Audit 35975

FY End
2022-12-31
Total Expended
$130.97M
Findings
22
Programs
46
Organization: Dekalb County, Ga (GA)
Year: 2022 Accepted: 2023-09-17

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
31692 2022-006 Significant Deficiency - N
31693 2022-006 Significant Deficiency - N
31694 2022-006 Significant Deficiency - N
31695 2022-004 Material Weakness - M
31696 2022-004 Material Weakness - M
31697 2022-005 Material Weakness - L
31698 2022-005 Material Weakness - L
31699 2022-005 Material Weakness - L
31700 2022-005 Material Weakness - L
31701 2022-005 Material Weakness - L
31702 2022-005 Material Weakness - L
608134 2022-006 Significant Deficiency - N
608135 2022-006 Significant Deficiency - N
608136 2022-006 Significant Deficiency - N
608137 2022-004 Material Weakness - M
608138 2022-004 Material Weakness - M
608139 2022-005 Material Weakness - L
608140 2022-005 Material Weakness - L
608141 2022-005 Material Weakness - L
608142 2022-005 Material Weakness - L
608143 2022-005 Material Weakness - L
608144 2022-005 Material Weakness - L

Programs

ALN Program Spent Major Findings
21.027 Coronavirus State and Local Fiscal Recovery Funds $25.43M Yes 1
66.468 Capitalization Grants for Drinking Water State Revolving Funds $13.49M - 0
66.458 Capitalization Grants for Clean Water State Revolving Funds $10.25M - 0
14.218 Community Development Block Grants/entitlement Grants $3.12M Yes 0
66.958 Water Infrastructure Finance and Innovation (wifia) (e) $2.30M - 0
21.019 Coronavirus Relief Fund $2.01M - 0
97.083 Staffing for Adequate Fire and Emergency Response (safer) $1.76M - 0
14.267 Continuum of Care Program $815,001 - 0
20.106 Airport Improvement Program $572,502 Yes 0
93.563 Child Support Enforcement $543,811 - 0
93.505 Affordable Care Act (aca) Maternal, Infant, and Early Childhood Home Visiting Program $521,707 - 0
20.205 Highway Planning and Construction $463,753 - 0
16.034 Coronavirus Emergency Supplemental Funding Program $302,513 - 0
17.274 Youthbuild $213,642 - 0
16.607 Bulletproof Vest Partnership Program $210,442 - 0
10.559 Summer Food Service Program for Children $210,315 - 0
16.590 Grants to Encourage Arrest Policies and Enforcement of Protection Orders Program $174,069 - 0
95.001 High Intensity Drug Trafficking Areas Program $165,101 - 0
16.021 Justice Systems Response to Families $123,970 - 0
17.258 Wia Adult Program $102,879 Yes 0
21.023 Emergency Rental Assistance Program $84,957 Yes 1
93.044 Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers $70,144 - 0
16.540 Juvenile Justice and Delinquency Prevention_allocation to States $68,077 - 0
17.277 Workforce Investment Act (wia) National Emergency Grants $66,348 - 0
14.231 Emergency Solutions Grant Program $64,318 Yes 1
16.585 Drug Court Discretionary Grant Program $63,739 - 0
16.745 Criminal and Juvenile Justice and Mental Health Collaboration Program $63,438 - 0
93.959 Block Grants for Prevention and Treatment of Substance Abuse $60,098 - 0
14.239 Home Investment Partnerships Program $53,393 - 0
17.278 Wia Dislocated Worker Formula Grants $52,092 Yes 0
16.588 Violence Against Women Formula Grants $50,000 - 0
16.013 Violence Against Women Act Court Training and Improvement Grants $39,126 - 0
97.042 Emergency Management Performance Grants $34,448 - 0
16.838 Comprehensive Opioid Abuse Site-Based Program $31,920 - 0
16.575 Crime Victim Assistance $25,024 - 0
16.734 Special Data Collections and Statistical Studies $25,000 - 0
21.016 Equitable Sharing $19,411 - 0
20.600 State and Community Highway Safety $18,154 - 0
93.052 National Family Caregiver Support, Title Iii, Part E $16,522 - 0
97.067 Homeland Security Grant Program $11,500 - 0
97.044 Assistance to Firefighters Grant $10,675 - 0
16.710 Public Safety Partnership and Community Policing Grants $9,511 - 0
93.053 Nutrition Services Incentive Program $2,018 - 0
16.738 Edward Byrne Memorial Justice Assistance Grant Program $1,414 - 0
17.259 Wia Youth Activities $1,382 Yes 0
16.922 Equitable Sharing Program $865 - 0

Contacts

Name Title Type
K8G5TL8B1XC7 Deborah Sherman Auditee
4043712238 Doug Moses Auditor
No contacts on file

