CSV Export on Commercial Banking Online

  • The CSV export is a method for downloading your Commercial Banking Online account information for upload into other financial systems. On Commercial Banking Online, data can be downloaded from a number of different areas including the Download Data Export section or from the Bank Account Summary or by having first selected a number of the Information Reporting reports i.e. Running Balance Report or Balance and Transaction Report. These will be covered in separate detail below;

    Balance and Transaction CSV Balance and Transaction CSV Download Data Export

    The Balance and Transaction Download Data Export CSV export file follows the following structure:

    Post Date 
                Account Number 
                            Account Name    
                                         Type
                                   Amount
                             Customer Reference
                Transaction Detail
    Balance
     

    Each line of the CSV export will start populate as per the data table below;

    Field Name Example Characteristics of the Field Record Length
    Post Date DD/MM/YYYY Numerical 10 characters
    Account Number 300000-12345678 GBP Alpha, numeric and special characters 19 characters - made up of Sort code (nnnnnn) + Hyphen( –) + Account number (nnnnnnnn) + Space ( ) +
    ISO Currency Code (GBP)
    Account Name SOCTEST NAMECHANGE Alpha, numeric Up to 39 characters
    Type CHAPS or International Payment Alphabetical up to 30 characters
    Amount 1.42 or -1.42 Numerical Up to 16 characters
    Negative includes a “-“
    Includes a full stop “.” as the decimal separator
    Customer Reference INVOICE 123456  Alpha numeric Up to 18 characters
    Transaction Detail ANDY DIXON        300000000253124371INVOICE 123456    301215     10     19JAN18 09:32     Alpha numeric Up to 90 characters
    Balance 11.33 or -5. Numerical Up to 16 characters
    Negative includes a “-“
    Includes a full stop “.” as the decimal separator


    CSV Transaction Type Codes

    Code Credit
    Description
    Code Debit
    Description
    TRF CHAPS or International Payment DDT CHAPS Payment
    BGC Bank Giro Credits CHK Cheque
    ADV Counter Deposit FPO Faster Payment Sent
    FPI Faster Payment Received 566 Account Debit
    TRF Inter Account Transfer TRF Inter Account Transfer
    STO Standing Order STO Standing Order
    MISCELLANEOUS Refunded Charges MSC Service Charges
    268 Sweeping TRF CHAPS Debit
    399 Sundry Credit MSC International Payment

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.