New Fees calculation.

[selective_distribution]

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!

[barry.110]

When you create a listing, or edit one, when you enter the price you get a line appear above saying UK Buyers will pay a £*.** protection fee. so if you enter £10 in the price the protection fee will show £1.12. I don't think there is a way to set a price so it shows the buyer the price £10.99.

[steel_dragon87]

It looks like you are abusiness seller rather than a private seller, so you should probably switch to a business account tbh. You will no longer have to worry about these buyers fees being added to your listings and affecting your prices.

[selective_distribution]

Thank you. I have not seen that yet. So it looks like I am correct that I will have to sit with a calculator on every listing trying to work out that the buyer sees a `sensible` price!

[newvintiques]

My back of a fag paper calculation says that if you list at £9,83 it should be £10.98.4 which would probably round up to £10.99.

I'm sure people will soon get used to their regular price settings, or just become a business seller and do away with the problem!

[barry.110]

I just started a draft listing and put in the price £9.83 and the system told me the UK Buyer protection fee will be £1.12 so the total would be £10.95. So not quite £10.99 but still what I would consider a normal price rather than the £11.11 as the OP’s example.

[goodibags]

"is there a formula to calculate this?"

The quick way to work back from buyer price to the price you should enter is:

1. Take off 72p (i.e. £10.99 - 0.72 = 10.27)

2. Then divide by 1.04 (10.27 / 1.04 = 9.87)

Bear in mind there are some amounts you cannot reach, like £13.99. I have tried.

Your choice is either £13.98 or £14.00. The extra penny causes an extra penny of fee to be added.

[suelel1968]

=SUM(K2-0.75)/1.04 where K2 is the listing price including buyer fees that you would like to see. I think in a spreadsheet that will get you back to the price you need to list at.

I haven't got any new fees yet (yay!) So I haven't been able to check it agrees with ebay. Let me know if it works.

[inspector_price]

This is really helpful, but please note the correct formula is actually =SUM(K2-0.72)/1.04 (tested and working)

[annedawso]

Thanks for providing the formula, took me a while to manually adjust without that.

[sticky-art-uk]

Why "Thanks ebay"?

If you're selling as a business then get registered as a business and the problem goes away.

Once you go over the £1k threshold in a year ebay will auto report to inland revenue anyway.

[jumberella]

I have managed to calculate the amount shown on my listing to a sensible amount by working backwards by subtracting the buyer protection fee as shown in the listing from my base price. I want to sell my item for £15.00 but it is listed for the buyer as £16.35, a messy total price with no visible separation for the buyer view of fee & seller price. The seller sees the breakdown but not the the buyer until they pay! It is not transparent. My price £15 reduced by BPFee of 4% + 75p (.60p +.74p) gives me £13.65 as starting price. By adjusting this starting price to £13.73 the addition of 4% + .75p gives me a buyer listing price of £15 but I now have a loss of £1.27. In order to list with a logical starting price I will have to do this for every listing and loose money? I will also loose interest on my sales money because it is withheld until two days after delivery. I have had one sale since the new ‘scheme’ started. Before my sales were steady. This is not good customer business practice. When the new postage system arrives on 15th April sellers will no longer be in control of their postage/ packaging fees and what new seller discouragement will that bring. 

[eastern-lights]

It gets worse if you ever want to do partial refunds! Suppose you combine two items and want to refund the buyer £4.90. If you refund £4.90 the buyer receives more than £4.90 as Ebay refund the 4% BPF on the £4.90 even though this was a shipping charge which the buyer did not pay BPF on! (To be fair it doesn't come out of the seller's pocket, but even so. If you want the buyer to receive £4.90 back you have to divide it by 1.04 = £4.71 or maybe £4.72.  Aaaargh! 😠  )

[jimthing]

Can anyone do a formula that includes items which sell OVER £300 so only pay at 2% for that tier? 

(all the ones above are only valid for items UNDER £300 at the 4% amount)

Presumably the formula should include the top amount too (£4000), so would be something that incorporates 300 to 4000 at 2%, and nothing above that?

The Buyer Protection fee is calculated as:

• A flat fee of up to £0.75 per item, and
• 4% of the item price up to £300, and
• 2% of any portion of the item price from £300 to £4,000
• (Any portion of the item price over £4,000 won't incur any additional fee.)

[superchallenge]

Assuming your price is in A1...something like...

=0.75 + MIN(A1, 300)*0.04 + MAX(0, MIN(A1-300, 3700))*0.02

...would show the buyer protection fee.

Haven't tested it, but that's how I would have done it off the top of my head.

[moonlight-rhapsody]

I saw this calculator mentioned on another thread, which works on 4% + 75p.  Thank you to whoever created it.

https://claude.site/artifacts/16aab181-f07e-41cd-a2be-608b241dffda

[jimthing]

---

@superchallenge wrote:

Assuming your price is in A1...something like...

=0.75 + MIN(A1, 300)*0.04 + MAX(0, MIN(A1-300, 3700))*0.02

...would show the buyer protection fee.

---

Great stuff, thanks – but how do you turn it into the pre-fee amount you can enter in the listing price box though? 

[jimthing]

Actually, sorry, but that's not correct. Just tested on an item trying to hit 349.99 finished price and while the formula above gave a fee of 13.75 the actual correct fee was 13.45.

Hurrrmph. Back to square one, again.

Anyone else knowledgeable enough on this? 

[papso22]

If your aim was to display £349.99 to your buyers, you achieved that.  They won't care that your calculated fee is slightly different to the one they are charged.

[superchallenge]

---

@jimthing wrote:

Anyone else knowledgeable enough on this? 

---

Turns out I am.

The formula (with rounding, and removing the fixed fee during calculation) is:-

=ROUNDDOWN(A1 + 0.75 + MIN(A1-0.75, 300)*0.04 + MAX(0, MIN(A1-300-0.75, 3700))*0.02,2)

The reason you were seeing a fee of £13.75 instead of £13.45 is because you were calculating the fee on the finished price of £349.99. Calculated on the pre-BPF price of £336.53 the fee shows as £13.46. eBay is rounding off somewhere, hence the 1p difference. There's no accounting for that unless you can get eBay to break down the exact method they use for calculation. So the best way to do it is still probably to create a ready reckoner of possible target prices that have been manually checked on a real-world listing. 

In order to find the price to list at in Excel, you would do a What-If Analysis. Go to Data > What-If Analysis > Goal Seek. 

In the attached image, I have my formula in A2, referencing C2. In the Goal Seek options...

Set Cell: A2
To Value: 349.99
By changing cell: C2

Click OK and it'll work it out.