Audit 360525

FY End
2023-09-30
Total Expended
$3.34M
Findings
6
Programs
3
Year: 2023 Accepted: 2025-06-28

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
568811 2023-004 Material Weakness - I
568812 2023-005 Material Weakness - L
568813 2023-006 Significant Deficiency - C
1145253 2023-004 Material Weakness - I
1145254 2023-005 Material Weakness - L
1145255 2023-006 Significant Deficiency - C

Programs

ALN Program Spent Major Findings
93.958 Block Grants for Community Mental Health Services $1.45M - 0
93.493 Congressional Directives $792,759 Yes 3
93.778 Medical Assistance Program $15,334 - 0

Contacts

Name Title Type
FZTBS1VNKQS1 Kevin Hartley Auditee
2316332171 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. Pass-through entity identifying numbers are presented where available. De Minimis Rate Used: Y Rate Explanation: The CMHSP has elected to use the 10-percent de minimis indirect cost rate allowed under the Uniform Guidance. The accompanying schedule of expenditures of federal awards (the schedule) includes the federal award activity of Northern Lakes Community Mental Health Authority (the CMHSP) under programs of the federal government for the year ended September 30, 2023. 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 CMHSP, it is not intended to and does not present its financial position or changes in net position of the CMHSP.
Title: PASS THROUGH AGENCIES 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. Pass-through entity identifying numbers are presented where available. De Minimis Rate Used: Y Rate Explanation: The CMHSP has elected to use the 10-percent de minimis indirect cost rate allowed under the Uniform Guidance. The CMHSP receives certain federal grants as subawards from non-federal entities. Pass-through entities, where applicable, have been identified in the schedule of expenditures of federal awards with an abbreviation, defined as follows: Pass-through Agency Abbreviation Pass-through Agency Name MDHHS Michigan Department of Health and Human Services U of M University of Michigan
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. Pass-through entity identifying numbers are presented where available. De Minimis Rate Used: Y Rate Explanation: The CMHSP has elected to use the 10-percent de minimis indirect cost rate allowed under the Uniform Guidance. The following is a reconciliation of federal expenditures reported on the SEFA with the federal revenues reported in the financial statements: Description Amount Federal awards subject to single audit as seen on SEFA 3,337,889 Revenues not subject to single audit 4,062,478 Total state and federal funding per financial statements 7,400,367

Finding Details

