LATEST UPDATE AVAILABLE FEB. 20 2008

Updated January 7, 2007

Booksellers (and other ebay sellers), click on a link below and choose "save" to download a set of freeware excel worksheets that provide automated functions for tracking monthly ebay sales.

• NEWEST: Version 5 updated to reflect new auction pricing starting 1/30/2007:* Ebay Automated Fee Tracker-V5 (zip file)
• Version 4:* use to calculate fees 8/22/2006- 1/29/2007: Ebay Automated Fee Tracker-V4 (zip file)
• Version 3: use to calculate fees prior to 08/22/2006: Ebay Automated Fee Tracker-V3 (zip file)

What you enter:

• Item cost


• Listed price


• Sold price


• Shipping


• Optional fees total

What the worksheet calculates:

• Ebay listing fee


• Ebay final value fee


• Paypal fee


• Total e/p fees, total cost, net profit


• Cost and profit metrics
• Monthly totals

A separate worksheet allows you to automatically calculate the total cost of optional ebay fees by entering yes/no answers.

The file provides separate monthly worksheets for auctions and stores and a running totals worksheet for a combined operation.

Please email us if you have suggestions for improvements or questions on how to use/customize the file.

*Version 5 update notes: 1) Ebay auction fees updated. Version 4 update notes: 1) Ebay store fees updated; 2) added column for total ebay+paypal fees; 3) added store metrics (e.g., store profit margin); 4) added running totals worksheet, which combines totals for both auctions and stores for that month.