Vehicle Expense Tracker Spreadsheet: Your Real Cost of Ownership

Ask most drivers what their car costs and you’ll get a fuel answer. “Maybe $60 a week in gas?” It’s the only number that arrives as a visible, repeated transaction, so it’s the only one the brain files under “car”. The insurance leaves the account on autopay. The tyres were March. The registration was a one-off annoyance. Depreciation never appears on a statement at all — and for a lot of vehicles it’s the biggest line of the lot.

The result is a number that’s usually wrong by a factor of two or more, which wouldn’t matter except that people make real decisions on it: whether to keep repairing an old car, whether a longer commute is affordable, whether to buy the truck. This guide covers how to build a vehicle expense tracker that produces an honest total — and, more usefully, an honest cost per mile — plus the specific logs that make the total possible.

The Seven Buckets a Vehicle Actually Costs You

A tracker that lumps everything into one column can tell you what you spent. It can’t tell you why, and it can’t tell you what to do about it. Split spending into buckets that behave differently:

• Fuel — high frequency, low individual amount, and the only bucket that also tells you something diagnostic (MPG).
• Maintenance — scheduled, predictable, cheap relative to the alternative. Oil, filters, fluids, rotations, brakes, belts.
• Repairs — unscheduled and lumpy. This is the bucket that decides whether a car stays or goes.
• Insurance — usually the second-biggest cash line, and the one most often left on autopilot for years.
• Registration, inspection, tax and fees — small, annual, invisible, and always forgotten in mental estimates.
• Loan or lease payments — where only the interest is a true cost of ownership; the principal is moving money from one pocket to another.
• Depreciation — no cash leaves your account, which is exactly why it’s ignored, and exactly why estimates come in so low.

That last one deserves its own paragraph. If a car was worth $18,000 in January and $15,000 in December, that vehicle cost you $3,000 that year whether or not it ever went near a workshop. You’ll pay it in one lump the day you sell or trade. Leaving depreciation out of a cost-of-ownership figure is like calculating a business’s profit without counting rent.

What Each Log Needs to Carry

The trick to a tracker that survives past week three is that each log holds only the fields that make a calculation possible — nothing decorative.

Fuel log: date, odometer reading, gallons (or litres), total cost. That’s it. Two consecutive odometer readings give you miles driven; miles divided by gallons gives MPG; cost divided by miles gives fuel cost per mile. The odometer column is the one people skip, and skipping it turns the fuel log into a spending list that can’t diagnose anything.

Maintenance log: date, odometer, service performed, cost, and — the important one — next due as either a date or an odometer figure. A maintenance log without a next-due column is a history book. With it, it’s a reminder system.

Repair log: date, odometer, what failed, parts cost, labour cost, shop, warranty. Splitting parts from labour matters more than it sounds: a run of repairs that’s mostly labour usually means an expensive shop, while a run that’s mostly parts means an ageing vehicle. Those two problems have completely different fixes.

Insurance: carrier, policy number, coverage type, premium, payment frequency, renewal date. The renewal date is the whole point — it’s the annual moment where shopping the policy is actually worth something.

Loan or lease: payment amount, remaining balance, rate, payoff date, interest paid to date.

Mileage log (if any driving is for business): date, purpose, start and end odometer, business miles. Contemporaneous, per-trip, and separate from everything else.

Vehicle info: purchase price, purchase date, purchase odometer, and a current estimated value you update once or twice a year from any of the public valuation sites. Those two values are what let the sheet calculate depreciation.

A Worked Twelve Months

Here’s the shape of a real annual total. The numbers below are my own illustrative assumptions for a five-year-old midsize sedan driven 12,000 miles in a year — not a national average, and not a survey. Use them as a template for the arithmetic, then substitute your own tracked figures.

Twelve thousand miles into $7,120 is 59.3 cents per mile. The fuel-only guess — the number most drivers actually carry in their head — was $1,800, or 15 cents a mile. The real figure is nearly four times the mental one.

Two things fall out of that table immediately. Depreciation ($2,100) is larger than fuel. And the two biggest lines, depreciation and insurance, are the two that never once required a decision during the year — they simply happened. That’s the general pattern: the buckets that cost the most are the ones with no transaction to notice.

