Finding 1024043 (2022-003)

Material Weakness Repeat Finding
Requirement
AN
Questioned Costs
-
Year
2022
Accepted
2023-06-08

AI Summary

  • Core Issue: The Schedule of Expenditures of Federal Awards (SEFA) was not prepared accurately, requiring material adjustments to comply with federal guidelines.
  • Impacted Requirements: Compliance with Uniform Guidance (2 C.F.R. Part 200) was not met due to inadequate reconciliation and oversight of federal and non-federal expenses.
  • Recommended Follow-Up: Management should enhance reconciliation processes and implement a review system for SEFA preparation to ensure accuracy and compliance.

Finding Text

2022-003 - Schedule of Expenditures of Federal Awards (SEFA) PreparationCriteria: Under Uniform Guidance (2 C.F.R. Part 200) Subpart F Section 200.502 the auditee must alsoprepare a Schedule of Expenditures of Federal Awards (SEFA) for the period covered by the auditee'sfinancial statements which must include the total of all federal awards expended.Condition: Material audit adjustments were required to present a complete and accurate SEFA incompliance with those of Uniform Guidance.Cause: The Agency need to enhance reconciliation of grant vouchers/accruals with general ledger activitythroughout the year. These reconciliations should be analyzed by a member of management with adequateexperience and training to properly recognize revenue in accordance with grants agreements. Further, thepreparation of the SEFA process lacks adequate analysis and oversight.Effect: Several SEFA versions prepared by management required material adjustments to present theAgency?s federal expenditures in accordance with the requirements of Uniform Guidance, including properlydelineating federal vs. non-federal expenses.Recommendation: We recommend that management implement a process to reconcile and review grantvouchers and reports to the general ledger activity throughout the year, including evaluating the revenueand expense relationship. We recommend management implement an oversight function over the processof preparing the SEFA.Views of Responsible Official and Planned Corrective Actions: The Executive Director and Senior Director ofFinance will update year-end closing procedures and checklists to support completion of closing in January ofeach year. The existing process will be documented indicating the Controller will complete the SEFA and asecond review will be completed by a separate individual.

Categories

Reporting Matching / Level of Effort / Earmarking

Other Findings in this Audit

  • 447599 2022-001
    Material Weakness Repeat
  • 447600 2022-002
    Material Weakness Repeat
  • 447601 2022-003
    Material Weakness Repeat
  • 447602 2022-004
    - Repeat
  • 1024041 2022-001
    Material Weakness Repeat
  • 1024042 2022-002
    Material Weakness Repeat
  • 1024044 2022-004
    - Repeat

Programs in Audit

ALN Program Name Expenditures
93.600 Head Start $2.75M
10.557 Special Supplemental Nutrition Program for Women, Infants, and Children $1.92M
16.575 Crime Victim Assistance $587,839
93.569 Community Services Block Grant $372,019
93.575 Child Care and Development Block Grant $365,271
14.267 Continuum of Care Program $278,921
93.053 Nutrition Services Incentive Program $254,905
93.235 Affordable Care Act (aca) Abstinence Education Program $250,539
93.912 Rural Health Care Services Outreach, Rural Health Network Development and Small Health Care Provider Quality Improvement $229,282
93.623 Basic Center Grant $217,361
16.021 Justice Systems Response to Families $168,831
16.888 Consolidated and Technical Assistance Grant Program to Address Children and Youth Experiencing Domestic and Sexual Violence and Engage Men and Boys As Allies $153,517
16.589 Rural Domestic Violence, Dating Violence, Sexual Assault, and Stalking Assistance Program $144,893
16.736 Transitional Housing Assistance for Victims of Domestic Violence, Dating Violence, Stalking, Or Sexual Assault $143,212
10.558 Child and Adult Care Food Program $140,685
93.778 Medical Assistance Program $132,026
93.498 Provider Relief Fund $73,460
93.671 Family Violence Prevention and Services/domestic Violence Shelter and Supportive Services $49,896
93.044 Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers $43,508
10.559 Summer Food Service Program for Children $38,947
93.558 Temporary Assistance for Needy Families $19,125
93.434 Every Student Succeeds Act/preschool Development Grants $14,485
93.991 Preventive Health and Health Services Block Grant $14,152
93.994 Maternal and Child Health Services Block Grant to the States $12,876
17.258 Wia Adult Program $7,118
93.550 Transitional Living for Homeless Youth $6,175
93.767 Children's Health Insurance Program $6,022
10.555 National School Lunch Program $5,239
16.017 Sexual Assault Services Formula Program $4,676
10.553 School Breakfast Program $3,279