A document tracker is a table with one row per piece of paperwork: what it is, who issues it, when it usually arrives, whether you have it, and where the saved copy lives. It holds no figures, so nothing in it can be wrong; its only job is to make sure nothing is chased late. Here is a layout you can copy into Excel or Google Sheets.
What columns should the tracker have?
| Column | Heading | Notes |
|---|---|---|
| A | Document | Name as the issuer calls it |
| B | Source | Employer, bank, insurer, landlord, fund house, broker |
| C | Expected month | Your own note, from what the source tells you |
| D | Received | Dropdown with Yes or No |
| E | Link to saved copy | A link to the file in your drive folder |
| F | Notes | Who you asked, on which date |
For D, set data validation to a list of Yes and No. In E, paste the sharing link of the file, or use =HYPERLINK("link","Open") so the row stays tidy.
Which documents belong in the list?
Start with these and delete what does not apply. Ask your CA which of them matter for your return, because that depends on your situation and on rules that change.
- Salary: Form 16 from the employer, and the final salary slips.
- Bank and post office: interest certificates for the year.
- Loans: home or education loan interest certificate from the lender.
- Rent: landlord's name and receipts, if you pay rent.
- Insurance: premium receipts or the yearly statement.
- Investments: fund house or registrar statements, and the broker's yearly statement.
- The tax statement available on the income tax portal, which you download yourself.
- Donations and medical bills: receipts with the issuer's details.
- Freelance or business income: invoices issued, and TDS certificates from clients if any.
When does each document become available?
This is the column most trackers leave out and the one that saves the most time. You should not fill it from a generic list, because dates vary by employer, bank and fund house. Instead, when you set up the tracker, ask each source and write down what they say, for example 'HR says by the end of the month after March' or 'bank portal, download after the year closes'. Then sort by column C and chase in order. A month you wrote yourself is a reminder; it is not a legal date, so do not treat it as one.
How do you see what is still missing?
Three formulas on a summary line, with the table in rows 2 to 40:
- Received so far: =COUNTIF(D2:D40,"Yes")
- Still pending: =COUNTIF(D2:D40,"No")
- Progress: =COUNTIF(D2:D40,"Yes")/COUNTA(A2:A40)
Format the progress cell as a percentage. Add conditional formatting on column D, with a custom formula =$D2="No" and a soft red fill, so the pending rows stand out when you open the sheet.
What if a document never arrives?
Add two columns to the right: Chase on, with a date, and Chased how, such as email, call or portal request. When you open the sheet, filter for rows where Received is No and Chase on is today or earlier. Most delays are small, such as an employer that sends certificates in batches or a bank that needs a written request, and a dated note stops you asking the same person twice. If a source cannot supply something, write that in Notes and tell your CA early, since they may know another route.
Keeping expense paperwork with the spending
This sheet tracks documents that other people send you. Receipts for your own spending are a different job, and SpendixAI keeps receipts with the transactions they belong to, which makes a bill easy to find later. Whether any of it matters for your return is a question for your CA.
Before you hand things to your CA
- Every row with Received set to Yes has a working link.
- Rows still on No have a note saying who you asked and when.
- The sheet and the folder are shared only with the people who need them.
- You have asked your CA what else is missing from the list.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

