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


GST Included

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

These 13 Excel spreadsheets are designed to streamline your shop's inventory management, keep track of when supplies are running low and how listings are performing (so you know which products to focus on). Also included are product list templates which you can send to wholesale customers if you want to sell to retailers.

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.

- Cost of Goods Sold (COGS)
- Pricing Worksheet
- Competitive Pricing (Market Analysis)
- Inventory
- Inventory (with photos)
- Product Analysis
- Wholesale Products List
- Product List
- Product List (with space to add photos)
- Service List
- Product Restocks
- To Order List
- Renewed Listings

Only 5 of the 13 spreadsheets are shown in the photos! Use all spreadsheets or only those that you need! All spreadsheets are combined in one Excel workbook (with each spreadsheet in a separate tab) for convenience.
Visit my blog for a video walkthrough of how these spreadsheets work:
- Calculate your cost of goods sold (COGS) - handy when tax time rolls around
- Quickly determine how much to charge for products to ensure you make a profit by entering your desired markup - it will calculate both retail and wholesale prices.
- Track which products are performing well, which are not and which bring in the most profit so you can determine which products you should focus on
- 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
- 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
- Currency can be changed from $ to pounds, Yen or any other currency you like

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

This is intended for keeping track of all your finished, ready to sell products. There is a ‘quick reference’ section where you can note what SKU letters/codes you use for what products.

Using this spreadsheet, you can also note the cost price and retail price (which you can refer to if someone is purchasing multiple and you would like to offer a discount but ensure you’ll still make a profit), as well as the customisation fee you charge, based on e.g. the extra labour required to add an element to a product based on a customer’s request, or additional costs for using a different material etc.

This is the same as the spreadsheet above but with an additional column if you want to add photos. This spreadsheet is best suited to shops that have a lot of products and each product is slightly different. For example, if you sell washi tape, there are an overwhelming amount of patterns, designs and colours!

The filter tools can be used to easily sort your products by category and SKU.

Instructions are included in the download on how you can add your own photos.

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.

If you have a person, company or retailer interested in placing a large order with you and you’re going to offer them wholesale pricing then use this spreadsheet. You can add photos of the product, the category and name (so you can use one spreadsheet for all of your products and they can filter the categories to see only those they are interested in), product names and SKU (product number codes), how much you currently have in stock, the retail price, the wholesale price, minimum order quantity, bulk order quantity and bulk discount rate if applicable.

Use this to track how much your competitors charge for similar products. The spreadsheet will automatically calculate the average price. You can also use it to compare pricing for similar things you order from your wholesalers or suppliers.

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.

If you're interested in a more detailed pricing worksheet, see

You can use this for your products (if you sell a lot of different types of washi tape, for example), but it is intended for your supplies/material (inputs used to make your products).

Same as above but without the column for photos

The spreadsheet is formatted for the initial order and up to 4 restocks (you can add more columns if needed). There is space to record the item, the date the order was placed, the date the order was received (this helps you determine lead times and when you should order to ensure you receive the product/supply before you sell out), as well as a section to record when you have updated your inventory after receiving the shipment, updated your expenses and filed away the receipt for the order so you can stay on top of your book-keeping and are organised when tax time comes around!

Use this to keep a list of all the products you need to order (kind of like a shopping list/wish list). You can filter by supplier so you only see all items that need to be purchased from that supplier/store, then print out for a shopping list, or send to your supplier when placing an order with them.

Keep track of your total profit for each product, based on quantity sold and profit (sale price less your cost price). This will show you which products you should focus more time on.

The spreadsheet will also tell you which products are your top 10% (most popular - the cells will highlight in green) and which are in your bottom 10% (least popular – the cells will highlight in red). It will do this for both the quantity sold column and the profit column. You can use this information to see which products sell well but perhaps have a low profit margin to assist with pricing and determining the right product mix/amounts to stock.

I recommend using this for listings that aren’t selling very well. Keep track of the date listed/renewed, listed price and quantity sold during each of the 4 quarters of a year. The spreadsheet will automatically calculate the total quantity sold for the year and the average price for the year, there is a notes column to record any notes you want e.g. ‘discontinue this product’

The spreadsheet will also tell you which products are your top 10% (most popular - the cells will highlight in green) and which are in your bottom 10% (least popular – the cells will highlight in red) based on the quantity sold (it will tell you for each quarter and for the entire year).

Use this if you sell labour/hourly rates based products. For example, if you sell shop coaching, webinars, run tutorial classes etc.



- Purple:
- Pink:
- Green:
- 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 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.

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

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.
(c) All About Planners


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

YouTube Channel:
Graphic Design Resources Shop:
Online store:



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

'I love just how easy this template is to use. Really helping me to keep track of my Etsy Shop supply inventory. Thanks so much!!!

'I really like this inventory worksheet, it will certainly help me control all of my raw material in my inventory as well as the finished products in my shop.'

'5 Stars!'

'Looking forward to being organized af'

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

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.

Actively selling in Australia

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

2,513 reviews

5 out of 5 stars
5 out of 5 stars

I love just how easy this template is to use. Really helping me to keep track of my Etsy Shop supply inventory. Thanks so much!!!

Red Tipton 14 Oct, 2017

5 out of 5 stars

I really like this inventory worksheet, it will certainly help me control all of my raw material in my inventory as well as the finished products in my shop.

Reviewed by Inactive 26 Jan, 2018

5 out of 5 stars

Excellent customer service, and the spreadsheet is EXACTLY what I needed to organize my shop. Thank you so much! :)

Lindsay Attaway 29 Jul, 2020

5 out of 5 stars

I found this to be very straight forward to use and very well thought out... I love it as an addition to my business. Would highly recommend it to anyone just staring out or anyone that cant find the right online application to use.. This spreadsheet does it all

Tony 26 Jan, 2021

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.