COLCHESTER PUBLIC SCHOOLS
YEAR TO DATE BUDGET REPORT
FOR THE PERIOD ENDED JUNE 30, 2020
UNEXPENDED/
TOTAL BUDGET REVISED YTD UNENCUMBERED PERCENT
OBJECT ACCOUNT DESCRIPTION BUDGET TRANSFERS BUDGET EXPENDED ENCUMBRANCES BALANCE NOTES USED
40111 CERTIFIED PERSONNEL SALARIES 19,092,672 0 19,092,672 19,373,019.97 520.64 (280,868.61) 2 101.5
40111 CERTIFIED DAILY SUBSTITUTES 215,000 0 215,000 111,887.29 0.00 103,112.71 52.0
40111 STIPENDS 410,346 0 410,346 336,438.74 0.00 73,907.26 82.0
40112 CLASSIFIED PERSONNEL SALARIES 5,717,069 (42,291) 5,674,778 5,527,466.54 15,987.40 131,324.06 97.7
40112 CLASSIFIED DAILY SUBSTITUTES 75,000 0 75,000 25,371.06 0.00 49,628.94 33.8
40113 ADDITIONAL STAFF HOURS 30,450 (2,696) 27,754 22,728.05 0.00 5,025.95 81.9
40130 CLASSIFIED OVERTIME 34,000 0 34,000 26,501.20 0.00 7,498.80 77.9
41210 EMPLOYEE RELATED INSURANCE 5,297,896 (47) 5,297,849 5,288,762.25 0.00 9,086.75 99.8
41220 SOCIAL SECURITY 408,457 (2,899) 405,558 367,538.15 0.00 38,019.85 1 90.6
41221 MEDICARE 376,886 (678) 376,208 352,929.13 0.00 23,278.87 1 93.8
41230 PENSION 242,272 (1,692) 240,580 219,357.19 0.00 21,222.81 1 91.2
41250 UNEMPLOYMENT 26,350 10,573 36,923 12,403.00 0.00 24,520.00 1 33.6
41260 WORKERS' COMPENSATION INSURANCE 303,718 (56,580) 247,138 248,319.61 0.00 (1,181.61) 2 100.5
41290 OTHER EMPLOYEE BENEFITS 287,428 (4,474) 282,954 282,276.44 0.00 677.56 99.8
42323 PROTECTIVE CLOTHING & SAFETY EQUIPMENT 0 0 0 0.00 0.00 0.00 0.0
42535 POSTAGE 17,700 (2,500) 15,200 12,940.40 0.00 2,259.60 85.1
42611 INSTRUCTIONAL SUPPLIES 236,209 (28,008) 208,201 185,566.16 29,692.96 (7,058.12) 2 103.4
42613 MAINTENANCE SUPPLIES 63,800 0 63,800 48,286.90 17,907.72 (2,394.62) 2 103.8
42614 GROUNDS MAINTENANCE SUPPLIES 24,000 0 24,000 29,491.74 0.00 (5,491.74) 2 122.9
42641 TEXTBOOKS 69,035 (3,352) 65,683 60,449.82 105.00 5,128.18 92.2
42642 LIBRARY BOOKS 14,627 0 14,627 14,239.16 246.13 141.71 99.0
42643 PERIODICALS 2,630 (73) 2,557 2,663.59 0.00 (106.59) 2 104.2
42690 OTHER SUPPLIES/MATERIALS 269,706 191,887 461,593 206,061.50 229,365.60 26,165.90 94.3
43320 PROFESSIONAL DEVELOPMENT 51,215 (4,300) 46,915 21,409.40 670.58 24,835.02 47.1
43322 INSTRUCTIONAL PROGRAM IMPROVEMENTS 27,430 0 27,430 13,385.36 925.00 13,119.64 52.2
43323 PUPIL SERVICES 86,082 0 86,082 94,871.98 0.00 (8,789.98) 110.2
43326 PUPIL SERVICES PUBLIC ADD'L SERVICES 0 0 0 100,394.12 19,299.52 (119,693.64) 3,4 0.0
43327 PUPIL SERVICES PRIVATE ADD'L SERVICES 0 0 0 34,645.70 0.00 (34,645.70) 3,4 0.0
43510 PUPIL TRANSPORTATION - REGULAR EDUC 1,261,581 (49,710) 1,211,871 1,211,323.61 0.00 547.39 100.0
43510 PUPIL TRANSPORTATION - SPECIAL EDUC 753,967 0 753,967 939,586.54 0.00 (185,619.54) 4 124.6
43511 TECH TRANSPORTATION 207,331 (21,720) 185,611 184,682.15 0.00 928.85 99.5
43580 TRAVEL 38,501 (2,000) 36,501 49,485.62 500.00 (13,484.62) 2 136.9
43810 DUES AND FEES 44,290 (816) 43,474 34,002.61 0.00 9,471.39 78.2
44203 LEGAL 100,000 0 100,000 130,128.50 0.00 (30,128.50) 2 130.1
44330 OTHER PROFESSIONAL TECHNICAL SERVICES 172,399 (1,372) 171,027 152,462.93 840.00 17,724.07 89.6
44340 FINANCIAL MANAGEMENT SERVICES 51,657 0 51,657 51,657.00 0.00 0.00 100.0
44520 PROPERTY INSURANCE 77,710 28,909 106,619 105,573.08 0.00 1,045.92 99.0
44521 LIABILITY INSURANCE GENERAL 55,501 4,332 59,833 59,832.72 0.00 0.28 100.0
44522 LIABILITY INSURANCE TRANSPORTATION 1,058 (225) 833 843.62 0.00 (10.62) 2 101.3
44540 ADVERTISING 580 0 580 580.00 0.00 0.00 100.0
44550 PRINTING 16,185 (159) 16,026 8,898.08 5,717.32 1,410.60 91.2
44561 TUITION - VO-AG 95,522 10,000 85,522 85,477.00 0.00 45.00 99.9
44561 TUITION - PUBLIC 1,324,506 0 1,324,506 1,407,792.09 26,144.47 (109,430.56) 4 108.3
44562 TUITION - PRIVATE 817,287 0 817,287 677,446.96 12,000.00 127,840.04 4 84.4
44563 TUITION - SAP OTHER 0 0 0 0.00 0.00 0.00 4 0.0
44566 TUITION - MAGNET SCHOOLS 337,694 (52,000) 285,694 285,609.32 0.00 84.68 100.0
COLCHESTER PUBLIC SCHOOLS
YEAR TO DATE BUDGET REPORT
FOR THE PERIOD ENDED JUNE 30, 2020
UNEXPENDED/
TOTAL BUDGET REVISED YTD UNENCUMBERED PERCENT
OBJECT ACCOUNT DESCRIPTION BUDGET TRANSFERS BUDGET EXPENDED ENCUMBRANCES BALANCE NOTES USED
44590 OTHER PURCHASED SERVICES 37,513 0 37,513 34,246.88 0.00 3,266.12 91.3
44610 CURRICULUM IMPLEMENTATION 130,000 0 130,000 115,134.57 8,798.76 6,066.67 95.3
44815 SOFTWARE LICENSING & SUPPORT 212,024 1,960 213,984 209,784.02 7,050.95 (2,850.97) 2 101.3
45411 WATER/SEWER 60,850 0 60,850 41,448.42 0.00 19,401.58 68.1
45530 TELEPHONES 40,770 0 40,770 40,700.28 0.00 69.72 99.8
45620 HEAT ENERGY SUPPLIES 342,225 (36,000) 306,225 254,643.26 0.00 51,581.74 83.2
45622 ELECTRICITY 857,115 (89,500) 767,615 746,297.11 0.00 21,317.89 97.2
45623 PROPANE 500 0 500 293.29 0.00 206.71 58.7
45626 GASOLINE - MAINTENANCE VEHICLES 750 0 750 551.13 0.00 198.87 73.5
45627 TRANSPORTATION SUPPLIES 117,000 (19,300) 97,700 89,522.58 0.00 8,177.42 91.6
46410 RECYCLING 30,621 0 30,621 26,141.67 2,770.72 1,708.61 94.4
46420 CLEANING/REPAIRING MAINTENANCE 105,523 (3,075) 102,448 81,110.52 14,937.50 6,399.98 93.8
46430 EQUIPMENT CONTRACTS - OFFICE 115,011 (7,235) 107,776 95,385.93 0.00 12,390.07 88.5
46430 EQUIPMENT CONTRACTS - FACILITIES 125,187 0 125,187 91,939.91 11,079.51 22,167.58 82.3
46431 VEHICLE MAINTENANCE 750 0 750 130.50 0.00 619.50 17.4
48730 INSTRUCTIONAL EQUIPMENT 0 0 0 0.00 0.00 0.00 0.0
48731 NON-INSTRUCTIONAL EQUIPMENT 14,700 0 14,700 14,752.16 0.00 (52.16) 2 100.4
48733 FURNITURE & FIXTURES 3,500 (1,000) 2,500 0.00 0.00 2,500.00 0.0
48734 OTHER CAPITAL OUTLAY 87,750 (20,263) 67,487 22,818.16 3,047.25 41,621.59 38.3
50205 TRANSFER TO BOE CAPITAL RESERVE 72,250 289,872 362,122 362,122.00 0.00 0.00 100.0
50250 TRANSFER TO CAFETERIA FUND 0 125,500 125,500 0.00 0.00 125,500.00 0.0
50260 TRANSFER TO EDUCATION GRANTS FUND 35,000 77,226 112,226 112,226.00 0.00 0.00 100.0
50700 TRANSFER TO DEBT SERVICE FUND 212,336 0 212,336 212,336.00 0.00 0.00 100.0
50900 CONTINGENCY (100,000) 100,804 804 0.00 0.00 804.00 0.0
TOTAL 41,237,122 387,098 41,604,220 40,956,370.67 407,607.03 240,242.30 99.4
Purchase orders for goods and services are issued throughout the school year.
(1) Employee benefit amounts reflect only actual expended amounts to date.
(2) Pending budget Transfer
(3) Reclassification of educational services associated with out of district special education placements - need to report separately from tuition costs to maximize
Medicaid reimbursements.
(4) Special Education expenditures subject to reimbursement form Excess Cost grant.