Finding 943327 (2022-001)

Material Weakness
Requirement
BL
Questioned Costs
-
Year
2022
Accepted
2024-02-12
Audit: 290035
Organization: Del Norte Child Care Council (CA)

AI Summary

  • Core Issue: Internal control weaknesses in cost allocation led to inaccurate expense reporting for Child Care Development Fund programs.
  • Impacted Requirements: Allocation ratios were outdated, causing some projects to be overcharged and stale payroll balances that weren't reconciled.
  • Recommended Follow-Up: Update indirect cost allocations annually and maintain oversight from an external accounting firm until internal capabilities improve.

Finding Text

Finding 2022-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, 2022, 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

  • 366885 2022-001
    Material Weakness
  • 366886 2022-001
    Material Weakness
  • 366887 2022-002
    Significant Deficiency Repeat
  • 366888 2022-002
    Significant Deficiency Repeat
  • 943328 2022-001
    Material Weakness
  • 943329 2022-002
    Significant Deficiency Repeat
  • 943330 2022-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 $538,763
93.575 Child Care and Development Block Grant $334,819
10.558 Child and Adult Care Food Program $117,921