Finding 972186 (2023-003)

Material Weakness
Requirement
L
Questioned Costs
-
Year
2023
Accepted
2024-05-02
Audit: 305385
Organization: Ucan (IL)
Auditor: Porte Brown LLC

AI Summary

  • Core Issue: Expenses charged to the grant were not properly supported by the general ledger, leading to potential misallocation.
  • Impacted Requirements: Compliance with 2 CFR 200.405 on expense allocation based on proportional benefit was not met.
  • Recommended Follow-Up: Implement regular reviews and reconciliations of the general ledger with vouchers before submission to the granting agency.

Finding Text

Criteria: 2 CFR 200.405 maintains that costs which are allocable to more than one program be allocated based on the proportional benefit or as determined on any reasonable documented basis. Condition: During our testing, 4 of the 8 expenses selected were unsupported by general ledger allocation of the expenses. The amount charged to the grant appeared to be an allocable percentage based on the budgeted amount however, the actual expenses that were incurred were not allocated out to the program in alignment with that budgeted amount. Cause: Due to turnover in program management adequate allocation of these expenses were not reconciled. Effect:The Organization must be able to demonstrate the expenses allocated to the grant on the vouchers is supported in its allocation in the general ledger to ensure proper allocation and avoidance of duplication of funding requests for the same amounts. Questioned Costs: The total of the allocated epxense transactions of $1,667 were not allocated in the general ledger system to the applicable program. Recommendation: We recommend that the Organization implement procedures and internal controls for regular review of the general ledger of their programs and reconcile to the vouchers prior to submission to the granting agency. Management's Response: We agree with this finding. See corrective action plan.

Categories

Allowable Costs / Cost Principles

Other Findings in this Audit

  • 395743 2023-002
    Significant Deficiency
  • 395744 2023-003
    Material Weakness
  • 395745 2023-004
    Significant Deficiency Repeat
  • 395746 2023-005
    Significant Deficiency Repeat
  • 395747 2023-004
    Significant Deficiency Repeat
  • 395748 2023-005
    Significant Deficiency Repeat
  • 395749 2023-003
    Material Weakness
  • 395750 2023-004
    Significant Deficiency Repeat
  • 395751 2023-005
    Significant Deficiency Repeat
  • 972185 2023-002
    Significant Deficiency
  • 972187 2023-004
    Significant Deficiency Repeat
  • 972188 2023-005
    Significant Deficiency Repeat
  • 972189 2023-004
    Significant Deficiency Repeat
  • 972190 2023-005
    Significant Deficiency Repeat
  • 972191 2023-003
    Material Weakness
  • 972192 2023-004
    Significant Deficiency Repeat
  • 972193 2023-005
    Significant Deficiency Repeat

Programs in Audit

ALN Program Name Expenditures
16.575 Crime Victim Assistance $775,609
94.011 Foster Grandparent Program $661,745
21.027 Coronavirus State and Local Fiscal Recovery Funds $374,834
17.259 Wia Youth Activities $286,024
10.555 National School Lunch Program $122,455
10.553 School Breakfast Program $84,002
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $32,683