Restructuring made simple with Xero

Due to our client’s parent company going through a large acquisition, our client was given the opportunity to branch out and restructure the entire company. Part of this included our client wanting to move their in-house accounting function to Xero.

Restructuring made simple with Xero

Legacy in-house accounting function – not fit for purpose

The group consisted of several entities and the client wanted to use Xero for its user friendly benefits, but also wanted a bespoke consolidation report which could be run by departmental codes rather than the usual chart of account codes. Our usual default method would be to use Spotlight reporting for any consolidations, however in this instance we needed to consider a method that would not only consolidate by the department codes, but also allow us to have several other detailed reports such as an executive page with the clients key KPI’s and a monthly reporting tab with a breakdown of live businesses and exited businesses.

Automated reports with the click of a button

By taking the time to understand our client’s needs, we were able to offer a bespoke consolidated report using Power BI. Our data analytics team have expertise using open API’s and was able to link up each of the Xero accounts we created to Power BI, producing an automated report with the clients desired chart of accounts and department codes at the click of a button. Not only was the report able to summarise the account balance by the summarised grouping provided by the client, but it also allowed us to drill down into each figure without having to open up each Xero account and locate the transactions. The Power BI report could be extracted easily and input into the excel management report, along with the other tailored reports.

Investing in their future

By upgrading their accounting function to Xero and the reporting to Power BI, the client has access to an accurate and more informative report that can be delivered to the investors on a timely basis.

Restructuring made simple
with Xero

Assessment

The group consisted of several entities and the client wanted to use Xero for its user friendly benefits, but also wanted a bespoke consolidation report which could be run by departmental codes rather than the usual chart of account codes. Our usual default method would be to use Spotlight reporting for any consolidations, however in this instance we needed to consider a method that would not only consolidate by the department codes, but also allow us to have several other detailed reports such as an executive page with the clients key KPI’s and a monthly reporting tab with a breakdown of live businesses and exited businesses. 

Project delivery

By taking the time to understand our client’s needs, we were able to offer a bespoke consolidated report using Power BI. Our data analytics team have expertise using open API’s and was able to link up each of the Xero accounts we created to Power BI, producing an automated report with the clients desired chart of accounts and department codes at the click of a button. Not only was the report able to summarise the account balance by the summarised grouping provided by the client, but it also allowed us to drill down into each figure without having to open up each Xero account and locate the transactions. The Power BI report could be extracted easily and input into the excel management report, along with the other tailored reports.

Transformational change

By upgrading their accounting function to Xero and the reporting to Power BI, the client has access to an accurate and more informative report that can be delivered to the investors on a timely basis.

Transformational change

By upgrading their accounting function to Xero and the reporting to Power BI, the client has access to an accurate and more informative report that can be delivered to the investors on a timely basis.