KontoXL

How to open an MT940 bank statement in Excel

MT940 (.sta, .940) files are bank statements for accounting software. Here is how to read them in Excel, with counterparty, IBAN and purpose in separate columns.

Convert a statement now PDF, camt.053 or MT940 · stays on your computer

An MT940 file is an electronic bank statement in the SWIFT text format. Banks offer it for accounting software; opened in a text editor it looks like lines of codes such as :60F:, :61: and :86:.

Convert MT940 to Excel

  1. Download the MT940 file from your online banking (often called .sta, .940, .mt940 or .txt).
  2. Drop it on KontoXL. Files with several statements (several days or accounts) are read completely.
  3. Download the Excel or CSV file: one row per booking, with the details of the :86: field split into counterparty, IBAN, purpose and reference.

What KontoXL reads in an MT940 file

Many banks are moving from MT940 to camt.053 (ISO 20022). KontoXL reads both: see camt.053 to Excel.
Convert a statement now PDF, camt.053 or MT940 · stays on your computer

Other guides