Full Transaction Export Report

  • The Full Transaction Export Report gives you the transactions, closing and clearing balances for one or more 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.

    1. You can create this report by clicking the report’s row on the Report Management screen.

      Go to the Report Management screen.
    2. Click on the Down arrow next to Full Transaction Export to open a list of options:
      • View – run a full transaction report
      • Filter – select criteria to run a transaction report
      • Create and Save a Filter - select criteria to run a transaction report and save to your Report Management Screen.
    3. 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.
    4. 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.
    5. Select the Bank ID’s you want to run the report for.
      You can select :
      • All items – To run a Transaction report for all Bank IDs you have access to.
      • Include Items – Select the Bank IDs that you want to use in a Transaction Export by ticking the box against that ID
      • Exclude Items – Exclude Bank IDs from the export by ticking the box against that ID.
    6. Select the Account Group you want to run the report for.
      You can select :
      • All items – To run a Transaction report for all account groups you have access to.
      • Include Items – Select the account groups that you want to use in a Transaction Export by ticking the box against that group
      • Exclude Items – Exclude account groups from the export by ticking the box against that group.
       
    7. Select the Account numbers that you want to run the report for.
      You can select :
      • All items – To run a Transaction report for all accounts that you have access to.
      • Include Items – Select accounts that you want to use in a Transaction Export by ticking the box against that against that account
      • Exclude Items – Exclude accounts from the export by ticking the box against that account.
    8. Select the Currency codes that you want to run the report for.
      You can select :
      • All items – To run a Transaction report for all the currency codes in your selected accounts.
      • Include Items – Select currency codes that you want to use in a Transaction 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.
    9. Select whether you want to see Debit or Credit transaction on the report.
    10. Select the BAI Transaction codes that you want to run the report for.
      You can select :
      • All items – To run a Transaction report for all the BAI codes in your selected accounts.
      • Include Items – Select BAI Transaction codes that you want to use in a Transaction Export by ticking the box against that against that code.
      • Exclude Items – Exclude BAI Transaction codes from the export by ticking the box against that code.
    11. Select the Swift Statement that you want to run the report for.
      You can select :
      • All items – To run a Transaction report for all the SWIFT statement types in your selected accounts.
      • Include Items – Select SWIFT statement types that you want to use in a Transaction Export by ticking the box against that against that type.
      • Exclude Items – Exclude SWIFT statement types from the export by ticking the box against that type.
    12. Select the Transactions Types you want to see on the report from the onscreen list.
    13. Select the Transaction amount, you can choose a minimum or maximum value to run the report on or alternatively choose an exact amount or between a specific range.
    14. If you are running a filter you will now have the following options:
      • View Results - view the Transaction 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 Transaction export report.
      If you chose 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.