Finding 1169639 (2025-003)

Material Weakness Repeat Finding
Requirement
AB
Questioned Costs
-
Year
2025
Accepted
2026-01-20
Audit: 382614
Organization: Wake County, North Carolina (NC)

AI Summary

  • Core Issue: There is a significant deficiency in tracking and reporting employee time for Medicaid, leading to inaccuracies in reimbursement requests.
  • Impacted Requirements: NCDHHS policy requires accurate allocation of salaries based on approved time sheets and supporting records.
  • Recommended Follow-Up: Implement a review control for weekly timesheets to ensure all program time is accurately reflected from day sheets.

Finding Text

2025-003 Significant Deficiency over Activities Allowed and Unallowed and Allowable Costs/Cost Principle (Repeat Finding) Information on the federal program: Medicaid Cluster (Medicaid), Assistance Listing Number 93.778, U.S. Department of Health and Human Services, passed through the N.C Department of Health and Human Services (NCDHHS), Division of Medical Assistance. Criteria: Per the NCDHHS policy manual, salaries, wages, and fringe benefits of Department of Social Service employees hired under the state merit system are allowable. Salaries shall be allocated to programs by time distribution methods and supported by payroll and attendance records for individuals. Condition: Employee’s time is tracked through the use of day sheets in which employees track their time by service code in 6-minute increments. Day sheets are used to complete weekly timesheets which are approved by supervisors. We noted five out of sixty sheets selected for Medicaid had more program minutes than what was reported on the employee’s approved time sheet. Context/Cause: As the day sheets included more program time than was included on the employee’s approved timesheet, the time spent on this program was understated during the 1571 monthly reimbursement request to the State. We noted the above condition in five out of sixty sheets selected for Medicaid. Effects: Inaccurate reporting of time coded to programs affects the total federal and state reimbursement for the program. Recommendation: We recommend that the County implements a review control over weekly timesheets to ensure the timesheets include all program time coded on the day sheets. Auditee’s Response: We concur with the finding.

Corrective Action Plan

County staff will receive annual daysheet training. The County will conduct training on the time sheet process. The County will continue random monthly reviews of Daysheets and timesheets initiated for May 2025. For those staff identified by the random monthly review with discrepancies, supervisors will provide refresher training on Daysheet and timesheet procedures. Additional targeted reviews will be completed monthly until the deficiencies are corrected.

Categories

Allowable Costs / Cost Principles Reporting Cash Management Significant Deficiency

