Tax and GST

How to total your deductible expenses at year end in A$

A three-pile method for totalling deductible expenses at year end in Australian dollars, with a logbook example, formulas and a short list to give your accountant.

Editorial illustration for How to total your deductible expenses at year end in A$

Total deductible expenses at year end is the sum of what you spent for work, minus the private part of any mixed-use cost, with proof for each line. Sort a full year of spending into three piles (business, mixed, personal), turn the mixed pile into a business portion, and add the first two. Then ask your tax agent or accountant to confirm what actually qualifies, because that is their call and the rules are theirs to apply.

Why does the total usually come out wrong?

Most mistakes are not arithmetic. They come from one account carrying everything, so a coffee, a lens and a school fee sit in the same list. Another cause is memory: by the end of the year nobody remembers what a A$212 charge in March was for. The fix is to classify as you go, or at least month by month, instead of in one weekend.

How do I sort a year of spending into three piles?

  1. Export the year from each account or card you used for work.
  2. Add a column called Pile with one of three words: Business, Mixed or Personal. In Google Sheets, a drop-down from Data validation keeps the spelling consistent.
  3. For Mixed rows, add a column called Share with a decimal, such as 0.36.
  4. Total the business pile with =SUMIF($E$2:$E$600,"Business",$D$2:$D$600).
  5. Total the mixed pile's business portion with =SUMPRODUCT(($E$2:$E$600="Mixed")*$D$2:$D$600*$F$2:$F$600).
  6. Add the two figures for your working total.

Here D is the amount in A$, E is the pile and F is the share. The formulas work in Excel and in Google Sheets.

Worked example: a freelance photographer

These figures are made up to show the arithmetic. Say the photographer drove 9,000 km in the year, and a logbook shows 3,200 of those were for client shoots. That is 3,200 / 9,000 = 0.3556, or about 36%.

LineAmountHow it is treatedWorking figure
Memory cardsA$240.00Business, share 1A$240.00
Editing software (A$29.99 x 12)A$359.88Business, share 1A$359.88
FuelA$2,100.00Mixed, share 3,200 / 9,000A$746.67
New lensA$1,850.00Held for the accountantNot counted yet
Working total--A$1,346.55

The total is 240 + 359.88 + 746.67 = A$1,346.55. The lens is a large one-off purchase, and how big items are treated is something to raise with your accountant, so it waits in a separate list instead of being added in.

What proof should sit behind each line?

  • A receipt, tax invoice or supplier email for each business item.
  • A logbook or trip diary for anything split by use, written at the time, not rebuilt afterwards.
  • A short note for odd items: who, what, and why it was for work.
  • Bank statements as a backup, not as the only evidence.

What if my records start late in the year?

Do what you can from what exists. Bank and card statements go back a long way, so you can still rebuild the year; it is slower than doing it monthly, but not impossible. Start with the biggest rows, because ten large items usually matter more than two hundred small ones. For the logbook, ask your agent what period of trip records they want before you invent figures for months you cannot recall. Never fill gaps with estimates presented as facts.

What do I hand over, and when should I ask a professional?

Give your tax agent the sheet, the receipts folder and your held-for-question list. Ask early about anything unusual: a vehicle, a home workspace, equipment bought late in the year, or income that arrived from overseas. Rules and limits change, so confirm the current position with your agent or the official source instead of relying on an article, including this one.

SpendixAI is built around India and INR, so it is not offered here as an Australian product. The same habits apply with any tool: category, share, receipt, note.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports