BSA/SAR Structuring Report

Screen ID:

Screen Title:

Panel Number:

Report Name:

LSARFIL-01

BSA/SAR Structuring Report

6758

LSARFIL

Click here to magnify

Access this screen by selecting Tool #1990 Print BSA/SAR Structuring Report.

For information about configuring your BSA parameters, using this report and the online inquiry, and using the related daily reports, refer to the Bank Secrecy Act Monitoring Tools booklet.

Looking for a simpler BSA report for your daily cash audit? Try the BSA/SAR Activity Report instead, available via Tool 633: Print BSA/SAR Activity Report.

This report provides a more comprehensive and detailed analysis of smaller denomination cash transactions that would normally fall below the standard range for BSA monitoring, to help your auditors look for signs of structuring or other suspicious activity. It uses a separate file from the other BSA report (SARDETAIL) and is organized not only by primary member but by joint owners as well. The report can be organized according to:

Who did the transaction (which SSN/TIN): Sort and stack transactions based on the SSN of the person, looking at what one person does across multiple accounts. This is based on the person served if you use the Currently Serving feature.
Which membership had the activity (which account base): Sort and stack transactions based on the account base of the membership, looking to see if multiple people did something on the same account.
What this person owns, across multiple memberships (including joint relationships): Sort and stack transactions by SSN/TIN; include all activity done by anyone on all accounts where this SSN/TIN is listed as an owner (whether primary or joint), looking for someone trying to hide activity by spreading it across multiple memberships that they own.

IMPORTANT: Depending on the date range and other settings you choose, the calculations done by this report can require an unusually intensive amount of computing power. You’ll see warnings on the screen about the time it may take to generate the report. And once you start the report, you will not be allowed to start another copy until the first one is finished generating. In other words, please be patient!

You can also limit your search to find only transactions over a certain dollar amount. This amount is independent of your normal BSA configuration, so may enter any amount you wish, but BE CAREFUL! The lower you set this amount, the more records will need to be evaluated, causing the report to take much more time to generate.

CU*TIP: AuditLink uses this tool on a daily basis with its clients. Contact them if you’d like advice on the best way to use this tool as part of your daily auditing tasks.

How Do I Save/Retrieve My Report Settings?

For more details on setting up this feature, refer to the Automating Reports and Queries booklet.

This report can be used with the “Report Scheduler,” a time-saving automation feature that allows you to select and save the filters you use to run several commonly used reports and then set these reports to be run automatically by our operations staff on the first of the month. Or you can save the settings and run them manually by yourself at any time.

To save your report settings, first select your filters, including printer (can be a physical printer or the HOLDxx or MONTHxx OUTQs) on any of the selection screens for this report. Then select Save Settings (F24). On the next screen name your settings (we recommend adding your name!), and designate whether you wish to run this manually or if you wish for operations to run the report. At a later time, use Retrieve Settings (F23) to populate the screen with the settings you have saved. You can also edit your settings using Retrieve Settings (F23). All saved settings can be viewed on the Report Automation: Standard Reports screen.

Tips for Selecting Date Settings for Report Automation

We recommend that if you want to automate this report, you use one of the relative date options (Previous Calendar Week or Previous Day, for example) rather than the absolute date options (Specify Data Range and One Month from Archive, specifically), as selecting the absolute options won't adjust the date range automatically during Report Automation, and therefore you'd get the exact same report every time and eventually no data at all as the data falls off in the usual purge cycle.

Additionally, the report automation feature has an option where you can request the report to be pulled as of either Current or Previous month-end. Report Automation will obey these settings, and if the report is set up using one of the relative date options, automation would simply calculate backwards from either the current date OR the prior month-end date.

Field Descriptions

Field Name	Description
Date Range	Choose one of the following: One month from archive – To go back to a full calendar month using data from the BSAMAST month-end snapshot in your archive (usually 6 months are in your online archive). Past 30 day period – To look back 30 days from today’s date. Previous calendar month – To look back at the most recently calendar month. For example, if running this report on September 10th, the month of August will be evaluated on the report. Previous calendar week – To look back at the prior full 7-day calendar week. For example, if running this report on Tuesday, the previous full calendar week (through Sunday) will be included. Previous day – To look back at the prior calendar day. Specify range– To specify a specific from and to date range. WARNING: Depending on how many days are selected, the report may take a long time to generate!
Select month/year	(Appears after a date range of “One month from archive” is selected.)Enter the month and year for a previous calendar month. If the month is no longer in your online archive (typically 6 months) a message will appear.
From / to	(Appears after a date range of “Specify range” is selected.) Enter a beginning and ending date range. Data must be available from your online archive (typically 6 months). WARNING!!Any range longer than a week will require more than 15 minutes to run. A range longer than month may require an hour or more. You will not be able to start another report until the first one is complete.
SSN/TIN	To limit the report to a single member, enter a SSN/TIN here. Leave the field blank to include all accounts.
Organize data according to	Choose one of the following: Who did the transaction (sort/stack by SSN/TIN for the person served) Which membership had the activity (sort/stack by ACCTBS for the activity account) What this person owns (sort/stack by SSN/TIN: include all activity by anyone on all accounts where this SSN/TIN is an owner) See below for samples of the reports that will be generated.
Report daily transaction amounts equal to or over	Enter a dollar amount to limit which individual transactions should be gathered and tallied on the report. This can be any amount, but BE CAREFUL! The lower you set this amount, the more records will need to be evaluated, causing the report to take much more time to generate.
Export report to file	Check this flag to export the data from the report, either the list of accounts for Member Connect, or the complete list of records on the finished report, to a file. An export window will appear. (A report will still be generated to your selected printer/output queue, too.) Remember that the file won’t be ready until the report is done.

Report Sample

If “Who did the transaction (sort/stack by SSN/TIN for the person served)” is selected:

If “Which membership had the activity (sort/stack by ACCTBS for the activity account)” is selected:

If “What this person owns (sort/stack by SSN/TIN: include all activity by anyone on all accounts where this SSN/TIN is an owner)” is selected: