For a family office with many entities, the investment picture and the accounting picture are often two different stories. This is a walkthrough of how one family uses MYFO and its NetSuite integration to turn investment activity into journal entries, close the books faster and make the two finally agree.
The structure
This family office runs a structure that has grown over two decades: a top holding company, several investment LLCs, family trusts for each branch, a charitable foundation, a real estate holding entity and an operating business. In total, more than fifteen entities, each with its own books.
The office keeps its accounting in NetSuite, with each entity set up as a subsidiary under one chart of accounts. Investments are held across multiple custodians and banks, plus a book of LP positions and direct private investments. Money moves between entities constantly through intercompany loans, management fees, capital contributions and distributions.
The month-end problem
Before MYFO, the office’s controller spent the first two weeks of every month keying journal entries.
Every trade, dividend, interest payment, fee, capital call, distribution and intercompany transfer had to be found on a custodian statement, bank statement or fund notice, coded to the right entity and GL account, and entered into NetSuite by hand. Market value adjustments were calculated in a spreadsheet and booked as a single entry per account.
The work was slow, but the bigger problem was trust. Errors surfaced at quarter-end, when the books didn’t tie to the investment reports. The family’s investment team and its accounting team were looking at the same assets and getting different answers.
One source of data for both views
MYFO already brought in the family’s investment data: custodial feeds from its brokerage accounts, bank statements, and fund notices and capital account statements forwarded by email. Every transaction sits in MYFO, linked to its account, asset and entity in the entity map.
With the NetSuite integration, that same data now feeds the general ledger. NetSuite remains the office’s books of record; MYFO prepares what goes into them. The investment view and the accounting view are built from one set of transactions, so they agree by design.
Journal entries, generated automatically
During setup, MYFO mapped each entity to its NetSuite subsidiary and each type of activity to the right GL accounts using the office’s own chart of accounts. Dividends, interest, realized gains, fees, capital calls, distributions and unrealized gains each have a rule.
From there, MYFO generates journal entries automatically as activity comes in, in NetSuite’s format, coded to the right subsidiary and account. Intercompany movements are booked on both sides. Market value adjustments are calculated position by position instead of in a side spreadsheet.
Entries are posted for the controller’s review and approval rather than straight to the ledger. The controller’s job changed from typing entries to reviewing them.
“Our controller went from data entry back to being a controller. The books and the portfolio finally tell the same story.”
Clean data before it reaches the ledger
Automating journal entries only helps if the underlying data is right. A bad custodial record that would once have shown up as a wrong number on a report can now become a wrong entry in the books.
MYFO holds incoming data before it enters the system and reviews it first. Reconciliation issues are flagged for the team, such as a position showing 15 units against 12 reconciled, which points to a missing transaction. Feeds that arrive with temporary zero values, which custodians usually correct within hours, are held until the corrected values arrive. Only reconciled data turns into journal entries.
A built-in audit trail
Every journal entry generated from MYFO links back to its source: the custodian transaction, the bank line or the fund notice in the Vault. When auditors ask what supports an entry, the controller opens it and the document is there.
Year-end audit preparation, which used to mean assembling binders of statements, now starts from a ledger where every investment entry is already documented.
What this makes possible
For this family office, the result is a month-end close measured in days instead of weeks, a general ledger that ties to investment reporting and an audit trail that builds itself. The controller has time back for the work that needs judgment: tax planning, entity cleanup and cash management across the structure.
That matters when the family restructures, when a trust needs its own financials or when the office adds another entity. These moments reward offices whose accounting and investment data already agree.
MYFO is not a replacement for a controller’s judgment. It is the infrastructure that removes the manual work between the portfolio and the ledger, so that judgment is spent where it matters.
If your family office runs on NetSuite and wants to see how MYFO works in practice, book a call.