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 2022-002 – Internal Control Deficiency and Noncompliance over Reporting Identification of the Federal Program: Federal Grantor: United States Department of the Treasury Pass-Through Entity: Smith County, Texas and the City of San Marcos, Texas Assistance Listing No.:21.027, Coronavirus State and Local Fiscal Recovery Funds Pass-Through Award Numbers: Not available Award Periods of Performance: Trinity Mother Frances, Pass-through Smith County, October 1, 2021 – November 30, 2021 Santa Rosa, Pass-through the City of San Marcos, March 03, 2021 through December 31, 2026 Criteria or Specific Requirement (Including Statutory, Regulatory or Other Citation): The Uniform Guidance 2 CFR section 200.303 states, “The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).” The Uniform Guidance 2 CFR section 200.510 states, “(b) Schedule of expenditures of Federal awards. The auditee must also prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended.” Condition: CHRISTUS did not originally prepare a complete and accurate listing of all federal awards in the SEFA. Cause: CHRISTUS did not have controls in place to ensure all federal expenditures were captured on the SEFA. Effect or Potential Effect: The SEFA prepared by CHRISTUS was misstated but was subsequently corrected. The misstatement resulted in the omission of a major federal program under the Uniform Guidance report. Questioned Costs: None. Context: Expenditures for Assistance Listing Number 21.027 were originally understated on the SEFA by $2,500,000, or 71% of the program. Identification as a Repeat Finding, if Applicable: This is not a repeat finding. Recommendation: CHRISTUS should review its internal controls over the process of accumulating and reporting expenditures of federal awards. Views of Responsible Officials: CHRISTUS agrees with the finding and has developed internal controls to ensure accurate and complete reporting of federal expenditures.
Finding 2022-002 – Internal Control Deficiency and Noncompliance over Reporting Identification of the Federal Program: Federal Grantor: United States Department of the Treasury Pass-Through Entity: Smith County, Texas and the City of San Marcos, Texas Assistance Listing No.:21.027, Coronavirus State and Local Fiscal Recovery Funds Pass-Through Award Numbers: Not available Award Periods of Performance: Trinity Mother Frances, Pass-through Smith County, October 1, 2021 – November 30, 2021 Santa Rosa, Pass-through the City of San Marcos, March 03, 2021 through December 31, 2026 Criteria or Specific Requirement (Including Statutory, Regulatory or Other Citation): The Uniform Guidance 2 CFR section 200.303 states, “The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).” The Uniform Guidance 2 CFR section 200.510 states, “(b) Schedule of expenditures of Federal awards. The auditee must also prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended.” Condition: CHRISTUS did not originally prepare a complete and accurate listing of all federal awards in the SEFA. Cause: CHRISTUS did not have controls in place to ensure all federal expenditures were captured on the SEFA. Effect or Potential Effect: The SEFA prepared by CHRISTUS was misstated but was subsequently corrected. The misstatement resulted in the omission of a major federal program under the Uniform Guidance report. Questioned Costs: None. Context: Expenditures for Assistance Listing Number 21.027 were originally understated on the SEFA by $2,500,000, or 71% of the program. Identification as a Repeat Finding, if Applicable: This is not a repeat finding. Recommendation: CHRISTUS should review its internal controls over the process of accumulating and reporting expenditures of federal awards. Views of Responsible Officials: CHRISTUS agrees with the finding and has developed internal controls to ensure accurate and complete reporting of federal expenditures.
Finding 2022-002 – Internal Control Deficiency and Noncompliance over Reporting Identification of the Federal Program: Federal Grantor: United States Department of the Treasury Pass-Through Entity: Smith County, Texas and the City of San Marcos, Texas Assistance Listing No.:21.027, Coronavirus State and Local Fiscal Recovery Funds Pass-Through Award Numbers: Not available Award Periods of Performance: Trinity Mother Frances, Pass-through Smith County, October 1, 2021 – November 30, 2021 Santa Rosa, Pass-through the City of San Marcos, March 03, 2021 through December 31, 2026 Criteria or Specific Requirement (Including Statutory, Regulatory or Other Citation): The Uniform Guidance 2 CFR section 200.303 states, “The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).” The Uniform Guidance 2 CFR section 200.510 states, “(b) Schedule of expenditures of Federal awards. The auditee must also prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended.” Condition: CHRISTUS did not originally prepare a complete and accurate listing of all federal awards in the SEFA. Cause: CHRISTUS did not have controls in place to ensure all federal expenditures were captured on the SEFA. Effect or Potential Effect: The SEFA prepared by CHRISTUS was misstated but was subsequently corrected. The misstatement resulted in the omission of a major federal program under the Uniform Guidance report. Questioned Costs: None. Context: Expenditures for Assistance Listing Number 21.027 were originally understated on the SEFA by $2,500,000, or 71% of the program. Identification as a Repeat Finding, if Applicable: This is not a repeat finding. Recommendation: CHRISTUS should review its internal controls over the process of accumulating and reporting expenditures of federal awards. Views of Responsible Officials: CHRISTUS agrees with the finding and has developed internal controls to ensure accurate and complete reporting of federal expenditures.
Noncompliance/Material Weakness – Schedule of Expenditures of Federal Awards 2 CFR §200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $4,752,800. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the District and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Noncompliance/Material Weakness – Schedule of Expenditures of Federal Awards 2 CFR §200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $4,752,800. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the District and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Noncompliance/Material Weakness – Schedule of Expenditures of Federal Awards 2 CFR §200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $4,752,800. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the District and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Noncompliance/Material Weakness – Schedule of Expenditures of Federal Awards 2 CFR §200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $4,752,800. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the District and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Noncompliance/Material Weakness – Schedule of Expenditures of Federal Awards 2 CFR §200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $4,752,800. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the District and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Noncompliance/Material Weakness – Schedule of Expenditures of Federal Awards 2 CFR §200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $4,752,800. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the District and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Noncompliance/Material Weakness – Schedule of Expenditures of Federal Awards 2 CFR §200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $4,752,800. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the District and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Noncompliance/Material Weakness – Schedule of Expenditures of Federal Awards 2 CFR §200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $4,752,800. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the District and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Noncompliance/Material Weakness – Schedule of Expenditures of Federal Awards 2 CFR §200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $4,752,800. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the District and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Noncompliance/Material Weakness – Schedule of Expenditures of Federal Awards 2 CFR §200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $4,752,800. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the District and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Noncompliance/Material Weakness – Schedule of Expenditures of Federal Awards 2 CFR §200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $4,752,800. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the District and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Noncompliance/Material Weakness – Schedule of Expenditures of Federal Awards 2 CFR §200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $4,752,800. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the District and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Noncompliance/Material Weakness – Schedule of Expenditures of Federal Awards 2 CFR §200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $4,752,800. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the District and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Noncompliance/Material Weakness – Schedule of Expenditures of Federal Awards 2 CFR §200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $4,752,800. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the District and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Noncompliance/Material Weakness – Schedule of Expenditures of Federal Awards 2 CFR §200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $4,752,800. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the District and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Noncompliance/Material Weakness – Schedule of Expenditures of Federal Awards 2 CFR §200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $4,752,800. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the District and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Noncompliance/Material Weakness – Schedule of Expenditures of Federal Awards 2 CFR §200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $4,752,800. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the District and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Noncompliance/Material Weakness – Schedule of Expenditures of Federal Awards 2 CFR §200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $4,752,800. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the District and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Noncompliance/Material Weakness – Schedule of Expenditures of Federal Awards 2 CFR §200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $4,752,800. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the District and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Noncompliance/Material Weakness – Schedule of Expenditures of Federal Awards 2 CFR §200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $4,752,800. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the District and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Noncompliance/Material Weakness – Schedule of Expenditures of Federal Awards 2 CFR §200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $4,752,800. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the District and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Noncompliance/Material Weakness – Schedule of Expenditures of Federal Awards 2 CFR §200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $4,752,800. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the District and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Noncompliance/Material Weakness – Schedule of Expenditures of Federal Awards 2 CFR §200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $4,752,800. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the District and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Noncompliance/Material Weakness – Schedule of Expenditures of Federal Awards 2 CFR §200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $4,752,800. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the District and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Noncompliance/Material Weakness – Schedule of Expenditures of Federal Awards 2 CFR §200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $4,752,800. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the District and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Noncompliance/Material Weakness – Schedule of Expenditures of Federal Awards 2 CFR §200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $4,752,800. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the District and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Noncompliance/Material Weakness – Schedule of Expenditures of Federal Awards 2 CFR §200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $4,752,800. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the District and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Noncompliance/Material Weakness – Schedule of Expenditures of Federal Awards 2 CFR §200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $4,752,800. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the District and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
2022-001 Preparation of and Internal controls over Schedule of Expenditures of Federal Awards -(Material Weakness) Federal Agency: U.S Department of Education Program Name: Child Nutrition Cluster Assistance Listing Numbers: 10.553, 10.555 and 10.559 Award Period: June 30, 2022 Criteria: According to 2 CFR 200, Subpart F, the District is required to prepare a schedule of federal expenditures, which must include the total federal awards expended as determined in accordance with §200.502. An effective internal control system exists if controls are effective in preventing or detecting material misstatements in the preparation of the schedule of federal expenditures of federal awards (the schedule). It provides reasonable assurance for the reliability of financial information and compliance with laws and regulations. Condition: We have determined that there was an inadequate design of internal control over the preparation of the schedule during the fiscal year ended June 30, 2022. The current financial reporting process does not ensure accuracy and completeness in the preparation of the schedule by the District, as required by Uniform Guidance. Cause: The District’s policies and procedures were not designed to ensure the District’s preparation of the schedule in conformity with Uniform Guidance. Effect: The District did not prepare the schedule in conformity with Uniform Guidance. This increases the likelihood of a material misstatement and noncompliance with laws and regulations. Recommendation: We recommend the Board of Education and management review the financial reporting process. Once this review is complete, the District should then perform a risk assessment to determine the best way to implement appropriate internal controls over financial reporting to ensure that the District prepares the schedule conformity with Uniform Guidance. Questioned Costs: None. Repeat Finding: No. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and plans to develop proper written policies and procedures for the internal control over compliance to ensure accuracy and completeness in the District’s preparation of the schedule as required by Uniform Guidance.
2022-001 Preparation of and Internal controls over Schedule of Expenditures of Federal Awards -(Material Weakness) Federal Agency: U.S Department of Education Program Name: Child Nutrition Cluster Assistance Listing Numbers: 10.553, 10.555 and 10.559 Award Period: June 30, 2022 Criteria: According to 2 CFR 200, Subpart F, the District is required to prepare a schedule of federal expenditures, which must include the total federal awards expended as determined in accordance with §200.502. An effective internal control system exists if controls are effective in preventing or detecting material misstatements in the preparation of the schedule of federal expenditures of federal awards (the schedule). It provides reasonable assurance for the reliability of financial information and compliance with laws and regulations. Condition: We have determined that there was an inadequate design of internal control over the preparation of the schedule during the fiscal year ended June 30, 2022. The current financial reporting process does not ensure accuracy and completeness in the preparation of the schedule by the District, as required by Uniform Guidance. Cause: The District’s policies and procedures were not designed to ensure the District’s preparation of the schedule in conformity with Uniform Guidance. Effect: The District did not prepare the schedule in conformity with Uniform Guidance. This increases the likelihood of a material misstatement and noncompliance with laws and regulations. Recommendation: We recommend the Board of Education and management review the financial reporting process. Once this review is complete, the District should then perform a risk assessment to determine the best way to implement appropriate internal controls over financial reporting to ensure that the District prepares the schedule conformity with Uniform Guidance. Questioned Costs: None. Repeat Finding: No. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and plans to develop proper written policies and procedures for the internal control over compliance to ensure accuracy and completeness in the District’s preparation of the schedule as required by Uniform Guidance.
2022-001 Preparation of and Internal controls over Schedule of Expenditures of Federal Awards -(Material Weakness) Federal Agency: U.S Department of Education Program Name: Child Nutrition Cluster Assistance Listing Numbers: 10.553, 10.555 and 10.559 Award Period: June 30, 2022 Criteria: According to 2 CFR 200, Subpart F, the District is required to prepare a schedule of federal expenditures, which must include the total federal awards expended as determined in accordance with §200.502. An effective internal control system exists if controls are effective in preventing or detecting material misstatements in the preparation of the schedule of federal expenditures of federal awards (the schedule). It provides reasonable assurance for the reliability of financial information and compliance with laws and regulations. Condition: We have determined that there was an inadequate design of internal control over the preparation of the schedule during the fiscal year ended June 30, 2022. The current financial reporting process does not ensure accuracy and completeness in the preparation of the schedule by the District, as required by Uniform Guidance. Cause: The District’s policies and procedures were not designed to ensure the District’s preparation of the schedule in conformity with Uniform Guidance. Effect: The District did not prepare the schedule in conformity with Uniform Guidance. This increases the likelihood of a material misstatement and noncompliance with laws and regulations. Recommendation: We recommend the Board of Education and management review the financial reporting process. Once this review is complete, the District should then perform a risk assessment to determine the best way to implement appropriate internal controls over financial reporting to ensure that the District prepares the schedule conformity with Uniform Guidance. Questioned Costs: None. Repeat Finding: No. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and plans to develop proper written policies and procedures for the internal control over compliance to ensure accuracy and completeness in the District’s preparation of the schedule as required by Uniform Guidance.
2022-001 Preparation of and Internal controls over Schedule of Expenditures of Federal Awards -(Material Weakness) Federal Agency: U.S Department of Education Program Name: Child Nutrition Cluster Assistance Listing Numbers: 10.553, 10.555 and 10.559 Award Period: June 30, 2022 Criteria: According to 2 CFR 200, Subpart F, the District is required to prepare a schedule of federal expenditures, which must include the total federal awards expended as determined in accordance with §200.502. An effective internal control system exists if controls are effective in preventing or detecting material misstatements in the preparation of the schedule of federal expenditures of federal awards (the schedule). It provides reasonable assurance for the reliability of financial information and compliance with laws and regulations. Condition: We have determined that there was an inadequate design of internal control over the preparation of the schedule during the fiscal year ended June 30, 2022. The current financial reporting process does not ensure accuracy and completeness in the preparation of the schedule by the District, as required by Uniform Guidance. Cause: The District’s policies and procedures were not designed to ensure the District’s preparation of the schedule in conformity with Uniform Guidance. Effect: The District did not prepare the schedule in conformity with Uniform Guidance. This increases the likelihood of a material misstatement and noncompliance with laws and regulations. Recommendation: We recommend the Board of Education and management review the financial reporting process. Once this review is complete, the District should then perform a risk assessment to determine the best way to implement appropriate internal controls over financial reporting to ensure that the District prepares the schedule conformity with Uniform Guidance. Questioned Costs: None. Repeat Finding: No. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and plans to develop proper written policies and procedures for the internal control over compliance to ensure accuracy and completeness in the District’s preparation of the schedule as required by Uniform Guidance.
Program - Various, including AL 10.923 – Emergency Watershed Protection Program – Reporting Grant Number & Year - Various, including NR216526XXXXC004, December 7, 2020, through August 6, 2021 Federal Grantor Agency - Various, including U.S. Department of Agriculture Pass-Through Entity - Various Criteria - Title 2 of the U.S. Code of Federal Regulations (CFR) § 200.510(b) (January 1, 2022) states, in part, the following: The auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with § 200.502. 2 CFR § 200.512(a)(1) (January 1, 2022) states the following: The audit must be completed and the data collection form described in paragraph (b) ofthis section and reporting package described in paragraph (c) of this section must besubmitted within the earlier of 30 calendar days after receipt of the auditor’s report(s),or nine months after the end of the audit period. If the due date falls on a Saturday,Sunday, or Federal holiday, the reporting package is due the next business day. 2 CFR § 200.508 (January 1, 2022) states, in part, the following: The auditee must: (a) Procure or otherwise arrange for the audit required by this part in accordance with §200.509, and ensure it is properly performed and submitted when due in accordance with §200.512. 2 CFR § 200.303 (January 1, 2022) states the following, in relevant part: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in ‘‘Standards for Internal Control in the Federal Government’’ issued by the Comptroller General of the United States or the ‘‘Internal Control Integrated Framework’’, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). A good internal control plan requires adequate procedures to ensure the Schedule of Expenditures Federal Awards (SEFA) is presented properly and includes all Federal expenditures made by the County during the fiscal year. Additionally, those same procedures should ensure the Federal audit is completed and submitted to the Federal Audit Clearinghouse within the time frame required by Title 2 CFR § 200.512. Condition - The County did not have adequate procedures in place to monitor Federal expenditures and ensure the Schedule of Expenditures of Federal Awards (SEFA) was completed and submitted to the Federal Audit Clearinghouse in accordance with Title 2 CFR § 200.512. Repeat Finding - No Questioned Costs - None Statistical Sample - No Context - The County had a basic financial statement audit completed for the fiscal year ending June 30, 2022, which was issued on January 4, 2023, but that audit did not include the additional information necessary to meet Uniform Guidance and Single Audit Act requirements. When the audit for the fiscal year ending June 30, 2023, was completed, the Auditor of Public Accounts identified that the County should have had a Single Audit completed for the fiscal year ending June 30, 2022. Cause - Administration of Federal awards is decentralized, with each County office operating independently without any centralized reporting procedures in place to ensure all Federal expenditures of the County are reported accurately during the annual financial statement audit. Additionally, there is an overall lack of knowledge by County personnel related to Federal reporting requirements. Effect - Noncompliance with Federal regulations and an increased risk for the SEFA to be inaccurate, which could lead to Federal sanctions and Single Audits not being completed when required. Recommendation - We recommend the County establish written procedures to ensure the SEFA is complete and accurate. Such procedures may include, among other things, a requirement that all offices in the County responsible for administering Federal grants report their grant expenditures, as well as related information, to a single individual in the County with overall responsibility for Federal reporting requirements. That individual should be knowledgeable of all Federal reporting and compliance requirements, and review expenditures provided by each office to ensure all amounts are accurate and include all Federal expenditures of the County. Further, we recommend the County obtain necessary training related to Federal reporting requirements and ensure a Single Audit is completed and submitted to the Federal Audit Clearinghouse within the time frame required by Title 2 CFR § 200.512. View of Officials - The County will ensure County personnel obtain training to ensure there is a proper understanding of the Federal reporting requirements and preparation of the Schedule of Federal Awards.
Criteria: In accordance with 2 CFR 200.200.510(b), the auditee must prepare a Schedule of Expenditures of Federal Awards (Schedule) 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 200.502. Condition: The University’s Schedule of Expenditures for Federal Awards for the year ended June 30, 2022, was restated to include federal expenditures totaling $3,035,255 for the Disaster Grants - Public Assistance (Presidentially Declared Disasters), Assistance Listing Number 97.036, resulting in total expenditures of $3,030,346. Cause: The federal program activity for the Disaster Grants - Public Assistance (Presidentially Declared Disasters), Assistance Listing Number 97.036, was omitted from the Schedule of Expenditures for Federal Awards due to an oversight in the preparation of the Schedule. Effect: Improper reporting of federal expenditures can result in material errors on the Schedule leading to inaccurate major program determination by the auditors. In this instance, an error did result in the identification of an additional major program. Questioned Cost: None. Context: The University improperly excluded grant expenditures for the Disaster Grants - Public Assistance (Presidentially Declared Disasters) program on the original Schedule for the year ended June 30, 2022 in the amount of $3,035,255 resulting in total expenditures of $3,030,346 for the program and, therefore, the single audit report was reissued for the correction of the error. Recommendation: We recommend the University enhance the process and internal controls around the timely identification of federal awards and preparation of the Schedule to ensure accuracy and completeness of the Schedule. Views of responsible officials: We agree with the compliance finding. See the Corrective Action Plan at pages 71-72.
EMPLOYMENT DEVELOPMENT DEPARTMENT Reference Number: 2022-001 Type of Finding: Material Weakness and Material Instance of Noncompliance Criteria Title 2 - Grants and Agreements. Subtitle A - Office of Management and Budget Guidance for Grants and Agreements. Chapter II - Office of Management and Budget Guidance. Part 200 - Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards. Subpart D - Post Federal Award Requirements. Standards for Financial and Program Management. §200.303 Internal controls (2 CFR 200.303): 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). Title 2 - Grants and Agreements. Subtitle A - Office of Management and Budget Guidance for Grants and Agreements. Chapter II - Office of Management and Budget Guidance. Part 200 - Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards. Subpart F - Audit Requirements. §200.510 Financial statements (2 CFR 200.510): (b) Schedule of expenditures of Federal awards. The auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (3) Provide total Federal awards expended for each individual Federal program and the Assistance Listings Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. Condition The State of California (State) has a decentralized financial reporting process, which requires State agencies and departments to provide specific financial information to the Department of Finance (Finance) in order to annually compile the Schedule of Expenditures of Federal Awards (Schedule). In its effort to more efficiently and accurately prepare the Schedule in accordance with the requirements of Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance), Finance developed the Single Audit Expenditures Reporting Database (Database). Finance developed the Database to include all of the relevant data fields necessary to compile and produce the Schedule. Finance also created a Single Audit Database User Manual, which provides specific guidance to users for accessing and navigating through the database. Due to the unprecedented impacts from the COVID-19 pandemic, the Employment Development Department (EDD) was unable to timely report to Finance through the Database with accurate and reliable federal cash basis expenditures for its largest federal award program that it administers, the Unemployment Insurance (ALN 17.225) program. The delay resulted in Finance being unable to compile and produce a complete and final approved Schedule until December 2023. Although an initial estimated expenditure amount was reported by EDD of $27.0 billion, the final amount reported in the Schedule was $23.3 billion. Cause Given the substantial increase in claimants seeking assistance under the Unemployment Insurance program resulting from the COVID-19 pandemic, EDD was overwhelmed with the administration of the Unemployment Insurance program. Effect The difficulties that EDD encountered from the COVID-19 pandemic, resulted in the late reporting and submission of final federal cash basis expenditures to Finance. The untimely submission continued to limit and constrain Finance from compiling and producing a final complete and accurate Schedule. Questioned Costs Questioned costs were not determinable. Recommendation EDD should continue to evaluate existing processes and controls related to its ability to properly report, and timely submit complete and accurate federal award cash basis expenditures to the Database, which affords Finance the ability to timely compile and produce a final Schedule pursuant to the Uniform Guidance. Views of Responsible Officials and Corrective Action Plan EDD agrees with this finding. The deferred transition to FI$Cal and the difficulties experienced thereafter have continued to cause EDD to be late with submitting year-end financials and its ability to submit timely the cash basis expenditures into the Single Audit Expenditures Reporting Database (Database). In addition, the onset of the COVID-19 pandemic created additional issues which ultimately impacted the EDD’s ability to submit timely year-end financials. However, the EDD continues to make progress to gain ground in the department’s efforts to follow the State’s deadlines for submitting year-end financials and entering the cash basis expenditures into the Database. During fiscal year 2022-23, the EDD completed a restructuring within the accounting area which realigned workload amongst the units and provided additional resources in critical areas. These changes will have a lasting effect and help the department to be better positioned going forward in processing the accounting workload and ultimately be able to catch up and submit year-end financials and enter the cash basis expenditures into the Database by the State’s deadlines. In addition, the EDD took lessons learned from the financial audits from the prior two fiscal years to update processes and procedures and applied that knowledge going forward. Also, staff continue to participate in various trainings offered by the Department of Finance and the Department of FI$Cal. In addition, staff work with the control agencies when issues arise that would impact our accounting functions.
EMPLOYMENT DEVELOPMENT DEPARTMENT Reference Number: 2022-001 Type of Finding: Material Weakness and Material Instance of Noncompliance Criteria Title 2 - Grants and Agreements. Subtitle A - Office of Management and Budget Guidance for Grants and Agreements. Chapter II - Office of Management and Budget Guidance. Part 200 - Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards. Subpart D - Post Federal Award Requirements. Standards for Financial and Program Management. §200.303 Internal controls (2 CFR 200.303): 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). Title 2 - Grants and Agreements. Subtitle A - Office of Management and Budget Guidance for Grants and Agreements. Chapter II - Office of Management and Budget Guidance. Part 200 - Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards. Subpart F - Audit Requirements. §200.510 Financial statements (2 CFR 200.510): (b) Schedule of expenditures of Federal awards. The auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (3) Provide total Federal awards expended for each individual Federal program and the Assistance Listings Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. Condition The State of California (State) has a decentralized financial reporting process, which requires State agencies and departments to provide specific financial information to the Department of Finance (Finance) in order to annually compile the Schedule of Expenditures of Federal Awards (Schedule). In its effort to more efficiently and accurately prepare the Schedule in accordance with the requirements of Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance), Finance developed the Single Audit Expenditures Reporting Database (Database). Finance developed the Database to include all of the relevant data fields necessary to compile and produce the Schedule. Finance also created a Single Audit Database User Manual, which provides specific guidance to users for accessing and navigating through the database. Due to the unprecedented impacts from the COVID-19 pandemic, the Employment Development Department (EDD) was unable to timely report to Finance through the Database with accurate and reliable federal cash basis expenditures for its largest federal award program that it administers, the Unemployment Insurance (ALN 17.225) program. The delay resulted in Finance being unable to compile and produce a complete and final approved Schedule until December 2023. Although an initial estimated expenditure amount was reported by EDD of $27.0 billion, the final amount reported in the Schedule was $23.3 billion. Cause Given the substantial increase in claimants seeking assistance under the Unemployment Insurance program resulting from the COVID-19 pandemic, EDD was overwhelmed with the administration of the Unemployment Insurance program. Effect The difficulties that EDD encountered from the COVID-19 pandemic, resulted in the late reporting and submission of final federal cash basis expenditures to Finance. The untimely submission continued to limit and constrain Finance from compiling and producing a final complete and accurate Schedule. Questioned Costs Questioned costs were not determinable. Recommendation EDD should continue to evaluate existing processes and controls related to its ability to properly report, and timely submit complete and accurate federal award cash basis expenditures to the Database, which affords Finance the ability to timely compile and produce a final Schedule pursuant to the Uniform Guidance. Views of Responsible Officials and Corrective Action Plan EDD agrees with this finding. The deferred transition to FI$Cal and the difficulties experienced thereafter have continued to cause EDD to be late with submitting year-end financials and its ability to submit timely the cash basis expenditures into the Single Audit Expenditures Reporting Database (Database). In addition, the onset of the COVID-19 pandemic created additional issues which ultimately impacted the EDD’s ability to submit timely year-end financials. However, the EDD continues to make progress to gain ground in the department’s efforts to follow the State’s deadlines for submitting year-end financials and entering the cash basis expenditures into the Database. During fiscal year 2022-23, the EDD completed a restructuring within the accounting area which realigned workload amongst the units and provided additional resources in critical areas. These changes will have a lasting effect and help the department to be better positioned going forward in processing the accounting workload and ultimately be able to catch up and submit year-end financials and enter the cash basis expenditures into the Database by the State’s deadlines. In addition, the EDD took lessons learned from the financial audits from the prior two fiscal years to update processes and procedures and applied that knowledge going forward. Also, staff continue to participate in various trainings offered by the Department of Finance and the Department of FI$Cal. In addition, staff work with the control agencies when issues arise that would impact our accounting functions.
DDEPARTMENT OF PUBLIC HEALTH Reference Number: 2022-002 Type of Finding: Material Weakness and Instance of Noncompliance Criteria Title 2 - Grants and Agreements. Subtitle A - Office of Management and Budget Guidance for Grants and Agreements. Chapter II - Office of Management and Budget Guidance. Part 200 - Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards. Subpart D - Post Federal Award Requirements. Standards for Financial and Program Management. §200.303 Internal controls (2 CFR 200.303): 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). Title 2 - Grants and Agreements. Subtitle A - Office of Management and Budget Guidance for Grants and Agreements. Chapter II - Office of Management and Budget Guidance. Part 200 - Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards. Subpart F - Audit Requirements. §200.510 Financial statements (2 CFR 200.510): (b) Schedule of expenditures of Federal awards. The auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (3) Provide total Federal awards expended for each individual Federal program and the Assistance Listings Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. (4) Include the total amount provided to subrecipients from each Federal program. Condition The State of California (State) has a decentralized financial reporting process, which requires State agencies and departments to provide specific financial information to the Department of Finance (Finance) in order to annually compile the Schedule of Expenditures of Federal Awards (Schedule). In its effort to more efficiently and accurately prepare the Schedule in accordance with the requirements of 2 CFR 200.510, Finance developed the Single Audit Expenditures Reporting Database (Database) to include all relevant data fields necessary to compile and produce the Schedule. Finance also created a Single Audit Database User Manual, which provides specific guidance to users for accessing and navigating through the database. Departments are given access to the centralized Database by Finance in order to upload and report federal award information for all federal award programs which they administer. The California Department of Public Health (Public Health) understated federal expenditures and overstated amounts passed through to subrecipients for the Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) program (ALN No. 93.323). The error, which was subsequently corrected, is indicative of a lack of sufficient controls for ensuring the Schedule’s completeness and accuracy prior to submission to Finance. Cause Public Health was a subrecipient of federal funds provided by their bona fide agent, Heluna Health, during the fiscal year ended June 30, 2022. Initially, the ELC program funds were not identified and recognized as federal expenditures until January 2023. During its compilation of federal award expenditures for reporting in Finance’s Database, Public Health did not properly analyze and capture all relevant financial transactions related to the ELC program. Effect Federal expenditures originally reported in the Schedule by Public Health for the ELC program were understated by $154,155,192 and the amounts passed through to subrecipients were overstated by $516,650,718. Questioned Costs No questioned costs were identified. Recommendation Public Health should establish a more thorough internal review and communication process between ELC program administration and accounting personnel to ensure information submitted to Finance for compilation of the Schedule is complete and accurate. Views of Responsible Officials and Corrective Action Plan Public Health’s Accounting Office will generate the FI$Cal Year End Close report (KK_12 expenditure) and collaborate with the ELC program to ensure that all expenditures captured are complete and accurate, ensuring timely reporting of the SEFA data for FY 2023-24 and beyond. Please note that the ELC program has been reported in the FY 2022-23 SEFA. Additionally, we will update the procedures to document the SEFA reporting for the ELC program. Estimated Implementation Date: September 2024 Contact: Jennifer Chan, Accounting Administrator II Federal Reporting Unit, Financial Management Division California Department of Public Health
2022-002 Reporting ? Schedule of Expenditures of Federal AwardsIdentification as a Repeat Finding: Repeat of Finding 2021-004.Finding:The SEFA provided for audit contained errors in identifying programs, program clusters and expenditures of federal awards.Criteria:The Organization is responsible for maintaining accurate information about all federal programs and reporting requirements. The Organization is responsible for using this information to comply with the Uniform Guidance in carrying out federal programs.Sample Size and Population: N/ACondition and Context:The original SEFA provided for audit contained errors in identifying programs, program clusters and expenditures of federal awards including the following:? 21.019 Coronavirus Relief Fund excluded. Contracts 4120 & 8328 passed through by the United Way of King County & the contract passed through by the Washington State Housing Finance Commission (WSHFC) totaled $205,822 but were not included in the original SEFA provided.? 21.023 Emergency Rental Assistance Program Contract 9395 passed through by the United Way of King County understated by $341,000.? 21.023 Emergency Rental Assistance Program Contract excluded. Contract 8366 passed through by the United Way of King County included $8,274,601 of federal funds that were not included on the original SEFA provided for audit.? 21.026 Homeowner Assistance Fund contact #HAF0025 passed through by WSHFC overstated by $124,710.? 91.024 Emergency Food and Shelter contract #889000-033 passed through by United Way of King County overstated by $66,542.? 17.258 WIOA Title 1b Adult Services contract #21-115-ADU passed through by Workforce Development Council of King County not identified as part of the WIOA Cluster.Additionally, the prior year SEFA was overstated by $704,017 for the 20.019 Coronavirus Relief Fund Contracts #4120 and #8328 passed through by the United Way of King County due to the accounting error identified in Finding 2022-001.Effect:Inaccurate identification of programs subject to the Single Audit increases the risk that the Organization will not comply with the terms and conditions of federal programs.Cause:As noted in Finding 2022-001, the Organization did not correctly account for advanced federal funds and as noted in Finding 2022-003, the Organization has not implemented a policy for advanced federal funds that complies with 2 CFR 200.305. These gaps in internal control resulted in cut-off errors in SEFA reporting for FY21 & FY22. Additionally, the Organization has not been applying the guidance of Section 200.502 of the Uniform Guidance in preparing the SEFA. Lastly, the program manager of the pass through agency of the 21.023 Emergency Rental Assistance Program Contract #8366 incorrectly informed the Organization that it had no responsibility for reporting the contract as a subrecipient of federal funds.Recommendation:The Organization must continue to increase its familiarity with federal grant compliance requirements and establish a process for timely identification of federal programs and a system for tracking contracts in order to ensure compliance with federal award programs and to completeness and accuracy in SEFA reporting.Questioned Costs: NoneManagement Response and Corrective Action Plan: See Corrective Action PlanContact Person: Mansour Camara, CFO
2022-002 Reporting ? Schedule of Expenditures of Federal AwardsIdentification as a Repeat Finding: Repeat of Finding 2021-004.Finding:The SEFA provided for audit contained errors in identifying programs, program clusters and expenditures of federal awards.Criteria:The Organization is responsible for maintaining accurate information about all federal programs and reporting requirements. The Organization is responsible for using this information to comply with the Uniform Guidance in carrying out federal programs.Sample Size and Population: N/ACondition and Context:The original SEFA provided for audit contained errors in identifying programs, program clusters and expenditures of federal awards including the following:? 21.019 Coronavirus Relief Fund excluded. Contracts 4120 & 8328 passed through by the United Way of King County & the contract passed through by the Washington State Housing Finance Commission (WSHFC) totaled $205,822 but were not included in the original SEFA provided.? 21.023 Emergency Rental Assistance Program Contract 9395 passed through by the United Way of King County understated by $341,000.? 21.023 Emergency Rental Assistance Program Contract excluded. Contract 8366 passed through by the United Way of King County included $8,274,601 of federal funds that were not included on the original SEFA provided for audit.? 21.026 Homeowner Assistance Fund contact #HAF0025 passed through by WSHFC overstated by $124,710.? 91.024 Emergency Food and Shelter contract #889000-033 passed through by United Way of King County overstated by $66,542.? 17.258 WIOA Title 1b Adult Services contract #21-115-ADU passed through by Workforce Development Council of King County not identified as part of the WIOA Cluster.Additionally, the prior year SEFA was overstated by $704,017 for the 20.019 Coronavirus Relief Fund Contracts #4120 and #8328 passed through by the United Way of King County due to the accounting error identified in Finding 2022-001.Effect:Inaccurate identification of programs subject to the Single Audit increases the risk that the Organization will not comply with the terms and conditions of federal programs.Cause:As noted in Finding 2022-001, the Organization did not correctly account for advanced federal funds and as noted in Finding 2022-003, the Organization has not implemented a policy for advanced federal funds that complies with 2 CFR 200.305. These gaps in internal control resulted in cut-off errors in SEFA reporting for FY21 & FY22. Additionally, the Organization has not been applying the guidance of Section 200.502 of the Uniform Guidance in preparing the SEFA. Lastly, the program manager of the pass through agency of the 21.023 Emergency Rental Assistance Program Contract #8366 incorrectly informed the Organization that it had no responsibility for reporting the contract as a subrecipient of federal funds.Recommendation:The Organization must continue to increase its familiarity with federal grant compliance requirements and establish a process for timely identification of federal programs and a system for tracking contracts in order to ensure compliance with federal award programs and to completeness and accuracy in SEFA reporting.Questioned Costs: NoneManagement Response and Corrective Action Plan: See Corrective Action PlanContact Person: Mansour Camara, CFO
2022-002 Reporting ? Schedule of Expenditures of Federal AwardsIdentification as a Repeat Finding: Repeat of Finding 2021-004.Finding:The SEFA provided for audit contained errors in identifying programs, program clusters and expenditures of federal awards.Criteria:The Organization is responsible for maintaining accurate information about all federal programs and reporting requirements. The Organization is responsible for using this information to comply with the Uniform Guidance in carrying out federal programs.Sample Size and Population: N/ACondition and Context:The original SEFA provided for audit contained errors in identifying programs, program clusters and expenditures of federal awards including the following:? 21.019 Coronavirus Relief Fund excluded. Contracts 4120 & 8328 passed through by the United Way of King County & the contract passed through by the Washington State Housing Finance Commission (WSHFC) totaled $205,822 but were not included in the original SEFA provided.? 21.023 Emergency Rental Assistance Program Contract 9395 passed through by the United Way of King County understated by $341,000.? 21.023 Emergency Rental Assistance Program Contract excluded. Contract 8366 passed through by the United Way of King County included $8,274,601 of federal funds that were not included on the original SEFA provided for audit.? 21.026 Homeowner Assistance Fund contact #HAF0025 passed through by WSHFC overstated by $124,710.? 91.024 Emergency Food and Shelter contract #889000-033 passed through by United Way of King County overstated by $66,542.? 17.258 WIOA Title 1b Adult Services contract #21-115-ADU passed through by Workforce Development Council of King County not identified as part of the WIOA Cluster.Additionally, the prior year SEFA was overstated by $704,017 for the 20.019 Coronavirus Relief Fund Contracts #4120 and #8328 passed through by the United Way of King County due to the accounting error identified in Finding 2022-001.Effect:Inaccurate identification of programs subject to the Single Audit increases the risk that the Organization will not comply with the terms and conditions of federal programs.Cause:As noted in Finding 2022-001, the Organization did not correctly account for advanced federal funds and as noted in Finding 2022-003, the Organization has not implemented a policy for advanced federal funds that complies with 2 CFR 200.305. These gaps in internal control resulted in cut-off errors in SEFA reporting for FY21 & FY22. Additionally, the Organization has not been applying the guidance of Section 200.502 of the Uniform Guidance in preparing the SEFA. Lastly, the program manager of the pass through agency of the 21.023 Emergency Rental Assistance Program Contract #8366 incorrectly informed the Organization that it had no responsibility for reporting the contract as a subrecipient of federal funds.Recommendation:The Organization must continue to increase its familiarity with federal grant compliance requirements and establish a process for timely identification of federal programs and a system for tracking contracts in order to ensure compliance with federal award programs and to completeness and accuracy in SEFA reporting.Questioned Costs: NoneManagement Response and Corrective Action Plan: See Corrective Action PlanContact Person: Mansour Camara, CFO
2022-002 Reporting ? Schedule of Expenditures of Federal AwardsIdentification as a Repeat Finding: Repeat of Finding 2021-004.Finding:The SEFA provided for audit contained errors in identifying programs, program clusters and expenditures of federal awards.Criteria:The Organization is responsible for maintaining accurate information about all federal programs and reporting requirements. The Organization is responsible for using this information to comply with the Uniform Guidance in carrying out federal programs.Sample Size and Population: N/ACondition and Context:The original SEFA provided for audit contained errors in identifying programs, program clusters and expenditures of federal awards including the following:? 21.019 Coronavirus Relief Fund excluded. Contracts 4120 & 8328 passed through by the United Way of King County & the contract passed through by the Washington State Housing Finance Commission (WSHFC) totaled $205,822 but were not included in the original SEFA provided.? 21.023 Emergency Rental Assistance Program Contract 9395 passed through by the United Way of King County understated by $341,000.? 21.023 Emergency Rental Assistance Program Contract excluded. Contract 8366 passed through by the United Way of King County included $8,274,601 of federal funds that were not included on the original SEFA provided for audit.? 21.026 Homeowner Assistance Fund contact #HAF0025 passed through by WSHFC overstated by $124,710.? 91.024 Emergency Food and Shelter contract #889000-033 passed through by United Way of King County overstated by $66,542.? 17.258 WIOA Title 1b Adult Services contract #21-115-ADU passed through by Workforce Development Council of King County not identified as part of the WIOA Cluster.Additionally, the prior year SEFA was overstated by $704,017 for the 20.019 Coronavirus Relief Fund Contracts #4120 and #8328 passed through by the United Way of King County due to the accounting error identified in Finding 2022-001.Effect:Inaccurate identification of programs subject to the Single Audit increases the risk that the Organization will not comply with the terms and conditions of federal programs.Cause:As noted in Finding 2022-001, the Organization did not correctly account for advanced federal funds and as noted in Finding 2022-003, the Organization has not implemented a policy for advanced federal funds that complies with 2 CFR 200.305. These gaps in internal control resulted in cut-off errors in SEFA reporting for FY21 & FY22. Additionally, the Organization has not been applying the guidance of Section 200.502 of the Uniform Guidance in preparing the SEFA. Lastly, the program manager of the pass through agency of the 21.023 Emergency Rental Assistance Program Contract #8366 incorrectly informed the Organization that it had no responsibility for reporting the contract as a subrecipient of federal funds.Recommendation:The Organization must continue to increase its familiarity with federal grant compliance requirements and establish a process for timely identification of federal programs and a system for tracking contracts in order to ensure compliance with federal award programs and to completeness and accuracy in SEFA reporting.Questioned Costs: NoneManagement Response and Corrective Action Plan: See Corrective Action PlanContact Person: Mansour Camara, CFO
2022-002 Reporting ? Schedule of Expenditures of Federal AwardsIdentification as a Repeat Finding: Repeat of Finding 2021-004.Finding:The SEFA provided for audit contained errors in identifying programs, program clusters and expenditures of federal awards.Criteria:The Organization is responsible for maintaining accurate information about all federal programs and reporting requirements. The Organization is responsible for using this information to comply with the Uniform Guidance in carrying out federal programs.Sample Size and Population: N/ACondition and Context:The original SEFA provided for audit contained errors in identifying programs, program clusters and expenditures of federal awards including the following:? 21.019 Coronavirus Relief Fund excluded. Contracts 4120 & 8328 passed through by the United Way of King County & the contract passed through by the Washington State Housing Finance Commission (WSHFC) totaled $205,822 but were not included in the original SEFA provided.? 21.023 Emergency Rental Assistance Program Contract 9395 passed through by the United Way of King County understated by $341,000.? 21.023 Emergency Rental Assistance Program Contract excluded. Contract 8366 passed through by the United Way of King County included $8,274,601 of federal funds that were not included on the original SEFA provided for audit.? 21.026 Homeowner Assistance Fund contact #HAF0025 passed through by WSHFC overstated by $124,710.? 91.024 Emergency Food and Shelter contract #889000-033 passed through by United Way of King County overstated by $66,542.? 17.258 WIOA Title 1b Adult Services contract #21-115-ADU passed through by Workforce Development Council of King County not identified as part of the WIOA Cluster.Additionally, the prior year SEFA was overstated by $704,017 for the 20.019 Coronavirus Relief Fund Contracts #4120 and #8328 passed through by the United Way of King County due to the accounting error identified in Finding 2022-001.Effect:Inaccurate identification of programs subject to the Single Audit increases the risk that the Organization will not comply with the terms and conditions of federal programs.Cause:As noted in Finding 2022-001, the Organization did not correctly account for advanced federal funds and as noted in Finding 2022-003, the Organization has not implemented a policy for advanced federal funds that complies with 2 CFR 200.305. These gaps in internal control resulted in cut-off errors in SEFA reporting for FY21 & FY22. Additionally, the Organization has not been applying the guidance of Section 200.502 of the Uniform Guidance in preparing the SEFA. Lastly, the program manager of the pass through agency of the 21.023 Emergency Rental Assistance Program Contract #8366 incorrectly informed the Organization that it had no responsibility for reporting the contract as a subrecipient of federal funds.Recommendation:The Organization must continue to increase its familiarity with federal grant compliance requirements and establish a process for timely identification of federal programs and a system for tracking contracts in order to ensure compliance with federal award programs and to completeness and accuracy in SEFA reporting.Questioned Costs: NoneManagement Response and Corrective Action Plan: See Corrective Action PlanContact Person: Mansour Camara, CFO
2022-002 Reporting ? Schedule of Expenditures of Federal AwardsIdentification as a Repeat Finding: Repeat of Finding 2021-004.Finding:The SEFA provided for audit contained errors in identifying programs, program clusters and expenditures of federal awards.Criteria:The Organization is responsible for maintaining accurate information about all federal programs and reporting requirements. The Organization is responsible for using this information to comply with the Uniform Guidance in carrying out federal programs.Sample Size and Population: N/ACondition and Context:The original SEFA provided for audit contained errors in identifying programs, program clusters and expenditures of federal awards including the following:? 21.019 Coronavirus Relief Fund excluded. Contracts 4120 & 8328 passed through by the United Way of King County & the contract passed through by the Washington State Housing Finance Commission (WSHFC) totaled $205,822 but were not included in the original SEFA provided.? 21.023 Emergency Rental Assistance Program Contract 9395 passed through by the United Way of King County understated by $341,000.? 21.023 Emergency Rental Assistance Program Contract excluded. Contract 8366 passed through by the United Way of King County included $8,274,601 of federal funds that were not included on the original SEFA provided for audit.? 21.026 Homeowner Assistance Fund contact #HAF0025 passed through by WSHFC overstated by $124,710.? 91.024 Emergency Food and Shelter contract #889000-033 passed through by United Way of King County overstated by $66,542.? 17.258 WIOA Title 1b Adult Services contract #21-115-ADU passed through by Workforce Development Council of King County not identified as part of the WIOA Cluster.Additionally, the prior year SEFA was overstated by $704,017 for the 20.019 Coronavirus Relief Fund Contracts #4120 and #8328 passed through by the United Way of King County due to the accounting error identified in Finding 2022-001.Effect:Inaccurate identification of programs subject to the Single Audit increases the risk that the Organization will not comply with the terms and conditions of federal programs.Cause:As noted in Finding 2022-001, the Organization did not correctly account for advanced federal funds and as noted in Finding 2022-003, the Organization has not implemented a policy for advanced federal funds that complies with 2 CFR 200.305. These gaps in internal control resulted in cut-off errors in SEFA reporting for FY21 & FY22. Additionally, the Organization has not been applying the guidance of Section 200.502 of the Uniform Guidance in preparing the SEFA. Lastly, the program manager of the pass through agency of the 21.023 Emergency Rental Assistance Program Contract #8366 incorrectly informed the Organization that it had no responsibility for reporting the contract as a subrecipient of federal funds.Recommendation:The Organization must continue to increase its familiarity with federal grant compliance requirements and establish a process for timely identification of federal programs and a system for tracking contracts in order to ensure compliance with federal award programs and to completeness and accuracy in SEFA reporting.Questioned Costs: NoneManagement Response and Corrective Action Plan: See Corrective Action PlanContact Person: Mansour Camara, CFO
2022-002 Reporting ? Schedule of Expenditures of Federal AwardsIdentification as a Repeat Finding: Repeat of Finding 2021-004.Finding:The SEFA provided for audit contained errors in identifying programs, program clusters and expenditures of federal awards.Criteria:The Organization is responsible for maintaining accurate information about all federal programs and reporting requirements. The Organization is responsible for using this information to comply with the Uniform Guidance in carrying out federal programs.Sample Size and Population: N/ACondition and Context:The original SEFA provided for audit contained errors in identifying programs, program clusters and expenditures of federal awards including the following:? 21.019 Coronavirus Relief Fund excluded. Contracts 4120 & 8328 passed through by the United Way of King County & the contract passed through by the Washington State Housing Finance Commission (WSHFC) totaled $205,822 but were not included in the original SEFA provided.? 21.023 Emergency Rental Assistance Program Contract 9395 passed through by the United Way of King County understated by $341,000.? 21.023 Emergency Rental Assistance Program Contract excluded. Contract 8366 passed through by the United Way of King County included $8,274,601 of federal funds that were not included on the original SEFA provided for audit.? 21.026 Homeowner Assistance Fund contact #HAF0025 passed through by WSHFC overstated by $124,710.? 91.024 Emergency Food and Shelter contract #889000-033 passed through by United Way of King County overstated by $66,542.? 17.258 WIOA Title 1b Adult Services contract #21-115-ADU passed through by Workforce Development Council of King County not identified as part of the WIOA Cluster.Additionally, the prior year SEFA was overstated by $704,017 for the 20.019 Coronavirus Relief Fund Contracts #4120 and #8328 passed through by the United Way of King County due to the accounting error identified in Finding 2022-001.Effect:Inaccurate identification of programs subject to the Single Audit increases the risk that the Organization will not comply with the terms and conditions of federal programs.Cause:As noted in Finding 2022-001, the Organization did not correctly account for advanced federal funds and as noted in Finding 2022-003, the Organization has not implemented a policy for advanced federal funds that complies with 2 CFR 200.305. These gaps in internal control resulted in cut-off errors in SEFA reporting for FY21 & FY22. Additionally, the Organization has not been applying the guidance of Section 200.502 of the Uniform Guidance in preparing the SEFA. Lastly, the program manager of the pass through agency of the 21.023 Emergency Rental Assistance Program Contract #8366 incorrectly informed the Organization that it had no responsibility for reporting the contract as a subrecipient of federal funds.Recommendation:The Organization must continue to increase its familiarity with federal grant compliance requirements and establish a process for timely identification of federal programs and a system for tracking contracts in order to ensure compliance with federal award programs and to completeness and accuracy in SEFA reporting.Questioned Costs: NoneManagement Response and Corrective Action Plan: See Corrective Action PlanContact Person: Mansour Camara, CFO