Tax and GST

Track your tax-saving investments in one place across accounts

Collect tax-saving investment payments scattered across bank accounts and apps into one list, with a worked example in rupees and a quarterly review habit.

Editorial illustration for Track your tax-saving investments in one place across accounts

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?

ProductHow paidAmount for the year
Provident fundMonthly, via payroll₹60,000
Life insurance premiumYearly, bank account 2₹24,000
Child tuition3 terms, credit card₹30,000
Home loan principalMonthly 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?

  1. End of June, September, December and early March.
  2. At each review, add anything missing and check it against the statement of each account.
  3. Mark proof as in hand or still to collect.
  4. 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.

SPENDIXAI JOURNAL

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

Explore your reports