Audit 25356

FY End
2022-06-30
Total Expended
$325.56M
Findings
14
Programs
29
Organization: City of Atlanta (GA)
Year: 2022 Accepted: 2023-03-30

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
26025 2022-007 Significant Deficiency - N
26026 2022-007 Significant Deficiency - N
26027 2022-007 Significant Deficiency - N
26028 2022-007 Significant Deficiency - N
26029 2022-007 Significant Deficiency - N
26030 2022-007 Significant Deficiency - N
26031 2022-006 Material Weakness - L
602467 2022-007 Significant Deficiency - N
602468 2022-007 Significant Deficiency - N
602469 2022-007 Significant Deficiency - N
602470 2022-007 Significant Deficiency - N
602471 2022-007 Significant Deficiency - N
602472 2022-007 Significant Deficiency - N
602473 2022-006 Material Weakness - L

Programs

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

Contacts

Name Title Type
HAAWKXL2PLE3 Youlanda Carr Auditee
4048658453 Hope Pendergrass Auditor
No contacts on file

Notes to SEFA

Title: LOANS Accounting Policies: The basic financial statements of the City of Atlanta, Georgia (the City), as of and for the year ended June 30,2022, include the operations of the Atlanta Development Authority. The accompanying schedule ofexpenditures of federal awards does not include federal financial assistance received directly by the AtlantaDevelopment Authority because this component unit engaged other auditors to perform an audit in accordancewith the Uniform Guidance. Accordingly, the accompanying schedule of expenditures of federal awardspresents the federal financial assistance programs administered by the City, and does not reflect the federalfinancial assistance programs administered by the Atlanta Development Authority.The accompanying schedule of expenditures of federal awards is presented using the modified accrual basis ofaccounting. Under the modified accrual basis of accounting, expenditures are recognized when the relatedliability is incurred.In instances where the grant agreement requires the City to match grant awards with City funds, such matchingfunds are excluded from the accompanying schedule of expenditures of federal awards. Grant programs that didnot have 2022 transactions have not been presented herein. The majority of these programs have completedtheir program activities but may not have been formally closed out. Grant revenues and expenditures incurredprior to 2022 under these grants remain subject to audit by either the grantor agency or its representativeswithin the limitations of the Uniform Guidance.Federal grant programs that are administered through State agencies (pass-through awards) have been includedin the accompanying schedule of expenditures of federal awards. These programs are operated according tofederal regulations promulgated by the originating federal agency providing the funding. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. The City uses funds available under the Community Development Block Grant and HOME Investment Grantprograms to provide low-interest loans to eligible persons. Principal payments received are used to makeadditional loans as part of the revolving loan fund. Disbursements of such loans are included as expenditures inthe accompanying schedule of expenditures of federal awards in the year of disbursement. The balances arenot included in the accompanying schedule as there are no continuing compliance requirements related to theloans.

Finding Details

