Know Which Documents in a Loan File Have Gone Stale
The file was ready in July. The appraisal came in low, the borrower disputed it, and now it is September and half the documents in the folder are too old to close on.
The short answer
Documents in a loan file age at different rates, and a file that stalls quietly outlives some of them. The dates are all readable: a paystub covers a pay period, a bank statement covers a month, and a credit report or an appraisal carries the day it was produced. A workflow on the On a Schedule trigger runs over the open loan folders, the Read Details from File and Ask AI About the File steps read those dates off the documents, and the Send a Message step reports which ones have aged far enough that they will need refreshing before closing.
Steps this uses
Before and after
What actually changes
As they arrive
- Loans/2026-004182/paystub.pdf
- Loans/2026-004182/statement.pdf
- Loans/2026-004182/credit.pdf
- Loans/2026-004182/appraisal.pdf
After the workflow
- Loans/2026-004182 Nakamura/2026-06-15-paystub-jun-01-15.pdf
- Loans/2026-004182 Nakamura/2026-06-30-bank-statement-june.pdf
- Loans/2026-004182 Nakamura/2026-07-02-credit-report.pdf
- Loans/2026-004182 Nakamura/2026-08-20-appraisal-1140-cedar.pdf
The same four documents, renamed by the date printed on each page. The weekly run reads those dates and reports the first three as due for refreshing before a September closing.
Setting it up
Described once, then it runs
This is the sentence. Send it to the builder and the steps below appear on a canvas, wired and named, for you to change before anything runs.
Every week, go through my open loan folders, read the dates off the paystubs, bank statements, credit reports and appraisals, and email me a list of the documents old enough that they will need refreshing before closing.
Put the document date in the filename first
This is the whole trick. If a paystub is named with the pay period it covers, the folder is already telling you what is old. The Rename step writes that in at the moment the document arrives, months before anybody asks.
Read the date on the page, not on the file
A bank statement downloaded in September can cover July. When the file was created says nothing useful, which is why the date has to come off the document itself.
Run it weekly over open files only
The Check File Details step narrows the run by where a file sits, so closed and withdrawn loans are not revisited every week for no reason.
Report the list, do not act on it
What an aged document needs is a decision: request it again, or do not, depending on where the file is and what it is going to. The report is the useful output and the action stays with a person.
Every document ages on its own clock
A paystub is about the pay period it covers. A bank statement is about a month. A credit report and an appraisal carry the day they were produced. These are different kinds of date with different shelf lives, and the limits come from the programme and the investor rather than from the document. What a workflow contributes is not the rule, it is the visibility: the dates are sitting on the documents and nobody reads them until the week of closing.
The files that stall are the ones this catches
A file that moves from application to closing in three weeks rarely has a staleness problem. The one that hits a dispute, a repair negotiation or a slow condition sits for two months and quietly outlives its own paperwork. Those are also the files everybody has stopped looking at, which is why a weekly pass over open folders is worth more than a careful check at the end.
What it does not do
It reads the dates off the documents in a folder and reports which ones are old. It does not know your investor overlays or the programme the loan is going to, so it reports age rather than compliance. It does not request the replacement, and it does not decide whether an aged document still works for a particular file. Those are decisions with a rule behind them and they belong to the person who knows the rule.
Limits
What to know before you build it
It can work through what is already there
This one runs on a schedule over a folder you point it at, so the documents sitting in it now are read and filed alongside the ones that arrive later. A large backlog is an overnight job rather than an instant one, because each document is read rather than pattern-matched.
What you need to run it
Pointed at a folder in The Drive AI, this works on every plan including the free one, because the files are already here. Pointing it at a Google Drive, OneDrive, SharePoint or Dropbox folder instead means connecting that account, which is on the Max plan or any team workspace.
FAQ
Common questions
Which mortgage documents go out of date?
The ones tied to a moment rather than to a fact. Paystubs and bank statements are about a recent period, and a credit report or an appraisal carries the day it was produced. Identification and tax returns are far more stable. The exact limits come from the programme and the investor rather than from the document itself.
How do you know a document has aged out?
By the date printed on it, not the date the file was saved. A statement downloaded today can cover a month from last quarter. Writing the document date into the filename when it arrives is what makes the whole folder readable later without opening anything.
Can this request the replacement automatically?
It reports what is old. Requesting the replacement is a separate collection, and a checklist is the right tool for it, because that ask needs to be tracked rather than just sent.
Why run it weekly rather than before closing?
Because a document found stale in the closing week is a delay, and the same document found stale six weeks earlier is an email. The entire value sits in the distance between noticing and needing.
Find out in August, not in September.
A weekly pass over open loan folders, reading the dates off the documents themselves.
5 GB free · No credit card required