button

DATA CONSOLIDATION CASE STUDY - PROPERTY MANAGEMENT

Vena Helps FirstService Residential Consolidate FP&A Data 90% Faster
fs-hero

Snapshot: FirstService Residential

noun_House_1884342-1
One of the largest residential property management firms in North America
multiple-locations-icon
FP&A team consolidates data from 30 regional markets
integration-icon-e1591136340732 (1)
Integrations: Microsoft Dynamics GP for ERP
“The biggest factor was ease-of-use because Vena is Excel-based. If you’re working in finance or FP&A, you’re already an advanced Excel user, so that was really important to us.”
Robbie Phillips
FP&A Director, FirstService Residential
fs-before-vena

FirstService Residential Before Vena

Robbie Phillips is no stranger to massive Excel spreadsheets. After 15 years in finance with some of America’s most successful companies, you could almost say Excel is like a second language for her. 

But like all seasoned finance pros, Robbie knows how tough it is to rely solely on offline spreadsheets for business planning. As Director of FP&A at FirstService Residential—one of the largest property management firms in North America—Robbie is in charge of consolidating data from the company’s 30 regional markets for accurate budgeting and forecasting.

Prior to launching Vena, this process was entirely manual. Robbie and her colleagues would spend all of their time gathering data from each market and re-inputting it back into Excel—with no time left to actually analyze what those numbers might mean for the business. 

“For budgeting and forecasting in particular, that was thousands of Excel documents, thousands of workbooks, each workbook having multiple tabs, in excess of 30 tabs in some cases,” says Robbie. “The task of coordinating and consolidating was a very big one.”

fs-vena-solution

The Vena Solution

Before implementing Vena in the summer of 2016, FirstService had looked at three other planning tools without pulling the trigger on any of them. But when Vena came to the table, Robbie was immediately drawn to the platform’s usability and minimal learning requirements.

“The biggest factor was ease-of-use because Vena is Excel-based,” she says. “If you’re working in finance or FP&A, you’re already an advanced Excel user, so that was really important to us.”

Vena automated data consolidation for FirstService's regional finance teams and provided each market with a central database for FP&A. Other key deliverables from Vena—on top of cleaning up all those messy offline spreadsheets—were workflow automation and audit trails.

Once the solution was live in every market, it didn’t take long for Robbie to realize that her manual spreadsheet woes would soon be a thing of the past.

FirstService Residential With Vena

report-1-e1588193441481
90% reduction in consolidation times, from a day and a half to 1 hour
app-icon
Familiar Excel interface requires minimal training and provides greater comfort for users
database-sharing
Advanced drill-down capabilities for easier analysis of each individual business unit
fs-key-results

Key Results

The results? Hours of time saved, greater transparency across the business and an elevated role for the office of finance and accounting. Today, instead of spending hours consolidating data manually, Robbie can update the budget and reforecast on demand so leadership is always empowered with the data they need for decision making.

“One of the things that we do in the corporate office is consolidate for all of the markets, all of the regions, all of the divisions. It’s down from maybe a day and a half to an hour,” she says. “Now the teams have more time to do more of the analytical work, which is what we’re there for.”

A personal win for Robbie is the ability to ensure that each regional market is accountable for their budgeted numbers—and also to better understand how each market is affecting the bottom line. With Vena, she’s now able to drill down into each market, analyze their KPIs and come up her own conclusions based on the story the numbers are telling her.

“It allows me to answer questions and to also challenge some of the assumptions that the markets may have,” she explains. “Now I can go back to senior management and have them feel that the final budget is not only accurate, but representative of each market as well.”

Ready to start your own growth journey?

Request Demo