Besides on eBay...

[sportscardtheory]

What is the best way/program to track what I spend on cards and what I sell them for on eBay, to know what my profit is... but on a mass scale? I have a Mac, if that matters...

For example;

Won - 1993 SP Johnny Damon - 5 total- paid average of $3.76 each
Sold - 1993 SP Johnny Damon - 4 sold - sold for $7.89 each, for a total of $16.52 profit

Or something like that, with a running total on the profit, and obviously set up in a correct and easy to use way. Help would be appreciated... I really don't want to do it all by hand.

 

[bouwob]

excell or if your are feeling technically savvy you could use access (the mac versions, if they exist)

 

[sportscardtheory]

excell or if your are feeling technically savvy you could use access

Could you give me some detail? I am computer illiterate...

 

[Dpanthers14]

excell or if your are feeling technically savvy you could use access

Could you give me some detail? I am computer illiterate...

Have fun with that one I remember doing access

 

[Tomlinson21RB]

google spreadsheets work too. accessible anywhere and don't have to worry about losing a file if a computer crashes.

 

[sportscardtheory]

google spreadsheets work too. accessible anywhere and don't have to worry about losing a file if a computer crashes.

Do you think it will do the things I mentioned above, and have the info at my fingertips anytime I need it?

 

[Tomlinson21RB]

google spreadsheets work too. accessible anywhere and don't have to worry about losing a file if a computer crashes.

Do you think it will do the things I mentioned above, and have the info at my fingertips anytime I need it?

I know it will. It is the same thing as excel, but online and you don't need any programs to use it other than a web browser.

I do:
first 5 columns (card information: player, year, set, #, SN)
column 6 (purchase date)
column 7 (purchase price)
column 8 (sale date)
column 9 (net sale)
column 10 (net sale - purchase price)

Then do a sum of column 10 for your total.

 

[bballcardkid]

Don't really use them, but do an excel spreadsheet, catalog all the cards of interest. Include 6 columns in this order (card, paid, sold, (paypal fees), (ebay fees), profit) Anything in parenthesis is a subtraction.

 

[serving4theking]

Basically anything you use, whether it be Excel or some small business software, is going to require some level of computer literacy and a little bit of learning the program. I mean, entire college classes are devoted to learning spreadsheets. But in a matter of a few hours you could take an Excel sheet and make it do what you want it to do. The learning is mostly figuring out how the formulas and cells.

 

[sportscardtheory]

Thank you very much everyone... I'm on the Google one right now, trying to figure it out. How do I get the total profit for all cards I post on it?

 

[sportscardtheory]

google spreadsheets work too. accessible anywhere and don't have to worry about losing a file if a computer crashes.

Do you think it will do the things I mentioned above, and have the info at my fingertips anytime I need it?

I know it will. It is the same thing as excel, but online and you don't need any programs to use it other than a web browser.

I do:
first 5 columns (card information: player, year, set, #, SN)
column 6 (purchase date)
column 7 (purchase price)
column 8 (sale date)
column 9 (net sale)
column 10 (net sale - purchase price)

Then do a sum of column 10 for your total.

So every card has it's own sheet and you post the info top to bottom, or is every card one row left to right? Sorry if this is a lot to explain... I just started wanting to keep track of my profits.

 

[Tomlinson21RB]

google spreadsheets work too. accessible anywhere and don't have to worry about losing a file if a computer crashes.

Do you think it will do the things I mentioned above, and have the info at my fingertips anytime I need it?

I know it will. It is the same thing as excel, but online and you don't need any programs to use it other than a web browser.

I do:
first 5 columns (card information: player, year, set, #, SN)
column 6 (purchase date)
column 7 (purchase price)
column 8 (sale date)
column 9 (net sale)
column 10 (net sale - purchase price)

Then do a sum of column 10 for your total.

So every card has it's own sheet and you post the info top to bottom, or is every card one row left to right? Sorry if this is a lot to explain... I just started wanting to keep track of my profits.

Entry should look something like this:
------1-------------2-------------3-------------------------------4-----------------5--------6----------------7--------------8----------9-------------------10
Pedro Alvarez 2008 Razor Signature Series Exclusive Signatures ES-2 12/14/2008 $20.50 Sale Date Net Sale =(A9-A7)

I can't do it tonight, but if you're interested I can hop on there with you tomorrow and help set it up. There is a function that you can invite people to view/edit it and it has a chat window too so I could explain/customize it with you.

 

[sportscardtheory]

google spreadsheets work too. accessible anywhere and don't have to worry about losing a file if a computer crashes.

Do you think it will do the things I mentioned above, and have the info at my fingertips anytime I need it?

I know it will. It is the same thing as excel, but online and you don't need any programs to use it other than a web browser.

I do:
first 5 columns (card information: player, year, set, #, SN)
column 6 (purchase date)
column 7 (purchase price)
column 8 (sale date)
column 9 (net sale)
column 10 (net sale - purchase price)

Then do a sum of column 10 for your total.

So every card has it's own sheet and you post the info top to bottom, or is every card one row left to right? Sorry if this is a lot to explain... I just started wanting to keep track of my profits.

Entry should look something like this:
------1-------------2-------------3-------------------------------4-----------------5--------6----------------7--------------8----------9-------------------10
Pedro Alvarez 2008 Razor Signature Series Exclusive Signatures ES-2 12/14/2008 $20.50 Sale Date Net Sale =(A9-A7)

I can't do it tonight, but if you're interested I can hop on there with you tomorrow and help set it up. There is a function that you can invite people to view/edit it and it has a chat window too so I could explain/customize it with you.

That would be AWESOME... I'll look for you on here tomorrow. Thanks man!

 

[Tomlinson21RB]

sounds good

 

[mrwhitesox30]

I keep track of all my sales in Excel, which is easy for me because I've used it for a long time. If you want to get a true profit, don't forget to include Ebay fees, Paypal fees, what you charge for shipping, how much you paid for shipping and how much you paid for materials (bubble mailer, toploader, etc.). If you just use what you paid for it and what you sold it for you will get a profit higher than what it actually is.

 

[Huffamaniac]

This is what I do

Don't really use them, but do an excel spreadsheet, catalog all the cards of interest. Include 6 columns in this order (card, paid, sold, (paypal fees), (ebay fees), profit) Anything in parenthesis is a subtraction.