Finding 1160150 (2024-002)

Material Weakness Repeat Finding
Requirement
L
Questioned Costs
-
Year
2024
Accepted
2025-10-08
Audit: 370532
Organization: Sullivan County (NH)
Auditor: Cbiz CPAS

AI Summary

  • Core Issue: The County has significant weaknesses in its internal controls over financial reporting, leading to errors in quarterly and annual expenditure reports.
  • Impacted Requirements: Compliance with OMB’s Uniform Administrative Requirements is at risk due to inaccuracies in reporting, including duplicative and misclassified expenditures.
  • Recommended Follow-Up: Strengthen internal controls by implementing a formal review process for report accuracy, validating calculations, and ensuring oversight during transitions to new reporting systems.

Finding Text

Federal Program Information Federal Agency: U.S. Department of the Treasury Award Name: Coronavirus State and Local Fiscal Recovery Funds Assistance Listing Number: 21.027 Award Year: 2021, 2022 Compliance Requirement: Reporting Type of Finding Compliance Internal Control over Compliance – Material Weakness Criteria or Specific Requirement OMB’s Uniform Administrative Requirement, Cost Principles, and Audit Requirements for Federal Awards (UG) requires an entity 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. Per program guidelines, recipients must ensure the accuracy and completeness of all required reports, including annual project and expenditure reports and quarterly expenditure reports. Condition and Context During our testing of a sample of two of the quarterly expenditure reports utilizing the Governor’s Office for Emergency Relief and Recovery (GOFERR) funding, we noted the following issues: • The Q1 report included $2,534,152 of expenditures that were attributable to a subsequent period as well as a typographical error in the cumulative total expenditure amount; • The Q2 report included $8,636,710 in duplicative expenditures that were also reported in Q1 as well as a typographical error in the cumulative total expenditure amount; and • Formula discrepancies were noted in both Q1 and Q2 reports, resulting in inaccurate calculations. During our testing of the annual project and expenditure report under the direct portion of ARPA funding we noted a material discrepancy between cumulative expenditures per the general ledger and the amount reported of $94,749. The County attributed these discrepancies to a transition to a new summary process designed to increase reporting efficiency. All reported expenditures were valid and appropriately documented based on testing over allowable costs. Cause Weaknesses in the County’s internal controls over financial reporting led to data entry errors, formula discrepancies, and inaccurate report compilation during the transition to a new reporting process. Effect or Potential Effect There is a risk that inaccurate financial information is reported to the granting agency, which could impact program oversight and public transparency. Material errors in required reports constitute noncompliance with federal reporting requirements and increase the likelihood of errors or misstatements in future reporting periods. No questioned costs are reported as reported costs were valid and supported by underlying documentation. Recommendation The County should strengthen its internal controls over the preparation and review of required reports under the Coronavirus State and Local Fiscal Recovery Funds Program. This should include a formal review of the report data for accuracy, validation of formulas and calculations, and enhanced oversight during system or process transitions. 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

2024-002 Improve Controls and Documentation Over Reporting (Material Weakness – Compliance, Internal Control over Compliance) “During our testing of a sample of two of the quarterly expenditure reports utilizing the Governor’s Office for Emergency Relief and Recovery (GOFERR) funding, we noted the following issues: • The Q1 report included $2,534,152 of expenditures that were attributable to a subsequent period as well as a typographical error in the cumulative total expenditure amount; • The Q2 report included $8,636,710 in duplicative expenditures that were also reported in Q1 as well as a typographical error in the cumulative total expenditure amount; and • Formula discrepancies were noted in both Q1 and Q2 reports, resulting in inaccurate calculations. During our testing of the annual project and expenditure report under the direct portion of ARPA funding we noted a material discrepancy between cumulative expenditures per the general ledger and the amount reported of $94,749. The County attributed these discrepancies to a transition to a new summary process designed to increase reporting efficiency. All reported expenditures were valid and appropriately documented based on testing over allowable costs.” Manager’s Statement of Concurrence or Nonconcurrence: The County recognizes there was discrepancy identified between the GOFERR reporting for the ARPA funding and the County’s general ledger. The discrepancy was a result of changes in reporting requirements and data entry errors that did not reflect an actual discrepancy of project costs or missing funds. The issue was used as an opportunity to improve the County’s internal financial tracking by having the Finance Department support the Facilities and Operations Department with an added reconciliation process to verify the reporting is accurate. The reporting requirements have been better clarified since the inception of the reporting model and seems more stabilized. Corrective Action: The worksheet used to track and calculate the data has been updated. Where possible, formulas have been simplified and streamlined to better match the reporting requirements and use corrected timeframes. The remnant data from earlier iterations that catered to earlier requirements, or understanding of those requirements has been removed. When general ledger data entry requests are delivered to the Finance Department they will be accompanied by the worksheet as supporting documentation so that an added reconciliation may be performed.

Categories

Allowable Costs / Cost Principles Reporting Internal Control / Segregation of Duties Material Weakness

Other Findings in this Audit

  • 1160148 2024-002
    Material Weakness Repeat
  • 1160149 2024-002
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
21.027 Coronavirus State and Local Fiscal Recovery Funds $10.78M
14.905 Lead Hazard Reduction Demonstration Grant Program $273,078
14.228 Community Development Block Grants/state's Program and Non-Entitlement Grants in Hawaii $25,007
16.593 Residential Substance Abuse Treatment for State Prisoners $5,989