1. Why Convert Your Bank Statement to Excel?
A bank statement in PDF is useful for viewing transactions, but it has a fundamental limitation: the data is locked in image or unstructured text format. You cannot filter, sort, sum or perform analysis directly in the PDF.
Once converted to Excel, you gain access to all analytical capabilities:
- Automatic bank reconciliation — compare transactions against your accounting records
- Expense categorisation — group by transaction type
- Cash flow analysis — inflows vs outflows by period
- Import into accounting software — PHC, Primavera, Sage, Contabilizei
- Automated reports — pivot tables, charts, dashboards
- Missing payment detection — filter by supplier or reference
For businesses and accountants, this conversion can save several hours per month of manual data entry.
2. Methods to Convert Bank Statement PDFs to Excel
Several methods are available, each with advantages and limitations. We analyse the main ones:
Method 1: Bank2PDF (Recommended)
A service specialised in Portuguese bank statements. Automatic format detection for each bank, no configuration required.
Advantages
- • All Portuguese banks supported
- • Result in <10 seconds
- • 1st page free
- • No software installation
- • Secure data (GDPR)
Limitations
- • Free plan: 1 page
- • Requires internet connection
Method 2: Adobe Acrobat
PaidAdobe Acrobat Pro has an export-to-Excel function. It works reasonably well for simple PDFs, but may struggle with the specific format of Portuguese banks.
Advantages
- • Recognised professional software
- • Works offline
Limitations
- • Cost: ~€20/month
- • Output frequently misformatted
- • Does not recognise PT bank formats
- • Requires manual Excel clean-up
Method 3: Manual Entry in Excel
FreeTyping each transaction from the PDF into Excel manually. Free but time-consuming, error-prone and impractical for statements with many transactions.
Method 4: Copy and Paste from PDF
FreeSelecting text in the PDF and pasting it into Excel. May work for simple PDFs, but the result is generally misformatted — everything in one column, dates and values mixed together, requiring extensive clean-up with formulas.
3. How to Use Bank2PDF — Step by Step
Bank2PDF is the fastest and most accurate method to convert Portuguese bank statements to Excel. Here is how it works:
- Create a free account at bank2pdf.com/register — no credit card required.
- Download the PDF statement from your bank's website or app (see the following section for bank-by-bank instructions).
- Upload the PDF to the Bank2PDF dashboard. Drag the file or click "Choose file".
- The system automatically detects the bank and statement format — no selection needed.
- In under 10 seconds you receive the Excel file to download, with all transactions organised in columns: Date, Description, Debit, Credit and Balance.
4. How to Download Your PDF Statement — By Bank
To convert, you first need the statement in PDF format. Here is the quick guide for each bank:
CGD — Caixa Geral de Depósitos
On CaixaDirecta (caixadirecta.cgd.pt): Account → Transactions → Export → PDF. On the CGD app: Account → Transactions → share icon → PDF. Full CGD guide →
Millennium BCP
On MillenniumNet (millenniumbcp.pt): My accounts → Transactions → Export → PDF. On the Millennium app: Account → Transactions → share icon top right. Full BCP guide →
Santander Totta
On Netbanco (netbanco.santander.pt): Accounts → Transactions → Export PDF. On the Santander app: Transactions → export icon. Full Santander guide →
Novo Banco
On NB Smart (nb.pt): Accounts → Transactions → Export → PDF. On the NovoBanco app: Account → View transactions → export. Full Novo Banco guide →
BPI
On BPI Net (bpinet.com): Current accounts → Account statement → Export to PDF. On the BPI app: Statement → share icon. Full BPI guide →
Crédito Agrícola
On CA Net (creditoagricola.pt): Accounts → Transactions → Export PDF. On the CA app: Account → Transactions → share button. Full Crédito Agrícola guide →
5. How to Import the Excel into Accounting Software
After converting, you can import the Excel file directly into the main Portuguese accounting software packages:
PHC Software
In PHC, go to Treasury → Import Bank Statement. Select the Excel file and map the columns (Date, Description, Debit, Credit). PHC accepts the format generated by Bank2PDF directly.
Primavera Business Software
Under Treasury → Bank Statements → Import. Primavera accepts Excel files with standardised columns. The Bank2PDF file is compatible without any additional transformations.
Sage / Contabilizei / TOConline
Most online accounting platforms support importing bank statements in Excel or CSV format. The file generated by Bank2PDF can be saved as CSV directly from Excel (File → Save As → CSV).
6. Tips and Common Issues
My bank PDF is password-protected
Some banks protect PDFs with the account holder's date of birth or tax number. You need to remove the protection before converting. Use Adobe Acrobat (File → Properties → Security) or an online PDF password removal tool. Once the protection is removed, Bank2PDF converts normally.
The statement was scanned and has no text
Paper statements that have been scanned are images, not PDFs with text. Bank2PDF uses OCR (optical character recognition) on paid plans to process this type of document. Accuracy is high, but a quick review may be required.
The resulting Excel has misformatted columns
If you are using a method other than Bank2PDF (e.g. direct copy-paste from PDF), it is common for the output to be misformatted. Bank2PDF resolves this automatically because it understands the specific structure of each Portuguese bank.
The statement shows multiple accounts on the same page
Some consolidated statements display multiple accounts. Bank2PDF automatically separates transactions by account, producing an organised Excel file.
The conversion took too long or returned an error
If the PDF has many pages (over 100), it may take longer. If an error occurs, check that the PDF is not corrupted by opening it in a browser. If the issue persists, contact Bank2PDF support.
7. Frequently Asked Questions
Is it possible to convert a bank statement PDF to Excel for free?
Yes. Bank2PDF offers conversion of the first page of any bank statement free of charge, with no credit card required. For full statements, paid plans are available from €19.99/month.
How long does it take to convert a bank statement to Excel?
Converting a typical bank statement (1 to 10 pages) takes under 10 seconds with Bank2PDF. Larger statements may take up to 30–60 seconds.
Is the generated Excel compatible with Portuguese accounting software?
Yes. The Excel file generated by Bank2PDF has standardised columns (Date, Description, Debit, Credit, Balance) compatible with PHC, Primavera, Sage, Contabilizei, TOConline and other Portuguese ERPs.
Does Bank2PDF support statements from all Portuguese banks?
Bank2PDF natively supports CGD, Millennium BCP, Santander, Novo Banco, BPI, Crédito Agrícola, Montepio, Banco CTT, ABANCA, ActivoBank, Bankinter, BBVA and many others. Bank detection is automatic.
Is my banking data safe when using Bank2PDF?
Yes. All files are processed on secure servers in Portugal with SSL encryption. Data is automatically deleted 30 days after conversion. Bank2PDF is fully GDPR compliant.
Ready to convert your statement?
Try it free now — 1st page of any statement, no credit card required.
Get Started Free