Finding 48672 (2022-002)

Significant Deficiency
Requirement
B
Questioned Costs
-
Year
2022
Accepted
2023-01-03
Audit: 48034
Auditor: Mahoney

AI Summary

  • Core Issue: Agate used budgeted costs for indirect allocations instead of actual costs, failing to adjust these estimates throughout 2022.
  • Impacted Requirements: This practice violates federal guidelines requiring costs charged to grants to be based on actual expenses, leading to potential overcharges.
  • Recommended Follow-Up: Implement quarterly reconciliations and adjust cost allocations based on actuals to ensure compliance and accuracy in future reporting.

Finding Text

Finding 2022-002 ? Allocation of Costs Based on Estimates Federal Program ? Emergency Solutions Grants Program Assistance Listing # 14.231 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 ? Agate?s current method of charging indirect costs, which consist of administrative, development, facility use and meal costs, to grants, is based on allocating budgeted costs. During 2022, these costs were not adjusted to match actual costs incurred. Agate 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 turnover in the finance department, the true up of these costs was not performed as requires in the financial policies. Also due to other turnover and program changes, the variances from budget to actual were more significant than they have been in the past. The meals costs allocations were new this year due to changes caused by the merger with House of Charities. Effect ? Some of the programs and related federal grants may have been overcharged. Recommendations ? Agate 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 ? Agate is aware of the Uniform guidance regulations and will follow them in the future. The Director of Finance has implemented changes to allow for adjustments to actual periodically throughout the fiscal year and at year end to accurately account for the distribution of allocations based on actual costs. Additionally, a new accounting system that includes a module to allocate indirect costs was implemented in fiscal year 2023. Responsible party for corrective action: Laura Straw, Finance Director Repeat Finding: No

Categories

Allowable Costs / Cost Principles

Other Findings in this Audit

  • 48668 2022-001
    Material Weakness
  • 48669 2022-002
    Significant Deficiency
  • 48670 2022-003
    Significant Deficiency
  • 48671 2022-001
    Material Weakness
  • 48673 2022-003
    Significant Deficiency
  • 48674 2022-001
    Material Weakness
  • 48675 2022-002
    Significant Deficiency
  • 48676 2022-003
    Significant Deficiency
  • 48677 2022-001
    Material Weakness
  • 48678 2022-002
    Significant Deficiency
  • 48679 2022-003
    Significant Deficiency
  • 48680 2022-001
    Material Weakness
  • 48681 2022-003
    Significant Deficiency
  • 48682 2022-002
    Significant Deficiency
  • 48683 2022-001
    Material Weakness
  • 48684 2022-002
    Significant Deficiency
  • 48685 2022-003
    Significant Deficiency
  • 48686 2022-001
    Material Weakness
  • 48687 2022-002
    Significant Deficiency
  • 48688 2022-003
    Significant Deficiency
  • 48689 2022-001
    Material Weakness
  • 48690 2022-001
    Material Weakness
  • 48691 2022-001
    Material Weakness
  • 48692 2022-001
    Material Weakness
  • 48693 2022-001
    Material Weakness
  • 48694 2022-001
    Material Weakness
  • 48695 2022-001
    Material Weakness
  • 48696 2022-001
    Material Weakness
  • 48697 2022-001
    Material Weakness
  • 625110 2022-001
    Material Weakness
  • 625111 2022-002
    Significant Deficiency
  • 625112 2022-003
    Significant Deficiency
  • 625113 2022-001
    Material Weakness
  • 625114 2022-002
    Significant Deficiency
  • 625115 2022-003
    Significant Deficiency
  • 625116 2022-001
    Material Weakness
  • 625117 2022-002
    Significant Deficiency
  • 625118 2022-003
    Significant Deficiency
  • 625119 2022-001
    Material Weakness
  • 625120 2022-002
    Significant Deficiency
  • 625121 2022-003
    Significant Deficiency
  • 625122 2022-001
    Material Weakness
  • 625123 2022-003
    Significant Deficiency
  • 625124 2022-002
    Significant Deficiency
  • 625125 2022-001
    Material Weakness
  • 625126 2022-002
    Significant Deficiency
  • 625127 2022-003
    Significant Deficiency
  • 625128 2022-001
    Material Weakness
  • 625129 2022-002
    Significant Deficiency
  • 625130 2022-003
    Significant Deficiency
  • 625131 2022-001
    Material Weakness
  • 625132 2022-001
    Material Weakness
  • 625133 2022-001
    Material Weakness
  • 625134 2022-001
    Material Weakness
  • 625135 2022-001
    Material Weakness
  • 625136 2022-001
    Material Weakness
  • 625137 2022-001
    Material Weakness
  • 625138 2022-001
    Material Weakness
  • 625139 2022-001
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
14.267 Continuum of Care Program $83,394
14.231 Emergency Solutions Grant Program $75,000
93.788 Opioid Str $19,435
97.024 Emergency Food and Shelter National Board Program $16,456
21.027 Coronavirus State and Local Fiscal Recovery Funds $5,000