# How $40M RIAs Reconcile Billing Between Custodian and CRM Canonical: https://granular.to/blog/ria-billing-reconciliation-custodian-crm Published: 2026-05-30 Updated: 2026-05-30 Author: Trey Category: Playbook Tags: professional-services, operations, automation, playbook, ai-agents > A step-by-step billing reconciliation workflow for $40M RIAs covering custodian feed validation, fee schedule audit, exception handling, and where AI agents materially reduce manual hours without creating compliance risk. > **TL;DR.** Mid-market RIAs at $40M to $80M in revenue lose a full week of operations time each quarter to billing reconciliation between custodian feeds and the CRM or portfolio accounting system. The work is unavoidable, but most of it does not need to be manual. A disciplined three-stage workflow (feed validation, fee schedule audit, exception handling) cuts the time in half and reduces the SEC's most-cited deficiency. AI agents help with the exception layer, not the calculation layer. Compliance risk is the gating constraint. Your billing run took eleven days last quarter. Your COO spent four of those days in spreadsheets reconciling a Schwab feed against your portfolio accounting system, finding the $187,000 wrap account that double-billed for two quarters, and writing the credit memo. Your founder is asking why the firm cannot grow past 220 households without hiring another ops person. This is the workflow that cuts that quarter-close from eleven days to five, without replacing your portfolio accounting platform or your CRM, and without taking on regulatory risk you cannot defend in an SEC exam. ## What reconciliation actually means at a $40M RIA For a $40M revenue RIA managing $4 to $8 billion in AUM across two or three custodians, billing reconciliation is not one task. It is three. **Stage one: custodian feed validation.** Pre-market each morning, your portfolio accounting system pulls position, cost basis, and transaction data from Schwab, Fidelity, Pershing, or LPL. The industry standard is a 99 percent or higher daily reconciliation rate, per [InvestmentNews' RIA billing software benchmarks](https://www.investmentnews.com/goria/technology/best-ria-billing-software-solutions-for-accuracy-and-efficiency/261798). What that means in practice: out of 600 client accounts and 15,000 daily transactions, you can expect 150 exceptions a day. Most resolve themselves overnight. Maybe 10 land in your ops lead's queue. **Stage two: fee schedule audit.** At quarter-end, your billing module calculates fees on average-daily-balance, on end-of-period balance, or on tiered breakpoints, depending on the client agreement. The fee schedule lives in three places: the Form ADV, the client investment management agreement (IMA), and your portfolio accounting system (Orion, Tamarac, Black Diamond, Addepar). Those three sources disagree more often than your founder thinks. **Stage three: exception handling.** Adds and withdrawals mid-quarter need pro-rated fees. Householded accounts need breakpoint recalculation. Held-away assets need to be excluded. Wrap fee accounts have a different rate. Your top-25 clients have negotiated discounts. Each of these is a manual review on each billing run. Most $40M RIAs do not have a documented version of this workflow. They have a senior ops manager who has it in her head. When she leaves, the firm loses 18 months figuring out what she knew. ![Two operations associates at a mid-market RIA reviewing portfolio accounting reconciliation exceptions and fee schedule audit dashboards on adjacent monitors](/images/blog/ria-billing-reconciliation-custodian-crm-ops-workstation.jpg) ## Five places this breaks at $40M After working with mid-market financial services back-offices across specialty finance, RIA, and insurance, the same five failure modes show up at every firm in this revenue band. **1. The Form ADV says one thing, the IMA says another.** Per [Comply's RIA billing guidance](https://www.comply.com/resource/the-dos-and-donts-of-billing-practices-for-rias/), examiners specifically look for clients whose IMA permits expenses that the Form ADV does not disclose. When you grew from $20M to $40M in revenue, you onboarded clients on three different fee schedules and never reconciled the legacy book. Your June 2024 ADV update did not capture the wrap accounts onboarded in February 2025. **2. Cost basis lags the custodian by one trading day.** A client moves $1.2M from one custodian to another in the last week of the quarter. Your portfolio accounting system shows the assets in transit for two days. Your billing run captures it twice. The compliance review catches it 60 percent of the time. **3. Breakpoint discounts compound across households.** A client adds $400,000 to her IRA in mid-March. Her household now crosses the 0.85 percent to 0.65 percent tier. Your system applies the new tier prospectively, not retroactively. The IMA says the tier applies "based on average daily balance for the billing period." That gap is a refund. **4. Held-away assets get billed.** Per [the SEC's frequent advisory fee compliance issues report](https://ria-compliance.com/2019/08/21/frequent-advisory-fee-and-expense-compliance-issues/), the most common version of this is billing on cash held outside the advisor's discretionary management, or on assets held at a third custodian for reporting purposes only. **5. The fee rate in the system does not match the contract.** An ops associate fat-fingered "0.085" instead of "0.85" on a client onboarded in 2023. The system has been billing 0.085 percent of AUM for nine quarters. Your annual internal fee audit caught it. The credit memo went out last week. ## The workflow that runs in five days Here is the workflow that actually fits inside a quarter-close week at a $40M RIA. It assumes you already have a portfolio accounting platform (Orion, Tamarac, Black Diamond, or Addepar), a CRM (Wealthbox, Redtail, or Salesforce Financial Services Cloud), and dedicated billing software (BillFin, AdvicePay, or the billing module inside your portfolio accounting system). **Day 1: Feed validation and exception triage.** Pull the previous-day custodian feed report from each of your custodians. Run an automated exception report against your portfolio accounting system. Anything over a 0.5 percent delta between custodian and system gets flagged. Three categories: timing differences (resolved by T+1 settlement), classification errors (manual review), corporate actions (validate against the custodian event feed). Most $40M RIAs have 8 to 15 of these per quarter that survive the auto-resolution overnight. **Day 2: Fee schedule audit.** Pull the fee rate field from your portfolio accounting system for every household. Pull the contracted fee rate from your CRM or document management system. Run a delta report. Anything that does not match: review the underlying IMA, confirm whether the contracted rate or the system rate is correct, and update one or the other. This step catches the 0.085 versus 0.85 errors and the wrap account discount that did not get applied. **Day 3: Householding and breakpoint recalculation.** Generate a household roster from your portfolio accounting system. For every household whose AUM crossed a tier boundary during the quarter, run the pro-rated tier calculation. This is where most ops leads spend two days. With documented breakpoint logic and an exception report that flags only the households that crossed a tier, this collapses to a half-day. **Day 4: Exclusion and adjustment pass.** Apply held-away exclusions. Apply pro-rated adjustments for adds and withdrawals greater than $25,000 (or whatever your IMA threshold is). Apply negotiated discounts. Generate the draft fee schedule. Run it past compliance. **Day 5: Invoice generation, custodian fee-debit, and audit log.** Generate invoices. Submit the fee-debit files to each custodian (Schwab Advisor Center, Fidelity Wealthscape, Pershing NetX360). Save the audit log with source data version, fee calculation methodology, exception handling notes, and approver name. The audit log is what your SEC examiner asks for first. Five days, not eleven. The savings come from two changes: an automated exception report at each stage (so ops looks only at the items that need human attention) and a clean separation between custodian feed reconciliation and fee calculation (so a feed exception does not block the entire run). ![COO at a $40M RIA reviewing a quarterly billing audit dashboard on a laptop in a modern conference room](/images/blog/ria-billing-reconciliation-custodian-crm-coo-review.jpg) ## Where AI agents fit, and where they do not The pitch you have been hearing from vendors is that AI will replace your billing reconciliation entirely. That is not true at $40M, and it will not be true for several years. The compliance and audit-trail requirements alone make full automation of the calculation layer a regulatory risk Sam cannot defend. **Where AI agents do help, today.** - **Exception classification.** When 12 reconciliation exceptions land in the ops queue on Monday morning, an AI agent that reads each exception and proposes a classification (timing, classification error, corporate action, manual review) saves your ops lead 90 minutes. The agent is not making the resolution decision. It is preparing the queue. - **Fee schedule consistency checks.** Reading the IMA PDF, extracting the contracted fee schedule, and comparing it to the rate in your portfolio accounting system is a perfect language-model task. The agent flags the mismatches. Your compliance officer makes the call. - **Audit log narration.** Generating a defensible written narrative for each exception (what was flagged, what was checked, what was resolved, by whom) is mechanical writing work. An AI agent produces a first draft in seconds. Your COO edits and approves. - **Quarterly client communication.** "Your fee for Q1 was $4,127.50 based on average daily balance of $1.94M at 0.85 percent, less the $182.40 prorated credit for the withdrawal on February 14." Drafting that text for 240 households is a four-hour job that an AI agent does in 20 minutes. **Where it does not help.** - The calculation engine itself. Your portfolio accounting system already does this. Replacing it with an AI-driven calculation is regulatory risk you do not need. - Custodian feed reconciliation logic. The systems-of-record discipline here is too tight for an LLM. Stay with deterministic logic. - Client-by-client discount and breakpoint application. The decisions are too consequential and too auditable to delegate to a probabilistic system. The pattern is consistent. AI handles the work around the calculation: triage, narration, communication, audit. Deterministic systems handle the calculation itself. This is the right division of labor at $40M, and it is the one that survives an SEC exam. ## What this costs to build A focused implementation lands in the four-to-six-week range for a $40M RIA. The build is mostly integration work between your portfolio accounting system, your CRM, your billing platform, and a thin agent layer that handles exception triage and narration. The custodian feed validation is already running. The breakpoint recalculation logic already exists. What is missing is the connective tissue and the exception interface. Most RIAs at $40M overspend on portfolio accounting and underspend on the workflow layer on top of it. If you are about to renegotiate your Orion or Tamarac contract, the right question is not "which platform should we move to." It is "what does the next four weeks of integration work look like to cut quarter-close from eleven days to five." ## FAQ **How long does billing reconciliation actually take at a $40M RIA?** Most $40M RIAs spend 8 to 12 days per quarter on the full cycle: feed validation, fee schedule audit, exception handling, invoice generation, and audit log. Best-in-class firms cut that to 4 to 5 days by automating the exception layer. **Should we replace our portfolio accounting system to fix this?** Almost never. The major platforms (Orion, Tamarac, Black Diamond, Addepar) all do reconciliation well at 99 percent or higher accuracy. The gap is the workflow on top. Build the workflow first. Replace the platform only if reconciliation rate is below 98 percent. **Where is the SEC focus right now?** Per [the RIA Compliance Group's summary of recent enforcement](https://ria-compliance.com/knowledge-center/rules-regulations/sec-rules-and-regulations/), fee billing has been cited in well over 100 enforcement actions in recent years. Most common findings: outdated fee schedules, incorrect breakpoint application, billing on excluded assets, and prepaid fees not refunded on terminated accounts. The remediation is a documented workflow with a defensible audit log. **Do we need a dedicated AI vendor or can our existing tech stack do this?** If you have Orion or Tamarac plus a CRM, you have 80 percent of what you need. The missing 20 percent is the agent layer for exception triage and narration. That is a four-week build, not a vendor decision. **What is the first move?** Run an internal fee audit on your last completed quarter. Pick 30 households at random. Pull the IMA, the fee schedule in your portfolio accounting system, the calculated fee, and the actual fee billed. The variance you find is the size of the problem. ## What this looks like at your firm If your quarter-close is running past a week, if your ops lead spends more time reconciling Schwab feeds than thinking about workflow, or if your last internal fee audit surfaced more than three errors, the workflow gap is bigger than the platform gap. We build the integration and the exception agent layer between your portfolio accounting system, your CRM, and your billing platform in four weeks at a fixed price. If this sounds like your Tuesday, [book 30 minutes with us](/) and we will walk through what the first 60 days looks like at a firm your size. --- ## Keep Reading - **[Wealthbox vs Redtail vs Salesforce FSC for $40M RIAs](/blog/wealthbox-redtail-salesforce-40m-ria)** - Honest teardown of the three CRMs that $40M RIAs actually evaluate, with the operational gaps that matter for back-office workflow. - **[Why RIA Roll-Ups Will Spend AI Budget on Back Office First](/blog/ria-roll-ups-ai-back-office-first)** - The strategy piece on why aggregators are investing in operations automation before client-facing AI tools.