Corrective Action Plans

Finding 261140 (2022-017)

Material Weakness 2022

NV

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

Finding Number: 2022-017 ? SEFA Preparation Corrective Action Plan: In 2022, the office had downsized due to turnover in staff. While a process was in place for reconciling, a secondary review was not performed to verify accuracy of the residual value calculations. To strengthen the oversight of fin...

Finding Number: 2022-017 ? SEFA Preparation Corrective Action Plan: In 2022, the office had downsized due to turnover in staff. While a process was in place for reconciling, a secondary review was not performed to verify accuracy of the residual value calculations. To strengthen the oversight of financial management in the School, Academica Nevada, the School?s management company, has filled all the open positions and realigned staff responsibilities to reduce individual workloads and provide additional oversight and review. The grant manager will reconcile all grants to ensure proper cutoff, with a secondary review performed by a member of management. Responsible Individuals: Nachum Golodner, Director of Accounting Anticipated Completion Date: June 30, 2023

View Audit 258987

Finding 261138 (2022-014)

Material Weakness 2022

Pinecrest Academy of Nevada

NV

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

Finding Number: 2022-014 ? Activities Allowed or Unallowed and Allowable Costs/Cost Principles Corrective Action Plan: A process has been put in place for the school principal to review all RFRs prior to submission to the grantor. Approval is evidenced by email sent by principal to the Director of G...

Finding Number: 2022-014 ? Activities Allowed or Unallowed and Allowable Costs/Cost Principles Corrective Action Plan: A process has been put in place for the school principal to review all RFRs prior to submission to the grantor. Approval is evidenced by email sent by principal to the Director of Grant Management, which is saved with the RFR as support. Responsible Individuals: Nachum Golodner, Director of Accounting Anticipated Completion Date: June 30, 2023

View Audit 258987

Finding 252560 (2022-002)

Significant Deficiency 2022

United Food Bank

AZ

Internal Control / Segregation of Duties Procurement, Suspension & Debarment Significant Deficiency § 200.303 § 200.318

2022-002 U.S. Department of Agriculture, Food, and Nutrition Service Emergency Food Assistance Program CFDA Number: 10.568/10.569 Passed Through: The Arizona Department of Economic Security Pass Through Number: CtR052634 Award Period: July 1, 2021 ? June 30, 2022 Condition/Context ? Internal cont...

2022-002 U.S. Department of Agriculture, Food, and Nutrition Service Emergency Food Assistance Program CFDA Number: 10.568/10.569 Passed Through: The Arizona Department of Economic Security Pass Through Number: CtR052634 Award Period: July 1, 2021 ? June 30, 2022 Condition/Context ? Internal control procedures over procurement requirements did not ensure compliance with federal awards. For 1 of 8 vendors tested, there was no documented evidence that the vendor was reviewed and approved in accordance with the Organization?s procurement policy. Contact Person ? Megan Montalvo, Chief Financial Officer Corrective Action Plan ? United Food Bank follows the set procurement policy. Quotes are obtained for all vendors who meet a certain dollar threshold. For the instance that occurred, quotes were obtained and reviewed. A meeting was held to discuss the quotes received, and it was decided to use the service of all of the vendors that quotes were obtained from, not just a single vendor. The failure occurred due to not documenting the selection of using multiple vendors for the same service on the Organization?s Vendor Selection Form. The Vendor Selection Form will be completed for all procurement services, even if multiple vendors are selected for the same type of goods or services.

View Audit 257571

Finding 252559 (2022-001)

Significant Deficiency 2022

United Food Bank

AZ

Internal Control / Segregation of Duties Subrecipient Monitoring Eligibility § 200.303

2022-001 U.S. Department of Agriculture, Food, and Nutrition Service Emergency Food Assistance Program CFDA Number: 10.568/10.569 Passed Through: The Arizona Department of Economic Security Pass Through Number: CtR052634 Award Period: July 1, 2021 ? June 30, 2022 Type of Finding ? Significant Defi...

