Union Bank supported

Union Bank of India Statement PDF
to Excel in 15 Seconds

Stop manually typing Union Bank transactions. Upload your Union Bank of India statement PDF and get a clean, formatted Excel file instantly — with all transactions, dates, and balances extracted automatically.

Convert Union Bank Statement Free →See pricing
30 free pages / month
No credit card needed
Every balance checked

What your Union Bank statement looks like in Excel

This is the file BankXL produces — ledgers assigned, debits and credits colour-coded, totals added, and every running balance checked against the statement.

XUnion_Bank_Statement_Apr_bankxl.xlsx
ABCDEFGHIJ
1Union Bank of India — Statement of Account
2RAJESH KUMAR  •  A/C: 30094417543  •  IFSC: UBIN0001234  •  Period: 01/04/2026 – 30/04/2026
3✓ Balance Proof — All 7 balance checks passed: every transaction adds up against the bank's own running balance. The closing balance matches the statement.
4#DateDescription / NarrationLedgerRef / Cheque NoTypeDebit (Dr)Credit (Cr)BalanceCheck
512026-04-01UPI/SWIGGY/FOOD ORDER/402918Staff Welfare402918UPI450.0049,550.00✓
622026-04-03NEFT/SALARY/ACME TECHNOLOGIES PVT LTDSalary ReceivedN093412NEFT82,000.00131,550.00✓
732026-04-05NEFT/RENT/R K PROPERTIESRentN094120NEFT25,000.00106,550.00✓
842026-04-07NACH/HDFC LIFE INSURANCE PREMIUMInsuranceNACH0071NACH/ECS3,200.00103,350.00✓
952026-04-10UPI/BESCOM/ELECTRICITY BILL/561203Electricity Charges561203UPI1,845.50101,504.50✓
1062026-04-12IMPS/PROFESSIONAL FEE/SHARMA AND COBank TransfersIMPS8821IMPS15,000.00116,504.50✓
11
12TOTAL — 6 transactions30,495.5097,000.00
Balance Proof: 7 of 7 checks passedOpening ₹50,000.00 → Closing ₹116,504.50

Union Bank statement password

Union Bank statement PDFs are usually locked with first 4 letters of your name in CAPITALS (initials count), then date and month of birth as DDMM — for example RAHU0106. See every format and work out yours →
You don't need to unlock it first: upload the locked PDF and enter the password when BankXL asks. It is used once to open the file and never stored.

How to convert Union Bank of India statement to Excel

STEP 01
Download your Union Bank statement from internet banking or Vyom app
STEP 02
Upload the PDF to BankXL
STEP 03
Get your Excel in 15 seconds

Supported Union Bank of India statement types

Union Bank Vyom app statements
Union Bank internet banking statements
Union Bank passbook PDFs
Union Bank NRI statements
Post-merger e-Andhra & e-Corporation account formats

Output formats for Union Bank statements

📊
Excel (.xlsx) with color-coded debits/credits
Best for Excel / accounting
📄
CSV for accounting software
Import into any tool
🔧
JSON for developers
For developers / APIs
📁
Tally XML for direct import
Direct Tally import
Deep-dive by format:Union Bank → Excel guide·Union Bank → Tally XML·Union Bank → CSV

Frequently asked about Union Bank statement conversion

How do I download my Union Bank statement?+

Log into Union Bank internet banking → Accounts → Statement → select period → Download PDF. Or use the Vyom app → Statement → Download.

Does BankXL support post-merger Union Bank formats?+

Yes. Statements from ex-Andhra Bank and ex-Corporation Bank accounts (now under Union Bank of India after the 2020 merger) work fine.

Can I convert Union Bank statements for Tally import?+

Yes — export as Tally XML and use Ctrl+I in Tally Prime / ERP 9. Receipts and payments land as proper vouchers.

Convert your Union Bank statement now

Free 30 pages every month. No credit card required. Works with all Union Bank of India account types.

Convert Free →See all supported banks

Also convert statements from:

SBIHDFCICICIAxisKotakPNBCanaraBoB

Built for how you actually use it:

For Chartered AccountantsBank Reconciliation GuideExport to Tally XMLTally Ledgers Assigned AutomaticallyTDS & Duplicate Payment ChecksBankXL vs NanonetsTally Prime Import Guide