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.
CIP - Risk Analysis Worksheet
Devil Queen, as she is known on the BOL Threads, has contributed her CIP Risk Analysis worksheet. This allows you to take each account and determine a risk level for it based on the account's attributes. Some items considered include the recency of the relationship, whether there is a TIN or not, the owners occupation and more. There are eight areas in total that are reviewed based on this worksheet. You may customize it to your needs.
First published on 03/01/2005