COMPUTERIZED INVOICE RECORD AND RECEIPT RECORD MATCHING WITH AUTOMATIC DISCREPANCY RESOLUTION

• US 20170154384A1
• Filed: 12/01/2015
• Published: 06/01/2017
• Est. Priority Date: 12/01/2015
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: SCHROEDER, Jurgen, HANSON, Gerald J., UCHENIK, Dmitriy
• Granted Patent: US 9,830,667 B2
• Time in Patent Office: Days
• CPC Class Codes: G06Q 20/00 Payment architectures, schemes or protocols apparatus for performing or posting payment transactions G07F7/08, G07F19/00; electronic cash registers G07G1/12
• CPC Class Codes: G06Q 20/10 specially adapted for electronic funds transfer [EFT] systems; specially adapted for home banking systems
• CPC Class Codes: G06Q 20/14 specially adapted for billing systems
• CPC Class Codes: G06Q 30/00 Commerce
• CPC Class Codes: G06Q 30/02 Marketing; Price estimation or determination; Fundraising
• CPC Class Codes: G06Q 30/06 Buying, selling or leasing transactions
• CPC Class Codes: G06Q 40/12 Accounting
• CPC Class Codes: G06Q 50/182 Alternative dispute resolution
• CPC Class Codes: G16Z 99/00 Subject matter not provided for in other main groups of this subclass

Abstract

Systems, methods, and other embodiments associated with invoice record and receipt record matching with automatic discrepancy resolution are described. In one embodiment, a method includes matching an invoice record to a receipt record and determining any remaining quantity discrepancy amount or cost discrepancy amount between the matched invoice record and receipt record. At least one tolerance window is identified, from a set of tolerance windows, into which the quantity discrepancy amount and the cost discrepancy amount fall. At least one resolution action, of a set of resolution actions, is identified which is mapped to the at least one identified tolerance window. A computing system is automatically triggered to perform the at least one identified resolution action to resolve the quantity discrepancy amount and the cost discrepancy amount.

Claims

1. A computer-implemented method performed by a computing device where the computing device includes at least one processor for executing instructions from a memory, the method comprising:

matching an invoice record to a receipt record via at least one processor, wherein the invoice record stores data describing an invoice quantity of items and an invoice cost in a first memory, and wherein the receipt record stores data describing a receipt quantity of items and a receipt cost in a second memory;

determining a quantity discrepancy amount, via the at least one processor, between the invoice record and the receipt record;

determining a cost discrepancy amount, via the at least one processor, between the invoice record and the receipt record;

identifying at least one tolerance data range, from a plurality of tolerance data ranges stored in a first data structure, in which the quantity discrepancy amount and the cost discrepancy amount are included;

accessing, via the at least one processor, a second data structure that stores a mapping of tolerance data ranges to resolution actions, wherein the accessing includes addressing the second data structure with the at least one tolerance data range to obtain at least one corresponding resolution action as an output;

generating an electronic message that identifies the at least one corresponding resolution action, wherein the at least one corresponding resolution action includes adjusting an inventory value; and

transmitting, via network communications, the electronic message to a computing system to invoke the computing system to automatically perform the at least one corresponding resolution action without user intervention to resolve the quantity discrepancy amount and the cost discrepancy amount.

2. The method of claim 1, wherein the at least one corresponding resolution action includes adjusting a value of the receipt record.

3. The method of claim 1, wherein matching the invoice record to the receipt record includes performing at least one computerized comparison operation between the invoice record and a plurality of receipt records to find the receipt record of the plurality of receipt records being a best match to the invoice record based on at least one set of matching criteria.

4. The method of claim 1, further comprising configuring the plurality of tolerance data ranges in the first data structure and storing the first data structure in a third memory of the computing device.

5. The method of claim 1, further comprising configuring the mapping of the tolerance data ranges to the resolution actions in the second data structure and storing the second data structure in a fourth memory of the computing device.

6. The method of claim 1, further comprising receiving from the computing system, via the network communications, a second electronic message indicating that the quantity discrepancy amount and the cost discrepancy amount have been resolved.

7. The method of claim 1, wherein the quantity discrepancy amount and the cost discrepancy amount are percentage values.

8. The method of claim 1, wherein the quantity discrepancy amount is a number of items, and wherein the cost discrepancy amount is a monetary amount.

9. The method of claim 1, wherein the computing system includes at least one of a computerized accounting system, a computerized billing system, and a computerized invoice management system.

