Can anyone offer me an example of a good SAR Activity Log? One that can keep track of 90 day review due dates and also one that can document why a SAR was NOT filed.

Thanks in advance!

I use a simple spreadsheet, listing the date filed, reason for filing, amount involved, account number/names. I then have another column, based on the date filed, that is 90 days from that date so I know by when I have to review for possible re-filing, as well as a 'status' column for what my review found. I haven't added when a SAR was not filed, but could probably use the same spreadsheet with a column to denote non-filing.

We've just recently installed the Banker's Toolbox product, BAM, so I'll be using that in the future to track SARs and those not filed.

I have a similar spreadsheet as Doug, but I also have a column to just note the date that I reported to the board and I do track on here SARs not filed. No extra column needed just simply column heading is 'SAR filed' and the input is yes or no. By having all accounts reviewed in one spot it is just handy to have it all in one place when examiners ask.

I used to use a spreadsheet as well. One tab for SARs filed & one tab for SARs not filed.

Back when I was working with BSA as a banker, I created an Access data base. It had dates, a field (Y or N) for whether a SAR was filed, drop downs for reason (kiting, structuring, etc.) so we could pull stats on filing, all of the data we needed.

It was pretty cool and worked well for us.

You could do the same in Excel. I liked Access because I had reports set up to export..querying by date...that I could use for the Board, etc. You could potentially do that with pivot tables.