Let’s be honest: pulling data from disconnected systems just to feed into your Excel models is time-consuming and exhausting.
It’s a familiar cycle for most commercial real estate asset management firms. Whether you’re working with operating partners, JVs, or borrowers, information arrives in inconsistent formats – PDFs, spreadsheets, manual exports, emails, etc. – and it’s up to your team to piece everything together. This typically means logging in to multiple systems, tracking down reports, and copying data manually into another set of Excel workbooks.
Even firms with internal PM or GL platforms aren’t immune. Hours upon hours are spent extracting, converting, and consolidating data, only to re-enter it into spreadsheets that power everything from projections and forecasting to underwriting and business plans.
This is what Excel Hell looks like.
And here’s the real kicker: the grind of managing disconnected data across siloed systems isn’t even about modeling – it’s about feeding the model.
Excel models are only as good as the data feeding them
We at Pereview believe the same as many of you: Excel is the world’s best modeling software, but it’s the world’s worst database. But in commercial real estate, it’s often pushed far beyond its limits because the underlying data infrastructure is siloed and broken.
Firms continue to rely on spreadsheet-driven processes, even as the volume of data, number of systems, and complexity of portfolios grows exponentially.
As the head of asset management for a client firm in Southern California that manages four opportunistic funds across all asset classes with an AUM of almost $2B, recently said:
“Once we topped $1B in AUM years ago, we swore we would start looking into more efficient ways to manage our property-level info received from, at that time, a handful of select operating partners on two different PM/GL systems. Then, as you can guess, we got busy, we got so overwhelmed that we just threw more and more employees at the ever-growing problem. ‘Excel is free,’ we told ourselves, never thinking of what the grind was truly costing us. Then suddenly, we almost hit $2B in AUM, where we needed even more processes in place only to realize we were almost at a point of no return. Mistakes were being made and the grind was too much to continue to ignore. We learned about Pereview from an industry peer who had come across you at a NAREIM event and we reached out to learn more. The rest is now happily just history, as we are so much more efficient now from property through to the fund to our investors.”
She replied, “Pereview connects directly to our now 11 operating partners’ Yardi, MRI and Entrata platforms, pulling all of our data automatically into our user, property, and portfolio dashboards. Our reports are automated and trusted because all data is clean. We focus on enhancing the property’s value and driving returns now without interruption. The grind is over. But it is far more than just data aggregation and collection; we now have all of our data in one location, which we never dreamed was possible in real estate.”
In speaking with another client firm in Chicago managing almost $6B in AUM across multiple value-add and opportunistic funds, their head of portfolio reporting stated they quickly hit the famous easy button – rapid ejection style from Excel Hell by implementing Pereview with Data Management Services.
He said, “It was a no-brainer for us to engage Pereview and their team of real estate professionals who know and understand the intricacies of a trial balance with variances and rent rolls to not only receive but to also collaborate with our operating partners on ensuring quality, accurate data is received month in and month out, freeing up our team to do what we do best in making our next strategic decision based on our past and present data with forward looking assumptions.”
What are the immediate indications of ROI by implementing Pereview?
He responded, “The fractional amount of money we pay for Pereview’s professional Data Management Services as opposed to what a handful of full-time employees would cost is amazing. It is probably our most successful investment, outside of our properties, of course. Excel usage has been greatly diminished and replaced with Pereview custom reports built to my requirements. In fact, I think we only use Excel for our modeling now, which Pereview also connects to.
Schedule a demo today to learn how Pereview can enhance your firm’s real estate asset management strategy. We’ll show you how to optimize your reporting, reduce risk, and make better decisions – without giving up the Excel functionality you rely on.