Examiners recently suggested that I report all CRA activity to the board each month. Has anyone every done this? If so, can you provide a sample format as a guide for me to use?

Ignore the suggestion unless you got a Needs Improvement. It is a ridiculous personal opinion of the examiner only.

I agree with Randy that you don't have to. However, we do. The report simply tells the board what the CRA Officer did during the month such as who he met with (community groups etc), what homebuyer classes were taught by employees/CRA Officer, progress being made on finding CD opportunities or investments, etc.

The examiners are trying to keep your department relevant, and likely suggested this as they believe the bank could do better in their CRA qualified activities.

Just create a fast fact sheet about loans that qualified for CD that month, and forward it to whoever it is supposed to go to. Try using something like the following headers in an excel sheet, and then copy/paste the values out into a word doc and save as a PDF for formatting and professionalism.

Community Development Purpose, Loan number, Borrower Name, Location, Census Tract Designation, Original Loan Amount, Pro Rata %, Pro Rata Benefit

I've seen suggestions like this when examiners identify or predict a deterioration in a bank's CRA posture. I agree that reporting everything CRA to the board each month is excessive, but I would want to know the underlying reason why they suggested this. Basically, did they have justification for the recommendation or was it just their opinion that every rule should have more board reporting?