Skip to content

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.

Click Now!


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

Filed under: 
Filed under lending as: 

Banker Store View All

From training, policies, forms, and publications, to office products and occasional gifts, it’s available here:

Banker Store

hot right now

image description

Looking for effective, convenient training on a particular subject?

BOL Learning Connect offers more than 200 courses ON-DEMAND or on CD ROM from AML to Reg Z and every topic in between.

Search Tools