TL;DR: An independent brokerage in Charlotte was tracking 35-45 active transactions in a shared Google Sheet. Four agents updated their rows when they remembered. Each transaction had 40-plus milestones. No dependency tracking between linked properties. On day 47 of a 5-property chain, a lender called asking about an appraisal that had been "in progress" for three weeks. It had never been scheduled. The chain nearly collapsed. We built a four-stage transaction coordinator agent that generates milestone checklists from contracts, tracks status in real time with stale-data detection, maps chain dependencies so a delay on Property 3 immediately flags Properties 4 and 5, and sends daily alerts to agents and weekly chain-health summaries to the broker. Twenty-three overdue milestones caught in month one. Two chain saves in the first quarter. Agent cost: $220/month.
Day 47
Everything looked on track.
Five properties linked in a chain. Sellers downsizing on one end, a young couple buying their first home in the middle, a family relocating to Raleigh, and a couple moving into a retirement community near Lake Norman on the other end.
Five families. Five sets of solicitors. Five mortgage applications. Roughly 200 milestones across the chain, all needing to land in the right order.
One shared Google Sheet tracking all of it.
On day 47, the buyer's lender on Property 2 called the brokerage. They needed the appraisal on Property 3 to finalise the buyer's financing. The spreadsheet showed the Property 3 appraisal as yellow. In progress.
It wasn't in progress. It had never been scheduled. The listing agent on Property 3 had meant to book it, got pulled into two other closings that week, and forgot. She'd entered "in progress" three weeks ago because she intended to do it. The spreadsheet didn't know the difference between intended and done.
The financing deadline for Property 2 was in 10 days. Without the appraisal on Property 3, the lender couldn't approve the loan. Without the loan, Property 2 doesn't close. Without Property 2 closing, the sellers on Property 1 have nowhere to go. Properties 4 and 5 collapse with it.
Three families. Scrambling. Two ended up in temporary housing for three weeks while timelines were renegotiated. One nearly walked away entirely.
Because one row in a spreadsheet hadn't been updated.
The Brokerage
Independent residential brokerage in Charlotte, North Carolina. Four agents, the broker/owner, and a part-time admin working 20 hours a week. Residential sales across the greater Charlotte metro.
Average active transactions: 35 to 45. Each carries 40-plus milestones: listing agreement, disclosures, offer acceptance, inspections, appraisal, title search, mortgage approval, HOA docs, final walkthrough, closing. That's roughly 1,400 to 1,800 active milestones tracked in a Google Sheet.
Four agents update their own rows. One updates daily. He's thorough. Two update "when something happens," which means milestones sit unchanged for days. The fourth updates in batches on Fridays, which means her rows are always slightly stale by Monday.
The broker reviews the full sheet every Monday morning. By then, some milestones are a week old. A milestone that went overdue on Wednesday looks the same on Monday's review as one that was completed on Thursday. The sheet shows the last thing someone typed. It doesn't show when they typed it.
No dependency tracking. Each transaction is a separate row. Chains aren't visible. The broker knows which deals are linked, in his head. But 35 to 45 transactions with shifting chain relationships? That's too much for memory.
Average transaction value: $380,000. Broker commission at 2.5-3%: roughly $9,500 to $11,400 per deal. The 5-property chain collapse cost the brokerage over $27,000 in commission risk. They recovered most of it by renegotiating timelines, but two families needed temporary housing.
Why the Spreadsheet Was Lying
The Google Sheet was well-structured. Colour-coded, with columns for every milestone. The problem: "in progress" entered three weeks ago looks identical to "in progress" entered yesterday. Both show yellow. No timestamps. No alerts. No dependency mapping.
The broker tried transaction management software. $300 to $500 per month. The free trial lasted three weeks. Agents found it was "one more thing to update" and stopped using it. The Google Sheet survived because it was familiar, even if unreliable.
Monday reviews were the safety net. Ninety minutes every Monday. But chains don't wait for Mondays. The Property 3 appraisal was overdue on Wednesday. Nobody knew until Friday. The Monday review catches problems that are five days old. In real estate, five days can be the difference between a close and a collapse.
The part-time admin was assigned as transaction coordinator. Twenty hours a week across 40-plus transactions with 40-plus milestones each. She became a human reminder system. She still missed chain dependencies because she tracked transactions individually. Property 3's delay wasn't on her radar as a threat to Property 2.
The design is next. The design, the build guide, the running costs and the take-away are free to subscribers. Enter your email below and the rest of this Blueprint opens. New ones arrive every Tuesday and Friday.
