[go: up one dir, main page]

CN118537153B - Account reconciliation method, device, system, storage medium and program product - Google Patents

Account reconciliation method, device, system, storage medium and program product Download PDF

Info

Publication number
CN118537153B
CN118537153B CN202410977938.2A CN202410977938A CN118537153B CN 118537153 B CN118537153 B CN 118537153B CN 202410977938 A CN202410977938 A CN 202410977938A CN 118537153 B CN118537153 B CN 118537153B
Authority
CN
China
Prior art keywords
order
product
checked
reconciliation
checking
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Active
Application number
CN202410977938.2A
Other languages
Chinese (zh)
Other versions
CN118537153A (en
Inventor
张阁
张迎娴
彭湖志
谢国旭
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Ausnutria Dairy China Co ltd
Original Assignee
Ausnutria Dairy China Co ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Ausnutria Dairy China Co ltd filed Critical Ausnutria Dairy China Co ltd
Priority to CN202410977938.2A priority Critical patent/CN118537153B/en
Publication of CN118537153A publication Critical patent/CN118537153A/en
Application granted granted Critical
Publication of CN118537153B publication Critical patent/CN118537153B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q40/00Finance; Insurance; Tax strategies; Processing of corporate or income taxes
    • G06Q40/12Accounting
    • G06Q40/125Finance or payroll
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00Administration; Management
    • G06Q10/08Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
    • G06Q10/087Inventory or stock management, e.g. order filling, procurement or balancing against orders

Landscapes

  • Business, Economics & Management (AREA)
  • Engineering & Computer Science (AREA)
  • Accounting & Taxation (AREA)
  • Finance (AREA)
  • Economics (AREA)
  • Marketing (AREA)
  • Physics & Mathematics (AREA)
  • Theoretical Computer Science (AREA)
  • Development Economics (AREA)
  • General Physics & Mathematics (AREA)
  • General Business, Economics & Management (AREA)
  • Strategic Management (AREA)
  • Operations Research (AREA)
  • Tourism & Hospitality (AREA)
  • Quality & Reliability (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Human Resources & Organizations (AREA)
  • Technology Law (AREA)
  • Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)

Abstract

本申请提供一种对账方法、装置、系统、存储介质及程序产品,包括:按照第一时间长度,周期性的获取订单信息;根据每次获取的订单信息,生成对应的汇总单据;汇总单据包括产品维度的汇总单据和核对主体维度的汇总单据;将产品维度的汇总单据中,各类型的产品的第一出库数据与仓储管理系统中对应类型的产品的第二出库数据进行核对,并将各类型的产品的第一入库数据与仓储管理系统中对应类型的产品的第二入库数据进行核对;针对每一个核对主体,根据费用项字段和核对主体在第二时间长度内的账务明细,生成核对主体的对账单;根据核对主体维度的汇总单据和对账单,对核对主体的各个订单进行账务核对。如此,解决了对账效率低且人工核对量大的问题。

The present application provides a reconciliation method, device, system, storage medium and program product, including: periodically obtaining order information according to a first time length; generating corresponding summary documents according to the order information obtained each time; the summary documents include summary documents of product dimension and summary documents of verification subject dimension; checking the first outbound data of each type of product in the summary document of product dimension with the second outbound data of the corresponding type of product in the warehouse management system, and checking 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; for each verification subject, generating a reconciliation statement of the verification subject according to the expense item field and the account details of the verification subject within the second time length; and performing account reconciliation on each order of the verification subject according to the summary document and reconciliation statement of the verification subject dimension. In this way, the problems of low reconciliation efficiency and large amount of manual reconciliation are solved.

Description

Accounting method, device, system, storage medium and program product
Technical Field
The present application relates to the field of accounting management, and in particular, to an accounting method, apparatus, system, storage medium and program product.
Background
At present, checking accounts of business electronic commerce mainly include accounting checking and inventory checking, wherein the accounting checking mainly checks a plurality of conditions such as receivable goods money, actual received goods money, order ticket cost, order ticket-free cost and the like, and the inventory checking mainly checks the quantity to be sent, the actual quantity to be sent, the quantity to be returned, the actual quantity to be returned and the like. In the conventional e-commerce platform order management, the order is put in and the accounts receivable are relatively stripped, so that the overall account checking efficiency is low and the manual checking amount is huge.
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.
Drawings
FIG. 1 is a flow chart of a reconciliation method in accordance with an embodiment of the application;
FIG. 2 is a diagram of one of the configuration pages of the expense item field in an embodiment of the present application;
FIG. 3 is a second exemplary configuration page of the expense item field according to the present application;
FIG. 4 is a schematic diagram of a configuration page of the account difference amount and the scroll account number in an embodiment of the present application;
FIG. 5 is a schematic diagram of sales order information in an embodiment of the present application;
FIG. 6 is a schematic diagram of summary documents of product dimensions in an embodiment of the application;
FIG. 7 is a schematic diagram of summary documents for reconciling principal dimensions in an embodiment of the application;
FIG. 8 is one of the page views of the statement of account in an embodiment of the application;
FIG. 9 is a second schematic diagram of pages of an statement of account in an embodiment of the application;
FIG. 10 is a schematic diagram of a page of the reconciliation result in an embodiment of the application;
FIG. 11 is a schematic diagram of accounting details in an embodiment of the present application;
FIG. 12 is a schematic page view of the business description of FIG. 11;
FIG. 13 is a schematic diagram of a reconciliation apparatus in accordance with an embodiment of the application;
Fig. 14 is a schematic diagram of a reconciliation system in accordance with an embodiment of the application.
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.

Claims (11)

1.一种对账方法,其特征在于,包括:1. A reconciliation method, characterized by comprising: 按照第一时间长度,周期性的获取订单信息,所述订单信息包括电商平台的销售单信息和售后单信息,以及仓库的退货单信息;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.根据权利要求1所述的方法,其特征在于,根据预先配置的费用项字段和所述核对主体在第二时间长度内的账务明细,生成所述核对主体的对账单,包括:2. The method according to claim 1, characterized in that 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 comprises: 针对所述核对主体的每一个订单,将所述账务明细中的数据与所述费用项字段匹配,获得各个所述费用项字段的数据;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.根据权利要求1所述的方法,其特征在于,根据所述实收金额、所述应收金额和预先配置的差异阈值,对所述待核对订单进行账务核对,包括: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, performing account verification on the order to be verified comprises: 计算所述应收金额和所述实收金额的差值;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.根据权利要求3所述的方法,其特征在于,在所述差值的绝对值大于所述差异阈值时,根据预先配置的滚动对账次数和所述差值,对所述待核对订单进行账务核对,包括: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 a pre-configured rolling reconciliation number and the difference, comprising: 在所述待核对订单的对账次数小于所述滚动对账次数时,确定所述待核对订单未完成核对,并更新所述待核对订单的已核对次数及已对账金额;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.根据权利要求1至4任一项所述的方法,其特征在于,根据所述核对主体维度的汇总单据和所述对账单,对所述核对主体的各个订单进行账务核对之后,所述方法还包括以下至少一个步骤: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.根据权利要求1所述的方法,其特征在于,所述方法还包括: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.根据权利要求1所述的方法,其特征在于,所述方法还包括: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.一种对账装置,其特征在于,包括:8. A reconciliation device, comprising: 订单获取模块,用于按照第一时间长度,周期性的获取订单信息,所述订单信息包括电商平台的销售单信息和售后单信息,以及仓库的退货单信息;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.一种对账系统,包括:包括收发机、存储器、处理器及存储在所述存储器上并在所述处理器上运行的计算机程序,其特征在于,所述处理器执行所述计算机程序时实现如权利要求1至7中任一项所述的对账方法。9. A reconciliation system, comprising: 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.一种可读存储介质,其上存储有程序或指令,其特征在于,所述程序或指令被处理器执行时实现如权利要求1至7中任一项所述的对账方法。10. A readable storage medium having a program or instruction stored thereon, wherein 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.一种计算机程序产品,其特征在于,包括计算机指令,所述计算机指令被处理器执行时实现如权利要求1至7中任一项所述的对账方法。11. A computer program product, comprising computer instructions, which, when executed by a processor, implement the reconciliation method according to any one of claims 1 to 7.
CN202410977938.2A 2024-07-22 2024-07-22 Account reconciliation method, device, system, storage medium and program product Active CN118537153B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202410977938.2A CN118537153B (en) 2024-07-22 2024-07-22 Account reconciliation method, device, system, storage medium and program product

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202410977938.2A CN118537153B (en) 2024-07-22 2024-07-22 Account reconciliation method, device, system, storage medium and program product

Publications (2)

Publication Number Publication Date
CN118537153A CN118537153A (en) 2024-08-23
CN118537153B true CN118537153B (en) 2024-11-22

Family

ID=92390316

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202410977938.2A Active CN118537153B (en) 2024-07-22 2024-07-22 Account reconciliation method, device, system, storage medium and program product

Country Status (1)

Country Link
CN (1) CN118537153B (en)

Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN116151733A (en) * 2023-02-10 2023-05-23 广州市天剑计算机系统工程有限公司 Shipping management method and device
CN116385041A (en) * 2023-04-04 2023-07-04 深圳市领星网络科技有限公司 Amazon E-commerce-based cost refinement management system and method

Family Cites Families (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP2004164324A (en) * 2002-11-13 2004-06-10 Oki Electric Ind Co Ltd Processing system and processing method for order-received commodity
US20050209934A1 (en) * 2004-03-17 2005-09-22 Sean Irby System, apparatus and process to provide, replenish, monitor, and invoice consignment inventory with retail customers
CN111221889B (en) * 2018-11-26 2023-06-02 上海阿米特数据系统有限公司 CASS retail data integration service platform
CN115205000B (en) * 2022-06-27 2023-04-18 深圳市数帝网络科技有限公司 Account checking method, account checking terminal and account checking system

Patent Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN116151733A (en) * 2023-02-10 2023-05-23 广州市天剑计算机系统工程有限公司 Shipping management method and device
CN116385041A (en) * 2023-04-04 2023-07-04 深圳市领星网络科技有限公司 Amazon E-commerce-based cost refinement management system and method

Also Published As

Publication number Publication date
CN118537153A (en) 2024-08-23

Similar Documents

Publication Publication Date Title
US7412418B2 (en) Expense tracking, electronic ordering, invoice presentment, and payment system and method
US7970671B2 (en) Automated transaction processing system and approach with currency conversion
US8442917B1 (en) Energy distribution and marketing backoffice system and method
US7716130B2 (en) Invoiceless trading and settlement method and system
US8078531B2 (en) Auditing or determining reductions to card-issuer interchange fees
US8401965B2 (en) Payment handling
US20060095367A1 (en) System and method of supply chain procurement, settlement and finance
US8738476B2 (en) Architectural design for selling standardized services application software
US10127558B2 (en) Expense tracking, electronic ordering, invoice presentment, and payment system and method
US20130339192A1 (en) Method and system for longterm inventory distribution financing and management
US10650359B2 (en) Energy distribution and marketing backoffice system and method
MXPA06010366A (en) Method and system for advancing funds.
US20060277139A1 (en) System and method for credit account management
CN114119089A (en) Internal fund transfer pricing system, method, equipment and medium
KR102288517B1 (en) Server and method for transaction adjustment
CN118537153B (en) Account reconciliation method, device, system, storage medium and program product
CA2520947A1 (en) System and method of supply chain procurement, settlement and finance
JP7162791B1 (en) Information processing device, information processing method, and program
JP2005309697A (en) Credit fluidizing system and credit fluidizing processing method
Yetter et al. No Excuses: Automation Advances Make Sales Tax Collection Easier for Everyone
CN107527282A (en) Continuous dynamic credit financing method and system
JP2003099694A (en) Accounts receivable calculation method
CA2482506A1 (en) System and method of supply chain finance
WO2025076136A1 (en) Variance management systems and methods for generating resource calculations
CN116128501A (en) Clearing process processing method, device, equipment and storage medium

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant