Source file retention
Every carrier statement that comes into your agency is a legal and financial document. When a producer disputes their payout six months from now, the first question will be: what did the carrier actually send? If you cannot produce the original file, you cannot defend your calculation.
Most agencies store carrier statements on someone's desktop or in a shared drive with an inconsistent naming convention. When the person who saved the file leaves, the trail ends. A payout control starts with a defined, consistent retention policy for source files.
Control: Every carrier statement must be stored in a named location with the carrier name, statement period, and import date in the file name. Files must not be modified after import — the original is the record. Retention minimum is 7 years to cover potential audit and dispute windows.
Growth risk: As you add carriers, the number of statement files per month grows proportionally. Without a consistent intake process, older statements get overwritten or lost as storage management becomes informal.
Contract versioning
Compensation contracts change. Carriers update rate schedules, modify chargeback windows, and reclassify products. When a contract changes and your system does not capture the version history, you cannot correctly calculate commissions for any policy that spans the contract change date.
This creates a class of systematic error that is nearly impossible to detect after the fact: commissions calculated before the contract change date at the wrong rate. The calculation looked correct at the time because the system had no prior version to compare against.
Control: Each compensation plan in your system must have an effective date and an optional termination date. When a carrier updates a rate schedule, do not modify the existing plan — create a new version with the new effective date. The system uses the plan version active on the policy statement date to calculate expected commissions. Old versions are never deleted.
Growth risk: As you grow from 3 carriers to 15, the number of contract renegotiations per year increases. Without a versioned system, each renegotiation creates a calculation gap.
Exception ownership
Exceptions are the reconciliation items that did not match automatically. An unowned exception is money in limbo — neither confirmed as paid nor flagged for recovery. In a well-run operation, every exception has an owner, a due date, and a resolution status.
The most common exception ownership failure at growing agencies is role ambiguity. Finance thinks operations is reviewing carrier exceptions. Operations thinks finance approved them already. The exception ages past 60 days and becomes much harder to resolve with the carrier.
Control: Every exception must be assigned to a named owner within 48 hours of appearing in the queue. Exceptions over 14 days old must have a documented status update. Exceptions over 30 days old must be escalated to a manager. The exception queue is a tracked work item, not a holding area.
Growth risk: Exception volume scales with transaction volume. At 10 carriers × 200 policies each, a 2% exception rate produces 40 open items per month. At 20 carriers × 500 policies, that becomes 200 items. An informal process that worked at 40 breaks at 200.
Approval gates
Approval gates are checkpoints that require a second reviewer before a payout batch moves to disbursement. They exist to catch calculation errors, override irregularities, and contract misapplications before producers receive incorrect payments. An incorrect payment is far more expensive than a delayed payment — the agency has to claw it back and explain it, which damages producer trust.
A minimal approval workflow has two gates: operations approves that the reconciliation is complete and all significant exceptions are resolved; finance approves the final payout batch amounts and certifies they match the approved commission register.
Control: Define which roles can approve each gate. No single person should both calculate commissions and approve their own payout. The approval record — who approved, when, and at what total — must be stored with the payout batch record permanently.
Growth risk: Fast-growing agencies often have one person doing calculation, reconciliation, and approval. This is a significant control gap. Separate these responsibilities as soon as headcount allows.
Statement publishing
Producers should receive a payout statement for every pay cycle. The statement shows the policies that generated commission, the comp plan rate applied, any chargebacks or advance repayments deducted, and the net amount they will receive. Without a statement, the producer cannot verify their payout — and if they cannot verify it, they will dispute it.
Most disputes are not about fraud. They are about information asymmetry: the producer does not understand why their payout changed month over month. A detailed statement eliminates most of those questions before they become disputes.
Control: Every pay cycle must produce a producer-facing statement that itemizes commissions by policy, deductions by type, and a running YTD total. Statements must be distributed within 3 business days of payout. Statements must be archived and accessible to the producer for at least 36 months.
Post-close adjustments
Sometimes a commission error is discovered after a pay cycle closes. A carrier sends a corrected statement. A comp plan was applied at the wrong rate. A chargeback was calculated on the wrong policy. Post-close adjustments are inevitable — the control question is whether they are documented, approved, and traceable.
An undocumented adjustment is indistinguishable from manipulation. Even if the adjustment is entirely correct, if it has no paper trail, it creates compliance risk and erodes producer trust.
Control: Every post-close adjustment must include: the original payout ID, the reason for the adjustment, the calculated delta, and approval from a Finance role. Adjustments must appear as separate line items on the producer's next statement with the original period referenced. No adjustment is silently applied to a future payout without disclosure.
The monthly close checklist
Use this checklist at the end of each commission cycle. Each item should have a designated owner and a completion date before the payout batch is approved.
Week 1 — Statement intake
- All carrier statements for the period have been received and stored with consistent naming
- Statement files have been imported into the commission system without modification
- Import validation errors have been reviewed — no rows silently dropped
- Product code mapping has been verified — no new carrier codes left unmatched
Week 2 — Reconciliation
- Matching engine has been run against all imports
- All high-confidence auto-matches have been reviewed and posted
- Exception queue has been cleared of items from prior periods
- New exceptions have been assigned to named owners with due dates
- Exceptions representing more than 1% of expected revenue have been escalated
Week 3 — Payout calculation
- Commission calculations have been run using current comp plan versions
- Chargeback calculations have been verified against contract windows
- Advance repayments have been correctly applied
- Producer split percentages have been verified against current contracts
- Payout batch totals have been reconciled against approved commission register
Week 4 — Approval and distribution
- Operations has approved that reconciliation is complete
- Finance has approved payout batch amounts
- NACHA or payment file has been generated and reviewed
- Producer statements have been generated and distributed within 3 business days
- All approvals recorded with name, role, timestamp, and batch total
- Any post-close adjustments from prior period have been documented and disclosed