Calculating Monthly Profits - eBay Suspended & PayPal Limited Forums
eBay Suspension & PayPal Limited Forums  
Join Today
Register Subscribe
     

Registration is fast, simple and absolutely free so please, join our community today!


Go Back   Home > Platform Discussions > eBay Discussion!

eBay Discussion! EBay Forum. News, Updates, or Anything eBay is Welcome. A kind of lounge if you will.

Reply
 
Thread Tools
  #1  
Old 01-25-2010
aking's Avatar
Executive [VIP]
 
Join Date: Aug 2008
Posts: 2,573
Thanks: 247
Thanked 218 Times in 176 Posts
Activity: 0%
Longevity: 91%
iTrader: (1)
Default Calculating Monthly Profits

How do you guys calculate your net profit every month? I usually do basic figures on a piece of scrap paper to figure out how much I will profit per lot of items I order, including ebay/paypal fees. But it would be nice if I could import data in a program and have it spit out my profits.

Any good ideas? If so, please share.
Reply With Quote
The complete step-by-step guide to get back to selling today!

  #2  
Old 01-25-2010
Here We Go Again's Avatar
Executive [VIP]
 
Join Date: Sep 2008
Posts: 2,359
Thanks: 192
Thanked 695 Times in 329 Posts
Activity: 0%
Longevity: 90%
iTrader: (1)
Default

I use a excel spreadsheet that I have built.
It is full of formulas.
I enter each sale I have with the date, account, item, price, shipping, cost, site fees & shipping cost.
Since I sell the same items at the same prices all the time I just copy/paste a previous sale and change the date.

I have it set up with formulas to automatically tell me the following:
Total price including shipping price.
Total fees including item cost, site fees & postage.
Total net profit
Monthly profit
Yearly profit
Monthly profit percentage (so I can see my best months of the year at the end of the year)
Total items sold
Total types of items (Example: 100 Item A's & 75 Item B's)
Total profit of each style of item I sell
Average profit per style of item

Once you get the spread sheet built with the formulas It is really easy.
The built in formulas are the big trick in a good spreadsheet.
__________________
Once you go Mac you will never go back
Reply With Quote
  #3  
Old 01-25-2010
aking's Avatar
Executive [VIP]
Threadstarter  
 
Join Date: Aug 2008
Posts: 2,573
Thanks: 247
Thanked 218 Times in 176 Posts
Activity: 0%
Longevity: 91%
iTrader: (1)
Default

Yea, thats a good idea HWGA. I am going to take one evening and set up an Excel spreadsheet with formulas to calculate everything.
Reply With Quote
  #4  
Old 01-25-2010
Senior Member
 
Join Date: Jan 2010
Posts: 234
Thanks: 4
Thanked 21 Times in 18 Posts
Activity: 0%
Longevity: 82%
iTrader: (0)
Default

I enter the actual amount I received from Paypal into Excel.(incomings)
Enter all my costs (outgoings)
Highlight each column and it adds everything up for you.
Reply With Quote
  #5  
Old 01-25-2010
lakeman's Avatar
Senior Member
 
Join Date: Jan 2009
Posts: 1,865
Thanks: 580
Thanked 411 Times in 233 Posts
Activity: 0%
Longevity: 88%
iTrader: (114)
Send a message via AIM to lakeman Send a message via MSN to lakeman Send a message via Yahoo to lakeman
Default

HWGA, that sounds like a really nice setup.


Bode, I do the same exact thing. :D
Reply With Quote
  #6  
Old 01-25-2010
SlickJane's Avatar
Subscribed [VIP]
 
Join Date: Nov 2009
Posts: 112
Thanks: 3
Thanked 5 Times in 5 Posts
Activity: 0%
Longevity: 83%
iTrader: (0)
Default

I also made an excel spreadsheet, with formulas so i just input a few numbers and it calculates it out. I also use the spreadsheet to calculate whether it's worth it to buy something in bulk- I price out many different items, then go with the highest profit margin/etc. I see what my breakeven sale amount would have to be, etc.
Reply With Quote
  #7  
Old 01-26-2010
aking's Avatar
Executive [VIP]
Threadstarter  
 
Join Date: Aug 2008
Posts: 2,573
Thanks: 247
Thanked 218 Times in 176 Posts
Activity: 0%
Longevity: 91%
iTrader: (1)
Default

check out this link I just found.

eBay and PayPal Fee Calculator
Reply With Quote
  #8  
Old 01-26-2010
Junior Member
 
Join Date: Mar 2009
Posts: 130
Thanks: 2
Thanked 31 Times in 14 Posts
Activity: 0%
Longevity: 87%
iTrader: (4)
Default

All your formulas are going to change with the new fees coming out this March: eBay.com : 2010 Spring Seller Update

9% FVF! Holy **** that is way much...
Reply With Quote
Reply




Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
PayPal monthly withdrawal limit exebayer PayPal Talk 9 05-02-2010 11:46 PM
So what do you do with your eBay Profits? aking Subscriber Discussions 53 06-18-2009 03:14 PM
Strategies For Locating Hot Items, Hot Sellers, Fast Profits and Monthly Sales Volume HairyOldEbayer Subscriber Discussions 20 02-16-2009 08:54 AM
CCNOW Monthly Fee DeathToEbay PayPal Talk 11 03-14-2008 12:09 AM
what is your monthly net profit? dddoch eBay Suspensions 0 06-21-2007 10:19 PM


Aspkin Group

All times are GMT -5. The time now is 04:29 PM.


Stop the guessing games and learn how you can quickly and easily get back on eBay today!
Read the best selling step-by-step eBay Suspension guide eBay Stealth!
Amazon Suspension? Read Amazon Ghost to get back on Amazon!
vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Ad Management by RedTyger
no new posts

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58