Corrective Action Plans

Finding 50106 (2022-006)

Material Weakness 2022

North Judson -- San Pierre School Corporation

IN

Equipment & Real Property Management § 200.303 § 200.313

FINDING 2022-006 Subject: COVID-19 - Education Stabilization Fund - Equipment and Real Property Management Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listing Number: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifyi...

FINDING 2022-006 Subject: COVID-19 - Education Stabilization Fund - Equipment and Real Property Management Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listing Number: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425U200013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Equipment and Real Property Management Audit Findings: Material Weakness Condition: An effective internal control system was not in place at the School Corporation in order to ensure compliance with requirements related to the grant agreement and Equipment and Real Property Management compliance requirement. Context: An effective internal control system was not in place at the School Corporation in order to ensure compliance with requirements related to the grant agreement and Equipment and Real Property Management. The School paid for chiller repairs and purchased a new air conditioning unit using education stabilization funds. These capital improvements were not added to a detailed listing of capital assets that would include a description of the property, a serial number or other identification number, the source of funding for the property (including the federal award identification number), who holds title, the acquisition date, cost of the property, percentage of federal participation in the project costs for the federal award under which the property was acquired, the location, and the use and condition of the property. In addition, a physical inventory had not been taken in the past two years. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Views of Responsible Officials and Planned Corrective Actions: We concur with the finding. Description of Corrective Action Plan: The NJ-SP School Corporation will implement internal controls to ensure that management establishes a system and maintains adequate supporting documentation to ensure compliance with the grant agreement and Equipment and Real Property Management. This will include documented summary appraisal reports annually. These controls will be implemented by July 1, 2023. Responsible Party and Timeline for Completion: Dalton C. Tunis ? Corporation Business Manager/Treasurer Anticipated Completion Date: July 1, 2023

View Audit 43779

Finding 50105 (2022-005)

Material Weakness 2022

North Judson -- San Pierre School Corporation

IN

Questioned Costs Allowable Costs / Cost Principles § 200.303 § 200.403

FINDING 2022-005 Subject: COVID-19 ? Education Stabilization Fund ? Activities Allowed or Unallowed, Allowable Costs/Cost Principles Federal Agency: Department of Education Federal Program: COVID-19 ? Education Stabilization Fund Assistance Listing Number: 84.425D, 84.425U Federal Award Numbers and...

FINDING 2022-005 Subject: COVID-19 ? Education Stabilization Fund ? Activities Allowed or Unallowed, Allowable Costs/Cost Principles Federal Agency: Department of Education Federal Program: COVID-19 ? Education Stabilization Fund Assistance Listing Number: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425U200013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Activities Allowed or Unallowed, Allowable Costs/Cost Principles Audit Findings: Material Weakness, Material Noncompliance Condition: An effective internal control system was not in place at the School Corporation to ensure compliance with the requirements related to the grant agreement and the Activities Allowed or Unallowed and Allowable Costs/Cost Principles compliance requirements. Context: (a) During allowable cost testing for vendor disbursements, we noted a portion of ARP ESSER funds were utilized to repair the chiller at the middle and high schools. The School Corporation incurred a total of approximately $284,000 in chiller repair costs between September 2021 and May 2022 and requested reimbursement for those expenditures from ARP ESSER funds in full. In October 2021, the School Corporation received an insurance claim check in the amount of $106,755 to cover a portion of the repair costs. The School Corporation did not deduct the amount received through insurance from the amount requested for reimbursement from federal funds, resulting in an overpayment of federal funds during the audit period. (b) Additionally, the School Corporation had not properly designed or implemented internal controls over recording transactions for payroll and fringe benefit disbursements to ensure the accuracy and classification of the payroll disbursements. Payroll disbursements make up approximately 45% of the program costs charged to the Education Stabilization Fund. One employee was responsible for processing payroll. Payroll reports were submitted to the School Board and Treasurer for review and approval; however, the reports only provided a total gross amount paid from each fund. The reports did not list the employees who were paid from the fund. In March 2021, the Treasurer implemented a review of the payroll distribution report, which is broken out by fund and individual employee. The lack of controls related to payroll disbursements was isolated to the 2020-2021 year. Views of Responsible Officials and Planned Corrective Actions: We concur with the finding. Description of Corrective Action Plan: The NJ-SP School Corporation will implement internal controls to ensure a system is established for when insurance claim checks are received that they are properly receipted and funds are accounted for and deducted from necessary reimbursement grants. This will give better proper oversight, reviews, and approvals over the insurance claim checks received. These controls will be implemented by July 1, 2023. The NJ-SP School Corporation will also implement internal controls to oversee that financial transactions related to receipts and payroll and fringe benefits disbursements are reviewed and verified by proper management to ensure that accuracy and documentation is in place. These controls were implemented on March, 2021. Responsible Party and Timeline for Completion: Dalton C. Tunis ? Corporation Business Manager/Treasurer Anticipated Completion Date for (b): March 2021 Anticipated Completion Date for (a): July 1, 2023

