Finding 35399 (2022-004)

Significant Deficiency Repeat Finding
Requirement
B
Questioned Costs
-
Year
2022
Accepted
2023-07-24

AI Summary

  • Core Issue: An employee was underpaid by $128 due to a misinterpretation of hours worked, affecting grant charges.
  • Impacted Requirements: Compliance with 2 CFR Part 200, which mandates accurate payroll records and internal controls for federal awards.
  • Recommended Follow-Up: Review and improve payroll procedures to ensure all hours are accurately recorded and charged to the grant.

Finding Text

Federal Agency: Department of Health and Human Services Federal Program Title: Aging Cluster Assistance Listing Number: 93.AGING Federal Award Identification Number and Year: 2101COSSC6-00 - 2021 Pass-Through Agency: Colorado Department of Human Services Pass-Through Number: None provided Award Period: February 1, 2021 ? September 30, 2023 Type of Finding: Significant Deficiency in Internal Control over Compliance and Other Matter Criteria or Specific Requirement: 2 CFR Part 200 Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Award requires charges to federal awards for salaries and wages be based on records that accurately reflect the work performed. These records must be supported by a system of internal controls which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. Condition: One hourly employee?s wages was underpaid and were not charged to the grant when compared to the hours per the approved timesheet. Questioned Costs: None Context: For one payroll transaction of five tested, the hourly employee?s gross wages were underpaid and undercharged to the grant by $128 based on four hours that were improperly omitted from final payroll. Cause: Entering payroll into QuickBooks using the approved timesheet for hourly employees is a manual process. For this individual, the timesheet reported 84 hours of regular pay and four hours of paid staff leave. Four regular pay hours were improperly omitted from the hours paid as these were misinterpreted to be the four hours of paid hourly staff leave. Effect: For the June 30, 2022 pay period, the employee was underpaid, and the grant was undercharged a total of $128. Repeat Finding: The finding is a repeat of a finding in the immediately prior year. Prior year finding number was 2021-002. Recommendation: We recommend the Council review its payroll procedures over hourly employees to ensure all hours are properly accounted for by pay code in the final payroll. Views of Responsible Officials: There is no disagreement with the audit finding.

Corrective Action Plan

AGING CLUSTER ? Assistance Listing No. 93.AGING Recommendation: We recommend the Council review its payroll procedures over hourly employees to ensure all hours are properly accounted for by pay code in the final payroll. Explanation of disagreement with audit finding: There is no disagreement with the audit finding. Action taken in response to finding: The Fiscal staff will review timesheet formats and search for possible improvements to the existing templates. Since this incident occurred, the Council has split the former Fiscal Coordinator position into two separate roles. This allows each employee to spend additional time on a fewer number of employees during payroll and review each timesheet with a high level of detail. Fiscal staff will continue to focus on precautions to reduce risk of error and employees will be encouraged to review their paystubs after each pay period. Name(s) of the contact person(s) responsible for corrective action: Becky Walter, Fiscal Manager Planned completion date for corrective action plan: December 31, 2023

Categories

Allowable Costs / Cost Principles Significant Deficiency Internal Control / Segregation of Duties

Other Findings in this Audit

  • 35397 2022-002
    Significant Deficiency
  • 35398 2022-003
    Significant Deficiency
  • 611839 2022-002
    Significant Deficiency
  • 611840 2022-003
    Significant Deficiency
  • 611841 2022-004
    Significant Deficiency Repeat

Programs in Audit

ALN Program Name Expenditures
81.042 Weatherization Assistance for Low-Income Persons $2.12M
14.228 Community Development Block Grants $1.76M
97.067 Homeland Security Grant Program $333,270
93.044 Special Programs for the Aging_title Iii, Part B_grants for Supportive Services $305,651
93.045 Special Programs for the Aging_title Iii, Part C-1 $295,588
93.889 National Bioterrorism Hospital Preparedness Program $190,080
11.307 Economic Adjustment Assistance $174,050
93.045 Special Programs for the Aging_title Iii, Part C-2 $172,032
20.513 Capital Assistance Program for Elderly Persons and Persons with Disabilities $76,800
11.302 Economic Development_support for Planning Organizations $70,000
93.044 Special Programs for the Aging_title Iii, Admin $65,016
93.052 National Family Caregiver Support, Title Iii, Part E $40,790
93.044 Special Programs for the Aging_covid-19 - Arpa, Title Iii, Admin $40,171
93.044 Special Programs for the Aging_covid-19 - Arpa, Title Iii, Part B Grants for Supportive Services $34,469
93.045 Special Programs for the Aging_title Iii, Nsip C-1 $22,438
93.044 Special Programs for the Aging_covid-19 - Title Iii, Colorado Vaccine Act $17,763
94.002 Cooperative Development Program $16,178
93.889 Covid-19 - National Bioterrorism Hospital Preparedness Program $12,790
10.351 Rural Business Development Grant $8,472
93.043 Special Programs for the Aging_title Iii, Part D_disease Prevention and Health Promotion Services $3,755
93.044 Special Programs for the Aging_covid-19 - Arpa, Title Iii, Public Health $2,161
93.042 Special Programs for the Aging_title Vii, Chapter 2_long Term Care Ombudsman Services for Older Individuals $28