Computerized invoice record and receipt record matching utilizing best match criteria

• US 10,438,282 B2
• Filed: 10/09/2015
• Issued: 10/08/2019
• Est. Priority Date: 10/09/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): Wilder, A. Hunter
• Assistant Examiner(s): Mutschler, Joseph M
• Application Number:
  US14/879,408
• Publication Number:
  US 20170103455A1
• Time in Patent Office: 1,460 Days
• Field of Search: 705 30
• CPC Class Codes: G06Q 40/02 Banking, e.g. interest calculation or account maintenance credit or loans G06Q40/03

Abstract

Systems, methods, and other embodiments associated with invoice record and receipt record matching utilizing best match criteria are described. In one embodiment, a method includes matching a plurality of invoice records to a plurality of receipt records based on a first set of criteria. When an invoice record matches no more than one receipt record, the invoice record is marked to indicate that the invoice record is matched to the receipt record. When an invoice record matches at least two receipt records based on the first set of criteria, one of the at least two receipt records is selected as a best match receipt record based on a second set of criteria. The invoice record is marked to indicate that the invoice record is matched to the selected receipt record. The invoice records determined to have matching receipt records are transmitted for payment by a financial system.

Claims

1. A non-transitory computer-readable medium storing computer-executable instructions that when executed by a computing device cause the computing device to:

receive a plurality of invoice records from an inventory database, where each invoice record stores data describing an invoice quantity of items and an invoice cost;

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

match the plurality of invoice records to the plurality of receipt records such that a given invoice record is deemed to match a given receipt record when a first set of criteria are met;

for each invoice record that matches a single receipt record and no other receipt record, record data in the invoice record indicating that the invoice record is matched to the receipt record;

for each invoice record that matches at least two receipt records based on the first set of criteria, the computing device is caused to;

(i) use a second set of criteria to select one of the at least two receipt records as a best match receipt record for the invoice when at least one of the second set of criteria are met as between the invoice record and a single one of the at least two receipt records, wherein the second set of criteria is evaluated using a different technique from the first set of criteria and the different technique is subsequent in order of priority to a technique used to evaluate the first set of criteria; and

(ii) record data in the invoice record indicating that the invoice record is matched to the selected receipt record;

where the first set of criteria is different from the second set of criteria;

transmit, via a network communication to a remote system, the invoice records determined to have matching receipt records; and

transmit, via the network communication to the remote system, a command to initiate payment of the invoice records by the remote system.

2. The non-transitory computer-readable medium of claim 1, wherein the instructions to selectively utilize criteria comprise instructions configured to cause the computing device to select a single one of the at least two receipt records having a receipt cost that is closest to the invoice cost as the best match receipt record for the invoice record.

3. The non-transitory computer-readable medium of claim 1, wherein the instructions to selectively utilize criteria comprise instructions configured to cause the computing device to select a single one of the at least two receipt records having a receipt cost that is more than the invoice cost as the best match receipt record for the invoice record.

4. The non-transitory computer-readable medium of claim 1, wherein the instructions to selectively utilize criteria comprise instructions configured to cause the computing device to select a single one of the at least two receipt records having a fewest number of item level variances with respect to the invoice record as the best match receipt record for the invoice record.

5. The non-transitory computer-readable medium of claim 1, wherein the instructions to selectively utilize criteria comprise instructions configured to cause the computing device to select a single one of the at least two receipt records having a receipt quantity that is closest to the invoice quantity as the best match receipt record for the invoice record.

6. The non-transitory computer-readable medium of claim 1, wherein the instructions to selectively utilize criteria comprise instructions configured to cause the computing device to:

select a single one of the at least two receipt records having a receipt cost that is closest to the invoice cost as the best match receipt record for the invoice;

in response to no single one of the at least two receipt records having a receipt cost that is closest to the invoice cost, select a single one of the at least two receipt records having a receipt cost that is more than the invoice cost as the best match receipt record for the invoice record when no more than one receipt record has a receipt cost that is more than the invoice cost;

in response to no single receipt record having i) a receipt cost that is closest to the invoice cost or ii) a receipt cost that is more than the invoice cost, select a single one of the at least two receipt records having a fewest number of item level variances with respect to the invoice record as the best match receipt record for the invoice record; and

in response to no single receipt record having i) a receipt cost that is closest to the invoice cost or ii) a receipt cost that is more than the invoice cost or iii) a fewest number of item level variances with respect to the invoice record, select a single one of the at least two receipt records having a receipt quantity that is closest to the invoice quantity as the best match receipt record for the invoice record.

7. The non-transitory computer-readable medium of claim 1, comprising instructions configured to cause the computing device to transmit invoice records that do not have a matching receipt to a computing system that supports manual resolution.

8. A computing system, comprising:

a processor connected to memory; and

a module stored on a non-transitory computer readable medium and configured with instructions that when executed by the processor cause the processor to;

receive a plurality of invoice records from an inventory database, where each invoice record stores data describing an invoice quantity of items and an invoice cost;

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

match the plurality of invoice records to the plurality of receipt records such that a given invoice record is deemed to match a given receipt record when a first set of criteria are met;

for each invoice record that matches a single receipt record and no other receipt record, recording data in the invoice record indicating that the invoice record is matched to the receipt record; and

