Finding 1227160 (2023-001)

Material Weakness Repeat Finding
Requirement
ABE
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 lacks effective internal controls to ensure ongoing access to required documentation for eligibility determinations and allowable costs under the COVID-19 Emergency Rental Assistance Program.
  • Impacted Requirements: Noncompliance with 2 CFR 200.303 and 2 CFR 200.334 regarding internal controls and record retention for federal programs.
  • Recommended Follow-Up: Implement policies to retain documentation securely and verify compliance with federal regulations periodically.

Finding Text

2023-001 Improve Internal Controls and Documentation over Allowable Costs and Eligibility Determinations 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: Activities Allowed or Unallowed, Allowable Costs/Cost Principles, Eligibility 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. Additionally, 2 CFR 200.334 requires the retention of records and supporting documentation to demonstrate eligibility determinations and allowability of expenditures under the program. Condition and Context During our audit, we tested a sample of 40 selections for allowable costs, as well as a sample of 40 for individual eligibility determinations under the program in which 38 selections were leveraged between the two tests. For 1 of the items selected for testing under allowable cost compliance and eligibility requirements, the County was unable to provide some of the required supporting documentation to demonstrate that individuals met the program’s eligibility requirements. However, lease agreements supporting the amount ultimately paid to the individual were provided to support allowability. The documentation was retained in an online portal to which the County no longer had access at the time of our audit procedures. Cause The County did not establish sufficient procedures or controls to ensure ongoing access to required supporting documentation maintained in the external portal used for program administration. Effect or Potential Effect Due to the weakness in internal controls noted above, the County could not demonstrate compliance with eligibility requirements for the sampled transaction. This also constitutes noncompliance with record retention requirements and impairs the ability for sufficient procedures to be performed over the program. Questioned Costs None reported. Identification as a Repeat Finding This is a repeat of finding 2022-002. Recommendation The County should implement policies and procedures to ensure required documentation for the program is retained in a manner that ensures continued access, even if administration platforms change or external portals are no longer accessible. The County should also periodically verify that it retains all necessary support for program transactions as required under federal regulations. 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: 1. Formalized record retention policies: A formal record retention policy specific to federal grant programs was implemented to ensure full compliance with 2 CFR 200.334. This policy applies regardless of whether documentation is stored internally or by third-party systems. Any documentation downloaded or transferred from third-party systems will be subject to a review process to verify completeness and accuracy before being finalized for County retention. The County shall also take steps to ensure that information downloads and exports from third-party systems represent complete and accurate records. 2. Auditing timing advocacy and preparedness: The County will continue to maintain timely documentation and preparedness for audits and will also advocate for timely initiation and completion of future audits. Significant delays in the audit process, though no fault of the County, as observed during the FY 2023 audit, substantially impacted the County's ability to access necessary documentation and demonstrate compliance. Although the County made every effort to retain records in accordance with federal requirements, the timing of the audit fieldwork occurred well after the program had concluded in May 2023. Had the audit been conducted in a timely manner, full access to the third-party platform used for program administration would have been available, along with supporting documentation. However, by the time the audit took place, the program had been closed for over 18 months, and access to the external software system had lapsed in accordance with the expiration of the service agreement. 3. Internal audit readiness reviews: Beginning with FY2025, the County conducts internal audit readiness reviews shortly after fiscal year-end to ensure all documentation for closed federal programs is centralized, archived, and accessible for future audit purposes, even if conducted years later. Implementation date of corrective action: October 24, 2025 Person Responsible for corrective action: Charles Nickerson, Senior Director of Finance

Categories

Allowable Costs / Cost Principles Eligibility Significant Deficiency

Other Findings in this Audit

  • 1227161 2023-002
    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