Audit 18840

FY End
2022-06-30
Total Expended
$73.87M
Findings
8
Programs
29
Organization: New Castle County, Delaware (DE)
Year: 2022 Accepted: 2023-03-30

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
15704 2022-004 Material Weakness - L
15705 2022-004 Material Weakness - L
15706 2022-003 Material Weakness - L
15707 2022-003 Material Weakness - L
592146 2022-004 Material Weakness - L
592147 2022-004 Material Weakness - L
592148 2022-003 Material Weakness - L
592149 2022-003 Material Weakness - L

Programs

ALN Program Spent Major Findings
21.019 Coronavirus Relief Fund $30.69M - 0
14.871 Section 8 Housing Choice Vouchers $16.63M - 0
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $7.31M Yes 0
14.239 Home Investment Partnerships Program $1.15M - 0
66.458 Capitalization Grants for Clean Water State Revolving Funds $1.09M - 0
14.231 Emergency Solutions Grant Program $979,601 - 0
97.042 Emergency Management Performance Grants $396,568 - 0
14.900 Lead-Based Paint Hazard Control in Privately-Owned Housing $350,284 - 0
16.034 Coronavirus Emergency Supplemental Funding Program $257,294 - 0
16.745 Criminal and Juvenile Justice and Mental Health Collaboration Program $198,765 - 0
16.575 Crime Victim Assistance $152,288 - 0
97.067 Homeland Security Grant Program $147,805 - 0
45.310 Grants to States $144,595 - 0
16.738 Edward Byrne Memorial Justice Assistance Grant Program $138,793 - 0
14.256 Neighborhood Stabilization Program Arra $125,166 - 0
16.710 Public Safety Partnership and Community Policing Grants $115,196 - 0
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $98,018 - 0
21.023 Emergency Rental Assistance Program $83,394 - 0
21.027 Coronavirus State and Local Fiscal Recovery Funds $75,000 Yes 1
14.228 Community Development Block Grants/state's Program and Non-Entitlement Grants in Hawaii $69,034 - 0
16.838 Comprehensive Opioid Abuse Site-Based Program $50,692 - 0
14.218 Community Development Block Grants/entitlement Grants $26,182 Yes 1
20.600 State and Community Highway Safety $24,533 - 0
16.922 Equitable Sharing Program $13,409 - 0
14.913 Healthy Homes Production Program $11,443 - 0
20.607 Alcohol Open Container Requirements $7,693 - 0
20.616 National Priority Safety Programs $7,388 - 0
97.047 Pre-Disaster Mitigation $656 - 0
45.312 National Leadership Grants $42 - 0

Contacts

Name Title Type
YT6XTK6YAMC1 Karen Wallace Auditee
3023955165 Remi Omisore Auditor
No contacts on file

Notes to SEFA

