Fund Accounting Data

Your Fund Admin Runs the Books. Your Business Runs on Them.

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

RELATED RESOURCES
Pillar Data Platform for '40 Act Fund Sponsors Operations NAV Reconciliation Automation Role CFO Data Platform for Fund Sponsors Compliance N-PORT Reporting Automation

See your fund accounting data — joined to the firm.

Start with a 30-minute strategy call. We'll map your fund admin relationships, expense cap structure, and sponsor-side data needs — and show you what a unified view looks like.