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?
| Column | Header | Notes |
|---|---|---|
| A | Date | Real dates, not text |
| B | Payee | As on the statement |
| C | Category | From a short fixed list |
| D | Amount | In A$, positive numbers |
| E | Status | Not relevant, Maybe, Needs proof or Ready |
| F | Note | What 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?
| Status | Rows | Amount | Next step |
|---|---|---|---|
| Ready | 48 | A$3,904.20 | Hand over |
| Needs proof | 11 | A$1,126.00 | Find receipts |
| Maybe | 9 | A$684.50 | Ask the accountant |
| Not relevant | 212 | A$18,230.00 | Leave 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
- Fill in the start and end dates on the Summary sheet.
- Run the Maybe count and book time with your accountant for those rows.
- Clear Needs proof from the biggest amount down.
- Save a dated PDF of the Summary tab.
- 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.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


