Citation in context

#q1d77
audit · claytonschools

finance 2020 2021 Audited Financial Report

2020-07-01 Portal: claytonschools Section: 2. District's Other Risk #q1d77

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. - 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, 2021 Budgeted amounts Variances - positive (negative) Original Final Actual (budgetary basis) Original to final Final to actual Revenues Local $ 21,377,130 $ 19,739,290 $ 19,678,262 $ (1,637,840) $ (61,028) County 108,000 126,710 126,706 18,710 (4) State 292,920 278,630 251,492 (14,290) (27,138) Federal 397,430 803,640 735,451 406,210 (68,189) Other 4,000 4,000 2,579 - (1,421) Total revenues 22,179,480 20,952,270 20,794,490 (1,227,210) (157,780) Expenditures Instruction 2,989,540 3,020,800 1,960,259 (31,260) 1,060,541 Attendance and guidance 788,830 788,760 730,891 70 57,869 Health services 589,380 775,270 633,296 (185,890) 141,974 Improvement of instruction and professional development 500,530 424,330 195,483 76,200 228,847 Media services 419,620 414,880 366,947 4,740 47,933 Board of Education services 304,360 304,360 188,994 - 115,366 Executive administration 1,644,980 1,657,700 1,597,463 (12,720) 60,237 Building level administration 1,127,010 1,137,510 1,062,993 (10,500) 74,517 Operation of plant 7,776,580 8,233,580 7,444,297 (457,000) 789,283 Security services 257,580 255,780 189,578 1,800 66,202 Nonallowable transportation 216,240 195,740 111,946 20,500 83,794 Food services 1,236,980 1,236,980 512,933 - 724,047 Business services 1,054,660 1,025,530 963,212 29,130 62,318 Central office support services 536,330 595,760 475,303 (59,430) 120,457 Adult/community programs 1,108,010 1,167,720 1,088,148 (59,710) 79,572 Total expenditures 20,550,630 21,234,700 17,521,743 (684,070) 3,712,957 Revenues over (under) expenditures $ 1,628,850 $ (282,430) $ 3,272,747 $ (1,911,280) $ 3,555,177 The accompanying notes are an integral part of this statement. - 66 -

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, 2021 Budgeted amounts Variances - positive (negative) Original Final Actual (budgetary basis) Original to final Final to actual Revenues Local $ 21,377,130 $ 19,739,290 $ 19,678,262 $ (1,637,840) $ (61,028) County 108,000 126,710 126,706 18,710 (4) State 292,920 278,630 251,492 (14,290) (27,138) Federal 397,430 803,640 735,451 406,210 (68,189) Other 4,000 4,000 2,579 - (1,421) Total revenues 22,179,480 20,952,270 20,794,490 (1,227,210) (157,780) Expenditures Instruction 2,989,540 3,020,800 1,960,259 (31,260) 1,060,541 Attendance and guidance 788,830 788,760 730,891 70 57,869 Health services 589,380 775,270 633,296 (185,890) 141,974 Improvement of instruction and professional development 500,530 424,330 195,483 76,200 228,847 Media services 419,620 414,880 366,947 4,740 47,933 Board of Education services 304,360 304,360 188,994 - 115,366 Executive administration 1,644,980 1,657,700 1,597,463 (12,720) 60,237 Building level administration 1,127,010 1,137,510 1,062,993 (10,500) 74,517 Operation of plant 7,776,580 8,233,580 7,444,297 (457,000) 789,283 Security services 257,580 255,780 189,578 1,800 66,202 Nonallowable transportation 216,240 195,740 111,946 20,500 83,794 Food services 1,236,980 1,236,980 512,933 - 724,047 Business services 1,054,660 1,025,530 963,212 29,130 62,318 Central office support services 536,330 595,760 475,303 (59,430) 120,457 Adult/community programs 1,108,010 1,167,720 1,088,148 (59,710) 79,572 Total expenditures 20,550,630 21,234,700 17,521,743 (684,070) 3,712,957 Revenues over (under) expenditures $ 1,628,850 $ (282,430) $ 3,272,747 $ (1,911,280) $ 3,555,177 The accompanying notes are an integral part of this statement. - 66 - 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, 2021 Budgeted amounts Variances - positive (negative) Original Final Actual (budgetary basis) Original to final Final to actual Revenues Local $34,511,200 $32,692,450 $32,418,245 $(1,818,750)$ (274,205) County 267,070 258,180 258,167 (8,890) (13) State 1,499,550 1,512,240 1,457,571 12,690 (54,669) Federal 51,620 488,170 90,744 436,550 (397,426) Other 95,550 95,550 89,787 - (5,763) Total revenues 36,424,990 35,046,590 34,314,514 (1,378,400) (732,076) Expenditures Instruction 28,388,620 28,399,360 27,671,036 (10,740) 728,324 Attendance and guidance 1,362,030 1,364,130 1,385,574 (2,100) (21,444) Health services 128,060 128,060 211,849 - (83,789) Improvement of instruction and professional development 1,162,780 1,249,780 1,114,649 (87,000) 135,131 Media services 603,400 603,400 604,720 - (1,320) Executive administration 1,062,100 1,062,100 1,190,156 - (128,056) Building level administration 1,611,290 1,611,290 1,594,375 - 16,915 Business services 90,000 90,000 - - 90,000 Adult/community programs 3,480 3,480 3,166 - 314 Total expenditures 34,411,760 34,511,600 33,775,525 (99,840) 736,075 Revenues over expenditures $ 2,013,230 $ 534,990 $ 538,989 $(1,478,240)$ 3,999 The accompanying notes are an integral part of this statement. - 67 -

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, 2021 Budgeted amounts Variances - positive (negative) Original Final Actual (budgetary basis) Original to final Final to actual Revenues Local $34,511,200 $32,692,450 $32,418,245 $(1,818,750)$ (274,205) County 267,070 258,180 258,167 (8,890) (13) State 1,499,550 1,512,240 1,457,571 12,690 (54,669) Federal 51,620 488,170 90,744 436,550 (397,426) Other 95,550 95,550 89,787 - (5,763) Total revenues 36,424,990 35,046,590 34,314,514 (1,378,400) (732,076) Expenditures Instruction 28,388,620 28,399,360 27,671,036 (10,740) 728,324 Attendance and guidance 1,362,030 1,364,130 1,385,574 (2,100) (21,444) Health services 128,060 128,060 211,849 - (83,789) Improvement of instruction and professional development 1,162,780 1,249,780 1,114,649 (87,000) 135,131 Media services 603,400 603,400 604,720 - (1,320) Executive administration 1,062,100 1,062,100 1,190,156 - (128,056) Building level administration 1,611,290 1,611,290 1,594,375 - 16,915 Business services 90,000 90,000 - - 90,000 Adult/community programs 3,480 3,480 3,166 - 314 Total expenditures 34,411,760 34,511,600 33,775,525 (99,840) 736,075 Revenues over expenditures $ 2,013,230 $ 534,990 $ 538,989 $(1,478,240)$ 3,999 The accompanying notes are an integral part of this statement. - 67 - SCHOOL DISTRICT OF CLAYTON NOTES TO REQUIRED SUPPLEMENTARY INFORMATION June 30, 2021 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 2, 2020, 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. - 68 -

