Tax Season Shouldn’t Be a Scavenger Hunt. Here’s How to Pull Your State Revenue in Minutes.

For single-state agencies, tax prep is straightforward. For everyone else — agencies writing business across multiple states, holding non-resident licenses in half a dozen jurisdictions, managing clients whose addresses span the map — the question of how much revenue came from each state is one that somebody has to answer every year. And in most agencies, answering it means pulling reports, filtering by state, adding up numbers, and hoping nothing got missed.

Commission Tracker has a built-in solution for this that most agencies don’t know exists.

The Commissions by State report generates directly from the Agency Payments Received report by setting the Group By filter to Client State. Navigate to Reports, select Agency Payments Received, set your date range to the tax year or period you’re analyzing, group by Client State, and run it. What comes back is a clean breakdown of gross revenue earned in each state your clients are located in — either as a summary with bottom-line totals per state, or as a full detail report that breaks down revenue by client and policy within each jurisdiction.

The summary format is what most agencies reach for at tax time. You need a number for each state, and the summary gives you exactly that — one line per state, total commission received, no extra noise. Hand it to your accountant and you’re done.

The detail format is where the report becomes a more powerful tool. If a state tax authority questions your reported revenue for a given jurisdiction, or if you need to verify which clients are contributing to your non-resident license threshold in a particular state, the detail view shows you every policy that fed into the total. You can see exactly which clients are driving your presence in each state and trace any individual number back to its source.

The report’s accuracy depends on one thing being set up correctly: the State field on each client’s address record needs to be populated. The system associates every payment received with the state listed on the primary client record, so if client addresses are incomplete, the report will either show a blank state or undercount certain jurisdictions. If you’re planning to run this for the first time before a filing deadline, it’s worth doing a quick audit of your client records first to make sure the state field is populated across the board. A few missing entries won’t break the report, but they will affect the totals.

For agencies with non-resident licenses, the Commissions by State breakdown also serves as a compliance checkpoint. Many states have revenue thresholds that determine whether a non-resident license is required, and keeping an eye on how much business you’re doing in each state is part of managing that exposure. Running this report quarterly rather than just at year end gives you an early warning if you’re approaching a threshold in a state where you don’t currently hold a license — which is significantly less stressful than finding out after the fact.

The regional growth angle is worth noting too. When you can see at a glance which states are producing the most commission revenue, you have a data-driven basis for decisions about where to focus marketing, which non-resident licenses are worth maintaining, and where there might be untapped opportunity. Commission data has a lot to say about where your business actually lives — the Commissions by State report is one of the clearest ways to read it.