2022-001 U.S. Department of Agriculture, Food, and Nutrition Service Emergency Food Assistance Program CFDA Number: 10.568/10.569 Passed Through: The Arizona Department of Economic Security Pass Through Number: CtR052634 Award Period: July 1, 2021 ? June 30, 2022 Type of Finding ? Significant Deficiency in Internal Control over Compliance Condition/Context ? Internal control procedures over eligibility requirements for 1 of 40 eligibility sheets tested indicated there was no certifying signature by the eligible recipient agency volunteer, and there was no evidence of secondary review by the distribution agency program officials. Contact Person ? Chariti Stern, Chief Program Officer Corrective Action Plan ? United Food Bank has entirely onboarded all TEFAP agencies to be active on Link2Feed; however, a handful of agencies still use sign-in sheets due to technology limitations. At the 2022 Agency Conference, a presentation was done that conveyed the importance of checking all signatures on United Food Bank documents. The 2022 Partner Agency Handbook explains that a signature is required for the reports and sign-in sheets to be authorized and accepted by United Food Bank. Re-training United Food Bank staff has also occurred to ensure that all reports have the correct signatures and that the United Food Bank staff?s initials are on all documents to ensure that the reports were reviewed.

View Audit 257571

Finding 195002 (2022-004)

Material Weakness 2022

South Dakota Health Care Coalition

SD

Matching / Level of Effort / Earmarking Material Weakness § 200.303

Finding: 2022-004 Federal Agency Name: Department of Health and Human Services Program Name: National Bioterrorism Hospital Preparedness Program Federal Financial Assistance Listing #93.889 Compliance Requirement: Earmarking Finding Summary: No independent secondary level of review or approval is p...

Finding: 2022-004 Federal Agency Name: Department of Health and Human Services Program Name: National Bioterrorism Hospital Preparedness Program Federal Financial Assistance Listing #93.889 Compliance Requirement: Earmarking Finding Summary: No independent secondary level of review or approval is performed relating to compliance. One employee is involved in preparing, reviewing and approving information. Additionally, no ongoing analysis is completed over comparison of actual expenditures to earmarked expenditures Responsible Individuals: Greg Santa Maria, Executive Director Corrective Action Plan: The SDHCC is working with its accounting firm to synchronize line-item coding to better ensure that expenditures are correctly coded and do not exceed maximums per line items outlined in grant contracts. The budget to actual grant expenditure comparisons will be provided to the SDHCC treasurer for review and comparison to the grant earmarking maximums. Anticipated Completion Date This is projected to be completed prior to Friday 4/28/23.

View Audit 178651

Finding 195001 (2022-003)

Material Weakness 2022

South Dakota Health Care Coalition

SD

Procurement, Suspension & Debarment § 200.303 § 200.318

Finding: 2022-003 Federal Agency Name: Department of Health and Human Services Program Name: National Bioterrorism Hospital Preparedness Program Federal Financial Assistance Listing #93.889 Compliance Requirement: Procurement, Suspension and Debarment Finding Summary: No independent secondary level...

Finding: 2022-003 Federal Agency Name: Department of Health and Human Services Program Name: National Bioterrorism Hospital Preparedness Program Federal Financial Assistance Listing #93.889 Compliance Requirement: Procurement, Suspension and Debarment Finding Summary: No independent secondary level of review or approval is performed relating to compliance. One employee is involved in preparing, reviewing and approving information. Additionally, 15 instances identified in our sample of expenditures in which the transaction exceeded the Coalition?s micro-purchase threshold, requiring a price analysis, however, the price analysis was not documented or completed. Further, the Coalition?s procurement policy does not include all the required elements as outlined in the Uniform Guidance. Lastly, five vendors were not verified against the central contractor registry prior to the expenses being incurred to ensure that the vendor was not suspended or debarred. Responsible Individuals: Greg Santa Maria, Executive Director Corrective Action Plan: The SDHCC Executive Director is currently revising the Coalition procurement policy to ensure that it appropriately reflects all elements required by the Uniform Guidance. The SDHCC Executive Director is updating the current review process to ensure that moving forward, all transactions that will exceed the Coalition?s micro purchase threshold include a documented price analysis. This will be reflected in the revised procurement policy. In an effort to ensure full compliance with vendor regulations. All outside vendors will be verified against the central contractor database before the SDHCC enters into any purchase agreements. This will be reflected in the revised SDHCC procurement policy. Anticipated Completion Date: Projected completion of procurement policy revision first draft to Board is Friday April 7, 2023

View Audit 178651

Finding 195000 (2022-002)

Material Weakness 2022

