Quickbooky

Accounting News

Apps & Integrations

Spreadsheet Sync availability hinges on your QuickBooks plan and Excel version

Spreadsheet Sync works only with QuickBooks Online Advanced and Accountant, and it needs a current Microsoft 365 Excel install or Google Sheets.

COMMUNITY ISSUESQUICKBOOKY

A familiar report lands in QuickBooks community threads: an Excel-heavy user goes looking for Spreadsheet Sync, finds nothing in the app menu, and assumes the feature is broken. The accepted guidance says otherwise. The tool is real, it works, and it is fenced off by subscription plan and by spreadsheet version. Two gates explain almost every dead end.

What does Spreadsheet Sync do?

Spreadsheet Sync is the vendor’s bridge between a spreadsheet and the online ledger. It ships for two audiences: companies on QuickBooks Online Advanced and firms on the Accountant edition. Three jobs define it. You can pull data into Excel, edit it there, and post the results back to the books. You can build new records from the tool’s templates and push them in bulk. You can also assemble custom reports or pivot tables and refresh them against current book data.

The older alternative is the manual round trip: export, fix, import, and reconcile the differences. That routine still exists and still works. It just does not carry edits back and forth, and every saved copy starts going stale the moment you make it. This tool is aimed squarely at that gap.

Why can’t you find Spreadsheet Sync in your account?

Because the plan says so. The add-in is reserved for Advanced and for the Accountant edition. If your subscription is Simple Start, Essentials, or Plus, the feature is not hidden, misconfigured, or waiting on an update. It simply is not part of those plans.

The remedy, per the accepted answer, is a subscription upgrade. You move up from inside the product, in the plan and billing settings, and the feature becomes available to admin users after the change takes effect. Firms doing client work reach the same tool through the Accountant edition rather than through any client’s plan.

Excel versions that work, and one legacy browser trap

Plan aside, the second common blocker is the spreadsheet program itself. The supported options are the Microsoft 365 version of Excel and Google Sheets. Older Excel releases, the perpetual-license installs from earlier years, will not run the add-in at all. The reason is plumbing rather than policy. The tool leans on the sign-in and add-in framework that ships with the current Office experience, and legacy installs never received that framework.

There is a browser footnote as well. Machines still defaulting to Internet Explorer 11 are directed to Microsoft Edge before installing. The old browser mishandles the account handoff during setup. That configuration is rare today, but the resulting failure looks like an install error and sends people down the wrong troubleshooting path.

Installation starts with an admin sign-in

Even on the right plan with the right Excel, setup can stall at permissions. The sequence begins by signing in as the administrator of the Advanced company. Standard users do not clear that first step. Once the admin requirement is satisfied, the rest is a guided install inside the spreadsheet application, and the connection is made from there.

Does Spreadsheet Sync cost extra?

No. The tool is bundled with the Advanced and Accountant subscriptions, so there is no separate fee to switch it on. The only money question arises on lower plans, where the real cost is the upgrade itself. Plan pricing shifts often enough that we leave figures out of this report.

Support questions have one route

The accepted answer closes with a pointer rather than a fix, because most of these cases need no fix. Questions about the tool itself are handled by the vendor’s customer success team, reached through the Help option inside the product. Account and billing questions for Advanced go through the same entry point. That is the vendor’s channel, and it is where such questions are answered.

A short checklist before you troubleshoot further

  • Confirm the subscription is Advanced, or that you are working in the Accountant edition.
  • Confirm Excel is the Microsoft 365 install, or move the work to Google Sheets.
  • Replace Internet Explorer 11 as the default browser with Microsoft Edge.
  • Sign in as the company administrator before installing.
  • Expect no separate fee; the only cost on a lower plan is the upgrade.

The pattern behind this guidance is consistent. The add-in is not broken, it is gated, and the gates are visible once you know to look. Check the plan, check the spreadsheet version, and check who is signing in. In that order, one of the three usually explains the empty app menu, and the fix follows from whichever gate you find.

← Back to Community Issues