The Affordable Care Act - Lowest Cost Monthly Premium report is a variation of the Affordable Care Act - Employee Offered Coverage template, and it uses the Affordable Care Act - Employee Offered Coverage topic. This variation lists employees that were offered benefit coverage, as well as the lowest cost monthly premium offered during a given date range. Benefits administrators can use this report template to review how the lowest cost monthly premium field will be filled in 1095-C forms.
Fields
| Field Name | Group by | Sort Order | Totals |
|---|---|---|---|
| Name Number | A to Z | ||
| Offered Cov. Start | Oldest to Newest | ||
| Lowest Monthly Prem. | Column Total: Minimum |
Custom Fields
Lowest Monthly Prem.
The Lowest Monthly Prem. custom field displays the lowest cost monthly premium. It uses the following expression:
Round(BenEmployeeOffering.AnnualEmployeeCost/12,3)
Filters
The template includes the following filters: