Union Bank of India statement analyser: Excel in, ITR-ready report out
Union Bank of India has the quirk that breaks the most spreadsheets: in some exports the amount and its direction are fused into a single cell — 1,00,000.00 (Dr) — instead of separate debit and credit columns. Greenote Lite parses the Indian digit grouping and the (Dr)/(Cr) suffix in one pass, alongside the slash-delimited remarks Union's UPI rows typically carry.
How to export your Union Bank of India statement as Excel or CSV
- 1Log in to Union Bank netbanking (or the Vyom app) and open the account statement.
- 2Select the account and the period under audit.
- 3Download the Excel or CSV statement; the portal typically offers these next to PDF.
- 4Upload directly — fused amount-with-(Dr)/(Cr) cells are expected and parsed.
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 (coming soon) will.
What Greenote Lite does with a Union Bank statement
Union's format needs numeric care as much as text care:
- Amount cells carrying a (Dr) or (Cr) suffix are split into value and direction automatically — no find-and-replace surgery in Excel first.
- Indian digit grouping (1,00,000.00) is parsed natively, so lakhs and crores never get mangled into the wrong magnitude.
- UPI remarks in the UPI/CR/reference/party/bank/VPA shape are slash-split; the party and VPA feed the ledger, the reference is dropped.
- Post-merger accounts from ex-Andhra Bank and ex-Corporation Bank branches occasionally export older layouts; column detection covers them.
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.
Union Bank statement questions
Yes — this fused layout is exactly what the parser expects from Union Bank. The value and the Dr/Cr direction are separated automatically and land in the right debit or credit column of the report.
Typically yes, as long as you export Excel or CSV rather than PDF. The app and netbanking exports can differ slightly in layout; both are detected automatically.
Those rows carried no readable counterparty in the remark — often terse charge or reversal entries. The engine marks them Suspense/Unknown instead of guessing, so your ledger stays trustworthy.
Try it on a real Union Bank statement
Your first statement is free — the trial processes the first 50 transactions so you can judge the quality end to end. No card, no signup wall, and the file is deleted the moment your report is ready.