How to audit freight and 3PL invoices, step by step

Executive Summary

Freight invoices carry more variables per line than almost any other AP category: base rate, fuel surcharge, accessorials, and mode. Each variable is set by a different document, and few AP teams hold all of them side by side when an invoice is approved. The invoice gets paid against the carrier's own number, not against the rate agreement that was supposed to set it, and the gap between those two numbers is margin drift.

The mechanism is document fragmentation, not carrier misconduct. The rate agreement lives in one file, the fuel surcharge table in another, and the accessorial schedule in a third, often revised separately and rarely reconciled against each other before payment. What changes it is a repeatable audit sequence that pulls all three documents together against the invoice, line by line, on a fixed cadence, rather than trusting the invoice as its own source of truth.

This guide gives the seven-step sequence: build the reference file, pull the invoice population, verify the base rate, verify the fuel surcharge, verify accessorials, reconcile discrepancies, and close the loop with the carrier. Each step names what to check it against and what a failure looks like, so an AP or procurement lead can run this against a real invoice batch rather than treat it as background reading.

1. What documents do you need before you start the audit?

You need four documents assembled before you open a single invoice: the carrier rate agreement or tariff, the current fuel surcharge schedule, the accessorial charge schedule, and the bill of lading or shipment record for each invoice under review. Auditing against the invoice's own printed rate, instead of these source documents, is not an audit. It is a reconciliation of the invoice against itself.

Step 1: Pull the master rate agreement for each carrier in scope, including any lane-specific or volume-tier addenda signed after the base agreement. Step 2: Pull the fuel surcharge schedule referenced in that agreement and confirm which index it ties to and how often it resets.

Step 3: Pull the accessorial schedule, which lists charges like detention, liftgate, residential delivery and redelivery, each with its own rate and trigger condition. Step 4: Pull the bill of lading, weight certificate, or delivery receipt for each invoice, since these establish the facts an invoice should be priced against, not the carrier's own summary of them.

A rate agreement without a signed effective date, or an accessorial schedule that predates the current contract term, is not a usable reference. Confirm the version in hand is current before you audit a single invoice against it.

A. Building the reference file

Consolidate the rate agreement, fuel schedule, and accessorial schedule into a single reference file per carrier, indexed by lane and effective date. This is the file every subsequent invoice gets checked against, so it needs to be built once and kept current rather than reassembled per invoice.

2. How do you pull the right invoice population to audit?

Pull every freight and 3PL invoice for the period under review, not a sample chosen by size. Group them by carrier and lane, then by mode, since a truckload invoice and a less-than-truckload invoice draw on different sections of the same rate agreement. A population built by dollar threshold alone will miss the accessorial-heavy, low-dollar invoices where drift concentrates.

Step 5: Export the full invoice population for the audit period from the AP system, filtered to freight and 3PL vendor codes. Step 6: Group the export by carrier, then by lane, then by mode (truckload, less-than-truckload, parcel, intermodal), since each grouping maps to a different section of the rate agreement.

Step 7: Flag invoices where the vendor code does not match a known carrier in your reference file. An invoice from an unrecognized or duplicate vendor code cannot be checked against a rate agreement that does not name it, and needs resolution before the line-item audit proceeds.

Do not exclude small-dollar invoices from the population. Accessorial charges are frequently billed on their own line or on a low-value shipment, and a threshold that screens out small invoices screens out the invoices most likely to carry an unvalidated accessorial.

3. How do you verify the base freight rate on each invoice?

Match each invoice's lane, mode, and weight break against the rate table in the reference file, and confirm the rate charged equals the rate on file for that combination. Where a volume tier applies, confirm the invoice reflects the tier the shipment actually qualifies for, not the tier from the prior period, since volume tiers reset on a schedule the invoice does not always follow.

Step 8: For each invoice, identify the exact lane (origin-destination pair), mode, and weight break, and look up the corresponding rate in the reference file built in step 1.

Step 9: Compare the looked-up rate to the rate actually charged. A mismatch here is a base rate discrepancy and gets logged with the invoice number, the rate charged, and the rate on file.

Step 10: Where the agreement includes volume tiers, confirm which tier the shipment volume falls into for the period, and confirm the invoice used that tier rather than a prior or default tier. A rate agreement negotiated on falling into a lower tier as volume grows only delivers that saving if the invoice is checked against the tier the volume actually earned.

4. How do you verify the fuel surcharge on each invoice?

Recalculate the fuel surcharge from the index and formula named in the carrier agreement, using the index value in effect on the shipment date, and compare that figure to the surcharge the invoice actually billed. A surcharge that persists at an old index value after the underlying fuel price has moved is a specific, checkable drift type, not a rounding difference.

Step 11: Identify the fuel index the agreement references and the reset frequency (weekly, monthly). Step 12: Pull the index value for the shipment date. The US EIA and BLS both publish relevant series; for reference, BLS PPI Commodity data for Fuels and related products and power, Gasoline (series WPU0571) read September 5, 2026 showed a July 2026 index value of 302.759, up 37.1% year over year, illustrating how fast the underlying input can move within a single contract term.

