Finding 544135 (2024-001)

Significant Deficiency
Requirement
AB
Questioned Costs
$1
Year
2024
Accepted
2025-03-31
Audit: 350919
Organization: Accokeek Foundation, INC (MD)
Auditor: Sikich CPA LLC

AI Summary

  • Core Issue: Payroll expenses were improperly classified, leading to an understatement of $2,591 charged to the grant.
  • Impacted Requirements: Payroll must reflect actual hours worked per employee to comply with federal grant guidelines.
  • Recommended Follow-Up: Establish a policy for regular reviews comparing timecards to the general ledger each pay period to ensure accurate charging to grants.

Finding Text

2024--001 Improper Classification Of Payroll Expenses 15.954 National Park Service Conservation, Protection, Outreach and Education Audit Results: Information on Federal Programs: Assistance Listing #: 15.954 National Park Service Conservation, Protection, Outreach and Education Grant #: P20AC00467 Federal Agency: United States Department of the Interior Criteria: Payroll expenses should be charged to federal grants based on the hours worked by each employee that worked on the grants during a specific pay period. Condition: During our testing over payroll auditors noted that for three pay periods there were variances between the total calculated amount to be charged to the grant based on the timecards and the total actual amount charged. Questioned Costs: $2,591 Context: Costs should be charged to the grant properly based on actual hours worked to ensure that they are not charging more than the grant award allows. Effect: As a result, payroll charged to the major program was understated by $2,591 for the year ended September 30, 2024. Cause: This resulted from the lack of a regular detailed review of the calculations in comparison to the general ledger. Recommendation: We recommend that management implement a policy for a detailed comparison of the timecards and calculations to the general ledger for each pay period to ensure that the information is being pulled correctly and that time is being properly charged to all federal grants. It is critical that time be properly charged to be in compliance with Uniform Guidance requirements. Views of Responsible Officials and Planned Corrective Actions: Management agrees with this Single Audit Finding and response is included in the Corrective Action Plan.

Corrective Action Plan

The finding from the September 30, 2024 schedule of findings and questioned cost is discussed below. The finding is numbered consistently with the number assigned in the schedule. Findings - Federal Award 2024-001 Summary of Finding During our testing over payroll auditors noted that for three pay periods there were variances between the total calculated amount to be charged to the grant based on the timecards and the total actual amount charged. As a result. payroll charged to the major program was understated by $2,591 for the year ended September 30, 2024. Statement of Concurrence or Nonconcurrence Management agrees with the finding and will implement the following corrective action. Corrective Action Accokeek Foundation will implement an enhanced payroll reconciliation process by updating the Excel workbook formula to ensure the timecard grant allocations are correctly captured and reported. The accounting team will test the updated formula to verify its accuracy and effectiveness. They will monitor the effectiveness of this corrective action through quarterly reviews and ensure that any discrepancies identified are promptly corrected. The enhanced reconciliation process and training will be implemented by June 30, 2025.

Categories

Questioned Costs

Other Findings in this Audit

  • 1120577 2024-001
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
15.954 National Park Service Conservation, Protection, Outreach, and Education $749,000
66.964 Chesapeake Bay Program Implementation, Regulatory/accountability and Monitoring Grants $29,388
15.930 Chesapeake Bay Gateways Network $15,603