When I was wrapping up my taxes a little while back, I had mentioned in my Instagram stories that I keep an inventory of all of my yarn, and keep it updated throughout the year. This has proven invaluable to me, not only when it comes time to do my taxes, but also when planning projects and yarn shopping!
Here I’ll show you how to get started with my inventory tracker, and provide you with the free download!
Getting started with inventory tracking can be quite the endeavor, but SO worthwhile. I am not exaggerating when I tell you that it took me several days to get everything entered when I started this several years ago, but it is really easy to maintain and has made my yarn stash a lot easier to manage.
When you first download the inventory tracker, it will be relatively blank. You’ll notice that a few columns are automatically calculated, so be sure that you don’t enter anything into those.
Adding Your Stash
When you have a full skein of yarn, this part is pretty straightforward. You’ll start by filling in all the details in the About section, which is pretty easy. The next section, Purchase, isn’t really necessary in terms of inventory, but something that I really like to have. I like to know how much the yarn cost exactly whenever I am working out pricing for my finished items. Notice that if you got your yarn on sale, or used a coupon to otherwise receive a discount, you can enter a Purchase Price that may be different than your Regular Price.
If the cost of your yarn and purchase details isn’t important to you, feel free to skip over those few columns.
One of my favorite things about this inventory tracker is the Weight section. This is where you’ll be able to see exactly how much of a specific yarn that you have. In this first example, let’s say that I have 2 full skeins of Brava Worsted in Cornflower. Brava has 218 yds per 100 g skein, so I’ll include that in Weight. Because the skeins are full, I’ll skip over the Remaining Weight section.
Lastly, you’ll enter your stock, which is just that: how many skeins you have of this exact yarn in stock. This will then automatically update the Total Cost column, if you chose to use the Purchase section.
Next we’ll work on those skeins that have already been used a bit. I’ll start off by noting that any partial skeins will need to have their own line. So if I wanted to add a third skein of Brava in cornflower (the same as the 2 skeins above), but it was a partial skein, it would still need to have it’s own line.
In this scenario, let’s say I have 1 skein of Brava in the color Blush, but I only have 30g left. I’ll enter everything as explained above for a full skein; however, in remaining weight, I’ll put the grams remaining in the skein.
Notice that when you enter the remaining grams, your remaining yardage will be updated as well.
This is one of the most helpful features of keeping an inventory in my opinion. Now I can easily see if I have enough yarn left for a specific project, or if I need to get more.
If you’ve never heard of calculating remaining yardage in a partial skein, let me give you a little crash course! The only thing that you’ll need for this is a kitchen scale! I got one on Amazon, which you can find here. You can absolute calculate yardage based on ounces, but I find grams to be a bit more accurate, and most yarns have that weight listed on the label already.
Make sure that you remove your yarn’s label before weighing it. Once you have the current gram weight, there’s just a bit of math to figure out the yardage.
Full Skein Grams: 100 / Full Skein Yardage: 218
Remaining Skein Grams: 30
[REMAINING GRAMS] x [FULL YARDAGE / FULL GRAMS]
30 x (218/100)
30 x 2.18
Of course, if you use the inventory tracker, there is no algebra required!
When you have used up the last of a skein of yarn, it’s up to you how to handle that in your inventory. You could change your stock to 0, or you could delete the row entirely. I personally delete the row, unless it is a yarn that I use often and will be replenishing.
Get the Freebie!
There you have it! I hope that this inventory tracker is helpful to you and we can all be on our way to a well managed yarn stash!
Download your Yarn Inventory Tracker for free by signing up to my newsletter below!
Get the Freebie!
Sign me up to the newsletter and give me the download for the Yarn Inventory Tracker spreadsheet!
Note: This excel spreadsheet has formulas in it in order for it to complete the automatic calculations. If you would accidentally delete a formula and it can’t be undone, no big deal! Just come back over to the blog and download a fresh copy!
You might enjoy my post on pricing your crochet makes, with a free download for a Crochet Profit Calculator. You can find the post here.
If you’ve enjoyed this freebie, please consider purchasing from one of my online shops, or shopping with my affiliate links. I so appreciate your support! All the details can be found here:
If you would like to see more from me, be sure to join my Facebook group!
If you’ve enjoyed this post, be sure to subscribe to my email newsletter so that you never miss a pattern release, and have subscriber only access to exclusive discount codes, offers, and freebies!
Thanks for stopping by! Happy crafting!
PATTERN COPYRIGHT © 2023 NICOLE CHASE. ALL RIGHTS RESERVED.
PATTERN MAY NOT BE ALTERED, COPIED, REDISTRIBUTED OR SOLD AS YOUR OWN PATTERN.
YOU MAY SELL THE FINISHED PRODUCT ON A SMALL SCALE. PATTERN/DESIGN CREDIT GIVEN TO WWW.THENICOLECHASE.COM IS APPRECIATED. PERMISSION TO SELL DOES NOT INCLUDE MASS PRODUCTION. LARGE SCALE PRODUCTION IS PROHIBITED.
PHOTOGRAPHY COPYRIGHT © 2023 NICOLE CHASE. ALL RIGHTS RESERVED.
PHOTOS MAY NOT BE ALTERED, COPIED, REDISTRIBUTED OR SOLD AS YOUR OWN.