Corrective Action Plans

2022-003: Significant Deficiency ? Suspension and Debarment Recommendation: We recommend the County retain documentation related to the applicable federal requirements to ensure compliance with said federal requirements. Explanation of disagreement with audit finding: There is no disagreement with ...

2022-003: Significant Deficiency ? Suspension and Debarment Recommendation: We recommend the County retain documentation related to the applicable federal requirements to ensure compliance with said federal requirements. Explanation of disagreement with audit finding: There is no disagreement with the audit finding. Repeat Finding: Yes ? See finding 2021-006 for similar finding in prior year. Management Response/Corrective Action: Procedures will be put in place to implement a policy of maintaining documentation related to suspension and debarment checks. Name of the Contact Person Responsible for Corrective Action: Tara Horn, County Auditor, (816) 271-1408 Planned Completion Date for Corrective Action Plan: December 31, 2023

View Audit 31794

Finding 36244 (2022-003)

Significant Deficiency 2022

Hope Community Resources, Inc. & Affiliates

AK

Reporting Significant Deficiency Internal Control / Segregation of Duties

Finding 2022-003 Significant Deficiency in Internal Control over Compliance, Noncompliance ? Reporting Corrective Action Plan The audit took longer than anticipated due to the source documentation required to validate prior audits since Hope switched from KPMG to BDO. Going forward, there should be ...

Finding 2022-003 Significant Deficiency in Internal Control over Compliance, Noncompliance ? Reporting Corrective Action Plan The audit took longer than anticipated due to the source documentation required to validate prior audits since Hope switched from KPMG to BDO. Going forward, there should be a significant shortening of audit timelines, which will allow the single audit to be filed within the required parameters. Expected Completion Date 9/1/23

View Audit 36980

Finding 36243 (2022-002)

Material Weakness 2022

Hope Community Resources, Inc. & Affiliates

AK

Internal Control / Segregation of Duties Subrecipient Monitoring Material Weakness

Finding 2022-002 Material Weakness in Internal Control over Compliance, Noncompliance ? Reporting Corrective Action Plan Weakness referenced Uniform Guidance Reporting that is not applicable going forward due to federal program discontinuing. Expected Completion Date Please see above.

View Audit 36980

Finding 36235 (2022-002)

Material Weakness 2022

Sheboygan Area School District

WI

Questioned Costs Special Tests & Provisions Material Weakness

Special Tests and Provisions ? Wage Rate Requirements There is no disagreement with the finding. Management immediately began to review policies and procedures. District Contacts: Mark Boehlke, Assistant Superintendent, Business and Operational Services Wendy Baackes, Coordinator ...

Special Tests and Provisions ? Wage Rate Requirements There is no disagreement with the finding. Management immediately began to review policies and procedures. District Contacts: Mark Boehlke, Assistant Superintendent, Business and Operational Services Wendy Baackes, Coordinator of Financial Services Finding 2022-002 expected to be corrected during the 2022-23 fiscal year.

View Audit 34159 Questioned Costs: $1

Finding 36227 (2022-006)

Material Weakness 2022

Oakland Unified School District

CA

Material Weakness Reporting Internal Control / Segregation of Duties

Responsible Individuals: Marth Pena, Coordinator of Afterschool Programs Corrective Action Plan: OUSD has implemented a new Expanded Learning Attendance improved tracking system and provided training to service providers. This new database allows for accurate and prompt attendance taking. 1. OUS...

Responsible Individuals: Marth Pena, Coordinator of Afterschool Programs Corrective Action Plan: OUSD has implemented a new Expanded Learning Attendance improved tracking system and provided training to service providers. This new database allows for accurate and prompt attendance taking. 1. OUSD transitioned to a new attendance tracking system. Due to the multiple errors and consistent changes in attendance, OUSD began using Aeries Supplemental Attendance tracking instead of CitySpan in fall 2021. This transition has allowed the Expanded Learning Office to support struggling sites with real-time accurate attendance data. 2. On July 29, OUSD held a mandatory Aeries training for all after-school staff and reviewed all CDE (ASES, 21st CCLC, and ASSETS) attendance requirements. Over 100 after-school staff attended. 3. All Attendance documents were revised to include Aeries attendance protocols. 4. OUSD Designed dashboards with real-time student and attendance data for all after-school providers The CDE has accepted the District's CAP as of 8/29/2022, and we expect improved outcomes during the fiscal year 2023. Anticipated Completion Date: June 30, 2023

View Audit 26207

Finding 36221 (2022-001)

Significant Deficiency 2022

Second Harvest Heartland

MN

Allowable Costs / Cost Principles Internal Control / Segregation of Duties § 200.303

CFDA: 21.027 Grant No.: 207957 Grant Period: Year ended September 30, 2022 Type of finding ? Significant deficiency in internal control over compliance Response: Agree Explanation/Corrective Action: The Purchasing Specialist tracks spending on a shared spreadsheet, which includes vendor, pu...

