Information of the federal program: Federal Grantor: United States Department of Housing and Urban Development Assistance Listing No.: 14.241, Housing Opportunities for Persons with AIDS Ascension Ministry Market: Illinois Pass-Through Grantor: AIDS Foundation of Chicago Federal Grantor: United States Department of Justice Assistance Listing No.: 16.560, National Institute of Justice Research, Evaluation, and Development Project Grants Ascension Ministry Market: Texas Federal Grantor: United States Department of Justice Assistance Listing No.: 16.710, Public Safety Partnership and Community Policing Grants Ascension Ministry Market: Illinois Pass-Through Grantor: The Village of Arlington Heights Police Department Federal Grantor: United States Department of the Treasury Assistance Listing No.: 21.027, COVID-19 Coronavirus State and Local Fiscal Recovery Funds Ascension Ministry Market: Maryland Pass-Through Grantor: Mayor and City Council of Baltimore, through MONSE Federal Grantor: United States Department of Health and Human Services Assistance Listing No.: 93.650, Accountable Health Communities Ascension Ministry Market: Illinois Federal Grantor: United States Department of Health and Human Services Assistance Listing No.: 93.958, Block Grants for Community Mental Health Services Ascension Ministry Market: Illinois Pass-Through Grantor: The State of Illinois Department of Human Services Federal Grantor: United States Department of Homeland Security Assistance Listing No.: 97.036, Disaster Grants – Public Assistance (Presidentially Declared Disasters) Ascension Ministry Market: Florida Pass-Through Grantor: Florida Division of Emergency ManagementFederal Grantor: United States Department of Homeland Security Assistance Listing No.: 97.039, Hazard Mitigation Grant Ascension Ministry Market: Florida Pass-Through Grantor: Florida Division of Emergency Management Criteria or specific requirement (including statutory, regulatory, or other citation): Section 200.303 of the Uniform Guidance states the following regarding internal control: “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: A grant with expenditures of $55,702 under Assistance Listing No. 14.241 was not included on the preliminary schedule of expenditures of federal awards (the Schedule) provided by management; the final Schedule was corrected. (Alexian Brothers-Bonaventure House, Illinois) A grant with expenditures of $204,574 under Assistance Listing No. 16.560 was not included on the preliminary Schedule provided by management; the final Schedule was corrected. (Ascension Seton, Texas) Expenditures in the amount of $89,084 under Assistance Listing No. 16.710 were improperly classified as Assistance Listing No. 93.958; the final Schedule was corrected. (Presence Behavioral Health, Illinois) A grant with expenditures of $230,108 under Assistance Listing No. 21.027 was included on the preliminary Schedule and was subsequently excluded when it was identified as a beneficiary award and not a subrecipient award; the final Schedule was corrected (Ascension Via Christi Hospitals Wichita, Inc., Kansas). A grant with expenditures of $164,195 under Assistance Listing No. 21.027 was not included on the preliminary Schedule provided by management; the final Schedule was corrected. (St. Agnes Healthcare, Inc., Maryland) Expenditures under Assistance Listing No. 93.650 were reported twice on the preliminary Schedule, resulting in overstatement of $314,551; the final Schedule was corrected. (Alexian Brothers Hospital Network, Illinois) A grant with expenditures of $232,713 under Assistance Listing No. 97.039 was misclassified as Assistance Listing No. 97.036; the final Schedule was corrected. (St. Vincent’s Health System, Florida) Cause: Ascension’s (the System) internal controls in place over the preparation of the Schedule were not sufficient to properly accumulate and accurately report all expenditures of federal awards. Effect or Potential Effect: Inaccurate or improper reporting of expenditures results in a misstated Schedule and can also potentially result in insufficient testing of the major programs or improper identification of major programs for audit purposes. Questioned costs: None. Context:The table below shows the preliminary and adjusted assistance listing on the Schedule. See table/chart in the finding. Identification as a repeat finding, if applicable: The finding is not a repeat finding from the prior year. Recommendation: Management should implement more robust internal controls to ensure the assistance listing numbers are appropriately listed on the Schedule and all federal expenditures are appropriately identified and reported on the Schedule. Views of responsible officials: The System will enhance grant management award processes by revising its onboarding procedures and add additional controls to monitor for accuracy of the core data. Management will reinforce the importance of timeliness and accuracy of the SEFA reporting totals to facilitate accurate reporting. Award amounts were changed on the SEFA reporting schedules after management’s review was executed. Management will implement preventive controls to lock down market SEFA templates after management final review.
Information of the federal program: Federal Grantor: United States Department of Housing and Urban Development Assistance Listing No.: 14.241, Housing Opportunities for Persons with AIDS Ascension Ministry Market: Illinois Pass-Through Grantor: AIDS Foundation of Chicago Federal Grantor: United States Department of Justice Assistance Listing No.: 16.560, National Institute of Justice Research, Evaluation, and Development Project Grants Ascension Ministry Market: Texas Federal Grantor: United States Department of Justice Assistance Listing No.: 16.710, Public Safety Partnership and Community Policing Grants Ascension Ministry Market: Illinois Pass-Through Grantor: The Village of Arlington Heights Police Department Federal Grantor: United States Department of the Treasury Assistance Listing No.: 21.027, COVID-19 Coronavirus State and Local Fiscal Recovery Funds Ascension Ministry Market: Maryland Pass-Through Grantor: Mayor and City Council of Baltimore, through MONSE Federal Grantor: United States Department of Health and Human Services Assistance Listing No.: 93.650, Accountable Health Communities Ascension Ministry Market: Illinois Federal Grantor: United States Department of Health and Human Services Assistance Listing No.: 93.958, Block Grants for Community Mental Health Services Ascension Ministry Market: Illinois Pass-Through Grantor: The State of Illinois Department of Human Services Federal Grantor: United States Department of Homeland Security Assistance Listing No.: 97.036, Disaster Grants – Public Assistance (Presidentially Declared Disasters) Ascension Ministry Market: Florida Pass-Through Grantor: Florida Division of Emergency ManagementFederal Grantor: United States Department of Homeland Security Assistance Listing No.: 97.039, Hazard Mitigation Grant Ascension Ministry Market: Florida Pass-Through Grantor: Florida Division of Emergency Management Criteria or specific requirement (including statutory, regulatory, or other citation): Section 200.303 of the Uniform Guidance states the following regarding internal control: “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: A grant with expenditures of $55,702 under Assistance Listing No. 14.241 was not included on the preliminary schedule of expenditures of federal awards (the Schedule) provided by management; the final Schedule was corrected. (Alexian Brothers-Bonaventure House, Illinois) A grant with expenditures of $204,574 under Assistance Listing No. 16.560 was not included on the preliminary Schedule provided by management; the final Schedule was corrected. (Ascension Seton, Texas) Expenditures in the amount of $89,084 under Assistance Listing No. 16.710 were improperly classified as Assistance Listing No. 93.958; the final Schedule was corrected. (Presence Behavioral Health, Illinois) A grant with expenditures of $230,108 under Assistance Listing No. 21.027 was included on the preliminary Schedule and was subsequently excluded when it was identified as a beneficiary award and not a subrecipient award; the final Schedule was corrected (Ascension Via Christi Hospitals Wichita, Inc., Kansas). A grant with expenditures of $164,195 under Assistance Listing No. 21.027 was not included on the preliminary Schedule provided by management; the final Schedule was corrected. (St. Agnes Healthcare, Inc., Maryland) Expenditures under Assistance Listing No. 93.650 were reported twice on the preliminary Schedule, resulting in overstatement of $314,551; the final Schedule was corrected. (Alexian Brothers Hospital Network, Illinois) A grant with expenditures of $232,713 under Assistance Listing No. 97.039 was misclassified as Assistance Listing No. 97.036; the final Schedule was corrected. (St. Vincent’s Health System, Florida) Cause: Ascension’s (the System) internal controls in place over the preparation of the Schedule were not sufficient to properly accumulate and accurately report all expenditures of federal awards. Effect or Potential Effect: Inaccurate or improper reporting of expenditures results in a misstated Schedule and can also potentially result in insufficient testing of the major programs or improper identification of major programs for audit purposes. Questioned costs: None. Context:The table below shows the preliminary and adjusted assistance listing on the Schedule. See table/chart in the finding. Identification as a repeat finding, if applicable: The finding is not a repeat finding from the prior year. Recommendation: Management should implement more robust internal controls to ensure the assistance listing numbers are appropriately listed on the Schedule and all federal expenditures are appropriately identified and reported on the Schedule. Views of responsible officials: The System will enhance grant management award processes by revising its onboarding procedures and add additional controls to monitor for accuracy of the core data. Management will reinforce the importance of timeliness and accuracy of the SEFA reporting totals to facilitate accurate reporting. Award amounts were changed on the SEFA reporting schedules after management’s review was executed. Management will implement preventive controls to lock down market SEFA templates after management final review.
Information of the federal program: Federal Grantor: United States Department of Housing and Urban Development Assistance Listing No.: 14.241, Housing Opportunities for Persons with AIDS Ascension Ministry Market: Illinois Pass-Through Grantor: AIDS Foundation of Chicago Federal Grantor: United States Department of Justice Assistance Listing No.: 16.560, National Institute of Justice Research, Evaluation, and Development Project Grants Ascension Ministry Market: Texas Federal Grantor: United States Department of Justice Assistance Listing No.: 16.710, Public Safety Partnership and Community Policing Grants Ascension Ministry Market: Illinois Pass-Through Grantor: The Village of Arlington Heights Police Department Federal Grantor: United States Department of the Treasury Assistance Listing No.: 21.027, COVID-19 Coronavirus State and Local Fiscal Recovery Funds Ascension Ministry Market: Maryland Pass-Through Grantor: Mayor and City Council of Baltimore, through MONSE Federal Grantor: United States Department of Health and Human Services Assistance Listing No.: 93.650, Accountable Health Communities Ascension Ministry Market: Illinois Federal Grantor: United States Department of Health and Human Services Assistance Listing No.: 93.958, Block Grants for Community Mental Health Services Ascension Ministry Market: Illinois Pass-Through Grantor: The State of Illinois Department of Human Services Federal Grantor: United States Department of Homeland Security Assistance Listing No.: 97.036, Disaster Grants – Public Assistance (Presidentially Declared Disasters) Ascension Ministry Market: Florida Pass-Through Grantor: Florida Division of Emergency ManagementFederal Grantor: United States Department of Homeland Security Assistance Listing No.: 97.039, Hazard Mitigation Grant Ascension Ministry Market: Florida Pass-Through Grantor: Florida Division of Emergency Management Criteria or specific requirement (including statutory, regulatory, or other citation): Section 200.303 of the Uniform Guidance states the following regarding internal control: “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: A grant with expenditures of $55,702 under Assistance Listing No. 14.241 was not included on the preliminary schedule of expenditures of federal awards (the Schedule) provided by management; the final Schedule was corrected. (Alexian Brothers-Bonaventure House, Illinois) A grant with expenditures of $204,574 under Assistance Listing No. 16.560 was not included on the preliminary Schedule provided by management; the final Schedule was corrected. (Ascension Seton, Texas) Expenditures in the amount of $89,084 under Assistance Listing No. 16.710 were improperly classified as Assistance Listing No. 93.958; the final Schedule was corrected. (Presence Behavioral Health, Illinois) A grant with expenditures of $230,108 under Assistance Listing No. 21.027 was included on the preliminary Schedule and was subsequently excluded when it was identified as a beneficiary award and not a subrecipient award; the final Schedule was corrected (Ascension Via Christi Hospitals Wichita, Inc., Kansas). A grant with expenditures of $164,195 under Assistance Listing No. 21.027 was not included on the preliminary Schedule provided by management; the final Schedule was corrected. (St. Agnes Healthcare, Inc., Maryland) Expenditures under Assistance Listing No. 93.650 were reported twice on the preliminary Schedule, resulting in overstatement of $314,551; the final Schedule was corrected. (Alexian Brothers Hospital Network, Illinois) A grant with expenditures of $232,713 under Assistance Listing No. 97.039 was misclassified as Assistance Listing No. 97.036; the final Schedule was corrected. (St. Vincent’s Health System, Florida) Cause: Ascension’s (the System) internal controls in place over the preparation of the Schedule were not sufficient to properly accumulate and accurately report all expenditures of federal awards. Effect or Potential Effect: Inaccurate or improper reporting of expenditures results in a misstated Schedule and can also potentially result in insufficient testing of the major programs or improper identification of major programs for audit purposes. Questioned costs: None. Context:The table below shows the preliminary and adjusted assistance listing on the Schedule. See table/chart in the finding. Identification as a repeat finding, if applicable: The finding is not a repeat finding from the prior year. Recommendation: Management should implement more robust internal controls to ensure the assistance listing numbers are appropriately listed on the Schedule and all federal expenditures are appropriately identified and reported on the Schedule. Views of responsible officials: The System will enhance grant management award processes by revising its onboarding procedures and add additional controls to monitor for accuracy of the core data. Management will reinforce the importance of timeliness and accuracy of the SEFA reporting totals to facilitate accurate reporting. Award amounts were changed on the SEFA reporting schedules after management’s review was executed. Management will implement preventive controls to lock down market SEFA templates after management final review.
2023-001 Preparation of and Internal Controls over Schedule of Expenditures of Federal Awards Preparation (Material Weakness) Federal Agencies: U.S. Department of Education and U.S. Department of Homeland Security Program Names: Education Stabilization Fund and Disaster Grant – Public Assistance Assistance Listing Numbers: 84.425 and 97.036 Award Period: June 30, 2023 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, 2023. 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.
2023-001 Preparation of and Internal Controls over Schedule of Expenditures of Federal Awards Preparation (Material Weakness) Federal Agencies: U.S. Department of Education and U.S. Department of Homeland Security Program Names: Education Stabilization Fund and Disaster Grant – Public Assistance Assistance Listing Numbers: 84.425 and 97.036 Award Period: June 30, 2023 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, 2023. 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.
2023-004 Preparation of and Internal controls over Schedule of Expenditures of Federal Awards Preparation (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, 2023 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, 2023. 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.
2023-004 Preparation of and Internal controls over Schedule of Expenditures of Federal Awards Preparation (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, 2023 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, 2023. 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.
2023-004 Preparation of and Internal controls over Schedule of Expenditures of Federal Awards Preparation (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, 2023 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, 2023. 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.
2023-001: SEFA Reporting – R&D Classification Federal Agency: Department of Health and Human Services Federal Program Title: Medical Student Education Program, Prevention of Disease, Disability, and Death by Infection Diseases, and Postdoctoral Training in General Dentistry Assistance Listing Number: 93.680, 93.084, 93.059 Award Number and Year: T99HP39200 (July 1, 2020 – June 30, 2024), NU2GGH002319 (September 30, 2020 – September 29, 2024), D88HP375559200 (July 1, 2020 – June 30, 2024) Award Period: July 1, 2022 – June 30, 2023 Type of Finding: Material Weakness in Internal Control Over Compliance, Other Matters Applicable Institution: University of Mississippi Medical Center (UMMC) Criteria or Specific Requirement: Internal Control – Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should 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). Compliance – 2 CFR, Part 200 – Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, Subpart F, §200.510(b) requires that auditees 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. Condition: The Schedule of Expenditures of Federal Awards (SEFA) contained errors and incorrect information which affected the major program determination. Questioned Costs: None noted as the reporting requirement does not affect the allowability of costs and/or activities. Context: The following SEFA errors were noted: • Amounts provided by UMMC incorrectly reported $4,558,549 in the Research & Development Cluster that should have been classified as expenditures for the Medical Student Education program (Assistance Listing 93.680). • Amounts provided by UMMC incorrectly reported $622,758 in the Research & Development Cluster that should have been classified as expenditures for the Prevention of Disease, Disability, and Death by Infection Diseases Program (Assistance Listing 93.084). • Amounts provided by UMMC incorrectly reported $383,695 in the Research & Development Cluster that should have been classified as expenditures for the Postdoctoral Training in General Dentistry Program (Assistance Listing 93.059). Cause: Awards were incorrectly coded as Research & Development during the award set-up process. Effect: The SEFA was not prepared in accordance with OMB requirements which affects the major program risk assessment. Repeat Finding: 2022-002 Recommendation: We recommend the institution review and revise its current reporting procedures and review requirements to ensure that federal expenditures are properly identified and classified. Views of Responsible Officials: There is no disagreement with the audit finding.
2023-001: SEFA Reporting – R&D Classification Federal Agency: Department of Health and Human Services Federal Program Title: Medical Student Education Program, Prevention of Disease, Disability, and Death by Infection Diseases, and Postdoctoral Training in General Dentistry Assistance Listing Number: 93.680, 93.084, 93.059 Award Number and Year: T99HP39200 (July 1, 2020 – June 30, 2024), NU2GGH002319 (September 30, 2020 – September 29, 2024), D88HP375559200 (July 1, 2020 – June 30, 2024) Award Period: July 1, 2022 – June 30, 2023 Type of Finding: Material Weakness in Internal Control Over Compliance, Other Matters Applicable Institution: University of Mississippi Medical Center (UMMC) Criteria or Specific Requirement: Internal Control – Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should 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). Compliance – 2 CFR, Part 200 – Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, Subpart F, §200.510(b) requires that auditees 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. Condition: The Schedule of Expenditures of Federal Awards (SEFA) contained errors and incorrect information which affected the major program determination. Questioned Costs: None noted as the reporting requirement does not affect the allowability of costs and/or activities. Context: The following SEFA errors were noted: • Amounts provided by UMMC incorrectly reported $4,558,549 in the Research & Development Cluster that should have been classified as expenditures for the Medical Student Education program (Assistance Listing 93.680). • Amounts provided by UMMC incorrectly reported $622,758 in the Research & Development Cluster that should have been classified as expenditures for the Prevention of Disease, Disability, and Death by Infection Diseases Program (Assistance Listing 93.084). • Amounts provided by UMMC incorrectly reported $383,695 in the Research & Development Cluster that should have been classified as expenditures for the Postdoctoral Training in General Dentistry Program (Assistance Listing 93.059). Cause: Awards were incorrectly coded as Research & Development during the award set-up process. Effect: The SEFA was not prepared in accordance with OMB requirements which affects the major program risk assessment. Repeat Finding: 2022-002 Recommendation: We recommend the institution review and revise its current reporting procedures and review requirements to ensure that federal expenditures are properly identified and classified. Views of Responsible Officials: There is no disagreement with the audit finding.
2023-001: SEFA Reporting – R&D Classification Federal Agency: Department of Health and Human Services Federal Program Title: Medical Student Education Program, Prevention of Disease, Disability, and Death by Infection Diseases, and Postdoctoral Training in General Dentistry Assistance Listing Number: 93.680, 93.084, 93.059 Award Number and Year: T99HP39200 (July 1, 2020 – June 30, 2024), NU2GGH002319 (September 30, 2020 – September 29, 2024), D88HP375559200 (July 1, 2020 – June 30, 2024) Award Period: July 1, 2022 – June 30, 2023 Type of Finding: Material Weakness in Internal Control Over Compliance, Other Matters Applicable Institution: University of Mississippi Medical Center (UMMC) Criteria or Specific Requirement: Internal Control – Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should 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). Compliance – 2 CFR, Part 200 – Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, Subpart F, §200.510(b) requires that auditees 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. Condition: The Schedule of Expenditures of Federal Awards (SEFA) contained errors and incorrect information which affected the major program determination. Questioned Costs: None noted as the reporting requirement does not affect the allowability of costs and/or activities. Context: The following SEFA errors were noted: • Amounts provided by UMMC incorrectly reported $4,558,549 in the Research & Development Cluster that should have been classified as expenditures for the Medical Student Education program (Assistance Listing 93.680). • Amounts provided by UMMC incorrectly reported $622,758 in the Research & Development Cluster that should have been classified as expenditures for the Prevention of Disease, Disability, and Death by Infection Diseases Program (Assistance Listing 93.084). • Amounts provided by UMMC incorrectly reported $383,695 in the Research & Development Cluster that should have been classified as expenditures for the Postdoctoral Training in General Dentistry Program (Assistance Listing 93.059). Cause: Awards were incorrectly coded as Research & Development during the award set-up process. Effect: The SEFA was not prepared in accordance with OMB requirements which affects the major program risk assessment. Repeat Finding: 2022-002 Recommendation: We recommend the institution review and revise its current reporting procedures and review requirements to ensure that federal expenditures are properly identified and classified. Views of Responsible Officials: There is no disagreement with the audit finding.
2023-002: SEFA Reporting- Incorrect Assistance Listing Numbers, Non-Federal Amounts on SEFA Federal Agency: Department of Education Federal Program Title: Title I, Special Education Grants to States, Career and Technical Education Assistance Listing Number: 84.010, 84.027, 84.048 Award Number and Year: VS010A0180024 (July 1, 2020 – June 30, 2023), H027A190108 (July 1, 2020 – June 30, 2023), V048A190024 (July 1, 2020 – June 30, 2023) Award Period: July 1, 2022 – June 30, 2023 Type of Finding: Material Weakness in Internal Control Over Compliance, Other Matters Applicable Institution: Mississippi State University (MSU) Criteria or Specific Requirement: Internal Control – Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should 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). Compliance – 2 CFR, Part 200 – Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, Subpart F, §200.510(b) requires that auditees 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. Condition: The Schedule of Expenditures of Federal Awards (SEFA) contained errors and incorrect information which affected the major program determination. Questioned Costs: None noted as the reporting requirement does not affect the allowability of costs and/or activities. Context: The following SEFA errors were noted: • Amounts provided by MSU incorrectly reported $371,067 in the Title I Program (Assistance Listing 84.010) that should have been reported in Special Education Grants to States (Assistance Listing Number 84.027). • Amounts provided by MSU incorrectly reported $902,101 in the Title I Program (Assistance Listing 84.010) that should have been reported in Career and Technical Education (Assistance Listing Number 84.048). • Amounts provided by MSU incorrectly reported $2,011,409 in the Title I Program (Assistance Listing 84.010) that were State Grants and not reportable on the SEFA. Cause: Mississippi State University did not have a process in place for awards that includes multiple ALNs and sources of funding. Effect: The SEFA was not prepared in accordance with OMB requirements which affects the major program risk assessment. Repeat Finding: 2022-002 Recommendation: We recommend the institution review and revise its current reporting procedures and review requirements to ensure that federal expenditures are properly identified and classified. Views of Responsible Officials: There is no disagreement with the audit finding.
2023-002: SEFA Reporting- Incorrect Assistance Listing Numbers, Non-Federal Amounts on SEFA Federal Agency: Department of Education Federal Program Title: Title I, Special Education Grants to States, Career and Technical Education Assistance Listing Number: 84.010, 84.027, 84.048 Award Number and Year: VS010A0180024 (July 1, 2020 – June 30, 2023), H027A190108 (July 1, 2020 – June 30, 2023), V048A190024 (July 1, 2020 – June 30, 2023) Award Period: July 1, 2022 – June 30, 2023 Type of Finding: Material Weakness in Internal Control Over Compliance, Other Matters Applicable Institution: Mississippi State University (MSU) Criteria or Specific Requirement: Internal Control – Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should 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). Compliance – 2 CFR, Part 200 – Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, Subpart F, §200.510(b) requires that auditees 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. Condition: The Schedule of Expenditures of Federal Awards (SEFA) contained errors and incorrect information which affected the major program determination. Questioned Costs: None noted as the reporting requirement does not affect the allowability of costs and/or activities. Context: The following SEFA errors were noted: • Amounts provided by MSU incorrectly reported $371,067 in the Title I Program (Assistance Listing 84.010) that should have been reported in Special Education Grants to States (Assistance Listing Number 84.027). • Amounts provided by MSU incorrectly reported $902,101 in the Title I Program (Assistance Listing 84.010) that should have been reported in Career and Technical Education (Assistance Listing Number 84.048). • Amounts provided by MSU incorrectly reported $2,011,409 in the Title I Program (Assistance Listing 84.010) that were State Grants and not reportable on the SEFA. Cause: Mississippi State University did not have a process in place for awards that includes multiple ALNs and sources of funding. Effect: The SEFA was not prepared in accordance with OMB requirements which affects the major program risk assessment. Repeat Finding: 2022-002 Recommendation: We recommend the institution review and revise its current reporting procedures and review requirements to ensure that federal expenditures are properly identified and classified. Views of Responsible Officials: There is no disagreement with the audit finding.
2023-002: SEFA Reporting- Incorrect Assistance Listing Numbers, Non-Federal Amounts on SEFA Federal Agency: Department of Education Federal Program Title: Title I, Special Education Grants to States, Career and Technical Education Assistance Listing Number: 84.010, 84.027, 84.048 Award Number and Year: VS010A0180024 (July 1, 2020 – June 30, 2023), H027A190108 (July 1, 2020 – June 30, 2023), V048A190024 (July 1, 2020 – June 30, 2023) Award Period: July 1, 2022 – June 30, 2023 Type of Finding: Material Weakness in Internal Control Over Compliance, Other Matters Applicable Institution: Mississippi State University (MSU) Criteria or Specific Requirement: Internal Control – Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should 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). Compliance – 2 CFR, Part 200 – Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, Subpart F, §200.510(b) requires that auditees 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. Condition: The Schedule of Expenditures of Federal Awards (SEFA) contained errors and incorrect information which affected the major program determination. Questioned Costs: None noted as the reporting requirement does not affect the allowability of costs and/or activities. Context: The following SEFA errors were noted: • Amounts provided by MSU incorrectly reported $371,067 in the Title I Program (Assistance Listing 84.010) that should have been reported in Special Education Grants to States (Assistance Listing Number 84.027). • Amounts provided by MSU incorrectly reported $902,101 in the Title I Program (Assistance Listing 84.010) that should have been reported in Career and Technical Education (Assistance Listing Number 84.048). • Amounts provided by MSU incorrectly reported $2,011,409 in the Title I Program (Assistance Listing 84.010) that were State Grants and not reportable on the SEFA. Cause: Mississippi State University did not have a process in place for awards that includes multiple ALNs and sources of funding. Effect: The SEFA was not prepared in accordance with OMB requirements which affects the major program risk assessment. Repeat Finding: 2022-002 Recommendation: We recommend the institution review and revise its current reporting procedures and review requirements to ensure that federal expenditures are properly identified and classified. Views of Responsible Officials: There is no disagreement with the audit finding.
2023-003: SEFA Reporting –Expenditures Recorded in the Incorrect Period Federal Agency: Department of Health and Human Services Federal Program Title: Telehealth Center of Excellence Assistance Listing Number: 93.211 Award Number and Year: U6631459 (September 1, 2021 – September 29, 2026) Award Period: July 1, 2022 – June 30, 2023 Type of Finding: Significant Deficiency in Internal Control Over Compliance, Other Matters Applicable Institution: University of Mississippi Medical Center (UMMC) Criteria or Specific Requirement: Internal Control – Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should 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). Compliance – 2 CFR, Part 200 – Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, Subpart F, §200.510(b) requires that auditees 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. Condition: Schedule of Expenditures of Federal Awards (SEFA) contained salary expenses of $1,175 that were not allowable and should have been removed from the SEFA. Questioned Costs: None. Context: For 1 out of 60 payroll expenditures selected for testing, the amount was not allowable and should not have been charged to the grant. Cause: Transfer of project expenditures occurred late and resulted in effort not being certified for salary amount in question. As a result, the salary was not reported to the sponsor via an invoice or financial report. However, the department did not remove the salary expenditure from the project in a timely manner. Effect: The SEFA does not reflect the accurate amount of federal expenditures for the year. Repeat Finding: 2022-002 Recommendation: We recommend the institutions review and revise its current reporting procedures and review requirements to ensure that federal expenditures are properly identified, recorded, and classified in the accurate year. Views of Responsible Officials: There is no disagreement with the audit finding.
Federal Program Information: Transition Program for Students with Intellectual Disabilities into Higher Education Grant (ALN: 84.407A). Criteria or Specific Requirement (Including Statutory, Regulatory or Other Citation): The auditee must 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. At a minimum, the schedule must: (1) 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. (2) 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. (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. (5) 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. (6) 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 (2 CFR section 200.510(b)). Condition: For certain Federal grant programs presented on the SEFA, the total amount provided to subrecipients during the year was not included. Cause: Administrative oversight with respect to SEFA preparation. Effect or Potential Effect: The University was not in compliance with SEFA presentation and disclosure requirements. Questioned Costs: None. Context: The University did not properly present and disclose approximately $162,000 of funds passed to subrecipients under the Transition Programs for Students with Intellectual Disabilities into Higher Education grant (ALN 84.407A) on the SEFA for the year ended June 30, 2023. Identification as a Repeat Finding: No similar findings noted in the prior year. Recommendation: We recommend the University enhance its policies and procedures to ensure that the SEFA has been prepared in accordance with the required guidelines and that it contains all minimum required elements that must be presented and disclosed, in accordance with federal regulations. Views of Responsible Officials and Planned Corrective Actions: The University Finance department has updated their policies and procedures to ensure that the SEFA is being prepared in accordance with required guidelines. We will work closely with our grants department to ensure all required elements are properly identified and disclosed.
Condition – The Corporation did not report $2,000,000 of CSLFRF grant expenditures received by Saint Agnes Medical Center Fresno (“Fresno”) in the consolidated SEFA for the year ended June 30, 2022. This resulted in an understatement of CSLFRF expenditures on the Corporation’s SEFA for the year ended June 30, 2022. This issue was discussed with the County of Fresno, the pass-through granting agency for this program, who requested the omitted CSLFRF expenditures be tested and included in the Corporation’s SEFA for the year ended June 30, 2023. Criteria – According to § 200.510(b) of the Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for 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.” Cause – The Fresno accounting department reported the CSLFRF grant to the Trinity Health Financial Reporting team incorrectly which resulted in the Fresno CSLFRF grant not being included in ALN 21.027, which was a major program for the year ended June 30, 2022. Effect – The Corporation’s SEFA for the year ended June 30, 2022 was understated by $2,000,000. Consequences for failure to comply with grant conditions may include a reduction of overall award and/or a restriction or reduction in future awards. Questioned costs – None Context – The Corporation did not report $2,000,000 of CSLFRF funds on its prior year SEFA. Repeat Finding from Prior Year – No Recommendation – The Corporation should institute additional policies and procedures to ensure grant expenditures reported by all locations are appropriately and completely included in the consolidated SEFA.
2023-001 Program: CDBG - Entitlement Grants Cluster / Highway Planning and Construction / Nationally Significant Freight and Highway Project Funds Federal Financial Assistance Listing No.: 14.218 / 20.205 / 20.934 Federal Agency: U.S. Department of Housing and Urban Development / U.S. Department of Transportation Direct Award: U.S. Department of Housing and Urban Development Pass-through: California Department of Transportation in relation to the Highway Planning and Construction and Nationally Significant Freight and Highway Project Funds Award Year: Multiple Grant Award Number: Multiple Compliance Requirements: Other - Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) §200.510(b) - Schedule of expenditures of Federal awards Type of Finding: Material Weakness in Internal Control over Compliance Criteria: Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) §200.510(b) states that the auditee (the City) must 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. In addition, §200.303 of the Uniform Guidance states that the City must establish and maintain effective internal control over the federal awards, including controls over the accuracy of program information and expenditure amounts. Condition: During our audit procedures performed over the SEFA and expenditures reported for the CDBG - Entitlement Grants Cluster, Highway Planning and Construction, and Nationally Significant Freight and Highway Project Funds, we noted the following: 1. The City did not properly identify the amount expended for the CDBG - Entitlement Grants Cluster, AL No. 14.218. The expenditures reported by the City were understated by $154,071. 2. The City did not properly identify the amount expended for the Highway Planning and Construction, AL No. 20.205. The expenditures reported by the City were overstated by $5,098,179. 3. The City did not properly classify the amount expended for the Nationally Significant Freight and Highway Project Funds, AL No. 20.934. The expenditures reported by the City were understated by $2,769,610. Cause: As a result, the City lacks adequate internal controls to ensure the SEFA is completely and accurately stated. Specifically, the City’s processes for recording and tracking expenditures of federal awards are not designed so that expenditures are identified when incurred and assigned to the correct program name or cluster in a complete and timely manner. Effect: The SEFA, as originally presented, was overstated by $2,174,498. Questioned Costs: No questioned costs were identified as a result of our procedures. Context/Sampling: No sampling was used. Program expenditures on the SEFA were reconciled to supporting records. Repeat Finding from the Prior Year(s): No. Recommendation: The City should establish policies and implement internal controls to ensure all federal expenditures are accurately tracked and reported on the SEFA. Personnel knowledgeable of federal expenditures should review amounts coded to federal programs for completeness and accuracy. The SEFA should be prepared and reviewed in a timely manner and reconciled to underlying records as well as the basic financial statements. View of Responsible Official and Planned Corrective Actions See separate corrective action plan.
2023-001 Program: CDBG - Entitlement Grants Cluster / Highway Planning and Construction / Nationally Significant Freight and Highway Project Funds Federal Financial Assistance Listing No.: 14.218 / 20.205 / 20.934 Federal Agency: U.S. Department of Housing and Urban Development / U.S. Department of Transportation Direct Award: U.S. Department of Housing and Urban Development Pass-through: California Department of Transportation in relation to the Highway Planning and Construction and Nationally Significant Freight and Highway Project Funds Award Year: Multiple Grant Award Number: Multiple Compliance Requirements: Other - Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) §200.510(b) - Schedule of expenditures of Federal awards Type of Finding: Material Weakness in Internal Control over Compliance Criteria: Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) §200.510(b) states that the auditee (the City) must 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. In addition, §200.303 of the Uniform Guidance states that the City must establish and maintain effective internal control over the federal awards, including controls over the accuracy of program information and expenditure amounts. Condition: During our audit procedures performed over the SEFA and expenditures reported for the CDBG - Entitlement Grants Cluster, Highway Planning and Construction, and Nationally Significant Freight and Highway Project Funds, we noted the following: 1. The City did not properly identify the amount expended for the CDBG - Entitlement Grants Cluster, AL No. 14.218. The expenditures reported by the City were understated by $154,071. 2. The City did not properly identify the amount expended for the Highway Planning and Construction, AL No. 20.205. The expenditures reported by the City were overstated by $5,098,179. 3. The City did not properly classify the amount expended for the Nationally Significant Freight and Highway Project Funds, AL No. 20.934. The expenditures reported by the City were understated by $2,769,610. Cause: As a result, the City lacks adequate internal controls to ensure the SEFA is completely and accurately stated. Specifically, the City’s processes for recording and tracking expenditures of federal awards are not designed so that expenditures are identified when incurred and assigned to the correct program name or cluster in a complete and timely manner. Effect: The SEFA, as originally presented, was overstated by $2,174,498. Questioned Costs: No questioned costs were identified as a result of our procedures. Context/Sampling: No sampling was used. Program expenditures on the SEFA were reconciled to supporting records. Repeat Finding from the Prior Year(s): No. Recommendation: The City should establish policies and implement internal controls to ensure all federal expenditures are accurately tracked and reported on the SEFA. Personnel knowledgeable of federal expenditures should review amounts coded to federal programs for completeness and accuracy. The SEFA should be prepared and reviewed in a timely manner and reconciled to underlying records as well as the basic financial statements. View of Responsible Official and Planned Corrective Actions See separate corrective action plan.
2023-001 Program: CDBG - Entitlement Grants Cluster / Highway Planning and Construction / Nationally Significant Freight and Highway Project Funds Federal Financial Assistance Listing No.: 14.218 / 20.205 / 20.934 Federal Agency: U.S. Department of Housing and Urban Development / U.S. Department of Transportation Direct Award: U.S. Department of Housing and Urban Development Pass-through: California Department of Transportation in relation to the Highway Planning and Construction and Nationally Significant Freight and Highway Project Funds Award Year: Multiple Grant Award Number: Multiple Compliance Requirements: Other - Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) §200.510(b) - Schedule of expenditures of Federal awards Type of Finding: Material Weakness in Internal Control over Compliance Criteria: Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) §200.510(b) states that the auditee (the City) must 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. In addition, §200.303 of the Uniform Guidance states that the City must establish and maintain effective internal control over the federal awards, including controls over the accuracy of program information and expenditure amounts. Condition: During our audit procedures performed over the SEFA and expenditures reported for the CDBG - Entitlement Grants Cluster, Highway Planning and Construction, and Nationally Significant Freight and Highway Project Funds, we noted the following: 1. The City did not properly identify the amount expended for the CDBG - Entitlement Grants Cluster, AL No. 14.218. The expenditures reported by the City were understated by $154,071. 2. The City did not properly identify the amount expended for the Highway Planning and Construction, AL No. 20.205. The expenditures reported by the City were overstated by $5,098,179. 3. The City did not properly classify the amount expended for the Nationally Significant Freight and Highway Project Funds, AL No. 20.934. The expenditures reported by the City were understated by $2,769,610. Cause: As a result, the City lacks adequate internal controls to ensure the SEFA is completely and accurately stated. Specifically, the City’s processes for recording and tracking expenditures of federal awards are not designed so that expenditures are identified when incurred and assigned to the correct program name or cluster in a complete and timely manner. Effect: The SEFA, as originally presented, was overstated by $2,174,498. Questioned Costs: No questioned costs were identified as a result of our procedures. Context/Sampling: No sampling was used. Program expenditures on the SEFA were reconciled to supporting records. Repeat Finding from the Prior Year(s): No. Recommendation: The City should establish policies and implement internal controls to ensure all federal expenditures are accurately tracked and reported on the SEFA. Personnel knowledgeable of federal expenditures should review amounts coded to federal programs for completeness and accuracy. The SEFA should be prepared and reviewed in a timely manner and reconciled to underlying records as well as the basic financial statements. View of Responsible Official and Planned Corrective Actions See separate corrective action plan.
2023-001 Program: CDBG - Entitlement Grants Cluster / Highway Planning and Construction / Nationally Significant Freight and Highway Project Funds Federal Financial Assistance Listing No.: 14.218 / 20.205 / 20.934 Federal Agency: U.S. Department of Housing and Urban Development / U.S. Department of Transportation Direct Award: U.S. Department of Housing and Urban Development Pass-through: California Department of Transportation in relation to the Highway Planning and Construction and Nationally Significant Freight and Highway Project Funds Award Year: Multiple Grant Award Number: Multiple Compliance Requirements: Other - Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) §200.510(b) - Schedule of expenditures of Federal awards Type of Finding: Material Weakness in Internal Control over Compliance Criteria: Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) §200.510(b) states that the auditee (the City) must 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. In addition, §200.303 of the Uniform Guidance states that the City must establish and maintain effective internal control over the federal awards, including controls over the accuracy of program information and expenditure amounts. Condition: During our audit procedures performed over the SEFA and expenditures reported for the CDBG - Entitlement Grants Cluster, Highway Planning and Construction, and Nationally Significant Freight and Highway Project Funds, we noted the following: 1. The City did not properly identify the amount expended for the CDBG - Entitlement Grants Cluster, AL No. 14.218. The expenditures reported by the City were understated by $154,071. 2. The City did not properly identify the amount expended for the Highway Planning and Construction, AL No. 20.205. The expenditures reported by the City were overstated by $5,098,179. 3. The City did not properly classify the amount expended for the Nationally Significant Freight and Highway Project Funds, AL No. 20.934. The expenditures reported by the City were understated by $2,769,610. Cause: As a result, the City lacks adequate internal controls to ensure the SEFA is completely and accurately stated. Specifically, the City’s processes for recording and tracking expenditures of federal awards are not designed so that expenditures are identified when incurred and assigned to the correct program name or cluster in a complete and timely manner. Effect: The SEFA, as originally presented, was overstated by $2,174,498. Questioned Costs: No questioned costs were identified as a result of our procedures. Context/Sampling: No sampling was used. Program expenditures on the SEFA were reconciled to supporting records. Repeat Finding from the Prior Year(s): No. Recommendation: The City should establish policies and implement internal controls to ensure all federal expenditures are accurately tracked and reported on the SEFA. Personnel knowledgeable of federal expenditures should review amounts coded to federal programs for completeness and accuracy. The SEFA should be prepared and reviewed in a timely manner and reconciled to underlying records as well as the basic financial statements. View of Responsible Official and Planned Corrective Actions See separate corrective action plan.
2023-001 Program: CDBG - Entitlement Grants Cluster / Highway Planning and Construction / Nationally Significant Freight and Highway Project Funds Federal Financial Assistance Listing No.: 14.218 / 20.205 / 20.934 Federal Agency: U.S. Department of Housing and Urban Development / U.S. Department of Transportation Direct Award: U.S. Department of Housing and Urban Development Pass-through: California Department of Transportation in relation to the Highway Planning and Construction and Nationally Significant Freight and Highway Project Funds Award Year: Multiple Grant Award Number: Multiple Compliance Requirements: Other - Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) §200.510(b) - Schedule of expenditures of Federal awards Type of Finding: Material Weakness in Internal Control over Compliance Criteria: Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) §200.510(b) states that the auditee (the City) must 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. In addition, §200.303 of the Uniform Guidance states that the City must establish and maintain effective internal control over the federal awards, including controls over the accuracy of program information and expenditure amounts. Condition: During our audit procedures performed over the SEFA and expenditures reported for the CDBG - Entitlement Grants Cluster, Highway Planning and Construction, and Nationally Significant Freight and Highway Project Funds, we noted the following: 1. The City did not properly identify the amount expended for the CDBG - Entitlement Grants Cluster, AL No. 14.218. The expenditures reported by the City were understated by $154,071. 2. The City did not properly identify the amount expended for the Highway Planning and Construction, AL No. 20.205. The expenditures reported by the City were overstated by $5,098,179. 3. The City did not properly classify the amount expended for the Nationally Significant Freight and Highway Project Funds, AL No. 20.934. The expenditures reported by the City were understated by $2,769,610. Cause: As a result, the City lacks adequate internal controls to ensure the SEFA is completely and accurately stated. Specifically, the City’s processes for recording and tracking expenditures of federal awards are not designed so that expenditures are identified when incurred and assigned to the correct program name or cluster in a complete and timely manner. Effect: The SEFA, as originally presented, was overstated by $2,174,498. Questioned Costs: No questioned costs were identified as a result of our procedures. Context/Sampling: No sampling was used. Program expenditures on the SEFA were reconciled to supporting records. Repeat Finding from the Prior Year(s): No. Recommendation: The City should establish policies and implement internal controls to ensure all federal expenditures are accurately tracked and reported on the SEFA. Personnel knowledgeable of federal expenditures should review amounts coded to federal programs for completeness and accuracy. The SEFA should be prepared and reviewed in a timely manner and reconciled to underlying records as well as the basic financial statements. View of Responsible Official and Planned Corrective Actions See separate corrective action plan.
2023-001 Program: CDBG - Entitlement Grants Cluster / Highway Planning and Construction / Nationally Significant Freight and Highway Project Funds Federal Financial Assistance Listing No.: 14.218 / 20.205 / 20.934 Federal Agency: U.S. Department of Housing and Urban Development / U.S. Department of Transportation Direct Award: U.S. Department of Housing and Urban Development Pass-through: California Department of Transportation in relation to the Highway Planning and Construction and Nationally Significant Freight and Highway Project Funds Award Year: Multiple Grant Award Number: Multiple Compliance Requirements: Other - Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) §200.510(b) - Schedule of expenditures of Federal awards Type of Finding: Material Weakness in Internal Control over Compliance Criteria: Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) §200.510(b) states that the auditee (the City) must 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. In addition, §200.303 of the Uniform Guidance states that the City must establish and maintain effective internal control over the federal awards, including controls over the accuracy of program information and expenditure amounts. Condition: During our audit procedures performed over the SEFA and expenditures reported for the CDBG - Entitlement Grants Cluster, Highway Planning and Construction, and Nationally Significant Freight and Highway Project Funds, we noted the following: 1. The City did not properly identify the amount expended for the CDBG - Entitlement Grants Cluster, AL No. 14.218. The expenditures reported by the City were understated by $154,071. 2. The City did not properly identify the amount expended for the Highway Planning and Construction, AL No. 20.205. The expenditures reported by the City were overstated by $5,098,179. 3. The City did not properly classify the amount expended for the Nationally Significant Freight and Highway Project Funds, AL No. 20.934. The expenditures reported by the City were understated by $2,769,610. Cause: As a result, the City lacks adequate internal controls to ensure the SEFA is completely and accurately stated. Specifically, the City’s processes for recording and tracking expenditures of federal awards are not designed so that expenditures are identified when incurred and assigned to the correct program name or cluster in a complete and timely manner. Effect: The SEFA, as originally presented, was overstated by $2,174,498. Questioned Costs: No questioned costs were identified as a result of our procedures. Context/Sampling: No sampling was used. Program expenditures on the SEFA were reconciled to supporting records. Repeat Finding from the Prior Year(s): No. Recommendation: The City should establish policies and implement internal controls to ensure all federal expenditures are accurately tracked and reported on the SEFA. Personnel knowledgeable of federal expenditures should review amounts coded to federal programs for completeness and accuracy. The SEFA should be prepared and reviewed in a timely manner and reconciled to underlying records as well as the basic financial statements. View of Responsible Official and Planned Corrective Actions See separate corrective action plan.
2023-001 Program: CDBG - Entitlement Grants Cluster / Highway Planning and Construction / Nationally Significant Freight and Highway Project Funds Federal Financial Assistance Listing No.: 14.218 / 20.205 / 20.934 Federal Agency: U.S. Department of Housing and Urban Development / U.S. Department of Transportation Direct Award: U.S. Department of Housing and Urban Development Pass-through: California Department of Transportation in relation to the Highway Planning and Construction and Nationally Significant Freight and Highway Project Funds Award Year: Multiple Grant Award Number: Multiple Compliance Requirements: Other - Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) §200.510(b) - Schedule of expenditures of Federal awards Type of Finding: Material Weakness in Internal Control over Compliance Criteria: Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) §200.510(b) states that the auditee (the City) must 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. In addition, §200.303 of the Uniform Guidance states that the City must establish and maintain effective internal control over the federal awards, including controls over the accuracy of program information and expenditure amounts. Condition: During our audit procedures performed over the SEFA and expenditures reported for the CDBG - Entitlement Grants Cluster, Highway Planning and Construction, and Nationally Significant Freight and Highway Project Funds, we noted the following: 1. The City did not properly identify the amount expended for the CDBG - Entitlement Grants Cluster, AL No. 14.218. The expenditures reported by the City were understated by $154,071. 2. The City did not properly identify the amount expended for the Highway Planning and Construction, AL No. 20.205. The expenditures reported by the City were overstated by $5,098,179. 3. The City did not properly classify the amount expended for the Nationally Significant Freight and Highway Project Funds, AL No. 20.934. The expenditures reported by the City were understated by $2,769,610. Cause: As a result, the City lacks adequate internal controls to ensure the SEFA is completely and accurately stated. Specifically, the City’s processes for recording and tracking expenditures of federal awards are not designed so that expenditures are identified when incurred and assigned to the correct program name or cluster in a complete and timely manner. Effect: The SEFA, as originally presented, was overstated by $2,174,498. Questioned Costs: No questioned costs were identified as a result of our procedures. Context/Sampling: No sampling was used. Program expenditures on the SEFA were reconciled to supporting records. Repeat Finding from the Prior Year(s): No. Recommendation: The City should establish policies and implement internal controls to ensure all federal expenditures are accurately tracked and reported on the SEFA. Personnel knowledgeable of federal expenditures should review amounts coded to federal programs for completeness and accuracy. The SEFA should be prepared and reviewed in a timely manner and reconciled to underlying records as well as the basic financial statements. View of Responsible Official and Planned Corrective Actions See separate corrective action plan.
2023-001 Program: CDBG - Entitlement Grants Cluster / Highway Planning and Construction / Nationally Significant Freight and Highway Project Funds Federal Financial Assistance Listing No.: 14.218 / 20.205 / 20.934 Federal Agency: U.S. Department of Housing and Urban Development / U.S. Department of Transportation Direct Award: U.S. Department of Housing and Urban Development Pass-through: California Department of Transportation in relation to the Highway Planning and Construction and Nationally Significant Freight and Highway Project Funds Award Year: Multiple Grant Award Number: Multiple Compliance Requirements: Other - Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) §200.510(b) - Schedule of expenditures of Federal awards Type of Finding: Material Weakness in Internal Control over Compliance Criteria: Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) §200.510(b) states that the auditee (the City) must 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. In addition, §200.303 of the Uniform Guidance states that the City must establish and maintain effective internal control over the federal awards, including controls over the accuracy of program information and expenditure amounts. Condition: During our audit procedures performed over the SEFA and expenditures reported for the CDBG - Entitlement Grants Cluster, Highway Planning and Construction, and Nationally Significant Freight and Highway Project Funds, we noted the following: 1. The City did not properly identify the amount expended for the CDBG - Entitlement Grants Cluster, AL No. 14.218. The expenditures reported by the City were understated by $154,071. 2. The City did not properly identify the amount expended for the Highway Planning and Construction, AL No. 20.205. The expenditures reported by the City were overstated by $5,098,179. 3. The City did not properly classify the amount expended for the Nationally Significant Freight and Highway Project Funds, AL No. 20.934. The expenditures reported by the City were understated by $2,769,610. Cause: As a result, the City lacks adequate internal controls to ensure the SEFA is completely and accurately stated. Specifically, the City’s processes for recording and tracking expenditures of federal awards are not designed so that expenditures are identified when incurred and assigned to the correct program name or cluster in a complete and timely manner. Effect: The SEFA, as originally presented, was overstated by $2,174,498. Questioned Costs: No questioned costs were identified as a result of our procedures. Context/Sampling: No sampling was used. Program expenditures on the SEFA were reconciled to supporting records. Repeat Finding from the Prior Year(s): No. Recommendation: The City should establish policies and implement internal controls to ensure all federal expenditures are accurately tracked and reported on the SEFA. Personnel knowledgeable of federal expenditures should review amounts coded to federal programs for completeness and accuracy. The SEFA should be prepared and reviewed in a timely manner and reconciled to underlying records as well as the basic financial statements. View of Responsible Official and Planned Corrective Actions See separate corrective action plan.
2023-001 Program: CDBG - Entitlement Grants Cluster / Highway Planning and Construction / Nationally Significant Freight and Highway Project Funds Federal Financial Assistance Listing No.: 14.218 / 20.205 / 20.934 Federal Agency: U.S. Department of Housing and Urban Development / U.S. Department of Transportation Direct Award: U.S. Department of Housing and Urban Development Pass-through: California Department of Transportation in relation to the Highway Planning and Construction and Nationally Significant Freight and Highway Project Funds Award Year: Multiple Grant Award Number: Multiple Compliance Requirements: Other - Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) §200.510(b) - Schedule of expenditures of Federal awards Type of Finding: Material Weakness in Internal Control over Compliance Criteria: Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) §200.510(b) states that the auditee (the City) must 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. In addition, §200.303 of the Uniform Guidance states that the City must establish and maintain effective internal control over the federal awards, including controls over the accuracy of program information and expenditure amounts. Condition: During our audit procedures performed over the SEFA and expenditures reported for the CDBG - Entitlement Grants Cluster, Highway Planning and Construction, and Nationally Significant Freight and Highway Project Funds, we noted the following: 1. The City did not properly identify the amount expended for the CDBG - Entitlement Grants Cluster, AL No. 14.218. The expenditures reported by the City were understated by $154,071. 2. The City did not properly identify the amount expended for the Highway Planning and Construction, AL No. 20.205. The expenditures reported by the City were overstated by $5,098,179. 3. The City did not properly classify the amount expended for the Nationally Significant Freight and Highway Project Funds, AL No. 20.934. The expenditures reported by the City were understated by $2,769,610. Cause: As a result, the City lacks adequate internal controls to ensure the SEFA is completely and accurately stated. Specifically, the City’s processes for recording and tracking expenditures of federal awards are not designed so that expenditures are identified when incurred and assigned to the correct program name or cluster in a complete and timely manner. Effect: The SEFA, as originally presented, was overstated by $2,174,498. Questioned Costs: No questioned costs were identified as a result of our procedures. Context/Sampling: No sampling was used. Program expenditures on the SEFA were reconciled to supporting records. Repeat Finding from the Prior Year(s): No. Recommendation: The City should establish policies and implement internal controls to ensure all federal expenditures are accurately tracked and reported on the SEFA. Personnel knowledgeable of federal expenditures should review amounts coded to federal programs for completeness and accuracy. The SEFA should be prepared and reviewed in a timely manner and reconciled to underlying records as well as the basic financial statements. View of Responsible Official and Planned Corrective Actions See separate corrective action plan.
2023-001 Program: CDBG - Entitlement Grants Cluster / Highway Planning and Construction / Nationally Significant Freight and Highway Project Funds Federal Financial Assistance Listing No.: 14.218 / 20.205 / 20.934 Federal Agency: U.S. Department of Housing and Urban Development / U.S. Department of Transportation Direct Award: U.S. Department of Housing and Urban Development Pass-through: California Department of Transportation in relation to the Highway Planning and Construction and Nationally Significant Freight and Highway Project Funds Award Year: Multiple Grant Award Number: Multiple Compliance Requirements: Other - Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) §200.510(b) - Schedule of expenditures of Federal awards Type of Finding: Material Weakness in Internal Control over Compliance Criteria: Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) §200.510(b) states that the auditee (the City) must 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. In addition, §200.303 of the Uniform Guidance states that the City must establish and maintain effective internal control over the federal awards, including controls over the accuracy of program information and expenditure amounts. Condition: During our audit procedures performed over the SEFA and expenditures reported for the CDBG - Entitlement Grants Cluster, Highway Planning and Construction, and Nationally Significant Freight and Highway Project Funds, we noted the following: 1. The City did not properly identify the amount expended for the CDBG - Entitlement Grants Cluster, AL No. 14.218. The expenditures reported by the City were understated by $154,071. 2. The City did not properly identify the amount expended for the Highway Planning and Construction, AL No. 20.205. The expenditures reported by the City were overstated by $5,098,179. 3. The City did not properly classify the amount expended for the Nationally Significant Freight and Highway Project Funds, AL No. 20.934. The expenditures reported by the City were understated by $2,769,610. Cause: As a result, the City lacks adequate internal controls to ensure the SEFA is completely and accurately stated. Specifically, the City’s processes for recording and tracking expenditures of federal awards are not designed so that expenditures are identified when incurred and assigned to the correct program name or cluster in a complete and timely manner. Effect: The SEFA, as originally presented, was overstated by $2,174,498. Questioned Costs: No questioned costs were identified as a result of our procedures. Context/Sampling: No sampling was used. Program expenditures on the SEFA were reconciled to supporting records. Repeat Finding from the Prior Year(s): No. Recommendation: The City should establish policies and implement internal controls to ensure all federal expenditures are accurately tracked and reported on the SEFA. Personnel knowledgeable of federal expenditures should review amounts coded to federal programs for completeness and accuracy. The SEFA should be prepared and reviewed in a timely manner and reconciled to underlying records as well as the basic financial statements. View of Responsible Official and Planned Corrective Actions See separate corrective action plan.
2023-001 Program: CDBG - Entitlement Grants Cluster / Highway Planning and Construction / Nationally Significant Freight and Highway Project Funds Federal Financial Assistance Listing No.: 14.218 / 20.205 / 20.934 Federal Agency: U.S. Department of Housing and Urban Development / U.S. Department of Transportation Direct Award: U.S. Department of Housing and Urban Development Pass-through: California Department of Transportation in relation to the Highway Planning and Construction and Nationally Significant Freight and Highway Project Funds Award Year: Multiple Grant Award Number: Multiple Compliance Requirements: Other - Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) §200.510(b) - Schedule of expenditures of Federal awards Type of Finding: Material Weakness in Internal Control over Compliance Criteria: Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) §200.510(b) states that the auditee (the City) must 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. In addition, §200.303 of the Uniform Guidance states that the City must establish and maintain effective internal control over the federal awards, including controls over the accuracy of program information and expenditure amounts. Condition: During our audit procedures performed over the SEFA and expenditures reported for the CDBG - Entitlement Grants Cluster, Highway Planning and Construction, and Nationally Significant Freight and Highway Project Funds, we noted the following: 1. The City did not properly identify the amount expended for the CDBG - Entitlement Grants Cluster, AL No. 14.218. The expenditures reported by the City were understated by $154,071. 2. The City did not properly identify the amount expended for the Highway Planning and Construction, AL No. 20.205. The expenditures reported by the City were overstated by $5,098,179. 3. The City did not properly classify the amount expended for the Nationally Significant Freight and Highway Project Funds, AL No. 20.934. The expenditures reported by the City were understated by $2,769,610. Cause: As a result, the City lacks adequate internal controls to ensure the SEFA is completely and accurately stated. Specifically, the City’s processes for recording and tracking expenditures of federal awards are not designed so that expenditures are identified when incurred and assigned to the correct program name or cluster in a complete and timely manner. Effect: The SEFA, as originally presented, was overstated by $2,174,498. Questioned Costs: No questioned costs were identified as a result of our procedures. Context/Sampling: No sampling was used. Program expenditures on the SEFA were reconciled to supporting records. Repeat Finding from the Prior Year(s): No. Recommendation: The City should establish policies and implement internal controls to ensure all federal expenditures are accurately tracked and reported on the SEFA. Personnel knowledgeable of federal expenditures should review amounts coded to federal programs for completeness and accuracy. The SEFA should be prepared and reviewed in a timely manner and reconciled to underlying records as well as the basic financial statements. View of Responsible Official and Planned Corrective Actions See separate corrective action plan.
2023-001 Program: CDBG - Entitlement Grants Cluster / Highway Planning and Construction / Nationally Significant Freight and Highway Project Funds Federal Financial Assistance Listing No.: 14.218 / 20.205 / 20.934 Federal Agency: U.S. Department of Housing and Urban Development / U.S. Department of Transportation Direct Award: U.S. Department of Housing and Urban Development Pass-through: California Department of Transportation in relation to the Highway Planning and Construction and Nationally Significant Freight and Highway Project Funds Award Year: Multiple Grant Award Number: Multiple Compliance Requirements: Other - Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) §200.510(b) - Schedule of expenditures of Federal awards Type of Finding: Material Weakness in Internal Control over Compliance Criteria: Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) §200.510(b) states that the auditee (the City) must 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. In addition, §200.303 of the Uniform Guidance states that the City must establish and maintain effective internal control over the federal awards, including controls over the accuracy of program information and expenditure amounts. Condition: During our audit procedures performed over the SEFA and expenditures reported for the CDBG - Entitlement Grants Cluster, Highway Planning and Construction, and Nationally Significant Freight and Highway Project Funds, we noted the following: 1. The City did not properly identify the amount expended for the CDBG - Entitlement Grants Cluster, AL No. 14.218. The expenditures reported by the City were understated by $154,071. 2. The City did not properly identify the amount expended for the Highway Planning and Construction, AL No. 20.205. The expenditures reported by the City were overstated by $5,098,179. 3. The City did not properly classify the amount expended for the Nationally Significant Freight and Highway Project Funds, AL No. 20.934. The expenditures reported by the City were understated by $2,769,610. Cause: As a result, the City lacks adequate internal controls to ensure the SEFA is completely and accurately stated. Specifically, the City’s processes for recording and tracking expenditures of federal awards are not designed so that expenditures are identified when incurred and assigned to the correct program name or cluster in a complete and timely manner. Effect: The SEFA, as originally presented, was overstated by $2,174,498. Questioned Costs: No questioned costs were identified as a result of our procedures. Context/Sampling: No sampling was used. Program expenditures on the SEFA were reconciled to supporting records. Repeat Finding from the Prior Year(s): No. Recommendation: The City should establish policies and implement internal controls to ensure all federal expenditures are accurately tracked and reported on the SEFA. Personnel knowledgeable of federal expenditures should review amounts coded to federal programs for completeness and accuracy. The SEFA should be prepared and reviewed in a timely manner and reconciled to underlying records as well as the basic financial statements. View of Responsible Official and Planned Corrective Actions See separate corrective action plan.
Criteria or Specific Requirement: Compliance: Per 2 CFR 200 Section 510(b), 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 Section 200.502. The schedule must list individual Federal programs by Federal agency and 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. It must also include the total amount provided to subrecipients from each Federal program. Per Section 502(g), Federal non-cash assistance, such as free rent, food commodities, donated property, or donated surplus property, must be valued at fair market value at the time of receipt or the assessed value provided by the Federal agency. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: Expenditures were recorded on the Schedule of Expenditures of Federal Awards (SEFA) submitted to the auditors in the year when reimbursement was received and not in the year in which the expenditure was incurred. Cause: Turnover in the grant accountant position resulted in an inexperienced accountant completing the schedule of expenditures of federal awards and management was unaware of the federal requirements for preparation of the SEFA. Effect: Federal expenditures were incorrectly reported on the SEFA submitted to the auditors by $140,000, effecting the initial determination of Type A and Type B programs and our program coverage. Questioned Costs: Undetermined Recommendation: We recommend that the County improve its SEFA compilation process to ensure that program expenditures reported on the County’s SEFA are complete and accurate based on when the expenditure was incurred. Views of Responsible Officials: The County agrees with this finding. See separate Correction Action Plan related to this finding.
Criteria or Specific Requirement: Compliance: Per 2 CFR 200 Section 510(b), 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 Section 200.502. The schedule must list individual Federal programs by Federal agency and 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. It must also include the total amount provided to subrecipients from each Federal program. Per Section 502(g), Federal non-cash assistance, such as free rent, food commodities, donated property, or donated surplus property, must be valued at fair market value at the time of receipt or the assessed value provided by the Federal agency. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: Expenditures were recorded on the Schedule of Expenditures of Federal Awards (SEFA) submitted to the auditors in the year when reimbursement was received and not in the year in which the expenditure was incurred. Cause: Turnover in the grant accountant position resulted in an inexperienced accountant completing the schedule of expenditures of federal awards and management was unaware of the federal requirements for preparation of the SEFA. Effect: Federal expenditures were incorrectly reported on the SEFA submitted to the auditors by $140,000, effecting the initial determination of Type A and Type B programs and our program coverage. Questioned Costs: Undetermined Recommendation: We recommend that the County improve its SEFA compilation process to ensure that program expenditures reported on the County’s SEFA are complete and accurate based on when the expenditure was incurred. Views of Responsible Officials: The County agrees with this finding. See separate Correction Action Plan related to this finding.
Criteria or Specific Requirement: Compliance: Per 2 CFR 200 Section 510(b), 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 Section 200.502. The schedule must list individual Federal programs by Federal agency and 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. It must also include the total amount provided to subrecipients from each Federal program. Per Section 502(g), Federal non-cash assistance, such as free rent, food commodities, donated property, or donated surplus property, must be valued at fair market value at the time of receipt or the assessed value provided by the Federal agency. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: Expenditures were recorded on the Schedule of Expenditures of Federal Awards (SEFA) submitted to the auditors in the year when reimbursement was received and not in the year in which the expenditure was incurred. Cause: Turnover in the grant accountant position resulted in an inexperienced accountant completing the schedule of expenditures of federal awards and management was unaware of the federal requirements for preparation of the SEFA. Effect: Federal expenditures were incorrectly reported on the SEFA submitted to the auditors by $140,000, effecting the initial determination of Type A and Type B programs and our program coverage. Questioned Costs: Undetermined Recommendation: We recommend that the County improve its SEFA compilation process to ensure that program expenditures reported on the County’s SEFA are complete and accurate based on when the expenditure was incurred. Views of Responsible Officials: The County agrees with this finding. See separate Correction Action Plan related to this finding.
Criteria or Specific Requirement: Compliance: Per 2 CFR 200 Section 510(b), 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 Section 200.502. The schedule must list individual Federal programs by Federal agency and 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. It must also include the total amount provided to subrecipients from each Federal program. Per Section 502(g), Federal non-cash assistance, such as free rent, food commodities, donated property, or donated surplus property, must be valued at fair market value at the time of receipt or the assessed value provided by the Federal agency. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: Expenditures were recorded on the Schedule of Expenditures of Federal Awards (SEFA) submitted to the auditors in the year when reimbursement was received and not in the year in which the expenditure was incurred. Cause: Turnover in the grant accountant position resulted in an inexperienced accountant completing the schedule of expenditures of federal awards and management was unaware of the federal requirements for preparation of the SEFA. Effect: Federal expenditures were incorrectly reported on the SEFA submitted to the auditors by $140,000, effecting the initial determination of Type A and Type B programs and our program coverage. Questioned Costs: Undetermined Recommendation: We recommend that the County improve its SEFA compilation process to ensure that program expenditures reported on the County’s SEFA are complete and accurate based on when the expenditure was incurred. Views of Responsible Officials: The County agrees with this finding. See separate Correction Action Plan related to this finding.
Criteria or Specific Requirement: Compliance: Per 2 CFR 200 Section 510(b), 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 Section 200.502. The schedule must list individual Federal programs by Federal agency and 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. It must also include the total amount provided to subrecipients from each Federal program. Per Section 502(g), Federal non-cash assistance, such as free rent, food commodities, donated property, or donated surplus property, must be valued at fair market value at the time of receipt or the assessed value provided by the Federal agency. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: Expenditures were recorded on the Schedule of Expenditures of Federal Awards (SEFA) submitted to the auditors in the year when reimbursement was received and not in the year in which the expenditure was incurred. Cause: Turnover in the grant accountant position resulted in an inexperienced accountant completing the schedule of expenditures of federal awards and management was unaware of the federal requirements for preparation of the SEFA. Effect: Federal expenditures were incorrectly reported on the SEFA submitted to the auditors by $140,000, effecting the initial determination of Type A and Type B programs and our program coverage. Questioned Costs: Undetermined Recommendation: We recommend that the County improve its SEFA compilation process to ensure that program expenditures reported on the County’s SEFA are complete and accurate based on when the expenditure was incurred. Views of Responsible Officials: The County agrees with this finding. See separate Correction Action Plan related to this finding.
Criteria or Specific Requirement: Compliance: Per 2 CFR 200 Section 510(b), 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 Section 200.502. The schedule must list individual Federal programs by Federal agency and 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. It must also include the total amount provided to subrecipients from each Federal program. Per Section 502(g), Federal non-cash assistance, such as free rent, food commodities, donated property, or donated surplus property, must be valued at fair market value at the time of receipt or the assessed value provided by the Federal agency. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: Expenditures were recorded on the Schedule of Expenditures of Federal Awards (SEFA) submitted to the auditors in the year when reimbursement was received and not in the year in which the expenditure was incurred. Cause: Turnover in the grant accountant position resulted in an inexperienced accountant completing the schedule of expenditures of federal awards and management was unaware of the federal requirements for preparation of the SEFA. Effect: Federal expenditures were incorrectly reported on the SEFA submitted to the auditors by $140,000, effecting the initial determination of Type A and Type B programs and our program coverage. Questioned Costs: Undetermined Recommendation: We recommend that the County improve its SEFA compilation process to ensure that program expenditures reported on the County’s SEFA are complete and accurate based on when the expenditure was incurred. Views of Responsible Officials: The County agrees with this finding. See separate Correction Action Plan related to this finding.
Criteria or Specific Requirement: Compliance: Per 2 CFR 200 Section 510(b), 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 Section 200.502. The schedule must list individual Federal programs by Federal agency and 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. It must also include the total amount provided to subrecipients from each Federal program. Per Section 502(g), Federal non-cash assistance, such as free rent, food commodities, donated property, or donated surplus property, must be valued at fair market value at the time of receipt or the assessed value provided by the Federal agency. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: Expenditures were recorded on the Schedule of Expenditures of Federal Awards (SEFA) submitted to the auditors in the year when reimbursement was received and not in the year in which the expenditure was incurred. Cause: Turnover in the grant accountant position resulted in an inexperienced accountant completing the schedule of expenditures of federal awards and management was unaware of the federal requirements for preparation of the SEFA. Effect: Federal expenditures were incorrectly reported on the SEFA submitted to the auditors by $140,000, effecting the initial determination of Type A and Type B programs and our program coverage. Questioned Costs: Undetermined Recommendation: We recommend that the County improve its SEFA compilation process to ensure that program expenditures reported on the County’s SEFA are complete and accurate based on when the expenditure was incurred. Views of Responsible Officials: The County agrees with this finding. See separate Correction Action Plan related to this finding.
Criteria or Specific Requirement: Compliance: Per 2 CFR 200 Section 510(b), 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 Section 200.502. The schedule must list individual Federal programs by Federal agency and 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. It must also include the total amount provided to subrecipients from each Federal program. Per Section 502(g), Federal non-cash assistance, such as free rent, food commodities, donated property, or donated surplus property, must be valued at fair market value at the time of receipt or the assessed value provided by the Federal agency. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: Expenditures were recorded on the Schedule of Expenditures of Federal Awards (SEFA) submitted to the auditors in the year when reimbursement was received and not in the year in which the expenditure was incurred. Cause: Turnover in the grant accountant position resulted in an inexperienced accountant completing the schedule of expenditures of federal awards and management was unaware of the federal requirements for preparation of the SEFA. Effect: Federal expenditures were incorrectly reported on the SEFA submitted to the auditors by $140,000, effecting the initial determination of Type A and Type B programs and our program coverage. Questioned Costs: Undetermined Recommendation: We recommend that the County improve its SEFA compilation process to ensure that program expenditures reported on the County’s SEFA are complete and accurate based on when the expenditure was incurred. Views of Responsible Officials: The County agrees with this finding. See separate Correction Action Plan related to this finding.
Criteria or Specific Requirement: Compliance: Per 2 CFR 200 Section 510(b), 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 Section 200.502. The schedule must list individual Federal programs by Federal agency and 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. It must also include the total amount provided to subrecipients from each Federal program. Per Section 502(g), Federal non-cash assistance, such as free rent, food commodities, donated property, or donated surplus property, must be valued at fair market value at the time of receipt or the assessed value provided by the Federal agency. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: Expenditures were recorded on the Schedule of Expenditures of Federal Awards (SEFA) submitted to the auditors in the year when reimbursement was received and not in the year in which the expenditure was incurred. Cause: Turnover in the grant accountant position resulted in an inexperienced accountant completing the schedule of expenditures of federal awards and management was unaware of the federal requirements for preparation of the SEFA. Effect: Federal expenditures were incorrectly reported on the SEFA submitted to the auditors by $140,000, effecting the initial determination of Type A and Type B programs and our program coverage. Questioned Costs: Undetermined Recommendation: We recommend that the County improve its SEFA compilation process to ensure that program expenditures reported on the County’s SEFA are complete and accurate based on when the expenditure was incurred. Views of Responsible Officials: The County agrees with this finding. See separate Correction Action Plan related to this finding.
Criteria or Specific Requirement: Compliance: Per 2 CFR 200 Section 510(b), 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 Section 200.502. The schedule must list individual Federal programs by Federal agency and 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. It must also include the total amount provided to subrecipients from each Federal program. Per Section 502(g), Federal non-cash assistance, such as free rent, food commodities, donated property, or donated surplus property, must be valued at fair market value at the time of receipt or the assessed value provided by the Federal agency. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: Expenditures were recorded on the Schedule of Expenditures of Federal Awards (SEFA) submitted to the auditors in the year when reimbursement was received and not in the year in which the expenditure was incurred. Cause: Turnover in the grant accountant position resulted in an inexperienced accountant completing the schedule of expenditures of federal awards and management was unaware of the federal requirements for preparation of the SEFA. Effect: Federal expenditures were incorrectly reported on the SEFA submitted to the auditors by $140,000, effecting the initial determination of Type A and Type B programs and our program coverage. Questioned Costs: Undetermined Recommendation: We recommend that the County improve its SEFA compilation process to ensure that program expenditures reported on the County’s SEFA are complete and accurate based on when the expenditure was incurred. Views of Responsible Officials: The County agrees with this finding. See separate Correction Action Plan related to this finding.
Criteria or Specific Requirement: Compliance: Per 2 CFR 200 Section 510(b), 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 Section 200.502. The schedule must list individual Federal programs by Federal agency and 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. It must also include the total amount provided to subrecipients from each Federal program. Per Section 502(g), Federal non-cash assistance, such as free rent, food commodities, donated property, or donated surplus property, must be valued at fair market value at the time of receipt or the assessed value provided by the Federal agency. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: Expenditures were recorded on the Schedule of Expenditures of Federal Awards (SEFA) submitted to the auditors in the year when reimbursement was received and not in the year in which the expenditure was incurred. Cause: Turnover in the grant accountant position resulted in an inexperienced accountant completing the schedule of expenditures of federal awards and management was unaware of the federal requirements for preparation of the SEFA. Effect: Federal expenditures were incorrectly reported on the SEFA submitted to the auditors by $140,000, effecting the initial determination of Type A and Type B programs and our program coverage. Questioned Costs: Undetermined Recommendation: We recommend that the County improve its SEFA compilation process to ensure that program expenditures reported on the County’s SEFA are complete and accurate based on when the expenditure was incurred. Views of Responsible Officials: The County agrees with this finding. See separate Correction Action Plan related to this finding.
Criteria or Specific Requirement: Compliance: Per 2 CFR 200 Section 510(b), 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 Section 200.502. The schedule must list individual Federal programs by Federal agency and 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. It must also include the total amount provided to subrecipients from each Federal program. Per Section 502(g), Federal non-cash assistance, such as free rent, food commodities, donated property, or donated surplus property, must be valued at fair market value at the time of receipt or the assessed value provided by the Federal agency. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: Expenditures were recorded on the Schedule of Expenditures of Federal Awards (SEFA) submitted to the auditors in the year when reimbursement was received and not in the year in which the expenditure was incurred. Cause: Turnover in the grant accountant position resulted in an inexperienced accountant completing the schedule of expenditures of federal awards and management was unaware of the federal requirements for preparation of the SEFA. Effect: Federal expenditures were incorrectly reported on the SEFA submitted to the auditors by $140,000, effecting the initial determination of Type A and Type B programs and our program coverage. Questioned Costs: Undetermined Recommendation: We recommend that the County improve its SEFA compilation process to ensure that program expenditures reported on the County’s SEFA are complete and accurate based on when the expenditure was incurred. Views of Responsible Officials: The County agrees with this finding. See separate Correction Action Plan related to this finding.
Criteria or Specific Requirement: Compliance: Per 2 CFR 200 Section 510(b), 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 Section 200.502. The schedule must list individual Federal programs by Federal agency and 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. It must also include the total amount provided to subrecipients from each Federal program. Per Section 502(g), Federal non-cash assistance, such as free rent, food commodities, donated property, or donated surplus property, must be valued at fair market value at the time of receipt or the assessed value provided by the Federal agency. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: Expenditures were recorded on the Schedule of Expenditures of Federal Awards (SEFA) submitted to the auditors in the year when reimbursement was received and not in the year in which the expenditure was incurred. Cause: Turnover in the grant accountant position resulted in an inexperienced accountant completing the schedule of expenditures of federal awards and management was unaware of the federal requirements for preparation of the SEFA. Effect: Federal expenditures were incorrectly reported on the SEFA submitted to the auditors by $140,000, effecting the initial determination of Type A and Type B programs and our program coverage. Questioned Costs: Undetermined Recommendation: We recommend that the County improve its SEFA compilation process to ensure that program expenditures reported on the County’s SEFA are complete and accurate based on when the expenditure was incurred. Views of Responsible Officials: The County agrees with this finding. See separate Correction Action Plan related to this finding.
Criteria or Specific Requirement: Compliance: Per 2 CFR 200 Section 510(b), 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 Section 200.502. The schedule must list individual Federal programs by Federal agency and 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. It must also include the total amount provided to subrecipients from each Federal program. Per Section 502(g), Federal non-cash assistance, such as free rent, food commodities, donated property, or donated surplus property, must be valued at fair market value at the time of receipt or the assessed value provided by the Federal agency. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: Expenditures were recorded on the Schedule of Expenditures of Federal Awards (SEFA) submitted to the auditors in the year when reimbursement was received and not in the year in which the expenditure was incurred. Cause: Turnover in the grant accountant position resulted in an inexperienced accountant completing the schedule of expenditures of federal awards and management was unaware of the federal requirements for preparation of the SEFA. Effect: Federal expenditures were incorrectly reported on the SEFA submitted to the auditors by $140,000, effecting the initial determination of Type A and Type B programs and our program coverage. Questioned Costs: Undetermined Recommendation: We recommend that the County improve its SEFA compilation process to ensure that program expenditures reported on the County’s SEFA are complete and accurate based on when the expenditure was incurred. Views of Responsible Officials: The County agrees with this finding. See separate Correction Action Plan related to this finding.
Criteria or Specific Requirement: Compliance: Per 2 CFR 200 Section 510(b), 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 Section 200.502. The schedule must list individual Federal programs by Federal agency and 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. It must also include the total amount provided to subrecipients from each Federal program. Per Section 502(g), Federal non-cash assistance, such as free rent, food commodities, donated property, or donated surplus property, must be valued at fair market value at the time of receipt or the assessed value provided by the Federal agency. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: Expenditures were recorded on the Schedule of Expenditures of Federal Awards (SEFA) submitted to the auditors in the year when reimbursement was received and not in the year in which the expenditure was incurred. Cause: Turnover in the grant accountant position resulted in an inexperienced accountant completing the schedule of expenditures of federal awards and management was unaware of the federal requirements for preparation of the SEFA. Effect: Federal expenditures were incorrectly reported on the SEFA submitted to the auditors by $140,000, effecting the initial determination of Type A and Type B programs and our program coverage. Questioned Costs: Undetermined Recommendation: We recommend that the County improve its SEFA compilation process to ensure that program expenditures reported on the County’s SEFA are complete and accurate based on when the expenditure was incurred. Views of Responsible Officials: The County agrees with this finding. See separate Correction Action Plan related to this finding.
Criteria or Specific Requirement: Compliance: Per 2 CFR 200 Section 510(b), 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 Section 200.502. The schedule must list individual Federal programs by Federal agency and 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. It must also include the total amount provided to subrecipients from each Federal program. Per Section 502(g), Federal non-cash assistance, such as free rent, food commodities, donated property, or donated surplus property, must be valued at fair market value at the time of receipt or the assessed value provided by the Federal agency. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: Expenditures were recorded on the Schedule of Expenditures of Federal Awards (SEFA) submitted to the auditors in the year when reimbursement was received and not in the year in which the expenditure was incurred. Cause: Turnover in the grant accountant position resulted in an inexperienced accountant completing the schedule of expenditures of federal awards and management was unaware of the federal requirements for preparation of the SEFA. Effect: Federal expenditures were incorrectly reported on the SEFA submitted to the auditors by $140,000, effecting the initial determination of Type A and Type B programs and our program coverage. Questioned Costs: Undetermined Recommendation: We recommend that the County improve its SEFA compilation process to ensure that program expenditures reported on the County’s SEFA are complete and accurate based on when the expenditure was incurred. Views of Responsible Officials: The County agrees with this finding. See separate Correction Action Plan related to this finding.
Criteria or Specific Requirement: Compliance: Per 2 CFR 200 Section 510(b), 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 Section 200.502. The schedule must list individual Federal programs by Federal agency and 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. It must also include the total amount provided to subrecipients from each Federal program. Per Section 502(g), Federal non-cash assistance, such as free rent, food commodities, donated property, or donated surplus property, must be valued at fair market value at the time of receipt or the assessed value provided by the Federal agency. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: Expenditures were recorded on the Schedule of Expenditures of Federal Awards (SEFA) submitted to the auditors in the year when reimbursement was received and not in the year in which the expenditure was incurred. Cause: Turnover in the grant accountant position resulted in an inexperienced accountant completing the schedule of expenditures of federal awards and management was unaware of the federal requirements for preparation of the SEFA. Effect: Federal expenditures were incorrectly reported on the SEFA submitted to the auditors by $140,000, effecting the initial determination of Type A and Type B programs and our program coverage. Questioned Costs: Undetermined Recommendation: We recommend that the County improve its SEFA compilation process to ensure that program expenditures reported on the County’s SEFA are complete and accurate based on when the expenditure was incurred. Views of Responsible Officials: The County agrees with this finding. See separate Correction Action Plan related to this finding.
Criteria or Specific Requirement: Compliance: Per 2 CFR 200 Section 510(b), 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 Section 200.502. The schedule must list individual Federal programs by Federal agency and 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. It must also include the total amount provided to subrecipients from each Federal program. Per Section 502(g), Federal non-cash assistance, such as free rent, food commodities, donated property, or donated surplus property, must be valued at fair market value at the time of receipt or the assessed value provided by the Federal agency. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: Expenditures were recorded on the Schedule of Expenditures of Federal Awards (SEFA) submitted to the auditors in the year when reimbursement was received and not in the year in which the expenditure was incurred. Cause: Turnover in the grant accountant position resulted in an inexperienced accountant completing the schedule of expenditures of federal awards and management was unaware of the federal requirements for preparation of the SEFA. Effect: Federal expenditures were incorrectly reported on the SEFA submitted to the auditors by $140,000, effecting the initial determination of Type A and Type B programs and our program coverage. Questioned Costs: Undetermined Recommendation: We recommend that the County improve its SEFA compilation process to ensure that program expenditures reported on the County’s SEFA are complete and accurate based on when the expenditure was incurred. Views of Responsible Officials: The County agrees with this finding. See separate Correction Action Plan related to this finding.
Criteria or Specific Requirement: Compliance: Per 2 CFR 200 Section 510(b), 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 Section 200.502. The schedule must list individual Federal programs by Federal agency and 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. It must also include the total amount provided to subrecipients from each Federal program. Per Section 502(g), Federal non-cash assistance, such as free rent, food commodities, donated property, or donated surplus property, must be valued at fair market value at the time of receipt or the assessed value provided by the Federal agency. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: Expenditures were recorded on the Schedule of Expenditures of Federal Awards (SEFA) submitted to the auditors in the year when reimbursement was received and not in the year in which the expenditure was incurred. Cause: Turnover in the grant accountant position resulted in an inexperienced accountant completing the schedule of expenditures of federal awards and management was unaware of the federal requirements for preparation of the SEFA. Effect: Federal expenditures were incorrectly reported on the SEFA submitted to the auditors by $140,000, effecting the initial determination of Type A and Type B programs and our program coverage. Questioned Costs: Undetermined Recommendation: We recommend that the County improve its SEFA compilation process to ensure that program expenditures reported on the County’s SEFA are complete and accurate based on when the expenditure was incurred. Views of Responsible Officials: The County agrees with this finding. See separate Correction Action Plan related to this finding.
Criteria or Specific Requirement: Compliance: Per 2 CFR 200 Section 510(b), 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 Section 200.502. The schedule must list individual Federal programs by Federal agency and 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. It must also include the total amount provided to subrecipients from each Federal program. Per Section 502(g), Federal non-cash assistance, such as free rent, food commodities, donated property, or donated surplus property, must be valued at fair market value at the time of receipt or the assessed value provided by the Federal agency. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: Expenditures were recorded on the Schedule of Expenditures of Federal Awards (SEFA) submitted to the auditors in the year when reimbursement was received and not in the year in which the expenditure was incurred. Cause: Turnover in the grant accountant position resulted in an inexperienced accountant completing the schedule of expenditures of federal awards and management was unaware of the federal requirements for preparation of the SEFA. Effect: Federal expenditures were incorrectly reported on the SEFA submitted to the auditors by $140,000, effecting the initial determination of Type A and Type B programs and our program coverage. Questioned Costs: Undetermined Recommendation: We recommend that the County improve its SEFA compilation process to ensure that program expenditures reported on the County’s SEFA are complete and accurate based on when the expenditure was incurred. Views of Responsible Officials: The County agrees with this finding. See separate Correction Action Plan related to this finding.
(2023-041) Title: Internal control over the submission of CNC Schedule of Expenditures of Federal Awards information needs improvement Prior Year Findings: See schedule of Findings and Questioned Costs for chart/table State Department: Education State Bureau: Child Nutrition Services Federal Agency: U.S. Department of Agriculture Assistance Listing Title: Child Nutrition Cluster Assistance Listing Number: 10.553, 10.555, 10.556, 10.559, 10.582 Federal Award Identification Number: See E-93 to E-94 Compliance Area: Reporting Type of Finding: Significant deficiency Questioned Costs: None Criteria: 2 CFR 200.303; 2 CFR 200.502 and .510; 7 CFR 250.58(e); U.S. Department of Agriculture Policy No. FD-104 The Department must establish and maintain effective internal control over Federal awards that provides reasonable assurance that the Department is managing awards in compliance with Federal statutes, regulations, and the terms and conditions of awards. The Department must prepare a Schedule of Expenditures of Federal Awards (SEFA) for the period covered by the State’s financial statements which must include the total Federal awards expended, including distribution or use of food commodities. Federal non-cash assistance, such as food commodities must be valued at fair market value at the time of receipt or the assessed value provided by the Federal agency. For a cluster of programs, the SEFA must list individual Federal programs within the cluster. In meeting the commodity offer value of donated foods for the school food authority, the distributing agency must use the cost-per-pound donated food price posted annually by the U.S. Department of Agriculture (USDA), the most recently published cost-per-pound price in the USDA donated foods catalog, and/or a rolling average of the USDA prices. Each distributing or recipient agency must choose a method of valuing USDA donated foods for audit purposes. In most cases, it is recommended that a distributing or recipient agency use one of the options listed in 7 CFR 250.58(e). Once a method of assigning value to USDA donated foods is selected, it must be used consistently in all its audit activities and the State must maintain a record of the means of valuing donated foods for such purposes. Condition: The Department must complete and submit exhibits and related schedules to the Office of the State Controller (OSC) at the close of each fiscal year to report Federal award information for inclusion on the State’s SEFA. OSC is responsible for compiling this information on behalf of the State. The Department submitted exhibits to OSC that: • incorrectly excluded $2.4 million of fresh food distributed to subrecipients and additional commodity items received. • incorrectly reported $1,417 of expenditures under ALN 10.555 National School Lunch Program that should have been reported under ALN 10.556 Special Milk Program. Context: In fiscal year 2023, noncash assistance totaling $2.4 million was not reported to OSC by the Department for inclusion on the SEFA. Noncash assistance for the Child Nutrition Cluster totaled $8.5 million in fiscal year 2023. Cause: • Lack of adequate policies and procedures • Lack of supervisory oversight Effect: Inaccurate reporting of expenditure amounts on the SEFA, which is submitted to the Federal government, may result in incorrect information used for programmatic, policy, or statistical purposes. Recommendation: We recommend that the Department implement policies and procedures that: • outline the method of valuing USDA donated foods in accordance with Federal regulations. • require a comprehensive review of SEFA schedules prior to submission to OSC. In addition, we recommend enhanced oversight over policies and procedures to ensure they are consistently applied and the SEFA is accurate and complete. Corrective Action Plan: See F-21 Management’s Response: The Department agrees with this finding. The child nutrition department will create a procedure for reporting the SEFA numbers to DOE Finance. Contact: Jane McLucas, Director of Child Nutrition, DOE, 207-624-6880 (State Number: 23-1203-02)