I want to create a Full Balance Export

  • The Full Balance Export Report gives you all the balance information for specified bank accounts that you’re entitled to view, according to the payments and cash management Roles assigned to you, during a specified time period. The data is presented in a simple format suitable for exporting for use with your organisation’s applications or spreadsheets.

    • Go to the Report Management screen.
    • Click on the Down arrow next to Full Balance Export to open a list of options:
      • View – run a full balance report
      • Filter – select criteria to run a balance report
      • Create and Save a Filter - select criteria to run a balance report and save to your Report Management Screen.
       
    • If you choose to Create and Save a Filter you will be asked to enter a name for the Filtered report which will be displayed in the Report Management screen and a description of the report.
    • Enter an Actual date or Date description in the Posting Date section. We recommend using a date description if you are going to save this Filter.
    • Select the Bank ID’s you want to run the report for.
      You can select :
      • All items – To run a Balance report for all Bank IDs you have access to.
      • Include Items – Select the Bank IDs that you want to use in a Balance Export by ticking the box against that ID.
      • Exclude Items – Exclude Bank IDs from the export by ticking the box against that ID.
       
    • Select the Account Group you want to run the report for. You can select :
      • All items – To run a Balance report for all account groups you have access to.
      • Include Items – Select the account groups that you want to use in a Balance Export by ticking the box against that group.
      • Exclude Items – Exclude account groups from the export by ticking the box against that group.
       
    • Select the Account numbers that you want to run the report for. You can select :
      • All items – To run a Balance report for all accounts that you have access to.
      • Include Items – Select accounts that you want to use in a Balance Export by ticking the box against that against that account.
      • Exclude Items – Exclude accounts from the export by ticking the box against that account.
       
    • Select the Currency codes that you want to run the report for. You can select :
      • All items – To run a Balance report for all the currency codes in your selected accounts.
      • Include Items – Select currency codes that you want to use in a Balance Export by ticking the box against that against that currency.
      • Exclude Items – Exclude currency codes from the export by ticking the box against that currency
       
    • If you are running a filter you will now have the following options:
      • View Results - view the Balance export as based on the criteria you’ve added
      • Save – Save the filter so that it appears on your report management screen, this will require giving the filter a name and a description
      • Saved Filters – access previously saved filters
      • Clear – clear the form
      • Cancel – return to the report management screen without running a Balance export report.


       If you choose to Create and Save a filter you will now have the following options:

      • Save – Save the filter so that it appears on your report management screen.
      • Cancel – return to the report management screen without saving your filter.

       

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.