Notes to SEFA

Accounting Policies: Basis of Presentation and Accounting The basic financial statements of DeKalb County, Georgia (the County), as of and for the year ended December 31, 2022, include the operations of the DeKalb County Board of Health. The accompanying schedule of expenditures of federal awards does not include federal financial assistance received directly by the DeKalb County Board of Health, because this component unit engaged other auditors to perform an audit in accordance with the Uniform Guidance. Accordingly, the accompanying schedule of expenditures of federal awards presents the federal financial assistance programs administered by the County, and does not reflect the federal financial assistance programs administered by the DeKalb County Board of Health. The accompanying schedule of expenditures of federal awards is presented using the modified accrual basis of accounting. Under the modified accrual basis of accounting, expenditures are recognized when the related liability is incurred. In instances where the grant agreement requires the County to match grant awards with County funds, such matching funds are excluded from the accompanying schedule of expenditures of federal awards. Grant programs that did not have 2022 transactions have not been presented herein. The majority of these programs have completed their program activities but may not have been formally closed out. Grant revenues and expenditures incurred prior to 2022 under these grants remain subject to audit by either the grantor agency or its representatives within the limitations of the Uniform Guidance. Federal grant programs that are administered through State agencies (pass-through awards) have been included in the accompanying schedule of expenditures of federal awards. These programs are operated according to federal regulations promulgated by the originating federal agency providing the funding. The County does not utilize the 10% de minimis indirect cost rate.(2) Loans The County uses funds available under the Community Development Block Grant and HOME Investment Grant programs to provide low-interest loans to eligible persons. Principal payments received are used to make additional loans as part of the revolving loan fund. Disbursements of such loans are included as expenditures in the accompanying schedule of expenditures of federal awards in the year of disbursement. The balances are not included in the accompanying schedule as there are no continuing compliance requirements related to the loans. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate.

Finding Details

