Etsy GST/HST Remittance Calculator

Youtube Video Tutorial: https://www.youtube.com/watch?v=cUmxmKlJ-QU&feature=youtu.be

Change Log and Version Updates

Version 2.2 – July 16 2024

Etsy Canada GST/HST Remittance Calculator 2.2

Excel .zip file download

  • Updated to include Provincial Sales tax table
  • Adjusted to reflect QST collected by seller and separate GST amount also collected
    • Previously assumed Etsy collected and remitted QST like other provincial taxes (Etsy collects and Remits PST for the provinces of BC and SK, and RST for the province of MB
  • Summary table changed to include line totals from my recent GST filing on the CRA website (July 2024)
  • Links added to CRA website for completing GST line items

Version 2.1 – June 17 2024

Etsy Canada GST/HST Remittance Calculator 2.1

Excel .zip file

  • Updated to include total Canadian revenue amount table
  • Added line 101, line 103, summary section

Version 2.0 – June 13 2024

Etsy Canada GST/HST Remittance Calculator 2.0

Excel .zip File

  • Add table to include pre-tax total sales 
  • Add table to include total Canadian revenue
  • Add summary section to include total tax Etsy collects and remits to various authorities – mostly international tax authorities
  • Add summary to show total combined revenue and total foreign revenue
  • Add third Bonus” tab with pivot table showing totals of tax Etsy collected on Canadian sales (Etsy is required to collect and remit PST and RST on behalf of sellers)

Original Files – April 17

Google Sheets: Etsy Canada GST/HST Remittance Calculator

Excel: Etsy Canada GST_HST Remittance Calculator.xlsx

Scroll to Top