Corrective Action Plans

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 48306 (2022-001)

Material Weakness 2022

Chris Properties Graham Circle, Inc.

GA

Questioned Costs Allowable Costs / Cost Principles

Finding 2022-001 ? Allowable Costs/Cost Principles (Allocation of Payroll) Type of Finding: Compliance and material weakness in internal control over compliance Corrective Action Plan: The Organization is in the process of implementing procedures around time and effort reporting with federal grants....

Finding 2022-001 ? Allowable Costs/Cost Principles (Allocation of Payroll) Type of Finding: Compliance and material weakness in internal control over compliance Corrective Action Plan: The Organization is in the process of implementing procedures around time and effort reporting with federal grants. The new process will include a formal written policy for time and effort reporting across all federal grants that will provide the required documentation that federal funds were charged only for time actually worked. The Organization will be implementing a time and effort certification process that will be completed on a quarterly basis. It will be included in our documented policies and procedures and will be completed for all employees charging time to federal grants The certifications will be signed by the employee and the supervisor.

View Audit 47524 Questioned Costs: $1

Finding 48304 (2022-001)

Significant Deficiency 2022

Mary Greeley Medical Center

IA

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

Identifying Number: 2022-001 Finding: For the Medical Center?s Period 2 reporting in the HRSA PRF reporting portal, the Medical Center inaccurately reported lost revenues, resulting in an overstatement of lost revenues. Quarterly revenues reported in the PRF reporting portal were misstated for seve...

Identifying Number: 2022-001 Finding: For the Medical Center?s Period 2 reporting in the HRSA PRF reporting portal, the Medical Center inaccurately reported lost revenues, resulting in an overstatement of lost revenues. Quarterly revenues reported in the PRF reporting portal were misstated for several quarters, resulting in a total overstatement of actual 2019 revenues of $5,197,094, a total overstatement of actual 2020 revenues of $3,996,899, and a total understatement of 2021 actual revenues of $1,915,433. The total net impact of these misstatements to the lost revenue calculation resulted in an understatement of lost revenues reported of $1,903,535. The Medical Center also reported PRF expenses in Period 2 in an amount equal to Period 2 PRF funding received. Therefore, the Medical Center did not report actual revenue data for the third or fourth quarters of 2021. The portal included $100,237,417 of third and fourth quarter 2019 actual revenues in the calculated lost revenue for 2021. While reporting of lost revenue was inaccurate, there were no questioned costs. Corrective Actions Taken or Planned: The Medical Center reported lost revenue using Option 1, comparing actual revenues for 2020 and 2021 to actual revenues for 2019. The Medical Center had errors in their formulas calculating actual revenue for the first quarter of 2019, second quarter of 2019, third quarter of 2019, and the second quarter of 2020. Additionally, the Medical Center used preliminary rather than final, audited actual revenue amounts for the second quarter of 2021. Due to the fact that Period 2 PRF expenses were equal to Period 2 PRF distributions received and lost revenue was not needed to qualify for the Period 2 PRF distributions, the Medical Center did not submit actual revenue data for the third nor fourth quarter of 2021 as the portal did not allow data entry beyond what was necessary to cover the Period 2 PRF distributions. As a result, the portal calculated a lost revenue amount for those quarters equal to actual revenues for the third quarter of 2019 and the fourth quarter of 2019. Management had previously added an additional layer of reporting review prior to submission, which includes the Chief Financial Officer, the Controller and the staff member responsible for submitting the information, which was implemented on March 24, 2022. However, this control did not detect previous formula errors. During the Period 4 reporting completed on March 28, 2023, the Controller and staff member corrected the prior formula errors and conducted a dual entry review as the information was reported into the portal. All errors, current and prior, have been corrected. Going forward, the Medical Center will implement checks to ensure that any information reported agrees to audited financial information. Anticipated completion date: March 28, 2023 Name of contact person responsible for corrective action: Gary Botine ? Vice President and Chief Financial Officer

View Audit 46078

Finding 48291 (2022-003)

Material Weakness 2022

City of Tell City

IN

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

FINDING 2022-003 Finding Subject: COVID-19 ? Coronavirus State and Local Fiscal Recovery Funds ? Reporting Summary of Finding: Material weaknesses were found related to Reporting for the COVID-19 ? Coronavirus State and Local Fiscal Recovery Funds program. Contact Person Responsible for Corrective A...

