Audit 345218

FY End
2024-06-30
Total Expended
$214.40M
Findings
2
Programs
67
Year: 2024 Accepted: 2025-03-07
Auditor: Lbmc

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
526305 2024-001 Significant Deficiency - N
1102747 2024-001 Significant Deficiency - N

Programs

ALN Program Spent Major Findings
21.027 Coronavirus State and Local Fiscal Recovery Funds $111.23M Yes 0
21.023 Emergency Rental Assistance Program $30.59M Yes 0
93.568 Low-Income Home Energy Assistance $7.24M Yes 0
11.307 Economic Adjustment Assistance $3.07M Yes 1
10.557 Wic Special Supplemental Nutrition Program for Women, Infants, and Children $2.80M - 0
93.967 Centers for Disease Control and Prevention Collaboration with Academia to Strengthen Public Health $2.00M - 0
14.218 Community Development Block Grants/entitlement Grants $1.91M - 0
14.231 Emergency Solutions Grant Program $1.85M - 0
93.569 Community Services Block Grant $1.63M - 0
14.241 Housing Opportunities for Persons with Aids $1.48M - 0
66.818 Brownfields Multipurpose, Assessment, Revolving Loan Fund, and Cleanup Cooperative Agreements $1.40M - 0
93.045 Special Programs for the Aging, Title Iii, Part C, Nutrition Services $909,912 - 0
14.239 Home Investment Partnerships Program $898,967 - 0
66.001 Air Pollution Control Program Support $885,433 - 0
14.900 Lead Hazard Reduction Grant Program $786,214 - 0
16.922 Equitable Sharing Program $561,740 - 0
93.069 Public Health Emergency Preparedness $480,129 - 0
93.788 Opioid Str $479,621 - 0
94.011 Americorps Seniors Foster Grandparent Program $459,652 - 0
93.243 Substance Abuse and Mental Health Services Projects of Regional and National Significance $366,995 - 0
16.838 Comprehensive Opioid, Stimulant, and Other Substances Use Program $346,722 - 0
93.959 Block Grants for Prevention and Treatment of Substance Abuse $343,259 - 0
14.889 Choice Neighborhoods Implementation Grants $263,107 - 0
81.128 Energy Efficiency and Conservation Block Grant Program (eecbg) $250,000 - 0
21.016 Equitable Sharing $223,696 - 0
97.042 Emergency Management Performance Grants $223,305 - 0
15.916 Outdoor Recreation Acquisition, Development and Planning $200,052 - 0
20.205 Highway Planning and Construction $191,798 Yes 0
93.926 Healthy Start Initiative $167,213 - 0
93.994 Maternal and Child Health Services Block Grant to the State $155,698 - 0
93.391 Activities to Support State, Tribal, Local and Territorial Health Department Response to Public Health Or Healthcare Crises $148,358 - 0
93.421 Strengthening Public Health Systems and Services Through National Partnerships to Improve and Protect the Nation's Health $139,093 - 0
93.940 Hiv Prevention Activities Health Department Based $130,897 - 0
93.268 Immunization Cooperative Agreements $129,408 - 0
14.401 Fair Housing Assistance Program $121,879 - 0
20.600 State and Community Highway Safety $112,134 - 0
14.228 Community Development Block Grants/state's Program and Non-Entitlement Grants in Hawaii $102,270 - 0
21.032 Local Assistance and Tribal Consistency Fund $100,000 - 0
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases $100,000 - 0
20.219 Recreational Trails Program $98,081 - 0
97.056 Port Security Grant Program $80,246 - 0
16.738 Edward Byrne Memorial Justice Assistance Grant Program $75,680 - 0
93.978 Sexually Transmitted Diseases Provider Education Grants $75,000 - 0
93.116 Project Grants and Cooperative Agreements for Tuberculosis Control Programs $71,200 - 0
95.001 High Intensity Drug Trafficking Areas Program $70,820 - 0
93.217 Family Planning Services $70,577 - 0
20.933 National Infrastructure Investments $63,137 - 0
66.046 Climate Pollution Reduction Grants $59,503 - 0
93.991 Preventive Health and Health Services Block Grant $54,408 - 0
93.917 Hiv Care Formula Grants $51,226 - 0
20.505 Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research $41,752 - 0
20.939 Safe Streets and Roads for All $39,669 - 0
93.136 Injury Prevention and Control Research and State and Community Based Programs $31,941 - 0
93.070 Environmental Public Health and Emergency Response $29,375 - 0
94.002 Americorps Seniors Retired and Senior Volunteer Program $29,308 - 0
10.699 Partnership Agreements $24,962 - 0
93.048 Special Programs for the Aging, Title Iv, and Title Ii, Discretionary Projects $21,227 - 0
66.032 State and Tribal Indoor Radon Grants $19,536 - 0
16.588 Violence Against Women Formula Grants $17,217 - 0
15.904 Historic Preservation Fund Grants-in-Aid $15,000 - 0
20.218 Motor Carrier Safety Assistance $6,887 - 0
14.267 Continuum of Care Program $5,838 - 0
16.590 Grants to Encourage Arrest Policies and Enforcement of Protection Orders Program $5,625 - 0
97.067 Homeland Security Grant Program $5,605 - 0
93.008 Medical Reserve Corps Small Grant Program $4,521 - 0
16.045 Community-Based Violence Intervention and Prevention Initiative $3,904 - 0
66.034 Surveys, Studies, Research, Investigations, Demonstrations, and Special Purpose Activities Relating to the Clean Air Act $3,090 - 0

