Audit 19281

FY End
2022-09-30
Total Expended
$3.55M
Findings
36
Programs
5
Organization: Detroit Recovery Project, Inc. (MI)
Year: 2022 Accepted: 2023-09-11
Auditor: Yeo & Yeo PC

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
22644 2022-005 Material Weakness - B
22645 2022-006 Material Weakness Yes B
22646 2022-007 Significant Deficiency - C
22647 2022-005 Material Weakness - B
22648 2022-007 Significant Deficiency - C
22649 2022-006 Material Weakness Yes B
22650 2022-005 Material Weakness - B
22651 2022-006 Material Weakness Yes B
22652 2022-007 Significant Deficiency - C
22653 2022-005 Material Weakness - B
22654 2022-006 Material Weakness Yes B
22655 2022-007 Significant Deficiency - C
22656 2022-005 Material Weakness - B
22657 2022-007 Significant Deficiency - C
22658 2022-006 Material Weakness Yes B
22659 2022-006 Material Weakness Yes B
22660 2022-005 Material Weakness - B
22661 2022-007 Significant Deficiency - C
599086 2022-005 Material Weakness - B
599087 2022-006 Material Weakness Yes B
599088 2022-007 Significant Deficiency - C
599089 2022-005 Material Weakness - B
599090 2022-007 Significant Deficiency - C
599091 2022-006 Material Weakness Yes B
599092 2022-005 Material Weakness - B
599093 2022-006 Material Weakness Yes B
599094 2022-007 Significant Deficiency - C
599095 2022-005 Material Weakness - B
599096 2022-006 Material Weakness Yes B
599097 2022-007 Significant Deficiency - C
599098 2022-005 Material Weakness - B
599099 2022-007 Significant Deficiency - C
599100 2022-006 Material Weakness Yes B
599101 2022-006 Material Weakness Yes B
599102 2022-005 Material Weakness - B
599103 2022-007 Significant Deficiency - C

Contacts

Name Title Type
SZY9KM9HH687 Andre Johnson Auditee
3133653100 Timothy Crosson Jr. Auditor
No contacts on file

Notes to SEFA

Title: RECONCILIATION TO THE FINANCIAL STATEMENTS Accounting Policies: Expenditures reported on the Schedule are reported on the accrual basis of accounting. Such expenditures are recognized following, as applicable, the cost principles contained in the OMB Circular A-122 Cost Principles for Non-Profit Organizations where certain types of expenditures are not allowable or are limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. The schedule of expenditures of federal awards reconciles to the statement of activities as follows: SEE TABLE IN NOTE 3 IN NOTES TO THE SEFA
Title: SUBRECIPIENTS Accounting Policies: Expenditures reported on the Schedule are reported on the accrual basis of accounting. Such expenditures are recognized following, as applicable, the cost principles contained in the OMB Circular A-122 Cost Principles for Non-Profit Organizations where certain types of expenditures are not allowable or are limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. No amounts were provided to subrecipients.

Finding Details

