General Fund March, 2022 Receipts
Disbursements
Tax Levy
Personnel Costs Webster
Instructional Salaries
$6,359,941.15
Penfield
Non- Intructional Salaries
$1,416,494.33
Ontario
ERS
$258,531.68
Walworth
TRS
$617,616.05
Pilot Payments
FICA
$629,408.04
Sub Total
$0.00
Worker's Compensation
$2,206,343.32
Dental Benefits
$121,571.23
Sub Total Personnel Costs Sub Total
$0.00
Health Benefits
$11,609,905.80
$0.00 Instructional Materials
Other Tax Items
Equipment
$163,003.29
Sales Tax Monroe/Wayne
Supplies
$243,578.49
PILOTS
Textbooks
$58,712.00
Contractuals
$164,708.89
Sub Total
$0.00
Sub Total Instructional Materials
$630,002.67
State Aid Categories Gen Aid
$16,121,567.57 Energy Expenses
Lottery Aid
$206,269.18
Tuition
$741,558.16 445/443 444
BOCES
$1,671,953.75 442
Textbook/Software Excess Cost Other Aid
Electric
$133,553.12
Natural Gas
$114,639.53
$561,707.00 446
Water
$2,875.65
$3,468,003.05 441
Fuel
$34,425.99
$376,892.99 Sub Total Energy
Sub Total
$285,494.29
$23,147,951.70 BOCES
$1,307,777.52
Other Revenues Interest
$7,666.00
Medicaid
$36,549.78 Subtotal
$1,307,777.52
Refund of Prior Year Facility Rentals
$115,406.03
Health Services Misc
Puchase of T Bills
$14,938,692.50
$13,681.44 Debt Service
Due to Federal/SL
$1,213,979.00 Transfer
Transfers
$12,100,000.00
$124,600.00 $2,000,000.00
Sub Total
$13,487,282.25 Sub Total Debt
$17,063,292.50
Total Monthly Receipts
$36,635,233.95 Monthly Disbursements
$30,896,472.78
Acct x6378 Balance per Bank less outstanding checks Demand Check/Deposit in trans
Acct x6378 $19,138,440.70 $250,138.14 $152.38
Beginning Balance
$13,149,693.77
Receipts
$36,635,233.95
Disbursements
$30,896,472.78
Balance
$18,888,454.94
In trans Ending Balance
$18,888,454.94
$0.00
School Lunch (C) March 2022 Receipts
Disbursements
Reimbursable Meals
Personnel Costs Breakfast
Non- Intructional Salaries
Lunch
ERS
Ala Carte
$51,788.42
TRS
Adult
$1,208.23
FICA/MED
$52,996.65
Worker's Compensation
Sub Total
$8,796.80
Health Benefits State
$16,406.08
Dental Benefits Breakfast
Jan/Feb Claims
$8,489.00
Lunch
Jan/Feb Claims
$9,025.00
Snack Sub Total
$120,920.20
$596.77
Sub Total Personnel Costs
$146,719.85
Food Purchases $17,514.00
Food Purchases
$199,534.51
Milk/Juice
$34,001.27
Produce
$2,810.92
Breakfast
Snack/Drinks
$3,770.61
Lunch
Meats/Proteins
Snack
Gov't Commodities
Surplus
Other
Federal Program
$38.30
PBT Sub Total
$0.00
Other Revenues
Sub Total
$240,155.61
Other Expenses Commissions
$5,781.63
Equipment/Repairs
$2,986.76
Catering
$8,244.62
Contractuals
$4,942.33
Supplies
$7,834.91
Concessions Interest
$46.64
Miscellaneous
$625.86
Misc
$5,197.90
Cash Transfers
$590,000.00
Pre-Payments
$39,238.71
Sub Total
Sub Total
$606,389.86
Monthly Disbursements
$993,265.32
$58,509.50
Interfund Transfer Total Monthly Receipts
$129,020.15
Aid payment Due From Gen
Balance per Bank
$480,585.80
less outstanding checks
-$550.89
Heartland Deposit Ending Balance
$480,034.91
Beginning Balance
$1,344,280.08
Receipts
$129,020.15
Disbursements
$993,265.32
Balance
$480,034.91
$0.00
Capital March 2022 Receipts
Transfers
Disbursements
$2,000,000.00 69.5 December 2018 Project
Interest
$29.29
Architect/Clerk
$64,417.04
Asbestos Monitoring Sub Total
$2,000,029.29
Survey & Engin
$63,889.89
Contractual/Incidentals Legal Equipment
$90,539.00
Sub Total
$218,845.93
69.5 December 2018 Project General Contract
$585,877.93
Plumbing Contract
$76,507.30
Mechanical Contract
$950,781.69
Electrical Contract
$342,060.01
Site Contract
$999,702.18
Sub Total
$2,954,929.11
Klem North 100k
Sub Total
$0.00
BOCES Project
$0.00
$100k Project
$3,677.50
Other Revenues
Sub Total Total Monthly Receipts
Balance per Bank
$2,000,029.29 Monthly Disbursements
-$261,656.40
less outstanding checks Ending Balance
-$261,656.40
$3,177,452.54
Beginning Balance
$915,766.85
Receipts
$2,000,029.29
Disbursements
$3,177,452.54
Balance
-$261,656.40
$0.00
General Fund (A) Reserves (GRB) March 2022 Receipts
Disbursements
Account x2260 Interest Earned
$547.48
Transfers from General for HSA
HSA Withdrawl Transfer for Cash Flow
$9,000,000.00
Deposit from General From Sweep
$19.10 $566.58
$9,000,000.00
Account x2260
Interest Earned
$45.71
Transfers from General for HSA
Sweep to x260
$45.71
Beginning Balance $11,287,803.90 Receipts
$566.58
Disbursements
$9,000,000.00
Balance
$2,288,370.48
Acct 260/ICS
$19.10
$19.10
Beginning Balance
$249,019.10
Receipts
$45.71
Disbursements
$19.10
Balance
$249,045.71
Acct 2260/GRB
$2,537,416.19
Federal (Special Aid) Fund (F) March 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
$358.95
Title V
CRSSA Grant
$341,684.32
CRRSA ESSR Grant
ARP
ARP
IDEA 611
IDEA 611
$48,489.73
IDEA 619
IDEA 619
$16,523.07
School for the Deaf ESY Sub Total
$341,684.32
State Grants
Sub Total
$65,371.75
State Grants Teacher Center
Teacher Center
$1,302.02
UPK
UPK
$52,920.35
Other
$94,961.67
Sub Total
$94,961.67
Continuing Education Programs
4201/Deaf Sub Total
$3,210.00 $57,432.37
Continuing Education Programs Registrations
$108,370.05
Salaries
$98,981.04
Equipment
Contractual
$6,316.14
Supplies
Supplies
$12,447.88
Contractuals
Refunds
Sub Total
$108,370.05
Other Grants/Donations
Sub Total
$117,745.06
Other Grants/Donations Cultural Arts
$2,100.00
Cultural Arts
Solofest
$1,638.00
BOCES
Other/Transfer
$10,064.00
Other
Interest
YEA
$3,080.00
$33.49
Sub Total
$13,835.49
Sub Total
$3,080.00
Monthly Receipts
$558,851.53
Monthly Disbursements
$243,629.18 $0.00
Balance per Bank
$790,792.76
less outstanding checks
-$50,740.36
Beginning Balance
$424,830.05
Receipts
$558,851.53
Ending Balance
$740,052.40
Disbursements
$243,629.18
Balance
$740,052.40
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
686,121)
$686,121
$686,121
$1,802,421
$1,802,489
$1,802,505
$1,802,587
$1,028,646
$1,028,684
$1,028,694
$1,028,740
$7,763,445
$7,763,750
$7,764,043
$7,764,112
$7,764,465
$1,812,367
$1,812,481
$1,812,552
$1,812,621
$1,812,637
$1,812,719
$3,657,976
$3,657,987
$3,658,216
$3,658,359
$3,658,498
$3,658,531
$3,658,697
$3,026,926
$3,027,002
$3,027,011
$3,027,200
$3,027,319
$3,027,433
$3,027,460
$3,027,598
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
($
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,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
($ 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,242
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
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
April
May
June
$0
$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 ($
-
) ($
-
) ($
-
)
($ 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,423 ($
-
) ($
-
) ($
-
)
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
$59,191,920
$0
$0
$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
May 2022
June 2021
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
Comm General Fund
$168,588
$171,460
$217,902
$218,807
$221,836
$262,041
$267,092
$268,677
$297,719
School Lunch Fund
$200,211
$175,040
$91,657
$342,260
$85,034
$222,394
$99,841
$1,344,280
$480,035
Capital Fund
$969,536
-$1,234,559
$3,543,497
-$142,161
$899,199
$1,725,072
$340,305
$915,767
-$261,656
Federal
$113,726
$264,167
$421,690
$121,909
$577,392
$424,830
$546,044
$424,830
$740,052
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
$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
$74,521
$75,703
$74,935
$71,843
$71,896
$81,197
$62,848
$62,907
$71,955
$20,000,000
$20,000,000
$20,000,000
$20,000,000
$20,010,501
$34,955,865
$90,909,221
$81,264,249
$68,753,821
$63,168,415
$54,205,719
$59,191,920
General Fund
Reserves Payroll CD's
Ending Total Cash:
$26,896,728
$19,284,817
$33,712,278
Summary of Investments
Bank
Maturity
Interest Rate
# of Days
Amount
General Fund Investment
Canandaigua
0.18%
$20,017,172
Capital Reserve Govt MM
GRB/ICS
0.05%
$6,632,976
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.99%
$4,960,528
US Treasury Bills
Chase
6/14/22
0.35%
$4,995,470
US Treasury Bills
Chase
9/8/22
0.70%
Totals
$4,982,694 $63,239,850