Sales Tax

How do I map sales tax codes to QuickBooks Online?

Connex for QuickBooks allows you to match existing QuickBooks tax codes based on the city, county, or state to QuickBooks. Connex supports QuickBooks Canada and the UK. This allows for easy management and reporting of sales tax payable in QuickBooks.

How do I map U.S. tax codes?

QuickBooks AST

For many users, automatic sales tax mapping is enabled in QuickBooks. This means Connex will send QuickBooks the total tax on the order. Then, QuickBooks will decide the proper tax code to add. Our software will detect whether AST is enabled and no settings change is required on Connex. During the QuickBooks install, you can set up AST. Here is an example order with tax:

Map Tax Codes in Connex

If you have some tax codes for for U.S. customers already located in QuickBooks Online, we can use Connex to tell QBO which one to use, based on the Shipping Address in the order. In this example, we will map existing QuickBooks sales tax codes:

  1. Login to Connex.
  2. Click manage.
  3. Expand sales tax.
  4. Next, click +Add New Code:
  5. Select the appropriate code from the drop-down and fill the remaining fields:

  6. When finished, click Update - congratulations, the code is now mapped. This is what it will look like:

  7. Next, map any additional required codes via the instructions above.

  8. When complete, click Save Settings and Sync Now on the bottom right.


I want to map a tax code for the entire state, and not a specific county / city. How do I do that?

The process is the same as the example above, but leave the City and County portions blank. For example, if you charge 6.75% for OH (Ohio Sales Tax) and want all orders from Ohio to receive that percentage.

I use QuickBooks Canada. How do I map tax?

The process is the same as the U.S. tax codes. There is no need to map city or county. You can map a code, region, and enter CA as the country. If your region has multiple rates, then map a tax code that has multiple rates. 

If you map no tax code, then Connex will apply exempt to the order.