Finding 1236790 (2023-016)

Material Weakness Repeat Finding
Requirement
P
Questioned Costs
-
Year
2023
Accepted
2026-09-25
Audit: 412274
Auditor: CBIZ CPAS PC

AI Summary

  • Core Issue: Indirect costs charged to federal awards were based on a provisional rate that was higher than the actual rate, leading to overstatements.
  • Impacted Requirements: Lack of documentation and reconciliation violates federal guidelines for allowable costs under the Uniform Guidance.
  • Recommended Follow-Up: Implement procedures for year-end calculations and adjustments of indirect costs, along with a review control for annual reconciliations.

Finding Text

CRITERIA Under the Uniform Guidance (2 CFR Part 200, Subpart E), recipients of federal awards must maintain documentation to support costs charged to federal programs, including indirect costs. The documentation should demonstrate that costs are allocable, allowable, and in accordance with the approved indirect cost rate agreement, if applicable. CONDITION AND CONTEXT UHU charged indirect costs to federal awards throughout the fiscal year using a provisional indirect cost rate that exceeded the actual rate calculated based on year-end financial information. Management did not perform a year-end reconciliation or adjustment to align indirect costs charged to federal awards with the actual allowable indirect cost rate. As a result, indirect costs charged to federal programs were overstated by the difference between the provisional and actual rates. CAUSE Management lacked procedures to perform a comprehensive year-end review and reconciliation of indirect costs charged to federal awards. In addition, there was no control in place requiring management to calculate the actual indirect cost rate and record any necessary true-up adjustment before the close of the fiscal year. EFFECT OR POTENTIAL EFFECT This may affect the accuracy of the Schedule of Expenditures of Federal Awards and compliance with federal requirements. RECOMMENDATION We recommend that management establish formal procedures to calculate the actual indirect cost rate at year-end, compare actual indirect costs charged to amounts allowable under the final rate calculation, and record any required adjustments prior to financial reporting and federal reporting. Management should also implement a review control to ensure all indirect cost reconciliations are completed and documented annually.

Corrective Action Plan

o Calculate provisional indirect costs monthly. o Perform year-end indirect cost reconciliation. o Record true-up adjustments before financial statements are finalized. o Review indirect cost calculations prior to submitting federal reports. o Maintain documentation supporting all indirect cost calculations.

Categories

Reporting Allowable Costs / Cost Principles

Other Findings in this Audit

  • 1236723 2023-009
    Material Weakness Repeat
  • 1236724 2023-009
    Material Weakness Repeat
  • 1236725 2023-009
    Material Weakness Repeat
  • 1236726 2023-009
    Material Weakness Repeat
  • 1236727 2023-009
    Material Weakness Repeat
  • 1236728 2023-009
    Material Weakness Repeat
  • 1236729 2023-009
    Material Weakness Repeat
  • 1236730 2023-009
    Material Weakness Repeat
  • 1236731 2023-009
    Material Weakness Repeat
  • 1236732 2023-009
    Material Weakness Repeat
  • 1236733 2023-010
    Material Weakness Repeat
  • 1236734 2023-010
    Material Weakness Repeat
  • 1236735 2023-010
    Material Weakness Repeat
  • 1236736 2023-010
    Material Weakness Repeat
  • 1236737 2023-010
    Material Weakness Repeat
  • 1236738 2023-010
    Material Weakness Repeat
  • 1236739 2023-010
    Material Weakness Repeat
  • 1236740 2023-010
    Material Weakness Repeat
  • 1236741 2023-010
    Material Weakness Repeat
  • 1236742 2023-011
    Material Weakness Repeat
  • 1236743 2023-011
    Material Weakness Repeat
  • 1236744 2023-011
    Material Weakness Repeat
  • 1236745 2023-011
    Material Weakness Repeat
  • 1236746 2023-011
    Material Weakness Repeat
  • 1236747 2023-011
    Material Weakness Repeat
  • 1236748 2023-011
    Material Weakness Repeat
  • 1236749 2023-011
    Material Weakness Repeat
  • 1236750 2023-011
    Material Weakness Repeat
  • 1236751 2023-012
    Material Weakness Repeat
  • 1236752 2023-012
    Material Weakness Repeat
  • 1236753 2023-012
    Material Weakness Repeat
  • 1236754 2023-012
    Material Weakness Repeat
  • 1236755 2023-012
    Material Weakness Repeat
  • 1236756 2023-012
    Material Weakness Repeat
  • 1236757 2023-012
    Material Weakness Repeat
  • 1236758 2023-012
    Material Weakness Repeat
  • 1236759 2023-012
    Material Weakness Repeat
  • 1236760 2023-013
    Material Weakness Repeat
  • 1236761 2023-013
    Material Weakness Repeat
  • 1236762 2023-013
    Material Weakness Repeat
  • 1236763 2023-013
    Material Weakness Repeat
  • 1236764 2023-013
    Material Weakness Repeat
  • 1236765 2023-013
    Material Weakness Repeat
  • 1236766 2023-013
    Material Weakness Repeat
  • 1236767 2023-013
    Material Weakness Repeat
  • 1236768 2023-013
    Material Weakness Repeat
  • 1236769 2023-013
    Material Weakness Repeat
  • 1236770 2023-014
    Material Weakness Repeat
  • 1236771 2023-014
    Material Weakness Repeat
  • 1236772 2023-014
    Material Weakness Repeat
  • 1236773 2023-014
    Material Weakness Repeat
  • 1236774 2023-014
    Material Weakness Repeat
  • 1236775 2023-014
    Material Weakness Repeat
  • 1236776 2023-014
    Material Weakness Repeat
  • 1236777 2023-014
    Material Weakness Repeat
  • 1236778 2023-014
    Material Weakness Repeat
  • 1236779 2023-014
    Material Weakness Repeat
  • 1236780 2023-015
    Material Weakness Repeat
  • 1236781 2023-016
    Material Weakness Repeat
  • 1236782 2023-016
    Material Weakness Repeat
  • 1236783 2023-016
    Material Weakness Repeat
  • 1236784 2023-016
    Material Weakness Repeat
  • 1236785 2023-016
    Material Weakness Repeat
  • 1236786 2023-016
    Material Weakness Repeat
  • 1236787 2023-016
    Material Weakness Repeat
  • 1236788 2023-016
    Material Weakness Repeat
  • 1236789 2023-016
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
93.914 HIV EMERGENCY RELIEF PROJECT GRANTS $827,117
93.243 SUBSTANCE ABUSE AND MENTAL HEALTH SERVICES PROJECTS OF REGIONAL AND NATIONAL SIGNIFICANCE $547,532
93.279 DRUG USE AND ADDICTION RESEARCH PROGRAMS $400,743
93.788 OPIOID STR $275,534
93.136 INJURY PREVENTION AND CONTROL RESEARCH AND STATE AND COMMUNITY BASED PROGRAMS $257,074
93.917 HIV CARE FORMULA GRANTS $58,312
93.242 MENTAL HEALTH RESEARCH GRANTS $41,967
93.855 ALLERGY AND INFECTIOUS DISEASES RESEARCH $25,429
93.940 HIV PREVENTION AND SURVEILLANCE ACTIVITIES-HEALTH DEPARTMENT BASED $4,314