Finding 1175894 (2024-003)

Material Weakness Repeat Finding
Requirement
ABGHILM
Questioned Costs
-
Year
2024
Accepted
2026-03-02

AI Summary

  • Core Issue: Internal controls failed to ensure accurate allocation of insurance expenses to grants, leading to potential disallowed costs.
  • Impacted Requirements: Compliance with Uniform Guidance on allowable costs for federal awards was not met.
  • Recommended Follow-Up: Establish procedures to reconcile insurance expenses, allocate costs based on actual policy amounts, and update calculations annually.

Finding Text

Significant Deficiency - Allocation of Insurance Expense - Allowable Costs U.S. Department of the Treasury AL #21.027 U.S. Department of Labor AL #17.258 / 17.259 / 17.278 Criteria: Uniform Guidance requires federal awards to be expended only for allowable activities and that the costs charged are in accordance with the applicable cost principles. Condition: The Organization's internal controls over financial reporting did not ensure that prepaid insurance and monthly adjustments to the account were based on current insurance statements resulting in an inaccurate amount allocated to grants each month. Cause: This situation was attributed to the turnover and vacancy in the accounting department and the shortage of support staff. Effect: Insurance expense allocated to grants and reimbursed by grantors was more than the actual expenditure resulting in disallowed costs and the potential need to refund grantors. Total insurance costs overallocated to grants for the year did not meet the threshold to be reported as a questioned cost. Questioned Costs: None Recommendation: Implement procedures to (1) reconcile prepaid insurance and insurance expense to the actual policies (2) allocate insurance expense based on the annual policy expense over 12 months and (3) ensure allocation calculations are updated annually for the new policy amounts. Response: The Organization agrees with the finding. The Organization will implement a method to ensure prepaid insurance is appropriately adjusted and insurance costs are accurately recorded and allocated to grants.

Corrective Action Plan

Response: The organization agrees with the finding. The organization has implemented a method to ensure prepaid insurance is appropriately adjusted and insurance costs are accurately recorded and allocated to grants.

Categories

Allowable Costs / Cost Principles

Other Findings in this Audit

  • 1175880 2024-001
    Material Weakness Repeat
  • 1175881 2024-002
    Material Weakness Repeat
  • 1175882 2024-003
    Material Weakness Repeat
  • 1175883 2024-001
    Material Weakness Repeat
  • 1175884 2024-002
    Material Weakness Repeat
  • 1175885 2024-003
    Material Weakness Repeat
  • 1175886 2024-001
    Material Weakness Repeat
  • 1175887 2024-002
    Material Weakness Repeat
  • 1175888 2024-003
    Material Weakness Repeat
  • 1175889 2024-001
    Material Weakness Repeat
  • 1175890 2024-002
    Material Weakness Repeat
  • 1175891 2024-003
    Material Weakness Repeat
  • 1175892 2024-001
    Material Weakness Repeat
  • 1175893 2024-002
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
93.566 REFUGEE AND ENTRANT ASSISTANCE STATE/REPLACEMENT DESIGNEE ADMINISTERED PROGRAMS $335,002
21.027 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $179,353
93.323 EPIDEMIOLOGY AND LABORATORY CAPACITY FOR INFECTIOUS DISEASES (ELC) $124,662
93.268 IMMUNIZATION COOPERATIVE AGREEMENTS $124,662
17.259 WIOA YOUTH ACTIVITIES $112,572
84.126 REHABILITATION SERVICES VOCATIONAL REHABILITATION GRANTS TO STATES $99,722
93.569 COMMUNITY SERVICES BLOCK GRANT $86,007
17.278 WIOA DISLOCATED WORKER FORMULA GRANTS $63,920
17.258 WIOA ADULT PROGRAM $35,983
93.596 CHILD CARE MANDATORY AND MATCHING FUNDS OF THE CHILD CARE AND DEVELOPMENT FUND $14,998
14.218 COMMUNITY DEVELOPMENT BLOCK GRANTS/ENTITLEMENT GRANTS $6,538