What auditors look for

Commission audits come from multiple directions: state insurance regulators reviewing producer compensation, carrier contract audits confirming you are applying comp schedules correctly, and internal or external financial audits verifying that commission expense is accurately recorded.

Each type of auditor is asking a slightly different question, but they all converge on the same evidence: for a given payment to a given producer, can you show exactly why that specific amount was paid, who approved it, and what the source data was that drove the calculation?

The agencies that struggle in audits are not the ones with errors in their records — some errors are inevitable. The ones that struggle are the ones that cannot answer the question systematically. The calculation was done in a spreadsheet that no longer exists. The approval was an email that was deleted. The carrier statement was overwritten when the next month's file came in with the same name.

The complete trace chain

An auditable commission record has a complete chain of custody from the source data to the payout. That chain has five links:

  1. The source statement row — the original, unmodified carrier statement row that reported the policy, premium, and paid commission amount.
  2. The policy record — the policy in your system that the statement row was matched to, including the effective date, carrier, product, and agent assignment.
  3. The comp rule version — the specific version of the compensation plan that was active on the statement date, defining the rate, plan type, and calculation method.
  4. The approval record — the documented approval of the commission amount by the appropriate role, with a name, role, and timestamp.
  5. The payout record — the payout batch entry showing the net amount disbursed, deductions applied, and the payment reference.

If any of these five links is missing or cannot be reconstructed, the chain is broken. A broken chain does not necessarily mean the payment was wrong — it means you cannot prove it was right.

Calculation traceability

The most common gap in commission audit trails is the calculation itself. An agency knows what was paid (it is on the producer's statement) and what the carrier sent (it is on the carrier statement), but cannot show how one led to the other.

Calculation traceability requires that every commission entry in your records includes the formula inputs that produced it: the annualized premium, the rate applied, the plan type used, the policy year (for graded schedules), and the comp rule version ID. With these inputs, any reviewer can independently verify the calculation by applying the formula.

This is why spreadsheets fail as commission records. A spreadsheet cell contains a result. It may contain a formula. It does not contain which policy record fed the formula, which contract version defined the rate, or who changed the formula last and when.

What audit-ready looks like: For a specific payout line item, a reviewer can pull up: the policy number, the carrier statement row, the effective date, the comp plan version with its rate, the formula applied, the calculated result, and a log of every modification made to this record with the date and user.

Approval records

Commission approvals are only useful as audit evidence if they are stored with enough context to be meaningful months or years later. An email that says "Approved — looks good" is not an audit record. An approval record in a commission system that stores: who approved, at what timestamp, the batch total they approved, and a reference to the specific payout batch — that is an audit record.

Approval workflows should require the approver to confirm a specific amount, not just click approve. This creates a stronger audit record and forces the approver to engage with the numbers rather than acting as a rubber stamp.

The approval record must be append-only. It cannot be deleted or modified after the fact. If a batch is approved in error and needs to be reversed, the reversal should be a separate record that references the original approval — not an edit to the original.

Producer statements as evidence

Producer-facing payout statements serve a dual purpose: they communicate to producers what they are being paid and why, and they create a contemporaneous record of what was disclosed at the time of payment. If a producer disputes a payment from 18 months ago, the statement is the primary evidence of what they were told.

For statements to serve as evidence, they need to be: generated from the commission calculation record (not reformatted from a spreadsheet), stored permanently and linked to the payout batch, and clearly versioned so that post-close adjustments appear as distinct line items rather than modifications to the original.

Statements should also be delivered to producers with a documented delivery record — a timestamp showing when the statement was made available and, if applicable, whether it was opened or downloaded.

Exportable evidence packages

When an audit request arrives, you should be able to produce an evidence package within hours, not days. An evidence package for a commission audit typically includes: the carrier statements for the relevant period (original files), the commission calculation records for all affected policies, the approval records for the relevant payout batches, and the producer statements for the period in question.

If your commission records are in spreadsheets and email threads, assembling this package will take days and will likely have gaps. If your records are in a purpose-built commission system with audit exports, the package is a report run.

Design your record-keeping so that the export is a button, not a project.

The audit readiness self-test

Run this test on your current commission records. Pick a payout from three months ago and answer these questions:

  • Can you find the original carrier statement file that drove this payout?
  • Can you show which statement rows matched to which policies?
  • Can you show the comp plan version and rate that was applied to each policy at that time?
  • Can you show who approved the payout, when, and the amount they approved?
  • Can you produce the producer statement that was sent for that period?
  • Can you show a complete log of every modification made to any record in that pay cycle?

If you can answer yes to all six questions in under 30 minutes, your commission process is audit-ready. If any answer is no, that gap is where your audit risk lives.