Bank Statement for Income Tax Return (India) — Convert PDF to Excel

Why the statement matters for your ITR

The income tax department sees a lot of your financial year through the Annual Information Statement and Form 26AS — including interest income where TDS was deducted. Your return has to be consistent with that. So at filing time you need to know, from your own records:

• Total interest earned, across savings and any deposits, to report under income from other sources.
• Business or professional receipts, if you run a proprietorship or profession — the UPI and NEFT credits that make up your turnover.
• Anything unusual, like a large deposit, that you may need to explain.

All of that lives in the bank statement, and the financial year runs April to March, so it's usually several months of PDFs to pull together.

From a locked PDF to a usable spreadsheet

1. Download the e-statement for the financial year from net banking — SBI, HDFC, ICICI, Axis, Kotak and the rest issue it as a password-protected PDF.
2. Open it with the password the bank sets, then convert it. Every transaction comes back as a row — date, value date, narration, reference, withdrawal, deposit and balance.
3. Filter the interest credits. The bank's interest postings sit on their own lines; sort and total them for the interest figure on your return.
4. Total your receipts, if you're in business — filter the UPI and NEFT credits that are sales, and total them for turnover.

Because the narration is kept whole on each row, a UPI payment stays identifiable — you can see who paid and match it against an invoice or a 26AS entry.

What the converter handles that a copy-paste won't

An Indian statement is mostly narration: a single UPI line reads like a long string of the payee's handle, the bank and a reference, and it wraps across lines. Paste that into a spreadsheet and one payment breaks into two rows, and hundreds of UPI entries become an unreadable mess. The converter keeps the whole narration on one line with its reference and value date beside it, so a year heavy with UPI activity comes out as clean, searchable rows.

It also reconciles the balance before you download — opening, plus deposits, minus withdrawals, has to reach the closing figure — so a line dropped between pages is caught before it distorts your interest total or turnover.

Straight into Tally for your accountant

If a CA prepares your return, or you keep books in Tally, you can export a Tally-ready XML instead of a spreadsheet. A year of UPI, NEFT and interest entries then imports as vouchers your accountant can post directly, rather than keying a month at a time. That's usually the difference between a same-day reconciliation and a long one.

Common pitfalls to avoid

• Missing interest. Savings interest is small per posting but adds up over a year, and it's taxable — total it rather than skipping it.
• Value date vs transaction date. Both matter when a cheque clears a day late; the converter keeps both so year-end cut-off is accurate.
• Password confusion. The e-statement opens with the password the bank shows on the download page; open it first, then convert the opened file.
• Multiple accounts. If income runs through more than one account, convert each — the department can see them all.