April 2024 Financial Reports
document center
| Pages | 25 |
|---|---|
| File Size | 0.9 MB |
| Folder | Departments/Finance/Monthly Financial Reports |
| OCR Status | Searchable (OCR processed) |
| Source URL | Original |
Document Preview
Full Text (OCR Extracted)
Contributed Gifts Fund April 30, 2024 R&P R&P R&P R&P FINANCE POLICE POLICE R&P MEMORIAL FRANCES X. CIVIC DEIDRICK HELMET R&P TREES & SWEENEY R&P R&P TRIANGLE R&P FIELD PRESS R&P DEPT. DEPT. RODEO GENERAL BENCHES MEMORIAL DOG PARK PLAYGROUND MEMORIAL TOY BOX BOX CEMETERY AUDITORIUM AUSTISM VEHICLE FISCAL YEAR 2024 DONATIONS DONATIONS DONATIONS DONATIONS DONATIONS DONATIONS DONATIONS DONATIONS DONATIONS DONATIONS A/V UPGRADE TRAINING CHALLENGE REVENUES REC & PARKS GENERAL DONATIONS $100.00 REC & PARKS MEMORIAL TREES & BENCHES DONATIONS $500.00 REC & PARKS DOG PARK DONATIONS $35.00 REC & PARKS TOY BOX DONATIONS $220.00 R&P CEMETERY DONATIONS $100.00 K9 DONATIONS POLICE DEPT. GENERAL DONATIONS TOTAL REVENUES $0.00 $100.00 $500.00 $0.00 $35.00 $0.00 $0.00 $220.00 $0.00 $100.00 $0.00 $0.00 $0.00 EXPENDITURES 07/14/23 EAST COAST K-9 TICO 08/04/23 JP MORGAN CHASE 08/04/23 D.DRISCOLL REIMBURSEMENT 08/18/23 PETTY CASH 08/18/23 MEDIA HERE& NOW LLC 08/04/23 JP MORGAN CHASE 09/04/23 JP MORGAN CHASE 09/04/23 JP MORGAN CHASE 10/04/23 JP MORGAN CHASE 10/04/23 JP MORGAN CHASE 11/22/23 PO 240394 POSITIVE PROMOT 11/04/23 JP MORGAN CHASE 12/04/23 JP MORGAN CHASE 01/05/24 REIMB E. FREDRICS 01/04/24 JP MORGAN CHASE 01/18/24 P.O. 240505 SMOKEY O'GRADYS WELLNESS DINNER 02/04/24 JP MORGAN CHASE 03/04/24 JP MORGAN CHASE 04/04/24 JP MORGAN CHASE 04/26/24 LJ BADGE & EMBLEM 04/02/24 JAYPRO SPORTS PO 240597 $4,290.00 04/24/24 M.E. O'BRIEN PO 240611 $2,825.00 TOTAL EXPENDITURES $0.00 $0.00 $2,825.00 $0.00 $0.00 $0.00 $0.00 $0.00 $4,290.00 $0.00 $0.00 $0.00 $0.00 NET CURRENT YEAR ACTIVITY $0.00 $100.00 ($2,325.00) $0.00 $35.00 $0.00 $0.00 $220.00 ($4,290.00) $100.00 $0.00 $0.00 $0.00 PRIOR YEAR BALANCE $594.72 $29.60 $1,271.39 $65.00 $725.97 $60,486.32 $1,140.00 $0.00 $12,600.00 $0.00 $151.00 $1,700.00 $780.11 CURRENT YEAR BALANCE $594.72 $129.60 ($1,053.61) $65.00 $760.97 $60,486.32 $1,140.00 $220.00 $8,310.00 $100.00 $151.00 $1,700.00 $780.11 Page 1 of 2 Contributed Gifts Fund April 30, 2024 FISCAL YEAR 2024 REVENUES REC & PARKS GENERAL DONATIONS REC & PARKS MEMORIAL TREES & BENCHES DONATIONS REC & PARKS DOG PARK DONATIONS REC & PARKS TOY BOX DONATIONS R&P CEMETERY DONATIONS K9 DONATIONS POLICE DEPT. GENERAL DONATIONS TOTAL REVENUES EXPENDITURES 07/14/23 EAST COAST K-9 TICO 08/04/23 JP MORGAN CHASE 08/04/23 D.DRISCOLL REIMBURSEMENT 08/18/23 PETTY CASH 08/18/23 MEDIA HERE& NOW LLC 08/04/23 JP MORGAN CHASE 09/04/23 JP MORGAN CHASE 09/04/23 JP MORGAN CHASE 10/04/23 JP MORGAN CHASE 10/04/23 JP MORGAN CHASE 11/22/23 PO 240394 POSITIVE PROMOT 11/04/23 JP MORGAN CHASE 12/04/23 JP MORGAN CHASE 01/05/24 REIMB E. FREDRICS 01/04/24 JP MORGAN CHASE 01/18/24 P.O. 240505 SMOKEY O'GRADYS WELLNESS DINNER 02/04/24 JP MORGAN CHASE 03/04/24 JP MORGAN CHASE 04/04/24 JP MORGAN CHASE 04/26/24 LJ BADGE & EMBLEM 04/02/24 JAYPRO SPORTS PO 240597 04/24/24 M.E. O'BRIEN PO 240611 TOTAL EXPENDITURES NET CURRENT YEAR ACTIVITY PRIOR YEAR BALANCE CURRENT YEAR BALANCE POLICE POLICE POLICE DEPT. DEPT. PUBLIC K-9 GENERAL SAFETY PROGRAM DONATIONS DOCK TOTAL $2,000.00 $5,995.00 $2,000.00 $5,995.00 $0.00 $8,950.00 $9,950.00 $0.00 $1,905.49 $46.47 $50.00 $500.00 $230.24 $709.47 $1,701.97 ($244.38) $2,958.90 $503.27 $326.15 $2,246.98 $50.00 $326.48 $1,930.31 $395.00 $21.99 $47.57 $532.00 $12,342.57 $11,845.34 $0.00 $31,302.91 ($10,342.57) ($5,850.34) $0.00 ($22,352.91) $14,897.23 $11,234.78 $7.04 $105,683.16 $4,554.66 $5,384.44 $7.04 $83,330.25 Page 2 of 2 GENERAL FUND STATEMENT OF EXPENDITURES COMPARED TO BUDGET FOR FISCAL YEAR 2023-2024, THROUGH APRIL 30, 2024 WITH COMPARATIVE ACTUAL AMOUNTS FOR FISCAL YEAR 2022-2023, THROUGH APRIL 30, 2023 FISCAL YEAR 2024 FISCAL YEAR 2024 VARIANCE FISCAL YEAR FISCAL YEAR 2024 FISCAL YEAR 2024 PERCENT FAVORABLE 2022-2023 APPROPRIATED ACTUAL EXPENDED (UNFAVORABLE) ACTUAL GENERAL GOVERNMENT Board of Selectmen $207,605 $158,203 76.20% 49,402 $169,091 Registrar of Voters $79,488 $78,711 99.02% 777 $81,547 Board of Finance $70,159 $80,512 114.76% (10,353) $70,730 Assessor $292,148 $239,713 82.05% 52,435 $216,302 Board of Assessment Appeals $1,602 $840 52.42% 762 $1,882 Tax Collector $217,865 $187,266 85.96% 30,599 $179,547 Finance Department $750,608 $634,274 84.50% 116,334 $591,440 Legal Department $370,000 $349,559 94.48% 20,441 $257,281 Town Clerk $252,225 $210,438 83.43% 41,787 $247,270 Planning and Zoning $661,210 $519,065 78.50% 142,145 $500,101 Building Maintenance $919,233 $1,038,166 112.94% (118,933) $750,031 Insurance $5,105,857 $4,779,478 93.61% 326,379 $4,417,986 Economic Development Commission $27,447 $26,634 97.04% 813 $9,696 Conservation Commission $18,250 $13,456 73.73% 4,794 $1,982 Zoning Board of Appeals $4,310 3,099 71.90% 1,211 3,263 Retirement Commission $7,049,737 $5,465,682 77.53% 1,584,055 $5,315,715 R.T.M. $18,903 $15,470 81.84% 3,433 $16,599 Building Department $297,609 $227,632 76.49% 69,977 $193,484 Youth Service Bureau $239,827 $227,616 94.91% 12,211 $182,927 Social Service Grants/Miscellaneous $88,182 $87,181 98.87% 1,001 $86,187 Contingency Fund $42,341 0 0.00% 42,341 0 Emergency Management $1,094,563 $782,190 71.46% 312,373 $784,602 Fire Services $3,531,618 $3,005,817 85.11% 525,801 $3,041,244 Police Department $6,828,296 $5,320,781 77.92% 1,507,515 $5,145,724 Public Works Department $4,994,798 $4,013,600 80.36% 981,198 $4,052,677 Conservation of Health $148,407 148,407 100.00% (0) 148,126 Public Health Nursing $25,911 18,000 69.47% 7,911 24,000 Senior Citizens Commission $484,631 401,362 82.82% 83,269 356,896 Waterford Public Library $1,023,830 $869,842 84.96% 153,988 $802,630 Page 1 of 2 GENERAL FUND STATEMENT OF EXPENDITURES COMPARED TO BUDGET FOR FISCAL YEAR 2023-2024, THROUGH APRIL 30, 2024 WITH COMPARATIVE ACTUAL AMOUNTS FOR FISCAL YEAR 2022-2023, THROUGH APRIL 30, 2023 FISCAL YEAR 2024 FISCAL YEAR 2024 VARIANCE FISCAL YEAR FISCAL YEAR 2024 FISCAL YEAR 2024 PERCENT FAVORABLE 2022-2023 APPROPRIATED ACTUAL EXPENDED (UNFAVORABLE) ACTUAL Recreation and Parks $1,399,310 $1,164,111 83.19% 235,199 $1,294,616 Flood and Erosion Control Bd. $2,138 407 19.01% 1,731 849 Ethics Commission $900 447 49.71% 453 0 Human Resources $278,631 $242,282 86.95% 36,349 $222,536 Information Technology $1,165,181 $1,052,945 90.37% 112,236 $933,529 Transfer to Waterford Special Activity Fund $4,750 $4,750 100.00% 0 $4,750 Transfer to Waterford Shellfish Fund $4,134 $4,134 100.00% 0 $1,721 Transfer to Capital Improvement Fund $2,787,620 $2,787,620 100.00% 0 $3,534,901 Transfer to Capital & Non-Recurring Fund $3,255,800 $3,255,800 100.00% 0 $3,803,560 Transfer to Dog Fund $100,000 $100,000 100.00% 0 $60,000 Debt Service $8,148,250 $8,148,250 100.00% 0 $7,197,459 Total General Government $51,993,374 $45,663,742 87.83% $6,329,632 $44,702,881 Board of Education $54,446,027 $41,934,658 77.02% 12,511,369 $39,299,789 Total General Fund $106,439,401 $87,598,400 82.30% $18,841,001 $84,002,670 Page 2 of 2 TOWN OF WATERFORD STATEMENT OF REVENUES COMPARED TO ANTICIPATED FOR FISCAL YEAR 2023-2024, THROUGH APRIL 30, 2024 WITH COMPARATIVE ACTUAL AMOUNTS FOR FISCAL YEAR 2022-2023, THROUGH APRIL 30, 2023 FAVORABLE FISCAL (UNFAVORABLE) FISCAL FISCAL YEAR FISCAL FISCAL YEAR YEAR 2023-2024 YEAR YEAR 2023-2024 2023-2024 PERCENT 2023-2024 2022-2023 BUDGET ACTUAL RECEIVED VARIANCE ACTUAL STATE OF CONNECTICUT EDUCATION EQUALIZED COST SHARING $326,444 $322,130 98.68% (4,314) $377,227 HEALTH & WELFARE $6,359 $6,810 107.09% 451 $5,982 SUB TOTAL 332,803 328,940 98.84% (3,863) 383,209 GENERAL GOVERNMENT PILOT-DISABLED 1,200 1,486 123.80% 286 $1,946 TIERED PILOT 315,978 347,575 110.00% 31,597 $316,181 TAX RELIEF-VETERANS 5,000 3,671 73.41% (1,329) $5,870 COURT FINES 0 7,435 #DIV/0! 7,435 $6,270 CIVIL PREPAREDNESS 20,000 38,988 194.94% 18,988 $23,403 TELECOMMUNICATIONS PROPERTY TAX 58,071 89,710 154.48% 31,639 $58,071 TOWN AID ROADS-IMPROVED 321,120 321,360 100.07% 240 $321,120 LOCAL CAPITAL IMPROVEMENT (LOCIP) 116,994 0 0.00% (116,994) $0 SDE STATE GRANT 14,000 10,577 75.55% (3,423) $14,102 ENHANCEMENT 911 22,981 22,583 98.27% (398) $22,418 MUNICIPAL REVENUE SHARE GRANT 379,498 493,810 130.12% 114,312 $373,384 GRANTS FOR MUNICIPAL PROJECTS 68,510 0 0.00% (68,510) $0 TOTAL GENERAL GOVERNMENT 1,323,352 1,337,195 101.05% 13,843 1,142,765 TOTAL STATE OF CONNECTICUT 1,656,155 1,666,135 100.60% 9,980 1,525,974 OTHER SOURCES EDUCATION TUITION 60,000 86,287 143.81% 26,287 105,931 RENT & MISCELLANEOUS 1,500 3,501 233.40% 2,001 3,451 SUB TOTAL 61,500 89,788 146.00% 28,288 109,382 TOWN OF WATERFORD STATEMENT OF REVENUES COMPARED TO ANTICIPATED FOR FISCAL YEAR 2023-2024, THROUGH APRIL 30, 2024 WITH COMPARATIVE ACTUAL AMOUNTS FOR FISCAL YEAR 2022-2023, THROUGH APRIL 30, 2023 FAVORABLE FISCAL (UNFAVORABLE) FISCAL FISCAL YEAR FISCAL FISCAL YEAR YEAR 2023-2024 YEAR YEAR 2023-2024 2023-2024 PERCENT 2023-2024 2022-2023 BUDGET ACTUAL RECEIVED VARIANCE ACTUAL GENERAL GOVERNMENT INTEREST & LIENS 291,306 256,367 88.01% (34,939) 335,219 INTEREST ON INVESTMENTS 2,500,000 2,737,291 109.49% 237,291 1,656,693 RECREATION & PARKS 165,000 200,914 121.77% 35,914 186,492 FIRE SERVICES INSPECTIONS & PLAN FEES 0 3,950 #DIV/0! 3,950 0 BUILDING INSPECTOR 400,000 466,723 116.68% 66,723 536,480 LICENSE, FEE, PERMIT, FINE 135,309 14,018 10.36% (121,292) 17,200 LIBRARY 0 1,285 #DIV/0! 1,285 362 WATER MAIN ASSESSMENTS 0 0 #DIV/0! 0 16,501 SALE OF VEHICLES 0 #DIV/0! 0 683 SALE OF EQUIPMENT 1,000 12,635 1263.50% 11,635 11,978 SCRRRA REBATE 0 1,532 #DIV/0! 1,532 0 NL RADIO COMM. NETWORK USE FEE 72,000 0 0.00% (72,000) 0 BULKY WASTE FEES 110,000 92,995 84.54% (17,005) 87,074 MISCELLANEOUS 27,582 149,112 540.61% 121,530 87,474 CONVEYANCE TAX 200,000 241,828 120.91% 41,828 347,336 EMS-REG COMM CTR FEES 6,000 4,500 75.00% (1,500) 3,000 PLANNING& ZONING, ZBA, CONSRV COMM 54,183 31,938 58.94% (22,246) 58,754 TOWN CLERK FEES 175,000 118,312 67.61% (56,688) 124,003 LIENS -COLLECTED BY UTILITY COMMISSION 0 2,860 #DIV/0! 2,860 2,780 TIPPING FEES 275,000 117,884 42.87% (157,116) 184,428 RECYCLING 45,000 27,110 60.24% (17,890) 48,019 COST SHARING PRR 0 0 #DIV/0! 0 187,367 TRANSFERS FROM OTHER FUNDS 0.00 897,324 #DIV/0! 897,324 161,025 TRANSFERS IN-PY ENCUMBRANCES 0 29,331 #DIV/0! 29,331 4 EUGENE O'NEILL GATE/LEASE REVENUE 10,000 22,474 224.74% 12,474 0 YSB BOE CLERICAL STIPEND 5,000 5,000 100.00% 0 5,000 RENTAL OF BUILDINGS 50,000 51,856 103.71% 1,856 775,230 SENIOR SERVICES 10,196 20,874 204.73% 10,678 13,412 VERSA KART/BLUE BOXES 10,000 6,410 64.10% (3,590) 6,410 PUBLIC WORKS BOE CUSTODIAL SUBSIDY 73,218 73,218 100.00% 0 0 SUB TOTAL 4,615,794 5,587,741 121.06% 971,947 4,852,924 TOTAL OTHER SOURCES 4,677,294 5,677,529 121.38% 1,000,235 4,962,306 PROPERTY TAXATION CURRENT PROPERTY TAX 95,263,203 95,775,364 100.54% 512,161 96,408,508 PRIOR YEAR TAXES 476,546 338,726 71.08% (137,820) 337,018 TOTAL PROPERTY TAXATION 95,739,749 96,114,090 100.39% 374,341 96,745,526 TOTAL REVENUES 102,073,198 103,457,755 101.36% 1,384,557 103,233,806 TOWN OF WATERFORD CAPITAL PROJECTS FUNDS APRIL 30, 2024 REMAINING BALANCE FUND DESCRIPTION APPROPRIATION EXPENDED BALANCE PCT EXP RETURNED 424 DISTRICT MAGNET SCHOOL/EARLY CHLDHD LRN CT 21,248,892.00 21,248,807.19 84.81 100.00% 432 WATERFORD HIGH SCHOOL BUILDING PROJECT 68,362,787.00 67,786,416.66 576,370.34 99.16% TOTALS 89,611,679.00 89,035,223.85 576,455.15 99.36% 0.00 PRIOR YEAR EXPENDITURES 89,035,223.85 CURRENT YEAR EXPENDITURES 0.00 TOWN OF WATERFORD STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE FLEET MANAGEMENT FUND AS OF APRIL 30, 2024 Revenues: Investment Income 193,157 Vehicle Rentals 42,113 Sale of Vehicles 3,063 Sale of Equipment 7,341 Insurance Settlement 47,845 Total Revenues 293,517 Expenditures: Equipment Replacement 247,177 Vehicle Replacement 1,935,330 Total Expenditures 2,182,507 Excess (Deficiency) of Revenues Over Expenditures (1,888,990) Other Financing Sources (Uses): Transfers from other funds 1,000,000 Total Other Financing Sources (Uses) 1,000,000 Net Change in Fund Balances (888,990) Fund Balances - Beginning 3,509,747 Fund Balances - Ending 2,620,757 TOWN OF WATERFORD CAPITAL IMPROVEMENT FUND APRIL 30, 2024 EXPENDED/ PERCENT TRANSFERS ACCOUNT DEPT/YEAR DESCRIPTION APPROPRIATED ENCUMBERED BALANCE EXPENDED OUT 30124-55738 BOS FY24 FLEET MANAGEMENT PLAN 1,000,000.00 1,000,000.00 0.00 100.0% 1,000,000.00 TO FLEET MANAGEMENT FUND 30716-55793 FINANCE (IT) FY16 FINANCIAL ACCOUNTING SOFTWARE 170,000.00 170,000.00 0.00 100.0% 12,491.82 31117-55803 BLDG MAINT FY17 PARKING LOT -YOUTH SERVICES 300,000.00 21,700.00 278,300.00 7.2% 31118-55803 BLDG MAINT FY18 PARKING LOT -YSB/POLICE 195,320.00 57,000.00 138,320.00 29.2% 31120-55851 BLDG MAINT FY20 ADA IMPROVEMENTS YSB/PD 87,000.00 20,800.00 66,200.00 23.9% 31120-55852 BLDG MAINT FY20 TOWN HALL BATHROOMS 87,500.00 87,500.00 0.00 100.0% 31121-55851 BLDG MAINT FY21 ADA IMPROVEMENTS YSB/PD 80,700.00 15,139.00 65,561.00 18.8% 31122-55819 BLDG MAINT FY22 UST REPLACEMENT 250,000.00 250,000.00 0.00 100.0% 31122-55892 BLDG MAINT FY22 AC UNIT REPLACMENT RADIO SITES 60,500.00 60,500.00 0.00 100.0% 13,460.85 31122-55893 BLDG MAINT FY22 EUGENE O'NEILL ROOF REPLACE 60,767.64 60,767.64 0.00 100.0% 31123-55904 BLDG MAINT FY23 UST REPLACEMENT EUGENE O'NEILL 260,000.00 87,897.82 172,102.18 33.8% 31123-55905 BLDG MAINT FY23 UST REPLACEMENT LIBRARY&PUBLIC SAFETY 420,000.00 411,271.41 8,728.59 97.9% 31123-57857 BLDG MAINT FY23 CIVIC TRIANGLE UPGRADES 1,285,818.00 1,285,814.61 3.39 100.0% 31124-55912 BLDG MAINT FY24 TOWN DOCK REPLACEMENT 40,000.00 0.00 40,000.00 0.0% 31124-55913 BLDG MAINT FY24 JORDAN PARKHOUSE REPAIRS 25,000.00 0.00 25,000.00 0.0% 31124-55915 BLDG MAINT FY24 SEPTIC REPLMT (EUGENE O'NEILL) 43,500.00 39,304.00 4,196.00 90.4% 32224-55908 EMERGENCY MANAGEMENT FY24 APCO INTELLICOM GUIDECARD SYST 40,000.00 40,000.00 0.00 100.0% 32224-55909 EMERGENCY MANAGEMENT FY24 EVENTIDE NEXLOGDX RECORDER 88,701.00 0.00 88,701.00 0.0% 32323-55900 FIRE SERVICES FY23 COHANZIE EMERGENCY GENERATOR 57,000.00 60,000.00 (3,000.00) 105.3% 32323-55907 FIRE SERVICES FY23 PAGERS UPGRADE/REPLACEMNENT 25,000.00 24,862.95 137.05 99.5% 33020-55850 PUBLIC WORKS FY20 CROSS ROAD 2,754,000.00 2,754,000.00 0.00 100.0% 881,507.03 33020-59300 PUBLIC WORKS FY20 FUNDING OFFSET-CROSS ROAD (2,754,000.00) (2,754,000.00) 0.00 100.0% (142,358.40) 33021-55867 PUBLIC WORKS FY21 REMOVE UST COHANZIE FIRE 348,790.00 348,790.00 0.00 100.0% 0.08 33022-55882 PUBLIC WORKS FY22 NORMAN/CONCRETE PANELS 80,100.00 108,584.98 (28,484.98) 135.6% 33022-55883 PUBLIC WORKS FY22 WILLIAM ST CONCRETER SIDEWALK 42,300.00 56,762.00 (14,462.00) 134.2% 33022-55884 PUBLIC WORKS FY22 SUMMER STREET/CONCRETE SW 33,420.00 32,505.00 915.00 97.3% 33022-55885 PUBLIC WORKS FY22 DAVID STREET/CONCRETE SW 43,680.00 60,995.00 (17,315.00) 139.6% 33023-55890 PUBLIC WORKS FY23 ROAD RESURFACING EVERSOURCE AF 315,951.00 (484,165.57) 800,116.57 -153.2% 33023-55901 PUBLIC WORKS FY23 CURB REPLACEMENT SANDY HOLLW 319,300.00 11,059.68 308,240.32 3.5% Page 1 of 2 TOWN OF WATERFORD CAPITAL IMPROVEMENT FUND APRIL 30, 2024 EXPENDED/ PERCENT TRANSFERS ACCOUNT DEPT/YEAR DESCRIPTION APPROPRIATED ENCUMBERED BALANCE EXPENDED OUT 33023-55902 PUBLIC WORKS FY23 RD RESURFACING SEC A, AREA 3 325,915.00 325,915.00 0.00 100.0% 126,532.94 33024-55911 PUBLIC WORKS FY24 BLOOMINGDALE/HUNTS BRK CULVERT 15,000.00 15,000.00 0.00 100.0% 33024-55914 PUBLIC WORKS FY24 ROTARY LIFT REPLACEMENTS 75,000.00 74,972.00 28.00 100.0% 33121-55871 UTILITY COMM FY21 EVERGREEN PUMP STATION 375,000.00 375,000.00 0.00 100.0% 5,690.08 33122-55894 UTILITY COMM FY22 CONTROL PANEL RETRO-FIT (GORMA 30,000.00 0.00 30,000.00 0.0% 33123-55019 UTILITY COMM FY23 CONTRACT #1 SEWER INTERCEPTOR EASEMENT ACCESS 250,000.00 75,200.00 174,800.00 30.1% 33123-55895 UTILITY COMM FY23 ROOF & SIDING REPLACEMENT 50,000.00 5,209.66 44,790.34 10.4% 33123-55906 UTILITY COMM FY23 WUC BILLING SOFTWARE 130,000.00 130,000.00 0.00 100.0% 33720-55854 REC & PARKS FY20 LEARY BASKETBALL COURT REBUILD 91,000.00 0.00 91,000.00 0.0% 33720-55855 REC & PARKS FY20 TOWN HALL BASKETBALL COURT REP 41,000.00 0.00 41,000.00 0.0% 33722-55896 REC & PARKS FY22 EQUIPMENT STORAGE PLAN 21,000.00 16,750.00 4,250.00 79.8% 33723-55838 REC & PARKS FY23 CHILDREN'S PLAYGROUND 40,000.00 0.00 40,000.00 0.0% 34723-55021 INFORMATION TECHNOLOGY FY23 AUDITORIUM MEETING ROOM UPDATES 272,000.00 86,819.78 185,180.22 31.9% 34724-55910 INFORMATION TECHNOLOGY FY24 NEXGEN TRANSITION 309,520.00 302,783.90 6,736.10 97.8% TOTALS 7,785,782.64 5,234,738.86 2,551,043.78 67.2% 1,897,324.40 PRIOR YEAR EXPENDITURES 1,408,500.81 CURRENT YEAR EXPENDITURES 3,826,238.05 Page 2 of 2 TOWN OF WATERFORD CAPITAL AND NON-RECURRING EXPENDITURE FUND FUND BALANCE DESIGNATION AND APPROPRIATION JULY 1,2023 TO JUNE 30,2024 AS OF APRIL 30,2024 BEGINNING FY24 RTM CLOSED AVAILABLE BALANCE XFER IN FISCAL YEAR 2023-2024 ENCUMBERED/ BAL (REVERTS INTEREST TO DATE APPROPRIATIONS DESIGNATED UNDESIGNATED DESIGNATED APPROPRIATED DESIGNATED UNDESIGNATED EXPENDED TO FUND) INC APPROPRIATED DESIGNATEDUNDESIGNATED 20501-57018 PURCHASE 8 GOSHEN ROAD $0.00 $0.00 $0.00 $385,000.00 $385,000.00 ($385,000.00) $378,686.00 $6,314.00 $0.00 $0.00 20501-57639 REVALUATION ($6,547.47) $332,700.00 $0.00 $75,000.00 $6,547.47 $17,255.80 ($17,255.80) $407,700.00 $0.00 20511-57767 NEVINS COTTAGE STRUCTURAL REPAIRS $20,715.00 $100,000.00 $0.00 $20,715.00 $100,000.00 $0.00 20511-57839 TOWN HALL EMERGENCY EGRESS $41,275.00 $0.00 $0.00 $41,275.00 $0.00 $0.00 $41,275.00 20511-57840 PLAN OF CONSERVATION DEVELOPMENT $56,220.07 $0.00 $0.00 $56,220.07 $0.00 $0.00 $0.00 20511-57856 JORDAN VILLAGE SIDEWALKS $87,786.36 $0.00 $0.00 $0.00 $87,786.36 $0.00 $0.00 $87,786.36 20502-48043 JORDAN VILLAGE SIDEWALK GRANT $0.00 $280,000.00 $0.00 $0.00 $280,000.00 $0.00 20511-57866 TOWN HALL FRONT DOOR $18,982.73 $0.00 $0.00 $18,982.73 $0.00 $0.00 $18,982.73 20511-57870 MAGO POINT IMPROVEMENTS $19,125.00 $374,500.00 $0.00 $17,625.00 $1,500.00 $374,500.00 $0.00 20511-57871 PUBLIC SAFETY BLDG HVAC $0.00 $62,045.00 $0.00 $0.00 $62,045.00 $0.00 20511-57872 ROOF & HVAC REPLACEMENT PUBLIC SAFETY BUILDING $193,274.20 $0.00 $0.00 $178,905.00 $14,369.20 $0.00 $0.00 20511-57874 RECONDITION ELEVATORS -TOWN HALL/YOUTH SERVICES BLDG $239,600.00 $0.00 $0.00 $28,550.00 $239,581.15 $28,568.85 $0.00 $0.00 20511-57876 SW SCHOOL UNDERGROUND TANK $122,732.32 $0.00 $0.00 $47,205.18 $75,527.14 $0.00 $0.00 20511-57879 TOWN HALL BATHROOM REFURBISHMENT $293,871.35 $0.00 $0.00 $125,000.00 $401,825.00 $17,046.35 $0.00 $0.00 20511-57885 COMMUNITY CENTER BMS PROJECT $0.00 $0.00 $0.00 $300,000.00 $300,000.00 ($300,000.00) $248,950.00 $51,050.00 $0.00 $0.00 20522-57794 MOBILE & PORTABLE RADIO REPLACEMENT PROGRAM $44,991.50 $500,436.00 $0.00 $496,753.00 ($496,753.00) $541,703.55 $40.95 $3,683.00 $0.00 20522-57887 FARGO WATER TANK ANTENNA $0.00 $0.00 $0.00 $48,998.00 $48,997.26 $0.74 $0.00 $0.00 20523-57777 FIRE SERVICES -SCBA UPGRADE PROGRAM $0.00 $0.00 $0.00 $64,000.00 $64,000.00 ($64,000.00) $63,981.44 $18.56 $0.00 $0.00 20523-57791 JORDAN-TRAFFIC LIGHT UPGRADE $0.00 $25,000.00 $0.00 $0.00 $25,000.00 $0.00 20523-57792 OSWEGATCHIE-BUILDING RENOVATIONS $212,500.00 $0.00 $0.00 $306,650.00 $433,471.00 ($306,650.00) $16,459.21 $629,511.79 $0.00 $0.00 20523-57836 FIRE SERVICES CARPET REPLACEMENT $0.00 $30,000.00 $0.00 $0.00 $30,000.00 $0.00 20523-57838 FIRE SERVICES PRE EMPTION LIGHT REPAIRS $0.00 $50,000.00 $0.00 $0.00 $50,000.00 $0.00 20529-57458 EVIDENCE ROOM & ARMORY UPDATE & RENOVATE $36,313.33 $0.00 $0.00 $36,287.00 $26.33 $0.00 $0.00 $26.33 20530-57695 MUNICIPAL COMPLEX RENOVATION $372,061.13 $6,100,833.00 $0.00 $17,090.06 $354,971.07 $6,100,833.00 $0.00 20507-59205 FUNDING OFFSETS DEBT SERVICE-MUNICIPAL COMPLEX ($1,251,500.00) ($6,000,000.00) $0.00 ($1,251,500.00) ($6,000,000.00) $0.00 20530-57696 MUNICIPAL COMPLEX CLEAN UP $4,370.23 $0.00 $0.00 $4,370.23 $0.00 $0.00 20530-57880 MAJOR/MINOR COLLECTOR ROAD PAVING $1,313,572.12 $0.00 $0.00 $483,926.34 $829,645.78 $0.00 $0.00 20530-57886 OLD NORWICH ROAD PAVING $0.00 $0.00 $0.00 $1,053,000.00 $1,053,000.00 $0.00 $0.00 20531-55771 HARVEY AVENUE PUMP STATION REHAB $503.58 $0.00 $0.00 $503.58 $0.00 $0.00 $503.58 20531-57685 I/I MITIGATION & CONTROL $312,063.86 $0.00 $0.00 $67,555.57 $244,508.29 $0.00 $0.00 20531-57816 OLD NORWICH/EVERGREEN/HARVEY AVE PUMP STATION REHA $554,835.61 $0.00 $0.00 $755,369.00 $1,154,618.70 $155,585.91 $0.00 $0.00 20531-57881 PLASTIC WATER SERVICE LINE REPLACEMENT $532,846.44 $0.00 $0.00 $100,000.00 $181,300.00 $218,193.88 $495,952.56 $100,000.00 $0.00 Page 1 TOWN OF WATERFORD CAPITAL AND NON-RECURRING EXPENDITURE FUND FUND BALANCE DESIGNATION AND APPROPRIATION JULY 1,2023 TO JUNE 30,2024 AS OF APRIL 30,2024 BEGINNING FY24 RTM CLOSED AVAILABLE BALANCE XFER IN FISCAL YEAR 2023-2024 ENCUMBERED/ BAL (REVERTS INTEREST TO DATE APPROPRIATIONS DESIGNATED UNDESIGNATED DESIGNATED APPROPRIATED DESIGNATED UNDESIGNATED EXPENDED TO FUND) INC APPROPRIATED DESIGNATEDUNDESIGNATED 20536-57848 LIBRARY HVAC UPGRADE $0.00 $1,091,200.00 $0.00 $1,091,200.00 ($1,091,200.00) $120,000.00 $971,200.00 $0.00 $0.00 20500-49000 CT PUBLIC LIBRARY CONSTRUCTION GRANT $0.00 ($250,000.00) $0.00 $0.00 ($250,000.00) $0.00 20537-57735 LEARY PARK ROAD /PARKING LOT $0.00 $20,000.00 $0.00 $0.00 $20,000.00 $0.00 20537-57878 REPAIR OF PLEASURE BEACH SIDEWALK/PATH $15,236.00 $0.00 $0.00 $0.00 $15,236.00 $0.00 $0.00 $15,236.00 20541-57328 ALEWIFE COVE DREDGING $0.00 $37,500.00 $0.00 $0.00 $37,500.00 $0.00 20547-47846 FIBER UPGRADE $0.00 $0.00 $0.00 $1,126.00 $0.00 $1,126.00 $0.00 $0.00 $0.00 20547-57847 TOWN-WIDE CAMERA SYSTEM $0.00 $85,000.00 $0.00 $84,914.00 ($84,914.00) $84,914.00 $86.00 $0.00 20547-57860 PHONE SYSTEM UPGRADE $0.00 $16,000.00 $0.00 $581,700.00 $537,623.94 $44,076.06 $16,000.00 $0.00 20547-57861 SWITCHES $0.00 $2,258.00 $0.00 $0.00 $2,258.00 $0.00 20547-57882 COMPUTER REPLACEMENTS $0.00 $0.00 $0.00 $42,250.00 $34,181.00 ($34,181.00) $34,180.35 $0.65 $8,069.00 $0.00 20500-43600 TURF FIELD RENTAL REVENUES $0.00 $4,815.00 $0.00 $0.00 $4,815.00 $0.00 20560-55020 CLMS CHILLER REPLACEMENTS $788,095.00 $0.00 $0.00 $12,120.96 $775,974.04 $0.00 $0.00 20560-57822 IT LEARNING BOARDS -END OF LIFE $50,108.35 $27,319.88 $0.00 $35,906.25 $14,202.10 $27,319.88 $0.00 20560-57828 QH 10-YR RETRO COMMISSIONING $0.00 $30,000.00 $0.00 $0.00 $30,000.00 $0.00 20560-57833 TENNIS COURTS $0.00 $52,300.00 $0.00 $0.00 $52,300.00 $0.00 20560-57841 BUS LOT OFFICE $0.00 $150,000.00 $0.00 $0.00 $150,000.00 $0.00 20560-57842 SCHOOL SECURITY $32,175.00 $0.00 $0.00 $1,982,900.00 $1,982,900.00 ($1,982,900.00) $137,144.24 $1,877,930.76 $0.00 $0.00 20560-57883 FINANCING ENERGY EFFICIENT EQUIPMENT $0.00 $0.00 $0.00 $243,335.00 $243,335.00 $0.00 $0.00 20560-57884 CHROMEBOOK & IPAD EQUIPMENT $0.00 $0.00 $0.00 $180,850.00 $180,242.00 $608.00 $0.00 $0.00 205-31520 UNDESIGNATED FUND BALANCE $0.00 $0.00 $3,025,793.38 ($3,332,596.47) $509,025.51 $0.00 $0.00 $202,222.42 $4,105,206.71 $3,121,906.88 $3,025,793.38 $3,255,800.00 $8,078,194.47 ($4,745,598.00) ($3,332,596.47) $5,293,409.95 $163,810.00 $509,025.51 $6,726,181.23 $1,632,108.88 $366,032.42 Page 2 TOWN OF WATERFORD CAPITAL AND NON-RECURRING EXPENDITURE FUND FUND BALANCE AND APPROPRIATION AS OF APRIL 30, 2024 APPROPRIATED DESIGNATED UNDESIGNATED TOTAL 20501-57018 PURCHASE 8 GOSHEN ROAD $6,314.00 $0.00 $0.00 $6,314.00 20501-57639 REVALUATION ($17,255.80) $407,700.00 $0.00 $390,444.20 20511-57767 NEVINS COTTAGE STRUCTURAL REPAIRS $20,715.00 $100,000.00 $0.00 $120,715.00 20511-57839 TOWN HALL EMERGENCY EGRESS $0.00 $0.00 $41,275.00 $41,275.00 20511-57856 JORDAN VILLAGE SIDEWALKS $0.00 $0.00 $87,786.36 $87,786.36 20502-48043 JORDAN VILLAGE SIDEWALK GRANT $0.00 $280,000.00 $0.00 $280,000.00 20511-57866 TOWN HALL FRONT DOOR $0.00 $0.00 $18,982.73 $18,982.73 20511-57870 MAGO POINT IMPROVEMENTS $1,500.00 $374,500.00 $0.00 $376,000.00 20511-57871 PUBLIC SAFETY BLDG HVAC $0.00 $62,045.00 $0.00 $62,045.00 20511-57872 ROOF & HVAC REPLACEMENT PUBLIC SAFETY BUILDING $14,369.20 $0.00 $0.00 $14,369.20 20511-57874 RECONDITION ELEVATORS -TOWN HALL/YOUTH SERVICES BLDG $28,568.85 $0.00 $0.00 $28,568.85 20511-57876 SW SCHOOL UNDERGROUND TANK $75,527.14 $0.00 $0.00 $75,527.14 20511-57879 TOWN HALL BATHROOM REFURBISHMENT $17,046.35 $0.00 $0.00 $17,046.35 20511-57885 COMMUNITY CENTER BMS PROJECT $51,050.00 $0.00 $0.00 $51,050.00 20522-57794 MOBILE & PORTABLE RADIO REPLACEMENT PROGRAM $40.95 $3,683.00 $0.00 $3,723.95 20522-57887 FARGO WATER TANK ANTENNA $0.74 $0.00 $0.00 $0.74 20523-57777 FIRE SERVICES -SCBA UPGRADE PROGRAM $18.56 $0.00 $0.00 $18.56 20523-57791 JORDAN-TRAFFIC LIGHT UPGRADE $0.00 $25,000.00 $0.00 $25,000.00 20523-57792 OSWEGATCHIE-BUILDING RENOVATIONS $629,511.79 $0.00 $0.00 $629,511.79 20523-57836 FIRE SERVICES CARPET REPLACEMENT $0.00 $30,000.00 $0.00 $30,000.00 20523-57838 FIRE SERVICES PRE EMPTION LIGHT REPAIRS $0.00 $50,000.00 $0.00 $50,000.00 20529-57458 EVIDENCE ROOM & ARMORY UPDATE & RENOVATE $0.00 $0.00 $26.33 $26.33 20530-57695 MUNICIPAL COMPLEX RENOVATION $354,971.07 $6,100,833.00 $0.00 $6,455,804.07 20507-59205 FUNDING OFFSETS DEBT SERVICE-MUNICIPAL COMPLEX ($1,251,500.00) ($6,000,000.00) $0.00 ($7,251,500.00) 20530-57696 MUNICIPAL COMPLEX CLEAN UP $4,370.23 $0.00 $0.00 $4,370.23 20530-57880 MAJOR/MINOR COLLECTOR ROAD PAVING $829,645.78 $0.00 $0.00 $829,645.78 20530-57886 OLD NORWICH ROAD PAVING $1,053,000.00 $0.00 $0.00 $1,053,000.00 20531-55771 HARVEY AVENUE PUMP STATION REHAB $0.00 $0.00 $503.58 $503.58 20531-57685 I/I MITIGATION & CONTROL $244,508.29 $0.00 $0.00 $244,508.29 20531-57816 OLD NORWICH/EVERGREEN/HARVEY AVE PUMP STATION REHAB $155,585.91 $0.00 $0.00 $155,585.91 20531-57881 PLASTIC WATER SERVICE LINE REPLACEMENT $495,952.56 $100,000.00 $0.00 $595,952.56 20536-57848 LIBRARY HVAC UPGRADE $971,200.00 $0.00 $0.00 $971,200.00 20500-49000 CT PUBLIC LIBRARY CONSTRUCTION GRANT $0.00 ($250,000.00) $0.00 ($250,000.00) 20537-57735 LEARY PARK ROAD /PARKING LOT $0.00 $20,000.00 $0.00 $20,000.00 20537-57878 REPAIR OF PLEASURE BEACH SIDEWALK/PATH $0.00 $0.00 $15,236.00 $15,236.00 20541-57328 ALEWIFE COVE DREDGING $0.00 $37,500.00 $0.00 $37,500.00 20547-57847 TOWN-WIDE CAMERA SYSTEM $84,914.00 $86.00 $0.00 $85,000.00 20547-57860 PHONE SYSTEM UPGRADE $44,076.06 $16,000.00 $0.00 $60,076.06 20547-57861 SWITCHES $0.00 $2,258.00 $0.00 $2,258.00 Page 1 TOWN OF WATERFORD CAPITAL AND NON-RECURRING EXPENDITURE FUND FUND BALANCE AND APPROPRIATION AS OF APRIL 30, 2024 APPROPRIATED DESIGNATED UNDESIGNATED TOTAL 20547-57882 COMPUTER REPLACEMENTS $0.65 $8,069.00 $0.00 $8,069.65 20500-43600 TURF FIELD RENTAL REVENUES $0.00 $4,815.00 $0.00 $4,815.00 20560-55020 CLMS CHILLER REPLACEMENTS $775,974.04 $0.00 $0.00 $775,974.04 20560-57822 IT LEARNING BOARDS -END OF LIFE $14,202.10 $27,319.88 $0.00 $41,521.98 20560-57828 QH 10-YR RETRO COMMISSIONING $0.00 $30,000.00 $0.00 $30,000.00 20560-57833 TENNIS COURTS $0.00 $52,300.00 $0.00 $52,300.00 20560-57841 BUS LOT OFFICE $0.00 $150,000.00 $0.00 $150,000.00 20560-57842 SCHOOL SECURITY $1,877,930.76 $0.00 $0.00 $1,877,930.76 20560-57883 FINANCING ENERGY EFFICIENT EQUIPMENT $243,335.00 $0.00 $0.00 $243,335.00 20560-57884 CHROMEBOOK & IPAD EQUIPMENT $608.00 $0.00 $0.00 $608.00 205-31520 UNDESIGNATED FUND BALANCE $0.00 $0.00 $202,222.42 $202,222.42 TOTAL $6,726,181.23 $1,632,108.88 $366,032.42 $8,724,322.53 Page 2 Insurance Administration Fund Balance Sheet April 30, 2024 Assets Cash and Cash Equivalents 7,054,205 Accounts Receivable 744 Due From Other Funds 499,720 Total Assets 7,554,669 Liabilities Accrued Liabilities (IBNR) 727,000 Advance Payments 10,053 Total Liabilities 737,053 Net Assets Unrestricted $6,817,616 Total Net Assets $ $6,817,616