Finding 513447 (2023-006)

Material Weakness
Requirement
B
Questioned Costs
$1
Year
2023
Accepted
2024-12-06

AI Summary

  • Core Issue: The Collaborative failed to provide adequate documentation for employee benefit costs allocated to the Title I program, leading to material noncompliance.
  • Impacted Requirements: Compliance with 2 CFR 200.403 and 2 CFR 200.431 regarding allowable costs and proper allocation of employee benefits.
  • Recommended Follow-Up: Maintain a detailed schedule of salary and benefit costs for each Federal award, ensuring reconciliation with the general ledger and Final Expenditure Report.

Finding Text

Assistance Lising number: 84.010 Program title: Title I Agency: U.S. Department of Education Pass-Through entity: Missouri Department of Elementary and Secondary Education Compliance Requirement: Allowable Costs Type of Finding: Material noncompliance Criteria: In accordance with 2 CFR 200.403, costs must be adequately documented to be allowable under Federal awards. Furthermore, under 2 CFR 200.431 employee benefit costs must be allocated to Federal awards in a manner consistent with the pattern of benefits attributable to the employees whose salaries and wages are chargeable to such Federal awards. Condition: We tested twenty-one transactions for employee benefits totaling $9,801 that were allocated to the Title I program general ledger. The Collaborative could not support these allocations. Cause: The Collaborative did not verify the accuracy of the allocation of employee benefits charged to the Title I general ledger by the payroll system. Effect: The allocation of employee benefit costs to the Title I program was not adequately supported as required by 2 CFR 200.403 for the transactions tested. Questioned costs: $9,801. Context: Total benefits charged to the Title 1 program were $337,839. Repeat finding: Not applicable. Recommendation: We recommend the Collaborative maintain a schedule detailing salary and benefit costs by employee for each Federal award. The Collaborative should recalculate the benefit costs for each employee to ensure their accuracy. Total salaries and benefits on the schedule should then be reconciled to the general ledger and to the Final Expenditure Report submitted to DESE. Views of the responsible officials and planned corrective actions: We will maintain a schedule that details all salary and benefit expenses charged against each Federal award and ensure that these totals are reconciled back to the general ledger and the Final Expenditure Report. We take some exception with this finding, as we believe the audit sample was pulled and formatted in a cumbersome manner and did not facilitate the process of clearly identifying all of the expenditures cited, which often represented portions of benefit costs paid for personnel and reflected in total on related insurance invoices, etc. The Director of Federal Programs and the Payroll Coordinator will be charged with ensuring the accuracy of this information and the related processes moving forward.

Corrective Action Plan

We will maintain a schedule that details all salary and benefit expenses charged against each Federal award and ensure that these totals are reconciled back to the general ledger and the Final Expenditure Report. We take some exception with this finding, as we believe the audit sample was pulled and formatted in a cumbersome manner and did not facilitate the process of clearly identifying all of the expenditures cited, which often represented portions of benefit costs paid for personnel and reflected in total on related insurance invoices, etc. The Director of Federal Programs and the Payroll Coordinator will be charged with ensuring the accuracy of this information and the related processes moving forward.

Categories

Questioned Costs Allowable Costs / Cost Principles

Other Findings in this Audit

  • 1089889 2023-006
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
84.425 Education Stabilization Fund $9.03M
84.010 Title I Grants to Local Educational Agencies $3.72M
10.555 National School Lunch Program $2.07M
10.553 School Breakfast Program $782,542
84.367 Improving Teacher Quality State Grants $394,132
84.424 Student Support and Academic Enrichment Program $349,605
84.287 Twenty-First Century Community Learning Centers $264,532
84.048 Career and Technical Education -- Basic Grants to States $201,819
32.009 Emergency Connectivity Fund Program $65,385
10.582 Fresh Fruit and Vegetable Program $55,182
84.371 Striving Readers $11,200
84.365 English Language Acquisition State Grants $1,878
93.434 Every Student Succeeds Act/preschool Development Grants $1,500
84.027 Special Education_grants to States $147