Finding 1081951 (2024-002)

Significant Deficiency
Requirement
AB
Questioned Costs
$1
Year
2024
Accepted
2024-11-13
Audit: 328203

AI Summary

  • Core Issue: The District lacked adequate internal controls over the ESSER grant, leading to unallowable costs and inconsistent application of indirect costs.
  • Impacted Requirements: Costs must be necessary, reasonable, and well-documented, as per federal guidelines (2 CFR Part 200.403 and 200.303).
  • Recommended Follow-Up: Strengthen internal controls by implementing detailed reviews of all expenditures and supporting documentation for federal grants.

Finding Text

Finding: Allowable Costs and Allowable Activities Federal Assistance Listing Number 84.425U – COVID-19 – Elementary and Secondary School Emergency Relief Fund (ESSER III) Department of Education, Passed-Through Colorado Department of Education Award Number – 4414/4431/9414; Award Year 2021 Criteria: According to 2 CFR Part 200.403 factors affecting allowability of costs – costs must meet the following general criteria in order to be allowable under Federal awards: (a) be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles, (b) conform to any limitations or exclusions set forth in these principles or in the Federal award as to types or amount of cost items, (c) be consistent with policies and procedures that apply uniformly to both federally-financed and other activities of the non-Federal entity, (d) be accorded consistent treatment, (e) be determined in accordance with generally accepted accounting principles, (f) to be included as a cost or used to meet cost sharing or matching requirements of any other federally-financed program in either the current or a prior period and (g) be adequately documented. In addition, according to 2 CFR Part 200.303, the non-Federal entity must 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. Condition: During our testing we noted the following: a. 3 out of the 25 payroll selections applied to the grant did not agree back to supporting payroll information. b. The indirect costs applied to the grant were not consistently applied between the quarters of the fiscal year due to variations in the indirect cost base used. Questioned Costs: a. $2,089. Questioned costs were determined by reviewing the payroll registers for the three impacted selections. b. None. The District under applied the amount of indirect costs allowable to the grant. Context: a. We tested 25 payroll, 25 nonpayroll and 25 fringe benefit transactions applied to the grant for the year ended June 30, 2024. The tested population covered expenditures of $7.1 million and the total population of expenditures were approximately $24.4 million. A non-statistical sampling methodology was used to select the sample. b. We tested the four quarters indirect costs calculations which were applied to the above grant award numbers for the year ended June 30, 2024. The tested population covered expenditures of $3.0 million and the total population of expenditures were approximately $3.1 million. A non-statistical sampling methodology was used to select the sample. Effect: The District did not have adequate internal controls in place over the ESSER grant which resulted in unallowable costs being applied to the grant and inconsistently applying indirect costs to the grant. Cause: The District continued to experience turnover within the positions overseeing grants during fiscal year 2024. There were not detailed reviews over the calculations and supporting documentation used to determine the expenditure amount to be applied to the grant. Identification as a Repeat Finding: Not applicable. Recommendation: We recommend that the District strengthen the internal controls surrounding review of all expenditures applied against federal grants including the supporting detail or calculations used to determine the expenditure amount to help ensure it recalculates and is consistent with District polices and procedures. Views of Responsible Officials: We agree with the finding. See separate report for planned corrective actions.

Categories

Questioned Costs Allowable Costs / Cost Principles Matching / Level of Effort / Earmarking

Other Findings in this Audit

  • 505509 2024-002
    Significant Deficiency
  • 505510 2024-003
    Significant Deficiency
  • 1081952 2024-003
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
84.425 Elementary and Secondary School Emergency Relief Fund (esser Iii) $27.74M
84.010 Title I $9.48M
10.555 National School Lunch Program $6.98M
84.027 Title Vi-B Idea Special Education $6.56M
10.553 National School Breakfast Program $1.74M
84.367 Title II Part A Training & Recruiting-Improving Teacher Quality $1.31M
10.555 National School Lunch Program- Donated Commodities $922,832
84.424 Title IV Student Support and Academic Enrichment $748,681
84.002 Adult Education $640,444
84.041 Impact Aid $587,588
84.425 Elementary and Secondary School Emergency Relief Fund (esser Ii) $513,512
93.243 Project Aware Colorado $474,892
97.036 Fema - Div. Homeland Sec & Emergency Management $329,425
10.559 Summer Lunch Program $320,923
10.185 Local Food for Schools (lfs) Cooperative $313,744
84.425 Esser III Crssa 9.5% State Set-Aside, High-Impact Tutoring $271,632
84.048 Perkins Grant-Career and Technical Education $232,296
84.365 Title III Part A English Language Acquisition $179,399
84.173 Title Vi-B Idea Preschool $166,483
84.425 Esser III Arp 9.5% State Set-Aside-21st Cclc E3 Summer $147,781
84.425 Covid-19 - Elementary and Secondary School Emergency Relief Fund Supplemental (esser Iii) $109,855
93.556 Cresl - Refugee English Language Acquisition-Promoting Safe and Stable Families $107,160
84.425 Geer II - Governor's Emergency Education Relief Fund: Bright Spot Award $97,155
84.048 Strengthening Career and Technical Education for the 21st Century Act (perkins V) $85,894
84.425 Arp Hcy I/ii $70,460
84.424F Stronger Connections $46,316
21.027 Coronavirus State and Local Fiscal Recovery Funds $33,982
84.060 Title Vi A - Indian Education $32,718
93.558 Cresl - Temporary Assistance for Needy Families $23,752
10.558 Child & Adult Care Food Program $15,753