The Challenge
Ten Buildings, Three Levels of Care, No Single View
Sequoia Living's buildings include retirement communities, affordable senior housing, and senior centers, each at a different level of care. Leadership needed an easy way to gather key information like census and accounts receivable so they could track trends, spot potential issues, and take action quickly.
The Solution
Putting the Reports in the Executives' Hands
NorthStar Group's data analytics team delivered that through MyAnalytics.
Receivables visible without running multiple reports
Census trends for a given month, quarter, or year
Census broken down by location and by level of care, with rolling month-over-month and day-over-day history to help schedule staff
Reports and spreadsheets the C-suite builds itself
Real-time data with no third party in the middle
The chief officers are the main users, and the census view is the one that reaches the staffing schedule.
The Results
Year One: Time Back, and a Clearer Read on the Money
Two benefits stand out after the first year. The first is time.
“It really does save us a lot of time being able to understand where numbers are coming from and break them down the way MyAnalytics does. For example, if we're receiving $300,000 from a location, from a specific level of care, we can break it down to living dollars, private pay dollars, and so on. We used to have to run reports and put that data into a spreadsheet to share that information. Having that data already compiled for us helps us run our business more smoothly.”
The second is what the payer-type breakdown does for financial planning. It turned a monthly total into something the finance team can track against.
“It gives us an idea where the money is coming from and to see where we may be falling short or where we may receive a windfall, and whether to expect the continuation of that kind of windfall. It gives us a tracking mechanism, which has been beneficial.”
The CFO, CEO, CIO, chief human resources officer, and the executive directors all use it, and the client wrote its own process documents to support them.
“The executive staff all enjoy using the system. It's very user friendly, especially with the process documents we've created internally.”
What's Next
Where It Goes Next
Sequoia Living plans to expand users this year to include more accountants, business office leaders, and other financial staff.
“Seeing the numbers in real time and being able to trend and report against that to run their respective parts of the organization will bring real value to us.”