SheetsSync for QuickBooks connects QuickBooks Online to Google Sheets™. Pull invoices, customers, bills, payments and financial reports into a sheet, choose the columns you want, and keep the sheet up to date without exporting CSV files.

WHAT YOU CAN SYNC
• 9 QuickBooks Online data types: Invoices, Customers, Vendors, Items, Payments, Bills, Purchases (expenses, checks and card charges), Accounts (chart of accounts) and Journal Entries.
• 3 reports: Profit & Loss, Balance Sheet and Transaction List.
• Each sheet tab holds one data type or report, with the fields, date range, filters and sort order you choose.

HOW YOUR SHEET STAYS CURRENT
• Manual sync: click Sync in the sidebar whenever you want fresh numbers (Free and Pro).
• Scheduled sync (Pro): hourly, every 6 hours, daily or weekly. Hourly is the fastest schedule, because Google lets add-ons run timed jobs at most once an hour.
• Webhook sync (Pro): when QuickBooks reports that a record changed, SheetsSync refreshes the affected sheet at the next hourly check, and leaves quiet sheets alone.

TWO-WAY SYNC (Pro)
• Edit customers, vendors, invoices, bills and items in the sheet and send the changes back to QuickBooks.
• Add a new row to create a new customer, vendor, invoice, bill or item.
• Push one row or a whole sheet at once (bulk push).

GOOD FOR
• A live AR aging or unpaid-invoices sheet your team can read without a QuickBooks seat.
• A custom P&L or Balance Sheet layout that refreshes itself.
• Bookkeepers who clean up customer or vendor lists faster in a spreadsheet than in QuickBooks.

PLANS
Free: 1 data type or report of your choice, up to 3 configured sheets, manual sync.
Pro: all 9 data types and 3 reports, unlimited sheets, scheduled sync, webhook sync, two-way sync and bulk push. $19.99/month, or $159.99/year (save 33%).
Pro starts with a 14-day free trial and does not ask for a card. If you don't add a card by the end of the trial, your account goes back to Free, nothing is charged, and your sheets and settings stay in place.

Works with QuickBooks Online Simple Start, Essentials, Plus and Advanced. QuickBooks Desktop is not supported.

SECURITY AND DATA
• Sign-in uses QuickBooks' official OAuth 2.0 connection. SheetsSync never sees your QuickBooks password.
• Records and reports pulled from QuickBooks pass through our servers in memory and are written to your sheet; they are not saved on our servers.
• We do keep what the service needs to run: your account and plan, the encrypted QuickBooks connection, your sheet settings, and time-limited sync and push logs. The full list and retention periods are at getsheetssync.com/compliance.
• The add-on can only open the spreadsheet you use it in.

GET STARTED
1. Install, then open Extensions > SheetsSync for QuickBooks > Open SheetsSync.
2. Click Connect to QuickBooks and approve access.
3. Pick a data type, choose your fields and click Sync.

Help: getsheetssync.com/support or support@getsheetssync.com

Google Sheets™ is a trademark of Google LLC. QuickBooks® is a registered trademark of Intuit Inc. SheetsSync is not affiliated with or endorsed by Google or Intuit.