Finding 380797 (2022-001)

Material Weakness Repeat Finding
Requirement
P
Questioned Costs
-
Year
2022
Accepted
2024-03-18
Audit: 295516
Organization: County of Salem (NJ)

AI Summary

  • Core Issue: The County's grant records are not organized effectively, leading to delays in preparing necessary financial schedules.
  • Impacted Requirements: Timely preparation and submission of federal and state financial assistance schedules to the Federal Audit Clearinghouse.
  • Recommended Follow-Up: Implement better internal controls and review grant documentation to ensure timely completion and submission of schedules.

Finding Text

Criteria or Specific Requirement The County should maintain their grant records in a manner that facilitates the timely preparation of schedules of expenditures of federal awards and state financial assistance (“schedules”) and allows for the timely submission of the single audit to the Federal Audit Clearinghouse. Condition The grant records maintained by the County did not easily facilitate the timely preparation of the schedules of expenditures of federal awards and state financial assistance. Questioned Costs Not applicable. Context Although the County did have all the required documentation to complete the schedules of expenditures of federal awards and state financial assistance, the accumulation and review of the information required additional analysis and adjustments to prepare the schedules. Effect or Potential Effect The schedules were not completed in a timely manner and resulted in a delayed submission to the Federal Audit Clearinghouse. Cause Due to significant turnover and personnel emergencies in the finance department, the County was unable to timely gather and prepare the schedules. Identification as a Repeat Finding See Finding 2021-001. Recommendation The County should implement internal controls and review their grant documentation to allow for the timely completion of the schedules of expenditures of federal awards and state financial assistance and submission to the Federal Audit Clearinghouse. View of Responsible Officials and Planned Corrective Action The responsible officials agree with the finding and will address the matter as part of their corrective action plan.

Corrective Action Plan

a. Condition The County did not maintain grant records in a manner that facilitates the timely preparation of schedules and, thus was unable to file the audit with the federal clearinghouse in a timely manner. b. Recommendation The County should implement internal controls and review grant documentation to ensure the schedules are completed adequately and the audit is submitted to the federal clearinghouse in a timely manner. c. Corrective Action The County has updated financial reporting policies regarding the preparation of the Schedule of Expenditures of Federal Awards and the Schedule of Expenditures of State Financial Assistance in order to complete the schedules timely. The grant files maintained in the Finance office and the information in the Edmunds system are both in the process of being reviewed and updated, in order that information is streamlined for ease of use in the preparation of the Schedule of Expenditures of Federal Awards and the Schedule of Expenditures of State Financial Assistance. d. Implementation Date Immediately e. Responsible Individual/Position Kelly A Hannigan, CFO/Treasurer

Categories

Internal Control / Segregation of Duties

Other Findings in this Audit

  • 957239 2022-001
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
21.027 Coronavirus State and Local Fiscal Recovery Funds $7.71M
93.069 Public Health Emergency Preparedness $675,523
93.563 Child Support Enforcement $458,546
16.575 Crime Victim Assistance $299,902
93.044 Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers $261,952
93.558 Temporary Assistance for Needy Families $193,965
93.045 Special Programs for the Aging_title Iii, Part C_nutrition Services $147,782
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $133,163
93.268 Immunization Cooperative Agreements $132,091
16.738 Edward Byrne Memorial Justice Assistance Grant Program $131,080
17.259 Wia Youth Activities $123,418
17.258 Wia Adult Program $113,247
93.136 Injury Prevention and Control Research and State and Community Based Programs $113,146
17.278 Wia Dislocated Worker Formula Grants $78,901
97.067 Homeland Security Grant Program $78,561
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $58,280
93.052 National Family Caregiver Support, Title Iii, Part E $44,316
21.019 Coronavirus Relief Fund $38,923
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $22,201
93.043 Special Programs for the Aging_title Iii, Part D_disease Prevention and Health Promotion Services $15,380
16.588 Violence Against Women Formula Grants $9,630
16.607 Bulletproof Vest Partnership Program $3,951
93.778 Medical Assistance Program $3,600
93.736 Prevention Public Health Fund: Viral Hepatitis Prevention $2,906
10.576 Senior Farmers Market Nutrition Program $1,000
93.070 Environmental Public Health and Emergency Response $1,000