Convert Union Bank of India Bank Statement to Excel
Union Bank’s statement layout is distinctive: Date, Tran Id, Remarks, UTR Number, Instr. ID, Withdrawals, Deposits and Balance — and notably no Value Date column at all, which trips up people expecting the usual dual-date format. The UTR Number field is gold for tracing NEFT and RTGS transfers, but it sits buried between Remarks and Instr. ID, and manual transcription tends to drop or misplace those long references. Meanwhile Remarks holds the UPI story in yet another bank-specific dialect. Keying hundreds of ₹ movements plus their Tran Ids and UTRs by hand practically guarantees a mismatch somewhere. SheetMyBank reads Union Bank’s exact column set and emits each identifier into its own labelled Excel column, transcription-error-free.
The Vyom app — being rebranded as Union ease — offers Account → Statement, where you select Last month, 3, 6 or 12 months, a financial year or a custom span, then PDF Download or Email Statement, a path the bank has confirmed publicly. Net banking users take Accounts → Account Summary → View Statement, with PDF, CSV and Excel choices. SheetMyBank converts the PDF using device-local parsing only; your data stays in the browser sandbox. The Balance column is then traced end to end, flagging any row that breaks the running total.
Drop your Union Bank of India statement here (PDF or photo)
Processed entirely on this device — nothing is uploaded. Scans and photos are read with on-device OCR (beta).
Free for your first 5 pages each month · Processed on your device · Balance-verified output
Union Bank of India statement FAQ
What is the Union Bank e-statement PDF password?
Four independent sources agree: the first four letters of your name in capital letters followed by your date and month of birth as DDMM — for example, Rahul born 1 June would use RAHU0106. If your name has fewer than four letters, the email from the bank explains the adjustment.
Why is there no Value Date in my Union Bank statement?
Union Bank’s standard statement simply omits it — the layout runs Date, Tran Id, Remarks, UTR Number, Instr. ID, Withdrawals, Deposits and Balance with a single date per row. If your accounting workflow requires value dating, note this before choosing Union Bank exports for interest reconciliation.
Can SheetMyBank keep the UTR Number as a searchable column?
Yes. UTR references from the statement land in a dedicated Excel column rather than being fused into the remarks text, so you can VLOOKUP a counterparty’s quoted UTR directly. Long numeric UTRs are exported as text to stop Excel from mangling them into scientific notation.