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.