Skip to main content

How do I sync QuickBooks Online invoices and payment status back into HubSpot deals automatically?

Use QuickBooks Online webhooks for Invoice and Payment changes, fetch the invoice, find its deal by a stored ID, and write the status from the invoice’s remaining balance to HubSpot deal properties. Add a nightly reconcile for missed events. A custom build is typically $1,500–$6,000 and two to four weeks; Zapier works for simple cases.

How the reverse sync works

QuickBooks webhooks don’t send the invoice itself, only a short notice of which record changed and how. Your code has to fetch the rest.

  1. Subscribe to QuickBooks Online webhooks for the Invoice and Payment entities. Each notification lists the entity name, its ID, the operation (Create, Update, Delete, Void) and a timestamp.
  2. Verify the intuit-signature header, store the raw event, return success at once, and do the work from a queue.
  3. Fetch the current invoice from the QuickBooks API. For a Payment event, read its lines to find every invoice it was applied to and fetch each of those.
  4. Find the HubSpot deal that belongs to the invoice (see the next section).
  5. Work out the status from the invoice’s TotalAmt and Balance, then update deal properties such as invoice_status, amount_paid, balance_due and last_payment_date.
  6. Nightly, call the QuickBooks Change Data Capture endpoint to catch anything the webhooks missed.

Always recompute from the invoice’s current state, never by adding up payment events. Events can arrive twice or out of order, and payments can be deleted. Reading Balance fresh every time means processing an event twice does no harm.

Matching each invoice to the right deal

This is the step that decides whether the project is $1,500 or $6,000. There are three patterns, from most to least reliable.

The invoice was created from the deal

If your forward sync or your team creates invoices from HubSpot, save the QuickBooks invoice ID on the deal and the deal ID in an invoice custom field at the moment of creation. Matching then becomes an exact lookup and never guesses.

Invoices are made by hand in QuickBooks

Match on the QuickBooks customer, the deal’s company and the amount, automatically only when exactly one open deal fits. Anything else goes to a review list where someone picks the deal once, and the choice is saved.

One deal, several invoices

Deposits, milestone billing and subscriptions all produce several invoices per deal. Store the invoice IDs as a list or as associated custom objects, and roll the deal’s paid and due totals up across all of them.

Partial payments, voids and the states people forget

QuickBooks state How to detect it HubSpot status
Open, unpaid Balance equals TotalAmt, greater than 0 Invoiced
Partially paid Balance between 0 and TotalAmt Partially paid; amount paid = TotalAmt − Balance
Paid Balance is 0 and TotalAmt greater than 0 Paid
Voided Void operation, or TotalAmt dropped to 0 Voided; clear balance due
Deleted Delete operation; fetch returns nothing Unlinked; flag for review
Payment deleted Invoice Balance goes back up Back to Invoiced or Partially paid
Overdue Open balance and DueDate in the past Overdue (checked nightly)

A voided invoice has a balance of zero, so a sync that checks only Balance == 0 will mark voided invoices as paid. Check the total or the operation first. Credit memos also lower the balance without any payment, so if your team uses them, record "settled by credit" separately from "paid".

Worked example: HubSpot, QuickBooks Online and Stripe

A 40-person services firm marks a $12,000 deal closed-won in HubSpot. The forward sync creates QuickBooks invoice 1043 and writes its ID onto the deal. The client pays a $4,000 deposit by card through Stripe, and a payments app records it in QuickBooks against invoice 1043.

  • QuickBooks sends a Payment Create notification. The worker fetches the payment and sees it is applied to invoice 1043.
  • It fetches invoice 1043: TotalAmt 12,000, Balance 8,000. It looks up the deal by the stored ID.
  • HubSpot is updated to invoice_status = Partially paid, amount_paid = 4,000, balance_due = 8,000. A task goes to the account owner.
  • Three weeks later an $8,000 ACH payment arrives. Balance drops to 0 with a non-zero total, so the deal moves to Paid and a workflow starts onboarding.
  • QuickBooks sends the same notification twice. The second run reads the same balance, writes the same values, and nothing changes.

At 60 invoices a month and roughly 3 minutes each to check QuickBooks and update the deal by hand, that is about 3 hours a month back. The bigger gain is that sales stops chasing clients who have already paid.

Your options and what they cost

Option Upfront Monthly What breaks first
Zapier or Make recipe A few hours of setup Plan fees, scaling with task volume Partial payments, voids, and payments split across invoices
Marketplace connector Low Per-seat or subscription fee Status fields that don’t match your pipeline
Custom integration (Smplfy) $1,500–$6,000 Hosting, usually a few dollars Upstream field changes, handled by alerts and a runbook

These are Smplfy’s figures, at $85 an hour. A one-way status sync where invoices already carry the deal ID is about 20–30 hours. The top of the range covers matching invoices made by hand, multiple invoices per deal, a review list, and backfilling a year of history.

Our Stripe-to-Salesforce and Google Sheets finance sync has run for two years with minimal maintenance.

Failure modes to plan for

  • QuickBooks access tokens expire hourly and refresh tokens rotate. Store the newest one, or the sync silently stops.
  • HubSpot enforces API rate limits per 10-second window, so a backfill of thousands of invoices needs throttling.
  • A payment can arrive before the invoice is linked to a deal. Queue it and retry instead of dropping it.
  • Someone renames or deletes a HubSpot deal property. Alert on failed writes, not just on failed reads.

Which approach to choose

Use Zapier or Make if you send fewer than about 30 invoices a month, every deal has exactly one invoice, and partial payments are rare. Use a custom integration if you take deposits or milestone payments, invoices get made by hand in QuickBooks, or a wrong "paid" flag sets off onboarding or commissions.

Don’t build anything yet if your team can’t say which HubSpot property is the source of truth for payment status, or if half your deals have no matching QuickBooks customer. Clean that up first.

Frequently asked questions

Does QuickBooks Online have webhooks for invoice payments?
Yes. QuickBooks Online webhooks report create, update, delete and void events for invoices and payments. The notification includes only the entity type, ID and operation, so your code must call the API to fetch the current record. Pair the webhooks with a nightly Change Data Capture check to catch anything missed.

How do I handle partial payments when syncing QuickBooks to HubSpot?
Read the invoice’s TotalAmt and Balance every time it changes, and set amount paid to the total minus the balance. Do not add up payment events, because they can repeat, arrive out of order or be deleted. Status is Partially paid whenever the balance is above zero and below the total.

Why does my sync mark voided QuickBooks invoices as paid?
When QuickBooks voids an invoice, it sets the amounts to zero, so the balance reads zero just as it does on a paid invoice. Check for the Void operation or a zero total before checking the balance. Voided invoices should clear the balance due on the deal and get their own status.

Can Zapier sync QuickBooks payment status to HubSpot deals?
Yes, for simple cases: one invoice per deal, full payments, and a deal ID you can find from the invoice. Logic for voids, split payments and retries quickly becomes hard to maintain. Past about 30 invoices a month with deposits, a coded integration is usually cheaper to run.

How much does a custom QuickBooks to HubSpot payment sync cost?
At Smplfy, a typical build is $1,500–$6,000 at $85 an hour and takes two to four weeks. The low end assumes invoices already carry the HubSpot deal ID. The high end adds matching for invoices created by hand, multiple invoices per deal, a review list and a historical backfill.

Related answers

Want a scoped estimate for your QuickBooks and HubSpot sync?

We’ll send a free written scope or join a 20-minute call. Have ready: how invoices get created today, roughly how many you send a month, and which deal fields your team updates by hand. Start a conversation.