Freight costs are one of the largest variable cost blocks in many companies — and at the same time one of the least explained. The monthly report shows a total, but not why it changed. This guide describes how transport data becomes robust freight cost controlling: which data is needed, which metrics carry weight, how cost changes are explained, and how actions get tracked through to the following invoices.
Step 1
1. Target picture: what freight cost controlling must answer
Freight cost controlling is more than a cost center in the monthly close. It answers four questions: how high are the costs, how are they developing, where does the change come from, and which action affects it. Anyone who only looks at the total sees results — but not causes.
- Define recipients: logistics needs shipment detail, purchasing needs terms, the CFO needs development and forecast.
- Questions before metrics: every KPI has to support a decision, otherwise it's just decoration.
- Cleanly separate volume, mix and price effects — otherwise every change in volume looks like a cost increase.
- Set the reporting rhythm: monthly standard reporting, ongoing review, quarterly deep-dive analysis.
Deep dive: The most important freight cost KPIs
Step 2
2. Data foundation: one truth for all analyses
Controlling rarely fails because of the metrics — it fails because of the data foundation. Carrier invoice data, shipment data from the ERP or TMS, and the contractual tariffs all have to come together via a common shipment number. Only then can costs per shipment, lane and cost type actually be calculated.
- Mandatory fields per shipment: date, origin and destination, weight, loading meters, mode of transport, carrier.
- Keep invoice line items separate: base freight, fuel, tolls, ancillary services.
- Measure data quality: match rate, missing weights, duplicates, non-auditable line items.
- One source for all reports — parallel Excel analyses produce contradictory figures.
Deep dive: What data does freight cost software need?
Step 3
3. Choosing the right metrics
A good freight cost cockpit gets by with a few, but meaningful, metrics. What matters is that every KPI has a reference value: costs alone say nothing, but cost per shipment, per kilogram or per revenue euro say a lot.
- Cost per shipment, per kilogram and per loading meter — split by mode of transport.
- Freight cost ratio: freight costs relative to revenue or goods value.
- Surcharge ratio: share of fuel, tolls and ancillary costs in total costs.
- Deviation ratio: share of invoice line items that differ from the agreed tariff.
- Structural KPIs: shipment size, utilization, share of express shipments, carrier mix.
Deep dive: Freight cost analysis at shipment level
Step 4
4. Drill-down: from the total to the individual shipment
A metric only becomes useful once you can break it down. Rising cost per shipment isn't a finding, it's a question: which carrier, which lane, which mode of transport, which cost type? The path from the total to a single shipment has to be possible in a few clicks.
- Consistently build dimensions: carrier, lane, mode of transport, cost type, plant, customer.
- Standardize time comparisons: previous month, same month last year, year to date.
- Flag outliers automatically instead of searching manually.
- Keep every metric traceable down to the shipment — otherwise the result gets questioned internally.
Deep dive: Freight cost reporting: what a dashboard needs to deliver
Step 5
5. Explaining cost changes instead of just reporting them
Freight costs rise for very different reasons: more shipments, heavier shipments, different lanes, higher surcharges, new terms — or simply incorrectly billed line items. Controlling only becomes relevant to steering once it separates these effects.
- Report volume effect, mix effect and price effect separately.
- Track surcharge development separately — fuel and tolls often mask the base freight.
- List billing errors as their own cause, not as a cost increase.
- Assign one action per cause: process, negotiation, tender or claim.
Deep dive: Why freight costs rise
Step 6
6. Bringing controlling and invoice auditing together
Reporting shows how costs develop. Freight invoice auditing shows whether what was billed matches what was agreed. Both belong on the same data foundation: target costs from the digital tariff model, actual costs from the invoice — the difference is both a metric and a work queue.
- Calculate target costs per shipment and carry them into the analysis as a reference.
- Categorize and prioritize deviations by error type and amount.
- Keep claimed and credited amounts visible within controlling.
- Treat recurring error patterns as a process topic, not a one-off case.
Deep dive: Freight invoice auditing: the complete guide
Step 7
7. From report to steering: tracking actions through
The final step decides the value: whoever measures also has to follow through. After a tender or a change in terms, only the following period shows whether the negotiated saving actually arrives in the invoices. This exact reconciliation between expectation and reality is the core task of freight cost controlling.
- Measure realized savings against the negotiated terms, not against the plan in the concept.
- Assign actions an owner, a deadline and an expected effect.
- Roll the forecast forward: expected volumes, surcharges and changes in terms.
- Standardize the reporting package so every month stays comparable.
8. The most common mistakes in freight cost controlling
Reporting only total costs
Without a reference value like shipment, kilogram or revenue, no development can be assessed — every change in volume distorts the picture.
Too many metrics
A cockpit with thirty KPIs doesn't get read. A few clearly defined metrics with drill-down are far more effective.
Separate data worlds
When reporting and invoice auditing run on different data, two truths emerge — and discussions replace decisions.
Surcharges not tracked separately
Fuel, tolls and ancillary costs move on their own logic. Hidden inside the base freight, they become unmanageable.
No follow-up on actions
Negotiated savings only count as realized once they're measurable in the following invoices.
How to cleanly break cost changes down into volume, mix and price effects is shown in the article Why freight costs rise.
9. When software pays off
As long as a few hundred shipments and a single carrier are involved, controlling can be handled in Excel. With several providers, their own zone and bracket logic, changing surcharges and new invoice files every month, the balance tips: the effort of maintaining data exceeds the insight gained. Software then takes over data preparation, target-cost calculation, metrics and drill-down — delivering the same, comparable analysis every month.
More on this: Freight cost management software and Does freight cost software need an ERP or TMS integration? or go straight to the product: ShipCheck KPI.
10. Frequently asked questions about freight cost controlling
What does freight cost controlling cover?
Freight cost controlling covers the ongoing measurement of transport costs, their breakdown by carrier, lane, mode of transport and cost type, explaining changes through volume, mix and price effects, and tracking actions such as tenders, changes in terms and claims.
Which freight cost KPIs matter most?
In practice, a few are enough: cost per shipment, cost per kilogram or loading meter, freight cost ratio relative to revenue, surcharge ratio, and deviation ratio against the agreed tariff. What matters is that every metric stays traceable down to shipment level.
How does controlling differ from freight invoice auditing?
Controlling shows how costs develop. Auditing shows whether what was billed matches what was contractually agreed. Rising cost per shipment can result from a changed shipment mix — or from a billing error. Only auditing tells the two apart.
Is Excel enough for freight cost controlling?
With a few hundred shipments and one carrier, Excel is workable. Once several providers bill under their own zone, bracket and surcharge logic, the maintenance effort grows faster than the insight gained — that's when software takes over data preparation, target-cost calculation and analysis.
How often should analysis be done?
A monthly standard report per billing period, accompanied by ongoing review of every invoice and a quarterly deep-dive on lanes, carrier mix and surcharge development, has proven effective.
Does controlling also show whether my tariffs are market-competitive?
No. Controlling compares actual costs with contractual target costs and with your own history. Whether the terms themselves are market-competitive is answered by benchmarking or a new freight tender — that's a separate question.
All articles on this topic
- Freight cost KPIs
- Freight cost reporting software
- Freight cost analysis at shipment level
- Why freight costs rise
- Freight cost management software
- What data does freight cost software need?
- ERP or TMS integration?
- Analyzing shipment data
- AI in freight cost analysis
- Freight cost control: ongoing instead of one-off
Control your freight costs with ShipCheck
All shipment and invoice data on one foundation, metrics down to the individual shipment, cost changes explained rather than just reported.
Get in touch now