RECORDS / TERMS / THE NEXT APPOINTMENT

Vehicle Log Book Templates for Tax Claims by Country

Set up a vehicle log book template for tax claims in Australia, New Zealand, Canada and South Africa, and learn which details each record needs.

9 min read1 viewsVehicle Log Book Templates for Tax Claims by Country
— · 0 votes
Contents
  1. What a vehicle log book records
  2. Australia: ATO vehicle logbook template
  3. New Zealand: IRD logbook template
  4. Canada: CRA vehicle log
  5. South Africa: Excel log book for SARS
  6. Free template download: what to check
  7. Columns a usable template should have
  8. Keeping records that hold up
  9. Questions about vehicle log book templates
  10. What should an ATO vehicle log book template include?
  11. Is there a vehicle log book template for Canada?
  12. Can I use an Excel log book template for South Africa?
  13. Where can I get a free vehicle log book template download?
  14. What does a NZ IRD logbook template need to show?
  15. How is the business use percentage calculated from a log book?

A vehicle log book template records trip dates, odometer readings and the business purpose of each journey so you can support a tax deduction for business vehicle use. The detail a template must capture depends on the tax authority of your country, such as the ATO in Australia, IRD in New Zealand, CRA in Canada or SARS in South Africa. A template is only a format; the accuracy of your own records is what supports the claim.

  • A log book links each trip to a date, an odometer reading and a business purpose.
  • The business use percentage is calculated from the business distance against total distance traveled.
  • Each country's tax authority sets its own format, period and supporting document rules.
  • A free printable log book works if the columns match what your tax authority asks for.
  • Keep fuel and service receipts alongside the log book to connect costs to trips.

What a vehicle log book records

A vehicle log book is a record of journeys made in a vehicle for which you claim a tax deduction. Every entry ties a trip to a date, a start and end odometer reading, and the business reason for the travel. The record also identifies the vehicle and the person who drove it.

The business use percentage is the share of total travel that relates to business. A log book gives you the figures to calculate that share in a defensible way. Without trip-level detail, you are guessing at a number your tax return depends on.

A log book also supports everyday operating costs when read with fuel and service receipts. Odometer readings connect a fill-up or repair to the distance covered. The service notes for your vehicle and the log book then tell the same story about its use.

  • Date of each trip
  • Start and end odometer readings
  • Total distance for the trip
  • Business purpose of the journey
  • Vehicle registration or identification
  • Driver name
  • Business and private distance split

Australia: ATO vehicle logbook template

The ATO vehicle logbook template is the format used to claim car expenses under the logbook method. It records odometer readings at the start and end of each journey and the reason for the trip. The log book covers a continuous period that sets the business use percentage for later returns, subject to the ATO's replacement rules.

An ATO-compliant log book needs the vehicle details, the odometer reading at the start of the period, and the odometer reading at the end. Business and private trips are entered as they happen, not reconstructed later. The calculated business use percentage carries into the expense claim.

A spreadsheet version of the ATO template works if it keeps the required columns and cannot be silently altered. Keep fuel, insurance, registration and service receipts for the same period. Where the log book method is uncertain for your situation, confirm the requirement with the ATO or a registered tax agent.

New Zealand: IRD logbook template

The NZ IRD logbook template records business travel so the business proportion of vehicle costs can be worked out. Inland Revenue asks for the vehicle's odometer reading at the start and end of the log book period. Each trip entry shows the distance, the date and the business reason.

A log book kept for a set period gives a business use percentage that applies to vehicle expenses. The IRD logbook format must show both business and private travel to justify that split. Keep the completed log book with the expense records for the same period.

Drivers sometimes keep a log for a short representative period and apply the result to the wider year. The rules on how long a log book stays valid differ by tax authority and by situation. Confirm the current IRD requirement before relying on an older log book.

Canada: CRA vehicle log

The Canada CRA vehicle log records the kilometers driven for business against total kilometers driven in the year. Canada Revenue Agency expects a record of each business trip with the date, destination and purpose. The log supports the business portion of motor vehicle expenses on a tax return.

A CRA vehicle log template holds the vehicle identification, the total kilometers for the year and the business kilometers. Keeping a trip-by-trip record makes the business figure traceable rather than estimated. Fuel, insurance, maintenance and lease or loan interest records sit beside the log.

