FINDING 2022-002 Subject: Special Education Cluster (IDEA) - Procurement and Suspension and Debarment Federal Agency: Department of Education Federal Program: Special Education Grants to States Assistance Listings Number: 84.027 Federal Award Numbers and Years (or Other Identifying Numbers): 21611-034-PN01, 22611-034-PN01 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Procurement and Suspension and Debarment Audit Findings: Material Weakness, Modified Opinion Repeat Finding This is a repeat finding from the immediately prior audit report. The prior audit finding number was 2021-003. Condition and Context The School Corporation had not designed or implemented adequate policies or procedures to ensure that proper procurement procedures for small purchases and simplified acquisitions were followed. There was no documented oversight, review, or approval process in place at the School Corporation to ensure proper procedures were followed and price or rate quotations were obtained, or documentation to support limited procurement procedures were conducted and maintained. Federal regulations allow for informal procurement methods when the value of the procurement for property or services does not exceed the simplified acquisition threshold, which is set at $250,000 unless a lower, more restrictive threshold is set by a non-federal entity. As Indiana Code has set a more restrictive threshold of $150,000, informal procurement methods are permitted when the value of the procurement does not exceed $150,000. This informal process allows for methods other than the formal bid process. The informal process is divided between two methods based on thresholds. Micro-purchases, typically for those purchases $10,000 or under, and small purchase procedures for those purchases above the micropurchase threshold, but below the simplified acquisition threshold. Micro-purchases may be awarded without soliciting competitive price rate quotations. If small purchase procedures are used, then price or rate quotations must be obtained from an adequate number of qualified sources. INDIANA STATE BOARD OF ACCOUNTS 22 METROPOLITAN SCHOOL DISTRICT OF LAWRENCE TOWNSHIP SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) The School Corporation did not obtain price or rate quotes for the five vendors tested that were less than the simplified acquisition threshold of $150,000 but exceeded the $10,000 micro-purchase threshold. Documentation detailing the history of procurement, which must include the reason for the procurement method used, was not available for audit. The School Corporation also did not follow procurement requirements for contracted services which exceeded the simplified acquisition threshold of $150,000. The School Corporation did not correctly procure a contract for the one vendor that exceeded the simplified acquisition threshold. Additionally, the School Corporation did not adequately maintain documentation detailing the history of the procurement or the rationale to limit competition. Finally, the School Corporation did not verify that this vendor was not excluded or disqualified from participation in federal assistance programs or activities. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.318 states in part: "(a) The non-Federal entity must have and use documented procurement procedures, consistent with State, local, and tribal laws and regulations and the standards of this section, for the acquisition of property or services required under a Federal award or subaward. The non-Federal entity's documented procurement procedures must conform to the procurement standards identified in §§ 200.317 through 200.327. . . . (i) The non-Federal entity must maintain records sufficient to detail the history of procurement. These records will include, but are not necessarily limited to, the following: Rationale for the method of procurement, selection of contract type, contractor selection or rejection, and the basis for the contract price. . . ." 2 CFR 200.320 states in part: "The non-Federal entity must have and use documented procurement procedures, consistent with the standards of this section and §§ 200.317, 200.318, and 200.319 for any of the following methods of procurement used for the acquisition of property or services required under a Federal award or sub-award. INDIANA STATE BOARD OF ACCOUNTS 23 METROPOLITAN SCHOOL DISTRICT OF LAWRENCE TOWNSHIP SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (a) Informal procurement methods. When the value of the procurement for property or services under a Federal award does not exceed the simplified acquisition threshold (SAT), as defined in § 200.1, or a lower threshold established by a non-Federal entity, formal procurement methods are not required. The non-Federal entity may use informal procurement methods to expedite the completion of its transactions and minimize the associated administrative burden and cost. The informal methods used for procurement of property or services at or below the SAT include: . . . (2) Small purchases — (i) Small purchase procedures. The acquisition of property or services, the aggregate dollar amount of which is higher than the micro-purchase threshold but does not exceed the simplified acquisition threshold. If small purchase procedures are used, price or rate quotations must be obtained from an adequate number of qualified sources as determined appropriate by the non-Federal entity. (ii) Simplified acquisition thresholds. The non-Federal entity is responsible for determining an appropriate simplified acquisition threshold based on internal controls, an evaluation of risk and its documented procurement procedures which must not exceed the threshold established in the FAR. When applicable, a lower simplified acquisition threshold used by the non-Federal entity must be authorized or not prohibited under State, local, or tribal laws or regulations. (b) Formal procurement methods. When the value of the procurement for property or services under a Federal financial assistance award exceeds the SAT, or a lower threshold established by a non-Federal entity, formal procurement methods are required. Formal procurement methods require following documented procedures. Formal procurement methods also require public advertising unless a non-competitive procurement can be used in accordance with § 200.319 or paragraph (c) of this section. The following formal methods of procurement are used for procurement of property or services above the simplified acquisition threshold or a value below the simplified acquisition threshold the non-Federal entity determines to be appropriate: (1) Sealed bids. A procurement method in which bids are publicly solicited and a firm fixed-price contract (lump sum or unit price) is awarded to the responsible bidder whose bid, conforming with all the material terms and conditions of the invitation for bids, is the lowest in price. The sealed bids method is the preferred method for procuring construction, if the conditions. (i) In order for sealed bidding to be feasible, the following conditions should be present: (A) A complete, adequate, and realistic specification or purchase description is available; (B) Two or more responsible bidders are willing and able to compete effectively for the business; and (C) The procurement lends itself to a firm fixed price contract and the selection of the successful bidder can be made principally on the basis of price. (ii) If sealed bids are used, the following requirements apply: INDIANA STATE BOARD OF ACCOUNTS 24 METROPOLITAN SCHOOL DISTRICT OF LAWRENCE TOWNSHIP SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (A) Bids must be solicited from an adequate number of qualified sources, providing them sufficient response time prior to the date set for opening the bids, for local, and tribal governments, the invitation for bids must be publicly advertised; (B) The invitation for bids, which will include any specifications and pertinent attachments, must define the items or services in order for the bidder to properly respond; (C) All bids will be opened at the time and place prescribed in the invitation for bids, and for local and tribal governments, the bids must be opened publicly; (D) A firm fixed price contract award will be made in writing to the lowest responsive and responsible bidder. Where specified in bidding documents, factors such as discounts, transportation cost, and life cycle costs must be considered in determining which bid is lowest. Payment discounts will only be used to determine the low bid when prior experience indicates that such discounts are usually taken advantage of; and. . . ." 2 CFR 180.300 states: "When you enter into a covered transaction with another person at the next lower tier, you must verify that the person with whom you intend to do business is not excluded or disqualified. You do this by: (a) Checking SAM Exclusions; or (b) Collecting a certification from that person; or (c) Adding a clause or condition to the covered transaction with that person." Cause A proper system of internal controls was not designed by management of the School Corporation, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, procurement procedures for goods and services were not adhered to and vendors to whom payments equal to or in excess of $25,000 were not verified to be not suspended, debarred, or otherwise excluded. Noncompliance with the grant agreement and the compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. INDIANA STATE BOARD OF ACCOUNTS 25 METROPOLITAN SCHOOL DISTRICT OF LAWRENCE TOWNSHIP SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure there are appropriate procurement procedures for goods and services and contractors and subrecipients, as appropriate, are not suspended, debarred, or otherwise excluded prior to entering into any contracts or subawards. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
Finding Number 2022-008 Prior Year Finding Number N/A Compliance Requirement: Allowable Costs/Costs Principles Program: U.S. Department of Education Title I Grants to Local Educational Agencies ALN #: 84.010 Award #: Various Award Period: Various COVID-19 – Governor’s Emergency Education Relief (GEER) ALN #: 84.425C Award #: Various Award Period: Various COVID-19 – Elementary and Secondary School Emergency Relief (ESSR) Fund ALN #: 84.425D Award #: Various Award Period: Various COVID-19 – American Rescue Plan - Elementary and Secondary School Emergency Relief (ARP ESSR) ALN #: 84.425U Award #: 211941 Award Period: 03/24/2021 – 09/30/2023 COVID-19 – American Rescue Plan - Elementary and Secondary School Emergency Relief – Homeless Children and Youth ALN #: 84.425W Award #: Various Award Period: Various Criteria – In accordance with §200.302 Financial Management, a non-federal entity's financial management systems, including records documenting compliance with federal statutes, regulations, and the terms and conditions of the federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the federal statutes, regulations, and the terms and conditions of the federal award. The financial management system of each non-federal entity must provide for the following: 1. Identification, in its accounts, of all federal awards received and expended and the federal programs under which they were received. 2. Accurate, current, and complete disclosure of the financial results of each federal award or program in accordance with the reporting requirements set forth in §200.327 Financial Reporting and §200.328 Monitoring and Reporting Program Performance. 3. Records that identify adequately the source and application of funds for federally funded activities. 4. Effective control over, and accountability for, all funds, property, and other assets. The Uniform Guidance in 2 CFR Section 200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Further, CFR Section 200.510 (b) requires the auditee must also prepare a Schedule of Expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR section 200.502, Basis for determining Federal awards expended. Condition – The amounts recorded in the Schedule of Expenditures of Federal Awards (SEFA) agree to the total amount recorded in the general ledger. The summary level payroll transactions recorded in the general ledger could not be reconciled to the transaction level detail provided from the payroll system. When comparing the two populations, we identified the following differences: • ALN 84.425 - For ALN 84.425 sub-program D, we noted a variance of $1,828,609. Total payroll expenditures per the payroll system details amounted to $18,437,724 whereas payroll expenditures per SEFA amounted to $16,609,116. In addition to the above, for ALN 84.425 sub-program U, we noted a variance of $301,432. Total payroll expenditures per the payroll system details amounted to $3,607,738 whereas payroll expenditures per the SEFA amounted to $3,909,170. • ALN 84.010 - We noted a variance of $752,503. Total payroll expenditures per the payroll system details amounted to $40,549,584 whereas payroll expenditures per the SEFA amounted to $39,797,081. Questioned Costs – Not Determinable. Context – This is a condition identified per review of the School System’s population completeness over the compliance requirements for each program. The prevalence of these findings is detailed in the condition section above. Effect – The SEFA may not be completely and accurately stated. In addition, the lack of established internal controls policies and procedures to ensure the SEFA is completely and accurately stated can lead to noncompliance with federal statutes, regulations, and provisions of grant agreements. Cause – The School System did not adhere to their internal policies and procedures to ensure the accuracy of the SEFA. Recommendation – We recommend that the School System develop policies and procedures and enhance their existing reconciliation process to ensure the completeness and accuracy of the SEFA, and that amounts reported on the SEFA are supported by transaction level detail. Views of Responsible Officials – The School System does not concur with the auditor’s findings and recommendations. The total expenditures for all federal programs recorded in the Schedule of Expenditures for Federal Awards are accurately presented and tie to the general ledger. The payroll sub-ledger is corrected before posting to the general ledger every two weeks. The resulting differences are most often immaterial but can be traced to corrections made by the Accounting Office after payroll is reviewed by the grants Restricted Funds Supervisor to ensure payroll is not posted to expired grants. The planned corrective actions are presented in the School System’s Corrective Action Plan attached as Appendix B to the Single Audit Report. BDO Response – We have reviewed management’s response and our finding remains as indicated, since we could not validate the details of the differences.
Finding Number 2022-008 Prior Year Finding Number N/A Compliance Requirement: Allowable Costs/Costs Principles Program: U.S. Department of Education Title I Grants to Local Educational Agencies ALN #: 84.010 Award #: Various Award Period: Various COVID-19 – Governor’s Emergency Education Relief (GEER) ALN #: 84.425C Award #: Various Award Period: Various COVID-19 – Elementary and Secondary School Emergency Relief (ESSR) Fund ALN #: 84.425D Award #: Various Award Period: Various COVID-19 – American Rescue Plan - Elementary and Secondary School Emergency Relief (ARP ESSR) ALN #: 84.425U Award #: 211941 Award Period: 03/24/2021 – 09/30/2023 COVID-19 – American Rescue Plan - Elementary and Secondary School Emergency Relief – Homeless Children and Youth ALN #: 84.425W Award #: Various Award Period: Various Criteria – In accordance with §200.302 Financial Management, a non-federal entity's financial management systems, including records documenting compliance with federal statutes, regulations, and the terms and conditions of the federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the federal statutes, regulations, and the terms and conditions of the federal award. The financial management system of each non-federal entity must provide for the following: 1. Identification, in its accounts, of all federal awards received and expended and the federal programs under which they were received. 2. Accurate, current, and complete disclosure of the financial results of each federal award or program in accordance with the reporting requirements set forth in §200.327 Financial Reporting and §200.328 Monitoring and Reporting Program Performance. 3. Records that identify adequately the source and application of funds for federally funded activities. 4. Effective control over, and accountability for, all funds, property, and other assets. The Uniform Guidance in 2 CFR Section 200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Further, CFR Section 200.510 (b) requires the auditee must also prepare a Schedule of Expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR section 200.502, Basis for determining Federal awards expended. Condition – The amounts recorded in the Schedule of Expenditures of Federal Awards (SEFA) agree to the total amount recorded in the general ledger. The summary level payroll transactions recorded in the general ledger could not be reconciled to the transaction level detail provided from the payroll system. When comparing the two populations, we identified the following differences: • ALN 84.425 - For ALN 84.425 sub-program D, we noted a variance of $1,828,609. Total payroll expenditures per the payroll system details amounted to $18,437,724 whereas payroll expenditures per SEFA amounted to $16,609,116. In addition to the above, for ALN 84.425 sub-program U, we noted a variance of $301,432. Total payroll expenditures per the payroll system details amounted to $3,607,738 whereas payroll expenditures per the SEFA amounted to $3,909,170. • ALN 84.010 - We noted a variance of $752,503. Total payroll expenditures per the payroll system details amounted to $40,549,584 whereas payroll expenditures per the SEFA amounted to $39,797,081. Questioned Costs – Not Determinable. Context – This is a condition identified per review of the School System’s population completeness over the compliance requirements for each program. The prevalence of these findings is detailed in the condition section above. Effect – The SEFA may not be completely and accurately stated. In addition, the lack of established internal controls policies and procedures to ensure the SEFA is completely and accurately stated can lead to noncompliance with federal statutes, regulations, and provisions of grant agreements. Cause – The School System did not adhere to their internal policies and procedures to ensure the accuracy of the SEFA. Recommendation – We recommend that the School System develop policies and procedures and enhance their existing reconciliation process to ensure the completeness and accuracy of the SEFA, and that amounts reported on the SEFA are supported by transaction level detail. Views of Responsible Officials – The School System does not concur with the auditor’s findings and recommendations. The total expenditures for all federal programs recorded in the Schedule of Expenditures for Federal Awards are accurately presented and tie to the general ledger. The payroll sub-ledger is corrected before posting to the general ledger every two weeks. The resulting differences are most often immaterial but can be traced to corrections made by the Accounting Office after payroll is reviewed by the grants Restricted Funds Supervisor to ensure payroll is not posted to expired grants. The planned corrective actions are presented in the School System’s Corrective Action Plan attached as Appendix B to the Single Audit Report. BDO Response – We have reviewed management’s response and our finding remains as indicated, since we could not validate the details of the differences.
Finding Number 2022-008 Prior Year Finding Number N/A Compliance Requirement: Allowable Costs/Costs Principles Program: U.S. Department of Education Title I Grants to Local Educational Agencies ALN #: 84.010 Award #: Various Award Period: Various COVID-19 – Governor’s Emergency Education Relief (GEER) ALN #: 84.425C Award #: Various Award Period: Various COVID-19 – Elementary and Secondary School Emergency Relief (ESSR) Fund ALN #: 84.425D Award #: Various Award Period: Various COVID-19 – American Rescue Plan - Elementary and Secondary School Emergency Relief (ARP ESSR) ALN #: 84.425U Award #: 211941 Award Period: 03/24/2021 – 09/30/2023 COVID-19 – American Rescue Plan - Elementary and Secondary School Emergency Relief – Homeless Children and Youth ALN #: 84.425W Award #: Various Award Period: Various Criteria – In accordance with §200.302 Financial Management, a non-federal entity's financial management systems, including records documenting compliance with federal statutes, regulations, and the terms and conditions of the federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the federal statutes, regulations, and the terms and conditions of the federal award. The financial management system of each non-federal entity must provide for the following: 1. Identification, in its accounts, of all federal awards received and expended and the federal programs under which they were received. 2. Accurate, current, and complete disclosure of the financial results of each federal award or program in accordance with the reporting requirements set forth in §200.327 Financial Reporting and §200.328 Monitoring and Reporting Program Performance. 3. Records that identify adequately the source and application of funds for federally funded activities. 4. Effective control over, and accountability for, all funds, property, and other assets. The Uniform Guidance in 2 CFR Section 200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Further, CFR Section 200.510 (b) requires the auditee must also prepare a Schedule of Expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR section 200.502, Basis for determining Federal awards expended. Condition – The amounts recorded in the Schedule of Expenditures of Federal Awards (SEFA) agree to the total amount recorded in the general ledger. The summary level payroll transactions recorded in the general ledger could not be reconciled to the transaction level detail provided from the payroll system. When comparing the two populations, we identified the following differences: • ALN 84.425 - For ALN 84.425 sub-program D, we noted a variance of $1,828,609. Total payroll expenditures per the payroll system details amounted to $18,437,724 whereas payroll expenditures per SEFA amounted to $16,609,116. In addition to the above, for ALN 84.425 sub-program U, we noted a variance of $301,432. Total payroll expenditures per the payroll system details amounted to $3,607,738 whereas payroll expenditures per the SEFA amounted to $3,909,170. • ALN 84.010 - We noted a variance of $752,503. Total payroll expenditures per the payroll system details amounted to $40,549,584 whereas payroll expenditures per the SEFA amounted to $39,797,081. Questioned Costs – Not Determinable. Context – This is a condition identified per review of the School System’s population completeness over the compliance requirements for each program. The prevalence of these findings is detailed in the condition section above. Effect – The SEFA may not be completely and accurately stated. In addition, the lack of established internal controls policies and procedures to ensure the SEFA is completely and accurately stated can lead to noncompliance with federal statutes, regulations, and provisions of grant agreements. Cause – The School System did not adhere to their internal policies and procedures to ensure the accuracy of the SEFA. Recommendation – We recommend that the School System develop policies and procedures and enhance their existing reconciliation process to ensure the completeness and accuracy of the SEFA, and that amounts reported on the SEFA are supported by transaction level detail. Views of Responsible Officials – The School System does not concur with the auditor’s findings and recommendations. The total expenditures for all federal programs recorded in the Schedule of Expenditures for Federal Awards are accurately presented and tie to the general ledger. The payroll sub-ledger is corrected before posting to the general ledger every two weeks. The resulting differences are most often immaterial but can be traced to corrections made by the Accounting Office after payroll is reviewed by the grants Restricted Funds Supervisor to ensure payroll is not posted to expired grants. The planned corrective actions are presented in the School System’s Corrective Action Plan attached as Appendix B to the Single Audit Report. BDO Response – We have reviewed management’s response and our finding remains as indicated, since we could not validate the details of the differences.
Finding Number 2022-008 Prior Year Finding Number N/A Compliance Requirement: Allowable Costs/Costs Principles Program: U.S. Department of Education Title I Grants to Local Educational Agencies ALN #: 84.010 Award #: Various Award Period: Various COVID-19 – Governor’s Emergency Education Relief (GEER) ALN #: 84.425C Award #: Various Award Period: Various COVID-19 – Elementary and Secondary School Emergency Relief (ESSR) Fund ALN #: 84.425D Award #: Various Award Period: Various COVID-19 – American Rescue Plan - Elementary and Secondary School Emergency Relief (ARP ESSR) ALN #: 84.425U Award #: 211941 Award Period: 03/24/2021 – 09/30/2023 COVID-19 – American Rescue Plan - Elementary and Secondary School Emergency Relief – Homeless Children and Youth ALN #: 84.425W Award #: Various Award Period: Various Criteria – In accordance with §200.302 Financial Management, a non-federal entity's financial management systems, including records documenting compliance with federal statutes, regulations, and the terms and conditions of the federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the federal statutes, regulations, and the terms and conditions of the federal award. The financial management system of each non-federal entity must provide for the following: 1. Identification, in its accounts, of all federal awards received and expended and the federal programs under which they were received. 2. Accurate, current, and complete disclosure of the financial results of each federal award or program in accordance with the reporting requirements set forth in §200.327 Financial Reporting and §200.328 Monitoring and Reporting Program Performance. 3. Records that identify adequately the source and application of funds for federally funded activities. 4. Effective control over, and accountability for, all funds, property, and other assets. The Uniform Guidance in 2 CFR Section 200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Further, CFR Section 200.510 (b) requires the auditee must also prepare a Schedule of Expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR section 200.502, Basis for determining Federal awards expended. Condition – The amounts recorded in the Schedule of Expenditures of Federal Awards (SEFA) agree to the total amount recorded in the general ledger. The summary level payroll transactions recorded in the general ledger could not be reconciled to the transaction level detail provided from the payroll system. When comparing the two populations, we identified the following differences: • ALN 84.425 - For ALN 84.425 sub-program D, we noted a variance of $1,828,609. Total payroll expenditures per the payroll system details amounted to $18,437,724 whereas payroll expenditures per SEFA amounted to $16,609,116. In addition to the above, for ALN 84.425 sub-program U, we noted a variance of $301,432. Total payroll expenditures per the payroll system details amounted to $3,607,738 whereas payroll expenditures per the SEFA amounted to $3,909,170. • ALN 84.010 - We noted a variance of $752,503. Total payroll expenditures per the payroll system details amounted to $40,549,584 whereas payroll expenditures per the SEFA amounted to $39,797,081. Questioned Costs – Not Determinable. Context – This is a condition identified per review of the School System’s population completeness over the compliance requirements for each program. The prevalence of these findings is detailed in the condition section above. Effect – The SEFA may not be completely and accurately stated. In addition, the lack of established internal controls policies and procedures to ensure the SEFA is completely and accurately stated can lead to noncompliance with federal statutes, regulations, and provisions of grant agreements. Cause – The School System did not adhere to their internal policies and procedures to ensure the accuracy of the SEFA. Recommendation – We recommend that the School System develop policies and procedures and enhance their existing reconciliation process to ensure the completeness and accuracy of the SEFA, and that amounts reported on the SEFA are supported by transaction level detail. Views of Responsible Officials – The School System does not concur with the auditor’s findings and recommendations. The total expenditures for all federal programs recorded in the Schedule of Expenditures for Federal Awards are accurately presented and tie to the general ledger. The payroll sub-ledger is corrected before posting to the general ledger every two weeks. The resulting differences are most often immaterial but can be traced to corrections made by the Accounting Office after payroll is reviewed by the grants Restricted Funds Supervisor to ensure payroll is not posted to expired grants. The planned corrective actions are presented in the School System’s Corrective Action Plan attached as Appendix B to the Single Audit Report. BDO Response – We have reviewed management’s response and our finding remains as indicated, since we could not validate the details of the differences.
Finding Number 2022-008 Prior Year Finding Number N/A Compliance Requirement: Allowable Costs/Costs Principles Program: U.S. Department of Education Title I Grants to Local Educational Agencies ALN #: 84.010 Award #: Various Award Period: Various COVID-19 – Governor’s Emergency Education Relief (GEER) ALN #: 84.425C Award #: Various Award Period: Various COVID-19 – Elementary and Secondary School Emergency Relief (ESSR) Fund ALN #: 84.425D Award #: Various Award Period: Various COVID-19 – American Rescue Plan - Elementary and Secondary School Emergency Relief (ARP ESSR) ALN #: 84.425U Award #: 211941 Award Period: 03/24/2021 – 09/30/2023 COVID-19 – American Rescue Plan - Elementary and Secondary School Emergency Relief – Homeless Children and Youth ALN #: 84.425W Award #: Various Award Period: Various Criteria – In accordance with §200.302 Financial Management, a non-federal entity's financial management systems, including records documenting compliance with federal statutes, regulations, and the terms and conditions of the federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the federal statutes, regulations, and the terms and conditions of the federal award. The financial management system of each non-federal entity must provide for the following: 1. Identification, in its accounts, of all federal awards received and expended and the federal programs under which they were received. 2. Accurate, current, and complete disclosure of the financial results of each federal award or program in accordance with the reporting requirements set forth in §200.327 Financial Reporting and §200.328 Monitoring and Reporting Program Performance. 3. Records that identify adequately the source and application of funds for federally funded activities. 4. Effective control over, and accountability for, all funds, property, and other assets. The Uniform Guidance in 2 CFR Section 200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Further, CFR Section 200.510 (b) requires the auditee must also prepare a Schedule of Expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR section 200.502, Basis for determining Federal awards expended. Condition – The amounts recorded in the Schedule of Expenditures of Federal Awards (SEFA) agree to the total amount recorded in the general ledger. The summary level payroll transactions recorded in the general ledger could not be reconciled to the transaction level detail provided from the payroll system. When comparing the two populations, we identified the following differences: • ALN 84.425 - For ALN 84.425 sub-program D, we noted a variance of $1,828,609. Total payroll expenditures per the payroll system details amounted to $18,437,724 whereas payroll expenditures per SEFA amounted to $16,609,116. In addition to the above, for ALN 84.425 sub-program U, we noted a variance of $301,432. Total payroll expenditures per the payroll system details amounted to $3,607,738 whereas payroll expenditures per the SEFA amounted to $3,909,170. • ALN 84.010 - We noted a variance of $752,503. Total payroll expenditures per the payroll system details amounted to $40,549,584 whereas payroll expenditures per the SEFA amounted to $39,797,081. Questioned Costs – Not Determinable. Context – This is a condition identified per review of the School System’s population completeness over the compliance requirements for each program. The prevalence of these findings is detailed in the condition section above. Effect – The SEFA may not be completely and accurately stated. In addition, the lack of established internal controls policies and procedures to ensure the SEFA is completely and accurately stated can lead to noncompliance with federal statutes, regulations, and provisions of grant agreements. Cause – The School System did not adhere to their internal policies and procedures to ensure the accuracy of the SEFA. Recommendation – We recommend that the School System develop policies and procedures and enhance their existing reconciliation process to ensure the completeness and accuracy of the SEFA, and that amounts reported on the SEFA are supported by transaction level detail. Views of Responsible Officials – The School System does not concur with the auditor’s findings and recommendations. The total expenditures for all federal programs recorded in the Schedule of Expenditures for Federal Awards are accurately presented and tie to the general ledger. The payroll sub-ledger is corrected before posting to the general ledger every two weeks. The resulting differences are most often immaterial but can be traced to corrections made by the Accounting Office after payroll is reviewed by the grants Restricted Funds Supervisor to ensure payroll is not posted to expired grants. The planned corrective actions are presented in the School System’s Corrective Action Plan attached as Appendix B to the Single Audit Report. BDO Response – We have reviewed management’s response and our finding remains as indicated, since we could not validate the details of the differences.
Finding Number 2022-008 Prior Year Finding Number N/A Compliance Requirement: Allowable Costs/Costs Principles Program: U.S. Department of Education Title I Grants to Local Educational Agencies ALN #: 84.010 Award #: Various Award Period: Various COVID-19 – Governor’s Emergency Education Relief (GEER) ALN #: 84.425C Award #: Various Award Period: Various COVID-19 – Elementary and Secondary School Emergency Relief (ESSR) Fund ALN #: 84.425D Award #: Various Award Period: Various COVID-19 – American Rescue Plan - Elementary and Secondary School Emergency Relief (ARP ESSR) ALN #: 84.425U Award #: 211941 Award Period: 03/24/2021 – 09/30/2023 COVID-19 – American Rescue Plan - Elementary and Secondary School Emergency Relief – Homeless Children and Youth ALN #: 84.425W Award #: Various Award Period: Various Criteria – In accordance with §200.302 Financial Management, a non-federal entity's financial management systems, including records documenting compliance with federal statutes, regulations, and the terms and conditions of the federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the federal statutes, regulations, and the terms and conditions of the federal award. The financial management system of each non-federal entity must provide for the following: 1. Identification, in its accounts, of all federal awards received and expended and the federal programs under which they were received. 2. Accurate, current, and complete disclosure of the financial results of each federal award or program in accordance with the reporting requirements set forth in §200.327 Financial Reporting and §200.328 Monitoring and Reporting Program Performance. 3. Records that identify adequately the source and application of funds for federally funded activities. 4. Effective control over, and accountability for, all funds, property, and other assets. The Uniform Guidance in 2 CFR Section 200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Further, CFR Section 200.510 (b) requires the auditee must also prepare a Schedule of Expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR section 200.502, Basis for determining Federal awards expended. Condition – The amounts recorded in the Schedule of Expenditures of Federal Awards (SEFA) agree to the total amount recorded in the general ledger. The summary level payroll transactions recorded in the general ledger could not be reconciled to the transaction level detail provided from the payroll system. When comparing the two populations, we identified the following differences: • ALN 84.425 - For ALN 84.425 sub-program D, we noted a variance of $1,828,609. Total payroll expenditures per the payroll system details amounted to $18,437,724 whereas payroll expenditures per SEFA amounted to $16,609,116. In addition to the above, for ALN 84.425 sub-program U, we noted a variance of $301,432. Total payroll expenditures per the payroll system details amounted to $3,607,738 whereas payroll expenditures per the SEFA amounted to $3,909,170. • ALN 84.010 - We noted a variance of $752,503. Total payroll expenditures per the payroll system details amounted to $40,549,584 whereas payroll expenditures per the SEFA amounted to $39,797,081. Questioned Costs – Not Determinable. Context – This is a condition identified per review of the School System’s population completeness over the compliance requirements for each program. The prevalence of these findings is detailed in the condition section above. Effect – The SEFA may not be completely and accurately stated. In addition, the lack of established internal controls policies and procedures to ensure the SEFA is completely and accurately stated can lead to noncompliance with federal statutes, regulations, and provisions of grant agreements. Cause – The School System did not adhere to their internal policies and procedures to ensure the accuracy of the SEFA. Recommendation – We recommend that the School System develop policies and procedures and enhance their existing reconciliation process to ensure the completeness and accuracy of the SEFA, and that amounts reported on the SEFA are supported by transaction level detail. Views of Responsible Officials – The School System does not concur with the auditor’s findings and recommendations. The total expenditures for all federal programs recorded in the Schedule of Expenditures for Federal Awards are accurately presented and tie to the general ledger. The payroll sub-ledger is corrected before posting to the general ledger every two weeks. The resulting differences are most often immaterial but can be traced to corrections made by the Accounting Office after payroll is reviewed by the grants Restricted Funds Supervisor to ensure payroll is not posted to expired grants. The planned corrective actions are presented in the School System’s Corrective Action Plan attached as Appendix B to the Single Audit Report. BDO Response – We have reviewed management’s response and our finding remains as indicated, since we could not validate the details of the differences.
Finding Number 2022-008 Prior Year Finding Number N/A Compliance Requirement: Allowable Costs/Costs Principles Program: U.S. Department of Education Title I Grants to Local Educational Agencies ALN #: 84.010 Award #: Various Award Period: Various COVID-19 – Governor’s Emergency Education Relief (GEER) ALN #: 84.425C Award #: Various Award Period: Various COVID-19 – Elementary and Secondary School Emergency Relief (ESSR) Fund ALN #: 84.425D Award #: Various Award Period: Various COVID-19 – American Rescue Plan - Elementary and Secondary School Emergency Relief (ARP ESSR) ALN #: 84.425U Award #: 211941 Award Period: 03/24/2021 – 09/30/2023 COVID-19 – American Rescue Plan - Elementary and Secondary School Emergency Relief – Homeless Children and Youth ALN #: 84.425W Award #: Various Award Period: Various Criteria – In accordance with §200.302 Financial Management, a non-federal entity's financial management systems, including records documenting compliance with federal statutes, regulations, and the terms and conditions of the federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the federal statutes, regulations, and the terms and conditions of the federal award. The financial management system of each non-federal entity must provide for the following: 1. Identification, in its accounts, of all federal awards received and expended and the federal programs under which they were received. 2. Accurate, current, and complete disclosure of the financial results of each federal award or program in accordance with the reporting requirements set forth in §200.327 Financial Reporting and §200.328 Monitoring and Reporting Program Performance. 3. Records that identify adequately the source and application of funds for federally funded activities. 4. Effective control over, and accountability for, all funds, property, and other assets. The Uniform Guidance in 2 CFR Section 200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Further, CFR Section 200.510 (b) requires the auditee must also prepare a Schedule of Expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR section 200.502, Basis for determining Federal awards expended. Condition – The amounts recorded in the Schedule of Expenditures of Federal Awards (SEFA) agree to the total amount recorded in the general ledger. The summary level payroll transactions recorded in the general ledger could not be reconciled to the transaction level detail provided from the payroll system. When comparing the two populations, we identified the following differences: • ALN 84.425 - For ALN 84.425 sub-program D, we noted a variance of $1,828,609. Total payroll expenditures per the payroll system details amounted to $18,437,724 whereas payroll expenditures per SEFA amounted to $16,609,116. In addition to the above, for ALN 84.425 sub-program U, we noted a variance of $301,432. Total payroll expenditures per the payroll system details amounted to $3,607,738 whereas payroll expenditures per the SEFA amounted to $3,909,170. • ALN 84.010 - We noted a variance of $752,503. Total payroll expenditures per the payroll system details amounted to $40,549,584 whereas payroll expenditures per the SEFA amounted to $39,797,081. Questioned Costs – Not Determinable. Context – This is a condition identified per review of the School System’s population completeness over the compliance requirements for each program. The prevalence of these findings is detailed in the condition section above. Effect – The SEFA may not be completely and accurately stated. In addition, the lack of established internal controls policies and procedures to ensure the SEFA is completely and accurately stated can lead to noncompliance with federal statutes, regulations, and provisions of grant agreements. Cause – The School System did not adhere to their internal policies and procedures to ensure the accuracy of the SEFA. Recommendation – We recommend that the School System develop policies and procedures and enhance their existing reconciliation process to ensure the completeness and accuracy of the SEFA, and that amounts reported on the SEFA are supported by transaction level detail. Views of Responsible Officials – The School System does not concur with the auditor’s findings and recommendations. The total expenditures for all federal programs recorded in the Schedule of Expenditures for Federal Awards are accurately presented and tie to the general ledger. The payroll sub-ledger is corrected before posting to the general ledger every two weeks. The resulting differences are most often immaterial but can be traced to corrections made by the Accounting Office after payroll is reviewed by the grants Restricted Funds Supervisor to ensure payroll is not posted to expired grants. The planned corrective actions are presented in the School System’s Corrective Action Plan attached as Appendix B to the Single Audit Report. BDO Response – We have reviewed management’s response and our finding remains as indicated, since we could not validate the details of the differences.
Finding Number 2022-008 Prior Year Finding Number N/A Compliance Requirement: Allowable Costs/Costs Principles Program: U.S. Department of Education Title I Grants to Local Educational Agencies ALN #: 84.010 Award #: Various Award Period: Various COVID-19 – Governor’s Emergency Education Relief (GEER) ALN #: 84.425C Award #: Various Award Period: Various COVID-19 – Elementary and Secondary School Emergency Relief (ESSR) Fund ALN #: 84.425D Award #: Various Award Period: Various COVID-19 – American Rescue Plan - Elementary and Secondary School Emergency Relief (ARP ESSR) ALN #: 84.425U Award #: 211941 Award Period: 03/24/2021 – 09/30/2023 COVID-19 – American Rescue Plan - Elementary and Secondary School Emergency Relief – Homeless Children and Youth ALN #: 84.425W Award #: Various Award Period: Various Criteria – In accordance with §200.302 Financial Management, a non-federal entity's financial management systems, including records documenting compliance with federal statutes, regulations, and the terms and conditions of the federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the federal statutes, regulations, and the terms and conditions of the federal award. The financial management system of each non-federal entity must provide for the following: 1. Identification, in its accounts, of all federal awards received and expended and the federal programs under which they were received. 2. Accurate, current, and complete disclosure of the financial results of each federal award or program in accordance with the reporting requirements set forth in §200.327 Financial Reporting and §200.328 Monitoring and Reporting Program Performance. 3. Records that identify adequately the source and application of funds for federally funded activities. 4. Effective control over, and accountability for, all funds, property, and other assets. The Uniform Guidance in 2 CFR Section 200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Further, CFR Section 200.510 (b) requires the auditee must also prepare a Schedule of Expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR section 200.502, Basis for determining Federal awards expended. Condition – The amounts recorded in the Schedule of Expenditures of Federal Awards (SEFA) agree to the total amount recorded in the general ledger. The summary level payroll transactions recorded in the general ledger could not be reconciled to the transaction level detail provided from the payroll system. When comparing the two populations, we identified the following differences: • ALN 84.425 - For ALN 84.425 sub-program D, we noted a variance of $1,828,609. Total payroll expenditures per the payroll system details amounted to $18,437,724 whereas payroll expenditures per SEFA amounted to $16,609,116. In addition to the above, for ALN 84.425 sub-program U, we noted a variance of $301,432. Total payroll expenditures per the payroll system details amounted to $3,607,738 whereas payroll expenditures per the SEFA amounted to $3,909,170. • ALN 84.010 - We noted a variance of $752,503. Total payroll expenditures per the payroll system details amounted to $40,549,584 whereas payroll expenditures per the SEFA amounted to $39,797,081. Questioned Costs – Not Determinable. Context – This is a condition identified per review of the School System’s population completeness over the compliance requirements for each program. The prevalence of these findings is detailed in the condition section above. Effect – The SEFA may not be completely and accurately stated. In addition, the lack of established internal controls policies and procedures to ensure the SEFA is completely and accurately stated can lead to noncompliance with federal statutes, regulations, and provisions of grant agreements. Cause – The School System did not adhere to their internal policies and procedures to ensure the accuracy of the SEFA. Recommendation – We recommend that the School System develop policies and procedures and enhance their existing reconciliation process to ensure the completeness and accuracy of the SEFA, and that amounts reported on the SEFA are supported by transaction level detail. Views of Responsible Officials – The School System does not concur with the auditor’s findings and recommendations. The total expenditures for all federal programs recorded in the Schedule of Expenditures for Federal Awards are accurately presented and tie to the general ledger. The payroll sub-ledger is corrected before posting to the general ledger every two weeks. The resulting differences are most often immaterial but can be traced to corrections made by the Accounting Office after payroll is reviewed by the grants Restricted Funds Supervisor to ensure payroll is not posted to expired grants. The planned corrective actions are presented in the School System’s Corrective Action Plan attached as Appendix B to the Single Audit Report. BDO Response – We have reviewed management’s response and our finding remains as indicated, since we could not validate the details of the differences.
Finding Number 2022-008 Prior Year Finding Number N/A Compliance Requirement: Allowable Costs/Costs Principles Program: U.S. Department of Education Title I Grants to Local Educational Agencies ALN #: 84.010 Award #: Various Award Period: Various COVID-19 – Governor’s Emergency Education Relief (GEER) ALN #: 84.425C Award #: Various Award Period: Various COVID-19 – Elementary and Secondary School Emergency Relief (ESSR) Fund ALN #: 84.425D Award #: Various Award Period: Various COVID-19 – American Rescue Plan - Elementary and Secondary School Emergency Relief (ARP ESSR) ALN #: 84.425U Award #: 211941 Award Period: 03/24/2021 – 09/30/2023 COVID-19 – American Rescue Plan - Elementary and Secondary School Emergency Relief – Homeless Children and Youth ALN #: 84.425W Award #: Various Award Period: Various Criteria – In accordance with §200.302 Financial Management, a non-federal entity's financial management systems, including records documenting compliance with federal statutes, regulations, and the terms and conditions of the federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the federal statutes, regulations, and the terms and conditions of the federal award. The financial management system of each non-federal entity must provide for the following: 1. Identification, in its accounts, of all federal awards received and expended and the federal programs under which they were received. 2. Accurate, current, and complete disclosure of the financial results of each federal award or program in accordance with the reporting requirements set forth in §200.327 Financial Reporting and §200.328 Monitoring and Reporting Program Performance. 3. Records that identify adequately the source and application of funds for federally funded activities. 4. Effective control over, and accountability for, all funds, property, and other assets. The Uniform Guidance in 2 CFR Section 200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Further, CFR Section 200.510 (b) requires the auditee must also prepare a Schedule of Expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR section 200.502, Basis for determining Federal awards expended. Condition – The amounts recorded in the Schedule of Expenditures of Federal Awards (SEFA) agree to the total amount recorded in the general ledger. The summary level payroll transactions recorded in the general ledger could not be reconciled to the transaction level detail provided from the payroll system. When comparing the two populations, we identified the following differences: • ALN 84.425 - For ALN 84.425 sub-program D, we noted a variance of $1,828,609. Total payroll expenditures per the payroll system details amounted to $18,437,724 whereas payroll expenditures per SEFA amounted to $16,609,116. In addition to the above, for ALN 84.425 sub-program U, we noted a variance of $301,432. Total payroll expenditures per the payroll system details amounted to $3,607,738 whereas payroll expenditures per the SEFA amounted to $3,909,170. • ALN 84.010 - We noted a variance of $752,503. Total payroll expenditures per the payroll system details amounted to $40,549,584 whereas payroll expenditures per the SEFA amounted to $39,797,081. Questioned Costs – Not Determinable. Context – This is a condition identified per review of the School System’s population completeness over the compliance requirements for each program. The prevalence of these findings is detailed in the condition section above. Effect – The SEFA may not be completely and accurately stated. In addition, the lack of established internal controls policies and procedures to ensure the SEFA is completely and accurately stated can lead to noncompliance with federal statutes, regulations, and provisions of grant agreements. Cause – The School System did not adhere to their internal policies and procedures to ensure the accuracy of the SEFA. Recommendation – We recommend that the School System develop policies and procedures and enhance their existing reconciliation process to ensure the completeness and accuracy of the SEFA, and that amounts reported on the SEFA are supported by transaction level detail. Views of Responsible Officials – The School System does not concur with the auditor’s findings and recommendations. The total expenditures for all federal programs recorded in the Schedule of Expenditures for Federal Awards are accurately presented and tie to the general ledger. The payroll sub-ledger is corrected before posting to the general ledger every two weeks. The resulting differences are most often immaterial but can be traced to corrections made by the Accounting Office after payroll is reviewed by the grants Restricted Funds Supervisor to ensure payroll is not posted to expired grants. The planned corrective actions are presented in the School System’s Corrective Action Plan attached as Appendix B to the Single Audit Report. BDO Response – We have reviewed management’s response and our finding remains as indicated, since we could not validate the details of the differences.
Finding Number 2022-008 Prior Year Finding Number N/A Compliance Requirement: Allowable Costs/Costs Principles Program: U.S. Department of Education Title I Grants to Local Educational Agencies ALN #: 84.010 Award #: Various Award Period: Various COVID-19 – Governor’s Emergency Education Relief (GEER) ALN #: 84.425C Award #: Various Award Period: Various COVID-19 – Elementary and Secondary School Emergency Relief (ESSR) Fund ALN #: 84.425D Award #: Various Award Period: Various COVID-19 – American Rescue Plan - Elementary and Secondary School Emergency Relief (ARP ESSR) ALN #: 84.425U Award #: 211941 Award Period: 03/24/2021 – 09/30/2023 COVID-19 – American Rescue Plan - Elementary and Secondary School Emergency Relief – Homeless Children and Youth ALN #: 84.425W Award #: Various Award Period: Various Criteria – In accordance with §200.302 Financial Management, a non-federal entity's financial management systems, including records documenting compliance with federal statutes, regulations, and the terms and conditions of the federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the federal statutes, regulations, and the terms and conditions of the federal award. The financial management system of each non-federal entity must provide for the following: 1. Identification, in its accounts, of all federal awards received and expended and the federal programs under which they were received. 2. Accurate, current, and complete disclosure of the financial results of each federal award or program in accordance with the reporting requirements set forth in §200.327 Financial Reporting and §200.328 Monitoring and Reporting Program Performance. 3. Records that identify adequately the source and application of funds for federally funded activities. 4. Effective control over, and accountability for, all funds, property, and other assets. The Uniform Guidance in 2 CFR Section 200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Further, CFR Section 200.510 (b) requires the auditee must also prepare a Schedule of Expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR section 200.502, Basis for determining Federal awards expended. Condition – The amounts recorded in the Schedule of Expenditures of Federal Awards (SEFA) agree to the total amount recorded in the general ledger. The summary level payroll transactions recorded in the general ledger could not be reconciled to the transaction level detail provided from the payroll system. When comparing the two populations, we identified the following differences: • ALN 84.425 - For ALN 84.425 sub-program D, we noted a variance of $1,828,609. Total payroll expenditures per the payroll system details amounted to $18,437,724 whereas payroll expenditures per SEFA amounted to $16,609,116. In addition to the above, for ALN 84.425 sub-program U, we noted a variance of $301,432. Total payroll expenditures per the payroll system details amounted to $3,607,738 whereas payroll expenditures per the SEFA amounted to $3,909,170. • ALN 84.010 - We noted a variance of $752,503. Total payroll expenditures per the payroll system details amounted to $40,549,584 whereas payroll expenditures per the SEFA amounted to $39,797,081. Questioned Costs – Not Determinable. Context – This is a condition identified per review of the School System’s population completeness over the compliance requirements for each program. The prevalence of these findings is detailed in the condition section above. Effect – The SEFA may not be completely and accurately stated. In addition, the lack of established internal controls policies and procedures to ensure the SEFA is completely and accurately stated can lead to noncompliance with federal statutes, regulations, and provisions of grant agreements. Cause – The School System did not adhere to their internal policies and procedures to ensure the accuracy of the SEFA. Recommendation – We recommend that the School System develop policies and procedures and enhance their existing reconciliation process to ensure the completeness and accuracy of the SEFA, and that amounts reported on the SEFA are supported by transaction level detail. Views of Responsible Officials – The School System does not concur with the auditor’s findings and recommendations. The total expenditures for all federal programs recorded in the Schedule of Expenditures for Federal Awards are accurately presented and tie to the general ledger. The payroll sub-ledger is corrected before posting to the general ledger every two weeks. The resulting differences are most often immaterial but can be traced to corrections made by the Accounting Office after payroll is reviewed by the grants Restricted Funds Supervisor to ensure payroll is not posted to expired grants. The planned corrective actions are presented in the School System’s Corrective Action Plan attached as Appendix B to the Single Audit Report. BDO Response – We have reviewed management’s response and our finding remains as indicated, since we could not validate the details of the differences.
Finding Number 2022-008 Prior Year Finding Number N/A Compliance Requirement: Allowable Costs/Costs Principles Program: U.S. Department of Education Title I Grants to Local Educational Agencies ALN #: 84.010 Award #: Various Award Period: Various COVID-19 – Governor’s Emergency Education Relief (GEER) ALN #: 84.425C Award #: Various Award Period: Various COVID-19 – Elementary and Secondary School Emergency Relief (ESSR) Fund ALN #: 84.425D Award #: Various Award Period: Various COVID-19 – American Rescue Plan - Elementary and Secondary School Emergency Relief (ARP ESSR) ALN #: 84.425U Award #: 211941 Award Period: 03/24/2021 – 09/30/2023 COVID-19 – American Rescue Plan - Elementary and Secondary School Emergency Relief – Homeless Children and Youth ALN #: 84.425W Award #: Various Award Period: Various Criteria – In accordance with §200.302 Financial Management, a non-federal entity's financial management systems, including records documenting compliance with federal statutes, regulations, and the terms and conditions of the federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the federal statutes, regulations, and the terms and conditions of the federal award. The financial management system of each non-federal entity must provide for the following: 1. Identification, in its accounts, of all federal awards received and expended and the federal programs under which they were received. 2. Accurate, current, and complete disclosure of the financial results of each federal award or program in accordance with the reporting requirements set forth in §200.327 Financial Reporting and §200.328 Monitoring and Reporting Program Performance. 3. Records that identify adequately the source and application of funds for federally funded activities. 4. Effective control over, and accountability for, all funds, property, and other assets. The Uniform Guidance in 2 CFR Section 200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Further, CFR Section 200.510 (b) requires the auditee must also prepare a Schedule of Expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR section 200.502, Basis for determining Federal awards expended. Condition – The amounts recorded in the Schedule of Expenditures of Federal Awards (SEFA) agree to the total amount recorded in the general ledger. The summary level payroll transactions recorded in the general ledger could not be reconciled to the transaction level detail provided from the payroll system. When comparing the two populations, we identified the following differences: • ALN 84.425 - For ALN 84.425 sub-program D, we noted a variance of $1,828,609. Total payroll expenditures per the payroll system details amounted to $18,437,724 whereas payroll expenditures per SEFA amounted to $16,609,116. In addition to the above, for ALN 84.425 sub-program U, we noted a variance of $301,432. Total payroll expenditures per the payroll system details amounted to $3,607,738 whereas payroll expenditures per the SEFA amounted to $3,909,170. • ALN 84.010 - We noted a variance of $752,503. Total payroll expenditures per the payroll system details amounted to $40,549,584 whereas payroll expenditures per the SEFA amounted to $39,797,081. Questioned Costs – Not Determinable. Context – This is a condition identified per review of the School System’s population completeness over the compliance requirements for each program. The prevalence of these findings is detailed in the condition section above. Effect – The SEFA may not be completely and accurately stated. In addition, the lack of established internal controls policies and procedures to ensure the SEFA is completely and accurately stated can lead to noncompliance with federal statutes, regulations, and provisions of grant agreements. Cause – The School System did not adhere to their internal policies and procedures to ensure the accuracy of the SEFA. Recommendation – We recommend that the School System develop policies and procedures and enhance their existing reconciliation process to ensure the completeness and accuracy of the SEFA, and that amounts reported on the SEFA are supported by transaction level detail. Views of Responsible Officials – The School System does not concur with the auditor’s findings and recommendations. The total expenditures for all federal programs recorded in the Schedule of Expenditures for Federal Awards are accurately presented and tie to the general ledger. The payroll sub-ledger is corrected before posting to the general ledger every two weeks. The resulting differences are most often immaterial but can be traced to corrections made by the Accounting Office after payroll is reviewed by the grants Restricted Funds Supervisor to ensure payroll is not posted to expired grants. The planned corrective actions are presented in the School System’s Corrective Action Plan attached as Appendix B to the Single Audit Report. BDO Response – We have reviewed management’s response and our finding remains as indicated, since we could not validate the details of the differences.
Finding Number 2022-008 Prior Year Finding Number N/A Compliance Requirement: Allowable Costs/Costs Principles Program: U.S. Department of Education Title I Grants to Local Educational Agencies ALN #: 84.010 Award #: Various Award Period: Various COVID-19 – Governor’s Emergency Education Relief (GEER) ALN #: 84.425C Award #: Various Award Period: Various COVID-19 – Elementary and Secondary School Emergency Relief (ESSR) Fund ALN #: 84.425D Award #: Various Award Period: Various COVID-19 – American Rescue Plan - Elementary and Secondary School Emergency Relief (ARP ESSR) ALN #: 84.425U Award #: 211941 Award Period: 03/24/2021 – 09/30/2023 COVID-19 – American Rescue Plan - Elementary and Secondary School Emergency Relief – Homeless Children and Youth ALN #: 84.425W Award #: Various Award Period: Various Criteria – In accordance with §200.302 Financial Management, a non-federal entity's financial management systems, including records documenting compliance with federal statutes, regulations, and the terms and conditions of the federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the federal statutes, regulations, and the terms and conditions of the federal award. The financial management system of each non-federal entity must provide for the following: 1. Identification, in its accounts, of all federal awards received and expended and the federal programs under which they were received. 2. Accurate, current, and complete disclosure of the financial results of each federal award or program in accordance with the reporting requirements set forth in §200.327 Financial Reporting and §200.328 Monitoring and Reporting Program Performance. 3. Records that identify adequately the source and application of funds for federally funded activities. 4. Effective control over, and accountability for, all funds, property, and other assets. The Uniform Guidance in 2 CFR Section 200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Further, CFR Section 200.510 (b) requires the auditee must also prepare a Schedule of Expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR section 200.502, Basis for determining Federal awards expended. Condition – The amounts recorded in the Schedule of Expenditures of Federal Awards (SEFA) agree to the total amount recorded in the general ledger. The summary level payroll transactions recorded in the general ledger could not be reconciled to the transaction level detail provided from the payroll system. When comparing the two populations, we identified the following differences: • ALN 84.425 - For ALN 84.425 sub-program D, we noted a variance of $1,828,609. Total payroll expenditures per the payroll system details amounted to $18,437,724 whereas payroll expenditures per SEFA amounted to $16,609,116. In addition to the above, for ALN 84.425 sub-program U, we noted a variance of $301,432. Total payroll expenditures per the payroll system details amounted to $3,607,738 whereas payroll expenditures per the SEFA amounted to $3,909,170. • ALN 84.010 - We noted a variance of $752,503. Total payroll expenditures per the payroll system details amounted to $40,549,584 whereas payroll expenditures per the SEFA amounted to $39,797,081. Questioned Costs – Not Determinable. Context – This is a condition identified per review of the School System’s population completeness over the compliance requirements for each program. The prevalence of these findings is detailed in the condition section above. Effect – The SEFA may not be completely and accurately stated. In addition, the lack of established internal controls policies and procedures to ensure the SEFA is completely and accurately stated can lead to noncompliance with federal statutes, regulations, and provisions of grant agreements. Cause – The School System did not adhere to their internal policies and procedures to ensure the accuracy of the SEFA. Recommendation – We recommend that the School System develop policies and procedures and enhance their existing reconciliation process to ensure the completeness and accuracy of the SEFA, and that amounts reported on the SEFA are supported by transaction level detail. Views of Responsible Officials – The School System does not concur with the auditor’s findings and recommendations. The total expenditures for all federal programs recorded in the Schedule of Expenditures for Federal Awards are accurately presented and tie to the general ledger. The payroll sub-ledger is corrected before posting to the general ledger every two weeks. The resulting differences are most often immaterial but can be traced to corrections made by the Accounting Office after payroll is reviewed by the grants Restricted Funds Supervisor to ensure payroll is not posted to expired grants. The planned corrective actions are presented in the School System’s Corrective Action Plan attached as Appendix B to the Single Audit Report. BDO Response – We have reviewed management’s response and our finding remains as indicated, since we could not validate the details of the differences.
Finding Number 2022-008 Prior Year Finding Number N/A Compliance Requirement: Allowable Costs/Costs Principles Program: U.S. Department of Education Title I Grants to Local Educational Agencies ALN #: 84.010 Award #: Various Award Period: Various COVID-19 – Governor’s Emergency Education Relief (GEER) ALN #: 84.425C Award #: Various Award Period: Various COVID-19 – Elementary and Secondary School Emergency Relief (ESSR) Fund ALN #: 84.425D Award #: Various Award Period: Various COVID-19 – American Rescue Plan - Elementary and Secondary School Emergency Relief (ARP ESSR) ALN #: 84.425U Award #: 211941 Award Period: 03/24/2021 – 09/30/2023 COVID-19 – American Rescue Plan - Elementary and Secondary School Emergency Relief – Homeless Children and Youth ALN #: 84.425W Award #: Various Award Period: Various Criteria – In accordance with §200.302 Financial Management, a non-federal entity's financial management systems, including records documenting compliance with federal statutes, regulations, and the terms and conditions of the federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the federal statutes, regulations, and the terms and conditions of the federal award. The financial management system of each non-federal entity must provide for the following: 1. Identification, in its accounts, of all federal awards received and expended and the federal programs under which they were received. 2. Accurate, current, and complete disclosure of the financial results of each federal award or program in accordance with the reporting requirements set forth in §200.327 Financial Reporting and §200.328 Monitoring and Reporting Program Performance. 3. Records that identify adequately the source and application of funds for federally funded activities. 4. Effective control over, and accountability for, all funds, property, and other assets. The Uniform Guidance in 2 CFR Section 200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Further, CFR Section 200.510 (b) requires the auditee must also prepare a Schedule of Expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR section 200.502, Basis for determining Federal awards expended. Condition – The amounts recorded in the Schedule of Expenditures of Federal Awards (SEFA) agree to the total amount recorded in the general ledger. The summary level payroll transactions recorded in the general ledger could not be reconciled to the transaction level detail provided from the payroll system. When comparing the two populations, we identified the following differences: • ALN 84.425 - For ALN 84.425 sub-program D, we noted a variance of $1,828,609. Total payroll expenditures per the payroll system details amounted to $18,437,724 whereas payroll expenditures per SEFA amounted to $16,609,116. In addition to the above, for ALN 84.425 sub-program U, we noted a variance of $301,432. Total payroll expenditures per the payroll system details amounted to $3,607,738 whereas payroll expenditures per the SEFA amounted to $3,909,170. • ALN 84.010 - We noted a variance of $752,503. Total payroll expenditures per the payroll system details amounted to $40,549,584 whereas payroll expenditures per the SEFA amounted to $39,797,081. Questioned Costs – Not Determinable. Context – This is a condition identified per review of the School System’s population completeness over the compliance requirements for each program. The prevalence of these findings is detailed in the condition section above. Effect – The SEFA may not be completely and accurately stated. In addition, the lack of established internal controls policies and procedures to ensure the SEFA is completely and accurately stated can lead to noncompliance with federal statutes, regulations, and provisions of grant agreements. Cause – The School System did not adhere to their internal policies and procedures to ensure the accuracy of the SEFA. Recommendation – We recommend that the School System develop policies and procedures and enhance their existing reconciliation process to ensure the completeness and accuracy of the SEFA, and that amounts reported on the SEFA are supported by transaction level detail. Views of Responsible Officials – The School System does not concur with the auditor’s findings and recommendations. The total expenditures for all federal programs recorded in the Schedule of Expenditures for Federal Awards are accurately presented and tie to the general ledger. The payroll sub-ledger is corrected before posting to the general ledger every two weeks. The resulting differences are most often immaterial but can be traced to corrections made by the Accounting Office after payroll is reviewed by the grants Restricted Funds Supervisor to ensure payroll is not posted to expired grants. The planned corrective actions are presented in the School System’s Corrective Action Plan attached as Appendix B to the Single Audit Report. BDO Response – We have reviewed management’s response and our finding remains as indicated, since we could not validate the details of the differences.
Finding Number 2022-008 Prior Year Finding Number N/A Compliance Requirement: Allowable Costs/Costs Principles Program: U.S. Department of Education Title I Grants to Local Educational Agencies ALN #: 84.010 Award #: Various Award Period: Various COVID-19 – Governor’s Emergency Education Relief (GEER) ALN #: 84.425C Award #: Various Award Period: Various COVID-19 – Elementary and Secondary School Emergency Relief (ESSR) Fund ALN #: 84.425D Award #: Various Award Period: Various COVID-19 – American Rescue Plan - Elementary and Secondary School Emergency Relief (ARP ESSR) ALN #: 84.425U Award #: 211941 Award Period: 03/24/2021 – 09/30/2023 COVID-19 – American Rescue Plan - Elementary and Secondary School Emergency Relief – Homeless Children and Youth ALN #: 84.425W Award #: Various Award Period: Various Criteria – In accordance with §200.302 Financial Management, a non-federal entity's financial management systems, including records documenting compliance with federal statutes, regulations, and the terms and conditions of the federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the federal statutes, regulations, and the terms and conditions of the federal award. The financial management system of each non-federal entity must provide for the following: 1. Identification, in its accounts, of all federal awards received and expended and the federal programs under which they were received. 2. Accurate, current, and complete disclosure of the financial results of each federal award or program in accordance with the reporting requirements set forth in §200.327 Financial Reporting and §200.328 Monitoring and Reporting Program Performance. 3. Records that identify adequately the source and application of funds for federally funded activities. 4. Effective control over, and accountability for, all funds, property, and other assets. The Uniform Guidance in 2 CFR Section 200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Further, CFR Section 200.510 (b) requires the auditee must also prepare a Schedule of Expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR section 200.502, Basis for determining Federal awards expended. Condition – The amounts recorded in the Schedule of Expenditures of Federal Awards (SEFA) agree to the total amount recorded in the general ledger. The summary level payroll transactions recorded in the general ledger could not be reconciled to the transaction level detail provided from the payroll system. When comparing the two populations, we identified the following differences: • ALN 84.425 - For ALN 84.425 sub-program D, we noted a variance of $1,828,609. Total payroll expenditures per the payroll system details amounted to $18,437,724 whereas payroll expenditures per SEFA amounted to $16,609,116. In addition to the above, for ALN 84.425 sub-program U, we noted a variance of $301,432. Total payroll expenditures per the payroll system details amounted to $3,607,738 whereas payroll expenditures per the SEFA amounted to $3,909,170. • ALN 84.010 - We noted a variance of $752,503. Total payroll expenditures per the payroll system details amounted to $40,549,584 whereas payroll expenditures per the SEFA amounted to $39,797,081. Questioned Costs – Not Determinable. Context – This is a condition identified per review of the School System’s population completeness over the compliance requirements for each program. The prevalence of these findings is detailed in the condition section above. Effect – The SEFA may not be completely and accurately stated. In addition, the lack of established internal controls policies and procedures to ensure the SEFA is completely and accurately stated can lead to noncompliance with federal statutes, regulations, and provisions of grant agreements. Cause – The School System did not adhere to their internal policies and procedures to ensure the accuracy of the SEFA. Recommendation – We recommend that the School System develop policies and procedures and enhance their existing reconciliation process to ensure the completeness and accuracy of the SEFA, and that amounts reported on the SEFA are supported by transaction level detail. Views of Responsible Officials – The School System does not concur with the auditor’s findings and recommendations. The total expenditures for all federal programs recorded in the Schedule of Expenditures for Federal Awards are accurately presented and tie to the general ledger. The payroll sub-ledger is corrected before posting to the general ledger every two weeks. The resulting differences are most often immaterial but can be traced to corrections made by the Accounting Office after payroll is reviewed by the grants Restricted Funds Supervisor to ensure payroll is not posted to expired grants. The planned corrective actions are presented in the School System’s Corrective Action Plan attached as Appendix B to the Single Audit Report. BDO Response – We have reviewed management’s response and our finding remains as indicated, since we could not validate the details of the differences.
Finding Number 2022-008 Prior Year Finding Number N/A Compliance Requirement: Allowable Costs/Costs Principles Program: U.S. Department of Education Title I Grants to Local Educational Agencies ALN #: 84.010 Award #: Various Award Period: Various COVID-19 – Governor’s Emergency Education Relief (GEER) ALN #: 84.425C Award #: Various Award Period: Various COVID-19 – Elementary and Secondary School Emergency Relief (ESSR) Fund ALN #: 84.425D Award #: Various Award Period: Various COVID-19 – American Rescue Plan - Elementary and Secondary School Emergency Relief (ARP ESSR) ALN #: 84.425U Award #: 211941 Award Period: 03/24/2021 – 09/30/2023 COVID-19 – American Rescue Plan - Elementary and Secondary School Emergency Relief – Homeless Children and Youth ALN #: 84.425W Award #: Various Award Period: Various Criteria – In accordance with §200.302 Financial Management, a non-federal entity's financial management systems, including records documenting compliance with federal statutes, regulations, and the terms and conditions of the federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the federal statutes, regulations, and the terms and conditions of the federal award. The financial management system of each non-federal entity must provide for the following: 1. Identification, in its accounts, of all federal awards received and expended and the federal programs under which they were received. 2. Accurate, current, and complete disclosure of the financial results of each federal award or program in accordance with the reporting requirements set forth in §200.327 Financial Reporting and §200.328 Monitoring and Reporting Program Performance. 3. Records that identify adequately the source and application of funds for federally funded activities. 4. Effective control over, and accountability for, all funds, property, and other assets. The Uniform Guidance in 2 CFR Section 200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Further, CFR Section 200.510 (b) requires the auditee must also prepare a Schedule of Expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR section 200.502, Basis for determining Federal awards expended. Condition – The amounts recorded in the Schedule of Expenditures of Federal Awards (SEFA) agree to the total amount recorded in the general ledger. The summary level payroll transactions recorded in the general ledger could not be reconciled to the transaction level detail provided from the payroll system. When comparing the two populations, we identified the following differences: • ALN 84.425 - For ALN 84.425 sub-program D, we noted a variance of $1,828,609. Total payroll expenditures per the payroll system details amounted to $18,437,724 whereas payroll expenditures per SEFA amounted to $16,609,116. In addition to the above, for ALN 84.425 sub-program U, we noted a variance of $301,432. Total payroll expenditures per the payroll system details amounted to $3,607,738 whereas payroll expenditures per the SEFA amounted to $3,909,170. • ALN 84.010 - We noted a variance of $752,503. Total payroll expenditures per the payroll system details amounted to $40,549,584 whereas payroll expenditures per the SEFA amounted to $39,797,081. Questioned Costs – Not Determinable. Context – This is a condition identified per review of the School System’s population completeness over the compliance requirements for each program. The prevalence of these findings is detailed in the condition section above. Effect – The SEFA may not be completely and accurately stated. In addition, the lack of established internal controls policies and procedures to ensure the SEFA is completely and accurately stated can lead to noncompliance with federal statutes, regulations, and provisions of grant agreements. Cause – The School System did not adhere to their internal policies and procedures to ensure the accuracy of the SEFA. Recommendation – We recommend that the School System develop policies and procedures and enhance their existing reconciliation process to ensure the completeness and accuracy of the SEFA, and that amounts reported on the SEFA are supported by transaction level detail. Views of Responsible Officials – The School System does not concur with the auditor’s findings and recommendations. The total expenditures for all federal programs recorded in the Schedule of Expenditures for Federal Awards are accurately presented and tie to the general ledger. The payroll sub-ledger is corrected before posting to the general ledger every two weeks. The resulting differences are most often immaterial but can be traced to corrections made by the Accounting Office after payroll is reviewed by the grants Restricted Funds Supervisor to ensure payroll is not posted to expired grants. The planned corrective actions are presented in the School System’s Corrective Action Plan attached as Appendix B to the Single Audit Report. BDO Response – We have reviewed management’s response and our finding remains as indicated, since we could not validate the details of the differences.
Finding Number 2022-008 Prior Year Finding Number N/A Compliance Requirement: Allowable Costs/Costs Principles Program: U.S. Department of Education Title I Grants to Local Educational Agencies ALN #: 84.010 Award #: Various Award Period: Various COVID-19 – Governor’s Emergency Education Relief (GEER) ALN #: 84.425C Award #: Various Award Period: Various COVID-19 – Elementary and Secondary School Emergency Relief (ESSR) Fund ALN #: 84.425D Award #: Various Award Period: Various COVID-19 – American Rescue Plan - Elementary and Secondary School Emergency Relief (ARP ESSR) ALN #: 84.425U Award #: 211941 Award Period: 03/24/2021 – 09/30/2023 COVID-19 – American Rescue Plan - Elementary and Secondary School Emergency Relief – Homeless Children and Youth ALN #: 84.425W Award #: Various Award Period: Various Criteria – In accordance with §200.302 Financial Management, a non-federal entity's financial management systems, including records documenting compliance with federal statutes, regulations, and the terms and conditions of the federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the federal statutes, regulations, and the terms and conditions of the federal award. The financial management system of each non-federal entity must provide for the following: 1. Identification, in its accounts, of all federal awards received and expended and the federal programs under which they were received. 2. Accurate, current, and complete disclosure of the financial results of each federal award or program in accordance with the reporting requirements set forth in §200.327 Financial Reporting and §200.328 Monitoring and Reporting Program Performance. 3. Records that identify adequately the source and application of funds for federally funded activities. 4. Effective control over, and accountability for, all funds, property, and other assets. The Uniform Guidance in 2 CFR Section 200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Further, CFR Section 200.510 (b) requires the auditee must also prepare a Schedule of Expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR section 200.502, Basis for determining Federal awards expended. Condition – The amounts recorded in the Schedule of Expenditures of Federal Awards (SEFA) agree to the total amount recorded in the general ledger. The summary level payroll transactions recorded in the general ledger could not be reconciled to the transaction level detail provided from the payroll system. When comparing the two populations, we identified the following differences: • ALN 84.425 - For ALN 84.425 sub-program D, we noted a variance of $1,828,609. Total payroll expenditures per the payroll system details amounted to $18,437,724 whereas payroll expenditures per SEFA amounted to $16,609,116. In addition to the above, for ALN 84.425 sub-program U, we noted a variance of $301,432. Total payroll expenditures per the payroll system details amounted to $3,607,738 whereas payroll expenditures per the SEFA amounted to $3,909,170. • ALN 84.010 - We noted a variance of $752,503. Total payroll expenditures per the payroll system details amounted to $40,549,584 whereas payroll expenditures per the SEFA amounted to $39,797,081. Questioned Costs – Not Determinable. Context – This is a condition identified per review of the School System’s population completeness over the compliance requirements for each program. The prevalence of these findings is detailed in the condition section above. Effect – The SEFA may not be completely and accurately stated. In addition, the lack of established internal controls policies and procedures to ensure the SEFA is completely and accurately stated can lead to noncompliance with federal statutes, regulations, and provisions of grant agreements. Cause – The School System did not adhere to their internal policies and procedures to ensure the accuracy of the SEFA. Recommendation – We recommend that the School System develop policies and procedures and enhance their existing reconciliation process to ensure the completeness and accuracy of the SEFA, and that amounts reported on the SEFA are supported by transaction level detail. Views of Responsible Officials – The School System does not concur with the auditor’s findings and recommendations. The total expenditures for all federal programs recorded in the Schedule of Expenditures for Federal Awards are accurately presented and tie to the general ledger. The payroll sub-ledger is corrected before posting to the general ledger every two weeks. The resulting differences are most often immaterial but can be traced to corrections made by the Accounting Office after payroll is reviewed by the grants Restricted Funds Supervisor to ensure payroll is not posted to expired grants. The planned corrective actions are presented in the School System’s Corrective Action Plan attached as Appendix B to the Single Audit Report. BDO Response – We have reviewed management’s response and our finding remains as indicated, since we could not validate the details of the differences.
Finding Number 2022-008 Prior Year Finding Number N/A Compliance Requirement: Allowable Costs/Costs Principles Program: U.S. Department of Education Title I Grants to Local Educational Agencies ALN #: 84.010 Award #: Various Award Period: Various COVID-19 – Governor’s Emergency Education Relief (GEER) ALN #: 84.425C Award #: Various Award Period: Various COVID-19 – Elementary and Secondary School Emergency Relief (ESSR) Fund ALN #: 84.425D Award #: Various Award Period: Various COVID-19 – American Rescue Plan - Elementary and Secondary School Emergency Relief (ARP ESSR) ALN #: 84.425U Award #: 211941 Award Period: 03/24/2021 – 09/30/2023 COVID-19 – American Rescue Plan - Elementary and Secondary School Emergency Relief – Homeless Children and Youth ALN #: 84.425W Award #: Various Award Period: Various Criteria – In accordance with §200.302 Financial Management, a non-federal entity's financial management systems, including records documenting compliance with federal statutes, regulations, and the terms and conditions of the federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the federal statutes, regulations, and the terms and conditions of the federal award. The financial management system of each non-federal entity must provide for the following: 1. Identification, in its accounts, of all federal awards received and expended and the federal programs under which they were received. 2. Accurate, current, and complete disclosure of the financial results of each federal award or program in accordance with the reporting requirements set forth in §200.327 Financial Reporting and §200.328 Monitoring and Reporting Program Performance. 3. Records that identify adequately the source and application of funds for federally funded activities. 4. Effective control over, and accountability for, all funds, property, and other assets. The Uniform Guidance in 2 CFR Section 200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Further, CFR Section 200.510 (b) requires the auditee must also prepare a Schedule of Expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR section 200.502, Basis for determining Federal awards expended. Condition – The amounts recorded in the Schedule of Expenditures of Federal Awards (SEFA) agree to the total amount recorded in the general ledger. The summary level payroll transactions recorded in the general ledger could not be reconciled to the transaction level detail provided from the payroll system. When comparing the two populations, we identified the following differences: • ALN 84.425 - For ALN 84.425 sub-program D, we noted a variance of $1,828,609. Total payroll expenditures per the payroll system details amounted to $18,437,724 whereas payroll expenditures per SEFA amounted to $16,609,116. In addition to the above, for ALN 84.425 sub-program U, we noted a variance of $301,432. Total payroll expenditures per the payroll system details amounted to $3,607,738 whereas payroll expenditures per the SEFA amounted to $3,909,170. • ALN 84.010 - We noted a variance of $752,503. Total payroll expenditures per the payroll system details amounted to $40,549,584 whereas payroll expenditures per the SEFA amounted to $39,797,081. Questioned Costs – Not Determinable. Context – This is a condition identified per review of the School System’s population completeness over the compliance requirements for each program. The prevalence of these findings is detailed in the condition section above. Effect – The SEFA may not be completely and accurately stated. In addition, the lack of established internal controls policies and procedures to ensure the SEFA is completely and accurately stated can lead to noncompliance with federal statutes, regulations, and provisions of grant agreements. Cause – The School System did not adhere to their internal policies and procedures to ensure the accuracy of the SEFA. Recommendation – We recommend that the School System develop policies and procedures and enhance their existing reconciliation process to ensure the completeness and accuracy of the SEFA, and that amounts reported on the SEFA are supported by transaction level detail. Views of Responsible Officials – The School System does not concur with the auditor’s findings and recommendations. The total expenditures for all federal programs recorded in the Schedule of Expenditures for Federal Awards are accurately presented and tie to the general ledger. The payroll sub-ledger is corrected before posting to the general ledger every two weeks. The resulting differences are most often immaterial but can be traced to corrections made by the Accounting Office after payroll is reviewed by the grants Restricted Funds Supervisor to ensure payroll is not posted to expired grants. The planned corrective actions are presented in the School System’s Corrective Action Plan attached as Appendix B to the Single Audit Report. BDO Response – We have reviewed management’s response and our finding remains as indicated, since we could not validate the details of the differences.
Condition and context ? The reports for the quarter ended December 31, 2021, for the Coronavirus State and Local Fiscal Recovery Funds and the Health Center Program Cluster, and the report for the quarter ended September 30, 2021 for the Emergency Rental Assistance Program were issued a day after the deadline. In addition, for one of three programmatic reports tested for the Emergency Rental Assistance Program, the report showed the number of participating households and funds paid at zero for each when it should have been 512 households and $646,914 paid, respectively.Effect ? The effect of the reporting delays and incorrect information is that funding agencies are receiving incorrect or untimely information.Cause ? The cause is insufficient monitoring of reporting deadlines and inadequate review process of reports prior to their submittal.Criteria ? Federal regulations (2 CFR ?200.327) and the terms of the federal grants and contracts require that financial reports be filed in a timely manner and be supported by accurate documentation.Recommendation ? We recommend that the County improve controls over grant reporting that includes a process for identifying reporting requirements and monitoring the timely grant reporting. The system of control should include evaluating and documenting the reporting requirements of each grant and, assignment of both the employees responsible for preparation of the grant reports and a secondary employee assignment for overall monitoring of the timeliness of all grant reports.
Condition and context ? The reports for the quarter ended December 31, 2021, for the Coronavirus State and Local Fiscal Recovery Funds and the Health Center Program Cluster, and the report for the quarter ended September 30, 2021 for the Emergency Rental Assistance Program were issued a day after the deadline. In addition, for one of three programmatic reports tested for the Emergency Rental Assistance Program, the report showed the number of participating households and funds paid at zero for each when it should have been 512 households and $646,914 paid, respectively.Effect ? The effect of the reporting delays and incorrect information is that funding agencies are receiving incorrect or untimely information.Cause ? The cause is insufficient monitoring of reporting deadlines and inadequate review process of reports prior to their submittal.Criteria ? Federal regulations (2 CFR ?200.327) and the terms of the federal grants and contracts require that financial reports be filed in a timely manner and be supported by accurate documentation.Recommendation ? We recommend that the County improve controls over grant reporting that includes a process for identifying reporting requirements and monitoring the timely grant reporting. The system of control should include evaluating and documenting the reporting requirements of each grant and, assignment of both the employees responsible for preparation of the grant reports and a secondary employee assignment for overall monitoring of the timeliness of all grant reports.
Condition and context ? The reports for the quarter ended December 31, 2021, for the Coronavirus State and Local Fiscal Recovery Funds and the Health Center Program Cluster, and the report for the quarter ended September 30, 2021 for the Emergency Rental Assistance Program were issued a day after the deadline. In addition, for one of three programmatic reports tested for the Emergency Rental Assistance Program, the report showed the number of participating households and funds paid at zero for each when it should have been 512 households and $646,914 paid, respectively.Effect ? The effect of the reporting delays and incorrect information is that funding agencies are receiving incorrect or untimely information.Cause ? The cause is insufficient monitoring of reporting deadlines and inadequate review process of reports prior to their submittal.Criteria ? Federal regulations (2 CFR ?200.327) and the terms of the federal grants and contracts require that financial reports be filed in a timely manner and be supported by accurate documentation.Recommendation ? We recommend that the County improve controls over grant reporting that includes a process for identifying reporting requirements and monitoring the timely grant reporting. The system of control should include evaluating and documenting the reporting requirements of each grant and, assignment of both the employees responsible for preparation of the grant reports and a secondary employee assignment for overall monitoring of the timeliness of all grant reports.
Condition and context ? The reports for the quarter ended December 31, 2021, for the Coronavirus State and Local Fiscal Recovery Funds and the Health Center Program Cluster, and the report for the quarter ended September 30, 2021 for the Emergency Rental Assistance Program were issued a day after the deadline. In addition, for one of three programmatic reports tested for the Emergency Rental Assistance Program, the report showed the number of participating households and funds paid at zero for each when it should have been 512 households and $646,914 paid, respectively.Effect ? The effect of the reporting delays and incorrect information is that funding agencies are receiving incorrect or untimely information.Cause ? The cause is insufficient monitoring of reporting deadlines and inadequate review process of reports prior to their submittal.Criteria ? Federal regulations (2 CFR ?200.327) and the terms of the federal grants and contracts require that financial reports be filed in a timely manner and be supported by accurate documentation.Recommendation ? We recommend that the County improve controls over grant reporting that includes a process for identifying reporting requirements and monitoring the timely grant reporting. The system of control should include evaluating and documenting the reporting requirements of each grant and, assignment of both the employees responsible for preparation of the grant reports and a secondary employee assignment for overall monitoring of the timeliness of all grant reports.
Condition and context ? The reports for the quarter ended December 31, 2021, for the Coronavirus State and Local Fiscal Recovery Funds and the Health Center Program Cluster, and the report for the quarter ended September 30, 2021 for the Emergency Rental Assistance Program were issued a day after the deadline. In addition, for one of three programmatic reports tested for the Emergency Rental Assistance Program, the report showed the number of participating households and funds paid at zero for each when it should have been 512 households and $646,914 paid, respectively.Effect ? The effect of the reporting delays and incorrect information is that funding agencies are receiving incorrect or untimely information.Cause ? The cause is insufficient monitoring of reporting deadlines and inadequate review process of reports prior to their submittal.Criteria ? Federal regulations (2 CFR ?200.327) and the terms of the federal grants and contracts require that financial reports be filed in a timely manner and be supported by accurate documentation.Recommendation ? We recommend that the County improve controls over grant reporting that includes a process for identifying reporting requirements and monitoring the timely grant reporting. The system of control should include evaluating and documenting the reporting requirements of each grant and, assignment of both the employees responsible for preparation of the grant reports and a secondary employee assignment for overall monitoring of the timeliness of all grant reports.
Condition and context ? The reports for the quarter ended December 31, 2021, for the Coronavirus State and Local Fiscal Recovery Funds and the Health Center Program Cluster, and the report for the quarter ended September 30, 2021 for the Emergency Rental Assistance Program were issued a day after the deadline. In addition, for one of three programmatic reports tested for the Emergency Rental Assistance Program, the report showed the number of participating households and funds paid at zero for each when it should have been 512 households and $646,914 paid, respectively.Effect ? The effect of the reporting delays and incorrect information is that funding agencies are receiving incorrect or untimely information.Cause ? The cause is insufficient monitoring of reporting deadlines and inadequate review process of reports prior to their submittal.Criteria ? Federal regulations (2 CFR ?200.327) and the terms of the federal grants and contracts require that financial reports be filed in a timely manner and be supported by accurate documentation.Recommendation ? We recommend that the County improve controls over grant reporting that includes a process for identifying reporting requirements and monitoring the timely grant reporting. The system of control should include evaluating and documenting the reporting requirements of each grant and, assignment of both the employees responsible for preparation of the grant reports and a secondary employee assignment for overall monitoring of the timeliness of all grant reports.
Suspension and Debarment Not Verified Prior to Awarding Contracts(Governor?s Office of Planning and Budget)Federal Agency: Department of the TreasuryAssistance Listing Number and Title: 21.027 Coronavirus State & Local Fiscal Recovery FundsFederal Award Number: N/AQuestioned Costs: $0Pass-through Entity: N/APrior Year Single Audit Report Finding Number: 2021-022We identified 26 of 42 contract agreements sampled (61.9 percent error) where, under GOPB?s oversight, the state agency awarded SLFRF without verifying the entity was not suspended or debarred. These state agencies did not include a suspension and debarment clause in the contract with the entity as required by 2 CFR 200.327 or through a search of the suspension and debarment list on sam.gov: (See the Schedule of Findings and Questioned Costs for the table)2 CFR part 200.303 requires non-federal entities to ?establish and maintain effective internal control?that provides reasonable assurance that the non-federal entity [manages the program] in compliance with?terms and conditions of the federal award.? At the time of the award, GOPB did not provide guidance to these agencies that were inexperienced with federal programs to be aware of the extent that the suspension and debarment requirements were applicable. Although our procedures did not detect noncompliance, failure to properly implement controls and appropriately review each contracted party for suspension and debarment could result in federally suspended or debarred entities receiving federal funds.Recommendation:We recommend GOPB assist agencies to gain an understanding of the suspension and debarment requirements and establish internal controls to ensure compliance with these requirements.GOPB?s Response:GOPB agrees with this finding. In September 2022, GOPB distributed an ARPA Agency Checklist to remind those managing SLFR funds of compliance, monitoring, and reporting requirements, which included the requirement of monitoring for suspension and debarment. This checklist tool was not consistently used. A retroactive check was performed and no entities receiving federal funds had been suspended or debarred.
Suspension and Debarment Not Verified Prior to Awarding Contracts(Governor?s Office of Planning and Budget)Federal Agency: Department of the TreasuryAssistance Listing Number and Title: 21.027 Coronavirus State & Local Fiscal Recovery FundsFederal Award Number: N/AQuestioned Costs: $0Pass-through Entity: N/APrior Year Single Audit Report Finding Number: 2021-022We identified 26 of 42 contract agreements sampled (61.9 percent error) where, under GOPB?s oversight, the state agency awarded SLFRF without verifying the entity was not suspended or debarred. These state agencies did not include a suspension and debarment clause in the contract with the entity as required by 2 CFR 200.327 or through a search of the suspension and debarment list on sam.gov: (See the Schedule of Findings and Questioned Costs for the table)2 CFR part 200.303 requires non-federal entities to ?establish and maintain effective internal control?that provides reasonable assurance that the non-federal entity [manages the program] in compliance with?terms and conditions of the federal award.? At the time of the award, GOPB did not provide guidance to these agencies that were inexperienced with federal programs to be aware of the extent that the suspension and debarment requirements were applicable. Although our procedures did not detect noncompliance, failure to properly implement controls and appropriately review each contracted party for suspension and debarment could result in federally suspended or debarred entities receiving federal funds.Recommendation:We recommend GOPB assist agencies to gain an understanding of the suspension and debarment requirements and establish internal controls to ensure compliance with these requirements.GOPB?s Response:GOPB agrees with this finding. In September 2022, GOPB distributed an ARPA Agency Checklist to remind those managing SLFR funds of compliance, monitoring, and reporting requirements, which included the requirement of monitoring for suspension and debarment. This checklist tool was not consistently used. A retroactive check was performed and no entities receiving federal funds had been suspended or debarred.
Suspension and Debarment Not Verified Prior to Awarding Contracts(Governor?s Office of Planning and Budget)Federal Agency: Department of the TreasuryAssistance Listing Number and Title: 21.027 Coronavirus State & Local Fiscal Recovery FundsFederal Award Number: N/AQuestioned Costs: $0Pass-through Entity: N/APrior Year Single Audit Report Finding Number: 2021-022We identified 26 of 42 contract agreements sampled (61.9 percent error) where, under GOPB?s oversight, the state agency awarded SLFRF without verifying the entity was not suspended or debarred. These state agencies did not include a suspension and debarment clause in the contract with the entity as required by 2 CFR 200.327 or through a search of the suspension and debarment list on sam.gov: (See the Schedule of Findings and Questioned Costs for the table)2 CFR part 200.303 requires non-federal entities to ?establish and maintain effective internal control?that provides reasonable assurance that the non-federal entity [manages the program] in compliance with?terms and conditions of the federal award.? At the time of the award, GOPB did not provide guidance to these agencies that were inexperienced with federal programs to be aware of the extent that the suspension and debarment requirements were applicable. Although our procedures did not detect noncompliance, failure to properly implement controls and appropriately review each contracted party for suspension and debarment could result in federally suspended or debarred entities receiving federal funds.Recommendation:We recommend GOPB assist agencies to gain an understanding of the suspension and debarment requirements and establish internal controls to ensure compliance with these requirements.GOPB?s Response:GOPB agrees with this finding. In September 2022, GOPB distributed an ARPA Agency Checklist to remind those managing SLFR funds of compliance, monitoring, and reporting requirements, which included the requirement of monitoring for suspension and debarment. This checklist tool was not consistently used. A retroactive check was performed and no entities receiving federal funds had been suspended or debarred.
Suspension and Debarment Not Verified Prior to Awarding Contracts(Governor?s Office of Planning and Budget)Federal Agency: Department of the TreasuryAssistance Listing Number and Title: 21.027 Coronavirus State & Local Fiscal Recovery FundsFederal Award Number: N/AQuestioned Costs: $0Pass-through Entity: N/APrior Year Single Audit Report Finding Number: 2021-022We identified 26 of 42 contract agreements sampled (61.9 percent error) where, under GOPB?s oversight, the state agency awarded SLFRF without verifying the entity was not suspended or debarred. These state agencies did not include a suspension and debarment clause in the contract with the entity as required by 2 CFR 200.327 or through a search of the suspension and debarment list on sam.gov: (See the Schedule of Findings and Questioned Costs for the table)2 CFR part 200.303 requires non-federal entities to ?establish and maintain effective internal control?that provides reasonable assurance that the non-federal entity [manages the program] in compliance with?terms and conditions of the federal award.? At the time of the award, GOPB did not provide guidance to these agencies that were inexperienced with federal programs to be aware of the extent that the suspension and debarment requirements were applicable. Although our procedures did not detect noncompliance, failure to properly implement controls and appropriately review each contracted party for suspension and debarment could result in federally suspended or debarred entities receiving federal funds.Recommendation:We recommend GOPB assist agencies to gain an understanding of the suspension and debarment requirements and establish internal controls to ensure compliance with these requirements.GOPB?s Response:GOPB agrees with this finding. In September 2022, GOPB distributed an ARPA Agency Checklist to remind those managing SLFR funds of compliance, monitoring, and reporting requirements, which included the requirement of monitoring for suspension and debarment. This checklist tool was not consistently used. A retroactive check was performed and no entities receiving federal funds had been suspended or debarred.
Suspension and Debarment Not Verified Prior to Awarding Contracts(Governor?s Office of Planning and Budget)Federal Agency: Department of the TreasuryAssistance Listing Number and Title: 21.027 Coronavirus State & Local Fiscal Recovery FundsFederal Award Number: N/AQuestioned Costs: $0Pass-through Entity: N/APrior Year Single Audit Report Finding Number: 2021-022We identified 26 of 42 contract agreements sampled (61.9 percent error) where, under GOPB?s oversight, the state agency awarded SLFRF without verifying the entity was not suspended or debarred. These state agencies did not include a suspension and debarment clause in the contract with the entity as required by 2 CFR 200.327 or through a search of the suspension and debarment list on sam.gov: (See the Schedule of Findings and Questioned Costs for the table)2 CFR part 200.303 requires non-federal entities to ?establish and maintain effective internal control?that provides reasonable assurance that the non-federal entity [manages the program] in compliance with?terms and conditions of the federal award.? At the time of the award, GOPB did not provide guidance to these agencies that were inexperienced with federal programs to be aware of the extent that the suspension and debarment requirements were applicable. Although our procedures did not detect noncompliance, failure to properly implement controls and appropriately review each contracted party for suspension and debarment could result in federally suspended or debarred entities receiving federal funds.Recommendation:We recommend GOPB assist agencies to gain an understanding of the suspension and debarment requirements and establish internal controls to ensure compliance with these requirements.GOPB?s Response:GOPB agrees with this finding. In September 2022, GOPB distributed an ARPA Agency Checklist to remind those managing SLFR funds of compliance, monitoring, and reporting requirements, which included the requirement of monitoring for suspension and debarment. This checklist tool was not consistently used. A retroactive check was performed and no entities receiving federal funds had been suspended or debarred.
Suspension and Debarment Not Verified Prior to Awarding Contracts(Governor?s Office of Planning and Budget)Federal Agency: Department of the TreasuryAssistance Listing Number and Title: 21.027 Coronavirus State & Local Fiscal Recovery FundsFederal Award Number: N/AQuestioned Costs: $0Pass-through Entity: N/APrior Year Single Audit Report Finding Number: 2021-022We identified 26 of 42 contract agreements sampled (61.9 percent error) where, under GOPB?s oversight, the state agency awarded SLFRF without verifying the entity was not suspended or debarred. These state agencies did not include a suspension and debarment clause in the contract with the entity as required by 2 CFR 200.327 or through a search of the suspension and debarment list on sam.gov: (See the Schedule of Findings and Questioned Costs for the table)2 CFR part 200.303 requires non-federal entities to ?establish and maintain effective internal control?that provides reasonable assurance that the non-federal entity [manages the program] in compliance with?terms and conditions of the federal award.? At the time of the award, GOPB did not provide guidance to these agencies that were inexperienced with federal programs to be aware of the extent that the suspension and debarment requirements were applicable. Although our procedures did not detect noncompliance, failure to properly implement controls and appropriately review each contracted party for suspension and debarment could result in federally suspended or debarred entities receiving federal funds.Recommendation:We recommend GOPB assist agencies to gain an understanding of the suspension and debarment requirements and establish internal controls to ensure compliance with these requirements.GOPB?s Response:GOPB agrees with this finding. In September 2022, GOPB distributed an ARPA Agency Checklist to remind those managing SLFR funds of compliance, monitoring, and reporting requirements, which included the requirement of monitoring for suspension and debarment. This checklist tool was not consistently used. A retroactive check was performed and no entities receiving federal funds had been suspended or debarred.
Suspension and Debarment Not Verified Prior to Awarding Contracts(Governor?s Office of Planning and Budget)Federal Agency: Department of the TreasuryAssistance Listing Number and Title: 21.027 Coronavirus State & Local Fiscal Recovery FundsFederal Award Number: N/AQuestioned Costs: $0Pass-through Entity: N/APrior Year Single Audit Report Finding Number: 2021-022We identified 26 of 42 contract agreements sampled (61.9 percent error) where, under GOPB?s oversight, the state agency awarded SLFRF without verifying the entity was not suspended or debarred. These state agencies did not include a suspension and debarment clause in the contract with the entity as required by 2 CFR 200.327 or through a search of the suspension and debarment list on sam.gov: (See the Schedule of Findings and Questioned Costs for the table)2 CFR part 200.303 requires non-federal entities to ?establish and maintain effective internal control?that provides reasonable assurance that the non-federal entity [manages the program] in compliance with?terms and conditions of the federal award.? At the time of the award, GOPB did not provide guidance to these agencies that were inexperienced with federal programs to be aware of the extent that the suspension and debarment requirements were applicable. Although our procedures did not detect noncompliance, failure to properly implement controls and appropriately review each contracted party for suspension and debarment could result in federally suspended or debarred entities receiving federal funds.Recommendation:We recommend GOPB assist agencies to gain an understanding of the suspension and debarment requirements and establish internal controls to ensure compliance with these requirements.GOPB?s Response:GOPB agrees with this finding. In September 2022, GOPB distributed an ARPA Agency Checklist to remind those managing SLFR funds of compliance, monitoring, and reporting requirements, which included the requirement of monitoring for suspension and debarment. This checklist tool was not consistently used. A retroactive check was performed and no entities receiving federal funds had been suspended or debarred.
Suspension and Debarment Not Verified Prior to Awarding Contracts(Governor?s Office of Planning and Budget)Federal Agency: Department of the TreasuryAssistance Listing Number and Title: 21.027 Coronavirus State & Local Fiscal Recovery FundsFederal Award Number: N/AQuestioned Costs: $0Pass-through Entity: N/APrior Year Single Audit Report Finding Number: 2021-022We identified 26 of 42 contract agreements sampled (61.9 percent error) where, under GOPB?s oversight, the state agency awarded SLFRF without verifying the entity was not suspended or debarred. These state agencies did not include a suspension and debarment clause in the contract with the entity as required by 2 CFR 200.327 or through a search of the suspension and debarment list on sam.gov: (See the Schedule of Findings and Questioned Costs for the table)2 CFR part 200.303 requires non-federal entities to ?establish and maintain effective internal control?that provides reasonable assurance that the non-federal entity [manages the program] in compliance with?terms and conditions of the federal award.? At the time of the award, GOPB did not provide guidance to these agencies that were inexperienced with federal programs to be aware of the extent that the suspension and debarment requirements were applicable. Although our procedures did not detect noncompliance, failure to properly implement controls and appropriately review each contracted party for suspension and debarment could result in federally suspended or debarred entities receiving federal funds.Recommendation:We recommend GOPB assist agencies to gain an understanding of the suspension and debarment requirements and establish internal controls to ensure compliance with these requirements.GOPB?s Response:GOPB agrees with this finding. In September 2022, GOPB distributed an ARPA Agency Checklist to remind those managing SLFR funds of compliance, monitoring, and reporting requirements, which included the requirement of monitoring for suspension and debarment. This checklist tool was not consistently used. A retroactive check was performed and no entities receiving federal funds had been suspended or debarred.
Suspension and Debarment Not Verified Prior to Awarding Contracts(Governor?s Office of Planning and Budget)Federal Agency: Department of the TreasuryAssistance Listing Number and Title: 21.027 Coronavirus State & Local Fiscal Recovery FundsFederal Award Number: N/AQuestioned Costs: $0Pass-through Entity: N/APrior Year Single Audit Report Finding Number: 2021-022We identified 26 of 42 contract agreements sampled (61.9 percent error) where, under GOPB?s oversight, the state agency awarded SLFRF without verifying the entity was not suspended or debarred. These state agencies did not include a suspension and debarment clause in the contract with the entity as required by 2 CFR 200.327 or through a search of the suspension and debarment list on sam.gov: (See the Schedule of Findings and Questioned Costs for the table)2 CFR part 200.303 requires non-federal entities to ?establish and maintain effective internal control?that provides reasonable assurance that the non-federal entity [manages the program] in compliance with?terms and conditions of the federal award.? At the time of the award, GOPB did not provide guidance to these agencies that were inexperienced with federal programs to be aware of the extent that the suspension and debarment requirements were applicable. Although our procedures did not detect noncompliance, failure to properly implement controls and appropriately review each contracted party for suspension and debarment could result in federally suspended or debarred entities receiving federal funds.Recommendation:We recommend GOPB assist agencies to gain an understanding of the suspension and debarment requirements and establish internal controls to ensure compliance with these requirements.GOPB?s Response:GOPB agrees with this finding. In September 2022, GOPB distributed an ARPA Agency Checklist to remind those managing SLFR funds of compliance, monitoring, and reporting requirements, which included the requirement of monitoring for suspension and debarment. This checklist tool was not consistently used. A retroactive check was performed and no entities receiving federal funds had been suspended or debarred.
Suspension and Debarment Not Verified Prior to Awarding Contracts(Governor?s Office of Planning and Budget)Federal Agency: Department of the TreasuryAssistance Listing Number and Title: 21.027 Coronavirus State & Local Fiscal Recovery FundsFederal Award Number: N/AQuestioned Costs: $0Pass-through Entity: N/APrior Year Single Audit Report Finding Number: 2021-022We identified 26 of 42 contract agreements sampled (61.9 percent error) where, under GOPB?s oversight, the state agency awarded SLFRF without verifying the entity was not suspended or debarred. These state agencies did not include a suspension and debarment clause in the contract with the entity as required by 2 CFR 200.327 or through a search of the suspension and debarment list on sam.gov: (See the Schedule of Findings and Questioned Costs for the table)2 CFR part 200.303 requires non-federal entities to ?establish and maintain effective internal control?that provides reasonable assurance that the non-federal entity [manages the program] in compliance with?terms and conditions of the federal award.? At the time of the award, GOPB did not provide guidance to these agencies that were inexperienced with federal programs to be aware of the extent that the suspension and debarment requirements were applicable. Although our procedures did not detect noncompliance, failure to properly implement controls and appropriately review each contracted party for suspension and debarment could result in federally suspended or debarred entities receiving federal funds.Recommendation:We recommend GOPB assist agencies to gain an understanding of the suspension and debarment requirements and establish internal controls to ensure compliance with these requirements.GOPB?s Response:GOPB agrees with this finding. In September 2022, GOPB distributed an ARPA Agency Checklist to remind those managing SLFR funds of compliance, monitoring, and reporting requirements, which included the requirement of monitoring for suspension and debarment. This checklist tool was not consistently used. A retroactive check was performed and no entities receiving federal funds had been suspended or debarred.
Suspension and Debarment Not Verified Prior to Awarding Contracts(Governor?s Office of Planning and Budget)Federal Agency: Department of the TreasuryAssistance Listing Number and Title: 21.027 Coronavirus State & Local Fiscal Recovery FundsFederal Award Number: N/AQuestioned Costs: $0Pass-through Entity: N/APrior Year Single Audit Report Finding Number: 2021-022We identified 26 of 42 contract agreements sampled (61.9 percent error) where, under GOPB?s oversight, the state agency awarded SLFRF without verifying the entity was not suspended or debarred. These state agencies did not include a suspension and debarment clause in the contract with the entity as required by 2 CFR 200.327 or through a search of the suspension and debarment list on sam.gov: (See the Schedule of Findings and Questioned Costs for the table)2 CFR part 200.303 requires non-federal entities to ?establish and maintain effective internal control?that provides reasonable assurance that the non-federal entity [manages the program] in compliance with?terms and conditions of the federal award.? At the time of the award, GOPB did not provide guidance to these agencies that were inexperienced with federal programs to be aware of the extent that the suspension and debarment requirements were applicable. Although our procedures did not detect noncompliance, failure to properly implement controls and appropriately review each contracted party for suspension and debarment could result in federally suspended or debarred entities receiving federal funds.Recommendation:We recommend GOPB assist agencies to gain an understanding of the suspension and debarment requirements and establish internal controls to ensure compliance with these requirements.GOPB?s Response:GOPB agrees with this finding. In September 2022, GOPB distributed an ARPA Agency Checklist to remind those managing SLFR funds of compliance, monitoring, and reporting requirements, which included the requirement of monitoring for suspension and debarment. This checklist tool was not consistently used. A retroactive check was performed and no entities receiving federal funds had been suspended or debarred.
Suspension and Debarment Not Verified Prior to Awarding Contracts(Governor?s Office of Planning and Budget)Federal Agency: Department of the TreasuryAssistance Listing Number and Title: 21.027 Coronavirus State & Local Fiscal Recovery FundsFederal Award Number: N/AQuestioned Costs: $0Pass-through Entity: N/APrior Year Single Audit Report Finding Number: 2021-022We identified 26 of 42 contract agreements sampled (61.9 percent error) where, under GOPB?s oversight, the state agency awarded SLFRF without verifying the entity was not suspended or debarred. These state agencies did not include a suspension and debarment clause in the contract with the entity as required by 2 CFR 200.327 or through a search of the suspension and debarment list on sam.gov: (See the Schedule of Findings and Questioned Costs for the table)2 CFR part 200.303 requires non-federal entities to ?establish and maintain effective internal control?that provides reasonable assurance that the non-federal entity [manages the program] in compliance with?terms and conditions of the federal award.? At the time of the award, GOPB did not provide guidance to these agencies that were inexperienced with federal programs to be aware of the extent that the suspension and debarment requirements were applicable. Although our procedures did not detect noncompliance, failure to properly implement controls and appropriately review each contracted party for suspension and debarment could result in federally suspended or debarred entities receiving federal funds.Recommendation:We recommend GOPB assist agencies to gain an understanding of the suspension and debarment requirements and establish internal controls to ensure compliance with these requirements.GOPB?s Response:GOPB agrees with this finding. In September 2022, GOPB distributed an ARPA Agency Checklist to remind those managing SLFR funds of compliance, monitoring, and reporting requirements, which included the requirement of monitoring for suspension and debarment. This checklist tool was not consistently used. A retroactive check was performed and no entities receiving federal funds had been suspended or debarred.
Suspension and Debarment Not Verified Prior to Awarding Contracts(Governor?s Office of Planning and Budget)Federal Agency: Department of the TreasuryAssistance Listing Number and Title: 21.027 Coronavirus State & Local Fiscal Recovery FundsFederal Award Number: N/AQuestioned Costs: $0Pass-through Entity: N/APrior Year Single Audit Report Finding Number: 2021-022We identified 26 of 42 contract agreements sampled (61.9 percent error) where, under GOPB?s oversight, the state agency awarded SLFRF without verifying the entity was not suspended or debarred. These state agencies did not include a suspension and debarment clause in the contract with the entity as required by 2 CFR 200.327 or through a search of the suspension and debarment list on sam.gov: (See the Schedule of Findings and Questioned Costs for the table)2 CFR part 200.303 requires non-federal entities to ?establish and maintain effective internal control?that provides reasonable assurance that the non-federal entity [manages the program] in compliance with?terms and conditions of the federal award.? At the time of the award, GOPB did not provide guidance to these agencies that were inexperienced with federal programs to be aware of the extent that the suspension and debarment requirements were applicable. Although our procedures did not detect noncompliance, failure to properly implement controls and appropriately review each contracted party for suspension and debarment could result in federally suspended or debarred entities receiving federal funds.Recommendation:We recommend GOPB assist agencies to gain an understanding of the suspension and debarment requirements and establish internal controls to ensure compliance with these requirements.GOPB?s Response:GOPB agrees with this finding. In September 2022, GOPB distributed an ARPA Agency Checklist to remind those managing SLFR funds of compliance, monitoring, and reporting requirements, which included the requirement of monitoring for suspension and debarment. This checklist tool was not consistently used. A retroactive check was performed and no entities receiving federal funds had been suspended or debarred.
Suspension and Debarment Not Verified Prior to Awarding Contracts(Governor?s Office of Planning and Budget)Federal Agency: Department of the TreasuryAssistance Listing Number and Title: 21.027 Coronavirus State & Local Fiscal Recovery FundsFederal Award Number: N/AQuestioned Costs: $0Pass-through Entity: N/APrior Year Single Audit Report Finding Number: 2021-022We identified 26 of 42 contract agreements sampled (61.9 percent error) where, under GOPB?s oversight, the state agency awarded SLFRF without verifying the entity was not suspended or debarred. These state agencies did not include a suspension and debarment clause in the contract with the entity as required by 2 CFR 200.327 or through a search of the suspension and debarment list on sam.gov: (See the Schedule of Findings and Questioned Costs for the table)2 CFR part 200.303 requires non-federal entities to ?establish and maintain effective internal control?that provides reasonable assurance that the non-federal entity [manages the program] in compliance with?terms and conditions of the federal award.? At the time of the award, GOPB did not provide guidance to these agencies that were inexperienced with federal programs to be aware of the extent that the suspension and debarment requirements were applicable. Although our procedures did not detect noncompliance, failure to properly implement controls and appropriately review each contracted party for suspension and debarment could result in federally suspended or debarred entities receiving federal funds.Recommendation:We recommend GOPB assist agencies to gain an understanding of the suspension and debarment requirements and establish internal controls to ensure compliance with these requirements.GOPB?s Response:GOPB agrees with this finding. In September 2022, GOPB distributed an ARPA Agency Checklist to remind those managing SLFR funds of compliance, monitoring, and reporting requirements, which included the requirement of monitoring for suspension and debarment. This checklist tool was not consistently used. A retroactive check was performed and no entities receiving federal funds had been suspended or debarred.
Suspension and Debarment Not Verified Prior to Awarding Contracts(Governor?s Office of Planning and Budget)Federal Agency: Department of the TreasuryAssistance Listing Number and Title: 21.027 Coronavirus State & Local Fiscal Recovery FundsFederal Award Number: N/AQuestioned Costs: $0Pass-through Entity: N/APrior Year Single Audit Report Finding Number: 2021-022We identified 26 of 42 contract agreements sampled (61.9 percent error) where, under GOPB?s oversight, the state agency awarded SLFRF without verifying the entity was not suspended or debarred. These state agencies did not include a suspension and debarment clause in the contract with the entity as required by 2 CFR 200.327 or through a search of the suspension and debarment list on sam.gov: (See the Schedule of Findings and Questioned Costs for the table)2 CFR part 200.303 requires non-federal entities to ?establish and maintain effective internal control?that provides reasonable assurance that the non-federal entity [manages the program] in compliance with?terms and conditions of the federal award.? At the time of the award, GOPB did not provide guidance to these agencies that were inexperienced with federal programs to be aware of the extent that the suspension and debarment requirements were applicable. Although our procedures did not detect noncompliance, failure to properly implement controls and appropriately review each contracted party for suspension and debarment could result in federally suspended or debarred entities receiving federal funds.Recommendation:We recommend GOPB assist agencies to gain an understanding of the suspension and debarment requirements and establish internal controls to ensure compliance with these requirements.GOPB?s Response:GOPB agrees with this finding. In September 2022, GOPB distributed an ARPA Agency Checklist to remind those managing SLFR funds of compliance, monitoring, and reporting requirements, which included the requirement of monitoring for suspension and debarment. This checklist tool was not consistently used. A retroactive check was performed and no entities receiving federal funds had been suspended or debarred.
Suspension and Debarment Not Verified Prior to Awarding Contracts(Governor?s Office of Planning and Budget)Federal Agency: Department of the TreasuryAssistance Listing Number and Title: 21.027 Coronavirus State & Local Fiscal Recovery FundsFederal Award Number: N/AQuestioned Costs: $0Pass-through Entity: N/APrior Year Single Audit Report Finding Number: 2021-022We identified 26 of 42 contract agreements sampled (61.9 percent error) where, under GOPB?s oversight, the state agency awarded SLFRF without verifying the entity was not suspended or debarred. These state agencies did not include a suspension and debarment clause in the contract with the entity as required by 2 CFR 200.327 or through a search of the suspension and debarment list on sam.gov: (See the Schedule of Findings and Questioned Costs for the table)2 CFR part 200.303 requires non-federal entities to ?establish and maintain effective internal control?that provides reasonable assurance that the non-federal entity [manages the program] in compliance with?terms and conditions of the federal award.? At the time of the award, GOPB did not provide guidance to these agencies that were inexperienced with federal programs to be aware of the extent that the suspension and debarment requirements were applicable. Although our procedures did not detect noncompliance, failure to properly implement controls and appropriately review each contracted party for suspension and debarment could result in federally suspended or debarred entities receiving federal funds.Recommendation:We recommend GOPB assist agencies to gain an understanding of the suspension and debarment requirements and establish internal controls to ensure compliance with these requirements.GOPB?s Response:GOPB agrees with this finding. In September 2022, GOPB distributed an ARPA Agency Checklist to remind those managing SLFR funds of compliance, monitoring, and reporting requirements, which included the requirement of monitoring for suspension and debarment. This checklist tool was not consistently used. A retroactive check was performed and no entities receiving federal funds had been suspended or debarred.
Suspension and Debarment Not Verified Prior to Awarding Contracts(Governor?s Office of Planning and Budget)Federal Agency: Department of the TreasuryAssistance Listing Number and Title: 21.027 Coronavirus State & Local Fiscal Recovery FundsFederal Award Number: N/AQuestioned Costs: $0Pass-through Entity: N/APrior Year Single Audit Report Finding Number: 2021-022We identified 26 of 42 contract agreements sampled (61.9 percent error) where, under GOPB?s oversight, the state agency awarded SLFRF without verifying the entity was not suspended or debarred. These state agencies did not include a suspension and debarment clause in the contract with the entity as required by 2 CFR 200.327 or through a search of the suspension and debarment list on sam.gov: (See the Schedule of Findings and Questioned Costs for the table)2 CFR part 200.303 requires non-federal entities to ?establish and maintain effective internal control?that provides reasonable assurance that the non-federal entity [manages the program] in compliance with?terms and conditions of the federal award.? At the time of the award, GOPB did not provide guidance to these agencies that were inexperienced with federal programs to be aware of the extent that the suspension and debarment requirements were applicable. Although our procedures did not detect noncompliance, failure to properly implement controls and appropriately review each contracted party for suspension and debarment could result in federally suspended or debarred entities receiving federal funds.Recommendation:We recommend GOPB assist agencies to gain an understanding of the suspension and debarment requirements and establish internal controls to ensure compliance with these requirements.GOPB?s Response:GOPB agrees with this finding. In September 2022, GOPB distributed an ARPA Agency Checklist to remind those managing SLFR funds of compliance, monitoring, and reporting requirements, which included the requirement of monitoring for suspension and debarment. This checklist tool was not consistently used. A retroactive check was performed and no entities receiving federal funds had been suspended or debarred.
Suspension and Debarment Not Verified Prior to Awarding Contracts(Governor?s Office of Planning and Budget)Federal Agency: Department of the TreasuryAssistance Listing Number and Title: 21.027 Coronavirus State & Local Fiscal Recovery FundsFederal Award Number: N/AQuestioned Costs: $0Pass-through Entity: N/APrior Year Single Audit Report Finding Number: 2021-022We identified 26 of 42 contract agreements sampled (61.9 percent error) where, under GOPB?s oversight, the state agency awarded SLFRF without verifying the entity was not suspended or debarred. These state agencies did not include a suspension and debarment clause in the contract with the entity as required by 2 CFR 200.327 or through a search of the suspension and debarment list on sam.gov: (See the Schedule of Findings and Questioned Costs for the table)2 CFR part 200.303 requires non-federal entities to ?establish and maintain effective internal control?that provides reasonable assurance that the non-federal entity [manages the program] in compliance with?terms and conditions of the federal award.? At the time of the award, GOPB did not provide guidance to these agencies that were inexperienced with federal programs to be aware of the extent that the suspension and debarment requirements were applicable. Although our procedures did not detect noncompliance, failure to properly implement controls and appropriately review each contracted party for suspension and debarment could result in federally suspended or debarred entities receiving federal funds.Recommendation:We recommend GOPB assist agencies to gain an understanding of the suspension and debarment requirements and establish internal controls to ensure compliance with these requirements.GOPB?s Response:GOPB agrees with this finding. In September 2022, GOPB distributed an ARPA Agency Checklist to remind those managing SLFR funds of compliance, monitoring, and reporting requirements, which included the requirement of monitoring for suspension and debarment. This checklist tool was not consistently used. A retroactive check was performed and no entities receiving federal funds had been suspended or debarred.
Suspension and Debarment Not Verified Prior to Awarding Contracts(Governor?s Office of Planning and Budget)Federal Agency: Department of the TreasuryAssistance Listing Number and Title: 21.027 Coronavirus State & Local Fiscal Recovery FundsFederal Award Number: N/AQuestioned Costs: $0Pass-through Entity: N/APrior Year Single Audit Report Finding Number: 2021-022We identified 26 of 42 contract agreements sampled (61.9 percent error) where, under GOPB?s oversight, the state agency awarded SLFRF without verifying the entity was not suspended or debarred. These state agencies did not include a suspension and debarment clause in the contract with the entity as required by 2 CFR 200.327 or through a search of the suspension and debarment list on sam.gov: (See the Schedule of Findings and Questioned Costs for the table)2 CFR part 200.303 requires non-federal entities to ?establish and maintain effective internal control?that provides reasonable assurance that the non-federal entity [manages the program] in compliance with?terms and conditions of the federal award.? At the time of the award, GOPB did not provide guidance to these agencies that were inexperienced with federal programs to be aware of the extent that the suspension and debarment requirements were applicable. Although our procedures did not detect noncompliance, failure to properly implement controls and appropriately review each contracted party for suspension and debarment could result in federally suspended or debarred entities receiving federal funds.Recommendation:We recommend GOPB assist agencies to gain an understanding of the suspension and debarment requirements and establish internal controls to ensure compliance with these requirements.GOPB?s Response:GOPB agrees with this finding. In September 2022, GOPB distributed an ARPA Agency Checklist to remind those managing SLFR funds of compliance, monitoring, and reporting requirements, which included the requirement of monitoring for suspension and debarment. This checklist tool was not consistently used. A retroactive check was performed and no entities receiving federal funds had been suspended or debarred.
Criteria: Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) 200.318 General Procurement Standards requires entities to have documented procurement procedures that conform to the procurement standards identified in 2 CFR 200.317 through 200.327. Condition: The City does not have formal documented procurement policies and procedures related to expenditures of federal awards. Cause: The City Council forms a committee to review and approve disbursements of federal funds. This process is the City’s general practice but does not follow written procurement policies and procedures. Effect: The City is out of compliance with general procurement standards under 2 CFR 200.318. Recommendation: The City should adopt formal documented procurement policies and procedures related to expenditures of federal awards. Response: The City Clerk and Mayor, with help from the Treasurer, will develop and implement documented procurement procedures that conform to the procurement standards relating to Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) 200.317 through 200.327.
Criteria: Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) 200.318 General Procurement Standards requires entities to have documented procurement procedures that conform to the procurement standards identified in 2 CFR 200.317 through 200.327. Condition: The City does not have formal documented procurement policies and procedures related to expenditures of federal awards. Cause: The City Council forms a committee to review and approve disbursements of federal funds. This process is the City’s general practice but does not follow written procurement policies and procedures. Effect: The City is out of compliance with general procurement standards under 2 CFR 200.318. Recommendation: The City should adopt formal documented procurement policies and procedures related to expenditures of federal awards. Response: The City Clerk and Mayor, with help from the Treasurer, will develop and implement documented procurement procedures that conform to the procurement standards relating to Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) 200.317 through 200.327.
Criteria: Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) 200.318 General Procurement Standards requires entities to have documented procurement procedures that conform to the procurement standards identified in 2 CFR 200.317 through 200.327. Condition: The City does not have formal documented procurement policies and procedures related to expenditures of federal awards. Cause: The City Council forms a committee to review and approve disbursements of federal funds. This process is the City’s general practice but does not follow written procurement policies and procedures. Effect: The City is out of compliance with general procurement standards under 2 CFR 200.318. Recommendation: The City should adopt formal documented procurement policies and procedures related to expenditures of federal awards. Response: The City Clerk and Mayor, with help from the Treasurer, will develop and implement documented procurement procedures that conform to the procurement standards relating to Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) 200.317 through 200.327.
2022-003 Procurement Policies and Covered Transactions Compliance Requirement Procurement, Suspension, and Debarment Category Significant Deficiency in Internal Control and Noncompliance Federal Agency U.S. Department of the Treasury Pass-Through Entity Puerto Rico Fiscal Agency and Financial Advisory Authority ALN 21.027 Federal Program COVID-19 - Coronavirus State and Local Fiscal Recovery Funds Criteria 2 CFR section 200.318 General procurement standards. (a) The non-Federal entity must have and use documented procurement procedures, consistent with State, local, and tribal laws and regulations and the standards of this section, for the acquisition of property or services required under a Federal award or subaward. The non-Federal entity's documented procurement procedures must conform to the procurement standards identified in §§ 200.317 through 200.327. 2 CFR section 180.220 Are any procurement contracts included as covered transactions? (a) Covered transactions under this part— (1) Do not include any procurement contracts awarded directly by a Federal agency; but (2) Do include some procurement contracts awarded by non-Federal participants in nonprocurement covered transactions. (b) Specifically, a contract for goods or services is a covered transaction if any of the following applies: (1) The contract is awarded by a participant in a nonprocurement transaction that is covered under § 180.210, and the amount of the contract is expected to equal or exceed $25,000. (2) The contract requires the consent of an official of a Federal agency. In that case, the contract, regardless of the amount, always is a covered transaction, and it does not matter who awarded it. For example, it could be a subcontract awarded by a contractor at a tier below a nonprocurement transaction, as shown in the appendix to this part. (3) The contract is for Federally-required audit services. (c) A subcontract also is a covered transaction if,— (1) It is awarded by a participant in a procurement transaction under a nonprocurement transaction of a Federal agency that extends the coverage of paragraph (b)(1) of this section to additional tiers of contracts (see the diagram in the appendix to this part showing that optional lower tier coverage); and (2) The value of the subcontract is expected to equal or exceed $25,000. Condition General Procurement Standards - Written Policies The Corporation has an outdated institutional procurement manual approved in 2014 that lacks written policies to ascertain compliance with the provisions of federal statutes, regulations, or the terms and conditions of federal awards regarding procurement, suspension, and debarment requirements. Suspension and Debarment - Covered Transaction From a population of nineteen disbursements, we selected nine disbursements to ascertain compliance with 2 CFR section 180.220 by examining the procurement documents provided by the Corporation. From that sample, we identified nine instances in which the SAM.gov registration verification process was not performed. Of the nine instances, we found eight suppliers properly registered, but one supplier appears as validated as unique and existing but not registered in SAM.gov. Cause Lack of understanding of procurement compliance requirements for federal awards. Fiscal year 2023 was the first year for the Corporation to be subjected to a single audit compliance requirement for receiving and expending COVID-19 public health emergency programs. Effect Noncompliance with sections 200.318 and 180.220 of 2 CFR may lead to temporary withholding of cash payments until the deficiency is corrected, and/or withholding further federal program awards. Questioned Costs None Recommendation General Procurement Standards - Written Policies and Suspension and Debarment - Covered Transaction We recommend the Corporation update its internal procurement written policies following the provisions of current state statutes and regulations and develop separate procurement written policies following the provisions of federal laws and regulations or the terms and conditions of federal awards, which includes the Procurement Standards described in 2 CFR section 200.317 through 200.327, as applicable. By updating, developing, and implementing the required written procurement policies, the Corporation will be able to comply with the federal government compliance requirements. Views of responsible officials Refer to Corrective Action Plan section.
Material Instance of Non-Compliance and Significant Deficiency Written Procurement Policy This finding impacts the procurement and suspension and debarment compliance requirement for the major program, Assistance Listing Number 10.555, Child Nutrition Cluster, funded by the U.S. Department of Agriculture and passed through by the Commonwealth of Massachusetts, Department of Elementary and Secondary Education (DESE). Criteria: The School must follow the procurement standards set out at 2 CFR sections 200.317 through 200.327. The School also must use their own documented procurement procedures, which reflect applicable state and local laws and regulations, provided that the procurements conform to applicable Federal statutes and the procurement requirements identified in 2 CFR part 200. Condition: During our compliance testing, we reviewed the School's procurement policy against Uniform Guidance standards. The policy did not meet all of the considerations that are required through Uniform Guidance, Federal and state regulations. The School followed their procurement policy during fiscal year 2022, but should update this policy in accordance with these regulations. Cause: The School’s existing procurement policy did not document all of the elements required by the Uniform Guidance. Effect: Non-compliance with the Uniform Guidance, potentially resulting in an increase in questioned costs. Was the finding a repeat of a finding in the immediately prior year?: No Recommendation: AAFCPAs recommends that management revise their policy to comply with current standards under the Uniform Guidance. Management Response: During the audit, it was recognized that the School did not have an updated procurement policy to comply with the current standards under the Uniform Guidance. This is the first year that the School received funds that exceeded the Uniform Guidance threshold and was not aware that there was a difference between Federal policy and state policy that we operated under. During the audit, it was recognized that the School had obtained appropriate bids and performed an adequate and documented comparison of qualifications amongst vendors before selecting the current vendor. These practices, which are outlined in the Uniform Guidance Standard, although followed, are not accurately reflected in our current procurement policy. This policy will be updated during fiscal year 2023.
Finding 2022-011 - Noncompliance Over Procurement and Suspension and Debarment – Coronavirus State and Local Fiscal Recovery Funds PASS THROUGH GRANTOR: Direct Grant FEDERAL AGENCY: U.S. Department of Treasury ASSISTANCE LISTING: 21.027 FEDERAL PROGRAM NAME: Coronavirus State and Local Fiscal Recovery Funds (SLFRF) FEDERAL AWARD NUMBER: SLFRP3720 FEDERAL AWARD YEAR: 2022 CONTROL CATEGORY: Procurement and Suspension and Debarment QUESTIONED COSTS: $203,000 Condition: During our review of the disbursement data from Muskogee County regarding procurement and suspension and debarment as per the Uniform Guidance 2 CFR 200.317 through 200.327, we identified the following: • One (1) ambulance was purchased in the amount of $203,000 for the Muskogee County EMS. There were no bids or quotes provide by the County or found in the BOCC meeting minutes supporting expenditure documentation. • There were six (6) vendors, in which the County did not check the www.SAM.gov website to review if the vendor had been suspended or debarred for those disbursements that warranted a bid, on the 6-month bid list, or received quotes. Cause of Condition: Policies and procedures have not been designed and implemented to ensure compliance of expenditures for all federal awards. Effect of Condition: This condition resulted in noncompliance to grant requirements and could lead to a loss of federal funds to the County. Recommendation: OSAI recommends county officials and department heads gain an understanding of federal programs awarded to Muskogee County. Internal control procedures should be designed and implemented to ensure accurate procurement and suspension and debarment and to ensure compliance with federal requirements. Management Response: Chairman of the Board of County Commissioners: Muskogee County has hired an internal grant administrator to assist in keeping the county compliant with all local, state, and federal requirements. Efforts will be made going forward to ensure that all grant funds are properly expended. This includes that all expenditures are properly documented and that all vendors are federally eligible to perform services. Criteria: 2 CFR § 200.317 through 200.327 General Procurement Standards reads as follows: When procuring property and services under a Federal award, a State must follow the same policies and procedures it uses for procurements from its non-Federal funds. The State will comply with §§ 200.321, 200.322, and 200.323 and ensure that every purchase order or other contract includes any clauses required by § 200.327. All other non-Federal entities, including subrecipients of a State, must follow the procurement standards in §§ 200.318 through 200.327. The non-Federal entity must have and use documented procurement procedures, consistent with State, local, and tribal laws and regulations and the standards of this section, for the acquisition of property or services required under a Federal award or subaward. The non- Federal entity's documented procurement procedures must conform to the procurement standards identified in §§ 200.317 through 200.327. (b) Non-Federal entities must maintain oversight to ensure that contractors perform in accordance with the terms, conditions, and specifications of their contracts or purchase orders. 2 CFR 180.700 – 180.760 Suspension and 2 CFR 180.800 – 180.885 Debarment Non-federal entities are prohibited from contracting with or making subawards under covered transactions to parties that are suspended or debarred. “Covered transactions” include contracts for goods and services awarded under a non-procurement transaction (e.g., grant or cooperative agreement) that are expected to equal or exceed $25,000 or meet certain other criteria as specified in 2 CFR section 180.220. All non-procurement transactions entered into by a pass-through entity (i.e., subawards to subrecipients), irrespective of award amount, are considered covered transactions, unless they are exempt as provided in 2 CFR section 180.215.
2022-002 Financial Statement Reconciliations/Tie-In Procedures Significant Deficiency CONDITION: A weakness existed in the overall reconciliation/tie-in procedures performed over the School’s financial statement accounts for the fiscal year ended June 30, 2022. Financial accounts were either reconciled untimely or in some cases, accounts were not reconciled at all. Most of these accounts should be reconciled on a monthly basis. The major areas where reconciliation procedures were weak included:A) Beginning Balances B) Cash Balances C) Account Receivables D) Grant Receivables/Unearned Revenues E) Accounts Payable F) Grant Revenue CRITERIA: OMB Uniform Guidance states the following in section 200.302, “(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. CAUSE: Lack of written policies and procedures over financial tie-in procedures that identify who is responsible for performing these tie-in/reconciliation procedures. EFFECT: In the course of performing the audit, the auditor recommended 10 adjusting journal entries be made to the financial statements for fiscal year ending June 30, 2022. Many of these adjustments could have been avoided if timely reconciliation and tie-in procedures had been conducted by the finance department. Many of these audit adjustments were material in nature.