Audit 39574

FY End
2022-12-31
Total Expended
$47.41M
Findings
2
Programs
38
Organization: City of Shreveport (LA)
Year: 2022 Accepted: 2023-08-06

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
45738 2022-005 Material Weakness - L
622180 2022-005 Material Weakness - L

Programs

ALN Program Spent Major Findings
21.027 Covid 19 - Coronavirus State and Local Fiscal Recovery Funds $9.42M Yes 1
14.889 Choice Neighborhoods Implementation Grants $5.31M - 0
14.218 Community Development Block Grants/entitlement Grants $2.55M - 0
20.106 Covid 19 - Airport Improvement Program $2.25M Yes 0
20.507 Covid 19 - Federal Transit_formula Grants $1.50M Yes 0
17.258 Wia Adult Program $1.21M - 0
17.259 Wia Youth Activities $1.05M - 0
20.507 Federal Transit_formula Grants $840,152 Yes 0
97.083 Staffing for Adequate Fire and Emergency Response (safer) $751,219 - 0
14.218 Covid 19 - Community Development Block Grants/entitlement Grants $741,213 - 0
16.710 Public Safety Partnership and Community Policing Grants $684,217 - 0
66.458 Capitalization Grants for Clean Water State Revolving Funds $640,107 - 0
15.904 Historic Preservation Fund Grants-in-Aid $579,352 - 0
14.231 Covid 19 - Emergency Solutions Grant Program $495,107 - 0
20.526 Buses and Bus Facilities Formula, Competitive, and Low Or No Emissions Programs $428,211 Yes 0
17.278 Wia Dislocated Worker Formula Grants $421,751 - 0
16.U01 A.f.i.s. 2021 $326,013 - 0
20.106 Airport Improvement Program $306,448 Yes 0
14.239 Home Investment Partnerships Program $253,148 - 0
16.U02 A.f.i.s. 2022 $236,627 - 0
17.277 Covid 19 - Workforce Investment Act (wia) National Emergency Grants $218,690 - 0
14.231 Emergency Solutions Grant Program $143,313 - 0
97.090 Law Enforcement Officer Reimbursement Agreement Program $123,430 - 0
16.609 Project Safe Neighborhoods $103,835 - 0
16.034 Covid 19 - Coronavirus Emergency Supplemental Funding Program $70,594 - 0
14.239 Covid 19 - Home Investment Partnerships Program $47,345 - 0
16.166 Safe Streets $41,916 - 0
16.U03 Federal Atf Grant $36,629 - 0
95.001 High Intensity Drug Trafficking Areas Program $28,634 - 0
16.U05 Organized Crime Enforcement Task Force $25,360 - 0
97.039 Hazard Mitigation Grant $23,628 - 0
16.U04 Organized Crime Enforcement Task Force $23,515 - 0
16.U06 U S Marshals $14,375 - 0
16.588 Violence Against Women Formula Grants $11,838 - 0
16.817 Byrne Criminal Justice Innovation Program $9,852 - 0
20.600 State and Community Highway Safety $3,933 - 0
66.815 Environmental Workforce Development and Job Training Cooperative Agreements $2,933 - 0
16.738 Edward Byrne Memorial Justice Assistance Grant Program $961 - 0

Contacts

Name Title Type
NJUKCVR2LWM8 Sherricka Fields Jones Auditee
3186735400 Tom Simms Auditor
No contacts on file

Notes to SEFA

