Corrective Action Plans

Finding 7838 (2023-002)

Significant Deficiency 2023

Rio Rancho Public School District No. 94

NM

Questioned Costs Allowable Costs / Cost Principles Matching / Level of Effort / Earmarking § 200.300 § 200.303 § 200.306 § 200.308 § 200.403

Executive Director of Finance: Management agrees with this finding. The school district converted to a new financial ERP system as of July 1, 2023. The new ERP system flags any duplicate invoice numbers that maybe entered. The Accounts Payable (A/P) staff will verify if payment has already been made...

Executive Director of Finance: Management agrees with this finding. The school district converted to a new financial ERP system as of July 1, 2023. The new ERP system flags any duplicate invoice numbers that maybe entered. The Accounts Payable (A/P) staff will verify if payment has already been made. On occasion, payment requests do not have an invoice number. To prevent duplicate payments, the Accounts Payable staff require original invoices and uses a system generated invoice number, or a will use a manual entry numbering convention to prevent duplicate invoice numbers. The invoice data is entered by an Accounts Payable specialist and reviewed by the Accounts Payable Manager. On occasion, A/P must request corrected invoices from vendors who try and reuse invoice numbers. The A/P Manager reviews invoice numbers during the check run for accuracy. Purchasing and A/P will also periodically review the vendor database for duplicate vendors. For construction projects that list a pay application number instead of an invoice number, A/P will implement a consistent invoice numbering convention to avoid duplicate payments. The A/P specialists will also review the PO payment history prior to processing. Responsible party(ies) for corrective action(s): Accounts Payable Manager Corrective action(s) timeline: December 1, 2023

View Audit 10190 Questioned Costs: $1

Finding 7582 (2023-002)

Material Weakness 2023

Franciscan Missionaries of Our Lady Health System, Inc.

LA

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

Corrective Action Plan The reconciliation review process will be enhanced for funding that applies to multiple funding periods. Anticipated Completion Date To be corrected with the Period 6 PRF portal submission Name of Contact Person for Corrective Action Rebecca Villar, Director of Accounting

View Audit 9933

Finding 7581 (2023-001)

Material Weakness 2023

Franciscan Missionaries of Our Lady Health System, Inc.

LA

Questioned Costs Allowable Costs / Cost Principles Matching / Level of Effort / Earmarking § 200.303

Corrective Action Plan Transition the St. Dominic payroll to be processed centrally at the System in accordance with all System's processes and procedures. Anticipated Completion Date January 1, 2022 Name of Contact Person for Corrective Action Amanda Hymel, Corporate Controller

View Audit 9933 Questioned Costs: $1

Finding 7577 (2023-004)

Material Weakness 2023

Bethany Lutheran Home for the Aged, Inc.

SD

Special Tests & Provisions Significant Deficiency Matching / Level of Effort / Earmarking § 200.303

Finding 2023-004 Federal Agency Name: Department of Agriculture Program Name: Communities Facilities Loans and Grants Cluster Federal Financial Assistance Listing #10.766 Finding Summary: Management created the reserve account of $114,600 in December 2022 which was established as a separate bookk...

Finding 2023-004 Federal Agency Name: Department of Agriculture Program Name: Communities Facilities Loans and Grants Cluster Federal Financial Assistance Listing #10.766 Finding Summary: Management created the reserve account of $114,600 in December 2022 which was established as a separate bookkeeping and bank account. However, management transposed the $116,400 amount that was required to be in the reserve account according to the Letter of Conditions. The Organization underfunded the actual reserve balance after interest earnings by $521 as of June 30, 2023. Additionally, the Organization withdrew $100,000 in May 2023 from the reserve account to deposit into the operating account and subsequently replenished the reserve account within 14 days without obtaining proper federal agency approval. Responsible Individuals: Dalton Huber, Chief Financial Officer Corrective Action Plan: A new line of credit has been established at First Interstate Bank to prevent this from reoccurring. The correct amount is presently in the reserve account. Anticipated Completion Date: 10/1/2023

View Audit 9917