Step 13: Apply the agreement's formula to that index value and compare the result to the surcharge billed. Step 14: Where the invoice surcharge does not move with the index, check whether the carrier's rate table was updated on the reset date the agreement specifies. A surcharge that lags the index reset date is drift, and the reader can confirm the reset mechanics in more depth on the surcharge sunset dating page.

Log every mismatch with the index value used to calculate the expected surcharge, so the discrepancy is defensible when raised with the carrier.

5. How do you verify accessorial charges line by line?

Match each accessorial line item, detention, liftgate, residential delivery, redelivery, against both its rate and its trigger condition in the accessorial schedule, not just its rate. A correctly priced accessorial that was never actually triggered, such as detention billed with no supporting time record, is as much a discrepancy as a wrong rate.

Step 15: List every accessorial charge on the invoice separately from the base rate. Step 16: For each one, confirm the rate matches the accessorial schedule for that carrier and charge type.

Step 17: Confirm the trigger condition is documented. Detention needs a time-in and time-out record; liftgate and residential delivery need a delivery record showing the condition applied; redelivery needs a record of the failed first attempt. An accessorial with the right rate but no supporting record is not verified, it is unverifiable, and gets logged as a documentation gap rather than waved through.

Step 18: Total the accessorial charges per invoice and flag any invoice where accessorials exceed a proportion of the base rate that warrants a closer look, using your own threshold since no industry-wide accessorial share is available to benchmark against.

6. How do you reconcile discrepancies and close the loop with the carrier?

Consolidate every flagged line, base rate, fuel surcharge, and accessorial, into a single discrepancy log per carrier, with the invoice number, the amount billed, the amount supported by the reference file, and the delta. Submit that log to the carrier as a dispute or credit request, and track it to resolution rather than closing it at submission.

Step 19: Build one discrepancy log per carrier covering the full audit period, not one log per invoice. A carrier reviewing twelve separate one-line disputes moves slower than one reviewing a single consolidated log.

Step 20: For each line, state the invoice number, the amount billed, the amount supported by the rate agreement, fuel index, or accessorial schedule, and the delta. This is the evidence that makes the dispute negotiable rather than a claim to argue over.

Step 21: Submit the log to the carrier's billing contact and set a follow-up date. Step 22: Track each line to a credit memo, an adjusted invoice, or a documented carrier rejection, and keep the log open until every line resolves. An unresolved dispute log is not a completed audit; it is deferred, and the underlying rate table needs re-checking on the next audit cycle to confirm the same discrepancy did not recur.

For the wider pattern this sits inside, start with the margin drift guide. See also n-way invoice matching explained and price file governance: why annual uploads create twelve months of drift.

7. Frequently Asked Questions (People Also Ask)

How often should we audit freight and 3PL invoices?

This guide describes the audit sequence itself rather than a cadence. Whether you run it on every invoice batch or on a periodic sample is a separate decision, covered in more depth on the page comparing continuous enforcement against periodic audit.

What is the difference between a base rate discrepancy and a fuel surcharge discrepancy?

A base rate discrepancy means the lane, mode, or weight break was priced against the wrong number in the rate table. A fuel surcharge discrepancy means the surcharge formula was applied correctly but against an outdated or wrong index value. They require separate verification steps because they draw on different source documents.

Do we need the bill of lading for every invoice, or just disputed ones?

Pull it for every invoice in the audit population, not just ones that look wrong. The bill of lading establishes the facts, weight, lane, delivery conditions, that the invoice is supposed to be priced against, so you need it before you can tell whether an invoice is correct in the first place.

Can we run this audit in a spreadsheet?

The sequence itself is spreadsheet-compatible: reference tables, invoice exports, and a discrepancy log are all tabular. Whether a spreadsheet holds up as your carrier count and invoice volume grow is a separate question, addressed on the page about building contract-to-invoice matching in Excel.

What counts as a legitimate rate increase versus drift?

A rate increase that was negotiated, documented, and reflected in a signed addendum to the carrier agreement is legitimate. A rate that increased on the invoice without a corresponding change to the reference file is drift. The distinction and how to document it are covered on the page separating margin drift from legitimate price increases.

Why does the accessorial schedule matter as much as the rate table?

Accessorial charges are billed on their own line, separate from the base rate, and each one has its own trigger condition that has to be documented, not just a rate that has to match. A correctly priced accessorial with no supporting record is still an unverified charge.

How do fuel price swings affect a freight audit?

They change how quickly a surcharge table can go stale. Per BLS PPI Commodity data for Fuels and related products and power, Gasoline (series WPU0571), read September 5, 2026, the July 2026 index value was up 37.1% year over year, which is the scale of movement a surcharge formula needs to track between contract resets.

What if the carrier disputes our findings?

Send the consolidated discrepancy log with the invoice number, amount billed, and the reference document the expected amount was calculated from. A dispute backed by the specific rate agreement clause or index value is negotiable in a way a general complaint about overbilling is not.

Does this audit cover duplicate freight payments?

No. Duplicate payment detection is a distinct check, generally run against the vendor master and payment history rather than the rate and accessorial schedules this sequence checks. It's addressed on the vendor master hygiene page.

How does a freight audit fit into a broader AP recovery effort?

Freight is one spend category among several that an AP recovery audit reviews. The mechanics here (rate, surcharge, accessorial verification) are specific to freight; what a broader recovery audit finds and misses across categories is covered separately.