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 |
