A data matching method between multi-type financial bills

Abstract

The application relates to a data matching method between multiple types of financial bills, and belongs to the technical field of financial data matching. The method obtains multiple original business orders, and generates corresponding monthly bills by summarizing the multiple original business orders according to preset summary rules. According to a preset splitting and combining logic, the monthly bills are split and combined based on the total application bill amount in the monthly bills, corresponding settlement bills are generated, and the settlement bills are used for bill opening to obtain corresponding invoices. A to-be-matched payment order is obtained, and data matching is performed on the original business order, the settlement bill and the to-be-matched payment order according to preset filtering conditions, so that the matching relationship between the original business order, the settlement bill and the to-be-matched payment order is determined. The application can associate the business order, the invoice content and the payment certificate, and improves the business processing efficiency of financial data processing.

Description

A data matching method among multiple types of financial documents Technical Field

[0001] This application belongs to the field of financial data matching technology, specifically involving a data matching method between multiple types of financial documents. Background Technology

[0002] Existing financial documents include settlement statements, payment slips, and business orders. Settlement statements are typically settlement vouchers issued by marketing agencies, based on specific transactions within the company, and serve as the basis for asset settlement. Payment slips generally refer to payment vouchers, prepared by the purchasing company's accounts payable department. They specify the supplier to whom goods, assets, or services have been received, the amount payable, and the payment date. Payment vouchers are internal records and authorization documents for paying liabilities within the purchasing company. Business orders typically encapsulate all of the company's business and information; they include various documents and certificates used in different business transactions. Buyers and sellers rely on these documents to handle matters such as delivery, transportation, insurance, commodity inspection, and foreign exchange settlement.

[0003] In the existing financial data processing process, due to the large number of various documents and the lack of correlation between settlement documents, payment documents, and business documents, it is impossible to quickly associate and match business documents, invoice content, and payment vouchers. When issuing invoices, it is necessary to sort out the relationship between documents one by one before issuing invoices, resulting in low business processing efficiency. Summary of the Invention

[0004] To address this, this application provides a data matching method for multiple types of financial documents, which helps to solve the problem that existing technologies cannot quickly associate and match business orders, invoice content, and payment vouchers in financial documents, resulting in low business processing efficiency.

[0005] To achieve the above objectives, this application adopts the following technical solution:

[0006] This application provides a data matching method for multiple types of financial documents, including:

[0007] Obtain multiple original business orders and summarize them according to preset summary rules to generate corresponding monthly bills;

[0008] Based on the total amount of invoices requested in the monthly bill, the monthly bill is split and combined according to a preset splitting and combining logic to generate a corresponding settlement statement and issue an invoice based on the settlement statement to obtain the invoice corresponding to the settlement statement;

[0009] Obtain the payment order to be matched, and perform data matching on the original business order, settlement order and payment order to be matched according to preset filtering conditions to determine the matching relationship between the original business order, settlement order and payment order to be matched.

[0010] Furthermore, the step of acquiring multiple original business orders and summarizing them according to preset summarization rules to generate a corresponding monthly bill specifically includes:

[0011] Retrieve all original business orders for the current month. Based on the confirmation time of the business orders, summarize all original business orders for the current month according to the dimensions of the main entity, the counterparty entity, the counterparty natural person and the sub-account, and generate corresponding two-month bills.

[0012] Furthermore, the confirmation time for the business order is specifically from the 1st to the 20th of the month and from the 21st to the last day of the month.

[0013] Furthermore, the step of splitting and combining the monthly bill based on the total amount of invoices requested in the monthly bill according to a preset splitting and combining logic, generating a corresponding settlement statement, and issuing an invoice based on the settlement statement, and obtaining the invoice corresponding to the settlement statement specifically includes:

[0014] Based on the total amount of invoices requested in the monthly bill, it is determined whether the total amount of invoices requested exceeds the preset settlement amount;

[0015] If the total amount of the requested invoice exceeds the preset settlement amount, the monthly bill is split according to the preset settlement amount to ensure that the total amount of the requested invoice for a single monthly bill after splitting does not exceed the preset settlement amount. At the same time, a corresponding settlement statement is generated based on the split monthly bill, and an invoice is issued based on the settlement statement to obtain the invoice corresponding to the settlement statement.

[0016] If the total amount of the requested invoice does not exceed the preset settlement amount, the current monthly bill is combined with other monthly bills whose total requested invoice amount does not exceed the preset settlement amount for invoicing, and the total amount of the combined invoice is ensured not to exceed the preset settlement amount; a corresponding settlement statement is generated based on all monthly bills of the combined invoice, and an invoice is issued based on the settlement statement to obtain the invoice corresponding to the settlement statement.

