What is a SWIFT MT940 Export?

4294972513

The SWIFT MT940 export is a method for downloading your Commercial Banking Online account information for upload into other financial systems. The SWIFT MT940 export file follows the following structure:

Transaction Reference Number [Tag 20] 
             Related Reference [Tag 21] 
                        Account Identification [Tag 25]   
                               Statement/Sequence number [Tag 28C]
                                      Opening Balance [Tag 60]
                               Statement Line [Tag 61]
                       Information to account owner [Tag 86]
             Closing Balance File Trailer [Tag 62]
Closing Available Balance [Tag 64]

Each line of the SWIFT MT940 export will start with a two-numbered record type followed by a number of fields.

Two Code Number	Description	Mandatory/Optional	Contents
20	Transaction Reference Number	M	1 – 16 characters
21	Related Reference	O	9 characters
25	Account Identification	M	15 characters (nnnnnn-nnnnnnnn)
28C	Statement number/Sequence number	M	Up to 11 characters (nnnnn/nnnnn)
60F or 60M	Opening Balance	M	Up to 25 characters
61	Statement line	O	Up to 93 characters
86	Information to account owner	O	6 x 65 characters
62F or 62M	Closing Balance (booked funds)	M	Up to 25 characters
64	Closing Available Balance	O	Up to 25 characters

Transaction Reference Number [Tag 20]

Example of a Transaction Reference Number

:20:0252018959562762

The Transaction Reference Number signifies the start of the File and contains unique information to enable identification of the message. The information in the fields will follow the above example.

Related Reference [Tag 21]

Example of a Related Reference

:21:000000000

The Related Reference will always be represented as “000000000”

Account Identification [Tag 25]

Example of Account Identification

:25:776123-00702468

This field displays the sort code and account number of the bank account being reported in the format nnnnnn-nnnnnnnn.

Statement/Sequence Number [Tag 28C]

Example of Statement/Sequence Number

:28C:1719/1

This field contains the sequential number of the statement, optionally followed by the sequence number of the message within that statement when more than one message is sent for one statement.

Opening Balance [Tag 60a]

Example of Opening Balance

:60F:C170119GBP5,00

This field indicates the opening balance, whether the balance is in debit or credit, the date, the currency and the amount of the balance

Opening Balance Field Structure	Data
1	C or D identifying if balance is a Credit or Debit
2 - 7	Statement Date (YYMMDD) For 60F= last statement date or For 60M = Current
8 – 10	ISO Currency Code
11 – 25	Amount including a comma as the decimal separator

Statement Line – [Tag 61]

Example of Statement Line Details

:61:170119C1,1NTRFANDY

CHAPS or International Payment

:86:F/FLOW ANDY TRNID00000000022-4TRNIDDATE20170119ADVREF301763

109183601701900110ANDY

The statement line [Tag 61] gives transaction reference information to assist the account owner identifying the reason for the entry as well as the reference of the account servicing institution. If no reference is available for this subfield, the code NONREF shall be used.

The information in the fields will follow this order:

Statement Line Sub- Field No	Data	Structure
1	Value date in format YYMMDD	6 characters
2	Entry Date – (Optional)	4 characters
3	C or D identifying if transaction is a Credit or Debit	1 character
4	Amount including a comma as the decimal separator	15 characters
5	N - Transaction Type code	1 character
6	SWIFT Transaction Identification code (see table below)	3 characters
7	Reference for Account Owner	16 characters
8	Reference of the Account Servicing Institution	// 16 characters
9	Supplementary Details	34 characters

Information to Account Owner [Tag 86]

This field contains additional information about the transaction detailed in the preceding statement line and is passed on to the account owner. The information can be populated over 6 lines of 65 characters.

Closing Balance [Tag 62]

Example of Closing Balance (booked funds)

:62F:C170119GBP11,33

The field indicates the Closing Ledger Balance, whether it is a debit or credit balance, the date, the currency and the amount of the balance.

The information in the fields will follow this order:

Closing Balance Field Structure	Data
1	C or D identifying if balance is a Credit or Debit
2 – 7	Statement Date (YYMMDD)
8 – 10	ISO Currency Code
11 – 25	Amount including a comma as the decimal separator

Closing Available Balance [Tag 64]

Example of Closing Available Balance

:64:C170119GBP5,83

The field indicates the Closing Available Balance, whether it is a debit or credit balance, the date, the currency and the amount of the balance.

The information in the fields will follow this order:

Closing Available Balance Field Structure	Data
1	C or D identifying if balance is a Credit or Debit
2 – 7	Statement Date (YYMMDD)
8 – 10	ISO Currency Code
11 – 25	Amount including a comma as the decimal separator

SWIFT MT940 Transaction Codes

ADV	Counter Deposit	CHK	Cheque Paid
BGC	Bank Giro Credits	DDT	Direct Debit
FPI	Faster Payment Received	FPO	Faster Payment Sent
MSC	ATM Deposit	MSC	ATM Withdrawal
MSC	Refunded Charges	MSC	Card Transaction
STO	Standing Order	MSC	International Payment
TRF	CHAPS or International Payment	MSC	Service Charges
TRF	Inter Account Transfer	STO	Standing Order
		TRF	CHAPS Payment
		TRF	Inter Account Transfer