Understanding Direct Bill Commission Tracking for Insurance Brokers

Direct bill commission tracking is the process of verifying that carrier commission payments match what your agency earned on every carrier-billed policy - and recovering the difference when they do not. The average independent agency loses 3-5% of direct bill commissions annually due to carrier errors, rate misapplication, and unreconciled discrepancies. For an agency earning $500,000 in annual direct bill commission, that is $15,000-$25,000 left uncollected each year. The errors are not random: carrier commission statements contain inaccuracies on 5-8% of policies, and the same categories of errors repeat across carriers.

This guide covers the full reconciliation workflow, the most common error types, the 15-day reconciliation cadence, and the AMS tools that automate most of the process.

Key Takeaways

• Carrier commission statements contain errors on 5-8% of policies; without monthly reconciliation, agencies lose 3-5% of earned direct bill commissions annually
• The 15-day reconciliation rule: complete reconciliation within 15 days of receiving each carrier's monthly statement - disputes submitted after 90 days are routinely rejected by carriers
• The three most common errors: wrong commission rate applied, endorsement commission missing, and cancellation credit not processed
• Applied Epic, AMS360, and HawkSoft all support commission download and matching workflows; reconciliation time drops from 15-20 hours per month to 2-3 hours with proper AMS configuration
• Override commissions and contingency commissions require separate tracking processes from base commissions
• Agencies need a discrepancy log with carrier, policy number, amount, dispute date, and resolution status - this log is the only way to verify disputes reach resolution

How Direct Bill Commission Flows

Under direct bill, the carrier invoices the client, collects premium, and calculates your commission based on the commission rate in your appointment agreement. The commission statement arrives monthly (or per-payment, at some carriers) and shows every policy the carrier processed that period, the premium collected, the commission rate applied, and the net commission paid.

Your agency receives the commission wire or ACH, then must verify that what arrived matches what you earned. This verification is commission tracking.

The information gap: The carrier's calculation is based on its own premium records. Your expected commission is based on your AMS records. Errors occur when the carrier's records differ from yours - a rate change not propagated correctly, an endorsement not reflected in the commission system, a cancellation credit processed weeks late. The reconciliation process is how you find and close these gaps.

The 15-Day Reconciliation Workflow

Complete reconciliation within 15 days of receiving each carrier's monthly statement. Disputes submitted after 90 days are routinely rejected by carrier commission teams. Running this process on a 15-day cadence verifies disputes are submitted while the transactions are still within the carrier's review window.

Step 1: Load expected commissions into the AMS before the statement arrives.

Every time a policy is written, record the expected commission in your AMS:

• Policy number
• Effective date
• Gross premium
• Commission rate (from the appointment agreement, verified against the dec page)
• Expected commission dollar amount
• Billing type (flagged as direct bill)

This record is your benchmark. It should be created at policy inception, not retroactively.

Step 2: Receive and import the carrier commission statement.

Commission statements arrive in three formats depending on the carrier:

• PDF - requires manual entry or scanning/OCR
• CSV/Excel - importable into most AMS platforms
• Electronic download via carrier portal - directly importable into Applied Epic and AMS360 via ACORD or proprietary data formats

Carriers offering electronic downloads include Hartford (via Hartford Connector), Travelers (via Producer Portal), Liberty Mutual (via Aspire), and Progressive (via ForAgents). Electronic downloads eliminate data entry errors in the import step.

Step 3: Match statement lines against expected commissions.

Compare each line on the carrier statement against the corresponding AMS record. Match on: policy number, premium amount, commission rate, and commission dollar amount. Flag any line where actual differs from expected by more than your tolerance ($25 is a reasonable threshold for most agencies).

Applied Epic workflow: Use the Commission Download feature (Agency → Commission → Download). Epic matches downloaded commission data against policy records automatically and generates an exception report showing unmatched items and rate discrepancies.

AMS360 workflow: Use the Direct Bill Commission module (Management → Direct Bill Commission). AMS360 imports commission data from carrier downloads and matches against policy premium records. The exception report shows mismatches by category.

