Quarterly billing is a process, not a spreadsheet

Quarter-end fee calculations often look simple from a distance. Take the account value, apply the agreed rate, divide by four, and send the result to billing.

The real process is less tidy. Someone has to confirm the right accounts are included, find the correct fee terms, check the valuation date, account for deposits and withdrawals, apply breakpoints, handle household arrangements, and explain any difference from the prior quarter. Then someone else should review the results before invoices or custodian billing instructions go out.

That work tends to be split across portfolio systems, CRM records, signed agreements, spreadsheets, and email. When one source is late or inconsistent, a staff member becomes the connection between them. They search, compare, copy, calculate, and ask an adviser to confirm what the agreement meant.

For a firm, that can be an expensive way to run a recurring process. It also creates room for missed fees, incorrect charges, delayed billing, and client questions that take time to resolve. Across financial advisory firms, recurring manual work can create costs and operational risk. That is not a promise that fee automation alone will recover that amount. It is a reason to examine where recurring manual work is costing the firm money.

Automating quarterly fees means building a controlled workflow around the calculation, not handing a spreadsheet to an agent and hoping the total is right.

Map the fee process before automating it

Start by documenting how a fee moves from an agreement to a billed amount. The workflow should answer several practical questions:

Which system is the source of record for client, household, and account status?
Where are signed fee terms stored, and who can confirm they are current?
Which valuation date and account balance does the firm use?
How are new accounts, closed accounts, and mid-quarter changes handled?
Who reviews exceptions, approves the final billing file, and records that approval?
What happens after approval, and which system or provider receives the billing instruction?

The answers may differ by client segment, adviser, custodian, or legacy agreement. Write those differences down rather than quietly encoding them in a spreadsheet formula. A workflow can automate known rules. It cannot safely resolve an undocumented exception on its own.

If your firm is also trying to improve the records feeding these calculations, the guide to automating CRM cleanup for financial advisory firms covers common data-quality work that can affect account and household matching.

Step 1: Collect the data and check its source

A fee run starts with a defined data window. For example, the process might collect account balances for the agreed quarter-end valuation date, active account status, client and household identifiers, and the fee schedule linked to each account.

The collection step should preserve where each item came from and when it was received. That matters when a custodian file arrives late, an account appears twice, or the CRM lists a different household from the portfolio system. A calculation needs more than a number. It needs a traceable input.

A practical data packet for each billing period could include:

The account and household roster for the billing run
Quarter-end values and valuation dates
Deposits, withdrawals, and account openings or closures
The applicable agreement and fee schedule
Billing frequency, minimums, exclusions, and any negotiated terms
Prior-quarter billed amounts for comparison

The workflow should validate the packet before calculating. It can flag missing account values, duplicate account identifiers, stale agreements, mismatched client records, and values dated outside the approved window. Those checks should stop the affected account from progressing until someone reviews it. They should not silently substitute a nearby date or guess which agreement applies.

This step is where integrations and permissions matter. The workflow should read from approved systems, use the firm’s established access controls, and retain a record of the files or records used. If the firm relies on manual uploads, require a consistent file format and log who uploaded each source.

Step 2: Apply the documented fee rules

Once the inputs pass validation, the calculation layer applies the terms that the firm has confirmed. Those rules may include an annual percentage rate billed quarterly, tiered breakpoints, household-level aggregation, account minimums, negotiated discounts, or exclusions for particular assets.

Even a familiar formula can be ambiguous in practice. A schedule may state a rate but not explain how to handle a partial quarter. A new account may be billed from its opening date, while another agreement may use a full-quarter convention. A household breakpoint could apply across eligible accounts, but not to every account in that household. Those choices need a written rule and an owner.

For each account, the calculation record should show:

The relevant balance and valuation date
The fee schedule and version applied
The calculation method, including any proration
Any adjustment or exclusion
The calculated amount before rounding and the amount sent for approval

The system should also retain enough detail to reproduce the amount later. A total with no inputs or rule reference is hard to review and harder to explain to a client.

Use the automation to make the documented rule repeatable, not to interpret legal language. When a signed agreement conflicts with the fee schedule in the CRM, route it to a person. The same applies when the wording is unclear or a proposed fee falls outside the firm’s approved policy. Firms reviewing how fee terms are communicated can also read AI fee disclosure guidance for financial advisory firms.

Step 3: Route exceptions to the right person

A useful automated fee workflow does not try to make every account look normal. It identifies the accounts that need attention and gives the reviewer enough context to decide what to do.

Common exceptions include:

Missing or stale account values
An account with no matching signed agreement
A new or closed account during the billing period
A large balance change compared with the previous quarter
A rate or fee amount outside an approved range
A mismatch between CRM householding and billing records
A manual adjustment without a reason or supporting approval
A fee schedule that changed during the quarter

Set thresholds with the people who own the process. A large balance change for a small account may be ordinary. The same percentage change on a major household could deserve a closer look. A system can flag the condition, show the prior and current values, and attach the relevant records. The reviewer decides whether it is valid.

