Corrective Action Plans

Finding 42671 (2022-002)

None 2022

IA

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

Finding: The University incorrectly calculated Federal Direct Subsidized Loan funds for one student resulting in an under award. Corrective Actions Taken or Planned: The Associate Director of Student Financial Aid reviews each student?s need-based aid to correctly calculate the amount of Direct Sub...

Finding: The University incorrectly calculated Federal Direct Subsidized Loan funds for one student resulting in an under award. Corrective Actions Taken or Planned: The Associate Director of Student Financial Aid reviews each student?s need-based aid to correctly calculate the amount of Direct Subsidized Loan each student should receive, with the TEACH Grant being treated as non-need-based aid. In addition, the Associate Director of Student Financial Aid will reassess a student?s calculation when summer term is awarded. The internal policies and procedures have been updated to ensure the need-based calculations are properly performed and reviewed. Person Responsible: Sara Sroka (ssroka@dbq.edu) Anticipated completion date: 10/19/2022

View Audit 53483 Questioned Costs: $1

Finding 42670 (2022-001)

Significant Deficiency 2022

University of Dubuque

IA

Student Financial Aid Reporting Matching / Level of Effort / Earmarking

Finding: The University did not timely or accurately report enrollment changes to the National Student Loan Data System (NSLDS). Corrective Actions Taken or Planned: The Registrar?s Office submits a monthly report to the National Student Loan Clearinghouse. For a brief period of time the process fo...

Finding: The University did not timely or accurately report enrollment changes to the National Student Loan Data System (NSLDS). Corrective Actions Taken or Planned: The Registrar?s Office submits a monthly report to the National Student Loan Clearinghouse. For a brief period of time the process for this was inconsistent. After a review of the procedures the issue has been fixed. Also, to ensure withdrawn dates during the semester are being reported on a timely basis Financial Planning will manually enter dates of withdrawn students to National Student Loan Data Systems (NSLDS). Students who have withdrawn at the end of the semester will be manually entered and monitored closely by the Registrar?s Office who will adjust reporting schedule to ensure timely reporting of withdrawn dates. Person Responsible: Sara Sroka (ssroka@dbq.edu) Anticipated completion date: 10/19/2022

View Audit 53483

Finding 42669 (2022-004)

Significant Deficiency 2022

Tennessee Pharmacists Research and Education Foundation

TN

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

2022-004: Compliance with Cost Principles U.S. Department of Health and Human Services, pass-through State of Tennessee Department of Health - Immunization Cooperative Agreements (ALN COVID-93.268) Management?s Response: We concur. View of Responsible Officials and Corrective Action: The CEO and the...

2022-004: Compliance with Cost Principles U.S. Department of Health and Human Services, pass-through State of Tennessee Department of Health - Immunization Cooperative Agreements (ALN COVID-93.268) Management?s Response: We concur. View of Responsible Officials and Corrective Action: The CEO and the Controller have implemented a process to ensure all staff attributed to the grant are submitting a monthly report of their time attributed to grant work. These timesheets are reviewed by the CEO with a double check by the Controller. The Controller will be revising prior attributions of rent expenses based on percentage of attributed staff timesheets. Anticipated Completion Date: Effective July 1, 2023, all current and new staff have been properly trained on the new process for submitting their monthly time sheets. With new accounting software being implemented on October 1, 2023, the correction to the rent expense accounting will be correctly attributed by November 1, 2023. Name of Responsible Person: The CEO and the Controller.

View Audit 53470

Finding 42668 (2022-003)

Material Weakness 2022

Tennessee Pharmacists Research and Education Foundation

TN

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

2022-003: Compliance with Cash Management Requirements U.S. Department of Health and Human Services, pass-through State of Tennessee Department of Health - Immunization Cooperative Agreements (ALN COVID-93.268) Management?s Response: We concur. View of Responsible Officials and Corrective Action: ...

2022-003: Compliance with Cash Management Requirements U.S. Department of Health and Human Services, pass-through State of Tennessee Department of Health - Immunization Cooperative Agreements (ALN COVID-93.268) Management?s Response: We concur. View of Responsible Officials and Corrective Action: The CEO and the Controller have implemented a process to submit reimbursement for prior month?s work by conclusion of the following month. The Controller has implemented a process to aggressively follow-up with the state accounting team to ensure the state is holding true to a proper timeline of reimbursement. The Controller utilizes this follow-up messaging to the state to ensure all proper documentation has been assessed properly at each stage of the state?s review process. Anticipated Completion Date: TPREF has implemented this new process as of July 1, 2023.

View Audit 53470

Finding 42633 (2022-001)

Significant Deficiency 2022

Quinnipiac University

CT

Student Financial Aid Matching / Level of Effort / Earmarking

As part of the assignment of Perkins Loans, we noted that the assignment process required the submission of original promissory notes for each loan to be assigned. As a result, the University began collecting and digitizing its historic loan records to maintain copies for retention and compliance pu...

