Finding 570797 (2024-001)

- Repeat Finding
Requirement
A
Questioned Costs
-
Year
2024
Accepted
2025-07-09
Audit: 361757
Organization: Aids Healthcare Foundation (CA)

AI Summary

  • Core Issue: Inaccurate documentation of employee hours for reimbursements, leading to discrepancies between timesheets and invoices.
  • Impacted Requirements: Compliance with 2 CFR Part 200.430 for accurate salary allocation records and internal controls over federal awards.
  • Recommended Follow-Up: Ensure timely reviews of employee hours and enforce approval processes for timecards to prevent future discrepancies.

Finding Text

Finding 2024-001: Allowable Cost/Cost Principles – Enhanced Documentation of Cost Allocation (Repeat Finding) Criteria or Specific Requirements Per 2 CFR Part 200.430 (g)(1), charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must support the distribution of the employee's salary or wages among specific activities or cost objectives. Per Uniform Guidance Compliance Supplement part 6 – Internal Control, non-federal entities are required to establish and maintain internal control over the federal awards that provides reasonable assurance that the non-federal entity is managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards. Condition Description A. Improved Documentation for Basis of Cost Allocation for Employee Time Charges Of the 50 employee monthly reimbursements (10 for ALN 14.241; 40 for ALN 93.914) selected for allowable costs testwork, we noted 2 employee monthly reimbursements (1 for ALN 14.241; 1 for ALN 93.914) for where the hours reported per the timesheet did not agree with the hours reported in the related request for reimbursement invoices. The hours reported per the reimbursement invoices were greater than the hours reported per the timesheets. The Foundation subsequently provided documentation indicating that such differences had been properly corrected in the following month’s reimbursement invoice through an adjustment to the reported hours per the reimbursement invoice. B. Improved Documentation of Routinary Reviews of Employee Hours Charged to the Grants We performed testwork over the Foundation’s implementation of the Corrective Action Plan (CAP) for Finding 2023-001. Per the CAP, the Foundation will perform regular reviews of tracked hours and reconciliations at least quarterly. Of the 18 payroll reimbursement months (for ALN 93.914), and 4 payroll reimbursement months (for ALN 93.940) selected for testwork, we noted a total of 2 months (1 for ALN 93.914; 1 for ALN 93.940) whereby the related reviews of tracked hours were performed more than 90 days after the respective reimbursement month. C. Timecard Lacking Employee and Manager Approvals In performing allowable costs testwork over payroll expenditures, we noted the following: Questioned Costs A. Improved Documentation for Basis of Cost Allocation for Employee Time Charges None. The Foundation corrected the discrepancies in subsequent monthly reimbursements. This issue is considered an internal control finding. B. Improved Documentation of Routinary Reviews of Employee Hours Charged to Grants None. This issue is considered an internal control finding. C. Timecards Lacking Employee and Manager Approvals None. This issue is considered an internal control finding. Cause and Effect A. Improved Documentation for Basis of Cost Allocation for Employee Time Charges Per the Associate Director of Contract Accounting, this was a one-time error in the month’s request for reimbursement invoice. This error was corrected within the grant period and did not result in overbilling the funder. However, since the correction occurred after the Foundation’s fiscal year-end, it resulted in an overstatement of expenditures reported on the SEFA for the year ended December 31, 2024. B. Improved Documentation of Routinary Reviews of Employees' Hours Charged to Grants. Per the Associate Director of Contract Accounting, the routinary review of employee hours occurred. However, there were still reclassifications that needed to be performed beyond the normal review process. The review process was not properly implemented. C. Timecards Lacking Employee and Manager Approvals The identified condition resulted from failure to follow formal procedures requiring both the employee and manager to sign off on the timesheets.

Corrective Action Plan

Views of Responsible Officials and Planned Corrective Actions A. Improved Documentation for Basis of Cost Allocation for Employee Time Charges Per the Associate Director of Contract Accounting, the Foundation reviewed all the invoices on the 1st and 2nd quarters of 2025 and noted that there were no other adjustments made relating to the invoices within the audit year ended December 31, 2024. To further strengthen internal controls for reimbursement requests, the Foundation will implement the following procedures: 1. Prior to submission of reimbursement requests to the funder, the Contracts Manager for each grant will review the supporting documents and invoice template to ensure only final and fully supported data is invoiced. 2. Continue the practice of reviewing salary costs allocated to each grant in the payroll system, with the percentage charged to the funder to ensure only fully supported costs are billed. B. Improved Documentation of Routinary Reviews of Employee Hours Charged to Grants Per the Associate Director of Contract Accounting, the Foundation has a process to review staff allocated to a grant to ensure that hours and salary costs are allocated correctly at least quarterly, but also additional adjustments and reclasses may be posted at year-end to ensure completeness and that all expenditures are posted in the correct SEFA period as part of the SEFA review process. C. Timecards Lacking Employee and Manager Approvals Per the Associate Director of Contract Accounting, the Foundation has a process in place to ensure that employees and managers approve timecards every pay period and will continue making enhancements to this process to ensure that gaps do not occur subsequently. Personnel responsible for implementation: Shibu Sam Position of responsible personnel: National Director of Contracts Date of Implementation: August 1, 2025

Categories

Allowable Costs / Cost Principles

Other Findings in this Audit

Programs in Audit

ALN Program Name Expenditures
14.241 Housing Opportunities for Persons with Aids $1.13M
93.917 Hiv Care Formula Grants $544,895
93.918 Grants to Provide Outpatient Early Intervention Services with Respect to Hiv Disease $416,264
98.001 Usaid Foreign Assistance for Programs Overseas $336,362
93.243 Substance Abuse and Mental Health Services Projects of Regional and National Significance $184,590
93.686 Ending the Hiv Epidemic: A Plan for America — Ryan White Hiv/aids Program Parts A and B $162,601
93.153 Coordinated Services and Access to Research for Women, Infants, Children, and Youth $61,282
93.242 Mental Health Research Grants $59,925
93.914 Hiv Emergency Relief Project Grants $56,943
93.940 Hiv Prevention Activities Health Department Based $55,145
93.977 Sexually Transmitted Diseases (std) Prevention and Control Grants $46,508
93.855 Allergy and Infectious Diseases Research $35,339
21.027 Coronavirus State and Local Fiscal Recovery Funds $34,198
93.279 Drug Use and Addiction Research Programs $23,763
93.943 Epidemiologic Research Studies of Acquired Immunodeficiency Syndrome (aids) and Human Immunodeficiency Virus (hiv) Infection in Selected Population Groups $14,500
93.361 Nursing Research $800