Tax and GST

Tax-deductible expenses summary: a status-based sheet for the year end

A year-end summary in Australian dollars that sorts expenses by status, from not relevant to ready for your accountant, using date-bounded SUMIFS totals.

Editorial illustration for Tax-deductible expenses summary: a status-based sheet for the year end

Instead of a yes-or-no flag, give each possibly tax-related expense a status that shows how far it has progressed: Not relevant, Maybe, Needs proof or Ready. Then total by status within your financial year with date-bounded SUMIFS. At year end you can see at a glance how much is ready to hand over, and how much still needs work.

Why use statuses instead of a flag?

A flag says what you think. A status says what you have done. 'Needs proof' tells you that a receipt is missing, while 'Ready' tells you the row has a category, a receipt and a note. Your accountant sees the same, so conversations start from the right place.

What is the sheet layout?

ColumnHeaderNotes
ADateReal dates, not text
BPayeeAs on the statement
CCategoryFrom a short fixed list
DAmountIn A$, positive numbers
EStatusNot relevant, Maybe, Needs proof or Ready
FNoteWhat it was for

On a Summary sheet, put your financial year's start date in B1 and its end date in B2. Check the dates that apply to you with your accountant or the official source rather than assuming them.

Which formulas total by status?

  • Ready total: =SUMIFS(Data!$D$2:$D$800, Data!$E$2:$E$800, "Ready", Data!$A$2:$A$800, ">="&$B$1, Data!$A$2:$A$800, "<="&$B$2)
  • Needs proof total: the same formula with "Needs proof" in place of "Ready"
  • Count of rows still at Maybe: =COUNTIFS(Data!$E$2:$E$800, "Maybe", Data!$A$2:$A$800, ">="&$B$1, Data!$A$2:$A$800, "<="&$B$2)

The ampersand joins the comparison symbol to the date in the cell. Putting dates in cells rather than typing them in the formula means one change updates every total.

What does a year-end view look like?

StatusRowsAmountNext step
Ready48A$3,904.20Hand over
Needs proof11A$1,126.00Find receipts
Maybe9A$684.50Ask the accountant
Not relevant212A$18,230.00Leave alone

The made-up figures give 48 + 11 + 9 + 212 = 280 rows. The first three statuses total A$5,714.70, which is the amount of attention the sheet is asking for, and the work to do is the 20 rows in the middle.

How do you clear Needs proof rows?

Sort by amount and begin with the largest. Search your email for the shop name, check the shop's account page for past orders, and look in the photo gallery for the date. Move a row to Ready when the receipt is saved and the note says what the item was for. If you cannot find proof, change the status to Maybe and write that in the note, so your accountant knows what happened.

How do you keep statuses honest across the year?

Review the sheet on the first of every month. Filter the status column to Maybe and Needs proof, and deal with anything older than sixty days, since memory and email searches both get harder with time. A row that has sat at Needs proof for months is usually either easy to fix with a ten-minute search or not worth keeping in the list. Writing the date you last touched a row in the note column also helps your accountant see which items are fresh and which are stale.

If several people share the sheet, agree who may set a row to Ready. One person owning that status keeps the word meaningful.

A year-end checklist

  1. Fill in the start and end dates on the Summary sheet.
  2. Run the Maybe count and book time with your accountant for those rows.
  3. Clear Needs proof from the biggest amount down.
  4. Save a dated PDF of the Summary tab.
  5. Hand over the workbook with a two-line cover note.

SpendixAI, built around India and rupees, is not offered for Australian records, although its categories can carry tax-deductible settings and its reports group totals the same way.

SPENDIXAI JOURNAL

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

Explore your reports