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 Rescission Calendar Calculator

After seeing fellow BOLers excited about a 12 page calendar that calculated rescission periods, Andy Zavoina of BOL decided that Excel should be able to do this easier. With a little scripting help from fellow Netizens, the final product is made available here. The prior versions are available for auditing older loans.

You will input the loan date and the rescission period is calculated according to the Reg. Z time tables. This does allow Sunday and holiday funding, since that is not uncommon in many banks today. If you do not close on these dates, move to your next business day.

This Excel file is ready for use by compliance, audit, lenders, loan representatives, etc., but you have to allow the macro to run for this application to work. This may require that you lower the security setting in Excel's Tools/Macro/Security menu (Developer/Code Tab in Office 2007) before loading the file.

First published on 01/01/2006

Last updated on 01-04-2021

Filed under: 

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