Finding 525782 (2024-002)

Material Weakness
Requirement
C
Questioned Costs
-
Year
2024
Accepted
2025-03-06
Audit: 344936
Organization: Town of Merrimack (NH)

AI Summary

  • Core Issue: The Town failed to record $132,701 in deposits related to federal reimbursements, leading to a material weakness in internal controls.
  • Impacted Requirements: This oversight violates federal regulations requiring effective cash management and accurate financial reporting for federal grants.
  • Recommended Follow-up: Implement procedures to ensure timely recording of all grant-related deposits and enhance reconciliation processes to address discrepancies promptly.

Finding Text

2024-002 Unrecorded Deposits (Material Weakness) Federal Agency: Department of Homeland Security Pass-through Agency: N/A Cluster/Program: Staffing for Adequate Fire and Emergency Response (SAFER) Assistance Listing Number: 97.083 Passed-through Identification: EMW-2020-FF-00046 Compliance Requirement: Cash Management Type of Finding: Internal Control over Compliance – Material Weakness Material Noncompliance Criteria or Specific Requirement: Federal regulations 2 CFR 200.303 states, the Town, as a recipient of Federal funds, must establish and maintain effective internal controls over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. Proper financial management and internal controls should ensure that all transactions related to Federal grants, including revenue recognition, expenditure tracking, and reporting, are accurately recorded in the Town’s general ledger in a timely manner. Failure to record deposits properly may result in financial misstatements, impact budgetary decisions, and affect compliance with Federal grant requirements. Condition: During the audit, we identified that the Town did not record deposits related to reimbursement requests #18 and #19 in the general ledger. These deposits, totaling $132,701, were reimbursements for payroll expenses associated with the firefighters hired under the SAFER grant. The unrecorded deposits caused the general ledger to be misstated as of June 30, 2024. Cause: The Town does not have adequate internal controls to ensure that all cash receipts, particularly those related to federal programs are recorded in the general ledger in a timely manner. This appears to stem from lack of detailed oversight over the cash reconciliation process while there was turnover in the finance office. Effect: Failure to record $132,701 in deposits resulted in a misstatement in the Town’s financial statements and non-compliance with cash management requirements. Additionally, the lack of timely recorded increases the risk of undetected errors or misuse of funds. Questioned Costs: None. While the deposits cleared the Town’s operating bank account via ACH from the federal awarding agency, the Town eventually identified the missing deposits and posted them to their general ledger system. Identification as Repeat Finding: This is not a repeat finding from the prior year. Recommendation: We recommend that the Town implement procedures to ensure that all grant related deposits are recorded in the general ledger upon receipt. In addition, we recommend that the Town implement additional procedures during the reconciliation process to ensure any identified variances or discrepancies are researched and addressed in a timely manner. Views of Responsible Officials: Management’s views and corrective action plan is included at the end of this report.

Corrective Action Plan

Audit Finding Reference: 2024-002 Management’s Response and Planned Corrective Action: We have developed a procedure of printing out all State of NH remittance advices. -Check bank receipts daily. -Print out the State of NH remittance advices. -Confirm Funds were received. -Book the receipt to Unifund. Name of Contact Person and Completion Date: Name 1: Paul Calabria Name 2: Xenia Simpson Anticipated Completion Date – February 25, 2025

Categories

Cash Management Internal Control / Segregation of Duties Material Weakness Reporting Matching / Level of Effort / Earmarking

Other Findings in this Audit

  • 525773 2024-001
    Significant Deficiency
  • 525774 2024-001
    Significant Deficiency
  • 525775 2024-001
    Significant Deficiency
  • 525776 2024-001
    Significant Deficiency
  • 525777 2024-001
    Significant Deficiency
  • 525778 2024-001
    Significant Deficiency
  • 525779 2024-001
    Significant Deficiency
  • 525780 2024-001
    Significant Deficiency
  • 525781 2024-001
    Significant Deficiency
  • 525783 2024-003
    Significant Deficiency
  • 1102215 2024-001
    Significant Deficiency
  • 1102216 2024-001
    Significant Deficiency
  • 1102217 2024-001
    Significant Deficiency
  • 1102218 2024-001
    Significant Deficiency
  • 1102219 2024-001
    Significant Deficiency
  • 1102220 2024-001
    Significant Deficiency
  • 1102221 2024-001
    Significant Deficiency
  • 1102222 2024-001
    Significant Deficiency
  • 1102223 2024-001
    Significant Deficiency
  • 1102224 2024-002
    Material Weakness
  • 1102225 2024-003
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
66.458 Clean Water State Revolving Fund $9.31M
20.205 Highway Planning and Construction $1.30M
97.083 Staffing for Adequate Fire and Emergency Response (safer) $1.03M
21.027 Coronavirus State and Local Fiscal Recovery Funds $509,106
16.710 Public Safety Partnership and Community Policing Grant $395,119
16.838 Comprehensive Opioid, Stimulant, and Other Substances Use Program $28,362
20.600 State and Community Highway Safety $12,348
16.607 Bulletproof Vest Partnership Program $7,323