CN113205400B - Financial accounting method, system and computer readable storage medium based on Amazon platform - Google Patents
Financial accounting method, system and computer readable storage medium based on Amazon platform Download PDFInfo
- Publication number
- CN113205400B CN113205400B CN202110580856.0A CN202110580856A CN113205400B CN 113205400 B CN113205400 B CN 113205400B CN 202110580856 A CN202110580856 A CN 202110580856A CN 113205400 B CN113205400 B CN 113205400B
- Authority
- CN
- China
- Prior art keywords
- information
- goods
- total
- cost
- determining
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 42
- XLYOFNOQVPJJNP-UHFFFAOYSA-N water Substances O XLYOFNOQVPJJNP-UHFFFAOYSA-N 0.000 claims abstract description 34
- 238000004590 computer program Methods 0.000 claims description 8
- 230000005484 gravity Effects 0.000 claims description 7
- 230000001737 promoting effect Effects 0.000 claims 2
- 238000007726 management method Methods 0.000 description 10
- 238000012549 training Methods 0.000 description 6
- 238000004422 calculation algorithm Methods 0.000 description 2
- 238000004364 calculation method Methods 0.000 description 2
- 238000004891 communication Methods 0.000 description 2
- 238000011161 development Methods 0.000 description 2
- 238000010586 diagram Methods 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 239000000463 material Substances 0.000 description 2
- 238000007637 random forest analysis Methods 0.000 description 2
- 230000000295 complement effect Effects 0.000 description 1
- 238000013523 data management Methods 0.000 description 1
- 238000013210 evaluation model Methods 0.000 description 1
- 238000001914 filtration Methods 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- 230000007246 mechanism Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 238000013439 planning Methods 0.000 description 1
- 238000012552 review Methods 0.000 description 1
- 238000012800 visualization Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/12—Accounting
- G06Q40/125—Finance or payroll
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/30—Information retrieval; Database structures therefor; File system structures therefor of unstructured textual data
- G06F16/33—Querying
- G06F16/3331—Query processing
- G06F16/3332—Query translation
- G06F16/3334—Selection or weighting of terms from queries, including natural language queries
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/186—Templates
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Business, Economics & Management (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Artificial Intelligence (AREA)
- Finance (AREA)
- Computational Linguistics (AREA)
- Accounting & Taxation (AREA)
- General Engineering & Computer Science (AREA)
- General Health & Medical Sciences (AREA)
- Health & Medical Sciences (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Development Economics (AREA)
- Economics (AREA)
- Marketing (AREA)
- Strategic Management (AREA)
- Technology Law (AREA)
- General Business, Economics & Management (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
The application relates to a financial accounting method, a system and a computer readable storage medium based on an Amazon platform, which comprises the steps of acquiring a total goods information set; wherein the total goods information set comprises running water batch information, goods quantity information and logistics cost information; determining logistics cost information corresponding to the running batch information according to the cargo quantity information and the logistics cost information; determining logistics cost information of the goods according to the flow batch information corresponding to the goods; and determining comprehensive cost information corresponding to the goods according to the logistics cost information of the goods. When accounting financial profit of goods in later period, can acquire the commodity circulation cost of single goods through the batch label of single goods to it is more accurate to make the comprehensive cost information that is the goods, more accurately accounts the commodity circulation cost of goods, makes the profit condition of goods more concrete true.
Description
Technical Field
The present application relates to the field of profit statement accounting technology, and in particular, to a financial accounting method, system and computer readable storage medium based on amazon platform.
Background
Cross-border e-commerce refers to an online transaction platform in which transaction subjects belonging to different borders reach transactions through an e-commerce platform and commodity is delivered through cross-border materials. With the development of internet technology application, a brand new development direction is provided for cross-border electronic commerce, more and more sellers enter amazon and other electronic commerce platforms, and in order to perform more refined operation and management on shops, many sellers use an ERP system (enterprise resource planning system). The ERP system is equivalent to an auxiliary management tool of an electronic store group, and has the functions of commodity management, financial data management, FBA management, purchase list management, warehouse management, logistics management, advertisement management, customer service management and the like.
A financial accounting method based on Amazon platform business disclosed in the Chinese invention patent application with the application publication number of CN111161040A in the prior art comprises the following steps: step 1: acquiring financial raw data from an Amazon platform; step 2: analyzing the format of the financial original data and storing the format in a server of a developer side; step 3: designing a financial accounting calculation formula conforming to Amazon business, and storing calculated data in a server of a developer side; step 4: and (3) displaying the financial data calculated in the step (3) in a chart form, and realizing the visualization of the financial data. According to the invention, the original financial statement data is automatically pulled through the Amazon API to replace manual downloading from the sellermenter; from the acquisition of the original data to the calculation, the cooperation among multiple departments is not needed, and the communication cost is reduced.
In view of the above technical solution, the present inventors believe that the existing ERP system generally uses a billing method to fix the cost of the commodity circulation of the stock goods, and uses a moving weighted average method to calculate the cost of the commodity circulation of the goods in the rest stock, so that it is difficult to accurately and truly reflect the cost of the commodity.
Disclosure of Invention
The first object of the application is to provide a financial accounting method based on an Amazon platform, which has the characteristic of reflecting the cost of goods more accurately and truly.
The first object of the present invention is achieved by the following technical solutions:
a financial accounting method based on an amazon platform, comprising:
acquiring a total goods information set; wherein the total goods information set comprises running water batch information, goods quantity information and logistics cost information; each goods is associated with a piece of running batch information, and the quantity information of the goods and the logistics cost information are respectively associated with the running batch information;
determining logistics cost information corresponding to the running batch information according to the cargo quantity information and the logistics cost information;
determining logistics cost information of the goods according to the flow batch information corresponding to the goods;
and determining comprehensive cost information corresponding to the goods according to the logistics cost information of the goods.
By adopting the technical scheme, after a lot of goods enter a warehouse through logistics transportation, all the goods in the lot have the same lot label, the lot label represents the running water lot information of the lot of goods, the quantity of the lot of goods is the quantity information of the goods, and the logistics cost of the lot of goods is the logistics cost information. And the logistics cost is allocated according to the quantity of the cargoes, so that the logistics cost of the single cargoes in the batch can be obtained, and the logistics cost information of each cargo can be obtained. When accounting financial profit of goods in later period, can acquire the commodity circulation cost of single goods through the batch label of single goods to it is more accurate to make the comprehensive cost information that is the goods, more accurately accounts the commodity circulation cost of goods, makes the profit condition of goods more concrete true.
Preferably, the specific method for determining logistics cost information of the goods according to the running water batch information corresponding to the goods includes:
generating a batch label bound with the goods; the batch label is used for indicating running water batch information associated with the goods;
and determining logistics cost information of the goods according to the batch labels bound by the goods.
By adopting the technical scheme, when the goods enter the warehouse, the batch label is generated according to the batch number of the logistics and is bound with the goods; the batch label can reflect the logistics batch number corresponding to the goods, and the running water batch information corresponding to the goods can be obtained by utilizing the batch label bound by the goods, so that the logistics cost information corresponding to the goods can be obtained.
Preferably, the total goods information set further includes total platform fee information and sales information; wherein the sales information includes single sales information corresponding to the goods and total sales information corresponding to sales units associated with the goods;
in the financial accounting method, further comprising:
determining apportionment specific gravity information corresponding to the goods according to the sales amount information and the total sales amount information of the single goods;
determining allocation cost information corresponding to the goods according to the total platform cost information and the allocation proportion information;
in a specific method of determining integrated cost information corresponding to a good based on logistics cost information of the good, the integrated cost information of the good is determined based on the logistics cost information and the allocation cost information.
By adopting the above technical solution, the total platform expense information is generally calculated for one total sales unit, and one sales unit contains a plurality of cargos or a plurality of cargos, so that the platform expense obtained from the total cargo information set serves the plurality of cargos. In order to be able to more truly account for the platform cost of a single good, the platform cost should be calculated to be shared among the plurality of goods it serves.
Preferably, the total platform fee information includes one or more of advertisement fee, promotion fee and warehouse fee.
By adopting the technical scheme, the total goods information set contains platform fees related to goods, such as advertising fees, popularization fees, storage fees and the like.
Preferably, in the specific method for acquiring the total cargo information, the method includes:
acquiring an interface data information set and an original financial statement set; the interface data information set can be obtained by pulling an api interface; the original financial statement collection can be obtained by means of automatic and/or manual downloading;
and generating a total goods information set according to the interface data information set and the original financial statement set.
By adopting the technical scheme, the total goods information set is obtained by combining the way of pulling the data by the api interface and the way of automatically and/or manually downloading the electronic report, so that the data information in the total goods information set is more comprehensive, and the calculated logistics cost and platform cost are more real.
Preferably, in the specific method for generating the total goods information set according to the interface data information set and the original financial statement set, the specific method comprises the following steps:
searching key information in the interface data information set based on the key word template, and determining a background key information set;
searching key information in the original financial report set based on the key word template, and determining a report key information set;
determining a total original information set and a repeated information set according to the background key information set and the report key information set;
and determining a total cargo information set according to the total original information set and the repeated information set.
By adopting the technical scheme, a user can preset a keyword template, wherein the keyword template comprises keywords related to information such as running water batch, logistics cost, logistics goods quantity, advertising cost, popularization cost, warehouse cost, commodity unit price, commodity sales, shop sales and the like, the keywords in the keyword template are searched in the interface data information set and the original financial statement set, and data information corresponding to the keywords is acquired, so that the data information of the keywords is acquired.
Preferably, the specific method for searching the key information in the original financial report set based on the key word template and determining the report key information set comprises the following steps:
translating the original financial statement set to generate an easy-to-read financial statement set;
and searching key information in the easy-to-read financial statement set based on the key word template, and determining a business key information set.
Through adopting above-mentioned technical scheme, when the sales of goods involves a plurality of countries, the language of each electronic report in original financial statement collection also can be different, consequently need translate original financial statement collection, generate easy-to-read financial statement collection, the user of facilitating the use directly reads this part financial statement.
The second purpose of the application is to provide a financial accounting system based on an Amazon platform, which has the characteristic of reflecting the cost of goods more accurately and truly.
The second object of the present invention is achieved by the following technical solutions:
the goods information acquisition module is used for acquiring a total goods information set; wherein the total goods information set comprises running water batch information, goods quantity information and logistics cost information; each goods is associated with a piece of running batch information, and the quantity information of the goods and the logistics cost information are respectively associated with the running batch information;
the logistics cost acquisition module is used for determining logistics cost information corresponding to the running water batch information according to the goods quantity information and the logistics cost information;
the logistics cost generation module is used for determining logistics cost information corresponding to the running water batch information according to the goods quantity information and the logistics cost information;
and the goods profit accounting module is used for determining comprehensive cost information corresponding to the goods according to the logistics cost information of the goods.
The third purpose of the application is to provide an intelligent terminal, which has the characteristic of reflecting the cost of goods more accurately and truly.
The third object of the present invention is achieved by the following technical solutions:
an intelligent terminal comprises a memory and a processor, wherein the memory stores a computer program which can be loaded by the processor and execute the financial accounting method based on the Amazon platform.
The fourth object of the present invention is to provide a computer storage medium capable of storing a corresponding program, and having a feature of reflecting cost of goods more accurately and truly.
The fourth object of the present invention is achieved by the following technical solutions:
a computer readable storage medium storing a computer program capable of being loaded by a processor and executing any one of the amazon-based financial accounting methods described above.
Drawings
FIG. 1 is a flow diagram of an Amazon platform-based financial accounting method of the present application.
FIG. 2 is a schematic flow chart of calculating logistics costs and platform costs in the Amazon platform-based financial accounting method of the present application.
FIG. 3 is a flow chart of generating a total cargo information set in the Amazon platform-based financial accounting method of the present application.
FIG. 4 is a block diagram of the Amazon platform-based financial accounting system of the present application.
In the figure, 1, a cargo information acquisition module; 2. a logistics cost acquisition module; 3. a logistics cost generation module; 4. a platform cost allocation module; 5. and a cargo profit accounting module.
Detailed Description
The goods transported across the border are usually transported by using a marine transportation mode, the transportation period of the goods before being stored in a warehouse is long, and the quantity of the goods transported in each batch may be different, so that the material flow cost of the goods in different batches may be greatly different. In actual sales, there may be multiple batches of goods in inventory, and the prices of these goods sold are substantially consistent, so that the profit of each goods is more difficult to calculate. In the related art, the ERP system generally adopts a billing mode to calculate the logistics cost of the goods by adopting a moving weighted average method after the goods are stored in the warehouse, but the logistics cost of the finally obtained goods is influenced by the logistics cost of the goods in other batches, so that the real profit situation of the single goods is difficult to be reflected, and the optimal management of funds is not facilitated.
For the purposes of making the objects, technical solutions and advantages of the embodiments of the present application more clear, the technical solutions of the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application, and it is apparent that the described embodiments are some embodiments of the present application, but not all embodiments. All other embodiments, which can be made by one of ordinary skill in the art based on the embodiments herein without making any inventive effort, are intended to be within the scope of the present application.
In addition, the term "and/or" herein is merely an association relationship describing an association object, and means that three relationships may exist, for example, a and/or B may mean: a exists alone, A and B exist together, and B exists alone. In this context, unless otherwise specified, the term "/" generally indicates that the associated object is an "or" relationship.
Embodiments of the present application are described in further detail below in conjunction with figures 1-4 of the specification.
Example 1
The embodiment of the application provides a financial accounting method based on an Amazon platform, and the main flow of the method is described as follows.
Referring to fig. 1, S01, a total cargo information set is acquired.
The total goods information set comprises information such as running water batch information, goods quantity information, logistics cost information and the like for accounting the logistics cost of goods in stock of each batch, and information such as platform cost information, sales amount information and the like for accounting the platform cost of each goods. The platform cost comprises advertising fees, popularization fees, warehouse fees and the like. The total goods information set is equivalent to the data base of the financial accounting method, and the logistics cost and the platform cost of the single goods can be determined through the total goods information set, so that the comprehensive cost of the goods can be calculated by combining other cost data, and the real profit of the goods can be calculated by combining sales data.
Referring to fig. 2, in a specific method of S01, it includes:
s011, acquiring an interface data information set.
The interface data information set is formed by pulling original data from a server by an api interface and storing the original data into a database or the server. In this embodiment, taking the amazon platform as an example, the interface data information set is formed by the raw data pulled by the amazon api, and the data related to the logistics, such as warehouse flow data, order data, inventory data, and the like, and part of the data related to advertising fees can be obtained through the data returned by the amazon api.
In this embodiment, the interface data information set includes running lot information, cargo quantity information and logistics cost information, where the running lot information refers to a lot number of cargo transportation, and the cargo quantity information and the logistics cost information are both associated with the running lot information; by combining the running water batch information, the cargo quantity information and the logistics cost information, the cargo quantity transported in the cargo logistics transportation of a certain batch and the cost generated by the cargo logistics transportation of the batch can be determined, and further the logistics cost of single cargoes in the batch can be calculated.
S012, acquiring an original financial statement set.
The original financial statement set comprises a plurality of electronic forms recorded with financial data information, wherein the financial data information comprises financial data such as commodity unit price, commodity sales amount, commodity discount and the like based on single goods, and financial data such as store sales amount, store advertising fee and the like based on sales units such as stores. The electronic forms in the original financial statement set can be obtained from the Amazon client side in a manual downloading or automatic downloading mode; in this embodiment, the system obtains the original financial statement collection by means of timed automatic download.
And S013, generating a total goods information set according to the interface data information set and the original financial statement set.
The interface data information set and the original financial statement set contain a plurality of original data information, and key data information, namely key information, needs to be screened from the data information to form a total goods information set so as to calculate the logistics cost and the platform cost of goods.
In this embodiment, the user may preset a keyword template, where the keyword template includes keywords related to information such as running lot, logistics cost, logistics cargo quantity, advertising cost, popularization cost, warehouse cost, commodity price, commodity sales, store sales, etc., and the data information corresponding to the keywords is obtained by searching keywords in the keyword template in the interface data information set and the original financial statement set, and further obtaining the data information of the keywords. Specifically, the keyword templates may be divided into an interface keyword template corresponding to the interface data information set and a report keyword template corresponding to the original financial report set.
In a specific method of S013, comprising:
and S0131, searching key information in the interface data information set based on the interface key word template, and determining a background key information set.
The interface keyword templates comprise keywords related to information such as running water batches, logistics cost, logistics cargo quantity, advertising cost and the like, and the interface keyword templates are used for searching and extracting the interface data information set, so that a background keyword information set comprising the running water batch information, the logistics cost information, the logistics cargo quantity information and part of advertising cost information is generated.
S0132, searching key information in the original financial report set based on the report keyword template, and determining a report key information set.
The report keyword template comprises keywords related to commodity unit price, commodity sales, store sales, warehouse fees, popularization fees, advertising fees and the like, and the interface keyword template is used for searching and extracting the interface data information set so as to generate a report keyword information set comprising commodity unit price information, commodity sales information, store sales information, warehouse fees information, popularization fees information and part of advertising fees information.
Referring to fig. 3, in a specific method of S0132, it includes:
s01321, translating the original financial statement set to generate the readable financial statement set.
When goods are sold in a plurality of countries, languages of all electronic reports in the original financial report set are different, so that the original financial report set is required to be translated, and an easy-to-read financial report set is generated.
S01322, searching key information in the easy-to-read financial statement set based on the statement keyword template, and determining a business key information set.
And searching and extracting key information in the readable financial statement set by using the key word template to generate a business key information set. In this embodiment, the names of the items in the background key information set and the names of the items in the business key information set are both mainly in chinese, so that domestic users can conveniently review the information.
S0133, determining a total original information set and a repeated information set according to the background key information set and the report key information set.
The total original information set is a total set containing a background key information set and a report key information set. Because the interface data information set and the original financial statement set both contain advertisement cost information, part of the information in the two parts of advertisement cost information may be repeated, and in order to make the advertisement cost of goods more accurate, the repeated part of advertisement cost needs to be removed from the total original information set.
In this embodiment, the repeated information set includes advertising fee information that is repeated with the original financial statement set in the interface data information set. In other embodiments, the repeated information set may also be advertisement fee information that is included in the original financial statement set and that is repeated with the interface data information set.
S0134, determining a total cargo information set according to the total original information set and the repeated information set.
And removing the repeated information set from the total original information set, namely taking the complement of the repeated information set in the total original information set, so as to obtain the total goods information set.
Referring to fig. 2, S02, logistics cost information of the goods is determined according to the total goods information set.
The logistics cost of the goods can be calculated by using logistics information related to the goods in the total goods information set.
S021, determining logistics cost information corresponding to the running water batch information according to the goods quantity information and the logistics cost information.
The running water batch information may reflect the batch number of the logistics transportation of a certain batch, the cargo quantity information may reflect how many cargoes are in the logistics transportation of the batch, and the logistics cost information may reflect the total cost generated by the logistics transportation of the batch. The total cost of the logistics is divided by the number of cargoes, so that the logistics cost of the single cargoes corresponding to the batch number can be obtained.
For different running water batch information, the corresponding cargo quantity information and logistics cost information are also different, so that the calculated logistics cost information is also different. The logistics cost information may be different between goods corresponding to different running water batch information, and the logistics cost information may be the same between goods corresponding to the same running water batch information.
S022, determining logistics cost information of the goods according to the flow batch information corresponding to the goods.
Wherein, by determining the logistics cost information corresponding to the running water batch information of the goods, the logistics cost information of the goods can be determined.
Referring to fig. 3, in a specific method of S022, it includes:
s0221, generating a batch label bound with the goods.
When the goods enter the warehouse, the batch label is generated according to the batch number of the logistics and is bound with the goods. Each cargo corresponds to a batch label, and the batch label can reflect the logistics batch number corresponding to the cargo, and further reflect the running water batch information associated with the cargo.
S0222, determining logistics cost information of goods bound by the batch label according to the running water batch information associated with the batch label.
The batch label bound by the goods can be used for acquiring the running water batch information corresponding to the goods, and further the logistics cost information corresponding to the goods can be acquired.
According to the embodiment, the batch labels are bound when the cargoes enter the warehouse, and the cost of the cargoes can be calculated in a first-in first-out mode according to the mode that the logistics cost is obtained by the batch labels, so that the inventory value condition and profit condition of each batch of cargoes can be reflected more truly.
Referring to fig. 2, S03, allocation cost information of the goods is determined according to the total goods information set.
The platform fees, such as advertising fees, promotion fees, warehouse fees, etc., related to the goods in the total goods information set are all calculated for one total sales unit. The sales unit comprises an asin (a commodity identification code automatically generated by the Amazon platform according to the general product code), a shop and the like, and a plurality of cargoes or a plurality of cargoes are contained in one sales unit. Thus, the platform cost derived from the aggregate cargo information set is that of serving a plurality of cargoes, which should be amortized to calculate in order to be able to more truly account for the platform cost of a single cargo. Hereinafter, the sales unit is described by taking a store as an example.
In a specific method of S03, comprising:
s031, according to the sales information of the single goods and the total sales information, the allocation proportion information corresponding to the goods is determined.
Wherein, the sales information of the single goods is aimed at the single goods, and refers to sales of the single goods; the total sales information is specific to the sales unit and refers to the total sales of the sales unit in which the goods are located; the split specific gravity information is a ratio between sales of the individual goods and total sales of the sales units.
S032, determining the allocation cost information corresponding to the goods according to the total platform cost information and the allocation proportion information.
The allocation proportion information can reflect the proportion of the sales of the goods in the total sales, and reflect the importance of the platform service to the sales of the goods; the larger the ratio of the sales of the goods is, the larger the service and support of the goods by the platform cost are, and the larger the cost of the platform cost is allocated; the smaller the ratio of the sales of the goods, the smaller the service and support of the goods by the platform fees are, and the smaller the cost of the platform fees allocated is, so that the total platform fees can be allocated by using the allocation proportion information, and the cost of the corresponding goods after being allocated can be calculated. In this embodiment, the cost of the goods for allocation can be obtained by multiplying the total platform cost by the allocated specific gravity.
S04, determining comprehensive cost information of the goods according to the logistics cost information and the allocation cost information.
The logistics cost and the platform cost of the single goods can be determined by combining the logistics cost information and the allocation cost information, and the comprehensive cost of the goods can be calculated by combining other cost data. After the comprehensive cost information of the single goods is obtained, the true profit of the goods can be calculated by combining the sales data of the goods.
It is worth noting that in the embodiment of the present application, the logistics cost and the platform cost of a single cargo are obtained, the cost data in these dimensions are used as a basis, and in combination with the data information in other dimensions, such as sales cycle, cargo discount, cargo sales volume, cargo refund, etc., a user can obtain enough data for this type of cargo as training data samples, substitute the training data samples into a random forest model for training, and model the training data samples by adopting a random forest algorithm to construct an evaluation model for this type of cargo, so as to evaluate the financial health degree related to the cargo, and help the user analyze operation decisions.
The implementation principle of the first embodiment of the application is as follows: for goods sold across the border, the logistic cost generated by goods in different batches of warehoused may be quite different, and if the logistic cost of the goods is calculated by using a moving weighted average method, the logistic cost calculated by the goods and the actual cost may be quite different, and the profit calculated by the user through the logistic cost is not accurate. According to the embodiment, the batch labels are bound when the goods enter the warehouse, so that the running water batch of the goods can be traced, and the logistics cost generated by the goods transportation corresponding to each running water batch is calculated; when the logistics cost of the goods is calculated, the logistics cost of the single goods in the corresponding batch is directly found through the batch label of the goods, so that the logistics cost of the single goods is more real and reliable.
Platform fees generated by goods, such as advertising fees, promotion fees, warehouse fees and the like, are fees for asin or shops in the Amazon background, the asin or the shops usually serve a plurality of goods, and therefore, the cost of single goods is difficult to directly realize, and the platform fees need to be reasonably shared. According to the method, the system and the equipment, the cost of the goods after being distributed is obtained by calculating the ratio of the sales amount of the goods in the total sales amount and utilizing the ratio to distribute the cost of the platform, so that the platform cost of the single goods is obtained, and a user can conveniently calculate the profit situation of the single goods.
According to the method and the device for acquiring the electronic report, the total goods information set is acquired by combining the data pulling mode of the api interface and the automatic and/or manual electronic report downloading mode, so that the data information in the total goods information set is more comprehensive, and further the calculated logistics cost and platform cost are more real. On the other hand, by means of translating the original financial statement set and extracting the keywords, a user can more intuitively check the key data information on the electronic statement, and the user can easily acquire corresponding data without further knowing familiarity with Amazon business or learning multinational languages, so that labor cost and communication cost are reduced.
Embodiment two:
referring to fig. 4, in one embodiment, there is provided an amazon platform-based financial accounting system, which corresponds to the amazon platform-based financial accounting method in the above embodiment one by one, and includes a cargo information acquisition module 1, a logistics cost acquisition module 2, a logistics cost generation module 3, a platform cost allocation module 4, and a cargo profit accounting module 5. The functional modules are described in detail as follows:
the goods information acquisition module 1 is used for acquiring a total goods information set; the total goods information set comprises running water batch information, goods quantity information, logistics cost information, single goods sales information and total sales information; each goods is associated with a piece of running batch information, and the quantity information of the goods and the logistics cost information are respectively associated with the running batch information;
a logistics cost acquisition module 2 for determining logistics cost information corresponding to the running lot information according to the goods quantity information and the logistics cost information;
a logistics cost generation module 3 for determining logistics cost information corresponding to the running lot information based on the goods quantity information and the logistics cost information;
the platform cost allocation module 4 is used for determining the allocation cost information of the goods according to the sales amount information and the total sales amount information of the single goods;
and the goods profit accounting module 5 determines comprehensive cost information of the goods according to the logistics cost information and the allocation cost information.
Embodiment III:
in one embodiment, a smart terminal is provided that includes a memory, a processor, and a computer program stored on and executable on the memory, wherein the memory stores training data, algorithm formulas, filtering mechanisms, and the like in a training model. The processor is configured to provide computing and control capabilities, and when executing the computer program, the processor performs the steps of:
s01, acquiring a total goods information set.
S011, acquiring an interface data information set.
S012, acquiring an original financial statement set.
And S013, generating a total goods information set according to the interface data information set and the original financial statement set.
And S0131, searching key information in the interface data information set based on the interface key word template, and determining a background key information set.
S0132, searching key information in the original financial report set based on the report keyword template, and determining a report key information set.
S01321, translating the original financial statement set to generate the readable financial statement set.
S01322, searching key information in the easy-to-read financial statement set based on the statement keyword template, and determining a business key information set.
S0133, determining a total original information set and a repeated information set according to the background key information set and the report key information set.
S0134, determining a total cargo information set according to the total original information set and the repeated information set.
S02, determining logistics cost information of the goods according to the total goods information set.
S021, determining logistics cost information corresponding to the running water batch information according to the goods quantity information and the logistics cost information.
S022, determining logistics cost information of the goods according to the flow batch information corresponding to the goods.
S0221, generating a batch label bound with the goods.
S0222, determining logistics cost information of goods bound by the batch label according to the running water batch information associated with the batch label.
S03, determining the allocation cost information of the goods according to the total goods information set.
S031, according to the sales information of the single goods and the total sales information, the allocation proportion information corresponding to the goods is determined.
S032, determining the allocation cost information corresponding to the goods according to the total platform cost information and the allocation proportion information.
S04, determining comprehensive cost information of the goods according to the logistics cost information and the allocation cost information.
Embodiment four:
in one embodiment, a computer readable storage medium is provided storing a computer program capable of being loaded by a processor and executing the above-described financial accounting method, the computer program when executed by the processor implementing the steps of:
s01, acquiring a total goods information set.
S011, acquiring an interface data information set.
S012, acquiring an original financial statement set.
And S013, generating a total goods information set according to the interface data information set and the original financial statement set.
And S0131, searching key information in the interface data information set based on the interface key word template, and determining a background key information set.
S0132, searching key information in the original financial report set based on the report keyword template, and determining a report key information set.
S01321, translating the original financial statement set to generate the readable financial statement set.
S01322, searching key information in the easy-to-read financial statement set based on the statement keyword template, and determining a business key information set.
S0133, determining a total original information set and a repeated information set according to the background key information set and the report key information set.
S0134, determining a total cargo information set according to the total original information set and the repeated information set.
S02, determining logistics cost information of the goods according to the total goods information set.
S021, determining logistics cost information corresponding to the running water batch information according to the goods quantity information and the logistics cost information.
S022, determining logistics cost information of the goods according to the flow batch information corresponding to the goods.
S0221, generating a batch label bound with the goods.
S0222, determining logistics cost information of goods bound by the batch label according to the running water batch information associated with the batch label.
S03, determining the allocation cost information of the goods according to the total goods information set.
S031, according to the sales information of the single goods and the total sales information, the allocation proportion information corresponding to the goods is determined.
S032, determining the allocation cost information corresponding to the goods according to the total platform cost information and the allocation proportion information.
S04, determining comprehensive cost information of the goods according to the logistics cost information and the allocation cost information.
The computer-readable storage medium includes, for example: a U-disk, a removable hard disk, a Read-Only Memory (ROM), a random access Memory (Random Access Memory, RAM), a magnetic disk, or an optical disk, or other various media capable of storing program codes.
The embodiments of the present invention are all preferred embodiments of the present application, and are not intended to limit the scope of the present application in this way, therefore: all equivalent changes in structure, shape and principle of this application should be covered in the protection scope of this application.
Claims (7)
1. A financial accounting method based on an amazon platform, comprising:
acquiring a total goods information set; the total goods information set comprises running water batch information, goods quantity information, logistics cost information, total platform cost information and sales amount information; wherein the total platform fee information comprises one or more of advertising fees, promotional fees and warehouse fees, and the sales amount information comprises single-item sales amount information corresponding to the goods and total sales amount information corresponding to sales units associated with the goods; each item is associated with a running batch information, and the item quantity information and the logistics cost information are respectively associated with the running batch information;
determining logistics cost information corresponding to the running lot information according to the goods quantity information and the logistics cost information;
generating a batch label bound with a cargo phase, wherein the batch label is used for indicating running water batch information associated with the cargo, and determining logistics cost information of the cargo according to the batch label bound with the cargo;
determining apportioned specific gravity information corresponding to the goods according to the individual sales information and the total sales information;
determining, from the total platform fee information and the split specific gravity information, split cost information corresponding to the goods;
and determining comprehensive cost information of the goods according to the logistics cost information and the allocation cost information.
2. The method of claim 1, wherein the acquiring a set of total cargo information comprises:
acquiring an interface data information set and an original financial statement set; the interface data information set can be obtained by pulling an api interface; the original financial statement set can be obtained by means of automatic and/or manual downloading;
and generating the total goods information set according to the interface data information set and the original financial statement set.
3. The method of claim 2, wherein generating the aggregate cargo information set from the interface data information set and the original financial statement set comprises:
searching key information in the interface data information set based on a key word template, and determining a background key information set;
searching key information in the original financial report set based on the key word template, and determining a report key information set;
determining a total original information set and a repeated information set according to the background key information set and the report key information set;
and determining the total cargo information set according to the total original information set and the repeated information set.
4. A method according to claim 3, wherein said searching for key information in the original set of financial reports based on the keyword templates, determining the set of report key information comprises:
translating the original financial statement set to generate an easy-to-read financial statement set;
and searching key information in the readable financial report set based on the key word template, and determining the report key information set.
5. A financial accounting system based on an amazon platform, comprising:
the goods information acquisition module (1) is used for acquiring a total goods information set; the total goods information set comprises running water batch information, goods quantity information, logistics cost information, total platform cost information and sales amount information; wherein the total platform fee information comprises one or more of advertising fees, promotional fees and warehouse fees, and the sales amount information comprises single-item sales amount information corresponding to the goods and total sales amount information corresponding to sales units associated with the goods; each item is associated with a running batch information, and the item quantity information and the logistics cost information are respectively associated with the running batch information;
a logistics cost acquisition module (2) for determining logistics cost information corresponding to the running lot information according to the goods quantity information and the logistics cost information;
the logistics cost generation module (3) is used for generating a batch label bound with a goods, wherein the batch label is used for indicating running water batch information associated with the goods, and determining logistics cost information of the goods according to the batch label bound with the goods;
a platform cost allocation module (4) for determining allocation specific gravity information corresponding to the goods according to the single-product sales amount information and the total sales amount information, and determining allocation cost information corresponding to the goods according to the total platform cost information and the allocation specific gravity information;
and the goods profit accounting module (5) is used for determining comprehensive cost information of the goods according to the logistics cost information and the allocation cost information.
6. An intelligent terminal comprising a memory and a processor, said memory having stored thereon a computer program capable of being loaded by the processor and executing the method according to any of claims 1 to 4.
7. A computer readable storage medium, characterized in that a computer program is stored which can be loaded by a processor and which performs the method according to any of claims 1 to 4.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202110580856.0A CN113205400B (en) | 2021-05-26 | 2021-05-26 | Financial accounting method, system and computer readable storage medium based on Amazon platform |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202110580856.0A CN113205400B (en) | 2021-05-26 | 2021-05-26 | Financial accounting method, system and computer readable storage medium based on Amazon platform |
Publications (2)
Publication Number | Publication Date |
---|---|
CN113205400A CN113205400A (en) | 2021-08-03 |
CN113205400B true CN113205400B (en) | 2024-03-01 |
Family
ID=77023672
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN202110580856.0A Active CN113205400B (en) | 2021-05-26 | 2021-05-26 | Financial accounting method, system and computer readable storage medium based on Amazon platform |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN113205400B (en) |
Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN107909325A (en) * | 2017-11-24 | 2018-04-13 | 九州通医药集团物流有限公司 | The accounting method that becomes more meticulous based on Medicine Enterprises Logistics cost |
CN109461015A (en) * | 2017-10-27 | 2019-03-12 | 江门市链程科技有限公司 | A kind of method and system for sharing and calculate automatically international logistics kinds of goods freight charges unit price |
CN111161040A (en) * | 2019-12-31 | 2020-05-15 | 深圳市恺誉科技有限公司 | Financial accounting method based on amazon platform service |
KR102113128B1 (en) * | 2019-12-17 | 2020-05-20 | 이미연 | Selling platform server for counting goods sales quantaties per seller on influencer marketing platform and operating method of selling platform server |
CN111325539A (en) * | 2020-03-03 | 2020-06-23 | 舟谱数据技术南京有限公司 | Cost and income allocation analysis system based on unified warehouse co-allocation operation mode |
-
2021
- 2021-05-26 CN CN202110580856.0A patent/CN113205400B/en active Active
Patent Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN109461015A (en) * | 2017-10-27 | 2019-03-12 | 江门市链程科技有限公司 | A kind of method and system for sharing and calculate automatically international logistics kinds of goods freight charges unit price |
CN107909325A (en) * | 2017-11-24 | 2018-04-13 | 九州通医药集团物流有限公司 | The accounting method that becomes more meticulous based on Medicine Enterprises Logistics cost |
KR102113128B1 (en) * | 2019-12-17 | 2020-05-20 | 이미연 | Selling platform server for counting goods sales quantaties per seller on influencer marketing platform and operating method of selling platform server |
CN111161040A (en) * | 2019-12-31 | 2020-05-15 | 深圳市恺誉科技有限公司 | Financial accounting method based on amazon platform service |
CN111325539A (en) * | 2020-03-03 | 2020-06-23 | 舟谱数据技术南京有限公司 | Cost and income allocation analysis system based on unified warehouse co-allocation operation mode |
Also Published As
Publication number | Publication date |
---|---|
CN113205400A (en) | 2021-08-03 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US20200065750A1 (en) | Inventory management system and method thereof | |
US9646286B2 (en) | System and method for automated retail product accounting | |
US7818342B2 (en) | Tracking usage of data elements in electronic business communications | |
US9129276B1 (en) | Inventory management | |
US11544653B2 (en) | System and method for improving product catalog representations based on product catalog adherence scores | |
CN108932655A (en) | A kind of farm produce sale management method Internet-based and system | |
Manetti | How technology is transforming manufacturing | |
US20050119900A1 (en) | Purchasing optimization system | |
CA3052582A1 (en) | System and method for improved inventory management of returned retail items | |
CN107507052B (en) | Quotation information acquisition method and device | |
CN116579804A (en) | Holiday commodity sales prediction method, holiday commodity sales prediction device and computer storage medium | |
US20080195527A1 (en) | Method and Apparatus for the Lending of Monetary Funds While Taking Collectibles as Collateral | |
CN113205400B (en) | Financial accounting method, system and computer readable storage medium based on Amazon platform | |
CN113139768A (en) | Goods shortage monitoring method based on unmanned vending machine | |
CN107341632A (en) | A kind of data capture method and device based on user's request | |
CN116595390A (en) | Commodity information processing method and electronic equipment | |
KR102394221B1 (en) | online vedor operating platform | |
Rabe et al. | Lean management accounting, elimination of waste in the company | |
CN112685441A (en) | Metadata-based content asset management method and system | |
CN113706254A (en) | Online material management method, device and equipment based on bill and storage medium | |
CN109948130B (en) | Method for intelligently filling value-added tax invoice commodity details | |
Su et al. | Profitability evaluation for newsboy-type product with normally distributed demand | |
CN114298776A (en) | Invoice issuing method and device, storage medium and computer equipment | |
Siganul et al. | An Exploratory Study on the Usage of Technology among Retailers in Labuan, Malaysia | |
Khairi et al. | Real-time tracking and category filtering of an automated system for trading cards collections |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
CB02 | Change of applicant information | ||
CB02 | Change of applicant information |
Address after: 518051 Building 1, Block C, Section 1, Chuangzhi Yuncheng, Liuxian Avenue, Xili Community, Xili Street, Nanshan District, Shenzhen City, Guangdong Province, China 3601 Applicant after: Shenzhen Lingxing Network Technology Co.,Ltd. Address before: 518000 2101-2104, block C, building 1, Chuangzhi Yuncheng bid section 1, Liuxian Avenue, Xili community, Xili street, Nanshan District, Shenzhen City, Guangdong Province Applicant before: Shenzhen Lingxing Network Technology Co.,Ltd. |
|
GR01 | Patent grant | ||
GR01 | Patent grant |