Pricing Calculator shop management Tool Etsy Sellers handmade product, cost of goods sold, COGS, worksheet spreadsheet excel file


GST Included

  • Digital download
  • Digital file type(s): 2 PDF, 1 other file

Not sure how much to charge for your goods? Feel like you're not making much profit? Don't even know how much profit you're making? This pricing calculator will help solve your pricing dilemma' and make sure you're charging enough to make a profit :)

- Instant download - start using it straight away!
- Excel file (can also be used in Google Sheets)
- Enter your material, labor and packaging costs
- Enter the time it takes to take photos and write the product description
- Enter the hourly rate you want to pay yourself
- Spreadsheet will automatically calculate the retail and wholesale price (including taking into account Etsy fees, payment processing fees and sales tax).

- Automatically calculates the retail and wholesale price (and you can change the suggested % markup if you like!)
- You can change the tax rate for your country or state
- There's also a section to calculate the price for custom orders based on what changes they want to make
- There's a section to add an SKU for the product (or you can duplicate the spreadsheet and use one tab for each product type in your shop. E.g. if you sold jewellery you could have separate tabs for bracelets, necklaces etc. )
- Space to type notes
- Space to add a product photo

Spreadsheet can also be printed if you prefer to write by hand or do calculations manually.

>>> Video tutorial/walkthrough of how to use the spreadsheets on my YouTube channel:

Market comparison pricing spreadsheet also available here:

This listing is for the light blue version

>>> 10 colors available <<<

- Light blue
- Pink
- Purple
- Green
- Mint
- Black
- Orange (contact me)
- Red (contact me)
- Dark Blue (contact me)
- If you need to know how much to charge so that you're actually turning a profit
- If you're thinking about offering a new product (or an entire product line) and aren't sure whether it's going to be feasible
- If you want to know how much you are paying yourself per hour (and what hourly rate you need to pay yourself to turn a profit)
- If you want to sell wholesale or to retailers

Can be used if you're an Etsy seller or if you have an online business outside of Etsy.
- Simple clean, ink friendly design
- Formulas automatically calculate
- Tips and examples to help guide you/recommended use (hover your mouse over the circles with the red triangle to see the suggested instructions/tips on what to enter where)

- Can be used by a new or seasoned Etsy shop owner, and/or if you have an online shop and create and sell physical products, digital products and/or services.

Files will be available for INSTANT DOWNLOAD after payment has cleared - please check your Etsy registered email address for the link to the download page.
- 54 Mistakes Etsy Sellers Make eBook:
- Order form template in chevron pattern or polka dot:
- Catalogue template:
- Shop Inventory spreadsheets:
- Pricing spreadsheet template to work out how much you should be charging:
- How to write product descriptions mini ecourse
- Blog planner:
- Business planner (no chevrons)
- Business planner (with chevrons)
- Finance binder (no chevrons)
- Budget binder EDITABLE
- Get it all printable planners:
- Tax planner (EDITABLE)
- Direct Sales Planner (EDITABLE)
- How to make labels in Photoshop ecourse (can be used to make product labels, address labels or any type of label for your business)

- GET IT ALL Ultimate Etsypreneur Success Bundle (ebook, ecourse, spreadsheets & planners!)
- Etsy shop critique:

I am unfortunately unable to provide after sales advice/troubleshooting on how to use Microsoft Excel or Google Sheets. Basic excel skills are required.

I accept no responsibility for errors that may be made in this spreadsheet. I am not accountant – I have created these spreadsheets based on my years of experience running an Etsy shop and online business. You are responsible for ensuring values (such as PayPal fees and tax rates relevant to your country) and formulas are correct - I recommend that you carefully check you have entered the correct vales and have not over-ridden formulas prior to using the information for taxes and financial reporting, and consultant an accountant if required.

These templates are strictly for YOUR BUSINESS USE ONLY. They are © All About Planners – you may not modify, reproduce or alter the templates, share with others or sell in original and/or modified format. I will not hesitate to proceed with legal action for violation of these terms of use.

