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.

Modified the reverse formula to work better with earlier versions of Excel
Initially the formula I wrote to reverse calculate eBay fees was too long and complex for earlier versions of Excel to understand. Today I re-wrote it in a more "Excel friendly" way so that it can be saved in Excel 97-2003 (XLS) format.

Combined my "Stores Markup Spreadsheet" and "Fixed Price Markup Spreadsheet"
Previously I had two separate markup spreadsheets. One for Fixed Price items on eBay.com and one for eBay Stores items. With Version 1.3 those two spreadsheets have been combined into one. Now you can keep a list of what to price your eBay Stores items and your eBay.com BIN items in the same file.

Redesigned "Edit Fee Rates" worksheet
I've redesigned the "Edit Fee Rates" worksheet and added a new "Options" section where you can set all of the options used by spreadsheet.

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

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

It will say version 1.2 (because that's the version of the main spreadsheet), but if you download it you'll find version 1.3 of the markup spreadsheet included in the ZIP file.

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

http://www.rolbe.com/2009/10/04/ebay-fee-calculator-spreadsheet/

Version History

Version 1.3 (January 29, 2010)

• Added an option for PowerSeller Discount (5%-20% off FVF)
• Modified the reverse formula to work better with earlier versions of Excel (Excel 97-2003)
• Combined my previous "Stores Markup Spreadsheet" and "Fixed Price Markup Spreadsheet" into a single file

Version 1.2 (November 14, 2009)

• Added an "Edit Fee Rates" tab
• Added support for the Store Referral Credit
• Added an Excel 2007 version of the spreadsheet

Version 1.0 (October 07, 2009)

• Initial Release