Freight came in over budget this month. How do we find out why?
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
- Cartage, Wilson product FAQ and product scope, October 2026: https://cartage.ai
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.
