Table of Contents
Myhealth were looking for a consolidation solution for Xero companies. The organisation is Australia’s fastest growing medical centre group, providing an exceptional experience for all patients, doctors and staff. A team of GPs, specialists, nurses is focused on quality health care in first-class facilities leading in the area of technology, innovation and development.
Limited Consolidation in Xero
Key pain points for the organisation were extensive preparation times with their spreadsheet-based reporting & planning process from their Sydney based headquarters and 80 clinics across the nation.
Myhealth is using the cloud based Xero system with each of the 80 clinics using a separate Xero company. Before implementing Acterys the information had to be manually loaded into Excel spreadsheets that had to be integrated for the financial reports.
Solution
With Acterys Apps for Xero the data from all Myhealth clinics is automatically updated and loaded into a cloud-based data model based on a standard relational database platform.
The model is optimized for financial analysis purposes there is no need to deal with raw API tables or hire expire expensive consultants for preparation. Important features like consolidation of all entities, time intelligence, currency translation as well as automation of manual journals are available out of the box.
Users in the finance department can build the required reports with their existing Power BI and Excel knowledge exactly to their needs.
Outcomes
With Acterys Myhealth was able to nearly completely automate the process for preparing monthly reports, board papers and planning/forecasting processes. Previously it took 5 days to prepare the required reports. Users love the ease of entering their numbers in conjunction with unparalleled analytics features and responsive visualizations in Power BI.
Ferdia Doherty at Myhealth commented on the results achieved: “Consolidated reports that include everything from the total group results to drill down to the single transaction are now available at a click”
“The front end for the solution is still Excel where we already have knowledge in house, but the data is now updated live from the data model and we avoid the typical menial maintenance tasks allowing us to put our focus on analysis and ensuring that that the strategic targets are met.”