What is a SWIFT MT940 file and how does conversion work?
SWIFT MT940 is the international end-of-day customer statement format that encodes each transaction across a :61: statement line and a multi-line :86: narrative block. EasyExtract reads .sta, .mt940, .940, and .txt files directly in your browser, normalizes comma decimals and debit signs, and exports RFC 4180 CSV.
How to convert MT940 to CSV online
- Drop your MT940 or .sta file. Select your bank export (.mt940, .sta, .940, or .txt). Your browser reads the text locally with zero uploads.
- Review parsed :61: and :86: rows. EasyExtract splits each :61: line into Value Date, D/C indicator, signed Amount, and Reference, then joins wrapped :86: narrative lines.
- Download or copy CSV. Click Download CSV to save mt940-transactions.csv for Excel, Xero, or QuickBooks, or copy the table directly to your clipboard.
What fields this converter extracts
- Value Date: Parsed from
YYMMDDin:61:into ISOYYYY-MM-DD. - D/C Indicator & Signed Amount: Detects
C,D,RC, andRDflags, converts European comma decimals to dot decimals, and prefixes debits with-. - Reference & Description: Extracts trailing
:61:reference tokens and concatenates multi-line:86:remittance blocks.
Supported extensions and preview bounds
Inputs: SWIFT MT940 files saved as .mt940, .sta, .940, or .txt.
Outputs: UTF-8 .csv with CSV formula-injection neutralization on text fields. Up to 500 rows render in the live preview table while all parsed rows export to CSV.
Why bank statements never leave your device
Corporate and personal MT940 exports list IBANs, cash balances, payroll transfers, and vendor names. EasyExtract runs 100% locally inside browser memory, so zero bytes cross the network.
What this tool does not do
- It does not parse binary or encrypted bank envelopes: Extract plain-text MT940 payloads from any ZIP or PGP wrapper before opening.
- It assumes 20xx dates for 6-digit YYMMDD tokens: Legacy pre-2000 statements will display
20YYyear prefixes.
When to use MT940 to CSV
- Treasury and ERP imports: Clean European and international bank statements before uploading into Xero, QuickBooks, SAP, or NetSuite.
- Reconciliation in Excel: Convert wrapped
:86:descriptions into single rows for pivot tables and lookup formulas.
MT940 compared with BAI2, CAMT.053, and OFX
European and international SWIFT banks use MT940 and its XML successor CAMT.053. US corporate treasury portals use BAI2, while North American retail accounting feeds use QBO and OFX. Read the complete walkthrough in how to convert MT940 to CSV.
Frequently asked questions
What is an MT940 file?
MT940 is the international SWIFT standard for electronic end-of-day bank account statements used across Europe, the UK, APAC, and South Africa.
Is it safe to convert bank statements here?
Yes. All parsing runs 100% client-side in JavaScript with zero server uploads.
Which accounting tools accept the exported CSV?
The exported CSV opens in Microsoft Excel and Google Sheets and imports into Xero, QuickBooks, and ERP templates.