← Guides & Articles
Guides & Articles

Carrier Invoice Guide for Shippers: From Rate Card to Approved Invoice

By Zineb Bakhtaoui · · 6 min read

Contents

  1. What a carrier invoice check needs to connect
  2. Why carrier invoices are hard to check
  3. The extras, one by one
  4. A worked example
  5. 7 points to check before you approve an invoice
  6. Free template: carrier invoice check (Excel)
  7. Spreadsheet vs ERP vs TMS
  8. Where Freterium fits
  9. How to start
  10. Key takeaways
  11. FAQ

It’s the end of the month. A transport manager has 400 trips, three carriers, and a rate grid in Excel that has been copied and updated so many times that the same route appears twice, at two different prices. Nobody noticed until now.

A carrier invoice is right when every trip on it matches your contract: price each trip when it’s planned, and only review the differences.

→ Book a demo

What a carrier invoice check needs to connect

An invoice can only be checked if four things are linked:

  • The contract: the agreed price per lane, per truck type, and the rules for extras
  • The trip: what was really planned and done
  • The proof: delivery note, arrival and departure times, extra stops
  • The invoice: what the carrier is asking to be paid

When these live in different places (a contract PDF, an Excel grid, WhatsApp messages, a paper delivery note), the check turns into a search.

Why carrier invoices are hard to check

The rate grid is a spreadsheet

Grids get copied, updated and duplicated. One team we spoke with found the same lane priced at two different rates in its own file.

The check happens weeks later

Site managers go through invoices line by line at the end of the month. By then, nobody remembers what happened on each trip.

Extras come without proof

Waiting time, extra stops and return trips are argued case by case. One company told us it receives detention charges at least twice a week and checks each one by hand.

Proof of delivery arrives late

When the delivery note is on paper, it can take days to come back. The invoice waits with it, or gets paid without it.

Several carriers, several formats

Each carrier sends its own format and references. One team spends 2 to 3 hours a month reconciling invoices from just three carriers.

The extras, one by one

Most disagreements with carriers are not about the base price. They are about what comes on top.

  • Extra stops: a fixed amount per additional delivery point. You need the list of stops actually made.
  • Waiting time (detention): a free period at loading or unloading, then a price per hour. You need real arrival and departure times.
  • Return trips: sometimes paid when the truck comes back empty. You need to know how it came back.
  • Cancellations and failed deliveries: a truck sent for nothing is often billed. You need to know who cancelled, and when.
  • Fuel surcharges: prices adjusted when diesel moves. You need the reference price and the formula in the contract.

A worked example

Example with illustrative figures, not taken from a client.

A 10-tonne truck delivers to three customers. The rate card says:

  • Base price for the lane, 10-tonne truck: USD 450 (first delivery point included)
  • Each extra stop: USD 40
  • Waiting time: first 2 hours free, then USD 30 per hour

What happened: 3 delivery points (2 extra stops), and 3.5 hours on site at the second customer (1.5 hours to pay).

Expected cost: 450 + (2 × 40) + (1.5 × 30) = USD 575.

The carrier’s invoice says USD 635: it charges 3.5 hours of waiting instead of 1.5. With the recorded times, the difference is easy to settle. Without them, it becomes a negotiation.

7 points to check before you approve a carrier invoice

  1. Is the lane right? Origin and destination match the trip that was done.
  2. Is the truck type right? The price matches the truck really used.
  3. Is the rate the contract rate? Take it from one rate card, not a copied file.
  4. Are the extra stops real? Each one matches a delivery on the trip.
  5. Is the waiting time proven? Check recorded arrival and departure times.
  6. Is the return trip billed correctly? Empty or loaded, per the contract.
  7. Is there proof of delivery? No proof, no payment, until it comes back.

Free template: carrier invoice check (Excel)

If you still check invoices by hand, our free Excel template does the maths for you. Enter one line per trip: the contract price, the extras and what the carrier invoiced. The template calculates the expected total and the difference, and highlights in red every line that needs checking.

It comes with an example row (the trip from the worked example above) and a short guide.

→ Download the carrier invoice check template (Excel)

Spreadsheet vs ERP vs TMS

  • Spreadsheet: free and flexible, but grids drift and errors are found at month end.
  • ERP: good for paying invoices, but rarely knows what happened on each trip.
  • Transport management system (TMS): prices each trip from the contract when it’s planned, links the proof, and compares the carrier’s invoice automatically.

Where Freterium fits: from the contract to the invoice

Freterium is a transport management system (TMS) used by shippers, distributors and logistics providers in Morocco, the GCC and beyond. For carrier costs, it covers:

  • Rate cards per carrier: lanes, truck types, extra stops, waiting time
  • Pre-invoicing: the expected cost of each trip, calculated from the contract
  • Proof of delivery in the driver app, attached to each trip
  • Arrival and departure times from the trucks’ GPS, so waiting time is a fact rather than an argument
  • A connection to your ERP, so approved costs go to finance

→ Book a demo

How to start without changing everything at once

  1. Start with your largest carrier and its rate grid.
  2. Clean the grid: one price per lane and truck type, every extra written as a rule.
  3. Agree with the carrier on what counts as proof.
  4. Run the automatic check next to your manual check for one month.
  5. Add the other carriers.

Key takeaways

  • Most invoice errors start in the rate grid, not in the invoice.
  • Extras are where most disputes happen.
  • Checking at the end of the month is too late to prove anything.
  • When each trip is priced from the contract, the team only reviews the differences.

→ Book a demo

FAQ

What documents do you need to check a carrier invoice?
The carrier’s contract or rate card, the trip details, the proof of delivery and, for extras, the recorded arrival and departure times.

How often should carrier invoices be checked?
Ideally trip by trip, as each delivery is done. At the latest, before the monthly invoice is approved.

Who should check carrier invoices: transport or finance?
Transport confirms the trip and its extras; finance approves the payment. A shared expected cost per trip lets both work from the same number.

How do you handle a rate dispute with a carrier?
Compare the invoice with the rate card and the trip data together. When both sides see the same times and stops, most disputes close quickly.

What is detention in trucking?
Detention is the charge a carrier bills when its truck waits longer than the free time agreed in the contract at loading or unloading.

Related articles: How to Build a Daily Transport Plan Without Excel