Updated with the new Spring 2010 eBay fees  

Today I'm releasing version 2.0 of my eBay spreadsheet with support for the new eBay fees as of March 30, 2010. Because we're in the midst of an eBay fee change when you download the spreadsheet you will be given two versions. One uses the fee rates prior to March 30, 2010 and one uses the fee rates from March 30, 2010 onwards. The new eBay fees become effective at midnight Pacific time on March 30, 2010. Here's what's new in version 2.0.

New Fee Rates for Auction Style Listings
Starting March 30th 2010, the fees for Auction Style listings will be changing to the following:

Standard Fees - Auction-style Listings
Starting Price	Insertion Fees
$0.01 - $0.99	FREE!*
$1.00 - $9.99	$0.25
$10.00 - $24.99	$0.50
$25.00 - $49.99	$0.75
$50.00 - $199.99	$1.00
$200+	$2.00
Selling Price	Final Value Fee
Item not sold	No Fee
$0.01 and above	9% ($50 cap)

*Up to 100 each month

Store Subscriber Fees - Auction-style Listings
Starting Price	Insertion Fees
$0.01 - $0.99	$0.10
$1.00 - $9.99	$0.25
$10.00 - $24.99	$0.50
$25.00 - $49.99	$0.75
$50.00 - $199.99	$1.00
$200+	$2.00
Selling Price	Final Value Fees
Item not sold	No fee
$0.01 - $50.00	8.75% of the closing value
$50.01 - $1,000.00	8.75% of the initial $50.00, plus 4.0% of the remaining closing value balance ($50.01 - $1,000.00)
Equal to or over $1,000.01	8.75% of the initial $50.00, plus 4.0% of the next $50.01 - $1,000.00, plus 2.0% of the remaining closing value balance ($1,000.01 - closing value)

New Fee Rates for Fixed Price Format Listings
The fees for Fixed Price Format listings will be changing to the following:

Fixed Price Format - Insertion Fees
eBay Stores Subscription	Anchor	Premium	Basic	Standard Fees (non-subscriber)
Insertion Fee	$0.03	$0.05	$0.20	$0.50
Pictures (up to 12)	FREE	FREE	FREE	No change

Fixed Price Format - Final Value Fees
Selling Price	All Other Categories	Electronics and Computers*	Clothing, Shoes & Accessories and Parts & Accessories	Media
Item not sold	No fee	No fee	No fee	No fee
$0.01 - $50.00	12.0% of the closing value	8.0%	12.0%	15.0%
$50.01 - $1,000.00	12.0% of the initial $50.00, plus 6.0% of the remaining closing value balance ($50.01 - $1,000.00)	5.0%	9.0%	5.0%
Equal to or over $1,000.01	12.0% of the initial $50.00, plus 6.0% of the next $50.01 - $1,000.00, plus 2% of the remaining to closing value balance ($1,000.01 - closing value)	2.0%	2.0%	2.0%

* Includes Computers and Networking, Electronics, Cameras and Photo, Video Games Systems, Pro Audio Equipment

New Fee Rates for eBay Motors Vehicles
The fees for selling vehicles on eBay Motors will be changing to the following:

eBay Motors Vehicles fees for National Auction-style and Fixed Price Formats
	First 4 listings every 12 months				5+ listings
	Insertion Fee	Successful Listing Fee			Insertion Fee	Successful Listing Fee
		Final value up to $2000	Final value $2000.01 +			Final Value up to $5000	Final Value $5000.01 +
Cars & Trucks, RVs & Campers, and Commercial Trucks	$0	$60	$125		$50	$0	$0
Motorcycles, Powersports, Trailers and Boats	$0	$60	$125		$20	$30	$60
Powersports under 50cc	$0	$10	$10		$10	$10	$10
All other Vehicles	$0	$60	$125		$20	$30	$60

eBay Motors Vehicles fees for Local Classified Ads
	Current	New
First 6 listings	$0	$0
7 - 12 listings	$15.00	$10.00
13th listing and above	$30.00	$15.00

eBay Motors Vehicles - Optional Feature Fees
Feature	Current Price	New Price
Scheduled Listings	$1.00	$0.00
Buy It Now	$1.00	$2.00
Bold	$4.00	$5.00
Border	$4.00	$5.00
Listing Icons	$2.00	$5.00
10-Day duration	$8.00	$15.00
Featured Plus!	$19.95	$24.95
21 day duration	$25.00	$32.00
ProPack	$29.95	$34.95
HP Featured	$99.95	No change
Picture Hosting	$0.15 / picture	No change
Supersize Pictures	$0.75	No change
Gallery Plus	$2.00	No change
Vehicle Picture Pack	$2.00	No change
Listing Designer	$5.00	No change
Highlight	$5.00	No change
Reserve	$7.00	No change

