Finding 508305 (2023-001)

Significant Deficiency
Requirement
B
Questioned Costs
-
Year
2023
Accepted
2024-11-19

AI Summary

  • Core Issue: The Conservation District lacks proper documentation linking employee hours to the ACAP grant, leading to potential inaccuracies in payroll reporting.
  • Impacted Requirements: Compliance with the Allowable Cost/Activity requirement is at risk due to insufficient internal controls over payroll tracking.
  • Recommended Follow-Up: Implement and adhere to internal control procedures for time tracking to ensure accurate support for grant reimbursement requests.

Finding Text

Reference Number: 2023-001 - Grant Project Payroll Tracking Reports Federal Agency: U.S. Environmental Protection Agency Federal Program: COVID-19 Agriculture Conservation Assistance Program Compliance Requirement: Allowable Cost/Activity Type of Finding: Significant Deficiency in Internal Control over Compliance Criteria: The Agriculture Conservation Assistance Program requires quarterly expenditures charged to the program to be properly supported. Payroll expenditures charged to the program should be supported by internal payroll reports which specify hours worked on ACAP related projects to ensure the correct number of hours are charged to the federal grant program. Statement of Condition: Per review of the District’s internal payroll tracking reports, it was noted that while employees keep a detailed list of time worked each day, no specific documentation is maintained within the tracking reports of which projects relate to the ACAP grant program to support the hours being charged to the program quarter. Statement of Cause: The Conservation District did not have proper internal control procedures in place to ensure review was completed as required. Possible Asserted Effect: Expenditures summarized for reporting may not contain the correct number of hours to charge to the ACAP grant program. Questioned Costs: None noted. Context: Reviewed monthly and quarterly time tracking spreadsheets maintained by Conservation District employees working on federal grant programs during the 2023 year. Repeat Finding: Not a repeat finding. Recommendation: The Conservation District should ensure internal control procedures are in place and procedures are being followed related to the preparation of employee time tracking spreadsheets used to support grant reimbursement requests.

Corrective Action Plan

2023-002: 2023-001 – Grant Project Payroll Tracking Reports Contact Person: Christian Strohmaier, cstrohmaier@chesco.org, 610-455-1370 Condition: Per review of the District’s internal payroll tracking reports, it was noted that while employees keep a detailed list of time worked each day, no specific documentation was maintained within the tracking reports of which projects relate to the ACAP grant program to support the hours being charged to the program each quarter. Corrective Action: Increased programmatic responsibilities make it necessary for all staff to accurately record their completed activities and the time spent upon them. Technical staff historically have reported this way, with activity stated, hours spent, and which program the activity relates to recorded. Each technical staff employe has an individual report maintained in Excel that is updated daily. This model will be used for administrative staff as well for their time spent in support of these programs. Proposed Completion Date: December 1, 2024

Categories

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

Other Findings in this Audit

  • 1084747 2023-001
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
21.027 Coronavirus State and Local Fiscal Recovery Funds $787,743
66.466 Geographic Programs - Chesapeake Bay Program $22,975