[0017] Furthermore, the step of combining the current monthly bill with other monthly bills whose total requested invoice amount does not exceed a preset settlement amount also includes:

[0018] If no other monthly bills can be matched for combined invoicing in the current monthly bill, a settlement statement will be generated separately for the current monthly bill, and an invoice will be issued based on the settlement statement to obtain the invoice corresponding to the settlement statement.

[0019] Further, the step of obtaining the payment order to be matched and performing data matching on the original business order, settlement order, and payment order to be matched according to preset filtering conditions to determine the matching relationship between the original business order, settlement order, and payment order to be matched specifically includes:

[0020] Based on the withdrawal code in the withdrawal record, retrieve the payment order to be matched from the payment center;

[0021] Using the entity of the party in the payment order, the counterparty entity, and the natural person identification number of the counterparty entity as preset filtering conditions, the payment order and the settlement order are filtered and matched according to the time sequence to determine the matching relationship between the payment order and the settlement order.

[0022] Based on the matching relationship between the payment slip and the settlement slip, the payment slip is matched with the monthly bill corresponding to the settlement slip according to the transaction time sequence of the payment slip to determine the matching relationship between the payment slip and the monthly bill;

[0023] Based on the generation relationship between the monthly bill and the original business order, the matching relationship between the payment order and the original business order is determined.

[0024] The application employs the above technical solution and has at least the following beneficial effects:

[0025] This application provides a data matching method for multiple types of financial documents. The method first acquires multiple original business orders and aggregates them according to preset aggregation rules to generate corresponding monthly invoices. Then, based on the total amount of invoices requested in the monthly invoices, the monthly invoices are split and combined according to preset splitting and combining logic to generate corresponding settlement statements. Invoices are then issued based on the settlement statements, and the corresponding invoices are obtained. Simultaneously, payment orders to be matched are acquired, and data matching is performed on the original business orders, settlement statements, and payment orders to be matched according to preset filtering conditions to ultimately determine the matching relationship between the original business orders, settlement statements, and payment orders to be matched. This application, by aggregating multiple business orders into a monthly invoice according to preset aggregation rules, and then splitting and combining the monthly invoices according to preset splitting and combining logic based on the total amount of invoices requested in the monthly invoices to generate corresponding settlement statements and issue invoices based on the settlement statements, enables the association between business orders and settlement statements. Furthermore, by splitting and combining the monthly invoices, the number of invoices can be reduced while meeting the invoicing requirements of third-party institutions. This application also performs data matching on the original business order, settlement order and payment order to be matched through preset filtering conditions, determines the matching relationship between the three, and can link the business order, invoice content and payment voucher, thereby improving the business processing efficiency of financial data processing.

[0026] It should be understood that the above general description and the following detailed description are exemplary and explanatory only, and do not limit this application. Attached Figure Description

[0027] To more clearly illustrate the technical solutions in the embodiments of this application or the prior art, the drawings used in the description of the embodiments or the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments of this application. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.

[0028] Figure 1 is a flowchart illustrating a data matching method among multiple types of financial documents according to an exemplary embodiment;

[0029] Figure 2 is a diagram illustrating the relationship between a business order and a monthly bill according to an exemplary embodiment;

[0030] Figure 3 is a diagram illustrating the relationship between a business order, a monthly bill, a Baiwang settlement statement, and an invoice according to an exemplary embodiment.

[0031] Figure 4 is a flowchart illustrating the acquisition and matching of payment slips according to an exemplary embodiment;

[0032] Figure 5 is a diagram illustrating the relationship between a business order, a monthly bill, a settlement statement, and an invoice according to an exemplary embodiment. Detailed Implementation

[0033] To make the objectives, technical solutions, and advantages of this application clearer, the technical solutions of this application will be described in detail below. Obviously, the described embodiments are only a part of the embodiments of this application, and not all of them. Based on the embodiments in this application, all other implementation methods obtained by those skilled in the art without creative effort are within the scope of protection of this application.

[0034] This application uses Baiwang's individual invoice issuance service for invoice issuance. Baiwang's individual invoice issuance service addresses the issue of individuals lacking the ability to issue invoices themselves. For invoices issued through Baiwang's individual invoice issuance service to be valid, the following conditions must be met:

[0035] 1. First, send out the Baiwang settlement statement, which requires proof of payment;

[0036] 2. Submit an invoice request based on the settlement statement;

