Finding 20966 (2022-001)

Material Weakness
Requirement
H
Questioned Costs
-
Year
2022
Accepted
2023-09-13

AI Summary

  • Core Issue: A formula error led to incorrect calculations for a contract's expenditures, affecting federal audit compliance.
  • Impacted Requirements: Internal controls must ensure accurate reporting of all expenditures on the Schedule of Expenditures of Federal Awards and State Financial Assistance.
  • Recommended Follow-Up: Conduct a thorough review of the Schedule to confirm all expenditures are correctly reported and implement additional review procedures.

Finding Text

We recommend certain improvements related to the preparation and review of the Organization?s Schedule of Expenditures of Federal Awards and State Financial Assistance. Condition: The Organization incorrectly calculated the expenditures for one contract that was subject to federal single audit reporting requirements. Criteria: Internal controls should be in place to provide reasonable assurance that all expenditures subject to federal single audit requirements are correctly included on the Schedule of Expenditures of Federal Awards and State Financial Assistance. Cause: We understand that due to a formula error on a spreadsheet, management inadvertently miscalculated the expenditures of one contract as it relates to the Organization?s responsibilities pursuant to the federal single audit reporting requirements, which was not identified in the review of the Schedule of Expenditures of Federal Awards and State Financial Assistance. Effect: The condition presents an elevated risk of the Organization preparing an inaccurate Schedule of Expenditures of Federal Awards and State Financial Assistance. Context: The auditor identified the miscalculation of the contract through its designed auditing procedures. No other similar exceptions were noted as a result of audit procedures. Repeat Finding: This finding is not a repeat finding from a prior audit. Recommendation: We recommend that the Organization carefully review the Schedule of Expenditures of Federal Awards and State Financial Assistance to ensure all expenditures subject to federal single audit requirements are properly included. Views of Responsible Officials and Planned Corrective Action: The Organization agrees with the finding and will develop additional procedures for the review of the Schedule of Expenditures of Federal Awards and State Financial Assistance.

Categories

Reporting

Other Findings in this Audit

  • 20965 2022-001
    Material Weakness
  • 20967 2022-001
    Material Weakness
  • 20968 2022-001
    Material Weakness
  • 597407 2022-001
    Material Weakness
  • 597408 2022-001
    Material Weakness
  • 597409 2022-001
    Material Weakness
  • 597410 2022-001
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
93.658 Foster Care_title IV-E $1.90M
16.575 Crime Victim Assistance $1.14M
93.667 Social Services Block Grant $235,930
93.659 Adoption Assistance $200,736
93.558 Temporary Assistance for Needy Families $100,261
93.645 Stephanie Tubbs Jones Child Welfare Services Program $31,798
93.556 Promoting Safe and Stable Families $8,823
93.575 Child Care and Development Block Grant $1,404
93.669 Child Abuse and Neglect State Grants $538