Use the Retro Group Plan Year Summary report to view the activity for an entire plan year for a retro group; use it as basic input for calculating premiums, rebates, and billing based on rebates.
The results include details for each claim for all employers in a retro group, including claim info, dates, budget numbers adjusted for % Liability, Total Incurred, and Excess Reserve. The summary line at the top gives grand totals for the entire retro group:
Parameters:
Employer Program (required) selects the retro or TPA program to be included in the report. The default is the first retro group found so if your firm manages only one retro group, no selection is needed.
Plan Year End Date (required) determines which set of four plan years will be included in the report. To see the most current four years of experience, specify the end date for your current plan year. The default value is the next June 30, but you may need to change it if your plan year start is other than the most common July 1 start date.
Take Loss Totals from … parameter (required) allows you to select alternate sources for the loss totals, either those shown in the most recent retro report, or those calculated using current costs and the selected Loss Factor Set. The default is set to the Most recent L&I retro report.
Loss Factor Set (optional) lets you select a particular loss factor set to use in calculating projected losses. The custom loss factor sets can be created, allowing you to do custom loss modeling.
Show deleted Loss Factor Sets checkbox determines whether deleted Loss Factor Sets will appear in the Loss Factor Set parameter drop-down. The default is to not include them.
Include Extended Coverage Claims checkbox determines whether claims falling outside of normal retro coverage, but inside customer coverage, will be included in the report. The default is to not include them.
Notes:
The Total Incurred Loss (a.k.a. Case Incurred Loss in L&I retro reports) is the sum of the greater of actual costs or reserves for each of Medical and Indemnity portions. Reserves are set to $0 if the claim is closed.
Discounted, Developed, Capped Loss applies LDFs and any Claim Cap to the Case Incurred Loss. The L&I report version also applies any applicable cap. If LDFs are not assigned for the claim, the Discounted, Developed, Capped Loss cell is grey.
Final Incurred Loss applies ELRFs and PAF to the Discounted/Developed Loss. If they are not assigned for the claim, the Final Incurred Loss cell is grey.
All amounts are multiplied by % Liable. Percent liability for all third party claims defaults to the value specified on the Admin > Firm tab but it can be adjusted for individual claims in the Claim Info > Claim screen. Occupational disease claims will use the % liability shown in CAC. All other claims are 100% liability.
L&I's average claim costs, if available, will be substituted for Medical Reserve or Indemnity Reserve if greater than either the current cost or the reserve.
Claims outside of retro membership coverage (may show when Include Extended Coverage Claims is selected) have Employer Name and DOI/DOLIE highlighted in blue-grey.