A running proof tracker is a sheet with one row for every payment you make that you may later need to show: date, what it was, the amount, whether you have the proof, and where the file lives. Update it within a week of each payment. The point is that in January or March you are not hunting for a receipt from May. Whether any payment counts for anything is a question for your CA, not for the sheet.
Why log payments as they happen?
Most of the scramble at the end of a financial year comes from one cause: the proof exists, but nobody knows where. Premium receipts arrive by email, fee receipts by post, and statements by download. A tracker turns all of these into one view, so a missing item is obvious while there is still time to ask for it.
What columns should the sheet have?
| Column | What to write | Example |
|---|---|---|
| Date paid | Day the money left your account | 14 Jun 2026 |
| Product or purpose | Short label of what you paid for | Term insurance premium |
| Paid for | Whose name it is in | Self |
| Amount | In rupees | ₹14,800 |
| Mode | UPI, bank transfer, cheque, card | Net banking |
| Proof status | Got it, Asked for it, Missing | Got it |
| File link or folder | Where the PDF or photo is stored | 2026-27 / Proofs / insurance-june.pdf |
| Note for CA | Any question you want to ask | Policy in my name or my spouse's? |
There are no limits or eligibility rules in this sheet, on purpose. It records facts. What counts, in which year and up to what amount, is decided by rules that change, and your CA will tell you.
How do you set it up in a spreadsheet?
Put the headings in row 1 and the data from row 2. To see the total of everything logged, use a formula in a cell below the table, such as =SUM(D2:D200) if the amounts are in column D. To count how many rows still have no proof, with proof status in column F, use =COUNTIF(F2:F200,"Missing"). To see the total for one purpose, with the label in column B, use =SUMIF(B2:B200,"Term insurance premium",D2:D200). The order of arguments in SUMIF is the range to test, then the condition, then the range to add. These work in both Excel and Google Sheets.
With hypothetical entries of ₹14,800, ₹25,000 and ₹6,200, the total is 14,800 plus 25,000 plus 6,200, which is ₹46,000. If one of the three rows is marked Missing, the COUNTIF cell shows 1, and you know exactly where to look.
What does proof status mean in practice?
- Got it: the receipt or statement is saved and the file link works.
- Asked for it: you have written to the company or institution and are waiting. Add the date you asked.
- Missing: nothing yet and no request sent. This is the status to clear first.
What should you store with each row?
Whatever the payer or institution gives you: a receipt, a premium certificate, a fee receipt, an account statement page. Save it in a folder for the April-to-March year, named with the date and a short label. Check that the name on the paper is the person you wrote in the Paid for column.
What should you ask your CA?
Bring the sheet and ask what is useful for your situation. Do not assume that logging a payment means it qualifies for anything. Ask whether any items should be recorded differently, whether any proofs are missing, and what the deadlines for the year are, as these can change.
When does a sheet stop being enough?
If the sheet grows large, or you want payments from your bank statements picked up without typing, SpendixAI can import the statements, categorise the lines, and keep a receipt with each transaction. You can create a category of your own for the payments you want to track and export a CSV. The proof status and CA notes can still stay in your sheet.
A closing checklist
- Create the sheet with the eight columns.
- Log each payment within a week.
- Save the proof the same day and add the file link.
- Clear every Missing row first.
- Send the sheet to your CA before the year ends.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

