Logistics industry account checking-based waybill and flow matching method

Abstract

The invention discloses a logistics industry account checking-based waybill and flow matching method. The method comprises the following steps of creating an automatic matching process temporary table; settling an account flow detail list; preprocessing, and calculating missing attributes; preprocessing: according to data features, performing interval marking on the pipeline; preprocessing: marking unprocessed marks on the pipeline details; carrying out matching association on the account income and the expenditure pipeline; post-processing and data verification are carried out; and ending. The account checking method has the beneficial effects that a complicated account checking mode which can only be carried out through manual Excel is improved, and the method can be used for carrying out follow-up account checking through manual operation after account checking of a large number of accounts, so that the account checking efficiency and the account checking quality are greatly optimized and improved.

Description

Technical Field

[0001] The present application belongs to the field of data processing technology in the logistics industry, and specifically relates to a method for matching waybills and flow sheets based on account reconciliation in the logistics industry. Background Art

[0002] A certain system logistics platform contains two main modules: waybills and accounts. The shipper enters the waybill on the platform and pays the freight of the waybill to the team leader's account through the shipper's account. The team leader's account can then pay the driver's bank card based on the waybill according to the situation, and can also directly withdraw cash from the account. For the direct withdrawal method, there is no relevant waybill information in the platform's transaction details, which makes account reconciliation inconvenient. Summary of the invention

[0003] The purpose of this application is to provide a method for matching waybills and flow records based on account reconciliation in the logistics industry, thereby solving the problem of inconvenience in reconciliation using traditional reconciliation methods on logistics platforms.

[0004] The purpose of this application is achieved through the following technical solutions:

[0005] A method for matching waybills and flow sheets based on account reconciliation in the logistics industry comprises the following steps:

[0006] Step 1, start; create a temporary table for the automated matching process;

[0007] The second step is to sort out the account transaction details; sort out the transaction details for all platform accounts as of a certain date;

[0008] The third step is preprocessing and calculating missing attributes; the platform account transaction details are sorted by account and transaction time to generate the current account balance of each transaction;

[0009] The fourth step is preprocessing. According to the data characteristics, the transaction flow is divided into intervals and marked; the platform account transaction details are divided into multiple intervals according to the account and the transaction time, and the income and expenditure transaction details from the beginning of the account to the end of the account are divided into multiple intervals, and unique transaction IDs are set for these intervals;

[0010] Step 5: Pre-processing: mark all transaction details as unprocessed; mark all transaction details as processed or not;

[0011] Step 6: According to the account and interval transaction ID, filter out the transactions with unprocessed ID, process the transactions in the interval one by one, and match and associate the account income and expenditure transactions;

[0012] Step 7: Post-processing and data verification;

[0013] Step 8. End.

[0014] Furthermore, the sixth step includes a large cycle process and a small cycle process;

[0015] Step 6: The big loop processes each account in turn and reads an unprocessed account according to the account list;

[0016] Step 6-2: The small loop processes each unprocessed transaction interval under the account in turn, and reads a segmented interval from the segmented interval list under the account;

[0017] Step 6-3: Determine whether the transaction details in the interval have been processed. If so, return to step 6-2 to prepare for processing the next interval. If not, proceed to step 6-4.

[0018] Step 6-4: Matching and associating account income and expenditure records;

[0019] Step 6-5: After processing the data in the segmented interval, mark all the flow records bound to the interval as processed;

[0020] Step 6-6: Check whether the account's transaction segment has been read. If not, return to step 6-2. If yes, proceed to step 6-7.

[0021] Step 6-7: Determine whether all account transaction details have been read. If not, return to step 6-1. If yes, proceed to step 7.

[0022] Furthermore, the matching and associating of the account income and expenditure flow includes:

[0023] Step 4 of the sixth step is accurate matching for direct payment scenarios. Bind the revenue and expenditure details in the interval that can be associated with the waybill number, and associate the direct payment transactions in the interval with the waybill.

[0024] Furthermore, it also includes step 6 / 4 / 2, approximate matching, scenario 1; associating the income with the same waybill number in the interval with the same single non-direct payment amount.

