Corrective Action Plans

Finding 48519 (2022-004)

Material Weakness 2022

North Central Parke Community School Corporation

IN

Special Tests & Provisions Subrecipient Monitoring Material Weakness § 200.303

FINDING 2022-004 Contact Person Responsible for Corrective Action: Mike Schimpf, Superintendent Contact Phone Number: 765-569-4191 Views of Responsible Official: We concur with the finding. Description of Corrective Action Plan: The material weakness in graduation cohort supporting documentation was...

FINDING 2022-004 Contact Person Responsible for Corrective Action: Mike Schimpf, Superintendent Contact Phone Number: 765-569-4191 Views of Responsible Official: We concur with the finding. Description of Corrective Action Plan: The material weakness in graduation cohort supporting documentation was due to the performance of previous building administration at the High School. A new building Principal and Guidance counselor have replaced those individuals. It is the responsibility of the Superintendent to ensure that the new building administrators are following IC 20-26-13 for graduation Cohort rate determination. Effective immediately, the High School building Principal and HS Guidance counselor will be given a copy of the graduation Cohort compliance regulations. The Superintendent will monitor their compliance and supporting documentation as needed. Anticipated Completion Date: Effective immediately

View Audit 44369

Finding 48501 (2022-001)

None 2022

Alexander Youth Network

NC

Subrecipient Monitoring

To prevent further late reports, internal calendar notifications will be added to the Executive Director and Program Director?s calendars. All information needed for the quarterly reports will be collected by the 15th of the month so the report can be submitted on time by the end of the month it is ...

To prevent further late reports, internal calendar notifications will be added to the Executive Director and Program Director?s calendars. All information needed for the quarterly reports will be collected by the 15th of the month so the report can be submitted on time by the end of the month it is due. The reporting calendar will be created at the beginning of the grant period so all dates are reviewed ahead of time, so there is no mistake which reports are due when. The Organization?s anticipated completion date for the corrective action plan is February 2023.

View Audit 41644

Finding 48500 (2022-002)

Significant Deficiency 2022

Association of State Drinking Water Administrators

VA

Subrecipient Monitoring Reporting

Finding No. 2022-002: Timely Submission of Required Federal Reports - Significant Deficiency in Internal Control Over Compliance ? Assistance Listing No. 66.424 Recommendation We recommend ASDWA utilize a comprehensive checklist to ensure all required reports are prepared and submitted in a timely ...

Finding No. 2022-002: Timely Submission of Required Federal Reports - Significant Deficiency in Internal Control Over Compliance ? Assistance Listing No. 66.424 Recommendation We recommend ASDWA utilize a comprehensive checklist to ensure all required reports are prepared and submitted in a timely manner. At least two individuals should be tasked with responsibility for monitoring the due dates for all required submissions. Action Taken We are working to establish a more robust notification system for all staff concerning required reporting deadlines. While ASDWA has a very small staff size of just 6, additional training and back-up for various responsibilities is being developed to better ensure timely action for all required filings. The ASDWA Accounting Liaison and another ASDWA staff person will be tasked for monitoring the due dates for all required submissions. Contact Person Responsible for Corrective Action Alan Roberson, Executive Director aroberson@asdwa.org Expected Completion Date: This corrective action is in process and expected to be fully implemented by June 30, 2023.

View Audit 47010

Finding 48494 (2022-004)

Significant Deficiency 2022

State of Alabama

AL

Subrecipient Monitoring Internal Control / Segregation of Duties Reporting

Finding Ref. No. 2022-004 Finding The Federal Funding Accountability and Transparency Act (Pub. L. No. 109-282), as amended by Section 6202 of Pub. L. No. 110-252, hereafter referred as the "Transparency Act" that are codified in 2 CFR Part 170, requires recipients (i.e., direct recipients) of gran...

