How to Auto-Create QuickBooks Online Invoices from HubSpot Deals Using Make

To scale your revenue operations effectively, you must automate QuickBooks Online to eliminate manual data entry between your CRM and payment gateways. When an account executive moves an opportunity to Closed Won in HubSpot, finance teams are frequently forced into manual data entry: copy-pasting customer tax details, billing contacts, and custom line items into QuickBooks Online.

Beyond being an administrative drain, manual invoice generation introduces discrepancies in tax rates, currency codes, and revenue reporting. Off-the-shelf connectors often lack support for multi-line products or custom discount logic.

This technical runbook demonstrates how to build an automated, bi-directional integration using Make (formerly Integromat). The scenario listens for closed deals in HubSpot, validates whether the customer already exists in QuickBooks Online, generates a structured invoice, and writes the resulting QuickBooks Invoice ID back into HubSpot.

Architectural Overview

Here is the automated execution pipeline:

Make scenario routing HubSpot Closed-Won deals to QuickBooks Online invoice creation
Figure 1: Complete Make.com workflow routing HubSpot Closed-Won deals into QuickBooks Online.
  1. Trigger: HubSpot detects a deal entering the Closed Won pipeline stage via webhook.
  2. Customer Lookup: Make queries QuickBooks Online by company domain or customer email.
  3. Conditional Branching (Router):
    • Path A: Customer exists → retrieve the QuickBooks CustomerId.
    • Path B: Customer does not exist → create a new QuickBooks Customer record using HubSpot billing metadata.
  4. Line Item Mapping: Deal line items are iterated and formatted into standard QuickBooks line-item payloads.
  5. Invoice Generation: QuickBooks generates the draft or open invoice.
  6. Sync Back: Make updates the HubSpot deal record with the QuickBooks DocNumber and public invoice URL for immediate rep visibility.

Prerequisites

  • HubSpot: Super Admin access with a configured Sales Pipeline containing a Closed Won stage.
  • QuickBooks Online: Accountant or Administrator permissions with access to your Chart of Accounts.
  • Make.com: A Core or Pro plan (the Router and multi-step modules require standard execution features).
  • Custom Field in HubSpot: Create a single-line text field on the Deal object called QBO Invoice Number to prevent duplicate triggering.

Step 1: Watch Closed-Won Deals in HubSpot

We trigger the scenario based on stage movement rather than generic updates to minimize operation usage.

  1. Create a new scenario in Make and add the HubSpot CRM module.
  2. Select Watch CRM Objects (or Watch Deals).
  3. Configure the object settings:
    • Object Type: Deal
    • Trigger By: Stage Updated
    • Pipeline: Your primary sales pipeline
    • Deal Stage: Closed Won
  4. Under Output Properties, ensure you include: dealname, amount, closedate, associatedCompanyIds, and qbo_invoice_number.

Step 2: Check for Existing QuickBooks Customer

To avoid creating redundant customer accounts in your accounting ledger, we run a query matching the customer’s identity.

  1. Add a QuickBooks Online > Search Customers module.
  2. Configure the search filter using a SQL-like condition:
    DisplayName = '{{1.properties.dealname}}' OR PrimaryEmailAddr = '{{1.properties.billing_email}}'
  3. Set the Limit to 1.

Step 3: Route Between Existing and New Accounts

Add a Router module to branch the execution based on search output:

  • Branch 1 (New Customer Creation):
    • Filter: Set a filter where Search Customers: TotalCount Equal to 0.
    • Action: Add QuickBooks Online > Create a Customer. Map the company name, primary contact name, billing street address, and tax residency from the associated HubSpot company record.
  • Branch 2 (Existing Customer Fallback):
    • Filter: Set a filter where Search Customers: TotalCount Greater than 0.
    • Pass the returned Id forward to the invoice generator.

Step 4: Create the QuickBooks Online Invoice