[0025] Furthermore, it also includes step 6 / 4 / 3, approximate matching, scenario 2; sorting the multiple identical waybill revenues or multiple non-direct payment withdrawal expenditures in the interval, and making a one-to-one association to ensure that one waybill revenue corresponds to only one expenditure.

[0026] Furthermore, it also includes step 6 / 4 / 4, approximate matching, scenario three; excluding the transactions of income and expenditure that have been bound in the transaction flow in this interval, and then taking out the transaction details of the same date in the remaining transaction flow with the same amount of income and non-direct payment expenditure for association.

[0027] Furthermore, it also includes step 6 / 4 / 5, approximate matching, scenario 4; exclude the transactions of income and expenditure that have been bound in this interval, and then take out the transaction details in the remaining transactions where the difference between the income date and the expenditure date is 1-5 days, and the income and non-direct payment expenditure amounts are consistent to associate them.

[0028] Furthermore, it also includes step 6 of 4, approximate matching, scenario 5; excluding the transactions of income and expenditure that have been bound in the transaction flow in this interval, and then taking out the transaction details of the remaining transactions with the same amount of income and non-direct payment expenditure to associate them.

[0029] Furthermore, it also includes step 6 / 4 / 7, approximate matching, scenario 6; excluding the revenue and expenditure transactions that are already bound in the transaction flow in the interval, and then taking out the transaction details with the same total revenue and expenditure amounts from the remaining transaction flows for association.

[0030] Furthermore, the sixth step includes interval 0 and non-0 interval. The transactions in interval 0 are processed first, and the remaining are non-0 intervals. Each account includes only one non-0 interval. An interval transaction ID is set for each non-0 interval. Fuzzy matching is performed in the non-0 interval according to the matching association method of the 0 interval direct payment scenario and scenarios one to four.

[0031] The beneficial effects of the present application are as follows: the complicated account reconciliation method that can only be performed manually through Excel is improved. The method can be used for reconciliation of large quantities of accounts, and then subsequent reconciliation can be performed manually, which greatly optimizes and improves the reconciliation efficiency and quality.

[0032] The aforementioned main scheme of the present application and its further options can be freely combined to form multiple schemes, all of which are schemes that can be adopted and claimed for protection in the present application; and in the present application, (non-conflicting options) can also be freely combined with each other and with other options. After understanding the scheme of the present application, those skilled in the art can understand that there are many combinations based on the prior art and common knowledge, all of which are technical schemes to be protected by the present application, and they are not exhaustively listed here. BRIEF DESCRIPTION OF THE DRAWINGS

[0033] Figure 1 It is a flowchart of this application. DETAILED DESCRIPTION

[0034] The following non-limiting examples are provided to illustrate the present application.

[0035] Example 1

[0036] refer to Figure 1 As shown, a method for matching waybills and flow sheets based on account reconciliation in the logistics industry includes the following steps.

[0037] The first step is to start; create a temporary table for the automated matching process.

[0038] The second step is to sort out the account transaction details. Sort out the transaction details for all platform accounts as of a certain date.

[0039] The third step is preprocessing and calculating missing attributes. The platform account transaction details are sorted by account and transaction time to generate the current account balance of each transaction, that is, the account balance at the time of the transaction is calculated based on the order of the transactions.

[0040] The fourth step is preprocessing, marking the transaction flow by segment according to data features. The transaction flow details of the platform account are divided into multiple intervals according to the account and the transaction time, and the income and expenditure transaction details from the beginning of the account to the end of the account are divided into multiple intervals, and unique transaction IDs are set for these intervals. That is, according to the account and time, the transaction flow is divided into multiple intervals according to the account's beginning balance of 0 and the end balance of 0.

[0041] Step 5: Preprocessing: Mark all transaction details as unprocessed. Mark all transaction details with a processing mark. If the mark is 0, it means that the income and expenditure transactions in this interval have not been fully bound. If the mark is 1, it means that the income and expenditure transactions in this interval have been fully bound.

[0042] Step 6: Filter out the unprocessed transactions according to the account and interval transaction ID, process the transactions in the interval one by one, and match and associate the account income and expenditure transactions.

[0043] The sixth step includes large-loop processing and small-loop processing.