Finding Ref. No. 2022-004 Finding The Federal Funding Accountability and Transparency Act (Pub. L. No. 109-282), as amended by Section 6202 of Pub. L. No. 110-252, hereafter referred as the "Transparency Act" that are codified in 2 CFR Part 170, requires recipients (i.e., direct recipients) of grants or cooperative agreements are required to report first-tier subawards of $30,000 or more to the Federal Funding Accountability and Transparency Act Subaward Reporting System (FSRS). The Uniform Guidance, 2 CFR Part 200, Appendix XI Compliance Supplement, May 2022, requires the Alabama Emergency Management Agency to report applicable first-tier subawards and contracts information as required in the "Transparency Act". The Alabama Emergency Management Agency (EMA) failed to provide the requested subaward letters and FSRS reports containing key data elements for the sample population of fourteen (14) first-tier subawards. The Alabama Emergency Management Agency did not have procedures in place to ensure that applicable first-tier subaward information was reported to the FSRS, resulting in a failure to provide a full disclosure to the public of all entities or organizations receiving federal funds during fiscal year 2022. Recommendation The Alabama Emergency Management Agency (EMA) should develop, maintain, and implement effective procedures to ensure compliance with the Federal Funding Accountability and Transparency Act (FFATA). Response/Views: We agree with the finding. Corrective Action Planned: The AEMA Recovery Division has hired additional staff that is assigned the task of completing and submitting FFATA reporting for future grants and for the funding listed in the recent FEMA monitoring report. The newly hired employees are new to the emergency management profession and are completing the required new-hire training. Once their training is complete, they will start training on FFATA and begin working to correct the finding. Reason for the Recurrence: Due to limited staffing and the obligation of funding changing on the nineteen open federally declared disasters that contain several hundred applicants per disaster, the agency could not maintain the FFATA requirement. The Alabama Emergency Management Agency did not have procedures in place to ensure that applicable first-tier sub-award information was reported to the Federal Funding Accountability and Transparency Act Subaward Reporting System (FSRS), failing to provide full disclosure to the public of all entities or organizations receiving federal funds during the fiscal year 2022. Our agency has amended procedures to ensure compliance and that applicable first-tier sub-award information is reported to the FSRS. Anticipated Completion Date: The goal is that significant progress can and will be made by the end of November. Contact Person(s): Craig Bolling, Director of Operations - Mission Support Email: craig.bolling@ema.alabama.gov Office: 205-280-2480 LaTonya Stephens, Director of Operations - Recovery Email: latonya.stephens@ema.alabama.gov Office: 205-280-2433

View Audit 41985

Finding 48491 (2022-002)

Material Weakness 2022

State of Alabama

AL

Questioned Costs Subrecipient Monitoring Eligibility § 200.303

Finding Ref. No. 2022-002 Finding: The Uniform Guidance, 2 CFR 200.303, requires non-Federal entities receiving Federal Awards (i.e., auditee management) to establish and maintain effective internal controls over the Federal Award that provide reasonable assurance that the non-Federal entity is man...

Finding Ref. No. 2022-002 Finding: The Uniform Guidance, 2 CFR 200.303, requires non-Federal entities receiving Federal Awards (i.e., auditee management) to establish and maintain effective internal controls over the Federal Award that provide reasonable assurance that the non-Federal entity is managing the Federal Award in compliance with Federal statutes, regulations, and terms and conditions of the Federal Award. 20 CFR 604.3(a) requires a State to only pay an individual who is able to work and available for work for the week which Unemployment Compensation (UC) is claimed. Based on work performed on unemployment compensation payments at the Alabama Department of Labor, for the period of October 1, 2021, through September 30, 2022, we identified 243 payments, totaling $58,809.00, which were made to 22 deceased claimants. We also identified an additional 186 payments, totaling $42,276.00, which were made to 27 incarcerated claimants. The combined improper payments to deceased or incarcerated claimants total $101,085.00 for the Unemployment Insurance Program. The Alabama Department of Labor did not have internal controls in place which were adequately designed to identify deceased or incarcerated claimants in a timely manner, in order to help prevent and/or detect improper payments. The lack of a well-designed system of internal controls, to identify deceased or incarcerated claimants, could cause the Alabama Department of Labor to continue to pay benefits to claimants who are deceased or incarcerated. Recommendation: The Alabama Department of Labor should establish and maintain effective internal controls to help ensure payments are not made to deceased or incarcerated claimants. Response/Views: We agree with the finding. Corrective Action Planned: ADOL now utilizes IDV through the Integrity Data Hub (IDH) for death crossmatch, giving ADOL the capability to crossmatch all claimants through the IDV. However, the review process is manual at this time. ADOL continues to pursue a fully automated process with the system vendor. ADOL is also working with the Interstate Connection Network (ICON) through the National Association of State Workforce Agencies (NASWA) to implement a match of SSN?s with the Social Security Administration?s Prisoner Update Processing System (PUPS). This will allow records to be checked in a nationwide database not just the State of Alabama. Reason for the Recurrence: The cause of this was due to the workload of pandemic claims and the lack of requirements to provide proof of income and employment. Prior to the pandemic a person had to have wages in order to qualify for benefits, eliminating a deceased person of more than 2 years from being monetarily eligible for benefits. Any remaining claimants that had died would be reported by the employer or through returned mail or a surviving of family member. Any notice of deceased person would be reviewed. With no way to verify whether a person was deceased or not, some did pay benefits. Anticipated Completion Date: ADOL implemented checking claims through IDH June 2022. Netacent, the vendor who maintains ADOL?s unemployment system, anticipates the PUPs project to be fully functioning by December 31,2023. Contact Person(s): Brent Langley, Assistant Unemployment Administrator

