eBay Fee Calculator Spreadsheet
Posted March 7th, 2010 by Ryan Olbe Spreadsheets, eBay Tools Add comments
This spreadsheet helps you calculate how much it would cost to sell on eBay. You simply enter the price of your item and you can see what your fees and profit would be in any of eBay's listing formats including Auction Format, "List 5 Free" Format, Fixed Price Format, Store Inventory Format, and Classified Ad Format. For advanced users, there is a way for you to reverse calculate your fees to determine what amount to charge for your item (or what to charge for S&H) to receive the amount you want after fees. You can keep a record of your sales using the included Sales Log worksheet or print out a chart showing what your fees would be for common amounts using the included Fees Chart worksheet. You can also reverse calculate price or S&H for a large number of items at once using bonus "Markup" worksheet. 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.
Fee Calculator worksheet
The Fee Calculator worksheet allows you to calculate what your fees and profit would be when selling on eBay. There are side-by-side calculators for Auction Format, Auction Format (5 Free), Fixed Price Format, Store Inventory Format, Classified Ad Format and Half.com. The boxes in yellow are what you fill in and the boxes in red and green are what the calculator fills in. You can enter:
• How many items you are offering for sale
• How many items you successfully sold
• How much you are charging for Shipping & Handling
• How much you actually paid in postage
• How much you paid to acquire the item (optional)
• The price you sold the item for
The calculator will figure out your total eBay fees, your total PayPal fees and your total profit from the sale.
You can reverse calculate fees by typing into the "To Receive" box. You tell the calculator the amount you want to receive after fees and it tells you what to charge for your item or what to charge for S&H to receive that amount. In effect, it incorporates all of your fees into the selling price of your item (or your S&H charge). When using this feature, please be mindful of eBay's excessive Shipping & Handling policy and PayPal's surcharge policy. You can also calculate your break-even point by typing in $0 as the amount you want to receive in profit.
eBay and PayPal Fee Charts
The included Fee Chart worksheets let you customize and print nicely formatted charts showing what your fees and profit would be for common amounts when selling on eBay or when receiving payments via PayPal. The eBay Fees Chart includes both your eBay fees and your PayPal fees. The PayPal Fees Chart only includes PayPal fees. You can customize:
• Whether or not Insertion Fees are included
• Whether or not Final Value Fees are included
• Whether or not Buy It Now Fees are included
• Whether or not PayPal Fees are included
• Whether the Domestic or Cross-Border PayPal rate should be used
• What your PayPal Monthly Sales Volume is
• What Starting Price should be used (for Auction-Style listings)
• What level of eBay Store you have
You can customize all the dollar amounts shown in the chart or you can use the built-in ones. Common item amounts from $1 to $2000 are included. The Fee Charts come in both spreadsheet format (editable), and PDF format (non-editable).
Sales Log worksheet
The Sales Log worksheet allows you to keep a record of all your sales on eBay. You can enter:
• The date of the transaction
• The name of the item you sold
• The item number of the item
• The listing format you used (Auction/Fixed Price/Stores/5 Free)
• What you paid to acquire the item (optional)
• What price you sold the item for
• The amount you charged for Shipping & Handling
• The amount you actually paid in postage
• A commission % (optional -- for consignment sellers)
• Your buyer's name, e-mail address, and shipping information
The spreadsheet will automatically calculate all your fees and profit and will print your "Average" and "Total" sale amounts at the top.
Markup worksheet
The Markup worksheet allows you to apply a certain markup percentage or amount to a large number of items at once. It can tell you what price to sell your item for or what to charge for Shipping & Handling to receive the amount you want after fees.
The spreadsheet is set up as a list and for each item in the list you can enter:
• The name of the item
• How much you paid to acquire the item
• How much you spent to ship the item (optional)
• How much you charge for S&H (optional)
• The markup amount you want to receive or
• The percentage markup you want to receive
The spreadsheet will tell you:
• What amount you would need to charge for S&H
What your fees, profit, and percentage profit would be if you used that S&H amount
(If the spreadsheet is doing it's job, these should equal the markup amount you specified)
OR
• What amount you would have to charge for your item
What your fees, profit, and percentage profit would be if you charged that amount
(If the spreadsheet is doing it's job, these should equal the markup amount you specified)
The spreadsheet expects you to fill in either a "Markup Amount" or a "Markup Percentage", which can be different for each item. If you enter 0 as both your "Markup Amount" and "Markup Percentage" it will calculate your break-even point.
The spreadsheet is also color-coded to make it easy to determine what you fill in and what the spreadsheet fills in. The yellow cells are what you fill in and the green and purple cells are what the spreadsheet fills in for you.
If you only care about calculating item price and not S&H (or vice versa), you can hide the columns you're not interested in using. You do this by right-clicking on the column letter of the column you no longer wish to see and then choosing "Hide" from the list. To bring it back again select the colunmns surrounding the column you wish to see, right-click on their column letter, and click "Show".
Edit Fee Rates worksheet
The "Edit Fee Rates" worksheet lets you edit all of the fee rates used by the calculator. You can modify all of the fee rates used by eBay.com, eBay Motors, eBay Stores, and PayPal. For some of the included spreadsheets you can also control how the calculator operates in the "Edit Fee Rates" worksheet including:
• What fees should be included in the fee charts
• What PayPal payment type should be applied (Domestic or Cross-Border)
• What your PayPal Monthly Sales Volume is
• What your eBay Stores Level is
• What default options should be used in the Sales Log
All of eBay and PayPal's latest fee rates (as of March 07, 2010) are pre-filled in for you.
Order Now for only $34.95 $24.95
March special! Save $10 if you order by March 15th, 2010!
Instant E-Mail Delivery
After making payment via PayPal, you will immediately be e-mailed a link to download the spreadsheet from a secure download area on this website. This link is specific to you and may not be shared. If you haven't received the e-mail after 12 hours, please contact me with your e-mail address and I'll resend it. The e-mail address you use to make payment is the e-mail address the spreadsheet will be delivered to, so make sure you can receive e-mails at that address. Also make sure to allow incoming e-mails from @rolbe.com so the e-mail doesn't end up in your spam or junk mail folder.
Free Updates For Life
When you purchase this calculator you'll also get free updates for life. That means if eBay ever changes their fee rates in the future, this calculator will be updated and you'll be given a link to download the new version for free. Also remember there are no recurring costs of any kind with this calculator. You don't have to pay a monthly fee to use it, you don't have to pay an annual fee to use it. Just a small, one-time only payment, and it's yours to keep for life!
30-Day Money Back Guarantee
I want you to be completely satisfied with your order that's why I'm willing to offer a 30-Day Unconditional Money Back Guarantee. Try out the calculator for a full 30-days and if you aren't 100% satisfied for any reason, just tell me and I'll refund your money, no questions asked!
Technical Requirements
You will need a computer capable of opening one of the following formats:
 |
OpenOffice.org format (.ODS) |
 |
Excel 2007 format (.XLSX) |
 |
Excel 97-2003 format (.XLS) |
When you purchase the spreadsheet you will be given all 3 formats. You can choose to use whichever version you feel most comfortable with and delete the other two. I designed the spreadsheet using OpenOffice.org and that is the format I recommend you use. OpenOffice.org Calc is a free alternative to Microsoft Excel and can be downloaded for free from http://www.openoffice.org.
New to OpenOffice.org? Watch this short video tour 
Version History
Version 1.5 (March 07, 2010)
• The "Quick Pricing Spreadsheet" and "Fee Calculator Spreadsheet" have been merged into a single, easier-to-use spreadsheet
• The "Fees Chart" and "Profit Chart" spreadsheets have been merged into a single, easier-to-use spreadsheet
• The eBay and PayPal Fee Charts are now separate files and easier to configure
• The "Selling Format Fee Comparison Tool" has been merged with the eBay Fees Chart
• Many of the formulas have been re-written to be compatible with earlier versions of Excel
• The "Edit Fee Rates" worksheet was re-designed to be easier to edit
• PayPal fees for amounts sent in foreign currencies are now more accurately calculated
Version 1.3 (January 28, 2010)
• Added "Top Rated Seller" as one of the options under "Powerseller Discount"
• Verified that all of the fee rates used in the spreadsheet were up-to-date with eBay
Version 1.2 (November 14, 2009)
• Modified the Car Electronics FVF structure because of this recent announcement from eBay:
http://announcements.ebay.com/2009/10/car-electronics-final-value-fees-lowered/
• Added an Excel 2007 version of the spreadsheet
Version 1.1 (October 20, 2009)
• Verified that all of the fee rates used in the spreadsheet were up-to-date with eBay
• Removed the following listing upgrades because they are no longer available on eBay:
Gift Services, Border, Highlight, Featured Plus, Home Page Featured, Pro Pack
Version 1.0 (October 04, 2009)
• Initial Release
I would like to purchase this eBay Calculator spreadsheet version but need to know if i would be able to get the spreadsheet formula of all the eBay fee calculations so that i can apply the markup i would like for all the items that i would like to sell on eBay and the formula would output the fixed store price?
Thanks.
Yes, you can view the formulas, but rather than copying and pasting long and complex formulas from one spreadsheet to another, I've created this additional spreadsheet for you that can more easily accomplish what you need. I'm including this as a free bonus to everyone who purchases this calculator. This spreadsheet allows you to add a specified markup (either as a percentage or as an amount) to a large number of items at once. To more easily understand what the spreadsheet does take a look at this screenshot:
http://www.rolbe.com/images/ebay_us_spreadsheet/014.html
You can add as many items as you like to a list and for each item you can specify what you paid for the item (under the "Cost" column), what you paid to ship the item (under the "Actual S&H" column), and what you charged the buyer for S&H (under the "Charged S&H" column). It will then calculate how much you would need to increase your S&H by OR how much you would need to increase your item's price by in order to achieve that desired markup amount.
Nice work!
Being an international seller myself, USA site is not that only site that I sell on. Would it be possible in the future to consider adding in various fee structures for other eBay sites?
Working on them as we speak. You can subscribe to my blog's RSS feed or my Twitter to be notified when they are ready.
Is there any way to use this spreadsheet in Excel?
Starting with version 1.5 all of my spreadsheets are now usable in any version of Excel.
Dear Ryan
Very Impressed with your Spreadsheet work. In past I have used your Calculator from Web. This spreadsheet is beyond the calculator. You will see my order for Spreadsheet soon. See you in Twitter too!
Thanks for help!
Thank you. I appreciate it.
[...] The author of these tools went as far as making a spreadsheet for the eBay fee calculator; the details of the spreadsheet and how it works can be found here. [...]
Will this run on Mac's Numbers 09?
Starting with version 1.5 you'll be able to open my Excel 97-2003 (.XLS) version in Numbers.
eBay's fee structure changed dramatically in the last month. Has your spreadsheet been updated accordingly? The screenshots show several features that eBay has discontinued (like highlight, Pro Pack, etc) and so I wondered if the spreadsheet has been updated with these changes yet? Also, I've used your online calculator many, many times, and I want to thank you personally for providing it!
On October 20, 2009 I went through and updated the calculator to fully align with eBay's current fee structure and I removed the listing upgrades that are no longer available on eBay.com including: Gift Services, Border, Highlight, Featured Plus, Home Page Featured and Pro Pack. I've also updated the version number of the calculator to version 1.1.
I bought your spreadsheet but the download link isn't working and your contact form isn't working either. What is going on. Please let me know. I am looking forward to using your spreadsheet. Please help me download it.
Thank You,
Clyde
I apologize for that. Within the last day or two my web hosting company moved me to a new server which caused my download code and contact form to stop working. I've since found the problem and fixed it so your download link should be working now and my contact form should be working as well. Just in case my contact form ever goes on the fritz again, I've added my e-mail address on there so you can e-mail me as a backup.
Thank you for your purchase! Please let me know if you have any other problems downloading or using the spreadsheet and I'll be glad to help you out.
This spreadsheet doesn't import listing information from eBay, does it?
Not right now, no, but I can work on adding that into a future version if you'd like. What exactly would you like it to do? Show a list of your currently running items or just your completed items? What information about each item would you like to see?
I would love to see this be able to import my
completed items. It would be great to see the exact profit
loss for a given time period like monthly or weekly especially yearly(for taxes)!
Will this work on Office 2008 for Mac?
Starting with version 1.5 this spreadsheet will work in any spreadsheet program on the Mac that can open a .XLS file. A .XLS file is an Excel 97-2003 spreadsheet that can be opened by virtually any spreadsheet program in the world. You could also download the Mac version of OpenOffice.org or NeoOffice.
Unfortunately, because Office 2008 for Mac doesn't support ODF (read here for more info) you won't be able to open my original OpenOffice versions.
Hi Ryan,
Any chance of creating a Filemaker Pro database which includes the functionality of your spreadsheets? It would be nice to have a record for each item bought or sold. Many thanks!
I've never used Filemaker Pro before, but I'll definitely look into it and see if I can include it in a future version.
Thx
Hi - will this help me with the info I will need for filing taxes in 2011? Can it be used for profit and loss for each month?
I've been receiving a number of comments lately from sellers saying they would like to more easily be able to see their totals for the month and the year so I've decided to make a change. Now, instead of one sales log spreadsheet, you have 12, one for each month of the year. Each month is now on it's own tab. To enter your sales for January just click on the "Jan" tab, to enter your sales for February, just click on the "Feb" tab and so on.
I've also added a brand new tab to the spreadsheet called "YTD" which stands for "Year To Date". By clicking on the "Year To Date" tab you can see all of your total income and expenses (including all of your eBay and PayPal fees) for each individual month and for the year in total. Nothing on this tab has to be entered manually. Everything is automatically calculated for you.
You can read more about the changes I've made in version 1.5 here:
http://www.rolbe.com/2010/01/11/ebay-sales-log-spreadsheet-1-5/
Does this program work on Mac? Can you calculate costs, income & profits for a specific period of time, for tax purposes and such?
Starting with version 1.5 this spreadsheet will work in any spreadsheet program on the Mac that can open a .XLS file. A .XLS file is an Excel 97-2003 spreadsheet that can be opened by virtually any spreadsheet program in the world. You could also download the Mac version of OpenOffice.org or NeoOffice. I design and develop all of my spreadsheets using OpenOffice.org and that is the program I recommend people use to open them (because it's free and cross-platform).
As for organizing your sales by time period, I've been receiving a lot of similar comments from other sellers and I've added something for this in version 1.5. Now the Sales Log has different sales sheets for each month and a "Year To Date" overview screen showing your total fees and profit for each month and for the year in total.
Happy New Year. You offer a nice service and people still whine. They gotta be from back east!!! Thanks Ryan!
I bought the spreadsheet which is awesome! I just need to know how i can enter products into the sales sheet for combined shipping items. For example. I sell one item for .99 and $3 shipping. and the same bidder won a additional item for .99 and only has to pay .50 for the item to be shipped with the first. How would i enter it into the sales log to calculate it properly because right now its doing a separte paypal charge when its one payment.
If a buyer bought multiple non-identical items from you, you would enter them as separate items in the Sales Log, but under the "S&H" field, where you enter the amount you charge for Shipping & Handling, you would only fill that in for one of the items (the total combined shipping amount), and for the other items you would enter $0.
Now, because they're listed separately in the Sales Log, their Final Value Fees are being calculated separately, which is what you want because eBay charges you separate FVF for separate items (even if you shipped them to the same buyer).
So the only thing you have to worry about is PayPal fees. By default, the Sales Log will calculate PayPal fees for each individual item, but that's not what you want because the buyer only sent you one payment for all items (and PayPal only charged you 1 fee). So what you have to do is a manual override. All you have to do is click on the cell that contains the PayPal fee for that item, then type the fee amount that PayPal actually charged you. Then, for the other items you can manually override their PayPal fee amounts to $0.00.
To figure out the right fee amount to enter, just change the "End" column to the total amount for all items then scroll over to the right to see the actual PayPal fee amount and delete the formula in that cell with the amount. Just click on the cell and type the amount and press Enter. Then go back and change the price of the item back to it's original price.
In a future version, I was thinking of using the "Tracking Number" field to make this process easier. I can make it so that if multiple items have the same tracking number I would know that they are the same shipment and using that I would be able to calculate the appropriate PayPal fee for the total shipment. Even if you don't have a tracking number, you would be able to type in any number you like and it would work just the same.
Very cool man.. Thanks alot for the help. This program helps me so much. Now i dont have to write down everything in a log book.
I had one more question if its not to much. For the month of Feb. I had 383 unsold store items. Is there a way to put them all in under one log. Lets say qty 383 . All end at 0. I did this and it didnt calculate all the fees . Just one .3 fee. Is there a way to do this without having to copy and paste 383 items into the sales log.
With unsold items you don't have to pay PayPal fees and you don't have to pay Final Value Fees, so the only thing you have to worry about are Insertion Fees. The Qty field represents how many items you sold in an individual listing, so that's why when you type in a Qty of 383, it gives you an Insertion Fee of $0.03 because it assumes you sold all the items within a single listing. To multiply/extrapolate Insertion Fees for multiple listings you can use a manual override. Here's how. First, in the Qty field type your quantity, for example 383. Then in the Insertion field, where it says $0.03, click on that and type:
=0.03*383
That will take your Insertion Fee of $0.03 and multiply it 383 times. Remember to type the equals sign (=) first because that tells your spreadsheet program to perform a mathematical operation and not just display what you've typed literally. If your Qty happened to appear in cell L8 you could also type this instead:
=0.03*L8
Doing this will delete the formula that's in there but that's alright in this case because you know for a fact what your Insertion Fees are.