Finding 1118410 (2024-001)

Significant Deficiency
Requirement
B
Questioned Costs
$1
Year
2024
Accepted
2025-03-31

AI Summary

  • Core Issue: Payroll reimbursement requests lacked necessary documentation to verify accuracy, leading to questioned costs of $40,394.
  • Impacted Requirements: Compliance with 2 CFR Part 200 is essential; internal controls must ensure payroll systems accurately reflect work performed.
  • Recommended Follow-Up: Management should establish procedures to document and support any changes made by the awarding agency before approving invoices.

Finding Text

2024 – 001 – Allowable Costs Federal Agency: U.S. Department of Homeland Security Federal Program Name: Disaster Grants – Public Assistance Assistance Listing Number: 97.036 Federal Award Identification Number and Year: FEMA-4496DR-MA Pass-Through Agency: Massachusetts Emergency Management Agency Pass-Through Number(s): CTFMEMA4496BOPHC02018 Award Period: March 27, 2020 through October 20, 2023 Type of Finding: • Significant Deficiency in Internal Control over Compliance • Other Matters Criteria or specific requirement: 2 CFR Part 200 Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Award requires compliance with the provisions of allowable costs/cost principles. The Commission should have internal controls designed to ensure compliance with those provisions. Payroll systems must be based on records that accurately reflect the work performed and supported by a system of internal controls that provides reasonable assurance that charges are accurate; allowable and reasonable. Condition: Some payroll reimbursement requests lacked supporting evidence as to the accuracy of the calculations. Questioned costs: $40,394 Context: For 5 of the 40 payroll transactions tested, we identified the Commission did not have documentation to support the payroll rates utilized in the request for reimbursement. Cause: Based on discussions with management, the awarding agency made adjustments to the workbook prior to uploading it to their portal for Commission approval, but the awarding agency did not provide notice of the change or supporting documentation to the Commission to verify the changes and ensure data accuracy. Effect: The salary charges are subject to disallowance and are considered questioned costs. Recommendation: Management should implement procedures to ensure that changes made by the awarding agency after invoice submission are properly supported and documented prior to approval them in the awarding agency’s portal. Views of responsible officials: There is no disagreement with the audit finding.

Categories

Questioned Costs Allowable Costs / Cost Principles Cash Management Significant Deficiency Matching / Level of Effort / Earmarking

Other Findings in this Audit

  • 541968 2024-001
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
93.914 Hiv Emergency Relief Project Grants $14.63M
93.495 Community Health Workers for Public Health Response and Resilient $3.00M
93.967 Centers for Disease Control and Prevention Collaboration with Academia to Strengthen Public Health $1.77M
93.391 Activities to Support State, Tribal, Local and Territorial (stlt) Health Department Response to Public Health Or Healthcare Crises $1.53M
93.926 Healthy Start Initiative $1.19M
93.686 Ending the Hiv Epidemic: A Plan for America — Ryan White Hiv/aids Program Parts A and B $878,363
14.231 Emergency Solutions Grant Program $825,503
93.498 Provider Relief Fund and American Rescue Plan (arp) Rural Distribution $763,385
14.239 Home Investment Partnerships Program $757,660
97.067 Homeland Security Grant Program $632,110
93.069 Public Health Emergency Preparedness $576,859
16.842 Opioid Affected Youth Initiative $412,036
93.136 Injury Prevention and Control Research and State and Community Based Programs $410,985
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $368,682
93.104 Comprehensive Community Mental Health Services for Children with Serious Emotional Disturbances (sed) $355,901
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $189,754
17.285 Registered Apprenticeship $183,901
93.917 Hiv Care Formula Grants $176,214
11.307 Economic Adjustment Assistance $164,369
93.991 Preventive Health and Health Services Block Grant $139,487
93.994 Maternal and Child Health Services Block Grant to the States $133,948
93.788 Opioid Str $133,491
93.334 The Healthy Brain Initiative: Technical Assistance to Implement Public Health Actions Related to Cognitive Health, Cognitive Impairment, and Caregiving at the State and Local Levels $132,030
93.421 Strengthening Public Health Systems and Services Through National Partnerships to Improve and Protect the Nation’s Health $126,648
10.569 Emergency Food Assistance Program (food Commodities) $119,893
93.137 Community Programs to Improve Minority Health $96,155
93.107 Area Health Education Centers $81,479
93.889 National Bioterrorism Hospital Preparedness Program $72,564
93.884 Primary Care Training and Enhancement $63,279
93.870 Maternal, Infant and Early Childhood Home Visiting Grant $52,519
93.304 Racial and Ethnic Approaches to Community Health $50,639
93.959 Block Grants for Prevention and Treatment of Substance Abuse $45,702
21.027 Coronavirus State and Local Fiscal Recovery Funds $45,538
14.267 Continuum of Care Program $35,393
93.135 Centers for Research and Demonstration for Health Promotion and Disease Prevention $15,884
93.243 Substance Abuse and Mental Health Services Projects of Regional and National Significance $14,177
93.217 Family Planning Services $12,073
16.888 Consolidated and Technical Assistance Grant Program to Address Children and Youth Experiencing Domestic and Sexual Violence and Engage Men and Boys As Allies $9,720
16.045 Community-Based Violence Intervention and Prevention Initiative $4,498