ComTrack

Reading Statements · Carrier statements

How to Read a Prosperity Life Commission Statement

How to download and read a Prosperity Life commission statement.

Prosperity Life · Includes video

Watch the walkthroughLoom video

Objective

This SOP explains how to download a Prosperity Life commission statement, interpret the key fields, and import the file into ComTrack for easier review and formatting. It is designed to help a team member quickly identify commission details and understand how totals are handled.

Key Steps

1. Download the commission statement from the Prosperity Life agent portal 0:00

Walkthrough screenshot at 0:00

  • Log in to the Prosperity Life agent portal.
  • Navigate to My Business.
  • Select Commission Statements.
  • Choose the statement month or period you want to download.
  • Select the file format, typically CSV.
  • Download the file to your computer.

2. Open the downloaded CSV and identify the main commission fields 0:35

Walkthrough screenshot at 0:35

  • Open the downloaded commission statement file.
  • Review the key columns to understand what each row represents.
  • Identify the following fields:
    • Date Processed: when the premium was processed for commission.
    • Policy Number / Plan Code: identifies the policy and product.
    • Insured: the member enrolled on the policy.
    • Writing Agent Number / Name / Age: Prosperity’s internal agent identifier and related agent details.
    • Effective Date: the coverage start month/date.
    • Pay-To: the date premiums are paid through, if included.
    • Year: the coverage year for the policy.
    • Commission Code: the commission schedule applied.
    • Premium: the amount used to calculate commission.
    • Split: the percentage assigned to the writing agent.
    • Earned Commission: the calculated commission amount.
    • Description: any note or row-level comment from Prosperity.

3. Calculate commission amounts when needed 1:58

Walkthrough screenshot at 1:58

  • Confirm the premium amount used for the commission calculation.
  • Check the split percentage:
    • If the split is 100%, the full premium amount is used for the writing agent.
    • If the split is less than 100%, multiply the premium by the split percentage first.
  • Apply the commission rate from the commission schedule.
  • Example from the transcript:
    • Premium: $122.88
    • Split: 100%
    • Commission rate: 26%
    • Earned commission: $31.95

4. Import the statement into ComTrack for easier formatting 3:05

Walkthrough screenshot at 3:05

  • Open ComTrack.
  • Drag and drop the same commission statement file into the system.
  • Click Digest to process the file.
  • Confirm the import when prompted by selecting OK.
  • Go to All Time Data to view the formatted statement.

5. Review the formatted data in ComTrack 3:35

Walkthrough screenshot at 3:35

  • Verify that ComTrack has organized the statement into readable columns.
  • Confirm the following fields are displayed correctly:
    • Agent Name
    • Carrier
    • Payment Period
    • Client Full Name
    • Effective Date
    • Associated Premium
    • Commission Amounts
  • Check the totals shown at the top of the ComTrack view.
  • Use the formatted layout to make the statement easier to read and analyze.

6. Add totals manually if the source statement does not provide them 4:04

Walkthrough screenshot at 4:04

  • Review the original Prosperity statement for a built-in total.
  • If no total is provided, calculate the total commission manually.
  • Sum the paid commission amounts as needed for reporting or reconciliation.
  • Use ComTrack as a reference point, but do not assume the source file includes totals.

7. Confirm classification commissions in ComTrack 4:14

Walkthrough screenshot at 4:14

  • Review the classification commissions section in ComTrack.
  • Use this section to help categorize or validate commission entries.
  • Compare the classification data against the original statement when needed.
  • Save or document the results according to your internal workflow.

Cautionary Notes

  • Pay-To may appear as zeros or be missing in the export; do not assume this means the policy has no paid-through date.
  • Commission totals may not be included in the original Prosperity CSV, so totals may need to be calculated manually.
  • Year matters because first-year commissions may differ from renewal commissions.
  • Split percentages must be applied correctly before calculating earned commission.
  • Always verify that the file imported into ComTrack matches the original statement month and carrier.

Tips for Efficiency

  • Use CSV format when downloading, since it is the easiest format to import and review.
  • Keep a consistent naming convention for downloaded files by month to make retrieval easier.
  • Use ComTrack to reduce manual formatting and improve readability.
  • When reviewing commissions, check year, split, and commission code first, since these drive the payout calculation.
  • If you regularly reconcile statements, create a simple spreadsheet template for manual total calculations when the source file does not include sums.

https://loom.com/share/9385f393b47040e2bafd28ba6ce023e3