Title: Reclass of Prior Year Expenditures Accounting Policies: The accompanying schedule of expenditures of federal awards includes Federal grant activity of New Castle County, Delaware and is presented on the modified accrual basis of accounting. Matching funds are excluded from the schedule and the Program Income generated from Federal Grants is classified as Federal Expenditures when spent. The information on this schedule is presented in accordance with Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards. Some amounts presented in this schedule may differ from amounts presented in, or used in the preparation of, the basic financial statements. Expenditures reported on the Schedule are reported on the modified accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance for all awards with the exception of Assistance Listing Number 21.019, which follows criteria determined by the Department of Treasury for allowability of costs. Under these principles, certain types of expenditures are not allowable or are limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. Disaster Grants Public Assistance ALN 97.036: After a Presidential-Declared Disaster, FEMA provides a Public Assistance Grant to reimburse eligible costs. For the year ended June 30, 2022, $7,307,911 of approved eligible expenditures that were incurred in a prior year are included on the Schedule.
Title: Loans Outstanding Accounting Policies: The accompanying schedule of expenditures of federal awards includes Federal grant activity of New Castle County, Delaware and is presented on the modified accrual basis of accounting. Matching funds are excluded from the schedule and the Program Income generated from Federal Grants is classified as Federal Expenditures when spent. The information on this schedule is presented in accordance with Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards. Some amounts presented in this schedule may differ from amounts presented in, or used in the preparation of, the basic financial statements. Expenditures reported on the Schedule are reported on the modified accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance for all awards with the exception of Assistance Listing Number 21.019, which follows criteria determined by the Department of Treasury for allowability of costs. Under these principles, certain types of expenditures are not allowable or are limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. New Castle County, Delaware administers low-income housing loan programs under the Community Development Block Grant and Home Investment Partnership Program, and Neighborhood Stabilization Program. The County had the following loan balances outstanding at June 30, 2022: Community Development Block Grants/Entitlement Grants14.218 $9,600,049 HOME Investment Partnerships Program 14.239 $4,453,883 NSP Grants G40400099,G40400100 and G4040010 14.218,14.256,14.228 $693,369
Title: Unexpended balance of loans available from CW State Revolving Fund Accounting Policies: The accompanying schedule of expenditures of federal awards includes Federal grant activity of New Castle County, Delaware and is presented on the modified accrual basis of accounting. Matching funds are excluded from the schedule and the Program Income generated from Federal Grants is classified as Federal Expenditures when spent. The information on this schedule is presented in accordance with Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards. Some amounts presented in this schedule may differ from amounts presented in, or used in the preparation of, the basic financial statements. Expenditures reported on the Schedule are reported on the modified accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance for all awards with the exception of Assistance Listing Number 21.019, which follows criteria determined by the Department of Treasury for allowability of costs. Under these principles, certain types of expenditures are not allowable or are limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. ARRA Clean Water State Revolving Fund 66.458 $4,983,131

Finding Details