As part of the assignment of Perkins Loans, we noted that the assignment process required the submission of original promissory notes for each loan to be assigned. As a result, the University began collecting and digitizing its historic loan records to maintain copies for retention and compliance purposes. The assignment process is currently underway and is required to be completed by June 30, 2023. The University is on track to meet that federal imposed deadline. Quinnipiac University agrees with the finding. A small percentage of the remaining loans to be assigned originated over 10 years ago. As it relates to this finding, we were unable to locate promissory notes for six students with loans originated 10 to 30 years ago. Due to their age, we believe the finding may be related to office moves and departmental reorganizations over the years. As a result of this finding and the federal assignment process in general, Management and Financial Aid have performed a comprehensive review of the remaining student records waiting to be assigned for completeness. As a result of this review Management and Financial Aid have identified all loans that are missing original promissory notes. As part of the assignment process, in lieu of original promissory notes alternative documents supporting the existence of these loans have been provided to the Perkins loan assignment processor. Any loans that are not accepted during this appeals process will be purchased by the University at the conclusion of the assignment process, which is planned to be completed by June 30, 2023. If the Office of Management and Budget have questions regarding this plan, please reach out to Stephen Allegretto, the Associate Vice President for Finance and Controller, who is responsible for ensuring this corrective action plan is implemented, at 203-582-7962.

View Audit 47260

Finding 42629 (2022-001)

Material Weakness 2022

Ivy Tech Community College of Indiana

IN

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

FINDING 2022-001 Contact Person Responsible for Corrective Action: Colby Shank Contact Phone Number: 317-921-4765 Views of Responsible Official: Ivy Tech Community College disputes this audit finding. The College has an effective internal control system to ensure compliance with requirements relate...

FINDING 2022-001 Contact Person Responsible for Corrective Action: Colby Shank Contact Phone Number: 317-921-4765 Views of Responsible Official: Ivy Tech Community College disputes this audit finding. The College has an effective internal control system to ensure compliance with requirements related to the Special Tests and Provisions ? Return of Title IV Funds compliance requirement. The College previously determined that the Return of Title IV Funds (R2T4) is high-risk due to the large number of transactions, the College?s modular term-based system, and the manual nature of R2T4 calculations. Therefore, a robust quality control review process was implemented. College personnel regularly monitor the error rates and nature of errors discovered through the quality control review to identify, correct, and eliminate calculation errors. The claimed errors outlined in Finding 2022-001 relate to the interpretation of how a correction recalculation is determined. In correction calculations, aid previously returned as a result of the initial calculation in the 2021-2022 academic year was considered no longer disbursed and was included in the correction calculation as ?aid that could have been disbursed.? In certain scenarios, this can result in different return amounts than if the aid had been included in the calculation as ?aid disbursed.? In the absence of explicit guidance on how to handle these scenarios within the Federal Student Aid Handbook, College interpretation and precedent has been to treat aid previously returned under the original calculation as aid that could have been disbursed. Volume 5, Chapter 2 of the 2021-2022 Federal Student Aid Handbook states that ?any undisbursed Title IV aid for the period that the school uses as the basis for the R2T4 calculation is counted as aid that could have been disbursed.? Ivy Tech confirmed this interpretation as valid via a third-party financial aid expert who facilitated a discussion with a representative of the USDOE. This USDOE representative confirmed the accuracy of the calculation and the alignment with the Federal Student Aid Policy Implementation and Oversight Directorate. During this discussion, the representative stated that the results of the original calculation could not be ignored, and that including aid that is no longer disbursed as ?aid that could have been disbursed? is the proper way to perform a correction calculation. The auditors state the College should have performed the following actions: ?The College should have considered the original amount of aid to be returned that had already been posted to each student?s account. The College should have posted the additional amount of aid to be returned to the students? accounts based upon the net difference between the original calculation and the corrective calculation performed for each student.? This methodology would have produced inaccurate return amounts under the interpretation of guidance from Federal Student Aid from which the College was operating during the review period. Only posting the ?net difference? between the original calculation and the correction calculation would have resulted in too few funds being returned to Federal Student Aid for many calculations during the review period. Specifically, a difference in return amounts occurred when the amount of unearned charges (institutional charges for the period multiplied by the percentage of unearned Title IV aid) was less than the calculated amount of Title IV aid to be returned. Under the R2T4 calculation formula, the amount of unearned charges can effectively create a ?cap? on the amount of Title IV aid to be returned by the school. At Ivy Tech Community College, this cap is most often reached when students receive disbursements of federal student loans prior to withdrawing. Because a relatively small percentage of Ivy Tech students receive federal student loans, most correction calculations performed during the review period by Ivy Tech under our interpretation of the guidance resulted in accurate return amounts. This issue only impacted a subset of students who received a correction calculation during the review period. Description of Corrective Action Plan: Upon receiving new guidance from the Chicago/Denver regional office of Federal Student Aid, Ivy Tech has modified the way in which it performs R2T4 correction calculations. Aid returned as a result of the original calculation will remain in the correction calculation as ?aid disbursed? instead of ?aid that could have been disbursed.? The College is no longer following prior guidance received by an expert consultant, a representative of Federal Student Aid that advised the College to include aid that has already been returned as ?aid that could have been disbursed.? The calculation change will be monitored for correctness through the College?s previously established internal controls and quality assurance process for the R2T4 process. Financial aid staff have been trained on the calculation change. Ivy Tech will review all students during the review period who received a correction calculation and will cover with institutional aid any federal grant aid that otherwise would not have been returned under the new guidance from Federal Student Aid. Anticipated Completion Date: 3/31/2023