Finding 7575 (2023-003)

Material Weakness 2023

Bethany Lutheran Home for the Aged, Inc.

SD

Reporting Material Weakness Matching / Level of Effort / Earmarking

Finding 2023-003 Federal Agency Name: Department of Agriculture Program Name: Communities Facilities Loans and Grants Cluster Federal Financial Assistance Listing #10.766 Finding Summary: The Organization does not have an internal control system designed to provide for the preparation of the cons...

Finding 2023-003 Federal Agency Name: Department of Agriculture Program Name: Communities Facilities Loans and Grants Cluster Federal Financial Assistance Listing #10.766 Finding Summary: The Organization does not have an internal control system designed to provide for the preparation of the consolidated schedule of expenditures of federal awards (the schedule) and accompanying notes to the schedule. Responsible Individuals: Dalton Huber, Chief Financial Officer Corrective Action Plan: Lack of resources make this necessary. Anticipated Completion Date: Ongoing

View Audit 9917

Finding 7569 (2023-003)

Material Weakness 2023

Stillwater Area Public Schools Independent School District #834

MN

Procurement, Suspension & Debarment Matching / Level of Effort / Earmarking Material Weakness § 200.303

U.S Department of Education 2023-003 Special Education Cluster – Assistance Listing No. 84.027 and 84.173 Recommendation: CLA recommends the District follow its procurement policies as well as requirements within the Uniform Guidance to perform the proper verification procedures on all covered trans...

U.S Department of Education 2023-003 Special Education Cluster – Assistance Listing No. 84.027 and 84.173 Recommendation: CLA recommends the District follow its procurement policies as well as requirements within the Uniform Guidance to perform the proper verification procedures on all covered transactions entered into with federal funds. Explanation of disagreement with audit finding: There is no disagreement with the audit finding. Action taken in response to finding: The District will work to revise its procedures as necessary to ensure that all procurements which are charged to federal programs are fully documented. Name(s) of the contact person(s) responsible for corrective action: Marie Schrul, Executive Director of Finance Planned completion date for corrective action plan: January 31, 2024

View Audit 9887

Finding 7543 (2023-001)

None 2023

Rochester Institute of Technology

NY

Student Financial Aid Reporting Eligibility

Management Response and Corrective Action Plan OMB Uniform Guidance Audit for the fiscal year ended June 30, 2023 Finding 2023-001 - Non-Compliance with Timely Student Enrollment Change Submissions to the National Student Loan Data System (NSLDS) Management agrees with the finding and in concurren...

Management Response and Corrective Action Plan OMB Uniform Guidance Audit for the fiscal year ended June 30, 2023 Finding 2023-001 - Non-Compliance with Timely Student Enrollment Change Submissions to the National Student Loan Data System (NSLDS) Management agrees with the finding and in concurrence with the recommendations has developed and is implementing the following corrective action plans: 1. RIT will implement a process for students who are not expected to return in the fall semester and were enrolled in spring to update the enrollment status with the NSC, the third party that reports to the NSLDS for the University. The manual update to the NSC will be completed within 30 days from the date that RIT is notified that the student is confirmed to no longer be expected to return in the upcoming fall semester. This process will be implemented for the start of summer term 2024. 2. As of November 1, 2023, RIT has enhanced its degree certification process for late certifications to include the two steps which are now required by the NSC. RIT has also added to this process an additional verification to validate that the degree record is subsequently and correctly updated with the NSLDS. 3. The University has communicated with the helpdesk at the NSLDS to determine the reasons why the two identified records for which the student status changes were timely reported to the NSC; however, the data was not correctly captured by the NSLDS. The NSLDS has not been able to identify the root cause of the issue and are continuing to research the problem. They indicate that there is nothing that RIT can do to update these records at this time. Management concurs with the recommendation and will implement a periodic reconciliation processes between the NSLDS and the NSC to verify that the NSLDS timely and completely received communication of student changes. This will include a confirmation process for manual transactions with the NSC to ensure they were received by the NSLDS, which will begin January 2024. Responsible Individual: Joseph Loffredo, Associate Vice President for Academic Affairs & Registrar

