Convert a bank statement to Excel

Why convert a bank statement to Excel?

Bank statement formats such as MT940 and CAMT.053 are made for accounting software, not to be read by hand. If you want to analyse, sort or check your transactions yourself, a spreadsheet is much more convenient. In Excel you can filter, sum, create pivot tables and add columns — and you can easily share the file with your accountant or bookkeeper.

StatementBridge converts MT940, CAMT.053, CSV or PDF into a clean, clear Excel or CSV spreadsheet with all transaction details listed below each other.

Common use cases

• VAT check — verify that the VAT you paid and received matches the actual bank transactions.
• Cash flow analysis — map income and expenses per period and analyse your liquidity.
• Spotting duplicate transactions — use filters and functions in Excel to find duplicate or unexpected bookings.
• Sharing with your accountant — deliver a clear file that opens in any program.

How does it work? Step by step

1. Upload your bank statement — go to StatementBridge and upload your MT940, CAMT.053, CSV or PDF file.
2. Check the preview — verify that the transactions, amounts, dates and balances are recognised correctly.
3. Choose Excel or CSV — select the spreadsheet format as output.
4. Download — download the spreadsheet and open it in Excel, Google Sheets or LibreOffice.

What does the file contain?

The spreadsheet contains all available transaction data from your source file: transaction date, amount, description, counterparty account (IBAN), counterparty name, currency and other available fields. Each transaction is clearly shown on its own row.

Correct formatting and safety

StatementBridge pays attention to the details that often go wrong in practice when exporting to a spreadsheet:

• UTF-8 encoding — special characters and accents are displayed correctly, without strange characters.
• Semicolon separation — the CSV file uses the semicolon as separator, as is standard in Dutch Excel settings.
• Comma decimals — amounts use the comma as decimal separator, so they are immediately recognised as numbers.
• Protection against formula injection — text fields that start with a character such as =, + or - are stored safely, so that Excel does not accidentally execute them as a formula.