View Audit 43389

Finding 42615 (2022-001)

Significant Deficiency 2022

Elizabeth James Senior Housing

WA

HUD Housing Programs Questioned Costs Special Tests & Provisions

Contact Person(s): Hilary Prinz, Accounting Manager, 206-687-4080 Explanation and specific reasons for disagreement with the audit finding or that corrective action is not required (if applicable): Due to turnover of staff the residual receipt payment in the amount of $83,818 for 2021 audit was not ...

Contact Person(s): Hilary Prinz, Accounting Manager, 206-687-4080 Explanation and specific reasons for disagreement with the audit finding or that corrective action is not required (if applicable): Due to turnover of staff the residual receipt payment in the amount of $83,818 for 2021 audit was not made in 2022. Corrective action planned: The entire finance team has been familiarized with Elizabeth James residual receipt requirement. If there is staff turnover in the future everyone on the team is aware of the requirement. A repeating event reminder has been entered into the property accountant?s calendar, the property asset manager?s calendar, and the finance calendar causing multiple alerts to multiple people within the organization going forward. Anticipated completion date: The 2021 residual receipt deposit requirement in the amount of $83,818.00 was paid via check on March 20, 2023. Repeating calendar events have been completed as of March 29, 2023.

View Audit 44080

Finding 42612 (2022-001)

Material Weakness 2022

Scripps Health and Affiliates

CA

Allowable Costs / Cost Principles Internal Control / Segregation of Duties Subrecipient Monitoring

Finding 2022-001: Additional internal controls to ensure payroll expenditures are reviewed were implemented in late FY22 by adopting a new approach to ensure compliant timekeeping. The new approach includes the following steps: ? Revised the current timekeeping policy to clarify employee and mana...

Finding 2022-001: Additional internal controls to ensure payroll expenditures are reviewed were implemented in late FY22 by adopting a new approach to ensure compliant timekeeping. The new approach includes the following steps: ? Revised the current timekeeping policy to clarify employee and manager responsibilities ? Modified failure to comply provisions ? Deployed educational programs for both management and staff ? Reviewed/improved Kronos Time and Attendance system automated notifications ? Made training resources available to management and staff via our Scripps intranet site Leadership monitors policy compliance by individual employee and manager via systemwide reporting on a biweekly basis. Contact person: Eric Cole Expected Completion Date: Completed ? September 2022

View Audit 40148

Finding 42611 (2022-002)

Material Weakness 2022

Scripps Health and Affiliates

CA

Allowable Costs / Cost Principles Internal Control / Segregation of Duties Reporting

Finding 2022-002: Additional internal controls to ensure payroll expenditures are reviewed were implemented in late FY22 by adopting a new approach to ensure compliant timekeeping. The new approach includes the following steps: ? Revised the current timekeeping policy to clarify employee and mana...

Finding 2022-002: Additional internal controls to ensure payroll expenditures are reviewed were implemented in late FY22 by adopting a new approach to ensure compliant timekeeping. The new approach includes the following steps: ? Revised the current timekeeping policy to clarify employee and manager responsibilities ? Modified failure to comply provisions ? Deployed educational programs for both management and staff ? Reviewed/improved Kronos Time and Attendance system automated notifications ? Made training resources available to management and staff via our Scripps intranet site Leadership monitors policy compliance by individual employee and manager via systemwide reporting on a biweekly basis. Contact person: Eric Cole Expected Completion Date: Completed ? September 2022

View Audit 40148

Finding 42608 (2022-004)

Significant Deficiency 2022

Saint Mary's College of California

CA

Questioned Costs Student Financial Aid Reporting

Corrective Action Plan for the Year Ended June 30, 2022 Finding 2022-004: Significant Deficiency - Non-compliance with Reporting Requirements for Disbursements Condition/Context: For 2 of 25 students selected for testing, the disbursement dates did not agree between the student?s institutional acc...