Criteria: Emergency Solutions Grant (ESG) program guidance stipulates that within 180 days after the date that HUD signs the grant agreement (or a grant amendment for reallocation of funds) the recipient must obligate all of the grant amount, except the amount for its administrative costs. Condition: Internal controls should be in place to ensure the County is in compliance with all requirements of the federal award program. Due to numerous conditions stemming from the COVID-19 pandemic, including staffing, limited agency capacity, and agencies prioritizing the utilization of other funding sources, the County?s Community Development department, in charge of utilizing the ESG funding, was unable to completely obligate the 2021 ESG award by the deadline of February 7, 2022, instead ultimately locating agencies and subrecipients to utilize the entire award in August 2022. The County however did comply with the Expenditure and Payment Requirement, having met the deadline to expend the entire award within twenty-four (24) months. Context/cause: The County did not have adequate internal controls to ensure compliance with the requirement to obligate the 2021 ESG award within 180 days of HUD signing. Obligation of this entire award was not achieved until August 2022, approximately 360 days after HUD signing. Effect: The 2021 ESG award was not obligated within the required 180-day window. Questioned Costs: None. Recommendation: We recommend the County enhances internal controls to ensure compliance with all ESG program special test requirements.
Criteria: Emergency Solutions Grant (ESG) program guidance stipulates that within 180 days after the date that HUD signs the grant agreement (or a grant amendment for reallocation of funds) the recipient must obligate all of the grant amount, except the amount for its administrative costs. Condition: Internal controls should be in place to ensure the County is in compliance with all requirements of the federal award program. Due to numerous conditions stemming from the COVID-19 pandemic, including staffing, limited agency capacity, and agencies prioritizing the utilization of other funding sources, the County?s Community Development department, in charge of utilizing the ESG funding, was unable to completely obligate the 2021 ESG award by the deadline of February 7, 2022, instead ultimately locating agencies and subrecipients to utilize the entire award in August 2022. The County however did comply with the Expenditure and Payment Requirement, having met the deadline to expend the entire award within twenty-four (24) months. Context/cause: The County did not have adequate internal controls to ensure compliance with the requirement to obligate the 2021 ESG award within 180 days of HUD signing. Obligation of this entire award was not achieved until August 2022, approximately 360 days after HUD signing. Effect: The 2021 ESG award was not obligated within the required 180-day window. Questioned Costs: None. Recommendation: We recommend the County enhances internal controls to ensure compliance with all ESG program special test requirements.
Criteria: Emergency Solutions Grant (ESG) program guidance stipulates that within 180 days after the date that HUD signs the grant agreement (or a grant amendment for reallocation of funds) the recipient must obligate all of the grant amount, except the amount for its administrative costs. Condition: Internal controls should be in place to ensure the County is in compliance with all requirements of the federal award program. Due to numerous conditions stemming from the COVID-19 pandemic, including staffing, limited agency capacity, and agencies prioritizing the utilization of other funding sources, the County?s Community Development department, in charge of utilizing the ESG funding, was unable to completely obligate the 2021 ESG award by the deadline of February 7, 2022, instead ultimately locating agencies and subrecipients to utilize the entire award in August 2022. The County however did comply with the Expenditure and Payment Requirement, having met the deadline to expend the entire award within twenty-four (24) months. Context/cause: The County did not have adequate internal controls to ensure compliance with the requirement to obligate the 2021 ESG award within 180 days of HUD signing. Obligation of this entire award was not achieved until August 2022, approximately 360 days after HUD signing. Effect: The 2021 ESG award was not obligated within the required 180-day window. Questioned Costs: None. Recommendation: We recommend the County enhances internal controls to ensure compliance with all ESG program special test requirements.
Criteria: Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) requires that pass-through entities clearly identify to each subrecipient significant Federal subaward information, including identifying award numbers, subaward period dates and budget dates, Federal Assistance Listings number and Title, and appropriate terms and conditions concerning closeout of the subaward. Typically this requirement is satisfied by utilizing a subrecipient contract, reflecting all necessary information, and requiring execution showing acknowledgement of the terms by both parties. Condition: Internal controls should be in place to ensure the County is in compliance with all requirements of the federal award program. In place of utilizing a subrecipient contract, the County opted to attach a document of program information to its standard purchase order provided to each subrecipient engaged for the program. This document did not contain all of the information required by CFR ?200.332 to be clearly communicated to all subrecipients. Context/cause: The County did not have adequate internal controls to ensure compliance with subrecipient monitoring requirements. Testing was performed over each requirement for the County. Out of a total population of sixty (60) subrecipients, six (6) were selected for testing. For three (3) of the six (6) sampled subrecipients, the County did not clearly communicate all required subaward information. Examples of this omitted information include the date of the federal award, the subrecipient?s Unique Entity Identifier (UEI) or DUNS number, program title and assistance listing numbers, and federal award project description. Effect: Noncompliance at the subrecipient level may occur due to the subrecipient being unaware of all requirements. Questioned Costs: None. Recommendation: We recommend the County enhances internal controls to ensure compliance with subrecipient monitoring requirements.
Criteria: Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) requires that pass-through entities clearly identify to each subrecipient significant Federal subaward information, including identifying award numbers, subaward period dates and budget dates, Federal Assistance Listings number and Title, and appropriate terms and conditions concerning closeout of the subaward. Typically this requirement is satisfied by utilizing a subrecipient contract, reflecting all necessary information, and requiring execution showing acknowledgement of the terms by both parties. Condition: Internal controls should be in place to ensure the County is in compliance with all requirements of the federal award program. In place of utilizing a subrecipient contract, the County opted to attach a document of program information to its standard purchase order provided to each subrecipient engaged for the program. This document did not contain all of the information required by CFR ?200.332 to be clearly communicated to all subrecipients. Context/cause: The County did not have adequate internal controls to ensure compliance with subrecipient monitoring requirements. Testing was performed over each requirement for the County. Out of a total population of sixty (60) subrecipients, six (6) were selected for testing. For three (3) of the six (6) sampled subrecipients, the County did not clearly communicate all required subaward information. Examples of this omitted information include the date of the federal award, the subrecipient?s Unique Entity Identifier (UEI) or DUNS number, program title and assistance listing numbers, and federal award project description. Effect: Noncompliance at the subrecipient level may occur due to the subrecipient being unaware of all requirements. Questioned Costs: None. Recommendation: We recommend the County enhances internal controls to ensure compliance with subrecipient monitoring requirements.
Criteria: Internal controls should be in place to ensure that reporting requirements are met as specified in the guidance provided by the Treasury. Treasury guidance specified that the County was required to submit monthly reports, including data regarding households assisted and expenditures made, due the 15th of the month following the end of the month being reported. Also required were quarterly reports that included sections of data detailing amounts of expenditures as well as demographics of the population assisted. The Uniform Guidance requires any recipients of federal awards to comply with the reporting requirements indicated by the grantor agency. Condition: During our testing of reporting requirements, we noted the County did not complete and submit two (2) of the twelve (12) required monthly reports. Additionally, it was noted that inaccurate data regarding the County?s population was included on three (3) of the eight (8) quarterly reports. For the first quarter?s report, no population was reported; on the second report, six (6) million unique households were reported as having initial Emergency Rental Assistance Program assistance; and in the third quarter, over five (5) million unique households were reported as receiving initial assistance. The population of DeKalb County is less than one million people. Context/cause: The County did not have adequate internal controls to ensure compliance with reporting requirements. Testing was performed over each requirement for the County. All reports for the program were tested. No monthly reports were submitted for the ERA1 subaward for the months of January 2022 or February 2022, and three (3) quarterly reports for the ERA1 subaward included significant inaccurate data. Effect: Two (2) required monthly reports were not submitted and three (3) quarterly reports included inaccurate data due to inadequate controls over compliance with reporting requirements. Questioned Costs: None. Recommendation: We recommend the County enhances internal controls to ensure accuracy and compliance with reporting requirements.
Criteria: Internal controls should be in place to ensure that reporting requirements are met as specified in the guidance provided by the Treasury. Treasury guidance specified that the County was required to submit monthly reports, including data regarding households assisted and expenditures made, due the 15th of the month following the end of the month being reported. Also required were quarterly reports that included sections of data detailing amounts of expenditures as well as demographics of the population assisted. The Uniform Guidance requires any recipients of federal awards to comply with the reporting requirements indicated by the grantor agency. Condition: During our testing of reporting requirements, we noted the County did not complete and submit two (2) of the twelve (12) required monthly reports. Additionally, it was noted that inaccurate data regarding the County?s population was included on three (3) of the eight (8) quarterly reports. For the first quarter?s report, no population was reported; on the second report, six (6) million unique households were reported as having initial Emergency Rental Assistance Program assistance; and in the third quarter, over five (5) million unique households were reported as receiving initial assistance. The population of DeKalb County is less than one million people. Context/cause: The County did not have adequate internal controls to ensure compliance with reporting requirements. Testing was performed over each requirement for the County. All reports for the program were tested. No monthly reports were submitted for the ERA1 subaward for the months of January 2022 or February 2022, and three (3) quarterly reports for the ERA1 subaward included significant inaccurate data. Effect: Two (2) required monthly reports were not submitted and three (3) quarterly reports included inaccurate data due to inadequate controls over compliance with reporting requirements. Questioned Costs: None. Recommendation: We recommend the County enhances internal controls to ensure accuracy and compliance with reporting requirements.
Criteria: Internal controls should be in place to ensure that reporting requirements are met as specified in the guidance provided by the Treasury. Treasury guidance specified that the County was required to submit monthly reports, including data regarding households assisted and expenditures made, due the 15th of the month following the end of the month being reported. Also required were quarterly reports that included sections of data detailing amounts of expenditures as well as demographics of the population assisted. The Uniform Guidance requires any recipients of federal awards to comply with the reporting requirements indicated by the grantor agency. Condition: During our testing of reporting requirements, we noted the County did not complete and submit two (2) of the twelve (12) required monthly reports. Additionally, it was noted that inaccurate data regarding the County?s population was included on three (3) of the eight (8) quarterly reports. For the first quarter?s report, no population was reported; on the second report, six (6) million unique households were reported as having initial Emergency Rental Assistance Program assistance; and in the third quarter, over five (5) million unique households were reported as receiving initial assistance. The population of DeKalb County is less than one million people. Context/cause: The County did not have adequate internal controls to ensure compliance with reporting requirements. Testing was performed over each requirement for the County. All reports for the program were tested. No monthly reports were submitted for the ERA1 subaward for the months of January 2022 or February 2022, and three (3) quarterly reports for the ERA1 subaward included significant inaccurate data. Effect: Two (2) required monthly reports were not submitted and three (3) quarterly reports included inaccurate data due to inadequate controls over compliance with reporting requirements. Questioned Costs: None. Recommendation: We recommend the County enhances internal controls to ensure accuracy and compliance with reporting requirements.
Criteria: Internal controls should be in place to ensure that reporting requirements are met as specified in the guidance provided by the Treasury. Treasury guidance specified that the County was required to submit monthly reports, including data regarding households assisted and expenditures made, due the 15th of the month following the end of the month being reported. Also required were quarterly reports that included sections of data detailing amounts of expenditures as well as demographics of the population assisted. The Uniform Guidance requires any recipients of federal awards to comply with the reporting requirements indicated by the grantor agency. Condition: During our testing of reporting requirements, we noted the County did not complete and submit two (2) of the twelve (12) required monthly reports. Additionally, it was noted that inaccurate data regarding the County?s population was included on three (3) of the eight (8) quarterly reports. For the first quarter?s report, no population was reported; on the second report, six (6) million unique households were reported as having initial Emergency Rental Assistance Program assistance; and in the third quarter, over five (5) million unique households were reported as receiving initial assistance. The population of DeKalb County is less than one million people. Context/cause: The County did not have adequate internal controls to ensure compliance with reporting requirements. Testing was performed over each requirement for the County. All reports for the program were tested. No monthly reports were submitted for the ERA1 subaward for the months of January 2022 or February 2022, and three (3) quarterly reports for the ERA1 subaward included significant inaccurate data. Effect: Two (2) required monthly reports were not submitted and three (3) quarterly reports included inaccurate data due to inadequate controls over compliance with reporting requirements. Questioned Costs: None. Recommendation: We recommend the County enhances internal controls to ensure accuracy and compliance with reporting requirements.
Criteria: Internal controls should be in place to ensure that reporting requirements are met as specified in the guidance provided by the Treasury. Treasury guidance specified that the County was required to submit monthly reports, including data regarding households assisted and expenditures made, due the 15th of the month following the end of the month being reported. Also required were quarterly reports that included sections of data detailing amounts of expenditures as well as demographics of the population assisted. The Uniform Guidance requires any recipients of federal awards to comply with the reporting requirements indicated by the grantor agency. Condition: During our testing of reporting requirements, we noted the County did not complete and submit two (2) of the twelve (12) required monthly reports. Additionally, it was noted that inaccurate data regarding the County?s population was included on three (3) of the eight (8) quarterly reports. For the first quarter?s report, no population was reported; on the second report, six (6) million unique households were reported as having initial Emergency Rental Assistance Program assistance; and in the third quarter, over five (5) million unique households were reported as receiving initial assistance. The population of DeKalb County is less than one million people. Context/cause: The County did not have adequate internal controls to ensure compliance with reporting requirements. Testing was performed over each requirement for the County. All reports for the program were tested. No monthly reports were submitted for the ERA1 subaward for the months of January 2022 or February 2022, and three (3) quarterly reports for the ERA1 subaward included significant inaccurate data. Effect: Two (2) required monthly reports were not submitted and three (3) quarterly reports included inaccurate data due to inadequate controls over compliance with reporting requirements. Questioned Costs: None. Recommendation: We recommend the County enhances internal controls to ensure accuracy and compliance with reporting requirements.
Criteria: Internal controls should be in place to ensure that reporting requirements are met as specified in the guidance provided by the Treasury. Treasury guidance specified that the County was required to submit monthly reports, including data regarding households assisted and expenditures made, due the 15th of the month following the end of the month being reported. Also required were quarterly reports that included sections of data detailing amounts of expenditures as well as demographics of the population assisted. The Uniform Guidance requires any recipients of federal awards to comply with the reporting requirements indicated by the grantor agency. Condition: During our testing of reporting requirements, we noted the County did not complete and submit two (2) of the twelve (12) required monthly reports. Additionally, it was noted that inaccurate data regarding the County?s population was included on three (3) of the eight (8) quarterly reports. For the first quarter?s report, no population was reported; on the second report, six (6) million unique households were reported as having initial Emergency Rental Assistance Program assistance; and in the third quarter, over five (5) million unique households were reported as receiving initial assistance. The population of DeKalb County is less than one million people. Context/cause: The County did not have adequate internal controls to ensure compliance with reporting requirements. Testing was performed over each requirement for the County. All reports for the program were tested. No monthly reports were submitted for the ERA1 subaward for the months of January 2022 or February 2022, and three (3) quarterly reports for the ERA1 subaward included significant inaccurate data. Effect: Two (2) required monthly reports were not submitted and three (3) quarterly reports included inaccurate data due to inadequate controls over compliance with reporting requirements. Questioned Costs: None. Recommendation: We recommend the County enhances internal controls to ensure accuracy and compliance with reporting requirements.
Criteria: Emergency Solutions Grant (ESG) program guidance stipulates that within 180 days after the date that HUD signs the grant agreement (or a grant amendment for reallocation of funds) the recipient must obligate all of the grant amount, except the amount for its administrative costs. Condition: Internal controls should be in place to ensure the County is in compliance with all requirements of the federal award program. Due to numerous conditions stemming from the COVID-19 pandemic, including staffing, limited agency capacity, and agencies prioritizing the utilization of other funding sources, the County?s Community Development department, in charge of utilizing the ESG funding, was unable to completely obligate the 2021 ESG award by the deadline of February 7, 2022, instead ultimately locating agencies and subrecipients to utilize the entire award in August 2022. The County however did comply with the Expenditure and Payment Requirement, having met the deadline to expend the entire award within twenty-four (24) months. Context/cause: The County did not have adequate internal controls to ensure compliance with the requirement to obligate the 2021 ESG award within 180 days of HUD signing. Obligation of this entire award was not achieved until August 2022, approximately 360 days after HUD signing. Effect: The 2021 ESG award was not obligated within the required 180-day window. Questioned Costs: None. Recommendation: We recommend the County enhances internal controls to ensure compliance with all ESG program special test requirements.
Criteria: Emergency Solutions Grant (ESG) program guidance stipulates that within 180 days after the date that HUD signs the grant agreement (or a grant amendment for reallocation of funds) the recipient must obligate all of the grant amount, except the amount for its administrative costs. Condition: Internal controls should be in place to ensure the County is in compliance with all requirements of the federal award program. Due to numerous conditions stemming from the COVID-19 pandemic, including staffing, limited agency capacity, and agencies prioritizing the utilization of other funding sources, the County?s Community Development department, in charge of utilizing the ESG funding, was unable to completely obligate the 2021 ESG award by the deadline of February 7, 2022, instead ultimately locating agencies and subrecipients to utilize the entire award in August 2022. The County however did comply with the Expenditure and Payment Requirement, having met the deadline to expend the entire award within twenty-four (24) months. Context/cause: The County did not have adequate internal controls to ensure compliance with the requirement to obligate the 2021 ESG award within 180 days of HUD signing. Obligation of this entire award was not achieved until August 2022, approximately 360 days after HUD signing. Effect: The 2021 ESG award was not obligated within the required 180-day window. Questioned Costs: None. Recommendation: We recommend the County enhances internal controls to ensure compliance with all ESG program special test requirements.
Criteria: Emergency Solutions Grant (ESG) program guidance stipulates that within 180 days after the date that HUD signs the grant agreement (or a grant amendment for reallocation of funds) the recipient must obligate all of the grant amount, except the amount for its administrative costs. Condition: Internal controls should be in place to ensure the County is in compliance with all requirements of the federal award program. Due to numerous conditions stemming from the COVID-19 pandemic, including staffing, limited agency capacity, and agencies prioritizing the utilization of other funding sources, the County?s Community Development department, in charge of utilizing the ESG funding, was unable to completely obligate the 2021 ESG award by the deadline of February 7, 2022, instead ultimately locating agencies and subrecipients to utilize the entire award in August 2022. The County however did comply with the Expenditure and Payment Requirement, having met the deadline to expend the entire award within twenty-four (24) months. Context/cause: The County did not have adequate internal controls to ensure compliance with the requirement to obligate the 2021 ESG award within 180 days of HUD signing. Obligation of this entire award was not achieved until August 2022, approximately 360 days after HUD signing. Effect: The 2021 ESG award was not obligated within the required 180-day window. Questioned Costs: None. Recommendation: We recommend the County enhances internal controls to ensure compliance with all ESG program special test requirements.
Criteria: Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) requires that pass-through entities clearly identify to each subrecipient significant Federal subaward information, including identifying award numbers, subaward period dates and budget dates, Federal Assistance Listings number and Title, and appropriate terms and conditions concerning closeout of the subaward. Typically this requirement is satisfied by utilizing a subrecipient contract, reflecting all necessary information, and requiring execution showing acknowledgement of the terms by both parties. Condition: Internal controls should be in place to ensure the County is in compliance with all requirements of the federal award program. In place of utilizing a subrecipient contract, the County opted to attach a document of program information to its standard purchase order provided to each subrecipient engaged for the program. This document did not contain all of the information required by CFR ?200.332 to be clearly communicated to all subrecipients. Context/cause: The County did not have adequate internal controls to ensure compliance with subrecipient monitoring requirements. Testing was performed over each requirement for the County. Out of a total population of sixty (60) subrecipients, six (6) were selected for testing. For three (3) of the six (6) sampled subrecipients, the County did not clearly communicate all required subaward information. Examples of this omitted information include the date of the federal award, the subrecipient?s Unique Entity Identifier (UEI) or DUNS number, program title and assistance listing numbers, and federal award project description. Effect: Noncompliance at the subrecipient level may occur due to the subrecipient being unaware of all requirements. Questioned Costs: None. Recommendation: We recommend the County enhances internal controls to ensure compliance with subrecipient monitoring requirements.
Criteria: Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) requires that pass-through entities clearly identify to each subrecipient significant Federal subaward information, including identifying award numbers, subaward period dates and budget dates, Federal Assistance Listings number and Title, and appropriate terms and conditions concerning closeout of the subaward. Typically this requirement is satisfied by utilizing a subrecipient contract, reflecting all necessary information, and requiring execution showing acknowledgement of the terms by both parties. Condition: Internal controls should be in place to ensure the County is in compliance with all requirements of the federal award program. In place of utilizing a subrecipient contract, the County opted to attach a document of program information to its standard purchase order provided to each subrecipient engaged for the program. This document did not contain all of the information required by CFR ?200.332 to be clearly communicated to all subrecipients. Context/cause: The County did not have adequate internal controls to ensure compliance with subrecipient monitoring requirements. Testing was performed over each requirement for the County. Out of a total population of sixty (60) subrecipients, six (6) were selected for testing. For three (3) of the six (6) sampled subrecipients, the County did not clearly communicate all required subaward information. Examples of this omitted information include the date of the federal award, the subrecipient?s Unique Entity Identifier (UEI) or DUNS number, program title and assistance listing numbers, and federal award project description. Effect: Noncompliance at the subrecipient level may occur due to the subrecipient being unaware of all requirements. Questioned Costs: None. Recommendation: We recommend the County enhances internal controls to ensure compliance with subrecipient monitoring requirements.
Criteria: Internal controls should be in place to ensure that reporting requirements are met as specified in the guidance provided by the Treasury. Treasury guidance specified that the County was required to submit monthly reports, including data regarding households assisted and expenditures made, due the 15th of the month following the end of the month being reported. Also required were quarterly reports that included sections of data detailing amounts of expenditures as well as demographics of the population assisted. The Uniform Guidance requires any recipients of federal awards to comply with the reporting requirements indicated by the grantor agency. Condition: During our testing of reporting requirements, we noted the County did not complete and submit two (2) of the twelve (12) required monthly reports. Additionally, it was noted that inaccurate data regarding the County?s population was included on three (3) of the eight (8) quarterly reports. For the first quarter?s report, no population was reported; on the second report, six (6) million unique households were reported as having initial Emergency Rental Assistance Program assistance; and in the third quarter, over five (5) million unique households were reported as receiving initial assistance. The population of DeKalb County is less than one million people. Context/cause: The County did not have adequate internal controls to ensure compliance with reporting requirements. Testing was performed over each requirement for the County. All reports for the program were tested. No monthly reports were submitted for the ERA1 subaward for the months of January 2022 or February 2022, and three (3) quarterly reports for the ERA1 subaward included significant inaccurate data. Effect: Two (2) required monthly reports were not submitted and three (3) quarterly reports included inaccurate data due to inadequate controls over compliance with reporting requirements. Questioned Costs: None. Recommendation: We recommend the County enhances internal controls to ensure accuracy and compliance with reporting requirements.
Criteria: Internal controls should be in place to ensure that reporting requirements are met as specified in the guidance provided by the Treasury. Treasury guidance specified that the County was required to submit monthly reports, including data regarding households assisted and expenditures made, due the 15th of the month following the end of the month being reported. Also required were quarterly reports that included sections of data detailing amounts of expenditures as well as demographics of the population assisted. The Uniform Guidance requires any recipients of federal awards to comply with the reporting requirements indicated by the grantor agency. Condition: During our testing of reporting requirements, we noted the County did not complete and submit two (2) of the twelve (12) required monthly reports. Additionally, it was noted that inaccurate data regarding the County?s population was included on three (3) of the eight (8) quarterly reports. For the first quarter?s report, no population was reported; on the second report, six (6) million unique households were reported as having initial Emergency Rental Assistance Program assistance; and in the third quarter, over five (5) million unique households were reported as receiving initial assistance. The population of DeKalb County is less than one million people. Context/cause: The County did not have adequate internal controls to ensure compliance with reporting requirements. Testing was performed over each requirement for the County. All reports for the program were tested. No monthly reports were submitted for the ERA1 subaward for the months of January 2022 or February 2022, and three (3) quarterly reports for the ERA1 subaward included significant inaccurate data. Effect: Two (2) required monthly reports were not submitted and three (3) quarterly reports included inaccurate data due to inadequate controls over compliance with reporting requirements. Questioned Costs: None. Recommendation: We recommend the County enhances internal controls to ensure accuracy and compliance with reporting requirements.
Criteria: Internal controls should be in place to ensure that reporting requirements are met as specified in the guidance provided by the Treasury. Treasury guidance specified that the County was required to submit monthly reports, including data regarding households assisted and expenditures made, due the 15th of the month following the end of the month being reported. Also required were quarterly reports that included sections of data detailing amounts of expenditures as well as demographics of the population assisted. The Uniform Guidance requires any recipients of federal awards to comply with the reporting requirements indicated by the grantor agency. Condition: During our testing of reporting requirements, we noted the County did not complete and submit two (2) of the twelve (12) required monthly reports. Additionally, it was noted that inaccurate data regarding the County?s population was included on three (3) of the eight (8) quarterly reports. For the first quarter?s report, no population was reported; on the second report, six (6) million unique households were reported as having initial Emergency Rental Assistance Program assistance; and in the third quarter, over five (5) million unique households were reported as receiving initial assistance. The population of DeKalb County is less than one million people. Context/cause: The County did not have adequate internal controls to ensure compliance with reporting requirements. Testing was performed over each requirement for the County. All reports for the program were tested. No monthly reports were submitted for the ERA1 subaward for the months of January 2022 or February 2022, and three (3) quarterly reports for the ERA1 subaward included significant inaccurate data. Effect: Two (2) required monthly reports were not submitted and three (3) quarterly reports included inaccurate data due to inadequate controls over compliance with reporting requirements. Questioned Costs: None. Recommendation: We recommend the County enhances internal controls to ensure accuracy and compliance with reporting requirements.
Criteria: Internal controls should be in place to ensure that reporting requirements are met as specified in the guidance provided by the Treasury. Treasury guidance specified that the County was required to submit monthly reports, including data regarding households assisted and expenditures made, due the 15th of the month following the end of the month being reported. Also required were quarterly reports that included sections of data detailing amounts of expenditures as well as demographics of the population assisted. The Uniform Guidance requires any recipients of federal awards to comply with the reporting requirements indicated by the grantor agency. Condition: During our testing of reporting requirements, we noted the County did not complete and submit two (2) of the twelve (12) required monthly reports. Additionally, it was noted that inaccurate data regarding the County?s population was included on three (3) of the eight (8) quarterly reports. For the first quarter?s report, no population was reported; on the second report, six (6) million unique households were reported as having initial Emergency Rental Assistance Program assistance; and in the third quarter, over five (5) million unique households were reported as receiving initial assistance. The population of DeKalb County is less than one million people. Context/cause: The County did not have adequate internal controls to ensure compliance with reporting requirements. Testing was performed over each requirement for the County. All reports for the program were tested. No monthly reports were submitted for the ERA1 subaward for the months of January 2022 or February 2022, and three (3) quarterly reports for the ERA1 subaward included significant inaccurate data. Effect: Two (2) required monthly reports were not submitted and three (3) quarterly reports included inaccurate data due to inadequate controls over compliance with reporting requirements. Questioned Costs: None. Recommendation: We recommend the County enhances internal controls to ensure accuracy and compliance with reporting requirements.
Criteria: Internal controls should be in place to ensure that reporting requirements are met as specified in the guidance provided by the Treasury. Treasury guidance specified that the County was required to submit monthly reports, including data regarding households assisted and expenditures made, due the 15th of the month following the end of the month being reported. Also required were quarterly reports that included sections of data detailing amounts of expenditures as well as demographics of the population assisted. The Uniform Guidance requires any recipients of federal awards to comply with the reporting requirements indicated by the grantor agency. Condition: During our testing of reporting requirements, we noted the County did not complete and submit two (2) of the twelve (12) required monthly reports. Additionally, it was noted that inaccurate data regarding the County?s population was included on three (3) of the eight (8) quarterly reports. For the first quarter?s report, no population was reported; on the second report, six (6) million unique households were reported as having initial Emergency Rental Assistance Program assistance; and in the third quarter, over five (5) million unique households were reported as receiving initial assistance. The population of DeKalb County is less than one million people. Context/cause: The County did not have adequate internal controls to ensure compliance with reporting requirements. Testing was performed over each requirement for the County. All reports for the program were tested. No monthly reports were submitted for the ERA1 subaward for the months of January 2022 or February 2022, and three (3) quarterly reports for the ERA1 subaward included significant inaccurate data. Effect: Two (2) required monthly reports were not submitted and three (3) quarterly reports included inaccurate data due to inadequate controls over compliance with reporting requirements. Questioned Costs: None. Recommendation: We recommend the County enhances internal controls to ensure accuracy and compliance with reporting requirements.
Criteria: Internal controls should be in place to ensure that reporting requirements are met as specified in the guidance provided by the Treasury. Treasury guidance specified that the County was required to submit monthly reports, including data regarding households assisted and expenditures made, due the 15th of the month following the end of the month being reported. Also required were quarterly reports that included sections of data detailing amounts of expenditures as well as demographics of the population assisted. The Uniform Guidance requires any recipients of federal awards to comply with the reporting requirements indicated by the grantor agency. Condition: During our testing of reporting requirements, we noted the County did not complete and submit two (2) of the twelve (12) required monthly reports. Additionally, it was noted that inaccurate data regarding the County?s population was included on three (3) of the eight (8) quarterly reports. For the first quarter?s report, no population was reported; on the second report, six (6) million unique households were reported as having initial Emergency Rental Assistance Program assistance; and in the third quarter, over five (5) million unique households were reported as receiving initial assistance. The population of DeKalb County is less than one million people. Context/cause: The County did not have adequate internal controls to ensure compliance with reporting requirements. Testing was performed over each requirement for the County. All reports for the program were tested. No monthly reports were submitted for the ERA1 subaward for the months of January 2022 or February 2022, and three (3) quarterly reports for the ERA1 subaward included significant inaccurate data. Effect: Two (2) required monthly reports were not submitted and three (3) quarterly reports included inaccurate data due to inadequate controls over compliance with reporting requirements. Questioned Costs: None. Recommendation: We recommend the County enhances internal controls to ensure accuracy and compliance with reporting requirements.