December 2022
document center
| Pages | 16 |
|---|---|
| File Size | 0.8 MB |
| Folder | Departments/Finance/Monthly Financial Reports |
| OCR Status | Searchable (OCR processed) |
| Source URL | Original |
Document Preview
Full Text (OCR Extracted)
TOWN OF WATERFORD 30123-55738 BOS FY23 FLEET MANAGEMENT PLAN 800,000.00 806,000.00 0.00 100.0% 800,000.00 TO FLEET MANAGEMENT FUN 31117-55803 BLDG MAINT FY17 PARKING LOT -YOUTH SERVICES 300,000.00 7,200.00 292,800.00 2.4% 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 0.00 87,000.00 0.0% 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 18,639.00 62,061.00 23.1% 81122-55819 BLDG MAINT FY22 UST REPLACEMENT 250,000.00 83,132.80 166,867.20 33.3% 31122-55892 BLDG MAINT FY22 AC UNIT REPLACMENT RADIO SITES 60,500.00 6,500.00 54,000.00 10.7% 31122-55893 BLDG MAINT FY22 EUGENE O'NEILL ROOF REPLACE 60,767.64 23,950.00 36,817.64 39.4% 31128-55904 BLDG MAINT FY23 UST REPLACEMENT EUGENE O'NEILL 260,000.00 8,536.57 256,463.43 14% 31128-55905 BLDG MAINT FY23 UST REPLACEMENT LIBRARY&PUBLIC SAFE’ 420,000.00 20,000.00 400,000.00 4.8% 31123-57857 BLDG MAINT FY23 CIVIC TRIANGLE UPGRADES 246,209.00 67,390.00 178,819.00 27.4% 82323-55900 FIRE SERVICES FY23 COHANZIE EMERGENCY GENERATOR 55,000.00 0.00 55,000.00 0.0% 32920-55846 POLICE DEPT FY20 PD POLICY DIRECTIVES REVAMP 30,000.00 30,000.00 0.00 100.0% 32920-55859 POLICE DEPT FY20 POLICE BLGD ARCHITECTURAL PLAN 15,000.00 15,000.00 0.00 100.0% 15,000.00 82922-55876 POLICE DEPT FY22 CYBER CRIME TASK FORCE EQUIPME 11,000.00 11,000.00 0.00 100.0% 1,547.49 32922-55878 POLICE DEPT FY22 IMPOUND YARD IMPROVEMENTS 28,500.00 0.00 28,500.00 0.0% 32922-55879 POLICE DEPT FY22 MARINE OUTBOARD MOTORS 38,500.00 38,500.00 0.00 100.0% 14,321.11 32923-55897 POLICE DEPT FY23 CELL BENCH SAFETY OVERLAY 19,596.00 19,596.00 0.00 100.0% 82923-55898 POLICE DEPT FY23 DE-ESCALATION & COMM TECHNOLOGY 22,085.00 22,085.00 0.00 100.0% 32923-55899 POLICE DEPT FY23 ELECTRON CONTROL WEAPON TRANS 29,345.00 29,345.00 0.00 100.0% 33020-55850 PUBLIC WORKS FY20 CROSS ROAD 2,754,000.00 2,466,996.00 287,004.00 89.6% 38020-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% ACCOUNT DEPT/YEAR DESCRIPTION 33022-55883 PUBLIC WORKS FY22 33022-55886 PUBLIC WORKS FY22 33022-55891 PUBLIC WORKS FY22 33023-55890 PUBLIC WORKS FY23 33028-55901 PUBLIC WORKS FY23 33023-55902 PUBLIC WORKS FY23 33121-55871 UTILITY COMM FY21 33122-55870 UTILITY COMM FY22 33122-55894 UTILITY COMM FY22 33123-55895 UTILITY COMM FY23 33719-55822 REC & PARKS FY19 33720-55855 REC & PARKS FY20 33723-55838 REC & PARKS FY23 WILLIAM ST CONCRETER SIDEWALK SUMMER STREET/CONCRETE SW DAVID STREET/CONCRETE SW CROSS ROAD/ASPHALT T. STATION SCALE & SCALE HOUSE ROAD RESURFACING EVERSOURCE AF RD RESURFACING SEC A, AREA 3 IN-LINE WASTEWATER SOLID GRIND CONTROL PANEL RETRO-FIT (GORMA VETERAN'S FIELD IRRIGATION SYS TOWN HALL BASKETBALL COURT REP TOTALS PRIOR YEAR EXPENDITURES CURRENT YEAR EXPENDITURES 219,300.00 50,000.00 21,000.00 EXPENDED/ ENCUMBERED 9,565.78 106,323.10 0.00 0.00 0.00 103,845.60 0.00 0.00 0.00 0.00 21,000.00 0.00 PERCENT TRANSFERS BALANCE EXPENDED OUT 32,732.22 22.6% 224,90 99.8% 315,951.00 0.0% 208,800.00 4.8% 0.00 100.0% 7,860.39 4,700.00 98.7% 0.00 100.0% 630.00 44,848.17 10.3% CAPITAL AND NON-RECURRING EXPENDITURE FUND FUND BALANCE AND APPROPRIATION AS OF DECEMBER 31, 2022 APPROPRIATED DESIGNATED UNDESIGNATED TOTAL 20601-57639 REVALUATION ($119,993.22) $332,700.00 $0.00 $212,706.78 20611-57767 NEVINS COTTAGE STRUCTURAL REPAIRS $20,715.00 $100,000.00 $0.00 $120,715.00 20511-57788 COMMUNITY CENTER HVAC CONTROL SEPARATION $0.00 $0.00 $49,800.00 $49,800.00 20511-57839 TOWN HALL EMERGENCY EGRESS $41,275.00 $0.00 $0.00 $41,275.00 20611-57856 JORDAN VILLAGE SIDEWALKS $82,059.15 $0.00 $0.00 $82,059.15 20502-48043 JORDAN VILLAGE SIDEWALK GRANT $0.00 $280,000.00 $0.00 $280,000.00 20511-67857 CIVIC TRIANGLE UPGRADES $0.53 $0.00 $0.00 $0.53 20511-57866 TOWN HALL FRONT DOOR $29,885.61 $0.00 $0.00 $29,885.61 20511-57870 MAGO POINT IMPROVEMENTS $0.00 $400,000.00 $0.00 $400,000.00 20511-57871 PUBLIC SAFETY BLDG HVAC $0.00 $62,045.00 $0.00 $62,045.00 20511-87872 ROOF & HVAC REPLACEMENT PUBLIC SAFETY BUILDING $166,813.00 $0.00 $0.00 $166,813.00 20511-57874 RECONDITION ELEVATORS -TOWN HALL/YOUTH SERVICES BLDG $35.00 $0.00 $0.00 $35.00 20611-57876 SW SCHOOL UNDERGROUND TANK $117,500.00 $0.00 $0.00 $117,500.00 20511-57879 TOWN HALL BATHROOM REFURBISHMENT $237,090.00 $0.00 $0.00 $237,090.00 20522-57794 MOBILE & PORTABLE RADIO REPLACEMENT PROGRAM $0.00 $740,165.00 $0.00 $740,165.00 20623-57733 OSWEGATGHIE FIRE BUILDING IMPROVEMENTS $500.00 $2,990,000.00 $0.00 $2,990,500.00 20523-57792 OSWEGATCHIE-BUILDING RENOVATIONS _ $213,700.00 $0.00 $0.00 $213,700.00 20507-59205: FUNDING OFFSETS.FY18 DEBT SERVICE-OSWEGATCHIE FIRE = ae $000. .($3,000,000.00) $0.00 ($3,000,000.00) 20523-57751 ELECTRICAL UPGRADE-JORDAN $0.00 $0.00 $28,688.25 $28,688.25 20623-57791 JORDAN-TRAFFIC LIGHT UPGRADE $0.00 $25,000.00 $0.00 $25,000.00 20523-67826 FIRE SERVICES HYDRAULIC EQUIPMENT $0.00 $0.00 $19,000.00 $19,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 20530-55850 CROSS ROAD DESIGN WORK $0.00 $0.00 $1,464.59 $1,464.59 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 cou 525. (§4;251,500.00)° ~. ($6,000,000.00) : $0.00. -($7,251,600.00) 20530-57696 MUNICIPAL COMPLEX CLEAN UP $4,370.23 $0.00 $0.00 $4,370.23 20530-57815 REDESIGN/RECONSTRUCT GARDINERS WOOD ROAD $0.00 $0.00 $91,609.63 $91,609.63 20530-57832 LED STREETLIGHT CONVERSION $0.00 $0.00 $16,125.54 $16,125.54 20530-57869 CROSSROAD TRAFFIC SIGNAL STUDY $0.00 $20,000.00 $0.00 $20,000.00 20530-57877 RESURFACE ROADS LAKE PONDS ETC $494,160.10 $0.00 $0.00 $494,160.10 20530-57880 MAJOR/MINOR COLLECTOR ROAD PAVING $1,762,736,00 $0.00 $0.00 $1,762,736.00 20531-55771 HARVEY AVENUE PUMP STATION REHAB $19,422.12 $0.00 $0.00 $19,422.12 20531-57685 I/ MITIGATION & CONTROL $310,985.86 $0.00 $0.00 $310,985.86 20531-57802 FORCE MAIN AIR RELEASE VALVES-EVALUATE & REPLACE $0.00 $0.00 $43,000.00 $43,000.00 20531-57816 OLD NORWIGH/EVERGREEN/HARVEY AVE PUMP STATION REHAB $5,438.00 $544,000.00 $0.00 $549,438.00 20531-57817 WASTEWATER PS FLOOD PROTECTION $0.00 $0.00 $85,030.10 $85,030.10 20536-57848 LIBRARY HVAC UPGRADE $0.00 $1,091,200.00 $0.00 $1,091,200.00 20600-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 Pagel CAPITAL AND NON-RECURRING EXPENDITURE FUND FUND BALANCE AND APPROPRIATION AS OF DECEMBER 31, 2022 APPROPRIATED DESIGNATED UNDESIGNATED TOTAL 20637-57878 REPAIR OF PLEASURE BEACH SIDEWALK/PATH $0.63 $0.00 $0.00 $0.63 20641-67328 ALEWIFE COVE DREDGING $0.00 $37,500.00 $0.00 $37,500.00 20847-57846 FIBER UPGRADE $5,179.05 $0.00 $22,620.00 $27,799.05 20647-57847 TOWN-WIDE CAMERA SYSTEM $0.00 $85,000.00 $0.00 $88,000.00 20847-57860 PHONE SYSTEM UPGRADE $0.00 $16,000.00 $0.00 $16,000.00 20547-57861 SWITCHES $0.60 _ $2,258.00 $0.00 _ $2,268.60 20560-57822 IT LEARNING BOARDS -END OF LIFE $14,912.20 $438,067.88 $0.00 $452,980.08 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 $180,000.00 20560-57842 SCHOOL SECURITY $32,175.00 $0.00 $0.00 $32,175.00 205-31520 UNDESIGNATED FUND BALANCE $0.00 $0.00 $2,562,517.11 $2,562,517.14 FISCAL YEAR 2023 REVENUES REC & PARKS MEMORIAL TREES & BENCHES DONATIONS K9 DONATIONS POLICE DEPT. GENERAL DONATIONS POLICE DEPT. FUNDRAISER PATCHES R&P R&P R&P MEMORIAL TREES & BENCHES DONATIONS R&P FRANCES X. SWEENEY MEMORIAL DONATIONS R&P R&P R&P civic TRIANGLE MEMORIAL DONATIONS R&P BOX FINANCE DEPT. AUDITORIUM A/V UPGRADE POLICE DEPT. VEHICLE CHALLENGE POLICE DEPT. PROGRAM $2,050.00 [TOTAL REVENUES EXPENDITURES 07/15/22 HOELCK'S FLORIST 08/04/22 JP MORGAN CHASE 08/04/22 JP MORGAN CHASE 08/19/22 REIMB FLANNAGAN -VET CARE, 09/02/22 REIMB FLANNAGAN 09/30/22 REIMB FLANNAGAN 09/30/22 MARK KOSMAN DESIGN 09/04/22 JP MORGAN CHASE 09/02/22 SYMBOLARTS, LLC 09/16/22 GROTON BOWLING 09/30/22 MEDIA HERE & NOW LLC 10/28/2022 BARCODE MEMORIAL BENCHES 10/28/2022 BARCODE MEMORIAL BENCHES 10/28/2022 BARCODE MEMORIAL BENCHES 10/14/2022 TOP GEAR, INC 09/05/22-10/04/22 JP MORGAN CHASE 10/14/2022 CAPITOL UNIFORMS, INC 09/05/22-10/04/22 JP MORGAN CHASE 10/28/2022 CAPITOL UNIFORMS, INC 11/10/22 KUSTOM SIGNALS 11/10/22 ILINE, INC 11/10/22 WHALING CITY GRAPHIC 11/04/22 JP MORGAN CHASE 11/04/22 JP MORGAN CHASE 12/04/22 JP MORGAN CHASE 12/04/22 JP MORGAN CHASE 12/04/22 JP MORGAN CHASE 12/9/2022 MEDIA HERE& NOW 12/23/2022 REIMB E. FREDRICS 12/09/22 HEALING THERAPIES $840.00 $218.85 $1,469.25 $194.10 $48.78 $22.84 $78.51 $122.00 $477.17 $146.26 $57.00 $28.22 $108.91 $78.35 [TOTAL EXPENDITURES $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 (83,663.75)] $0.00 | $20.00 | 30.00 | $0.00 | $0.00 | 30.00 | $0.00 | $0.00 | 30.00 | 30.00 | $687.86 | PRIOR YEAR BALANCE $4,258.47 | $29.60 | $1,251.39 | $65.00 | $725.97 | $50,486.32 | $1,140.00 | $12,600.00 | $151.00 | $1,700.00 | $780.11 | ICURRENT YEAR BALANCE $594.72 | $29.60 | $65.00 | $725.97 | $50,486.32 | $1,140.00 } $12,600.00 | $1,700.00 | $780.11 | $6,577.54 | DEPT. DEPT. PUBLIC GENERAL PATCHES SAFETY FISCAL YEAR 2023 DONATIONS | FUNDRAISER DOCK TOTAL REVENUES REC & PARKS MEMORIAL TREES & BENCHES DONATIONS POLICE DEPT. GENERAL DONATIONS $8,788.68 POLICE DEPT. FUNDRAISER PATCHES $1,020.00 fTOTAL REVENUES $8,788.68 $1,020.00 30.00] $14,406.78 EXPENDITURES 07/15/22 HOELCK'S FLORIST $148.84 08/04/22 JP MORGAN CHASE 08/04/22 JP MORGAN CHASE $1,130.00 08/19/22 REIMB FLANNAGAN -VET CARE 09/02/22 REIMB FLANNAGAN 09/30/22 REIMB FLANNAGAN 09/30/22 MARK KOSMAN DESIGN 09/04/22 JP MORGAN CHASE 09/02/22 SYMBOLARTS, LLC $1,246.50 09/16/22 GROTON BOWLING $137.25 09/30/22 MEDIA HERE & NOW LLC $500.00 10/28/2022 BARCODE MEMORIAL BENCHES 10/28/2022 BARCODE MEMORIAL BENCHES 10/28/2022 BARCODE MEMORIAL BENCHES 10/14/2022 TOP GEAR, INC 09/05/22-10/04/22 JP MORGAN CHASE $599.00 10/14/2022 CAPITOL UNIFORMS, INC $3,127.77 09/05/22-10/04/22 JP MORGAN CHASE 10/28/2022 CAPITOL UNIFORMS, INC 11/10/22 KUSTOM SIGNALS $2,737.63 11/10/22 ILINE, INC $550.35 11/10/22 WHALING CITY GRAPHIC $1,598.87 11/04/22 JP MORGAN CHASE 11/04/22 JP MORGAN CHASE. $317.97 12/04/22 JP MORGAN CHASE, 12/04/22 JP MORGAN CHASE 12/04/22 JP MORGAN CHASE $1,227.68 12/9/2022 MEDIA HERE& NOW $500.00 12/23/2022 REIMB E. FREDRICS $150.00 12/09/22 HEALING THERAPIES $1,020.00 froYAL EXPENDITURES $13,971.86 $1,020.00 $0.00 | $22,545.85 [NET CURRENT YEAR ACTIVITY ($5,183.18)] 30.00 | $0.00 _(§8,139.07)] [PRIOR YEAR BALANCE $12,153.55 | $0.00 | $7.04 [$91,238.13 | [CURRENT YEAR BALANCE $6,970.37 | $0.00 | $7.04] _ $83,099.06 | DECEMBER 31, 2022 TOWN OF WATERFORD CAPITAL PROJECTS FUNDS REMAINING BALANCE FUND DESCRIPTION APPROPRIATION EXPENDED BALANCE PCT EXP RETURNED 424 DISTRICT MAGNET SCHOOL/EARLY CHLDHD LRNCT —.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 STATE OF CONNECTICUT EDUCATION EQUALIZED COST SHARING HEALTH & WELFARE SUB TOTAL GENERAL GOVERNMENT PILOT-DISABLED TIERED PILOT TAX RELIJEF-VETERANS COURT FINES CIVIL PREPAREDNESS TELECOMMUNICATIONS PROPERTY TAX TOWN AID ROADS-IMPROVED LOCAL CAPITAL IMPROVEMENT (LOCIP) SDE STATE GRANT ENHANCEMENT 911 MUNICIPAL REVENUE SHARE GRANT TOTAL GENERAL GOVERNMENT TOTAL STATE OF CONNECTICUT FEDERAL:GOVERNMENT FEMA REIMBURSEMENT TOTAL FEDERAL GOVERNMENT OTHER SOURCES EDUCATION TUITION RENT & MISCELLANEOUS SUB TOTAL TOWN OF WATERFORD STATEMENT OF REVENUES COMPARED TO ANTICIPATED FOR FISCAL YEAR 2021-2022, THROUGH DECEMBER 31, 2022 WITH COMPARATIVE ACTUAL AMOUNTS FOR FISCAL YEAR 2020-2021, THROUGH DECEMBER 31, 2021 FAVORABLE FISCAL (UNFAVORABLE) FISCAL FISCAL YEAR FISCAL FISCAL YEAR YEAR 2022-2023 YEAR YEAR 2022-2023 2022-2023 PERCENT 2022-2023 2021-2022 BUDGET ACTUAL RECEIVED VARIANCE ACTUAL $316,189 $81,611 25.81% (234,578) $81,611 $6,359 $0 0.00% (6,359) $0 322,548 $1,611 25.30% (240,937) $1,611 0 1,946 #DIV/0! 1,946 $1,879 316,181 316,181 100.00% (0) $235,221 0 5,870 #DIV/0! 5,870 $6,570 0 1,460 #DIV/0! 1,460 $0 9,713 19,653 202.33% 9,940 $40,686 48,729 0 0.00% (48,729) $0 316,431 160,560 50.74% (155,871) $158,216 115,890 0 0.00% (115,890) $117,757 14,000 7,000 50.00% (7,000) $7,093 22,981 16,813 73.16% (6,168) $18,579 0 373,384 #DIV/0! 373,384 $83,589 $43,925 902,867 106.98% 58,942 669,590 1,166,473 984,478 84.40% (181,995) 751,201 0.00 0 0.00% 0 0.00 0 0.00% 0 0 83,432 105,931 126.97% 22,499 71,334 4,930 1,479 30.00% (G,451) 3,476 88,362 107,410 121.56% 19,048 74,810 TOWN OF WATERFORD STATEMENT OF REVENUES COMPARED TO ANTICIPATED FOR FISCAL YEAR 2021-2022, THROUGH DECEMBER 31, 2022 WITH COMPARATIVE ACTUAL AMOUNTS FOR FISCAL YEAR 2020-2021, THROUGH DECEMBER 31, 2021 FAVORABLE FISCAL (UNFAVORABLE) FISCAL FISCAL YEAR FISCAL FISCAL YEAR YEAR 2022-2023 YEAR YEAR 2022-2023 2022-2023 PERCENT 2022-2023 2021-2022 BUDGET ACTUAL RECEIVED VARIANCE ACTUAL GENERAL GOVERNMENT INTEREST & LIENS 321,563 142,004 44.16% (179,559) 126,244 INTEREST ON INVESTMENTS 110,000 873,966 794,51% 763,966 48,752 RECREATION & PARKS 75,000 160,781 214.37% 85,781 155,176 COMMUNITY USE OF SCHOOLS 0 0 #DIV/0! 0 100 BUILDING INSPECTOR 350,000 396,521 113.29% 46,521 293,785 LICENSE, FEE, PERMIT, FINE 40,159 11,194 27.87% (28,966) 14,100 LIBRARY 0 81 #DIV/0! 81 0 WATER MAIN ASSESSMENTS 0 0 #DIV/0! 0 403 SALE OF VEHICLES 0 683. #DIV/0! 683 0 SALE OF EQUIPMENT 0 5,574 #DIV/0! 5,574 557 NL RADIO COMM. NETWORK USE FEE 72,000 0 0.00% (72,000) 0 ALARM PENALTIES 0 0 #DIv/0! 0 50 BULKY WASTE FEES 70,000 55,979 79.97% (14,021) 60,970 MISCELLANEOUS 69,306 76,983 111.08% 7,677 32,831 CONVEYANCE TAX 200,000 173,832 86.92% (26,168) 247,196 EMS-REG COMM CTR FEES 6,000 1,500 25.00% (4,500) 1,500 SEWER ASSESSMENTS 0 0 #DIV/0! 0 555 PLANNING& ZONING, ZBA, CONSRV COMM 38,500 35,231 91.51% (3,269) 21,709 TOWN CLERK FEES 200,000 T7917 38.96% (122,084) 124,383 LIENS -COLLECTED BY UTILITY COMMISSION 0 2,780 #DIV/0! 2,780 0 TIPPING FEES 200,000 90,834 45.42% (109,166) 107,313 RECYCLING 25,000 35,156 140.62% 10,156 22,221 COST SHARING PRR 0 187,367 #DIV/0! 187,367 83,722 TRANSFERS FROM OTHER FUNDS 0.00 109,159 #DIV/0! 109,159 5,814 TRANSFERS IN-PY ENCUMBRANCES 0 4 #DIV/0! 4 650 EUGENE O'NEILL GATE/LEASE REVENUE 10,000 0 0.00% (10,000) 9,159 AMBULANCE OPERATING SUBSIDY 0 0 #DIV/0! 0 6,000 YSB BOE CLERICAL STIPEND 5,000 5,000 100.00% 0 5,000 RENTAL OF BUILDINGS 75,000 63,009 84.01% (11,991) 60,015 SENIOR SERVICES 10,796 8,140 75.40% (2,656) 22,163 VERSA KART/BLUE BOXES 5,000 4,370 87.40% (630) 6,540 CIRMA MEMEBERS EQUITY DISTRIBUTION 0 0 #DIV/0! 0 96,057 SUB TOTAL 1,883,324 2,518,065 133.70% 634,741 1,552,965 TOTAL OTHER SOURCES 1,971,686 2,625,475 133.16% 653,789 1,627,775 PROPERTY TAXATION CURRENT PROPERTY TAX 95,943,064 77,848,330 81.14% (18,094,734) 75,376,117 PRIOR. YEAR TAXES 300,000 159,859 53.29% (140,141) (29,165) TOTAL PROPERTY TAXATION 96,243,064 78,008,190 81.05% (18,234,874) 75,346,952 TOTAL REVENUES 99,381,223 81,618,143 82.13% (17,763,080) 77,725,928 STATEMENT OF EXPENDITURES COMPARED TO BUDGET FOR FISCAL YEAR 2022-2023, THROUGHDECEMBER 31, 2022 WITH COMPARATIVE ACTUAL AMOUNTS FOR FISCAL YEAR 2021-2022, THROUGH DECEMBER 31, 2021 FISCAL YEAR2023 VARIANCE FISCAL YEAR FISCAL YEAR2023 FISCAL YEAR2023 PERCENT FAVORABLE 2021-2022 APPROPRIATED ACTUAL EXPENDED (UNFAVORABLE) ACTUAL GENERAL GOVERNMENT Board of Selectmen $207,605 $101,331 48.81% 106,274 $123,012 Registrar of Voters $78,204 $60,297 77.10% 17,907 $44,614 Board of Finance $66,673 $69,652 104.47% (2,979) $62,873 Assessor $259,344 $130,666 50.38% 128,678 $210,684 Board of Assessment Appeals $1,620 $314 19.38% 1,306 $375 Tax Collector $210,139 $115,947 55.18% 94,192 $115,303 Finance Department $703,709 $382,895 54.41% 320,814 $400,840 Legal Department $295,000 $114,311 38.75% 180,689 $124,232 Town Clerk $275,739 $175,906 63.79% 99,833 $146,249 Planning and Zoning $657,972 $317,283 48.22% 340,689 $294,493 Building Maintenance $888,781 $449,528 50.58% 439,253 $382,131 Insurance $4,728,672 $1,328,685 28.10% 3,399,987 $1,388,870 Economic Development Commission $27,471 $8,966 32.64% 18,505 $7,328 Conservation Commission $18,250 $1,584 8.68% 16,666 $13,135 Zoning Board of Appeals $4,310 3,016 69.98% 1,294 2,820 Retirement Commission $6,333,067 $3,674,425 58.02% 2,658,642 $3,317,324 R.T.M. $18,903 $14,798 78.28% 4,105 $14,409 Building Department $316,641 $123,633 39.05% 193,008 $113,675 Youth Service Bureau $272,160 $112,839 41.46% 159,321 $150,679 Social Service Grants/Miscellaneous $86,473 $84,251 97.43% 2,222 $78,143 Contingency Fund $261,729 8) 0.00% 261,729 0 Emergency Management $1,068,486 $507 830 47.53% 560,656 $471,170 Fire Services $3,408,420 $2,091,784 61.37% 1,316,636 $2,037,876 Police Department $6,428,214 $3,203,567 49.84% 3,224,647 $3,124,836 Public Works Department $4,709,563 $3,024,282 64.22% 1,685,281 $2,811,029 Conservation of Health $148,126 148,126 100.00% (0) 142,282 Public Health Nursing $26,000 24,000 92.31% 2,000 7,917 Senior Citizens Commission $471,297 218,656 46.39% 252,641 $233,245 Waterford Public Library $999,475 $486,568 48.68% 512,907 $499,929 Page 1 of 2 GENERAL FUND STATEMENT OF EXPENDITURES COMPARED TO BUDGET FOR FISCAL YEAR 2022-2023, THROUGHDECEMBER 31, 2022 WITH COMPARATIVE ACTUAL AMOUNTS FOR FISCAL YEAR 2021-2022, THROUGH DECEMBER 31, 2021 FISCAL YEAR2023 FISCAL YEAR2023 VARIANCE FISCAL YEAR FISCAL YEAR2023 FISCAL YEAR2023 PERCENT FAVORABLE 2021-2022 APPROPRIATED ACTUAL EXPENDED (UNFAVORABLE) ACTUAL Recreation and Parks $1,424,485 $925,533 64.97% 498,952 $834,125 Flood and Erosion Control Bd. $2,138 529 24.76% 1,609 394 Ethics Commission $850 0 0.00% 850 156 Human Resources $259,856 $166,523 64.08% 93,333 $134,684 Information Technology $1,160,391 $760,526 65.54% 399,865 $790,399 Transfer to Waterford Week Activity Fund $4,750 $4,750 100.00% 0 $4,750 Transfer to Waterford Shellfish Fund $1,721 $1,721 100.00% 0 $2,000 Transfer to Capital Improvement Fund $2,987,901 $2,987,901 100.00% 0 $2,964,754 Transfer to Capital & Non-Recurring Fund $3,001,560 $3,001,560 100.00% 0 $2,700,600 Transfer to Dog Fund $60,000 $60,000 100.00% 0 $60,000 Debt Service $7,197,640 $5,447,016 75.68% 1,750,624 $6,121,316 Total General Government $49,073,335 $30,331,199 61.81% $18,742,136 $29,932,651 Board of Education $52,109,124 $19,052,493 36.56% 33,056,631 $20,007,955 Total General Fund $101,182,459 $49,383,692 48.81% $51,798,767 $49,940,606 TOWN OF WATERFORD STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE FLEET MANAGEMENT FUND AS OF DECEMBER 31, 2022 Revenues: Investment Income State of Connecticut Grants Vehicle Rentals Sale of Vehicles Total Revenues Expenditures: Equipment Replacement Vehicle Replacement Total Expenditures Excess (Deficiency) of Revenues Over Expenditures Other Financing Sources (Uses): Transfers from other funds Total Other Financing Sources (Uses) Net Change in Fund Balances Fund Balances - Beginning Fund Balances - Ending 53,906 52,000 40,888 20,174 166,968 345,620 916,772 1,262,392 (1,095,424) 800,000 800,000 (295,424) 3,159,442 2,864,019 Insurance Administration Fund Balance Sheet December 31, 2022 Assets Cash and Cash Equivalents 1,987,191 Due From Other Funds 28,541 1 Total Assets 2,015,732 Liabilities Accrued Liabilities (IBNR) 1,085,000 Advance Payments 28,185 Total Liabilities 1,113,185 Net Assets Unrestricted $902,546 Total Net Assets $ $902,546 1) Healthcare entry for FY23 is not posted yet FIFTEEN ROPE FERRY ROAD PHONE: 860-442-0553 WATERFORD, CT 06385-2886 www.waterfordct.org Date: = December 13, 2022 To: Members of the Board of Finance From: The Town Accountant Subject: Status of Contingency Fiscal Year 2023 Contingency Fund, Line item 10121-59010: 07/01/22 Appropriation 265,000 Transferred through 12/06/22 (3,271) Balance 261,729 Virginia Bidlucki Page 1 FISCAL YEAR 2022-2023 CONTINGENCY TRANSFERS & BALANCE BOARD “TRANSFER ORG OBJECT DESCRIPTION OF FINANCE RTM AMOUNT BALANCE BALANCE 07/01/22 $265,000.00 10138 55898 TRANSFER OUT TO CURRENT YEAR CAPYTAL-DE-ESCALATION& COMMUNICATION TECHNOLOGY 7/20/2022 N/A $775.00 $264,225.00 10138 55807 TRANSFER OUT TO CURRENT YEAR CAPITAL-CELL BENCH SAFETY OVERLAY 9/7/2022 N/A $2,496.00 $261,729.00 ($3,271.00) $261,729.00 Page 2 FIFTEEN ROPE FERRY ROAD WATERFORD, CT 06385-2886 To: Board of Finance Members F From: Town Accountant WA Date: January 19, 2023 Subject: Status of General Fund Unassigned Balance Unassigned Fund Balance: Unassigned balance 06/30/22 23,004,117 Applied as additional appropriations through 12/31/22 (1,801,236) Projected revenues in excess of (less than) budgeted through 12/31/22 2,627,674 Estimated Ending Unassigned Balance 23,830,555 PHONE: 860-442-0553 www.waterfordct.org