TRID Date Calculation Spreadsheet

TRID calculator

The TILA-RESPA Integrated Disclosure (TRID) rules apply to all closed-end consumer credit transactions to be secured by real estate for which the lender received initial application on or after October 3, 2015. Even if the loan funds will be put to a non-related consumer purpose, such as when the consumer uses the loan funds to pay for a child’s wedding, the TRID rules apply.

In a departure from earlier rules, the TRID rules apply to the following:

  • Vacant land loans
    • Regardless of whether loan funds will be used to erect a structure on the site.
  • Temporary financing
  • Timeshares


The rules do not extend to HELOCs, which are covered elsewhere in Regulation Z, or business-purpose loans. 


When to use: Complete the calculation form with any closed-end consumer application to be secured by real estate. 

There are 2 tabs within the TRID Date Calculation Spreadsheet:

  • 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 Disclosures can be given to meet a desired closing date. 


To access the calculator click here: TRID-Date-Calculation.xlsx

Was this article helpful?

Can't find what you're looking for?

Our award-winning customer care team is here for you.

Contact Support