CFDA: 21.027 Grant No.: 207957 Grant Period: Year ended September 30, 2022 Type of finding ? Significant deficiency in internal control over compliance Response: Agree Explanation/Corrective Action: The Purchasing Specialist tracks spending on a shared spreadsheet, which includes vendor, purchase order #, product type, product description, pounds ordered, quoted amount due, and expected receipt date. Once the product is received, the Purchasing Specialist notes the actual receipt date and amount due. At the conclusion of every month during the grant period, a separate member of the Sourcing Team will review all purchase orders and related items in the system for accuracy and to ensure the items purchased are in accordance with the requirements of the funding, including any applicable qualifiers. The team member will also verify the amount due matches the associated NetSuite bill/invoice. The team member will indicate the date of the review and the name of the member completing the review on the spreadsheet. Once the review is completed, the team member will take a screenshot of the applicable expenses for the current month and email it to the Controller. This is to state the information is ready for submission to the government for reimbursement. Anticipated Completion Date: The Director of Sourcing and Demand Planning reviewed all prior purchase orders for accuracy as well as began the monthly review process with the month of November.

View Audit 26205

Finding 36219 (2022-001)

Material Weakness 2022

City of Meridian, Idaho

ID

Subrecipient Monitoring Material Weakness Reporting § 200.303

Finding# 2022-001 Federal Agency Name: U.S. Department of Housing & Urban Development Program Name: Community Development Black Grant/COVID-19 Community Development Block Grant ALN# 14.218 Finding Summary: 2 CFR 200.303(a) establishes that the auditee must establish and maintain effective internal ...

Finding# 2022-001 Federal Agency Name: U.S. Department of Housing & Urban Development Program Name: Community Development Black Grant/COVID-19 Community Development Block Grant ALN# 14.218 Finding Summary: 2 CFR 200.303(a) establishes that the auditee must establish and maintain effective internal control over the federal award that provides assurance that the entity is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. 2 CFR Part 170 establishes requirements for recipients' reporting of information on subawards as required by the Federal Funding Accountability and Transparency Act of 2006 (FFATA). During the testing of the CDBG program, it was noted the City does not have a process in place to identify that FFATA reporting was required and did not report information on the subawards as required by FFATA. Responsible Individuals: Crystal Campbell, Community Development Program Coordinator. Corrective Action Plan: The City of Meridian has implemented the following changes to its internal control procedures to address finding # 2022-001 as listed above. Effective January 1, 2023, we have updated our Grant Management Software (Neighborly) to provide a monthly report that displays all New Subrecipient Agreements executed with a value of $30,000 that fall under the Federal Funding Accountability and Transparency Act (FFATA). This monthly report will establish an effective control over the necessary reporting of subrecipient agreements executed over the value of $30,000. The monthly Neighborly report will be reviewed and approved by the Community Development Program Coordinator along with their supervisor on a monthly basis to make the City compliant for FFATA reporting requirements. The Community Development Program Coordinator will have also added to the internal quarterly review process to discuss any FFATA items being considered and reviewed. Anticipated Completion Date: Ongoing.

View Audit 25888

Finding 36211 (2022-003)

Significant Deficiency 2022

Ainsworth Community Schools

NE

Subrecipient Monitoring Reporting Internal Control / Segregation of Duties

Name of Contact Person: Dale Hafer, Superintendent Views of Responsible Officials and Planned Corrective Actions: The District relies on the auditor to propose adjustments necessary to prepare the schedule of expenditures o...

Name of Contact Person: Dale Hafer, Superintendent Views of Responsible Officials and Planned Corrective Actions: The District relies on the auditor to propose adjustments necessary to prepare the schedule of expenditures of federal awards including the related note disclosures. The District reviews schedule of expenditures of federal awards and approves all adjustments.

View Audit 36577

Finding 36194 (2022-008)

Significant Deficiency 2022

Great Expectations Housing Corporation

CA

Special Tests & Provisions Reporting Significant Deficiency

Reporting views of responsible officials and planned corrective actions Management has arranged for transfers to be done on the 25th of every month manner and has put in place controls to ensure such transfers are done every month as required.

View Audit 34377

Finding 36193 (2022-007)

Significant Deficiency 2022

Great Expectations Housing Corporation

CA

HUD Housing Programs Reporting Significant Deficiency

Reporting views of responsible officials and planned corrective actions Management put in place an electronic work order system that keeps track of the work orders for the property and has put controls in place to actively monitor the system to ensure appropriate repairs are being completed in a tim...

Reporting views of responsible officials and planned corrective actions Management put in place an electronic work order system that keeps track of the work orders for the property and has put controls in place to actively monitor the system to ensure appropriate repairs are being completed in a timely manner.

