Skip to content

Alogent recently created a new spreadsheet that helps bankers calculate the cost of their current exception tracking workflows.

Modern Payments Infrastructure: 1 Platform, 1 API, All Channels
Is it time for a solution refresh? Legacy processes can’t always keep up. Ask yourself these questions to assess your payments modernization goals and explore the benefits of a single platform for all Day 1 and Day 2 processing.

Click Now!


TRID Date Calendar

Confused by the TRID date rules? Based on the application date, when is the Loan Estimate required to be delivered, when is it considered received, how do Changed Circumstances change things, when are Closing Disclosures required and when can you close the loan?

BOL user Carolina Blue created a calendar tool in Excel. There are two tabs:

  • one for calculating the earliest possible closing date based on when the Loan Estimate(s) and Closing Disclosure are issued/received and
  • one provides the latest possible date the Loan Estimate(s) and Closing Disclosure can be given to meet a desired closing date.

Select which tab you want and complete the green fields (and one yellow field) when prompted.

NOTE: The password to unlock both tabs is TRID in the event you need to customize this tool. You will need to have Excel 2010 or later for the tool to work properly.

TRID (v4) is contributed by "Eldon96" and is an enhanced version for use especially by those with older versions of XL or who don't have the ability to work with add-ins on the XL program itself. Saturdays can be selected or deselected, using Y or N in the Holidays tab. No add-ins are required. For those wondering what the differences are, this includes day calculations in the hidden columns that take the place of the workdays.intl() and networkdays.intl() functions added in XL versions 2010 and above. It’s a simple solution and only wouldn’t work if there were more than 3 days back to back that were Sundays and holidays. A third sheet was added with the holiday list rather than have two hidden lists for each sheet. It’s protected but not hidden.

Beginning with TRID (v4.3) we've included Juneteenth, June 19 of each year beginning in 2021, as a federal holiday.

Version 6.1 has been added to include Oct 2017 thru 2023 holidays. What changed this year was "Earliest Closing Date" cell A24 was changed to read, "Enter evidenced date of CD receipt. If not a business day, choose the next business day." The "choose next business day" was added. One mortgage lender commented that it is common for a borrower to get the CD on a holiday, and she insisted this should be the next business day in the box to avoid potential errors. This should allow the Earliest Closing Date tab to match the Desired Closing tabs results. Also, cell B28 on the "Desired Closing" tab was supposed to be locked. It was also supposed to have a formula in it. Here in version (6.1) where I added that formula back in as it was removed in v6.

Version 7.1, with holidays for 2024 is ready. Version 7 had an error extending the days until closing artificially. It would not have caused a violation, but rather an inconvenience to the borrower wanting to close as soon as possible.

**Users need to verify the complicated TRID requirements in all fields, but especially when a static date holiday falls on a Sunday. As an example, in 2022, June 20, 2022, was a business day based on the precise definition; it was not counted as a holiday for the precise definition. But, if the bank was open for substantially all business, it was counted as a business day using the non-precise definition. If an application was received 6/16/22, the LE had to be sent by 6/21 if the bank was not open for business on Saturdays but was open on the 20th. But by 6/22 if the bank was closed Saturdays and not open on the 20th.

As always, these and our other tools are not guaranteed and the user is ultimately responsible for ensuring their dates are compliant with the regulatory requirements applicable.

First published on 12/20/2023

Last updated on 12-20-2023

Search Tools