Reference Number: 2022-005 Prior Year Finding: No Federal Agency: U.S. Department of Labor State Agency: Executive Office of Labor and Workforce Development Federal Program: Unemployment Insurance, COVID-19 ? Unemployment Insurance Assistance Listing Number: 17.225 Award Number and Year: UI372292255A25 (10/1/2021 ? 12/31/2024), UI356542155A25 (10/1/2020 ? 12/31/2023) Compliance Requirement: Matching Type of Finding: Material Weakness in Internal Control Over Compliance, Material Noncompliance Criteria or specific requirement: Compliance: The state is required to provide 50 percent of the amounts paid to the majority of eligible Extended Benefits (EB) claimants (those not covered by federal law or special provisions of state law) (20 CFR sections 615.2 and 615.14(a)). Those EB amounts paid by the State Workforce Agency (SWA), and that are not the responsibility of the state, are reimbursable to the state from the Unemployment Trust Fund (UTF) (20 CFR section 615.14). The first week of EB is reimbursable to the state only if, in addition to other requirements, the state requires the first week of an individual?s benefit year to be an ?unpaid waiting week?. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in ?Standards for Internal Control in the Federal Government? issued by the Comptroller General of the United States or the ?Internal Control Integrated Framework?, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: The Executive Office of Labor and Workforce Development (the Department) was unable to provide documentation that it had provided the required 50 percent of matching funds for Extended Benefits. Context: The Department was unable to provide documentation that it provided 50 percent of the amount paid to Extended Benefits claimants nor that it had an approved federal waiver stating that the Department was not required to match these funds. Questioned costs: Undetermined. Cause: The Department?s procedures and controls were not sufficient to ensure it provided the required 50 percent match for Extended Benefits payments. Effect: The Department claimed Federal reimbursement for the State share of costs of the program. Recommendation: We recommend the Department review and enhance procedures and controls to ensure that it is in compliance with the matching requirements of the program. Views of responsible officials: Management agrees with the finding.
Reference Number: 2022-006 Prior Year Finding: No Federal Agency: U.S. Department of Labor State Agency: Executive Office of Labor and Workforce Development Federal Program: Unemployment Insurance, COVID-19 ? Unemployment Insurance Assistance Listing Number: 17.225 Award Number and Year: UI372292255A25 (10/1/2021 ? 12/31/2024), UI356542155A25 (10/1/2020 ? 12/31/2023) Compliance Requirement: Eligibility Type of Finding: Significant Deficiency in Internal Control Over Compliance, Other Matters Criteria or specific requirement: Compliance: Under state Unemployment Compensation (UC) laws, a worker?s benefit rights depend on the amount of the worker?s wages and/or weeks of work in covered employment in a ?base period.? While most states define the base period as the first four of the last five completed calendar quarters prior to the filing of the claim, other base periods may be used. To qualify for benefits, a claimant must have earned a certain amount of wages or have worked a certain number of weeks or calendar quarters within the base period or meet some combination of wage and employment requirements. Some states require a waiting period of one week of total or partial unemployment before UC is payable. A ?waiting period? is a non-compensable period of unemployment in which the worker is otherwise eligible for benefits. To be eligible to receive UC, all states provide that a claimant must have been separated from suitable work for non-disqualifying reasons under state law (i.e., not because of such acts as leaving voluntarily without good cause or discharge for misconduct connected with work). After separation, they must be able and available for work, actively seeking work, legally authorized to work in the United States and must not have refused an offer of suitable work. Executive Office of Labor and Workforce Development procedures require that a monetary determination letter be sent to each claimant upon completion of eligibility determination and the calculation of the weekly benefit amount. This letter provides the claimant with an official notification that benefits have been approved. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in ?Standards for Internal Control in the Federal Government? issued by the Comptroller General of the United States or the ?Internal Control Integrated Framework?, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: After completing eligibility determination for a claimant, the Executive Office of Labor and Workforce Development (the Department) did not send a monetary determination letter. Context: For one of sixty claimants selected for testing, the Department did not send a monetary determination letter to the claimant identifying the approved weekly benefit amount. Auditors were able to recalculate the weekly benefit amount from other sources and determined that it had been accurately calculated. Questioned costs: None noted. Cause: The Department?s procedures and controls were not sufficient to ensure it sent monetary determination letters to all claimants upon completion of eligibility determination. Effect: The Department was unable to provide documentation that it had sent a monetary determination letter to a claimant. Recommendation: We recommend the Department review and enhance procedures and controls to ensure that it sends a monetary determination letter to all claimants upon completion of eligibility determination. Views of responsible officials: Management agrees with the finding.
Reference Number: 2022-007 Prior Year Finding: 2021-009 Federal Agency: U.S. Department of Labor State Agency: Executive Office of Labor and Workforce Development Federal Program: Unemployment Insurance, COVID-19 ? Unemployment Insurance Assistance Listing Number: 17.225 Award Number and Year: UI372292255A25 (10/1/2021 ? 12/31/2024), UI356542155A25 (10/1/2020 ? 12/31/2023) Compliance Requirement: Reporting Type of Finding: Significant Deficiency in Internal Control Over Compliance, Other Matters Criteria or specific requirement: Compliance: ETA 9130, Financial Status Report, UI Programs ? This report is used to report program and administrative expenditures. All ETA grantees are required to submit quarterly financial reports for each grant award which they operate, including standard program and pilot, demonstration, and evaluation projects. Financial data is required to be reported cumulatively from grant inception through the end of each reporting period. A separate ETA 9130 is submitted for each of the following: UI, PEUC, and PUA Administration, DUA, TRA/RTAA, and UA Projects (administration and benefits). See TEGL No. 02-16 for specific and clarifying instructions about the ETA 9130. Per 9130 guidelines the report is submitted via an on-line reporting system. The report submission process is 3-steps (1) secondary contact enters in the data (2) primary contact is responsible for certifying the accuracy of the data by entering the PIN (3) DOl/ETA is responsible for reviewing the FSR, communicating with the grantee and accepting the report within 10 working days after certification. Quarterly reporting deadlines: May 15 (March end date), August 14 (June 30 end date), November 14 (September end date), February 14 (December 31 end date). Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in ?Standards for Internal Control in the Federal Government? issued by the Comptroller General of the United States or the ?Internal Control Integrated Framework?, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: ETA 9130 reports submitted by the Executive Office of Labor and Workforce Development (the Department) did not agree to supporting documentation. In addition, several reports were not submitted timely. Context: Reports for the 12/31/2021 and 6/30/2022 quarters were selected for testing, which resulted in testing eleven individual reports. The following exceptions were noted: ? For ten of eleven reports, current period and cumulative indirect expenditures were included in supporting documentation but were not included in the report. ? For three of eleven reports, the federal share of expenditures in the previous period and current period did not agree to supporting documentation. The cumulative federal share of expenditures did tie to supporting documentation. ? For one of eleven reports, the federal share of expenditures in the previous period, current period and cumulative did not agree to supporting documentation. In addition, the federal share of unliquidated obligations, total federal share of obligations and unliquidated balance of federal funds did not agree to supporting documentation. This resulted in an underreporting of the Federal share. ? Six of eleven reports were not submitted timely. The reports were submitted from one to four days late. Questioned costs: None noted, as the reporting errors did not result in an overclaim of the federal share of expenditures. Cause: The Department does not have sufficient internal controls in place over compliance of the ETA 9130 reporting process. Effect: ETA 9130 reports did not agree to supporting documentation and were submitted late. Recommendation: We recommend that policies and procedures be enhanced to ensure that financial reports are filed timely and accurately. Views of responsible officials: Management agrees with the finding.
Reference Number: 2022-008 Prior Year Finding: No Federal Agency: U.S. Department of Labor State Agency: Executive Office of Labor and Workforce Development Federal Program: Unemployment Insurance, COVID-19 ? Unemployment Insurance Assistance Listing Number: 17.225 Award Number and Year: UI372292255A25 (10/1/2021 ? 12/31/2024), UI356542155A25 (10/1/2020 ? 12/31/2023) Compliance Requirement: Special Tests and Provisions ? Match with IRS 940 FUTA Tax Form Type of Finding: Significant Deficiency in Internal Control Over Compliance, Other Matters Criteria or specific requirement: Compliance: States are required to annually certify for each taxpayer the total amount of contributions required to be paid under the state law for the calendar year and the amounts and dates of such payments in order for the taxpayer to be allowed the credit against the Federal Unemployment (FUTA) tax (26 CFR sections 31.3302(a)-3(a)). In order to accomplish this certification, states annually perform a match of employer tax payments with credit claimed for these payments on the employer?s IRS 940 FUTA tax form. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in ?Standards for Internal Control in the Federal Government? issued by the Comptroller General of the United States or the ?Internal Control Integrated Framework?, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: The Executive Office of Labor and Workforce Development (the Department) did not complete the annual match of employer tax payments with IRS 940 FUTA tax forms on a timely basis. Context: The Department initiated the annual match process, but it was not completed until after auditors requested documentation that it had been performed. Questioned costs: Undetermined. Cause: The Department?s procedures and controls were not sufficient to ensure it completed the annual FUTA tax certification process on a timely basis. Effect: Untimely annual FUTA tax certifications could result in unresolved errors in the payment of the FUTA tax and related credits taken by taxpayers. Recommendation: We recommend the Department review and enhance procedures and controls to ensure that the annual match of employer tax payments with employers? IRS 940 FUTA tax forms is completed on a timely basis. Views of responsible officials: Management agrees with the finding.
Criteria: 2 CFR 200.303 requires that non-federal entities receiving federal awards establish and maintain internal control over the federal awards that provides reasonable assurance that the non-federal entity is managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards. Condition: The University did not detect several material noncompliance due to the ineffective internal control over compliance. Questioned Costs: Not applicable
Criteria: 2 CFR 200.303 requires that non-federal entities receiving federal awards establish and maintain internal control over the federal awards that provides reasonable assurance that the non-federal entity is managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards. Condition: The University did not detect several material noncompliance due to the ineffective internal control over compliance. Questioned Costs: Not applicable
Criteria: 2 CFR 200.303 requires that non-federal entities receiving federal awards establish and maintain internal control over the federal awards that provides reasonable assurance that the non-federal entity is managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards. Condition: The University did not detect several material noncompliance due to the ineffective internal control over compliance. Questioned Costs: Not applicable
2022-001 Quarterly Reporting Type of Finding - Material Weakness in Internal Control Over Compliance Department of Health and Human Services 93.558 Temporary Assistance for Needy Families Compliance Requirement: Reporting -Criteria - 2 CFR 200.303 states that a non-Federal Entity must establish and maintain effective internal controls over the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. -Condition - EmberHope, Inc. submits status reports quarterly to the State of Kansas Department for Children and Families (KS-DCF) that provides updates on specifically established objectives as agreed to with the State of Kansas. The reports submitted were not reviewed prior to submission. -Cause - The process for submitting the quarterly status reports did not include a review of the reports for timeliness, completeness, and accuracy by somone independent of the report preparation. -Effect - EmberHope, Inc. quarterly status reports could be filed untimely and contain incomplete and/or inaccurate information. -Questioned Costs - Not applicable. -Context - During the year ended June 30, 2022, EmberHope, Inc. submitted four quarterly reports. We selected one report for detail testing and found no exceptions to our tests. -Identification as a Repeat Finding - Not applicable. -Recommendation - EmberHope, Inc. should require a review of the quarterly status reports prior to submission to KS-DCF to reduce the risk of incomplete or inaccurate information. The review should also include procedures to ensure timely submission of accurate reports. -Views of Responsible Official - EmberHope, Inc. agrees with the finding and is updating the internal control environment to include a review of the quarterly reports prior to submission.
Finding 2022-003 Information on the federal program: Subject: Education Stabilization Fund (ESSER) ? Internal Controls 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 Criteria: 2 CFR section 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following: (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in ?? 200.328 Financial reporting . . . ." 34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other responsibilities under the program." 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 requirements. Cause: The School Corporation's management had not developed a system of internal controls to ensure compliance with the compliance requirements listed above. Effect: The failure to establish an effective internal control system placed the School Corporation at risk of noncompliance with the grant agreement and the compliance requirements. A lack of segregation of duties within an internal control system could have also allowed noncompliance with the compliance requirements and allowed the misuse and mismanagement of federal funds and assets by not having proper oversight, reviews, and approvals over the activities of the programs. Questioned Costs: There were no questioned costs identified. Context: 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 and GEER 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. We noted the amounts reported as expended ($0) on both reports did not agree to the amounts expended per the underlying expenditure records, $32,108 for the first report time period and $28,300 for the second report time period of the School Corporation. Additionally, we noted the for both reports that were submitted, there was no documented review by someone other than the preparer of the report to ensure the information submitted was complete and accurate. Identification as a repeat finding: No. Recommendation: We recommend someone other than the preparer of the report perform a documented review prior to submission to validate the accuracy and completeness of the data submitted. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
Finding 2022-003 Information on the federal program: Subject: Education Stabilization Fund (ESSER) ? Internal Controls 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 Criteria: 2 CFR section 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following: (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in ?? 200.328 Financial reporting . . . ." 34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other responsibilities under the program." 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 requirements. Cause: The School Corporation's management had not developed a system of internal controls to ensure compliance with the compliance requirements listed above. Effect: The failure to establish an effective internal control system placed the School Corporation at risk of noncompliance with the grant agreement and the compliance requirements. A lack of segregation of duties within an internal control system could have also allowed noncompliance with the compliance requirements and allowed the misuse and mismanagement of federal funds and assets by not having proper oversight, reviews, and approvals over the activities of the programs. Questioned Costs: There were no questioned costs identified. Context: 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 and GEER 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. We noted the amounts reported as expended ($0) on both reports did not agree to the amounts expended per the underlying expenditure records, $32,108 for the first report time period and $28,300 for the second report time period of the School Corporation. Additionally, we noted the for both reports that were submitted, there was no documented review by someone other than the preparer of the report to ensure the information submitted was complete and accurate. Identification as a repeat finding: No. Recommendation: We recommend someone other than the preparer of the report perform a documented review prior to submission to validate the accuracy and completeness of the data submitted. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
Finding 2022-003 Information on the federal program: Subject: Education Stabilization Fund (ESSER) ? Internal Controls 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 Criteria: 2 CFR section 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following: (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in ?? 200.328 Financial reporting . . . ." 34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other responsibilities under the program." 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 requirements. Cause: The School Corporation's management had not developed a system of internal controls to ensure compliance with the compliance requirements listed above. Effect: The failure to establish an effective internal control system placed the School Corporation at risk of noncompliance with the grant agreement and the compliance requirements. A lack of segregation of duties within an internal control system could have also allowed noncompliance with the compliance requirements and allowed the misuse and mismanagement of federal funds and assets by not having proper oversight, reviews, and approvals over the activities of the programs. Questioned Costs: There were no questioned costs identified. Context: 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 and GEER 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. We noted the amounts reported as expended ($0) on both reports did not agree to the amounts expended per the underlying expenditure records, $32,108 for the first report time period and $28,300 for the second report time period of the School Corporation. Additionally, we noted the for both reports that were submitted, there was no documented review by someone other than the preparer of the report to ensure the information submitted was complete and accurate. Identification as a repeat finding: No. Recommendation: We recommend someone other than the preparer of the report perform a documented review prior to submission to validate the accuracy and completeness of the data submitted. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
Finding 2022-003 Information on the federal program: Subject: Education Stabilization Fund (ESSER) ? Internal Controls 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 Criteria: 2 CFR section 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following: (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in ?? 200.328 Financial reporting . . . ." 34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other responsibilities under the program." 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 requirements. Cause: The School Corporation's management had not developed a system of internal controls to ensure compliance with the compliance requirements listed above. Effect: The failure to establish an effective internal control system placed the School Corporation at risk of noncompliance with the grant agreement and the compliance requirements. A lack of segregation of duties within an internal control system could have also allowed noncompliance with the compliance requirements and allowed the misuse and mismanagement of federal funds and assets by not having proper oversight, reviews, and approvals over the activities of the programs. Questioned Costs: There were no questioned costs identified. Context: 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 and GEER 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. We noted the amounts reported as expended ($0) on both reports did not agree to the amounts expended per the underlying expenditure records, $32,108 for the first report time period and $28,300 for the second report time period of the School Corporation. Additionally, we noted the for both reports that were submitted, there was no documented review by someone other than the preparer of the report to ensure the information submitted was complete and accurate. Identification as a repeat finding: No. Recommendation: We recommend someone other than the preparer of the report perform a documented review prior to submission to validate the accuracy and completeness of the data submitted. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
FINDING 2022-003 Information on the federal program: Subject: Child Nutrition Cluster ? Reporting Federal Agency: Department of Education Federal Program: School Breakfast Program, National School Lunch Program Assistance Listing Number: 10.553, 10.555, 10.559 Federal Award Number and Year (or Other Identifying Numbers): FY2021, FY2022 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Significant Deficiency Criteria: 2 CFR section 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO) " 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. Cause: The School Corporation's management had not developed a system of internal controls to ensure compliance with the reporting requirements. Effect: The failure to establish an effective internal control system placed the School Corporation at risk of noncompliance with the grant agreement and the compliance requirements. A lack of segregation of duties within an internal control system could have also allowed noncompliance with the compliance requirements and allowed the misuse and mismanagement of federal funds and assets by not having proper oversight, reviews, and approvals over the activities of the programs. Questioned Costs: There were no questioned costs identified. Context: We noted that for one sponsor claim reimbursement in a sample of four claims, the Food Service Director prepared the sponsor claim reimbursement summary without a secondary, documented review before the submission of the claim to ensure the accuracy of the sponsor claim reimbursement summary. Identification as a repeat finding, if applicable: No. Recommendation: We recommended that the School Corporation implement a documented, formal review of the claims before they are submitted for reimbursement. Views of Responsible Officials and Planned Corrective Actions: For the views of the responsible officials, refer to the Corrective Action Plan that is part of this report.
Finding 2022-004 Subject: Child Nutrition Cluster ? Internal Controls Federal Agency: Department of Agriculture Federal Program: School Breakfast Program, National School Lunch Program, Summer Food Service Program for Children Assistance Listing Number: 10.533, 10.555, 10.559 Federal Award Number and Year (or Other Identifying Numbers): FY2021, FY2022 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Procurement and Suspension and Debarment Audit Finding: Significant Deficiency Criteria: 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO) " 2 CFR 180.300 states: "When you enter into a covered transaction with another person at the next lower tier, you must verify that the person with whom you intend to do business is not excluded or disqualified. You do this by: (a) Checking the SAM Exclusions; or (b) Collecting a certification from that person; or (c) Adding a clause or condition to the covered transaction with that person." Condition: An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the Child Nutrition Program and Procurement and Suspension and Debarment compliance requirements. Cause: The School Corporation's management had not developed a system of internal controls that would have ensured compliance with the Procurement and Suspension and Debarment compliance requirement. Effect: The failure to establish internal controls enabled noncompliance to go undetected. The failure to comply with the grant agreement and the compliance requirement could have resulted in the loss of federal funds to the School Corporation. Questioned Costs: There were no questioned costs identified. Context: For one of our procurement selections, out of a sample of two, the School Corporation was not able to provide verification that the vendor was not suspended or debarred. Identification as a repeat finding, if applicable: No. Recommendation: We recommend that the School Corporation's management establish and implement control procedures to ensure compliance with the grant agreement and the Procurement and Suspension and Debarment compliance requirement. This should include ensuring suspension and debarment checks are performed and documented prior to entering into the transaction. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
FINDING 2022-003 Information on the federal program: Subject: Child Nutrition Cluster ? Reporting Federal Agency: Department of Education Federal Program: School Breakfast Program, National School Lunch Program Assistance Listing Number: 10.553, 10.555, 10.559 Federal Award Number and Year (or Other Identifying Numbers): FY2021, FY2022 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Significant Deficiency Criteria: 2 CFR section 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO) " 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. Cause: The School Corporation's management had not developed a system of internal controls to ensure compliance with the reporting requirements. Effect: The failure to establish an effective internal control system placed the School Corporation at risk of noncompliance with the grant agreement and the compliance requirements. A lack of segregation of duties within an internal control system could have also allowed noncompliance with the compliance requirements and allowed the misuse and mismanagement of federal funds and assets by not having proper oversight, reviews, and approvals over the activities of the programs. Questioned Costs: There were no questioned costs identified. Context: We noted that for one sponsor claim reimbursement in a sample of four claims, the Food Service Director prepared the sponsor claim reimbursement summary without a secondary, documented review before the submission of the claim to ensure the accuracy of the sponsor claim reimbursement summary. Identification as a repeat finding, if applicable: No. Recommendation: We recommended that the School Corporation implement a documented, formal review of the claims before they are submitted for reimbursement. Views of Responsible Officials and Planned Corrective Actions: For the views of the responsible officials, refer to the Corrective Action Plan that is part of this report.
Finding 2022-004 Subject: Child Nutrition Cluster ? Internal Controls Federal Agency: Department of Agriculture Federal Program: School Breakfast Program, National School Lunch Program, Summer Food Service Program for Children Assistance Listing Number: 10.533, 10.555, 10.559 Federal Award Number and Year (or Other Identifying Numbers): FY2021, FY2022 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Procurement and Suspension and Debarment Audit Finding: Significant Deficiency Criteria: 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO) " 2 CFR 180.300 states: "When you enter into a covered transaction with another person at the next lower tier, you must verify that the person with whom you intend to do business is not excluded or disqualified. You do this by: (a) Checking the SAM Exclusions; or (b) Collecting a certification from that person; or (c) Adding a clause or condition to the covered transaction with that person." Condition: An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the Child Nutrition Program and Procurement and Suspension and Debarment compliance requirements. Cause: The School Corporation's management had not developed a system of internal controls that would have ensured compliance with the Procurement and Suspension and Debarment compliance requirement. Effect: The failure to establish internal controls enabled noncompliance to go undetected. The failure to comply with the grant agreement and the compliance requirement could have resulted in the loss of federal funds to the School Corporation. Questioned Costs: There were no questioned costs identified. Context: For one of our procurement selections, out of a sample of two, the School Corporation was not able to provide verification that the vendor was not suspended or debarred. Identification as a repeat finding, if applicable: No. Recommendation: We recommend that the School Corporation's management establish and implement control procedures to ensure compliance with the grant agreement and the Procurement and Suspension and Debarment compliance requirement. This should include ensuring suspension and debarment checks are performed and documented prior to entering into the transaction. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
FINDING 2022-003 Information on the federal program: Subject: Child Nutrition Cluster ? Reporting Federal Agency: Department of Education Federal Program: School Breakfast Program, National School Lunch Program Assistance Listing Number: 10.553, 10.555, 10.559 Federal Award Number and Year (or Other Identifying Numbers): FY2021, FY2022 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Significant Deficiency Criteria: 2 CFR section 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO) " 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. Cause: The School Corporation's management had not developed a system of internal controls to ensure compliance with the reporting requirements. Effect: The failure to establish an effective internal control system placed the School Corporation at risk of noncompliance with the grant agreement and the compliance requirements. A lack of segregation of duties within an internal control system could have also allowed noncompliance with the compliance requirements and allowed the misuse and mismanagement of federal funds and assets by not having proper oversight, reviews, and approvals over the activities of the programs. Questioned Costs: There were no questioned costs identified. Context: We noted that for one sponsor claim reimbursement in a sample of four claims, the Food Service Director prepared the sponsor claim reimbursement summary without a secondary, documented review before the submission of the claim to ensure the accuracy of the sponsor claim reimbursement summary. Identification as a repeat finding, if applicable: No. Recommendation: We recommended that the School Corporation implement a documented, formal review of the claims before they are submitted for reimbursement. Views of Responsible Officials and Planned Corrective Actions: For the views of the responsible officials, refer to the Corrective Action Plan that is part of this report.
Finding 2022-004 Subject: Child Nutrition Cluster ? Internal Controls Federal Agency: Department of Agriculture Federal Program: School Breakfast Program, National School Lunch Program, Summer Food Service Program for Children Assistance Listing Number: 10.533, 10.555, 10.559 Federal Award Number and Year (or Other Identifying Numbers): FY2021, FY2022 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Procurement and Suspension and Debarment Audit Finding: Significant Deficiency Criteria: 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO) " 2 CFR 180.300 states: "When you enter into a covered transaction with another person at the next lower tier, you must verify that the person with whom you intend to do business is not excluded or disqualified. You do this by: (a) Checking the SAM Exclusions; or (b) Collecting a certification from that person; or (c) Adding a clause or condition to the covered transaction with that person." Condition: An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the Child Nutrition Program and Procurement and Suspension and Debarment compliance requirements. Cause: The School Corporation's management had not developed a system of internal controls that would have ensured compliance with the Procurement and Suspension and Debarment compliance requirement. Effect: The failure to establish internal controls enabled noncompliance to go undetected. The failure to comply with the grant agreement and the compliance requirement could have resulted in the loss of federal funds to the School Corporation. Questioned Costs: There were no questioned costs identified. Context: For one of our procurement selections, out of a sample of two, the School Corporation was not able to provide verification that the vendor was not suspended or debarred. Identification as a repeat finding, if applicable: No. Recommendation: We recommend that the School Corporation's management establish and implement control procedures to ensure compliance with the grant agreement and the Procurement and Suspension and Debarment compliance requirement. This should include ensuring suspension and debarment checks are performed and documented prior to entering into the transaction. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
FINDING 2022-003 Information on the federal program: Subject: Child Nutrition Cluster ? Reporting Federal Agency: Department of Education Federal Program: School Breakfast Program, National School Lunch Program Assistance Listing Number: 10.553, 10.555, 10.559 Federal Award Number and Year (or Other Identifying Numbers): FY2021, FY2022 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Significant Deficiency Criteria: 2 CFR section 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO) " 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. Cause: The School Corporation's management had not developed a system of internal controls to ensure compliance with the reporting requirements. Effect: The failure to establish an effective internal control system placed the School Corporation at risk of noncompliance with the grant agreement and the compliance requirements. A lack of segregation of duties within an internal control system could have also allowed noncompliance with the compliance requirements and allowed the misuse and mismanagement of federal funds and assets by not having proper oversight, reviews, and approvals over the activities of the programs. Questioned Costs: There were no questioned costs identified. Context: We noted that for one sponsor claim reimbursement in a sample of four claims, the Food Service Director prepared the sponsor claim reimbursement summary without a secondary, documented review before the submission of the claim to ensure the accuracy of the sponsor claim reimbursement summary. Identification as a repeat finding, if applicable: No. Recommendation: We recommended that the School Corporation implement a documented, formal review of the claims before they are submitted for reimbursement. Views of Responsible Officials and Planned Corrective Actions: For the views of the responsible officials, refer to the Corrective Action Plan that is part of this report.
Finding 2022-004 Subject: Child Nutrition Cluster ? Internal Controls Federal Agency: Department of Agriculture Federal Program: School Breakfast Program, National School Lunch Program, Summer Food Service Program for Children Assistance Listing Number: 10.533, 10.555, 10.559 Federal Award Number and Year (or Other Identifying Numbers): FY2021, FY2022 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Procurement and Suspension and Debarment Audit Finding: Significant Deficiency Criteria: 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO) " 2 CFR 180.300 states: "When you enter into a covered transaction with another person at the next lower tier, you must verify that the person with whom you intend to do business is not excluded or disqualified. You do this by: (a) Checking the SAM Exclusions; or (b) Collecting a certification from that person; or (c) Adding a clause or condition to the covered transaction with that person." Condition: An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the Child Nutrition Program and Procurement and Suspension and Debarment compliance requirements. Cause: The School Corporation's management had not developed a system of internal controls that would have ensured compliance with the Procurement and Suspension and Debarment compliance requirement. Effect: The failure to establish internal controls enabled noncompliance to go undetected. The failure to comply with the grant agreement and the compliance requirement could have resulted in the loss of federal funds to the School Corporation. Questioned Costs: There were no questioned costs identified. Context: For one of our procurement selections, out of a sample of two, the School Corporation was not able to provide verification that the vendor was not suspended or debarred. Identification as a repeat finding, if applicable: No. Recommendation: We recommend that the School Corporation's management establish and implement control procedures to ensure compliance with the grant agreement and the Procurement and Suspension and Debarment compliance requirement. This should include ensuring suspension and debarment checks are performed and documented prior to entering into the transaction. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
FINDING 2022-002 Subject: Special Education Cluster - Earmarking Federal Agency: Department of Education Federal Program: Special Education Grants to States, Special Education Preschool Grants Assistance Listings Numbers: 84.027, 84.173 Federal Award Number and Year (or Other Identifying Numbers): 20611-042-PN01, 21611-042-PN01 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Matching, Level of Effort, Earmarking Audit Finding: Significant Deficiency Criteria: 2 CFR 200.303 states in part: "The non-Federal entity must: (a)Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO)...." 2 CFR 200.403 states in part: "Except where otherwise authorized by statute, costs must meet the following general criteria in order to be allowable under Federal awards: ? (g) Be adequately documented.... " 2 CFR 200.208(b) states in part: "The Federal awarding agency or pass-through entity may adjust specific Federal award conditions as needed . . ." 511 IAC 7-34-7(b) states: "The public agency, in providing special education and related services to students in nonpublic schools must expend at least an amount that is the same proportion of the public agency total subgrant under 20 U.S.C. 1411(f) as the number of nonpublic school students with disabilities, who are enrolled by their parents in nonpublic schools within its boundaries, is to the total number of students with disabilities of the same age range." Condition: 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 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. Cause: The School Corporation's management had not developed an effective system of internal controls that would have ensured compliance with the grant agreement and the earmarking requirements of the Matching, Level of Effort, Earmarking compliance requirement. Effect: The failure to establish an effective internal control system, as well as adequately document costs of federal awards, prevented the determination of the School Corporation's compliance with the earmarking requirements of the Matching, Level of Effort, Earmarking compliance requirement. Questioned Costs: There were no questioned costs identified. Context: The School Corporation is a member of the Northeast Indiana Special Education Cooperative (Cooperative). During fiscal year 2021-2022, the Cooperative operated the special education programs and spent the federal money on behalf of all its members. 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. 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 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-042-PN01, 20611-042-PN01, and 21611-042-PN01 grant awards could not be verified for the individual schools to verify the minimum amount per the grant awards was expended and properly reported to IDOE as required. The lack of internal controls and noncompliance were isolated to the 20611-042-PN01 and 21611-042-PN01 grant awards. The minimum proportionate share earmarking amount was $3,483 and $3,429 for the 20611-042-PN01 and 21611-042-PN01 grant awards, respectively. Identification as a repeat finding: No. Recommendation: We recommended that the School Corporation's management establish a system of internal controls, as well as appropriately document and identify federal award expenditures to ensure compliance with the Matching, Level of Effort, Earmarking compliance requirement. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
FINDING 2022-002 Subject: Special Education Cluster - Earmarking Federal Agency: Department of Education Federal Program: Special Education Grants to States, Special Education Preschool Grants Assistance Listings Numbers: 84.027, 84.173 Federal Award Number and Year (or Other Identifying Numbers): 20611-042-PN01, 21611-042-PN01 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Matching, Level of Effort, Earmarking Audit Finding: Significant Deficiency Criteria: 2 CFR 200.303 states in part: "The non-Federal entity must: (a)Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO)...." 2 CFR 200.403 states in part: "Except where otherwise authorized by statute, costs must meet the following general criteria in order to be allowable under Federal awards: ? (g) Be adequately documented.... " 2 CFR 200.208(b) states in part: "The Federal awarding agency or pass-through entity may adjust specific Federal award conditions as needed . . ." 511 IAC 7-34-7(b) states: "The public agency, in providing special education and related services to students in nonpublic schools must expend at least an amount that is the same proportion of the public agency total subgrant under 20 U.S.C. 1411(f) as the number of nonpublic school students with disabilities, who are enrolled by their parents in nonpublic schools within its boundaries, is to the total number of students with disabilities of the same age range." Condition: 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 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. Cause: The School Corporation's management had not developed an effective system of internal controls that would have ensured compliance with the grant agreement and the earmarking requirements of the Matching, Level of Effort, Earmarking compliance requirement. Effect: The failure to establish an effective internal control system, as well as adequately document costs of federal awards, prevented the determination of the School Corporation's compliance with the earmarking requirements of the Matching, Level of Effort, Earmarking compliance requirement. Questioned Costs: There were no questioned costs identified. Context: The School Corporation is a member of the Northeast Indiana Special Education Cooperative (Cooperative). During fiscal year 2021-2022, the Cooperative operated the special education programs and spent the federal money on behalf of all its members. 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. 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 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-042-PN01, 20611-042-PN01, and 21611-042-PN01 grant awards could not be verified for the individual schools to verify the minimum amount per the grant awards was expended and properly reported to IDOE as required. The lack of internal controls and noncompliance were isolated to the 20611-042-PN01 and 21611-042-PN01 grant awards. The minimum proportionate share earmarking amount was $3,483 and $3,429 for the 20611-042-PN01 and 21611-042-PN01 grant awards, respectively. Identification as a repeat finding: No. Recommendation: We recommended that the School Corporation's management establish a system of internal controls, as well as appropriately document and identify federal award expenditures to ensure compliance with the Matching, Level of Effort, Earmarking compliance requirement. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
FINDING 2022-002 Subject: Special Education Cluster - Earmarking Federal Agency: Department of Education Federal Program: Special Education Grants to States, Special Education Preschool Grants Assistance Listings Numbers: 84.027, 84.173 Federal Award Number and Year (or Other Identifying Numbers): 20611-042-PN01, 21611-042-PN01 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Matching, Level of Effort, Earmarking Audit Finding: Significant Deficiency Criteria: 2 CFR 200.303 states in part: "The non-Federal entity must: (a)Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO)...." 2 CFR 200.403 states in part: "Except where otherwise authorized by statute, costs must meet the following general criteria in order to be allowable under Federal awards: ? (g) Be adequately documented.... " 2 CFR 200.208(b) states in part: "The Federal awarding agency or pass-through entity may adjust specific Federal award conditions as needed . . ." 511 IAC 7-34-7(b) states: "The public agency, in providing special education and related services to students in nonpublic schools must expend at least an amount that is the same proportion of the public agency total subgrant under 20 U.S.C. 1411(f) as the number of nonpublic school students with disabilities, who are enrolled by their parents in nonpublic schools within its boundaries, is to the total number of students with disabilities of the same age range." Condition: 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 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. Cause: The School Corporation's management had not developed an effective system of internal controls that would have ensured compliance with the grant agreement and the earmarking requirements of the Matching, Level of Effort, Earmarking compliance requirement. Effect: The failure to establish an effective internal control system, as well as adequately document costs of federal awards, prevented the determination of the School Corporation's compliance with the earmarking requirements of the Matching, Level of Effort, Earmarking compliance requirement. Questioned Costs: There were no questioned costs identified. Context: The School Corporation is a member of the Northeast Indiana Special Education Cooperative (Cooperative). During fiscal year 2021-2022, the Cooperative operated the special education programs and spent the federal money on behalf of all its members. 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. 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 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-042-PN01, 20611-042-PN01, and 21611-042-PN01 grant awards could not be verified for the individual schools to verify the minimum amount per the grant awards was expended and properly reported to IDOE as required. The lack of internal controls and noncompliance were isolated to the 20611-042-PN01 and 21611-042-PN01 grant awards. The minimum proportionate share earmarking amount was $3,483 and $3,429 for the 20611-042-PN01 and 21611-042-PN01 grant awards, respectively. Identification as a repeat finding: No. Recommendation: We recommended that the School Corporation's management establish a system of internal controls, as well as appropriately document and identify federal award expenditures to ensure compliance with the Matching, Level of Effort, Earmarking compliance requirement. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
FINDING 2022-002 Subject: Special Education Cluster - Earmarking Federal Agency: Department of Education Federal Program: Special Education Grants to States, Special Education Preschool Grants Assistance Listings Numbers: 84.027, 84.173 Federal Award Number and Year (or Other Identifying Numbers): 20611-042-PN01, 21611-042-PN01 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Matching, Level of Effort, Earmarking Audit Finding: Significant Deficiency Criteria: 2 CFR 200.303 states in part: "The non-Federal entity must: (a)Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO)...." 2 CFR 200.403 states in part: "Except where otherwise authorized by statute, costs must meet the following general criteria in order to be allowable under Federal awards: ? (g) Be adequately documented.... " 2 CFR 200.208(b) states in part: "The Federal awarding agency or pass-through entity may adjust specific Federal award conditions as needed . . ." 511 IAC 7-34-7(b) states: "The public agency, in providing special education and related services to students in nonpublic schools must expend at least an amount that is the same proportion of the public agency total subgrant under 20 U.S.C. 1411(f) as the number of nonpublic school students with disabilities, who are enrolled by their parents in nonpublic schools within its boundaries, is to the total number of students with disabilities of the same age range." Condition: 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 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. Cause: The School Corporation's management had not developed an effective system of internal controls that would have ensured compliance with the grant agreement and the earmarking requirements of the Matching, Level of Effort, Earmarking compliance requirement. Effect: The failure to establish an effective internal control system, as well as adequately document costs of federal awards, prevented the determination of the School Corporation's compliance with the earmarking requirements of the Matching, Level of Effort, Earmarking compliance requirement. Questioned Costs: There were no questioned costs identified. Context: The School Corporation is a member of the Northeast Indiana Special Education Cooperative (Cooperative). During fiscal year 2021-2022, the Cooperative operated the special education programs and spent the federal money on behalf of all its members. 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. 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 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-042-PN01, 20611-042-PN01, and 21611-042-PN01 grant awards could not be verified for the individual schools to verify the minimum amount per the grant awards was expended and properly reported to IDOE as required. The lack of internal controls and noncompliance were isolated to the 20611-042-PN01 and 21611-042-PN01 grant awards. The minimum proportionate share earmarking amount was $3,483 and $3,429 for the 20611-042-PN01 and 21611-042-PN01 grant awards, respectively. Identification as a repeat finding: No. Recommendation: We recommended that the School Corporation's management establish a system of internal controls, as well as appropriately document and identify federal award expenditures to ensure compliance with the Matching, Level of Effort, Earmarking compliance requirement. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
FINDING 2022-002 Subject: Special Education Cluster - Earmarking Federal Agency: Department of Education Federal Program: Special Education Grants to States, Special Education Preschool Grants Assistance Listings Numbers: 84.027, 84.173 Federal Award Number and Year (or Other Identifying Numbers): 20611-042-PN01, 21611-042-PN01 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Matching, Level of Effort, Earmarking Audit Finding: Significant Deficiency Criteria: 2 CFR 200.303 states in part: "The non-Federal entity must: (a)Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO)...." 2 CFR 200.403 states in part: "Except where otherwise authorized by statute, costs must meet the following general criteria in order to be allowable under Federal awards: ? (g) Be adequately documented.... " 2 CFR 200.208(b) states in part: "The Federal awarding agency or pass-through entity may adjust specific Federal award conditions as needed . . ." 511 IAC 7-34-7(b) states: "The public agency, in providing special education and related services to students in nonpublic schools must expend at least an amount that is the same proportion of the public agency total subgrant under 20 U.S.C. 1411(f) as the number of nonpublic school students with disabilities, who are enrolled by their parents in nonpublic schools within its boundaries, is to the total number of students with disabilities of the same age range." Condition: 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 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. Cause: The School Corporation's management had not developed an effective system of internal controls that would have ensured compliance with the grant agreement and the earmarking requirements of the Matching, Level of Effort, Earmarking compliance requirement. Effect: The failure to establish an effective internal control system, as well as adequately document costs of federal awards, prevented the determination of the School Corporation's compliance with the earmarking requirements of the Matching, Level of Effort, Earmarking compliance requirement. Questioned Costs: There were no questioned costs identified. Context: The School Corporation is a member of the Northeast Indiana Special Education Cooperative (Cooperative). During fiscal year 2021-2022, the Cooperative operated the special education programs and spent the federal money on behalf of all its members. 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. 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 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-042-PN01, 20611-042-PN01, and 21611-042-PN01 grant awards could not be verified for the individual schools to verify the minimum amount per the grant awards was expended and properly reported to IDOE as required. The lack of internal controls and noncompliance were isolated to the 20611-042-PN01 and 21611-042-PN01 grant awards. The minimum proportionate share earmarking amount was $3,483 and $3,429 for the 20611-042-PN01 and 21611-042-PN01 grant awards, respectively. Identification as a repeat finding: No. Recommendation: We recommended that the School Corporation's management establish a system of internal controls, as well as appropriately document and identify federal award expenditures to ensure compliance with the Matching, Level of Effort, Earmarking compliance requirement. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
Review And Approval Of The Schedule Of Expenditures Of Federal Awards (SEFA) - Significant Deficiency All Federal Programs Criteria: The Uniform Guidance in 2 CFR Section 200.303 requires that non-Federal entities receiving Federal awards (i.e. auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. The School should have a process in place to perform a review of the SEFA, to include evidence of the resolution of variances, as well as a process to document the overall review and approval to ensure proper presentation, completeness, and accuracy of the SEFA. Condition: During the course of the audit, the engagement team identified multiple instances where the SEFA was not accurately prepared and presented. Specifically, there were federal expenditures that were misclassified to the incorrect federal grant. The SEFA was corrected to correctly classify these expenses in the current year. The engagement team identified this as a pervasive deficiency impacting all schools, as the SEFA was prepared by the same management personnel. Cause: The entity does not have an appropriate process in place to review the SEFA, to include retaining evidence of the resolution of variances, as well as documentation of the overall review and approval. Effect: Potential misstatement could occur if expenditure amounts are not accurately presented on the SEFA. Questioned Costs: Not applicable. Context: Not applicable. Identification As A Repeat Finding: Yes. Recommendation: The School should develop a consistent process to review the SEFA. Issues identified during the course of the review should be investigated and resolved in a timely manner.
Review And Approval Of The Schedule Of Expenditures Of Federal Awards (SEFA) - Significant Deficiency All Federal Programs Criteria: The Uniform Guidance in 2 CFR Section 200.303 requires that non-Federal entities receiving Federal awards (i.e. auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. The School should have a process in place to perform a review of the SEFA, to include evidence of the resolution of variances, as well as a process to document the overall review and approval to ensure proper presentation, completeness, and accuracy of the SEFA. Condition: During the course of the audit, the engagement team identified multiple instances where the SEFA was not accurately prepared and presented. Specifically, there were federal expenditures that were misclassified to the incorrect federal grant. The SEFA was corrected to correctly classify these expenses in the current year. The engagement team identified this as a pervasive deficiency impacting all schools, as the SEFA was prepared by the same management personnel. Cause: The entity does not have an appropriate process in place to review the SEFA, to include retaining evidence of the resolution of variances, as well as documentation of the overall review and approval. Effect: Potential misstatement could occur if expenditure amounts are not accurately presented on the SEFA. Questioned Costs: Not applicable. Context: Not applicable. Identification As A Repeat Finding: Yes. Recommendation: The School should develop a consistent process to review the SEFA. Issues identified during the course of the review should be investigated and resolved in a timely manner.
Review And Approval Of The Schedule Of Expenditures Of Federal Awards (SEFA) - Significant Deficiency All Federal Programs Criteria: The Uniform Guidance in 2 CFR Section 200.303 requires that non-Federal entities receiving Federal awards (i.e. auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. The School should have a process in place to perform a review of the SEFA, to include evidence of the resolution of variances, as well as a process to document the overall review and approval to ensure proper presentation, completeness, and accuracy of the SEFA. Condition: During the course of the audit, the engagement team identified multiple instances where the SEFA was not accurately prepared and presented. Specifically, there were federal expenditures that were misclassified to the incorrect federal grant. The SEFA was corrected to correctly classify these expenses in the current year. The engagement team identified this as a pervasive deficiency impacting all schools, as the SEFA was prepared by the same management personnel. Cause: The entity does not have an appropriate process in place to review the SEFA, to include retaining evidence of the resolution of variances, as well as documentation of the overall review and approval. Effect: Potential misstatement could occur if expenditure amounts are not accurately presented on the SEFA. Questioned Costs: Not applicable. Context: Not applicable. Identification As A Repeat Finding: Yes. Recommendation: The School should develop a consistent process to review the SEFA. Issues identified during the course of the review should be investigated and resolved in a timely manner.
Review And Approval Of The Schedule Of Expenditures Of Federal Awards (SEFA) - Significant Deficiency All Federal Programs Criteria: The Uniform Guidance in 2 CFR Section 200.303 requires that non-Federal entities receiving Federal awards (i.e. auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. The School should have a process in place to perform a review of the SEFA, to include evidence of the resolution of variances, as well as a process to document the overall review and approval to ensure proper presentation, completeness, and accuracy of the SEFA. Condition: During the course of the audit, the engagement team identified multiple instances where the SEFA was not accurately prepared and presented. Specifically, there were federal expenditures that were misclassified to the incorrect federal grant. The SEFA was corrected to correctly classify these expenses in the current year. The engagement team identified this as a pervasive deficiency impacting all schools, as the SEFA was prepared by the same management personnel. Cause: The entity does not have an appropriate process in place to review the SEFA, to include retaining evidence of the resolution of variances, as well as documentation of the overall review and approval. Effect: Potential misstatement could occur if expenditure amounts are not accurately presented on the SEFA. Questioned Costs: Not applicable. Context: Not applicable. Identification As A Repeat Finding: Yes. Recommendation: The School should develop a consistent process to review the SEFA. Issues identified during the course of the review should be investigated and resolved in a timely manner.
2022-003 Department of Health and Human Services Iowa Department of Public Health CFDA #93.268 Immunization Cooperative Agreements Applicable Federal Award Number and Year ? 5881I429E, 5885BT431 #7, and 5885BT431 #8 for 2022 Cash Management Material Weakness in Internal Control Over Compliance Criteria: 2 CFR 200.303(a) establishes that the auditee must establish and maintain effective internal control over the federal award that provides assurance that the entity is managing the federal award in compliance with federal statutes, regulations, and conditions of the federal award. The Cash Management Improvement Act of 1990-31 CFR 205.33 requires that when grant funds are advanced, recipients must follow procedures to minimize the time elapsing between the transfer of funds and disbursement. Condition: The County?s requests for reimbursement submitted to the Iowa Department of Public Health were not reviewed and approved by a separate individual outside of the preparer. In addition, on two occasions the County held grant funds in excess of seven weeks. Cause: The County did not have an internal control process in place to ensure a secondary review and approval of the requests for reimbursement. Effect: Without a secondary review and approval, there is a possibility that the requests for reimbursement contain errors, which could lead to ineligible expenditures being claimed under the program and noncompliance with federal requirements regarding the Cash Management Improvement Act. Questioned Costs: None reported. Context: A nonstatistical sample of 6 requests for reimbursement out of 21 were tested. Repeat Finding from Prior Years: No Recommendation: We recommend the County implement a control process which includes a secondary review and approval of all requests for reimbursements. Views of Responsible Officials: The VNA will submit the claim to the Health Department for approval before submitting going forward.
2022-004 Department of Health and Human Services Iowa Department of Public Health CFDA #93.268 Immunization Cooperative Agreements Applicable Federal Award Number and Year ? 5881I429E, 5885BT431 #7, and 5885BT431 #8 for 2022 Subrecipient Monitoring and Special Tests and Provisions Material Weakness in Internal Control Over Compliance and Material Noncompliance Criteria: 2 CFR 200.303(a) establishes that the auditee must establish and maintain effective internal control over the federal award that provides assurance that the entity is managing the federal award in compliance with federal statutes, regulations, and conditions of the federal award. Subrecipient monitoring requirements are contained in 2 CFR 200.331 through 2 CFR 200.333 and include requirements to identify the award and applicable requirements to the subrecipient and monitor the activities of the subrecipient. Condition: The County did not formally communicate the required information to the subrecipient. No subrecipient agreement was executed. In addition, no monitoring activities were documented, including monitoring of the program?s special tests and provisions. Cause: The County did not have an internal control process in place to ensure subrecipient monitoring requirements were met. Effect: Without the proper communication of applicable requirements and monitoring of the subrecipient, there is a possibility that federal statutes, regulations, and the terms and conditions of the federal award, including the program?s special tests and provisions, were not complied with. Questioned Costs: None reported. Context: $112,801 was passed through to one subrecipient during the year ended June 30, 2022. Repeat Finding from Prior Years: No Recommendation: We recommend the County implement a control process which includes the applicable subrecipient monitoring requirements. Views of Responsible Officials: Dubuque County is working with the Dubuque Visiting Nurse Association on implementing a subrecipient agreement and will put a control process in place to monitor.
2022-003 Department of Health and Human Services Iowa Department of Public Health CFDA #93.268 Immunization Cooperative Agreements Applicable Federal Award Number and Year ? 5881I429E, 5885BT431 #7, and 5885BT431 #8 for 2022 Cash Management Material Weakness in Internal Control Over Compliance Criteria: 2 CFR 200.303(a) establishes that the auditee must establish and maintain effective internal control over the federal award that provides assurance that the entity is managing the federal award in compliance with federal statutes, regulations, and conditions of the federal award. The Cash Management Improvement Act of 1990-31 CFR 205.33 requires that when grant funds are advanced, recipients must follow procedures to minimize the time elapsing between the transfer of funds and disbursement. Condition: The County?s requests for reimbursement submitted to the Iowa Department of Public Health were not reviewed and approved by a separate individual outside of the preparer. In addition, on two occasions the County held grant funds in excess of seven weeks. Cause: The County did not have an internal control process in place to ensure a secondary review and approval of the requests for reimbursement. Effect: Without a secondary review and approval, there is a possibility that the requests for reimbursement contain errors, which could lead to ineligible expenditures being claimed under the program and noncompliance with federal requirements regarding the Cash Management Improvement Act. Questioned Costs: None reported. Context: A nonstatistical sample of 6 requests for reimbursement out of 21 were tested. Repeat Finding from Prior Years: No Recommendation: We recommend the County implement a control process which includes a secondary review and approval of all requests for reimbursements. Views of Responsible Officials: The VNA will submit the claim to the Health Department for approval before submitting going forward.
2022-004 Department of Health and Human Services Iowa Department of Public Health CFDA #93.268 Immunization Cooperative Agreements Applicable Federal Award Number and Year ? 5881I429E, 5885BT431 #7, and 5885BT431 #8 for 2022 Subrecipient Monitoring and Special Tests and Provisions Material Weakness in Internal Control Over Compliance and Material Noncompliance Criteria: 2 CFR 200.303(a) establishes that the auditee must establish and maintain effective internal control over the federal award that provides assurance that the entity is managing the federal award in compliance with federal statutes, regulations, and conditions of the federal award. Subrecipient monitoring requirements are contained in 2 CFR 200.331 through 2 CFR 200.333 and include requirements to identify the award and applicable requirements to the subrecipient and monitor the activities of the subrecipient. Condition: The County did not formally communicate the required information to the subrecipient. No subrecipient agreement was executed. In addition, no monitoring activities were documented, including monitoring of the program?s special tests and provisions. Cause: The County did not have an internal control process in place to ensure subrecipient monitoring requirements were met. Effect: Without the proper communication of applicable requirements and monitoring of the subrecipient, there is a possibility that federal statutes, regulations, and the terms and conditions of the federal award, including the program?s special tests and provisions, were not complied with. Questioned Costs: None reported. Context: $112,801 was passed through to one subrecipient during the year ended June 30, 2022. Repeat Finding from Prior Years: No Recommendation: We recommend the County implement a control process which includes the applicable subrecipient monitoring requirements. Views of Responsible Officials: Dubuque County is working with the Dubuque Visiting Nurse Association on implementing a subrecipient agreement and will put a control process in place to monitor.
2022-003 Department of Health and Human Services Iowa Department of Public Health CFDA #93.268 Immunization Cooperative Agreements Applicable Federal Award Number and Year ? 5881I429E, 5885BT431 #7, and 5885BT431 #8 for 2022 Cash Management Material Weakness in Internal Control Over Compliance Criteria: 2 CFR 200.303(a) establishes that the auditee must establish and maintain effective internal control over the federal award that provides assurance that the entity is managing the federal award in compliance with federal statutes, regulations, and conditions of the federal award. The Cash Management Improvement Act of 1990-31 CFR 205.33 requires that when grant funds are advanced, recipients must follow procedures to minimize the time elapsing between the transfer of funds and disbursement. Condition: The County?s requests for reimbursement submitted to the Iowa Department of Public Health were not reviewed and approved by a separate individual outside of the preparer. In addition, on two occasions the County held grant funds in excess of seven weeks. Cause: The County did not have an internal control process in place to ensure a secondary review and approval of the requests for reimbursement. Effect: Without a secondary review and approval, there is a possibility that the requests for reimbursement contain errors, which could lead to ineligible expenditures being claimed under the program and noncompliance with federal requirements regarding the Cash Management Improvement Act. Questioned Costs: None reported. Context: A nonstatistical sample of 6 requests for reimbursement out of 21 were tested. Repeat Finding from Prior Years: No Recommendation: We recommend the County implement a control process which includes a secondary review and approval of all requests for reimbursements. Views of Responsible Officials: The VNA will submit the claim to the Health Department for approval before submitting going forward.
2022-004 Department of Health and Human Services Iowa Department of Public Health CFDA #93.268 Immunization Cooperative Agreements Applicable Federal Award Number and Year ? 5881I429E, 5885BT431 #7, and 5885BT431 #8 for 2022 Subrecipient Monitoring and Special Tests and Provisions Material Weakness in Internal Control Over Compliance and Material Noncompliance Criteria: 2 CFR 200.303(a) establishes that the auditee must establish and maintain effective internal control over the federal award that provides assurance that the entity is managing the federal award in compliance with federal statutes, regulations, and conditions of the federal award. Subrecipient monitoring requirements are contained in 2 CFR 200.331 through 2 CFR 200.333 and include requirements to identify the award and applicable requirements to the subrecipient and monitor the activities of the subrecipient. Condition: The County did not formally communicate the required information to the subrecipient. No subrecipient agreement was executed. In addition, no monitoring activities were documented, including monitoring of the program?s special tests and provisions. Cause: The County did not have an internal control process in place to ensure subrecipient monitoring requirements were met. Effect: Without the proper communication of applicable requirements and monitoring of the subrecipient, there is a possibility that federal statutes, regulations, and the terms and conditions of the federal award, including the program?s special tests and provisions, were not complied with. Questioned Costs: None reported. Context: $112,801 was passed through to one subrecipient during the year ended June 30, 2022. Repeat Finding from Prior Years: No Recommendation: We recommend the County implement a control process which includes the applicable subrecipient monitoring requirements. Views of Responsible Officials: Dubuque County is working with the Dubuque Visiting Nurse Association on implementing a subrecipient agreement and will put a control process in place to monitor.
2022-002 Department of Health and Human Services CFDA #93.498 COVID-19 Provider Relief Fund and American Rescue Plan (ARP) Rural Distribution Applicable Federal Award Number and Year ? Periods 2 and 3 TIN #426004597 Activities Allowed or Unallowed and Allowable Costs/Cost Principles and Reporting Material Weakness in Internal Control Over Compliance Criteria: 2 CFR 200.303(a) establishes that the auditee must establish and maintain effective internal control over the federal award that provides assurance that the entity is managing the federal award in compliance with federal statutes, regulations, and conditions of the federal award. Condition: The Center?s final expenditure listing identified as eligible and claimed under the Provider Relief Fund program was not reviewed and approved by a separate individual outside of the preparer. In addition, the County?s special reports submitted to the Department of Health and Human Services for Periods 2 and 3 TIN #426004597 were not reviewed and approved by a separate individual outside of the preparer. Cause: The County did not have an internal control process in place to ensure a secondary review and approval of eligible expenditures that were summarized from the underlying support to the final expenditure listing was documented. The summary spreadsheet was used to claim allowable costs under the federal program. In addition, the review and approval of the reports submitted to the Department of Health and Human Services for Periods 2 and 3 were not performed by someone other than the preparer of the report. Effect: Without a secondary review and approval, there is a possibility that ineligible expenditures may be claimed under the program and the report may not be accurately completed. Questioned Costs: None reported. Context: Testing was performed over general and administrative expenses and healthcare related expenses, including personnel costs and certain supplies for activities allowed and unallowed and allowable costs/cost principles. A nonstatistical sample of 17 transactions totaling $129,627 out of $213,848 were tested. In addition, key line items were tested on the Period 2 and Period 3 Department of Health and Human Services special reports. Repeat Finding from Prior Years: No Recommendation: We recommend the County implement a control process which includes a secondary review and approval of the summarized final expenditure listing used to claim the allowable costs under the federal program and secondary review and approval of required reports to be submitted to the federal agency. Views of Responsible Officials: Moving forward, the Finance Director and/or Administrator will review and approve the expenditures and reports prior to being submitted.
Finding Number: 2022-003 Program: Research and Development Cluster Federal Agency Name: Various Federal Award Year: July 1, 2021 ? June 30, 2022 Federal Assistance Listing Numbers: Various Criteria The Uniform Guidance Section 200.430 states that charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. Further, in accordance with 2 CFR 200.303(a), non-federal entities must establish and maintain effective internal control over the federal award that provides reasonable assurance that the non-federal entity is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. Condition During our testing of payroll allowability we noted 4 out of 71 payroll transactions tested were paid and charged to the grant incorrectly. Additionally, for 3 out of 71 payroll transactions the amount allocated to the grant was incorrect. The incorrect payments and allocations to grants were due to manual errors when processing payroll and related after the fact allocations to federal grants. We deemed this to be a material weakness in internal controls and noncompiance with the allowable costs compliance requirement. Our sample was not, and was not intended to be statistically valid. This finding is a repeat finding in the immediately prior audit finding 2021-003 Questioned Costs Unallowable payroll costs charged to the grants below FALN 12.300 $ 170 FALN 12.300 170 FALN 47.041 5,744 FALN 47.076 7 Total $ 6,091 Cause Manual calculations or clerical errors of the amount to be paid/and or allocated to the grant were made before being entered into the system. There was no secondary review of the calculation by someone other than the preparer.The University did not have an adequately designed internal control to identify calculation errors in applying payroll amounts to federal awards and as such, the amount of the errors and related non-compliance could have been greater and not detected by the University?s control environment. Effect Payroll amounts charged to federal grants are unsupported by actual time spent on the award and are thus unallowable. Recommendation We recommend that the University implement a more thorough and detailed process and related internal controls to review payroll authorization forms and manual calculations performed before the payroll allocation is recorded to the federal grant.
Finding Number: 2022-003 Program: Research and Development Cluster Federal Agency Name: Various Federal Award Year: July 1, 2021 ? June 30, 2022 Federal Assistance Listing Numbers: Various Criteria The Uniform Guidance Section 200.430 states that charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. Further, in accordance with 2 CFR 200.303(a), non-federal entities must establish and maintain effective internal control over the federal award that provides reasonable assurance that the non-federal entity is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. Condition During our testing of payroll allowability we noted 4 out of 71 payroll transactions tested were paid and charged to the grant incorrectly. Additionally, for 3 out of 71 payroll transactions the amount allocated to the grant was incorrect. The incorrect payments and allocations to grants were due to manual errors when processing payroll and related after the fact allocations to federal grants. We deemed this to be a material weakness in internal controls and noncompiance with the allowable costs compliance requirement. Our sample was not, and was not intended to be statistically valid. This finding is a repeat finding in the immediately prior audit finding 2021-003 Questioned Costs Unallowable payroll costs charged to the grants below FALN 12.300 $ 170 FALN 12.300 170 FALN 47.041 5,744 FALN 47.076 7 Total $ 6,091 Cause Manual calculations or clerical errors of the amount to be paid/and or allocated to the grant were made before being entered into the system. There was no secondary review of the calculation by someone other than the preparer.The University did not have an adequately designed internal control to identify calculation errors in applying payroll amounts to federal awards and as such, the amount of the errors and related non-compliance could have been greater and not detected by the University?s control environment. Effect Payroll amounts charged to federal grants are unsupported by actual time spent on the award and are thus unallowable. Recommendation We recommend that the University implement a more thorough and detailed process and related internal controls to review payroll authorization forms and manual calculations performed before the payroll allocation is recorded to the federal grant.
Finding Number: 2022-003 Program: Research and Development Cluster Federal Agency Name: Various Federal Award Year: July 1, 2021 ? June 30, 2022 Federal Assistance Listing Numbers: Various Criteria The Uniform Guidance Section 200.430 states that charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. Further, in accordance with 2 CFR 200.303(a), non-federal entities must establish and maintain effective internal control over the federal award that provides reasonable assurance that the non-federal entity is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. Condition During our testing of payroll allowability we noted 4 out of 71 payroll transactions tested were paid and charged to the grant incorrectly. Additionally, for 3 out of 71 payroll transactions the amount allocated to the grant was incorrect. The incorrect payments and allocations to grants were due to manual errors when processing payroll and related after the fact allocations to federal grants. We deemed this to be a material weakness in internal controls and noncompiance with the allowable costs compliance requirement. Our sample was not, and was not intended to be statistically valid. This finding is a repeat finding in the immediately prior audit finding 2021-003 Questioned Costs Unallowable payroll costs charged to the grants below FALN 12.300 $ 170 FALN 12.300 170 FALN 47.041 5,744 FALN 47.076 7 Total $ 6,091 Cause Manual calculations or clerical errors of the amount to be paid/and or allocated to the grant were made before being entered into the system. There was no secondary review of the calculation by someone other than the preparer.The University did not have an adequately designed internal control to identify calculation errors in applying payroll amounts to federal awards and as such, the amount of the errors and related non-compliance could have been greater and not detected by the University?s control environment. Effect Payroll amounts charged to federal grants are unsupported by actual time spent on the award and are thus unallowable. Recommendation We recommend that the University implement a more thorough and detailed process and related internal controls to review payroll authorization forms and manual calculations performed before the payroll allocation is recorded to the federal grant.
Finding Number: 2022-003 Program: Research and Development Cluster Federal Agency Name: Various Federal Award Year: July 1, 2021 ? June 30, 2022 Federal Assistance Listing Numbers: Various Criteria The Uniform Guidance Section 200.430 states that charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. Further, in accordance with 2 CFR 200.303(a), non-federal entities must establish and maintain effective internal control over the federal award that provides reasonable assurance that the non-federal entity is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. Condition During our testing of payroll allowability we noted 4 out of 71 payroll transactions tested were paid and charged to the grant incorrectly. Additionally, for 3 out of 71 payroll transactions the amount allocated to the grant was incorrect. The incorrect payments and allocations to grants were due to manual errors when processing payroll and related after the fact allocations to federal grants. We deemed this to be a material weakness in internal controls and noncompiance with the allowable costs compliance requirement. Our sample was not, and was not intended to be statistically valid. This finding is a repeat finding in the immediately prior audit finding 2021-003 Questioned Costs Unallowable payroll costs charged to the grants below FALN 12.300 $ 170 FALN 12.300 170 FALN 47.041 5,744 FALN 47.076 7 Total $ 6,091 Cause Manual calculations or clerical errors of the amount to be paid/and or allocated to the grant were made before being entered into the system. There was no secondary review of the calculation by someone other than the preparer.The University did not have an adequately designed internal control to identify calculation errors in applying payroll amounts to federal awards and as such, the amount of the errors and related non-compliance could have been greater and not detected by the University?s control environment. Effect Payroll amounts charged to federal grants are unsupported by actual time spent on the award and are thus unallowable. Recommendation We recommend that the University implement a more thorough and detailed process and related internal controls to review payroll authorization forms and manual calculations performed before the payroll allocation is recorded to the federal grant.
Finding Number: 2022-003 Program: Research and Development Cluster Federal Agency Name: Various Federal Award Year: July 1, 2021 ? June 30, 2022 Federal Assistance Listing Numbers: Various Criteria The Uniform Guidance Section 200.430 states that charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. Further, in accordance with 2 CFR 200.303(a), non-federal entities must establish and maintain effective internal control over the federal award that provides reasonable assurance that the non-federal entity is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. Condition During our testing of payroll allowability we noted 4 out of 71 payroll transactions tested were paid and charged to the grant incorrectly. Additionally, for 3 out of 71 payroll transactions the amount allocated to the grant was incorrect. The incorrect payments and allocations to grants were due to manual errors when processing payroll and related after the fact allocations to federal grants. We deemed this to be a material weakness in internal controls and noncompiance with the allowable costs compliance requirement. Our sample was not, and was not intended to be statistically valid. This finding is a repeat finding in the immediately prior audit finding 2021-003 Questioned Costs Unallowable payroll costs charged to the grants below FALN 12.300 $ 170 FALN 12.300 170 FALN 47.041 5,744 FALN 47.076 7 Total $ 6,091 Cause Manual calculations or clerical errors of the amount to be paid/and or allocated to the grant were made before being entered into the system. There was no secondary review of the calculation by someone other than the preparer.The University did not have an adequately designed internal control to identify calculation errors in applying payroll amounts to federal awards and as such, the amount of the errors and related non-compliance could have been greater and not detected by the University?s control environment. Effect Payroll amounts charged to federal grants are unsupported by actual time spent on the award and are thus unallowable. Recommendation We recommend that the University implement a more thorough and detailed process and related internal controls to review payroll authorization forms and manual calculations performed before the payroll allocation is recorded to the federal grant.
Finding Number: 2022-003 Program: Research and Development Cluster Federal Agency Name: Various Federal Award Year: July 1, 2021 ? June 30, 2022 Federal Assistance Listing Numbers: Various Criteria The Uniform Guidance Section 200.430 states that charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. Further, in accordance with 2 CFR 200.303(a), non-federal entities must establish and maintain effective internal control over the federal award that provides reasonable assurance that the non-federal entity is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. Condition During our testing of payroll allowability we noted 4 out of 71 payroll transactions tested were paid and charged to the grant incorrectly. Additionally, for 3 out of 71 payroll transactions the amount allocated to the grant was incorrect. The incorrect payments and allocations to grants were due to manual errors when processing payroll and related after the fact allocations to federal grants. We deemed this to be a material weakness in internal controls and noncompiance with the allowable costs compliance requirement. Our sample was not, and was not intended to be statistically valid. This finding is a repeat finding in the immediately prior audit finding 2021-003 Questioned Costs Unallowable payroll costs charged to the grants below FALN 12.300 $ 170 FALN 12.300 170 FALN 47.041 5,744 FALN 47.076 7 Total $ 6,091 Cause Manual calculations or clerical errors of the amount to be paid/and or allocated to the grant were made before being entered into the system. There was no secondary review of the calculation by someone other than the preparer.The University did not have an adequately designed internal control to identify calculation errors in applying payroll amounts to federal awards and as such, the amount of the errors and related non-compliance could have been greater and not detected by the University?s control environment. Effect Payroll amounts charged to federal grants are unsupported by actual time spent on the award and are thus unallowable. Recommendation We recommend that the University implement a more thorough and detailed process and related internal controls to review payroll authorization forms and manual calculations performed before the payroll allocation is recorded to the federal grant.
Finding Number: 2022-003 Program: Research and Development Cluster Federal Agency Name: Various Federal Award Year: July 1, 2021 ? June 30, 2022 Federal Assistance Listing Numbers: Various Criteria The Uniform Guidance Section 200.430 states that charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. Further, in accordance with 2 CFR 200.303(a), non-federal entities must establish and maintain effective internal control over the federal award that provides reasonable assurance that the non-federal entity is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. Condition During our testing of payroll allowability we noted 4 out of 71 payroll transactions tested were paid and charged to the grant incorrectly. Additionally, for 3 out of 71 payroll transactions the amount allocated to the grant was incorrect. The incorrect payments and allocations to grants were due to manual errors when processing payroll and related after the fact allocations to federal grants. We deemed this to be a material weakness in internal controls and noncompiance with the allowable costs compliance requirement. Our sample was not, and was not intended to be statistically valid. This finding is a repeat finding in the immediately prior audit finding 2021-003 Questioned Costs Unallowable payroll costs charged to the grants below FALN 12.300 $ 170 FALN 12.300 170 FALN 47.041 5,744 FALN 47.076 7 Total $ 6,091 Cause Manual calculations or clerical errors of the amount to be paid/and or allocated to the grant were made before being entered into the system. There was no secondary review of the calculation by someone other than the preparer.The University did not have an adequately designed internal control to identify calculation errors in applying payroll amounts to federal awards and as such, the amount of the errors and related non-compliance could have been greater and not detected by the University?s control environment. Effect Payroll amounts charged to federal grants are unsupported by actual time spent on the award and are thus unallowable. Recommendation We recommend that the University implement a more thorough and detailed process and related internal controls to review payroll authorization forms and manual calculations performed before the payroll allocation is recorded to the federal grant.
Finding Number: 2022-003 Program: Research and Development Cluster Federal Agency Name: Various Federal Award Year: July 1, 2021 ? June 30, 2022 Federal Assistance Listing Numbers: Various Criteria The Uniform Guidance Section 200.430 states that charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. Further, in accordance with 2 CFR 200.303(a), non-federal entities must establish and maintain effective internal control over the federal award that provides reasonable assurance that the non-federal entity is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. Condition During our testing of payroll allowability we noted 4 out of 71 payroll transactions tested were paid and charged to the grant incorrectly. Additionally, for 3 out of 71 payroll transactions the amount allocated to the grant was incorrect. The incorrect payments and allocations to grants were due to manual errors when processing payroll and related after the fact allocations to federal grants. We deemed this to be a material weakness in internal controls and noncompiance with the allowable costs compliance requirement. Our sample was not, and was not intended to be statistically valid. This finding is a repeat finding in the immediately prior audit finding 2021-003 Questioned Costs Unallowable payroll costs charged to the grants below FALN 12.300 $ 170 FALN 12.300 170 FALN 47.041 5,744 FALN 47.076 7 Total $ 6,091 Cause Manual calculations or clerical errors of the amount to be paid/and or allocated to the grant were made before being entered into the system. There was no secondary review of the calculation by someone other than the preparer.The University did not have an adequately designed internal control to identify calculation errors in applying payroll amounts to federal awards and as such, the amount of the errors and related non-compliance could have been greater and not detected by the University?s control environment. Effect Payroll amounts charged to federal grants are unsupported by actual time spent on the award and are thus unallowable. Recommendation We recommend that the University implement a more thorough and detailed process and related internal controls to review payroll authorization forms and manual calculations performed before the payroll allocation is recorded to the federal grant.
Finding Number: 2022-003 Program: Research and Development Cluster Federal Agency Name: Various Federal Award Year: July 1, 2021 ? June 30, 2022 Federal Assistance Listing Numbers: Various Criteria The Uniform Guidance Section 200.430 states that charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. Further, in accordance with 2 CFR 200.303(a), non-federal entities must establish and maintain effective internal control over the federal award that provides reasonable assurance that the non-federal entity is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. Condition During our testing of payroll allowability we noted 4 out of 71 payroll transactions tested were paid and charged to the grant incorrectly. Additionally, for 3 out of 71 payroll transactions the amount allocated to the grant was incorrect. The incorrect payments and allocations to grants were due to manual errors when processing payroll and related after the fact allocations to federal grants. We deemed this to be a material weakness in internal controls and noncompiance with the allowable costs compliance requirement. Our sample was not, and was not intended to be statistically valid. This finding is a repeat finding in the immediately prior audit finding 2021-003 Questioned Costs Unallowable payroll costs charged to the grants below FALN 12.300 $ 170 FALN 12.300 170 FALN 47.041 5,744 FALN 47.076 7 Total $ 6,091 Cause Manual calculations or clerical errors of the amount to be paid/and or allocated to the grant were made before being entered into the system. There was no secondary review of the calculation by someone other than the preparer.The University did not have an adequately designed internal control to identify calculation errors in applying payroll amounts to federal awards and as such, the amount of the errors and related non-compliance could have been greater and not detected by the University?s control environment. Effect Payroll amounts charged to federal grants are unsupported by actual time spent on the award and are thus unallowable. Recommendation We recommend that the University implement a more thorough and detailed process and related internal controls to review payroll authorization forms and manual calculations performed before the payroll allocation is recorded to the federal grant.
Finding Number: 2022-003 Program: Research and Development Cluster Federal Agency Name: Various Federal Award Year: July 1, 2021 ? June 30, 2022 Federal Assistance Listing Numbers: Various Criteria The Uniform Guidance Section 200.430 states that charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. Further, in accordance with 2 CFR 200.303(a), non-federal entities must establish and maintain effective internal control over the federal award that provides reasonable assurance that the non-federal entity is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. Condition During our testing of payroll allowability we noted 4 out of 71 payroll transactions tested were paid and charged to the grant incorrectly. Additionally, for 3 out of 71 payroll transactions the amount allocated to the grant was incorrect. The incorrect payments and allocations to grants were due to manual errors when processing payroll and related after the fact allocations to federal grants. We deemed this to be a material weakness in internal controls and noncompiance with the allowable costs compliance requirement. Our sample was not, and was not intended to be statistically valid. This finding is a repeat finding in the immediately prior audit finding 2021-003 Questioned Costs Unallowable payroll costs charged to the grants below FALN 12.300 $ 170 FALN 12.300 170 FALN 47.041 5,744 FALN 47.076 7 Total $ 6,091 Cause Manual calculations or clerical errors of the amount to be paid/and or allocated to the grant were made before being entered into the system. There was no secondary review of the calculation by someone other than the preparer.The University did not have an adequately designed internal control to identify calculation errors in applying payroll amounts to federal awards and as such, the amount of the errors and related non-compliance could have been greater and not detected by the University?s control environment. Effect Payroll amounts charged to federal grants are unsupported by actual time spent on the award and are thus unallowable. Recommendation We recommend that the University implement a more thorough and detailed process and related internal controls to review payroll authorization forms and manual calculations performed before the payroll allocation is recorded to the federal grant.
Finding Number: 2022-003 Program: Research and Development Cluster Federal Agency Name: Various Federal Award Year: July 1, 2021 ? June 30, 2022 Federal Assistance Listing Numbers: Various Criteria The Uniform Guidance Section 200.430 states that charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. Further, in accordance with 2 CFR 200.303(a), non-federal entities must establish and maintain effective internal control over the federal award that provides reasonable assurance that the non-federal entity is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. Condition During our testing of payroll allowability we noted 4 out of 71 payroll transactions tested were paid and charged to the grant incorrectly. Additionally, for 3 out of 71 payroll transactions the amount allocated to the grant was incorrect. The incorrect payments and allocations to grants were due to manual errors when processing payroll and related after the fact allocations to federal grants. We deemed this to be a material weakness in internal controls and noncompiance with the allowable costs compliance requirement. Our sample was not, and was not intended to be statistically valid. This finding is a repeat finding in the immediately prior audit finding 2021-003 Questioned Costs Unallowable payroll costs charged to the grants below FALN 12.300 $ 170 FALN 12.300 170 FALN 47.041 5,744 FALN 47.076 7 Total $ 6,091 Cause Manual calculations or clerical errors of the amount to be paid/and or allocated to the grant were made before being entered into the system. There was no secondary review of the calculation by someone other than the preparer.The University did not have an adequately designed internal control to identify calculation errors in applying payroll amounts to federal awards and as such, the amount of the errors and related non-compliance could have been greater and not detected by the University?s control environment. Effect Payroll amounts charged to federal grants are unsupported by actual time spent on the award and are thus unallowable. Recommendation We recommend that the University implement a more thorough and detailed process and related internal controls to review payroll authorization forms and manual calculations performed before the payroll allocation is recorded to the federal grant.
Finding Number: 2022-003 Program: Research and Development Cluster Federal Agency Name: Various Federal Award Year: July 1, 2021 ? June 30, 2022 Federal Assistance Listing Numbers: Various Criteria The Uniform Guidance Section 200.430 states that charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. Further, in accordance with 2 CFR 200.303(a), non-federal entities must establish and maintain effective internal control over the federal award that provides reasonable assurance that the non-federal entity is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. Condition During our testing of payroll allowability we noted 4 out of 71 payroll transactions tested were paid and charged to the grant incorrectly. Additionally, for 3 out of 71 payroll transactions the amount allocated to the grant was incorrect. The incorrect payments and allocations to grants were due to manual errors when processing payroll and related after the fact allocations to federal grants. We deemed this to be a material weakness in internal controls and noncompiance with the allowable costs compliance requirement. Our sample was not, and was not intended to be statistically valid. This finding is a repeat finding in the immediately prior audit finding 2021-003 Questioned Costs Unallowable payroll costs charged to the grants below FALN 12.300 $ 170 FALN 12.300 170 FALN 47.041 5,744 FALN 47.076 7 Total $ 6,091 Cause Manual calculations or clerical errors of the amount to be paid/and or allocated to the grant were made before being entered into the system. There was no secondary review of the calculation by someone other than the preparer.The University did not have an adequately designed internal control to identify calculation errors in applying payroll amounts to federal awards and as such, the amount of the errors and related non-compliance could have been greater and not detected by the University?s control environment. Effect Payroll amounts charged to federal grants are unsupported by actual time spent on the award and are thus unallowable. Recommendation We recommend that the University implement a more thorough and detailed process and related internal controls to review payroll authorization forms and manual calculations performed before the payroll allocation is recorded to the federal grant.
Finding Number: 2022-003 Program: Research and Development Cluster Federal Agency Name: Various Federal Award Year: July 1, 2021 ? June 30, 2022 Federal Assistance Listing Numbers: Various Criteria The Uniform Guidance Section 200.430 states that charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. Further, in accordance with 2 CFR 200.303(a), non-federal entities must establish and maintain effective internal control over the federal award that provides reasonable assurance that the non-federal entity is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. Condition During our testing of payroll allowability we noted 4 out of 71 payroll transactions tested were paid and charged to the grant incorrectly. Additionally, for 3 out of 71 payroll transactions the amount allocated to the grant was incorrect. The incorrect payments and allocations to grants were due to manual errors when processing payroll and related after the fact allocations to federal grants. We deemed this to be a material weakness in internal controls and noncompiance with the allowable costs compliance requirement. Our sample was not, and was not intended to be statistically valid. This finding is a repeat finding in the immediately prior audit finding 2021-003 Questioned Costs Unallowable payroll costs charged to the grants below FALN 12.300 $ 170 FALN 12.300 170 FALN 47.041 5,744 FALN 47.076 7 Total $ 6,091 Cause Manual calculations or clerical errors of the amount to be paid/and or allocated to the grant were made before being entered into the system. There was no secondary review of the calculation by someone other than the preparer.The University did not have an adequately designed internal control to identify calculation errors in applying payroll amounts to federal awards and as such, the amount of the errors and related non-compliance could have been greater and not detected by the University?s control environment. Effect Payroll amounts charged to federal grants are unsupported by actual time spent on the award and are thus unallowable. Recommendation We recommend that the University implement a more thorough and detailed process and related internal controls to review payroll authorization forms and manual calculations performed before the payroll allocation is recorded to the federal grant.
Finding Number: 2022-003 Program: Research and Development Cluster Federal Agency Name: Various Federal Award Year: July 1, 2021 ? June 30, 2022 Federal Assistance Listing Numbers: Various Criteria The Uniform Guidance Section 200.430 states that charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. Further, in accordance with 2 CFR 200.303(a), non-federal entities must establish and maintain effective internal control over the federal award that provides reasonable assurance that the non-federal entity is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. Condition During our testing of payroll allowability we noted 4 out of 71 payroll transactions tested were paid and charged to the grant incorrectly. Additionally, for 3 out of 71 payroll transactions the amount allocated to the grant was incorrect. The incorrect payments and allocations to grants were due to manual errors when processing payroll and related after the fact allocations to federal grants. We deemed this to be a material weakness in internal controls and noncompiance with the allowable costs compliance requirement. Our sample was not, and was not intended to be statistically valid. This finding is a repeat finding in the immediately prior audit finding 2021-003 Questioned Costs Unallowable payroll costs charged to the grants below FALN 12.300 $ 170 FALN 12.300 170 FALN 47.041 5,744 FALN 47.076 7 Total $ 6,091 Cause Manual calculations or clerical errors of the amount to be paid/and or allocated to the grant were made before being entered into the system. There was no secondary review of the calculation by someone other than the preparer.The University did not have an adequately designed internal control to identify calculation errors in applying payroll amounts to federal awards and as such, the amount of the errors and related non-compliance could have been greater and not detected by the University?s control environment. Effect Payroll amounts charged to federal grants are unsupported by actual time spent on the award and are thus unallowable. Recommendation We recommend that the University implement a more thorough and detailed process and related internal controls to review payroll authorization forms and manual calculations performed before the payroll allocation is recorded to the federal grant.