Install and open Spreadsheet Sync in QuickBooks Online Advanced or Accountant

This article explains how to open Spreadsheet Sync and sign in while working in QuickBooks Online Advanced or Accountant. It also explains how to sign out.

In this article, you'll learn:

• How to install Spreadsheet Sync
• How to sign in to Spreadsheet Sync
• How to sign in to Spreadsheet Sync if you are automatically signed out
• How to sign out of Spreadsheet Sync

Spreadsheet Sync only works with Excel Office 365. It won't work with older Excel versions.

If your computer's embedded browser is Internet Explorer 11, install this file to upgrade your browser to Microsoft Edge.

Spreadsheet Sync can be installed on both Mac and PC.

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.

How to install Spreadsheet Sync

Use one of the following methods to install Spreadsheet Sync from within QuickBooks:

• From the Reports tab:
  1. Select Reports (Take me there).
  2. Select the Create new report ▼ dropdown and select in spreadsheet.
  3. Select Next.
• From Settings ⚙:
  • Select Spreadsheet Sync.
• From the Spreadsheet Sync tab under Reports:
  1. Select Reports (Take me there), then select Spreadsheet Sync.
  2. Select Go to Spreadsheet Sync.
  3. Select Next.

To allow the Spreadsheet Sync add-in:

1. In the pop-up window, select Let’s Go.
2. In the next pop-up window, select Open Microsoft Excel app.
3. Once Spreadsheet Sync downloads, it'll prompt Office 365 to open. Select Trust this add-in.
4. Select Sign in. 
5. Enter your QuickBooks Online user ID and password.
6. Select Continue.

Sign in to Spreadsheet Sync

Opening Spreadsheet Sync from within Excel

1. Select Spreadsheet Sync in the Excel navigation bar.
2. Select Sign in.
3. Enter your QuickBooks Online user ID and password in the Spreadsheet Sync panel.
4. Select Continue.

Sign in again to Spreadsheet Sync if you are automatically signed out

If the Spreadsheet Sync toolbar in Excel is unavailable, it means you’re signed out of Spreadsheet Sync.

• Re-enter your sign-in credentials in the Spreadsheet Sync panel.
• You may need to close and reopen Spreadsheet Sync before signing back in. 

Sign out of Spreadsheet Sync

1. Select the Spreadsheet Sync tab.
2. Select Sign Out.