Finding 1072826 (2023-001)

Significant Deficiency Repeat Finding
Requirement
B
Questioned Costs
-
Year
2023
Accepted
2024-09-10

AI Summary

  • Core Issue: There was a significant deficiency in internal controls over compliance, leading to discrepancies between payroll transactions and employee timesheets for federal grants.
  • Impacted Requirements: Internal control procedures were not followed, resulting in undercharging of grants and inadequate documentation of time and effort.
  • Recommended Follow-up: Management should verify that amounts charged to grants match timesheets and payroll registers before submitting reimbursement requests.

Finding Text

Finding 2023-001: Allowable costs – significant deficiency in internal controls over compliance and compliance finding. Community Services Block Grant ALN 93.569 Emergency Rental Assistance Program ALN 21.023 Criteria: The Council’s internal control procedures over compliance specify that all employees timesheets and hours agree to the payroll register and amount allocated to grant activities. Condition: During allowable cost testing for federal grants, for 8 of the 65 payroll transactions tested, the amount charged to the grant did not agree to the employee's timesheet. Cause: Prior to May 2023, percentage labor distributions were based on grant budgeted allocations in our payroll system for those employees working out of multiple service categories. Additionally, service category descriptions in the payroll system did not match 100% with the general ledger service category descriptions. Effect: The Council's reporting of grant time and effort was not fully documented, in accordance with internal control over compliance procedures. The cumulative effect of the exceptions noted during tested resulted in the grants being undercharged by the Council. Per Management's Corrective Action plan, this finding was fully resolved as of April 2024. Questioned Costs: None Recommendation: Management should ensure amount charged to the grants agree to timesheets and payroll registers before the request for reimbursement is submitted. Management’s Response: The corrective action plan detailed on page 31 was fully implemented as of April 2024.

Categories

Allowable Costs / Cost Principles Cash Management Reporting Significant Deficiency

Other Findings in this Audit

  • 496383 2023-001
    Significant Deficiency Repeat
  • 496384 2023-001
    Significant Deficiency Repeat
  • 496385 2023-001
    Significant Deficiency Repeat
  • 496386 2023-001
    Significant Deficiency
  • 1072825 2023-001
    Significant Deficiency Repeat
  • 1072827 2023-001
    Significant Deficiency Repeat
  • 1072828 2023-001
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
93.045 Special Programs for the Aging: Title Iii, Part C, Nutrition Services $4.27M
93.044 Special Programs for the Aging: Title Iii, Part B Grants for Supportive Services and Senior Centers $3.46M
93.569 Community Services Block Grant $1.88M
21.023 Emergency Rental Assistance Program $1.54M
93.052 National Family Caregiver Support, Title Iii, Part E $1.32M
93.778 Medical Assistance Program $375,162
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $231,429
93.368 21st Century Cures Act - Precision Medicine Initiative $221,088
93.053 Nutrition Services Incentive Program $172,248
97.024 Emergency Food and Shelter National Board Program $87,198
93.043 Special Programs for the Aging: Title Iii, Part D, Disease Prevention and Health Promotion Services $82,661
93.324 State Health Insurance Assistance Program $71,058
93.747 Elder Abuse Prevention Interventions Program $37,508
93.071 Medicare Enrollment Assistance Program $33,639
93.734 Empowering Older Adults and Adults with Disabilities Through Chronic Disease Self-Management Education Programs- Financed by Prevention and Public Health Funds $28,316
93.042 Special Programs for the Aging: Title Vii, Chapter 2, Long Term Care Ombudsman Services for Older Individuals $13,286
93.767 Children's Health Insurance Program $11,448
93.558 Temporary Assistance for Needy Families $2,714