How do you Track Inventory?

[Tripawds]

Hey everyone, I thought I'd throw this to you first before I hit up the Etsy Tax/Bookkeeping team (that group is so huge!).

How do you track your inventory? How do you keep track of what's sold in Etsy versus what you have on hand?

I'm having a hard time keeping track of what we have in the store versus what we have actually made, and have run into two situations where a customer bought an item that I forgot to deactivate in my store because we were all out of the actual items (talk about scrambling to make new ones!). Ugh.

I've always used Quickbooks for recordkeeping and inventory tracking with our other businesses, but I'm finding it hard to track jewelry making supplies and our actual products that we've made with them.

Any advice greatly appreciated!

[PlayingWithFiber]

I deal mostly with digital patterns since we went on the road; before though I just used an Excel spreadsheet. That worked fine for my items - crocheted stuff; not sure if it would work with all the different supplies you need for jewelry.

I've seen some forms from Handmadeology for tracking inventory, it just seems that there really is no way around it being a tedious chore...:-/

[Former_Member]

I use Excel and find it tedious as well but I haven't found another way to do it. It is time consuming and confusing at times... I use one excel spread sheet for each box of goodies I store somewhere in the trailer and that seems to keep me somewhat organized. I just have to remember to check off the things I sell every once in a while. I'd be happy to send you my file as a visual if that would be helpful???

[Tripawds]

Hi gals, thanks! Sweeties, sure, I'd love to see the file, thank you!