Bridging the Spreadsheet Gap in Commercial Real Estate Management

Written by:

Steve Marcinuk

Date:

09 Sep 2025

Share

Share via Facebook

Share via Linkedin

Share via X

Copy to clipboard

The commercial real estate industry has long been characterized by its resistance to technological change, with many firms managing multi-million dollar portfolios through the same spreadsheet systems they’ve used for decades. However, a growing number of companies are recognizing that manual processes create significant operational risks and revenue leakage, particularly as the industry faces a looming knowledge transfer challenge.

STRATAFOLIO, a software-as-a-service company founded by Jeri Frank, Co-Founder & CEO, and her husband, emerged from this exact pain point. “Like many good companies, it starts because you have a need,” Frank explains. “My husband and I took bonuses, bought real estate, and every month we redid spreadsheets. We were savvy enough to realize that is not a good operational model for growth.”

The Genesis of Automated Property Management

Frank’s background at Pearson and her husband’s aerospace software engineering experience provided the technical foundation for STRATAFOLIO. Their initial foray into residential real estate management evolved into a commercial-focused platform after working with developers in Iowa.

“The things they were struggling with, we dealt with somewhat on the residential side. It was just exacerbated for those commercial real estate owners,” Frank notes. “People we talked to still manage 20, 50, 100 million dollar portfolios in spreadsheets.”

STRATAFOLIO’s value proposition centers on reducing manual work by 80% through QuickBooks integration, targeting companies that manage commercial real estate with multi-year leases and require tracking lease escalations and CAM reconciliation or triple net leases.

Market Adoption and Geographic Reach

The company has clients across the United States and Canada, with higher adoption in California, Texas, Florida, and Tennessee. “What separates us from a lot of the property management software out there is that we focus on commercial assets that have multi-year leases,” Frank explains. “We’re famous for our one-click CAM reconciliation.”

Learning Through Beta Testing

STRATAFOLIO’s development process revealed three foundational insights: focus on multi-year lease commercial real estate, the prevalence of QuickBooks among clients, and the need for full-service onboarding. “Those onboarding efforts failed because they never took the time to onboard themselves,” Frank recalls. “So now we do a full-service onboarding, and we have staff that are accountants, they’re QuickBooks pro advisors, and they know commercial real estate.”

Revenue Recovery Through Expert Implementation

This onboarding approach has yielded unexpected client benefits. Frank reports 100% return on investment solely through identifying missing revenue during implementation. “We often identify lost revenue. Right now we have 100% return on investment in just revenue that we have identified that was missing from their books because they had missed lease escalations, or they had left something out of their CAM reconciliations,” she explains.

Generational Shifts Driving Technology Adoption

While commercial real estate has traditionally been slow to adopt technology, Frank observes significant shifts in market receptivity, driven by concerns over knowledge concentration and succession planning.

“I’m having more conversations every day with people who are concerned that they are the only individual who knows certain things about their tenants.They are actively working to put systems in place that anyone can step in and take over.”

The next generation entering the industry brings different expectations from residential leasing. “When they were a renter, they were used to an experience with streamlined communications. When they come into that commercial real estate office, they want that same capability available for their tenants.”

Frank notes the disconnect between residential and commercial tenant experiences: “When you think about residential tenants paying $1,500 to $3,000 a month, and commercial tenants paying maybe $3,000 a month, sometimes $100,000 a month for rent, those tenants should have a professional experience where they can log on, see their lease, upload their certificates of insurance, change their contact information.”

Strategic AI Implementation

STRATAFOLIO has embraced AI and automation, with an initial application targeting tenant certificates of insurance. “It’s not a big deal until it’s a huge deal and the tenant has lapsed on their coverage and disaster happens,” Frank explains. Their system automates certificate information entry, reminds tenants for uploads, and confirms correct completion. “It’s a real, live application that removes manual work from the owner operator,” Frank notes.

On AI risks: “Everyone who is implementing AI is concerned about the AI deriving incorrect information and potentially hallucinating. It has to be deployed carefully and not all at once.”

The Hidden Cost of CAM Reconciliation Neglect

Frank identifies missing lease escalations, tenant certificate management, and CAM reconciliation as top client pain points. “CAM reconciliation is under-focused on…and we see people…it is a direct hit to the bottom line for owners,” Frank explains. “Sometimes owners will say, ‘It’s a lot of work to do this CAM reconciliation. I’m just going to roll over what I did last year.’ Well, taxes have gone up, insurance has gone up, every other expense has gone up.”

STRATAFOLIO published research on The Shocking Financial Impact of Neglecting CAM Reconciliation, showing how shortcuts directly affect profitability. “When you have a system in place that allows you to quickly do CAM reconciliation, you can get it done in January, which creates a better experience for your tenant and a much better experience for your bottom line and cash flow,” Frank concludes.

Looking Forward

As commercial real estate faces operational challenges and margin pressures, companies like STRATAFOLIO embody a recognition that technology adoption is now essential. Generational change, succession concerns, and operational efficiency create a more receptive environment for solutions that augment human expertise, capture institutional knowledge, and ensure critical processes like lease escalations and CAM reconciliations don’t fall through the cracks. The shift from spreadsheets to integrated platforms represents a fundamental step toward professionalizing commercial real estate operations for the next generation.