CFO Data Platform for Firms with Proprietary '40 Act Funds
CFOs running firms with their own mutual funds or ETFs juggle fund-level P&L, expense caps, advisor comp on flows, and advisory revenue — in separate spreadsheets. Milemarker unifies it.
Fund-level economics, advisory revenue, advisor comp on fund flows, expense cap waivers — CFOs at fund-sponsoring firms manage two financial stacks. Milemarker joins them.
The CFO at a '40 Act fund-sponsoring RIA or asset manager runs two financial stacks at once. On the advisory side: client AUM, advisory fee revenue, advisor comp, operating overhead. On the fund side: fund management fees, 12b-1 and sub-TA, distribution-related revenue, fund-level operating expenses, expense cap waivers and potential recoupments. Revenue lines are economically different. Expense allocations flow differently. Advisor comp on flows into proprietary funds crosses both stacks. The board fee committee asks about the fund side; the firm's ownership asks about the combined picture. Almost nobody gets to that combined picture without Excel.
The Fund Sponsor CFO Problem
The advisory billing system says one thing. The fund administrator's report says another. The transfer agent's flow file says a third. Advisor comp sits in a spreadsheet. The firm ERP — NetSuite, Sage Intacct, or QuickBooks — captures operating expenses but has no concept of fund-side economics. Even at well-run firms, the combined picture across these sources requires the CFO's office to assemble it by hand, usually monthly, often at month-end under deadline.
Expense caps are the quiet tax on CFO time. A fund may have a contractual expense cap of 95 basis points, a current expense ratio of 92 basis points, a waiver obligation that has accumulated over the last three years, and a recoupment window that closes at various dates. Tracking that in a spreadsheet is possible. Tracking it while also closing the month and preparing the board packet is a different order of difficulty — and recoupment windows get missed because no one has the bandwidth to watch them daily.
Fee committee meetings amplify the gap. The board expects a fund-level P&L walk, an expense ratio change explanation, a peer comparison, and a waiver status review — on a cadence that often outpaces what the admin can produce without a dedicated ask. Preparing the packet becomes a project rather than a report. And because the packet lives in Excel, version-control and approval history are fragile.
Advisor comp tied to flows into proprietary funds is another persistent gap. Flows settle at the transfer agent. Comp structure lives in HRIS. Actual payouts happen in the payroll system. Joining them requires a spreadsheet that the CFO's office maintains by hand — and explaining a single comp adjustment often means walking three systems. When the firm grows, the spreadsheet breaks.
What a CFO-Grade Fund Data Layer Requires
01
Consolidated Firm + Fund Revenue
Advisory fee revenue, fund management fees, 12b-1, sub-TA, and distribution revenue in one structured view — with allocations clean across advisory and fund sides.
02
Expense Cap & Waiver Ledger
Cap, current ratio, waiver balance, and recoupment windows in the same data model — with event-driven alerts before deadlines slip.
03
Advisor Comp Tied to Flows
Comp accruals tied to actual settled flows from the TA — not reconstructed in a spreadsheet from payroll and CRM.
04
Distribution Economics
Distribution-side revenue, 12b-1 payouts, intermediary economics, and DCIO arrangements structured for CFO review.
05
Fund-Level P&L
Fund-by-fund, share-class-by-share-class P&L built from admin GL and sponsor-side allocations — ready for board fee committee.
06
Scenario Modeling
"What if AUM grows 15% and the waiver stays in place?" "What if we breakpoint at $500M?" Modeling from the actual data, not a detached Excel.
How Milemarker Works for CFOs
Milemarker ingests fund admin GL from Ultimus, SEI, ALPS, SS&C, BNY Mellon, State Street, and Atlantic alongside TA flow data from DST, Ultimus, or SS&C GIDS. Advisory-side data from the billing system, CRM, and custodians flows into the same warehouse. HRIS comp data joins through 130+ integrations. Firm GL from NetSuite, Sage Intacct, or QuickBooks completes the picture. The sponsor's Snowflake warehouse becomes the single structured source for firm-plus-fund economics.
Navigator AI sits on top of that warehouse as the CFO's query layer. "Walk me through this month's fund P&L variance" is answered against actual admin GL, accrual detail, and the attribution logic the CFO defines. "What's our recoupment exposure if the waiver renews?" runs on the actual waiver ledger. "How did Flat Iron Wealth's comp payout move quarter-over-quarter, and what flows drove it?" is answered across HRIS and TA data in the same query.
Milemarker Relay handles the operational side. Recoupment window approaching? Alert routed to CFO and outside counsel. Waiver renewal due? Automated packet sent to the approval chain. Month-end comp calculation? Event-driven workflow runs against settled flows and writes back to payroll. Board fee committee date? Packet assembly begins automatically from the same data the CFO reviews internally. Every step is audit-logged inside the firm's SOC 2 Type II posture.
Critically, the firm owns its data layer. The Snowflake warehouse is the firm's. Historical admin data, comp history, and waiver ledger stay in firm-controlled infrastructure through fund admin changes, TA transitions, or acquisitions. Auditors and examiners access a consistent source, and the CFO's reporting is not hostage to any single vendor's data cadence.
Before Milemarker
Advisory + fund stacks reconciled by hand
Expense caps tracked in Excel
Recoupment windows missed
Advisor comp calculated in a spreadsheet
Fee committee packets rebuilt every quarter
No consolidated firm + fund P&L
With Milemarker
Firm + fund joined in one warehouse
Expense cap ledger in the data model
Relay alerts on recoupment windows
Comp calculated on actual settled flows
Fee committee packets from one source
Consolidated firm + fund P&L on demand
Who This Is For
CFOs at RIAs Sponsoring Mutual Funds
RIAs that run their own proprietary mutual fund lineup — often born out of a preferred investment strategy that scaled beyond SMAs — sit at the intersection of advisory-side economics and fund-side regulatory structure. CFOs at these firms need a data layer that respects both. Milemarker's sponsor-side model was designed around this combined picture.
CFOs at Asset Managers with '40 Act Products
Asset managers running a fund complex — whether alongside SMAs, institutional mandates, or sub-advised relationships — need CFO-grade visibility across every revenue source the firm generates. Milemarker joins fund-side fee revenue, distribution-side economics, and advisory-side revenue without pushing the firm to replace the admin, the TA, or the firm ERP.
Controllers at Fund Complexes
Controllers responsible for close, intercompany allocations, and fund-versus-firm expense treatment need a structured source for fund-side activity that joins cleanly to firm ledgers. Milemarker delivers that structured source without requiring a GL migration or a new ERP.
FP&A at Multi-Channel Firms
FP&A teams modeling firm economics across advisory, fund, and distribution channels benefit most from a single queryable source for all three. Milemarker gives FP&A a sponsor-side warehouse that supports scenario modeling against actual data rather than exported snapshots.
Frequently Asked Questions
Does this replace our ERP or accounting system?
No. NetSuite, Sage Intacct, and QuickBooks remain the firm's accounting system, and the fund administrator remains the fund-level GL. Milemarker sits above both — ingesting firm and fund GL, advisory billing, TA flows, and HRIS data — and joining them into a firm-owned Snowflake warehouse the CFO can query and report from.
How does this handle expense caps and recoupments?
Expense cap arrangements, current waiver balances, and recoupment windows live in a structured ledger alongside the admin's expense data. CFOs can see cap versus actual ratio, waiver consumed, and recoupment windows about to open or close — with Milemarker Relay sending alerts before deadlines so recoupment opportunities don't quietly expire.
What about advisor comp on flows?
Firms that sponsor their own funds often pay advisor comp tied to flows into the proprietary lineup. Milemarker joins TA flow data to the advisory-side CRM and HRIS comp structure, so comp can be calculated against actual settled flows rather than manually reconciled. Comp accrual, payout, and adjustment trail lives in the same data model as the revenue it relates to.
Can this feed our board fee committee deck?
Yes. Fund-level P&L walk, expense ratio change attribution, waiver and recoupment detail, and distribution economics can be generated from the same data that drives internal CFO reporting. That means board fee committee decks and 15(c) packets draw from one reviewed source, not a separately rebuilt spreadsheet.
How does firm-owned Snowflake help CFOs specifically?
CFOs at fund-sponsoring firms carry audit, SOC, and compliance accountability. A firm-owned Snowflake instance means the data lives in infrastructure the firm controls — clear access logs, SOC 2 Type II posture, no vendor lock-in on data access. Auditors and examiners see a consistent source of truth rather than a patchwork of vendor portals.
What about audit trail?
All data pulled into the warehouse retains source lineage — which admin file, which billing system export, which HRIS snapshot. Every change routed through Milemarker Relay carries an audit record: who approved it, when, and what downstream systems received the update. For both SEC examinations and SOC audits, that trail is queryable rather than reconstructed.
Implementation timeline?
Most fund-sponsoring firms see firm and fund admin data flowing within 2–4 weeks. Full implementation — including advisor comp, expense cap waiver ledger, and board-ready fund P&L views — typically takes 6–10 weeks depending on complexity. The timeline is driven primarily by admin data delivery and firm-side source system access.
Related guides
Part of the Finance & Compliance Ops series:
Data Platform for '40 Act Fund Sponsors: Unifying Fund Admin, Transfer Agent, Sub-Advisor & Custodian Data
Fund Accounting Data Platform for '40 Act Fund Sponsors
Transfer Agent Data Integration: Unifying TA, Fund, and Firm Data
Proprietary Mutual Fund Operations: The Complete Sponsor-Side Data Stack
The Rollup CFO's Playbook: Rapid Integration, Standardized Operations & Scale Economics
Fee Billing Reconciliation for RIAs: Automate Advisory Fee Calculations





