Finding 977227 (2023-001)

Significant Deficiency
Requirement
B
Questioned Costs
-
Year
2023
Accepted
2024-06-13

AI Summary

  • Core Issue: There were discrepancies between employee timesheets and payroll registers for federal grants, indicating weak internal controls over compliance.
  • Impacted Requirements: Compliance procedures were not followed, leading to undercharging of grants and inadequate documentation of time and effort.
  • Recommended Follow-Up: Management must verify that amounts charged to grants align with timesheets and payroll records 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

  • 400782 2023-001
    Significant Deficiency Repeat
  • 400783 2023-001
    Significant Deficiency Repeat
  • 400784 2023-001
    Significant Deficiency Repeat
  • 400785 2023-001
    Significant Deficiency
  • 977224 2023-001
    Significant Deficiency Repeat
  • 977225 2023-001
    Significant Deficiency Repeat
  • 977226 2023-001
    Significant Deficiency Repeat

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 $448,694
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $276,790
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.575 Child Care and Development Block Grant $81,058
93.324 State Health Insurance Assistance Program $71,058
93.042 Special Programs for the Aging: Title Vii, Chapter 2, Long Term Care Ombudsman Services for Older Individuals $50,794
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.767 Children's Health Insurance Program $12,253
93.558 Temporary Assistance for Needy Families $2,764