SheetsSync Help Center: how can we help?

Fixes for QuickBooks connection and sync problems, answers about plans and two-way sync, and a direct line to support.

Common Issues & Fixes

Most problems can be resolved with these quick steps.

Authentication

"QuickBooks disconnected" error

Your QuickBooks connection token has expired or was revoked.

Fix: Open the SheetsSync sidebar in Google Sheets, click "Disconnect", then reconnect your QuickBooks account. This refreshes your authentication tokens.
Sync

Sync is not pulling new data

Scheduled sync may be paused or the sheet configuration may be stale.

Fix: Run a manual sync first. If data appears, re-enable auto-sync from the sidebar settings. Also check that the correct entity type is selected for your sheet.
Sync

Missing columns or fields

Some QuickBooks fields may not appear in your sheet after sync.

Fix: SheetsSync writes the columns that QuickBooks returns. Custom fields may require QuickBooks Plus or Advanced. Try a fresh sync to a new sheet to see all available columns.
Authentication

"Authorization failed" on connect

The OAuth flow didn't complete successfully.

Fix: Make sure pop-ups are allowed for the add-on. Try using Chrome in a normal (non-incognito) window. If the issue persists, clear your browser cache and try again.
Billing

Pro features not activating

You subscribed but Pro features aren't available yet.

Fix: Close and reopen the SheetsSync sidebar. If features still don't appear, sign out and sign back in. Your subscription status may take a minute to propagate.
General

Add-on not loading in sidebar

The SheetsSync sidebar shows a blank panel or spinner.

Fix: Refresh the Google Sheets page. If still blank, go to Extensions > Manage Add-ons and make sure SheetsSync is enabled for this document.
Plan limits

"Free plan allows..." message when saving a sheet

The Free plan allows up to 3 configured sheets and 1 QuickBooks data type.

Fix: Reuse a sheet that already syncs your chosen data type, remove a sheet configuration you no longer need, or start the 14-day Pro trial (no card needed) for unlimited sheets and all data types. See pricing.
Sync

Some records are missing from the sheet

The sheet only shows records that match its date range and filters.

Fix: Open Configure This Sheet and widen the date range or remove filters, then sync again. For invoices, the invoice sync guide explains which date field the range uses.

Frequently Asked Questions

Quick answers to common questions.

Open any Google Sheet, go to Extensions > Add-ons > Get add-ons, and search for "SheetsSync". Click Install, approve the Google permissions, then open Extensions > SheetsSync > Open SheetsSync and click Connect QuickBooks. The setup guide shows each step.
SheetsSync works with QuickBooks Online Simple Start, Essentials, Plus and Advanced. QuickBooks Desktop is not supported.
Nine QuickBooks data types: Invoices, Customers, Vendors, Items, Payments, Bills, Purchases, Accounts and Journal Entries, plus three reports: Profit & Loss, Balance Sheet and Transaction List. Each sheet tab syncs one of them with the fields you pick. Free covers any one of them; Pro covers all of them. For invoices, see how to sync QuickBooks invoices to Google Sheets.
Scheduled syncs run from a Google timer that checks once an hour, so a sync can land some minutes before or after the hour you expect. Hourly is the fastest schedule available. Webhook sync also waits for the next hourly check. If you need fresh numbers right now, run a manual sync.
With Pro, you can edit rows in Google Sheets and push the changes back to QuickBooks, or add rows to create new records. It supports Customers, Vendors, Invoices, Bills and Items. A status column shows each row as Synced, Pending, New or Error. You can push one sheet, all sheets, or selected rows from the Push to QuickBooks menu.
Open Extensions > SheetsSync > Manage Subscription to cancel in the billing portal. Pro stays active until the end of the period you paid for, and no sheets or settings are deleted. You can also email support@getsheetssync.com and we will handle it for you.
You connect on Intuit's OAuth 2.0 screen, so SheetsSync never sees your QuickBooks password, and data is encrypted in transit. The synced data lives in your Google Sheet. The SheetsSync backend keeps what it needs to run the sync: connection tokens, sheet settings, sync logs and the rows you push back with two-way sync. See the privacy policy and Security & Compliance page.
Disconnect QuickBooks from the add-on sidebar, which deletes your stored QuickBooks tokens and connection. For full account deletion, email support@getsheetssync.com. The opt-out and data deletion page has step-by-step instructions.

Guides and comparisons

Longer walkthroughs for common QuickBooks and Google Sheets jobs.

Still need help?

Send us a message and we'll get back to you as soon as possible.

Get in touch

Whether it's a bug, a question, or feedback — we'd love to hear from you.

Typical response time: Under 24 hours on business days

We'll respond to your email address. No account required.