Finding 2022-001 Year-End Close Process/Account Reconciliations Information on the Federal Programs: CFDA 14.235 Criteria or Specific Requirement: In accordance with CFR 200.302 the financial management system of each non-Federal entity must provide for effective control over, and accountability for, all funds, property, and other assets. The non-Federal entity must adequately safeguard all assets and assure that they are used solely for authorized purposes. Condition: The initial financial information provided for the audit was not accurate, resulting in delays in the audit process. In addition, we noted that certain schedules/reconciliations were not properly prepared in advance of the audit. Cause: NEW transitioned to a new accounting software during the fiscal year. We noted that NEW encountered certain difficulties during this process. Effect or Potential Effect: If each account is not reconciled regularly, it increases the risk of loss of Federal funds. Questioned Costs: None Context: The transition to the new accounting system resulted in certain challenges. Identification as a Repeat Finding, if Applicable: Not applicable Recommendation: We recommend that NEW complete the transition to the new system and ensure that each account is properly reconciled on a monthly basis.
Finding 2022-002: Support for Schedule of Expenditures of Federal Awards in the Accounting System Information on the Federal Programs: CFDA 14.235 Criteria or Specific Requirement: In accordance with CFR 200.302 (financial management) the auditee must be able to identify all Federal awards received and expenses and the Federal programs under which they were received. Condition: We noted that in the transition from the previous accounting system, certain expenditures had not been properly classified in the new system. As a result, although detailed invoices were available to support the amounts reported on the SEFA, the expenses had not been accurately classified by award within the general ledger. Cause: NEW transitioned to a new accounting software during the fiscal year. We noted that NEW encountered certain difficulties during this process. Effect or Potential Effect: If the information on the SEFA cannot be traced back to the information within the accounting system, there is an increased potential for inaccurate reporting. Questioned Costs: Indeterminable Context: The transition to the new accounting system resulted in certain challenges. Identification as a Repeat Finding, if Applicable: Not applicable Recommendation: We recommend that NEW complete the transition to the new system and ensure that each account is properly reconciled on a monthly basis.
Type: Federal award, Significant Deficiency over Schedule of Expenditures of Federal Awards (SEFA) CFDA Number: U.S. Department of Transportation 20.513 Enhanced Transit Services Programs Cluster 20.507 Federal Transit Formula Grants Requirement: The Organization should have a process in place to review the schedule of federal expenditures. The schedule of federal awards did not initially identify federal expenditures in accordance with 2 CFR 200.302. Condition/Context: The Organization?s initial schedule of expenditures of federal awards (SEFA) presented for the audit did not identify all federal awards. The SEFA excluded a new award and required adjustments. Effect: Total expenditures by federal funding source may not be properly reported and Uniform Guidance reporting may be inaccurate. Questioned Costs: None. Recommendation: The Organization should implement additional procedures to review the preparation of the SEFA presented for the audit to accurately capture all activity under federal awards. Management?s Response: We agree that the draft SEFA did not initially identify all federal awards. Controls over preparation of the SEFA were not fully complete at the time it was presented to the auditors. We believe the controls would have identified all federal expenditures in accordance with 2 CFR 200.302 if they had been further completed prior to submission to the auditors.
Type: Federal award, Significant Deficiency over Schedule of Expenditures of Federal Awards (SEFA) CFDA Number: U.S. Department of Transportation 20.513 Enhanced Transit Services Programs Cluster 20.507 Federal Transit Formula Grants Requirement: The Organization should have a process in place to review the schedule of federal expenditures. The schedule of federal awards did not initially identify federal expenditures in accordance with 2 CFR 200.302. Condition/Context: The Organization?s initial schedule of expenditures of federal awards (SEFA) presented for the audit did not identify all federal awards. The SEFA excluded a new award and required adjustments. Effect: Total expenditures by federal funding source may not be properly reported and Uniform Guidance reporting may be inaccurate. Questioned Costs: None. Recommendation: The Organization should implement additional procedures to review the preparation of the SEFA presented for the audit to accurately capture all activity under federal awards. Management?s Response: We agree that the draft SEFA did not initially identify all federal awards. Controls over preparation of the SEFA were not fully complete at the time it was presented to the auditors. We believe the controls would have identified all federal expenditures in accordance with 2 CFR 200.302 if they had been further completed prior to submission to the auditors.
Type: Federal award, Significant Deficiency over Schedule of Expenditures of Federal Awards (SEFA) CFDA Number: U.S. Department of Transportation 20.513 Enhanced Transit Services Programs Cluster 20.507 Federal Transit Formula Grants Requirement: The Organization should have a process in place to review the schedule of federal expenditures. The schedule of federal awards did not initially identify federal expenditures in accordance with 2 CFR 200.302. Condition/Context: The Organization?s initial schedule of expenditures of federal awards (SEFA) presented for the audit did not identify all federal awards. The SEFA excluded a new award and required adjustments. Effect: Total expenditures by federal funding source may not be properly reported and Uniform Guidance reporting may be inaccurate. Questioned Costs: None. Recommendation: The Organization should implement additional procedures to review the preparation of the SEFA presented for the audit to accurately capture all activity under federal awards. Management?s Response: We agree that the draft SEFA did not initially identify all federal awards. Controls over preparation of the SEFA were not fully complete at the time it was presented to the auditors. We believe the controls would have identified all federal expenditures in accordance with 2 CFR 200.302 if they had been further completed prior to submission to the auditors.
Type: Federal award, Significant Deficiency over Schedule of Expenditures of Federal Awards (SEFA) CFDA Number: U.S. Department of Transportation 20.513 Enhanced Transit Services Programs Cluster 20.507 Federal Transit Formula Grants Requirement: The Organization should have a process in place to review the schedule of federal expenditures. The schedule of federal awards did not initially identify federal expenditures in accordance with 2 CFR 200.302. Condition/Context: The Organization?s initial schedule of expenditures of federal awards (SEFA) presented for the audit did not identify all federal awards. The SEFA excluded a new award and required adjustments. Effect: Total expenditures by federal funding source may not be properly reported and Uniform Guidance reporting may be inaccurate. Questioned Costs: None. Recommendation: The Organization should implement additional procedures to review the preparation of the SEFA presented for the audit to accurately capture all activity under federal awards. Management?s Response: We agree that the draft SEFA did not initially identify all federal awards. Controls over preparation of the SEFA were not fully complete at the time it was presented to the auditors. We believe the controls would have identified all federal expenditures in accordance with 2 CFR 200.302 if they had been further completed prior to submission to the auditors.
Type: Federal award, Significant Deficiency over Schedule of Expenditures of Federal Awards (SEFA) CFDA Number: U.S. Department of Transportation 20.513 Enhanced Transit Services Programs Cluster 20.507 Federal Transit Formula Grants Requirement: The Organization should have a process in place to review the schedule of federal expenditures. The schedule of federal awards did not initially identify federal expenditures in accordance with 2 CFR 200.302. Condition/Context: The Organization?s initial schedule of expenditures of federal awards (SEFA) presented for the audit did not identify all federal awards. The SEFA excluded a new award and required adjustments. Effect: Total expenditures by federal funding source may not be properly reported and Uniform Guidance reporting may be inaccurate. Questioned Costs: None. Recommendation: The Organization should implement additional procedures to review the preparation of the SEFA presented for the audit to accurately capture all activity under federal awards. Management?s Response: We agree that the draft SEFA did not initially identify all federal awards. Controls over preparation of the SEFA were not fully complete at the time it was presented to the auditors. We believe the controls would have identified all federal expenditures in accordance with 2 CFR 200.302 if they had been further completed prior to submission to the auditors.
Type: Federal award, Significant Deficiency over Schedule of Expenditures of Federal Awards (SEFA) CFDA Number: U.S. Department of Transportation 20.513 Enhanced Transit Services Programs Cluster 20.507 Federal Transit Formula Grants Requirement: The Organization should have a process in place to review the schedule of federal expenditures. The schedule of federal awards did not initially identify federal expenditures in accordance with 2 CFR 200.302. Condition/Context: The Organization?s initial schedule of expenditures of federal awards (SEFA) presented for the audit did not identify all federal awards. The SEFA excluded a new award and required adjustments. Effect: Total expenditures by federal funding source may not be properly reported and Uniform Guidance reporting may be inaccurate. Questioned Costs: None. Recommendation: The Organization should implement additional procedures to review the preparation of the SEFA presented for the audit to accurately capture all activity under federal awards. Management?s Response: We agree that the draft SEFA did not initially identify all federal awards. Controls over preparation of the SEFA were not fully complete at the time it was presented to the auditors. We believe the controls would have identified all federal expenditures in accordance with 2 CFR 200.302 if they had been further completed prior to submission to the auditors.
Significant Deficiency 2022-002 Written Uniform Guidance Policies and Procedures Federal Program: U.S. Department of Housing and Urban Development Federal Assistance Listing 14.155 ? Section 207-223(f) Mortgage Insurance for the Purchase or Refinance of Existing Multi-Family Projects Criteria: Uniform Guidance requires written procedures for cash management and determining the allowability of costs in accordance with Subpart E ? Cost Principals. Condition: Susanne Corporation did not have written procedures for cash management (2 CFR 200.302(b)(6)) and allowable costs determination (2 CFR 200.302(b)(7)) in accordance with Uniform Guidance requirements. Questioned Costs: $0 Cause: Susanne Corporation?s written policies and procedures were not updated to include required Uniform Guidance policies. Effect: Employees of Susanne Corporation could enter into a transaction that is not in compliance with Uniform Guidance requirements. Recommendation: We recommend Susanne Corporation should draft and adopt written procedures in accordance with Uniform Guidance requirements. Views of Responsible Officials and Planned Corrective Action: Management agrees with the finding and is in the process of drafting and implementing written procedures for cash management and determining the allowability of costs in accordance with Subpart E ? Cost Principals.
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.425D, 84.425U 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). . . ." 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 amount reported as expended, $0 for ESSER I, on the second report did not agree to the amounts expended per the underlying expenditure records, $28,353 for ESSER I 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.425D, 84.425U 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). . . ." 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 amount reported as expended, $0 for ESSER I, on the second report did not agree to the amounts expended per the underlying expenditure records, $28,353 for ESSER I 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.425D, 84.425U 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). . . ." 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 amount reported as expended, $0 for ESSER I, on the second report did not agree to the amounts expended per the underlying expenditure records, $28,353 for ESSER I 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-004 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Number: 84.425 Federal Award Numbers and Years or (Other Identifying Numbers): S425D200013, S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Condition and Context An effective internal control system was not designed, nor implemented at the School Corporation to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. The School Corporation had not designed, nor implemented a system of internal control to ensure that the annual Elementary and Secondary School Emergency Relief (ESSER) annual data reports (Reports) were complete and accurately submitted. The Reports were prepared by one employee without an oversight, or review process in place to detect and correct errors. Additionally, for one of ten key line items tested the School Corporation did not accurately report the information. The Full-time Equivalent (FTE) positions as of March 13, 2020, and September 30, 2020, as required by the ESSER 1, Year 1 annual data report did not agree with the documentation provided. The lack of internal controls was a systemic issue throughout the audit period. The noncompliance was isolated to the ESSER I, Year 1 report. 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 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 and 200.329. . . ." 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." Cause Management had not developed, nor implemented a system of internal control that would have ensured compliance with the grant agreement and the Reporting compliance requirement. Effect The failure to establish an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Reporting compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish internal controls to ensure compliance and comply with the grant agreement and the Reporting compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-004 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Number: 84.425 Federal Award Numbers and Years or (Other Identifying Numbers): S425D200013, S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Condition and Context An effective internal control system was not designed, nor implemented at the School Corporation to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. The School Corporation had not designed, nor implemented a system of internal control to ensure that the annual Elementary and Secondary School Emergency Relief (ESSER) annual data reports (Reports) were complete and accurately submitted. The Reports were prepared by one employee without an oversight, or review process in place to detect and correct errors. Additionally, for one of ten key line items tested the School Corporation did not accurately report the information. The Full-time Equivalent (FTE) positions as of March 13, 2020, and September 30, 2020, as required by the ESSER 1, Year 1 annual data report did not agree with the documentation provided. The lack of internal controls was a systemic issue throughout the audit period. The noncompliance was isolated to the ESSER I, Year 1 report. 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 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 and 200.329. . . ." 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." Cause Management had not developed, nor implemented a system of internal control that would have ensured compliance with the grant agreement and the Reporting compliance requirement. Effect The failure to establish an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Reporting compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish internal controls to ensure compliance and comply with the grant agreement and the Reporting compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-004 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Number: 84.425 Federal Award Numbers and Years or (Other Identifying Numbers): S425D200013, S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Condition and Context An effective internal control system was not designed, nor implemented at the School Corporation to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. The School Corporation had not designed, nor implemented a system of internal control to ensure that the annual Elementary and Secondary School Emergency Relief (ESSER) annual data reports (Reports) were complete and accurately submitted. The Reports were prepared by one employee without an oversight, or review process in place to detect and correct errors. Additionally, for one of ten key line items tested the School Corporation did not accurately report the information. The Full-time Equivalent (FTE) positions as of March 13, 2020, and September 30, 2020, as required by the ESSER 1, Year 1 annual data report did not agree with the documentation provided. The lack of internal controls was a systemic issue throughout the audit period. The noncompliance was isolated to the ESSER I, Year 1 report. 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 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 and 200.329. . . ." 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." Cause Management had not developed, nor implemented a system of internal control that would have ensured compliance with the grant agreement and the Reporting compliance requirement. Effect The failure to establish an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Reporting compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish internal controls to ensure compliance and comply with the grant agreement and the Reporting compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-004 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Number: 84.425 Federal Award Numbers and Years or (Other Identifying Numbers): S425D200013, S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Condition and Context An effective internal control system was not designed, nor implemented at the School Corporation to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. The School Corporation had not designed, nor implemented a system of internal control to ensure that the annual Elementary and Secondary School Emergency Relief (ESSER) annual data reports (Reports) were complete and accurately submitted. The Reports were prepared by one employee without an oversight, or review process in place to detect and correct errors. Additionally, for one of ten key line items tested the School Corporation did not accurately report the information. The Full-time Equivalent (FTE) positions as of March 13, 2020, and September 30, 2020, as required by the ESSER 1, Year 1 annual data report did not agree with the documentation provided. The lack of internal controls was a systemic issue throughout the audit period. The noncompliance was isolated to the ESSER I, Year 1 report. 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 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 and 200.329. . . ." 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." Cause Management had not developed, nor implemented a system of internal control that would have ensured compliance with the grant agreement and the Reporting compliance requirement. Effect The failure to establish an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Reporting compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish internal controls to ensure compliance and comply with the grant agreement and the Reporting compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
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-002 Subject: Education Stabilization Fund ? Annual Data Report Federal Agency: Department of Education Federal Program: COVID-19 ? Education Stabilization Fund Assistance Listing Number: 84.425D Federal Award Number and Year (or Other Identifying Numbers): S425D200013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Material Weakness Criteria: 2 CFR 200.302(b) 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) " "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: The School Corporation did not have a documented review control in place to ensure the annual data report was reviewed by someone other than the preparer. Cause: There were not sufficient internal controls in place to ensure the Annual Data Report was submitted by the Indiana Department of Education?s deadline. Effect: The failure to establish an effective internal control system placed the School Corporation at risk of noncompliance with the grant agreement and the Reporting compliance requirements. Questioned Costs: There were no questioned costs identified. Context: There was no documented review by someone other than the preparer of the Annual Data Report to ensure the information submitted was complete and accurate. Additionally, the ESSER II Year 1 Annual Data Report submitted to the Indiana Department of Education did not disclose any expenditures and was therefore, understated by approximately $394,000. 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-002 Subject: Education Stabilization Fund ? Annual Data Report Federal Agency: Department of Education Federal Program: COVID-19 ? Education Stabilization Fund Assistance Listing Number: 84.425D Federal Award Number and Year (or Other Identifying Numbers): S425D200013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Material Weakness Criteria: 2 CFR 200.302(b) 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) " "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: The School Corporation did not have a documented review control in place to ensure the annual data report was reviewed by someone other than the preparer. Cause: There were not sufficient internal controls in place to ensure the Annual Data Report was submitted by the Indiana Department of Education?s deadline. Effect: The failure to establish an effective internal control system placed the School Corporation at risk of noncompliance with the grant agreement and the Reporting compliance requirements. Questioned Costs: There were no questioned costs identified. Context: There was no documented review by someone other than the preparer of the Annual Data Report to ensure the information submitted was complete and accurate. Additionally, the ESSER II Year 1 Annual Data Report submitted to the Indiana Department of Education did not disclose any expenditures and was therefore, understated by approximately $394,000. 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.
Criteria: The Uniform Guidance requires nonfederal entities that receive federal awards to establish written policies, procedures, or standards of conduct as described in the following sections: Financial management (2 CFR 200.302) Payment (2 CFR 200.305) General procurement standards (2 CFR 200.318) Competition (2 CFR 200.319) Methods of procurement to be followed (2 CFR 200.320) Compensation ? personal services (2 CFR 200.430) Compensation ? fringe benefits (2 CFR 200.431) Transportation costs (2 CFR 200.474) Condition: The Town did not have written policies, procedures, and standards of conduct relative to federal awards as required by the Uniform Guidance. Cause: The Town was not aware of these requirements. Effect: The Town is not in compliance with the Uniform Guidance with respect to these written policies. Recommendation: We recommend that the Town update its policies and procedures to comply with the Uniform Guidance requirements mentioned above. Management?s Response: We agree that our existing policies do not explicitly address federal award compliance requirements. We will be updating the Town?s procedures and policies to incorporate the requirements of Part 200 of the Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards.
FINDING 2022-006 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Number: 84.425D Federal Award Number and Year (or Other Identifying Number): S425D200013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters INDIANA STATE BOARD OF ACCOUNTS 26 METROPOLITAN SCHOOL DISTRICT OF WARREN COUNTY SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Condition and Context An effective internal control system was not designed nor implemented at the School Corporation to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. The School Corporation had not designed nor implemented a system of internal controls to ensure that the annual Elementary and Secondary School Emergency Relief (ESSER) annual data reports (Reports) were complete and accurately submitted. The Reports were prepared by one employee without an oversight or review process in place to prevent, or detect and correct, errors. Additionally, for two of ten key line items tested, the School Corporation could not provide supporting documentation. The lack of supporting documentation for the full-time equivalent (FTE) key line item on the ESSER I, Year 1 annual data report prevented the determination of the accuracy of the line items. The lack of internal controls was a systemic issue throughout the audit period. The noncompliance was isolated to the ESSER I, Year 1 report. 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 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 and 200.329. . . . (3) Records that identify adequately the source and application of funds for federally funded activities. These records must contain information pertaining to Federal awards, authorizations, obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. . . ." INDIANA STATE BOARD OF ACCOUNTS 27 METROPOLITAN SCHOOL DISTRICT OF WARREN COUNTY SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 2 CFR 200.333 states in part: "Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or annually, from the date of the submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient. . . ." 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." Cause Management had not developed nor implemented a system of internal controls that would have ensured compliance with the grant agreement and Reporting compliance requirement. Effect The failure to establish an effective internal control system enabled noncompliance to go undetected. Noncompliance with the grant agreement and the Reporting compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish internal controls to ensure compliance and comply with the grant agreement and Reporting compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-006 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Number: 84.425D Federal Award Number and Year (or Other Identifying Number): S425D200013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters INDIANA STATE BOARD OF ACCOUNTS 26 METROPOLITAN SCHOOL DISTRICT OF WARREN COUNTY SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Condition and Context An effective internal control system was not designed nor implemented at the School Corporation to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. The School Corporation had not designed nor implemented a system of internal controls to ensure that the annual Elementary and Secondary School Emergency Relief (ESSER) annual data reports (Reports) were complete and accurately submitted. The Reports were prepared by one employee without an oversight or review process in place to prevent, or detect and correct, errors. Additionally, for two of ten key line items tested, the School Corporation could not provide supporting documentation. The lack of supporting documentation for the full-time equivalent (FTE) key line item on the ESSER I, Year 1 annual data report prevented the determination of the accuracy of the line items. The lack of internal controls was a systemic issue throughout the audit period. The noncompliance was isolated to the ESSER I, Year 1 report. 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 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 and 200.329. . . . (3) Records that identify adequately the source and application of funds for federally funded activities. These records must contain information pertaining to Federal awards, authorizations, obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. . . ." INDIANA STATE BOARD OF ACCOUNTS 27 METROPOLITAN SCHOOL DISTRICT OF WARREN COUNTY SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 2 CFR 200.333 states in part: "Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or annually, from the date of the submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient. . . ." 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." Cause Management had not developed nor implemented a system of internal controls that would have ensured compliance with the grant agreement and Reporting compliance requirement. Effect The failure to establish an effective internal control system enabled noncompliance to go undetected. Noncompliance with the grant agreement and the Reporting compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish internal controls to ensure compliance and comply with the grant agreement and Reporting compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-003 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Number: 84.425C Federal Award Number and Year (or Other Identifying Number): S425C200018 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Modified Opinion Condition and Context An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. INDIANA STATE BOARD OF ACCOUNTS 19 LAKE STATION COMMUNITY SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) The School Corporation completed three annual Elementary and Secondary School Emergency Relief (ESSER) and two Governor's Emergency Education Relief (GEER) annual Data Collection reports (Reports) during the audit period. Data on one report, the GEER I, Year 1 annual report, did not agree to unit's ledger. The expenditures reported on the GEER I, Year 1 annual report were $202,500; however, the School Corporation had no expenditures from the GEER fund during the year 1 reporting period. The lack of internal controls and noncompliance were isolated to the GEER I, Year 1 annual report. 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 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 and 200.329. . . ." 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." Cause Management had not established a system of internal controls that would have ensured compliance with the grant agreement and the Reporting compliance requirement. Effect The failure to establish an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Reporting compliance requirement could result in the loss of future federal funds to the School Corporation. INDIANA STATE BOARD OF ACCOUNTS 20 LAKE STATION COMMUNITY SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish internal controls to ensure compliance and comply with the grant agreement and the Reporting compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-006 Subject: Child Nutrition Cluster - Reporting Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program, Summer Food Service Program for Children, COVID-19 - Summer Food Service Program for Children Assistance Listings Numbers: 10.553, 10.555, 10.559 Federal Award Numbers and Years (or Other Identifying Numbers): FY 2020-2021, FY 2021-2022 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Condition and Context An effective system of internal controls was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. Monthly Sponsor Claims for Reimbursement (Claims) were submitted to the Indiana Department of Education (IDOE) based upon meals served for the month. All four Claims tested had differences between the Claims submitted and the School Corporation's summary meal count reports. Meal counts did not match the ledgers provided by the Food Management Service Company (FMSC) nor the internally generated reports of the School Corporation. The lack of internal controls and noncompliance were systemic issues throughout the audit period. 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). . . ." INDIANA STATE BOARD OF ACCOUNTS 26 CENTRAL NOBLE COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 2 CFR 200.302(b) (Uniform Guidance) 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.327 Financial reporting and 200.328 Monitoring and reporting program performance. . . ." 2 CFR 200.302(b) (Revised Uniform Guidance) 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 and 200.329. . . ." Cause Management had not developed a system of internal controls that would have ensured compliance with the grant agreement and the Reporting compliance requirement. Effect The failure to establish an effective system of internal controls enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Reporting compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish a system of internal controls to ensure compliance and comply with the Reporting compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-006 Subject: Child Nutrition Cluster - Reporting Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program, Summer Food Service Program for Children, COVID-19 - Summer Food Service Program for Children Assistance Listings Numbers: 10.553, 10.555, 10.559 Federal Award Numbers and Years (or Other Identifying Numbers): FY 2020-2021, FY 2021-2022 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Condition and Context An effective system of internal controls was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. Monthly Sponsor Claims for Reimbursement (Claims) were submitted to the Indiana Department of Education (IDOE) based upon meals served for the month. All four Claims tested had differences between the Claims submitted and the School Corporation's summary meal count reports. Meal counts did not match the ledgers provided by the Food Management Service Company (FMSC) nor the internally generated reports of the School Corporation. The lack of internal controls and noncompliance were systemic issues throughout the audit period. 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). . . ." INDIANA STATE BOARD OF ACCOUNTS 26 CENTRAL NOBLE COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 2 CFR 200.302(b) (Uniform Guidance) 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.327 Financial reporting and 200.328 Monitoring and reporting program performance. . . ." 2 CFR 200.302(b) (Revised Uniform Guidance) 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 and 200.329. . . ." Cause Management had not developed a system of internal controls that would have ensured compliance with the grant agreement and the Reporting compliance requirement. Effect The failure to establish an effective system of internal controls enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Reporting compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish a system of internal controls to ensure compliance and comply with the Reporting compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-006 Subject: Child Nutrition Cluster - Reporting Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program, Summer Food Service Program for Children, COVID-19 - Summer Food Service Program for Children Assistance Listings Numbers: 10.553, 10.555, 10.559 Federal Award Numbers and Years (or Other Identifying Numbers): FY 2020-2021, FY 2021-2022 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Condition and Context An effective system of internal controls was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. Monthly Sponsor Claims for Reimbursement (Claims) were submitted to the Indiana Department of Education (IDOE) based upon meals served for the month. All four Claims tested had differences between the Claims submitted and the School Corporation's summary meal count reports. Meal counts did not match the ledgers provided by the Food Management Service Company (FMSC) nor the internally generated reports of the School Corporation. The lack of internal controls and noncompliance were systemic issues throughout the audit period. 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). . . ." INDIANA STATE BOARD OF ACCOUNTS 26 CENTRAL NOBLE COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 2 CFR 200.302(b) (Uniform Guidance) 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.327 Financial reporting and 200.328 Monitoring and reporting program performance. . . ." 2 CFR 200.302(b) (Revised Uniform Guidance) 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 and 200.329. . . ." Cause Management had not developed a system of internal controls that would have ensured compliance with the grant agreement and the Reporting compliance requirement. Effect The failure to establish an effective system of internal controls enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Reporting compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish a system of internal controls to ensure compliance and comply with the Reporting compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-006 Subject: Child Nutrition Cluster - Reporting Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program, Summer Food Service Program for Children, COVID-19 - Summer Food Service Program for Children Assistance Listings Numbers: 10.553, 10.555, 10.559 Federal Award Numbers and Years (or Other Identifying Numbers): FY 2020-2021, FY 2021-2022 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Condition and Context An effective system of internal controls was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. Monthly Sponsor Claims for Reimbursement (Claims) were submitted to the Indiana Department of Education (IDOE) based upon meals served for the month. All four Claims tested had differences between the Claims submitted and the School Corporation's summary meal count reports. Meal counts did not match the ledgers provided by the Food Management Service Company (FMSC) nor the internally generated reports of the School Corporation. The lack of internal controls and noncompliance were systemic issues throughout the audit period. 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). . . ." INDIANA STATE BOARD OF ACCOUNTS 26 CENTRAL NOBLE COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 2 CFR 200.302(b) (Uniform Guidance) 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.327 Financial reporting and 200.328 Monitoring and reporting program performance. . . ." 2 CFR 200.302(b) (Revised Uniform Guidance) 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 and 200.329. . . ." Cause Management had not developed a system of internal controls that would have ensured compliance with the grant agreement and the Reporting compliance requirement. Effect The failure to establish an effective system of internal controls enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Reporting compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish a system of internal controls to ensure compliance and comply with the Reporting compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-006 Subject: Child Nutrition Cluster - Reporting Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program, Summer Food Service Program for Children, COVID-19 - Summer Food Service Program for Children Assistance Listings Numbers: 10.553, 10.555, 10.559 Federal Award Numbers and Years (or Other Identifying Numbers): FY 2020-2021, FY 2021-2022 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Condition and Context An effective system of internal controls was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. Monthly Sponsor Claims for Reimbursement (Claims) were submitted to the Indiana Department of Education (IDOE) based upon meals served for the month. All four Claims tested had differences between the Claims submitted and the School Corporation's summary meal count reports. Meal counts did not match the ledgers provided by the Food Management Service Company (FMSC) nor the internally generated reports of the School Corporation. The lack of internal controls and noncompliance were systemic issues throughout the audit period. 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). . . ." INDIANA STATE BOARD OF ACCOUNTS 26 CENTRAL NOBLE COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 2 CFR 200.302(b) (Uniform Guidance) 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.327 Financial reporting and 200.328 Monitoring and reporting program performance. . . ." 2 CFR 200.302(b) (Revised Uniform Guidance) 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 and 200.329. . . ." Cause Management had not developed a system of internal controls that would have ensured compliance with the grant agreement and the Reporting compliance requirement. Effect The failure to establish an effective system of internal controls enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Reporting compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish a system of internal controls to ensure compliance and comply with the Reporting compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-006 Subject: Child Nutrition Cluster - Reporting Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program, Summer Food Service Program for Children, COVID-19 - Summer Food Service Program for Children Assistance Listings Numbers: 10.553, 10.555, 10.559 Federal Award Numbers and Years (or Other Identifying Numbers): FY 2020-2021, FY 2021-2022 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Condition and Context An effective system of internal controls was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. Monthly Sponsor Claims for Reimbursement (Claims) were submitted to the Indiana Department of Education (IDOE) based upon meals served for the month. All four Claims tested had differences between the Claims submitted and the School Corporation's summary meal count reports. Meal counts did not match the ledgers provided by the Food Management Service Company (FMSC) nor the internally generated reports of the School Corporation. The lack of internal controls and noncompliance were systemic issues throughout the audit period. 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). . . ." INDIANA STATE BOARD OF ACCOUNTS 26 CENTRAL NOBLE COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 2 CFR 200.302(b) (Uniform Guidance) 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.327 Financial reporting and 200.328 Monitoring and reporting program performance. . . ." 2 CFR 200.302(b) (Revised Uniform Guidance) 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 and 200.329. . . ." Cause Management had not developed a system of internal controls that would have ensured compliance with the grant agreement and the Reporting compliance requirement. Effect The failure to establish an effective system of internal controls enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Reporting compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish a system of internal controls to ensure compliance and comply with the Reporting compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-005 Subject: Title I Grants to Local Educational Agencies - Reporting Federal Agency: Department of Education Federal Program: Title I Grants to Local Educational Agencies Assistance Listings Number: 84.010 Federal Award Number and Year (or Other Identifying Number): S010A200014 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Condition and Context An effective internal control system was not designed, or implemented at the School Corporation to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. Total expenditures reported on the 2020-2021 Final Expenditure Report (Report) were not supported by the School Corporation's ledgers. Total expenditures on the Report were $578,452 whereas expenditures per the ledgers were $677,514. The lack of internal controls and noncompliance were systemic issues throughout the audit period. 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). . . ." INDIANA STATE BOARD OF ACCOUNTS 21 CONCORD COMMUNITY SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 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 and 200.329. . . ." 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." 2 CFR 200.334 states in part: "Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or annually, from the date of the submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient. . . ." 34 CFR 76.731 states: "A State and a subgrantee shall keep records to show its compliance with program requirements." Cause Management had not developed a system of internal controls that would have ensured compliance with the Reporting compliance requirement. Effect The failure to establish an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Reporting compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish a system of internal controls to ensure compliance and comply with the grant agreement and the Reporting compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-002 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers) S425D200013,S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Condition and Context An effective internal controls system was not designed, nor implemented at the School Corporation to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. The School Corporation had not designed, nor implemented a system of internal control to ensure that the annual Elementary and Secondary School Emergency Relief (ESSER) annual Data Collection reports (Reports) were complete and accurately submitted. The Reports were prepared by one employee without an oversight or review process in place to prevent, or detect and correct, errors. Additionally, for one of seven key line items tested the School Corporation could not provide supporting documentation. The lack of supporting documentation for the full time equivalent(FTE) key line item on the ESSER I, Year 1, annual report prevented the determination of the accuracy of the line item. The lack of internal controls was a systemic issue throughout the audit period. The noncompliance was isolated to the ESSER 1, Year 1 report. 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 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 and 200.329. . . ." 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." Cause Management had not developed or implemented a system of internal controls that would have ensured compliance with the grant agreement and the Reporting compliance requirement. Effect The failure to establish an effective internal controls system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and Reporting compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish internal controls to ensure compliance and comply with the grant agreement and the Reporting compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-002 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers) S425D200013,S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Condition and Context An effective internal controls system was not designed, nor implemented at the School Corporation to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. The School Corporation had not designed, nor implemented a system of internal control to ensure that the annual Elementary and Secondary School Emergency Relief (ESSER) annual Data Collection reports (Reports) were complete and accurately submitted. The Reports were prepared by one employee without an oversight or review process in place to prevent, or detect and correct, errors. Additionally, for one of seven key line items tested the School Corporation could not provide supporting documentation. The lack of supporting documentation for the full time equivalent(FTE) key line item on the ESSER I, Year 1, annual report prevented the determination of the accuracy of the line item. The lack of internal controls was a systemic issue throughout the audit period. The noncompliance was isolated to the ESSER 1, Year 1 report. 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 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 and 200.329. . . ." 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." Cause Management had not developed or implemented a system of internal controls that would have ensured compliance with the grant agreement and the Reporting compliance requirement. Effect The failure to establish an effective internal controls system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and Reporting compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish internal controls to ensure compliance and comply with the grant agreement and the Reporting compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-002 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers) S425D200013,S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Condition and Context An effective internal controls system was not designed, nor implemented at the School Corporation to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. The School Corporation had not designed, nor implemented a system of internal control to ensure that the annual Elementary and Secondary School Emergency Relief (ESSER) annual Data Collection reports (Reports) were complete and accurately submitted. The Reports were prepared by one employee without an oversight or review process in place to prevent, or detect and correct, errors. Additionally, for one of seven key line items tested the School Corporation could not provide supporting documentation. The lack of supporting documentation for the full time equivalent(FTE) key line item on the ESSER I, Year 1, annual report prevented the determination of the accuracy of the line item. The lack of internal controls was a systemic issue throughout the audit period. The noncompliance was isolated to the ESSER 1, Year 1 report. 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 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 and 200.329. . . ." 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." Cause Management had not developed or implemented a system of internal controls that would have ensured compliance with the grant agreement and the Reporting compliance requirement. Effect The failure to establish an effective internal controls system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and Reporting compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish internal controls to ensure compliance and comply with the grant agreement and the Reporting compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
Reference Number: 2022-022 Prior Year Finding: No Federal Agency: U.S. Department of Education State Agency: Agency of Education (Agency) Federal Program: Title I Grants to Local Educational Agencies Assistance Listing Number: 84.010 Award Number and Year: S010A200045 (7/1/2020 ? 9/30/2021) S01A210045 (7/1/2021-9/30/2022) Compliance Requirement: Reporting ? Financial Reporting Type of Finding Significant Deficiency in Internal Control Over Compliance, Other Matters Criteria or specific requirement: Compliance: Per 2 CFR 200.302, each state must expend and account for the Federal award in accordance with state laws and procedures for expending and accounting for the state's own funds. In addition, the state's and the other non-Federal entity's financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. Recipients of U.S. Department of Education funds use the G5 system to simultaneously request cash reimbursements and report expenditures. The G5 system is in lieu of the SF-270 ? Request for Advance or Reimbursement. 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 Agency of Education (Agency) was not able to support that the amount it had reported for drawdown in the G5 system was accurate and was supported by expenditures recorded in its accounting system and reported on the Schedule of Expenditures of Federal Awards (SEFA). The total draws by the Agency were less than the total expenditures on the SEFA. Context: The Agency of Education (Agency) was unable to provide supporting documentation for the amount it had reported and drawn down in the G5 system for the program as compared to expenditures it had incurred and reported on the Schedule of Expenditures of Federal Awards (SEFA). Auditors noted the total reported draws were $5.9 million (approximately 16%) less than expenditures reported on the SEFA. The Agency was unable to reconcile this variance. Cause: The Agency?s procedures and internal controls were not sufficient to account for timing differences and ensure that cash draws were complete, accurate and tied to expenditures incurred in its accounting system as reported on the SEFA. Effect: Auditors were unable to verify that cash draws in the G5 system were complete, accurate and supported by documentation recorded in the Agency?s accounting system. Questioned costs: Undetermined. Recommendation: We recommend the Agency review and enhance internal controls and procedures over financial reporting to ensure that cash draws requested in the G5 system are complete, accurate, and that supporting documentation is maintained and agrees with expenditures recorded in its accounting system. Views of responsible officials: Management agrees with the finding.
Identification of the Federal Programs: Assistance Listing Number: 20.507 Assistance Listing Title: Federal Transit Cluster Federal Agency: U.S. Department of Transportation Pass-Through Entity: N/A Federal Award Identification Number: CA-2017-149-00; CA-90-Z085-00; CA-90-Y974-00; CA -2019-033-00; CA -90-Y900-00; CA-2020-177-00; CA-2021-169-01; CA-2022-041-00; CA-2021-075-00 Assistance Listing Number: 21.027 Assistance Listing Title: Coronavirus State and Local Fiscal Recovery Funds Federal Agency: U.S. Department of the Treasury Pass-Through Entity: N/A Federal Award Identification Number: 1505-0271 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): In accordance with 2 CFR ?200.303 Internal Controls, 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). Under ?200.302 Financial Management, (b) (3) Records that identify adequately the source and application of funds for federally-funded activities. These records must contain information pertaining to Federal awards, authorizations, financial obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. Under ?200.430(i) Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity. Condition: During the audit, we could not verify if the Bus Operators? and Police Officers? timecards were properly approved by their supervisors. The timecard reports were uploaded from the time entry system to the payroll module by the supervisors; however, there were no records on who reviewed the timecard reports or completed the upload of the timecard reports to the payroll module. Additionally, 8 out of 25 Police Officers? personnel action forms could not be located. Cause: The Bus Line and Police Departments did not have formal policies and procedures over the timecard approval process. There was also ineffective monitoring of human resources processes, including the maintenance of personnel action forms. Effect or Potential Effect: Without approved personnel action forms and review or approval of time cards, inaccurate payroll expenditures could be charged to the federal programs. Questioned Costs: None noted. Context: See condition above for the context of the finding. Identification as a Repeat Finding, If Applicable: Not applicable. Recommendation: We recommended the City adopt formal policies and procedures on the documentation of timecard approval process for the Bus Line and Police Departments. The City should also implement regular monitoring and conduct periodic reviews of personnel files to verify the presence and completeness of personnel action forms. Views of Responsible Officials: Management has reviewed the payroll/timecard approval process. The City utilizes New World Systems eSuites for employees to enter their bi-weekly hours, and for employees and supervisors to approve timesheets. However, not all employees can utilize eSuites, as the requirements for timekeeping for Bus Operators, Police and Fire personnel is such that separate timekeeping systems must be maintained and utilized. To that end, staff has initiated a process whereby ? for employees not using eSuites ? manual review and approval of bi-weekly hours is conducted by supervisors in the appropriate department (i.e., Transit, Police, etc.). Management believes this additional review and approval level will provide the necessary back-up to improve internal control over timecards/timekeeping.
Identification of the Federal Programs: Assistance Listing Number: 20.507 Assistance Listing Title: Federal Transit Cluster Federal Agency: U.S. Department of Transportation Pass-Through Entity: N/A Federal Award Identification Number: CA-2017-149-00; CA-90-Z085-00; CA-90-Y974-00; CA -2019-033-00; CA -90-Y900-00; CA-2020-177-00; CA-2021-169-01; CA-2022-041-00; CA-2021-075-00 Assistance Listing Number: 21.027 Assistance Listing Title: Coronavirus State and Local Fiscal Recovery Funds Federal Agency: U.S. Department of the Treasury Pass-Through Entity: N/A Federal Award Identification Number: 1505-0271 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): In accordance with 2 CFR ?200.303 Internal Controls, 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). Under ?200.302 Financial Management, (b) (3) Records that identify adequately the source and application of funds for federally-funded activities. These records must contain information pertaining to Federal awards, authorizations, financial obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. Under ?200.430(i) Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity. Condition: During the audit, we could not verify if the Bus Operators? and Police Officers? timecards were properly approved by their supervisors. The timecard reports were uploaded from the time entry system to the payroll module by the supervisors; however, there were no records on who reviewed the timecard reports or completed the upload of the timecard reports to the payroll module. Additionally, 8 out of 25 Police Officers? personnel action forms could not be located. Cause: The Bus Line and Police Departments did not have formal policies and procedures over the timecard approval process. There was also ineffective monitoring of human resources processes, including the maintenance of personnel action forms. Effect or Potential Effect: Without approved personnel action forms and review or approval of time cards, inaccurate payroll expenditures could be charged to the federal programs. Questioned Costs: None noted. Context: See condition above for the context of the finding. Identification as a Repeat Finding, If Applicable: Not applicable. Recommendation: We recommended the City adopt formal policies and procedures on the documentation of timecard approval process for the Bus Line and Police Departments. The City should also implement regular monitoring and conduct periodic reviews of personnel files to verify the presence and completeness of personnel action forms. Views of Responsible Officials: Management has reviewed the payroll/timecard approval process. The City utilizes New World Systems eSuites for employees to enter their bi-weekly hours, and for employees and supervisors to approve timesheets. However, not all employees can utilize eSuites, as the requirements for timekeeping for Bus Operators, Police and Fire personnel is such that separate timekeeping systems must be maintained and utilized. To that end, staff has initiated a process whereby ? for employees not using eSuites ? manual review and approval of bi-weekly hours is conducted by supervisors in the appropriate department (i.e., Transit, Police, etc.). Management believes this additional review and approval level will provide the necessary back-up to improve internal control over timecards/timekeeping.
Identification of the Federal Programs: Assistance Listing Number: 20.507 Assistance Listing Title: Federal Transit Cluster Federal Agency: U.S. Department of Transportation Pass-Through Entity: N/A Federal Award Identification Number: CA-2017-149-00; CA-90-Z085-00; CA-90-Y974-00; CA -2019-033-00; CA -90-Y900-00; CA-2020-177-00; CA-2021-169-01; CA-2022-041-00; CA-2021-075-00 Assistance Listing Number: 21.027 Assistance Listing Title: Coronavirus State and Local Fiscal Recovery Funds Federal Agency: U.S. Department of the Treasury Pass-Through Entity: N/A Federal Award Identification Number: 1505-0271 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): In accordance with 2 CFR ?200.303 Internal Controls, 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). Under ?200.302 Financial Management, (b) (3) Records that identify adequately the source and application of funds for federally-funded activities. These records must contain information pertaining to Federal awards, authorizations, financial obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. Under ?200.430(i) Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity. Condition: During the audit, we could not verify if the Bus Operators? and Police Officers? timecards were properly approved by their supervisors. The timecard reports were uploaded from the time entry system to the payroll module by the supervisors; however, there were no records on who reviewed the timecard reports or completed the upload of the timecard reports to the payroll module. Additionally, 8 out of 25 Police Officers? personnel action forms could not be located. Cause: The Bus Line and Police Departments did not have formal policies and procedures over the timecard approval process. There was also ineffective monitoring of human resources processes, including the maintenance of personnel action forms. Effect or Potential Effect: Without approved personnel action forms and review or approval of time cards, inaccurate payroll expenditures could be charged to the federal programs. Questioned Costs: None noted. Context: See condition above for the context of the finding. Identification as a Repeat Finding, If Applicable: Not applicable. Recommendation: We recommended the City adopt formal policies and procedures on the documentation of timecard approval process for the Bus Line and Police Departments. The City should also implement regular monitoring and conduct periodic reviews of personnel files to verify the presence and completeness of personnel action forms. Views of Responsible Officials: Management has reviewed the payroll/timecard approval process. The City utilizes New World Systems eSuites for employees to enter their bi-weekly hours, and for employees and supervisors to approve timesheets. However, not all employees can utilize eSuites, as the requirements for timekeeping for Bus Operators, Police and Fire personnel is such that separate timekeeping systems must be maintained and utilized. To that end, staff has initiated a process whereby ? for employees not using eSuites ? manual review and approval of bi-weekly hours is conducted by supervisors in the appropriate department (i.e., Transit, Police, etc.). Management believes this additional review and approval level will provide the necessary back-up to improve internal control over timecards/timekeeping.
Identification of the Federal Programs: Assistance Listing Number: 20.507 Assistance Listing Title: Federal Transit Cluster Federal Agency: U.S. Department of Transportation Pass-Through Entity: N/A Federal Award Identification Number: CA-2017-149-00; CA-90-Z085-00; CA-90-Y974-00; CA -2019-033-00; CA -90-Y900-00; CA-2020-177-00; CA-2021-169-01; CA-2022-041-00; CA-2021-075-00 Assistance Listing Number: 21.027 Assistance Listing Title: Coronavirus State and Local Fiscal Recovery Funds Federal Agency: U.S. Department of the Treasury Pass-Through Entity: N/A Federal Award Identification Number: 1505-0271 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): In accordance with 2 CFR ?200.303 Internal Controls, 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). Under ?200.302 Financial Management, (b) (3) Records that identify adequately the source and application of funds for federally-funded activities. These records must contain information pertaining to Federal awards, authorizations, financial obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. Under ?200.430(i) Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity. Condition: During the audit, we could not verify if the Bus Operators? and Police Officers? timecards were properly approved by their supervisors. The timecard reports were uploaded from the time entry system to the payroll module by the supervisors; however, there were no records on who reviewed the timecard reports or completed the upload of the timecard reports to the payroll module. Additionally, 8 out of 25 Police Officers? personnel action forms could not be located. Cause: The Bus Line and Police Departments did not have formal policies and procedures over the timecard approval process. There was also ineffective monitoring of human resources processes, including the maintenance of personnel action forms. Effect or Potential Effect: Without approved personnel action forms and review or approval of time cards, inaccurate payroll expenditures could be charged to the federal programs. Questioned Costs: None noted. Context: See condition above for the context of the finding. Identification as a Repeat Finding, If Applicable: Not applicable. Recommendation: We recommended the City adopt formal policies and procedures on the documentation of timecard approval process for the Bus Line and Police Departments. The City should also implement regular monitoring and conduct periodic reviews of personnel files to verify the presence and completeness of personnel action forms. Views of Responsible Officials: Management has reviewed the payroll/timecard approval process. The City utilizes New World Systems eSuites for employees to enter their bi-weekly hours, and for employees and supervisors to approve timesheets. However, not all employees can utilize eSuites, as the requirements for timekeeping for Bus Operators, Police and Fire personnel is such that separate timekeeping systems must be maintained and utilized. To that end, staff has initiated a process whereby ? for employees not using eSuites ? manual review and approval of bi-weekly hours is conducted by supervisors in the appropriate department (i.e., Transit, Police, etc.). Management believes this additional review and approval level will provide the necessary back-up to improve internal control over timecards/timekeeping.
Identification of the Federal Programs: Assistance Listing Number: 20.507 Assistance Listing Title: Federal Transit Cluster Federal Agency: U.S. Department of Transportation Pass-Through Entity: N/A Federal Award Identification Number: CA-2017-149-00; CA-90-Z085-00; CA-90-Y974-00; CA -2019-033-00; CA -90-Y900-00; CA-2020-177-00; CA-2021-169-01; CA-2022-041-00; CA-2021-075-00 Assistance Listing Number: 21.027 Assistance Listing Title: Coronavirus State and Local Fiscal Recovery Funds Federal Agency: U.S. Department of the Treasury Pass-Through Entity: N/A Federal Award Identification Number: 1505-0271 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): In accordance with 2 CFR ?200.303 Internal Controls, 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). Under ?200.302 Financial Management, (b) (3) Records that identify adequately the source and application of funds for federally-funded activities. These records must contain information pertaining to Federal awards, authorizations, financial obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. Under ?200.430(i) Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity. Condition: During the audit, we could not verify if the Bus Operators? and Police Officers? timecards were properly approved by their supervisors. The timecard reports were uploaded from the time entry system to the payroll module by the supervisors; however, there were no records on who reviewed the timecard reports or completed the upload of the timecard reports to the payroll module. Additionally, 8 out of 25 Police Officers? personnel action forms could not be located. Cause: The Bus Line and Police Departments did not have formal policies and procedures over the timecard approval process. There was also ineffective monitoring of human resources processes, including the maintenance of personnel action forms. Effect or Potential Effect: Without approved personnel action forms and review or approval of time cards, inaccurate payroll expenditures could be charged to the federal programs. Questioned Costs: None noted. Context: See condition above for the context of the finding. Identification as a Repeat Finding, If Applicable: Not applicable. Recommendation: We recommended the City adopt formal policies and procedures on the documentation of timecard approval process for the Bus Line and Police Departments. The City should also implement regular monitoring and conduct periodic reviews of personnel files to verify the presence and completeness of personnel action forms. Views of Responsible Officials: Management has reviewed the payroll/timecard approval process. The City utilizes New World Systems eSuites for employees to enter their bi-weekly hours, and for employees and supervisors to approve timesheets. However, not all employees can utilize eSuites, as the requirements for timekeeping for Bus Operators, Police and Fire personnel is such that separate timekeeping systems must be maintained and utilized. To that end, staff has initiated a process whereby ? for employees not using eSuites ? manual review and approval of bi-weekly hours is conducted by supervisors in the appropriate department (i.e., Transit, Police, etc.). Management believes this additional review and approval level will provide the necessary back-up to improve internal control over timecards/timekeeping.
Identification of the Federal Programs: Assistance Listing Number: 20.507 Assistance Listing Title: Federal Transit Cluster Federal Agency: U.S. Department of Transportation Pass-Through Entity: N/A Federal Award Identification Number: CA-2017-149-00; CA-90-Z085-00; CA-90-Y974-00; CA -2019-033-00; CA -90-Y900-00; CA-2020-177-00; CA-2021-169-01; CA-2022-041-00; CA-2021-075-00 Assistance Listing Number: 21.027 Assistance Listing Title: Coronavirus State and Local Fiscal Recovery Funds Federal Agency: U.S. Department of the Treasury Pass-Through Entity: N/A Federal Award Identification Number: 1505-0271 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): In accordance with 2 CFR ?200.303 Internal Controls, 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). Under ?200.302 Financial Management, (b) (3) Records that identify adequately the source and application of funds for federally-funded activities. These records must contain information pertaining to Federal awards, authorizations, financial obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. Under ?200.430(i) Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity. Condition: During the audit, we could not verify if the Bus Operators? and Police Officers? timecards were properly approved by their supervisors. The timecard reports were uploaded from the time entry system to the payroll module by the supervisors; however, there were no records on who reviewed the timecard reports or completed the upload of the timecard reports to the payroll module. Additionally, 8 out of 25 Police Officers? personnel action forms could not be located. Cause: The Bus Line and Police Departments did not have formal policies and procedures over the timecard approval process. There was also ineffective monitoring of human resources processes, including the maintenance of personnel action forms. Effect or Potential Effect: Without approved personnel action forms and review or approval of time cards, inaccurate payroll expenditures could be charged to the federal programs. Questioned Costs: None noted. Context: See condition above for the context of the finding. Identification as a Repeat Finding, If Applicable: Not applicable. Recommendation: We recommended the City adopt formal policies and procedures on the documentation of timecard approval process for the Bus Line and Police Departments. The City should also implement regular monitoring and conduct periodic reviews of personnel files to verify the presence and completeness of personnel action forms. Views of Responsible Officials: Management has reviewed the payroll/timecard approval process. The City utilizes New World Systems eSuites for employees to enter their bi-weekly hours, and for employees and supervisors to approve timesheets. However, not all employees can utilize eSuites, as the requirements for timekeeping for Bus Operators, Police and Fire personnel is such that separate timekeeping systems must be maintained and utilized. To that end, staff has initiated a process whereby ? for employees not using eSuites ? manual review and approval of bi-weekly hours is conducted by supervisors in the appropriate department (i.e., Transit, Police, etc.). Management believes this additional review and approval level will provide the necessary back-up to improve internal control over timecards/timekeeping.
Identification of the Federal Programs: Assistance Listing Number: 20.507 Assistance Listing Title: Federal Transit Cluster Federal Agency: U.S. Department of Transportation Pass-Through Entity: N/A Federal Award Identification Number: CA-2017-149-00; CA-90-Z085-00; CA-90-Y974-00; CA -2019-033-00; CA -90-Y900-00; CA-2020-177-00; CA-2021-169-01; CA-2022-041-00; CA-2021-075-00 Assistance Listing Number: 21.027 Assistance Listing Title: Coronavirus State and Local Fiscal Recovery Funds Federal Agency: U.S. Department of the Treasury Pass-Through Entity: N/A Federal Award Identification Number: 1505-0271 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): In accordance with 2 CFR ?200.303 Internal Controls, 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). Under ?200.302 Financial Management, (b) (3) Records that identify adequately the source and application of funds for federally-funded activities. These records must contain information pertaining to Federal awards, authorizations, financial obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. Under ?200.430(i) Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity. Condition: During the audit, we could not verify if the Bus Operators? and Police Officers? timecards were properly approved by their supervisors. The timecard reports were uploaded from the time entry system to the payroll module by the supervisors; however, there were no records on who reviewed the timecard reports or completed the upload of the timecard reports to the payroll module. Additionally, 8 out of 25 Police Officers? personnel action forms could not be located. Cause: The Bus Line and Police Departments did not have formal policies and procedures over the timecard approval process. There was also ineffective monitoring of human resources processes, including the maintenance of personnel action forms. Effect or Potential Effect: Without approved personnel action forms and review or approval of time cards, inaccurate payroll expenditures could be charged to the federal programs. Questioned Costs: None noted. Context: See condition above for the context of the finding. Identification as a Repeat Finding, If Applicable: Not applicable. Recommendation: We recommended the City adopt formal policies and procedures on the documentation of timecard approval process for the Bus Line and Police Departments. The City should also implement regular monitoring and conduct periodic reviews of personnel files to verify the presence and completeness of personnel action forms. Views of Responsible Officials: Management has reviewed the payroll/timecard approval process. The City utilizes New World Systems eSuites for employees to enter their bi-weekly hours, and for employees and supervisors to approve timesheets. However, not all employees can utilize eSuites, as the requirements for timekeeping for Bus Operators, Police and Fire personnel is such that separate timekeeping systems must be maintained and utilized. To that end, staff has initiated a process whereby ? for employees not using eSuites ? manual review and approval of bi-weekly hours is conducted by supervisors in the appropriate department (i.e., Transit, Police, etc.). Management believes this additional review and approval level will provide the necessary back-up to improve internal control over timecards/timekeeping.
Identification of the Federal Programs: Assistance Listing Number: 20.507 Assistance Listing Title: Federal Transit Cluster Federal Agency: U.S. Department of Transportation Pass-Through Entity: N/A Federal Award Identification Number: CA-2017-149-00; CA-90-Z085-00; CA-90-Y974-00; CA -2019-033-00; CA -90-Y900-00; CA-2020-177-00; CA-2021-169-01; CA-2022-041-00; CA-2021-075-00 Assistance Listing Number: 21.027 Assistance Listing Title: Coronavirus State and Local Fiscal Recovery Funds Federal Agency: U.S. Department of the Treasury Pass-Through Entity: N/A Federal Award Identification Number: 1505-0271 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): In accordance with 2 CFR ?200.303 Internal Controls, 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). Under ?200.302 Financial Management, (b) (3) Records that identify adequately the source and application of funds for federally-funded activities. These records must contain information pertaining to Federal awards, authorizations, financial obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. Under ?200.430(i) Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity. Condition: During the audit, we could not verify if the Bus Operators? and Police Officers? timecards were properly approved by their supervisors. The timecard reports were uploaded from the time entry system to the payroll module by the supervisors; however, there were no records on who reviewed the timecard reports or completed the upload of the timecard reports to the payroll module. Additionally, 8 out of 25 Police Officers? personnel action forms could not be located. Cause: The Bus Line and Police Departments did not have formal policies and procedures over the timecard approval process. There was also ineffective monitoring of human resources processes, including the maintenance of personnel action forms. Effect or Potential Effect: Without approved personnel action forms and review or approval of time cards, inaccurate payroll expenditures could be charged to the federal programs. Questioned Costs: None noted. Context: See condition above for the context of the finding. Identification as a Repeat Finding, If Applicable: Not applicable. Recommendation: We recommended the City adopt formal policies and procedures on the documentation of timecard approval process for the Bus Line and Police Departments. The City should also implement regular monitoring and conduct periodic reviews of personnel files to verify the presence and completeness of personnel action forms. Views of Responsible Officials: Management has reviewed the payroll/timecard approval process. The City utilizes New World Systems eSuites for employees to enter their bi-weekly hours, and for employees and supervisors to approve timesheets. However, not all employees can utilize eSuites, as the requirements for timekeeping for Bus Operators, Police and Fire personnel is such that separate timekeeping systems must be maintained and utilized. To that end, staff has initiated a process whereby ? for employees not using eSuites ? manual review and approval of bi-weekly hours is conducted by supervisors in the appropriate department (i.e., Transit, Police, etc.). Management believes this additional review and approval level will provide the necessary back-up to improve internal control over timecards/timekeeping.
Identification of the Federal Programs: Assistance Listing Number: 20.507 Assistance Listing Title: Federal Transit Cluster Federal Agency: U.S. Department of Transportation Pass-Through Entity: N/A Federal Award Identification Number: CA-2017-149-00; CA-90-Z085-00; CA-90-Y974-00; CA -2019-033-00; CA -90-Y900-00; CA-2020-177-00; CA-2021-169-01; CA-2022-041-00; CA-2021-075-00 Assistance Listing Number: 21.027 Assistance Listing Title: Coronavirus State and Local Fiscal Recovery Funds Federal Agency: U.S. Department of the Treasury Pass-Through Entity: N/A Federal Award Identification Number: 1505-0271 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): In accordance with 2 CFR ?200.303 Internal Controls, 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). Under ?200.302 Financial Management, (b) (3) Records that identify adequately the source and application of funds for federally-funded activities. These records must contain information pertaining to Federal awards, authorizations, financial obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. Under ?200.430(i) Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity. Condition: During the audit, we could not verify if the Bus Operators? and Police Officers? timecards were properly approved by their supervisors. The timecard reports were uploaded from the time entry system to the payroll module by the supervisors; however, there were no records on who reviewed the timecard reports or completed the upload of the timecard reports to the payroll module. Additionally, 8 out of 25 Police Officers? personnel action forms could not be located. Cause: The Bus Line and Police Departments did not have formal policies and procedures over the timecard approval process. There was also ineffective monitoring of human resources processes, including the maintenance of personnel action forms. Effect or Potential Effect: Without approved personnel action forms and review or approval of time cards, inaccurate payroll expenditures could be charged to the federal programs. Questioned Costs: None noted. Context: See condition above for the context of the finding. Identification as a Repeat Finding, If Applicable: Not applicable. Recommendation: We recommended the City adopt formal policies and procedures on the documentation of timecard approval process for the Bus Line and Police Departments. The City should also implement regular monitoring and conduct periodic reviews of personnel files to verify the presence and completeness of personnel action forms. Views of Responsible Officials: Management has reviewed the payroll/timecard approval process. The City utilizes New World Systems eSuites for employees to enter their bi-weekly hours, and for employees and supervisors to approve timesheets. However, not all employees can utilize eSuites, as the requirements for timekeeping for Bus Operators, Police and Fire personnel is such that separate timekeeping systems must be maintained and utilized. To that end, staff has initiated a process whereby ? for employees not using eSuites ? manual review and approval of bi-weekly hours is conducted by supervisors in the appropriate department (i.e., Transit, Police, etc.). Management believes this additional review and approval level will provide the necessary back-up to improve internal control over timecards/timekeeping.
FA 2022-001 Improve Controls over Cash Management Compliance Requirement: Cash Management Internal Control Impact: Significant Deficiency Compliance Impact: Nonmaterial Noncompliance Federal Awarding Agency: U.S. Department of Education Pass-Through Entity: Georgia Department of Education AL Numbers and Titles: COVID-19 ? 84.425D ? Elementary and Secondary School Emergency Relief Fund COVID-19 ? 84.425U ? American Rescue Plan Elementary and Secondary School Emergency Relief Fund Federal Award Numbers: S425D210012 (Year: 2021), S425U210012 (Year: 2021) Questioned Costs: $195,559 Description: The School District made cash drawdowns in excess of the immediate cash needs of the Elementary and Secondary School Emergency Relief Fund program. Background Information: The School District may request Elementary and Secondary School Emergency Relief (ESSER) Fund program funds from the Georgia Department of Education (GaDOE) once per month. GaDOE requires the School District to submit DE-0147 ? Requests for Reimbursement of Monthly Cash Disbursements through the Grants Accounting Online Reporting System to receive program funds. When a DE-0147 request is submitted and approved, the ESSER program funds are typically disbursed to the School District through an electronic payment process the next week. The School District submitted DE-0147 requests to receive a total of $4,407,030 in ESSER program funds from GaDOE for the fiscal year under review. Criteria: As a recipient of federal awards, the School District is required to establish and maintain effective internal control over federal awards that provides reasonable assurance of managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards pursuant to Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance), Section 200.303 ? Internal Controls. Provisions included in the Uniform Guidance Section 200.305(b) state that for ?For non-Federal entities other than states, payments methods must minimize the time elapsing between the transfer of funds from? the pass-through entity and the disbursement by the non-Federal entity.? In addition, the Uniform Guidance Section 200.302(b)(6) requires that the entity develop written cash management procedures. Condition: Upon testing ESSER program revenues and expenditures recorded on the financial statements, potential deficiencies in the cash management process were identified. Therefore, a review of all cash drawdowns and disbursements related to the ESSER program was performed to determine if any excessive drawdowns were made during the year under review. Excessive drawdown requests totaling $195,559 were identified. Cause: Drawdowns in excess of expenditures were caused by an error made by School District personnel when requesting ESSER funds. These excessive drawdowns were primarily the result of the School District requesting reimbursement for expenditures that had not been incurred by year end. Effect: The School District was not in compliance with the Uniform Guidance and GaDOE guidance. In addition, the School District could potentially accrue an interest liability that would be owed back to the federal government. Furthermore, when the School District cannot meet the requirement to minimize the time elapsing between the transfer of funds and disbursement of those funds, provisions included in the Uniform Guidance allow GaDOE to change the method by which the School District is transferred funds and delay the School District?s receipt of these funds. This may include requirement by GaDOE to submit invoices prior to being reimbursed for ESSER program expenditures. Recommendation: The School District should establish procedures to accurately forecast the cash needs of the ESSER program and minimize the time elapsing between the transfer of funds from GaDOE and the disbursement of such funds by the School District. In addition, these procedures should be documented in writing in accordance with the Uniform Guidance Section 200.302(b)(6). Furthermore, management should develop and implement a monitoring process to ensure that these procedures are followed. Views of Responsible Officials: We concur with this finding.
FA 2022-001 Improve Controls over Cash Management Compliance Requirement: Cash Management Internal Control Impact: Significant Deficiency Compliance Impact: Nonmaterial Noncompliance Federal Awarding Agency: U.S. Department of Education Pass-Through Entity: Georgia Department of Education AL Numbers and Titles: COVID-19 ? 84.425D ? Elementary and Secondary School Emergency Relief Fund COVID-19 ? 84.425U ? American Rescue Plan Elementary and Secondary School Emergency Relief Fund Federal Award Numbers: S425D210012 (Year: 2021), S425U210012 (Year: 2021) Questioned Costs: $195,559 Description: The School District made cash drawdowns in excess of the immediate cash needs of the Elementary and Secondary School Emergency Relief Fund program. Background Information: The School District may request Elementary and Secondary School Emergency Relief (ESSER) Fund program funds from the Georgia Department of Education (GaDOE) once per month. GaDOE requires the School District to submit DE-0147 ? Requests for Reimbursement of Monthly Cash Disbursements through the Grants Accounting Online Reporting System to receive program funds. When a DE-0147 request is submitted and approved, the ESSER program funds are typically disbursed to the School District through an electronic payment process the next week. The School District submitted DE-0147 requests to receive a total of $4,407,030 in ESSER program funds from GaDOE for the fiscal year under review. Criteria: As a recipient of federal awards, the School District is required to establish and maintain effective internal control over federal awards that provides reasonable assurance of managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards pursuant to Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance), Section 200.303 ? Internal Controls. Provisions included in the Uniform Guidance Section 200.305(b) state that for ?For non-Federal entities other than states, payments methods must minimize the time elapsing between the transfer of funds from? the pass-through entity and the disbursement by the non-Federal entity.? In addition, the Uniform Guidance Section 200.302(b)(6) requires that the entity develop written cash management procedures. Condition: Upon testing ESSER program revenues and expenditures recorded on the financial statements, potential deficiencies in the cash management process were identified. Therefore, a review of all cash drawdowns and disbursements related to the ESSER program was performed to determine if any excessive drawdowns were made during the year under review. Excessive drawdown requests totaling $195,559 were identified. Cause: Drawdowns in excess of expenditures were caused by an error made by School District personnel when requesting ESSER funds. These excessive drawdowns were primarily the result of the School District requesting reimbursement for expenditures that had not been incurred by year end. Effect: The School District was not in compliance with the Uniform Guidance and GaDOE guidance. In addition, the School District could potentially accrue an interest liability that would be owed back to the federal government. Furthermore, when the School District cannot meet the requirement to minimize the time elapsing between the transfer of funds and disbursement of those funds, provisions included in the Uniform Guidance allow GaDOE to change the method by which the School District is transferred funds and delay the School District?s receipt of these funds. This may include requirement by GaDOE to submit invoices prior to being reimbursed for ESSER program expenditures. Recommendation: The School District should establish procedures to accurately forecast the cash needs of the ESSER program and minimize the time elapsing between the transfer of funds from GaDOE and the disbursement of such funds by the School District. In addition, these procedures should be documented in writing in accordance with the Uniform Guidance Section 200.302(b)(6). Furthermore, management should develop and implement a monitoring process to ensure that these procedures are followed. Views of Responsible Officials: We concur with this finding.
Compliance Requirement: Procurement and Written Policies ALN Number: 10.664 Grant Number: 18-DG-11020000-050 Criteria: Title 2 of the U.S. Code of Federal Regulations (CFR) ? 180.300 (January 1, 2021) requires non-federal entities to verify an entity is not excluded or disqualified prior to entering into a covered transaction by, ?(a) Checking SAM Exclusions; or (b) Collecting a certification from that [entity]; or (c) Adding a clause or condition to the covered transaction with that [entity].? A good internal control plan requires adequate procedures to ensure the County has proper procedures in place to verify that contractors paid with grant funds are not suspended, debarred, or otherwise excluded from or ineligible for participation in Federal programs or activities. The Uniform Guidance requires nonfederal entities that receive federal awards to establish written policies, procedures, and or/standards of conduct, except if excluded in compliance supplement. There are four basic reasons for creating an internal control system through defining and documenting processes with well written policies and procedures: 1.Compliance 2.Operational Needs 3.Managing Risks 4.Continuous Improvement Complying with laws and regulations should be a critical function of the County. Well-defined and documented processes (i.e. procedures, training manuals) along with records that demonstrate process capability can make evident an effective internal control system and compliance to Federal guidelines. Another important role of documentation of procedures is to ensure processes fundamental to the County are properly guided by County?s officials, and are consistent way that meets the County?s needs, and that are important related information and data are captured and communicated. Documentation of procedures are important for controlling process, documenting the standard work that was performed and training new employees. Condition: The County lacks certain written policies and procedures required by Uniform Guidance. Although the County has an outdated Accounting Policy, certain policies for Federal Expenditures need to be updated and added. These include: 1. Financial management (200.302) 2.Payment (200.305) 3.General procurement standards (200.318) 4.Competition (200.319) 5.Methods of procurement to be followed (200.320) 6.Compensation ? personal services (200.430) 7.Compensation ? fringe benefits (200.431) 8.Relocation costs of employees (200.464) 9.Travel costs (200.474) Cause: Appears to be the result of a lack of training coupled with limited staffing and resources. Questioned Costs: None Context for Calculation Of Questioned Costs: None Effect: Without adequate procedures to ensure contractors are not suspended, debarred or otherwise excluded from or ineligible for participation in Federal programs or activities, there is an increased risk for the misuse of Federal funds and noncompliance with Federal regulations. Recommendation: We recommend the County implement procedures to ensure, prior to entering into a covered transaction, that a contractor in not suspended, debarred, or otherwise excluded from or ineligible for participation in Federal programs or activities, and that procedures is adequately documented. Furthermore, the County should familiarize themselves with the Uniform Guidance and implement the following: 1.Develop and document all of its significant processes over federal awards. 2.Make the written policies and procedures available to all personnel and departments within the County 3.Ensure the written policies and procedures are accurate, complete, and current at all times (The Board of County Commissioners should update the policy on an annual basis.) 4.Revise policies and procedures for changes in business processes and policies over federal awards 5.Communicate significant changes to all affected personnel immediately to ensure they are aware of any revisions to their Responsibilities to the federal award. 6.Document policies and procedures to facilitate training and provide guidelines relative to federal awards for changes in personnel.
Compliance Requirement: Procurement and Written Policies ALN Number: 10.664 Grant Number: 18-DG-11020000-050 Criteria: Title 2 of the U.S. Code of Federal Regulations (CFR) ? 180.300 (January 1, 2021) requires non-federal entities to verify an entity is not excluded or disqualified prior to entering into a covered transaction by, ?(a) Checking SAM Exclusions; or (b) Collecting a certification from that [entity]; or (c) Adding a clause or condition to the covered transaction with that [entity].? A good internal control plan requires adequate procedures to ensure the County has proper procedures in place to verify that contractors paid with grant funds are not suspended, debarred, or otherwise excluded from or ineligible for participation in Federal programs or activities. The Uniform Guidance requires nonfederal entities that receive federal awards to establish written policies, procedures, and or/standards of conduct, except if excluded in compliance supplement. There are four basic reasons for creating an internal control system through defining and documenting processes with well written policies and procedures: 1.Compliance 2.Operational Needs 3.Managing Risks 4.Continuous Improvement Complying with laws and regulations should be a critical function of the County. Well-defined and documented processes (i.e. procedures, training manuals) along with records that demonstrate process capability can make evident an effective internal control system and compliance to Federal guidelines. Another important role of documentation of procedures is to ensure processes fundamental to the County are properly guided by County?s officials, and are consistent way that meets the County?s needs, and that are important related information and data are captured and communicated. Documentation of procedures are important for controlling process, documenting the standard work that was performed and training new employees. Condition: The County lacks certain written policies and procedures required by Uniform Guidance. Although the County has an outdated Accounting Policy, certain policies for Federal Expenditures need to be updated and added. These include: 1. Financial management (200.302) 2.Payment (200.305) 3.General procurement standards (200.318) 4.Competition (200.319) 5.Methods of procurement to be followed (200.320) 6.Compensation ? personal services (200.430) 7.Compensation ? fringe benefits (200.431) 8.Relocation costs of employees (200.464) 9.Travel costs (200.474) Cause: Appears to be the result of a lack of training coupled with limited staffing and resources. Questioned Costs: None Context for Calculation Of Questioned Costs: None Effect: Without adequate procedures to ensure contractors are not suspended, debarred or otherwise excluded from or ineligible for participation in Federal programs or activities, there is an increased risk for the misuse of Federal funds and noncompliance with Federal regulations. Recommendation: We recommend the County implement procedures to ensure, prior to entering into a covered transaction, that a contractor in not suspended, debarred, or otherwise excluded from or ineligible for participation in Federal programs or activities, and that procedures is adequately documented. Furthermore, the County should familiarize themselves with the Uniform Guidance and implement the following: 1.Develop and document all of its significant processes over federal awards. 2.Make the written policies and procedures available to all personnel and departments within the County 3.Ensure the written policies and procedures are accurate, complete, and current at all times (The Board of County Commissioners should update the policy on an annual basis.) 4.Revise policies and procedures for changes in business processes and policies over federal awards 5.Communicate significant changes to all affected personnel immediately to ensure they are aware of any revisions to their Responsibilities to the federal award. 6.Document policies and procedures to facilitate training and provide guidelines relative to federal awards for changes in personnel.