View Audit 9841

Finding 7530 (2023-002)

Significant Deficiency 2023

Second Harvest Heartland

MN

Eligibility Matching / Level of Effort / Earmarking Significant Deficiency § 200.303

Audit Finding: ALN: 10.656 Grant No.: 204642 Grant Period: Year ended September 30, 2023 Type of finding – Significant deficiency in internal control over compliance Response: Agree Explanation/Corrective Action: • Scanning Applications: o Applications are physically filed by volunteers, th...

Audit Finding: ALN: 10.656 Grant No.: 204642 Grant Period: Year ended September 30, 2023 Type of finding – Significant deficiency in internal control over compliance Response: Agree Explanation/Corrective Action: • Scanning Applications: o Applications are physically filed by volunteers, then scanned into SharePoint and filed electronically. o SharePoint does not recognize hand-written applications, so we use a filing spreadsheet to track specific batch numbers for applications, which gives us the ability to trace an individual document. If the document is typed, then it can be recognized through a search in SharePoint.  Our SOP document for scanning applications can be found on the CSFP Sharepoint site. o We have two volunteers who are scanning on a weekly basis (between 150-250 applications scanned weekly), and we will continue to prioritize this project as more staff/volunteer hours become available. • If an application is missing: o Confirm that application information is in ClientTrack and document through a generated printed application. o Send application to distribution site for next distribution, to ensure participant signs new application before they receive another CSFP box. Anticipated Completion Date: We currently have two volunteers who are scanning on a weekly basis (between 150-250 applications scanned weekly), and we will continue to prioritize this project as more staff/volunteer hours become available. The current backlog is around one year with plans to get caught up using additional resources in the next few months.

View Audit 9830

Finding 7516 (2023-003)

Material Weakness 2023

Platte Health Center

SD

Subrecipient Monitoring Material Weakness Matching / Level of Effort / Earmarking § 200.303

Single Audit Finding 2023-003 Federal Agency Name: Department of Agriculture Program Name: Communities Facilities Loans and Grants Cluster Federal Financial Assistance Listing #10.766 Finding Summary: The Health Center does not have controls in place to ensure compliance with the requirements as th...

Single Audit Finding 2023-003 Federal Agency Name: Department of Agriculture Program Name: Communities Facilities Loans and Grants Cluster Federal Financial Assistance Listing #10.766 Finding Summary: The Health Center does not have controls in place to ensure compliance with the requirements as they have not been calculating or monitoring the required debt ratios. The Health Center was relying on annual calculations performed by the Eide Bailly audit team. Responsible Individuals: Vicki Jensen, Chief Financial Officer Corrective Action Plan: Platte Health Center will perform debt service ratio and working capital calculations and implement a review process over the calculations as part of their year-end close process to ensure all covenants of the loan are met. Anticipated Completion Date: June 30, 2024

View Audit 9749

Finding 7471 (2023-006)

Significant Deficiency 2023

Harris-Stowe State University

MO

Student Financial Aid Matching / Level of Effort / Earmarking Subrecipient Monitoring

Finding 2023-006 Personnel Responsible for Corrective Action: Registrar – Yolanda Kenton Anticipated Completion Date: December 2023 Corrective Action Plan: The University filled the Registrar position which had been vacant for 6 months. In addition, the Registrar’s Office implemented a control...

Finding 2023-006 Personnel Responsible for Corrective Action: Registrar – Yolanda Kenton Anticipated Completion Date: December 2023 Corrective Action Plan: The University filled the Registrar position which had been vacant for 6 months. In addition, the Registrar’s Office implemented a control that includes running a monthly enrollment status report allowing for changes to be reported within the 60 day window. The current Registrar has also done Registrar training with the American Association of Collegiate Registrars and Admissions Officers (AACRAO).

View Audit 9669

Finding 7437 (2023-001)

None 2023

Los Angeles Chapter National Tooling & MacHining Association Training Centers Trust

CA

Reporting Student Financial Aid Matching / Level of Effort / Earmarking

