Freight came in over budget this month. How do we find out why?

Freight invoice audit and payment guideNov 17, 202617 min read

Why did freight come in over budget this month?

It is the third business day of the month. The controller sends the logistics manager a short note: "Freight was $412,000 against a budget of $365,000. Can you tell me why by Friday?" The logistics manager opens the general ledger and sees one number. The carrier invoices are spread across two inboxes, a spreadsheet and the ERP. Nobody is sure which loads belong to which month, and two carriers have not invoiced yet.

To find out why freight came in over budget, first remove timing effects such as late invoices and missing accruals, then split the remaining gap into six causes using shipment-level data: volume, rate, accessorials, mode mix, expedites and billing errors. Each cause points to a different owner. Volume is a sales and operations question. Rate is a procurement question. Accessorials and errors are execution and audit questions. Mode mix and expedites are usually planning questions.

The answer is rarely one thing. A typical month mixes a few more loads than planned, a rate increase on one lane, some detention, two expedites for a late production run and a billing error nobody caught. The work is to size each part so the conversation focuses on the ones that matter.

Why the general ledger total is not enough

The ledger records freight cost when invoices are posted. It does not tell you which loads the invoices cover, whether the charges were expected or whether the work could have been done for less. It also mixes timing. An invoice for a load that delivered on the 29th may post next month. A credit for a disputed charge may post two months later. The ledger is where the question starts. The shipment records are where the answer is.

How this differs from a quarterly explanation

A monthly check has less time and less data. Some invoices will still be missing, and one month of volume can swing more than a quarter. That means the monthly check should be quick, focused on the biggest drivers and honest about what is still unknown. The quarterly view can go deeper. For that longer review, see how to explain a quarterly freight increase to the CFO.

What the controller actually needs

The controller does not need every load. They need to know four things: how much of the gap is real, what caused it, whether it will repeat next month and what the team is doing about it. A good answer fits on one page and can be defended line by line.

Let's review last month's freight spend line by line. You don't need to prepare anything: Cartage maps the workflow with you on the call.

See it on your own loads. Wilson, by Cartage, is an AI logistics agent that quotes, books, tracks, audits and pays for freight with your approved carriers.

Book a demo →

How do you break a freight overrun into its causes?

Work in a fixed order: timing, volume, rate, accessorials, mode mix, expedites and errors. The order matters, because each step removes one effect before the next is measured. If you measure rate before volume, more loads can look like higher prices.

Step 1: Fix the timing

Before anything else, decide which loads belong to the month. The cleanest rule is to count every load that delivered in the month, whether or not it has been invoiced yet. Then:

  • Add accruals for delivered loads with no invoice, using the rate confirmation amount.
  • Remove prior-month loads whose invoices posted this month.
  • Note open credits and disputes, and do not count them as savings until they post.

Consider a hypothetical month. The ledger shows $412,000. Of that, $21,000 is for loads delivered last month. Another $9,000 of loads delivered this month have not been invoiced. The true cost of this month's freight is $412,000 minus $21,000 plus $9,000, or $400,000. The gap against a $365,000 budget is $35,000, not $47,000. Timing alone explained $12,000.

Step 2: Measure volume

Compare the number of loads, pallets or pounds shipped against what the budget assumed. If the budget planned 310 loads and the team shipped 335, the extra 25 loads at the budget's average cost explain part of the gap. In the hypothetical month, if the budget assumed an average of $1,177 per load, 25 extra loads add about $29,400.

Volume overruns are usually not a logistics failure. They follow sales. Still, look at where the extra loads came from. Extra loads from new orders are healthy. Extra loads from split shipments, partial orders or reships are a process problem.

Step 3: Measure rate

For loads on the same lane and mode, compare what the team paid per load against the budget rate. Do this lane by lane for the lanes with the most spend. A rate increase on one busy lane can cost more than small changes on twenty quiet ones.

Separate three kinds of rate change:

  • Contract changes: a carrier raised its rate on the lane.
  • Spot exposure: the usual carrier was not available and the load went to the spot market at a higher price.
  • Fuel: fuel surcharges moved with fuel prices. Track fuel apart from the base rate, because nobody on the team controls it.

Step 4: Measure accessorials

Total every charge beyond the base rate and fuel: detention, liftgate, residential, inside delivery, reweigh and reclass, redelivery, layover, lumper and others. Compare against the budget's allowance or against a normal month. Then sort them into charges that were expected at booking and charges that showed up only on the invoice.

