News / Budget
Oct 28, 2026
Explaining a transport budget variance to your CFO
Table of Contents
"Why are we over budget on transport?" It is one of the most common questions a transport team gets from finance, and one of the hardest to answer well. The usual answer, "carriers got more expensive", is rarely wrong. It is just rarely the whole story.
A useful answer splits the gap into causes that add up exactly to the total. There are three of them.
The three causes
Any difference between the transport budget and actual spend comes from:
- Volume. You shipped more or fewer parcels than planned.
- Shipping mix. You shipped different parcels than planned: other carriers, other countries, other services, other sizes.
- Rates. The same parcel cost more or less than planned, because of rate changes, surcharges or fuel.
These three explain the whole gap. They also point to different owners. Volume is usually a commercial question. Mix is an operational one. Rates belong in the carrier negotiation.
A worked example
Take a month where the budget was €6,965,904 and actual spend was €7,473,370. That is €507,466, or 7.3%, over budget. Split into the three causes:
| Cause | Effect |
|---|---|
| Volume: 13,056 fewer shipments than planned | −€150,296 |
| Shipping mix | +€536,731 |
| Rates and surcharges, mainly fuel | +€121,031 |
| Total | +€507,466 |
Three things stand out. Volume was below plan, so on volume alone the month should have come in under budget. Rates did go up, but they explain less than a quarter of the gap. Most of the difference comes from mix.
Opening up the mix
"Shipping mix" is the cause people find hardest to picture, so it helps to split it further. In the same example, the €536,731 breaks down into:
- Carrier: +€458,667. The planned split was 50% PostNL and 44% DHL. The actual split was 38% PostNL and 52% DHL. UPS went from 6% to 9%. At €7.48 per shipment for PostNL against €9.64 for DHL and €39.18 for UPS, moving volume away from the cheapest carrier adds up quickly.
- Country: +€66,686. Slightly fewer domestic parcels and slightly more to Germany and France, where a shipment costs two to three times as much.
- Parcel size: +€11,377. A small shift from small to medium parcels.
Now the conversation is concrete. Why did volume move from PostNL to DHL and UPS? Capacity, a service problem, a change at the warehouse, a customer promise? That is a question with an answer and an owner.
The figures in this example are from Censa's demo account, not a real customer.
How to calculate it
The method is a standard variance split, applied in order:
- Volume effect. Planned cost per shipment times the difference in shipments.
- Mix effect. The actual number of shipments, priced at planned rates per carrier, country and size, minus the same shipments at the planned average. This isolates what changed in where and how you shipped.
- Rate effect. What remains: actual spend minus actual shipments at planned rates. This is the pure price change, including surcharges and fuel.
The order matters, and so does consistency. Pick one order and keep it every month, so the numbers can be compared over time.
The hard part is not the formula. It is having planned rates per carrier, country and service, and actual costs at the same level of detail. Without that, mix and rates blur together into "carriers got more expensive".
How to present it
For the CFO, three lines are enough: the gap, the three causes, and the one or two actions that follow. Keep the detail for the questions.
A short structure that works:
- The number. €507,466 over budget, 7.3%.
- The cause. Mainly carrier mix: volume moved from PostNL to DHL and UPS.
- What is not the cause. Volume was below plan. Rates explain €121,031, mostly fuel.
- The action. Agree the carrier allocation for next month, and review the fuel terms in the DHL contract.
Make it monthly
A variance explained once is a report. A variance explained every month, the same way, becomes a management tool. Transport and finance look at the same numbers and the same causes, and the budget review stops being a debate about whose numbers are right.
Censa splits every budget variance into volume, mix and rates, and lets you open each cause down to carrier, country and parcel size.