General Fund June, 2022 Receipts
Disbursements
Tax Levy
Personnel Costs Webster
Instructional Salaries
$12,994,184.83
Penfield
Non- Intructional Salaries
$2,468,778.46
Ontario
ERS
$215,552.18
Walworth
TRS
$1,214,862.73
FICA
$1,185,148.29
Pilot Payments Sub Total
$0.00
Worker's Compensation
$2,218,900.91
Dental Benefits
$86,123.48
Sub Total Personnel Costs Sub Total
$0.00
Health Benefits
$20,383,550.88
$0.00 Instructional Materials
Other Tax Items
Equipment
$154,455.92
Sales Tax Monroe/Wayne
Supplies
$399,595.57
PILOTS
Textbooks
$5,657.26
Contractuals
$201,444.66
Sub Total
$0.00
Sub Total Instructional Materials
$761,153.41
State Aid Categories Gen Aid
$2,263,536.32 Energy Expenses
Lottery Aid Tuition
445/443 444
Electric
$66,477.08
BOCES
442
Natural Gas
$17,781.32
Textbook/Software
446
Water
$10,559.62
Excess Cost
441
Fuel
Other Aid
Sub Total Energy
Sub Total
$30,772.83 $125,590.85
$2,263,536.32 BOCES
$1,936,789.45
Transfer
$1,800,000.00
Interest
$2,108.31
Medicaid
$73,393.79 Subtotal
$3,736,789.45
Other Revenues
Refund of Prior Year Facility Rentals
$4,534.00
Health Services
$3,970.60 Puchase of T Bills
Misc
$73,091.18 Debt Service
$4,509,400.00
$157,097.88 Sub Total Debt
$4,509,400.00
Due to Federal/SL Transfers Sub Total NEW BAN Total Monthly Receipts
$25,297,300.00 $27,717,934.20 Monthly Disbursements
Acct x6378 Balance per Bank less outstanding checks
Acct x6378 $7,896,796.20 $842,941.33
Demand Check/Deposit in trans
$120.60
In trans
$200.50
Ending Balance
$29,516,484.59
$7,054,175.97
Beginning Balance
($ 8,852,726.36)
Receipts
$27,717,934.20
Disbursements
$29,516,484.59
Balance
$7,054,175.97
0.000000006519258022
School Lunch (C) June 2022 Receipts
Disbursements
Reimbursable Meals
Personnel Costs Breakfast
Non- Intructional Salaries
$154,146.86
Lunch
ERS
$9,563.25
Ala Carte
TRS
Adult Sub Total
FICA/MED $0.00
$11,417.90
Worker's Compensation Health Benefits
State
$15,914.69
Dental Benefits Breakfast
$11,302.00
Lunch
$13,348.00
Snack Sub Total
$576.90
Sub Total Personnel Costs
$191,619.60
Food Purchases $24,650.00
Food Purchases
$178,811.60
Milk/Juice Federal Program
Produce Breakfast
Snack/Drinks
Lunch
Meats/Proteins
Snack
Gov't Commodities
Surplus
Other
$8,626.72
PBT Sub Total
$0.00
Other Revenues
Sub Total
$187,438.32
Other Expenses Commissions
Equipment/Repairs
$4,484.41
Catering
$44,241.82
Contractuals
$3,490.26
Concessions
$4,043.41
Supplies
$6,605.36
Interest
$40.92
Miscellaneous
Misc Pre-payments Sub Total
Cash Transfers $10,772.40
Sub Total
$14,580.03
Monthly Disbursements
$393,637.95
$59,098.55
Interfund Transfer
$250,000.00
Total Monthly Receipts
333748.55
Aid payment Due From Gen
Balance per Bank
$180,254.71
Beginning Balance
$190,637.94
less outstanding checks
-$49,506.17
Receipts
$333,748.55
Disbursements
$393,637.95
Balance
$130,748.54
Heartland Deposit Ending Balance
$130,748.54
0
Capital June 2022 Receipts
Transfers
Disbursements
$2,300,000.00 69.5 December 2018 Project
Interest
$162.12
Architect/Clerk
$127,000.15
Asbestos Monitoring Sub Total
$2,300,162.12
Survey & Engin
$225.00
Contractual/Incidentals
$321,297.00
Legal Equipment
$7,122.23
Sub Total
$455,644.38
69.5 December 2018 Project General Contract
$999,598.35
Plumbing Contract
$371,537.97
Mechanical Contract
$86,410.10
Electrical Contract
$261,852.05
Site Contract
$388,954.67
Sub Total
$2,108,353.14
Klem North 100k
Sub Total
$0.00
BOCES Project
$0.00
$100k Project
Other Revenues
Sub Total Total Monthly Receipts
$2,300,162.12 Monthly Disbursements
$2,563,997.52
Balance per Bank
$447,473.16
Beginning Balance
$265,641.81
less outstanding checks
-$445,666.75
Receipts
$2,300,162.12
Ending Balance
$1,806.41
Disbursements
$2,563,997.52
Balance
$1,806.41
-0.0000000001746229827
Federal (Special Aid) Fund (F) June 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
$132,631.95
IDEA 619
IDEA 619
$5,849.07
$2,378.00
$1,551.35
$124,549.95
School for the Deaf ESY Sub Total
$0.00
State Grants
$97.32
Sub Total
$267,057.64
State Grants Teacher Center
Teacher Center
$7,016.72
UPK
UPK
$35,605.79
Other Sub Total
4201/Deaf $0.00
Continuing Education Programs
Sub Total
$4,950.00 $47,572.51
Continuing Education Programs Registrations
$71,370.35
Salaries
Equipment
Contractual
Supplies
Supplies
Contractuals Sub Total
$126,112.63 501.29
$56,382.14
Refunds $71,370.35
Other Grants/Donations
Sub Total
$182,996.06
Other Grants/Donations Cultural Arts
$1,110.25
Cultural Arts
Other
$650.00
BOCES
Transfer
$140,000.00
Other
Interest
$71.63
$29.99 $901.26
Sub Total
$140,721.63
Sub Total
$2,041.50
Monthly Receipts
$212,091.98
Monthly Disbursements
$499,667.71 0
Balance per Bank
$203,247.56
less outstanding checks
-$106,593.02
Beginning Balance
$384,230.27
Receipts
$212,091.98
Ending Balance
$96,654.54
Disbursements
$499,667.71
Balance
$96,654.54
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
$686,211
$1,802,421
$1,802,489
$1,802,505
$1,802,587
$1,802,624
$1,802,727
$3,302,826
$1,028,605
$1,028,646
$1,028,684
$1,028,694
$1,028,740
$1,028,761
$1,028,820
$1,028,877
$7,763,445
$7,763,750
$7,764,043
$7,764,112
$7,764,465
$7,764,625
$7,765,068
$8,765,494
$1,812,367
$1,812,481
$1,812,552
$1,812,621
$1,812,637
$1,812,719
$1,812,756
$1,812,860
$2,812,959
$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
$4,159,181
$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
$4,027,999
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
$10,633,958
($
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
$3,157,457
($
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
$1,212,950 $39,787,913
Reserve for Encumbrances
($
Liability Reserve
($
1,802,121)
Employee Benefit Accrued Liability Reserve
($
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,474)
$1,028,512
$1,028,538
$1,028,541
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
June
($ 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
$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
-$3,022,610
$11,483,954 ($ 11,482,817)
$11,481,793
$11,481,180 ($ 11,480,562) ($ 11,479,043) ($
Unreserved Fund Balance
Total Fund Balance
($ 11,488,960)
$11,488,960 ($ 11,487,105) ($ 11,487,105) ($ 11,485,136)
2,477,390)
$42,264,955.60 $42,266,054.28 $42,265,024.61 $42,264,925.37 $42,265,182.61 $42,265,213.09 $42,265,213.09 $42,264,536.76 $42,265,278.00 $42,265,357.53 $42,265,213.09 $42,265,302.90
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
$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
$53,140,855
$39,857,776
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
$8,852,907
$7,054,176
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
$377,111
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
$130,749
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
$1,806
Federal
$113,726
$264,167
$421,690
$121,909
$577,392
$424,830
$546,044
$424,830
$740,052
$565,124
$318,207
$96,655
Trust and Agency Reserves Payroll
$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
$402,673
$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
$11,539,193
$11,539,193
$2,540,787
$74,521
$75,703
$74,935
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
$67,705
$72,090
$20,000,000
$20,000,000
$20,000,000
$20,000,000
$20,010,501
$34,955,865
$17,931,912
$17,931,912
$17,931,912
$90,909,221
$81,264,249
$68,753,821
$63,168,415
$54,205,719
$59,191,870
$53,140,855
$39,857,776
$28,607,959
Summary of Investments
Bank
Maturity
Interest Rate
# of Days
Amount
Capital Reserve Govt MM
GRB/ICS
0.30%
$6,633,958
Retirement Contribution Reserve
GRB/ICS
0.30%
$7,765,494
Workers Comp Reserve
GRB/ICS
0.30%
$3,027,999
EBALR Reserve
GRB/ICS
0.30%
$1,028,877
Debt Service Res Govt MM
GRB/ICS
0.30%
$3,157,457
Tax Certiorari Reserve Govt MM
GRB/ICS
0.30%
$3,659,181
Unemployment Reserve Govt MM
GRB/ICS
0.30%
$1,212,950
Liability Reserve Govt MM
GRB/ICS
0.30%
$1,802,826
US Treasury Bills
Chase
12/29/22
0.98%
$4,960,528
US Treasury Bills
Chase
7/15/22
1.04%
$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
$2,993,220 $46,220,655