FINDING 2022-003 Finding Subject: COVID-19 ? Coronavirus State and Local Fiscal Recovery Funds ? Reporting Summary of Finding: Material weaknesses were found related to Reporting for the COVID-19 ? Coronavirus State and Local Fiscal Recovery Funds program. Contact Person Responsible for Corrective Action: Connie A Berger, Clerk-Treasurer Contact Phone Number and Email Address: 812-547-2349 clerk-treasurer@tellcity.in.gov Views of Responsible Officials: We concur with the finding. Description of Corrective Action Plan: The Corrective Action Plan will happen in 2024 when submitting information in the project and expenditure report due the US Department of the Treasury. I will have one of the Deputy Clerk-Treasurers review and check the information before I submit the information, and also have them watch when the information is submitted into the computer system. The City elected to claim all the SLFRF allocation as revenue loss. Anticipated Completion Date: The Completion Date for the Corrective Action Plan will be April 30, 2024. This is the date that the next yearly report will be due.

View Audit 42011

Finding 48278 (2022-001)

Material Weakness 2022

Franklin Community School Corporation

IN

Questioned Costs Allowable Costs / Cost Principles § 200.302 § 200.303 § 200.403

Contact Person Responsible for Corrective Action: Tina Gross Contact Phone Number: 317-945-4327 Views of Responsible Official: We concur with this finding, but would like to offer the following explanation: When ESSER funds first become available, there were no guidelines or restrictions that were m...

Contact Person Responsible for Corrective Action: Tina Gross Contact Phone Number: 317-945-4327 Views of Responsible Official: We concur with this finding, but would like to offer the following explanation: When ESSER funds first become available, there were no guidelines or restrictions that were made available. Instead, the districts were assigned swift deadlines in getting their spending plans submitted. The advice was, if you can link the request to COVID, and IDOE approves the request, then ESSER funds can be used. Months later, in an attempt to tighten things up, the school districts were presented with guidelines. This took place after all of the planning had already been done for all three grants and costs had already been incurred. The renovation cost in question was included in our spending plan submitted to IDOE through the Title Application Center. The following narrative was also submitted with the budget to IDOE as follows: ?We are also requesting $472,962.87 for a renovation project at our local Career Center, Central Nine in Greenwood. Franklin High School is one of eight sending schools for this career center. These renovations will add necessary classroom and lab space for the Diesel, Welding, and Dental programs. The renovations also include meeting space and restrooms. The total cost of Franklin Community Schools? portion of the project is estimated at $652,400, however, we are only requesting a portion of that in ESSER III funds and will cover the difference using district funds? IDOE approved the budget submitted, including this specific transaction. There was no reason for the district to think that this was an unallowable transaction. Description of Corrective Action Plan: The district is willing to transfer this expense to rainy day or operating funds if necessary. Anticipated Completion Date: 2-22-23

View Audit 40756 Questioned Costs: $1

Finding 48257 (2022-002)

Material Weakness 2022

Crawfordsville Community School Corporation

IN

Questioned Costs Subrecipient Monitoring Allowable Costs / Cost Principles § 200.303 § 200.307

FINDING 2022-002 Contact Person Responsible for Corrective Action: Andrew Nicodemus Contact Phone Number: 765-362-2342 Views of the Responsible Official: We agree with the finding. Description of Corrective Action Plan: Crawfordsville Community School Corporation plans to review all internal c...

FINDING 2022-002 Contact Person Responsible for Corrective Action: Andrew Nicodemus Contact Phone Number: 765-362-2342 Views of the Responsible Official: We agree with the finding. Description of Corrective Action Plan: Crawfordsville Community School Corporation plans to review all internal control procedures, including the control procedures over Program Income for the Child Nutrition Cluster. After this review, we will implement a system to ensure that compliance with the federal program income requirements is met. Anticipated Completion Date: We expect this Corrective Action to be implement by the end of April 2023 to allow for a full review of all internal control processes and procedures.

View Audit 49435 Questioned Costs: $1

Finding 48253 (2022-001)

Material Weakness 2022

Genoa Central School District

