I want to filter an administration report

  • Filter an administration report to display only the information in which you are interested. Once you have filtered the report, you can export it to a range of file formats or print it for review away from Commercial Banking Online. Alternatively, save a filtered report view that you can re-use whenever you need to.

    It is not possible to filter a Role Audit History Report. 

    1. On your Administration page, click Administration reports to display the Report Management screen.
    2. Click Down arrow in the report’s row and select Filter from the pop-up menu displayed.
      Filter pop-up menu
    3. The filter options for the report are displayed. To add filters to the report, click + next to the type of report value you want to filter on, then, depending on the type of value you’re using to filter, tick the box next to each value you want to include in the filter or select a value operator and enter a filter value.  
      Filter Options
      The Date section lets you specify an exact time period over which you would like to view a report. You can either specify actual dates or date descriptions to describe the date range of the report. The descriptions are:
      • Today: this is the current date
      • Yesterday: this is yesterday’s date
      • Start of this week: this is the Monday of the current week
      • Start of last week: this is the Monday of the previous week
      • End of last week: this is the Sunday of the previous week
      • Start of this month: this the first day of the current calendar month
      • Start of last month: this is the first day of the previous calendar month
      • End of last month: this is the final day of the previous calendar month

    4. When available, the Sort section will also be displayed. This allows you to sort the report data using a specified report value.
      Sort
      • Select the report value you want to sort the report on and select Ascending or Descending, as required.
      • If you want to add more than one sort to the report, click Add More
       
    5. When you are ready to view the filtered report view, click View Results.
    6. Export the report data or print the report, as required.
    7. Once you have finished viewing the filtered report view, click Cancel. You are returned to the Report Management screen.

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.