For example, if you are trying to buy and sell for profit, you could add in your item costs. Feel free to change things around to fit your own specs, I’ve tried to make it as intuitive as possible. Note that the running totals of things are at the top and highlighted for quick reference. Payment – Method of payment (PayPal, Money Order, etc. Status – Unpaid/Paid/Shipped (drop-down menu) Net – Net amount received for item after fees PP Fees – PayPal Fees, also automatically calculated (Standard Business Account) Sell Price – What was the final selling price?ĮBay Fees – Automatically calculated based on Sell Price Listed? – Is it listed on eBay? (if yes, list Auction #) Pic? – Have you taken a picture yet? (Y/N pull down menu)ĭesc? – Have you written up the description yet? (Y/N) In fact, Excel has a function built into the program that calculates monthly payments for you. I’ve made the columns go pretty much chronologically in the order of selling an item on eBay. Updated FebruThough it may seem intimidating, it’s actually relatively easy to calculate monthly loan payments in Excel. Here’s a screenshot (click to enlarge) and some instructions: You can download it here – MyMoneyBlog_EbayTemplate.xls. 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. 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.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |