Mileage and Expense Tracking Without a Spreadsheet

Business miles are one of the most valuable deductions a self-employed person has, and one of the easiest to lose. A spreadsheet you update "when you remember" is a spreadsheet full of guesses. Here's how to keep an honest mileage log and your receipts together, without babysitting a grid of cells.

Why the spreadsheet always fails

A mileage spreadsheet asks you to do the hardest thing at the worst time: record a trip after you've already parked, unloaded, and moved on to whatever you were driving there for. The entry never happens. Weeks later you're reconstructing routes from memory, which is exactly the kind of record that falls apart under review. Your receipts, meanwhile, live in a different pile entirely — a photo roll, an inbox, a glovebox. Two disconnected systems means two chances to forget, and no single place that answers "what did this trip actually cost me?"

The fix isn't a better spreadsheet. It's capturing each thing once, at the moment it happens, and letting the record assemble itself.

What a compliant mileage log actually needs

You don't need fancy software to satisfy a tax authority — you need four facts per trip, recorded close to when the driving happened:

• Date — the day of the trip.
• Destination and purpose — where you went and the business reason (client visit, supply run, job site).
• Miles driven — the distance for that trip.
• A running total — enough to show your business-versus-personal split over the year.

Both the IRS and CRA expect a log that's contemporaneous — kept as you go, not invented in April. Commuting from home to a regular workplace generally doesn't count; trips between job sites, to clients, or to pick up business supplies generally do. When in doubt, note the purpose so the trip explains itself later.

Two ways to deduct driving — pick one

There are two methods, and you generally choose the one that gives you the larger deduction:

1. Standard mileage rate. You multiply your business miles by a per-mile rate set by the tax authority each year. Simple, and it folds in fuel, wear, and depreciation. You still need the mileage log — the rate is worthless without the miles behind it.
2. Actual expenses. You total what the vehicle really cost — fuel, insurance, repairs, registration, a share of depreciation — and deduct the business-use percentage. This method lives or dies on your receipts.

Notice that both methods need records you're tempted to skip: one needs every trip logged, the other needs every receipt kept. That's the real argument for tracking miles and expenses in the same place — whichever method wins at tax time, you already have the paperwork.

Keep miles and receipts in one place

The lazy, reliable habit looks like this. When you fill up the tank or pay for a repair, photograph the receipt on the spot and let it get read, categorized, and filed — merchant, date, total, tax, and line items captured without typing. When the trip itself matters, note the destination, purpose, and distance while it's fresh. Now the fuel receipt and the drive it paid for aren't in two different systems; they're part of the same running record of what your vehicle costs to run for the business.

Expense Rabbit handles the receipt half of that automatically. Snap a gas or maintenance receipt and it reads the details, assigns a category with a confidence score you can correct in a tap, and keeps everything synced between your iPhone and the web on one account. At tax time you export a single books-ready CSV instead of reconciling a spreadsheet against a shoebox — whichever deduction method you end up using.

Do it once, not twice

The whole point is to stop maintaining two half-finished records that only get reconciled once a year under deadline pressure. Capture the receipt when you pay. Note the trip when you drive. Let both sit in the same searchable place. When someone asks you to back up a vehicle deduction — or you're simply deciding which method to claim — the answer is already sitting there, complete, instead of waiting to be rebuilt from memory and faded paper.

← More guides