Tax and GST

Where to track all your tax-saving investments in one place

A forum-style answer for tracking scattered tax-saving investments in India: numbered steps, a made-up year of entries, an honest limit and what to ask your CA.

Editorial illustration for Where to track all your tax-saving investments in one place

The question: my tax-saving investments are spread across a payslip, a PPF account, an insurer and a few SIPs, and I never know my total until March. How do I track them in one place? Short answer: one list with a row per payment, a column for the type, and a monthly habit of adding what moved. A sheet is enough; an app helps when the rows get many.

The steps we would follow

  1. Open a sheet with columns for Date, Item, Type, Amount, Paid from and Proof saved.
  2. List every source at the start of April: salary deductions, any PPF or similar deposit, insurance premiums, children's tuition fees, loan principal repayments, and whatever else your CA has told you counts.
  3. Pull the salary-linked ones from your payslips each month. They already happen, so just record them.
  4. Enter each separate payment the day it is made, with a photo or PDF of the receipt.
  5. Add a total cell with a formula, for example =SUMIFS($D$2:$D$300,$C$2:$C$300,"Insurance") for one type, and a grand total with =SUM($D$2:$D$300).
  6. On the first of every month, compare the sheet to your bank statement so nothing is missing.
  7. In January, review the total with your CA, not in March.

What does a made-up year look like?

These figures are only an example. Salary deduction toward a provident fund: ₹3,600 a month, so 12 times 3,600 is ₹43,200. A PPF deposit of ₹30,000 once in April. A life insurance premium of ₹18,000 paid in July. A school tuition fee of ₹24,000 paid in two parts. Sum: 43,200 plus 30,000 plus 18,000 plus 24,000 is ₹1,15,200.

ItemTypeAmount in ₹
Provident fund deductionsSalary-linked43,200
PPF depositSavings account30,000
Life insurance premiumInsurance18,000
Tuition feeEducation24,000
Sheet totaln/a1,15,200

Whether each of those items counts, and up to what limit, is for your CA to confirm for the current year. Your sheet only shows what you paid.

What should I double-check?

  • Payments made late in March often do not show in the statement until a day or two later. Note the date on the receipt too.
  • A joint account payment may belong to one person's records. Mark who paid.
  • Premiums paid by employer or family can look like your spending. Mark them.
  • Refunds and reversals should be recorded as negative lines.

Can an expense tracker do this?

Partly. SpendixAI lets you create custom categories with tax-deductible settings, so statement rows for tax-saving payments can sit under a category such as Tax-saving payments, and a report or a CSV download shows the year. It imports PDF, CSV or Excel statements and you review the rows. It does not track investment values or compute tax, and it only knows what appears in the statements you upload, so payroll deductions you never see in a bank statement need a manual entry.

What do people usually miss?

Three things come up again and again in threads like this. First, payroll deductions that never touch your own bank statement, so a sheet built only from statements undercounts. Second, payments made for a spouse or parent, where the receipt is in someone else's name. Third, a premium paid annually in one month and forgotten for eleven. Put a recurring reminder for each annual payment in your calendar on the day you set up the sheet, and add a note beside each row saying when it is next due.

A quick monthly routine

  • Five minutes on the first of the month
  • Add anything missing, attach the receipt
  • Check the total against your running target
  • Write a note for anything unusual
SPENDIXAI JOURNAL

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

Explore your reports