Workflow template for operations and process improvement

Transaction deadline check

Every Monday, and whenever a contract is amended, the transaction coordinator gets one page from the open-transactions export: what falls due soon, by agent; what has passed with no completion recorded; which dates are missing or impossible; and a question for each agent. It reads dates as recorded and counts none.

View this template on GitHub

Put this on your planBuild this in a sprint

Add it to a workflow in the FullyPowered Planner, beside the teams and roles that will run it. Book a fit call

The outcome

No milestone slips past quietly. Each week the transaction coordinator or managing broker sees every open deal on one page: the deposits, inspection periods, financing and appraisal dates, title work and closings coming up in the brokerage's window, sorted by agent, and every milestone whose recorded date has gone by with nothing marked complete.

The records that would cause trouble later surface now: a financing date nobody entered, a closing dated before the offer was accepted, a completion stamped with a date that has not happened yet, a deal with no agent on it. If last week's export is supplied, the page also shows what moved since then: new deals, deals that dropped off, dates that changed and completions recorded. Each problem arrives as a plain question for the agent who can answer it.

A count at the top proves the page is complete: every open transaction and every tracked milestone is accounted for, so the coordinator knows nothing was skipped.

The contract and the managing broker govern every deadline. The workflow template reads each date exactly as your system holds it. It never works out a deadline from a contract, a law or a rule about weekends and holidays, and it gives no legal advice. It contacts nobody, extends nothing and changes no record.

Who starts the work, and when

The transaction coordinator starts it every Monday morning, before the week's calls, and again on any day a contract is amended and the new dates are in the system. Where a brokerage has no coordinator, the managing broker runs it. The coordinator decides which questions go to which agent and how; the agents answer and update the record; the managing broker decides on any deadline that is in doubt, with the contract in hand.

What they supply

  • The open-transactions export from your real estate CRM or transaction system, one row per open deal, with these columns: transaction ID, property, side, agent, acceptance date, and for each milestone you track (deposit due, inspection period end, financing date, appraisal, title, closing) its date as recorded with the completed date beside it. If your headers differ from the defaults, the workflow template stops and asks which column is which.
  • Today's date.
  • Your brokerage's settings: which milestones you track, and how many days ahead counts as due soon (seven unless you change it).
  • Last week's export, if you want the changes since then.

Leave buyers' and tenants' personal finances, and anything touching fair-housing protected characteristics, out of the export. A deadline check needs none of it, and the workflow template stops if it finds any.

What comes out

One page in a fixed order: the count that proves every transaction and milestone was read; milestones due in the window, by agent; milestones past their recorded date with no completion recorded, oldest first; missing or impossible dates; changes since last week's export; and the questions for each agent. A section with nothing in it says "None." The page closes by saying that every date is as recorded and that nothing was sent, extended or changed.

An example

Illustrative example with sample data. Brokerage X is an illustrative brokerage with residential and commercial work. Its transaction coordinator runs the Monday check. The agents appear as letters, the properties are illustrative, and no buyer, seller or tenant is named. Every row and date below is illustrative.

The inputs come first, in full, so the workflow template can be run on them. The page follows.

The inputs

1. Settings (typed by the transaction coordinator)

Brokerage: Brokerage X
Today: Monday 23 November 2026
Page is for: transaction coordinator
Milestones tracked, in order (display name: date column / completed column):
  Deposit due: deposit_due / deposit_completed
  Inspection period end: inspection_end / inspection_completed
  Financing date: financing_date / financing_completed
  Appraisal: appraisal_date / appraisal_completed
  Title: title_date / title_completed
  Closing: closing_date / closing_completed
Due soon: within 7 calendar days
Not applicable is marked: n/a

2. The open-transactions export from your real estate CRM or transaction system (this week, exported Monday 23 November 2026)

