LedgerWire

Integration guide

Sync Airtable with QuickBooks Desktop (Pro, Premier and Enterprise)

How to sync Airtable records from a base into QuickBooks Desktop with a JSON API and the official Web Connector: object mapping, duplicate handling and a runnable sandbox.

Most Airtable 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 Airtable events (automation script or schedule).
  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 in a Customers table → Customer
  • Row in an Invoices table → Invoice (store the TxnID back in the row)
  • Status column from Invoice.isPaid on a schedule

Avoiding duplicates

Store the QuickBooks TxnID or ListID that LedgerWire returns next to the Airtable record, and put the Airtable 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 Airtable sync without Windows or a QuickBooks license.

LedgerWire is not affiliated with Airtable or Intuit. Product names are used only to describe compatibility.

Post a Airtable 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": "AIRT-1042",
    "memo": "Airtable 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