Key Takeaways

• Advisory fee billing errors are a top SEC examination finding; more than one-third of examined RIAs had at least one material fee error in recent examination periods.

• Four methods exist for reconciling advisory fees: manual spreadsheet review, billing software with built-in reconciliation, middleware alert routing, and continuous orchestrated reconciliation.

• Fee billing refunds: $35M+ paid in 2022–2023 by advisory firms following SEC fee billing examinations — only formal-action cases; actual industry total is higher.

• Continuous orchestrated reconciliation is the only method that catches errors before the billing period closes, produces an examination-ready audit log, and handles tiered fee schedules with household grouping automatically.

• Break-even for orchestration vs. manual is typically 3–5 months at firms above $100M AUM with complex fee schedules.

Advisory Fee Reconciliation: 4 Methods Compared 2026

Every quarter, advisory fees leave client accounts. The fee schedule says what should be charged. The custodian statement says what was actually charged. In theory, these match. In practice, discrepancies are common — wrong fee tier applied after an AUM threshold was crossed, stale household groupings, a fee waiver that expired and was not removed, a new account that inherited the wrong schedule. Most RIAs catch these errors eventually. Many catch them a year or more after they started.

SEC-registered RIAs: 15,400+ retail-serving according to the SIFMA 2024 industry factbook (2024). Every one of those firms is required to have a process for ensuring fees charged match fees owed. The SEC's examination staff has called fee billing a top examination priority since 2018, and the stakes of a billing error — client refunds, disclosure amendments, reputational damage — are too high to manage with a spreadsheet reviewed once a year.

This guide compares 4 methods for reconciling advisory fees against the fee schedule, from fully manual to fully automated, with the decision criteria that determine which approach fits your firm's AUM, client count, and compliance posture.

TL;DR: Advisory fee reconciliation compares what the custodian billed in each period against what the fee schedule says should have been billed, flags discrepancies above a materiality threshold, and routes them for investigation and correction. Automating this process shifts the work from a quarterly manual exercise to a continuous background check.

Who This Is For

This guide is for:

• RIAs managing $100M+ in AUM with 50+ client accounts

• Compliance officers or operations leads responsible for fee billing accuracy

• Firms that have been cited or are concerned about SEC examination findings on fee billing

Red flags: Skip the automated methods if you manage fewer than 30 client accounts on a single flat-fee schedule with no AUM-tiered pricing — manual reconciliation takes less than an hour per quarter at that scale. Also skip if your custodian (Schwab Advisor Services, Fidelity Institutional, Pershing) already provides a fee discrepancy report that your team reviews and acts on consistently.

Why Fee Reconciliation Errors Persist

The root cause of most advisory fee errors is not bad intent — it is data fragmentation. The fee schedule lives in the firm's CRM or a spreadsheet. The billing calculation happens in portfolio management software (Black Diamond, Orion, Tamarac). The actual deduction happens at the custodian. And household groupings, fee waivers, and AUM thresholds are maintained manually across all three systems, often by different people.

According to the SEC Office of Compliance Inspections and Examinations 2023 Risk Alert on Investment Adviser Fee Billing, more than one-third of examined RIAs had at least one material fee billing error in the examination period. The most common error types were: incorrect AUM calculation due to excluded accounts, misapplied fee waivers, and failure to apply breakpoints when household AUM crossed a tier threshold.

Fee billing errors: $35M+ in client refunds were paid by advisory firms following SEC fee billing examinations in 2022–2023 according to the SEC Division of Enforcement 2024 Annual Report (2024). That figure covers only cases that resulted in formal action — the actual refund volume across the industry is higher.

The structural fix is a reconciliation process that runs on every billing cycle, checks every account, and catches discrepancies before the billing period closes rather than years later.

The 4 Methods

Method 1: Manual Quarterly Reconciliation

The standard approach at firms under $300M AUM is a quarterly manual reconciliation. A compliance associate pulls the custodian billing report, the firm's fee schedule, and the portfolio management system's AUM data, then cross-references line by line in Excel.

What works: No technology cost. Full control over the process. Works for firms with stable, simple fee schedules.

What breaks: At 100+ client accounts, a manual reconciliation takes 12–20 hours per quarter. The process is error-prone under time pressure. And because it happens after the billing period closes, errors identified during reconciliation require refund processing — not just correction.

Method 2: Billing Software with Built-In Reconciliation

Platforms like Orion Billing, Black Diamond, and Tamarac include fee billing modules that calculate fees from AUM data and compare them against custodian actuals. Discrepancy reports are available within the platform.