The Institution understands the importance of this process and the finding associated with this oversight is valid. The Institution will improve internal practices for promptly reviewing and responding to the NSLDS enrollment roster within the stipulated 15-day timeframe. The institution will establ...

The Institution understands the importance of this process and the finding associated with this oversight is valid. The Institution will improve internal practices for promptly reviewing and responding to the NSLDS enrollment roster within the stipulated 15-day timeframe. The institution will establish clear protocols for addressing errors on the NSLDS enrollment roster within the mandated 10-day period to ensure accurate and timely modifications. Personnel Responsible for Implementation: Danielle Skinner Position of Responsible Personnel: President Expected Date of Implementation: Immediate

View Audit 9586

Finding 7410 (2023-003)

Significant Deficiency 2023

Thomas More University

KY

Student Financial Aid Subrecipient Monitoring Significant Deficiency

Prior to the student information system transition, regular monitoring of the return of funds took place for Direct Loans, specifically for the returns associated with R2T4 calculations. During the transition, this process was not immediately replaced. It was noted during the audit cycle that issues...

Prior to the student information system transition, regular monitoring of the return of funds took place for Direct Loans, specifically for the returns associated with R2T4 calculations. During the transition, this process was not immediately replaced. It was noted during the audit cycle that issues existed within the new system related to returning funds and tickets were submitted to Jenzabar about the issues, specifically raising concerns about the timing of returns. Not all returns were being picked up by the process that collects the returns and sends them in batches to COD. Adjustments have been made to the system and testing has shown that all of the returns are being picked up now. The Financial Aid Office is also regularly monitoring returns again, similar to the process prior to the transition, and we are now monitoring both Direct Loan and Pell grant returns. This process is managed by an Excel spreadsheet of all Direct Loan and Pell grant returns that have been made in JFA. Any time a return of a Direct Loan or Pell grant is made in JFA, the return is added to the spreadsheet. A Financial Aid Counselor has a regular reminder on their calendar once per week to monitor each return to ensure that the full return process has taken place through COD and that the funds have been returned timely. Anticipated Completion Date: October 1, 2023

View Audit 9556

Finding 7408 (2023-002)

Significant Deficiency 2023

Thomas More University

KY

Student Financial Aid Reporting Significant Deficiency

The Office of the Registrar submits the enrollment reports to the National Student Clearinghouse. Over the course of this past year, the office struggled with a new student information system and staff changes. To prevent reports being submitted late, everyone in the current staff has been trained o...

The Office of the Registrar submits the enrollment reports to the National Student Clearinghouse. Over the course of this past year, the office struggled with a new student information system and staff changes. To prevent reports being submitted late, everyone in the current staff has been trained on how to submit reports. The office has worked with representatives of the National Student Clearinghouse to assist with error reports. In addition, the due dates for submitting the reports have been updated to a more consistent timeframe each month. Each staff member in the Office of the Registrar has the list of dates when the reports are due. Furthermore, the staff hopes to schedule more training from the provider of the student information system to help process reports more accurately. Anticipated Completion Date: November 1, 2023

View Audit 9556

Finding 7407 (2023-001)

Significant Deficiency 2023

Thomas More University

KY

Student Financial Aid Matching / Level of Effort / Earmarking Significant Deficiency

During the transition from Jenzabar CX to Jenzabar JFA software, the process to notify students of their loan and TEACH grant disbursements and rights to cancel needed to be rebuilt. The process in CX was fully automated, while the process in JFA was not fully automated for the 2022-23 audit cycle. ...

During the transition from Jenzabar CX to Jenzabar JFA software, the process to notify students of their loan and TEACH grant disbursements and rights to cancel needed to be rebuilt. The process in CX was fully automated, while the process in JFA was not fully automated for the 2022-23 audit cycle. As a result, there were some students in October of 2022 that did not receive their required notification. For the 2023-24 cycle, the Director of Financial Aid has worked with Jenzabar to establish a more automated process for these notifications. Two separate queries have been established to identify loan disbursements and TEACH recipients. Each query looks for disbursements that occurred that day and collects them in a batch. An automated “scheduler” then runs each group through a notification process where each student will receive an email to their Thomas More email account notifying them that they received the disbursement that day. The scheduler runs this process and sends notifications out at 8pm each evening. Any loan disbursements occur during normal business hours, and even if delayed, would not disburse past 6pm, so each disbursement that occurred that day will be caught by the scheduler by 8pm. Anticipated Completion Date: October 15, 2023