View Audit 43779 Questioned Costs: $1

Finding 50102 (2022-009)

Material Weakness 2022

North Judson -- San Pierre School Corporation

IN

Matching / Level of Effort / Earmarking § 200.303

FINDING 2022-009 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 Numbers and Years (or Other Identifying Numbers): 20611-109-PN01 Pass-Through Entity: I...

FINDING 2022-009 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 Numbers and Years (or Other Identifying Numbers): 20611-109-PN01 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Earmarking Audit Findings: Material Weakness Condition: An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the compliance requirements listed above. Context: A proportionate share of special education funds was earmarked to the local private school. The School Corporation could not provide support to substantiate that non-public services were provided. For the special education grant awards that were fully expended during the audit period, the School Corporation did not expend the minimum required amount on services for non-public students with disabilities. Views of Responsible Officials and Planned Corrective Actions: We concur with the finding. Description of Corrective Action Plan: The NJ-SP School Corporation will implement internal controls to ensure compliance with the grant agreement and the proportionate share of special education funds. A system will be established that maintains adequate supporting documentation to ensure compliance with the grant agreement and the earmarking and reporting compliance requirements of the proportionate share funds. This will give better proper oversight, reviews, and approvals over the proportionate share special education funds. These controls will be implemented by July 1, 2023. Responsible Party and Timeline for Completion: Dalton C. Tunis ? Corporation Business Manager/Treasurer Anticipated Completion Date: March 2021

View Audit 43779

Finding 50101 (2022-008)

Material Weakness 2022

North Judson -- San Pierre School Corporation

IN

Allowable Costs / Cost Principles § 200.303 § 200.403

FINDING 2022-008 Subject: Special Education Cluster (IDEA) ? Activities Allowed or Unallowed, Allowable Costs/Cost Principles Federal Agency: Department of Education Federal Program: Special Education Grants to States, Special Education Preschool Grants Assistance Listing Number: 84.027, 84.173 Fed...

FINDING 2022-008 Subject: Special Education Cluster (IDEA) ? Activities Allowed or Unallowed, Allowable Costs/Cost Principles Federal Agency: Department of Education Federal Program: Special Education Grants to States, Special Education Preschool Grants Assistance Listing Number: 84.027, 84.173 Federal Award Numbers and Years (or Other Identifying Numbers): 20611-109-PN01, 21611-109-PN01, 21619-109-PN01 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Activities Allowed or Unallowed, Allowable Costs/Cost Principles Audit Findings: Material Weakness Condition: An effective internal control system was not in place at the School Corporation to ensure compliance with the requirements related to the grant agreement and the Activities Allowed or Unallowed and Allowable Costs/Cost Principles compliance requirements. Context: The School Corporation had not properly designed or implemented internal controls over recording transactions for payroll and fringe benefit disbursements to ensure the accuracy and classification of the payroll disbursements. Payroll disbursements make up 100% of the program costs charged to the Special Education grants. One employee was responsible for processing payroll. Payroll reports were submitted to the School Board and Treasurer for review and approval; however, the reports only provided a total gross amount paid from each fund. The reports did not list the employees who were paid from the fund. In March 2021, the Treasurer implemented a review of the payroll distribution report by fund and individual employee. The lack of controls related to payroll disbursements was isolated to the 2020-2021 year. Views of Responsible Officials and Planned Corrective Actions: We concur with the finding. Description of Corrective Action Plan: The NJ-SP School Corporation will implement internal controls to oversee that financial transactions related to receipts and payroll and fringe benefits disbursements are reviewed and verified by proper management to ensure that accuracy and documentation is in place. These controls were implemented on March, 2021. Responsible Party and Timeline for Completion: Dalton C. Tunis ? Corporation Business Manager/Treasurer Anticipated Completion Date: March 2021

View Audit 43779

Finding 50097 (2022-004)

Material Weakness 2022

North Judson -- San Pierre School Corporation

IN

Allowable Costs / Cost Principles School Nutrition Programs § 200.303 § 200.403 § 200.430

FINDING 2022-004 Subject: Child Nutrition Cluster ? Activities Allowed or Unallowed, Allowable Costs/Cost Principles Federal Agency: Department of Agriculture Federal Program: School Breakfast Program, National School Lunch Program, After School Snack Program, Summer Food Service Program for Childr...

