Finding 39703 (2022-006)

Material Weakness
Requirement
L
Questioned Costs
-
Year
2022
Accepted
2023-03-13
Audit: 36821
Auditor: Dwc CPAS LLC

AI Summary

  • Core Issue: The Schedule of Expenditures did not properly identify COVID-19 funding and contained outdated and misclassified information.
  • Impacted Requirements: This violates the Uniform Guidance and federal regulations for accurate reporting of federal awards.
  • Recommended Follow-Up: Management should allocate sufficient resources to the Finance and Administration department to improve tracking and reporting of grant awards.

Finding Text

Criteria: The Uniform Guidance requires the auditee to prepare a complete and accurate Schedule of Expenditures of Federal Awards. In addition, Title 2 U.S. Code of Federal Regulations Part 200, Appendix XI 2022 Compliance Supplement Appendix VII Other Audit Advisories requires recipients and subrecipients to separately identify COVID-19 Emergency Acts expenditures on the Schedule. Condition: The Schedule of Expenditures of Federal and Nonfederal Awards (the Schedule) prepared by the Organization did not separately identify American Rescue Plan COVID-19 funding for Assistance Listing No. 93.568 awards. In addition, the Schedule prepared by the Organization contained many pass-through award identification numbers that were not updated from the prior year, mis-identified certain awards as being COVID-19 funded when they weren?t, and contained various classification errors. Cause: Management was unable to accurately identify the source of funding and other information included on the Schedule. Effect or Potential Effect: The Organization did not comply with Federal regulations regarding federal award reporting. The late identification of certain funding delayed completion of the audit. Context: Prior to audit adjustments, the Schedule contained material errors. Repeat Finding: No. Recommendations: We recommend that management provide adequate resources to the Finance and Administration department to properly manage, track, and report grant awards.

Categories

Reporting Subrecipient Monitoring Matching / Level of Effort / Earmarking

Other Findings in this Audit

  • 39698 2022-006
    Material Weakness
  • 39699 2022-006
    Material Weakness
  • 39700 2022-006
    Material Weakness
  • 39701 2022-006
    Material Weakness
  • 39702 2022-006
    Material Weakness
  • 616140 2022-006
    Material Weakness
  • 616141 2022-006
    Material Weakness
  • 616142 2022-006
    Material Weakness
  • 616143 2022-006
    Material Weakness
  • 616144 2022-006
    Material Weakness
  • 616145 2022-006
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
21.023 Covid-19 Emergency Rental Assistance Program $1.63M
93.045 Special Programs for the Aging_title Iii, Part C_nutrition Services $1.54M
93.568 Covid-19 Low-Income Home Energy Assistance $1.10M
93.569 Community Services Block Grant $833,504
93.667 Social Services Block Grant $728,264
93.044 Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers $670,261
93.569 Covid-19 Community Services Block Grant $630,949
93.778 Medical Assistance Program $514,678
14.231 Covid-19 Emergency Solutions Grant Program $472,395
93.053 Nutrition Services Incentive Program $337,107
93.778 Covid-19 Medical Assistance Program $308,708
81.042 Weatherization Assistance for Low-Income Persons $244,881
94.011 Foster Grandparent Program $139,289
93.568 Low-Income Home Energy Assistance $91,497
93.043 Special Programs for the Aging_title Iii, Part D_disease Prevention and Health Promotion Services $89,379
20.513 Enhanced Mobility of Seniors and Individuals with Disabilities $40,267
93.044 Covid-19 Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers $38,595
93.048 Covid-19 Special Programs for the Aging_title Iv_and Title Ii_discretionary Projects $35,000
14.218 Community Development Block Grants/entitlement Grants $28,898
93.052 National Family Caregiver Support, Title Iii, Part E $26,296
93.470 Alzheimer's Disease Program Initiative (adpi) $23,009
93.042 Special Programs for the Aging_title Vii, Chapter 2_long Term Care Ombudsman Services for Older Individuals $15,474
97.024 Emergency Food and Shelter National Board Program $14,000
93.041 Special Programs for the Aging_title Vii, Chapter 3_programs for Prevention of Elder Abuse, Neglect, and Exploitation $8,965
93.048 Special Programs for the Aging_title Iv_and Title Ii_discretionary Projects $1,795