Calculator Inputs
Example Data Table
| Province | Mode | Item Amount | Shipping | Discount | Federal Tax | Provincial Tax | Total Tax | Grand Total |
|---|---|---|---|---|---|---|---|---|
| Ontario | Exclusive | CAD 200.00 | CAD 20.00 | 10% | CAD 10.00 | CAD 16.00 | CAD 26.00 | CAD 226.00 |
| British Columbia | Exclusive | CAD 100.00 | CAD 15.00 | CAD 0.00 | CAD 5.75 | CAD 8.05 | CAD 13.80 | CAD 128.80 |
| Quebec | Exclusive | CAD 150.00 | CAD 10.00 | CAD 5.00 | CAD 7.75 | CAD 15.46 | CAD 23.21 | CAD 178.21 |
| Nova Scotia | Inclusive | CAD 114.00 | CAD 0.00 | CAD 0.00 | CAD 5.00 | CAD 9.00 | CAD 14.00 | CAD 114.00 |
Formula Used
Exclusive pricing
Inclusive pricing
This version separates federal and provincial portions, while still allowing editable overrides for special storefront rules, promotions, manual audits, or future rate changes.
How to Use This Calculator
- Select the customer province or territory.
- Choose tax-exclusive pricing or inclusive reverse calculation.
- Enter item amount, shipping, and any discount.
- Pick the item tax status and decide whether shipping is taxable.
- Review the preset rates, then override them only if needed.
- Submit the form to view the result above the calculator.
- Use the CSV or PDF buttons to export the summary.
FAQs
1. What taxes does this calculator handle?
It supports GST, HST, PST, RST, and QST style calculations for Canadian ecommerce pricing. Federal and provincial portions are shown separately, even in HST provinces.
2. Which province should I choose?
Choose the customer destination province or the place-of-supply province used for checkout tax. That usually drives the rate charged on the order.
3. What is the difference between zero-rated and exempt?
Both return zero tax in this calculator. Zero-rated items are taxable at 0%, while exempt items are outside normal taxable treatment for charging tax.
4. Can I reverse-calculate from a tax-included price?
Yes. Choose the inclusive mode. The calculator backs tax out of the entered amount and returns the estimated pre-tax base, tax split, and final total.
5. Should shipping be taxed?
Often yes, but not always. Use the shipping checkbox to match your actual invoice rule, marketplace logic, or product-specific treatment.
6. Why are Quebec numbers split differently?
Quebec commonly shows GST and QST as separate components. This calculator keeps them separated for reporting clarity and quick verification.
7. Can I change the preset rates?
Yes. Federal and provincial inputs are editable. That helps when you audit historic orders, test future scenarios, or validate marketplace imports.
8. What do the CSV and PDF exports include?
Exports include province, pricing mode, taxable base, tax rates, tax amounts, and grand total. They are designed for fast sharing and recordkeeping.