Citation in context

#q1de5
audit · claytonschools

finance 2019 2020 Audited Financial Report

2019-07-01 Portal: claytonschools Section: 2. District's Other Risk #q1de5

REQUIRED SUPPLEMENTARY INFORMATION 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, 2020 Budgeted amounts Variances - positive (negative) Original Final Actual (budgetary basis) Original to final Final to actual Revenues Local $ 19,194,740 $ 21,272,760 $ 21,830,042 $ 2,078,020 $ 557,282 County 115,000 123,380 123,380 8,380 - State 228,090 246,610 298,576 18,520 51,966 Federal 320,120 436,820 318,606 116,700 (118,214) Other 4,000 4,000 11,173 - 7,173 Total revenues 19,861,950 22,083,570 22,581,777 2,221,620 498,207 Expenditures Instruction 2,999,270 2,922,890 2,267,824 76,380 655,066 Attendance and guidance 789,590 796,570 721,902 (6,980) 74,668 Health services 461,550 593,100 479,137 (131,550) 113,963 Improvement of instruction and professional development 541,720 520,150 293,758 21,570 226,392 Media services 398,500 399,720 353,846 (1,220) 45,874 Board of Education services 209,370 222,820 224,451 (13,450) (1,631) Executive administration 1,572,960 1,571,560 1,498,528 1,400 73,032 Building level administration 1,108,750 1,106,020 1,083,147 2,730 22,873 Operation of plant 7,697,330 7,875,260 7,407,529 (177,930) 467,731 Security services 238,770 238,770 171,295 - 67,475 Nonallowable transportation 223,250 217,390 195,273 5,860 22,117 Food services 1,203,280 1,203,280 883,025 - 320,255 Business services 1,036,160 1,008,580 933,871 27,580 74,709 Central office support services 452,670 469,800 401,644 (17,130) 68,156 Adult/community programs 1,063,920 1,078,730 1,137,983 (14,810) (59,253) Total expenditures 19,997,090 20,224,640 18,053,213 (227,550) 2,171,427 Revenues over (under) expenditures $ (135,140) $ 1,858,930 $ 4,528,564 $ 1,994,070 $ 2,669,634 The accompnaying 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 - GENERAL FUND - UNAUDITED Year ended June 30, 2020 Budgeted amounts Variances - positive (negative) Original Final Actual (budgetary basis) Original to final Final to actual Revenues Local $ 19,194,740 $ 21,272,760 $ 21,830,042 $ 2,078,020 $ 557,282 County 115,000 123,380 123,380 8,380 - State 228,090 246,610 298,576 18,520 51,966 Federal 320,120 436,820 318,606 116,700 (118,214) Other 4,000 4,000 11,173 - 7,173 Total revenues 19,861,950 22,083,570 22,581,777 2,221,620 498,207 Expenditures Instruction 2,999,270 2,922,890 2,267,824 76,380 655,066 Attendance and guidance 789,590 796,570 721,902 (6,980) 74,668 Health services 461,550 593,100 479,137 (131,550) 113,963 Improvement of instruction and professional development 541,720 520,150 293,758 21,570 226,392 Media services 398,500 399,720 353,846 (1,220) 45,874 Board of Education services 209,370 222,820 224,451 (13,450) (1,631) Executive administration 1,572,960 1,571,560 1,498,528 1,400 73,032 Building level administration 1,108,750 1,106,020 1,083,147 2,730 22,873 Operation of plant 7,697,330 7,875,260 7,407,529 (177,930) 467,731 Security services 238,770 238,770 171,295 - 67,475 Nonallowable transportation 223,250 217,390 195,273 5,860 22,117 Food services 1,203,280 1,203,280 883,025 - 320,255 Business services 1,036,160 1,008,580 933,871 27,580 74,709 Central office support services 452,670 469,800 401,644 (17,130) 68,156 Adult/community programs 1,063,920 1,078,730 1,137,983 (14,810) (59,253) Total expenditures 19,997,090 20,224,640 18,053,213 (227,550) 2,171,427 Revenues over (under) expenditures $ (135,140) $ 1,858,930 $ 4,528,564 $ 1,994,070 $ 2,669,634 The accompnaying 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, 2020 Budgeted amounts Variances - positive (negative) Original Final Actual (budgetary basis) Original to final Final to actual Revenues Local $34,210,270 $36,004,380 $37,159,405 $ 1,794,110 $ 1,155,025 County 247,000 281,770 281,774 34,770 4 State 1,405,960 1,429,440 1,417,715 23,480 (11,725) Federal 142,090 123,980 122,782 (18,110) (1,198) Other 165,620 140,140 120,485 (25,480) (19,655) Total revenues 36,170,940 37,979,710 39,102,161 1,808,770 1,122,451 Expenditures Instruction 28,233,790 27,871,190 27,041,280 362,600 829,910 Attendance and guidance 1,324,410 1,324,410 1,346,623 - (22,213) Health services 124,680 124,680 158,637 - (33,957) Improvement of instruction and professional development 627,200 1,002,140 970,505 (374,940) 31,635 Media services 587,790 587,790 588,093 - (303) Executive administration 1,048,950 1,048,950 1,050,968 - (2,018) Building level administration 1,569,410 1,569,410 1,594,989 - (25,579) Business services 90,000 80,540 - 9,460 80,540 Central office support services 5,800 5,800 - - 5,800 Adult/community programs 3,480 3,480 3,600 - (120) 33,615,510 33,618,390 32,754,695 (2,880) 863,695 Total expenditures Revenues over expenditures $ 2,555,430 $ 4,361,320 $ 6,347,466 $ 1,805,890 $ 1,986,146 The accompnaying 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, 2020 Budgeted amounts Variances - positive (negative) Original Final Actual (budgetary basis) Original to final Final to actual Revenues Local $34,210,270 $36,004,380 $37,159,405 $ 1,794,110 $ 1,155,025 County 247,000 281,770 281,774 34,770 4 State 1,405,960 1,429,440 1,417,715 23,480 (11,725) Federal 142,090 123,980 122,782 (18,110) (1,198) Other 165,620 140,140 120,485 (25,480) (19,655) Total revenues 36,170,940 37,979,710 39,102,161 1,808,770 1,122,451 Expenditures Instruction 28,233,790 27,871,190 27,041,280 362,600 829,910 Attendance and guidance 1,324,410 1,324,410 1,346,623 - (22,213) Health services 124,680 124,680 158,637 - (33,957) Improvement of instruction and professional development 627,200 1,002,140 970,505 (374,940) 31,635 Media services 587,790 587,790 588,093 - (303) Executive administration 1,048,950 1,048,950 1,050,968 - (2,018) Building level administration 1,569,410 1,569,410 1,594,989 - (25,579) Business services 90,000 80,540 - 9,460 80,540 Central office support services 5,800 5,800 - - 5,800 Adult/community programs 3,480 3,480 3,600 - (120) 33,615,510 33,618,390 32,754,695 (2,880) 863,695 Total expenditures Revenues over expenditures $ 2,555,430 $ 4,361,320 $ 6,347,466 $ 1,805,890 $ 1,986,146 The accompnaying notes are an integral part of this statement. - 66 - SCHOOL DISTRICT OF CLAYTON NOTES TO REQUIRED SUPPLEMENTARY INFORMATION June 30, 2020 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 5, 2019, 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. - 67 -