Each exception needs a clear status, assigned owner, due date, and resolution note. If the item is unresolved, the account should remain out of the approved billing file. That is safer than letting a warning appear in a report that nobody owns.

This is a good place for an agent to help with administrative work. It can gather supporting records, summarize the discrepancy, and send the item to the right reviewer. It should not change a signed fee term or override an approval rule by itself.

Step 4: Get approval before billing

Before anything is sent to a billing platform, custodian, or client, the reviewer should see a complete run summary. That summary should include total fees, account counts, exceptions, adjustments, and comparisons with the previous quarter. The reviewer should be able to open the calculation detail for an individual account.

A second approver may be appropriate for high-value adjustments, unusual fee changes, or files above a firm-defined threshold. The approval should capture who approved the run, when they approved it, what version they reviewed, and whether any exceptions remained open.

After approval, the workflow can prepare the agreed billing output. That might be a file for upload, a set of instructions for a billing platform, or a report for staff to process. Keep the handoff separate from the approval itself. A person should be able to confirm that the approved file is the file being sent.

This same discipline applies to later questions. If a client asks why a fee changed, staff should be able to retrieve the agreement, inputs, calculation, exception notes, and approval without reconstructing the process from inboxes and saved spreadsheets.

For firms working on the next step after calculating a fee, automating advisory fee reconciliation explains how to compare expected charges with what was actually billed or collected.

What the end-to-end agent workflow looks like

An agent-supported quarterly run can follow a defined sequence:

Open the billing period. A scheduled workflow creates the run for the quarter and records the relevant valuation date, billing rules, and staff owners.
Collect approved inputs. It retrieves the account roster, balances, status changes, and current fee schedules from connected systems or controlled uploads.
Validate the data. It checks for missing values, duplicate records, date mismatches, and account-to-agreement gaps. It creates assigned exceptions rather than guessing.
Calculate fees. It applies the firm’s documented formulas and records the inputs, rules, and result for each account.
Prepare exception summaries. It gathers the related records and explains what needs review, such as a balance change or missing agreement.
Request approval. It presents the run summary and detail to the authorized reviewer. The workflow holds the billing output until approval is recorded.
Prepare the handoff and retain the audit trail. It creates the approved billing file or instructions and stores the run details, approvals, and exception resolutions.

The agent does not need authority to change fee terms, approve its own output, or send charges without a human sign-off. Keeping those boundaries explicit makes the workflow easier to test and easier for staff to trust.

A workflow may connect this work to related operations. Other workflows can support meeting preparation or document drafting, subject to the firm’s controls. Those agents don’t calculate quarterly fees, but the same question applies to each: what data can it use, what work can it complete, and where must a person approve the result?

If quarter-end work also includes preparing client reviews, see how to automate QBR preparation for advisory firms. The goal is to reduce the manual handoffs without removing the controls that protect the client and the firm.

Measure value in the firm’s own numbers

Before building, estimate the current cost of the process. Count the staff hours spent collecting data, checking agreements, fixing spreadsheet errors, asking advisers for decisions, preparing billing files, and responding to fee questions. Include review time, not just the time spent entering numbers.

Then compare the cost with the outcomes the workflow needs to improve:

Fewer manual steps per billing run
Fewer unresolved records at the approval deadline
Faster time from quarter-end to approved billing
Fewer corrections after billing
A clearer audit trail for client and compliance questions

Use the firm’s actual volumes and loaded staff costs. A firm with a small number of straightforward accounts will have a different case from one with multiple custodians, old agreements, and household-level fee schedules. The aim is to identify where the process loses time or creates risk, then set a realistic target.

For a working session on the process, book a 60-min Omni Audit. We map the current workflow, identify the control points, and define a sensible first automation step.

Start with one controlled billing run

Don’t begin by automating every fee arrangement in the firm. Choose a representative group of accounts with clear agreements and reliable data. Document the rules, run the calculation in parallel with the existing process, and compare every result before relying on the new workflow.

Use the parallel run to find gaps in source data and policy. If the automated result differs, record the reason. Was the account mapped incorrectly? Was the agreement out of date? Did staff apply an undocumented convention? Resolve the cause before expanding the workflow.

Then add more complex arrangements in stages. Keep an owner for each rule, test changes before a live billing run, and retain the option to stop the workflow if a required source or approval is missing. Those steps help keep automation useful as the firm adds clients, custodians, or fee structures.

A quarterly fee workflow is a good candidate for automation because it repeats and has clear points where data, calculation, review, and approval meet. It still needs human judgment for exceptions and unclear agreements. The right design gives staff fewer routine checks to perform and better evidence when something needs their attention.

Get a practical audit of the workflow

A workflow audit can help map the current process, identify automation opportunities, and consider a first workflow with its control points.

Bring a recent billing checklist, a sample of the fee schedules, and an example of an exception your team had to resolve. You don’t need to share client-sensitive information for the conversation. The aim is to understand how the work moves through your firm and where a controlled agent workflow could help.

See Omni for financial advisory firms for the vertical-specific audit details, or book your 60-min Omni Audit to map the workflow with our team.

How to Automate Quarterly Advisory Fee Calculations