Finding 1217528 (2024-002)

Material Weakness Repeat Finding
Requirement
B
Questioned Costs
-
Year
2024
Accepted
2026-06-13

AI Summary

  • Core Issue: Control deficiencies led to errors in payroll expense allocation for federal awards, violating 45 CFR § 75.430(i)(1)(i).
  • Impacted Requirements: Internal controls were not effectively implemented, resulting in unapproved timesheets and miscalculations in employee hours.
  • Recommended Follow-Up: The County should review and strengthen policies to ensure all timesheets are properly approved by a knowledgeable supervisor before allocation to federal programs.

Finding Text

45 CFR § 75.430(i)(1)(i) states charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must be supported by a system of internal controls which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. Additionally, 45 CFR § 75.303 requires a non-Federal entity receiving federal awards to establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. Due to control deficiencies, the following errors were noted for AL # 93.659 - Adoption Assistance for the fiscal year ended December 31, 2024: • The testing of payroll expenses noted the County utilized employee-completed time-sheets for allocating payroll expenses to the federal program. However, the County’s established internal control procedures did not occur for four out of 40 (10%) timesheets submitted. The timesheets did not contain appropriate evidence that the timesheet was reviewed and approved by a supervisor with direct knowledge of the employee’s activities to support proper allocation to the program. We were able to substantiate the related expenses through additional means to support allocation to the federal program. Additionally, three out of 40 timesheets (7.5%) reviewed, indicated the Director approved their own timesheet instead of another supervisor. • Time accrued was miscalculated which resulted in an employee banking 15 minutes extra of comp time. • Time charged to sick and regular pay was miscalculated which resulted in an employee being charged 8 hours of sick pay instead of 7 hours. • Time accrued was miscalculated which resulted in an employee being paid for 80 hours when the employee only worked 79 hours. Failure to ensure all time sheets are appropriately approved and reviewed by a knowledgeable supervisor could result in errors and unallowable costs being allocated to a federal program and could ultimately result in a questioned cost. We recommend the County review established policies and procedures and ensure all timesheets are appropriately reviewed prior to allocation to a federal program.

Corrective Action Plan

A procedure was put in place where the administrative assistant processing payroll verifies that the employee completed time-sheets are signed off by supervisors signing their initials next to the employees signature. The administrative assistant will verify that the supervisors have signed the time-sheets that they have completed based on the employee’s completed time-sheet. If the initials or signatures are missing, they will be returned to the supervisor to complete. The Finance Director will sign off on the Executive Director’s time-sheet so that the Executive Director is no longer approving their own time-sheet.

Categories

Allowable Costs / Cost Principles

Programs in Audit

ALN Program Name Expenditures
93.558 TEMPORARY ASSISTANCE FOR NEEDY FAMILIES $3.93M
93.778 GRANTS TO STATES FOR MEDICAID $2.52M
20.205 HIGHWAY PLANNING AND CONSTRUCTION $2.11M
93.658 FOSTER CARE TITLE IV-E $1.50M
93.563 CHILD SUPPORT SERVICES $1.43M
93.659 ADOPTION ASSISTANCE $946,124
20.509 FORMULA GRANTS FOR RURAL AREAS AND TRIBAL TRANSIT PROGRAM $749,887
10.561 STATE ADMINISTRATIVE MATCHING GRANTS FOR THE SUPPLEMENTAL NUTRITION ASSISTANCE PROGRAM $618,867
93.959 BLOCK GRANTS FOR PREVENTION AND TREATMENT OF SUBSTANCE ABUSE $566,538
17.258 WIOA ADULT PROGRAM $448,974
14.267 CONTINUUM OF CARE PROGRAM $394,783
14.239 HOME INVESTMENT PARTNERSHIPS PROGRAM $376,250
93.788 OPIOID STR $338,600
17.259 WIOA YOUTH ACTIVITIES $338,140
14.228 COMMUNITY DEVELOPMENT BLOCK GRANTS/STATE'S PROGRAM AND NON-ENTITLEMENT GRANTS IN HAWAII $311,809
84.181 SPECIAL EDUCATION-GRANTS FOR INFANTS AND FAMILIES $270,347
93.575 CHILD CARE AND DEVELOPMENT BLOCK GRANT $198,666
93.564 CHILD SUPPORT SERVICES RESEARCH $155,730
93.958 BLOCK GRANTS FOR COMMUNITY MENTAL HEALTH SERVICES $153,091
93.472 TITLE IV-E PREVENTION PROGRAM $145,365
17.225 UNEMPLOYMENT INSURANCE $130,023
21.027 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $122,301
93.556 MARYLEE ALLEN PROMOTING SAFE AND STABLE FAMILIES PROGRAM $93,418
97.042 EMERGENCY MANAGEMENT PERFORMANCE GRANTS $86,215
93.645 STEPHANIE TUBBS JONES CHILD WELFARE SERVICES PROGRAM $78,645
17.278 WIOA DISLOCATED WORKER FORMULA GRANTS $76,488
93.667 SOCIAL SERVICES BLOCK GRANT $64,930
93.912 RURAL HEALTHCARE SERVICES PROGRAMS $59,722
93.674 JOHN H. CHAFEE FOSTER CARE PROGRAM FOR SUCCESSFUL TRANSITION TO ADULTHOOD $49,309
93.044 SPECIAL PROGRAMS FOR THE AGING, TITLE III, PART B, GRANTS FOR SUPPORTIVE SERVICES AND SENIOR CENTERS $37,472
97.067 HOMELAND SECURITY GRANT PROGRAM $30,784
16.738 EDWARD BYRNE MEMORIAL JUSTICE ASSISTANCE GRANT PROGRAM $22,975
17.277 WIOA NATIONAL DISLOCATED WORKER GRANTS / WIA NATIONAL EMERGENCY GRANTS $18,568
16.710 PUBLIC SAFETY PARTNERSHIP AND COMMUNITY POLICING GRANTS $11,906
93.747 ELDER ABUSE PREVENTION INTERVENTIONS PROGRAM $9,083
90.404 HAVA ELECTION SECURITY GRANTS $6,623