Skip to content

This tool is no longer available on Xero. If you have any questions please reach out to Xero support.



Read more about Videos



20 July 2011 #

perhaps i am missing something…but where can we get this macro from?

Richard Phillips
21 July 2011 #

@Toby – well spotted and quick too! The macro will be available in the Resources tab of Xero Partner Edition when we roll the next release in early August.

David Barton
21 July 2011 #

Wicked. Can’t wait to try it out

21 July 2011 #

Does it handle multiple companies in multiple countries?
Also why do we have to use a macro? Seems like a cheap and dirty work around. Surely we should be able to do this properly within xero?

Kim Ashurst
22 July 2011 #

I can’t wait to see this – is this coming out in the UK version as well?

22 July 2011 #

@Richard Partner Edition?? Does that mean I won’t have access to it, even though I have 4 “Large” Xero accounts?

James Riddell
25 July 2011 #

+1 for having the macro available to regular non partner-edition users.
+100 for having this available as standard in the Xero application. I would pay for a new organisation that was a consolidation of other organisations if necessary.

Richard Phillips
25 July 2011 #

@Toby happy to provide this to anyone who wants it – not just partners.
@Gavin building this into Xero is something we could look to do. For now we need to focus our resources on building out core features and into areas where we get a lot of requests. In the meantime we thought it would be good to offer this functionality via a tool our accounting partner Deloitte have built. We’ll continue to monitor the requests for making this part of Xero.

25 July 2011 #

@Richard Thanks for email, I think you could safely assume any person that has more than one account would like a consolidation tool!

Gavin Cooney
26 July 2011 #

@Richard So in other words there is no multiple currency support?
Also just noticed that it’s only for partner edition. So not only is the ‘feature’ a cheap excel hack, with no multiple currency support, it’s not available to us meer mortals with multiple companies on xero?
C’mon xero… you’re better than this!

Rod Drury
26 July 2011 #

Proper consolidations from Xero will come after we’ve delivered Report Packs completely as they build the foundations for smart consolidations. This Excel spreadsheet from Deloitte is a good temporary measure. We have also seen others use the Reporting API to pull reports out of Xero in XML and consolidate in code.

No reason why the Excel spreadsheet can’t be extended to handle currencies.

Sorry but as always there is so much to do but native consolidations is a direction we’re working towards as you can see with the Report Pack work.


Denis Breen
28 July 2011 #

Well Done Xero
This should be very useful. We’d prefer to keep consolidation in Excel anyway. Looking forward to the report pack release.

25 August 2011 #

Please can I have the spreadsheet, not a partner but have 2 multi currency accounts. tips for using this with multi currency appreciated

Jon Stacey
2 September 2011 #

Guys, any sign of this appearing – I can’t see it in the resources section of the partner edition but perhaps I’m missing something?

Richard Phillips
2 September 2011 #

@Jon, expect to see this in Partner Edition in the next week.

James McCarthy
5 September 2011 #

Could I please have a copy of the spreadsheet? Thanks in advance.

Adrian Rands
13 September 2011 #

Can I also have a copy of the spreadsheet or a link to the file? Thanks.

Richard Phillips
16 September 2011 #

Quick update everyone – this tool is now available for partners in Xero Partner Edition – Resources tab. For any non-partners that would like access, please email and we’ll be happy to provide it.

Samantha Smith
22 September 2011 #

Awesome work guys, I keep falling in love with you over and over again!!

David Carr
3 November 2011 #

Has anyone used this consolidation tool? How useful have you found it?

18 November 2011 #

Can the consolidation tool handle multi currency? i.e UK GBP accounts converted to Euro then consolidated with Irish Euro accounts

Richard Phillips
18 November 2011 #

@Declan, you’ll need to convert figures to a standard currency first – then consolidate.

18 November 2011 #

I have requested a copy of this macro from Support, so when I get it I will have a play … but realistically, I agree with others, this needs to be a core feature!
Along with the ability to run other reports across a group (e.g. how much did our subsidiaries spend with Supplier X in the last 6 months). Anyone know of any offerings from 3rd parties that might make this easier?

Mel Cann
22 December 2011 #

I’ve tried to run this but it keeps throwing up an error message, even on the demo version (‘an error has occurred on the reports – please try again’). Any of you have had error messages? If yes, how did you get round them? Thanks.

Richard Phillips
23 December 2011 #

@Mel we’ll be in touch to help you get this running.

14 February 2012 #

Hi there, I’m getting the same problem as Mel Cann above. Can’t even get the demo to work. Thanks!

Elizabeth Salter
21 February 2012 #

What an awesome resource. Thank you!

1 April 2012 #

can I have a copy of this macro please?

28 August 2012 #

Cant even find consolidation under Resource Tab?

Richard Phillips
29 August 2012 #

@Debbie it’s under the Practice Resource section in the Resource Tab

10 October 2012 #

Demo worked but not when I’ve tried with our companies! Can it be because 1 company has 13 bank accounts and the other only one ??? and 1 have same account number but different name? + intercompany same accounts but different name!

Richard Phillips
10 October 2012 #

@Gabrielle – this tool is now quite out of date. We haven’t updated it as there is now an Add-on Partner that provides this service. You can check them out at

10 October 2012 #

This tool was given to me today by Xero support! Thx. Will look into the Add-on

Michael Graham
29 November 2012 #

Richard, can you pelase send me a copy of the excel tool.

12 February 2013 #

Oh well, I’ll have to wait to change to Xero it seems as I don’t want to use a macro to get such reports out. And as somebody else has said ‘what about multiple currency?’

