Only QuickBooks Online Advanced or QuickBooks Online Accountant admins can initially access Spreadsheet Sync and grant user access. See how to change the primary admin user in QuickBooks Online for more information.

The following roles can use it:

• Primary admin
• Company admin
• Standard all access

For QuickBooks Online Accountant users:

• Must have client access.
• Can use Spreadsheet Sync only with Advanced SKU clients.
• Accountant users are considered Company Admins within a client’s Advanced account.

For Excel

1. Open QuickBooks Online Advanced.
2. Go to Settings ⚙ and select Spreadsheet Sync.
3. Follow the steps to download and install the add-in.
4. Make sure you are using Office 365 Excel.
5. If your default browser is Internet Explorer 11, upgrade to Microsoft Edge before installing.
6. When prompted, select Trust this Add-In to complete the installation.

Other ways to install in Excel:

1. Follow this link to complete the steps in product
2. From the Create new report ▼ dropdown, select in spreadsheet.
3. Select Next, then follow the steps to download and install the add-in.

Or

1. Follow this link to complete the steps in product
2. Select Run report in Excel.
3. Select Next, then follow the steps to download and install the add-in.

For Google Sheets

1. Open Google Sheets.
2. Select Extensions from the menu.
3. Select Add-ons, then select Get add-ons.
4. In the search bar, type Spreadsheet Sync and select it.
5. Follow the prompts to install and complete the setup.

Sign in to Excel Sheet:

1. Open Excel Sheet.
2. Select Spreadsheet Sync from the menu.
3. Select Get started.
4. Enter your QuickBooks credentials and follow the steps to sign in.
5. If you have access to multiple companies, select the company you want to use.

Sign out of Excel Sheet:

1. Open Excel or Google Sheets.
2. Select Spreadsheet Sync from the menu.
3. Select the person icon, then select Sign out.

Sign in to Google Sheet:

1. Open Google Sheet.
2. From the Extensions tab, select Spreadsheet Sync, then select Launch add-in.
3. Select Get started.
4. Enter your QuickBooks credentials and follow the steps to sign in.
5. If you have access to multiple companies, select the company you want to use.

Sign out of Google Sheet:

1. Open Google Sheet.
2. From the Extensions tab, select Spreadsheet Sync, then select Launch add-in.
3. Select the person icon, then select Sign out.

1. Open Spreadsheet Sync in Excel or Google Sheets.
2. Select Run report.
3. Select the company from the Select company ▼ dropdown.
4. Select the Select report ▼ dropdown to select the report you're adding data from.
5. Select the filters based on the data you want to view. The filters vary depending on the type of report or data table.
6. Select Run report to get the data into the spreadsheet.
7. Use spreadsheet tools to build charts and graphs.

Report categories

• Business overview: Cash flows, stock valuation, budgets, and financial overviews.
• For my accountant: Year-end preparation and tax-focused reports.
• What you owe: Payables, supplier balances, and outstanding bills.
• Who owes you: Receivables, A/R Ageing Summary, and Open Invoices.
• Sales and customers: Sales by product or service, revenue trends, and customer details.
• Bank transactions: Payments, transfers, and reconciliations.
• Employee reports: Time Activities and payroll data.

Advanced templates explained

• Management Report: Includes Trial Balance, Balance Sheet, and Profit & Loss sheets for multi-period analysis.
• Smart Profit & Loss Report: Features formatted tables and slicers for detailed financial insights.

• Use filters to refine your data, including date ranges, class, or location.
• Apply multiple date range filters for comparative periods and trend analysis.
• Add or remove rows and columns for a customised layout.
  Note: Deleted rows can't be recovered.

1. In Spreadsheet Sync, select Create or edit records.
2. Select a company from the Select company ▼ dropdown.
3. Select a template from the Select a record type ▼ dropdown.

To add new data

1. Select Add new records to QuickBooks.
2. Select Get template to create a data entry sheet.

To edit existing data

1. Select Edit QuickBooks records and sync back.
2. Apply filters to download the records you want.
3. Select Get template to populate the sheet.
4. Make your changes and mark the Post? column as Yes.
5. Select Sync to QuickBooks, then select Sync to confirm.

Spreadsheet Sync allows you to batch update data like invoices or transactions efficiently.

1. In Spreadsheet Sync, select Create or edit records.
2. Select a company and a record type (for example, Invoices and Bills).
3. Select Edit QuickBooks records and sync back to download data.
4. Apply filters or select any mandatory field as required.
5. Select Get template to generate a sheet.
6. Add or edit information and mark rows as Yes under Post?.
7. Select Sync to QuickBooks, then select Sync to confirm.
8. Select View sync details to check updates and fix errors.

You can group companies together to create consolidated reports.

1. Select Spreadsheet Sync from the menu, then select Group.
2. Select + Create group.
3. Enter a name for the group in the Group name field.
4. Select a currency from the Currency ▼ dropdown for the group.
5. Add companies to the group.
   Note: You can include QuickBooks Online Simple Start, QuickBooks Online Essentials, or QuickBooks Online Plus companies.
6. Select Save.
7. From the Select report dropdown ▼, select a report and apply filters.
8. Select Run report to generate the consolidated data.