Keep business journeys, mileage claims and everyday expenses organised in one professional spreadsheet.

This premium Mileage & Expenses Log is designed for sole traders, freelancers, photographers, landlords, small businesses and anyone who needs a clear record of business travel and costs. Enter each journey and expense, then let the workbook calculate mileage claims, category totals and the combined grand total automatically.

WHAT IS INCLUDED
• Clean macro-free Microsoft Excel .xlsx workbook
• Automatic Mileage & Expenses Dashboard
• 100 business-journey rows
• 100 business-expense rows
• Default and individual mileage-rate fields
• Automatic claim calculations
• 12 expense categories
• Receipt and payment-method dropdowns
• Missing-receipt count
• Expense-category chart
• Seven-currency display selector
• Comprehensive Instructions tab

CURRENCY OPTIONS
GBP (£), USD ($), EUR (€), AUD (A$), CAD (C$), NZD (NZ$) and JPY (¥).

Changing currency changes the displayed symbol only. It does not convert amounts or apply exchange rates. Enter ordinary numbers without typing currency symbols.

COMPATIBILITY
Designed for Microsoft Excel as a normal macro-free .xlsx file. It can also be uploaded to Google Sheets. Core formulas and dropdowns are compatible, although chart styling and conditional currency number formatting may appear slightly different after import.

HOW IT WORKS
1. Choose your display currency.
2. Enter the reporting period and applicable mileage rate.
3. Record business journeys, mileage and purpose.
4. Add other expenses, suppliers and receipt status.
5. Review the automatic dashboard and totals.

PLEASE NOTE
This is a digital spreadsheet download. No physical item will be posted. Spreadsheet software is required. Mileage rates, evidence requirements and allowable expenses differ by country, date and circumstances. This template is an organisational tool and is not tax, accounting or legal advice.

sole trader excel

Mileage & Expenses Log