Full Transaction Export Report

4294970475

4294971208

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.

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

Go to the Report Management screen.

Click on the 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.

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 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.

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.

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.

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.

Select whether you want to see Debit or Credit transaction on the report.

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.

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.

Select the Transactions Types you want to see on the report from the onscreen list.

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.

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

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.