Sole Trader Kilometre Log, Monthly Tracking Template

Free Kilometre Log Template for Sole Traders — Track Car Expenses the ATO
Way

If you use your vehicle for work, you’re leaving money on the table without a
proper log. The ATO requires you to record every business trip — date, start
and end point, purpose and kilometres driven. This free kilometre log template
does all the heavy lifting for you.

What You Get :

  • Pre-formatted monthly log sheet with Date, Start Location, End Location,
    Purpose and odometer fields
  • Auto-calculated Total km column — no manual maths
  • ATO cents-per-km rate pre-loaded (88¢/km for 2024-25) with auto-calculated
    deduction estimate
  • Monthly Totals row so you know exactly what to claim
  • ATO-compliant layout — ready to hand to your accountant at tax time
  • Works in Excel and Google Sheets

Who It’s For :

Tradies, consultants, delivery drivers, NDIS workers, real estate agents — any
sole trader who drives for business.

ATO / Compliance Note :

The ATO cents-per-km method allows you to claim up to 5,000 km per vehicle
per year without a full logbook. You must record the purpose of every trip. This
template satisfies that requirement.

KMtracker Infographic


FAQ

Do I need to keep a logbook to claim car expenses?

For the cents-per-km method (up to 5,000 km/year), a logbook is not required
but you must be able to show how you calculated your claim. This log covers
that. For the logbook method (over 5,000 km or higher deductions), a full 12-
week logbook is required.

Do I need to keep a logbook to claim car expenses?

The ATO rate for 2024-25 is 88 cents per kilometre. This template has it preloaded. Update cell H4 if the rate changes.

Do I need to keep a logbook to claim car expenses?

Yes. Open Excel, File > Save As > Google Sheets, or upload directly to Google
Drive and open with Sheets. All formulas are compatible.