Automated audit process

• US 8,326,709 B1
• Filed: 12/04/2008
• Issued: 12/04/2012
• Est. Priority Date: 12/31/2002
• Status: Active Grant

• Current Assignee: Accenture Global Services Limited (Accenture PLC)
• Original Assignee: Accenture Global Services Limited (Accenture PLC)
• Inventors: Spreng, Jim L., Peterson, Scott, O'Connor, Daniel P., Peppard, David W.
• Primary Examiner(s): Zeender, F.
• Assistant Examiner(s): Haider, Fawaad
• Application Number:
  US12/327,992
• Time in Patent Office: 1,461 Days
• Field of Search: 705/30
• US Class Current: 705/30
• CPC Class Codes: G06Q 20/102 Bill distribution or payments
• CPC Class Codes: G06Q 20/209 Specified transaction journal output feature, e.g. printed receipt or voice output
• CPC Class Codes: G06Q 30/02 Marketing; Price estimation or determination; Fundraising
• CPC Class Codes: G06Q 30/0283 Price estimation or determination
• CPC Class Codes: G06Q 40/00 Finance; Insurance; Tax strategies; Processing of corporate or income taxes
• CPC Class Codes: G06Q 40/12 Accounting

Abstract

A process for increasing profits of a business engaged in the purchase of large numbers of products and/or products of volatile pricing from numerous vendors that operates to identify pricing errors, preferably typically before payment, by automatically reviewing all invoices typically in the order they are received to determine a best system price for each line item of each invoice by reference to pricing factors such as volume discount, seasonal pricing, price protection, commodity pricing, competition pricing, and cash discount recorded in memory for the subject item and reference to payment history data, accounts payable data and invoice data. From the pricing factors and associated data, a best system price is determined and compared to the invoice price for the item so that pricing errors are automatically uncovered and, if appropriate, flagged to identify the same as an exception for warning or notification.

Claims

1. A computer-implemented method comprising:

accessing an invoice received from a vendor of an enterprise;

identifying an item and a quantity for the item listed on the invoice;

determining a base date and an invoice price associated with the item;

selecting, from among multiple prices stored for the item and the vendor in a storage medium, a lowest price that is valid for the identified quantity of the item on the associated base date;

designating the lowest price as a best system price that applies on the base date;

comparing the best system price with the invoice price; and

flagging, by one or more computers, the invoice as an exception when the invoice price of the item exceeds the best system price by a predefined threshold.

2. The method of claim 1, further comprising:

storing a list of items expected to be purchased by the enterprise, prices associated with each item expected to be purchased, and terms associated with each price, each term including an effective date term,

wherein the lowest price is determined based on comparing the base date associated with the identified item with the stored list.

3. The method of claim 2, wherein the terms further comprise sales volume terms, price protection terms, seasonal pricing terms, commodity pricing terms, competition pricing terms, and cash discount terms, collectively.

4. The method of claim 1, wherein determining the lowest price further comprises determining whether price protection was in effect on the associated base date.

5. The method of claim 4, wherein determining whether price protection was in effect on the associated base date further comprises calculating a receipt of goods (ROG) date for the respective item.

6. The method of claim 1, wherein flagging the invoice as an exception further comprises:

generating a warning when the invoice price of any identified item exceeds the best system price by a predefined threshold, and when payment for the item has not been made to the vendor;

generating a notification when the invoice price of any identified item exceeds the best system price by a predefined threshold, and when payment for the item has been made to the vendor; and

generating a report of warnings and notifications.

7. The method of claim 1, wherein the base date for each item comprises a purchase order date or an invoice date.

8. The method of claim 1, wherein determining the invoice price associated with the item further comprises:

determining an invoice price associated with a group of items;

determining a quantity of items in the group; and

dividing the invoice price associated with the group of items by the quantity of items in the group.

22. The method of claim 1, wherein selecting a lowest price that is valid for the identified quantity of the item on the associated base date comprises:

determining that the quantity satisfies a volume break quantity associated with a volume discount offered by the vendor for the item on the base date.

