Finding 526305 (2024-001)

Significant Deficiency
Requirement
N
Questioned Costs
$1
Year
2024
Accepted
2025-03-07
Audit: 345218
Auditor: Lbmc

AI Summary

  • Core Issue: The federal program reported incorrect expenditures on the SEFA, leading to a misstatement of $1,570,592 for ALN 11.307.
  • Impacted Requirements: Compliance with 2CFR 200.510 for SEFA reporting and internal policies on loan proceeds application were not met.
  • Recommended Follow-up: Improve communication between grants personnel and management, and regularly reconcile the loan system to catch errors early.

Finding Text

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.

Corrective Action Plan

Finding ALN 11.307 During testing of the Economic Adjustment Assistance (ALN 11.307) grant two issues were noted. The federal expenditure amount was reported incorrectly on the SEFA provided by Louisville Metro and information in the loan payment system was incorrect for two written off loans. The amount reported on the SEFA was $1,501,755. The correct federal expenditure amount is $3,072,347. An adjustment to the SEFA was made to correct the federal expenditure amount. The loan payment for the written off loan, Barbie Bac’z, did not follow the order of priority. The METCO Board approved $14,699 to be written off for The Limbo LLC per the 12/14/23 METCO memo. However, the amount on the grant portfolio that was written off was $14,577. The difference between the minutes and the grant portfolio is $122. “We recommend communication between the OMB Grants division and the agency handling a federal grant be improved to ensure the SEFA is accurate. Auditor’s Recommendation We recommend management periodically reconcile the RLF loan system to catch errors before too much time has passed and make corrections when needed. We recommend that management correct the next semi-annual report and the information used to prepare the chart attached to the semi-annual report is for the correct fiscal year.” Management Response Management concurs with the auditors’ finding and recommendation. Metro Government will implement controls for periodic reconciliation of the RLF loan system to catch errors before too much time has passed in addition to a year-end review for a secondary supervisor and management review to ensure an accurate outcome before submission for audit review. Anticipated Completion Date Periodic Reconciliation of RLF program quarterly beginning April 1, 2025 Annual Review to be completed by July 15 for fiscal year ending June 30 Contact Responsible For Corrective Action Richard Champion Louisville Metro Finance Director (502) 574-1881

Categories

Questioned Costs Reporting

Other Findings in this Audit

  • 1102747 2024-001
    Significant Deficiency

Programs in Audit

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