Bank Statements for ITR Filing
An income tax return is largely a reconciliation exercise: the interest, receipts and payments your accounts recorded across the financial year, set against what has already been reported on your behalf. Doing that from a pile of PDFs in the last week before a deadline is where most of the pain comes from. Here is what to pull, in what order, and the one file problem that stops the whole job before it starts.
1. Work out which months you actually need
The financial year runs 1 April to 31 March, so FY 2025-26 covers 1 April 2025 to 31 March 2026 and is assessed as AY 2026-27. You need that window on every account you held during it, not just the one your salary lands in: the account you opened in January, the joint account you barely touch, and the one you closed in August all sit inside the year.
The closed account is the one people forget, and it is also the hardest to retrieve once net banking access is gone, so pull it first. If a bank issues statements on a cycle that does not end on 31 March, the first and last files in the set each straddle the year boundary and need splitting once they are in a spreadsheet.
2. Unlock the PDF before anything can read it
Statement PDFs from Indian banks usually arrive encrypted, with a password built from something like part of a PAN and a date of birth. An encrypted file cannot be parsed at all: StatementSheet reports that it could not read the PDF rather than returning a half-read table. Open it in any PDF reader with the password, use that reader's print or export option to save an unprotected copy, and convert the copy.
Keep the unprotected copy somewhere private and delete it when the return is filed. It is a complete financial record with the lock taken off, which is exactly why the bank put the lock on in the first place.
3. Interest is the number worth checking twice
A savings account is usually credited with interest quarterly, so a full year is four entries per account rather than one, and a fixed deposit may pay on its own schedule or only at maturity. Meanwhile the Annual Information Statement already carries an interest figure the bank reported, and a return is often prefilled from it.
Treat both as claims and compare them. A gap between the two is usually one of three things: a deposit at a branch or a bank you had forgotten, a joint account reported in full against a single holder, or interest credited a few days after 31 March and therefore belonging to the next year. Whether savings interest attracts a deduction at all depends on the regime you file under, and the deductions people remember are old-regime ones, so confirm which regime your return is actually on before planning around them.
4. What else a statement is evidence for
- Business or professional receipts, if you file with a profit and loss rather than a salary certificate. Bank credits are the backbone of that schedule.
- Rent paid or received by transfer, where a standing instruction gives you twelve dated entries instead of a bundle of receipts.
- Large or unusual movements that also appear in the Annual Information Statement. An unexplained credit is a common trigger for a query, and the fastest answer is the account history that explains it.
- Money sent abroad or received from abroad, which carries reporting of its own and is easiest to total from the account rather than from memory.
- Advance tax and self-assessment payments you actually made, including the one you are not sure went through.
5. The dates, with the usual caveat
For AY 2026-27 the ordinary due date for an individual who does not need an audit was 31 July 2026, and a belated or revised return generally runs to 31 December 2026. Audit cases sit on a later date. These move more years than not, so check the department's current notification rather than this page before you plan around a date. What does not move is the work: the statement set is the same whether you file in July or in December, and it is far cheaper to assemble in September.
6. Turn the PDFs into one sheet, once
No Indian bank has a parser tuned to its exact layout here, so those statements are read by the generic geometry parser, which finds the header row and rebuilds the columns from whatever layout it meets. That works on most well-formed statements and is worth checking rather than assuming: convert the file, then read the reconciliation badge before you rely on the totals. Where the checks could not be completed the badge says so instead of going green.
One workbook per account per year, with a month column added, is enough to total interest, to answer a question three years from now without reopening a PDF, and to hand an accountant something they can work from. If the columns need tidying afterwards, the Excel cleanup guide covers the usual problems: amounts stored as text, ambiguous dates, and duplicate rows from overlapping exports.
Convert your statement first
Drop a PDF statement on the converter and download a structured .xlsx or CSV. Digital PDFs are parsed in your browser and never uploaded; a scan is read by on-device OCR, and an unreadable page goes to cloud OCR only if you explicitly approve it.
See all supported banks → · Convert a statement now →
Filing somewhere else this season? See bank statements for UK Self Assessment and bank statements for a US tax return.