View Audit 41985 Questioned Costs: $1

Finding 48483 (2022-008)

Significant Deficiency 2022

Community College of Beaver County

PA

Subrecipient Monitoring Reporting Significant Deficiency

Finding 2022-008: Improper HEERF Student Aid Portion Reporting ? Significant Deficiency and Noncompliance Condition: There were no student quarterly reports posted to the College's website for the quarters ending September 30, 2021, December 31, 2021, and March 31, 2022 and the institutional quarter...

Finding 2022-008: Improper HEERF Student Aid Portion Reporting ? Significant Deficiency and Noncompliance Condition: There were no student quarterly reports posted to the College's website for the quarters ending September 30, 2021, December 31, 2021, and March 31, 2022 and the institutional quarterly reports were posted late for the quarters ending September 30, 2021, December 31, 2021 and March 31, 2022. Responsible for the Plan: Kolt Codner, Chief of Staff, Executive Director CCBC Foundation, Advancement and Sponsored Programs Glenn Natali, Vice President of Finance, Operations, and Information Technology Planned completion date: June 30, 2023 Corrective Action Plan: To ensure compliance with HEERF Student Aid Reporting the Office of Advancement and Sponsored Programs will continue to develop all required quarterly and annual reports as requested by the Department of Education HEERF program office. ? Student Aid reporting will be developed by OASP and posted on all required PDF reporting forms and uploaded to the CARES Aid Reporting (https://www.ccbc.edu/cares-aid-reporting ) website as required. ? The Student Aid report will also be emailed to the program officer quarterly as required. ? Narrative at the top of the CARES Aid Reporting site (https://www.ccbc.edu/cares-aid-reporting) will be updated and prior period reports will be saved and posted at the bottom of the page. ? Each quarterly report will be developed and posted by the Executive Director of Advancement and Sponsored Programs ? Following the posting of reporting the Vice President of Finance will review and confirm timely and complete reporting to satisfy HEERF requirements.

View Audit 52943

Finding 48482 (2022-007)

Significant Deficiency 2022

Community College of Beaver County

PA

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

Finding 2022-007: Late Student Status Change Reporting ? Significant Deficiency and Noncompliance Condition and Context: The change in status for one of 25 students tested was not reported to the National Student Loan Data System (NSLDS) within 30 days or included in a roster file within 60 days. Re...

Finding 2022-007: Late Student Status Change Reporting ? Significant Deficiency and Noncompliance Condition and Context: The change in status for one of 25 students tested was not reported to the National Student Loan Data System (NSLDS) within 30 days or included in a roster file within 60 days. Responsible for the Plan: Janet Davidson, Director of Financial Aid Planned completion date: June 30, 2023 Corrective Action Plan: The Institution Research & Data Analyst currently has a process to ensure that status changes for enrolled and withdrawn students are completed in a timely manner. For students who graduated the process is slightly different. The graduation status change is currently populated through the degree transmission files. In some instances the process does not automatically update the student enrollment record and the college must complete an additional step to ensure the graduation date is reflected not only on the degree tab but also on the enrollment information. To ensure that this is completed in a timely manner we will implement the following procedures. ? The Student Records office will review all applications for graduation within two weeks of final grades being submitted. ? The Degree Verify file will be submitted no later than 25 days after the end of the term/the degree conferred date. ? Once the degree file has been submitted the Student Records office will follow up with the National Student Clearinghouse to review the G Not Applied report and updated individual student records where the degree file did not update the enrollment record to reflect the graduation date.

View Audit 52943

Finding 48468 (2022-008)

Material Weakness 2022

Rochester Community School Corporation

IN

Special Tests & Provisions Subrecipient Monitoring Material Weakness § 200.303

FINDING 2022-008 (Auditor Assigned Reference Number) Contact Person Responsible for Corrective Action: Todd VanDerWeele Contact Phone Number: 574.223.2159 Views of Responsible Official: We concur with the finding. The Head Secretary at Rochester High School will document any student that is removed ...

FINDING 2022-008 (Auditor Assigned Reference Number) Contact Person Responsible for Corrective Action: Todd VanDerWeele Contact Phone Number: 574.223.2159 Views of Responsible Official: We concur with the finding. The Head Secretary at Rochester High School will document any student that is removed from the high school graduation cohort. The secretary will have the high school principal review and approve this documentation, and the secretary will place in the student?s permanent file. Anticipated Completion Date: May 31, 2023

View Audit 52598

Finding 48467 (2022-007)

Material Weakness 2022

Rochester Community School Corporation

IN

