I’ve been collecting gift ribbons and lace over several years. There is no plan for these yet, but I “need” to hold on to them. I know you crafters can relate!
114 spreadsheet lines later these are all accounted for, and a value is guesstimated.
Since 2009 I’ve been better about tracking my craft purchases before I stow them away. I also have a stash of receipts from the years prior and my (digital) photo albums help out a bit too. Still, it’s a lot of guesstimating dating back to 2003.
So if you’re thinking of starting a crafting business, I highly recommend setting up a spreadsheet now that tracks brands, SKUs, dates purchased and price. Enter everything before you throw away the packaging. It often tells you your quantities too so you don’t have to measure or count things on your own. I am learning that there are programs that can then help calculate what you use when you make something and automatically updates your inventory. How cool does that sound?
As I tucked the ribbons back into a drawer, I found some UTEE creations as well.
Good to know what I have on hand “in case of emergency.” 🙂
It feels good to be one drawer closer to starting my business. I ‘only’ have 6 more to go, along with 3 cabinets!
Up next is my embellishment drawer–probably full of surprises! 😉
I did take a breather Sunday (and Tuesday). That was fun! I’ll tell you about Tuesday soon.
Wow- you completely put me to shame. I really love reading about how you’re organizing things. A lot of this would never occur to me but I could SO see the benefit! Must take time to do some organizing soon- 🙂 Thanks for the sweet comment on my blog the other day too. I’m glad I met YOU TOO! 🙂