NEW
Supplier quote comparison
Compare two supplier offers on the same purchase quantity and cost basis.
ProcurementPROCUREMENT
Freight Invoice Audit & Duplicate Charge Checker
Match shipment and charge totals, retain every billed row, and review differences and repeated line identifiers.
Freight invoice audit calculator
Match shipment and charge totals, retain every billed row, and review differences and repeated line identifiers.
YOUR RESULT LIVE CALCULATION
Freight invoice audit
4charge groups to review
REVIEW FLAGS / NO AUTOMATIC DISPUTES OR DEDUCTION- Contracted total (USD)
- $1,320.00
- All billed rows, including repeats
- $1,100.00
- Matched net difference
- $55.00
- Positive discrepancies beyond tolerance
- $55.00
- Negative discrepancies beyond tolerance
- $0.00
- Uncontracted billed amount (net)
- $25.00
- Unbilled contracted amount (net)
- $300.00
- Repeated invoice/line IDs / extra exact rows
- 1 / 1
All billed rows are counted; none are automatically removed. Multiple lines may be valid splits or credits. Differences compare aggregate shipment/charge totals against the larger of the absolute or percentage tolerance. Missing contract and missing billing are separate review statuses, not proven overcharges or savings. Use one currency and comparable charge/tax boundaries. No carrier, payment system, or dispute service is contacted.
Charge comparison (USD)
6 rows
| Shipment | Charge | Contracted | Billed | Billed - contracted | Allowed difference | Billed rows | Status |
|---|---|---|---|---|---|---|---|
| SHIP-100 | FREIGHT | 500 | 500 | 0 | 2.5 | 1 | Within tolerance |
| SHIP-100 | FUEL | 75 | 85 | 10 | 1 | 1 | Over tolerance |
| SHIP-101 | FREIGHT | 400 | 400 | 0 | 2 | 1 | Within tolerance |
| SHIP-101 | LIFTGATE | 45 | 90 | 45 | 1 | 2 | Over tolerance; Multiple billed lines: review; Repeated invoice/line ID; Possible exact duplicate |
| SHIP-102 | FREIGHT | 300 | N/A | N/A | 1.5 | 0 | No billed line |
| SHIP-999 | STORAGE | N/A | 25 | N/A | N/A | 1 | No contracted charge |
Entered billed lines (USD)
6 rows
| Invoice | Line | Shipment | Charge | Billed | Duplicate checks |
|---|---|---|---|---|---|
| INV-700 | 1 | SHIP-100 | FREIGHT | 500 | No repeated row ID |
| INV-700 | 2 | SHIP-100 | FUEL | 85 | No repeated row ID |
| INV-701 | 1 | SHIP-101 | FREIGHT | 400 | No repeated row ID |
| INV-701 | 2 | SHIP-101 | LIFTGATE | 45 | Repeated invoice/line ID |
| INV-701 | 2 | SHIP-101 | LIFTGATE | 45 | Repeated invoice/line ID; Possible exact duplicate: extra row |
| INV-702 | 1 | SHIP-999 | STORAGE | 25 | No repeated row ID |
BEHIND THE NUMBER
How the calculation works
Enter one contracted total per shipment/charge and separate invoice lines in the billing dataset. Identifiers match after trimming and uppercasing. Amounts use exact currency minor units (two decimals, or whole JPY); credits may be negative. Differences strictly beyond the larger tolerance are flagged in either direction. Repeated invoice/line IDs, extra identical rows, multiple billed lines, uncontracted charges, and unbilled contract entries have distinct review flags. All rows remain in totals and exports.
Difference = sum of all billed rows for a shipment/charge - contracted total. Allowed difference = max(absolute tolerance, absolute contracted amount x percentage tolerance).
When this calculation helps
Review matched charge differences separately from uncontracted billing and unbilled contract entries. A lower grand total can conceal an over-tolerance accessorial when another charge has not yet been invoiced.
Check the interpretation
Repeated invoice/line IDs and identical extra rows are questions for a reviewer, not proof of a duplicate. Keep credits and splits in the totals, verify the source import, and retain the contract version and service approval before pursuing an adjustment.
Review indicators only, not confirmed duplicate charges, recoverable savings, payment authorization, or an automatic carrier dispute. Splits, credits, contract amendments, taxes, and accessorial approvals can explain a difference. Use a single currency and the same scope in both datasets. Each CSV is limited to 512 KB and 1,000 rows. Tolerances support two decimal places; JPY absolute tolerance uses whole units.
UPS billing and invoice adjustment informationWorked example: Freight Invoice Auditing: Match Charges Before Disputing Them
Good to know
Are duplicates removed?
No. Every entered billed row remains in the totals. Repeated invoice/line IDs and identical extra rows are flags for human review, not proof that a charge is invalid.
Can positive and negative differences cancel?
The matched net difference is shown separately from positive and negative discrepancies beyond tolerance. Uncontracted and unbilled items are separate, so a net total cannot hide those review statuses.