An English Excel (XLSX) workbook for self-employed people and small businesses to record trips by odometer reading, split business and personal distance, and add up paid vehicle costs by period. One-time digital download with a BLANK workbook for your records and a DEMO workbook with fictional examples.

The problem it solves

Business and personal kilometres and vehicle costs end up scattered across notes, receipts and memory, so totals are hard to trust when you need them.

Who it is for

Freelancers, sole traders and small businesses who drive for work and want one simple workbook for mileage and vehicle costs.

What you get

• Record trips with start and end odometer readings; distance is calculated for you and split into business and personal
• Register up to 10 vehicles, each in km or miles, with up to 500 trip entries and 500 paid cost entries per workbook
• Overview totals for any period and vehicle, with a month-by-month table and a km or miles display switch
• Six cost categories (Fuel, Parking, Tolls, Service, Insurance, Other) with optional receipt references
• Input flags and reading review warnings point out invalid records, overlapping readings and missing business purposes
• A fictional DEMO workbook shows how everything works before you start with the BLANK one

How you use it

1. Extract the ZIP, open the BLANK workbook in desktop Excel and save a working copy.
2. Read the Guide tab, then register your vehicles with a unique ID and a fixed km or miles odometer unit.
3. Enter trips and paid costs in the yellow input cells; pale blue cells are formulas.
4. On the Overview sheet set the start and end dates, vehicle (or All), currency label and km or miles display.
5. Check the status and review flags, then use the totals. Save dated XLSX copies as backups.

Questions