Finding 366885 (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.

Corrective Action Plan

Management agrees that due to turnover in staff during 2022 and 2023, there were gaps in communication leading to the cost allocation formulas and leadsheet account reconciliations not being updated on a continuing basis as reimbursement requests were being to the California Department of Social Services. Management believes that all key accounting positions have since been filled by qualified personnel. A formal close process and reconciliation of all balance sheet accounts and indirect cost allocations each month will ensure reimbursement requests are complete and accurate. Process documentation is also being prepared to help personnel in the accounting department follow proper control procedures. Action: Develop and document process for drawdown calculation and year end reconciliation to accounting records. Due Date: 3/1/23 Staff: Don Reynolds, contracted CFO

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

  • 366886 2022-001
    Material Weakness
  • 366887 2022-002
    Significant Deficiency Repeat
  • 366888 2022-002
    Significant Deficiency Repeat
  • 943327 2022-001
    Material Weakness
  • 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