Finding 1156697 (2024-002)

Material Weakness Repeat Finding
Requirement
AB
Questioned Costs
-
Year
2024
Accepted
2025-09-30
Audit: 369065
Organization: Advocate Aurora Health, Inc. (IL)

AI Summary

  • Core Issue: Internal controls were insufficient to accurately record changes in employee effort certifications for salaries charged to the grant.
  • Impacted Requirements: Compliance with Sections 200.303 and 200.430(g)(1)(vi) of the Uniform Guidance regarding internal control and documentation of personnel expenses.
  • Recommended Follow-Up: Management should implement procedures to ensure timely updates of effort changes in the general ledger and communicate discrepancies to the Grant Accounting team.

Finding Text

Federal Agency: United States Department of Agriculture Food and Nutrition Service ALN: 16.575 Crime Victim Assistance (VOCA) Pass-Through Grantor: State of Illinois, Illinois Criminal Justice Information Authority and State of Wisconsin Department of Justice Pass-Through Award Number: 2021/2022-VO-A/VO-01-18139; 2023-VO-01-18830; 218690; 218692 Pass-Through Award Period: 10/1/2023 to 9/30/2025 Criteria or specific requirement (including statutory, regulatory or other citation): Section 200.303 of the Uniform Guidance states the following regarding internal control: “The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).” Section 200.430(g)(1)(vi) of the Uniform Guidance states that the standards for documentation of personnel expense must “Support the distribution of the employee’s salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity”. Condition: Management did not have sufficiently designed internal controls to ensure that approved changes in employees’ effort certifications for salaries and wages were accurately recorded and charged to the grant. Cause: The Organization has internal controls in place to ensure employees’ effort certifications are approved. However, the Organization did not have internal controls to ensure that changes in employees’ certified effort were recorded and charged to the grant. Effect or potential effect: Unallowable payroll costs may be charged to the federal program. Questioned costs: $707 – Grant 218692 Context: We tested a sample of 25 payroll expenses, which totaled $28,826, for the period January 1, 2024 through December 31, 2024 and identified 3 transactions, which totaled $5,848. These three transactions had a change in effort during the period that was not reflected in the labor distribution causing the Advocate Aurora Health, Inc. to overcharge the grant by $707. The total VOCA expenditures reported on the Schedule are $2,098,275 for the year ended December 31, 2024. Payroll costs totaled $1,690,963, representing 84% of the total VOCA expenditures. Identification as a repeat finding, if applicable: This is not a repeat finding. Recommendation: Management should ensure that changes in effort made as a result of effort report certifications are reflected in the general ledger. Views of responsible officials: Advocate Aurora Management will develop and implement written procedures to ensure the timely communication of discrepancies identified during the effort certification process to the Grant Accounting team for appropriate review and adjustment.

Corrective Action Plan

Finding 2024-002 Crime Victim Assistance (ALN 16.575) The Organization has internal controls in place to ensure employees’ effort certifications are approved. However, the Organization did not have internal controls to ensure that allchanges in employees’ certified effort were communicated, recorded and charged to the grant. Management Response: Management will develop and implement written procedures to ensure the timely communication of discrepancies identified during the effort certification process to the Grant Accounting team for appropriate review and adjustment. Program staff will be trained in the new process, and reviews will be conducted to monitor compliance and ensure the continued effectiveness of the process. Contact Person (s) Responsible for Corrective Action: David McDermott, Grants Director and Venice Northe, Grants Accounting Manager. Anticipated Completion Date: December 31, 2025.

Categories

Allowable Costs / Cost Principles Matching / Level of Effort / Earmarking

Other Findings in this Audit

  • 1156690 2024-001
    Material Weakness Repeat
  • 1156691 2024-001
    Material Weakness Repeat
  • 1156692 2024-002
    Material Weakness Repeat
  • 1156693 2024-002
    Material Weakness Repeat
  • 1156694 2024-002
    Material Weakness Repeat
  • 1156695 2024-002
    Material Weakness Repeat
  • 1156696 2024-002
    Material Weakness Repeat
  • 1156698 2024-003
    Material Weakness Repeat
  • 1156699 2024-003
    Material Weakness Repeat
  • 1156700 2024-003
    Material Weakness Repeat
  • 1156701 2024-003
    Material Weakness Repeat
  • 1156702 2024-003
    Material Weakness Repeat
  • 1156703 2024-003
    Material Weakness Repeat
  • 1156704 2024-004
    Material Weakness Repeat
  • 1156705 2024-004
    Material Weakness Repeat
  • 1156706 2024-003
    Material Weakness Repeat
  • 1156707 2024-003
    Material Weakness Repeat
  • 1156708 2024-003
    Material Weakness Repeat
  • 1156709 2024-003
    Material Weakness Repeat
  • 1156710 2024-003
    Material Weakness Repeat
  • 1156711 2024-003
    Material Weakness Repeat
  • 1156712 2024-003
    Material Weakness Repeat
  • 1156713 2024-003
    Material Weakness Repeat
  • 1156714 2024-003
    Material Weakness Repeat
  • 1156715 2024-005
    Material Weakness Repeat
  • 1156716 2024-005
    Material Weakness Repeat
  • 1156717 2024-005
    Material Weakness Repeat
  • 1156718 2024-005
    Material Weakness Repeat
  • 1156719 2024-005
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
93.399 Cancer Control $996,083
93.788 Opioid Str $833,967
10.557 Wic Special Supplemental Nutrition Program for Women, Infants, and Children $781,999
16.575 Crime Victim Assistance $733,904
93.073 Birth Defects and Developmental Disabilities - Prevention and Surveillance $476,939
93.889 National Bioterrorism Hospital Preparedness Program $426,242
93.958 Block Grants for Community Mental Health Services $419,516
21.019 Coronavirus Relief Fund $359,651
93.866 Aging Research $329,450
84.116 Fund for the Improvement of Postsecondary Education $318,505
93.959 Block Grants for Prevention and Treatment of Substance Abuse $268,777
93.226 Research on Healthcare Costs, Quality and Outcomes $262,701
21.027 Coronavirus State and Local Fiscal Recovery Funds $242,974
16.753 Congressionally Recommended Awards $226,240
93.493 Congressional Directives $184,115
93.083 Prevention of Disease, Disability, and Death Through Immunization and Control of Respiratory and Related Diseases $181,349
93.778 Medical Assistance Program $123,305
93.350 National Center for Advancing Translational Sciences $120,845
93.307 Minority Health and Health Disparities Research $96,018
93.840 Translation and Implementation Science Research for Heart, Lung, Blood Diseases, and Sleep Disorders $95,460
93.395 Cancer Treatment Research $91,050
16.588 Violence Against Women Formula Grants $88,183
93.242 Mental Health Research Grants $82,002
93.566 Refugee and Entrant Assistance State/replacement Designee Administered Programs $68,903
20.600 State and Community Highway Safety $65,308
93.837 Cardiovascular Diseases Research $61,010
10.136 American Rescue Plan Act of 2021 Loan Payment $60,648
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $47,812
93.497 Family Violence Prevention and Services/ Sexual Assault/rape Crisis Services and Supports $18,500
93.969 Pphf Geriatric Education Centers $17,696
10.555 National School Lunch Program $4,884
10.558 Child and Adult Care Food Program $1,372