NEED HELP: calculate ebay/paypal fees

brentandbecca · 12-20-2007, 12:55 AM

okay, i know ebay blackthorne and others can tell you what an item sold for, what shipping you charged, what shipping cost thru pp, pp fees, and ebay fees

BUT does anyone know how i can get reports or customize reports that will tell me for instance...

bowman draft sales totals, fees i was charged, etc

I have been doing this manually for years which takes FOREVER, to track more accurately and quicker i was curious what other sod/use

csun22 · 12-20-2007, 01:12 AM

How large or small is the volume of sales that you do? Are you looking to track fees, etc on a per item basis or more so by category......like you were saying all Bowman Draft sales, etc?

Just out of curiousity, when you say "manually".....how manual is it that you are doing it right now?

brentandbecca · 12-20-2007, 01:16 AM

volume, well i have had 1400 auctions in 13 days...
i could either do a search for all bowman draft, OR per item, and then add them up

manually i go in on spreadsheet,,,add all sales with shipping, then go onto invoice for ebay, add all fees, then go to paypal add all fees, then take off shipping

takes FOREVER, even if i could leave out shipping and call that even , fine...just more concerned about fees, and not total fees like selling mgr and pro give you for week/month periods

csun22 · 12-20-2007, 01:35 AM

I, myself, do not do a high volume of eBay sales so I have no idea if eBay provides a service like this for you. When eBay provides you with the invoice, do they give you the option of downloading the invoice? Perhaps you can have a database set up so that you can cross reference all the information and have it pulled into one table that you can look up by auction item #, etc?

I created a spreadsheet that gives you the eBay/paypal fees item by item if you input the starting price/ending price.

Sorry I do not have a more precise answer for you. Hopefully you're able to find a solution. If any of these ideas sound like something that may help, let me know

I used to work for a company that did eBay sales. They used Channel Advisor, which is a 3rd party eBay sales management site.....but its more for repeat type auctions and they charge you like 2% per sale.....so that of course eats up profit but they do provide pretty good sales reports. Unfortunately I don't think a site like that would help all that much for the sale of individual cards

cardshopmd · 12-20-2007, 06:55 AM

here is a place to help you calculate your fees they also have a auction bomb
so if your getting hosed in ebay you can shut them down in baulk

http://bin.vrane.com/fvf

Quote:

Originally Posted by brentandbecca

okay, i know ebay blackthorne and others can tell you what an item sold for, what shipping you charged, what shipping cost thru pp, pp fees, and ebay fees

BUT does anyone know how i can get reports or customize reports that will tell me for instance...

bowman draft sales totals, fees i was charged, etc

I have been doing this manually for years which takes FOREVER, to track more accurately and quicker i was curious what other sod/use

brentandbecca · 12-20-2007, 08:53 PM

i could try sure, but again it's manual inputing the #s, for the 1000s of auctions i do i need an auto report from ebay, they have them just not where i can keep all of one brand together...but at this point i'll try anything...on blackthorne it does have each item in there with shipping, ebay fees and paypal fees after the sale, but for each product i'd have to go ina nd manual add up numbers, not say...SEARCH for bowman draft, and all 600 items show, with total sales, total fees, etc

jacobbigshow · 12-20-2007, 10:11 PM

Does anybody keep good book keeping. I personally keep none. It is good and bad. Good for if I ever get in tax problems, this is a hobby and I made no money on it. Bad news, I have no clue on how much money I made this year. I think a few K, but I am not sure.

12-20-2007, 12:55 AM	#1
brentandbecca Member Join Date: Jul 2007 Posts: 5,441 brentandbecca	NEED HELP: calculate ebay/paypal fees okay, i know ebay blackthorne and others can tell you what an item sold for, what shipping you charged, what shipping cost thru pp, pp fees, and ebay fees BUT does anyone know how i can get reports or customize reports that will tell me for instance... bowman draft sales totals, fees i was charged, etc I have been doing this manually for years which takes FOREVER, to track more accurately and quicker i was curious what other sod/use __________________ Brent Twitter: @brentandbecca eBay: brentandbecca

12-20-2007, 01:16 AM	#3
brentandbecca Member Join Date: Jul 2007 Posts: 5,441 brentandbecca	volume, well i have had 1400 auctions in 13 days... i could either do a search for all bowman draft, OR per item, and then add them up manually i go in on spreadsheet,,,add all sales with shipping, then go onto invoice for ebay, add all fees, then go to paypal add all fees, then take off shipping takes FOREVER, even if i could leave out shipping and call that even , fine...just more concerned about fees, and not total fees like selling mgr and pro give you for week/month periods __________________ Brent Twitter: @brentandbecca eBay: brentandbecca

12-20-2007, 08:53 PM	#6
brentandbecca Member Join Date: Jul 2007 Posts: 5,441 brentandbecca	i could try sure, but again it's manual inputing the #s, for the 1000s of auctions i do i need an auto report from ebay, they have them just not where i can keep all of one brand together...but at this point i'll try anything...on blackthorne it does have each item in there with shipping, ebay fees and paypal fees after the sale, but for each product i'd have to go ina nd manual add up numbers, not say...SEARCH for bowman draft, and all 600 items show, with total sales, total fees, etc __________________ Brent Twitter: @brentandbecca eBay: brentandbecca

12-20-2007, 01:12 AM	#2
csun22 Member Join Date: Oct 2007 Posts: 1,200	How large or small is the volume of sales that you do? Are you looking to track fees, etc on a per item basis or more so by category......like you were saying all Bowman Draft sales, etc? Just out of curiousity, when you say "manually".....how manual is it that you are doing it right now?

12-20-2007, 01:35 AM	#4
csun22 Member Join Date: Oct 2007 Posts: 1,200	I, myself, do not do a high volume of eBay sales so I have no idea if eBay provides a service like this for you. When eBay provides you with the invoice, do they give you the option of downloading the invoice? Perhaps you can have a database set up so that you can cross reference all the information and have it pulled into one table that you can look up by auction item #, etc? I created a spreadsheet that gives you the eBay/paypal fees item by item if you input the starting price/ending price. Sorry I do not have a more precise answer for you. Hopefully you're able to find a solution. If any of these ideas sound like something that may help, let me know I used to work for a company that did eBay sales. They used Channel Advisor, which is a 3rd party eBay sales management site.....but its more for repeat type auctions and they charge you like 2% per sale.....so that of course eats up profit but they do provide pretty good sales reports. Unfortunately I don't think a site like that would help all that much for the sale of individual cards

12-20-2007, 10:11 PM	#7
jacobbigshow Member Join Date: Aug 2007 Location: NJ Posts: 2,928 jacobbigshow Jacobbigshow	Does anybody keep good book keeping. I personally keep none. It is good and bad. Good for if I ever get in tax problems, this is a hobby and I made no money on it. Bad news, I have no clue on how much money I made this year. I think a few K, but I am not sure.