QuickBooks Online Advanced companies used to sign in are automatically available within Spreadsheet Sync. Note that only QuickBooks Online Advanced admin users can open and manage Spreadsheet Sync.
Using company data in Spreadsheet Sync
- In the Spreadsheet Sync panel, select Company settings.
- Under Companies, a list of all QuickBooks Online Advanced companies you have access to displays.
- Select + Add company to integrate one of your QuickBooks Online companies into Spreadsheet Sync.
Note: The new QuickBooks Online companies should be associated with the same account as the logged-in company. - Select Next.
Organize companies into groups
By organizing companies into groups, you can create multi-company, or consolidated, reports.
- In the Spreadsheet Sync panel, select Company settings.
- Select + Create group to create a group.
- 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.
Note: You can currently add up to 10 companies per group. - Select Save.