[0037] 3. Based on the Baiwang settlement statement code, check the corresponding invoice status using the scheduled task. If an invoice has already been issued, retrieve it.

[0038] The existing invoicing scheme is based on withdrawal records (i.e., payment slips): one payment slip corresponds to one Baiwang settlement slip. The specific invoicing process is as follows:

[0039] (1) Record the customer's withdrawal records in the third-party TuXi settlement system;

[0040] (2) Set up a scheduled task to retrieve the payment voucher, i.e., the payment slip, for each withdrawal record from the payment center;

[0041] (3) Cash withdrawal transactions with payment vouchers are included in the scope of pending invoicing;

[0042] (4) Select the payment slip to be issued and issue the invoice through Baiwang.

[0043] According to the aforementioned invoicing method, there is a one-to-one correspondence between payment slips and Baiwang settlement slips. However, in the existing invoicing scheme, there is no correlation between payment slips, Baiwang settlement slips, and business slips, resulting in low business efficiency when processing financial documents. Therefore, this application provides a data matching method between multiple types of financial documents.

[0044] Please refer to Figure 1, which is a flowchart illustrating a data matching method between multiple types of financial documents according to an exemplary embodiment. As shown in Figure 1, the method includes the following steps:

[0045] A data matching method for multiple types of financial documents includes:

[0046] S1: Obtain multiple original business orders and summarize them according to preset summary rules to generate corresponding monthly bills;

[0047] S2: Based on the total amount of invoices requested in the monthly bill, split and combine the monthly bill according to the preset splitting and combining logic, generate the corresponding settlement statement, issue invoices based on the settlement statement, and obtain the invoices corresponding to the settlement statement;

[0048] S3: Obtain the payment order to be matched, and perform data matching on the original business order, settlement order and payment order to be matched according to the preset filtering conditions to determine the matching relationship between the original business order, settlement order and payment order to be matched.

[0049] Furthermore, in one embodiment, the step of obtaining multiple original business orders and summarizing the multiple original business orders according to a preset summarization rule to generate a corresponding monthly bill specifically includes:

[0050] Retrieve all original business orders for the current month. Based on the confirmation time of the business orders, summarize all original business orders for the current month according to the dimensions of the main entity, the counterparty entity, the counterparty natural person and the sub-account, and generate corresponding two-month bills.

[0051] The confirmation time for the business order is specifically from the 1st to the 20th of the month and from the 21st to the last day of the month.

[0052] In practice, this application summarizes the business orders for a month into two "monthly statements" based on whether the confirmation time of the business order falls between the 1st and 20th of the month or between the 21st and the last day of the month. The statements are categorized by the entity itself, the counterparty (in this example, the store), the counterparty's natural person, and the sub-account. The monthly statement summary can be set to be executed once on the 21st of each month. The original business orders and the summarized monthly statements are shown in Tables 1 and 2 below.

[0053] Table 1 Original Business Order Data Table

[0054] Serial Number | Transaction Order Code | Party A | Party B | Party C | Party D | Party E ... 11:00:00600.004YW004A Company B Store Xiaoming 123456****0012011-10-20 11:00:002011-10-21 11:00:003,600.005YW005A Company B Store Xiaohong 123456****0022011-10-20 11:00:002011-10-21 11:00:002,600.006TW006A Company C Store Xiaoming 123456****0012011-10-20 11:00:002011-10-21 11:00:00 600.007 TW007 Company A, Store B, Xiaoming 1 2 3 4 5 6 ***** 001 2011-11-11 11:00:00 2011-11-12 11:00:00 600.008 TW008 Company A, Store B, Xiaoming 1 2 3 4 5 6 ***** 001 2011-11-20 11:00:00 2011-11-21 11:00:00 200.00 surface

[0055] The monthly bill is generated based on the entity of this party, the entity of the other party (store), the natural person's ID number, and the business order confirmation time (i.e., the settlement time), according to the dimensions of "1st to 20th of the month" and "21st to the last day of the month", as shown in Table 2 below:

[0056] Table 2 Summary and Analysis of Business Orders

