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.
| Document | Source | Period | File name | Received on | Checked |
|---|---|---|---|---|---|
| Salary account statement | Bank | Oct 2026 | 2026-10 Salary account.pdf | 03-Nov-2026 | Yes |
| Credit card statement | Card issuer | Oct 2026 | 2026-10 Credit card.pdf | 05-Nov-2026 | Yes |
| Health insurance premium receipt | Insurer | FY 2026-27 | Health premium receipt.pdf | 12-Aug-2026 | Yes |
| Rent receipt | Landlord | Oct 2026 | 2026-10 Rent receipt.jpg | 07-Nov-2026 | No |
| Salary slip | Employer | Oct 2026 | 2026-10 Salary slip.pdf | 01-Nov-2026 | Yes |
| Donation receipt | Trust | FY 2026-27 | Donation receipt Mar.pdf | 04-Nov-2026 | No |
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
- Open a new sheet and type the six headers in row 1.
- Freeze row 1 so the headers stay in view as you scroll.
- Add a drop-down for the Checked column.
- Add a row for each document in the folder today, newest first.
- Put the COUNTIF formula in a cell at the top right of the sheet.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