Add the QuickBooks Online > Create an Invoice module at the convergence of your branches:

  1. Customer: Map the dynamic customer ID: ifempty(3.Id; 2.Id) (reads the newly created ID if Path A ran, or the searched ID if Path B ran).
  2. TxnDate: Map formatDate(1.properties.closedate; YYYY-MM-DD).
  3. Due Date: Map your organization’s standard payment terms (e.g., Net 30: addDays(1.properties.closedate; 30)).
  4. Line Items: Under Lines, configure the charge item:
    • Description: Contract fulfillment: {{1.properties.dealname}}
    • Amount: Map the total deal value from HubSpot (1.properties.amount).
    • Account: Select your designated Sales / Operating Revenue account from the dropdown.

Step 5: Write Back the Invoice ID to HubSpot

Closing the loop provides your sales team immediate visibility without needing accounting software seats:

  1. Add a HubSpot CRM > Update an Object module.
  2. Object Type: Deal.
  3. Object ID: Map {{1.id}}.
  4. Fields to Update:
    • QBO Invoice Number: Map {{4.DocNumber}} (the generated invoice number from QuickBooks).

Handling Common Edge Cases

1. Loop Prevention and Idempotency

When HubSpot updates a deal property (such as saving the Invoice Number in Step 5), it triggers a property change event. If your trigger is configured loosely, this can create an infinite execution loop.

Always add an initial filter immediately after the HubSpot trigger: Proceed only if QBO Invoice Number Does Not Exist. If an invoice number is already populated, the scenario halts immediately, preventing duplicate invoices.

2. Multi-Line Item Deals

If your sales team adds discrete SKUs or recurring service tiers in HubSpot, using a single aggregate deal amount will flatten the invoice. In that scenario, add a HubSpot > Get Deal Line Items module followed by an Array Aggregator to map discrete product rows into the QuickBooks Line payload.

Scenario 2: Auto-Syncing Stripe Payout Transactions to QuickBooks Online

Architectural Overview to Automate QuickBooks Online

Here is the data pipeline we will build:

  1. Trigger: Stripe fires a payout.paid webhook event whenever funds are sent to your bank.
  2. Data Fetching: Make queries the Stripe Balance Transactions API to extract every line item tied to that specific payout ID.
  3. Array Aggregation: Transactions are grouped into two clean buckets: Gross Sales and Processing Fees.
  4. Action: Make creates a matched Bank Deposit in QuickBooks Online, assigning gross receipts to Undeposited Funds and net merchant fees to an expense account called Stripe Processing Fees.
automate quickbooks online workflow in make

Prerequisites and Account Setup

Before configuring modules, ensure the following ledger accounts exist in QuickBooks Online:

  • Stripe Clearing Account: A dummy Bank Account type in your Chart of Accounts.
  • Stripe Processing Fees: An Expense account (Category: Bank & Merchant Fees).
  • Operating Checking Account: Your primary bank account receiving Stripe deposits.

Step 1: Create the Stripe Webhook Trigger in Make

We use an instant webhook to prevent polling delays and unnecessary operation consumption.

  1. Log in to your Make workspace and click Create a new scenario.
  2. Add the Stripe module and select Watch Events (Instant).
  3. Click Add next to the Webhook field and connect your Stripe account using API Restricted Keys (ensure read access to Payouts and Balance Transactions is granted).
  4. Under Event Types, scroll down and select: payout.paid.
  5. Save the trigger module.

Step 2: Retrieve Balance Transactions for the Payout

The initial payout.paid payload contains the total amount transferred, but it does not list the granular customer transactions or Stripe fee deductions. We must pull the balance transactions list using the payout identifier.

  1. Add a second module: Stripe > Make an API Call.
  2. Set the URL to: /v1/balance_transactions?payout={{1.data.object.id}}&limit=100
  3. Set the Method to GET.
  4. Click Run this module only with a recent payout ID to inspect the returned JSON structure.

The response returns an array of transaction objects containing gross amounts, fee amounts, and transaction types:

