The average independent RIA works with 2.4 custodians.

The average independent RIA works with 2.4 custodians. Each one exports data in a different format, with different field naming conventions, different delivery schedules, and different representations of the same events.

Schwab’s overnight file drops at 2am. Fidelity’s drops at midnight. Pershing delivers via SFTP on a four-hour delay. None of them represent a partial transfer the same way. For a firm working across three custodians, that is three separate reconciliation workflows, maintained independently, each one a point of failure.

Most firms build these workflows manually: usually in Excel, sometimes in Python, occasionally in custom middleware maintained by one person. Any format change on the custodian’s end quietly breaks the downstream process. One firm we work with discovered a six-week gap in their reconciliation data after a custodian format update. They found out at audit, not from their system.

Multi-custodian reconciliation is the ops problem that firms underestimate until something fails. At that point, the cost is measured in hours to diagnose, days to remediate, and an audit finding that requires explanation.

The firms that have solved this are not using fewer custodians. They have built a normalized data layer above the custodian tier so a format change upstream does not cascade downstream.