AI Real Estate Contract Review: Deadlines and Contingencies

Coding Liquids tutorial cover featuring Sagnik Bhattacharya for AI Real Estate Contract Review: Deadlines and Contingencies.
Coding Liquids tutorial cover featuring Sagnik Bhattacharya for AI Real Estate Contract Review: Deadlines and Contingencies.

Give an AI assistant the signed contract and every addendum, ask for each deadline with its trigger, day count, clause and page, then check every row against the paper before anything reaches a calendar. The extraction takes minutes. The checking is the real job, because assistants miscount days, apply superseded terms and skip items.

Treat the assistant as a second reader, not the record. The signed contract controls, and the table it produces is a draft until you have checked each line. Forms differ in how they count days and handle weekends, so the example below uses invented terms; read your own form's definitions. This is not legal advice, and questions about what a missed date means go to your broker or a real estate lawyer.

Follow me on Instagram@sagnikteaches

Feed it the signed set, in date order, with handwriting flagged

Most extraction errors start before the prompt, with the wrong documents. Gather the executed contract, every counter-offer, every addendum and any signed extension, and name the files in date order: 01-offer, 02-counter-1, 03-addendum-A. Later documents override earlier ones where they conflict, and the assistant can only apply that rule if it knows which came later. A scan of the first offer sitting in the same folder as the final signed version is exactly how a superseded term gets extracted.

Connect on LinkedInSagnik Bhattacharya

Then think about what the file contains. A purchase package carries names, addresses, bank details for the earnest money and sometimes identity numbers. The assistant needs the dates, parties and clauses, not the account numbers, so blank those out first. Use the tool your brokerage has approved: business plans such as ChatGPT Business, Claude Team, Gemini in Workspace and Microsoft 365 Copilot don't train on business content by default, whereas consumer plans put the choice in a privacy setting. The brokerage rules tutorial for emails, disclosures and contracts covers what offices usually allow.

Subscribe on YouTube@sagnikteaches

File size is rarely the obstacle. A 40-page package sits far below the page limits of the main assistants (Claude, for instance, reads PDFs of up to 1,000 pages, with visual layout supported up to 100 pages). Scan quality is the obstacle. Handwritten changes initialled in a margin, a struck-through date and a stamped "received" mark are the items most likely to be missed or misread. So ask the assistant, as the first step, to list every page it cannot read cleanly and every handwritten or typed-over change it sees, and look at those pages yourself before you read anything else it says.

The Complete Excel Course with AI Integration thumbnail

The Complete Excel Course with AI Integration

From formulas and pivot tables to Power Query, DAX, VBA and AI with Copilot, ChatGPT and Claude — hands-on from the first lesson.

By Sagnik Bhattacharya and Virginia Thorn, Primetime Emmy Award winner

Buy now

An extraction prompt that shows its counting

The prompt below asks for rules as well as dates. A date alone gives you nothing to check; a date with its trigger, counting rule, clause and the assistant's own day-by-day count lets you see where a wrong assumption crept in.

You are helping a real estate agent turn a signed residential purchase contract
into a deadline sheet. The attached documents are the only source. They are in
date order: [01-offer, 02-counter-1, 03-addendum-A]. Later documents override
earlier ones where they conflict.

Step 1. List every document you were given with its page count. Name any page
that is blank, unreadable or skewed, and any handwriting or initials you are not
certain you read correctly.
Step 2. Find every date, period, deadline and condition: effective date, earnest
money, disclosures, inspection, appraisal, financing, title and survey, HOA or
condo documents, sale of the buyer's home, repairs, walk-through, closing,
possession, extensions, and the rules for giving notice.
Step 3. Give one table row per item with these columns: No. | Item | Who must act
| Trigger event | Period exactly as written | Day-counting rule as written | Time
of day | Document, clause and page | Exact words (25 words at most) | Amended or
superseded by | Confidence (High/Medium/Low) and why.
Step 4. Where the trigger has already happened, calculate the date and show the
count one day per line, stating which days you treated as non-business days.
Quote the contract's definitions of "day", "business day" and "effective date".
Step 5. List anything you looked for and did not find, any conflict between
documents, and any deadline whose trigger has not happened yet.
Do not interpret legal effect, say what happens if a date is missed, or advise
whether to waive anything.

Each instruction is there because of a failure it prevents. "Exact words, 25 at most" stops paraphrase, which is where a "within" quietly becomes an "after". "Amended or superseded by" forces the assistant to compare documents instead of reading the first one it meets. The count-by-line requirement turns a hidden assumption, such as treating a public holiday as a working day, into something visible. The last line keeps it out of territory where a confident-sounding answer could mislead you.

