CN110659965A - Control method for automatically reflecting bill difference of takeout order - Google Patents
Control method for automatically reflecting bill difference of takeout order Download PDFInfo
- Publication number
- CN110659965A CN110659965A CN201910903022.1A CN201910903022A CN110659965A CN 110659965 A CN110659965 A CN 110659965A CN 201910903022 A CN201910903022 A CN 201910903022A CN 110659965 A CN110659965 A CN 110659965A
- Authority
- CN
- China
- Prior art keywords
- platform
- order
- bill
- merchant
- take
- 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.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q30/00—Commerce
- G06Q30/06—Buying, selling or leasing transactions
- G06Q30/0601—Electronic shopping [e-shopping]
- G06Q30/0633—Lists, e.g. purchase orders, compilation or processing
- G06Q30/0635—Processing of requisition or of purchase orders
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q20/00—Payment architectures, schemes or protocols
- G06Q20/08—Payment architectures
- G06Q20/10—Payment architectures specially adapted for electronic funds transfer [EFT] systems; specially adapted for home banking systems
- G06Q20/102—Bill distribution or payments
Abstract
The invention relates to a control method for automatically reflecting bill difference of take-out orders, which comprises the steps that a system receives bills of a take-out platform, bills of a system platform and ERP bills of merchants; comparing every order record of the system one by one, and if the orders are the same in the three-party records, the system directly accounts the order; if the records of the three parties are different, the system respectively judges whether the time dimensions and the caliber dimensions of the accounts of the three parties are the same, whether the links of verification and cancellation are not achieved or the accounts are wrong, and records the reason of account bill difference; the actual total difference amount is provided, the reason for the difference of the bill recorded by the system is counted, and the information is provided to the merchant through a report. According to the technical scheme, the bills of the take-out platform, the bills of the system platform and the orders in the ERP bills of the merchants are respectively compared, so that the difference of the unchecked orders in the bills of the three parties and the reasons causing the difference are automatically found and fed back to the corresponding parties, and the corresponding parties can conveniently level or adjust the bills.
Description
Technical Field
The invention belongs to the technical field of network platform management, and particularly relates to a control method for automatically reflecting bill difference of take-out orders.
Background
The selling proportion of goods sold on the internet in China increases year by year, and particularly, online shopping and consumption of young people become a habitual behavior. After an order is generated online and completed by an enterprise participating in online sales, such as a retail enterprise like a commercial supermarket or a convenience store, the take-away platform performs financial accounting for the order of the merchant, and performs reconciliation with the merchant according to the management time limit of the take-away platform, and meanwhile, after the order is completed by the merchant, the merchant also performs corresponding financial accounting in the ERP of the merchant.
However, after the merchant may develop the goods sale or service business on different takeout platforms, such as online business of reaching home in the east of kyoto, takeout in the united states, hungry retail, praise, and online shopping mall built by oneself, in the financial accounting link, due to the existence of data transfer of a plurality of takeout platforms, system platforms, and a plurality of systems of ERP of the merchant, various abnormal situations may exist in the process, so that the takeout platform and ERP accounting of the merchant are not smooth and difficult to check.
Disclosure of Invention
The invention aims to provide a control method for automatically reflecting bill difference of take-out orders so as to solve the problem of account difference between a take-out platform, a system platform and a merchant ERP.
The invention is realized by the following technical scheme:
a control method for automatically reflecting bill differences of take-out orders, comprising the steps of:
step 1, the system receives a bill of a take-out platform, a bill of a system platform and an ERP bill of a merchant;
step 2, the system compares the bill of the take-out platform, the bill of the system platform and each order record in the ERP bill of the merchant one by one, and judges that:
if the records of the three parties are the same for any order, the system can directly tie account for the order;
if the records of the three parties are different, the system judges whether the billing time dimensions of the three parties are the same, if not, the system records that the billing time dimensions are the reason of bill difference;
if the two are the same, the system enters the step 3;
step 3, the system judges whether the accounting caliber dimensions of the three parties are the same, if not, the system records that the accounting caliber dimensions are the reason causing the bill difference and displays the amount corresponding to the caliber difference subject;
if the two are the same, the system enters step 4;
step 4, the system judges whether the verification link is not reached in the records of the three parties, if so, the system records that the verification link is not reached and is the reason of causing bill difference;
if not, the system records that the accounting error is the reason of account difference;
step 5, the system repeats the steps 2 to 4 until all orders are analyzed;
step 6, the system issues the actual total difference amount and counts the reason for the difference of the bill recorded by the system, and the system automatically accounts for the order with the difference only in the step 2 and the step 3;
and 7, displaying the information in the step 6 to a merchant through a report by the system.
The bill of the takeout platform at least comprises a takeout platform order;
the system platform bill at least comprises a system platform order;
the merchant ERP bill at least includes merchant orders.
Before analysis, the system firstly determines whether a corresponding order exists, and the steps are as follows:
step 1, the system extracts any takeout platform order in the takeout platform bill, compares the takeout platform order with a platform order record in a system platform and a merchant order record in a merchant ERP respectively, and judges:
step 2, if the take-out platform order exists in the platform order record of the system platform and the merchant order record in the merchant ERP, determining that the take-out platform order is an effective order, otherwise, recording the take-out platform order as a non-effective order;
step 3, repeating the steps 1 and 2 until all the takeout platform orders in the takeout platform bill are compared;
step 4, the system extracts any merchant order in the ERP bill of the merchant and compares the merchant order with a platform order record in the system platform and a take-out platform order record in the take-out platform respectively;
step 5, if the merchant order in the merchant ERP bill exists in the platform order record of the system platform and the takeout platform order record of the takeout platform, determining that the merchant order is an effective order, otherwise, recording the merchant order as a non-effective order;
step 6, repeating the steps 4 and 5 until all merchant orders in the merchant bill are compared;
and 7, counting the recorded invalid order information in the take-out platform bill and the invalid order information in the merchant bill by the system, and feeding back to the take-out platform and the merchant.
The invention has the beneficial effects that:
according to the technical scheme, the bills of the take-out platform, the bills of the system platform and the orders in the ERP bills of the merchants are respectively compared, so that the difference of the unchecked orders in the bills of the three parties and the reasons causing the difference are automatically found and fed back to the corresponding parties, and the corresponding parties can conveniently level or adjust the bills.
Drawings
FIG. 1 is a logic diagram of the control method of the present invention.
Detailed Description
The technical solutions of the present invention are described in detail below by examples, and the following examples are only exemplary, can be used only for explaining and explaining the technical solutions of the present invention, and are not to be construed as limiting the technical solutions of the present invention.
After a commercial supermarket or convenience store retail enterprise carries out online business such as Jingdong home-to-home, American group takeout, hungry retail, praise and self-built online shopping mall, in a financial accounting link, due to the data circulation of a takeout platform, a system platform and a plurality of systems of the ERP of the merchant, various abnormal conditions exist in the process, so that the takeout platform and the ERP of the merchant are uneven in accounting and difficult to check.
Therefore, a product capable of automatically reflecting the difference between the takeaway order and the financial bookkeeping is provided, the online platform bill, the system platform bill and the merchant ERP bill are centralized in a three-party automatic reconciliation tool of the system platform to reflect the reconciliation result through data collection and analysis, and the difference reason and the difference list are provided.
As shown in fig. 1, a control method for automatically reflecting the bill difference of a takeout order includes the following steps:
step 1, the system receives a bill of a take-out platform, a bill of a system platform and an ERP bill of a merchant; the specific time period is set by three parties according to respective management, and the implementation of the technical scheme of the application is not influenced.
The bill of the take-out platform at least comprises the take-out platform order and can also comprise information such as price and time.
The system platform bill at least comprises a system platform order and can also comprise information such as price, time and the like.
The merchant ERP bill at least comprises merchant orders and can also comprise information such as price, time and the like.
After the system obtains the bill of the take-out platform, the bill of the system platform and the ERP bill of the merchant, the system firstly analyzes the bill of the corresponding take-out platform and the orders in the ERP bill of the merchant to determine whether each order exists or not, so as to avoid the situation that the order which does not exist exists in the bill or one party can miss the order.
The specific analysis steps are as follows:
step one, the system extracts any takeout platform order in the takeout platform bill and compares the takeout platform order with a platform order record in a system platform and a merchant order record in a merchant ERP respectively, wherein the order recorded in the current platform bill is not limited to the order which does not provide verification and sale or does not have verification and sale time; similarly, the merchant order record in the merchant ERP also includes orders that have not been offered for verification or have not had time to verify, and determines:
and step two, if the take-out platform order exists in the platform order record of the system platform and the merchant order record in the merchant ERP, determining that the take-out platform order is an effective order, otherwise, recording the take-out platform order as a non-effective order, and storing the information of the non-effective order by the system.
And step three, repeating the step one and the step two until all the takeout platform orders in the takeout platform bill are compared and finished, and forming invalid order summarizing information in the takeout platform bill.
Step four, the system extracts any merchant order in the ERP bill of the merchant, and the merchant order is respectively recorded with a platform order in the system platform and a takeout platform order in the takeout platform, wherein the takeout platform order in the takeout platform also comprises an order which does not provide verification or does not reach verification time, and the judgment is carried out:
and step five, if the merchant orders in the merchant ERP bill exist in the platform order record of the system platform and the take-out platform order record of the take-out platform, determining that the merchant orders are valid orders, otherwise, recording the merchant orders as invalid orders, and storing the invalid order information by the system.
And step six, repeating the step four and the step five until all the merchant orders in the merchant ERP bill are compared, and forming non-effective order summary information in the merchant ERP bill.
And 7, counting the recorded invalid order information in the take-out platform bill and the invalid order information in the merchant bill by the system, and feeding back to the take-out platform and the merchant so as to facilitate the two parties to confirm the order in time.
Step 2, the system compares the bill of the take-out platform, the bill of the system platform and each order record in the ERP bill of the merchant one by one, wherein the comparison mode is that the first order is analyzed and judged from the first order to the end of the last order:
if the first order is aimed at, if the three records are the same, the system directly accounts the order;
if the records of the three parties are different, the system judges whether the billing time dimensions of the three parties are the same, if not, the system records that the billing time dimensions are the reason of bill difference; in this application, the billing time dimension refers to the recording time range of bills, for example, the takeaway platform is in days as the billing unit, and the merchant bill is in 24 hours as the billing unit, which may result in some records across days, but may also include other recording time ranges.
If the two are the same, the system enters the step 3;
step 3, the system judges whether the accounting caliber dimensions of the three parties are the same, if not, the system records that the accounting caliber dimensions are the reason of causing bill difference; in the present application, the dimension of the billing aperture refers to the accounting standard, and in the technical solution of the present application, the dimension of the billing time, the dimension of the billing aperture, and the following accounting link and billing difference are general terms in accounting.
If the two are the same, the system enters step 4;
and 4, judging whether the verification link is not reached in the records of the three parties by the system, if so, recording that the verification link is not reached by the system and is the reason of bill difference.
If not, the system records that the billing error is the cause of the bill discrepancy.
And 5, repeating the steps 2 to 4 by the system until all orders are analyzed.
Step 6, the system issues the actual total difference amount and counts the reason for the difference of the bill recorded by the system, and the system automatically accounts for the order with the difference only in the step 2 and the step 3; .
And 7, providing the information in the step 6 to the merchant through the system through the report.
After receiving the corresponding information, the merchant can perform manual direct tie-up confirmation or reconciliation of both parties according to needs, and feed back the final processing result to the system.
Although embodiments of the present invention have been shown and described, it will be appreciated by those skilled in the art that changes, modifications, substitutions and alterations can be made in these embodiments without departing from the principles and spirit of the invention, the scope of which is defined in the appended claims and their equivalents.
Claims (3)
1. A control method for automatically reflecting bill differences of take-out orders, comprising the steps of:
step 1, the system receives a bill of a take-out platform, a bill of a system platform and an ERP bill of a merchant;
step 2, the system compares the bill of the take-out platform, the bill of the system platform and each order record in the ERP bill of the merchant one by one, and judges that:
if the records of the three parties are the same for any order, the system can directly tie account for the order;
if the records of the three parties are different, the system judges whether the billing time dimensions of the three parties are the same, if not, the system records that the billing time dimensions are the reason of bill difference;
if the two are the same, the system enters the step 3;
step 3, the system judges whether the accounting caliber dimensions of the three parties are the same, if not, the system records that the accounting caliber dimensions are the reason causing the bill difference and displays the amount corresponding to the caliber difference subject;
if the two are the same, the system enters step 4;
step 4, the system judges whether the verification link is not reached in the records of the three parties, if so, the system records that the verification link is not reached and is the reason of causing bill difference;
if not, the system records that the accounting error is the reason of account difference;
step 5, the system repeats the steps 2 to 4 until all orders are analyzed;
step 6, the system issues the actual total difference amount and counts the reason for the difference of the bill recorded by the system, and the system automatically accounts for the order with the difference only in the step 2 and the step 3;
and 7, displaying the information in the step 6 to a merchant through a report by the system.
2. The control method for automatically reflecting bill differences of take-away orders according to claim 1, wherein the bill of the take-away platform comprises at least a take-away platform order;
the system platform bill at least comprises a system platform order;
the merchant ERP bill at least includes merchant orders.
3. The control method for automatically reflecting bill differences of take orders according to claim 1, wherein said system first determines whether a corresponding order exists before performing the analysis, comprising the steps of:
step 1, the system extracts any takeout platform order in the takeout platform bill, compares the takeout platform order with a platform order record in a system platform and a merchant order record in a merchant ERP respectively, and judges:
step 2, if the take-out platform order exists in the platform order record of the system platform and the merchant order record in the merchant ERP, determining that the take-out platform order is an effective order, otherwise, recording the take-out platform order as a non-effective order;
step 3, repeating the steps 1 and 2 until all the takeout platform orders in the takeout platform bill are compared;
step 4, the system extracts any merchant order in the ERP bill of the merchant and compares the merchant order with a platform order record in the system platform and a take-out platform order record in the take-out platform respectively;
step 5, if the merchant order in the merchant ERP bill exists in the platform order record of the system platform and the takeout platform order record of the takeout platform, determining that the merchant order is an effective order, otherwise, recording the merchant order as a non-effective order;
step 6, repeating the steps 4 and 5 until all merchant orders in the merchant bill are compared;
and 7, counting the recorded invalid order information in the take-out platform bill and the invalid order information in the merchant bill by the system, and feeding back to the merchant.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910903022.1A CN110659965A (en) | 2019-09-24 | 2019-09-24 | Control method for automatically reflecting bill difference of takeout order |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910903022.1A CN110659965A (en) | 2019-09-24 | 2019-09-24 | Control method for automatically reflecting bill difference of takeout order |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110659965A true CN110659965A (en) | 2020-01-07 |
Family
ID=69038782
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910903022.1A Pending CN110659965A (en) | 2019-09-24 | 2019-09-24 | Control method for automatically reflecting bill difference of takeout order |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110659965A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112669008A (en) * | 2020-12-29 | 2021-04-16 | 平安普惠企业管理有限公司 | Bill data verification method and device, computer equipment and storage medium |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20060131392A1 (en) * | 2000-07-12 | 2006-06-22 | Cooper William A | Transaction card system and approach |
| US20090024527A1 (en) * | 2007-07-19 | 2009-01-22 | First Data Corporation | Merchant-initiated adjustments |
| US20140032418A1 (en) * | 2012-07-25 | 2014-01-30 | Lance Weber | Upstream and downstream data conversion |
| US20140337183A1 (en) * | 2008-08-21 | 2014-11-13 | Alibaba Group Holding Limited | Online processing for offshore business transactions |
| CN107945002A (en) * | 2017-12-27 | 2018-04-20 | 长沙海米网络技术有限公司 | A kind of automatic account checking method, system and storage device |
| CN108280636A (en) * | 2018-03-05 | 2018-07-13 | 万帮充电设备有限公司 | Divide account method, apparatus and system |
| CN108416580A (en) * | 2018-03-09 | 2018-08-17 | 万帮充电设备有限公司 | Account checking method, account checking apparatus and electronic equipment |
-
2019
- 2019-09-24 CN CN201910903022.1A patent/CN110659965A/en active Pending
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20060131392A1 (en) * | 2000-07-12 | 2006-06-22 | Cooper William A | Transaction card system and approach |
| US20090024527A1 (en) * | 2007-07-19 | 2009-01-22 | First Data Corporation | Merchant-initiated adjustments |
| US20140337183A1 (en) * | 2008-08-21 | 2014-11-13 | Alibaba Group Holding Limited | Online processing for offshore business transactions |
| US20140032418A1 (en) * | 2012-07-25 | 2014-01-30 | Lance Weber | Upstream and downstream data conversion |
| CN107945002A (en) * | 2017-12-27 | 2018-04-20 | 长沙海米网络技术有限公司 | A kind of automatic account checking method, system and storage device |
| CN108280636A (en) * | 2018-03-05 | 2018-07-13 | 万帮充电设备有限公司 | Divide account method, apparatus and system |
| CN108416580A (en) * | 2018-03-09 | 2018-08-17 | 万帮充电设备有限公司 | Account checking method, account checking apparatus and electronic equipment |
Non-Patent Citations (1)
| Title |
|---|
| 课题组编: "《ERP环境下的财务收支审计指南 上》", November 2013 * |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112669008A (en) * | 2020-12-29 | 2021-04-16 | 平安普惠企业管理有限公司 | Bill data verification method and device, computer equipment and storage medium |
| WO2022142040A1 (en) * | 2020-12-29 | 2022-07-07 | 平安普惠企业管理有限公司 | Billing data verification method and apparatus, computer device and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| WO2019091076A1 (en) | Method and device for managing bill of material, and computer-readable storage medium | |
| TW201319975A (en) | Transaction platform data processing method and system | |
| CN109165956A (en) | Enterprise management system and data acquisition based on product big data utilize method | |
| CN111784466A (en) | Cross-border e-commerce transaction system | |
| US20020069082A1 (en) | Electronic commerce system and operating method thereof | |
| CN115600956A (en) | Method for improving purchasing efficiency in purchasing cooperation | |
| US8484101B2 (en) | Cost management system with flexible unit of measure | |
| US20130006820A1 (en) | System and Method of Determining the Quality of Enhanced Transaction Data | |
| CN111353841B (en) | Document data processing method, device and system | |
| CN110659965A (en) | Control method for automatically reflecting bill difference of takeout order | |
| CN110874745A (en) | Bill return management system | |
| CN115222497B (en) | Financial data verification processing method and system | |
| CN112418748A (en) | Offline reconciliation method and system for e-commerce inventory under distributed architecture | |
| CN116383592A (en) | Real-time computing and analyzing system and method based on Amazon finance | |
| CN111563704A (en) | Warehouse inventory management system | |
| US20070239776A1 (en) | Bonded material monitoring system and method | |
| US20120005040A1 (en) | Methods and systems for capturing value from a payment decline or error | |
| US11017418B1 (en) | Merchant services statements and pricing | |
| CN113792533A (en) | Data processing method, data processing device, storage medium and electronic equipment | |
| CN106204253A (en) | Insider transaction profit and loss data identification, collection and correlating method and device | |
| US20210125289A1 (en) | Business management system and business management method | |
| CN109583995A (en) | A kind of merchant store management backstage of mall system | |
| CN115205000B (en) | Account checking method, account checking terminal and account checking system | |
| JP2003532202A (en) | Method, system and storage medium for analyzing product delivery | |
| Hidayat et al. | Inventory model for deteriorating items with expired time in lost-sales probabilistic demand (Pharmacy case study) |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20200107 |
|
| RJ01 | Rejection of invention patent application after publication |