Finding 1080952 (2022-011)

Material Weakness
Requirement
P
Questioned Costs
-
Year
2022
Accepted
2024-11-01
Audit: 327070
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 $1,559,951.
  • Impacted Requirements: Compliance with 2 CFR § 200.510(b) was not met, risking future federal funding due to inaccurate reporting.
  • Recommended Follow-Up: The School District should update policies and implement a second review process before submitting the federal schedule to ensure accuracy.

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 $1,559,951. 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.

Categories

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

Other Findings in this Audit

  • 504493 2022-010
    Material Weakness
  • 504494 2022-011
    Material Weakness
  • 504495 2022-011
    Material Weakness
  • 504496 2022-011
    Material Weakness
  • 504497 2022-011
    Material Weakness
  • 504498 2022-011
    Material Weakness
  • 504499 2022-011
    Material Weakness
  • 504500 2022-011
    Material Weakness
  • 504501 2022-011
    Material Weakness
  • 504502 2022-011
    Material Weakness
  • 504503 2022-011
    Material Weakness
  • 504504 2022-011
    Material Weakness
  • 504505 2022-011
    Material Weakness
  • 504506 2022-011
    Material Weakness
  • 504507 2022-011
    Material Weakness
  • 504508 2022-011
    Material Weakness
  • 504509 2022-011
    Material Weakness
  • 504510 2022-011
    Material Weakness
  • 504511 2022-011
    Material Weakness
  • 504512 2022-011
    Material Weakness
  • 504513 2022-011
    Material Weakness
  • 1080935 2022-010
    Material Weakness
  • 1080936 2022-011
    Material Weakness
  • 1080937 2022-011
    Material Weakness
  • 1080938 2022-011
    Material Weakness
  • 1080939 2022-011
    Material Weakness
  • 1080940 2022-011
    Material Weakness
  • 1080941 2022-011
    Material Weakness
  • 1080942 2022-011
    Material Weakness
  • 1080943 2022-011
    Material Weakness
  • 1080944 2022-011
    Material Weakness
  • 1080945 2022-011
    Material Weakness
  • 1080946 2022-011
    Material Weakness
  • 1080947 2022-011
    Material Weakness
  • 1080948 2022-011
    Material Weakness
  • 1080949 2022-011
    Material Weakness
  • 1080950 2022-011
    Material Weakness
  • 1080951 2022-011
    Material Weakness
  • 1080953 2022-011
    Material Weakness
  • 1080954 2022-011
    Material Weakness
  • 1080955 2022-011
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
84.425 Covid-19 - Elementary and Secondary School Emergency Relief (esser Ii) Fund $1.10M
10.555 National School Lunch Program $845,865
84.027 Special Education-Grants to States (idea, Part B) $552,007
32.009 Covid-19 - Emergency Connectivity Fund (ecf) Program - Equipment $391,500
84.010 Title I Grants to Local Educational Agencies $339,150
10.553 School Breakfast Program $297,196
84.425 Covid-19 - Elementary and Secondary School Emergency Relief (esser) Fund $266,346
84.425 Covid-19 - American Rescue Plan - Elementary and Secondary School Emergency Relief (arp Esser) Fund $194,491
84.027 Covid-19 - Special Education-Grants to States (idea, Part B) - Arp $117,380
84.010 Title I Grants to Local Educational Agencies - Delinquent $96,718
10.555 National School Lunch Program - Food Donation $80,792
10.555 Covid-19 - National School Lunch Program - Cn Covid Food Pro Manf $43,538
84.173 Special Education-Preschool Grants (idea Preschool) $15,741
84.010 Title I Grants to Local Educational Agencies - Expanding Opportunities for Each Child Non-Competitive Grant $10,066
84.367 Title II-A Supporting Effective Instruction State Grants $8,100
84.424 Title IV-A Student Support and Academic Enrichment Program $7,867
10.555 Covid-19 - National School Lunch Program - Cnp Covid3 Emergency Cst $3,600
84.365 English Language Acquisition State Grants - Title III - Language Instruction for English Learners $1,873
10.649 Covid-19 - State Pandemic Electronic Benefit Transfer (p-Ebt) Administrative Costs Grant $614