9. A system comprising:

one or more computers; and

a computer-readable medium coupled to the one or more computers having instructions stored thereon which, when executed by the one or more computers, cause the one or more computers to perform operations comprising;

accessing an invoice received from a vendor of an enterprise,

identifying an item and a quantity for the item listed on the invoice,

determining a base date and an invoice price associated with the item,

selecting, from among multiple prices stored for the item and the vendor in a storage medium, a lowest price that is valid for the identified quantity of the item on the associated base date,

designating the lowest price as a best system price that applies on the base date,

comparing the best system price with the invoice price, and

flagging the invoice as an exception when the invoice price of the item exceeds the best system price by a predefined threshold.

10. The system of claim 9, wherein the operations further comprise:

storing a list of items expected to be purchased by the enterprise, prices associated with each item expected to be purchased, and terms associated with each price, each term including an effective date term,

wherein the lowest price is determined based on comparing the base date associated with the identified item with the stored list, and

wherein the terms further comprise sales volume terms, price protection terms, seasonal pricing terms, commodity pricing terms, competition pricing terms, and cash discount terms, collectively.

11. The system of claim 9, wherein determining the lowest price further comprises determining whether price protection was in effect on the associated base date.

12. The system of claim 11, wherein determining whether price protection was in effect on the associated base date further comprises calculating a receipt of goods (ROG) date for the respective item.

13. The system of claim 9, wherein flagging the invoice as an exception further comprises:

generating a warning when the invoice price of any identified item exceeds the best system price by a predefined threshold, and when payment for the item has not been made to the vendor;

generating a notification when the invoice price of any identified item exceeds the best system price by a predefined threshold, and when payment for the item has been made to the vendor; and

generating a report of warnings and notifications.

14. The method of claim 9, wherein the base date for each item comprises a purchase order date or an invoice date.

15. The system of claim 9, wherein determining the invoice price associated with the item further comprises:

determining an invoice price associated with a group of items;

determining a quantity of items in the group; and

dividing the invoice price associated with the group of items by the quantity of items in the group.

16. A non-transitory computer-readable medium encoded with a computer program comprising instructions that, when executed, operate to cause a computer to perform operations comprising:

accessing an invoice received from a vendor of an enterprise;

identifying an item and a quantity for the item listed on the invoice;

determining a base date and an invoice price associated with the item;

selecting, from among multiple prices stored for the item and the vendor in a storage medium, a lowest price that is valid for the identified quantity of the item on the associated base date;

designating the lowest price as a best system price that applies on the base date;

comparing the best system price with the invoice price; and

flagging the invoice as an exception when the invoice price of the item exceeds the best system price by a predefined threshold.

17. The computer-readable medium of claim 16, wherein the operations further comprise:

storing a list of items expected to be purchased by the enterprise, prices associated with each item expected to be purchased, and terms associated with each price, each term including an effective date term,

wherein the lowest price is determined based on comparing the base date associated with the identified item with the stored list, and

wherein the terms further comprise sales volume terms, price protection terms, seasonal pricing terms, commodity pricing terms, competition pricing terms, and cash discount terms, collectively.

18. The computer-readable medium of claim 16, wherein determining the lowest price further comprises determining whether price protection was in effect on the associated base date.

19. The computer-readable medium of claim 18, wherein determining whether price protection was in effect on the associated base date further comprises calculating a receipt of goods (ROG) date for the respective item.

20. The computer-readable medium of claim 16, wherein flagging the invoice as an exception further comprises:

generating a warning when the invoice price of any identified item exceeds the best system price by a predefined threshold, and when payment for the item has not been made to the vendor;

generating a notification when the invoice price of any identified item exceeds the best system price by a predefined threshold, and when payment for the item has been made to the vendor; and

generating a report of warnings and notifications.

21. The computer-readable medium of claim 16, wherein determining the invoice price associated with the item further comprises:

determining an invoice price associated with a group of items;

determining a quantity of items in the group; and

dividing the invoice price associated with the group of items by the quantity of items in the group.