Finding 541073 (2024-002)

Significant Deficiency Repeat Finding
Requirement
B
Questioned Costs
$1
Year
2024
Accepted
2025-03-31

AI Summary

  • Core Issue: A formula error in payroll tracking led to incorrect wage calculations for a grant, affecting compliance with federal requirements.
  • Impacted Requirements: Internal controls must ensure accurate tracking of employee wages to prevent double counting and ensure compliance with 45 CFR 75.430(i)(1) and CFR 200.430.
  • Recommended Follow-Up: Implement a thorough review process for all wages charged to grants before reimbursement requests, including regular updates on salary changes.

Finding Text

Allowable Activities and Costs Federal Agency: U.S. Department of Health and Human Services Federal Program Name: Health Centers Cluster Assistance Listing Number: 93.224 and 93.527 Federal Award Identification Number: H80CS00824-22 and H80CS00824-23 Award Periods: May 1, 2023 – April 30, 2024, May 1, 2024 – April 30, 2025 Type of Finding: Immaterial noncompliance and significant deficiency in internal control over compliance Criteria: A grantee's system of internal control should include processes to review after-the-fact interim charges made to a federal award based on budget estimates. 45 CFR 75.430(i)(1). In addition, CFR 200.430 indicates costs of compensation are allowable to the extent that they satisfy the specific requirement of determining and supporting the salary and wages based on records that accurately reflect the work performed. Salaries and wages charged to a grant should be tagged/identified by employee to ensure expenses are not counted or charged twice. Condition: During the testing of payroll expenses charged to the grant, it was noted that a formula error resulted in the incorrect calculation of payroll expense for a particular employee. The Organization’s review did not identify that the wages being charged to the grant were inconsistent with the amount actually paid to the identified employee. Questioned Costs: $757. Context: The above condition impacted three (3) of sixty (60) transactions selected for testing, all of which related to the same employee. Cause: The Organization’s process for tracking and aggregating wages charged to the grant was dependent upon a VLOOKUP formula based on the employee’s last name. As a result of there being two employees with the same last name, the formula returned the first such employee from the payroll records. This resulted in the incorrect calculation of payroll expense for the employee selected for testing. Effect: The amount of wages charges to the grant could be different from the actual amount of wages paid to the employee. Repeat Finding: Yes. Recommendation: We recommend the Organization implement a comprehensive and thorough process to review all wages charged to federal and state grant prior to initiating a drawdown request or submitting a reimbursement request to the grantor. As part of this, the Organization should implement a process to review changes to salary and wage information as changes are made or identified.

Corrective Action Plan

Allowable Activities and Costs Health Centers Cluster – Assistance Listing No. 93.224 and 93.527 Recommendation: We recommend the Organization implement a comprehensive and thorough process to review all wages charged to federal and state grant prior to initiating a drawdown request or submitting a reimbursement request to the grantor. As part of this, the Organization should implement a process to review changes to salary and wage information as changes are made or identified.. Action taken in response to finding: The process has been changed as of July 1, 2024 and will continue forward. Name(s) of the contact person(s) responsible for corrective action: Daria Sztaba, CFO Planned completion date for corrective action plan: July 1, 2024

Categories

Questioned Costs Cash Management Significant Deficiency

Other Findings in this Audit

  • 541074 2024-003
    Material Weakness
  • 541075 2024-002
    Significant Deficiency Repeat
  • 541076 2024-003
    Material Weakness
  • 1117515 2024-002
    Significant Deficiency Repeat
  • 1117516 2024-003
    Material Weakness
  • 1117517 2024-002
    Significant Deficiency Repeat
  • 1117518 2024-003
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
93.527 Affordable Care Act (aca) Grants for New and Expanded Services Under the Health Center Program $29,388
93.136 Injury Prevention and Control Research and State and Community Based Programs $18,700
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $13,000
93.268 Immunization Cooperative Agreements $2,994