Accounting Procedures Handbook

PENSION/BENEFITS 17.3 TRUST AND AGENCY FUNDS employees grid of Excel spreadsheet; b. Determine number of retirees with coverage from retirees grid ofExcel spreadsheet; c. Determine former employees with coverage under COBRA (#2) from Human Resources. d. Calculation represents total participants and is entered on Scheduleline 7d. 5. Retrieve Excel file ...\Projection/CF budget proj {MMYY} to provide the cost of the plan based on last health care census or 1 above. a. Go to Summary for total cost of plan. b. Page down to "Grand Total of Payments to BCBS, employees column. This amount is listed on Line 6 of schedule F. c. Invoke macro Ctrl T to print total cost schedule. 6. Update Excel file ...\BENEFITS\Frm5500. for employees, eligible and participants. Print range for file. 7. Obtain Comptroller’s signature. 8. Submit to IRS by 3/31 the year after plan year ends on 8/31. Per instructions, the last day of the seventh month after the plan year ends. H. Flexible Spending Account Reconciliation The purpose of this activity is to reconcile the FSA deductions to the list of employee participants submitted to the Service provider. 1. Payroll or Human Resources will notify Benefit Analyst of change in employee’s FSA participation due to termination, leave of absence, etc. 2. Retrieve FSA summary spreadsheet for participants in the Medical and Dependant Care plans for current year. 3. Obtain payroll deduction register from payroll. 4. Compare totals by plan from deduction register to spreadsheet to reconcile differences. Copy employee’s data and withholding amount as negative if ceasing or positive if correction or 02/01/XX mid-year new hires enrolled. I. Health Insurance – Prescription Analysis The purpose of this activity is to document trends in the prescription plan. Using the Care first Quarterly Account Information Report: 1. Retrieve Excel file ... Health Ins/Prescriptions.xls 2. Enter enrollment data from performance Comparison 3. Enter average prescription contracts & average members from Claims Costs Summary by Product. 4. Enter billed, net & paid charges from Claims Cost Summary 5. Enter number of fills from Drug Utilization to proof average cost per fill 6. Enter percentage of generic fills. Brand fill is calculated. 7. Enter percentage of amount paid for generic fills. Brand is calculated. 8. Submit report to Comptroller and Employee Benefit Suggestion Committee for review.