August 2022

TOWN OF WATERFORD
CAPITAL IMPROVEMENT FUND
EXPENDED! PERCENT TRANSFERS
ACCOUNT DEPT/YEAR DESCRIPTION APPROPRIATED ENCUMBERED BALANCE EXPENDED OUT
30123-55788 BOS FY23 FLEET MANAGEMENT PLAN 800,000.00 800,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 24%
31118-55803 BLDG MAINT FY18 PARKING LOT -YSB/POLICE 195,320.06 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%
31121-55852 BLDG MAINT FY21 TOWN HALL BATHROOMS 25,000.00 0.00 25,000.00 0.0%
31122-55819 BLDG MAINT FY22 UST REPLACEMENT 250,000.00 69,000.00 181,000.00 27.6%
81122-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 2,350.00 58,417.64 3.9%
81122-57857 BLDG MAINT FY22 CIVIC TRIANGLE UPGRADES 150,000.00 149,140.00 860,00 99.4%
31123-55903 BLDG MAINT FY23 FISH LADDER REPAIR 16,000.00 0.00 16,000.00 0.0%
81123-55904 BLDG MAINT FY23 UST REPLACEMENT EUGENE O'NEILL 260,000.00 0.00 260,000.00 0.0%
31123-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 0.00 246,209.00 0.0%
32323-55900 FIRE SERVICES FY28 COHANZIE EMERGENCY GENERATOR 55,000.00 0.00 55,000.00 0.0%
82920-55846 POLICE DEPT FY20 PD POLICY DIRECTIVES REVAMP 30,000.00 30,000.00 0.00 100.0%
82920-55859 POLICE DEPT FY20 POLICE BLGD ARCHITECTURAL PLAN 15,000.00 0.00 15,000.00 0.0%
32922-55876 POLICE DEPT FY22 CYBER CRIME TASK FORCE EQUIPME 11,000.00 9,452.51 1,547.49 85.9%
82922-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 52,750.00 (14,250.00) 137.0%
32923-55897 POLICE DEPT FY23 CELL BENCH SAFETY OVERLAY 17,100.00 0.00 17,100.00 0.0%
32923-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%
33021-55867 PUBLIC WORKS FY21 REMOVE UST COHANZIE FIRE 299,000.00 365,423.78 (66,423.78) 122.2%

CAPITAL IMPROVEMENT FUND
AUGUST 31, 2022
ACCOUNT
DEPT/YEAR
DESCRIPTION
38022-55883
PUBLIC
WORKS
FY22
33022-55884
PUBLIC
WORKS
FY22
33022-55885
PUBLIC
WORKS
FY22
33022-55886
PUBLIC
WORKS
FY22
33022-55889
PUBLIC
WORKS
FY22
83022-55891
PUBLIC
WORKS
FY22
33023-55890
PUBLIC
WORKS
FY23
33023-55902
PUBLIC
WORKS
FY23
33120-55821
UTILITY
COMM
FY20
33122-55870
UTILITY
COMM
FY22
83122-55894
UTILITY
COMM
FY22
33122-55895
UTILITY
COMM
FY22
33123-55895
UTILITY
COMM
FY23
33123-55906
UTILITY
COMM
FY23
33719-55835
REC
&
PARKS
FY19
33722-55896
REC
&
PARKS
FY22
WILLIAM ST CONCRETER SIDEWALK
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
LEARY PARK IRRIGATION
VETERAN'S FIELD IRRIGATION SYS
TOWN HALL BASKETBALL COURT REP
EQUIPMENT STORAGE PLAN
TOTALS
PRIOR YEAR EXPENDITURES
CURRENT YEAR EXPENDITURES
42,300.00
69,800.00
106,548.06
219,300.00
325,915.00
120,000.00
30,000.00
50,000.00
50,000.00
21,000.00
EXPENDED/ PERCENT TRANSFERS
ENCUMBERED BALANCE EXPENDED out
9,567.78
32,732.22
22.6%
106,323.10
224,90
99.8%
119,370.00
630.00
99.5%
2,660,180.88 8,671,888.26 41.9% 800,000.00
1,126,211.08

CAPITAL AND NON-RECURRING EXPENDITURE FUND
FUND BALANCE AND APPROPRIATION
20501-57639
REVALUATION
20511-67856
JORDAN
VILLAGE
SIDEWALKS
20502-48043
JORDAN
VILLAGE
SIDEWALK
GRANT
20511-67871
PUBLIC
SAFETY
BLDG
HVAC
20511-57875
TEMP
OIL
TANK
EUGENE
O'NEILL
20507-69206 FUNDING OFFSETS FY18 DEBT SERVICE-OSWEGATCHIE FIRE
20523-57826
FIRE
SERVICES
HYDRAULIC
EQUIPMENT
20507-59205: FUNDING OFFSETS DEBT SERVIGE-MUNICIPAL COMPLEX
20530-57832 LED STREETLIGHT CONVERSION
20530-57868 BRIDGE ENGINEERING PLAN
20530-57877
RESURFACE
ROADS
LAKE
PONDS
ETC
20600-49000: CT PUBLIC LIBRARY CONSTRUCTION GRANT
20537-57735 LEARY PARK ROAD /PARKING LOT
APPROPRIATED DESIGNATED UNDESIGNATED TOTAL
($119,993.22)
$332,700.00
$0.00
$212,706.78
$20,715.00 $100,000.00 $0.00 $120,715.00
$49,800.00 $0.00 $0.00 $49,800.00
$41,275.00
$0.00
$0.00
$41,275.00
$80,239.95 $0.00 $0.00 $80,239.95
$0.00 $280,000.00 $0.00 $280,000.00
$0.53 $0.00 $0.00 $0.53
$29,885.61
$0.00
$0.00
$29,886.61
$0.00 $400,000.00 $0.00 $400,000.00
$0.00
$62,045.00
$0.00
$62,046.00
$186,363.00 $0.00 $0.00 $186,363.00
$35.00 $0.00 $0.00 $35.00
$1,094.28 $0.00 $0.00 $1,094.28
$117,500.00
$0.00
$0.00
$117,500.00
$0.00 $740,165.00 $0.00 $740,165.00
$500.00 $2,990,000.00 $0.00 $2,990,500.00
$213,700.00 —_—-$0.00 $0.00 $213,700.00
“$0.00
($3,000,000.00)
$0.00
($3,000,000.00)
$28,688.25
$0.00
$0.00
$28,688.25
$0.00 $25,000.00 $0.00 $25,000.00
($0.00) $19,000.00 $0.00 $19,000.00
$0.00 $30,000.00 $0.00 $30,000.00
$0.00 $50,000.00 $0.00 $50,000.00
$354,971.07 $6,100,833.00 $0.00 $6,455,804.07
($1,251,500.00)°.
-
.($6,000,000.00)
$0.00
($7,251,500.00)
$4,370.23 $0.00 $0.00 $4,370.23
$16,125.54
$0.00
$0.00
$16,125.54
$0.00 $35,000.00 $0.00 $35,000.00
$0.00 $35,000.00 $0.00 $35,000.00
$0.00 $20,000.00 $0.00 $20,000.00
$980,215.00 $0.00 $0.00 $980,215.00
$19,422.12 $0.00 $0.00 $19,422.12
$310,985.86 $0.00 $0.00 $310,985.86
$0.00 $43,000.00 $0.00 $43,000.00
$5,438.00
$544,000.00
$0.00
$649,438.00
$30.10
$85,000.00
$0.00
$85,030.10
$0.00 $1,091,200.00 $0.00 $1,091,200.00
$0:00
($260,000.00)
$0.00
($250,000.00)
$0.00
$20,000.00
$0.00
$20,000.00
Pagel

20537-57854 WTFD BEACH PARK IMPROVEMENTS
20560-57828
QH
10-YR
RETRO
COMMISSIONING
20560-57841
BUS
LOT
OFFICE
20560-57842
SCHOOL
SECURITY
CAPITAL AND NON-RECURRING EXPENDITURE FUND
FUND BALANCE AND APPROPRIATION
APPROPRIATED
DESIGNATED
UNDESIGNATED
TOTAL
$0.00
$30,000.00
$0.00
$30,000.00
$0.00
$37,500.00
$0.00
$37,500.00
$0.33
$1,585.00
$0.00
$1,585.33
$5,380.00
$22,620.00
$0.00
$28,000.00
$0.00
$85,000.00
$0.00
$85,000.00
$0.00
$4,815.00
-
$0.00
$4,815.00
$15,074.80
$438,067.88
$0.00
$453,142.68
$0.00
$30,000.00
$0.00
$30,000.00
$0.00
$150,000.00
$0.00
$150,000.00
$32,175.00
$0.00
$0.00
$32,175.00
$0.00
$0.00
$2,722,614.86
$2,722,614.86
$1,246,180.45
$4,623,088.88
$2,722,614.86
$8,591
,884.19