Criteria: Title 24 U.S. Code of Federal Regulations sections 58.1, 58.22, 58.34, 58.35, and 570.604 require projects to have an environmental review unless they meet criteria specified in the regulations that would exempt or exclude them from environmental certification requirements. For projects where the environmental review was not performed, a written documentation that the review was not required must be prepared. 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 exception noted during our testing: - One (1) out of eleven (11) projects we tested for environmental reviews did not have a timely exception report prepared. The Salvation Army, Red Shields Lodge project had expenditures as early as October 2021 and the exception report was prepared on March 9, 2023. Context/cause: The City did not have adequate internal controls to ensure compliance with the special test ? environmental review requirements. Testing was performed over each requirement for the City. Out of a total population of twenty-two (22) projects, we selected a sample of eleven (11) projects to test for environmental reviews. One (1) out of the eleven (11) projects tested did not have an exemption report prepared in a timely manner. Effects: Noncompliance at the special test ? environmental review 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 special testing requirements. Auditee?s Response: The City of Atlanta?s Department of Grants and Community Development (DGCD) acknowledges and agrees with this Environmental Review finding. DGCD will reinforce its standard operating procedure concerning ERs and will reinsure that environmental reviews are properly completed for every awarded grant project.
Criteria: Title 24 U.S. Code of Federal Regulations sections 58.1, 58.22, 58.34, 58.35, and 570.604 require projects to have an environmental review unless they meet criteria specified in the regulations that would exempt or exclude them from environmental certification requirements. For projects where the environmental review was not performed, a written documentation that the review was not required must be prepared. 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 exception noted during our testing: - One (1) out of eleven (11) projects we tested for environmental reviews did not have a timely exception report prepared. The Salvation Army, Red Shields Lodge project had expenditures as early as October 2021 and the exception report was prepared on March 9, 2023. Context/cause: The City did not have adequate internal controls to ensure compliance with the special test ? environmental review requirements. Testing was performed over each requirement for the City. Out of a total population of twenty-two (22) projects, we selected a sample of eleven (11) projects to test for environmental reviews. One (1) out of the eleven (11) projects tested did not have an exemption report prepared in a timely manner. Effects: Noncompliance at the special test ? environmental review 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 special testing requirements. Auditee?s Response: The City of Atlanta?s Department of Grants and Community Development (DGCD) acknowledges and agrees with this Environmental Review finding. DGCD will reinforce its standard operating procedure concerning ERs and will reinsure that environmental reviews are properly completed for every awarded grant project.
Criteria: Title 24 U.S. Code of Federal Regulations sections 58.1, 58.22, 58.34, 58.35, and 570.604 require projects to have an environmental review unless they meet criteria specified in the regulations that would exempt or exclude them from environmental certification requirements. For projects where the environmental review was not performed, a written documentation that the review was not required must be prepared. 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 exception noted during our testing: - One (1) out of eleven (11) projects we tested for environmental reviews did not have a timely exception report prepared. The Salvation Army, Red Shields Lodge project had expenditures as early as October 2021 and the exception report was prepared on March 9, 2023. Context/cause: The City did not have adequate internal controls to ensure compliance with the special test ? environmental review requirements. Testing was performed over each requirement for the City. Out of a total population of twenty-two (22) projects, we selected a sample of eleven (11) projects to test for environmental reviews. One (1) out of the eleven (11) projects tested did not have an exemption report prepared in a timely manner. Effects: Noncompliance at the special test ? environmental review 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 special testing requirements. Auditee?s Response: The City of Atlanta?s Department of Grants and Community Development (DGCD) acknowledges and agrees with this Environmental Review finding. DGCD will reinforce its standard operating procedure concerning ERs and will reinsure that environmental reviews are properly completed for every awarded grant project.
Criteria: Title 24 U.S. Code of Federal Regulations sections 58.1, 58.22, 58.34, 58.35, and 570.604 require projects to have an environmental review unless they meet criteria specified in the regulations that would exempt or exclude them from environmental certification requirements. For projects where the environmental review was not performed, a written documentation that the review was not required must be prepared. 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 exception noted during our testing: - One (1) out of eleven (11) projects we tested for environmental reviews did not have a timely exception report prepared. The Salvation Army, Red Shields Lodge project had expenditures as early as October 2021 and the exception report was prepared on March 9, 2023. Context/cause: The City did not have adequate internal controls to ensure compliance with the special test ? environmental review requirements. Testing was performed over each requirement for the City. Out of a total population of twenty-two (22) projects, we selected a sample of eleven (11) projects to test for environmental reviews. One (1) out of the eleven (11) projects tested did not have an exemption report prepared in a timely manner. Effects: Noncompliance at the special test ? environmental review 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 special testing requirements. Auditee?s Response: The City of Atlanta?s Department of Grants and Community Development (DGCD) acknowledges and agrees with this Environmental Review finding. DGCD will reinforce its standard operating procedure concerning ERs and will reinsure that environmental reviews are properly completed for every awarded grant project.
Criteria: Title 24 U.S. Code of Federal Regulations sections 58.1, 58.22, 58.34, 58.35, and 570.604 require projects to have an environmental review unless they meet criteria specified in the regulations that would exempt or exclude them from environmental certification requirements. For projects where the environmental review was not performed, a written documentation that the review was not required must be prepared. 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 exception noted during our testing: - One (1) out of eleven (11) projects we tested for environmental reviews did not have a timely exception report prepared. The Salvation Army, Red Shields Lodge project had expenditures as early as October 2021 and the exception report was prepared on March 9, 2023. Context/cause: The City did not have adequate internal controls to ensure compliance with the special test ? environmental review requirements. Testing was performed over each requirement for the City. Out of a total population of twenty-two (22) projects, we selected a sample of eleven (11) projects to test for environmental reviews. One (1) out of the eleven (11) projects tested did not have an exemption report prepared in a timely manner. Effects: Noncompliance at the special test ? environmental review 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 special testing requirements. Auditee?s Response: The City of Atlanta?s Department of Grants and Community Development (DGCD) acknowledges and agrees with this Environmental Review finding. DGCD will reinforce its standard operating procedure concerning ERs and will reinsure that environmental reviews are properly completed for every awarded grant project.
Criteria: Title 24 U.S. Code of Federal Regulations sections 58.1, 58.22, 58.34, 58.35, and 570.604 require projects to have an environmental review unless they meet criteria specified in the regulations that would exempt or exclude them from environmental certification requirements. For projects where the environmental review was not performed, a written documentation that the review was not required must be prepared. 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 exception noted during our testing: - One (1) out of eleven (11) projects we tested for environmental reviews did not have a timely exception report prepared. The Salvation Army, Red Shields Lodge project had expenditures as early as October 2021 and the exception report was prepared on March 9, 2023. Context/cause: The City did not have adequate internal controls to ensure compliance with the special test ? environmental review requirements. Testing was performed over each requirement for the City. Out of a total population of twenty-two (22) projects, we selected a sample of eleven (11) projects to test for environmental reviews. One (1) out of the eleven (11) projects tested did not have an exemption report prepared in a timely manner. Effects: Noncompliance at the special test ? environmental review 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 special testing requirements. Auditee?s Response: The City of Atlanta?s Department of Grants and Community Development (DGCD) acknowledges and agrees with this Environmental Review finding. DGCD will reinforce its standard operating procedure concerning ERs and will reinsure that environmental reviews are properly completed for every awarded grant project.
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.
Criteria: Title 24 U.S. Code of Federal Regulations sections 58.1, 58.22, 58.34, 58.35, and 570.604 require projects to have an environmental review unless they meet criteria specified in the regulations that would exempt or exclude them from environmental certification requirements. For projects where the environmental review was not performed, a written documentation that the review was not required must be prepared. 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 exception noted during our testing: - One (1) out of eleven (11) projects we tested for environmental reviews did not have a timely exception report prepared. The Salvation Army, Red Shields Lodge project had expenditures as early as October 2021 and the exception report was prepared on March 9, 2023. Context/cause: The City did not have adequate internal controls to ensure compliance with the special test ? environmental review requirements. Testing was performed over each requirement for the City. Out of a total population of twenty-two (22) projects, we selected a sample of eleven (11) projects to test for environmental reviews. One (1) out of the eleven (11) projects tested did not have an exemption report prepared in a timely manner. Effects: Noncompliance at the special test ? environmental review 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 special testing requirements. Auditee?s Response: The City of Atlanta?s Department of Grants and Community Development (DGCD) acknowledges and agrees with this Environmental Review finding. DGCD will reinforce its standard operating procedure concerning ERs and will reinsure that environmental reviews are properly completed for every awarded grant project.
Criteria: Title 24 U.S. Code of Federal Regulations sections 58.1, 58.22, 58.34, 58.35, and 570.604 require projects to have an environmental review unless they meet criteria specified in the regulations that would exempt or exclude them from environmental certification requirements. For projects where the environmental review was not performed, a written documentation that the review was not required must be prepared. 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 exception noted during our testing: - One (1) out of eleven (11) projects we tested for environmental reviews did not have a timely exception report prepared. The Salvation Army, Red Shields Lodge project had expenditures as early as October 2021 and the exception report was prepared on March 9, 2023. Context/cause: The City did not have adequate internal controls to ensure compliance with the special test ? environmental review requirements. Testing was performed over each requirement for the City. Out of a total population of twenty-two (22) projects, we selected a sample of eleven (11) projects to test for environmental reviews. One (1) out of the eleven (11) projects tested did not have an exemption report prepared in a timely manner. Effects: Noncompliance at the special test ? environmental review 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 special testing requirements. Auditee?s Response: The City of Atlanta?s Department of Grants and Community Development (DGCD) acknowledges and agrees with this Environmental Review finding. DGCD will reinforce its standard operating procedure concerning ERs and will reinsure that environmental reviews are properly completed for every awarded grant project.
Criteria: Title 24 U.S. Code of Federal Regulations sections 58.1, 58.22, 58.34, 58.35, and 570.604 require projects to have an environmental review unless they meet criteria specified in the regulations that would exempt or exclude them from environmental certification requirements. For projects where the environmental review was not performed, a written documentation that the review was not required must be prepared. 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 exception noted during our testing: - One (1) out of eleven (11) projects we tested for environmental reviews did not have a timely exception report prepared. The Salvation Army, Red Shields Lodge project had expenditures as early as October 2021 and the exception report was prepared on March 9, 2023. Context/cause: The City did not have adequate internal controls to ensure compliance with the special test ? environmental review requirements. Testing was performed over each requirement for the City. Out of a total population of twenty-two (22) projects, we selected a sample of eleven (11) projects to test for environmental reviews. One (1) out of the eleven (11) projects tested did not have an exemption report prepared in a timely manner. Effects: Noncompliance at the special test ? environmental review 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 special testing requirements. Auditee?s Response: The City of Atlanta?s Department of Grants and Community Development (DGCD) acknowledges and agrees with this Environmental Review finding. DGCD will reinforce its standard operating procedure concerning ERs and will reinsure that environmental reviews are properly completed for every awarded grant project.
Criteria: Title 24 U.S. Code of Federal Regulations sections 58.1, 58.22, 58.34, 58.35, and 570.604 require projects to have an environmental review unless they meet criteria specified in the regulations that would exempt or exclude them from environmental certification requirements. For projects where the environmental review was not performed, a written documentation that the review was not required must be prepared. 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 exception noted during our testing: - One (1) out of eleven (11) projects we tested for environmental reviews did not have a timely exception report prepared. The Salvation Army, Red Shields Lodge project had expenditures as early as October 2021 and the exception report was prepared on March 9, 2023. Context/cause: The City did not have adequate internal controls to ensure compliance with the special test ? environmental review requirements. Testing was performed over each requirement for the City. Out of a total population of twenty-two (22) projects, we selected a sample of eleven (11) projects to test for environmental reviews. One (1) out of the eleven (11) projects tested did not have an exemption report prepared in a timely manner. Effects: Noncompliance at the special test ? environmental review 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 special testing requirements. Auditee?s Response: The City of Atlanta?s Department of Grants and Community Development (DGCD) acknowledges and agrees with this Environmental Review finding. DGCD will reinforce its standard operating procedure concerning ERs and will reinsure that environmental reviews are properly completed for every awarded grant project.
Criteria: Title 24 U.S. Code of Federal Regulations sections 58.1, 58.22, 58.34, 58.35, and 570.604 require projects to have an environmental review unless they meet criteria specified in the regulations that would exempt or exclude them from environmental certification requirements. For projects where the environmental review was not performed, a written documentation that the review was not required must be prepared. 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 exception noted during our testing: - One (1) out of eleven (11) projects we tested for environmental reviews did not have a timely exception report prepared. The Salvation Army, Red Shields Lodge project had expenditures as early as October 2021 and the exception report was prepared on March 9, 2023. Context/cause: The City did not have adequate internal controls to ensure compliance with the special test ? environmental review requirements. Testing was performed over each requirement for the City. Out of a total population of twenty-two (22) projects, we selected a sample of eleven (11) projects to test for environmental reviews. One (1) out of the eleven (11) projects tested did not have an exemption report prepared in a timely manner. Effects: Noncompliance at the special test ? environmental review 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 special testing requirements. Auditee?s Response: The City of Atlanta?s Department of Grants and Community Development (DGCD) acknowledges and agrees with this Environmental Review finding. DGCD will reinforce its standard operating procedure concerning ERs and will reinsure that environmental reviews are properly completed for every awarded grant project.
Criteria: Title 24 U.S. Code of Federal Regulations sections 58.1, 58.22, 58.34, 58.35, and 570.604 require projects to have an environmental review unless they meet criteria specified in the regulations that would exempt or exclude them from environmental certification requirements. For projects where the environmental review was not performed, a written documentation that the review was not required must be prepared. 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 exception noted during our testing: - One (1) out of eleven (11) projects we tested for environmental reviews did not have a timely exception report prepared. The Salvation Army, Red Shields Lodge project had expenditures as early as October 2021 and the exception report was prepared on March 9, 2023. Context/cause: The City did not have adequate internal controls to ensure compliance with the special test ? environmental review requirements. Testing was performed over each requirement for the City. Out of a total population of twenty-two (22) projects, we selected a sample of eleven (11) projects to test for environmental reviews. One (1) out of the eleven (11) projects tested did not have an exemption report prepared in a timely manner. Effects: Noncompliance at the special test ? environmental review 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 special testing requirements. Auditee?s Response: The City of Atlanta?s Department of Grants and Community Development (DGCD) acknowledges and agrees with this Environmental Review finding. DGCD will reinforce its standard operating procedure concerning ERs and will reinsure that environmental reviews are properly completed for every awarded grant project.
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.