Great video! I'd suggest two things. The first thing is to have an extra column showing the profit for each card (could also be the ROI on the money spent on the card). That way you can analyze which cards give you the greatest profit to optimize your buying strategy. Could also be different shades of green marking the card. Dark green = great profit and light green = small profit. The second suggestion is having an extra column showing your purchasing price (yes you would have two identical columns showing purchasing price). But when you make a sale you delete the value in one of the columns. That makes you easily track your current inventory value. It's not perfect, as the purchasing price at the given time does not always reflect current value but it does give you a pretty decent idea of total inventory value. For me it was an eye opener seeing how much money I had tied up in cards and boxes just laying around. It can also be pretty handy for insurance purposes. Thank you for your content - please keep making it!
Thanks for this video. I am just getting back into cards in an attempt to build a small business flipping. I collected as a kid in the 80s and jumped back in a couple of years ago to make money, and I jumped back out after a couple of months because I wasted so much on braks, razzs, packs, and buying th wrong cards. I am now getting back in, starting with around $200. I am going to try to build from the ground up. I have done a lot of research, and I now have a strategy. I bought my first cards for the past 2 weeks. I have a handful to flip as the NFL season begins, and then I am moving to basketball for the start of the NBA season. I am just beginning a tracking spreadsheet, so this is a useful video, hanks.
@@stevenoel5726 that’s great!! Yes Stroud prices are down right now he’s a buy but other than that I’m doing the same I’ve been focusing on buying basketball
Excellent video! Very informative! I do something similar, but it’s pretty cumbersome and takes a bit of work to do some real analysis of how well I’m doing. And I only put cards I’m listing in the spreadsheet…I need to start doing this for all cards. Each card gets one row and there are columns for purchase price, grading, platform charges, and even pre-grading notes. It’s kind of one stop shopping. Oh yeah, the best part is after I enter all the details for cards, I output a CSV file which gets uploaded to eBay and creates listings. Thanks for the video! Would love to see more content like this. I’m going to check out your previous videos.
Than you so much for watching and for the kind words! Yeah, I want to find ways to both improve by sheet while also simplifying it. Less work with more result kind of thing
Just curious, would you find it helpful if there was a platform that helped specifically manage your sport cards inventory? I was working on something like this as a side project for fun, as a way to combine my interest in tech and sports cards. But now I am wondering if this is actually something useful to invest more time in 🤔
It's a great idea. I think it would be really helpful. I feel the biggest thing my sheet doesn't do well is showing currently inventory and inventory value. Market movers is good because it can do that and show prices of comps. But it doesn't work well for raw cards, and transitioning raw cards to graded. But I think it's the closest thing that exists.
@@DanielsonSportsCards Thats exactly why i started to build a platform for this. I wanted something a bit more specific in terms of tracking Raw to Graded, knowing what cards are in Grading Process (PSA,BGS,HGA) , and knowing the money i've spent and margins ive made per card. I think I will restart this project again, I didn't think it was too useful to continue but now im having second thoughts. Thanks! 🤔
I have columns that show the average sale price of that card, and the gem rate % for PSA, BGS, and SGC for that card. Just a suggestion. How do you account for raw cards that you later graded? It seems like you are only buying raw, selling raw. Buying slabs and selling slabs
Great video! I'd suggest two things. The first thing is to have an extra column showing the profit for each card (could also be the ROI on the money spent on the card). That way you can analyze which cards give you the greatest profit to optimize your buying strategy. Could also be different shades of green marking the card. Dark green = great profit and light green = small profit. The second suggestion is having an extra column showing your purchasing price (yes you would have two identical columns showing purchasing price). But when you make a sale you delete the value in one of the columns. That makes you easily track your current inventory value. It's not perfect, as the purchasing price at the given time does not always reflect current value but it does give you a pretty decent idea of total inventory value. For me it was an eye opener seeing how much money I had tied up in cards and boxes just laying around. It can also be pretty handy for insurance purposes. Thank you for your content - please keep making it!
@@gwydion44 thank you sooo much what a great comment I’m going to try this!
This may be my favorite channel now and just ran across it earlier today. Great video!!
I just re-started collecting cards (used to in the 90s). I'm also using Excel to track all the spendings and sales. Great job mate!
@@kachino82 hey thanks! Another thing that has been super helpful is having a separate bank account for all this stuff.
Came across your channel yesterday. Great content. U are filling a void in this market. Keep it up
Ah thanks man. I need to make time to make more content. Your encouragement helps me, thank you
Thanks for this video. I am just getting back into cards in an attempt to build a small business flipping. I collected as a kid in the 80s and jumped back in a couple of years ago to make money, and I jumped back out after a couple of months because I wasted so much on braks, razzs, packs, and buying th wrong cards. I am now getting back in, starting with around $200. I am going to try to build from the ground up. I have done a lot of research, and I now have a strategy. I bought my first cards for the past 2 weeks. I have a handful to flip as the NFL season begins, and then I am moving to basketball for the start of the NBA season. I am just beginning a tracking spreadsheet, so this is a useful video, hanks.
@@stevenoel5726 that’s great!! Yes Stroud prices are down right now he’s a buy but other than that I’m doing the same I’ve been focusing on buying basketball
Love this overview!! Great example of how to stay organized. Excited to see how it progresses over time.
Thank you!
Excellent video! Very informative! I do something similar, but it’s pretty cumbersome and takes a bit of work to do some real analysis of how well I’m doing. And I only put cards I’m listing in the spreadsheet…I need to start doing this for all cards. Each card gets one row and there are columns for purchase price, grading, platform charges, and even pre-grading notes. It’s kind of one stop shopping. Oh yeah, the best part is after I enter all the details for cards, I output a CSV file which gets uploaded to eBay and creates listings. Thanks for the video! Would love to see more content like this. I’m going to check out your previous videos.
Than you so much for watching and for the kind words! Yeah, I want to find ways to both improve by sheet while also simplifying it. Less work with more result kind of thing
Sweet video bud 👌 Thanks for sharing 👊
thank you!!
This is fantastic 👏
Thank you!! Just subbed to your channel too
Definitely helpful!!!
@@SnakeMcgoo I’m glad to hear it!! My hope is next year to have a better system
a pivot table with a bar graph would be a great way to visualize your data
That's a great idea!
Just curious, would you find it helpful if there was a platform that helped specifically manage your sport cards inventory? I was working on something like this as a side project for fun, as a way to combine my interest in tech and sports cards. But now I am wondering if this is actually something useful to invest more time in 🤔
It's a great idea. I think it would be really helpful. I feel the biggest thing my sheet doesn't do well is showing currently inventory and inventory value. Market movers is good because it can do that and show prices of comps. But it doesn't work well for raw cards, and transitioning raw cards to graded. But I think it's the closest thing that exists.
@@DanielsonSportsCards Thats exactly why i started to build a platform for this. I wanted something a bit more specific in terms of tracking Raw to Graded, knowing what cards are in Grading Process (PSA,BGS,HGA) , and knowing the money i've spent and margins ive made per card. I think I will restart this project again, I didn't think it was too useful to continue but now im having second thoughts. Thanks! 🤔
@@dora_dadestroya Let me know if you need a beta tester!
How do you input when you sell a card purchased in a previous year?
I have columns that show the average sale price of that card, and the gem rate % for PSA, BGS, and SGC for that card. Just a suggestion. How do you account for raw cards that you later graded? It seems like you are only buying raw, selling raw. Buying slabs and selling slabs
So I do buy raw and grade a lot. I highlight those in blue.
Is there a way to get this sheet? I have been looking for something like this.
You can DM me in IG if you'd like
no poop august going strong 💪💪
@@_trib you haven’t pooped since July??
That’s rough. You might want to get more fiber in your diet
Are you registered as an llc? Been questioning if I should do that or not
@@Newblastcards I am
Another big question how do you separate business money from personal do you like pay yourself or how does that work? Thanks @DanielsonSportsCards
Are you an accountant?
@@lococardcollector7901 hey! No I’m actually a film producer funny enough