I am preparing to sell my jewelry and I am trying to decide how I will handle everything in Quickbooks. I’ve used Quickbooks for 20 years in my computer business, but jewelry is a bit different. In my computer business, I purchase hardware (hard drives, motherboards, etc…) and enter everything into Quickbooks as an inventory item. Then I either sell each piece of hardware individually or if I’m building a computer, I have a service item called “custom system” and I list each piece of hardware underneath that item on the invoice.
So, when dealing with jewelry, I don’t want to set up each bead, finding, charm, etc… in Quickbooks as an inventory item because there will be thousands. Plus I would have to count each bead, etc.. and enter that number into QB. If I did it that way, I would then have to set up service items for earrings and bracelets. Then for each item I sold, I would have to enter all the components in that item so the inventory count would match. No thanks! I have item numbers for each design that I create and I thought about entering each item number as an inventory item. However, if I do that, how would I show where the item came from? I didn’t purchase the bracelet or earrings from a vendor. I made them. So there is really no accurate way to add them to inventory.
That brings me to my purpose for this post. For those of you who use Quickbooks in your jewelry business, how are you entering everything? Inventory items or no? Non-inventory items for the things you order just to keep track of part numbers? Maybe just a service item for earrings and one for bracelets? If that’s the case, do you keep track of the actual items and their components in Excel? Any input is totally appreciated!