South Dakota Health Care Coalition

SD

Equipment & Real Property Management § 200.303 § 200.313

Finding: 2022-002 Federal Agency Name: Department of Health and Human Services Program Name: National Bioterrorism Hospital Preparedness Program Federal Financial Assistance Listing #93.889 Compliance Requirement: Equipment and Real Property Management Finding Summary: No independent secondary leve...

Finding: 2022-002 Federal Agency Name: Department of Health and Human Services Program Name: National Bioterrorism Hospital Preparedness Program Federal Financial Assistance Listing #93.889 Compliance Requirement: Equipment and Real Property Management Finding Summary: No independent secondary level of review or approval is performed relating to compliance. One employee is involved in preparing, reviewing and approving information. Additionally, property records lack descriptive elements as required by 2CFR 200.313(d)(1), including source of funding, acquisition date and cost. Lastly, a physical inventory of equipment has not been performed within the last two years. Responsible Individuals: Greg Santa Maria, Executive Director Corrective Action Plan: The SDHCC Executive has updated the SDHCC fixed asset listing to include recommended components listed in the findings above. This includes an updated physical inventory of all listed equipment. Anticipated Completion Date: March 16, 2023

View Audit 178651

Finding 194999 (2022-001)

Material Weakness 2022

South Dakota Health Care Coalition

SD

Allowable Costs / Cost Principles Cash Management Material Weakness § 200.303

Finding: 2022-001 Federal Agency Name: Department of Health and Human Services Program Name: National Bioterrorism Hospital Preparedness Program Federal Financial Assistance Listing #93.889 Compliance Requirement: Activities Allowed and Allowable Costs, Period of Performance, Cash Management and Rep...

Finding: 2022-001 Federal Agency Name: Department of Health and Human Services Program Name: National Bioterrorism Hospital Preparedness Program Federal Financial Assistance Listing #93.889 Compliance Requirement: Activities Allowed and Allowable Costs, Period of Performance, Cash Management and Reporting Finding Summary: No independent secondary level of review or approval is performed relating to compliance. One employee is involved in preparing, reviewing and approving information. Additionally, Internal control procedures documented within Coalition?s Grant Management Policy have not been updated since departure of the Grant Management Director. Responsible Individuals: Greg Santa Maria, Executive Director Corrective Action Plan: The SDHCC has updated its invoicing process to include an internal review of all invoices prior to submission for reimbursement by the state. Per the new process, the executive director reviews, prepares and completes the initial invoicing process. Once complete, the invoice is forwarded to the SDHCC treasurer for final review and approval prior to final submission to SD DOH. The review process is formally documented by treasurer signature on face document prior to submission to DOH. Grant management policy is currently in revision. Anticipated Completion Date: For Invoicing Process, practice was changed to reflect final review by SDHCC treasurer on January 10, 2023, beginning with BP4 Invoice number 227. Projected Grant Management policy revision first draft to Board is Friday April 7, 2023.

View Audit 178651

Finding 194991 (2022-004)

Material Weakness 2022

Southwestern Consolidated School District of Shelby County

IN

Equipment & Real Property Management Internal Control / Segregation of Duties Reporting § 200.302 § 200.303 § 200.328

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