Expenditure appropriations lapse at the end of the fiscal year.  Budgeted amounts are as originally adopted on June 5, 2019, 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. - 67 - SCHOOL DISTRICT OF CLAYTON NOTES TO REQUIRED SUPPLEMENTARY INFORMATION June 30, 2020 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,581,777 $ 39,102,161 Current year revenue accruals 319,356 200,282 Prior year revenue accruals (326,058) (174,792) Revenues - modified accrual basis $ 22,575,075 $ 39,127,651 Expenditures Expenditures - cash basis $ 18,053,213 $ 32,754,695 Current year expenditure accruals 44,292 23,650 Prior year expenditure accruals (129,258) (109,063) Expenditures - modified accrual basis $ 17,968,247 $ 32,669,282 - 68 -

SCHOOL DISTRICT OF CLAYTON NOTES TO REQUIRED SUPPLEMENTARY INFORMATION June 30, 2020 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,581,777 $ 39,102,161 Current year revenue accruals 319,356 200,282 Prior year revenue accruals (326,058) (174,792) Revenues - modified accrual basis $ 22,575,075 $ 39,127,651 Expenditures Expenditures - cash basis $ 18,053,213 $ 32,754,695 Current year expenditure accruals 44,292 23,650 Prior year expenditure accruals (129,258) (109,063) Expenditures - modified accrual basis $ 17,968,247 $ 32,669,282 - 68 - SCHOOL DISTRICT OF CLAYTON NET PENSION LIABILITY - UNAUDITED Year ended June 30, 2020 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 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 - 69 -

Open full document View original source Report an error →