ComTrack

Reading Statements · Carrier statements

How to Read a Medica Commission Statement

Step-by-step: how to download your Medica commission statement and what every column means.

Medica · Includes video

Watch the walkthroughLoom video

Objective

This SOP explains how to manually access and download a Medica commission statement, how to interpret the key fields in the statement, and how to automate future statement retrieval through ComTrack. It is designed so a team member can quickly find the correct statement, save it in Excel format, and understand the commission details.

Key Steps

1. Log in to Medica and open the Commission portal 0:08

Walkthrough screenshot at 0:08

  • Log in to Medica and complete 2FA authentication.
  • In the Tools section, locate and click Commission.
  • This opens the commission portal where statement history is available.

2. Open statement history and select the correct statement 0:30

Walkthrough screenshot at 0:30

  • Click History to view all available commission statements.
  • Review the list of statements and locate the one you need.
  • Click the Payout Type ID or another clickable row element to open statement details.
  • A side menu will appear with statement options.

3. View the individual legacy statement 1:01

Walkthrough screenshot at 1:01

  • Confirm you are in Individual Statement Legacy.
  • Open the statement to display the full commission details.
  • Verify that the statement shown matches the correct period before downloading.

4. Save the statement as an Excel file 1:12

Walkthrough screenshot at 1:12

  • Click Save on the statement page.
  • When prompted for a file format, select Excel.
  • Download the file to your computer for use in ComTrack or other internal workflows.

5. Review and interpret the statement fields 1:37

Walkthrough screenshot at 1:37

  • Subscriber ID: Medica member ID for the client.
  • Subscriber Name: Client’s full name, split into last and first name.
  • Policy ID: Policy number, typically the member ID plus the Medica plan code.
  • Product: Plan name and state code.
  • Effective Date: Date coverage began.
  • Biz Type: Business type, such as individual.
  • Term Date: Date the policy ended; blank means the policy is still active.
  • Coverage Months: The payment period the commission applies to.
  • Cycle Year: The year of the client’s relationship with the agent; 1 = first year, 2 = second year, etc.
  • CMS Payment: Indicates whether the payment is for new business or renewal.
  • Writing Agent: Selling agent ID.
  • Earned Broker Name: Agent who received credit for the sale.
  • Payee: Medica agency payee number.
  • Paid Vendor: Agency name that received payment.
  • Total Rate: Flat dollar amount paid per member per month.
  • Commission: Amount paid on that specific row.
  • Date Paid: Date Medica issued the commission payment.

6. Use Retrieve in ComTrack to automate statement collection 4:43

Walkthrough screenshot at 4:43

  • Open Retrieve inside ComTrack.
  • Search for Medica in the list of supported portals.
  • Enter the Medica username and password.
  • If 2FA is required, connect the email account used for authentication.
  • Use Add Gmail or Add Outlook account depending on the email provider.
  • Sign in to grant access to 2FA codes so retrieval can proceed automatically.

7. Run retrieval for a selected date range 5:37

Walkthrough screenshot at 5:37

  • After entering credentials for the desired carriers, click Run.
  • Choose how far back to retrieve statements:
    • Last 30 days
    • Last 2 months
    • Custom timeframe
  • Click Start Retrieve to begin the automated download process.
  • Wait for the files to populate in ComTrack, typically within about 20 minutes.

8. Set up scheduled retrieval for ongoing automation 6:14

Walkthrough screenshot at 6:14

  • Enable Schedule Retrieval to automate future downloads.
  • Set a recurring trigger, such as the first day of each month.
  • Choose the retrieval window, such as the past 31 days or the prior month.
  • Save the schedule so statements are retrieved automatically without manual intervention.

Cautionary Notes

  • Ensure you are in the correct statement view before downloading; the SOP specifically references Individual Statement Legacy.
  • Double-check the date range and statement period so you do not download the wrong commission file.
  • If 2FA is enabled, the connected email account must be accessible and properly authenticated.
  • Use the correct email provider option in ComTrack (Gmail or Outlook) to avoid retrieval failures.
  • Confirm that the downloaded file is in Excel format, since that is the preferred format for working with commission statements.

Tips for Efficiency

  • Use Retrieve in ComTrack instead of manually downloading statements whenever possible.
  • Set up scheduled retrieval to eliminate repetitive monthly manual work.
  • Keep Medica credentials and 2FA access updated so automated retrieval continues without interruption.
  • Save downloaded files in a consistent folder structure for easier tracking and reconciliation.
  • Review the statement fields using the definitions above to speed up commission validation and troubleshooting.

https://loom.com/share/07c57cf62618402bacf9cea8a00b2c30