Free Freight Invoice Audit Checklist and Accessorial Tracker (Excel)

A working tracker for the people who pay freight bills. Log every truckload and LTL invoice against what you agreed with each carrier, catch overbilled accessorials and duplicates before you pay, and get the monthly accessorial report finance asks for. Plus a one-page audit checklist (PDF) for every invoice.

  • Accessorial schedule and invoice audit log: what you agreed with each carrier, and one row per invoice that flags overbilled linehaul, fuel and accessorials, class or weight above the BOL, and duplicates in red.
  • Disputes and monthly report: open disputes with the days left in each carrier's dispute window, and billed vs allowed accessorials by month, facility, carrier and type, with two charts.
  • The 12-point audit checklist, in the workbook and as a one-page PDF to run on every invoice.
Freight audit
Accessorial charges
Truckload and LTL
Excel + PDF
Free download

Get the free checklist and tracker

Thank you! Your submission has been received!

Download the checklist and tracker →

Oops! Something went wrong while submitting the form.
What's inside
An invoice log that shows what to dispute

Start with the Accessorial schedule tab: free time, detention rates and caps, truck ordered not used, stop-offs, lumper terms, fuel index and peg, the LTL items and each carrier's dispute window. It follows the accessorial schedule in our accessorial charges guide, so it also works as the accessorial sheet in your next bid.

Then log every invoice. Billed linehaul, fuel and up to four accessorials sit next to what was agreed, and anything above it turns red: an overbilled charge, a class or weight higher than the BOL, an accessorial nobody requested or proved, or a possible duplicate. Each dispute gets a deadline and a countdown.

The Monthly report fills itself: billed vs allowed accessorials by month, facility, carrier and type, the top 5 facilities for detention, and disputed vs recovered dollars, with two charts. Grey cells are yours and everything else is locked.

The Monthly report tab of the Emerge freight invoice audit tracker, with accessorials billed vs allowed by month, disputed vs recovered dollars and the top 5 facilities for detention
Next step

Want accessorials capped before the invoice arrives?

The easiest invoice to audit is one where every accessorial was quoted as its own line, with a cap, before the freight moved. See how Emerge runs annual bids.

See how Emerge runs annual bids