July Financials
document center
| Pages | 20 |
|---|---|
| File Size | 1.0 MB |
| Folder | Departments/Finance/Monthly Financial Reports |
| OCR Status | Searchable (OCR processed) |
| Source URL | Original |
Document Preview
Full Text (OCR Extracted)
Contributed Gifts Fund July 31, 2023 R&P R&P R&P R&P FINANCE POLICE POLICE POLICE POLICE POLICE R&P MEMORIAL FRANCES X. CIVIC DEIDRICK HELMET R&P TREES & SWEENEY R&P R&P TRIANGLE FIELD PRESS DEPT. DEPT. DEPT. DEPT. PUBLIC RODEO GENERAL BENCHES MEMORIAL DOG PARK PLAYGROUND MEMORIAL BOX AUDITORIUM AUSTISM VEHICLE K-9 GENERAL SAFETY FISCAL YEAR 2024 DONATIONS DONATIONS DONATIONS DONATIONS DONATIONS DONATIONS DONATIONS DONATIONS A/V UPGRADE TRAINING CHALLENGE PROGRAM DONATIONS DOCK TOTAL REVENUES K9 DONATIONS $2,000.00 POLICE DEPT. GENERAL DONATIONS $1,000.00 TOTAL REVENUES $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2,000.00 $1,000.00 $0.00 $3,000.00 EXPENDITURES 07/14/23 EAST COAST K-9 TICO $9,950.00 TOTAL EXPENDITURES $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $9,950.00 $0.00 $9,950.00 NET CURRENT YEAR ACTIVITY $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2,000.00 ($8,950.00) $0.00 ($6,950.00) PRIOR YEAR BALANCE $594.72 $29.60 $1,271.39 $65.00 $725.97 $60,486.32 $1,140.00 $12,600.00 $151.00 $1,700.00 $780.11 $14,897.23 $11,234.78 $7.04 $105,683.16 CURRENT YEAR BALANCE $594.72 $29.60 $1,271.39 $65.00 $725.97 $60,486.32 $1,140.00 $12,600.00 $151.00 $1,700.00 $780.11 $16,897.23 $2,284.78 $7.04 $98,733.16 Page 1 of 1 GENERAL FUND STATEMENT OF EXPENDITURES COMPARED TO BUDGET FOR FISCAL YEAR 2023-2024, THROUGH JULY 31, 2023 WITH COMPARATIVE ACTUAL AMOUNTS FOR FISCAL YEAR 2022-2023, THROUGH JULY 31, 2022 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 $11,882 5.72% 195,723 $13,494 Registrar of Voters $79,488 $5,070 6.38% 74,418 $9,081 Board of Finance $70,159 $65,089 92.77% 5,070 $61,966 Assessor $292,148 $16,460 5.63% 275,688 $34,284 Board of Assessment Appeals $1,602 $12 0.76% 1,590 $0 Tax Collector $217,865 $34,264 15.73% 183,601 $34,124 Finance Department $747,721 $150,743 20.16% 596,978 $110,126 Legal Department $295,000 ($735) -0.25% 295,735 $0 Town Clerk $252,225 $12,703 5.04% 239,522 $14,933 Planning and Zoning $661,210 $42,213 6.38% 618,997 $45,761 Building Maintenance $899,770 $250,762 27.87% 649,008 $97,030 Insurance $5,105,857 $1,334,227 26.13% 3,771,630 $1,214,177 Economic Development Commission $27,447 $9,419 34.32% 18,028 $800 Conservation Commission $18,250 $1,203 6.59% 17,047 $1,202 Zoning Board of Appeals $4,310 2,968 68.86% 1,342 2,974 Retirement Commission $7,049,737 $1,996,015 28.31% 5,053,722 $1,646,750 R.T.M. $18,903 $12,852 67.99% 6,051 $12,852 Building Department $297,609 $18,649 6.27% 278,960 $14,568 Youth Service Bureau $239,827 $13,915 5.80% 225,912 $27,385 Social Service Grants/Miscellaneous $88,182 $125,214 141.99% (37,032) $5,052 Contingency Fund $265,000 0 0.00% 265,000 0 Emergency Management $1,094,563 $53,179 4.86% 1,041,384 $92,961 Fire Services $3,531,618 $966,598 27.37% 2,565,020 $793,278 Police Department $6,730,602 $417,174 6.20% 6,313,428 $421,178 Public Works Department $4,994,798 $1,249,724 25.02% 3,745,074 $1,176,271 Conservation of Health $148,407 0 0.00% 148,407 0 Public Health Nursing $25,911 0 0.00% 25,911 0 Senior Citizens Commission $484,631 28,547 5.89% 456,084 27,989 Waterford Public Library $1,006,837 $102,626 10.19% 904,211 $99,807 Page 1 of 2 GENERAL FUND STATEMENT OF EXPENDITURES COMPARED TO BUDGET FOR FISCAL YEAR 2023-2024, THROUGH JULY 31, 2023 WITH COMPARATIVE ACTUAL AMOUNTS FOR FISCAL YEAR 2022-2023, THROUGH JULY 31, 2022 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,418,773 $179,637 12.66% 1,239,136 $160,015 Flood and Erosion Control Bd. $2,138 0 0.00% 2,138 331 Ethics Commission $900 47 5.20% 853 0 Human Resources $259,836 $88,228 33.96% 171,608 $93,103 Information Technology $1,165,181 $499,919 42.90% 665,262 $552,982 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,402,902 $2,402,902 100.00% 0 $2,946,905 Transfer to Capital & Non-Recurring Fund $281,250 $281,250 100.00% 0 $1,238,824 Transfer to Dog Fund $100,000 $100,000 100.00% 0 $60,000 Debt Service $8,148,250 $2,176,825 26.72% 5,971,425 $2,246,075 Total General Government $48,645,396 $12,658,466 26.02% $35,986,930 $13,262,747 Board of Education $54,193,983 $1,501,707 2.77% 52,692,276 $1,755,131 Total General Fund $102,839,379 $14,160,174 13.77% $88,679,205 $15,017,878 Page 2 of 2 TOWN OF WATERFORD STATEMENT OF REVENUES COMPARED TO ANTICIPATED FOR FISCAL YEAR 2023-2024, THROUGH JULY 31, 2023 WITH COMPARATIVE ACTUAL AMOUNTS FOR FISCAL YEAR 2022-2023, THROUGH JULY 31, 2022 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 $0 0.00% (326,444) $0 HEALTH & WELFARE $6,359 $0 0.00% (6,359) $0 SUB TOTAL 332,803 0 0.00% (332,803) 0 GENERAL GOVERNMENT PILOT-DISABLED 1,200 0 0.00% (1,200) $0 TIERED PILOT 315,978 0 0.00% (315,978) $0 TAX RELIEF-VETERANS 5,000 0 0.00% (5,000) $0 CIVIL PREPAREDNESS 20,000 0 0.00% (20,000) $0 TELECOMMUNICATIONS PROPERTY TAX 58,071 0 0.00% (58,071) $0 TOWN AID ROADS-IMPROVED 321,120 160,680 50.04% (160,440) $0 LOCAL CAPITAL IMPROVEMENT (LOCIP) 116,994 0 0.00% (116,994) $0 SDE STATE GRANT 14,000 0 0.00% (14,000) $0 ENHANCEMENT 911 22,981 5,646 24.57% (17,335) $5,604 MUNICIPAL REVENUE SHARE GRANT 379,498 0 0.00% (379,498) $0 GRANTS FOR MUNICIPAL PROJECTS 68,510 0 0.00% (68,510) $0 TOTAL GENERAL GOVERNMENT 1,323,352 166,326 12.57% (1,157,026) 5,604 TOTAL STATE OF CONNECTICUT 1,656,155 166,326 10.04% (1,489,829) 5,604 OTHER SOURCES EDUCATION TUITION 60,000 0 0.00% (60,000) 0 RENT & MISCELLANEOUS 1,500 0 0.00% (1,500) 0 SUB TOTAL 61,500 0 0.00% (61,500) 0 TOWN OF WATERFORD STATEMENT OF REVENUES COMPARED TO ANTICIPATED FOR FISCAL YEAR 2023-2024, THROUGH JULY 31, 2023 WITH COMPARATIVE ACTUAL AMOUNTS FOR FISCAL YEAR 2022-2023, THROUGH JULY 31, 2022 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 13,776 4.73% (277,530) 6,335 INTEREST ON INVESTMENTS 2,500,000 150,567 6.02% (2,349,433) 20,435 RECREATION & PARKS 165,000 123,250 74.70% (41,750) 125,143 BUILDING INSPECTOR 400,000 40,321 10.08% (359,679) 106,359 LICENSE, FEE, PERMIT, FINE 135,309 1,654 1.22% (133,656) 1,958 LIBRARY 0 175 #DIV/0! 175 0 SALE OF EQUIPMENT 1,000 0 0.00% (1,000) 0 NL RADIO COMM. NETWORK USE FEE 72,000 0 0.00% (72,000) 0 BULKY WASTE FEES 110,000 10,541 9.58% (99,459) 10,776 MISCELLANEOUS 27,582 1,849 6.71% (25,733) 2,169 CONVEYANCE TAX 200,000 27,964 13.98% (172,036) 33,529 EMS-REG COMM CTR FEES 6,000 0 0.00% (6,000) 0 PLANNING& ZONING, ZBA, CONSRV COMM 54,183 1,701 3.14% (52,482) 19,094 TOWN CLERK FEES 175,000 12,247 7.00% (162,753) 14,408 TIPPING FEES 275,000 0 0.00% (275,000) 0 RECYCLING 45,000 0 0.00% (45,000) 0 TRANSFERS FROM OTHER FUNDS 0.00 0 #DIV/0! 0 0 EUGENE O'NEILL GATE/LEASE REVENUE 10,000 0 0.00% (10,000) 0 YSB BOE CLERICAL STIPEND 5,000 0 0.00% (5,000) 0 RENTAL OF BUILDINGS 50,000 9,096 18.19% (40,904) 10,789 SENIOR SERVICES 10,196 3,457 33.91% (6,739) 1,594 VERSA KART/BLUE BOXES 10,000 900 9.00% (9,100) 1,080 PUBLIC WORKS BOE CUSTODIAL SUBSIDY 73,218 73,218 100.00% 0 0 SUB TOTAL 4,615,794 470,715 10.20% (4,145,079) 353,669 TOTAL OTHER SOURCES 4,677,294 470,715 10.06% (4,206,579) 353,669 PROPERTY TAXATION CURRENT PROPERTY TAX 95,263,203 64,536,461 67.75% (30,726,742) 58,242,321 PRIOR YEAR TAXES 476,546 17,668 3.71% (458,878) 27,657 TOTAL PROPERTY TAXATION 95,739,749 64,554,129 67.43% (31,185,620) 58,269,978 TOTAL REVENUES 102,073,198 65,191,170 63.87% (36,882,028) 58,629,251 TOWN OF WATERFORD CAPITAL PROJECTS FUNDS JULY 31, 2023 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 JULY 31, 2023 Revenues: Investment Income 15,391 Vehicle Rentals 900 Total Revenues 16,291 Expenditures: Equipment Replacement 24,375 Vehicle Replacement 649,860 Total Expenditures 674,235 Excess (Deficiency) of Revenues Over Expenditures (657,944) Other Financing Sources (Uses): Transfers from other funds 1,000,000 Total Other Financing Sources (Uses) 1,000,000 Net Change in Fund Balances 342,056 Fund Balances - Beginning 3,509,747 Fund Balances - Ending 3,851,803 TOWN OF WATERFORD CAPITAL IMPROVEMENT FUND JULY 31, 2023 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 157,508.18 12,491.82 92.7% 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 14,590.00 72,910.00 16.7% 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 219,786.41 30,213.59 87.9% 31122-55892 BLDG MAINT FY22 AC UNIT REPLACMENT RADIO SITES 60,500.00 46,589.15 13,910.85 77.0% 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 79,950.67 180,049.33 30.8% 31123-55905 BLDG MAINT FY23 UST REPLACEMENT LIBRARY&PUBLIC SAFETY 420,000.00 241,694.24 178,305.76 57.5% 31123-57857 BLDG MAINT FY23 CIVIC TRIANGLE UPGRADES 1,012,390.00 1,012,386.61 3.39 100.0% 31124-55904 BLDG MAINT FY24 UST REPLACEMT (EUGENE O'NEILL) 43,500.00 0.00 43,500.00 0.0% 31124-55912 BLDG MAINT FY24 TOWN DOCK REPLACEMENT 40,000.00 0.00 40,000.00 31124-55913 BLDG MAINT FY24 JORDAN PARKHOUSE REPAIRS 25,000.00 0.00 25,000.00 32224-55908 5EMERGENCY MANAGEMENT FY24 APCO INTELLICOM GUIDECARD SYST 40,000.00 0.00 40,000.00 32224-55909 5EMERGENCY MANAGEMENT FY24 EVENTIDE NEXLOGDX RECORDER 88,701.00 0.00 88,701.00 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 1,944,901.12 809,098.88 70.6% 33020-59300 PUBLIC WORKS FY20 FUNDING OFFSET-CROSS ROAD (2,754,000.00) (2,611,641.60) (142,358.40) 94.8% 33021-55867 PUBLIC WORKS FY21 REMOVE UST COHANZIE FIRE 337,500.00 336,563.20 936.80 99.7% 33022-55882 PUBLIC WORKS FY22 NORMAN/CONCRETE PANELS 80,100.00 19,639.98 60,460.02 24.5% 33022-55883 PUBLIC WORKS FY22 WILLIAM ST CONCRETER SIDEWALK 42,300.00 9,567.78 32,732.22 22.6% 33022-55884 PUBLIC WORKS FY22 SUMMER STREET/CONCRETE SW 33,420.00 7,545.98 25,874.02 22.6% 33022-55885 PUBLIC WORKS FY22 DAVID STREET/CONCRETE SW 43,680.00 9,565.78 34,114.22 21.9% 33023-55890 PUBLIC WORKS FY23 ROAD RESURFACING EVERSOURCE AF 315,951.00 0.00 315,951.00 0.0% 33023-55901 PUBLIC WORKS FY23 CURB REPLACEMENT SANDY HOLLW 219,300.00 10,720.56 208,579.44 4.9% Page 1 of 2 TOWN OF WATERFORD CAPITAL IMPROVEMENT FUND JULY 31, 2023 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 0.00 325,915.00 0.0% 33024-55911 PUBLIC WORKS FY24 BLOOMINGDALE/HUNTS BRK CULVERT 15,000.00 0.00 15,000.00 0.0% 33024-55914 PUBLIC WORKS FY24 ROTARY LIFT REPLACEMENTS 75,000.00 0.00 75,000.00 0.0% 33121-55871 UTILITY COMM FY21 EVERGREEN PUMP STATION 375,000.00 369,309.92 5,690.08 98.5% 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 0.00 250,000.00 0.0% 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,927.50 (927.50) 100.7% 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 0.00 272,000.00 0.0% 34724-55910 INFORMATION TECHNOLOGY FY24 NEXGEN TRANSITION 309,520.00 302,783.90 6,736.10 97.8% TOTALS 7,401,064.64 3,583,935.08 3,817,129.56 48.4% 1,000,000.00 PRIOR YEAR EXPENDITURES 669,352.18 CURRENT YEAR EXPENDITURES 2,914,582.90 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 JULY 31,2023 BEGINNING FY24 RTM AVAILABLE BALANCE XFER IN FISCAL YEAR 2023-2024 ENCUMBERED/ INTEREST TO DATE APPROPRIATIONS DESIGNATED UNDESIGNATED DESIGNATED APPROPRIATED DESIGNATEDUNDESIGNATED EXPENDED INC APPROPRIATED DESIGNATED UNDESIGNATED 20501-57639 REVALUATION ($6,547.47) $332,700.00 $0.00 $75,000.00 $17,255.80 ($23,803.27) $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 $5,727.21 $82,059.15 $0.00 $0.00 20502-48043 JORDAN VILLAGE SIDEWALK GRANT $0.00 $280,000.00 $0.00 $0.00 $0.00 $0.00 20511-57866 TOWN HALL FRONT DOOR $18,982.73 $0.00 $0.00 $18,982.73 $0.00 $0.00 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,605.00 $14,669.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,214.88 $89,517.44 $0.00 $0.00 20511-57879 TOWN HALL BATHROOM REFURBISHMENT $293,871.35 $0.00 $0.00 $293,871.35 $0.00 $0.00 20522-57794 MOBILE & PORTABLE RADIO REPLACEMENT PROGRAM $44,991.50 $500,436.00 $0.00 $23,811.75 $21,179.75 $500,436.00 $0.00 20523-57777 FIRE SERVICES -SCBA UPGRADE PROGRAM $0.00 $0.00 $0.00 $64,000.00 $0.00 $64,000.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 $212,500.00 $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 $24,100.00 $12,213.33 $0.00 $0.00 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 $485,194.50 $828,377.62 $0.00 $0.00 20531-55771 HARVEY AVENUE PUMP STATION REHAB $503.58 $0.00 $0.00 $503.58 $0.00 $0.00 20531-57685 I/I MITIGATION & CONTROL $312,063.86 $0.00 $0.00 $1,078.00 $310,985.86 $0.00 $0.00 20531-57816 OLD NORWICH/EVERGREEN/HARVEY AVE PUMP STATION REHA $554,835.61 $0.00 $0.00 $5,010.00 $549,825.61 $0.00 $0.00 20531-57881 PLASTIC WATER SERVICE LINE REPLACEMENT $532,846.44 $0.00 $0.00 $100,000.00 $43,253.63 $489,592.81 $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 JULY 31,2023 BEGINNING FY24 RTM AVAILABLE BALANCE XFER IN FISCAL YEAR 2023-2024 ENCUMBERED/ INTEREST TO DATE APPROPRIATIONS DESIGNATED UNDESIGNATED DESIGNATED APPROPRIATED DESIGNATEDUNDESIGNATED EXPENDED INC APPROPRIATED DESIGNATED UNDESIGNATED 20536-57848 LIBRARY HVAC UPGRADE $0.00 $1,091,200.00 $0.00 $0.00 $1,091,200.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 $14,980.00 $256.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-57847 TOWN-WIDE CAMERA SYSTEM $0.00 $85,000.00 $0.00 $0.00 $85,000.00 $0.00 20547-57860 PHONE SYSTEM UPGRADE $0.00 $16,000.00 $0.00 $0.00 $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,945.00 $775,150.00 $0.00 $0.00 20560-57822 IT LEARNING BOARDS -END OF LIFE $50,108.35 $27,319.88 $0.00 $34,740.00 $15,368.35 $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 $32,175.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 ($424,185.00) $48,009.25 $2,649,617.63 $4,105,206.71 $3,121,906.88 $3,025,793.38 $281,250.00 $424,185.00 $0.00 ($424,185.00) $1,392,157.90 $48,009.25 $3,137,233.81 $3,123,156.88 $2,649,617.63 Page 2 TOWN OF WATERFORD CAPITAL AND NON-RECURRING EXPENDITURE FUND FUND BALANCE AND APPROPRIATION AS OF JULY 31, 2023 APPROPRIATED DESIGNATED UNDESIGNATED TOTAL 20501-57639 REVALUATION ($23,803.27) $407,700.00 $0.00 $383,896.73 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 $82,059.15 $0.00 $0.00 $82,059.15 20511-57866 TOWN HALL FRONT DOOR $18,982.73 $0.00 $0.00 $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,669.20 $0.00 $0.00 $14,669.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,517.44 $0.00 $0.00 $89,517.44 20511-57879 TOWN HALL BATHROOM REFURBISHMENT $293,871.35 $0.00 $0.00 $293,871.35 20522-57794 MOBILE & PORTABLE RADIO REPLACEMENT PROGRAM $21,179.75 $500,436.00 $0.00 $521,615.75 20523-57792 OSWEGATCHIE-BUILDING RENOVATIONS $212,500.00 $0.00 $0.00 $212,500.00 20523-57777 FIRE SERVICES -SCBA UPGRADE PROGRAM $0.00 $64,000.00 $0.00 $64,000.00 20523-57791 JORDAN-TRAFFIC LIGHT UPGRADE $0.00 $25,000.00 $0.00 $25,000.00 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 $12,213.33 $0.00 $0.00 $12,213.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 $828,377.62 $0.00 $0.00 $828,377.62 20531-55771 HARVEY AVENUE PUMP STATION REHAB $503.58 $0.00 $0.00 $503.58 20531-57685 I/I MITIGATION & CONTROL $310,985.86 $0.00 $0.00 $310,985.86 20531-57816 OLD NORWICH/EVERGREEN/HARVEY AVE PUMP STATION REHAB $549,825.61 $0.00 $0.00 $549,825.61 20531-57881 PLASTIC WATER SERVICE LINE REPLACEMENT $489,592.81 $100,000.00 $0.00 $589,592.81 20536-57848 LIBRARY HVAC UPGRADE $0.00 $1,091,200.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 $256.00 $0.00 $0.00 $256.00 20541-57328 ALEWIFE COVE DREDGING $0.00 $37,500.00 $0.00 $37,500.00 20547-57847 TOWN-WIDE CAMERA SYSTEM $0.00 $85,000.00 $0.00 $85,000.00 20547-57860 PHONE SYSTEM UPGRADE $0.00 $16,000.00 $0.00 $16,000.00 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 20500-43600 TURF FIELD RENTAL REVENUES $0.00 $4,815.00 $0.00 $4,815.00 20560-55020 CLMS CHILLER REPLACEMENTS $775,150.00 $0.00 $0.00 $775,150.00 20560-57822 IT LEARNING BOARDS -END OF LIFE $15,368.35 $27,319.88 $0.00 $42,688.23 20560-57828 QH 10-YR RETRO COMMISSIONING $0.00 $30,000.00 $0.00 $30,000.00 Page 1 TOWN OF WATERFORD CAPITAL AND NON-RECURRING EXPENDITURE FUND FUND BALANCE AND APPROPRIATION AS OF JULY 31, 2023 APPROPRIATED DESIGNATED UNDESIGNATED TOTAL 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 $32,175.00 $0.00 $0.00 $32,175.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 $2,649,617.63 $2,649,617.63 TOTAL $3,137,233.81 $3,403,156.88 $2,649,617.63 $9,190,008.32 Page 2 Insurance Administration Fund Balance Sheet July 31, 2023 Assets Cash and Cash Equivalents 5,186,531 Accounts Receivable 4,784 Due From Other Funds 373,513 Total Assets 5,564,828 Liabilities Accrued Liabilities (IBNR) 1,007,370 Advance Payments 28,261 Total Liabilities 1,035,631 Net Assets Unrestricted $4,529,197 Total Net Assets $ $4,529,197 Note: Healthcare entry for FY24 is not posted yet