I agree. I created my own excel spreadsheet to record the results of the 3rd review which I perform of most of the REG CC holds that are created. worksheet #1 2013 has all 26 branches listed with 6 columns for each branch which are: Total Holds, # Holds Reviewed, # Regulation Errors, Regulation Error Percentage, Bank Procedure Errors, and Bank Procedure Error Percentage.
I have 5 rows per month going down. week 1-4 totals and month totals. I know 4 weeks does not make a month but I just slide the partial weeks into the first or last week of the month.(weekly numbers are not compared to each other) I set it up by week because I double check the branch's 2nd review on a weekly basis and this report works for that.
Worksheet #2 is 2013 Errors by Person Responsible which has columns: Business Date, User ID, Name of Person Entering Hold, 2nd Reviewer's Name, Branch, Error Reason, Customer Last Name.
I should note that I hold the reviewer responsible for any errors that make it through the branch 2nd review process.
It is very easy to set up the excel spreadsheet to calculate percentages. The Chief Compliance Officer then extracts monthly data from my report and reports it to the Enterprise Risk Management Committee and to the Audit Committee of the Board of Directors.
I have used the data to inform the Retail Staff of any trends in errors.