FINDING 2022-004 Subject: Child Nutrition Cluster ? Activities Allowed or Unallowed, Allowable Costs/Cost Principles Federal Agency: Department of Agriculture Federal Program: School Breakfast Program, National School Lunch Program, After School Snack Program, Summer Food Service Program for Children Assistance Listing Number: 10.553, 10.555, 10.559 Federal Award Numbers and Years (or Other Identifying Numbers): FY2021, FY2022 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Activities Allowed or Unallowed, Allowable Costs/Cost Principles Audit Findings: Material Weakness Condition: An effective internal control system was not in place at the School Corporation to ensure compliance with the requirements related to the grant agreement and the Activities Allowed or Unallowed and Allowable Costs/Cost Principles compliance requirements. Context: The School Corporation had not designed or implemented adequate internal controls to ensure that payroll disbursements were only for food service-related services. Payroll disbursements comprise approximately 45% of the program costs charged to the Child Nutrition Cluster. One employee was responsible for processing payroll. Payroll reports were submitted to the School Board and Treasurer for review and approval; however, the reports only provided a total gross amount paid from each fund. The reports did not list the employees who were paid from the fund. In March 2021, the Treasurer implemented a review of the payroll distribution report, which is broken out by fund and individual employee. The lack of controls related to payroll disbursements was isolated to the 2020-21 year. Additionally, payroll disbursements for custodial employees were allocated to the Child Nutrition Cluster based on a percentage of the custodial employees? salaries. However, there were no time and effort logs or other documentation maintained to support the percentage of the custodial salaries allocated to the Child Nutrition Cluster. The custodial salaries make up approximately 3% of the total payroll disbursements charged to the Child Nutrition Cluster. This was an issue throughout the audit period. Views of Responsible Officials and Planned Corrective Actions: We concur with the finding. Description of Corrective Action Plan: The NJ-SP School Corporation will implement internal controls to ensure compliance with the activities allowed or unallowed and allowable costs/cost principles compliance requirements. This will consist of maintaining documentation to support that payroll disbursements are only for food service operating costs by having supporting timesheets and timecards or time and effort reports for all employees paid from the School lunch fund. These controls will be implemented by July 1, 2023. Responsible Party and Timeline for Completion: Dalton C. Tunis ? Corporation Business Manager/Treasurer Anticipated Completion Date: July 1, 2023

View Audit 43779

Finding 50093 (2022-003)

Material Weakness 2022

North Daviess Community Schools

IN

Subrecipient Monitoring Material Weakness Reporting § 200.302 § 200.328

FINDING 2022-003 Information on the federal program: Subject: Education Stabilization Fund - Annual Data Report Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listing Number: 84.425C, 84.425D, 84.425U Pass-Through Entity: Indiana Dep...

FINDING 2022-003 Information on the federal program: Subject: Education Stabilization Fund - Annual Data Report Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listing Number: 84.425C, 84.425D, 84.425U Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Material Weakness Condition: The School Corporation did not have a documented review control in place to ensure the annual data report was reviewed by someone other than the preparer and that the report was submitted timely. Context: The Annual Data Report for the period of October 1, 2020 to June 30, 2021 was due to the Indiana Department of Education (IDOE) by May 13, 2022. The School Corporation submitted the report on May 16, 2022. In addition, there was no documented review by someone other than the preparer of the report to ensure the information submitted was complete and accurate. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and will take the following corrective action. Dr. Barry Stone, Director of Curriculum will prepare the Annual Data Report in a timely matter and the reports will be reviewed by Mrs. Berry, Superintendent and then signed off before submitting the report. Responsible party and timeline for completion: Federal regulation requires name and title of person overseeing corrective action plan and anticipated completion date. Dr. Barry Stone, Director of Curriculum will compile the report and Mrs. Berry, Superintendent will approve and sign off when the report is due.

View Audit 43321

Finding 50087 (2022-004)

Significant Deficiency 2022

North Daviess Community Schools

IN

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

FINDING 2022-004 Information on the federal program: Subject: Special Education Cluster - Earmarking Federal Agency: Department of Education Federal Program: Special Education Grants to States, Special Education Preschool Grants Assistance Listing Number: 84.027, 84.173 Pass-Through Entity: In...

FINDING 2022-004 Information on the federal program: Subject: Special Education Cluster - Earmarking Federal Agency: Department of Education Federal Program: Special Education Grants to States, Special Education Preschool Grants Assistance Listing Number: 84.027, 84.173 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Matching, Level of Effort, Earmarking Audit Finding: Significant Deficiency Condition and Context: The School Corporation is a member of the Daviess-Martin Special Education Cooperative (Cooperative). During fiscal year 2020-2021, 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 (!DOE) and each member school, the school corporation was responsible for ensuring and providing oversight of the Cooperative. However, 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. The Non-Public Proportionate Share expenditures for the 19611-007-PN01 and 19619-007-PN01 grant awards could not be verified for the individual member schools. Total grant expenditures were posted as expended. The non-public proportionate share expenditures were then determined by applying the budgeted percentage for non-public school expenditures to the total expenditures. These were the amounts reported to !DOE. As such, we were unable to identify if the minimum amount per the grant awards was expended and properly reported to !DOE as required. The lack of internal controls and noncompliance was isolated to the 19611-007-PN01 and 19619-007-PN01 grant awards. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and will take the following corrective action. The School Corporation will set internal controls in place to ensure that the required level of expenditures for non-public school students with disabilities was met for our school corporation. Earmarking requirements for the Matching, Level of Effort will be reviewed and reported. We have consulted with Daviess-Martin Special Education Co-Op and they have assured us additional Komputrol training has been completed on their part to ensure that we are all monitoring internal controls. Responsible party and timeline for completion: Federal regulation requires name and title of person overseeing corrective action plan and anticipated completion date. Mrs. Berry, Superintendent will work with the Daviess-Martin Special Education Co-Op to ensure our School Corporation is in compliance each school year.

