Finding 1229212 (2023-003)

Material Weakness Repeat Finding
Requirement
B
Questioned Costs
-
Year
2023
Accepted
2026-09-09
Audit: 410701
Organization: City of Jacksonville Arkansas (AR)

AI Summary

  • Core Issue: Incorrect pay rates were used in payroll calculations for federal disaster grants, leading to overstated costs.
  • Impacted Requirements: Compliance with 2 CFR § 200.430, which mandates accurate records for payroll costs charged to federal awards.
  • Recommended Follow-Up: Strengthen payroll review procedures to ensure costs are calculated using authorized pay rates before reimbursement.

Finding Text

Disaster Grants – Public Assistance (Presidentially Declared Disasters) Assistance Listing No. 97.036 US Department of Homeland Security Federal Award Year: 2023 Criteria - In accordance with 2 CFR § 200.430, compensation for personal services charged to a federal award must be based on records that accurately reflect the work performed and support the payroll costs charged to the federal program. Internal controls should ensure that payroll expenditures charged to federal awards are calculated using authorized and accurate pay rates. Condition - During our testing of payroll costs charged to ALN 97.036, we identified one instance in which employee's payroll cost was calculated using an incorrect pay rate. As a result, the payroll expenditure charged to the federal program was overstated. Cause - The City's controls over payroll cost calculations were not operating effectively to ensure payroll expenditures charged to the federal award were calculated using the correct authorized pay rate. Effect or Potential Effect - Payroll expenditures charged to the federal award may not be supported by accurate compensation records, resulting in the reimbursement of unallowable costs and noncompliance with federal requirements. Questioned Costs - $152 Context - One of the seventeen payroll transactions tested (6%) was determined to be calculated using the incorrect payrate. This represents $10 of the $29,919 sampled costs. The sampling methodology used is not, and is not intended to be, statistically valid. Identification as a repeat finding - No Recommendation - We recommend management strengthen its review procedures over payroll expenditures charged to federal awards to ensure payroll costs are calculated using approved and authorized pay rates prior to reimbursement and reporting. Views of Responsible Officials and Planned Corrective Actions - Management concurs with the finding and will enhance its payroll review procedures to verify that payroll costs charged to federal awards are calculated using the correct authorized pay rates

Corrective Action Plan

Finding #2023-003 – Statement of Condition: During our testing of payroll costs charged to ALN 97.036, we identified one instance in which employee's payroll cost was calculated using an incorrect pay rate. As a result, the payroll expenditure charged to the federal program was overstated. Response: Management concurs with the finding and will enhance its payroll review procedures to verify that payroll costs charged to federal awards are calculated using the correct authorized pay rates. The matter was corrected by December 31, 2024

Categories

Allowable Costs / Cost Principles

Other Findings in this Audit

  • 1229211 2023-002
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
20.205 HIGHWAY PLANNING AND CONSTRUCTION $7.36M
97.036 DISASTER GRANTS - PUBLIC ASSISTANCE (PRESIDENTIALLY DECLARED DISASTERS) $933,539
16.922 EQUITABLE SHARING PROGRAM $98,582
14.218 COMMUNITY DEVELOPMENT BLOCK GRANTS/ENTITLEMENT GRANTS $54,591
12.610 COMMUNITY ECONOMIC ADJUSTMENT ASSISTANCE FOR COMPATIBLE USE AND JOINT LAND USE STUDIES $52,490
16.738 EDWARD BYRNE MEMORIAL JUSTICE ASSISTANCE GRANT PROGRAM $25,036
16.000 DRUG TASK FORCE OVERTIME $18,014
16.607 BULLETPROOF VEST PARTNERSHIP PROGRAM $10,051