[0057] Serial Number | Transaction Order Code | Party A | Party B | Party C | Natural Person | Party B | Natural Person ID Number | Transaction Time | Settlement Time | Amount Payable (RMB) | Monthly Billing Cycle | Monthly Bill Number | 1 YW001 | Company A | Store B | Xiaoming | 1 | 2 | 3 | 4 | 5 | 6 ***** | 001 | 2011-10-20 | 11:00:00 | 2011-10-21 | 11:00:00 | 3,600.00 | 2011-10-22~2011-10-31 | YZ001 | 2 YW002 | Company A | Store B | Xiaohong | 1 | 2 | 3 | 4 | 5 | 6 ***** | 002 | 2011-10-20 11:00:00 2011-10-21 11:00:00 2,600.00 2011-10-22~2011-10-31 YZ0023 YW003A Company C Store Xiaoming 1 2 3 4 5 6 ***** 001 2011-10-20 11:00:00 2011-10-21 11:00:00 600.00 2011-10-22~2011-10-31 YZ0034 YW004A Company B Store Xiaoming 1 2 3 4 5 6 ***** 001 2011-10-20 11:00:00 2011-10-21 11:00:00 3,600.00 2011-10-22~2011-10-31 YZ0015 YW005 A Company B Store Xiaohong 123456****002 2011-10-20 11:00:00 2011-10-21 11:00:00 2,600.00 2011-10-22~2011-10-31 YZ0026 YW006 A Company C Store Xiaoming 123456****001 2011-10-20 11:00:00 2011-10-21 11:00:00 600.00 2011-10-22~2011-10-31 YZ0037 YW007 A Company B Store Xiaoming 1 2 3 4 5 6 ***** 001 2011-11-11 11:00:00 2011-11-12 11:00:00 600.00 2011-11-01~2011-11-20 YZ0048 YW008 A Company B Store Xiaoming 1 2 3 4 5 6 ***** 001 2011-11-20 11:00:002011-11-2111:00:00200.002011-11-21~2011-11-30YZ005 surface

[0058] The final monthly bill is shown in Table 3 below:

[0059] Table 3 Monthly Billing Data

[0060] Serial Number | Monthly Bill Code | Monthly Billing Period | This Party | Counterparty (Store) | Natural Person | Counterparty Natural Person ID Number | Monthly Bill Amount (Yuan) | 1 | YZ001 | 2011-10-22~2011-10-31 | Company A | Store B | Xiaoming | 1 | 2 | 3 | 4 | 5 | 6 | ***** | 001 | 7,200.00 | 2 | YZ002 | 2011-11-01~2011-11-20 | Company A | Store B | Xiaoming | 1 | 2 | 3 | 4 | 5 | 6 | ***** | 001 | 600.00 | 3 | YZ00 32011-11-21~2011-11-30 Company A, Store B, Xiaoming, 123456****001200.004YZ004; 2011-10-22~2011-10-31 Company A, Store B, Xiaohong, 123456****0023,600.005YZ005; 2011-10-22~2011-10-31 Company A, Store C, Xiaoming, 123456****0013,600.00 surface

[0061] As can be seen from the above practice, there is a many-to-one relationship between business orders and monthly bills. That is, one business order corresponds to one monthly bill, one monthly bill corresponds to multiple business orders, and the monthly bill is composed of business orders. The relationship between the two is shown in Figure 2.

[0062] Further, in one embodiment, the step of splitting and combining the monthly bill based on the total amount of invoices requested in the monthly bill according to a preset splitting and combining logic, generating a corresponding settlement statement, and issuing an invoice based on the settlement statement, and obtaining the invoice corresponding to the settlement statement specifically includes:

[0063] Based on the total amount of invoices requested in the monthly bill, it is determined whether the total amount of invoices requested exceeds the preset settlement amount;

[0064] If the total amount of the requested invoice exceeds the preset settlement amount, the monthly bill is split according to the preset settlement amount to ensure that the total amount of the requested invoice for a single monthly bill after splitting does not exceed the preset settlement amount. At the same time, a corresponding settlement statement is generated based on the split monthly bill, and an invoice is issued based on the settlement statement to obtain the invoice corresponding to the settlement statement.

[0065] If the total amount of the requested invoices does not exceed the preset settlement amount, the current monthly invoice is combined with other monthly invoices whose total requested invoice amount does not exceed the preset settlement amount for invoicing, ensuring that the total amount of the combined invoices does not exceed the preset settlement amount. A corresponding settlement statement is generated based on all the combined monthly invoices, and invoices are issued based on these settlement statements to obtain the corresponding invoices. This application, by splitting monthly invoices into settlement statements with preset settlement amounts for invoicing, can minimize the number of invoices while meeting the invoicing requirements of third-party institutions, thus improving business processing efficiency.

[0066] The process of combining the current monthly bill with other monthly bills whose total invoice amount does not exceed the preset settlement amount also includes:

[0067] If no other monthly bills can be matched for combined invoicing in the current monthly bill, a settlement statement will be generated separately for the current monthly bill, and an invoice will be issued based on the settlement statement to obtain the invoice corresponding to the settlement statement.

