Finding 1227167 (2022-002)

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

AI Summary

  • Core Issue: The County failed to maintain access to necessary documentation for eligibility determinations 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.
  • Recommended Follow-Up: Implement policies to ensure documentation is retained for ongoing access and regularly verify compliance with federal record-keeping requirements.

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: 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 35 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 transactions. 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. 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

Audit Finding Reference: 2022-002 Corrective Action Taken or Planned: 1. Formalized Record Retention Policies: A formal record retention policy specific to federal grant programs will be implemented to ensure full compliance with 2 CFR 200.334. This policy will apply 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 omplete and accurate records. 2. Audit 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, through no fault of the County, as observed during the FY2022 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 all 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 will conduct 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. Anticipated Completion Date: October 15, 2025 Contact Person Responsible for Corrective Action: Charles Nickerson, Senior Director of Finance

Categories

Allowable Costs / Cost Principles Eligibility Significant Deficiency

Other Findings in this Audit

  • 1227164 2022-001
    Material Weakness Repeat
  • 1227165 2022-001
    Material Weakness Repeat
  • 1227166 2022-001
    Material Weakness Repeat
  • 1227168 2022-003
    Material Weakness Repeat

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