Enter your idea

Can't believe it's been 12 years since this idea was first brought up and this feature still hasn't been addressed. Could we please get the ability to consolidate multiple entities?

I have a few 'group' of companies and/or holding companies where group reporting becomes more and more important and a necessity for compliance.

Will soon need to consolidate group accounts for a small group.

Possibility to define a "Contact" as "related party" and creating dedicated "A/P" and "A/R" or adding the "related parties" filter to each report.

This is 100% what Mayday is designed to do.

https://www.getmayday.com/?utm_source=xero&utm_id=community

If you have multiple Xero orgs that have intercompany transactions and balances, Mayday will be the solution you're after.

They handle intercompany recharging, with mark-ups. So that covers off one challenge you're having.

They also have a fantastic intercompany reconciliation tool, makes it easy to keep loans in balance and automates discrepancy identification.

In terms of feedback, I can see over 150 five star reviews on the xero app store.

Every month I combine reports from 3 orgs into one spreadsheet for one view

The right and ability to export all the data I have lovingly (cough) input across the firms intercompanies would be a game changer. I would pay a small small add on fee as appreciate not all standard users/sole traders would require this option.

For me it would be as simple as basing it around the chart of accounts report, adding the entity field with the option to choose the period and year to date balances (maybe tracking fields too as in other standard reports)

I would be able to manage mismatched codes and prepare consolidated accounts using excel functions easy enough

Allow users to easily consolidate their entities to form a consolidated P&L and BS

Including consolidation of budgets

Agree with Simon Jones comments. It would make sense for us to have another entity set up for consolidation entries to be complete.

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!

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.

Would be a game changer for us with multiple entity levels.

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.

What third party do people use to achieve this? We need to be able to solve this.

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.

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

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.

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)

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