The problem
An independent wealth manager looks after client families whose money sits on many investment platforms, local and offshore, in rand, dollars, pounds and euros. Each platform sends statements in its own layout, some scanned, some password-protected, and the data feeds that should have joined them up were not reliable enough to report from.
The firm wanted one place to see each family's holdings, goal-based allocations and adviser fees, built on the statements clients themselves receive, so reporting could never disagree with them. And no client data was to leave its own cloud.
What we built
- A statement pipeline that reads every platform's statements, including scanned ones through OCR, captures everything they carry and never guesses a missing value.
- Reconciliation on every statement: holdings must add up to the stated total, and opening balance plus movements must equal the closing balance. Anything that doesn't is sent to an exceptions queue to approve, edit or decline.
- Client views built on top: family units, identity resolution across differently printed names, goal-based bucket allocation, adviser fees against agreed mandates, and a completeness check that shows which statements are still missing each month.
- A dashboard for the firm's team, and per-family client reports generated straight from the pipeline.
Architecture
- Runs entirely inside the client's own cloud tenant, in-country. Statements are read from private storage, processed in temporary storage and deleted; nothing lands on RanWorx infrastructure.
- OCR runs locally inside the pipeline; no outside AI service ever sees a statement.
- Python and FastAPI over PostgreSQL in Docker, with a React dashboard served from the same origin. API-first, with every endpoint documented.
- Every action is written to a hash-chained audit trail that the firm's security partner can verify independently through the API.
Result
The firm's month-end book now comes from its statements. Where platforms supplied their own month-end figures, several agreed to the cent.
After the pilot the firm took the system into use and signed a one-year development retainer.