Fee billing reconciliation is the process of verifying that advisory fees charged to clients match what fee schedules dictate—based on accurate AUM calculations, correct household aggregation, and validated breakpoint tiers—across every custodian and every account, every billing cycle.
The Billing Reconciliation Problem
RIA fee billing looks straightforward on paper: charge a percentage of assets under management. In practice, executing that calculation correctly requires assembling accurate data from four different systems that were never designed to talk to each other.
AUM data lives in custodian portals—and most RIAs work with three or more custodians. Fee schedules live in billing systems or spreadsheets. Household relationships that determine whether a client qualifies for a breakpoint tier live in the CRM. The actual tiered breakpoint structures are buried in client contracts or advisory agreements.
Reconciling all of this manually every quarter creates an inevitable gap between what a firm should be billing and what it actually bills. That gap has a name: billing error. And billing errors flow in two directions. Some represent revenue leakage—clients underbilled due to missing accounts, incorrect AUM, or fee schedule changes not applied. Others represent overbilling—clients charged more than their agreement permits, creating refund liability, client complaints, and SEC scrutiny.
Why the Problem Compounds Over Time
The billing reconciliation problem is not static. It grows as the firm grows. Every new client adds another fee schedule to track. Every new custodian adds another data source to reconcile. Every fee schedule negotiation creates another set of custom breakpoints to apply. Every household restructuring—marriage, divorce, death, new accounts—creates another opportunity for aggregation errors to slip through.
A firm that manages 200 clients across two custodians has a manageable (if still risky) manual process. A firm managing 600 clients across four custodians with tiered fee schedules for every relationship tier has a process that is functionally impossible to execute accurately by hand.
Common Billing Errors at RIAs
Every firm experiences some version of these errors. The question is whether they are caught before or after the fee is debited—and whether there is an auditable record explaining how each calculation was made.
Incorrect AUM Calculation
AUM calculations fail when accounts are missing or when the wrong valuation date is used. Accounts held at a secondary custodian that was not included in the billing export, retirement accounts excluded from an advisory fee that should be included, and accounts opened after the billing data pull all create AUM understatements. AUM overstatements can occur when terminated accounts are not removed from the billing data or when accounts from different client records are accidentally consolidated.
Wrong Fee Tier Applied
Fee schedules typically include breakpoints: the first $1M is billed at one rate, the next $2M at a lower rate, and assets above $3M at a still-lower rate. If the AUM figure used for billing is incorrect, the client may be placed in the wrong tier. Even a correctly calculated AUM figure can trigger the wrong tier if the fee schedule in the billing system has not been updated to reflect a rate negotiated with the client or a schedule change applied to a client segment.
Household Aggregation Errors
Many fee schedules allow clients to aggregate accounts across family members—spouses, children, trusts, entities—to reach breakpoint thresholds. When accounts are not properly linked in the CRM, or when CRM household data is not synchronized with the billing system, accounts that should be aggregated are billed separately. A household with $2.5M across four accounts, where only $1.8M is linked to the household record in the billing system, may be billed at a higher tier than its agreement requires.
New Accounts Not Added to Billing
When a new account is opened at a custodian, it enters the billing workflow only if someone explicitly adds it. In manual workflows, this requires the operations team to notice the new account in the custodian feed, match it to the correct client record, link it to the household, and add it to the billing configuration. Each step is a failure point. Accounts that slip through are not billed—often for multiple quarters before anyone notices.
Terminated Accounts Still Billed
The reverse problem is equally common. When a client closes an account, transfers assets, or terminates the advisory relationship, billing should stop. In manual processes, a termination at the custodian does not automatically remove the account from billing. Unless the operations team maintains a process for catching terminated accounts in every billing cycle, those accounts continue generating fee debits—creating a client complaint and refund obligation when eventually discovered.
Fee Schedule Changes Not Applied
Fee schedules change: the firm revises its standard schedule, a client negotiates a custom rate, a client reaches a new relationship tier, or a promotional rate expires. Each change requires updating the billing configuration before the next cycle runs. Changes applied late, applied to the wrong client record, or not applied at all result in billing at the old rate rather than the current agreement rate.
The Cost of Billing Errors
Revenue Leakage from Underbilling
Underbilling is the most financially damaging category of billing error and the least visible. A firm that misses a new account, applies the wrong (lower) fee tier, or fails to update a fee schedule generates less revenue than its agreements entitle it to—without any immediate signal that something is wrong. Clients do not complain about being charged less. The error surfaces only when a reconciliation review or audit catches the discrepancy.
For a firm managing $1 billion in AUM at an average fee of 0.85 percent annually, a 2 percent underbilling rate means approximately $170,000 in revenue leakage each year. At $5 billion AUM, that figure exceeds $850,000 annually. Most leakage cannot be recovered retroactively—client agreements typically restrict back-billing, and the reputational cost of requesting retroactive fees often exceeds the amount owed.
Client Complaints and Refund Liability from Overbilling
Overbilling creates the opposite problem: visible, immediate client impact. A client who notices an unexpected debit, receives a fee that does not match their agreement, or gets billed for an account they closed will call—or escalate. Refunds must be issued, relationships must be repaired, and the firm must investigate how the error occurred and document the corrective action. High-value clients who experience overbilling errors are statistically more likely to initiate a review of the overall relationship.
SEC Scrutiny and Examination Risk
Fee calculation accuracy is among the SEC's most consistently cited examination findings. The Investment Advisers Act requires advisers to charge fees consistent with their advisory agreements and to disclose their billing methodology in the Form ADV. Examiners routinely request fee calculations for a sample of client accounts, compare them to fee agreement terms, and look for systematic errors that indicate process failures rather than isolated mistakes. Firms that cannot produce clear audit trails documenting how each fee was calculated face heightened deficiency risk—even if the dollar amounts involved are small.
Operational Burden
Beyond the financial and regulatory costs, billing errors consume disproportionate operational time. Each discrepancy discovered requires investigation: pulling the original data, retracing the calculation, identifying where the error entered the workflow, and determining whether other accounts were affected by the same root cause. A single error that turns out to be systematic—say, a fee schedule update that was not applied to an entire client tier—can require reviewing and recalculating dozens of accounts. The operations team that should be focused on client service and growth initiatives instead spends billing week and the weeks following it managing error investigation and remediation.
What Automated Fee Reconciliation Looks Like
Automated fee billing reconciliation replaces the spreadsheet-and-export workflow with a continuous validation pipeline that runs against live data. Here is how each step in the workflow changes:
Step 1: Pull AUM from Custodian Feeds
Rather than logging into three custodian portals and exporting position files manually, the platform pulls account and position data automatically through custodian data feeds—Schwab, Fidelity, Pershing, and others. Positions are normalized to a standard format, accounts are linked to the correct client records, and valuations are timestamped to the correct billing date. This data flows into the reconciliation pipeline daily, ensuring the firm always has current AUM data available rather than relying on the last export someone remembered to pull.
Step 2: Apply Fee Schedules from the Billing System
The platform connects to the firm's billing system or fee schedule database to retrieve the current fee schedule for each client. Fee schedule changes—rate adjustments, new breakpoints, custom negotiated rates—are reflected in real time as they are entered into the source system. The reconciliation engine applies the current fee schedule, not the schedule that was current at last quarter's billing cycle, eliminating the class of errors that comes from stale configuration data.
Step 3: Validate Household Aggregation from the CRM
The platform pulls household structure from the CRM—which accounts are linked to which households, which household members qualify for aggregation—and applies that structure to the AUM calculation. When household data is updated in the CRM, the billing reconciliation automatically reflects the change at the next calculation. Accounts added to a household, entities linked to a family relationship, and new accounts associated with existing clients are all captured without manual billing system updates.
Step 4: Calculate Expected Fees
With accurate AUM, current fee schedules, and validated household aggregation in place, the platform calculates the expected fee for each account and household. The calculation applies tiered breakpoints across the correct AUM base, prorates for billing period, and accounts for any minimum fees or fee caps specified in the client agreement. The expected fee calculation is logged with every input variable—AUM figure used, valuation date, fee tier applied, household AUM basis—creating an audit trail for every fee produced.
Step 5: Compare Expected to Actual Fees Debited
The platform compares the calculated expected fee to the actual fee debited from the client account and flags any variance that exceeds a defined tolerance. Variances are categorized: potential overbilling, potential underbilling, accounts not billed (new accounts missing from billing), accounts billed but not in AUM (terminated or excluded accounts). Each flagged item is routed to the operations team for review before the billing cycle closes—not discovered weeks later during a client conversation.
Step 6: Automated Discrepancy Flagging
Discrepancies surface in a reconciliation dashboard rather than buried in a spreadsheet. Each flagged item shows the expected fee, the actual fee, the variance amount, and the likely cause based on the data. Operations staff can resolve items directly in the dashboard, with every resolution decision logged. The platform tracks the status of each discrepancy from initial flag through investigation and resolution, producing a complete audit record of the billing cycle.
Manual vs. Automated Billing Reconciliation
The operational difference between manual and automated reconciliation is not marginal—it is structural. Here is how the two approaches compare across the dimensions that matter most.
How a Data Platform Enables Billing Automation
The reason manual billing reconciliation is so error-prone is not that the calculations are complex—the math is straightforward. The reason is that the inputs to the calculation live in separate systems with no native integration between them. A data platform solves the billing reconciliation problem by connecting those systems and making their data available to the reconciliation workflow in a normalized, current, and auditable form.
Unified Custodian Data Across All Accounts
A data platform with pre-built custodian integrations pulls account and position data from Schwab, Fidelity, Pershing, and other custodians through standardized data feeds. Every account at every custodian appears in a single, normalized data model. When a new account is opened, it appears in the platform automatically. When an account is closed or transferred, the platform reflects the change. The billing reconciliation engine always operates on the complete account universe—not whatever was included in the last export.
CRM Household Relationships Connected to Billing
The platform connects CRM household records to account data from custodians, creating a unified household view that spans all accounts regardless of where they are held. Household aggregation for fee calculation uses the same household structure that the CRM maintains for relationship management—ensuring the billing calculation reflects the client relationship as the firm understands it, not as it existed when billing was last manually configured. Changes to household membership in the CRM propagate to the billing reconciliation automatically.
Fee Schedule Data Integrated into the Calculation
The platform connects to the firm's billing system or fee schedule data source to retrieve current fee schedules for each client. Fee schedules are versioned—when a rate changes, the platform records when the change was effective and applies the correct rate to calculations for the relevant billing period. This versioning creates a clear record of what rate applied when, which is exactly what SEC examiners ask for when reviewing fee calculation methodology.
Automated Calculation and Reconciliation Pipeline
With all inputs connected and normalized, the platform runs the fee calculation and reconciliation automatically on a defined schedule—daily during billing week, or continuously as data is updated. The reconciliation output is a structured list of expected versus actual fees, with discrepancies categorized by type and routed to the appropriate operations team member for review. Every calculation input, calculation step, and discrepancy resolution is logged, creating the audit trail that compliance and examination require.
Multi-Custodian Coverage
Pre-built integrations with Schwab, Fidelity, Pershing, and more—no manual exports required from any custodian
CRM Household Sync
Salesforce, Redtail, Wealthbox household data applied automatically to every fee calculation
Fee Schedule Versioning
Every rate change logged with effective dates—correct fee applied to the correct billing period
Real-Time Discrepancy Flags
Variances surfaced before fees are debited, not discovered after client complaints
New Account Detection
Accounts opened at any custodian automatically enter the billing workflow—no manual addition required
Structured Audit Trail
Every calculation logged with inputs and outputs—reproducible for SEC examination on demand
SEC Compliance for Fee Billing
Fee billing accuracy is not only an operational priority—it is a regulatory one. The SEC's examination program consistently identifies fee calculation errors as among the most common compliance deficiencies at registered investment advisers. Understanding what examiners look for and how audit trails satisfy those requirements is essential for any firm that wants to manage examination risk proactively.
What the Investment Advisers Act Requires
The Investment Advisers Act of 1940 and the rules thereunder require registered investment advisers to charge fees consistent with the terms of their advisory agreements. The Form ADV Part 2A (the firm brochure) must describe the firm's fee calculation methodology, billing frequency, and any deductions from client accounts. Charging fees that differ from the disclosed methodology—whether higher or lower—is a violation, even if the client has not complained and even if the difference appears immaterial.
What Examiners Look For
During a fee billing examination, SEC staff typically request:
- Sample fee calculations: A selection of client accounts with the complete calculation showing AUM basis, fee rate applied, billing period, and fee amount charged
- Fee agreement terms: The relevant sections of the advisory agreement for each sampled account, confirming the fee rate and billing methodology disclosed
- Household aggregation documentation: Evidence that accounts combined for breakpoint purposes are correctly associated with the client relationship
- New account and termination controls: Procedures documenting how the firm ensures new accounts enter billing and terminated accounts exit billing promptly
- Fee schedule change controls: Documentation showing how rate changes are applied and when they take effect
- Discrepancy records: Evidence that the firm identifies and resolves billing errors when they occur, including refund or credit records
Firms that produce this documentation quickly and clearly—because it is generated automatically by their reconciliation system—demonstrate the kind of operational control that shortens examination timelines and reduces deficiency risk. Firms that must reconstruct calculations from spreadsheets and emails signal the opposite.
How Audit Trails Satisfy Examination Requirements
An automated reconciliation platform generates a structured audit trail for every fee calculation: the account AUM on the billing date, the source of that data (custodian and feed timestamp), the household aggregation applied, the fee schedule version used, the expected fee calculated, the actual fee debited, and any discrepancy flag and its resolution. This record is reproducible on demand for any billing cycle, any account, any date range.
When an examiner requests fee calculations for 25 sampled accounts from the last three years, a firm with automated reconciliation can produce that documentation in hours. A firm relying on manual spreadsheets—if those spreadsheets have been retained at all—faces days of reconstruction work and the risk that the documentation will not be complete or consistent enough to satisfy examiner requests.
Proactive Error Identification as a Compliance Control
The SEC's guidance on fee billing errors distinguishes between isolated errors discovered through a robust review process and systematic errors that indicate a failed compliance program. Firms that identify billing errors proactively, remediate them promptly, and document the root cause and corrective action are treated significantly more favorably than firms whose errors are discovered by examiners. An automated reconciliation process that flags discrepancies before fees are debited is itself evidence of a functioning compliance control—the kind of control that examiners look for when evaluating the overall quality of a firm's compliance program.