Special Tests & Provisions Subrecipient Monitoring Material Weakness § 200.207 § 200.303

FINDING 2022-007 (Auditor Assigned Reference Number) Contact Person Responsible for Corrective Action: Todd VanDerWeele Contact Phone Number: 574.223.2159 Views of Responsible Official: We concur with the finding. 1. The Curriculum Director will create a control at the beginning of the school year s...

FINDING 2022-007 (Auditor Assigned Reference Number) Contact Person Responsible for Corrective Action: Todd VanDerWeele Contact Phone Number: 574.223.2159 Views of Responsible Official: We concur with the finding. 1. The Curriculum Director will create a control at the beginning of the school year so that we can properly ensure all parties receive test security training. This will be a google document, separated by tabs at the bottom for each building, with the names of all staff members. The control will also contain columns that can be check marked when test security forms and training is completed. The control will also contain a box to show the date training was completed. 2. We will have this document for training on test security in each building in August and September. Each staff member will sign the document to show they received the training. 3. The Curriculum Director will create an agenda for each training to properly ensure all staff members are trained. 4. All staff members will also be required to sign the test security form provided by the IDOE at their respective training. 5. For all staff members who miss training at their building, a Google Form will be provided with all of the test security information. Staff members will be required to fill out the form and watch the training video. The form will be time and date stamped. 6. The Curriculum Director will update the control at least once a week until all staff members are trained. Anticipated Completion Date: February 2024

View Audit 52598

Finding 48446 (2022-001)

Material Weakness 2022

Mid-East Career and Technology Centers

OH

Special Tests & Provisions Student Financial Aid Subrecipient Monitoring

Finding Number: 2022-001 Planned Corrective Action: Mid-East's Adult Education Financial Coordinator retired at the end of Fiscal Year 2021. As any new position, there was a learning curve and the new Financial Aid Coordinator received limited training with the former Coordinator. Consultants were...

Finding Number: 2022-001 Planned Corrective Action: Mid-East's Adult Education Financial Coordinator retired at the end of Fiscal Year 2021. As any new position, there was a learning curve and the new Financial Aid Coordinator received limited training with the former Coordinator. Consultants were hired to help, but this specific reconciliation process was not discussed. There has been a recent change in the Adult Education Director's position, and it is the intention of the new Director to eventually cross-train positions. This will assist in the future for a smoother transition between employees leaving and new employees hired. Since the finding, the Adult Education Financial Coordinator has established a checklist of items that need to be completed for each drawdown. This checklist will be placed in each drawdown folder. The Monthly Drawdown Reconciliation plan will include beginning with verifying with Common Origination and Disbursement Center (COD) School Summery report prior to the disbursement. Once the disbursement information is entered into Ed-Express and transferred to COD for the month review of the School Summary report, it will be reviewed to verify that the "Cash>Net Accepted & Posted Disbursements" matches the Achademix Drawdown Batch. Then, again when the disbursement funds are disbursed, a review of the COD School Summary report will occur. At any time, if a variance occurs, it will be addressed immediately. This plan of action went into place with the February 17, 2023 disbursement process. All documentation of any reconciliations will be kept in each drawdown file. The variance of the $866.00 occurred during the final drawdown of Fiscal Year 2022. As the reconciliation process was not in place, the variance was not discovered. As a new Fisca Year started, it was a new batch of funds, and the $866 variance was not discovered until the audit process. The variance was researched and corrected. The correction was located and corrected in Ed Express and had no monetary effect. The School Summary report from COD Cash>Net Accepted & Posted Disbursements" is at zero for 2021-2022, and documentation has been kept on that. The newly implemented checklist and process for reconciliation will prevent variances from happening in the future. Anticipated Completion Date: Currently in place and will continue. Responsible Contact Person: Thasia Shilling, Adult Education Financial Aid Coordinator

View Audit 47843

Finding 48429 (2022-002)

Significant Deficiency 2022

City of North Las Vegas

NV

Subrecipient Monitoring HUD Housing Programs Matching / Level of Effort / Earmarking

The management team agrees with the auditor?s recommendation and has already implemented additional controls to address the stated concerns. Effective July 1, 2022, the City created a separate Grants division to centralize the application, compliance and administration of federal grants. This depart...

The management team agrees with the auditor?s recommendation and has already implemented additional controls to address the stated concerns. Effective July 1, 2022, the City created a separate Grants division to centralize the application, compliance and administration of federal grants. This department is responsible for creating a City-wide Grants Policy and Procedures Manual related to grants including but not limited to: acceptance of an award, managing an award, initiating and monitoring subawards, programmatic and financial reporting and closeout of awards. The Grants Director is responsible for the corrective action as it relates to this finding.

View Audit 41405

Finding 48426 (2022-004)

