Citation in context

#q1c9c
audit · claytonschools

finance 2022 2023 Audited Financial Report

2022-07-01 Portal: claytonschools Section: 2. District's Other Risk #q1c9c

Should the contributions received by MUSIC not be sufficient, special assessments can be made to the member districts. There have been no significant changes in insurance coverage from the prior year. - 62 - SCHOOL DISTRICT OF CLAYTON SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE - BUDGET AND ACTUAL - CASH BASIS - GENERAL FUND - UNAUDITED Year ended June 30, 2023 Budgeted amounts Variances - positive (negative) Original Final Actual (budgetary basis) Original to final Final to actual Revenues Local $ 21,582,080 $ 21,582,080 $ 21,494,287 $ - $ (87,793) County 125,280 125,280 116,473 - (8,807) State 377,030 388,930 401,475 11,900 12,545 Federal 565,420 575,970 826,250 10,550 250,280 Other 2,000 2,000 26,742 - 24,742 Total revenues 22,651,810 22,674,260 22,865,227 22,450 190,967 Expenditures Instruction 3,003,270 3,068,480 2,459,487 (65,210) 608,993 Attendance and guidance 927,120 873,250 831,601 53,870 41,649 Health services 766,320 760,640 720,619 5,680 40,021 Improvement of instruction and professional development 558,940 558,540 418,003 400 140,537 Media services 461,670 466,890 467,508 (5,220) (618) Board of Education services 286,020 286,020 250,739 - 35,281 Executive administration 1,863,850 1,899,590 1,843,733 (35,740) 55,857 Building level administration 1,122,300 1,129,800 1,152,090 (7,500) (22,290) Operation of plant 8,111,630 8,340,870 7,690,782 (229,240) 650,088 Security services 266,760 268,830 291,096 (2,070) (22,266) Nonallowable transportation 230,510 288,210 314,099 (57,700) (25,889) Food services 1,225,180 1,227,340 1,014,924 (2,160) 212,416 Business services 1,095,670 1,046,480 1,070,494 49,190 (24,014) Central office support services 538,520 560,830 487,604 (22,310) 73,226 Adult/community programs 1,226,260 1,212,240 1,151,940 14,020 60,300 Total expenditures 21,684,020 21,988,010 20,164,719 (303,990) 1,823,291 Revenues over (under) expenditures $ 967,790 $ 686,250 $ 2,700,508 $ (281,540) $ 2,014,258 The accompanying notes are an integral part of this statement. - 64 -

SCHOOL DISTRICT OF CLAYTON SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE - BUDGET AND ACTUAL - CASH BASIS - GENERAL FUND - UNAUDITED Year ended June 30, 2023 Budgeted amounts Variances - positive (negative) Original Final Actual (budgetary basis) Original to final Final to actual Revenues Local $ 21,582,080 $ 21,582,080 $ 21,494,287 $ - $ (87,793) County 125,280 125,280 116,473 - (8,807) State 377,030 388,930 401,475 11,900 12,545 Federal 565,420 575,970 826,250 10,550 250,280 Other 2,000 2,000 26,742 - 24,742 Total revenues 22,651,810 22,674,260 22,865,227 22,450 190,967 Expenditures Instruction 3,003,270 3,068,480 2,459,487 (65,210) 608,993 Attendance and guidance 927,120 873,250 831,601 53,870 41,649 Health services 766,320 760,640 720,619 5,680 40,021 Improvement of instruction and professional development 558,940 558,540 418,003 400 140,537 Media services 461,670 466,890 467,508 (5,220) (618) Board of Education services 286,020 286,020 250,739 - 35,281 Executive administration 1,863,850 1,899,590 1,843,733 (35,740) 55,857 Building level administration 1,122,300 1,129,800 1,152,090 (7,500) (22,290) Operation of plant 8,111,630 8,340,870 7,690,782 (229,240) 650,088 Security services 266,760 268,830 291,096 (2,070) (22,266) Nonallowable transportation 230,510 288,210 314,099 (57,700) (25,889) Food services 1,225,180 1,227,340 1,014,924 (2,160) 212,416 Business services 1,095,670 1,046,480 1,070,494 49,190 (24,014) Central office support services 538,520 560,830 487,604 (22,310) 73,226 Adult/community programs 1,226,260 1,212,240 1,151,940 14,020 60,300 Total expenditures 21,684,020 21,988,010 20,164,719 (303,990) 1,823,291 Revenues over (under) expenditures $ 967,790 $ 686,250 $ 2,700,508 $ (281,540) $ 2,014,258 The accompanying notes are an integral part of this statement. - 64 - SCHOOL DISTRICT OF CLAYTON SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE - BUDGET AND ACTUAL - CASH BASIS - SPECIAL REVENUE FUND - UNAUDITED Year ended June 30, 2023 Budgeted amounts Variances - positive (negative) Original Final Actual (budgetary basis) Original to final Final to actual Revenues Local $32,351,780 $32,351,780 $34,112,980 $ - $ 1,761,200 County 254,600 254,600 260,134 - 5,534 State 1,868,190 1,868,190 1,962,457 - 94,267 Federal 157,330 298,580 149,801 141,250 (148,779) Other 2,000 2,000 - - (2,000) Total revenues 34,633,900 34,775,150 36,485,372 141,250 1,710,222 Expenditures Instruction Instruction 29,753,650 29,879,290 29,155,150 (125,640) 724,140 Attendance and guidance 1,485,810 1,485,810 1,372,781 - 113,029 Health services 133,890 133,890 203,497 - (69,607) Improvement of instruction and professional development 1,185,950 1,191,700 1,222,753 (5,750) (31,053) Media services 554,920 554,920 560,187 - (5,267) Executive administration 1,271,300 1,271,300 1,294,462 - (23,162) Building level administration 1,646,060 1,646,060 1,711,528 - (65,468) Business services 111,040 54,210 - 56,830 54,210 Central office support services 580 3,940 3,936 (3,360) 4 Adult/community programs 3,480 3,480 3,528 - (48) Total expenditures 36,146,680 36,224,600 35,527,822 (77,920) 696,778 Revenues over (under) expenditures $(1,512,780)$(1,449,450)$ 957,550 $ 63,330 $ 2,407,000 The accompanying notes are an integral part of this statement. - 65 -

