A wealth advisory practice
A whole book of client financials
An adviser went from a spreadsheet per client to one view across every company in her book, live with her own documents the day we started.
- The system
- The practice's own models, templates and adjustments
- The documents
- Each client's statements, budgets and reports, however they arrive
A spreadsheet per client, and nothing carries across
The principal advises a book of client businesses on their financials, valuations and exit preparation. Every client's numbers arrive in a different shape: profit and loss, cash flow, statements, budgets, adjustments, add-backs.
So advisers rebuild the same views client by client in spreadsheets. Nothing carries across the book, which means every valuation starts from nothing, and a question about the whole portfolio is a question nobody can answer quickly.
What we built
A platform that reads the documents as they arrive and normalises them, so every company in the book is comparable. Adjustments, add-backs and scenarios are authored on top, with the raw figure always still underneath, and valuations and health checks run across the whole portfolio rather than one company at a time. Any figure can be traced back to the statement it came from, and exports carry that lineage with them.
Each client company gets its own data room to upload into, and an optional workspace to work on its own numbers, so a company is not only reported on. The separation is enforced at the data layer: a company sees its own figures and never another company's, nor the adviser's adjustments and valuations.
Some of it was built to her spec. A due diligence data room for valuation and exit work. A thirteen-week cashflow template, which in her words is there to determine months on hand, filled in weekly and reconciled against the profit and loss. Dashboard views built from screenshots she sent us.
Portfolio
Companies
41
Statements read
386
Need a look
5
| Company | Reported | Normalised | Status |
|---|---|---|---|
| Dalby Freight | $412,000 | $486,000 | Accepted |
| Kerrisdale Group | $1,240,000 | $1,198,000 | Accepted |
| Lowood Trades | $88,500 | $131,000 | Review |
| Pinnacle Civil | $655,200 | Not stated | Needs a look |
How it went
The platform went live on 31 July with her first two document packs loaded the same day. She sent the cashflow template and the rest of her requirements on 6 August, and those changes were done by the 11th. A thirty-minute session on the 12th, and full access on the 13th.
Live on her own documents on day one, with her own changes turned around inside a fortnight.
What changed
The story is how the practice works now rather than the hours saved. Clients upload straight into their own data room. Each company's figures stay walled off. Valuation work builds on the whole book instead of resetting with every engagement.
If Sercha ever went away, the platform deploys into her own infrastructure and she keeps running it.