Exception Tracking Spreadsheet (TicklerTrax™)
Downloaded by more than 1,000 bankers. Free Excel spreadsheet to help you track missing and expiring documents for credit and loans, deposits, trusts, and more. Visualize your exception data in interactive charts and graphs. Provided by bank technology vendor, AccuSystems. Download TicklerTrax for free.
Branch Auditing Workpaper
Chris Kilian, Scott Valley Bank, developed an auditing tool to look at signage and briefly understand the compliance culture and skillset of the branch employees. He uses this as a tool for on-site compliance audits of branches and ATMs. The checklist helps verify that all the required disclosures are correct and prompts interviews of the employee's level of knowledge when it comes to APYs, APRs, the CRA Public File, customer complaints, and NOW account elegibility.
This tool could also be used by sending it to the branches and allowing them to self-test themselves and verify that the signage is properly displayed. The telephone could be used to interview employees.
First published on 04/01/2007