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!

Reg Z Date Worksheets

Many compliance officers are afraid that the new Reg. Z rules will be confusing and lead to errors as it pertains to revised disclosures and the earliest closing dates now allowed. Working off of the Reg. CC Hold Calculator, Kevin Mitchell CRCM, from Lubbock, TX, responded to a need expressed in the BOL Threads. He created this "Reg. Z - Early Disclosure and Loan Closing Timing Calendar."It is laid out in three tabs in an Excel spreadsheet. There is a tab each for Data Entry, Instructions, and Calendar Calculations.

The Instructions tab is colored purple and explains to the user how to enter the Holiday dates for the current year or for the period being reviewed. The Data Entry (green) tab is to enter the required dates in the green shaded cells. These are the pertinent dates to the application and disclosure timing. All the calculations occur on the third tab where the business days are counted and used for the Lookup function. The output is on the Data Entry tab, displaying the 3rd - 7th Business day.

Bright yellow labels tell the user when the loan may close based on redisclosures being mailed or given in person. All but the green cells requiring input are locked and protected. There is no password so to modify the sheet, just select Tools > Protection > Unprotect Sheet.

Recently added to Kevin's sheet are some modifications by Charles Geimer, CRCM. Charles added the GFE Important Dates Lines 1-4 calculation to the spreadsheet. In Sept. 2012 Charles modified sheet, especially the Instructions tab and added Notes (look for the red triangles in the upper right of a cell, hover over that to see the Note) to explain the requirements of that cell. The Instructions contain information on the Rate Lock dates and why these calculations are done this way.

First published on 06/09/2009

Filed under: 
Filed under compliance as: 
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