General Fund April, 2022 Receipts
Disbursements
Tax Levy
Personnel Costs Webster
$1,491,350.76
Instructional Salaries
$6,568,765.73
Penfield
$475,049.39
Non- Intructional Salaries
$1,919,673.66
Ontario
$12,130.23
ERS
$81,680.80
TRS
$620,178.27
FICA
$637,519.24
Walworth Pilot Payments Sub Total
$1,978,530.38
Worker's Compensation Health Benefits
$2,222,590.11
Dental Benefits
$99,782.84
Sub Total Personnel Costs Sub Total
$12,150,190.65
$0.00 Instructional Materials
Other Tax Items Sales Tax Monroe/Wayne PILOTS Sub Total
$0.00
Equipment
$55,311.51
Supplies
$337,378.71
Textbooks
$54,777.07
Contractuals
$143,481.97
Sub Total Instructional Materials
$590,949.26
State Aid Categories Gen Aid
Energy Expenses
Lottery Aid Tuition
445/443 444
Electric
$110,740.65
BOCES
442
Natural Gas
$54,005.90
Textbook/Software
446
Water
$8,071.86
Excess Cost
441
Fuel
Other Aid
Sub Total Energy
Sub Total
$172,818.41
$0.00 BOCES
$1,316,122.76
Subtotal
$1,316,122.76
Facility Rentals
$10,020.80
Health Services
$9,035.09 Puchase of T Bills
$2,993,219.75
Misc
$1,736.00 Debt Service
Other Revenues Interest
$17,171.52
Medicaid Refund of Prior Year
Due to Federal/SL Transfers
$899.80 Transfer
$1,900,000.00
$20,000,000.00
Sub Total
$20,038,863.21 Sub Total Debt
$4,893,219.75
Total Monthly Receipts
$22,017,393.59 Monthly Disbursements
$19,123,300.83
Acct x6378
Acct x6378
Balance per Bank
$24,946,602.28
less outstanding checks
$3,145,524.86
Demand Check/Deposit in trans In trans Ending Balance
Beginning Balance
($ 18,888,454.94)
Receipts
$22,017,393.59
Disbursements
$19,123,300.83
Balance
$21,782,547.70
$18,529.72 $21,782,547.70
$0.00
School Lunch (C) April 2022 Receipts
Disbursements
Reimbursable Meals
Personnel Costs Breakfast
Non- Intructional Salaries
$108,430.57
Lunch
ERS
$114,826.54
Ala Carte Adult Sub Total
$51,788.42
TRS
$1,208.23
FICA/MED
$52,996.65
Worker's Compensation
$8,012.67
Health Benefits State
Dental Benefits Breakfast
$8,489.00
Lunch
$9,025.00
Snack
$1,150.00
Sub Total
Sub Total Personnel Costs
$231,269.78
Food Purchases
$18,664.00
Food Purchases
$110,105.87
Milk/Juice
$53,621.68
Produce
$2,431.38
Breakfast
Snack/Drinks
$2,705.52
Lunch
Meats/Proteins
Snack
Gov't Commodities
Surplus
Other
Federal Program
PBT Sub Total
$0.00
Other Revenues
Sub Total
$168,864.45
Other Expenses Commissions
$5,731.63
Equipment/Repairs
$3,484.30
Catering
$8,244.62
Contractuals
$3,120.91
Supplies
$6,104.66
Concessions Interest
$46.64
Misc
$5,197.90
Pre-payments
$32,615.69
Sub Total
Miscellaneous Cash Transfers Sub Total
$12,709.87
Monthly Disbursements
$412,844.10
$51,836.48
Interfund Transfer Total Monthly Receipts
$123,497.13
Aid payment Due From Gen
Balance per Bank
$263,172.60
Beginning Balance
$479,984.91
less outstanding checks
-$74,511.51
Receipts
$123,497.13
Heartland Deposit
$1,976.85
Disbursements
$412,844.10
Ending Balance
$190,637.94
Balance
$190,637.94
$0.00
Capital April 2022 Receipts
Transfers
Disbursements
$2,500,000.00 69.5 December 2018 Project
Interest
$113.37
Architect/Clerk
$118,933.53
Asbestos Monitoring Sub Total
$2,500,113.37
Survey & Engin Contractual/Incidentals Legal Equipment
$87,164.79
Sub Total
$206,098.32
69.5 December 2018 Project General Contract
$937,464.39
Plumbing Contract
$19,857.31
Mechanical Contract
$605,215.67
Electrical Contract
$207,799.20
Site Contract
$87,999.61
Sub Total
$1,858,336.18
Klem North 100k
Sub Total
$0.00
BOCES Project
$0.00
$100k Project
$3,677.50
Other Revenues
Sub Total Total Monthly Receipts
$2,500,113.37 Monthly Disbursements
$2,068,112.00
Balance per Bank
$684,113.77
Beginning Balance
-$261,656.40
less outstanding checks
-$513,768.80
Receipts
$2,500,113.37
Ending Balance
$170,344.97
Disbursements
$2,068,112.00
Balance
$170,344.97
$0.00
General Fund (A) Reserves (GRB) April 2022 Receipts
Disbursements
Account x2260 Interest Earned
$188.04
Transfers from General for HSA
HSA Withdrawl Transfer for Cash Flow
Deposit from General From Sweep
$45.71 $233.75
$0.00
Account x2260
Interest Earned
$52.87
Transfers from General for HSA
Sweep to x260
$52.87
$45.71
$45.71
Beginning Balance
$2,288,370.48
Beginning Balance
$249,045.71
Receipts
$233.75
Receipts
$52.87
Disbursements
$0.00
Balance
$2,288,604.23
Acct 260/ICS
Disbursements
$45.71
Balance
$249,052.87
Acct 2260/GRB
$2,537,657.10
Federal (Special Aid) Fund (F) April 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
$1,310.75
$121,954.70 $6,661.85
School for the Deaf ESY Sub Total
$0.00
State Grants
Sub Total
$129,927.30
State Grants Teacher Center
Teacher Center
$269.82
UPK
UPK
$8,217.35
Other
4201/Deaf
Sub Total
$0.00
Continuing Education Programs
Sub Total
$1,860.00 $10,347.17
Continuing Education Programs Registrations
$108,228.00
Salaries
$90,080.38
Equipment
Contractual
$1,440.00
Supplies
Supplies
$1,106.83
Contractuals
Refunds
Sub Total
$108,228.00
Other Grants/Donations
Sub Total
$92,627.21
Other Grants/Donations Cultural Arts
YEA
$700.00
Cultural Arts
Solofest
BOCES
Other/Transfer
$1,110.25
Interest
$55.87
Other
$52,121.08
Sub Total
$1,866.12
Sub Total
$52,121.08
Monthly Receipts
$110,094.12
Monthly Disbursements
$285,022.76 $0.00
Balance per Bank
$571,447.33
less outstanding checks
-$6,323.57
Beginning Balance
$740,052.40
Receipts
$110,094.12
Ending Balance
$565,123.76
Disbursements
$285,022.76
Balance
$565,123.76
Webster Central School District 2021-22 Fund Balance Summary Reserved Fund Balance
July
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
April
686,121)
$686,121
$686,121
$686,121
$1,802,421
$1,802,489
$1,802,505
$1,802,587
$1,802,624
$1,028,646
$1,028,684
$1,028,694
$1,028,740
$1,028,761
$7,763,445
$7,763,750
$7,764,043
$7,764,112
$7,764,465
$7,764,625
$1,812,367
$1,812,481
$1,812,552
$1,812,621
$1,812,637
$1,812,719
$1,812,756
$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,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
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
($
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
($
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
($ 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
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
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
May
June
$0
$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) ($
-
) ($
-
)
($ 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) ($
-
) ($
-
)
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 $61,163,272
$0
$0
$0
$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
June 2021
Monthly General Fund
$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
Comm General Fund
$168,588
$171,460
$217,902
$218,807
$221,836
$262,041
$267,092
$268,677
$297,719
$305,899
School Lunch Fund
$200,211
$175,040
$91,657
$342,260
$85,034
$222,394
$99,841
$1,344,280
$479,985
$190,638
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
Federal
$113,726
$264,167
$421,690
$121,909
$577,392
$424,830
$546,044
$424,830
$740,052
$565,124
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
$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
$74,521
$75,703
$74,935
Reserves Payroll CD's
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
$20,000,000
$20,000,000
$20,000,000
$20,000,000
$20,010,501
$34,955,865
$34,955,865
$90,909,221
$81,264,249
$68,753,821
$63,168,415
$54,205,719
$59,191,870
$61,163,272
Summary of Investments
Bank
Maturity
Interest Rate
# of Days
Amount
Capital Reserve Govt MM
GRB/ICS
0.05%
Retirement Contribution Reserve
GRB/ICS
0.05%
$7,764,112
Workers Comp Reserve
GRB/ICS
0.05%
$3,027,460
EBALR Reserve
GRB/ICS
0.05%
$1,028,694
Debt Service Res Govt MM
GRB/ICS
0.05%
$3,156,974
Tax Certiorari Reserve Govt MM
GRB/ICS
0.05%
$3,658,531
Unemployment Reserve Govt MM
GRB/ICS
0.05%
$1,212,734
Liability Reserve Govt MM
GRB/ICS
0.05%
$1,802,505
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%
Totals
$6,632,976
$2,993,220 $46,215,899