Removal of the "List 5 Free" and Store Inventory Formats
Previously my calculator allowed you to compare the fees for the 4 major eBay listings formats: Auction Format, Auction Format (5 Free), Fixed Price Format, and Store Inventory Format. As of March 30th 2010, eBay is removing 2 of these formats (Store Inventory and 5 Free). There is now only one Auction Format and one Fixed Price Format, but your fees will be different depending on if you have an eBay Store or not.

For non-Store owners I've set up these two side-by-side calculators. These allow you to compare the fees for Auction Format and Fixed Price Format listings using the non-store (standard) fee rates.

If you have an eBay Store you can use the calculators to the right of that labeled Auction Format (Stores) and Fixed Price Format (Stores). These calculators use the fee rates applicable to Store owners.

The cheaper of the two formats will appear with a green band and the more expensive of the two formats will appear with a red band.

Redesigned Fee Chart
I've also updated my eBay Fees Chart which now looks like this:

If you don't have an eBay Store you will want to look on the left hand side of the chart to compare the fees for Standard Auction Style and Fixed Price Formats. If you do have an eBay Store look on the right hand side of the chart to compare the fees for Auction Style and Fixed Price listings from a Store owner's perspective. You can choose which level of eBay Store you have and set other chart options using the "Edit Fee Rates" tab.

New options for Category and Listing Format in Sales Log
When choosing a category in the Sales Log you are now given these options:

Media
Technology
Accessories
Industrial
Other

Select "Media" for:
Books, Music, DVDs & Movies, Video Games

Select "Technology" for:
Consumer Electronics, Video Game Systems, Cameras & Photo
Computers and Networking
Motors Car Audio & Electronics
Pro Audio Equipment

Select "Accessories" for:
Clothing, Shoes & Accessories
eBay Motors > Parts & Accessories

Select "Industrial" for:
Agriculture & Forestry > Tractors & Farm Machinery
Construction > Heavy Equipment, Trailers
Restaurant & Catering > Concession Trailers & Carts
Healthcare, Lab & Life Science > Imaging & Aesthetics Equipment
Industrial Supply, MRO > Fork Lifts & Other Lifts
Manufacturing & Metalworking > Manufacturing Equipment
Manufacturing & Metalworking > Metalworking Equipment
Office, Printing & Shipping > Commercial Printing Presses

Select "Other" for:
All other categories

When choosing a Listing Format you are now given these options:

Auction
Fixed
S. Auction
S. Fixed

Select "Auction" for Auction Style Format
-Duration: 1, 3, 5, 7, or 10 days
-Limited to one item per listing
-Add "Buy It Now" for an additional fee

Select "Fixed" for Fixed Price Format
-Duration: 3, 5, 7, 10, 30 days, or Good 'Til Cancelled
-Sell multiple items in one listing
-No additional fee for Buy It Now
-$0.99 minimum price

Select "S. Auction" for (Stores) Auction Style Format
-Same as Auction Style Format but for Store Subscribers

Select "S. Fixed" for (Stores) Fixed Price Format
-Same as Fixed Price Format but for Store Subscribers

Updated Powerseller Discount options
When choosing a Powerseller Discount you are now given these choices:

Standard Discount (5% off FVF)
Top-Rated Seller Discount (20% off FVF)

Removal of the Store Referral Credit program
As of March 30th 2010 eBay is removing the Store Referral Credit program and so I've removed it from the spreadsheet.

Free Insertion Fees for Auction Style listings starting at $0.01 to $0.99
Under eBay's new fee policy, if you are creating an No Reserve Auction Style listing and your starting price is $0.01 to $0.99 your Insertion Fees will be free. You will not pay any Insertion Fees but you can only create 100 of these free listings a month. After that you will be charged a $0.10 Insertion Fee. In Version 2.0 of the Sales Log this is taken care of automatically for you. The spreadsheet will determine whether this is your 1st to 100th listing in the month and it's Auction Style and it's starting price is $0.01 to $0.99 and you're not using a reserve and will display the correct Insertion Fee (either $0.00 or $0.10) accordingly. If you add a reserve to your auction you will not be eligible for the free Insertion Fee. eBay Store owners are also not eligible for the free Insertion Fee.

If you've already purchased the spreadsheet you can download the new version at:

http://www.rolbe.com/download/

If you haven't purchased the spreadsheet yet you can do so at:

http://www.rolbe.com/2010/03/07/ebay-spreadsheet/

Please feel free to leave comments on this page if you would like to see any new features or options added to the spreadsheet.