Excel Sheet for sellers!

MercilessKiller

Hi there

In a few hours I'll prob be designing an Excel sheet which will have entries for:

Selling price, Delivery, Percentage taken by ebay (or amazon), how much i'll receive.

One for ebay, one for amazon.

This will mean I can just enter the price for the product and see what I'm going to get.

But before I do that I thought I'd post here to see if anyone else has such a tool?!?!?!

If not I'll do mine and link it on here for ya'll

frivolous_fay

I did an amazon one but I'm not 100% sure it's accurate

pinkgem

I made an excel spreadsheet for some books i was selling which calculated total profit (or loss) for selling on amazon, ebay and green metrolpolis

webbie

I would love one of these as I can't do it myself - any copies gratefully received, if feeling kind!!

many thanks

moneysaver05_2

webbie wrote:

I would love one of these as I can't do it myself - any copies gratefully received, if feeling kind!!

many thanks

I second that. if you do design one can you send us a copy of it, it will be much appreciated it.
cheers:D

pinky8

webbie wrote:

I would love one of these as I can't do it myself - any copies gratefully received, if feeling kind!!

many thanks

I would love one aswell please

My never seem to make sense-I don't really know what sections to do!

Thanks in advance,

xxx

d0cketts

I use https://www.ezaytools.co.uk really helpful

hitch_2

http://www.ebaycalculator.co.uk/

you can save all of your calculations, handy if you sell a lot

sara2323

Just added both websites to my favourites, the calculations are so simple!

Could really do with an excel spreadsheet for both Amazon and Ebay, I tried creating one but can't find the correct formula..

jordan_gibson

Yep that would be really handy, please send me one if you get two minutes. I use one at the moment but it is only very simple.

DonnaP

Hi

I put everything manually into my own spreadsheet (very crude, but effective). I don't like relying on anything too automated. I have a column for how much the item sells for (all my items are old stuff that I haven't had to buy), then all the following columns are expenses - listing fees, seller fees, paypal fees and postage costs. I have set up a simple excel formula to deduct the expenses from the amount the item sold for. Bingo - profit for each item.

I then add all these up on a separate sheet to give a total monthly profit, which gets moved over into a different bank account each month. I keep these monthly sheets to give me an idea of how much I make each year.

I think its best to play around and put together your own which works for you - some people may want more detail than others. If you are new to excel, then there are many short courses at colleges etc to teach the basics.

Donna