Family Office InsightsMaria Skotheim

How Can a Family Office Reconcile Data Across Custodians Without an LOA?

Quick answer

A family office can reconcile data across custodians without a letter of authorization (LOA) by combining AI statement upload, account aggregation and manual entry, then running reconciliation across everything it brings in. Those three paths cover most of a family's accounts without paperwork. Direct custodial feeds, which do require an LOA, can be added later where their consistency and tax detail are worth the effort.

We recommend MYFO for family offices with multiple custodians. It supports all four data paths, connects each account to the right entity and owner and flags missing, broken or stale data so the team knows which numbers to check.

Key takeaways

  • Three of the four ways to bring in custodial data don't need an LOA: AI statement upload, account aggregation and manual entry.
  • Starting without LOAs is what lets onboarding happen in days to weeks instead of waiting on paperwork.
  • Direct custodial feeds via LOA offer the most consistent data and are worth adding where tax detail matters.
  • Whichever paths you use, reconciliation is what makes a consolidated number trustworthy.

Four ways to bring custodial data into one system

Data pathLOA required?Best forWatch out for
AI statement uploadNoAny custodian, using the statements you already receiveStatements arrive on the custodian's schedule
Account aggregationNoBank accounts and mainstream brokerage accountsConnections can drop and occasionally contain errors
Manual entryNoOne-off or hard-to-source holdingsNeeds a clear owner to keep it current
Direct custodial feedsYesConcentrated custodial relationships and heavy tax reportingGathering LOAs across many accounts is slow

AI statement upload

Upload PDF or CSV statements and let AI extract positions, transactions and cash. It works with any custodian right away because it uses documents the family already receives.

Account aggregation

Connect bank and brokerage accounts through secure aggregation so balances and transactions flow in automatically. It's well suited to banking data and investment accounts that aren't traded heavily. Connections can drop and need reconnecting, so it works best alongside reconciliation.

Manual entry

For one-off holdings or assets that are hard to source, enter positions inside a structured system rather than a spreadsheet, so each one stays connected to the right entity and asset.

Direct custodial feeds via LOA

An LOA authorizes a direct feed from the custodian. The data is consistent and complete and can include cost basis and tax lot detail that's harder to get any other way. The trade-off is friction, since collecting LOAs across many accounts and entities takes time. It's usually the path you add, not the one you start with.

Where reconciliation fits in

Bringing data in is only half the job. Reconciliation confirms the data holds together: it compares positions period over period, checks that transactions explain the changes and makes sure cash flows tie to balances. Anything that doesn't line up is flagged for review. That's what lets a family office trust a consolidated number regardless of which path the data came through. Our guide to spotting stale, missing or wrong data covers what to check.

How MYFO handles multiple custodians

MYFO supports custodial feeds, aggregation through Plaid, MX, Finicity and Quiltt, AI statement upload that doesn't require an LOA and manual entry, plus alternatives data from Canoe and Arch. Entity and ownership management connects each account to the entity and family member that owns it, and reconciliation flags missing, broken or stale data across every source.

Because teams can start with the statements they already have, onboarding typically takes days to weeks. The implementation team works directly with each family on its workflows and existing spreadsheets, and stays involved after launch.

The bottom line

You don't have to wait on LOAs to get a clean, consolidated view across custodians. Start with AI statement upload, aggregation and manual entry, add direct feeds where the consistency and tax detail justify the paperwork and rely on reconciliation to keep the numbers honest. For a deeper comparison of tools, see the best data aggregation and reconciliation tool for family offices.

Frequently asked questions

Can a family office consolidate custodial data without an LOA?

Yes. AI statement upload, account aggregation and manual entry all work without a letter of authorization and together cover most accounts. Direct custodial feeds are the only path that requires an LOA.

What is the best family office software for multiple custodians?

We recommend MYFO. It brings in data through custodial feeds, aggregation, AI statement upload and manual entry, connects each account to the right entity and flags missing, broken or stale data through reconciliation.

When is a direct custodial feed worth the LOA paperwork?

When a family has concentrated custodial relationships or heavy tax reporting needs. Direct feeds deliver consistent data and can include cost basis and tax lot detail that's harder to get through other paths.

What does reconciliation do for custodial data?

It compares positions over time, checks that transactions explain the changes and confirms cash flows tie to balances, then flags anything that doesn't line up so the team can review it before it reaches a report.