General Fund May, 2022 Receipts
Disbursements
Tax Levy
Personnel Costs Webster
Instructional Salaries
$6,381,514.80
Penfield
Non- Intructional Salaries
$1,775,813.50
Ontario
ERS
$175,260.54
Walworth
TRS
$530,044.69
Pilot Payments
FICA
$511,463.12
Sub Total
$0.00
Worker's Compensation Health Benefits
$2,328,307.77
Dental Benefits
$116,935.77
Sub Total Personnel Costs Sub Total
$11,819,340.19
$0.00 Instructional Materials
Other Tax Items Sales Tax Monroe/Wayne
$2,474,577.55
PILOTS Sub Total
$2,474,577.55
Equipment
$73,252.86
Supplies
$272,377.52
Textbooks
$50,692.49
Contractuals
$276,953.59
Sub Total Instructional Materials
$673,276.46
State Aid Categories Gen Aid
$5,283,703.18 Energy Expenses
Lottery Aid Tuition
445/443 444
Electric
$106,511.46
BOCES
442
Natural Gas
$36,434.00
Textbook/Software
446
Water
$15,310.34
Excess Cost
441
Fuel
Other Aid
Sub Total Energy
Sub Total
$20,782.74 $179,038.54
$5,283,703.18 BOCES
$1,549,682.75
Other Revenues Interest
$2,261.53
Medicaid
$31,281.30 Subtotal
$1,549,682.75
Refund of Prior Year Facility Rentals
$19,660.59
Health Services
Puchase of T Bills
Misc
$8,654.13 Debt Service
Due to Federal/SL
$971,700.00 Transfer
$7,500,000.00
Transfers Sub Total
$1,033,557.55 Sub Total Debt
$7,500,000.00
Total Monthly Receipts
$8,791,838.28 Monthly Disbursements
$21,721,337.94
Acct x6378 Balance per Bank less outstanding checks
Acct x6378 $9,383,632.84 $530,816.25
Demand Check/Deposit in trans In trans Ending Balance
Beginning Balance
($ 21,782,226.02)
Receipts
$8,791,838.28
Disbursements
$21,721,337.94
Balance
$8,852,726.36
$90.23 $8,852,726.36
$0.00
May 2022 Receipts
Disbursements
Reimbursable Meals
Personnel Costs Breakfast
$5,853.00
Non- Intructional Salaries
$91,143.27
Lunch
$5,789.00
ERS
$7,468.09
Ala Carte
TRS
Adult Sub Total
FICA/MED $11,642.00
State Breakfast
$6,602.87
Worker's Compensation Health Benefits
$15,914.69
Dental Benefits
$576.90
Sub Total Personnel Costs
$121,705.82
Lunch Snack Sub Total
Food Purchases $0.00
Federal Program Breakfast
Food Purchases
$91,267.38
Milk/Juice
$32,255.82
Produce
$366.17
Snack/Drinks
$13,916.30
Lunch
$40,300.08
Meats/Proteins
Snack
$2,727.00
Gov't Commodities
Surplus SCA Sub Total
Other $161,026.00 $204,053.08
Other Revenues
Sub Total
$137,805.67
Other Expenses Commissions
$5,999.66
Equipment/Repairs
$1,722.16
Catering
$10,824.25
Contractuals
$1,996.31
Supplies
$22,358.04
Concessions Interest
$33.64
Miscellaneous
Misc Pre-payments Sub Total
Cash Transfers $42,858.73
Sub Total
$26,076.51
Monthly Disbursements
$285,588.00
$59,716.28
Interfund Transfer Total Monthly Receipts
$275,411.36
Aid payment Due From Gen
Balance per Bank
$229,805.49
Beginning Balance
$190,637.94
less outstanding checks
-$49,394.19
Receipts
$275,411.36
Heartland Deposit
$50.00
Disbursements
$285,588.00
Ending Balance
$180,461.30
Balance
$180,461.30
$0.00
Capital May 2022 Receipts
Transfers
Disbursements
$2,100,000.00 69.5 December 2018 Project
Interest
$135.85
Architect/Clerk
$64,417.04
Asbestos Monitoring Sub Total
$2,100,135.85
Survey & Engin
$3,867.00
Contractual/Incidentals
$93,859.65
Legal Equipment
$72,941.00
Sub Total
$235,084.69
69.5 December 2018 Project General Contract
$1,769,754.32
Plumbing Contract Mechanical Contract Electrical Contract Site Contract Sub Total
$1,769,754.32
Klem North 100k
Sub Total
$0.00
BOCES Project
Other Revenues
Sub Total
$0.00
Total Monthly Receipts
$2,100,135.85 Monthly Disbursements
$2,004,839.01
Balance per Bank
$597,927.53
Beginning Balance
$170,344.97
less outstanding checks
-$332,285.72
Receipts
$2,100,135.85
Ending Balance
$265,641.81
Disbursements
$2,004,839.01
Balance
$265,641.81
$0.00
General Fund (A) Reserves (GRB) May 2022 Receipts
Disbursements
Account x2260 Interest Earned
$1,484.82
Transfers from General for HSA
HSA Withdrawl Transfer for Cash Flow
Deposit from General
$9,000,000.00
From Sweep
$52.87 $9,001,537.69
$0.00
Account x2260
Interest Earned
$51.16
Transfers from General for HSA
Sweep to x260
$51.16
$52.87
$52.87
Beginning Balance
$2,288,604.23
Beginning Balance
$249,052.87
Receipts
$9,001,537.69
Receipts
$51.16
Disbursements
$0.00
Disbursements
$52.87
Balance
$11,290,141.92
Balance
$249,051.16
Acct 260/ICS
Acct 2260/GRB
$11,539,193.08
Federal (Special Aid) Fund (F) May 2022 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
IDEA 619
IDEA 619
$244,738.28
School for the Deaf ESY Sub Total
$0.00
State Grants
Sub Total
$244,738.28
State Grants Teacher Center
Teacher Center
UPK
UPK
Other Sub Total
4201/Deaf $0.00
Continuing Education Programs
Sub Total
$0.00
Continuing Education Programs Registrations
$80,191.04
Salaries
Equipment
Contractual
Supplies
Supplies
Contractuals
Refunds
Sub Total
$80,191.04
Other Grants/Donations
Sub Total
$77,507.65 $4,862.02 $82,369.67
Other Grants/Donations Cultural Arts
Cultural Arts
Solofest
BOCES
Other/Transfer
Other
Interest Sub Total
$0.00
Monthly Receipts
$80,191.04
Sub Total
$0.00
Monthly Disbursements
$327,107.95 $0.00
Balance per Bank
$337,206.01
less outstanding checks
-$18,999.16
Beginning Balance Receipts
$80,191.04
Ending Balance
$318,206.85
Disbursements
$327,107.95
Balance
$318,206.85
$565,123.76
Webster Central School District 2021-22 Fund Balance Summary Reserved Fund Balance
July
April
May
686,121)
$686,121
$686,121
$686,121
$686,121
$1,802,421
$1,802,489
$1,802,505
$1,802,587
$1,802,624
$1,802,727
$1,028,646
$1,028,684
$1,028,694
$1,028,740
$1,028,761
$1,028,820
$7,763,445
$7,763,750
$7,764,043
$7,764,112
$7,764,465
$7,764,625
$7,765,068
$1,812,367
$1,812,481
$1,812,552
$1,812,621
$1,812,637
$1,812,719
$1,812,756
$1,812,860
$3,657,976
$3,657,987
$3,658,216
$3,658,359
$3,658,498
$3,658,531
$3,658,697
$3,658,772
$3,658,981
$3,026,926
$3,027,002
$3,027,011
$3,027,200
$3,027,319
$3,027,433
$3,027,460
$3,027,598
$3,027,660
$3,027,833
6,631,563)
$6,631,805
$6,631,972
$6,631,990
$6,632,406
$6,632,666
$6,632,917
$6,632,976
$6,633,277
$6,633,414
$6,633,594
($
3,155,966)
$3,156,081
$3,156,329
$3,156,054
$3,156,624
$3,156,748
$3,156,867
$3,156,974
$3,157,104
$3,157,248
$3,157,284
($
1,212,475)
$1,212,520
$1,212,550
$1,212,554
$1,212,599
$1,212,677
$1,212,723
$1,212,734
$1,212,789
$1,212,814
$1,212,883
Reserve for Encumbrances
($
Liability Reserve
($
1,802,121)
Employee Benefit Accrued Liability Reserve
($
1,028,474)
Retirement Contribution Reserve
($
TRS Sub Reserve
August 686,121) ($
September
October
November
686,121)
$686,121
$686,121
$1,802,187
$1,802,232
$1,802,237
$1,802,350
$1,028,512
$1,028,538
$1,028,541
$1,028,605
7,762,459)
$7,762,742
$7,762,837
$7,762,959
($
1,812,251)
$1,812,317
$1,812,362
Tax Certiorari Reserve
($
3,657,751)
$3,657,885
Worker's Compensation Reserve
($
3,026,815)
Capital Reserve
($
Debt Service Reserve Unemployment Insurance Reserve Total Reserved Fund Balance:
686,121) ($
December $686,121 ($
January
February
March
($ 30,775,996)
$30,777,095 ($ 30,777,920) ($ 30,777,821) ($ 30,780,046)
$30,781,259 ($ 30,782,396)
$30,782,744
$30,784,098
$30,784,796
$30,786,170
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
($
5,988,960)
$5,988,960
$5,987,105
$5,987,105
$5,985,136
$5,983,954
$5,982,817
$5,981,793
$5,981,180
$5,980,562
$5,979,043
June
$0
Unreserved Fund Balance
Total Fund Balance
($ 11,488,960)
$11,488,960 ($ 11,487,105) ($ 11,487,105) ($ 11,485,136)
$11,483,954 ($ 11,482,817)
$11,481,793
$11,481,180 ($ 11,480,562) ($ 11,479,043) ($
-
)
($ 42,264,956)
$42,266,054 ($ 42,265,025) ($ 42,264,925) ($ 42,265,183)
$42,265,213 ($ 42,265,213)
$42,264,537
$42,265,278 ($ 42,265,358) ($ 42,265,213) ($
-
)
Total Budget
$188,814,445
July 2021
August 2021
September 2021
October 2021
November 2021
December 2021
January 2022
February 2022
March 2022
April 2022
May 2022
June 2021
$39,857,777
$36,190,921
$26,896,728
$19,284,817
$33,712,278
$90,909,221
$81,264,249
$68,753,821
$63,168,415
$54,205,719
$59,191,870
$44,139,319
Monthly $13,350,794
$8,036,384
$22,948,896
$56,045,997
$45,157,379
$27,546,883
$23,588,273
$13,149,694
$18,888,455
$21,782,548
$8,852,907
Comm General Fund
$168,588
$171,460
$217,902
$218,807
$221,836
$262,041
$267,092
$268,677
$297,719
$305,899
$315,818
School Lunch Fund
$200,211
$175,040
$91,657
$342,260
$85,034
$222,394
$99,841
$1,344,280
$479,985
$190,638
$180,461
Capital Fund
$969,536
-$1,234,559
$3,543,497
-$142,161
$899,199
$1,725,072
$340,305
$915,767
-$261,656
$170,345
$265,642
Federal
$113,726
$264,167
$421,690
$121,909
$577,392
$424,830
$546,044
$424,830
$740,052
$565,124
$318,207
Trust and Agency
$489,001
$265,293
-$120,033
$2,717,803
$2,717,803
$6,956,705
$6,728,324
$6,492,241
$1,482,079
$583,333
$385,931
$11,530,351
$11,531,329
$6,533,735
$11,532,763
$11,533,710
$11,534,699
$11,535,688
$11,536,822
$2,537,416
$2,537,657
$11,539,193
$74,521
$75,703
$74,935
General Fund
Reserves Payroll CD's/Treasury Bill
Ending Total Cash:
$26,896,728
$19,284,817
$33,712,278
$71,843
$71,896
$81,197
$62,848
$62,907
$71,955
$71,864
$67,705
$20,000,000
$20,000,000
$20,000,000
$20,000,000
$20,010,501
$34,955,865
$17,931,912
$17,931,912
$90,909,221
$81,264,249
$68,753,821
$63,168,415
$54,205,719
$59,191,870
$44,139,319
$39,857,777
$0
Summary of Investments
Bank
Maturity
Interest Rate
# of Days
Amount
Capital Reserve Govt MM
GRB/ICS
0.20%
$6,633,594
Retirement Contribution Reserve
GRB/ICS
0.20%
$7,765,068
Workers Comp Reserve
GRB/ICS
0.20%
$3,027,833
EBALR Reserve
GRB/ICS
0.20%
$1,028,820
Debt Service Res Govt MM
GRB/ICS
0.20%
$3,157,284
Tax Certiorari Reserve Govt MM
GRB/ICS
0.20%
$3,658,981
Unemployment Reserve Govt MM
GRB/ICS
0.20%
$1,212,883
Liability Reserve Govt MM
GRB/ICS
0.20%
$1,802,727
US Treasury Bills
Chase
12/29/22
0.98%
$4,960,528
US Treasury Bills
Chase
6/14/22
0.35%
$4,995,470
US Treasury Bills
Chase
9/8/22
0.70%
$4,982,694
US Treasury Bills
Chase
7/28/2022
0.70%
$2,993,220
Totals
$46,219,102