Finding 12829 (2022-001)

Material Weakness Repeat Finding
Requirement
B
Questioned Costs
-
Year
2022
Accepted
2023-04-09

AI Summary

  • Core Issue: The Agency is not regularly reconciling grant reports with financial records, leading to potential inaccuracies in reported amounts.
  • Impacted Requirements: Compliance with grant reporting and monitoring requirements is lacking, including incomplete personnel activity reports and absence of compliance reviews.
  • Recommended Follow-Up: Establish written procedures for regular reconciliations, ensure all employees submit personnel activity reports, and conduct periodic compliance reviews.

Finding Text

Finding 2022-001 ? Controls over Grant Reporting and Monitoring (Repeat Finding) Federal Agency: U.S. Department of Health and Human Services Pass-through Entity: Illinois Department on Aging Federal Program: Aging Cluster (Federal Assistance Listing No.?s 93.044, 93.045, 93.053) Requirement: Allowable Costs and Reporting Criteria: To ensure the correctness and completeness of the various required grant reporting performed by the Agency, it is critical to have a process in place to regularly reconcile underlying financial records with the grant reports and ensure the underlying costs in the financial records can be supported. It is also imperative to have monitoring procedures in place to ensure compliance to all grant requirements. Condition: During the course of our audit, we noted that the Agency is not performing regular reconciliations between the general ledger and the grant reports. Management is using several worksheets to determine the grant report amounts, and it is evident that the Agency is allotting adequate time to prepare the grant reporting. However, we were not able to determine that the Agency is reconciling the reported amounts to the underlying financial documentation on a regular or cumulative basis. Additionally, it was observed that personnel activity reports were not completed for all employees as required by certain grant agreements. We also noted that no compliance review is being performed to ensure adherence to all grant requirements. Cause: There is currently no reconciliation process being maintained for each of the various grant sources. The Agency continues to improve in this area from the prior years, however, a formal reconciliation is not being performed. Regarding personnel activity reports, supporting documentation is not available for all employees? actual time spent and charged to the grants. We also were not able to obtain any monitoring documentation indicating that a formal process has been developed to ensure grant compliance. Effect: Without timely reconciliations, personnel activity reports, and monitoring processes, grant expenditures can be omitted or overstated on the submitted grant reporting and other grant noncompliance could be overlooked. This could result in missed funding or noncompliance with the grant agreement which could lead to adverse conditions with the grantor. Recommendation: We recommend that the Agency develop written procedures that require all grant reports are reconciled to the internal accounting records prior to submission. This reconciliation should be presented in a clear and concise manner to enable another party to review and approve before ultimately submitted it to the grantor. This should be attainable as each grant is coded separately. Additionally, we recommend the Agency implement that all employees submit personnel activity reports to provide documentation of their time that is reimbursed by each grant. We also recommend that the Agency require a periodic review of the adherence to the various grant compliance requirements and note such a review was performed. Response: The board and management continue to gain a better understanding of the grant reconciliation process. A procedure is intended to be put in place to reconcile grant reports to the general ledger, Procedures to implement the collection of employee activity reports and periodic reviews with the board showing grant funds used compared to grant funds requested from the grantor. See Corrective Action Plan.

Categories

Subrecipient Monitoring Allowable Costs / Cost Principles Reporting

Other Findings in this Audit

  • 12825 2022-001
    Material Weakness Repeat
  • 12826 2022-001
    Material Weakness Repeat
  • 12827 2022-001
    Material Weakness Repeat
  • 12828 2022-001
    Material Weakness Repeat
  • 12830 2022-001
    Material Weakness Repeat
  • 12831 2022-001
    Material Weakness Repeat
  • 589267 2022-001
    Material Weakness Repeat
  • 589268 2022-001
    Material Weakness Repeat
  • 589269 2022-001
    Material Weakness Repeat
  • 589270 2022-001
    Material Weakness Repeat
  • 589271 2022-001
    Material Weakness Repeat
  • 589272 2022-001
    Material Weakness Repeat
  • 589273 2022-001
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
93.053 Nutrition Services Incentive Program $143,269
93.045 Special Programs for the Aging_title Iii, Part C_nutrition Services $80,000
93.324 State Health Insurance Assistance Program $24,594
93.052 National Family Caregiver Support, Title Iii, Part E $22,095
93.048 Special Programs for the Aging_title Iv_and Title Ii_discretionary Projects $16,000
93.071 Medicare Enrollment Assistance Program $7,257
93.041 Special Programs for the Aging_title Vii, Chapter 3_programs for Prevention of Elder Abuse, Neglect, and Exploitation $4,710
93.044 Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers $2,112
93.043 Special Programs for the Aging_title Iii, Part D_disease Prevention and Health Promotion Services $1,063