Finding 1205816 (2023-002)

Material Weakness Repeat Finding
Requirement
L
Questioned Costs
-
Year
2023
Accepted
2026-04-02
Audit: 397560
Organization: City of Bentonville, Arkansas (AR)

AI Summary

  • Core Issue: Quarterly performance reports did not match the underlying data, indicating a lack of accurate documentation.
  • Impacted Requirements: Failure to maintain adequate records violates reporting criteria and increases the risk of noncompliance with federal guidelines.
  • Recommended Follow-Up: Management should establish formal procedures for reconciling performance report data with source records to ensure accuracy.

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 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 two out of four reports submitted during the year for detailed testing. For both reports tested, we noted a 100% error rate related to inaccurate underlying documentation 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: No 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 Contract Phone Number: 479-271-6781 Audit Firm: Forvis Mazars, LLP Audit Period: December 31, 2023 Finding #2023-002 – Statement of Condition: The City did not maintain documentation supporting the underlying information included in its quarterly performance report. Specifically, source records and supporting schedules used to compile reported information were not retained or made available for audit. Response: The Organization concurs with the finding and related adjustments made during the audit. Management will implement additional internal controls related to program reports. 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
21.027 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $4.35M
20.205 HIGHWAY PLANNING AND CONSTRUCTION $1.90M
97.036 DISASTER GRANTS - PUBLIC ASSISTANCE (PRESIDENTIALLY DECLARED DISASTERS) $1.04M
20.106 AIRPORT IMPROVEMENT PROGRAM $82,000