Finding 1054847 (2023-002)

Material Weakness
Requirement
ABL
Questioned Costs
$1
Year
2023
Accepted
2024-07-15
Audit: 315087
Organization: City of Mesquite, Texas (TX)
Auditor: Forvis Mazars

AI Summary

  • Core Issue: The City reported COVID-19 expenses without proper documentation linking them to allowable activities, leading to questioned costs of $163,700.
  • Impacted Requirements: Compliance with federal guidelines for allowable costs and accurate reporting is essential, as outlined in Pub. L. No. 116-136 and 45 CFR 75.342.
  • Recommended Follow-Up: Revise policies and procedures to ensure all federal grant expenditures are backed by actual costs and maintain proper documentation for compliance.

Finding Text

Program: COVID-19 - Provider Relief Fund Assistance Listing Number: 93.498 Compliance Requirement: Activities Allowed or Unallowed and Allowable Costs and Reporting Federal Agency: Department of Health and Human Services Criteria or Specific Requirement – Activities Allowed/Unallowed and Cost Principles (Pub. L. No. 116-136, 134 Stat. 563 and Pub. L. No. 116-139, 134 Stat. 622 and 623) and Reporting (45 CFR 75.342). Federal awards are only to be expended for allowable activities. In addition, the City is required to prepare and submit the period five provider relief fund report to the U.S. Department of Health and Human Services. This report is to be prepared using accurate financial information and submitted by the deadline established. Condition – The City reported COVID-19-related expenditures, including supplies, within the HHS Provider Relief Fund (PRF) portal that did not have sufficient supporting documentation showing expenditures were related to the prevention, preparation or response to COVID-19. In addition, the City reported fringe benefit amounts based on budgeted allocations and not actual expenditures. Questioned Costs – $163,700. Questioned costs were determined by the amount of allocated supplies and fringe benefit costs included within the federal awards expended. Context – Management made certain estimates related to allowable program costs that did not have adequate underlying supporting documentation to determine proper allocation of claimed program expenditures. Effect – The City submitted expenses under the PRF program based on allocations and not actual expenditures. As a result, the City did not have support that they were reasonably related to the prevention, preparation or response to COVID-19. Cause – Internal controls were not in place to ensure federal awards were expended only for allowable activities. Identification as a Repeat Finding – N/A Recommendation – Policies and procedures over federal grant expenditure and reporting should be modified to ensure that allowable costs are supported by expenditures and reports that include indirect costs have sufficient supporting documentation that is retained in accordance with grant requirements. Views of Responsible Officials and Planned Corrective Actions – We agree with the finding. See separate report for planned corrective actions.

Categories

Questioned Costs Allowable Costs / Cost Principles

Other Findings in this Audit

Programs in Audit

ALN Program Name Expenditures
14.871 Section 8 Housing Choice Vouchers $18.19M
21.027 Covid-19 - Coronavirus State and Local Fiscal Recovery Funds $1.26M
14.218 Community Development Block Grants/entitlement Grants $1.11M
20.507 Covid-19 - Federal Transit_formula Grants $860,511
14.871 Covid-19 - Section 8 Emergency Housing Choice Vouchers $580,803
93.498 Covid-19 - Provider Relief Fund $478,776
16.922 Equitable Sharing Program $354,318
14.879 Mainstream Voucher Program (mv) $338,427
20.507 Federal Transit_formula Grants $149,500
97.067 Homeland Security Grant Program $101,185
14.218 Covid-19 - Community Development Block Grants/entitlement Grants $86,996
93.045 Special Programs for the Aging_title Iii, Part C_nutrition Services $54,573
21.016 Equitable Sharing $42,772
20.600 State and Community Highway Safety $3,081