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 format follows the industry standard SWIFT MT940 structure.

    The SWIFT MT940 export follows the below structure, * x represents a character/and or space:

    {4:
    :20: xxxxxxxxxxxxxxxx
    :21: xxxxxxxxxxxxxxxx
    :25: xxxxxx-xxxxxxxx
    :28C: xxxxx/xxxxx
    :60F:C/D DDMMYY GBP xxxxx
    :61: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
    :86: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
    xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
    xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
    xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
    xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
    :62F:C/ D DDMMYY GBPxxxxx
    -}

    Mandatory/Optional Tag Field Name Content/Options No.
    M 20 Transaction reference number 16x 1
    O 21 Related reference 16x 2
    M 25 Account identification 35x 3
    M 28C Statement number/Sequence number 5n(/5n) 4
             
    O 61 Statement line * 6
    O 86 Information to account owner 6*65x 7
             
    M 62a Closing balance (booked funds) F or M 8
    O 64 Closing available balance (available funds) 1!a6!a15d 9
             
    O 65 Forward available balance 1!a6!n3!a15d 10
             
    O 86 Information to account owner 6*65x 11


    1. Field 20: Transaction reference number (TRN) Mandatory field. Minimum length 1 character; maximum length 16 characters.
    2. Field 21: Related reference Optional field. 16 characters.
    3. Field 25: Account identification Mandatory field. Minimum length 1 character; maximum length 35 characters. Sort code/Account number combination. Follows pattern xxxxxx-xxxxxxxx for sort code – account number.
    4. Field 28C: Statement number. Mandatory field. Minimum length 1; maximum length 5. Follows pattern xxxxx/xxxxx for statement number / sequence number. 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. E.g. 12345/1
    5. Field 60: Opening balance Mandatory field. There are 2 options:

      • Option F – :60F:
        • Debit/Credit | Last Statement Date (YYMMDD) | Currency (ISO) | Amount
      • Option M – :60M:
        • Debit/Credit | Current Statement Date (YYMMDD) | Currency (ISO) | Amount
      Sub Field Name Content/Options
      1 char Debit or Credit (D or C)
      6 int Date (YYMMDD)
      3 alpha - ISO 4217 Currency code (GBP)
      15 dec Amount including a comma as the decimal separator

    6. Field 61: Statement line. For multi-line fields we split the data into fixed length chunks. It is not necessary to fill all the characters as a pair will delimit the field. If a customer reference cannot be deduced the reference ‘NONREF’ should be included.
      Sub Field Name Content/Options
      6 int Value date (YYMMDD)
      4 int Entry date (YYMMDD) Optional
      2 alpha Optional
      2 alpha Debit/Credit mark
      1 alpha Funds code optional
      15 dec Amount (including comma decimal separator)
      1 alpha 3 char Amount (including comma decimal separator)
      16 chars Reference for account owner
      // 16 chars Account servicing institution's reference (optional)
      34 chars Supplementary details (optional)

    7. Field 86: Information to account owner 6*65 characters – any additional information.
    8. Field 62a: Closing balance (booked fund) Mandatory field. There are 2 options:

      • Option F – :60F:
        • Debit/Credit | Last Statement Date (YYMMDD) | Currency (ISO) | Amount
      • • Option M – :60M:
        • Debit/Credit | Current Statement Date (YYMMDD) | Currency (ISO) | Amount
      Sub Field Name Content/Options
      1 char Debit or Credit (D or C)
      6 int Date (YYMMDD)
      3 alpha - ISO 4217 Currency code (GBP)
      15 dec Amount including a comma as the decimal separator

    9. Field 64: Closing available balance (available funds) Optional field.
      Sub Field Name Content/Options
      1 char Debit or Credit (D or C)
      6 int Date (YYMMDD)
      3 alpha - ISO 4217 Currency code (GBP)
      15 dec Amount including a comma as the decimal separator

    10. Field 65: Forward available balance Optional field.
      Sub Field Name Content/Options
      1 char Debit or Credit (D or C)
      6 int Date (YYMMDD)
      3 alpha - ISO 4217 Currency code (GBP)
      15 dec Amount including a comma as the decimal separator

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.