What is a SWIFT MT940 Export?

  • 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


How helpful is the information on this page?

Calls may be monitored or recorded in case we need to check we have carried out your instructions correctly and to help improve our quality of service.

Lloyds Bank plc Registered Office: 25 Gresham Street, London EC2V 7HN. Registered in England and Wales no. 2065. Telephone: 020 7626 1500.

Authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and the Prudential Regulation Authority under registration number 119278.

We subscribe to the Lending Code; copies of the Code can be obtained from www.lendingstandardsboard.org.uk.

Eligible deposits with us are protected by the Financial Services Compensation Scheme (FSCS). We are covered by the Financial Ombudsman Service (FOS). Please note that due to FSCS and FOS eligibility criteria not all business customers will be covered.