Reconcile the health insurance in spreadsheet
At every beginning of month, we will receive the bill from regence for next bill coverage period. We normally do the insurance reconciliation at beginning of each month.
2. add up the two pay period health deductions from ADP for each employee. The pay period is every 1st and 15th
3. Open the CypressNas-Payroll (folder) -Insurance-insurance tracker
4. check the bill we received from Regence every month, and put each person’s medical and dental charge under their name tab.
5. Accounting to the handbook on May 2022, Crittenden Partners pay $360 for employee only,$590 for employee+ spouse +1-2 Children and $800 for family. Mostly, in insurance tracking sheet, the potion paid by company each month is the same.
6 add the two-pay period (1st and 15th) portion of employee’s deductions in insurance tracker. The deductions could be found at ADP. If there is no adding new family member, the deduction is the same. 7. There is the formula under the balance tab, and all the amounts should be zero.
Note: If someone leave, their health insurance should be ended by the end of that month. Their health benefits from ADP will also be zero in 1st , so we are expected the regence to give the credit back to us.