View Audit 34377

Finding 36192 (2022-006)

Significant Deficiency 2022

Great Expectations Housing Corporation

CA

HUD Housing Programs Eligibility Reporting

Reporting views of responsible officials and planned corrective actions Management will put in place procedures to ensure verification of tenant assets is done during recertification.

View Audit 34377

Finding 36191 (2022-005)

Material Weakness 2022

Great Expectations Housing Corporation

CA

Allowable Costs / Cost Principles HUD Housing Programs Material Weakness

Reporting views of responsible officials and planned corrective actions Management will ensure that moving forward there are controls in place to ensure expenses are captured in the correct fiscal period and that at year end there is a final review of the transactions to ensure that everything is no...

Reporting views of responsible officials and planned corrective actions Management will ensure that moving forward there are controls in place to ensure expenses are captured in the correct fiscal period and that at year end there is a final review of the transactions to ensure that everything is not only properly entered, but properly classified as well.

View Audit 34377

Finding 36189 (2022-003)

Material Weakness 2022

Great Expectations Housing Corporation

CA

Allowable Costs / Cost Principles HUD Housing Programs Material Weakness

Reporting views of responsible officials and planned corrective actions Management has put in place controls and procedures to ensure that funds are not over-disbursed in the future. Management has returned the funds to the HUD entity.

View Audit 34377

Finding 36188 (2022-002)

Material Weakness 2022

Great Expectations Housing Corporation

CA

Reporting Internal Control / Segregation of Duties Material Weakness

Reporting views of responsible officials and planned corrective actions Management will put in place controls and procedures to ensure financial reporting is complete, accurate, and timely.

View Audit 34377

Finding 36187 (2022-001)

Material Weakness 2022

Great Expectations Housing Corporation

CA

HUD Housing Programs Special Tests & Provisions Cash Management

Reporting views of responsible officials and planned corrective actions Management has opened a new residual account for this HUD entity and has put in place controls to ensure that the calculated surplus cash balance is deposited into the account, if applicable, annually.

View Audit 34377

Finding 36169 (2022-002)

Significant Deficiency 2022

Upper Columbia United Tribes

WA

Subrecipient Monitoring Matching / Level of Effort / Earmarking Internal Control / Segregation of Duties § 200.303

The Executive Director will implement measures to ensure that reports are submitted in a timely manner.

View Audit 26976

Finding 36158 (2022-002)

Material Weakness 2022

Dekalb County Central United School District

IN

Internal Control / Segregation of Duties Subrecipient Monitoring Material Weakness § 200.303

FINDING 2022-002 Contact Person Responsible for Corrective Action: Steve Snider, CFO & Gina Buhr, Director of Business Operations Contact Phone Number: 260-920-1011 Views of Responsible Official: We adamantly disagree with the finding. The ?annual? reports in question were nothing more than a mid-po...

FINDING 2022-002 Contact Person Responsible for Corrective Action: Steve Snider, CFO & Gina Buhr, Director of Business Operations Contact Phone Number: 260-920-1011 Views of Responsible Official: We adamantly disagree with the finding. The ?annual? reports in question were nothing more than a mid-point check on spending with the federal relief grants in the form of a jotform, which in and of itself, does not provide any good way to have an additional sign off. We already had controls in place for all of the spending occurring within these grants, so the proper controls were in place upstream from the jotform. Description of Corrective Action Plan: Jotform requests from the state are now entered with the data, printed out prior to submission, reviewed by a second party (if the CFO completes, the Director of Business Operations reviews and vice versa), then once the review is complete, the data is reentered and submitted. Anticipated Completion Date: We are starting this process in February with the Teacher Benefit jotform.

View Audit 25696

Finding 36140 (2022-009)

Material Weakness 2022

County of Los Angeles

CA

Subrecipient Monitoring Internal Control / Segregation of Duties Matching / Level of Effort / Earmarking § 200.303

DPH agrees with the finding and recommendation. DPH will continue monitoring subawards upon execution and monthly to identify when a subrecipient surpasses the threshold triggering FFATA reporting. DPH will also retain screenshots or printouts when submitting FFATA reports to document the submissio...

DPH agrees with the finding and recommendation. DPH will continue monitoring subawards upon execution and monthly to identify when a subrecipient surpasses the threshold triggering FFATA reporting. DPH will also retain screenshots or printouts when submitting FFATA reports to document the submission date.

View Audit 35126

Finding 36139 (2022-003)

Material Weakness 2022

County of Los Angeles

CA

Subrecipient Monitoring Internal Control / Segregation of Duties Reporting § 200.303

DPH agrees with the finding and recommendation. DPH will continue to monitor subawards upon execution and monthly to identify when a subrecipient surpasses the threshold triggering FFATA reporting. DPH will also retain screenshots or printouts when submitting FFATA reports to document the submissi...