Title: PROGRAM COSTS Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards (the Schedule) presents the activity of the federal awards of the City of Shreveport, Louisiana (the City). The Citys reporting entity is defined in Note 1 to the Citys financial statements for the year ended December 31, 2022. All federal awards received from federal agencies are included on the Schedule. The accompanying Schedule of Expenditures of Federal Awards is presented using the same basis of accounting, which is described in Note 1 to the Citys financial statements for the year ended December 31, 2022. The information in the Schedule is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards. Therefore, some amounts presented in this Schedule may differ from amounts presented in, or used in the preparation of, the basic financial statements. The City did not elect to use the 10 percent (10%) de minimis indirect cost rate. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. The amounts shown as current year expenditures represent only the federal grant portion of the program costs. Entire program costs, including the Citys portion, exceed what is presented. Such expenditures are recognized following the cost principles contained in Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, wherein certain types of expenditures are not allowable or are limited as to reimbursement.
Title: MATCHING REQUIREMENTS Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards (the Schedule) presents the activity of the federal awards of the City of Shreveport, Louisiana (the City). The Citys reporting entity is defined in Note 1 to the Citys financial statements for the year ended December 31, 2022. All federal awards received from federal agencies are included on the Schedule. The accompanying Schedule of Expenditures of Federal Awards is presented using the same basis of accounting, which is described in Note 1 to the Citys financial statements for the year ended December 31, 2022. The information in the Schedule is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards. Therefore, some amounts presented in this Schedule may differ from amounts presented in, or used in the preparation of, the basic financial statements. The City did not elect to use the 10 percent (10%) de minimis indirect cost rate. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. Certain Federal programs require the City to contribute non-Federal funds (matching funds) to support the Federally-funded programs. The City has met its matching requirements. The Schedule does not include the expenditure of non-Federal matching funds.
Title: LOANS AND LOAN GUARANTEES Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards (the Schedule) presents the activity of the federal awards of the City of Shreveport, Louisiana (the City). The Citys reporting entity is defined in Note 1 to the Citys financial statements for the year ended December 31, 2022. All federal awards received from federal agencies are included on the Schedule. The accompanying Schedule of Expenditures of Federal Awards is presented using the same basis of accounting, which is described in Note 1 to the Citys financial statements for the year ended December 31, 2022. The information in the Schedule is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards. Therefore, some amounts presented in this Schedule may differ from amounts presented in, or used in the preparation of, the basic financial statements. The City did not elect to use the 10 percent (10%) de minimis indirect cost rate. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. The Office of Community Planning and Development has issued a compliance supplement regarding the programs for the Community Development Block Grant (ALN 14.218). For subrecipients of these loans in years after the subrecipient has expended loan proceeds and completed construction, and the subrecipients only ongoing financial activity of the program is the payment of principal and interest on outstanding balances, the prior loan balances at the subrecipient level are not considered to have continuing compliance requirements. The City's Water and Sewer department is the subrecipient of the States Capitalization Grants for Clean Water State Revolving Funds (ALN 66.458). The City has drawn down $15,006,597 as of the year ended December 31, 2022. The outstanding balances for Loan and Loan Guarantee Programs as of December 31, 2022 is as follows; Community Development Block Grants/Entitlement Grants, ALN 14.218, $142,000, and Capitalization Grants for Clean Water State Revolving Funds, ALN 66.458, $13,579.696.
Title: SUBSEQUENT EVENTS Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards (the Schedule) presents the activity of the federal awards of the City of Shreveport, Louisiana (the City). The Citys reporting entity is defined in Note 1 to the Citys financial statements for the year ended December 31, 2022. All federal awards received from federal agencies are included on the Schedule. The accompanying Schedule of Expenditures of Federal Awards is presented using the same basis of accounting, which is described in Note 1 to the Citys financial statements for the year ended December 31, 2022. The information in the Schedule is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards. Therefore, some amounts presented in this Schedule may differ from amounts presented in, or used in the preparation of, the basic financial statements. The City did not elect to use the 10 percent (10%) de minimis indirect cost rate. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. The City is required to evaluate events or transactions that may occur after the Schedule of Expenditures of Federal Awards date for potential recognition or disclosure in the notes to the Schedule of Expenditures of Federal Awards. The City performed such an evaluation through June 30, 2023, the date which the schedule of expenditures of federal awards was available to be issued, and noted no events or transactions that occurred after the Schedule of Expenditures of Federal Awards date requiring recognition or disclosure.
Title: NONCASH AWARDS Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards (the Schedule) presents the activity of the federal awards of the City of Shreveport, Louisiana (the City). The Citys reporting entity is defined in Note 1 to the Citys financial statements for the year ended December 31, 2022. All federal awards received from federal agencies are included on the Schedule. The accompanying Schedule of Expenditures of Federal Awards is presented using the same basis of accounting, which is described in Note 1 to the Citys financial statements for the year ended December 31, 2022. The information in the Schedule is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards. Therefore, some amounts presented in this Schedule may differ from amounts presented in, or used in the preparation of, the basic financial statements. The City did not elect to use the 10 percent (10%) de minimis indirect cost rate. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. No noncash awards were received for the year ended December 31, 2022.
Title: PROGRAM INCOME Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards (the Schedule) presents the activity of the federal awards of the City of Shreveport, Louisiana (the City). The Citys reporting entity is defined in Note 1 to the Citys financial statements for the year ended December 31, 2022. All federal awards received from federal agencies are included on the Schedule. The accompanying Schedule of Expenditures of Federal Awards is presented using the same basis of accounting, which is described in Note 1 to the Citys financial statements for the year ended December 31, 2022. The information in the Schedule is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards. Therefore, some amounts presented in this Schedule may differ from amounts presented in, or used in the preparation of, the basic financial statements. The City did not elect to use the 10 percent (10%) de minimis indirect cost rate. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. See table inside of single audit report.
Title: Program Subtotal Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards (the Schedule) presents the activity of the federal awards of the City of Shreveport, Louisiana (the City). The Citys reporting entity is defined in Note 1 to the Citys financial statements for the year ended December 31, 2022. All federal awards received from federal agencies are included on the Schedule. The accompanying Schedule of Expenditures of Federal Awards is presented using the same basis of accounting, which is described in Note 1 to the Citys financial statements for the year ended December 31, 2022. The information in the Schedule is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards. Therefore, some amounts presented in this Schedule may differ from amounts presented in, or used in the preparation of, the basic financial statements. The City did not elect to use the 10 percent (10%) de minimis indirect cost rate. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. The total expenditures under ALN 16.738 are $158,861.

