How to Manage Complex Agent Commission Hierarchies Without Spreadsheets
Ara Leiva
May 4, 2026
Want to help more clients?
TALK TO SALESTL;DR: Agent commission hierarchies in insurance distribution involve multiple payout levels, carrier-specific rates, and rules that change as agents advance. Managing these in spreadsheets leads to errors, delays, and frustrated agents. Purpose-built technology lets you configure hierarchy rules once per contract and have the platform handle every downstream payout automatically. This post explains how it works and what to look for.
If you run an IMO or BGA, you already know that commission hierarchies are not simple. A policy written by an agent in your downline might generate commissions at the agent level, the GA level, the MGA level, and your level, each at a different rate, possibly split between multiple people. Multiply that by hundreds of policies and dozens of carriers, and you start to understand why commissions teams spend days on what should take hours.
Insurance hierarchy structures typically flow from the carrier down through the IMO or FMO to MGAs, GAs, and individual agents. Each level has a contractual commission rate with the carrier, and each level must be paid correctly on every transaction. There is no room for estimation. An agent who was shorted because your team miscalculated a split is not going to quietly let it go.
The agencies that manage this well are not doing it by hand.
What Makes Agent Commission Hierarchies So Complex?
Different Rates by Carrier and Level
Every carrier has its own commission schedule. An agent at the GA level with Carrier A gets a different rate than the same agent at the GA level with Carrier B. Your team has to know those rates and apply them correctly for every transaction.
Multiply this across a typical IMO's carrier portfolio, and you might have hundreds of different rate combinations to track. A spreadsheet can hold that data. The problem is keeping it current and applying it accurately under time pressure.
Agents Move Between Levels
Agents get promoted. An agent who starts at the standard level earns their way to the GA level. When that happens, every new policy they write should be paid at the new level. In a manual process, that means updating the agent's record and going back to check whether the level change was applied correctly on recent transactions.
Miss a level change, and you either underpay the agent (a trust problem) or continue paying at the old rate (a revenue leak for the agent and potential carrier confusion).
Shannon Culp, COO at Empower Brokerage, explained how this works in OneHQ's ICM platform: "We can change the agent's level. So we may have an agent who now becomes a GA and the GA has agents underneath them. We're able to go in through the contract side and change their level so that now all of those new policies will capture their new level. We're not touching every single policy. We're only touching the contract."
That is the difference between managing by contract and managing by policy. Managing by policy at scale is not sustainable.
Override Commissions Run Through Multiple Levels
When an agent writes a policy, commissions do not flow only to that agent. There are override commissions due to everyone up the hierarchy who has a stake in that agent's production. If a GA has five agents writing business and those agents are under an MGA who is under your IMO, every policy those agents write generates override commissions at the GA level, the MGA level, and your level simultaneously.
Calculating those overrides manually for every transaction across every carrier is where commission errors concentrate.
Splits and Co-Agent Arrangements
Some agencies split commissions between an agent and a sales manager. Others split between a selling agent and a servicing agent on complex cases. These arrangements are a normal part of the business, but they add another layer of calculation to every affected transaction.
Innovative Brokerage Network uses OneHQ to manage exactly this kind of split. As Debbie Kohlenberger describes it: "We take the percentage of the extra amount that goes to an advisor, and what's left out of that, we do a percentage for our internal sales managers. By setting the path level, the platform knows when a policy comes through and just splits it up the way that it needs to be split without us having to do manual calculations."
Why Spreadsheets Fail at This Scale
Spreadsheets are not the problem in isolation. The problem is using them to manage dynamic, multi-level relationships across a large and growing organization.
The specific failure points are predictable:
Version control breaks down. When multiple people maintain commission data in spreadsheets, you end up with multiple versions. The person processing commissions this week might be working from a different rate table than the one your sales manager updated yesterday.
Level changes do not propagate. Updating an agent's level in a spreadsheet does not automatically update all the calculations that depend on that level. Someone has to manually find and fix every affected formula.
Splits require manual calculation every time. There is no "set it once" in a spreadsheet. Every commission cycle, someone has to remember the split arrangement and apply it correctly.
There is no audit trail. When a commission dispute comes up, a spreadsheet cannot tell you who changed what or when. You are starting from scratch to figure out what happened.
How Purpose-Built Technology Handles Hierarchy Management
Contract-Level Configuration
The right platform lets you configure commission rules at the contract level, not the policy level. You set up each agent's contract with each carrier once: their commission level, any split arrangements, which GA or MGA they roll up to, and any custom rules that apply.
After that, every policy that agent writes is processed according to those contract rules automatically. The platform generates the correct payout calculations for every level of the hierarchy without any additional input from your team.
Automatic Level Updates
When an agent advances to a new level, you update the contract. The platform applies the new level to all subsequent policies automatically. You do not need to revisit individual policies or manually recalculate anything.
This is how Empower Brokerage went from manually touching each policy to touching only the contract. The result was the ability to process three to four times more commission volume without adding staff.
Multi-Level Override Automation
The platform tracks every layer of your hierarchy and calculates override commissions at each level automatically. When a policy comes in for one of your downline agents, the system knows which GA, which MGA, and which IMO level is due an override, and at what rate, based on the hierarchy you have configured.
You can view how OneHQ's ICM handles these multi-level arrangements alongside its other commission and incentive management capabilities.
Split Commission Automation
Split arrangements are configured once per agent or per policy type. The platform applies those splits on every transaction without any manual calculation. This is the "set it and forget it" experience Debbie Kohlenberger described at Innovative Brokerage Network, where advisor and internal sales manager splits run automatically after each commission batch.
What Agents Experience When Hierarchies Are Managed Well
Agents care most about whether their commission is right. When hierarchy management is automated and accurate, agents get what they expect, on time, with no surprises.
The secondary benefit is transparency. When an agent calls to ask why their commission looks different from last month, your team can pull up the transaction and explain exactly what happened. Contract level change? Override adjustment? Split arrangement? It is all documented and accessible.
Agents who trust their IMO or BGA to pay them correctly are more loyal and more productive. See how the OneHQ Agent Portal gives agents direct access to their commission statements, grids, and payment history, so they can verify their own numbers without calling your team.
Checklist: Signs Your Hierarchy Management Needs an Upgrade
- Your commissions team has to manually update spreadsheets when an agent changes levels
- Commission processing takes more than two days per carrier cycle
- You have had disputes about incorrect override amounts in the last year
- When an agent calls with a commission question, your team needs more than a few minutes to find the answer
- You cannot quickly tell a new team member how to process commissions without a lengthy training process
- You are not confident that every split arrangement is being applied correctly on every cycle
If more than two of these are true, a purpose-built platform for hierarchy management will make a material difference.
Ready to see how hierarchy management works when it is automated? Talk to our team and we will walk through your specific setup and show you what a cleaner process looks like.