HawkSoft workflow: Use the Commission Reconciliation tool under the Agency menu. HawkSoft supports CSV import and manual matching. Its exception report is less automated than Epic or AMS360 but functional for agencies under 300 policies.

Step 4: Categorize and quantify discrepancies.

For each flagged discrepancy, identify the error type:

Step 5: Submit disputes within 15 days of statement receipt.

Submit disputes through the carrier's preferred channel: carrier portal (fastest), email to the commission team (standard), or written letter (slowest, required by some carriers for disputes above a dollar threshold).

Every dispute submission should include: agency name and NPN, policy number, effective date, the commission amount paid, the commission amount owed, the specific error type, and supporting documentation (appointment agreement commission schedule, endorsement dec page, or cancellation notice).

Step 6: Log every dispute and track to resolution.

Maintain a discrepancy log with these fields:

Review the log weekly. Disputes that are open for more than 30 days require a follow-up contact. Disputes that reach 60 days without resolution should escalate to a carrier manager or agency network contact.

Building a Tracking System: Manual vs. Automated

Manual tracking works for agencies with:

• Fewer than 5 carrier appointments
• Fewer than 200 direct bill policies
• Commission statements that arrive consistently and on time

Use a spreadsheet with one row per policy, columns for expected commission by month, and conditional formatting that flags when actual commission received is more than $25 below expected.

Automated tracking is necessary for agencies with:

• 5 or more carrier appointments
• More than 200 direct bill policies
• Multiple producers with separate commission tracking needs

Automated tools - including Applied Epic's commission download module, AMS360's Direct Bill Commission module, and dedicated reconciliation tools like BrokerageAudit - ingest carrier statements, match against AMS records, and flag discrepancies without manual line-by-line review. Reconciliation time drops from 15-20 hours per month to 2-3 hours focused on exception resolution.

The cost of not automating: At 15-20 hours per month of manual reconciliation at a billing manager's loaded hourly rate of $35-$45, manual reconciliation costs $6,300-$10,800 annually. Automation reduces this to $840-$1,350 in labor. Most agencies break even on reconciliation automation within the first year.

Tracking Override and Contingency Commissions

Override commissions and contingency commissions require separate tracking from base commissions.

Override commissions are volume-based bonuses paid by carriers or agency networks for meeting premium volume thresholds. They are calculated on total written premium and paid quarterly or annually. Track overrides against the override schedule in your carrier or network agreement. Verify that each quarterly payment matches the volume you wrote in that period at the contracted rate.

Contingency commissions are profit-sharing payments based on the loss ratio and premium growth of your book at each carrier. They are calculated annually and paid 60-120 days after year-end. Track contingency against the carrier's contingency formula. Verify that the carrier's reported loss ratio and premium volume match your records. Disputes over contingency calculations are the highest-dollar disputes agencies face - errors of $5,000-$50,000 are not unusual for mid-size agencies.

Common contingency errors:

• Carrier excludes claims from the loss ratio calculation that were subsequently subrogated and recovered (should reduce losses)
• Carrier includes premium for policies that were cancelled and returned, inflating the premium base without the corresponding claim reduction
• Carrier applies the wrong effective date for rate changes, shifting premium between measurement periods

Track contingency separately from base commissions. Maintain your own running loss ratio calculation for each carrier and compare quarterly against carrier-reported data. Discrepancies caught during the year are easier to resolve than those disputed after the annual calculation is finalized.

Carrier-Specific Commission Statement Notes

Hartford: Monthly commission statements via Hartford Connector (downloadable CSV, importable into Applied Epic and AMS360). Commission download includes endorsement adjustments and cancellation credits. Disputes submitted through the Connector portal; resolution averages 30 days.

Travelers: Commission statements available weekly via Producer Portal (CSV download). Endorsement commissions are included in the statement period they process, usually within 2 weeks of the endorsement. Disputes submitted via the Producer Portal; Travelers averages 20-25 day resolution time.

Liberty Mutual: Monthly statements via Aspire portal (PDF and CSV). Commission downloads are compatible with AMS360 import. Liberty Mutual's cancellation credit processing runs 30-45 days behind effective date - a common source of short-term statement discrepancies that resolve in the following month's statement.

