Audit 352372

FY End
2024-09-30
Total Expended
$2.59M
Findings
12
Programs
5
Year: 2024 Accepted: 2025-04-01

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
553777 2024-005 Significant Deficiency Yes B
553778 2024-005 Significant Deficiency Yes B
553779 2024-005 Significant Deficiency Yes B
553780 2024-005 Significant Deficiency Yes B
553781 2024-005 Significant Deficiency Yes B
553782 2024-006 Significant Deficiency Yes A
1130219 2024-005 Significant Deficiency Yes B
1130220 2024-005 Significant Deficiency Yes B
1130221 2024-005 Significant Deficiency Yes B
1130222 2024-005 Significant Deficiency Yes B
1130223 2024-005 Significant Deficiency Yes B
1130224 2024-006 Significant Deficiency Yes A

Contacts

Name Title Type
NBBSKPEAHJ25 Shereda Finch Auditee
3342621629 Jeri S Groce Auditor
No contacts on file

Notes to SEFA

Accounting Policies: The accompanying schedule of expenditures of federal awards includes the federal grant activity of Council on Substance Abuse – NCADD and is presented on the accrual basis of accounting. The information in this schedule is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards. Therefore, some amounts presented in this schedule may differ from amounts presented in, or used in the preparation of, the basic financial statements. The Council did not provide federal awards to subrecipients during the year. De Minimis Rate Used: N Rate Explanation: The Council did not elect to charge a de minimis rate of 10% for federal awards.

Finding Details

