NAV, GL, expenses, waivers, distributions — your fund administrator is the system of record. But the firm needs that data joined to sales, compliance, and executive dashboards.

Fund accounting for a '40 Act mutual fund or ETF covers daily NAV calculation, the fund-level general ledger, expense accruals and waivers, distributions, capital stock activity, financial statement preparation, and tax allocations. In nearly every case, this work is performed by a third-party fund administrator — Ultimus, SEI, ALPS (including the SS&C ALPS business), SS&C, BNY Mellon, State Street, Atlantic, and a handful of others. The administrator owns the books. But the sponsor still needs that accounting data connected to sales flows, advisory data, CRM activity, compliance reporting, and executive dashboards — and that connection is rarely automatic.

The Fund Accounting Data Problem

The administrator runs the books. But the firm — the sponsor — has to answer questions the books alone cannot answer. What drove this month's expense ratio change? How much did the waiver cost us this quarter? How do fund flows correlate with campaigns, wholesaler activity, or advisor-channel coverage? Where do we stand on recoupment windows? The admin's reporting system is optimized for producing financial statements and regulatory filings, not for cross-functional firm reporting.

In practice, the monthly fund accounting package arrives as portal PDFs, pivot-table exports, or static Excel files. GL detail needs to be rekeyed or transformed before it can join to anything else the firm tracks. Sales flow data from the transfer agent lives in one system, wholesaler attribution in another, and the admin's expense files in a third. Joining them to answer a single executive question becomes a multi-day analyst project.

Expense cap waivers and reimbursements sit in a spreadsheet that the CFO, fund controller, and outside legal update by hand. Waiver renewals slip past deadlines. Recoupment windows close unnoticed. Expense ratio movement between months gets explained after the fact — which makes board fee committee conversations harder than they need to be. The data exists. It is just scattered across vendors, formats, and cadences.

Meanwhile, the board expects explanations faster than the admin's normal cycle allows. "Why did the expense ratio move?" and "What is our AUM walk by share class?" should be answerable in hours, not at the next quarterly packet drop. When the answer requires pulling three exports and rebuilding a spreadsheet, speed is not an option.

What a Sponsor-Side Fund Accounting Data Layer Enables

01

Continuous NAV & GL Feed

Daily NAV and GL detail flowing from the admin into a firm-owned warehouse — normalized and joinable, not static exports.

02

Expense Ratio + Waiver Tracking

Expense accruals, waiver arrangements, and recoupment windows structured together so the firm sees current ratio, cap, and waiver balance in one place.

03

Distribution Modeling

Distribution history, ex-dates, pay dates, and short- and long-term character data available for forecasting and 19(a) review.

04

Cross-Fund P&L

Fund-level P&L rolled up across the complex — by fund, by share class, by series — without a spreadsheet rebuild.

05

Joined to Sales and Flows

Fund accounting data joined to TA flows, wholesaler activity, and CRM so flow and expense conversations share a data source.

06

Executive Dashboards

CFO, fund CFO, and fund board views built on one source — not separately reconstructed for each audience.

How Milemarker Integrates with Fund Admins

Milemarker connects directly to the fund administrator — Ultimus, SEI, ALPS, SS&C, BNY Mellon, State Street, Atlantic — and ingests NAV, GL detail, expense accruals, waiver activity, distribution records, capital stock activity, and financial statement datasets on the cadence the admin provides. Daily where the admin runs daily. Monthly where the admin closes monthly. Milemarker does not replicate or replace the admin's system of record — it pulls the data out and structures it in a firm-owned Snowflake warehouse.

Once inside the warehouse, fund accounting data is joined to transfer agent flow data, advisory-side CRM activity, 130+ integrations across the wealth-tech stack, and internal systems like HRIS and the firm ERP. A fund's expense ratio is no longer isolated from the flows that drove AUM growth or from the comp arrangements those flows triggered. The data model treats the sponsor as the integration point, not any single vendor.

Navigator AI is the sponsor-side query layer on that warehouse. A fund CFO can ask "what drove our expense ratio up in Q2?" and Navigator walks through fee accrual, waiver consumption, AUM changes, and expense line detail from the admin's own data. "Walk me through the flow and expense pattern for our small-cap fund year-to-date" is answered against actual admin and TA data — not a generic template.

Milemarker Relay automates the operational workflows around fund accounting data. Waiver renewal deadlines trigger alerts to the CFO and outside legal before they lapse. Expense cap breaches route to a defined response workflow. Distribution data flows to the client portal, advisor desktop, and notification systems. All of it is audit-logged and fits inside the firm's SOC 2 Type II posture.