2022 ? 004 Federal Agency: U.S. Department of Housing and Urban Development Federal Program: Community Development Block Grant/Entitlement Grants Assistance Listing Number: 14.218 Award Period: June 23, 2009 through September 1, 2028 Compliance Requirement: Reporting ? Federal Funding Accountability and Transparency Act (FFATA) Type of Finding: Material Weakness in Internal Control Over Compliance, Material Noncompliance Criteria or specific requirement: Compliance: Per the Federal Funding Accountability and Transparency Act (FFATA), prime (direct) recipients of grants or cooperative agreements are required to report first-tier subawards of $30,000 or more to the Federal Funding Accountability and Transparency Act Subaward Reporting System (FSRS). Reports must be filed in FSRS by the end of the month following the month in which the prime recipient awards any sub-grant greater than or equal to $30,000. If the initial award is below $30,000 but subsequent grant modifications result in a total award equal to or over $30,000, the award will be subject to the reporting requirements as of the date the award exceeds $30,000. If the initial award equals or exceeds $30,000 but funding is subsequently de-obligated such that the total award amount falls below $30,000, the award continues to be subject to FFATA reporting requirements. The following key data elements must be reported: Subawardee Name and Data Universal Numbering System (DUNS) number; Amount of Subaward (inclusive of modifications); Subaward Obligation/Action Date; Date of Report Submission; Subaward Number; Project Description; and Names and Compensation of Highly Compensated Officers. (Names and Compensation of Highly Compensated Officers must only be reported when the entity in the preceding fiscal year received 80 percent or more of its annual gross revenues in Federal awards; and $30,000,000 or more in annual gross revenues from Federal awards; and the public does not have access to this information about the compensation of the senior executives of the entity through periodic reports filed under section 13(a) or 15(d) of the Securities Exchange Act of 1934 (15 U.S.C. ?? 78m(a), 78o(d)) or section 6104 of the Internal Revenue Code of 1986.) Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in ?Standards for Internal Control in the Federal Government? issued by the Comptroller General of the United States or the ?Internal Control Integrated Framework?, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: The County did not report required subaward information to FSRS for first-tier subawards of $30,000 or more. Context: Zero of two subawards selected for testing were reported to FSRS. Total subawards tested were $1,090,268, and $0 was reported as required by FFATA requirements. See Schedule of Findings and Questioned Costs for chart/table Questioned costs: None noted. Cause: The County?s policies and procedures were not sufficient to ensure that required subaward information was reported to FSRS. Internal controls did not prevent or detect the errors. Effect: Subawards were not reported to FSRS in accordance with FFATA requirements. Recommendation: We recommend that the County develop internal controls and procedures to ensure that FFATA reporting requirements are met. We further recommend the County develop controls and procedures to ensure that all required subawards are reported accurately and timely to FSRS. Views of responsible officials: Management agrees with the finding. The Department of Community Services is developing internal controls to ensure that FFATA reporting requirements are met. A system has been created to ensure all required sub-awards are reported accurately and timely in the Federal Funding Accountability and Transparency Act Subaward Reporting System (FSRS). See Corrective Action Plan for details.
2022 ? 004 Federal Agency: U.S. Department of Housing and Urban Development Federal Program: Community Development Block Grant/Entitlement Grants Assistance Listing Number: 14.218 Award Period: June 23, 2009 through September 1, 2028 Compliance Requirement: Reporting ? Federal Funding Accountability and Transparency Act (FFATA) Type of Finding: Material Weakness in Internal Control Over Compliance, Material Noncompliance Criteria or specific requirement: Compliance: Per the Federal Funding Accountability and Transparency Act (FFATA), prime (direct) recipients of grants or cooperative agreements are required to report first-tier subawards of $30,000 or more to the Federal Funding Accountability and Transparency Act Subaward Reporting System (FSRS). Reports must be filed in FSRS by the end of the month following the month in which the prime recipient awards any sub-grant greater than or equal to $30,000. If the initial award is below $30,000 but subsequent grant modifications result in a total award equal to or over $30,000, the award will be subject to the reporting requirements as of the date the award exceeds $30,000. If the initial award equals or exceeds $30,000 but funding is subsequently de-obligated such that the total award amount falls below $30,000, the award continues to be subject to FFATA reporting requirements. The following key data elements must be reported: Subawardee Name and Data Universal Numbering System (DUNS) number; Amount of Subaward (inclusive of modifications); Subaward Obligation/Action Date; Date of Report Submission; Subaward Number; Project Description; and Names and Compensation of Highly Compensated Officers. (Names and Compensation of Highly Compensated Officers must only be reported when the entity in the preceding fiscal year received 80 percent or more of its annual gross revenues in Federal awards; and $30,000,000 or more in annual gross revenues from Federal awards; and the public does not have access to this information about the compensation of the senior executives of the entity through periodic reports filed under section 13(a) or 15(d) of the Securities Exchange Act of 1934 (15 U.S.C. ?? 78m(a), 78o(d)) or section 6104 of the Internal Revenue Code of 1986.) Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in ?Standards for Internal Control in the Federal Government? issued by the Comptroller General of the United States or the ?Internal Control Integrated Framework?, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: The County did not report required subaward information to FSRS for first-tier subawards of $30,000 or more. Context: Zero of two subawards selected for testing were reported to FSRS. Total subawards tested were $1,090,268, and $0 was reported as required by FFATA requirements. See Schedule of Findings and Questioned Costs for chart/table Questioned costs: None noted. Cause: The County?s policies and procedures were not sufficient to ensure that required subaward information was reported to FSRS. Internal controls did not prevent or detect the errors. Effect: Subawards were not reported to FSRS in accordance with FFATA requirements. Recommendation: We recommend that the County develop internal controls and procedures to ensure that FFATA reporting requirements are met. We further recommend the County develop controls and procedures to ensure that all required subawards are reported accurately and timely to FSRS. Views of responsible officials: Management agrees with the finding. The Department of Community Services is developing internal controls to ensure that FFATA reporting requirements are met. A system has been created to ensure all required sub-awards are reported accurately and timely in the Federal Funding Accountability and Transparency Act Subaward Reporting System (FSRS). See Corrective Action Plan for details.
2022 ? 003 Federal Agency: U.S. Department of the Treasury Federal Program: COVID-19 ? Coronavirus State and Local Fiscal Recovery Funds Assistance Listing Number: 21.027 Award Period: March 3, 2021 ? December 31, 2024, liquidated by December 31, 2026 Compliance Requirement: Reporting Type of Finding: Material Weakness in Internal Control Over Compliance, Material Noncompliance Criteria or specific requirement: Compliance: Reporting requirements for Coronavirus State and Local Fiscal Recovery Funds includes the following: Project and Expenditure Reports: Each recipient is required to report obligations and expenditures by project according to its corresponding Expenditure Category. The Project and Expenditure Report provides information on projects funded, expenditures, and contracts and subawards greater than or equal to $50,000, and other information required from recipients. For purposes of reporting in the SLFRF portal, an obligation is an order placed for property and services, contracts and subawards made, and similar transactions that require payment. An expenditure is the amount that has been incurred as a liability of the entity (the service has been rendered or the good has been delivered to the entity). An initial quarterly Project and Expenditure Report covered three calendar quarters from March 3, 2021 to December 31, 2021 and was required to be submitted to Treasury by January 31, 2022. Subsequent quarterly reports cover one calendar quarter and are required to be submitted to Treasury by the last day of the month following the end of the period covered. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in ?Standards for Internal Control in the Federal Government? issued by the Comptroller General of the United States or the ?Internal Control Integrated Framework?, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: The supporting documentation did not agree with amounts reported for obligations, expenditures and subawards on the Project and Expenditure Reports. Context: The following reports were selected for testing: 1) Project and Expenditure Reports for the 3/31/2022 and 6/30/2022 quarters: From these reports, 17 projects were selected for testing obligations and expenditures, 2 subawards greater than $50,000 and 11 subawards less than $50,000 were selected. The following exceptions were noted: 1) Project and Expenditure Reports: o Obligations: For 8 of 17 projects reported, obligations did not agree to supporting documentation. Additionally, 3 projects were included in the supporting documentation that were not reported. o Expenditures ? For 3 of 17 projects reported, expenditures did not agree to supporting documentation. Additionally, 3 projects were included in the supporting documentation that were not reported. o Subawards greater than $50,000: For 1 of 2 subawards greater than $50,000, reported obligations did not match supporting documentation. o Subawards less than $50,000: For 6 of 11 subawards, reported obligations did not match supporting documentation. Questioned costs: Undetermined. Cause: Internal Controls were not operating effectively to ensure that Project and Expenditure Reports were submitted accurately. Effect: Obligations, expenditures, and subaward information reported to Treasury did not agree to supporting documentation. Recommendation: The County should enhance its procedures and internal controls regarding preparation of the Project and Expenditure Reports to ensure that information reported is accurate and agrees to supporting documentation. Views of responsible officials: Management agrees with the finding. New Castle County self-reported the variances in expenditures and obligations due to accruals of costs to previously reported quarters. Such variances can be common with just-in-time reporting. Regarding the omitted projects, the Reporting Portal has undergone several updates throughout the period of performance. These updates contributed to confusion in required data for projects. The omitted projects were included in the subsequent reports after the data points were known and tracked. Regarding the reporting of project obligations, Treasury?s definition of obligation is very broad, and FAQ 13.17 allows the recipient to use its discretion to determine when an obligation is incurred. Such discretion calls for the interpretation of several source documents. In each report total obligations were not less than total expenditures nor did total obligations exceed available funding.
2022 ? 003 Federal Agency: U.S. Department of the Treasury Federal Program: COVID-19 ? Coronavirus State and Local Fiscal Recovery Funds Assistance Listing Number: 21.027 Award Period: March 3, 2021 ? December 31, 2024, liquidated by December 31, 2026 Compliance Requirement: Reporting Type of Finding: Material Weakness in Internal Control Over Compliance, Material Noncompliance Criteria or specific requirement: Compliance: Reporting requirements for Coronavirus State and Local Fiscal Recovery Funds includes the following: Project and Expenditure Reports: Each recipient is required to report obligations and expenditures by project according to its corresponding Expenditure Category. The Project and Expenditure Report provides information on projects funded, expenditures, and contracts and subawards greater than or equal to $50,000, and other information required from recipients. For purposes of reporting in the SLFRF portal, an obligation is an order placed for property and services, contracts and subawards made, and similar transactions that require payment. An expenditure is the amount that has been incurred as a liability of the entity (the service has been rendered or the good has been delivered to the entity). An initial quarterly Project and Expenditure Report covered three calendar quarters from March 3, 2021 to December 31, 2021 and was required to be submitted to Treasury by January 31, 2022. Subsequent quarterly reports cover one calendar quarter and are required to be submitted to Treasury by the last day of the month following the end of the period covered. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in ?Standards for Internal Control in the Federal Government? issued by the Comptroller General of the United States or the ?Internal Control Integrated Framework?, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: The supporting documentation did not agree with amounts reported for obligations, expenditures and subawards on the Project and Expenditure Reports. Context: The following reports were selected for testing: 1) Project and Expenditure Reports for the 3/31/2022 and 6/30/2022 quarters: From these reports, 17 projects were selected for testing obligations and expenditures, 2 subawards greater than $50,000 and 11 subawards less than $50,000 were selected. The following exceptions were noted: 1) Project and Expenditure Reports: o Obligations: For 8 of 17 projects reported, obligations did not agree to supporting documentation. Additionally, 3 projects were included in the supporting documentation that were not reported. o Expenditures ? For 3 of 17 projects reported, expenditures did not agree to supporting documentation. Additionally, 3 projects were included in the supporting documentation that were not reported. o Subawards greater than $50,000: For 1 of 2 subawards greater than $50,000, reported obligations did not match supporting documentation. o Subawards less than $50,000: For 6 of 11 subawards, reported obligations did not match supporting documentation. Questioned costs: Undetermined. Cause: Internal Controls were not operating effectively to ensure that Project and Expenditure Reports were submitted accurately. Effect: Obligations, expenditures, and subaward information reported to Treasury did not agree to supporting documentation. Recommendation: The County should enhance its procedures and internal controls regarding preparation of the Project and Expenditure Reports to ensure that information reported is accurate and agrees to supporting documentation. Views of responsible officials: Management agrees with the finding. New Castle County self-reported the variances in expenditures and obligations due to accruals of costs to previously reported quarters. Such variances can be common with just-in-time reporting. Regarding the omitted projects, the Reporting Portal has undergone several updates throughout the period of performance. These updates contributed to confusion in required data for projects. The omitted projects were included in the subsequent reports after the data points were known and tracked. Regarding the reporting of project obligations, Treasury?s definition of obligation is very broad, and FAQ 13.17 allows the recipient to use its discretion to determine when an obligation is incurred. Such discretion calls for the interpretation of several source documents. In each report total obligations were not less than total expenditures nor did total obligations exceed available funding.
2022 ? 004 Federal Agency: U.S. Department of Housing and Urban Development Federal Program: Community Development Block Grant/Entitlement Grants Assistance Listing Number: 14.218 Award Period: June 23, 2009 through September 1, 2028 Compliance Requirement: Reporting ? Federal Funding Accountability and Transparency Act (FFATA) Type of Finding: Material Weakness in Internal Control Over Compliance, Material Noncompliance Criteria or specific requirement: Compliance: Per the Federal Funding Accountability and Transparency Act (FFATA), prime (direct) recipients of grants or cooperative agreements are required to report first-tier subawards of $30,000 or more to the Federal Funding Accountability and Transparency Act Subaward Reporting System (FSRS). Reports must be filed in FSRS by the end of the month following the month in which the prime recipient awards any sub-grant greater than or equal to $30,000. If the initial award is below $30,000 but subsequent grant modifications result in a total award equal to or over $30,000, the award will be subject to the reporting requirements as of the date the award exceeds $30,000. If the initial award equals or exceeds $30,000 but funding is subsequently de-obligated such that the total award amount falls below $30,000, the award continues to be subject to FFATA reporting requirements. The following key data elements must be reported: Subawardee Name and Data Universal Numbering System (DUNS) number; Amount of Subaward (inclusive of modifications); Subaward Obligation/Action Date; Date of Report Submission; Subaward Number; Project Description; and Names and Compensation of Highly Compensated Officers. (Names and Compensation of Highly Compensated Officers must only be reported when the entity in the preceding fiscal year received 80 percent or more of its annual gross revenues in Federal awards; and $30,000,000 or more in annual gross revenues from Federal awards; and the public does not have access to this information about the compensation of the senior executives of the entity through periodic reports filed under section 13(a) or 15(d) of the Securities Exchange Act of 1934 (15 U.S.C. ?? 78m(a), 78o(d)) or section 6104 of the Internal Revenue Code of 1986.) Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in ?Standards for Internal Control in the Federal Government? issued by the Comptroller General of the United States or the ?Internal Control Integrated Framework?, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: The County did not report required subaward information to FSRS for first-tier subawards of $30,000 or more. Context: Zero of two subawards selected for testing were reported to FSRS. Total subawards tested were $1,090,268, and $0 was reported as required by FFATA requirements. See Schedule of Findings and Questioned Costs for chart/table Questioned costs: None noted. Cause: The County?s policies and procedures were not sufficient to ensure that required subaward information was reported to FSRS. Internal controls did not prevent or detect the errors. Effect: Subawards were not reported to FSRS in accordance with FFATA requirements. Recommendation: We recommend that the County develop internal controls and procedures to ensure that FFATA reporting requirements are met. We further recommend the County develop controls and procedures to ensure that all required subawards are reported accurately and timely to FSRS. Views of responsible officials: Management agrees with the finding. The Department of Community Services is developing internal controls to ensure that FFATA reporting requirements are met. A system has been created to ensure all required sub-awards are reported accurately and timely in the Federal Funding Accountability and Transparency Act Subaward Reporting System (FSRS). See Corrective Action Plan for details.
2022 ? 004 Federal Agency: U.S. Department of Housing and Urban Development Federal Program: Community Development Block Grant/Entitlement Grants Assistance Listing Number: 14.218 Award Period: June 23, 2009 through September 1, 2028 Compliance Requirement: Reporting ? Federal Funding Accountability and Transparency Act (FFATA) Type of Finding: Material Weakness in Internal Control Over Compliance, Material Noncompliance Criteria or specific requirement: Compliance: Per the Federal Funding Accountability and Transparency Act (FFATA), prime (direct) recipients of grants or cooperative agreements are required to report first-tier subawards of $30,000 or more to the Federal Funding Accountability and Transparency Act Subaward Reporting System (FSRS). Reports must be filed in FSRS by the end of the month following the month in which the prime recipient awards any sub-grant greater than or equal to $30,000. If the initial award is below $30,000 but subsequent grant modifications result in a total award equal to or over $30,000, the award will be subject to the reporting requirements as of the date the award exceeds $30,000. If the initial award equals or exceeds $30,000 but funding is subsequently de-obligated such that the total award amount falls below $30,000, the award continues to be subject to FFATA reporting requirements. The following key data elements must be reported: Subawardee Name and Data Universal Numbering System (DUNS) number; Amount of Subaward (inclusive of modifications); Subaward Obligation/Action Date; Date of Report Submission; Subaward Number; Project Description; and Names and Compensation of Highly Compensated Officers. (Names and Compensation of Highly Compensated Officers must only be reported when the entity in the preceding fiscal year received 80 percent or more of its annual gross revenues in Federal awards; and $30,000,000 or more in annual gross revenues from Federal awards; and the public does not have access to this information about the compensation of the senior executives of the entity through periodic reports filed under section 13(a) or 15(d) of the Securities Exchange Act of 1934 (15 U.S.C. ?? 78m(a), 78o(d)) or section 6104 of the Internal Revenue Code of 1986.) Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in ?Standards for Internal Control in the Federal Government? issued by the Comptroller General of the United States or the ?Internal Control Integrated Framework?, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: The County did not report required subaward information to FSRS for first-tier subawards of $30,000 or more. Context: Zero of two subawards selected for testing were reported to FSRS. Total subawards tested were $1,090,268, and $0 was reported as required by FFATA requirements. See Schedule of Findings and Questioned Costs for chart/table Questioned costs: None noted. Cause: The County?s policies and procedures were not sufficient to ensure that required subaward information was reported to FSRS. Internal controls did not prevent or detect the errors. Effect: Subawards were not reported to FSRS in accordance with FFATA requirements. Recommendation: We recommend that the County develop internal controls and procedures to ensure that FFATA reporting requirements are met. We further recommend the County develop controls and procedures to ensure that all required subawards are reported accurately and timely to FSRS. Views of responsible officials: Management agrees with the finding. The Department of Community Services is developing internal controls to ensure that FFATA reporting requirements are met. A system has been created to ensure all required sub-awards are reported accurately and timely in the Federal Funding Accountability and Transparency Act Subaward Reporting System (FSRS). See Corrective Action Plan for details.
2022 ? 003 Federal Agency: U.S. Department of the Treasury Federal Program: COVID-19 ? Coronavirus State and Local Fiscal Recovery Funds Assistance Listing Number: 21.027 Award Period: March 3, 2021 ? December 31, 2024, liquidated by December 31, 2026 Compliance Requirement: Reporting Type of Finding: Material Weakness in Internal Control Over Compliance, Material Noncompliance Criteria or specific requirement: Compliance: Reporting requirements for Coronavirus State and Local Fiscal Recovery Funds includes the following: Project and Expenditure Reports: Each recipient is required to report obligations and expenditures by project according to its corresponding Expenditure Category. The Project and Expenditure Report provides information on projects funded, expenditures, and contracts and subawards greater than or equal to $50,000, and other information required from recipients. For purposes of reporting in the SLFRF portal, an obligation is an order placed for property and services, contracts and subawards made, and similar transactions that require payment. An expenditure is the amount that has been incurred as a liability of the entity (the service has been rendered or the good has been delivered to the entity). An initial quarterly Project and Expenditure Report covered three calendar quarters from March 3, 2021 to December 31, 2021 and was required to be submitted to Treasury by January 31, 2022. Subsequent quarterly reports cover one calendar quarter and are required to be submitted to Treasury by the last day of the month following the end of the period covered. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in ?Standards for Internal Control in the Federal Government? issued by the Comptroller General of the United States or the ?Internal Control Integrated Framework?, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: The supporting documentation did not agree with amounts reported for obligations, expenditures and subawards on the Project and Expenditure Reports. Context: The following reports were selected for testing: 1) Project and Expenditure Reports for the 3/31/2022 and 6/30/2022 quarters: From these reports, 17 projects were selected for testing obligations and expenditures, 2 subawards greater than $50,000 and 11 subawards less than $50,000 were selected. The following exceptions were noted: 1) Project and Expenditure Reports: o Obligations: For 8 of 17 projects reported, obligations did not agree to supporting documentation. Additionally, 3 projects were included in the supporting documentation that were not reported. o Expenditures ? For 3 of 17 projects reported, expenditures did not agree to supporting documentation. Additionally, 3 projects were included in the supporting documentation that were not reported. o Subawards greater than $50,000: For 1 of 2 subawards greater than $50,000, reported obligations did not match supporting documentation. o Subawards less than $50,000: For 6 of 11 subawards, reported obligations did not match supporting documentation. Questioned costs: Undetermined. Cause: Internal Controls were not operating effectively to ensure that Project and Expenditure Reports were submitted accurately. Effect: Obligations, expenditures, and subaward information reported to Treasury did not agree to supporting documentation. Recommendation: The County should enhance its procedures and internal controls regarding preparation of the Project and Expenditure Reports to ensure that information reported is accurate and agrees to supporting documentation. Views of responsible officials: Management agrees with the finding. New Castle County self-reported the variances in expenditures and obligations due to accruals of costs to previously reported quarters. Such variances can be common with just-in-time reporting. Regarding the omitted projects, the Reporting Portal has undergone several updates throughout the period of performance. These updates contributed to confusion in required data for projects. The omitted projects were included in the subsequent reports after the data points were known and tracked. Regarding the reporting of project obligations, Treasury?s definition of obligation is very broad, and FAQ 13.17 allows the recipient to use its discretion to determine when an obligation is incurred. Such discretion calls for the interpretation of several source documents. In each report total obligations were not less than total expenditures nor did total obligations exceed available funding.
2022 ? 003 Federal Agency: U.S. Department of the Treasury Federal Program: COVID-19 ? Coronavirus State and Local Fiscal Recovery Funds Assistance Listing Number: 21.027 Award Period: March 3, 2021 ? December 31, 2024, liquidated by December 31, 2026 Compliance Requirement: Reporting Type of Finding: Material Weakness in Internal Control Over Compliance, Material Noncompliance Criteria or specific requirement: Compliance: Reporting requirements for Coronavirus State and Local Fiscal Recovery Funds includes the following: Project and Expenditure Reports: Each recipient is required to report obligations and expenditures by project according to its corresponding Expenditure Category. The Project and Expenditure Report provides information on projects funded, expenditures, and contracts and subawards greater than or equal to $50,000, and other information required from recipients. For purposes of reporting in the SLFRF portal, an obligation is an order placed for property and services, contracts and subawards made, and similar transactions that require payment. An expenditure is the amount that has been incurred as a liability of the entity (the service has been rendered or the good has been delivered to the entity). An initial quarterly Project and Expenditure Report covered three calendar quarters from March 3, 2021 to December 31, 2021 and was required to be submitted to Treasury by January 31, 2022. Subsequent quarterly reports cover one calendar quarter and are required to be submitted to Treasury by the last day of the month following the end of the period covered. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in ?Standards for Internal Control in the Federal Government? issued by the Comptroller General of the United States or the ?Internal Control Integrated Framework?, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: The supporting documentation did not agree with amounts reported for obligations, expenditures and subawards on the Project and Expenditure Reports. Context: The following reports were selected for testing: 1) Project and Expenditure Reports for the 3/31/2022 and 6/30/2022 quarters: From these reports, 17 projects were selected for testing obligations and expenditures, 2 subawards greater than $50,000 and 11 subawards less than $50,000 were selected. The following exceptions were noted: 1) Project and Expenditure Reports: o Obligations: For 8 of 17 projects reported, obligations did not agree to supporting documentation. Additionally, 3 projects were included in the supporting documentation that were not reported. o Expenditures ? For 3 of 17 projects reported, expenditures did not agree to supporting documentation. Additionally, 3 projects were included in the supporting documentation that were not reported. o Subawards greater than $50,000: For 1 of 2 subawards greater than $50,000, reported obligations did not match supporting documentation. o Subawards less than $50,000: For 6 of 11 subawards, reported obligations did not match supporting documentation. Questioned costs: Undetermined. Cause: Internal Controls were not operating effectively to ensure that Project and Expenditure Reports were submitted accurately. Effect: Obligations, expenditures, and subaward information reported to Treasury did not agree to supporting documentation. Recommendation: The County should enhance its procedures and internal controls regarding preparation of the Project and Expenditure Reports to ensure that information reported is accurate and agrees to supporting documentation. Views of responsible officials: Management agrees with the finding. New Castle County self-reported the variances in expenditures and obligations due to accruals of costs to previously reported quarters. Such variances can be common with just-in-time reporting. Regarding the omitted projects, the Reporting Portal has undergone several updates throughout the period of performance. These updates contributed to confusion in required data for projects. The omitted projects were included in the subsequent reports after the data points were known and tracked. Regarding the reporting of project obligations, Treasury?s definition of obligation is very broad, and FAQ 13.17 allows the recipient to use its discretion to determine when an obligation is incurred. Such discretion calls for the interpretation of several source documents. In each report total obligations were not less than total expenditures nor did total obligations exceed available funding.