Kolumn

19 / 20 · Time and projects

Mileage log

A mileage log with totals by month and purpose.

SEK 69

Incl. 25% Swedish VAT. Buyers outside the EU and EU businesses with a valid VAT number pay 20% less.

Also part of the bundle with all 20 templates for SEK 499. All 20 templates

Middle Earth Consulting AB contributes 1% of your purchase to removing carbon dioxide from the atmosphere.

What it does

A mileage log where the odometer reading carries over from trip to trip. The template calculates the distance and totals business and private driving per month.

What you get

Sheets
Log, Summary
Each file also has an instructions sheet and a lists sheet.
Formulas
1065
Files
2 × .xlsx: English and Swedish
Works in
Excel (Windows, Mac, web), Google Sheets, LibreOffice
Macros
None
Licence
One licence per business or household, unlimited internal users

Screenshots

English version with example data
English version with example data
Swedish version with example data
Swedish version with example data

How to use it

  1. Enter the registration number and the odometer reading at the start of the year.
  2. For each trip: date, odometer at the end, purpose, from/to and type (business or private). The start value is taken from the previous trip.
  3. The Summary sheet shows driving per month and the reimbursement.