[0044] In the sixth step, the large loop processes each account in turn and reads an unprocessed account according to the account list.

[0045] Step 6-2: The small loop processes each unprocessed transaction interval under the account in turn, and reads a segmented interval in the segmented interval list under the account.

[0046] Step 6-3 determines whether the transaction details in the interval have been processed. If so, return to step 6-2 to prepare to process the next interval. If not, proceed to step 6-4.

[0047] Step 6-4, matching and associating account income and expenditure transactions, including: Step 6-4-1, accurate matching, direct payment scenario; binding and associating the income and expenditure details in the interval that can be associated with the waybill number, associating the direct payment transactions in the interval with the waybill, and retaining the balance of the relationship in the relationship table, which is the difference between income and expenditure.

[0048] Step 6 of 4, approximate matching, scenario 1: associate the income with the same waybill number in the interval with the same single non-direct payment amount to ensure a one-to-one matching relationship.

[0049] Step 6 / 4 / 3, approximate matching, scenario 2; sort the multiple identical waybill revenues or multiple non-direct payment withdrawal expenditures in the interval by number, and make a one-to-one association to ensure that one waybill revenue corresponds to only one expenditure.

[0050] Step 4 of 6, approximate matching, scenario 3; exclude the transactions of income and expenditure that are already bound in this interval, and then extract the transaction details of the remaining transactions with the same amount of income and non-direct payment expenditure on the same date for association.

[0051] Step 6 / 4 / 5, approximate matching, scenario 4; exclude the transaction records of income and expenditure that are already bound in this interval, and then extract the transaction details of the remaining transaction records where the difference between the income date and the expenditure date is 1-5 days, and the income and non-direct payment expenditure amounts are consistent, and associate them.

[0052] Step 6 of 4, Approximate Matching, Scenario 5: Exclude the transactions in this interval that have already bound income and expenditure, and then extract the transaction details in the remaining transactions that have the same amount of income and non-direct payment expenditure to associate.

[0053] Step 6 / 4 / 7, approximate matching, scenario 6; exclude the revenue and expenditure transactions that are already bound in this interval, and then take out the transaction details with the same total revenue and expenditure amounts from the remaining transactions for association.

[0054] Step 6 of 5: After processing the data in the split interval, mark all the flow records bound to the interval as processed.

[0055] Step 6 / 6 determines whether the transaction segmentation interval under the account has been read. If not, return to step 6 / 2. If so, the small loop ends and proceed to step 6 / 7.

[0056] Step 6-7 determines whether all account transaction details have been read. If not, return to step 6-1. If yes, the big loop ends and proceed to step 7.

