Updated on May 5, 2022
We received a question from our users on how to consolidate multiple Xero companies into one spreadsheet. Hopefully, this video will be helpful. You need to establish a connection and template for every company on the first login (one time only). Once the template is saved, you can refresh reports for all companies in one click or schedule an auto-refresh.
G-Accon Blog 
We updated a video with sound and new consolidated reports functionality!
LikeLike
you can watch one of our webinar which cover this topic as well:
LikeLike
I would like to watch this video but there is no sound?
LikeLike
helllo!
LikeLike
Yes, auto-refresh works for multiple organizations! You can refresh all your organizations automatically, without opening Google Sheets.
LikeLike
Hi, there is no audio , no sound and i cant hear. do you you have texts for this? when i auto-refresh, my data does not refresh. also do i need to be signed in to any of the company xero in order for refresh data?
LikeLike
Yes, please advise if auto refresh works when using multiple companies ?
LikeLike
Can we use auto-refresh when using multiple organisations?
LikeLike