Computerized invoice record and receipt record matching with automatic discrepancy resolution

• US 9,830,667 B2
• Filed: 12/01/2015
• Issued: 11/28/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
• Primary Examiner(s): Goyea, Olusegun
• Application Number:
  US14/955,171
• Publication Number:
  US 20170154384A1
• Time in Patent Office: 728 Days
• Field of Search: 705 40, 705 39, 705 711, 705 5, 705 712, 705 22, 705 30, 705 28
• 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, and wherein the receipt record stores data describing a receipt quantity of items and a receipt cost;

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;

creating a mapping entry within a mapping data structure of tolerance data ranges to resolution actions, wherein the mapping entry maps a tolerance data range for a cost and quantity discrepancy pair to a set of resolution actions;

in response to the quantity discrepancy amount and the cost discrepancy amount corresponding to the tolerance data range within the mapping data structure, (i) selecting a resolution action from the set of resolution actions and (ii) generating an electronic message that identifies the resolution action; and

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

2. The method of claim 1, wherein the resolution action includes adjusting an inventory value.

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 receiving a user selection of the resolution action from the set of resolution actions.

5. The method of claim 1, further comprising utilizing mapping logic to select the resolution action from the set of resolution actions.

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;

create a mapping entry within a mapping data structure of tolerance windows to resolution actions, wherein the mapping entry maps a tolerance window for a cost and quantity discrepancy pair to a set of resolution actions;

in response to the quantity discrepancy amount and the cost discrepancy amount corresponding to the tolerance window within the mapping data structure, select a resolution action from the set of resolution actions,

wherein the input/output module is further configured to;

generate an electronic message that identifies the resolution action, wherein the 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 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 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 creating a mapping entry within a mapping data structure of tolerance windows to resolution actions, wherein the mapping entry maps a tolerance window for a cost and quantity discrepancy pair to a set of resolution actions;

instructions for selecting a resolution action from the set of resolution actions in response to the quantity discrepancy amount and the cost discrepancy amount corresponding to the tolerance window within the mapping data structure

instructions for generating an electronic message that identifies the resolution action, wherein the 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 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 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.