The intention of this post is to provide its readers with an overview of the MT940 file format. It will help the readers to understand different details present in MT940 file at different places or rows.
What is an MT940?
MT940 is an Electronic Bank Account Statement, developed by SWIFT. It consists the details of all transactions done through a bank account. It is used to import the transaction details from a bank account to ERP system and is delivered in text format.
1st Sample MT940 File:
:86:999/00FPC68354 X XXXXXX 913000381
/20BGCFrom: 09-01-18 20376333
Meaning of these rows:
:20: – Statement Date
:25: – Account Identification Bank Key / Account Number, or It can also have IBAN number of the Account for which the statement is generated.
:28C: – Bank Statement Number
:60F: – Opening Balance(D:Debit + Date:YYMMDD + Currency + Amount)
:61: – Transaction Line( Date:YYMMDD + PostingDate:MMDD + C:Credit + 3rdCharacterOfCurrency,P for GBP + Transaction Amount + SomeFixed Value)
:86: – Transaction Details (TransactionCode + Transaction Type + otherDetails
:62F: – Closing Balance (C: Credit + DateYYMMDD + Currency + Amount)
:64: – Available Balance (C:Credit + Date:YYMMDD + Currency + Amount)
2nd Sample MT940 File: (example taken from this link)
:61:0310201020D1088,41FTRFREF 12345678/2003//8327000090031790 Transfer
:86:020?00Wyplata/przelew?20DEUTSCHE ELEKTROAPPARATUR?21OBENSTRAS SE 4 MUNCHEN?22OCMT/EUR1088,41?23CHGS/SHA/EUR20,00?24FAKTURA 333 /2003 ZAPLATA ZA?25FABRYKATY DO TUB 200 SZTUK?26GZX 76 I 300 SZT UK GZY 77 T?27RANZYSTORY 300 SZTUK BT34SX?28OPORNIKI 500 SZTUK W Q2?29232FX?30HYVEDEMM700?31701890012872?38DE09700202701890012872
Meaning of these Rows:
1: 2: 4: – SWIFT Header
:20: – Short Name of Account Holder
:25: – Account Identification, same as described above.
Other Tags of MT940 Format are same as explained in sample 1