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.
HMDA Checklist and Data Collection
Sarah D. Scott, VP Compliance & CRA at Heritage Oaks Bank provided BOL with two tools she developed for her bank for HMDA.The HMDA Data Collection Form, and a template for tracking HMDA records and problems.Her bank was having HMDA errors and they were trying to drill down and figure out who was making them, and what type of errors were being made repeatedly.
The chart is set up so that each loan can be entered, along with the names of the lender (loan officer) originating the loan and the loan processor.If there is something wrong with a particular data item, they mark the box with an "X".If there is a problem with documentation, they mark the box with a "??".On the main page, the errors tally by loan.However, there are also two other tabs with pivot tables, and they are able to determine how many errors or loan documentation problems there are for each lender and processor.(The names on the template are there for demonstration purposes.)
First published on 03/01/2013