# Freight Invoice Audit Worksheet

> Source: https://netray.co/tools/freight-invoice-audit-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Compare what the carrier billed with what your contract rate should produce, and see the variance per invoice and in total.

## Category

cost-finance

## Audience

- Logistics coordinator
- Accounts payable
- Transportation manager

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### PRO / invoice

**Key:** pro

**Type:** text

#### Carrier

**Key:** carrier

**Type:** text

#### Ship date

**Key:** ship_date

**Type:** date

#### Billed weight (lb)

**Key:** weight

**Type:** number

#### Contract rate per cwt

**Key:** rate

**Type:** number

**Format:** currency

#### Contract fuel %

**Key:** fsc

**Type:** number

**Unit:** %

#### Allowed accessorials

**Key:** acc

**Type:** number

**Format:** currency

#### Amount billed

**Key:** billed

**Type:** number

**Format:** currency

#### Expected charge

**Key:** expected

**Type:** number

**Expr:** weight / 100 * rate * (1 + fsc / 100) + acc

**Format:** currency

#### Variance (billed minus expected)

**Key:** variance

**Type:** number

**Expr:** billed - (weight / 100 * rate * (1 + fsc / 100) + acc)

**Format:** currency

**Rows:**

**Pro:** 7731984420

**Carrier:** Lone Star Freight

**Ship date:** 2026-10-06

**Weight:** 1850

**Rate:** 21.5

**Fsc:** 24

**Acc:** 35

**Billed:** 523.4

**Pro:** 7731984511

**Carrier:** Lone Star Freight

**Ship date:** 2026-10-07

**Weight:** 920

**Rate:** 24

**Fsc:** 24

**Acc:** 0

**Billed:** 312.6

**Pro:** 5520918873

**Carrier:** Prairie Express

**Ship date:** 2026-10-08

**Weight:** 3200

**Rate:** 18.75

**Fsc:** 28

**Acc:** 55

**Billed:** 842

**Pro:** 5520919004

**Carrier:** Prairie Express

**Ship date:** 2026-10-09

**Weight:** 640

**Rate:** 26

**Fsc:** 28

**Acc:** 0

**Billed:** 213

**Totals:**

#### Total billed

**Key:** billed

**Agg:** sum

**Format:** currency

#### Total expected

**Key:** expected

**Agg:** sum

**Format:** currency

#### Net variance

**Key:** variance

**Agg:** sum

**Format:** currency

**Summary:**

#### Net overbilling as % of expected

**Key:** over_pct

**Expr:** sum_variance / sum_expected * 100

**Format:** percent

#### Invoices reviewed

**Key:** inv

**Expr:** count

**Format:** integer

**Notes:** Variance greater than zero means the carrier billed more than your contract produces. Investigate each positive variance against the bill of lading, reweigh records and the contract before disputing. Rates per cwt are per 100 pounds.

## Content

**Intro:** Freight invoices contain errors more often than most teams expect: wrong rate tier, reclassed freight, unapproved accessorials or a fuel surcharge that does not match the contract. This worksheet recomputes the expected charge from your contract inputs and shows the variance for each invoice.

**Sections:**

#### How to use this worksheet

**Body:** Enter one row per carrier invoice. Fill in the billed weight, the contract rate per hundredweight, the fuel surcharge percentage in your agreement, any accessorial charges you expect and the amount the carrier billed. The worksheet calculates the expected charge and the variance. Positive variances are potential overcharges. Add notes in a separate column of your own if you export to Excel, and use the totals to see whether the problem is isolated or systemic.

#### The expected charge formula

**Body:** For LTL and similar weight-based freight, the base charge is billed weight divided by 100, multiplied by the rate per hundredweight. Fuel surcharge is applied as a percentage of that base. Allowed accessorials are added. Real tariffs also have minimum charges, discounts off a base tariff and weight breaks, so use the effective rate for the weight bracket on the shipment. If your contract uses a flat rate per shipment, put the flat amount in as the rate with weight set to 100.

#### Investigating a variance

**Body:** A variance by itself does not prove an error. Check the common causes before disputing.

**Bullets:**

- Weight differences: reweigh or inspection charges, or a rounding rule
- Freight class or NMFC changes made by the carrier after inspection
- Accessorials such as liftgate, limited access or detention that actually occurred
- Fuel surcharge table updated for the week of shipment
- Duplicate billing for the same PRO number

#### Common mistakes

**Body:** Audits fail when the inputs are weak or the follow-up is slow.

**Bullets:**

- Auditing without the current signed rate agreement
- Missing dispute windows in the carrier terms
- Paying first and never tracking recoveries
- Treating small variances as noise when they repeat on every invoice

**Cta:** If freight invoices are matched to purchase orders and receipts in your ERP, we can help automate the contract-rate comparison.

**Faq:**

#### What is a freight invoice audit?

**Answer:** A check that each carrier invoice matches the agreed rate, the actual shipment details and the allowed accessorials before payment. It catches duplicate bills, wrong rates and unauthorized charges.

#### How do I calculate expected LTL charges?

**Answer:** Divide weight by 100, multiply by the contract rate per hundredweight, apply the fuel surcharge percentage and add any valid accessorials. Then apply any minimum charge in your tariff if the result is lower.

#### How long do I have to dispute an overcharge?

**Answer:** It varies by carrier terms and jurisdiction. Many contracts set a window of months from invoice or payment. Dispute promptly and read the dispute clause in your rate agreement.

#### Is a third-party audit service better?

**Answer:** For large freight spend, a freight audit and payment provider may recover more and save staff time. For modest volumes, a worksheet like this is enough to spot patterns and support disputes.

## Search terms

freight invoice audit template, freight bill audit spreadsheet, carrier invoice verification, freight overcharge calculator, freight audit excel, LTL invoice audit worksheet, freight payment audit

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json