Audit 304752

FY End
2023-06-30
Total Expended
$25.39M
Findings
2
Programs
28
Organization: YWCA Metropolitan Chicago (IL)
Year: 2023 Accepted: 2024-04-26

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
394863 2023-005 Material Weakness - BCEM
971305 2023-005 Material Weakness - BCEM

Programs

ALN Program Spent Major Findings
93.600 Head Start $5.78M Yes 0
93.596 Child Care Mandatory and Matching Funds of the Child Care and Development Fund $3.61M - 0
10.558 Child and Adult Care Food Program $3.08M Yes 1
14.881 Moving to Work Demonstration Program $2.08M - 0
93.575 Covid-19 - Child Care and Development Block Grant $908,132 - 0
16.575 Crime Victim Assistance $672,678 - 0
93.575 Child Care and Development Block Grant $318,004 - 0
17.259 Wia Youth Activities $245,073 - 0
17.258 Wia Adult Program $197,962 - 0
84.215 Fund for the Improvement of Education $163,685 - 0
14.218 Community Development Block Grants/entitlement Grants $163,143 - 0
93.497 Covid-19 - Family Violence Prevention and Services/ Sexual Assault/rape Crisis Services and Supports $138,222 - 0
93.558 Temporary Assistance for Needy Families $132,218 - 0
14.267 Continuum of Care Program $124,469 - 0
16.588 Violence Against Women Formula Grants $119,312 - 0
93.667 Social Services Block Grant $83,405 - 0
59.037 Small Business Development Centers $72,965 - 0
10.537 Supplemental Nutrition Assistance Program (snap) Employment and Training (e&t) Data and Technical Assistance Grants $67,320 - 0
21.023 Covid-19 - Emergency Rental Assistance Program $65,956 - 0
14.218 Covid-19 - Community Development Block Grants/entitlement Grants $62,144 - 0
21.027 Covid-19 - Coronavirus State and Local Fiscal Recovery Funds $57,153 - 0
17.278 Wia Dislocated Worker Formula Grants $56,359 - 0
93.600 Covid-19 - Head Start $41,455 Yes 0
84.425 Covid-19 - Education Stabilization Fund $32,474 - 0
16.034 Coronavirus Emergency Supplemental Funding Program $18,886 - 0
16.524 Legal Assistance for Victims $6,655 - 0
93.434 Every Student Succeeds Act/preschool Development Grants $5,000 - 0
93.136 Injury Prevention and Control Research and State and Community Based Programs $1,226 - 0

Contacts

Name Title Type
YB9CJGZ9KN66 Anjanette Brown Auditee
3127622702 Toni Diprizio Auditor
No contacts on file

Notes to SEFA

Title: Insurance Coverage Accounting Policies: The accompanying schedule of expenditures of federal awards (the “Schedule”) includes the federal grant activity of YWCA Metropolitan Chicago (the “Agency”) under programs of the federal government for the year ended June 30, 2023. The information in the Schedule is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (the “Uniform Guidance”). Because the Schedule presents only a selected portion of the operations of the Agency, it is not intended to and does not present the financial position, changes in net assets, functional expenses, or cash flows of the Agency. Expenditures reported in the Schedule are reported on the accrual basis of accounting. Such expenditures are recognized following the cost principles contained in Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, wherein certain types of expenditures are not allowable or are limited as to reimbursement. The pass through entity identifying numbers are presented where available. The Agency has elected not to use the 10 percent de minimis indirect cost rate to recover indirect costs, as allowed under the Uniform Guidance. De Minimis Rate Used: N Rate Explanation: The Agency has elected not to use the 10 percent de minimis indirect cost rate to recover indirect costs, as allowed under the Uniform Guidance. YWCA Metropolitan Chicago has no federal insurance.
Title: Noncash Assistance Accounting Policies: The accompanying schedule of expenditures of federal awards (the “Schedule”) includes the federal grant activity of YWCA Metropolitan Chicago (the “Agency”) under programs of the federal government for the year ended June 30, 2023. The information in the Schedule is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (the “Uniform Guidance”). Because the Schedule presents only a selected portion of the operations of the Agency, it is not intended to and does not present the financial position, changes in net assets, functional expenses, or cash flows of the Agency. Expenditures reported in the Schedule are reported on the accrual basis of accounting. Such expenditures are recognized following the cost principles contained in Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, wherein certain types of expenditures are not allowable or are limited as to reimbursement. The pass through entity identifying numbers are presented where available. The Agency has elected not to use the 10 percent de minimis indirect cost rate to recover indirect costs, as allowed under the Uniform Guidance. De Minimis Rate Used: N Rate Explanation: The Agency has elected not to use the 10 percent de minimis indirect cost rate to recover indirect costs, as allowed under the Uniform Guidance. The value of the noncash assistance received was determined in accordance with the provisions of the Uniform Guidance. No noncash assistance was received during the year ended June 30, 2023.

