Tax and GST

An index sheet for your tax folder: one row per document

Build a simple index sheet for your tax folder with one row per document: six columns, six example rows and a formula to count papers not yet checked.

Editorial illustration for An index sheet for your tax folder: one row per document

An index sheet is a single spreadsheet tab with one row for each document in your tax folder: what it is, where it came from, which period it covers, its file name, when you received it and whether you have checked it. It takes a minute per document and turns a folder you have to open into a list you can scan, filter and hand to your CA.

What columns does the index need?

  • Document: a plain description, such as "Salary account statement" or "Health insurance premium receipt".
  • Source: where it came from (bank, employer, insurer, landlord, you).
  • Period: the month or financial year it covers, such as "Oct 2026" or "FY 2026-27".
  • File name: the exact name in your folder, so you can find it in seconds.
  • Received on: the date you got or downloaded it, as a real date in the sheet.
  • Checked: "Yes" or "No", meaning whether you opened it and confirmed the name, period and amount are right.

Six columns are enough. More columns usually means fewer rows get filled in.

What do filled rows look like?

These six rows are examples only, with invented names and file names.

DocumentSourcePeriodFile nameReceived onChecked
Salary account statementBankOct 20262026-10 Salary account.pdf03-Nov-2026Yes
Credit card statementCard issuerOct 20262026-10 Credit card.pdf05-Nov-2026Yes
Health insurance premium receiptInsurerFY 2026-27Health premium receipt.pdf12-Aug-2026Yes
Rent receiptLandlordOct 20262026-10 Rent receipt.jpg07-Nov-2026No
Salary slipEmployerOct 20262026-10 Salary slip.pdf01-Nov-2026Yes
Donation receiptTrustFY 2026-27Donation receipt Mar.pdf04-Nov-2026No

How do you find what is still unchecked?

In Excel or Google Sheets, with the Checked column in F and your data in rows 2 to 500, this counts the rows still marked "No":

  • =COUNTIF($F$2:$F$500,"No")
  • To count unchecked papers for one period only, with the period in column C: =COUNTIFS($F$2:$F$500,"No",$C$2:$C$500,"Oct 2026")

Put the first formula at the top of the sheet where you will see it each month. In the example above it returns 2. To see the actual rows, turn on the filter in the header row and filter Checked to "No".

A tidy way to avoid typing mistakes is to make column F a drop-down list with only "Yes" and "No", using data validation in either program. That way, "yes", "Yes " and "Y" cannot all appear in the same column and spoil the count.

Should the sheet live in the same place as the folder?

Yes. Keep the index inside the year folder, or in the top Money Papers folder if you use one sheet for all years with a "Financial year" column. A sheet saved on your desktop while the papers sit in the cloud will drift apart. Where you store the file, keep it private, because a list of your papers, accounts and sources is itself sensitive.

How is a row different from a copy of the paper?

The index does not hold the document. It only records that you have it and where it is. Do not type account numbers or full policy numbers into it. A short note like "last four digits ending 4821" is plenty to tell two similar documents apart without writing out a complete number.

When does a sheet stop being enough?

An index tells you which papers you hold. It does not add up your spending, categorise your payments or match a receipt to a payment. If you also want that, SpendixAI can take the same bank statements and show the rows for you to review before saving. For the folder itself, the sheet is the right tool.

Set it up in ten minutes

  1. Open a new sheet and type the six headers in row 1.
  2. Freeze row 1 so the headers stay in view as you scroll.
  3. Add a drop-down for the Checked column.
  4. Add a row for each document in the folder today, newest first.
  5. Put the COUNTIF formula in a cell at the top right of the sheet.
SPENDIXAI JOURNAL

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

Explore your reports