Before Milemarker

Admin data lives in portal PDFs

GL rekeyed to join to sales flows

Waiver tracking in a separate spreadsheet

Recoupment windows missed

Expense ratio explained after the fact

Board questions take days to answer

With Milemarker

Admin data structured in Snowflake

GL joined natively to flows and comp

Waivers in the same data model as GL

Relay alerts on recoupment windows

Expense ratio explained in real time

Board questions answered in hours

Who This Is For

Fund CFOs

Fund CFOs responsible for fund-level P&L, expense ratio, waiver economics, and board fee committee reporting need the admin's data structured into a model that supports cross-fund analysis and real-time questions. Milemarker gives the fund CFO a sponsor-side data layer that closes the gap between what the admin produces and what the board asks for.

Fund Ops Leaders

Heads of fund operations coordinate with the admin daily, manage service provider relationships, and sit between the admin, the TA, distribution, and the CCO office. A unified data layer reduces the amount of time the ops team spends reconciling exports and frees them to focus on service provider performance and fund complex strategy.

Fund Sponsors with Multiple Admins

Firms with funds spread across two or more administrators — often the result of acquisitions, sub-advisory relationships, or a series trust migration — face the additional challenge of different data models, different portal structures, and different reporting cadences. Milemarker normalizes all of them into one sponsor-side data model.

Sponsors Consolidating Fund Admin Relationships

Firms evaluating or executing a consolidation from multiple admins to a single admin benefit from a sponsor-side data layer that decouples firm reporting from any single vendor relationship. The warehouse persists through the transition. Historical data stays structured. Reporting does not have to be rebuilt every time the admin changes.

Frequently Asked Questions

Do you replace the fund administrator?

No. Ultimus, SEI, ALPS, SS&C, BNY Mellon, State Street, and Atlantic remain the system of record for daily NAV, GL, expense accruals, distributions, and financial statements. Milemarker ingests the data they produce and joins it to the sponsor-side view — sales flows, advisory data, CRM, HRIS — in a firm-owned Snowflake warehouse.

What fund administrators do you integrate with?

Milemarker ingests data from Ultimus, SEI, ALPS, SS&C (including ALPS-branded operations), BNY Mellon, State Street, and Atlantic. Integration approach varies — some admins provide direct feeds, others provide scheduled exports, others require portal-based retrieval that Milemarker automates. Each is evaluated during a strategy call.

How current is the data?

For daily NAV and position data where the admin provides a daily feed, the sponsor-side warehouse typically reflects T+1. GL detail, expense ratios, and waiver activity usually follow the admin's own reporting cadence — daily or monthly depending on the firm. Milemarker does not accelerate what the admin produces; it surfaces it faster to the rest of the firm.

Can this feed our board portal?

Yes. Once fund accounting data is structured in the sponsor-owned warehouse, it can be pushed to board portals, BI tools, or custom dashboards. Board books and 15(c) packets can draw from the same source as CFO reporting, which eliminates the Excel rebuild before each board meeting.

What about expense caps and waivers?

Expense cap arrangements, waiver terms, and recoupment windows are typically tracked in a spreadsheet separate from the admin's GL. Milemarker can structure the waiver ledger alongside the admin's expense data so the firm can see current expense ratio vs cap, waiver balance outstanding, and recoupment windows approaching — all on the same timeline.

How does this tie to our ERP or firm GL?

Fund-level GL comes from the admin. Firm-level GL usually lives in NetSuite, Sage Intacct, or QuickBooks. Milemarker ingests both and joins them — so firm-wide financials (advisory revenue plus fund management fee revenue, consolidated operating expenses, fund-side versus advisory-side allocations) can be reported from one data layer without replacing the ERP.

What about multi-series funds?

Multi-series and master-feeder structures are handled in the data model. Each series and share class is tracked with its own expense accruals, waivers, and distributions, and aggregation logic rolls them up to the fund and complex level. This makes multi-share-class expense ratio analysis and fee committee review meaningfully faster.

Related guides

Part of the Data Infrastructure series:

• Data Platform for '40 Act Fund Sponsors: Unifying Fund Admin, Transfer Agent, Sub-Advisor & Custodian Data

• NAV Reconciliation Automation for '40 Act Funds

• CFO Data Platform for Firms with Proprietary '40 Act Funds

• N-PORT Reporting Automation: Streamline Quarterly Form N-PORT Filings

• Data Platform for RIA Aggregators & Consolidators

• Custodian Data Aggregation: Unified Reporting Across Schwab, Fidelity & Pershing