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 Fees – Automatically 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.
The Best Credit Card Bonus Offers – November 2024
Big List of Free Stocks from Brokerage Apps
Best Interest Rates on Cash - November 2024
Free Credit Scores x 3 + Free Credit Monitoring
Best No Fee 0% APR Balance Transfer Offers
Little-Known Cellular Data Plans That Can Save Big Money
How To Haggle Your Cable or Direct TV Bill
Big List of Free Consumer Data Reports (Credit, Rent, Work)
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)
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
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
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?!
does this take off the 5.25% final value fee as well?
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.
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.
Does this spreadsheet include both Ebay final value fees and the Ebay listing fees?
i’m hopeless at excel love this but wish i could get it to work for the united kingdom
Great… Many thanks
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.
Try Enlarging your column width. The width maybe too narrow for your data entry
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?
@ eric
Try making the cell larger by dragging it, it doesnt look like you have enough room to display your output.
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!
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 🙂
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
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.
Thank you ever so much. This will give me a start.
Thank you for sharing! I’ve been scattered and this is a life saver!
Thanks so much for this! Still using the template ten years later in 2015!
The only change I made was, for anyone else reading this, to the formula in Column G, to reflect updated fees (this is for anyone using this template in 2015).
Hi Chloe
I am going to start using this template. What exact change did you make to Column G?
Thanks,
Jay
Double click on column G. You will see a formula. Delete it and put in = (E7+I7+F7) * 0.10
The reason for the change is because eBay fees are now 10% of total sell price. What that new formula does is add total sell price to shipping + shipping & handling to get final total sell price. Then it multiplies by 10% to get the eBay fee.
What is the updated formula for column G?
For me personally and new to selling on eBay, I found your spreadsheet so very easy to use. I did set up different spreadsheets for type of item selling…then put each sheet in my binder under appropriate tab.
JEWELRY; ANTIQUES; CLOTHING, etc. It doesn’t give you a grand total for everything combined, but it makes it easier for me at least at this time to keep track.
Thank you! Del
I’m up for any advice
This is a great base spreadsheet.. unless you know Excel format and equations you can easily mess it up.. if you do know anything about excel you know you can lock the cells so you do not change them…
Thank you for this Awesome spreadsheet. It was a big time saver and I can move onto selling.!! More than open to any advice!! Thank you again.
Thank you very much. I really appreciate you. Its save my time.
This looks great but do you have an updated version for 2017?
Great starter template that can easily be customised if you have MS Excel skills but it does need reformatting for use in the UK. The formulas for the fees need updating as these have changed since the template was posted online. Thanks for sharing for FREE and I’ve added a few pointers below to help any UK users after reading the comments to this post.
UK users
* To calculate the running totals and the Ebay / PayPal fees correctly reformat the cells containing those values to UK Currency (highlight cells, right click, format cells, currency)
* Ebay Fees = 10% of the Final Value Amount = Sell Price + Postage (Final Value Amount * 0.1= Ebay Fee)
*PayPal Fees = If PayPal Income is £1,500 per month = 2.9% + £0.20p per transaction (Final Value Amount + 0.2 * 0.029)
Your eBay Selling Template is good to use. What is missing is COG (cost of goods). Should have this added between Listed and Sell Price for Profit/Loss spreadsheet.
Love this spreadsheet , but I agree about COGS missing. How could I change this spreadsheet to include the Cost of Goods?
Hello, Once I utilize the first 2 lines I’m unable to use the excel sheet…no activated? Do I need to purchase something?
Hi,
Spreadsheets are my worst nightmare. Does’ anyone have a up to date version of this working to uk specs?
Thanks in advanmce.