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
-
Graham Oddy commented
It is not at all unusual for a client to have more than one group company and so it is essential to have the ability to consolidate their figures. As with the lack of Back-Up this is a facility that it is extraordinary that Xero doesn't already supply.
-
Mark Tewkesbury commented
A must have! Quite surprised it isn't a feature by Xero as they are very good!
-
Richard MIlls commented
Would be a great feature for users like us who operate multi companies
-
Graham Oddy commented
This is a "Must Have" for any accounting system. Having to use a "third party" app to achieve consolidation makes Xero look 2nd rate in comparison to its competitors.
-
Rene Irwin commented
It is very time-consuming consolidating our monthly Management accounts via excel. My Management is wanting a more extensive look into the financial side of the business this coming year which is going to take MORE time to consolidate.
-
Daniel Smith commented
I cant believe XERO cant do this & MYOB Can! MYOB is catching up..
-
Monica Rossi commented
I echo the previous requests/comments for this feature to be up and running in XERO asap. Consolidating financial reports for different entities is really time-consuming if done manually through Excel. Please could you look into this at your earliest? Thank you!
-
Kate Fargher commented
This is more than important to our organisations. We are currently having to copy and paste bits of reports together, very time-consuming and open to error.
I have not selected critical, because we will survive without it, but it would save a load of time and grief!
-
Simon Jones commented
to do intercompany transactions properly and isolate them in the p&l and balance sheet to allow easy elimination on consolidation requires a parallel set of accounts to sales ledger and purchase ledger to allow intercompany invoicing and booking of intercompany bills. This would keep intercompany transactions properly separate but maintain the sales and purchases functionality. At the moment to make this work properly the work around means use of journals and pdf invoices produced outside xero - not pretty and definitely not ideal
-
Viet Nguyen commented
Hi Mark, you could try our product Collately at https://workspace.google.com/marketplace/app/collately/1077882379255. This is a Google Sheets add-on which allows downloading or uploading data from multiple Xero organisations into a Google Sheets report. You could schedule for this download to run automatically as well.
Cheers,
Collately team -
Gordon Ogborne commented
Our organisation has the need to be able to consolidate an entity based here in Australia with an entity based in the UK and state the consolidation in a chosen currency, in this case AUD. The inability of Xero to be able to handle this will force us to move off the software platform. Over to you Xero to get the software developers to make it happen.
-
Dianne Carino commented
This will be a great feature in XERO reports since consolidating financials for entities is really a time consuming if done manually through Excel.
-
Rupinder Dhaliwal commented
Report Packs - Consolidated Reporting
Does Xero have anything on the roadmap for consolidating different entities to prepare a group report. This is a must for group structures but currently there is no ability in Xero. Currently we have to rely on Spotlight (to consolidated amounts) and then excel template to get all the required notes. This feature was available in MYOB AO, why can't Xero do it.
-
Amit Patel commented
I agree with all the comments here. Xero needs a way to consolidate multiple financial statements entities in Xero.
-
Alex Scobie commented
Having the ability to consolidate multiple entites is very important as many NFP and small business have multiple entities. This is an impediment to MYOB users moving to Xero. And if MYOB can do it....
I wonder if anyone looks at these posts. I suspect maybe it is a way of software providers pretending to be listening to their users.
-
Kirrily McKay commented
Producing consolidated Financial Reports across multiple Xero organisations is currently very time consuming - would be invaluable to have this feature as part of the standard Xero subscription.
-
Robyn Obrien commented
Great function to have as would save a lot of time from manually doing so. Like the Xero report range, just want to be able to consolidate multiple xero files.
-
Mark Smith commented
Ability to report on multiple organisations within one report, whether it's one report with sections, or separate reports within a multi-page report with one page per company. Could possibly work where the organisation is treated like a contact group, ie another layer of filtering/grouping.
-
POVG Treasurer commented
This will save some considerable time at the end of a year and for general reporting to the Board.