Bank Account Usage sample script Report

A new sample script has been added that reports Accounts and Clients where the same Bank Account or Credit Card Number is used between Clients and Accounts - which may indicate fraud.

It tries to ignore scenarios where a Bank Account is used on multiple Accounts, where one or more Clients are common between the Accounts.

The script creates an Excel Workbook showing each Bank Account or Credit Card, and the number of Clients and Accounts that use each - as well as the number of "Matches" found.

For example, if two Clients, e.g. Mr and Mrs Browne, have a joint Bank Account, but no Account connects them Match will show as 2. But, if they have an Account that connects them, Match will show as 1.

NOTE: This script may take some time to run on large databases.

WARNING: This script creates a spreadsheet including sensitive information, please bear this in mind.

WARNING: This is a BETA script. Please use with caution and check results.

The following new sample Script has been added:

• Script_BankAccountUsageReport.xml
• BETA Version: 1.00 (01/02/2024)
• Script Id "BAUR"