Use QuickBooks actions in HubSpot workflows

The QuickBooks Online integration includes several workflow actions that enable you to automate the creation of QuickBooks invoices, sales estimates, and sales receipts. Below, learn how to use these actions in deal, quote, and payment-based workflows.

While users in a Marketing Hub, Sales Hub, Service Hub, or Operations Hub Professional account can set up workflows to use with QuickBooks Online, the integration can be used on any subscription level.

Please note: QuickBooks Online actions in HubSpot workflows are only available for customers based in the United States.

Integration sync requirements

To create invoices, sales estimates, and receipts in QuickBooks Online, HubSpot first checks the data between the two platforms before any data is synced to QuickBooks Online. This helps to ensure data accuracy and prevent unnecessary data from being created in QuickBooks online. Below are the requirements that contacts and line items must meet in order for HubSpot to create new assets in QuickBooks Online through workflow actions:

• Contacts:
  • Legacy integration: in the legacy QuickBooks Online integration, the First Name, Last Name and Email address contact properties are used to match the HubSpot contact record to a QuickBooks contact. A new contact will be created in QuickBooks if no match is found. If there are multiple contact records associated with the quote or deal record in HubSpot, the first associated contact will be used.
  • New integration: in the new QuickBooks Online integration, a contact must match your data sync settings in order for HubSpot to create assets in QuickBooks Online, or the workflow action will fail. This helps prevent HubSpot from creating unnecessary contacts in QuickBooks Online. For example, if you're using the Create a QuickBooks invoice action, but the enrolled deal's associated contact isn't eligible to sync, HubSpot will not create the invoice in QuickBooks Online. Therefore, it's recommended to set your HubSpot workflows to enroll based on your data sync contact filters.
• Line items: line items in HubSpot must be associated to the quote or deal records enrolled in the workflow to create an invoice, sales estimate, or sales receipt in QuickBooks. HubSpot will match a line item in HubSpot with the product in QuickBooks. If no match is found, the invoice, sales estimate, or sales receipt will not be created. 

It's recommended that product sync in turned on in your QuickBooks settings, and QuickBooks products are used for deal and quote line items to ensure that an invoice, sales estimate, or sales receipt is created.

Add QuickBooks actions to your deal or quote-based workflow

You can add QuickBooks actions to HubSpot workflows to create an invoice, sales orders, or estimates in your QuickBooks account. To add these actions: 

• In your HubSpot account, navigate to Automation > Workflows.
• Click the name of a workflow to edit an existing workflow. Or click Create workflow to create a new workflow.
• Click the plus icon +.
• In the right panel, select a QuickBooks action:
• To create an invoice, click Create a QuickBooks invoice.
• To create an estimate, click Create a QuickBooks estimate.
• To create a sales receipt, click Create a QuickBooks sales receipt.

• Click the Which QuickBooks account do you want to create an invoice/estimate/sales receipt for? dropdown menu and select the QuickBooks account. 
• Click the Payment Terms dropdown menu and select a value (only available for the Create a QuickBooks invoice action). 
• Click the Customer dropdown menu and select a customer.
• Click the Products dropdown menu and select a product. 
• Click the Create a product in QuickBooks if it doesn’t exist? dropdown and select either Yes or No. 
• Click Save. 
• Finish editing your workflow, then click Review and publish to review the workflow.
• Click Turn on to turn the workflow on.

Please note: invoices created will be associated to the workflow object. For example, if you create an invoice using a deal-based workflow, the invoice will be associated to the deal. 

To enroll a paid quote in a workflow:

• In your HubSpot account, navigate to Automation > Workflows.
• To create a new workflow, in the upper right, click Create workflow.
• In the left panel, select Quote-based.
• In the right panel, select your workflow type.
• Click the pencil icon to give your workflow a name, then click Next. You'll then be taken to the workflow editor.
• In the workflow editor, click Set up triggers.
• In the Filters section, select Quote > Esign completed signature, then select is known. 

To enroll a paid deal in a workflow:

• In your HubSpot account, navigate to Automation > Workflows.
• To create a new workflow, in the upper right, click Create workflow.
• In the left panel, select Deal-based.
• In the right panel, select your workflow type.
• Click the pencil icon to give your workflow a name, then click Next. You'll then be taken to the workflow editor.
• In the workflow editor, click Set up triggers.
• In the Filters section, select Deal > Deal name, then contains any of Payment Link. 

Using QuickBooks actions with HubSpot payments

You can also create paid invoices and sales receipts using workflows if you have HubSpot payments set up. Sales receipts can be created for all types of products. Paid invoices can only be created for non-taxable line items.

Please note: it is only possible to use these actions with payments-based workflows. 

To use QuickBooks Online actions in a payment-based workflow:

• In your HubSpot account, navigate to Automation > Workflows.
• To create a new workflow, in the upper right, click Create workflow.
• In the left panel, select Payment-based.
• Click the pencil icon to give your workflow a name, then click Next. You'll then be taken to the workflow editor.
• Select your workflow triggers. For each group of enrollment triggers you add, you should also add a Source is not equal to all of Invoice filter. This will prevent HubSpot from enrolling payments already made with invoices, which would create duplicate invoices in QuickBooks Online.
  
  
• Click the plus icon +.
• In the right panel, select a QuickBooks action:
  • To create an invoice, click Create a QuickBooks paid invoice. This will create a paid invoice in QuickBooks using your HubSpot payment data. 
  • To create a sales receipt, click Create a QuickBooks sales receipt. This will create a sales receipt in QuickBooks using your HubSpot payment data.
• Click the Which QuickBooks account do you want to create an invoice/sales receipt for? dropdown menu and select the QuickBooks account. 
• Click the Customer dropdown menu and select a customer.
• Click the Products dropdown menu and select a product. 
• Click the Create a product in QuickBooks if it doesn’t exist? dropdown and select either Yes or No. 
• Click Save. 
• Finish editing your workflow, then click Review and publish to review the workflow.
• Click Turn on to turn the workflow on.

Create a QuickBooks expense in a HubSpot workflow

You can also create a QuickBooks expense with a HubSpot workflow action. This action will create an expense in QuickBooks to reflect your HubSpot payment fee. To create an expense: 

• In your HubSpot account, navigate to Automation > Workflows.
• To create a new workflow, in the upper right, click Create workflow.
• In the left panel, select Payment-based.
• Click the pencil icon to give your workflow a name, then click Next. You'll then be taken to the workflow editor.
• Select your chosen triggers. 
• Click the plus icon +.
• In the right panel, select Create a QuickBooks expense. 
• Fill out the required fields.
• Click Save. 

Create refund receipts in QuickBooks

To create a refund receipt in QuickBooks when a full refund occurs in HubSpot payments:

• In your HubSpot account, navigate to Automation > Workflows.
• To create a new workflow, in the upper right, click Create workflow.
• In the left panel, select Payment-based. 
• Click the pencil icon to give your workflow a name, then click Next. You'll then be taken to the workflow editor.
• Select your chosen triggers. 
• Click the plus icon +.
• In the right panel, select Create a QuickBooks refund receipt. 
• Fill out the required fields.
• Click Save.