Progressive: Commission reports via ForAgents portal (CSV). Progressive pays direct bill commission weekly, making reconciliation cycles shorter. ForAgents data integrates with Applied Epic via the ACORD commission download protocol.

For the full comparison of billing models and their reconciliation implications, see our direct bill vs agency bill insurance guide. For a complete breakdown of direct bill's trade-offs, review direct bill advantages and disadvantages.

FAQ

What are the key considerations for direct bill commission tracking?

The three critical considerations are data accuracy (AMS policy records must reflect the correct premium and rate before statements arrive), reconciliation frequency (15 days after statement receipt is the working standard), and dispute follow-through (every flagged discrepancy must be tracked to a final resolution, not abandoned when the carrier is slow to respond). Agencies that miss any one of these three lose commission systematically.

How does poor commission tracking affect agency financials?

The direct revenue impact is 3-5% of direct bill commission lost annually to unreconciled errors. On $500,000 in direct bill commission, that is $15,000-$25,000. The secondary effects are equally damaging: inaccurate producer compensation (producers are underpaid if commissions are understated in the AMS), unreliable profitability analysis (you cannot make accurate book-of-business decisions if your commission data has a 3-5% error rate), and incorrect contingency commission tracking (which compounds the underpayment risk to the highest-value payments).

What mistakes should agencies avoid with direct bill commission tracking?

Mistake 1: Skipping months and catching up quarterly. Carriers reject disputes over 90 days old. Quarterly reconciliation means disputes from months 1 and 2 of the quarter are already at risk. Mistake 2: Accepting statement totals without line-by-line verification. Carriers are accurate at the aggregate but error-prone at the policy level. Mistake 3: Failing to track endorsement commissions separately. Endorsements are frequently omitted from commission statements and require a separate lookup against endorsement dec pages. Mistake 4: Not maintaining a discrepancy log with follow-up dates.

What tools are available for direct bill commission tracking in 2026?

Applied Epic (Applied Systems) offers a Commission Download module that imports carrier data and generates exception reports. AMS360 (Vertafore) has a Direct Bill Commission module with import and matching capability. HawkSoft supports CSV import and manual matching with exception reporting. Dedicated reconciliation tools like BrokerageAudit automate statement ingestion, AMS matching, discrepancy categorization, and dispute tracking across all carriers in a single dashboard. Carrier portals - Hartford Connector, Travelers Producer Portal, Liberty Aspire, Progressive ForAgents - provide source commission data for import.

How is direct bill commission tracking changing in 2026?

Three trends are reshaping the process. First, ACORD data standards for commission downloads are becoming more widely adopted, reducing the format inconsistency between carriers. Second, real-time commission reporting is replacing monthly batch statements at Travelers and Progressive, compressing the reconciliation cycle from 30+ days to near-real-time. Third, AI-powered reconciliation tools can now detect likely errors before the statement arrives by analyzing endorsement and cancellation activity in the AMS and predicting which policies will have missing or incorrect commission. These tools flag issues for staff to verify rather than requiring staff to discover them through line-by-line review.

What best practices produce the lowest commission leakage rate?

Reconcile within 15 days of every carrier statement receipt - no exceptions. Record expected commission on every new policy at inception, not retroactively. Maintain a discrepancy log updated weekly. Follow up on open disputes at 30 days and escalate at 60 days. Separate override and contingency tracking from base commission tracking - keep three separate tracking processes. Review commission rates in the AMS at every renewal; outdated rates are a systematic source of expected-vs-actual gaps that are easy to miss because they are small per policy but large in aggregate. Conduct a quarterly audit of the carrier appointment schedules against the rates loaded in the AMS.

Written by Javier Sanz, Founder of BrokerageAudit. Last updated April 2026.

The average agency loses $15,000-$25,000 per year in untracked direct bill commission errors. BrokerageAudit ingests carrier commission statements, matches them against your AMS records, and surfaces every discrepancy automatically - so you recover what you've earned without spending 15+ hours a month on manual reconciliation. See how we compare →