Finding 497352 (2023-005)

Significant Deficiency
Requirement
AB
Questioned Costs
-
Year
2023
Accepted
2024-09-19

AI Summary

  • Core Issue: Payroll expenses for construction management fees were billed to the federal grant based on outdated budgeted allocations, without reconciling to actual time worked in 2023.
  • Impacted Requirements: This practice violates cost principles outlined in 2 CFR Part 200, Subpart E, which require expenditures to be necessary, reasonable, and accurately allocated.
  • Recommended Follow-Up: Management should regularly review payroll allocation calculations to ensure they reflect actual costs and comply with federal guidelines.

Finding Text

Significant Deficiency: Payroll Allocation True Up Related to Construction Management Fees Condition: During our testing of federal expenditures, we noted payroll expenses related to construction management fees were allocated and billed to the federal grant based on the Organization’s budgeted time allocations determined at the beginning of the year with no reconciliation to actual time allocations during 2023. We consider this instance to be a significant deficiency over compliance relating to allowable costs and the cost principles. Criteria: Expenditures charged to the federal grant must follow the cost principles outlined in 2 CFR Part 200, Subpart E including “Be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles.” Cause: Internal billings were not updated for actual 2023 payroll allocations and management did not perform reconciliation of budgeted allocations to actual time incurred. Effect: As a result of the deficiency noted, the federal grant could be charged in excess of actual expenditures necessary and reasonable to run the programs. Recommendation: We recommend management review their calculations of payroll allocations for the federal grant on a periodic basis to ensure the amounts being billed to the federal grant are reasonable and in line with actual costs incurred.

Corrective Action Plan

Payroll allocation budgets used to develop construction management fees charged to allowable federal programs will be reviewed semi-annually to adjust for any differences between budgeted and actual costs. This review will be documented, and any adjustments will be made to the applicable federal programs.

Categories

Allowable Costs / Cost Principles

Other Findings in this Audit

  • 497353 2023-006
    Significant Deficiency
  • 497354 2023-005
    Significant Deficiency
  • 497355 2023-006
    Significant Deficiency
  • 497356 2023-006
    Significant Deficiency
  • 497357 2023-006
    Significant Deficiency
  • 1073794 2023-005
    Significant Deficiency
  • 1073795 2023-006
    Significant Deficiency
  • 1073796 2023-005
    Significant Deficiency
  • 1073797 2023-006
    Significant Deficiency
  • 1073798 2023-006
    Significant Deficiency
  • 1073799 2023-006
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
14.900 Lead-Based Paint Hazard Control in Privately-Owned Housing $138,664
21.027 Coronavirus State and Local Fiscal Recovery Funds $52,633
14.218 Community Development Block Grants/entitlement Grants $30,000
14.239 Home Investment Partnerships Program $14,962