UKAccounting6 min read

What Happens When a New Member Joins Your Investment Club Mid-Year?

The accounting is fine when everyone joins on the same day. It gets complicated the moment someone joins later — especially if the portfolio has already gone up in value. Here's what you need to do.

The problem with a simple split

Imagine your club has 4 members who each contributed £1,000 a year ago. The portfolio is now worth £5,200 — a gain of £1,200. A fifth member joins today and contributes £1,300 (their 20% share of the current portfolio value).

Now suppose the club sells everything tomorrow and splits the proceeds equally. The new member would receive a share of the £1,200 gain that accrued entirely before they joined. That's unfair to the existing four members — and it creates a tax problem, because the new member is being allocated a gain they didn't earn.

In reverse: if the portfolio had fallen in value, a simple split would give the new member a share of a loss that's not theirs either.

The solution: Capital Equalisation Adjustment

A Capital Equalisation Adjustment (CEA) is a mechanism that separates the new member's capital contribution from the embedded gains already sitting in the portfolio.

When the new member joins, the club calculates the unrealised gain embedded in each holding on that date. The new member's contribution is treated as partly a capital contribution (buying into the portfolio at cost) and partly a CEA payment (buying into the embedded gain they're joining at).

When those gains are eventually realised, the CEA amount is deducted from the new member's gain — because they already paid for it when they joined.

A worked example

Portfolio on the date the new member joins:

Holding: 1,000 Vodafone shares

Cost base: £1,200

Current FMV: £1,600

Embedded unrealised gain: £400

Existing members: 4, each with 25% ownership

New member joins at 20%, existing drop to 20% each

New member's CEA = 20% × £400 = £80

This £80 is deducted from the new member's gain when the shares are eventually sold.

When the club eventually sells those shares, the gain is allocated to all five members at their ownership percentages — but the new member's taxable gain is reduced by the £80 CEA they paid on entry.

What if you don't do a CEA?

Two things go wrong:

  1. Existing members lose out. A portion of the gain they earned is shared with the new member. They pay tax on less gain than they actually earned.
  2. The new member overpays tax. They get allocated a gain they didn't earn — and have no mechanism to reduce it.

HMRC guidance for investment clubs acknowledges CEAs as the correct approach. Proshare (the UK investment club body) recommends them. Not doing them isn't just unfair — it produces incorrect tax figures.

Why this is hard to do in a spreadsheet

To calculate the CEA correctly, you need the fair market value of every holding on the exact date the new member joins. Then you need to track that CEA separately for every future disposal, prorated by the shares sold.

A club that holds 15 securities and has had 3 members join at different times has 45 separate CEA records to maintain — plus the tracking of which portion of each has been used as each holding is sold down.

It's not impossible in Excel. But it's the most common thing that goes wrong in manually managed club accounts.

What about when a member leaves?

When a member exits, the calculation runs in reverse. The leaving member is allocated their share of the embedded gain at the point of exit. This is treated as a disposal for CGT purposes — the member has effectively sold their proportionate share of every holding in the portfolio.

The remaining members' cost bases are then stepped up to reflect the fact that the portfolio has been re-valued at current prices for the exiting member's share.

CEAs calculated automatically

HWSW calculates Capital Equalisation Adjustments on the exact date each member joins, tracks them per holding, and deducts them correctly when gains are realised.