If you drive for your small business — to meet a client, visit a job site, pick up supplies, or drop off an order — a mileage log turns those trips into organised business information. Without one, business miles are easy to forget or mix up with personal trips.
A mileage log does not need to be complicated. The simpler it is, the more likely you are to keep using it. This article explains what to record and shows a clear layout you can copy into a spreadsheet or notebook.
Please note: this is general information only, not tax advice. Tax and reimbursement rules vary and change over time, so check the current rules that apply to you or ask a qualified accountant or tax professional.
Photo by Mike Bird on Pexels. Illustrative image only — it shows a car dashboard and odometer, not an actual mileage log.
What is a business mileage log?
A business mileage log is a running list of work-related trips, one row per trip. Each row answers four basic questions: when did you travel, where did you go, why was the trip for business, and how far did you drive?
You do not need a long essay for each trip. A short, specific note — for example, “client meeting” with the place name — beats a vague entry such as “driving around town.” Each entry should make sense on its own later.
Why a simple template works better than a detailed one
Many mileage logs fail for the same reason: they ask for too much. If every entry takes several minutes, you will put it off, and then stop doing it altogether. A template you can complete in under a minute per trip is a template you will actually keep.
Keep the columns to the essentials and fill the log in on the day of the trip, or at least in the same week. A record made close to the time of travel is easier to trust than one rebuilt months later.
The fields to include in your template
Start with these fields. You can add one or two of your own later, but do not add extra columns yet:
- Date — the date of the trip, not just the week or month.
- Starting point — where the trip began, such as your home office or shop.
- Destination — the place you travelled to, with enough detail to identify it later.
- Business purpose — a short reason, such as “supplier pickup,” “site visit,” or “client delivery.”
- Miles driven — the business miles for that trip only.
- Odometer readings (optional but helpful) — the reading at the start and end of the trip, or at least at the start and end of the year and when you begin using a new vehicle for business.
- Notes — anything extra, such as tolls or parking, if you track those separately.
If more than one person drives for the business, add a driver name column. If you use one vehicle for both business and personal driving, keep personal trips out of the business log, or clearly mark them in a separate section.
A copy-ready layout you can recreate
There is no downloadable file attached to this post. The layout below is designed so you can recreate it in a few minutes in a spreadsheet, a word processor table, or a paper notebook. Use one row per trip, and add a total row at the bottom of each month.
| Date | From | To | Business purpose | Miles |
|---|---|---|---|---|
| Example date | Home office | Supplier warehouse | Supply pickup | — |
| Example date | Shop | Client site | Site visit | — |
In a spreadsheet, add a simple sum formula at the bottom of the miles column for a monthly total, and name the file clearly with the year and the word “mileage.”
How to set it up in five practical steps
- Choose one place for the log — a spreadsheet you can open anywhere, or a notebook kept in the vehicle.
- Create the columns above. Resist adding extra columns until you truly need one.
- Note your starting odometer reading at the top of the log.
- Record each trip on the day it happens, or the same evening while it is still fresh.
- Review it once a week for blank fields or missing trips, and fix gaps while you still remember them.
Business, personal, and commuting miles: keep them separate
Not every mile you drive is a business mile. Trips between work locations, client visits, job sites, and business errands are the kinds of trips people record in a business log, while purely personal trips are not. Regular travel between home and a fixed workplace is often treated differently, but the exact treatment depends on the rules that apply to you — so be consistent, be specific, and check the rules that apply to you.
Paper, spreadsheet, or app?
A paper log is simple but must be totalled by hand; a spreadsheet is easy to total, search, and back up; an app can record trips automatically but still needs you to check each trip is marked business or personal. Pick the format you will open every week.
Common mistakes to avoid
- Waiting until year-end. Reconstructed logs are full of gaps. Record trips as you go.
- Writing vague purposes. “Meeting” alone does not say who you met or why. Add the place or reason.
- Mixing personal miles in. Keep personal driving out of the business total, or clearly separated.
- Keeping the log in two places. One log, in one place, is easier to total and easier to trust.
Frequently asked questions
Do I need a separate log for each vehicle?
It helps to keep vehicles separate, or at least to note which vehicle was used for each trip, so you do not have to untangle a mixed list later.
What if I forget to log a trip?
Fill it in as soon as you remember, using your calendar, messages, or receipts to confirm the date and destination. Do not leave it blank and hope you will remember it later.
Should I record odometer readings for every trip?
Start and end readings for each trip give the clearest record. At minimum, note your reading when you start the log, at the end of the year, and when you begin using a new vehicle for business.
Can I use this template for employee reimbursements?
Yes — the same fields work for employees, plus the driver name and a submission date if your business needs them. Set one clear deadline, such as weekly or monthly, so logs do not pile up.
Is there a downloadable file with this article?
No. This post does not include a downloadable file. It gives you the full layout above so you can recreate it in a spreadsheet or notebook in a few minutes, with exactly the columns you need and nothing extra.
Start small, then keep going
Create the columns today, note your starting odometer reading, and log your next business trip while it is fresh. After a month of weekly checks, the habit will feel routine.
Comments
Post a Comment