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!