Finding 389997 (2023-002)

Significant Deficiency
Requirement
A
Questioned Costs
-
Year
2023
Accepted
2024-03-29

AI Summary

  • Core Issue: Payroll records did not match actual charges, leading to discrepancies in program billing.
  • Impacted Requirements: Compliance with Uniform Guidance (2 CFR 200.430) for accurate payroll tracking and internal controls.
  • Recommended Follow-Up: Review and enhance payroll processes to ensure accurate recording and implement secondary reviews to catch errors.

Finding Text

Finding 2023-002 – Internal Controls over Payroll Tracking & Recording Assistance Listing #: ALL Federal Awards: All Criteria: In accordance with the Uniform Guidance’s compensation requirements (2 CFR 200.430), payroll systems must be based on records that accurately reflect the work performed and supported by a system of internal controls that provides reasonable assurances that charges are accurate; allowable and reasonable; and properly allocated amongst programs. Condition: During our testing of 40 payroll transactions, we noted five instances where the time charged on the employee’s timesheet by program did not agree to the programs actually charged in the general ledger, and ultimately billed to the applicable grant award. Cause: The Organization summarizes employee timesheet data amongst programs on a reclass spreadsheet, which serves as the basis for entry into the general ledger. It appears there were errors when entering time from the timesheet into the reclass spreadsheet, which were not detected as a secondary review was not performed. Effect: The effect of the errors noted above did not exceed $850. Although the overall errors were immaterial, an inherent risk exists that errors could be material and not be detected and corrected without sufficient review. Questioned Costs: N/A Repeat Finding: No Recommendation: We recommend the Organization review its current processes over payroll to ensure that payroll costs are captured and recorded correctly in the financial management system. Response: We concur with the Finding. The CFO will immediately evaluate the need for additional controls to ensure accurate recording of time charged to program as reflected on the employee’s timesheet.

Corrective Action Plan

NOTE: While discrepancies in payroll entries were observed during the period of emergency declaration, which provided full flexibility in fund usage, it's important to note that this doesn't justify inconsistencies between timesheets and the general ledger. The CFO will immediately evaluate the procedures involved in recording employee time on timesheets and transferring this data to the financial management system. The CFO will immediately evaluate the need for additional controls to ensure accurate recording of time charged to programs as reflected on the employee's timesheet. The CFO will immediately implement new processes that establish checks and balances to verify that the programs charged in the general ledger align with the time recorded by the employees and is verified by their supervisor. The CFO and HR director will provide training sessions to all staff and new hires on the importance of accurately capturing and recording payroll costs by April 30, 2024. The CEO will immediately provide training to the CFO and staff accountant on the significance of aligning time charged with the programs designated in the general ledger for proper grant award billing. The CFO will conduct periodic reviews of payroll transactions to identify any discrepancies or irregularities promptly and take action immediately upon identification of such. These reviews will continue through FY 2025.

Categories

Allowable Costs / Cost Principles Internal Control / Segregation of Duties

