How To Save Money On Ebay Shipping

My eBay Selling Template (in Microsoft Excel)

My Money Blog has partnered with CardRatings and Credit-Land for selected credit cards and may receive a commission. All opinions expressed are the author's alone, and has not been provided nor approved by any of the companies mentioned.

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.

Filed Under: eBay

Last updated: October 5, 2011

My Money Blog has partnered with CardRatings and Credit-Land for selected credit cards, and may receive a commission from card issuers. All opinions expressed are the author's alone, and has not been provided nor approved by any of the companies mentioned. MyMoneyBlog.com is also a member of the Amazon Associate Program, and if you click through to Amazon and make a purchase, I may earn a small commission. Thank you for your support.

User Generated Content Disclosure: Comments and/or responses are not provided or commissioned by any advertiser. Comments and/or responses have not been reviewed, approved or otherwise endorsed by any advertiser. It is not any advertiser's responsibility to ensure all posts and/or questions are answered.