Family office software: what it must do, and how to choose it

Most family offices run on three things: a general ledger their accountant keeps, a spreadsheet somebody built years ago, and a person who knows where everything is. It works until it does not - a second generation asks for their own view, a fund administrator changes its statement format, or the person leaves.

"Family office software" is the category that grew up to replace that arrangement. It is a crowded label, and the products under it do very different jobs. This guide sets out what the software has to do for a family office of any size, how to tell a reporting tool from an operating platform, and how to run a selection without losing a year to it.

What a family office actually has to do every month

Strip away the strategy and the meetings and the recurring operational work of a family office is a handful of loops:

1. Documents arrive - capital call notices, distribution notices, capital account statements, redemption confirmations, GP quarterly reports, brokerage statements, K-1's. Dozens of administrators, each with its own layout.
2. Money moves - the wires those documents describe, the family's own spending, property costs, dividends and coupons, transfers between entities.
3. Someone reconciles the two - this wire is that capital call; that credit is the distribution the notice promised; this debit is the chalet's insurance.
4. The ledger is posted - double-entry journals for each entity, in the right currency, approved by someone other than the person who drafted them.
5. The family is told - net worth, performance, liquidity, what changed, what needs a decision; by entity, by member, by asset class; sometimes for a trustee, sometimes for a board.

Every product in the category does step five. The question is how many of the other four it does, and how honestly.

Reporting tools versus operating platforms

The clearest dividing line in the market is whether the software produces the numbers or merely displays them.

A reporting tool takes positions and transactions that somebody else has already prepared - typically a data-aggregation feed, a custodian file or a spreadsheet upload - and renders them beautifully. It answers "what do we own?" well. It answers "is this right?" poorly, because it has no view of the documents, the bank lines or the journals that stand behind each figure. When a number looks wrong, the investigation happens somewhere else.

An operating platform does the loops above itself. It reads the documents, holds the bank lines, matches the two, drafts the journals, and reports from the same register it just reconciled. The reporting is not a separate feed; it is the top of a chain of evidence. Ask any figure where it came from and it can show you the page.

Neither is wrong. A family whose administrator or private bank already produces a clean consolidated book may only need the reporting layer. A family with a dozen managers, several entities and a small team almost always needs the platform, because the reconciliation is the work.

The twelve questions that separate products

These are the questions we would ask any vendor, including ourselves.

On documents

1. How are capital account statements read? "AI extraction" can mean a language model guessing at a PDF, or a deterministic parser built for that administrator's template with a model only as a fallback. The difference shows up in the third quarter, when a figure is silently wrong. Ask how many administrator formats are supported as templates, and what happens to a statement the system has never seen.

2. Can a reviewer see where each figure came from? The extracted number should be boxed on the source page. If the review screen is a form beside a PDF you have to search by eye, every review takes minutes instead of seconds.

3. Does a scanned document work? Older statements and some administrators still arrive as images. OCR should be built in, and its output should be flagged for a person to confirm.

On money

4. Which bank connections are real? Open Banking through a regulated aggregator covers UK and EU accounts; private banks and custodians rarely offer a feed and need a statement import instead - MT940, CAMT.053 or the bank's own CSV. Ask which of these the product supports and whether they land in the same ledger.

5. How are wires matched to notices? A capital call notice says "USD 150,000 on 17 November". The wire arrives on the 18th for USD 150,000 from the family's USD account. The software should match the two on amount, date and fund name, score the match, and hold anything ambiguous for human review - not leave the bookkeeper to do it in a spreadsheet.

6. What happens to everything else? Lifestyle and operating spend need categorising. A model that categorises with a confidence score and learns from corrections is useful; one that categorises silently is dangerous. Ask what the threshold for human review is and whether it can be changed.

On accounting

7. Is there a real ledger? Draft, approved and posted journals; debits equal credits; FX at the transaction date; an audit trail on every field. If the product cannot produce a trial balance per entity, it is a reporting tool, whatever the brochure says.

8. Can it feed the accountant's system? Most families keep a statutory general ledger in Xero, Sage, FreeAgent or a larger system. The platform should export approved journals into it rather than ask you to replace it.

On reporting

9. Are the numbers computed once? IRR on the portfolio page should equal IRR on the fund page should equal IRR in the quarterly report. If the calculations live in several places - a dashboard here, an export there, a spreadsheet for the board pack - they will drift.

10. Can you change the currency and the date? A multi-currency family needs every figure in the reporting currency at the right rate, and needs to look at the book as it stood on any past date. Both should be a header control, not a support ticket.

On the family

11. Does it understand ownership? A member's wealth is what they own through trusts, companies and partnerships, at the percentage they own it. Software that reports by account cannot answer the question a principal actually asks.

12. Who can see what? Roles per module, approval where you want it, and a record of every change. The platform will hold the family's most sensitive information; the access model deserves as much scrutiny as the charts.

Build, buy, or stay with the accountant?

Staying with the accountant works for a family with few managers and no appetite for its own team. The risk is that the family's view of its own wealth arrives quarterly, after the fact, in someone else's format.

Building is rarely the right answer any more. The extraction problem alone - reading hundreds of administrator formats reliably - takes years, and the maintenance never ends.

Buying is the default. The selection question is which category of product, and that follows from the loops above: if the family's problem is reconciliation and control, choose an operating platform; if the book already arrives clean, a reporting layer may do.

How to run a selection in eight weeks

1. Week 1 - Write down the loops. List every document type you receive, every bank and custodian, every entity and who owns it, and every report you produce. This is the specification; most families have never written it down.
2. Weeks 2-3 - Shortlist by category. Decide reporting tool or operating platform first. Then three vendors at most.
3. Weeks 4-6 - Test on your own documents. Send each vendor a month of real (or redacted) statements, notices and bank files and ask them to load it. A demo on the vendor's data tells you about the vendor's data.
4. Week 7 - Check the chain. Pick five figures from the resulting reports and ask each vendor to show you the document behind each one.
5. Week 8 - Talk about the team. Who will do the daily review? How long does onboarding take, and who does it? What does the first year cost, all in?

What Tributom One does

Tributom One was built as an operating platform for exactly the loops above. Documents from 40-plus administrator formats are read deterministically and boxed on the page for review; bank feeds and statements land in one ledger; wires are matched to notices automatically; journals move through draft, approved and posted with a field-level audit trail; and the Reporting Centre, the liquidity forecast and Report Studio all read the same register. The pages linked below show each area with real screens.