Pages

Tuesday, January 3, 2012

My Ebay Spreadsheet



Today I'm going to share the spreadsheet that I use to track my ebay items.  My husband created this for me last year when I was just doing auctions, so there are a few columns I rarely use now that I have a store. 

  • Column A (Name):  This is where I put the description of the item I'm selling.
  • Column C (Listed @):  When I did auctions, I liked knowing what I started the listing at so that I could compare what it eventually sold for.  This is a column I probably will delete in the future.
  • Column D (Sold For):  Final selling price goes here. 
  • Column E (Paid): What I paid for the item
  • Column F (Profit before fees):  This column calculates the selling price minus cost (Column D minus column E)
  • Column G&H (Weight):  Most of my items come from the Goodwill outlet, which is based on weight.  In order to find the correct cost, I enter the weight and it auto calculates into column E.  If I get an item elsewhere, I manually enter it into column E.
  • Column I (Insertation Fee): What it cost me to list the item.
  • Column J & K (Ebay and Paypal Fees) Right now, I don't have those auto calculating, but my plans are to have both auto-calculate so that I don't have to manually enter them.
  • Column L (Shipping Paid):  What it cost me to ship the item.
  • Column M (Shipping Received):  I enter in what the buyer paid in shipping.  For the past few months I've been doing free shipping, so this is almost always 0.
  • Column N (Final Profit):  What I made after paying high fees to Ebay and Paypal.
Feel free to ask any questions about this spreadsheet.  Also, I would love to hear how you track your ebay transactions.  Is it similar to this or completely different?

25 comments:

Diana said...

Thank you for this! I copied it almost word for word to use it this year. How do you know the exact amount that you pay to Paypal and to Ebay in fees? Is Paypal always 4% of the amount received including shipping? And is Ebay 11% of all amount received including shipping? I just take off 15% of the amount I receive as a general rule when calculating profit but I don't know how exact that is. Thanks for your help!

Samantha said...

Mine looked almost exactly like this! Sadly my laptop was stolen this last weekend with all of my ebay info so i have no idea what mot of my stuff even cost me anymore, thanks for poting this, now can at least have a template when I can eventually start over!!

Momma Marketer said...

I am considering getting started with eBay (selling that is, I already shop there). Do you have any good tips for newbies?

Kim said...

@ Diana..I'm not sure what the exact fees are for Ebay and Paypal. I know a roundabout, but need to sit down and calculate them to have my husband create a formula for it.

@ Samantha..I would suggest emailing it yourself from time to time. For a while I had mine on an old desktop. We don't know when it'll crash, but so that I didn't lose everything I kept a copy in my email.

@ Momma Marketer..I would suggest starting with items around your house. Start small, get the feel for it and then if you are still wanting to do it, venture out to find things to flip. My first sale was a scrapbook that I had laying around that I sold for $50.

Anonymous said...

Kim you don't need to calculate your Ebay or Paypal fees. You can print a monthly statement from Paypal. Go to History, Basic Search. On the right (blueish column), click on More, then Monthly acct statement.The first column reflects all income (incl shipping), there's also one for Paypal fees. You can print an invoice from Ebay, to get exact fee costs. It can be found under 'Account'. HTH

Anonymous said...

[url=http://www.51soboo.com]百家乐论坛,百家乐园,百家乐技巧[/url]


百家乐论坛

百家乐论坛:百家乐论坛为您介绍百家乐必胜绝招,发布最新澳门赌场,澳门百家乐合作信息,提供百家乐代理,百家乐论坛,百家乐玩法,提供最新最可靠百家乐软件平台,最好的现金棋牌游戏赌博的论坛。

百家乐论坛,百家乐园,百家乐技巧,百家乐技术交流,百家乐在线试玩的网址,欢迎您来我们百家乐网站参观试玩

Anonymous said...

http://www.4006002833.com
[url=http://www.4006002833.com]太阳城娱乐城[/url],太阳城,菲律宾太阳城

Anonymous said...
This comment has been removed by a blog administrator.
Anonymous said...
This comment has been removed by a blog administrator.
Anonymous said...
This comment has been removed by a blog administrator.
Anonymous said...
This comment has been removed by a blog administrator.
Anonymous said...
This comment has been removed by a blog administrator.
Anonymous said...
This comment has been removed by a blog administrator.
Anonymous said...
This comment has been removed by a blog administrator.
Anonymous said...
This comment has been removed by a blog administrator.
Anonymous said...
This comment has been removed by a blog administrator.
Anonymous said...
This comment has been removed by a blog administrator.
Anonymous said...
This comment has been removed by a blog administrator.
Anonymous said...
This comment has been removed by a blog administrator.
Anonymous said...
This comment has been removed by a blog administrator.
Anonymous said...
This comment has been removed by a blog administrator.
Anonymous said...
This comment has been removed by a blog administrator.
Anonymous said...
This comment has been removed by a blog administrator.
Anonymous said...
This comment has been removed by a blog administrator.
Anonymous said...

This is the reason why if social networking and search engine optimization alone have advantages, social networking SEO also has a series of advantages.
Although I'll be telling you the steps that you need to take in this article, you'll learn more and you'll better understand the process of writing SEO articles if
you do thorough research. For the two searches I conducted for my own website, the
results were a little different.

Here is my webpage ... รับทำ seo