FINDING 2022-004 Subject: COVID-19 ? Education Stabilization Fund ? Reporting, Equipment and Real Property Management Federal Agency: Department of Education Federal Program: COVID-19 ? Education Stabilization Fund Assistance Listing Number: 84.425D Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting, Equipment and Real Property Management Audit Finding: 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 the Reporting and Equipment and Real Property Management compliance requirements. 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 the Reporting compliance requirements. Reporting The School Corporation was required to submit two Annual Data Reports to the Indiana Department of Education (IDOE) to meet federal reporting requirements for ESSER grant awards. The first report was for the period of March 13, 2020 to September 30, 2020 and was due by January 21, 2021. The second report was for the period of October 1, 2020 to June 30, 2021 and was due by May 13, 2022. For both reports that were submitted, there was segregation of duties between the preparation of the report and the review and submission of the report by someone other than the preparer. However, the review was not sufficient to prevent the following error: ? In the second report, the amounts reported as expended did not agree to the underlying expenditure records of the School Corporation for ESSER I and ESSER II awards. Per discussion with the Treasurer, the amount in the report included expenditures through the report due date of May 13, 2022 rather than through the reporting period end date of June 30, 2021. This resulted in an overstatement of expenditures of $83,000 for ESSER I and $184,000 for ESSER II. Equipment and Real Property Management During our testing of equipment and real property management, it was noted that the School Corporation had not conducted a physical inventory during the last two years as required. Views of Responsible Officials and Planned Corrective Actions: We concur with the finding. Description of Corrective Action Plan: For the upcoming year 3 ESSER report that is due by April 7th, the corporation treasure will ensure that the data provided for the completion of this report only includes the correct time period information for July 1, 2021 through June 30, 2022. Southwestern superintendent, Josh Edwards, will verify the correct dates and amounts for the requested time period before submitting the report. Both the treasurer and the superintendent will review the form and sign a printed copy to be kept on file at the administration building. Inventory has in the past only been taken within certain departments. A more complete inventory will be scheduled. Southwestern superintendent, Josh Edwards, and treasurer Bonnie Thopy will research the required criteria to become compliant. Once these parameters have been established they will work within the guidelines to ensure an inventory will be completed before the next audit period. Responsible Party and Timeline for Completion: Treasurer, Bonnie Thopy, and Superintendent, Josh Edwards ? these changes will be implemented for FY2023.

View Audit 178570

Finding 194988 (2022-003)

Material Weakness 2022

Southwestern Consolidated School District of Shelby County

IN

Questioned Costs School Nutrition Programs Cash Management § 200.303

FINDING 2022-003 Subject: Child Nutrition Cluster ? Internal Controls Federal Agency: Department of Agriculture Federal Program: School Breakfast Program, National School Lunch Program Assistance Listing Numbers: 10.553, 10.555 Pass-Through Entity: Indiana Department of Education Compliance Requir...

FINDING 2022-003 Subject: Child Nutrition Cluster ? Internal Controls Federal Agency: Department of Agriculture Federal Program: School Breakfast Program, National School Lunch Program Assistance Listing Numbers: 10.553, 10.555 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: 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 the reporting compliance requirement. Context: For all four monthly claims selected for testing, there was no formal evidence of the sponsor claim reimbursement summary being reviewed by someone independent of who prepared the sponsor claim reimbursement summary prior to submission. Additionally, we noted that for one claim in the sample of four, the meal counts were overclaimed for the month. In October 2020, the School Corporation overclaimed breakfast by 43 meals and underclaimed lunch by 11 meals. Views of Responsible Officials and Planned Corrective Actions: We concur with the finding. Description of Corrective Action Plan: Food Service Director, Brisha Dunbar will verify that the numbers she pulls from E-trition match the amounts that she is claiming for reimbursement. FSD completes a daily edit check form and compares totals to the monthly E-trition report. Once the food service director has the monthly forms completed Southwestern ECA treasurer, Amber Mitchell will review and compare totals before the numbers are submitted to the State. She will initial the totals form along with the FSD and these forms will be kept on file in the FSD?s office. Responsible Party and Timeline for Completion: Food Service Director, Brisha Dunbar and ECA Treasurer, Amber Mitchell ? these changes will be implemented effective March 2023.

View Audit 178570 Questioned Costs: $1

Finding 194963 (2022-002)

Material Weakness 2022

Northern Indiana Workforce Board, Inc.

IN

Questioned Costs Allowable Costs / Cost Principles Cash Management § 200.303

Finding 2022-002: Material Weakness related to Cash Management Condition: Cash draws from WIOA Cluster and Coronavirus Relief Fund grants exceeded the amount needed to cover allowable costs. Recommendation: Management needs to work with the State of Indiana Department of Workforce Development to ref...

Finding 2022-002: Material Weakness related to Cash Management Condition: Cash draws from WIOA Cluster and Coronavirus Relief Fund grants exceeded the amount needed to cover allowable costs. Recommendation: Management needs to work with the State of Indiana Department of Workforce Development to refund the overdrawn funds or apply the funds to allowable costs in the upcoming fiscal year. Management?s Corrective Actions: Staffing changes have occurred, and the fiscal management duties have been outsourced to a third party which has experience with Workforce Boards and related grants. The new Fiscal Agent is working with IN DWD to correct these errors.

View Audit 178568 Questioned Costs: $1

Finding 194833 (2022-004)