transaction_id,property,side,agent,acceptance_date,deposit_due,deposit_completed,inspection_end,inspection_completed,financing_date,financing_completed,appraisal_date,appraisal_completed,title_date,title_completed,closing_date,closing_completed
T-101,14 Alder Row,buyer,Agent A,2026-10-20,2026-10-23,2026-10-22,2026-10-30,2026-10-29,2026-11-19,,2026-11-12,2026-11-11,2026-11-25,,2026-12-01,
T-102,3 Birch Court,seller,Agent B,2026-11-02,2026-11-05,2026-11-05,2026-11-16,,2026-11-27,,2026-11-24,,2026-12-04,,2026-12-15,
T-103,Suite 4 at 220 Mill Street (office),buyer,Agent C,2026-09-28,2026-10-01,2026-09-30,2026-11-06,2026-11-05,n/a,,n/a,,2026-11-20,2026-11-18,2026-11-30,
T-104,9 Cedar Lane,both,Agent A,2026-11-10,2026-11-13,,2026-11-24,,,,2026-12-01,,2026-12-08,,2026-11-05,
T-105,61 Dune Road,buyer,Agent B,2026-10-26,2026-10-29,2026-10-28,2026-11-09,2026-11-09,2026-11-30,,2026-11-20,2026-11-19,2026-12-02,,2026-12-10,
T-106,Warehouse 2 at 5 Kiln Yard (industrial),seller,,2026-11-16,2026-11-19,2026-12-02,2026-12-07,,n/a,,n/a,,2026-12-14,,2027-01-08,
T-107,27 Elm Terrace,seller,Agent C,2026-11-18,2026-11-21,2026-11-20,2026-12-02,,2026-12-16,,2026-12-09,,2026-12-23,,2027-01-05,
T-108,8 Fern Close,buyer,Agent C,2026-10-05,2026-10-08,2026-10-08,2026-10-19,2026-10-17,2026-11-06,2026-11-05,2026-10-28,2026-10-27,2026-11-13,2026-11-12,2026-12-04,

The export holds no buyer, seller or tenant names, no personal finances and nothing about anyone's personal characteristics.

3. Last week's export (exported Monday 16 November 2026)

transaction_id,property,side,agent,acceptance_date,deposit_due,deposit_completed,inspection_end,inspection_completed,financing_date,financing_completed,appraisal_date,appraisal_completed,title_date,title_completed,closing_date,closing_completed
T-099,40 Gorse Hill,buyer,Agent B,2026-09-14,2026-09-17,2026-09-16,2026-09-28,2026-09-26,2026-10-16,2026-10-15,2026-10-09,2026-10-08,2026-11-06,2026-11-05,2026-11-13,2026-11-13
T-101,14 Alder Row,buyer,Agent A,2026-10-20,2026-10-23,2026-10-22,2026-10-30,2026-10-29,2026-11-19,,2026-11-12,2026-11-11,2026-11-25,,2026-12-01,
T-102,3 Birch Court,seller,Agent B,2026-11-02,2026-11-05,2026-11-05,2026-11-16,,2026-11-27,,2026-11-24,,2026-12-04,,2026-12-15,
T-103,Suite 4 at 220 Mill Street (office),buyer,Agent C,2026-09-28,2026-10-01,2026-09-30,2026-11-06,2026-11-05,n/a,,n/a,,2026-11-20,,2026-11-30,
T-104,9 Cedar Lane,both,Agent A,2026-11-10,2026-11-13,,2026-11-24,,,,2026-12-01,,2026-12-08,,2026-12-15,
T-105,61 Dune Road,buyer,Agent B,2026-10-26,2026-10-29,2026-10-28,2026-11-09,2026-11-09,2026-11-23,,2026-11-20,,2026-12-02,,2026-12-10,
T-106,Warehouse 2 at 5 Kiln Yard (industrial),seller,,2026-11-16,2026-11-19,,2026-12-07,,n/a,,n/a,,2026-12-14,,2027-01-08,
T-108,8 Fern Close,buyer,Agent C,2026-10-05,2026-10-08,2026-10-08,2026-10-19,2026-10-17,2026-11-06,2026-11-05,2026-10-28,2026-10-27,2026-11-13,2026-11-12,2026-12-04,

The page

TRANSACTION DEADLINE CHECK: Brokerage X, as of Monday 23 November 2026

For: transaction coordinator. Export: 8 open transactions. Last week's export: 8 transactions. Milestones tracked: Deposit due, Inspection period end, Financing date, Appraisal, Title, Closing. Window: 7 calendar days, through 2026-11-30. Defaults used: none.

Read: Transactions read: 8 (rows in the export: 8). With something due, past or wrong: 6. With nothing due, past or wrong: 2 (T-107, T-108). Milestones read: 48 (8 x 6). Completed: 16. Due in the window: 6. Past, no completion recorded: 3. Date problems: 3. Not applicable: 4. Later: 16.

  1. DUE IN THE WINDOW, BY AGENT: 6

Agent A

  • 2026-11-24 (in 1 day): Inspection period end, T-104, 9 Cedar Lane, both.
  • 2026-11-25 (in 2 days): Title, T-101, 14 Alder Row, buyer.

