In the Forums

Register

Today's Posts

Search

Get the Weekly
Inkling
newsletter





Previous Issues

Splitcoaststampers's privacy policy

Get Social

Splitcoaststampers on InstagramLike Splitcoaststampers on FacebookFollow Splitcoaststampers on TwitterPit Splitcoaststampers on Pinterest

Sponsored Ads


 
Splitcoaststampers.com - the world's #1 papercrafting community
You're currently viewing Splitcoaststampers as a GUEST. We pride ourselves on being great hosts, but guests have limited access to some of our incredible artwork, our lively forums and other super cool features of the site! You can join our incredible papercrafting community at NO COST. So what are you waiting for?

Join the party at Splitcoaststampers today!

Reply
 
Thread Tools Search this Thread
Old 01-31-2008, 05:51 AM   #1
Cardstock Collector
 
gallicxy's Avatar
 
Join Date: Oct 2007
Posts: 9
Default Anyone have craft fair/sellers spreadsheet?

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?
gallicxy is offline  
Tweet this Post! Share on Facebook Reddit!! Pin on Pinterest! Share on Google+!
Reply With Quote
Old 01-31-2008, 07:18 AM   #2
Rubber Obsessor
 
yankeewifey's Avatar
 
Join Date: Jan 2007
Posts: 108
Default

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
yankeewifey is offline  
Tweet this Post! Share on Facebook Reddit!! Pin on Pinterest! Share on Google+!
Reply With Quote
Reply



Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are On
Pingbacks are On
Refbacks are Off