Corrective Action Plan for the Year Ended June 30, 2022 Finding 2022-004: Significant Deficiency - Non-compliance with Reporting Requirements for Disbursements Condition/Context: For 2 of 25 students selected for testing, the disbursement dates did not agree between the student?s institutional account and the data reported to COD. The students had disbursements that were later refunded. It was noted that the students were disbursed without a valid MPN on file, resulting in students being disbursement that were not eligible at the time of disbursement. The College ultimately obtained the signed valid MPNs and then re- disbursed the funds, as a result the student account original disbursement date and the COD disbursement date differ. Actions Taken: To ensure that this problem does not recur for 2022-2023, disbursement rules have been instituted in Colleague that would prevent funds disbursing if a student hasn?t completed an MPN. The frequency of exports from Colleague to COD has been increased. In addition, Direct Loan and Pell rejects are being corrected each week so that if funds are disbursed and a Colleague or COD error is received, the disbursement is corrected and re- exported before the 15-day time limit. Name(s) of Contact Person Responsible for Corrective Action: Joseph Gilchrist, Interim Financial Aid Director Anticipated Completion date: June 30, 2023

View Audit 38194 Questioned Costs: $1

Finding 42606 (2022-002)

Significant Deficiency 2022

Saint Mary's College of California

CA

Questioned Costs Student Financial Aid Cash Management

Corrective Action Plan for the Year Ended June 30, 2022 Finding 2022-002: Significant Deficiency ? Direct Loan Reconciliation Condition/Context: The College was not able to provide the three monthly reconciliations for November 2021, February 2022, or April 2022 when requested for the audit in the ...

Corrective Action Plan for the Year Ended June 30, 2022 Finding 2022-002: Significant Deficiency ? Direct Loan Reconciliation Condition/Context: The College was not able to provide the three monthly reconciliations for November 2021, February 2022, or April 2022 when requested for the audit in the summer of 2022. The Institution noted that the reconciliations had not been performed timely, and subsequently the Institution had a consultant complete these reconciliations. The auditors were unable to obtain evidence of or confirmation from the Institution on if review of the reconciliations occurred. The sample was not a statistically valid sample. Additionally, the College discovered that Direct Loan reconciliation hadn't been done correctly in the past due to staff turnover. A consultant was given the task of doing a complete 21-22 reconciliation in June 2022. This consultant discovered 16 students had been awarded $177,816 in error. The cause of this was that rules had not been setup correctly in Colleague, and consistent reconciliation by correcting Colleague and COD errors wasn't completed in a timely manner. The auditors obtained the listing of students awarded incorrectly. Actions Taken: For the $177,816in direct loans incorrectly disbursed that was identified, SMC returned the loans and replaced with institutional aid for the impacted students. Beginning with July 2022, the Assistant Director/Systems Specialist reconciles direct loans every month. The Executive Director of Financial Aid and the VP of Enrollment Management review these reports at the end of each month. In addition, a system adjustment has been implemented for 2022-2023 to ensure reconciliation is done monthly. The Assistant Director/Systems Specialist utilizes Colleague variance reports that tract Direct Loans disbursed year to date, the number that COD (Servicer for U.S. Department of Education) has approved, and the students that make up the variance, if any. In addition, COD and Colleague errors that occur during the import/export of Direct Loans to and from COD are corrected on a consistent basis. Reconciliation documentation is then forwarded to the Executive Director for review. Name(s) of Contact Person Responsible for Corrective Action: Joseph Gilchrist, Interim Financial Aid Director Anticipated Completion date: June 30, 2023

View Audit 38194 Questioned Costs: $1

Finding 42592 (2022-006)

Significant Deficiency 2022

Saint Mary's College of California

CA

Internal Control / Segregation of Duties Questioned Costs Student Financial Aid § 200.303

Corrective Action Plan for the Year Ended June 30, 2022 Finding 2022-006: Significant Deficiency ? Control Environment Condition/Context: It was noted during the audit, that there were gaps in the internal control structure of the College, that was no longer adequate to ensure compliance with fede...

Corrective Action Plan for the Year Ended June 30, 2022 Finding 2022-006: Significant Deficiency ? Control Environment Condition/Context: It was noted during the audit, that there were gaps in the internal control structure of the College, that was no longer adequate to ensure compliance with federal regulations and compliance requirements. Action Taken: The staffing changes in the Business Office and the Financial Aid office resulted in learning curves for the new employees. Both offices have started projects to document procedures so that when turnover occurs, there is a blueprint in place to assist the new employees. SMC will also review the internal controls in place for federal reporting to determine how they can be strengthened. Name(s) of Contact Person Responsible for Corrective Action: Nicole Yu, AVP/Controller and Joseph Gilchrist, Interim Financial Aid Director Anticipated Completion dates: Documenting procedures is on ongoing project. Revised internal controls for federal reporting will be in place by June 30, 2023.

View Audit 38194

Finding 42591 (2022-003)

Significant Deficiency 2022

Saint Mary's College of California

CA

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

Corrective Action Plan for the Year Ended June 30, 2022 Finding 2022-003: Significant Deficiency - Enrollment Reporting Condition/Context: Of 25 students tested, the status date for one student selected was not reported accurately on the campus level reporting in National Student Loan Data System ...