View Audit 9556

Finding 7392 (2023-002)

Material Weakness 2023

Douglas County, Nv

NV

Subrecipient Monitoring Matching / Level of Effort / Earmarking Material Weakness § 200.303 § 200.329

Finding 2023-002 Program: COVID-19 Coronavirus State and Local Fiscal Recovery Funds Federal Financial Assistance Listing: 21.027 Federal Agency: U.S. Department of the Treasury Passed-through: N/A Award Year: 2022-2023 Compliance Requirement: Reporting Grant Award Number: Applies to all awards wi...

Finding 2023-002 Program: COVID-19 Coronavirus State and Local Fiscal Recovery Funds Federal Financial Assistance Listing: 21.027 Federal Agency: U.S. Department of the Treasury Passed-through: N/A Award Year: 2022-2023 Compliance Requirement: Reporting Grant Award Number: Applies to all awards with findings and no specific grant award. Type of Finding: Material Instance of Noncompliance, Material Weakness in Internal Controls over Compliance Management’s Response: We concur. Views of Responsible Officials and Corrective Action: Management agrees with the finding and understands the importance of properly reporting federal and will institute a multi-step review system before such reporting is finalized and submitted. Name of Responsible Person: Terri Willoughby, CFO Name of Department Contact: Finance Projected Implementation Date: January 1, 2024

View Audit 9528

Finding 7272 (2023-001)

Significant Deficiency 2023

Lighthouse Central Florida, Inc.

FL

Subrecipient Monitoring Reporting Significant Deficiency

U.S. Department of Housing and Urban Development Lighthouse Central Florida, Inc. and Lighthouse Works!, Inc. (collectively, the Organization) respectfully submits the following corrective action plan for the year ended September 30, 2023. Audit period: October 1, 2022 – September 30, 2023 The fi...

U.S. Department of Housing and Urban Development Lighthouse Central Florida, Inc. and Lighthouse Works!, Inc. (collectively, the Organization) respectfully submits the following corrective action plan for the year ended September 30, 2023. Audit period: October 1, 2022 – September 30, 2023 The findings from the schedule of findings and questioned costs are discussed below. The findings are numbered consistently with the numbers assigned in the schedule. FINDINGS—FEDERAL AWARD PROGRAMS AUDIT U.S. Department of Housing and Urban Development Community Development Block Grants – Assistance Listing No. 14.218 Recommendation: The Organization should implement an internal review process before the information is submitted to the pass-through agencies. Explanation of disagreement with audit finding: There is no disagreement with the audit finding. Action taken in response to finding: Lighthouse Central Florida, Inc. is performing a review of its internal process and designating internal review procedures to ensure future compliance. Name of the contact person responsible for corrective action: Christina Carrier, Vice President of Finance Planned completion date for corrective action plan: March 31, 2024

View Audit 9443

Finding 7251 (2023-004)

None 2023

University of Hawaii

HI

Questioned Costs Student Financial Aid Matching / Level of Effort / Earmarking

Finding No. 2023-004: Financial Aid Administration – Control Deficiency Federal Agency: U.S. Department of Education AL Number and Title: 84.063P – Federal Pell Grant Program 84.268 – Federal Direct Student Loans Questioned Costs: $25 Responsible Individual: Calvin Black, Financial Aid Manager, Hawa...

