• Daily Deals
  • Gift Cards
  • Sell
  • Help & Contact
  • Shop Deals

This listing was ended by the seller because the item is no longer available.

Ships to:
United States
Visit store:
Ships to:
United States

Details about  eBay Sales Profit Fee Tracking Spreadsheet 1099K Expense Report Excel 2003 2007

See original listing
eBay Sales Profit Fee Tracking Spreadsheet 1099K Expense Report Excel 2003 2007
Item Sold
Item condition:
--not specified
Dec 29, 2012
US $4.99
FREE Expedited Shipping | See details
Item location:
Warren, Michigan, United States


eBay item number:
Seller assumes all responsibility for this listing.
Last updated on  Oct 05, 2012 08:43:34 PDT  View all revisions

When purchasing, please make sure you send me a message letting me know what version of this program you need:  Excel 2003, Excel 2007, Excel 2010 or OpenOffice!

Please note:  If you would like a backup copy of this software sent to you, choose the $2.99 Standard Shipping option.  A copy of the software will be sent to you on a CD/ROM via USPS First Class Mail.  You will still receive a copy of the software through email as well.


When I first started my eBay business 12 years ago, I kept very limited records of my sales, fees and other related expenses.  In the past several years however, I realized it was very important to start keeping a more accurate accounting of what money was coming in and going out.  And now in 2012, with PayPal and other POS companies issuing the IRS 1099-K, it's crucial to be able to track your expenses so you can write some of them off on your taxes.  This is why I created this particular spreadsheet and now I am offering it to my fellow eBay sellers

What started as a simple spreadsheet that I entered 100% of the data into, ballooned into a piece of software that automatically calculates about 80% of the data in it.  This software uses several complex formulas embedded in it which calculate all of your eBay and PayPal fees, tells you your profit, return on investment, and shows you a graphical breakdown of where your costs are.  I also have now added an expense report to each monthly worksheet in the software so you can keep a running tally of exactly when you are spending on your eBay business.  Built into the expense report is a mileage calculator as well as a calculator for determining the amount of your cell phone bill you can write off on taxes each month.


You are purchasing (1) one copy of  "
My eBay Sales Tracker and Expense Report - Basic Version", a spreadsheet I created for tracking sales in my eBay store.

Please Note:  When purchasing, please specify what version you need (Excel 2003, Excel 2007, Excel 2010 or OpenOffice Calc v3.00 or higher) in the "order details" section during checkout.

Computer requirements:

Windows based PC running Windows XP, Windows Vista or Windows 7

Microsoft Office Excel versions 2003, Excel 2007 or Excel 2010, OpenOffice Calc version 3 or higher.
(This software will not work with Excel for Macintosh due to Microsoft permanently disabling macros in those versions of Excel.)

Please note:  This software uses macros to operate some of the formulas used to make calculations.  A macro is an automated line of code that runs in the background of the spreadsheet.  Your security settings in Excel will need to be set to "Medium" or "Low" for this software to function properly on your computer.

For Excel 2007 Users:  Make sure that you have the add-in "Analysis ToolPak" installed on Excel 2007 for macros to work correctly.

Software file size:

  • Excel 2003 - 4.72 MB
  • Excel 2007/2010 - 1.96 MB
  • OpenOffice Calc. - 4.37 MB

Features of this software:

NEW!!!  Now compatible with OpenOffice Calc!

The OpenOffice version of this software is now available for those eBay sellers who do not have access to Microsoft Excel.

NEW!!!  Expense Report added for those tracking their expenses for tax reporting purposes!  The expense report includes the following:

  • Automated Mileage Calculator - Input miles traveled and choose the appropriate mileage:  "Business, Moving, or Charitable"  The calculator will give you the dollar amount you can deduct.
  • Cell Phone Deduction Calculator - Input the number of personal and business calls made on your cell phone and the total bill amount.  Deductible total is calculated automatically.
  • Cumulative Expense Totals - Keeps a running total of all expenses by category so you can see where your money is going.  Categories are typical of what can be deducted for income tax purposes.

NEW!!!  Cumulative totals of your sales and expenses all on one sheet which can be viewed at a glance.  No crunching the numbers in your head!

12 months of sheets formatted and ready to input your eBay sales data.

1 formatted blank sheet to copy and create more sheets to add to your workbook, or replace an existing sheet if anything happens.

Glossary of the terminology used in the spreadsheet as it relates to selling on eBay.

Example sales sheet with data entered so you can see how the spreadsheet works.

This software tracks sales in the following fixed price and auction style listing categories on eBay:

  • Electronics
  • Books & Media
  • Electronics
  • Clothing
  • All Other Items
  • eBay Motors - Car Parts and related
  • eBay Motors - Car Electronics
Sales Tax calculation for those required to collect it.  (If you collect more than one state or have differing tax percentages, let me know so I can adjust your spreadsheet.)

Check out options for PayPal and PayPal International.  (Calculates the correct fees for transaction both International and in the United States.)

Ability to track total sales and costs incurred in selling.  Also provides you with a ROI (return on investment) of your sales.

Ability to input up to 1000 eBay transactions.  (If you need more please let me know so I can add more rows.)

