Finding Type: Material Weakness
Criteria
The Academy’s internal control structure should ensure that the accounting data is appropriately calculated, reconciled, and reported in accordance with generally accepted accounting principles.
Condition
The Academy’s accounts required significant adjustments to the general ledger to properly reflect the appropriate balance after the books and records were presented for audit.
Cause/Effect
While the accounts were reconciled throughout the year, the reconciliations completed had certain instances where the year-end reconciliation process didn’t match to the general ledger.
Recommendation
The Academy should institute monthly and yearly closing procedures to ensure that all accounts are reconciled and match the general ledger.
Finding Type: Material Weakness
Criteria
The Academy should monitor the general ledger appropriately 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, which resulted in many auditor-proposed journal entries.
Context
We noted that the Academy didn’t have a process in place to ensure that financial statements were accurate and complete.
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 were 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 are responsible for the entire general ledger and financial statements to perform monitoring, analytical analysis, and adjustment as needed.
Finding Type: Material Weakness and Material Noncompliance
Criteria
There should be a process in place to ensure that the Academy complies with laws and regulations.
Condition
There was an instance identified where the Academy was not in compliance with laws and regulations. State School Aid Act MCL 388.1718 requires that annual audits are submitted by November 1 to the Michigan Department of Education.
Cause/Effect
There was a change in staff and staff shortages, which led to noncompliance with MCL 388.1718.
Recommendation
We recommend that the Academy implement a process that identifies specific individuals to identify and monitor applicable compliance requirements throughout the year.
Finding Type: Material Weakness
Criteria
There should be a process to ensure grant revenue is accurately and timely recorded.
Condition
The Academy didn’t have a process in place to ensure that grant revenue was reported accurately and timely.
Context
During our testing, we noted errors in recording various revenue, accounts receivable, and unearned revenue accounts. This included instances where revenues were not properly recorded, and drawdowns for grants were processed beyond the sixty-day requirement, which reduced revenue.
Cause/Effect
There is no process to ensure that grant revenues are timely and accurately accounted for.
Recommendation
We recommend that the Academy implement a process that would allow for the accurate recording of grant revenue and timely request of cash drawdowns.
Finding Type: Material Weakness – Noncompliance – Educational Stabilization Fund Under the Coronavirus Aid, Relief, and Economic Security Act
Criteria
Michigan Department of Education awarded the American Rescue Plan Elementary and Secondary School Emergency Relief (ARP ESSER) program to public school academies operating before fiscal year 2022. Under the program, Academies cannot allow the transfer of ESSER funding to academies open after fiscal year 2021.
Condition
The Academy transferred ESSER funds based on the State of Michigan's approved consolidated application that identified Lincoln-King Adams-Young Academy as a second tier subrecipient. Subsequent to year-end, the State of Michigan deemed the transfer as unallowable incurred expenditures ineligible.
The Academy firmly disputes that the transfers were unallowable because of the pre-approvals received by the Academy to be a sub-recipient of a federal award but supports trying to resolve the relevant issues.
Questioned Cost
Questioned costs included amounts transferred to Lincoln-King Adams-Young Academy, which totaled $3,345,325 in Fiscal Year 23.
Context
Subsequent to year-end, we were made aware that the transfers were unallowable.
Cause and Effect
The Academy relied on the approved consolidated application noting the use of funds for Lincoln-King Adams-Young Academy.
Finding Type: Material Weakness
Criteria
The Academy’s internal control structure should ensure that the accounting data is appropriately calculated, reconciled, and reported in accordance with generally accepted accounting principles.
Condition
The Academy’s accounts required significant adjustments to the general ledger to properly reflect the appropriate balance after the books and records were presented for audit.
Cause/Effect
While the accounts were reconciled throughout the year, the reconciliations completed had certain instances where the year-end reconciliation process didn’t match to the general ledger.
Recommendation
The Academy should institute monthly and yearly closing procedures to ensure that all accounts are reconciled and match the general ledger.
Finding Type: Material Weakness
Criteria
The Academy should monitor the general ledger appropriately 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, which resulted in many auditor-proposed journal entries.
Context
We noted that the Academy didn’t have a process in place to ensure that financial statements were accurate and complete.
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 were 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 are responsible for the entire general ledger and financial statements to perform monitoring, analytical analysis, and adjustment as needed.
Finding Type: Material Weakness and Material Noncompliance
Criteria
There should be a process in place to ensure that the Academy complies with laws and regulations.
Condition
There was an instance identified where the Academy was not in compliance with laws and regulations. State School Aid Act MCL 388.1718 requires that annual audits are submitted by November 1 to the Michigan Department of Education.
Cause/Effect
There was a change in staff and staff shortages, which led to noncompliance with MCL 388.1718.
Recommendation
We recommend that the Academy implement a process that identifies specific individuals to identify and monitor applicable compliance requirements throughout the year.
Finding Type: Material Weakness
Criteria
There should be a process to ensure grant revenue is accurately and timely recorded.
Condition
The Academy didn’t have a process in place to ensure that grant revenue was reported accurately and timely.
Context
During our testing, we noted errors in recording various revenue, accounts receivable, and unearned revenue accounts. This included instances where revenues were not properly recorded, and drawdowns for grants were processed beyond the sixty-day requirement, which reduced revenue.
Cause/Effect
There is no process to ensure that grant revenues are timely and accurately accounted for.
Recommendation
We recommend that the Academy implement a process that would allow for the accurate recording of grant revenue and timely request of cash drawdowns.
Finding Type: Material Weakness – Noncompliance – Educational Stabilization Fund Under the Coronavirus Aid, Relief, and Economic Security Act
Criteria
Michigan Department of Education awarded the American Rescue Plan Elementary and Secondary School Emergency Relief (ARP ESSER) program to public school academies operating before fiscal year 2022. Under the program, Academies cannot allow the transfer of ESSER funding to academies open after fiscal year 2021.
Condition
The Academy transferred ESSER funds based on the State of Michigan's approved consolidated application that identified Lincoln-King Adams-Young Academy as a second tier subrecipient. Subsequent to year-end, the State of Michigan deemed the transfer as unallowable incurred expenditures ineligible.
The Academy firmly disputes that the transfers were unallowable because of the pre-approvals received by the Academy to be a sub-recipient of a federal award but supports trying to resolve the relevant issues.
Questioned Cost
Questioned costs included amounts transferred to Lincoln-King Adams-Young Academy, which totaled $3,345,325 in Fiscal Year 23.
Context
Subsequent to year-end, we were made aware that the transfers were unallowable.
Cause and Effect
The Academy relied on the approved consolidated application noting the use of funds for Lincoln-King Adams-Young Academy.