Finding No. 2023-004: Financial Aid Administration – Control Deficiency Federal Agency: U.S. Department of Education AL Number and Title: 84.063P – Federal Pell Grant Program 84.268 – Federal Direct Student Loans Questioned Costs: $25 Responsible Individual: Calvin Black, Financial Aid Manager, Hawaiʿi Community College Date Action Taken: On-going Return of Title IV Funds R2T4 was calculated incorrectly due to inadequate staffing and lack of personnel training. R2T4 has been recalculated for the identified student, and Hawaiʿi CC is working to hire vacant positions and resolve ongoing staffing issues. The UH Community College Central Financial Aid Office is also working to develop/finalize written R2T4 procedures. Enrollment Reporting Exit materials were sent late due to inadequate staffing and ongoing staff absences. Hawaiʿi CC is working to hire vacant positions and resolve ongoing staffing issues.

View Audit 9418 Questioned Costs: $1

Finding 7249 (2023-002)

None 2023

University of Hawaii

HI

Student Financial Aid Matching / Level of Effort / Earmarking Internal Control / Segregation of Duties

Finding No. 2023-002: Return of Title IV Funds – Control Deficiency Federal Agency: U.S. Department of Education AL Number and Title: 84.063P – Federal Pell Grant Program 84.268 – Federal Direct Student Loans Questioned Costs: $ – Responsible Individual: Sherrie Padilla, Director of Financial Aid, U...

Finding No. 2023-002: Return of Title IV Funds – Control Deficiency Federal Agency: U.S. Department of Education AL Number and Title: 84.063P – Federal Pell Grant Program 84.268 – Federal Direct Student Loans Questioned Costs: $ – Responsible Individual: Sherrie Padilla, Director of Financial Aid, University of Hawaiʿi at Hilo Date Action Taken: Immediately A miscalculation counting the 45-day requirement occurred with the 4 students in question resulting in the funds being returned on the 46th day. Procedures have been adjusted to return funds on the 30th day giving ample time to meet the 45-day requirement.

View Audit 9418

Finding 7248 (2023-001)

None 2023

University of Hawaii

HI

Student Financial Aid Reporting Matching / Level of Effort / Earmarking

Finding No. 2023-001: Financial Aid Administration – Control Deficiency Federal Agency: U.S. Department of Education AL Number and Title: 84.063P – Federal Pell Grant Program Questioned Costs: $ – Responsible Individual: Pheng Xiong, Office of the Registrar, University Registrar Nikki Chun, Div. of ...

Finding No. 2023-001: Financial Aid Administration – Control Deficiency Federal Agency: U.S. Department of Education AL Number and Title: 84.063P – Federal Pell Grant Program Questioned Costs: $ – Responsible Individual: Pheng Xiong, Office of the Registrar, University Registrar Nikki Chun, Div. of Enrollment Management, Vice Provost for Enrollment Management Date Action Taken: August 2023 The Office of the Registrar is fully aware of and takes very seriously its enrollment and degree reporting requirements and responsibilities. The finding presented in Finding No. 2023-005 happened as a result of a processing error where students in the final Spring 2023 enrollment file were not cleared out. This prevented students in the Spring 2023 degree files, submitted on June 26th and July 3rd, from having their graduation statuses updated with the National Student Clearinghouse if they were in the affected initial Summer 2023 enrollment file. The August 2nd file could not be processed because the National Student Clearinghouse was working with the office to reject the Summer enrollment and Spring 2023 degree reports. The reports had to be rejected in order for the corrected Summer 2023 file to be applied. The existing business process requires use of an SQL script. Since the script requires complicated manual steps and can lead to errors, the Office of the Registrar has been working to implement the NSC reporting functionality in the student information system. The new business process will improve enrollment and degree reporting, including the reduction of errors resulting from human error. The Office of the Registrar aims to go live with new business process with Spring 2024 enrollment reporting.

View Audit 9418

Finding 7239 (2023-004)

Material Weakness 2023

Independent School District No. 206 Alexandria Public Schools

MN

Internal Control / Segregation of Duties Special Tests & Provisions Material Weakness

Special Tests and Provisions – Prevailing Wage Requirement Material Noncompliance and Material Weakness in Internal Control over Compliance Finding Summary: The District did not satisfy the requirements of 2 CFR 656.40 through 2 CFR 656.41. The district did not ensure proper inclusion of prevailing...

