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.
Assistance Listing, Federal Agency, and Program Name - Assistance Listing 66.443, Environmental Protection Agency, Reducing Lead in Drinking Water Federal Award Identification Number and Year - OOE02968, 2021 Pass-through Entity - n/a Finding Type - Material weakness Repeat Finding - No Criteria - 2 CFR 200.508 requires the City to prepare appropriate financial statements, including the schedule of expenditures of federal awards (SEFA) in accordance with 2 CFR 200.510. The SEFA must list individual federal programs as required by 2 CFR 200.501(b)(1). The SEFA is the basis for the auditor determination of major programs as required by 2 CFR 200.518. Condition - The original SEFA prepared for audit purposes did not include all federal expenditures that should have been reported under ALN 66.443. Questioned Costs - None Identification of How Questioned Costs Were Computed - n/a Context - Approximately $864,000 of federal expenditures were not included in the original SEFA prepared for audit purposes under ALN 66.443. Cause and Effect - The City's controls over reconciling the SEFA to federal revenue did not detect the missing expenditures because federal revenue was not appropriately accrued by $864,000. As a result, ALN 66.443 was not originally identified as a major program. Recommendation - The City should review its controls over preparation of the SEFA and reconciling the SEFA to federal expenditures per the general ledger to ensure the appropriate amount of federal expenditures are reported on the SEFA. Views of Responsible Officials and Corrective Action Plan - We agree with the auditor’s recommendation. Changes have been implemented to ensure all programs with both federal and state/local funding will be examined to ensure correct expenditure by funding source is properly recorded.
Finding 2022-002 – Internal Control Deficiency and Noncompliance over Reporting Identification of the Federal Program: Federal Grantor: United States Department of the Treasury Pass-Through Entity: Smith County, Texas and the City of San Marcos, Texas Assistance Listing No.:21.027, Coronavirus State and Local Fiscal Recovery Funds Pass-Through Award Numbers: Not available Award Periods of Performance: Trinity Mother Frances, Pass-through Smith County, October 1, 2021 – November 30, 2021 Santa Rosa, Pass-through the City of San Marcos, March 03, 2021 through December 31, 2026 Criteria or Specific Requirement (Including Statutory, Regulatory or Other Citation): The Uniform Guidance 2 CFR section 200.303 states, “The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).” The Uniform Guidance 2 CFR section 200.510 states, “(b) Schedule of expenditures of Federal awards. 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 §200.502 Basis for determining Federal awards expended.” Condition: CHRISTUS did not originally prepare a complete and accurate listing of all federal awards in the SEFA. Cause: CHRISTUS did not have controls in place to ensure all federal expenditures were captured on the SEFA. Effect or Potential Effect: The SEFA prepared by CHRISTUS was misstated but was subsequently corrected. The misstatement resulted in the omission of a major federal program under the Uniform Guidance report. Questioned Costs: None. Context: Expenditures for Assistance Listing Number 21.027 were originally understated on the SEFA by $2,500,000, or 71% of the program. Identification as a Repeat Finding, if Applicable: This is not a repeat finding. Recommendation: CHRISTUS should review its internal controls over the process of accumulating and reporting expenditures of federal awards. Views of Responsible Officials: CHRISTUS agrees with the finding and has developed internal controls to ensure accurate and complete reporting of federal expenditures.
Finding 2022-002 – Internal Control Deficiency and Noncompliance over Reporting Identification of the Federal Program: Federal Grantor: United States Department of the Treasury Pass-Through Entity: Smith County, Texas and the City of San Marcos, Texas Assistance Listing No.:21.027, Coronavirus State and Local Fiscal Recovery Funds Pass-Through Award Numbers: Not available Award Periods of Performance: Trinity Mother Frances, Pass-through Smith County, October 1, 2021 – November 30, 2021 Santa Rosa, Pass-through the City of San Marcos, March 03, 2021 through December 31, 2026 Criteria or Specific Requirement (Including Statutory, Regulatory or Other Citation): The Uniform Guidance 2 CFR section 200.303 states, “The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).” The Uniform Guidance 2 CFR section 200.510 states, “(b) Schedule of expenditures of Federal awards. 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 §200.502 Basis for determining Federal awards expended.” Condition: CHRISTUS did not originally prepare a complete and accurate listing of all federal awards in the SEFA. Cause: CHRISTUS did not have controls in place to ensure all federal expenditures were captured on the SEFA. Effect or Potential Effect: The SEFA prepared by CHRISTUS was misstated but was subsequently corrected. The misstatement resulted in the omission of a major federal program under the Uniform Guidance report. Questioned Costs: None. Context: Expenditures for Assistance Listing Number 21.027 were originally understated on the SEFA by $2,500,000, or 71% of the program. Identification as a Repeat Finding, if Applicable: This is not a repeat finding. Recommendation: CHRISTUS should review its internal controls over the process of accumulating and reporting expenditures of federal awards. Views of Responsible Officials: CHRISTUS agrees with the finding and has developed internal controls to ensure accurate and complete reporting of federal expenditures.
Finding 2022-002 – Internal Control Deficiency and Noncompliance over Reporting Identification of the Federal Program: Federal Grantor: United States Department of the Treasury Pass-Through Entity: Smith County, Texas and the City of San Marcos, Texas Assistance Listing No.:21.027, Coronavirus State and Local Fiscal Recovery Funds Pass-Through Award Numbers: Not available Award Periods of Performance: Trinity Mother Frances, Pass-through Smith County, October 1, 2021 – November 30, 2021 Santa Rosa, Pass-through the City of San Marcos, March 03, 2021 through December 31, 2026 Criteria or Specific Requirement (Including Statutory, Regulatory or Other Citation): The Uniform Guidance 2 CFR section 200.303 states, “The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).” The Uniform Guidance 2 CFR section 200.510 states, “(b) Schedule of expenditures of Federal awards. 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 §200.502 Basis for determining Federal awards expended.” Condition: CHRISTUS did not originally prepare a complete and accurate listing of all federal awards in the SEFA. Cause: CHRISTUS did not have controls in place to ensure all federal expenditures were captured on the SEFA. Effect or Potential Effect: The SEFA prepared by CHRISTUS was misstated but was subsequently corrected. The misstatement resulted in the omission of a major federal program under the Uniform Guidance report. Questioned Costs: None. Context: Expenditures for Assistance Listing Number 21.027 were originally understated on the SEFA by $2,500,000, or 71% of the program. Identification as a Repeat Finding, if Applicable: This is not a repeat finding. Recommendation: CHRISTUS should review its internal controls over the process of accumulating and reporting expenditures of federal awards. Views of Responsible Officials: CHRISTUS agrees with the finding and has developed internal controls to ensure accurate and complete reporting of federal expenditures.
Noncompliance/Material Weakness – Schedule of Expenditures of Federal Awards 2 CFR §200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $4,752,800. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the District and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Noncompliance/Material Weakness – Schedule of Expenditures of Federal Awards 2 CFR §200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $4,752,800. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the District and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Noncompliance/Material Weakness – Schedule of Expenditures of Federal Awards 2 CFR §200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $4,752,800. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the District and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Noncompliance/Material Weakness – Schedule of Expenditures of Federal Awards 2 CFR §200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $4,752,800. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the District and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Noncompliance/Material Weakness – Schedule of Expenditures of Federal Awards 2 CFR §200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $4,752,800. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the District and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Noncompliance/Material Weakness – Schedule of Expenditures of Federal Awards 2 CFR §200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $4,752,800. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the District and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Noncompliance/Material Weakness – Schedule of Expenditures of Federal Awards 2 CFR §200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $4,752,800. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the District and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Noncompliance/Material Weakness – Schedule of Expenditures of Federal Awards 2 CFR §200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $4,752,800. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the District and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Noncompliance/Material Weakness – Schedule of Expenditures of Federal Awards 2 CFR §200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $4,752,800. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the District and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Noncompliance/Material Weakness – Schedule of Expenditures of Federal Awards 2 CFR §200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $4,752,800. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the District and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Noncompliance/Material Weakness – Schedule of Expenditures of Federal Awards 2 CFR §200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $4,752,800. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the District and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Noncompliance/Material Weakness – Schedule of Expenditures of Federal Awards 2 CFR §200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $4,752,800. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the District and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Noncompliance/Material Weakness – Schedule of Expenditures of Federal Awards 2 CFR §200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $4,752,800. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the District and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Noncompliance/Material Weakness – Schedule of Expenditures of Federal Awards 2 CFR §200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $4,752,800. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the District and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Noncompliance/Material Weakness – Schedule of Expenditures of Federal Awards 2 CFR §200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $4,752,800. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the District and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Noncompliance/Material Weakness – Schedule of Expenditures of Federal Awards 2 CFR §200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $4,752,800. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the District and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Noncompliance/Material Weakness – Schedule of Expenditures of Federal Awards 2 CFR §200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $4,752,800. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the District and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Noncompliance/Material Weakness – Schedule of Expenditures of Federal Awards 2 CFR §200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $4,752,800. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the District and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Noncompliance/Material Weakness – Schedule of Expenditures of Federal Awards 2 CFR §200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $4,752,800. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the District and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Noncompliance/Material Weakness – Schedule of Expenditures of Federal Awards 2 CFR §200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $4,752,800. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the District and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Noncompliance/Material Weakness – Schedule of Expenditures of Federal Awards 2 CFR §200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $4,752,800. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the District and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Noncompliance/Material Weakness – Schedule of Expenditures of Federal Awards 2 CFR §200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $4,752,800. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the District and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Noncompliance/Material Weakness – Schedule of Expenditures of Federal Awards 2 CFR §200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $4,752,800. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the District and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Noncompliance/Material Weakness – Schedule of Expenditures of Federal Awards 2 CFR §200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $4,752,800. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the District and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Noncompliance/Material Weakness – Schedule of Expenditures of Federal Awards 2 CFR §200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $4,752,800. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the District and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Noncompliance/Material Weakness – Schedule of Expenditures of Federal Awards 2 CFR §200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $4,752,800. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the District and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Noncompliance/Material Weakness – Schedule of Expenditures of Federal Awards 2 CFR §200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $4,752,800. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the District and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Noncompliance/Material Weakness – Schedule of Expenditures of Federal Awards 2 CFR §200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $4,752,800. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the District and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Program - Various, including AL 10.923 – Emergency Watershed Protection Program – Reporting Grant Number & Year - Various, including NR216526XXXXC004, December 7, 2020, through August 6, 2021 Federal Grantor Agency - Various, including U.S. Department of Agriculture Pass-Through Entity - Various Criteria - Title 2 of the U.S. Code of Federal Regulations (CFR) § 200.510(b) (January 1, 2022) states, in part, the following: The auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with § 200.502. 2 CFR § 200.512(a)(1) (January 1, 2022) states the following: The audit must be completed and the data collection form described in paragraph (b) ofthis section and reporting package described in paragraph (c) of this section must besubmitted within the earlier of 30 calendar days after receipt of the auditor’s report(s),or nine months after the end of the audit period. If the due date falls on a Saturday,Sunday, or Federal holiday, the reporting package is due the next business day. 2 CFR § 200.508 (January 1, 2022) states, in part, the following: The auditee must: (a) Procure or otherwise arrange for the audit required by this part in accordance with §200.509, and ensure it is properly performed and submitted when due in accordance with §200.512. 2 CFR § 200.303 (January 1, 2022) states the following, in relevant 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). A good internal control plan requires adequate procedures to ensure the Schedule of Expenditures Federal Awards (SEFA) is presented properly and includes all Federal expenditures made by the County during the fiscal year. Additionally, those same procedures should ensure the Federal audit is completed and submitted to the Federal Audit Clearinghouse within the time frame required by Title 2 CFR § 200.512. Condition - The County did not have adequate procedures in place to monitor Federal expenditures and ensure the Schedule of Expenditures of Federal Awards (SEFA) was completed and submitted to the Federal Audit Clearinghouse in accordance with Title 2 CFR § 200.512. Repeat Finding - No Questioned Costs - None Statistical Sample - No Context - The County had a basic financial statement audit completed for the fiscal year ending June 30, 2022, which was issued on January 4, 2023, but that audit did not include the additional information necessary to meet Uniform Guidance and Single Audit Act requirements. When the audit for the fiscal year ending June 30, 2023, was completed, the Auditor of Public Accounts identified that the County should have had a Single Audit completed for the fiscal year ending June 30, 2022. Cause - Administration of Federal awards is decentralized, with each County office operating independently without any centralized reporting procedures in place to ensure all Federal expenditures of the County are reported accurately during the annual financial statement audit. Additionally, there is an overall lack of knowledge by County personnel related to Federal reporting requirements. Effect - Noncompliance with Federal regulations and an increased risk for the SEFA to be inaccurate, which could lead to Federal sanctions and Single Audits not being completed when required. Recommendation - We recommend the County establish written procedures to ensure the SEFA is complete and accurate. Such procedures may include, among other things, a requirement that all offices in the County responsible for administering Federal grants report their grant expenditures, as well as related information, to a single individual in the County with overall responsibility for Federal reporting requirements. That individual should be knowledgeable of all Federal reporting and compliance requirements, and review expenditures provided by each office to ensure all amounts are accurate and include all Federal expenditures of the County. Further, we recommend the County obtain necessary training related to Federal reporting requirements and ensure a Single Audit is completed and submitted to the Federal Audit Clearinghouse within the time frame required by Title 2 CFR § 200.512. View of Officials - The County will ensure County personnel obtain training to ensure there is a proper understanding of the Federal reporting requirements and preparation of the Schedule of Federal Awards.