Monthly breakdown of your shipping, eBay, and PayPal fees.

Automatically calculates all fees incurred by eBay and PayPal for your sales transactions.  (Always refer to your monthly invoice for misc. and listing fees from eBay)

Visual graph/chart breakdown of your sales and costs.

FREE EMAIL SUPPORT for any issues or questions you might have about the spreadsheet!

BONUS:  Should eBay or PayPal makes changes to their fee structures in the selling categories included in this spreadsheet, I will provide an updated spreadsheet to you free of charge for as long as I am still selling on eBay (which will be a while).

NOW AVAILABLE!  My eBay Sales Tracker v4.1.1 (Advanced Version) - Users can add the inventories of their eBay Store and crucial data is auto-filled into the sales spreadsheets.  v4.0.1 is only available for Excel 2003, 2007 and 2010.  You can check it out here:  My eBay Sales Tracker Software - Advanced Version

Testimonials from eBay buyers:
"You just saved me a ton of hassle. I do pretty well with excel, but really wasn't excited to sit down and do more formulas." - J. in California

"This software was EXACTLY what I needed to keep track of my sales on eBay!" - R. in Ohio

"You should have come up with this software a LOT sooner!  Thank you for making my life a little easier with it..."  A. in Florida



PayPal is the preferred method of payment for this seller.  Cost of this item is only $4.99!  Once payment is received, a copy of this software will be emailed to you at your certified PayPal address.


Misc. Info

I am not a computer programmer or an expert Excel user.  I am just a fellow eBay'er who wanted something to track his sales and decided to share his program with the everyone else.  Please email me with questions, comments or suggestions.  If your idea or suggestion is used in subsequent versions of this software, I will credit you for your contribution.

Thanks for looking and please check out my other items!

My eBay Sales Tracker (v3.2.2) is © 2009 - 2012 MySpiritualRoots

Please Note:  This product is the INTELLECTUAL PROPERTY of the seller, "MySpiritualRoots", and is the legal owner and authorized seller of this software.


Change Log:

v1.0.0 - Initial release.
v2.0.1 - Major re-work of spreadsheet and re-release.
v2.0.2 - Adds "Regular Auction (Store)" to Item Category column, correction of ROI formula.
v2.0.3 - Custom add-on for buyer.
v2.1.1 - Minor re-work.  Macro formulas re-written so Final Value Fees (FVF) for sale amounts above $50.01 calculate correctly.
v3.0.1 - Major re-work of spreadsheet and re-release.
v3.1.1 - Minor re-work of spreadsheet.  Glossary and Example worksheet added.  Tax column added for those who collect state taxes for their sales.
v3.2.1 - Minor re-work of spreadsheet.  Expense report added.
v3.2.2 -
Minor re-work of spreadsheet.  Cumulative sales and expense totals page added.

Please Note:  This software is NOT a substitute for keeping accurate records for tax reporting purposes.  Always retain each and every receipt as it relates to you business.


Questions and answers about this item

No questions or answers have been posted about this item.

Place bid

Time left:
Current bid:
(Approximately ##1##)
Import charges:
Your max bid:
Your max bid:
By clicking Confirm bid, you commit to buy this item from the seller if you are the winning bidder.
By clicking Confirm bid, you are committing to buy this item from the seller if you are the winning bidder and have read and agree to the Global Shipping Program terms and conditions - opens in a new window or tab. Import charges previously quoted are subject to change if you increase you maximum bid amount.
Resume bidding, if the page does not update immediately.
Place bid
Review and confirm your bid
Bid confirmation
FREE shipping
See item description
(Approximately ##1##)
(Enter ##1## or more)
(Enter more than ##1##)
Your max bid:
Increase max bid
Place bid
Confirm bid
Increase max bid
Change bid
, you've been outbid. Don't let it get away - bid again!
, you're the highest bidder on this item. Hope you win it!
, you're the first bidder. Hope you win!
, you're currently the high bidder, but you're close to getting outbid.
, this auction is almost over and you're currently the high bidder.
, you're the high bidder, but the reserve price hasn't been met.
Please enter your bid again.
Please enter a valid number as the bid price.
Enter an amount that is equal or greater than the minimum bid required. This can be found under the bid entry box.
Maximum bids can't be lowered once they're submitted.
This seller requires the buyer to have a PayPal account to purchase this item. Get a PayPal account here .
Your bid is greater than or equal to the Buy It Now price. We recommend you purchase this item via Buy It Now. If you still wish to bid, you may do so below.
Time left:
Current bid:
(approximately ##1##)
Your maximum bid:
(approximately ##1##)
Increase your maximum bid:
By clicking 1 Click Bid, you commit to buy this item from the seller if you're the winning bidder. Learn moreabout 1-click bid - opens in a new window or tab
(approximately ##1##)
Winning bid:
Starting bid:
Congrats! The auction has ended and you're the winner.
The auction has ended, but the reserve price was not met.
Sorry, the auction has ended and you were outbid.
Good news, you're the high bidder.
Sorry, you've been outbid.
You're the high bidder, but the reserve price is not met.
Please enter a higher amount than the current bid.
Maximum bids cannot be lowered once submitted.
Please enter a valid number.