Disclosure of Invention
The embodiment of the application provides a checking method, a device, a system, a storage medium and a program product, which solve the problems of low checking efficiency and large manual checking amount of the conventional e-commerce platform.
In order to achieve the above object, an embodiment of the present application provides a reconciliation method, including:
periodically acquiring order information according to the first time length, wherein the order information comprises sales order information and after-sales order information of an electronic commerce platform and return order information of a warehouse;
Generating a summary document corresponding to the order information acquired at this time according to the order information acquired at each time; the summarized documents comprise summarized documents of product dimension and summarized documents of checking main body dimension, and the checking main body comprises an e-commerce platform and/or an e-commerce store;
Checking the first ex-warehouse data of each type of product in the summary document of the product dimension with the second ex-warehouse data of the corresponding type of product in the warehouse management system, and checking the first warehouse-in data of each type of product with the second warehouse-in data of the corresponding type of product in the warehouse management system;
Generating, for each reconciliation entity, a statement of the reconciliation entity based on the preconfigured fee item field and the accounting details of the reconciliation entity for a second length of time; wherein the second time length comprises at least one of the first time lengths;
and according to the summary bill and the statement of the dimension of the checking main body, performing accounting checking on each order of the checking main body.
Optionally, generating the statement of the checking subject according to the preconfigured fee item field and the accounting details of the checking subject in the second time length includes:
matching the data in the accounting details with the expense item fields for each order of the checking main body to obtain the data of each expense item field;
and generating the statement according to the data of the expense item fields of the respective orders obtained by matching.
Optionally, before performing accounting checking on each order of the checking subject according to the summary document and the statement of dimension of the checking subject, the method further includes:
Determining an order state of an order to be checked; wherein the order status includes a completed new status, a checked incomplete status, or an uncore status;
And performing accounting checking on each order of the checking subject according to the summary document and the statement of the dimension of the checking subject, wherein the accounting checking comprises the following steps:
and under the condition that the order state is a checked unfinished state or an unchecked state, according to the summary bill and the statement of the checking main dimension, carrying out accounting checking on the order to be checked.
Optionally, according to the summary document and the statement of the dimension of the checking subject, performing accounting checking on the order to be checked, including:
extracting data of the expense item field of the order to be checked from the statement;
Calculating the actual receiving amount of the order to be checked according to the extracted data of the expense item field of the order to be checked;
acquiring receivable amount of the order to be checked from the summary document of the dimension of the checking main body;
and carrying out accounting checking on the order to be checked according to the actual receipt amount, the receivable amount and a pre-configured difference threshold.
Optionally, according to the actual receivables, the receivables and a pre-configured difference threshold, performing accounting checking on the to-be-checked order, including:
calculating the difference value between the receivable amount and the actual receivable amount;
when the absolute value of the difference value is smaller than or equal to the difference threshold value, determining that the order to be checked is checked, and checking the order to be checked;
And when the absolute value of the difference value is larger than the difference threshold value, performing accounting checking on the order to be checked according to the preset rolling checking times and the difference value.
Optionally, when the absolute value of the difference is greater than the difference threshold, performing accounting checking on the order to be checked according to the preset rolling checking times and the difference, including:
When the checking times of the to-be-checked orders are smaller than the rolling checking times, determining that the to-be-checked orders are not checked, and updating checked times and checked amount of the to-be-checked orders;
or when the checking times of the orders are equal to the rolling checking times, determining that the orders to be checked are checked, and the checking result is check failure.
Optionally, after accounting checking is performed on each order of the checking subject according to the summary document and the statement of the dimension of the checking subject, the method further comprises at least one step of:
If the checking result is that the checking is successful, creating a fee reimbursement bill of the order corresponding to the checking result;
And outputting prompt information of failed verification when the verification result is failed verification, and/or creating a sales bill and an return bill, wherein the sales bill and the return bill are used for adjusting the accounting data of the order corresponding to the verification result.
Optionally, the method further comprises:
And under the condition that the order state is the completed newly-added state, creating a sales bill and a return bill 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.
Optionally, the method further comprises:
According to the statement, determining a proportional relationship between the expenditure amount of the checking subject and the order real receipt amount of the checking subject;
and predicting the sales performance of the checking subject and/or the expense of the checking subject according to the proportion relation.
In a second aspect, to achieve the above object, an embodiment of the present application provides a reconciliation apparatus, including:
The order acquisition module is used for periodically acquiring order information according to the first time length, wherein the order information comprises sales order information and after-sales order information of the electronic commerce platform and return order information of the warehouse;
the summarized bill generation module is used for generating summarized bills corresponding to the acquired order information according to the acquired order information; the summarized documents comprise summarized documents of product dimension and summarized documents of checking main body dimension, and the checking main body comprises an e-commerce platform and/or an e-commerce store;
the inventory checking module is used for checking the first ex-warehouse data of each type of product with the second ex-warehouse data of the corresponding type of product in the warehouse management system in the summarized bill of the product dimension, and checking the first warehouse-in data of each type of product with the second warehouse-in data of the corresponding type of product in the warehouse management system;
The statement generation module is used for generating a statement of each checking subject according to a pre-configured expense item field and the accounting details of the checking subject in a second time length; wherein the second time length includes a plurality of the first time lengths;
And the account checking module is used for checking accounts of each order of the checking main body according to the summary bill and the statement of the dimension of the checking main body.
In a third aspect, to achieve the above object, an embodiment of the present application provides a reconciliation system, including a transceiver, a memory, a processor, and a computer program stored on the memory and running on the processor, the processor implementing the reconciliation method as described in the first aspect when executing the computer program.
In a fifth aspect, to achieve the above object, an embodiment of the present application provides a readable storage medium having stored thereon a program or instructions which, when executed by a processor, implement the reconciliation method as described in the first aspect.
In a sixth aspect, to achieve the above object, an embodiment of the present application provides a computer program product having stored thereon a program or instructions which, when executed by a processor, implement the reconciliation method as defined in the first aspect.
The technical scheme of the application has the following beneficial effects:
According to the checking method, first, order information is periodically acquired according to a first time length, wherein the order information comprises sales order information and after-sales order information of an electronic commerce platform and return order information of a warehouse; secondly, generating a summary document corresponding to the order information acquired at this time according to the order information acquired at each time; the summarized documents comprise summarized documents of product dimension and summarized documents of checking main body dimension, and the checking main body comprises an e-commerce platform and/or an e-commerce store; here, the product inventory is checked by utilizing the summary document of the product dimension, so that daily check of the product inventory from the order dimension can be realized, and the problems of slow manual rechecking and low inventory commodity management efficiency in the prior art are solved; thirdly, checking the first ex-warehouse data of each type of product in the summary document of the product dimension with the second ex-warehouse data of the corresponding type of product in the warehouse management system, and checking the first warehouse-in data of each type of product with the second warehouse-in data of the corresponding type of product in the warehouse management system; then, generating a statement of the checking subject according to a pre-configured expense item field and accounting details of the checking subject in a second time length for each checking subject; wherein the second time length comprises at least one of the first time lengths; and finally, according to the summary bill and the statement of the dimension of the checking main body, performing accounting checking on each order of the checking main body. Thus, the accounting check and the inventory check can be realized in one system, the problems of the input and output of orders and the relative stripping of accounts receivable in the conventional electronic commerce platform order management are solved, the consistency of the order-accounts receivable-goods check is realized, namely the accounts receivable in order dimension and the income check of goods are realized, so that the manual check amount can be reduced, and the account checking efficiency is improved.
Detailed Description
In order to make the technical problems, technical solutions and advantages to be solved more apparent, the following detailed description will be given with reference to the accompanying drawings and specific embodiments.
An embodiment of the present application provides a reconciliation method, as shown in fig. 1, including:
Step 101, periodically acquiring order information according to a first time length, wherein the order information comprises sales order information and after-sales order information of an electronic commerce platform and return order information of a warehouse; here, the first time period may be one natural day, for example, the step may obtain sales order information and after-sales order information of the current day e-commerce platform and return order information of the warehouse for 17:00 of each natural day. Specifically, sales order information and after-sales order information can be obtained from the background of the e-commerce platform, and return order information can be obtained from a warehouse management system (Warehouse MANAGEMENT SYSTEM, WMS); or obtain such order information from an order center; the sales order information may include, as shown in fig. 5, receiving information (receiving address, receiving information, etc.), next person information (member code, member name, contact information, etc.) and commodity information (commodity name, next product number, number of orders, original order amount, actual order amount, etc.);
Step 102, generating summary documents corresponding to the order information acquired at this time according to the order information acquired at each time; wherein the summary document comprises a summary document of a product dimension and a summary document of a check subject dimension, the summary document of the product dimension comprising summary data of each type of product (e.g., ex-warehouse data, in-warehouse data, order amount, etc. of each type of product); the checking main body comprises an e-commerce platform and/or an e-commerce store; that is, the summary document of the dimension of the checking main body is, for example, the summary document of the dimension of the e-commerce platform or the summary document of the dimension of the e-shop, and the user can set the summary document according to the requirement;
Among them, as shown in fig. 7 (the collating subjects are electric shops), each collating subject forms a row of information including settlement date, online store code, online store name, document type (sales order/after-sales order), document status (not generated/generated), order number/return number, product category number, shipment total number/return total number, return order amount, etc. among the collating subjects' collating documents;
Step 103, checking the first ex-warehouse data of each type of product with the second ex-warehouse data of the corresponding type of product in a warehouse management system in the summary document of the product dimension, and checking the first warehouse-in data of each type of product with the second warehouse-in data of the corresponding type of product in the warehouse management system; wherein, in the summary document of the product dimension, each product corresponds to a row of information, wherein each row of information comprises a product number, a product type, a product name, a product unit, an order quantity, a shipping quantity, a freezing quantity, a return quantity, a platform real return quantity, a suspension quantity and the like, wherein the platform real return quantity can be acquired from an e-commerce platform, and the platform real return quantity is applicable to a small pay and after-sale interception scene and the like in a refund service, based on the summary document of the product dimension, the total ex-warehouse number (first ex-warehouse data) and the total warehouse-in number (first warehouse-in data) of each type of product on the current day can be acquired, and based on the acquired first ex-warehouse data and first warehouse-in data, the actual inventory (provided by a warehouse management system) of each product is checked, and the inventory check is realized, wherein when the first warehouse-in data and the second warehouse-in data are the same, the first ex-warehouse data and the second warehouse-out data are the same, indicating that the product check is successful every day; when the first warehouse-in data and the second warehouse-in data are different, or the first warehouse-out data and the second warehouse-out data are different, the failure of checking the product inventory is indicated, namely, the sales or operation data are inconsistent with the actual inventory data in the warehouse management system, and at the moment, a notification message can be output so as to check the data again by related personnel; thus, the inventory commodity management efficiency is improved, and the problem of low manual rechecking efficiency is solved;
Step 104, for each checking subject, generating statement of the checking subject according to the preconfigured fee item field and the accounting details of the checking subject in the second time length; wherein the second time length includes a plurality of the first time lengths; for example, the second time length is one week or one month, etc., and of course, the second time length may be the same as the first time length, for example, all natural days; here, the fee item field includes, for example, but is not limited to, at least one of: deduction fee items, marketing fee items, insurance fee items, software service fee items, transaction collection fee items, transaction refund fee items, supply and sell platform transaction fee items, public welfare donation fee items;
The accounting details in the above steps are as shown in fig. 11, and include, but are not limited to, the following: accounting serial number, business serial number, merchant order number, merchant name, time of occurrence, account number of the other party, income amount, expenditure amount, account balance, transaction channel, business type, business description, business bill, business order, business foundation, single number and the like; the statement of accounts in the above steps is shown in fig. 8 and 9, and includes the amount corresponding to the expense item field of each platform and the amount corresponding to the template field of each standard platform;
Here, it should be noted that, based on the step 104, the method should further include: the configuration page of the expense item field is shown in fig. 2 and 3, and first, as shown in fig. 2, a standard template caliber field is configured, wherein the standard template caliber field includes, but is not limited to, the following fields: field 1: partial adjustment-manual filling of adjustment amount (accounting for part of billing part no ticket type amount fee); field 2: accounting invoice (counting the amount of the expense with the ticket); field 3: check-up should be accepted (account for order-up should be accepted); field 4: difference adjustment (counting the amount of ticketless fees); field 5: others (accounting for other reasons-caused reconciliation); secondly, the caliber of the platform is corresponding to the caliber of the standard template, wherein the field 3 of the caliber of the standard template is as follows: the corresponding platform caliber of the check to be checked includes: field 1: deduction (deduction use: fund issuing task), field 3:0020001 transaction refund-balance refund, field 4:0010002 transaction collect-pre-sell order (buyer liability not refund), field 5:0010001 transaction collection-transaction collection; "field 2 with standard template caliber: the platform caliber corresponding to the account deduction invoice comprises: field 2: 0030129-software service fee-third party facilitator service fee (platform billing); "field 1 with standard template caliber: the platform caliber corresponding to the partial adjustment-manual filling adjustment amount comprises: field 6: deduction (deduction use: × alliance commission deduction), field 7: deduction (deduction use: alliance generalized commission return), field 8:0060011 marketing expenditure-guest commission;
Step 105, according to the summary document and statement of dimension of the checking subject, performing accounting checking on each order of the checking subject; specifically, the method comprises the following steps: and accumulating the summarized documents of the dimension of the checking subject corresponding to the same checking subject in the time length corresponding to the checking subject to check the accumulated result with the checking subject, wherein a page diagram of one checking result in the step is shown in fig. 10, and the difference amount of each checking subject is displayed.
In the reconciliation method of the embodiment of the application, first, order information is periodically acquired according to a first time length, wherein the order information comprises sales order information and after-sales order information of an electronic commerce platform and return order information of a warehouse; secondly, generating a summary document corresponding to the order information acquired at this time according to the order information acquired at each time; the summarized documents comprise summarized documents of product dimension and summarized documents of checking main body dimension, and the checking main body comprises an e-commerce platform and/or an e-commerce store; here, the product inventory is checked by utilizing the summary document of the product dimension, so that daily check of the product inventory from the order dimension can be realized, and the problems of slow manual rechecking and low inventory commodity management efficiency in the prior art are solved; thirdly, checking the product inventory according to the summarized documents of the product dimension; then, generating a statement of the checking subject according to a pre-configured expense item field and accounting details of the checking subject in a second time length for each checking subject; wherein the second time length comprises at least one of the first time lengths; and finally, according to the summary bill and the statement of the dimension of the checking main body, performing accounting checking on each order of the checking main body. Thus, the accounting check and the inventory check can be realized in one system, the problems of the input and output of orders and the relative stripping of accounts receivable in the conventional electronic commerce platform order management are solved, the consistency of the order-accounts receivable-goods check is realized, namely the accounts receivable in order dimension and the income check of goods are realized, so that the manual check amount can be reduced, and the account checking efficiency is improved.
As an alternative implementation, step 104 includes:
Matching the data in the accounting details with the expense item fields for each order of the checking main body to obtain the data of each expense item field; specifically, the step may be to obtain an amount corresponding to each expense item field (sum of amounts of a plurality of business descriptions corresponding to the expense item field) based on matching of the business descriptions in the accounting details with the expense item field; wherein, the description of the service can be seen in fig. 12;
and generating the statement according to the data of the expense item fields of the respective orders obtained by matching, wherein the statement generated in the step is shown in fig. 8 and 9.
Further, as an optional implementation, before step 105, the method further includes:
Determining an order state of an order to be checked; wherein the order status includes a completed new status, a checked incomplete status, or an uncore status; here, the completed new status means that the order is checked in the history bill, but the expense or income of the order, such as refund of the order, occurs in the latest bill (bill obtained in the present period); in short, the completed new state refers to a new fee appearing on the order after the checking is completed, for example, a refund scene appears on the order after the checking is completed; the checked unfinished state means that the order to be checked has been checked at least once, the checking result fails to check, and the checked times are less than the preset rolling checking times; the uncore state means that the order to be checked is uncore;
On this basis, step 105 includes:
and under the condition that the order state is a checked unfinished state or an unchecked state, according to the summary bill and the statement of the checking main dimension, carrying out accounting checking on the order to be checked.
That is, when accounting is performed on an order to be checked, firstly, the state of the order to be checked needs to be determined, and secondly, accounting is performed on an order that is not checked.
As a specific implementation manner, according to the summary document and the statement of the dimension of the checking subject, performing accounting checking on the order to be checked includes:
extracting data of the expense item field of the order to be checked from the statement;
Calculating the actual receiving amount of the order to be checked according to the extracted data of the expense item field of the order to be checked; here, the fee items corresponding to the actual amounts of the different e-commerce platforms are different, and specifically, see the following table 1, where the actual amounts are the sum of the amounts of the fee items corresponding to the actual amounts:
Table 1 examples of amounts for different platforms
Platform name |
The corresponding field of the running water is composed (corresponding order management system order amount) |
Remarks |
Platform 1 |
Order real payment should be made, platform real patch, platform patch_freight, actual arrival patch, actual tone payment patch, actual tone month marketing patch and order refund |
|
Platform 2 |
Aggregate revenue (Yuan) -order refund (Yuan) |
|
Platform 3 |
Order entry-refund |
|
Platform 4 |
Revenue-refund + balance payment |
Field head = type, corresponding amount head = field head = type of refund received, refund corresponding amount = payout |
Platform 5 |
Transaction payment + transaction refund |
Income rising = expense type, corresponding amount rising = expense amount (meta) refund rising = business type, corresponding amount = expense amount (meta) |
Platform 6 |
Should receive |
Transaction payment head = business type, amount corresponds to: refund head-up = business type for payment amount transaction, amount corresponds to: income amount |
Platform 7 |
0010002 Trade revenue-order revenue +0010005 trade revenue-coupon settlement +0020005 trade refund-coupon settlement +0020002 trade refund-order refund |
Field head = merchant payable/payable, corresponding amount head = amount |
Acquiring receivable amount of the order to be checked from the summary document of the dimension of the checking main body;
According to the actual receipt amount, the receivable amount and a pre-configured difference threshold, performing accounting checking on the order to be checked; specifically, when the absolute value of the difference between the receivable amount and the actual receivable amount is smaller than the difference threshold, the checking result of the order is indicated to be successful.
In the optional implementation mode, various expenditure and order-related expense details can be accurately identified based on the checking bill, the manual statistics workload is reduced, checking is performed based on the checking bill and the summary bill of the dimension of the checking main body, intelligent checking of the checking main body is realized, the checking efficiency is improved, and the manual checking workload is reduced.
As a more specific implementation manner, according to the real receipt amount, the receivable amount and a pre-configured difference threshold, performing accounting checking on the order to be checked includes:
calculating the difference value between the receivable amount and the actual receivable amount;
when the absolute value of the difference value is smaller than or equal to the difference threshold value, determining that the order to be checked is checked, and checking the order to be checked;
And when the absolute value of the difference value is larger than the difference threshold value, performing accounting checking on the order to be checked according to the preset rolling checking times and the difference value.
That is, when the difference between the receivable amount and the actual receivable amount is less than or equal to the difference threshold, it indicates that the difference between the receivable amount and the actual receivable amount is within the allowable error range, which indicates that the order is successful in reconciliation, and when the difference between the receivable amount and the actual receivable amount is greater than the difference threshold, it indicates that the difference between the receivable amount and the actual receivable amount is outside the allowable error range, it needs to further determine whether the number of times of reconciliation of the order reaches the preset number of times of rolling reconciliation, so as to determine whether the reconciliation result of the order is successful or failed.
In the more specific implementation manner, the rolling account checking times are set, so that the repeated account checking of the same order can be realized, the problems that each expense of an e-commerce platform is different from the expense money returning mode, the expense condition and the expense money returning detail of the single order cannot be identified by a set of method only for total income, a great deal of risks are caused to the expense management of financial staff, the expense is increased, abnormal money returning orders cannot be clearly positioned, and the expense money returning abnormality possibly caused by service operation problems cannot be identified are solved.
Based on the above more specific implementation manner, the method of the embodiment of the present application further includes: the difference amount and the rolling account number are configured, wherein the configuration page of the difference amount and the rolling account number is shown in fig. 4, the difference value is set as the difference threshold value in fig. 4, and the check number limit corresponds to the rolling account number.
Specifically, when the absolute value of the difference is greater than the difference threshold, performing accounting checking on the order to be checked according to the preset rolling checking times and the difference, including:
When the checking times of the to-be-checked orders are smaller than the rolling checking times, determining that the to-be-checked orders are not checked, and updating checked times and checked amount of the to-be-checked orders; here, updating the checked number of times of the order to be checked to be 1 added to the checked number of times, and checking the amount to be the amount of which checking is completed;
or when the checking times of the orders are equal to the rolling checking times, determining that the orders to be checked are checked, and the checking result is check failure.
In short, subtracting the real amount (real amount determined according to statement) in the table 1 from the receivable amount in the summary document of the checking subject dimension to obtain a result, checking the result with the difference amount (corresponding to the difference threshold) in the checking rule, and if the result is within the fault tolerance range of the difference amount, determining that checking is successful; if the result is out of the difference amount fault tolerance range and the order rolling checking times are not consumed (checked times are smaller than rolling checking times), the order is regarded as not checked, and the order can enter the next rolling checking range; if the result is out of the fault tolerance range of the difference amount and the checking number is consumed (the checked number is equal to the rolling checking number), the checking is considered to be failed.
Further, as an optional implementation manner, after step 105, the method further includes at least one of the following steps:
if the checking result is that the checking is successful, creating a fee reimbursement bill of the order corresponding to the checking result; the charge reimbursement bill is used for charge reimbursement, so that an execution subject (such as a reimbursement system) of the charge reimbursement method of the embodiment of the application can send the charge reimbursement bill to a financial system after the charge reimbursement bill is created so as to execute a charge reimbursement flow in the financial system;
Outputting prompt information of failed verification when the verification result is failed verification, and/or creating a sales bill and an return bill, wherein the sales bill and the return bill are used for adjusting the accounting data of an order corresponding to the verification result;
Here, after only the prompt information of the failed collation is output, the adjustment may be manually performed by the staff; when only a sales bill and a return bill are created or prompt information is output and the sales bill and the return bill are created, adjustment and difference adjustment can be carried out based on the created sales bill and the return bill, wherein the sales amount of the sales bill is the difference value between the receivable amount and the actual receivable amount, and thus the actual receivable amount can be adjusted based on the sales bill, so that the difference value between the receivable amount and the actual receivable amount is within a 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 the actual inventory and the inventory determined according to the order information can be ensured to be the same.
According to the realization modes, the corresponding fee item amount can be automatically brought out according to the account checking result and the fee analysis result of the checking main body, and an electric business balance and fee reimbursement flow can be directly initiated for the account data correction, so that the operation is more convenient, and the occurrence of the condition of manual error input and error recording is reduced; namely: corresponding receivables accounting and stock deduction or stock increase can be completed in time in the accounting system, order return and support check are completed weekly or monthly according to platform return rules or reconciliation actual demands, the system automatically checks, abnormal non-return orders or abnormal expenditure orders are automatically identified, and the accuracy of the receivables can be ensured.
Further, as another alternative implementation, the method further includes:
And under the condition that the order state is the completed newly-added state, creating a sales bill and a return bill 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.
Here, it should be noted that, the application scenarios of the above alternative implementation manner are: the order to be checked is checked in the history checking process, and the bill detail obtained in the checking period again comprises the detail of the order (such as refund for the order). Taking the bill to be checked as an order A as an example, the order A is checked and completed in the last checking period, and the refund detail of the order A is acquired in the checking period, at this time, a sales bill and a refund bill can be created based on the refund detail acquired in the checking period so as to level the refund on account. The specific contents of the sales document and the return document are the same as those of the sales document and the return document of the previous alternative implementation, and the description thereof will not be repeated here.
Further, as yet another alternative implementation, the method further includes:
According to the statement, determining a proportional relationship between the expenditure amount of the checking subject and the order real receipt amount of the checking subject; that is, the present step is: firstly, obtaining the sum of the real receipt and the sum of the expenditure of each order of the same checking main body in the statement, and secondly, calculating the ratio of the two sums to obtain the proportional relation of the expenditure and the real receipt; wherein, when calculating the above-mentioned proportional relation in a period of time, the influence of special conditions (such as sales promotion) on the proportional relation can be adjusted in a weighted manner, for example, sales performance of 7 months is predicted according to the proportional relation of 6 months, and since the sales promotion exists in 6 months, the proportional relation of 6 months can be multiplied by a pre-configured coefficient to be used as the predicted proportional relation of 7 months;
predicting sales performance of the collation subject and/or expense of the collation subject according to the proportional relationship; here, the sales performance of the collation subject may be expressed in terms of sales/order actual amount of the collation subject.
In still another alternative implementation, an example of predicting sales performance of the collation subject based on the proportional relationship is: the 1 ten thousand yuan of expenditure in the last year 1 month produces 100 ten thousand sales results, the proportion relation of the expenditure in the last year 1 month and the actual receipt amount is 1%, in the 1 month of the present year, the expenditure in the last year 1 month is cut off to 1 month 10 days, the expenditure in the 1 ten thousand yuan is produced, the expenditure in the 1 month of the present year can be predicted to produce 3 ten thousand yuan, and the sales results produced in the 1 month of the present year are predicted to be 300 ten thousand yuan according to the proportion relation of the 1 month of the present year.
In still another alternative implementation, an example of predicting the expense of the collation subject based on the proportional relationship is: assuming that the proportional relationship between the payout amount in the last year and the actual payout amount is 1%, and the sales performance of the verification subject in the present year is 1 million yuan, the payout amount in the present year is predicted to be 1 million×1% =10 ten thousand yuan.
Here, it should be noted that, at present, the e-commerce sales scenario already covers most enterprises, but the e-commerce platform is a great difficulty in goods in-out and in-storage management and accounting management. Each daily platform sells goods delivery data and returns goods data statistics manual statistics difficulty, each electronic commerce platform checks that the order should be received, the order is received in fact, the order cost is difficult, in order to facilitate the electronic commerce order and the actual operation of commodity inventory management operators and the financial reconciliation capability of the electronic commerce, the goods management, the financial account receivable management, the cost and the budget management capability of enterprises to the electronic commerce business are improved through technical means. Based on the method, the summary bill of the product dimension and the summary bill of the checking main body dimension are generated through order information, so that the product inventory is checked based on the summary bill of the product dimension, and the account checking is performed based on the summary bill of the checking main body dimension and the statement generated according to the bill detail, thus, the checking of the inventory and the account processing in the order dimension is achieved, daily checking in one system can be realized, the inventory commodity management efficiency is improved, the problem of low manual checking efficiency is solved, the order-receivables-goods consistency checking is realized, the account checking delay is avoided, and the receivables and the income checking of the goods in the order dimension can be realized when the order quantity is large; the problems that a large number of expense items are paid through different manual check platforms, the associated expense details of various expenses and orders cannot be accurately identified, and manual statistics workload is large are solved; in addition, in the order dimension account checking process, a rolling checking mechanism is innovatively introduced, so that the problems that all expense and expense payment modes of an e-commerce platform are different, a set of expense conditions and expense payment details of a single order cannot be identified only by a total income mode, a great deal of risks are caused for expense management of financial staff, the expense which cannot be identified is increased, abnormal expense payment orders cannot be clearly positioned, and the expense payment abnormality possibly caused by service operation problems cannot be identified are solved. In addition, in the embodiment of the application, after the checking is finished, corresponding receivables and stock deductions or stock increases can be finished in time in the accounting system, the order back payment and the support checking are finished every week or every month according to the platform back payment rule or the checking actual demand, the system automatically checks, abnormal non-back payment orders or abnormal expenditure orders are automatically identified, and the accuracy of the accounts to be received is ensured.
Briefly, the reconciliation method of the embodiment of the present application may include the steps of:
First: identifying and configuring various expense items of the e-commerce platform statement; specifically, according to the statement of the platform E-commerce, the names of income and expense items and expense scenes of various different order scenes are identified, and the corresponding financial settlement expense caliber and financial settlement mode of the expense are configured in the system;
Second,: setting account checking difference amount and order rolling account checking frequency rules; specific: according to the settlement rules of the past period and the failure rules of the platform settlement, each platform settlement rule, the difference amount range (corresponding to the difference threshold) and the order rolling settlement times (corresponding to the preconfigured rolling settlement times) are configured, namely, partial e-commerce platform settlement is delayed according to the settlement state of the consumer, and the complete settlement can be completed in a plurality of settlement periods;
Third,: the system automatically checks the order form, the receivable amount and the goods to be put in and put out; specific: the system counts the electronic commerce orders daily to send orders, sent orders, goods delivered, quantity of goods delivered, goods returned and quantity of goods returned, and automatically generates enterprise resource planning (ENTERPRISE RESOURCE PLANNING, ERP) daily-junction bill (summary bill corresponding to the tea dimension and summary bill for checking the main dimension) after the warehouse confirms the stock data;
Fourth,: weekly/monthly platform statement resolution; specific: identifying various expense details in a designated time dimension according to the configured platform account checking expense field and marking an order generated by corresponding expense;
Fifth,: checking the order dimension account amount-real account amount; specific: according to the cost analysis condition in the income flow of each e-commerce platform, the system automatically calculates the real amount of each order, checks the real amount of each order with the amount of the order to be received in the order center, and calculates the difference of the order to be received; more specifically, subtracting the actual amount obtained according to the formula in the table 1 from the amount due to the order in the daily account checking to obtain a result, checking the result with the difference amount in the account checking rule, and if the result is within the fault tolerance range of the difference amount, considering that the account checking is successful; if the result is out of the difference amount fault tolerance range and the order rolling checking times are not consumed, the checking is not completed, and the order can enter the next rolling checking range; if the result is out of the difference amount fault tolerance range and the accounting number is consumed, the accounting is considered to be failed; if the payment item (such as refund) with the completed historical reconciliation appears in the platform flow, the payment item is considered to be abnormal. The system automatically marks the reconciliation states of various orders and supports the processing of different reconciliation results according to different reconciliation states;
sixth: automatic processing of fee management finance; specific: and the corresponding fee item amount is automatically brought out according to the account checking result of the shop platform and the fee analysis result system, and an electronic commerce adjustment and fee account reporting process can be directly initiated for correcting the account data. The operation is convenient, and the error input and error recording caused by manpower is reduced;
seventh: predicting a cost budget; specific: according to the shop account checking result and the various expense result of each platform electric store, the system automatically evaluates the expense utilization rate, calculates the relation between the expense and the business achievement rate, and is used for estimating the next month budget and estimating the annual quarter store expense.
The account checking method provided by the embodiment of the application has the following advantages: on the one hand, on the basis of the conditions of E-commerce order generation and performance achievement, order-goods-receivable data are checked every day, so that accurate accounting and receivable are ensured, and the turnover efficiency of goods in a warehouse for sale is improved; on the other hand, the manual account checking workload is reduced by using the computer computing force, the corresponding cost statistics is ensured to be accurate, and the account checking result can be directly applied to a cost settlement or electronic commerce difference adjustment scene, so that the system is convenient to operate; on the other hand, the configuration is simple, the input result is clear and detailed, and financial staff can conveniently and accurately achieve the management service compliance operation through financial data; and on the other hand, the cost prediction of the electronic commerce is realized, so that the cost prediction of the electronic commerce has a data source basis and the cost proposal has an accurate data basis. The cost prediction of the E-commerce is more accurate, and the use is more efficient.
The embodiment of the application also provides a reconciliation device, as shown in fig. 13, comprising:
the order acquisition module 1301 is configured to periodically acquire order information according to a first time length, where 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 1302, configured to generate a summary document corresponding to the order information acquired at this time according to the order information acquired at each time; the summarized documents comprise summarized documents of product dimension and summarized documents of checking main body dimension, and the checking main body comprises an e-commerce platform and/or an e-commerce store;
The inventory checking module 1303 is configured to check, in the summary document of the product dimension, first ex-warehouse data of each type of product with second ex-warehouse data of a corresponding type of product in a warehouse management system, and check the first in-warehouse data of each type of product with the second in-warehouse data of a corresponding type of product in the warehouse management system;
A statement generation module 1304 configured to generate, for each reconciliation entity, a statement for the reconciliation entity based on the preconfigured fee item field and the accounting details of the reconciliation entity for the second length of time; wherein the second time length includes a plurality of the first time lengths;
And the reconciliation module 1305 is used for performing accounting reconciliation on each order of the reconciliation subject according to the summary document and the statement of the dimension of the reconciliation subject.
Optionally, the statement of account generation module 1304 is specifically configured to: matching the data in the accounting details with the expense item fields for each order of the checking main body to obtain the data of each expense item field; and generating the statement according to the data of the expense item fields of the respective orders obtained by matching.
Optionally, the apparatus further comprises:
the first determining module is used for determining the order state of the order to be checked; wherein the order status includes a completed new status, a checked incomplete status, or an uncore status;
The reconciliation module 1305 is specifically configured to: and under the condition that the order state is a checked unfinished state or an unchecked state, the accounting checks the order to be checked according to the summary bill and the statement of the dimension of the checking main body.
Optionally, the reconciliation module 1305 includes:
An extracting sub-module, configured to extract, from the statement of account, data of the fee item field of the order to be checked;
The calculation sub-module is used for calculating the actual receipt amount of the order to be checked according to the extracted data of the expense item field of the order to be checked;
the acquiring submodule is used for acquiring the receivable amount of the order to be checked from the summarized document of the dimension of the checking main body;
And the account checking sub-module is used for checking accounts of the to-be-checked order according to the actual receivables, the receivables and the preset difference threshold.
Optionally, the reconciliation submodule includes:
The calculating unit is used for calculating the difference value of the receivable amount and the actual receivable amount;
The determining unit is used for determining that the order to be checked is checked and the checking result is successful when the absolute value of the difference value is smaller than or equal to the difference threshold value;
and the checking unit is used for checking accounts of the order to be checked according to the preset rolling checking times and the difference value when the absolute value of the difference value is larger than the difference threshold value.
Optionally, the reconciliation unit is specifically configured to:
When the checking times of the to-be-checked orders are smaller than the rolling checking times, determining that the to-be-checked orders are not checked, and updating checked times and checked amount of the to-be-checked orders;
or when the checking times of the orders are equal to the rolling checking times, determining that the orders to be checked are checked, and the checking result is check failure.
Optionally, the apparatus further comprises at least one of the following modules:
the first creation module is used for creating a fee reimbursement bill of an order corresponding to the checking result when the checking result is successful;
And the processing module is used for outputting prompt information of failed verification and/or creating a sales bill and an return bill when the verification result is failed verification, wherein the sales bill and the return bill are used for adjusting the accounting data of the order corresponding to the verification result.
Optionally, the apparatus further comprises:
and the second creation module is used for creating a sales bill and a return bill 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 under the condition that the order state is the completed newly added state.
Optionally, the apparatus further comprises:
the second determining module is used for determining the proportional relation between the expenditure amount of the checking main body and the actual order receiving amount of the checking main body according to the statement;
and the prediction module is used for predicting the sales performance of the check body and/or the expense of the check body according to the proportion relation.
It should be noted that, the accounting device provided by the embodiment of the present application can implement all the method steps implemented by the embodiment of the accounting method, and can achieve the same technical effects, and detailed descriptions of the same parts and beneficial effects as those of the embodiment of the method in the embodiment are omitted.
To achieve the above object, an embodiment of the present application provides a reconciliation system comprising a transceiver 1410, a processor 1400, a memory 1420, and a program stored on the memory 1420 and executable on the processor 1400; wherein the processor 1400 implements the method of controlling robot displacement applied to the client device as described above or implements the method of controlling robot displacement applied to the server device as described above when executing the program.
The transceiver 1410 is configured to receive and transmit data under the control of the processor 1400.
Wherein in fig. 14, a bus architecture may comprise any number of interconnected buses and bridges, and in particular one or more processors represented by the processor 1400 and various circuits of the memory represented by the memory 1420, linked together. The bus architecture may also link together various other circuits such as peripheral devices, voltage regulators, power management circuits, etc., which are well known in the art and, therefore, will not be described further herein. The bus interface provides an interface. The transceiver 1410 may be a number of elements, i.e., include a transmitter and a receiver, providing a means for communicating with various other apparatus over a transmission medium. The user interface 1430 may also be an interface capable of interfacing with an internal connection requiring device for a different system, including but not limited to a keypad, display, speaker, microphone, joystick, etc.
The processor 1400 is responsible for managing the bus architecture and general processing, and the memory 1420 may store data used by the processor 1400 in performing operations.
It should be noted that, in the reconciliation system provided by the embodiment of the present application, all the method steps implemented by the embodiment of the reconciliation method can be implemented, and the same technical effects can be achieved, and detailed descriptions of the same parts and beneficial effects as those of the embodiment of the method in the embodiment are omitted.
The readable storage medium of the embodiment of the present application stores a program or an instruction, which when executed by a processor, implements the steps in the accounting method described above, and can achieve the same technical effects, and is not described herein again for avoiding repetition.
Wherein, 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 Read-Only Memory (ROM), a random access Memory (Random Access Memory RAM), a magnetic disk or an optical disk.
In an embodiment of the application, the modules may be implemented in software for execution by various types of processors. An identified module of executable code may, for instance, comprise one or more physical or logical blocks of computer instructions which may, for instance, be organized as an object, procedure, or function. Nevertheless, the executables of an identified module need not be physically located together, but may comprise disparate instructions stored in different bits which, when joined logically together, comprise the module and achieve the stated purpose for the module.
Indeed, a module of executable code may be a single instruction, or many instructions, and may even be distributed over several different code segments, among different programs, and across several memory devices. Likewise, operational data may be identified within modules and may be embodied in any suitable form and organized within any suitable type of data structure. The operational data may be collected as a single data set, or may be distributed over different locations including over different storage devices.
Where a module may be implemented in software, taking into account the level of existing hardware technology, a module may be implemented in software, and one skilled in the art may, without regard to cost, build corresponding hardware circuitry, including conventional very large scale integrated circuits or gate arrays, and existing semiconductors such as logic chips, transistors, or other discrete components, to achieve the corresponding functions. A module may also be implemented in programmable hardware devices such as field programmable gate arrays, programmable array logic, programmable logic devices or the like.
Embodiments of the present application further provide a computer program product, which includes computer instructions, where the computer instructions when executed by a processor implement the accounting method as described above, and achieve the same technical effects, and in order to avoid repetition, a detailed description is omitted here.
The exemplary embodiments described above are described with reference to the drawings, many different forms and embodiments are possible without departing from the spirit and teachings of the present application, and therefore, the present application should not be construed as limited to the exemplary embodiments set forth herein. Rather, these exemplary embodiments are provided so that this disclosure will be thorough and complete, and will convey the scope of the application to those skilled in the art. In the drawings, the size of the elements and relative sizes may be exaggerated for clarity. The terminology used herein is for the purpose of describing particular example embodiments only and is not intended to be limiting. As used herein, the singular forms "a", "an" and "the" are intended to include the plural forms as well, unless the context clearly indicates otherwise. It will be further understood that the terms "comprises" and/or "comprising," when used in this specification, specify the presence of stated features, integers, steps, operations, elements, and/or components, but do not preclude the presence or addition of one or more other features, integers, steps, operations, elements, components, and/or groups thereof. Unless otherwise indicated, a range of values includes the upper and lower limits of the range and any subranges therebetween.
It should be appreciated that reference throughout this specification to "one embodiment" or "an embodiment" means that a particular feature, structure or characteristic described in connection with the embodiment is included in at least one embodiment of the present application. Thus, the appearances of the phrases "in one embodiment" or "in an embodiment" in various places throughout this specification are not necessarily all referring to the same embodiment. Furthermore, the particular features, structures, or characteristics may be combined in any suitable manner in one or more embodiments.
In various embodiments of the present application, it should be understood that the sequence numbers of the following processes do not mean the order of execution, and the order of execution of the processes should be determined by the functions and internal logic, and should not constitute any limitation on the implementation process of the embodiments of the present application.
In addition, the terms "system" and "network" are often used interchangeably herein.
In the embodiments provided herein, it should be understood that "B corresponding to a" means that B is associated with a from which B may be determined. It should also be understood that determining B from a does not mean determining B from a alone, but may also determine B from a and/or other information.
While the foregoing is directed to the preferred embodiments of the present application, it will be appreciated by those skilled in the art that various modifications and adaptations can be made without departing from the principles of the present application, and such modifications and adaptations are intended to be comprehended within the scope of the present application.