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.
Loan Accounting System Worksheets
Carol Tucker of EagleBank, MD, uses the new loan input sheet to take all of the information that is in the note [supplemented by approval documents, commitment letters and due diligence that has been completed] and translate it to the terms and conditions for the loan accounting system. The review form enables a quick check of the information to the LAS for accuracy and completeness, as well as making sure the information is recorded in other systems.
The real value is that you can have a lower level of expertise needed to input data because the person inputting is not interpreting the terms and conditions -- not only does that help allocate resources more effectively, but it aids in the segmentation of duties.The latter has become a big focus in the Fed's safety and soundness exams!
Carol also provided a loan input worksheet form you may find useful or to use as a "go-by" as you develop your own.The Word version is set as a form for tabbed input.
First published on 01/15/2005