Freight Invoice Auditing: Match Charges Before Disputing Them
A worked invoice reconciliation showing tolerances, credits, repeated line IDs, and why a lower invoice total can still hide charges worth reviewing.
Start with a comparable charge boundary
An invoice audit needs more than a quoted grand total and a billed grand total. Define the shipment reference, charge code, currency, and scope of each contracted amount. Freight, fuel, liftgate service, storage, and taxes may be separate charges. An amended rate or an approved extra service belongs in the supporting evidence. Comparing an original quote that excludes accessorials with a final invoice that includes them creates a review question, not proof that the carrier billed incorrectly.
Worked example: a smaller invoice with unresolved differences
The IronTandem example has five contracted shipment/charge totals worth $1,320 and six entered billed rows worth $1,100. The overall billed amount is $220 lower, but that net movement is not a saving. Matched charges are $55 higher, a $25 storage charge has no contract match, and a $300 contracted freight line has no billing match. Reconciliation is $1,320 + $55 + $25 - $300 = $1,100. Each component calls for a different investigation.
Apply tolerances to the matched amount
The example uses a $1 absolute tolerance and a 0.50% percentage tolerance. For a contracted $500 freight charge, the larger allowance is $2.50. For a $75 fuel charge, the larger allowance is $1. The billed $85 fuel amount is $10 above its contracted amount, so it is outside tolerance. A difference exactly equal to the allowance is within tolerance in this model. Keep the contractual rounding convention with the audit; do not silently replace a carrier agreement with a spreadsheet preference.
Keep repeated lines and credits in view
The $45 liftgate charge appears twice under the same invoice and line identifier. Both rows remain in the billed total, and the repeated identifier and identical extra row receive separate flags. This could be a true duplicate, an import repeated twice, or an unusual source-system representation. A legitimate split or negative credit can also create multiple lines for one shipment/charge. Removing rows automatically would conceal how the entered invoice reconciles and could overstate recoverable money.
Build a review packet rather than an automatic deduction
For an over-tolerance charge, retain the quote or contract version, invoice number, line identifier, shipment reference, delivery evidence, and relevant accessorial approval. For an uncontracted line, first establish whether the charge was authorized elsewhere. For an unbilled line, check timing and cancellation before calling it a liability or omission. Record the question and the evidence needed to answer it. Follow the billing provider's current adjustment process rather than treating a calculator flag as a submitted dispute.
Close the loop with an auditable result
After a reviewer resolves a question, retain the original extract and add the approved explanation or corrected source file. A useful outcome distinguishes confirmed errors, valid charges, credits pending, and unresolved items. Report reviewed amounts separately from cash actually recovered. IronTandem performs the entered comparison locally and exports the detail; it does not contact a carrier, authorize payment, or determine legal entitlement. Reconcile a fresh export after a credit arrives so the same issue is not counted twice.