Agent B

  • 2026-11-24 (in 1 day): Appraisal, T-102, 3 Birch Court, seller.
  • 2026-11-27 (in 4 days): Financing date, T-102, 3 Birch Court, seller.
  • 2026-11-30 (in 7 days): Financing date, T-105, 61 Dune Road, buyer.

Agent C

  • 2026-11-30 (in 7 days): Closing, T-103, Suite 4 at 220 Mill Street (office), buyer.
  1. PAST, NO COMPLETION RECORDED: 3
  • 2026-11-13 (10 days ago): Deposit due, T-104, 9 Cedar Lane, Agent A.
  • 2026-11-16 (7 days ago): Inspection period end, T-102, 3 Birch Court, Agent B.
  • 2026-11-19 (4 days ago): Financing date, T-101, 14 Alder Row, Agent A.
  1. MISSING OR IMPOSSIBLE DATES: 3 milestones; transaction fields: 1
  • T-104, 9 Cedar Lane, Agent A: Financing date: blank; missing.
  • T-104, 9 Cedar Lane, Agent A: Closing: 2026-11-05; before acceptance 2026-11-10.
  • T-106, Warehouse 2 at 5 Kiln Yard (industrial), agent not recorded: Deposit due: completed 2026-12-02; completion after today.
  • T-106, Warehouse 2 at 5 Kiln Yard (industrial), agent not recorded: Agent: blank; agent not recorded.
  1. CHANGES SINCE LAST WEEK'S EXPORT (2026-11-16) New: T-107. No longer in the export: T-099. Why is not known from the export. Dates changed: T-104 Closing: 2026-12-15 to 2026-11-05. T-105 Financing date: 2026-11-23 to 2026-11-30. Completions recorded: T-103 Title: 2026-11-18. T-105 Appraisal: 2026-11-19. T-106 Deposit due: 2026-12-02 (also in section 3). Completions removed: None.

  2. QUESTIONS FOR EACH AGENT

Agent A

  1. T-101, 14 Alder Row: Financing date is recorded as 2026-11-19 with no completion recorded. What does the transaction file show?
  2. T-104, 9 Cedar Lane: Deposit due is recorded as 2026-11-13 with no completion recorded. What does the transaction file show?
  3. T-104, 9 Cedar Lane: Financing date is blank. What does the transaction file show?
  4. T-104, 9 Cedar Lane: Closing is recorded as 2026-11-05, before the acceptance date of 2026-11-10. What does the transaction file show?
  5. T-104, 9 Cedar Lane: Closing changed from 2026-12-15 to 2026-11-05 since last week. What does the transaction file show?

Agent B

  1. T-099, 40 Gorse Hill: no longer in the export. What does the transaction file show?
  2. T-102, 3 Birch Court: Inspection period end is recorded as 2026-11-16 with no completion recorded. What does the transaction file show?
  3. T-105, 61 Dune Road: Financing date changed from 2026-11-23 to 2026-11-30 since last week. What does the transaction file show?

Agent not recorded: for the transaction coordinator

  1. T-106, Warehouse 2 at 5 Kiln Yard (industrial): Deposit due completion is recorded as 2026-12-02, after today. What does the transaction file show?

Agents with no questions: Agent C.

Prepared for transaction coordinator to review. Every date is as recorded in the export; none was worked out from a contract, a statute or a business-day rule. Nothing has been sent, extended or changed. The contract and the managing broker govern every deadline.

Checking the figures (not part of the page)

  • Window end: 23 November + 7 days = 30 November 2026. Due in the window means 23 to 30 November inclusive.
  • Milestones read: 8 transactions x 6 milestones = 48. Completed 16 (T-101: 3, T-102: 1, T-103: 3, T-105: 3, T-107: 1, T-108: 5). Due 6. Past 3. Date problems 3. Not applicable 4 (T-103 and T-106, financing and appraisal each). Later 16 (T-101: 1, T-102: 2, T-104: 2, T-105: 2, T-106: 3, T-107: 5, T-108: 1). 16 + 6 + 3 + 3 + 4 + 16 = 48.
  • T-104's Appraisal (2026-12-01) and Title (2026-12-08) fall after its recorded closing, but its closing date is itself a problem, so the after-closing test is skipped for T-104 and both count as later.
  • T-106 has no agent recorded, so its blank agent is listed in section 3 and its question goes to the transaction coordinator; no separate question asks who the agent is. Questions are numbered from 1 under each agent.
  • T-107 and T-108 have only completed or later milestones, so they have nothing due, past or wrong. 6 + 2 = 8.

