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.

See pricing

98% of numbers correct on 82 hand-checked pages How we measure

How to get your Union Bank of India statement into Excel

  1. 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.
    Go to Union Bank of India Online Banking
  2. Upload it here

    Scans and phone photos work too.

  3. 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.

sample-statement-2026-01.xlsx Jan 2026 · INR
Sample bank statement rows with made-up data, amounts in INR
Date Debit Credit Balance
2026-01-02 Salary - Example Employer Ltd 2,500.00 3,500.00
2026-01-05 Card payment - Sample Grocery Co 120.00 3,380.00
2026-01-09 Rent - Placeholder Properties 1,200.00 2,180.00
2026-01-14 Transfer from savings 300.00 2,480.00
2026-01-20 Utility bill - Demo Energy Co 80.00 2,400.00
2026-01-27 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.

    Files for QuickBooks Online

    Files for Xero

  • 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?
Yes. Union Bank of India's mobile app, previously called VYOM, is now Union ease. Any statement PDF you saved from it, under either name, converts here the same way as one downloaded from internet banking.
Should I download the PDF or the XLS?
For your own reconciliation, XLS saves a step. For anything you'll submit, archive or share, the PDF is the better record. Many people keep both: the PDF as the document, and either the bank's XLS or a conversion of the PDF as the working file.
Can I import converted Union Bank of India rows into QuickBooks or Xero?
Yes. Review the rows, then export a QuickBooks or Xero CSV.

Convert your Union Bank of India statement to Excel

Page 1 free, no sign-up to see it; just an email to download.

pdf2text is independent and not affiliated with or endorsed by Union Bank of India.