Every broker I know has the same haunted spreadsheet. It lives on the second monitor, three tabs deep, color-coded in a system only past-you understood. It started as "Q1 Industrial Pipeline, Atlanta MSA" and now it's a 47-column monster with a tab named "DO NOT DELETE (Mike)." You open it Monday morning, scroll, lose your place, close it, and tell yourself you'll clean it up Friday. You will not clean it up Friday. Nobody ever cleans it up Friday.
This is not a productivity problem. It is a tooling problem dressed up as a discipline problem, and it's quietly costing you deals.
The lifecycle of a broker spreadsheet
Week 1 is beautiful. Fresh tab, frozen header row, six clean columns: Property, Address, Seller, Asking, Cap, Status. You feel organized. You send the link to your analyst. You consider, briefly, becoming the kind of broker who runs a tight pipeline.
By week 3, someone has added a column called "Notes" that contains entire LOI drafts. There are now two date columns and nobody is sure which one is the OM date and which one is the call-back date. The Status column has fourteen unique values including "maybe?", "DEAD", "dead", "Dead - revisit Q3", and one cell that just says "Tom."
By week 6, you have seven tabs. There is a tab for "Closed Won" with two rows. There is a tab called "Sheet1 (2)" that nobody will admit creating. The asking-price column is now half numbers, half strings like "$12.5M ish" and "asking $14, will take $11." Conditional formatting from week 2 is still firing on cells whose meaning has drifted three times.
By the end of the quarter, the spreadsheet gets archived. Not because it's done, because it's unusable. You start a new one. You promise yourself this one will stay clean. The cycle begins again. Multiply this by four quarters, three product types, and two markets, and you have a graveyard of pipeline files, each containing maybe twelve deals you genuinely cared about and three hundred you forgot you ever saw.
Five failure modes you keep meeting
Every spreadsheet pipeline dies of the same five things. You will recognize all of them.
1. Stale data. The last-updated column says March 14. It is now April 24. You have no idea if the seller still wants $14M, if the T-12 you saw is still the most recent T-12, or if the deal traded last week to someone else and you missed the email. Every conversation with that seller now starts with you trying to remember what you knew about them, then re-pulling the OM, then realizing your notes contradict the OM, then giving up and asking a question you already asked in February.
2. Version chaos. The file is called Pipeline_Q1_FINAL_v7_FINAL_RAFA_EDIT.xlsx. There are four versions in your Downloads folder, two on the shared drive, one your analyst is editing right now, and one your partner emailed you that is somehow newer than all of them but missing three deals. Reconciling these is a Tuesday afternoon you will never get back. Choosing which one is "the truth" is, functionally, a coin flip.
3. Color coding decay. Yellow used to mean "follow up this week." Then it meant "waiting on seller." Then your analyst started using it for "interesting but not for this fund." Now nobody remembers, including you, including the person who invented the legend. Green is either "won" or "called back" or "the OM is good," depending on which tab you're looking at. The legend tab, if it ever existed, has been deleted.
4. No audit trail. Six weeks ago you passed on a deal in Marietta. Today the seller's broker calls and asks why. You have no idea. The Notes cell says "not a fit." Not a fit for what? Which mandate? Which buy box? Was it the cap rate, the tenancy, the year built, the deferred maintenance you saw in the OM? You either invent a reason on the call or admit you can't remember. Both are bad. Worse: when the same deal recirculates next quarter at a 50bps wider cap, you have no record that you ever looked at it, so you waste two hours doing the same diligence you already did.
5. Sharing problems. Your acquisitions client wants to see what's in the pipeline. You cannot send them the spreadsheet. The spreadsheet has three other clients' mandates on it. It has internal notes like "seller is delusional" and "Mike's nephew, be polite." So you copy-paste the relevant rows into a new file, reformat it, strip the colors, fix the columns, send it as a PDF, and lose forty minutes you should have spent on the next deal. You do this every week. Every broker does this every week.
The hidden cost: deals you forgot you saw
The visible cost of a spreadsheet pipeline is the time you spend maintaining it. The hidden cost is much worse: it's the deals you saw, dismissed, and lost track of, and the same deals coming back six months later as if for the first time.
A repriced asset is one of the highest-conviction setups a broker gets. You already did the work. You know the rent roll, the basis, the seller's motivation, the reason you passed. When that deal comes back at a wider cap or a softer ask, you should be the first call. Instead, because the original work is buried in a quarterly archive nobody opens, you treat it as a new deal. You re-underwrite from scratch. You miss the timing. Someone else closes it.
This isn't a hypothetical. Walk through any broker's archive folder and you'll find at least three deals that recirculated and got re-pitched as new. The spreadsheet didn't fail at storing data. It failed at being queryable, at surfacing context, at telling you "you've seen this address before, here's what you said about it, here's what changed."
A pipeline you can't query is not a pipeline. It's a graveyard.
What a structured alternative looks like
The fix is not a better spreadsheet. People have been trying to build a better spreadsheet for thirty years. The fix is recognizing that broker workflow is not a list problem, it's a mandate problem. Every deal you look at is a deal you're looking at for something: a specific buyer, a specific buy box, a specific set of gates.
A structured cre pipeline management setup looks like this:
- Mandate-based workspaces. Each mandate (the Atlanta industrial fund, the Sunbelt MOB roll-up, the family office multifamily allocation) gets its own workspace, with its own buy box defined explicitly: product type, size, vintage, cap range, geo, deal-breakers. Deals enter the workspace and get evaluated against that buy box, not a vague mental model.
- Gates with written reasoning. A deal moves from "screened" to "underwriting" to "LOI" through gates. Each gate transition records who moved it, when, and why. Three months later, when the deal recirculates, the reason you passed is one click away.
- A real audit trail. Every verdict, pursue, pass, watch, is logged. Not as a yellow cell. As a structured event with a timestamp, an author, and a reason. When a seller's broker asks why you passed, you actually know.
- Branded shortlists you can send. When a client wants to see the pipeline, you generate a shortlist from the mandate workspace. It shows them only their deals, in their format, with the fields they care about. It does not show them your other clients. It takes thirty seconds, not forty minutes.
This is roughly what we built bipsio around. Each mandate has its own workspace, buy box, and gates. Hugo, the AI sitting on top of the data, re-evaluates verdicts whenever you run a fresh scan, so when a deal you passed on six months ago comes back at a wider cap and shows up in your next scan, the system flags it instead of you rediscovering it by accident. If you want to see it on a real mandate, the sample mandate walks through one end-to-end.
Migrating in a week without pulling out
The reason most brokers don't move off spreadsheets isn't disagreement with any of the above. It's the dread of migration. The spreadsheet, as bad as it is, contains years of context. Moving it sounds like a project.
It doesn't have to be. A reasonable migration looks like this:
- Day 1-2. Pick your two or three most active mandates. Define the buy box for each in writing, the actual gates, not a vibe. This alone is worth the week, because most spreadsheet pipelines have never had their criteria written down explicitly.
- Day 3. Import the live deals from your current spreadsheet. Not the archive. Just what's actually moving. For most brokers this is 20-40 deals per mandate, not the 300 in the file.
- Day 4. Backfill the verdict history for anything that was already screened: pursued, passed, watching, with a one-line reason. This is the audit trail you wish you had.
- Day 5. Run your normal week inside the new workspace. Keep the spreadsheet open as a safety blanket. You will close it by Wednesday of week 2 and not reopen it.
The archive stays where it is. You don't migrate dead deals. You migrate the live pipeline and the active mandates, and you let the rest age out.
The point
Your spreadsheet isn't bad because you're undisciplined. It's bad because a spreadsheet is the wrong shape for what you're actually doing. You're not maintaining a list, you're tracking dozens of deals against a handful of mandates, each with its own buy box, each with its own audit history, each with clients who want to see a clean version of their slice and only their slice.
A spreadsheet can fake that for about six weeks. Then it becomes the graveyard.
If your Q1 pipeline is already on its third version-FINAL and it's only April, that's the signal. Write the buy boxes down. Move the live deals into a structure that survives a quarter. Stop rediscovering the same Marietta industrial deal every six months. If you want to see what mandate-based pipeline tracking looks like before committing to anything, sign up, bring your worst spreadsheet, we'll show you the shape it should have had.
Your Friday self will thank you. For once.