[0068] In this application, when splitting and combining monthly bills, the order in which the monthly bills are processed is based on the order of the monthly bills in the database.

[0069] Furthermore, in some other embodiments of this application, the method of combining and splitting monthly bills to generate Baiwang settlement statements can be further optimized. The method of splitting and combining monthly bills can be based on generating the fewest Baiwang settlement statements. The specific method can be selected according to the actual situation, and will not be elaborated here.

[0070] In practice, we choose Baiwang's individual invoicing service for invoicing. Since all invoices issued by Baiwang through this service are for a face value of 1000 yuan, the amount of each settlement statement sent to Baiwang cannot exceed 1000 yuan. Therefore, this application sets the preset settlement amount to 1000 yuan. When a user selects a corresponding monthly bill to apply for invoicing, the total amount of the requested invoice is generated into a Baiwang settlement statement according to certain splitting and combination rules to ensure that the amount of each Baiwang settlement statement does not exceed 1000 yuan. As shown in Table 4 below, monthly bills with a total requested invoice amount greater than 1000 yuan need to be split.

[0071] Table 4. Example of a monthly bill for invoice application

[0072] Serial Number | Monthly Bill Code | Monthly Billing Period | This Party | Counterparty (Store) | Natural Person | Counterparty Natural Person ID Number | Monthly Bill Amount (Yuan) | 1 YZ001 | 2011-10-22~2011-10-31 | Company A | Store B | Xiaoming | 1 | 2 | 3 | 4 | 5 | 6 | **** | 001 | 7,200.00 surface

[0073] Select the monthly bills (greater than 1000) for which invoices will be issued.

[0074] Based on the example in Table 2 above, and subject to the restriction that the amount of each Baiwang settlement statement cannot exceed 1,000 yuan, the generated Baiwang settlement statement data is shown in Figure 5 below:

[0075] Table 5 Baiwang Settlement Statement Data Table

[0076] Serial Number | Baiwang Settlement Statement Code | This Party | Counterparty (Store) | Natural Person | Counterparty Natural Person ID Number | Baiwang Settlement Statement Amount (Yuan) | Related Monthly Bill Code | Monthly Bill Related Amount (Yuan) | Monthly Bill Amount (Yuan) | 1 | BW001 | Company A, Store B | Xiaoming | 1 | 2 | 3 | 4 | 5 | 6 | ***** | 001 | 1,000.00 | YZ001 | 1,000.00 | 7,200.00 | 2 | BW002 | Company A, Store B | Xiaoming | 1 | 2 | 3 | 4 | 5 | 6 | ***** | 001 | 1,000.00 | YZ001 | 1,000.00 | 7,200.00 | 3 | BW003 | Company A, Store B | Xiaoming | 1 | 2 | 3 | 4 | 5 | 6 | ***** | 001 | 1,000.00 | YZ001 | 1,000.00 | 7,200.00 | 4 | BW004 | Company A, Store B | Xiaoming | 1 | 2 | 3 | 4 | 5 | 6 ****0011,000.00YZ0011,000.007,200.005BW005A Company B Store Xiaoming 123456****0011,000.00YZ0011,000.007,200.006BW006A Company B Store Xiaoming 123456****0011,000.00YZ 0011,000.007,200.007BW007A Company B Store Xiaoming 123456****0011,000.00YZ0011,000.007,200.008BW008A Company B Store Xiaoming 123456****0011,000.00YZ001200.007,200.00 surface

[0077] Currently, Baiwang's individual invoice issuance service only offers paper invoices. Paper invoices require manual collection and counting, and accounting staff must scan each invoice individually, resulting in a heavy workload. Therefore, it's necessary to reduce the number of invoices by combining monthly bills under 1000 yuan, while ensuring the combined Baiwang settlement statement amount does not exceed 1000 yuan. The combined monthly bill data is shown in Table 6 below:

[0078] Table 6 Monthly Billing Data for Combined Invoicing

[0079] Serial Number | Monthly Bill Code | Monthly Billing Period | This Party | Counterparty (Store) | Natural Person | Counterparty Natural Person ID Number | Monthly Bill Amount (Yuan) | 2YZ002 | 2011-11-01~2011-11-20 | Company A | Store B | Xiaoming | 1 | 2 | 3 | 4 | 5 | 6 | **** | 00 | 600.00 | 3YZ003 | 2011-11-21~2011-11-30 | Company A | Store B | Xiaoming | 1 | 2 | 3 | 4 | 5 | 6 | **** | 00 | 200.00 surface

