Automated plan balance adjustments

Clearing plan balances used to mean calculating and entering an adjustment for every employee by hand. The Mass Adjustment Template in the Benefits Reconciliation Module now does that math for you.

How to use it

1. Open the Mass Adjustment Template. On the invoice list, click Mass Actions in the bottom toolbar, hover over Mass Adjustment Template, and choose Generate Report.

2. Select the invoices you want to clear. A checkbox column appears in the invoice table. Tick the invoices whose balances you want to adjust, then click Generate.

3. Choose how the adjustments should be calculated. In the Generate Mass Adjustment Template Report window, set the Reason to Beginning Balance, then pick a Reconciliation Type. This is the part that's new, and it decides how the adjustment column in your file gets filled:

Default

the file downloads with an empty adjustment column. You enter each beginning plan balance amount yourself, and it's applied to that person's plan balance. This is the original behavior.

Variance 

the platform automatically fills the adjustment column to clear the variance for the selected month. No manual calculation needed.

Plan Balance

you set a Plan Balance Start Date and End Date, and the platform calculates the adjustments needed to zero the plan balance across that whole period.

Click Generate to download the report.

4. Review the report. Open the downloaded file. For Variance and Plan Balance, the adjustment amounts are already filled in, so you just check them. For Default, enter the amounts yourself. 

5. Upload the report back in. Return to the invoice list, click Mass Actions, hover over Mass Adjustment Template, and choose Upload Report. Select your file, and the plan balances update in full.

This is especially useful during open enrollment, when carrier rates change late and variances pile up over several months.