ComTrack

Reading Statements · Carrier statements

How to Read a Wellcare Commission Statement

How to download and read a Centene / Wellcare Medicare commission statement, tab by tab.

Wellcare · Includes video

Watch the walkthroughLoom video

Objective

This SOP explains how to access a Centene-Wellcare commission statement, interpret the key fields in the Excel file, and optionally upload the statement into ComTrack for easier review and reporting. The goal is to help a team member quickly verify commission details, member information, and payment amounts with confidence.

Key Steps

1. Access the Centene Workbench from the portal 0:00

Walkthrough screenshot at 0:00

  • Log in to your portal.
  • Navigate to the Centene Workbench.
  • This is the starting point for locating commission statements.

2. Open the Statement section 0:18

Walkthrough screenshot at 0:18

  • From the Centene Workbench screen, select Statement.
  • This section contains the available commission statements organized by month.

3. Select the correct monthly statement and download it 0:24

Walkthrough screenshot at 0:24

  • Review the list of statements shown for different months.
  • Choose the statement you need.
  • Download the file, typically by selecting the Excel option.

4. Review the workbook tabs and summary information 0:42

Walkthrough screenshot at 0:42

  • Open the downloaded Excel file.
  • Confirm the workbook includes tabs such as:
    • Summary
    • Detail
    • Legacy
  • In the Summary tab, identify:
    • Payee name
    • Agent NPN
    • Payee NPN
    • Statement date
  • Use this tab to confirm who is being paid and when the statement was generated.

5. Interpret the commission categories in the Summary tab 1:05

Walkthrough screenshot at 1:05

  • Review the description section, which breaks commissions into categories such as:
    • Initial enrollments
    • Renewal enrollments
    • Rapid disenrollments
    • Disenrollments / chargebacks
    • Legacy items
    • Miscellaneous items
  • Check the total to understand the overall commission amount for the statement period.
  • Use the counts and totals to verify that the statement aligns with expected activity.

6. Verify the Detail tab for transaction-level accuracy 1:38

Walkthrough screenshot at 1:38

  • Open the Detail tab to review individual commission records.
  • Match the payment type to the Summary tab (for example, renewal).
  • Confirm the payment description and whether the commission is listed at the broker level.
  • Understand that broker level means the commission is paid to the writing agent rather than an override or upline.

7. Confirm agent, member, and payment fields in Detail 2:15

Walkthrough screenshot at 2:15

  • Review the following fields in the Detail tab:
    • Writing broker name and NPN
    • Earner name and NPN
    • Agency name, if the payment is made to an agency
    • Pay period
    • Payment amount / commission
  • Verify the Medicare beneficiary identifier and member name.
  • Check the sign date and effective date to confirm policy timing.

8. Review plan and cycle information for context 3:03

Walkthrough screenshot at 3:03

  • Locate the cycle year to understand the member cycle count used by Centene.
  • Review the prior plan field to determine whether the member came from another plan.
  • Check the plan type and full plan name to identify the product being paid.
  • Use these fields to distinguish between initial and renewal business.

9. Upload the statement into ComTrack for easier processing 3:45

Walkthrough screenshot at 3:45

  • If the statement is difficult to read manually, open ComTrack.
  • Drag and drop the Excel statement file into ComTrack.
  • Confirm the system is ready to process the file.

10. Run the digest and review the processed output 4:12

Walkthrough screenshot at 4:12

  • Click the Digest button.
  • Confirm the action by selecting OK if prompted.
  • Review the processed data under All Time Data.
  • Verify that the output includes organized columns such as:
    • Agent name
    • Carrier
    • Payment period
    • Client full name
    • Effective date
    • Commission amount
  • Use the formatted output to simplify review and reporting.

Cautionary Notes

  • Do not assume the Summary and Detail tabs will always match without checking. Always verify payment type, amount, and counts.
  • Broker level indicates payment to the writing agent, not necessarily the agency or upline.
  • Some fields may be abbreviated or formatted differently depending on the carrier statement.
  • The naming convention can be confusing; confirm member and policy details carefully before using the data for reporting.
  • If the statement is uploaded into ComTrack, ensure the file is the correct monthly statement before digesting it.

Tips for Efficiency

  • Use the Summary tab first to quickly identify the statement’s overall commission categories and totals.
  • Use the Detail tab only after confirming the summary totals to save time.
  • Upload the file into ComTrack when you need cleaner formatting or faster data review.
  • Keep a consistent checklist for verifying: payee, NPN, payment type, amount, member name, and effective date.
  • Save processed ComTrack output for future reference and reconciliation.

https://loom.com/share/caa0d37284364ad092beda35ee1ad5ee