SCHOOL DISTRICT OF CLAYTON SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE - BUDGET AND ACTUAL - CASH BASIS - SPECIAL REVENUE FUND - UNAUDITED Year ended June 30, 2023 Budgeted amounts Variances - positive (negative) Original Final Actual (budgetary basis) Original to final Final to actual Revenues Local $32,351,780 $32,351,780 $34,112,980 $ - $ 1,761,200 County 254,600 254,600 260,134 - 5,534 State 1,868,190 1,868,190 1,962,457 - 94,267 Federal 157,330 298,580 149,801 141,250 (148,779) Other 2,000 2,000 - - (2,000) Total revenues 34,633,900 34,775,150 36,485,372 141,250 1,710,222 Expenditures Instruction Instruction 29,753,650 29,879,290 29,155,150 (125,640) 724,140 Attendance and guidance 1,485,810 1,485,810 1,372,781 - 113,029 Health services 133,890 133,890 203,497 - (69,607) Improvement of instruction and professional development 1,185,950 1,191,700 1,222,753 (5,750) (31,053) Media services 554,920 554,920 560,187 - (5,267) Executive administration 1,271,300 1,271,300 1,294,462 - (23,162) Building level administration 1,646,060 1,646,060 1,711,528 - (65,468) Business services 111,040 54,210 - 56,830 54,210 Central office support services 580 3,940 3,936 (3,360) 4 Adult/community programs 3,480 3,480 3,528 - (48) Total expenditures 36,146,680 36,224,600 35,527,822 (77,920) 696,778 Revenues over (under) expenditures $(1,512,780)$(1,449,450)$ 957,550 $ 63,330 $ 2,407,000 The accompanying notes are an integral part of this statement. - 65 - SCHOOL DISTRICT OF CLAYTON NOTES TO REQUIRED SUPPLEMENTARY INFORMATION June 30, 2023 NOTE A – BUDGETS AND BUDGETARY ACCOUNTING The District follows these procedures in establishing the budgetary data reflected in the financial statements:  In accordance with Chapter 67, RSMo, the District adopts a budget for each fund.  Prior to July, the Superintendent, who serves as the budget officer, submits to the Board a proposed budget for the fiscal year beginning on the following July 1. The proposed budget includes estimated revenues and proposed expenditures for all District funds. Budgeted expenditures cannot exceed beginning available monies plus estimated revenues for the year.  A public hearing is conducted to obtain taxpayer comments. Prior to its approval by the Board, the budget document is available for public inspection.  Prior to July 1, the budget is legally enacted by a vote of the Board.  Subsequent to its formal approval of the budget, the Board has the authority to make necessary adjustments to the budget by formal vote of the Board. For each fund, total fund expenditures may not legally exceed final amended budgeted expenditures. Expenditure appropriations lapse at the end of the fiscal year.  Budgeted amounts are as originally adopted on June 1, 2022, or as amended by the Board at various times during the year.  Budgets are adopted on the cash basis of accounting for all governmental funds. The cash basis is used to enable the District to more accurately budget revenue and expenses as the resources are expended or received. - 66 -

