Month-End Close Automation & Financial Reconciliation3 min readUpdated September 2026

Reconciling Advisory Fees When the Custodian Sets the Calendar

For an RIA, the custodian's fee file, not your invoice, drives the close, so the choice comes down to how many custodians you reconcile: FloQast fits a single-custodian practice, and BlackLine fits firms matching fee files across several platforms. Until the custodian posts the debit, the fee revenue on your books is only an estimate.

Vendors Covered in this Article

Disclosure: We may earn a commission if you buy through some links on this page. It doesn't change what we recommend.

Why does the custodian's file run an RIA's close?

Most RIAs bill in advance or in arrears based on assets under management at a snapshot date, but the actual debit happens on the custodian's schedule, which rarely lines up neatly with your own month-end. Until that fee file posts and you can confirm the amount collected matches what your fee schedule says it should be, the number sitting in revenue is an estimate. A close process that treats the estimate as final, and never circles back once the custodian file actually posts, is the single most common way RIA fee revenue drifts from what was actually earned.

A firm managing a modest client roster can usually still do this review by hand each month, cross-checking the custodian's posted fee amount against a simple fee calculation spreadsheet. The habit matters more than the tool at this stage: what breaks the process isn't a lack of software, it's skipping the review during a busy month and assuming last month's numbers still hold true.

Solicitor and Referral Payouts Add a Second Ledger

A firm that pays outside solicitors a share of the advisory fee for referred clients has to track that payout against the same AUM snapshot the fee itself was calculated from, then confirm the solicitor was paid the correct percentage once the fee actually collects. Get the sequencing wrong, paying the solicitor from an estimate before the custodian file confirms the real number, and a fee adjustment later means either clawing back an overpayment or eating a shortfall that should have gone to the solicitor.

Tiered and Householded Fee Schedules Complicate Matching

Many RIAs bill on a tiered schedule, a lower rate above a certain AUM breakpoint, and household related accounts together so a family's combined assets determine the tier. A single account misclassified into the wrong household, or a breakpoint applied to one account instead of the combined total, is a small error that's easy to miss on one account and expensive once it's been repeating for a year across many households.

Say two accounts inside the same household, one at $600,000 and another at $450,000, should combine to a $1,050,000 balance that crosses the tier breakpoint at $1,000,000. If the second account is entered under a slightly different household name, the system prices each account separately at the lower tier, and the client is systematically overbilled every quarter until someone catches the mismatch.

FloQast for a Single-Custodian Practice

A firm custodying primarily through one platform, with a modest account count and a fee schedule that doesn't change often, tends to do well on FloQast. The checklist model enforces a monthly review of the custodian fee file against your own fee schedule without requiring a heavy implementation, which fits a firm whose back office is often just one or two people.

BlackLine When You Custody Across Multiple Platforms

A firm that custodies client assets across several platforms is reconciling multiple fee files, each with its own format and posting timing, every month. That's where BlackLine's matching engine earns its complexity, automatically tying each custodian's fee debit back to the underlying fee schedule rather than asking a reviewer to check several separate spreadsheets by hand and hope nothing was missed between them.

A Detail the SEC Expects You to Keep Straight

Recordkeeping expectations for how advisory fees were calculated and any adjustments made along the way mean the trail matters as much as the final number. If your firm's own operating cash sits in a sweep account, it's worth knowing where the effective federal funds rate stands, 3.63% as of mid-20261, as a rough benchmark for whether that sweep yield is actually competitive rather than assuming the custodian's default rate is fine.

A Short List Before You Automate Fee Billing

Before moving fee reconciliation into either platform, confirm three things: every household is defined consistently in your CRM and your billing system, every custodian relationship has a known fee file format and posting cadence, and someone specific owns solicitor payout timing, separate from the advisor closing the client relationship. Skipping this groundwork and configuring a checklist around fee schedules that don't actually match your CRM's household definitions just automates the same error at a faster pace.

Groundwork to confirm before you automate:

  • Every household is defined the same way in your CRM and your billing system.
  • Every custodian relationship has a known fee file format and posting cadence.
  • One named person owns solicitor payout timing, separate from the advisor closing the client relationship.
  • Fee corrections are recorded as their own adjusting entries that reference the original fee period.
Executive Capability Standard

What Good Looks Like

A well-run RIA close matches every custodian fee debit to the fee schedule and AUM balance it was calculated from, with solicitor payouts reconciled against the same snapshot before either number is treated as final.

Building The Capability (5-Stage Skill Ladder)

1. Learn:List every custodian relationship your firm uses, along with each one's fee file format and posting schedule.
2. Do Manually:Reconcile a sample of fee debits by hand against your own fee schedule for two full cycles.
3. Delegate:Assign one person ownership of custodian fee reconciliation, separate from client-facing advisors.
4. Automate:Move fee-file reconciliation into FloQast or BlackLine based on custodian count and household volume.
5. Buy:Add dedicated RIA billing software once householding and tiering complexity outgrows a general ledger checklist.

How to Get Started

Disclosure: We may earn a commission if you buy through some links on this page. It doesn't change what we recommend.

Frequently Asked Questions

How should we treat a fee correction after the custodian's file already posted?

Record the correction as its own adjusting entry in the period it's identified, referencing the original fee period it corrects, rather than quietly rolling it into the current month's revenue. A clear trail from the original estimate to the correction is what a reviewer, or an examiner, will want to see.

Do we need to track solicitor payouts separately from advisory fee revenue?

Yes. Keep the solicitor share as its own line tied to the specific fee period and AUM snapshot it was calculated from. Blending it into general revenue makes it much harder to confirm a solicitor was paid the correct amount when the underlying fee is later adjusted.

Is BlackLine worth it for a firm on a single custodian?

Usually not yet. A single-custodian practice with a stable account count typically gets what it needs from FloQast's lighter checklist model. Revisit the decision once you add a second or third custodian relationship, since that's when fee-file matching complexity actually grows.

What's the real risk of a small tiering error in a householded fee schedule?

It compounds quietly. A single misapplied breakpoint might be a few dollars a month, but left unreconciled across many households for a year, it becomes a real revenue discrepancy and a compliance question about whether clients were billed at the rate their disclosed fee schedule actually promised.

Sources

Where we quote a benchmark, we show its source. Other figures in this guide are estimates or general guidance, so check them against your own numbers.

  1. Effective federal funds rate (monthly average). FRED series FEDFUNDS; cross-checked vs Federal Reserve H.15 release (3.63% on 2026-06-30), 2026.

Related Guides