A freight invoice audit checks a supplier’s bill against the approved buy rate or agreement, the service booked and evidence of what happened on the shipment. The purpose is to identify incorrect, duplicate or unsupported charges before an invoice is approved for payment—and to document why a valid difference was accepted.
Download the freight invoice audit and reconciliation worksheet to register invoices, review charge lines, track discrepancies and retain the approval decision. It is a working template for your finance and operations process; adapt approval limits and document requirements to your organization.
What Is Freight Invoice Reconciliation?
Freight invoice reconciliation compares what a supplier billed with what the forwarder expected to pay for the service actually provided. The expected amount may come from an approved carrier contract, spot rate, agent agreement or authorized amendment. The shipment and booking records establish which service, quantity and events apply.
A complete review asks three questions:
- Was this the supplier and service used for the shipment?
- Does each billed charge follow an applicable approved rate or documented exception?
- Is there evidence for the quantity, event and amount being charged?
This checklist concerns supplier invoices received by the forwarder. Customer invoice creation, quote approval and overall margin analysis are related processes, but each has its own decision and evidence.
Download The Reconciliation Worksheet
The workbook has six tabs:
| Tab | Purpose |
|---|---|
| Read Me | Explains the sequence and worksheet limits |
| Invoice Register | Records supplier invoice details and flags a possible duplicate supplier-and-invoice-number combination |
| Audit Checklist | Captures each check, status, reviewer and evidence reference |
| Line Matches | Compares expected and invoiced amounts on the same currency and unit basis |
| Discrepancy Log | Tracks questions, supplier replies, credits and resolutions |
| Approval Record | Records the authorized approve, hold or reject decision |
The Line Matches tab calculates an expected amount from the entered quantity and approved unit rate. It displays a variance only when the expected and invoiced units and currencies match. A separate check compares the invoice’s entered line amount with its billed quantity × billed unit rate. The workbook does not convert currencies or decide whether a variance is acceptable.
Download the freight invoice reconciliation worksheet
Freight Invoice Audit Checklist
Work through these checks after the invoice is received and before payment release.
1. Register And Identify The Invoice
Record the supplier, invoice number, dates, currency, total and job or shipment reference. Check for the same supplier-and-invoice-number combination, a previously paid invoice, credit note or revised invoice. A possible duplicate is a prompt for investigation, not an automatic rejection.
2. Match The Supplier And Service
Confirm that the supplier billed is the provider booked or otherwise authorized for the service. Match the invoice’s job, booking, shipment, container or air waybill references to the operational record. Investigate charges assigned to the wrong job or billed by an unexpected party.
3. Find The Applicable Approved Rate
Locate the contract, spot offer, agent agreement or authorized amendment that applies to the service. Check its version, validity dates, trade lane, equipment, cargo conditions, charge basis and the event that determines rate applicability. Preserve the source reference used in the review.
A customer quote may help explain the expected margin, but it is not a substitute for the supplier’s approved buy-rate evidence.
4. Compare Charges Line By Line
Map each supplier description to an internal charge category while preserving the original label. Check the quantity, unit, rate, currency, minimum and net billed amount.
| Charge | Evidence to compare |
|---|---|
| Base freight | Approved rate, mode, route, equipment or chargeable quantity |
| Fuel or other surcharge | Applicable rule, amount or percentage, effective date and calculation basis |
| Origin and destination charges | Agreed service scope and the charge’s inclusion or exclusion |
| Documentation | Document or processing activity actually requested or completed |
| Storage, detention or waiting | Event dates, applicable free time, unit and supporting record |
| Other accessorial | Triggering instruction or event and the applicable agreed charge |
Similar names do not always describe the same service. Verify a suspected duplicate against the underlying inclusions before removing it. The freight surcharge guide explains common charge bases and validity questions in more detail.
5. Check Invoice Arithmetic And Currency
Compare each billed line amount with its stated quantity × unit rate, allowing for the supplier’s documented rounding or minimum rules. Reconcile line totals to the invoice summary. Review taxes under your finance policy as a separate check.
Do not subtract amounts in different currencies as if they were comparable. If the approved reference and invoice use different currencies, record the agreed conversion source, date and rule before determining a variance.
6. Log And Resolve Differences
Give each discrepancy a reference, invoice line, reason, owner and evidence request. Ask the supplier for support or a corrected invoice where appropriate. Record whether the charge is confirmed, amended, credited, disputed or accepted as an authorized exception.
Do not overwrite the original invoiced amount when a supplier responds. Keep the first bill, correspondence and revised document linked so the decision can be reconstructed.
7. Approve Or Hold With Evidence
The reviewer should identify any open differences and the documents checked. An authorized approver then records the approve, hold or reject decision according to your internal policy. A zero numeric variance does not by itself establish that the correct supplier, service or event was billed.
Freight Invoice Reconciliation Example
The following figures are illustrative, not current rates.
An approved charge is USD 200 per container for a defined service. The supplier invoice shows USD 240 against one container and labels the extra USD 40 as a surcharge.
The reviewer should not approve or reject the USD 40 based on the label alone. Check whether the surcharge was part of the base rate, whether a separate rule applies to this shipment, its effective date and the event or quantity used to calculate it. Record the source and supplier explanation. If the charge is supported, document the authorized exception or approved amendment. If it is unsupported, hold the affected amount and seek a correction or credit under the company’s process.
What Evidence Should Be Kept?
A completed audit record should let another reviewer identify the basis for the decision without reconstructing an email thread. Retain or reference:
- The original supplier invoice and any revision or credit note.
- The applicable approved rate, contract, spot offer or amendment.
- The booking or service instruction and relevant shipment reference.
- Evidence for event-based charges, such as dates or service confirmations.
- The line comparison and calculation or currency basis used.
- Supplier clarification and the resolution of each discrepancy.
- The reviewer, authorized approver, decision and date.
Store the documents under your organization’s retention and access rules. The worksheet can point to controlled document locations rather than hold sensitive attachments itself.
When Is The Audit Complete?
The invoice is ready for an approval decision when its supplier and shipment are identified, charge lines have an applicable basis, arithmetic and currency checks are complete, and discrepancies have a documented resolution or an explicit hold. The authorized approver makes the payment decision.
The broader commercial effect can then be reviewed in margin leakage in freight forwarding. Controls applied before a customer quote is sent belong in freight quote governance.
Frequently Asked Questions
It is a review of a supplier invoice against the approved rate or agreement, the booked service and shipment evidence before payment approval.
Invoice reconciliation decides whether supplier charges are supported and correctly billed. Margin analysis compares expected and realized commercial results across the job, including customer revenue and final supplier costs.
No. Some differences follow a valid amendment, changed shipment quantity or additional service. Investigate the cause, retain evidence and record an authorized decision before approving or disputing the charge.
No. Its formulas assist with line arithmetic and same-basis variance checks. A reviewer still confirms the supplier, shipment, service, source documents and any exceptions; an authorized person records the approval decision.