• 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

The products and services outlined on this site may be offered by legal entities from across Lloyds Banking Group, including Lloyds Bank plc and Lloyds Bank Corporate Markets plc. Lloyds Bank plc and Lloyds Bank Corporate Markets plc are separate legal entities within the Lloyds Banking Group.

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. Please note that any data sent via e-mail is not secure and may be read by others.

Lloyds Bank is a trading name of Lloyds Bank plc, Bank of Scotland plc and Lloyds Bank Corporate Markets plc. Lloyds Bank plc. Registered Office: 25 Gresham Street, London EC2V 7HN. Registered in England and Wales no.2065. Bank of Scotland plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC327000. Lloyds Bank Corporate Markets plc. Registered office 25 Gresham Street, London EC2V 7HN. Registered in England and Wales no. 10399850. Authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and the Prudential Regulation Authority under registration number 119278, 169628 and 763256 respectively.

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

While all reasonable care has been taken to ensure that the information provided is correct, no liability is accepted by Lloyds Bank for any loss or damage caused to any person relying on any statement or omission. This is for information only and should not be relied upon as offering advice for any set of circumstances. Specific advice should always be sought in each instance.