Syncing Sales Tax in WooCommerce Orders with QuickBooks Desktop - Canada

Discover how to efficiently sync sales tax data between WooCommerce orders and QuickBooks Desktop in Canada for accurate accounting.

Written by the MyWorks Team

Updated at January 23rd, 2026

Table of Contents

Tax Rates in Canada are uniform and almost always consist of 13-17 static rates charged across different provinces, usually GST, HST, PST, and sometimes a combination of GST and PST. 

In WooCommerce, these rates should be manually set up in WooCommerce > Settings > Tax. No automated sales tax calculation service should be necessary in WooCommerce, as these rates do not vary once set up.

In QuickBooks, these rates can be added as Sales Tax Items in the Item List, if not already present. Once added in both WooCommerce and QuickBooks, they can be mapped together in MyWorks Sync.

What's needed:

  • In MyWorks Sync > Settings > Tax, set a taxable and non-taxable code - normally "G" and "E." The tax code format should be set to "Sales Tax Code."
  • In MyWorks Sync > Map > Tax Rates, your WooCommerce tax rates should be mapped to the corresponding QuickBooks tax codes - normally called G, H, P, etc.

 

Once set, orders will sync from WooCommerce to QuickBooks, preserving the tax treatment (or lack thereof) in WooCommerce.

Compound Rate Mapping

If the WooCommerce order uses more than one tax rate (typical in Canada). QuickBooks Desktop only supports one tax rate for each line item, so if there are two tax rates in your WooCommerce order, these need to be compound-mapped to the single combined rate in QuickBooks at MyWorks Sync > Map > Taxes.

To enable the Compound Rate mapping view, use the “Show Compound Taxes” button top right of MyWorks Sync > Map > Taxes