Skip to content

Carrier Commission Table

Carrier Commission Tables are the mathematical engines of Commission Tracker. They define exactly how much revenue your agency expects to receive for a specific product.

These tables are used during Receiving Payments, Importing Carrier Statements, and Carrier Reconciliation to identify underpayments or missing commissions.

💡 Why Use This

Carrier Commission Tables are the foundation of automated commission auditing:

  • Automated Auditing — By defining your contract rates, the software automatically flags whenever a carrier pays less than what was promised.
  • Efficiency — Once a table is created, it can be linked to any policy to automate all future commission math.
  • Accurate Projections — Enables the system to calculate your "Expected" commission vs. the "Actual" commission received.

🗺️ How to Access

Carrier Tables are created and managed on the Carrier record. See Create Carrier Commission Tables for setup instructions.

To assign a table to a policy, select it from the Carrier Table dropdown on the Policy screen within the Carrier Payment Details section.

Supported Table Types

Commission Tracker supports four distinct calculation methods to match various carrier contracts. You only need to create these tables once; then attach the correct table to each new policy.

Table Type Commission Basis Description
Flat % of Premium Commission is a consistent flat percentage of the premium.
Graded % of Accumulated Premium Same as Flat, except the % paid changes as the accumulated premium increases.
Scheduled Fixed Dollar Amount A set dollar amount is paid regardless of the premium or the number of members.
Pay Per Subscriber Dollar Per Member A dollar amount is paid for each member in the group.

Alternatives to Carrier Tables

You are not required to use Carrier Commission Tables if you do not need Commission Tracker to calculate your Expected Commission:

  • Zero Expectation — Set the Carrier Table field to System - None. This results in an expected commission of zero.
  • Manual Override — Use the Commission Per Payment field to manually enter the exact commission expected per billing cycle, bypassing the automated table calculation entirely.

Agency vs. Agent Revenue

Carrier Commission Tables determine the Agency's revenue from the provider. To define how that revenue is split among your staff, you must also configure Carrier Table Agent Splits.

🔧 Troubleshooting

The expected commission is $0 even though a Carrier Commission Table is assigned. Check that the table has rates defined for the policy's current Term Number. If the renewal term column is blank or 0%, the system calculates $0 for that term.

I assigned the wrong table to a policy. Open the policy, select the correct table from the Carrier Table dropdown, and save. Future expected payments will recalculate based on the new table. If payments have already been posted, review them for accuracy.

Need help? Contact support@commission-tracker.com