Expenditure appropriations lapse at the end of the fiscal year.  Budgeted amounts are as originally adopted on June 2, 2020, 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. - 68 - SCHOOL DISTRICT OF CLAYTON NOTES TO REQUIRED SUPPLEMENTARY INFORMATION June 30, 2021 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 $ 20,794,490 $ 34,314,514 Current year revenue accruals (124,968) (547,891) Prior year revenue accruals (252,903) (200,283) Revenues - modified accrual basis $ 20,416,619 $ 33,566,340 Expenditures Expenditures - cash basis $ 17,521,743 $ 33,775,525 Current year expenditure accruals 70,956 104,255 Prior year expenditure accruals 22,163 (23,650) Expenditures - modified accrual basis $ 17,614,862 $ 33,856,130 - 69 -

SCHOOL DISTRICT OF CLAYTON NOTES TO REQUIRED SUPPLEMENTARY INFORMATION June 30, 2021 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 $ 20,794,490 $ 34,314,514 Current year revenue accruals (124,968) (547,891) Prior year revenue accruals (252,903) (200,283) Revenues - modified accrual basis $ 20,416,619 $ 33,566,340 Expenditures Expenditures - cash basis $ 17,521,743 $ 33,775,525 Current year expenditure accruals 70,956 104,255 Prior year expenditure accruals 22,163 (23,650) Expenditures - modified accrual basis $ 17,614,862 $ 33,856,130 - 69 - SCHOOL DISTRICT OF CLAYTON NET PENSION LIABILITY - UNAUDITED Year ended June 30, 2021 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 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,844,992 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 - 70 -

Open full document View original source Report an error →