We build a variety of data tools to
assist compliance monitoring and risk assessments.
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