All Major Indian Banks Supported
Our converter is tested and optimised for the PDF statement formats used by all major Indian banks. Both public sector and private sector bank formats are supported:
SBIState Bank of India — NetBanking & YONO app
HDFC BankNetBanking & Mobile Banking PDFs
ICICI BankInternet Banking & iMobile statements
Axis BankInternet Banking & Axis Mobile
Kotak BankNet Banking & Kotak Mobile App
PNBPunjab National Bank — all formats
Bank of BarodaBOB World & NetBanking PDFs
Canara BankInternet Banking statements
Union BankUnion Bank of India statements
Yes BankYES Mobile & NetBanking
IndusInd BankIndusMobile & NetBanking
IDFC First BankMobile Banking PDFs
Additional Banks Supported
Federal Bank, South Indian Bank, Karnataka Bank, Karur Vysya Bank, City Union Bank, Dhanlaxmi Bank, UCO Bank, Indian Overseas Bank, Central Bank of India, Bank of India, Bank of Maharashtra, Oriental Bank, Andhra Bank, Corporation Bank, Syndicate Bank, Vijaya Bank, Dena Bank and all other scheduled commercial banks and regional rural banks.
Password-Protected PDF Bank Statements
Most Indian bank statements downloaded from NetBanking are password-protected. Our converter handles all standard Indian bank PDF passwords:
- SBI — First 5 characters of account holder name (in CAPS) + Date of birth in DDMMYYYY format. Example: RAHUL + 15031985 = RAHUL15031985
- HDFC Bank — Customer ID (8-digit number found on your debit card or login page)
- ICICI Bank — First 4 characters of name in CAPS + DOB in DDMMYYYY. Example: PRIT05071990
- Axis Bank — Registered mobile number
- Kotak Mahindra Bank — Last 6 digits of account number
- PNB — Date of birth in DDMMYYYY format
- Bank of Baroda — Date of birth in DDMMYYYY format
- Canara Bank — Date of birth in DDMMYYYY format
Upload your password-protected PDF and our converter will prompt for the password. Passwords are used only for decryption and are never stored.
Use Cases for Indian Bank Statement Conversion
📋
Tally & Zoho Books Import
Convert bank statements to Excel or CSV and import into Tally Prime, Tally ERP 9 or Zoho Books for bank reconciliation.
🧾
ITR Filing
Structured transaction data for CA-assisted tax return preparation. Easily identify interest income, TDS credits and total deposits.
📚
CA Audit & Bookkeeping
CA firms convert client Indian bank statements for audit, bookkeeping and tax compliance. Works with all major Indian banks.
🏠
Loan Applications
Convert 3-12 months of bank statements for home loan, personal loan or business loan application income verification.
How to Convert an Indian Bank Statement
1
Download Statement
Download your bank statement PDF from NetBanking or mobile app
2
Upload & Convert
Upload the PDF — enter password if prompted, conversion in 2-5 seconds
3
Download Excel
Download Excel or CSV — ready for Tally, Zoho Books or analysis
Bank-Specific Converter Pages
For detailed instructions and bank-specific information, see our dedicated pages:
INR Currency Handling
Indian bank statements use the INR lakh/crore number format (1,00,000 for one lakh; 1,00,00,000 for one crore). Our converter correctly parses Indian number formatting and outputs plain numeric values suitable for arithmetic in Excel and accounting software. No manual reformatting of amounts is needed.
Tally and Zoho Books Import
Our Excel and CSV output is directly compatible with Indian accounting software:
- Tally Prime — Import via Bank Reconciliation or using Tally's Excel/CSV import utility. Standard Date/Description/Debit/Credit/Balance format is compatible.
- Tally ERP 9 — Compatible with ODBC import and third-party Tally import utilities.
- Zoho Books — Import via Banking > Import Statement. Upload CSV and map columns to Zoho's fields.
- QuickBooks India — Import via Banking > Upload Statement in CSV format.
Frequently Asked Questions
Which Indian banks are supported?
All major Indian banks are supported: SBI, HDFC, ICICI, Axis, Kotak, PNB, Bank of Baroda, Canara Bank, Union Bank, Yes Bank, IndusInd Bank, IDFC First Bank, Federal Bank and all other scheduled commercial banks. If your bank is not listed, upload your statement — automatic bank detection handles it.
What is the PDF password for my bank statement?
Common formats: SBI — first 5 letters of name (CAPS) + DOB in DDMMYYYY. HDFC — Customer ID. ICICI — first 4 letters of name (CAPS) + DOB in DDMMYYYY. Axis — registered mobile number. Kotak — last 6 digits of account number. PNB/BOB — DOB in DDMMYYYY. Passwords are never stored on our servers.
Can I import to Tally?
Yes. Download Excel or CSV and import into Tally Prime using the bank reconciliation import feature. The standard Date/Description/Debit/Credit/Balance format is compatible with Tally. Zoho Books CSV import is also supported.
Does it work with statements downloaded from mobile apps?
Yes. PDFs from SBI YONO, HDFC Mobile Banking, ICICI iMobile, Axis Mobile and all other Indian bank apps are fully supported. These are digital PDFs that process in 2-5 seconds.
Does it handle INR amounts correctly?
Yes. Indian lakh/crore number formatting (1,00,000) is correctly parsed and output as plain numeric values for use in Excel and accounting software. No manual reformatting needed.
Can I use this for ITR filing?
Yes. Structured transaction data in Excel makes it easier to calculate total credits, verify TDS, reconcile with Form 26AS and prepare information for income tax return filing.
What the Conversion Looks Like
Here is a real example of how raw PDF bank statement text is transformed into a clean, structured Excel file:
| Before → After Comparison |
|---|
| Raw PDF (what the bank gives you) | Clean Excel (what you get) |
|---|
| 01 Jun 2026 UPI/CR/466893467/Received from Rajesh Kumar/SBIN0003456 5,000.00 1,23,450.00 Cr |
Date: 2026-06-01
Description: Received from Rajesh Kumar [UPI: rajesh@sbi]
Credit: 5000.00 Balance: 123450.00 |
| 03 Jun 2026 NEFT/DR/SALARY/ACME CORP LTD/REF20260603001 Cr 85,000.00 2,08,450.00 |
Date: 2026-06-03
Description: SALARY/ACME CORP LTD / REF20260603001
Credit: 85000.00 Balance: 208450.00 |
| 07 Jun 2026 POS/AMAZON.IN/DEBIT Dr 3,299.00 2,05,151.00 |
Date: 2026-06-07
Description: POS / AMAZON.IN
Debit: 3299.00 Balance: 205151.00 |
Every column — Date, Description, Debit, Credit, Balance — is extracted and separated automatically. Dates standardised to YYYY-MM-DD. Currency symbols removed. Ready for Excel pivot tables, QuickBooks import, or Tally.