What does a vehicle cost tracker show?
A fleet cost analysis starts with one question: what does each vehicle actually cost, and what does it cost per kilometer? Totals by cost type hide the answer. This tracker keeps every cost against a vehicle, so you can see which vehicles cost more than others of the same kind, which cost category drives it, and how cost per km moves month by month.
The costs are actuals from invoices, fuel card statements and payroll, not estimates. The cost per km uses odometer readings, so the result is only as good as the readings: a tracking system gives you the monthly distance without waiting for drivers.
How to use the vehicle cost tracker
- Set the currency, the first month of the view and the outlier factor on Settings. The sheets show 12 months from the first month.
- List your vehicles on Vehicles, with group, purchase data and the odometer at the start of the view.
- Enter each cost on Cost ledger with its vehicle and category. Split a shared invoice across vehicles before you enter it.
- Enter the month-end odometer for each vehicle on Odometer.
- Read Ranking and Dashboard each month, and look at the cost categories of any vehicle that is flagged.
How cost per km and the outlier flag are calculated
Straight-line depreciation spreads the purchase cost minus the residual value evenly over the useful life. The outlier factor is a company choice; the file uses 1.2 as an example. The group average includes every vehicle in the group that has km in the period.
Worked example: one truck stands out
V-03 and V-04 are the same light truck model. From January to September 2026, V-04 cost 13,430 USD for 50,680 km, or 0.27 per km; V-03 cost 9,385 USD for 57,340 km, or 0.16 per km. The group average is (0.16 + 0.27) ÷ 2 = 0.21, so V-04 runs at 1.24 times the average, above the 1.2 factor, and is flagged.
Its maintenance column explains it: a 3,333 USD gearbox repair in May and brakes in August, on the oldest vehicle in the fleet. Its lifetime TCO sheet shows the depreciation already charged and the book value, which is what you need next to decide whether to repair it again or replace it. The Fleet Vehicle Replacement Calculator takes it from there.
How to keep the numbers right
- One line per document. Keep the invoice or statement number, so any figure can be traced back.
- Annual payments land in one month. Insurance paid in January raises January's cost per km. Compare vehicles with the period column, not one month.
- Check the difference line. Monthly costs shows the gap between the fleet total and the category total. A gap means a ledger line has no vehicle or a vehicle that is not on the list.
- Enter costs before the ledger. If a vehicle ran before you started the ledger, add its earlier running costs on Vehicles, or its lifetime cost per km will look too low.
Vehicle cost tracker or fleet budget?
The Fleet Annual Budget Template plans costs by type for the year and compares them with actuals, and its TCO sheet works with annual estimates. This tracker is the monthly ledger of what each vehicle actually cost. You can use both: the budget for the year, the tracker for each vehicle. For a quick estimate without a ledger, try the Vehicle Depreciation Calculator.
What the tracker does not do
It is a calculation tool, not an accounting system. It does not post entries or replace your accounts, and the depreciation method, useful life and residual value follow your company's accounting policy. All figures in the file are examples.