Open MT940 files in your browser
The statement banks pass over SWIFT, and what business banking exports for accounting software. Open one right here, every booking in a table. Nothing leaves your device.
Or drop it anywhere on this page
What you'll see
Your statement opens as a table, a row for each transaction, with the account, its period and its balances in Show details.
- A row for each transaction • Amounts as the bank wrote them
- Sort and filter • Search every payee and memo
- Each account's period and balances • Money in and out summed
- Export • Save as CSV, Excel, JSON or Parquet
About MT940
SWIFT, the network banks send payments over, defined the MT940 message as a customer's statement: an account's opening balance, every booking, and its closing balance. Business banking exports it as .mt940, .sta or .txt, and accounting apps across Europe import it.
An MT940 is text in fields that start with a tag: :20: the reference, :25: the account, :28C: the statement's number, :60F: the opening balance, a :61: line for each booking with its :86: details, and :62F: the closing balance. Banks fill :86: their own way: German banks with ?20 to ?33 subfields for the purpose, the other party's name and account, Dutch ones with codes like /NAME/ and /REMI/.
Filepeek reads it in your browser as a table, a row for each booking with its date, value date, payee, purpose, type and amount, the amounts in the bank's own digits. Show details gives each account, its period, its opening and closing balances and the money in and out, summed exactly. Sort, filter and search the rows, and save them as CSV, Excel, JSON or Parquet.
SWIFT MT940 Customer Statement
.mt940 • .sta
Format
- MIME type
- text/plain
- Made by
- SWIFT
Inside the file
- Account
- :25:, the account number or IBAN
- Balances
- :60F: opening and :62F: closing, with their dates
- Bookings
- A :61: line each, with :86: details
- Written as
- Text in tagged fields, one statement after another
Opens in every browser
Browsers download MT940 files, or show them as raw text. Filepeek opens them in Chrome, Edge, Firefox and Safari as a table of bookings.
- YouChromeOpens through Filepeek
- YouEdgeOpens through Filepeek
- YouFirefoxOpens through Filepeek
- YouSafariOpens through Filepeek
Apps that open MT940
- WindowsGnuCash, free, and accounting apps like DATEV import it
- MacGnuCash, free, imports it
- iPhone and iPadNo app built in opens it
- AndroidNo app built in opens it
Questions
Why are the payee and purpose all in one line?
Each bank writes a booking's :86: details its own way. Filepeek reads the payee, purpose and reference from the ?20 to ?33 subfields German banks write and the /NAME/ and /REMI/ codes Dutch and other banks write, and keeps anything else as it is, in Memo.
My bank sends CAMT.053 now. Does that open?
Yes. CAMT.052, 053 and 054, the ISO 20022 XML statements that replace MT940, open the same way, a row for each booking, whatever the file's name.
Can I turn an MT940 into Excel?
Yes. Choose Export to save every booking, or only the rows on show, as Excel, CSV, JSON or Parquet, with the amounts exactly as the bank wrote them and money out negative.