Why connect QuickBooks to Google Sheets?
QuickBooks Online is good at bookkeeping, but its reports are fixed. As soon as you want a custom AR aging view, a cash dashboard for a client, or a pivot table across a year of invoices, you end up exporting a file, cleaning it up and pasting it into a spreadsheet. Then you do it again next week.
A QuickBooks Google Sheets integration replaces that loop. The data arrives in a normal sheet tab, so you can use formulas, charts, pivot tables and sharing exactly as you would with any other sheet, and it can be refreshed without starting over.
- Custom reports: build the views QuickBooks does not offer, with your own formulas and formatting.
- Sharing: give a partner, manager or client a sheet instead of a QuickBooks login.
- Analysis: use QUERY, pivot tables and charts across thousands of rows.
- Dashboards: point a QuickBooks dashboard in Google Sheets at synced tabs so it updates with each sync.
Ways to connect QuickBooks and Google Sheets
There are three common approaches. Which one fits depends on how often the data changes and how much setup you want to maintain.
- Manual export and import. Export a report from QuickBooks to Excel or CSV, then import it into Sheets. Free and simple, but every refresh is manual and formulas break when columns move. Our guide to exporting QuickBooks to Google Sheets covers this method.
- Automation platforms. Tools such as Zapier can add a row to a sheet when a new record appears in QuickBooks. Good for event-style workflows, less suited to keeping a full table current. See SheetsSync vs Zapier.
- A Google Sheets add-on. An add-on runs inside Sheets and pulls whole QuickBooks tables or reports on demand or on a schedule. SheetsSync is one of these; others include Coupler.io, Coefficient, G-Accon and LiveFlow, and Intuit offers its own Spreadsheet Sync on some plans.
The rest of this guide uses SheetsSync, a Google Sheets add-on built only for QuickBooks Online.
What QuickBooks data syncs to Google Sheets
SheetsSync syncs 9 QuickBooks Online data types and 3 reports. Each sheet tab is tied to one of them, with its own column choice, date range, filters and sort order (reports also offer grouping).
Invoices
Invoice number, date, customer, total, balance, due date, terms, paid or unpaid, email status and memo. Ideal for AR tracking and aging.
Customers
Display name, company, contact details, billing address, balance and active status.
Vendors
Vendor names, contact details, address, balance and the 1099 flag.
Items
Products and services with SKU, type, unit price and quantity on hand.
Payments
Customer payments received, with amounts and dates.
Bills
Vendor bills with bill number, date, vendor, total, balance, due date and AP account.
Purchases
Expenses, checks and card charges with payee, payment type, account and amount.
Accounts
Your chart of accounts with type, sub-type, number, classification and current balance.
Journal Entries
Journal number, date, total, memo and whether it is an adjusting entry.
The three reports are Profit & Loss, Balance Sheet and Transaction List. On Free you can sync any one data type or report of your choice; Pro unlocks all of them. Webhook sync and two-way sync do not apply to reports.
How to connect QuickBooks to Google Sheets, step by step
You need a QuickBooks Online company (any plan), a Google account with Google Sheets, and permission to approve app connections in QuickBooks.
- Install the add-on. In any Google Sheet, open Extensions > Add-ons > Get add-ons, search for "SheetsSync" and install it, or install from the Google Workspace Marketplace listing.
- Open the sidebar. Go to Extensions > SheetsSync > Open SheetsSync. The panel opens on the right.
- Connect QuickBooks. Click Connect QuickBooks. Intuit's own sign-in screen opens; sign in and approve access to your company.
- Configure the sheet. Choose Configure This Sheet, pick a data type or report (for example Invoices), tick the fields you want as columns, set a date range, and add filters or a sort order if you need them.
- Sync. Click the sync icon in the sidebar, or choose Extensions > SheetsSync > Sync This Sheet. SheetsSync writes a header row and your records into the tab. Repeat on other tabs for other data types.
- Automate (Pro). In the same settings, turn on a sync schedule, webhook sync or two-way sync.
Tip: Keep your formulas and charts on separate tabs that reference the synced tabs. Each sync rewrites the synced tab, so anything typed into it by hand will be replaced unless two-way sync is on for that sheet.
Keeping the sheet up to date
↻ Manual sync (Free and Pro)
Click Sync whenever you want fresh numbers. The tab is rewritten with the current QuickBooks data for your settings.
⏰ Scheduled auto-sync (Pro)
Hourly, every 6 hours, daily at a chosen hour, or weekly on a chosen day. Hourly is the fastest option because Google runs add-on timers at most once an hour.
🔔 Webhook sync (Pro)
QuickBooks notifies SheetsSync when a record of that type changes. The sheet is marked as changed and refreshed on the next hourly check, so it updates when something actually changed.
☰ Sync history
The sidebar keeps a log of recent syncs: the last 5 on Free and the last 20 on Pro, so you can see when a tab was last refreshed and whether it worked.
Sending changes back to QuickBooks
With Pro, two-way sync lets you edit a synced row, or add a new one, and push it to QuickBooks. It works for customers, vendors, invoices, bills and items. A status column shows each row as Synced, Pending, New or Error. Calculated fields such as totals and balances are never sent back, because QuickBooks computes them.
Bulk push sends many rows in one go, which helps with migrations or month-end data entry. Payments, purchases, accounts, journal entries and reports are pull-only. The Free plan can read data but cannot write to QuickBooks.
Free vs Pro pricing
| Feature | Free | Pro |
|---|---|---|
| Price (USD) | $0 | $19.99/month or $159.99/year |
| QuickBooks data types | 1 of your choice | All 9, plus 3 reports |
| Configured sheets | Up to 3 | Unlimited |
| Manual sync | ✓ | ✓ |
| Fields, date ranges, filters, sorting | ✓ | ✓ |
| Scheduled auto-sync (hourly to weekly) | ✕ | ✓ |
| Webhook sync | ✕ | ✓ |
| Two-way sync and bulk push | ✕ | ✓ |
| Sync history | Last 5 | Last 20 |
Pro starts with a 14-day free trial that does not ask for a card. If you do not subscribe, the account returns to Free and your sheet settings stay in place. See the pricing section on the home page.
Security and data handling
- Intuit OAuth 2.0: you sign in on Intuit's screen, so SheetsSync never sees your QuickBooks password.
- Encrypted in transit: traffic between QuickBooks, the SheetsSync backend and Google Sheets uses HTTPS.
- What is kept: your synced data lives in your Google Sheet. The 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.
- Disconnect any time: disconnecting in the sidebar deletes the stored QuickBooks tokens. You can also revoke access in your Intuit account.
Details are in the privacy policy and on the security and compliance page. If something does not connect, the help center has troubleshooting steps.
Other QuickBooks to Google Sheets tools
Different tools suit different teams. Multi-source connectors make sense if QuickBooks is one of many data sources; dedicated add-ons suit teams that live in QuickBooks. Each comparison below lists where the other tool is the better fit.
Coupler.io
A data import tool with many sources, QuickBooks among them, aimed at scheduled imports into sheets and BI tools.
SheetsSync vs Coupler.io →Coefficient
A Google Sheets connector for many business systems, including QuickBooks, CRMs and databases.
SheetsSync vs Coefficient →LiveFlow
A financial reporting and consolidation product built on spreadsheets, aimed at finance teams.
SheetsSync vs LiveFlow →G-Accon
An accounting add-on for Google Sheets with QuickBooks and Xero connectors and reporting templates.
SheetsSync vs G-Accon →