LTL, truckload and parcel freight audit

Freight invoice processing that reads every carrier's bill.

LTL, truckload and parcel bills arrive as PDFs, scans and photos, each in its own layout. ParserBee reads them all and gives you one row per charge line, ready to check against your rate card in Excel or Google Sheets.

25 pages free
Ready-made Freight Invoice template
One row per charge line
One bill, four charge lines

Audit freight invoices line by line, not by the total.

The total on this Ridgeline bill looks normal. The ready-made Freight Invoice template reads every charge line, your sheet puts the contract rate next to each one, and the overcharges show. Until the charges are rows, most bills get paid as billed.

Billed 730.67, expected 562.26: 23% of this bill is open to question. Send the dispute within 180 days of receiving the bill.

Six checks per bill

How do small shippers catch freight overcharges?

By checking every bill, not a sample, for the same six errors. Each one needs a charge line from the bill and a figure from your BOL or rate card, which is why the bills have to be rows first.

Reweighs and reclasses

Billed weight or freight class differs from your bill of lading. The sheet compares the two; you ask for the inspection or reweigh certificate.

Fuel from the wrong week

The fuel percentage does not match your contract's fuel table for the week the freight moved. A lookup on the weekly diesel price catches it.

Accessorials nobody ordered

Liftgate, residential, inside delivery or limited access fees that are not on the BOL, or are billed above the contract price.

Duplicate bills

The same PRO number billed twice, often once by mail and once by email. A COUNTIF on the PRO column flags the second one.

Detention without the times

Detention billed with no arrival and departure times, or inside the free time. Check it against the proof of delivery.

Wrong rate or minimum

A rate that is not the one on your rate confirmation, or a minimum charge applied when the weight-based charge is higher.

Freight invoice audit in Excel

How do I check freight invoices against carrier rates in Excel?

Put every charge line from your freight bills in one sheet and your contracted rates and fuel table in a second sheet. XLOOKUP then works out what each shipment should cost, and any bill where billed minus expected is above your tolerance goes back to the carrier.

  1. Get the bills into rows

    Read the week's bills with the Freight Invoice template and download one Excel file with one row per charge line; call that sheet Charges. In a Bills sheet, keep one row per bill: PRO in A, the carrier and lane key in B, the weight from your bill of lading in D (the bill of lading parser reads it), the pickup week's diesel price in E, and the billed linehaul, fuel, accessorials and total in F to I. The export puts the PRO number on each bill's first row only, so fill it down first (select column C, Go To Special, Blanks, type = and the cell above, press Ctrl+Enter). Then SUMIFS pulls each charge type in by PRO number:

    =SUMIFS(Charges!$F:$F, Charges!$C:$C, A2, Charges!$E:$E, "Fuel*")
  2. Put your rates in a Rates sheet

    One row per carrier and lane: a key such as Ridgeline|Columbus to Atlanta, the rate per hundredweight (cwt), the minimum charge and the price of each accessorial you agreed. If your contract is a discount off a base tariff, enter the net rate for each weight break, or the price on the rate confirmation for spot loads.

  3. Work out the expected linehaul

    Weight divided by 100, times the contract rate, but never less than the minimum. In column J:

    =MAX(XLOOKUP(B2, Rates!$A$2:$A$200, Rates!$C$2:$C$200),
         D2/100 * XLOOKUP(B2, Rates!$A$2:$A$200, Rates!$B$2:$B$200))
  4. Look up the fuel surcharge for the week

    Most US fuel tables follow the weekly diesel price from the US Energy Information Administration. Keep a Fuel sheet of price bands (column A, lowest price of each band) and percentages (column B). In column K, match mode -1 finds the band for the diesel price in column E and applies it to the expected linehaul:

    =ROUND(J2 * XLOOKUP(E2, Fuel!$A$2:$A$40, Fuel!$B$2:$B$40, "no band", -1), 2)
  5. Compare and flag

    Put the accessorials on the BOL at your contract price in L, the expected total (J + K + L) in M, and the variance (I minus M) in N. Then flag duplicates first and anything over your tolerance (here $5; there is no standard figure). XLOOKUP and SUMIFS work the same way in Google Sheets.

    =IF(COUNTIF(A$2:A2, A2) > 1, "Duplicate", IF(N2 > 5, "Dispute", IF(N2 < -5, "Under-billed", "OK")))
