Last Updated on July 17, 2024 by Kathy Booth
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
- 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
- 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
- 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