Cost of goods sold inventory spreadsheet etsy seller tool shop management retail supplies materials wholesale pricing worksheet excel forms

Product Info

This Excel spreadsheet is designed to streamline the pricing process for your shop! Enter in all of the costs involved in making your product, then transfer to the pricing your product spreadsheet to work out how much you should sell it for.

These 2 spreadsheets are from the inventory spreadsheets bundle which is available here: http://etsy.me/2cuEymn

The file will be available for INSTANT DOWNLOAD after payment has cleared - please check your Etsy registered email address for the link to the download page.
______________________________________

HOW TO USE THE SPREADSHEETS:

1. COST OF GOODS SOLD
Use this spreadsheet to calculate the total product cost (cost of materials) as well as labour, packaging, shipping etc. You can keep track of what employee created what product, which is helpful when working out how much they need to be paid.

Replace 'Material 1' with the type of material used e.g. beads, fabric etc. then type the cost of this material in the column below.

2. PRICING WORKSHEET (MULTIPLE PRODUCTS)
Keep pricing information for all of your products in one convenient place for quick reference. Using this helps you calculate what price to charge by building up a cost based on materials, labour, if there is a customisation fee (e.g. if the customer wanted a different colour), packaging, shipping, wholesale markup, retail markup etc.

The materials, labour, packaging and shipping are automatically linked to the cost of goods sold spreadsheet.

If you're interested in a more detailed pricing worksheet, see http://etsy.me/2ckuP0l
______________________________________

YOU NEED THESE SPREADSHEETS IF
- You want to save time by not having to build spreadsheets from scratch/develop your own system - all the work has been done for you!
- You need to know your cost of goods sold and profit for tax reporting purposes
- If business is picking up or you've been in business for a while and need a system for tracking your inventory
- If you offer different pricing levels e.g. retail and wholesale and need one convenient place to store all this info
- Want to determine which products are unpopular, too time consuming or not profitable enough and which you should discontinue so you can focus on perfecting your hit products
- Need a way to track when you need to re-order inventory
______________________________________

SPREADSHEET FEATURES
- Instant Download
- Simple, clean, non-gender specific design
- Purchase once and these can be re-used again and again each year
- Formulas automatically calculate
- The top row/column titles will not move when you scroll down the excel file, so you don't need to scroll back up to the top of the worksheet, to remember what to enter in each column
- Tips and examples are in the spreadsheets to help guide you/recommended use (hover your mouse over cells that have a red triangle in the corner)
- Also included is an 8 page guide with instructions & tips on how to use Microsoft Excel

- Can be used by new and experience Etsy sellers, and/or if you have an online shop outside of Etsy

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.
______________________________________

UPGRADE to the full Etsy sellers spreadsheet package! Get it here >> http://etsy.me/2cuEymn

Visit my blog for a video walkthrough of how these spreadsheets work:
>>> http://www.allaboutthehouseprintablesblog.com/simple-easy-method-tracking-product-inventory-using-excel-spreadsheets/
______________________________________

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
______________________________________

TERMS OF USE/USER AGREEMENT

I am unfortunately unable to provide after sales advice/troubleshooting on how to use excel, other than the instructions included in your purchase. 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.

These templates are strictly for YOUR BUSINESS USE ONLY. They are © AllAboutTheHouse Printables – 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.
______________________________________
PLEASE READ

>>>> 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.

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.
______________________________________

(c) All About Planners https://www.etsy.com/au/shop/AllAboutPlannersShop

Blog: http://allaboutplanners.com.au/

>>> Subscribe to the blog to access the free printables library!
http://bit.ly/2hdKzpd

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/
______________________________________

***CUSTOMER REVIEWS***

'Absolutely great!!! Thanx a lot. Helps business to run smoothly!'

'5 Stars!'

'Thanks! This is just what I need. Plus a useful no-nonsense how to use you-tube video!'

'Helpful! I made a few tweaks specific for my business and it was easy to do.'