Tax and GST

80c deduction list: how to keep the paperwork organised through the year

An 80c deduction list is only as good as your records: here is how to track documents, amounts and dates month by month, and what to confirm with your CA.

Editorial illustration for 80c deduction list: how to keep the paperwork organised through the year

An 80c deduction list is easiest to prepare when you keep one running sheet all year, with a row for every payment you might need to show and a folder for each proof. This article covers the records and habits only. Which items qualify, and up to what amount, is decided by current law and your own situation, so confirm that with your CA or the official income tax source.

Why start with records, not the list?

Many people open the list in March, then hunt through emails and passbooks for proofs. By then, premium receipts are in old messages, fee receipts are in a school bag and one payment was made from a family member's account. The list matters less than the habit of filing the paper when the payment happens.

What should one row in your tracker contain?

  • Date of payment
  • Name of the institution or provider
  • Type of payment, in your own words
  • Amount paid
  • Whose name the policy, account or receipt is in
  • Mode of payment, such as UPI, cheque or auto-debit
  • Where the proof is stored
  • Whether your CA has confirmed it belongs on the list

A worked example with made-up numbers

Say these are payments you are unsure about, all hypothetical:

DateItemAmount (₹)Proof savedCA confirmed?
12 AprInsurance premium24,000YesPending
5 JulTuition fee instalment18,500YesPending
15 SepRecurring deposit instalment30,000StatementPending
20 NovAnother premium9,500NoPending

The tracker total is 24,000 + 18,500 + 30,000 + 9,500 = ₹82,000. Two things stand out: one row has no proof saved, and every row is still waiting for your CA. That is exactly what you want to discover in November, not on the last day of March. Your CA may well tell you some rows do not belong at all, which is useful to know early.

A formula for a running total in Excel or Google Sheets

Put amounts in column C from row 2 to row 200, and put your CA's answer in column E as the word Yes. To add up only the confirmed rows, use:

=SUMIFS($C$2:$C$200, $E$2:$E$200, "Yes")

To add up everything entered so far, use =SUM($C$2:$C$200). The difference between the two is the amount still waiting for confirmation.

How do you keep proofs findable?

  1. Make one folder per financial year, April to March.
  2. Name each file with the date and the provider, for example 2026-04-12-premium.pdf.
  3. Save statements and receipts the day they arrive.
  4. Photograph paper receipts straight away and keep the paper too.
  5. Keep a copy off your phone, for example in a cloud folder you control.

When a sheet stops being enough

If you are tired of retyping, SpendixAI can take bank or card statements as PDF, CSV or Excel, let you review rows before saving, and keep receipts with their transactions, so the payment and its proof sit together. You can also create custom categories and download a report as CSV for your CA. It estimates figures for you but does not compute tax or file anything, so treat anything it shows as a starting point.

A quarterly habit

  • April and every quarter: add new payments to the sheet
  • Check that each has a proof saved
  • Send the sheet to your CA once a quarter for a quick view
  • In February, look for gaps and ask what is still open
SPENDIXAI JOURNAL

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

Explore your reports