Finding 26031 (2022-006)

Material Weakness
Requirement
L
Questioned Costs
-
Year
2022
Accepted
2023-03-30
Audit: 25356
Organization: City of Atlanta (GA)

AI Summary

  • Core Issue: The City failed to submit nine monthly and five quarterly reports to Treasury, with all submitted reports missing deadlines.
  • Impacted Requirements: Compliance with Title 2 U.S. Code of Federal Regulations Part 200, which mandates timely submission of financial and performance data.
  • Recommended Follow-Up: Enhance internal controls and improve calendaring processes to ensure timely reporting in the future.

Finding Text

Criteria: Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) requires that direct recipients submit monthly and quarterly reports that include both financial and performance data. The deadlines for these reports to be submitted was set by the U.S. Department of Treasury (?Treasury?). Condition: Internal controls should be in place to ensure the City is in compliance with all requirements of the federal award program. Internal controls were not sufficient to detect the following exceptions noted during our testing: - Nine (9) monthly reports and five (5) quarterly reports were not submitted to Treasury. - Out of the twenty-two (22) total monthly and quarterly reports that were submitted to Treasury, none of the reports were submitted on or before the deadline issued by Treasury. Context/cause: The City did not have adequate internal controls to ensure compliance with reporting requirements. Effects: Noncompliance at the reporting level may occur and not be detected by the City. Questioned Costs: Undetermined Recommendation: We recommend the City enhance internal controls to ensure compliance with reporting requirements. Auditee?s Response: The City of Atlanta?s Office of Enterprise Risk Management (ERM) acknowledges and agrees with the reporting findings. ERM will enhance its calendaring processes for mandated reporting to ensure that reports are filed timely.

Corrective Action Plan

Name of Contact Person Responsible for Corrective Action Plan: Jerry Deloach, Chief Risk Officer - Enterprise Risk Management Corrective Action Plan: The City of Atlanta?s Office of Enterprise Risk Management (ERM) will calendar the deadlines for filing of reports 90 days from the filing date and each 30-day period thereafter until the filing date and filing of the report. In addition, the Office of ERM will calendar the filing date two weeks prior to filing date. ERM will file the report two weeks prior to the filing deadline date and provide the City of Atlanta?s Grants Accounting team with a copy of the filing. Anticipated Completion Date: June 30, 2023

Categories

Allowable Costs / Cost Principles Reporting Internal Control / Segregation of Duties

Other Findings in this Audit

  • 26025 2022-007
    Significant Deficiency
  • 26026 2022-007
    Significant Deficiency
  • 26027 2022-007
    Significant Deficiency
  • 26028 2022-007
    Significant Deficiency
  • 26029 2022-007
    Significant Deficiency
  • 26030 2022-007
    Significant Deficiency
  • 602467 2022-007
    Significant Deficiency
  • 602468 2022-007
    Significant Deficiency
  • 602469 2022-007
    Significant Deficiency
  • 602470 2022-007
    Significant Deficiency
  • 602471 2022-007
    Significant Deficiency
  • 602472 2022-007
    Significant Deficiency
  • 602473 2022-006
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
20.106 Airport Improvement Program $50.00M
21.023 Emergency Rental Assistance Program $17.18M
66.458 Capitalization Grants for Clean Water State Revolving Funds $15.51M
14.231 Emergency Solutions Grant Program $6.88M
21.019 Coronavirus Relief Fund $5.21M
21.027 Coronavirus State and Local Fiscal Recovery Funds $2.52M
20.933 National Infrastructure Investments $2.50M
14.218 Community Development Block Grants/entitlement Grants $2.23M
16.738 Edward Byrne Memorial Justice Assistance Grant Program $1.10M
17.278 Wia Dislocated Worker Formula Grants $744,415
11.307 Economic Adjustment Assistance $601,971
14.241 Housing Opportunities for Persons with Aids $377,778
14.239 Home Investment Partnerships Program $341,158
16.922 Equitable Sharing Program $320,758
17.259 Wia Youth Activities $225,968
14.856 Lower Income Housing Assistance Program_section 8 Moderate Rehabilitation $215,160
17.258 Wia Adult Program $175,084
66.436 Surveys, Studies, Investigations, Demonstrations, and Training Grants and Cooperative Agreements - Section 104(b)(3) of the Clean Water Act $172,269
10.558 Child and Adult Care Food Program $148,680
10.559 Summer Food Service Program for Children $131,325
97.106 Securing the Cities Program $103,592
20.205 Highway Planning and Construction $101,264
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $84,729
10.175 Farmers Market and Local Food Promotion Program (b) $76,095
97.067 Homeland Security Grant Program $64,105
45.024 Promotion of the Arts_grants to Organizations and Individuals $25,000
66.818 Brownfields Assessment and Cleanup Cooperative Agreements $22,826
20.600 State and Community Highway Safety $8,439
20.507 Federal Transit_formula Grants $7,607