The forum post: my bank statement PDF is password protected and the converter will not open it, what now? The converter cannot read what it cannot unlock, so you open the file yourself first using the code your bank set, or use a tool you trust that asks for it during import. Then you check that the rows match your balances before you rely on them.
Where does the lock code come from?
Banks that protect a statement PDF usually tell you how the password is formed, often in the email carrying the file, in the statement notes or in the bank's help pages. It is typically made from details you already know, but the exact pattern differs by bank and can change, so read your own bank's instructions rather than guessing from what someone else used. If you cannot find it, ask the bank through its official channels.
Steps to get unstuck
- Download the statement again from the bank's own site or app, in case the first file was damaged.
- Open it in a normal PDF viewer and enter the password when asked. If it opens, the password is right.
- If a converter still fails, check that the file is not a scanned picture. If you cannot select text on the page, the converter has nothing to read.
- If your bank offers CSV or Excel downloads, use those. They avoid the PDF problem completely.
- If you must use the PDF, upload it to a tool that asks for the password itself during import.
- After import, check the rows against the statement before saving.
A worked check with made-up numbers
Say the statement shows an opening balance of ₹38,420.50, total credits of ₹1,12,000.00 and total debits of ₹1,05,310.75. The closing balance should then be 38,420.50 + 1,12,000.00 - 1,05,310.75 = ₹45,109.75.
| Check | Statement | Imported rows |
|---|---|---|
| Number of rows | 212 | 212 |
| Total credits (₹) | 1,12,000.00 | 1,12,000.00 |
| Total debits (₹) | 1,05,310.75 | 1,05,310.75 |
| Closing balance (₹) | 45,109.75 | 45,109.75 |
If the credits and debits match, the import is likely complete. If the debits come up short by ₹2,400.00, a row was missed or merged, often at a page break or where a long description wraps onto a second line. Find a transaction near that amount and add it by hand.
What does SpendixAI do with locked files?
SpendixAI supports password-protected PDFs during import, alongside CSV and Excel files. You pick the account first, upload the file, and review the rows before they are saved. It does not promise that every layout will be read perfectly, which is why the review step exists. It also does not ask for net-banking logins.
Which problems are not about the password?
- A statement from a bank that lays out dates or amounts differently from the one you tried before.
- A statement with an extra page of terms in front of the transactions.
- A file that opens only in the bank's own viewer.
- A very old statement that was produced as a picture.
One useful test: try the first page only. If a one-page excerpt opens and reads correctly, the problem is with the file or the layout, not the lock. If even that fails, request a fresh copy from the bank. Keep the unlocked file in a private folder rather than emailing it around, and delete spare copies once the import is saved.
An honest limit
If a PDF is badly formed, no converter will rescue every row. In that case, using the bank's CSV or Excel export, or typing the few missing rows yourself, is faster than hunting for a better tool.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

