2022-23 Fiscal Year Treasurer’s Report For the Month Ending May 31, 2023 Prepared By: Lori Schreiber, Treasurer Brian Freeman, Assistant Superintendent for Business
1
❏ 3rd quarter (Monroe County 1st Quarter) sales tax arrived and on target for a typical amount ❏ One of the last state aid payments arrived for general aid purposes ❏ Interest from investments that were up this month have been realized in the general fund ❏ Small state reimbursements for school lunch fund, but sales from vending commissions picked up this month ❏ No revenue into the capital fund since we have not had a borrowing this month ❏ Federal fund had limited (Wondercare) revenue activity Appropriations: ❏ General fund expenditures are typical once again, except BOCES is trending higher as year end purchasing for technology/software renewals are part of this month ❏ School lunch food purchases are dwindling as we utilize available products to prevent waste ❏ April break saw punch list items get completed in many buildings which correlates to finishing out contract payments this month for many of the construction contractors so you will notice a month to month increase in payments for the capital fund project ❏ Minimal activity across the federal funds for all grant purposes Cash Flow: ❏ Cash flow down as expected as it is a low revenue month and we approach the end of the fiscal year-revenue slows ❏ Cash flow position on par with last years at this time of the fiscal year Miscellaneous: ❏ Investing in three banks at this time ❏ GRB is a general savings account ❏ NYCLASS investments for a third month due to high rates continuing to beat traditional local banks CD’s and money market accounts ❏ TD Bank continues to have excellent rates for its online only customers so a bulk of our investments remain there 2
Webster Central School Treasurer's Report May 31, 2023 Month of March General Fund Balance at Beginning of Month Receipts Balance plus Receipts Disbursements Balance at End of Month
-$3,650,197.20 $29,787,149.57 $26,136,952.37 $18,718,500.88 $7,418,451.49
School Lunch Fund Balance at Beginning of Month Receipts Balance plus Receipts Disbursements Balance at End of Month
$129,585.33 $578,691.03 $708,276.36 $408,715.17 $299,561.19
Federal Fund Balance at Beginning of Month Receipts Balance plus Receipts Disbursements Balance at End of Month
$21,749.33 $490,476.02 $512,225.35 $378,425.09 $133,800.26
Capital Fund Balance at Beginning of Month Receipts Balance plus Receipts Disbursements Balance at End of Month
$1,369,533.60 $2,691.32 $1,372,224.92 $862,633.07 $509,591.85
Community Ed Balance at Beginning of Month Receipts Balance plus Receipts Disbursements Balance at End of Month
$157,129.44 $14,288.13 $171,417.57 $2,994.77 $168,422.80
General Reserves Balance at Beginning of Month Receipts Balance plus Receipts Disbursements Balance at End of Month
$13,956,549.86 $29,463.15 $13,986,013.01 $10,000,000.00 $3,986,013.01
General Fund May 2023 Receipts
Disbursements
Tax Levy
Personnel Costs Webster
Instructional Salaries
$7,186,099.92
Penfield
Non- Intructional Salaries
$1,961,017.29
Ontario
ERS
$212,252.20
Walworth
TRS
$706,728.77
FICA
$671,869.84
Sub Total
$0.00
Worker's Compensation
Sales Tax Monroe Wayne Sub Total
$9,837.61
Health Benefits
$2,312,711.39
Dental Benefits
$144,082.21
$2,611,195.32 $4,799.46 Sub Total Personnel Costs
$13,204,599.23
$2,615,994.78 Instructional Materials
Other Tax Items
Equipment
$773,778.66
STAR
Supplies
$395,809.10
PILOTS
Textbooks
$14,808.17
Contractuals
$364,509.63
Sub Total
$0.00
Sub Total Instructional Materials
$1,548,905.56
State Aid Categories Gen Aid
$6,160,567.67 Energy Expenses
Lottery Aid Other
445/443 444 Electric
$139,241.47
BOCES
442 Natural Gas
$27,777.95
Textbook
446 Water
$12,640.43
Computer Software
441 Fuel
Homeless
Sub Total Energy
$8,367.33 $188,027.18
ESSR/GEER Sub Total
$6,160,567.67 BOCES
$1,905,262.14
Other Revenues Interest
$621,644.96
Medicaid
$43,035.55 Subtotal
Aquatic Center/Community Ed
$21,541.68
$1,905,262.14
Student Deposits Health Services Misc
Sub Total Total Monthly Receipts
$3,143.78 Debt Service &Transfers
$689,365.97 Sub Total Debt $9,465,928.42 Monthly Disbursements
$0.00 $16,846,794.11
School Lunch (C) May 2023 Receipts
Disbursements
Reimbursable Meals
Personnel Costs Breakfast
Non- Intructional Salaries
$136,789.09
Lunch
ERS
$12,962.93
Ala Carte
TRS
Adult
FICA/MED
$10,125.72
Worker's Compensation
$56,670.71
Health Benefits
$15,508.59
Dental Benefits
$628.25
Sub Total
$0.00
State Breakfast
Jan-April
$3,450.00
Lunch
Jan-April
$16,545.00
Snack Sub Total
Sub Total Personnel Costs
$0.00
$232,685.29
Food Purchases $19,995.00
Food Purchases
$60,806.55
Milk/Juice Federal Program
Produce Breakfast
Snack/Drinks
Lunch
Meats/Proteins
Snack
Gov't Commodities
Surplus
Other
$1,491.79
PBT Sub Total
$0.00
Other Revenues
Sub Total
$62,298.34
Other Expenses Commissions
$13,048.49
Equipment/Repairs
$862.26
Catering
$17,830.25
Contractuals
$492.78
Supplies
$12,868.06
Concessions Interest
$498.28
Miscellaneous
$0.00
Misc Pre-payments Sub Total
Sub Total
$14,223.10
Monthly Disbursements
$309,206.73
$31,377.02
Interfund Transfer Total Monthly Receipts
$51,372.02
Capital May 2023 Receipts
Disbursements
69.5 December 2018 Project Interest
$2,691.32
Architect/Clerk
$73,342.80
Asbestos Monitoring Sub Total
$2,691.32
Survey & Engin Contractual/Incidentals
$409.00
Legal Equipment Sub Total
$53,157.50 $126,909.30
69.5 December 2018 Project General Contract
$90,326.75
Plumbing Contract
$129,317.80
Mechanical Contract
$17,213.59
Electrical Contract
$169,398.50
Site Contract Sub Total
$406,256.64
Bus Purchase
Sub Total
$0.00
Capital Outlay Project
$0.00
BOCES Project
$0.00
Other Revenues
Sub Total Total Monthly Receipts
$0.00 $2,691.32
Monthly Disbursements
$533,165.94
Federal (Special Aid) Fund (F) May 2023 Receipts
Disbursements
Federal Grants
Federal Grants Title I
Title I
Title II
Title II
Title III
Title III
Title IV
Title IV
Title V
Title V
CRSSA Grant
CRRSA ESSR Grant
ARP
ARP
IDEA 611
IDEA 611
$3,209.24
IDEA 619
IDEA 619
$10,799.19
HWB
School for the Deaf
$31,609.80
$2,625.89
$69,003.64
ESY Sub Total
$0.00
State Grants
Sub Total
$117,247.76
State Grants Teacher Center
Teacher Center
UPK
UPK
Other Sub Total
$5,966.09
4201/Deaf $0.00
Continuing Education Programs
Sub Total
$5,966.09
Continuing Education Programs Registrations
$78,252.12
Salaries
Equipment
Contractual
Supplies
Supplies
Contractuals Sub Total
$104,661.45
Refunds $78,252.12
Other Grants/Donations
Sub Total
$104,661.45
Other Grants/Donations Cultural Arts
Cultural Arts
Other
BOCES Other
Interest
$4,246.84
$823.69
Sub Total
$823.69
Sub Total
$4,246.84
Monthly Receipts
$79,075.81
Monthly Disbursements
$232,122.14 $0.00
Webster Central School District 2022-23 Fund Balance Summary Reserved Fund Balance
July
April
May
555,759)
$555,759
$555,759
$555,759
$555,759
$3,312,205
$3,316,035
$3,318,008
$3,319,980
$3,320,145
$3,322,469
$1,031,798
$1,032,991
$1,033,606
$1,034,220
$1,034,272
$1,034,996
$8,780,831
$8,790,386
$8,800,550
$8,805,786
$8,811,021
$8,811,459
$8,817,626
$2,814,541
$2,817,881
$2,820,947
$2,824,209
$2,825,889
$2,827,569
$2,827,710
$2,829,689
$4,159,309
$4,161,520
$4,166,459
$4,170,992
$4,175,815
$4,178,299
$4,180,784
$4,180,991
$4,183,917
$4,028,104
$4,028,123
$4,030,264
$4,035,047
$4,039,437
$4,044,108
$4,043,631
$4,046,514
$4,049,121
$4,051,955
($ 10,633,958)
$10,634,234
$10,634,284
$10,639,937
$10,652,564
$10,664,155
$10,676,486
$10,682,838
$10,689,189
$10,689,720
$10,697,202
Debt Service Reserve
($
3,155,966)
$3,157,539
$3,157,554
$3,158,836
$3,161,303
$3,162,277
$3,165,939
$3,165,939
$3,321,676
$3,320,145
$3,322,469
Unemployment Insurance Reserve
($
1,212,950)
$1,212,981
$1,212,987
$1,213,632
$1,215,072
$1,216,394
$1,217,801
$1,218,525
$1,219,250
$1,219,310
$1,220,163
Reserve for Encumbrances
($
Liability Reserve
($
3,302,826)
Employee Benefit Accrued Liability Reserve
($
1,028,877)
Retirement Contribution Reserve
($
TRS Sub Reserve
August 555,759) ($
September
October
November
555,759)
$555,759
$555,759
$3,302,912
$3,302,927
$3,304,683
$3,308,605
$1,028,903
$1,028,908
$1,029,455
$1,030,677
8,765,494)
$8,765,721
$8,765,763
$8,770,423
($
2,812,959)
$2,813,032
$2,813,046
Tax Certiorari Reserve
($
4,159,181)
$4,159,289
Worker's Compensation Reserve
($
4,027,999)
Capital Reserve
Total Reserved Fund Balance:
555,759) ($
December $555,759 ($
January
February
March
($ 39,655,970)
$39,658,474 ($ 39,658,661) ($ 39,679,050) ($ 39,724,197) ($ 39,764,351) ($ 39,809,694) ($ 39,828,280) ($ 40,005,962) ($ 40,008,632) ($ 40,036,245) ($
Appropriated
($
5,500,000)
$5,500,000 ($
5,500,000)
$5,500,000
$5,500,000
$5,500,000
$5,500,000
$5,500,000
$5,500,000
$5,500,000
$5,500,000
Unappropriated/Unassigned
($
6,251,482)
$6,251,482
$6,250,283
$6,229,497
$6,183,068
$6,140,446
$6,095,104
$6,071,749
$6,048,395
$6,048,394
$6,018,931
June
-
)
Unreserved Fund Balance
Total Fund Balance
($ 11,751,482)
$11,751,482 ($ 11,750,283) ($ 11,729,497) ($ 11,683,068) ($ 11,640,446) ($ 11,595,104) ($ 11,571,749) ($ 11,548,395) ($ 11,548,394) ($ 11,518,931) ($
-
)
($ 51,407,452)
$51,409,957 ($ 51,408,944) ($ 51,408,547) ($ 51,407,265) ($ 51,404,798) ($ 51,404,798) ($ 51,400,029) ($ 51,554,357) ($ 51,557,026) ($ 51,555,177) ($
-
)
Total Budget
$195,813,457
July 2022
General Fund
August 2022
September 2022 October 2022 November 2022 December 2022 January 2023 February 2023
March 2023
April 2023
May 2023
June 2023
Monthly $1,248,147
$119,501
$14,368,192
$52,001,092
$3,355,032
$4,981,385
$966,814
$1,578,895
$7,231,714
-$3,650,197
$7,418,451
Comm General Fund
$385,689
$37,142
$32,464
$32,745
$34,693
$84,929
$95,949
$106,532
$151,593
$157,129
$168,423
School Lunch Fund
$106,555
$68,557
$138,964
$298,887
$409,255
$166,106
$457,416
$333,559
$119,130
-$10,471
$299,561
Capital Fund
$64,716
$36,416
$1,222,719
$3,642,339
$3,020,602
$69,031
$272,329
$2,682,012
$1,834,646
$1,040,166
$299,561
Federal
$158,658
$149,377
-$5,520
$1,100,247
$1,317,049
$1,543,058
$1,584,570
-$9,792
-$61,725
-$129,216
$133,800
Trust and Agency
$229,242
$21,856
$221,762
$121,126
$206,675
$606,530
$519,891
$0
$0
$0
$0
$2,541,460
$541,825
$542,012
$11,557,719
$16,591,670
$10,130,823
$10,169,293
$2,887,337
$14,003,258
$13,956,550
$3,986,013
Reserves Payroll CD's/Treasury Bills
Ending Total:
$71,084
$72,379
$73,176
$77,104
$76,010
$79,107
$81,028
$0
$0
$0
$0
$12,914,521
$7,937,375
$4,941,485
$4,941,485
$50,941,485
$46,000,000
$41,000,000
$36,000,000
$36,000,000
$36,000,000
$26,000,000
$17,720,072
$8,984,428
$21,535,254
$73,772,744
$75,952,472
$63,660,969
$55,147,290
$43,578,543
$59,278,616
$47,363,961
$38,305,810
$0
Summary of Investments Reserve Savings
Bank
Maturity
GRB
Interest Rate
# of Days
Amount
3.75%
$394,230
CD
TD Bank
6/2/2023
5.18%
30
$16,000,000
CD
TD Bank
6/2/2023
5.18%
30
$10,222,830
Savings
NYCLASS
4.72%
30
$3,591,783
Totals
$30,208,843