RIA Billing Software Is Not Fee Reconciliation

We work with financial operations teams where a number has to survive a client question, an auditor and an examiner. In registered investment adviser (RIA) firms, the advisory fee is that number, and it is usually trusted more than it is checked.

RIA billing software takes an agreement, a valuation, a fee schedule and a set of billing rules, then produces an invoice or a fee file. Fee reconciliation is a different job. It proves that the fee actually deducted matches what the agreement entitled the firm to charge, after householding, breakpoints, grandfathered schedules, exclusions and proration are applied.

Most firms buy software for the first job and assume the second is covered. This post covers why calculation is not proof, the seven inputs behind a fee run, the errors the SEC found in its examinations, a six-step quarterly reconciliation, what examiners expect to see, and when to buy versus build the revenue layer underneath billing.

Calculating an RIA Fee Is Not the Same as Proving It

Calculating an RIA fee answers what the fee should be under the rules loaded into the system, and reconciliation answers if the actual debit matched the entitlement under the actual agreement. We treat them as two separate controls, because a firm can get the first right and the second wrong every quarter.

The regulator's view makes the gap concrete. In a November 2021 risk alert, the SEC Division of Examinations reported that its staff conducted approximately 130 examinations of SEC-registered investment advisers under an advisory fee initiative and identified deficiencies related to the advisory fees charged during most of them. The same alert notes that the Division has identified disclosures about the costs of investing as an examination priority since 2018.

The real question for an owner is not if the system can calculate an advisory fee. It is if the firm can reproduce last quarter's fee run, line by line, well enough to defend it to a client, an auditor or an examiner. That is the difference between billing software and revenue control.

The Seven Inputs Behind Every Quarterly Fee Run

A quarterly fee is the product of at least seven inputs, and each can live in a different system, spreadsheet, email thread or person's head. We map them before anything else, because a firm that cannot say where each input comes from has a fee calculator with memory gaps rather than a billing system.

The agreement, householding and exclusions are the inputs most likely to sit outside the billing system, which is why they cause most of the trouble and why our reconciliation starts from them.

Fee Errors the SEC Found in Adviser Examinations

The fee errors the SEC found are more useful than any vendor feature list, because they name where fee runs actually break. We group the alert's observations by the stage where each error enters the run.

Most of these are agreement errors or data-governance errors that happen to surface in billing. If the wrong schedule was loaded, the wrong householding group assigned or the wrong assets marked billable, the software applies the rate correctly to the wrong inputs.

The alert also describes the typical examined adviser, which assessed fees quarterly, deducted them directly from client accounts and used software or third-party service providers to calculate them. Software was in the loop for most firms, and the errors still happened.

Why Calculation-Only RIA Billing Software Misses Most of the Risk

Calculation-only RIA billing software misses most of the risk because the error usually lives upstream of the math, in data the engine treats as true. We see the same handful of causes again and again:

• A side letter or negotiated discount never made it into the billing system.
• A grandfathered schedule stayed in a spreadsheet after a custodian transition or an acquisition.
• A private investment was left out of custodian pricing, then included in or omitted from the fee base inconsistently.
• A household was split after a recruiting event and the breakpoint logic was never revisited.
• A new account was billed for a full period instead of being prorated.

There is also an independence problem. When the custodian computes the fee, deducts it and reports it, the firm's control is only as independent as its ability to verify that file.

That is an operating reality rather than an accusation, and in a single-custodian book with standard schedules it may be acceptable. In a more complex firm, an independent reconciliation is the control that closes the gap, and it needs a fee schedule the firm controls, the agreement or household rule behind each charge, the valuation inputs and the custodian's debit file to compare against.

How to Run a Reproducible Quarterly Fee Reconciliation

A reproducible quarterly fee reconciliation compares expected fee with actual fee for every billing group, classifies each difference and keeps the evidence. We run it in six steps, and the design goal is that another operations lead could rerun it six months later without asking anyone what they remembered.

1. Build the Expected Fee From the Agreement in Force

Start from the signed agreement, not from the billing system's configuration. Apply the fee schedule, household definition, valuation base, exclusions and proration rules that the agreement and disclosures actually specify.

This step is where grandfathered schedules and side arrangements get caught, because they are read from the source document. The common mistake is recalculating from the same configuration the billing system used, which simply repeats its errors.

2. Import the Actual Debits for the Same Period

Load the custodian's debit file, or the equivalent record of fees actually charged, for exactly the same billing period and accounts. Keep the raw file unchanged so the comparison can be reproduced.

Date conventions matter here. A debit processed a few days into the next period is still part of this quarter's run, and the reconciliation should tie it back rather than treat it as missing.

3. Match at the Billing-Group Level

Compare expected and actual fees by billing group or household, never only at the firm total. Firm-level totals hide offsetting errors, where one client is overcharged and another undercharged by a similar amount.

