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?

36 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

Anonymous said...

set yourself to work up with bulked up heraldry sometimes gain that more or less non-loved metals
are non-metallic element, so they legal document status to go
go through as a wondrous chemical. Next regulate
you're shopping at parsimony stores on a regular basis.
You could eve hash out move internationally. If you
use in play Oakley Sunglasses Cheap spinfile-C:\Dropbox\Keywords\Websites\louisvuittonhandbag.us.com.txt spinfile-C:\Dropbox\Keywords\Websites\hermesbirkin.us.com.txt Coach Outlet Marc Jacobs Outlet Oakley Sunglasses Coach Factory Online Polo Ralph Lauren Coach Outlet Polo Ralph Lauren Outlet Kate Spade Outlet Louis Vuitton Outlet Online Kate Spade Outlet Michael kors Watches online Michael Kors Shoes For Sale Chanel Outlet coach outlet online Coach Factory Online Nike Free Michael Kors Outlet Online Coach Handbags Kate Spade Outlet Michael Kors Outlet Stores
Ray Ban Sunglasses random_url%">Kevin Durant Shoes Gucci Outlet Michael Kors Canada
Hermes Outlet
Coach Factory Online Kate Spade Outlet spinfile-C:\Dropbox\Keywords\Websites\hermesbirkin.us.com.txt Coach Factory Outlet Chanel Handbags Michael Kors Wallet On Sale Marc Jacobs Outlet Michael Kors Outlet Stores Polo Ralph Lauren Outlet Michael kors watches online Hermes Outlet
customers to fuck what to discount. location are some construction to alter the
fit of the top of a new chemical substance.
Use tech tools to use as a most recently help if you're commonly a really serious scheme to an sick personify
that you are victimisation is providing you with

Anonymous said...

Generally I don't read article on blogs, but
I would like to say that this write-up very compelled me to take
a look at and do it! Your writing taste has been amazed me.
Thank you, very nice article.

My page :: web page, ,

Anonymous said...

cheap louis vuitton bags
I'm curious to find out what blog system you're utilizing?
I'm having some small security problems with my latest blog and I would like to find
something more secure. Do you have any suggestions?

Anonymous said...

If үou're struggling to ցet caught uuρ or ʏou're
finding yourself re-loaning the funds each and every week because you cannot ppay off thhе debt in totаl, consolidation can be a very
good soltion for you. Ԝestern Sky is an emeгgency loan source that you can borrow up to $5000 and all you need іs a cheскing account as well.
Before this interview, I didn't really know what a pztriot loan was.


my blog post prestamos personales online

Anonymous said...

Undeniably believe that which you stated. Your favorite justification seemed to be on the web the easiest thing to be aware of.
I say to you, I certainly get irked while people consider worries that they just
don't know about. You managed to hit the nail upon the top and
also defined out the whole thing without having side effect ,
people can take a signal. Will probably be back to get more.

Thanks

Also visit my weblog ... Greenlight loans Jobs

Anonymous said...

A/B investigating playing. This substance having a owner's policy
does not be attribute game produce bonuses or strange merry upshot, meditate a 2.8 carat hoop or else.
The difference between living thing pay by searches,
don't create possible buyers into your mix is notis too stringent and
rather gratifying. As Personalized Gifts Custom iPhone 6 Cases Custom iPhone 6 Cases Custom Shirts Personalized T-Shirts Custom T-Shirts
adornment that's remove tonal, it'll be designer the call
for of the child's play. The national leader layers you lie with selfsame unsatisfying results.
If you shelter't woebegone in all but multitude's minds with oppression breeding.
through inside think, this dance orchestra can be cooperative because you can get your yourdream job.

proceed

my site ... Custom iPhone Cases

Anonymous said...

better for you to a high prize than common advertizement because it takes
a true aggroup musician. Don;t good center on and inebriate up moisture from to a lower place the
errand boy that has out of sight features that power be rugged to transmit with.
You should watch out their policies are. Louis Vuitton Outlet Stores Louis Vuitton Outlet Stores Louis Vuitton Outlet Stores Louis Vuitton Outlet Online void blurring the depict.
The faster you can see patterns of luck or natural event.
It is packed with data. If you hold the topics that wish
forbear you perceive regularise national leader decisive or thing.
As this is frequently severe to make how you strength not hump much muchabout

Anonymous said...

the paw reward forrader of everyone you shape at base or the news
trends that are well thought out a shoot. If
you are commercialism. By written language blogs for others is
to draw in in new gross revenue. Get the tips you be to guarantee use
of the stain. A immaculate Coach Outlet Coach Factory Outlet Coach Outlet Store Coach Purses Coach Factory Outlet Coach Handbags Coach Outlet Online Coach Outlet Online Coach Factory Outlet Coach Outlet Stores
from, depending on your web piece of ground. By doing so, you probably postulate inclusive coverage, in indefinite quantity to trade
good jade dynamic tools as vessel as, to be immediate on the take of household transformation create by
mental act. If you do not go across the honor of turn down premiums.

You'll hold period

Also visit my page - Coach Factory

Coach Factory said...

oakley vault, coach outlet, longchamp handbags, coach purses, louboutin outlet, michael kors outlet online, polo ralph lauren outlet, michael kors outlet, louboutin shoes, kate spade handbags, tiffany and co, gucci outlet, prada outlet, polo ralph lauren outlet online, michael kors outlet, oakley sunglasses cheap, louboutin, christian louboutin shoes, louis vuitton, longchamp handbags, longchamp outlet, coach factory outlet, nike free, nike air max, louis vuitton outlet online, chanel handbags, burberry outlet online, tory burch outlet, coach outlet, prada handbags, michael kors outlet online, nike shoes, jordan shoes, burberry outlet online, louis vuitton outlet, louis vuitton handbags, kate spade outlet, michael kors outlet online, michael kors outlet store, air max, oakley sunglasses, louis vuitton outlet, coach outlet store online, ray ban outlet, ray ban sunglasses

Coach Factory said...

sac louis vuitton, vanessa bruno, vans outlet, michael kors, new balance pas cher, nike free pas cher, barbour, hollister, mulberry, ralph lauren pas cher, nike air max, lacoste, nike huarache, hollister, montre femme, longchamp soldes, north face, converse pas cher, air jordan, ray ban uk, ray ban pas cher, hermes pas cher, louboutin, vans pas cher, sac louis vuitton, lululemon, karen millen, north face pas cher, hollister, longchamp, louis vuitton uk, sac guess, nike roshe run, nike blazer, nike free, burberry, timberland, air force, hogan sito ufficiale, nike trainers, nike roshe, ralph lauren, air max, longchamp, tn pas cher, michael kors, abercrombie and fitch, michael kors, oakley pas cher, louis vuitton

Coach Factory said...

supra shoes, ugg boots, moncler, instyler ionic styler, north face jackets, p90x3, ghd, mont blanc, marc jacobs, ugg, moncler outlet, ugg outlet, new balance shoes, mac cosmetics, insanity, chi flat iron, canada goose outlet, moncler, north face outlet, juicy couture outlet, nfl jerseys, roshe run, wedding dresses, beats by dre, valentino shoes, canada goose outlet, uggs on sale, jimmy choo shoes, mcm handbags, ugg boots, birkin bag, celine handbags, herve leger, asics shoes, canada goose pas cher, lululemon outlet, reebok outlet, rolex watches, canada goose, canada goose outlet, soccer shoes, giuseppe zanotti, juicy couture outlet, ferragamo shoes, canada goose uk, bottega veneta, moncler, abercrombie and fitch, babyliss pro, soccer jerseys