Share:

Share on facebook
Share on twitter
Share on linkedin

80 Xero Clinics Consolidated in a Click

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.”

Recent Posts

Top 5 Tips & Tricks For Planning, Budgeting and Forecasting in Power BI & Excel In this blog I am

Planning and Analytics [Infographic]

It is not uncommon for companies to have separate planning and analytics processes or legacy solutions that result in more

Materialize and Synchronize Power BI with a Data Warehouse “Materialize” is a database concept that refers to storing the result

I can’t help smiling when I see legacy BI/Planning application vendors -that were not so long ago laughing away Power BI- coming out with their own “Power BI Integration” after Microsoft has turned around the industry. These are more often than not nothing but “a marketing spiel” to build on Power BI’s awareness and of very limited use in real life application scenarios.

Across many mid-sized and large companies, finance and operations teams are at crossroads. This was one of the findings from the recent BPM Pulse 2021 survey which revealed that only a third of companies had truly harmonized strategic, financial, and operational plans.

Tags