Insurance
Administration Fund
Balance Sheet
August 31, 2022
Assets
Cash and Cash Equivalents 5,976,350
Accounts Receivable 262
Total Assets 5,976,612
Liabilities
Accrued Liabilities (IBNR) 605,346 1)
Due to other funds 182,969 2)
Advance Payments 26,139
Total Liabilities 814,454
Net Assets
Unrestricted $5,162,158
Total Net Assets $ $5,162,158
1) IBNR for FY22 is not posted yet
2) Healthcare entry for FY23 is not posted yet

TOWN OF WATERFORD
STATEMENT OF REVENUES, EXPENDITURES,
AND CHANGES IN FUND BALANCE
FLEET MANAGEMENT FUND
AS OF AUGUST 31, 2022
Revenues:
Investment Income
State of Connecticut Grants
Vehicle Rentals
Sale of Vehicles
Sale of Equipment
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
11,088
52,000
7,950
13,390
1,632
86,060
273,659
817,380
1,091,039
(1,004,979)
800,000
800,000
(204,979)
3,157,810
2,952,831

TOWN OF WATERFORD
CAPITAL PROJECTS FUNDS
AUGUST 31, 2022
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 Q.00

Contributed
Gifts
Fund
Fund
#
212
AUGUST
31,
2022
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
FIELD
PRESS
DEPT.
RODEO
GENERAL
BENCHES
MEMORIAL
DOG
PARK
PLAYGROUND
MEMORIAL
BOX
AUDITORIUM
FISCAL
YEAR
2023
DONATIONS
|
DONATIONS
|
DONATIONS
|
DONATIONS
_|_DONATIONS
DONATIONS
DONATIONS
DONATIONS
AsV
UPGRADE
REVENUES
K9
DONATIONS
POLICE
DEPT,
GENERAL
DONATIONS
[LOTAL
REVENUES
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
EXPENDITURES
07/15/22
HOELCK’S
FLORIST
08/04/22
JP
MORGAN
CHASE
08/04/22
JP
MORGAN
CHASE
08/18/22
KUSTOM
SIGNALS
PURCHASE
ORDER
08/19/22
RBIMB
FLANNAGAN
-VET
CARE
08/16/22
BARCO
-MEMORIAL
BENCH
PURCHASE,
ORDER
$840.00
[TOTAL
EXPENDITURES
$0.00
$0.00
$840.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
[NET
CURRENT
YEAR
ACTIVITY
$0.00|
$0.00|
($840.00)
$0.00|
$0.00|
$0.00|
$0.00|
$0.00|
$0.00|
[PRIOR
YEAR
BALANCE
$4,258.47|
$29.60|
$1,251.39|
$65.00|
$725.97
|_
$50,486.32|
31,140.00|
$12,600.00|
$152.00
[CURRENT
YEAR
BALANCE
$4,258.47|
$29.60|
$411.39|
$65.00|
$725.97|
$50,486.32|
$1,140.00|
$12,600.00|
$151.00
|
Page
1
of2

Contributed Gifts Fund
Fund # 212
AUGUST 31, 2022
POLICE POLICE POLICE POLICE POLICE
DEPT. DEPT. DEPT. PUBLIC
AUSTISM VEHICLE K-9 GENERAL SAFETY
FISCAL YEAR 2023 TRAINING | CHALLENGE PROGRAM | DONATIONS DOCK TOTAL
REVENUES
K9 DONATIONS $1,000.00
POLICE DEPT. GENERAL DONATIONS $7,563.68
[TOTAL REVENUES 30.00 $0.00 $1,000.00 $7,563.68 $0.00 $8,563.68
EXPENDITURES
07/15/22 HOELCK'S FLORIST $148.84
08/04/22 JP MORGAN CHASE $194.10
08/04/22 JP MORGAN CHASE $1,130.00
08/18/22 KUSTOM SIGNALS PURCHASE ORDER $2,737.63
08/19/22 REIMB FLANNAGAN -VET CARE $48.78
08/16/22 BARCO -MEMORIAL BENCH PURCHASE ORDER
[TOTAL EXPENDITURES $0.00 $0.00 $242.88 $4,016.47 $0.00 $5,099.35
[NET CURRENT YEAR ACTIVITY | $0.00 | 30.00 | $757.12 | $3,547.21 | $0.00 [ $3,464.33 |
PRIOR YEAR BALANCE | $1,700.00 | $780.11 | $5,889.68 | $12,153.55 | $7.04 | $91,238.13 |
[CURRENT YEAR BALANCE | $1,700.00 $780.11 | $6,646.80 | $15,700.76 | $7.04] $94,702.46 |
Page 2 of 2