Simplify payday and set payroll to run automatically on QuickBooks.

Green Circle Icon with Stylized White Letters
QuickBooksHelpIntuit

Create groups to run multi-company reporting in Spreadsheet Sync

by Intuit • Image Alt Text 12
Image Alt Text Updated 5/24/2026 20:37

Learn how to create groups to run multi-company reporting in Spreadsheet Sync.

In QuickBooks Online Advanced, you can organize your companies by creating groups in Spreadsheet Sync. You can then use the grouped companies to run consolidated reports in spreadsheets. 
Note: Only QuickBooks Online Advanced admin users and standard all-access users can open and manage Spreadsheet Sync.

Organize companies into groups

To organize companies into groups, create multi-company, or consolidated reports. 

  • In the Spreadsheet Sync panel, select Company settings.

  • See all the QuickBooks Online companies you have access to in Companies.

  • To create a group, select + Create group.
    Note: You can also add QuickBooks Online Simple Start, Essentials, and Plus companies to a group for running multi-company reports.

  • Enter a name for the group in the Group name field.

  • Select the Currency for the group.

  • Under Connected companies, select the companies under the Add to group column.

  • Select Save.

Sign in now for personalized help

See articles customized for your product and join our large community of QuickBooks users.

Sign In / Sign Up