Audit 340690

FY End
2023-09-30
Total Expended
$774,270
Findings
4
Programs
3
Year: 2023 Accepted: 2025-01-31

Organization Exclusion Status:

Checking exclusion status...

Contacts

Name Title Type
D3G1TL9F3G95 Amy Decker Auditee
2315477672 Trina Ochs Auditor
No contacts on file

Notes to SEFA

Accounting Policies: Note 1 The accompanying Schedule of Expenditures of Federal Awards includes the Federal grant activity of the Consortium, and is presented on the accrual basis of accounting. The information in this schedule is presented in accordance with requirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles and Audit Requirements for Federal Awards ("Uniform Guidance"). Therefore, some amounts presented in this schedule may differ from amounts presented in, or used in, the basic financial statements. Note 2 Management has reported that expenditures in this Schedule of Expenditures of Federal Awards are equal to or derived from amounts reported in the annual or final cost reports. Unallowed differences, if any, have been disclosed to the auditor. Note 3 The financial reports including claims for advances and reimbursements and amounts claimed or used for matching, are timely, complete, accurate and contain information that is supported by the books and records from which the basic financial statements have been prepared. Note 4 The Consortium did not use the 10% de-minimus cost rate under the Uniform Administrative Requirements. Note 5 Pass-through entities have been abbreviated in the schedule, defined as follows: Pass-through Agency Abbreviation Pass-through Agency Name MDHHS Michigan Department of Health and Human Services De Minimis Rate Used: N Rate Explanation: The Consortium did not use the 10% de-minimus cost rate under the Uniform Administrative Requirements.

Finding Details

Finding 2023-003 Material Noncompliance Late Submission of Audit Package Criteria: 2 CFR Section 200.512 requires the audit, data collection form, and the reporting package be submitted within thirty calendar days after the auditee received the auditor's report or nine months after end of the audit period (whichever is earlier). Condition: The Consortium did not file the audit, the data collection form and the reporting package within the required timeframe. Cause: Near the end of the fiscal year, there was a change in the allocation of a grant's funds between federal and state funding, that was not communicated to the Consortium timely. The change in allocation resulted in federal expenditures exceeding the single audit threshold. However, the Consortium was unaware of this change in allocation and therefore was unaware of the single audit requirement. Effect: As a result of this condition, a single audit was not obtained timely, and the audit, data collection form, and the reporting package were not filed by the due date. Recommendation: Implement and adhere to procedures whereby state and federal funding allocations are known and tracked, to allow for timely completion of an audit for submission by the deadline when required. Management's Response: It is the responsibility of the Finance Supervisor to ensure all contracts entered into includes language indicating if the funding is federal or state. If it is federal funding, the contract must include the federal assistance listing number, which will be reported on the year-end schedule of federal awards. A single audit will be performed if the federal expenditures reach the maximum allowable per auditing standards. If a single audit is required, it will be completed and submitted to the appropriate grantors within nine months of the end of the fiscal year. Person Responsible: Amy Decker, Finance Supervisor Anticipate Completion Date: December 2024
Finding 2023-003 Material Noncompliance Late Submission of Audit Package Criteria: 2 CFR Section 200.512 requires the audit, data collection form, and the reporting package be submitted within thirty calendar days after the auditee received the auditor's report or nine months after end of the audit period (whichever is earlier). Condition: The Consortium did not file the audit, the data collection form and the reporting package within the required timeframe. Cause: Near the end of the fiscal year, there was a change in the allocation of a grant's funds between federal and state funding, that was not communicated to the Consortium timely. The change in allocation resulted in federal expenditures exceeding the single audit threshold. However, the Consortium was unaware of this change in allocation and therefore was unaware of the single audit requirement. Effect: As a result of this condition, a single audit was not obtained timely, and the audit, data collection form, and the reporting package were not filed by the due date. Recommendation: Implement and adhere to procedures whereby state and federal funding allocations are known and tracked, to allow for timely completion of an audit for submission by the deadline when required. Management's Response: It is the responsibility of the Finance Supervisor to ensure all contracts entered into includes language indicating if the funding is federal or state. If it is federal funding, the contract must include the federal assistance listing number, which will be reported on the year-end schedule of federal awards. A single audit will be performed if the federal expenditures reach the maximum allowable per auditing standards. If a single audit is required, it will be completed and submitted to the appropriate grantors within nine months of the end of the fiscal year. Person Responsible: Amy Decker, Finance Supervisor Anticipate Completion Date: December 2024
Finding 2023-003 Material Noncompliance Late Submission of Audit Package Criteria: 2 CFR Section 200.512 requires the audit, data collection form, and the reporting package be submitted within thirty calendar days after the auditee received the auditor's report or nine months after end of the audit period (whichever is earlier). Condition: The Consortium did not file the audit, the data collection form and the reporting package within the required timeframe. Cause: Near the end of the fiscal year, there was a change in the allocation of a grant's funds between federal and state funding, that was not communicated to the Consortium timely. The change in allocation resulted in federal expenditures exceeding the single audit threshold. However, the Consortium was unaware of this change in allocation and therefore was unaware of the single audit requirement. Effect: As a result of this condition, a single audit was not obtained timely, and the audit, data collection form, and the reporting package were not filed by the due date. Recommendation: Implement and adhere to procedures whereby state and federal funding allocations are known and tracked, to allow for timely completion of an audit for submission by the deadline when required. Management's Response: It is the responsibility of the Finance Supervisor to ensure all contracts entered into includes language indicating if the funding is federal or state. If it is federal funding, the contract must include the federal assistance listing number, which will be reported on the year-end schedule of federal awards. A single audit will be performed if the federal expenditures reach the maximum allowable per auditing standards. If a single audit is required, it will be completed and submitted to the appropriate grantors within nine months of the end of the fiscal year. Person Responsible: Amy Decker, Finance Supervisor Anticipate Completion Date: December 2024
Finding 2023-003 Material Noncompliance Late Submission of Audit Package Criteria: 2 CFR Section 200.512 requires the audit, data collection form, and the reporting package be submitted within thirty calendar days after the auditee received the auditor's report or nine months after end of the audit period (whichever is earlier). Condition: The Consortium did not file the audit, the data collection form and the reporting package within the required timeframe. Cause: Near the end of the fiscal year, there was a change in the allocation of a grant's funds between federal and state funding, that was not communicated to the Consortium timely. The change in allocation resulted in federal expenditures exceeding the single audit threshold. However, the Consortium was unaware of this change in allocation and therefore was unaware of the single audit requirement. Effect: As a result of this condition, a single audit was not obtained timely, and the audit, data collection form, and the reporting package were not filed by the due date. Recommendation: Implement and adhere to procedures whereby state and federal funding allocations are known and tracked, to allow for timely completion of an audit for submission by the deadline when required. Management's Response: It is the responsibility of the Finance Supervisor to ensure all contracts entered into includes language indicating if the funding is federal or state. If it is federal funding, the contract must include the federal assistance listing number, which will be reported on the year-end schedule of federal awards. A single audit will be performed if the federal expenditures reach the maximum allowable per auditing standards. If a single audit is required, it will be completed and submitted to the appropriate grantors within nine months of the end of the fiscal year. Person Responsible: Amy Decker, Finance Supervisor Anticipate Completion Date: December 2024