A head of asset management told me his quarterly investor reports took three weeks to build. Not to write. To build.
His platform runs 35+ assets. The underwriting lives in ARGUS. Operations live in Yardi. In between sit the asset-level spreadsheets, one per property, each maintained by whoever inherited it.
Every quarter, his analysts pulled numbers out of all three, reconciled them by hand, and assembled a deck. Three weeks, every 90 days. Almost a quarter of the year spent reporting on the quarter.
That was the problem he hired us to fix. The expensive one was hiding underneath it.
When the systems finally ran on one data layer and we compared what the firm underwrote against what the buildings actually did, the gap wasn’t a rounding error.
■ THE DATA
12–18%
Variance between underwritten projections and actual performance, on assets everyone assumed were tracking plan.
Nobody had been hiding it. Nobody could see it. The plan and the reality lived in two systems that had never been introduced, and the spreadsheets in between were quietly smoothing the difference.
The reporting got faster. Three weeks to three days. But speed was the souvenir. The variance was the prize.
■ THE PATTERN
Disparate Systems That Never Talk
Real estate on the surface. The same gap shows up wherever operators run on systems that each see one slice.
PRIVATE EQUITY
Deal data spread across CIMs, QoE reports, and financials means every diligence cycle starts with reconciliation. Unify the layer and diligence runs 40% faster, and the inconsistencies surface instead of hiding.
HEALTHCARE
Revenue leaks across referrals, eligibility, charge capture, and denials, in systems that each see one slice. One clinical trials portfolio found $2M a month once the slices became one picture.
EVERYWHERE ELSE
Your data is all there, just fragmented. And fragmented data does more than slow you down. It hides money and manufactures risk while looking perfectly normal.
■ DO THIS WEEK
Take the report your team dreads most. Count the systems it touches before it’s done. If the answer is more than two, somewhere in the gaps between them is a version of the truth nobody is looking at. That’s where I’d start digging.
Found your own hidden number? Reply and tell me. Best story goes in a future issue, anonymized.
See you next week.
Zach
Founder & CEO, OutcomeCatalyst