Significant Deficiency 2022

City of North Las Vegas

NV

Subrecipient Monitoring Internal Control / Segregation of Duties § 200.332

The management team agrees with the auditor?s recommendation and has already implemented additional controls to address the stated concerns. Effective July 1, 2022, the City created a separate Grants division to centralize the application, compliance and administration of federal grants. This depart...

The management team agrees with the auditor?s recommendation and has already implemented additional controls to address the stated concerns. Effective July 1, 2022, the City created a separate Grants division to centralize the application, compliance and administration of federal grants. This department is responsible for creating a City-wide Grants Policy and Procedures Manual related to grants including but not limited to: acceptance of an award, managing an award, initiating and monitoring subawards, programmatic and financial reporting and closeout of awards. The Grants Director is responsible for the corrective action as it relates to this finding.

View Audit 41405

Finding 48425 (2022-002)

Significant Deficiency 2022

City of Paramount

CA

Matching / Level of Effort / Earmarking Procurement, Suspension & Debarment Subrecipient Monitoring § 200.303 § 200.329

FINDING 2022-002 Program: COVID-19: Coronavirus State and Local Fiscal Recovery Funds CFDA No.: 21.027 Federal Grantor: United States Department of the Treasury Passed-through: N/A Compliance Requirements: Reporting Auditor Recommendation: We recommend the City enhance internal controls to ensure ...

FINDING 2022-002 Program: COVID-19: Coronavirus State and Local Fiscal Recovery Funds CFDA No.: 21.027 Federal Grantor: United States Department of the Treasury Passed-through: N/A Compliance Requirements: Reporting Auditor Recommendation: We recommend the City enhance internal controls to ensure Interim and Project and Expenditure Reports are prepared in accordance with program requirements. Views of Responsible Officials and Corrective Action: We concur with the recommendation and will enhance internal controls to ensure that the Interim and Project and Expenditure Reports are prepared in accordance with program requirements. During this reporting period, there was no clear direction from the State on how to submit prior period corrections, so to achieve this action, City staff submitted a zero ?current expenditure? and then included the prior period adjustment in the cumulative total. Since the audit found that this was the wrong process and a deficiency in reporting, the City will reach out to the State for assistance in reporting prior period corrections. The City will ensure a thorough review prior to submitting to ensure the report is accurate. The City also encountered reporting difficulties for the quarter ending 6/30/2022 with entering vendor information. City staff contacted the State to request assistance, however the State was overwhelmed with requests from agencies state-wide and was not able to respond to the City?s request in a timely manner. The State was aware of the issues and had allowed Cities to submit their report late. The City has not had any issue subsequent to the 6/30/2022 report and has been submitting its report timely. Name of Responsible Person: Kim Sao, Finance Director Implementation Date: 6/30/2023

View Audit 47393

Finding 48424 (2022-001)

Significant Deficiency 2022

City of Paramount

CA

Procurement, Suspension & Debarment Subrecipient Monitoring § 200.214 § 200.317 § 200.318 § 200.319 § 200.321

FINDING 2022-001 Program: COVID-19: Coronavirus State and Local Fiscal Recovery Funds CFDA No.: 21.027 Federal Grantor: United States Department of the Treasury Passed-through: N/A Compliance Requirements: Procurement, Suspension and Debarment Auditor Recommendation: We recommend the City modify a...

FINDING 2022-001 Program: COVID-19: Coronavirus State and Local Fiscal Recovery Funds CFDA No.: 21.027 Federal Grantor: United States Department of the Treasury Passed-through: N/A Compliance Requirements: Procurement, Suspension and Debarment Auditor Recommendation: We recommend the City modify and strengthen its policies and procedures to ensure that the required Uniform Guidance standards are addressed. Views of Management/Responsible Officials and Corrective Action: The City concurs with the auditor?s recommendation and will modify and strengthen its policies and procedures to ensure that the required Uniform Guidance standards are addressed. The City has never had a finding in its Single Audit before and was not aware that the procurement standards identified in Title 2 of the Code of Federal Regulations (CFR), specifically 2 CFR sections 200.317 through 200.326, had to be included in the City?s procurement policy. Being that this was the first time the City received the ARPA funding and was subject to this requirement, this deficiency came up. The City will review and bring its current policy up to date. The City also made an effort to comply when a deficiency was known. In August 2022, the City established its Debarment and Suspension policy. With this policy in place, the City will review its current process to ensure that going forward, verifications for debarment and suspension are performed for contractors prior to entering into transactions with them. Name of Responsible Person: Kim Sao, Finance Director Implementation Date: 6/30/2023

View Audit 47393

Finding 48421 (2022-001)

Material Weakness 2022

