Mileage log template and example in Excel
A free template with every field the Estonian Tax and Customs Board (MTA) expects to see, plus a formula that never pays out more than €550 a month. No sign-up.
Download the template
Excel if you want kilometres and the allowance to add up by themselves. PDF if you prefer a pen.
No sign-up. The template is in Estonian, the language your accountant files in.
What's in the template
- Header fields, once a month:the driver's name, the car's registration number, the month and the employer.
- One row per trip: date, odometer at the start and end, route and purpose. Distance is calculated from the two readings.
- Month total: kilometres and the allowance via
=MIN(km × 0.5, 550), so the sheet can't pay out more than the tax-free cap. - A «Juhend» (guide) sheet with the rules on one page, and a last sheet about DrivLog.
Why exactly these fields is explained on the logbook requirements page.
A filled-in example
This is what a correctly filled mileage log looks like for one month. Driver: Mari Tamm, car 123 ABC, October 2026.
| Date | Start | End | Km | Route | Purpose |
|---|---|---|---|---|---|
| 01.10 | 48,213 | 48,396 | 183 | Tallinn → Tartu | Client meeting, Tartu |
| 02.10 | 48,396 | 48,558 | 162 | Tartu → Pärnu | Contract signing, Pärnu |
| 05.10 | 48,558 | 48,686 | 128 | Pärnu → Tallinn | Return to the office |
| 07.10 | 48,686 | 48,717 | 31 | Tallinn → Keila | Client meeting, Keila |
| Total | 504 | 504 km × €0.50 = €252.00 | |||
Note that each row's end reading is the next row's start, every purpose says why the trip was made, and the month stays under the €550 cap. The same layout works as a paper form: print the PDF and fill it in by hand.
How to fill it in
- At the start of the month fill in the header and write the odometer reading on the first row.
- Log each work trip the same day. A sheet filled from memory at month-end is where distances turn into «about 180».
- Write a purpose that says something: «client meeting, Tartu», not «work».
- At month-end check that each row's end reading is the next row's start. Save as PDF and send it to your accountant.
Template or DrivLog?
Honest answer: with a handful of trips, the template is enough. The difference is who keeps an eye on the formulas and the odometer.
| Comparison | Excel template | DrivLog |
|---|---|---|
| Price | free | €3 per user a month, 7 days free |
| Distance | look it up on a map, type it in | calculated from the addresses |
| Odometer | typed on every row | moves forward with each trip |
| €550 cap | the formula is there until someone overwrites it | always applied |
| Empty purpose | Excel allows it | required field |
| On a phone | awkward | works in the browser |
| Month-end | save a PDF yourself | PDF and Excel in one click |
Where Excel usually lets you down
Not in the file format. A mileage log kept in Excel is perfectly acceptable — the law asks for content, not a particular program. The mistakes come from people: a blank cell, a «128?» typed as text that drops out of the sum, an odometer reading that doesn't follow on. The most common ones, with examples, are on the requirements page. To choose between paper, Excel and an app, see the comparison.