Business

Annual Expense Report for Tax Filing in India: Prepare It in One Day

A salaried metro employee's one-day plan to assemble an annual expense report for tax filing from bank statements, receipts and a simple category sheet.

Editorial illustration for Annual Expense Report for Tax Filing in India: Prepare It in One Day

You can assemble an annual expense report in a day if you work in a fixed order: collect twelve months of statements, sort every row into a handful of categories, total each one, and put the supporting receipts next to the totals. The report is a set of records for you and your CA; it does not decide what is taxable or claimable.

What the report is for, and what it is not

A salaried person in a metro city usually has one salary credit a month and a long list of outgoings: rent, a home loan EMI, school fees, insurance premiums, electricity and gas, domestic help, travel. Your CA or the filing portal will ask about a few of these. The report puts them in one place so that you are not hunting through six months of messages on the last weekend before the deadline.

Rules and limits change every year, so confirm which items matter for you with your CA or the official source. Your job is only to have clean figures and papers ready.

A day, hour by hour

TimeTaskOutput
Hour 1Download April to March statements for each bank account and card12 months of files per account
Hour 2Put every row into one sheet or import the statements into a trackerOne list of all transactions
Hours 3-4Tag each row with a categoryCategory column filled
Hour 5Total each category and each monthSummary table
Hour 6Match receipts and certificates to the categories that need themOne folder per category
Hour 7Check totals against salary credits and statement balancesReconciled sheet
Hour 8Write a one-page note for your CA: what is attached, what is missingHand-over pack

A worked example for a salaried year

Say your monthly take-home is ₹1,05,000. Over twelve months that is ₹12,60,000. Your sheet shows rent of ₹30,000 a month, so ₹3,60,000 for the year, a home loan EMI of ₹24,000 a month, so ₹2,88,000, and school fees of ₹1,20,000 paid in three instalments of ₹40,000.

Add those three: 3,60,000 plus 2,88,000 plus 1,20,000 equals ₹7,68,000. If total spending for the year is ₹9,90,000, the remaining ₹2,22,000 is everything else, and the gap between income of ₹12,60,000 and spending of ₹9,90,000 is ₹2,70,000. If that gap does not roughly match what moved into savings accounts and investments, something is missing from your list.

Which receipts do I need to keep with the report?

Keep the papers that a CA is likely to ask about: rent receipts or the rental agreement, premium receipts for insurance, the home loan interest and principal certificate your lender issues, school fee receipts, and donation receipts. Which of them affect your return is a question for your CA, so ask early and keep all of them anyway.

How do I check the numbers are right?

  1. Add the category totals; they must equal total spending.
  2. Add the monthly totals; they must equal the same figure.
  3. Compare salary credits across the year with your salary slips.
  4. Spot-check three large entries against the statement.
  5. Look for two same-amount payments to the same merchant a day or two apart, which may be a double entry.

The hand-over pack

Put the pack in a folder named with the financial year, for example FY 2025-26. Inside, keep the summary sheet, the full transaction list, and subfolders for receipts and certificates. Add a short note saying which months were covered, which accounts were included and anything you could not find. A CA reading that note saves you an hour of questions.

Next year, avoid the scramble by spending twenty minutes at the end of each month adding the new rows and checking the totals. A year then becomes twelve small checks.

SPENDIXAI JOURNAL

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

Explore your reports