Corrective Action Plan for the Year Ended June 30, 2022 Finding 2022-003: Significant Deficiency - Enrollment Reporting Condition/Context: Of 25 students tested, the status date for one student selected was not reported accurately on the campus level reporting in National Student Loan Data System (NSLDS). The College used the degree conferral date of 8/20/2021 rather than the end of the term/last date of attendance of July 4, 2021 that was used for reporting program level information for this student, and consistent with how other students were reported. Additionally, for two students, reporting at the program level was late, not within 30 days or included in a response to a roster file or within 60 days. The students were reported as graduated effective August 20, 2021 with the earliest certification date of October 31, 2021 at the campus level and December 3, 2021 at the program level. Action taken: In order to ensure compliance in 2022-2023, the Office of the Registrar has increased the degree of reporting frequency to National Student Clearinghouse (NSC), so as to meet the 60-day requirement in NSLDS. It has also have gained access to the National Student Loan Data System to monitor alignment with information submitted by SMC to NSC. Name(s) of Contact Person Responsible for Corrective Action: Tracey Donaldson, AVP and Registrar Anticipated Completion date: June 30, 2023

View Audit 38194

Finding 42590 (2022-001)

Significant Deficiency 2022

Saint Mary's College of California

CA

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

Corrective Action Plan for the Year Ended June 30, 2022 Finding 2022-001: Significant Deficiency- Return of Title IV Funds Condition/Context: During the audit it was noted that the College provided a list of students that withdrew during the fiscal year and this differed from data that was reporte...

Corrective Action Plan for the Year Ended June 30, 2022 Finding 2022-001: Significant Deficiency- Return of Title IV Funds Condition/Context: During the audit it was noted that the College provided a list of students that withdrew during the fiscal year and this differed from data that was reported internally to the Audit Committee on the number of students that withdrew in Fall 2021 and Spring 2022 (through April). The number of students that withdrew, the number of student?s that required an R2T4 calculation and the amount of the return all varied. The auditors discussed this with management who confirmed that the list provided to the auditors was complete and that the information reported to the Audit Committee was incorrect. From the withdrawal population the College did provide, a sample of 9 students were selected for testing for return of Title IV funds, of which 5 students did not require Title IV refunds and 4 students did require Title IV refunds. For the population of students with Title IV refunds, the calculations and refunds for 3 students were performed late, and for 1 of those students the calculation was also incorrect (excluded SEOG funds from the calculation). For the 3 students with refunds that were late, 100% of their Title IV funds were returned and then later re- disbursed before the R2T4 calculation and return occurred. Actions Taken: Subsequent to the 2021-2022 single audit fieldwork, SMC had a Financial Aid Services consultant review all R2T4 cases and 1 additional error was identified requiring the return of an additional $17.00. In the future, all R2T4 refund calculations will be performed by the Assistant Director/Systems Specialist who has received substantial training. In addition, the Assistant Director?s refund calculations will be reviewed by the Executive Director of Financial Aid for accuracy. System adjustments have also been made so that if funds are reversed they are re-disbursed at the amount the student is eligible for after the R2T4 calculation is completed. Name(s) of Contact Person Responsible for Corrective Action: Joseph Gilchrist, Interim Financial Aid Director Anticipated Completion date: June 30, 2023

View Audit 38194 Questioned Costs: $1

Finding 42589 (2022-002)

Significant Deficiency 2022

Memorial Regional Health

CO

Special Tests & Provisions Questioned Costs Significant Deficiency § 200.303

2022-002 United States Department of Agriculture CFDA 10.766 Community Facilities Loans and Grants Cluster Special Tests and Provisions Significant Deficiency in Internal Controls Over Compliance Finding Summary: There was no evidence retained that the Hospital?s recalculates debt covenants as requi...

2022-002 United States Department of Agriculture CFDA 10.766 Community Facilities Loans and Grants Cluster Special Tests and Provisions Significant Deficiency in Internal Controls Over Compliance Finding Summary: There was no evidence retained that the Hospital?s recalculates debt covenants as required or performs any review of one of the two financial debt covenant calculations. Responsible Individuals: Brittany Johnson, CFO Corrective Action Plan: Management will implement a control process which includes periodic calulation and review of all financial debt covenants. Anticipated Completion Date: Action taken and completed on 5/31/23

View Audit 39522

Finding 42568 (2022-001)

None 2022

Caribbean University, Inc.

PR

Special Tests & Provisions Student Financial Aid Reporting

Finding No. 2022-001 The University verified the internal processes to this report and verified the operating system manual used by the University from the report. After this assessment on May 5, 2021, the University is review and amended the procedure for identifying students who met the graduatio...

Finding No. 2022-001 The University verified the internal processes to this report and verified the operating system manual used by the University from the report. After this assessment on May 5, 2021, the University is review and amended the procedure for identifying students who met the graduation requirements. This procedure was done with the purpose of ensuring sent this report in the time required according by the regulations. This procedure is effective from fiscal year 2021 - 2022, as notified in the action plan for last year. As a result of the implementation of this process, the number of students was reduced by fourteen (14), from 16 to 2 compared to last year. This represents a reduction, of fifty-six percent (56%). In addition, to what has been previously explained, training and retraining will continue for all offices and departments that involved in the process established by the University. On the other hand, the University will continue to monitor the process by conducting internal audits to guarantee compliance with regulations in this matter.

