Yarn Inventory Spreadsheet

Ad Blocker Detected

Our website is made possible by displaying online advertisements to our visitors. Please consider supporting us by disabling your ad blocker.

This article will show you how to keep track of your yarn inventory by using a Yarn Inventory Spreadsheet. This spreadsheet will help you determine which colors, yarns, and kits you are currently using, as well as allowing you to mark other items such as needles and yarn. You can even have a separate table for your temporary supply as well as other supplies like wools and large crystals.

Needle Inventory and other yarn art Journal Templates
872 best Knit images on Pinterest from yarn inventory spreadsheet , source:pinterest.com

Your spreadsheet is going to require a few pieces of information, but the important ones to remember are the name of yarn, color, and kit. The name of yarn will be something that you enter in the small text box, followed by your category, which could be different depending on the purpose of your spreadsheet. For example, if you are preparing a wicker pattern for the birthday of a friend, you would enter “wicker” as your category.

Next up, it is important to enter the amount of yarn you currently have in the text box, followed by your yarn count. In most cases, this is going to be the number of bags or balls you currently have in stock. The next boxes to fill out are the boxes for the colors you want to purchase and the kit(s) you want to purchase.

Supply order form Template Fice Supply order form Template Beautiful Fice Supply Inventory
Supply order form Template from yarn inventory spreadsheet , source:dentistryonline.info

The last step is to make sure you have a tab for each type of yarn you have, whether it is the balls (i.e. Sport, Cashmere, Sportster, etc.) or kit (i.e. Cloche, Rainbow).

Next, the text boxes to fill out are for the items that you already have and the line items that you are going to purchase. These are going to be labeled like yarn and needles, crystals, beads, and other tools.

Internship Report on Hypoid posite Knit Ltd Knitting
Internship Report on Hypoid posite Knit Ltd Knitting from yarn inventory spreadsheet , source:scribd.com

You may have to manually enter some numbers here, but it shouldn’t take too long. Once all the other necessary boxes are filled out, you should end up with a spreadsheet that looks like this:

Keep in mind that you will probably need to adjust the spreadsheet if your yarn inventory fluctuates from time to time. Of course, you will also need to make sure that your spreadsheet is current. Even though you should be able to change it in Excel, you may need to download the spreadsheet for your platform of choice to change the inventory you have in the spreadsheet.

Preschool Weekly Lesson Plan Template Luxury Nursery Weekly Lesson Plan for Preschool Sample Template 8 Free
Preschool Weekly Lesson Plan Template Best Weekly Lesson Plan from yarn inventory spreadsheet , source:tomvsbruce.com