Australian Tax-Time Record Keeping Kit: Excel Spreadsheet Template (Example and Blank Files)

General information and planning tool only. Not financial advice, tax advice or accounting advice: it does not consider your situation. Check with the ATO or another official source, or a registered tax agent or licensed adviser, before you act.

Keep income, deductions and receipts in one place all year, then see every total at tax time.

What You Get

• Income and deductions logs with dropdown categories
• Work-related use percentage and claimable amount worked out for each entry
• Summary by category, receipts-still-to-find count and a document checklist
• Example file and blank file (Excel)
• Formulas work in Microsoft Excel. You can also upload the file to Google Sheets (File > Import); please test it with your own data first

How It Works

Open the Start Here sheet, fill the yellow cells and read the summary. The example file shows how it looks with sample figures.

Please Note

Created by LifePlanLabs with AI assistance, then checked: calculations and answer keys are generated and verified by code, and every page was reviewed before sale. A parent, teacher or adviser should still read through it. Digital download only, no physical item. For personal or own-classroom/own-business use; please do not resell or share the file. Australian English.