• Guidance: importing Bacs Multiple to Commercial Banking Online (CSV file)

    Last updated:  07  December  2015

    Importing Bacs Multiple in a CSV file

    Importing Bacs Multiple payments to Commercial Banking Online will be different to importing them in your existing online banking channel:

    • Bacs Multiple payment will now be called Bacs Payment on Commercial Banking Online
    • Commercial Banking Online does not allow Bacs to be submitted with other payment types.

    Corporate 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.

    Debit and credit fields

    Bacs multiple imports will consist of debit and credit records, Several credit records can be linked to a single debit record and every debit record must be followed by at least one credit record.

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

    New mandatory fieldsFields have changed position or formatNew optional fieldsRemoved fields
    Unique Sequence NumberHeader IndicatorValue DateRecord Label
    Debit IndicatorBeneficiary Sort CodeCommentsTotal Value of Debits1
    Credit IndicatorBeneficiary Account Number Label Number (Header Label)
    Beneficiary NameImport Date Filler
    Trailer IndicatorDebit Account Number Total Value of Credits1
     Payment Amount Transaction Code
     Debit Reference Total Number of Debits2
     Beneficiary Reference Remitter Sort Code
       Total Number of Credits3
       Remitter's Account Number
       Filler
       Remitter's Name
       Record Label

    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 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

     Corporate OnlineCommercial Banking Online 
    Field namePositionMandatory / optionalField formatPositionMandatory / optionalField formatDescription of the change

    Record Label

    T1

    Mandatory

    4 characters

    n/a

    n/a

    n/a

    Field has been removed

    Header Indicator

    H1

    Mandatory

    UHL

    H1

    Mandatory

    H

    Field has changed position and format

    Beneficiary Sort Code

    P1

    Mandatory

    6 characters

    C5

    Mandatory

    6 characters

    Field has changed position

    Total Value of Debits 1

    T2

    Mandatory

    13 character

    n/a

    n/a

    n/a

    Field has been removed

    Label Number (Header Label)

    H2

    Mandatory

    1 character

    n/a

    n/a

    n/a

    Field has been removed

    Beneficiary Account Number

    P2

    Mandatory

    8 characters

    C4

    Mandatory

    8 characters

    Field has changed position

    Filler

    H3

    Mandatory

    1 character

    n/a

    n/a

    n/a

    Field has been removed

    Import Date

    H4

    Mandatory

    YYDDD

    H2

    Mandatory

    YYYYMMDD

    Field has changed position and format

    Transaction Code

    P4

    Mandatory

    2 characters

    n/a

    n/a

    n/a

    Field has been removed

    Total Number of Debits 2

    T4

    Mandatory

    7 characters

    n/a

    n/a

    n/a

    Field has been removed

    Unique Sequence Number

    n/a

    n/a

    n/a

    H3

    Mandatory

    35 characters

    New mandatory field

    Debit Indicator

    n/a

    n/a

    n/a

    D1

    Mandatory

    D

    New mandatory field

    Value Date

    n/a

    n/a

    n/a

    D2

    Optional

    YYYYMMDD

    New optional field

    Remitter Sort Code

    P5

    Mandatory

    6 characters

    n/a

    n/a

    n/a

    Field has been removed

    Total Number of Credits 3

    T5

    Mandatory

    13 characters

    n/a

    n/a

    n/a

    Field has been removed

    Debit Account Number

    P5 and P6

    Mandatory

    6 characters and 8 characters

    D4

    Mandatory

    [Sort Code]-[Account Number]

    Field has changed format. Sort Code and Account Number are now in a single field separated with a hyphen.

    Remitter's Account Number

    P6

    Mandatory

    8 characters

    n/a

    n/a

    n/a

    Field has been removed

    Filler

    P7

    Optional

    4 characters

    n/a

    n/a

    n/a

    Field has been removed

    Payment Amount

    P8

    Mandatory

    N11

    C2

    Mandatory

    N18.2

    Field has changed position and format

    Remitter's Name

    P9

    Mandatory

    18 characters

    n/a

    n/a

    n/a

    Field has been removed

    Debit Reference

    C9

    Mandatory

    18 characters

    D3

    Optional

    16 characters

    Field has changed position and format

    Beneficiary Reference

    P10

    Mandatory

    18 characters

    C6

    Optional

    18 characters

    Field has changed position

    Record Label

    C10

    Mandatory

    18 characters

    n/a

    n/a

    n/a

    Field has been removed

    Comments

    n/a

    n/a

    n/a

    D5

    Optional

    140 characters

    New optional field. Not passed with the Import.

    Credit Indicator

    n/a

    n/a

    n/a

    C1

    Mandatory

    C

    New mandatory field

    Beneficiary Name

    n/a

    n/a

    n/a

    C3

    Mandatory

    18 characters

    New mandatory field

    Trailer Indicator

    n/a

    n/a

    n/a

    T1

    Mandatory

    T

    New mandatory field

    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.

    A key to the abbreviations used in the tables above

    Key 
    Position The 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

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.