Finding 393701 (2023-001)

Material Weakness
Requirement
P
Questioned Costs
-
Year
2023
Accepted
2024-04-18

AI Summary

  • Core Issue: A revenue entry was misclassified, leading to a $179,000 understatement for 2022 and an overstatement for 2023 in the SEFA.
  • Impacted Requirements: Internal controls over compliance were ineffective, resulting in incomplete reporting of federal expenditures.
  • Recommended Follow-Up: Implement a tracking system to ensure accurate reporting of all federal award expenditures in line with Uniform Guidance.

Finding Text

Finding Number: 2023-001 Programs Affected: 21.027 Coronavirus State and Local Fiscal Recovery Funds Criteria: The Organization is responsible for designing, implementing and maintaining effective internal controls over compliance that provide reasonable assurance that the internal controls will prevent misstatements or detect and correct misstatements on a timely basis, intentional or unintentional, from occurring. Condition Found: While comparing and reconciling the schedule of expenditures of federal awards (SEFA) to the consolidated financial statements, we noted one revenue entry was included in the SEFA which related to expenses incurred during the year ended December 31, 2022. Assistance Listing 21.027 was understated by approximately $179,000 for the year ended December 31, 2022 and Assistance Listing 21.027 was overstated by approximately $179,000 for the year ended December 31, 2023. The amount was recorded correct for the program year, but not the agency fiscal year. Cause and Effect: The staff member that created the revenue entry should have split it between December 2022 and January 2023. The error was overlooked by the entry reviewer. The condition resulted in management not identifying all expenditures to be included in the SEFA in 2022, which could have resulted in incomplete information reported to users of the SEFA. Questioned Costs: N/A Identification of Repeat Findings:N/A Recommendation:We recommend the Organization implement a tracking system to identify and report all expenditures of federal awards on the SEFA in compliance with the requirements of the Uniform Guidance. Views of a Responsible Official and Corrective Action Plan: Management agrees with the finding. See attached Corrective Action Plan.

Corrective Action Plan

Management will implement a reconciliation process when preparing the schedule of expenditures of federal awards to identify the period in which the expenditures were incurred. This will allow the reporting of expenditures in the proper period. Responsible party: Daniel Kern, Chief Financial Officer; (603) 641 9441 Anticipated completion date: June 30, 2024

Categories

Reporting

Other Findings in this Audit

  • 970143 2023-001
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
21.027 Coronavirus State and Local Fiscal Recovery Funds $955,704
93.959 Block Grants for Prevention and Treatment of Substance Abuse $741,118
14.239 Home Investment Partnerships Program $436,958
14.856 Lower Income Housing Assistance Program_section 8 Moderate Rehabilitation $414,656
93.243 Substance Abuse and Mental Health Services_projects of Regional and National Significance $377,851
93.788 Opioid Str $278,421
14.267 Continuum of Care Program $24,235