Over the last few weeks I've been making numerous upgrades and improvements to my eBay spreadsheet and today I'm glad to finally announce the release of version 1.5. Here's what's new in this version.

Support for older versions of Excel
Prior to version 1.5 I had an OpenOffice.org version and an Excel 2007 version. That means the spreadsheet could be opened in either OpenOffice.org (any platform) or Excel 2007 (PC) or Excel 2008 (Mac). However, I received numerous e-mails from sellers who told me they couldn't open the spreadsheet because they were still using Excel 97-2003. These older versions of Excel have technical limitations and couldn't understand my long advanced formulas. In version 1.5, I re-wrote a lot of the formulas using a different method and now the spreadsheet will work perfectly in any version of Excel. It will also now work on any spreadsheet program on any type of computer that can open an .XLS file (for instance, Numbers for the Mac). When you download the spreadsheet you will now be given 3 versions:

	OpenOffice.org Version (.ODS)
	Excel 2007 Version (.XLSX)
	Excel 97-2003 Version (.XLS)

You can choose to use whichever version you feel most comfortable with and delete the other two.
Read the rest of this entry »

eBay Fee Calculator Spreadsheet
Latest Version: 3.2
Last Updated: July 13, 2011
Works for:

eBay.com	eBay.ca	eBay.com.au	eBay.co.uk	eBay.ie	eBay.fr
eBay.es	eBay.it	eBay.de	eBay.at	eBay.be	eBay.nl
eBay.pl	eBay.ch	eBay.in	eBay.com.my	eBay.ph	eBay.com.sg

This spreadsheet allows you to determine exactly what it will cost to sell an item on eBay and exactly how much profit you will make. You provide the calculator with the amount of your item and it will provide you with the exact amount of eBay fees and the exact amount of PayPal fees you would expect to pay if you sold an item on eBay for that amount. The fee calculator really gets into the nitty gritty and accounts for every last little thing that might affect your fees including what category you're selling in, what level of eBay Store you have, what format you are selling in, which listing upgrades you are using and so on. Each of which plays a factor in determining what fees you will pay. You can account for product costs, shipping costs, packing costs, insurance costs, pretty much any cost that you might be incurring as a seller to accurately determine your profit. You can also use it to compare the fees for Auction Style Format vs. Fixed Price Format to determine which is a better fit for your item. You can also use it as a break-even calculator to determine the minimum price you would need to sell your item for so that you don't unintentionally lose money from the sale.

It is a profit prediction and analysis tool to allow you to better judge whether a particular item is worth selling or not based on the potential profit you would receive.
Read the rest of this entry »

Today I've updated my eBay Sales Log spreadsheet to version 1.7. Here's what's new...

A "refund" column has been added
A "refund" column has been added where you can specify a full or partial refund you issued to a customer. If you've ever sold an item on eBay, then later had to issue a refund this column may help. All you have to do is enter the amount you refunded your customer in the "Refund" column. If you refund back 100% of your item's price, the spreadsheet will assume you went through the process of getting a FVF credit and will negate both your Final Value Fees and your PayPal fees. If you only issued a partial refund the spreadsheet will assume you clicked the Issue Partial Refund button in PayPal and will credit back some of your PayPal fees. If you didn't issue a refund you can either enter $0, leave it blank or hide this column completely. I've also added a new section to the "Year To Date" worksheet which totals up all your refunds for the year.

Read the rest of this entry »

Today I've updated my eBay Markup spreadsheet to version 1.3. The purpose of the markup spreadsheet is to tell you what to charge for your items (or what to charge for S&H) to receive the amount you want after fees for a large number of items at once. Here's what's new in version 1.3. (See Screenshot).

Added option for PowerSeller Discount
With this version you now have the option of including a PowerSeller Discount (which provides a 5% to 20% discount off your Final Value Fees). All you have to do is select your PowerSeller Discount level from a list and the correct Final Value Fee discount will be applied.

Read the rest of this entry »

Today I've updated my eBay Sales Log spreadsheet to version 1.6. Here's what's been added.

New field for Sales Tax
I've added a new option for Sales Tax. If you charge sales tax on eBay you can now enter the tax percentage you charge in the Tax % column. The yellow column is where you enter your tax rate (for example 6%) and the red column is where you'll see the calculated tax amount show up. Since tax laws vary by state you are given the option of choosing whether to tax just the item price or the item price plus the S&H charge. If you don't charge tax you can either type 0% or leave this field blank.

Read the rest of this entry »