View Audit 40375

Finding 42555 (2022-001)

None 2022

Milan Housing for the Elderly, Inc.

IN

Questioned Costs Matching / Level of Effort / Earmarking

CORRECTIVE ACTION PLAN Milan Housing for the Elderly RD Project No: 15-69-291939067 December 31, 2022 Reporting Views of Responsible Officials We concur that the replacement reserve and the reserve for taxes and insurance are underfunded. Concur or Do Not Concur with this Finding: Concur Agree or Di...

CORRECTIVE ACTION PLAN Milan Housing for the Elderly RD Project No: 15-69-291939067 December 31, 2022 Reporting Views of Responsible Officials We concur that the replacement reserve and the reserve for taxes and insurance are underfunded. Concur or Do Not Concur with this Finding: Concur Agree or Disagree with Auditor Recommendations: Agree Proposed Completion Date: December 31, 2023 Actions Taken or Planned on the Finding: The Project will increase funding as permitted by operating cash flows.

View Audit 38335

Finding 42507 (2022-002)

Significant Deficiency 2022

New Mexico Coalition to End Homelessness

NM

Reporting Matching / Level of Effort / Earmarking § 200.303 § 200.502 § 200.510

As requested, the New Mexico Coalition to End Homelessness has completed its corrective action plan for the audit findings in the 2022 fiscal year annual audit report. We have reviewed the findings and have made a corrective action plan to address each of the findings with completion dates. 2022-...

As requested, the New Mexico Coalition to End Homelessness has completed its corrective action plan for the audit findings in the 2022 fiscal year annual audit report. We have reviewed the findings and have made a corrective action plan to address each of the findings with completion dates. 2022-002?PREPARATION OF SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS Federal Agency: All presented in the Schedule of Expenditures of Federal Awards. Program Name: All presented in the Schedule of Expenditures of Federal Awards. Assistance Listing Nos. and Program Expenditures: All presented in Schedule of Expenditures of Federal Awards. Award Number and Program Award Year: All presented in Schedule of Expenditures of Federal Awards. Compliance Requirement: Other ? Schedule of Expenditures of Federal Awards preparation Type of Finding: E Questioned Costs: None Statement of Condition While conducting the audit, the following was reviewed; the Coalition?s Federal grants report for the fiscal year and identified the federal grants, Assistance Listing # (AL#) and the amounts of the federal expenditures and all of the other items required to properly present the Schedule of Expenditures of Federal Awards (SEFA). The finance staff of the Coalition confirm the correctness of the SEFA. Despite the confirmation of accuracy, additional federal expenditures and grouping of grant expenditures were identified after several reviews of the SEFA. Criteria 2 CFR 200.510 indicates that the auditee must prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee?s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502 Basis for Determining Federal Awards Expended. Per 2 CFR 200.502 the determination of when a Federal award is expended should be based on when the activity related to the Federal award occurs. Generally, the activity pertains to events that require the non-Federal entity to comply with Federal statutes, regulations, and the terms and conditions of Federal awards, such as expenditure/expense transactions associated with awards. In addition, 2 CFR Part 200.303 requires the program establish and maintain effective internal controls over Federal awards that provides reasonable assurance of compliance with Federal statutes, regulations, and the terms and conditions of Federal awards. Effect Without an established process governed by effective internal controls, the Coalition may not prevent or detect material misstatements on its SEFA in a timely manner. In addition, the errors could result in improper selections of major program(s) for the single audit and a substandard single audit. Cause Historically, the Coalition has requested the auditor assist in identifying accruals related to federal grant expenditures as the organization has maintained these records on a cash basis. As the organization has taken more responsibility on maintaining its federal grant expenditures on an accrual basis, an incomplete SEFA has been provided. Recommendation It is recommended the Coalition prepare the Schedule of Expenditures of Federal Awards and submit this to the auditor for testing. The SEFA should include the name of the grant, name of grantor, the AL #, the pass-through number if applicable and a reconciliation of the federal revenues and expenditures to the Coalition?s general ledger. The Coalition staff should perform more detailed reviews of the reports to ensure they properly reflect grant receipts and expenditures. This review should be performed by someone other than the preparer and should include documented evidence of agreeing the reported data to the accounting records. We further recommend training for those individuals involved in the preparation and review of the reports to ensure they are fully aware of the requirements. View of Responsible Officials and Corrective Action Plan: The corrective Action Plan will be carried out in the 2023 Fiscal Year and information will be given to the auditors when requested for the 2023 Audit. The Coalition will ensure that all information needed for the SEFA is kept and entered accurately. When the fiscal year closes out, the Coalition will provide the auditors with a test SEFA to confirm that the information we are collecting throughout the year and are asserting are the correct numbers for our federal grants, is indeed the correct information. Corrective Action Plan Timeline: Completed by October 31, 2023 (Final copy of the SEFA will not be given to the auditors until requested for the 2023 Audit) Designation Of Employee Position Responsible For Meeting Deadline: Executive Director, Monet Silva will oversee this project and work closely with the auditors to make sure that the information saved and shared is correct. Thank you, Monet Silva Executive Director

