Enhanced trade compliance system: audit processing, payment balancing process and amendment processing

• US 7,389,286 B2
• Filed: 01/19/2005
• Issued: 06/17/2008
• Est. Priority Date: 12/27/2002
• Status: Expired due to Fees

• Current Assignee: Honda Motor Co., Ltd. (Honda Motor Company)
• Original Assignee: Honda Motor Co., Ltd. (Honda Motor Company)
• Inventors: Potts, Tom, Peach, Laurie, Holmes, Frederic, Halterman, Matt, Swirt, Mark, Uy, Anthony
• Primary Examiner(s): Lee; Wilson
• Application Number:
  US11/039,003
• Publication Number:
  US 20060015418A1
• Time in Patent Office: 1,245 Days
• Field of Search: 707/100, 707/101, 707/102, 707 1- 10, 705/26, 705/30, 705/40
• US Class Current: 1/1
• CPC Class Codes: G06Q 10/06 Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
• CPC Class Codes: G06Q 10/10 Office automation; Time management
• CPC Class Codes: G06Q 30/04 Billing or invoicing
• CPC Class Codes: G06Q 40/12 Accounting
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching

Abstract

Methods and systems for auditing invoice and payment records are disclosed. A computer system may receive a plurality of invoices and payment records, compare one of the invoices to a matching one of the payment records to identify a discrepancy between the invoice and the payment record, calculate an error value as a function of the identified discrepancy, determine that the calculated error value exceeds a tolerance value, and generate an reporting the identified discrepancy. Methods and systems for balancing invoices and payment records are also disclosed. A computer system may compare dates and payment amounts of the invoices to dates and payment amounts of the payment records, and identify matches between the two. The computer system may then display lists of unmatched invoices and payment records for a user to manually examine.

Claims

1. A method used in connection with balancing payment records and invoices, comprising:

receiving a plurality of invoices in a computer system, each invoice referring to a shipment;

receiving a plurality of payment records in the computer system, each payment record referring to a shipment;

identifying a plurality of unmatched invoices, each having no matching payment record in the plurality of payment records;

identifying a plurality of unmatched payment records, each having no matching invoice in the plurality of invoices;

generating a first list including the unmatched invoices and a second list including the unmatched payment records; and

displaying the first and second lists together.

2. The method of claim 1 further comprising receiving input from a user representing a match between a invoice displayed in the first list and an payment record displayed in the second list.

3. The method of claim 2 farther comprising receiving an additional input from the user representing a correction to at least one of the payment record displayed in the first list and the invoice displayed in the second list and, in response to receiving the addition input, editing at least one of the payment record and the invoice to reflect the correction.

4. The method of claim 3 further comprising an emendment report including information about the edit.

5. Computer-readable media embodying a program of instructions executable by a computer to perform a method used in connection with balancing invoice and payment records, the method comprising:

receiving a plurality of invoices in a computer system, each invoice referring to a shipment;

receiving a plurality of payment records in the computer system, each payment record referring to a shipment;

identifying a plurality of unmatched invoices, each having no matching payment record in the plurality of payment records;

identifying a plurality of unmatched payment records, each having no matching invoice in the plurality of invoices;

generating a first list including the unmatched invoices and a second list including the unmatched payment records; and

displaying the first and second lists together.

6. A system for balancing invoice and payment records comprising:

an input configured to receive a plurality of invoices and a plurality of payment records, each invoice referring to a shipment and each payment record referring to a shipment;

a processor configured to identify a plurality of unmatched invoices each having no matching payment record in the plurality of payment records, identify a plurality of unmatched payment records each having no matching invoice in the plurality of invoices, and generate a first list including the unmatched invoices and a second list including the unmatched payment records; and

a display device configured to display the first and second lists together.