Significant Deficiency 2022

West County Community Services

CA

Cash Management Reporting Matching / Level of Effort / Earmarking § 200.303

Finding Number: 2022-004 Finding: Emergency Rental Assistance Program Reporting. All Emergency Rental Assistance (ERA) grantees must submit monthly and quarterly reports. Monthly reports capture details specific to that month while quarterly reports contain several cumulative fields covering all act...

Finding Number: 2022-004 Finding: Emergency Rental Assistance Program Reporting. All Emergency Rental Assistance (ERA) grantees must submit monthly and quarterly reports. Monthly reports capture details specific to that month while quarterly reports contain several cumulative fields covering all activity from the date of the grant award through the quarter close. These reports provide financial and performance data regarding grantee administration of their ERA projects and capture program design in addition to program status data elements. Quarterly reports are intended to capture standard financial and performance data, as well as detailed information on qualifying direct and indirect expenditures pursuant to the government-wide Federal Funding Accountability and Transparency Act (FFATA) reporting requirements and in accordance with Section 15011 of the Coronavirus Aid, Relief, and Economic Security Act, as amended and interpreted in the U.S. Department of Treasury?s reporting and compliance guidance on Treasury.gov. The reports submitted by the Organization to the Sonoma County Community Development Commission inaccurately reported total expenditures to date due to a formula error. However, monthly expenditures reported and claimed for reimbursement were determined to be accurate. Planned Corrective Actions: The Finance Director will review and check for clerical errors on all claim forms prior to submission to the funder. A spreadsheet will be maintained which will track signoffs that indicate the review was performed. Anticipated Completion Date: Completed. Responsible Contact Person: David France, Director of Finance

View Audit 178615

Finding 98125 (2022-101)

Material Weakness 2022

Pima County

AZ

Subrecipient Monitoring § 200.303 § 200.331 § 200.332

Assistance Listings Number: Program Name: 97.024 Emergency Food and Shelter National Board Program Name of contact person: Regina Kelly, Director, Grants Management & Innovation Anticipated completion date: June 2024 Response: Pima County agrees with the finding. Pima County's federal award expen...

Assistance Listings Number: Program Name: 97.024 Emergency Food and Shelter National Board Program Name of contact person: Regina Kelly, Director, Grants Management & Innovation Anticipated completion date: June 2024 Response: Pima County agrees with the finding. Pima County's federal award expenditures have more than quadrupled since 2018, dramatically increasing the volume of subrecipients and the need for monitoring. The County recognized this challenge and procured services from a third-party entity to conduct subrecipient monitoring in the short term and assist in the development of a robust and effective subrecipient monitoring program to effectively address the rapid growth of subrecipient monitoring needs.

View Audit 94856

Finding 98117 (2022-003)

Significant Deficiency 2022

Mental Health Center of Boulder County Dba Mental Health Partners

CO

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

Federal Program Name: ? Provider Relief Fund ? ALN 93.498 Recommendation: Our auditors recommended Organization provide HRSA with their revised Lost Revenues calculation as the current eligible lost revenues reported on the PRF Period 3 report appears to be understated. Explanation of disagreemen...

Federal Program Name: ? Provider Relief Fund ? ALN 93.498 Recommendation: Our auditors recommended Organization provide HRSA with their revised Lost Revenues calculation as the current eligible lost revenues reported on the PRF Period 3 report appears to be understated. Explanation of disagreement with audit finding: There is no disagreement with the audit finding. Management?s response: Management concurs with the finding. Due to the complexity and lack of clarity on PRF reporting, the period 3 lost revenues calculation was understated. The HRSA portal is closed so Mental Health Partners is not able to provide an updated and current lost revenue report for Period 3. However, the Mental Health Partners has not received and does not anticipate receiving any additional PRF funds, so no future impact is expected or additional corrective action needed. Should additional funds be received, the CFO and Controller will adjust future reporting as needed. Name(s) of the contact person(s) responsible for corrective action: CFO and Controller Planned completion date for corrective action plan: Will implement in fiscal year 2023.

View Audit 91802

Finding 98112 (2022-002)

Significant Deficiency 2022

Mental Health Center of Boulder County Dba Mental Health Partners

CO

Period of Performance Matching / Level of Effort / Earmarking Internal Control / Segregation of Duties § 200.1 § 200.303