Finding Details

Program Name: Coronavirus State and Local Recovery Funds ? Assistance Listing Number 21.027. Federal Award Year: 2022. Name of federal agency: Department of Treasury. Condition: In accordance with 2 CFR 200.303(a) which requires the non-federal entity to establish and maintain effective internal controls over compliance, the City failed to establish and maintain effective controls over reporting. No reporting was submitted during fiscal year-ending December 31, 2022. Criteria: The City is responsible for submitting reports per the Coronavirus State and Local Fiscal Recovery Funds compliance requirements. Cause: Management in place during fiscal year-ending December 31, 2022 failed to create and submit any reports. Effect: A record of late reporting could lead to a finding of non-compliance, which could result in development of a corrective action plan, or other consequences as appropriate. Questioned Cost: None. Recommendation: We recommend the client prepares and submits all applicable reporting requirements for the Coronavirus State and Local Fiscal Recovery Funds program. Person Responsible for Corrective Action Plan: April Jordan, Controller.
Program Name: Coronavirus State and Local Recovery Funds ? Assistance Listing Number 21.027. Federal Award Year: 2022. Name of federal agency: Department of Treasury. Condition: In accordance with 2 CFR 200.303(a) which requires the non-federal entity to establish and maintain effective internal controls over compliance, the City failed to establish and maintain effective controls over reporting. No reporting was submitted during fiscal year-ending December 31, 2022. Criteria: The City is responsible for submitting reports per the Coronavirus State and Local Fiscal Recovery Funds compliance requirements. Cause: Management in place during fiscal year-ending December 31, 2022 failed to create and submit any reports. Effect: A record of late reporting could lead to a finding of non-compliance, which could result in development of a corrective action plan, or other consequences as appropriate. Questioned Cost: None. Recommendation: We recommend the client prepares and submits all applicable reporting requirements for the Coronavirus State and Local Fiscal Recovery Funds program. Person Responsible for Corrective Action Plan: April Jordan, Controller.