We build a variety of data tools to assist compliance monitoring and risk assessments.  Some are simple spreadsheet tools like a Reg CC “quick calc” spreadsheet to assist tellers calculate how much cash will be immediately available for otherwise “held” deposits.  Other tools are nested spreadsheets.  Or, Excel VBA macros that perform in seconds what a human could do in half day.

Click here to see a list of common data tools in use in our client’s offices.

Reg CC Quick-Calc XL Sheet

Customer News Aggregator

MS Access Reports Compliance Management Reports

Aggregation Reports BSA Accounts Risk by Type

Aggregation Reports BSA Accounts Risk by Customer/Entity Type

BSA Medium and High Risk Reports

Data Validation Procedures

Cross Sell Report (Household Penetration Reports)
   This report uses VBA macro to reduce 4 hour task to 10 minutes.
   It consolidates 12 separate reports

All Account Geocoding Reports including HIDTA, HIFCA and Non-US