Creative Compulsion

Some time ago, I created a simple Excel spreadsheet to give me a quick idea of my profit per item when selling on eBay. I’ve looked around and there are some good programs out there for sale, but I really didn’t need anything fancy - just a general idea of target pricing when I get new items in. I decided to post it here for download in case anyone else finds it useful. The best part? It’s free!

There are 2 sections to it, one for stores and one for auctions.To use, just plug in your cost, desired selling price, any handling fee you charge and the amount for postage/shipping costs. The spreadsheet will give you your gross and net profit for that item. It does take Paypal fees into account, you could delete that column if you don’t use Paypal.

There are some limitations. Unlike the fancy schmancy programs, this isn’t going to figure out your listing fee for you. I list often enough that I know a $24.99 item is going to be $0.95 - $.60 for listing and $0.35 for gallery. You could always copy the listing fees to the bottom of the spreadsheet if you don’t have them memorized. Also keep in mind that this won’t figure in necessary costs like labor, unsold item fees, monthly store fees, etc. It’s simply designed to be an “overview”.

Download the eBay Fees calculator

Enjoy