Audit 29226

FY End
2022-09-30
Total Expended
$4.55M
Findings
6
Programs
4
Year: 2022 Accepted: 2023-06-20

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
29015 2022-001 Significant Deficiency - M
29016 2022-001 Significant Deficiency - M
29017 2022-001 Significant Deficiency - M
605457 2022-001 Significant Deficiency - M
605458 2022-001 Significant Deficiency - M
605459 2022-001 Significant Deficiency - M

Contacts

Name Title Type
E5REXNKQ15G5 Tricia Wurn Auditee
2313836394 Christina Schaub Auditor
No contacts on file

Notes to SEFA

Title: Basis Of Presentation Accounting Policies: Expenditures reported on the schedule are reported on the full accrual basis of accounting. Such expenditures are recognized following the cost principles contained in Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Negative amounts (if any) shown on the schedule represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. De Minimis Rate Used: Y Rate Explanation: The auditee used the de minimis cost rate. The accompanying schedule of expenditures of federal awards (the schedule) includes the federal award activity of Northern Michigan Regional Entity (the Entity) under programs of the federal government for the year ended September 30, 2022. The information in this schedule is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). Because the schedule presents only a selected portion of the operations of the Entity, it is not intended to and does not present its financial position or changes in net position of the Entity.
Title: Reconciliation With Audited Financial Statements Accounting Policies: Expenditures reported on the schedule are reported on the full accrual basis of accounting. Such expenditures are recognized following the cost principles contained in Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Negative amounts (if any) shown on the schedule represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. De Minimis Rate Used: Y Rate Explanation: The auditee used the de minimis cost rate. Revenues related to federal expenditures are reported as follows in the financial statements of Northern Michigan Regional Entity: DescriptionAmountFederal revenues subject to single audit as seen on SEFA4,547,774State revenues and remaining federal revenues not subject to single audit537,185Total State and federal grants per financial statement audit5,084,959

Finding Details

2022-001: Considered a significant deficiency in internal control over compliance/immaterial non-compliance Program: ALN 93.959 Block Grants for Prevention and Treatment of Substance Abuse (Prevention, COVID-19 Prevention II, and COVID-19 ARPA Prevention) Criteria: As detailed by 2 CFR 200.332, the pass-through entity must communicate specific information to subrecipients, as applicable. Condition: During testing of contracts with subrecipients it was noted that these contracts did not include portions of required disclosures. Cause/Effect: This condition appears to be the result of inconsistent application of internal controls over compliance. Contracts with subrecipients were not in compliance with 2 CFR 200.332. Questioned Cost: None. Recommendation: We recommend that the Entity update all contracts with subrecipients to include required language. View of Responsible Official: Management is in agreement with this recommendation.
2022-001: Considered a significant deficiency in internal control over compliance/immaterial non-compliance Program: ALN 93.959 Block Grants for Prevention and Treatment of Substance Abuse (Prevention, COVID-19 Prevention II, and COVID-19 ARPA Prevention) Criteria: As detailed by 2 CFR 200.332, the pass-through entity must communicate specific information to subrecipients, as applicable. Condition: During testing of contracts with subrecipients it was noted that these contracts did not include portions of required disclosures. Cause/Effect: This condition appears to be the result of inconsistent application of internal controls over compliance. Contracts with subrecipients were not in compliance with 2 CFR 200.332. Questioned Cost: None. Recommendation: We recommend that the Entity update all contracts with subrecipients to include required language. View of Responsible Official: Management is in agreement with this recommendation.
2022-001: Considered a significant deficiency in internal control over compliance/immaterial non-compliance Program: ALN 93.959 Block Grants for Prevention and Treatment of Substance Abuse (Prevention, COVID-19 Prevention II, and COVID-19 ARPA Prevention) Criteria: As detailed by 2 CFR 200.332, the pass-through entity must communicate specific information to subrecipients, as applicable. Condition: During testing of contracts with subrecipients it was noted that these contracts did not include portions of required disclosures. Cause/Effect: This condition appears to be the result of inconsistent application of internal controls over compliance. Contracts with subrecipients were not in compliance with 2 CFR 200.332. Questioned Cost: None. Recommendation: We recommend that the Entity update all contracts with subrecipients to include required language. View of Responsible Official: Management is in agreement with this recommendation.
2022-001: Considered a significant deficiency in internal control over compliance/immaterial non-compliance Program: ALN 93.959 Block Grants for Prevention and Treatment of Substance Abuse (Prevention, COVID-19 Prevention II, and COVID-19 ARPA Prevention) Criteria: As detailed by 2 CFR 200.332, the pass-through entity must communicate specific information to subrecipients, as applicable. Condition: During testing of contracts with subrecipients it was noted that these contracts did not include portions of required disclosures. Cause/Effect: This condition appears to be the result of inconsistent application of internal controls over compliance. Contracts with subrecipients were not in compliance with 2 CFR 200.332. Questioned Cost: None. Recommendation: We recommend that the Entity update all contracts with subrecipients to include required language. View of Responsible Official: Management is in agreement with this recommendation.
2022-001: Considered a significant deficiency in internal control over compliance/immaterial non-compliance Program: ALN 93.959 Block Grants for Prevention and Treatment of Substance Abuse (Prevention, COVID-19 Prevention II, and COVID-19 ARPA Prevention) Criteria: As detailed by 2 CFR 200.332, the pass-through entity must communicate specific information to subrecipients, as applicable. Condition: During testing of contracts with subrecipients it was noted that these contracts did not include portions of required disclosures. Cause/Effect: This condition appears to be the result of inconsistent application of internal controls over compliance. Contracts with subrecipients were not in compliance with 2 CFR 200.332. Questioned Cost: None. Recommendation: We recommend that the Entity update all contracts with subrecipients to include required language. View of Responsible Official: Management is in agreement with this recommendation.
2022-001: Considered a significant deficiency in internal control over compliance/immaterial non-compliance Program: ALN 93.959 Block Grants for Prevention and Treatment of Substance Abuse (Prevention, COVID-19 Prevention II, and COVID-19 ARPA Prevention) Criteria: As detailed by 2 CFR 200.332, the pass-through entity must communicate specific information to subrecipients, as applicable. Condition: During testing of contracts with subrecipients it was noted that these contracts did not include portions of required disclosures. Cause/Effect: This condition appears to be the result of inconsistent application of internal controls over compliance. Contracts with subrecipients were not in compliance with 2 CFR 200.332. Questioned Cost: None. Recommendation: We recommend that the Entity update all contracts with subrecipients to include required language. View of Responsible Official: Management is in agreement with this recommendation.