Learning to convert a password-protected Banco Portugues de Investimento PDF statement to Excel is essential for BPI customers who need their Portuguese bank data in a spreadsheet. Banco Portugues de Investimento, widely known as BPI, protects many of its emailed and downloaded statements with a password, which keeps the document safe in transit but blocks converters that cannot open locked files. Once you supply the right password at conversion time, the statement becomes an ordinary spreadsheet, and this guide covers the password hunt, the conversion, and the euro-format checks that matter most.
Expat and cross-border customers feel this friction most. A BPI statement may arrive while you live abroad, the password rule may be described in Portuguese, and the statement itself uses European date and number formats that US or UK software misreads by default. None of that is a reason to retype the statement by hand. The workflow below treats the password as a one-time hurdle and the formatting as a short checklist, and after the first month it becomes routine.
Find the password for your BPI statement
BPI statement passwords are typically tied to your customer identification: for many customers, the password is a personal identification number, a tax number, or credentials from BPI online banking, depending on how the statement was issued. The delivery email or the download screen is the first place to look, since it commonly states the password rule in Portuguese, for example that the password is your identification document number. Translate that message carefully before guessing, because a misread rule sends you down a list of wrong candidates.
Work through candidates methodically and note each attempt: identification number without spaces or punctuation, the number format used at login, and any password you set when requesting the statement. If you downloaded the statement from BPI Net or the mobile app, the password often matches the download step rather than the email rule. If nothing works, request a new statement from the bank instead of using unlocking tools that require uploading a financial document to an unverified server. For background on the bank, see our Banco Portugues de Investimento bank page.
Convert the unlocked BPI PDF to Excel
Use a converter that supports password-protected PDFs and enter the password when prompted at upload. The converter reads the transaction table and returns a spreadsheet with date, description, and amount columns, while your original protected PDF stays unchanged as the official record. Keep that original filed by account and month, because accountants and tax authorities prefer the bank-issued document over a spreadsheet you edited.
Portuguese statements use day-first dates and euro amounts with a comma decimal and a dot or space for thousands, so 1.250,50 means one thousand two hundred fifty euros and fifty cents. After conversion, verify five rows against the PDF, confirm the opening balance equals the prior statement's closing balance, and confirm the closing balance. Watch for Portuguese labels in the description column, such as commission or fee terms, which translate unevenly: keep the original description alongside any translation so matching stays possible later. For the general method, see our guide on how to convert a bank statement PDF to Excel.
Reconcile a BPI statement in euros
Reconciliation for a euro account needs the currency set correctly before import. If your accounting software defaults to dollars, a euro statement imported into a dollar account creates a conversion difference on every row, even when the transactions are perfect. Create or select a euro-denominated account first, then import the converted file, and match transactions to invoices, receipts, and transfers.
Pay attention to cross-border items: transfers from abroad may appear with different dates in BPI and in your other bank, and card transactions in other currencies settle in euros at a rate that differs slightly from the purchase-day rate. Those timing and rate differences explain most small reconciliation gaps on BPI statements. Match the settled euro amount, not the original foreign-currency amount, and note exchange-rate differences separately rather than forcing the totals to agree. For the matching workflow, see our guide on how to reconcile a bank statement.
Common BPI password and conversion problems
The most common failure is a password that looks right but carries a hidden character: a trailing space copied from an email, a hyphen typed where the rule wants none, or a leading zero dropped by a spreadsheet that treated the ID as a number. Type the password by hand in a desktop PDF reader to confirm it before converting, and if it opens there but fails in the converter, the converter may not support protected PDFs at all.
A second common problem is a statement that opens but converts with garbled text. That usually means the PDF was generated as scanned images rather than selectable text, which happens with older statements. In that case, optical character recognition is needed before conversion, and the result needs a closer row-by-row check, since scanned numbers misread more often than digital text. Either way, the closing balance is your test: if it matches the PDF, the conversion is trustworthy; if it does not, find the bad rows before importing.
Frequently asked questions
What is the password for a BPI PDF statement?
It is commonly your identification or tax number, or a password set during download. Check the delivery email or download screen first, since it usually states the rule, sometimes in Portuguese.
Can I convert a protected BPI PDF without removing the password?
Yes. A converter that supports protected PDFs opens the file with the password you supply, reads the transactions, and returns a spreadsheet. The original PDF remains protected.
Why do euro amounts look wrong after conversion?
Portuguese statements use comma decimals and dot thousands separators. If amounts are one hundred times too small, the comma was misread, and fixing the number format in the spreadsheet repairs the column.
Should the accounting account be in euros or dollars?
Euros for a euro statement. Importing a euro statement into a dollar account creates a conversion difference on every row and makes reconciliation painful.
Start with one month, confirm the password and the closing balance, and the rest of the year follows easily. If you convert statements in volume, check pricing for plans that cover more pages, and begin from the ConvertStatement home page.