• Getting to know Commercial Banking Online

    Exporting data

    On Commercial Banking Online, you can export data to use with your local accounting software using these types of file: CSV, BAI, SWIFT MT-940.

    The data export on the new platform will look different to what you use now.

    You may need to make changes to your local reconciliation processes to avoid any problems when you move to the new platform.

    The information and guides below will help you to do this.

  • Exporting Data

  • What's changed?

    Below you can see what’s changed on Commercial Banking Online.

    Statement Report

    The Statement Report on the new platform is in a different format to your current platform. But the content of the reports is similar.

    Column order and format

    Export files on the new platform have a different column order and in some cases the format of the content will change. The guides below show you how these have changed.

    Transaction narratives

    Transaction narratives, codes and identifiers will be different. You’ll see what has changed for each format in the guides below.

    Running reports

    On the new platform statements are known as reports. There is a new way to export data, explained in the video above.

    Other file formats

    Lotus, Quattro & Excel won’t be available in the new platform. You should use the CSV export on Commercial Banking Online instead. APACS will be available later in 2019.

    What you need to do

    You may need to make some changes to your local software package or processes when you start using Commercial Banking Online.

    The guides below will help you to make these changes.

    It’s a good idea to share these guides with your IT support teams before your move, so they are able to make any changes.

    More support

    Find out how to export data on the Commercial Banking Online Support Centre.

Important legal information

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: 0207 626 1500.

Authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and the Prudential Regulation Authority under Registration Number 119278.

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.

Lloyds Banking Group includes companies using brands including Lloyds Bank, Halifax and Bank of Scotland and their associated companies. More information on Lloyds Banking Group can be found at www.lloydsbankinggroup.com