Reporting - Ability to consolidate multiple Xero organisations
To have the ability to combine the reporting between more than one Xero org.
Purpose: Better at group budgeting and account managements

-
Kate Parker commented
Agree with Simon Jones comments. It would make sense for us to have another entity set up for consolidation entries to be complete.
-
Simon Jones commented
technically I'd have thought this was straight forward. A separate data dump consolidation module allowing each entity to dump p&L balance sheet and analysis codes (if required) into a data cube. It would require a "Consolidation entries " ledger to be treated as a separate entity in the data dump, and some basis accounting discipline in adhering to a standard group Chart of accounts. But apart from that - Simples! so Xero please can you just do it and stop ******* around with new expense apps that replace old ones that work fine!
-
Tim Winstone commented
We have 4 Xero entities across our group of organizations. Being able to have consolidated reporting for P&L and Balance sheet would make a huge difference. The key is that we have the ability to consolidate using tracking categories, as this is how we report in our organization.
Currently we have to do this all in Excel as other 3rd party Reporting tools do not consider tracking categories. -
Chloe Hughes commented
Would be a game changer for us with multiple entity levels.
-
Volodymyr Lysychnyk commented
It would be great if Xero could add a mapping tool with the option to post exceptions.
I'm ready to pay for this feature. Because what is offered in the marketplace is absolutely useless. -
Adam Ross commented
What third party do people use to achieve this? We need to be able to solve this.
-
Roxanne O'Sullivan commented
This definitely needs to be implemented, we have a group of 40+ entities, to have the ability to run one report across all entities would save hours of time each month.
-
Alexandre Ung commented
As a group of companies, each of our companies are on XERO
That is why we need to have this functionality to be able to function "centrally", and avoid to export each report 17 times (because we have 17 companies...)
Please support this development
Thank you in advance
-
Fabien Ecard commented
this needs to be part and parcel of the product. Relying too much on various third parties to do this right now. Not only it's expensive, but very time consuming.
-
Andrew Lim commented
THIS SHOULD be standard feature for customers who choose to use Xero for all their entities. Currently the only way to do this is through third party apps who charge unreasonably high the more entities you have, just to extract data and export to a spreadsheet like Excel, Sheets, etc.
And i don't think we can easily link Excel to the Xero API too as I understand they work on a Outh2 linkage and need another 3rd party add on as well.
The least Xero can do after increasing the fees is so much is to provide a free add on for customers to export data for all entities in Xero (if this can't be implemented in Xero platform itself)
-
Muhammad Naeem Mumtaz commented
Hi,
I suggest that Xero should have ability to consolidate multiple entities. It will save a lot of time and cost to their customers.
Kind Regards
Naeem -
David Elsey commented
Have a look at https://xpna.co - consolidate as many Xero files as you need, automated eliminations, multi-currency etc etc.
You can trial it for 15 days for free.
-
Elana Gold commented
We moved to Xero to improve our accounting functionality which is sadly lacking especially with consolidations.
-
Monique Wolvekamp commented
It would be nice to have this integrated and not to rely on an add-on
-
Kim Lyster commented
We need this also, it is so time consuming having consolidate all the reports manually. Maybe I should invoice Xero for my time each month for having to do this manually.
-
Kieran Holsgrove commented
We need this! We have multiple companies and it takes a long time to manually consolidate reports for the group.
-
Irene Lim commented
Just saying - MYOB already one step ahead on this. I think Xero need to pick up their pace with this one.
-
Travis Ho commented
Guys, please use Fathom. It works perfectly on consolidating numbers among Xero entities.
-
Les Harvey commented
This feature would make Xero much more effective across multiple related entities.
-
Toby Anstruther commented
currently it is this limitation which is preventing me from using Xero more widely