Travel Expense Tracker Template: ATO-Friendly Excel Spreadsheet
Track business travel costs with this Excel travel expense template. Built for ATO record keeping: dates, amounts, GST, kilometres and receipts.
Why Track Travel Expenses Properly
Travel expenses are one of the most common deductions for Australian small businesses, and one of the easiest to get wrong at tax time. The ATO wants to see records that show the business purpose of each expense, not just a pile of receipts. A structured tracker turns a shoebox of paper into a claim you can defend.
This article walks through a travel expense tracker built in Excel, designed for ATO record keeping: dates, amounts, GST, payment method, receipts and kilometres, with totals that calculate themselves.
For the same discipline applied to job costs, see our construction job costing template. The structure transfers directly.
What the Tracker Records
Set up columns for everything the ATO and your accountant will ask about:
| Column | What goes in it |
|---|---|
| Date | Date of the expense |
| Trip / Reference | Trip name or project reference |
| Category | Flights, accommodation, meals, car, parking, other |
| Description | What it was and who it was with |
| Supplier | Who you paid |
| Payment method | Company card, personal card, cash, reimbursed |
| Total amount | Gross amount paid |
| GST | GST component of the total |
| GST-exclusive | Total minus GST |
| Receipt ref | Receipt number or file reference |
| Business % | 100% for pure business trips, less for mixed |
| Claimable | Total x business % |
The claimable column is what flows into your tax records. For mixed trips, apply the business percentage to the claimable amount rather than fudging the total.
Building the Template
Step 1: the data entry sheet
Put the column headings above in row 1. Freeze the top row (View > Freeze Panes) so headings stay visible while you scroll. Format the amount columns as currency with two decimals, and the GST column as currency too. Add data validation to the Category column (Data > Data Validation > List) so you cannot type "meal" in one row and "Meals" in the next; inconsistent categories are what make end-of-year summaries painful.
Step 2: the summary sheet
On a second sheet, build totals that update as you enter expenses:
=SUM(Tracker!G2:G1000) ' total spent
=SUM(Tracker!H2:H1000) ' total GST
=SUM(Tracker!G2:G1000)-SUM(Tracker!H2:H1000) ' GST-exclusive
=SUM(Tracker!L2:L1000) ' total claimable
Use SUMIFS to break totals down by category:
=SUMIFS(Tracker!L2:L1000, Tracker!C2:C1000, "Accommodation")
And by month for cash flow visibility:
=SUMIFS(Tracker!L2:L1000, Tracker!A2:A1000, ">="&DATE(2026,7,1), Tracker!A2:A1000, "<"&DATE(2026,8,1))
Step 3: the car travel section
Car expenses use a separate small table because the claim methods differ:
| Date | Trip purpose | Method | Kilometres (cents per km) | Deduction |
|---|---|---|---|---|
| 14/07/2026 | Client meeting, Parramatta | Cents per km | 34 | =C2*rate |
The cents per kilometre rate is set by the ATO each financial year. Put the rate in its own cell (say the rate cell is $F$1) and reference it:
=D2*$F$1
If you use the logbook method instead, your claim is based on the business percentage of actual car costs, and the tracker should hold the logbook percentage rather than per-trip kilometres.
Keeping the Records the ATO Wants
Three habits make the difference between a smooth claim and an audit headache:
- Record the business purpose at the time. A one-line purpose ("Client meeting, Surry Hills") entered while the trip is fresh is far more credible than a reconstructed one in June.
- Keep the receipts attached. Store the receipt reference in the tracker and file the physical or scanned receipt against it. The ATO requires receipts for expenses above the threshold (around $10 including GST, updated each year).
- Split mixed trips. If a business trip includes a personal day, apply the business percentage only to the business portion. Claiming the personal portion is the fastest way to trigger a review.
GST on travel
If you are GST registered, record the GST component separately on every expense so you can claim input tax credits. Keep tax invoices for expenses over the threshold. Entertainment-related travel (client meals that are entertainment rather than subsistence) has special rules, including reduced GST claims; flag those lines clearly in the tracker and let your accountant decide the treatment.
From Tracking to Profitability
Travel costs are an input to pricing, not just a deduction. The same data that supports your tax claim tells you what a client visit or a project trip actually costs, which should feed your quoting and margin decisions. Use our profitability calculator to see what those travel costs do to your project margins, then use the tracker month over month to keep them honest.
Frequently asked questions
What should a travel expense tracker record for ATO purposes?
Keep the date, amount, GST component, payment method, supplier, purpose of the trip, and a receipt reference for every expense. For car travel, record the reason for the trip, the distance, and which method you are claiming under (cents per kilometre or logbook). The ATO requires records that show the business purpose of each expense, not just the amount.
How do I claim travel expenses as a business deduction?
Business travel expenses are deductible when the dominant purpose of the trip is business. Keep receipts for expenses over the ATO threshold (around $10 including GST, updated regularly), record the business purpose at the time, and claim only the business portion of any mixed trip. Meals and accommodation while away from home for work are deductible; personal sightseeing is not.
What is the difference between cents per kilometre and the logbook method?
Cents per kilometre is a simplified method: a fixed rate per business kilometre, capped at a set number of kilometres per year, with no need for detailed records beyond the trips. The logbook method requires a 12-week logbook to establish the business use percentage, then you claim that percentage of actual running costs. Cents per kilometre is simpler; the logbook method usually gives a higher deduction for heavy business use.
Do I need to record GST on travel expenses?
Yes, if you are GST registered. Record the GST component separately so you can claim input tax credits on business travel. Split the total into GST and GST-exclusive amounts in your tracker, and keep tax invoices for expenses over the threshold. Entertainment-related travel expenses have special GST rules; check those before claiming.