DPH agrees with the finding and recommendation. DPH will continue to monitor subawards upon execution and monthly to identify when a subrecipient surpasses the threshold triggering FFATA reporting. DPH will also retain screenshots or printouts when submitting FFATA reports to document the submission date.

View Audit 35126

Finding 36114 (2022-002)

None 2022

Waubonsee Community College District 516

IL

Reporting Internal Control / Segregation of Duties

2022-002 HEERF Reporting - Higher Education Relief Funds Assistance Listing Number 84.425E, 84.425F, 84.425C, Grant Period - Year Ended June 30, 2022 Condition Found The College fa...

2022-002 HEERF Reporting - Higher Education Relief Funds Assistance Listing Number 84.425E, 84.425F, 84.425C, Grant Period - Year Ended June 30, 2022 Condition Found The College failed to post public records for the March 31, 2022 student quarterly reporting period in a timely manner. We consider this to be an instance of non-compliance relating to the Reporting Compliance Requirement. Corrective Action Plan As of June 16, 2022, student grant disclosure for the March 31 quarterly reporting period for the second allocation of HEERF student grants has been posted as public records on www.waubonsee.edu website. Responsible Person for Corrective Action Plan Dr. Stacey Randall, Executive Dean for Institutional Effectiveness and Title V Project Director, is the person responsible for this Corrective Action Plan. Implementation Date of Corrective Action Plan As of June 16, 2022, all phases of the Corrective Action Plan were implemented.

View Audit 31075

Finding 36113 (2022-001)

None 2022

Waubonsee Community College District 516

IL

Questioned Costs Student Financial Aid Internal Control / Segregation of Duties

2022-001 Federal Work Study - Student Financial Aid Cluster Assistance Listing Number 84.007, 84.033, 84.063, 84.268, Grant Period - Year Ended June 30, 2022 Condition Found During...

2022-001 Federal Work Study - Student Financial Aid Cluster Assistance Listing Number 84.007, 84.033, 84.063, 84.268, Grant Period - Year Ended June 30, 2022 Condition Found During our Federal Work Study testing, we selected eleven students and noted that one student was paid for hours they did not work. The College did not review federal work-study hours worked against class hours scheduled and timesheets to ensure the student was not working during a scheduled class and that they were paid for the correct number of hours. We consider this condition to be an instance of non-compliance to the Activities Allowed or Unallowed compliance requirement. Corrective Action Plan In addition to direct counseling with the supervisor and student workers partied to this practice, the Financial Aid and Human Resources offices implemented several steps to stress the supervisor?s responsibility for timesheet validation. The changes went into effect on August 5, 2022. The steps included: 1. Reviewed the Student Worker Employee Handbook and Student Worker Supervisor Handbooks to confirm that language exists addressing that students should not work during scheduled class time, and supervisors are responsible for reviewing timesheets before approval submission. 2. All Supervisors are now required to review and sign off on the Supervisor Student Worker Handbook annually. Human Resources will audit for compliance quarterly. 3. At the start of each new academic year, Financial Aid and Human Resources will host a ?Hiring a Student Worker Information? session for all supervisors. This year the session took place on September 1, 2022. This session stress timesheet reviews, among many other responsibilities. Responsible Person for Corrective Action Plan Mary Greenwood, Director of Student Financial Aid Services, will be the person responsible for this Corrective Action Plan. Implementation Date of Corrective Action Plan As of August 5, 2022, all phases of the Corrective Action Plan were implemented.

View Audit 31075 Questioned Costs: $1

Finding 36112 (2022-006)

Material Weakness 2022

Oak Park Elementary School District 97

IL

Allowable Costs / Cost Principles Cash Management Internal Control / Segregation of Duties

Oak Park Elementary School District 97 06-016-0970-02 CORRECTIVE ACTION PLAN FOR CURRENT YEAR AUDIT FINDINGS Year Ending June 30, 2022 Corrective Action Plan Finding No.: 2022 - 006 Condition: The District claimed $421,462 of expenditures related to HVAC improvements on their March 31, 2022 r...

Oak Park Elementary School District 97 06-016-0970-02 CORRECTIVE ACTION PLAN FOR CURRENT YEAR AUDIT FINDINGS Year Ending June 30, 2022 Corrective Action Plan Finding No.: 2022 - 006 Condition: The District claimed $421,462 of expenditures related to HVAC improvements on their March 31, 2022 reimbursement claim submitted to the Illinois State Board of Education, however these expenditures were not paid by the District until October 2022. Plan: The District will implement additional procedures for review and approval of reimbursement claims prior to submission to ensure that expenditures are claimed within a reasonable period of time in relation to when a reimbursement claim is submitted. Anticipated Date of Completion: 6/30/2023 Name of Contact Person: Patrick King, Senior Director of Finance

View Audit 30957

Corrective Action Plans

Filters