If your bank sent the statement with a password, open it with that password, then print it to a new PDF. The new file has no password and can be converted to Excel. Convert, check the totals, and delete the unprotected copy as soon as you are done, because it holds your account details in the open.
Where does the password come from?
Banks usually describe how the password is formed in the email that carries the statement, or on their website or app. It is typically built from details you already know, but the exact pattern is the bank's own. Read that message carefully, and if it does not say, ask your bank through its official channel. Never download tools that claim to crack or guess passwords, and do not try to bypass a file you are not meant to open.
How do you save an unprotected working copy?
- Open the PDF in your browser or PDF viewer and enter the password when asked.
- Press Ctrl+P to print.
- Choose Microsoft Print to PDF or Save as PDF as the printer. On a phone, choose the Save as PDF option in the share or print menu.
- Save the new file under a clear name, such as statement-april-working, in a folder you chose.
- Open the new copy. It should open without a password.
Note that this method re-creates the pages as text and images, so the result is a faithful copy only for a normal text PDF. Check that you can still select a line of text in it.
What do you do with the unprotected copy?
| Step | Why |
|---|---|
| Convert it to Excel or CSV straight away | The less time the open copy exists, the better |
| Reconcile the converted rows against the statement | Conversion mistakes show up in the totals |
| Delete the working copy | It holds your name, account number and spending |
| Empty the Recycle Bin or Deleted items | Deleted files wait there until it is emptied |
| Keep the original protected PDF | It remains your official record |
The unprotected copy is the risky part, so it helps to decide its lifespan before you create it: minutes, not days.
How do you keep storage tidy?
- Work in a single folder, not on the desktop or in Downloads where files accumulate.
- Check that the folder is not set to sync automatically to a shared or public cloud space.
- Do not forward unprotected copies in chat groups or email threads.
- On a phone, remove the working copy from Downloads, Recent files and any gallery.
- Name files by month rather than by your name or account number.
Treat the working copy as temporary. A simple habit is to put it in a folder named to-delete, so that at the end of the session you can empty the folder in one go and nothing lingers by accident.
What if the password does not work?
Check that you are using the latest message, since banks can change the pattern. Check the upper and lower case, and that you have not added a space. Make sure the file is not damaged by downloading it again. If it still fails, contact your bank through the number on its official website or your card. Keep the password to yourself and never pass it to anyone who contacts you offering help.
Be careful about where the copy goes. Use a converter that runs on your own device, or one whose privacy terms you have read. Once an unprotected statement is uploaded to an unknown website, you cannot take it back, and it contains the details that identify your account.
Next steps
Once the copy is converted, the rows can be checked, categorised and used. Remember that a working copy is temporary: convert, verify and delete.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

