I have created an Excel spreadsheet that I use for tracking my beading inventory. It is broken down into seven separate worksheets: 1-seed beads, 2-glass and crystal, 3-natural stones, 4-metal wood nuts, 5-findings, 6-tools and misc, 7-cost summary. You can enter color/size/shape/vender/pkg size/cost/etc.. It will calculate cost for multiple quantities, and keep a running total for each worksheet. This running total is linked to the summary page to give you a total cost of your inventory.
I find this spreadsheet very useful, because you can sort each page by any column... size, color, etc., making it easy to see what inventory you have without going thru your actual product (I always get distracted by all the pretty beads when I have to do that!) It is also handy for re-ordering; the vendor and cost are entered for each item.
Now that I've told you about this.. my question.. is this saleable? I was thinking a cost of $25 for the ready to use spreadsheet. Is that too high? too low? Is anyone interested?
thanks for any feedback.
karen ~ BeadDelirium blog | artfire
Hi Karen, I have read comments from a few people on the forums using basic quickbooks saying inventory detail and reporting was not adequate. Perhaps your spreadsheet would be helpful for some quickbooks users. Really can't tell you more since I don't use quickbooks myself. I track all my expenses on Excel and prefer to keep my per item inventory cost data on the bags that I store my materials in. I just track overall inventory expense and the itemized detail does not show up until it is work in process.
Hope that helps! Lisa
You might be able to find a market for this, but I sort of doubt it. It's not difficult to set up the sheets you describe Yes it takes time, but in the overall scheme of things it's relatively easy. And because it's easy, most will want to customize their pages to their specific needs.
And, speaking strictly for my own needs, I have to bite the bullet and pony up the $$ for a program that will accept bar codes and has a scanner.
Probably not what you wanted to hear,
Thanks Anne, :) that is kind of what I thought, but figured I'd throw it out there and see. With the lack of responce on this post, I figured it wasn't a popular idea. Appreciate the feedback from you and Lisa.
Quickbooks is an EXCELLENT program, and if you invest the time to use all it offers, it's perfect for inventory tracking and all the other accounting issues a small business needs to address. (I used early versions of it when I owned a restaurant because it has the ability to issue payroll checks). But, it is expensive in many ways including cost to purchase, time to set-up properly, and time invested in the learning curve. I wouldn't recommend it for the casual business owner.
A true add advantage to Quickbooks is that many professional accountants also use it so tax time becomes a breeze. I've been lusting after the new, improved version for quite some time but just know that I don't have the time to invest it getting it set up just now. :0(
Hello andi thanks in advance
My name is Cathy Alston. I have been making jewelry for a while and looking for an inventory for my beads.
CurrentlyI am buying my beads from local retailers while they are on sale in hopes of still making a profit.
This is my question. Do you know if a way or program that I can use that will allow me to scan in my tags that I leave on my bead strand and import that information into the program? I am not trying to use their UPC bar as my final product. I just need a way of getting the vendor name, strand price, gemstone name and size.
I can count the beads and photograph them into the inventory. I have between 900-1000 stands