Skip to content
stmtai

Convert HDFC statement PDFs to Excel, Tally and CSV.
Tally, Zoho Books, Excel files from the PDF.

Statements emailed by HDFC Bank are password-protected and the email spells out the format. NetBanking will hand you the same statement as Excel or a delimited text file, not just PDF, and for a quick tally that is often enough.

Drop your HDFC statement here

PDF, scan or photo. Up to 12 files at a time.

Not ready to upload your own? See a sample result

5 pages free, no account. Amounts stay in INR.

Last updated

How to download a HDFC statement as a PDF

  1. Log in to HDFC Bank NetBanking. Go to Accounts, then Enquire, then Download Account Statement (labelled Account Statement on some profiles).
  2. Choose the account, set a period (a preset like last 6 months or your own date range, up to 5 years back) and pick PDF as the format.
  3. Click Download and save the file. This PDF is generated on the spot and is not password-protected.
  4. For a statement in your inbox: Accounts, then Request, then Email Statement, and choose the period. That PDF arrives protected.
  5. In the HDFC Bank app: Accounts, tap the account, then Statements (or Email Statement) and select the period.

Then drop the file above; several months of HDFC statements at once come back as one workbook.

Is the HDFC PDF password-protected?

Statements emailed by HDFC Bank are password-protected and the email spells out the format. For savings and current account e-statements it has long been the Customer ID, and the email subject usually shows the last digits of that ID as a hint. Drop the emailed file as it is: the upload box asks for the Customer ID and unlocks the PDF in your browser, and only the unlocked copy is sent. The NetBanking download comes unprotected if you would rather skip the prompt.

What HDFC statements look like

Date, Narration, Chq./Ref.No., Value Dt, Withdrawal Amt., Deposit Amt., Closing Balance. Dense, many rows per page, often password-protected.

HDFC statements have seven columns: Date, Narration, Chq./Ref.No., Value Dt, Withdrawal Amt., Deposit Amt. and Closing Balance, in small type with 40 to 50 rows a page. Dates are dd/mm/yy. The Narration is where UPI accounts get noisy: a typical line reads UPI-MERCHANT NAME-vpa@bank-BANKCODE-reference-remark, and the reference number repeats in the Chq./Ref.No. column. Amounts use Indian grouping (1,23,456.78) which the converter reads as 123456.78. A salaried account with daily UPI use produces 300 to 600 rows a quarter, and the statement ends with a summary block giving opening balance, Dr Count, Cr Count, Debits, Credits and closing balance, which is what the row-count check is compared against.

Why not use HDFC's own export?

NetBanking will hand you the same statement as Excel or a delimited text file, not just PDF, and for a quick tally that is often enough. The Excel is a straight dump of the statement columns with no formatting and dates as text, so it still needs cleaning before Zoho will take it, and it is not something Tally can post as vouchers. Where the PDF wins is when someone else sent it to you: a client's emailed e-statement, or a signed branch statement for a loan file, exists only as a protected PDF, and converting it gives you clean columns plus a Tally XML voucher file.

Where HDFC statements trip up converters

  • Indian number format (1,23,456.78) is read correctly.
  • Password-protected PDFs are unlocked in your browser: a prompt asks for the password HDFC printed in its email, and only the unlocked copy is uploaded.
  • UPI narrations are long; they are kept whole so UPI IDs remain searchable.

Which software HDFC customers import into

HDFC customers most often import into Tally, Zoho Books, Excel.

HDFC questions

The UPI narrations are very long. Can the converter shorten them?

It keeps them whole by default because the UPI ID and the reference are what you search for when a customer disputes a payment. In Excel you can split the narration on the hyphens with Text to Columns and keep only the merchant part. Nothing is truncated during conversion.

Does the Dr Count and Cr Count at the end of the statement get used?

Yes. HDFC prints how many transactions the statement contains, and the converter compares the number of rows it extracted against that total, alongside the balance check. A mismatch is flagged before you download, which is the fastest way to notice a page that did not render.

Should I convert the emailed e-statement or the NetBanking download?

If you have NetBanking access, download from there. It is unprotected and you can choose the exact date range. The emailed e-statement is the same data for a fixed cycle and needs its password removed first. Both convert identically once open.

How do I convert a HDFC statement PDF to Excel?

Download it from HDFC using the steps above, drop it here, and in about 10 to 40 seconds you get the table, the balance check and the Excel, CSV, QuickBooks, Xero and Tally XML downloads. The first 5 pages are free with no account.

How many HDFC statements can I convert at once?

Up to 12 files at a time, 60 pages each. A year of monthly statements comes back as one Excel workbook with an Overview sheet showing which months balanced, a sheet per month with a Category column, and a Categories sheet totalling the year by category.

Other banks in India

Comparing converters for HDFC statements? 14 tools that name HDFC or its market, side by side, checked October 2026.

All banks and formats · See a sample result