{
  "object": "list",
  "data": [
    {
      "id": "txn_1032x92eAA6e1008",
      "amount": 10000,
      "fee": 320,
      "net": 9680,
      "currency": "usd",
      "type": "charge"
    }
  ]
}

Step 3: Aggregate Fees and Gross Sales

To build a clean deposit in QuickBooks, we must separate the aggregate customer receipts from the operational fees.

  1. Add an Iterator module immediately following the Stripe API call module.
  2. Map the array data[] from the API response into the Iterator.
  3. Add a Numeric Aggregator module:
    • Source Module: Iterator
    • Aggregate Function: SUM
    • Value: Iterator.fee divided by 100 (Stripe returns currency in cents).
  4. Add a second Numeric Aggregator module to calculate the gross transaction amount:
    • Aggregate Function: SUM
    • Value: Iterator.amount divided by 100.

Step 4: Create the QuickBooks Online Deposit

Now we generate the journalized bank deposit record in QuickBooks so the bank feed matches seamlessly.

  1. Add the QuickBooks Online app and select the Create a Deposit module.
  2. In the Deposit To Account field, select your actual business checking account (the account receiving the Stripe direct deposit).
  3. Set the Date field to map: {{1.data.object.arrival_date}} (formatted using formatDate(arrival_date; YYYY-MM-DD)).
  4. Under Deposit Lines, configure two line items:

Line Item 1 (Gross Inflow):

  • Received From: Leave blank or set to Stripe.
  • Account: Undeposited Funds (or your designated Stripe Clearing Account).
  • Amount: Map the total from your Gross Sales Aggregator.

Line Item 2 (Processing Fee Outflow):

  • Account: Stripe Processing Fees (Expense).
  • Amount: Map the total from your Fee Aggregator multiplied by -1. (QuickBooks requires fee deductions on deposits to be negative numbers).
  • Description: Auto-generated: Stripe processing fees for Payout ID {{1.data.object.id}}.

Edge Cases and Troubleshooting

1. Handling Currency Discrepancies (FX Volatility)

If you sell internationally, Stripe converts foreign payments into your settlement currency at the time of the transaction, but minor floating currency fluctuations can occur before payout distribution. If your deposit is off by a few cents:

  • Add a dedicated Chart of Accounts line named Foreign Exchange Gain / Loss.
  • Create a conditional routing filter in Make: if net_settlement - (gross_sales - fees) != 0, post the remainder to that FX variance account.

2. Stripe Payouts with Negative Balances (Chargebacks)

If refunds and customer chargebacks exceed total revenue during a rolling period, Stripe will debit your bank account instead of depositing funds.

  • Add a Router module before the QuickBooks action.
  • Route A (Standard): If payout.amount > 0, execute the Create a Deposit action described above.
  • Route B (Debit Recovery): If payout.amount < 0, execute a Create an Expense action in QuickBooks to track the account clawback without breaking the deposit workflow.

Summary of Completed Scenario

Once activated, your scenario executes silently in the background:

[Stripe Instant Webhook] 
       │
[Get Balance Txns API] 
       │
   [Iterator] 
       │
[Aggregator: Fees & Gross] 
       │
[QuickBooks: Create Deposit]

When you log into QuickBooks Online to review your weekly bank feed, the incoming Stripe bank batch will display a green Match button instead of requiring manual splits. Click match,

If a client’s invoice remains unpaid due to credit card issues, ensure you also set up an automated failed payment recovery workflow to prevent revenue leakage.

Reconciling Invoice Payments

Automating invoice creation completes half of your financial operations pipeline. Once your customer pays that QuickBooks invoice through an online gateway like Stripe, you face the next accounting bottleneck: reconciling bulk payout deposits against individual invoice balances.

To automate net fee calculations and payout splits directly in your ledger, read our companion runbook: How to Auto-Sync Stripe Payout Transactions to QuickBooks Online Using Make.

Leave a Reply

Your email address will not be published. Required fields are marked *