Finding 574041 (2022-001)

Significant Deficiency Repeat Finding
Requirement
P
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 inaccurately reported $580,474 in federal expenditures on the SEFA, leading to compliance risks.
  • Impacted Requirements: The SEFA must adhere to Uniform Guidance, and inaccuracies could affect audit requirements and major program determinations.
  • Recommended Follow-Up: Implement stronger controls and procedures for reconciling federal expenditures with supporting documents to ensure SEFA accuracy.

Finding Text

2022-001 Improve Internal Controls over the Preparation of the Schedule of Expenditures of Federal Awards (SEFA) Federal Program(s) Information Cluster/Program: All federal programs Type of Finding Compliance Internal Control over Compliance – Significant Deficiency Criteria or Specific Requirement The County is required to prepare a SEFA in accordance with the prescribed guidelines of the Uniform Guidance. Condition and Context The County did not properly report a net impact of $580,474 in expenditures on the SEFA. As a result of the initial improper expenditure amounts included, the auditors’ assessment over major program determination was impacted. Cause The County did not have adequate controls in place in order to properly report federal expenditures. Effect or Potential Effect Due to the weakness in internal controls noted above, there is a risk that amounts reported on the SEFA are not complete and accurate. The lack of a complete and accurate SEFA may impact the determination of if a single audit is required, as well as major program determination. Misstating expenditures on the SEFA results in the County being out of compliance with the requirements set forth in the underlying grant agreements and the Uniform Guidance. Recommendation The County should ensure that adequate procedures and controls are in place to ensure that the SEFA is complete and accurate. These controls should include controls requiring the reconciliation of federal expenditures to the appropriate supporting documentation (e.g., general ledger, grant reports, etc.). 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.

Categories

Reporting Significant Deficiency

Other Findings in this Audit

  • 574040 2022-001
    Significant Deficiency Repeat
  • 574042 2022-001
    Significant Deficiency Repeat
  • 574043 2022-002
    Material Weakness
  • 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