[0080] Select the monthly bills (less than 1000) for which invoices will be issued.

[0081] Since the two months' bill amounts in the example in Table 6 are relatively small, they can be combined and issued as a single invoice. Therefore, the generated Baiwang settlement statement data is shown in Table 7 below:

[0082] Table 7. Baiwang Settlement Statement Data Table for Combined Invoicing

[0083]

[0084] Generated Baiwang settlement statement (combined only)

[0085] Furthermore, in certain complex scenarios, it is necessary to both split and combine monthly bills, as shown in Table 8 below:

[0086] Table 8 Monthly bill data to be combined and split

[0087] Serial Number | Monthly Bill Code | Monthly Billing Period | This Party | Counterparty (Store) | Natural Person | Counterparty Natural Person ID Number | Monthly Bill Amount (Yuan) | 1 | YZ001 | 2011-10-22~2011-10-31 | Company A | Store B | Xiaoming | 1 | 2 | 3 | 4 | 5 | 6 | ***** | 001 | 7, 200.00 | 2 | YZ002 | 2011-11-01~2011-11-20 | Company A | Store B | Xiaoming | 1 | 2 | 3 | 4 | 5 | 6 | ***** | 001 | 600.00 | 3 | YZ003 | 2011-11-21~2011-11-30 | Company A | Store B | Xiaoming | 1 | 2 | 3 | 4 | 5 | 6 | ***** | 001 | 200.00 surface

[0088] In the case shown in Table 8 above, since a single Baiwang settlement statement cannot exceed 1000, and in order to reduce the number of invoices, monthly statements with smaller amounts are combined for invoicing, the Baiwang settlement statement shown in Table 9 below is generated:

[0089] Table 9. Data table of Baiwang settlement statement generated by splitting and combining.

[0090]

[0091] As can be seen from the above practical experience, there is a many-to-many relationship between monthly bills and Baiwang settlement statements. That is, a monthly bill with a large amount may correspond to multiple Baiwang settlement statements, while a monthly bill with a small amount may correspond to only one Baiwang settlement statement. However, there is a one-to-one correspondence between Baiwang settlement statements and invoices. In summary, the relationship between business orders, monthly bills, Baiwang settlement statements, and invoices is shown in Figure 3.

[0092] Further, in one embodiment, the step of obtaining the payment order to be matched and performing data matching on the original business order, settlement order, and payment order to be matched according to preset filtering conditions to determine the matching relationship between the original business order, settlement order, and payment order to be matched specifically includes:

[0093] Based on the withdrawal code in the withdrawal record, retrieve the payment order to be matched from the payment center;

[0094] Using the entity of the party in the payment order, the counterparty entity, and the natural person identification number of the counterparty entity as preset filtering conditions, the payment order and the settlement order are filtered and matched according to the time sequence to determine the matching relationship between the payment order and the settlement order.

[0095] Based on the matching relationship between the payment slip and the settlement slip, the payment slip is matched with the monthly bill corresponding to the settlement slip according to the transaction time sequence of the payment slip to determine the matching relationship between the payment slip and the monthly bill;

[0096] Based on the generation relationship between the monthly bill and the original business order, the matching relationship between the payment order and the original business order is determined.

[0097] In practice, this application retrieves the matching payment slip from the payment center based on the withdrawal code of the withdrawal record. Specifically, each time the business side (the third-party TuXi settlement system in Figure 4) initiates a withdrawal, the successful withdrawal record is recorded in the transaction log, along with the third-party transaction log number returned by the payment center after successful payment. Once a month, a scheduled task retrieves the payment voucher, i.e., the payment slip, from the payment center based on the transaction log number. This process is shown in Figure 4.

[0098] The specific process for matching payment slips, Baiwang settlement slips, and business orders is as follows:

[0099] Process 1: First, match the payment slips and Baiwang settlement slips. Based on the filtering conditions of the entity to be matched, the counterparty entity (i.e., store name), and the natural person identification number of the counterparty entity, match the payment slip with the earlier transaction time and the Baiwang settlement slip with the earlier creation time, and use the transaction amount of the payment slip to be matched to fill the amount to be matched in the Baiwang settlement slip.

[0100] The payment orders to be matched are shown in Table 10 below, and the settlement statements and monthly bills of Baiwang to be matched are shown in Table 11 below.

[0101] Table 10: Payment Order Data Table to be Matched

