Your spreadsheet is lying to you

Stop Running Your
Investment Club on a Spreadsheet

Every investment club starts with a spreadsheet. Every investment club eventually breaks one. HWSW does the maths for you — member splits, tax figures, portfolio tracking — automatically.

Free to start. No credit card required.

Five ways your spreadsheet is going to cause a problem

It's not a question of if — it's when.

1

New member joins — entire sheet breaks

Recalculating ownership percentages across historic transactions is a full afternoon of formula-fixing. One wrong cell and the gains are wrong for everyone.

2

Member withdraws — nobody agrees on the amount

Working out exactly what a departing member is owed, factoring in unrealised gains and CGT liability, is almost impossible to do correctly in Excel without accounting training.

3

Tax time — someone has to do it manually

Extracting each member's share of capital gains, applying Section 104 rules or the correct cost basis method, and preparing figures for self-assessment takes days.

4

Multiple versions, nobody knows which is current

"Is it the one Dave sent on Tuesday or the one Sarah updated Thursday?" Spreadsheets shared by email are a version-control disaster waiting to happen.

5

No audit trail when something goes wrong

When a number looks wrong, tracing back through years of formula dependencies to find the error is brutal — and there's no history of who changed what.

What HWSW does instead

Everything your spreadsheet tries to do — done automatically, correctly, every time.

Calculates each member's ownership percentage automatically on every contribution and withdrawal

Applies Capital Equalisation Adjustments when new members join — no manual recalculation

HMRC Section 104 pooling with same-day and 30-day matching rules applied automatically

Generates every member's CGT figures at year end — ready for self-assessment

Withdrawal liability calculator — know exactly what a departing member is owed before they ask

Full audit trail — every transaction, every change, every member action is logged

One version, always current — every member sees the same live data

Import bank and broker statements automatically via AI — no manual data entry

Schedule K-1 generation for US clubs filing as partnerships

Real-time NAV per unit and portfolio dashboard

Spreadsheet vs HWSW

Task
Spreadsheet
HWSW
New member joins
Recalculate everything manually
Automatic CEA calculated instantly
Member withdraws
Guess at the right number
Exact withdrawal liability shown
Year-end tax figures
Full weekend of work
Generated in seconds per member
HMRC Section 104 matching
Hope you got the rules right
Applied automatically on every trade
Portfolio valuation
Manual price lookups
Live prices, always current
Multiple members editing
Version chaos
One live version, everyone in sync
Audit trail
None
Full history of every change
Statement import
Type it all in manually
AI reads your PDF statements
Free to start

Ready to close the spreadsheet for good?

Join the waitlist and get early access to the investment club platform that does it all automatically.

No spam, ever. Unsubscribe any time.