Finding 1168822 (2022-005)

Material Weakness Repeat Finding
Requirement
A
Questioned Costs
-
Year
2022
Accepted
2026-01-12
Audit: 381011
Organization: Bell County (TX)

AI Summary

  • Core Issue: Missing documentation for payroll calculations led to unsupported pay rates and timesheets for several employees.
  • Impacted Requirements: Non-compliance with generally accepted control procedures and 2 CFR 200.302, risking incorrect employee payments and classification errors.
  • Recommended Follow-Up: Ensure all payroll records are retained and approved by managers before payroll runs; implement strengthened documentation procedures starting January 2025.

Finding Text

Condition: 1- Gross payroll calculations could not be supported for several employees tested due to missing pay rate support. 2- Gross payroll calculations could not be supported for several employees tested due to missing timesheets. 3- Classification errors were noted in 2 of 11 periods tested (34 of 86 individuals tested). Criteria: Generally accepted control procedure and 2 CFR 200.302 Cause of Condition: Missing documentation resulted in conditions 1 and 2. The cause of the classification differences between the accounting department’s payroll worksheet and the general ledger postings are unknown. Due to staff turnover, the cause could not be determined. Effect of Condition: Employees may be paid at unapproved rates or for unworked time. Classification errors may result in over/under charging grant programs.Questioned Costs: Condition 1: Known: $ 412.54 Questioned: $ 5,580.24 Condition 2: Known: $ 20,357.31 Questioned: n/a Condition 3: Known: $ 91,593.05 Questioned: n/a Recommendation: We recommend: - Records be retained to support all transactions recorded to the general ledger. - Department managers review and approve all payroll-related source documents (personnel action forms, timesheets, etc.) prior to finalizing the payroll run. - Administrative manager review and approve payroll worksheet prior to finalizing the payroll run and posting to the general ledger. Corrective Action Plan: Beginning January 2025, the District strengthened payroll documentation and review procedures to ensure compliance with 2 CFR 200.302. Personnel Action Forms and timesheets will be required, approved by department managers, and retained electronically for all employees. The Administrative staff reviews and approves payroll worksheets prior to posting to the general ledger. All department managers and administrative staff will attend training and routine follow-up training on purchasing policies and procedures. A sign in sheet will be required for those attending. Contact Person: Grant Accounting Specialist Anticipated Completion Date: 01/31/2026

Corrective Action Plan

Condition: 1- Gross payroll calculations could not be supported for several employees tested due to missing pay rate support. 2- Gross payroll calculations could not be supported for several employees tested due to missing timesheets. 3- Classification errors were noted in 2 of 11 periods tested (34 of 86 individuals tested). Criteria: Generally accepted control procedure and 2 CFR 200.302 Cause of Condition: Missing documentation resulted in conditions 1 and 2. The cause of the classification differences between the accounting department’s payroll worksheet and the general ledger postings are unknown. Due to staff turnover, the cause could not be determined. Effect of Condition: Employees may be paid at unapproved rates or for unworked time. Classification errors may result in over/under charging grant programs.Questioned Costs: Condition 1: Known: $ 412.54 Questioned: $ 5,580.24 Condition 2: Known: $ 20,357.31 Questioned: n/a Condition 3: Known: $ 91,593.05 Questioned: n/a Recommendation: We recommend: - Records be retained to support all transactions recorded to the general ledger. - Department managers review and approve all payroll-related source documents (personnel action forms, timesheets, etc.) prior to finalizing the payroll run. - Administrative manager review and approve payroll worksheet prior to finalizing the payroll run and posting to the general ledger. Corrective Action Plan: Beginning January 2025, the District strengthened payroll documentation and review procedures to ensure compliance with 2 CFR 200.302. Personnel Action Forms and timesheets will be required, approved by department managers, and retained electronically for all employees. The Administrative staff reviews and approves payroll worksheets prior to posting to the general ledger. All department managers and administrative staff will attend training and routine follow-up training on purchasing policies and procedures. A sign in sheet will be required for those attending. Contact Person: Grant Accounting Specialist Anticipated Completion Date: 01/31/2026

Categories

No categories assigned yet.

Other Findings in this Audit

  • 1168818 2022-001
    Material Weakness Repeat
  • 1168819 2022-002
    Material Weakness Repeat
  • 1168820 2022-003
    Material Weakness Repeat
  • 1168821 2022-004
    Material Weakness Repeat
  • 1168823 2022-006
    Material Weakness Repeat
  • 1168824 2022-007
    Material Weakness Repeat
  • 1168825 2022-008
    Material Weakness Repeat
  • 1168826 2022-009
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
10.557 WIC SPECIAL SUPPLEMENTAL NUTRITION PROGRAM FOR WOMEN, INFANTS, AND CHILDREN $3.40M
93.268 IMMUNIZATION COOPERATIVE AGREEMENTS $300,000
93.354 PUBLIC HEALTH EMERGENCY RESPONSE: COOPERATIVE AGREEMENT FOR EMERGENCY RESPONSE: PUBLIC HEALTH CRISIS RESPONSE $281,334
93.778 MEDICAL ASSISTANCE PROGRAM $267,445
93.069 PUBLIC HEALTH EMERGENCY PREPAREDNESS $194,359
93.116 PROJECT GRANTS AND COOPERATIVE AGREEMENTS FOR TUBERCULOSIS CONTROL PROGRAMS $58,296
93.991 PREVENTIVE HEALTH AND HEALTH SERVICES BLOCK GRANT $55,966
93.323 EPIDEMIOLOGY AND LABORATORY CAPACITY FOR INFECTIOUS DISEASES (ELC) $48,556
93.217 FAMILY PLANNING SERVICES $10,685