Unexpected accessorials usually point to booking errors, such as a missing liftgate request or the wrong freight class, or to dock problems, such as long waits at a receiver. Reweigh and reclass charges deserve their own line. The article on stopping LTL reweigh and reclass charges explains where they come from.

Step 5: Measure mode mix

If more freight than usual moved by truckload instead of LTL, or by LTL instead of parcel, the average cost per shipment changes even if every rate stayed flat. Count loads and spend by mode and compare to the budget's mix. A shift toward more expensive modes is not always bad. It might reflect bigger orders. But it should be visible.

Step 6: Measure expedites

Pull out every load that moved faster than the standard service: team trucks, expedited LTL, air freight, hot shots and guaranteed services. For each, record why it was needed. Late production, a missed pickup, a customer emergency and a forgotten order are different problems with different owners.

Step 7: Find the errors

Last, look for charges that should not have been paid at all: duplicate invoices, rates above the rate confirmation, accessorials for services not used and charges for loads that were cancelled. These are often small one by one. Together they can be a real share of the gap, and they are the easiest to recover.

Step 8: Reconcile

Add up the pieces. In the hypothetical month, the result might look like this:

Cause Amount Owner Will it repeat?
Timing (prior-month invoices, accruals) $12,000 Finance and logistics No
Volume: 25 extra loads $29,400 Sales and operations Depends on orders
Rate: two lanes moved to spot $6,200 Logistics Yes, until fixed
Accessorials: detention and liftgate $4,100 Logistics Yes, if booking errors continue
Mode mix: more truckload $1,500 Planning Maybe
Expedites: three late production runs $5,800 Operations Depends on production
Errors: one duplicate invoice, one overbilled rate $2,300 Accounts payable Recoverable
Rate savings on other lanes -$14,300 Logistics Yes
Total explained $47,000

The figures are made up to show the method. Note the negative line: some lanes may have come in under budget. Showing those keeps the explanation honest.

What data do you need, and where does it come from?

You need one row per load with the lane, mode, dates, carrier, quoted rate, invoiced amount and every charge line. Most teams have this data. It is just spread across too many places.

The fields that matter

  • Order or PO number and customer.
  • Origin, destination and lane name (consistent across months).
  • Mode and service level, including whether it was expedited.
  • Ship date and delivery date.
  • Carrier.
  • Weight, pallets or pieces.
  • Quoted or rate-confirmed amount.
  • Invoiced amount, broken into base, fuel and each accessorial.
  • Invoice number and date, and payment status.
  • Any dispute or credit, with the amount and status.
  • The reason for any expedite or extra charge.

Where the data usually lives

Data Common location Common problem
Orders and customers ERP Not linked to the load or carrier
Quotes and rate confirmations Email, carrier portals Hard to find after the fact
Bookings and carriers Spreadsheet or email Different spellings, missing fields
Invoices Accounts payable inbox, ERP Only the total is entered, not charge lines
PODs Email, carrier websites Missing for some loads
Expedite reasons Someone's memory Not recorded at all

The hardest part of the monthly check is usually the join: matching each invoice to the load, the rate confirmation and the order. If invoices are entered as one total per carrier, the accessorial and error steps become guesswork.

Lane names must stay the same

If one month calls a lane "Plant 2 to Atlanta" and the next calls it "Dalton to GA DC," the rate comparison breaks. Define lanes once, by origin and destination city or ZIP prefix, and keep the definitions fixed. The guide on seeing freight spend by customer, product and lane covers how to set that up.

A hypothetical lane check

Consider a hypothetical lane from a plant to a customer's distribution center. The budget assumed 40 truckloads at $1,900 each, or $76,000. The month shows 42 loads and $86,300. The overrun is $10,300.

Split it step by step. Two extra loads at the budget rate explain $3,800. That leaves $6,500. The load records show that 34 loads moved with the usual carrier at $1,900, and 8 moved on the spot market at an average of $2,400 because the usual carrier had no trucks in the last week of the month. Those 8 loads cost $500 more each, or $4,000. Detention on three loads at the customer's dock adds $1,200. One load was invoiced at $2,250 instead of the confirmed $1,900, an error of $350. The rest, $950, is fuel.

Each piece now has an owner. The extra loads belong to sales. The spot exposure is a carrier capacity question for logistics. The detention is a receiver conversation. The $350 is a dispute for accounts payable. Without the load records, the same lane would just read "over by $10,300," and nobody would know whom to call.

