Navigation: Reports / Reporting and Statements/ Information Reports 

 Overview

Lloyds Bank Gem Connect offers you a suite of reports to manage and monitor activity across your accounts. You can use filters and date ranges to produce reports for the specific data you require.

The Balance summary and detail report and the Transaction details report provide account balances and transaction details.

The Account management status report provides a summary of all changes made to your accounts and whether they were approved or rejected (and if so, the reason why).

The inter-company lending report gives details of sweeping transactions between different legal entities.

You have the ability to create one off reports, or you can save report criteria so the report can be re-run easily, without setting up the details every time you want the information. You may also edit these saved reports though only the user who has created the report is entitled to do so.

Step 1:

To create a new report, click on the name of the report displayed under the heading “Create new report”. For example, click on “Balance summary and detail” and you will be displayed the parameters you can select to create the report.

Step 2:

Select the relevant parameters within the report.

If you wish to save the report parameters for future use, select “Save report criteria”.

Click on “Generate Report” to run the report.

Parameters for Transaction detail and Balance summary and detail reports

Account: the maximum number of accounts you can select varies, depending on the Delivery method and Format you choose.

• There is a configured limit for the number of accounts you can select when:
• Delivery method = Display online
• Delivery method = Export and Format = HTML, Tab delimited, PDF or Plain text.
• If you breach this account limit, you will see an error message highlighting the limit and asking you to refine your selection criteria to reduce the number of accounts selected.
• A larger number of accounts may be selected when:
• Delivery method = Export and Format = CSV data or CSV consolidated.
• If you breach this higher CSV export account limit, you will see an error message highlighting this limit and asking you to refine your selection criteria to reduce the number of accounts selected.

Transaction groups: defaults to All transactions. Click on the drop down to select other options such as All credit transactions or specific methods of payment.

Date range: click within the Date range box to select either a relative date range (such as “Last week”) or choose a specific start and end date range. If you choose to Export in CSV data or CSV consolidated format, you may choose a larger date range of up to 12 months.

Payment references: defaults to no references. Click on the dropdown to select one or many references to include in your report. Notably, PDF and HTML formats do not include references, even if you select references.

Format: the Transaction details report includes a format “CSV consolidated” . This format includes the GEM account in every row, it has one header only and no line breaks after each different GEM account. The CSV consolidated format includes additional data items, compared to other formats: Credit currency, Bank country, SWIFT BIC and UETR number.

Shared report: Once you have entered your report criteria, if you tick the Shared report tick box and then click on the “Save report criteria” button, this will save your report and share it with all other entitled users within your legal entity. 

Favourite report: If you tick the Favourite report tick box and click on the “Save report criteria” button, this will ensure the report appears at the top of any relevant report searches you undertake.

Save report criteria: When you create a report and click on “Save report criteria”, a pop up will be displayed and you can add a name and a description for the report you want to save. The saved report can then be accessed from the Information reporting home screen. The “Load saved report” section of the home screen will display all saved reports in the drop down list. You run the saved report by selecting the report from the drop down and then clicking on “Go”. You can also edit and delete saved reports.

Reporting larger volumes

As mentioned above, for Transaction detail and Balance summary and detail reports, if you want to report on a larger volume of accounts and/or transactions and/or up to 12 months of data, please choose to Export in CSV data or CSV consolidated format.

There will still be a limit on the number of accounts and/or transactions that can be returned, but the supported volumes for export in these two CSV formats are greater than exporting in other formats or displaying the report online.

When you Export your report in either of these CSV formats and the applicable transactions are above the limit for one report, you will see the Export Reports Summary screen. On this screen, the associated account and transaction details are split across multiple reports. For example, in the Export Reports Summary screen shot below, the first 20000 transactions are shown in the first split report, the next 20000 transactions are shown in the second split report and so on.

On clicking “Download” against each split report you can Open the report or Save it to your own machine.

Please note if you are looking to extract information for a materially large number of accounts or transactions, the Gem Connect online reporting tool is not the recommended mechanism. Please consult your Onboarding & Servicing contact to discuss our SAP Analytics Cloud reporting capability.

A link to the guide for SAP Analytics Cloud can be found here:
User Guide-Analytics.pdf