View Audit 43321

Finding 50084 (2022-002)

Material Weakness 2022

North Vermillion Community School Corporation

IN

Subrecipient Monitoring Matching / Level of Effort / Earmarking Internal Control / Segregation of Duties § 200.302 § 200.303 § 200.328 § 200.329 § 200.334

FINDING 2020-002 Contact Person Responsible for Corrective Action: Shelly Harrison, Corporation Treasurer Contact Phone Number: 765-492-5102 Views of Responsible Official: We concur to the findings; however, while completing the ESSER Reports, some formatting errors of the provided spreadsheet cr...

FINDING 2020-002 Contact Person Responsible for Corrective Action: Shelly Harrison, Corporation Treasurer Contact Phone Number: 765-492-5102 Views of Responsible Official: We concur to the findings; however, while completing the ESSER Reports, some formatting errors of the provided spreadsheet created some questions by the North Vermillion officials prompting a clarification email to the DOE. Since the formatting errors were not addressed and all completed boxes on the North Vermillion ESSER Report spreadsheet turned green (indicating the correct amounts on the spreadsheet), the North Vermillion officials felt the ESSER report submitted was correct. Description of Corrective Action Plan: To correct the internal control issue, the Superintendent and Corporation Treasurer will work independently as well as collaboratively on the ESSER Reports. Prior to submitting any future report, the corporation officials will document their work by signing off and dating the report prior to submission to the DOE. To rectify the incorrect dollar amount on the Yearly ESSER Report Spreadsheet, the corporation treasurer and superintendent will work collaboratively to correct the amounts on either the ESSER I Year End Report and the ESSER II Year 2 and/or Year End Report. Anticipated Completion Date: Both the Internal Control and ESSER I corrective actions have been corrected, with the ESSER I Final Expenditure Report being completed and signed off on. The ESSER II corrective actions will be completed on the upcoming ESSER III Year End Report when that report is due.

View Audit 43320

Finding 50081 (2022-001)

Material Weakness 2022

North Vermillion Community School Corporation

IN

Procurement, Suspension & Debarment § 200.303 § 200.318 § 200.320

FINDING 2022-001 Contact Person Responsible for Corrective Action: Christy Nale Contact Phone Number: 765-492-5411 View of Responsible Official: Procurement request for milk and dairy was requested from the West Central Educational Service Center. After not receiving the bid request in a timely ...

FINDING 2022-001 Contact Person Responsible for Corrective Action: Christy Nale Contact Phone Number: 765-492-5411 View of Responsible Official: Procurement request for milk and dairy was requested from the West Central Educational Service Center. After not receiving the bid request in a timely manner, the procurement bid was received from the Wilson Education Center. The North Vermillion Community School Corporation was unaware that the Wilson Education Center was not IDOE approved in 2021. The IDOE approved cooperative list was not made available to our corporation, and not easily accessible on the IDOE School Nutrition link. Description of Corrective Action Plan: The corrective action has been made as the Wilson Education Center was approved as a Cooperative Procurement site in 2022 by the IDOE. Anticipated Completion Date: No anticipated date, the Corrective Action has already been completed.

View Audit 43320

Finding 50080 (2022-004)

Material Weakness 2022

Metropolitan School District of Shakamak

IN

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

FINDING 2022-004 Contact Person Responsible for Corrective Action: Jeff Gambill, Superintendent; Jerry Keller, Maintenance Supervisor Contact Phone Number: 812-665-3550 Views of Responsible Official: We concur with the finding. Description of Corrective Action Plan: The Superintendent and Maintenan...

FINDING 2022-004 Contact Person Responsible for Corrective Action: Jeff Gambill, Superintendent; Jerry Keller, Maintenance Supervisor Contact Phone Number: 812-665-3550 Views of Responsible Official: We concur with the finding. Description of Corrective Action Plan: The Superintendent and Maintenance Supervisor will begin reviewing all wage rates for construction contracts in excess of $2,000, to verify that the wages are not less than the prevailing wage rates, determined by the Department of Labor, to their laborers and mechanics. The Superintendent and the Maintenance Supervisor will review the prevailing wage rates listed on sam.gov. Anticipated Completion Date: Immediate review will begin of all wage rates for construction contracts in excess of $2,000.

View Audit 43315

Finding 50077 (2022-005)

Material Weakness 2022

Metropolitan School District of Shakamak

IN

Equipment & Real Property Management § 200.303 § 200.313

FINDING 2022-005 Contact Person Responsible for Corrective Action: Jeff Gambill, Superintendent; Jerry Keller, Maintenance Supervisor Contact Phone Number: 812-665-3550 Views of Responsible Official: We concur with the finding. Description of Corrective Action Plan: The Superintendent and Maintenan...