What to do when data is missing

Missing data is normal at month-end. Do not stall the whole review for it. Mark loads with no invoice as accrued at the rate confirmation amount. Mark missing expedite reasons as "unknown" and ask the person who booked them. Report what share of spend is still estimated. A review that is 90% firm and says so is more useful than one that waits three weeks.

Which mistakes make a freight budget review go wrong?

Most mistakes come from mixing causes, trusting the ledger total or comparing against the wrong baseline. Avoid these and the review gets faster every month.

Mistake 1: Comparing to last month only

Last month may have been unusual. Compare against the budget and against the same month last year. A December that is over budget may still be normal for December.

Mistake 2: Measuring rate before volume

If the team shipped 10% more loads, total cost will rise even with flat rates. Measure volume first, then rates on a per-load or per-pound basis.

Mistake 3: Hiding fuel inside rate

Fuel moves with the market. When fuel is mixed into the base rate, a fuel spike looks like a carrier problem. Track fuel as its own line.

Mistake 4: Treating every accessorial as unavoidable

Some accessorials are part of the service, such as a liftgate for a receiver with no dock. Others come from errors, such as a wrong address or a missing appointment. Sort them. The avoidable ones are where the fix is.

Mistake 5: Ignoring the budget assumptions

If the budget used last year's rates and carriers raised prices in the spring, the budget was wrong before the year started. Say so. The fix then belongs in next year's freight budget, not in this month's execution.

Mistake 6: Counting disputes as savings

A disputed charge is not saved until the credit posts. Report disputes separately with their status, and follow them to the end.

Mistake 7: Explaining without acting

An explanation that ends at "rates went up" changes nothing. For each cause, name the specific lanes, carriers or customers, the next step and who owns it.

Decision rules for the monthly review

Finding What it usually means Next step
Gap mostly timing Invoices and accruals were out of step Fix the cutoff rule; no freight action needed
More loads, same cost per load Sales volume grew Update the forecast; check for split shipments
Higher cost per load on a few lanes Carrier rate change or spot exposure Review the lanes, get fresh quotes, recheck the carrier ranking
Accessorials up Booking details or dock problems Check booking accuracy and receiver records
More expedites Production or planning slipped Review with operations; record reasons
Errors found Invoices paid without checking Dispute and recover; audit before paying

What should the monthly freight check look like?

A one-page summary, a variance table and a short list of actions. The same format every month makes trends easy to see.

The summary

Three or four sentences: the budget, the actual, the true gap after timing, and the two or three causes that explain most of it. For example: "Freight was $412,000 against $365,000. After timing, the real gap is $35,000. Most of it came from 25 extra loads tied to higher orders and two lanes that moved to the spot market. Expedites added $5,800 and are linked to late production."

The checklist

Use this before sending the review:

  • Loads counted by delivery date, with accruals for missing invoices.
  • Prior-month invoices removed.
  • Volume measured before rate.
  • Fuel shown as its own line.
  • Rate compared lane by lane for the top lanes by spend.
  • Accessorials split into expected and unexpected.
  • Mode mix compared to the budget.
  • Every expedite has a reason.
  • Billing errors listed with dispute status.
  • Favorable lanes shown, not only overruns.
  • Share of spend still estimated is stated.
  • Each cause has an owner and a next step.

Who should see it

Send it to the controller and to the owners of each cause: sales for volume, operations for expedites, accounts payable for errors. A short review meeting is useful when one cause is new or large. Otherwise, the page is enough.

Making it faster each month

The first review takes the longest because the data is scattered. The fix is not more analysis. It is capturing the right details as the work happens: the rate on every booking, the charge lines on every invoice, the reason for every expedite. When each load already carries that information, the monthly check becomes a report rather than a project. For which numbers to watch beyond the budget gap, see freight coordination KPIs.

How does Wilson, by Cartage, help explain a freight overrun?

Wilson, by Cartage, is an AI logistics agent that quotes, books, tracks, audits and pays freight for manufacturers and distributors, and it keeps the record a monthly freight review needs as it does that work. Traditional logistics software gives teams information. Wilson executes the work required to move shipments forward.

Wilson works like a free logistics department with four parts: the labor, the data, the network and the payments. Each one shapes what shows up in the monthly numbers.

The labor

