Finding 1094354 (2023-004)

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

AI Summary

  • Core Issue: HIPS struggled to prepare an accurate Schedule of Expenditures of Federal Awards (SEFA) due to employee turnover affecting financial reporting.
  • Impacted Requirements: Compliance with 2 CFR Section 200.508 (b) was not met, leading to delays in the audit process.
  • Recommended Follow-Up: Implement distinct codes for each Federal program in the accounting system and ensure consistent reconciliation of expenditures throughout the year.

Finding Text

Finding 2003-04: Schedule of Expenditures of Federal Awards Information on the Federal Program: All programs in the 2023 SEFA. See Finding 2023-003 Questioned Costs: None. Context: The exception noted during the audit pertained to all programs under the SEFA for the year ended September 30, 2023. Identification as a Repeat Finding, if Applicable: Not applicable. Criteria or Specific Requirement: In accordance with 2 CFR Section 200.508 (b), HIPS is required to prepare appropriate financial statements, including the Schedule of Expenditures of Federal Awards (SEFA). Condition: During the audit, we noted that HIPS experienced difficulty in preparing and ensuring that all Federal expenditures were properly included in the Schedule of Expenditures of Federal Awards. As a result, a significant amount of time was spent by management during the audit process reconciling the schedule, resulting in an audit delay. Cause: HIPS experienced turnover during the last fiscal year, specifically related to employees responsible for financial reporting and tracking of Federal award expenditures. Effect or Potential Effect: HIPS experienced difficulty in preparing an accurate SEFA. Recommendation: We recommend that each Federal program should have a distinct code set up in the accounting system in order to track the direct costs attributable to that program. We also recommend that management properly reconcile Federal expenditures during year on a consistent basis in order to prepare the Schedule of Expenditures of Federal Awards on a timely basis.

Categories

Reporting

Other Findings in this Audit

  • 517900 2023-004
    Significant Deficiency
  • 517901 2023-004
    Significant Deficiency
  • 517902 2023-005
    Significant Deficiency
  • 517903 2023-006
    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
  • 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