Skip to content

Mileage log

Log trips with odometer readings and get distance, monthly totals and the amount to reimburse.

Mileage log template, first page

Fill it in and preview

Mileage log

A log of vehicle trips for tax or expense claims. Record the date, the places, the purpose and whether the trip was Business or Personal, with the odometer at the start and the end. The sheet works out each distance and the amount to reimburse at your rate for business trips, shows totals, the business share of all driving and a check for readings that go backwards, and a month by month table on the Summary sheet. Download it as Excel, OpenDocument, PDF or CSV.

Log

Mileage log

Add one row for every trip. Enter the odometer at the start and at the end. Distance and the amount to reimburse follow.

Driver Katarzyna Wojcik

Vehicle Skoda Octavia, GD 4471K

Year 2027

Rate per km for business trips 0.300

Date From To Purpose Type Odometer start Odometer end
2027-03-02 Office, Gdansk Client site, Gdynia Installation visit Business 48,210 48,245
2027-03-02 Client site, Gdynia Office, Gdansk Return from visit Business 48,245 48,281
2027-03-06 Home Garden centre Weekend errand Personal 48,281 48,297
2027-03-09 Office, Gdansk Supplier, Tczew Collect parts Business 48,297 48,352
2027-03-09 Supplier, Tczew Office, Gdansk Return with parts Business 48,352 48,405
Total
Business distance (km) 179
Personal distance (km) 16
Business share of all driving 91.8%
Amount to reimburse 53.70
Trips with an end reading below the start 0

Summary

Distance by month

Month Business km Personal km Amount to reimburse
2027-01-01 0 0 0.00
2027-02-01 0 0 0.00
2027-03-01 179 16 53.70
2027-04-01 0 0 0.00
2027-05-01 0 0 0.00
2027-06-01 0 0 0.00
2027-07-01 0 0 0.00
2027-08-01 0 0 0.00
2027-09-01 0 0 0.00
2027-10-01 0 0 0.00
2027-11-01 0 0 0.00
2027-12-01 0 0 0.00
Year 179 16 53.70

Open this spreadsheet in nerixA preview of the first rows with sample figures. Open it in nerix to fill in your own and change any cell.

Templates are a careful starting point, not legal advice. Where the law matters, check what applies where you are.

Finance and accounting

What this template is for

A mileage log template for Excel: record each trip with odometer readings, and get distance, business and personal totals and the amount to reimburse.

It is free to fill in online, needs no account, and downloads as a Word document or a PDF. See all Finance and accounting templates All free Excel and spreadsheet templates

Finance and accounting

What you fill in

The form asks for 5 details. The document fills itself in as you type.

  • Driver

    For example: Katarzyna Wojcik

  • Vehicleoptional

    For example: Skoda Octavia, GD 4471K

  • Year

    For example: 2027

  • Rate per km for business tripsoptional

    The amount paid for each business kilometre. Use miles and a rate per mile if you prefer, but keep one unit throughout.

    For example: 0.30

  • Trips

    One row for each trip. Type: Business or Personal. Odometer end must be higher than the start.

Finance and accounting

What is inside

The parts of this document, in order.

  1. 1A log of vehicle trips for tax or expense claims. Record the date, the places, the purpose and whether the trip was B...

Templates

How it works

  1. 01

    Open

    Open the spreadsheet in nerix and fill in the short form. Your answers go straight into its cells.

  2. 02

    Change

    Every figure is a live formula. Change any cell and the totals, differences and charts work themselves out.

  3. 03

    Download

    Save it as an Excel file, an OpenDocument sheet, a PDF or CSV.

Make it yours with AI

Open it in the chat and ask for changes: shorter, firmer, another situation, another language.

Adapt it with nerix

Finance and accounting

Questions people ask

What details does this template ask for?

The form asks for 5 details, starting with Driver, Year, Trips. 2 more are optional.

Can I download this template as Word or PDF?

Yes. Open it in nerix and the finished spreadsheet downloads as Excel, OpenDocument, PDF or CSV. It is free and the page only shows sample figures.

Is what I type sent anywhere?

No. What you type stays in your browser while you fill in the document. It only goes to nerix if you choose to open the template in the chat.

What should I check before I use this template?

Tax and expense rules for mileage differ by country, including the rate, which trips count and what records you must keep. Enter the rate your employer or tax authority allows, and keep the log up to date.

Are these finance templates free?

Most are. Fill in and download them for free as Word or PDF, with no account. A few longer documents are premium: free to fill in, paid once to download, and marked with their price.

Do these templates include tax rules?

No. Tax and invoicing rules differ by country. Each template has fields for amounts and references, and you add the tax details your local rules require.

Can I use them with my accounting software?

Yes. They are plain documents. Download the Word version, or copy the figures into your software.