Finding 949062 (2023-005)

Significant Deficiency Repeat Finding
Requirement
B
Questioned Costs
-
Year
2023
Accepted
2024-03-06
Audit: 293672
Auditor: Mahoney

AI Summary

  • Core Issue: The Organization is using budgeted allocations for indirect costs instead of actual costs, violating federal guidelines.
  • Impacted Requirements: Costs charged to federal grants must be based on actual expenses, with necessary adjustments made throughout the year.
  • Recommended Follow-Up: Implement quarterly reconciliations to ensure accurate cost allocations and avoid overcharging grants, starting in fiscal year 2024.

Finding Text

2023-005 Allocation of Costs Based on Budgeted Numbers Federal Program – Continuum of Care Assistance Listing # 14.267 Compliance & Significant Deficiency Category of Finding – Allowable Costs/Cost Principles Criteria – Uniform guidance cost principals require that amounts charged to federal grants be based on actual costs. These can be estimated allocations, but the estimates must be based on actual current information. The regulations specify that budget estimates may be used for interim accounting purposes, provided that they are later trued up to actuals. Condition – The Organization’s current method of charging some indirect costs to grants is based on budgeted allocations. Specifically, the allocation of workers compensation and facilities charges are based on budgeted allocations. Also, several individuals who work on multiple programs allocate their time to grants based on a budget allocation. The Organization did not true up these budgeted costs to actual during the year as required. The dollar value effect of this is difficult to determine. Cause – Due to the change in the accounting system, the true up of these costs was not performed as required in the financial policies. Effect – Some of the programs and related federal grants may have been overcharged. Recommendations – The Organization should review their policies for allocating these costs and apply allocations during the year that are based on actual costs rather than budgeted or implement a process to true up allocated costs periodically during the year. Based on current grant periods, we recommend at least quarterly reconciliations to avoid overcharging a grant which has closed. Auditee's comments and response – Management agrees with the finding and plans to true up budgeted allocations with actual allocations annually effective fiscal year 2024. Responsible party for corrective action: Laura Straw, Finance Director Repeat Finding: Yes, 2022-002

Categories

Allowable Costs / Cost Principles

Other Findings in this Audit

  • 372584 2023-001
    Material Weakness Repeat
  • 372585 2023-001
    Material Weakness Repeat
  • 372586 2023-001
    Material Weakness Repeat
  • 372587 2023-001
    Material Weakness Repeat
  • 372588 2023-001
    Material Weakness Repeat
  • 372589 2023-001
    Material Weakness Repeat
  • 372590 2023-001
    Material Weakness Repeat
  • 372591 2023-001
    Material Weakness Repeat
  • 372592 2023-002
    Significant Deficiency
  • 372593 2023-002
    Significant Deficiency
  • 372594 2023-002
    Significant Deficiency
  • 372595 2023-002
    Significant Deficiency
  • 372596 2023-002
    Significant Deficiency
  • 372597 2023-002
    Significant Deficiency
  • 372598 2023-002
    Significant Deficiency
  • 372599 2023-002
    Significant Deficiency
  • 372600 2023-003
    Significant Deficiency
  • 372601 2023-003
    Significant Deficiency
  • 372602 2023-003
    Significant Deficiency
  • 372603 2023-003
    Significant Deficiency
  • 372604 2023-003
    Significant Deficiency
  • 372605 2023-003
    Significant Deficiency
  • 372606 2023-003
    Significant Deficiency
  • 372607 2023-003
    Significant Deficiency
  • 372608 2023-004
    Material Weakness Repeat
  • 372609 2023-004
    Material Weakness Repeat
  • 372610 2023-004
    Material Weakness Repeat
  • 372611 2023-004
    Material Weakness Repeat
  • 372612 2023-004
    Material Weakness Repeat
  • 372613 2023-004
    Material Weakness Repeat
  • 372614 2023-004
    Material Weakness Repeat
  • 372615 2023-004
    Material Weakness Repeat
  • 372616 2023-005
    Significant Deficiency Repeat
  • 372617 2023-005
    Significant Deficiency Repeat
  • 372618 2023-005
    Significant Deficiency Repeat
  • 372619 2023-005
    Significant Deficiency Repeat
  • 372620 2023-005
    Significant Deficiency Repeat
  • 372621 2023-006
    Significant Deficiency
  • 372622 2023-006
    Significant Deficiency
  • 372623 2023-006
    Significant Deficiency
  • 372624 2023-006
    Significant Deficiency
  • 372625 2023-006
    Significant Deficiency
  • 949026 2023-001
    Material Weakness Repeat
  • 949027 2023-001
    Material Weakness Repeat
  • 949028 2023-001
    Material Weakness Repeat
  • 949029 2023-001
    Material Weakness Repeat
  • 949030 2023-001
    Material Weakness Repeat
  • 949031 2023-001
    Material Weakness Repeat
  • 949032 2023-001
    Material Weakness Repeat
  • 949033 2023-001
    Material Weakness Repeat
  • 949034 2023-002
    Significant Deficiency
  • 949035 2023-002
    Significant Deficiency
  • 949036 2023-002
    Significant Deficiency
  • 949037 2023-002
    Significant Deficiency
  • 949038 2023-002
    Significant Deficiency
  • 949039 2023-002
    Significant Deficiency
  • 949040 2023-002
    Significant Deficiency
  • 949041 2023-002
    Significant Deficiency
  • 949042 2023-003
    Significant Deficiency
  • 949043 2023-003
    Significant Deficiency
  • 949044 2023-003
    Significant Deficiency
  • 949045 2023-003
    Significant Deficiency
  • 949046 2023-003
    Significant Deficiency
  • 949047 2023-003
    Significant Deficiency
  • 949048 2023-003
    Significant Deficiency
  • 949049 2023-003
    Significant Deficiency
  • 949050 2023-004
    Material Weakness Repeat
  • 949051 2023-004
    Material Weakness Repeat
  • 949052 2023-004
    Material Weakness Repeat
  • 949053 2023-004
    Material Weakness Repeat
  • 949054 2023-004
    Material Weakness Repeat
  • 949055 2023-004
    Material Weakness Repeat
  • 949056 2023-004
    Material Weakness Repeat
  • 949057 2023-004
    Material Weakness Repeat
  • 949058 2023-005
    Significant Deficiency Repeat
  • 949059 2023-005
    Significant Deficiency Repeat
  • 949060 2023-005
    Significant Deficiency Repeat
  • 949061 2023-005
    Significant Deficiency Repeat
  • 949063 2023-006
    Significant Deficiency
  • 949064 2023-006
    Significant Deficiency
  • 949065 2023-006
    Significant Deficiency
  • 949066 2023-006
    Significant Deficiency
  • 949067 2023-006
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
14.267 Continuum of Care Program $326,522
14.231 Emergency Solutions Grant Program $118,642