Skip to content
English
Customer portal Sign in
  • There are no suggestions because the search field is empty.

How do I map VAT, GST and HST codes?

How to map tax codes for Canada and Europe with Connex

Introduction

Systems like Odoo, Sage Business Cloud Accounting and QuickBooks Online allow you to map tax codes on line items. In the United States, the entire order has a single code. Outside the United States, different products can have different tax codes.

In these examples, tax codes appear on the line items. Y0u need to use the Connex rules engine to map the codes.

Is there a demo?

Here is a demo:

 

How do I set up customers?

If you sell B2C, we recommend one customer per currency code. If you sell B2B, it is OK to have individual customers.

In this example, we sell in USD, EUR and GBP. Here are the steps to set up customers per currency code:

  1. In QuickBooks Online, go to customers.
  2. Create a customer.
  3. In the display name as field, enter USD Customers.
  4. Under default currency code, enter the currency code USD.
  5. Perform the same steps for EUR and GBP.
  6. Perform the same steps for each currency.
  7. In Connex, go to settings > customer match.
  8. Enter billing company name last name, first name as the match.
  9. In Connex, click rules engine.
  10. Upload this spreadsheet. This will map to USD Customers, GBP Customers and EUR customers.

How do I map tax codes based on the shipping address country code?

If you use QuickBooks Online, we recommend uploading a spreadsheet of tax codes. Alter the spreadsheet with the tax code name. There are three times of mappings:

  1. Download - Map Discount Tax Codes: If there is a discount, this is the tax code.
  2. Download - Map Shipping Tax Code: If there is a shipping amount, this is the tax code.
  3. Download - Map Order Item Tax Code: For every product on the sale, this is the tax code.

Taxes are mapped by shipping address country. Once complete, go to the Connex rules engine. Click the upload button on the right of the grid. Upload the spreadsheet.

If you wish to add a new rule in the future, follow these steps:

Here are the steps:

  1. Login to Connex.
  2. Click rules engine.
  3. Click add new rule.
  4. Scroll to the bottom and select write rule without order number.
  5. In the title, enter the title of the rule like Standard 20%.
  6. As the action, choose map order item tax code: 
  7. In conditions, enter these values: Shipping Country, Equals, GB.
  8. In the map to, enter 20% Standard.
  9. Click submit.

Can I map tax codes, based on a product SKU?

Yes, under conditions add another row: Product SKU, Equals, (ENTER SKU)