One purchase at $485,000, from contract terms to verified dates

Everything in this example is invented, including the clause numbers, which are there to show the format. A buyer and seller reach mutual acceptance at 4:15 p.m. on Tuesday 10 November 2026 on a $485,000 purchase. The form defines a business day as any day except a Saturday, Sunday or public holiday, and says the day of acceptance is not counted. A deadline that falls on a weekend or holiday moves to the next business day. Times are local to the property. A counter-offer signed that same afternoon replaced the original offer's 30-day financing period with 25 days. Say a public holiday falls on Wednesday 11 November.

The table is the finished deliverable after verification: the contingencies and deadlines the agent will calendar, with the dates worked out and checked.

ItemClock as writtenVerified dateWho actsWhere
Earnest money, $10,0003 business days after acceptanceMon 16 NovBuyer pays the escrow holderContract §3, p.2
HOA documents delivered5 days after acceptanceMon 16 Nov (Sun 15 Nov rolls forward)SellerContract §6, p.3
Inspection objections10 days after acceptance, by 5:00 p.m.Fri 20 Nov, 5:00 p.m.Buyer gives written noticeContract §7, p.3
Seller's reply to objections3 days after the notice is deliveredSet on delivery: Mon 23 Nov if delivered Fri 20 NovSellerContract §7.2, p.3
Appraisal contingency21 days after acceptanceTue 1 DecBuyer, through the lenderContract §8, p.4
Financing contingency25 days after acceptance (replaces 30)Mon 7 Dec (Sat 5 Dec rolls forward)Buyer, through the lenderCounter-offer 1, item 4
Final walk-throughWithin 2 days before closingWindow opens Wed 16 DecBuyer and agentContract §11, p.5
Closing and possessionFixed dateFri 18 DecBoth sidesContract §2, p.1

Notice what the table does not say: what happens if a date passes. For each contingency, add one more column headed "If the date passes", filled with the contract's own words, the clause and the page, never your paraphrase. Some contracts end the right, some leave it open until someone acts, and some need a notice first. If you can't find the wording, that is a question for your broker, and the empty cell is the reminder to ask.

Look also at the calendar this produces. Monday 16 November carries two deadlines, earnest money and the HOA documents, and it is the first normal working day after a holiday. A sensible agent sets reminders for the Thursday and Friday before it, and tells the client early that the transfer needs to be arranged that week, whatever the deadline says. Dates that cluster are worth spotting while the sheet is still a table, because a calendar shows them one at a time.

Where the first pass went wrong, and what caught each error

