Finding 1237532 (2024-002)

Material Weakness Repeat Finding
Requirement
L
Questioned Costs
-
Year
2024
Accepted
2026-09-28
Audit: 412492
Organization: City of Bentonville, Arkansas (AR)

AI Summary

  • Core Issue: Quarterly performance reports did not match the underlying data, indicating a lack of accurate record-keeping.
  • Impacted Requirements: Failure to comply with reporting criteria may lead to inaccuracies and risks of noncompliance with federal regulations.
  • Recommended Follow-Up: Establish formal procedures for staff to prepare and reconcile calculation worksheets linking reported data to source records.

Finding Text

Disaster Grants – Public Assistance (Presidentially Declared Disasters) Assistance Listing No. 97.036 U.S. Department of Homeland Security Criteria: Reporting (44 CFR 206.204), Entities are required to maintain adequate records that support amounts reported in financial and performance reports to ensure accuracy; allow for proper oversight; and comply with applicable laws, regulations, and grant agreements. Condition: The quarterly performance reports did not agree to underlying data. Specifically, source records and supporting schedules used to compile reported information did not agree to the submitted report. Cause: The City does not have formalized procedures requiring staff to prepare and reconcile calculation worksheets that link performance report data to the underlying records. Staff indicated that calculations were performed manually. Effect or Potential Effect: Without adequate documentation supporting quarterly performance reports, reported performance data may be inaccurate, incomplete, or not fully supported. This increases the risk of noncompliance with Uniform Guidance reporting requirements, misreporting to federal agencies, and potential impacts on continued eligibility for federal funding. Questioned Costs: No unknown or questioned costs. Context: We selected a sample of three of five reports submitted during the year for detailed testing. For two of the three reports tested (66%), the amounts and performance measures reported were not supported by the underlying schedules; specifically, the reported amounts did not agree to the underlying schedules, and we noted inaccuracies in the underlying documentation used to support calculations (including aggregated output measures and derived performance indicators). The sampling methodology used is not, and is not intended to be, statistically valid. Repeat Finding: Yes Recommendation: We recommend management implement procedures ensuring that all performance report data requiring calculations are supported by reconciled worksheets that clearly document how reported amounts were derived from source records. Views of Responsible Officials: We agree with the finding. See separate report for planned corrective actions.

Corrective Action Plan

Contact Name: Patrick Johndrow Contact Phone Number: 479-271-6781 Audit Firm: Forvis Mazars, LLP Audit Period: December 31, 2024 Finding #2024-002 – Statement of Condition: The quarterly performance reports did not agree to underlying data. Specifically, source records and supporting schedules used to compile reported information did not agree to the submitted report. Response: The Organization concurs with the finding. Management will implement additional controls related to reporting. The completion date for the above-mentioned corrective action was January 2026.

Categories

Eligibility Reporting Internal Control / Segregation of Duties

Programs in Audit

ALN Program Name Expenditures
97.036 DISASTER GRANTS - PUBLIC ASSISTANCE (PRESIDENTIALLY DECLARED DISASTERS) $4.05M
20.205 HIGHWAY PLANNING AND CONSTRUCTION (FEDERAL-AID HIGHWAY PROGRAM) $3.16M
20.106 AIRPORT IMPROVEMENT PROGRAM, INFRASTRUCTURE INVESTMENT AND JOBS ACT PROGRAMS, AND COVID-19 AIRPORTS PROGRAMS $1.02M
21.027 COVID-19 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $841,831
81.128 ENERGY EFFICIENCY AND CONSERVATION BLOCK GRANT PROGRAM (EECBG) $117,322
66.461 REGIONAL WETLAND PROGRAM DEVELOPMENT GRANTS $75,772
14.218 COMMUNITY DEVELOPMENT BLOCK GRANTS/ENTITLEMENT GRANTS $30,378
16.607 BULLETPROOF VEST PARTNERSHIP PROGRAM $15,746
16.738 EDWARD BYRNE MEMORIAL JUSTICE ASSISTANCE GRANT PROGRAM $13,342