Automate advisory fee calculations, catch billing errors, and create auditable records that satisfy SEC examiners and protect firm revenue.

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

3–8%

of client accounts experience billing discrepancies per cycle in firms without automated reconciliation

2–4 days

consumed by manual fee reconciliation each quarter at mid-size RIAs

Top 5

SEC examination priority: fee calculation accuracy appears in the majority of RIA deficiency letters

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.

Manual Reconciliation

Quarterly spreadsheet exercise consuming 2–4 days per billing cycle

Errors caught after fees are debited—refund and investigation required

Manual custodian exports from each portal—prone to missed accounts

Household aggregation mapped manually in spreadsheet each cycle

Audit trail is a spreadsheet—difficult to reproduce for SEC examiners

Revenue leakage accumulates silently between annual audits

Automated Reconciliation

Continuous validation—discrepancies flagged before fees are debited

Billing cycle review compressed from days to hours

Custodian data pulled automatically across all custodians daily

CRM household structure applied automatically to every calculation

Structured audit trail for every calculation—exam-ready at any time

New accounts and terminations flagged automatically in real time

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.

01

Multi-Custodian Coverage

Pre-built integrations with Schwab, Fidelity, Pershing, and more—no manual exports required from any custodian

02

CRM Household Sync

Salesforce, Redtail, Wealthbox household data applied automatically to every fee calculation

03

Fee Schedule Versioning

Every rate change logged with effective dates—correct fee applied to the correct billing period

04

Real-Time Discrepancy Flags

Variances surfaced before fees are debited, not discovered after client complaints

05

New Account Detection

Accounts opened at any custodian automatically enter the billing workflow—no manual addition required

06

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.

Frequently Asked Questions

What is fee billing reconciliation for RIAs?

Fee billing reconciliation is the process of verifying that advisory fees charged to clients match what the firm's fee schedules dictate, based on accurate AUM calculations across all custodians. It involves pulling account valuations from custodian feeds, applying the correct fee tier from the client's fee schedule, validating household aggregation for breakpoint qualification, calculating expected fees, and comparing them to actual fees debited. Discrepancies are flagged for review and correction before they become billing errors, client complaints, or compliance issues.

How often do RIAs experience billing errors?

Industry data suggests that firms billing manually or with limited automation experience billing discrepancies in 3 to 8 percent of client accounts per billing cycle. Given that the average RIA bills quarterly, a firm with 500 clients could see 15 to 40 billing errors every three months. These errors split roughly evenly between underbilling (revenue leakage) and overbilling (client refund liability and reputational risk). The actual rate depends heavily on how many custodians the firm uses, how complex the household structure is, and how frequently fee schedules change.

What does the SEC look for when examining fee billing?

SEC examiners focus on fee billing accuracy as one of their top examination areas. They look for: documented fee calculation methodology that matches what was disclosed in the ADV Part 2, evidence that fees charged match the negotiated fee schedule for each client, proper household aggregation for breakpoint qualification, timely credits for terminated accounts, and auditable records showing how each fee was calculated. Examiners frequently request the firm's billing calculations for a sample of client accounts and compare them to the fee schedule in the client agreement. Discrepancies without documented explanations create significant deficiency risk.

What causes household aggregation errors in fee billing?

Household aggregation errors occur when accounts that should be combined for breakpoint qualification are not linked correctly in the billing system. Common causes include: accounts opened under different names or entity types (individual vs. joint vs. trust) that are not connected in the CRM, new accounts added after initial household setup, accounts at different custodians that are not synchronized across systems, and household structure changes (divorce, death, new family members) not reflected in billing configuration. When a household that should qualify for a lower fee tier is billed at the higher tier because accounts are not aggregated, the firm has overcharged the client and carries refund liability.

How does a data platform improve fee billing accuracy?

A unified data platform improves fee billing accuracy by connecting custodian account data, CRM household relationships, and fee schedule data into a single reconciliation workflow. Rather than manually pulling AUM from each custodian, mapping accounts to households in a spreadsheet, and looking up fee tiers in a contract database, the platform automates each step. Account valuations flow in from custodian feeds, the platform applies household aggregation rules from CRM data, calculates expected fees using the correct fee schedule, and compares expected to actual debited fees. Discrepancies are flagged automatically for review, producing an auditable trail of every calculation.

What is revenue leakage from billing errors, and how significant is it?

Revenue leakage occurs when a firm bills less than it is entitled to under the client's fee agreement. Common causes include new accounts that are not added to the billing system promptly, fee schedule updates not applied to existing clients, AUM calculated on an incorrect valuation date that understates assets, and accounts mistakenly excluded from household aggregation causing the wrong (lower) fee tier to apply. For a firm managing $1 billion in AUM at an average fee of 0.85 percent, a 2 percent underbilling rate translates to approximately $170,000 in annual foregone revenue. Across a $5 billion RIA, that number exceeds $850,000 per year.

How long does manual fee billing reconciliation take?

Manual fee billing reconciliation for a mid-size RIA typically consumes 2 to 4 business days per billing cycle. The process involves exporting account data from each custodian, consolidating positions into a master spreadsheet, mapping accounts to households, calculating AUM by household, looking up fee tiers, computing expected fees, comparing to billing system output, and investigating discrepancies. Firms with multiple custodians, complex household structures, or tiered fee schedules experience the longest cycles. Automated reconciliation compresses this to hours rather than days, with discrepancies surfaced in real time rather than after manual review.

Can fee billing reconciliation work across multiple custodians?

Yes, and multi-custodian environments are precisely where automated reconciliation delivers the greatest value. When a client household holds accounts at Schwab, Fidelity, and Pershing, manually aggregating those positions to calculate a single AUM figure for fee purposes requires pulling data from three separate custodian portals, normalizing the account formats, and linking them to the correct household. A data platform with pre-built custodian integrations automates this aggregation, pulling standardized account and position data from each custodian daily and assembling the complete household view automatically. Fee calculations then run on complete, current data rather than the last export each advisor team remembered to pull.

Related guides

Part of the Finance & Compliance Ops series:

• RIA Growth Analytics: Data-Driven Strategies for Advisory Firm Growth

• Advisor Productivity Analytics: Scorecards, Metrics & Benchmarking for RIAs

• Business Intelligence for Wealth Management: Dashboards, Analytics & Self-Service Reporting

• Wealth Management Reporting Automation: From Manual Exports to Real-Time Dashboards

• The Rollup CFO's Playbook: Rapid Integration, Standardized Operations & Scale Economics

• The CFO's Guide to WealthTech ROI: Data-Driven P&L Visibility