FINDING 2023-004 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Number: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Modified Opinion Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. The School Corporation was required to submit an annual data report to the Indiana Department of Education (IDOE) via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditures, and expenditures per activity. During the audit period the School Corporation was required to submit two ESSER I reports, two ESSER II reports, and two ESSER III reports, for a total of six reports. However, the School Corporation failed to submit all six required reports. 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). . . ." 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 A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, reports were not submitted to the IDOE. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure reports are submitted timely and accurately. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-004 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Number: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Modified Opinion Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. The School Corporation was required to submit an annual data report to the Indiana Department of Education (IDOE) via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditures, and expenditures per activity. During the audit period the School Corporation was required to submit two ESSER I reports, two ESSER II reports, and two ESSER III reports, for a total of six reports. However, the School Corporation failed to submit all six required reports. 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). . . ." 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 A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, reports were not submitted to the IDOE. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure reports are submitted timely and accurately. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-004 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Number: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Modified Opinion Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. The School Corporation was required to submit an annual data report to the Indiana Department of Education (IDOE) via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditures, and expenditures per activity. During the audit period the School Corporation was required to submit two ESSER I reports, two ESSER II reports, and two ESSER III reports, for a total of six reports. However, the School Corporation failed to submit all six required reports. 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). . . ." 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 A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, reports were not submitted to the IDOE. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure reports are submitted timely and accurately. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-004 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Number: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Modified Opinion Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. The School Corporation was required to submit an annual data report to the Indiana Department of Education (IDOE) via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditures, and expenditures per activity. During the audit period the School Corporation was required to submit two ESSER I reports, two ESSER II reports, and two ESSER III reports, for a total of six reports. However, the School Corporation failed to submit all six required reports. 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). . . ." 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 A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, reports were not submitted to the IDOE. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure reports are submitted timely and accurately. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
Finding Number 2022-008 Prior Year Finding Number N/A Compliance Requirement: Allowable Costs/Costs Principles Program: U.S. Department of Education Title I Grants to Local Educational Agencies ALN #: 84.010 Award #: Various Award Period: Various COVID-19 – Governor’s Emergency Education Relief (GEER) ALN #: 84.425C Award #: Various Award Period: Various COVID-19 – Elementary and Secondary School Emergency Relief (ESSR) Fund ALN #: 84.425D Award #: Various Award Period: Various COVID-19 – American Rescue Plan - Elementary and Secondary School Emergency Relief (ARP ESSR) ALN #: 84.425U Award #: 211941 Award Period: 03/24/2021 – 09/30/2023 COVID-19 – American Rescue Plan - Elementary and Secondary School Emergency Relief – Homeless Children and Youth ALN #: 84.425W Award #: Various Award Period: Various Criteria – In accordance with §200.302 Financial Management, a 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. The financial management system of each non-federal entity must provide for the following: 1. Identification, in its accounts, of all federal awards received and expended and the federal programs under which they were received. 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. 3. Records that identify adequately the source and application of funds for federally funded activities. 4. Effective control over, and accountability for, all funds, property, and other assets. The Uniform Guidance in 2 CFR Section 200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Further, CFR Section 200.510 (b) requires the auditee must also prepare a Schedule of Expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR section 200.502, Basis for determining Federal awards expended. Condition – The amounts recorded in the Schedule of Expenditures of Federal Awards (SEFA) agree to the total amount recorded in the general ledger. The summary level payroll transactions recorded in the general ledger could not be reconciled to the transaction level detail provided from the payroll system. When comparing the two populations, we identified the following differences: • ALN 84.425 - For ALN 84.425 sub-program D, we noted a variance of $1,828,609. Total payroll expenditures per the payroll system details amounted to $18,437,724 whereas payroll expenditures per SEFA amounted to $16,609,116. In addition to the above, for ALN 84.425 sub-program U, we noted a variance of $301,432. Total payroll expenditures per the payroll system details amounted to $3,607,738 whereas payroll expenditures per the SEFA amounted to $3,909,170. • ALN 84.010 - We noted a variance of $752,503. Total payroll expenditures per the payroll system details amounted to $40,549,584 whereas payroll expenditures per the SEFA amounted to $39,797,081. Questioned Costs – Not Determinable. Context – This is a condition identified per review of the School System’s population completeness over the compliance requirements for each program. The prevalence of these findings is detailed in the condition section above. Effect – The SEFA may not be completely and accurately stated. In addition, the lack of established internal controls policies and procedures to ensure the SEFA is completely and accurately stated can lead to noncompliance with federal statutes, regulations, and provisions of grant agreements. Cause – The School System did not adhere to their internal policies and procedures to ensure the accuracy of the SEFA. Recommendation – We recommend that the School System develop policies and procedures and enhance their existing reconciliation process to ensure the completeness and accuracy of the SEFA, and that amounts reported on the SEFA are supported by transaction level detail. Views of Responsible Officials – The School System does not concur with the auditor’s findings and recommendations. The total expenditures for all federal programs recorded in the Schedule of Expenditures for Federal Awards are accurately presented and tie to the general ledger. The payroll sub-ledger is corrected before posting to the general ledger every two weeks. The resulting differences are most often immaterial but can be traced to corrections made by the Accounting Office after payroll is reviewed by the grants Restricted Funds Supervisor to ensure payroll is not posted to expired grants. The planned corrective actions are presented in the School System’s Corrective Action Plan attached as Appendix B to the Single Audit Report. BDO Response – We have reviewed management’s response and our finding remains as indicated, since we could not validate the details of the differences.
Finding Number 2022-008 Prior Year Finding Number N/A Compliance Requirement: Allowable Costs/Costs Principles Program: U.S. Department of Education Title I Grants to Local Educational Agencies ALN #: 84.010 Award #: Various Award Period: Various COVID-19 – Governor’s Emergency Education Relief (GEER) ALN #: 84.425C Award #: Various Award Period: Various COVID-19 – Elementary and Secondary School Emergency Relief (ESSR) Fund ALN #: 84.425D Award #: Various Award Period: Various COVID-19 – American Rescue Plan - Elementary and Secondary School Emergency Relief (ARP ESSR) ALN #: 84.425U Award #: 211941 Award Period: 03/24/2021 – 09/30/2023 COVID-19 – American Rescue Plan - Elementary and Secondary School Emergency Relief – Homeless Children and Youth ALN #: 84.425W Award #: Various Award Period: Various Criteria – In accordance with §200.302 Financial Management, a 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. The financial management system of each non-federal entity must provide for the following: 1. Identification, in its accounts, of all federal awards received and expended and the federal programs under which they were received. 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. 3. Records that identify adequately the source and application of funds for federally funded activities. 4. Effective control over, and accountability for, all funds, property, and other assets. The Uniform Guidance in 2 CFR Section 200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Further, CFR Section 200.510 (b) requires the auditee must also prepare a Schedule of Expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR section 200.502, Basis for determining Federal awards expended. Condition – The amounts recorded in the Schedule of Expenditures of Federal Awards (SEFA) agree to the total amount recorded in the general ledger. The summary level payroll transactions recorded in the general ledger could not be reconciled to the transaction level detail provided from the payroll system. When comparing the two populations, we identified the following differences: • ALN 84.425 - For ALN 84.425 sub-program D, we noted a variance of $1,828,609. Total payroll expenditures per the payroll system details amounted to $18,437,724 whereas payroll expenditures per SEFA amounted to $16,609,116. In addition to the above, for ALN 84.425 sub-program U, we noted a variance of $301,432. Total payroll expenditures per the payroll system details amounted to $3,607,738 whereas payroll expenditures per the SEFA amounted to $3,909,170. • ALN 84.010 - We noted a variance of $752,503. Total payroll expenditures per the payroll system details amounted to $40,549,584 whereas payroll expenditures per the SEFA amounted to $39,797,081. Questioned Costs – Not Determinable. Context – This is a condition identified per review of the School System’s population completeness over the compliance requirements for each program. The prevalence of these findings is detailed in the condition section above. Effect – The SEFA may not be completely and accurately stated. In addition, the lack of established internal controls policies and procedures to ensure the SEFA is completely and accurately stated can lead to noncompliance with federal statutes, regulations, and provisions of grant agreements. Cause – The School System did not adhere to their internal policies and procedures to ensure the accuracy of the SEFA. Recommendation – We recommend that the School System develop policies and procedures and enhance their existing reconciliation process to ensure the completeness and accuracy of the SEFA, and that amounts reported on the SEFA are supported by transaction level detail. Views of Responsible Officials – The School System does not concur with the auditor’s findings and recommendations. The total expenditures for all federal programs recorded in the Schedule of Expenditures for Federal Awards are accurately presented and tie to the general ledger. The payroll sub-ledger is corrected before posting to the general ledger every two weeks. The resulting differences are most often immaterial but can be traced to corrections made by the Accounting Office after payroll is reviewed by the grants Restricted Funds Supervisor to ensure payroll is not posted to expired grants. The planned corrective actions are presented in the School System’s Corrective Action Plan attached as Appendix B to the Single Audit Report. BDO Response – We have reviewed management’s response and our finding remains as indicated, since we could not validate the details of the differences.
Finding Number 2022-008 Prior Year Finding Number N/A Compliance Requirement: Allowable Costs/Costs Principles Program: U.S. Department of Education Title I Grants to Local Educational Agencies ALN #: 84.010 Award #: Various Award Period: Various COVID-19 – Governor’s Emergency Education Relief (GEER) ALN #: 84.425C Award #: Various Award Period: Various COVID-19 – Elementary and Secondary School Emergency Relief (ESSR) Fund ALN #: 84.425D Award #: Various Award Period: Various COVID-19 – American Rescue Plan - Elementary and Secondary School Emergency Relief (ARP ESSR) ALN #: 84.425U Award #: 211941 Award Period: 03/24/2021 – 09/30/2023 COVID-19 – American Rescue Plan - Elementary and Secondary School Emergency Relief – Homeless Children and Youth ALN #: 84.425W Award #: Various Award Period: Various Criteria – In accordance with §200.302 Financial Management, a 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. The financial management system of each non-federal entity must provide for the following: 1. Identification, in its accounts, of all federal awards received and expended and the federal programs under which they were received. 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. 3. Records that identify adequately the source and application of funds for federally funded activities. 4. Effective control over, and accountability for, all funds, property, and other assets. The Uniform Guidance in 2 CFR Section 200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Further, CFR Section 200.510 (b) requires the auditee must also prepare a Schedule of Expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR section 200.502, Basis for determining Federal awards expended. Condition – The amounts recorded in the Schedule of Expenditures of Federal Awards (SEFA) agree to the total amount recorded in the general ledger. The summary level payroll transactions recorded in the general ledger could not be reconciled to the transaction level detail provided from the payroll system. When comparing the two populations, we identified the following differences: • ALN 84.425 - For ALN 84.425 sub-program D, we noted a variance of $1,828,609. Total payroll expenditures per the payroll system details amounted to $18,437,724 whereas payroll expenditures per SEFA amounted to $16,609,116. In addition to the above, for ALN 84.425 sub-program U, we noted a variance of $301,432. Total payroll expenditures per the payroll system details amounted to $3,607,738 whereas payroll expenditures per the SEFA amounted to $3,909,170. • ALN 84.010 - We noted a variance of $752,503. Total payroll expenditures per the payroll system details amounted to $40,549,584 whereas payroll expenditures per the SEFA amounted to $39,797,081. Questioned Costs – Not Determinable. Context – This is a condition identified per review of the School System’s population completeness over the compliance requirements for each program. The prevalence of these findings is detailed in the condition section above. Effect – The SEFA may not be completely and accurately stated. In addition, the lack of established internal controls policies and procedures to ensure the SEFA is completely and accurately stated can lead to noncompliance with federal statutes, regulations, and provisions of grant agreements. Cause – The School System did not adhere to their internal policies and procedures to ensure the accuracy of the SEFA. Recommendation – We recommend that the School System develop policies and procedures and enhance their existing reconciliation process to ensure the completeness and accuracy of the SEFA, and that amounts reported on the SEFA are supported by transaction level detail. Views of Responsible Officials – The School System does not concur with the auditor’s findings and recommendations. The total expenditures for all federal programs recorded in the Schedule of Expenditures for Federal Awards are accurately presented and tie to the general ledger. The payroll sub-ledger is corrected before posting to the general ledger every two weeks. The resulting differences are most often immaterial but can be traced to corrections made by the Accounting Office after payroll is reviewed by the grants Restricted Funds Supervisor to ensure payroll is not posted to expired grants. The planned corrective actions are presented in the School System’s Corrective Action Plan attached as Appendix B to the Single Audit Report. BDO Response – We have reviewed management’s response and our finding remains as indicated, since we could not validate the details of the differences.
Finding Number 2022-008 Prior Year Finding Number N/A Compliance Requirement: Allowable Costs/Costs Principles Program: U.S. Department of Education Title I Grants to Local Educational Agencies ALN #: 84.010 Award #: Various Award Period: Various COVID-19 – Governor’s Emergency Education Relief (GEER) ALN #: 84.425C Award #: Various Award Period: Various COVID-19 – Elementary and Secondary School Emergency Relief (ESSR) Fund ALN #: 84.425D Award #: Various Award Period: Various COVID-19 – American Rescue Plan - Elementary and Secondary School Emergency Relief (ARP ESSR) ALN #: 84.425U Award #: 211941 Award Period: 03/24/2021 – 09/30/2023 COVID-19 – American Rescue Plan - Elementary and Secondary School Emergency Relief – Homeless Children and Youth ALN #: 84.425W Award #: Various Award Period: Various Criteria – In accordance with §200.302 Financial Management, a 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. The financial management system of each non-federal entity must provide for the following: 1. Identification, in its accounts, of all federal awards received and expended and the federal programs under which they were received. 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. 3. Records that identify adequately the source and application of funds for federally funded activities. 4. Effective control over, and accountability for, all funds, property, and other assets. The Uniform Guidance in 2 CFR Section 200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Further, CFR Section 200.510 (b) requires the auditee must also prepare a Schedule of Expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR section 200.502, Basis for determining Federal awards expended. Condition – The amounts recorded in the Schedule of Expenditures of Federal Awards (SEFA) agree to the total amount recorded in the general ledger. The summary level payroll transactions recorded in the general ledger could not be reconciled to the transaction level detail provided from the payroll system. When comparing the two populations, we identified the following differences: • ALN 84.425 - For ALN 84.425 sub-program D, we noted a variance of $1,828,609. Total payroll expenditures per the payroll system details amounted to $18,437,724 whereas payroll expenditures per SEFA amounted to $16,609,116. In addition to the above, for ALN 84.425 sub-program U, we noted a variance of $301,432. Total payroll expenditures per the payroll system details amounted to $3,607,738 whereas payroll expenditures per the SEFA amounted to $3,909,170. • ALN 84.010 - We noted a variance of $752,503. Total payroll expenditures per the payroll system details amounted to $40,549,584 whereas payroll expenditures per the SEFA amounted to $39,797,081. Questioned Costs – Not Determinable. Context – This is a condition identified per review of the School System’s population completeness over the compliance requirements for each program. The prevalence of these findings is detailed in the condition section above. Effect – The SEFA may not be completely and accurately stated. In addition, the lack of established internal controls policies and procedures to ensure the SEFA is completely and accurately stated can lead to noncompliance with federal statutes, regulations, and provisions of grant agreements. Cause – The School System did not adhere to their internal policies and procedures to ensure the accuracy of the SEFA. Recommendation – We recommend that the School System develop policies and procedures and enhance their existing reconciliation process to ensure the completeness and accuracy of the SEFA, and that amounts reported on the SEFA are supported by transaction level detail. Views of Responsible Officials – The School System does not concur with the auditor’s findings and recommendations. The total expenditures for all federal programs recorded in the Schedule of Expenditures for Federal Awards are accurately presented and tie to the general ledger. The payroll sub-ledger is corrected before posting to the general ledger every two weeks. The resulting differences are most often immaterial but can be traced to corrections made by the Accounting Office after payroll is reviewed by the grants Restricted Funds Supervisor to ensure payroll is not posted to expired grants. The planned corrective actions are presented in the School System’s Corrective Action Plan attached as Appendix B to the Single Audit Report. BDO Response – We have reviewed management’s response and our finding remains as indicated, since we could not validate the details of the differences.
Finding Number 2022-008 Prior Year Finding Number N/A Compliance Requirement: Allowable Costs/Costs Principles Program: U.S. Department of Education Title I Grants to Local Educational Agencies ALN #: 84.010 Award #: Various Award Period: Various COVID-19 – Governor’s Emergency Education Relief (GEER) ALN #: 84.425C Award #: Various Award Period: Various COVID-19 – Elementary and Secondary School Emergency Relief (ESSR) Fund ALN #: 84.425D Award #: Various Award Period: Various COVID-19 – American Rescue Plan - Elementary and Secondary School Emergency Relief (ARP ESSR) ALN #: 84.425U Award #: 211941 Award Period: 03/24/2021 – 09/30/2023 COVID-19 – American Rescue Plan - Elementary and Secondary School Emergency Relief – Homeless Children and Youth ALN #: 84.425W Award #: Various Award Period: Various Criteria – In accordance with §200.302 Financial Management, a 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. The financial management system of each non-federal entity must provide for the following: 1. Identification, in its accounts, of all federal awards received and expended and the federal programs under which they were received. 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. 3. Records that identify adequately the source and application of funds for federally funded activities. 4. Effective control over, and accountability for, all funds, property, and other assets. The Uniform Guidance in 2 CFR Section 200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Further, CFR Section 200.510 (b) requires the auditee must also prepare a Schedule of Expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR section 200.502, Basis for determining Federal awards expended. Condition – The amounts recorded in the Schedule of Expenditures of Federal Awards (SEFA) agree to the total amount recorded in the general ledger. The summary level payroll transactions recorded in the general ledger could not be reconciled to the transaction level detail provided from the payroll system. When comparing the two populations, we identified the following differences: • ALN 84.425 - For ALN 84.425 sub-program D, we noted a variance of $1,828,609. Total payroll expenditures per the payroll system details amounted to $18,437,724 whereas payroll expenditures per SEFA amounted to $16,609,116. In addition to the above, for ALN 84.425 sub-program U, we noted a variance of $301,432. Total payroll expenditures per the payroll system details amounted to $3,607,738 whereas payroll expenditures per the SEFA amounted to $3,909,170. • ALN 84.010 - We noted a variance of $752,503. Total payroll expenditures per the payroll system details amounted to $40,549,584 whereas payroll expenditures per the SEFA amounted to $39,797,081. Questioned Costs – Not Determinable. Context – This is a condition identified per review of the School System’s population completeness over the compliance requirements for each program. The prevalence of these findings is detailed in the condition section above. Effect – The SEFA may not be completely and accurately stated. In addition, the lack of established internal controls policies and procedures to ensure the SEFA is completely and accurately stated can lead to noncompliance with federal statutes, regulations, and provisions of grant agreements. Cause – The School System did not adhere to their internal policies and procedures to ensure the accuracy of the SEFA. Recommendation – We recommend that the School System develop policies and procedures and enhance their existing reconciliation process to ensure the completeness and accuracy of the SEFA, and that amounts reported on the SEFA are supported by transaction level detail. Views of Responsible Officials – The School System does not concur with the auditor’s findings and recommendations. The total expenditures for all federal programs recorded in the Schedule of Expenditures for Federal Awards are accurately presented and tie to the general ledger. The payroll sub-ledger is corrected before posting to the general ledger every two weeks. The resulting differences are most often immaterial but can be traced to corrections made by the Accounting Office after payroll is reviewed by the grants Restricted Funds Supervisor to ensure payroll is not posted to expired grants. The planned corrective actions are presented in the School System’s Corrective Action Plan attached as Appendix B to the Single Audit Report. BDO Response – We have reviewed management’s response and our finding remains as indicated, since we could not validate the details of the differences.
Finding Number 2022-008 Prior Year Finding Number N/A Compliance Requirement: Allowable Costs/Costs Principles Program: U.S. Department of Education Title I Grants to Local Educational Agencies ALN #: 84.010 Award #: Various Award Period: Various COVID-19 – Governor’s Emergency Education Relief (GEER) ALN #: 84.425C Award #: Various Award Period: Various COVID-19 – Elementary and Secondary School Emergency Relief (ESSR) Fund ALN #: 84.425D Award #: Various Award Period: Various COVID-19 – American Rescue Plan - Elementary and Secondary School Emergency Relief (ARP ESSR) ALN #: 84.425U Award #: 211941 Award Period: 03/24/2021 – 09/30/2023 COVID-19 – American Rescue Plan - Elementary and Secondary School Emergency Relief – Homeless Children and Youth ALN #: 84.425W Award #: Various Award Period: Various Criteria – In accordance with §200.302 Financial Management, a 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. The financial management system of each non-federal entity must provide for the following: 1. Identification, in its accounts, of all federal awards received and expended and the federal programs under which they were received. 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. 3. Records that identify adequately the source and application of funds for federally funded activities. 4. Effective control over, and accountability for, all funds, property, and other assets. The Uniform Guidance in 2 CFR Section 200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Further, CFR Section 200.510 (b) requires the auditee must also prepare a Schedule of Expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR section 200.502, Basis for determining Federal awards expended. Condition – The amounts recorded in the Schedule of Expenditures of Federal Awards (SEFA) agree to the total amount recorded in the general ledger. The summary level payroll transactions recorded in the general ledger could not be reconciled to the transaction level detail provided from the payroll system. When comparing the two populations, we identified the following differences: • ALN 84.425 - For ALN 84.425 sub-program D, we noted a variance of $1,828,609. Total payroll expenditures per the payroll system details amounted to $18,437,724 whereas payroll expenditures per SEFA amounted to $16,609,116. In addition to the above, for ALN 84.425 sub-program U, we noted a variance of $301,432. Total payroll expenditures per the payroll system details amounted to $3,607,738 whereas payroll expenditures per the SEFA amounted to $3,909,170. • ALN 84.010 - We noted a variance of $752,503. Total payroll expenditures per the payroll system details amounted to $40,549,584 whereas payroll expenditures per the SEFA amounted to $39,797,081. Questioned Costs – Not Determinable. Context – This is a condition identified per review of the School System’s population completeness over the compliance requirements for each program. The prevalence of these findings is detailed in the condition section above. Effect – The SEFA may not be completely and accurately stated. In addition, the lack of established internal controls policies and procedures to ensure the SEFA is completely and accurately stated can lead to noncompliance with federal statutes, regulations, and provisions of grant agreements. Cause – The School System did not adhere to their internal policies and procedures to ensure the accuracy of the SEFA. Recommendation – We recommend that the School System develop policies and procedures and enhance their existing reconciliation process to ensure the completeness and accuracy of the SEFA, and that amounts reported on the SEFA are supported by transaction level detail. Views of Responsible Officials – The School System does not concur with the auditor’s findings and recommendations. The total expenditures for all federal programs recorded in the Schedule of Expenditures for Federal Awards are accurately presented and tie to the general ledger. The payroll sub-ledger is corrected before posting to the general ledger every two weeks. The resulting differences are most often immaterial but can be traced to corrections made by the Accounting Office after payroll is reviewed by the grants Restricted Funds Supervisor to ensure payroll is not posted to expired grants. The planned corrective actions are presented in the School System’s Corrective Action Plan attached as Appendix B to the Single Audit Report. BDO Response – We have reviewed management’s response and our finding remains as indicated, since we could not validate the details of the differences.
Finding Number 2022-008 Prior Year Finding Number N/A Compliance Requirement: Allowable Costs/Costs Principles Program: U.S. Department of Education Title I Grants to Local Educational Agencies ALN #: 84.010 Award #: Various Award Period: Various COVID-19 – Governor’s Emergency Education Relief (GEER) ALN #: 84.425C Award #: Various Award Period: Various COVID-19 – Elementary and Secondary School Emergency Relief (ESSR) Fund ALN #: 84.425D Award #: Various Award Period: Various COVID-19 – American Rescue Plan - Elementary and Secondary School Emergency Relief (ARP ESSR) ALN #: 84.425U Award #: 211941 Award Period: 03/24/2021 – 09/30/2023 COVID-19 – American Rescue Plan - Elementary and Secondary School Emergency Relief – Homeless Children and Youth ALN #: 84.425W Award #: Various Award Period: Various Criteria – In accordance with §200.302 Financial Management, a 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. The financial management system of each non-federal entity must provide for the following: 1. Identification, in its accounts, of all federal awards received and expended and the federal programs under which they were received. 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. 3. Records that identify adequately the source and application of funds for federally funded activities. 4. Effective control over, and accountability for, all funds, property, and other assets. The Uniform Guidance in 2 CFR Section 200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Further, CFR Section 200.510 (b) requires the auditee must also prepare a Schedule of Expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR section 200.502, Basis for determining Federal awards expended. Condition – The amounts recorded in the Schedule of Expenditures of Federal Awards (SEFA) agree to the total amount recorded in the general ledger. The summary level payroll transactions recorded in the general ledger could not be reconciled to the transaction level detail provided from the payroll system. When comparing the two populations, we identified the following differences: • ALN 84.425 - For ALN 84.425 sub-program D, we noted a variance of $1,828,609. Total payroll expenditures per the payroll system details amounted to $18,437,724 whereas payroll expenditures per SEFA amounted to $16,609,116. In addition to the above, for ALN 84.425 sub-program U, we noted a variance of $301,432. Total payroll expenditures per the payroll system details amounted to $3,607,738 whereas payroll expenditures per the SEFA amounted to $3,909,170. • ALN 84.010 - We noted a variance of $752,503. Total payroll expenditures per the payroll system details amounted to $40,549,584 whereas payroll expenditures per the SEFA amounted to $39,797,081. Questioned Costs – Not Determinable. Context – This is a condition identified per review of the School System’s population completeness over the compliance requirements for each program. The prevalence of these findings is detailed in the condition section above. Effect – The SEFA may not be completely and accurately stated. In addition, the lack of established internal controls policies and procedures to ensure the SEFA is completely and accurately stated can lead to noncompliance with federal statutes, regulations, and provisions of grant agreements. Cause – The School System did not adhere to their internal policies and procedures to ensure the accuracy of the SEFA. Recommendation – We recommend that the School System develop policies and procedures and enhance their existing reconciliation process to ensure the completeness and accuracy of the SEFA, and that amounts reported on the SEFA are supported by transaction level detail. Views of Responsible Officials – The School System does not concur with the auditor’s findings and recommendations. The total expenditures for all federal programs recorded in the Schedule of Expenditures for Federal Awards are accurately presented and tie to the general ledger. The payroll sub-ledger is corrected before posting to the general ledger every two weeks. The resulting differences are most often immaterial but can be traced to corrections made by the Accounting Office after payroll is reviewed by the grants Restricted Funds Supervisor to ensure payroll is not posted to expired grants. The planned corrective actions are presented in the School System’s Corrective Action Plan attached as Appendix B to the Single Audit Report. BDO Response – We have reviewed management’s response and our finding remains as indicated, since we could not validate the details of the differences.
Finding Number 2022-008 Prior Year Finding Number N/A Compliance Requirement: Allowable Costs/Costs Principles Program: U.S. Department of Education Title I Grants to Local Educational Agencies ALN #: 84.010 Award #: Various Award Period: Various COVID-19 – Governor’s Emergency Education Relief (GEER) ALN #: 84.425C Award #: Various Award Period: Various COVID-19 – Elementary and Secondary School Emergency Relief (ESSR) Fund ALN #: 84.425D Award #: Various Award Period: Various COVID-19 – American Rescue Plan - Elementary and Secondary School Emergency Relief (ARP ESSR) ALN #: 84.425U Award #: 211941 Award Period: 03/24/2021 – 09/30/2023 COVID-19 – American Rescue Plan - Elementary and Secondary School Emergency Relief – Homeless Children and Youth ALN #: 84.425W Award #: Various Award Period: Various Criteria – In accordance with §200.302 Financial Management, a 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. The financial management system of each non-federal entity must provide for the following: 1. Identification, in its accounts, of all federal awards received and expended and the federal programs under which they were received. 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. 3. Records that identify adequately the source and application of funds for federally funded activities. 4. Effective control over, and accountability for, all funds, property, and other assets. The Uniform Guidance in 2 CFR Section 200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Further, CFR Section 200.510 (b) requires the auditee must also prepare a Schedule of Expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR section 200.502, Basis for determining Federal awards expended. Condition – The amounts recorded in the Schedule of Expenditures of Federal Awards (SEFA) agree to the total amount recorded in the general ledger. The summary level payroll transactions recorded in the general ledger could not be reconciled to the transaction level detail provided from the payroll system. When comparing the two populations, we identified the following differences: • ALN 84.425 - For ALN 84.425 sub-program D, we noted a variance of $1,828,609. Total payroll expenditures per the payroll system details amounted to $18,437,724 whereas payroll expenditures per SEFA amounted to $16,609,116. In addition to the above, for ALN 84.425 sub-program U, we noted a variance of $301,432. Total payroll expenditures per the payroll system details amounted to $3,607,738 whereas payroll expenditures per the SEFA amounted to $3,909,170. • ALN 84.010 - We noted a variance of $752,503. Total payroll expenditures per the payroll system details amounted to $40,549,584 whereas payroll expenditures per the SEFA amounted to $39,797,081. Questioned Costs – Not Determinable. Context – This is a condition identified per review of the School System’s population completeness over the compliance requirements for each program. The prevalence of these findings is detailed in the condition section above. Effect – The SEFA may not be completely and accurately stated. In addition, the lack of established internal controls policies and procedures to ensure the SEFA is completely and accurately stated can lead to noncompliance with federal statutes, regulations, and provisions of grant agreements. Cause – The School System did not adhere to their internal policies and procedures to ensure the accuracy of the SEFA. Recommendation – We recommend that the School System develop policies and procedures and enhance their existing reconciliation process to ensure the completeness and accuracy of the SEFA, and that amounts reported on the SEFA are supported by transaction level detail. Views of Responsible Officials – The School System does not concur with the auditor’s findings and recommendations. The total expenditures for all federal programs recorded in the Schedule of Expenditures for Federal Awards are accurately presented and tie to the general ledger. The payroll sub-ledger is corrected before posting to the general ledger every two weeks. The resulting differences are most often immaterial but can be traced to corrections made by the Accounting Office after payroll is reviewed by the grants Restricted Funds Supervisor to ensure payroll is not posted to expired grants. The planned corrective actions are presented in the School System’s Corrective Action Plan attached as Appendix B to the Single Audit Report. BDO Response – We have reviewed management’s response and our finding remains as indicated, since we could not validate the details of the differences.
Finding Number 2022-008 Prior Year Finding Number N/A Compliance Requirement: Allowable Costs/Costs Principles Program: U.S. Department of Education Title I Grants to Local Educational Agencies ALN #: 84.010 Award #: Various Award Period: Various COVID-19 – Governor’s Emergency Education Relief (GEER) ALN #: 84.425C Award #: Various Award Period: Various COVID-19 – Elementary and Secondary School Emergency Relief (ESSR) Fund ALN #: 84.425D Award #: Various Award Period: Various COVID-19 – American Rescue Plan - Elementary and Secondary School Emergency Relief (ARP ESSR) ALN #: 84.425U Award #: 211941 Award Period: 03/24/2021 – 09/30/2023 COVID-19 – American Rescue Plan - Elementary and Secondary School Emergency Relief – Homeless Children and Youth ALN #: 84.425W Award #: Various Award Period: Various Criteria – In accordance with §200.302 Financial Management, a 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. The financial management system of each non-federal entity must provide for the following: 1. Identification, in its accounts, of all federal awards received and expended and the federal programs under which they were received. 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. 3. Records that identify adequately the source and application of funds for federally funded activities. 4. Effective control over, and accountability for, all funds, property, and other assets. The Uniform Guidance in 2 CFR Section 200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Further, CFR Section 200.510 (b) requires the auditee must also prepare a Schedule of Expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR section 200.502, Basis for determining Federal awards expended. Condition – The amounts recorded in the Schedule of Expenditures of Federal Awards (SEFA) agree to the total amount recorded in the general ledger. The summary level payroll transactions recorded in the general ledger could not be reconciled to the transaction level detail provided from the payroll system. When comparing the two populations, we identified the following differences: • ALN 84.425 - For ALN 84.425 sub-program D, we noted a variance of $1,828,609. Total payroll expenditures per the payroll system details amounted to $18,437,724 whereas payroll expenditures per SEFA amounted to $16,609,116. In addition to the above, for ALN 84.425 sub-program U, we noted a variance of $301,432. Total payroll expenditures per the payroll system details amounted to $3,607,738 whereas payroll expenditures per the SEFA amounted to $3,909,170. • ALN 84.010 - We noted a variance of $752,503. Total payroll expenditures per the payroll system details amounted to $40,549,584 whereas payroll expenditures per the SEFA amounted to $39,797,081. Questioned Costs – Not Determinable. Context – This is a condition identified per review of the School System’s population completeness over the compliance requirements for each program. The prevalence of these findings is detailed in the condition section above. Effect – The SEFA may not be completely and accurately stated. In addition, the lack of established internal controls policies and procedures to ensure the SEFA is completely and accurately stated can lead to noncompliance with federal statutes, regulations, and provisions of grant agreements. Cause – The School System did not adhere to their internal policies and procedures to ensure the accuracy of the SEFA. Recommendation – We recommend that the School System develop policies and procedures and enhance their existing reconciliation process to ensure the completeness and accuracy of the SEFA, and that amounts reported on the SEFA are supported by transaction level detail. Views of Responsible Officials – The School System does not concur with the auditor’s findings and recommendations. The total expenditures for all federal programs recorded in the Schedule of Expenditures for Federal Awards are accurately presented and tie to the general ledger. The payroll sub-ledger is corrected before posting to the general ledger every two weeks. The resulting differences are most often immaterial but can be traced to corrections made by the Accounting Office after payroll is reviewed by the grants Restricted Funds Supervisor to ensure payroll is not posted to expired grants. The planned corrective actions are presented in the School System’s Corrective Action Plan attached as Appendix B to the Single Audit Report. BDO Response – We have reviewed management’s response and our finding remains as indicated, since we could not validate the details of the differences.
Finding Number 2022-008 Prior Year Finding Number N/A Compliance Requirement: Allowable Costs/Costs Principles Program: U.S. Department of Education Title I Grants to Local Educational Agencies ALN #: 84.010 Award #: Various Award Period: Various COVID-19 – Governor’s Emergency Education Relief (GEER) ALN #: 84.425C Award #: Various Award Period: Various COVID-19 – Elementary and Secondary School Emergency Relief (ESSR) Fund ALN #: 84.425D Award #: Various Award Period: Various COVID-19 – American Rescue Plan - Elementary and Secondary School Emergency Relief (ARP ESSR) ALN #: 84.425U Award #: 211941 Award Period: 03/24/2021 – 09/30/2023 COVID-19 – American Rescue Plan - Elementary and Secondary School Emergency Relief – Homeless Children and Youth ALN #: 84.425W Award #: Various Award Period: Various Criteria – In accordance with §200.302 Financial Management, a 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. The financial management system of each non-federal entity must provide for the following: 1. Identification, in its accounts, of all federal awards received and expended and the federal programs under which they were received. 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. 3. Records that identify adequately the source and application of funds for federally funded activities. 4. Effective control over, and accountability for, all funds, property, and other assets. The Uniform Guidance in 2 CFR Section 200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Further, CFR Section 200.510 (b) requires the auditee must also prepare a Schedule of Expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR section 200.502, Basis for determining Federal awards expended. Condition – The amounts recorded in the Schedule of Expenditures of Federal Awards (SEFA) agree to the total amount recorded in the general ledger. The summary level payroll transactions recorded in the general ledger could not be reconciled to the transaction level detail provided from the payroll system. When comparing the two populations, we identified the following differences: • ALN 84.425 - For ALN 84.425 sub-program D, we noted a variance of $1,828,609. Total payroll expenditures per the payroll system details amounted to $18,437,724 whereas payroll expenditures per SEFA amounted to $16,609,116. In addition to the above, for ALN 84.425 sub-program U, we noted a variance of $301,432. Total payroll expenditures per the payroll system details amounted to $3,607,738 whereas payroll expenditures per the SEFA amounted to $3,909,170. • ALN 84.010 - We noted a variance of $752,503. Total payroll expenditures per the payroll system details amounted to $40,549,584 whereas payroll expenditures per the SEFA amounted to $39,797,081. Questioned Costs – Not Determinable. Context – This is a condition identified per review of the School System’s population completeness over the compliance requirements for each program. The prevalence of these findings is detailed in the condition section above. Effect – The SEFA may not be completely and accurately stated. In addition, the lack of established internal controls policies and procedures to ensure the SEFA is completely and accurately stated can lead to noncompliance with federal statutes, regulations, and provisions of grant agreements. Cause – The School System did not adhere to their internal policies and procedures to ensure the accuracy of the SEFA. Recommendation – We recommend that the School System develop policies and procedures and enhance their existing reconciliation process to ensure the completeness and accuracy of the SEFA, and that amounts reported on the SEFA are supported by transaction level detail. Views of Responsible Officials – The School System does not concur with the auditor’s findings and recommendations. The total expenditures for all federal programs recorded in the Schedule of Expenditures for Federal Awards are accurately presented and tie to the general ledger. The payroll sub-ledger is corrected before posting to the general ledger every two weeks. The resulting differences are most often immaterial but can be traced to corrections made by the Accounting Office after payroll is reviewed by the grants Restricted Funds Supervisor to ensure payroll is not posted to expired grants. The planned corrective actions are presented in the School System’s Corrective Action Plan attached as Appendix B to the Single Audit Report. BDO Response – We have reviewed management’s response and our finding remains as indicated, since we could not validate the details of the differences.
Finding Number 2022-008 Prior Year Finding Number N/A Compliance Requirement: Allowable Costs/Costs Principles Program: U.S. Department of Education Title I Grants to Local Educational Agencies ALN #: 84.010 Award #: Various Award Period: Various COVID-19 – Governor’s Emergency Education Relief (GEER) ALN #: 84.425C Award #: Various Award Period: Various COVID-19 – Elementary and Secondary School Emergency Relief (ESSR) Fund ALN #: 84.425D Award #: Various Award Period: Various COVID-19 – American Rescue Plan - Elementary and Secondary School Emergency Relief (ARP ESSR) ALN #: 84.425U Award #: 211941 Award Period: 03/24/2021 – 09/30/2023 COVID-19 – American Rescue Plan - Elementary and Secondary School Emergency Relief – Homeless Children and Youth ALN #: 84.425W Award #: Various Award Period: Various Criteria – In accordance with §200.302 Financial Management, a 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. The financial management system of each non-federal entity must provide for the following: 1. Identification, in its accounts, of all federal awards received and expended and the federal programs under which they were received. 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. 3. Records that identify adequately the source and application of funds for federally funded activities. 4. Effective control over, and accountability for, all funds, property, and other assets. The Uniform Guidance in 2 CFR Section 200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Further, CFR Section 200.510 (b) requires the auditee must also prepare a Schedule of Expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR section 200.502, Basis for determining Federal awards expended. Condition – The amounts recorded in the Schedule of Expenditures of Federal Awards (SEFA) agree to the total amount recorded in the general ledger. The summary level payroll transactions recorded in the general ledger could not be reconciled to the transaction level detail provided from the payroll system. When comparing the two populations, we identified the following differences: • ALN 84.425 - For ALN 84.425 sub-program D, we noted a variance of $1,828,609. Total payroll expenditures per the payroll system details amounted to $18,437,724 whereas payroll expenditures per SEFA amounted to $16,609,116. In addition to the above, for ALN 84.425 sub-program U, we noted a variance of $301,432. Total payroll expenditures per the payroll system details amounted to $3,607,738 whereas payroll expenditures per the SEFA amounted to $3,909,170. • ALN 84.010 - We noted a variance of $752,503. Total payroll expenditures per the payroll system details amounted to $40,549,584 whereas payroll expenditures per the SEFA amounted to $39,797,081. Questioned Costs – Not Determinable. Context – This is a condition identified per review of the School System’s population completeness over the compliance requirements for each program. The prevalence of these findings is detailed in the condition section above. Effect – The SEFA may not be completely and accurately stated. In addition, the lack of established internal controls policies and procedures to ensure the SEFA is completely and accurately stated can lead to noncompliance with federal statutes, regulations, and provisions of grant agreements. Cause – The School System did not adhere to their internal policies and procedures to ensure the accuracy of the SEFA. Recommendation – We recommend that the School System develop policies and procedures and enhance their existing reconciliation process to ensure the completeness and accuracy of the SEFA, and that amounts reported on the SEFA are supported by transaction level detail. Views of Responsible Officials – The School System does not concur with the auditor’s findings and recommendations. The total expenditures for all federal programs recorded in the Schedule of Expenditures for Federal Awards are accurately presented and tie to the general ledger. The payroll sub-ledger is corrected before posting to the general ledger every two weeks. The resulting differences are most often immaterial but can be traced to corrections made by the Accounting Office after payroll is reviewed by the grants Restricted Funds Supervisor to ensure payroll is not posted to expired grants. The planned corrective actions are presented in the School System’s Corrective Action Plan attached as Appendix B to the Single Audit Report. BDO Response – We have reviewed management’s response and our finding remains as indicated, since we could not validate the details of the differences.
Finding Number 2022-008 Prior Year Finding Number N/A Compliance Requirement: Allowable Costs/Costs Principles Program: U.S. Department of Education Title I Grants to Local Educational Agencies ALN #: 84.010 Award #: Various Award Period: Various COVID-19 – Governor’s Emergency Education Relief (GEER) ALN #: 84.425C Award #: Various Award Period: Various COVID-19 – Elementary and Secondary School Emergency Relief (ESSR) Fund ALN #: 84.425D Award #: Various Award Period: Various COVID-19 – American Rescue Plan - Elementary and Secondary School Emergency Relief (ARP ESSR) ALN #: 84.425U Award #: 211941 Award Period: 03/24/2021 – 09/30/2023 COVID-19 – American Rescue Plan - Elementary and Secondary School Emergency Relief – Homeless Children and Youth ALN #: 84.425W Award #: Various Award Period: Various Criteria – In accordance with §200.302 Financial Management, a 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. The financial management system of each non-federal entity must provide for the following: 1. Identification, in its accounts, of all federal awards received and expended and the federal programs under which they were received. 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. 3. Records that identify adequately the source and application of funds for federally funded activities. 4. Effective control over, and accountability for, all funds, property, and other assets. The Uniform Guidance in 2 CFR Section 200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Further, CFR Section 200.510 (b) requires the auditee must also prepare a Schedule of Expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR section 200.502, Basis for determining Federal awards expended. Condition – The amounts recorded in the Schedule of Expenditures of Federal Awards (SEFA) agree to the total amount recorded in the general ledger. The summary level payroll transactions recorded in the general ledger could not be reconciled to the transaction level detail provided from the payroll system. When comparing the two populations, we identified the following differences: • ALN 84.425 - For ALN 84.425 sub-program D, we noted a variance of $1,828,609. Total payroll expenditures per the payroll system details amounted to $18,437,724 whereas payroll expenditures per SEFA amounted to $16,609,116. In addition to the above, for ALN 84.425 sub-program U, we noted a variance of $301,432. Total payroll expenditures per the payroll system details amounted to $3,607,738 whereas payroll expenditures per the SEFA amounted to $3,909,170. • ALN 84.010 - We noted a variance of $752,503. Total payroll expenditures per the payroll system details amounted to $40,549,584 whereas payroll expenditures per the SEFA amounted to $39,797,081. Questioned Costs – Not Determinable. Context – This is a condition identified per review of the School System’s population completeness over the compliance requirements for each program. The prevalence of these findings is detailed in the condition section above. Effect – The SEFA may not be completely and accurately stated. In addition, the lack of established internal controls policies and procedures to ensure the SEFA is completely and accurately stated can lead to noncompliance with federal statutes, regulations, and provisions of grant agreements. Cause – The School System did not adhere to their internal policies and procedures to ensure the accuracy of the SEFA. Recommendation – We recommend that the School System develop policies and procedures and enhance their existing reconciliation process to ensure the completeness and accuracy of the SEFA, and that amounts reported on the SEFA are supported by transaction level detail. Views of Responsible Officials – The School System does not concur with the auditor’s findings and recommendations. The total expenditures for all federal programs recorded in the Schedule of Expenditures for Federal Awards are accurately presented and tie to the general ledger. The payroll sub-ledger is corrected before posting to the general ledger every two weeks. The resulting differences are most often immaterial but can be traced to corrections made by the Accounting Office after payroll is reviewed by the grants Restricted Funds Supervisor to ensure payroll is not posted to expired grants. The planned corrective actions are presented in the School System’s Corrective Action Plan attached as Appendix B to the Single Audit Report. BDO Response – We have reviewed management’s response and our finding remains as indicated, since we could not validate the details of the differences.
Finding Number 2022-008 Prior Year Finding Number N/A Compliance Requirement: Allowable Costs/Costs Principles Program: U.S. Department of Education Title I Grants to Local Educational Agencies ALN #: 84.010 Award #: Various Award Period: Various COVID-19 – Governor’s Emergency Education Relief (GEER) ALN #: 84.425C Award #: Various Award Period: Various COVID-19 – Elementary and Secondary School Emergency Relief (ESSR) Fund ALN #: 84.425D Award #: Various Award Period: Various COVID-19 – American Rescue Plan - Elementary and Secondary School Emergency Relief (ARP ESSR) ALN #: 84.425U Award #: 211941 Award Period: 03/24/2021 – 09/30/2023 COVID-19 – American Rescue Plan - Elementary and Secondary School Emergency Relief – Homeless Children and Youth ALN #: 84.425W Award #: Various Award Period: Various Criteria – In accordance with §200.302 Financial Management, a 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. The financial management system of each non-federal entity must provide for the following: 1. Identification, in its accounts, of all federal awards received and expended and the federal programs under which they were received. 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. 3. Records that identify adequately the source and application of funds for federally funded activities. 4. Effective control over, and accountability for, all funds, property, and other assets. The Uniform Guidance in 2 CFR Section 200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Further, CFR Section 200.510 (b) requires the auditee must also prepare a Schedule of Expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR section 200.502, Basis for determining Federal awards expended. Condition – The amounts recorded in the Schedule of Expenditures of Federal Awards (SEFA) agree to the total amount recorded in the general ledger. The summary level payroll transactions recorded in the general ledger could not be reconciled to the transaction level detail provided from the payroll system. When comparing the two populations, we identified the following differences: • ALN 84.425 - For ALN 84.425 sub-program D, we noted a variance of $1,828,609. Total payroll expenditures per the payroll system details amounted to $18,437,724 whereas payroll expenditures per SEFA amounted to $16,609,116. In addition to the above, for ALN 84.425 sub-program U, we noted a variance of $301,432. Total payroll expenditures per the payroll system details amounted to $3,607,738 whereas payroll expenditures per the SEFA amounted to $3,909,170. • ALN 84.010 - We noted a variance of $752,503. Total payroll expenditures per the payroll system details amounted to $40,549,584 whereas payroll expenditures per the SEFA amounted to $39,797,081. Questioned Costs – Not Determinable. Context – This is a condition identified per review of the School System’s population completeness over the compliance requirements for each program. The prevalence of these findings is detailed in the condition section above. Effect – The SEFA may not be completely and accurately stated. In addition, the lack of established internal controls policies and procedures to ensure the SEFA is completely and accurately stated can lead to noncompliance with federal statutes, regulations, and provisions of grant agreements. Cause – The School System did not adhere to their internal policies and procedures to ensure the accuracy of the SEFA. Recommendation – We recommend that the School System develop policies and procedures and enhance their existing reconciliation process to ensure the completeness and accuracy of the SEFA, and that amounts reported on the SEFA are supported by transaction level detail. Views of Responsible Officials – The School System does not concur with the auditor’s findings and recommendations. The total expenditures for all federal programs recorded in the Schedule of Expenditures for Federal Awards are accurately presented and tie to the general ledger. The payroll sub-ledger is corrected before posting to the general ledger every two weeks. The resulting differences are most often immaterial but can be traced to corrections made by the Accounting Office after payroll is reviewed by the grants Restricted Funds Supervisor to ensure payroll is not posted to expired grants. The planned corrective actions are presented in the School System’s Corrective Action Plan attached as Appendix B to the Single Audit Report. BDO Response – We have reviewed management’s response and our finding remains as indicated, since we could not validate the details of the differences.
Finding Number 2022-008 Prior Year Finding Number N/A Compliance Requirement: Allowable Costs/Costs Principles Program: U.S. Department of Education Title I Grants to Local Educational Agencies ALN #: 84.010 Award #: Various Award Period: Various COVID-19 – Governor’s Emergency Education Relief (GEER) ALN #: 84.425C Award #: Various Award Period: Various COVID-19 – Elementary and Secondary School Emergency Relief (ESSR) Fund ALN #: 84.425D Award #: Various Award Period: Various COVID-19 – American Rescue Plan - Elementary and Secondary School Emergency Relief (ARP ESSR) ALN #: 84.425U Award #: 211941 Award Period: 03/24/2021 – 09/30/2023 COVID-19 – American Rescue Plan - Elementary and Secondary School Emergency Relief – Homeless Children and Youth ALN #: 84.425W Award #: Various Award Period: Various Criteria – In accordance with §200.302 Financial Management, a 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. The financial management system of each non-federal entity must provide for the following: 1. Identification, in its accounts, of all federal awards received and expended and the federal programs under which they were received. 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. 3. Records that identify adequately the source and application of funds for federally funded activities. 4. Effective control over, and accountability for, all funds, property, and other assets. The Uniform Guidance in 2 CFR Section 200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Further, CFR Section 200.510 (b) requires the auditee must also prepare a Schedule of Expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR section 200.502, Basis for determining Federal awards expended. Condition – The amounts recorded in the Schedule of Expenditures of Federal Awards (SEFA) agree to the total amount recorded in the general ledger. The summary level payroll transactions recorded in the general ledger could not be reconciled to the transaction level detail provided from the payroll system. When comparing the two populations, we identified the following differences: • ALN 84.425 - For ALN 84.425 sub-program D, we noted a variance of $1,828,609. Total payroll expenditures per the payroll system details amounted to $18,437,724 whereas payroll expenditures per SEFA amounted to $16,609,116. In addition to the above, for ALN 84.425 sub-program U, we noted a variance of $301,432. Total payroll expenditures per the payroll system details amounted to $3,607,738 whereas payroll expenditures per the SEFA amounted to $3,909,170. • ALN 84.010 - We noted a variance of $752,503. Total payroll expenditures per the payroll system details amounted to $40,549,584 whereas payroll expenditures per the SEFA amounted to $39,797,081. Questioned Costs – Not Determinable. Context – This is a condition identified per review of the School System’s population completeness over the compliance requirements for each program. The prevalence of these findings is detailed in the condition section above. Effect – The SEFA may not be completely and accurately stated. In addition, the lack of established internal controls policies and procedures to ensure the SEFA is completely and accurately stated can lead to noncompliance with federal statutes, regulations, and provisions of grant agreements. Cause – The School System did not adhere to their internal policies and procedures to ensure the accuracy of the SEFA. Recommendation – We recommend that the School System develop policies and procedures and enhance their existing reconciliation process to ensure the completeness and accuracy of the SEFA, and that amounts reported on the SEFA are supported by transaction level detail. Views of Responsible Officials – The School System does not concur with the auditor’s findings and recommendations. The total expenditures for all federal programs recorded in the Schedule of Expenditures for Federal Awards are accurately presented and tie to the general ledger. The payroll sub-ledger is corrected before posting to the general ledger every two weeks. The resulting differences are most often immaterial but can be traced to corrections made by the Accounting Office after payroll is reviewed by the grants Restricted Funds Supervisor to ensure payroll is not posted to expired grants. The planned corrective actions are presented in the School System’s Corrective Action Plan attached as Appendix B to the Single Audit Report. BDO Response – We have reviewed management’s response and our finding remains as indicated, since we could not validate the details of the differences.
Finding Number 2022-008 Prior Year Finding Number N/A Compliance Requirement: Allowable Costs/Costs Principles Program: U.S. Department of Education Title I Grants to Local Educational Agencies ALN #: 84.010 Award #: Various Award Period: Various COVID-19 – Governor’s Emergency Education Relief (GEER) ALN #: 84.425C Award #: Various Award Period: Various COVID-19 – Elementary and Secondary School Emergency Relief (ESSR) Fund ALN #: 84.425D Award #: Various Award Period: Various COVID-19 – American Rescue Plan - Elementary and Secondary School Emergency Relief (ARP ESSR) ALN #: 84.425U Award #: 211941 Award Period: 03/24/2021 – 09/30/2023 COVID-19 – American Rescue Plan - Elementary and Secondary School Emergency Relief – Homeless Children and Youth ALN #: 84.425W Award #: Various Award Period: Various Criteria – In accordance with §200.302 Financial Management, a 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. The financial management system of each non-federal entity must provide for the following: 1. Identification, in its accounts, of all federal awards received and expended and the federal programs under which they were received. 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. 3. Records that identify adequately the source and application of funds for federally funded activities. 4. Effective control over, and accountability for, all funds, property, and other assets. The Uniform Guidance in 2 CFR Section 200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Further, CFR Section 200.510 (b) requires the auditee must also prepare a Schedule of Expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR section 200.502, Basis for determining Federal awards expended. Condition – The amounts recorded in the Schedule of Expenditures of Federal Awards (SEFA) agree to the total amount recorded in the general ledger. The summary level payroll transactions recorded in the general ledger could not be reconciled to the transaction level detail provided from the payroll system. When comparing the two populations, we identified the following differences: • ALN 84.425 - For ALN 84.425 sub-program D, we noted a variance of $1,828,609. Total payroll expenditures per the payroll system details amounted to $18,437,724 whereas payroll expenditures per SEFA amounted to $16,609,116. In addition to the above, for ALN 84.425 sub-program U, we noted a variance of $301,432. Total payroll expenditures per the payroll system details amounted to $3,607,738 whereas payroll expenditures per the SEFA amounted to $3,909,170. • ALN 84.010 - We noted a variance of $752,503. Total payroll expenditures per the payroll system details amounted to $40,549,584 whereas payroll expenditures per the SEFA amounted to $39,797,081. Questioned Costs – Not Determinable. Context – This is a condition identified per review of the School System’s population completeness over the compliance requirements for each program. The prevalence of these findings is detailed in the condition section above. Effect – The SEFA may not be completely and accurately stated. In addition, the lack of established internal controls policies and procedures to ensure the SEFA is completely and accurately stated can lead to noncompliance with federal statutes, regulations, and provisions of grant agreements. Cause – The School System did not adhere to their internal policies and procedures to ensure the accuracy of the SEFA. Recommendation – We recommend that the School System develop policies and procedures and enhance their existing reconciliation process to ensure the completeness and accuracy of the SEFA, and that amounts reported on the SEFA are supported by transaction level detail. Views of Responsible Officials – The School System does not concur with the auditor’s findings and recommendations. The total expenditures for all federal programs recorded in the Schedule of Expenditures for Federal Awards are accurately presented and tie to the general ledger. The payroll sub-ledger is corrected before posting to the general ledger every two weeks. The resulting differences are most often immaterial but can be traced to corrections made by the Accounting Office after payroll is reviewed by the grants Restricted Funds Supervisor to ensure payroll is not posted to expired grants. The planned corrective actions are presented in the School System’s Corrective Action Plan attached as Appendix B to the Single Audit Report. BDO Response – We have reviewed management’s response and our finding remains as indicated, since we could not validate the details of the differences.
Finding Number 2022-008 Prior Year Finding Number N/A Compliance Requirement: Allowable Costs/Costs Principles Program: U.S. Department of Education Title I Grants to Local Educational Agencies ALN #: 84.010 Award #: Various Award Period: Various COVID-19 – Governor’s Emergency Education Relief (GEER) ALN #: 84.425C Award #: Various Award Period: Various COVID-19 – Elementary and Secondary School Emergency Relief (ESSR) Fund ALN #: 84.425D Award #: Various Award Period: Various COVID-19 – American Rescue Plan - Elementary and Secondary School Emergency Relief (ARP ESSR) ALN #: 84.425U Award #: 211941 Award Period: 03/24/2021 – 09/30/2023 COVID-19 – American Rescue Plan - Elementary and Secondary School Emergency Relief – Homeless Children and Youth ALN #: 84.425W Award #: Various Award Period: Various Criteria – In accordance with §200.302 Financial Management, a 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. The financial management system of each non-federal entity must provide for the following: 1. Identification, in its accounts, of all federal awards received and expended and the federal programs under which they were received. 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. 3. Records that identify adequately the source and application of funds for federally funded activities. 4. Effective control over, and accountability for, all funds, property, and other assets. The Uniform Guidance in 2 CFR Section 200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Further, CFR Section 200.510 (b) requires the auditee must also prepare a Schedule of Expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR section 200.502, Basis for determining Federal awards expended. Condition – The amounts recorded in the Schedule of Expenditures of Federal Awards (SEFA) agree to the total amount recorded in the general ledger. The summary level payroll transactions recorded in the general ledger could not be reconciled to the transaction level detail provided from the payroll system. When comparing the two populations, we identified the following differences: • ALN 84.425 - For ALN 84.425 sub-program D, we noted a variance of $1,828,609. Total payroll expenditures per the payroll system details amounted to $18,437,724 whereas payroll expenditures per SEFA amounted to $16,609,116. In addition to the above, for ALN 84.425 sub-program U, we noted a variance of $301,432. Total payroll expenditures per the payroll system details amounted to $3,607,738 whereas payroll expenditures per the SEFA amounted to $3,909,170. • ALN 84.010 - We noted a variance of $752,503. Total payroll expenditures per the payroll system details amounted to $40,549,584 whereas payroll expenditures per the SEFA amounted to $39,797,081. Questioned Costs – Not Determinable. Context – This is a condition identified per review of the School System’s population completeness over the compliance requirements for each program. The prevalence of these findings is detailed in the condition section above. Effect – The SEFA may not be completely and accurately stated. In addition, the lack of established internal controls policies and procedures to ensure the SEFA is completely and accurately stated can lead to noncompliance with federal statutes, regulations, and provisions of grant agreements. Cause – The School System did not adhere to their internal policies and procedures to ensure the accuracy of the SEFA. Recommendation – We recommend that the School System develop policies and procedures and enhance their existing reconciliation process to ensure the completeness and accuracy of the SEFA, and that amounts reported on the SEFA are supported by transaction level detail. Views of Responsible Officials – The School System does not concur with the auditor’s findings and recommendations. The total expenditures for all federal programs recorded in the Schedule of Expenditures for Federal Awards are accurately presented and tie to the general ledger. The payroll sub-ledger is corrected before posting to the general ledger every two weeks. The resulting differences are most often immaterial but can be traced to corrections made by the Accounting Office after payroll is reviewed by the grants Restricted Funds Supervisor to ensure payroll is not posted to expired grants. The planned corrective actions are presented in the School System’s Corrective Action Plan attached as Appendix B to the Single Audit Report. BDO Response – We have reviewed management’s response and our finding remains as indicated, since we could not validate the details of the differences.
Finding Number 2022-008 Prior Year Finding Number N/A Compliance Requirement: Allowable Costs/Costs Principles Program: U.S. Department of Education Title I Grants to Local Educational Agencies ALN #: 84.010 Award #: Various Award Period: Various COVID-19 – Governor’s Emergency Education Relief (GEER) ALN #: 84.425C Award #: Various Award Period: Various COVID-19 – Elementary and Secondary School Emergency Relief (ESSR) Fund ALN #: 84.425D Award #: Various Award Period: Various COVID-19 – American Rescue Plan - Elementary and Secondary School Emergency Relief (ARP ESSR) ALN #: 84.425U Award #: 211941 Award Period: 03/24/2021 – 09/30/2023 COVID-19 – American Rescue Plan - Elementary and Secondary School Emergency Relief – Homeless Children and Youth ALN #: 84.425W Award #: Various Award Period: Various Criteria – In accordance with §200.302 Financial Management, a 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. The financial management system of each non-federal entity must provide for the following: 1. Identification, in its accounts, of all federal awards received and expended and the federal programs under which they were received. 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. 3. Records that identify adequately the source and application of funds for federally funded activities. 4. Effective control over, and accountability for, all funds, property, and other assets. The Uniform Guidance in 2 CFR Section 200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Further, CFR Section 200.510 (b) requires the auditee must also prepare a Schedule of Expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR section 200.502, Basis for determining Federal awards expended. Condition – The amounts recorded in the Schedule of Expenditures of Federal Awards (SEFA) agree to the total amount recorded in the general ledger. The summary level payroll transactions recorded in the general ledger could not be reconciled to the transaction level detail provided from the payroll system. When comparing the two populations, we identified the following differences: • ALN 84.425 - For ALN 84.425 sub-program D, we noted a variance of $1,828,609. Total payroll expenditures per the payroll system details amounted to $18,437,724 whereas payroll expenditures per SEFA amounted to $16,609,116. In addition to the above, for ALN 84.425 sub-program U, we noted a variance of $301,432. Total payroll expenditures per the payroll system details amounted to $3,607,738 whereas payroll expenditures per the SEFA amounted to $3,909,170. • ALN 84.010 - We noted a variance of $752,503. Total payroll expenditures per the payroll system details amounted to $40,549,584 whereas payroll expenditures per the SEFA amounted to $39,797,081. Questioned Costs – Not Determinable. Context – This is a condition identified per review of the School System’s population completeness over the compliance requirements for each program. The prevalence of these findings is detailed in the condition section above. Effect – The SEFA may not be completely and accurately stated. In addition, the lack of established internal controls policies and procedures to ensure the SEFA is completely and accurately stated can lead to noncompliance with federal statutes, regulations, and provisions of grant agreements. Cause – The School System did not adhere to their internal policies and procedures to ensure the accuracy of the SEFA. Recommendation – We recommend that the School System develop policies and procedures and enhance their existing reconciliation process to ensure the completeness and accuracy of the SEFA, and that amounts reported on the SEFA are supported by transaction level detail. Views of Responsible Officials – The School System does not concur with the auditor’s findings and recommendations. The total expenditures for all federal programs recorded in the Schedule of Expenditures for Federal Awards are accurately presented and tie to the general ledger. The payroll sub-ledger is corrected before posting to the general ledger every two weeks. The resulting differences are most often immaterial but can be traced to corrections made by the Accounting Office after payroll is reviewed by the grants Restricted Funds Supervisor to ensure payroll is not posted to expired grants. The planned corrective actions are presented in the School System’s Corrective Action Plan attached as Appendix B to the Single Audit Report. BDO Response – We have reviewed management’s response and our finding remains as indicated, since we could not validate the details of the differences.
Criteria: Uniform Guidance requires written procedures for cash management and determining the allowability of costs in accordance with Subpart E – Cost Principals. Condition: The Agency 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: The Agency’s written policies and procedures were not updated to include required Uniform Guidance policies. Effect: Employees of the Agency could enter into a transaction that is not in compliance with Uniform Guidance requirements. Recommendation: We recommend the Agency 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 adopted the appropriate policies and procedures in December 2023.
Criteria: Uniform Guidance requires written procedures for cash management and determining the allowability of costs in accordance with Subpart E – Cost Principals. Condition: The Agency 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: The Agency’s written policies and procedures were not updated to include required Uniform Guidance policies. Effect: Employees of the Agency could enter into a transaction that is not in compliance with Uniform Guidance requirements. Recommendation: We recommend the Agency 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 adopted the appropriate policies and procedures in December 2023.
Criteria: Uniform Guidance requires written procedures for cash management and determining the allowability of costs in accordance with Subpart E – Cost Principals. Condition: The Agency 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: The Agency’s written policies and procedures were not updated to include required Uniform Guidance policies. Effect: Employees of the Agency could enter into a transaction that is not in compliance with Uniform Guidance requirements. Recommendation: We recommend the Agency 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 adopted the appropriate policies and procedures in December 2023.
2022-003: Significant Deficiency in Internal Control / Immaterial Noncompliance – Cash Management (repeat comment) Federal Program: WIOA Cluster (ALN 17.258/17.259/17.278) Criteria: 2 CFR 200.305(b) states, in part: “For Non-Federal entities payment methods must minimize the time elapsing between the transfer of funds from the United States Treasury or the pass-through entity and the disbursement by the non-Federal entity…” 2 CFR 200.305(b)(2)(ii) states, in part: “Non-Federal entities must be authorized to submit requests for advance payments and reimbursements….”. 2 CFR 200.302(b)(6) states, in part: “the financial management system of each non-Federal entity must provide for written procedures to implement the requirements of 2 CFR 200.305 – Federal Payment”. Condition: 1) The Consortium requested funds in advance of when the related disbursements were made, 2) the basis for the advances (requests) were not supported by appropriate documentation, and 3) authorization for requesting funds in advance was not obtained. Context: The amount overdrawn for the WIOA Cluster totaled $125,668. It was noted that other programs were also overdrawn as follows: SNAP Cluster (ALN 10.561): $81,751 and Unemployment Insurance (ALN 17.225): $8,143. The total amount of funds overdrawn as of year-end totaled $215,562. Cause: Management oversight. Effect: Funds were requested and received in advance of when the related payments were disbursed without obtaining authorization for advance payments, and without properly documenting the basis for the requested funds. Consequently, the Consortium did not minimize the time elapsing between the transfer of funds from the United States Treasury or the pass-through entity and the disbursement by the non-Federal entity. Recommendation: The Consortium should carefully review their policies and procedures and make the necessary changes to assure that cash draws are based on expenditures already incurred and they are supported by transactions recorded in the books and records of the Consortium. Views of Responsible Officials: We agree with the finding. Michigan Works! Southeast will continue to ensure it adheres to the policy standards for cash on hand time limits.
2022-003: Significant Deficiency in Internal Control / Immaterial Noncompliance – Cash Management (repeat comment) Federal Program: WIOA Cluster (ALN 17.258/17.259/17.278) Criteria: 2 CFR 200.305(b) states, in part: “For Non-Federal entities payment methods must minimize the time elapsing between the transfer of funds from the United States Treasury or the pass-through entity and the disbursement by the non-Federal entity…” 2 CFR 200.305(b)(2)(ii) states, in part: “Non-Federal entities must be authorized to submit requests for advance payments and reimbursements….”. 2 CFR 200.302(b)(6) states, in part: “the financial management system of each non-Federal entity must provide for written procedures to implement the requirements of 2 CFR 200.305 – Federal Payment”. Condition: 1) The Consortium requested funds in advance of when the related disbursements were made, 2) the basis for the advances (requests) were not supported by appropriate documentation, and 3) authorization for requesting funds in advance was not obtained. Context: The amount overdrawn for the WIOA Cluster totaled $125,668. It was noted that other programs were also overdrawn as follows: SNAP Cluster (ALN 10.561): $81,751 and Unemployment Insurance (ALN 17.225): $8,143. The total amount of funds overdrawn as of year-end totaled $215,562. Cause: Management oversight. Effect: Funds were requested and received in advance of when the related payments were disbursed without obtaining authorization for advance payments, and without properly documenting the basis for the requested funds. Consequently, the Consortium did not minimize the time elapsing between the transfer of funds from the United States Treasury or the pass-through entity and the disbursement by the non-Federal entity. Recommendation: The Consortium should carefully review their policies and procedures and make the necessary changes to assure that cash draws are based on expenditures already incurred and they are supported by transactions recorded in the books and records of the Consortium. Views of Responsible Officials: We agree with the finding. Michigan Works! Southeast will continue to ensure it adheres to the policy standards for cash on hand time limits.
2022-003: Significant Deficiency in Internal Control / Immaterial Noncompliance – Cash Management (repeat comment) Federal Program: WIOA Cluster (ALN 17.258/17.259/17.278) Criteria: 2 CFR 200.305(b) states, in part: “For Non-Federal entities payment methods must minimize the time elapsing between the transfer of funds from the United States Treasury or the pass-through entity and the disbursement by the non-Federal entity…” 2 CFR 200.305(b)(2)(ii) states, in part: “Non-Federal entities must be authorized to submit requests for advance payments and reimbursements….”. 2 CFR 200.302(b)(6) states, in part: “the financial management system of each non-Federal entity must provide for written procedures to implement the requirements of 2 CFR 200.305 – Federal Payment”. Condition: 1) The Consortium requested funds in advance of when the related disbursements were made, 2) the basis for the advances (requests) were not supported by appropriate documentation, and 3) authorization for requesting funds in advance was not obtained. Context: The amount overdrawn for the WIOA Cluster totaled $125,668. It was noted that other programs were also overdrawn as follows: SNAP Cluster (ALN 10.561): $81,751 and Unemployment Insurance (ALN 17.225): $8,143. The total amount of funds overdrawn as of year-end totaled $215,562. Cause: Management oversight. Effect: Funds were requested and received in advance of when the related payments were disbursed without obtaining authorization for advance payments, and without properly documenting the basis for the requested funds. Consequently, the Consortium did not minimize the time elapsing between the transfer of funds from the United States Treasury or the pass-through entity and the disbursement by the non-Federal entity. Recommendation: The Consortium should carefully review their policies and procedures and make the necessary changes to assure that cash draws are based on expenditures already incurred and they are supported by transactions recorded in the books and records of the Consortium. Views of Responsible Officials: We agree with the finding. Michigan Works! Southeast will continue to ensure it adheres to the policy standards for cash on hand time limits.
2022-003: Significant Deficiency in Internal Control / Immaterial Noncompliance – Cash Management (repeat comment) Federal Program: WIOA Cluster (ALN 17.258/17.259/17.278) Criteria: 2 CFR 200.305(b) states, in part: “For Non-Federal entities payment methods must minimize the time elapsing between the transfer of funds from the United States Treasury or the pass-through entity and the disbursement by the non-Federal entity…” 2 CFR 200.305(b)(2)(ii) states, in part: “Non-Federal entities must be authorized to submit requests for advance payments and reimbursements….”. 2 CFR 200.302(b)(6) states, in part: “the financial management system of each non-Federal entity must provide for written procedures to implement the requirements of 2 CFR 200.305 – Federal Payment”. Condition: 1) The Consortium requested funds in advance of when the related disbursements were made, 2) the basis for the advances (requests) were not supported by appropriate documentation, and 3) authorization for requesting funds in advance was not obtained. Context: The amount overdrawn for the WIOA Cluster totaled $125,668. It was noted that other programs were also overdrawn as follows: SNAP Cluster (ALN 10.561): $81,751 and Unemployment Insurance (ALN 17.225): $8,143. The total amount of funds overdrawn as of year-end totaled $215,562. Cause: Management oversight. Effect: Funds were requested and received in advance of when the related payments were disbursed without obtaining authorization for advance payments, and without properly documenting the basis for the requested funds. Consequently, the Consortium did not minimize the time elapsing between the transfer of funds from the United States Treasury or the pass-through entity and the disbursement by the non-Federal entity. Recommendation: The Consortium should carefully review their policies and procedures and make the necessary changes to assure that cash draws are based on expenditures already incurred and they are supported by transactions recorded in the books and records of the Consortium. Views of Responsible Officials: We agree with the finding. Michigan Works! Southeast will continue to ensure it adheres to the policy standards for cash on hand time limits.
2022-003: Significant Deficiency in Internal Control / Immaterial Noncompliance – Cash Management (repeat comment) Federal Program: WIOA Cluster (ALN 17.258/17.259/17.278) Criteria: 2 CFR 200.305(b) states, in part: “For Non-Federal entities payment methods must minimize the time elapsing between the transfer of funds from the United States Treasury or the pass-through entity and the disbursement by the non-Federal entity…” 2 CFR 200.305(b)(2)(ii) states, in part: “Non-Federal entities must be authorized to submit requests for advance payments and reimbursements….”. 2 CFR 200.302(b)(6) states, in part: “the financial management system of each non-Federal entity must provide for written procedures to implement the requirements of 2 CFR 200.305 – Federal Payment”. Condition: 1) The Consortium requested funds in advance of when the related disbursements were made, 2) the basis for the advances (requests) were not supported by appropriate documentation, and 3) authorization for requesting funds in advance was not obtained. Context: The amount overdrawn for the WIOA Cluster totaled $125,668. It was noted that other programs were also overdrawn as follows: SNAP Cluster (ALN 10.561): $81,751 and Unemployment Insurance (ALN 17.225): $8,143. The total amount of funds overdrawn as of year-end totaled $215,562. Cause: Management oversight. Effect: Funds were requested and received in advance of when the related payments were disbursed without obtaining authorization for advance payments, and without properly documenting the basis for the requested funds. Consequently, the Consortium did not minimize the time elapsing between the transfer of funds from the United States Treasury or the pass-through entity and the disbursement by the non-Federal entity. Recommendation: The Consortium should carefully review their policies and procedures and make the necessary changes to assure that cash draws are based on expenditures already incurred and they are supported by transactions recorded in the books and records of the Consortium. Views of Responsible Officials: We agree with the finding. Michigan Works! Southeast will continue to ensure it adheres to the policy standards for cash on hand time limits.
2022-003: Significant Deficiency in Internal Control / Immaterial Noncompliance – Cash Management (repeat comment) Federal Program: WIOA Cluster (ALN 17.258/17.259/17.278) Criteria: 2 CFR 200.305(b) states, in part: “For Non-Federal entities payment methods must minimize the time elapsing between the transfer of funds from the United States Treasury or the pass-through entity and the disbursement by the non-Federal entity…” 2 CFR 200.305(b)(2)(ii) states, in part: “Non-Federal entities must be authorized to submit requests for advance payments and reimbursements….”. 2 CFR 200.302(b)(6) states, in part: “the financial management system of each non-Federal entity must provide for written procedures to implement the requirements of 2 CFR 200.305 – Federal Payment”. Condition: 1) The Consortium requested funds in advance of when the related disbursements were made, 2) the basis for the advances (requests) were not supported by appropriate documentation, and 3) authorization for requesting funds in advance was not obtained. Context: The amount overdrawn for the WIOA Cluster totaled $125,668. It was noted that other programs were also overdrawn as follows: SNAP Cluster (ALN 10.561): $81,751 and Unemployment Insurance (ALN 17.225): $8,143. The total amount of funds overdrawn as of year-end totaled $215,562. Cause: Management oversight. Effect: Funds were requested and received in advance of when the related payments were disbursed without obtaining authorization for advance payments, and without properly documenting the basis for the requested funds. Consequently, the Consortium did not minimize the time elapsing between the transfer of funds from the United States Treasury or the pass-through entity and the disbursement by the non-Federal entity. Recommendation: The Consortium should carefully review their policies and procedures and make the necessary changes to assure that cash draws are based on expenditures already incurred and they are supported by transactions recorded in the books and records of the Consortium. Views of Responsible Officials: We agree with the finding. Michigan Works! Southeast will continue to ensure it adheres to the policy standards for cash on hand time limits.
2022-003: Significant Deficiency in Internal Control / Immaterial Noncompliance – Cash Management (repeat comment) Federal Program: WIOA Cluster (ALN 17.258/17.259/17.278) Criteria: 2 CFR 200.305(b) states, in part: “For Non-Federal entities payment methods must minimize the time elapsing between the transfer of funds from the United States Treasury or the pass-through entity and the disbursement by the non-Federal entity…” 2 CFR 200.305(b)(2)(ii) states, in part: “Non-Federal entities must be authorized to submit requests for advance payments and reimbursements….”. 2 CFR 200.302(b)(6) states, in part: “the financial management system of each non-Federal entity must provide for written procedures to implement the requirements of 2 CFR 200.305 – Federal Payment”. Condition: 1) The Consortium requested funds in advance of when the related disbursements were made, 2) the basis for the advances (requests) were not supported by appropriate documentation, and 3) authorization for requesting funds in advance was not obtained. Context: The amount overdrawn for the WIOA Cluster totaled $125,668. It was noted that other programs were also overdrawn as follows: SNAP Cluster (ALN 10.561): $81,751 and Unemployment Insurance (ALN 17.225): $8,143. The total amount of funds overdrawn as of year-end totaled $215,562. Cause: Management oversight. Effect: Funds were requested and received in advance of when the related payments were disbursed without obtaining authorization for advance payments, and without properly documenting the basis for the requested funds. Consequently, the Consortium did not minimize the time elapsing between the transfer of funds from the United States Treasury or the pass-through entity and the disbursement by the non-Federal entity. Recommendation: The Consortium should carefully review their policies and procedures and make the necessary changes to assure that cash draws are based on expenditures already incurred and they are supported by transactions recorded in the books and records of the Consortium. Views of Responsible Officials: We agree with the finding. Michigan Works! Southeast will continue to ensure it adheres to the policy standards for cash on hand time limits.
2022-003: Significant Deficiency in Internal Control / Immaterial Noncompliance – Cash Management (repeat comment) Federal Program: WIOA Cluster (ALN 17.258/17.259/17.278) Criteria: 2 CFR 200.305(b) states, in part: “For Non-Federal entities payment methods must minimize the time elapsing between the transfer of funds from the United States Treasury or the pass-through entity and the disbursement by the non-Federal entity…” 2 CFR 200.305(b)(2)(ii) states, in part: “Non-Federal entities must be authorized to submit requests for advance payments and reimbursements….”. 2 CFR 200.302(b)(6) states, in part: “the financial management system of each non-Federal entity must provide for written procedures to implement the requirements of 2 CFR 200.305 – Federal Payment”. Condition: 1) The Consortium requested funds in advance of when the related disbursements were made, 2) the basis for the advances (requests) were not supported by appropriate documentation, and 3) authorization for requesting funds in advance was not obtained. Context: The amount overdrawn for the WIOA Cluster totaled $125,668. It was noted that other programs were also overdrawn as follows: SNAP Cluster (ALN 10.561): $81,751 and Unemployment Insurance (ALN 17.225): $8,143. The total amount of funds overdrawn as of year-end totaled $215,562. Cause: Management oversight. Effect: Funds were requested and received in advance of when the related payments were disbursed without obtaining authorization for advance payments, and without properly documenting the basis for the requested funds. Consequently, the Consortium did not minimize the time elapsing between the transfer of funds from the United States Treasury or the pass-through entity and the disbursement by the non-Federal entity. Recommendation: The Consortium should carefully review their policies and procedures and make the necessary changes to assure that cash draws are based on expenditures already incurred and they are supported by transactions recorded in the books and records of the Consortium. Views of Responsible Officials: We agree with the finding. Michigan Works! Southeast will continue to ensure it adheres to the policy standards for cash on hand time limits.
2022-003: Significant Deficiency in Internal Control / Immaterial Noncompliance – Cash Management (repeat comment) Federal Program: WIOA Cluster (ALN 17.258/17.259/17.278) Criteria: 2 CFR 200.305(b) states, in part: “For Non-Federal entities payment methods must minimize the time elapsing between the transfer of funds from the United States Treasury or the pass-through entity and the disbursement by the non-Federal entity…” 2 CFR 200.305(b)(2)(ii) states, in part: “Non-Federal entities must be authorized to submit requests for advance payments and reimbursements….”. 2 CFR 200.302(b)(6) states, in part: “the financial management system of each non-Federal entity must provide for written procedures to implement the requirements of 2 CFR 200.305 – Federal Payment”. Condition: 1) The Consortium requested funds in advance of when the related disbursements were made, 2) the basis for the advances (requests) were not supported by appropriate documentation, and 3) authorization for requesting funds in advance was not obtained. Context: The amount overdrawn for the WIOA Cluster totaled $125,668. It was noted that other programs were also overdrawn as follows: SNAP Cluster (ALN 10.561): $81,751 and Unemployment Insurance (ALN 17.225): $8,143. The total amount of funds overdrawn as of year-end totaled $215,562. Cause: Management oversight. Effect: Funds were requested and received in advance of when the related payments were disbursed without obtaining authorization for advance payments, and without properly documenting the basis for the requested funds. Consequently, the Consortium did not minimize the time elapsing between the transfer of funds from the United States Treasury or the pass-through entity and the disbursement by the non-Federal entity. Recommendation: The Consortium should carefully review their policies and procedures and make the necessary changes to assure that cash draws are based on expenditures already incurred and they are supported by transactions recorded in the books and records of the Consortium. Views of Responsible Officials: We agree with the finding. Michigan Works! Southeast will continue to ensure it adheres to the policy standards for cash on hand time limits.
2022-003: Significant Deficiency in Internal Control / Immaterial Noncompliance – Cash Management (repeat comment) Federal Program: WIOA Cluster (ALN 17.258/17.259/17.278) Criteria: 2 CFR 200.305(b) states, in part: “For Non-Federal entities payment methods must minimize the time elapsing between the transfer of funds from the United States Treasury or the pass-through entity and the disbursement by the non-Federal entity…” 2 CFR 200.305(b)(2)(ii) states, in part: “Non-Federal entities must be authorized to submit requests for advance payments and reimbursements….”. 2 CFR 200.302(b)(6) states, in part: “the financial management system of each non-Federal entity must provide for written procedures to implement the requirements of 2 CFR 200.305 – Federal Payment”. Condition: 1) The Consortium requested funds in advance of when the related disbursements were made, 2) the basis for the advances (requests) were not supported by appropriate documentation, and 3) authorization for requesting funds in advance was not obtained. Context: The amount overdrawn for the WIOA Cluster totaled $125,668. It was noted that other programs were also overdrawn as follows: SNAP Cluster (ALN 10.561): $81,751 and Unemployment Insurance (ALN 17.225): $8,143. The total amount of funds overdrawn as of year-end totaled $215,562. Cause: Management oversight. Effect: Funds were requested and received in advance of when the related payments were disbursed without obtaining authorization for advance payments, and without properly documenting the basis for the requested funds. Consequently, the Consortium did not minimize the time elapsing between the transfer of funds from the United States Treasury or the pass-through entity and the disbursement by the non-Federal entity. Recommendation: The Consortium should carefully review their policies and procedures and make the necessary changes to assure that cash draws are based on expenditures already incurred and they are supported by transactions recorded in the books and records of the Consortium. Views of Responsible Officials: We agree with the finding. Michigan Works! Southeast will continue to ensure it adheres to the policy standards for cash on hand time limits.
2022-003: Significant Deficiency in Internal Control / Immaterial Noncompliance – Cash Management (repeat comment) Federal Program: WIOA Cluster (ALN 17.258/17.259/17.278) Criteria: 2 CFR 200.305(b) states, in part: “For Non-Federal entities payment methods must minimize the time elapsing between the transfer of funds from the United States Treasury or the pass-through entity and the disbursement by the non-Federal entity…” 2 CFR 200.305(b)(2)(ii) states, in part: “Non-Federal entities must be authorized to submit requests for advance payments and reimbursements….”. 2 CFR 200.302(b)(6) states, in part: “the financial management system of each non-Federal entity must provide for written procedures to implement the requirements of 2 CFR 200.305 – Federal Payment”. Condition: 1) The Consortium requested funds in advance of when the related disbursements were made, 2) the basis for the advances (requests) were not supported by appropriate documentation, and 3) authorization for requesting funds in advance was not obtained. Context: The amount overdrawn for the WIOA Cluster totaled $125,668. It was noted that other programs were also overdrawn as follows: SNAP Cluster (ALN 10.561): $81,751 and Unemployment Insurance (ALN 17.225): $8,143. The total amount of funds overdrawn as of year-end totaled $215,562. Cause: Management oversight. Effect: Funds were requested and received in advance of when the related payments were disbursed without obtaining authorization for advance payments, and without properly documenting the basis for the requested funds. Consequently, the Consortium did not minimize the time elapsing between the transfer of funds from the United States Treasury or the pass-through entity and the disbursement by the non-Federal entity. Recommendation: The Consortium should carefully review their policies and procedures and make the necessary changes to assure that cash draws are based on expenditures already incurred and they are supported by transactions recorded in the books and records of the Consortium. Views of Responsible Officials: We agree with the finding. Michigan Works! Southeast will continue to ensure it adheres to the policy standards for cash on hand time limits.
2022-003: Significant Deficiency in Internal Control / Immaterial Noncompliance – Cash Management (repeat comment) Federal Program: WIOA Cluster (ALN 17.258/17.259/17.278) Criteria: 2 CFR 200.305(b) states, in part: “For Non-Federal entities payment methods must minimize the time elapsing between the transfer of funds from the United States Treasury or the pass-through entity and the disbursement by the non-Federal entity…” 2 CFR 200.305(b)(2)(ii) states, in part: “Non-Federal entities must be authorized to submit requests for advance payments and reimbursements….”. 2 CFR 200.302(b)(6) states, in part: “the financial management system of each non-Federal entity must provide for written procedures to implement the requirements of 2 CFR 200.305 – Federal Payment”. Condition: 1) The Consortium requested funds in advance of when the related disbursements were made, 2) the basis for the advances (requests) were not supported by appropriate documentation, and 3) authorization for requesting funds in advance was not obtained. Context: The amount overdrawn for the WIOA Cluster totaled $125,668. It was noted that other programs were also overdrawn as follows: SNAP Cluster (ALN 10.561): $81,751 and Unemployment Insurance (ALN 17.225): $8,143. The total amount of funds overdrawn as of year-end totaled $215,562. Cause: Management oversight. Effect: Funds were requested and received in advance of when the related payments were disbursed without obtaining authorization for advance payments, and without properly documenting the basis for the requested funds. Consequently, the Consortium did not minimize the time elapsing between the transfer of funds from the United States Treasury or the pass-through entity and the disbursement by the non-Federal entity. Recommendation: The Consortium should carefully review their policies and procedures and make the necessary changes to assure that cash draws are based on expenditures already incurred and they are supported by transactions recorded in the books and records of the Consortium. Views of Responsible Officials: We agree with the finding. Michigan Works! Southeast will continue to ensure it adheres to the policy standards for cash on hand time limits.
2022-003: Significant Deficiency in Internal Control / Immaterial Noncompliance – Cash Management (repeat comment) Federal Program: WIOA Cluster (ALN 17.258/17.259/17.278) Criteria: 2 CFR 200.305(b) states, in part: “For Non-Federal entities payment methods must minimize the time elapsing between the transfer of funds from the United States Treasury or the pass-through entity and the disbursement by the non-Federal entity…” 2 CFR 200.305(b)(2)(ii) states, in part: “Non-Federal entities must be authorized to submit requests for advance payments and reimbursements….”. 2 CFR 200.302(b)(6) states, in part: “the financial management system of each non-Federal entity must provide for written procedures to implement the requirements of 2 CFR 200.305 – Federal Payment”. Condition: 1) The Consortium requested funds in advance of when the related disbursements were made, 2) the basis for the advances (requests) were not supported by appropriate documentation, and 3) authorization for requesting funds in advance was not obtained. Context: The amount overdrawn for the WIOA Cluster totaled $125,668. It was noted that other programs were also overdrawn as follows: SNAP Cluster (ALN 10.561): $81,751 and Unemployment Insurance (ALN 17.225): $8,143. The total amount of funds overdrawn as of year-end totaled $215,562. Cause: Management oversight. Effect: Funds were requested and received in advance of when the related payments were disbursed without obtaining authorization for advance payments, and without properly documenting the basis for the requested funds. Consequently, the Consortium did not minimize the time elapsing between the transfer of funds from the United States Treasury or the pass-through entity and the disbursement by the non-Federal entity. Recommendation: The Consortium should carefully review their policies and procedures and make the necessary changes to assure that cash draws are based on expenditures already incurred and they are supported by transactions recorded in the books and records of the Consortium. Views of Responsible Officials: We agree with the finding. Michigan Works! Southeast will continue to ensure it adheres to the policy standards for cash on hand time limits.
2022-003: Significant Deficiency in Internal Control / Immaterial Noncompliance – Cash Management (repeat comment) Federal Program: WIOA Cluster (ALN 17.258/17.259/17.278) Criteria: 2 CFR 200.305(b) states, in part: “For Non-Federal entities payment methods must minimize the time elapsing between the transfer of funds from the United States Treasury or the pass-through entity and the disbursement by the non-Federal entity…” 2 CFR 200.305(b)(2)(ii) states, in part: “Non-Federal entities must be authorized to submit requests for advance payments and reimbursements….”. 2 CFR 200.302(b)(6) states, in part: “the financial management system of each non-Federal entity must provide for written procedures to implement the requirements of 2 CFR 200.305 – Federal Payment”. Condition: 1) The Consortium requested funds in advance of when the related disbursements were made, 2) the basis for the advances (requests) were not supported by appropriate documentation, and 3) authorization for requesting funds in advance was not obtained. Context: The amount overdrawn for the WIOA Cluster totaled $125,668. It was noted that other programs were also overdrawn as follows: SNAP Cluster (ALN 10.561): $81,751 and Unemployment Insurance (ALN 17.225): $8,143. The total amount of funds overdrawn as of year-end totaled $215,562. Cause: Management oversight. Effect: Funds were requested and received in advance of when the related payments were disbursed without obtaining authorization for advance payments, and without properly documenting the basis for the requested funds. Consequently, the Consortium did not minimize the time elapsing between the transfer of funds from the United States Treasury or the pass-through entity and the disbursement by the non-Federal entity. Recommendation: The Consortium should carefully review their policies and procedures and make the necessary changes to assure that cash draws are based on expenditures already incurred and they are supported by transactions recorded in the books and records of the Consortium. Views of Responsible Officials: We agree with the finding. Michigan Works! Southeast will continue to ensure it adheres to the policy standards for cash on hand time limits.
2022-003: Significant Deficiency in Internal Control / Immaterial Noncompliance – Cash Management (repeat comment) Federal Program: WIOA Cluster (ALN 17.258/17.259/17.278) Criteria: 2 CFR 200.305(b) states, in part: “For Non-Federal entities payment methods must minimize the time elapsing between the transfer of funds from the United States Treasury or the pass-through entity and the disbursement by the non-Federal entity…” 2 CFR 200.305(b)(2)(ii) states, in part: “Non-Federal entities must be authorized to submit requests for advance payments and reimbursements….”. 2 CFR 200.302(b)(6) states, in part: “the financial management system of each non-Federal entity must provide for written procedures to implement the requirements of 2 CFR 200.305 – Federal Payment”. Condition: 1) The Consortium requested funds in advance of when the related disbursements were made, 2) the basis for the advances (requests) were not supported by appropriate documentation, and 3) authorization for requesting funds in advance was not obtained. Context: The amount overdrawn for the WIOA Cluster totaled $125,668. It was noted that other programs were also overdrawn as follows: SNAP Cluster (ALN 10.561): $81,751 and Unemployment Insurance (ALN 17.225): $8,143. The total amount of funds overdrawn as of year-end totaled $215,562. Cause: Management oversight. Effect: Funds were requested and received in advance of when the related payments were disbursed without obtaining authorization for advance payments, and without properly documenting the basis for the requested funds. Consequently, the Consortium did not minimize the time elapsing between the transfer of funds from the United States Treasury or the pass-through entity and the disbursement by the non-Federal entity. Recommendation: The Consortium should carefully review their policies and procedures and make the necessary changes to assure that cash draws are based on expenditures already incurred and they are supported by transactions recorded in the books and records of the Consortium. Views of Responsible Officials: We agree with the finding. Michigan Works! Southeast will continue to ensure it adheres to the policy standards for cash on hand time limits.
2022-003: Significant Deficiency in Internal Control / Immaterial Noncompliance – Cash Management (repeat comment) Federal Program: WIOA Cluster (ALN 17.258/17.259/17.278) Criteria: 2 CFR 200.305(b) states, in part: “For Non-Federal entities payment methods must minimize the time elapsing between the transfer of funds from the United States Treasury or the pass-through entity and the disbursement by the non-Federal entity…” 2 CFR 200.305(b)(2)(ii) states, in part: “Non-Federal entities must be authorized to submit requests for advance payments and reimbursements….”. 2 CFR 200.302(b)(6) states, in part: “the financial management system of each non-Federal entity must provide for written procedures to implement the requirements of 2 CFR 200.305 – Federal Payment”. Condition: 1) The Consortium requested funds in advance of when the related disbursements were made, 2) the basis for the advances (requests) were not supported by appropriate documentation, and 3) authorization for requesting funds in advance was not obtained. Context: The amount overdrawn for the WIOA Cluster totaled $125,668. It was noted that other programs were also overdrawn as follows: SNAP Cluster (ALN 10.561): $81,751 and Unemployment Insurance (ALN 17.225): $8,143. The total amount of funds overdrawn as of year-end totaled $215,562. Cause: Management oversight. Effect: Funds were requested and received in advance of when the related payments were disbursed without obtaining authorization for advance payments, and without properly documenting the basis for the requested funds. Consequently, the Consortium did not minimize the time elapsing between the transfer of funds from the United States Treasury or the pass-through entity and the disbursement by the non-Federal entity. Recommendation: The Consortium should carefully review their policies and procedures and make the necessary changes to assure that cash draws are based on expenditures already incurred and they are supported by transactions recorded in the books and records of the Consortium. Views of Responsible Officials: We agree with the finding. Michigan Works! Southeast will continue to ensure it adheres to the policy standards for cash on hand time limits.
2022-003: Significant Deficiency in Internal Control / Immaterial Noncompliance – Cash Management (repeat comment) Federal Program: WIOA Cluster (ALN 17.258/17.259/17.278) Criteria: 2 CFR 200.305(b) states, in part: “For Non-Federal entities payment methods must minimize the time elapsing between the transfer of funds from the United States Treasury or the pass-through entity and the disbursement by the non-Federal entity…” 2 CFR 200.305(b)(2)(ii) states, in part: “Non-Federal entities must be authorized to submit requests for advance payments and reimbursements….”. 2 CFR 200.302(b)(6) states, in part: “the financial management system of each non-Federal entity must provide for written procedures to implement the requirements of 2 CFR 200.305 – Federal Payment”. Condition: 1) The Consortium requested funds in advance of when the related disbursements were made, 2) the basis for the advances (requests) were not supported by appropriate documentation, and 3) authorization for requesting funds in advance was not obtained. Context: The amount overdrawn for the WIOA Cluster totaled $125,668. It was noted that other programs were also overdrawn as follows: SNAP Cluster (ALN 10.561): $81,751 and Unemployment Insurance (ALN 17.225): $8,143. The total amount of funds overdrawn as of year-end totaled $215,562. Cause: Management oversight. Effect: Funds were requested and received in advance of when the related payments were disbursed without obtaining authorization for advance payments, and without properly documenting the basis for the requested funds. Consequently, the Consortium did not minimize the time elapsing between the transfer of funds from the United States Treasury or the pass-through entity and the disbursement by the non-Federal entity. Recommendation: The Consortium should carefully review their policies and procedures and make the necessary changes to assure that cash draws are based on expenditures already incurred and they are supported by transactions recorded in the books and records of the Consortium. Views of Responsible Officials: We agree with the finding. Michigan Works! Southeast will continue to ensure it adheres to the policy standards for cash on hand time limits.
2022-003: Significant Deficiency in Internal Control / Immaterial Noncompliance – Cash Management (repeat comment) Federal Program: WIOA Cluster (ALN 17.258/17.259/17.278) Criteria: 2 CFR 200.305(b) states, in part: “For Non-Federal entities payment methods must minimize the time elapsing between the transfer of funds from the United States Treasury or the pass-through entity and the disbursement by the non-Federal entity…” 2 CFR 200.305(b)(2)(ii) states, in part: “Non-Federal entities must be authorized to submit requests for advance payments and reimbursements….”. 2 CFR 200.302(b)(6) states, in part: “the financial management system of each non-Federal entity must provide for written procedures to implement the requirements of 2 CFR 200.305 – Federal Payment”. Condition: 1) The Consortium requested funds in advance of when the related disbursements were made, 2) the basis for the advances (requests) were not supported by appropriate documentation, and 3) authorization for requesting funds in advance was not obtained. Context: The amount overdrawn for the WIOA Cluster totaled $125,668. It was noted that other programs were also overdrawn as follows: SNAP Cluster (ALN 10.561): $81,751 and Unemployment Insurance (ALN 17.225): $8,143. The total amount of funds overdrawn as of year-end totaled $215,562. Cause: Management oversight. Effect: Funds were requested and received in advance of when the related payments were disbursed without obtaining authorization for advance payments, and without properly documenting the basis for the requested funds. Consequently, the Consortium did not minimize the time elapsing between the transfer of funds from the United States Treasury or the pass-through entity and the disbursement by the non-Federal entity. Recommendation: The Consortium should carefully review their policies and procedures and make the necessary changes to assure that cash draws are based on expenditures already incurred and they are supported by transactions recorded in the books and records of the Consortium. Views of Responsible Officials: We agree with the finding. Michigan Works! Southeast will continue to ensure it adheres to the policy standards for cash on hand time limits.
2022-003: Significant Deficiency in Internal Control / Immaterial Noncompliance – Cash Management (repeat comment) Federal Program: WIOA Cluster (ALN 17.258/17.259/17.278) Criteria: 2 CFR 200.305(b) states, in part: “For Non-Federal entities payment methods must minimize the time elapsing between the transfer of funds from the United States Treasury or the pass-through entity and the disbursement by the non-Federal entity…” 2 CFR 200.305(b)(2)(ii) states, in part: “Non-Federal entities must be authorized to submit requests for advance payments and reimbursements….”. 2 CFR 200.302(b)(6) states, in part: “the financial management system of each non-Federal entity must provide for written procedures to implement the requirements of 2 CFR 200.305 – Federal Payment”. Condition: 1) The Consortium requested funds in advance of when the related disbursements were made, 2) the basis for the advances (requests) were not supported by appropriate documentation, and 3) authorization for requesting funds in advance was not obtained. Context: The amount overdrawn for the WIOA Cluster totaled $125,668. It was noted that other programs were also overdrawn as follows: SNAP Cluster (ALN 10.561): $81,751 and Unemployment Insurance (ALN 17.225): $8,143. The total amount of funds overdrawn as of year-end totaled $215,562. Cause: Management oversight. Effect: Funds were requested and received in advance of when the related payments were disbursed without obtaining authorization for advance payments, and without properly documenting the basis for the requested funds. Consequently, the Consortium did not minimize the time elapsing between the transfer of funds from the United States Treasury or the pass-through entity and the disbursement by the non-Federal entity. Recommendation: The Consortium should carefully review their policies and procedures and make the necessary changes to assure that cash draws are based on expenditures already incurred and they are supported by transactions recorded in the books and records of the Consortium. Views of Responsible Officials: We agree with the finding. Michigan Works! Southeast will continue to ensure it adheres to the policy standards for cash on hand time limits.
2022-003: Significant Deficiency in Internal Control / Immaterial Noncompliance – Cash Management (repeat comment) Federal Program: WIOA Cluster (ALN 17.258/17.259/17.278) Criteria: 2 CFR 200.305(b) states, in part: “For Non-Federal entities payment methods must minimize the time elapsing between the transfer of funds from the United States Treasury or the pass-through entity and the disbursement by the non-Federal entity…” 2 CFR 200.305(b)(2)(ii) states, in part: “Non-Federal entities must be authorized to submit requests for advance payments and reimbursements….”. 2 CFR 200.302(b)(6) states, in part: “the financial management system of each non-Federal entity must provide for written procedures to implement the requirements of 2 CFR 200.305 – Federal Payment”. Condition: 1) The Consortium requested funds in advance of when the related disbursements were made, 2) the basis for the advances (requests) were not supported by appropriate documentation, and 3) authorization for requesting funds in advance was not obtained. Context: The amount overdrawn for the WIOA Cluster totaled $125,668. It was noted that other programs were also overdrawn as follows: SNAP Cluster (ALN 10.561): $81,751 and Unemployment Insurance (ALN 17.225): $8,143. The total amount of funds overdrawn as of year-end totaled $215,562. Cause: Management oversight. Effect: Funds were requested and received in advance of when the related payments were disbursed without obtaining authorization for advance payments, and without properly documenting the basis for the requested funds. Consequently, the Consortium did not minimize the time elapsing between the transfer of funds from the United States Treasury or the pass-through entity and the disbursement by the non-Federal entity. Recommendation: The Consortium should carefully review their policies and procedures and make the necessary changes to assure that cash draws are based on expenditures already incurred and they are supported by transactions recorded in the books and records of the Consortium. Views of Responsible Officials: We agree with the finding. Michigan Works! Southeast will continue to ensure it adheres to the policy standards for cash on hand time limits.
2022-003: Significant Deficiency in Internal Control / Immaterial Noncompliance – Cash Management (repeat comment) Federal Program: WIOA Cluster (ALN 17.258/17.259/17.278) Criteria: 2 CFR 200.305(b) states, in part: “For Non-Federal entities payment methods must minimize the time elapsing between the transfer of funds from the United States Treasury or the pass-through entity and the disbursement by the non-Federal entity…” 2 CFR 200.305(b)(2)(ii) states, in part: “Non-Federal entities must be authorized to submit requests for advance payments and reimbursements….”. 2 CFR 200.302(b)(6) states, in part: “the financial management system of each non-Federal entity must provide for written procedures to implement the requirements of 2 CFR 200.305 – Federal Payment”. Condition: 1) The Consortium requested funds in advance of when the related disbursements were made, 2) the basis for the advances (requests) were not supported by appropriate documentation, and 3) authorization for requesting funds in advance was not obtained. Context: The amount overdrawn for the WIOA Cluster totaled $125,668. It was noted that other programs were also overdrawn as follows: SNAP Cluster (ALN 10.561): $81,751 and Unemployment Insurance (ALN 17.225): $8,143. The total amount of funds overdrawn as of year-end totaled $215,562. Cause: Management oversight. Effect: Funds were requested and received in advance of when the related payments were disbursed without obtaining authorization for advance payments, and without properly documenting the basis for the requested funds. Consequently, the Consortium did not minimize the time elapsing between the transfer of funds from the United States Treasury or the pass-through entity and the disbursement by the non-Federal entity. Recommendation: The Consortium should carefully review their policies and procedures and make the necessary changes to assure that cash draws are based on expenditures already incurred and they are supported by transactions recorded in the books and records of the Consortium. Views of Responsible Officials: We agree with the finding. Michigan Works! Southeast will continue to ensure it adheres to the policy standards for cash on hand time limits.
2022-003: Significant Deficiency in Internal Control / Immaterial Noncompliance – Cash Management (repeat comment) Federal Program: WIOA Cluster (ALN 17.258/17.259/17.278) Criteria: 2 CFR 200.305(b) states, in part: “For Non-Federal entities payment methods must minimize the time elapsing between the transfer of funds from the United States Treasury or the pass-through entity and the disbursement by the non-Federal entity…” 2 CFR 200.305(b)(2)(ii) states, in part: “Non-Federal entities must be authorized to submit requests for advance payments and reimbursements….”. 2 CFR 200.302(b)(6) states, in part: “the financial management system of each non-Federal entity must provide for written procedures to implement the requirements of 2 CFR 200.305 – Federal Payment”. Condition: 1) The Consortium requested funds in advance of when the related disbursements were made, 2) the basis for the advances (requests) were not supported by appropriate documentation, and 3) authorization for requesting funds in advance was not obtained. Context: The amount overdrawn for the WIOA Cluster totaled $125,668. It was noted that other programs were also overdrawn as follows: SNAP Cluster (ALN 10.561): $81,751 and Unemployment Insurance (ALN 17.225): $8,143. The total amount of funds overdrawn as of year-end totaled $215,562. Cause: Management oversight. Effect: Funds were requested and received in advance of when the related payments were disbursed without obtaining authorization for advance payments, and without properly documenting the basis for the requested funds. Consequently, the Consortium did not minimize the time elapsing between the transfer of funds from the United States Treasury or the pass-through entity and the disbursement by the non-Federal entity. Recommendation: The Consortium should carefully review their policies and procedures and make the necessary changes to assure that cash draws are based on expenditures already incurred and they are supported by transactions recorded in the books and records of the Consortium. Views of Responsible Officials: We agree with the finding. Michigan Works! Southeast will continue to ensure it adheres to the policy standards for cash on hand time limits.
2022-003: Significant Deficiency in Internal Control / Immaterial Noncompliance – Cash Management (repeat comment) Federal Program: WIOA Cluster (ALN 17.258/17.259/17.278) Criteria: 2 CFR 200.305(b) states, in part: “For Non-Federal entities payment methods must minimize the time elapsing between the transfer of funds from the United States Treasury or the pass-through entity and the disbursement by the non-Federal entity…” 2 CFR 200.305(b)(2)(ii) states, in part: “Non-Federal entities must be authorized to submit requests for advance payments and reimbursements….”. 2 CFR 200.302(b)(6) states, in part: “the financial management system of each non-Federal entity must provide for written procedures to implement the requirements of 2 CFR 200.305 – Federal Payment”. Condition: 1) The Consortium requested funds in advance of when the related disbursements were made, 2) the basis for the advances (requests) were not supported by appropriate documentation, and 3) authorization for requesting funds in advance was not obtained. Context: The amount overdrawn for the WIOA Cluster totaled $125,668. It was noted that other programs were also overdrawn as follows: SNAP Cluster (ALN 10.561): $81,751 and Unemployment Insurance (ALN 17.225): $8,143. The total amount of funds overdrawn as of year-end totaled $215,562. Cause: Management oversight. Effect: Funds were requested and received in advance of when the related payments were disbursed without obtaining authorization for advance payments, and without properly documenting the basis for the requested funds. Consequently, the Consortium did not minimize the time elapsing between the transfer of funds from the United States Treasury or the pass-through entity and the disbursement by the non-Federal entity. Recommendation: The Consortium should carefully review their policies and procedures and make the necessary changes to assure that cash draws are based on expenditures already incurred and they are supported by transactions recorded in the books and records of the Consortium. Views of Responsible Officials: We agree with the finding. Michigan Works! Southeast will continue to ensure it adheres to the policy standards for cash on hand time limits.
2022-003: Significant Deficiency in Internal Control / Immaterial Noncompliance – Cash Management (repeat comment) Federal Program: WIOA Cluster (ALN 17.258/17.259/17.278) Criteria: 2 CFR 200.305(b) states, in part: “For Non-Federal entities payment methods must minimize the time elapsing between the transfer of funds from the United States Treasury or the pass-through entity and the disbursement by the non-Federal entity…” 2 CFR 200.305(b)(2)(ii) states, in part: “Non-Federal entities must be authorized to submit requests for advance payments and reimbursements….”. 2 CFR 200.302(b)(6) states, in part: “the financial management system of each non-Federal entity must provide for written procedures to implement the requirements of 2 CFR 200.305 – Federal Payment”. Condition: 1) The Consortium requested funds in advance of when the related disbursements were made, 2) the basis for the advances (requests) were not supported by appropriate documentation, and 3) authorization for requesting funds in advance was not obtained. Context: The amount overdrawn for the WIOA Cluster totaled $125,668. It was noted that other programs were also overdrawn as follows: SNAP Cluster (ALN 10.561): $81,751 and Unemployment Insurance (ALN 17.225): $8,143. The total amount of funds overdrawn as of year-end totaled $215,562. Cause: Management oversight. Effect: Funds were requested and received in advance of when the related payments were disbursed without obtaining authorization for advance payments, and without properly documenting the basis for the requested funds. Consequently, the Consortium did not minimize the time elapsing between the transfer of funds from the United States Treasury or the pass-through entity and the disbursement by the non-Federal entity. Recommendation: The Consortium should carefully review their policies and procedures and make the necessary changes to assure that cash draws are based on expenditures already incurred and they are supported by transactions recorded in the books and records of the Consortium. Views of Responsible Officials: We agree with the finding. Michigan Works! Southeast will continue to ensure it adheres to the policy standards for cash on hand time limits.
2022-003: Significant Deficiency in Internal Control / Immaterial Noncompliance – Cash Management (repeat comment) Federal Program: WIOA Cluster (ALN 17.258/17.259/17.278) Criteria: 2 CFR 200.305(b) states, in part: “For Non-Federal entities payment methods must minimize the time elapsing between the transfer of funds from the United States Treasury or the pass-through entity and the disbursement by the non-Federal entity…” 2 CFR 200.305(b)(2)(ii) states, in part: “Non-Federal entities must be authorized to submit requests for advance payments and reimbursements….”. 2 CFR 200.302(b)(6) states, in part: “the financial management system of each non-Federal entity must provide for written procedures to implement the requirements of 2 CFR 200.305 – Federal Payment”. Condition: 1) The Consortium requested funds in advance of when the related disbursements were made, 2) the basis for the advances (requests) were not supported by appropriate documentation, and 3) authorization for requesting funds in advance was not obtained. Context: The amount overdrawn for the WIOA Cluster totaled $125,668. It was noted that other programs were also overdrawn as follows: SNAP Cluster (ALN 10.561): $81,751 and Unemployment Insurance (ALN 17.225): $8,143. The total amount of funds overdrawn as of year-end totaled $215,562. Cause: Management oversight. Effect: Funds were requested and received in advance of when the related payments were disbursed without obtaining authorization for advance payments, and without properly documenting the basis for the requested funds. Consequently, the Consortium did not minimize the time elapsing between the transfer of funds from the United States Treasury or the pass-through entity and the disbursement by the non-Federal entity. Recommendation: The Consortium should carefully review their policies and procedures and make the necessary changes to assure that cash draws are based on expenditures already incurred and they are supported by transactions recorded in the books and records of the Consortium. Views of Responsible Officials: We agree with the finding. Michigan Works! Southeast will continue to ensure it adheres to the policy standards for cash on hand time limits.
2022-003: Significant Deficiency in Internal Control / Immaterial Noncompliance – Cash Management (repeat comment) Federal Program: WIOA Cluster (ALN 17.258/17.259/17.278) Criteria: 2 CFR 200.305(b) states, in part: “For Non-Federal entities payment methods must minimize the time elapsing between the transfer of funds from the United States Treasury or the pass-through entity and the disbursement by the non-Federal entity…” 2 CFR 200.305(b)(2)(ii) states, in part: “Non-Federal entities must be authorized to submit requests for advance payments and reimbursements….”. 2 CFR 200.302(b)(6) states, in part: “the financial management system of each non-Federal entity must provide for written procedures to implement the requirements of 2 CFR 200.305 – Federal Payment”. Condition: 1) The Consortium requested funds in advance of when the related disbursements were made, 2) the basis for the advances (requests) were not supported by appropriate documentation, and 3) authorization for requesting funds in advance was not obtained. Context: The amount overdrawn for the WIOA Cluster totaled $125,668. It was noted that other programs were also overdrawn as follows: SNAP Cluster (ALN 10.561): $81,751 and Unemployment Insurance (ALN 17.225): $8,143. The total amount of funds overdrawn as of year-end totaled $215,562. Cause: Management oversight. Effect: Funds were requested and received in advance of when the related payments were disbursed without obtaining authorization for advance payments, and without properly documenting the basis for the requested funds. Consequently, the Consortium did not minimize the time elapsing between the transfer of funds from the United States Treasury or the pass-through entity and the disbursement by the non-Federal entity. Recommendation: The Consortium should carefully review their policies and procedures and make the necessary changes to assure that cash draws are based on expenditures already incurred and they are supported by transactions recorded in the books and records of the Consortium. Views of Responsible Officials: We agree with the finding. Michigan Works! Southeast will continue to ensure it adheres to the policy standards for cash on hand time limits.