Finding 1177643 (2024-007)

Material Weakness Repeat Finding
Requirement
AB
Questioned Costs
-
Year
2024
Accepted
2026-03-10
Audit: 391060
Organization: Jackson County (OH)

AI Summary

  • Core Issue: The Sheriff's Department lacked adequate documentation and internal controls for calculating employee retention payments from the American Rescue Plan Funding.
  • Impacted Requirements: Payments must be necessary, reasonable, and consistently documented per federal regulations, with clear calculations for all employee payments.
  • Recommended Follow-Up: Implement procedures to maintain supporting documentation for all grant payments and ensure any changes to payment calculations are properly approved.

Finding Text

2 C.F.R. § 1000.10 gives regulatory effect to the Department of the Treasurer for 2 C.F.R. § 200.403(a), which requires that costs be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles. 2 C.F.R. § 200.403(c) documents that costs must be consistent with policies and procedures that apply uniformly to both federally-financed and other activities of the non-Federal entity. The Sheriff's Department was awarded the American Rescue Plan Funding for the Community Violence Intervention program to offer employee incentive and retention funds of $72,159 on October 14, 2022. The Sheriff's department completed the request for proposal for the grant based on May 2022 wages with an original grant period being April 2022 through April 2024. However, funding wasn't received until April 2023 and the Sheriff's Department received a grant extension through October 2024. The Sheriff's Clerk prepared a spreadsheet to base the retention and incentive payments on 10% of the annual salaries for dispatchers and deputies using their pay rates as of May 2022. This 10% annual amount was then to be paid over 24 months. Due to the delay of the grant start date, the first payment not made until 2023. During 2024, payments 7 through 10 were made lacking documentation of how the payment amounts were calculated. There was no supporting documentation on file for how new employees were added to the grant or how the amount allocated for new employees was calculated. While these payments were allowable for the purpose of retention of employees there were not sufficient internal controls in place for the calculation of the payments made over the life of the grant as the calculations changed throughout the year as employees left and were replaced. For most new employees, a bi-monthly flat rate not related to a percentage of their salary was paid. These flat rates were not approved by the Sheriff to be used in place of the 10% annual max calculations. Due to the lack of supporting documentation on file to determine how the Sheriff's Clerk calculated the retention payments to employees, we calculated a maximum of 10% annual salary per employee using 2022 hourly rates for those employed in 2022 and 2023 hourly rates for new employees in 2023, and 2024 hourly rate for new employees in 2024. We then divided that amount by 24 months as the one year annual amount was to be paid across two years to get a monthly incentive amount and then multiplied the monthly amount by the number of months actually employed during the grant period. We compared our recalculated amounts to amounts actually paid through the final payment in 2024 to determine if there were any over payments over the life of the grant. We noted that amounts paid to employees from Payment 7 through Payment 10 covering March through October 2024 were not adequately documented as we could not recalculate the bi-monthly payments totaling $13,476.52 in salaries and $2,072 in related benefits though we did note no employee received greater than 10% of their annual salary maximum. Lack of supporting documentation could result in noncompliance and/or questioned costs. The Sheriff's office should implement procedures to ensure all supporting documentation for grant payments are maintained. Actual amounts paid by grant funds to employees should be supported by calculations and changes to the calculations should be approved. The grant was completed as of December 31, 2024.

Corrective Action Plan

The Sheriff’s Office has separated from the person who oversaw these grants. New procedures have been implemented, and the Chief Deputy is now involved in overseeing these grants as well.

Categories

Procurement, Suspension & Debarment Allowable Costs / Cost Principles Period of Performance Matching / Level of Effort / Earmarking Internal Control / Segregation of Duties

