Account reconciliation method, device, system, storage medium and program product
By periodically acquiring order information to generate summary documents and automating accounting and inventory reconciliation, the problem of low reconciliation efficiency on e-commerce platforms has been solved. This achieves consistent verification of orders, accounts receivable, and goods, reducing the amount of manual verification and improving management efficiency and accuracy.
Patent Information
- Application Number
- CN202410977938.2
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2024-07-22
- Publication Date
- 2024-11-22
- Estimated Expiration
- 2044-07-22
AI Technical Summary
E-commerce platforms suffer from low reconciliation efficiency and a large amount of manual verification. The relatively separate management of order inbound/outbound and accounts receivable leads to low management efficiency.
By periodically acquiring order information, generating summary documents and verifying product inventory, and combining them with accounting details to generate reconciliation statements, the computer system is used to automate accounting and inventory verification, and a rolling reconciliation mechanism is introduced to identify expense expenditures and payment details.
It enables consistency verification of orders, accounts receivable, and goods, reduces manual verification, improves reconciliation efficiency, ensures the accuracy of accounting and inventory data, reduces human error, and supports the automation and forecasting of expense management.
Smart Images

Figure CN118537153B_ABST
Abstract
Description
Technical Field
[0001] The present application relates to the technical field of account reconciliation management, and in particular to an account reconciliation method, device, system, storage medium and program product. Background Art
[0002] At present, the reconciliation of e-commerce business of enterprises is mainly divided into account reconciliation and inventory reconciliation. Account reconciliation mainly checks accounts receivable, actual accounts receivable, invoice-invoiced expenses, invoice-uninvoiced expenses, etc. Inventory reconciliation mainly checks the quantity to be shipped, the actual quantity shipped, the quantity to be returned, the actual quantity returned, etc. In the order management of existing e-commerce platforms, order in and out of the warehouse and accounts receivable are relatively separated, resulting in low overall reconciliation efficiency and huge manual reconciliation. Summary of the invention
[0003] The embodiments of the present application provide a reconciliation method, device, system, storage medium and program product, which solve the problems of low reconciliation efficiency and large amount of manual verification on existing e-commerce platforms.
[0004] In a first aspect, to achieve the above-mentioned purpose, an embodiment of the present application provides a reconciliation method, comprising:
[0005] According to the first time length, periodically obtain order information, wherein the order information includes sales order information and after-sales order information of the e-commerce platform, and return order information of the warehouse;
[0006] According to the order information obtained each time, a summary document corresponding to the order information obtained this time is generated; wherein the summary document includes a summary document of a product dimension and a summary document of a verification subject dimension, and the verification subject includes an e-commerce platform and / or an e-commerce store;
[0007] The first outbound data of each type of product in the summary document of the product dimension is checked with the second outbound data of the corresponding type of product in the warehouse management system, and the first inbound data of each type of product is checked with the second inbound data of the corresponding type of product in the warehouse management system;
[0008] For each checking subject, generating a statement of the checking subject according to the pre-configured expense item fields and the account details of the checking subject within a second time length; wherein the second time length includes at least one of the first time lengths;
[0009] According to the summary document of the verification subject dimension and the reconciliation statement, the accounts of each order of the verification subject are checked.
[0010] Optionally, generating a statement of account for the verification subject according to the pre-configured expense item fields and the account details of the verification subject within the second time period includes:
[0011] For each order of the checking subject, matching the data in the account details with the expense item fields to obtain the data of each expense item field;
[0012] The statement is generated based on the matched data of the expense item fields of each of the orders.
[0013] Optionally, before performing account verification on each order of the verification subject according to the summary document of the verification subject dimension and the reconciliation statement, the method further includes:
[0014] Determine the order status of the order to be checked; wherein the order status includes a completed new order status, a checked but uncompleted order status, or an unchecked order status;
[0015] The performing of account verification on each order of the verification subject according to the summary document of the verification subject dimension and the reconciliation statement includes:
[0016] When the order status is a verified but uncompleted state or an unverified state, the account verification is performed on the order to be verified according to the summary document of the verification subject dimension and the statement.
[0017] Optionally, performing account verification on the order to be verified according to the summary document of the verification subject dimension and the statement of account, includes:
[0018] In the statement, extract the data of the expense item field of the order to be checked;
[0019] Calculate the actual amount of the order to be checked based on the extracted data of the expense item field of the order to be checked;
[0020] In the summary document of the verification subject dimension, the receivable amount of the order to be verified is obtained;
[0021] The order to be checked is checked based on the actually collected amount, the receivable amount and a pre-configured difference threshold.
[0022] Optionally, performing account verification on the order to be verified according to the actually collected amount, the receivable amount and a pre-configured difference threshold includes:
[0023] Calculate the difference between the receivable amount and the actual amount received;
[0024] When the absolute value of the difference is less than or equal to the difference threshold, it is determined that the order to be checked is completed and the check result is successful;
[0025] When the absolute value of the difference is greater than the difference threshold, the order to be checked is checked according to a pre-configured rolling check number and the difference.
[0026] Optionally, when the absolute value of the difference is greater than the difference threshold, performing account reconciliation on the order to be reconciled according to a preconfigured rolling reconciliation number and the difference, including:
[0027] When the number of reconciliations of the order to be checked is less than the rolling number of reconciliations, determining that the order to be checked has not been checked, and updating the number of reconciliations and the reconciled amount of the order to be checked;
[0028] Alternatively, when the number of reconciliations of the order is equal to the number of rolling reconciliations, it is determined that the order to be reconciled has completed reconciliation, and the reconciliation result is reconciliation failure.
[0029] Optionally, after performing account verification on each order of the verification subject according to the summary document of the verification subject dimension and the reconciliation statement, the method further comprises at least one of the following steps:
[0030] If the verification result is successful, create an expense reimbursement form for the order corresponding to the verification result;
[0031] When the verification result is a verification failure, a prompt message of the verification failure is output, and / or a sales document and a return document are created, wherein the sales document and the return document are used to adjust the accounting data of the order corresponding to the verification result.
[0032] Optionally, the method further comprises:
[0033] When the order status is the completed new order status, a sales document and a return document for adjusting the account data of the order to be checked are created according to the data related to the order to be checked in the statement.
[0034] Optionally, the method further comprises:
[0035] Determine the ratio between the amount of expenditure of the verification subject and the amount actually received for the order of the verification subject according to the reconciliation statement;
[0036] According to the proportional relationship, the sales performance of the verification subject and / or the expense expenditure of the verification subject are predicted.
[0037] In a second aspect, in order to achieve the above-mentioned purpose, an embodiment of the present application provides a reconciliation device, comprising:
[0038] An order acquisition module, used to periodically acquire order information according to a first time length, wherein the order information includes sales order information and after-sales order information of the e-commerce platform, and return order information of the warehouse;
[0039] A summary document generation module, configured to generate a summary document corresponding to the order information obtained this time according to the order information obtained each time; wherein the summary document includes a summary document of a product dimension and a summary document of a verification subject dimension, and the verification subject includes an e-commerce platform and / or an e-commerce store;
[0040] An inventory checking module, used to check the first outbound data of each type of product in the summary document of the product dimension with the second outbound data of the corresponding type of product in the warehouse management system, and to check the first inbound data of each type of product with the second inbound data of the corresponding type of product in the warehouse management system;
[0041] A statement generation module, for generating a statement of each checking subject according to a pre-configured expense item field and the account details of the checking subject within a second time length, wherein the second time length includes a plurality of the first time lengths;
[0042] The reconciliation module is used to perform account reconciliation on each order of the reconciliation subject according to the summary document of the reconciliation subject dimension and the reconciliation statement.
[0043] In the third aspect, in order to achieve the above-mentioned purpose, an embodiment of the present application provides a reconciliation system, including a transceiver, a memory, a processor, and a computer program stored in the memory and running on the processor, and when the processor executes the computer program, it implements the reconciliation method described in the first aspect.
[0044] In a fifth aspect, in order to achieve the above-mentioned purpose, an embodiment of the present application provides a readable storage medium on which a program or instruction is stored, and when the program or instruction is executed by a processor, the reconciliation method as described in the first aspect is implemented.
[0045] In a sixth aspect, in order to achieve the above-mentioned purpose, an embodiment of the present application provides a computer program product on which a program or instruction is stored, and when the program or instruction is executed by a processor, the reconciliation method as described in the first aspect is implemented.
[0046] The beneficial effects of the above technical solution of the present application are as follows:
[0047] The reconciliation method of the embodiment of the present application firstly obtains order information periodically according to a first time length, wherein the order information includes sales order information and after-sales order information of the e-commerce platform, and return order information of the warehouse; secondly, generates a summary document corresponding to the order information obtained this time according to the order information obtained each time; wherein the summary document includes a summary document of a product dimension and a summary document of a verification subject dimension, wherein the verification subject includes an e-commerce platform and / or an e-commerce store; here, by using the summary document of the product dimension to verify the product inventory, it is possible to realize daily verification of the product inventory from the order dimension, thereby solving the problems of slow manual review and low efficiency of inventory management; Thirdly, the first outbound data of each type of product in the summary document of the product dimension is checked with the second outbound data of the corresponding type of product in the warehouse management system, and the first inbound data of each type of product is checked with the second inbound data of the corresponding type of product in the warehouse management system; then, for each verification subject, a statement of account is generated according to the pre-configured expense item field and the account details of the verification subject within the second time length; wherein the second time length includes at least one of the first time lengths; finally, according to the summary document of the verification subject dimension and the statement of account, each order of the verification subject is checked for account. In this way, account checking and inventory checking can be realized in one system, which solves the problem of relative separation of order inbound and outbound and accounts receivable in the existing e-commerce platform order management, realizes the consistency of order-account receivable-goods proofreading, that is, realizes the account receivable and goods income checking of the order dimension, so that the manual checking amount can be reduced and the reconciliation efficiency can be improved. BRIEF DESCRIPTION OF THE DRAWINGS
[0048] Figure 1 A flowchart of a reconciliation method according to an embodiment of the present application;
[0049] Figure 2 This is one of the schematic diagrams of the configuration page of the expense item field in the embodiment of the present application;
[0050] Figure 3 This is a second schematic diagram of a configuration page for the expense item field in an embodiment of the present application;
[0051] Figure 4 A schematic diagram of a configuration page for the reconciliation difference amount and the rolling reconciliation times in an embodiment of the present application;
[0052] Figure 5 A schematic diagram of sales order information in an embodiment of the present application;
[0053] Figure 6 A schematic diagram of a summary document of product dimensions in an embodiment of the present application;
[0054] Figure 7 A schematic diagram of a summary document of the verification subject dimension in an embodiment of the present application;
[0055] Figure 8 This is one of the page diagrams of the statement in the embodiment of the present application;
[0056] Fig. 9 This is a second schematic diagram of a page of a statement in an embodiment of the present application;
[0057] Fig.10 A schematic diagram of a page showing the reconciliation results in an embodiment of the present application;
[0058] Fig.11 This is a schematic diagram of the accounting details in the embodiment of this application;
[0059] Fig.12 for Fig.11 A schematic diagram of a page for business description in;
[0060] Fig.13 A schematic diagram of the structure of the account reconciliation device according to an embodiment of the present application;
[0061] Fig.14 A schematic diagram of a reconciliation system according to an embodiment of the present application. DETAILED DESCRIPTION
[0062] In order to make the technical problems, technical solutions and advantages to be solved by the present application clearer, a detailed description will be given below with reference to the accompanying drawings and specific embodiments.
[0063] The embodiment of the present application provides a reconciliation method, such as Figure 1 As shown, the method includes:
[0064] Step 101, periodically obtain order information according to a first time length, the order information includes the sales order information and after-sales order information of the e-commerce platform, and the return order information of the warehouse; here, the first time length can be a natural day, for example, this step can obtain the sales order information and after-sales order information of the e-commerce platform on that day, as well as the return order information of the warehouse at 17:00 on each natural day. Specifically, the sales order information and after-sales order information can be obtained from the background of the e-commerce platform, and the return order information can be obtained from the warehouse management system (WMS); or, the order information can be obtained from the order center; wherein, the sales order information such as Figure 5 As shown, it may include delivery information (delivery address, consignee information, etc.), orderer information (membership code, member name, contact information, etc. of the orderer) and product information (product name, order product number, order quantity, original order amount, actual order amount, etc.);
[0065] Step 102, generating a summary document corresponding to the order information obtained this time according to the order information obtained each time; wherein the summary document includes a summary document of product dimension and a summary document of verification subject dimension, the summary document of product dimension includes summary data of each type of product (for example, outbound data, inbound data, order data, order amount, etc. of each type of product); the verification subject includes an e-commerce platform and / or an e-commerce store; that is, the summary document of verification subject dimension is, for example, a summary document of e-commerce platform dimension or a summary document of e-commerce store dimension, and the user can set it according to the needs;
[0066] Among them, check the summary documents of the subject dimension such as Figure 7 As shown in the figure (the verification subject is an e-commerce store), in the summary document of the verification subject dimension, each verification subject is formed into a row of information, where each row of information includes settlement date, online store code, online store name, document type (sales order / after-sales order), document status (ungenerated / generated), order quantity / return quantity, number of product types, total shipment quantity / total return quantity, return order amount, etc.;
[0067] Step 103, the first outbound data of each type of product in the product dimension summary document is compared with the second outbound data of the corresponding type of product in the warehouse management system, and the first inbound data of each type of product is compared with the second inbound data of the corresponding type of product in the warehouse management system; wherein the product dimension summary document is as follows: Figure 6 As shown, in the summary document of the product dimension, each product corresponds to a row of information, wherein each row of information includes product number, product type, product name, product unit, order quantity, order amount, shipment quantity, shipment amount, frozen quantity, return quantity, return amount, platform actual refund amount and suspended quantity, etc. Here, the platform actual refund amount can be obtained from the e-commerce platform, and the platform actual refund amount is applicable to the "small compensation and after-sales interception scenario" in the refund business, etc. Based on the summary document of the product dimension, the total outbound quantity (first outbound data) and total inbound quantity (first inbound data) of each type of product on the day can be obtained, and based on the obtained first outbound quantity The actual inventory of each product (provided by the warehouse management system) is checked against the first incoming data and the second incoming data, thereby realizing daily inventory checking. When the first incoming data and the second incoming data are the same, and the first outgoing data and the second outgoing data are the same, it indicates that the product inventory checking is successful; when the first incoming data and the second incoming data are different, or the first outgoing data and the second outgoing data are different, it indicates that the product inventory checking fails, that is, the sales or operation data is inconsistent with the actual inventory data in the warehouse management system. At this time, a notification message can be output so that relevant personnel can recheck the data; in this way, the efficiency of inventory management is improved and the problem of low efficiency of manual review is solved;
[0068] Step 104, for each verification subject, a statement of the verification subject is generated according to the pre-configured expense item field and the account details of the verification subject within the second time length; wherein the second time length includes multiple first time lengths; for example, the second time length is one week or one month, etc., and of course, the second time length may also be the same as the first time length, such as one natural day; here, the expense item field includes, for example, but is not limited to, at least one of the following: withholding expense item, marketing expenditure expense item, insurance expenditure expense item, software service expense item, transaction collection expense item, transaction refund expense item, supply and marketing platform transaction payment expense item, and public welfare donation expense item;
[0069] The account details in the above steps are as follows Fig.11 As shown, the account details include but are not limited to the following: account serial number, business serial number, merchant order number, merchant name, time of occurrence, counterparty account number, income amount, expenditure amount, account balance, transaction channel, business type, business description, business bill, business order, business basis and order number, etc.; the statement in the above steps is as follows Figure 8 and Fig. 9 As shown, it includes the amount corresponding to the expense item field of each platform and the amount corresponding to the template field of each standard platform;
[0070] Here, it should be noted that, based on the above step 104, the method should also include: configuring the expense item field, wherein the configuration page of the expense item field is as follows: Figure 2 and Figure 3 As shown, first, Figure 2As shown, configure the standard template caliber fields, where the standard template caliber fields include but are not limited to the following fields: Field 1: Partial adjustment - manually fill in the adjustment amount (count the amount of expenses for some invoices and some non-invoices); Field 2: Account deduction invoice account (count the amount of invoices); Field 3: Accounts receivable verification (count the amount of orders receivable); Field 4: Adjustment (count the amount of non-invoices); Field 5: Others (count the reconciliation differences caused by other reasons); Secondly, match the platform caliber with the standard template caliber, where the platform caliber corresponding to the standard template caliber "Field 3: Accounts receivable verification" includes: Field 1: Withholding (Purpose of deduction: Fund agency task), Field 3: 0020001 Transaction refund-balance refund, field 4: 0010002 Transaction receipt-pre-sale deposit (buyer's responsibility, non-refundable), field 5: 0010001 Transaction receipt-transaction receipt; the platform caliber corresponding to the standard template caliber "Field 2: Account deduction invoice account" includes: Field 2: 0030129-software service fee-third-party service provider service fee (platform invoicing); the platform caliber corresponding to the standard template caliber "Field 1: Partial adjustment-manually fill in the adjustment amount" includes: Field 6: Withholding (purpose of deduction: ** alliance commission withholding), Field 7: Withholding (purpose of deduction: ** alliance promotion commission refund), Field 8: 0060011 Marketing expenses-** customer commission;
[0071] Step 105, based on the summary document of the verification subject dimension and the reconciliation statement, perform account reconciliation on each order of the verification subject; specifically, this step is: accumulate the summary documents of the verification subject dimension corresponding to the same verification subject within the time length corresponding to the reconciliation statement, and reconcile the accumulated result with the reconciliation statement, wherein a page diagram of a reconciliation result of this step is as follows Fig.10 As shown, the difference amount of each reconciliation entity is displayed.
[0072] In the reconciliation method of the embodiment of the present application, first, according to the first time length, order information is periodically obtained, and the order information includes sales order information and after-sales order information of the e-commerce platform, and return order information of the warehouse; secondly, according to the order information obtained each time, a summary document corresponding to the order information obtained this time is generated; wherein the summary document includes a summary document of the product dimension and a summary document of the verification subject dimension, and the verification subject includes the e-commerce platform and / or the e-commerce store; here, the product inventory is checked by using the summary document of the product dimension, so that the product inventory can be checked daily from the order dimension, which solves the existing problems of slow manual review and low efficiency of inventory management; thirdly, the product inventory is checked according to the summary document of the product dimension; then, for each verification subject, a reconciliation statement of the verification subject is generated according to the pre-configured expense item field and the account details of the verification subject within the second time length; wherein the second time length includes at least one of the first time lengths; finally, according to the summary document of the verification subject dimension and the reconciliation statement, the accounts of each order of the verification subject are reconciled. In this way, account reconciliation and inventory reconciliation can be realized in one system, which solves the problem of relative separation of order entry and exit and accounts receivable in the existing e-commerce platform order management, and achieves consistency in order-accounts receivable-goods proofreading, that is, realizes the income reconciliation of accounts receivable and goods in the order dimension. In this way, the amount of manual reconciliation can be reduced and the efficiency of reconciliation can be improved.
[0073] As an optional implementation, step 104 includes:
[0074] For each order of the checking subject, the data in the account details are matched with the expense item fields to obtain the data of each expense item field; specifically, this step can be based on matching the business description in the account details with the expense item fields to obtain the amount corresponding to each expense item field (the sum of the amounts of multiple business descriptions corresponding to the expense item field); the description of the business description can be found in Fig.12 ;
[0075] The statement is generated based on the data of the expense item field of each order obtained by matching. The statement generated in this step is as follows: Figure 8 and Fig. 9 shown.
[0076] Further, as an optional implementation, before step 105, the method further includes:
[0077] Determine the order status of the order to be checked; wherein the order status includes the completed new status, the checked but unfinished status or the unchecked status; here, the completed new status means that the order has been checked in the historical bill, but the expenditure or income of the order appears in the latest bill (the bill obtained in this cycle), such as the order refund; in simple terms, the completed new status means that new expenses appear in the order after the check is completed, for example, the order is refunded after the check is completed; the checked but unfinished status means that the order to be checked has completed at least one check, the check result fails, and the number of checks is less than the pre-configured rolling reconciliation number; the unchecked status means that the order to be checked has not been checked;
[0078] On this basis, step 105 includes:
[0079] When the order status is a verified but uncompleted state or an unverified state, the account verification is performed on the order to be verified according to the summary document of the verification subject dimension and the statement.
[0080] That is to say, when performing account reconciliation on orders to be checked, it is first necessary to determine the status of the orders to be checked, and secondly, perform account reconciliation on orders that have not been completed.
[0081] As a specific implementation method, the account verification of the order to be verified is performed according to the summary document of the verification subject dimension and the statement, including:
[0082] In the statement, extract the data of the expense item field of the order to be checked;
[0083] According to the data of the fee item field of the order to be checked extracted, the actual amount of the order to be checked is calculated; here, the actual amount of different e-commerce platforms corresponds to different fee items, which can be specifically referred to in the following Table 1, where the actual amount should be the sum of the amounts of each fee item corresponding to the actual amount:
[0084] Table 1 Examples of actual amounts collected on different platforms
[0085] Platform Name The corresponding receivables field composition of the transaction (corresponding to the order amount of the order management system) Remark Platform 1 The actual payment of the order + the actual subsidy of the platform + the actual platform subsidy_shipping fee + the actual talent subsidy + the actual payment subsidy of a certain audio + the actual monthly marketing subsidy of a certain audio + the order refund Platform 2 Total revenue (yuan) - order refund (yuan) Platform 3 Order Receipt-Refund Platform 4 Income - Refund + Balance Payment Field header = type, corresponding amount header = income Field header for refund = type, corresponding amount for refund = expenditure Platform 5 Transaction Payment + Transaction Refund Income header = income and expenditure type, corresponding amount header = income and expenditure amount (yuan) Refund header = business type, corresponding amount = income and expenditure amount (yuan) Platform 6 Receivables Transaction payment header = business type, amount corresponds to: expenditure amount Transaction refund header = business type, amount corresponds to: income amount Platform 7 0010002|Transaction income-Order income+0010005|Transaction income-Coupon settlement+0020005|Transaction refund-Coupon settlement+0020002|Transaction refund-Order refund Field header = merchant receivable / payable, corresponding amount header = amount
[0086] In the summary document of the verification subject dimension, the receivable amount of the order to be verified is obtained;
[0087] The order to be reconciled is reconciled according to the actually collected amount, the receivable amount and a pre-configured difference threshold; specifically, when the absolute value of the difference between the receivable amount and the actually collected amount is less than the difference threshold, it indicates that the reconciliation result of the order is successful.
[0088] In this optional implementation, the expense details associated with various types of expenditures and orders can be accurately identified based on the reconciliation statement, reducing the workload of manual statistics. Reconciliation is performed based on the summary documents of the reconciliation statement and the verification subject dimension, realizing intelligent reconciliation of the verification subject, improving reconciliation efficiency, and reducing the workload of manual verification.
[0089] As a more specific implementation, performing account verification on the order to be verified according to the actual amount received, the receivable amount and a pre-configured difference threshold includes:
[0090] Calculate the difference between the receivable amount and the actual amount received;
[0091] When the absolute value of the difference is less than or equal to the difference threshold, it is determined that the order to be checked is completed and the check result is successful;
[0092] When the absolute value of the difference is greater than the difference threshold, the order to be checked is checked according to a pre-configured rolling check number and the difference.
[0093] That is to say, when the difference between the amount receivable and the amount actually collected is less than or equal to the difference threshold, it means that the difference between the amount receivable and the amount actually collected is within the allowable error range, indicating that the order reconciliation is successful; when the difference between the amount receivable and the amount actually collected is greater than the difference threshold, it means that the difference between the amount receivable and the amount actually collected is outside the allowable error range, and it is necessary to further determine whether the number of reconciliations for the order has reached the pre-configured rolling reconciliation number, so as to determine whether the reconciliation result of this order is a success or a failure.
[0094] In the above-mentioned more specific implementation method, by setting the number of rolling reconciliations, multiple reconciliations can be achieved for the same order to solve the problem that the various expense expenditures and expense collection methods of the e-commerce platform are different. A method that only checks the total revenue cannot identify the expense expenditure situation and expense collection details of a single order, which also creates many risks for the expense management of financial personnel. There are unrecognized increases in expense expenditures, and it is impossible to clearly locate abnormal collection orders, and it is impossible to identify problems such as abnormal expense collection that may be caused by business operation problems.
[0095] Based on the above more specific implementation, it can be seen that the method of the embodiment of the present application also includes: configuring the difference amount and the number of rolling reconciliations, wherein the configuration page of the difference amount and the number of rolling reconciliations is as follows: Figure 4 As shown, Figure 4 The "Amount Difference Setting" is to set the difference threshold, and the "Reconciliation Times Limit" corresponds to the aforementioned rolling reconciliation times.
[0096] Specifically, when the absolute value of the difference is greater than the difference threshold, performing account reconciliation on the order to be reconciled according to the pre-configured rolling reconciliation times and the difference, including:
[0097] When the number of reconciliations of the order to be checked is less than the rolling number of reconciliations, it is determined that the order to be checked has not been checked, and the number of reconciliations and the reconciled amount of the order to be checked are updated; here, updating the number of reconciliations of the order to be checked is to increase the number of reconciliations by 1, and the reconciled amount is the amount of the reconciliation;
[0098] Alternatively, when the number of reconciliations of the order is equal to the number of rolling reconciliations, it is determined that the order to be reconciled has completed reconciliation, and the reconciliation result is reconciliation failure.
[0099] Simply put, the amount receivable in the summary document of the verification subject dimension is subtracted from the amount actually collected in the above Table 1 (the amount actually collected determined based on the statement of account), and the result is compared with the difference amount in the reconciliation rule (corresponding to the aforementioned difference threshold). If the result is within the tolerance range of the difference amount, the reconciliation is considered successful; if the result is outside the tolerance range of the difference amount and the number of rolling reconciliations for the order has not been consumed (the number of reconciliations completed is less than the number of rolling reconciliations), the reconciliation is considered incomplete and the order can enter the next rolling reconciliation range; if the result is outside the tolerance range of the difference amount and the number of reconciliations has been consumed (the number of reconciliations completed is equal to the number of rolling reconciliations), the reconciliation is considered failed.
[0100] Further, as an optional implementation, after step 105, the method further includes at least one of the following steps:
[0101] If the verification result is successful, create an expense reimbursement form for the order corresponding to the verification result; wherein the expense reimbursement form is used for expense reimbursement, therefore, after creating the expense reimbursement form, the execution subject (such as the reconciliation system) of the reconciliation method of the embodiment of the present application can send the expense reimbursement form to the financial system to execute the expense reimbursement process in the financial system;
[0102] If the verification result is a verification failure, output a prompt message of the verification failure, and / or create a sales document and a return document, wherein the sales document and the return document are used to adjust the accounting data of the order corresponding to the verification result;
[0103] Here, after only outputting the prompt message of verification failure, the staff can manually perform adjustments; when only creating sales documents and return documents or outputting prompt messages and creating sales documents and return documents, adjustments can be performed based on the created sales documents and return documents, wherein the sales amount of the sales document should be the difference between the amount receivable and the actual amount received, so that the actual amount received can be adjusted based on the sales document so that the difference between the amount receivable and the actual amount received is within the difference threshold; in addition, the number of products in the sales document is the same as the number of products in the return document, and the refund in the return document is zero, so that it can be ensured that the actual inventory is the same as the inventory determined based on the order information.
[0104] The above-mentioned multiple implementation methods can automatically bring out the corresponding fee amount according to the reconciliation results and expense analysis results of the verification subject, and can directly initiate the e-commerce adjustment and expense reimbursement process for accounting data correction. This is more convenient and reduces the occurrence of manual errors; that is, the corresponding accounts receivable accounting and inventory deductions or inventory increases can be completed in the accounting system in a timely manner. According to the platform's collection rules or actual reconciliation needs, order collection and support verification can be completed weekly or monthly. The system automatically verifies and automatically identifies abnormal uncollected orders or abnormal expenditure orders to ensure the accuracy of accounts receivable.
[0105] Furthermore, as another optional implementation, the method further includes:
[0106] When the order status is the completed new order status, a sales document and a return document for adjusting the account data of the order to be checked are created according to the data related to the order to be checked in the statement.
[0107] Here, it should be noted that the application scenario of the above optional implementation method is: the order to be checked has been checked in the historical checking process, and the bill details obtained in this checking cycle include the details of the order (such as the refund for the order). Take the bill to be checked as order A as an example. Order A was checked in the previous checking cycle, and the refund details of order A were obtained in this checking cycle. At this time, sales documents and return documents can be created based on the refund details obtained in this checking cycle to balance the refund in the account. Among them, the specific contents of the sales document and return document are the same as the sales document and return document of the previous optional implementation method, and will not be repeated here.
[0108] Furthermore, as another optional implementation, the method further includes:
[0109] According to the reconciliation statement, determine the proportional relationship between the expenditure amount of the verification subject and the actual amount received of the order of the verification subject; that is, this step is: first, in the reconciliation statement, obtain the sum of the actual amount received and the sum of the expenditure amount of each order of the same verification subject; second, calculate the ratio of the two sums to obtain the proportional relationship between the expenditure amount and the actual amount received; wherein, when calculating the above proportional relationship over a period of time, the influence of special circumstances (such as promotional activities) on the proportional relationship can be adjusted in a weighted manner. For example, the sales performance in July is predicted based on the proportional relationship in June. Since there is a promotional activity in June, the proportional relationship in June can be multiplied by a pre-configured coefficient as the predicted proportional relationship in July;
[0110] According to the proportional relationship, the sales performance of the verification subject and / or the expense expenditure of the verification subject are predicted; here, the sales performance of the verification subject can be represented by the sales volume / actually collected amount of the orders of the verification subject.
[0111] In another optional implementation method mentioned above, an example of predicting the sales performance of the verification entity based on the proportional relationship is: an expenditure of 10,000 yuan in January last year generated a sales performance of 1 million, and the proportional relationship between the expenditure amount and the actual amount collected in January last year was 1%. In January this year, as of January 10, an expenditure of 10,000 yuan was generated, and it is predicted that an expenditure of 30,000 yuan will be generated in January this year. According to the proportional relationship in January last year, it is predicted that the sales performance generated in January this year should be 3 million yuan.
[0112] In another optional implementation method mentioned above, an example of predicting the expense expenditure of the verification entity based on the proportional relationship is: assuming that the proportional relationship between the expenditure amount and the actual amount collected last year is 1%, and the sales performance this year set by the verification entity is 10 million yuan, the predicted expenditure amount this year is 10 million * 1% = 100,000 yuan.
[0113] Here, it should be noted that e-commerce sales scenarios have covered most companies, but the management of goods in and out of the warehouse and account management on e-commerce platforms are a major difficulty. It is difficult to manually count the sales, delivery and return data of each platform every day, and it is difficult for each e-commerce platform to check the order receivables, order actual receipts and order expenses. In order to facilitate the actual operation of e-commerce order and commodity inventory management operators and the e-commerce financial reconciliation capabilities, technical means are used to improve the goods management, financial receivables management, expense and budget management capabilities of enterprises for e-commerce business. Based on this, the reconciliation method of the embodiment of the present application generates a summary document of the product dimension and a summary document of the verification subject dimension through order information, so as to realize the verification of product inventory based on the summary document of the product dimension, and the account reconciliation based on the summary document of the verification subject dimension and the reconciliation statement generated according to the bill details. In this way, on the one hand, the verification of inventory and account processing in the order dimension is achieved, and daily reconciliation can be realized within a system, which improves the efficiency of inventory management and solves the problem of low efficiency of manual review. On the other hand, the consistent proofreading of orders, accounts receivable and goods is realized to avoid delays in account reconciliation. When the order volume is large, the accounts receivable and goods in the order dimension can also be realized. Income verification; Third, it solves the problem that it is impossible to accurately identify the related expense details of various expenditures and orders through manual verification of a large number of different expense expenditure items on the platform, and the manual statistical workload is large; In addition, in the order dimension account verification process, the innovative introduction of the rolling reconciliation mechanism solves the problem that the various expense expenditures and expense collection methods of the e-commerce platform are different. A method that only looks at the total income has no way to identify the expense expenditure situation and expense collection details of a single order, which also creates many risks for the expense management of financial personnel. There are unrecognizable expense increase, and it is impossible to clearly locate abnormal collection orders, and it is impossible to identify the abnormal expense collection that may be caused by business operation problems. In addition, in the embodiment of the present application, after the verification is completed, the corresponding accounts receivable accounting and inventory deduction or inventory increase can be completed in the accounting system in a timely manner. According to the platform collection rules or the actual needs of reconciliation, the order collection and support verification are completed weekly or monthly. The system automatically verifies and automatically identifies abnormal uncollected orders or abnormal expenditure orders to ensure the accuracy of accounts receivable.
[0114] In short, the reconciliation method of the embodiment of the present application may include the following steps:
[0115] First: Identify and configure various expense items in the e-commerce platform statement; specifically, based on the platform e-commerce statement, identify the names of the income and expenditure expense items and expense scenarios for various order scenarios, and configure the corresponding financial settlement expense caliber and financial settlement method in the system;
[0116] Second: configure and set the rules for the reconciliation difference amount and the number of rolling reconciliations for orders; specifically: according to the past reconciliation rules and the rules for the invalidation of platform payment collection, configure the reconciliation rules for each platform, the difference amount range (corresponding to the aforementioned difference threshold) and the number of rolling reconciliations for orders (corresponding to the aforementioned pre-configured number of rolling reconciliations), that is, if the payment collection of some e-commerce platforms is delayed due to the consumer's receipt status, within how many reconciliation cycles can the payment be fully collected;
[0117] Third: The system automatically checks the order - receivable amount - goods in and out of the warehouse; specifically: the system counts the orders to be sent, orders sent, shipped goods, quantity of shipped goods, returned goods, and quantity of returned goods on a daily basis. After the warehouse confirms the inventory data, the system automatically generates the Enterprise Resource Planning (ERP) daily settlement document (corresponding to the summary document of the tea product dimension and the summary document of the verification subject dimension mentioned above);
[0118] Fourth: Weekly / monthly platform statement analysis; specifically: identify various expense details within the specified time dimension based on the configured platform reconciliation expense fields and mark the orders incurring the corresponding expenses;
[0119] Fifth: order dimension receivable amount - actual amount received verification; specifically: according to the cost analysis in the revenue flow of each e-commerce platform, the system automatically calculates the actual amount received of each order and the order center order receivable amount, and calculates the order receivable difference; more specifically, the order receivable amount in the daily reconciliation is subtracted from the actual amount received according to the formula in the aforementioned Table 1, and the result is verified with the difference amount in the reconciliation rule. If the result is within the tolerance range of the difference amount, it is considered a successful reconciliation; if the result is outside the tolerance range of the difference amount, and the number of order rolling reconciliations has not been consumed, it is considered to be incomplete reconciliation, and the order can enter the next rolling reconciliation range; if the result is outside the tolerance range of the difference amount, and the number of reconciliations has been consumed, it is considered to be a reconciliation failure; if there is a payment item for goods that has been reconciled in the platform flow (such as a refund), it is considered an exception. The system automatically marks the reconciliation status of various orders, and supports processing different reconciliation results according to different reconciliation statuses;
[0120] Sixth: Automatic processing of expense management finance; Specifically: According to the reconciliation results of the store platform and the expense analysis results, the system automatically brings out the corresponding expense amount, and can directly initiate the e-commerce adjustment and expense reimbursement process for accounting data correction. Convenient operation reduces manual input and wrong recording;
[0121] Seventh: Cost budget forecast; Specifically: Based on the reconciliation results of e-commerce stores on each platform and the results of various expense expenditures, the system automatically evaluates the cost utilization rate and calculates the relationship between expense expenditure and business achievement rate, which is used for the next month's budget estimate and annual quarterly store expense estimate.
[0122] The above-mentioned reconciliation method of the embodiment of the present application has the following advantages: on the one hand, based on the generation and fulfillment of e-commerce orders, the order-goods-receivables data are checked daily to ensure the accuracy of accounts and receivables, and improve the turnover efficiency of warehouse purchase, sales and inventory; on the other hand, the computing power of computers is used to reduce the workload of manual reconciliation, ensure the accuracy of corresponding expense statistics, and the reconciliation results can be directly applied to expense settlement or e-commerce adjustment scenarios, and the system operation is convenient; on the other hand, the configuration is simple, the input results are clear and detailed, which is convenient for financial personnel to manage business compliance operations through accurate financial data; on the other hand, e-commerce expense forecasting is realized, so that e-commerce expense forecasting has a data source basis and expense settlement has an accurate data basis. Make e-commerce expense forecasting more accurate and use more efficient.
[0123] The embodiment of the present application also provides a reconciliation device, such as Fig.13 As shown, including:
[0124] The order acquisition module 1301 is used to periodically acquire order information according to a first time length, wherein the order information includes sales order information and after-sales order information of the e-commerce platform, and return order information of the warehouse;
[0125] The summary document generation module 1302 is used to generate a summary document corresponding to the order information obtained this time according to the order information obtained each time; wherein the summary document includes a summary document of a product dimension and a summary document of a verification subject dimension, and the verification subject includes an e-commerce platform and / or an e-commerce store;
[0126] The inventory checking module 1303 is used to check the first outbound data of each type of product in the summary document of the product dimension with the second outbound data of the corresponding type of product in the warehouse management system, and to check the first inbound data of each type of product with the second inbound data of the corresponding type of product in the warehouse management system;
[0127] A statement generation module 1304 is used to generate a statement of each checking subject according to the pre-configured expense item fields and the account details of the checking subject within a second time length, wherein the second time length includes a plurality of the first time lengths;
[0128] The reconciliation module 1305 is used to perform account reconciliation on each order of the reconciliation subject according to the summary document of the reconciliation subject dimension and the reconciliation statement.
[0129] Optionally, the statement generation module 1304 is specifically used to: for each order of the verification entity, match the data in the account details with the expense item field to obtain the data of each expense item field; and generate the statement based on the matched data of the expense item field of each order.
[0130] Optionally, the device further comprises:
[0131] A first determination module is used to determine the order status of the order to be checked; wherein the order status includes a completed and newly added state, a checked but unfinished state, or an unchecked state;
[0132] The reconciliation module 1305 is specifically used for: when the order status is a checked but uncompleted state or an unchecked state, performing account reconciliation on the order to be reconciled according to the summary document of the reconciliation subject dimension and the reconciliation statement.
[0133] Optionally, the reconciliation module 1305 includes:
[0134] An extraction submodule, used to extract data of the expense item field of the order to be checked in the statement;
[0135] A calculation submodule, used for calculating the actual amount received of the order to be checked according to the data extracted from the expense item field of the order to be checked;
[0136] An acquisition submodule, used for acquiring the receivable amount of the order to be checked in the summary document of the checking subject dimension;
[0137] The reconciliation submodule is used to perform account reconciliation on the order to be reconciled according to the actual amount received, the receivable amount and a pre-configured difference threshold.
[0138] Optionally, the reconciliation submodule includes:
[0139] A calculation unit, used for calculating the difference between the receivable amount and the actual amount received;
[0140] A determination unit, configured to determine that the order to be checked is completed and the check result is a successful check when the absolute value of the difference is less than or equal to the difference threshold;
[0141] The reconciliation unit is used to perform account reconciliation on the order to be reconciled according to a pre-configured rolling reconciliation number and the difference when the absolute value of the difference is greater than the difference threshold.
[0142] Optionally, the reconciliation unit is specifically used for:
[0143] When the number of reconciliations of the order to be checked is less than the rolling number of reconciliations, determining that the order to be checked has not been checked, and updating the number of reconciliations and the reconciled amount of the order to be checked;
[0144] Alternatively, when the number of reconciliations of the order is equal to the number of rolling reconciliations, it is determined that the order to be reconciled has completed reconciliation, and the reconciliation result is reconciliation failure.
[0145] Optionally, the device further comprises at least one of the following modules:
[0146] A first creation module, for creating an expense reimbursement form for an order corresponding to the verification result when the verification result is successful;
[0147] The processing module is used to output a prompt message of verification failure when the verification result is verification failure, and / or create a sales document and a return document, wherein the sales document and the return document are used to adjust the accounting data of the order corresponding to the verification result.
[0148] Optionally, the device further comprises:
[0149] The second creation module is used to create a sales document and a return document for adjusting the accounting data of the order to be checked according to the data related to the order to be checked in the statement when the order status is the completed new status.
[0150] Optionally, the device further comprises:
[0151] A second determination module is used to determine the ratio between the expenditure amount of the verification subject and the actual amount received for the order of the verification subject according to the reconciliation statement;
[0152] A prediction module is used to predict the sales performance of the verification subject and / or the expense expenditure of the verification subject according to the proportional relationship.
[0153] It should be noted here that the above-mentioned reconciliation device provided in the embodiment of the present application can implement all the method steps implemented in the above-mentioned reconciliation method embodiment, and can achieve the same technical effect. The parts and beneficial effects of this embodiment that are the same as those of the method embodiment will not be described in detail here.
[0154] To achieve the above-mentioned purpose, an embodiment of the present application provides a reconciliation system, including a transceiver 1410, a processor 1400, a memory 1420, and a program stored on the memory 1420 and executable on the processor 1400; wherein, when the processor 1400 executes the program, the method for controlling the displacement of a robot applied to a client device as described above is implemented, or, the method for controlling the displacement of a robot applied to a server device as described above is implemented.
[0155] The transceiver 1410 is used to receive and send data under the control of the processor 1400 .
[0156] Among them, Fig.14 In the embodiment, the bus architecture may include any number of interconnected buses and bridges, specifically one or more processors represented by processor 1400 and various circuits of memory represented by memory 1420 are linked together. The bus architecture may also link together various other circuits such as peripherals, voltage regulators, and power management circuits, which are well known in the art and are therefore not further described herein. The bus interface provides an interface. The transceiver 1410 may be a plurality of components, namely, a transmitter and a receiver, providing a unit for communicating with various other devices on a transmission medium. For different systems, the user interface 1430 may also be an interface capable of externally and internally connecting required devices, and the connected devices include but are not limited to a keypad, a display, a speaker, a microphone, a joystick, and the like.
[0157] The processor 1400 is responsible for managing the bus architecture and general processing, and the memory 1420 can store data used by the processor 1400 when performing operations.
[0158] It should be noted here that the above-mentioned reconciliation system provided in the embodiment of the present application can implement all the method steps implemented in the above-mentioned reconciliation method embodiment, and can achieve the same technical effect. The parts and beneficial effects of this embodiment that are the same as those in the method embodiment will not be described in detail here.
[0159] A readable storage medium in an embodiment of the present application stores a program or instruction thereon. When the program or instruction is executed by a processor, the steps in the reconciliation method as described above are implemented and the same technical effect can be achieved. To avoid repetition, it will not be described here.
[0160] The processor is the processor in the reconciliation system described in the above embodiment. The readable storage medium includes a computer readable storage medium, such as a computer read-only memory (ROM), a random access memory (RAM), a magnetic disk or an optical disk.
[0161] In the embodiment of the present application, module can be implemented with software so that it can be executed by various types of processors. For example, an executable code module of an identification can include one or more physical or logical blocks of computer instructions, for example, it can be constructed as an object, process or function. Nevertheless, the executable code of the identified module does not need to be physically located together, but can include different instructions stored in different positions, and when these instructions are logically combined together, it constitutes a module and realizes the specified purpose of the module.
[0162] In fact, executable code module can be a single instruction or many instructions, and can even be distributed on a plurality of different code segments, distributed among different programs, and distributed across a plurality of memory devices.Similarly, operation data can be identified in the module, and can be implemented and organized in the data structure of any appropriate type according to any appropriate form.Described operation data can be collected as a single data set, or can be distributed in different locations (including on different storage devices), and can only be present on a system or network as an electronic signal at least in part.
[0163] When a module can be implemented by software, considering the level of existing hardware technology, a person skilled in the art can build a corresponding hardware circuit to implement the corresponding function without considering the cost of the module that can be implemented by software. The hardware circuit includes a conventional very large scale integrated circuit or gate array and existing semiconductors such as logic chips, transistors, or other discrete components. The module can also be implemented by a programmable hardware device, such as a field programmable gate array, a programmable array logic, a programmable logic device, etc.
[0164] An embodiment of the present application also provides a computer program product, including computer instructions. When the computer instructions are executed by a processor, the reconciliation method as described above is implemented and the same technical effect can be achieved. In order to avoid repetition, it will not be described here.
[0165] The above exemplary embodiments are described with reference to the accompanying drawings, and many different forms and embodiments are feasible without departing from the spirit and teachings of the present application. Therefore, the present application should not be constructed as a limitation of the exemplary embodiments proposed herein. More specifically, these exemplary embodiments are provided so that the present application will be perfect and complete, and the scope of the present application will be conveyed to those who are familiar with the technology. In these figures, the component sizes and relative sizes may be exaggerated for clarity. The terms used here are only based on the purpose of describing specific exemplary embodiments and are not intended to be limiting. As used herein, unless the text clearly indicates otherwise, the singular forms "one", "an" and "the" are intended to include these multiple forms. It will be further understood that the terms "comprising" and / or "including" when used in this specification indicate the presence of the features, integers, steps, operations, components and / or components, but do not exclude the presence or increase of one or more other features, integers, steps, operations, components, components and / or their groups. Unless otherwise indicated, when stated, a range of values includes the upper and lower limits of that range and any subranges therebetween.
[0166] It should be understood that the references to "one embodiment" or "an embodiment" throughout the specification mean that the specific features, structures, or characteristics associated with the embodiment are included in at least one embodiment of the present application. Therefore, the references to "in one embodiment" or "in an embodiment" appearing throughout the specification do not necessarily refer to the same embodiment. In addition, these specific features, structures, or characteristics may be combined in any suitable manner in one or more embodiments.
[0167] In the various embodiments of the present application, it should be understood that the size of the serial numbers of the following processes does not mean the order of execution. The execution order of each process should be determined by its function and internal logic, and should not constitute any limitation on the implementation process of the embodiments of the present application.
[0168] Additionally, the terms "system" and "network" are often used interchangeably herein.
[0169] In the embodiments provided in the present application, it should be understood that "B corresponding to A" means that B is associated with A, and B can be determined according to A. However, it should also be understood that determining B according to A does not mean determining B only according to A, and B can also be determined according to A and / or other information.
[0170] The above is a preferred embodiment of the present application. It should be pointed out that for ordinary technicians in this technical field, several improvements and modifications can be made without departing from the principles described in the present application. These improvements and modifications should also be regarded as the scope of protection of the present application.
Claims
1. A reconciliation method, characterized in that: include: According to the first time length, periodically obtain order information, wherein the order information includes sales order information and after-sales order information of the e-commerce platform, and return order information of the warehouse; According to the order information obtained each time, a summary document corresponding to the order information obtained this time is generated; wherein the summary document includes a summary document of a product dimension and a summary document of a verification subject dimension, and the verification subject includes an e-commerce platform and / or an e-commerce store; wherein the summary document of the product dimension includes a summary document of each type of product, and the summary document of each type of product includes product number, product type, product name, product unit, order quantity, order amount, shipment quantity, shipment amount, frozen quantity, return quantity, platform actual refund amount, and suspended quantity; the summary document of the verification subject dimension includes summary documents of each verification subject, and the summary document of each verification subject includes settlement date, online store code, online store name, document type, document status, order quantity or return quantity, number of product types, total shipment quantity or total return quantity, and return order amount; The first outbound data of each type of product in the summary document of the product dimension is checked with the second outbound data of the corresponding type of product in the warehouse management system, and the first inbound data of each type of product is checked with the second inbound data of the corresponding type of product in the warehouse management system; wherein the first outbound data includes the total outbound quantity of each type of product on the day determined according to the summary document of the product dimension, and the first inbound data includes the total inbound quantity of each type of product on the day determined according to the summary document of the product dimension; For each checking subject, generating a statement of the checking subject according to the pre-configured expense item fields and the account details of the checking subject within a second time length; wherein the second time length includes at least one of the first time lengths; According to the summary document of the verification subject dimension and the reconciliation statement, the account reconciliation is performed on each order of the verification subject; Wherein, before performing account verification on each order of the verification subject according to the summary document of the verification subject dimension and the reconciliation statement, the method further includes: Determine the order status of the order to be checked; wherein the order status includes a completed new state, a checked but unfinished state or an unchecked state; wherein the completed new state is a state in which the order has been checked and completed and new fees have been incurred, the checked but unfinished state is a state in which at least one check has been completed, the check result is a check failure, and the number of checks is less than a pre-configured rolling reconciliation number, and the unchecked state is a state in which no check has been performed; The performing of account verification on each order of the verification subject according to the summary document of the verification subject dimension and the reconciliation statement includes: When the order status is a checked but uncompleted state or an unchecked state, performing account checking on the order to be checked according to the summary document of the checking subject dimension and the reconciliation statement; According to the summary document of the verification subject dimension and the reconciliation statement, the account verification of the order to be verified includes: In the statement, extract the data of the expense item field of the order to be checked; Calculate the actual amount of the order to be checked based on the extracted data of the expense item field of the order to be checked; In the summary document of the verification subject dimension, the receivable amount of the order to be verified is obtained; The order to be checked is checked based on the actually collected amount, the receivable amount and a pre-configured difference threshold.
2. The method according to claim 1, characterized in that Generating a statement of the checking subject according to the pre-configured expense item fields and the account details of the checking subject within the second time length, including: For each order of the checking subject, matching the data in the account details with the expense item fields to obtain the data of each expense item field; The statement is generated based on the matched data of the expense item fields of each of the orders.
3. The method according to claim 1, characterized in that According to the actual amount received, the amount receivable and a pre-configured difference threshold, the order to be checked is checked for accounts, including: Calculate the difference between the receivable amount and the actual amount received; When the absolute value of the difference is less than or equal to the difference threshold, it is determined that the order to be checked is completed and the check result is successful; When the absolute value of the difference is greater than the difference threshold, the order to be checked is checked according to a pre-configured rolling check number and the difference.
4. The method according to claim 3, characterized in that When the absolute value of the difference is greater than the difference threshold, performing account reconciliation on the order to be reconciled according to the pre-configured rolling reconciliation times and the difference, including: When the number of reconciliations of the order to be checked is less than the rolling number of reconciliations, determining that the order to be checked has not been checked, and updating the number of reconciliations and the reconciled amount of the order to be checked; Alternatively, when the number of reconciliations of the order is equal to the number of rolling reconciliations, it is determined that the order to be reconciled has completed reconciliation, and the reconciliation result is reconciliation failure.
5. The method according to any one of claims 1 to 4, characterized in that: After performing account verification on each order of the verification subject according to the summary document of the verification subject dimension and the reconciliation statement, the method further comprises at least one of the following steps: If the verification result is successful, create an expense reimbursement form for the order corresponding to the verification result; When the verification result is a verification failure, a prompt message of the verification failure is output, and / or a sales document and a return document are created, wherein the sales document and the return document are used to adjust the accounting data of the order corresponding to the verification result.
6. The method according to claim 1, characterized in that The method further comprises: When the order status is the completed new order status, a sales document and a return document for adjusting the account data of the order to be checked are created according to the data related to the order to be checked in the statement.
7. The method according to claim 1, characterized in that The method further comprises: Determine the ratio between the amount of expenditure of the verification subject and the amount actually received for the order of the verification subject according to the reconciliation statement; According to the proportional relationship, the sales performance of the verification subject and / or the expense expenditure of the verification subject are predicted.
8. A reconciliation device, characterized in that: include: An order acquisition module, used to periodically acquire order information according to a first time length, wherein the order information includes sales order information and after-sales order information of the e-commerce platform, and return order information of the warehouse; A summary document generation module is used to generate a summary document corresponding to the order information obtained this time according to the order information obtained each time; wherein the summary document includes a summary document of a product dimension and a summary document of a verification subject dimension, and the verification subject includes an e-commerce platform and / or an e-commerce store; wherein the summary document of the product dimension includes a summary document of each type of product, and the summary document of each type of product includes product number, product type, product name, product unit, order quantity, order amount, shipment quantity, shipment amount, frozen quantity, return quantity, platform actual refund amount, and suspended quantity; the summary document of the verification subject dimension includes summary documents of each verification subject, and the summary document of each verification subject includes settlement date, online store code, online store name, document type, document status, order quantity or return quantity, number of product types, total shipment quantity or total return quantity, and return order amount; The inventory checking module is used to check the first outbound data of each type of product in the summary document of the product dimension with the second outbound data of the corresponding type of product in the warehouse management system, and to check the first inbound data of each type of product with the second inbound data of the corresponding type of product in the warehouse management system; wherein the first outbound data includes the total outbound quantity of each type of product on the day determined according to the summary document of the product dimension, and the first inbound data includes the total inbound quantity of each type of product on the day determined according to the summary document of the product dimension; A statement generation module, for generating a statement of each checking subject according to a pre-configured expense item field and the account details of the checking subject within a second time length, wherein the second time length includes a plurality of the first time lengths; A reconciliation module, used to perform account reconciliation on each order of the reconciliation subject according to the summary document of the reconciliation subject dimension and the reconciliation statement; Wherein, the device further comprises: A first determination module is used to determine the order status of the order to be checked; wherein the order status includes a completed and newly added status, a checked and unfinished status or an unchecked status; wherein the completed and newly added status is a status in which the order has been checked and completed and new expenses have been incurred, the checked and unfinished status is a status in which at least one check has been completed, the check result is a check failure, and the number of checks is less than a pre-configured rolling reconciliation number, and the unchecked status is a status in which no check has been performed; The reconciliation module is specifically used for: when the order status is a checked but uncompleted state or an unchecked state, performing account reconciliation on the order to be reconciled according to the summary document of the reconciliation subject dimension and the reconciliation statement; The reconciliation module includes: An extraction submodule, used to extract data of the expense item field of the order to be checked in the statement; A calculation submodule, used for calculating the actual amount received of the order to be checked according to the data extracted from the expense item field of the order to be checked; An acquisition submodule, used for acquiring the receivable amount of the order to be checked in the summary document of the checking subject dimension; The reconciliation submodule is used to perform account reconciliation on the order to be reconciled according to the actual amount received, the receivable amount and a pre-configured difference threshold.
9. A reconciliation system, comprising: The method comprises a transceiver, a memory, a processor and a computer program stored in the memory and running on the processor, wherein the processor implements the reconciliation method according to any one of claims 1 to 7 when executing the computer program.
10. A readable storage medium having a program or instruction stored thereon, characterized in that: When the program or instruction is executed by a processor, the reconciliation method according to any one of claims 1 to 7 is implemented.
11. A computer program product, characterized in that The method comprises computer instructions, which, when executed by a processor, implement the reconciliation method according to any one of claims 1 to 7.
