MT940 to CSV Converter

Convert SWIFT MT940 bank statements to CSV. Widely used by European banks (Deutsche Bank, ING, Raiffeisen, ABN AMRO). Runs in your browser.

1.0.0
Version
Auth
Batch
Zero uploads. MT940 statements parsed entirely in your browser.

Upload MT940 file

.mt940, .sta, .940, or plain .txt

MT940 to CSV Converter Tutorial

What is MT940?

MT940 is a SWIFT message format for customer account statements, widely used by European banks for corporate and accounting exchanges. Unlike CSV, it's a tag-based format like:

:20:STMT-REF-001
:25:/DE12345678901234567890
:28C:1/1
:60F:C240101EUR12345,67
:61:2401020102DR500,00NTRFNONREF
:86:Zahlung an Muller GmbH
:62F:C240102EUR11845,67

Tag Meanings

  • :20: — Transaction reference
  • :25: — Account identification
  • :28C: — Statement/sequence number
  • :60F: — Opening balance
  • :61: — Statement line (one per transaction)
  • :86: — Information to account owner (transaction details)
  • :62F: — Closing balance

Banks That Export MT940

  • Deutsche Bank, Commerzbank (DE)
  • ING, Rabobank, ABN AMRO (NL)
  • Raiffeisen, Erste, BAWAG (AT)
  • BNP Paribas, Société Générale (FR)
  • UBS, Credit Suisse / UBS (CH)
  • Santander, BBVA (ES)
  • SWIFT-connected business banking worldwide

Why Convert?

MT940 is machine-readable but unfriendly for humans. Converting to CSV lets you:

  • Import into Excel/Google Sheets for analysis
  • Feed into accounting software that doesn't accept MT940
  • Combine multiple months of statements for reconciliation
  • Search across transactions with grep/awk

Parsing Logic

This tool handles the core MT940 fields. The :86: description tag can contain structured sub-fields (?20..?29 for remittance info, ?30/?31 for bank info, ?32/?33 for counterparty name) — we extract those when present.