Enter your idea

We have multiple company Xero files and would like to be able to consolidate three of them for BAS purposes. Merge two subsidiary companies into the parent company for BAS returns. Thís would be so helpful and easier than downloading all the spreadsheets and merging.

We are moving 2 of our companies on to Xero, 2 are already there, and we really do need to be able to consolidate reports between the group of accounts.

So the sooner this idea is put into practice the better, seems it has been a long time in the waiting!

A basic requirement for a group of companies.

I'm using the demo and this will be a deal breaker. Quickbooks already has this feature.

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.