What works: Reduces the manual calculation step significantly. Discrepancy reports are generated automatically per billing cycle. Most major custodians (Schwab, Fidelity, Pershing) have certified integrations.

Where it falls short: The reconciliation report is available, but reviewing and actioning it is still manual. Firms with complex household groupings or multi-tier schedules may find the built-in reconciliation logic insufficient for edge cases. According to the Tiburon Strategic Advisors 2024 RIA Technology Survey, 41% of RIAs using billing software still supplement it with manual review for their highest-AUM clients.

Method 3: Middleware-Assisted Alert Routing

The third approach adds an alert layer on top of Method 2. When the billing software generates a discrepancy report, a middleware tool (Zapier, Make) parses it and sends a structured alert — client name, account number, billed amount, scheduled amount, variance — to a compliance Slack channel or email address.

This ensures the discrepancy report does not sit unread in the billing platform until someone remembers to log in.

What works: Gets discrepancy data into the workflow tool the compliance team already uses. Low cost.

What breaks: The middleware cannot apply materiality thresholds intelligently, cannot prioritize by variance magnitude, and cannot track whether a discrepancy was investigated and resolved.

Method 4: Continuous Orchestrated Reconciliation

The fourth method is a continuous reconciliation workflow that runs on each billing event, applies materiality logic, routes findings to the right person based on account type and variance size, tracks resolution, and logs every step for examination readiness.

Method 4 in Detail: The Recipe

Step 1 — Ingest custodian billing data. Custodian billing data arrives as a daily or monthly file from Schwab, Fidelity, or Pershing. The orchestration layer ingests this via SFTP or secure API and parses it into a structured billing register: account number, billing date, fee amount, billing basis (AUM as of what date).

Step 2 — Pull the fee schedule from the CRM. The firm's fee schedule — including tier breakpoints, household groupings, and active waivers — is maintained in the CRM (Redtail, Wealthbox, Salesforce Financial Services Cloud) or in the portfolio management platform. The orchestration layer reads the current schedule for each account.

Step 3 — Calculate the expected fee. For each account: multiply the AUM basis by the applicable tier rate, apply any active waivers, and adjust for the billing period length (quarterly proration). This is the "should have billed" figure.

Step 4 — Compare and apply materiality thresholds. Compare expected vs. actual fee. Flag discrepancies above $50 or 2% of expected fee (whichever is lower) for investigation. Discrepancies below $10 are logged but not escalated — the cost of investigation exceeds the variance.

Step 5 — Route findings. Variances of $50–$500: route to the compliance associate for review and correction within 5 business days. Variances above $500 or affecting accounts above $5M AUM: route to the chief compliance officer with same-day escalation.

Step 6 — Track resolution and generate audit log. Every finding is tracked from detection through resolution. The audit log — who reviewed it, what was found, what correction was made, when — is maintained as an examination-ready record.

Worked Example: Tiered Fee Schedule with Household Grouping

Consider a 3-advisor RIA managing 220 accounts totaling $340M AUM. Their fee schedule has three tiers: 1.00% on the first $1M, 0.75% on $1M–$3M, 0.60% above $3M. One household — the Martinez family — has 4 linked accounts totaling $2.8M when grouped. When a position_snapshot.created event fires in their Orion instance at quarter-end, the orchestration platform reads the grouped AUM of $2.8M, applies the blended tier rate (1.00% on $1M + 0.75% on $1.8M = $23,500 annualized / 4 = $5,875 quarterly), and compares it to the custodian's billed figure of $6,125. The $250 discrepancy exceeds the $50 materiality threshold and is routed to the compliance associate with the account group, the billing calculation, the custodian bill, and the fee schedule tier — all in one task. The associate identifies that Orion grouped only 3 of the 4 accounts (one was linked manually and the link had broken on a system update), corrects the household grouping, and processes a $250 refund to the client — all within 3 business days of the billing date rather than discovering it 12 months later at examination prep.

Method Comparison

SEC Examination Readiness Checklist

A firm that automates reconciliation also needs the audit trail to demonstrate compliance in an examination. Use this checklist to verify your process:

• Fee schedule is documented and version-controlled (date each change was effective)
• Household groupings are reconciled against custodian data at least quarterly
• Every billing discrepancy above materiality threshold is documented with: date detected, root cause, corrective action, client refund amount if any
• Fee waivers are reviewed quarterly — expired waivers are removed within one billing cycle
• The reconciliation process is described in the firm's written supervisory procedures (WSP)
• Exam team can pull a complete discrepancy log for any period within 24 hours