[0102] Serial Number | Transaction Serial Number | Transaction Time | This Party | Counterparty | Natural Person | Counterparty | Natural Person ID Number | Transaction Amount (RMB) | 1 | JY001 | 2012-11-01 | 11:00:00 | Company A | Store B | Xiaoming | 1 | 2 | 3 | 4 | 5 | 6 | ***** | 001 | 200.00 | 2 | JY002 | 2012-11-11 | 11:00:00 | Company A | Store B | Xiaoming | 1 | 2 | 3 | 4 | 5 | 6 | ***** | 001 | 600.00 | 3 | JY003 | 2012-11-12 | 11:00:00 | Company A | Store B | Xiaoming | 1 | 2 | 3 | 4 | 5 | 6 | ***** | 001 | 800.00 | 4 | JY004 | 2012-11-12 11:00:000 Company A, Store B, Xiaoming 123456****0011,000.005JY0052012-11-13 11:00:000 Company A, Store B, Xiaoming 123456****0017,200.006JY0062012-11-11 11:00:000 Company A, Store C, Xiaoming 123456****0017,200.007JY0072012-11-11 11:00:000 Company A, Store B, Xiaohong 123456****0027,200.00 surface

[0103] Table 11: Data of Baiwang settlement statements and monthly bills to be matched

[0104]

[0105] Step 2: Match the payment slip with the monthly invoice included in the Baiwang settlement statement. After matching the payment slip and the Baiwang settlement statement, match the payment slip with the monthly invoice (i.e., the next level monthly invoice) in the matching section of the Baiwang settlement statement, matching the payment slip with the earlier transaction time and the monthly invoice with the earlier push period. Since the monthly invoice and business order have a one-to-many relationship, and the relationship between business orders and monthly invoices has been clarified when summarizing the monthly invoices, the matching relationship between payment slips and business orders can be further confirmed based on the matching relationship between payment slips and monthly invoices. That is, when the matching relationship between payment slips and monthly invoices is determined, the matching relationship between payment slips and business orders is also determined.

[0106] The matching status between the payment slips, Baiwang settlement slips, and monthly bills determined according to Tables 10 and 11 above is shown in Table 12 below.

[0107] Table 12: Matching of Payment Slips, Baiwang Settlement Statements, and Monthly Bills

[0108]

[0109] As can be seen from Tables 10 to 12, the relationship between the payment slips, business slips, monthly bills, Baiwang settlement slips, and invoices determined in this application is shown in Figure 5. This achieves data association and matching between the contents of business slips, invoices, and payment vouchers, which can improve the business processing efficiency of financial data processing.

[0110] To facilitate a more thorough understanding of the solution presented in this application, the following explanations are provided for some of the technical terms used:

[0111] 1. Payment slip: a payment voucher, specifically referring to the payment voucher from Alipay;

[0112] 2. Business Order: This refers to the document that records the details of the actual business transaction, including the creation time, confirmation time, amount payable, the parties involved in the transaction and their rights and obligations, etc.

[0113] 3. Monthly Bill: Business orders are summarized monthly based on their confirmation dates. Generally, the summaries are based on the period from the 1st to the 20th of the calendar month and from the 21st to the last day of the calendar month. Therefore, a month's bill will be divided into two parts.

[0114] 4. Baiwang Settlement Statement: When selecting multiple monthly bills for invoicing, since the face value of the input invoices issued by Baiwang is 1,000 yuan, the total amount of the invoice application for a certain selection will be split and combined in units of 1,000 yuan to generate a Baiwang settlement statement. The amount of a Baiwang settlement statement cannot exceed 1,000 yuan.

[0115] 5. Summary cycle: The company's invoicing date is the 20th of each month. That is, the company issues or receives invoices that occur between the 21st of the previous month and the last day of the previous month and between the 1st and the 20th of the current month after the 20th. Therefore, an invoicing cycle is divided into two parts according to the different natural months: "the 21st of the previous month to the last day of the previous month" and "the 1st and the 20th of the current month".

[0116] 6. Baiwang Invoice Issuance Service for Individuals: Since individuals often lack the ability to issue invoices themselves and need to find an agency to help them issue invoices, Baiwang provides this service.

[0117] Any process or method description in the flowchart or otherwise herein can be understood as: representing a module, segment, or portion of code comprising one or more executable instructions for implementing a particular logical function or process, and the scope of the preferred embodiments of this application includes additional implementations in which functions may be performed not in the order shown or discussed, including substantially simultaneously or in reverse order depending on the function involved, as should be understood by those skilled in the art to which embodiments of this application pertain.

