2023-001 Implement System-Based Tracking of Federal Expenditures Assistance Listing Number: 93.566 Assistance Listing Program Title: Refugee and Entrant Assistance – State - Administered Programs Federal Agency: Department of Health and Human Services (HHS) Passed Through Entities: 1. California Department of Social Services 2. University of California, San Diego 3. California Rural Legal Assistance Foundation 4. San Diego Refugee Communities Coalition/United Women of East Africa Support Team Federal Award Numbers: ALSP22-0002-A1, PUR00533092, ALSP22-0001, and ACS22-05-CAIR-A1 Federal Award Year: 8/1/2022 to 3/31/2025 Compliance Requirement: Activities Allowed or Unallowed Criteria: Management is responsible for designing, implementing, and maintaining an internal control system that ensures accurate financial reporting. Effective internal control over financial reporting provides reasonable assurance regarding the completeness and accuracy of accounting records, and compliance with grantor requirements. 2 CFR 200.510 Financial Statements require auditees to prepare a Schedule of Expenditures of Federal Awards (SEFA) for the period covered by the auditee's financial statements. This schedule must include the total Federal awards expended, as determined in accordance with 2 CFR 200.502. The information presented should be consistent with the accounting records (i.e., general ledger). In addition, Section 2 CFR 200.302(b)(1) provides that non-Federal entities must maintain effective control over and accountability for all funds, and must identify, in their accounts, all Federal awards received and expended. Condition: During our review of the SEFA, we noted that CAIR-CA currently utilizes workbooks outside of its accounting software to track federal expenditures. The external workbooks do not reconcile directly with the general ledger (GL) requiring management to prepare a separate reconciliation to support the SEFA amounts. Cause: This year marks CAIR-CA’s first Single Audit. As such, processes and internal controls over federal award tracking are still under development. The current system is not yet fully integrated to allow for automated or system-based tracking of federal expenditures by grant. Effect: Relying on manual workbooks to track federal expenditures can be inefficient and may result in inaccurate or incomplete reporting of federal expenditures. Questioned Cost: None Recommendation: We recommend that CAIR-CA enhance its accounting processes to enable the tracking of federal expenditures directly within its accounting software. This can be accomplished by implementing GL tracking codes or tags specifically designated for federal expenditures. Transitioning to a system based tracking approach will support consistency between the general ledger and the SEFA, simplify the process of generating financial reports, and improve the tracking of federal expenditures. Views of Responsible Officials and Corrective Action Plan: Management concurs with the finding and is currently in the process of updating the accounting system to incorporate grant-specific specific tracking codes to further align with federal reporting standards. As part of a layered approach to internal controls, Excel worksheets will continue to be used as a supplementary monitoring tool, providing an additional cross-check to the system-generated reports. Responsible person: Jackie Ramirez, Operations & Finance Associate Director Expected Implementation date: November 20, 2025
2023-001 Implement System-Based Tracking of Federal Expenditures Assistance Listing Number: 93.566 Assistance Listing Program Title: Refugee and Entrant Assistance – State - Administered Programs Federal Agency: Department of Health and Human Services (HHS) Passed Through Entities: 1. California Department of Social Services 2. University of California, San Diego 3. California Rural Legal Assistance Foundation 4. San Diego Refugee Communities Coalition/United Women of East Africa Support Team Federal Award Numbers: ALSP22-0002-A1, PUR00533092, ALSP22-0001, and ACS22-05-CAIR-A1 Federal Award Year: 8/1/2022 to 3/31/2025 Compliance Requirement: Activities Allowed or Unallowed Criteria: Management is responsible for designing, implementing, and maintaining an internal control system that ensures accurate financial reporting. Effective internal control over financial reporting provides reasonable assurance regarding the completeness and accuracy of accounting records, and compliance with grantor requirements. 2 CFR 200.510 Financial Statements require auditees to prepare a Schedule of Expenditures of Federal Awards (SEFA) for the period covered by the auditee's financial statements. This schedule must include the total Federal awards expended, as determined in accordance with 2 CFR 200.502. The information presented should be consistent with the accounting records (i.e., general ledger). In addition, Section 2 CFR 200.302(b)(1) provides that non-Federal entities must maintain effective control over and accountability for all funds, and must identify, in their accounts, all Federal awards received and expended. Condition: During our review of the SEFA, we noted that CAIR-CA currently utilizes workbooks outside of its accounting software to track federal expenditures. The external workbooks do not reconcile directly with the general ledger (GL) requiring management to prepare a separate reconciliation to support the SEFA amounts. Cause: This year marks CAIR-CA’s first Single Audit. As such, processes and internal controls over federal award tracking are still under development. The current system is not yet fully integrated to allow for automated or system-based tracking of federal expenditures by grant. Effect: Relying on manual workbooks to track federal expenditures can be inefficient and may result in inaccurate or incomplete reporting of federal expenditures. Questioned Cost: None Recommendation: We recommend that CAIR-CA enhance its accounting processes to enable the tracking of federal expenditures directly within its accounting software. This can be accomplished by implementing GL tracking codes or tags specifically designated for federal expenditures. Transitioning to a system based tracking approach will support consistency between the general ledger and the SEFA, simplify the process of generating financial reports, and improve the tracking of federal expenditures. Views of Responsible Officials and Corrective Action Plan: Management concurs with the finding and is currently in the process of updating the accounting system to incorporate grant-specific specific tracking codes to further align with federal reporting standards. As part of a layered approach to internal controls, Excel worksheets will continue to be used as a supplementary monitoring tool, providing an additional cross-check to the system-generated reports. Responsible person: Jackie Ramirez, Operations & Finance Associate Director Expected Implementation date: November 20, 2025
2023-001 Implement System-Based Tracking of Federal Expenditures Assistance Listing Number: 93.566 Assistance Listing Program Title: Refugee and Entrant Assistance – State - Administered Programs Federal Agency: Department of Health and Human Services (HHS) Passed Through Entities: 1. California Department of Social Services 2. University of California, San Diego 3. California Rural Legal Assistance Foundation 4. San Diego Refugee Communities Coalition/United Women of East Africa Support Team Federal Award Numbers: ALSP22-0002-A1, PUR00533092, ALSP22-0001, and ACS22-05-CAIR-A1 Federal Award Year: 8/1/2022 to 3/31/2025 Compliance Requirement: Activities Allowed or Unallowed Criteria: Management is responsible for designing, implementing, and maintaining an internal control system that ensures accurate financial reporting. Effective internal control over financial reporting provides reasonable assurance regarding the completeness and accuracy of accounting records, and compliance with grantor requirements. 2 CFR 200.510 Financial Statements require auditees to prepare a Schedule of Expenditures of Federal Awards (SEFA) for the period covered by the auditee's financial statements. This schedule must include the total Federal awards expended, as determined in accordance with 2 CFR 200.502. The information presented should be consistent with the accounting records (i.e., general ledger). In addition, Section 2 CFR 200.302(b)(1) provides that non-Federal entities must maintain effective control over and accountability for all funds, and must identify, in their accounts, all Federal awards received and expended. Condition: During our review of the SEFA, we noted that CAIR-CA currently utilizes workbooks outside of its accounting software to track federal expenditures. The external workbooks do not reconcile directly with the general ledger (GL) requiring management to prepare a separate reconciliation to support the SEFA amounts. Cause: This year marks CAIR-CA’s first Single Audit. As such, processes and internal controls over federal award tracking are still under development. The current system is not yet fully integrated to allow for automated or system-based tracking of federal expenditures by grant. Effect: Relying on manual workbooks to track federal expenditures can be inefficient and may result in inaccurate or incomplete reporting of federal expenditures. Questioned Cost: None Recommendation: We recommend that CAIR-CA enhance its accounting processes to enable the tracking of federal expenditures directly within its accounting software. This can be accomplished by implementing GL tracking codes or tags specifically designated for federal expenditures. Transitioning to a system based tracking approach will support consistency between the general ledger and the SEFA, simplify the process of generating financial reports, and improve the tracking of federal expenditures. Views of Responsible Officials and Corrective Action Plan: Management concurs with the finding and is currently in the process of updating the accounting system to incorporate grant-specific specific tracking codes to further align with federal reporting standards. As part of a layered approach to internal controls, Excel worksheets will continue to be used as a supplementary monitoring tool, providing an additional cross-check to the system-generated reports. Responsible person: Jackie Ramirez, Operations & Finance Associate Director Expected Implementation date: November 20, 2025
2023-001 Implement System-Based Tracking of Federal Expenditures Assistance Listing Number: 93.566 Assistance Listing Program Title: Refugee and Entrant Assistance – State - Administered Programs Federal Agency: Department of Health and Human Services (HHS) Passed Through Entities: 1. California Department of Social Services 2. University of California, San Diego 3. California Rural Legal Assistance Foundation 4. San Diego Refugee Communities Coalition/United Women of East Africa Support Team Federal Award Numbers: ALSP22-0002-A1, PUR00533092, ALSP22-0001, and ACS22-05-CAIR-A1 Federal Award Year: 8/1/2022 to 3/31/2025 Compliance Requirement: Activities Allowed or Unallowed Criteria: Management is responsible for designing, implementing, and maintaining an internal control system that ensures accurate financial reporting. Effective internal control over financial reporting provides reasonable assurance regarding the completeness and accuracy of accounting records, and compliance with grantor requirements. 2 CFR 200.510 Financial Statements require auditees to prepare a Schedule of Expenditures of Federal Awards (SEFA) for the period covered by the auditee's financial statements. This schedule must include the total Federal awards expended, as determined in accordance with 2 CFR 200.502. The information presented should be consistent with the accounting records (i.e., general ledger). In addition, Section 2 CFR 200.302(b)(1) provides that non-Federal entities must maintain effective control over and accountability for all funds, and must identify, in their accounts, all Federal awards received and expended. Condition: During our review of the SEFA, we noted that CAIR-CA currently utilizes workbooks outside of its accounting software to track federal expenditures. The external workbooks do not reconcile directly with the general ledger (GL) requiring management to prepare a separate reconciliation to support the SEFA amounts. Cause: This year marks CAIR-CA’s first Single Audit. As such, processes and internal controls over federal award tracking are still under development. The current system is not yet fully integrated to allow for automated or system-based tracking of federal expenditures by grant. Effect: Relying on manual workbooks to track federal expenditures can be inefficient and may result in inaccurate or incomplete reporting of federal expenditures. Questioned Cost: None Recommendation: We recommend that CAIR-CA enhance its accounting processes to enable the tracking of federal expenditures directly within its accounting software. This can be accomplished by implementing GL tracking codes or tags specifically designated for federal expenditures. Transitioning to a system based tracking approach will support consistency between the general ledger and the SEFA, simplify the process of generating financial reports, and improve the tracking of federal expenditures. Views of Responsible Officials and Corrective Action Plan: Management concurs with the finding and is currently in the process of updating the accounting system to incorporate grant-specific specific tracking codes to further align with federal reporting standards. As part of a layered approach to internal controls, Excel worksheets will continue to be used as a supplementary monitoring tool, providing an additional cross-check to the system-generated reports. Responsible person: Jackie Ramirez, Operations & Finance Associate Director Expected Implementation date: November 20, 2025
2023-001 Implement System-Based Tracking of Federal Expenditures Assistance Listing Number: 93.566 Assistance Listing Program Title: Refugee and Entrant Assistance – State - Administered Programs Federal Agency: Department of Health and Human Services (HHS) Passed Through Entities: 1. California Department of Social Services 2. University of California, San Diego 3. California Rural Legal Assistance Foundation 4. San Diego Refugee Communities Coalition/United Women of East Africa Support Team Federal Award Numbers: ALSP22-0002-A1, PUR00533092, ALSP22-0001, and ACS22-05-CAIR-A1 Federal Award Year: 8/1/2022 to 3/31/2025 Compliance Requirement: Activities Allowed or Unallowed Criteria: Management is responsible for designing, implementing, and maintaining an internal control system that ensures accurate financial reporting. Effective internal control over financial reporting provides reasonable assurance regarding the completeness and accuracy of accounting records, and compliance with grantor requirements. 2 CFR 200.510 Financial Statements require auditees to prepare a Schedule of Expenditures of Federal Awards (SEFA) for the period covered by the auditee's financial statements. This schedule must include the total Federal awards expended, as determined in accordance with 2 CFR 200.502. The information presented should be consistent with the accounting records (i.e., general ledger). In addition, Section 2 CFR 200.302(b)(1) provides that non-Federal entities must maintain effective control over and accountability for all funds, and must identify, in their accounts, all Federal awards received and expended. Condition: During our review of the SEFA, we noted that CAIR-CA currently utilizes workbooks outside of its accounting software to track federal expenditures. The external workbooks do not reconcile directly with the general ledger (GL) requiring management to prepare a separate reconciliation to support the SEFA amounts. Cause: This year marks CAIR-CA’s first Single Audit. As such, processes and internal controls over federal award tracking are still under development. The current system is not yet fully integrated to allow for automated or system-based tracking of federal expenditures by grant. Effect: Relying on manual workbooks to track federal expenditures can be inefficient and may result in inaccurate or incomplete reporting of federal expenditures. Questioned Cost: None Recommendation: We recommend that CAIR-CA enhance its accounting processes to enable the tracking of federal expenditures directly within its accounting software. This can be accomplished by implementing GL tracking codes or tags specifically designated for federal expenditures. Transitioning to a system based tracking approach will support consistency between the general ledger and the SEFA, simplify the process of generating financial reports, and improve the tracking of federal expenditures. Views of Responsible Officials and Corrective Action Plan: Management concurs with the finding and is currently in the process of updating the accounting system to incorporate grant-specific specific tracking codes to further align with federal reporting standards. As part of a layered approach to internal controls, Excel worksheets will continue to be used as a supplementary monitoring tool, providing an additional cross-check to the system-generated reports. Responsible person: Jackie Ramirez, Operations & Finance Associate Director Expected Implementation date: November 20, 2025
2023-001 Implement System-Based Tracking of Federal Expenditures Assistance Listing Number: 93.566 Assistance Listing Program Title: Refugee and Entrant Assistance – State - Administered Programs Federal Agency: Department of Health and Human Services (HHS) Passed Through Entities: 1. California Department of Social Services 2. University of California, San Diego 3. California Rural Legal Assistance Foundation 4. San Diego Refugee Communities Coalition/United Women of East Africa Support Team Federal Award Numbers: ALSP22-0002-A1, PUR00533092, ALSP22-0001, and ACS22-05-CAIR-A1 Federal Award Year: 8/1/2022 to 3/31/2025 Compliance Requirement: Activities Allowed or Unallowed Criteria: Management is responsible for designing, implementing, and maintaining an internal control system that ensures accurate financial reporting. Effective internal control over financial reporting provides reasonable assurance regarding the completeness and accuracy of accounting records, and compliance with grantor requirements. 2 CFR 200.510 Financial Statements require auditees to prepare a Schedule of Expenditures of Federal Awards (SEFA) for the period covered by the auditee's financial statements. This schedule must include the total Federal awards expended, as determined in accordance with 2 CFR 200.502. The information presented should be consistent with the accounting records (i.e., general ledger). In addition, Section 2 CFR 200.302(b)(1) provides that non-Federal entities must maintain effective control over and accountability for all funds, and must identify, in their accounts, all Federal awards received and expended. Condition: During our review of the SEFA, we noted that CAIR-CA currently utilizes workbooks outside of its accounting software to track federal expenditures. The external workbooks do not reconcile directly with the general ledger (GL) requiring management to prepare a separate reconciliation to support the SEFA amounts. Cause: This year marks CAIR-CA’s first Single Audit. As such, processes and internal controls over federal award tracking are still under development. The current system is not yet fully integrated to allow for automated or system-based tracking of federal expenditures by grant. Effect: Relying on manual workbooks to track federal expenditures can be inefficient and may result in inaccurate or incomplete reporting of federal expenditures. Questioned Cost: None Recommendation: We recommend that CAIR-CA enhance its accounting processes to enable the tracking of federal expenditures directly within its accounting software. This can be accomplished by implementing GL tracking codes or tags specifically designated for federal expenditures. Transitioning to a system based tracking approach will support consistency between the general ledger and the SEFA, simplify the process of generating financial reports, and improve the tracking of federal expenditures. Views of Responsible Officials and Corrective Action Plan: Management concurs with the finding and is currently in the process of updating the accounting system to incorporate grant-specific specific tracking codes to further align with federal reporting standards. As part of a layered approach to internal controls, Excel worksheets will continue to be used as a supplementary monitoring tool, providing an additional cross-check to the system-generated reports. Responsible person: Jackie Ramirez, Operations & Finance Associate Director Expected Implementation date: November 20, 2025
Item 2023-004: Preparation of Schedule of Expenditures of Federal Awards Identification of federal programs: All Assistance Listing Numbers included on the schedule of expenditures of federal awards for the period from July 1, 2023 to December 31, 2023. Federal award grant number: 204645, 203684, 236829, 229353, and 031875505 Federal agency: U.S. Department of Agriculture, U.S. Department of Treasury Pass-through entity: Minnesota Department of Health, Minnesota Department of Human Services, and Wisconsin Department of Agriculture, Trade and Consumer Protection Criteria: The Uniform Guidance (2 CFR 200.510) requires the auditee to prepare the schedule of expenditures of federal awards to cover the correct reporting period and contain certain information to be considered complete. Condition: We noted the initial schedule of expenditures of federal awards presented for audit was incorrectly for the year ended June 30, 2024. Once the correct period was determined and the revised schedule of expenditures of federal awards was received for the period from July 1, 2023 to December 31, 2023, additional findings were noted as follows: • Food Distribution Cluster program was not properly grouped by federal Assistance Listing Number. • Pass-through entity identifying numbers listed for three programs were incorrect. Once the pass-through entity numbers were corrected, it was determined that two of the programs were the same and should be combined as one listing. • Coronavirus State and Local Fiscal Recovery Funds had improper identification of federal department, pass-through entity and pass-through entity identifying number. This program was improperly included in the Food Distribution Cluster. Cause: The exceptions noted above were due to a breakdown in SHNLFB’s procedures to ensure that the schedule of expenditures of federal awards is in accordance with the Uniform Guidance. Further, we noted there is no documented review and approval of the schedule of expenditures of federal awards. Effect: Improper schedule of expenditures of federal awards was presented for audit. Questioned costs: None Context: The schedule of expenditures of federal awards was not prepared consistent with the requirements of the Uniform Guidance (2 CFR 200.510). Repeat finding: No Recommendation: SHNLFB should continue to improve its procedures around the preparation and review of the schedule of expenditures of federal awards. Views of responsible officials of the auditee: SHNLFB concurs with this finding and a response is included in the corrective action plan.
Item 2023-004: Preparation of Schedule of Expenditures of Federal Awards Identification of federal programs: All Assistance Listing Numbers included on the schedule of expenditures of federal awards for the period from July 1, 2023 to December 31, 2023. Federal award grant number: 204645, 203684, 236829, 229353, and 031875505 Federal agency: U.S. Department of Agriculture, U.S. Department of Treasury Pass-through entity: Minnesota Department of Health, Minnesota Department of Human Services, and Wisconsin Department of Agriculture, Trade and Consumer Protection Criteria: The Uniform Guidance (2 CFR 200.510) requires the auditee to prepare the schedule of expenditures of federal awards to cover the correct reporting period and contain certain information to be considered complete. Condition: We noted the initial schedule of expenditures of federal awards presented for audit was incorrectly for the year ended June 30, 2024. Once the correct period was determined and the revised schedule of expenditures of federal awards was received for the period from July 1, 2023 to December 31, 2023, additional findings were noted as follows: • Food Distribution Cluster program was not properly grouped by federal Assistance Listing Number. • Pass-through entity identifying numbers listed for three programs were incorrect. Once the pass-through entity numbers were corrected, it was determined that two of the programs were the same and should be combined as one listing. • Coronavirus State and Local Fiscal Recovery Funds had improper identification of federal department, pass-through entity and pass-through entity identifying number. This program was improperly included in the Food Distribution Cluster. Cause: The exceptions noted above were due to a breakdown in SHNLFB’s procedures to ensure that the schedule of expenditures of federal awards is in accordance with the Uniform Guidance. Further, we noted there is no documented review and approval of the schedule of expenditures of federal awards. Effect: Improper schedule of expenditures of federal awards was presented for audit. Questioned costs: None Context: The schedule of expenditures of federal awards was not prepared consistent with the requirements of the Uniform Guidance (2 CFR 200.510). Repeat finding: No Recommendation: SHNLFB should continue to improve its procedures around the preparation and review of the schedule of expenditures of federal awards. Views of responsible officials of the auditee: SHNLFB concurs with this finding and a response is included in the corrective action plan.
Item 2023-004: Preparation of Schedule of Expenditures of Federal Awards Identification of federal programs: All Assistance Listing Numbers included on the schedule of expenditures of federal awards for the period from July 1, 2023 to December 31, 2023. Federal award grant number: 204645, 203684, 236829, 229353, and 031875505 Federal agency: U.S. Department of Agriculture, U.S. Department of Treasury Pass-through entity: Minnesota Department of Health, Minnesota Department of Human Services, and Wisconsin Department of Agriculture, Trade and Consumer Protection Criteria: The Uniform Guidance (2 CFR 200.510) requires the auditee to prepare the schedule of expenditures of federal awards to cover the correct reporting period and contain certain information to be considered complete. Condition: We noted the initial schedule of expenditures of federal awards presented for audit was incorrectly for the year ended June 30, 2024. Once the correct period was determined and the revised schedule of expenditures of federal awards was received for the period from July 1, 2023 to December 31, 2023, additional findings were noted as follows: • Food Distribution Cluster program was not properly grouped by federal Assistance Listing Number. • Pass-through entity identifying numbers listed for three programs were incorrect. Once the pass-through entity numbers were corrected, it was determined that two of the programs were the same and should be combined as one listing. • Coronavirus State and Local Fiscal Recovery Funds had improper identification of federal department, pass-through entity and pass-through entity identifying number. This program was improperly included in the Food Distribution Cluster. Cause: The exceptions noted above were due to a breakdown in SHNLFB’s procedures to ensure that the schedule of expenditures of federal awards is in accordance with the Uniform Guidance. Further, we noted there is no documented review and approval of the schedule of expenditures of federal awards. Effect: Improper schedule of expenditures of federal awards was presented for audit. Questioned costs: None Context: The schedule of expenditures of federal awards was not prepared consistent with the requirements of the Uniform Guidance (2 CFR 200.510). Repeat finding: No Recommendation: SHNLFB should continue to improve its procedures around the preparation and review of the schedule of expenditures of federal awards. Views of responsible officials of the auditee: SHNLFB concurs with this finding and a response is included in the corrective action plan.
Item 2023-004: Preparation of Schedule of Expenditures of Federal Awards Identification of federal programs: All Assistance Listing Numbers included on the schedule of expenditures of federal awards for the period from July 1, 2023 to December 31, 2023. Federal award grant number: 204645, 203684, 236829, 229353, and 031875505 Federal agency: U.S. Department of Agriculture, U.S. Department of Treasury Pass-through entity: Minnesota Department of Health, Minnesota Department of Human Services, and Wisconsin Department of Agriculture, Trade and Consumer Protection Criteria: The Uniform Guidance (2 CFR 200.510) requires the auditee to prepare the schedule of expenditures of federal awards to cover the correct reporting period and contain certain information to be considered complete. Condition: We noted the initial schedule of expenditures of federal awards presented for audit was incorrectly for the year ended June 30, 2024. Once the correct period was determined and the revised schedule of expenditures of federal awards was received for the period from July 1, 2023 to December 31, 2023, additional findings were noted as follows: • Food Distribution Cluster program was not properly grouped by federal Assistance Listing Number. • Pass-through entity identifying numbers listed for three programs were incorrect. Once the pass-through entity numbers were corrected, it was determined that two of the programs were the same and should be combined as one listing. • Coronavirus State and Local Fiscal Recovery Funds had improper identification of federal department, pass-through entity and pass-through entity identifying number. This program was improperly included in the Food Distribution Cluster. Cause: The exceptions noted above were due to a breakdown in SHNLFB’s procedures to ensure that the schedule of expenditures of federal awards is in accordance with the Uniform Guidance. Further, we noted there is no documented review and approval of the schedule of expenditures of federal awards. Effect: Improper schedule of expenditures of federal awards was presented for audit. Questioned costs: None Context: The schedule of expenditures of federal awards was not prepared consistent with the requirements of the Uniform Guidance (2 CFR 200.510). Repeat finding: No Recommendation: SHNLFB should continue to improve its procedures around the preparation and review of the schedule of expenditures of federal awards. Views of responsible officials of the auditee: SHNLFB concurs with this finding and a response is included in the corrective action plan.
Item 2023-004: Preparation of Schedule of Expenditures of Federal Awards Identification of federal programs: All Assistance Listing Numbers included on the schedule of expenditures of federal awards for the period from July 1, 2023 to December 31, 2023. Federal award grant number: 204645, 203684, 236829, 229353, and 031875505 Federal agency: U.S. Department of Agriculture, U.S. Department of Treasury Pass-through entity: Minnesota Department of Health, Minnesota Department of Human Services, and Wisconsin Department of Agriculture, Trade and Consumer Protection Criteria: The Uniform Guidance (2 CFR 200.510) requires the auditee to prepare the schedule of expenditures of federal awards to cover the correct reporting period and contain certain information to be considered complete. Condition: We noted the initial schedule of expenditures of federal awards presented for audit was incorrectly for the year ended June 30, 2024. Once the correct period was determined and the revised schedule of expenditures of federal awards was received for the period from July 1, 2023 to December 31, 2023, additional findings were noted as follows: • Food Distribution Cluster program was not properly grouped by federal Assistance Listing Number. • Pass-through entity identifying numbers listed for three programs were incorrect. Once the pass-through entity numbers were corrected, it was determined that two of the programs were the same and should be combined as one listing. • Coronavirus State and Local Fiscal Recovery Funds had improper identification of federal department, pass-through entity and pass-through entity identifying number. This program was improperly included in the Food Distribution Cluster. Cause: The exceptions noted above were due to a breakdown in SHNLFB’s procedures to ensure that the schedule of expenditures of federal awards is in accordance with the Uniform Guidance. Further, we noted there is no documented review and approval of the schedule of expenditures of federal awards. Effect: Improper schedule of expenditures of federal awards was presented for audit. Questioned costs: None Context: The schedule of expenditures of federal awards was not prepared consistent with the requirements of the Uniform Guidance (2 CFR 200.510). Repeat finding: No Recommendation: SHNLFB should continue to improve its procedures around the preparation and review of the schedule of expenditures of federal awards. Views of responsible officials of the auditee: SHNLFB concurs with this finding and a response is included in the corrective action plan.
Item 2023-004: Preparation of Schedule of Expenditures of Federal Awards Identification of federal programs: All Assistance Listing Numbers included on the schedule of expenditures of federal awards for the period from July 1, 2023 to December 31, 2023. Federal award grant number: 204645, 203684, 236829, 229353, and 031875505 Federal agency: U.S. Department of Agriculture, U.S. Department of Treasury Pass-through entity: Minnesota Department of Health, Minnesota Department of Human Services, and Wisconsin Department of Agriculture, Trade and Consumer Protection Criteria: The Uniform Guidance (2 CFR 200.510) requires the auditee to prepare the schedule of expenditures of federal awards to cover the correct reporting period and contain certain information to be considered complete. Condition: We noted the initial schedule of expenditures of federal awards presented for audit was incorrectly for the year ended June 30, 2024. Once the correct period was determined and the revised schedule of expenditures of federal awards was received for the period from July 1, 2023 to December 31, 2023, additional findings were noted as follows: • Food Distribution Cluster program was not properly grouped by federal Assistance Listing Number. • Pass-through entity identifying numbers listed for three programs were incorrect. Once the pass-through entity numbers were corrected, it was determined that two of the programs were the same and should be combined as one listing. • Coronavirus State and Local Fiscal Recovery Funds had improper identification of federal department, pass-through entity and pass-through entity identifying number. This program was improperly included in the Food Distribution Cluster. Cause: The exceptions noted above were due to a breakdown in SHNLFB’s procedures to ensure that the schedule of expenditures of federal awards is in accordance with the Uniform Guidance. Further, we noted there is no documented review and approval of the schedule of expenditures of federal awards. Effect: Improper schedule of expenditures of federal awards was presented for audit. Questioned costs: None Context: The schedule of expenditures of federal awards was not prepared consistent with the requirements of the Uniform Guidance (2 CFR 200.510). Repeat finding: No Recommendation: SHNLFB should continue to improve its procedures around the preparation and review of the schedule of expenditures of federal awards. Views of responsible officials of the auditee: SHNLFB concurs with this finding and a response is included in the corrective action plan.
Item 2023-004: Preparation of Schedule of Expenditures of Federal Awards Identification of federal programs: All Assistance Listing Numbers included on the schedule of expenditures of federal awards for the period from July 1, 2023 to December 31, 2023. Federal award grant number: 204645, 203684, 236829, 229353, and 031875505 Federal agency: U.S. Department of Agriculture, U.S. Department of Treasury Pass-through entity: Minnesota Department of Health, Minnesota Department of Human Services, and Wisconsin Department of Agriculture, Trade and Consumer Protection Criteria: The Uniform Guidance (2 CFR 200.510) requires the auditee to prepare the schedule of expenditures of federal awards to cover the correct reporting period and contain certain information to be considered complete. Condition: We noted the initial schedule of expenditures of federal awards presented for audit was incorrectly for the year ended June 30, 2024. Once the correct period was determined and the revised schedule of expenditures of federal awards was received for the period from July 1, 2023 to December 31, 2023, additional findings were noted as follows: • Food Distribution Cluster program was not properly grouped by federal Assistance Listing Number. • Pass-through entity identifying numbers listed for three programs were incorrect. Once the pass-through entity numbers were corrected, it was determined that two of the programs were the same and should be combined as one listing. • Coronavirus State and Local Fiscal Recovery Funds had improper identification of federal department, pass-through entity and pass-through entity identifying number. This program was improperly included in the Food Distribution Cluster. Cause: The exceptions noted above were due to a breakdown in SHNLFB’s procedures to ensure that the schedule of expenditures of federal awards is in accordance with the Uniform Guidance. Further, we noted there is no documented review and approval of the schedule of expenditures of federal awards. Effect: Improper schedule of expenditures of federal awards was presented for audit. Questioned costs: None Context: The schedule of expenditures of federal awards was not prepared consistent with the requirements of the Uniform Guidance (2 CFR 200.510). Repeat finding: No Recommendation: SHNLFB should continue to improve its procedures around the preparation and review of the schedule of expenditures of federal awards. Views of responsible officials of the auditee: SHNLFB concurs with this finding and a response is included in the corrective action plan.
Item 2023-004: Preparation of Schedule of Expenditures of Federal Awards Identification of federal programs: All Assistance Listing Numbers included on the schedule of expenditures of federal awards for the period from July 1, 2023 to December 31, 2023. Federal award grant number: 204645, 203684, 236829, 229353, and 031875505 Federal agency: U.S. Department of Agriculture, U.S. Department of Treasury Pass-through entity: Minnesota Department of Health, Minnesota Department of Human Services, and Wisconsin Department of Agriculture, Trade and Consumer Protection Criteria: The Uniform Guidance (2 CFR 200.510) requires the auditee to prepare the schedule of expenditures of federal awards to cover the correct reporting period and contain certain information to be considered complete. Condition: We noted the initial schedule of expenditures of federal awards presented for audit was incorrectly for the year ended June 30, 2024. Once the correct period was determined and the revised schedule of expenditures of federal awards was received for the period from July 1, 2023 to December 31, 2023, additional findings were noted as follows: • Food Distribution Cluster program was not properly grouped by federal Assistance Listing Number. • Pass-through entity identifying numbers listed for three programs were incorrect. Once the pass-through entity numbers were corrected, it was determined that two of the programs were the same and should be combined as one listing. • Coronavirus State and Local Fiscal Recovery Funds had improper identification of federal department, pass-through entity and pass-through entity identifying number. This program was improperly included in the Food Distribution Cluster. Cause: The exceptions noted above were due to a breakdown in SHNLFB’s procedures to ensure that the schedule of expenditures of federal awards is in accordance with the Uniform Guidance. Further, we noted there is no documented review and approval of the schedule of expenditures of federal awards. Effect: Improper schedule of expenditures of federal awards was presented for audit. Questioned costs: None Context: The schedule of expenditures of federal awards was not prepared consistent with the requirements of the Uniform Guidance (2 CFR 200.510). Repeat finding: No Recommendation: SHNLFB should continue to improve its procedures around the preparation and review of the schedule of expenditures of federal awards. Views of responsible officials of the auditee: SHNLFB concurs with this finding and a response is included in the corrective action plan.
Material Weakness/Noncompliance – Other 2 CFR §200.510(b) states, in part, that 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 Basis for determining Federal awards expended. At a minimum, the schedule must: a. List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b. For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c. Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d. Include the total amount provided to subrecipients from each Federal program. e. For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f. Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. Subsequent to the original issuance of the 2023 audit report dated July 23, 2024, with the assistance of the pass-through entity, it was determined that the City omitted a federally funded program under the Highway Planning and Construction (ALN 20.205) – PID# 110419. The related expenditures of $2,378,835, were materially misstated by the exclusion from the City’s originally provided SEFA. The City failed to properly identify/communicate the federal designation of the project. Inaccurate completion of the SEFA could lead to inaccurate reporting of federal expenditures by the City and could jeopardize future federal funding. We recommend the City work with its departments to ensure all grant activity is properly included and a materially accurate Schedule is presented for audit. Furthermore, the City can reach out to various Ohio agencies to assist in determining Federal activity. Officials Response: See Corrective Action Plan.
Assistance Listing, Federal Agency, and Program Name 21.027 U.S. Department of the Treasury Coronavirus State and Local Fiscal Recovery Funds Federal Award Identification Number and Year MH 1251 2023 Pass through Entity The Ohio Department of Mental Health and Addiction Services Finding Type Material weakness Repeat Finding No Criteria Per 2 CFR 200.508(b), an auditee must prepare appropriate financial statements, including the schedule of expenditures of federal awards, in accordance with 200.510 financial statements. Per 2 CFR 200.510(b), the auditee must also prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended, as determined in accordance with 200.502 basis for determining federal awards expended. Condition Controls in place were not adequate to ensure the schedule of federal expenditures was complete and accurate. Questioned Costs N/A If questioned costs are not determinable, description of why known questioned costs were undetermined or otherwise could not be reported N/A Identification of How Questioned Costs Were Computed N/A Context ProMedica did not initially include the funds received through the Ohio Department of Mental Health and Addiction Services Coronavirus State and Local Fiscal Recovery funds on the SEFA. Cause and Effect ProMedica has a process in place to identify all potential sources of federal funding received during the year, however they received some incorrect information when going through these procedures, resulting in the SEFA being incomplete for the year ended December 31, 2023. Upon discovery of the error, ProMedica prepared a SEFA that included the Ohio Department of Mental Health and Addiction Services Coronavirus State and Local Fiscal Recovery funds. This lack of controls resulted in the reissuance of the 2023 single audit. Recommendation Management should implement controls to ensure all federal funding received is properly identified as such and included on the SEFA. Views of Responsible Officials and Corrective Action Plan Management fully understands the importance of internal controls to ensure the schedule of federal expenditures is complete and accurate. The Grants Department will amend its current written processes regarding award establishment to include requiring documentation indicating an award is federal funds prior to establishing the project in Infor CloudSuite Financials & Supply Management (Accounting software). Additionally, the Grants Department will routinely audit the database the department utilizes to record awards to ensure the field to note federal awards is properly updated. Furthermore, the SEFA will be reviewed with documented sign-off by each member of the Grants Team prior to submission
Federal Award Number and Award Year AL No. 93.958, 93.959 and 93.558, QG002 20, award year 7/1/2022 – 6/30/2024 AL No. 93.958, 93.959 and 93.558, ME015, award year 7/1/2022 – 6/30/2024 Criteria According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the entity’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502. Additionally, 2 CFR section 200.303 requires that non federal entities receiving federal awards establish and maintain internal control over the federal awards that provides reasonable assurance that the non federal entity is managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards. Condition and Context The Organization did not have adequate internal controls related to reporting of expenditures on the SEFA for Temporary Assistance for Needy Families, Block Grants for Community Mental Health Services, and Block Grants for Prevention and Treatment of Substance Abuse. Specifically, the Organization’s controls to reconcile expenditures from their internal tracking spreadsheets to the appropriate assistance listing numbers within the underlying grant/contract documentation, including the original contract and “Post Award Notices” (PAN) spreadsheets, were not operating as designed. As a result, the Organization determined that $2,601,106 of Temporary Assistance for Needy Families expenditures were incorrectly reported under the Block Grants for Community Mental Health Services and Block Grants for Prevention and Treatment of Substance Abuse programs. Possible Cause and Effect In discussing the condition with the Organization’s management, they stated it was caused by the use of an outdated PAN spreadsheet, which led to expenditures being incorrectly reported on the SEFA under the wrong ALN. Additionally, management review controls over the completeness and accuracy of the SEFA were not designed to detect the error. Failure to establish effective internal controls regarding financial reporting for the preparation of the SEFA may prevent the Organization from completing an audit in accordance with the timelines of Uniform Guidance. Questioned Costs None. Statistically Valid Sample Not applicable Repeat of Prior Finding No Recommendations Management should enhance its system of internal control to ensure that the SEFA is complete and accurate. View of Responsible Official Management agrees with the noted finding.
Federal Award Number and Award Year AL No. 93.958, 93.959 and 93.558, QG002 20, award year 7/1/2022 – 6/30/2024 AL No. 93.958, 93.959 and 93.558, ME015, award year 7/1/2022 – 6/30/2024 Criteria According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the entity’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502. Additionally, 2 CFR section 200.303 requires that non federal entities receiving federal awards establish and maintain internal control over the federal awards that provides reasonable assurance that the non federal entity is managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards. Condition and Context The Organization did not have adequate internal controls related to reporting of expenditures on the SEFA for Temporary Assistance for Needy Families, Block Grants for Community Mental Health Services, and Block Grants for Prevention and Treatment of Substance Abuse. Specifically, the Organization’s controls to reconcile expenditures from their internal tracking spreadsheets to the appropriate assistance listing numbers within the underlying grant/contract documentation, including the original contract and “Post Award Notices” (PAN) spreadsheets, were not operating as designed. As a result, the Organization determined that $2,601,106 of Temporary Assistance for Needy Families expenditures were incorrectly reported under the Block Grants for Community Mental Health Services and Block Grants for Prevention and Treatment of Substance Abuse programs. Possible Cause and Effect In discussing the condition with the Organization’s management, they stated it was caused by the use of an outdated PAN spreadsheet, which led to expenditures being incorrectly reported on the SEFA under the wrong ALN. Additionally, management review controls over the completeness and accuracy of the SEFA were not designed to detect the error. Failure to establish effective internal controls regarding financial reporting for the preparation of the SEFA may prevent the Organization from completing an audit in accordance with the timelines of Uniform Guidance. Questioned Costs None. Statistically Valid Sample Not applicable Repeat of Prior Finding No Recommendations Management should enhance its system of internal control to ensure that the SEFA is complete and accurate. View of Responsible Official Management agrees with the noted finding.
Federal Award Number and Award Year AL No. 93.958, 93.959 and 93.558, QG002 20, award year 7/1/2022 – 6/30/2024 AL No. 93.958, 93.959 and 93.558, ME015, award year 7/1/2022 – 6/30/2024 Criteria According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the entity’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502. Additionally, 2 CFR section 200.303 requires that non federal entities receiving federal awards establish and maintain internal control over the federal awards that provides reasonable assurance that the non federal entity is managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards. Condition and Context The Organization did not have adequate internal controls related to reporting of expenditures on the SEFA for Temporary Assistance for Needy Families, Block Grants for Community Mental Health Services, and Block Grants for Prevention and Treatment of Substance Abuse. Specifically, the Organization’s controls to reconcile expenditures from their internal tracking spreadsheets to the appropriate assistance listing numbers within the underlying grant/contract documentation, including the original contract and “Post Award Notices” (PAN) spreadsheets, were not operating as designed. As a result, the Organization determined that $2,601,106 of Temporary Assistance for Needy Families expenditures were incorrectly reported under the Block Grants for Community Mental Health Services and Block Grants for Prevention and Treatment of Substance Abuse programs. Possible Cause and Effect In discussing the condition with the Organization’s management, they stated it was caused by the use of an outdated PAN spreadsheet, which led to expenditures being incorrectly reported on the SEFA under the wrong ALN. Additionally, management review controls over the completeness and accuracy of the SEFA were not designed to detect the error. Failure to establish effective internal controls regarding financial reporting for the preparation of the SEFA may prevent the Organization from completing an audit in accordance with the timelines of Uniform Guidance. Questioned Costs None. Statistically Valid Sample Not applicable Repeat of Prior Finding No Recommendations Management should enhance its system of internal control to ensure that the SEFA is complete and accurate. View of Responsible Official Management agrees with the noted finding.
Federal Award Number and Award Year AL No. 93.958, 93.959 and 93.558, QG002 20, award year 7/1/2022 – 6/30/2024 AL No. 93.958, 93.959 and 93.558, ME015, award year 7/1/2022 – 6/30/2024 Criteria According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the entity’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502. Additionally, 2 CFR section 200.303 requires that non federal entities receiving federal awards establish and maintain internal control over the federal awards that provides reasonable assurance that the non federal entity is managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards. Condition and Context The Organization did not have adequate internal controls related to reporting of expenditures on the SEFA for Temporary Assistance for Needy Families, Block Grants for Community Mental Health Services, and Block Grants for Prevention and Treatment of Substance Abuse. Specifically, the Organization’s controls to reconcile expenditures from their internal tracking spreadsheets to the appropriate assistance listing numbers within the underlying grant/contract documentation, including the original contract and “Post Award Notices” (PAN) spreadsheets, were not operating as designed. As a result, the Organization determined that $2,601,106 of Temporary Assistance for Needy Families expenditures were incorrectly reported under the Block Grants for Community Mental Health Services and Block Grants for Prevention and Treatment of Substance Abuse programs. Possible Cause and Effect In discussing the condition with the Organization’s management, they stated it was caused by the use of an outdated PAN spreadsheet, which led to expenditures being incorrectly reported on the SEFA under the wrong ALN. Additionally, management review controls over the completeness and accuracy of the SEFA were not designed to detect the error. Failure to establish effective internal controls regarding financial reporting for the preparation of the SEFA may prevent the Organization from completing an audit in accordance with the timelines of Uniform Guidance. Questioned Costs None. Statistically Valid Sample Not applicable Repeat of Prior Finding No Recommendations Management should enhance its system of internal control to ensure that the SEFA is complete and accurate. View of Responsible Official Management agrees with the noted finding.
Federal Award Number and Award Year AL No. 93.958, 93.959 and 93.558, QG002 20, award year 7/1/2022 – 6/30/2024 AL No. 93.958, 93.959 and 93.558, ME015, award year 7/1/2022 – 6/30/2024 Criteria According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the entity’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502. Additionally, 2 CFR section 200.303 requires that non federal entities receiving federal awards establish and maintain internal control over the federal awards that provides reasonable assurance that the non federal entity is managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards. Condition and Context The Organization did not have adequate internal controls related to reporting of expenditures on the SEFA for Temporary Assistance for Needy Families, Block Grants for Community Mental Health Services, and Block Grants for Prevention and Treatment of Substance Abuse. Specifically, the Organization’s controls to reconcile expenditures from their internal tracking spreadsheets to the appropriate assistance listing numbers within the underlying grant/contract documentation, including the original contract and “Post Award Notices” (PAN) spreadsheets, were not operating as designed. As a result, the Organization determined that $2,601,106 of Temporary Assistance for Needy Families expenditures were incorrectly reported under the Block Grants for Community Mental Health Services and Block Grants for Prevention and Treatment of Substance Abuse programs. Possible Cause and Effect In discussing the condition with the Organization’s management, they stated it was caused by the use of an outdated PAN spreadsheet, which led to expenditures being incorrectly reported on the SEFA under the wrong ALN. Additionally, management review controls over the completeness and accuracy of the SEFA were not designed to detect the error. Failure to establish effective internal controls regarding financial reporting for the preparation of the SEFA may prevent the Organization from completing an audit in accordance with the timelines of Uniform Guidance. Questioned Costs None. Statistically Valid Sample Not applicable Repeat of Prior Finding No Recommendations Management should enhance its system of internal control to ensure that the SEFA is complete and accurate. View of Responsible Official Management agrees with the noted finding.
Federal Award Number and Award Year AL No. 93.958, 93.959 and 93.558, QG002 20, award year 7/1/2022 – 6/30/2024 AL No. 93.958, 93.959 and 93.558, ME015, award year 7/1/2022 – 6/30/2024 Criteria According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the entity’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502. Additionally, 2 CFR section 200.303 requires that non federal entities receiving federal awards establish and maintain internal control over the federal awards that provides reasonable assurance that the non federal entity is managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards. Condition and Context The Organization did not have adequate internal controls related to reporting of expenditures on the SEFA for Temporary Assistance for Needy Families, Block Grants for Community Mental Health Services, and Block Grants for Prevention and Treatment of Substance Abuse. Specifically, the Organization’s controls to reconcile expenditures from their internal tracking spreadsheets to the appropriate assistance listing numbers within the underlying grant/contract documentation, including the original contract and “Post Award Notices” (PAN) spreadsheets, were not operating as designed. As a result, the Organization determined that $2,601,106 of Temporary Assistance for Needy Families expenditures were incorrectly reported under the Block Grants for Community Mental Health Services and Block Grants for Prevention and Treatment of Substance Abuse programs. Possible Cause and Effect In discussing the condition with the Organization’s management, they stated it was caused by the use of an outdated PAN spreadsheet, which led to expenditures being incorrectly reported on the SEFA under the wrong ALN. Additionally, management review controls over the completeness and accuracy of the SEFA were not designed to detect the error. Failure to establish effective internal controls regarding financial reporting for the preparation of the SEFA may prevent the Organization from completing an audit in accordance with the timelines of Uniform Guidance. Questioned Costs None. Statistically Valid Sample Not applicable Repeat of Prior Finding No Recommendations Management should enhance its system of internal control to ensure that the SEFA is complete and accurate. View of Responsible Official Management agrees with the noted finding.
Federal Award Number and Award Year AL No. 93.958, 93.959 and 93.558, QG002 20, award year 7/1/2022 – 6/30/2024 AL No. 93.958, 93.959 and 93.558, ME015, award year 7/1/2022 – 6/30/2024 Criteria According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the entity’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502. Additionally, 2 CFR section 200.303 requires that non federal entities receiving federal awards establish and maintain internal control over the federal awards that provides reasonable assurance that the non federal entity is managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards. Condition and Context The Organization did not have adequate internal controls related to reporting of expenditures on the SEFA for Temporary Assistance for Needy Families, Block Grants for Community Mental Health Services, and Block Grants for Prevention and Treatment of Substance Abuse. Specifically, the Organization’s controls to reconcile expenditures from their internal tracking spreadsheets to the appropriate assistance listing numbers within the underlying grant/contract documentation, including the original contract and “Post Award Notices” (PAN) spreadsheets, were not operating as designed. As a result, the Organization determined that $2,601,106 of Temporary Assistance for Needy Families expenditures were incorrectly reported under the Block Grants for Community Mental Health Services and Block Grants for Prevention and Treatment of Substance Abuse programs. Possible Cause and Effect In discussing the condition with the Organization’s management, they stated it was caused by the use of an outdated PAN spreadsheet, which led to expenditures being incorrectly reported on the SEFA under the wrong ALN. Additionally, management review controls over the completeness and accuracy of the SEFA were not designed to detect the error. Failure to establish effective internal controls regarding financial reporting for the preparation of the SEFA may prevent the Organization from completing an audit in accordance with the timelines of Uniform Guidance. Questioned Costs None. Statistically Valid Sample Not applicable Repeat of Prior Finding No Recommendations Management should enhance its system of internal control to ensure that the SEFA is complete and accurate. View of Responsible Official Management agrees with the noted finding.
Federal Award Number and Award Year AL No. 93.958, 93.959 and 93.558, QG002 20, award year 7/1/2022 – 6/30/2024 AL No. 93.958, 93.959 and 93.558, ME015, award year 7/1/2022 – 6/30/2024 Criteria According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the entity’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502. Additionally, 2 CFR section 200.303 requires that non federal entities receiving federal awards establish and maintain internal control over the federal awards that provides reasonable assurance that the non federal entity is managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards. Condition and Context The Organization did not have adequate internal controls related to reporting of expenditures on the SEFA for Temporary Assistance for Needy Families, Block Grants for Community Mental Health Services, and Block Grants for Prevention and Treatment of Substance Abuse. Specifically, the Organization’s controls to reconcile expenditures from their internal tracking spreadsheets to the appropriate assistance listing numbers within the underlying grant/contract documentation, including the original contract and “Post Award Notices” (PAN) spreadsheets, were not operating as designed. As a result, the Organization determined that $2,601,106 of Temporary Assistance for Needy Families expenditures were incorrectly reported under the Block Grants for Community Mental Health Services and Block Grants for Prevention and Treatment of Substance Abuse programs. Possible Cause and Effect In discussing the condition with the Organization’s management, they stated it was caused by the use of an outdated PAN spreadsheet, which led to expenditures being incorrectly reported on the SEFA under the wrong ALN. Additionally, management review controls over the completeness and accuracy of the SEFA were not designed to detect the error. Failure to establish effective internal controls regarding financial reporting for the preparation of the SEFA may prevent the Organization from completing an audit in accordance with the timelines of Uniform Guidance. Questioned Costs None. Statistically Valid Sample Not applicable Repeat of Prior Finding No Recommendations Management should enhance its system of internal control to ensure that the SEFA is complete and accurate. View of Responsible Official Management agrees with the noted finding.
Federal Award Number and Award Year AL No. 93.958, 93.959 and 93.558, QG002 20, award year 7/1/2022 – 6/30/2024 AL No. 93.958, 93.959 and 93.558, ME015, award year 7/1/2022 – 6/30/2024 Criteria According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the entity’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502. Additionally, 2 CFR section 200.303 requires that non federal entities receiving federal awards establish and maintain internal control over the federal awards that provides reasonable assurance that the non federal entity is managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards. Condition and Context The Organization did not have adequate internal controls related to reporting of expenditures on the SEFA for Temporary Assistance for Needy Families, Block Grants for Community Mental Health Services, and Block Grants for Prevention and Treatment of Substance Abuse. Specifically, the Organization’s controls to reconcile expenditures from their internal tracking spreadsheets to the appropriate assistance listing numbers within the underlying grant/contract documentation, including the original contract and “Post Award Notices” (PAN) spreadsheets, were not operating as designed. As a result, the Organization determined that $2,601,106 of Temporary Assistance for Needy Families expenditures were incorrectly reported under the Block Grants for Community Mental Health Services and Block Grants for Prevention and Treatment of Substance Abuse programs. Possible Cause and Effect In discussing the condition with the Organization’s management, they stated it was caused by the use of an outdated PAN spreadsheet, which led to expenditures being incorrectly reported on the SEFA under the wrong ALN. Additionally, management review controls over the completeness and accuracy of the SEFA were not designed to detect the error. Failure to establish effective internal controls regarding financial reporting for the preparation of the SEFA may prevent the Organization from completing an audit in accordance with the timelines of Uniform Guidance. Questioned Costs None. Statistically Valid Sample Not applicable Repeat of Prior Finding No Recommendations Management should enhance its system of internal control to ensure that the SEFA is complete and accurate. View of Responsible Official Management agrees with the noted finding.
Federal Award Number and Award Year AL No. 93.958, 93.959 and 93.558, QG002 20, award year 7/1/2022 – 6/30/2024 AL No. 93.958, 93.959 and 93.558, ME015, award year 7/1/2022 – 6/30/2024 Criteria According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the entity’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502. Additionally, 2 CFR section 200.303 requires that non federal entities receiving federal awards establish and maintain internal control over the federal awards that provides reasonable assurance that the non federal entity is managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards. Condition and Context The Organization did not have adequate internal controls related to reporting of expenditures on the SEFA for Temporary Assistance for Needy Families, Block Grants for Community Mental Health Services, and Block Grants for Prevention and Treatment of Substance Abuse. Specifically, the Organization’s controls to reconcile expenditures from their internal tracking spreadsheets to the appropriate assistance listing numbers within the underlying grant/contract documentation, including the original contract and “Post Award Notices” (PAN) spreadsheets, were not operating as designed. As a result, the Organization determined that $2,601,106 of Temporary Assistance for Needy Families expenditures were incorrectly reported under the Block Grants for Community Mental Health Services and Block Grants for Prevention and Treatment of Substance Abuse programs. Possible Cause and Effect In discussing the condition with the Organization’s management, they stated it was caused by the use of an outdated PAN spreadsheet, which led to expenditures being incorrectly reported on the SEFA under the wrong ALN. Additionally, management review controls over the completeness and accuracy of the SEFA were not designed to detect the error. Failure to establish effective internal controls regarding financial reporting for the preparation of the SEFA may prevent the Organization from completing an audit in accordance with the timelines of Uniform Guidance. Questioned Costs None. Statistically Valid Sample Not applicable Repeat of Prior Finding No Recommendations Management should enhance its system of internal control to ensure that the SEFA is complete and accurate. View of Responsible Official Management agrees with the noted finding.
Finding 2023-002 – SEFA Reporting Federal Program: Medicaid Assistance Program HIV Emergency Relief Project Grants ALNs: 93.778 93.914 Federal Agency: U.S. Department of Health and Human Services Federal Award Years: July 1, 2022 – June 30, 2024 (93.778) March 1, 2022 – February 28, 2024 (93.914) Criteria: 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 Found, Including Perspective: The Schedule of Expenditures of Federal Awards (SEFA) prepared by management contained certain differences between federal expenditures reported and the years in which the federal awards were expended totaling $174,977 related to the Medicaid Assistance Program and $250,808 relate to the HIV Emergency Relief Project Grants. Possible Cause and Effect: While the System performs a review during the compilation of the SEFA, controls were not designed or implemented effectively to ensure that certain amounts were properly reflected on the SEFA in the period in which they were expended. Questioned Costs: None. Statistical Validity: The sample was not intended to be, and was not, a statistically valid sample. Repeat Finding in the Prior Year: Yes – 2022-001 Recommendation We recommend that management implement appropriate controls and processes to ensure that expenditures are presented on the correct SEFA year. Views of Responsible Officials: Grady Memorial Hospital Corporation will implement a control and process to ensure that expenditures are properly reflected on the SEFA.
Finding 2023-003 – SEFA Reporting Federal Program: COVID-19 Coronavirus State and Local Fiscal Recovery Funds Disaster Grants – Public Assistance ALNs: 21.027 97.036 Federal Agency: U.S. Department of Treasury U.S. Department of Homeland Security Federal Award Years: October 1, 2022 – September 20, 2024 (21.027) January 1, 2023 – December 31, 2023 (97.036) Criteria: 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. Additionally, 2 CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designated to reasonably ensure compliance with Federal laws, regulations and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately and completely reported on the SEFA. Condition Found, Including Perspective: The System did not have adequate controls relating to the reporting of expenditures on the SEFA for the FEMA – Disaster Grants – Public Assistance and the Coronavirus State and Local Fiscal Recovery Funds programs. Specifically, the System did not have a control in place to ensure that all FEMA awards obligated during the year were recorded on the SEFA. Additionally, the System did not have a control in place to ensure that all incurred expenditures were properly accrued on the SEFA. As a result, the expenditures on the SEFA were understated as follows: • Expenditures of $2,038,362 for the FEMA – Disaster Grants – Public Assistance program were obligated and incurred as of December 31, 2023 but not recorded on the SEFA. • Expenditures of $2,790,267 for the Coronavirus State and Local Fiscal Recovery Funds program were incurred but not accrued for at year end. • Expenditures of $7,529,167 for the Coronavirus State and Local Fiscal Recovery Funds program which were incurred during 2023 and subsequently identified by management to be submitted for reimbursement under the federal award. Possible Cause and Effect: While the System performs a review during the compilation of the SEFA, controls were not designed or implemented effectively to ensure that amounts were properly recognized on the SEFA in the period in which they were expended. Failure to establish effective internal controls regarding financial reporting for the preparation of the SEFA may prevent the System from completing an audit in accordance with the timelines of Uniform Guidance. Questioned Costs: None. Statistical Validity: The sample was not intended to be, and was not, a statistically valid sample. Repeat Finding in the Prior Year: This is not a repeat finding. Recommendation We recommend that management implement appropriate controls and processes to ensure that the SEFA is complete and accurate. Views of Responsible Officials: Grady Memorial Hospital Corporation will implement a control and process to ensure that expenditures are properly reflected on the SEFA.
Federal Agency: U.S. Department of the TreasuryFederal Program Name: Emergency Rental Assistance Program (ERAP) Assistance Listing Number: 21.023 Federal Award Identification Number and Year: Various Pass-Through Agency: Pennsylvania Department of Health and Human Services Pass-Through Number(s): ERA-2101060067, ERA2-0391, ERAP2 Award Period: 1/1/2023 – 12/31/23 Type of Finding: Significant Deficiency in Internal Control Over Compliance Criteria or Specific RequirementUniform guidance requires the auditee to prepare a schedule of expenditures of federal awards (SEFA) which must include the total federal awards expended as determined in accordance with sub-section 200.502. 2 CFR 200.510. A non-federal entity must maintain effective internal control over the federal award (2 CFR 200.303).Condition and ContextPolicies and controls in place regarding the completeness of the SEFA were not properly functioning. Within the supporting listing of expenses relating to ERAP expenditures, six transactions were identified as prior fiscal-year expenditures that were included in the unadjusted 2023 expenditure total. The County revised the 2023 SEFA to exclude the 2022 expenditures. Questioned Costs$33,301 Cause Controls ensuring that only federal expenditures incurred in the period from January 1, 2023 to December 31, 2023 were not operating as designed.Effect Potential inaccurate expenditure reporting in the SEFA. Repeat Finding No.Recommendation We recommend management should review the process of recording federal expenditures to determine expenditures are being included in the appropriate fiscal year.Views of Responsible Officials There is no disagreement with the audit finding and the County is in the process of implementing corrective procedures.
Federal Agency: U.S. Department of the Treasury Federal Program Name: American Rescue Plan Act / Coronavirus State Fiscal Recovery Fund (ARPA) Assistance Listing Number: 21.027Federal Award Identification Number and Year: Various Pass-Through Agency: Pennsylvania Department of Health and Human Services Pass-Through Number(s): 2022-CG-01-39297, SLFRP3241, C000084584, 4100095388 Award Period: 1/1/2023 – 12/31/23 Type of Finding: Significant Deficiency in Internal Control Over ComplianceCriteria or Specific Requirement Uniform guidance requires the auditee to prepare a schedule of expenditures of federal awards (SEFA) which must include the total federal awards expended as determined in accordance with sub-section 200.502. 2 CFR 200.510. A non-federal entity must maintain effective internal control over the federal award (2 CFR 200.303).Condition and Context Policies and controls in place regarding the completeness of the SEFA were not properly functioning. Within the supporting listing of expenses relating to ARPA expenditures, multiple transactions were identified as 2022 fiscal year expenditures that were included in the in 2023 expenditure total. The County revised the 2023 SEFA to exclude the 2022 expenditures. Questioned Costs$381,675 Cause Controls ensuring that only federal expenditures incurred in the period from January 1, 2023 to December 31, 2023 were not operating as designed. Effect Potential inaccurate expenditure reporting in the SEFA. Repeat Finding No.Recommendation We recommend management should review the process of recording federal expenditures to determine expenditures are being included in the appropriate fiscal year.Views of Responsible Officials There is no disagreement with the audit finding and the County is in the process of implementing corrective procedures.
Finding 2023-003: Material Weakness – SEFA reporting Federal grantor: All Federal Programs Condition: The SEFA was not complete and contained reporting errors. MBDA Supplemental grants were omitted, and the awards amounts, CDFI numbers for other grants in SEFA were inaccurate. Criteria: Per 2 CFR § 200.510(b), the SEFA must include a complete and accurate accounting of all federal awards expended during the fiscal year, including correct CDFI numbers, program names, and total expenditures. Cause: The issues appear to result from a lack of comprehensive review and reconciliation procedures during SEFA preparation. Effect: Incomplete and inaccurate SEFA reporting leads to noncompliance with Uniform Guidance and increases the risk of omitted federal programs, incorrect major program determination, and errors in reporting to federal oversight agencies. Recommendation: The Chamber needs to strengthen internal control over SEFA preparation by implementing a formal review process, verifying all CDFI numbers, and ensuring all federal awards are accurately included. Views of Responsible Officials and Planned Corrective Actions: The Chamber agrees with the finding and is in the process of implementing a better review process that will be effective in 2025.
Finding 2023-002: Material Weakness – Revised Schedule of Expenditures of Federal Awards Federal Grantor: U.S. Department of Treasury Passed-through: City and County of Sacramento Compliance Requirement: Reporting Condition: Expenditures reported on the SEFA were revised during the single audit. Criteria: Per 2 CFR § 200.510(b), the SEFA must include a complete and accurate accounting of all federal awards expended during the fiscal year, including correct CDFI numbers, program names, and total expenditures. Cause: The issues appear to result from a lack of comprehensive review and reconciliation procedures during SEFA preparation. Effect: Incomplete and inaccurate SEFA reporting leads to noncompliance with Uniform Guidance and increases the risk of omitted federal programs, incorrect major program determination, and errors in reporting to federal oversight agencies. Recommendation: The Chamber needs to strengthen internal control over SEFA preparation by implementing a formal review process, verifying expenditures are properly reported. Views of Responsible Officials and Planned Corrective Actions: The Chamber agrees with the finding and is in the process of implementing a better review process that will be effective in 2025.
Criteria: Per 2 CFR §200.510(b), the SEFA must include: - A list of individual federal programs by agency, including the Assistance Listing number. - The total federal awards expended for each program, including capital projects funded by federal grants. - Amounts passed through to subrecipients. - Outstanding balances for loan or loan guarantee programs. - Significant accounting policies used in preparing the SEFA. Condition: During our audit of the Schedule of Expenditures of Federal Awards (SEFA), we identified that the schedule was incomplete. Specifically, certain federal awards were either omitted or incorrectly reported, including a significant omission of During 2023, there was approximately $16.5 million in federal funds received for capital projects. These amounts should have been included in the SEFA as part of the entity's total federal expenditures. Cause: The omission of the capital project funds appears to have resulted from a misunderstanding of what constitutes an expenditure for SEFA reporting purposes. The entity may not have recognized that capital outlays funded by federal grants must be included, leading to an understated SEFA. Other errors in the SEFA appear to have resulted from inadequate reconciliation processes between the entity's accounting records and federal grant reports. Possible effect: An incomplete SEFA could result in noncompliance with the Uniform Guidance and an incomplete Single Audit. Questioned cost: N/A Recommendation: We recommend that management: - Implement a reconciliation process to ensure that all federal expenditures are accurately captured in the SEFA. - Provide additional training for accounting personnel on federal reporting requirements. - Review all local government awards to determine whether Federal funds are a component of the contracts. - Review SEFA data for completeness and accuracy before submission. Views of responsible officials: The Schedule of Expenditures of Federal Awards (SEFA) provided to the audit firm was incomplete due to two primary factors: (1) insufficient understanding by staff regarding the requirement to include federally funded capital expenditures, and (2) improper recording of property acquisitions. Management acknowledges this oversight, which occurred during the implementation of a new program and at a time when staff were not fully aware that such expenditures must be reflected on the SEFA. Furthermore, certain capital expenditures paid directly through escrow were not recorded in the organization's accounting records. To remediate these issues, management has taken the following corrective actions: - Delivered targeted training to staff on the proper treatment and reporting of federally funded capital expenditures; - Updated internal closing and reporting procedures to incorporate a formal review of balance sheet activity; and - Updated internal closing and reporting procedures to incorporate a reconciliation to settlement statements when recording new property acquisitions; and - Strengthened internal controls to ensure all federally funded capital items are accurately captured in future SEFA submissions. Management is committed to maintaining compliance with federal reporting requirements and ensuring the completeness and accuracy of future SEFAfilings.
Finding 2023-003 – Huerfano County - Internal controls over the preparation of the SEFA Criteria: In accordance with 2 CFR Part 200.510(b)(2), the auditee is responsible for preparing a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR Part 200.303(a) and 2 CFR Part 200.502. Condition: The County does not have adequate internal controls to ensure the SEFA accurately reports all federal assistance the county receives. Cause: Grant management at the county is decentralized and departments are responsible for providing the required information to the County’s department of finance to facilitate the preparation of the SEFA. The department of finance was not provided accurate federal program expenditures. Effect: The SEFA did not correctly report all Federal expenditures. The Federal government relies on the SEFA information to be reported accurately. In addition, accurate SEFA information is relied upon by the auditors in order to perform the major program determinations utilized to select the Federal programs subject to Single Audit procedures. Questioned Costs: None reported. Repeat Finding: No. Recommendation: We recommend the County implement a countywide system to allow for a more automated system of tracking federal expenditures, that may include updated processes to be developed to set up new organization codes which would require grant managers to provide the required information needed for accurate SEFA preparation. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has implemented new process to ensure accurate preparation of their SEFA’s.
2023-003: Internal Control Over Schedule of Expenditures of Federal Awards Federal Grantor: U.S. Department of Agriculture (USDA), U.S. Department of the Interior (Interior), U.S. Department of Justice (DOJ), U.S. Department of Transportation (DOT), U.S. Department of the Treasury (Treasury), and U.S. Department of Health and Human Services (HHS) Pass-Through Grantor: Missouri Department of Health and Senior Services, Missouri Department of Public Safety, and Missouri Department of Transportation Federal Assistance Listing Number: 10.557, 10.665, 15.226, 16.738, 20.205, 21.027, 93.069, 93.323, 93.354, 93.767, 93.778, 93.967 and 93.994 Program Title: Special Supplemental Nutrition Program for Women, Infants, and Children; Schools and Roads – Grants to States; Payments in Lieu of Taxes; Edward Byrne Memorial Justice Assistance Grant Program; Highway Planning and Construction; Coronavirus State and Local Fiscal Recovery Funds; Public Health Emergency Preparedness; Epidemiology and Laboratory Capacity for Infectious Diseases; Public Health Emergency Response; Children’s Health Insurance Program; Grants to States for Medicaid; CDC Collaboration with Academia to Strengthen Public Health; Maternal and Child Health Services Block Grant Pass-through Entity Identifying Number: ERS04523109, BRO-B020(18), BRO-B020(19), SLFRP4542-CJMI005, DH220051995, DH2200517449, CK000546-01B, DH230051996, DH220051742, OE00007201A1, DH220051847 Award Year: 2022 and 2023 Questioned Costs: None Criteria: 2 CFR 200.510(b) requires auditees to prepare a schedule of expenditures of federal awards (SEFA) which must report total federal awards expended during the audit period. At a minimum, the schedule must include: expenditures by individual federal program, name of the pass-through entity and identifying number for awards not received directly from the federal government, and the total amount provided to subrecipients from each federal program. The County has not implemented proper internal controls to ensure the completeness and accuracy of the SEFA. Condition: The SEFA reported by the County in the 2023 and 2024 annual budget documents contained errors in amounts of federal expenditures reported. Discrepancies in amounts reported on the 2022 SEFA and amount supported by underlying accounting records are summarized as follows: Discrepancies in amounts reported on the 2023 SEFA and amount supported by underlying accounting records are summarized as follows: Cause: The County has not implemented a proper system of internal control over SEFA preparation, such as a reconciliation to underlying accounting records or having a separate individual review the SEFA for clerical accuracy after it has been prepared. Reasons for discrepancies in individual programs varied. Effect: The SEFA presented for audit did not accurately reflect the County’s actual expenditures of federal awards for both the years ended December 31, 2023 and 2022. Recommendation: We recommend that the County implement internal controls to ensure that the SEFA completely and accurately states the expenditures of federal awards of the County each year.
2023-004 SEFA REPORTING Federal Program Information: Federal Agency and Program Name Federal Assistance Listing Number National Endowment for the Humanities Promotion of the Humanities Federal/State Partnership Grant Number: SO-289836-23 45.129 Criteria: 2 CFR 200.303 requires that a 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 and the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).” 2 CFR 200.510(b) states that “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 2 CFR 200.502.” Condition: The Council’s internal controls are not adequate to ensure the Schedule of Expenditures of Federal Awards (SEFA) accurately reports Federal assistance. The Council’s fiscal year 2023 SEFA for the Promotion of the Humanities Federal/State Partnership program included expenditures from other fiscal years. Questioned Costs: $4,015 Context: Total federal expenditures for the Promotion of the Humanities Federal/State Partnership program were $1,019,055 for the year ended October 31, 2023. Cause: The Council does not have adequate internal controls in place to ensure the accuracy of the SEFA. Effect: The Council is not reporting accurate financial information in its SEFA. Identification as a Repeat Finding: This is not a repeat finding from the prior year. Recommendation: We recommend that the Council implement controls over financial reporting, including the SEFA, to ensure accuracy of financial data. Views of Responsible Officials: Management acknowledges the finding. See corrective action plan.
2023-004 SEFA REPORTING Federal Program Information: Federal Agency and Program Name Federal Assistance Listing Number National Endowment for the Humanities Promotion of the Humanities Federal/State Partnership Grant Number: SO-289836-23 45.129 Criteria: 2 CFR 200.303 requires that a 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 and the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).” 2 CFR 200.510(b) states that “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 2 CFR 200.502.” Condition: The Council’s internal controls are not adequate to ensure the Schedule of Expenditures of Federal Awards (SEFA) accurately reports Federal assistance. The Council’s fiscal year 2023 SEFA for the Promotion of the Humanities Federal/State Partnership program included expenditures from other fiscal years. Questioned Costs: $4,015 Context: Total federal expenditures for the Promotion of the Humanities Federal/State Partnership program were $1,019,055 for the year ended October 31, 2023. Cause: The Council does not have adequate internal controls in place to ensure the accuracy of the SEFA. Effect: The Council is not reporting accurate financial information in its SEFA. Identification as a Repeat Finding: This is not a repeat finding from the prior year. Recommendation: We recommend that the Council implement controls over financial reporting, including the SEFA, to ensure accuracy of financial data. Views of Responsible Officials: Management acknowledges the finding. See corrective action plan.
U.S. Department of Homeland Security, U.S. Department of Justice, and U.S. Department of Health and Human Services #2023-011 – Major Federal Award Finding Nature of Finding: Significant Deficiency in Internal Controls over Compliance This is a repeat of prior year finding #2022-007. Criteria/Condition: Per 2 CFR 200.510(b), 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. For SEFA reporting, federal expenditures were not disclosed for one program and were overstated or understated for other programs. Cause/Context: Expenditures for the Emergency Food and Shelter National Board Program were excluded from the client-prepared SEFA. There were various other grants with allocations between state and federal funding that were not presented properly on the SEFA. The SEFA presented has been adjusted for these errors. Effect: Controls in place did not sufficiently ensure the completeness and accuracy of the SEFA. Recommendation: We recommend the Organization enhance its procedures and controls to ensure data accumulated to prepare the SEFA is complete and accurate. Views of Responsible Officials and Planned Corrective Actions: The Organization will implement the following changes in its accounting procedures: The Schedule of Expenditures of Federal Awards (SEFA) will be reviewed for accuracy by either the CFO or CEO after it is produced, to ensure that all federal awards are included, and that the amounts on the schedule are accurate.
U.S. Department of Homeland Security, U.S. Department of Justice, and U.S. Department of Health and Human Services #2023-011 – Major Federal Award Finding Nature of Finding: Significant Deficiency in Internal Controls over Compliance This is a repeat of prior year finding #2022-007. Criteria/Condition: Per 2 CFR 200.510(b), 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. For SEFA reporting, federal expenditures were not disclosed for one program and were overstated or understated for other programs. Cause/Context: Expenditures for the Emergency Food and Shelter National Board Program were excluded from the client-prepared SEFA. There were various other grants with allocations between state and federal funding that were not presented properly on the SEFA. The SEFA presented has been adjusted for these errors. Effect: Controls in place did not sufficiently ensure the completeness and accuracy of the SEFA. Recommendation: We recommend the Organization enhance its procedures and controls to ensure data accumulated to prepare the SEFA is complete and accurate. Views of Responsible Officials and Planned Corrective Actions: The Organization will implement the following changes in its accounting procedures: The Schedule of Expenditures of Federal Awards (SEFA) will be reviewed for accuracy by either the CFO or CEO after it is produced, to ensure that all federal awards are included, and that the amounts on the schedule are accurate.
U.S. Department of Homeland Security, U.S. Department of Justice, and U.S. Department of Health and Human Services #2023-011 – Major Federal Award Finding Nature of Finding: Significant Deficiency in Internal Controls over Compliance This is a repeat of prior year finding #2022-007. Criteria/Condition: Per 2 CFR 200.510(b), 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. For SEFA reporting, federal expenditures were not disclosed for one program and were overstated or understated for other programs. Cause/Context: Expenditures for the Emergency Food and Shelter National Board Program were excluded from the client-prepared SEFA. There were various other grants with allocations between state and federal funding that were not presented properly on the SEFA. The SEFA presented has been adjusted for these errors. Effect: Controls in place did not sufficiently ensure the completeness and accuracy of the SEFA. Recommendation: We recommend the Organization enhance its procedures and controls to ensure data accumulated to prepare the SEFA is complete and accurate. Views of Responsible Officials and Planned Corrective Actions: The Organization will implement the following changes in its accounting procedures: The Schedule of Expenditures of Federal Awards (SEFA) will be reviewed for accuracy by either the CFO or CEO after it is produced, to ensure that all federal awards are included, and that the amounts on the schedule are accurate.
U.S. Department of Homeland Security, U.S. Department of Justice, and U.S. Department of Health and Human Services #2023-011 – Major Federal Award Finding Nature of Finding: Significant Deficiency in Internal Controls over Compliance This is a repeat of prior year finding #2022-007. Criteria/Condition: Per 2 CFR 200.510(b), 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. For SEFA reporting, federal expenditures were not disclosed for one program and were overstated or understated for other programs. Cause/Context: Expenditures for the Emergency Food and Shelter National Board Program were excluded from the client-prepared SEFA. There were various other grants with allocations between state and federal funding that were not presented properly on the SEFA. The SEFA presented has been adjusted for these errors. Effect: Controls in place did not sufficiently ensure the completeness and accuracy of the SEFA. Recommendation: We recommend the Organization enhance its procedures and controls to ensure data accumulated to prepare the SEFA is complete and accurate. Views of Responsible Officials and Planned Corrective Actions: The Organization will implement the following changes in its accounting procedures: The Schedule of Expenditures of Federal Awards (SEFA) will be reviewed for accuracy by either the CFO or CEO after it is produced, to ensure that all federal awards are included, and that the amounts on the schedule are accurate.
U.S. Department of Homeland Security, U.S. Department of Justice, and U.S. Department of Health and Human Services #2023-011 – Major Federal Award Finding Nature of Finding: Significant Deficiency in Internal Controls over Compliance This is a repeat of prior year finding #2022-007. Criteria/Condition: Per 2 CFR 200.510(b), 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. For SEFA reporting, federal expenditures were not disclosed for one program and were overstated or understated for other programs. Cause/Context: Expenditures for the Emergency Food and Shelter National Board Program were excluded from the client-prepared SEFA. There were various other grants with allocations between state and federal funding that were not presented properly on the SEFA. The SEFA presented has been adjusted for these errors. Effect: Controls in place did not sufficiently ensure the completeness and accuracy of the SEFA. Recommendation: We recommend the Organization enhance its procedures and controls to ensure data accumulated to prepare the SEFA is complete and accurate. Views of Responsible Officials and Planned Corrective Actions: The Organization will implement the following changes in its accounting procedures: The Schedule of Expenditures of Federal Awards (SEFA) will be reviewed for accuracy by either the CFO or CEO after it is produced, to ensure that all federal awards are included, and that the amounts on the schedule are accurate.
U.S. Department of Homeland Security, U.S. Department of Justice, and U.S. Department of Health and Human Services #2023-011 – Major Federal Award Finding Nature of Finding: Significant Deficiency in Internal Controls over Compliance This is a repeat of prior year finding #2022-007. Criteria/Condition: Per 2 CFR 200.510(b), 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. For SEFA reporting, federal expenditures were not disclosed for one program and were overstated or understated for other programs. Cause/Context: Expenditures for the Emergency Food and Shelter National Board Program were excluded from the client-prepared SEFA. There were various other grants with allocations between state and federal funding that were not presented properly on the SEFA. The SEFA presented has been adjusted for these errors. Effect: Controls in place did not sufficiently ensure the completeness and accuracy of the SEFA. Recommendation: We recommend the Organization enhance its procedures and controls to ensure data accumulated to prepare the SEFA is complete and accurate. Views of Responsible Officials and Planned Corrective Actions: The Organization will implement the following changes in its accounting procedures: The Schedule of Expenditures of Federal Awards (SEFA) will be reviewed for accuracy by either the CFO or CEO after it is produced, to ensure that all federal awards are included, and that the amounts on the schedule are accurate.
U.S. Department of Homeland Security, U.S. Department of Justice, and U.S. Department of Health and Human Services #2023-011 – Major Federal Award Finding Nature of Finding: Significant Deficiency in Internal Controls over Compliance This is a repeat of prior year finding #2022-007. Criteria/Condition: Per 2 CFR 200.510(b), 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. For SEFA reporting, federal expenditures were not disclosed for one program and were overstated or understated for other programs. Cause/Context: Expenditures for the Emergency Food and Shelter National Board Program were excluded from the client-prepared SEFA. There were various other grants with allocations between state and federal funding that were not presented properly on the SEFA. The SEFA presented has been adjusted for these errors. Effect: Controls in place did not sufficiently ensure the completeness and accuracy of the SEFA. Recommendation: We recommend the Organization enhance its procedures and controls to ensure data accumulated to prepare the SEFA is complete and accurate. Views of Responsible Officials and Planned Corrective Actions: The Organization will implement the following changes in its accounting procedures: The Schedule of Expenditures of Federal Awards (SEFA) will be reviewed for accuracy by either the CFO or CEO after it is produced, to ensure that all federal awards are included, and that the amounts on the schedule are accurate.
U.S. Department of Homeland Security, U.S. Department of Justice, and U.S. Department of Health and Human Services #2023-011 – Major Federal Award Finding Nature of Finding: Significant Deficiency in Internal Controls over Compliance This is a repeat of prior year finding #2022-007. Criteria/Condition: Per 2 CFR 200.510(b), 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. For SEFA reporting, federal expenditures were not disclosed for one program and were overstated or understated for other programs. Cause/Context: Expenditures for the Emergency Food and Shelter National Board Program were excluded from the client-prepared SEFA. There were various other grants with allocations between state and federal funding that were not presented properly on the SEFA. The SEFA presented has been adjusted for these errors. Effect: Controls in place did not sufficiently ensure the completeness and accuracy of the SEFA. Recommendation: We recommend the Organization enhance its procedures and controls to ensure data accumulated to prepare the SEFA is complete and accurate. Views of Responsible Officials and Planned Corrective Actions: The Organization will implement the following changes in its accounting procedures: The Schedule of Expenditures of Federal Awards (SEFA) will be reviewed for accuracy by either the CFO or CEO after it is produced, to ensure that all federal awards are included, and that the amounts on the schedule are accurate.
U.S. Department of Homeland Security, U.S. Department of Justice, and U.S. Department of Health and Human Services #2023-011 – Major Federal Award Finding Nature of Finding: Significant Deficiency in Internal Controls over Compliance This is a repeat of prior year finding #2022-007. Criteria/Condition: Per 2 CFR 200.510(b), 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. For SEFA reporting, federal expenditures were not disclosed for one program and were overstated or understated for other programs. Cause/Context: Expenditures for the Emergency Food and Shelter National Board Program were excluded from the client-prepared SEFA. There were various other grants with allocations between state and federal funding that were not presented properly on the SEFA. The SEFA presented has been adjusted for these errors. Effect: Controls in place did not sufficiently ensure the completeness and accuracy of the SEFA. Recommendation: We recommend the Organization enhance its procedures and controls to ensure data accumulated to prepare the SEFA is complete and accurate. Views of Responsible Officials and Planned Corrective Actions: The Organization will implement the following changes in its accounting procedures: The Schedule of Expenditures of Federal Awards (SEFA) will be reviewed for accuracy by either the CFO or CEO after it is produced, to ensure that all federal awards are included, and that the amounts on the schedule are accurate.
U.S. Department of Homeland Security, U.S. Department of Justice, and U.S. Department of Health and Human Services #2023-011 – Major Federal Award Finding Nature of Finding: Significant Deficiency in Internal Controls over Compliance This is a repeat of prior year finding #2022-007. Criteria/Condition: Per 2 CFR 200.510(b), 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. For SEFA reporting, federal expenditures were not disclosed for one program and were overstated or understated for other programs. Cause/Context: Expenditures for the Emergency Food and Shelter National Board Program were excluded from the client-prepared SEFA. There were various other grants with allocations between state and federal funding that were not presented properly on the SEFA. The SEFA presented has been adjusted for these errors. Effect: Controls in place did not sufficiently ensure the completeness and accuracy of the SEFA. Recommendation: We recommend the Organization enhance its procedures and controls to ensure data accumulated to prepare the SEFA is complete and accurate. Views of Responsible Officials and Planned Corrective Actions: The Organization will implement the following changes in its accounting procedures: The Schedule of Expenditures of Federal Awards (SEFA) will be reviewed for accuracy by either the CFO or CEO after it is produced, to ensure that all federal awards are included, and that the amounts on the schedule are accurate.
U.S. Department of Homeland Security, U.S. Department of Justice, and U.S. Department of Health and Human Services #2023-011 – Major Federal Award Finding Nature of Finding: Significant Deficiency in Internal Controls over Compliance This is a repeat of prior year finding #2022-007. Criteria/Condition: Per 2 CFR 200.510(b), 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. For SEFA reporting, federal expenditures were not disclosed for one program and were overstated or understated for other programs. Cause/Context: Expenditures for the Emergency Food and Shelter National Board Program were excluded from the client-prepared SEFA. There were various other grants with allocations between state and federal funding that were not presented properly on the SEFA. The SEFA presented has been adjusted for these errors. Effect: Controls in place did not sufficiently ensure the completeness and accuracy of the SEFA. Recommendation: We recommend the Organization enhance its procedures and controls to ensure data accumulated to prepare the SEFA is complete and accurate. Views of Responsible Officials and Planned Corrective Actions: The Organization will implement the following changes in its accounting procedures: The Schedule of Expenditures of Federal Awards (SEFA) will be reviewed for accuracy by either the CFO or CEO after it is produced, to ensure that all federal awards are included, and that the amounts on the schedule are accurate.
U.S. Department of Homeland Security, U.S. Department of Justice, and U.S. Department of Health and Human Services #2023-011 – Major Federal Award Finding Nature of Finding: Significant Deficiency in Internal Controls over Compliance This is a repeat of prior year finding #2022-007. Criteria/Condition: Per 2 CFR 200.510(b), 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. For SEFA reporting, federal expenditures were not disclosed for one program and were overstated or understated for other programs. Cause/Context: Expenditures for the Emergency Food and Shelter National Board Program were excluded from the client-prepared SEFA. There were various other grants with allocations between state and federal funding that were not presented properly on the SEFA. The SEFA presented has been adjusted for these errors. Effect: Controls in place did not sufficiently ensure the completeness and accuracy of the SEFA. Recommendation: We recommend the Organization enhance its procedures and controls to ensure data accumulated to prepare the SEFA is complete and accurate. Views of Responsible Officials and Planned Corrective Actions: The Organization will implement the following changes in its accounting procedures: The Schedule of Expenditures of Federal Awards (SEFA) will be reviewed for accuracy by either the CFO or CEO after it is produced, to ensure that all federal awards are included, and that the amounts on the schedule are accurate.
U.S. Department of Homeland Security, U.S. Department of Justice, and U.S. Department of Health and Human Services #2023-011 – Major Federal Award Finding Nature of Finding: Significant Deficiency in Internal Controls over Compliance This is a repeat of prior year finding #2022-007. Criteria/Condition: Per 2 CFR 200.510(b), 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. For SEFA reporting, federal expenditures were not disclosed for one program and were overstated or understated for other programs. Cause/Context: Expenditures for the Emergency Food and Shelter National Board Program were excluded from the client-prepared SEFA. There were various other grants with allocations between state and federal funding that were not presented properly on the SEFA. The SEFA presented has been adjusted for these errors. Effect: Controls in place did not sufficiently ensure the completeness and accuracy of the SEFA. Recommendation: We recommend the Organization enhance its procedures and controls to ensure data accumulated to prepare the SEFA is complete and accurate. Views of Responsible Officials and Planned Corrective Actions: The Organization will implement the following changes in its accounting procedures: The Schedule of Expenditures of Federal Awards (SEFA) will be reviewed for accuracy by either the CFO or CEO after it is produced, to ensure that all federal awards are included, and that the amounts on the schedule are accurate.