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 »

Updated with the latest eBay fees as of June 27, 2010  

This spreadsheet helps you calculate how much it would cost to sell on eBay. It includes versions for:

eBay.com (USA) -- View Screenshots
eBay.ca (Canada) -- View Screenshots
eBay.com.au (Australia) -- View Screenshots
eBay.co.uk (United Kingdom) -- View Screenshots
eBay.ie (Ireland) -- View Screenshots

With just a few clicks you can instantly determine exactly how much you are paying in fees and exactly how much you are making in profit every time you sell on eBay. All of the possible ways of selling on eBay are included. It's not only a calculator, it's a fee-comparison tool. You can use it to compare the different listing formats to see which is the best (most profitable) format to list in for any item you may be selling. It also gives you the ability to reverse calculate your fees. That means you tell the calculator the amount you want to receive after fees and it tells you what to charge to receive that amount.

You can keep a record of your sales using the included Sales Log spreadsheet or print out a chart showing what your fees would be for common amounts using the included eBay Fees Chart. You can also reverse calculate price for a large number of items at once using the included Markup spreadsheet. If eBay ever changes their fees in the future (or you want to calculate the fees for another service) you can edit all of the fee rates used by the spreadsheet using the included Edit Fee Rates worksheet.
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 »