[0118] Those skilled in the art will understand that all or part of the steps of the methods in the above embodiments can be implemented by a program instructing related hardware. The program can be stored in a computer-readable storage medium, and when executed, the program includes one or a combination of the steps of the method embodiments.

[0119] In the description of this specification, the references to terms such as "one embodiment," "some embodiments," "example," "specific example," or "some examples," etc., indicate that a specific feature, structure, material, or characteristic described in connection with that embodiment or example is included in at least one embodiment or example of this application. In this specification, the illustrative expressions of the above terms do not necessarily refer to the same embodiment or example. Furthermore, the specific features, structures, materials, or characteristics described may be combined in any suitable manner in one or more embodiments or examples.

[0120] Although embodiments of this application have been shown and described above, it is understood that the above embodiments are exemplary and should not be construed as limiting this application. Those skilled in the art can make changes, modifications, substitutions and variations to the above embodiments within the scope of this application.

Claims

1. A data matching method among multiple types of financial documents, characterized in that, include: Obtain multiple original business orders and summarize them according to preset summary rules to generate corresponding monthly bills; Based on the total amount of invoices requested in the monthly statement, the monthly statement is split and combined according to a preset splitting and combining logic to generate corresponding settlement statements and issue invoices based on the settlement statements, thereby obtaining the invoices corresponding to the settlement statements; payment orders to be matched are obtained, and data matching of the original business order, settlement statement, and payment orders to be matched is performed according to preset filtering conditions to determine the matching relationship between the original business order, settlement statement, and payment orders to be matched; the specific steps of obtaining payment orders to be matched and performing data matching of the original business order, settlement statement, and payment orders to be matched according to preset filtering conditions to determine the matching relationship between the original business order, settlement statement, and payment orders to be matched include: obtaining payment orders to be matched from the payment center based on the withdrawal code in the withdrawal record; Using the entity name, the counterparty name, and the natural person identification number of the counterparty name in the payment slip as preset filtering conditions, the payment slip and settlement slip are filtered and matched according to the time sequence to determine the matching relationship between the payment slip and the settlement slip; based on the matching relationship between the payment slip and the settlement slip, the payment slip is matched with the monthly statement corresponding to the settlement slip according to the transaction time sequence of the payment slip to determine the matching relationship between the payment slip and the monthly statement; based on the generation relationship between the monthly statement and the original business order, the matching relationship between the payment slip and the original business order is determined.

2. The data matching method among multiple types of financial documents according to claim 1, characterized in that, The process of obtaining multiple original business orders and summarizing them according to preset summarization rules to generate corresponding monthly bills specifically includes: obtaining all original business orders within the current month, and summarizing all original business orders within the current month according to the confirmation time of the business orders, based on the dimensions of the party, the counterparty, the counterparty's natural person, and sub-accounts, to generate corresponding two-month bills.

3. The data matching method among multiple types of financial documents according to claim 2, characterized in that, The confirmation time for the business order is specifically from the 1st to the 20th of the month and from the 21st to the last day of the month.

4. The data matching method among multiple types of financial documents according to claim 1, characterized in that, The process of splitting and combining the monthly bill based on the total amount of invoices requested in the monthly bill according to a preset splitting and combining logic, generating corresponding settlement statements, issuing invoices based on the settlement statements, and obtaining the invoices corresponding to the settlement statements specifically includes: determining whether the total amount of invoices requested in the monthly bill exceeds a preset settlement amount; if the total amount of invoices requested exceeds the preset settlement amount, splitting the monthly bill according to the preset settlement amount to ensure that the total amount of invoices requested in a single monthly bill after splitting does not exceed the preset settlement amount, generating corresponding settlement statements based on the split monthly bills, issuing invoices based on the settlement statements, and obtaining the invoices corresponding to the settlement statements; if the total amount of invoices requested does not exceed the preset settlement amount, combining the current monthly bill with other monthly bills whose total amount of invoices requested does not exceed the preset settlement amount, ensuring that the total amount of invoices requested in the combined bills does not exceed the preset settlement amount; generating corresponding settlement statements based on all the combined monthly bills, issuing invoices based on the settlement statements, and obtaining the invoices corresponding to the settlement statements.

5. The data matching method among multiple types of financial documents according to claim 4, characterized in that, The step of combining the current monthly bill with other monthly bills whose total invoicing amount does not exceed the preset settlement amount also includes: if the current monthly bill does not match other monthly bills that can be combined for invoicing, then a settlement statement is generated separately for the current monthly bill, and an invoice is issued based on the settlement statement to obtain the invoice corresponding to the settlement statement.

Images