Run the same table and your split may look nothing like this. A paid-off ten-year-old car has almost no depreciation and a fat repair line. A three-year-old EV has heavy depreciation, tiny fuel and near-zero maintenance. The point of tracking isn’t to arrive at my numbers — it’s to find out which shape you’re actually in, because the two shapes call for opposite decisions.

Why Cost Per Mile Is the Number Worth Having

An annual total is interesting. Cost per mile is usable, because it’s the only form of the number that can answer questions:

• Is the longer commute affordable? An extra 30 miles a day, five days a week, is roughly 7,500 miles a year. At 59 cents that’s about $4,400 — an amount that quietly rewrites a salary comparison.
• Repair or replace? A repair is worth it when the cost of keeping the old car per mile stays below what a replacement would cost per mile. That comparison is impossible without a per-mile figure for the car you already own.
• Is the second vehicle earning its place? Households with two cars often find the second one carries nearly a full year of insurance, registration and depreciation for a few thousand miles of driving. Per mile, it can be four or five times the cost of the first.
• What’s a business mile really worth? If you drive for work and reimburse at a fixed rate, your true cost per mile tells you whether the reimbursement is generous or quietly subsidised by you.

Every one of those questions is a division problem you can only do if the numerator (total cost) and denominator (miles) are both tracked. Miles come free from the odometer column in the fuel log — which is why that column matters so much.

Setting It Up Without Abandoning It in Three Weeks

The failure mode for vehicle tracking isn’t complexity, it’s frequency. Fill-ups happen weekly; nobody sits down weekly to do admin. Two habits fix it:

1. Log the fill-up at the pump. Odometer, gallons, total. Fifteen seconds while the tank fills, on your phone. Everything else in the tracker can wait.
2. Do a five-minute monthly pass. Add any maintenance, repairs, insurance and fees from the month, and update nothing else. Once or twice a year, refresh the vehicle’s estimated value so the depreciation line stays honest.

That’s the entire maintenance burden, and it’s what stands between you and a real number twelve months from now.

This is what the Vehicle Expense & Maintenance Tracker from ReadySheetGo is built around. It ships with nine tabs and 674+ auto-calculating formulas: a Fuel Log that turns odometer readings into MPG and cost per mile automatically, a Maintenance Log with next-due reminders, a Repair History with a parts-versus-labour split, Insurance and Loan/Lease tabs, an IRS-style Mileage Log, and a Dashboard that rolls the whole thing into a cost-of-ownership summary for up to four vehicles at once.

The Multi-Vehicle Problem

A household with two or three vehicles has a specific blind spot: the costs blend on the same card and the same insurance bill, so nobody can say which vehicle is the expensive one. Tracking each vehicle as its own profile — its own fuel log entries, its own repairs, its own share of insurance — is what makes the awkward question answerable. It’s frequently the low-mileage second car, not the daily driver, that turns out to be the worst value per mile.

Where to Go Next

Once the tracker is running, four questions tend to follow. Each has its own guide:

• The annual number — how the yearly cost of owning a car actually builds up, bucket by bucket, and why the guess is always low: how much does it cost to own a car per year
• The keep-or-ditch decision — the per-mile comparison that settles repair-or-replace without emotion, worked through with numbers: repair or replace your car
• The service side — what belongs in a maintenance log, the intervals worth tracking, and the copy-ready checklist: car maintenance log spreadsheet
• The tax side — the mistakes that make a business mileage log unusable, and the columns that prevent each one: vehicle mileage log for taxes

Start with the fuel log and the odometer column. Everything else in this guide is built on top of those two fields, and twelve months from now they’re the difference between a real cost-of-ownership figure and another confident guess.

Featured on ReadySheetGo

Vehicle Expense & Maintenance Tracker — Know what your car really costs, per year and per mile. Nine tabs and 674+ auto-calculating formulas covering a Dashboard cost-of-ownership summary, Vehicle Info with depreciation for up to 4 vehicles, a Fuel Log with automatic MPG and cost per mile, a Maintenance Log with next-due reminders, a Repair History with parts-versus-labour breakdown, an Insurance Tracker with renewal dates, a Loan/Lease tab with remaining balance and total interest, and an IRS-style Mileage Log for business use. Works in Excel and Google Sheets, no macros. Instant digital download — $12.99.