Simple to use Bookkeeping Spreadsheet for Etsy Sellers based in UK who are NOT vat registered.
➤ Copy in your Etsy Payments CSV and Order File.
➤ 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
The easy way to deal with bookkeeping for your Etsy Store
✱ Updated October 2023 to include Share and Save Refunds ✱
To see a full video preview of the template, go to
➤ https://youtu.be/bzEOpe3-VXw
PLUS Full video tutorials on setting up & using your file
➤ https://bit.ly/etsy-template-tutorials
Are you struggling to find the RIGHT numbers on Etsy for your bookkeeping?
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 slotted into exactly the right places in your reports.
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 UK
✱ Are not VAT registered
✱ Have their system set up in English
✱ Use Microsoft Excel (2010 or later) or Google Sheets
➤ Alternative versions are listed for Sellers in USA, Canada & Australia and for UK Sellers who are VAT registered.
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
➤ Add your own Income & Expense Categories to match your business
➤ Tax Year Summary for Current and Previous Year - whatever date your tax year starts
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 and Order Files each month and add to the template
➤ Includes a simple format to add all your other Sales and Costs
✓ Input your transactions by date and tag to your chosen category
➤ Instantly see all your income and expenses grouped by month and type
✓ no manual input required.
Includes Bonus Reports
✱ Annual Summary for Current and Previous Year with flexible start dates
✓ Perfect for UK tax years starting 6th April
✱ Sales Location Report to see which countries you’ve sold to
✱ 4 Additional In-built Charts
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
PLUS GET ACCESS TO:
✱ Free updates if the data feeding your template changes
✱ Hint and Tips to help you make sense of your business numbers
✱ Be the first to hear about new products and templates
WHAT'S INCLUDED IN YOUR PURCHASE
➤ Excel File containing your Spreadsheet Template
➤ Step-by-Step Detailed Illustrated Instructions to walk you through setting up and using your file
➤ Google File Link included in your instructions
➤ Troubleshooting Guide to help with any tricky areas
REMEMBER THAT YOU WILL NEED ACCESS TO MICROSOFT EXCEL (2010 or Later) ) or GOOGLE SHEETS TO USE THIS TEMPLATE
OTHER TEMPLATES AVAILABLE
If you are a UK VAT Registered Seller > this version will calculate the VAT included in your sales and pull it into a separate report
➤ https://www.etsy.com/uk/MadeontheCommon/listing/846519582/etsy-automated-bookkeeping-for-uk-vat
Alternative versions also available if you are an Etsy Seller based in USA, Canada or Australia
If you sell on multiple sales platforms check out my options for Sellers on Shopify, Amazon, Ebay and Squarespace
➤ https://www.etsy.com/uk/MadeontheCommon/listing/1062485162/
Or check out my other templates designed to help 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
All designs and products are copyright Made on the Common and for personal use only. I am happy for you to give as a one-time gift but please do not resell or include in any other commercial products.
I'm sorry but I'm not able to accept returns on my products as I have no way of knowing whether your item has been used or not.
Thank you for stopping by Made on the Common - see the full product range here
➤ https://www.etsy.com/shop/madeonthecommon/
Sarah x