QuickBooks Online

QuickBooks Online Help & Support

  • How to Get Started with QuickBooks on Zapier
  • Popular Things To Do With Quickbooks
  • Common Problems with Quickbooks

How to Get Started with QuickBooks on Zapier

About Quickbooks Online's Integration#

  • Admin/owner permissions: Admin
  • Paid/versioned account: Paid
  • Custom field support: N/A
  • Partner’s documentation: N/A

Connecting with Quickbooks Online#

When you start creating a QuickBooks Online Zap, you will be prompted to connect a New Account:

Connect your QuickBooks account.

Click the button and a pop-up would appear. Enter your QuickBooks Online Email/User ID and Password:

Login to QuickBooks

After adding your login details, QuickBooks online will ask you to authorize Zapier to access your data. Click Authorize:

Authorize Zapier to access your QuickBooks account.

The pop-up would disappear and you will see your QuickBooks Online account added to your Zapier account and is ready for selection.

Testing and approving your account in Zapier!

Popular Things To Do With Quickbooks

Create QuickBooks Online customers with sales receipts for new Stripe charges

Stripe + QuickBooks Online

Try It

Add new Stripe charges to QuickBooks Online as sales receipts

Stripe + QuickBooks Online

Create QuickBooks Online sales receipts from new WooCommerce orders

WooCommerce + QuickBooks Online

Add new WooCommerce orders to QuickBooks Online as customers

WooCommerce + QuickBooks Online

Create invoices for QuickBooks Online customers from new Shopify orders

Shopify + QuickBooks Online

Add new QuickBooks Online invoices to a Google Sheets spreadsheet as new rows

QuickBooks Online + Google Sheets

Common Problems with Quickbooks

How do I use line items with Quickbooks?#

To use line items in Zapier, you'll usually want to ensure that both the trigger and the action you're using have line item support:

""

In Zapier's Quickbooks integration, the “New Sales Receipt,” “New Invoice,” and “New Payment” triggers offer line item support, as do the “Create Bill (Account Based),” “Create Bill (Item Based),” “Create Estmate,” “Create Sales Receipt,” “Create Invoice,” and “Update Invoice” actions and the “Find Product(s)” search.

If you want to learn more about how line items work, read our Guide to Line Items here.

Desktop Version#

At this time Zapier does not support the desktop version of Quickbooks. We only support Quickbooks Online (or QBO for short!). It's not possible for us to access the desktop version, but converting to QBO from desktop is a fairly painless process.

Self-Employed Version#

At this time Zapier does not support the Self-Employed version of Quickbooks Online. If you are currently on the Self-Employed plan and want to use Zapier, you can upgrade to a full Quickbooks Online account.

Customer Name Already in Use#

Zapier uses the Display Name as a unique handle for finding customers inside of Quickbooks. If you attempt to create a new customer, employee, and vendor that reuses an existing Display Name you will experience an error.

Free Plan on Zapier#

Because of the way Intuit bills for connections into Quickbooks, we're unable to provide this application under free or non-trial accounts. If you upgrade to a paid Zapier plan you will have full access to Zapier and Quickbooks!

Token Expired#

Sometimes this happens because you change your password in Quickbooks, revoked our app's permissions, or the authorization expired (sometimes Quickbooks resets them). You should be able to just connect or reconnect your Account in Zapier. For example, in your account settings:

Reconnect your account.

Receive error: "There is no account associated with the item 'Sales'. Is it marked for purchase, and has an account associated with it?"#

If you receive this error when creating items inside Quickbooks, try this:

  • Log in to Quickbooks Online and click on Settings > Account & Settings > Advanced > Automation > Apply bill payments
  • Uncheck the box "Automatically apply bill payments."

quickbooks screenshot

Business validation error/Deprecated fields#

If you are running into issues with unsupported fields, you may be using an older version of Quickbooks. Zapier uses V3 of the Quickbooks API. If you are using a newer version and still getting this error please drop us an email and we can take a closer look.

Error: "The application has already been subscribed to by another user for this company"#

If you get this error, you'll need to disconnect Zapier from your Quickbooks account, then try reconnecting. To do this, click on "Apps" from the lefthand navigation inside of your Quickbooks account, then choose, "My Apps", then, "Manage my Apps". Delete the Zapier connection and then try connecting your account through your zap again. If you continue to run into this issue, email contact@zapier.com and we can attempt to force delete the connection.

The SKU field isn't available on the Create Invoice actions#

SKUs are set on the product and cannot be manually written to the invoice, so that's why this field is unavailable. If you select the correct Line Item/Product, then the SKU will automatically pull in to the invoice.

Error: Invalid account type: You need to select a different type of account for this transaction.#

When using "Create Sales Receipt" action, the "Deposit To Account" specifies a deposit account where the customer's payment is deposited. For this field, QuickBooks' only accepts account types "Other Current Asset" or "Bank".

Error: "list index out of range"#

This error means that QuickBooks tried to find a record but it couldn't. This has occurred previously for the action Create Invoice by Customer. When trying to find an email address here - ""

QuickBooks didn't yet have that email address on file and returned the 'list index out of range' error.

To fix this error, you need to add another QuickBooks step before this: Find or Create Customer. This will ensure that a customer record is created for QuickBooks to find in the next step.

Error: Business Validation Error: Select a product or service#

Check to see if "Shipping" is turned on in the company's Quickbooks settings under the "Sales" tab. Switching that ON should fix the issue.

Connect the apps you use every day

Get started with a Free account

Or
By signing up, you agree to Zapier’s Terms of Service