Command: monthly-commission-recon

Match all carrier statements and open a task with the dollar delta for every discrepancy.

Inputs

Carrier statements — PDF or CSV exports from all commissions, for the reporting month (e.g., jan_statements.zip). Include carrier name and policy count.

Period — month and year for reconciliation (e.g., {2026-01}). Defaults to the current month.

Commission ledger — internal accounting export (e.g., QuickBooks or custom ledger) for the same period, showing earned commissions by carrier.

Threshold — dollar amount above which to flag a delta (e.g., {50}). Defaults to 25.

Assignee — person responsible for investigating discrepancies (e.g., {operations-lead}). Defaults to finance team.

Steps

1. Extract carrier name, policy count, and total commissions from each statement.
2. Compare each carrier's reported commissions against your ledger entries. Note any missing policies, overages, or unexplained deductions.
3. Calculate the net delta (ledger minus statement) for each carrier.
4. Filter deltas greater than your threshold amount.
5. For each flagged discrepancy, open a task with the carrier name, delta amount, date range, and supporting docs.
6. Assign the task to your designated reviewer for follow-up (e.g., contact carrier for explanation or correction).

Constraints

• Reconciliation is clerical only. If a delta suggests a coverage or policy issue, escalate to a licensed agent immediately—do not investigate claim history or policy terms yourself.
• Do not modify commissions or ledger entries. Flag and delegate.
• Missing statements or incomplete data halt the reconciliation—request updates from carriers and re-run.

Done when: all carrier statements are matched against your ledger, every delta exceeding your threshold is logged as a task, and each task is assigned for review.