Other Findings in this Audit

  • 1177634 2024-006
    Material Weakness Repeat
  • 1177635 2024-006
    Material Weakness Repeat
  • 1177636 2024-006
    Material Weakness Repeat
  • 1177637 2024-006
    Material Weakness Repeat
  • 1177638 2024-006
    Material Weakness Repeat
  • 1177639 2024-007
    Material Weakness Repeat
  • 1177640 2024-007
    Material Weakness Repeat
  • 1177641 2024-007
    Material Weakness Repeat
  • 1177642 2024-007
    Material Weakness Repeat
  • 1177644 2024-008
    Material Weakness Repeat
  • 1177645 2024-008
    Material Weakness Repeat
  • 1177646 2024-009
    Material Weakness Repeat
  • 1177647 2024-009
    Material Weakness Repeat
  • 1177648 2024-009
    Material Weakness Repeat
  • 1177649 2024-009
    Material Weakness Repeat
  • 1177650 2024-009
    Material Weakness Repeat
  • 1177651 2024-009
    Material Weakness Repeat
  • 1177652 2024-009
    Material Weakness Repeat
  • 1177653 2024-009
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
93.558 TEMPORARY ASSISTANCE FOR NEEDY FAMILIES $1.57M
93.778 MEDICAL ASSISTANCE PROGRAM $1.06M
93.667 SOCIAL SERVICES BLOCK GRANT $809,859
93.563 CHILD SUPPORT SERVICES $613,347
93.658 FOSTER CARE TITLE IV-E $602,575
10.561 STATE ADMINISTRATIVE MATCHING GRANTS FOR THE SUPPLEMENTAL NUTRITION ASSISTANCE PROGRAM $281,442
97.067 HOMELAND SECURITY GRANT PROGRAM $270,772
14.228 COMMUNITY DEVELOPMENT BLOCK GRANTS/STATE'S PROGRAM AND NON-ENTITLEMENT GRANTS IN HAWAII $191,324
14.239 HOME INVESTMENT PARTNERSHIPS PROGRAM $190,870
93.767 CHILDREN'S HEALTH INSURANCE PROGRAM $152,495
17.259 WIOA YOUTH ACTIVITIES $141,179
93.659 ADOPTION ASSISTANCE $132,705
17.258 WIOA ADULT PROGRAM $116,480
17.278 WIOA DISLOCATED WORKER FORMULA GRANTS $78,575
84.027 SPECIAL EDUCATION GRANTS TO STATES $47,318
93.575 CHILD CARE AND DEVELOPMENT BLOCK GRANT $45,838
93.645 STEPHANIE TUBBS JONES CHILD WELFARE SERVICES PROGRAM $44,664
21.027 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $20,698
93.556 MARYLEE ALLEN PROMOTING SAFE AND STABLE FAMILIES PROGRAM $20,316
97.042 EMERGENCY MANAGEMENT PERFORMANCE GRANTS $16,780
10.555 NATIONAL SCHOOL LUNCH PROGRAM $15,204
21.032 LOCAL ASSISTANCE AND TRIBAL CONSISTENCY FUND $11,906
17.225 UNEMPLOYMENT INSURANCE $11,460
93.472 TITLE IV-E PREVENTION PROGRAM $10,314
10.553 SCHOOL BREAKFAST PROGRAM $10,165
84.173 SPECIAL EDUCATION PRESCHOOL GRANTS $8,512
90.404 HAVA ELECTION SECURITY GRANTS $6,871
20.703 INTERAGENCY HAZARDOUS MATERIALS PUBLIC SECTOR TRAINING AND PLANNING GRANTS $6,600
20.106 AIRPORT IMPROVEMENT PROGRAM, INFRASTRUCTURE INVESTMENT AND JOBS ACT PROGRAMS, AND COVID-19 AIRPORTS PROGRAMS $5,967
93.674 JOHN H. CHAFEE FOSTER CARE PROGRAM FOR SUCCESSFUL TRANSITION TO ADULTHOOD $4,576
10.665 SCHOOLS AND ROADS - GRANTS TO STATES $2,507
93.747 ELDER ABUSE PREVENTION INTERVENTIONS PROGRAM $2,348
15.226 PAYMENTS IN LIEU OF TAXES $1,991
20.608 MINIMUM PENALTIES FOR REPEAT OFFENDERS FOR DRIVING WHILE INTOXICATED $1,511
15.438 NATIONAL FOREST ACQUIRED LANDS $960
17.207 EMPLOYMENT SERVICE/WAGNER-PEYSER FUNDED ACTIVITIES $540
17.245 TRADE ADJUSTMENT ASSISTANCE $87