Finding 574043 (2022-002)

Material Weakness
Requirement
ABE
Questioned Costs
$1
Year
2022
Accepted
2025-08-20
Audit: 364627
Organization: County of Rockingham (NH)
Auditor: Cbiz CPAS PC

AI Summary

  • Core Issue: The County lacks effective internal controls and documentation processes for the COVID-19 Emergency Rental Assistance Program, leading to noncompliance with federal requirements.
  • Impacted Requirements: Failure to meet criteria under 2 CFR 200.303 and 2 CFR 200.334 regarding eligibility determinations and allowable costs.
  • Recommended Follow-Up: Implement policies to ensure ongoing access to documentation and regularly verify compliance with record retention requirements.

Finding Text

2022-002 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 – Material Weakness 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 8 of the items selected for testing under allowable cost compliance and eligibility requirements, the County was unable to provide some or all of the required supporting documentation to demonstrate that individuals met the program’s eligibility requirements and that costs were allowable. 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 and allowable cost 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 Due to the condition noted above, we were unable to determine if the costs charged to the applicable grant are allowable. 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

Questioned Costs Allowable Costs / Cost Principles Eligibility Material Weakness

Other Findings in this Audit

  • 574040 2022-001
    Significant Deficiency Repeat
  • 574041 2022-001
    Significant Deficiency Repeat
  • 574042 2022-001
    Significant Deficiency Repeat
  • 574044 2022-003
    Significant Deficiency
  • 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