FINDING 2022-005 Contact Person Responsible for Corrective Action: Jeff Gambill, Superintendent; Jerry Keller, Maintenance Supervisor Contact Phone Number: 812-665-3550 Views of Responsible Official: We concur with the finding. Description of Corrective Action Plan: The Superintendent and Maintenance Supervisor will begin reviewing all capital asset inventories. These inventories are completed every two years, by an independent company. The Superintendent and Maintenance Supervisor will also maintain a corporation capital asset listing, updating any additions between inventories, to verify that the assets are properly accounted for on the capital asset inventory. The Superintendent and Maintenance Supervisor will add to the corporation capital asset listing, the assets that were omitted from the most recent capital asset inventory, and ensure that those assets are listed in the next capital asset inventory. Anticipated Completion Date: The Superintendent and Maintenance Supervisor will immediately begin maintaining a capital asset listing, updating any additions between inventories, as well as adding the assets that were omitted on the previous capital asset inventory.

View Audit 43315

Finding 50076 (2022-003)

Material Weakness 2022

Metropolitan School District of Shakamak

IN

Subrecipient Monitoring Matching / Level of Effort / Earmarking Internal Control / Segregation of Duties § 200.302 § 200.303 § 200.328 § 200.329 § 200.334

FINDING 2022-003 Contact Person Responsible for Corrective Action: Jeff Gambill, Superintendent; Jennifer Barcus, Corporation Treasurer. Contact Phone Number: 812-665-3550 Views of Responsible Official: We concur with the finding. Description of Corrective Action Plan: The Corporation Treasurer wil...

FINDING 2022-003 Contact Person Responsible for Corrective Action: Jeff Gambill, Superintendent; Jennifer Barcus, Corporation Treasurer. Contact Phone Number: 812-665-3550 Views of Responsible Official: We concur with the finding. Description of Corrective Action Plan: The Corporation Treasurer will begin reviewing all annual data reports completed by the Superintendent, prior to submission of the reports, to verify that all expenditures are reported in the correct reporting period. Anticipated Completion Date: Immediate review will begin of all annual data reports.

View Audit 43315

Finding 50072 (2022-005)

Significant Deficiency 2022

Frontier School Corporation

IN

Internal Control / Segregation of Duties Subrecipient Monitoring Reporting § 200.303

FINDING 2022-005 Contact Person Responsible for Corrective Action: Cortney Parrish, Corporation Treasurer Contact Phone Number: 765-240-2346 Views of Responsible Official: We agree with the finding Description of Corrective Action Plan: The School Corporation plans to have the Jr/Sr. High Sch...

FINDING 2022-005 Contact Person Responsible for Corrective Action: Cortney Parrish, Corporation Treasurer Contact Phone Number: 765-240-2346 Views of Responsible Official: We agree with the finding Description of Corrective Action Plan: The School Corporation plans to have the Jr/Sr. High School ECA Treasurer review and approve all financial data collection reports for grants prior to submission. Anticipated Completion Date: Immediately

View Audit 43314

Finding 50065 (2022-004)

Material Weakness 2022

Frontier School Corporation

IN

School Nutrition Programs Internal Control / Segregation of Duties Cash Management § 200.303

Finding 2022-004 Contact Person Responsible for Corrective Action: Rhonda Morgan, FSD Contact Phone Number: 765-240-2386 Views of Responsible Official: We concur with the finding. Description of Corrective Action Plan: Frontier School Corporation will have the Elementary and Jr/Sr High Kitchen ...

Finding 2022-004 Contact Person Responsible for Corrective Action: Rhonda Morgan, FSD Contact Phone Number: 765-240-2386 Views of Responsible Official: We concur with the finding. Description of Corrective Action Plan: Frontier School Corporation will have the Elementary and Jr/Sr High Kitchen Managers pull the monthly reports from eTrition for breakfast and lunch meals served for their respective schools. A blank Monthly Worksheet will be provided to each Kitchen Manager to be filled out using the data report from eTrition, the foodservice software. The reports and worksheets from each school will be given to the Food Service Director. The FSD will have independently prepared a complete report using data pulled from eTrition including both schools. The FSD will then compare the elementary Kitchen Manager?s report with the Master Report. The FSD will then compare the Jr/Sr High Kitchen Manager?s report with the Master Report. The Master Report will then be presented to each Kitchen Manager for their approval after checking to see that the data matches, initialing and dating the Master Report. The Food Service Director will then submit the Monthly Claims Report to CNPweb. The Corporation Treasurer will also have access to all data collected to ensure proper reportig. All data and internal checks will be filed in the Food Service Director?s office.. Anticipated Completion Date: The CAP will be in place by March 24, 2023 in preparation for the Monthly Claim of March 2023 to be the first month these internal controls will be implemented.

View Audit 43314

Finding 50064 (2022-003)

Material Weakness 2022

Frontier School Corporation

IN

