My eBay Selling Template (in Microsoft Excel)

I’m still in the midst of listing everything I need to sell on eBay… man it’s a lot of stuff I’ve been hoarding. I’ve decided to share my eBay selling template – it’s nothing spectacular, just something I whipped up in Microsoft Excel to help organize and automate selling a large number of items. Hopefully others can find it useful. You can download it here – MyMoneyBlog_EbayTemplate.xls. Here’s a screenshot (click to enlarge) and some instructions:



I’ve made the columns go pretty much chronologically in the order of selling an item on eBay.

Item – Brief description of item.
Pic? – Have you taken a picture yet? (Y/N pull down menu)
Desc? – Have you written up the description yet? (Y/N)
Listed? – Is it listed on eBay? (if yes, list Auction #)
Sell Price – What was the final selling price?
S&H – Shipping & Handling Charge
eBay FeesAutomatically calculated based on Sell Price
PP Fees – PayPal Fees, also automatically calculated (Standard Business Account)
Ship Fees – Actual shipping cost
Net – Net amount received for item after fees
Status – Unpaid/Paid/Shipped (drop-down menu)
Date – Date of most recent Status
Payment – Method of payment (PayPal, Money Order, etc. in drop-down menu)
ebay ID/Name – Buyer information

Note that the running totals of things are at the top and highlighted for quick reference. Feel free to change things around to fit your own specs, I’ve tried to make it as intuitive as possible. For example, if you are trying to buy and sell for profit, you could add in your item costs. Any feedback is welcome as well.

Comments

  1. I also put in the ship-to address and a field for tracking number if you use a method of shipping that has it (USPS Priority Mail has free tracking if you print the labels online, and the flat rate envelopes are pretty good at $3.85)

  2. Good idea, I usually e-mail the buyer the tracking number, so that number is saved in my e-mail box somewhere. Thanks for bringing up the free delivery confirmation – here is the link:

    USPS Shipping label w/ Free Delivery Confirmation

  3. Hey thanks so much for this. i dont know why someone hasn’t made a little program for post auction management that does this.. sigh. But i think paypal fees have changed. or else they’re charging me way too much. how do i change the formulation to get the right fees? or else, the data is all skewed.

    Thanks,
    Teri

  4. ah i figured it out. the paypal transaction fees in the workbook don’t take the shipping fees charged into account, when the totals sent to paypal by buyers do. So it’s calcutating pre-=shipping fee totals – which doesn’t really help. is there are work around for this?
    i.e. item costs $10, shipping costs $10, so you get $20 from buyer – and paypal gets a portion of that. But in your chart, it would only see $10 and paypals share of $10 as the paypal fee – instead of the $20. i hope i explained this clearly. is there a workaround?!

  5. does this take off the 5.25% final value fee as well?

  6. I forget, but it should, I have made some changes to it since posting it here though…

    I should warn everyone that if you don’t anything about Excel, it is easy to screw up some cells and mess it all up. Some basic knowledge of how Excel works and how it references other cells is required. And that way, you can customize it to your needs.

  7. Jonathan Peach says:

    Hello,
    This is fantastic! I was just about to spend hours, labouriously creating somthing similar and I thought, Google it. Found this, great! Thanks from Devon, England.

  8. Does this spreadsheet include both Ebay final value fees and the Ebay listing fees?

  9. i’m hopeless at excel love this but wish i could get it to work for the united kingdom

  10. Great… Many thanks

  11. why everytime i try to put an item# in a certain cell it comes back like this: 1.4031E+11? its really annoying and im not sure why its doing this. I am not a stud with excel so please could some one give me some assistance.

  12. I am having a hard time with the equation for the net income, pp fees, and ebay fees. they are doing it by themselfs like you said it would. what do i have to do to make this work?

  13. @ eric
    Try making the cell larger by dragging it, it doesnt look like you have enough room to display your output.

  14. I like your template, however I have spent the past 48 hours on one …straight.
    eBay has since made a few xhanges that not a single developer has touched.
    Simply because ..if you got complaints your template was to complicated, to properly analize your st% & ftr fees 25/75 and then combine all three aimals in to one serious form especially if you can work it puled straight out of eBay’s lacking reportrs…

    I’ll keep posted on how it turns out!

  15. I have a template I would like to sell but don’t know where I can sell it since its a Microsoft OneNote template. Seems everyone wants .exe or PDF files for upload. Have any suggestions for selling this document for me? I’m sure it would sell but the file types are holding me back!

    Thanks :)

  16. Hey, I might have just overlooked this, but is this only set up for ebay auctions or can you change to Buy it now? that way I can get the correct ebay fee’s

  17. Thank you so much for sharing this. it is great that you shared this great idea and I am sure that this took some time. I am not great with making formulas my it # is coming out wrong and I tried to change the format and that worked but I am not getting any of the fees to come out. the top line does but when I add my items it dose not do the sum if any one could help that would be great. I am very thankful for what you have already provided. Thank you so much.

Speak Your Mind

*