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

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



In stock

GST Included
Oi! You can't buy your own item.

  • Digital download
  • Digital file type(s): 1 PDF

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 Docs)
- 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 Docs. Basic excel skills are required. If you convo me requesting assistance I unfortunately will not be able to answer due to time constraints. There are NO REFUNDS under any circumstances, including if you do not have basic excel skills.

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.

I don't accept returns, exchanges or cancellations. But please contact me if you have any problems with your order.



Owner of AllAboutPlannersShop

Message Rachael

This seller usually responds within 24 hours.

2,147 reviews 4.5 out of 5 stars


Luis Valentin 05 Sep, 2019

Leggenda Blackbourn 15 Apr, 2019

5 out of 5 stars

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

Purchased item:

Sirpa Mastall 17 May, 2019

5 out of 5 stars

Super useful and clean , well made setup 👍👌👍

Purchased item:

Explore related categories & searches