minicoopers11 Posted July 22, 2014 Share Posted July 22, 2014 Out of curiousity, how do you account the sets sold? I mean... if you have multiples of a set with different purchase prices... do you use FIFO or LIFO? When I sell a set I have multiples of I always sell the less beautiful box and write off the set which has the highest bu-in price. So my remaining invested amount becomes lower. I hope you guys know what I mean. I use FIFO. I don't bother matching box condition with the proper purchase price. Quote Link to comment Share on other sites More sharing options...
speedsausage Posted July 22, 2014 Share Posted July 22, 2014 Out of curiousity, how do you account the sets sold? I mean... if you have multiples of a set with different purchase prices... do you use FIFO or LIFO? When I sell a set I have multiples of I always sell the less beautiful box and write off the set which has the highest bu-in price. So my remaining invested amount becomes lower. I hope you guys know what I mean. Correct me if I'm wrong, does FIFO and LIFO mean, first-in and first-out and last in first out. Also if you have 5 of the same sets in various conditions and different purchase prices, technically shouldn't you be averaging the purchase price out over the 5 sets because in the end really your ROI is over the lot of 5 sets? I'm thinking giving 1 specific set out of the lot of 5 a specific amount$, and you are defining an ROI for that specific set, the numbers are being skewed in your favour no matter what??? Quote Link to comment Share on other sites More sharing options...
Ciglione Posted July 22, 2014 Share Posted July 22, 2014 Correct me if I'm wrong, does FIFO and LIFO mean, first-in and first-out and last in first out. Also if you have 5 of the same sets in various conditions and different purchase prices, technically shouldn't you be averaging the purchase price out over the 5 sets because in the end really your ROI is over the lot of 5 sets? I'm thinking giving 1 specific set out of the lot of 5 a specific amount$, and you are defining an ROI for that specific set, the numbers are being skewed in your favour no matter what??? It is in my favour yes. I would just call it creative accounting. I do not scam anything. The end result is always the same (profit wise). What I do is: I have 5 pcs of the same set with different purchase prices and different box conditions. When I notice it is profitable to sell this particular set I will take the set with the least beautiful or perfect box condition. Make a picture of it and put it for sale with the actual original clear picture so people know what they buy. I keep the best ones for later. When I sell the set I will "write off" the most expensive set in my books. If I had to pay shipping costs with the purchases of my 5 sets I will write that off too from the profit. At the end I will for example have the two best sets left for the cheapest purchase price. So my investment money in this set is as low as possible. The profit I earned I can then use to reinvest in other sets. It is not FIFO or LIFO but a creative combination of both. 1 Quote Link to comment Share on other sites More sharing options...
speedsausage Posted July 22, 2014 Share Posted July 22, 2014 It is in my favour yes. I would just call it creative accounting. I do not scam anything. The end result is always the same (profit wise). What I do is: I have 5 pcs of the same set with different purchase prices and different box conditions. When I notice it is profitable to sell this particular set I will take the set with the least beautiful or perfect box condition. Make a picture of it and put it for sale with the actual original clear picture so people know what they buy. I keep the best ones for later. When I sell the set I will "write off" the most expensive set in my books. If I had to pay shipping costs with the purchases of my 5 sets I will write that off too from the profit. At the end I will for example have the two best sets left for the cheapest purchase price. So my investment money in this set is as low as possible. The profit I earned I can then use to reinvest in other sets. It is not FIFO or LIFO but a creative combination of both. I haven't sold anything yet and this was something that hadn't crossed my mind. I like your creativeness here and I just may apply it to my practices when I get there. Quote Link to comment Share on other sites More sharing options...
xeeeej Posted October 22, 2014 Share Posted October 22, 2014 Here is a vanilla version of my Google spreadsheet. Please feel free to borrow and use any ideas, and provide feedback if you have any. Thanks! https://docs.google.com/spreadsheets/d/11UTvui13wEzrEblD2B-EKgR9F-VF3f7ctT2VoxnbGzQ/edit?usp=sharing 5 Quote Link to comment Share on other sites More sharing options...
LegoManiacc Posted October 22, 2014 Share Posted October 22, 2014 That's slick, thanks for sharing! Quote Link to comment Share on other sites More sharing options...
xeeeej Posted March 5, 2015 Share Posted March 5, 2015 (edited) I've added several new features to my Google Drive spreadsheet for tracking inventory and sales. 1. Supplies. Enter the type of box needed for each item. Enter your beginning box inventory, and then any subsequent supply purchases. The spreadsheet will then track how many are used and how many you need. Never accidentally run out of boxes again! 2. CAGR calculations. By item and overall. 3. Quick Item lookup. Enter the set # for details on how many you have in inventory/sold/profit, etc. 4. Goals vs. actual sales/income. 5. Breakdown of Amazon vs. ebay sales. 6. Piece count. Let me know if you have questions/suggestions for the next version! Enjoy! https://docs.google.com/spreadsheets/d/1NCmgY9nNxF8bjzuMthZArR5JmySAaJtFbr7fAgI2egU/edit?usp=sharing Edited March 5, 2015 by xeeeej 4 Quote Link to comment Share on other sites More sharing options...
Alpinemaps Posted March 5, 2015 Share Posted March 5, 2015 Sweet! Thanks xeeeej. I used the last one that you posted, and kinda did a merge between it and my own sheet. I'll have to post it one of these days. I greatly expanded your Stats page. I now do stats by year, as well as overall. I've expanded a couple of other things in there, as well. But I did incorporate a lot of the stuff you put into yours to help expand mine. Looking forward to taking a look at your sheets, to see how you've expanded on them. 1 Quote Link to comment Share on other sites More sharing options...
xeeeej Posted March 5, 2015 Share Posted March 5, 2015 You're welcome! I would like to track items across multiple years, but honestly the spreadsheet gets bogged down once you put so many items on it with all the formulas, etc. So I doubt it would ever be able to sustain a multi-year version. I just save a new version for each quarter or year, and can go back to review those for historical purposes. I'd be interested to see what you cooked up, though! Quote Link to comment Share on other sites More sharing options...
Alpinemaps Posted March 5, 2015 Share Posted March 5, 2015 I'm up to four years in the spreadsheet. And it is starting to get pretty easy. But performance isn't too made, mostly because I keep it in Google Docs. I break out different segments, though, which makes it even "bigger." Right now, I have tabs for Sets, Minifigs, Set Parting, Bulk Lots, and Bulk Parts. I'm about to break out Polybags into their own tab. I also double track Mixels (they are tracked on the Sets tab, but I also track their individual purchases on a separate tab so when I'm putting together sets from multiple buys, I have a source for their individual prices that then get combined into the entry on Sets page - e.***., if I buy two of one color one day, and the third another day, at a different location and price, I can combine those prices into one entry for that particular color). Quote Link to comment Share on other sites More sharing options...
Neosphinx Posted March 5, 2015 Share Posted March 5, 2015 Very impressive work! Certainly an asset for those that want a very realistic image of their 'business'. Quote Link to comment Share on other sites More sharing options...
xeeeej Posted March 5, 2015 Share Posted March 5, 2015 I'm up to four years in the spreadsheet. And it is starting to get pretty easy. But performance isn't too made, mostly because I keep it in Google Docs. I break out different segments, though, which makes it even "bigger." Right now, I have tabs for Sets, Minifigs, Set Parting, Bulk Lots, and Bulk Parts. I'm about to break out Polybags into their own tab. I also double track Mixels (they are tracked on the Sets tab, but I also track their individual purchases on a separate tab so when I'm putting together sets from multiple buys, I have a source for their individual prices that then get combined into the entry on Sets page - e.***., if I buy two of one color one day, and the third another day, at a different location and price, I can combine those prices into one entry for that particular color). That sounds intense! Looking forward to seeing a demo. Quote Link to comment Share on other sites More sharing options...
angmotan Posted March 7, 2015 Share Posted March 7, 2015 Time to start to create one excel sheet for myself too Quote Link to comment Share on other sites More sharing options...
Guest owlsandhorns Posted March 10, 2015 Share Posted March 10, 2015 I recently made an excel sheet to track all of this. Gives item irr, total portfolio irr, summary cashflows of revenues, inventories, etc, and realized profits by month. If there is an appetite for it I'll link it. Quote Link to comment Share on other sites More sharing options...
xeeeej Posted March 10, 2015 Share Posted March 10, 2015 Sure! I'm always looking for new ideas for mine. Quote Link to comment Share on other sites More sharing options...
matt1147 Posted March 10, 2015 Share Posted March 10, 2015 I can always geek out over a good spreadsheet! Quote Link to comment Share on other sites More sharing options...
Follows Closely Posted March 10, 2015 Share Posted March 10, 2015 ^ link away. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.