Automated RIA AUM Fee Billing Reconciliation
Each billing cycle, WebRun opens Charles Schwab Advisor Center to pull every account's billable value, checks it against the fee schedule and tier on file in Redtail Technology, logs every account to Google Sheets, and posts a Slack alert for any mismatch above your threshold.
How do I catch AUM fee billing errors before invoices go out?
WebRun reconciles advisory fees each billing cycle by pulling live account values from Charles Schwab Advisor Center and comparing them against the fee schedule on file in Redtail Technology. It logs every household to Google Sheets and posts a ranked Slack alert for any mismatch, so billing errors get caught and corrected before they reach a client statement.
- Billing mismatches get caught before invoices reach a client
- Every household is reconciled against live custodian data each cycle
- The largest dollar errors are surfaced first, not buried in a spreadsheet
Built for Registered Investment Advisors · RIA operations staff · billing administrators · compliance teams
What does WebRun do on every run?
The exact actions WebRun takes, in order - in plain language, so you can adjust anything.
-
WebRun signs in and gets to work
Opens
www.redtailtechnology.comin a real browser with your saved login - no setup, no API keys. -
1
Redtail Technology - pull each household's fee schedule
redtailtechnology.com
WebRun opens Redtail Technology to pull each household's fee schedule. - Open Redtail Technology and list every billable household
- Capture the fee schedule, tier, and billing frequency on file for each
- Note any household marked as fee exempt or under a special arrangement
Done when Every billable household has its fee schedule captured.
-
2
Charles Schwab Advisor Center - pull billable account values
schwab.com
WebRun opens Charles Schwab Advisor Center to pull billable account values. - Open Charles Schwab Advisor Center and pull the billable account value for each household
- Match each account to its household in the reconciliation list
- Recalculate the expected fee from the value and the schedule on file
Done when Every household has an expected fee calculated from live custodian data.
-
3
Google Sheets - log the reconciliation
google.com
WebRun opens Google Sheets to log the reconciliation. - Log the account value, expected fee, and billed fee side by side for every household
- Highlight any row where the billed fee differs from the expected fee
- Keep a running tab per quarter so you can compare cycles
Done when The full reconciliation for the cycle is logged in Google Sheets.
-
4
Slack - alert on mismatches
slack.com
WebRun opens Slack to alert on mismatches. - Post a summary of how many households were checked and how many mismatched
- List the largest dollar mismatches first with the household name
- Never adjust a fee or resubmit a bill. Only flag it for you to correct
Done when You have a ranked list of billing mismatches in Slack before invoices post.
How is each run configured?
Secure by default
Connect once, stays signed in
WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.
Every action is checked against this policy before it runs.
Questions, answered
Does it change any fees or billing records?
No. WebRun only reads account values and the fee schedule on file, then flags mismatches. It never edits a fee, resubmits a bill, or touches billing records.
How does it calculate the expected fee?
It applies the fee schedule and tier already on file in Redtail Technology to the live billable value pulled from Charles Schwab Advisor Center, then compares that to what was actually billed.
What counts as a mismatch worth flagging?
Any household where the billed fee differs from the recalculated expected fee. Every mismatch is logged, and the largest dollar differences are surfaced first in Slack.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.