QuickBooksHelpIntuit
Create groups to run multi-company reporting in Spreadsheet Sync
by Intuit• Updated 1 week ago
Learn how to create groups to run multi-company reporting in Spreadsheet Sync.
In QuickBooks Online Advanced or Accountant, you can organize your companies by creating groups in Spreadsheet Sync. You can then use the grouped companies to run consolidated reports in spreadsheets.
Accessing Spreadsheet Sync
The following user types can access Spreadsheet Sync:
- Primary Admin
- Company Admin
- Standard (All access)
The following parameters apply to Accountant users:
- Team members must have been provided client access.
- Only clients with Advanced SKUs can use Spreadsheet Sync.
- An Accountant user is considered a Company Admin on their client's company, thus all Accountant users should be able to access Spreadsheet Sync within a client's Advanced file.
Organize companies into groups
By organizing companies into groups, you can create multi-company or consolidated reports.
- In the Spreadsheet Sync panel, select Group.
- See all the QuickBooks Online companies you have access to in Companies.
- To create a group, select + Create group. Select + Group multiple companies, if you are creating for the first time.
Note: You can also add QuickBooks Online EasyStart, 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.
- Select the companies under the Add companies to group column.
- Select Save.
- From the Select report ▼ dropdown, select a report.
- Choose the filters you want to apply on the report.
Under Date range, select whether to see weekly, monthly, quarterly, or yearly data and the start and end dates of your data period. (For multiple period reports, select filters for a total time period and comparative time periods.) - Select Run report to generate the report on the spreadsheet.
Sign in now for personalized help
See articles customized for your product and join our large community of QuickBooks users.
More like this
- Create a Record of Employment (ROE) in QuickBooks Onlineby QuickBooks•1251•Updated April 11, 2024
- Create journal entries in QuickBooks Onlineby QuickBooks•1182•Updated 3 weeks ago
- View your pay stubs, time off, and year-to-date pay in QuickBooks Workforceby QuickBooks•1438•Updated May 28, 2024
- Add and manage users in QuickBooks Onlineby QuickBooks•453•Updated 2 weeks ago
- Frequently asked questions about merging companies, data files, or copy lists in QuickBooks Onlineby QuickBooks•13•Updated January 29, 2024