To track tax-saving investments in one place, make a single sheet with one row per payment: date, product, amount, account and proof. Fill it from your statements every quarter instead of in March, so you can see the year's total before the deadline rather than after.
Why do tax-saving payments scatter?
A policy premium goes from one bank account, a recurring investment from another, a provident fund contribution through payroll, a tuition payment on a credit card. Some are yearly, some monthly, some random top-ups at the end of the year. No single statement shows them all, so the total is anybody's guess.
What does one row of the sheet need?
- Date of payment
- Product type, written in your own words: life insurance, provident fund, fixed deposit, tuition, loan principal
- Name of the institution
- Amount paid
- Account or card it left from
- Proof: certificate, passbook, statement, receipt
Limits and eligible products change from year to year, and they differ by tax regime, so your sheet should not hard-code any limit. Ask your CA for the figure and type it in a single cell you can update.
How do you set it up so it totals itself?
Say product types are in column B and amounts in column D. In Excel or Google Sheets:
- Total for the year: =SUM($D$2:$D$300)
- Total for one product: =SUMIFS($D$2:$D$300, $B$2:$B$300, "Provident fund")
- Gap to a limit your CA gave you, kept in cell G1: =G1-SUM($D$2:$D$300)
- If the result is negative, you have already crossed that figure.
The last two lines work whatever the limit is, which is why the limit lives in a cell and not in the formula.
What does it look like with made-up numbers?
| Product | How paid | Amount for the year |
|---|---|---|
| Provident fund | Monthly, via payroll | ₹60,000 |
| Life insurance premium | Yearly, bank account 2 | ₹24,000 |
| Child tuition | 3 terms, credit card | ₹30,000 |
| Home loan principal | Monthly EMI part | ₹48,000 |
These add up to ₹1,62,000 (60,000 plus 24,000 plus 30,000 plus 48,000). If your CA says the relevant limit for you is ₹1,50,000, the gap formula returns minus 12,000, meaning the list already goes past that limit and no new payment is needed. If the limit were ₹2,00,000, the gap would be ₹38,000. Remember that a payment counting in your sheet is not the same as counting for tax.
When should you review it?
- End of June, September, December and early March.
- At each review, add anything missing and check it against the statement of each account.
- Mark proof as in hand or still to collect.
- In December, ask your CA whether anything else needs to change before year end.
What about payments that never touch your bank statement?
Payroll deductions, employer contributions and some small savings schemes may not appear in your personal statements at all. Ask HR for the salary slip trail or an annual statement, and add those lines to the sheet by hand with the source named in the proof column. Mark each as confirmed only when you hold the document, so the sheet always shows what is proven and what is only expected.
Where does an expense tracker fit?
The payments themselves are in your bank statements. SpendixAI lets you import those statements from several accounts into one workspace, set up a category for tax-saving payments, and run a report on that category for the year. Payments made through payroll will not appear in a bank statement, so keep those in your sheet or enter them by hand.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