Procurement, Suspension & Debarment § 200.1 § 200.303 § 200.317 § 200.318 § 200.319

Finding 2022-003 Contact Person Responsible for Corrective Action: Rhonda Morgan, FSD Contact Phone Number: 765-240-2386 Views of Responsible Official: We concur with the finding. Description of Corrective Action Plan: Procurement: Frontier School Corporation will have the Food Service Directo...

Finding 2022-003 Contact Person Responsible for Corrective Action: Rhonda Morgan, FSD Contact Phone Number: 765-240-2386 Views of Responsible Official: We concur with the finding. Description of Corrective Action Plan: Procurement: Frontier School Corporation will have the Food Service Director prepare contacts to all possible food & drink vendors asking for Vendor Bids for the following school year. Any email correspondence will be CC?d to the Corporation Treasurer and Superintendent when contacting the Vendors. A phone call log will also be kept by the Food Service Director. After receiving Vendor Bids, all Vendor Bids or Vendor Declining to Bid will be presented to the School Board for their approval. The Food Service Director will also give a recommendation at that time on who they would like to award the Vendor Bid to. After the School Board vote on Vendor Bid Awards, e-mail correspondence will be sent to all vendors with Corporation Secretary and Superintendent CC?d. All email data, phone logs, and School Board notes will be filed in the Food Service Director?s office. This internal control system will ensure compliance with the state Procurement agreements and requirements. Anticipated Completion Date: The CAP will be in place by March 24, 2023 in preparation for the Vendor Bids for the School Year 2023-2024 to be prepared and sent out in April 2023. Suspension and Debarment: Frontier School Corporation Food Service Director will check SAM Exclusions, collect a certification from that vendor, or adding a clause or condition to the covered transaction with that vendor. This information would then be kept in the Vendor?s file. Anticipated Completion Date: The CAP will be in place by March 17, 2023 in preparation for the Vendor Bids for the School Year 2023-2024 to be prepared and sent out in April 2023. The Food Service Director will have current vendors checked on SAM Exclusion or have a certification from that vendor, or adding a clause or condition to the covered transactions with the current vendors by March, 17, 2023.

View Audit 43314

Finding 50063 (2022-001)

Significant Deficiency 2022

State of North Carolina

NC

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

Subrecipients Were Not Paid Timely Department Name: Health and Human Services Contact Name / Telephone Number of Person Responsible for CAP: Joyce Massey-Smith, Director of Aging and Adult Services - (919) 855-3400 ? For any future occurrences where capacity is an issue, Division of Aging and Adult ...

Subrecipients Were Not Paid Timely Department Name: Health and Human Services Contact Name / Telephone Number of Person Responsible for CAP: Joyce Massey-Smith, Director of Aging and Adult Services - (919) 855-3400 ? For any future occurrences where capacity is an issue, Division of Aging and Adult Services (DAAS) will request additional staffing support from the Office of Opportunity and Well-Being. ? The Division of Aging and Adult Services provided funding for a temporary position to assist with processing the increase in Emergency Solutions Grant (ESG) invoices. Corrective action was completed on: January 1, 2022.

View Audit 53638

Finding 50062 (2022-007)

Significant Deficiency 2022

State of North Carolina

NC

Student Financial Aid Subrecipient Monitoring Reporting

Enrollment Status Reporting Errors Department Name: Western Piedmont Community College Contact Name / Telephone Number of Person Responsible for CAP: Dr. Tou Vang - (828) 448-3178 The Enrollment Reporting schedule in the College registrar?s office has been updated to ensure that reporting of student...

Enrollment Status Reporting Errors Department Name: Western Piedmont Community College Contact Name / Telephone Number of Person Responsible for CAP: Dr. Tou Vang - (828) 448-3178 The Enrollment Reporting schedule in the College registrar?s office has been updated to ensure that reporting of student enrollment information occurs every month. Enrollment Reports will be shared with the Financial Aid Office to confirm monthly updates in NSLDS. This procedure will ensure that the College submits all student status changes on a monthly basis. Corrective action was completed on: November 7, 2022.

View Audit 53638

Finding 50061 (2022-006)

Significant Deficiency 2022

State of North Carolina

NC

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

Enrollment Status Reporting Errors Department Name: Lenoir Community College Contact Name / Telephone Number of Person Responsible for CAP: Shelia Wiggins, Director of Financial Aid - (252) 527-6223 To correct the enrollment status reporting issues, Lenoir Community College has implemented the foll...