Finding 2023-004 – PROCUREMENT Type: Material Weakness in Internal Control/Noncompliance. Program: ALN 93.493 Congressional Directives Criteria: Pursuant to 2 CFR 200.320, when a procurement transaction under a Federal award exceeds the simplified acquisition threshold, formal procurement methods are required. Pursuant to 2 CFR 200.214 and 2 CFR part 180, prior to entering into a covered transaction, a nonfederal entity must verify that the person with whom they intend to do business is not suspended, debarred, or otherwise excluded or disqualified.” Condition: The CMHSP did not follow the formal procurement methods outlined in 2 CFR 200.320 prior to entering into contracts for services under the grant. Also, the CMHSP did not verify that the vendors were not suspended, debarred, or otherwise excluded or disqualified in accordance with 2 CFR requirements prior to entering into a contract for services under the grant. Cause: This condition was caused by an insufficient internal control process for review and approval of procurements/check for suspension and debarment. Effect: The CMHSP purchased several items that did not have the proper documentation/support of the procurement process. Questioned Cost: $749,624 Context: Three contracts were paid from grant funds. The questioned costs shown above reflect the amount paid from grant funds for the year pursuant to those contracts. Also, upon subsequent review, it was determined that the vendor was not suspended, debarred, or otherwise excluded or disqualified. Recommendation: We recommend that the CMHSP review their internal controls and make necessary changes to ensure that purchases adhere to the CMHSP’s procurement policy. Management’s Resp: We are in agreement with this finding.
Finding 2023-005 – REPORTING Type: Material Weakness in Internal Control/Noncompliance. Program: ALN 93.493 Congressional Directives Criteria: Pursuant to 2 CFR 200.328(c), “The recipient or subrecipient must submit financial reports as required by the Federal award.” According to the closeout requirements of the Federal award, recipients must, “Reconcile financial expenditures to the reported total disbursement and charges in PMS.” Condition: The CMHSP did not reconcile financial expenditures shown in the Federal Financial Report to the total disbursement and charges in PMS. Cause: This condition was caused by an insufficient internal control process for review and approval of grant reports. Effect: Federal share of expenditures listed on the Federal Financial Report were overstated by $361,981. Questioned Cost: None. Context: Amounts received as Federal reimbursement, as detailed in PMS, were supported by the books and records of the CMHSP. However, the final report of expenditures was overstated by $361,981. Recommendation: We recommend that the CMHSP review their internal controls and make necessary changes to ensure that reports adhere to the grant requirements. Management’s Resp: We are in agreement with this finding.
Finding 2023-006 – CASH MANAGEMENT Type: Significant Deficiency in Internal Control. Program: ALN 93.493 Congressional Directives Criteria: Pursuant to 2 CFR 200.303, recipients must, “Establish, document, and maintain effective internal control over the Federal award that provides reasonable assurance that the recipient or subrecipient is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should align with the guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control-Integrated Framework” issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).” Condition: The CMHSP has established internal controls relating to approvals of cash requests. However, during testing, we noted that cash requests did not contain evidence of required review and approvals. Cause: This condition was caused by an insufficient internal control process for review and approval of cash requests. Effect: Cash requests submitted prior to review and approval are at risk of reporting incorrect information. Questioned Cost: None. Context: Although amounts listed in the cash requests were supported by the books and records, the requests did not contain evidence of approvals. Recommendation: We recommend that the CMHSP review their internal controls and make necessary changes to ensure that cash requests are reviewed and approved prior to submission. Management’s Resp: We are in agreement with this finding.
Finding 2023-004 – PROCUREMENT Type: Material Weakness in Internal Control/Noncompliance. Program: ALN 93.493 Congressional Directives Criteria: Pursuant to 2 CFR 200.320, when a procurement transaction under a Federal award exceeds the simplified acquisition threshold, formal procurement methods are required. Pursuant to 2 CFR 200.214 and 2 CFR part 180, prior to entering into a covered transaction, a nonfederal entity must verify that the person with whom they intend to do business is not suspended, debarred, or otherwise excluded or disqualified.” Condition: The CMHSP did not follow the formal procurement methods outlined in 2 CFR 200.320 prior to entering into contracts for services under the grant. Also, the CMHSP did not verify that the vendors were not suspended, debarred, or otherwise excluded or disqualified in accordance with 2 CFR requirements prior to entering into a contract for services under the grant. Cause: This condition was caused by an insufficient internal control process for review and approval of procurements/check for suspension and debarment. Effect: The CMHSP purchased several items that did not have the proper documentation/support of the procurement process. Questioned Cost: $749,624 Context: Three contracts were paid from grant funds. The questioned costs shown above reflect the amount paid from grant funds for the year pursuant to those contracts. Also, upon subsequent review, it was determined that the vendor was not suspended, debarred, or otherwise excluded or disqualified. Recommendation: We recommend that the CMHSP review their internal controls and make necessary changes to ensure that purchases adhere to the CMHSP’s procurement policy. Management’s Resp: We are in agreement with this finding.
Finding 2023-005 – REPORTING Type: Material Weakness in Internal Control/Noncompliance. Program: ALN 93.493 Congressional Directives Criteria: Pursuant to 2 CFR 200.328(c), “The recipient or subrecipient must submit financial reports as required by the Federal award.” According to the closeout requirements of the Federal award, recipients must, “Reconcile financial expenditures to the reported total disbursement and charges in PMS.” Condition: The CMHSP did not reconcile financial expenditures shown in the Federal Financial Report to the total disbursement and charges in PMS. Cause: This condition was caused by an insufficient internal control process for review and approval of grant reports. Effect: Federal share of expenditures listed on the Federal Financial Report were overstated by $361,981. Questioned Cost: None. Context: Amounts received as Federal reimbursement, as detailed in PMS, were supported by the books and records of the CMHSP. However, the final report of expenditures was overstated by $361,981. Recommendation: We recommend that the CMHSP review their internal controls and make necessary changes to ensure that reports adhere to the grant requirements. Management’s Resp: We are in agreement with this finding.
Finding 2023-006 – CASH MANAGEMENT Type: Significant Deficiency in Internal Control. Program: ALN 93.493 Congressional Directives Criteria: Pursuant to 2 CFR 200.303, recipients must, “Establish, document, and maintain effective internal control over the Federal award that provides reasonable assurance that the recipient or subrecipient is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should align with the guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control-Integrated Framework” issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).” Condition: The CMHSP has established internal controls relating to approvals of cash requests. However, during testing, we noted that cash requests did not contain evidence of required review and approvals. Cause: This condition was caused by an insufficient internal control process for review and approval of cash requests. Effect: Cash requests submitted prior to review and approval are at risk of reporting incorrect information. Questioned Cost: None. Context: Although amounts listed in the cash requests were supported by the books and records, the requests did not contain evidence of approvals. Recommendation: We recommend that the CMHSP review their internal controls and make necessary changes to ensure that cash requests are reviewed and approved prior to submission. Management’s Resp: We are in agreement with this finding.