Feature · Password-protected PDFs
Password protected bank statement PDF to Excel
To convert a password protected bank statement PDF to Excel, upload the locked file and type its password when asked. It is unlocked in your browser, the password is never sent to our servers, and the unlocked copy is converted and reconciled like any other statement.
- Unlocked in your browser
- The password is never sent or stored
- Clear message on a wrong password
- Same checks and exports as any statement
The short answer
How to convert a password protected bank statement PDF to Excel
Upload the locked PDF, type the password when VouchRow asks for it, and the statement is converted like any other: rows extracted, reconciled against the statement’s own balances, and exported to Excel or the format your software takes. The password unlocks the file in your browser and is never sent to our servers or stored.
There is no need to remove the password yourself first. The unlocked copy is made on your device, and that copy is what is converted and kept.
What VouchRow cannot do is open a file without its password. It does not crack or guess passwords, so a statement whose password nobody knows cannot be converted.
Step by step
Converting a locked statement, step by step
- 1Upload the PDF as it cameUpload the statement exactly as the bank sent it. Uploading needs an account. The file is recognised as locked when it is opened.
- 2Type the passwordYou are asked for the password. If you are not sure of it, check the email the statement came with or the bank’s help pages before guessing.
- 3The file is unlocked on your deviceYour browser decrypts the PDF and makes an unlocked copy. The password is used for that and then dropped. It is not sent or saved.
- 4If the password is wrong, try againA password that does not open the file gets a clear “wrong password” message, and you can type it again.
- 5The statement is converted and checkedA digital statement is read in your browser. A scanned one is sent for transcription after you are asked, as with any scan. Either way the rows are reconciled against the running balance and printed totals.
- 6Review and exportCheck any flagged rows against the source line, then export Excel, CSV, QBO, QFX, OFX, QIF, IIF or Tally XML, depending on your plan.
Unlocked in your browser, once
When a PDF turns out to be password-protected, you are asked for the password. The file is decrypted in your browser and an unlocked copy is made there. That copy is what gets converted, previewed and stored, so nothing downstream ever needs the password again.
Decryption carries the text layer across untouched. A digital statement stays digital after it is unlocked, and is read in the browser like any other.
The password goes nowhere
The password is used for that one decryption and then dropped. It is not sent to VouchRow’s servers, it is not saved in your account, and it is not remembered for the next statement from the same bank. Each locked file asks again.
A wrong password is said plainly
If the password does not open the file, you see a message saying so and can type it again. A missing password and a wrong one are told apart, so you are never left guessing whether the file is damaged or the password is off by a character.
We cannot open a PDF whose password you do not know
Why it works
Why it works this way
The password stays with you
Decryption happens in your browser, so the password never has to be sent anywhere to be used.
Digital stays digital
Unlocking keeps the text layer, so a locked online-banking statement is read as text, not as an image.
Wrong is told apart from missing
You know whether the password was wrong or the file needed one, and can try again straight away.
Same checks as any statement
Running balance, page subtotals, opening to closing, printed totals and the count all run on the unlocked copy.
Teammates are not blocked
The stored copy is unlocked, so a colleague reviewing the statement does not need the password passed on to them.
Where they come from
Which statements arrive password-protected
Most US banks deliver statements through online banking as ordinary PDFs. Locked files turn up in a few predictable places, and they are worth recognising because the password is usually one you already have.
- Some US credit card issuers and brokerages send statements, or attachments, as password-protected PDFs.
- Clients sometimes lock a statement themselves before emailing it to their accountant, and send the password separately.
- Indian bank e-statements are almost always locked. The password is usually built from the account holder’s name, date of birth or customer ID, and the bank explains the pattern in the statement email or on its help pages.
Privacy
What happens to the password, and what happens to the file
They are treated differently on purpose. The password is used once, in your browser, to make an unlocked copy, and is then gone: it is not sent to VouchRow’s servers, not saved in your account and not remembered for the next file.
The unlocked copy is handled like any other statement. It is stored under the workspace’s retention setting, and deleted when that setting says. If retention is set to keep nothing, the PDF is not kept either.
| The password | The unlocked PDF | |
|---|---|---|
| Where it is used | In your browser, once | Converted, previewed and reviewed |
| Sent to VouchRow’s servers | No | Stored, if retention allows |
| Kept afterwards | No | For the workspace’s retention period |
| Who can open it | Only whoever knows it | Members with access to the project |
Teams
Why teammates can open the stored copy without the password
Because the stored PDF is the unlocked one, anyone in the workspace who can view that project can open it and see the source line behind each row. That is usually what a firm wants: the senior reviewing a junior’s conversion should not need the client’s password too.
It does mean the password no longer controls who sees the file once it is in the workspace. Project access does that instead. If a client gave the password to one person deliberately, put the statement in a project only that person can see, or set retention so the PDF is not kept.
Wrong password
When the password does not work
A password that does not open the file gets a “wrong password” message, and you can try again. Before that, a few things are worth checking.
- Capitals. PDF passwords are case-sensitive, and patterns built from a name often expect capitals or lower case specifically.
- Date format. A date of birth may be expected as DDMMYYYY, DDMM or another order; the bank’s instructions say which.
- The right password for the right file. Statements from different banks, or different accounts, often use different passwords.
- A copied space. Pasting a password from an email can carry a trailing space with it.
Scans and batches
Scanned locked files, and locked files in a batch
A locked scan is unlocked the same way, in your browser, and the unlocked pages are then read as a scan: you are asked before they are sent for transcription. The password itself still never leaves your device.
In a batch of digital statements, a password-protected file is not converted with the others. It is marked as needing its password, and you convert it on its own, where you are asked for it.
Side by side
Removing the password yourself vs unlocking on upload
Both end with a converted statement. The difference is how many copies of the unlocked file you leave behind.
| Remove the password first, then upload | Upload the locked file | |
|---|---|---|
| Extra steps per statement | Open, save an unlocked copy, upload that | None: type the password when asked |
| Unlocked copy left on your computer | Yes, until you delete it | No |
| Password sent to VouchRow | No | No |
| Stored copy in VouchRow | Unlocked | Unlocked |
| Checks and exports | The same | The same |
Who uses it
Who runs into locked statements
Accountants receiving client statements
Clients who lock statements before emailing them. Convert with the password they send, and the team works on the stored copy.
Credit card and brokerage downloads
Issuers and brokerages that deliver locked PDFs. Convert card statements to Excel or QBO without saving an unlocked copy first.
Clients with Indian bank accounts
E-statements that are locked by default, converted to Excel, CSV or Tally XML with the password built from the account holder’s details.
Lenders and family-law teams
Statements supplied by applicants or parties, locked, with the password supplied separately.
FAQ
Password-protected statement PDFs: questions
How do I convert a password protected bank statement PDF to Excel?
Upload the locked PDF, type its password when asked, and the statement is unlocked in your browser and converted. Review the reconciliation, then export Excel or any other format your plan includes.
Is my PDF password sent to VouchRow?
No. The password is used in your browser to unlock the file and is then dropped. It is not sent to our servers and not stored.
Can my teammates open the statement without the password?
Yes. The stored copy is the unlocked one, under the workspace’s retention setting, so any member with access to that project can open it. Use project access or retention if that is not what you want.
What happens if I type the wrong password?
You see a message saying the password did not open the file, and you can type it again.
Can VouchRow open a PDF if I have forgotten the password?
No. VouchRow does not crack, guess or bypass passwords. Ask the bank or whoever sent the file for the password, or download an unlocked copy from online banking if the bank offers one.
What is the password for my Indian bank e-statement?
Usually a combination of the account holder’s name, date of birth or customer ID, in a pattern the bank sets. The statement email or the bank’s help pages give the exact pattern. VouchRow cannot tell you what it is.
Can I convert password-protected PDFs in a batch?
Not together with the rest. In a batch, a locked file is marked as needing its password, and you convert it on its own, where you are asked for it.
Do password-protected scanned statements work?
Yes. The file is unlocked in your browser first, then the pages are read as a scan, after you are asked. The password never leaves your device.
Keep going
Related guides and converters
Related features
Convert a locked statement to
Handling and retention
Related
Other features
Convert a locked statement without saving an unlocked copy first
Create an account, upload the PDF as the bank sent it and type the password when asked. Plans start at $15 a month for 300 pages, and only pages with transactions count.