Anyone who knows me well knows that I am have a life-long sordid love affair with my spreadsheets. I have a spreadsheet for everything! It's about the only way I can stay sane. I had a couple people ask me how I keep track of what I spend on my inventory. The answer is easy - I have a spreadsheet! :)
My eBay spreadsheet has 13 worksheets on it. Here's a shot of my inventory one. It's pretty self-explanatory.
I have a column for the date, where I got it, what it was, how much I paid for it, the date it sold, and how much it sold for. I actually use this for several things, not just for knowing how much I paid for something.
- Mileage: When I need to add up my mileage for the month, I can tell at a glance what days I went where. I know Goodwill is an 18 mile round trip for me, so every time I bought something at Goodwill, I know I can count 18 miles.
- Clearance: When I'm running a steep clearance sale, I can easily see how long I've had an item. I can scroll to the top of my spreadsheet and see what I've had around forever and clearance those items (or even pull them to donate or put in a yard sale).
- Future Listings: I find the same inventory repeatedly. I have bought 3 Namco handheld Pacman video games, for example. When I'm listing something that I previously sold, I can look at my spreadsheet and see how much it sold for and price the new one accordingly.
- Making Best Offer Decisions: When I get an offer for something, I can easily use my spreadsheet to see how much I spent for the item. That helps me to make a quick decision about whether I want to accept the offer or not.
- Commissions: My sister-in-law shops for me. She has my BOLO (Be On the LookOut) list and shops in between her visits back home. She presents me with goods and receipts. I pay her for the purchases. Then I also give her 20% of the profit on anything she brought me. I need to know what I spent in order to properly figure out how much I owe her for the sale.
People make fun of me for my spreadsheets (you know who you are!), but you see... it's not just about my obsessive spreadsheet habit. This one's actually USEFUL. :)