Accounts Payable / Accounts Receivable Matching System

Abstract

This solution resolves the discrepancy between invoices and payments that arises when the ordering party makes payments without verifying the contractor's invoice information before payment. [Solution] A means 3 is provided to reconcile accounts payable and accounts receivable between the ordering party's accounts payable list data 1 and the receiving party's accounts receivable list data 2. Information items that are not included in the ordering party's accounts payable list data 1 but are included in the receiving party's accounts receivable list data 2 are extracted and sent to the ordering party as an invoice document 6. The ordering party reviews the received invoice information and replies to the receiving party as purchase details information, responding with "approved" for items that are acceptable and "not approved" for items that cannot be approved. The receiving party reviews the contents of the purchase details information received as a reply from the ordering party and replies with whether or not it can be approved as purchase details reply information, thereby resolving the discrepancy between accounts payable and accounts receivable before the ordering party makes payment.

Description

Technical Field

[0001] The present invention is directed to the field of reconciliation processing of accounts receivable and accounts payable in business-to-business transactions.

Background Art

[0002] In business-to-business transactions in Japan, it is common to settle on a monthly basis. The recipient delivers an invoice based on its accounts receivable ledger to the orderer, and the orderer makes payments based on its accounts payable ledger while referring to the invoice.

[0003] In this settlement procedure, discrepancies between invoices and payments frequently occur, and a large amount of manpower is required for reconciliation. As a countermeasure, a settlement procedure has been introduced in some business-to-business transactions where the orderer delivers a list of accounts payable to the recipient before payment, and the recipient confirms it before the orderer makes the payment.

[0004] However, even in this procedure, since various business-to-business settlement documents are exchanged, the problem of requiring manpower for reconciliation is not solved. Therefore, a mechanism for standardizing the data items of the exchanged documents as a common reference data model and automatically reconciling them with a system has finally reached the stage of practical use.

[0005] The accounts receivable and accounts payable reconciliation system of the present invention takes a procedure of inputting the accounts payable list data 1 sent by the orderer to the recipient and the recipient's own accounts receivable list data 2 into the accounts receivable and accounts payable reconciliation means 3 and performing the reconciliation between the two.

[0006] In the prior art so far, the accounts payable list and the accounts receivable list can be reconciled, but the settlement process for transferred assets and services that are not included in the accounts payable list but are included in the accounts receivable list remains.

[0007] In the reconciliation procedure of the accounts payable list and the accounts receivable list shown in the non-patent literature, for the settlement process of transferred assets that are not included in the accounts payable list but are included in the accounts receivable list, it is assumed that the recipient creates a claim document to be delivered to the orderer manually separately from the accounts receivable and accounts payable reconciliation mechanism, so the effect of automation utilizing invoice digitization cannot be obtained.

Prior Art Documents

[0008] [Patent Document 1] Patent No. 7556722 [Non-patent literature]

[0009] [Non-Patent Document 1] Guidelines for Standard EDI Invoice Specifications for Small and Medium-Sized Enterprises Part 1 ver.4.3 [Overview of the Initiative] [Problems that the invention aims to solve]

[0010] The objective of this invention is to solve the problem of having to manually process cases where some details included in the accounts receivable list of the receiving party are not included in the accounts payable list of the ordering party.

[0011] When a client receives an invoice, they will make payment if the contents are reasonable, but they will not pay for items that they deem inappropriate. If the contractor is not checked in advance, the problem of discrepancies between invoices and payments will recur. To solve this problem, this invention allows the client to provide the contractor with purchase details information under the invoice system as a response to the invoice information. [Means for solving the problem]

[0012] In this invention, the accounts payable list data 1 of the ordering party and the accounts receivable list data 2 of the receiving party are input into the accounts payable / accounts receivable matching means 3, and the two sets of data are compared and verified. If the matching results match, the accounts payable / accounts receivable matching means 3 outputs a "confirmation" response document 4 and sends it to the ordering party. If there are items that do not match, a "confirmation not possible" response document 5 is output and sent to the ordering party. The most important feature of this invention is that if there are information items that exist in the receiving party's accounts receivable list data 2 but are not included in the ordering party's accounts payable list data 1, the matching means 3 extracts the information items not included in the ordering party's accounts payable list data 1 from the receiving party's accounts receivable list data 2, outputs an invoice document 6, and sends it to the ordering party.

[0013] By adding the requirements for the invoice details stipulated by the invoice system to the accounts payable list data 1, the accounts payable / accounts receivable matching means 3 can output the "confirmation" response document 4 with the requirements for the supplier to "confirm" the purchase details of the ordering party stipulated by the invoice system. Similarly, the "confirmation not possible" response document 5 can be output with the requirements for the supplier to "confirmation not possible" the purchase details of the ordering party stipulated by the invoice system.

[0014] By adding the requirements for qualified invoices stipulated by the invoice system to the accounts receivable list data, the accounts payable / accounts receivable matching means 3 can output the invoice document 6 with the additional data added to it, along with the requirements for qualified invoices stipulated by the invoice system.

[0015] Upon receiving the aforementioned invoice document 6, the ordering party will refer to its contents and "approve" any additional information items in invoice document 6, sending the response to the supplier as purchase details under the invoice system. For information items that should not be added, the ordering party will send a "not approved" response to the supplier as purchase details.