Other Findings in this Audit

  • 1169638 2025-002
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
93.778 MEDICAL ASSISTANCE PROGRAM $24.81M
10.561 STATE ADMINISTRATIVE MATCHING GRANTS FOR THE SUPPLEMENTAL NUTRITION ASSISTANCE PROGRAM $8.74M
93.563 CHILD SUPPORT SERVICES $6.49M
93.658 FOSTER CARE TITLE IV-E $5.71M
10.557 WIC SPECIAL SUPPLEMENTAL NUTRITION PROGRAM FOR WOMEN, INFANTS, AND CHILDREN $4.37M
93.917 HIV CARE FORMULA GRANTS $2.87M
17.259 WIOA YOUTH ACTIVITIES $2.77M
17.258 WIOA ADULT PROGRAM $2.60M
93.596 CHILD CARE MANDATORY AND MATCHING FUNDS OF THE CHILD CARE AND DEVELOPMENT FUND $2.44M
14.239 HOME INVESTMENT PARTNERSHIPS PROGRAM $2.36M
93.967 CENTERS FOR DISEASE CONTROL AND PREVENTION COLLABORATION WITH ACADEMIA TO STRENGTHEN PUBLIC HEALTH $1.93M
17.278 WIOA DISLOCATED WORKER FORMULA GRANTS $1.88M
93.667 SOCIAL SERVICES BLOCK GRANT $1.83M
14.241 HOUSING OPPORTUNITIES FOR PERSONS WITH AIDS $1.67M
93.767 CHILDREN'S HEALTH INSURANCE PROGRAM $1.36M
10.916 WATERSHED REHABILITATION PROGRAM $825,967
93.994 MATERNAL AND CHILD HEALTH SERVICES BLOCK GRANT TO THE STATES $824,894
17.270 REENTRY EMPLOYMENT OPPORTUNITIES $805,411
93.659 ADOPTION ASSISTANCE $759,578
16.835 BODY WORN CAMERA POLICY AND IMPLEMENTATION $659,767
93.918 GRANTS TO PROVIDE OUTPATIENT EARLY INTERVENTION SERVICES WITH RESPECT TO HIV DISEASE $647,146
20.507 FEDERAL TRANSIT FORMULA GRANTS $605,970
93.568 LOW-INCOME HOME ENERGY ASSISTANCE $459,291
97.036 DISASTER GRANTS - PUBLIC ASSISTANCE (PRESIDENTIALLY DECLARED DISASTERS) $443,593
21.027 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $396,315
16.922 EQUITABLE SHARING PROGRAM $321,832
14.231 EMERGENCY SOLUTIONS GRANT PROGRAM $297,242
93.645 STEPHANIE TUBBS JONES CHILD WELFARE SERVICES PROGRAM $278,488
20.600 STATE AND COMMUNITY HIGHWAY SAFETY $237,711
93.217 FAMILY PLANNING SERVICES $236,670
93.566 REFUGEE AND ENTRANT ASSISTANCE STATE/REPLACEMENT DESIGNEE ADMINISTERED PROGRAMS $234,742
20.205 HIGHWAY PLANNING AND CONSTRUCTION $215,851
14.218 COMMUNITY DEVELOPMENT BLOCK GRANTS/ENTITLEMENT GRANTS $200,000
93.556 MARYLEE ALLEN PROMOTING SAFE AND STABLE FAMILIES PROGRAM $177,212
93.940 HIV PREVENTION ACTIVITIES HEALTH DEPARTMENT BASED $174,688
93.268 IMMUNIZATION COOPERATIVE AGREEMENTS $166,608
93.243 SUBSTANCE ABUSE AND MENTAL HEALTH SERVICES PROJECTS OF REGIONAL AND NATIONAL SIGNIFICANCE $160,361
16.838 COMPREHENSIVE OPIOID, STIMULANT, AND OTHER SUBSTANCES USE PROGRAM $158,590
93.674 JOHN H. CHAFEE FOSTER CARE PROGRAM FOR SUCCESSFUL TRANSITION TO ADULTHOOD $143,923
14.267 CONTINUUM OF CARE PROGRAM $128,924
17.277 WIOA NATIONAL DISLOCATED WORKER GRANTS / WIA NATIONAL EMERGENCY GRANTS $95,651
97.042 EMERGENCY MANAGEMENT PERFORMANCE GRANTS $91,579
84.184 SCHOOL SAFELY NATIONAL ACTIVITIES $88,161
93.069 PUBLIC HEALTH EMERGENCY PREPAREDNESS $86,360
95.001 HIGH INTENSITY DRUG TRAFFICKING AREAS PROGRAM $85,000
93.977 SEXUALLY TRANSMITTED DISEASES (STD) PREVENTION AND CONTROL GRANTS $80,665
93.558 TEMPORARY ASSISTANCE FOR NEEDY FAMILIES $72,098
93.898 CANCER PREVENTION AND CONTROL PROGRAMS FOR STATE, TERRITORIAL AND TRIBAL ORGANIZATIONS $71,500
93.387 NATIONAL AND STATE TOBACCO CONTROL PROGRAM $58,306
16.738 EDWARD BYRNE MEMORIAL JUSTICE ASSISTANCE GRANT PROGRAM $51,797
16.710 PUBLIC SAFETY PARTNERSHIP AND COMMUNITY POLICING GRANTS $45,010
97.137 STATE AND LOCAL CYBERSECURITY GRANT PROGRAM TRIBAL CYBERSECURITY GRANT PROGRAM $37,500
93.103 FOOD AND DRUG ADMINISTRATION RESEARCH $34,227
93.116 PROJECT GRANTS AND COOPERATIVE AGREEMENTS FOR TUBERCULOSIS CONTROL PROGRAMS $33,399
94.013 AMERICORPS VOLUNTEERS IN SERVICE TO AMERICA 94.013 $32,862
93.991 PREVENTIVE HEALTH AND HEALTH SERVICES BLOCK GRANT $29,543
16.753 CONGRESSIONALLY RECOMMENDED AWARDS $21,762
93.436 WELL-INTEGRATED SCREENING AND EVALUATION FOR WOMEN ACROSS THE NATION (WISEWOMAN) $19,530
20.513 ENHANCED MOBILITY OF SENIORS AND INDIVIDUALS WITH DISABILITIES $8,915
16.609 PROJECT SAFE NEIGHBORHOODS $6,686
20.530 PUBLIC TRANSPORTATION INNOVATION $6,299
16.606 STATE CRIMINAL ALIEN ASSISTANCE PROGRAM $5,907
93.837 CARDIOVASCULAR DISEASES RESEARCH $5,275