Finding 1072884 (2023-001)

Material Weakness Repeat Finding
Requirement
BL
Questioned Costs
-
Year
2023
Accepted
2024-09-11
Audit: 319367
Organization: Del Norte Child Care Council (CA)

AI Summary

  • Core Issue: Internal controls over compliance with allowable costs are weak, leading to inaccurate allocation of expenses across funds.
  • Impacted Requirements: Allocation ratios for costs have not been updated, resulting in some projects being overcharged and stale balances in payroll accounts.
  • Recommended Follow-Up: Update indirect cost allocations annually and maintain oversight through an external accounting firm until internal capabilities improve.

Finding Text

Finding 2023-01 – Material Weakness in Internal Control over Compliance with Allowable Costs and Reporting - Child Care and Development Block Grant- Assistance Listing #93.575, Child Care Mandatory and Matching Funds of the Child Care Development Fund - Assistance Listing #93.596 Criteria or Specified Requirement Accounting staff submit periodic reimbursement requests to the California Department of Social Services for expenses reimbursable under the Council’s federal Child Care Development Fund contract. Costs are recognized as the liability is incurred consistent with Generally Accepted Accounting Principles. Management uses two pool funds to allocate central office costs to its various funds, activities and projects. Payroll and related expenses are allocated based on direct hours, and facilities expenses are allocated based on square footage. Condition Found In review of the allocation from the two pool funds, it was noted that allocation ratios had not been updated from the prior year amounts despite the program mix changing. As such, the other funds, activities and projects are charged more than their share of those costs. A review of the year end accounts for accrued payroll and payroll taxes showed stale balances that had not been reconciled to actual accrued costs. Cause Management indicated that the loss of the Executive Director during the year placed too much pressure on the finance department to give them the time to undertake a new indirect calculation and to adequately review and tie out balance sheet accounts. Effect Some grant funds or projects receive excess pool allocations and costs that cannot be traced to actual expenses. Questioned Costs Monthly allocations are made within the accounting software but the hour and square footage totals and year end balance sheet accruals are not documented; consequently, there is no way to recompute the allocation to include all funds, activities and projects used by the Organization. Since audit procedures were performed to vouch cutoff, accruals, reclassifications, and allowable costs eligible for reimbursement as of June 30, 2023, there are no questioned costs. Recommendation We recommend that the indirect cost allocation be updated at least annually to include all funds, activities and projects so that each shares in the pool cost. After consultation regarding possible remedies to the condition, the Council engaged an outside accounting firm to provide financial oversight. We recommend that the Council continue that relationship, or a similar relationship until such time as they can develop sufficient capability among staff to meet the requirements for oversight.

Categories

Allowable Costs / Cost Principles Matching / Level of Effort / Earmarking Internal Control / Segregation of Duties Cash Management Material Weakness Reporting

Other Findings in this Audit

  • 496442 2023-001
    Material Weakness Repeat
  • 496443 2023-001
    Material Weakness Repeat
  • 496444 2023-002
    Significant Deficiency Repeat
  • 496445 2023-002
    Significant Deficiency Repeat
  • 1072885 2023-001
    Material Weakness Repeat
  • 1072886 2023-002
    Significant Deficiency Repeat
  • 1072887 2023-002
    Significant Deficiency Repeat

Programs in Audit

ALN Program Name Expenditures
93.596 Child Care Mandatory and Matching Funds of the Child Care and Development Fund $515,583
93.575 Child Care and Development Block Grant $287,939
10.558 Child and Adult Care Food Program $63,632