• Guidance: importing PC Pay in Commercial Banking Online (CSV file) for LloydsLink customers

    Last updated:  07  December  2015

    Importing PC Pay in a CSV file

    Importing PC Pay payments to Commercial Banking Online will be different to importing them in LloydsLink:

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

    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.

    PC Pay

    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

    Beneficiary Sort Code

    Value Date

    Filter Description

    Date

    Beneficiary Account Number

    Batch Description

    Version

    Sequence

    Beneficiary Name

    Comments

    Freeze

    Debit

    Payment Reference

     

     

    Debit Account Number

    Payment Amount 

     

    Credit

       

    Trailer Indicator

       




    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 Indicatorn/an/an/aH1MandatoryHNew mandatory field
    Daten/an/an/aH2MandatoryYYYYMMDDNew mandatory field
    Sequencen/an/an/aH3Mandatory35 charactersNew mandatory field
    Filter DescriptionH1Mandatory35 charactersn/an/an/aField has been removed
    VersionH2Mandatory10 charactersn/an/an/aField has been removed
    FreezeH3OptionalYES or NOn/an/an/aField has been removed
    Debitn/an/an/aD1MandatoryDNew mandatory field
    Value Daten/an/an/aD2OptionalYYYYMMDDNew optional field
    Batch Descriptionn/an/an/aD3Optional16 charactersNew optional field
    Debit Account Numbern/an/an/aD4Mandatory[Sort Code] – [Account Number]
    15 characters
    New mandatory field
    Commentsn/an/an/aD5Optional140 charactersNew optional field
    Creditn/an/an/aC1MandatoryCNew mandatory field
    Beneficiary Sort Code1Mandatory6 charactersC5Mandatory6 charactersField has changed position
    Beneficiary Account Number2Mandatory8 charactersC4Mandatory8 charactersField has changed position
    Beneficiary Name3Mandatory18 charactersC3Mandatory18 charactersField has changed position
    Payment Reference4Optional18 charactersC6Optional18 charactersField has changed position
    Payment Amount5MandatoryN11.2C2MandatoryN18.2Field has changed position and format
    Trailer Indicatorn/an/an/aT1MandatoryTNew 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 
    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

    PC Pay Fixed Length

    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

    Beneficiary Sort Code

    Value Date

    Filter Description

    Date

    Beneficiary Account Number

    Batch Description

    Version

    Sequence

    Beneficiary Name

    Comments

    Freeze

    Debit

    Payment Amount

     

    Beneficiary Type of Account

    Debit Account Number

    Payment Reference

     

    Beneficiary Transaction Code

    Credit

      

    Space Padding

    Trailer Indicator

      

    Space Padding





    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 Indicatorn/an/an/aH1MandatoryHNew mandatory field
    Daten/an/an/aH2MandatoryYYYYMMDDNew mandatory field
    Sequencen/an/an/aH3Mandatory35 charactersNew mandatory field
    Filter DescriptionH1Mandatory35 charactersn/an/an/aField has been removed
    VersionH2Mandatory10 charactersn/an/an/aField has been removed
    FreezeH3OptionalYES or NOn/an/an/aField has been removed
    Debitn/an/an/aD1MandatoryDNew mandatory field
    Value Daten/an/an/aD2OptionalYYYYMMDDNew optional field
    Batch Descriptionn/an/an/aD3Optional16 charactersNew optional field
    Debit Account Numbern/an/an/aD4Mandatory[Sort Code] – [Account Number]
    15 characters
    New mandatory field
    Commentsn/an/an/aD5Optional140 charactersNew optional field
    Creditn/an/an/aC1MandatoryCNew mandatory field
    Beneficiary Sort Code1Mandatory6 charactersC5Mandatory6 charactersField has changed position
    Beneficiary Account Number2Mandatory8 charactersC4Mandatory8 charactersField has changed position
    Beneficiary Type of Account3Mandatory1 charactersn/an/an/aField has been removed
    Beneficiary Transaction Code4Mandatory99n/an/an/aField has been removed
    Space Padding5Mandatory18 charactersn/an/an/aField has been removed
    Payment Amount6MandatoryN11.2C2MandatoryN18.2Field has changed position and format
    Space Padding7Mandatory18 charactersn/an/an/aField has been removed
    Payment Reference8Optional18 charactersC6Optional18 charactersField has changed position
    Beneficiary Name9Mandatory18 charactersC3Mandatory18 charactersField has changed position
    Trailer Indicatorn/an/an/aT1MandatoryTNew 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

    PC Pay Standard Format

    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

    Beneficiary Sort Code

    Value Date

    Filter Description

    Date

    Beneficiary Account Number

    Batch Description

    Version

    Sequence

    Beneficiary Name

    Comments

    Freeze

    Debit

    Payment Amount

     

    Beneficiary Type of Account

    Debit Account Number

      

    Beneficiary Bank Branch

    Credit

       

    Trailer Indicator

       


    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 Indicatorn/an/an/aH1MandatoryHNew mandatory field
    Daten/an/an/aH2MandatoryYYYYMMDDNew mandatory field
    Sequencen/an/an/aH3Mandatory35 charactersNew mandatory field
    Filter DescriptionH1Mandatory35 charactersn/an/an/aField has been removed
    VersionH2Mandatory10 charactersn/an/an/aField has been removed
    FreezeH3OptionalYES or NOn/an/an/aField has been removed
    Debitn/an/an/aD1MandatoryDNew mandatory field
    Value Daten/an/an/aD2OptionalYYYYMMDDNew optional field
    Batch Descriptionn/an/an/aD3Optional16 charactersNew optional field
    Debit Account Numbern/an/an/aD4Mandatory[Sort Code] – [Account Number]
    15 characters
    New mandatory field
    Commentsn/an/an/aD5Optional140 charactersNew optional field
    Creditn/an/an/aC1MandatoryCNew mandatory field
    Beneficiary Sort Code1Mandatory6 charactersC5Mandatory6 charactersField has changed position
    Beneficiary Account Number2Mandatory8 charactersC4Mandatory8 charactersField has changed position
    Beneficiary Type of Account3Mandatory1 charactersn/an/an/aField has been removed
    Beneficiary Bank Branch4Optional18 charactersn/an/an/aField has been removed
    Beneficiary Name5Mandatory18 charactersC3Mandatory18 charactersField has changed position
    Payment Reference6Optional18 charactersC6Optional18 charactersNo change
    Payment Amount7MandatoryN11.2C2MandatoryN18.2Field has changed position and format
    Trailer Indicatorn/an/an/aT1MandatoryTNew 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 
    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

    PC Pay Standard Format with Remittance Advice

    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

    Beneficiary Sort Code

    Value Date

    Filter Description

    Date

    Beneficiary Account Number

    Batch Description

    Version

    Sequence

    Beneficiary Name

    Comments

    Freeze

    Debit

    Payment Amount

     

    Beneficiary Type of Account

    Debit Account Number

      

    Beneficiary Bank Branch

    Credit

      

    Remittance Advice Beneficiary Name and Address

    Trailer Indicator

      

    Remittance Advice Beneficiary Email Address

       

    Remittance Advice Additional Information




    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 Indicatorn/an/an/aH1MandatoryHNew mandatory field
    Daten/an/an/aH2MandatoryYYYYMMDDNew mandatory field
    Sequencen/an/an/aH3Mandatory35 charactersNew mandatory field
    Filter DescriptionH1Mandatory35 charactersn/an/an/aField has been removed
    VersionH2Mandatory10 charactersn/an/an/aField has been removed
    FreezeH3OptionalYES or NOn/an/an/aField has been removed
    Debitn/an/an/aD1MandatoryDNew mandatory field
    Value Daten/an/an/aD2OptionalYYYYMMDDNew optional field
    Batch Descriptionn/an/an/aD3Optional16 charactersNew optional field
    Debit Account Numbern/an/an/aD4Mandatory[Sort Code] – [Account Number]
    15 characters
    New mandatory field
    Commentsn/an/an/aD5Optional140 charactersNew optional field
    Creditn/an/an/aC1MandatoryCNew mandatory field
    Beneficiary Sort Code1Mandatory6 charactersC5Mandatory6 charactersField has changed position
    Beneficiary Account Number2Mandatory8 charactersC4Mandatory8 charactersField has changed position
    Beneficiary Type of Account3Mandatory1 charactersn/an/an/aField has been removed
    Beneficiary Bank Branch4Optional18 charactersn/an/an/aField has been removed
    Beneficiary Name5Mandatory18 charactersC3Mandatory18 charactersField has changed position
    Payment Reference6Optional18 charactersC6Optional18 charactersNo change
    Payment Amount7MandatoryN11.2C2MandatoryN18.2Field has changed position and format
    Remittance Advice Beneficiary Name and Address8Optional35 characters x 6n/an/an/aField has been removed
    Remittance Advice Beneficiary Email Address9Optional75 charactersn/an/an/aField has been removed
    Remittance Advice Additional Information10Optional75 characters x 22n/an/an/aField has been removed
    Trailer Indicatorn/an/an/aT1MandatoryTNew 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 
    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

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.