Special Tests and Provisions – Prevailing Wage Requirement Material Noncompliance and Material Weakness in Internal Control over Compliance Finding Summary: The District did not satisfy the requirements of 2 CFR 656.40 through 2 CFR 656.41. The district did not ensure proper inclusion of prevailing wage rate clauses were included in a construction contract and also did not obtain proper support to ensure required certified payrolls were submitted. Responsible Individuals: Rick Sansted, Superintendent Corrective Action Plan: The District will establish controls to follow all applicable requirements under Uniform Guidance and applicable CFR sections. Anticipated Completion Date: June 30, 2024

View Audit 9408

Finding 7209 (2023-001)

None 2023

Yale University

CT

Student Financial Aid Matching / Level of Effort / Earmarking Special Tests & Provisions

Views of Responsible Officials and Corrective Action Plan The University acknowledges the need for consistent policies, procedures, and the application of these requirements and has already begun to put in place corrective actions to address these issues for the 2023-24 academic year. Outlined below...

Views of Responsible Officials and Corrective Action Plan The University acknowledges the need for consistent policies, procedures, and the application of these requirements and has already begun to put in place corrective actions to address these issues for the 2023-24 academic year. Outlined below are corrective actions and proposed changes to align Yale with the stated recommendations: • Verification – Implementation of a university-wide document posting process with an expected implementation date by the end of the fiscal year 2024. This process will auto-populate federally required documents into Yale’s financial aid system, based on FAFSA/ISIR comment codes, in a way that will prevent disbursement to a student’s account unless collected. Schools will receive training from the University Financial Aid Office (“UFAO”) in concurrence with the implementation of this new automated population regarding the collection of the new university-wide form and the proper acceptance of identity requirements. • Electronic Transactions – Beginning in June of 2023, all financial aid recipients, not just Federal Financial Aid recipients, are asked to complete E-Consent on the new Student Portal Yale Hub. Students cannot view award offers, electronic documents that must be completed online, or personal historical financial aid data until the E-Consent question is answered. • Return of Title IV – Creation and implementation of a university-wide Return to Title IV funds policy and procedure is currently in process. This implementation will begin before the end of calendar year 2023 and will include training of several additional Financial Aid staff members across the university on the updated policies and procedures to create redundancies for timely and consistent processing of R2T4’s. • NSLDS Enrollment Reporting – The University Registrar is working with ITS to correct the custom Banner NSC extract job to ensure that not just the enrollment status is updated, but also the program level status. An additional staff member in the registrar’s office will be deployed to focus on compliance and enrollment reporting. • Satisfactory Academic Progress (“SAP”) – The University Financial Aid Office has begun a school-by-school review of SAP policies. Review and implementation of updated SAP policies will be concluded by June 2024 schoolwide. UFAO will set up an SAP review process for new programs as well as an annual review for each school. University contact: David Blackmon, Director, Office of Student Financial Aid David.Blackmon@yale.edu

View Audit 9367

Finding 7186 (2023-004)

Material Weakness 2023

City of Beaveron

MI

Procurement, Suspension & Debarment Cash Management Material Weakness

AL# 11.300 Investments for Public Works & Economic Development - Other Matters: Written Policies Required by the Uniform GuidanceRecommendation: We recommend that the City ensures these policies are updated to conform with the Uniform Guidance as soon as practical, but no later than the end of fisca...

AL# 11.300 Investments for Public Works & Economic Development - Other Matters: Written Policies Required by the Uniform GuidanceRecommendation: We recommend that the City ensures these policies are updated to conform with the Uniform Guidance as soon as practical, but no later than the end of fiscal year 2023. Action Taken: The City has been provided an example of appropriate policies to use as a guide in updating their written policies. City management is currently working on updating all current procedures and policies to ensure that they are compliant with Uniform Guidance for all current and future Federal Awards. Anticipated Completion Date: June 2024

View Audit 9302

Finding 7102 (2023-004)

Material Weakness 2023

