Convert HDFC Bank Bank Statement to Excel
HDFC Bank prints its transactions as Date, Narration, Chq./Ref.No., Value Dt, Withdrawal Amt., Deposit Amt. and Closing Balance. The Narration field follows a hyphen-delimited UPI pattern — ‘UPI-{name}-{VPA}-{IFSC}-{RRN}-{remark}’ — which gets chopped at roughly 100 characters, so the payee’s VPA or your own remark often vanishes mid-word. Anyone who has tried selecting a full page in Acrobat knows the columns collapse into one jumbled string, forcing hours of manual splitting for a single quarter of ₹ entries. SheetMyBank reads HDFC’s column geometry directly from the PDF, keeps each hyphen-separated narration intact in one cell, and separates withdrawals from deposits so your pivot tables work immediately.
Inside NetBanking, go to the Accounts tab → Enquire → View/Download Account Statement for recent periods; for older data use Download Historical Statements, which offers five formats including PDF, Excel and Text, or raise Request → Email Statement. Whichever PDF you end up with, SheetMyBank converts it entirely on your device — nothing crosses the network. Since every HDFC row carries a Closing Balance, the tool subtracts withdrawals and adds deposits down the sheet, highlighting any row where the printed balance disagrees with the computed one.
Drop your HDFC Bank statement here (PDF or photo)
Processed entirely on this device — nothing is uploaded. Scans and photos are read with on-device OCR (beta).
Free for your first 5 pages each month · Processed on your device · Balance-verified output
HDFC Bank statement FAQ
How do I open a password-protected HDFC e-statement PDF?
HDFC email statements open with your Customer ID — the same number you use to log in to NetBanking. This is one of the most consistently documented password schemes among Indian banks. Enter it exactly as printed on your welcome letter or chequebook, with no extra spaces.
HDFC already offers Excel in Download Historical Statements — why convert a PDF?
The Excel option only appears for historical requests inside NetBanking. Monthly e-statements pushed to your email, and statements handed over at a branch, arrive as PDF only. Converting those locally spares you from re-requesting old periods or waiting for a fresh download window.
Why is the payee name cut off in my HDFC UPI narration?
HDFC truncates the ‘UPI-name-VPA-IFSC-RRN-remark’ string near 100 characters, so trailing segments disappear in the PDF itself. SheetMyBank exports whatever the bank printed, and because the hyphen positions are preserved, you can still split the narration into fields with Excel’s Text to Columns.