This amount includes applicable customs duties, taxes, brokerage and other fees. This amount is subject to change until you make payment. For additional information, see the Global Shipping Program terms and conditions- opens in a new window or tabThis amount includes applicable customs duties, taxes, brokerage and other fees. This amount is subject to change until you make payment. If you reside in an EU member state besides UK, import VAT on this purchase is not recoverable. For additional information, see the Global Shipping Program terms and conditions- opens in a new window or tab
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 Trackerand Expense Report - Basic Version",
a spreadsheet I created for tracking sales in my eBay
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.
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:
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.
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.
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
This software tracks sales in the
following fixed price and auction style listing categories
Books & Media
All Other Items
eBay Motors - Car Parts and related
eBay Motors - Car Electronics
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.)
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.
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 calculatesall fees
incurred by eBay and PayPal for your sales transactions. (Always refer to your monthly invoice for misc. and listing fees from eBay)
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
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
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
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.
(estimated and based on max bid)To be provided at checkout
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.