Finding 526747 (2024-003)

Material Weakness Repeat Finding
Requirement
AB
Questioned Costs
-
Year
2024
Accepted
2025-03-12

AI Summary

  • Core Issue: The Organization incorrectly calculated the 8% indirect cost rate based on budgeted amounts instead of actual direct costs incurred.
  • Impacted Requirements: Compliance with federal cost principles and internal control standards, specifically 2 CFR 200.303(a) and Iowa Department of Education guidelines.
  • Recommended Follow-Up: Management should enhance procedures to ensure indirect costs are allocated based on actual direct costs and remain within the allowable limits.

Finding Text

Department of Education and Passed through State of Iowa Department of Education Federal Financial Assistance Listing #84.287, C14-SHIP, C15-SHIP, C16-SHIP, C17-SHIP, C18-SHIP, 7/1/2023 – 6/30/2024 Twenty-First Century Community Learning Centers Program Activities Allowed or Unallowed and Allowable Costs/Cost Principles Material Weakness in Internal Control over Compliance Criteria: The Organization is required to have procedures in place to ensure that federal awards are expended only for allowable costs in accordance with Subpart E – Cost Principles of the Uniform Guidance. Allowable costs are supported by appropriate documentation and correctly charged as to account, amount, and period. 2 CFR 200.303(a) establishes that the auditee must establish and maintain effective internal control over the federal award that provides assurance that the entity is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. The Iowa Department of Education Guide to Program Budgets and Accounting for the 21st Century Community Learning Centers program provides that an organization participating in the program may expend no more than 8 percent of annual funding on general administration and indirect costs. Further, indirect costs are to be recovered only to the extent of direct costs incurred. Condition: Through review of indirect costs charged to the federal awards, we noted the Organization charged an 8% administrative indirect cost rate to the federal awards, however, calculated the 8% on the budgeted grant award rather than on the actual direct costs incurred under the federal award for the first three quarters of the grant period. Cause: The Organization was not aware that the indirect cost rate should be applied pro rata to the underlying direct costs prior to the completion of the prior year audit. Effect: The Organization’s controls did not detect or correct the errors identified. Questioned Costs: No questioned costs over $25,000. Context: Two quarters out of four quarters of indirect costs charged to the federal awards were selected for testing, which accounted for $17,547 of $44,268 total indirect costs charged to the federal award. Repeat Finding from Prior Year: Yes, Finding 2023-003 Recommendation: We acknowledge the Organization revised their procedures following the prior year audit. We recommend management continue to review procedures over the allocation of indirect costs to ensure indirect amounts charged to the program are based on actual underlying direct costs and that the total indirect allocation of general administration costs does not exceed the rate allowed by the federal program. Views of Responsible Officials: Management is in agreement.

Corrective Action Plan

Federal Agency Name: Department of Education Pass‐through Entity: State of Iowa Department of Education Assistance Listing Number: 84.287 Program Name: Twenty‐First Century Community Learning Centers Program Finding Summary: Through review of indirect costs charged to the federal awards, our auditors noted that we charged an 8% administrative indirect cost rate to the federal awards, however, calculated the 8% on the budgeted grant award rather than on the actual direct costs incurred under the federal award for the first three quarters of the grant period. Corrective Action Plan: Resolved. Procedures were placed into service following the prior year audit to ensure indirect amounts charged to the program are based on actual underlying direct costs and the total indirect allocation of general administration costs do not exceed the rate allowed by the federal program. All claims submitted for 21st Century grants in the third and fourth quarter of Fiscal Year 2024 were reviewed to ensure the administrative indirect cost is assigned to direct expenses only. Also, in the third quarter the previous two quarters were corrected to result in an overall fiscal year of indirect costs of 8% on expenditures. Responsible Individual: Mindy Baylor, Director of Finance Anticipated Completion Date: Resolved

Categories

Allowable Costs / Cost Principles

Other Findings in this Audit

  • 526748 2024-004
    Material Weakness
  • 526749 2024-005
    Material Weakness
  • 526750 2024-006
    Material Weakness
  • 526751 2024-007
    Material Weakness
  • 1103189 2024-003
    Material Weakness Repeat
  • 1103190 2024-004
    Material Weakness
  • 1103191 2024-005
    Material Weakness
  • 1103192 2024-006
    Material Weakness
  • 1103193 2024-007
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
17.270 Reentry Employment Opportunities $576,735
84.287 Twenty-First Century Community Learning Centers $576,612
16.812 Second Chance Act Reentry Initiative $342,592
16.818 Children Exposed to Violence $215,852
93.556 Marylee Allen Promoting Safe and Stable Families Program $171,778
93.243 Substance Abuse and Mental Health Services Projects of Regional and National Significance $139,140
93.669 Child Abuse and Neglect State Grants $23,487
93.558 Temporary Assistance for Needy Families $18,256
16.540 Juvenile Justice and Delinquency Prevention $12,122