Finding 982614 (2023-001)

Material Weakness
Requirement
B
Questioned Costs
-
Year
2023
Accepted
2024-07-02
Audit: 311594
Organization: Lowndes County School District (MS)

AI Summary

  • Core Issue: There is a significant weakness in internal controls over compliance, specifically regarding time and effort documentation for Special Education grants.
  • Impacted Requirements: Documentation did not meet federal standards, including timely semi-annual certifications and accurate personnel activity reports.
  • Recommended Follow-Up: Provide training for staff on proper documentation practices to ensure compliance with federal requirements.

Finding Text

Finding 2023-001 Material Weakness in Internal Control Over Compliance and Material Non-Compliance Federal Agency: U. S. Department of Education Pass-Through Entity: Mississippi Department of Education Federal Program: Special Education Cluster Special Education Grants to States 84.027 COVID 19 - Special Education Grants to States 84.027X Special Education Grants to States 84.173 COVID 19 - Special Education Grants to States 84.173X Compliance Requirement: Allowable Costs/Cost Principles Repeat Finding from Prior Audit? No Condition: Controls were not adhered to within the Office of Special Services to endure that time and effort documentation were maintained in accordance with 2 CFR section 200.430 and Appendix B of 2 CFR Part 225 – Selected Items of Cost. Time and effort documentation for Special Education Cluster employees who worked on one cost objective submitted annual certifications instead of the required semi-annual certifications. The following deficiencies were noted regarding personnel activity reports (PAR forms): (1) PAR forms were not reviewed for mathematical accuracy resulting in incorrect percentages of effort by cost objective; (2) comparisons of actual costs to budgeted distributions based on the monthly activity reports were not performed at least quarterly. The lack of review and comparison of actual cost to budget did not result in excess cost to the federal award. (3) the district did not review, and approved PAR forms within the timeline established by the district on a consistent basis. Date and signature documentation on at least one PAR form for each employee tested was signed and dated after the fifth of the following month. Criteria: Title 2 U.S. Code of Federal Regulations (CFR) Part 200.430 – Uniform Administrative Requirements, Cost Principles, and Audit Requirement for Federal Awards (Uniform Guidance) requires charges to federal award for salaries and wages to be based on records that accurately reflect the work performed. These records must (1) be supported by a system of internal controls which provide reasonable assurance that charges are accurate, allowable and properly allocated, (2) reasonably reflect total activity for which the employee is compensated, (3) encompass both federally assisted and all other activities compensated by the entity, (4) support the distribution of the employee’s wages among specific cost objectives if the employee works on more than one federal award, (5) be reconciled with payroll budget estimates with necessary adjustments made to accounting records to ensure that excess costs are not charged to federal programs. In addition, Appendix B of 2 CFR Part 225 – Selected Items of Cost requires: (1) Where employees are expected to work solely on a single Federal award or cost objective, charges for their salaries and wages will be supported by periodic certifications that the employees worked solely on that program for the period covered by the certification. These certifications will be prepared at least semi-annually and will be signed by the employee or supervisory official having firsthand knowledge of the work performed by the employee. (2) Where employees work on multiple activities or cost objectives, a distribution of their salaries or wages will be supported by personnel activity reports. These reports must meet the following standards: (a) They must reflect an after-the-fact distribution of the actual activity of each employee, (b) They must account for the total activity for which each employee is compensated, (c) They must be prepared at least monthly and must coincide with one or more pay periods, and (d) They must be signed by the employee. (e) Budget estimates or other distribution percentages determined before the services are performed do not qualify as support for charges to Federal awards but may be used for interim accounting purposes, provided that: (i) The governmental unit's system for establishing the estimates produces reasonable approximations of the activity actually performed; (ii) At least quarterly, comparisons of actual costs to budgeted distributions based on the monthly activity reports are made. Costs charged to Federal awards to reflect adjustments made as a result of the activity actually performed may be recorded annually if the quarterly comparisons show the differences between budgeted and actual costs are less than ten percent; and (iii) The budget estimates or other distribution percentages are revised at least quarterly, if necessary, to reflect changed circumstances. Cause: A lack of oversight by program personnel resulted in documentation for time and effort reporting to not conform to requirements of set forth in 2 CFR 200.430 and Appendix B of 2 CFR Part 225. Effect: Failure to timely and properly prepare and review time and effort reporting could allow for improper charges to be made to the federal award which could result in disallowed charges to the program. Context: Fifteen (15) of fifteen (15) semi-annual certifications examined were prepared for the entire school year instead of on a semi-annual basis. Two personnel activity reports for one employee were not signed by the immediate supervisor. At one or more PAR forms for eight (8) of the eight employees monthly PAR reports tested were not signed and approved timely as defined by the district procedures. Repeat Finding: This is not a repeat finding. Auditor’s Recommendation: The school district should provide training to all employees working on Special Education grants to educate them on the requirements for documenting personnel time and effort both for semi-annual certifications and personnel activity reports. View of Responsible Officials and Planned Corrective Actions: See Auditee’s Corrective Action Plan

Categories

Allowable Costs / Cost Principles Internal Control / Segregation of Duties

Other Findings in this Audit

  • 406172 2023-001
    Material Weakness
  • 406173 2023-001
    Material Weakness
  • 406174 2023-001
    Material Weakness
  • 406175 2023-001
    Material Weakness
  • 982615 2023-001
    Material Weakness
  • 982616 2023-001
    Material Weakness
  • 982617 2023-001
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
84.425 Education Stabilization Fund $3.71M
84.010 Title I Grants to Local Educational Agencies $1.51M
10.553 School Breakfast Program $690,387
84.367 Improving Teacher Quality State Grants $244,466
84.027 Special Education_grants to States $236,676
10.555 National School Lunch Program $175,766
84.358 Rural Education $144,318
84.424 Student Support and Academic Enrichment Program $117,639
84.421 Disability Innovation Fund (dif) $88,189
84.048 Career and Technical Education -- Basic Grants to States $82,354
12.U01 Reserve Officers Training Corps $67,981
93.778 Medical Assistance Program $59,271
84.377 School Improvement Grants $21,662
10.579 Child Nutrition Discretionary Grants Limited Availability $20,781
84.173 Special Education_preschool Grants $16,068
10.560 State Administrative Expenses for Child Nutrition $8,465
96.001 Social Security_disability Insurance $658