Calculate trip contribution before comparing vehicle profitability

An outbound movement earns ₹30,000 and appears to leave a comfortable contribution. The truck returns empty, the driver submits another allowance and a toll adjustment arrives after the trip is marked complete. A comparison based on the outbound leg now overstates what the full movement earned.

Trip costing should follow the agreed operating boundary and show which costs are actual, estimated or still unresolved. Use the completed round trip when the business decision includes returning the vehicle to its next usable position.

Follow both legs of the journey

Consider this illustrative round trip. The outbound leg covers 400 kilometres and the empty return covers 300 kilometres. Revenue is ₹30,000 for the outbound service; there is no return revenue. All figures exclude taxes and use a common currency.

Fuel consumption is supported by the example's reconciled opening stock, refuelling and closing stock records. The costing rate is ₹95 per litre. It is an assumed consistent valuation rate for the example, not a statement of current pump prices.

Looking only at the outbound leg gives ₹16,500 contribution: ₹30,000 less ₹13,500. Including the return produces total direct cost of ₹22,875 and contribution of ₹7,125.

A later toll reconciliation adds ₹250 that was missing from the initial record. Final direct cost becomes ₹23,125 and direct contribution becomes ₹6,875. The adjustment changes the same trip; it does not belong to a fictional new journey merely because it posted later.

The 700-kilometre boundary matters. Comparing this result with another trip's outbound-only margin would mix different units of work.

Establish where the trip starts and ends

A round trip need not return to the same depot if the agreed operating model positions the vehicle elsewhere. Record the start, delivery and end location, associated legs and the period the vehicle is committed.

Link repositioning and empty movements to the decision that requires them. A separately sold backhaul may change the boundary or introduce another revenue leg. Preserve the relationship instead of counting the same return expense against two trips.

For multi-drop work, retain stop-level evidence where it changes a charge or expense, while keeping a clear trip total. A waiting event may create a supplier cost, a customer charge, both or neither. Record each obligation under its actual terms; an observed delay does not create automatic revenue.

Cancellations and abandoned movements also consume resources. Excluding them from the vehicle's completed-work view can make a busy vehicle look more profitable than the whole operation.

Reconcile fuel quantity before valuing it

Suppose the vehicle purchases 120 litres during the outbound leg but consumes 100 litres under the reconciled quantity record. At ₹95 per litre, the purchase is ₹11,400 while consumed fuel costs ₹9,500 in this example. The remaining 20 litres have not disappeared; they remain available for later movement.

Real vehicles may use fuel bought at different prices. Finance should define the valuation approach, and operations should explain the quantity evidence. A dashboard must not alternate between purchase cost and consumption cost merely because one field is easier to obtain.

Frappe HR's Vehicle Log records odometer readings, fuel expenses and service details, and can support an expense-claim workflow. Those records are useful inputs, but the trip's consumption boundary and allocation still require reconciliation. Frappe HR — Vehicle Log

Investigate implausible odometer changes, duplicate fuel receipts and missing closing readings. A modelled consumption estimate can remain useful when labelled as an estimate. It should not silently overwrite an actual measurement or become an allegation against a driver.

Keep direct contribution and full cost separate

Suppose management additionally allocates ₹7,000 of vehicle and support cost to the illustrative round trip under an approved policy. The result after that allocation is a loss of ₹125: ₹6,875 contribution less ₹7,000 allocated cost.

Both views can be useful. Direct contribution helps explain what the trip added before those allocations. The allocated view supports a broader assessment of whether the vehicle's work covers the selected cost base over time.

Neither number alone determines whether a future trip should be accepted. Some allocated costs continue even if the vehicle remains idle; other resources have alternative profitable work. A short-term dispatch decision and a long-term fleet decision therefore need different comparisons.

State whether lease, depreciation, insurance, maintenance or salaried labour is already included in a rate. Adding a monthly allocation on top of an all-inclusive supplier charge can double count cost.

Close the expense trail without hiding uncertainty

Assign each pending expense an owner, source, expected amount and review date. At operational completion, show a provisional trip result when material costs remain estimated. Once actual evidence arrives, replace the matching estimate and retain the variance.

Oracle's invoice matching capability illustrates links between financial documents and transport records. The local costing process still needs to identify the service and estimate being replaced, particularly where one invoice covers several trips. Oracle Transportation Management 26C — Match Rule

A late credit or rejected charge needs the same discipline. Retain what was previously reported and why it changed. Do not remove an unresolved expense simply because a month-end report is due.

For each trip, a reviewer should be able to trace revenue, direct actuals, remaining estimates and separate allocations back to their source records. A single unexplained “other cost” total is a starting point for investigation rather than an adequate closure condition.

Compare vehicles over equivalent work

Compare similar operating periods, routes, equipment and service obligations. Show utilisation and idle time beside contribution rather than forcing an apparently precise ranking from unlike assignments.

One vehicle may have a strong contribution per completed trip but spend many days without work. Another may handle longer cycles or difficult delivery windows. Review totals and the denominator used before changing allocation.

Next actions

1. Define the costing unit and link every loaded, empty and repositioning leg within it.
2. Reconcile consumed fuel, trip-specific expenses and late adjustments, distinguishing actuals from estimates.
3. Report direct contribution and any broader allocation as separate views with a clear bridge.
4. Compare vehicles over comparable work and time periods before making a fleet or pricing decision.