A mileage log and a cost log are related but not the same document. The mileage log establishes the business share, while receipts establish the total cost. Where employment or self-employment rules affect the claim, confirm the CRA requirement for your situation.

South Africa: Excel log book for SARS

A vehicle log book template Excel file for South Africa tracks business and private kilometers for a tax year. The record supports a claim for business travel against vehicle running costs. Each trip needs a date, odometer readings, distance and the reason for travel.

An Excel log book for South Africa should separate business trips from private trips clearly. Formulas can total the business distance and divide it by the total distance to give the business use percentage. Protect the formulas so the figures are not changed by accident.

Keep fuel slips and service invoices in the same file or folder as the spreadsheet. Where an employer reimburses travel or where the claim rules are unclear, confirm the SARS requirement or ask a tax practitioner before filing.

Free template download: what to check

A free vehicle log book template download is only useful if its columns match the records your tax authority requires. Check that the template captures the date, odometer readings, trip purpose and a running total. A free printable log book suits drivers who record trips by hand and file the pages.

A template built for another country can miss a required field or use the wrong distance unit. A spreadsheet using miles will not suit a country that records kilometers without conversion. Match the template to the tax authority whose rules apply to your return.

Free templates often carry no support and no updates when rules change. Save a blank copy before you start, and back up the completed file. The tax authority's own published layout is the reference when a template disagrees with it.

Columns a usable template should have

A usable template keeps every entry short and repeatable, so a driver can fill it in at the end of a trip. The standard columns cover the date, the vehicle, the driver, the start and end odometer readings and the purpose. A distance column calculated from the odometer readings reduces arithmetic errors.

A business or private flag lets you total each category separately. A notes column holds details of a customer visit or a delivery that the purpose field cannot fit. A monthly or yearly summary sheet turns the entries into a business use percentage.

The log book should also show a closing odometer reading for the period. That reading lets a reviewer check the total distance against the trip entries. Leave a space for the signature or name of the person keeping the record.

ColumnWhat it holds
DateDay of the trip
Odometer startReading before the trip
Odometer endReading after the trip
DistanceEnd reading minus start reading
PurposeBusiness reason for the travel
CategoryBusiness or private trip
VehicleRegistration or identification

Keeping records that hold up

A log book holds up when it is filled in as trips happen, not recreated at tax time. Consistent odometer readings are the backbone of the record. A missing reading weakens the link between a trip and the cost it supports.

Store the log book with fuel receipts, service invoices and insurance documents for the same period. An organized record starts with the details you already have, such as service notes, dates and everyday vehicle costs. Paper and digital copies should both be kept where the tax authority requires records to be retained.

A tax professional can check whether a log book method suits your claim before you build a year of entries. Where a job needs a trained specialist, such as correcting a filed return, consult one. A template does not replace that advice.

Questions about vehicle log book templates

What should an ATO vehicle log book template include?

An ATO vehicle log book template should record the vehicle details, start and end odometer readings, and each trip with its business purpose. The entries cover a continuous period that sets the business use percentage. Confirm the current ATO requirement or ask a registered tax agent before relying on the result.

Is there a vehicle log book template for Canada?

Yes, a Canada vehicle log template is available in spreadsheet and printable forms. The CRA vehicle log records each business trip with date, destination and purpose, plus total and business kilometers for the year. The business share of motor vehicle expenses is then calculated from those figures.

Can I use an Excel log book template for South Africa?

Yes, an Excel vehicle log book works for South Africa when it separates business and private trips and totals the distance for each. A business use percentage is calculated from those totals. Check that the file matches the SARS requirement for the tax year, or ask a tax practitioner.

Where can I get a free vehicle log book template download?

A free vehicle log book template download is offered by tax authorities, spreadsheet libraries and some vehicle service providers. Check that the columns match the tax authority whose rules apply to your return before you use it. Keep a blank copy and back up the completed file.

What does a NZ IRD logbook template need to show?

A NZ IRD logbook template needs the odometer reading at the start and end of the log book period and each trip's date, distance and business reason. Business and private travel are both recorded so the business proportion of vehicle costs can be worked out. Confirm how long a log book stays valid with Inland Revenue.

How is the business use percentage calculated from a log book?

The business use percentage is business distance divided by total distance for the log book period, multiplied by one hundred. A log book gives both figures when every trip is entered with its odometer readings and category. The percentage then applies to the vehicle costs you claim.

Latest articles