Enhanced trade compliance system: audit processing, payment balancing and amendment processing
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.
1. A non-transitory computer-readable storage media embodying a program of instructions which perform the following method of auditing invoice and payment records when executed by a computer system, the method comprising the steps of:
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 matched sets of invoices and payment records, wherein each matched set includes an invoice and payment record referring to the same shipment;
identifying a discrepancy within each of a plurality of the matched sets between the invoice and payment record in that matched set;
identifying a common attribute among the plurality of matched sets, each of which have the identified discrepancy between the invoice and payment record in the respective matched set; and
generating an output from the computer system reporting the identified common attribute among the matched sets which each have the identified discrepancy between the invoice and payment record in the respective matched set.
2. The method of claim 1 wherein the discrepancy between the invoice and payment record in each matched set that has the common attribute is in duty amounts and is caused by an incorrect HTS classification.
3. A system for auditing invoice and payment records comprising:
an input device 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 matched sets of invoices and payment records wherein each matched set includes an invoice and payment record referring to the same shipment;
identify a discrepancy between the invoice and payment record for each of a plurality of the matched sets;
identify a common attribute among the plurality of matched sets, each of which have the identified discrepancy between the invoice and payment record in the respective matched set; and
generating an output reporting the identified common attribute among the matched sets which each have the identified discrepancy between the invoice and payment record in the respective matched set; and
a display device configured to display the output reporting the identified common attribute among the matched sets which each have the identified discrepancy between the invoice and payment record in the respective matched set.
4. The system of claim 3 wherein the processor is configured to:
calculate an error value for each one of the plurality of matched sets as a function of the identified discrepancy; and
determine that each calculated error value exceeds a predetermined tolerance value.
5. The computer-readable storage media of claim 1 further comprising:
calculating an error value for each one of the plurality of matched sets as a function of the identified discrepancy; and
determining that each calculated error value exceeds a predetermined tolerance value.
6. The computer-readable storage media of claim 1 wherein the identified common attribute is the same product.
7. The computer-readable storage media of claim 6 wherein the identified discrepancies between the matched sets of invoice and payment records that have the same identified product is a discrepancy in the duty owed for importation of the product.
8. The computer-readable storage media of claim 7 wherein the discrepancy in the duty is caused by the incorrect assignment of a Harmonized Tariff Schedule code to the product.