Federal Program Name: ? Block Grants for Community Mental Health Services ? ALN 93.243 ? Section 223 Demonstration Programs to Improve Community Mental Health Services ? ALN 93.958 Recommendation: Our auditors recommended the Organization update their method of allocating expenditures to federal a...

Federal Program Name: ? Block Grants for Community Mental Health Services ? ALN 93.243 ? Section 223 Demonstration Programs to Improve Community Mental Health Services ? ALN 93.958 Recommendation: Our auditors recommended the Organization update their method of allocating expenditures to federal awards based on the incurred date, rather than paid date. Explanation of disagreement with audit finding: There is no disagreement with the audit finding. Management?s response: Management concurs with the audit finding. As the previous process for grant salary, fringe, and indirect billings was based on salary paid date this resulted in expenses on certain grants being allocated prior to the period of performance. While this was at least in part offset by eligible grant expenses not being billed at the end of the grant period, it was not in compliance with 2 CFR 200.1 for period of performance. The CFO, supported by the Controller and Grants Manager, will immediately update the controls and grants billing processes to be based on incurred date rather than paid date. Name(s) of the contact person(s) responsible for corrective action: CFO, Controller, and Grants Manager Planned completion date for corrective action plan: Will implement in fiscal year 2023.

View Audit 91802

Finding 94088 (2022-001)

Significant Deficiency 2022

Banks County Board of Education

GA

Questioned Costs Allowable Costs / Cost Principles Subrecipient Monitoring § 200.303 § 200.403 § 200.415

FA 2022-001 Improve Controls over Federal Expenditures Compliance Requirement: Activities Allowed or Unallowed Allowable Costs/Cost Principles Internal Control Impact: Significant Deficiency Compliance Impact: Nonmaterial Noncompliance Federal...

FA 2022-001 Improve Controls over Federal Expenditures Compliance Requirement: Activities Allowed or Unallowed Allowable Costs/Cost Principles 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), S45U210012 (Year: 2021) Questioned Costs: $16,384 Repeat of Prior Year Finding: None Description: A review of expenditures charged to the Elementary and Secondary School Emergency Relief Fund program revealed instances in which expenditures had not been properly approved by the pass-through entity. Corrective Action Plans: The School District will work with all entities to confirm that all existing internal controls are adhered to by developing and implementing an improved monitoring process. This process will ensure that all expenditures are compliant with all applicable policies and regulations. Estimated Completion Date: June 30, 2023 Contact Person: Daniel Oldham Telephone: 706-677-2222 Email: Daniel.oldham@banks.k12.ga.us

View Audit 85526 Questioned Costs: $1

Finding 93898 (2022-002)

Significant Deficiency 2022

Town of Easton (the Easton Utilities Commission)

MD

Equipment & Real Property Management Internal Control / Segregation of Duties Significant Deficiency § 200.303

Rural eConnectivity Pilot Program ? Assistance Listing No. 10.752 Recommendation: We recommend the Commission formalize policies and procedures over internal controls to ensure review and approval of equipment and inventory expenditures are properly documented. Explanation of disagreement with audit...

Rural eConnectivity Pilot Program ? Assistance Listing No. 10.752 Recommendation: We recommend the Commission formalize policies and procedures over internal controls to ensure review and approval of equipment and inventory expenditures are properly documented. Explanation of disagreement with audit finding: There is no disagreement with the audit finding. Action taken in response to finding: The review of inventory requisitions will be denoted with the reviewer?s initials. The monthly equipment charges will be provided to the Supervisor of Velocity Plant Operations for review and his approval confirmed via email. Since the inception of the Rural eConnectivity program, the Commission has worked closely with representatives from the USDA to ensure compliance with the USDA?s accounting and reporting requirements. Inventory requisitions are completed by field crew and warehouse personnel, reviewed, and approved by the Supervisor of Velocity Plant Operations who reviews each and files in a binder. There is a final cursory reasonableness review by the Senior Staff Accountant. During the preparation of the USDA?s Financial Requirement Statement for reimbursement purposes, the Senior Staff Accountant and CFO review all invoices and material requisitions for proper coding. This review did not include physical signoff during the period tested. Name of the contact person responsible for corrective action: Steve J. Ochse Planned completion date for corrective action plan: April 30, 2023

