Finding 8684 (2021-001)

Material Weakness
Requirement
AP
Questioned Costs
-
Year
2021
Accepted
2024-01-16

AI Summary

  • Core Issue: The Association's financial system migration to MIP Fund Accounting failed to meet federal reporting requirements, leading to inaccurate financial reports.
  • Impacted Requirements: Compliance with HHS financial management standards, including accurate financial information, effective control over cash assets, and proper cost allowability.
  • Recommended Follow-Up: Collaborate with the software vendor and consultants to establish a proper chart of accounts and reporting tools to ensure compliance with federal regulations.

Finding Text

Federal Agency: U.S. Department of Health and Human Services Federal Program Name: Head Start Cluster Assistance Listing Number: 93.600 Pass‐through Agency: N/A Contract numbers: 10CH01029405C3 10CH01029406 10CH01204401 10HE00135801C5 10HE00135801C6 Contract periods: 01/2020‐06/2021 01/2021‐06/2021 07/2021‐12/2021 07/2021‐06/2023 07/2021‐06/2023 Criteria: As stated in the U.S. Department of Health and Human Services (HHS) Grants Policy Statement, grant recipients are required to meet the standards and requirements for financial management systems set forth or referenced in 45 CFR 74.21 or 92.20, as applicable. Further, financial systems must enable grant recipients to do the following: • Provide accurate, current, and complete financial information about Federal awards. • Maintain records that adequately identify the sources of funds for federally assisted activities and the purposes for which the award was used. • Maintain effective control over and accountability for all cash, real and personal property, and other assets under the award. • Compare actual expenditures or outlays with the approved budget for the award. • Determine the allowability of costs in accordance with the applicable federal cost principles, program regulations, and other regulations cited in the Notice of Award. • Minimize the time elapsing between any advance payment under the award(s) and disbursement of the funds for direct program costs and the proportionate share of any allowable indirect or facilities and administrative costs. Condition: The Association’s controls were not effective to ensure the financial systems migration from Intuit QuickBooks Enterprise to MIP Fund Accounting satisfied the requirements for financial reporting as stipulated by federal regulations and HHS. The initial financial reports provided by the Association did not provide accurate or complete information about the federal awards under its management. Further, initial bank reconciliation reports did not provide proof of effective control over and accountability for cash assets held under the award. This internal control deficiency is considered to be a material weakness. Context: Procedures included examining bank reconciliation reports, general ledger detail reports, and budget vs. actual reports by program and tracing to supporting documentation for a sample of transactions in each operations cycle (cash receipts, cash disbursements, payroll disbursements, journal entries). Cause: The Association changed the software used for maintaining its financial systems from Intuit QuickBooks Enterprise to MIP Fund Accounting in July 2020, beginning with their payroll processing. Full implementation of all other operating cycles occurred effective in January 2021. The system migration did not include adequate vendor support for building a chart of accounts or custom reporting tools to allow for a level of reporting required to produce timely and accurate financial statements for federal reporting needs. Further, the beginning subledgers for accounts receivable and accounts payable, and beginning outstanding reconciling items for cash accounts, were not properly built into the MIP Fund Accounting system during the early implementation process, resulting in the Association having difficulties reconciling their cash accounts. Effect: By not successfully implementing a financial system as required under federal and HHS agency regulations, the Association cannot demonstrate compliance with grantor’s requirements that require accurate, current, and complete financial information regarding the federal awards under its management. Recommendation: The Association continue to work internally and with the software vendor and outside consultants as needed to implement a chart of accounts and custom reporting tools that will assist them in complying with federal regulations regarding its financial system. View of Responsible Officials: There is no disagreement with this audit finding.

Categories

Internal Control / Segregation of Duties Allowable Costs / Cost Principles Cash Management Material Weakness Reporting

Other Findings in this Audit

  • 8676 2021-001
    Material Weakness
  • 8677 2021-002
    Significant Deficiency
  • 8678 2021-003
    Significant Deficiency
  • 8679 2021-004
    Significant Deficiency
  • 8680 2021-001
    Material Weakness
  • 8681 2021-002
    Significant Deficiency
  • 8682 2021-003
    Significant Deficiency
  • 8683 2021-004
    Significant Deficiency
  • 8685 2021-002
    Significant Deficiency
  • 8686 2021-003
    Significant Deficiency
  • 8687 2021-004
    Significant Deficiency
  • 8688 2021-001
    Material Weakness
  • 8689 2021-002
    Significant Deficiency
  • 8690 2021-003
    Significant Deficiency
  • 8691 2021-004
    Significant Deficiency
  • 8692 2021-001
    Material Weakness
  • 8693 2021-002
    Significant Deficiency
  • 8694 2021-003
    Significant Deficiency
  • 8695 2021-004
    Significant Deficiency
  • 585118 2021-001
    Material Weakness
  • 585119 2021-002
    Significant Deficiency
  • 585120 2021-003
    Significant Deficiency
  • 585121 2021-004
    Significant Deficiency
  • 585122 2021-001
    Material Weakness
  • 585123 2021-002
    Significant Deficiency
  • 585124 2021-003
    Significant Deficiency
  • 585125 2021-004
    Significant Deficiency
  • 585126 2021-001
    Material Weakness
  • 585127 2021-002
    Significant Deficiency
  • 585128 2021-003
    Significant Deficiency
  • 585129 2021-004
    Significant Deficiency
  • 585130 2021-001
    Material Weakness
  • 585131 2021-002
    Significant Deficiency
  • 585132 2021-003
    Significant Deficiency
  • 585133 2021-004
    Significant Deficiency
  • 585134 2021-001
    Material Weakness
  • 585135 2021-002
    Significant Deficiency
  • 585136 2021-003
    Significant Deficiency
  • 585137 2021-004
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
93.505 Affordable Care Act (aca) Maternal, Infant, and Early Childhood Home Visiting Program $110,512
93.600 Head Start $104,574
10.558 Child and Adult Care Food Program $14,144