Finding 574044 (2022-003)

Significant Deficiency
Requirement
L
Questioned Costs
-
Year
2022
Accepted
2025-08-20
Audit: 364627
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 due to inadequate internal controls and system errors.
  • Impacted Requirements: Compliance with 2 CFR 200.303 for timely and accurate reporting to the U.S. Department of the Treasury was not met.
  • Recommended Follow-Up: Strengthen internal controls for report submission, maintain documentation of submission dates, and implement backup procedures for system errors.

Finding Text

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 the ERA 1 and ERA 2 reports for quarter end 9/30/2021 were submitted on 12/31/2021 after the required deadline of 10/29/2021. The County indicated the late submissions were due to the inability to retrieve the information required to compile the reports due to an ERAP system error. • Of the 4 monthly performance reports tested, the County was unable to provide documentation showing the date of submission for the ERA 1 and ERA 2 reports for the month of October 2021. The remaining 2 monthly performance reports for the month of April 2022 were submitted in July 2022, and no approved extension was on file. • Of the 2 quarterly performance reports tested, the ERA 1 report for quarter end 9/30/2021 was submitted on 12/31/2021 after the required deadline of 10/29/2021 due to the inability to retrieve the information required to compile the reports due to an ERA system error. The other quarterly performance report tested for ERA 2 for the quarter ending 6/30/2022 was not submitted on time as evidence by a notification email from Treasury after the due date had passed. 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. No questioned costs are reported as the requirement is procedural in nature. 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

Audit Finding Reference: 2022-003 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 submission ( e.g., email confirmations, screenshots from the federal submission portal, etc.). These confirmations will be retained in a designated compliance folder for each program. 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 involved 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. Anticipated Completion Date: October 15, 2025 Contact Person Responsible for Corrective Action: Charles Nickerson, Senior Director of Finance

Categories

Reporting Significant Deficiency

Other Findings in this Audit

  • 574040 2022-001
    Significant Deficiency Repeat
  • 574041 2022-001
    Significant Deficiency Repeat
  • 574042 2022-001
    Significant Deficiency Repeat
  • 574043 2022-002
    Material Weakness
  • 1150482 2022-001
    Significant Deficiency Repeat
  • 1150483 2022-001
    Significant Deficiency Repeat
  • 1150484 2022-001
    Significant Deficiency Repeat
  • 1150485 2022-002
    Material Weakness
  • 1150486 2022-003
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
21.023 Emergency Rental Assistance Program $3.63M
21.027 Coronavirus State and Local Fiscal Recovery Funds $1.81M
93.498 Provider Relief Fund and American Rescue Plan (arp) Rural Distribution $1.03M
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $395,230
21.019 Coronavirus Relief Fund $260,000
16.575 Crime Victim Assistance $48,888
14.228 Community Development Block Grants/state's Program and Non-Entitlement Grants in Hawaii $26,000
16.922 Equitable Sharing Program $22,940
16.593 Residential Substance Abuse Treatment for State Prisoners $20,842
16.738 Edward Byrne Memorial Justice Assistance Grant Program $10,516
16.034 Coronavirus Emergency Supplemental Funding Program $10,030
20.614 National Highway Traffic Safety Administration (nhtsa) Discretionary Safety Grants and Cooperative Agreements $8,978
97.042 Emergency Management Performance Grants $6,327
97.067 Homeland Security Grant Program $2,650