LedgerWire

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

  1. Your backend listens for Google Sheets events (Apps Script trigger).
  2. It calls LedgerWire with a lw_live_… key, e.g. POST /v1/sales-receipts.
  3. The Web Connector on your customer's PC picks the request up on its next poll (every minute by default) and QuickBooks writes it.
  4. You get the result in the HTTP response (if it lands within 25 seconds) or a job.completed webhook.

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.

Post a Google Sheets sale as a sales receipt
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 key

More integration guides