Other Findings in this Audit

  • 389996 2023-001
    -
  • 389998 2023-001
    Significant Deficiency
  • 389999 2023-002
    Significant Deficiency
  • 390000 2023-001
    Significant Deficiency
  • 390001 2023-002
    Significant Deficiency
  • 390002 2023-001
    Significant Deficiency
  • 390003 2023-002
    Significant Deficiency
  • 390004 2023-001
    Significant Deficiency
  • 390005 2023-002
    Significant Deficiency
  • 390006 2023-001
    Significant Deficiency
  • 390007 2023-002
    Significant Deficiency
  • 390008 2023-001
    Significant Deficiency
  • 390009 2023-002
    Significant Deficiency
  • 390010 2023-001
    Significant Deficiency
  • 390011 2023-002
    Significant Deficiency
  • 390012 2023-001
    Significant Deficiency
  • 390013 2023-002
    Significant Deficiency
  • 390014 2023-001
    Significant Deficiency
  • 390015 2023-002
    Significant Deficiency
  • 390016 2023-001
    Significant Deficiency
  • 390017 2023-002
    Significant Deficiency
  • 390018 2023-001
    Significant Deficiency
  • 390019 2023-002
    Significant Deficiency
  • 390020 2023-001
    Significant Deficiency
  • 390021 2023-002
    Significant Deficiency
  • 390022 2023-001
    Significant Deficiency
  • 390023 2023-002
    Significant Deficiency
  • 390024 2023-001
    Significant Deficiency
  • 390025 2023-002
    Significant Deficiency
  • 390026 2023-001
    Significant Deficiency
  • 390027 2023-002
    Significant Deficiency
  • 390028 2023-001
    Significant Deficiency
  • 390029 2023-002
    Significant Deficiency
  • 390030 2023-001
    Significant Deficiency
  • 390031 2023-002
    Significant Deficiency
  • 390032 2023-001
    Significant Deficiency
  • 390033 2023-002
    Significant Deficiency
  • 390034 2023-001
    Significant Deficiency
  • 390035 2023-002
    Significant Deficiency
  • 390036 2023-001
    Significant Deficiency
  • 390037 2023-002
    Significant Deficiency
  • 390038 2023-001
    Significant Deficiency
  • 390039 2023-002
    Significant Deficiency
  • 390040 2023-001
    Significant Deficiency
  • 390041 2023-002
    Significant Deficiency
  • 966438 2023-001
    -
  • 966439 2023-002
    Significant Deficiency
  • 966440 2023-001
    Significant Deficiency
  • 966441 2023-002
    Significant Deficiency
  • 966442 2023-001
    Significant Deficiency
  • 966443 2023-002
    Significant Deficiency
  • 966444 2023-001
    Significant Deficiency
  • 966445 2023-002
    Significant Deficiency
  • 966446 2023-001
    Significant Deficiency
  • 966447 2023-002
    Significant Deficiency
  • 966448 2023-001
    Significant Deficiency
  • 966449 2023-002
    Significant Deficiency
  • 966450 2023-001
    Significant Deficiency
  • 966451 2023-002
    Significant Deficiency
  • 966452 2023-001
    Significant Deficiency
  • 966453 2023-002
    Significant Deficiency
  • 966454 2023-001
    Significant Deficiency
  • 966455 2023-002
    Significant Deficiency
  • 966456 2023-001
    Significant Deficiency
  • 966457 2023-002
    Significant Deficiency
  • 966458 2023-001
    Significant Deficiency
  • 966459 2023-002
    Significant Deficiency
  • 966460 2023-001
    Significant Deficiency
  • 966461 2023-002
    Significant Deficiency
  • 966462 2023-001
    Significant Deficiency
  • 966463 2023-002
    Significant Deficiency
  • 966464 2023-001
    Significant Deficiency
  • 966465 2023-002
    Significant Deficiency
  • 966466 2023-001
    Significant Deficiency
  • 966467 2023-002
    Significant Deficiency
  • 966468 2023-001
    Significant Deficiency
  • 966469 2023-002
    Significant Deficiency
  • 966470 2023-001
    Significant Deficiency
  • 966471 2023-002
    Significant Deficiency
  • 966472 2023-001
    Significant Deficiency
  • 966473 2023-002
    Significant Deficiency
  • 966474 2023-001
    Significant Deficiency
  • 966475 2023-002
    Significant Deficiency
  • 966476 2023-001
    Significant Deficiency
  • 966477 2023-002
    Significant Deficiency
  • 966478 2023-001
    Significant Deficiency
  • 966479 2023-002
    Significant Deficiency
  • 966480 2023-001
    Significant Deficiency
  • 966481 2023-002
    Significant Deficiency
  • 966482 2023-001
    Significant Deficiency
  • 966483 2023-002
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
93.778 Medical Assistance Program $257,038
93.052 National Family Caregiver Support, Title Iii, Part E $86,575
94.002 Retired and Senior Volunteer Program $59,295
14.218 Community Development Block Grants/entitlement Grants $58,260
16.575 Crime Victim Assistance $54,364
93.044 Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers $42,139
93.045 Special Programs for the Aging_title Iii, Part C_nutrition Services $27,368
93.053 Nutrition Services Incentive Program $16,211
93.324 State Health Insurance Assistance Program $15,997
93.042 Special Programs for the Aging_title Vii, Chapter 2_long Term Care Ombudsman Services for Older Individuals $14,734
93.048 Special Programs for the Aging_title Iv_and Title Ii_discretionary Projects $11,014
93.071 Medicare Enrollment Assistance Program $10,970
93.043 Special Programs for the Aging_title Iii, Part D_disease Prevention and Health Promotion Services $4,852
93.041 Special Programs for the Aging_title Vii, Chapter 3_programs for Prevention of Elder Abuse, Neglect, and Exploitation $3,740