Finding 1211073 (2025-004)

Material Weakness Repeat Finding
Requirement
L
Questioned Costs
-
Year
2025
Accepted
2026-04-30

AI Summary

  • Core Issue: The City’s internal controls failed, leading to errors in reports submitted to the U.S. Treasury.
  • Impacted Requirements: Compliance with 2 CFR 200.303, which mandates effective internal controls and independent review of reports.
  • Recommended Follow-Up: Enhance review procedures to include data reconciliation and a secondary review before future submissions.

Finding Text

2025-004 Reporting ALN 21.027 Coronavirus State and Local Fiscal Funds US Department of the Treasury Fiscal Year 2025 Funding Grant Y5314 Criteria: 2 CFR 200.303 requires non-federal entities to establish and maintain effective internal controls. Reports should be subject to independent review to verify completeness, validity, and timeliness of submission. Condition: The City’s controls over reports issued to U.S. Treasury failed to operate correctly as the underlying data contained errors which were noted on the report issued to the US Treasury. Cause of the condition: The City did not have a proper review of the underlying data for the reports sent to the US Treasury as the underlying data caused the reports to be incorrect. Potential effect of condition: Reports submitted could contain errors or could be incomplete. Questioned costs: None noted. Reported finding is a deficiency in internal control. Recommendation: The City should review the underlying data along with the report to ensure the report agrees with the support and the underlying data is correct. Management Response: Management recognizes the importance of accurate and complete reporting to the U.S. Treasury. While procedures were in place, the review of underlying data was not sufficient to ensure accuracy and completeness prior to submission. The issue was limited to a single report and was corrected in the subsequent U.S. Treasury reporting cycle in accordance with program requirements. To prevent recurrence, management has enhanced its review procedures over grant reporting to include reconciliation of underlying data and validation checks for inconsistencies prior to report submission. Additionally, a secondary level of review will be performed to ensure reports are complete and accurate before submission to the U.S. Treasury.

Corrective Action Plan

2025-004 Reporting Recommendation: The City should review the underlying data along with the report to ensure that report agrees with the support and the underlying data is correct. Corrective Action: Management recognizes the importance of accurate and complete reporting to the U.S. Treasury. While procedures were in place, the review of underlying data was not sufficient to ensure accuracy and completeness prior to submission. The issue was limited to a single report and was corrected in the subsequent U.S. Treasury reporting cycle in accordance with program requirements. To prevent recurrence, management has enhanced its review procedures over grant reporting to include reconciliation of underlying data and validation checks for inconsistencies prior to report submission. Additionally, a secondary level of review will be performed to ensure reports are complete and accurate before submission to the U.S. Treasury. Responsible Parties: B. Keith Smith, Finance Director Anticipated Correction Date: September 30, 2026

Categories

Reporting Matching / Level of Effort / Earmarking Internal Control / Segregation of Duties

Other Findings in this Audit

  • 1211072 2025-003
    Material Weakness Repeat
  • 1211074 2025-003
    Material Weakness Repeat
  • 1211075 2025-003
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
14.228 COMMUNITY DEVELOPMENT BLOCK GRANTS/STATE'S PROGRAM AND NON-ENTITLEMENT GRANTS IN HAWAII $441,549
97.036 DISASTER GRANTS - PUBLIC ASSISTANCE (PRESIDENTIALLY DECLARED DISASTERS) $88,021
16.738 EDWARD BYRNE MEMORIAL JUSTICE ASSISTANCE GRANT PROGRAM $4,469
16.607 BULLETPROOF VEST PARTNERSHIP PROGRAM $4,088
21.027 COVID-19 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $1,193