If you've downloaded a bank statement in India, you've almost certainly hit this: you open the PDF and it demands a password. Banks lock e-statements by default to protect your financial data in transit. The good news — once you know where the password comes from, opening and converting the statement takes about a minute.
Why bank statements are password-protected
A bank statement is one of the most sensitive documents you own — it carries your account number, balance, income and every transaction. Banks password-lock the PDF so that if the email or file is intercepted or forwarded by mistake, the contents stay protected. It's a sensible default, even if it's mildly annoying when you just want to open your own statement.
Where to find your statement password
The password is set by your bank, not by you — and the exact rule is printed in the email or SMS that delivered the statement. This is the single most important thing to know: rather than guessing, open the covering email from your bank and look for the line that says something like "Your statement is password protected. The password is…". Every bank spells out its own rule there.
The password is almost always built from details you already know — some combination of your name, date of birth, PAN, customer ID, or account number. Common patterns you'll see described in the bank's email include:
- Your date of birth in DDMMYYYY (or DDMMYY) format
- Your PAN, sometimes combined with your date of birth
- Your customer ID or account number
- The first few letters of your name (in capitals) plus part of your date of birth
How to open the PDF
Open the file in any PDF reader — Adobe Acrobat Reader, your browser, or your phone's PDF viewer — and enter the password when prompted. Passwords are usually case-sensitive, so if your bank says the name portion is in capitals, type it exactly that way. Once accepted, you can read the statement normally.
How to create an unlocked copy
To convert a statement (into Excel, Tally, or anything else), it's cleanest to work from an unlocked copy. You don't need special software — the print-to-PDF trick works on every device:
Open the statement with its password
Open the locked PDF and enter the password so the contents are visible.
Print to PDF
Choose File → Print (or the print icon), then select "Save as PDF" / "Microsoft Print to PDF" as the printer instead of a physical printer. Save the new file.
You now have an unlocked copy
The saved file opens without a password. It's a normal PDF you can convert, email, or archive — keep it somewhere private, since it's no longer protected.
Converting the unlocked statement to Excel
With an unlocked PDF in hand, converting to a spreadsheet is the easy part. Upload it to BankXL's converter and you'll get a formatted Excel file — debit/credit split into separate columns, running balance intact, junk rows removed — in about 15 seconds. Need it in Tally instead? The same unlocked PDF works with the Tally Prime converter.
Doing this safely
An unlocked statement is exactly as sensitive as the locked one — just without the lock. A few sensible habits:
- Store unlocked copies in a private folder, not a shared drive or desktop
- Delete unlocked copies once you've converted or filed them
- Only upload to a converter that processes privately and doesn't retain your file — see our bank statement privacy guide for what to check
- Never email an unlocked statement without re-protecting or zipping it with a password
BankXL processes your unlocked PDF entirely on our own servers, parses it in memory, and deletes it the instant your download is ready — nothing is written to disk, logged, or sent to any third-party service.
Stuck on a specific bank's password or format? Email support@banlxlai.com and we'll point you in the right direction.
Convert your unlocked statement
Once your PDF is unlocked, drop it into BankXL and get clean Excel, CSV or Tally XML in 15 seconds — parsed privately on our servers, never shared with any third party.
Convert to Excel →