What Is MT940 Format?
MT940 (Message Type 940) is a SWIFT standard for electronic bank statements. It is a structured text format used by banks across Europe, the Middle East, and Asia to deliver machine-readable transaction data to corporate customers and accounting systems. The format consists of tagged fields:
| Tag | Field Name | Contents |
|---|
| :20: | Transaction Reference | Unique statement reference number |
| :25: | Account Identification | IBAN or account number |
| :28C: | Statement / Sequence Number | Statement number and page number |
| :60F: | Opening Balance | Currency + debit/credit indicator + opening balance |
| :61: | Transaction | Value date + booking date + D/C + amount + reference |
| :86: | Information to Account Owner | Narrative, payee name, remittance info |
| :62F: | Closing Balance | Currency + debit/credit indicator + closing balance |
How to Convert MT940 to Excel
1
Upload MT940 FileUpload your .mt940, .sta, or .txt file — or a PDF MT940 export from your bank
2
Auto-ParseAll MT940 field tags are parsed: booking date, value date, amount, reference, narrative
3
Download ExcelGet a clean .xlsx or .csv with all transactions, balances, and account details
Banks That Use MT940 Format
Germany & DACH Region
Deutsche Bank
Commerzbank
DZ Bank
KfW
HypoVereinsbank
Landesbank Baden-Württemberg
Volksbank
Sparkasse
Netherlands & Benelux
ING Bank
ABN AMRO
Rabobank
SNS Bank
Triodos Bank
KBC Belgium
BNP Paribas Fortis
Belfius
France & Southern Europe
BNP Paribas
Société Générale
Crédit Agricole
UniCredit
Intesa Sanpaolo
Santander EU
BBVA
Erste Bank
Other Regions
HSBC International
Standard Chartered
Emirates NBD
Abu Dhabi Commercial Bank
DBS Singapore
Bangkok Bank
MT940 vs CAMT.053 — What's the Difference?
| Feature | MT940 | CAMT.053 |
|---|
| Format | SWIFT proprietary text format | ISO 20022 XML format |
| Status | Legacy — still widely used | Modern — SEPA mandated |
| File extension | .mt940, .sta, .txt, .940 | .xml |
| Structured data | Tag-based, semi-structured | Fully structured XML |
| Rich remittance | Limited (86 field narrative) | Full structured remittance info |
| Used in | Existing ERP integrations, legacy systems | New SEPA implementations |
MT940 to Excel — Column Mapping
Each MT940 transaction record (tag :61: and :86:) maps to these Excel columns:
- Value Date — from :61: field, first 6 digits (YYMMDD format converted to YYYY-MM-DD)
- Booking Date — from :61: field, optional 4-digit entry date
- Debit/Credit — D = debit (money out), C = credit (money in), RD/RC = reversal
- Amount — transaction amount with currency from :60F: opening balance tag
- Reference — customer reference from :61: field
- Narrative — payee, description, and remittance info from :86: field
- Balance — closing balance from :62F: tag (per statement batch)
Frequently Asked Questions
What file extension does an MT940 file have?
MT940 files use .mt940, .sta, .txt, or .940 extensions. The file is a plain text document formatted with SWIFT field tags (:20:, :25:, :28C:, :60F:, :61:, :86:, :62F:). You can open it in any text editor to verify the contents before converting.
What is the difference between MT940 and CAMT.053?
MT940 is an older SWIFT text-based format. CAMT.053 is its XML replacement mandated by SEPA for modern European bank integrations. Both contain the same transaction data — MT940 in a tag-based text structure, CAMT.053 in structured XML. Our tool handles MT940 format.
Can I convert MT940 files exported from ERP systems like SAP?
Yes. MT940 files generated by SAP, Oracle, Microsoft Dynamics, or other ERP systems are supported as long as they follow the SWIFT MT940 standard field structure.
Which European banks provide MT940 download?
Deutsche Bank, ING Bank, ABN AMRO, Rabobank, Commerzbank, UniCredit, BNP Paribas, Société Générale, Santander EU, BBVA, KBC, Belfius, Erste Bank, and most other European banks offer MT940 download from their business banking or corporate banking portals.
Can I import the converted Excel into accounting software?
Yes. The converted Excel or CSV can be imported into SAP, QuickBooks, Xero, Sage, Exact Online, Twinfield, AFAS, and other accounting systems that accept standard CSV bank imports.
Convert Your Bank Statement Free
No signup required. Works with every bank worldwide.
Start Converting Now