How to track mortgage rate lock expiration

Published 16 October 2026. Updated 16 October 2026.

A rate lock is a promise with an end date. The lender holds a rate for a set number of days, and if the loan has not closed by then, the file needs an extension, which usually costs something, or a new lock at whatever pricing applies that day. Most brokerages know this in principle. The failures come from a pipeline where every loan file has a different lock date, in a different document, and nobody is looking at them side by side.

This guide describes a small routine that keeps lock dates visible. It works in a spreadsheet and needs no special tools.

Why do lock dates slip?

Lock dates get missed for ordinary reasons:

• The date lives on the lender's lock confirmation, while the working notes live in the loan origination system or a spreadsheet, so the two drift apart.
• Lock periods differ by lender and by file, so a file locked later can expire sooner than one locked earlier.
• A lock gets extended or re-locked and the old date stays in someone's notes.
• Conditions arrive in waves, and the team works on whichever file called most recently, not whichever has the fewest days left.

What should you record for every loan file?

Keep one row per loan file with the same few columns:

Copy the expiry date from the confirmation document itself. A date remembered from a phone call is the one that turns out to be wrong.

How to rank by days left and check the margin

Sort the sheet by days left, soonest first. Then, for the files at the top, ask a second question: is the margin real?

1. Subtract the expected closing date from the lock expiry. A margin of zero or less means the lock expires on or before the day of closing.
2. Check what the lock has to cover. Some lenders need the loan to fund, not only to be signed, before the lock expires, and on most refinances of a primary home the borrower's three-business-day right to cancel pushes funding past the signing date. The lock confirmation or the lender's lock policy says which date counts.
3. Count the open prior to docs items on the file. Each one is a reason the closing documents may be late. See prior to docs and prior to funding conditions.
4. Mark any file where the closing is likely to run past the lock. Those are your extension candidates.
5. Decide on the extension early. Asking for one with several days left gives you time to compare options. Asking on the last day does not.

A file with 20 days left and six open prior to docs items can be riskier than a file with 6 days left and nothing open. The ranking tells you where to look first, and the margin tells you what to do.

What does a daily routine look like?

1. Update the days left column. If it is a spreadsheet formula, check that it still points at today's date.
2. Read the top five rows each morning: loan number, days left, what is blocking it.
3. For each, name the owner of the blocking item: the borrower, the processor, the title company or a third party.
4. For any file whose lock was extended or re-locked, replace the expiry date with the one on the new confirmation.
5. Note any file where no lock date can be found. It needs a call to the lender, and it should not sit at the bottom of the sheet by default.

What if a lock has to be extended?

The principle is the same in every case: decide before the last day, and put the cost in front of the borrower and the broker-owner while there is still a choice. What an extension costs, how many days it buys and whether a new lock is cheaper are all set by the lender, so read that lender's lock policy and the confirmation. Do not assume the terms from a previous file with a different lender.

Be careful with money talk. Who pays an extension fee depends on the lender's terms, your agreement with the borrower and your compliance rules. Check with your compliance contact before you promise anything.

Common mistakes

• Using the lock period in days and counting from the wrong start date.
• Keeping the expiry in a note field that nobody sorts.
• Ranking only by days left and ignoring the number of open items.
• Forgetting that a re-lock replaces the old date.
• Leaving files with no lock date at the bottom of the list, where they hide.

How ConditionPilot does this step

ConditionPilot builds the lock-ranked queue for you. Upload the lender's condition sheet for each loan file, and add the rate lock confirmation if you have it. A model reads the lock expiry from the confirmation or the sheet, code checks that the date, year included, is printed in the quoted line on its page, and code computes the days to expiry. The queue is ranked with the soonest expiry first, and a lock that has already passed reads "expired 3 days ago" and goes to the top. If the documents of one loan file give different expiry dates, the earliest is used and the difference is listed for you to check.

The queue comes as an Excel workbook, with a sheet of every condition. The items to check come first in the PDF, and in a separate CSV file. A loan file where no lock date can be found ranks after every file with a confirmed date, and it is listed as something to check. ConditionPilot does not extend or change a lock, and it does not read a lock from a scanned page or photo. It also does not keep a running queue across jobs yet, so each job ranks the files you uploaded together. A job takes up to 10 loan files, at 6 credits each. Sign up to try it.

Questions

Where is the rate lock expiration date found?

On the lender's rate lock confirmation. The condition sheet may not show it at all. Read the confirmation for each loan file and write the date down exactly, year included.

What happens if a lock expires before closing?

The usual choices are an extension, often for a fee or a price change, or a new lock at the lender's pricing on that day. The terms are set by each lender, so check the lender's lock policy.

Do weekends count when counting lock days?

Lock periods are usually counted in calendar days, but what happens when the expiry falls on a weekend or holiday differs by lender. Check the lender's lock terms before you rely on a count.