With 37 residential properties, 19 commercial properties, and three hotels to their name, Midwest Property Management is the largest privately-held residential rental property holder in Alberta and the Northwest Territories of Canada. Each of Midwest Property Management’s properties requires its own operations reporting and its own corporate reporting. In addition, the company works with five separate ownership groups that each want to see something very specific. These reports especially need to be customized to each group’s requirements, whether that includes graphs or pivot tables or something entirely different.
When Midwest Property Management implemented Spreadsheet Server into their MRI reporting processes in July of 2017, Property Analyst Joseline Leroux estimated they saved approximately 75 hours—nearly two full work weeks—on reporting. “We used it for our budgets, we used it for our cash reporting,” Leroux said.
But reporting needs changed drastically in early 2020. “COVID hit, and as you can imagine, the first thing anybody’s worried about is cash flow,” Leroux recalled. “Executives needed a huge volume of information regarding analytics to make any kind of decision almost on an hourly basis. In the COVID times, Spreadsheet Server really saved us and allowed us to move so quickly with things that changed every day.
“Even before COVID hit, Spreadsheet Server is just such a game changer for anybody who wants real-time data analysis in a concise and correct format.”