Contacts

Name Title Type
XTABXRBBAUB1 Ron Cox Auditee
5025745831 Farrah Petter Auditor
No contacts on file

Notes to SEFA

Title: Note A--Basis of Presentation Accounting Policies: Expenditures reported on the SEFA are reported on the modified accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance and/or OMB Circular A-87, Cost Principles for State, Local and Indian Tribal Governments, wherein certain types of expenditures are not allowable or as limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: Metro Government has not elected to use the 10% de minimis indirect cost rate as allowed under the Uniform Guidance. The accompanying Schedule of Expenditures of Federal Awards (“SEFA”) includes the federal grant activity of Louisville/Jefferson County Metro Government (“Metro Government”). The information in this SEFA is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (“Uniform Guidance”). Because the Schedule presents only a selected portion of the operations of Metro Government, it is not intended to and does not present the financial position, changes in net assets, or cash flows of Metro Government.
Title: Note B--Summary of Significant Accounting Policies Accounting Policies: Expenditures reported on the SEFA are reported on the modified accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance and/or OMB Circular A-87, Cost Principles for State, Local and Indian Tribal Governments, wherein certain types of expenditures are not allowable or as limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: Metro Government has not elected to use the 10% de minimis indirect cost rate as allowed under the Uniform Guidance. Expenditures reported on the SEFA are reported on the modified accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance and/or OMB Circular A-87, Cost Principles for State, Local and Indian Tribal Governments, wherein certain types of expenditures are not allowable or as limited as to reimbursement. The basic financial statements of Metro Government are presented on the modified accrual basis of accounting for the governmental fund financial statements and the accrual basis of accounting for the government-wide, proprietary fund, and fiduciary fund financial statements. Thus, amounts reported on the Schedule may not directly agree to the amounts reported in the basic financial statements. The accompanying SEFA reflects certain adjustments resulting from transfers of funds between grants, adjustments, or credits made in the normal course of business. As a result, certain grants reflect negative expenditures. Federal assistance listing numbers or other identifying numbers listed on the SEFA were obtained from the respective grant/contract agreement.
Title: Note C--Indirect Cost Rate Accounting Policies: Expenditures reported on the SEFA are reported on the modified accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance and/or OMB Circular A-87, Cost Principles for State, Local and Indian Tribal Governments, wherein certain types of expenditures are not allowable or as limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: Metro Government has not elected to use the 10% de minimis indirect cost rate as allowed under the Uniform Guidance. Metro Government has not elected to use the 10% de minimis indirect cost rate as allowed under the Uniform Guidance.
Title: Note D--Programs From Multiple Funding Sources Accounting Policies: Expenditures reported on the SEFA are reported on the modified accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance and/or OMB Circular A-87, Cost Principles for State, Local and Indian Tribal Governments, wherein certain types of expenditures are not allowable or as limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: Metro Government has not elected to use the 10% de minimis indirect cost rate as allowed under the Uniform Guidance. Uniform Guidance Part 200, Subpart A defines a recipient as "a non-federal entity that expends federal awards received directly from a federal awarding agency to carry out a federal program" and a passthrough entity as "a non-federal entity that provides a federal award to a sub-recipient to carry out a federal program." Federal program funds can be received directly from the federal government or passed through from another entity. Below is a list of federal programs that are funded from more than a single funding source. They may be either (1) multiple passed through agencies, or (2) both direct and passed through. All other federal programs listed on the SEFA are from a single source, and therefore the program totals are evident in the SEFA.
Title: Note E--Economic Adjustment Assistance Program Accounting Policies: Expenditures reported on the SEFA are reported on the modified accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance and/or OMB Circular A-87, Cost Principles for State, Local and Indian Tribal Governments, wherein certain types of expenditures are not allowable or as limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: Metro Government has not elected to use the 10% de minimis indirect cost rate as allowed under the Uniform Guidance. Metro Government has an U. S. Economic Development Administration (“EDA”) revolving loan fund (“RLF”) under the Economic Adjustment Assistance Program, Federal Assistance Listing Number (“FALN”) 11.307. According to the OMB Compliance Supplement, for purposes of completing the SEFA, each EDA RLF (FALN 11.307) should be shown as a separate line item calculated as follows: 1. Balance of RLF loan outstanding at the end of the recipient’s fiscal year, plus 2. Cash and Investment balances in the RLF at the end of the recipient’s fiscal year, plus 3. Administrative expenses paid out of the RLF income during recipient’s fiscal year, plus 4. The unpaid principal of all loans written off during the recipient’s fiscal year; and then multiply this sum (1+2+3+4) by 5. The Federal share of the RLF. The Federal share is defined as the Federal participation rate (or the Federal grant rate) as specified in the grant award. The calculation to arrive at the RLF amount shown on the SEFA as of year ended June 30, 2024 is as follows:

