cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Question to sellers on calculating profit and loss

To all sellers,

    How are you people calculating profit/loss on your monthly sales?

wouldnt it be nice the seller hub includes a dashboard to this feature to all sellers? Share your thoughts

Message 1 of 10
latest reply
9 REPLIES 9

Question to sellers on calculating profit and loss

I don't want to share that much financial or other types of

information with ebay.

Sherry

=^.^= =^.^=
( ) ( )
" " =^.^= " "
Message 2 of 10
latest reply

Question to sellers on calculating profit and loss


@params143 wrote:

To all sellers,

    How are you people calculating profit/loss on your monthly sales?

wouldnt it be nice the seller hub includes a dashboard to this feature to all sellers? Share your thoughts


First off ebay would not be able to calculate your profits vs losses as they would not know expenses incurred for your items listed for sale.

So why would you think Seller Hub would be able to help with this....?????????

Surely, (if that's your name) you would be able to calculate your own profits vs losses????

Every computer has a built in calculator and phones do to...

Message 3 of 10
latest reply

Question to sellers on calculating profit and loss

Old school pencil and a ledger book, subtract expenses and costs from total. All profit, no loss since my COGS is zero and I don't have returns. (yet lol)

The easier you are to offend the easier you are to control.


We seem to be getting closer and closer to a situation where nobody is responsible for what they did but we are all responsible for what somebody else did. - Thomas Sowell
Message 4 of 10
latest reply

Question to sellers on calculating profit and loss


@params143 wrote:

How are you people calculating profit/loss on your monthly sales?

wouldnt it be nice the seller hub includes a dashboard to this feature to all sellers? Share your thoughts


Here is how I do it when I need to (- hich I do quarterly at most, and usually just annually for taxes: 

 

1) Export my PayPal transaction details into a spreadsheet

2) Prune and calculate to get columns for Total Amount and Fees

3) Sort / slice / dice until I have one spreadsheet each for : 

   - Payments / refunds from buyers (with column for total received and fees)

   - Payments for shipping that I bought

   - Payments to eBay (monthly paynent of fees)

   - Payments for other expenses (shipping supplies, etc) 

4) Manually add Cost of Goods Sold

5) Manually add lines for other expenses not paid through PayPal

 

With this data, I can very quickly come up with the totals I need: 

 

a) Total received

b) Total selling price

c) Total fees paid to PayPal

d) Total fees paid to eBay

e) Total paid for shipping

f) Total COGS

g) Total of other expenses

 

And from these total, the only measure I really care about is (c + d + e + f + g) / b.

 

This shows me what percentage of my selling price I put in my pocket. I shoot for 75%. 

 

And I'm with sharingtheland - this information is none of eBay's business. 

Message 5 of 10
latest reply

Question to sellers on calculating profit and loss

In seller hub if you go into the performance tab and select 'summary' off the drop down bar it will bring you to a chart which deducts your selling costs: eBay fvf's, paypal fvf's, and shipping charges for the past 31 days and shows you your net profit from there.  However, it does not -- and can not -- deduct things like your aquisition costs, gas, etc.  How do you expect eBaySH  to know that information?

Happy 2018! May this upcoming year be a prosperous one!
Message 6 of 10
latest reply

Question to sellers on calculating profit and loss

I don't expect a total accounting from Seller Hub........

 

But I do expect a DOWNLOADABLE breakdown of the essentials:

 

Ebay fees

Paypal Fees

Item sold for Price

Shipping paid by the buyer

Shipping paid by the seller

Sales Tax collected

Charitable Contributions

 

It's ludicrous that a Program touted to be the end all, be all for Sellers doesn't have a report for IRS reporting containing the above information.  Selling Manager PRO has some of it I believe.  I've had at least 2 go-arounds with SH people about this lack and gotten no where......except surprise that anyone wants/ needs it.....  which shows the shallow depth of understanding of the basic business needs of sellers......

 

I've tried to get what paypal has......but am not an expert in Excel and the basic download is such a mess (or used to be) that I couldn't ever make it work.....

Message 7 of 10
latest reply

Question to sellers on calculating profit and loss


@params143 wrote:

To all sellers,

    How are you people calculating profit/loss on your monthly sales?

wouldnt it be nice the seller hub includes a dashboard to this feature to all sellers? Share your thoughts


I don't do a monthly P/L. I know the approximate profit, based on how much money I'm able to transfer out of my PayPal account. The full calculation is only necessary for tax purposes, once a year.

Message 8 of 10
latest reply

Question to sellers on calculating profit and loss

From what I've been reading, Seller Hub doesn't even show (calendar) monthly sales figures like the old generic selling page did

"If a product doesn't sell, raise the price" - Reese Palley
"If it sold FAST, it was priced too low" - also Reese Palley
Message 9 of 10
latest reply

Question to sellers on calculating profit and loss

We use a spreadsheet.  We download our sales each day from ebay and then have formulas for fees and discounts then we add in costs of goods sold, shipping cost, and paypal fees.  The spreadsheet calculates the net profit of each product.  We then can catorgorize the profits into product sources that we want to track.  We get products from several different sources ( some are consignment and some we purchase out right).  We can ensure individual products/bundles are profitable and also keep track of money.  The numbers aren't exact due to the fact that we do not factor in promotions, free listings, and differences in fvf for different catogories but the difference is very small and works for determining if a product is profitable or not.  For taxes we just download all transactions from paypal and catorgorize them and send them to the accountant.

Message 10 of 10
latest reply