Finding 1227161 (2023-002)

Material Weakness Repeat Finding
Requirement
L
Questioned Costs
-
Year
2023
Accepted
2026-08-18
Audit: 409334
Organization: County of Rockingham (NH)
Auditor: CBIZ CPAS PC

AI Summary

  • Core Issue: The County failed to submit required reports for the COVID-19 Emergency Rental Assistance Program on time, indicating a significant deficiency in internal controls.
  • Impacted Requirements: Compliance with 2 CFR 200.303 mandates effective internal controls for timely and accurate reporting to the U.S. Department of the Treasury.
  • Recommended Follow-Up: Strengthen internal controls for report submissions, maintain evidence of submission dates, and implement backup procedures for system errors affecting reporting.

Finding Text

2023-002 Improve Internal Controls over Reporting Federal Program Information Federal Agency: Department of the Treasury Award Name: COVID-19 Emergency Rental Assistance Program Assistance Listing Number: 21.023 Award Year: 2022 Compliance Requirement: Reporting Type of Finding Compliance Internal Control over Compliance – Significant Deficiency Criteria or Specific Requirement Per 2 CFR 200.303, the County is required to establish and maintain effective internal controls over federal programs to provide reasonable assurance of compliance with federal statutes, regulations, and the terms and conditions of the award. Program guidance requires timely and accurate submission of quarterly financial and performance reports, as well as monthly performance reports, to the U.S. Department of the Treasury in accordance with established deadlines. Condition and Context During our testing of the reporting compliance requirement for ERA 1 and ERA 2 awards over the quarterly financial reports, quarterly performance reports and monthly performance reports, we noted the following exceptions: • Of the 2 quarterly financial reports (SF-425) tested, both ERA 2 reports for quarter ends 9/30/2022 and 12/31/2022 were submitted after the required deadline. • Of the 2 quarterly performance reports tested, both ERA 2 reports for quarter ends 9/30/2022 and 12/31/2022 were submitted after the required deadline. • Of the 1 final report tested, the ERA 1 report due on 1/30/2023 was submitted after the required deadline. Cause The County did not establish sufficient procedures or controls to ensure timely submission of all required reports or retention of sufficient evidence to support timeliness of filing. In addition, the County did not have a contingency process in place to address system errors affecting timely reporting. Effect or Potential Effect Due to the weakness in internal controls noted above, there is an increased risk that required program information may not be reported to the granting agency in a timely manner consistent with federal reporting requirements. Additionally, the lack of supporting documentation impedes the ability to verify compliance with reporting deadlines. Questioned Costs None reported. Identification as a Repeat Finding This is a repeat of finding 2022-003. Recommendation The County should strengthen internal controls in place over the timely submission and documentation of required reports for the program. This should include maintaining sufficient evidence of the date and method of submission and considering the implementation of backup procedures in the event system issues affect timely reporting. The County should ensure any delays are documented and, if necessary, approved by the granting agency in writing. Views of Responsible Official and Planned Corrective Action Management’s corrective action plan is included at the end of this report after the Schedule of Prior Year Findings.

Corrective Action Plan

Corrective Action Taken or Planned: 1. Formal documentation and retention procedures: Going forward, all report submissions will be accompanied by time and date-stamped confirmation of submissions (e.g., email confirmations, screenshots from federal submission portal, etc.). These confirmations will be retained in a designated compliance folder for each program. Submitted reports, if available, will be downloaded immediately or as soon as possible from the respective Federal or State agency portal/site and saved to an appropriate County network folder. 2. Contingency plan for system errors: The County will develop a written contingency plan to address delays caused by system outages or data access issues. This plan will include communication protocols with software vendors, documentation of incidents, and immediate outreach to the granting agency when delays are anticipated. 3. Documenting extensions and agency communication: In any case where a reporting deadline cannot be met, staff will immediately request written approval for extensions from the granting agency, and this correspondence will be retained as part of the official reporting record, as applicable and permitted. 4. Training for program and compliance staff: Staff invovled in federal reporting will receive training on reporting deadlines, documentation standards, and escalation protocols for delays. This training will be updated annually to reflect current guidance and program requirements. Implementation date of corrective action: October 24, 2025 Person responsible for corrective action: Charles Nickerson, Senior Director of Finance

Categories

Reporting

Other Findings in this Audit

  • 1227160 2023-001
    Material Weakness Repeat
  • 1227162 2023-003
    Material Weakness Repeat
  • 1227163 2023-003
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
21.023 EMERGENCY RENTAL ASSISTANCE PROGRAM $6.41M
97.036 DISASTER GRANTS - PUBLIC ASSISTANCE (PRESIDENTIALLY DECLARED DISASTERS) $1.62M
14.228 COMMUNITY DEVELOPMENT BLOCK GRANTS/STATE'S PROGRAM AND NON-ENTITLEMENT GRANTS IN HAWAII $430,003
21.027 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $70,339
16.575 CRIME VICTIM ASSISTANCE $49,735
97.067 HOMELAND SECURITY GRANT PROGRAM $14,347
20.614 NATIONAL HIGHWAY TRAFFIC SAFETY ADMINISTRATION (NHTSA) DISCRETIONARY SAFETY GRANTS AND COOPERATIVE AGREEMENTS $13,710
16.738 EDWARD BYRNE MEMORIAL JUSTICE ASSISTANCE GRANT PROGRAM $12,027
16.593 RESIDENTIAL SUBSTANCE ABUSE TREATMENT FOR STATE PRISONERS $9,321
16.922 EQUITABLE SHARING PROGRAM $3,905