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:
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.
By Jonathan Ping | eBay | 7/12/05, 1:20pm