Finding Details

Assistance Listing, Federal Agency, and Program Name 10.558, U.S. Department of Agriculture, Child Care and Adult Food Program Federal Award Identification Number and Year 15 016 271P 00 Pass through Entity Illinois State Board of Education Finding Type Material weakness Repeat Finding No Criteria Per 2 CFR 200.303(a), the nonfederal entity must establish and maintain effective internal control over the federal award that provides reasonable assurance that the nonfederal 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). Other requirements include: a) Per 7 CFR 226.10(c)(1), prior to submitting its consolidated monthly claim to the State agency, each sponsoring organization must perform edit checks on each facility's meal claim; per 7 CFR sections 226.16(g) and (h), a sponsoring organization must disburse advance and meal reimbursement payments to centers and day care homes under its sponsorship within five working days of receiving them from its state agency. b) Per 7 CFR 226.15(f), each sponsoring organization of day care homes shall determine which of the day care homes under its sponsorship are eligible as tier I day care homes. c) Communication from the passthrough entity to return to pre COVID 19 monitoring, as required under 7 CFR 226.16(d)(4)(iii), effective October 1, 2022, where sponsoring organizations are required to perform onsite monitoring of each of its facilities three times every year, which includes requirements to ensure the amount of time between reviews does not exceed six months (unless review average is used). Condition A lack of documented controls as evidence of supervisory review and segregation of duties to ensure compliance with Federal program requirements, specifically over: a) monthly expenditure reports submitted to the passthrough entity b) tier (day care home eligibility) determinations c) subrecipient monitoring Questioned Costs None Identification of How Questioned Costs Were Computed N/A no instances of material noncompliance noted that would result in questioned costs Context a) During testing a sample of 5 monthly expenditure submissions, we noted no formally documented supervisory review in place. Additionally, during testing of 40 disbursements to providers, we noted no formally documented supervisory review to ensure disbursements to providers are made within 5 working days of receipt from the State passthrough entity. b) While gaining an understanding of controls over tier (day care home eligibility) determinations, we noted no controls established to ensure supervisory review of these determinations. c) While testing a sample 40 provider monitoring visits, we noted 3 visits without evidence of supervisory review and 6 visits where the visit was completed and validated in the software by the same individual. Additionally, we noted 16 day care homes and 2 day care centers with less than the required 3 annual on site monitoring visits for the year, and 15 day care homes and 2 day care centers where onsite monitoring performed were more than the required 6 months apart. Cause and Effect A lack of effectively designed, implemented, and operating controls in any of these area could result in a material noncompliance with program requirements or Uniform Guidance. Recommendation We recommend management formalize documentation of a supervisory review of: a) monthly expenditure submissions before submitting to the passthrough entity, including documented supervisory controls to ensure disbursement timeliness is met within 5 working days as part of this review; b) of data used in making tier/eligibility determinations for accuracy and completeness; and c) of subrecipient monitoring. Additionally, we recommend management work with its passthrough entities to cofirm compliance requirements, especially when compliance requirements change as the result of ending or expiring waivers and flexibilities. Views of Responsible Officials and Corrective Action Plan Management agrees with the recommendations. a) Management will put into place a formal procedure to support evidence of the second review over the monthly expenditure submissions taking place by April 2024. Management also notes that there are no instances in which the Organization did not provide funds to the provider within the mandated 5 days, however, the Organization will begin formally documenting the process of review over provider payments within 5 days by April 30, 2024. b) The software required to be used by the funder for management of the program does have limitations on how the data input for making tier/eligibility determinations and necessary second review is documented. The Organization will design a process to document this second review by April 30, 2024. c) Management believes staffing shortages coming out the COVID 19 waivers resulted in the inability to perform all required Subrecipient monitoring, however, this staffing shortage has been rectified as of August 31, 2023.
Assistance Listing, Federal Agency, and Program Name 10.558, U.S. Department of Agriculture, Child Care and Adult Food Program Federal Award Identification Number and Year 15 016 271P 00 Pass through Entity Illinois State Board of Education Finding Type Material weakness Repeat Finding No Criteria Per 2 CFR 200.303(a), the nonfederal entity must establish and maintain effective internal control over the federal award that provides reasonable assurance that the nonfederal 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). Other requirements include: a) Per 7 CFR 226.10(c)(1), prior to submitting its consolidated monthly claim to the State agency, each sponsoring organization must perform edit checks on each facility's meal claim; per 7 CFR sections 226.16(g) and (h), a sponsoring organization must disburse advance and meal reimbursement payments to centers and day care homes under its sponsorship within five working days of receiving them from its state agency. b) Per 7 CFR 226.15(f), each sponsoring organization of day care homes shall determine which of the day care homes under its sponsorship are eligible as tier I day care homes. c) Communication from the passthrough entity to return to pre COVID 19 monitoring, as required under 7 CFR 226.16(d)(4)(iii), effective October 1, 2022, where sponsoring organizations are required to perform onsite monitoring of each of its facilities three times every year, which includes requirements to ensure the amount of time between reviews does not exceed six months (unless review average is used). Condition A lack of documented controls as evidence of supervisory review and segregation of duties to ensure compliance with Federal program requirements, specifically over: a) monthly expenditure reports submitted to the passthrough entity b) tier (day care home eligibility) determinations c) subrecipient monitoring Questioned Costs None Identification of How Questioned Costs Were Computed N/A no instances of material noncompliance noted that would result in questioned costs Context a) During testing a sample of 5 monthly expenditure submissions, we noted no formally documented supervisory review in place. Additionally, during testing of 40 disbursements to providers, we noted no formally documented supervisory review to ensure disbursements to providers are made within 5 working days of receipt from the State passthrough entity. b) While gaining an understanding of controls over tier (day care home eligibility) determinations, we noted no controls established to ensure supervisory review of these determinations. c) While testing a sample 40 provider monitoring visits, we noted 3 visits without evidence of supervisory review and 6 visits where the visit was completed and validated in the software by the same individual. Additionally, we noted 16 day care homes and 2 day care centers with less than the required 3 annual on site monitoring visits for the year, and 15 day care homes and 2 day care centers where onsite monitoring performed were more than the required 6 months apart. Cause and Effect A lack of effectively designed, implemented, and operating controls in any of these area could result in a material noncompliance with program requirements or Uniform Guidance. Recommendation We recommend management formalize documentation of a supervisory review of: a) monthly expenditure submissions before submitting to the passthrough entity, including documented supervisory controls to ensure disbursement timeliness is met within 5 working days as part of this review; b) of data used in making tier/eligibility determinations for accuracy and completeness; and c) of subrecipient monitoring. Additionally, we recommend management work with its passthrough entities to cofirm compliance requirements, especially when compliance requirements change as the result of ending or expiring waivers and flexibilities. Views of Responsible Officials and Corrective Action Plan Management agrees with the recommendations. a) Management will put into place a formal procedure to support evidence of the second review over the monthly expenditure submissions taking place by April 2024. Management also notes that there are no instances in which the Organization did not provide funds to the provider within the mandated 5 days, however, the Organization will begin formally documenting the process of review over provider payments within 5 days by April 30, 2024. b) The software required to be used by the funder for management of the program does have limitations on how the data input for making tier/eligibility determinations and necessary second review is documented. The Organization will design a process to document this second review by April 30, 2024. c) Management believes staffing shortages coming out the COVID 19 waivers resulted in the inability to perform all required Subrecipient monitoring, however, this staffing shortage has been rectified as of August 31, 2023.