Richard Francis
14 February 2013 #

Hi everyone. Spotlight Reporting ( produces simple consolidations (including multi-currency) for up to 10 related Xero orgs. Each org gets a Spotlight Report as well as the consolidated ‘group’ view, great for performance tracking and informed decision-making. Extended functionality is due soon.

17 April 2013 #

Has anyone used Spotlight? I don’t want to have to convert my GBP balance sheet into USD, MYSELF, before consolidating with my USD balance sheet. That is the major pain point with consolidating, and the reason lots of folks are looking for multi-company, multi-currency consolidation. Does Spotlight have this capability?

6 June 2013 #

Spotlight Multi looks like it could be useful. They offer a free demo / trial period. It seems easy to connect your subsidiaries up.

Major problem so far is that, after connecting my subsidiaries up, it fails to build the report so I actually haven’t seen if it is any good or not! I have logged this with their help desk and they got back to me very quickly but have yet to actually fix or advise. In addition,

I have two other queries logged with them I am yet to hear back on:

(1) I can’t see where Spotlight Multi allows me to enter in any consolidation elimination entries – very important for groups of companies, and

(2) because I can’t see the reports yet (as they fail to build), I don’t know how Spotlight Multi handles foreign currency conversion – it says it does it but the devil is in the detail and I want to know how it converts previous months P&L’s as well as how it converts Balance Sheet accounts such as Retained Earnings etc.

Does anybody have any experience with Spotlight Multi or can answer any of these queries?

Richard Francis
7 June 2013 #

Hi Chris

I’m reluctant to go into details of a recent support ticket raised for our product on the Xero blog, but:

+ Multi has an editable data grid for you to perform any eliminations; and
+ Multi uses the same foreign currency conversion service as Xero, albeit not at a transaction level.

Multi is primarily designed for large-scale aggregation, benchmarking etc of franchises and not-for-profits. You’ll probably find Spotlight Reporting (which can consolidate 10 related entities) as a more fit-for-purpose tool.

From our website you can access training resources including video tutorials.

We are best suited to simple consolidation needs at this time and don’t necessarily feel that we are there yet for year-end and complex needs. The Spotlight tools are focussed primarily on the trusted advisor, advanced management reporting space.

We’ll be in touch soon. Thanks.

31 January 2014 #

Could anyone at XERO provide a current update on the direction of consoldiation . We currently use XERO but need to perform consolidation functions that we no longer wish to do in excel.

David Watson
3 February 2014 #

Hi Daniela,

If you are open to using an add-on solution for consolidations, you may wish to try Fathom ( ). Fathom helps you to group your related companies together to easily create consolidated reports.

A few key features:
– Fathom enables consolidation for small and large groups (up to 250 entities).
– Fathom consolidates both your financial and non-financial results and also any targets.
– If required, you can easily process eliminations to filter the impact of any intercompany accounts (ie intercompany loans, management fees etc…) from your consolidated analysis.

In addition to consolidations, Fathom also helps you to easily compare, rank and benchmark each of your companies. This is specifically useful for franchises and other multi-entity organisations.

Daniela, please let me know if I can assist with a guided tour of these features.

13 February 2014 #

This is exactly function i am looking for. Could you please email me? Thanks!

Ernest Ong
19 February 2014 #

This is the function i am looking for. Could you email me please.

Peter Clarke
28 February 2014 #

Xero … stop beating around the bush and make this a core feature.
I have 2 branches i keep in seperate accounts, … downloading the reports then consolidate in excel … takes too long .. all i want is a quicksnapshot each week.
I dont have an hour to spare to go through the excel process.
Thanks for moving this up to the important new features.

Jane Cooke
18 June 2014 #

We have recently converted our three global companies to Xero. One based in Europe, one in the USA, one in Australia, with over twenty years experience advising others and overseeing the finance function in a number of diverse organisations I expected this change over regardless of the amount of preparation and planning invested to equate to my recent trip to the dentist to extract a much loved tooth, to take longer than anticipated, hurt more than could be possible given the pain killing injections, the actual implementation very uncomfortable, being vulnerable feeling exposed and very intrusive, and once the operation was over, the discomfort at the new feel of my mouth harder to operate and adjust to. It hasn’t been, the implementation of Xero has been easier and quicker than anticipated the functionality better and more comprehensive than I believed, the ease and comfort with adapting to its use amazing in it being such a non issue. Why am I writing this comment then, well because the one and only shortfall and disappointed I have had with Xero to date is this blogs topic Consolidated Accounts, doesn’t do it, isn’t doing it and given the last comment on this blog was Feb 2014 you Xero guys might be thinking it doesn’t matter. I just would like to let you know that it does and it is your one thing that is well how can I say this nicely letting you product and brand down in my eyes, it basically places the product in the sole trader, corner shop, well, myob market. I have had to go out and find third party solutions, which I have what I don’t understand is that this is not brain surgery, you guys could do this added feature quite easily so please put it back on your to do list from three years ago and do it. I know you can.

19 June 2014 #

Is this macro tool still available? If so, where can I download it please?
I’ve looked at the Spotlight option recommended by Xero and think the macro tool will possibly suit us better.

Gregory Parsons
28 September 2014 #

We have 4 Xero entities that we consolidate on a regular basis. All are different currencies. If anyone is interested in using our consolidation solution (cloud based subscription) let me know. Consolidation can be managed for a larger number of entities. If you are interested email me at

Add your comment

We welcome all feedback but prefer a real name and email address.