LedgerWire

Integration guide

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

How to sync HubSpot companies, deals and quotes into QuickBooks Desktop with a JSON API and the official Web Connector: object mapping, duplicate handling and a runnable sandbox.

Most HubSpot 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 HubSpot events (deal stage change).
  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

  • Company → Customer
  • Product → ItemService
  • Closed-won deal → Invoice or EstimateAdd through /v1/qbxml
  • Invoice status back to HubSpot from Invoice.isPaid

Avoiding duplicates

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

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

Post a HubSpot 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": "HUBS-1042",
    "memo": "HubSpot 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