Finding 969004 (2022-007)

Significant Deficiency
Requirement
L
Questioned Costs
-
Year
2022
Accepted
2024-04-08

AI Summary

  • Core Issue: Year-end payroll of approximately $69,000 was not accrued, leading to misalignment of expenses with the correct fiscal year.
  • Impacted Requirements: Compliance with Uniform Guidance for recognizing revenue and expenses under cost reimbursement contracts was not met.
  • Recommended Follow-Up: Implement monthly payroll accrual procedures to ensure timely and accurate reporting of costs within the correct grant periods.

Finding Text

Significant Deficiency – Year End Accrued Payroll - Period of Performance U.S. Department of Health and Human Services CFDA #93.566 U.S. Department of Labor CFDA #17.258 / 17.259 / 17.278 Criteria: Uniform Guidance requires that revenue is recognized when federal expenditures under cost reimbursement contracts are incurred. Condition: The Organization's internal controls over financial reporting did not ensure that revenues and expenses were recorded in the proper period. The year end payroll totaling approximately $69,000 was not accrued at June 30, 2022, and therefore was not allocated and charged to grants until the following fiscal year. In addition, the year-end accrued vacation did not agree to the supporting detail resulting in an adjustment of approximately $7,000 that was not allocated to grants in the year ended June 30, 2022. Cause: This situation was attributed to the turnover and vacancy in the accounting department positions from July 2021 through May 2022 which resulted in the absence of guidance as well as the use of inconsistent accounting methodologies during this period and at year end. Effect: Grant expenditures and the associated invoicing for reimbursement do not occur in the appropriate fiscal year. Although this is just a timing difference, there is a potential to lose out on receiving reimbursement for expenses depending on the grant period. Questioned Costs: None Repeat Finding: No Recommendation: We recommend the Organization implement payroll accrual procedures at month end in order to ensure costs are captured in the appropriate period and within the appropriate grant period. Response: The Organization agrees with the finding. There were gaps in information flow due to staff turnover. The Organization already has a process in place for reviewing payroll expenditures. The Organization will significantly increase the practice of capturing payroll expenses in the appropriate period and within the appropriate grant period to report grant expenses for reimbursement.

Categories

Cash Management Period of Performance Reporting Significant Deficiency Internal Control / Segregation of Duties

Other Findings in this Audit

  • 392525 2022-003
    Significant Deficiency
  • 392526 2022-003
    Significant Deficiency
  • 392527 2022-003
    Significant Deficiency
  • 392528 2022-003
    Significant Deficiency
  • 392529 2022-003
    Significant Deficiency
  • 392530 2022-003
    Significant Deficiency
  • 392531 2022-003
    Significant Deficiency
  • 392532 2022-003
    Significant Deficiency
  • 392533 2022-003
    Significant Deficiency
  • 392534 2022-004
    Significant Deficiency Repeat
  • 392535 2022-004
    Significant Deficiency Repeat
  • 392536 2022-004
    Significant Deficiency Repeat
  • 392537 2022-004
    Significant Deficiency Repeat
  • 392538 2022-004
    Significant Deficiency Repeat
  • 392539 2022-004
    Significant Deficiency Repeat
  • 392540 2022-004
    Significant Deficiency Repeat
  • 392541 2022-004
    Significant Deficiency Repeat
  • 392542 2022-004
    Significant Deficiency Repeat
  • 392543 2022-005
    Material Weakness
  • 392544 2022-005
    Material Weakness
  • 392545 2022-005
    Material Weakness
  • 392546 2022-005
    Material Weakness
  • 392547 2022-005
    Material Weakness
  • 392548 2022-005
    Material Weakness
  • 392549 2022-005
    Material Weakness
  • 392550 2022-005
    Material Weakness
  • 392551 2022-005
    Material Weakness
  • 392552 2022-006
    Material Weakness
  • 392553 2022-006
    Material Weakness
  • 392554 2022-006
    Material Weakness
  • 392555 2022-006
    Material Weakness
  • 392556 2022-006
    Material Weakness
  • 392557 2022-006
    Material Weakness
  • 392558 2022-006
    Material Weakness
  • 392559 2022-006
    Material Weakness
  • 392560 2022-006
    Material Weakness
  • 392561 2022-007
    Significant Deficiency
  • 392562 2022-007
    Significant Deficiency
  • 392563 2022-007
    Significant Deficiency
  • 392564 2022-007
    Significant Deficiency
  • 392565 2022-007
    Significant Deficiency
  • 392566 2022-007
    Significant Deficiency
  • 392567 2022-007
    Significant Deficiency
  • 392568 2022-007
    Significant Deficiency
  • 392569 2022-007
    Significant Deficiency
  • 968967 2022-003
    Significant Deficiency
  • 968968 2022-003
    Significant Deficiency
  • 968969 2022-003
    Significant Deficiency
  • 968970 2022-003
    Significant Deficiency
  • 968971 2022-003
    Significant Deficiency
  • 968972 2022-003
    Significant Deficiency
  • 968973 2022-003
    Significant Deficiency
  • 968974 2022-003
    Significant Deficiency
  • 968975 2022-003
    Significant Deficiency
  • 968976 2022-004
    Significant Deficiency Repeat
  • 968977 2022-004
    Significant Deficiency Repeat
  • 968978 2022-004
    Significant Deficiency Repeat
  • 968979 2022-004
    Significant Deficiency Repeat
  • 968980 2022-004
    Significant Deficiency Repeat
  • 968981 2022-004
    Significant Deficiency Repeat
  • 968982 2022-004
    Significant Deficiency Repeat
  • 968983 2022-004
    Significant Deficiency Repeat
  • 968984 2022-004
    Significant Deficiency Repeat
  • 968985 2022-005
    Material Weakness
  • 968986 2022-005
    Material Weakness
  • 968987 2022-005
    Material Weakness
  • 968988 2022-005
    Material Weakness
  • 968989 2022-005
    Material Weakness
  • 968990 2022-005
    Material Weakness
  • 968991 2022-005
    Material Weakness
  • 968992 2022-005
    Material Weakness
  • 968993 2022-005
    Material Weakness
  • 968994 2022-006
    Material Weakness
  • 968995 2022-006
    Material Weakness
  • 968996 2022-006
    Material Weakness
  • 968997 2022-006
    Material Weakness
  • 968998 2022-006
    Material Weakness
  • 968999 2022-006
    Material Weakness
  • 969000 2022-006
    Material Weakness
  • 969001 2022-006
    Material Weakness
  • 969002 2022-006
    Material Weakness
  • 969003 2022-007
    Significant Deficiency
  • 969005 2022-007
    Significant Deficiency
  • 969006 2022-007
    Significant Deficiency
  • 969007 2022-007
    Significant Deficiency
  • 969008 2022-007
    Significant Deficiency
  • 969009 2022-007
    Significant Deficiency
  • 969010 2022-007
    Significant Deficiency
  • 969011 2022-007
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
93.268 Immunization Cooperative Agreements $134,701
17.259 Wia Youth Activities $86,507
17.278 Wia Dislocated Worker Formula Grants $69,499
93.569 Community Services Block Grant $64,106
17.258 Wia Adult Program $45,662
14.218 Community Development Block Grants/entitlement Grants $43,699
93.566 Refugee and Entrant Assistance_state Administered Programs $23,386
97.024 Emergency Food and Shelter National Board Program $17,278
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $13,953
93.669 Child Abuse and Neglect State Grants $12,831
93.596 Child Care Mandatory and Matching Funds of the Child Care and Development Fund $3,931