View Audit 90093

Finding 90907 (2022-001)

Material Weakness 2022

Hastings College

NE

Procurement, Suspension & Debarment § 200.214 § 200.303 § 200.317 § 200.318 § 200.327

Finding 2022-01 Federal Program Title: Education Stabilization Fund ?Higher Education Emergency Relief Fund Compliance Requirement: Procurement, Suspension and Debarment Name of Contact Person: Lynn Feeken, Financial Controller Corrective Action: The College developed and implemented a procurement p...

Finding 2022-01 Federal Program Title: Education Stabilization Fund ?Higher Education Emergency Relief Fund Compliance Requirement: Procurement, Suspension and Debarment Name of Contact Person: Lynn Feeken, Financial Controller Corrective Action: The College developed and implemented a procurement policy which addressed Uniform Guidance Procurement, Suspension and Debarment requirements. Date of Completion: January 5, 2023

View Audit 71637

Finding 84725 (2022-016)

Material Weakness 2022

Scott County School District 2

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-016 Contact Person Responsible for Corrective Action: Casey Brewster Contact Phone Number: 812-752-8935 Views of Responsible Official: We concur with the finding Description of Corrective Action Plan: The approved grant budgets for all federal grants will be input into the financial man...

FINDING 2022-016 Contact Person Responsible for Corrective Action: Casey Brewster Contact Phone Number: 812-752-8935 Views of Responsible Official: We concur with the finding Description of Corrective Action Plan: The approved grant budgets for all federal grants will be input into the financial management system and with all expenditures reported monthly from the Treasurer to the Director overseeing the federal grant for review and final approval. The Director shall be one of the approvers within the approval chain of federal grant funds the Director oversees. The Director shall be responsible for reviewing and utilizing actual expenditure reports to complete the annual reports, or any other reports, prior to another documented review by the Treasurer or CFO. All documentation related to the reports shall be maintained for future audit purposes. Anticipated Completion Date: April 2023.

View Audit 90090

Finding 84724 (2022-015)

Material Weakness 2022

Scott County School District 2

IN

Equipment & Real Property Management Procurement, Suspension & Debarment Material Weakness § 200.303 § 200.313

FINDING 2022-015 Contact Person Responsible for Corrective Action: Casey Brewster Contact Phone Number: 812-752-8935 Views of Responsible Official: We concur with the finding INDIANA STATE BOARD OF ACCOUNTS 70 Description of Corrective Action Plan: The Capital Asset Ledger updated in June 2022 is be...

