• Guidance: importing Express or Standard MoneyMover in Commercial Banking Online (CSV file) for LloydsLink customers

    Last updated:  07  December  2015

    Importing Express or Standard MoneyMover in a CSV file

    Importing Express or Standard MoneyMover payments to Commercial Banking Online will be different to importing them in LloydsLink:

    • Express or Standard MoneyMover will now be called International Payment on Commercial Banking Online

    Header Indicator and Trailer Indicator

    Each payment you import will need to contain a header record at the start and a trailer record at the end. The header record will need to include:

    • Header Indicator: H
    • Import date: YYYYMMDD
    • Unique Sequence Number: every payment submitted by a user on the same day must have a different number. Each user can choose which number to enter.

    The Trailer Indicator field must always be ‘T’.

    Comments

    The comments field allows you to add notes about the payment. The field is optional and any text entered will not be shown on Commercial Banking Online.

    LloydsLink

    This table shows a breakdown of new, changed and removed fields on Commercial Banking Online.

    New mandatory fields  

    Fields have changed position or format  

    New optional fields  

    Removed fields  

    Header Indicator

    Payment Type

    Debit Account Reference

    Filter Description

    Date

    Originator Name

    Debit Amount

    Version

    Sequence

    Value Date

    Beneficiary Address Line 2

    Freeze

    Beneficiary Bank Code Type

    Beneficiary IBAN

    Beneficiary Country

    Urgency Code

    Beneficiary Account Type

    Payment Amount

    Beneficiary Bank Address Line 2

    Pay on Application

    Trailer Indicator

    Beneficiary Address Line 1

    Beneficiary Bank Country

    Debit Account Code

     

    Beneficiary Bank Name

    Beneficiary Reference Line 2

    Special Instructions

     

    Beneficiary Bank Address Line 1

    Beneficiary Reference Line 3

    Beneficiary Short Code

     

    Beneficiary Bank Code

    Beneficiary Reference Line 4

    Remittance Advice Debit Account Name and Address

     

    Beneficiary Reference Line 1

    Intermediary Bank Name

    Remittance Advice Beneficiary Name and Address

     

    Bank to Bank Instructions Line 1

    Intermediary Bank Code Type

    Remittance Advice Additional Information

     

    Beneficiary Account Number

    Intermediary Bank ID

    Remittance Advice Beneficiary Email Address

     

    Debit Account

    Intermediary Bank Address Line 1

    Payment Currency

     

    FX Contract ID

    Intermediary Bank Address Line 2

     
     

    FX Exchange Rate

    Intermediary Bank Address Line 3

     
     

    Charges

    Intermediary Bank Country

     
     

     

    Comments

     
      

    Debit Amount

     
      

    Originator Address 1

     
      

    Originator Address 2

     
      

    Originator Country

     




    New mandatory fields

    These fields are new mandatory fields which must be completed for the imported payment to pass validation

    Fields have changed position or format

    These fields have changed position and/or format. They are a mixture of mandatory and optional fields. Mandatory fields must be completed for the imported payment to pass validation.

    New optional fields

    These fields are new and are optional.

    Removed fields

    These LloydsLink fields will no longer appear on Commercial Banking Online.

    This table shows the differences between your existing payment import file and the payment import file on Commercial Banking Online

     LloydsLinkCommercial Banking Online 
    Field namePositionMandatory/OptionalField formatPositionMandatory/OptionalField formatDescription of the change

    Header Indicator

    n/a

    n/a

    n/a

    H1

    Mandatory

    H

    New mandatory field

    Date

    n/a

    n/a

    n/a

    H2

    Mandatory

    YYYYMMDD

    New mandatory field

    Sequence

    n/a

    n/a

    n/a

    H3

    Mandatory

    35 characters

    New mandatory field

    Filter Description

    H1

    Mandatory

    35 characters

    n/a

    n/a

    n/a

    Field has been removed

    Version

    H2

    Mandatory

    10 characters

    n/a

    n/a

    n/a

    Field has been removed

    Freeze

    H3

    Optional

    YES or NO

    n/a

    n/a

    n/a

    Field has been removed

    Payment Type

    1

    Mandatory

    IM or EM

    1

    Mandatory

    INT

    Mandatory field must be filled with ‘INT’

    Urgency Code

    2

    Optional

    1 character

    n/a

    n/a

    n/a

    Field has been removed

    Originator Name

    17

    Optional

    35 characters

    44

    Optional

    35 characters

    Field has changed position

    Originator Address 1

    18

    Optional

    35 characters x3

    45

    Optional

    35 characters

    Field has changed position and format

    Originator Address 2

    n/a

    n/a

    n/a

    46

    Optional

    35 characters

    New optional field

    Originator Country

    n/a

    n/a

    n/a

    48

    Optional

    2 characters

    New optional field

    Value Date

    3

    Mandatory

    DDMMYY

    2

    Mandatory

    YYYYMMDD

    Field has changed position and format

    Payment Currency

    4

    Mandatory

    3 characters

    n/a

    n/a

    n/a

    Field has been removed

    Payment Amount

    5

    Mandatory

    N15

    3

    Optional/Mandatory

    N18.2

    Field has changed position and format and is mandatory if Debit Amount is not populated

    Debit Account Reference

    n/a

    n/a

    n/a

    4

    Optional

    16 characters

    New optional field

    Beneficiary Short Code

    6

    Optional

    10 characters

    n/a

    n/a

    n/a

    Field has been removed

    Beneficiary IBAN

    n/a

    n/a

    n/a

    12

    Mandatory

    35 characters

    Field has changed position

    Beneficiary Account Type

    n/a

    n/a

    n/a

    11

    Mandatory

    “Other” or “IBAN”

    New mandatory field

    Beneficiary Name

    7

    Mandatory

    35 characters

    10

    Mandatory

    35 characters

    Field has changed position

    Beneficiary Address Line 1

    8

    Mandatory

    35 characters x3

    13

    Optional

    35 characters

    Field is now optional and has changed position and format

    Beneficiary Address Line 2

    n/a

    n/a

    n/a

    14

    Optional

    35 characters

    New optional field

    Beneficiary Country

    n/a

    n/a

    n/a

    17

    Optional

    2 characters

    New optional field

    Beneficiary Bank Name

    9

    Mandatory

    35 characters

    18

    Optional

    35 characters

    Field is now optional and has changed position

    Beneficiary Bank Code Type

    n/a

    n/a

    n/a

    19

    Mandatory

    For IBAN select “SWIFT” for Other select the ISO country code

    New mandatory field

    Beneficiary Bank SWIFT Code ID Type

    n/a

    n/a

    n/a

    20

    Mandatory

    35 characters

    New mandatory field

    Beneficiary Bank Address Line 1

    10

    Mandatory

    35 characters x3

    21

    Optional

    35 characters

    Field is now optional and has changed position and format

    Beneficiary Bank Address Line 2

    n/a

    n/a

    n/a

    22

    Optional

    35 characters

    New optional field

    Beneficiary Bank Country

    n/a

    n/a

    n/a

    24

    Optional

    2 characters

    New optional field

    Beneficiary Bank ID

    11

    Mandatory

    11 characters

    20

    Mandatory

    35 characters

    Field has changed position

    Beneficiary Reference Line 1

    12

    Optional

    35 characters x3

    26

    Optional

    35 characters

    Field has changed position and format

    Beneficiary Reference Line 2

    n/a

    n/a

    n/a

    27

    Optional

    35 characters

    New optional field

    Beneficiary Reference Line 3

    n/a

    n/a

    n/a

    28

    Optional

    35 characters

    New optional field

    Beneficiary Reference Line 4

    n/a

    n/a

    n/a

    29

    Optional

    35 characters

    New optional field

    Intermediary Bank Name

    n/a

    n/a

    n/a

    30

    Optional

    35 characters

    New optional field

    Intermediary Bank Code Type

    n/a

    n/a

    n/a

    31

    Optional

    ”UK2 or “SWIFT”

    New optional field

    Intermediary Bank Code

    n/a

    n/a

    n/a

    32

    Optional

    34 characters

    New optional field

    Intermediary Bank Address Line 1

    n/a

    n/a

    n/a

    33

    Optional

    35 characters

    New optional field

    Intermediary Bank Address Line 2

    n/a

    n/a

    n/a

    34

    Optional

    35 characters

    New optional field

    Intermediary Bank Address Line 3

    n/a

    n/a

    n/a

    35

    Optional

    35 characters

    New optional field

    Intermediary Bank Country

    n/a

    n/a

    n/a

    36

    Optional

    2 characters

    New optional field

    Comments

    n/a

    n/a

    n/a

    37

    Optional

    140 characters

    New optional field

    Beneficiary Account Number

    13

    Mandatory

    34 characters

    10

    Mandatory

    34 characters

    Field has changed position

    Pay on Application

    13

    Optional

    1 character

    n/a

    n/a

    n/a

    Field has been removed

    Debit Account Code

    14

    Optional

    10 characters

    n/a

    n/a

    n/a

    Field has been removed

    Debit Account

    15 and 16

    Mandatory

    6 characters and 8 characters

    5

    Mandatory

    [Sort Code]-[Account Number] 15 characters

    Sort Code and Account Number are now in a single field separated with a hyphen.

    Debit Amount

    n/a

    n/a

    n/a

    7

    Optional

    N18.3

    New optional field

    Special Instructions

    20

    Optional

    35 characters x7

    n/a

    n/a

    n/a

    Field has been removed

    FX Contract ID

    21

    Optional

    1 character and N10 or AGREED

    9

    Optional

    16 characters

    Field has changed position and format

    FX Exchange Rate

    22

    Optional

    15 characters

    8

    Optional

    N10

    Field has changed position and format

    Charges

    23

    Mandatory

    1 character

    25

    Mandatory

    3 characters

    Field has changed position and format

    Remittance Advice Debit Account Name and Address

    24

    Optional

    35 characters x6

    n/a

    n/a

    n/a

    Field has been removed

    Remittance Advice Beneficiary Name and Address

    25

    Optional

    35 characters x6

    n/a

    n/a

    n/a

    Field has been removed

    Remittance Advice Additional Information

    26

    Optional

    75 characters x22

    n/a

    n/a

    n/a

    Field has been removed

    Remittance Advice Beneficiary Email Address

    27

    Optional

    75 characters

    n/a

    n/a

    n/a

    Field has been removed

    Trailer Indicator

    n/a

    n/a

    n/a

    T1

    Mandatory

    T

    New mandatory field

    A key to the abbreviations used in the tables above

     

    Key 
    PositionThe number shows the field position within the file. Where there are two numeric values, e.g. 3 and 4, this means two fields will be consolidated into one. For example Commercial Banking Online combines the sort code and account number into one field.
    Field Formatn/aNot applicable – this field does not exist
    DDays
    MMonths
    YYears
    N(16.2) means 16 numeric characters with 2 decimal places
    25 characters x 5means five lines of 25 characters
    'H' or 'T'means Header or Trailer

    Check your payment import files are compatible with Commercial Banking Online.

    We have provided a range of example files that demonstrate what a working payment import file will look like on Commercial Banking Online.

    You can use these files to compare them with and make changes to your current import files.

    Find out more about using payment import example files on Commercial Banking Online.

Lloyds Bank plc. Registered office: 25 Gresham Street, London, EC2V 7HN. Registered in England and Wales no. 2065. Authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and the Prudential Regulation Authority. Authorisation can be checked on the Financial Services Register at www.fca.org.uk under the Firm 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.