Bank statement to Excel
Every transaction in its own row with real dates and numbers, ready for filters and pivot tables.
Read more →PDF bank statement to MT940
Your accounting software reads MT940, but the bank only gave you a PDF? Convert it here – with the opening and closing balance your software needs.
- Every bank, any language
- Balance check: opening + transactions = closing
- Your statement never leaves your computer
ExcelCSVMT940CAMT.053OFXQBO
When you need this
- A new client brings a year of PDF statements and your bank link only goes back a few months.
- The bank no longer offers MT940 downloads for older periods.
- You moved bank or the account has been closed, and only PDFs remain.
What the MT940 file contains
A standard SWIFT MT940 statement: account (IBAN and currency), opening balance (:60F:), one :61: line per transaction with booking date, value date and amount, the description in the :86: field with the counterparty IBAN and name where available, and the closing balance (:62F:). We use the SWIFT character set and line lengths, so strict importers accept the file.
Balances must match
Accounting software rejects an MT940 file when the opening balance does not follow on from the previous import. BankToCSV takes the balances from the statement and checks that all transactions add up before you download. MT940 export is part of Business.
Last updated: 29 October 2026
How it works
From PDF statement to a clean file in three steps
Drop the PDF
Download the statement as PDF from your online banking and drop it on the page. Nothing is uploaded.
Check the result
Every transaction appears in a table with date, description and amount. We check the opening and closing balance for you.
Download
Choose Excel, CSV, MT940, CAMT.053 or OFX and import the file into your spreadsheet or accounting software.
Your bank statements stay on your device
Bank statements show your income, your spending and your account number. That is why BankToCSV reads them inside your browser. The PDF is not uploaded – not to us and not to anyone else. You can even disconnect from the internet after the page has loaded.
We do not use tracking cookies or analytics.
Related converters and guides
PDF bank statement to CSV
Comma or semicolon, decimal point or comma: a CSV that imports cleanly anywhere.
Read more →PDF to CAMT.053
ISO 20022 XML statements for modern accounting software and ERP systems.
Read more →Bank statement to QBO
QuickBooks Web Connect files for QuickBooks Online and Desktop.
Read more →Bank statement to OFX
For Xero, Quicken, YNAB and other finance apps.
Read more →Supported banks
ING, Rabobank, ABN AMRO, Chase, Sparkasse and many more – and yours, if it is missing.
Read more →Frequently asked questions
Which programs import MT940?
Among others SnelStart, Exact Online, AFAS, Twinfield, e-Boekhouden, Moneybird, DATEV, Lexware and many ERP systems.
MT940 or CAMT.053?
Banks are replacing MT940 by CAMT.053. Most software reads both; when in doubt, choose what your software calls its bank import format.