Reconcile advisory fees against AUM each quarter
Each quarter, WebRun opens Orion, pulls the advisory fees billed per account, recalculates the expected fee from each account's average AUM and fee schedule in Google Sheets, flags any account where billed and expected do not match, and sends you a Telegram summary of the exceptions to review before fees are finalised.
- No credit card
- Under $0.01 per run
- Cancel anytime
How do I reconcile advisory fees billed against AUM each quarter?
Each quarter, WebRun opens Orion, pulls the advisory fees billed per account, and recalculates the expected fee from each account's AUM and fee schedule in Google Sheets. It flags any account where billed and expected do not match and sends you a Telegram summary of the exceptions. WebRun reconciles only and never adjusts a fee or bills a client.
- Every account's billed fee is checked against its AUM
- Mismatches are flagged before fees are finalised
- Nothing is ever rebilled or refunded automatically
Built for financial advisors · RIAs · operations teams · billing managers
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
login.orionadvisor.comin a real browser with your saved login - no setup, no API keys. -
1
Orion - pull fees billed and AUM
orion.com
WebRun opens Orion to pull fees billed and AUM per account. - Open Orion and pull the advisory fees billed for each account this quarter
- Pull each account's average AUM for the billing period and its fee schedule
- Capture the account, billed fee, AUM, and applicable rate for each
Done when Billed fees, AUM, and rates are captured for every account this quarter.
-
2
Google Sheets - recalculate and compare
google.com How to Automate Google Sheets
WebRun recalculates expected fees and flags any mismatch in Sheets. - Open the fee reconciliation workbook and add a row per account
- Recalculate the expected fee from each account's AUM and fee schedule, then compare it to the billed amount
- Flag any account where billed and expected differ beyond a small rounding tolerance
Done when Every account is reconciled and mismatches are flagged in the sheet.
-
3
Telegram - summarise the exceptions
telegram.org How to Automate Telegram
WebRun sends a Telegram summary of the fee reconciliation exceptions. - Send a Telegram summary of how many accounts matched and how many were flagged
- List the flagged accounts with the billed amount, expected amount, and the difference
- Note that these are exceptions to review. WebRun never adjusts a fee or issues a refund itself
Done when You have this quarter's fee reconciliation summary in Telegram.
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 adjust fees, bill clients, or issue refunds?
No. WebRun only reconciles the numbers and flags exceptions for review. Adjusting a fee, billing a client, or issuing a refund stays with your team. WebRun surfaces the mismatch so a person can decide what to do.
How does it calculate the expected fee?
It recalculates each account's fee from its average AUM for the period and its fee schedule in Orion, then compares that expected figure to the billed amount and flags any difference beyond a small rounding tolerance.
When does it run?
You start it each quarter on your billing run, so it reconciles the fees right after they are calculated and before they are finalised, giving you a clean exceptions list while there is still time to fix anything.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.