Thread Options
#2054453 - 12/16/15 05:33 PM BSA manual monitoring
rsanders Offline
Member
Joined: Feb 2010
Posts: 72
Does anybody have a template for a spreadsheet or anything used to track transactions for suspicious activity? I'm looking for ideas on how to best manually track cash in or out so that I can look for trends. I have cash reports that I review daily that show all cash transactions over 3,000. And a have a report that I review daily that shows a rolling week of cash transactions in and out per customer. I just need help deciding how to best consolidate that information to see if Jon Doe is conducting certain transactions repeatedly.

Return to Top
BSA/AML/CIP/OFAC Forum
#2054456 - 12/16/15 05:39 PM Re: BSA manual monitoring rsanders
New Manager Offline
100 Club
Joined: Jan 2004
Posts: 136
We produce a report through our AML software. It shows all cash transactions 6,000.00 to 10,000.00 sorted by customer. We pull it for a rolling three months and look for trends, take a sampling to verify alerts were created, etc.. Other than that, we reply on our AML software to produce alerts.

Return to Top
#2054459 - 12/16/15 05:46 PM Re: BSA manual monitoring rsanders
Doug Hendrickson Offline
Power Poster
Doug Hendrickson
Joined: Oct 2009
Posts: 3,927
We also can pull reports from our core processor for a period of time. Check to see if your core of AML software has such a report.
_________________________
I hear and I forget. I see and I remember. I do and I understand.--Confucius

Return to Top
#2054462 - 12/16/15 05:47 PM Re: BSA manual monitoring rsanders
rsanders Offline
Member
Joined: Feb 2010
Posts: 72
What kind of AML software do you use?

Return to Top
#2054467 - 12/16/15 06:16 PM Re: BSA manual monitoring rsanders
New Manager Offline
100 Club
Joined: Jan 2004
Posts: 136
We use Verafin.

Return to Top
#2054608 - 12/17/15 12:46 AM Re: BSA manual monitoring rsanders
ItNeverEnds CRCM Offline
Platinum Poster
Joined: Oct 2006
Posts: 992
Looking for my sanity
Mine is pretty basic, just an excel spreadsheet with filters on the column headers so I can filter by last name, SSN, etc. We manually input all cash transactions from our core. It works great for a small bank. Been using it for about 10 years.
_________________________
"The reason I talk to myself is because I'm the only one whose answers I accept."
- George Carlin

Return to Top
#2054861 - 12/17/15 09:36 PM Re: BSA manual monitoring rsanders
Just Jean Offline
Platinum Poster
Joined: Feb 2002
Posts: 582
USA
We are truly manually monitoring through use of an Excel spreadsheet. I can track trends across the month (or within the month, especially if the activity is just beginning).

Return to Top
#2054991 - 12/18/15 05:35 PM Re: BSA manual monitoring rsanders
Sherlocked Offline
Member
Joined: Dec 2013
Posts: 82
221B Baker St.
We used to use an excel spreadsheet and entered our large $ ins and outs from core reports daily. You can sort by any field you like. We caught structuring this way, but it is labor intensive.
_________________________
"I’m not a psychopath. I’m a high-functioning sociopath. Do your research.” -Sherlock

Return to Top
#2056768 - 01/05/16 05:40 PM Re: BSA manual monitoring rsanders
Lisa Offline
New Poster
Joined: Sep 2015
Posts: 21
I am wondering what cash threshold others are using to capture and monitor cash deposit and withdrawal transactions? Currently our tellers are instructed to ask customers the source or purpose of cash on all transactions over $3,000. We are being told that our bank is too strict. What are you doing? Thanks, Lisa.

Return to Top
#2056772 - 01/05/16 05:45 PM Re: BSA manual monitoring rsanders
Lilly C Offline
100 Club
Lilly C
Joined: Dec 2004
Posts: 209
Sunny Florida
We are doing $3,000 as well. I hear grumblings every now and then. I don't think it's strict. We've had customers split the cash between the branches.

Return to Top
#2056777 - 01/05/16 05:55 PM Re: BSA manual monitoring rsanders
Doug Hendrickson Offline
Power Poster
Doug Hendrickson
Joined: Oct 2009
Posts: 3,927
We used to have a $3,000 limit that we've now bumped up to $4,000.
_________________________
I hear and I forget. I see and I remember. I do and I understand.--Confucius

Return to Top
#2056783 - 01/05/16 06:05 PM Re: BSA manual monitoring rsanders
bcompliance Offline
Diamond Poster
Joined: Sep 2014
Posts: 1,228
We are using $3,000 but most of our tellers will send an alert for anything over $1,500. Not sure why.
_________________________
CRCM, CAMS

Return to Top

Moderator:  Andy_Z