By purchasing you accept and agree to the above terms of use.

>>>> Software requirements

- These spreadsheets were made in Excel 2016
- They should also work with earlier and later versions of Excel although I cannot guarantee this
- They should also work with earlier version of Excel although I cannot guarantee this
- They will work in numbers on a MAC
- They will work in Google Sheet which is free online:

I am not responsible if you are using a different software program and the files do not work. There are no refunds if these files will not work with your PC/laptop, or if you do not have basic excel skills and have problems formatting and/or using the spreadsheets.

The spreadsheets are intending for using on your computer or laptop (digital files to be used digitally), but if you wish to print the spreadsheet and file paper copies at the end of the year, this spreadsheet can be printed.

Most instant download items (and all sets) come in zipped folders. Please ensure your computer can open zipped folders.

The watermarks will NOT appear on your copy.

Colours may vary depending on your monitor and printer.

There are no refunds on digital items.
Please note that this is a digital product and no physical product will be sent.

Files will be available for INSTANT DOWNLOAD after payment has cleared - please check your Etsy registered email address for an automatic email containing the link to the download page. If you have changed email addresses or cannot locate the email which may go to your spam/junk folder, instructions for accessing the download page are included in the 'notes from seller' on your order receipt.


'Great product, cannot wait to use it. Great communication with the shop owner. Highly recommend.'

'5 Stars!'

'Super useful and clean , well made setup 👍👌👍'

'thank you for a great product!'

'Useful tool! Happy with it'

'Excellent. Helped me very much'

'Thank you for making my life easy! <3'

'Excellent spreadsheet. It is very helpful in keeping my business organised.'

'A must have for any shop'

'Absolutely love knowing my pricing is spot on, and I'm not leaving my numbers to an educated guess.'


All sheets are (c) All About Planners


>>> Subscribe to the blog to access the free printables library!

YouTube Channel:
Graphic Design Resources Shop:
Online store:

Instant Download

Your files will be available to download once payment is confirmed. Here's how.

Instant download items don’t accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.

Etsy Purchase Protection: Shop confidently on Etsy knowing if something goes wrong with an order, we've got your back for all eligible purchases — see programme terms



Owner of AllAboutPlannersShop

Message Rachael

This seller usually responds within 24 hours.

2,513 reviews

5 out of 5 stars
Actively selling in Australia

Shop has made 43 sales to buyers in Australia in the past 30 days.

5 out of 5 stars

Really beautiful wallet, much nicer and more personal than the ‘designer’ one I was going to purchase. Arrived quickly and well packaged. Thank you 😊

Susie 04 Dec, 2018

5 out of 5 stars

Works beautifully!!

Luis Valentin 05 Sep, 2019

5 out of 5 stars

Good spreadsheet for someone that produces their own sale items. My hubby (spreadsheet wiz) made some changes for me, as we deal with a manufacturer(s). So my costing is more about design, shipping, packaging, couriers, and labeling, rather than labour hours. He also added a margin calculator and a currency calculator, as we deal with different currencies. So good spreadsheet if you produce your own goods, probs not for people that are importing/producing elsewhere and dealing with exchange rates etc.

Voni de Lussanet 02 May, 2022

5 out of 5 stars

Excellent spreadsheet, thank you so much. Would have taken me hours. You’ve thought of everything too. 😃

Leggenda Blackbourn 15 Apr, 2019

More from this shop

See more

Disclaimer: Etsy assumes no responsibility for the accuracy, labelling, or content of sellers' listings and products. Electrical or electronic products may pose a risk of fire or electrocution. Vintage, handmade, refurbished, or modified electrical or electronic products may not meet current safety standards and may not be in safe working order. Inspect carefully before use and message the seller if you have concerns relating to the product. Do not use a vintage electrical or electronic item if its safety can't be verified. To reduce the risk of fire, never leave vintage electrical or electronic products plugged in unattended. See Etsy's Terms of Use for more information.

Explore more related searches