Finding 517903 (2023-006)

Significant Deficiency
Requirement
L
Questioned Costs
-
Year
2023
Accepted
2025-01-07
Audit: 336157
Organization: Hips (DC)

AI Summary

  • Core Issue: HIPS miscalculated the de minimis indirect rate and lacked documentation for timely financial and programmatic report submissions.
  • Impacted Requirements: Compliance with federal financial and programmatic reporting standards is at risk, potentially leading to payment issues or award ineligibility.
  • Recommended Follow-Up: Recalculate the indirect rate correctly, improve internal controls for report accuracy, and establish a tracking system for timely submissions.

Finding Text

Finding 2023-006: Financial and Programmatic Reporting Information on the Federal Program: Assistance Listing Number 93.788 Criteria or Specific Requirement: HIPS is required to comply with applicable statutes, regulations, and the terms and conditions of the Federal awards pertaining to financial and programmatic reporting requirements. Condition: HIPS incorrectly calculated the de minimis indirect rate on financial reports submitted during the year. We also noted certain financial programmatic reports did not have sufficient documentation to support timely submission of required reports on the awards under audit. Cause: The de minimis rates on financial reports reviewed were not correct due to formula errors on the modified direct cost base used for the calculation on reports submit. Reporting deadlines for proved challenging to meet due to the turnover of key staff and the administrative burdens associated with gathering the data necessary to complete the reports. Reports submissions for certain awards did not have supporting documentation for the date of submission due to the information not being available in the system that the reports are submit to. Lastly, we noted certain awards were approved prior to the end of the reporting period due to administrative limitations on review and approval of reports. Effect or Potential Effect: Noncompliance with financial and programmatic reporting requirements could potentially result in the withholding of future payments, award suspension or termination, and ineligibility of future awards. Questioned Costs: None Context: The exceptions noted during the audit pertained to all Department of Human and Health Services (HHS) awards under audit for the year ended September 30, 2023. Identification as a Repeat Finding, if Applicable: Not applicable Recommendation: HIPS should recalculate the de minimis indirect rate in accordance with the applicable cost principles as outlined in 2 CFR 200.414 (if applicable) or other relevant guidance based on the award agreements. HIPS should ensure that any miscalculations are promptly corrected, and any indirect costs calculation formulas are adjusted on future reports. Furthermore, HIPS should implement internal controls to regularly verify the correct application of the de minimis rate to avoid similar errors in the future. HIPS should implement a system to track and ensure the timely submission of all financial and programmatic reports as required by the award agreements. This includes reviewing the terms and conditions of each award to identify mandatory reporting requirements, and establishing internal controls or to ensure accurate and timely reporting. Submission of reports should be retained internally for documentation purposes.

Corrective Action Plan

Views of Responsible Officials: Prior to receiving this finding, HIPS was not in the practice of saving documentation of financial or programmatic reporting submission. Staff responsible for submissions are now documenting submission of reports as of 2024. Incorrect application of the de minimis rate was due to an error in the funder-provided spreadsheet. HIPS Finance Manager has been tasked with checking all spreadsheet calculations prior to submissions of financial reporting.

Categories

Allowable Costs / Cost Principles Procurement, Suspension & Debarment Eligibility Reporting

Other Findings in this Audit

  • 517900 2023-004
    Significant Deficiency
  • 517901 2023-004
    Significant Deficiency
  • 517902 2023-005
    Significant Deficiency
  • 517904 2023-004
    Significant Deficiency
  • 517905 2023-005
    Significant Deficiency
  • 517906 2023-006
    Significant Deficiency
  • 517907 2023-004
    Significant Deficiency
  • 517908 2023-005
    Significant Deficiency
  • 517909 2023-006
    Significant Deficiency
  • 517910 2023-004
    Significant Deficiency
  • 517911 2023-004
    Significant Deficiency
  • 517912 2023-004
    Significant Deficiency
  • 517913 2023-004
    Significant Deficiency
  • 1094342 2023-004
    Significant Deficiency
  • 1094343 2023-004
    Significant Deficiency
  • 1094344 2023-005
    Significant Deficiency
  • 1094345 2023-006
    Significant Deficiency
  • 1094346 2023-004
    Significant Deficiency
  • 1094347 2023-005
    Significant Deficiency
  • 1094348 2023-006
    Significant Deficiency
  • 1094349 2023-004
    Significant Deficiency
  • 1094350 2023-005
    Significant Deficiency
  • 1094351 2023-006
    Significant Deficiency
  • 1094352 2023-004
    Significant Deficiency
  • 1094353 2023-004
    Significant Deficiency
  • 1094354 2023-004
    Significant Deficiency
  • 1094355 2023-004
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
93.788 Opioid Str $691,569
93.243 Substance Abuse and Mental Health Services Projects of Regional and National Significance $367,952
93.136 Injury Prevention and Control Research and State and Community Based Programs $316,551
93.421 Strengthening Public Health Systems and Services Through National Partnerships to Improve and Protect the Nation�s Health $107,962
93.940 Hiv Prevention Activities Health Department Based $99,930
93.944 Human Immunodeficiency Virus (hiv)/acquired Immunodeficiency Virus Syndrome (aids) Surveillance $88,204