08-13-2017 09:42 PM
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
08-13-2017 09:52 PM
I don't want to share that much financial or other types of
information with ebay.
08-13-2017 10:08 PM
@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...
08-13-2017 11:02 PM
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)
08-14-2017 04:39 AM - edited 08-14-2017 04:41 AM
@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.
08-14-2017 04:48 AM
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?
08-14-2017 05:05 AM
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.....
08-14-2017 06:50 AM
@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.
08-14-2017 08:57 AM
08-14-2017 10:15 AM
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.