January 2024 Finanical Reports
document center
| Pages | 27 |
|---|---|
| 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 January 31, 2024 R&P R&P R&P R&P FINANCE R&P MEMORIAL FRANCES X. CIVIC DEIDRICK HELMET R&P TREES & SWEENEY R&P R&P TRIANGLE R&P FIELD PRESS R&P DEPT. RODEO GENERAL BENCHES MEMORIAL DOG PARK PLAYGROUND MEMORIAL TOY BOX BOX CEMETERY AUDITORIUM FISCAL YEAR 2024 DONATIONS DONATIONS DONATIONS DONATIONS DONATIONS DONATIONS DONATIONS DONATIONS DONATIONS DONATIONS A/V UPGRADE REVENUES 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 $0.00 $500.00 $0.00 $35.00 $0.00 $0.00 $220.00 $0.00 $100.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 TOTAL EXPENDITURES $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 NET CURRENT YEAR ACTIVITY $0.00 $0.00 $500.00 $0.00 $35.00 $0.00 $0.00 $220.00 $0.00 $100.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 CURRENT YEAR BALANCE $594.72 $29.60 $1,771.39 $65.00 $760.97 $60,486.32 $1,140.00 $220.00 $12,600.00 $100.00 $151.00 Page 1 of 2 Contributed Gifts Fund January 31, 2024 FISCAL YEAR 2024 REVENUES 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 TOTAL EXPENDITURES NET CURRENT YEAR ACTIVITY PRIOR YEAR BALANCE CURRENT YEAR BALANCE POLICE POLICE POLICE POLICE POLICE DEPT. DEPT. DEPT. PUBLIC AUSTISM VEHICLE K-9 GENERAL SAFETY TRAINING CHALLENGE PROGRAM DONATIONS DOCK TOTAL $2,000.00 $3,323.00 $0.00 $0.00 $2,000.00 $3,323.00 $0.00 $6,178.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 $0.00 $0.00 $12,320.58 $10,870.77 $0.00 $23,191.35 $0.00 $0.00 ($10,320.58) ($7,547.77) $0.00 ($17,013.35) $1,700.00 $780.11 $14,897.23 $11,234.78 $7.04 $105,683.16 $1,700.00 $780.11 $4,576.65 $3,687.01 $7.04 $88,669.81 Page 2 of 2 GENERAL FUND STATEMENT OF EXPENDITURES COMPARED TO BUDGET FOR FISCAL YEAR 2023-2024, THROUGH JANUARY 31, 2024 WITH COMPARATIVE ACTUAL AMOUNTS FOR FISCAL YEAR 2022-2023, THROUGH JANUARY 31, 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 $109,027 52.52% 98,578 $117,152 Registrar of Voters $79,488 $53,132 66.84% 26,356 $65,429 Board of Finance $70,159 $78,738 112.23% (8,579) $69,652 Assessor $292,148 $163,492 55.96% 128,656 $148,322 Board of Assessment Appeals $1,602 $223 13.93% 1,379 $314 Tax Collector $217,865 $136,687 62.74% 81,179 $131,625 Finance Department $747,721 $479,470 64.12% 268,252 $436,060 Legal Department $370,000 $350,416 94.71% 19,584 $147,775 Town Clerk $252,225 $153,562 60.88% 98,663 $193,674 Planning and Zoning $661,210 $372,601 56.35% 288,609 $362,458 Building Maintenance $919,233 $731,667 79.60% 187,566 $500,253 Insurance $5,105,857 $4,760,447 93.24% 345,410 $4,407,517 Economic Development Commission $27,447 $9,634 35.10% 17,813 $9,483 Conservation Commission $18,250 $13,444 73.66% 4,807 $1,592 Zoning Board of Appeals $4,310 3,091 71.71% 1,219 3,241 Retirement Commission $7,049,737 $4,318,549 61.26% 2,731,189 $4,099,460 R.T.M. $18,903 $14,834 78.47% 4,069 $14,811 Building Department $297,609 $147,187 49.46% 150,422 $141,958 Youth Service Bureau $239,827 $165,959 69.20% 73,868 $131,506 Social Service Grants/Miscellaneous $88,182 $87,081 98.75% 1,101 $84,254 Contingency Fund $129,972 0 0.00% 129,972 0 Emergency Management $1,094,563 $537,105 49.07% 557,458 $572,569 Fire Services $3,531,618 $2,431,556 68.85% 1,100,062 $2,297,232 Police Department $6,779,340 $3,793,191 55.95% 2,986,149 $3,678,967 Public Works Department $4,994,798 $3,216,063 64.39% 1,778,735 $3,288,968 Conservation of Health $148,407 148,407 100.00% (0) 148,126 Public Health Nursing $25,911 10,000 38.59% 15,911 24,000 Senior Citizens Commission $484,631 287,418 59.31% 197,213 252,547 Waterford Public Library $1,006,837 $620,327 61.61% 386,510 $557,707 Page 1 of 2 GENERAL FUND STATEMENT OF EXPENDITURES COMPARED TO BUDGET FOR FISCAL YEAR 2023-2024, THROUGH JANUARY 31, 2024 WITH COMPARATIVE ACTUAL AMOUNTS FOR FISCAL YEAR 2022-2023, THROUGH JANUARY 31, 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 $875,486 62.57% 523,824 $1,005,397 Flood and Erosion Control Bd. $2,138 243 11.37% 1,895 590 Ethics Commission $900 324 36.00% 576 0 Human Resources $259,836 $196,345 75.57% 63,491 $179,699 Information Technology $1,165,181 $926,315 79.50% 238,866 $792,382 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,514,192 $2,514,192 100.00% 0 $3,012,901 Transfer to Capital & Non-Recurring Fund $2,564,150 $2,564,150 100.00% 0 $3,001,560 Transfer to Dog Fund $100,000 $100,000 100.00% 0 $60,000 Debt Service $8,148,250 $7,730,968 94.88% 417,282 $5,878,841 Total General Government $51,028,296 $38,110,212 74.68% $12,918,084 $35,824,493 Board of Education $54,193,983 $31,259,826 57.68% 22,934,157 $29,623,500 Total General Fund $105,222,279 $69,370,038 65.93% $35,852,241 $65,447,993 Page 2 of 2 TOWN OF WATERFORD STATEMENT OF REVENUES COMPARED TO ANTICIPATED FOR FISCAL YEAR 2023-2024, THROUGH JANUARY 31, 2024 WITH COMPARATIVE ACTUAL AMOUNTS FOR FISCAL YEAR 2022-2023, THROUGH JANUARY 31, 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 $163,222 50.00% (163,222) $163,222 HEALTH & WELFARE $6,359 $6,810 107.09% 451 $5,982 SUB TOTAL 332,803 170,032 51.09% (162,771) 169,204 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 2,323 #DIV/0! 2,323 $1,460 CIVIL PREPAREDNESS 20,000 29,445 147.23% 9,445 $19,653 TELECOMMUNICATIONS PROPERTY TAX 58,071 0 0.00% (58,071) $0 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) $7,000 ENHANCEMENT 911 22,981 16,937 73.70% (6,044) $16,813 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,227,183 92.73% (96,169) 1,063,427 TOTAL STATE OF CONNECTICUT 1,656,155 1,397,215 84.37% (258,940) 1,232,631 OTHER SOURCES EDUCATION TUITION 60,000 0 0.00% (60,000) 105,931 RENT & MISCELLANEOUS 1,500 2,022 134.80% 522 1,479 SUB TOTAL 61,500 2,022 3.29% (59,478) 107,410 TOWN OF WATERFORD STATEMENT OF REVENUES COMPARED TO ANTICIPATED FOR FISCAL YEAR 2023-2024, THROUGH JANUARY 31, 2024 WITH COMPARATIVE ACTUAL AMOUNTS FOR FISCAL YEAR 2022-2023, THROUGH JANUARY 31, 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 184,980 63.50% (106,326) 157,511 INTEREST ON INVESTMENTS 2,500,000 2,008,065 80.32% (491,935) 1,091,321 RECREATION & PARKS 165,000 180,091 109.15% 15,091 166,186 FIRE SERVICES INSPECTIONS & PLAN FEES 0 950 #DIV/0! 950 0 BUILDING INSPECTOR 400,000 334,533 83.63% (65,467) 414,455 LICENSE, FEE, PERMIT, FINE 135,309 9,281 6.86% (126,028) 12,206 LIBRARY 0 862 #DIV/0! 862 120 SALE OF VEHICLES 0 #DIV/0! 0 683 SALE OF EQUIPMENT 1,000 60 5.97% (940) 9,649 NL RADIO COMM. NETWORK USE FEE 72,000 0 0.00% (72,000) 0 BULKY WASTE FEES 110,000 66,683 60.62% (43,317) 63,113 MISCELLANEOUS 27,582 135,574 491.53% 107,992 79,194 CONVEYANCE TAX 200,000 182,644 91.32% (17,356) 288,707 EMS-REG COMM CTR FEES 6,000 1,500 25.00% (4,500) 3,000 PLANNING& ZONING, ZBA, CONSRV COMM 54,183 24,817 45.80% (29,366) 36,873 TOWN CLERK FEES 175,000 84,550 48.31% (90,450) 88,588 LIENS -COLLECTED BY UTILITY COMMISSION 0 2,860 #DIV/0! 2,860 2,780 TIPPING FEES 275,000 70,484 25.63% (204,516) 114,236 RECYCLING 45,000 24,099 53.55% (20,901) 35,156 COST SHARING PRR 0 0 #DIV/0! 0 187,367 TRANSFERS FROM OTHER FUNDS 0.00 770,791 #DIV/0! 770,791 154,843 TRANSFERS IN-PY ENCUMBRANCES 0 29,331 #DIV/0! 29,331 4 EUGENE O'NEILL GATE/LEASE REVENUE 10,000 0 0.00% (10,000) 0 YSB BOE CLERICAL STIPEND 5,000 5,000 100.00% 0 5,000 RENTAL OF BUILDINGS 50,000 37,446 74.89% (12,554) 73,226 SENIOR SERVICES 10,196 14,305 140.30% 4,109 8,945 VERSA KART/BLUE BOXES 10,000 4,990 49.90% (5,010) 4,880 PUBLIC WORKS BOE CUSTODIAL SUBSIDY 73,218 73,218 100.00% 0 0 SUB TOTAL 4,615,794 4,247,112 92.01% (368,682) 2,998,043 TOTAL OTHER SOURCES 4,677,294 4,249,134 90.85% (428,160) 3,105,453 PROPERTY TAXATION CURRENT PROPERTY TAX 95,263,203 94,095,578 98.77% (1,167,625) 94,363,515 PRIOR YEAR TAXES 476,546 261,724 54.92% (214,822) 187,665 TOTAL PROPERTY TAXATION 95,739,749 94,357,302 98.56% (1,382,447) 94,551,180 TOTAL REVENUES 102,073,198 100,003,652 97.97% (2,069,546) 98,889,264 TOWN OF WATERFORD CAPITAL PROJECTS FUNDS JANUARY 31, 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 JANUARY 31, 2024 Revenues: Investment Income 134,625 Vehicle Rentals 28,463 Sale of Vehicles 3,063 Insurance Settlement 47,845 Total Revenues 213,994 Expenditures: Equipment Replacement 97,041 Vehicle Replacement 1,557,451 Total Expenditures 1,654,492 Excess (Deficiency) of Revenues Over Expenditures (1,440,498) Other Financing Sources (Uses): Transfers from other funds 1,000,000 Total Other Financing Sources (Uses) 1,000,000 Net Change in Fund Balances (440,498) Fund Balances - Beginning 3,509,747 Fund Balances - Ending 3,069,250 TOWN OF WATERFORD CAPITAL IMPROVEMENT FUND JANUARY 31, 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 247,769.41 2,230.59 99.1% 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 82,897.82 177,102.18 31.9% 31123-55905 BLDG MAINT FY23 UST REPLACEMENT LIBRARY&PUBLIC SAFETY 420,000.00 400,502.00 19,498.00 95.4% 31123-57857 BLDG MAINT FY23 CIVIC TRIANGLE UPGRADES 1,012,390.00 1,012,386.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,179.40 820.60 96.7% 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 (812,716.58) 1,128,667.58 -257.2% 33023-55901 PUBLIC WORKS FY23 CURB REPLACEMENT SANDY HOLLW 319,300.00 10,720.56 308,579.44 3.4% Page 1 of 2 TOWN OF WATERFORD CAPITAL IMPROVEMENT FUND JANUARY 31, 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 199,382.06 126,532.94 61.2% 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,512,354.64 4,487,204.24 3,025,150.40 59.7% 1,770,791.46 PRIOR YEAR EXPENDITURES 1,408,500.81 CURRENT YEAR EXPENDITURES 3,078,703.43 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 JANUARY 31,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-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 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 $19,125.00 $0.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 $239,565.00 $35.00 $0.00 $0.00 20511-57876 SW SCHOOL UNDERGROUND TANK $122,732.32 $0.00 $0.00 $33,705.18 $89,027.14 $0.00 $0.00 20511-57879 TOWN HALL BATHROOM REFURBISHMENT $293,871.35 $0.00 $0.00 $125,000.00 $401,230.00 $17,641.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) $237,400.00 $62,600.00 $0.00 $0.00 20522-57794 MOBILE & PORTABLE RADIO REPLACEMENT PROGRAM $44,991.50 $500,436.00 $0.00 $44,384.00 $607.50 $500,436.00 $0.00 20522-57887 FARGO WATER TANK ANTENNA $0.00 $0.00 $0.00 $48,998.00 $48,998.00 $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) $62,200.00 $1,800.00 $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 $7,645.03 $204,854.97 $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 $28,578.00 $283,485.86 $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,098,818.70 $211,385.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 $202,059.86 $512,086.58 $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 JANUARY 31,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) $1,091,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 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 $0.00 $42,250.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) $76,832.00 $1,938,243.00 $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,177,225.47) $354,950.72 $203,518.63 $4,105,206.71 $3,121,906.88 $3,025,793.38 $2,564,150.00 $6,700,239.47 ($3,523,014.00) ($3,177,225.47) $4,008,246.19 $107,299.00 $354,950.72 $6,689,900.99 $2,163,042.88 $310,817.63 Page 2 TOWN OF WATERFORD CAPITAL AND NON-RECURRING EXPENDITURE FUND FUND BALANCE AND APPROPRIATION AS OF JANUARY 31, 2024 APPROPRIATED DESIGNATED UNDESIGNATED TOTAL 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 $41,275.00 $0.00 $0.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 $0.00 $374,500.00 $0.00 $374,500.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 $35.00 $0.00 $0.00 $35.00 20511-57876 SW SCHOOL UNDERGROUND TANK $89,027.14 $0.00 $0.00 $89,027.14 20511-57879 TOWN HALL BATHROOM REFURBISHMENT $17,641.35 $0.00 $0.00 $17,641.35 20511-57885 COMMUNITY CENTER BMS PROJECT $62,600.00 $0.00 $0.00 $62,600.00 20522-57794 MOBILE & PORTABLE RADIO REPLACEMENT PROGRAM $607.50 $500,436.00 $0.00 $501,043.50 20522-57887 FARGO WATER TANK ANTENNA $48,998.00 $0.00 $0.00 $48,998.00 20523-57777 FIRE SERVICES -SCBA UPGRADE PROGRAM $1,800.00 $0.00 $0.00 $1,800.00 20523-57791 JORDAN-TRAFFIC LIGHT UPGRADE $0.00 $25,000.00 $0.00 $25,000.00 20523-57792 OSWEGATCHIE-BUILDING RENOVATIONS $204,854.97 $0.00 $0.00 $204,854.97 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 $283,485.86 $0.00 $0.00 $283,485.86 20531-57816 OLD NORWICH/EVERGREEN/HARVEY AVE PUMP STATION REHAB $211,385.91 $0.00 $0.00 $211,385.91 20531-57881 PLASTIC WATER SERVICE LINE REPLACEMENT $512,086.58 $100,000.00 $0.00 $612,086.58 20536-57848 LIBRARY HVAC UPGRADE $1,091,200.00 $0.00 $0.00 $1,091,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 $15,236.00 $0.00 $0.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 20547-57882 COMPUTER REPLACEMENTS $0.00 $42,250.00 $0.00 $42,250.00 Page 1 TOWN OF WATERFORD CAPITAL AND NON-RECURRING EXPENDITURE FUND FUND BALANCE AND APPROPRIATION AS OF JANUARY 31, 2024 APPROPRIATED DESIGNATED UNDESIGNATED TOTAL 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,938,243.00 $0.00 $0.00 $1,938,243.00 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 $203,518.63 $203,518.63 TOTAL $6,689,900.99 $2,163,042.88 $310,817.63 $9,163,761.50 Page 2 Insurance Administration Fund Balance Sheet January 31, 2024 Assets Cash and Cash Equivalents 10,608,691 Accounts Receivable 4,679 Total Assets 10,613,370 Liabilities Accounts Payable 0 Accrued Liabilities (IBNR) 727,000 Due to other funds 207,313 Advance Payments 15,278.51 $ Total Liabilities 949,591 Net Assets Unrestricted $9,663,778 Total Net Assets $ $9,663,778