Spreadsheet Sync: plan limits, browser fixes, and batch invoice edits

Spreadsheet Sync, the QuickBooks tool that links company data to Microsoft Excel and Google Sheets, carries a short list of hard requirements. Most of the troubleshooting we see ends on that list rather than on a defect. The accepted guidance on the feature covers the same ground: plan eligibility, software compatibility, and a defined sequence for batch edits. None of the three checks is obvious from inside the product.

Which plans can use Spreadsheet Sync?

Two, and only two. QuickBooks Online Advanced includes the tool, and QuickBooks Online Accountant includes it for practitioners who work across client companies. If you are on Simple Start, Essentials, or Plus, the feature is absent by design. Nothing in settings will reveal it. The vendor’s answer for users on those tiers is a subscription upgrade. The symptom is a missing toolbar option rather than an error message, which is why the gap often reads as a fault.

There is no separate purchase once you arrive. Spreadsheet Sync is part of the Advanced and Accountant subscriptions, not an add-on with its own price.

The software rules that decide whether it connects

The tool works with Office 365 Excel and with Google Sheets. Older, standalone releases of Excel are not supported, so a workstation holding a dated copy will not cooperate. The practical check is straightforward: use Excel from a current Microsoft 365 installation, or move the work to Google Sheets. Sheets sidesteps the version question entirely, since the connection runs in the browser.

Setup also assumes an administrator login. You sign in as an admin of the QuickBooks Online Advanced company, then install and open the tool from there. A standard user profile will not carry the permission the installation needs.

Does Internet Explorer 11 still block it?

On some older machines, yes. If the computer’s default browser is Internet Explorer 11, the guidance calls for a specific update file that upgrades the default browser to Microsoft Edge. Machines already defaulting to something modern skip this step entirely. After the upgrade, the tool opens through Edge without further configuration. The trap mostly catches workstations that were never moved off the legacy browser.

Can invoices be edited in bulk through it?

Yes. The posting function exists for exactly that: edit multiple transactions in one sheet, then post the changes back in a single pass. The workflow begins at the toolbar with a sign-in each session. The accepted sequence for invoices and bills runs as follows:

1. Open Spreadsheet Sync from the toolbar and sign in.
2. Select Create or edit records.
3. Choose your company from the company dropdown.
4. Select the Invoices and Bills template.
5. Choose the option to edit QuickBooks records and sync back.
6. Filter the download to the transactions you actually need.
7. Optionally include custom field columns where your forms use them.

The template covers invoices and bills together, so the same route handles supplier bills as well as customer invoices.

The filter step is part of the sequence, not an optional extra. It decides which transactions land in the sheet, and a tight filter keeps the working document manageable.

What else can the same connection do?

Three further capabilities sit behind the invoice workflow. It pulls live QuickBooks data into a spreadsheet, accepts your edits, and posts the results back. It can create new records and transactions from templates, rather than one entry at a time. And it feeds custom reports and pivot tables, which you refresh with current QuickBooks data instead of rebuilding. For teams that report out of a spreadsheet each month, that refresh step replaces a manual export.

The short version

Run the checks in order. Plan first: Advanced or Accountant, otherwise the tool is simply not available. Software second: Office 365 Excel or Google Sheets, with Edge as the default browser on any legacy machine. Permissions third: an admin login for setup. Once those clear, the batch sequence above resolves the bulk invoice questions that bring users to this feature.