Transfer Agent Data Integration: Unifying TA, Fund, and Firm Data
Your transfer agent owns the shareholder record. Your firm needs that data connected to CRM, advisory portfolios, and fund accounting — without waiting on the TA's reports.
Sales flows, 12b-1 payments, advisor-of-record relationships, omnibus vs direct — transfer agent data drives it all. Milemarker brings it into the firm's Snowflake warehouse continuously.
A mutual fund transfer agent is the service provider responsible for maintaining the fund's shareholder record — processing purchases and redemptions, disbursing dividends and capital gains, calculating commissions and 12b-1 fees, producing tax reporting (1099-DIV, 1099-B, 5498), sending statements, and supporting shareholder services. Some shareholder accounts are held "direct at fund" (one shareholder per TA record), while others are held in omnibus (a single platform-level account at the TA represents many end-investors). Major mutual fund TAs include DST, Ultimus, ALPS, SS&C GIDS, Huntington, and BNY.
The Transfer Agent Data Problem
The transfer agent owns the shareholder record — but the fund sponsor runs the business. Sales and distribution teams need flows visibility to manage wholesalers and platforms. Operations teams need reconciliation between the TA and the fund admin. CFOs need 12b-1 and sub-TA payment oversight. And everyone needs to map shareholder records to the firm's own CRM and advisory data to see the full relationship.
Today, most of that visibility arrives as TA reports: PDFs, batch files, or dashboards pulled a day or two after the activity. Flows arrive in summary form. Gross, net, net new, and reinvestment-adjusted flows get calculated differently by different teams. Sales leadership often learns about a large redemption from the wholesaler calling, not from the dashboard.
Omnibus accounts compound the problem. A single omnibus account at the TA — representing, say, a platform with 500 advisors and 20,000 end-investors — hides all of the advisor-of-record detail behind a rep-code or branch-code breakdown that may or may not be delivered in the daily file. Sponsors that want to know flows by advisor, by branch, or by relationship have to decompose the omnibus themselves.
12b-1 and sub-TA payments need their own reconciliation. The TA calculates 12b-1 against shareholder positions; the sponsor pays platforms based on sub-accounting files that may not agree with the TA's calculation down to the penny. Tying shareholder positions, 12b-1 calculations, and actual payments together requires the fund's flow data, the platform's sub-accounting data, and the TA's ledger to live in the same queryable place.
And nobody has a unified client view. A household that holds shares direct-at-fund, through an advisor on a wirehouse platform, and in an advisory account with the sponsor's RIA appears as three unrelated records across three systems. The sponsor sees the TA record, but can't see the advisory relationship alongside it.
What TA Data Integration Requires
01
Daily Shareholder Activity Feed
Purchases, redemptions, exchanges, dividend reinvestments, and cash balances from the TA in a structured daily feed — not a PDF assembled the next morning.
02
Omnibus Decomposition
Rep, branch, and broker code resolution against omnibus flows so sponsors can see activity at the advisor, firm, and relationship level — not just at the platform level.
03
Advisor-of-Record Linkage
TA accounts joined to the firm's CRM using rep, branch, and tax ID matching so every shareholder has an attached advisor, firm, and relationship record.
04
12b-1 & Sub-TA Payment Flow
TA-calculated 12b-1, sub-TA payments to platforms, and shareholder positions reconciled continuously — with variances surfaced rather than discovered at month-end.
05
Tax Reporting Alignment
1099-DIV, 1099-B, and 5498 data from the TA joined to shareholder records so the sponsor can answer tax questions from data rather than from the TA's support line.
06
Direct-at-Fund + Platform Reconciliation
Direct shareholder activity and omnibus platform activity reconciled into one picture of total fund flows, holdings, and shareholder distribution.
How Milemarker Integrates TA Data
Milemarker ingests transfer agent data via SFTP or API from the major mutual fund TAs — DST, Ultimus, ALPS, SS&C GIDS, Huntington, BNY — and normalizes it into a unified shareholder, account, and activity model inside the firm's Snowflake warehouse. Positions, transactions, dividend records, and 12b-1 detail all share the same schema, regardless of which TA produced the file.
Omnibus decomposition uses rep, branch, and broker codes from the TA file, supplemented by sub-accounting feeds from the platforms themselves where they're available (NSCC, DTCC, and direct platform feeds). The goal is to get from "flows at Platform X" to "flows at Advisor Y on Platform X" — at the level of granularity the TA and the platform actually support.
Shareholder records join to the firm's advisory CRM — Salesforce, Wealthbox, Redtail, HubSpot, or internal systems — to create the unified client view. A household that holds the sponsor's funds three different ways finally appears as one household, with all three relationships visible. For firms like Flat Iron Wealth that sponsor funds and operate an affiliated RIA, this is often the single most valuable aggregation.
Navigator AI lets sales, operations, and finance ask questions in plain English. "Show me net flows by advisor this week." "Which platforms had redemptions above $5M yesterday?" "What's our 12b-1 accrual for Share Class A year-to-date?" "How many direct-at-fund shareholders do we have by state?" Answers come from the firm's warehouse with lineage back to the TA feed.
Milemarker Relay automates the coordination. Sub-TA payment reconciliation, advisor notifications on large redemptions, 12b-1 accrual confirmations, and platform relationship reviews become workflows that run on the warehouse rather than projects that someone in ops has to drive every month.
Before Milemarker
Flows arrive as PDFs a day or two late
Omnibus hides advisor-of-record detail
Shareholder record and advisory CRM disconnected
12b-1 reconciliation done monthly in Excel
No unified gross vs net vs net new definition
Large redemptions discovered by phone
With Milemarker
Daily shareholder activity in the warehouse
Omnibus decomposed to advisor level
Shareholder records joined to CRM
12b-1 and sub-TA payments reconciled continuously
One flow definition, queryable by any cut
Large redemption alerts routed automatically
Who This Is For
Mutual Fund Sales Teams
National sales managers, regional VPs, and wholesalers need continuous visibility into flows by platform, by advisor, and by relationship. A unified TA data layer turns daily flow reports from a lagging PDF into a live, queryable view that drives territory calls, platform reviews, and wholesale deployment.
Fund Operations Teams
The ops team responsible for reconciliation between the TA and the fund admin, for 12b-1 accruals, for omnibus breakdowns, and for platform settlement gets a structural lift. Work that was reactive and report-driven becomes continuous and exception-driven, with Relay routing exceptions instead of people emailing PDFs.
CFOs Tracking Flows and Payments
CFOs at fund sponsors — especially those at firms like Flat Iron Wealth that run proprietary funds alongside an RIA — need oversight of revenue (net flows × fund economics) and distribution expense (12b-1 + sub-TA). Milemarker gives the CFO one place to see both sides of that equation without adding finance headcount to reconcile between systems.
Sponsors with Omnibus Relationships
Fund complexes with significant assets held in omnibus at platforms, wirehouses, and broker-dealers have the biggest advisor-of-record visibility problem. Milemarker's decomposition closes the gap so the sponsor can see, manage, and serve the advisor relationships behind the platform aggregate.
Frequently Asked Questions
Does Milemarker replace the transfer agent?
No. The TA continues to own shareholder recordkeeping, purchase and redemption processing, dividend disbursement, commissions, 12b-1 fees, tax reporting, and statements. Milemarker ingests the TA's output and normalizes it alongside the firm's advisory CRM, portfolio, and fund accounting data so the sponsor has continuous visibility into flows and shareholder activity.
What TAs do you integrate with?
Milemarker integrates with the major mutual fund transfer agents — DST, Ultimus, ALPS, SS&C GIDS, Huntington, BNY — as well as TAs operated by smaller fund complexes. Integration is typically via SFTP or batch file feed and brings in shareholder activity, positions, dividend records, 12b-1 detail, and tax reporting data.
How do you handle omnibus accounts?
Omnibus accounts consolidate many end-investors under a single platform-level account at the TA, which obscures advisor-of-record detail. Milemarker decomposes omnibus activity using rep, branch, and broker codes from the TA feed and — where available — sub-accounting files from the platform, so the sponsor can see flows and assets down to the advisor or relationship level.
Can you link TA data to our CRM?
Yes. Milemarker joins TA shareholder records to the firm's advisory CRM (Salesforce, Wealthbox, Redtail, HubSpot, or internal systems) using account, rep, and branch identifiers plus tax ID matching where appropriate. The result is a unified client view that pulls mutual fund holdings, advisory assets, and CRM activity into the same record.
What about 12b-1 payments?
12b-1 fees and sub-TA payments are among the most common reconciliation headaches for fund sponsors. Milemarker ingests the TA's 12b-1 calculation and the sub-TA payment feeds, joins them to shareholder positions and advisor-of-record records, and surfaces variances continuously. Milemarker Relay can route exceptions to operations for investigation and automate payment confirmations.
How often is data refreshed?
Refresh cadence depends on the TA's feed capability. Most major TAs support daily delivery of shareholder activity, positions, and cash. Dividend and 12b-1 data usually arrives on the TA's monthly or quarterly cycle. Milemarker normalizes whatever cadence the TA supports into the firm's Snowflake warehouse so the data is current relative to the source.
What about privacy and shareholder data?
Shareholder data — including personally identifiable information — is handled under the firm's existing privacy policies and Regulation S-P obligations. Data is stored in a Snowflake instance the firm owns. Milemarker maintains SOC 2 Type II certification. Role-based access controls limit visibility to appropriate personnel, and full lineage supports audit and regulatory examination.
Related guides
Part of the Wealth Operations series:
Data Platform for '40 Act Fund Sponsors: Unifying Fund Admin, Transfer Agent, Sub-Advisor & Custodian Data
NAV Reconciliation Automation for '40 Act Funds
Fund Accounting Data Platform for '40 Act Fund Sponsors
CFO Data Platform for Firms with Proprietary '40 Act Funds
Data Migration for RIAs: Moving CRM, Custodian & Portfolio Data Without Breaking Everything
Data-Driven M&A Due Diligence for RIAs: Evaluate Acquisitions with Confidence




