Finding 50108 (2022-005)

Material Weakness
Requirement
AB
Questioned Costs
$1
Year
2022
Accepted
2023-03-26

AI Summary

  • Core Issue: The School Corporation lacked effective internal controls over grant compliance, leading to potential overpayments and noncompliance with federal requirements.
  • Impacted Requirements: Noncompliance with 2 CFR 200.303 and 2 CFR 200.403 regarding allowable costs and internal controls, resulting in questioned costs of $106,755.
  • Recommended Follow-Up: Ensure insurance proceeds are applied to costs before using federal funds and enhance payroll disbursement controls through regular reviews of detailed reports.

Finding Text

FINDING 2022-005 Subject: COVID-19 ? Education Stabilization Fund ? Activities Allowed or Unallowed, Allowable Costs/Cost Principles Federal Agency: Department of Education Federal Program: COVID-19 ? Education Stabilization Fund Assistance Listing Number: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425U200013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Activities Allowed or Unallowed, Allowable Costs/Cost Principles Audit Findings: Material Weakness, Material Noncompliance Criteria: 2 CFR 200.303 states in part: "The non-Federal entity must: (b) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.403 states in part: "Except where otherwise authorized by statute, costs must meet the following general criteria in order to be allowable under Federal awards: (c) Be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles. (d) Conform to any limitations or exclusions set forth in these principles or in the Federal award as to types or amount of cost items. . . . (h) Be adequately documented. . . . Condition: An effective internal control system was not in place at the School Corporation to ensure compliance with the requirements related to the grant agreement and the Activities Allowed or Unallowed and Allowable Costs/Cost Principles compliance requirements. Cause: (a) The School Corporation planned to utilize a portion of the grant funds for chiller repairs and included the costs in the award budget. The School Corporation subsequently also received insurance proceeds for a portion of the repair costs. (b) The School Corporation's management had not designed or implemented internal controls over payroll disbursements which would have ensured compliance with the compliance requirements listed above. Effect: (a) The School Corporation received a grant payment for expenses that were subsequently also recovered from insurance proceeds. Therefore, the school has overdrawn ARP ESSER funds by that amount. Noncompliance with the grant agreement and the compliance requirements could result in the future loss of funds to the School Corporation. (b) The failure to establish an effective internal control system over payroll disbursements could enable material noncompliance to go undetected. Noncompliance with the grant agreement and the compliance requirements listed above could have resulted in the loss of funds to the School Corporation. Questioned Costs: Known questioned costs of $106,755 were identified. Context: (a) During allowable cost testing for vendor disbursements, we noted a portion of ARP ESSER funds were utilized to repair the chiller at the middle and high schools. The School Corporation incurred a total of approximately $284,000 in chiller repair costs between September 2021 and May 2022 and requested reimbursement for those expenditures from ARP ESSER funds in full. In October 2021, the School Corporation received an insurance claim check in the amount of $106,755 to cover a portion of the repair costs. The School Corporation did not deduct the amount received through insurance from the amount requested for reimbursement from federal funds, resulting in an overpayment of federal funds during the audit period. (b) Additionally, the School Corporation had not properly designed or implemented internal controls over recording transactions for payroll and fringe benefit disbursements to ensure the accuracy and classification of the payroll disbursements. Payroll disbursements make up approximately 45% of the program costs charged to the Education Stabilization Fund. One employee was responsible for processing payroll. Payroll reports were submitted to the School Board and Treasurer for review and approval; however, the reports only provided a total gross amount paid from each fund. The reports did not list the employees who were paid from the fund. In March 2021, the Treasurer implemented a review of the payroll distribution report, which is broken out by fund and individual employee. The lack of controls related to payroll disbursements was isolated to the 2020-2021 year. Identification as a repeat finding, if applicable: No Recommendation: (a) We recommend management ensure any insurance proceeds or non-federal sources of funding are applied first to costs incurred before charging the costs to federal awards. (b) We recommend management continue to document controls surrounding payroll disbursement through review of the payroll distribution report each pay period. Views of Responsible Officials: Management agrees with the finding and has prepared a corrective action plan.

Categories

Questioned Costs Allowable Costs / Cost Principles

Other Findings in this Audit

  • 50097 2022-004
    Material Weakness Repeat
  • 50098 2022-004
    Material Weakness Repeat
  • 50099 2022-004
    Material Weakness Repeat
  • 50100 2022-004
    Material Weakness Repeat
  • 50101 2022-008
    Material Weakness Repeat
  • 50102 2022-009
    Material Weakness Repeat
  • 50103 2022-008
    Material Weakness Repeat
  • 50104 2022-008
    Material Weakness Repeat
  • 50105 2022-005
    Material Weakness
  • 50106 2022-006
    Material Weakness
  • 50107 2022-007
    Material Weakness
  • 50109 2022-006
    Material Weakness
  • 50110 2022-007
    Material Weakness
  • 50111 2022-005
    Material Weakness
  • 50112 2022-006
    Material Weakness
  • 626539 2022-004
    Material Weakness Repeat
  • 626540 2022-004
    Material Weakness Repeat
  • 626541 2022-004
    Material Weakness Repeat
  • 626542 2022-004
    Material Weakness Repeat
  • 626543 2022-008
    Material Weakness Repeat
  • 626544 2022-009
    Material Weakness Repeat
  • 626545 2022-008
    Material Weakness Repeat
  • 626546 2022-008
    Material Weakness Repeat
  • 626547 2022-005
    Material Weakness
  • 626548 2022-006
    Material Weakness
  • 626549 2022-007
    Material Weakness
  • 626550 2022-005
    Material Weakness
  • 626551 2022-006
    Material Weakness
  • 626552 2022-007
    Material Weakness
  • 626553 2022-005
    Material Weakness
  • 626554 2022-006
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
84.425 Covid-19 - Education Stabilization Fund $608,464
10.553 School Breakfast Program $217,534
84.027 Special Education_grants to States $213,439
10.555 National School Lunch Program $107,401
84.010 Title I Grants to Local Educational Agencies $83,469
93.778 Medical Assistance Program $60,319
84.358 Rural Education $22,583
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $11,217
84.173 Special Education_preschool Grants $10,888
84.424 Student Support and Academic Enrichment Program $9,576
10.559 Summer Food Service Program for Children $5,250
84.367 Supporting Effective Instruction State Grants $4,000