Finding 1216651 (2025-002)

Material Weakness Repeat Finding
Requirement
A
Questioned Costs
-
Year
2025
Accepted
2026-06-04
Audit: 403105
Organization: Brenda Thibeault (CT)

AI Summary

  • Core Issue: Payroll allocations to federal awards were not consistently supported by employee time records, leading to discrepancies.
  • Impacted Requirements: Compliance with OMB Cost Principles and Uniform Guidance regarding accurate recording of expenditures and payroll costs.
  • Recommended Follow-Up: Implement reconciliation procedures to ensure payroll allocations match actual time worked before journal entries are posted.

Finding Text

Federal Agency: Department of Health and Human Services Federal Program Name: Block Grants for Community Mental Health Services and Block Grants for Prevention and Treatment of Substance Abuse Federal Assistance Listing Number: 93.958 and 93.959 Pass-Through Agency: State of Connecticut Department of Mental Health and Addiction Services, and State of Connecticut Department Children and Family Services Award Period: 7/1/2024-6/30/2025 and 3/1/2023-8/31/2025 Type of Finding: Allowed Costs in Relation of Payroll Allocations Criteria or Specific Requirement: The Office of Management and Budget (OMB) Cost Principles and Uniform Guidance require expenditures charged to federal awards to be recorded in accordance with applicable cost standards and the entity’s cost allocation policies, including proper allocations of payroll related costs. Time and effort reported must correspond to the actual hours worked and be consistent with the allocations of payroll costs reflected in the entity’s payroll records and general ledger. Condition: During testing of payroll transactions charged to federal awards, exceptions were identified across four employees in which the hours reflected on employee time cards did not agree to the labor costs allocated to federal awards in the general ledger and/or journal entries. The discrepancies noted indicate that payroll allocations to federal programs were not consistently supported by the underlying time records maintained by the entity. However, all federal funding is from Department of Health and Human Services. Questioned Costs: Immaterial Context: The exceptions identified relate to discrepancies between actual time worked as documented on employee time cards and the labor costs recorded and allocated to federal programs within the general ledger. While the employees performed work during the relevant periods and total payroll costs were accurately stated, the allocations to federal awards were not supported by the underlying time card records, resulting in labor charges to federal programs that were not reflective of actual time and effort spent on those programs. Cause: The payroll allocation process was not reconciled to individual employee time card records prior to posting journal entries to the general ledger. Recommendation: Management should implement reconciliation procedures to ensure that payroll allocations recorded to federal award programs are supported by and agree to actual time records prior to recording journal entries to the general ledger. Views of Responsible Officials and Planned Corrective Action: Management concurs with the finding.

Corrective Action Plan

Management will implement reconciliation procedures to ensure that payroll allocations recorded to federal award programs are supported by and agree to actual time records prior to recording journal entries to the general ledger. A supervisory review process will be established to periodically compare time card data against payroll journal entries to identify and resolve discrepancies on a timely basis.

Categories

Allowable Costs / Cost Principles

Other Findings in this Audit

  • 1216641 2025-002
    Material Weakness Repeat
  • 1216642 2025-003
    Material Weakness Repeat
  • 1216643 2025-002
    Material Weakness Repeat
  • 1216644 2025-003
    Material Weakness Repeat
  • 1216645 2025-001
    Material Weakness Repeat
  • 1216646 2025-002
    Material Weakness Repeat
  • 1216647 2025-003
    Material Weakness Repeat
  • 1216648 2025-002
    Material Weakness Repeat
  • 1216649 2025-003
    Material Weakness Repeat
  • 1216650 2025-001
    Material Weakness Repeat
  • 1216652 2025-003
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
93.788 OPIOID STR $136,200
93.958 BLOCK GRANTS FOR COMMUNITY MENTAL HEALTH SERVICES $65,222
93.245 Connecticut Partnerships for Hope and Healing Substance Abuse and Mental Health Services Administration’s Cooperative Agreements for the Garrett Lee Smith State/Tribal Youth Suicide Prevention and Early Intervention Program $35,646
93.243 SUBSTANCE ABUSE AND MENTAL HEALTH SERVICES PROJECTS OF REGIONAL AND NATIONAL SIGNIFICANCE $22,855
21.027 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $7,040
93.959 BLOCK GRANTS FOR PREVENTION AND TREATMENT OF SUBSTANCE ABUSE $2,000
93.669 CHILD ABUSE AND NEGLECT STATE GRANTS $700