Enrollment Status Reporting Errors Department Name: Lenoir Community College Contact Name / Telephone Number of Person Responsible for CAP: Shelia Wiggins, Director of Financial Aid - (252) 527-6223 To correct the enrollment status reporting issues, Lenoir Community College has implemented the following corrective actions: ? The Registrar's and Financial Aid Office will develop a process to ensure that information is reported to the NSLDS through the National Student Clearinghouse on time. ? The Registrar has been given access to the NSLDS to review enrollment information and status changes reported to NSLDS through the National Student Clearinghouse for the accuracy of records. ? The Registrar has received further training on the correct workflow for updating students' withdrawal statuses. ? The Registrar and Director of Financial Aid will work cohesively to ensure that the corrective actions are effective by pulling a sample of students' changes from NSLDS and reviewing them for accuracy. ? Steps will be taken to ensure continued training and education of the Registrar's and Financial Aid Offices staff on enrollment status reporting. The steps above will allow the College to monitor compliance as it relates to Enrollment Status reporting. Anticipated Completion Date: June 30, 2023.

View Audit 53638

Finding 50060 (2022-005)

Significant Deficiency 2022

State of North Carolina

NC

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

Enrollment Status Reporting Errors Department Name: Central Piedmont Community College Contact Name / Telephone Number of Person Responsible for CAP: Richard Pucine - (704) 330-6247 On September 2, 2022, the College Registrar?s Office corrected the enrollment status for the three students identified...

Enrollment Status Reporting Errors Department Name: Central Piedmont Community College Contact Name / Telephone Number of Person Responsible for CAP: Richard Pucine - (704) 330-6247 On September 2, 2022, the College Registrar?s Office corrected the enrollment status for the three students identified during the audit with an incorrect status change. The College?s Senior Registrar is implementing an internal audit process in November to ensure all students with enrollment status changes are accurately reported to the National Student Loan Data System (NSLDS). Anticipated Completion Date: Corrective Action was partially completed on September 2, 2022. Full completion is expected in November 2022 with the implementation of the internal audit process.

View Audit 53638

Finding 50059 (2022-023)

Significant Deficiency 2022

State of North Carolina

NC

Questioned Costs Eligibility Subrecipient Monitoring

Deficiencies in the Medicaid Eligibility Determination Process Department Name: Health and Human Services Contact Name / Telephone Number of Person Responsible for CAP: Eva Fulcher - (919) 813-5343; Betty Dumas-Beasley - (919) 527-7739 The Department reviewed the errors identified in the audit and w...

Deficiencies in the Medicaid Eligibility Determination Process Department Name: Health and Human Services Contact Name / Telephone Number of Person Responsible for CAP: Eva Fulcher - (919) 813-5343; Betty Dumas-Beasley - (919) 527-7739 The Department reviewed the errors identified in the audit and will follow-up with each responsible county to correct the beneficiary record. When applicable, the Department will issue overpayment recoupment notices to the affected counties as required by state statute. Anticipated Completion Date: June 30, 2023.

View Audit 53638 Questioned Costs: $1

Finding 50058 (2022-022)

Significant Deficiency 2022

State of North Carolina

NC

Questioned Costs Procurement, Suspension & Debarment Eligibility

Errors in Medicaid Provider Billing and Payment Process Department Name: Health and Human Services Contact Name / Telephone Number of Person Responsible for CAP: Natasha Bostick-Drake - (919) 710-7891; Cathy Pace - (919) 527-7005 The Division of Health Benefits (DHB) will analyze each error identifi...

Errors in Medicaid Provider Billing and Payment Process Department Name: Health and Human Services Contact Name / Telephone Number of Person Responsible for CAP: Natasha Bostick-Drake - (919) 710-7891; Cathy Pace - (919) 527-7005 The Division of Health Benefits (DHB) will analyze each error identified in the audit and take appropriate action. A Tentative Notice of Decision (TND) will be sent to each provider to recoup any overpayment identified. Provider Education Letters will be sent to all providers with identified errors. DHB will conduct a six-month post payment review of the affected providers? fee-for-service paid claims to determine if errors are recurring. Anticipated Completion Date: December 31, 2023. DHB will work with General Dynamics Information Technology (GDIT) to update the Maternity Event billing rates that were in error for the affected time periods in NC Tracks. DHB will reprocess the claims and pay at the correct rate. DHB will review and enhance rate setting internal controls to mitigate the risk of this error recurring. Anticipated Completion Date: June 30, 2023.

View Audit 53638 Questioned Costs: $1

Finding 50047 (2022-002)

Material Weakness 2022

Glenwood Community School District

IA

Internal Control / Segregation of Duties

The District did identify the wage rate falsification matter in a timely manner. We proactively worked with legal counsel, the Iowa Auditor of State, external auditors, the Glenwood Board of Education and our software vendor to appropriately report and resolve the situation. We have requested our sc...

The District did identify the wage rate falsification matter in a timely manner. We proactively worked with legal counsel, the Iowa Auditor of State, external auditors, the Glenwood Board of Education and our software vendor to appropriately report and resolve the situation. We have requested our school accounting system vendor, Software Unlimited, to develop a wage rate change report that can be regularly reviewed. The requested report is in process of development and will be included in an upcoming software maintenance release. We have received and reviewed a pay rate change query report from Software Unlimited for the months of January 2022 to April 2022 and no exceptions were discovered. Appropriate review procedures have been established to regularly review this report in the future. We have both contacted the insurance company and legal counsel both of whom indicated that this is a School District decision that does not need approval by either of them. We will also work on revising procedures to include documentation of administrative approval of employee time cards and we do have procedures for the Board President to sign all contracts entered into by the District that comply with Chapter 291 .1 of the Code of Iowa. We have enhanced internal procedures so that procedures are in place to allow for confirmation of all required payroll filings and to ensure that the filings are timely. Our procedures now include a requirement that all W-2 filings are confirmed by two individuals at the District. In addition, we have contacted the District insurance company and informed them of the situation so that a claim can be filed if needed to cover any penalties associated with the late W-2 filing.

