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?
Enable QuickBooks Desktop Sales Tax
If you use QuickBooks Online, then skip this step. To get started, sales tax management must enabled in QuickBooks, even if your company charges does not charge sales tax.
- In QuickBooks, click Edit > Preferences;
- next, click Sales Tax > Company Preferences;
- Click Yes to 'Do you charge sales tax?'.
- Add a default tax agency:
- When asked to make items and customers taxable, click OK.
Map Tax Codes in Connex
Now that we have some tax codes, for U.S. customers, let's map existing QuickBooks sales tax codes:
- Login to Connex.
- Click manage.
- Expand orders.
- Expand sync orders to QuickBooks.
- Expand sales tax.
- Next, click +Add New Code:
Select the appropriate code from the drop-down and fill the remaining fields:
When finished, click Update - congratulations, the code is now mapped. This is what it will look like:
Next, map any additional required codes via the instructions above.
When complete, click Save Settings and Sync Now on the bottom right.
What if my new tax code doesn't appear in the list?
You may need to refresh your drop downs. See this article for more information.
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. It will look similar to this:
If you map no tax code, then Connex will apply exempt to the order.
I want to map tax codes on an item basis. Is this possible?
You can map the tax code from the QuickBooks item list. For more info, read this guide.
How do I map grouped sales tax codes?First, we need to create a sales tax item in QuickBooks. To create a new sales tax item:
- In QuickBooks, click Lists > Item List > New Item > Sales Tax Item
- Click OK
- In QuickBooks, click Lists > Item List > New Item > Sales Tax Group
- Fill in Name, description, choose corresponding sales tax items;
- Click OK.
Here is the end result:
Like before, add the tax mapping. In the city or county columns, enter a city or column where this code should get applied. If the incoming order matches a city or county that you mapped, then Connex will apply the code.
Can I override the default sales tax code of non or tax?
Yes, you can create rules to compare tax and apply a tax code. You may also use the tax code from QuickBooks. For more details, read this article.
Does Connex support sales tax groups?
Yes. To see how to set this up, please click here: Group Sales Tax Item in QuickBooks.
Third-party Sales Tax Management Services
If you're using a third-party service like Avalara, you do not need to map sales tax codes. For third-party sales tax management solutions, enable tax mapping as a line item.
- city_county.xlsx (1 MB)