Indian Bank statement analyser: Excel in, ITR-ready report out
Indian Bank statements are a classic public-sector export: terse, upper-case narrations that often abbreviate or truncate the party name, and, since the amalgamation of Allahabad Bank in 2020, layouts that can vary between accounts that all read Indian Bank at the top. In most versions the download labelled Excel is a text or HTML table underneath rather than a true .xls. Greenote Lite is built for exactly this: it reads those files directly, pulls the party out of whatever the narration actually contains, and marks the rest honestly instead of guessing.
Works with Excel and CSV statements from netbanking. Got a PDF? That is coming to the full Greenote desktop app.
How to export your Indian Bank statement as Excel or CSV
- 1Log in to Indian Bank NetBanking, or the IndOASIS mobile app, and open the account statement view. In most versions it sits under the Accounts or Enquiry menu.
- 2Select the account and the date range for the period under audit. Older portals sometimes cap a single download, so a full financial year may need two or three files.
- 3Download the Excel or CSV version rather than PDF. If the saved file shows a format warning when you open it, that is normal for these exports.
- 4Upload the file exactly as downloaded. There is no cleanup needed, and no need to re-save it as a proper Excel file first.
Menu names shift between netbanking versions, so treat the steps above as a guide — the constant is the format: take the Excel, XLS or CSV download, not the PDF. Greenote Lite does not read PDF statements; the full Greenote desktop app does, and is available now.
What Greenote Lite does with an Indian Bank statement
Indian Bank exports test a parser on two fronts, file format and terse text, and the engine handles both:
- The download labelled Excel is often a text or HTML table wearing an .xls extension. The engine detects and reads these directly, so the file-format warning your spreadsheet app shows does not mean the file is corrupt.
- All-caps, abbreviated narrations are parsed for mode keywords (UPI, NEFT, IMPS, TRF) and whatever party fragment survives. Truncated names are matched conservatively, so two different parties are never merged into one.
- UPI, NEFT and IMPS rows are read for the counterparty: UPI narrations give up a name and VPA between their slash segments, transfer rows have their IFSC and reference numbers stripped, and repeat payments to the same merchant roll up as one party with one total in the ledger.
- Direction is taken from the debit and credit columns, not from words in the narration, so a terse or mislabelled row can never flip a payment into a receipt. Where an export uses a single amount column with a separate Dr/Cr type, that layout is read too.
- Accounts migrated from ex-Allahabad Bank branches can export slightly different, legacy-looking layouts. The table detector maps their columns automatically rather than expecting one fixed template.
The download is a four-sheet Excel workbook: a party ledger of who paid whom, every transaction categorised and named, a category summary, and an ITR summary with AIS/SFT flags. See why the party ledger comes first or the full statement-to-ITR workflow.
Indian Bank statement questions
Typically yes. After the 2020 amalgamation of Allahabad Bank, Indian Bank accounts can export slightly different legacy layouts depending on the branch's origin. The engine detects the transaction table and what each column means rather than expecting one fixed template, and the contact form reaches a real person if a file resists.
No. Indian Bank's NetBanking and the IndOASIS app often hand you a text or HTML table under an .xls name, which is why your spreadsheet warns about it. Greenote Lite reads that table directly, so upload it as downloaded without converting it first.
Where enough of the name survives, yes, and repeat payments to that party roll into one line. A fragment too ambiguous to place is left in Suspense/Unknown instead of being attached to the wrong party, so nothing is invented.
The IndOASIS Excel or CSV export works and is auto-detected. The PDF is not usable here; Greenote Lite reads Excel and CSV only, and PDF statements are handled by the separate Greenote desktop app.
Try it on a real Indian Bank statement
Your first statement is free — the trial processes the first 300 transactions so you can judge the quality end to end. Verify your email with a one-time code (no password, no card), and the file is deleted the moment your report is ready.