Finding 393314 (2022-008)

Material Weakness
Requirement
P
Questioned Costs
-
Year
2022
Accepted
2024-04-16

AI Summary

  • Core Issue: The District's Schedule of Expenditures of Federal Awards was understated by $4,752,800, leading to potential inaccuracies in federal funding reporting.
  • Impacted Requirements: Compliance with 2 CFR §200.510(b) was not met, affecting the detailed reporting of federal programs and expenditures.
  • Recommended Follow-Up: The District should review and update policies to ensure a second review of data before submission to auditors for accuracy.

Finding Text

Noncompliance/Material Weakness – Schedule of Expenditures of Federal Awards 2 CFR §200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $4,752,800. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the District and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.

Categories

Reporting Subrecipient Monitoring Material Weakness Matching / Level of Effort / Earmarking

Other Findings in this Audit

  • 393293 2022-007
    Material Weakness
  • 393294 2022-007
    Material Weakness
  • 393295 2022-007
    Material Weakness
  • 393296 2022-007
    Material Weakness
  • 393297 2022-007
    Material Weakness
  • 393298 2022-008
    Material Weakness
  • 393299 2022-008
    Material Weakness
  • 393300 2022-008
    Material Weakness
  • 393301 2022-008
    Material Weakness
  • 393302 2022-008
    Material Weakness
  • 393303 2022-008
    Material Weakness
  • 393304 2022-008
    Material Weakness
  • 393305 2022-008
    Material Weakness
  • 393306 2022-008
    Material Weakness
  • 393307 2022-008
    Material Weakness
  • 393308 2022-008
    Material Weakness
  • 393309 2022-008
    Material Weakness
  • 393310 2022-008
    Material Weakness
  • 393311 2022-008
    Material Weakness
  • 393312 2022-008
    Material Weakness
  • 393313 2022-008
    Material Weakness
  • 393315 2022-008
    Material Weakness
  • 393316 2022-008
    Material Weakness
  • 393317 2022-008
    Material Weakness
  • 393318 2022-008
    Material Weakness
  • 393319 2022-008
    Material Weakness
  • 393320 2022-008
    Material Weakness
  • 393321 2022-008
    Material Weakness
  • 393322 2022-008
    Material Weakness
  • 393323 2022-008
    Material Weakness
  • 393324 2022-008
    Material Weakness
  • 393325 2022-008
    Material Weakness
  • 969735 2022-007
    Material Weakness
  • 969736 2022-007
    Material Weakness
  • 969737 2022-007
    Material Weakness
  • 969738 2022-007
    Material Weakness
  • 969739 2022-007
    Material Weakness
  • 969740 2022-008
    Material Weakness
  • 969741 2022-008
    Material Weakness
  • 969742 2022-008
    Material Weakness
  • 969743 2022-008
    Material Weakness
  • 969744 2022-008
    Material Weakness
  • 969745 2022-008
    Material Weakness
  • 969746 2022-008
    Material Weakness
  • 969747 2022-008
    Material Weakness
  • 969748 2022-008
    Material Weakness
  • 969749 2022-008
    Material Weakness
  • 969750 2022-008
    Material Weakness
  • 969751 2022-008
    Material Weakness
  • 969752 2022-008
    Material Weakness
  • 969753 2022-008
    Material Weakness
  • 969754 2022-008
    Material Weakness
  • 969755 2022-008
    Material Weakness
  • 969756 2022-008
    Material Weakness
  • 969757 2022-008
    Material Weakness
  • 969758 2022-008
    Material Weakness
  • 969759 2022-008
    Material Weakness
  • 969760 2022-008
    Material Weakness
  • 969761 2022-008
    Material Weakness
  • 969762 2022-008
    Material Weakness
  • 969763 2022-008
    Material Weakness
  • 969764 2022-008
    Material Weakness
  • 969765 2022-008
    Material Weakness
  • 969766 2022-008
    Material Weakness
  • 969767 2022-008
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
10.555 National School Lunch Program $1.70M
84.425 Covid-19 - Elementary and Secondary School Emergency Relief (esser Ii) Fund $1.31M
84.425 Covid-19 - American Rescue Plan - Elementary and Secondary School Emergency Relief (arp Esser) Fund $1.15M
84.027 Special Education-Grants to States (idea, Part B) $800,714
10.553 School Breakfast Program $418,631
84.010 Title I Grants to Local Educational Agencies $311,734
10.555 National School Lunch Program - Food Donation $135,590
84.367 Supporting Effective Instruction State Grants $111,408
10.555 Covid-19 - National School Lunch Program - Cn Covid Food Pro Manf $90,412
32.009 Covid-19 - Emergency Connectivity Fund (ecf) Program - Equipment $60,000
10.555 Covid-19 - National School Lunch Program - Cnp Covid3 Emergency Cst $19,130
84.424 Student Support and Academic Enrichment Program $15,649
84.173 Special Education-Preschool Grants (idea Preschool) $13,661
84.365 English Language Acquisition State Grants - Title III - Language Instruction for English Learners $13,357
84.027 Special Education-Grants to States (idea, Part B) - Restoration $11,594
84.425 Covid-19 - Elementary and Secondary School Emergency Relief (esser) Fund $9,950
84.010 Title I Grants to Local Educational Agencies - Expanding Opportunities for Each Child Non-Competitive Grant $5,673
32.009 Covid-19 - Emergency Connectivity Fund (ecf) Program - Services $5,276
10.649 Covid-19 - State Pandemic Electronic Benefit Transfer (p-Ebt) Administrative Costs Grant $3,063
84.027 Special Education-Grants to States (idea, Part B) - Parent Mentor Project Supplemental $525