Hi! I like spreadsheets and with Etsy’s fees going up in a few weeks I thought it would be handy to make an Etsy fee calculator so other small businesses can assess how much they’re being ripped off and if it’s a good idea to move to another platform! You can use any kind of spreadsheet software, including google sheets, excel or libreoffice calc.
My calculator looks like this. Column A is where I put the price I want to receive for my product, Column B calculates what the 6.5% fee is from that price, Column C adds Etsy’s 20c listing fee, Column D shows the consumer cost aka what someone would pay for your product, and Column E just shows what Etsy takes from you. This calculator doesn’t include Etsy’s postage fees since I buy my own stamps.
Formulas:
Column A: any dollar amount - how much you want to get for the product
Column B: =A2*0.065 - this calculates the percentage
Column C: =A2+0.2 - adds the 20c listing fee
Column D: =B2+C2 - Adds the percentage and listing fee together
Column E: =B2+0.2 - adds the percentage and 20c fee together
If you haven’t used spreadsheet software a lot, you can highlight and drag cells containing formulas so they continue downwards, so in the original formula where is says “A2″ it will automatically continue to say like “A3″ so you can use this to calculate all your product’s prices.
If you have any further questions let me know, I’ve never made a tutorial like this before and I hope it’s clear and easy to understand!
Discover transparent UK Visa Application Fees on our website. Easily access up-to-date information on visa processing costs for various categories. Plan your visa application budget with confidence using our comprehensive fee breakdown. Simplify your UK visa journey with clarity and certainty.