Finding 52312 (2022-001)

Significant Deficiency
Requirement
H
Questioned Costs
-
Year
2022
Accepted
2023-07-16
Audit: 48339
Organization: City of Fargo (ND)
Auditor: Eide Bailly

AI Summary

  • Core Issue: The City incorrectly reported a 2023 expenditure in the 2022 federal awards schedule.
  • Impacted Requirements: Internal controls failed to ensure compliance with period of performance documentation.
  • Recommended Follow-Up: Management should improve controls to ensure all federal expenditures are reported in the correct period.

Finding Text

Department of the Treasury and the North Dakota Department of Commerce Federal Financial Assistance Listing 21.027 COVID-19 Coronavirus State and Local Fiscal Recovery of Funds Period of Performance Significant Deficiency in Internal Control over Compliance Criteria - A good system of internal accounting control includes an adequate system for ensuring that all period of performance requirement are met, documented and approved. Condition - During the course of our engagement we noted that the City included a 2023 expenditure in the 2022 reported schedule of expenditures of federal awards. Cause - Control procedures in place did not detect the expenditures coded to the correct period. Effect - This expenditure is included in the wrong period. Questioned Costs - None reported. The total of known and projected questioned costs were less than the threshold that would require reporting. Context/Sampling - A non-statistical sample of 60 transactions out of a population over 250 total transactions were selected for testing, which accounted for $3,593,271 of $8,855,190 of federal program expenditures. Repeat Finding from Prior Year(s) - No Recommendation - Management should take steps to ensure that all federal expenditures are in the correct period under Uniform Guidance. Views of Responsible Officials - There is no disagreement with the audit finding.

Corrective Action Plan

COVID-19 Coronavirus State and Local Fiscal Recovery of Funds Federal Financial Assistance Listing 21.027 Period of Performance Significant Deficiency in Internal Control over Compliance Finding Summary: During the course of the audit engagement, it was noted that the City included one 2023 expenditure in the 2022 reported schedule of expenditures of federal awards. Responsible Individuals: Wyatt Papenfuss, Finance Manager Corrective Action Plan: The City will take steps to ensure that all federal expenditures are in the correct period under Uniform Guidance. Anticipated Completion Date: December 31, 2023

Categories

Reporting Period of Performance Significant Deficiency

Other Findings in this Audit

  • 628754 2022-001
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
66.458 Capitalization Grants for Clean Water State Revolving Funds $43.46M
20.507 Federal Transit_formula Grants $4.60M
97.047 Pre-Disaster Mitigation $1.30M
21.027 Coronavirus State and Local Fiscal Recovery Funds $1.20M
93.268 Immunization Cooperative Agreements $914,944
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $665,420
10.557 Special Supplemental Nutrition Program for Women, Infants, and Children $575,447
20.526 Buses and Bus Facilities Formula, Competitive, and Low Or No Emissions Programs $547,410
14.239 Home Investment Partnerships Program $533,595
93.069 Public Health Emergency Preparedness $412,606
14.218 Community Development Block Grants/entitlement Grants $405,614
93.917 Hiv Care Formula Grants $349,973
93.217 Family Planning_services $204,513
93.391 Activities to Support State, Tribal, Local and Territorial (stlt) Health Department Response to Public Health Or Healthcare Crises $173,902
97.067 Homeland Security Grant Program $166,617
93.898 Cancer Prevention and Control Programs for State, Territorial and Tribal Organizations $133,485
16.034 Coronavirus Emergency Supplemental Funding Program $119,750
20.513 Enhanced Mobility of Seniors and Individuals with Disabilities $68,908
97.042 Emergency Management Performance Grants $60,317
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $55,901
16.738 Edward Byrne Memorial Justice Assistance Grant Program $51,291
93.421 Strengthening Public Health Systems and Services Through National Partnerships to Improve and Protect the Nations Health $50,164
93.991 Preventive Health and Health Services Block Grant $42,850
93.116 Project Grants and Cooperative Agreements for Tuberculosis Control Programs $36,019
93.940 Hiv Prevention Activities_health Department Based $32,431
20.600 State and Community Highway Safety $27,788
93.994 Maternal and Child Health Services Block Grant to the States $26,176
20.703 Interagency Hazardous Materials Public Sector Training and Planning Grants $24,251
14.231 Emergency Solutions Grant Program $10,019
20.616 National Priority Safety Programs $9,779
20.608 Minimum Penalties for Repeat Offenders for Driving While Intoxicated $5,008
93.566 Refugee and Entrant Assistance_state Administered Programs $2,886
66.605 Performance Partnership Grants $1,250