Finding 1118450 (2024-003)

Significant Deficiency Repeat Finding
Requirement
AB
Questioned Costs
$1
Year
2024
Accepted
2025-03-31

AI Summary

  • Core Issue: Significant errors in payroll expense calculations led to potential noncompliance with federal grant requirements.
  • Impacted Requirements: Internal controls over allowable costs were ineffective, risking submission of disallowed costs under federal awards.
  • Recommended Follow-Up: Management should review and improve procedures for payroll allocation and expenditure tracking to ensure compliance.

Finding Text

Department of Health and Human Services FFAL #93.087, 90CU0095, 9/30/2018 – 9/29/2024 Enhance Safety of Children Affected by Substance Abuse Activities Allowed or Unallowed and Allowable Costs and Cost Principles Significant Deficiency in Internal Control over Compliance Criteria: The Center is required to have procedures in place to ensure that federal awards are expended only for allowable costs in accordance with Subpart E – Cost Principles of the Uniform Guidance. Allowable costs are supported by appropriate documentation and correctly charged as to account, amount, and period. 2 CFR 200.303(a) establishes that the auditee must establish and maintain effective internal control over the federal award that provides assurance that the entity is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. Condition: In our sample of expenditures selected for testing, we noted calculation errors when allocating payroll expenses to the federal grant. Cause: The calculation errors were due to the use of a wrong employee’s allocation percentage, a keying error for the amount of payroll taxes for an employee, and not properly updating the calculation of worker’s compensation based upon the new percentage effective January 1, 2024 for the state of Iowa. In addition, the secondary review of federal grant expenditure tracking spreadsheet did not identify the calculation errors. Effect: The Center’s controls did not detect or correct the errors identified, which results in a reasonable possibility that the Center could submit disallowed costs under the federal awards and would not be able to detect and correct noncompliance in a timely manner. Questioned Costs: The program was overcharged by $1,348. Context: A total non-statistical sample of 60 nonpayroll and payroll transactions out of more than 250 transactions were selected for testing, which accounted for $113,666 of $474,590 of federal payroll and nonpayroll direct program expenditures. Repeat Finding from Prior Year: Yes, prior year finding 2023-003 Recommendation: We recommend management review the procedures and control processes involving allocating payroll expenses and the federal grant expenditure tracking spreadsheet to ensure compliance with the federal grant. Views of Responsible Officials: Management is in agreement.

Categories

Questioned Costs Allowable Costs / Cost Principles

Other Findings in this Audit

  • 542008 2024-003
    Significant Deficiency Repeat
  • 542009 2024-004
    Significant Deficiency
  • 542010 2024-005
    Significant Deficiency Repeat
  • 1118451 2024-004
    Significant Deficiency
  • 1118452 2024-005
    Significant Deficiency Repeat

Programs in Audit

ALN Program Name Expenditures
93.696 Certified Community Behavioral Health Clinic Expansion Grants $1.11M
93.958 Block Grants for Community Mental Health Services $1.07M
93.087 Enhance Safety of Children Affected by Substance Abuse $608,135
93.243 Substance Abuse and Mental Health Services Projects of Regional and National Significance $308,828
16.575 Crime Victim Assistance $251,784
93.912 Rural Health Care Services Outreach, Rural Health Network Development and Small Health Care Provider Quality Improvement $196,585
93.211 Rural Telemedicine Grants $38,346
93.788 Opioid Str $27,758
93.829 Section 223 Demonstration Programs to Improve Community Mental Health Services $20,000