Route, Load, Lane: Reporting for a Logistics Business

A logistics P&L is a study in aggregation. Freight income on one line, fuel on another, driver wages, tolls, maintenance, vehicle finance — all summed across every truck and every trip in the period. The result is a statement that can be perfectly accurate and almost perfectly uninformative, because a transport business doesn’t make or lose money in aggregate. It makes or loses money one trip at a time, on specific lanes, with specific vehicles — and the statutory statements collapse exactly the dimensions along which the answers run.

The consequence is a familiar one: an operator who knows the fleet is busy, knows the revenue line is growing, and cannot say which routes are actually paying for themselves. Four families of numbers close that gap. Most monthly packs contain none of them.

The numbers that actually run a logistics business

Route and lane profitability. The unit of profit in transport is the trip, and the honest question for any lane is whether revenue per trip covers the fully loaded cost per trip — not just the fuel and the driver, but tolls, a maintenance reserve per kilometre, and an apportioned share of the vehicle’s EMI or depreciation. Take a hypothetical lane billing ₹42,000 a trip: fuel ₹19,500, driver ₹4,500, tolls ₹3,800, maintenance reserve ₹3,200, and ₹8,500 of vehicle EMI apportioned across the month’s trips — ₹39,500 all-in, a ₹2,500 surplus per run. Thin, but positive. Now suppose diesel has risen 12% since the rate was contracted and no revision has landed: the same lane is losing roughly ₹1,000 on every trip, while looking like the busiest and healthiest route in the network. A lane can be full, frequent, and quietly loss-making on every single run — and freight income in aggregate will never say so. This is the logistics version of the blended-margin trap that trading businesses fall into: the average conceals the loser.

Utilisation and empty miles. A truck earns nothing standing in a yard and less than nothing running empty, yet the EMI, the insurance, and most of the driver cost accrue regardless. Two measures matter. Capacity utilisation per vehicle — loaded kilometres as a share of total kilometres run — exposes the dead-head problem: the outbound leg that pays ₹42,000 and the return leg that pays nothing turns a profitable lane into a marginal round trip unless return loads are found. And revenue per vehicle per day is, for most fleets, the single most predictive operating metric there is: a vehicle whose fully loaded cost works out to, say, ₹11,000 a day and which is earning ₹9,000 a day is losing money in a way no monthly fuel variance will reveal. Tracked per vehicle, this number moves before the P&L does — a truck drifting from ₹13,000 a day to ₹9,500 over two months is an early warning the financial statements will only confirm a quarter later.

Fuel and maintenance cost per kilometre, against expected. Fuel is typically the largest single cost in the business, and it is also where leakage shows first. Every vehicle has an expected mileage norm; the reporting question is how actual consumption per kilometre compares to it, vehicle by vehicle, month by month. A truck rated at 4.2 km per litre that is delivering 3.5 is telling you something — pilferage, route deviation, idling, or an engine problem — and the sooner the variance is visible, the cheaper the cause is to fix. Maintenance behaves the same way: cost per kilometre trending upward on a specific vehicle is the clearest signal that it is approaching the point where it costs more to keep than to replace. Both signals exist only as rates against expectation. As absolute rupee lines on a P&L, they are noise.

Working capital peculiar to the trade. Transport has a cash cycle all of its own, and none of it appears on an income statement. Freight is billed on credit, and large consignors dictate terms — so days sales outstanding by client matters more than the blended figure, because one anchor customer at 90 days can hold more cash than the rest of the book combined. Beneath that sits a layer most industries don’t have: driver advances and trip settlements. Cash goes out on day one of a trip — fuel advance, toll float, en-route expenses — and only lands in the ledger when the trip sheet is settled, sometimes weeks later. A fleet with, say, ₹28,00,000 floating in unsettled advances at any given time is financing that float invisibly, and unreconciled balances have a way of ageing into write-offs. And then there are detention and demurrage recoveries: the contract entitles the operator to ₹1,500 a day when a vehicle is held at a consignee’s yard, the vehicle sits for four days, and the charge is never raised because nobody joined the trip sheet to the contract. Money earned, never billed. A thirteen-week cash forecast built without these flows is a forecast of a different, tidier business.

Why they don’t reach the pack

None of this is exotic analysis. The reason it rarely appears is that it lives in records the accounting system never summarises: trip sheets, fuel logs, FASTag and toll statements, workshop job cards, and — where one exists — the transport management system. Route profitability needs each trip’s revenue matched to its fuel fills, its tolls, and an apportioned slice of vehicle finance. Utilisation needs loaded and empty kilometres from trip records the ledger doesn’t hold at all. Fuel variance needs litres and kilometres joined per vehicle. The advance float needs driver imprest accounts reconciled against settled trip sheets. Every one of these is a join across sources, done by hand, every month — so the pack falls back to the statutory P&L, which the books produce for free, and the layer that actually explains the fleet gets built occasionally, if at all.

The cost of flying without them

A logistics business running on its financial statements alone makes the same expensive mistakes on a loop. The loss-making lane keeps its trucks because it looks busy and nobody has costed a trip. Empty return legs are absorbed as a fact of life rather than priced or backfilled. Fuel leakage runs for two or three quarters before an annual review catches it, by which point the money is long gone. Driver advances age quietly until a reconciliation exercise turns a float into a write-off. Detention that was contractually recoverable expires unbilled. And rate revisions come late, because the trigger — cost per trip crossing revenue per trip — was never on a page anyone reviewed. None of these failures needs better accounting. They need reporting that answers the operating questions, at the grain the business actually runs on: the route, the load, the lane.

What to expect with Datavrn

Datavrn is being built to produce the layer beneath the logistics P&L. Route and lane profitability on a fully loaded cost per trip, utilisation and revenue per vehicle per day, fuel and maintenance cost per kilometre against expected, and the working capital tied up in client credit and driver advances come through as part of the monthly pack — and each figure drills to the trip sheet or invoice behind it, so a lane’s margin opens into the trips, fuel fills, and tolls that made it. Where an input is estimated — a maintenance reserve per kilometre, an apportioned EMI — it is flagged with its basis rather than buried in the number. You get the view that actually runs a fleet, on the rhythm of the close, instead of rebuilding it from trip sheets and toll statements by hand each month.

Datavrn is management-reporting software for finance teams, virtual CFO practices and enterprise finance functions. Available now: for one standalone Entity, take a Trial Balance through confirmed groupings and disclosures to an Excel working draft with live links or a clean finalised workbook with fixed values. Datavrn prepares the statements; it does not file or certify them. The wider management pack is in active development. Start free with your work email — no invitation needed.