for each invoice record that matches at least two receipt records based on the first set of criteria, the computing device is cause to;

(i) use a second set of criteria to select one of the at least two receipt records as a best match receipt record for the invoice when at least one of the second set of criteria are met as between the invoice record and a single one of the at least two receipt records, wherein the second set of criteria is evaluated using a different technique from the first set of criteria and the different technique is subsequent in order of priority to a technique used to evaluate the first set of criteria; and

(ii) record data in the invoice record indicating that the invoice record is matched to the selected receipt record;

where the first set of criteria is different from the second set of criteria;

transmit, via a network communication to a remote system, the invoice records determined to have matching receipt records; and

transmit, via the network communication to the remote system, a command to initiate payment of the invoice records by the remote system.

9. The computing system of claim 8, wherein the instructions to selectively utilize criteria comprise instructions that cause the processor to select a single one of the at least two receipt records having a receipt cost that is closest to the invoice cost as the best match receipt record for the invoice record.

10. The computing system of claim 8, wherein the instructions to selectively utilize criteria comprise instructions that cause the processor to select a single one of the at least two receipt records having a receipt cost that is more than the invoice cost as the best match receipt record for the invoice record.

11. The computing system of claim 8, wherein the instructions to selectively utilize criteria comprise instructions that cause the processor to select a single one of the at least two receipt records having a fewest number of item level variances with respect to the invoice record as the best match receipt record for the invoice record.

12. The computing system of claim 8, wherein the instructions to selectively utilize criteria comprise instructions that cause the processor to select a single one of the at least two receipt records having a receipt quantity that is closest to the invoice quantity as the best match receipt record for the invoice record.

13. The computing system of claim 8, wherein the instructions cause the processor to transmit invoice records that do not have a matching receipt to a computing system that supports manual resolution.

14. A computer-implemented method, comprising:

receiving, by a processor, a plurality of invoice records from an inventory database, where each invoice record stores data describing an invoice quantity of items and an invoice cost;

receiving, by the processor, a plurality of receipt records from a receipt database, where each receipt record includes data describing a receipt quantity of items and a receipt cost;

matching, by the processor, the plurality of invoice records to the plurality of receipt records such that a given invoice record is deemed to match a given receipt record when a first set of criteria are met;

for each invoice record that matches a single receipt record and no other receipt record, recording data in the invoice record indicating that the invoice record is matched to the receipt record;

for each invoice record that matches at least two receipt records based on the first set of criteria, the computing device is caused to;

(i) use a second set of criteria to select one of the at least two receipt records as a best match receipt record for the invoice when at least one of the second set of criteria are met as between the invoice record and a single one of the at least two receipt records, wherein the second set of criteria is evaluated using a different technique from the first set of criteria and the different technique is subsequent in order of priority to a technique used to evaluate the first set of criteria; and

(ii) record, by the processor, data in the invoice record indicating that the invoice record is matched to the selected receipt record;

where the first set of criteria is different from the second set of criteria;

transmitting, by the processor via a network communication to a remote system, the invoice records determined to have matching receipt records; and

transmit, by the processor via the network communication to the remote system, a command to initiate payment of the invoice records by the remote system.

15. The computer-implemented method of claim 14, wherein the selectively utilizing criteria comprises selecting a single one of the at least two receipt records having a receipt cost that is closest to the invoice cost as the best match receipt record for the invoice record.

16. The computer-implemented method of claim 14, wherein the selectively utilizing criteria comprises selecting a single one of the at least two receipt records having a receipt cost that is more than the invoice cost as the best match receipt record for the invoice record.

17. The computer-implemented method of claim 14, wherein the selectively utilizing criteria comprises selecting a single one of the at least two receipt records having a fewest number of item level variances with respect to the invoice record as the best match receipt record for the invoice record.

18. The computer-implemented method of claim 14, wherein the selectively utilizing criteria comprises selecting a single one of the at least two receipt records having a receipt quantity that is closest to the invoice quantity as the best match receipt record for the invoice record.

19. The computer-implemented method of claim 14, wherein the selectively utilizing criteria comprises:

selecting a single one of the at least two receipt records having a receipt cost that is closest to the invoice cost as the best match receipt record for the invoice;

in response to no single one of the at least two receipt records having a receipt cost that is closest to the invoice cost, selecting a single one of the at least two receipt records having a receipt cost that is more than the invoice cost as the best match receipt record for the invoice record when no more than one receipt record has a receipt cost that is more than the invoice cost;

in response to no single receipt record having i) a receipt cost that is closest to the invoice cost or ii) a receipt cost that is more than the invoice cost, select a single one of the at least two receipt records having a fewest number of item level variances with respect to the invoice record as the best match receipt record for the invoice record; and

in response to no single receipt record having i) a receipt cost that is closest to the invoice cost or ii) a receipt cost that is more than the invoice cost or iii) a fewest number of item level variances with respect to the invoice record, select a single one of the at least two receipt records having a receipt quantity that is closest to the invoice quantity as the best match receipt record for the invoice record.

20. The computer-implemented method of claim 14, comprising transmitting invoice records that do not have a matching receipt to a computing system that supports manual resolution.