View Audit 53484

Finding 50046 (2022-001)

Material Weakness 2022

Glenwood Community School District

IA

Internal Control / Segregation of Duties

Compensating controls to address the segregation of duties internal control deficiency due to limited staff size have been established in these areas to obtain the maximum internal control possible under current circumstances. The District continuously reviews internal controls for opportunities to ...

Compensating controls to address the segregation of duties internal control deficiency due to limited staff size have been established in these areas to obtain the maximum internal control possible under current circumstances. The District continuously reviews internal controls for opportunities to further enhance the internal control environment.

View Audit 53484

Finding 50043 (2022-024)

Material Weakness 2022

State of Ohio

OH

Subrecipient Monitoring Reporting Material Weakness

Corrective Action Plan: Ohio EMA continues to work with the vendor (Civix/EMGrants) to modify the FFATA reporting functionality within the grant management system. Controls independent of the grant management system are in place and continue to be refined as new situations surrounding the FFATA proc...

Corrective Action Plan: Ohio EMA continues to work with the vendor (Civix/EMGrants) to modify the FFATA reporting functionality within the grant management system. Controls independent of the grant management system are in place and continue to be refined as new situations surrounding the FFATA process continue to present themselves. These controls include the monthly running of obligation reports out of the EMGrants system followed by the timely reporting of any applicable items in FSRS. Recipient-Sub-Recipient Grant Agreements have been revised to require applicants to supply us with executive compensation information required by FFATA. This information is also required in SAM.gov. However, we?ve discovered various flaws in the SAM.gov system that makes it unreliable. Lastly, we have implemented processes for documenting all known, and future unknown, flaws within the FFATA process. This will assist us with clearly showing in future audits what is and is not in our control with FFATA. It?s worth noting the majority of the timeliness errors found in the auditor?s sampling occurred prior to Ohio EMA?s implementation of its corrective action plan in SFY 2022. The items sampled after the corrective action plan implementation date did not return any timeliness errors. Anticipated Completion Date for Corrective Action: Completed Contact Person Responsible for Corrective Action: Laura Adcock, Disaster Recovery Branch Chief, Ohio Department of Public Safety 2855 West Dublin Granville Road, Columbus, Ohio 43235 Phone: 614-230-7696, E-mail Address: ladcock@dps.ohio.gov

View Audit 52604

Finding 50042 (2022-023)

Material Weakness 2022

State of Ohio

OH

Subrecipient Monitoring

Corrective Action Plan: In November 2022, the Disaster Recovery Branch (DRB) sent out audit certification forms to all applicants that received FEMA PA funds during their fiscal years 2020-2022. DRB had already sent out audit certifications in January 2020 for applicants that received FEMA PA funds...

Corrective Action Plan: In November 2022, the Disaster Recovery Branch (DRB) sent out audit certification forms to all applicants that received FEMA PA funds during their fiscal years 2020-2022. DRB had already sent out audit certifications in January 2020 for applicants that received FEMA PA funds in their fiscal years 2018-2019. The certifications were either emailed or mailed. This action is documented in a new Audit Tracking Module in EMGrants that went live in the fall of 2022. In October/November 2022, the DRB also created an Excel pivot table for all years in which FEMA PA funds were disbursed to applicants. DRB reviewed this table to identify applicants that were highly likely to have a Single Audit in 2020 or 2021 (county departments, hospitals, schools, etc.) or that had received more than $750,000 in FEMA PA funds. The DRB then searched the Federal Audit Clearinghouse (FAC) to determine whether or not Single Audits were completed for those applicants. When Single Audits were found, the audit tracking module was created to ensure the DRB reviewed those audits as well. Finally, on January 1, 2023, EMGrants automatically sent 2022 audit certifications to applicants on a January 1-December 31 fiscal year and EMGrants will automatically send 2023 audit certifications July 1, 2023 for applicants on a July 1-June 30 fiscal year. The system will continue to send these audit certifications to applicants in the coming fiscal years when they have received FEMA PA funds from DRB. Anticipated Completion Date for Corrective Action: Completed Contact Person Responsible for Corrective Action: Laura Adcock, Disaster Recovery Branch Chief, Ohio Department of Public Safety 2855 West Dublin Granville Road, Columbus, Ohio 43235 Phone: 614-230-7696, E-mail Address: ladcock@dps.ohio.gov

View Audit 52604

Corrective Action Plans

Filters