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.
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.
| Charge | Rate | Amount |
|---|---|---|
| Linehaul | $18.40 per cwt | 393.76 |
| Fuel surcharge | 33.5% | 131.91 |
| Liftgate delivery | Flat | 95.00 |
| Residential delivery | Flat | 110.00 |
| Total due (USD), net 30 | 730.67 | |
Billed 730.67, expected 562.26: 23% of this bill is open to question. Send the dispute within 180 days of receiving the 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.
Time matters: for US motor carriers, 49 U.S.C. 13710 gives a shipper 180 days from receiving a bill to contest it.
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.
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*")
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.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))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)
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")))
Run on the Ridgeline bill, these formulas give an expected total of 562.26 against 730.67 billed. A variance is an amount to question, not money owed: the carrier may show a reweigh certificate or a signed delivery receipt that supports the charge.
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
=IF(COUNTIF(A$2:A2,A2)>1,"Duplicate",IF(E2>5,"Dispute","OK"))| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | PRO | Carrier | Billed | Expected | Variance | Status |
| 2 | 7710-40318 | Ridgeline | 730.67 | 562.26 | 168.41 | Dispute |
| 3 | 55821-04 | Keystone | 374.92 | 374.92 | 0.00 | OK |
| 4 | 209114 | Bluewater | 671.24 | 671.24 | 0.00 | OK |
| 5 | 4471-118 | Summit | 150.00 | 75.00 | 75.00 | Verify |
| 6 | 55821-04 | Keystone | 374.92 | 374.92 | 0.00 | Duplicate |
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 Excel | Freight audit provider | ||
|---|---|---|---|
| Who reads the bills | ParserBeeParserBee reads every carrier's layout, PDF, scan or photo | Typing into ExcelYour team, one bill at a time | Freight audit providerThe provider |
| Who checks the rates | ParserBeeFormulas in your own sheet, set up once | Typing into ExcelYour team, by eye | Freight audit providerThe provider's audit rules |
| Who pays the carrier | ParserBeeYour AP team (ParserBee does not pay) | Typing into ExcelYour AP team | Freight audit providerUsually the provider |
| Disputes | ParserBeeYour team, with the variance and the line behind it | Typing into ExcelYour team, if anyone spots it | Freight audit providerUsually the provider |
| Cost | ParserBee25 pages free, then from $29 a month for 250 pages | Typing into ExcelStaff time | Freight audit providerQuoted per contract; few publish prices |
| Best for | ParserBeeShippers, 3PLs and brokers who want the data and keep control | Typing into ExcelA few bills a month | Freight 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.
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.
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.
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 →Freight invoice processing questions
What is freight invoice processing?
It is the work between a carrier's bill arriving and the carrier being paid: reading the bill, checking each charge against the rate you agreed and the shipment that moved, disputing what is wrong, then approving and paying the rest. Most of the time goes into the first step, reading the bills, because every carrier prints them differently.
How do I audit freight bills without a freight audit company?
Put the charges from every bill in one sheet, one row per charge line, and keep your contracted rates and your fuel table in a second sheet. XLOOKUP then calculates what each shipment should cost, and a variance column shows which bills to question. ParserBee does the reading, so the sheet fills itself; the rate check is a few formulas you set up once, as shown on this page.
How do small shippers catch freight overcharges?
By checking every bill, not a sample, for the same six things: billed weight and class against the bill of lading, the fuel percentage against the fuel table, accessorials against what was ordered, duplicate PRO numbers, detention against the delivery times, and the base rate against the rate confirmation. A variance of a few dollars a bill adds up over a year of shipments.
Can I audit parcel invoices in a spreadsheet?
Yes, with different checks: late deliveries on services that carry a guarantee, dimensional weight (length times width times height, divided by the divisor in your carrier's service guide), address correction and residential fees, and duplicate tracking numbers. If your parcel carrier lets you download the invoice as a CSV file, start from that. For PDF parcel invoices, ParserBee reads up to 24 pages per file on paid plans, one row per package.
Does ParserBee audit freight invoices against my rates?
No. ParserBee reads the freight bills and gives you every charge as rows in Excel, CSV, Google Sheets or Airtable. The rate check runs in your own sheet, with your rate card, so you can see and change every rule. ParserBee does not pay carriers or file disputes.
What does the Freight Invoice template read?
The ready-made Freight Invoice template reads the invoice number and date, carrier, shipper, shipment reference, origin, destination, shipment and delivery dates, every charge line with its description and amount, the total, currency and payment terms. Add billed weight, freight class, PRO number or BOL number as extra fields by describing them in plain English.
How long do I have to dispute a freight bill?
For US motor carriers, federal law (49 U.S.C. 13710) says a shipper must contest the original bill or a later bill within 180 days of receiving it to keep the right to contest those charges, and a carrier has 180 days to bill extra charges. Your contract can set its own terms, so check it too. Auditing every week keeps you well inside the window.
Which fuel price should my fuel surcharge check use?
The one your contract names. Most US fuel surcharge tables follow the weekly on-highway diesel price published by the US Energy Information Administration, national or by region. Keep a table of price bands and percentages, and look up the band for the week the freight was picked up.
Can it read bills of lading and proof of delivery too?
Yes. The bill of lading parser and the ready-made Bill of Lading template read shipper, consignee, pieces, weight and class, and a delivery note template reads proof of delivery. Read all three and you can check each bill against the shipment that moved, in the same sheet.
Which file types can it read?
PDF, JPG, PNG, WebP and HEIC, so digital bills, scans and phone photos all work. Data Lab also reads emails saved as .eml files, Excel (XLSX) and CSV. Upload up to 100 files at once in Data Lab.
Does it work with my TMS, ERP or QuickBooks?
Through Zapier, Make, n8n, the document parsing API or a CSV import. ParserBee has no direct connector to a TMS or an accounting system today. Google Sheets and Airtable are built in.
How much does it cost?
New accounts get 25 free pages, no credit card. Paid plans start at $29 a month for 250 pages; see pricing. Each page uses one page credit, so a one-page freight bill uses one and a twelve-page parcel invoice uses twelve.
Is my data used to train AI?
No. Your documents are never used to train AI models, and files travel to ParserBee over an encrypted (HTTPS) connection.