Finding 1169776 (2023-003)

Material Weakness Repeat Finding
Requirement
GH
Questioned Costs
-
Year
2023
Accepted
2026-01-20

AI Summary

  • Core Issue: There are significant weaknesses in internal controls over payroll matching for grant funds, leading to inaccuracies in reported costs.
  • Impacted Requirements: Compliance with 2 CFR 200.303(a) and 24 CFR 578.73 is at risk due to improper matching of funds and inadequate documentation of expenditures.
  • Recommended Follow-Up: Enhance payroll review processes to ensure costs charged to grants align with reported hours on timesheets.

Finding Text

2023-003 Compliance and Internal Controls over Matching (Material Weakness) Internal Controls over Period of Performance and Earmarking (Material Weakness) U.S. Department of Housing and Urban Development 14.267 – Continuum of Care Program 2023 Funding Criteria: Under 2 CFR Section 200.303(a), non‐federal entities must establish and maintain effective internal controls to provide reasonable assurance that the entity is managing the federal awards in compliance with statues, regulations, and the terms and conditions of the award. Additionally, under 24 CFR Section 578.73, the Organization must match all grant funds, except for leasing funds, with no less than 25 percent of funds or in-kind contributions from other sources. Furthermore, under 2 CFR Section 200.403 (g) and (h), the Organization’s expenditures must be adequately documented and incurred during the approved budget period, respectively. Condition: Payroll costs that could be potentially chargeable to the grant but were not, were claimed as a matching contribution under the grant by the Organization. However, as noted in finding 2023-001 above, payroll cost allocated to the grants did not agree to the grant hours reported in the approved timesheets for certain samples selected for testing. Because of this finding, we cannot establish the accuracy of payroll claimed as a match for the grant. Review and approval of each payroll batch was conducted, but in 6 out of 6 instances tested, errors in grant allocation were not detected. Cause: While there is a process in place for upper management to review and approve each payroll batch based on hours incurred per timesheet, it appears that the control was not operating effectively as the payroll cost charged to the grant in several instances exceeded the corresponding hours charged to the grant per the timesheet. Effect: Unmatched funds may be required to be returned back to grantor and / or impact future funding. Questioned Costs: Undeterminable Perspective: Payroll charged to the grants exceeded time incurred in 7 out of the 60 samples tested, including 1 out of the 17 samples for contract TX0275L6E002112 where payroll was used as a match. Repeat Finding: Yes. Recommendation: We recommend that part of the review process for payroll include verification that the cost charged to the grant does not exceed the grant hours reported on employee timesheet. Views of Responsible Officials: We concur with the recommendation, please see Corrective Action Plan.

Corrective Action Plan

2023-003 Compliance and Internal Controls over Matching (Material Weakness) Internal Controls over Period of Performance and Earmarking (Material Weakness) U.S. Department of Housing and Urban Development 14.267 – Continuum of Care Program 2023 Funding Recommendation: We recommend that part of the review process for payroll include verification that the cost charged to the grant does not exceed the grant hours reported on employee timesheet. Corrective Action: In response to the first finding, we have implemented a comprehensive payroll review process that addresses both the initial concern and the subsequent finding. The new payroll process that has been established will ensure that costs charged to the grant do not exceed the hours reported on employee timesheets, effectively eliminating both issues: Responsible Parties: Sandra Robicheaux – Executive Director Claudia Dixon – CFO Tyler Starkel - YPTC Date to be Corrected: Implementation for above changes went into effect 6/01/2024

Categories

Matching / Level of Effort / Earmarking

Other Findings in this Audit

  • 1169767 2023-002
    Material Weakness Repeat
  • 1169768 2023-002
    Material Weakness Repeat
  • 1169769 2023-002
    Material Weakness Repeat
  • 1169770 2023-002
    Material Weakness Repeat
  • 1169771 2023-002
    Material Weakness Repeat
  • 1169772 2023-003
    Material Weakness Repeat
  • 1169773 2023-003
    Material Weakness Repeat
  • 1169774 2023-003
    Material Weakness Repeat
  • 1169775 2023-003
    Material Weakness Repeat
  • 1169777 2023-004
    Material Weakness Repeat
  • 1169778 2023-005
    Material Weakness Repeat
  • 1169779 2023-005
    Material Weakness Repeat
  • 1169780 2023-005
    Material Weakness Repeat
  • 1169781 2023-005
    Material Weakness Repeat
  • 1169782 2023-005
    Material Weakness Repeat
  • 1169783 2023-006
    Material Weakness Repeat
  • 1169784 2023-006
    Material Weakness Repeat
  • 1169785 2023-006
    Material Weakness Repeat
  • 1169786 2023-006
    Material Weakness Repeat
  • 1169787 2023-006
    Material Weakness Repeat
  • 1169788 2023-007
    Material Weakness Repeat
  • 1169789 2023-007
    Material Weakness Repeat
  • 1169790 2023-007
    Material Weakness Repeat
  • 1169791 2023-007
    Material Weakness Repeat
  • 1169792 2023-007
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
21.027 COVID-19 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $636,146
14.267 CONTINUUM OF CARE PROGRAM $616,945