AR

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

Purchases of equipment and other capital outlay expenditures require the prior written approval of the Federal awarding agency or pass-through entity. (Reference #EDSD24422-001) We have been in contact with DESE for guidance and will continue to do so regarding this fund. We will implement proper i...

Purchases of equipment and other capital outlay expenditures require the prior written approval of the Federal awarding agency or pass-through entity. (Reference #EDSD24422-001) We have been in contact with DESE for guidance and will continue to do so regarding this fund. We will implement proper internal controls over program expenditures . Documentation has already been received from DESE to assist in this finding.

View Audit 48541 Questioned Costs: $1

Finding 48234 (2022-002)

Significant Deficiency 2022

Monument Health, Inc.

SD

Allowable Costs / Cost Principles Cash Management Significant Deficiency § 200.303

Finding: 2022-002 Federal Agency Name: Department of Health and Human Services Program Name: COVID-19 HRSA Claims Reimbursement for the Uninsured Program and the COVID-19 Coverage Assistance Fund Federal Financial Assistance Listing #: #93.461 Finding Summary: Audit testing identified one instance ...

Finding: 2022-002 Federal Agency Name: Department of Health and Human Services Program Name: COVID-19 HRSA Claims Reimbursement for the Uninsured Program and the COVID-19 Coverage Assistance Fund Federal Financial Assistance Listing #: #93.461 Finding Summary: Audit testing identified one instance in which health services provided to a patient were reimbursed under the federal program, and the health services provided did not meet the terms and conditions of the federal program. Through the coding process, an incorrect diagnosis code was included in the system, and therefore, the patient?s health services flowed into Monument Health?s Uninsured Program workflow which resulted in $3,563 of health services being reimbursed under the federal program. As part of the audit, a sample of 60 patients were selected for testing, accounting for $1,659,497 of $4,344,728 of monies received from the federal agency. Responsible Individuals: Austin Willuweit, Vice President of Finance Jen Schmaltz, Corporate Controller Corrective Action Plan: Monument Health will develop a review process to identify claims that could have a diagnosis coding issue. A return of any excess reimbursement will be completed. Anticipated Completion Date: June 30, 2023

View Audit 40813

Finding 48162 (2022-001)

Significant Deficiency 2022

Rock Hill School District 3

SC

Allowable Costs / Cost Principles Reporting

Finding: 2022-001 Contact Person: Terri Smith, Assistant Superintendent of Business Services, trsmith@rhmail.org Corrective Action: The District has implemented procedures to ensure that semi-annual certifications, monthly personnel activity reports, or similar supporting ...

Finding: 2022-001 Contact Person: Terri Smith, Assistant Superintendent of Business Services, trsmith@rhmail.org Corrective Action: The District has implemented procedures to ensure that semi-annual certifications, monthly personnel activity reports, or similar supporting documentation are prepared for those employees who work on a single or multiple federal awards or cost objectives. Proposed Completion Date: June 30, 2023

View Audit 50428

Finding 48131 (2022-001)

Material Weakness 2022

Los Angeles County Museum of Natural History Foundation

CA

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

In response to Finding #2022-001, the Foundation will implement two additional mitigating efforts into the existing processes and procedures to address the conditions in this finding. (1) A Missed Approval report will be generated from the payroll system to identify which hourly employee timecards h...

In response to Finding #2022-001, the Foundation will implement two additional mitigating efforts into the existing processes and procedures to address the conditions in this finding. (1) A Missed Approval report will be generated from the payroll system to identify which hourly employee timecards have not been approved after each pay period. Supervisors will be required to provide approvals on timecards of hourly employees identified in this step. (2) The Foundation will develop a time allocation form to document an after-the-fact review of any budgeted payroll costs allocated to awards to ensure they are reflective of actual time incurred. Such time allocation forms will be required on at least a quarterly basis. These steps will be in place by December 31, 2022. Implementation will be overseen and ensured by Dr. Luis Chiappe, Senior Vice President, Research & Collections, 213-763-3361.

View Audit 46323

Finding 48123 (2022-003)

Material Weakness 2022

City of Goshen

IN

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

FINDING 2022-003: COVID-19 ? Coronavirus State and Local Fiscal Recovery Funds ? Internal Controls Contact Person Responsible for Corrective Action: Clerk-Treasurer Richard Aguirre Contact Phone Number: (574) 533-8623 Views of Responsible Official: We concur with the finding. Description of Correcti...

FINDING 2022-003: COVID-19 ? Coronavirus State and Local Fiscal Recovery Funds ? Internal Controls Contact Person Responsible for Corrective Action: Clerk-Treasurer Richard Aguirre Contact Phone Number: (574) 533-8623 Views of Responsible Official: We concur with the finding. Description of Corrective Action Plan: To enhance internal controls, the City of Goshen Clerk-Treasurer?s Office has identified and segregated duties related to the preparation of the Schedule of Federal Awards (SEFA). Using the checklist from the SBOA as a reference, an internal checklist has been created to use for annual review of the policies and procedures. For this year in particular, a revisiting of the policies and procedures is necessary to address and clarify segregation of duties, both for internal and external purposes. The design, including segregation of duties, exists between the Clerk-Treasurer, Deputy Clerk-Treasurer, and the Grants Manager. However, the reporting procedures can be improved, specifically in how implementation generates verifiable proof and documentation. What is cited below is more of a ?retroactive finding? from 2021, since SBOA did not audit these funds previously. There also had been a series of difficulties with the Treasury portal; by the time the system was corrected, the reports were submitted. Regarding the procedures, the City of Goshen undertook data entry, review, and submission using three different individuals, and there is evidence of this review that has not been acknowledged by the SBOA. The review and oversight process, however, is being improved in light of this new finding. The revision of policies will more effectively articulate the steps that effect internal control and ensure consistent implementation. To ensure the accuracy of Project and Expenditure Reports prior to submission to the U.S. Department of Treasury, the preparer will email the reviewer when a report is ready for review. The reviewer will respond to the email when the information is reviewed and include any errors noted that need to be corrected. This email correspondence will be kept and provided to state auditors. The City also will maintain an approval sheet indicating that the review of the report has been completed and the reviewer will sign and date the approval sheet and note any errors found during the review. Anticipated Completion Date: This process should be reviewed and ready by the next SEFA preparation, in January 2024. ? Completed and submitted to the State Board of Accounts, Aug. 29, 2023

View Audit 41399

Finding 48116 (2022-001)

Significant Deficiency 2022

Barrow County Board of Education

GA

Questioned Costs Allowable Costs / Cost Principles Procurement, Suspension & Debarment § 200.303 § 200.318 § 200.403 § 200.404

Corrective Action Plan - FEDERAL AWARD FINDINGS AND QUESTIONED COSTS FA 2022-001 Improve Controls over Expenditures Compliance Requirement: Activities Allowed or Unallowed Allowable Costs/Cost Principles Procurement and Suspension and Debarment I...

Corrective Action Plan - FEDERAL AWARD FINDINGS AND QUESTIONED COSTS FA 2022-001 Improve Controls over Expenditures Compliance Requirement: Activities Allowed or Unallowed Allowable Costs/Cost Principles Procurement and Suspension and Debarment Internal Control Impact: Significant Deficiency Compliance Impact: Nonmaterial Noncompliance Federal Awarding Agency: U.S. Department of Education Pass-Through Entity: Georgia Department of Education Assistance Listing Number and Title: COVID-19 - 84.4250 - Elementary and Secondary School Emergency Relief Fund COVID-19 - 84.425U - American Rescue Plan Elementary And Secondary School Emergency Relief Fund Federal Award Number: S425D200012 (Year: 2020), S425D210012 (Year: 2021) S45U210012 (Year: 2021) Questioned Costs: $358,390 Repeat of Prior Year Finding: None Description: The policies and procedures of the School District were insufficient to provide adequate internal controls over expenditures as it relates to the Elementary and Secondary School Emergency Relief Fund program. Corrective Action Plans: We acknowledge this finding, however the School District relied on the advance, written approval of Georgia Department of Education Federal Programs staff that our request was a proper use of federal funds and that we had all the documentation needed for this cost to be allowable. It was pointed out to us during the audit that the contract with the custodial staff did not have the language needed to cover the bonus to our custodial contract staff in the view of the Department of Audits. The Department took this position even though both parties agreed to these payments, the Board of Education voted to approve this expenditure, the agreement was documented and the Board of Education General Counsel concluded this was permissible under the Contract. In order to accommodate the Department?s concerns, the School District will monitor contracts to ensure that all expenditures are compliant with the School District?s purchasing policies and procedures as well as compliance requirements for the ESSER program. Estimated Completion Date: May 2023 Contact Person: Jennifer Houston Telephone: 770-867-4527 Email: Jennifer.houston@barrow.k12.ga.us

View Audit 54405 Questioned Costs: $1

Finding 48112 (2022-005)

Significant Deficiency 2022

Town of Enfield, Connecticut

CT

Procurement, Suspension & Debarment Allowable Costs / Cost Principles Significant Deficiency § 200.318 § 200.326

Finding 2022-005 Reporting Significant Deficiency ? Internal Control over Compliance Other Matters (Noncompliance) Description of Finding The Town's Program Status Reports were not reviewed separate from preparer prior to submission. Statement of Concurrence or NonConcurrence Management agrees wi...

Finding 2022-005 Reporting Significant Deficiency ? Internal Control over Compliance Other Matters (Noncompliance) Description of Finding The Town's Program Status Reports were not reviewed separate from preparer prior to submission. Statement of Concurrence or NonConcurrence Management agrees with this finding. Corrective Action The Town is in process of developing a formal policy. Name of Contact Person John Wilcox Projected Completion Date June 30, 2023

View Audit 53687

Finding 48089 (2022-005)

Material Weakness 2022

Liberty-Perry Community School Corporation

IN

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

FINDING 2022-005 Contact Person Responsible for Corrective Action: Brenda Layne, Food Service Director Contact Phone Number: 765-289-7323 Views of Responsible Official: We concur with the findings Description Qf Corrective Action Plan: The prompts have been fixed on the Distribution Report, so it wi...

FINDING 2022-005 Contact Person Responsible for Corrective Action: Brenda Layne, Food Service Director Contact Phone Number: 765-289-7323 Views of Responsible Official: We concur with the findings Description Qf Corrective Action Plan: The prompts have been fixed on the Distribution Report, so it will include all Cafeteria employees. The F.S.D. will also initial each time card and Distribution Report. In the future ALL Claims will be initialed by the F.S.D. And as additional control the Superintendent will also initial all claims prior to the School Board meeting. Anticipated Completion Date: February 2023

View Audit 54302

Finding 48081 (2022-001)

Significant Deficiency 2022

Jackson Hole Land Trust

WY

Procurement, Suspension & Debarment Subrecipient Monitoring Allowable Costs / Cost Principles

Finding 2022-001 Contact person and responsible person: Derek Schaefer, Chief Financial Officer. Email address: derek@jhlandtrust.org Corrective Action Planned: As a result of the September 30, 2021 Schedule of Findings and Questioned Costs, subsequent to the month of May 2022, the Land Trust develo...

Finding 2022-001 Contact person and responsible person: Derek Schaefer, Chief Financial Officer. Email address: derek@jhlandtrust.org Corrective Action Planned: As a result of the September 30, 2021 Schedule of Findings and Questioned Costs, subsequent to the month of May 2022, the Land Trust developed a checklist of processes and procedures to guide the Land Trust through future conservation easement purchases made with federal funds. The Land Trust assigned an employee to review federal contracts and extract and summarize applicable compliance requirements. The Land Trust will continue to develop and hone these new procedures and tools. Anticipated Completion Date: Substantially completed at September 30, 2022 with ongoing adjustments.

View Audit 53099

Finding 48078 (2022-004)

Significant Deficiency 2022

Pequea Valley School District

PA

Allowable Costs / Cost Principles Reporting

#2022-004 - COVID-19 Education Stabilization Fund - AL #: 84.425D, Year Ended June 30, 2022 Criteria: The Pennsylvania Department of Education (PDE) requires the recipient of ESSER I funding to use the correct number of nonpublic low-income students that proactively affirm participation in the ESS...

#2022-004 - COVID-19 Education Stabilization Fund - AL #: 84.425D, Year Ended June 30, 2022 Criteria: The Pennsylvania Department of Education (PDE) requires the recipient of ESSER I funding to use the correct number of nonpublic low-income students that proactively affirm participation in the ESSER I grant when calculating the nonpublic schools? funding allocation. Statement of Condition: Pequea Valley School District inadvertently excluded two nonpublic students in its allocation of the nonpublic school?s calculated share of the ESSER I grant. Cause and Effect: Pequea Valley School District did not have a second level review process in place prior to submitting the nonpublic school?s allocation amount to PDE. As a result, the per pupil allocation was higher than it should have been. Questioned Costs: None over the reportable threshold. Identification of Repeat Finding: No Recommendation: Pequea Valley School District should implement a second-level review process for its submissions to grantors for funding and reporting purposes. Management Response: The School District?s Assistant Superintendent who is responsible for Federal Programs will review and certify that per pupil calculations for non-public students are recorded accurately.

View Audit 53112

Finding 48072 (2022-007)

Significant Deficiency 2022

Ucan

IL

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

Identifying Number: 2022-007 Finding: Unallowable cost-salary allocation Corrective Actions Taken or Planned: UCAN agrees with this finding and is committed to strengthening internal controls to ensure that amounts are properly reported to the funder. We believe that significant turnover in the ...

Identifying Number: 2022-007 Finding: Unallowable cost-salary allocation Corrective Actions Taken or Planned: UCAN agrees with this finding and is committed to strengthening internal controls to ensure that amounts are properly reported to the funder. We believe that significant turnover in the finance department led to this deficiency, so we are actively documenting procedures and cross-training employees. All vouchers will also go through a review process before they are sent to the funder. This is a repeat finding, with the original corrective action plan to be completed before June 30, 2023. We do believe that corrective actions that have been taken have resolved this issue. Contact person is Kimberly Parish, Chief Financial Officer and she can be reached at kim.parish@ucanchicago.org.

View Audit 53429 Questioned Costs: $1

Finding 48055 (2022-001)

Significant Deficiency 2022

Advanced Living Inc.'s Schwenckfeld Manor

PA

Questioned Costs Subrecipient Monitoring Allowable Costs / Cost Principles

We corrected the issue prior to the audit report date via a proposed journal entry. The issue identified was due to the manner in which our new payroll system's allocations were set up. Upon discovery, we corrected the setup and revised the allocation methodology. We have also committed to more thor...

We corrected the issue prior to the audit report date via a proposed journal entry. The issue identified was due to the manner in which our new payroll system's allocations were set up. Upon discovery, we corrected the setup and revised the allocation methodology. We have also committed to more thorough monitoring of our payroll allocations each payroll period during the year to ensure allocations are made in accordance with the Project's policy.

View Audit 46043 Questioned Costs: $1

Finding 48048 (2022-002)

Significant Deficiency 2022

Sonoma County Community Development Commission

CA

Subrecipient Monitoring Allowable Costs / Cost Principles Cash Management

The Sonoma County Community Development Commission submits the following corrective action plan in response to Finding 2022-002 which states, ?Emergency Solutions Grant Program.? This finding pertains to (24 CFR Section 576.203) which states, ?the recipient must pay each subrecipient for allowable c...

The Sonoma County Community Development Commission submits the following corrective action plan in response to Finding 2022-002 which states, ?Emergency Solutions Grant Program.? This finding pertains to (24 CFR Section 576.203) which states, ?the recipient must pay each subrecipient for allowable costs within 30 days after receiving the subrecipient?s complete payment request.? The Ending Homelessness Team received substantial funding to assist with the Coronavirus Pandemic. Aside from the $7M received from the Federal Government, the Homelessness Team received an additional $10M in funding for State Emergency Solutions Grant (Coronavirus) and the State?s HHAP (Homeless Housing Assistance Prevention) Program, approximately four times the amount the team processed in prior years. Despite the significant increase in funding and program needs across the County during the pandemic, the Homelessness Team?s staffing levels didn?t change. The volume of transactions increased substantially and took additional time to process check request received. In addition, all checks are processed through the County of Sonoma?s accounting functions where they are reviewed, approved, and paid. The County?s Claims Department serves the entire County. During the height of the pandemic, all departments, including the Commission, experienced significant delays in processing times at the County level. Now that the pandemic is nearing an end, the Commission expects the Homelessness Team to return to their regular funding levels which will significantly reduce processing turn times. Sincerely, Dave Kiff Interim Executive Director Sonoma County Community Development Commission

View Audit 41759

Finding 47974 (2022-001)

Significant Deficiency 2022

Colquitt County Board of Education

GA

Questioned Costs Allowable Costs / Cost Principles Procurement, Suspension & Debarment § 200.303 § 200.318 § 200.403

FA 2022-001 Improve/Strengthen Controls over Expenditures Compliance Requirement: Activities Allowed or Unallowed Allowable Costs/Cost Principle Procurement and Suspension and Debarment Internal Control Impact: Significant Deficiency Compliance Impact: Nonmaterial Noncompliance Federal Awarding ...

FA 2022-001 Improve/Strengthen Controls over Expenditures Compliance Requirement: Activities Allowed or Unallowed Allowable Costs/Cost Principle Procurement and Suspension and Debarment Internal Control Impact: Significant Deficiency Compliance Impact: Nonmaterial Noncompliance Federal Awarding Agency: U.S. Department of Education Pass-Through Entity: Georgia Department of Education Assistance Listing Number and Title: COVID-19 - 84.425D - Elementary and Secondary School Emergency Relief Fund COVID-19 - 84.425U - American Rescue Plan Elementary and Secondary School Emergency Relief Fund Federal Award Number: S425D200012 (Year: 2020), S425D210012 (Year: 2021), S425U2120012 (Year: 2021) Questioner Costs: $265,630 Description: The polices and procedures of the School District were insufficient to provide adequate internal controls over expenditures as it relates to the Elementary and Secondary School Emergency Relief Fund program. Corrective Action Plans: We concur with this finding. The process used to pay retention wages to staff has been reviewed and will only be paid to staff employed by the Colquitt County Board of Education. Estimated Completion Date: Contact Person: Jeremy Jones, CFO Telephone: 229-890-6224 Email: jeremy.jones@colquitt.k12.ga.us

View Audit 40794 Questioned Costs: $1

Finding 47958 (2022-002)

Significant Deficiency 2022

Adams Central Community Schools

IN

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

FINDING 2022-002 Information on the federal program: Subject: Special Education Cluster (IDEA) - Earmarking Federal Agency: Department of Education Federal Program: Special Education Grants to States Assistance Listing Number: 84.027 Federal Award Number: 20611-001-PN01 Pass-Through Entity: Indiana ...

FINDING 2022-002 Information on the federal program: Subject: Special Education Cluster (IDEA) - Earmarking Federal Agency: Department of Education Federal Program: Special Education Grants to States Assistance Listing Number: 84.027 Federal Award Number: 20611-001-PN01 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Matching, Level of Effort, Earmarking Audit Findings: Significant Deficiency Condition: The School Corporation is a member of the Adams Wells Special Services Cooperative (Cooperative). During fiscal year 2021-2022, the Cooperative operated the special education programs and spent the federal money on behalf of all its member schools. As the grant agreements were between the Indiana Department of Education (IDOE) and each member school, the school corporation was responsible for ensuring and providing oversight of the Cooperative. There was inadequate oversight performed by the School Corporation in order to ensure compliance with the Matching, Level of Effort, Earmarking compliance requirement. The School Corporation did not have internal controls in place to ensure that the Cooperative complied with the earmarking requirements. The Cooperative did not have adequate procedures in place to ensure that the required level of expenditures for non-public school students with disabilities was met for each member school. The Cooperative did not have effective internal controls to ensure non-public school expenditures were appropriately identified and reported. Context: The Non-Public Proportionate Share expenditures for the 20611-001-PN01 grant award could not be verified for the individual member schools. Total non-public expenditures were posted as expended. The member school proportionate share expenditures were then determined by applying a budgeted percentage to the total non-public expenditures. These were the amounts reported to IDOE. As such, we were unable to identify if the minimum amount per member school was expended and properly reported to IDOE as required. The School Corporation?s Non-Public Proportionate Share for the 20611-001- PN01 grant application was $5,368. Views of Responsible Officials: We concur with the finding. Description of Corrective Action Plan: Our corrective action plan is following the AWSSC plan of: Co-ops cannot combine proportionate share funds. Funds must be spent within each LEA?s geographic boundary. We will not receive a repeat finding for FY21. We will correct for FY22 and forward. Time & Effort Logs are being completed to show how many hours personnel are servicing Non-Pub school students with a service plan. If Materials and Equipment are purchased for a specific student?s need, per the service plan, then those expenditures are 100% school specific. Per the DOE, Materials used by our Speech Language Pathologist for Speech Therapy for all six school corporations, those expenditures are split evenly across all school corporations with a non-pub proportionate share allocation. Responsible Party and Timeline for Completion: The Superintendent and Corporation Treasurer will work with the Adams Wells Special Services Cooperative to monitor and verify those expenditures are allocated appropriately across all school corporations with a non-pub proportionate share allocation.

View Audit 52770

Finding 47939 (2022-002)

None 2022

City of Haverhill

MA

Allowable Costs / Cost Principles

CORRECTIVE ACTION PLAN Oversight Agency for Audit: U.S. Department of Education The City of Haverhill, Massachusetts respectfully submits the following corrective action plan for the year ended June 30, 2022. Name and address of independent public accounting firm: Powers & Sullivan, LLC 100...

CORRECTIVE ACTION PLAN Oversight Agency for Audit: U.S. Department of Education The City of Haverhill, Massachusetts respectfully submits the following corrective action plan for the year ended June 30, 2022. Name and address of independent public accounting firm: Powers & Sullivan, LLC 100 Quannapowitt Parkway, Suite 101 Wakefield, MA 01880 Audit period: July 1, 2021 through June 30, 2022 The finding from the June 30, 2022, schedule of findings and questioned costs is discussed below. The finding is numbered consistently with the number assigned in the schedule. FINDINGS?FEDERAL AWARD PROGRAMS AUDITS U.S. DEPARTMENT OF EDUCATION Passed through the Massachusetts Department of Elementary and Secondary Education Education Stabilization Fund Education Stabilization Fund Federal Assistance Listing No. 84.425C, 84.425D, and 84.425W 2022-002: Controls for Charging Expenditures to the Grant Compliance Requirement: Allowable Costs/Cost Principles Type of Finding: Compliance and Internal Control over Compliance ? Other Matter Criteria or Specific Requirement: Grantees must provide reasonable assurance that Federal awards are expended only for allowable activities and that the costs of goods and services charged to Federal awards are allowable and in accordance with the applicable cost principles. Condition: The City did not have an adequate process to charge expenditures to the Education Stabilization Fund program, resulting in large adjusting journal entries to record costs to the grant. The City also did not have an adequate process to maintain supporting documentation for the adjusting entries in an efficient manner that could be provided timely upon request. Questioned Costs: None reported. Context: A majority of expenditures were initially charged to the general fund upon disbursement and subsequently reclassified to the Education Stabilization Fund program via three material manual adjusting journal entries. The City was not able to provide documentation to support the manual journal entries upon request, and support was not provided until a significant amount of time after the request was made. Effect: The City is not able to promptly substantiate the allowability of costs charged to the Federal program. The risk that unallowable costs could be charged, or that accounting errors could be made and not detected and correct timely, is heightened. Cause: Lack of appropriate controls over recording expenditures to the grant and maintaining documentation for costs charged. The internal control process should include procedures to ensure that grant activity is recorded appropriately, and that adequate supporting documentation is maintained and readily available. Recommendation: Management should implement internal control procedures to ensure that expenditures are charged appropriately at the time they are initially incurred. Effective internal control procedures would mitigate the need for large manual adjusting journal entries. If adjusting journal entries are required, the City should retain adequate documentation to support the journal entries. The documentation should be filed in a manner that ensures it is easily accessible upon request. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and will implement internal control procedures to ensure that expenditures are recorded appropriately at the time they are incurred. Management will also implement procedures to ensure that, if manual adjusting entries are required, detailed supporting documentation is maintained. Management plans to implement these procedures in 2023. If the Oversight Agency has questions regarding this plan, please call Michael Pfifferling, Assistant Superintendent of Finance and Operations at 978-374-3400. Sincerely yours, Michael Pfifferling Assistant Superintendent of Finance and Operations City of Haverhill

View Audit 52314

Corrective Action Plans

Filters