10. A computing system, comprising:

an input/output module, including instructions stored in a non-transitory computer-readable medium, configured to;

retrieve a plurality of invoice records, where each invoice record includes data describing an invoice quantity of items and an invoice cost, and

retrieve a plurality of receipt records, where each receipt record includes data describing a receipt quantity of items and a receipt cost;

a matching module, including instructions stored in a non-transitory computer-readable medium, configured to match an invoice record of the plurality of invoice records to a receipt record of the plurality of receipt records;

a discrepancy module, including instructions stored in a non-transitory computer-readable medium, configured to determine a quantity discrepancy amount and a cost discrepancy amount between the invoice record and the receipt record as matched by the matching module; and

a mapping module, including instructions stored in a non-transitory computer-readable medium, configured to;

identify at least one tolerance window, from a set of tolerance windows, into which the quantity discrepancy amount and the cost discrepancy amount fall, and

access a mapping data structure, that stores a mapping of tolerance windows to resolution actions, by addressing the mapping data structure with the at least one tolerance window to obtain at least one corresponding resolution action as an output,

wherein the input/output module is further configured to;

generate an electronic message that identifies the at least one corresponding resolution action, wherein the at least one corresponding resolution action includes adjusting an inventory value, and

transmit, via network communications, the electronic message to a computing system to invoke the computing system to automatically perform the at least one corresponding resolution action without user intervention to resolve the quantity discrepancy amount and the cost discrepancy amount.

11. The computing system of claim 10, further comprising a database device configured to store at least the plurality of invoice records and the plurality of receipt records.

12. The computing system of claim 10, wherein the matching module includes a baseline matching module configured to match the invoice record to at least one receipt record of the plurality of receipt records such that the invoice record is deemed to match the at least one receipt record when a first set of criteria are met.

13. The computing system of claim 12, wherein the matching module includes a best matching module configured to, when the at least one receipt record matched by the baseline matching module includes at least two receipt records, select a single one of the at least two receipt records when a second set of criteria are met.

14. The computing system of claim 10, wherein the input/output module comprises a visual user interface module configured to provide a graphical user interface and facilitate configuring of the set of tolerance windows, the resolution actions, and the mapping of tolerance windows to resolution actions via the graphical user interface.

15. The computing system of claim 14, further comprising a display screen configured to display and facilitate user interaction with at least the graphical user interface.

16. A non-transitory computer-readable medium storing computer-executable instructions that, when executed by a computer, cause the computer to perform functions, wherein the instructions comprise:

instructions for matching an invoice record to a receipt record, wherein the invoice record stores data describing an invoice quantity of items and an invoice cost, and wherein the receipt record stores data describing a receipt quantity of items and a receipt cost;

instructions for determining a quantity discrepancy amount between the invoice record and the receipt record;

instructions for determining a cost discrepancy amount between the invoice record and the receipt record;

instructions for identifying at least one tolerance window, from a set of tolerance windows, into which the quantity discrepancy amount and the cost discrepancy amount fall;

instructions for accessing a mapping data structure that stores a mapping of tolerance windows to resolution actions, wherein the instructions for accessing include instructions for addressing the mapping data structure with the at least one tolerance window to obtain at least one corresponding resolution action as an output;

instructions for generating an electronic message that identifies the at least one corresponding resolution action, wherein the at least one corresponding resolution action includes adjusting an inventory value; and

instructions for transmitting the electronic message to a computing system to invoke the computing system to automatically perform the at least one corresponding resolution action without user intervention to resolve the quantity discrepancy amount and the cost discrepancy amount.

17. The non-transitory computer-readable medium of claim 16, wherein the instructions for transmitting the electronic message to a remote computing system to cause the remote computing system to perform the at least one corresponding resolution action include instructions for causing charging back an overbilling amount to an associated vendor.

18. The non-transitory computer-readable medium of claim 16, wherein the instructions further include instructions for configuring the set of tolerance windows in at least one tolerance data structure stored in a computerized memory.

19. The non-transitory computer-readable medium of claim 16, wherein the instructions further include instructions for configuring the mapping of tolerance windows to resolution actions in the mapping data structure stored in a computerized memory.

20. The non-transitory computer-readable medium of claim 16, wherein the instructions for matching the invoice record to the receipt record further include instructions for performing at least one computerized comparison operation between the invoice record and a plurality of receipt records to find the receipt record of the plurality of receipt records being a best match to the invoice record based on at least one set of matching criteria.