Horizon Science Academy of Cleveland

OH

Matching / Level of Effort / Earmarking Subrecipient Monitoring

Finding Number: 2022-001 Planned Corrective Action: See Below Anticipated Completion Date: 03/17/2023 Responsible Contact Person: Ramazan Celep, Treasurer The District is aware of the requirement in Federal program legislation to ensure inclusion of the prevailing w...

Finding Number: 2022-001 Planned Corrective Action: See Below Anticipated Completion Date: 03/17/2023 Responsible Contact Person: Ramazan Celep, Treasurer The District is aware of the requirement in Federal program legislation to ensure inclusion of the prevailing wage rate provision in Agreements, as well as to obtain certified payroll reports to verify prevailing wages were paid. In the future, the District will work more closely with the contractor to ensure proper language is included in the bid documents and the contracts to ensure the District is in compliance with applicable federal regulations.

View Audit 46104

Finding 48419 (2022-001)

Material Weakness 2022

Alive, Inc.

MO

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

Corrective Action Plan Contact Name: Maggie Menefee Corrective Action: ALIVE is seeking an individual with appropriate nonprofit and federal award experience to provide additional oversight Expected Completion Date: December 31, 2022.

View Audit 53779 Questioned Costs: $1

Finding 48408 (2022-001)

Material Weakness 2022

Castle Rock School District No. 401

WA

Procurement, Suspension & Debarment School Nutrition Programs Subrecipient Monitoring

Finding ref number: 2022-001 Finding caption: The District did not have adequate internal controls for ensuring compliance with federal procurement requirements. Name, address, and telephone of District contact person: Shelby Garrett 600 Huntington Avenue S. Castle Rock WA 98611 (360) 501-2940 Corre...

Finding ref number: 2022-001 Finding caption: The District did not have adequate internal controls for ensuring compliance with federal procurement requirements. Name, address, and telephone of District contact person: Shelby Garrett 600 Huntington Avenue S. Castle Rock WA 98611 (360) 501-2940 Corrective action the auditee plans to take in response to the finding: Once the district was notified of the noncompliance regarding Child Nutrition federal procurement requirements, an interlocal agreement was immediately put in place with Longview School District for our small purchases of $150,000 or below. The agreement was approved by the Castle Rock School Board at the March 8, 2023 board meeting and approved by the Longview School District School Board on March 17, 2023. For our purchases above $150,000, the district requested to be a member of the Puget Sound Joint Purchasing Cooperative on March 6, 2023 and the membership was approved by the PSJPC Board on March 12, 2023. PSJPC provided the district with an interlocal agreement and the agreement was approved by the Castle Rock School Board at the March 22, 2023 board meeting. Anticipated date to complete the corrective action: 3/22/2023

View Audit 53371

Finding 48406 (2022-008)

Significant Deficiency 2022

Alexandria Community School Corporation

IN

Internal Control / Segregation of Duties Subrecipient Monitoring Reporting § 200.303

2022-008 COVID-19 Education Stabilization Fund Recommendation: School Corporation management should establish a system of internal control to ensure compliance. Training over proper internal control development and implementation may be beneficial. Explanation of disagreement with audit fin...

2022-008 COVID-19 Education Stabilization Fund Recommendation: School Corporation management should establish a system of internal control to ensure compliance. Training over proper internal control development and implementation may be beneficial. Explanation of disagreement with audit finding: There is no disagreement with the audit finding. Action planned in response to finding: The school corporation will implement a review process to ensure reports are reviewed before submission. Name of the contact person responsible for corrective action: Cheryl Harvey, Business Manager Planned completion date for corrective action plan: Begin immediately

View Audit 52597

Finding 48384 (2022-015)

Material Weakness 2022

State of New York

NY

Questioned Costs Subrecipient Monitoring Allowable Costs / Cost Principles

