Finding 1149842 (2023-010)

Material Weakness Repeat Finding
Requirement
P
Questioned Costs
-
Year
2023
Accepted
2025-08-13
Audit: 364161
Organization: Batavia Local School District (OH)

AI Summary

  • Core Issue: The School District's Schedule of Expenditures of Federal Awards was inaccurate, with total federal expenditures understated by $675,306.
  • Impacted Requirements: Compliance with 2 CFR § 200.510(b) was not met, risking inaccurate federal expenditure reporting and potential jeopardy to future federal funding.
  • Recommended Follow-Up: The School District should review and update policies and procedures, including implementing a second review of data before submitting the federal schedule to auditors.

Finding Text

Material Weakness/Noncompliance – 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 School District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $675,306. Adjustments were made to the Schedule of Expenditures of Federal Awards. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the School District and could jeopardize future federal funding. We recommend the School 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. Officials' Response: See Corrective Action Plan

Categories

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

Other Findings in this Audit

  • 573390 2023-010
    Material Weakness Repeat
  • 573391 2023-010
    Material Weakness Repeat
  • 573392 2023-010
    Material Weakness Repeat
  • 573393 2023-010
    Material Weakness Repeat
  • 573394 2023-010
    Material Weakness Repeat
  • 573395 2023-010
    Material Weakness Repeat
  • 573396 2023-010
    Material Weakness Repeat
  • 573397 2023-010
    Material Weakness Repeat
  • 573398 2023-010
    Material Weakness Repeat
  • 573399 2023-010
    Material Weakness Repeat
  • 573400 2023-010
    Material Weakness Repeat
  • 573401 2023-010
    Material Weakness Repeat
  • 573402 2023-010
    Material Weakness Repeat
  • 573403 2023-010
    Material Weakness Repeat
  • 573404 2023-010
    Material Weakness Repeat
  • 573405 2023-010
    Material Weakness Repeat
  • 573406 2023-010
    Material Weakness Repeat
  • 573407 2023-010
    Material Weakness Repeat
  • 1149832 2023-010
    Material Weakness Repeat
  • 1149833 2023-010
    Material Weakness Repeat
  • 1149834 2023-010
    Material Weakness Repeat
  • 1149835 2023-010
    Material Weakness Repeat
  • 1149836 2023-010
    Material Weakness Repeat
  • 1149837 2023-010
    Material Weakness Repeat
  • 1149838 2023-010
    Material Weakness Repeat
  • 1149839 2023-010
    Material Weakness Repeat
  • 1149840 2023-010
    Material Weakness Repeat
  • 1149841 2023-010
    Material Weakness Repeat
  • 1149843 2023-010
    Material Weakness Repeat
  • 1149844 2023-010
    Material Weakness Repeat
  • 1149845 2023-010
    Material Weakness Repeat
  • 1149846 2023-010
    Material Weakness Repeat
  • 1149847 2023-010
    Material Weakness Repeat
  • 1149848 2023-010
    Material Weakness Repeat
  • 1149849 2023-010
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
84.027 Special Education-Grants to States (idea, Part B) $572,731
10.555 National School Lunch Program $547,680
84.425 Covid-19 - American Rescue Plan - Elementary and Secondary School Emergency Relief (arp Esser) Fund $463,151
84.010 Title I Grants to Local Educational Agencies $365,698
84.425 Covid-19 - Elementary and Secondary School Emergency Relief (esser Ii) Fund $221,445
10.553 School Breakfast Program $183,118
84.010 Title I Grants to Local Educational Agencies - Delinquent $84,048
10.555 National School Lunch Program - Food Donation $82,285
10.555 Covid-19 - National School Lunch Program - Cn Covid Food Pro Manf $66,731
84.424 Title IV-A Student Support and Academic Enrichment Program $37,376
84.173 Special Education-Preschool Grants (idea Preschool) $15,708
84.173 Covid-19 - Arp Special Education-Preschool Grants (idea Preschool) $8,691
84.365 English Language Acquisition State Grants - Title III - Language Instruction for English Learners $2,988
10.649 Covid-19 - State Pandemic Electronic Benefit Transfer (p-Ebt) Administrative Costs Grant $628
84.425 Covid-19 - American Rescue Plan - Elementary and Secondary School Emergency Relief (arp Esser) Fund - Homeless Round II $200