Anyone have craft fair/sellers spreadsheet?

[gallicxy]

I am trying to organize my sales and such and was wondering if anyone has a spread sheet or anything that they use to keep track of items on hand/ items that have sold and such.

If you do. would you be willing to share?

[yankeewifey]

It's not hard to set-up. Here are the columns that I created:
Qty (quantity that I made)
Item (short item description)
Item Type (I have categories like 'bath', 'decor', 'food', 'papercraft', etc)
Total Cost The formula for this cell is =E2*A2
Cost Per (adding up all my supplies for that item, divided by quantity made)
Show Price Per (how much I priced a single unit at)
Earned $All =(F2*A2)-(E2*A2) (If I sold all I made, how much I'd make )
Earned $Each =F2-E2 (How much my return would be if I sold one unit.)
Sold (the quantity I sold at this particular event)

At the end of each show, I 'inventory' what's left. I update the 'sold' column with how many of each item I sold. When that's done, I update my inventory list and print off a new one so it's ready to go for next time. HTH