Where it fits

  • Real estate, where a brokerage carries dozens of open deals, each with its own inspection, financing and closing dates, and one missed date can cost a client the deal.
  • Finance and investment, where an acquisitions team tracks the milestones on its own property purchases and wants the same weekly view of what is due.
  • Operations and process improvement, which owns the weekly routine that keeps every open file on track.
  • Sales, where agents carry their deals to closing and need to see what is theirs this week.
  • Growth & scaling, when the brokerage has more open deals than one coordinator can hold in their head.
  • Established businesses, where the Monday review lives in one long-serving coordinator's spreadsheet and should be the same every week.

It sits beside unit turnover readiness checklist, which gets a rental unit ready between tenants, and obligation and filing calendar review, which does the same kind of recorded-date check for a company's own filings and renewals, and supplier delivery date check, which compares the promised and revised dates on open purchase orders.

What has to change for your company

Match the column headers to your export, or rename the columns once. List the milestones you track, in the order you think about them, separately for residential and commercial deals if they differ. Set your due-soon window. Decide how your system marks a milestone that does not apply, such as financing on a cash purchase. Agree who reads the page, who sends the questions to agents and how quickly agents answer. It runs in ChatGPT, Claude, Copilot or Gemini, from the files you supply; it needs no connection to your transaction system.

What has been checked

FullyPowered AI wrote this workflow template. It was editorially reviewed on 19 November 2026. It was tried on its example on 19 November 2026 in one run, published with it. Edits after that run, to the example's questions and to some format notes, have not been run again. It has not yet been tested in a client environment or as a packaged version in ChatGPT, Claude, Copilot or Gemini.

Testing in your environment means running it on two or three past Mondays your coordinator remembers well, with hard cases written in advance: a closing dated before acceptance, a blank financing date on a deal that has one, a cash purchase marked not applicable, a date changed by an amendment. The coordinator checks every line against the system before anyone relies on it. Pilot acceptance-test preparation sets those cases up.

Who decides

People decide

Your people keep

  • Which questions go to which agent
  • Every deadline that is in doubt, decided by the managing broker with the contract in hand
  • Every update to the transaction record
By design

It does not

  • Works out no deadline from a contract or a statute
  • Gives no legal advice
  • Contacts nobody
  • Extends nothing
  • Changes no record

Questions people ask

Who is this for?

The transaction coordinator runs it every Monday and whenever a contract is amended. Where there is no coordinator, the managing broker runs it.

What do I need to supply?

The open-transactions export, today's date, your milestones and due-soon window, and optionally last week's export.

Does it work out my deadlines?

No. It reads each date exactly as your system records it. The contract and the managing broker govern every deadline, and it gives no legal advice.

Does it contact agents or change records?

No. It contacts nobody and changes no record. The coordinator decides who is asked, and the agent updates the system.

What has been checked?

It was editorially reviewed and tried once on an example. It has not yet been tested in a client environment.

What it connects to

The business systems this workflow template works with, what it reads from each and what it writes to it, from a reviewed reading of its own text.

Writes to it: nothing.

What it connects to
How it works with the systemReads from it
Works from an export from a real estate CRM, listing or transaction system.Reads from itEach open deal with its agent, acceptance date and milestone dates.

The full workflow template

Everything above is the outline. The complete workflow template is the working version: the roles, the inputs, the procedure, the exceptions and stop conditions, the output format, the reviewer checklist, the acceptance tests, the instructions for an AI assistant and what to customize for your company. It comes with a download and the link to its folder in FullyPowered’s public repository.

View the full template

Free with an account. Sign in by email: no password and no card.

Next step

Put this workflow template to work for your team: on your plan, or built with you in a sprint.

  1. 01

    The full workflow template

    Free with an account. Sign in by email: no password and no card.

  2. 02

    FullyPowered Planner

    Add it to a workflow in the FullyPowered Planner, beside the teams and roles that will run it.

  3. 03

    Build this in a sprint

    In a sprint, FullyPowered adapts this workflow template to your rules, proves it on your own work and puts it in the hands of the roles that own it.

These workflow templates are examples and a starting point, not a complete list. We can build any workflow for your company, including one that runs several steps, in a Workflow Sprint or a scoped implementation.

Rather talk it through first? Book a fit callDiscuss adapting this

FullyPowered Planner. A card to start, everything unlocked, nothing charged for seven days.Security & your informationPlanner termsRefunds