FINDING 2022-015 Contact Person Responsible for Corrective Action: Casey Brewster Contact Phone Number: 812-752-8935 Views of Responsible Official: We concur with the finding INDIANA STATE BOARD OF ACCOUNTS 70 Description of Corrective Action Plan: The Capital Asset Ledger updated in June 2022 is being updated and will remain up-to-date with categorization of assets to identify those assets purchased in part or in whole by federal funds. The updated capital asset ledger shall include a description, serial/id number, source of funds (federal award #) and percentage of total, cost, date, location, etc. In June of each year, this update will be completed and documented by the Treasurer and CFO. Anticipated Completion Date: June 2023.

View Audit 90090

Finding 84723 (2022-014)

Material Weakness 2022

Scott County School District 2

IN

Cash Management § 200.208 § 200.302 § 200.303 § 200.305 § 200.328

FINDING 2022-014 Contact Person Responsible for Corrective Action: Casey Brewster Contact Phone Number: 812-752-8935 Views of Responsible Official: We concur with the finding. Description of Corrective Action Plan: The approved grant budgets for all federal grants will be input into the financial ma...

FINDING 2022-014 Contact Person Responsible for Corrective Action: Casey Brewster Contact Phone Number: 812-752-8935 Views of Responsible Official: We concur with the finding. Description of Corrective Action Plan: The approved grant budgets for all federal grants will be input into the financial management system and with all expenditures reported monthly from the Treasurer to the Director overseeing the federal grant for review and final approval. The monthly reports will then be used by the Director to generate a reimbursement request for actual expenditures. The reimbursement request must then be reviewed and signed by the Treasurer or the CFO prior to submission to the State by the Director. Anticipated Completion Date: April 2023

View Audit 90090

Finding 84722 (2022-013)

Material Weakness 2022

Scott County School District 2

IN

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

FINDING 2022-013 Contact Person Responsible for Corrective Action: Casey Brewster Contact Phone Number: 812-752-8935 Views of Responsible Official: We concur with the finding Description of Corrective Action Plan: Supporting documentation and a second approval is now required within the local financ...

FINDING 2022-013 Contact Person Responsible for Corrective Action: Casey Brewster Contact Phone Number: 812-752-8935 Views of Responsible Official: We concur with the finding Description of Corrective Action Plan: Supporting documentation and a second approval is now required within the local financial management system for transfers and journal entries. Relevant notes and uploaded documents will be housed within the financial management system so future audits shall have ease of access to the documentation in order to properly test allowable activities and costs. Anticipated Completion Date: March 2023.

View Audit 90090 Questioned Costs: $1

Finding 84716 (2022-009)

Material Weakness 2022

Scott County School District 2

IN

Special Tests & Provisions Subrecipient Monitoring Material Weakness § 200.303

FINDING 2022-009 Contact Person Responsible for Corrective Action: Casey Brewster Contact Phone Number: 812-752-8935 Views of Responsible Official: We concur with the finding. Description of Corrective Action Plan: The Director of Grants/Programs will receive and review all expenditure requests from...

FINDING 2022-009 Contact Person Responsible for Corrective Action: Casey Brewster Contact Phone Number: 812-752-8935 Views of Responsible Official: We concur with the finding. Description of Corrective Action Plan: The Director of Grants/Programs will receive and review all expenditure requests from the local, private school from the Equitable Share portion of grants to ensure INDIANA STATE BOARD OF ACCOUNTS 68 the expenditure is for allowable activities and only if that occurs will it then be processed by the business office. The Director?s approval shall be documented prior to paying the invoice. In addition, the Director will review on a monthly basis all expenditure and revenue details and document that review and any notes confirming accuracy or addressing needs for correction as well as documenting the approved expenditures on the comprehensive checklist. Anticipated Completion Date: May 2023

View Audit 90090

Finding 84715 (2022-008)

Material Weakness 2022

Scott County School District 2

IN

Matching / Level of Effort / Earmarking § 200.207 § 200.208 § 200.303 § 200.400

FINDING 2022-008 Contact Person Responsible for Corrective Action: Casey Brewster Contact Phone Number: 812-752-8935 Views of Responsible Official: We concur with the finding. Description of Corrective Action Plan: Quarterly reviews of parental involvement will be included in the quarterly grant rev...

FINDING 2022-008 Contact Person Responsible for Corrective Action: Casey Brewster Contact Phone Number: 812-752-8935 Views of Responsible Official: We concur with the finding. Description of Corrective Action Plan: Quarterly reviews of parental involvement will be included in the quarterly grant reviews with the Director of Grants/Programs and the CFO. The Director will also be in engaged in IDOE provided trainings such as TitleCon, and understands the parental involvement requirements needing to be met and will monitor accordingly. In addition, the monthly reports of all revenue and expenditures shall include tracking of specific spending requirements, such as parental involvement spending. Finally, the comprehensive checklist that will be implemented will include the earmarking requirements and status. Anticipated Completion Date: May 2023

View Audit 90090

Finding 84714 (2022-007)

Material Weakness 2022

Scott County School District 2

IN

Subrecipient Monitoring Matching / Level of Effort / Earmarking Internal Control / Segregation of Duties § 200.303 § 200.333 § 200.334 § 200.77 § 200.78

FINDING 2022-007 Contact Person Responsible for Corrective Action: Kristin Nass Contact Phone Number: 812-752-8935 Views of Responsible Official: We concur with the finding. Description of Corrective Action Plan: In addition to on-going training and support of the Director of Grants/Programs who ove...

FINDING 2022-007 Contact Person Responsible for Corrective Action: Kristin Nass Contact Phone Number: 812-752-8935 Views of Responsible Official: We concur with the finding. Description of Corrective Action Plan: In addition to on-going training and support of the Director of Grants/Programs who oversees Title I, a comprehensive checklist which includes required documentation and actions (including the verified data from non-pub school) is being developed and will be implemented in the spring of 2023. Checklist completion and reviewed data will be signed off by the CFO. Anticipated Completion Date: May 2023

View Audit 90090

Corrective Action Plans

Filters