Skip to content

Agency vs Agent Commission Comparison

The Agency vs. Agent Commission Comparison report is an auditing tool that confirms the total commission received by your agency matches the total commission paid out to agents — including the portion retained by the House. Use it to catch allocation errors before they compound.

💡 Why Use This

Use this report when:

  • You need to audit payouts — Confirm that every dollar received from a carrier has been properly allocated to agents.
  • You suspect a discrepancy — Quickly identify specific payments where an agent was underpaid or overpaid.
  • Reconciling monthly totals — Replace the manual process of comparing the Agency Payments Received and Agent Commissions Earned reports side by side.

🗺️ How to Access

  1. Navigate to Reports → Agency vs Agent Commission Comparison.
  2. Set your Date Range to the period you are auditing.
  3. Select a filter — Carrier, Agent, or Revenue Group.
  4. Choose a report format (see below) and click View Report.

Agency vs Agent Selection Screen

Report Format Variations

The system offers three views of this comparison data depending on your auditing needs.

Agency vs Agent Discrepancy Report

An exception-only report. It shows only payments where there is at least a $1.00 discrepancy between the gross commission received and the total commissions paid out. Use this first to find errors quickly.

Discrepancy Report Preview

Agency vs Agent Reconcile Report

A full audit report. It compares all payments received from the carrier to the total commissions paid out, regardless of whether they match. Use this for a complete picture of a given period.

Reconcile Report Preview

Agency vs Agent Reconcile (Spreadsheet Format)

Provides the same comprehensive data as the Reconcile Report in a flat format. Use this when you plan to export to Excel for further analysis.

Spreadsheet Format Preview

Spreadsheet Data Example

How This Report Generates

  1. The system cross-references the Agency Payments Received (gross) against the calculated Agent Splits.
  2. It subtracts the total agent payouts from the gross received amount.
  3. If a difference exists, it is highlighted to show exactly how much commission remains unallocated or is over-allocated.

🔧 Troubleshooting

Almost every line shows a discrepancy. The most common cause is that the House is not included in calculations. If the agency retains a portion of the commission but the House is not configured as an agent split, that retained amount registers as unallocated. Verify your agent split setup includes a House allocation where applicable.

A specific carrier shows a large discrepancy. Filter the report to that carrier and run the Reconcile format to see every transaction. Look for payments that were posted without agent splits assigned, or payments where splits were entered incorrectly.

The report shows a discrepancy for a single payment I know was correct. Check the Payment Received Date. If a payment spans two periods and was partially applied, the allocation may appear offset. Open the payment in Payment History to verify the split amounts.

I want to run this for just one carrier. Use the Carrier filter on the selection screen to limit the report to a single carrier. The Discrepancy format is the fastest way to find problems within that carrier's payments.

Need help? Contact support@commission-tracker.com