LedgerWire

Integration guide

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

How to sync Salesforce accounts, opportunities and orders into QuickBooks Desktop with a JSON API and the official Web Connector: object mapping, duplicate handling and a runnable sandbox.

Most Salesforce 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 Salesforce events (platform event or Flow callout).
  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

  • Account → Customer
  • Product2 → Item
  • Order / closed opportunity → Invoice or SalesOrderAdd (Premier+)
  • Payment status back to Salesforce from Invoice.balanceRemaining

Avoiding duplicates

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

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

Post a Salesforce 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": "SALE-1042",
    "memo": "Salesforce 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