Finding 1156788 (2024-002)

Material Weakness Repeat Finding
Requirement
B
Questioned Costs
$1
Year
2024
Accepted
2025-09-30
Audit: 369168
Auditor: Bmss LLC

AI Summary

  • Core Issue: Duplicate invoices led to the recording of unallowable costs totaling $22,100.41.
  • Impacted Requirements: Compliance with the Uniform Guidance, which mandates refunding federal shares of unallowable costs.
  • Recommended Follow-Up: Implement IT controls to prevent duplicate invoice entries and ensure proper vendor record management.

Finding Text

Program - Racial and Ethnic Approaches to Community Health, ALN # 93.304 Compliance Requirement – Allowable Cost Questioned Cost - $22,100.41 Criteria - The Uniform Guidance states that any federal share of unallowable costs must be refunded to the government. Condition - During our audit, we noticed an instance of duplicate expenditures being recorded. Reimbursement was requested and received for these costs from the Racial and Ethnic Approaches to Community Health program under ALN 93.304. This occurred through a single vendor, for which it was noted that the vendor had sent duplicate invoices, and MSPHI recorded both invoices. Effect - Lack of controls resulted in MSPHI recording duplicate expenditures, which resulted in requesting reimbursement for unallowable costs. Cause - Duplicate vendor records. Recommendation - We recommend the implementation of IT controls to prevent the recording of duplicate invoice numbers. View of responsible officials - The vendor(USM) sent duplicate bills but from different names on the invoice 2 months apart. Mississippi Public Health Institute has since made all departments and duplicate names inactive inside NetSuite so the internal controls of duplicate invoice numbers and amounts will work. The Organization concurs with the finding and will implement the recommendation. Refer to Corrective Action Plan.

Corrective Action Plan

AUDITEE’S CORRECTIVE ACTION PLAN As required by 2CFR Section 200.511 of the Uniform Guidance, Mississippi Public Health Institute has prepared and hereby submits the following corrective action plan for the findings included in the Schedule of Findings and Questions Costs for the year ended December 31, 2024: Federal Award Findings and Questioned Costs 2024-002 Unallowable Costs Criteria - The Uniform Guidance states that any federal share of allowable costs must be refunded to the government. During our audit, we noticed an instance of duplicate expenditures being recorded. Reimbursement was requested and received for these costs from the Racial and Ethnic Approaches to Community Health program under ALN 93.304. This occurred through a single vendor, for which it was noted that the vendor had sent duplicate invoices, and MSPHI recorded both invoices. Recommendation - We recommend the implementation of IT controls to prevent duplicate invoice numbers to be recorded. Corrective Action Plan - Mississippi Public Health Institute will increase oversight of grant expenditures and drawdowns to improve reconciliation accuracy. Position of Responsible Official – John Davis, Chief Financial Officer Anticipated Completion Date – Completed after brought to client’s attention. August 31st, 2025.

Categories

Questioned Costs Allowable Costs / Cost Principles Cash Management

Programs in Audit

ALN Program Name Expenditures
93.304 Racial and Ethnic Approaches to Community Health $950,244
93.967 Centers for Disease Control and Prevention Collaboration with Academia to Strengthen Public Health $588,630
93.788 Opioid Str $511,722
93.243 Substance Abuse and Mental Health Services Projects of Regional and National Significance $323,624
93.912 Rural Health Care Services Outreach, Rural Health Network Development and Small Health Care Provider Quality Improvement $264,160
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $209,219
16.838 Comprehensive Opioid, Stimulant, and Other Substances Use Program $204,279
93.671 Family Violence Prevention and Services/domestic Violence Shelter and Supportive Services $144,441
93.391 Activities to Support State, Tribal, Local and Territorial (stlt) Health Department Response to Public Health Or Healthcare Crises $101,576
93.959 Block Grants for Prevention and Treatment of Substance Abuse $68,554
93.946 Cooperative Agreements to Support State-Based Safe Motherhood and Infant Health Initiative Programs $59,770
93.136 Injury Prevention and Control Research and State and Community Based Programs $37,361
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $35,971
93.310 Trans-Nih Research Support $35,493
93.319 Outreach Programs to Reduce the Prevalence of Obesity in High Risk Rural Areas $31,794
93.110 Maternal and Child Health Federal Consolidated Programs $26,656
21.027 Coronavirus State and Local Fiscal Recovery Funds $26,309
93.899 Minority Hiv/aids Fund (mhaf) $25,332