How to Convert Union Bank of India Statement to Excel — 3 Steps
1
Download from Union Bank Internet Banking
Log in to unionbank.online or the Union Mobile app, navigate to Account Statement, and download your PDF
2
Upload & Convert
Upload the PDF — enter your DOB (DDMMYYYY) as the password if prompted
3
Download Excel or CSV
Get a clean .xlsx or .csv with Date, Narration, Cheque/Ref No., Value Date, Withdrawal, Deposit, and Balance
How to Download Your Union Bank of India Statement PDF
Via Union Bank Internet Banking (unionbank.online)
- Visit unionbank.online and click Personal Banking Login
- Enter your Customer ID and Password
- Go to Accounts → Account Statement
- Select your account, set the From Date and To Date (up to 12 months)
- Choose PDF format and click Download
- Password: typically your Date of Birth in DDMMYYYY format
Via Union Mobile App
- Open the Union Mobile app (available on Android and iOS)
- Log in with your Customer ID and MPIN
- Tap Accounts → select your account → Account Statement
- Set the date range and tap Download PDF
- The statement is saved to your phone's Downloads folder
Via Branch Visit
Visit any Union Bank of India branch with your passbook or account details and request a printed statement. Branch staff can also provide a certified (bank-stamped) statement for official purposes such as loan applications or court submissions.
Union Bank of India Statement PDF Password
- Primary password: Your Date of Birth in DDMMYYYY format — e.g., 12 August 1985 → 12081985
- Alternative: Your Customer ID (the same ID you use to log in to internet banking)
- Erstwhile Andhra Bank accounts: If your account was migrated from Andhra Bank, try your DOB first. Some migrated accounts may use the first 6 digits of the account number.
- NRI accounts: Try your DOB in DDMMYYYY. If that fails, contact Union Bank NRI services on 1800-22-2244 (toll-free).
About Union Bank of India
Union Bank of India is one of India's largest government-owned public sector banks, established in 1919 and headquartered in Mumbai. As of 2025, it is the fifth largest public sector bank in India by business volume. Union Bank is listed on both the NSE and BSE (ticker: UNIONBANK) and is regulated by the Reserve Bank of India (RBI).
On 1 April 2020, Union Bank of India merged with Andhra Bank and Corporation Bank as part of the Government of India's banking consolidation programme. This made Union Bank the 5th largest public sector bank with over 9,500 branches, 12,000+ ATMs, and more than 120 million customer accounts across India. Customers of Andhra Bank (strong in Andhra Pradesh and Telangana) and Corporation Bank (strong in Karnataka) had their accounts seamlessly migrated to Union Bank's systems.
Union Bank offers the full range of banking products: savings and current accounts, fixed deposits, personal loans, home loans (Union Home), vehicle loans, education loans (Union Education), and a range of government scheme accounts (PM Jan Dhan, PM Mudra, Sukanya Samridhi). All Union Bank accounts produce statement PDFs that are accepted by all Indian government institutions, RBI-regulated lenders, and major embassies worldwide.
Supported Account Types
- Savings Accounts — Union Classic, Union Premium, Union Senior Citizens', Union Mahila Bachat, Basic Savings Bank Deposit (BSBD)
- Current Accounts — Union Current Classic, Union Current Premium, Union Current Trade accounts
- Salary Accounts — Union Salary accounts for salaried employees, defence personnel, and government staff
- NRI Accounts — NRE Savings, NRO Savings, FCNR deposits for Non-Resident Indians
- Government Scheme Accounts — PM Jan Dhan Yojana (PMJDY), Pradhan Mantri Mudra Yojana (PMMY), Atal Pension Yojana (APY)
- Erstwhile Andhra Bank accounts (Andhra Pradesh, Telangana, other states)
- Erstwhile Corporation Bank accounts (Karnataka, other states)
What the Conversion Looks Like — Before & After
| Before → After Comparison |
|---|
| Raw PDF (Union Bank of India) |
Clean Excel Output |
| 01 Jun 2026 NEFT CR/SALARY/BHARAT HEAVY ELECTRICALS/UTR26060100431 78,000.00 1,43,210.00 |
Date: 2026-06-01
Narration: NEFT CR — SALARY / BHARAT HEAVY ELECTRICALS
Deposit: ₹78,000.00 Balance: ₹1,43,210.00 |
| 05 Jun 2026 UPI/DR/9876543210/Ramesh Stores/upi-ref-44512 2,800.00 1,40,410.00 |
Date: 2026-06-05
Narration: UPI DR — Ramesh Stores / 9876543210
Withdrawal: ₹2,800.00 Balance: ₹1,40,410.00 |
| 10 Jun 2026 ATM/WDL/UNION BANK ATM ANDHERI MUMBAI 15,000.00 1,25,410.00 |
Date: 2026-06-10
Narration: ATM WDL — UNION BANK ATM ANDHERI MUMBAI
Withdrawal: ₹15,000.00 Balance: ₹1,25,410.00 |
Why People Convert Union Bank Statements to Excel
📊 ITR Filing and CA Audit
During ITR season, Chartered Accountants need Union Bank statements in Excel to reconcile salary credits, identify TDS deductions, and compute interest income. Converting your statement to Excel eliminates manual entry and allows quick categorisation using SUMIF formulas.
🏠 Home Loan and Personal Loan Applications
Union Bank is one of India's top home loan lenders. For Union Home, SBI Home Finance, LIC Housing Finance, or any other lender, 6 months of salary account statements are required. The Excel output from our converter is compatible with lender-required formats and can be submitted alongside the original PDFs.
📋 Tally and Accounting Software Import
Union Bank statement Excel files can be imported directly into Tally ERP, Tally Prime, QuickBooks, and Busy Accounting. Map columns: Date → Date, Narration → Particulars, Withdrawal → Debit, Deposit → Credit, Balance → Closing Balance.
🌍 Visa Applications
Union Bank is a government-owned nationalised bank accepted by all major embassies for US B1/B2, UK, Schengen, and other visa financial evidence requirements. Submit the original PDF — use Excel for your own verification before the visa interview.
Frequently Asked Questions
How do I download Union Bank of India statement PDF?
Via unionbank.online: Login → Accounts → Account Statement → set date range → Download PDF. Via Union Mobile app: Login → Accounts → select account → Account Statement → Download PDF. You can also request a printed statement from any Union Bank branch.
What is the password for Union Bank of India statement PDF?
Most Union Bank statement PDFs use your Date of Birth in DDMMYYYY format (e.g., 12 August 1985 = 12081985). If that fails, try your Customer ID. For erstwhile Andhra Bank migrated accounts, try the first 6 digits of your account number.
Does Union Bank statement work for erstwhile Andhra Bank accounts?
Yes. All Andhra Bank and Corporation Bank accounts were merged into Union Bank of India on 1 April 2020. Statements for these migrated accounts are now issued under the Union Bank format and are fully supported by our converter.
Can I use Union Bank statement for home loan?
Yes. Union Bank is an RBI-regulated nationalised bank and its statements are accepted by all major lenders for home loan, personal loan, and vehicle loan applications. Lenders typically require 6 months of salary account statements.
How to import Union Bank statement into Tally?
Convert your Union Bank PDF to Excel using our free tool. In Tally ERP or Tally Prime, go to Banking → Bank Statement Import, select your bank ledger, import the Excel file, map columns (Date, Particulars, Debit, Credit, Balance), and complete the import.
Is Union Bank statement accepted for Schengen visa?
Yes. Union Bank is a government-owned nationalised bank widely accepted by all major embassies. Submit 3 to 6 months of original signed PDFs for visa applications. The Excel conversion is for your personal reference only.
What is the IFSC code for Union Bank of India?
Union Bank IFSC codes start with UBIN followed by 7 digits (e.g., UBIN0531561). For migrated Andhra Bank branches, old ANDB IFSC codes have been updated to UBIN codes. Check your latest Union Bank statement header for the correct IFSC.
How accurate is the Union Bank statement conversion?
For digital PDFs from unionbank.online or Union Mobile, accuracy is 99%+. All columns — Date, Narration, Ref No., Value Date, Withdrawal, Deposit, and Balance — are extracted faithfully. Verify against the original PDF for tax or loan submissions.
Ready to Convert Your Union Bank of India Statement?
100% free · No signup · Password-protected PDFs supported · Instant download
Convert Now — It's Free →