This text was produced by optical character
recognition (OCR) of a scanned document and may contain errors. The linked
document above is the authoritative version.
Machine-extracted text of a publicly
posted document, provided for reference and search. The original document at
the link above is authoritative.
Board of Education and Town
Monthly Health Insurance Reserve Report
COLCHESTER
PUBLIC SCHOOLS
io
Cash Flow Analysis - August 2023
BOE Town Balance
Balance 07/31/23 3,367,117.03 (448,898.83) 2,918,218.20
May 23 & June 23 182,700.00
August Sewer & Water 12,002.58
August Employee Contributions** 51,635.32 16,318.35
August interest 7,514.77 0.00
Employer HSA contributions (117,062.50) 0.00
Third Party Admininstrator Fees (3,745.00) (820.50)
Administrative Costs (134,011.37) (27,367.09)
Stop loss claims reimbursement 0.00 0.00
August claims (thru 08/31/23) (495,106.16) (162,797.76)
Balance 8/31/23 2,676,342.09 (428,863.25) 2,247,478.84
* The employer portion is determined at the start of year and divided by 12 so each month
the contribution will be the same.
** Employees portion of the health insurance premium collected for the month