14-02-2025 10:10 AM
OK, I understand that there are new fees applied, and I have just noted that an item I had listed at £9.99 is now listed at £11.11! The odd 11p makes it look a very unappealing price. I could list it at £10.99 and take the hit, but my question is .....do I now have to go through EVERY listing I have and adjust the price? What is the calculation in fees to do this? I guess I have to calculate the new fees in every new listing also.....is there a formula to calculate this? What a nightmare!......Thanks eBay!
07-05-2025 4:26 PM - edited 07-05-2025 4:27 PM
@sticky-art-uk wrote:or stop worrying about a non existent problem.
We've changed nothing and still getting plenty of sales, a few pence and an odd number isn't going to put anyone off. If they want it they'll have it.
That entirely misses the point of this thread. If private sellers want a formula for their spreadsheets, that's a valid issue, even if it isn't for you being a business seller. 🙄
07-05-2025 4:44 PM
@4_bathrooms - Any luck with this?
07-05-2025 4:58 PM
Whoops...
This should work:
=IF(A1<=300,ROUND((A1-0.72)/1.04,2),ROUND((((A1-312)-0.72)/1.02)+300,2))
Excel doesn't like functions nested the way I did it originally.
07-05-2025 5:04 PM - edited 07-05-2025 5:05 PM
@4_bathrooms wrote:
=IF(A1<=300,ROUND((A1-0.72)/1.04,2),ROUND((((A1-312)-0.72)/1.02)+300,2))
AFAICS this works for all figures now – great work!
Though for others using this, you may have to change the figure in red above to be anywhere from 0.70 to 0.75 to be accurate with what Ebay shows.
07-05-2025 5:08 PM
@jimthing wrote:
@4_bathrooms wrote:
=IF(A1<=300,ROUND((A1-0.72)/1.04,2),ROUND((((A1-312)-0.72)/1.02)+300,2))
AFAICS this works for all figures now – great work!
Though for others using this, you may have to change the figure in red above to be anywhere from 0.70 to 0.75 to be accurate with what Ebay shows.
As far as I can tell the fixed fee is always 72p at the moment. eBay have published "up to 75p" but it appears they made an error in their own calculation and deducted 4% from the 75p; i.e. 72p.
07-05-2025 5:14 PM
@4_bathrooms wrote:
@jimthing wrote:
@4_bathrooms wrote:
=IF(A1<=300,ROUND((A1-0.72)/1.04,2),ROUND((((A1-312)-0.72)/1.02)+300,2))
AFAICS this works for all figures now – great work!
Though for others using this, you may have to change the figure in red above to be anywhere from 0.70 to 0.75 to be accurate with what Ebay shows.
As far as I can tell the fixed fee is always 72p at the moment. eBay have published "up to 75p" but it appears they made an error in their own calculation and deducted 4% from the 75p; i.e. 72p.
Not sure about that... as I checked it with 24.95 final price from one of my listings, and had to edit that figure to be 0.73 because Ebay shows 23.29 pre-BPF price with 1.66 BPF = 24.95 final price.
07-05-2025 5:18 PM
As you can see here:
08-05-2025 12:27 AM - edited 08-05-2025 12:31 AM
@jimthing wrote:
@4_bathrooms wrote:
@jimthing wrote:AFAICS this works for all figures now – great work!
Though for others using this, you may have to change the figure in red above to be anywhere from 0.70 to 0.75 to be accurate with what Ebay shows.
As far as I can tell the fixed fee is always 72p at the moment. eBay have published "up to 75p" but it appears they made an error in their own calculation and deducted 4% from the 75p; i.e. 72p.
Not sure about that... as I checked it with 24.95 final price from one of my listings, and had to edit that figure to be 0.73 because Ebay shows 23.29 pre-BPF price with 1.66 BPF = 24.95 final price.
I think it's actually to do with roundings when calculating the variable amount.
The variable fee of 4% includes VAT so is actually 3.334% plus VAT and each element would need to be calculated separately for accounting purposes.
So for your example:
Net amount :
£23.29 x 3.334% = £0.78 (rounded to 2 decimal places).
VAT amount:
£0.78 x 20% = £0.16 (again rounded to 2 decimal places).
£0.78 + £0.16 = £0.94 which when added to the £0.72 fixed fee (£0.60 + VAT) = £1.66 total BPF as shown by eBay.
16-05-2025 5:46 PM
Agreed, absolute nightmare. I am finding it impossible to negotiate a price even for low cost items. I have one item listed at £5.50 - I would take £5 but cannot figure out how to include Ebay Buyer fee so I get £5.
Buyer has sent offers of £4.11 and £4.60 - as you said Nightmare.
16-05-2025 5:51 PM - edited 16-05-2025 5:52 PM
@punkwroc77 wrote:I would take £5 but cannot figure out how to include Ebay Buyer fee so I get £5.
Set the offer as £5.92.
16-05-2025 6:19 PM - edited 16-05-2025 6:22 PM
@punkwroc77 - Use either of these:
Online calculator: [entering 5.00 final price, gives 4.12 asking]
https://ebaybpfcalculator.netlify.app
Spreadsheet calculation: [entering 5.00 final price, gives 4.12 asking]
=IF(A1<=300,ROUND((A1-0.72)/1.04,2),ROUND((((A1-312)-0.72)/1.02)+300,2))
Each of these can often be a penny or two out, so you may have to use a hack of sorts to check it precisely, by editing the item starting price manually on the listing to see the fee Ebay give, and if doesn't add-up to the final figure needed, change the figure one of the above two options gave you as the starting price by a penny or two to get the right rounded final amount.
Then stop the edit without saving, and make that starting price offer to the buyer. Convoluted but necessary, unfortunately. 😑
16-05-2025 6:31 PM
@punkwroc77 wrote:Agreed, absolute nightmare. I am finding it impossible to negotiate a price even for low cost items. I have one item listed at £5.50 - I would take £5 but cannot figure out how to include Ebay Buyer fee so I get £5.
Buyer has sent offers of £4.11 and £4.60 - as you said Nightmare.
If the buyer is sending an offer to you then the amount they offer will include the BPF so they will need to offer £5.92 in order for you to receive £5.00. If you were sending an offer to the buyer then the BPF would be added to the amount you offer.
16-05-2025 8:09 PM - edited 16-05-2025 8:19 PM
This is perhaps the stupidest system ever, really. Ebay should be showing both buyers and sellers BOTH prices during offers (the pre-fee and final price), regardless of whoever instigates the offer.
It's like they never considered how people actually think about pricing whatsoever in setting up this system.
A similar point I argued last week on the community chat thread with staff: Give private sellers the option to see and use a FINAL price in the item price box, and have Ebay work the fee backwards from there, also showing the breakdown – pre-fee amount & fee above it.
Of course that would be far too simple for their users, wouldn't it, as it would sound like a SELLER fee again, rather than the BUYER fee they want to now market these fees as! 🙄
Instead we're stuck with this pseudo-American system that works like sales tax in the US does – i.e. you see the price of an item on the shelf in a store, but it's only when you take it to the counter or online basket to pay, do they then tell you the final price with sales tax added (different sales tax per city/county/state, of course). But the rest of the world does NOT work this way for a reason: We want to know the WHOLE price (in our case that means VAT-inclusive, rather than Sales Tax!) before purchase.
17-05-2025 9:28 AM
It's worth bearing in mind that some amounts are impossible to hit.
For example, selling an item for £13.99 is impossible.
If you enter an item price £12.75 the buyer fees to be added are £1.22
But increasing by a penny to £12.76 the fees jump to £1.24
There is no obvious reason for a penny increase to cause the fees to jump by 2p. It's as if the rounding is being applied in 2 places, possibly on the net fee and again on the VAT?
Likewise, reducing your price by 96p won't always guarantee the total will come down by a pound.
17-05-2025 12:16 PM
@goodibags wrote:There is no obvious reason for a penny increase to cause the fees to jump by 2p. It's as if the rounding is being applied in 2 places, possibly on the net fee and again on the VAT?
Yes, that is exactly what is happening, 2 lots of rounding due to the VAT, as I explained in my post above (message #48).
17-05-2025 1:33 PM
It's a bit rubbish, isn't it? If Ebay developers weren't so incredibly sloppy you might even think it was deliberate?
19-05-2025 1:57 AM - edited 19-05-2025 1:57 AM
@punkwroc77 wrote:Agreed, absolute nightmare. I am finding it impossible to negotiate a price even for low cost items. I have one item listed at £5.50 - I would take £5 but cannot figure out how to include Ebay Buyer fee so I get £5.
Buyer has sent offers of £4.11 and £4.60 - as you said Nightmare.
Any price can be calculated using:
(sum of fixed costs)/(1-(sum of variable costs as decimal))
Every cost is either fixed (£) or variable (%)
19-05-2025 3:58 AM - edited 19-05-2025 4:01 AM
19-05-2025 10:51 AM
I've just tried to re-list a small painting which I realised will go Letter post, ie exempt from SD. I wanted to make it so the buyer saw £6.50. I used ebay's calculator, but no matter how I manipulated the figures, I could only get either £6.51 or £6.49. In the end I made the price £6.00 just so that I could get a round number ☹️
19-05-2025 1:33 PM
@moonlight-rhapsody wrote:I've just tried to re-list a small painting which I realised will go Letter post, ie exempt from SD. I wanted to make it so the buyer saw £6.50. I used ebay's calculator, but no matter how I manipulated the figures, I could only get either £6.51 or £6.49. In the end I made the price £6.00 just so that I could get a round number ☹️
In some cases it is impossible to get to the desired figure due to rounding off as pointed out in this post by @sml192.
eBay states the BPF is 4% + 75p including VAT; at the moment it is 4% + 72p including VAT. That means it is actually (3.33333...% + 60p) + VAT. Working backwards from that will always leave some starting values a penny or two out.
I'm not sure why you didn't just stick with £6.49. Businesses often use 49p or 99p denominations because lots of people mentally see a figure like £6.99 as being "six pounds something" rather than being £7.00 less a rather insignificant penny.