View Audit 40302

Finding 42502 (2022-001)

Significant Deficiency 2022

University of Detroit Mercy

MI

Student Financial Aid Reporting Significant Deficiency

Prior Year Finding Number: 2022-001 Fiscal Year in Which the Finding Initially Occurred: 2022 Federal Program, CFDA Number and Name: U.S. Department of Education, Student Financial Assistance Cluster ? CFDA 84.268, Federal Direct Student Loans; CFDA 84.063, Federal Pell Grant Program; CFDA 84.0...

Prior Year Finding Number: 2022-001 Fiscal Year in Which the Finding Initially Occurred: 2022 Federal Program, CFDA Number and Name: U.S. Department of Education, Student Financial Assistance Cluster ? CFDA 84.268, Federal Direct Student Loans; CFDA 84.063, Federal Pell Grant Program; CFDA 84.007, Federal Supplemental Educational Opportunity Grants Condition: The University did not accurately report a student status change to the NSLDS in a timely manner. Of the 40 students selected for enrollment reporting testing, the status change for 1 student was not accurately reported as withdrawn within the required 60-day period. Planned Corrective Action: The cause of the error has been found and the University has implemented additional controls to ensure that student graduation status is reported in a timely manner. Contact person responsible for corrective action: Diane Praet, Registrar Anticipated Completion Date: 12/31/2022

View Audit 39489

Finding 42498 (2022-003)

Significant Deficiency 2022

Borough of Prospect Park School District

NJ

Questioned Costs Eligibility School Nutrition Programs

Finding Number: 2022-003. Corrective Action Required by Board: The district should maintain the completed valid New Jersey Household Information Survey Form or documentation of direct certification for all students reported as low income. Method of Implementation: The Food Service manager will p...

Finding Number: 2022-003. Corrective Action Required by Board: The district should maintain the completed valid New Jersey Household Information Survey Form or documentation of direct certification for all students reported as low income. Method of Implementation: The Food Service manager will produce and properly file all required reports and forms for direct certification for all students. Person Responsible for Implementation: Food Service Manager. Planned Completion Date of Implementation: May 1, 2023

View Audit 39158

Finding 42474 (2022-002)

Significant Deficiency 2022

Fund for Public Health in New York, Inc.

NY

Questioned Costs Procurement, Suspension & Debarment Subrecipient Monitoring

Finding 2022?002 Reporting Corrective Action Plan: To ensure timely and accurate reporting of subaward data as required under the Federal Funding Accountability and Transparency Act (FFATA), the Fund will update its internal procedures to enhance tracking and monitoring. This will include requiring...

Finding 2022?002 Reporting Corrective Action Plan: To ensure timely and accurate reporting of subaward data as required under the Federal Funding Accountability and Transparency Act (FFATA), the Fund will update its internal procedures to enhance tracking and monitoring. This will include requiring that the FFATA reports are prepared and then reviewed by the preparer?s supervisor prior to submission. The Fund will also ensure that appropriate staff are notified and trained on the requirements and updated process. Management will monitor this issue regularly during the year to ensure compliance. Person Responsible for Correction Action: Rebecca Adeskavitz, Chief Operating Officer Projected Date of Completion: This corrective action plan will be implemented immediately in response to the Auditor?s recommendation.

View Audit 38318

Finding 42469 (2022-001)

Significant Deficiency 2022

Bloomfield College

NJ

Student Financial Aid Reporting Subrecipient Monitoring

The office of the Registrar will work with the academic administration to increase faculty education on the importance of timely reporting on non-attendance, to include a presentation at Faculty Orientation. Additionally, communications to all faculty will be sent at the census period and mid-point ...

The office of the Registrar will work with the academic administration to increase faculty education on the importance of timely reporting on non-attendance, to include a presentation at Faculty Orientation. Additionally, communications to all faculty will be sent at the census period and mid-point of the term, reminding them of the attendance policy and reporting requirements. Lastly, Division Chairs and Vice President of Academic Affairs will be sent a list of non-compliant reporting faculty for follow-up at week 3 and week 9.

View Audit 38359

Finding 42467 (2022-003)

Significant Deficiency 2022

Alamo Area Mutual Housing Association

TX

HUD Housing Programs Questioned Costs Significant Deficiency

CORRECTIVE ACTION PLAN Name and Number of the Project: AAMHA Babcock North, L.P. HUD No. 115-11305 Audit Firm: M Group, LLP Audit Period: The year ended December 31, 2022 Compliance Review C. COMMENTS ON FINDINGS AND RECOMMENDATIONS We concur with the findings and recommendations of our auditors reg...

