How to Convert HDFC Bank Statement PDF to Excel — 3 Simple Steps
1
Download from HDFC
Get your statement PDF from HDFC NetBanking or the MobileBanking app
2
Upload & Convert
Upload the PDF above — enter the PDF password if prompted (last 4 digits of mobile)
3
Download Excel
Get a clean .xlsx file with date, narration, withdrawal, deposit, and balance
How to Download Your HDFC Bank Statement PDF
Via HDFC NetBanking
HDFC NetBanking is the easiest way to get a statement PDF for any date range:
- Log in at netbanking.hdfcbank.com using your Customer ID and IPIN
- Go to Accounts in the top navigation
- Click Account Statement from the dropdown
- Select your account, choose the statement period (up to 2 years available online)
- Choose PDF as the format and click Download
- The PDF will be password-protected — the password is the last 4 digits of your registered mobile number
Via HDFC MobileBanking App
The HDFC Bank app (available on iOS and Android) also lets you download statements:
- Open the HDFC Bank app and log in with your Customer ID or biometric
- Tap My Accounts from the home screen
- Select the account you want the statement for
- Tap Statement and select the date range
- Tap Download — the PDF is sent to your downloads folder
HDFC Bank Statement PDF Password
HDFC Bank automatically password-protects all statement PDFs. The password follows a fixed rule that is easy to remember:
- Primary password: The last 4 digits of your registered mobile number. If your mobile is 9876543210, the password is 3210.
- Alternative: If the mobile number password does not work (e.g., for older statements), try the last 4 digits of your HDFC Customer ID.
- NRI accounts: Some NRI account statements use the last 4 digits of the NRE/NRO account number instead.
When you upload a password-protected HDFC PDF to our converter, you will be prompted to enter the password. The password is used only to unlock the file for processing and is never stored on our servers.
Supported HDFC Account Types
Our converter handles all HDFC Bank account statement formats without any special configuration:
- HDFC Savings Account — Regular savings accounts including Regular Savings, SavingsMax, Women's Savings, and Senior Citizens' accounts
- HDFC Current Account — Business current accounts including Regular, Plus, Premium, and Trade Current accounts
- HDFC Salary Account — Classic, Regular, Premium, and Corporate Salary accounts
- HDFC NRI Accounts — NRE (Non-Resident External) and NRO (Non-Resident Ordinary) savings and fixed deposit accounts
- HDFC Basic Savings Account — BSBD (Basic Savings Bank Deposit) accounts
All these account types use the same underlying HDFC statement PDF format, so the converter processes them identically and extracts all columns accurately.
What Columns Are Extracted from HDFC Statements?
HDFC Bank statements follow a consistent 7-column layout. Our converter preserves the exact structure:
Common Uses for HDFC Statement Excel Files
📊 ITR Filing & Tax Computation
During income tax filing season, your CA or tax consultant will often ask for 12 months of bank statements in Excel format. Converting your HDFC PDFs saves hours of manual data entry and reduces transcription errors. Filter by category to quickly identify TDS credits, interest income, and dividend payments.
🏠 Home Loan & Personal Loan Applications
HDFC Bank and other lenders typically require 6 months of salary account statements in Excel format for loan underwriting. Our converter produces clean, properly formatted files that lenders accept without question.
📈 CA Audit & Book Reconciliation
Chartered Accountants and auditors use Excel statements to reconcile books of accounts. The clean debit/credit columns and running balance make bank reconciliation straightforward in Tally ERP, Busy Accounting, or any other Indian accounting software.
💰 Personal Finance & Budgeting
Use Excel pivot tables to categorise your HDFC transactions by narration type — UPI payments, ATM withdrawals, EMI debits, salary credits — and build a clear picture of your monthly spending patterns.
Frequently Asked Questions
How do I download my HDFC Bank statement PDF?
Log into HDFC NetBanking at netbanking.hdfcbank.com, go to Accounts → Account Statement, select your date range, choose PDF format, and download. On the HDFC MobileBanking app: My Accounts → Statement → select period → Download.
What is the password for my HDFC Bank statement PDF?
HDFC uses the last 4 digits of your registered mobile number as the PDF password. For example, if your mobile number ends in 3210, enter 3210 when prompted. For NRI accounts, try the last 4 digits of the account number if the mobile number does not work.
Which HDFC account types are supported?
All HDFC account types are supported: savings accounts, current accounts, salary accounts, NRE accounts, and NRO accounts. They all use the same PDF statement format so conversion works identically.
How long does the conversion take?
Digital HDFC statement PDFs (downloaded from NetBanking) convert in under 5 seconds. Scanned or photographed statements may take 15–30 seconds due to OCR processing. There is no limit on the number of pages or months.
Is my HDFC Bank data safe?
Yes. All files are processed on HTTPS-encrypted secure servers and automatically deleted after 24 hours. We never store, share, or sell your financial data. The PDF password you enter is used only to unlock the file and is never saved.
Can I convert multiple months of HDFC statements?
Yes — convert one PDF at a time with no daily limits. To analyse multiple months, convert each PDF separately and then combine the sheets in Excel. There is no charge, ever.
Does it work with HDFC NRI account statements?
Yes. HDFC NRE and NRO account statements use the same PDF format as domestic accounts. Foreign currency transactions and INR equivalents are both captured in the narration column.
What Excel columns are extracted from HDFC statements?
Date, Narration/Description, Cheque/Reference Number, Value Date, Withdrawal Amount, Deposit Amount, and Closing Balance — exactly matching HDFC's official statement column layout.
What is the password for an HDFC Bank credit card statement PDF?
HDFC Bank credit card statement PDFs are typically password-protected using your date of birth in DDMMYYYY format (e.g., 15031990 for 15 March 1990). If that does not work, try the last 4 digits of your registered mobile number, or call HDFC credit card support at 1800-202-6161 to confirm the password format for your account type.
Can I convert my HDFC Bank statement to Tally-compatible CSV?
Yes. After converting your HDFC statement PDF, download the Tally CSV option. The output uses DD-MM-YYYY date format, separate Debit and Credit columns, and plain decimal amounts — the exact format required by Tally ERP 9 and Tally Prime bank reconciliation import and TDL import scripts.
How do I convert my HDFC Bank statement to QuickBooks QBO format?
Upload your HDFC Bank statement PDF to bankstatementengine.com and select QBO as the output format. The QBO file can then be imported directly into QuickBooks Online via Banking → Upload from file. This eliminates manual entry of HDFC transactions in QuickBooks.
Does the converter work with HDFC Bank joint account statements?
Yes. HDFC issues a single PDF statement for joint accounts showing all transactions. The converter extracts all transactions from that PDF regardless of which account holder initiated the transaction.
What should I do if my HDFC Bank statement PDF fails to convert?
First check that you are entering the correct password (last 4 digits of your registered mobile number for savings accounts). If the PDF is a scanned image rather than a digital statement, OCR processing takes longer. For best results, download a fresh copy of the statement directly from HDFC NetBanking rather than using a forwarded or printed-then-scanned copy.
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.
Ready to Convert Your HDFC Statement to Excel?
100% free · No signup · Password-protected PDFs supported · Instant download
Convert Now — It's Free →