Finding 1156982 (2024-002)

Material Weakness Repeat Finding
Requirement
A
Questioned Costs
-
Year
2024
Accepted
2025-09-30

AI Summary

  • Core Issue: Payroll expenses were charged to federal awards based on budget estimates without proper documentation of time and effort.
  • Impacted Requirements: 2 CFR 200.430(i) mandates effective internal controls for personnel expense allocation, requiring official records for accurate charge support.
  • Recommended Follow-Up: Implement periodic time and effort reports, ensure supervisor reviews for accuracy, and adjust financial records to reflect actual work performed.

Finding Text

Finding 2024-002, Material Weakness, Allowable Costs Identification of federal program: U.S. DEPARTMENT OF HEALTH AND HUMAN SERVICES 93.224 and 93.527 Health Center Program Cluster Criteria: 2 CFR 200.430(i) requires the auditee to establish and maintain effective internal control over the allocation of personnel expenses whereby charges to Federal awards for personnel-related expenditures are supported by official records of the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. Budget estimates alone do not qualify as support for charges to Federal awards, but may be used for interim accounting purposes, provided that: The non-federal entity's system of internal controls includes processes to review after-the-fact interim charges made to a Federal award based on budget estimates. All necessary adjustment must be made such that the final amount charged to the Federal award is accurate, allowable and properly allocated. Condition: Payroll expenses were charged to the award based on budget estimates. Cause: The Organization uses a spreadsheet, prepared annually, to document the allocation of personnel costs charged across federal and other awards and indirect cost centers. Time and effort reports were not maintained or reviewed to support the allocation of personnel costs. Effect: The Organization was unable to provide documentation of time and effort for personnel who were not 100% charged to the federal award. Questioned costs: None. Context: Total compensation charged to federal awards was tested for 11 out of 92 total employees charged to federal awards. 7 of the 9 employees tested were charged to multiple cost centers. Employees tested were not charged in excess of their compensation. However, there was no documentation of how the allocations were determined beyond budget estimates. Total personnel costs allocated to the Health Center Cluster were $2,887,641. Repeat finding: 2023-004 Recommendation: We recommend that the Organization implement periodic time and effort reports to track employee allocations among federal awards, non-federal awards and indirect cost centers. We recommend that time and effort reports be reviewed by employee supervisors to ensure employee allocations are reflective of actual work performed and payroll allocation changes are made timely to reflect changes in employee duties. All necessary adjustments should be made to financial records to reflect the final amount charged to the Federal award reflects actual work performed. Views of responsible officials and planned corrective actions: See attached corrective action plan.

Corrective Action Plan

Material Weakness, Allowable Costs- The following steps have been taken or will be taken to address Finding 2024-002: • Shalom Health Care Center, Inc. has been working on updating federal grant draws within the timeframe of payroll and not monthly. • Shalom Health Care Center, Inc. will also prepare semiannual attestation for management to review staff allocations. Contact Michael A. Nino, Chief Financial Officer anino@shalomhealthcenter.org 317-269-7198

Categories

Allowable Costs / Cost Principles

Other Findings in this Audit

  • 1156979 2024-002
    Material Weakness Repeat
  • 1156980 2024-002
    Material Weakness Repeat
  • 1156981 2024-002
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
93.224 Health Center Program (community Health Centers, Migrant Health Centers, Health Care for the Homeless, and Public Housing Primary Care) $333,660
93.242 Mental Health Research Grants $74,430
93.940 Hiv Prevention Activities Health Department Based $67,839
93.527 Grants for New and Expanded Services Under the Health Center Program $51,231