Freight Invoice Discrepancy Report: Build One

How do you build a freight invoice discrepancy report?

A freight invoice discrepancy report lists, charge by charge, what was quoted, what was billed and the difference. Each line also records the charge type, which document each figure came from, and whether the carrier cited documentation for any reweigh or reclassification. You need two documents to build it: the carrier invoice and the original quote.

LanePilot is a TMS and WMS for small and mid-sized manufacturers, distributors and warehouses, and its freight invoice audit builds the quote-versus-billed comparison for you.

What a discrepancy record has to contain

A report is only as good as the individual records inside it. A record that says "this invoice looks high" cannot be disputed, sorted or checked later. A usable record carries five things for every charge that differs:

The quoted amount. What the shipper was told the charge would be, taken from the quote for that shipment.
The billed amount. What the carrier invoice actually charged for the same item.
The charge type. Linehaul, fuel surcharge, an accessorial such as a liftgate service, a reweigh adjustment, a reclassification, or a duplicate of a bill already paid.
The source of each figure. Which document and which line the quoted amount and the billed amount came from, so anyone can open both and see the same numbers.
The documentation status. For a reweigh or a reclassification, whether the carrier cited a certificate or an inspection reference, or cited nothing at all.

The difference between the first two items is arithmetic. The other three are what make the difference worth anything, because they tell you what kind of disagreement it is and who has to prove what.

Why the original quote is a required second document

The most common shortcut is to check the invoice against a filed rate table. That check only confirms the invoice matches the carrier's own published rates. It cannot see that a shipment was quoted at one price and billed at another, because the rate table is not the price the shipper was given when the shipment was booked.

The original quote for that same shipment is what makes the gap visible. Every figure in the quoted column has to come from the quote, not from memory and not from a standing assumption about what a lane usually costs.

How to build the report, step by step

Step 1: Pair the two documents for one shipment

Match the carrier invoice to the quote for the same shipment using the references both documents share, such as the PRO number or the bill of lading number.

Step 2: List every charge from the quote, then every charge from the invoice

Put the two lists side by side by charge type. A charge on the invoice with no counterpart on the quote is the most important line to catch, so leave the quoted side empty rather than skipping the row.

Step 3: Record the difference per line

Quoted, billed, and the difference between them. Keep each charge on its own line instead of rolling everything into one total, because a total can hide a lower linehaul that offsets a higher accessorial.

Step 4: Tag the charge type

Four types are worth separating because each is checked differently: an accessorial that was not on the quote, a duplicate of a shipment already billed, a fuel surcharge that differs from what was quoted, and a reweigh or reclassification.

Step 5: Record the documentation status

LanePilot's audit treats a reweigh or reclassification that cites a certificate or an inspection reference as a documented correction, not an overcharge. A citation alone does not prove the carrier is right, so keep the reference in the record and decide for yourself whether it settles the line. One that cites nothing is a line for you to verify with the carrier.

A worked example (invented numbers, for illustration only)

The figures below are invented to show how the record is built. They are not real rates, not a typical result and not a claim about what any shipper pays. Say the quote for one shipment shows two charges and the carrier invoice shows five:

Linehaul. Quoted $300.00, billed $300.00, difference $0.00. Matches. No action.
Fuel surcharge. Quoted $45.00, billed $54.00, difference $9.00. Type: fuel surcharge variance. Check the fuel table that applied on the ship date.
Liftgate service. Quoted nothing, billed $75.00, difference $75.00. Type: accessorial not on the quote. Verify that the service was requested and performed.
Reclassification. Quoted nothing, billed $62.00, difference $62.00. Type: reclassification. The carrier cited no inspection reference. Flag it to verify.
Reweigh adjustment. Quoted nothing, billed $18.00, difference $18.00. Type: reweigh. The carrier cited a reweigh certificate. Record it as a documented correction and do not dispute it in this example.

Quoted total: $300.00 plus $45.00, which is $345.00. Billed total: $300.00 plus $54.00 plus $75.00 plus $62.00 plus $18.00, which is $509.00. The total difference is $164.00. Of that, $146.00 ($9.00 plus $75.00 plus $62.00) is flagged to verify and $18.00 is a documented correction.

That last split is the point of the exercise. A report that only said "$164.00 over the quote" would invite a dispute over a charge the carrier had already documented. The record shows exactly where to push and where not to. (This example keeps the reweigh and the reclassification as single lines for clarity. On a real invoice a reweigh or a reclassification usually changes the rate and the weight-based lines, so check how your carrier presents it.)

What the report cannot tell you

A discrepancy report shows that two documents disagree. It does not decide who is right. A flagged line is a question for the carrier, and the answer may be that the charge was correct. Dispute deadlines vary by carrier and by the contract or bill of lading terms governing the shipment, so check those terms for your shipment instead of assuming a universal window.

This report covers carrier invoices compared against the quote. Shortages and damage found at receiving are handled separately, through discrepancy capture at the dock and vendor chargebacks.

Where this fits in LanePilot

One System. TMS & WMS on easy mode. The platform quotes, books and tracks freight and runs receiving and inventory in the same system. When the quote was built in LanePilot, it is already in the place the invoice is checked, and one system means less re-entry between quoting and checking the invoice. If the quote was made elsewhere, you type the quoted rate in.

The freight invoice audit is the cost-recovery half of that. It itemizes the difference between what was quoted and what was billed, by charge type, and it flags a reweigh or reclassification that cites nothing for you to verify. LanePilot drafts the dispute letter. You send it yourself, because LanePilot does not contact, negotiate with or file anything with a carrier. You can read how the audit works on the Freight Invoice Audit and Overcharge Recovery page.

The free plan includes 5 quote credits and 7 invoice audits a month, on two separate meters. Sign up at lanepilottech.com/signup, then bring the carrier invoice and the original quote for the same shipment. An audit needs both.

Frequently Asked Questions

What is a freight invoice discrepancy report?

It is a charge-by-charge record of where a carrier invoice differs from the original quote for the same shipment. Each line shows the quoted amount, the billed amount, the charge type, the source document for each figure, and whether the carrier cited documentation for a reweigh or reclassification.

Why do I need the original quote and not just the invoice?

The invoice alone only shows what was billed. A check against a filed rate table only confirms the invoice matches the carrier's own published rates, and it cannot show that a shipment was quoted at one price and billed at another. The quote is the second document that makes that gap visible.

Is a reweigh or reclassification charge always an overcharge?

No. LanePilot's audit treats one that cites a certificate or an inspection reference as a documented correction, though a citation alone does not settle that the carrier is right. One that cites no documentation is worth verifying with the carrier. The record should capture which it was.

Does LanePilot send the dispute to the carrier?

No. LanePilot drafts the dispute letter and the shipper sends it. LanePilot does not contact, negotiate with or file anything with a carrier.