Skip to content

Commissions by Carrier Table

The Commissions by Carrier Table report (titled Carrier Table Report on screen) lists every Carrier Commission Table you've created, along with its configured rates broken out by policy year. It's a directory of your commission schedules β€” not a revenue summary β€” making it a quick way to audit rate setups across your entire book.


πŸ’‘ Why Use This

Use this report when:

  • Auditing table setups β€” Confirm the rates configured for your Scheduled, Flat, Graded, and PPS tables are correct across every carrier.
  • Reviewing rate structures β€” See every policy-year rate row for a table at a glance, instead of opening each table individually.
  • Documenting contracts β€” Export the full list for recordkeeping or carrier contract audits.

πŸ—ΊοΈ How to Access

  1. Navigate to Reports β†’ Carrier β†’ Carrier Tables.
  2. Click Show Report.

Carrier Tables in the Reports β†’ Carrier menu

Carrier Table Report launch dialog


Understanding the Results

The report groups rows by Carrier, then by Table Name, listing each configured rate row:

  • Start Date β€” The effective date for table versions, where applicable.
  • Table Type β€” Scheduled, Flat, Graded, or PPS.
  • Comm Year β€” The policy term/year the row applies to.
  • Prem / Subs β€” The premium or subscriber threshold the row applies to (for Graded and PPS tables).
  • Value β€” The dollar amount or percentage rate for that row.
  • Overhead / Type β€” Additional table-level settings.

Use Export or Export To Email to save the report as an Excel Workbook (or other supported format) for offline review.

Carrier Table Report results, grouped by carrier and table


πŸ”§ Troubleshooting

A carrier table I expect to see is missing from the report. Confirm the table still exists under that carrier and hasn't been deleted. See Create Carrier Commission Tables.

The report doesn't show revenue totals or agent splits. This is expected β€” this report is a rates directory only. For revenue summaries, use Book of Business or Agency Payments Received.


Need help? Contact support@commission-tracker.com