Download PDF
Centage > Case Studies > Faster Budgeting and More Timely Reports Provides Greater Visibility into Personnel Expenses
Centage Logo

Faster Budgeting and More Timely Reports Provides Greater Visibility into Personnel Expenses

Technology Category
  • Functional Applications - Enterprise Resource Planning Systems (ERP)
Applicable Industries
  • Healthcare & Hospitals
Services
  • System Integration
The Challenge
SerenaGroup, a global healthcare management company, was facing challenges with its financial structure. The company operates across multiple locations, each of which is considered a separate cost center. This structure required the creation of a full profit and loss statement for each individual site every reporting period. The company's existing solution, QuickBooks Enterprise, was capable of producing the individual P&Ls, but it did not support the consolidation of these into a summarized report. The workaround involved a time-consuming process of exporting and merging spreadsheets in Excel, which took 2-3 days every month. This process was prone to errors and did not allow for precise forecasting. Additionally, SerenaGroup needed to allocate overhead expenses to individual facilities, which added another layer of complexity to the process.
About The Customer
SerenaGroup is a global healthcare management company that develops Centers of Excellence in wound care and hyperbaric medicine. Founded in 2002, the company has locations across the United States and works with hospitals, nursing facilities, and state-of-the-art wound treatment centers. SerenaGroup also conducts clinical trials ranging from bioengineered skin to growth factors to platelet gels. The company's financial structure separates their locations into 25 to 30 separate cost centers. Each of these cost centers required a full profit and loss statement every reporting period, which was a time-consuming and error-prone process.
The Solution
SerenaGroup decided to supplement its existing QuickBooks Enterprise system with Centage Corporation’s robust budgeting, forecasting, and reporting tools. This solution allowed the company to handle actuals in QuickBooks and use the Centage tools for more sophisticated financial tasks. With this implementation, the company was able to produce individual P&Ls and a consolidated version monthly with just a few clicks. The solution also allowed SerenaGroup to complete the double layer of allocations they needed by creating a custom-built, automated process. This process performed the overhead allocation after the personnel allocation was complete, thus producing the cost center distribution results that SerenaGroup was looking for. Additionally, they created a new data group for personnel expenses to give SerenaGroup an unprecedented look at payroll expenditure detail at the FTE and location level.
Operational Impact
  • The process of collecting data and preparing separate reports, then combining the dozens of cost centers to create the consolidated company-level financials, which previously took two full working days every month, now takes minutes.
  • The solution allows for easy running of 'what-if' scenarios to explore business opportunities and analyze expenses.
  • The solution provides a variance analysis on the results that wasn’t possible when the financial statements had to be manually prepared in Excel.
Quantitative Benefit
  • SerenaGroup saves 24 workdays a year that were previously spent compiling and formatting financial reports in Excel.
  • The company has been able to defer adding another accountant to their team.

Related Case Studies.

Contact us

Let's talk!

* Required
* Required
* Required
* Invalid email address
By submitting this form, you agree that IoT ONE may contact you with insights and marketing messaging.
No thanks, I don't want to receive any marketing emails from IoT ONE.
Submit

Thank you for your message!
We will contact you soon.