Broker Commission Auditor

The Problem

Brokers facilitate employer group enrollment and are paid commissions based on enrollment volume, plan selection, or renewal. Commission calculations must reconcile against enrollment data: if broker claims 100 members enrolled but enrollment system shows only 80, commission should be adjusted accordingly. Manual reconciliation is tedious and error-prone, especially when brokers manage multiple employer groups with varying commission structures. Brokers have incentive to overstate enrollment; payers must verify commissions monthly or quarterly.

Data Requirements

Data Sources:

• Broker enrollment submission files (Excel, EDI, or portal export) , member names, SSN, plan selection, coverage dates
• Payer enrollment system (HealthEdge, Facets) , authoritative enrolled member list, plan assignments, coverage dates
• Broker agreements , commission rate structure, payment terms, reconciliation schedule
• Commission invoice/payment records , broker's claimed commission and supporting calculation
• Member master file , enrollment effective dates, coverage status, plan selection history

Data Classification:

• Public: None typically
• Internal Structured: Enrollment files, broker agreements, commission payment records
• Internal Unstructured: Broker correspondence, prior reconciliation notes
• External Third-Party: Broker submission files
• Sensitive/Regulated: Member names, SSNs, and enrollment data are PII; subject to HIPAA

Data Quality Requirements:

• Timeliness: Enrollment submissions should be reconciled within 10 to 15 days of receipt; commission invoices reconciled before payment.
• Completeness: Broker submission should match enrollment system within 1 to 2% variance (system delays can cause minor discrepancies).
• Accuracy: Member names and SSNs must match; plan codes must be valid; coverage dates must align with broker submission.

Integration Complexity: Low-Medium , Requires import/matching of broker submissions (typically Excel or EDI) against enrollment system. Most payers have standard ETL processes for this. Rule engine for commission calculation is straightforward. Complexity is mainly in handling broker submission format variations and dispute resolution.

Regulatory Alignment

• Broker Licensing & Compliance: State insurance regulations govern broker compensation; payer should verify compliance.
• Fair Dealing Standards: Broker commission calculations should be transparent and accurate; payer audit demonstrates good faith.

Comparable Implementations

• Benefitfocus Broker Management , Platform for broker enrollment and commission tracking
• Enrollment system reconciliation procedures , Standard Facets/HealthEdge functionality
• Industry best practices , Self-Insured Institute of America guidance on enrollment management