Wilson does the labor from the first quote to the final POD: quotes, bookings, paperwork, tracking and carrier follow-ups. It requests quotes from the company's approved carriers and compares them on total cost, including accessorials, so the expected cost is known at booking. It negotiates toward the company's rate targets within approval limits. Rates outside those limits go to the logistics team. When a load needs an expedite or a rebook, the decision and the reason are recorded on the shipment.

The data

Wilson keeps every order, load, quote, rate, document and contact on record as it works. That is the data. Each load carries its lane, mode, carrier, rate confirmation, invoice and POD, so the join that eats most of the monthly review is already done. Every message, confirmation and change is kept in the shipment's change history.

Wilson does not keep a standing scorecard or recurring benchmarking by default. It can produce carrier-performance and lane-rate reports on request from the loads it runs, which is what a month-end review needs.

Wilson keeps every load, rate and document on record, so teams don't need a TMS. Wilson replaces the TMS for freight execution and connects to the company's ERP. Wilson works with SAP, NetSuite, Microsoft Dynamics 365, Oracle, Infor, Epicor, Sage, Acumatica and other ERP environments, with the exact connection depending on the customer's data flow and scope. Whether freight cost is written back to the ERP depends on scope.

The network

The network gives the shipper better freight rates on every lane, because its volume counts with every other Wilson customer's. The network includes carriers and brokers. The company still approves who hauls its freight. When a lane keeps moving to the spot market, the network is another place to find an approved option.

The payments

The payments part catches the error line before it reaches the ledger. Wilson audits each carrier invoice against the rate confirmation and the POD before money moves. An invoice over the agreed rate, for example $2,410 against an agreed $2,200, is held and flagged for a person. A duplicate invoice is attached as a resend, not paid twice, and a new invoice number repeating a charge already billed is raised with the carrier. Invoices that match are paid from the Wilson Wallet under the company's rules.

Control and scope

Wilson starts with assisted execution. The company sets approval limits, and routine actions run automatically within those rules as the workflow is proven. The company controls the scope: a subset of shipments, one or two key customers or loads excluded by rule. Timing depends on scope: most teams start on a few lanes and expand from there.

Pricing

Wilson is free on Wilson's network: the shipper pays the freight rate and nothing on top. When a shipper keeps its own carriers, the fee is 2% to 0.5% of what Wilson pays them, falling with volume. There are no seat fees, no setup cost and no contract.

FAQs

Can Wilson tell us why freight went over budget?

Wilson, by Cartage, an AI logistics agent, keeps every load, rate, invoice and document on one record as it works, and it can produce carrier-performance and lane-rate reports on request from the loads it runs. That gives the team the shipment-level data to split an overrun into volume, rate, accessorials, mode mix, expedites and errors. The judgment on causes and actions stays with the team.

What is the first thing to check when freight is over budget?

Timing. Make sure the month includes every load delivered in it, with accruals for missing invoices, and excludes invoices for loads from earlier months. Timing alone can explain a large share of a monthly gap.

Should we measure volume or rate first?

Volume first. More loads will raise total cost even with flat rates. Once volume is removed, compare cost per load or per pound lane by lane to see real rate changes.

How do we separate fuel from rate increases?

Track the fuel surcharge as its own line on every invoice. Fuel follows the market and is not something the team negotiates load by load. Mixing it into the base rate makes carriers look more expensive than they are.

Which accessorials are worth investigating?

Charges that were not on the quote or rate confirmation, such as unexpected detention, liftgate, redelivery, reweigh or reclass. They usually point to a booking error or a dock problem that will repeat until someone fixes it.

What if half the invoices have not arrived yet?

Accrue the missing loads at their rate confirmation amount and say what share of spend is estimated. Do not hold the review for complete data. Update the figures when the invoices arrive.

Does Wilson keep a carrier scorecard?

Not by default. Wilson can produce carrier-performance and lane-rate reports on request from the loads it runs.

How does Wilson stop billing errors from reaching the budget?

Wilson audits each carrier invoice against the rate confirmation and the POD before payment. Invoices over the agreed rate or outside the rules are held for a person, and duplicates are not paid twice.

How long should a monthly freight review take?

With shipment-level data already joined, a few hours. Without it, often days. The difference is whether rates, charge lines and expedite reasons are captured when the work happens.

Sources

Let's review last month's freight spend line by line. You don't need to prepare anything: Cartage maps the workflow with you on the call.

Add Cartage as a preferred source on Google