Finding 1153516 (2024-007)

Material Weakness Repeat Finding
Requirement
L
Questioned Costs
-
Year
2024
Accepted
2025-09-19
Audit: 366795
Organization: City of Manchester, Nh (NH)
Auditor: Cbiz CPAS PC

AI Summary

  • Core Issue: There is a significant deficiency in internal controls over the reporting of Federal program information, specifically due to a lack of segregation of duties in the preparation and review of financial reports.
  • Impacted Requirements: Compliance with 2 CFR 200.303 is at risk, as it mandates effective internal controls to ensure accurate reporting and compliance with Federal statutes.
  • Recommended Follow-Up: The City should establish procedures for proper segregation of duties and implement a documented independent review process for all Federal reports before submission.

Finding Text

2024-007 Improve Internal Controls Over Reporting Federal Program(s) Information Federal Agency: Department of Justice Award Name: Public Safety Partnership and Community Policing Grants Assistance Listing Number: 16.710 Award Year: 2024 Compliance Requirement: Reporting Type of Finding Internal Control over Compliance – Significant Deficiency Criteria or Specific Requirement 2 CFR 200.303 requires non-Federal entities to establish and maintain effective internal controls over Federal awards to provide reasonable assurance of compliance with Federal statutes, regulations, and the terms and conditions of the award. Effective internal control includes appropriate segregation of duties to prevent and detect errors and irregularities in financial reporting, including the preparation and review of Federal Financial Reports (such as the SF-425). Condition and Context During our testing of two quarterly SF-425 Federal Financial Reports submitted under the Public Safety Partnership and Community Policing Grants program, we noted that although the amounts reported agreed to the general ledger, there was no segregation of duties between the individual who prepared the reports and the individual responsible for review and approval prior to submission. The same individual performed both preparation and submission duties without a documented independent review. Cause The City did not establish adequate internal control procedures to ensure that reports under the program are subject to independent review and approval prior to submission. Effect or Potential Effect The lack of segregation of duties increases the risk that errors or misstatements in the reports could go undetected. No questioned costs are reported as the requirement is procedural in nature. Recommendation The City should implement procedures to ensure appropriate segregation of duties in the preparation and review of all Federal reports. The process should include a documented, independent review and approval of reports prior to their submission to ensure accuracy and compliance with grant requirements. Views of Responsible Official Management’s corrective action plan is included at the end of this report after the Schedule of Prior Year Findings.

Corrective Action Plan

2024-007 Improve Internal Controls Over Reporting Management Response and Corrective Action Plan: We concur with the finding. The City acknowledges that the preparation and submission of SF- 425 Federal Financial Reports under the Public Safety Partnership and Community Policing Grants program lacked appropriate segregation of duties. To address this, the City and Department will implement written procedures requiring that all Federal financial reports undergo an independent review and documented approval prior to submission. The Financial Analyst will prepare reports, the Grant Coordinator (or designee) will perform and document the review, and the Authorized Official (Business Services Manager) will submit only after review is complete. A review checklist will be adopted, and documentation will be retained in the grant file. Staff training on internal control requirements will be conducted, and full implementation is expected within 90 days. The Independent City Auditor will be responsible for ensuring completion and ongoing compliance. Planned Implementation Date: 12/17/2025 Person Responsible for Corrective Action: Julianne Pelletier

Categories

Reporting Internal Control / Segregation of Duties

Other Findings in this Audit

  • 1153513 2024-005
    Material Weakness Repeat
  • 1153514 2024-006
    Material Weakness Repeat
  • 1153515 2024-006
    Material Weakness Repeat
  • 1153517 2024-004
    Material Weakness Repeat
  • 1153518 2024-004
    Material Weakness Repeat
  • 1153519 2024-004
    Material Weakness Repeat
  • 1153520 2024-004
    Material Weakness Repeat
  • 1153521 2024-004
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
21.027 Coronavirus State and Local Fiscal Recovery Funds $10.39M
14.218 Community Development Block Grants/entitlement Grants $2.11M
20.933 National Infrastructure Investments $2.03M
93.224 Health Center Program (community Health Centers, Migrant Health Centers, Health Care for the Homeless, and Public Housing Primary Care) $1.75M
20.106 Airport Improvement Program, Infrastructure Investment and Jobs Act Programs, and Covid-19 Airports Programs $1.09M
14.905 Lead Hazard Reduction Demonstration Grant Program $1.09M
14.239 Home Investment Partnerships Program $789,327
16.710 Public Safety Partnership and Community Policing Grants $557,872
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $348,910
97.067 Homeland Security Grant Program $339,208
16.922 Equitable Sharing Program $273,534
93.069 Public Health Emergency Preparedness $268,149
93.959 Block Grants for Prevention and Treatment of Substance Abuse $256,420
14.913 Healthy Homes Production Program $246,893
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $209,777
16.738 Edward Byrne Memorial Justice Assistance Grant Program $192,284
93.421 Strengthening Public Health Systems and Services Through National Partnerships to Improve and Protect the Nation’s Health $170,578
93.994 Maternal and Child Health Services Block Grant to the States $169,211
16.838 Comprehensive Opioid, Stimulant, and Other Substances Use Program $162,363
14.231 Emergency Solutions Grant Program $137,932
93.104 Comprehensive Community Mental Health Services for Children with Serious Emotional Disturbances (sed) $135,899
66.458 Clean Water State Revolving Fund $135,799
93.268 Immunization Cooperative Agreements $133,540
93.940 Hiv Prevention Activities Health Department Based $101,282
16.751 Edward Byrne Memorial Competitive Grant Program $88,677
16.550 State Justice Statistics Program for Statistical Analysis Centers $83,500
16.839 Stop School Violence $81,175
16.588 Violence Against Women Formula Grants $78,636
20.930 Payments for Small Community Air Service Development $74,528
66.468 Drinking Water State Revolving Fund $66,145
93.527 Grants for New and Expanded Services Under the Health Center Program $61,388
20.600 State and Community Highway Safety $45,848
93.366 State Actions to Improve Oral Health Outcomes and Partner Actions to Improve Oral Health Outcomes $44,000
93.197 Childhood Lead Poisoning Prevention Projects, State and Local Childhood Lead Poisoning Prevention and Surveillance of Blood Lead Levels in Children $39,857
21.016 Equitable Sharing $36,111
93.977 Sexually Transmitted Diseases (std) Prevention and Control Grants $21,050
93.991 Preventive Health and Health Services Block Grant $14,181
16.609 Project Safe Neighborhoods $13,649
93.889 National Bioterrorism Hospital Preparedness Program $9,007
93.136 Injury Prevention and Control Research and State and Community Based Programs $8,950
93.103 Food and Drug Administration Research $1,712
16.034 Coronavirus Emergency Supplemental Funding Program $1,663