Finding 1099849 (2023-001)

Material Weakness
Requirement
B
Questioned Costs
-
Year
2023
Accepted
2025-02-17
Audit: 342673
Organization: Houston Recovery Center, Lgc (TX)

AI Summary

  • Core Issue: Houston Recovery Center lacks adequate procedures for accurately allocating payroll costs across multiple federal grants, leading to potential misallocation of funds.
  • Impacted Requirements: Compliance with federal guidelines on allowable costs, specifically the need for accurate records reflecting actual work performed as per §200.430.
  • Recommended Follow-Up: Implement new policies to ensure payroll charges are based on actual time and effort, and conduct regular time studies to validate allocations.

Finding Text

Finding #2023-001 – Material Weakness and Material Noncompliance. Major federal programs: U. S. Department of Treasury, Assistance Listing #21.027, COVID-19 Coronavirus State and Local Fiscal Recovery Funds, Passed through Harris County, Texas, Contract #220163, Contract year: 12/01/22 – 12/31/24, Assistance Listing #93.788, Opioid STR, Passed through the Texas Health and Human Services Commission, Contract #HHS000357900001, Contract years: 09/01/21 – 08/31/22 and 09/01/22 – 08/31/23, Passed through the University of Texas Health Science Center, San Antonio, Contract #HHS000561800001, Contract year: 09/01/21 – 08/31/22. Other federal programs: U. S. Department of Health and Human Services:, Assistance Listing #93.243, Substance Abuse and Mental Health Services Projects of Regional and National Significance, Contract #5H79TI080624-03, Contract year: 09/30/21 – 09/29/22, Contract #5H79TI080624-04, Contract year: 09/30/22 – 09/29/23, Passed through the City of Houston Health Department, Assistance Listing #93.243, Contract #H79SP080300, Contract years: 11/01/21 – 10/31/22, 11/01/22 – 10/31/23 and 06/08/21 – 06/30/23, Assistance Listing #93.959, Block Grants for Prevention and Treatment of Substance Abuse, Passed through the Texas Health and Human Services Commission, Contract #HHS000130500019, Contract years: 09/01/21 – 08/31/22 and 09/01/22 – 08/31/23. Criteria: Allowable costs – Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, §200.430 requires that charges to awards for salaries and wages be based on records that accurately reflect the work performed. These records must 1) be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable and properly allocated; 2) reasonably reflect the total activity for which the employee is compensated; 3) comply with the established accounting policies and practices of the agency; and 4) support the distribution of the employee’s salary or wages among specific activities or cost objectives if the employee works on more than one activity. Houston Recovery Center’s procedures for allocating payroll costs are not sufficient to ensure that costs are appropriately allocated amongst federal and other funding streams. Condition and context: Houston Recovery Center has personnel funded by more than one grant award. The responsibilities for each position are examined and an assessment of time needed to perform each assigned task is made. The time allotment is then converted to a percentage of salary, documented on the personnel action form for each employee, and used to create the personnel section of each grant budget. Each grant is charged based on the percentages documented on the personnel action forms. In fiscal 2022, quarterly time studies were utilized to support that the budgeted estimates per the personnel action forms were reasonable and, if needed, adjustments were made in the general ledger. On July 1, 2022, Houston Recovery Center changed third-party payroll processors and the new processor did not provide the capability to charge time to more than one cost center. Therefore, while allocations are still made in the general ledger based on the percentages documented on the employee’s personnel action form, actual time worked by grant/cost center was not tracked. Additionally, a time study was not performed in the year ended June 30, 2023 to evaluate the reasonableness of time charged to the grants. Questioned costs: Unknown. Cause: Houston Recovery Center’s payroll provider advised that the payroll software could provide the capability of personnel to charge multiple grants consistent with time work efforts. After implementation of the new system, the payroll provider worked for months to meet that requirement only to conclude that they were unable to provide the ability to charge to more than one grant. Effect: Allocation of payroll costs may not properly reflect the time and effort expended on the specific federal program. Recommendation: Houston Recovery Center should establish policies and procedures to ensure that grants are charged based on actual time and effort expended. Views of responsible officials and planned corrective actions: Management agrees with the finding. See Corrective Action Plan.

Categories

Allowable Costs / Cost Principles

Other Findings in this Audit

  • 523399 2023-001
    Material Weakness
  • 523400 2023-002
    Significant Deficiency
  • 523401 2023-001
    Material Weakness
  • 523402 2023-002
    Significant Deficiency
  • 523403 2023-001
    Material Weakness
  • 523404 2023-002
    Significant Deficiency
  • 523405 2023-001
    Material Weakness
  • 523406 2023-002
    Significant Deficiency
  • 523407 2023-001
    Material Weakness
  • 523408 2023-002
    Significant Deficiency
  • 523409 2023-001
    Material Weakness
  • 523410 2023-002
    Significant Deficiency
  • 1099841 2023-001
    Material Weakness
  • 1099842 2023-002
    Significant Deficiency
  • 1099843 2023-001
    Material Weakness
  • 1099844 2023-002
    Significant Deficiency
  • 1099845 2023-001
    Material Weakness
  • 1099846 2023-002
    Significant Deficiency
  • 1099847 2023-001
    Material Weakness
  • 1099848 2023-002
    Significant Deficiency
  • 1099850 2023-002
    Significant Deficiency
  • 1099851 2023-001
    Material Weakness
  • 1099852 2023-002
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
21.027 Coronavirus State and Local Fiscal Recovery Funds $490,328
93.243 Substance Abuse and Mental Health Services Projects of Regional and National Significance $281,568
93.959 Block Grants for Prevention and Treatment of Substance Abuse $193,291
93.788 Opioid Str $28,876