For the companion workflow — monitoring held-away accounts for AUM drift — see reduce flag held-away account drift for advisor review. For the onboarding-side of client data accuracy, see automate RIA KYC AML client onboarding workflow.

Fee Error Frequency by Billing Method

Not all reconciliation methods catch errors at the same rate. The table below shows error-detection performance benchmarks from advisory practice audits.

Monthly Cost of Errors at Different AUM Levels

The financial impact of fee billing errors scales with AUM. The table below shows estimated annual refund exposure for a firm with a 1.0% base fee schedule and a 4% error rate.

Reconciliation Effort by Firm Size and Fee Schedule Complexity

The time required for advisory fee reconciliation scales with both AUM and fee schedule complexity. This table summarizes effort estimates across firm profiles.

For the RMD tracking workflow that reuses the same custodian data feeds as fee reconciliation, see automate RMD deadline alerts for RIA clients — the same Schwab/Fidelity/Pershing connection handles both.

Glossary of Key Terms

Fee schedule: The firm's documented rate structure — expressed as a percentage of AUM, flat dollar amount, or tiered rate — that governs what each client should be charged.

Breakpoint: The AUM threshold at which a lower fee tier applies. Failure to apply breakpoints when a client's AUM crosses a tier is one of the most common SEC fee billing findings.

Household grouping: The aggregation of multiple accounts for a single client household used to calculate a blended AUM for tier application purposes.

Fee waiver: A documented exception granting a client a reduced fee for a specific period. Waivers that expire but are not removed result in overcharges.

Materiality threshold: The minimum variance (dollar or percentage) at which a discrepancy requires investigation. Typically $50 or 2%, whichever is lower.

Billing basis: The AUM value used for fee calculation — typically the account value at a specific date (e.g., last business day of the prior quarter).

Frequently Asked Questions

How often should advisory fee reconciliation run?

At minimum, once per billing cycle (quarterly for most RIAs). Automated approaches can run monthly or on each billing event. The SEC expects firms to catch and correct errors within a reasonable time after they occur — quarterly is the practical floor.

What is the most common source of advisory fee errors?

According to the SEC's 2023 Risk Alert on Fee Billing, the most common sources are incorrect AUM calculation (usually due to excluded accounts or broken household links), failure to apply tier breakpoints, and unremoved fee waivers. All three are detectable with automated reconciliation.

Do custodians provide the data needed for automated reconciliation?

Schwab Advisor Services, Fidelity Institutional, and Pershing all provide billing detail files that include account-level fee amounts. These can be ingested via SFTP or, increasingly, via API. TD Ameritrade data has migrated to Schwab since the 2023 acquisition.

What happens when an error is found that requires a client refund?

The refund must be processed, the client must be notified, and the error must be documented. If the overcharge was material and systemic, the firm's Form ADV disclosure may need to be amended. The compliance officer should evaluate each case under the firm's written supervisory procedures.

Can this workflow handle flat-fee clients alongside AUM-based clients?

Yes, with separate logic paths. For flat-fee accounts, the comparison is simply: billed amount vs. contracted flat fee. The materiality threshold applies the same way.

What is the difference between fee reconciliation and fee billing?

Fee billing is the process of calculating and collecting advisory fees. Fee reconciliation is the after-the-fact comparison of what was billed against what should have been billed. Billing software automates the former; reconciliation automation catches errors the billing process introduced.

How does US Tech Automations fit into this workflow?

US Tech Automations connects to the custodian billing feed (via SFTP or API), pulls the fee schedule from the CRM, calculates the expected fee per account, and routes discrepancies above the materiality threshold to the right reviewer — with a full audit trail logged for examination readiness. For KYC and onboarding automation in the same compliance stack, see automate RIA KYC AML client onboarding workflow.

The Bottom Line

Advisory fee reconciliation is a regulatory requirement, not an optional process. The four methods above range from a quarterly manual spreadsheet exercise to a continuous automated workflow that catches discrepancies in days rather than quarters. The right choice depends on your AUM, client count, and fee schedule complexity.

Reconciliation frequency matters: quarterly manual review catches 60% of errors; monthly automated review catches 94% according to the Investment Adviser Association 2024 Compliance Best Practices Survey (2024).

For firms above $100M AUM with complex fee schedules, Method 4 is the only approach that is both operationally sustainable and examination-ready. The manual and middleware methods become progressively less viable as client count and fee schedule complexity grow.

US Tech Automations reads the custodian billing feed, applies your fee schedule logic, and routes exceptions to the compliance team — so billing errors surface in days rather than quarters.

See how pricing scales with your account count and evaluate whether the automation layer fits your compliance budget.