HDFC Bank Statement to CSV: The Complete Walkthrough

You need an HDFC Bank statement as CSV, and you need it to be right: every UPI transfer, every NEFT credit, every amount in the correct direction. Maybe you're filing ITR, assembling a loan file, or handing a year of transactions to an accountant.

Here is the thing worth knowing before you start: HDFC NetBanking does not offer a CSV download. The formats it lists are Delimited (.txt), MS Excel (.xls), MS Money, PDF and Text. So even the best case leaves you converting something, and the common case leaves you with a password-protected PDF and nothing else.

This post covers both paths, the HDFC-specific quirks that break most converters, and how to prove your CSV matches the statement to the paisa.

Quick answer

There are two ways to get HDFC transactions into a spreadsheet:

1. HDFC's own statement download. In NetBanking you can download an account statement for a date range as Delimited (.txt), MS Excel (.xls), MS Money, PDF or Text. Note what is absent: there is no CSV option. The .xls or Delimited file gets you close, then needs tidying.
2. Convert the PDF statement. For emailed e-statements, older periods, closed accounts, or a statement someone sent you, the data exists only as a PDF. Upload it to a converter like BankStatementKit, which extracts the transactions and balance-checks the output against the statement's own printed totals.

Rule of thumb: if you can log in and the period is available, take the .xls and tidy it. If what you have is a PDF, or you want a clean CSV that reconciles without hand-editing, convert it.

Convert an HDFC PDF to a verified CSV

Option 1: HDFC's built-in statement download

If you have NetBanking access, try this first — the data comes straight from the bank.

1. Log in to HDFC NetBanking with your Customer ID and IPIN.
2. Go to Accounts → Enquire → Account Statement, or Download Historical Statement for older periods.
3. Choose a date range and a format. HDFC lists Delimited (.txt), MS Excel (.xls), MS Money, PDF and Text — there is no CSV option.
4. Open the .xls or Delimited file in Excel or Google Sheets.

In the mobile app the statement journey produces a PDF you can view, share or email to yourself rather than a spreadsheet.

Where the built-in download stops

HDFC's export is genuinely useful, and it also runs out in predictable ways:

• No CSV, so there is always a conversion step. The .xls and Delimited files carry the data but not in the shape most accounting tools want. Expect header rows, merged cells and text-formatted numbers before anything imports cleanly.
• Date-range limits. Online statement history goes back only so far. Older periods are the ones people most often need for loan files and tax assessments.
• You need working login access. For a closed account, an NRI account you no longer operate, or a statement a client emailed you, there's no login to use.
• Emailed e-statements are PDFs. If you're registered for email statements, what lands in your inbox each month is a password-protected PDF, not a spreadsheet.

Every one of those cases ends in the same place: a file you have to convert.

Option 2: Convert the HDFC PDF statement to CSV

1. Open the statement PDF. If it's an emailed e-statement it will ask for a password.
2. Upload it. Supply the password when prompted — the file is decrypted in memory and never written to disk.
3. The transactions are read into seven standard columns: Date, Narration, Reference, Value Date, Debit, Credit, Balance.
4. Check the verification label, then download the CSV.

Convert an HDFC statement

About that password

HDFC's emailed statements are encrypted. For savings and current account statements the password is your Customer ID.

Credit card statements are the fiddly case, because HDFC documents two different formats depending on the statement: the first four letters of your name plus your date of birth as DDMM, or the first four letters of your name plus the last four digits of the card number. Rather than guess between them, check the exact format stated in the email HDFC sends with the statement — that email is the authority, over any blog post including this one.

Why HDFC PDFs trip up generic converters

HDFC statements have a specific shape, and it defeats naive extraction in three ways.

Narrations wrap. This is the big one. HDFC's Narration column carries long UPI, NEFT and IMPS strings — counterparty handles, reference numbers, remarks — and a single entry routinely spills onto two or three physical lines. A converter that treats each line as a transaction produces phantom rows with no amounts attached. Rows have to be assembled around the date and amount columns, with continuation lines folded back into the transaction they belong to.

Dr and Cr are separate columns. HDFC prints Withdrawal (Dr) and Deposit (Cr) as two columns rather than one signed amount. Collapse them carelessly and every debit in the file flips sign — an error that's invisible until something downstream fails to balance.

There's a Value Date as well as a Date. Transaction date and value date differ on plenty of rows. Treating them as interchangeable quietly reorders the statement.

The seven-column HDFC layout — Date, Narration, Chq./Ref. No., Value Date, Withdrawal (Dr), Deposit (Cr), Closing Balance — maps cleanly onto the standard output columns when it's read as a table rather than as lines of text.

Prove the CSV matches the statement

This is the part most people skip, and it's the part that matters. HDFC statements give you two independent ways to check the conversion:

1. The running balance chain. Every row prints a Closing Balance. For each row, the previous balance minus the debit plus the credit must equal the printed balance. A single dropped or duplicated row breaks the chain at exactly the point it went wrong.
2. The STATEMENT SUMMARY. HDFC prints a summary block with opening balance, closing balance, and debit and credit counts. Opening + total credits − total debits must equal closing, and the row counts must match what you extracted.

Doing this by hand takes 10–15 minutes per statement. BankStatementKit runs both checks on every conversion and labels the result VERIFIED, DISCREPANCY or FAILED, with a discrepancy pinpointing the row where the numbers stop reconciling.

FAQ

The bottom line

If you have NetBanking access and your date range is available, use HDFC's own download — it's free and native. For emailed e-statements, older periods, closed accounts and client-supplied PDFs, convert the PDF — and insist on a conversion you can prove, because the wrapped narrations and split Dr/Cr columns are exactly where silent errors hide.