Independant School District No. 152

MN

Internal Control / Segregation of Duties Special Tests & Provisions Material Weakness

Special Tests and Provisions – Prevailing Wage Requirement Material Noncompliance and Material Weakness in Internal Control over Compliance Finding Summary: In our testing of special tests and provisions for Prevailing Wage Requirements, it was identified that the District did not satisfy the requir...

Special Tests and Provisions – Prevailing Wage Requirement Material Noncompliance and Material Weakness in Internal Control over Compliance Finding Summary: In our testing of special tests and provisions for Prevailing Wage Requirements, it was identified that the District did not satisfy the requirements of 2 CFR 656.40 through 2 CFR 656.41. The district did not ensure proper inclusion of prevailing wage rate clauses were included in a construction contract and also did not obtain proper support to ensure required certified payrolls were submitted. Responsible Individuals: Brandon Lunak, Superintendent. Corrective Action Plan: The District’s construction project that used federal funding was completed during fiscal year 2023 therefore this finding will not be repeated during fiscal year 2024. The District will establish controls to follow all applicable requirements under Uniform Guidance and applicable CFR sections. Anticipated Completion Date: June 30, 2024

View Audit 9199

Finding 7099 (2023-001)

None 2023

Casa Montego Ii, Inc.

CA

HUD Housing Programs Cash Management Reporting

Department of Housing and Urban Development 600 Harrison Street, 3rd Floor San Francisco, CA 94107-1300 Casa Montego II, Inc., HUD project No. 121-EE187-NP, respectively submits the following corrective action plan for the audit year ended September 30, 2023. Auditor: SNP Partners LLP 3470 Mt. D...

Department of Housing and Urban Development 600 Harrison Street, 3rd Floor San Francisco, CA 94107-1300 Casa Montego II, Inc., HUD project No. 121-EE187-NP, respectively submits the following corrective action plan for the audit year ended September 30, 2023. Auditor: SNP Partners LLP 3470 Mt. Diablo Blvd., Suite A300 Lafayette, CA 94549 The findings from the September 30, 2023 schedule of findings and questioned costs are discussed below. The findings are numbered consistently with the numbers assigned in the schedule. Section A of the schedule, Summary of Audit Results, does not include findings and is not addressed. FINDINGS – FINANCIAL STATEMENT AUDIT No findings noted. FINDINGS – FEDERAL AWARDS PROGRAMS Department of Housing and Urban Development Finding No.: 2023-001 AL 14.157 – Supportive Housing for Elderly Recommendation: We recommend the Owner review controls over the use of project funds. We recommend that the project make approved distributions of residual receipts from the Residual Receipts Fund. Action Taken: The operating account was refunded the $43,029 on 12/7/2023 with funds from the Residual Receipts Funds. Controls have been put in place to prevent the unauthorized distribution of income or project assets. Anticipated Completion Date: December 7, 2023 If there are any questions regarding this plan, please call Jose L. Sanchez at (510) 6470-0700 Very Truly Yours, Jose L. Sanchez – Vice President of Finance

View Audit 9175

Finding 7098 (2023-002)

Material Weakness 2023

Elder Care Alliance of San Francisco - #121-22098

CA

HUD Housing Programs Material Weakness Reporting

Finding 2023-002: Cash Receipts - Material Weakness in Internal Control Over Compliance As required by Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) we have provided below ...

Finding 2023-002: Cash Receipts - Material Weakness in Internal Control Over Compliance As required by Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) we have provided below our response and corrective action plan addressing the finding noted in the Single Audit reporting package for Elder Care Alliance of San Francisco (“AVSF”) for the year ended June 30, 2023. Response and Corrective Action Plan: Going forward, management will add check totals to the vacancy loss adjustment, in order to post the appropriate entries in the general ledger. In addition, management will perform high level calculations to review against our reporting and investigate additional reports for comparison purposes. Responsible Person: Amanda Casey, Accounting Consultant, under the oversight of Bing Isenberg, Chief Financial Officer

View Audit 9162

Corrective Action Plans

Filters