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

Corrective Action Plan

We concur with the recommendation. Management has remediated the finding. Funding is now separately identified on the Schedule of Expenditures of Federal and Nonfederal Awards. Additionally, Management has allocated additional resources to the Finance and Administration department to properly manage, track, and report grant awards. A shared SEFA index is maintained and a process for updating the document on an ongoing basis was instituted.

Categories

Reporting Subrecipient Monitoring Matching / Level of Effort / Earmarking

Other Findings in this Audit

  • 39699 2022-006
    Material Weakness
  • 39700 2022-006
    Material Weakness
  • 39701 2022-006
    Material Weakness
  • 39702 2022-006
    Material Weakness
  • 39703 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