[0057] The sixth step includes the 0 interval and the non-0 interval (the 0 interval means that the account's opening balance + collection - payment - ending balance in a certain period is 0, and the non-0 interval is not 0). The transactions in the 0 interval are processed first, and the remaining are non-0 intervals. Each account includes only one non-0 interval, and an interval transaction ID is set for each non-0 interval. Fuzzy matching is performed in the non-0 interval according to the 0 interval direct payment scenario and the matching association methods of scenarios one to four.

[0058] Step 7: Post-processing and data verification.

[0059] Step 8. End.

[0060] The aforementioned basic examples and their further selected examples can be freely combined to form multiple embodiments, all of which are embodiments that can be adopted and claimed for protection in this application. In the scheme of this application, each selected example can be arbitrarily combined with any other basic examples and selected examples.

[0061] The above description is only a preferred embodiment of the present application and is not intended to limit the present application. Any modifications, equivalent substitutions and improvements made within the spirit and principles of the present application should be included in the protection scope of the present application.

Claims

1. A method for matching waybills and flow records based on account reconciliation in the logistics industry, characterized in that: The steps include: Step 1, start; create a temporary table for the automated matching process; The second step is to sort out the account transaction details; sort out the transaction details for all platform accounts as of a certain date; The third step is preprocessing and calculating missing attributes; Generate the current account balance of each transaction according to the platform account transaction details by account and transaction time; The fourth step is preprocessing, marking the flow into partitions according to data characteristics; Split the platform account transaction details into multiple intervals according to the account and transaction time, and set unique transaction IDs for these intervals; Step 5: Pre-processing: mark all transaction details as unprocessed; mark all transaction details as processed or not; Step 6: According to the account and interval transaction ID, filter out the transactions with unprocessed ID, process the transactions in the interval one by one, and match and associate the account income and expenditure transactions; Step 7: Post-processing and data verification; Step 8. End.

2. The method for matching waybills and bank statements based on account reconciliation in the logistics industry according to claim 1 is characterized by: The sixth step includes a large circulation process and a small circulation process; In step 6, the large loop processes each account in turn and reads an unprocessed account according to the account list; in step 6, the small loop processes each unprocessed transaction interval under the account in turn and reads a segmented interval from the segmented interval list under the account; Step 6-3: Determine whether the transaction details in the interval have been processed. If so, return to step 6-2 to prepare for processing the next interval. If not, proceed to step 6-4. Step 6-4: Matching and associating account income and expenditure records; Step 6-5: After processing the data in the segmented interval, mark all the flow records bound to the interval as processed; Step 6-6: Check whether the account's transaction segment has been read. If not, return to step 6-2. If yes, proceed to step 6-7. Step 6-7: Determine whether all account transaction details have been read. If not, return to step 6-1. If yes, proceed to step 7.

3. The method for matching waybills and bank statements based on account reconciliation in the logistics industry according to claim 2 is characterized by: The matching and association of the account income and expenditure flow includes: Step 4 of the sixth step is accurate matching for direct payment scenarios. Bind the revenue and expenditure details in the interval that can be associated with the waybill number, and associate the direct payment transactions in the interval with the waybill.

4. The method for matching waybills and bank statements based on account reconciliation in the logistics industry according to claim 3 is characterized by: It also includes step 6 / 4 / 2, approximate matching, scenario 1; associating the income with the same waybill number in the interval with the same single non-direct payment amount.

5. The method for matching waybills and bank statements based on account reconciliation in the logistics industry according to claim 4 is characterized by: It also includes step 6 / 4 / 3, approximate matching, scenario 2; sorting the multiple identical waybill revenues or multiple non-direct payment withdrawal expenditures in the interval, and making a one-to-one association to ensure that one waybill revenue corresponds to only one expenditure.

6. The method for matching waybills and bank statements based on account reconciliation in the logistics industry according to claim 5 is characterized by: It also includes step 4 of 6, approximate matching, scenario 3; exclude the transactions of income and expenditure that have been bound in this interval, and then extract the transaction details of the same date in the remaining transactions with the same amount of income and non-direct payment expenditure for association.

7. The method for matching waybills and bank statements based on account reconciliation in the logistics industry according to claim 6 is characterized by: It also includes step 6 / 4 / 5, approximate matching, scenario 4; exclude the transactions of income and expenditure that have been bound in this interval, and then take out the transaction details in the remaining transactions where the difference between the income date and the expenditure date is 1-5 days, and the income and non-direct payment expenditure amounts are consistent, and associate them.

8. The method for matching waybills and bank statements based on account reconciliation in the logistics industry according to claim 7 is characterized by: It also includes step 6 / 4 / 6, approximate matching, scenario 5; exclude the transactions in this interval that have already bound income and expenditure, and then take out the transaction details in the remaining transactions that have the same income and non-direct payment amount to associate them.

9. The method for matching waybills and bank statements based on account reconciliation in the logistics industry according to claim 8, characterized in that: It also includes step 6 / 4 / 7, approximate matching, scenario 6; exclude the revenue and expenditure transactions that have been bound in the interval, and then take out the transaction details with the same total revenue and expenditure amounts from the remaining transactions for association.

10. The method for matching waybills and bank statements based on account reconciliation in the logistics industry according to any one of claims 1 to 7, characterized in that: The sixth step includes interval 0 and non-0 interval. The transaction flow of interval 0 is processed first, and the remaining are non-0 intervals. Each account includes only one non-0 interval. An interval transaction ID is set for each non-0 interval. Fuzzy matching is performed in the non-0 interval according to the matching association method of the 0 interval direct payment scenario and scenarios one to four.

Images