Finding 496449 (2023-002)

Material Weakness Repeat Finding
Requirement
P
Questioned Costs
-
Year
2023
Accepted
2024-09-11
Audit: 319370
Organization: Madison-Carver Academy (MI)

AI Summary

  • Core Issue: The Academy did not effectively monitor its general ledger, leading to incomplete and inaccurate financial reports.
  • Impacted Requirements: Timeliness and accuracy of financial statements were compromised, resulting in numerous auditor-proposed journal entries.
  • Recommended Follow-Up: Establish a monitoring procedure with designated individuals for each account to ensure thorough oversight and accurate financial reporting.

Finding Text

Criteria The Academy should have appropriate overall monitoring of the general ledger to ensure timely and accurate financial statements. Condition The Academy lacked appropriate overall monitoring of account balances during the year to compile complete and accurate financial reports that resulted in many auditor-proposed journal entries. Cause/Effect The Academy did not identify the resources necessary to ensure general ledger accounts were monitored and analyzed by appropriate individuals, including taking an overview of fund activity to finalize the accounting records. As a result of the lack of appropriate overall monitoring procedures, there we many auditor-proposed journal entries. Recommendation The Academy should develop an overall monitoring procedure to ensure that all fund activity is complete, accurate, and logical. This includes assigning an appropriate individual to each general ledger account and several individuals be responsible for the entire general ledger and financial statements to perform monitoring, analytical analysis, and adjustment as needed.

Corrective Action Plan

Investment in configuration of new software will allow for more consistent internal controls and proper reporting to aid in monthly reconciliation and close process. Department will create and implement a monthly close checklist that will be adhered to and followed up on by the Accounting Manager. This list will include revenue and grant reconciliations as well. Final GL review will be completed by Director of Finance and signed off on prior to EOM

Categories

Subrecipient Monitoring

Other Findings in this Audit

  • 496448 2023-001
    Material Weakness Repeat
  • 496450 2023-003
    Material Weakness Repeat
  • 1072890 2023-001
    Material Weakness Repeat
  • 1072891 2023-002
    Material Weakness Repeat
  • 1072892 2023-003
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
84.425 Education Stabilization Fund $1.07M
84.010 Title I Grants to Local Educational Agencies $393,529
84.027 Special Education_grants to States $128,576
10.553 School Breakfast Program $76,557
84.367 Improving Teacher Quality State Grants $17,810
10.565 Commodity Supplemental Food Program $17,527
10.555 National School Lunch Program $4,600
84.424 Student Support and Academic Enrichment Program $2,251
10.649 Pandemic Ebt Administrative Costs $628