Matching at this level also exposes double-billing and missing accounts, which show up as groups with a debit and no expected fee, or the reverse.

4. Review Variances Against a Documented Threshold

Set a materiality threshold in advance and write it down, then review every variance above it. A threshold decided after seeing the numbers is a judgment call an examiner will question.

Below-threshold variances still deserve a periodic look for patterns, since a small error repeated across many accounts is how breakpoint and proration mistakes usually hide.

5. Classify Every Exception Into One of Four Dispositions

Each exception gets exactly one disposition, and each disposition has a defined next action. We find four are enough.

6. Document the Outcome So a Third Party Can Reproduce It

For every billing group, keep the source agreement, the schedule used, the valuation record, the debit record and the reviewer's sign-off. The documentation standard should be boring, because boring is what makes it reproducible.

The SEC alert points the same way. It observed fewer errors at advisers with specific written policies covering the supervision, calculation, review and billing of fees, and noted that checklists for reconciling fee calculations with advisory agreements can help when used consistently by all advisory personnel.

What Examiners Expect to See in the Fee Evidence Trail

Examiners expect an evidence trail that lets a third party reproduce each charge from the agreement and the disclosure. We build the trail around the documents the rules already require, so nothing is collected only for an exam.

Form ADV Part 2A, Item 5 asks advisers to describe whether you deduct fees from clients' assets or bill clients for fees incurred and to explain how often fees are billed or deducted, as well as how a prepaid fee is refunded on termination.

Advisers Act Rule 206(4)-7 requires written policies and procedures reasonably designed to prevent violations and a review, no less frequently than annually, of their adequacy and effectiveness. For each quarter, the trail should therefore show:

• The fee schedule in force for the client or household.
• The valuation method and the exclusions applied.
• The householding rule used.
• The debit amount and date.
• The reviewer who checked the reconciliation.
• The remediation for any variance.

When to Buy RIA Billing Software and When to Build the Revenue Layer

For many firms RIA billing software is the right purchase, and the decision is about what sits underneath it. We would buy when the book is effectively single-custodian, fee schedules are standard with little grandfathering, most billable assets are custodied and priced inside the platform, and householding is simple and rarely disputed.

Building the revenue layer underneath billing makes sense when a meaningful share of billable assets is held away or not priced by the custodian, when householding and grandfathered schedules live in spreadsheets beside the system, when the firm works across more than one custodian, or when revenue must be attributed across advisors and acquired books on terms vendors do not model.

Commodity workflows such as invoicing, payment collection and statement delivery are fine to buy, a split we describe in buy the commodity, build the moat.

Version one of that revenue layer should be narrow. It stores the agreement as data, holds the active schedule and billing-group definitions the firm controls, calculates expected fees, reports variances against custodian debits and keeps an audit trail of changes.

We apply the same design logic in our fintech software development work on ledger and reconciliation foundations for regulated workflows, and the same matching discipline appears in where trade reconciliation breaks come from and in why a fund administrator does not own your waterfall.

Make Every RIA Fee Run Reproducible Before the Next Exam

RIA billing software tells you what the fee should be, and a quarterly reconciliation proves what the fee was. Build the expected fee from the agreement, match it against actual debits by billing group, classify every variance, and keep evidence a third party could rerun. If the firm cannot reproduce, defend and explain the fee that left a client account, we would treat it as a control problem before it becomes an exam finding.

If you are weighing a revenue layer beside your billing platform, the team at Better Software can walk through the data model with you.

Frequently Asked Questions

How Often Are Advisory Fees Paid?

Most advisory fees are paid quarterly, and the SEC described quarterly assessment as typical among the advisers it examined. We still check each agreement, because some firms bill monthly, in advance or in arrears, and the cadence in practice has to match what the client was told.

How Often Can Advisory Fees Be Charged?

Advisory fees can be charged as often as the client agreement allows and the firm's brochure discloses. We see quarterly billing most often, with some monthly or annual arrangements. More frequent charging gives small errors more chances to repeat, so reconciliation needs to run on the same cadence.

How Are Advisory Fees Calculated?

Advisory fees are usually calculated by applying a percentage rate, often tiered by asset level, to account value on an agreed date or average. We confirm the householding rule, exclusions and proration for flows, because those inputs change the fee more often than the rate itself.

Is Advisory Fee Same as Management Fee?

Firms often use advisory fee and management fee loosely for the same charge, but the governing documents decide. We treat the advisory agreement and the brochure as the definition, since a management fee can also mean one component of a broader arrangement such as a wrap program.

What Does Billed Quarterly Mean?

Billed quarterly means the fee is charged once every three months, usually based on account value at the start or end of the quarter. We also confirm if billing is in advance or in arrears, because that decides how refunds and new accounts are prorated.