Finding 2022-005 ? Supporting Documentation for Expenditures Program Name: Substance Abuse and Mental Health Services ? Projects of Regional and National Significance ? Assistance Listing 93.243 Section 223 Demonstration Programs to Improve Community Mental Health Services ? Assistance Listing 93.829 Awarding Agency: U.S. Department of Health and Human Services, passed through Substance Abuse and Mental Health Services Administration, 2022 Finding Type: Material Weakness on Internal Controls over Compliance and Material Noncompliance Questioned Cost Amount: None Context / Criteria: 2CFR200.403(g) requires expenses incurred must be for activities allowed under the terms and conditions of the federal award. Condition: During our review of expenditures, we noted transactions that did not have documentation to support the purchase, such as invoices, or documentation to show the purchase was approved prior to payment. For AL 93.243 21 of 50 transactions sampled lacked approvals for the disbursement. Additionally, 4 of 50 transactions lacked evidence for the disbursements. For AL 93.829 1 of 16 transactions sampled lacked evidence for the disbursements and approvals. Cause / Effect: The Organization did not have adequate controls in place to ensure transactions had proper documentation and approval prior to payment. Recommendation: We recommend management review each purchase to ensure it is supported by proper documentation and is properly approved prior to payment. Views of Responsible Officials: Management is in agreement with the finding. Corrective Action Plan: See attached corrective action plan.
Finding 2022-006, 2021-004, 2020-002 ? Time Reporting/Personnel Activity Reports Program Name: Substance Abuse and Mental Health Services ? Projects of Regional and National Significance ? Assistance Listing 93.243 Section 223 Demonstration Programs to Improve Community Mental Health Services ? Assistance Listing 93.829 Awarding Agency: U.S. Department of Health and Human Services, passed through Substance Abuse and Mental Health Services Administration, 2022 Finding Type: Material Weakness on Internal Controls over Compliance and Material Noncompliance Questioned Cost Amount: Unknown Context / Criteria: 2CFR200.400.430(i) requires the distribution of salary and wages charged to federal awards should be based on actual employee activity as reflected in personnel activity reports (timesheets), prepared after the fact, which include the total activity for which employees were compensated. Condition: For all payroll transactions selected during our test work, it was noted that the payroll register did not agree to the amounts charged to each grant. Additionally, there was not a personnel activity report (PAR) or timesheet equivalent provided to support the employees? time charged to the grant. For AL 93.243 60 of 60 transactions lacked personnel activity reports to document time spent on the award. Additionally, 21 of 60 transactions lacked approval for the pay period?s time entry. For AL 93.829 60 of 60 transactions lacked personnel activity reports to document time spent on the award. Additionally, 18 of 60 transactions lacked approval for the pay period?s time entry. Cause / Effect: The Organization did not have adequate controls in place to ensure amounts charged to the grant were properly supported and approved. Recommendation: We recommend management review payroll for accuracy, including comparing the timesheets/PARs to the payroll register, and the payroll register to the general ledger to ensure time charged to the grant accurately reflects work performed relating to the grant. Views of Responsible Officials: Management is in agreement with the finding. Corrective Action Plan: See attached corrective action plan.
Finding 2022-007 ? Reimbursement of Federal Awards Program Name: Substance Abuse and Mental Health Services ? Projects of Regional and National Significance ? Assistance Listing 93.243 Section 223 Demonstration Programs to Improve Community Mental Health Services ? Assistance Listing 93.829 Awarding Agency: U.S. Department of Health and Human Services, passed through Substance Abuse and Mental Health Services Administration, 2022 Finding Type: Significant Deficiency on Internal Controls over Compliance and Material Noncompliance Questioned Cost Amount: None Context / Criteria: 2CFR200.305(b)(3) requires expenses for reimbursement grants to be incurred and paid before reimbursement is requested. Condition: During our review of profit and loss statements for the federal grants to be included on the SEFA, it was noted that revenue exceeded expenditures for the reimbursement grants. Cause / Effect: The Organization did not have adequate controls in place to ensure expenditures were paid prior to requesting reimbursement. Management recorded the revenue in excess of expenses as refundable advance for the year ended September 30, 2022. Recommendation: We recommend management review reimbursement requests prior to submitting them to ensure the expenditures were paid prior to requesting reimbursement. Views of Responsible Officials: Management is in agreement with the finding. Corrective Action Plan: See attached corrective action plan.
Finding 2022-005 ? Supporting Documentation for Expenditures Program Name: Substance Abuse and Mental Health Services ? Projects of Regional and National Significance ? Assistance Listing 93.243 Section 223 Demonstration Programs to Improve Community Mental Health Services ? Assistance Listing 93.829 Awarding Agency: U.S. Department of Health and Human Services, passed through Substance Abuse and Mental Health Services Administration, 2022 Finding Type: Material Weakness on Internal Controls over Compliance and Material Noncompliance Questioned Cost Amount: None Context / Criteria: 2CFR200.403(g) requires expenses incurred must be for activities allowed under the terms and conditions of the federal award. Condition: During our review of expenditures, we noted transactions that did not have documentation to support the purchase, such as invoices, or documentation to show the purchase was approved prior to payment. For AL 93.243 21 of 50 transactions sampled lacked approvals for the disbursement. Additionally, 4 of 50 transactions lacked evidence for the disbursements. For AL 93.829 1 of 16 transactions sampled lacked evidence for the disbursements and approvals. Cause / Effect: The Organization did not have adequate controls in place to ensure transactions had proper documentation and approval prior to payment. Recommendation: We recommend management review each purchase to ensure it is supported by proper documentation and is properly approved prior to payment. Views of Responsible Officials: Management is in agreement with the finding. Corrective Action Plan: See attached corrective action plan.
Finding 2022-007 ? Reimbursement of Federal Awards Program Name: Substance Abuse and Mental Health Services ? Projects of Regional and National Significance ? Assistance Listing 93.243 Section 223 Demonstration Programs to Improve Community Mental Health Services ? Assistance Listing 93.829 Awarding Agency: U.S. Department of Health and Human Services, passed through Substance Abuse and Mental Health Services Administration, 2022 Finding Type: Significant Deficiency on Internal Controls over Compliance and Material Noncompliance Questioned Cost Amount: None Context / Criteria: 2CFR200.305(b)(3) requires expenses for reimbursement grants to be incurred and paid before reimbursement is requested. Condition: During our review of profit and loss statements for the federal grants to be included on the SEFA, it was noted that revenue exceeded expenditures for the reimbursement grants. Cause / Effect: The Organization did not have adequate controls in place to ensure expenditures were paid prior to requesting reimbursement. Management recorded the revenue in excess of expenses as refundable advance for the year ended September 30, 2022. Recommendation: We recommend management review reimbursement requests prior to submitting them to ensure the expenditures were paid prior to requesting reimbursement. Views of Responsible Officials: Management is in agreement with the finding. Corrective Action Plan: See attached corrective action plan.
Finding 2022-006, 2021-004, 2020-002 ? Time Reporting/Personnel Activity Reports Program Name: Substance Abuse and Mental Health Services ? Projects of Regional and National Significance ? Assistance Listing 93.243 Section 223 Demonstration Programs to Improve Community Mental Health Services ? Assistance Listing 93.829 Awarding Agency: U.S. Department of Health and Human Services, passed through Substance Abuse and Mental Health Services Administration, 2022 Finding Type: Material Weakness on Internal Controls over Compliance and Material Noncompliance Questioned Cost Amount: Unknown Context / Criteria: 2CFR200.400.430(i) requires the distribution of salary and wages charged to federal awards should be based on actual employee activity as reflected in personnel activity reports (timesheets), prepared after the fact, which include the total activity for which employees were compensated. Condition: For all payroll transactions selected during our test work, it was noted that the payroll register did not agree to the amounts charged to each grant. Additionally, there was not a personnel activity report (PAR) or timesheet equivalent provided to support the employees? time charged to the grant. For AL 93.243 60 of 60 transactions lacked personnel activity reports to document time spent on the award. Additionally, 21 of 60 transactions lacked approval for the pay period?s time entry. For AL 93.829 60 of 60 transactions lacked personnel activity reports to document time spent on the award. Additionally, 18 of 60 transactions lacked approval for the pay period?s time entry. Cause / Effect: The Organization did not have adequate controls in place to ensure amounts charged to the grant were properly supported and approved. Recommendation: We recommend management review payroll for accuracy, including comparing the timesheets/PARs to the payroll register, and the payroll register to the general ledger to ensure time charged to the grant accurately reflects work performed relating to the grant. Views of Responsible Officials: Management is in agreement with the finding. Corrective Action Plan: See attached corrective action plan.
Finding 2022-005 ? Supporting Documentation for Expenditures Program Name: Substance Abuse and Mental Health Services ? Projects of Regional and National Significance ? Assistance Listing 93.243 Section 223 Demonstration Programs to Improve Community Mental Health Services ? Assistance Listing 93.829 Awarding Agency: U.S. Department of Health and Human Services, passed through Substance Abuse and Mental Health Services Administration, 2022 Finding Type: Material Weakness on Internal Controls over Compliance and Material Noncompliance Questioned Cost Amount: None Context / Criteria: 2CFR200.403(g) requires expenses incurred must be for activities allowed under the terms and conditions of the federal award. Condition: During our review of expenditures, we noted transactions that did not have documentation to support the purchase, such as invoices, or documentation to show the purchase was approved prior to payment. For AL 93.243 21 of 50 transactions sampled lacked approvals for the disbursement. Additionally, 4 of 50 transactions lacked evidence for the disbursements. For AL 93.829 1 of 16 transactions sampled lacked evidence for the disbursements and approvals. Cause / Effect: The Organization did not have adequate controls in place to ensure transactions had proper documentation and approval prior to payment. Recommendation: We recommend management review each purchase to ensure it is supported by proper documentation and is properly approved prior to payment. Views of Responsible Officials: Management is in agreement with the finding. Corrective Action Plan: See attached corrective action plan.
Finding 2022-006, 2021-004, 2020-002 ? Time Reporting/Personnel Activity Reports Program Name: Substance Abuse and Mental Health Services ? Projects of Regional and National Significance ? Assistance Listing 93.243 Section 223 Demonstration Programs to Improve Community Mental Health Services ? Assistance Listing 93.829 Awarding Agency: U.S. Department of Health and Human Services, passed through Substance Abuse and Mental Health Services Administration, 2022 Finding Type: Material Weakness on Internal Controls over Compliance and Material Noncompliance Questioned Cost Amount: Unknown Context / Criteria: 2CFR200.400.430(i) requires the distribution of salary and wages charged to federal awards should be based on actual employee activity as reflected in personnel activity reports (timesheets), prepared after the fact, which include the total activity for which employees were compensated. Condition: For all payroll transactions selected during our test work, it was noted that the payroll register did not agree to the amounts charged to each grant. Additionally, there was not a personnel activity report (PAR) or timesheet equivalent provided to support the employees? time charged to the grant. For AL 93.243 60 of 60 transactions lacked personnel activity reports to document time spent on the award. Additionally, 21 of 60 transactions lacked approval for the pay period?s time entry. For AL 93.829 60 of 60 transactions lacked personnel activity reports to document time spent on the award. Additionally, 18 of 60 transactions lacked approval for the pay period?s time entry. Cause / Effect: The Organization did not have adequate controls in place to ensure amounts charged to the grant were properly supported and approved. Recommendation: We recommend management review payroll for accuracy, including comparing the timesheets/PARs to the payroll register, and the payroll register to the general ledger to ensure time charged to the grant accurately reflects work performed relating to the grant. Views of Responsible Officials: Management is in agreement with the finding. Corrective Action Plan: See attached corrective action plan.
Finding 2022-007 ? Reimbursement of Federal Awards Program Name: Substance Abuse and Mental Health Services ? Projects of Regional and National Significance ? Assistance Listing 93.243 Section 223 Demonstration Programs to Improve Community Mental Health Services ? Assistance Listing 93.829 Awarding Agency: U.S. Department of Health and Human Services, passed through Substance Abuse and Mental Health Services Administration, 2022 Finding Type: Significant Deficiency on Internal Controls over Compliance and Material Noncompliance Questioned Cost Amount: None Context / Criteria: 2CFR200.305(b)(3) requires expenses for reimbursement grants to be incurred and paid before reimbursement is requested. Condition: During our review of profit and loss statements for the federal grants to be included on the SEFA, it was noted that revenue exceeded expenditures for the reimbursement grants. Cause / Effect: The Organization did not have adequate controls in place to ensure expenditures were paid prior to requesting reimbursement. Management recorded the revenue in excess of expenses as refundable advance for the year ended September 30, 2022. Recommendation: We recommend management review reimbursement requests prior to submitting them to ensure the expenditures were paid prior to requesting reimbursement. Views of Responsible Officials: Management is in agreement with the finding. Corrective Action Plan: See attached corrective action plan.
Finding 2022-005 ? Supporting Documentation for Expenditures Program Name: Substance Abuse and Mental Health Services ? Projects of Regional and National Significance ? Assistance Listing 93.243 Section 223 Demonstration Programs to Improve Community Mental Health Services ? Assistance Listing 93.829 Awarding Agency: U.S. Department of Health and Human Services, passed through Substance Abuse and Mental Health Services Administration, 2022 Finding Type: Material Weakness on Internal Controls over Compliance and Material Noncompliance Questioned Cost Amount: None Context / Criteria: 2CFR200.403(g) requires expenses incurred must be for activities allowed under the terms and conditions of the federal award. Condition: During our review of expenditures, we noted transactions that did not have documentation to support the purchase, such as invoices, or documentation to show the purchase was approved prior to payment. For AL 93.243 21 of 50 transactions sampled lacked approvals for the disbursement. Additionally, 4 of 50 transactions lacked evidence for the disbursements. For AL 93.829 1 of 16 transactions sampled lacked evidence for the disbursements and approvals. Cause / Effect: The Organization did not have adequate controls in place to ensure transactions had proper documentation and approval prior to payment. Recommendation: We recommend management review each purchase to ensure it is supported by proper documentation and is properly approved prior to payment. Views of Responsible Officials: Management is in agreement with the finding. Corrective Action Plan: See attached corrective action plan.
Finding 2022-006, 2021-004, 2020-002 ? Time Reporting/Personnel Activity Reports Program Name: Substance Abuse and Mental Health Services ? Projects of Regional and National Significance ? Assistance Listing 93.243 Section 223 Demonstration Programs to Improve Community Mental Health Services ? Assistance Listing 93.829 Awarding Agency: U.S. Department of Health and Human Services, passed through Substance Abuse and Mental Health Services Administration, 2022 Finding Type: Material Weakness on Internal Controls over Compliance and Material Noncompliance Questioned Cost Amount: Unknown Context / Criteria: 2CFR200.400.430(i) requires the distribution of salary and wages charged to federal awards should be based on actual employee activity as reflected in personnel activity reports (timesheets), prepared after the fact, which include the total activity for which employees were compensated. Condition: For all payroll transactions selected during our test work, it was noted that the payroll register did not agree to the amounts charged to each grant. Additionally, there was not a personnel activity report (PAR) or timesheet equivalent provided to support the employees? time charged to the grant. For AL 93.243 60 of 60 transactions lacked personnel activity reports to document time spent on the award. Additionally, 21 of 60 transactions lacked approval for the pay period?s time entry. For AL 93.829 60 of 60 transactions lacked personnel activity reports to document time spent on the award. Additionally, 18 of 60 transactions lacked approval for the pay period?s time entry. Cause / Effect: The Organization did not have adequate controls in place to ensure amounts charged to the grant were properly supported and approved. Recommendation: We recommend management review payroll for accuracy, including comparing the timesheets/PARs to the payroll register, and the payroll register to the general ledger to ensure time charged to the grant accurately reflects work performed relating to the grant. Views of Responsible Officials: Management is in agreement with the finding. Corrective Action Plan: See attached corrective action plan.
Finding 2022-007 ? Reimbursement of Federal Awards Program Name: Substance Abuse and Mental Health Services ? Projects of Regional and National Significance ? Assistance Listing 93.243 Section 223 Demonstration Programs to Improve Community Mental Health Services ? Assistance Listing 93.829 Awarding Agency: U.S. Department of Health and Human Services, passed through Substance Abuse and Mental Health Services Administration, 2022 Finding Type: Significant Deficiency on Internal Controls over Compliance and Material Noncompliance Questioned Cost Amount: None Context / Criteria: 2CFR200.305(b)(3) requires expenses for reimbursement grants to be incurred and paid before reimbursement is requested. Condition: During our review of profit and loss statements for the federal grants to be included on the SEFA, it was noted that revenue exceeded expenditures for the reimbursement grants. Cause / Effect: The Organization did not have adequate controls in place to ensure expenditures were paid prior to requesting reimbursement. Management recorded the revenue in excess of expenses as refundable advance for the year ended September 30, 2022. Recommendation: We recommend management review reimbursement requests prior to submitting them to ensure the expenditures were paid prior to requesting reimbursement. Views of Responsible Officials: Management is in agreement with the finding. Corrective Action Plan: See attached corrective action plan.
Finding 2022-005 ? Supporting Documentation for Expenditures Program Name: Substance Abuse and Mental Health Services ? Projects of Regional and National Significance ? Assistance Listing 93.243 Section 223 Demonstration Programs to Improve Community Mental Health Services ? Assistance Listing 93.829 Awarding Agency: U.S. Department of Health and Human Services, passed through Substance Abuse and Mental Health Services Administration, 2022 Finding Type: Material Weakness on Internal Controls over Compliance and Material Noncompliance Questioned Cost Amount: None Context / Criteria: 2CFR200.403(g) requires expenses incurred must be for activities allowed under the terms and conditions of the federal award. Condition: During our review of expenditures, we noted transactions that did not have documentation to support the purchase, such as invoices, or documentation to show the purchase was approved prior to payment. For AL 93.243 21 of 50 transactions sampled lacked approvals for the disbursement. Additionally, 4 of 50 transactions lacked evidence for the disbursements. For AL 93.829 1 of 16 transactions sampled lacked evidence for the disbursements and approvals. Cause / Effect: The Organization did not have adequate controls in place to ensure transactions had proper documentation and approval prior to payment. Recommendation: We recommend management review each purchase to ensure it is supported by proper documentation and is properly approved prior to payment. Views of Responsible Officials: Management is in agreement with the finding. Corrective Action Plan: See attached corrective action plan.
Finding 2022-007 ? Reimbursement of Federal Awards Program Name: Substance Abuse and Mental Health Services ? Projects of Regional and National Significance ? Assistance Listing 93.243 Section 223 Demonstration Programs to Improve Community Mental Health Services ? Assistance Listing 93.829 Awarding Agency: U.S. Department of Health and Human Services, passed through Substance Abuse and Mental Health Services Administration, 2022 Finding Type: Significant Deficiency on Internal Controls over Compliance and Material Noncompliance Questioned Cost Amount: None Context / Criteria: 2CFR200.305(b)(3) requires expenses for reimbursement grants to be incurred and paid before reimbursement is requested. Condition: During our review of profit and loss statements for the federal grants to be included on the SEFA, it was noted that revenue exceeded expenditures for the reimbursement grants. Cause / Effect: The Organization did not have adequate controls in place to ensure expenditures were paid prior to requesting reimbursement. Management recorded the revenue in excess of expenses as refundable advance for the year ended September 30, 2022. Recommendation: We recommend management review reimbursement requests prior to submitting them to ensure the expenditures were paid prior to requesting reimbursement. Views of Responsible Officials: Management is in agreement with the finding. Corrective Action Plan: See attached corrective action plan.
Finding 2022-006, 2021-004, 2020-002 ? Time Reporting/Personnel Activity Reports Program Name: Substance Abuse and Mental Health Services ? Projects of Regional and National Significance ? Assistance Listing 93.243 Section 223 Demonstration Programs to Improve Community Mental Health Services ? Assistance Listing 93.829 Awarding Agency: U.S. Department of Health and Human Services, passed through Substance Abuse and Mental Health Services Administration, 2022 Finding Type: Material Weakness on Internal Controls over Compliance and Material Noncompliance Questioned Cost Amount: Unknown Context / Criteria: 2CFR200.400.430(i) requires the distribution of salary and wages charged to federal awards should be based on actual employee activity as reflected in personnel activity reports (timesheets), prepared after the fact, which include the total activity for which employees were compensated. Condition: For all payroll transactions selected during our test work, it was noted that the payroll register did not agree to the amounts charged to each grant. Additionally, there was not a personnel activity report (PAR) or timesheet equivalent provided to support the employees? time charged to the grant. For AL 93.243 60 of 60 transactions lacked personnel activity reports to document time spent on the award. Additionally, 21 of 60 transactions lacked approval for the pay period?s time entry. For AL 93.829 60 of 60 transactions lacked personnel activity reports to document time spent on the award. Additionally, 18 of 60 transactions lacked approval for the pay period?s time entry. Cause / Effect: The Organization did not have adequate controls in place to ensure amounts charged to the grant were properly supported and approved. Recommendation: We recommend management review payroll for accuracy, including comparing the timesheets/PARs to the payroll register, and the payroll register to the general ledger to ensure time charged to the grant accurately reflects work performed relating to the grant. Views of Responsible Officials: Management is in agreement with the finding. Corrective Action Plan: See attached corrective action plan.
Finding 2022-006, 2021-004, 2020-002 ? Time Reporting/Personnel Activity Reports Program Name: Substance Abuse and Mental Health Services ? Projects of Regional and National Significance ? Assistance Listing 93.243 Section 223 Demonstration Programs to Improve Community Mental Health Services ? Assistance Listing 93.829 Awarding Agency: U.S. Department of Health and Human Services, passed through Substance Abuse and Mental Health Services Administration, 2022 Finding Type: Material Weakness on Internal Controls over Compliance and Material Noncompliance Questioned Cost Amount: Unknown Context / Criteria: 2CFR200.400.430(i) requires the distribution of salary and wages charged to federal awards should be based on actual employee activity as reflected in personnel activity reports (timesheets), prepared after the fact, which include the total activity for which employees were compensated. Condition: For all payroll transactions selected during our test work, it was noted that the payroll register did not agree to the amounts charged to each grant. Additionally, there was not a personnel activity report (PAR) or timesheet equivalent provided to support the employees? time charged to the grant. For AL 93.243 60 of 60 transactions lacked personnel activity reports to document time spent on the award. Additionally, 21 of 60 transactions lacked approval for the pay period?s time entry. For AL 93.829 60 of 60 transactions lacked personnel activity reports to document time spent on the award. Additionally, 18 of 60 transactions lacked approval for the pay period?s time entry. Cause / Effect: The Organization did not have adequate controls in place to ensure amounts charged to the grant were properly supported and approved. Recommendation: We recommend management review payroll for accuracy, including comparing the timesheets/PARs to the payroll register, and the payroll register to the general ledger to ensure time charged to the grant accurately reflects work performed relating to the grant. Views of Responsible Officials: Management is in agreement with the finding. Corrective Action Plan: See attached corrective action plan.
Finding 2022-005 ? Supporting Documentation for Expenditures Program Name: Substance Abuse and Mental Health Services ? Projects of Regional and National Significance ? Assistance Listing 93.243 Section 223 Demonstration Programs to Improve Community Mental Health Services ? Assistance Listing 93.829 Awarding Agency: U.S. Department of Health and Human Services, passed through Substance Abuse and Mental Health Services Administration, 2022 Finding Type: Material Weakness on Internal Controls over Compliance and Material Noncompliance Questioned Cost Amount: None Context / Criteria: 2CFR200.403(g) requires expenses incurred must be for activities allowed under the terms and conditions of the federal award. Condition: During our review of expenditures, we noted transactions that did not have documentation to support the purchase, such as invoices, or documentation to show the purchase was approved prior to payment. For AL 93.243 21 of 50 transactions sampled lacked approvals for the disbursement. Additionally, 4 of 50 transactions lacked evidence for the disbursements. For AL 93.829 1 of 16 transactions sampled lacked evidence for the disbursements and approvals. Cause / Effect: The Organization did not have adequate controls in place to ensure transactions had proper documentation and approval prior to payment. Recommendation: We recommend management review each purchase to ensure it is supported by proper documentation and is properly approved prior to payment. Views of Responsible Officials: Management is in agreement with the finding. Corrective Action Plan: See attached corrective action plan.
Finding 2022-007 ? Reimbursement of Federal Awards Program Name: Substance Abuse and Mental Health Services ? Projects of Regional and National Significance ? Assistance Listing 93.243 Section 223 Demonstration Programs to Improve Community Mental Health Services ? Assistance Listing 93.829 Awarding Agency: U.S. Department of Health and Human Services, passed through Substance Abuse and Mental Health Services Administration, 2022 Finding Type: Significant Deficiency on Internal Controls over Compliance and Material Noncompliance Questioned Cost Amount: None Context / Criteria: 2CFR200.305(b)(3) requires expenses for reimbursement grants to be incurred and paid before reimbursement is requested. Condition: During our review of profit and loss statements for the federal grants to be included on the SEFA, it was noted that revenue exceeded expenditures for the reimbursement grants. Cause / Effect: The Organization did not have adequate controls in place to ensure expenditures were paid prior to requesting reimbursement. Management recorded the revenue in excess of expenses as refundable advance for the year ended September 30, 2022. Recommendation: We recommend management review reimbursement requests prior to submitting them to ensure the expenditures were paid prior to requesting reimbursement. Views of Responsible Officials: Management is in agreement with the finding. Corrective Action Plan: See attached corrective action plan.
Finding 2022-005 ? Supporting Documentation for Expenditures Program Name: Substance Abuse and Mental Health Services ? Projects of Regional and National Significance ? Assistance Listing 93.243 Section 223 Demonstration Programs to Improve Community Mental Health Services ? Assistance Listing 93.829 Awarding Agency: U.S. Department of Health and Human Services, passed through Substance Abuse and Mental Health Services Administration, 2022 Finding Type: Material Weakness on Internal Controls over Compliance and Material Noncompliance Questioned Cost Amount: None Context / Criteria: 2CFR200.403(g) requires expenses incurred must be for activities allowed under the terms and conditions of the federal award. Condition: During our review of expenditures, we noted transactions that did not have documentation to support the purchase, such as invoices, or documentation to show the purchase was approved prior to payment. For AL 93.243 21 of 50 transactions sampled lacked approvals for the disbursement. Additionally, 4 of 50 transactions lacked evidence for the disbursements. For AL 93.829 1 of 16 transactions sampled lacked evidence for the disbursements and approvals. Cause / Effect: The Organization did not have adequate controls in place to ensure transactions had proper documentation and approval prior to payment. Recommendation: We recommend management review each purchase to ensure it is supported by proper documentation and is properly approved prior to payment. Views of Responsible Officials: Management is in agreement with the finding. Corrective Action Plan: See attached corrective action plan.
Finding 2022-006, 2021-004, 2020-002 ? Time Reporting/Personnel Activity Reports Program Name: Substance Abuse and Mental Health Services ? Projects of Regional and National Significance ? Assistance Listing 93.243 Section 223 Demonstration Programs to Improve Community Mental Health Services ? Assistance Listing 93.829 Awarding Agency: U.S. Department of Health and Human Services, passed through Substance Abuse and Mental Health Services Administration, 2022 Finding Type: Material Weakness on Internal Controls over Compliance and Material Noncompliance Questioned Cost Amount: Unknown Context / Criteria: 2CFR200.400.430(i) requires the distribution of salary and wages charged to federal awards should be based on actual employee activity as reflected in personnel activity reports (timesheets), prepared after the fact, which include the total activity for which employees were compensated. Condition: For all payroll transactions selected during our test work, it was noted that the payroll register did not agree to the amounts charged to each grant. Additionally, there was not a personnel activity report (PAR) or timesheet equivalent provided to support the employees? time charged to the grant. For AL 93.243 60 of 60 transactions lacked personnel activity reports to document time spent on the award. Additionally, 21 of 60 transactions lacked approval for the pay period?s time entry. For AL 93.829 60 of 60 transactions lacked personnel activity reports to document time spent on the award. Additionally, 18 of 60 transactions lacked approval for the pay period?s time entry. Cause / Effect: The Organization did not have adequate controls in place to ensure amounts charged to the grant were properly supported and approved. Recommendation: We recommend management review payroll for accuracy, including comparing the timesheets/PARs to the payroll register, and the payroll register to the general ledger to ensure time charged to the grant accurately reflects work performed relating to the grant. Views of Responsible Officials: Management is in agreement with the finding. Corrective Action Plan: See attached corrective action plan.
Finding 2022-007 ? Reimbursement of Federal Awards Program Name: Substance Abuse and Mental Health Services ? Projects of Regional and National Significance ? Assistance Listing 93.243 Section 223 Demonstration Programs to Improve Community Mental Health Services ? Assistance Listing 93.829 Awarding Agency: U.S. Department of Health and Human Services, passed through Substance Abuse and Mental Health Services Administration, 2022 Finding Type: Significant Deficiency on Internal Controls over Compliance and Material Noncompliance Questioned Cost Amount: None Context / Criteria: 2CFR200.305(b)(3) requires expenses for reimbursement grants to be incurred and paid before reimbursement is requested. Condition: During our review of profit and loss statements for the federal grants to be included on the SEFA, it was noted that revenue exceeded expenditures for the reimbursement grants. Cause / Effect: The Organization did not have adequate controls in place to ensure expenditures were paid prior to requesting reimbursement. Management recorded the revenue in excess of expenses as refundable advance for the year ended September 30, 2022. Recommendation: We recommend management review reimbursement requests prior to submitting them to ensure the expenditures were paid prior to requesting reimbursement. Views of Responsible Officials: Management is in agreement with the finding. Corrective Action Plan: See attached corrective action plan.
Finding 2022-005 ? Supporting Documentation for Expenditures Program Name: Substance Abuse and Mental Health Services ? Projects of Regional and National Significance ? Assistance Listing 93.243 Section 223 Demonstration Programs to Improve Community Mental Health Services ? Assistance Listing 93.829 Awarding Agency: U.S. Department of Health and Human Services, passed through Substance Abuse and Mental Health Services Administration, 2022 Finding Type: Material Weakness on Internal Controls over Compliance and Material Noncompliance Questioned Cost Amount: None Context / Criteria: 2CFR200.403(g) requires expenses incurred must be for activities allowed under the terms and conditions of the federal award. Condition: During our review of expenditures, we noted transactions that did not have documentation to support the purchase, such as invoices, or documentation to show the purchase was approved prior to payment. For AL 93.243 21 of 50 transactions sampled lacked approvals for the disbursement. Additionally, 4 of 50 transactions lacked evidence for the disbursements. For AL 93.829 1 of 16 transactions sampled lacked evidence for the disbursements and approvals. Cause / Effect: The Organization did not have adequate controls in place to ensure transactions had proper documentation and approval prior to payment. Recommendation: We recommend management review each purchase to ensure it is supported by proper documentation and is properly approved prior to payment. Views of Responsible Officials: Management is in agreement with the finding. Corrective Action Plan: See attached corrective action plan.
Finding 2022-007 ? Reimbursement of Federal Awards Program Name: Substance Abuse and Mental Health Services ? Projects of Regional and National Significance ? Assistance Listing 93.243 Section 223 Demonstration Programs to Improve Community Mental Health Services ? Assistance Listing 93.829 Awarding Agency: U.S. Department of Health and Human Services, passed through Substance Abuse and Mental Health Services Administration, 2022 Finding Type: Significant Deficiency on Internal Controls over Compliance and Material Noncompliance Questioned Cost Amount: None Context / Criteria: 2CFR200.305(b)(3) requires expenses for reimbursement grants to be incurred and paid before reimbursement is requested. Condition: During our review of profit and loss statements for the federal grants to be included on the SEFA, it was noted that revenue exceeded expenditures for the reimbursement grants. Cause / Effect: The Organization did not have adequate controls in place to ensure expenditures were paid prior to requesting reimbursement. Management recorded the revenue in excess of expenses as refundable advance for the year ended September 30, 2022. Recommendation: We recommend management review reimbursement requests prior to submitting them to ensure the expenditures were paid prior to requesting reimbursement. Views of Responsible Officials: Management is in agreement with the finding. Corrective Action Plan: See attached corrective action plan.
Finding 2022-006, 2021-004, 2020-002 ? Time Reporting/Personnel Activity Reports Program Name: Substance Abuse and Mental Health Services ? Projects of Regional and National Significance ? Assistance Listing 93.243 Section 223 Demonstration Programs to Improve Community Mental Health Services ? Assistance Listing 93.829 Awarding Agency: U.S. Department of Health and Human Services, passed through Substance Abuse and Mental Health Services Administration, 2022 Finding Type: Material Weakness on Internal Controls over Compliance and Material Noncompliance Questioned Cost Amount: Unknown Context / Criteria: 2CFR200.400.430(i) requires the distribution of salary and wages charged to federal awards should be based on actual employee activity as reflected in personnel activity reports (timesheets), prepared after the fact, which include the total activity for which employees were compensated. Condition: For all payroll transactions selected during our test work, it was noted that the payroll register did not agree to the amounts charged to each grant. Additionally, there was not a personnel activity report (PAR) or timesheet equivalent provided to support the employees? time charged to the grant. For AL 93.243 60 of 60 transactions lacked personnel activity reports to document time spent on the award. Additionally, 21 of 60 transactions lacked approval for the pay period?s time entry. For AL 93.829 60 of 60 transactions lacked personnel activity reports to document time spent on the award. Additionally, 18 of 60 transactions lacked approval for the pay period?s time entry. Cause / Effect: The Organization did not have adequate controls in place to ensure amounts charged to the grant were properly supported and approved. Recommendation: We recommend management review payroll for accuracy, including comparing the timesheets/PARs to the payroll register, and the payroll register to the general ledger to ensure time charged to the grant accurately reflects work performed relating to the grant. Views of Responsible Officials: Management is in agreement with the finding. Corrective Action Plan: See attached corrective action plan.
Finding 2022-005 ? Supporting Documentation for Expenditures Program Name: Substance Abuse and Mental Health Services ? Projects of Regional and National Significance ? Assistance Listing 93.243 Section 223 Demonstration Programs to Improve Community Mental Health Services ? Assistance Listing 93.829 Awarding Agency: U.S. Department of Health and Human Services, passed through Substance Abuse and Mental Health Services Administration, 2022 Finding Type: Material Weakness on Internal Controls over Compliance and Material Noncompliance Questioned Cost Amount: None Context / Criteria: 2CFR200.403(g) requires expenses incurred must be for activities allowed under the terms and conditions of the federal award. Condition: During our review of expenditures, we noted transactions that did not have documentation to support the purchase, such as invoices, or documentation to show the purchase was approved prior to payment. For AL 93.243 21 of 50 transactions sampled lacked approvals for the disbursement. Additionally, 4 of 50 transactions lacked evidence for the disbursements. For AL 93.829 1 of 16 transactions sampled lacked evidence for the disbursements and approvals. Cause / Effect: The Organization did not have adequate controls in place to ensure transactions had proper documentation and approval prior to payment. Recommendation: We recommend management review each purchase to ensure it is supported by proper documentation and is properly approved prior to payment. Views of Responsible Officials: Management is in agreement with the finding. Corrective Action Plan: See attached corrective action plan.
Finding 2022-006, 2021-004, 2020-002 ? Time Reporting/Personnel Activity Reports Program Name: Substance Abuse and Mental Health Services ? Projects of Regional and National Significance ? Assistance Listing 93.243 Section 223 Demonstration Programs to Improve Community Mental Health Services ? Assistance Listing 93.829 Awarding Agency: U.S. Department of Health and Human Services, passed through Substance Abuse and Mental Health Services Administration, 2022 Finding Type: Material Weakness on Internal Controls over Compliance and Material Noncompliance Questioned Cost Amount: Unknown Context / Criteria: 2CFR200.400.430(i) requires the distribution of salary and wages charged to federal awards should be based on actual employee activity as reflected in personnel activity reports (timesheets), prepared after the fact, which include the total activity for which employees were compensated. Condition: For all payroll transactions selected during our test work, it was noted that the payroll register did not agree to the amounts charged to each grant. Additionally, there was not a personnel activity report (PAR) or timesheet equivalent provided to support the employees? time charged to the grant. For AL 93.243 60 of 60 transactions lacked personnel activity reports to document time spent on the award. Additionally, 21 of 60 transactions lacked approval for the pay period?s time entry. For AL 93.829 60 of 60 transactions lacked personnel activity reports to document time spent on the award. Additionally, 18 of 60 transactions lacked approval for the pay period?s time entry. Cause / Effect: The Organization did not have adequate controls in place to ensure amounts charged to the grant were properly supported and approved. Recommendation: We recommend management review payroll for accuracy, including comparing the timesheets/PARs to the payroll register, and the payroll register to the general ledger to ensure time charged to the grant accurately reflects work performed relating to the grant. Views of Responsible Officials: Management is in agreement with the finding. Corrective Action Plan: See attached corrective action plan.
Finding 2022-007 ? Reimbursement of Federal Awards Program Name: Substance Abuse and Mental Health Services ? Projects of Regional and National Significance ? Assistance Listing 93.243 Section 223 Demonstration Programs to Improve Community Mental Health Services ? Assistance Listing 93.829 Awarding Agency: U.S. Department of Health and Human Services, passed through Substance Abuse and Mental Health Services Administration, 2022 Finding Type: Significant Deficiency on Internal Controls over Compliance and Material Noncompliance Questioned Cost Amount: None Context / Criteria: 2CFR200.305(b)(3) requires expenses for reimbursement grants to be incurred and paid before reimbursement is requested. Condition: During our review of profit and loss statements for the federal grants to be included on the SEFA, it was noted that revenue exceeded expenditures for the reimbursement grants. Cause / Effect: The Organization did not have adequate controls in place to ensure expenditures were paid prior to requesting reimbursement. Management recorded the revenue in excess of expenses as refundable advance for the year ended September 30, 2022. Recommendation: We recommend management review reimbursement requests prior to submitting them to ensure the expenditures were paid prior to requesting reimbursement. Views of Responsible Officials: Management is in agreement with the finding. Corrective Action Plan: See attached corrective action plan.
Finding 2022-005 ? Supporting Documentation for Expenditures Program Name: Substance Abuse and Mental Health Services ? Projects of Regional and National Significance ? Assistance Listing 93.243 Section 223 Demonstration Programs to Improve Community Mental Health Services ? Assistance Listing 93.829 Awarding Agency: U.S. Department of Health and Human Services, passed through Substance Abuse and Mental Health Services Administration, 2022 Finding Type: Material Weakness on Internal Controls over Compliance and Material Noncompliance Questioned Cost Amount: None Context / Criteria: 2CFR200.403(g) requires expenses incurred must be for activities allowed under the terms and conditions of the federal award. Condition: During our review of expenditures, we noted transactions that did not have documentation to support the purchase, such as invoices, or documentation to show the purchase was approved prior to payment. For AL 93.243 21 of 50 transactions sampled lacked approvals for the disbursement. Additionally, 4 of 50 transactions lacked evidence for the disbursements. For AL 93.829 1 of 16 transactions sampled lacked evidence for the disbursements and approvals. Cause / Effect: The Organization did not have adequate controls in place to ensure transactions had proper documentation and approval prior to payment. Recommendation: We recommend management review each purchase to ensure it is supported by proper documentation and is properly approved prior to payment. Views of Responsible Officials: Management is in agreement with the finding. Corrective Action Plan: See attached corrective action plan.
Finding 2022-006, 2021-004, 2020-002 ? Time Reporting/Personnel Activity Reports Program Name: Substance Abuse and Mental Health Services ? Projects of Regional and National Significance ? Assistance Listing 93.243 Section 223 Demonstration Programs to Improve Community Mental Health Services ? Assistance Listing 93.829 Awarding Agency: U.S. Department of Health and Human Services, passed through Substance Abuse and Mental Health Services Administration, 2022 Finding Type: Material Weakness on Internal Controls over Compliance and Material Noncompliance Questioned Cost Amount: Unknown Context / Criteria: 2CFR200.400.430(i) requires the distribution of salary and wages charged to federal awards should be based on actual employee activity as reflected in personnel activity reports (timesheets), prepared after the fact, which include the total activity for which employees were compensated. Condition: For all payroll transactions selected during our test work, it was noted that the payroll register did not agree to the amounts charged to each grant. Additionally, there was not a personnel activity report (PAR) or timesheet equivalent provided to support the employees? time charged to the grant. For AL 93.243 60 of 60 transactions lacked personnel activity reports to document time spent on the award. Additionally, 21 of 60 transactions lacked approval for the pay period?s time entry. For AL 93.829 60 of 60 transactions lacked personnel activity reports to document time spent on the award. Additionally, 18 of 60 transactions lacked approval for the pay period?s time entry. Cause / Effect: The Organization did not have adequate controls in place to ensure amounts charged to the grant were properly supported and approved. Recommendation: We recommend management review payroll for accuracy, including comparing the timesheets/PARs to the payroll register, and the payroll register to the general ledger to ensure time charged to the grant accurately reflects work performed relating to the grant. Views of Responsible Officials: Management is in agreement with the finding. Corrective Action Plan: See attached corrective action plan.
Finding 2022-007 ? Reimbursement of Federal Awards Program Name: Substance Abuse and Mental Health Services ? Projects of Regional and National Significance ? Assistance Listing 93.243 Section 223 Demonstration Programs to Improve Community Mental Health Services ? Assistance Listing 93.829 Awarding Agency: U.S. Department of Health and Human Services, passed through Substance Abuse and Mental Health Services Administration, 2022 Finding Type: Significant Deficiency on Internal Controls over Compliance and Material Noncompliance Questioned Cost Amount: None Context / Criteria: 2CFR200.305(b)(3) requires expenses for reimbursement grants to be incurred and paid before reimbursement is requested. Condition: During our review of profit and loss statements for the federal grants to be included on the SEFA, it was noted that revenue exceeded expenditures for the reimbursement grants. Cause / Effect: The Organization did not have adequate controls in place to ensure expenditures were paid prior to requesting reimbursement. Management recorded the revenue in excess of expenses as refundable advance for the year ended September 30, 2022. Recommendation: We recommend management review reimbursement requests prior to submitting them to ensure the expenditures were paid prior to requesting reimbursement. Views of Responsible Officials: Management is in agreement with the finding. Corrective Action Plan: See attached corrective action plan.
Finding 2022-005 ? Supporting Documentation for Expenditures Program Name: Substance Abuse and Mental Health Services ? Projects of Regional and National Significance ? Assistance Listing 93.243 Section 223 Demonstration Programs to Improve Community Mental Health Services ? Assistance Listing 93.829 Awarding Agency: U.S. Department of Health and Human Services, passed through Substance Abuse and Mental Health Services Administration, 2022 Finding Type: Material Weakness on Internal Controls over Compliance and Material Noncompliance Questioned Cost Amount: None Context / Criteria: 2CFR200.403(g) requires expenses incurred must be for activities allowed under the terms and conditions of the federal award. Condition: During our review of expenditures, we noted transactions that did not have documentation to support the purchase, such as invoices, or documentation to show the purchase was approved prior to payment. For AL 93.243 21 of 50 transactions sampled lacked approvals for the disbursement. Additionally, 4 of 50 transactions lacked evidence for the disbursements. For AL 93.829 1 of 16 transactions sampled lacked evidence for the disbursements and approvals. Cause / Effect: The Organization did not have adequate controls in place to ensure transactions had proper documentation and approval prior to payment. Recommendation: We recommend management review each purchase to ensure it is supported by proper documentation and is properly approved prior to payment. Views of Responsible Officials: Management is in agreement with the finding. Corrective Action Plan: See attached corrective action plan.
Finding 2022-007 ? Reimbursement of Federal Awards Program Name: Substance Abuse and Mental Health Services ? Projects of Regional and National Significance ? Assistance Listing 93.243 Section 223 Demonstration Programs to Improve Community Mental Health Services ? Assistance Listing 93.829 Awarding Agency: U.S. Department of Health and Human Services, passed through Substance Abuse and Mental Health Services Administration, 2022 Finding Type: Significant Deficiency on Internal Controls over Compliance and Material Noncompliance Questioned Cost Amount: None Context / Criteria: 2CFR200.305(b)(3) requires expenses for reimbursement grants to be incurred and paid before reimbursement is requested. Condition: During our review of profit and loss statements for the federal grants to be included on the SEFA, it was noted that revenue exceeded expenditures for the reimbursement grants. Cause / Effect: The Organization did not have adequate controls in place to ensure expenditures were paid prior to requesting reimbursement. Management recorded the revenue in excess of expenses as refundable advance for the year ended September 30, 2022. Recommendation: We recommend management review reimbursement requests prior to submitting them to ensure the expenditures were paid prior to requesting reimbursement. Views of Responsible Officials: Management is in agreement with the finding. Corrective Action Plan: See attached corrective action plan.
Finding 2022-006, 2021-004, 2020-002 ? Time Reporting/Personnel Activity Reports Program Name: Substance Abuse and Mental Health Services ? Projects of Regional and National Significance ? Assistance Listing 93.243 Section 223 Demonstration Programs to Improve Community Mental Health Services ? Assistance Listing 93.829 Awarding Agency: U.S. Department of Health and Human Services, passed through Substance Abuse and Mental Health Services Administration, 2022 Finding Type: Material Weakness on Internal Controls over Compliance and Material Noncompliance Questioned Cost Amount: Unknown Context / Criteria: 2CFR200.400.430(i) requires the distribution of salary and wages charged to federal awards should be based on actual employee activity as reflected in personnel activity reports (timesheets), prepared after the fact, which include the total activity for which employees were compensated. Condition: For all payroll transactions selected during our test work, it was noted that the payroll register did not agree to the amounts charged to each grant. Additionally, there was not a personnel activity report (PAR) or timesheet equivalent provided to support the employees? time charged to the grant. For AL 93.243 60 of 60 transactions lacked personnel activity reports to document time spent on the award. Additionally, 21 of 60 transactions lacked approval for the pay period?s time entry. For AL 93.829 60 of 60 transactions lacked personnel activity reports to document time spent on the award. Additionally, 18 of 60 transactions lacked approval for the pay period?s time entry. Cause / Effect: The Organization did not have adequate controls in place to ensure amounts charged to the grant were properly supported and approved. Recommendation: We recommend management review payroll for accuracy, including comparing the timesheets/PARs to the payroll register, and the payroll register to the general ledger to ensure time charged to the grant accurately reflects work performed relating to the grant. Views of Responsible Officials: Management is in agreement with the finding. Corrective Action Plan: See attached corrective action plan.
Finding 2022-006, 2021-004, 2020-002 ? Time Reporting/Personnel Activity Reports Program Name: Substance Abuse and Mental Health Services ? Projects of Regional and National Significance ? Assistance Listing 93.243 Section 223 Demonstration Programs to Improve Community Mental Health Services ? Assistance Listing 93.829 Awarding Agency: U.S. Department of Health and Human Services, passed through Substance Abuse and Mental Health Services Administration, 2022 Finding Type: Material Weakness on Internal Controls over Compliance and Material Noncompliance Questioned Cost Amount: Unknown Context / Criteria: 2CFR200.400.430(i) requires the distribution of salary and wages charged to federal awards should be based on actual employee activity as reflected in personnel activity reports (timesheets), prepared after the fact, which include the total activity for which employees were compensated. Condition: For all payroll transactions selected during our test work, it was noted that the payroll register did not agree to the amounts charged to each grant. Additionally, there was not a personnel activity report (PAR) or timesheet equivalent provided to support the employees? time charged to the grant. For AL 93.243 60 of 60 transactions lacked personnel activity reports to document time spent on the award. Additionally, 21 of 60 transactions lacked approval for the pay period?s time entry. For AL 93.829 60 of 60 transactions lacked personnel activity reports to document time spent on the award. Additionally, 18 of 60 transactions lacked approval for the pay period?s time entry. Cause / Effect: The Organization did not have adequate controls in place to ensure amounts charged to the grant were properly supported and approved. Recommendation: We recommend management review payroll for accuracy, including comparing the timesheets/PARs to the payroll register, and the payroll register to the general ledger to ensure time charged to the grant accurately reflects work performed relating to the grant. Views of Responsible Officials: Management is in agreement with the finding. Corrective Action Plan: See attached corrective action plan.
Finding 2022-005 ? Supporting Documentation for Expenditures Program Name: Substance Abuse and Mental Health Services ? Projects of Regional and National Significance ? Assistance Listing 93.243 Section 223 Demonstration Programs to Improve Community Mental Health Services ? Assistance Listing 93.829 Awarding Agency: U.S. Department of Health and Human Services, passed through Substance Abuse and Mental Health Services Administration, 2022 Finding Type: Material Weakness on Internal Controls over Compliance and Material Noncompliance Questioned Cost Amount: None Context / Criteria: 2CFR200.403(g) requires expenses incurred must be for activities allowed under the terms and conditions of the federal award. Condition: During our review of expenditures, we noted transactions that did not have documentation to support the purchase, such as invoices, or documentation to show the purchase was approved prior to payment. For AL 93.243 21 of 50 transactions sampled lacked approvals for the disbursement. Additionally, 4 of 50 transactions lacked evidence for the disbursements. For AL 93.829 1 of 16 transactions sampled lacked evidence for the disbursements and approvals. Cause / Effect: The Organization did not have adequate controls in place to ensure transactions had proper documentation and approval prior to payment. Recommendation: We recommend management review each purchase to ensure it is supported by proper documentation and is properly approved prior to payment. Views of Responsible Officials: Management is in agreement with the finding. Corrective Action Plan: See attached corrective action plan.
Finding 2022-007 ? Reimbursement of Federal Awards Program Name: Substance Abuse and Mental Health Services ? Projects of Regional and National Significance ? Assistance Listing 93.243 Section 223 Demonstration Programs to Improve Community Mental Health Services ? Assistance Listing 93.829 Awarding Agency: U.S. Department of Health and Human Services, passed through Substance Abuse and Mental Health Services Administration, 2022 Finding Type: Significant Deficiency on Internal Controls over Compliance and Material Noncompliance Questioned Cost Amount: None Context / Criteria: 2CFR200.305(b)(3) requires expenses for reimbursement grants to be incurred and paid before reimbursement is requested. Condition: During our review of profit and loss statements for the federal grants to be included on the SEFA, it was noted that revenue exceeded expenditures for the reimbursement grants. Cause / Effect: The Organization did not have adequate controls in place to ensure expenditures were paid prior to requesting reimbursement. Management recorded the revenue in excess of expenses as refundable advance for the year ended September 30, 2022. Recommendation: We recommend management review reimbursement requests prior to submitting them to ensure the expenditures were paid prior to requesting reimbursement. Views of Responsible Officials: Management is in agreement with the finding. Corrective Action Plan: See attached corrective action plan.