
Data Services
Multi-custodian data aggregation for advisors
Reviewed by Trevor Keast, Principal & Data Services Manager · Updated
- Daily custodian and trust-system feeds into APX, Axys, and other portfolio systems
- Account, security, and transaction mapping that holds up through new accounts, transfers, and corporate actions
- Daily cash and position reconciliation before data reaches combined client reports
- Help choosing between direct feeds, an aggregator, or your platform's own data service
From a CSSI customer engagement
Daily data feeds kept running through a move to Tamarac
When an APX client moved to Tamarac, CSSI's Data Services team set up the same daily data feeds to produce a format Tamarac accepts. The client pulls and processes that data daily.
Read the Tamarac data feed storyDefinitions
Which kind of data aggregation does your firm need?
Custodial data aggregation
Held-away account aggregation
Combined reports come last
How the work moves
From the old system to a verified cutover
- 01
Source data
History, accounts, and securities
- 02
Map and convert
Accounts, identifiers, and transactions
- 03
Validate
Balances and history reconciled
- 04
Cutover
Accepted, documented, and live
Aggregation approaches
Four ways to get multi-custodian data into one system
Scroll across to review all four columns.
| Approach | Best fit | What your firm owns | Typical failure points |
|---|---|---|---|
| Custodian direct feeds into your portfolio system | APX, Axys, or another accounting system with custodian interfaces. Advent Custodial Data, for example, delivers trade-date positions, transactions, and cash activity before the market opens on T+1. | Custodian account authorizations, the import, the security master, translation rules, and daily reconciliation. | New accounts missing from the feed. Unmapped transaction codes. Unknown securities. A late file that leaves yesterday's data in place. |
| Third-party aggregator or data vendor | Many custodians, held-away accounts, or a source your system cannot reach directly. ByAllAccounts, for example, aggregates positions, transactions, prices, and tax lots through user-permissioned connections. | Account permissions, reconnections, mapping the delivered format, and reconciliation. | A connection stops when a login changes. Coverage varies by institution. Identifiers do not match your security master. |
| Platform-native aggregation | Firms on a platform that runs its own custodian connections. Orion reconciles brokerage data with custodians overnight. Addepar connects directly to custodians. Black Diamond includes outsourced daily reconciliation. | Clean account opening and linking, reviewing the exceptions the platform raises, and any source outside its network. | Uncovered sources. History and cost basis at conversion. Firm-specific treatments that must fit the platform's model. |
| Managed or outsourced feed processing | Firms keeping their current system without staffing the daily feed and reconciliation work, or needing cover for a key person. | Approving the reconciled result, the exception policy, and telling the provider about new accounts, transfers, and closures. | Unclear ownership of breaks. Late notice of new accounts or transfers. Procedures that live in one person's head. |
Where CSSI helps
Feeds, reconciliation, and combined reports for firms with several sources
Setup
How a multi-custodian feed gets set up
Inventory sources and accounts
List custodians, trust systems, held-away sources, and the target system. Note which accounts are not yet on a feed.Choose a path for each source
Use a direct feed, an aggregator, the platform's own connection, or managed processing. Confirm coverage, fields, history, and delivery time with a sample.Map and translate
Map accounts and securities. Translate each source's transaction codes, including transfers, fees, and corporate actions, into the target system's types. Replay a sample period.Reconcile, then report
Compare cash and positions with each source daily. Agree tolerances, exception owners, and what holds a combined report. Add sources once the first ones run clean.
Project outputs
What a feed project should leave you with
Source and feed inventory
Mapping tables
Reconciliation procedure
Exception log and release rules
Connected services
When the problem sits next to the feed
Investment reconciliation services
Investment data management
Portfolio data migration
Sources
Vendor details referenced on this page
Questions
Frequently asked questions
What is custodial data aggregation?
It is the daily collection of positions, transactions, and cash from each custodian and trust system a firm uses. The data is loaded into one portfolio accounting system and reconciled, so the firm works from a single book of record.
How do RIAs aggregate data from multiple custodians?
Most use a mix: direct custodian feeds into the portfolio system, a third-party aggregator for sources without a feed, or a platform such as Orion, Addepar, or Black Diamond with its own connections. Each still needs mapping, transaction translation, and daily reconciliation.
What is the difference between account aggregation and custodial feeds?
Custodial feeds come from the institution holding the assets, under the firm's custodial relationship. Account aggregation usually reaches accounts the firm does not hold, through connections the account owner permits. Feeds typically support the accounting book. Held-away data often supports reporting and planning.
Is financial data aggregation the same as open banking?
Not for an advisory firm. Open banking services such as Plaid, MX, and Yodlee let consumers share bank and card data with apps. Advisors need custodian positions, tax lots, transactions, and corporate actions reconciled to a portfolio system.
How should a combined report handle different source dates and transfers?
Document the reporting date and basis, and the as-of date of each source. Agree how late records and missing prices affect release. A transfer between custodians can post on different days at each end, so trace it through both accounts before the combined view goes out.
Can CSSI handle our custodian feeds if we keep our current portfolio system?
CSSI's data and BackOffice services are scoped around the system a firm already runs. Published work covers APX, Axys, and Tamarac. Coverage for your custodians and trust systems is confirmed during scoping.
Keep exploring
Related Data Services pages
Next step
