Convert Password-Protected Bank Statements

Plenty of bank PDFs arrive locked. It's routine in India, and several UK and EU banks do it too. The good news is that the password is usually a pattern the bank told you, not something you've lost. Here's how to open the file properly and turn it into a spreadsheet you can actually work with.

Why your bank statement PDF is password-protected

Banks encrypt statement PDFs so that a file sitting in an inbox or a downloads folder can't be read by anyone who picks it up. When you open one, you're prompted for a password before a single line shows. That's an "open password" (sometimes called a user password), and it's the one that stands between you and the data.

The part people miss: the password is rarely random. Most banks generate it from details you already know, and they document the pattern in the covering email or on their website. Common patterns include:

• Name plus date of birth — for example, the first few letters of your name in capitals followed by your DOB as `DDMMYYYY` or `DDMM`.
• Account or customer number — often the last few digits combined with your DOB.
• Date of birth on its own, formatted exactly as the bank specifies.
• PAN or a registered mobile number — common with Indian banks, where the PAN in capitals is a frequent format.

If you're not sure, check the email the statement came with. The pattern is almost always spelled out there, and getting the format exactly right — capitals, no spaces, the date order the bank wants — is usually the only thing standing between you and an open file.

A quick, honest line on this: you can only do any of the below with a statement you own and a password you legitimately have. None of it is about getting past a password you don't know. A converter is not a cracking tool, and you shouldn't treat any tool as one.

Step 1 — Unlock the PDF so it's openable

A converter needs a PDF it can open. So the first job is to turn your locked statement into an unlocked copy. You only need the open password to do this, and you almost certainly have it. Two reliable ways, both using software you already own:

Print to PDF (works everywhere). Open the statement, enter the password, then use your viewer's Print dialog and choose "Save as PDF" (macOS) or "Microsoft Print to PDF" (Windows) as the printer. You're effectively re-printing the open document to a fresh, unprotected file. The new copy has no password and opens straight away.

Save without the password (Acrobat or Preview). If you have Adobe Acrobat, open the file, go to the security settings and remove the password permission, then save. On a Mac, Preview lets you open the locked file, then export a new copy without the password set. Either way you end up with a clean, openable PDF.

A caveat worth knowing: the print-to-PDF route on a scanned statement produces an image-only PDF with no selectable text. That's fine — it just means the conversion step relies on OCR (optical character recognition) to read the image, which a proper converter handles. It does mean you shouldn't rely on copy-paste afterwards, because there's no text layer to copy.

Step 2 — Convert the unlocked file to Excel or CSV

With an openable PDF in hand, the conversion is the easy part. Using Export Bank Statement:

1. Upload the unlocked PDF. Drag in the copy you just saved — any bank, any layout. Because it's no longer encrypted, the converter can read it.
2. Let it extract. Every transaction goes into real columns: date, description, money in, money out, running balance. If your unlocked file is image-only — common after print-to-PDF on a scan — OCR reads the image so you still get structured data.
3. Check the reconciliation result. The tool totals the extracted lines and tests them against the statement's own running balance. Opening balance, plus credits, minus debits should equal the printed closing balance. If it does, the file reconciles. If it's out, the statement gets flagged rather than handed back as if it were correct.
4. Download clean Excel or CSV. You get a usable .xlsx or CSV — ready to total, filter, pivot, or import into accounting software. No merged columns, no figures stuck as text.

That's the whole flow: unlock once, upload once. For the conversion mechanics in more depth, the how to convert PDF bank statements to Excel guide covers the extraction side, and if you've been fighting with manual entry, convert bank statements to Excel without copy-paste is the one to read.

The check that matters once it's unlocked

Unlocking gets you an openable file. It doesn't tell you the conversion was complete — and that's where most tools stop. A running balance is a checksum the bank prints for you. After every transaction the statement shows the true account position, so you can start at the opening figure, apply each credit and debit in order, and the final number must land on the printed closing balance. If it doesn't, a line is missing or misread.

Export Bank Statement runs that balance walk automatically on every file before you download. So if a 312.40 discrepancy creeps in — a row lost in a page break, a swapped digit, a debit read as a credit — it shows up straight away instead of surviving into your accounts. As far as we know, most converters don't verify the file this way; most extract the numbers and leave the checking to you. If you want the detail on how that works, see how to reconcile bank statements.

One honest caveat on the accounting side. Converting isn't a live bank feed. A bank feed is an automated, certified connection straight into Xero or QuickBooks. What you get here is a file — clean Excel, CSV, or a native bank-import CSV for Xero, QuickBooks or Zoho Books — that you then import yourself. Convert, then import. It handles historical and one-off statements a feed can't reach, but it isn't a one-click API sync, and you should be wary of any tool that blurs the two.

What happens to a sensitive file like this

A bank statement is about as sensitive a document as you'll handle, and an unlocked one even more so, because you've stripped its protection to convert it. So it's fair to ask what becomes of it. With Export Bank Statement, files are processed and then deleted, and they're never used to train AI. If any converter is vague about deletion or about training on your data, treat that vagueness as your answer and use something else.

A practical tip: once you've converted, delete the unlocked copy from your own machine too. You made it to get the file openable; you don't need a password-free statement sitting in your downloads folder afterwards.