Expenditure appropriations lapse at the end of the fiscal year.  Budgeted amounts are as originally adopted on June 1, 2022, or as amended by the Board at various times during the year.  Budgets are adopted on the cash basis of accounting for all governmental funds. The cash basis is used to enable the District to more accurately budget revenue and expenses as the resources are expended or received. - 66 - SCHOOL DISTRICT OF CLAYTON NOTES TO REQUIRED SUPPLEMENTARY INFORMATION June 30, 2023 NOTE A – BUDGETS AND BUDGETARY ACCOUNTING - CONTINUED The following schedule reconciles the revenue and expenditures on the budgetary basis of accounting (cash basis) with the amounts presented under the modified accrual basis of accounting: General Fund Special Revenue Fund Revenues Revenues - cash basis $ 22,865,227 $ 36,485,372 Current year revenue accruals (391,343) 381,515 Prior year revenue accruals 496,594 (257,317) Revenues - modified accrual basis $ 22,970,478 $ 36,609,570 Expenditures Expenditures - cash basis $ 20,164,719 $ 35,527,822 Current year expenditure accruals 230,661 88,794 Prior year expenditure accruals (11,060) (135,478) Expenditures - modified accrual basis $ 20,384,320 $ 35,481,138 - 67 -

SCHOOL DISTRICT OF CLAYTON NOTES TO REQUIRED SUPPLEMENTARY INFORMATION June 30, 2023 NOTE A – BUDGETS AND BUDGETARY ACCOUNTING - CONTINUED The following schedule reconciles the revenue and expenditures on the budgetary basis of accounting (cash basis) with the amounts presented under the modified accrual basis of accounting: General Fund Special Revenue Fund Revenues Revenues - cash basis $ 22,865,227 $ 36,485,372 Current year revenue accruals (391,343) 381,515 Prior year revenue accruals 496,594 (257,317) Revenues - modified accrual basis $ 22,970,478 $ 36,609,570 Expenditures Expenditures - cash basis $ 20,164,719 $ 35,527,822 Current year expenditure accruals 230,661 88,794 Prior year expenditure accruals (11,060) (135,478) Expenditures - modified accrual basis $ 20,384,320 $ 35,481,138 - 67 - SCHOOL DISTRICT OF CLAYTON NET PENSION LIABILITY - UNAUDITED Year ended June 30, 2023 Schedule of Proportionate Share of the Net Pension Liability and Related Ratios – PSRS Year ended* Proportion of the Net Pension Liability (Asset) Proportionate share of the Net Pension Liability (Asset) Actual member payroll Net Pension Liability (Asset) as a percentage of covered payroll Fiduciary Net Position as a percentage of total pension liability 6/30/2014 % 0.5208 $ 21,366,213 $ 23,616,628 % 90.47 % 89.34 6/30/2015 % 0.5256 30,342,153 24,305,850 % 124.83 % 85.78 6/30/2016 % 0.5421 40,335,757 25,587,013 % 157.64 % 82.18 6/30/2017 % 0.5510 39,790,604 26,583,036 % 149.68 % 83.77 6/30/2018 % 0.5512 41,022,820 27,049,379 % 151.00 % 84.06 6/30/2019 % 0.5515 40,701,088 27,606,008 % 147.44 % 84.62 6/30/2020 % 0.5488 49,011,771 27,895,612 % 175.70 % 82.01 6/30/2021 % 0.5532 12,246,618 29,001,748 % 42.23 % 95.81 6/30/2022 % 0.5483 42,406,647 29,420,226 % 144.14 % 86.04 Schedule of Proportionate Share of the Net Pension Liability and Related Ratios – PEERS Year ended* Proportion of the Net Pension Liability (Asset) Proportionate share of the Net Pension Liability (Asset) Actual member payroll Net Pension Liability (Asset) as a percentage of covered payroll Fiduciary Net Position as a percentage of total pension liability 6/30/2014 % 0.5233 $ 1,910,913 $ 7,630,413 % 25.04 % 91.33 6/30/2015 % 0.5044 2,667,803 7,563,393 % 35.27 % 88.28 6/30/2016 % 0.5122 4,109,561 7,908,987 % 51.96 % 83.32 6/30/2017 % 0.5064 3,863,583 8,137,380 % 47.48 % 85.35 6/30/2018 % 0.4976 3,845,017 8,279,018 % 46.44 % 86.06 6/30/2019 % 0.4942 3,908,930 8,571,837 % 45.60 % 86.38 6/30/2020 % 0.4788 4,647,029 8,615,269 % 53.94 % 84.06 6/30/2021 % 0.4700 506,154 8,612,957 % 5.88 % 98.36 6/30/2022 % 0.4589 3,878,246 8,957,602 % 43.30 % 87.92 - 68 -

Open full document View original source Report an error →