Freight invoice auditing, week by week

A week of freight bills, one status each.

ParserBee is not a freight audit company. It reads the bills; the rules live in your sheet, where you can see and change every one. Send the rows to a linked Google Sheet and the statuses update as each new bill is read.

  • Every carrier's charges land in the same columns
  • Dispute, verify, duplicate or OK, at a glance
  • Your team works the exceptions, not every bill
Outsource or keep it in-house

ParserBee, typing into Excel or a freight audit provider?

A freight audit and payment provider audits, pays and disputes for you. ParserBee gives you the data and leaves the decisions with your team.

Typing into ExcelFreight audit provider
Who reads the billsParserBeeParserBee reads every carrier's layout, PDF, scan or photoTyping into ExcelYour team, one bill at a timeFreight audit providerThe provider
Who checks the ratesParserBeeFormulas in your own sheet, set up onceTyping into ExcelYour team, by eyeFreight audit providerThe provider's audit rules
Who pays the carrierParserBeeYour AP team (ParserBee does not pay)Typing into ExcelYour AP teamFreight audit providerUsually the provider
DisputesParserBeeYour team, with the variance and the line behind itTyping into ExcelYour team, if anyone spots itFreight audit providerUsually the provider
CostParserBee25 pages free, then from $29 a month for 250 pagesTyping into ExcelStaff timeFreight audit providerQuoted per contract; few publish prices
Best forParserBeeShippers, 3PLs and brokers who want the data and keep controlTyping into ExcelA few bills a monthFreight audit providerLarge shippers who want audit and payment outsourced

Freight audit provider column: from the freight audit and payment providers' own sites, checked November 2026. None of the four we checked publishes a price. Check their sites for current terms.

Outsourcing wins when

When a freight audit and payment provider is the better buy.

  • You want someone else to audit, pay carriers and handle disputes: choose a freight audit and payment provider.
  • Your carriers already send EDI 210 invoices or CSV billing files into your TMS: the data is already structured, so audit it there.
  • You need rating built into your TMS at booking time: that is a TMS feature, not document reading.
  • A single parcel invoice runs to hundreds of pages: ask your carrier for the CSV file instead; ParserBee reads up to 24 pages per PDF on paid plans.
In-house wins when

When reading the bills yourself pays off.

  • Bills arrive as PDFs, scans or photos from many carriers.
  • You audit in Excel or Google Sheets today, or want to start.
  • Brokers checking carrier invoices against rate confirmations.
  • 3PLs re-billing freight to their own customers.
The paperwork behind each bill

Check each bill against its BOL and proof of delivery.

A reweigh or an accessorial is only a dispute if the shipment paperwork says so. The same account reads it: 83 ready-made document parser templates across 16 industries, plus any document you build a template for with the AI template builder.

Bills of lading

Shipper, consignee, pieces, weight and class: the other side of the weight check.

Bill of lading parser →

Proof of delivery

Delivery date, receiver and notes, to back up or reject accessorials and detention.

Delivery note data extraction →

Freight invoice template

The ready-made Parser Template this page uses, with a sample of every field.

Freight invoice template →

Commercial invoices

Seller, buyer, HS codes and values for cross-border shipments.

Commercial invoice parser →

Packing lists

Cartons, dimensions and weights, line by line.

Packing list data extraction →

Supplier invoices

Everything else your AP team receives, with every line item.

Invoice OCR software →
FAQ

Freight invoice processing questions

Put this week's carrier bills through the rate check.

Try ParserBee free for 25 pages. No credit card. Pick the ready-made Freight Invoice template and test it on one of your own bills.