Connect QuickBooks Online and Zapier Tables to power AI-driven automation No-code AI automation Full audit trails and controls SOC 2 and GDPR compliant Easy visual workflow builder 9,000+ apps, 450+ AI tools Free tier available Choose a Trigger
Choose an Action
Launch your first automated workflow Start with a template that brings QuickBooks Online and Zapier Tables together. Build enterprise-grade automation in minutes.
Our most popular template
Create deposits in QuickBooks Online from new records in Zapier Tables Zapier Tables + QuickBooks Online
Update Zapier Tables records whenever QuickBooks Online customers are updated QuickBooks Online + Zapier Tables
Create records in Zapier Tables for new invoices from QuickBooks Online QuickBooks Online + Zapier Tables
Create records in Zapier Tables from new customers in QuickBooks Online QuickBooks Online + Zapier Tables
Increase values in Zapier Tables when new payments are recorded in QuickBooks Online QuickBooks Online + Zapier Tables
Create records in Zapier Tables for new vendors in QuickBooks Online QuickBooks Online + Zapier Tables
Load more
Create new QuickBooks Online customers from new records in Zapier Tables Zapier Tables + QuickBooks Online
Create records in Zapier Tables for new accounts in QuickBooks Online QuickBooks Online + Zapier Tables
Top companies trust Zapier to automate work that solves their unique business problems—no coding required.
How Zapier works Zapier makes it easy to integrate QuickBooks Online with Zapier Tables - no code necessary. See how you can get setup in minutes.
QuickBooks Online
QuickBooks Online
Zapier Tables
Zapier Tables
1. Select the event
App
QuickBooks Online
Choose a trigger A trigger is the event that starts your Zap—like a "New Account" from QuickBooks Online.
Add your action An action happens after the trigger—such as "Calculate Summary Formula" in Zapier Tables.
You’re connected! Zapier seamlessly connects QuickBooks Online and Zapier Tables, automating your workflow.
Supported triggers and actions Zapier helps you create workflows that connect your apps to automate repetitive tasks. A trigger is an event that starts a workflow, and an action is an event a Zap performs.
Triggers Actions Triggers & Actions
New Account Triggers when you add a new account.
Try It New Bill Triggers when a new bill is added.
Try It Estimate Emailed Triggers when an estimate is emailed.
Try It New Expense Triggers when a new expense is added.
Try It Invoice Emailed Triggers when an invoice is emailed.
Try It New Bill Payment Triggers when a new bill paid.
Try It New Deposit Triggers when a there is a new deposit.
Try It New Paid Invoice Triggers when the balance of an invoice becomes zero.
Try It New Project Triggers when a new project is created.
Try It New Time Entry Triggers when a new time entry is created.
Try It New Purchase Order Triggers when a new purchase order is added.
Try It New Supplier Credit Triggers when a new supplier credit is created.
Try It Updated Credit Memo Triggers when a credit memo is updated.
Try It Updated Estimate Triggers when an existed estimate is updated.
Try It New Vendor Triggers when a new vendor is added.
Try It Create Bill (Item Based) Create a new bill, optionally tied to a customer.
Bill Number
Line_item
Line_description
Qty
Unit Price
Line_class
AP Account
Customer
Due_date
Transaction Date
Create Bill (Item Based) Create a new bill, optionally tied to a customer (with line item support).
Terms
Transaction Date
Due_date
Bill Number
Department
Global_tax_calculation
Product/Service
Description
Qty
Rate
Billable?
Customer
Line_class
Tax_code
AP Account
Memo
Create Employee Creates a new employee.
Primary Email Address
Middle Name
Employee Phone Number
Birth Date
Billable Time
Active
Release Date
Cost Rate
Employee Mobile
Gender
Hired Date
Organization
Address Line 1
Address Line 2
Address Line 3
Address Line 4
Address Line 5
Create Customer Adds a new customer.
Display_name
Title
First Name
Middle name
Last Name
Company
Email
Phone
Mobile
Fax
Other
Website
Active
GST Registration Type
GSTIN
Address__line1
Address__line2
Address__city
Address__state_code
Address__zip_code
Address__country
Shipping_address__line1
Shipping_address__line2
Shipping_address__city
Shipping_address__state_code
Shipping_address__zip_code
Shipping_address__country
Notes
Currency
Taxable
Tax_code
Tax Registration Number
Tax Resale Number
Job/Parent Customer
Bill with Parent?
Preferred_payment_method
Preferred_delivery_method
Terms
Customer_type
Create Expense Creates a new expense using check, cash, or credit card.
Bank/Credit AccountRequired
Payment Date
Payment_method
Reference Number
Print Later?
Account
Description
Amount
Billable Status
Tax Code
Customer
Class
Product/Service
Description
Quantity
Rate
Amount
Billable Status
Tax Code
Customer
Class
Memo
Tax_code
Total_tax
Tax_calculation
Department
Location
Currency
Exchange Rate
Create Journal Entry Creates a new journal entry.
Create Sales Receipt Adds a new sales receipt (with line item support).
Info
Customer
Find Customer by Name/Email
Email
Send Later?
Note
Message
Service_date
Line_description
Product/Service
Line Item Quantity
Line Item Unit Price
Line_item_tax_code
Line_item_class
Transaction Date
Total_discount
Payment_method
Payment Reference Number
Deposit To Account
Sales Receipt Number
Auto Generate Sales Receipt Number
Address__line1
Address__line2
Address__city
Address__state_code
Address__zip_code
Address__country
Shipping_address__line1
Shipping_address__line2
Shipping_address__city
Shipping_address__state_code
Shipping_address__zip_code
Shipping_address__country
Currency
Exchange_rate
Class
Tax_code
Total_tax
Tax_calculation
Shipping_tax
Shipping Cost
Department
Create Purchase Order Creates a new purchase order.
Purchase Order Status
Mailing_address
Shipping_address
Purchase Order Date
Ship Via
Purchase Order Number
PO Email
Account
Description
Amount
Customer
Class
Description
Rate
Customer
Class
Your Message to Vendor
Memo
Send Estimate Sends an estimate.
Send Sales Receipt Send an existing sales receipt.
Update Bill Updates an existing bill.
Vendor
AP Account
Transaction Date
Due Date
Line ID
Amount
Description
Account
Customer
Class
Tax Code
Billable Status
Currency
Exchange Rate
Private Note
Global Tax Calculation
Total Amount
Sales Terms
Department
Document Number
Include in Annual TPAR
Update Estimate Updates an existing estimate.
Customer
Transaction Date
Shipping Date
Detail Type
Amount
Description
Item
Unit Price
Quantity
Tax Code
Discount Percent
Print Status
Email Status
Shipping Address Line 1
Shipping Address Line 2
Shipping Address City
Shipping Address State/Province
Shipping Address Postal Code
Shipping Address Country
Billing Address Line 1
Billing Address Line 2
Billing Address City
Billing Address State/Province
Billing Address Postal Code
Billing Address Country
Class
Sales Terms
Shipping Method
Tracking Number
Document Number
Accepted By
Accepted Date
Exchange Rate
Department
Apply Tax After Discount
Private Note
Customer Memo
Expiration Date
Transaction Status
Update Product Updates an existing product.
Name
Type
SKU
Sales Tax Included
Sales Tax Code
Class
Source
Purchase Tax Included
Description
Sub Item
Taxable
Purchase Description
Active
Purchase Cost
Unit Price
Update Sales Receipt Updates an existing sales receipt.
Customer
Transaction Date
Shipping Date
Info
Detail Type
Amount
Description
Item
Unit Price
Quantity
Discount Percent
Total Amount
Print Status
Email Status
Payment Reference Number
Deposit To Account
Payment Method
Shipping Address Line 1
Shipping Address Line 2
Shipping Address City
Shipping Address State/Province
Shipping Address Postal Code
Shipping Address Country
Billing Address Line 1
Billing Address Line 2
Billing Address City
Billing Address State/Province
Billing Address Postal Code
Billing Address Country
Tracking Number
Class
Department
Private Note
Customer Memo
Create Vendor Adds a new vendor.
Phone
Email
Website
Address__line1
Address__line2
Address__city
Address__state_code
Address__zip_code
Company__name
Vendor__1099
Void Invoice Void an invoice.
Find Account Find an account by name.
Find Customer Find a customer by name or email address.
Find Class Finds a class based on name or ID.
Find Employee Finds an employee based on display name or ID.
Find Products Find products by names (with line item support)
Find Sales Receipt Finds a sales receipt by ID, Customer Name or Sales Receipt Number.
Find Product Find a product by name or sku
Find or Create Customer Finds or creates a specific customer v2.
Display_name
Title
First Name
Middle name
Last Name
Company
Email
Phone
Mobile
Fax
Other
Website
Active
GST Registration Type
GSTIN
Address__line1
Address__line2
Address__city
Address__state_code
Address__zip_code
Address__country
Shipping_address__line1
Shipping_address__line2
Shipping_address__city
Shipping_address__state_code
Shipping_address__zip_code
Shipping_address__country
Notes
Currency
Taxable
Tax_code
Tax Registration Number
Tax Resale Number
Job/Parent Customer
Bill with Parent?
Preferred_payment_method
Preferred_delivery_method
Terms
Customer_type
Find or Create Sales Receipt Finds or creates a specific sales receipt.
Info
Customer
Find Customer by Name/Email
Email
Send Later?
Note
Message
Service_date
Line_description
Product/Service
Line Item Quantity
Line Item Unit Price
Line_item_tax_code
Line_item_class
Transaction Date
Total_discount
Payment_method
Payment Reference Number
Deposit To Account
Sales Receipt Number
Auto Generate Sales Receipt Number
Address__line1
Address__line2
Address__city
Address__state_code
Address__zip_code
Address__country
Shipping_address__line1
Shipping_address__line2
Shipping_address__city
Shipping_address__state_code
Shipping_address__zip_code
Shipping_address__country
Currency
Exchange_rate
Class
Tax_code
Total_tax
Tax_calculation
Shipping_tax
Shipping Cost
Department
Find or Create Vendor Finds or creates a specific vendor.
Phone
Email
Website
Address__line1
Address__line2
Address__city
Address__state_code
Address__zip_code
Company__name
Vendor__1099
New or Updated or Deleted Record Triggers when a record is added, updated, or deleted in a table.
Zap_id
Zap_step_id
Zap_path_run_id
Try It New Record Triggers when a new record is added to a table.
Zap_id
Zap_step_id
Zap_path_run_id
Try It Updated Record Triggers when a record is updated on a table.
Zap_id
Zap_step_id
Zap_path_run_id
Try It Continue Zap Button Clicked The Zap will run until this step, then wait until a Continue Button is clicked.
Delete Record Delete an existing record on a table.
Zap_id
Zap_step_id
Zap_path_run_id
Increment or Decrement Value Increments or Decrements a value on a number field of a record.
Zap_id
Zap_step_id
Zap_path_run_id
Change Button State Changes the state (enabled or disabled) and label of a button on an existing record.
Find Table Finds a table based on an exact match.
Find or Create record Finds or creates a specific find record.
Zap_id
Zap_step_id
Zap_path_run_id
New Bank Transaction Triggers when a new bank transaction is created.
Try It New Customer Triggers when you add a new customer.
Try It New Estimate Triggers when you add a new estimate.
Try It New Invoice Due Triggers when an invoice becomes due within a specified number of days.
Try It New Invoice Triggers when you add a new invoice.
Try It New Credit Memo Triggers when a new credit memo is created.
Try It New Journal Entry Triggers when a new journal entry is created.
Try It New Product Triggers when a new product is created.
Try It New Refund Receipt Triggers when there is a new refund receipt.
Try It New Payment Triggers when a payment is received (with line item support).
Try It New Sales Receipt Triggers when a new sales receipt is added.
Try It Updated Bill Triggers when a bill is updated.
Try It Updated Customer Triggers when an existing customer is updated.
Try It Updated Invoice Triggers when an invoice is updated.
Try It Attach File(s) or Note Attach a file or note to a QuickBooks record, or upload a standalone file without linking it to a record
Create Bill (Account Based) Create a new bill, optionally tied to a customer (with line item support).
Terms
Transaction Date
Due_date
Bill Number
Department
Currency
Exchange Rate
Global_tax_calculation
Description
Billable?
Customer
Class
Tax_code
AP Account
Memo
Create Deposit Creates a new deposit in QuickBooks.
Create Credit Memo Creates a new credit memo.
Email
Send Later?
Billing_address
Credit_memo_date
Credit_memo_number
Auto Generate Credit Memo Number
Class
Service_date
Product/Service
Description
Quantity
Rate
Tax
Class
Message_displayed_on_credit_memo
Memo
Apply Tax After Discount?
Discount_value
Discount_percent
Sales Tax Rate
Shipping Cost
Create Estimate Create a new estimate (with line item support).
Number
Line_description
Line Item/Product
Line Item Quantity
Line_item_tax_code
Line Item Service Date
Rate
Tax_calculation
Transaction Date
Expiration_date
Ship Date
Message displayed on estimate
Billing_address
Billing Address City
Billing Address Country
Billing Address Postal Code
Billing Address State/Province
Shipping_address
Shipping Address City
Shipping Address Country
Shipping Address Postal Code
Shipping Address State/Province
Shipping amount
Bill Email
Send later
Discount_value
Discount_percent
Class
Sales Terms
Shipping Method
Tracking Number
Private Note
Transaction Status
Apply Tax After Discount
Print Status
Department
Create Product/Service Creates a new product or service.
Create Invoice Adds a new invoice (with line item and bundle item support).
Info
Email
Cc
Bcc
Send Later?
Billing_address
Shipping_address
Terms
Invoice Date
Due_date
Ship_via
Shipping_date
Tracking_number
Invoice Number
Auto Generate Invoice Number
Service Date
Product/Service
Description
Quantity
Rate
Helptext_line_amount
Amount
Tax
Class
Add Bundle Item to invoice?
Message Displayed on Invoice
Message Displayed on Statement
Project ID
Accept Payment Via Bank Transfer
Accept Payment Via Credit Card
Tax_code
Total_tax
Tax_calculation
Apply Tax After Discount?
Discount_value
Discount_percent
Shipping_tax
Shipping
Deposit
Deposit To Account
Class
Department
Location
Currency
Exchange Rate
Create Payment Creates a new payment, optionally linked to an invoice.
Unapplied Amount
Transaction Date
Payment_method
Payment Reference Number
Deposit To Account
Line_amount
Line Linked Invoice
Memo
Create Refund Receipt Creates a new refund receipt.
Send Invoice Send an existing invoice.
Create Time Activity Creates a new single time activity.
Time Activity TypeRequired
Update Customer Updates an existing customer.
Company
Email
Title
First name
Middle name
Last name
Suffix
Display name as
Phone
Mobile
Fax
Other
Website
Print_on_check_as
Notes
Billing Address - Street
Billing Address - City/Town
Billing Address - State/Province
Billing Address - ZIP code
Billing Address - Country
Shipping Address - Street
Shipping Address - City/Town
Shipping Address - State/Province
Shipping Address - ZIP code
Shipping Address - Country
Exemption_details
Job/Parent Customer
Active
Customer_type
Preferred_payment_method
Taxable
Tax_code
Tax Registration Number
Currency
Update Invoice Updates an existing invoice (with line item support).
Customer
Email
Cc
Bcc
Send Later?
Billing_address
Shipping_address
Terms
Invoice Date
Due_date
Ship_via
Shipping_date
Tracking_number
Invoice Number
Auto Generate Invoice Number
Service_date
Product/Service
Description
Quantity
Rate
Amount
Tax
Class
Message Displayed on Invoice
Message Displayed on Statement
Accept Payment Via Bank Transfer
Accept Payment Via Credit Card
Tax_code
Total_tax
Tax_calculation
Apply Tax After Discount?
Discount_value
Discount_percent
Shipping_tax
Shipping
Deposit
Class
Department
Location
Currency
Update Purchase (Expense) Updates an existing purchase/expense transaction.
Update Vendor Updates an existing vendor.
Title
Given Name
Middle Name
Suffix
Family Name
Primary Email Address
Display Name
Fax number
Business Number
Currency Code
Currency Name
Mobile Phone Number
Primary Phone Number
Alternate Phone Number
Active
Vendor 1099
Cost Rate
Billing Rate
Web Address
Company Name
Tax Identifier
Account Number
Print On Check Name
Address__line1
Address__line2
Address__city
Address__state_code
Address__country
Address__zip_code
Balance
Create Vendor Credit Creates a new vendor credit.
Transaction Date
Document Number
Currency
Exchange Rate
Location
Department
Tax Calculation
Memo
Account
Description
Amount
Billable Status
Tax Code
Customer
Class
Product/Service
Description
Quantity
Rate
Amount
Billable Status
Tax Code
Customer
Class
API Request (Beta) This is an advanced action which makes a raw HTTP request that includes this integration's authentication.
Get Attachments Get attachments from a record.
Find Estimate Finds an estimate.
Estimate Id
Doc Number
Customer Name
Transaction Date
Total Amount
Find Customer by Query Finds customers using custom SQL-like WHERE clause syntax for advanced querying.
Find Payment Finds a payment based on Id.
Find Purchase (Expense) Find a purchase/expense transaction by various criteria such as vendor, date, amount, or document number.
Info
Purchase ID
Document Number
Vendor ID
Vendor Name
Transaction Date
Total Amount
Payment Type
Find Invoice Find an invoice using either Invoice Number, Invoice ID or Invoice Date or Due Date.
Info
Invoice Number
Invoice ID
Invoice Date
Due Date
Find Vendor Find a vendor by name.
Find or Create Employee Finds or creates a specific employee.
Info
ID
Display Name
Primary Email Address
Middle Name
Employee Phone Number
Birth Date
Billable Time
Active
Release Date
Cost Rate
Employee Mobile
Gender
Hired Date
Organization
Address Line 1
Address Line 2
Address Line 3
Address Line 4
Address Line 5
Find or Create Product Finds or creates a specific product.
Trigger Zap Button Clicked Triggers when a button is clicked on a record.
Try It New or Updated Record Triggers when a record is added or updated on a table.
Zap_id
Zap_step_id
Zap_path_run_id
Try It Summary Formula Updated Triggers when a Summary Formula value has changed.
Try It Calculate Summary Formula Calculates a Summary Formula for a Field.
Create Record Creates a new record on a table.
Zap_id
Zap_step_id
Zap_path_run_id
Duplicate Table Create a new table with an existing table as a template.
Update Record Update an existing record on a table.
Zap_id
Zap_step_id
Zap_path_run_id
Find Records Finds records based on a search value.
Zap_id
Zap_step_id
Zap_path_run_id
Get Summary Formula Values Gets all calculated Summary Formula values for a Table.
Load more
For AI agents & developers
Use QuickBooks Online and Zapier Tables with AI agents and code Beyond Zap workflows. Call QuickBooks Online and Zapier Tables actions directly from your AI client or your codebase, using the same 9,000+ app integrations Zapier already runs.
No code Connect via Zapier MCP Expose QuickBooks Online and Zapier Tables actions as tools in any MCP client. Authenticate once, then call them in natural language.
Example actions on this page
Works with
Claude · ChatGPT · Cursor · any MCP-compatible client
Connect Zapier MCP Typescript Call from code with the Zapier SDK Trigger QuickBooks Online and Zapier Tables actions from backend services, scripts, or agent code.
Install
# TypeScript / Node
npm install @zapier/zapier-sdk Run an action
import { createZapierSdk } from '@zapier/zapier-sdk';
const zapier = createZapierSdk();
await zapier.runAction({ /* quickbooks / zapier-tables action */ }); Run the SDK docs There is no Python package yet. SDK is TypeScript-only (@zapier/zapier-sdk). The MCP server URL is personal to your account; get it at zapier.com/mcp.
Zapier is the automation platform of choice for 87% of Forbes Cloud 100 companies in 2023 93%
Customers who say using Zapier has made them better at their job
25m
Customers have created over 25 million Zaps on the platform
6 mins
The average user takes less than 6 minutes to set up a Zap
Learn how to automate QuickBooks Online on the Zapier blog
How to automate invoices with QuickBooks Online and Zapier You can streamline your invoicing process by adding automation to the mix. Here's how to set up a Zap—what we call our automated workflows—that turns orders from your online store into invoices in QuickBooks Online.
4 ways to automate QuickBooks Online Automation can help keep you on track the entire calendar year so that, come tax time, you won't have to start from scratch and dig through a mountain of digital paperwork. Here's how you can use Zaps—Zapier's automated workflows—to connect the tools across your business to QuickBooks so your books...
Learn how to automate Zapier Tables on the Zapier blog
How to set up a team operations portal with Zapier Here's how to build your own operations portal with Zapier Interfaces (a landing page builder), Zapier Tables (automation-powered databases), and Zaps (what we call automated workflows). Create a streamlined, efficient workspace that powers your business from the inside out.
How to build an automated system on Zapier Learn how to use Zapier Interfaces, Tables, and Zaps to build a completely custom, automated system. Plus, add an AI chatbot to speed up customer interactions.
How to create an onboarding system with Zapier With Zapier, you can create an entire onboarding process that collects and stores all of your employee data in one place. Then you can trigger automated workflows that let you email and message your new employees with their onboarding tasks, assign buddies to them, add their details to other apps,...
Load more
Make work flow with AI Level up your QuickBooks Online to Zapier Tables integration with AI. Extract, summarize, and transform your integration data with leading AI models like
OpenAI ,
Anthropic , and more.
QuickBooks Online is the web version of the popular accounting packages QuickBooks. Use any Zapier integration to connect QuickBooks Online to hundreds of other apps.
Zapier Tables is a no-code database built for automation.
Connect QuickBooks Online to Zapier Tables on the world's largest no-code automation platform 
