Integration guide
Sync Google Sheets with QuickBooks Desktop (Pro, Premier and Enterprise)
How to sync Google Sheets rows in a spreadsheet into QuickBooks Desktop with a JSON API and the official Web Connector: object mapping, duplicate handling and a runnable sandbox.
Most Google Sheets accounting connectors only support QuickBooks Online. If your customers run QuickBooks Desktop (Pro, Premier or Enterprise), the only supported remote path is the QuickBooks Web Connector, which polls a SOAP server you host. LedgerWire is that server, with a REST API on top.
How the sync is wired
- Your backend listens for Google Sheets events (Apps Script trigger).
- It calls LedgerWire with a
lw_live_…key, e.g.POST /v1/sales-receipts. - The Web Connector on your customer's PC picks the request up on its next poll (every minute by default) and QuickBooks writes it.
- You get the result in the HTTP response (if it lands within 25 seconds) or a
job.completedwebhook.
Object mapping
- Row → Invoice or Bill (store the TxnID in a column to avoid duplicates)
- Customer sheet → Customer
- Pull open invoices into a sheet for collections
Avoiding duplicates
Store the QuickBooks TxnID or ListID that LedgerWire returns next to the Google Sheets record, and put the Google Sheets id in RefNumber or Memo. Before creating, query by RefNumber (GET /v1/invoices?refNumber=…).
Names must match exactly
QuickBooks resolves refs by FullName or ListID. Look customers and items up once, cache their ids, and create missing ones first. A missing ref returns qbStatusCode 3140 with the field that failed.
Try it before you have a customer
The free sandbox is a seeded QuickBooks Desktop company that answers the same calls, so you can build and test the whole Google Sheets sync without Windows or a QuickBooks license.
LedgerWire is not affiliated with Google Sheets or Intuit. Product names are used only to describe compatibility.
curl https://ledgerwire.vibiz.app/v1/sales-receipts \
-H "Authorization: Bearer $LEDGERWIRE_KEY" \
-H "Content-Type: application/json" \
-d '{
"customerRef": { "fullName": "Bayside Builders LLC" },
"refNumber": "GOOG-1042",
"memo": "Google Sheets order 1042",
"lines": [{ "itemRef": { "fullName": "Air Filter 16x25" }, "quantity": 4, "rate": 14.5 }]
}'Run these calls against a hosted QuickBooks Desktop sandbox now.
Get a free sandbox keyMore integration guides
- Sync Shopify with QuickBooks Desktop (Pro, Premier and Enterprise)
- Sync Stripe with QuickBooks Desktop (Pro, Premier and Enterprise)
- Sync Jobber with QuickBooks Desktop (Pro, Premier and Enterprise)
- Sync ServiceTitan with QuickBooks Desktop (Pro, Premier and Enterprise)
- Sync HubSpot with QuickBooks Desktop (Pro, Premier and Enterprise)
- Sync Salesforce with QuickBooks Desktop (Pro, Premier and Enterprise)
- Sync WooCommerce with QuickBooks Desktop (Pro, Premier and Enterprise)
- Sync Square with QuickBooks Desktop (Pro, Premier and Enterprise)
- Sync Airtable with QuickBooks Desktop (Pro, Premier and Enterprise)