Finding Details

Federal Program reported incorrectly on the Schedule of Expenditures of Federal Awards (“SEFA”) and errors noted in written off loans Federal Program: Assistance Listing Number (“ALN”) 11.307 Economic Adjustment Assistance Name of Federal Agency: U.S. Department of Commerce Award Identification Number and Year: 04-79-07547 and Year 2020 Name of pass-through entity: N/A COVID Identification: Yes Amount of Questioned Costs: $1,571,578 Criteria: 2CFR 200.510 states the requirements for SEFA reporting. The Louisville Metropolitan Business Development Corporation Policy and Procedures Handbook provides the order of priority for loan proceeds to be applied. Condition: The federal expenditure amount for ALN 11.307 was reported incorrectly on the draft SEFA provided by Louisville Metro. Also, the information in the loan system was incorrect for two written off loans. Effect: SEFA was mis-stated for ALN 11.307. Semi-annual report had incorrect information on chart. Cause: Lack of communication between Metro grants personnel and Metro OMB grants division. Also error in loan system. Questioned Costs: Total questioned costs is $1,571,578 (SEFA error of $1,570,592, loan error of $864, and loan error of $122). Context: Total federal expenditures on the SEFA required an adjustment of $1,570,592. The total written off loan amounts for FY 2024 were $343,439. Recommendation: We recommend communication be improved and management periodically reconcile the loan system to detect errors. Management’s response: Management agrees with the finding and will develop a plan to insure such differences do not reoccur in the future.
Federal Program reported incorrectly on the Schedule of Expenditures of Federal Awards (“SEFA”) and errors noted in written off loans Federal Program: Assistance Listing Number (“ALN”) 11.307 Economic Adjustment Assistance Name of Federal Agency: U.S. Department of Commerce Award Identification Number and Year: 04-79-07547 and Year 2020 Name of pass-through entity: N/A COVID Identification: Yes Amount of Questioned Costs: $1,571,578 Criteria: 2CFR 200.510 states the requirements for SEFA reporting. The Louisville Metropolitan Business Development Corporation Policy and Procedures Handbook provides the order of priority for loan proceeds to be applied. Condition: The federal expenditure amount for ALN 11.307 was reported incorrectly on the draft SEFA provided by Louisville Metro. Also, the information in the loan system was incorrect for two written off loans. Effect: SEFA was mis-stated for ALN 11.307. Semi-annual report had incorrect information on chart. Cause: Lack of communication between Metro grants personnel and Metro OMB grants division. Also error in loan system. Questioned Costs: Total questioned costs is $1,571,578 (SEFA error of $1,570,592, loan error of $864, and loan error of $122). Context: Total federal expenditures on the SEFA required an adjustment of $1,570,592. The total written off loan amounts for FY 2024 were $343,439. Recommendation: We recommend communication be improved and management periodically reconcile the loan system to detect errors. Management’s response: Management agrees with the finding and will develop a plan to insure such differences do not reoccur in the future.