I want to export my Balance & Transaction information in CSV

  • Data Export 

    How you can export your data in Commercial Banking Online

    Duration: 01:15

  • Download your Balance & Transaction information in CSV from Commercial Banking Online. In Commercial Banking Online there are 2 options for downloading information in CSV; balance & transactions, or just transactions.

    Follow the steps below to download your information in a CSV Export from Commercial Banking Online. Click here to see the CSV Export file structure and CSV Transaction Type Codes.

    CSV export screen
    1. Hover over the Reporting link and select Download Data export option.
    2. Select Create Export at the bottom of the screen.
    3. Select CSV (Balance & Transaction) or CSV (Transactions Only) in the Export type dropdown.
    4. Enter a File name for the Export file.
    5. Choose the Date Range for the report to cover.
      To search for specific dates select Date range and enter the Start and End dates of the period you wish to cover.
    6. Select the accounts that you want to run the report for.
      You can select:
      • All items – To export the CSV information for all accounts that you have access to.
      • Include Items – To select accounts that you want to export the CSV information for by ticking the box against that Account.
      • Exclude Items – To exclude accounts from the CSV export by ticking the box against that Account.
    7. Click Create Export to run the CSV export. You will get a message to say that the CSV Export Request has been submitted.
    8. Return to the Download Data Export screen to see your report, click on the Down arrow next to the reports name to either view details about the report or Download the report to your computer.

    CSV Balance & Transaction

    An example file of the data you will receive can be found here

    Data headings:

    Post Date (DD/MM/YYYY)
    Account Number (includes currency code, e.g. 300001-00000001 GBP)
    Account Name
    Customer Reference
    Transaction Detail
    Balance (a running balance of all entries in the file)

    CSV Transactions only

    An example file of the data you will receive can be found here

How helpful is the information on this page?

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