HelpQuickBooks Online

Common Problems with Quickbooks

Last updated:

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, contact us 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.

Need more help?

Contact Support

Tell us about your problem, and we’ll find you a solution or you can email support.
Get Help

Hire an Expert

We have a directory of professionals across the globe who are ready to help.
Find a Zapier Expert

Zapier Community

Connect with other Zapier users and industry professionals to get help crafting the perfect workflow.
Check out the community

Zapier University

Video courses designed to help you become a better Zapier user, whether you’re a beginner or more experienced.
View courses