Finding 2024-005 Allowable Costs–Payroll Costs (Significant Deficiency and Noncompliance) (Repeat Finding) Information on the Federal Program: U.S. Department of Health and Human Services, Assistance Listing #93.243 Substance Abuse and Mental Health Services Projects of Regional and National Significance. Criteria: 2 CFR section 200.302 establishes the requirements for sufficient financial management over grant funding to ensure records adequately identify the source and application of funds for federally funded activities. These records must contain information pertaining to Federal awards, authorizations, financial obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. Condition: We tested 32 payroll disbursements across five pay periods. Of those 32, 5 exceptions were noted. One exception was that the amount of time and corresponding amounts allocated to the grant did not agree to the percentage documented on the employee’s timesheet. For the other 4 exceptions, the supporting time sheets could not be provided for a pay period tested. Cause: Employee timesheets are turned in after payroll is processed and allocations made, the timesheet in this exception did not agree to the amount allocated. Four supporting time sheets for a January payroll processed could not be located. Effect: The Council did not retain proper documentation to support payroll costs charged to the grant. Questioned Costs: $729 Recommendation: We recommend the Council strengthen procedures surrounding payroll so that the source documentation agrees to and is retained to support the amounts being allocated to the grant based on actual employee time. Views of Responsible Officials: See Management’s View and Corrective Action Plan at the end of the report.
Finding 2024-005 Allowable Costs–Payroll Costs (Significant Deficiency and Noncompliance) (Repeat Finding) Information on the Federal Program: U.S. Department of Health and Human Services, Assistance Listing #93.243 Substance Abuse and Mental Health Services Projects of Regional and National Significance. Criteria: 2 CFR section 200.302 establishes the requirements for sufficient financial management over grant funding to ensure records adequately identify the source and application of funds for federally funded activities. These records must contain information pertaining to Federal awards, authorizations, financial obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. Condition: We tested 32 payroll disbursements across five pay periods. Of those 32, 5 exceptions were noted. One exception was that the amount of time and corresponding amounts allocated to the grant did not agree to the percentage documented on the employee’s timesheet. For the other 4 exceptions, the supporting time sheets could not be provided for a pay period tested. Cause: Employee timesheets are turned in after payroll is processed and allocations made, the timesheet in this exception did not agree to the amount allocated. Four supporting time sheets for a January payroll processed could not be located. Effect: The Council did not retain proper documentation to support payroll costs charged to the grant. Questioned Costs: $729 Recommendation: We recommend the Council strengthen procedures surrounding payroll so that the source documentation agrees to and is retained to support the amounts being allocated to the grant based on actual employee time. Views of Responsible Officials: See Management’s View and Corrective Action Plan at the end of the report.
Finding 2024-005 Allowable Costs–Payroll Costs (Significant Deficiency and Noncompliance) (Repeat Finding) Information on the Federal Program: U.S. Department of Health and Human Services, Assistance Listing #93.243 Substance Abuse and Mental Health Services Projects of Regional and National Significance. Criteria: 2 CFR section 200.302 establishes the requirements for sufficient financial management over grant funding to ensure records adequately identify the source and application of funds for federally funded activities. These records must contain information pertaining to Federal awards, authorizations, financial obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. Condition: We tested 32 payroll disbursements across five pay periods. Of those 32, 5 exceptions were noted. One exception was that the amount of time and corresponding amounts allocated to the grant did not agree to the percentage documented on the employee’s timesheet. For the other 4 exceptions, the supporting time sheets could not be provided for a pay period tested. Cause: Employee timesheets are turned in after payroll is processed and allocations made, the timesheet in this exception did not agree to the amount allocated. Four supporting time sheets for a January payroll processed could not be located. Effect: The Council did not retain proper documentation to support payroll costs charged to the grant. Questioned Costs: $729 Recommendation: We recommend the Council strengthen procedures surrounding payroll so that the source documentation agrees to and is retained to support the amounts being allocated to the grant based on actual employee time. Views of Responsible Officials: See Management’s View and Corrective Action Plan at the end of the report.
Finding 2024-005 Allowable Costs–Payroll Costs (Significant Deficiency and Noncompliance) (Repeat Finding) Information on the Federal Program: U.S. Department of Health and Human Services, Assistance Listing #93.243 Substance Abuse and Mental Health Services Projects of Regional and National Significance. Criteria: 2 CFR section 200.302 establishes the requirements for sufficient financial management over grant funding to ensure records adequately identify the source and application of funds for federally funded activities. These records must contain information pertaining to Federal awards, authorizations, financial obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. Condition: We tested 32 payroll disbursements across five pay periods. Of those 32, 5 exceptions were noted. One exception was that the amount of time and corresponding amounts allocated to the grant did not agree to the percentage documented on the employee’s timesheet. For the other 4 exceptions, the supporting time sheets could not be provided for a pay period tested. Cause: Employee timesheets are turned in after payroll is processed and allocations made, the timesheet in this exception did not agree to the amount allocated. Four supporting time sheets for a January payroll processed could not be located. Effect: The Council did not retain proper documentation to support payroll costs charged to the grant. Questioned Costs: $729 Recommendation: We recommend the Council strengthen procedures surrounding payroll so that the source documentation agrees to and is retained to support the amounts being allocated to the grant based on actual employee time. Views of Responsible Officials: See Management’s View and Corrective Action Plan at the end of the report.
Finding 2024-005 Allowable Costs–Payroll Costs (Significant Deficiency and Noncompliance) (Repeat Finding) Information on the Federal Program: U.S. Department of Health and Human Services, Assistance Listing #93.243 Substance Abuse and Mental Health Services Projects of Regional and National Significance. Criteria: 2 CFR section 200.302 establishes the requirements for sufficient financial management over grant funding to ensure records adequately identify the source and application of funds for federally funded activities. These records must contain information pertaining to Federal awards, authorizations, financial obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. Condition: We tested 32 payroll disbursements across five pay periods. Of those 32, 5 exceptions were noted. One exception was that the amount of time and corresponding amounts allocated to the grant did not agree to the percentage documented on the employee’s timesheet. For the other 4 exceptions, the supporting time sheets could not be provided for a pay period tested. Cause: Employee timesheets are turned in after payroll is processed and allocations made, the timesheet in this exception did not agree to the amount allocated. Four supporting time sheets for a January payroll processed could not be located. Effect: The Council did not retain proper documentation to support payroll costs charged to the grant. Questioned Costs: $729 Recommendation: We recommend the Council strengthen procedures surrounding payroll so that the source documentation agrees to and is retained to support the amounts being allocated to the grant based on actual employee time. Views of Responsible Officials: See Management’s View and Corrective Action Plan at the end of the report.
Finding 2024-006 – Activities Allowed (Significant Deficiency and Noncompliance)(Repeat Finding) Information on the Federal Program: U.S. Department of Veterans Affairs, Assistance Listing #64.055 Staff Sergeant Parker Gordon Fox Suicide Prevention Grant Program. Criteria: 2 CFR section 200.302 establishes the requirements for sufficient financial management over grant funding to ensure funds have been used in accordance with Federal statues, regulations, and terms and conditions of the Federal award. These requirements include that the nonfederal entity compare expenditures with the approved award budget. Condition: We tested 22 nonpayroll disbursements; one of those expenses did not fit into an expense category in the approved award budget. Cause: The Council began allocating non-reimbursable expenses to their grant codes to track the true costs of running a program. This grant allowed for indirect costs; however, these costs were charged directly to the grant and were included in the amount requested for reimbursement and also in the cost base used for the indirect cost calculation. These costs were not in line with the categories of expenses in the award budget. Effect: The Council allocated costs that were not allowable activities per the grant budget. Questioned Costs: $255 Recommendation: We recommend the Council strengthen procedures over costs invoiced for reimbursement to ensure those costs are compared to the grant budget for allowability. Views of Responsible Officials: See Management’s View and Corrective Action Plan at the end of the report.
Finding 2024-005 Allowable Costs–Payroll Costs (Significant Deficiency and Noncompliance) (Repeat Finding) Information on the Federal Program: U.S. Department of Health and Human Services, Assistance Listing #93.243 Substance Abuse and Mental Health Services Projects of Regional and National Significance. Criteria: 2 CFR section 200.302 establishes the requirements for sufficient financial management over grant funding to ensure records adequately identify the source and application of funds for federally funded activities. These records must contain information pertaining to Federal awards, authorizations, financial obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. Condition: We tested 32 payroll disbursements across five pay periods. Of those 32, 5 exceptions were noted. One exception was that the amount of time and corresponding amounts allocated to the grant did not agree to the percentage documented on the employee’s timesheet. For the other 4 exceptions, the supporting time sheets could not be provided for a pay period tested. Cause: Employee timesheets are turned in after payroll is processed and allocations made, the timesheet in this exception did not agree to the amount allocated. Four supporting time sheets for a January payroll processed could not be located. Effect: The Council did not retain proper documentation to support payroll costs charged to the grant. Questioned Costs: $729 Recommendation: We recommend the Council strengthen procedures surrounding payroll so that the source documentation agrees to and is retained to support the amounts being allocated to the grant based on actual employee time. Views of Responsible Officials: See Management’s View and Corrective Action Plan at the end of the report.
Finding 2024-005 Allowable Costs–Payroll Costs (Significant Deficiency and Noncompliance) (Repeat Finding) Information on the Federal Program: U.S. Department of Health and Human Services, Assistance Listing #93.243 Substance Abuse and Mental Health Services Projects of Regional and National Significance. Criteria: 2 CFR section 200.302 establishes the requirements for sufficient financial management over grant funding to ensure records adequately identify the source and application of funds for federally funded activities. These records must contain information pertaining to Federal awards, authorizations, financial obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. Condition: We tested 32 payroll disbursements across five pay periods. Of those 32, 5 exceptions were noted. One exception was that the amount of time and corresponding amounts allocated to the grant did not agree to the percentage documented on the employee’s timesheet. For the other 4 exceptions, the supporting time sheets could not be provided for a pay period tested. Cause: Employee timesheets are turned in after payroll is processed and allocations made, the timesheet in this exception did not agree to the amount allocated. Four supporting time sheets for a January payroll processed could not be located. Effect: The Council did not retain proper documentation to support payroll costs charged to the grant. Questioned Costs: $729 Recommendation: We recommend the Council strengthen procedures surrounding payroll so that the source documentation agrees to and is retained to support the amounts being allocated to the grant based on actual employee time. Views of Responsible Officials: See Management’s View and Corrective Action Plan at the end of the report.
Finding 2024-005 Allowable Costs–Payroll Costs (Significant Deficiency and Noncompliance) (Repeat Finding) Information on the Federal Program: U.S. Department of Health and Human Services, Assistance Listing #93.243 Substance Abuse and Mental Health Services Projects of Regional and National Significance. Criteria: 2 CFR section 200.302 establishes the requirements for sufficient financial management over grant funding to ensure records adequately identify the source and application of funds for federally funded activities. These records must contain information pertaining to Federal awards, authorizations, financial obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. Condition: We tested 32 payroll disbursements across five pay periods. Of those 32, 5 exceptions were noted. One exception was that the amount of time and corresponding amounts allocated to the grant did not agree to the percentage documented on the employee’s timesheet. For the other 4 exceptions, the supporting time sheets could not be provided for a pay period tested. Cause: Employee timesheets are turned in after payroll is processed and allocations made, the timesheet in this exception did not agree to the amount allocated. Four supporting time sheets for a January payroll processed could not be located. Effect: The Council did not retain proper documentation to support payroll costs charged to the grant. Questioned Costs: $729 Recommendation: We recommend the Council strengthen procedures surrounding payroll so that the source documentation agrees to and is retained to support the amounts being allocated to the grant based on actual employee time. Views of Responsible Officials: See Management’s View and Corrective Action Plan at the end of the report.
Finding 2024-005 Allowable Costs–Payroll Costs (Significant Deficiency and Noncompliance) (Repeat Finding) Information on the Federal Program: U.S. Department of Health and Human Services, Assistance Listing #93.243 Substance Abuse and Mental Health Services Projects of Regional and National Significance. Criteria: 2 CFR section 200.302 establishes the requirements for sufficient financial management over grant funding to ensure records adequately identify the source and application of funds for federally funded activities. These records must contain information pertaining to Federal awards, authorizations, financial obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. Condition: We tested 32 payroll disbursements across five pay periods. Of those 32, 5 exceptions were noted. One exception was that the amount of time and corresponding amounts allocated to the grant did not agree to the percentage documented on the employee’s timesheet. For the other 4 exceptions, the supporting time sheets could not be provided for a pay period tested. Cause: Employee timesheets are turned in after payroll is processed and allocations made, the timesheet in this exception did not agree to the amount allocated. Four supporting time sheets for a January payroll processed could not be located. Effect: The Council did not retain proper documentation to support payroll costs charged to the grant. Questioned Costs: $729 Recommendation: We recommend the Council strengthen procedures surrounding payroll so that the source documentation agrees to and is retained to support the amounts being allocated to the grant based on actual employee time. Views of Responsible Officials: See Management’s View and Corrective Action Plan at the end of the report.
Finding 2024-005 Allowable Costs–Payroll Costs (Significant Deficiency and Noncompliance) (Repeat Finding) Information on the Federal Program: U.S. Department of Health and Human Services, Assistance Listing #93.243 Substance Abuse and Mental Health Services Projects of Regional and National Significance. Criteria: 2 CFR section 200.302 establishes the requirements for sufficient financial management over grant funding to ensure records adequately identify the source and application of funds for federally funded activities. These records must contain information pertaining to Federal awards, authorizations, financial obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. Condition: We tested 32 payroll disbursements across five pay periods. Of those 32, 5 exceptions were noted. One exception was that the amount of time and corresponding amounts allocated to the grant did not agree to the percentage documented on the employee’s timesheet. For the other 4 exceptions, the supporting time sheets could not be provided for a pay period tested. Cause: Employee timesheets are turned in after payroll is processed and allocations made, the timesheet in this exception did not agree to the amount allocated. Four supporting time sheets for a January payroll processed could not be located. Effect: The Council did not retain proper documentation to support payroll costs charged to the grant. Questioned Costs: $729 Recommendation: We recommend the Council strengthen procedures surrounding payroll so that the source documentation agrees to and is retained to support the amounts being allocated to the grant based on actual employee time. Views of Responsible Officials: See Management’s View and Corrective Action Plan at the end of the report.
Finding 2024-006 – Activities Allowed (Significant Deficiency and Noncompliance)(Repeat Finding) Information on the Federal Program: U.S. Department of Veterans Affairs, Assistance Listing #64.055 Staff Sergeant Parker Gordon Fox Suicide Prevention Grant Program. Criteria: 2 CFR section 200.302 establishes the requirements for sufficient financial management over grant funding to ensure funds have been used in accordance with Federal statues, regulations, and terms and conditions of the Federal award. These requirements include that the nonfederal entity compare expenditures with the approved award budget. Condition: We tested 22 nonpayroll disbursements; one of those expenses did not fit into an expense category in the approved award budget. Cause: The Council began allocating non-reimbursable expenses to their grant codes to track the true costs of running a program. This grant allowed for indirect costs; however, these costs were charged directly to the grant and were included in the amount requested for reimbursement and also in the cost base used for the indirect cost calculation. These costs were not in line with the categories of expenses in the award budget. Effect: The Council allocated costs that were not allowable activities per the grant budget. Questioned Costs: $255 Recommendation: We recommend the Council strengthen procedures over costs invoiced for reimbursement to ensure those costs are compared to the grant budget for allowability. Views of Responsible Officials: See Management’s View and Corrective Action Plan at the end of the report.