CORRECTIVE ACTION PLAN Name and Number of the Project: AAMHA Babcock North, L.P. HUD No. 115-11305 Audit Firm: M Group, LLP Audit Period: The year ended December 31, 2022 Compliance Review C. COMMENTS ON FINDINGS AND RECOMMENDATIONS We concur with the findings and recommendations of our auditors regarding our noncompliance as cited in the accompanying Schedule of Findings and Questioned Costs. ACTIONS TAKEN FINDING 2022-003: Section 223(f) HUD Insured Loan, CFDA 14.155 CORRECTIVE ACTION COMPLETED: Management will monitor and reconcile the cash receipts received from San Antonio Housing Authority. On February 15, 2023, the Company received $45,629 from the affiliated property. Finding 2022-003 Cleared. We have prepared the corrective action plan as required by the standards applicable to financial statements contained in Government Auditing Standards and by the audit requirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). Any questions regarding the above corrective action plan should be directed to Brandi Vitier, Board Member.

View Audit 39155 Questioned Costs: $1

Finding 42465 (2022-001)

Significant Deficiency 2022

Alamo Area Mutual Housing Association

TX

Questioned Costs HUD Housing Programs Significant Deficiency

CORRECTIVE ACTION PLAN Name and Number of the Project: See Below Audit Firm: M Group, LLP Audit Period: The year ended December 31, 2022 Project Name: AAMHA Western Hills, LLC; HUD Project No. 115-35888; Amount $15,079 AAMHA Cypress Cove, LLC; HUD Project No. 115-11254; Amount $30,413 AAMHA Calcas...

CORRECTIVE ACTION PLAN Name and Number of the Project: See Below Audit Firm: M Group, LLP Audit Period: The year ended December 31, 2022 Project Name: AAMHA Western Hills, LLC; HUD Project No. 115-35888; Amount $15,079 AAMHA Cypress Cove, LLC; HUD Project No. 115-11254; Amount $30,413 AAMHA Calcasieu, LLC; HUD Project No. 115-11280; Amount $19,866 Total $65,358 Compliance Review A. COMMENTS ON FINDINGS AND RECOMMENDATIONS We concur with the findings and recommendations of our auditors regarding our noncompliance as cited in the accompanying Schedule of Findings and Questioned Costs. ACTIONS TAKEN FINDING 2022-001: Section 223(a)(7) HUD Insured Loan, CFDA 14.135 and Section 223(f) HUD Insured Loan, CFDA 14.155 CORRECTIVE ACTION COMPLETED: On April 3, 2023, the Company deposited $15,079 to fund the security deposit account for AAMHA Western Hill, LLC. On March 20, 2023, the Company deposited $30,413 to fund the security deposit account for AAMHA Cypress Cove, LLC. On March 14, 2023, the Company deposited $19,866 to fund the security deposit account for AAMHA Calcasieu, LLC. Finding 2022-001 Cleared. We have prepared the corrective action plan as required by the standards applicable to financial statements contained in Government Auditing Standards and by the audit requirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principals, and Audit Requirements for Federal Awards. Any questions regarding the above corrective action plan should be directed to Brandi Vitier, Board Member.

View Audit 39155

Finding 42464 (2022-002)

Significant Deficiency 2022

Alamo Area Mutual Housing Association

TX

Questioned Costs HUD Housing Programs Significant Deficiency

CORRECTIVE ACTION PLAN Name and Number of the Project: AAMHA KPTP, LLC HUD No. 115-35652 Audit Firm: M Group, LLP Audit Period: The year ended December 31, 2022 Compliance Review B. COMMENTS ON FINDINGS AND RECOMMENDATIONS We concur with the findings and recommendations of our auditors regarding our...

CORRECTIVE ACTION PLAN Name and Number of the Project: AAMHA KPTP, LLC HUD No. 115-35652 Audit Firm: M Group, LLP Audit Period: The year ended December 31, 2022 Compliance Review B. COMMENTS ON FINDINGS AND RECOMMENDATIONS We concur with the findings and recommendations of our auditors regarding our noncompliance as cited in the accompanying Schedule of Findings and Questioned Costs. ACTIONS TAKEN FINDING 2022-002: Section 223(a)(7) HUD Insured Loan, CFDA 14.135 CORRECTIVE ACTION COMPLETED: Management will review the HUD Regulatory Agreement to ensure compliance governing surplus cash calculation and distributions. On March 28, 2023, Alamo repaid $61,764 to the Project. Finding 2022-002 Cleared. We have prepared the corrective action plan as required by the standards applicable to financial statements contained in Government Auditing Standards and by the audit requirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principals, and Audit Requirements for Federal Awards. Any questions regarding the above corrective action plan should be directed to Brandi Vitier, Board Member.

View Audit 39155 Questioned Costs: $1

Corrective Action Plans

Filters