Union Bank of India Statement to Excel or CSV
Union Bank of India lets you choose the file format when you download a statement from internet banking; its manual lists PDF, XLS and Text. The PDF tends to be the version that gets saved, emailed and attached to loan files, and later it's the only copy left. Upload it here to rebuild the transaction table, with dates normalised and withdrawals shown as negative amounts.
Page 1 free, no sign-up to see it; just an email to download. The whole document is one payment: $9 up to 25 pages, priced by page count above that. No subscription.
Several statements? Drop up to 100 at once: one payment for all of them, priced by their total pages.
98% of numbers correct on 82 hand-checked pages How we measure
How to get your Union Bank of India statement into Excel
-
Download the PDF statement from Union Bank of India online banking
- Log in to Union Bank of India internet banking (the mobile app, formerly VYOM, is now Union ease).
- Open 'Accounts' > 'Balance & Transaction Info' > 'Operative Accounts', then use the 'Actions' link on the account row and choose 'Account Statement'.
- Set 'Date From' and 'Date to' (or a fixed period such as the last 1 month), select Search, then pick a format in the 'select download format' box and press 'Go'.
- Save the statement for the period you need as a PDF.
-
Upload it here
Scans and phone photos work too.
-
Download Excel, CSV, or QuickBooks and Xero CSV
Check the rows against the statement, then export.
Sample result
Your Union Bank of India statement in Excel
Made-up sample rows, not a real statement.
| Date | Description | Debit | Credit | Balance |
|---|---|---|---|---|
| 2026-01-02 Salary - Example Employer Ltd | Salary - Example Employer Ltd | 2,500.00 | 3,500.00 | |
| 2026-01-05 Card payment - Sample Grocery Co | Card payment - Sample Grocery Co | 120.00 | 3,380.00 | |
| 2026-01-09 Rent - Placeholder Properties | Rent - Placeholder Properties | 1,200.00 | 2,180.00 | |
| 2026-01-14 Transfer from savings | Transfer from savings | 300.00 | 2,480.00 | |
| 2026-01-20 Utility bill - Demo Energy Co | Utility bill - Demo Energy Co | 80.00 | 2,400.00 | |
| 2026-01-27 Card payment - Fictional Coffee Co | Card payment - Fictional Coffee Co | 15.00 | 2,385.00 |
Statement notes
What to know about Union Bank of India statements
Format chosen at download
The bank's internet banking manual, from 2022, describes a 'select download format' box on the statement screen. If you still have access and need recent months, XLS is the shortest route. For statements already saved as PDF, conversion gets you the same rows without logging in again.
Loan statements come in yearly pieces
For loan accounts the manual limits a statement search to 366 days. A five-year loan history therefore arrives as five or more PDFs. Convert each one; the period check confirms the pieces meet without overlap, and each file's balances are verified on their own.
dd/MM/yyyy in, YYYY-MM-DD out
Union Bank's date fields take dd/MM/yyyy, and the statements print dates day first. Output dates are written YYYY-MM-DD, so 05/06/2026 can't turn into May 6 when someone opens the file on a laptop set to American formats.
Combined statement or one account
The same manual shows a Combined Statement option next to the per-account statement. For reconciliation, a single-account statement is easier: one opening balance, one closing balance, and a running-balance check that means something. Keep the combined PDF for an overview.
Output and review
From Union Bank of India PDF to your books
Accounting tip
TallyPrime lists Union Bank of India for Excel statement imports, meaning the XLS you download from the bank. A converted PDF can't go through that importer; use it for manual reconciliation instead, ticking off vouchers and entering the bank date for each.
-
Checked before export
Opening balance plus transactions is checked against the closing balance. Duplicate or missing periods are flagged.
-
Export formats
Excel, CSV, JSON, or QuickBooks and Xero CSV.
-
Private workspace
HTTPS uploads, kept private until you ask support to delete them.
FAQ
Union Bank of India statement questions
Is VYOM the same app as Union ease?
Should I download the PDF or the XLS?
Can I import converted Union Bank of India rows into QuickBooks or Xero?
Convert your Union Bank of India statement to Excel
Page 1 free, no sign-up to see it; just an email to download.
More Bank Statement Converters
pdf2text is independent and not affiliated with or endorsed by Union Bank of India.