Here is what an assistant might plausibly return on a first pass through that contract, an invented run that shows the kinds of slips to expect. Three of the eight rows came out right (the seller's reply, the appraisal date and the closing date). The other five needed attention, and the last column shows how each was caught.

ItemAssistant saidSigned contract saysWhat caught it
Earnest moneyFri 13 NovMon 16 Nov, because 11 Nov is a public holiday and the business-day definition excludes itIts day-by-day count listed 11 Nov as day 1
HOA documentsSun 15 NovMon 16 Nov, because weekend deadlines roll forwardChecking the weekday of every date
Inspection objectionsFri 20 Nov, all dayFri 20 Nov, 5:00 p.m.The time-of-day column was empty
Financing contingencyThu 10 DecMon 7 Dec, because Counter-offer 1 says 25 daysThe "amended by" column was blank; the 30 days came from the original offer
Final walk-throughNot listedWithin 2 days before closing, §11The "anything you did not find" step and the brokerage checklist

The financing row is the dangerous one. The assistant's date was three days later than the real one, so an agent who trusted the calendar would have told the buyer there was time left when the contingency had ended. The earnest-money date errs on the early side, which costs nothing, and the HOA date concerns a seller's task, but both still produce a wrong calendar, and a calendar with wrong entries trains everybody to ignore it. The inspection row shows a subtler fault: the date was right and the entry was still wrong, because an all-day event invites a 6 p.m. email that arrives an hour late.

All five errors left a visible fingerprint. The first was caught by the day count the prompt demanded, the second by the agent's habit of checking the weekday of every date, and the third by the empty time column. A blank "amended by" cell exposed the fourth, and the question about what was missing exposed the fifth. That is the reason to ask for structure: a paragraph summary hides these faults, while a table with required columns turns them into gaps you can see.

Recompute the dates in a spreadsheet, not in your head

The checking step that catches the most is an independent calculation. Put the acceptance date in a cell, type the public holidays for the property's location into a short list, and let the spreadsheet count. Type the holiday list yourself. An assistant's holiday list changes by place and by year, and a wrong one is invisible until a deadline slips.

B1 = acceptance date (10 Nov 2026)       E2:E10 = public holidays you typed

Calendar days:            =B1+10
Business days:            =WORKDAY(B1,3,E2:E10)
Roll forward if needed:   =WORKDAY(B1+25-1,1,E2:E10)
Weekday check:            =TEXT(C5,"dddd")

Microsoft's documentation describes WORKDAY as skipping weekends and any holidays you list, and Google Sheets has a function of the same name. It does not count the start date, which matches a form that says the day of acceptance is not counted. If your form counts the acceptance day as day 1, subtract a day from the formula's input, and write that choice in a note beside the cell. The roll-forward formula takes the day before the deadline and moves one business day on, so a Saturday 5 December becomes Monday 7 December while a Friday stays put.

A quick sum shows the method on the earnest money. =WORKDAY(B1,3,E2:E10) with 11 November in the holiday list returns Monday 16 November; with the list empty it returns Friday 13 November. The two answers are the gap between the assistant's first pass and the contract. When the assistant's date and your formula disagree, do not pick the one you prefer. Open the definitions page of the contract, read what counts as a business day, and let the paper decide.

The ten-minute verification pass

Verification is quicker when it follows the same order every time. Print the table or put it beside the signed set on a second screen, and work down this list.

  1. Compare the documents the assistant listed in step 1 with the set you hold, page count for page count. A missing addendum is the commonest root cause.
  2. Open the cited page for every row, read the exact words against the contract, and tick or correct the row. Do not tick a row from memory.
  3. Read the definitions page and compare it with what the assistant quoted for "day", "business day" and "effective date".
  4. Recompute every date with the spreadsheet formulas and compare. Investigate every difference, even a single day.
  5. Check each time of day and each delivery method: who must receive the notice, in what form, and where it must go.
  6. Read the "amended or superseded by" column, then read the newest document first to confirm nothing older has crept in.
  7. Ask: "Which deadlines could appear in a contract like this that are not on your list?" and compare the answer with your brokerage's own checklist.
  8. Write "Checked against the signed copy by [initials], [date]" at the top of the sheet.

Most files need about ten minutes, and a file with several addenda takes longer. A sheet that has been through all eight steps is reliable enough to build a calendar on. A sheet that has skipped steps 2 and 4 is only an AI summary.

From verified sheet to calendar entries

Name entries so they survive a crowded calendar: a short property label, who acts, what, and the time. Put the clause and page in the description so whoever opens the entry can find the source in seconds, and add a second reminder one business day before the deadline as your own buffer. These filled-in entries come from the sample deal.

Entry titleWhenRemindersDescription
[12 Oak] BUYER: earnest money $10,000 to escrowMon 16 Nov, all day (contract gives no time)3 days, 1 day, morning of§3, p.2: 3 business days; 11 Nov excluded as a public holiday. Checked against signed copy: [initials], [date]
[12 Oak] BUYER: inspection objections due 5:00 pmFri 20 Nov, 17:003 days, 1 day, 3 hours§7, p.3. Written notice; delivery rules §9, p.4. Own target: send Thu 19 Nov
[12 Oak] BUYER: financing contingency endsMon 7 Dec, all day7 days, 3 days, 1 dayCounter-offer 1, item 4: 25 days, replaces 30. Own target: lender's written commitment by Fri 4 Dec
TENTATIVE [12 Oak] SELLER: reply to objectionsNo date yetNone until notice is delivered§7.2, p.3: 3 days after delivery. Add the date when the notice goes out, then remove TENTATIVE

The tentative entry matters. A deadline whose trigger has not happened has no date, and a guessed date on a calendar is worse than an empty one. Label it, leave the date off or pencil one in clearly, and complete it when the notice goes out.

If you would rather import than type, Google Calendar accepts CSV files with English column headings, where only Subject and Start Date are required, and as of November 2026 its help page gives a month-first date format (its example is 05/30/2020). Repeating events may arrive as separate one-off entries rather than a series. Add Start Time and Description columns for the rest. Three consequences follow. A spreadsheet in a day-first setting needs its dates converted before export, or an entry for 7 December could land on 12 July. Import one test row into a spare calendar before the whole sheet. And if you use another calendar, check its import help for the file types it accepts.

Give each deal its own calendar, shared with whoever coordinates the transaction. Clients usually need something simpler than a calendar, and a short message with the verified dates in plain words does the job:

"Hi [first name], here are the key dates in your contract, checked against the signed copy: earnest money to the escrow holder by Monday 16 November; inspection objections in writing by 5:00 p.m. on Friday 20 November; financing contingency date Monday 7 December; closing Friday 18 December. Please tell me straight away if any of this differs from what you remember, and call me before any date if you're unsure what is needed."

Questions to hand to your broker, not to the assistant

An assistant is fluent enough to answer questions it has no business answering. Whether a text message counts as written notice, whether a client should waive a contingency, what follows a missed date, and whether a clause making time "of the essence" makes a given date strict: all of these depend on the contract, the form and the rules where the property sits. Add one line to the Project instructions: "If I ask a legal question, don't answer it. List the exact clauses involved and the questions I should take to my broker."

That instruction turns the assistant's confidence into something useful. After the sample deal, the list it returned looked something like this (illustrative wording, like the rest of the example):

"1. §9 says notice may be given 'by email to the address in §20'. Does the buyer agent's address count, or only the buyer's? 2. §7 says the inspection period ends at 5:00 p.m. 'local time'. Which time zone applies if the buyer is travelling? 3. Counter-offer 1 reduces the financing period but does not mention the appraisal period. Does the appraisal period stay at 21 days? 4. §14 moves weekend deadlines to the next business day. Does that apply to the walk-through window as well as to the contingency dates?"

Those are good questions, and each one stops an agent from guessing. The same pattern helps in other files, and the transaction coordinator tutorial shows which other file-keeping jobs are worth handing to AI at all. For inspection findings, the inspection report summary tutorial covers the repair-request side that follows the objection deadline in the sample deal.

Re-running the sheet when an addendum arrives

Deadlines change during a deal, and a calendar built once goes stale. Treat every new signed document as a trigger to re-run the whole process, not to patch one entry. Suppose Addendum B, signed on Tuesday 17 November, extends the inspection period by 2 days. The period now ends 12 days after acceptance, which is Sunday 22 November, so under the form's rolling rule it moves to Monday 23 November at 5:00 p.m. If the buyer's notice goes out that Monday, the seller's three days run to Thursday 26 November, a public holiday in this example, which rolls to Friday 27 November. One extension moved two dates, and the seller-reply entry changed from tentative to a real date.

To catch that kind of cascade, paste the previous table into the assistant along with the full set of documents and ask: "Here is the deadline table from the previous version. Compare it with the documents, now including Addendum B, and list every row that changes, with the old and new date and the clause that caused the change." Then verify the changes with the same ten-minute pass, update the calendar entries, and add a line to the deal's notes: "v3, after Addendum B, checked [initials], [date]". Keep every version of the table in the deal file. If anyone asks later why a date was in the calendar, the version history answers the question.

The tutorial on tracking contract renewals and deadlines applies the same extract-verify-calendar loop to business contracts, which is useful if you also manage listing agreements or leases. For the broader question of what an assistant can do inside a calendar, see whether AI can manage your calendar before you let one create events on your behalf.

Questions agents ask before trusting AI with contract dates

Can AI tell me whether a contingency has been waived?

It can quote the clause and list any signed waiver it finds, which is useful, but it cannot decide what a waiver, a late notice or a missed date means for your client. That is a legal question for your broker or a real estate lawyer. Ask the assistant to list the exact words and the documents involved, then take them to the person who can advise.

Should the assistant add the dates to my calendar directly?

Not before the sheet is verified. Some assistants can connect to a calendar and create events, but a wrong event looks exactly like a right one and gets trusted. Verify the table against the signed contract first, then create the entries yourself or import a file you have checked, starting with a single test row.

What if the contract does not say how to count days?

Do not let the assistant pick a convention for you. Check the form's definitions section and any note from the form's publisher, then ask your broker how your office counts. Until you have an answer, calendar the earliest plausible date as a tentative reminder and label it so nobody treats it as settled.

What should I tell clients about using AI on their contract?

Follow your brokerage's policy on client documents first, because some offices restrict uploads. Where it is allowed, tell clients that the dates they receive come from their signed contract and were checked by you personally. The assistant is an internal drafting step, and the person responsible for the dates is you.

Further reads

Sources: Google Calendar's CSV import help page, Claude's file-upload help page, the vendors' pricing and privacy pages for business AI plans, and the WORKDAY function pages for Excel and Google Sheets (all checked November 2026). The contract terms, clauses and dates in the examples are invented for illustration.

Want a deal calendar your whole team trusts?

On a 1:1 call we'll look at how your deals are tracked today, where AI can safely draft the deadline sheet, and which checks must stay with a person.

Book a 1:1 call with me