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.