Audit 374073

ESSER III - Grant Coding ALN 84.425U - EFS Section 1 - Elementary and Secondary Education - Grant # 213713 2122 - Grant Ending September 30, 2024 Condition and Criteria: 2 CFR 200.327 of the Uniform Guidance as well as the Michigan Department of Education (MDE) Audit Manual requires proper financial reporting, which would include the Final Expenditure Report (FER) to be an accurate and true representations of the expenditures for each project. During the current year testing, while total expenditures by funding source code matched the Final Expenditure Report (FER), we found multiple areas where function and/or object codes in the trial balance did not match up with those reported in the FER. Effect: The financial information reported in the FER was not an accurate reflection of how the District utilized the grant dollars. Cause: The FER was prepared prior to properly journalizing the approved activity into the grant. Context: Due to staffing changes during the year, Management did not realize that the activity had not been properly journalized into the correct grant accounts, but believed that all expenditures were approved and therefore submitted the FER based on the data available at the time. Questioned Costs: $0 Auditors' Recommendation: We recommend that management verify the accuracy of the coding of each transaction, documenting such coding on each invoice, and that management then compare the trial balance to the individual grant draws, each time a draw is made, prior to completing the trial balance for the audit, and prior to completing the annual FER. In addition, we recommend that when coding the transactions, management compare each transaction to the applicable grant application. Views of Responsible Officials and Planned Corrective Actions: The District understands the issue and has contracted with a third party to help ensure that all activity is properly classified prior to draws being made and prior to the FER being submitted. Please see the attached Corrective Action Plan prepared by the District.