Revenue Projection

Revenue Projection

The Revenue Projection report projects revenue over a specific period by year and month on Active policies. Revenue is also included from Termed policies while they were active.  Only policies with a comp plan linked to them are included in the report.

Click the attachment below for a sample Revenue Projection report.

Report Parameters

  1. Name
  2. Comp Plan Type - Pct of Premium, Medicare Advantage, Fee, Target Premium or Graded
  3. Primary Field - Individual Client, Group Client, Worksite Client, Agent, Carrier, Product, Type
  4. Secondary Field - All or specific item from Primary Field
  5. Start Date
  6. End Date - results available up to 10 years.

Report Results 




Add

  1. Go tothe  Main Menu.
  2. Click Reports – Revenue Projection.
  3. Click ADD REPORT.
  4. Enter a report name.
  5. Select a Comp Plan.
  6. Select a Primary Field.
  7. Select a Secondary Field.
  8. Enter Start Date.
  9. Enter End Date.  A maximum of 10 years is available.
  10. Click SAVE.

Edit

  1. Go to the Main Menu.
  2. Click Reports – Revenue Projection.
  3. Click the box next to the report to edit.
  4. Click the edit icon  .
  5. Make changes.
  6. Click SAVE.

Duplicate

  1. Go to the Main Menu.
  2. Click Reports – Revenue Projection.
  3. Click the box next to the report to duplicate.  Only one report at a time can be duplicated.
  4. Click the duplicate icon .
  5. Make changes.
  6. Click SAVE.

Delete

  1. Go to the Main Menu.
  2. Click Reports – Revenue Projection.
  3. Click the box next to the reports to delete.
  4. Click the delete icon .
  5. Click CONTINUE.

Export

  1. Go to the Main Menu.
  2. Click Reports – Revenue Projection.
  3. Click the report name.
  4. Click the export icon .

    • Related Articles

    • 5-Year Revenue

      A 5-Year Revenue projection is available for each policy that has a comp plan linked to it. Revenue is projected for the the next 5 years using the current date. Calculations are displayed annually and by policy mode. 5-Year Revenue Projection Go to ...

    • Revenue Types

      Revenue Types are names given to other types of compensation on a policy. An example is an override or bonus. The revenue type name from the commission statement is used to match the commission to a policy. A revenue type is linked to a carrier. Add ...

    • Step 6 - Add Reports

      There are multiple reports to help you calculate, project, analyze and track premium and commission for your policies. Pending Business – displays annualized premium and first year commission on policies in underwriting. Analytics – summary of ...

    • Target Premium Import Template

      The Target Premium template is specifically for universal life and whole life policies. These policies pay a base commission rate on the “target premium” and a smaller rate on the “excess premium”. The Base and Excess rate can vary from year to year. ...

    • Pct of Premium Import Template

      The Percentage of Premium template is for policies that pay commissions based on a percentage of the paid premium. Typical products for this template are term life, disability, LTC, and voluntary benefits. Click the attachment at the bottom of the ...