Finding 45776 (2022-001)

Significant Deficiency
Requirement
B
Questioned Costs
-
Year
2022
Accepted
2023-02-14
Audit: 40574
Organization: Sheltercare (OR)
Auditor: Jones & Roth PC

AI Summary

  • Core Issue: There are significant deficiencies in internal controls over compliance related to the Emergency Rental Assistance Program, specifically in how employee time is recorded and billed.
  • Impacted Requirements: The lack of consistent application of internal control policies risks charging incorrect or unallowable costs to federal grants, violating the allowable costs criteria under Uniform Guidance.
  • Recommended Follow-Up: Management should enhance the review process for timesheet data and ensure all activity reports are completed and approved before billing to improve accuracy and compliance.

Finding Text

Finding 2022-001 Federal Award Program: Emergency Rental Assistance Program (Assistance Listing # 21.023) Pass-through Agency: Lane County Type of Finding: Significant deficiency in internal controls over compliance Compliance Requirement: Allowable costs Criteria: The Uniform Guidance (2 CFR ?200.430) states that costs of compensation are allowable to the extent they are reasonable for the services rendered and conform to the established written policy of the non-Federal entity consistently applied to both Federal and non-Federal activities; and follow an appointment made in accordance with a non-Federal entity's laws and/or rules or written policies and meets the requirements of Federal statute, where applicable. ShelterCare?s written policies rely on the use of timesheets, activity reports (which document actual hours worked by program/grant) and an excel billing worksheet to charge time to federal program grants. Condition: We noted instances in which the internal control policies were inconsistently applied to the process of recording and billing employees? time. We also noted instances in which time sheets and activity reports were missing employee and supervisor signatures indicating approval. We also noted instances in which information from the activity reports did not agree to the underlying timesheets. Cause of Condition: Internal control policies and procedures were not consistently applied to the process for timesheet review and approval, completion of activity reports and preparation of billings for the federal program grants. There was not adequate review of the billings against the underlying support (timesheets and activity reports) to catch input errors in the billings. Effect of Condition: This condition increases the risk that the incorrect amount of costs and/or unallowable costs would be charged to the federal program. Questioned Costs: No reportable questioned costs. Context: Our sample size was 40 payroll transactions and was not a statistically valid sample as it was selected haphazardly. We noted two instances in our sample in which timesheets and activity reports were missing employee and supervisor signatures indicating approval. We noted two instances in which information input into the billing did not agree to the underlying data in the activity reports and timesheets. Repeat Finding: No. Recommendation: We recommend management review the current process used to transfer data from the timesheet to the activity report to the billing worksheets and institute additional layers of review of the data to ensure data is accurately allocated and reported in the billing worksheets for which the costs charged to the grants are derived. We also recommend management consistently apply procedures to ensure activity reports are completed for all employees charging time to programs and appropriate approvals are obtained prior to billings. View of Responsible Officials: Management agrees with the finding. See Corrective Action Plan.

Corrective Action Plan

Finding 2022-001 Management?s Response and Planned Corrective Actions: Management and staff responsible for the EARS (Activity Reports) process and grants/contracts billing oversight have reviewed the current process. The following will be either added to the process or completed to ensure accuracy of data on the billing worksheet. 1. Improve accuracy and timeliness of data through meeting and discussion with program managers and supervisors. Education for managers/supervisors will be conducted so they understand exactly what to review on each timesheet, the accuracy of the data compared to what is on the timekeeping software and that the timesheet is complete. They will help to develop processes on their end to ensure staff are completing these correctly. The process will be added to program manager and supervisor orientation training and checklist. 2. Currently, the staff member completing the EARS timesheet entry and billing workbook completes a double check of data and ensure every line of hours matches timekeeping software (not just the total hours) . This will be added to the procedure. 3. At the time of hire notification, payroll staff will send an email to Program Manager to request clarification if new staff member will be completing EARS (timesheet) and verification that new staff member has the form and has been trained. This will also be added to the Staff Member Orientation checklist completed by supervisors. 4. Every two weeks, after the payroll clerk has completed the EARS checklist, the controller will verify that every staff member timesheet has been received and new or terminated staff members are noted on the checklist. A second page will be created on the checklist to account for staff members who do not complete EARS. Any changes (new or termed staff) will be accounted for so that we have a complete list of who completes EARS and which staff members do not. 5. At the end of fiscal calendar, controller will notify payroll staff creating the Billing Backup report with the new Fringe calculation to be added to the workbook. Controller will verify the fringe number is correct in the workbook before any billing begins for the new fiscal year. Payroll staff member will also add to staff calendar to ensure that information is received when creating the spreadsheet for the new fiscal period. ? The name of the contact person(s) responsible for the corrective actions: Kathleen Broadhurst, Senior Director of Finance, Cathy Fisher, Controller, and Dorothy Conn, Payroll Administrator. ? The corrective action planned: See above comments ? The anticipated completion date: o The internal process in the finance department will be completed December 31, 2022. The Program Manager meeting and education will be conducted in January 2023.

Categories

Allowable Costs / Cost Principles

Other Findings in this Audit

  • 622218 2022-001
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
21.023 Emergency Rental Assistance Program $3.59M
14.231 Emergency Solutions Grant Program $187,831
14.267 Continuum of Care Program $115,022