Finding 1160386 (2025-001)

Material Weakness Repeat Finding
Requirement
B
Questioned Costs
-
Year
2025
Accepted
2025-10-14
Audit: 370796
Organization: United Way of Greater Houston (TX)

AI Summary

  • Core Issue: There is a significant deficiency in documenting time and effort for payroll, leading to potential inaccuracies in salary allocations to the federal program.
  • Impacted Requirements: The Uniform Guidance mandates that salary charges must be based on accurate records and internal controls to ensure costs are allowable and properly allocated.
  • Recommended Follow-Up: Implement procedures to regularly compare actual time worked with the fixed salary percentages charged to the grant to ensure compliance.

Finding Text

Finding #2025-001 – Significant Deficiency and Other Noncompliance. Applicable federal program: U. S. Department of Treasury, COVID-19 – Coronavirus State and Local Fiscal Recovery Funds, Assistance Listing #21.027, Passed through BakerRipley, Contract period: 02/01/23 – 12/31/26, Contract number: None. Criteria: Allowable costs – The Uniform Guidance, Subpart E Cost Principles, requires that charges to federal awards for salaries and wages be based on records that accurately reflect work performed and support the distribution of an employee’s salary or wages among specific activities or cost objectives, which includes being supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. Condition and context: In a sample of 35 payroll transactions, 14 transactions for three employees did not have time and effort documentation to support the allocation of salary costs charged to the major program. For these employees who work less than 100% on the program the employees track their activities on their calendars. However, salaries were allocated based on a fixed percentage that did not vary from period to period. Cause: There was not a procedure in place to compare the actual percentage of time worked based on their calendars to the fixed percentage charged to the grant to ensure that the actual percentage of time worked was equal to or greater than the percentages charged to the grant. Effect: Failure to establish controls for adherence with the Uniform Guidance for allowable costs may result in unallowed costs charged to the program. Questioned costs: Unknown. Recommendation: Strengthen controls to require comparison of actual time and effort percentages by activity to the percentage of salaries and wages allocated to federal programs. Views of responsible officials and planned corrective actions: Management agrees with the finding. See Corrective Action Plan.

Corrective Action Plan

Finding #2025-001 – Significant Deficiency and Other Noncompliance. Applicable federal program: U. S. Department of Treasury, COVID-19 – Coronavirus State and Local Fiscal Recovery Funds, Assistance Listing #21.027, Passed through BakerRipley, Contract period: 02/01/23 – 12/31/26, Contract number: None. Condition and context: In a sample of 35 payroll transactions, 14 transactions for three employees did not have time and effort documentation to support the allocation of salary costs charged to the major program. For these employees who work less than 100% on the program the employees track their activities on their calendars. However, salaries were allocated based on a fixed percentage that did not vary from period to period. Recommendation: Strengthen controls to require comparison of actual time and effort percentages by activity to the percentage of salaries and wages allocated to federal programs. Planned corrective action: United Way of Greater Houston has implemented a reconciliation process for billed time to ensure salary allocations reflect actual time and effort for fiscal year 2025-2026. This includes a review of calendar-based activity tracking and comparison against fixed allocation percentages. To strengthen long-term compliance, United Way plans to deploy an electronic timekeeping system that enables dynamic tracking of employee effort across government grant programs. This system will support audit readiness and improve internal control over payroll allocations. Responsible officer: Bart Ferrell, Chief Strategy and Finance Officer. Estimated completion date: September 8, 2025.

Categories

Allowable Costs / Cost Principles

Programs in Audit

ALN Program Name Expenditures
21.027 Coronavirus State and Local Fiscal Recovery Funds $1.65M
93.778 Medical Assistance Program $731,384
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $450,769
93.575 Child Care and Development Block Grant $334,586
93.767 Children's Health Insurance Program $22,728
93.558 Temporary Assistance for Needy Families $5,284