How to use SteadyScrape Tax Functions

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.

Get started

  1. Install the add-on. Open the Google Workspace™ Marketplace, search for SteadyScrape Tax Functions and click Install. You can also install it from a spreadsheet: Extensions → Add-ons → Get add-ons.
  2. Open a spreadsheet. Open an existing spreadsheet or create a new one in Google Sheets™ (sheets.new).
  3. Create the example sheet. Click Extensions → SteadyScrape Tax Functions → Create example sheet / Créer une feuille exemple. The first time, Google asks you to authorize the add-on: it needs permission to "View and manage spreadsheets that this application has been installed in", which it uses only to add the example tab. A new tab named Tax example / Exemple opens, with headers, example rows and working formulas.
  4. Type your own values. In the example tab, replace the amounts in column A, the province codes in column B and, if you want a past rate, the dates in column C. Columns D to H recalculate.
  5. Type formulas anywhere. In any cell, type a formula such as =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.
  6. Get help in the sheet. Click Extensions → SteadyScrape Tax Functions → How to use / Mode d'emploi, or type =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.

How to set up your sheet

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:

ColumnWhat to put thereRequired?
A: AmountPrice before tax, a number (for example 100 or 59.99)Yes (a blank amount gives a blank result)
B: Province / CodeCanada: 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: DateThe sale date, to use the rate in force on that day (Canada from 2013-04-01)No (default: today)
G: Tax-included totalA total that already includes tax, for the reverse calculationOnly 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.

Formulas and the columns they need

FormulaNeedsReturnsExample
=CA_SALES_TAX(amount, province, [date])Amount, ProvinceTotal sales tax (GST/HST + PST or QST)=CA_SALES_TAX(100, "QC") → 14.98
=CA_GROSS(amount, province, [date])Amount, ProvinceTax-included total=CA_GROSS(100, "ON") → 113
=CA_NET_FROM_GROSS(gross, province, [date])Tax-included total, ProvinceAmount before tax=CA_NET_FROM_GROSS(112, "BC") → 100
=CA_TAX_RATE(province, [date])ProvinceCombined rate (format the cell as %)=CA_TAX_RATE("NS", "2025-03-31") → 15%
=CA_GST_HST(amount, province, [date])Amount, ProvinceGST or HST only=CA_GST_HST(100, "BC") → 5
=CA_PST(amount, province, [date])Amount, ProvincePST or QST only (0 where there is none)=CA_PST(100, "BC") → 7
=QST(amount, [date])AmountQuebec 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 belowTable: each tax, rate, amount, dates and official source=TAX_BREAKDOWN(100, "QC")
=TAX_SOURCE(province or "CR:code", [date])Province or IVA codeOfficial source URL=TAX_SOURCE("CR:R2")
=TAX_DISCLAIMER(["fr"])NothingDisclaimer and rate-table version=TAX_DISCLAIMER()
=TAX_HELP(["fr"])Nothing; leave 2 columns freeThe 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.

Disclaimer

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.

Support

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.

Mode d'emploi : SteadyScrape Tax Functions

  1. Installez le module depuis Google Workspace™ Marketplace (recherchez SteadyScrape Tax Functions, puis Installer), ou depuis une feuille : Extensions → Modules complémentaires → Télécharger des modules complémentaires.
  2. Ouvrez une feuille Google Sheets™, existante ou nouvelle.
  3. Créez la feuille exemple : Extensions → SteadyScrape Tax Functions → Create example sheet / Créer une feuille exemple. La première fois, Google demande d'autoriser le module à « voir et gérer les feuilles de calcul dans lesquelles cette application est installée »; il s'en sert seulement pour ajouter l'onglet exemple. Un onglet Tax example / Exemple s'ouvre avec en-têtes, exemples et formules.
  4. Tapez vos valeurs : montants en colonne A, codes de province (QC, ON, « Québec »…) ou d'IVA en colonne B, dates facultatives en colonne C. Les colonnes D à H se recalculent.
  5. Tapez des formules, par exemple =CA_SALES_TAX(A5; B5; C5). Selon vos paramètres régionaux, le séparateur est la virgule ou le point-virgule.
  6. Aide dans la feuille : Extensions → SteadyScrape Tax Functions → How to use / Mode d'emploi, ou =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