Forum

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. :)

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.

Yea, thats a good idea HWGA. I am going to take one evening and set up an Excel spreadsheet with formulas to calculate everything.

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.

HWGA, that sounds like a really nice setup. :)


Bode, I do the same exact thing. :D

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.

check out this link I just found.

eBay and PayPal Fee Calculator

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...