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 |