Simple to use Bookkeeping Spreadsheet for Tax Registered Etsy Sellers based in Canada
Calculate the GST / HST and local Province Tax included in your sales
The easy way to deal with bookkeeping for your Etsy Store
✱ Updated in October 2023 to include Share and Save Refunds ✱
➤ Copy in your Etsy Payments CSV, Order File and Order Items.
➤ See a monthly breakdown of your Sales and Fees
➤ Add any other income and expenses
✱ Know exactly how much money you’ve made in your business
✱ See your Sale Tax by Province split between Etsy retained tax, Etsy calculated tax paid to you and manually calculated tax included in your sales.
✱ Pull out the tax paid on your Etsy fees and Other Expenses to claim back against your sales tax
NOTE: This template is suitable for Tax Registered Sellers in Canada and can be used for all sales before and after July 2022. It includes a full breakdown of your Sales and tax by Province split between.
✱ Tax calculated by Etsy and paid to you (pre July 2022) & Province tax calculated by Etsy and retained by them (from July 2022)
✱ PLUS Automated calculation of tax included in your sales figures (using details of the item sold and location sold to. from July 2022
A separate listing is available for non-tax registered sellers (see below)
To see a full video preview of this template, go to
➤ https://youtu.be/2C4UiztDeuY
PLUS Full video tutorials on setting up & using your file
➤ https://bit.ly/etsy-template-tutorials
Following the recent changes made by Etsy, are you struggling to work out the tax numbers that you need to extract from your Sales figures?
Imagine the time you could save by simply downloading your Payments and Orders from Etsy, pasting them into a ready to use template & having the right numbers calculated automatically and pulled out into a simple tax summary that shows your sales and taxes by Province?
You'd know you had all the numbers you needed to check on your shop's performance and could breathe a sigh of relief at tax time.
➤ So why not let this easy to use Spreadsheet provide you with exactly what you need?
THIS LISTING
Is for Etsy Sellers who
✱ Are based in Canada
✱ Are Tax Registered for GST/HST and /or QST
✱ Have their Payment Account and Order file in the SAME Currency (e,g, CAD)
✱ Have their system and Etsy Payment Statement set up in English
✱ Use Microsoft Excel (2010 or later) or Google Sheets
➤ See alternative versions below for non-tax registered Canadian sellers, sellers on multi platforms and those based in other countries.
KEY FEATURES
➤ Instant Download - you can start using your file today
➤ Use for multiple years so buy once and use forever
➤ Flexible Dates - just choose the Months you want to see in your Reports
➤ Exclude non taxable products from your tax calculations
➤ Add your own Income & Expense Categories to cover your whole business
➤ Track Sales and Taxes by Canadian Province and US State
➤ Sales Maps of Sales and Orders for Canada and USA
SCARED OF SPREADSHEETS?
➤ I've got you covered with a Full Support Package
✓ Detailed Step-by-Step illustrated instructions
✓ Video tutorials to walk you through setting up & using your file PLUS extra links to troubleshooting videos
✓ Email Help - if you get stuck just email me and I’ll help you fix any problems - you can even send me your file!
✓ PLUS Free Updates - if Etsy change their data you can have an updated file for free
HOW IT WORKS
➤ Simply download your Etsy Payments, Order and OrderItems Files each month and add to the template
➤ Canadian tax automatically calculated for each sale using details of the item sold and location sold to
➤ Input your non Etsy sales and costs by date and tag to your chosen category
➤ Instantly see all your income, expenses and taxes grouped by month and type
✓ no manual input required.
Includes Bonus Reports
✱ Annual Summary for Current and Previous Year with flexible start dates
✱ Sales Map of Sales and Orders for USA and Canada
✱ 4 Additional In-built Charts
➤ Note: Canada Map doesn’t display in Google Sheets
THIS IS A DIGITAL PRODUCT FOR YOU TO USE - NO PHYSICAL PRODUCT WILL BE SHIPPED
WANT TO SAVE 10%?
Sign up to my email list and you’ll get a discount code to save 10% off your first order.
➤ https://www.madeonthecommon.com/motc-discount
WHAT'S INCLUDED IN YOUR PURCHASE
➤ Excel File containing your Spreadsheet Template
➤ PDF Step-by-Step, Illustrated Instructions with links to tutorial videos
✱ Google File Link included in your instructions
➤ PDF Guide including video tutorials to help troubleshoot your file
REMEMBER THAT YOU WILL NEED ACCESS TO MICROSOFT EXCEL (2010 or Later) or GOOGLE SHEETS TO USE THIS TEMPLATE
LAST UPDATED - October 2023
Reflects changes made by Etsy to how Canadian tax is handled
The template can be used for multiple years and works for all months from October 2018 onwards.
Pulls out tax charged by Etsy on your fees to reclaim against your Sales Tax
OTHER TEMPLATES AVAILABLE
If you’re in Canada, tax registered and paid in CAD but list your products in USD:
➤ https://www.etsy.com/MadeontheCommon/listing/1267883046
If you’re in Canada and NOT tax registered
➤ https://www.etsy.com/MadeontheCommon/listing/948894786
Alternative versions also available if you are an Etsy Seller based in USA, UK, Ireland, or Australia
If you sell on multiple sales platforms check out my templates for Sellers on Shopify,
(Amazon and Ebay coming soon)
➤ Etsy & Shopify: https://www.etsy.com/uk/MadeontheCommon/listing/1120208853/
➤ Shopify Only: https://www.etsy.com/uk/MadeontheCommon/listing/1204518771/
Plus check out my other templates to help run your small business - including Pricing Worksheets, Password Managers and Invoicing
➤ bit.ly/motcBusinessTools
All Templates are created by me, a qualified accountant with over 20 years of spreadsheet experience, to give you the Simple and Effective Tools you need to succeed in your business
HOW DO I GET MY TEMPLATE?
➤ Check out the FAQ section for full details
FINALLY
I want you to be happy with your purchase, so please message or email me if you need any help.
I'm sorry but I'm not able to accept returns on my products as I have no way of knowing whether you are still using your template or not, but please contact me if you are having any difficulties using your spreadsheet.
All designs and products are copyright Made on the Common and are for use with your own business only.
No resale or inclusion in other commercial products is allowed.
Thank you for stopping by Made on the Common - see the full product range here
➤ https://www.etsy.com/shop/madeonthecommon/
Sarah x