Finding 50958 (2022-008)

Material Weakness Repeat Finding
Requirement
B
Questioned Costs
$1
Year
2022
Accepted
2023-07-13
Audit: 53429
Organization: Ucan (IL)
Auditor: Rsm US LLP

AI Summary

  • Core Issue: Two employees did not complete required 100% Time Certificates, and seven employees failed to submit Personnel Activity Reports, leading to unallowable costs.
  • Impacted Requirements: Noncompliance with Article 23 of the grant agreement and 2 CFR 200.430 regarding accurate salary and time reporting.
  • Recommended Follow-Up: Enhance internal controls to ensure timely completion of certifications and reports, and verify compliance with grant requirements.

Finding Text

Finding 2022-008: Unallowable cost?salary certification and personnel activity reports Repeat Finding Yes (2021-009) Federal Program Title: U.S. Department of Justice Passed through Illinois Criminal Justice Information Authority 16.575; Crime Victim Assistance Award Year Award# 219040: March 23, 2021 ? May 31, 2022 Award# 220040: June 1, 2022 ? November 30, 2023 Criteria: Article 23 of the Illinois Criminal Justice Information Authority grant agreement states that personnel who spend 100% of their time on the funded program must certify on a semi-annual basis. Additionally, Article 23 of the Illinois Criminal Justice Information Authority grant agreement states that personnel who spend less than 100% of their time on the funded program must maintain Personnel Activity Reports (PAR) that accurately reflects the time the employee spends performing the program and any other duties. 2 CFR 200.430 requires that charges to federal awards for salaries and wages must be based on records that accurately reflect the work performed. Condition: There were two employees designated as spending 100% of their time on the grant who did not complete their 100% Time Certificates. There were also seven employees allocated at less than 100% to the grant who did not complete any Personnel Activity Reports during the fiscal year. Of the Personnel Activity Reports that we were able to review, all were completed significantly after the fact rather than during the grant period tested. Cause: Due to turnover in program staffing, program oversight was not performed timely. Effect: Unallowable costs were submitted for reimbursement causing UCAN to be in noncompliance with Article 23 of the grant agreement. Questioned costs: We are unable to determine if the two employees allocated 100% to the grant actually worked 100% of their time on the funded program. These five selections resulted in $7,832 of questioned cost, based on the portion of the salary we tested. For the seven employees allocated at less than 100% to the grant, we are unable to determine the amount of time that the employees worked on the funded program, therefore 11 selections resulted in questioned costs of $13,395, representing the amount tested. In total, the questioned costs are $21,227. Context: Out of 12 employees tested who were allocated 100% to the grant, there were two employees where a self-certification was not completed during the year. This represented 2 out of 42 transactions tested. Out of 10 employees tested who were allocated to the grant at less than 100%, there were seven employees where a Personnel Activity Report was not completed during the year. Of the 18 transactions tested where personnel charged less than 100% to the grant, 11 of the Personnel Activity Reports were not prepared. Recommendation: We recommend that management improve internal controls for identifying and communicating compliance requirements per the grant agreement. Further, we recommend that management implement an internal control activity to verify that all employees charging 100% of their time to the funded program complete a self-certification on a semi-annual basis and that all employees charging less than 100% of their time to the funded program complete a Personnel Activity Report. All Personnel Activity Reports should be completed and reviewed timely. Views of responsible officials: Management agrees with this finding. Please see corrective action plan attached.

Corrective Action Plan

Identifying Number: 2022-008 Finding: Unallowable cost ? salary certification and personnel activity reports Corrective Actions Taken or Planned: UCAN agrees with this finding and believes the turnover in personnel affected this area as there was a misunderstanding on what was required. Employees in leadership positions have been trained on what is required and are ensuring that all staff certifications are being gathered monthly. This is a repeat finding, with the original corrective action plan to be completed before December 31, 2022. We do believe that corrective actions that have been taken have resolved this issue. Contact person is Kimberly Parish, Chief Financial Officer and she can be reached at kim.parish@ucanchicago.org.

Categories

Questioned Costs Allowable Costs / Cost Principles Internal Control / Segregation of Duties

Other Findings in this Audit

  • 47968 2022-010
    Significant Deficiency Repeat
  • 47969 2022-011
    Significant Deficiency
  • 47970 2022-012
    Significant Deficiency Repeat
  • 47971 2022-013
    Significant Deficiency Repeat
  • 48072 2022-007
    Significant Deficiency Repeat
  • 50959 2022-009
    Significant Deficiency Repeat
  • 624410 2022-010
    Significant Deficiency Repeat
  • 624411 2022-011
    Significant Deficiency
  • 624412 2022-012
    Significant Deficiency Repeat
  • 624413 2022-013
    Significant Deficiency Repeat
  • 624514 2022-007
    Significant Deficiency Repeat
  • 627400 2022-008
    Material Weakness Repeat
  • 627401 2022-009
    Significant Deficiency Repeat

Programs in Audit

ALN Program Name Expenditures
16.575 Crime Victim Assistance $890,857
94.011 Foster Grandparent Program $419,581
17.259 Wioa Youth Activities $290,970
10.555 National School Lunch Program $58,272
10.553 School Breakfast Program $38,333