How Independent Insurance Agents Track Commissions Without a Spreadsheet

The standard advice for new independent agents is to keep a separate commission spreadsheet alongside your CRM or AMS, because most platforms either don't track commissions at all or do it poorly. Tower CRM tracks commissions on the deal record itself — pre-configured, no setup, reportable by producer from day one.

Why the spreadsheet workaround exists

Commission tracking is one of those features that sounds simple but breaks down in practice with generic tools.

A generic CRM records deals as won or lost — there’s no concept of a commission amount, a carrier payout, or a producer split. Most AMS platforms handle commissions, but they’re priced for established agencies ($99–$200/month) and configured for agencies that already know their workflow. Neither option works well for a scratch agent building their first book.

The result is a Google Sheet that lives outside your client system. Every time a policy binds, you enter it twice — once in the CRM, once in the spreadsheet. Every month, you reconcile the spreadsheet against carrier statements. It works until it doesn’t, usually when a renewal falls through the cracks or a commission dispute needs a paper trail.

How Tower handles it

Every insurance workspace in Tower ships with a Commission field pre-configured on deals. It’s there when you sign up. No custom field setup, no imported template.

The workflow:

1. Log a deal when a prospect enters your pipeline
2. When the policy binds, update the deal status and enter the commission amount
3. Assign the deal owner — that’s the producer for attribution

That’s it. The commission amount lives on the deal record, connected to the client, the carrier, the policy dates, and the renewal timeline.

The Commission Report

Your Tower dashboard includes a pre-built Commission Report that aggregates commission data by producer automatically. For a solo agent, it’s your personal production summary. For an agency with multiple producers, it’s your scoreboard — who wrote what, by carrier, by month.

Because commission sits in the same reporting engine as your deal pipeline and revenue forecast, you can filter and slice it the same way you would any other metric:

• Commission by carrier — which relationships are most productive
• Commission by month — production trends over time
• Commission by producer — team performance at a glance
• Commission by policy type — where your book is concentrated

The report updates in real time as deals are closed and commission amounts are entered. No export, no pivot table, no reconciliation against a separate file.

Reconciling against carrier statements

When carrier statements arrive, your Tower commission data is the source of truth. Filter by carrier and date range to pull every policy written in that statement period, with commission amounts as logged. Compare against what the carrier paid. Flag discrepancies directly on the deal record with a note.

This is significantly faster than a spreadsheet reconciliation because the data is already organized by carrier — you’re not hunting through rows or sorting columns.

For agencies with multiple producers

Deal ownership in Tower is how producer attribution works. Assign a deal to a producer when it enters the pipeline, and every commission tied to that deal is attributed to that producer in reporting. If ownership changes — a producer leaves, a book transfers — updating the deal owner updates the attribution.

The Commission Report by producer gives agency owners a real-time view of production without asking producers to self-report.

What you don’t need

With commission tracking built into your CRM, you don’t need:

• A separate commission spreadsheet or Google Sheet
• A standalone commission tracking tool
• A full AMS subscription to get commission reporting

The commission data lives where the client and policy data live — one record, one system.