Pricing Calculator shop management Tool Etsy Sellers handmade product, cost of goods sold, COGS, worksheet spreadsheet excel file
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 :)
ABOUT THE SPREADSHEET
- 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: https://www.youtube.com/watch?v=JlPyn4TOLFk
Market comparison pricing spreadsheet also available here: https://etsy.me/2OWqCRK
This listing is for the light blue version
>>> 10 colors available <<<
- Light blue https://etsy.me/2OdGMG8
- Pink https://etsy.me/2yFubYl
- Purple https://etsy.me/2VC5IMw
- Green https://etsy.me/2S5SLso
- Mint https://etsy.me/2yFud2p
- Black https://etsy.me/355Pn5X
- Orange (contact me)
- Red (contact me)
- Dark Blue (contact me)
WHO THIS SPREADSHEET IS FOR:
- 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.
YOU MAY ALSO BE INTERESTED IN:
- 54 Mistakes Etsy Sellers Make eBook: http://etsy.me/2cJIAUW
- Order form template in chevron pattern http://etsy.me/2cxqmpE or polka dot: http://etsy.me/2cAWXtH
- Catalogue template: http://etsy.me/2cqCUls
- Shop Inventory spreadsheets: http://etsy.me/2cuEymn
- Pricing spreadsheet template to work out how much you should be charging: http://etsy.me/2ckuP0l
- How to write product descriptions mini ecourse http://etsy.me/2cikK0n
- Blog planner: http://etsy.me/1jxJyEX
- Business planner (no chevrons) http://etsy.me/2cMjHKw
- Business planner (with chevrons) http://etsy.me/1MykCc4
- Finance binder (no chevrons) http://etsy.me/2ccRMRd
- Budget binder EDITABLE http://etsy.me/1NbYBhS
- Get it all printable planners: http://etsy.me/2cJWKVi
- Tax planner (EDITABLE) http://etsy.me/1OoEykU
- Direct Sales Planner (EDITABLE) http://etsy.me/1RacUE8
- How to make labels in Photoshop ecourse (can be used to make product labels, address labels or any type of label for your business) http://etsy.me/2ci3xV6
- GET IT ALL Ultimate Etsypreneur Success Bundle (ebook, ecourse, spreadsheets & planners!) http://etsy.me/2cqEgrf
- Etsy shop critique: http://etsy.me/2cqE7tm
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.
>>>> 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: https://www.google.com/sheets/about/
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.
DOWNLOADING THE FILES
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.
*** CUSTOMER REVIEWS ***
'Great product, cannot wait to use it. Great communication with the shop owner. Highly recommend.'
'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 https://www.etsy.com/au/shop/AllAboutPlannersShop
>>> Subscribe to the blog to access the free printables library!
YouTube Channel: https://www.youtube.com/channel/UCS-BDJTp4HVRbPoApDcl59w
Graphic Design Resources Shop: https://www.etsy.com/au/shop/PaperCravings
Online store: https://www.allaboutplannersshop.com.au/
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.
2,513 reviews5 out of 5 stars
Shop has made 43 sales to buyers in Australia in the past 30 days.
Really beautiful wallet, much nicer and more personal than the ‘designer’ one I was going to purchase. Arrived quickly and well packaged. Thank you 😊
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.
Excellent spreadsheet, thank you so much. Would have taken me hours. You’ve thought of everything too. 😃
Photos from reviews
BLACK Craft, Hobby, DIY Printables - Chevron Printable-Organisation-Household Binder - 22 sheets - Binder Cover and Spine- PDF
GREY EDITABLE Teacher Planner Printable School Homeschool Lesson Planner Class Organization 2020 2021 Teaching Homework Calendar Diary
EDITABLE PURPLE Printable Party Planner 14 sheets PDF Chevron Party Printables Household Binder Guest List, Party Budget To Do List Schedule
Spending Stickers Weekly Expenses Planner Stickers Printable Stickers Full Box or Sidebar made for Erin Condren, Plum Paper Limelife etc.
Bill Printable Editable Rainbow Stripe Paid Bills Checklist Finance Printable - PDF - Household Binder - Money Management - Finance Set