Finding 1225263 (2025-004)

Material Weakness Repeat Finding
Requirement
B
Questioned Costs
-
Year
2025
Accepted
2026-07-31

AI Summary

  • Core Issue: Expense allocations for federal and non-federal awards were inaccurately based on headcount rather than a fair share of benefits.
  • Impacted Requirements: Allocations must reflect the actual use of expenses across all programs, ensuring compliance with federal guidelines.
  • Recommended Follow-Up: Implement a review process for allocation calculations to ensure accuracy before submitting reimbursement requests.

Finding Text

Criteria: Allocations for expenses charged to federal and non-federal awards should be representative of the prorata share of the expense over all programs and activities benefited by the expense. Condition: Certain expenses are allocated amongst grants and programs based on headcount. The calculations for the allocations were not applied consistently or accurately based on identified personnel. Cause: The accounting clerk responsible for the calculations used incorrect information. Amounts allocated were reviewed for reasonableness but the detailed calculations were not reviewed. Effect: Amounts computed as eligible for reimbursement were understated by a projected immaterial amount. Recommendation: The calculations supporting amounts on requests for reimbursements should be reviewed as part of the review of all expenses included on the request.

Corrective Action Plan

Management has provided a template, which was reviewed and approved by the CFO in April 2026, to the AP Clerk without any roundings of the allocation percentages. Management will review the calculations between January 1 and April 2026 that were used for allocations and will correct any allocations as necessary. Management will ensure the review of expenses include all calculations supporting the expense amounts. All these actions are effective January 1, 2026, and will be managed by the Chief Financial Officer.

Categories

Allowable Costs / Cost Principles Cash Management Matching / Level of Effort / Earmarking

Other Findings in this Audit

  • 1225262 2025-004
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
84.181 SPECIAL EDUCATION-GRANTS FOR INFANTS AND FAMILIES $1.63M
84.027 SPECIAL EDUCATION GRANTS TO STATES $313,920
93.558 TEMPORARY ASSISTANCE FOR NEEDY FAMILIES $213,514
21.027 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $125,793
14.239 HOME INVESTMENT PARTNERSHIPS PROGRAM $109,330
16.726 JUVENILE MENTORING PROGRAM $49,331
14.169 HOUSING COUNSELING ASSISTANCE PROGRAM $25,746
93.434 EVERY STUDENT SUCCEEDS ACT/PRESCHOOL DEVELOPMENT GRANTS $25,484