State Agency: Office of Children and Family Services Single Audit Contact: Bonnie Hahn Title: External Audit Liaison Telephone: 518-486-1034 E-mail Address: Bonnie.Hahn@ocfs.ny.gov Federal Program(s) (ALN # [s]): Social Services Block Grant (93.667) Audit Report Reference: 2022-015 Anticipated Compl...

State Agency: Office of Children and Family Services Single Audit Contact: Bonnie Hahn Title: External Audit Liaison Telephone: 518-486-1034 E-mail Address: Bonnie.Hahn@ocfs.ny.gov Federal Program(s) (ALN # [s]): Social Services Block Grant (93.667) Audit Report Reference: 2022-015 Anticipated Completion Date: 3/31/24 Corrective Action Planned: OCFS Bureau of Financial Operations has set up monitoring activities to review the adequacy of supporting documentation and appropriateness of Title XX claims. Going forward, the annual subrecipient risk assessment will be used to determine a schedule for reviewing the districts. OCFS will review the current monitoring activities performed by various program offices to determine, when considered as a whole, if they are sufficient to address the portion of the finding regarding eligibility and the accuracy of the Post-Expenditure Report.

View Audit 49189 Questioned Costs: $1

Finding 48382 (2022-014)

Significant Deficiency 2022

State of New York

NY

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

State Agency: Office of Children and Family Services Single Audit Contact: Bonnie Hahn Title: External Audit Liaison Telephone: 518-486-1034 E-mail Address: Bonnie.Hahn@ocfs.ny.gov Federal Program(s) (ALN # [s]): Foster Care Block Grant (93.658) Audit Report Reference: 2022-014 Anticipated Completio...

State Agency: Office of Children and Family Services Single Audit Contact: Bonnie Hahn Title: External Audit Liaison Telephone: 518-486-1034 E-mail Address: Bonnie.Hahn@ocfs.ny.gov Federal Program(s) (ALN # [s]): Foster Care Block Grant (93.658) Audit Report Reference: 2022-014 Anticipated Completion Date: 3/31/24 Corrective Action Planned: OCFS is in the process of determining procedures for reviewing the reasonableness of the rates being used by the local districts and will implement corrective action to remediate the finding. The 2022-2023 NYS Executive Budget included a mandate requiring Local Districts to pay no less than the Maximum State Aid Rate (MSAR) for all children in foster boarding homes no later than July 1, 2023. The Office of Children and Family Services is in the process of revising the MSAR tables. This change will require districts to review the Level of Difficulty (LOD) assigned to individual children and revise the rates assigned to them based on the new rate schedule. OCFS has established a two-year timeframe to allow districts to phase in the use of the rates and OCFS will provide technical assistance as needed.

View Audit 49189

Finding 48380 (2022-013)

Significant Deficiency 2022

State of New York

NY

Subrecipient Monitoring Reporting Allowable Costs / Cost Principles

State Agency: Office of Temporary and Disability Assistance Single Audit Contact: Thomas Cooper Title: Director of Internal Audit Telephone: (518) 473-4601 E-mail Address: Thomas.cooper@otda.ny.gov Federal Program(s) (ALN # [s]): Low Income Home Energy Assistance Program (93.568) Audit Report Refere...

State Agency: Office of Temporary and Disability Assistance Single Audit Contact: Thomas Cooper Title: Director of Internal Audit Telephone: (518) 473-4601 E-mail Address: Thomas.cooper@otda.ny.gov Federal Program(s) (ALN # [s]): Low Income Home Energy Assistance Program (93.568) Audit Report Reference: 2022-013 Anticipated Completion Date: 1/31/2023 Corrective Action Planned: OTDA is working with our ITS development partners to implement updates to the OTDA FFATA reporting logic as follows: ? Raise expenditure threshold for subrecipients that equals or exceeds $30,000 (previous amount was > $25,000). (This is complete.) ? When calculating the expenditures for subrecipient payments, the report logic needs to account for internal split coding and for multiple grant payments made on a single voucher. (This is complete.) ? Update reporting logic for SFS/OSC Accounting Date (previous logic used SFS/OSC Voucher Paid Date). The SFS Accounting Date will be used as the Obligation Date in accordance with the definition of Obligation Date in the guidance. Anticipated completion and implementation for reporting in January 2023.

View Audit 49189

Finding 48347 (2022-001)

Material Weakness 2022

Seattle School District No. 1

WA

Questioned Costs Allowable Costs / Cost Principles Subrecipient Monitoring

Finding ref number: 2022-001 Finding caption: The District did not have adequate internal controls for ensuring compliance with allowable activities and costs, and restricted purpose requirements. Name, address, and te...

Finding ref number: 2022-001 Finding caption: The District did not have adequate internal controls for ensuring compliance with allowable activities and costs, and restricted purpose requirements. Name, address, and telephone of District contact person: Amy Fleming, Accounting Director 2445 3rd Avenue S. Seattle WA 98104 (206) 252-0274 Corrective action the auditee plans to take in response to the finding: The District does not concur with the finding or questioned costs. SAO reviewed various types of documentation and chose not to accept any documentation presented by the District to even consider reducing questioned costs. The standard of documentation required by SAO to satisfy ?unmet? need in would have been hard to meet even if the District hadn?t been in the midst of a pandemic. The District has internal controls over asset inventory and provided equipment only to students and staff with unmet needs, and all costs were allowable, reasonable and necessary. We look forward to working with the FCC to resolve this finding and we appreciate the guidance that was provided by the FCC, as noted below. Guidance from the FCC Devices for remote learning could also be used at school. During the pandemic in Washington State we experienced times when classrooms, schools and or districts were closed by health department and state regulations because of outbreaks. Districts had to be prepared to support remote learning each day with constantly changing guidance on who was allowed to be in person. The following guidance from the Federal Communications Commission, titled ?Emergency Connectivity Fund Common Misconceptions?, ?Misconception #2: If schools have returned to in-class instruction for the upcoming school year, they are not eligible to participate. Answer: This is false. Equipment and services provided to students or school staff who would otherwise lack sufficient access to connected devices, and/or broadband internet access connection while off campus are eligible for Emergency Connectivity Fund Support.? From the Federal Communications Commission Order FCC-CIRC21-93-043021, question 77: ?We think schools are in the best position to determine whether their students and staff have devices and broadband services sufficient to meet their remote learning needs, and we recognize that they are making such decisions in the midst of a pandemic. We, therefore, will not impose any specific metrics or process requirements on those determinations.? And from question 51: ??we are sensitive to the need to provide some flexibility during this uncertain time. If those connected devices were purchased for the purpose of providing students?with devices for off-campus use consistent with the rules we adopt today, we will not prohibit such on-campus use.? Anticipated date to complete the corrective action: December 2023

View Audit 40833 Questioned Costs: $1

Finding 48323 (2022-003)

Significant Deficiency 2022

Central Fulton School District

PA

Reporting Subrecipient Monitoring Cash Management

Condition: The Pennsylvania Department of Revenue requires Reconciliation of Cash on Hand Quarterly Reports for any program for which they are receiving monthly payments. These quarter reports are due the 10th working days of January, April, July and October. The Pennsylvania Department of Educatio...

Condition: The Pennsylvania Department of Revenue requires Reconciliation of Cash on Hand Quarterly Reports for any program for which they are receiving monthly payments. These quarter reports are due the 10th working days of January, April, July and October. The Pennsylvania Department of Education requires annual final expenditure reports to be filed documenting the financial transactions of each grant. The final reports are due within 30 days after the funds are expended but no later than 30 days after the ending of the date of the project. Districts are required to have appropriate controls over the accuracy of preparation and timely filing of final expenditure reports. Views of Responsible Officials and Planned Corrective Actions: The District Business Manager will work with all involved in the process of the Federal Grants filing the expenditure reports quarterly and filing of the final expenditure reports. Procedures will include creating a calendar with the due dates, reporting the expenditures in the accounting software and creating a report with the expenses listed for the month and quarterly. Account numbers will be created according to the PDE accounting manual for the recording of all expenses. The person responsible for the corrective action plan will be the business manager and the anticipated completion date will be June 30, 2023.

View Audit 47859

Finding 48320 (2022-007)

Significant Deficiency 2022

City of Albuquerque

NM

Subrecipient Monitoring § 200.303 § 200.332 § 200.501

2022 ? 007 (Previously 2021-003) Subrecipient Monitoring (Significant Deficiency and Noncompliance) Management?s Progress for Repeat Findings: The City Controller reviewed the listing of subrecipient risk assessments for 2022 and the listing was determined to b...

2022 ? 007 (Previously 2021-003) Subrecipient Monitoring (Significant Deficiency and Noncompliance) Management?s Progress for Repeat Findings: The City Controller reviewed the listing of subrecipient risk assessments for 2022 and the listing was determined to be complete. The City will update the subrecipient monitoring policies and procedures ad provide training to the departments. Management Response: Management agrees with the finding. The City will develop standard City-wide subrecipient management policies and procedures including risk assessment and monitoring tools. Additionally, any federal program with two or more City departments managing subrecipients will use the same subrecipient tools to ensure consistency. Timeline and Responsible Position: June 2023 ? City Controller/DFAS Deputy Director

View Audit 48606

Finding 48316 (2022-008)

Significant Deficiency 2022

City of Albuquerque

NM

Subrecipient Monitoring Period of Performance Reporting § 200.302 § 200.303

2022 ? 008 Reporting (Significant Deficiency and Noncompliance) Management Response: The City agrees with the finding. The City will implement controls to ensure compliance with federal financi...

2022 ? 008 Reporting (Significant Deficiency and Noncompliance) Management Response: The City agrees with the finding. The City will implement controls to ensure compliance with federal financial management regulations. The City recognizes that it needs to improve its procedures for preparing quarterly report for Treasury funds. Going forward, the Family and Community Services Department will work with the Grants Section to develop and implement standardized procedures for identifying and documenting expenditures, and for reviewing quarterly reports prior to submission. Timeline and Responsible Position: June 2023 ? City Controller/DFAS Deputy Director and Director of Family & Community Services

View Audit 48606

Corrective Action Plans

Filters