Finding 194 (2023-001)

Material Weakness
Requirement
ABCEFGHIJLMNP
Questioned Costs
-
Year
2023
Accepted
2023-10-19
Audit: 314
Auditor: Mjco LLC

AI Summary

  • Core Issue: The School has a material weakness due to inadequate tracking of federal award expenditures, leading to an incomplete Schedule of Expenditures of Federal Awards (SEFA).
  • Impacted Requirements: Compliance with 2 CFR sections 200.510(b) and 200.502 regarding proper accounting and reporting of federal expenditures.
  • Recommended Follow-Up: Establish a robust process for tracking federal award expenditures to ensure accurate and timely SEFA preparation and compliance with Uniform Guidance.

Finding Text

Internal Control Impact: Materail weakness. Repeat Finding: No. Questioned Costs: No. Criteria: 2 CFR section 200.510(b) requires the auditee to prepare a Schedule of Expenditures of Federal Awards (SEFA) that must contain all federal awards expended during the period. 2 CFR section 200.502 requires proper tracking and accounting of federal expenditures incurred under the same basis of accounting as the basic financial statements to ensure proper cutoff and reporting. Condition: The School did not adequately track its expenditures of federal awards and did not prepare a complete SEFA as of the year end. Cause: The School did not have an adequate process to track expenditures of federal awards. This resulted in the School not being aware that they had expended more than $750,000 of federal awards during the year and would be subject to the Uniform Guidance. Effect: Failure to adequately track expenditures of federal awards could result in the SEFA being prepared inaccurately or in an untimely manner. Recommendation: Marshall Jones recommends that the School establish a process to track the expenditures of federal awards during the year. This will help the School to be aware of crossing the Uniform Guidance threshold, enabling the School to prepare the SEFA accurately and timely. Views of Responsible Officials: Management of the School concurs with the finding. Please refer to the Corrective Action Plan.

Corrective Action Plan

Description of Finding: The school did not adequately track its expenditures of federal awards and did not prepare a complete SEFA as of the year end. Statement of Concurrence or Nonconcurrence: The school agrees with the audit finding as presented. Corrective Action: While the school’s chart of accounts includes specific accounts for grants and Title I funds, the chart of accounts did not explicitly list all federal revenue (Title I, ESSER Grant, USDA, and Federal Facility Grant). The school has already updated the chart of accounts to account for all federal funds with appropriate identification of revenue sources. This will allow the school to accurately account for monthly revenue and expenditures relating to federal funding sources, along with accurate monthly financial reporting of federal fund usage and expenses. Name of Contact Person: Chaz Patterson-Ellis, Chief Financial Officer, 678-466-7300, chaz.patterson@chatthillscharter.org. Projected Completion Date: Sept 30, 2023. Chaz Patterson-Ellis, Chief Financial Officer.

Categories

Reporting

Other Findings in this Audit

  • 576636 2023-001
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
84.425 Education Stabilization Fund $439,704
84.010 Title I Grants to Local Educational Agencies $188,416
10.555 National School Lunch Program $127,704
10.553 School Breakfast Program $55,911
10.912 Environmental Quality Incentives Program $30,000