[0016] The contractor reviews the contents of the purchase details information provided by the ordering party. If they agree, they send a "confirmed" response document to the ordering party as the purchase details response information under the invoice system. If they do not agree, they send a "confirmation not possible" response document as the purchase details response information.

[0017] When the response document from the order recipient is "unconfirmable", human or digital consultations are carried out among the parties until the "unconfirmable" items can be "confirmed", and the consultations continue until the response document from the order recipient becomes "confirmed". The orderer makes payment when the purchase details response information received from the order recipient is a "confirmed" response document.

Advantages of the Invention

[0018] The present invention matches the orderer's accounts payable list data 1 and the order recipient's accounts receivable list data 2 before the orderer makes payment, extracts information items that are not included in the orderer's accounts payable list data 1 but are included in the order recipient's accounts receivable list data 2, transmits them to the orderer as a claim document 6, and the orderer examines the content of the claim document and transmits a response to the order recipient as the purchase details information of the invoice system. The order recipient confirms the content of the purchase details information delivered by the orderer and replies to the orderer with "confirmed" or "unconfirmable" of the content as the purchase details response information. The orderer makes payment based on the "confirmed" purchase details response information. By this procedure, the advantage of solving the problem of mismatch between claims and payments caused by the orderer making payments without confirming the order recipient's claim information can be obtained.

Brief Description of the Drawings

[0019] [Figure 1] Data flow diagram of the accounts payable / accounts receivable matching system [Figure 2] Example of the accounts payable / accounts receivable comprehensive system

Modes for Carrying Out the Invention

[0020] The accounts payable / accounts receivable matching means 3 of the accounts payable / accounts receivable matching system operates at the order recipient's end. Since the matching result is transmitted to the orderer via EDI, the form implemented in the order recipient's EDI provider 9 is easy to use. Fig. 1 shows the data flow diagram of the accounts payable / accounts receivable reference system. Fig. 2 shows an example.

Examples

[0021] Figure 1 shows the data flow of the accounts receivable / accounts payable matching system. The key point of the present invention is the accounts receivable / accounts payable matching means 3, and its implementation can be either on the cloud or on-premises, without any restrictions.

[0022] Figure 2 illustrates the implementation of the accounts receivable / accounts payable matching system to an EDI provider. The order placer and the order receiver exchange EDI documents using an EDI provider respectively. The order placer side EDI provider 7 provides an order placer my page 8 as a UI on the cloud. On the screen of the order placer my page 8, functions such as the function to send EDI documents and the function to display and check the content of the EDI documents received from the order receiver are provided.

[0023] The order receiver side EDI provider 9 provides an order receiver my page 10 as a UI on the cloud. Further, it receives the accounts receivable list data 1 of the order placer, uploads the accounts payable list data 2 of the order receiver, inputs them into the accounts receivable / accounts payable matching means 3 for matching, and provides a function to output the matching result. The output of the matching result is displayed on the order receiver my page 10, and if the order receiver confirms the matching result and there is no problem, it sends a reply to the order placer.

[0024] In Figure 2, a case where the order placer and the order receiver use different EDI providers respectively is illustrated, but a single EDI provider can also provide the UI service functions on both sides of the order placer my page 8 and the order receiver my page 10.

Industrial Applicability

[0025] Regarding the long-standing unresolved issue of the discrepancy between claims and payments, the present invention is applicable to all business-to-business transactions and can eliminate the inefficiency of the settlement operations in our country.

Explanation of Signs

[0026] 1 Accounts receivable list data 2 Accounts payable list data 3 Accounts receivable / accounts payable matching means 4 Confirmation reply document 5. Unconfirmable response document 6. Billing Document 7. EDI provider on the ordering side 8. Client's My Page 9. EDI provider on the contractor's side 10. Recipient's My Page

Claims

1. The system includes an accounts payable / accounts receivable matching means 3 that matches accounts payable list data 1 provided by the ordering party with accounts receivable list data 2 from the receiving party. The accounts payable / accounts receivable matching means 3 has a first function of matching accounts payable list data 1 and accounts receivable list data 2, and a second function of identifying the matching result and creating a response document from the orderer to the orderer, The accounts payable / accounts receivable matching system is characterized by having the following features: first, a function to send a "confirmation" response document 4 created by the second function to the ordering party if the matching results of the first function match all line items in the list; second, a function to send a "confirmation not possible" response document 5 created by the second function to the ordering party if there are mismatches in the line items in the list; and third, a function to extract the missing line items from the accounts payable list data 2 if there are line items present in the accounts receivable list data 2 but not in the accounts payable list data 1, create an "invoice" document 6 and send it to the ordering party.

2. A means for the ordering party to receive and confirm the "invoice" document described in claim 1, Accounts payable / accounts receivable matching system characterized by having a means for the ordering party, after confirming the invoice details, to create a response regarding the confirmation as a purchase details document stipulated by the invoice system and send it to the receiving party.

3. A means for the contractor to confirm the contents of the purchase details document in response from the ordering party as described in claim 2, Accounts payable / accounts receivable matching system characterized by having a means for the recipient to send a "confirmation" reply in the invoice system if they determine that the contents of the reply purchase details document are acceptable, and to send a "confirmation not possible" reply in the same reply document if they determine that there are items that cannot be accepted.

Images