SteadyScrape Tax Functions adds Canadian sales tax (GST, HST, PST, QST) and Costa Rica IVA formulas to Google Sheets™. Follow these steps to get a working example in under a minute. Français plus bas.
=CA_SALES_TAX(A5, B5, C5). Type =CA_, =CR_ or =TAX_ to see every function in the formula suggestions. Depending on your spreadsheet locale, separate arguments with commas or semicolons.=TAX_HELP() in an empty cell for the list of functions.To use the formulas in another spreadsheet, open it and click any item under Extensions → SteadyScrape Tax Functions once. This turns the add-on on in that file.
The formulas don't need a special layout: they read the cells you pass to them. The example sheet uses this layout, one row per sale:
| Column | What to put there | Required? |
| A: Amount | Price before tax, a number (for example 100 or 59.99) | Yes (a blank amount gives a blank result) |
| B: Province / Code | Canada: a province or territory code (AB, BC, MB, NB, NL, NS, NT, NU, ON, PE, QC, SK, YT) or its name in English or French. Costa Rica: an IVA code (GENERAL, R4, R4_INTL_AIR, R2, R1, R0_5) | Yes for Canada; optional for Costa Rica (default GENERAL, 13%) |
| C: Date | The sale date, to use the rate in force on that day (Canada from 2013-04-01) | No (default: today) |
| G: Tax-included total | A total that already includes tax, for the reverse calculation | Only for CA_NET_FROM_GROSS / CR_NET_FROM_GROSS |
Each argument can be a single cell or a range of the same size, for example =CA_SALES_TAX(A2:A500, B2:B500, C2:C500) fills a whole column.
| Formula | Needs | Returns | Example |
=CA_SALES_TAX(amount, province, [date]) | Amount, Province | Total sales tax (GST/HST + PST or QST) | =CA_SALES_TAX(100, "QC") → 14.98 |
=CA_GROSS(amount, province, [date]) | Amount, Province | Tax-included total | =CA_GROSS(100, "ON") → 113 |
=CA_NET_FROM_GROSS(gross, province, [date]) | Tax-included total, Province | Amount before tax | =CA_NET_FROM_GROSS(112, "BC") → 100 |
=CA_TAX_RATE(province, [date]) | Province | Combined rate (format the cell as %) | =CA_TAX_RATE("NS", "2025-03-31") → 15% |
=CA_GST_HST(amount, province, [date]) | Amount, Province | GST or HST only | =CA_GST_HST(100, "BC") → 5 |
=CA_PST(amount, province, [date]) | Amount, Province | PST or QST only (0 where there is none) | =CA_PST(100, "BC") → 7 |
=QST(amount, [date]) | Amount | Quebec QST (9.975%) | =QST(100) → 9.98 |
=CR_IVA(amount, [code], [date]) | Amount (IVA code optional) | Costa Rica IVA | =CR_IVA(100000, "R4") → 4,000 |
=CR_NET_FROM_GROSS(gross, [code], [date]) | Tax-included total (IVA code optional) | Amount without IVA | =CR_NET_FROM_GROSS(113000) → 100,000 |
=TAX_BREAKDOWN(amount, province, [date], ["fr"]) | Amount, Province; leave 6 columns free to the right and a few rows below | Table: each tax, rate, amount, dates and official source | =TAX_BREAKDOWN(100, "QC") |
=TAX_SOURCE(province or "CR:code", [date]) | Province or IVA code | Official source URL | =TAX_SOURCE("CR:R2") |
=TAX_DISCLAIMER(["fr"]) | Nothing | Disclaimer and rate-table version | =TAX_DISCLAIMER() |
=TAX_HELP(["fr"]) | Nothing; leave 2 columns free | The list of functions in your sheet | =TAX_HELP() |
If a formula shows #ERROR!, hover over the cell to read the message (in English and French), for example an unknown province code or a date before 2013-04-01.
Rate lookup and arithmetic only, not tax advice. You choose the province or IVA rate code; the add-on does not decide whether a sale is taxable, where it is supplied, or whether an exemption or special rate applies. Each rate is dated and linked to its official source. Verify with the CRA, Revenu Québec, your provincial ministry or Costa Rica's Ministerio de Hacienda before filing.
Email hello@steadyscrape.dev. Please describe the problem and the formula; don't send customer data or your spreadsheet. More: add-on overview · privacy policy · terms.
=CA_SALES_TAX(A5; B5; C5). Selon vos paramètres régionaux, le séparateur est la virgule ou le point-virgule.=TAX_HELP("fr").Colonnes nécessaires : montant (obligatoire), province ou code d'IVA (obligatoire pour le Canada; IVA par défaut : GENERAL 13 %), date (facultative, aujourd'hui par défaut), total taxes incluses (seulement pour CA_NET_FROM_GROSS et CR_NET_FROM_GROSS).
Avis : consultation de taux et calcul seulement, et non un avis fiscal. Vérifiez auprès de l'ARC, de Revenu Québec, de votre ministère provincial ou du Ministerio de Hacienda avant de produire une déclaration.
Soutien : hello@steadyscrape.dev, en français ou en anglais.
Google Sheets™ and Google Workspace™ are trademarks of Google LLC. Google Sheets™ et Google Workspace™ sont des marques de commerce de Google LLC.
SteadyScrape · 91 - 1554 Carling Avenue, Ottawa, ON K1Z 7M4, Canada · hello@steadyscrape.dev