Material Weakness in Internal Control over Compliance: Other—Schedule of Expenditure of Federal Awards Preparation Criteria: 2 CFR 200.510 indicates 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. Per 2 CFR 200.502, the determination of when a federal award is expended should be based on when the activity related to the federal award occurs. Generally, the activity pertains to events that require the non-Federal entity to comply with federal statutes, regulations, and the terms and conditions of federal awards, such as: expenditure/expense transactions associated with awards. In addition, 2 CFR Part 200.303 requires the program establish and maintain effective internal controls over federal awards that provide reasonable assurance of compliance with federal statutes, regulations, and the terms and conditions of federal awards. Condition: SEE did not include an existing federally funded contract during the preparation of the SEFA for the year ended December 31, 2023. Cause: SEE was not aware that the contract should be included in the SEFA. Effect or Potential Effect: Due to the control deficiencies described above, if not for auditor assistance, inaccurate expenditures would have been reported to the Federal government. In addition, these errors could result in improper selections of major program(s) for the single audit. Questioned costs: No questioned costs were identified as a result of this compliance finding. Recommendation: We recommend that SEE establish formal procedures to ensure federally funded contracts are included in the SEFA as expenditures. Views of responsible officials and planned corrective actions: Management acknowledges the omission of the federally contract from the auditee’s prepared SEFA. Management is committed to properly preparing the SEFA, and to address this oversight, management will identify trainings for accounting personnel related to SEFA reporting and for those reviewing the schedule, to ensure its accuracy.
Finding: 2023-003 CFDA Number: 21.027 Program Name: Coronavirus State and Local Fiscal Recovery Funds Federal Agency: Department of Treasury/Department of Housing and Community Development Type of Finding: Federal Award Finding Compliance Requirement: Reporting Questioned Costs: N/A Criteria According to 2 CFR 200.510(b), the auditee must prepare a SEFA that includes all federal awards expended, listed by federal program and Assistance Listings Number, along with the total amount provided to subrecipients. The SEFA must also include notes that describe the significant accounting policies used in preparing the schedule. The expenditures must be reported on the same basis of accounting as the auditee’s financial statements. Condition During our audit of the Friends of the Mission's SEFA for the fiscal year ended December 31, 2023, we noted that the SEFA did not accurately report the total federal awards expended for the Department of Treasury, Assistance Listings Number 21.027. The SEFA understated expenditures by $612,964 from the Homekey Program. Cause The auditee’s internal controls over the preparation of the SEFA were not sufficient to ensure all federal expenditures were accurately identified and reported. Additionally, staff responsible for SEFA preparation were not fully trained on the requirements of 2 CFR 200.510(b). Effect: The inaccurate reporting of federal expenditures in the SEFA could lead to noncompliance with federal award requirements, misstatements in the single audit report, and potential delays or errors in the submission of the data collection form to the Federal Audit Clearinghouse. This may also impact the auditee’s ability to demonstrate compliance with federal regulations. Recommendations: We recommend that Friends of the Mission implement the following corrective actions: 1. Develop and document a formal process for preparing the SEFA, including procedures to identify and track all federal awards. 2. Provide training to staff responsible for SEFA preparation on the requirements of 2 CFR 200.510(b). 3. Implement a review process to ensure the SEFA is complete, accurate, and consistent with the auditee’s financial statements prior to submission. 4. Reconcile the SEFA with the general ledger and federal award records to ensure all expenditures are properly reported. Management's Response Management is aware of the finding and has taken steps to rectify the finding so that it does not repeat in future years.
Finding number: 2023-004 – Material Weakness in Internal Control Over Preparation, Reconciliation, and Retention of the Schedule of Expenditures of Federal Awards (SEFA) Federal Program #1 HIV Emergency Relief Project Grants: CFDA Number: 93.914 Federal Program #2 HIV Care Formula Grants): CFDA Number: 93.917 Federal Program #3: HIV Prevention Activities: CFDA Number: 93.941 Name of federal agency: U.S. Department of Health and Human Services (HHS) Name of pass-through entity: Multiple Repeat finding: No AIDS Arms, Inc. dba Prism Health North Texas and Subsidiary Schedule of Findings and Questioned Costs For the Year Ended December 31, 2023 SECTION III - SUMMARY OF FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (continued) Criteria: Under 2 CFR §200.510(b), recipients of federal funds are required to prepare a Schedule of Expenditures of Federal Awards (SEFA) that fairly presents federal expenditures for each grant program and is derived from and supported by the entity's accounting records. Additionally, 2 CFR §200.302 requires that financial management systems adequately identify and account for federal awards to ensure accuracy and compliance with applicable federal requirements. Best practices dictate that federal expenditures should be reconciled regularly to the general ledger, and supporting documentation should be maintained to substantiate amounts reported on the SEFA. Condition: The Organization lacked adequate controls over the preparation, reconciliation, and retention of records related to the SEFA. Specifically: The SEFA incorrectly reported certain federal awards as non-federal awards. The SEFA is prepared based on amounts requested for reimbursement instead of directly based on expenditures incurred. Reconciliation schedules that tied SEFA expenditures directly back to the expenses recorded in the general ledger could not be located. Expenses recorded in the general ledger represent expenses incurred to operate the program in addition to direct grant expenditures; the Organization only requests reimbursement for direct program expenditures allowable under the program. Documentation of Excel-based reconciliations did not agree to reported monthly expenditures, indicating manual reclassification entries between program codes that were not clearly supported. Cause: The deficiencies noted were primarily due to: Lack of system controls to ensure that state and federal expenditures were separately tracked from non-grant funds spent within the same source codes. Turnover in grants management personnel, which resulted in missing, incomplete, or inaccurate reconciling records. Possible effect: Without a complete and accurate SEFA, the Organization risks noncompliance with Uniform Guidance reporting requirements, which could impact its ability to receive and administer federal funds in the future. Additionally, inaccurate SEFA reporting increases the risk of errors in administering funds, questioned costs, and over or under expenditure of grants. Questioned cost: None identified at this time. AIDS Arms, Inc. dba Prism Health North Texas and Subsidiary Schedule of Findings and Questioned Costs For the Year Ended December 31, 2023 SECTION III - SUMMARY OF FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (continued) Recommendation: We recommend that the Organization implement the following measures to improve SEFA preparation and record retention: 1. Develop a Standardized SEFA Reconciliation Process – Implement formal policies and procedures requiring that SEFA expenditures be reconciled to the general ledger on a monthly basis, with documentation maintained for audit purposes. 2. Enhance System Controls for Grant Expenditures – Modify the financial system to allow for the proper segregation of state and federal expenditures from non-grant funds, ensuring that expenditures are properly classified at the time of entry. 3. Require Monthly Documentation Reviews – Establish a control requiring management to review and approve SEFA reconciliation schedules on a monthly or quarterly basis to ensure accuracy and completeness. 4. Implement a Centralized Documentation Retention Policy – Require that all SEFA-related reconciliation records, including general ledger tie-outs and manual adjustments, be retained in a centralized, accessible location. 5. Provide Grants Management Training – Conduct training for grants management and accounting personnel on SEFA preparation requirements, including Uniform Guidance compliance and best practices for documentation and reconciliation. 6. By implementing these measures, the Organization can improve its internal controls over SEFA preparation, ensure compliance with Uniform Guidance, and reduce the risk of reporting inaccuracies. AIDS Arms, Inc. dba Prism Health North Texas and Subsidiary Schedule of Findings and Questioned Costs For the Year Ended December 31, 2023 SECTION III - SUMMARY OF FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (continued) Views of responsible officials: Management partially agrees with the finding. While we acknowledge that documentation supporting SEFA reconciliation was incomplete, we believe that federal expenditures were properly accounted for. We would like to address some of the auditors' points individually: "The SEFA is prepared based on amounts requested for reimbursement instead of directly based on expenditures incurred." Most grant awards do not fully fund the programs they support, most grant awards do not run concurrently with Prism Health North Texas' fiscal year (i.e., with the Calendar Year), and most grant awards are not spent in equal monthly amounts. It is correct that the 2023 SEFA was based on grant-appropriate expenditures that occurred during Calendar Year 2023 and were submitted to those grant sponsors for reimbursement. This will not necessarily reach the full cost to Prism for each grant-supported program, nor is it likely to exactly match any annual grant award amount. "Expenses recorded in the general ledger represent expenses incurred to operate the program in addition to direct grant expenditures; the Organization only requests reimbursement for direct program expenditures allowable under the program." As we confirmed verbally with the audit partner on April 25, 2025, this statement is intended to provide information and context and is not a criticism or intended to point out any problem. As stated above, most grant awards do not fully fund the programs they support; therefore, the general ledger necessarily includes both expenses the sponsor will reimburse and expenses the sponsor will not reimburse. Nonetheless, we are enhancing our reconciliation procedures and documentation practices to fully meet audit requirements. Finding 2023-004 refers to the auditors' assessment of the SEFA preparation and reconciliation processes that occurred in Calendar Year 2023. As of this writing, Prism Health North Texas has already changed its SEFA preparation and reconciliation processes and meets many of the recommendations above. Action Taken: Documentation Retention – On April 25, 2025, management created a structured and easily accessible system for storing all relevant information for all grants management personnel. A logical naming system for files identifying the SEFA period, the funding agency and identified general ledger expenditures claimed on the SEFA. We are now documenting the difference between all GL transactions and those submitted for sponsor reimbursement (i.e., SEFA components) in a single document per fund code, arranged by fiscal year. Previously this documentation was kept by invoice and arranged by grant year. Management will continue to ensure all expenditure-related support, such as invoices and purchase orders, is saved electronically to all AIDS Arms, Inc. dba Prism Health North Texas and Subsidiary Schedule of Findings and Questioned Costs For the Year Ended December 31, 2023 SECTION III - SUMMARY OF FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (continued) financial transactions. SEFA Reconciliation – Management has decided to move from an annual to quarterly SEFA reconciliation process to enhance the frequency of management oversight in SEFA draft preparation. VP of Finance will prepare the SEFA for independent review by the CFO. This will be put into a written policy/procedure. System Enhancements – Prism's current accounting system does not accommodate this. However, Prism is already in the later stages of selecting a new Enterprise Resource Planning (ERP) solution, with this as one of our key selection criteria. Our new ERP should allow for expenditures within the same cost center to be identified as grant-reimbursable or non-grant-reimbursable at the time of entry. We have identified opportunities in new financial management software solutions that we are scheduled to demo May 12th and the 16th of 2025. Opportunities such as: The ability to tag grant-reimbursable transactions, to segment our award cost center into two important categories. The full cost to manage a specific program. Identified cost claimed on the SEFA. Dedicated grant modules that will allow us to establish business rules and workflows to streamline and digitize critical aspects of grant management. Staff Engagement – Cross department coordination meetings occur monthly between the Finance organization and the Grants Management team to continue to foster alignment and collaboration in our grant cycles. A general overview of SEFA, including how to prepare and organize the monthly reconciliations, has already occurred with some of the grants accountants. _________________________________________________________
Finding number: 2023-004 – Material Weakness in Internal Control Over Preparation, Reconciliation, and Retention of the Schedule of Expenditures of Federal Awards (SEFA) Federal Program #1 HIV Emergency Relief Project Grants: CFDA Number: 93.914 Federal Program #2 HIV Care Formula Grants): CFDA Number: 93.917 Federal Program #3: HIV Prevention Activities: CFDA Number: 93.941 Name of federal agency: U.S. Department of Health and Human Services (HHS) Name of pass-through entity: Multiple Repeat finding: No AIDS Arms, Inc. dba Prism Health North Texas and Subsidiary Schedule of Findings and Questioned Costs For the Year Ended December 31, 2023 SECTION III - SUMMARY OF FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (continued) Criteria: Under 2 CFR §200.510(b), recipients of federal funds are required to prepare a Schedule of Expenditures of Federal Awards (SEFA) that fairly presents federal expenditures for each grant program and is derived from and supported by the entity's accounting records. Additionally, 2 CFR §200.302 requires that financial management systems adequately identify and account for federal awards to ensure accuracy and compliance with applicable federal requirements. Best practices dictate that federal expenditures should be reconciled regularly to the general ledger, and supporting documentation should be maintained to substantiate amounts reported on the SEFA. Condition: The Organization lacked adequate controls over the preparation, reconciliation, and retention of records related to the SEFA. Specifically: The SEFA incorrectly reported certain federal awards as non-federal awards. The SEFA is prepared based on amounts requested for reimbursement instead of directly based on expenditures incurred. Reconciliation schedules that tied SEFA expenditures directly back to the expenses recorded in the general ledger could not be located. Expenses recorded in the general ledger represent expenses incurred to operate the program in addition to direct grant expenditures; the Organization only requests reimbursement for direct program expenditures allowable under the program. Documentation of Excel-based reconciliations did not agree to reported monthly expenditures, indicating manual reclassification entries between program codes that were not clearly supported. Cause: The deficiencies noted were primarily due to: Lack of system controls to ensure that state and federal expenditures were separately tracked from non-grant funds spent within the same source codes. Turnover in grants management personnel, which resulted in missing, incomplete, or inaccurate reconciling records. Possible effect: Without a complete and accurate SEFA, the Organization risks noncompliance with Uniform Guidance reporting requirements, which could impact its ability to receive and administer federal funds in the future. Additionally, inaccurate SEFA reporting increases the risk of errors in administering funds, questioned costs, and over or under expenditure of grants. Questioned cost: None identified at this time. AIDS Arms, Inc. dba Prism Health North Texas and Subsidiary Schedule of Findings and Questioned Costs For the Year Ended December 31, 2023 SECTION III - SUMMARY OF FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (continued) Recommendation: We recommend that the Organization implement the following measures to improve SEFA preparation and record retention: 1. Develop a Standardized SEFA Reconciliation Process – Implement formal policies and procedures requiring that SEFA expenditures be reconciled to the general ledger on a monthly basis, with documentation maintained for audit purposes. 2. Enhance System Controls for Grant Expenditures – Modify the financial system to allow for the proper segregation of state and federal expenditures from non-grant funds, ensuring that expenditures are properly classified at the time of entry. 3. Require Monthly Documentation Reviews – Establish a control requiring management to review and approve SEFA reconciliation schedules on a monthly or quarterly basis to ensure accuracy and completeness. 4. Implement a Centralized Documentation Retention Policy – Require that all SEFA-related reconciliation records, including general ledger tie-outs and manual adjustments, be retained in a centralized, accessible location. 5. Provide Grants Management Training – Conduct training for grants management and accounting personnel on SEFA preparation requirements, including Uniform Guidance compliance and best practices for documentation and reconciliation. 6. By implementing these measures, the Organization can improve its internal controls over SEFA preparation, ensure compliance with Uniform Guidance, and reduce the risk of reporting inaccuracies. AIDS Arms, Inc. dba Prism Health North Texas and Subsidiary Schedule of Findings and Questioned Costs For the Year Ended December 31, 2023 SECTION III - SUMMARY OF FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (continued) Views of responsible officials: Management partially agrees with the finding. While we acknowledge that documentation supporting SEFA reconciliation was incomplete, we believe that federal expenditures were properly accounted for. We would like to address some of the auditors' points individually: "The SEFA is prepared based on amounts requested for reimbursement instead of directly based on expenditures incurred." Most grant awards do not fully fund the programs they support, most grant awards do not run concurrently with Prism Health North Texas' fiscal year (i.e., with the Calendar Year), and most grant awards are not spent in equal monthly amounts. It is correct that the 2023 SEFA was based on grant-appropriate expenditures that occurred during Calendar Year 2023 and were submitted to those grant sponsors for reimbursement. This will not necessarily reach the full cost to Prism for each grant-supported program, nor is it likely to exactly match any annual grant award amount. "Expenses recorded in the general ledger represent expenses incurred to operate the program in addition to direct grant expenditures; the Organization only requests reimbursement for direct program expenditures allowable under the program." As we confirmed verbally with the audit partner on April 25, 2025, this statement is intended to provide information and context and is not a criticism or intended to point out any problem. As stated above, most grant awards do not fully fund the programs they support; therefore, the general ledger necessarily includes both expenses the sponsor will reimburse and expenses the sponsor will not reimburse. Nonetheless, we are enhancing our reconciliation procedures and documentation practices to fully meet audit requirements. Finding 2023-004 refers to the auditors' assessment of the SEFA preparation and reconciliation processes that occurred in Calendar Year 2023. As of this writing, Prism Health North Texas has already changed its SEFA preparation and reconciliation processes and meets many of the recommendations above. Action Taken: Documentation Retention – On April 25, 2025, management created a structured and easily accessible system for storing all relevant information for all grants management personnel. A logical naming system for files identifying the SEFA period, the funding agency and identified general ledger expenditures claimed on the SEFA. We are now documenting the difference between all GL transactions and those submitted for sponsor reimbursement (i.e., SEFA components) in a single document per fund code, arranged by fiscal year. Previously this documentation was kept by invoice and arranged by grant year. Management will continue to ensure all expenditure-related support, such as invoices and purchase orders, is saved electronically to all AIDS Arms, Inc. dba Prism Health North Texas and Subsidiary Schedule of Findings and Questioned Costs For the Year Ended December 31, 2023 SECTION III - SUMMARY OF FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (continued) financial transactions. SEFA Reconciliation – Management has decided to move from an annual to quarterly SEFA reconciliation process to enhance the frequency of management oversight in SEFA draft preparation. VP of Finance will prepare the SEFA for independent review by the CFO. This will be put into a written policy/procedure. System Enhancements – Prism's current accounting system does not accommodate this. However, Prism is already in the later stages of selecting a new Enterprise Resource Planning (ERP) solution, with this as one of our key selection criteria. Our new ERP should allow for expenditures within the same cost center to be identified as grant-reimbursable or non-grant-reimbursable at the time of entry. We have identified opportunities in new financial management software solutions that we are scheduled to demo May 12th and the 16th of 2025. Opportunities such as: The ability to tag grant-reimbursable transactions, to segment our award cost center into two important categories. The full cost to manage a specific program. Identified cost claimed on the SEFA. Dedicated grant modules that will allow us to establish business rules and workflows to streamline and digitize critical aspects of grant management. Staff Engagement – Cross department coordination meetings occur monthly between the Finance organization and the Grants Management team to continue to foster alignment and collaboration in our grant cycles. A general overview of SEFA, including how to prepare and organize the monthly reconciliations, has already occurred with some of the grants accountants. _________________________________________________________
Finding number: 2023-004 – Material Weakness in Internal Control Over Preparation, Reconciliation, and Retention of the Schedule of Expenditures of Federal Awards (SEFA) Federal Program #1 HIV Emergency Relief Project Grants: CFDA Number: 93.914 Federal Program #2 HIV Care Formula Grants): CFDA Number: 93.917 Federal Program #3: HIV Prevention Activities: CFDA Number: 93.941 Name of federal agency: U.S. Department of Health and Human Services (HHS) Name of pass-through entity: Multiple Repeat finding: No AIDS Arms, Inc. dba Prism Health North Texas and Subsidiary Schedule of Findings and Questioned Costs For the Year Ended December 31, 2023 SECTION III - SUMMARY OF FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (continued) Criteria: Under 2 CFR §200.510(b), recipients of federal funds are required to prepare a Schedule of Expenditures of Federal Awards (SEFA) that fairly presents federal expenditures for each grant program and is derived from and supported by the entity's accounting records. Additionally, 2 CFR §200.302 requires that financial management systems adequately identify and account for federal awards to ensure accuracy and compliance with applicable federal requirements. Best practices dictate that federal expenditures should be reconciled regularly to the general ledger, and supporting documentation should be maintained to substantiate amounts reported on the SEFA. Condition: The Organization lacked adequate controls over the preparation, reconciliation, and retention of records related to the SEFA. Specifically: The SEFA incorrectly reported certain federal awards as non-federal awards. The SEFA is prepared based on amounts requested for reimbursement instead of directly based on expenditures incurred. Reconciliation schedules that tied SEFA expenditures directly back to the expenses recorded in the general ledger could not be located. Expenses recorded in the general ledger represent expenses incurred to operate the program in addition to direct grant expenditures; the Organization only requests reimbursement for direct program expenditures allowable under the program. Documentation of Excel-based reconciliations did not agree to reported monthly expenditures, indicating manual reclassification entries between program codes that were not clearly supported. Cause: The deficiencies noted were primarily due to: Lack of system controls to ensure that state and federal expenditures were separately tracked from non-grant funds spent within the same source codes. Turnover in grants management personnel, which resulted in missing, incomplete, or inaccurate reconciling records. Possible effect: Without a complete and accurate SEFA, the Organization risks noncompliance with Uniform Guidance reporting requirements, which could impact its ability to receive and administer federal funds in the future. Additionally, inaccurate SEFA reporting increases the risk of errors in administering funds, questioned costs, and over or under expenditure of grants. Questioned cost: None identified at this time. AIDS Arms, Inc. dba Prism Health North Texas and Subsidiary Schedule of Findings and Questioned Costs For the Year Ended December 31, 2023 SECTION III - SUMMARY OF FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (continued) Recommendation: We recommend that the Organization implement the following measures to improve SEFA preparation and record retention: 1. Develop a Standardized SEFA Reconciliation Process – Implement formal policies and procedures requiring that SEFA expenditures be reconciled to the general ledger on a monthly basis, with documentation maintained for audit purposes. 2. Enhance System Controls for Grant Expenditures – Modify the financial system to allow for the proper segregation of state and federal expenditures from non-grant funds, ensuring that expenditures are properly classified at the time of entry. 3. Require Monthly Documentation Reviews – Establish a control requiring management to review and approve SEFA reconciliation schedules on a monthly or quarterly basis to ensure accuracy and completeness. 4. Implement a Centralized Documentation Retention Policy – Require that all SEFA-related reconciliation records, including general ledger tie-outs and manual adjustments, be retained in a centralized, accessible location. 5. Provide Grants Management Training – Conduct training for grants management and accounting personnel on SEFA preparation requirements, including Uniform Guidance compliance and best practices for documentation and reconciliation. 6. By implementing these measures, the Organization can improve its internal controls over SEFA preparation, ensure compliance with Uniform Guidance, and reduce the risk of reporting inaccuracies. AIDS Arms, Inc. dba Prism Health North Texas and Subsidiary Schedule of Findings and Questioned Costs For the Year Ended December 31, 2023 SECTION III - SUMMARY OF FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (continued) Views of responsible officials: Management partially agrees with the finding. While we acknowledge that documentation supporting SEFA reconciliation was incomplete, we believe that federal expenditures were properly accounted for. We would like to address some of the auditors' points individually: "The SEFA is prepared based on amounts requested for reimbursement instead of directly based on expenditures incurred." Most grant awards do not fully fund the programs they support, most grant awards do not run concurrently with Prism Health North Texas' fiscal year (i.e., with the Calendar Year), and most grant awards are not spent in equal monthly amounts. It is correct that the 2023 SEFA was based on grant-appropriate expenditures that occurred during Calendar Year 2023 and were submitted to those grant sponsors for reimbursement. This will not necessarily reach the full cost to Prism for each grant-supported program, nor is it likely to exactly match any annual grant award amount. "Expenses recorded in the general ledger represent expenses incurred to operate the program in addition to direct grant expenditures; the Organization only requests reimbursement for direct program expenditures allowable under the program." As we confirmed verbally with the audit partner on April 25, 2025, this statement is intended to provide information and context and is not a criticism or intended to point out any problem. As stated above, most grant awards do not fully fund the programs they support; therefore, the general ledger necessarily includes both expenses the sponsor will reimburse and expenses the sponsor will not reimburse. Nonetheless, we are enhancing our reconciliation procedures and documentation practices to fully meet audit requirements. Finding 2023-004 refers to the auditors' assessment of the SEFA preparation and reconciliation processes that occurred in Calendar Year 2023. As of this writing, Prism Health North Texas has already changed its SEFA preparation and reconciliation processes and meets many of the recommendations above. Action Taken: Documentation Retention – On April 25, 2025, management created a structured and easily accessible system for storing all relevant information for all grants management personnel. A logical naming system for files identifying the SEFA period, the funding agency and identified general ledger expenditures claimed on the SEFA. We are now documenting the difference between all GL transactions and those submitted for sponsor reimbursement (i.e., SEFA components) in a single document per fund code, arranged by fiscal year. Previously this documentation was kept by invoice and arranged by grant year. Management will continue to ensure all expenditure-related support, such as invoices and purchase orders, is saved electronically to all AIDS Arms, Inc. dba Prism Health North Texas and Subsidiary Schedule of Findings and Questioned Costs For the Year Ended December 31, 2023 SECTION III - SUMMARY OF FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (continued) financial transactions. SEFA Reconciliation – Management has decided to move from an annual to quarterly SEFA reconciliation process to enhance the frequency of management oversight in SEFA draft preparation. VP of Finance will prepare the SEFA for independent review by the CFO. This will be put into a written policy/procedure. System Enhancements – Prism's current accounting system does not accommodate this. However, Prism is already in the later stages of selecting a new Enterprise Resource Planning (ERP) solution, with this as one of our key selection criteria. Our new ERP should allow for expenditures within the same cost center to be identified as grant-reimbursable or non-grant-reimbursable at the time of entry. We have identified opportunities in new financial management software solutions that we are scheduled to demo May 12th and the 16th of 2025. Opportunities such as: The ability to tag grant-reimbursable transactions, to segment our award cost center into two important categories. The full cost to manage a specific program. Identified cost claimed on the SEFA. Dedicated grant modules that will allow us to establish business rules and workflows to streamline and digitize critical aspects of grant management. Staff Engagement – Cross department coordination meetings occur monthly between the Finance organization and the Grants Management team to continue to foster alignment and collaboration in our grant cycles. A general overview of SEFA, including how to prepare and organize the monthly reconciliations, has already occurred with some of the grants accountants. _________________________________________________________
Finding number: 2023-004 – Material Weakness in Internal Control Over Preparation, Reconciliation, and Retention of the Schedule of Expenditures of Federal Awards (SEFA) Federal Program #1 HIV Emergency Relief Project Grants: CFDA Number: 93.914 Federal Program #2 HIV Care Formula Grants): CFDA Number: 93.917 Federal Program #3: HIV Prevention Activities: CFDA Number: 93.941 Name of federal agency: U.S. Department of Health and Human Services (HHS) Name of pass-through entity: Multiple Repeat finding: No AIDS Arms, Inc. dba Prism Health North Texas and Subsidiary Schedule of Findings and Questioned Costs For the Year Ended December 31, 2023 SECTION III - SUMMARY OF FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (continued) Criteria: Under 2 CFR §200.510(b), recipients of federal funds are required to prepare a Schedule of Expenditures of Federal Awards (SEFA) that fairly presents federal expenditures for each grant program and is derived from and supported by the entity's accounting records. Additionally, 2 CFR §200.302 requires that financial management systems adequately identify and account for federal awards to ensure accuracy and compliance with applicable federal requirements. Best practices dictate that federal expenditures should be reconciled regularly to the general ledger, and supporting documentation should be maintained to substantiate amounts reported on the SEFA. Condition: The Organization lacked adequate controls over the preparation, reconciliation, and retention of records related to the SEFA. Specifically: The SEFA incorrectly reported certain federal awards as non-federal awards. The SEFA is prepared based on amounts requested for reimbursement instead of directly based on expenditures incurred. Reconciliation schedules that tied SEFA expenditures directly back to the expenses recorded in the general ledger could not be located. Expenses recorded in the general ledger represent expenses incurred to operate the program in addition to direct grant expenditures; the Organization only requests reimbursement for direct program expenditures allowable under the program. Documentation of Excel-based reconciliations did not agree to reported monthly expenditures, indicating manual reclassification entries between program codes that were not clearly supported. Cause: The deficiencies noted were primarily due to: Lack of system controls to ensure that state and federal expenditures were separately tracked from non-grant funds spent within the same source codes. Turnover in grants management personnel, which resulted in missing, incomplete, or inaccurate reconciling records. Possible effect: Without a complete and accurate SEFA, the Organization risks noncompliance with Uniform Guidance reporting requirements, which could impact its ability to receive and administer federal funds in the future. Additionally, inaccurate SEFA reporting increases the risk of errors in administering funds, questioned costs, and over or under expenditure of grants. Questioned cost: None identified at this time. AIDS Arms, Inc. dba Prism Health North Texas and Subsidiary Schedule of Findings and Questioned Costs For the Year Ended December 31, 2023 SECTION III - SUMMARY OF FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (continued) Recommendation: We recommend that the Organization implement the following measures to improve SEFA preparation and record retention: 1. Develop a Standardized SEFA Reconciliation Process – Implement formal policies and procedures requiring that SEFA expenditures be reconciled to the general ledger on a monthly basis, with documentation maintained for audit purposes. 2. Enhance System Controls for Grant Expenditures – Modify the financial system to allow for the proper segregation of state and federal expenditures from non-grant funds, ensuring that expenditures are properly classified at the time of entry. 3. Require Monthly Documentation Reviews – Establish a control requiring management to review and approve SEFA reconciliation schedules on a monthly or quarterly basis to ensure accuracy and completeness. 4. Implement a Centralized Documentation Retention Policy – Require that all SEFA-related reconciliation records, including general ledger tie-outs and manual adjustments, be retained in a centralized, accessible location. 5. Provide Grants Management Training – Conduct training for grants management and accounting personnel on SEFA preparation requirements, including Uniform Guidance compliance and best practices for documentation and reconciliation. 6. By implementing these measures, the Organization can improve its internal controls over SEFA preparation, ensure compliance with Uniform Guidance, and reduce the risk of reporting inaccuracies. AIDS Arms, Inc. dba Prism Health North Texas and Subsidiary Schedule of Findings and Questioned Costs For the Year Ended December 31, 2023 SECTION III - SUMMARY OF FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (continued) Views of responsible officials: Management partially agrees with the finding. While we acknowledge that documentation supporting SEFA reconciliation was incomplete, we believe that federal expenditures were properly accounted for. We would like to address some of the auditors' points individually: "The SEFA is prepared based on amounts requested for reimbursement instead of directly based on expenditures incurred." Most grant awards do not fully fund the programs they support, most grant awards do not run concurrently with Prism Health North Texas' fiscal year (i.e., with the Calendar Year), and most grant awards are not spent in equal monthly amounts. It is correct that the 2023 SEFA was based on grant-appropriate expenditures that occurred during Calendar Year 2023 and were submitted to those grant sponsors for reimbursement. This will not necessarily reach the full cost to Prism for each grant-supported program, nor is it likely to exactly match any annual grant award amount. "Expenses recorded in the general ledger represent expenses incurred to operate the program in addition to direct grant expenditures; the Organization only requests reimbursement for direct program expenditures allowable under the program." As we confirmed verbally with the audit partner on April 25, 2025, this statement is intended to provide information and context and is not a criticism or intended to point out any problem. As stated above, most grant awards do not fully fund the programs they support; therefore, the general ledger necessarily includes both expenses the sponsor will reimburse and expenses the sponsor will not reimburse. Nonetheless, we are enhancing our reconciliation procedures and documentation practices to fully meet audit requirements. Finding 2023-004 refers to the auditors' assessment of the SEFA preparation and reconciliation processes that occurred in Calendar Year 2023. As of this writing, Prism Health North Texas has already changed its SEFA preparation and reconciliation processes and meets many of the recommendations above. Action Taken: Documentation Retention – On April 25, 2025, management created a structured and easily accessible system for storing all relevant information for all grants management personnel. A logical naming system for files identifying the SEFA period, the funding agency and identified general ledger expenditures claimed on the SEFA. We are now documenting the difference between all GL transactions and those submitted for sponsor reimbursement (i.e., SEFA components) in a single document per fund code, arranged by fiscal year. Previously this documentation was kept by invoice and arranged by grant year. Management will continue to ensure all expenditure-related support, such as invoices and purchase orders, is saved electronically to all AIDS Arms, Inc. dba Prism Health North Texas and Subsidiary Schedule of Findings and Questioned Costs For the Year Ended December 31, 2023 SECTION III - SUMMARY OF FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (continued) financial transactions. SEFA Reconciliation – Management has decided to move from an annual to quarterly SEFA reconciliation process to enhance the frequency of management oversight in SEFA draft preparation. VP of Finance will prepare the SEFA for independent review by the CFO. This will be put into a written policy/procedure. System Enhancements – Prism's current accounting system does not accommodate this. However, Prism is already in the later stages of selecting a new Enterprise Resource Planning (ERP) solution, with this as one of our key selection criteria. Our new ERP should allow for expenditures within the same cost center to be identified as grant-reimbursable or non-grant-reimbursable at the time of entry. We have identified opportunities in new financial management software solutions that we are scheduled to demo May 12th and the 16th of 2025. Opportunities such as: The ability to tag grant-reimbursable transactions, to segment our award cost center into two important categories. The full cost to manage a specific program. Identified cost claimed on the SEFA. Dedicated grant modules that will allow us to establish business rules and workflows to streamline and digitize critical aspects of grant management. Staff Engagement – Cross department coordination meetings occur monthly between the Finance organization and the Grants Management team to continue to foster alignment and collaboration in our grant cycles. A general overview of SEFA, including how to prepare and organize the monthly reconciliations, has already occurred with some of the grants accountants. _________________________________________________________
Finding number: 2023-004 – Material Weakness in Internal Control Over Preparation, Reconciliation, and Retention of the Schedule of Expenditures of Federal Awards (SEFA) Federal Program #1 HIV Emergency Relief Project Grants: CFDA Number: 93.914 Federal Program #2 HIV Care Formula Grants): CFDA Number: 93.917 Federal Program #3: HIV Prevention Activities: CFDA Number: 93.941 Name of federal agency: U.S. Department of Health and Human Services (HHS) Name of pass-through entity: Multiple Repeat finding: No AIDS Arms, Inc. dba Prism Health North Texas and Subsidiary Schedule of Findings and Questioned Costs For the Year Ended December 31, 2023 SECTION III - SUMMARY OF FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (continued) Criteria: Under 2 CFR §200.510(b), recipients of federal funds are required to prepare a Schedule of Expenditures of Federal Awards (SEFA) that fairly presents federal expenditures for each grant program and is derived from and supported by the entity's accounting records. Additionally, 2 CFR §200.302 requires that financial management systems adequately identify and account for federal awards to ensure accuracy and compliance with applicable federal requirements. Best practices dictate that federal expenditures should be reconciled regularly to the general ledger, and supporting documentation should be maintained to substantiate amounts reported on the SEFA. Condition: The Organization lacked adequate controls over the preparation, reconciliation, and retention of records related to the SEFA. Specifically: The SEFA incorrectly reported certain federal awards as non-federal awards. The SEFA is prepared based on amounts requested for reimbursement instead of directly based on expenditures incurred. Reconciliation schedules that tied SEFA expenditures directly back to the expenses recorded in the general ledger could not be located. Expenses recorded in the general ledger represent expenses incurred to operate the program in addition to direct grant expenditures; the Organization only requests reimbursement for direct program expenditures allowable under the program. Documentation of Excel-based reconciliations did not agree to reported monthly expenditures, indicating manual reclassification entries between program codes that were not clearly supported. Cause: The deficiencies noted were primarily due to: Lack of system controls to ensure that state and federal expenditures were separately tracked from non-grant funds spent within the same source codes. Turnover in grants management personnel, which resulted in missing, incomplete, or inaccurate reconciling records. Possible effect: Without a complete and accurate SEFA, the Organization risks noncompliance with Uniform Guidance reporting requirements, which could impact its ability to receive and administer federal funds in the future. Additionally, inaccurate SEFA reporting increases the risk of errors in administering funds, questioned costs, and over or under expenditure of grants. Questioned cost: None identified at this time. AIDS Arms, Inc. dba Prism Health North Texas and Subsidiary Schedule of Findings and Questioned Costs For the Year Ended December 31, 2023 SECTION III - SUMMARY OF FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (continued) Recommendation: We recommend that the Organization implement the following measures to improve SEFA preparation and record retention: 1. Develop a Standardized SEFA Reconciliation Process – Implement formal policies and procedures requiring that SEFA expenditures be reconciled to the general ledger on a monthly basis, with documentation maintained for audit purposes. 2. Enhance System Controls for Grant Expenditures – Modify the financial system to allow for the proper segregation of state and federal expenditures from non-grant funds, ensuring that expenditures are properly classified at the time of entry. 3. Require Monthly Documentation Reviews – Establish a control requiring management to review and approve SEFA reconciliation schedules on a monthly or quarterly basis to ensure accuracy and completeness. 4. Implement a Centralized Documentation Retention Policy – Require that all SEFA-related reconciliation records, including general ledger tie-outs and manual adjustments, be retained in a centralized, accessible location. 5. Provide Grants Management Training – Conduct training for grants management and accounting personnel on SEFA preparation requirements, including Uniform Guidance compliance and best practices for documentation and reconciliation. 6. By implementing these measures, the Organization can improve its internal controls over SEFA preparation, ensure compliance with Uniform Guidance, and reduce the risk of reporting inaccuracies. AIDS Arms, Inc. dba Prism Health North Texas and Subsidiary Schedule of Findings and Questioned Costs For the Year Ended December 31, 2023 SECTION III - SUMMARY OF FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (continued) Views of responsible officials: Management partially agrees with the finding. While we acknowledge that documentation supporting SEFA reconciliation was incomplete, we believe that federal expenditures were properly accounted for. We would like to address some of the auditors' points individually: "The SEFA is prepared based on amounts requested for reimbursement instead of directly based on expenditures incurred." Most grant awards do not fully fund the programs they support, most grant awards do not run concurrently with Prism Health North Texas' fiscal year (i.e., with the Calendar Year), and most grant awards are not spent in equal monthly amounts. It is correct that the 2023 SEFA was based on grant-appropriate expenditures that occurred during Calendar Year 2023 and were submitted to those grant sponsors for reimbursement. This will not necessarily reach the full cost to Prism for each grant-supported program, nor is it likely to exactly match any annual grant award amount. "Expenses recorded in the general ledger represent expenses incurred to operate the program in addition to direct grant expenditures; the Organization only requests reimbursement for direct program expenditures allowable under the program." As we confirmed verbally with the audit partner on April 25, 2025, this statement is intended to provide information and context and is not a criticism or intended to point out any problem. As stated above, most grant awards do not fully fund the programs they support; therefore, the general ledger necessarily includes both expenses the sponsor will reimburse and expenses the sponsor will not reimburse. Nonetheless, we are enhancing our reconciliation procedures and documentation practices to fully meet audit requirements. Finding 2023-004 refers to the auditors' assessment of the SEFA preparation and reconciliation processes that occurred in Calendar Year 2023. As of this writing, Prism Health North Texas has already changed its SEFA preparation and reconciliation processes and meets many of the recommendations above. Action Taken: Documentation Retention – On April 25, 2025, management created a structured and easily accessible system for storing all relevant information for all grants management personnel. A logical naming system for files identifying the SEFA period, the funding agency and identified general ledger expenditures claimed on the SEFA. We are now documenting the difference between all GL transactions and those submitted for sponsor reimbursement (i.e., SEFA components) in a single document per fund code, arranged by fiscal year. Previously this documentation was kept by invoice and arranged by grant year. Management will continue to ensure all expenditure-related support, such as invoices and purchase orders, is saved electronically to all AIDS Arms, Inc. dba Prism Health North Texas and Subsidiary Schedule of Findings and Questioned Costs For the Year Ended December 31, 2023 SECTION III - SUMMARY OF FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (continued) financial transactions. SEFA Reconciliation – Management has decided to move from an annual to quarterly SEFA reconciliation process to enhance the frequency of management oversight in SEFA draft preparation. VP of Finance will prepare the SEFA for independent review by the CFO. This will be put into a written policy/procedure. System Enhancements – Prism's current accounting system does not accommodate this. However, Prism is already in the later stages of selecting a new Enterprise Resource Planning (ERP) solution, with this as one of our key selection criteria. Our new ERP should allow for expenditures within the same cost center to be identified as grant-reimbursable or non-grant-reimbursable at the time of entry. We have identified opportunities in new financial management software solutions that we are scheduled to demo May 12th and the 16th of 2025. Opportunities such as: The ability to tag grant-reimbursable transactions, to segment our award cost center into two important categories. The full cost to manage a specific program. Identified cost claimed on the SEFA. Dedicated grant modules that will allow us to establish business rules and workflows to streamline and digitize critical aspects of grant management. Staff Engagement – Cross department coordination meetings occur monthly between the Finance organization and the Grants Management team to continue to foster alignment and collaboration in our grant cycles. A general overview of SEFA, including how to prepare and organize the monthly reconciliations, has already occurred with some of the grants accountants. _________________________________________________________
Finding number: 2023-004 – Material Weakness in Internal Control Over Preparation, Reconciliation, and Retention of the Schedule of Expenditures of Federal Awards (SEFA) Federal Program #1 HIV Emergency Relief Project Grants: CFDA Number: 93.914 Federal Program #2 HIV Care Formula Grants): CFDA Number: 93.917 Federal Program #3: HIV Prevention Activities: CFDA Number: 93.941 Name of federal agency: U.S. Department of Health and Human Services (HHS) Name of pass-through entity: Multiple Repeat finding: No AIDS Arms, Inc. dba Prism Health North Texas and Subsidiary Schedule of Findings and Questioned Costs For the Year Ended December 31, 2023 SECTION III - SUMMARY OF FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (continued) Criteria: Under 2 CFR §200.510(b), recipients of federal funds are required to prepare a Schedule of Expenditures of Federal Awards (SEFA) that fairly presents federal expenditures for each grant program and is derived from and supported by the entity's accounting records. Additionally, 2 CFR §200.302 requires that financial management systems adequately identify and account for federal awards to ensure accuracy and compliance with applicable federal requirements. Best practices dictate that federal expenditures should be reconciled regularly to the general ledger, and supporting documentation should be maintained to substantiate amounts reported on the SEFA. Condition: The Organization lacked adequate controls over the preparation, reconciliation, and retention of records related to the SEFA. Specifically: The SEFA incorrectly reported certain federal awards as non-federal awards. The SEFA is prepared based on amounts requested for reimbursement instead of directly based on expenditures incurred. Reconciliation schedules that tied SEFA expenditures directly back to the expenses recorded in the general ledger could not be located. Expenses recorded in the general ledger represent expenses incurred to operate the program in addition to direct grant expenditures; the Organization only requests reimbursement for direct program expenditures allowable under the program. Documentation of Excel-based reconciliations did not agree to reported monthly expenditures, indicating manual reclassification entries between program codes that were not clearly supported. Cause: The deficiencies noted were primarily due to: Lack of system controls to ensure that state and federal expenditures were separately tracked from non-grant funds spent within the same source codes. Turnover in grants management personnel, which resulted in missing, incomplete, or inaccurate reconciling records. Possible effect: Without a complete and accurate SEFA, the Organization risks noncompliance with Uniform Guidance reporting requirements, which could impact its ability to receive and administer federal funds in the future. Additionally, inaccurate SEFA reporting increases the risk of errors in administering funds, questioned costs, and over or under expenditure of grants. Questioned cost: None identified at this time. AIDS Arms, Inc. dba Prism Health North Texas and Subsidiary Schedule of Findings and Questioned Costs For the Year Ended December 31, 2023 SECTION III - SUMMARY OF FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (continued) Recommendation: We recommend that the Organization implement the following measures to improve SEFA preparation and record retention: 1. Develop a Standardized SEFA Reconciliation Process – Implement formal policies and procedures requiring that SEFA expenditures be reconciled to the general ledger on a monthly basis, with documentation maintained for audit purposes. 2. Enhance System Controls for Grant Expenditures – Modify the financial system to allow for the proper segregation of state and federal expenditures from non-grant funds, ensuring that expenditures are properly classified at the time of entry. 3. Require Monthly Documentation Reviews – Establish a control requiring management to review and approve SEFA reconciliation schedules on a monthly or quarterly basis to ensure accuracy and completeness. 4. Implement a Centralized Documentation Retention Policy – Require that all SEFA-related reconciliation records, including general ledger tie-outs and manual adjustments, be retained in a centralized, accessible location. 5. Provide Grants Management Training – Conduct training for grants management and accounting personnel on SEFA preparation requirements, including Uniform Guidance compliance and best practices for documentation and reconciliation. 6. By implementing these measures, the Organization can improve its internal controls over SEFA preparation, ensure compliance with Uniform Guidance, and reduce the risk of reporting inaccuracies. AIDS Arms, Inc. dba Prism Health North Texas and Subsidiary Schedule of Findings and Questioned Costs For the Year Ended December 31, 2023 SECTION III - SUMMARY OF FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (continued) Views of responsible officials: Management partially agrees with the finding. While we acknowledge that documentation supporting SEFA reconciliation was incomplete, we believe that federal expenditures were properly accounted for. We would like to address some of the auditors' points individually: "The SEFA is prepared based on amounts requested for reimbursement instead of directly based on expenditures incurred." Most grant awards do not fully fund the programs they support, most grant awards do not run concurrently with Prism Health North Texas' fiscal year (i.e., with the Calendar Year), and most grant awards are not spent in equal monthly amounts. It is correct that the 2023 SEFA was based on grant-appropriate expenditures that occurred during Calendar Year 2023 and were submitted to those grant sponsors for reimbursement. This will not necessarily reach the full cost to Prism for each grant-supported program, nor is it likely to exactly match any annual grant award amount. "Expenses recorded in the general ledger represent expenses incurred to operate the program in addition to direct grant expenditures; the Organization only requests reimbursement for direct program expenditures allowable under the program." As we confirmed verbally with the audit partner on April 25, 2025, this statement is intended to provide information and context and is not a criticism or intended to point out any problem. As stated above, most grant awards do not fully fund the programs they support; therefore, the general ledger necessarily includes both expenses the sponsor will reimburse and expenses the sponsor will not reimburse. Nonetheless, we are enhancing our reconciliation procedures and documentation practices to fully meet audit requirements. Finding 2023-004 refers to the auditors' assessment of the SEFA preparation and reconciliation processes that occurred in Calendar Year 2023. As of this writing, Prism Health North Texas has already changed its SEFA preparation and reconciliation processes and meets many of the recommendations above. Action Taken: Documentation Retention – On April 25, 2025, management created a structured and easily accessible system for storing all relevant information for all grants management personnel. A logical naming system for files identifying the SEFA period, the funding agency and identified general ledger expenditures claimed on the SEFA. We are now documenting the difference between all GL transactions and those submitted for sponsor reimbursement (i.e., SEFA components) in a single document per fund code, arranged by fiscal year. Previously this documentation was kept by invoice and arranged by grant year. Management will continue to ensure all expenditure-related support, such as invoices and purchase orders, is saved electronically to all AIDS Arms, Inc. dba Prism Health North Texas and Subsidiary Schedule of Findings and Questioned Costs For the Year Ended December 31, 2023 SECTION III - SUMMARY OF FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (continued) financial transactions. SEFA Reconciliation – Management has decided to move from an annual to quarterly SEFA reconciliation process to enhance the frequency of management oversight in SEFA draft preparation. VP of Finance will prepare the SEFA for independent review by the CFO. This will be put into a written policy/procedure. System Enhancements – Prism's current accounting system does not accommodate this. However, Prism is already in the later stages of selecting a new Enterprise Resource Planning (ERP) solution, with this as one of our key selection criteria. Our new ERP should allow for expenditures within the same cost center to be identified as grant-reimbursable or non-grant-reimbursable at the time of entry. We have identified opportunities in new financial management software solutions that we are scheduled to demo May 12th and the 16th of 2025. Opportunities such as: The ability to tag grant-reimbursable transactions, to segment our award cost center into two important categories. The full cost to manage a specific program. Identified cost claimed on the SEFA. Dedicated grant modules that will allow us to establish business rules and workflows to streamline and digitize critical aspects of grant management. Staff Engagement – Cross department coordination meetings occur monthly between the Finance organization and the Grants Management team to continue to foster alignment and collaboration in our grant cycles. A general overview of SEFA, including how to prepare and organize the monthly reconciliations, has already occurred with some of the grants accountants. _________________________________________________________
Finding number: 2023-004 – Material Weakness in Internal Control Over Preparation, Reconciliation, and Retention of the Schedule of Expenditures of Federal Awards (SEFA) Federal Program #1 HIV Emergency Relief Project Grants: CFDA Number: 93.914 Federal Program #2 HIV Care Formula Grants): CFDA Number: 93.917 Federal Program #3: HIV Prevention Activities: CFDA Number: 93.941 Name of federal agency: U.S. Department of Health and Human Services (HHS) Name of pass-through entity: Multiple Repeat finding: No AIDS Arms, Inc. dba Prism Health North Texas and Subsidiary Schedule of Findings and Questioned Costs For the Year Ended December 31, 2023 SECTION III - SUMMARY OF FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (continued) Criteria: Under 2 CFR §200.510(b), recipients of federal funds are required to prepare a Schedule of Expenditures of Federal Awards (SEFA) that fairly presents federal expenditures for each grant program and is derived from and supported by the entity's accounting records. Additionally, 2 CFR §200.302 requires that financial management systems adequately identify and account for federal awards to ensure accuracy and compliance with applicable federal requirements. Best practices dictate that federal expenditures should be reconciled regularly to the general ledger, and supporting documentation should be maintained to substantiate amounts reported on the SEFA. Condition: The Organization lacked adequate controls over the preparation, reconciliation, and retention of records related to the SEFA. Specifically: The SEFA incorrectly reported certain federal awards as non-federal awards. The SEFA is prepared based on amounts requested for reimbursement instead of directly based on expenditures incurred. Reconciliation schedules that tied SEFA expenditures directly back to the expenses recorded in the general ledger could not be located. Expenses recorded in the general ledger represent expenses incurred to operate the program in addition to direct grant expenditures; the Organization only requests reimbursement for direct program expenditures allowable under the program. Documentation of Excel-based reconciliations did not agree to reported monthly expenditures, indicating manual reclassification entries between program codes that were not clearly supported. Cause: The deficiencies noted were primarily due to: Lack of system controls to ensure that state and federal expenditures were separately tracked from non-grant funds spent within the same source codes. Turnover in grants management personnel, which resulted in missing, incomplete, or inaccurate reconciling records. Possible effect: Without a complete and accurate SEFA, the Organization risks noncompliance with Uniform Guidance reporting requirements, which could impact its ability to receive and administer federal funds in the future. Additionally, inaccurate SEFA reporting increases the risk of errors in administering funds, questioned costs, and over or under expenditure of grants. Questioned cost: None identified at this time. AIDS Arms, Inc. dba Prism Health North Texas and Subsidiary Schedule of Findings and Questioned Costs For the Year Ended December 31, 2023 SECTION III - SUMMARY OF FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (continued) Recommendation: We recommend that the Organization implement the following measures to improve SEFA preparation and record retention: 1. Develop a Standardized SEFA Reconciliation Process – Implement formal policies and procedures requiring that SEFA expenditures be reconciled to the general ledger on a monthly basis, with documentation maintained for audit purposes. 2. Enhance System Controls for Grant Expenditures – Modify the financial system to allow for the proper segregation of state and federal expenditures from non-grant funds, ensuring that expenditures are properly classified at the time of entry. 3. Require Monthly Documentation Reviews – Establish a control requiring management to review and approve SEFA reconciliation schedules on a monthly or quarterly basis to ensure accuracy and completeness. 4. Implement a Centralized Documentation Retention Policy – Require that all SEFA-related reconciliation records, including general ledger tie-outs and manual adjustments, be retained in a centralized, accessible location. 5. Provide Grants Management Training – Conduct training for grants management and accounting personnel on SEFA preparation requirements, including Uniform Guidance compliance and best practices for documentation and reconciliation. 6. By implementing these measures, the Organization can improve its internal controls over SEFA preparation, ensure compliance with Uniform Guidance, and reduce the risk of reporting inaccuracies. AIDS Arms, Inc. dba Prism Health North Texas and Subsidiary Schedule of Findings and Questioned Costs For the Year Ended December 31, 2023 SECTION III - SUMMARY OF FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (continued) Views of responsible officials: Management partially agrees with the finding. While we acknowledge that documentation supporting SEFA reconciliation was incomplete, we believe that federal expenditures were properly accounted for. We would like to address some of the auditors' points individually: "The SEFA is prepared based on amounts requested for reimbursement instead of directly based on expenditures incurred." Most grant awards do not fully fund the programs they support, most grant awards do not run concurrently with Prism Health North Texas' fiscal year (i.e., with the Calendar Year), and most grant awards are not spent in equal monthly amounts. It is correct that the 2023 SEFA was based on grant-appropriate expenditures that occurred during Calendar Year 2023 and were submitted to those grant sponsors for reimbursement. This will not necessarily reach the full cost to Prism for each grant-supported program, nor is it likely to exactly match any annual grant award amount. "Expenses recorded in the general ledger represent expenses incurred to operate the program in addition to direct grant expenditures; the Organization only requests reimbursement for direct program expenditures allowable under the program." As we confirmed verbally with the audit partner on April 25, 2025, this statement is intended to provide information and context and is not a criticism or intended to point out any problem. As stated above, most grant awards do not fully fund the programs they support; therefore, the general ledger necessarily includes both expenses the sponsor will reimburse and expenses the sponsor will not reimburse. Nonetheless, we are enhancing our reconciliation procedures and documentation practices to fully meet audit requirements. Finding 2023-004 refers to the auditors' assessment of the SEFA preparation and reconciliation processes that occurred in Calendar Year 2023. As of this writing, Prism Health North Texas has already changed its SEFA preparation and reconciliation processes and meets many of the recommendations above. Action Taken: Documentation Retention – On April 25, 2025, management created a structured and easily accessible system for storing all relevant information for all grants management personnel. A logical naming system for files identifying the SEFA period, the funding agency and identified general ledger expenditures claimed on the SEFA. We are now documenting the difference between all GL transactions and those submitted for sponsor reimbursement (i.e., SEFA components) in a single document per fund code, arranged by fiscal year. Previously this documentation was kept by invoice and arranged by grant year. Management will continue to ensure all expenditure-related support, such as invoices and purchase orders, is saved electronically to all AIDS Arms, Inc. dba Prism Health North Texas and Subsidiary Schedule of Findings and Questioned Costs For the Year Ended December 31, 2023 SECTION III - SUMMARY OF FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (continued) financial transactions. SEFA Reconciliation – Management has decided to move from an annual to quarterly SEFA reconciliation process to enhance the frequency of management oversight in SEFA draft preparation. VP of Finance will prepare the SEFA for independent review by the CFO. This will be put into a written policy/procedure. System Enhancements – Prism's current accounting system does not accommodate this. However, Prism is already in the later stages of selecting a new Enterprise Resource Planning (ERP) solution, with this as one of our key selection criteria. Our new ERP should allow for expenditures within the same cost center to be identified as grant-reimbursable or non-grant-reimbursable at the time of entry. We have identified opportunities in new financial management software solutions that we are scheduled to demo May 12th and the 16th of 2025. Opportunities such as: The ability to tag grant-reimbursable transactions, to segment our award cost center into two important categories. The full cost to manage a specific program. Identified cost claimed on the SEFA. Dedicated grant modules that will allow us to establish business rules and workflows to streamline and digitize critical aspects of grant management. Staff Engagement – Cross department coordination meetings occur monthly between the Finance organization and the Grants Management team to continue to foster alignment and collaboration in our grant cycles. A general overview of SEFA, including how to prepare and organize the monthly reconciliations, has already occurred with some of the grants accountants. _________________________________________________________
Finding number: 2023-004 – Material Weakness in Internal Control Over Preparation, Reconciliation, and Retention of the Schedule of Expenditures of Federal Awards (SEFA) Federal Program #1 HIV Emergency Relief Project Grants: CFDA Number: 93.914 Federal Program #2 HIV Care Formula Grants): CFDA Number: 93.917 Federal Program #3: HIV Prevention Activities: CFDA Number: 93.941 Name of federal agency: U.S. Department of Health and Human Services (HHS) Name of pass-through entity: Multiple Repeat finding: No AIDS Arms, Inc. dba Prism Health North Texas and Subsidiary Schedule of Findings and Questioned Costs For the Year Ended December 31, 2023 SECTION III - SUMMARY OF FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (continued) Criteria: Under 2 CFR §200.510(b), recipients of federal funds are required to prepare a Schedule of Expenditures of Federal Awards (SEFA) that fairly presents federal expenditures for each grant program and is derived from and supported by the entity's accounting records. Additionally, 2 CFR §200.302 requires that financial management systems adequately identify and account for federal awards to ensure accuracy and compliance with applicable federal requirements. Best practices dictate that federal expenditures should be reconciled regularly to the general ledger, and supporting documentation should be maintained to substantiate amounts reported on the SEFA. Condition: The Organization lacked adequate controls over the preparation, reconciliation, and retention of records related to the SEFA. Specifically: The SEFA incorrectly reported certain federal awards as non-federal awards. The SEFA is prepared based on amounts requested for reimbursement instead of directly based on expenditures incurred. Reconciliation schedules that tied SEFA expenditures directly back to the expenses recorded in the general ledger could not be located. Expenses recorded in the general ledger represent expenses incurred to operate the program in addition to direct grant expenditures; the Organization only requests reimbursement for direct program expenditures allowable under the program. Documentation of Excel-based reconciliations did not agree to reported monthly expenditures, indicating manual reclassification entries between program codes that were not clearly supported. Cause: The deficiencies noted were primarily due to: Lack of system controls to ensure that state and federal expenditures were separately tracked from non-grant funds spent within the same source codes. Turnover in grants management personnel, which resulted in missing, incomplete, or inaccurate reconciling records. Possible effect: Without a complete and accurate SEFA, the Organization risks noncompliance with Uniform Guidance reporting requirements, which could impact its ability to receive and administer federal funds in the future. Additionally, inaccurate SEFA reporting increases the risk of errors in administering funds, questioned costs, and over or under expenditure of grants. Questioned cost: None identified at this time. AIDS Arms, Inc. dba Prism Health North Texas and Subsidiary Schedule of Findings and Questioned Costs For the Year Ended December 31, 2023 SECTION III - SUMMARY OF FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (continued) Recommendation: We recommend that the Organization implement the following measures to improve SEFA preparation and record retention: 1. Develop a Standardized SEFA Reconciliation Process – Implement formal policies and procedures requiring that SEFA expenditures be reconciled to the general ledger on a monthly basis, with documentation maintained for audit purposes. 2. Enhance System Controls for Grant Expenditures – Modify the financial system to allow for the proper segregation of state and federal expenditures from non-grant funds, ensuring that expenditures are properly classified at the time of entry. 3. Require Monthly Documentation Reviews – Establish a control requiring management to review and approve SEFA reconciliation schedules on a monthly or quarterly basis to ensure accuracy and completeness. 4. Implement a Centralized Documentation Retention Policy – Require that all SEFA-related reconciliation records, including general ledger tie-outs and manual adjustments, be retained in a centralized, accessible location. 5. Provide Grants Management Training – Conduct training for grants management and accounting personnel on SEFA preparation requirements, including Uniform Guidance compliance and best practices for documentation and reconciliation. 6. By implementing these measures, the Organization can improve its internal controls over SEFA preparation, ensure compliance with Uniform Guidance, and reduce the risk of reporting inaccuracies. AIDS Arms, Inc. dba Prism Health North Texas and Subsidiary Schedule of Findings and Questioned Costs For the Year Ended December 31, 2023 SECTION III - SUMMARY OF FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (continued) Views of responsible officials: Management partially agrees with the finding. While we acknowledge that documentation supporting SEFA reconciliation was incomplete, we believe that federal expenditures were properly accounted for. We would like to address some of the auditors' points individually: "The SEFA is prepared based on amounts requested for reimbursement instead of directly based on expenditures incurred." Most grant awards do not fully fund the programs they support, most grant awards do not run concurrently with Prism Health North Texas' fiscal year (i.e., with the Calendar Year), and most grant awards are not spent in equal monthly amounts. It is correct that the 2023 SEFA was based on grant-appropriate expenditures that occurred during Calendar Year 2023 and were submitted to those grant sponsors for reimbursement. This will not necessarily reach the full cost to Prism for each grant-supported program, nor is it likely to exactly match any annual grant award amount. "Expenses recorded in the general ledger represent expenses incurred to operate the program in addition to direct grant expenditures; the Organization only requests reimbursement for direct program expenditures allowable under the program." As we confirmed verbally with the audit partner on April 25, 2025, this statement is intended to provide information and context and is not a criticism or intended to point out any problem. As stated above, most grant awards do not fully fund the programs they support; therefore, the general ledger necessarily includes both expenses the sponsor will reimburse and expenses the sponsor will not reimburse. Nonetheless, we are enhancing our reconciliation procedures and documentation practices to fully meet audit requirements. Finding 2023-004 refers to the auditors' assessment of the SEFA preparation and reconciliation processes that occurred in Calendar Year 2023. As of this writing, Prism Health North Texas has already changed its SEFA preparation and reconciliation processes and meets many of the recommendations above. Action Taken: Documentation Retention – On April 25, 2025, management created a structured and easily accessible system for storing all relevant information for all grants management personnel. A logical naming system for files identifying the SEFA period, the funding agency and identified general ledger expenditures claimed on the SEFA. We are now documenting the difference between all GL transactions and those submitted for sponsor reimbursement (i.e., SEFA components) in a single document per fund code, arranged by fiscal year. Previously this documentation was kept by invoice and arranged by grant year. Management will continue to ensure all expenditure-related support, such as invoices and purchase orders, is saved electronically to all AIDS Arms, Inc. dba Prism Health North Texas and Subsidiary Schedule of Findings and Questioned Costs For the Year Ended December 31, 2023 SECTION III - SUMMARY OF FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (continued) financial transactions. SEFA Reconciliation – Management has decided to move from an annual to quarterly SEFA reconciliation process to enhance the frequency of management oversight in SEFA draft preparation. VP of Finance will prepare the SEFA for independent review by the CFO. This will be put into a written policy/procedure. System Enhancements – Prism's current accounting system does not accommodate this. However, Prism is already in the later stages of selecting a new Enterprise Resource Planning (ERP) solution, with this as one of our key selection criteria. Our new ERP should allow for expenditures within the same cost center to be identified as grant-reimbursable or non-grant-reimbursable at the time of entry. We have identified opportunities in new financial management software solutions that we are scheduled to demo May 12th and the 16th of 2025. Opportunities such as: The ability to tag grant-reimbursable transactions, to segment our award cost center into two important categories. The full cost to manage a specific program. Identified cost claimed on the SEFA. Dedicated grant modules that will allow us to establish business rules and workflows to streamline and digitize critical aspects of grant management. Staff Engagement – Cross department coordination meetings occur monthly between the Finance organization and the Grants Management team to continue to foster alignment and collaboration in our grant cycles. A general overview of SEFA, including how to prepare and organize the monthly reconciliations, has already occurred with some of the grants accountants. _________________________________________________________
Finding number: 2023-004 – Material Weakness in Internal Control Over Preparation, Reconciliation, and Retention of the Schedule of Expenditures of Federal Awards (SEFA) Federal Program #1 HIV Emergency Relief Project Grants: CFDA Number: 93.914 Federal Program #2 HIV Care Formula Grants): CFDA Number: 93.917 Federal Program #3: HIV Prevention Activities: CFDA Number: 93.941 Name of federal agency: U.S. Department of Health and Human Services (HHS) Name of pass-through entity: Multiple Repeat finding: No AIDS Arms, Inc. dba Prism Health North Texas and Subsidiary Schedule of Findings and Questioned Costs For the Year Ended December 31, 2023 SECTION III - SUMMARY OF FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (continued) Criteria: Under 2 CFR §200.510(b), recipients of federal funds are required to prepare a Schedule of Expenditures of Federal Awards (SEFA) that fairly presents federal expenditures for each grant program and is derived from and supported by the entity's accounting records. Additionally, 2 CFR §200.302 requires that financial management systems adequately identify and account for federal awards to ensure accuracy and compliance with applicable federal requirements. Best practices dictate that federal expenditures should be reconciled regularly to the general ledger, and supporting documentation should be maintained to substantiate amounts reported on the SEFA. Condition: The Organization lacked adequate controls over the preparation, reconciliation, and retention of records related to the SEFA. Specifically: The SEFA incorrectly reported certain federal awards as non-federal awards. The SEFA is prepared based on amounts requested for reimbursement instead of directly based on expenditures incurred. Reconciliation schedules that tied SEFA expenditures directly back to the expenses recorded in the general ledger could not be located. Expenses recorded in the general ledger represent expenses incurred to operate the program in addition to direct grant expenditures; the Organization only requests reimbursement for direct program expenditures allowable under the program. Documentation of Excel-based reconciliations did not agree to reported monthly expenditures, indicating manual reclassification entries between program codes that were not clearly supported. Cause: The deficiencies noted were primarily due to: Lack of system controls to ensure that state and federal expenditures were separately tracked from non-grant funds spent within the same source codes. Turnover in grants management personnel, which resulted in missing, incomplete, or inaccurate reconciling records. Possible effect: Without a complete and accurate SEFA, the Organization risks noncompliance with Uniform Guidance reporting requirements, which could impact its ability to receive and administer federal funds in the future. Additionally, inaccurate SEFA reporting increases the risk of errors in administering funds, questioned costs, and over or under expenditure of grants. Questioned cost: None identified at this time. AIDS Arms, Inc. dba Prism Health North Texas and Subsidiary Schedule of Findings and Questioned Costs For the Year Ended December 31, 2023 SECTION III - SUMMARY OF FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (continued) Recommendation: We recommend that the Organization implement the following measures to improve SEFA preparation and record retention: 1. Develop a Standardized SEFA Reconciliation Process – Implement formal policies and procedures requiring that SEFA expenditures be reconciled to the general ledger on a monthly basis, with documentation maintained for audit purposes. 2. Enhance System Controls for Grant Expenditures – Modify the financial system to allow for the proper segregation of state and federal expenditures from non-grant funds, ensuring that expenditures are properly classified at the time of entry. 3. Require Monthly Documentation Reviews – Establish a control requiring management to review and approve SEFA reconciliation schedules on a monthly or quarterly basis to ensure accuracy and completeness. 4. Implement a Centralized Documentation Retention Policy – Require that all SEFA-related reconciliation records, including general ledger tie-outs and manual adjustments, be retained in a centralized, accessible location. 5. Provide Grants Management Training – Conduct training for grants management and accounting personnel on SEFA preparation requirements, including Uniform Guidance compliance and best practices for documentation and reconciliation. 6. By implementing these measures, the Organization can improve its internal controls over SEFA preparation, ensure compliance with Uniform Guidance, and reduce the risk of reporting inaccuracies. AIDS Arms, Inc. dba Prism Health North Texas and Subsidiary Schedule of Findings and Questioned Costs For the Year Ended December 31, 2023 SECTION III - SUMMARY OF FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (continued) Views of responsible officials: Management partially agrees with the finding. While we acknowledge that documentation supporting SEFA reconciliation was incomplete, we believe that federal expenditures were properly accounted for. We would like to address some of the auditors' points individually: "The SEFA is prepared based on amounts requested for reimbursement instead of directly based on expenditures incurred." Most grant awards do not fully fund the programs they support, most grant awards do not run concurrently with Prism Health North Texas' fiscal year (i.e., with the Calendar Year), and most grant awards are not spent in equal monthly amounts. It is correct that the 2023 SEFA was based on grant-appropriate expenditures that occurred during Calendar Year 2023 and were submitted to those grant sponsors for reimbursement. This will not necessarily reach the full cost to Prism for each grant-supported program, nor is it likely to exactly match any annual grant award amount. "Expenses recorded in the general ledger represent expenses incurred to operate the program in addition to direct grant expenditures; the Organization only requests reimbursement for direct program expenditures allowable under the program." As we confirmed verbally with the audit partner on April 25, 2025, this statement is intended to provide information and context and is not a criticism or intended to point out any problem. As stated above, most grant awards do not fully fund the programs they support; therefore, the general ledger necessarily includes both expenses the sponsor will reimburse and expenses the sponsor will not reimburse. Nonetheless, we are enhancing our reconciliation procedures and documentation practices to fully meet audit requirements. Finding 2023-004 refers to the auditors' assessment of the SEFA preparation and reconciliation processes that occurred in Calendar Year 2023. As of this writing, Prism Health North Texas has already changed its SEFA preparation and reconciliation processes and meets many of the recommendations above. Action Taken: Documentation Retention – On April 25, 2025, management created a structured and easily accessible system for storing all relevant information for all grants management personnel. A logical naming system for files identifying the SEFA period, the funding agency and identified general ledger expenditures claimed on the SEFA. We are now documenting the difference between all GL transactions and those submitted for sponsor reimbursement (i.e., SEFA components) in a single document per fund code, arranged by fiscal year. Previously this documentation was kept by invoice and arranged by grant year. Management will continue to ensure all expenditure-related support, such as invoices and purchase orders, is saved electronically to all AIDS Arms, Inc. dba Prism Health North Texas and Subsidiary Schedule of Findings and Questioned Costs For the Year Ended December 31, 2023 SECTION III - SUMMARY OF FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (continued) financial transactions. SEFA Reconciliation – Management has decided to move from an annual to quarterly SEFA reconciliation process to enhance the frequency of management oversight in SEFA draft preparation. VP of Finance will prepare the SEFA for independent review by the CFO. This will be put into a written policy/procedure. System Enhancements – Prism's current accounting system does not accommodate this. However, Prism is already in the later stages of selecting a new Enterprise Resource Planning (ERP) solution, with this as one of our key selection criteria. Our new ERP should allow for expenditures within the same cost center to be identified as grant-reimbursable or non-grant-reimbursable at the time of entry. We have identified opportunities in new financial management software solutions that we are scheduled to demo May 12th and the 16th of 2025. Opportunities such as: The ability to tag grant-reimbursable transactions, to segment our award cost center into two important categories. The full cost to manage a specific program. Identified cost claimed on the SEFA. Dedicated grant modules that will allow us to establish business rules and workflows to streamline and digitize critical aspects of grant management. Staff Engagement – Cross department coordination meetings occur monthly between the Finance organization and the Grants Management team to continue to foster alignment and collaboration in our grant cycles. A general overview of SEFA, including how to prepare and organize the monthly reconciliations, has already occurred with some of the grants accountants. _________________________________________________________
2 CFR Subpart F § 200.510(b) requires the auditee prepare a Schedule of Expenditures of Federal Awards (the Schedule) for the period covered by the Village’s financial statements which must include the total federal awards expended as determined in accordance with § 200.502. The Village was not aware federal monies were expended and therefore did not complete a Schedule of Expenditures of Federal Awards or Notes to the Schedule of Expenditures of Federal Awards. As a result, the Village did not properly notify the Auditor of State's office of the Village's Single Audit status for 2023. After several discussions with Village personnel, the Schedule of Expenditures of Federal Awards and Notes to the Schedule of Expenditures of Federal awards were completed.
Finding 2023-001 – ReportingInformation of the federal program:Federal Grantor: Department of Defense (DOD)Assistance Listing No.: 12.420, Military Medical Research and DevelopmentPass-Through Grantor: Johns Hopkins UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.172, Human Genome ResearchPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.226, Research on Healthcare Costs, Quality and OutcomesPass-Through Grantor: The Regents of the University of MichiganFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.242, Mental Health Research GrantsPass-Through Grantor: Rutgers State UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.307, Minority Health and Health Disparities ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.310, Trans-NIH Research SupportPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.350, National Center for Advancing Translational SciencesPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.351, Research Infrastructure ProgramPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.361, Nursing ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.368, 21st Century Cures Act – Precision Medicine InitiativePass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.394, Cancer Detection and Diagnosis ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.395, Cancer Treatment ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.396, Cancer Biology ResearchPass-Through Grantor: Tulane University, Louisiana State UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.397, Cancer Centers Support GrantsPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.667, Social Services Block GrantPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.837, Cardiovascular Diseases ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.838, Lung Diseases ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.847, Diabetes, Digestive, and Kidney Diseases Extramural ResearchPass-Through Grantors: Northwestern University, Duke University, University of Washington, The Regents of University of MichiganFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.853, Extramural Research Programs in the Neurosciences and Neurological DisordersPass-Through Grantor: Rush University Medical CenterFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.855, Allergy, Immunology and Transplantation ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.859, Biomedical Research and Research TrainingPass-Through Grantor: University of Wisconsin – MadisonFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.865, Child Health and Human Development Extramural ResearchPass-Through Grantors: Northwestern University, University of Washington, The Regents of the University of CaliforniaFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.866, Aging ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.946, Cooperative Agreements to Support State-Based Safe Motherhood and Infant Health Initiative ProgramsPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.994, Maternal and Child Health Services Block Grant to the StatesPass-Through Grantor: Northwestern Memorial HospitalCriteria or specific requirement (including statutory, regulatory, or other citation):Section 200.303 of the Uniform Guidance states the following regarding internal control: “The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).”The Uniform Guidance 2 CFR section 200.510 states, “(b) Schedule of expenditures of Federal awards. The auditee must also prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended.”Condition:Certain grants related to the Research and Development Cluster were misstated by $233,405 on the preliminary schedule of expenditures of federal awards (the Schedule) provided by management due to the inappropriate classification of costs within the general ledger; the final Schedule was corrected.In addition, an award which was not a federal grant award with expenditures of $148,388 was included on the preliminary Schedule provided by management. The final Schedule was corrected.Cause:Endeavor’s internal controls in place over the preparation of the Schedule were not sufficient to properly accumulate and accurately report all expenditures of federal awards.Effect or Potential Effect:Inaccurate or improper reporting of expenditures results in a misstated Schedule and can also potentially result in insufficient testing of the major programs or improper identification of major programs for audit purposes.Questioned costs:None.Context:The table below reflects the preliminary and adjusted assistance listing balances on the Schedule (only assistance listing programs which changed are included below):Identification as a repeat finding, if applicable:The finding is not a repeat finding from the prior year.Recommendation:Management should implement internal controls to ensure amounts are appropriately accumulated and reported on the Schedule and all federal expenditures are appropriately identified and reported on the Schedule.Views of responsible officials:Award amounts were changed on the Schedule after management’s review was executed. Management acknowledges that implementing the new Enterprise Resource Planning (ERP) system, in 2023 presented changes to the SEFA reporting. Management has identified and addressed the reporting issues within the new system to ensure that the grant totals are appropriately captured in the SEFA.Endeavor will enhance grant management award processes by revising its procedures and adding additional controls to monitor for accuracy of the core data. Management will reinforce the importance of timeliness and accuracy of the Schedule reporting totals to facilitate accurate reporting.
Finding 2023-001 – ReportingInformation of the federal program:Federal Grantor: Department of Defense (DOD)Assistance Listing No.: 12.420, Military Medical Research and DevelopmentPass-Through Grantor: Johns Hopkins UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.172, Human Genome ResearchPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.226, Research on Healthcare Costs, Quality and OutcomesPass-Through Grantor: The Regents of the University of MichiganFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.242, Mental Health Research GrantsPass-Through Grantor: Rutgers State UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.307, Minority Health and Health Disparities ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.310, Trans-NIH Research SupportPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.350, National Center for Advancing Translational SciencesPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.351, Research Infrastructure ProgramPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.361, Nursing ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.368, 21st Century Cures Act – Precision Medicine InitiativePass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.394, Cancer Detection and Diagnosis ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.395, Cancer Treatment ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.396, Cancer Biology ResearchPass-Through Grantor: Tulane University, Louisiana State UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.397, Cancer Centers Support GrantsPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.667, Social Services Block GrantPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.837, Cardiovascular Diseases ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.838, Lung Diseases ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.847, Diabetes, Digestive, and Kidney Diseases Extramural ResearchPass-Through Grantors: Northwestern University, Duke University, University of Washington, The Regents of University of MichiganFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.853, Extramural Research Programs in the Neurosciences and Neurological DisordersPass-Through Grantor: Rush University Medical CenterFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.855, Allergy, Immunology and Transplantation ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.859, Biomedical Research and Research TrainingPass-Through Grantor: University of Wisconsin – MadisonFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.865, Child Health and Human Development Extramural ResearchPass-Through Grantors: Northwestern University, University of Washington, The Regents of the University of CaliforniaFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.866, Aging ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.946, Cooperative Agreements to Support State-Based Safe Motherhood and Infant Health Initiative ProgramsPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.994, Maternal and Child Health Services Block Grant to the StatesPass-Through Grantor: Northwestern Memorial HospitalCriteria or specific requirement (including statutory, regulatory, or other citation):Section 200.303 of the Uniform Guidance states the following regarding internal control: “The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).”The Uniform Guidance 2 CFR section 200.510 states, “(b) Schedule of expenditures of Federal awards. The auditee must also prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended.”Condition:Certain grants related to the Research and Development Cluster were misstated by $233,405 on the preliminary schedule of expenditures of federal awards (the Schedule) provided by management due to the inappropriate classification of costs within the general ledger; the final Schedule was corrected.In addition, an award which was not a federal grant award with expenditures of $148,388 was included on the preliminary Schedule provided by management. The final Schedule was corrected.Cause:Endeavor’s internal controls in place over the preparation of the Schedule were not sufficient to properly accumulate and accurately report all expenditures of federal awards.Effect or Potential Effect:Inaccurate or improper reporting of expenditures results in a misstated Schedule and can also potentially result in insufficient testing of the major programs or improper identification of major programs for audit purposes.Questioned costs:None.Context:The table below reflects the preliminary and adjusted assistance listing balances on the Schedule (only assistance listing programs which changed are included below):Identification as a repeat finding, if applicable:The finding is not a repeat finding from the prior year.Recommendation:Management should implement internal controls to ensure amounts are appropriately accumulated and reported on the Schedule and all federal expenditures are appropriately identified and reported on the Schedule.Views of responsible officials:Award amounts were changed on the Schedule after management’s review was executed. Management acknowledges that implementing the new Enterprise Resource Planning (ERP) system, in 2023 presented changes to the SEFA reporting. Management has identified and addressed the reporting issues within the new system to ensure that the grant totals are appropriately captured in the SEFA.Endeavor will enhance grant management award processes by revising its procedures and adding additional controls to monitor for accuracy of the core data. Management will reinforce the importance of timeliness and accuracy of the Schedule reporting totals to facilitate accurate reporting.
Finding 2023-001 – ReportingInformation of the federal program:Federal Grantor: Department of Defense (DOD)Assistance Listing No.: 12.420, Military Medical Research and DevelopmentPass-Through Grantor: Johns Hopkins UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.172, Human Genome ResearchPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.226, Research on Healthcare Costs, Quality and OutcomesPass-Through Grantor: The Regents of the University of MichiganFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.242, Mental Health Research GrantsPass-Through Grantor: Rutgers State UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.307, Minority Health and Health Disparities ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.310, Trans-NIH Research SupportPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.350, National Center for Advancing Translational SciencesPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.351, Research Infrastructure ProgramPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.361, Nursing ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.368, 21st Century Cures Act – Precision Medicine InitiativePass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.394, Cancer Detection and Diagnosis ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.395, Cancer Treatment ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.396, Cancer Biology ResearchPass-Through Grantor: Tulane University, Louisiana State UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.397, Cancer Centers Support GrantsPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.667, Social Services Block GrantPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.837, Cardiovascular Diseases ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.838, Lung Diseases ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.847, Diabetes, Digestive, and Kidney Diseases Extramural ResearchPass-Through Grantors: Northwestern University, Duke University, University of Washington, The Regents of University of MichiganFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.853, Extramural Research Programs in the Neurosciences and Neurological DisordersPass-Through Grantor: Rush University Medical CenterFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.855, Allergy, Immunology and Transplantation ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.859, Biomedical Research and Research TrainingPass-Through Grantor: University of Wisconsin – MadisonFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.865, Child Health and Human Development Extramural ResearchPass-Through Grantors: Northwestern University, University of Washington, The Regents of the University of CaliforniaFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.866, Aging ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.946, Cooperative Agreements to Support State-Based Safe Motherhood and Infant Health Initiative ProgramsPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.994, Maternal and Child Health Services Block Grant to the StatesPass-Through Grantor: Northwestern Memorial HospitalCriteria or specific requirement (including statutory, regulatory, or other citation):Section 200.303 of the Uniform Guidance states the following regarding internal control: “The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).”The Uniform Guidance 2 CFR section 200.510 states, “(b) Schedule of expenditures of Federal awards. The auditee must also prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended.”Condition:Certain grants related to the Research and Development Cluster were misstated by $233,405 on the preliminary schedule of expenditures of federal awards (the Schedule) provided by management due to the inappropriate classification of costs within the general ledger; the final Schedule was corrected.In addition, an award which was not a federal grant award with expenditures of $148,388 was included on the preliminary Schedule provided by management. The final Schedule was corrected.Cause:Endeavor’s internal controls in place over the preparation of the Schedule were not sufficient to properly accumulate and accurately report all expenditures of federal awards.Effect or Potential Effect:Inaccurate or improper reporting of expenditures results in a misstated Schedule and can also potentially result in insufficient testing of the major programs or improper identification of major programs for audit purposes.Questioned costs:None.Context:The table below reflects the preliminary and adjusted assistance listing balances on the Schedule (only assistance listing programs which changed are included below):Identification as a repeat finding, if applicable:The finding is not a repeat finding from the prior year.Recommendation:Management should implement internal controls to ensure amounts are appropriately accumulated and reported on the Schedule and all federal expenditures are appropriately identified and reported on the Schedule.Views of responsible officials:Award amounts were changed on the Schedule after management’s review was executed. Management acknowledges that implementing the new Enterprise Resource Planning (ERP) system, in 2023 presented changes to the SEFA reporting. Management has identified and addressed the reporting issues within the new system to ensure that the grant totals are appropriately captured in the SEFA.Endeavor will enhance grant management award processes by revising its procedures and adding additional controls to monitor for accuracy of the core data. Management will reinforce the importance of timeliness and accuracy of the Schedule reporting totals to facilitate accurate reporting.
Finding 2023-001 – ReportingInformation of the federal program:Federal Grantor: Department of Defense (DOD)Assistance Listing No.: 12.420, Military Medical Research and DevelopmentPass-Through Grantor: Johns Hopkins UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.172, Human Genome ResearchPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.226, Research on Healthcare Costs, Quality and OutcomesPass-Through Grantor: The Regents of the University of MichiganFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.242, Mental Health Research GrantsPass-Through Grantor: Rutgers State UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.307, Minority Health and Health Disparities ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.310, Trans-NIH Research SupportPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.350, National Center for Advancing Translational SciencesPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.351, Research Infrastructure ProgramPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.361, Nursing ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.368, 21st Century Cures Act – Precision Medicine InitiativePass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.394, Cancer Detection and Diagnosis ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.395, Cancer Treatment ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.396, Cancer Biology ResearchPass-Through Grantor: Tulane University, Louisiana State UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.397, Cancer Centers Support GrantsPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.667, Social Services Block GrantPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.837, Cardiovascular Diseases ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.838, Lung Diseases ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.847, Diabetes, Digestive, and Kidney Diseases Extramural ResearchPass-Through Grantors: Northwestern University, Duke University, University of Washington, The Regents of University of MichiganFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.853, Extramural Research Programs in the Neurosciences and Neurological DisordersPass-Through Grantor: Rush University Medical CenterFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.855, Allergy, Immunology and Transplantation ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.859, Biomedical Research and Research TrainingPass-Through Grantor: University of Wisconsin – MadisonFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.865, Child Health and Human Development Extramural ResearchPass-Through Grantors: Northwestern University, University of Washington, The Regents of the University of CaliforniaFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.866, Aging ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.946, Cooperative Agreements to Support State-Based Safe Motherhood and Infant Health Initiative ProgramsPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.994, Maternal and Child Health Services Block Grant to the StatesPass-Through Grantor: Northwestern Memorial HospitalCriteria or specific requirement (including statutory, regulatory, or other citation):Section 200.303 of the Uniform Guidance states the following regarding internal control: “The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).”The Uniform Guidance 2 CFR section 200.510 states, “(b) Schedule of expenditures of Federal awards. The auditee must also prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended.”Condition:Certain grants related to the Research and Development Cluster were misstated by $233,405 on the preliminary schedule of expenditures of federal awards (the Schedule) provided by management due to the inappropriate classification of costs within the general ledger; the final Schedule was corrected.In addition, an award which was not a federal grant award with expenditures of $148,388 was included on the preliminary Schedule provided by management. The final Schedule was corrected.Cause:Endeavor’s internal controls in place over the preparation of the Schedule were not sufficient to properly accumulate and accurately report all expenditures of federal awards.Effect or Potential Effect:Inaccurate or improper reporting of expenditures results in a misstated Schedule and can also potentially result in insufficient testing of the major programs or improper identification of major programs for audit purposes.Questioned costs:None.Context:The table below reflects the preliminary and adjusted assistance listing balances on the Schedule (only assistance listing programs which changed are included below):Identification as a repeat finding, if applicable:The finding is not a repeat finding from the prior year.Recommendation:Management should implement internal controls to ensure amounts are appropriately accumulated and reported on the Schedule and all federal expenditures are appropriately identified and reported on the Schedule.Views of responsible officials:Award amounts were changed on the Schedule after management’s review was executed. Management acknowledges that implementing the new Enterprise Resource Planning (ERP) system, in 2023 presented changes to the SEFA reporting. Management has identified and addressed the reporting issues within the new system to ensure that the grant totals are appropriately captured in the SEFA.Endeavor will enhance grant management award processes by revising its procedures and adding additional controls to monitor for accuracy of the core data. Management will reinforce the importance of timeliness and accuracy of the Schedule reporting totals to facilitate accurate reporting.
Finding 2023-001 – ReportingInformation of the federal program:Federal Grantor: Department of Defense (DOD)Assistance Listing No.: 12.420, Military Medical Research and DevelopmentPass-Through Grantor: Johns Hopkins UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.172, Human Genome ResearchPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.226, Research on Healthcare Costs, Quality and OutcomesPass-Through Grantor: The Regents of the University of MichiganFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.242, Mental Health Research GrantsPass-Through Grantor: Rutgers State UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.307, Minority Health and Health Disparities ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.310, Trans-NIH Research SupportPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.350, National Center for Advancing Translational SciencesPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.351, Research Infrastructure ProgramPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.361, Nursing ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.368, 21st Century Cures Act – Precision Medicine InitiativePass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.394, Cancer Detection and Diagnosis ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.395, Cancer Treatment ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.396, Cancer Biology ResearchPass-Through Grantor: Tulane University, Louisiana State UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.397, Cancer Centers Support GrantsPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.667, Social Services Block GrantPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.837, Cardiovascular Diseases ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.838, Lung Diseases ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.847, Diabetes, Digestive, and Kidney Diseases Extramural ResearchPass-Through Grantors: Northwestern University, Duke University, University of Washington, The Regents of University of MichiganFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.853, Extramural Research Programs in the Neurosciences and Neurological DisordersPass-Through Grantor: Rush University Medical CenterFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.855, Allergy, Immunology and Transplantation ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.859, Biomedical Research and Research TrainingPass-Through Grantor: University of Wisconsin – MadisonFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.865, Child Health and Human Development Extramural ResearchPass-Through Grantors: Northwestern University, University of Washington, The Regents of the University of CaliforniaFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.866, Aging ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.946, Cooperative Agreements to Support State-Based Safe Motherhood and Infant Health Initiative ProgramsPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.994, Maternal and Child Health Services Block Grant to the StatesPass-Through Grantor: Northwestern Memorial HospitalCriteria or specific requirement (including statutory, regulatory, or other citation):Section 200.303 of the Uniform Guidance states the following regarding internal control: “The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).”The Uniform Guidance 2 CFR section 200.510 states, “(b) Schedule of expenditures of Federal awards. The auditee must also prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended.”Condition:Certain grants related to the Research and Development Cluster were misstated by $233,405 on the preliminary schedule of expenditures of federal awards (the Schedule) provided by management due to the inappropriate classification of costs within the general ledger; the final Schedule was corrected.In addition, an award which was not a federal grant award with expenditures of $148,388 was included on the preliminary Schedule provided by management. The final Schedule was corrected.Cause:Endeavor’s internal controls in place over the preparation of the Schedule were not sufficient to properly accumulate and accurately report all expenditures of federal awards.Effect or Potential Effect:Inaccurate or improper reporting of expenditures results in a misstated Schedule and can also potentially result in insufficient testing of the major programs or improper identification of major programs for audit purposes.Questioned costs:None.Context:The table below reflects the preliminary and adjusted assistance listing balances on the Schedule (only assistance listing programs which changed are included below):Identification as a repeat finding, if applicable:The finding is not a repeat finding from the prior year.Recommendation:Management should implement internal controls to ensure amounts are appropriately accumulated and reported on the Schedule and all federal expenditures are appropriately identified and reported on the Schedule.Views of responsible officials:Award amounts were changed on the Schedule after management’s review was executed. Management acknowledges that implementing the new Enterprise Resource Planning (ERP) system, in 2023 presented changes to the SEFA reporting. Management has identified and addressed the reporting issues within the new system to ensure that the grant totals are appropriately captured in the SEFA.Endeavor will enhance grant management award processes by revising its procedures and adding additional controls to monitor for accuracy of the core data. Management will reinforce the importance of timeliness and accuracy of the Schedule reporting totals to facilitate accurate reporting.
Finding 2023-001 – ReportingInformation of the federal program:Federal Grantor: Department of Defense (DOD)Assistance Listing No.: 12.420, Military Medical Research and DevelopmentPass-Through Grantor: Johns Hopkins UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.172, Human Genome ResearchPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.226, Research on Healthcare Costs, Quality and OutcomesPass-Through Grantor: The Regents of the University of MichiganFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.242, Mental Health Research GrantsPass-Through Grantor: Rutgers State UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.307, Minority Health and Health Disparities ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.310, Trans-NIH Research SupportPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.350, National Center for Advancing Translational SciencesPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.351, Research Infrastructure ProgramPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.361, Nursing ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.368, 21st Century Cures Act – Precision Medicine InitiativePass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.394, Cancer Detection and Diagnosis ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.395, Cancer Treatment ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.396, Cancer Biology ResearchPass-Through Grantor: Tulane University, Louisiana State UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.397, Cancer Centers Support GrantsPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.667, Social Services Block GrantPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.837, Cardiovascular Diseases ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.838, Lung Diseases ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.847, Diabetes, Digestive, and Kidney Diseases Extramural ResearchPass-Through Grantors: Northwestern University, Duke University, University of Washington, The Regents of University of MichiganFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.853, Extramural Research Programs in the Neurosciences and Neurological DisordersPass-Through Grantor: Rush University Medical CenterFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.855, Allergy, Immunology and Transplantation ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.859, Biomedical Research and Research TrainingPass-Through Grantor: University of Wisconsin – MadisonFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.865, Child Health and Human Development Extramural ResearchPass-Through Grantors: Northwestern University, University of Washington, The Regents of the University of CaliforniaFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.866, Aging ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.946, Cooperative Agreements to Support State-Based Safe Motherhood and Infant Health Initiative ProgramsPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.994, Maternal and Child Health Services Block Grant to the StatesPass-Through Grantor: Northwestern Memorial HospitalCriteria or specific requirement (including statutory, regulatory, or other citation):Section 200.303 of the Uniform Guidance states the following regarding internal control: “The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).”The Uniform Guidance 2 CFR section 200.510 states, “(b) Schedule of expenditures of Federal awards. The auditee must also prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended.”Condition:Certain grants related to the Research and Development Cluster were misstated by $233,405 on the preliminary schedule of expenditures of federal awards (the Schedule) provided by management due to the inappropriate classification of costs within the general ledger; the final Schedule was corrected.In addition, an award which was not a federal grant award with expenditures of $148,388 was included on the preliminary Schedule provided by management. The final Schedule was corrected.Cause:Endeavor’s internal controls in place over the preparation of the Schedule were not sufficient to properly accumulate and accurately report all expenditures of federal awards.Effect or Potential Effect:Inaccurate or improper reporting of expenditures results in a misstated Schedule and can also potentially result in insufficient testing of the major programs or improper identification of major programs for audit purposes.Questioned costs:None.Context:The table below reflects the preliminary and adjusted assistance listing balances on the Schedule (only assistance listing programs which changed are included below):Identification as a repeat finding, if applicable:The finding is not a repeat finding from the prior year.Recommendation:Management should implement internal controls to ensure amounts are appropriately accumulated and reported on the Schedule and all federal expenditures are appropriately identified and reported on the Schedule.Views of responsible officials:Award amounts were changed on the Schedule after management’s review was executed. Management acknowledges that implementing the new Enterprise Resource Planning (ERP) system, in 2023 presented changes to the SEFA reporting. Management has identified and addressed the reporting issues within the new system to ensure that the grant totals are appropriately captured in the SEFA.Endeavor will enhance grant management award processes by revising its procedures and adding additional controls to monitor for accuracy of the core data. Management will reinforce the importance of timeliness and accuracy of the Schedule reporting totals to facilitate accurate reporting.
Finding 2023-001 – ReportingInformation of the federal program:Federal Grantor: Department of Defense (DOD)Assistance Listing No.: 12.420, Military Medical Research and DevelopmentPass-Through Grantor: Johns Hopkins UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.172, Human Genome ResearchPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.226, Research on Healthcare Costs, Quality and OutcomesPass-Through Grantor: The Regents of the University of MichiganFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.242, Mental Health Research GrantsPass-Through Grantor: Rutgers State UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.307, Minority Health and Health Disparities ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.310, Trans-NIH Research SupportPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.350, National Center for Advancing Translational SciencesPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.351, Research Infrastructure ProgramPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.361, Nursing ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.368, 21st Century Cures Act – Precision Medicine InitiativePass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.394, Cancer Detection and Diagnosis ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.395, Cancer Treatment ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.396, Cancer Biology ResearchPass-Through Grantor: Tulane University, Louisiana State UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.397, Cancer Centers Support GrantsPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.667, Social Services Block GrantPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.837, Cardiovascular Diseases ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.838, Lung Diseases ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.847, Diabetes, Digestive, and Kidney Diseases Extramural ResearchPass-Through Grantors: Northwestern University, Duke University, University of Washington, The Regents of University of MichiganFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.853, Extramural Research Programs in the Neurosciences and Neurological DisordersPass-Through Grantor: Rush University Medical CenterFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.855, Allergy, Immunology and Transplantation ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.859, Biomedical Research and Research TrainingPass-Through Grantor: University of Wisconsin – MadisonFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.865, Child Health and Human Development Extramural ResearchPass-Through Grantors: Northwestern University, University of Washington, The Regents of the University of CaliforniaFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.866, Aging ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.946, Cooperative Agreements to Support State-Based Safe Motherhood and Infant Health Initiative ProgramsPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.994, Maternal and Child Health Services Block Grant to the StatesPass-Through Grantor: Northwestern Memorial HospitalCriteria or specific requirement (including statutory, regulatory, or other citation):Section 200.303 of the Uniform Guidance states the following regarding internal control: “The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).”The Uniform Guidance 2 CFR section 200.510 states, “(b) Schedule of expenditures of Federal awards. The auditee must also prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended.”Condition:Certain grants related to the Research and Development Cluster were misstated by $233,405 on the preliminary schedule of expenditures of federal awards (the Schedule) provided by management due to the inappropriate classification of costs within the general ledger; the final Schedule was corrected.In addition, an award which was not a federal grant award with expenditures of $148,388 was included on the preliminary Schedule provided by management. The final Schedule was corrected.Cause:Endeavor’s internal controls in place over the preparation of the Schedule were not sufficient to properly accumulate and accurately report all expenditures of federal awards.Effect or Potential Effect:Inaccurate or improper reporting of expenditures results in a misstated Schedule and can also potentially result in insufficient testing of the major programs or improper identification of major programs for audit purposes.Questioned costs:None.Context:The table below reflects the preliminary and adjusted assistance listing balances on the Schedule (only assistance listing programs which changed are included below):Identification as a repeat finding, if applicable:The finding is not a repeat finding from the prior year.Recommendation:Management should implement internal controls to ensure amounts are appropriately accumulated and reported on the Schedule and all federal expenditures are appropriately identified and reported on the Schedule.Views of responsible officials:Award amounts were changed on the Schedule after management’s review was executed. Management acknowledges that implementing the new Enterprise Resource Planning (ERP) system, in 2023 presented changes to the SEFA reporting. Management has identified and addressed the reporting issues within the new system to ensure that the grant totals are appropriately captured in the SEFA.Endeavor will enhance grant management award processes by revising its procedures and adding additional controls to monitor for accuracy of the core data. Management will reinforce the importance of timeliness and accuracy of the Schedule reporting totals to facilitate accurate reporting.
Finding 2023-001 – ReportingInformation of the federal program:Federal Grantor: Department of Defense (DOD)Assistance Listing No.: 12.420, Military Medical Research and DevelopmentPass-Through Grantor: Johns Hopkins UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.172, Human Genome ResearchPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.226, Research on Healthcare Costs, Quality and OutcomesPass-Through Grantor: The Regents of the University of MichiganFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.242, Mental Health Research GrantsPass-Through Grantor: Rutgers State UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.307, Minority Health and Health Disparities ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.310, Trans-NIH Research SupportPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.350, National Center for Advancing Translational SciencesPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.351, Research Infrastructure ProgramPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.361, Nursing ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.368, 21st Century Cures Act – Precision Medicine InitiativePass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.394, Cancer Detection and Diagnosis ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.395, Cancer Treatment ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.396, Cancer Biology ResearchPass-Through Grantor: Tulane University, Louisiana State UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.397, Cancer Centers Support GrantsPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.667, Social Services Block GrantPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.837, Cardiovascular Diseases ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.838, Lung Diseases ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.847, Diabetes, Digestive, and Kidney Diseases Extramural ResearchPass-Through Grantors: Northwestern University, Duke University, University of Washington, The Regents of University of MichiganFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.853, Extramural Research Programs in the Neurosciences and Neurological DisordersPass-Through Grantor: Rush University Medical CenterFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.855, Allergy, Immunology and Transplantation ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.859, Biomedical Research and Research TrainingPass-Through Grantor: University of Wisconsin – MadisonFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.865, Child Health and Human Development Extramural ResearchPass-Through Grantors: Northwestern University, University of Washington, The Regents of the University of CaliforniaFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.866, Aging ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.946, Cooperative Agreements to Support State-Based Safe Motherhood and Infant Health Initiative ProgramsPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.994, Maternal and Child Health Services Block Grant to the StatesPass-Through Grantor: Northwestern Memorial HospitalCriteria or specific requirement (including statutory, regulatory, or other citation):Section 200.303 of the Uniform Guidance states the following regarding internal control: “The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).”The Uniform Guidance 2 CFR section 200.510 states, “(b) Schedule of expenditures of Federal awards. The auditee must also prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended.”Condition:Certain grants related to the Research and Development Cluster were misstated by $233,405 on the preliminary schedule of expenditures of federal awards (the Schedule) provided by management due to the inappropriate classification of costs within the general ledger; the final Schedule was corrected.In addition, an award which was not a federal grant award with expenditures of $148,388 was included on the preliminary Schedule provided by management. The final Schedule was corrected.Cause:Endeavor’s internal controls in place over the preparation of the Schedule were not sufficient to properly accumulate and accurately report all expenditures of federal awards.Effect or Potential Effect:Inaccurate or improper reporting of expenditures results in a misstated Schedule and can also potentially result in insufficient testing of the major programs or improper identification of major programs for audit purposes.Questioned costs:None.Context:The table below reflects the preliminary and adjusted assistance listing balances on the Schedule (only assistance listing programs which changed are included below):Identification as a repeat finding, if applicable:The finding is not a repeat finding from the prior year.Recommendation:Management should implement internal controls to ensure amounts are appropriately accumulated and reported on the Schedule and all federal expenditures are appropriately identified and reported on the Schedule.Views of responsible officials:Award amounts were changed on the Schedule after management’s review was executed. Management acknowledges that implementing the new Enterprise Resource Planning (ERP) system, in 2023 presented changes to the SEFA reporting. Management has identified and addressed the reporting issues within the new system to ensure that the grant totals are appropriately captured in the SEFA.Endeavor will enhance grant management award processes by revising its procedures and adding additional controls to monitor for accuracy of the core data. Management will reinforce the importance of timeliness and accuracy of the Schedule reporting totals to facilitate accurate reporting.
Finding 2023-001 – ReportingInformation of the federal program:Federal Grantor: Department of Defense (DOD)Assistance Listing No.: 12.420, Military Medical Research and DevelopmentPass-Through Grantor: Johns Hopkins UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.172, Human Genome ResearchPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.226, Research on Healthcare Costs, Quality and OutcomesPass-Through Grantor: The Regents of the University of MichiganFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.242, Mental Health Research GrantsPass-Through Grantor: Rutgers State UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.307, Minority Health and Health Disparities ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.310, Trans-NIH Research SupportPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.350, National Center for Advancing Translational SciencesPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.351, Research Infrastructure ProgramPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.361, Nursing ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.368, 21st Century Cures Act – Precision Medicine InitiativePass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.394, Cancer Detection and Diagnosis ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.395, Cancer Treatment ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.396, Cancer Biology ResearchPass-Through Grantor: Tulane University, Louisiana State UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.397, Cancer Centers Support GrantsPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.667, Social Services Block GrantPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.837, Cardiovascular Diseases ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.838, Lung Diseases ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.847, Diabetes, Digestive, and Kidney Diseases Extramural ResearchPass-Through Grantors: Northwestern University, Duke University, University of Washington, The Regents of University of MichiganFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.853, Extramural Research Programs in the Neurosciences and Neurological DisordersPass-Through Grantor: Rush University Medical CenterFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.855, Allergy, Immunology and Transplantation ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.859, Biomedical Research and Research TrainingPass-Through Grantor: University of Wisconsin – MadisonFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.865, Child Health and Human Development Extramural ResearchPass-Through Grantors: Northwestern University, University of Washington, The Regents of the University of CaliforniaFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.866, Aging ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.946, Cooperative Agreements to Support State-Based Safe Motherhood and Infant Health Initiative ProgramsPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.994, Maternal and Child Health Services Block Grant to the StatesPass-Through Grantor: Northwestern Memorial HospitalCriteria or specific requirement (including statutory, regulatory, or other citation):Section 200.303 of the Uniform Guidance states the following regarding internal control: “The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).”The Uniform Guidance 2 CFR section 200.510 states, “(b) Schedule of expenditures of Federal awards. The auditee must also prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended.”Condition:Certain grants related to the Research and Development Cluster were misstated by $233,405 on the preliminary schedule of expenditures of federal awards (the Schedule) provided by management due to the inappropriate classification of costs within the general ledger; the final Schedule was corrected.In addition, an award which was not a federal grant award with expenditures of $148,388 was included on the preliminary Schedule provided by management. The final Schedule was corrected.Cause:Endeavor’s internal controls in place over the preparation of the Schedule were not sufficient to properly accumulate and accurately report all expenditures of federal awards.Effect or Potential Effect:Inaccurate or improper reporting of expenditures results in a misstated Schedule and can also potentially result in insufficient testing of the major programs or improper identification of major programs for audit purposes.Questioned costs:None.Context:The table below reflects the preliminary and adjusted assistance listing balances on the Schedule (only assistance listing programs which changed are included below):Identification as a repeat finding, if applicable:The finding is not a repeat finding from the prior year.Recommendation:Management should implement internal controls to ensure amounts are appropriately accumulated and reported on the Schedule and all federal expenditures are appropriately identified and reported on the Schedule.Views of responsible officials:Award amounts were changed on the Schedule after management’s review was executed. Management acknowledges that implementing the new Enterprise Resource Planning (ERP) system, in 2023 presented changes to the SEFA reporting. Management has identified and addressed the reporting issues within the new system to ensure that the grant totals are appropriately captured in the SEFA.Endeavor will enhance grant management award processes by revising its procedures and adding additional controls to monitor for accuracy of the core data. Management will reinforce the importance of timeliness and accuracy of the Schedule reporting totals to facilitate accurate reporting.
Finding 2023-001 – ReportingInformation of the federal program:Federal Grantor: Department of Defense (DOD)Assistance Listing No.: 12.420, Military Medical Research and DevelopmentPass-Through Grantor: Johns Hopkins UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.172, Human Genome ResearchPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.226, Research on Healthcare Costs, Quality and OutcomesPass-Through Grantor: The Regents of the University of MichiganFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.242, Mental Health Research GrantsPass-Through Grantor: Rutgers State UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.307, Minority Health and Health Disparities ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.310, Trans-NIH Research SupportPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.350, National Center for Advancing Translational SciencesPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.351, Research Infrastructure ProgramPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.361, Nursing ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.368, 21st Century Cures Act – Precision Medicine InitiativePass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.394, Cancer Detection and Diagnosis ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.395, Cancer Treatment ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.396, Cancer Biology ResearchPass-Through Grantor: Tulane University, Louisiana State UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.397, Cancer Centers Support GrantsPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.667, Social Services Block GrantPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.837, Cardiovascular Diseases ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.838, Lung Diseases ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.847, Diabetes, Digestive, and Kidney Diseases Extramural ResearchPass-Through Grantors: Northwestern University, Duke University, University of Washington, The Regents of University of MichiganFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.853, Extramural Research Programs in the Neurosciences and Neurological DisordersPass-Through Grantor: Rush University Medical CenterFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.855, Allergy, Immunology and Transplantation ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.859, Biomedical Research and Research TrainingPass-Through Grantor: University of Wisconsin – MadisonFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.865, Child Health and Human Development Extramural ResearchPass-Through Grantors: Northwestern University, University of Washington, The Regents of the University of CaliforniaFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.866, Aging ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.946, Cooperative Agreements to Support State-Based Safe Motherhood and Infant Health Initiative ProgramsPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.994, Maternal and Child Health Services Block Grant to the StatesPass-Through Grantor: Northwestern Memorial HospitalCriteria or specific requirement (including statutory, regulatory, or other citation):Section 200.303 of the Uniform Guidance states the following regarding internal control: “The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).”The Uniform Guidance 2 CFR section 200.510 states, “(b) Schedule of expenditures of Federal awards. The auditee must also prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended.”Condition:Certain grants related to the Research and Development Cluster were misstated by $233,405 on the preliminary schedule of expenditures of federal awards (the Schedule) provided by management due to the inappropriate classification of costs within the general ledger; the final Schedule was corrected.In addition, an award which was not a federal grant award with expenditures of $148,388 was included on the preliminary Schedule provided by management. The final Schedule was corrected.Cause:Endeavor’s internal controls in place over the preparation of the Schedule were not sufficient to properly accumulate and accurately report all expenditures of federal awards.Effect or Potential Effect:Inaccurate or improper reporting of expenditures results in a misstated Schedule and can also potentially result in insufficient testing of the major programs or improper identification of major programs for audit purposes.Questioned costs:None.Context:The table below reflects the preliminary and adjusted assistance listing balances on the Schedule (only assistance listing programs which changed are included below):Identification as a repeat finding, if applicable:The finding is not a repeat finding from the prior year.Recommendation:Management should implement internal controls to ensure amounts are appropriately accumulated and reported on the Schedule and all federal expenditures are appropriately identified and reported on the Schedule.Views of responsible officials:Award amounts were changed on the Schedule after management’s review was executed. Management acknowledges that implementing the new Enterprise Resource Planning (ERP) system, in 2023 presented changes to the SEFA reporting. Management has identified and addressed the reporting issues within the new system to ensure that the grant totals are appropriately captured in the SEFA.Endeavor will enhance grant management award processes by revising its procedures and adding additional controls to monitor for accuracy of the core data. Management will reinforce the importance of timeliness and accuracy of the Schedule reporting totals to facilitate accurate reporting.
Finding 2023-001 – ReportingInformation of the federal program:Federal Grantor: Department of Defense (DOD)Assistance Listing No.: 12.420, Military Medical Research and DevelopmentPass-Through Grantor: Johns Hopkins UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.172, Human Genome ResearchPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.226, Research on Healthcare Costs, Quality and OutcomesPass-Through Grantor: The Regents of the University of MichiganFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.242, Mental Health Research GrantsPass-Through Grantor: Rutgers State UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.307, Minority Health and Health Disparities ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.310, Trans-NIH Research SupportPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.350, National Center for Advancing Translational SciencesPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.351, Research Infrastructure ProgramPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.361, Nursing ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.368, 21st Century Cures Act – Precision Medicine InitiativePass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.394, Cancer Detection and Diagnosis ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.395, Cancer Treatment ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.396, Cancer Biology ResearchPass-Through Grantor: Tulane University, Louisiana State UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.397, Cancer Centers Support GrantsPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.667, Social Services Block GrantPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.837, Cardiovascular Diseases ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.838, Lung Diseases ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.847, Diabetes, Digestive, and Kidney Diseases Extramural ResearchPass-Through Grantors: Northwestern University, Duke University, University of Washington, The Regents of University of MichiganFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.853, Extramural Research Programs in the Neurosciences and Neurological DisordersPass-Through Grantor: Rush University Medical CenterFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.855, Allergy, Immunology and Transplantation ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.859, Biomedical Research and Research TrainingPass-Through Grantor: University of Wisconsin – MadisonFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.865, Child Health and Human Development Extramural ResearchPass-Through Grantors: Northwestern University, University of Washington, The Regents of the University of CaliforniaFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.866, Aging ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.946, Cooperative Agreements to Support State-Based Safe Motherhood and Infant Health Initiative ProgramsPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.994, Maternal and Child Health Services Block Grant to the StatesPass-Through Grantor: Northwestern Memorial HospitalCriteria or specific requirement (including statutory, regulatory, or other citation):Section 200.303 of the Uniform Guidance states the following regarding internal control: “The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).”The Uniform Guidance 2 CFR section 200.510 states, “(b) Schedule of expenditures of Federal awards. The auditee must also prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended.”Condition:Certain grants related to the Research and Development Cluster were misstated by $233,405 on the preliminary schedule of expenditures of federal awards (the Schedule) provided by management due to the inappropriate classification of costs within the general ledger; the final Schedule was corrected.In addition, an award which was not a federal grant award with expenditures of $148,388 was included on the preliminary Schedule provided by management. The final Schedule was corrected.Cause:Endeavor’s internal controls in place over the preparation of the Schedule were not sufficient to properly accumulate and accurately report all expenditures of federal awards.Effect or Potential Effect:Inaccurate or improper reporting of expenditures results in a misstated Schedule and can also potentially result in insufficient testing of the major programs or improper identification of major programs for audit purposes.Questioned costs:None.Context:The table below reflects the preliminary and adjusted assistance listing balances on the Schedule (only assistance listing programs which changed are included below):Identification as a repeat finding, if applicable:The finding is not a repeat finding from the prior year.Recommendation:Management should implement internal controls to ensure amounts are appropriately accumulated and reported on the Schedule and all federal expenditures are appropriately identified and reported on the Schedule.Views of responsible officials:Award amounts were changed on the Schedule after management’s review was executed. Management acknowledges that implementing the new Enterprise Resource Planning (ERP) system, in 2023 presented changes to the SEFA reporting. Management has identified and addressed the reporting issues within the new system to ensure that the grant totals are appropriately captured in the SEFA.Endeavor will enhance grant management award processes by revising its procedures and adding additional controls to monitor for accuracy of the core data. Management will reinforce the importance of timeliness and accuracy of the Schedule reporting totals to facilitate accurate reporting.
Finding 2023-001 – ReportingInformation of the federal program:Federal Grantor: Department of Defense (DOD)Assistance Listing No.: 12.420, Military Medical Research and DevelopmentPass-Through Grantor: Johns Hopkins UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.172, Human Genome ResearchPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.226, Research on Healthcare Costs, Quality and OutcomesPass-Through Grantor: The Regents of the University of MichiganFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.242, Mental Health Research GrantsPass-Through Grantor: Rutgers State UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.307, Minority Health and Health Disparities ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.310, Trans-NIH Research SupportPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.350, National Center for Advancing Translational SciencesPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.351, Research Infrastructure ProgramPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.361, Nursing ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.368, 21st Century Cures Act – Precision Medicine InitiativePass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.394, Cancer Detection and Diagnosis ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.395, Cancer Treatment ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.396, Cancer Biology ResearchPass-Through Grantor: Tulane University, Louisiana State UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.397, Cancer Centers Support GrantsPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.667, Social Services Block GrantPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.837, Cardiovascular Diseases ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.838, Lung Diseases ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.847, Diabetes, Digestive, and Kidney Diseases Extramural ResearchPass-Through Grantors: Northwestern University, Duke University, University of Washington, The Regents of University of MichiganFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.853, Extramural Research Programs in the Neurosciences and Neurological DisordersPass-Through Grantor: Rush University Medical CenterFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.855, Allergy, Immunology and Transplantation ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.859, Biomedical Research and Research TrainingPass-Through Grantor: University of Wisconsin – MadisonFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.865, Child Health and Human Development Extramural ResearchPass-Through Grantors: Northwestern University, University of Washington, The Regents of the University of CaliforniaFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.866, Aging ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.946, Cooperative Agreements to Support State-Based Safe Motherhood and Infant Health Initiative ProgramsPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.994, Maternal and Child Health Services Block Grant to the StatesPass-Through Grantor: Northwestern Memorial HospitalCriteria or specific requirement (including statutory, regulatory, or other citation):Section 200.303 of the Uniform Guidance states the following regarding internal control: “The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).”The Uniform Guidance 2 CFR section 200.510 states, “(b) Schedule of expenditures of Federal awards. The auditee must also prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended.”Condition:Certain grants related to the Research and Development Cluster were misstated by $233,405 on the preliminary schedule of expenditures of federal awards (the Schedule) provided by management due to the inappropriate classification of costs within the general ledger; the final Schedule was corrected.In addition, an award which was not a federal grant award with expenditures of $148,388 was included on the preliminary Schedule provided by management. The final Schedule was corrected.Cause:Endeavor’s internal controls in place over the preparation of the Schedule were not sufficient to properly accumulate and accurately report all expenditures of federal awards.Effect or Potential Effect:Inaccurate or improper reporting of expenditures results in a misstated Schedule and can also potentially result in insufficient testing of the major programs or improper identification of major programs for audit purposes.Questioned costs:None.Context:The table below reflects the preliminary and adjusted assistance listing balances on the Schedule (only assistance listing programs which changed are included below):Identification as a repeat finding, if applicable:The finding is not a repeat finding from the prior year.Recommendation:Management should implement internal controls to ensure amounts are appropriately accumulated and reported on the Schedule and all federal expenditures are appropriately identified and reported on the Schedule.Views of responsible officials:Award amounts were changed on the Schedule after management’s review was executed. Management acknowledges that implementing the new Enterprise Resource Planning (ERP) system, in 2023 presented changes to the SEFA reporting. Management has identified and addressed the reporting issues within the new system to ensure that the grant totals are appropriately captured in the SEFA.Endeavor will enhance grant management award processes by revising its procedures and adding additional controls to monitor for accuracy of the core data. Management will reinforce the importance of timeliness and accuracy of the Schedule reporting totals to facilitate accurate reporting.
Finding 2023-001 – ReportingInformation of the federal program:Federal Grantor: Department of Defense (DOD)Assistance Listing No.: 12.420, Military Medical Research and DevelopmentPass-Through Grantor: Johns Hopkins UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.172, Human Genome ResearchPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.226, Research on Healthcare Costs, Quality and OutcomesPass-Through Grantor: The Regents of the University of MichiganFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.242, Mental Health Research GrantsPass-Through Grantor: Rutgers State UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.307, Minority Health and Health Disparities ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.310, Trans-NIH Research SupportPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.350, National Center for Advancing Translational SciencesPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.351, Research Infrastructure ProgramPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.361, Nursing ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.368, 21st Century Cures Act – Precision Medicine InitiativePass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.394, Cancer Detection and Diagnosis ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.395, Cancer Treatment ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.396, Cancer Biology ResearchPass-Through Grantor: Tulane University, Louisiana State UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.397, Cancer Centers Support GrantsPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.667, Social Services Block GrantPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.837, Cardiovascular Diseases ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.838, Lung Diseases ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.847, Diabetes, Digestive, and Kidney Diseases Extramural ResearchPass-Through Grantors: Northwestern University, Duke University, University of Washington, The Regents of University of MichiganFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.853, Extramural Research Programs in the Neurosciences and Neurological DisordersPass-Through Grantor: Rush University Medical CenterFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.855, Allergy, Immunology and Transplantation ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.859, Biomedical Research and Research TrainingPass-Through Grantor: University of Wisconsin – MadisonFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.865, Child Health and Human Development Extramural ResearchPass-Through Grantors: Northwestern University, University of Washington, The Regents of the University of CaliforniaFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.866, Aging ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.946, Cooperative Agreements to Support State-Based Safe Motherhood and Infant Health Initiative ProgramsPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.994, Maternal and Child Health Services Block Grant to the StatesPass-Through Grantor: Northwestern Memorial HospitalCriteria or specific requirement (including statutory, regulatory, or other citation):Section 200.303 of the Uniform Guidance states the following regarding internal control: “The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).”The Uniform Guidance 2 CFR section 200.510 states, “(b) Schedule of expenditures of Federal awards. The auditee must also prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended.”Condition:Certain grants related to the Research and Development Cluster were misstated by $233,405 on the preliminary schedule of expenditures of federal awards (the Schedule) provided by management due to the inappropriate classification of costs within the general ledger; the final Schedule was corrected.In addition, an award which was not a federal grant award with expenditures of $148,388 was included on the preliminary Schedule provided by management. The final Schedule was corrected.Cause:Endeavor’s internal controls in place over the preparation of the Schedule were not sufficient to properly accumulate and accurately report all expenditures of federal awards.Effect or Potential Effect:Inaccurate or improper reporting of expenditures results in a misstated Schedule and can also potentially result in insufficient testing of the major programs or improper identification of major programs for audit purposes.Questioned costs:None.Context:The table below reflects the preliminary and adjusted assistance listing balances on the Schedule (only assistance listing programs which changed are included below):Identification as a repeat finding, if applicable:The finding is not a repeat finding from the prior year.Recommendation:Management should implement internal controls to ensure amounts are appropriately accumulated and reported on the Schedule and all federal expenditures are appropriately identified and reported on the Schedule.Views of responsible officials:Award amounts were changed on the Schedule after management’s review was executed. Management acknowledges that implementing the new Enterprise Resource Planning (ERP) system, in 2023 presented changes to the SEFA reporting. Management has identified and addressed the reporting issues within the new system to ensure that the grant totals are appropriately captured in the SEFA.Endeavor will enhance grant management award processes by revising its procedures and adding additional controls to monitor for accuracy of the core data. Management will reinforce the importance of timeliness and accuracy of the Schedule reporting totals to facilitate accurate reporting.
Finding 2023-001 – ReportingInformation of the federal program:Federal Grantor: Department of Defense (DOD)Assistance Listing No.: 12.420, Military Medical Research and DevelopmentPass-Through Grantor: Johns Hopkins UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.172, Human Genome ResearchPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.226, Research on Healthcare Costs, Quality and OutcomesPass-Through Grantor: The Regents of the University of MichiganFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.242, Mental Health Research GrantsPass-Through Grantor: Rutgers State UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.307, Minority Health and Health Disparities ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.310, Trans-NIH Research SupportPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.350, National Center for Advancing Translational SciencesPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.351, Research Infrastructure ProgramPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.361, Nursing ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.368, 21st Century Cures Act – Precision Medicine InitiativePass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.394, Cancer Detection and Diagnosis ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.395, Cancer Treatment ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.396, Cancer Biology ResearchPass-Through Grantor: Tulane University, Louisiana State UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.397, Cancer Centers Support GrantsPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.667, Social Services Block GrantPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.837, Cardiovascular Diseases ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.838, Lung Diseases ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.847, Diabetes, Digestive, and Kidney Diseases Extramural ResearchPass-Through Grantors: Northwestern University, Duke University, University of Washington, The Regents of University of MichiganFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.853, Extramural Research Programs in the Neurosciences and Neurological DisordersPass-Through Grantor: Rush University Medical CenterFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.855, Allergy, Immunology and Transplantation ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.859, Biomedical Research and Research TrainingPass-Through Grantor: University of Wisconsin – MadisonFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.865, Child Health and Human Development Extramural ResearchPass-Through Grantors: Northwestern University, University of Washington, The Regents of the University of CaliforniaFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.866, Aging ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.946, Cooperative Agreements to Support State-Based Safe Motherhood and Infant Health Initiative ProgramsPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.994, Maternal and Child Health Services Block Grant to the StatesPass-Through Grantor: Northwestern Memorial HospitalCriteria or specific requirement (including statutory, regulatory, or other citation):Section 200.303 of the Uniform Guidance states the following regarding internal control: “The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).”The Uniform Guidance 2 CFR section 200.510 states, “(b) Schedule of expenditures of Federal awards. The auditee must also prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended.”Condition:Certain grants related to the Research and Development Cluster were misstated by $233,405 on the preliminary schedule of expenditures of federal awards (the Schedule) provided by management due to the inappropriate classification of costs within the general ledger; the final Schedule was corrected.In addition, an award which was not a federal grant award with expenditures of $148,388 was included on the preliminary Schedule provided by management. The final Schedule was corrected.Cause:Endeavor’s internal controls in place over the preparation of the Schedule were not sufficient to properly accumulate and accurately report all expenditures of federal awards.Effect or Potential Effect:Inaccurate or improper reporting of expenditures results in a misstated Schedule and can also potentially result in insufficient testing of the major programs or improper identification of major programs for audit purposes.Questioned costs:None.Context:The table below reflects the preliminary and adjusted assistance listing balances on the Schedule (only assistance listing programs which changed are included below):Identification as a repeat finding, if applicable:The finding is not a repeat finding from the prior year.Recommendation:Management should implement internal controls to ensure amounts are appropriately accumulated and reported on the Schedule and all federal expenditures are appropriately identified and reported on the Schedule.Views of responsible officials:Award amounts were changed on the Schedule after management’s review was executed. Management acknowledges that implementing the new Enterprise Resource Planning (ERP) system, in 2023 presented changes to the SEFA reporting. Management has identified and addressed the reporting issues within the new system to ensure that the grant totals are appropriately captured in the SEFA.Endeavor will enhance grant management award processes by revising its procedures and adding additional controls to monitor for accuracy of the core data. Management will reinforce the importance of timeliness and accuracy of the Schedule reporting totals to facilitate accurate reporting.
Finding 2023-001 – ReportingInformation of the federal program:Federal Grantor: Department of Defense (DOD)Assistance Listing No.: 12.420, Military Medical Research and DevelopmentPass-Through Grantor: Johns Hopkins UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.172, Human Genome ResearchPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.226, Research on Healthcare Costs, Quality and OutcomesPass-Through Grantor: The Regents of the University of MichiganFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.242, Mental Health Research GrantsPass-Through Grantor: Rutgers State UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.307, Minority Health and Health Disparities ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.310, Trans-NIH Research SupportPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.350, National Center for Advancing Translational SciencesPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.351, Research Infrastructure ProgramPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.361, Nursing ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.368, 21st Century Cures Act – Precision Medicine InitiativePass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.394, Cancer Detection and Diagnosis ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.395, Cancer Treatment ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.396, Cancer Biology ResearchPass-Through Grantor: Tulane University, Louisiana State UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.397, Cancer Centers Support GrantsPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.667, Social Services Block GrantPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.837, Cardiovascular Diseases ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.838, Lung Diseases ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.847, Diabetes, Digestive, and Kidney Diseases Extramural ResearchPass-Through Grantors: Northwestern University, Duke University, University of Washington, The Regents of University of MichiganFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.853, Extramural Research Programs in the Neurosciences and Neurological DisordersPass-Through Grantor: Rush University Medical CenterFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.855, Allergy, Immunology and Transplantation ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.859, Biomedical Research and Research TrainingPass-Through Grantor: University of Wisconsin – MadisonFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.865, Child Health and Human Development Extramural ResearchPass-Through Grantors: Northwestern University, University of Washington, The Regents of the University of CaliforniaFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.866, Aging ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.946, Cooperative Agreements to Support State-Based Safe Motherhood and Infant Health Initiative ProgramsPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.994, Maternal and Child Health Services Block Grant to the StatesPass-Through Grantor: Northwestern Memorial HospitalCriteria or specific requirement (including statutory, regulatory, or other citation):Section 200.303 of the Uniform Guidance states the following regarding internal control: “The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).”The Uniform Guidance 2 CFR section 200.510 states, “(b) Schedule of expenditures of Federal awards. The auditee must also prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended.”Condition:Certain grants related to the Research and Development Cluster were misstated by $233,405 on the preliminary schedule of expenditures of federal awards (the Schedule) provided by management due to the inappropriate classification of costs within the general ledger; the final Schedule was corrected.In addition, an award which was not a federal grant award with expenditures of $148,388 was included on the preliminary Schedule provided by management. The final Schedule was corrected.Cause:Endeavor’s internal controls in place over the preparation of the Schedule were not sufficient to properly accumulate and accurately report all expenditures of federal awards.Effect or Potential Effect:Inaccurate or improper reporting of expenditures results in a misstated Schedule and can also potentially result in insufficient testing of the major programs or improper identification of major programs for audit purposes.Questioned costs:None.Context:The table below reflects the preliminary and adjusted assistance listing balances on the Schedule (only assistance listing programs which changed are included below):Identification as a repeat finding, if applicable:The finding is not a repeat finding from the prior year.Recommendation:Management should implement internal controls to ensure amounts are appropriately accumulated and reported on the Schedule and all federal expenditures are appropriately identified and reported on the Schedule.Views of responsible officials:Award amounts were changed on the Schedule after management’s review was executed. Management acknowledges that implementing the new Enterprise Resource Planning (ERP) system, in 2023 presented changes to the SEFA reporting. Management has identified and addressed the reporting issues within the new system to ensure that the grant totals are appropriately captured in the SEFA.Endeavor will enhance grant management award processes by revising its procedures and adding additional controls to monitor for accuracy of the core data. Management will reinforce the importance of timeliness and accuracy of the Schedule reporting totals to facilitate accurate reporting.
Finding 2023-001 – ReportingInformation of the federal program:Federal Grantor: Department of Defense (DOD)Assistance Listing No.: 12.420, Military Medical Research and DevelopmentPass-Through Grantor: Johns Hopkins UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.172, Human Genome ResearchPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.226, Research on Healthcare Costs, Quality and OutcomesPass-Through Grantor: The Regents of the University of MichiganFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.242, Mental Health Research GrantsPass-Through Grantor: Rutgers State UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.307, Minority Health and Health Disparities ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.310, Trans-NIH Research SupportPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.350, National Center for Advancing Translational SciencesPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.351, Research Infrastructure ProgramPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.361, Nursing ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.368, 21st Century Cures Act – Precision Medicine InitiativePass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.394, Cancer Detection and Diagnosis ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.395, Cancer Treatment ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.396, Cancer Biology ResearchPass-Through Grantor: Tulane University, Louisiana State UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.397, Cancer Centers Support GrantsPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.667, Social Services Block GrantPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.837, Cardiovascular Diseases ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.838, Lung Diseases ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.847, Diabetes, Digestive, and Kidney Diseases Extramural ResearchPass-Through Grantors: Northwestern University, Duke University, University of Washington, The Regents of University of MichiganFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.853, Extramural Research Programs in the Neurosciences and Neurological DisordersPass-Through Grantor: Rush University Medical CenterFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.855, Allergy, Immunology and Transplantation ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.859, Biomedical Research and Research TrainingPass-Through Grantor: University of Wisconsin – MadisonFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.865, Child Health and Human Development Extramural ResearchPass-Through Grantors: Northwestern University, University of Washington, The Regents of the University of CaliforniaFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.866, Aging ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.946, Cooperative Agreements to Support State-Based Safe Motherhood and Infant Health Initiative ProgramsPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.994, Maternal and Child Health Services Block Grant to the StatesPass-Through Grantor: Northwestern Memorial HospitalCriteria or specific requirement (including statutory, regulatory, or other citation):Section 200.303 of the Uniform Guidance states the following regarding internal control: “The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).”The Uniform Guidance 2 CFR section 200.510 states, “(b) Schedule of expenditures of Federal awards. The auditee must also prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended.”Condition:Certain grants related to the Research and Development Cluster were misstated by $233,405 on the preliminary schedule of expenditures of federal awards (the Schedule) provided by management due to the inappropriate classification of costs within the general ledger; the final Schedule was corrected.In addition, an award which was not a federal grant award with expenditures of $148,388 was included on the preliminary Schedule provided by management. The final Schedule was corrected.Cause:Endeavor’s internal controls in place over the preparation of the Schedule were not sufficient to properly accumulate and accurately report all expenditures of federal awards.Effect or Potential Effect:Inaccurate or improper reporting of expenditures results in a misstated Schedule and can also potentially result in insufficient testing of the major programs or improper identification of major programs for audit purposes.Questioned costs:None.Context:The table below reflects the preliminary and adjusted assistance listing balances on the Schedule (only assistance listing programs which changed are included below):Identification as a repeat finding, if applicable:The finding is not a repeat finding from the prior year.Recommendation:Management should implement internal controls to ensure amounts are appropriately accumulated and reported on the Schedule and all federal expenditures are appropriately identified and reported on the Schedule.Views of responsible officials:Award amounts were changed on the Schedule after management’s review was executed. Management acknowledges that implementing the new Enterprise Resource Planning (ERP) system, in 2023 presented changes to the SEFA reporting. Management has identified and addressed the reporting issues within the new system to ensure that the grant totals are appropriately captured in the SEFA.Endeavor will enhance grant management award processes by revising its procedures and adding additional controls to monitor for accuracy of the core data. Management will reinforce the importance of timeliness and accuracy of the Schedule reporting totals to facilitate accurate reporting.
Finding 2023-001 – ReportingInformation of the federal program:Federal Grantor: Department of Defense (DOD)Assistance Listing No.: 12.420, Military Medical Research and DevelopmentPass-Through Grantor: Johns Hopkins UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.172, Human Genome ResearchPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.226, Research on Healthcare Costs, Quality and OutcomesPass-Through Grantor: The Regents of the University of MichiganFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.242, Mental Health Research GrantsPass-Through Grantor: Rutgers State UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.307, Minority Health and Health Disparities ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.310, Trans-NIH Research SupportPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.350, National Center for Advancing Translational SciencesPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.351, Research Infrastructure ProgramPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.361, Nursing ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.368, 21st Century Cures Act – Precision Medicine InitiativePass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.394, Cancer Detection and Diagnosis ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.395, Cancer Treatment ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.396, Cancer Biology ResearchPass-Through Grantor: Tulane University, Louisiana State UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.397, Cancer Centers Support GrantsPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.667, Social Services Block GrantPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.837, Cardiovascular Diseases ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.838, Lung Diseases ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.847, Diabetes, Digestive, and Kidney Diseases Extramural ResearchPass-Through Grantors: Northwestern University, Duke University, University of Washington, The Regents of University of MichiganFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.853, Extramural Research Programs in the Neurosciences and Neurological DisordersPass-Through Grantor: Rush University Medical CenterFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.855, Allergy, Immunology and Transplantation ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.859, Biomedical Research and Research TrainingPass-Through Grantor: University of Wisconsin – MadisonFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.865, Child Health and Human Development Extramural ResearchPass-Through Grantors: Northwestern University, University of Washington, The Regents of the University of CaliforniaFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.866, Aging ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.946, Cooperative Agreements to Support State-Based Safe Motherhood and Infant Health Initiative ProgramsPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.994, Maternal and Child Health Services Block Grant to the StatesPass-Through Grantor: Northwestern Memorial HospitalCriteria or specific requirement (including statutory, regulatory, or other citation):Section 200.303 of the Uniform Guidance states the following regarding internal control: “The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).”The Uniform Guidance 2 CFR section 200.510 states, “(b) Schedule of expenditures of Federal awards. The auditee must also prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended.”Condition:Certain grants related to the Research and Development Cluster were misstated by $233,405 on the preliminary schedule of expenditures of federal awards (the Schedule) provided by management due to the inappropriate classification of costs within the general ledger; the final Schedule was corrected.In addition, an award which was not a federal grant award with expenditures of $148,388 was included on the preliminary Schedule provided by management. The final Schedule was corrected.Cause:Endeavor’s internal controls in place over the preparation of the Schedule were not sufficient to properly accumulate and accurately report all expenditures of federal awards.Effect or Potential Effect:Inaccurate or improper reporting of expenditures results in a misstated Schedule and can also potentially result in insufficient testing of the major programs or improper identification of major programs for audit purposes.Questioned costs:None.Context:The table below reflects the preliminary and adjusted assistance listing balances on the Schedule (only assistance listing programs which changed are included below):Identification as a repeat finding, if applicable:The finding is not a repeat finding from the prior year.Recommendation:Management should implement internal controls to ensure amounts are appropriately accumulated and reported on the Schedule and all federal expenditures are appropriately identified and reported on the Schedule.Views of responsible officials:Award amounts were changed on the Schedule after management’s review was executed. Management acknowledges that implementing the new Enterprise Resource Planning (ERP) system, in 2023 presented changes to the SEFA reporting. Management has identified and addressed the reporting issues within the new system to ensure that the grant totals are appropriately captured in the SEFA.Endeavor will enhance grant management award processes by revising its procedures and adding additional controls to monitor for accuracy of the core data. Management will reinforce the importance of timeliness and accuracy of the Schedule reporting totals to facilitate accurate reporting.
Finding 2023-001 – ReportingInformation of the federal program:Federal Grantor: Department of Defense (DOD)Assistance Listing No.: 12.420, Military Medical Research and DevelopmentPass-Through Grantor: Johns Hopkins UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.172, Human Genome ResearchPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.226, Research on Healthcare Costs, Quality and OutcomesPass-Through Grantor: The Regents of the University of MichiganFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.242, Mental Health Research GrantsPass-Through Grantor: Rutgers State UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.307, Minority Health and Health Disparities ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.310, Trans-NIH Research SupportPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.350, National Center for Advancing Translational SciencesPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.351, Research Infrastructure ProgramPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.361, Nursing ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.368, 21st Century Cures Act – Precision Medicine InitiativePass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.394, Cancer Detection and Diagnosis ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.395, Cancer Treatment ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.396, Cancer Biology ResearchPass-Through Grantor: Tulane University, Louisiana State UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.397, Cancer Centers Support GrantsPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.667, Social Services Block GrantPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.837, Cardiovascular Diseases ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.838, Lung Diseases ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.847, Diabetes, Digestive, and Kidney Diseases Extramural ResearchPass-Through Grantors: Northwestern University, Duke University, University of Washington, The Regents of University of MichiganFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.853, Extramural Research Programs in the Neurosciences and Neurological DisordersPass-Through Grantor: Rush University Medical CenterFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.855, Allergy, Immunology and Transplantation ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.859, Biomedical Research and Research TrainingPass-Through Grantor: University of Wisconsin – MadisonFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.865, Child Health and Human Development Extramural ResearchPass-Through Grantors: Northwestern University, University of Washington, The Regents of the University of CaliforniaFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.866, Aging ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.946, Cooperative Agreements to Support State-Based Safe Motherhood and Infant Health Initiative ProgramsPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.994, Maternal and Child Health Services Block Grant to the StatesPass-Through Grantor: Northwestern Memorial HospitalCriteria or specific requirement (including statutory, regulatory, or other citation):Section 200.303 of the Uniform Guidance states the following regarding internal control: “The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).”The Uniform Guidance 2 CFR section 200.510 states, “(b) Schedule of expenditures of Federal awards. The auditee must also prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended.”Condition:Certain grants related to the Research and Development Cluster were misstated by $233,405 on the preliminary schedule of expenditures of federal awards (the Schedule) provided by management due to the inappropriate classification of costs within the general ledger; the final Schedule was corrected.In addition, an award which was not a federal grant award with expenditures of $148,388 was included on the preliminary Schedule provided by management. The final Schedule was corrected.Cause:Endeavor’s internal controls in place over the preparation of the Schedule were not sufficient to properly accumulate and accurately report all expenditures of federal awards.Effect or Potential Effect:Inaccurate or improper reporting of expenditures results in a misstated Schedule and can also potentially result in insufficient testing of the major programs or improper identification of major programs for audit purposes.Questioned costs:None.Context:The table below reflects the preliminary and adjusted assistance listing balances on the Schedule (only assistance listing programs which changed are included below):Identification as a repeat finding, if applicable:The finding is not a repeat finding from the prior year.Recommendation:Management should implement internal controls to ensure amounts are appropriately accumulated and reported on the Schedule and all federal expenditures are appropriately identified and reported on the Schedule.Views of responsible officials:Award amounts were changed on the Schedule after management’s review was executed. Management acknowledges that implementing the new Enterprise Resource Planning (ERP) system, in 2023 presented changes to the SEFA reporting. Management has identified and addressed the reporting issues within the new system to ensure that the grant totals are appropriately captured in the SEFA.Endeavor will enhance grant management award processes by revising its procedures and adding additional controls to monitor for accuracy of the core data. Management will reinforce the importance of timeliness and accuracy of the Schedule reporting totals to facilitate accurate reporting.
Finding 2023-001 – ReportingInformation of the federal program:Federal Grantor: Department of Defense (DOD)Assistance Listing No.: 12.420, Military Medical Research and DevelopmentPass-Through Grantor: Johns Hopkins UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.172, Human Genome ResearchPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.226, Research on Healthcare Costs, Quality and OutcomesPass-Through Grantor: The Regents of the University of MichiganFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.242, Mental Health Research GrantsPass-Through Grantor: Rutgers State UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.307, Minority Health and Health Disparities ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.310, Trans-NIH Research SupportPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.350, National Center for Advancing Translational SciencesPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.351, Research Infrastructure ProgramPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.361, Nursing ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.368, 21st Century Cures Act – Precision Medicine InitiativePass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.394, Cancer Detection and Diagnosis ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.395, Cancer Treatment ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.396, Cancer Biology ResearchPass-Through Grantor: Tulane University, Louisiana State UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.397, Cancer Centers Support GrantsPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.667, Social Services Block GrantPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.837, Cardiovascular Diseases ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.838, Lung Diseases ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.847, Diabetes, Digestive, and Kidney Diseases Extramural ResearchPass-Through Grantors: Northwestern University, Duke University, University of Washington, The Regents of University of MichiganFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.853, Extramural Research Programs in the Neurosciences and Neurological DisordersPass-Through Grantor: Rush University Medical CenterFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.855, Allergy, Immunology and Transplantation ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.859, Biomedical Research and Research TrainingPass-Through Grantor: University of Wisconsin – MadisonFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.865, Child Health and Human Development Extramural ResearchPass-Through Grantors: Northwestern University, University of Washington, The Regents of the University of CaliforniaFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.866, Aging ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.946, Cooperative Agreements to Support State-Based Safe Motherhood and Infant Health Initiative ProgramsPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.994, Maternal and Child Health Services Block Grant to the StatesPass-Through Grantor: Northwestern Memorial HospitalCriteria or specific requirement (including statutory, regulatory, or other citation):Section 200.303 of the Uniform Guidance states the following regarding internal control: “The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).”The Uniform Guidance 2 CFR section 200.510 states, “(b) Schedule of expenditures of Federal awards. The auditee must also prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended.”Condition:Certain grants related to the Research and Development Cluster were misstated by $233,405 on the preliminary schedule of expenditures of federal awards (the Schedule) provided by management due to the inappropriate classification of costs within the general ledger; the final Schedule was corrected.In addition, an award which was not a federal grant award with expenditures of $148,388 was included on the preliminary Schedule provided by management. The final Schedule was corrected.Cause:Endeavor’s internal controls in place over the preparation of the Schedule were not sufficient to properly accumulate and accurately report all expenditures of federal awards.Effect or Potential Effect:Inaccurate or improper reporting of expenditures results in a misstated Schedule and can also potentially result in insufficient testing of the major programs or improper identification of major programs for audit purposes.Questioned costs:None.Context:The table below reflects the preliminary and adjusted assistance listing balances on the Schedule (only assistance listing programs which changed are included below):Identification as a repeat finding, if applicable:The finding is not a repeat finding from the prior year.Recommendation:Management should implement internal controls to ensure amounts are appropriately accumulated and reported on the Schedule and all federal expenditures are appropriately identified and reported on the Schedule.Views of responsible officials:Award amounts were changed on the Schedule after management’s review was executed. Management acknowledges that implementing the new Enterprise Resource Planning (ERP) system, in 2023 presented changes to the SEFA reporting. Management has identified and addressed the reporting issues within the new system to ensure that the grant totals are appropriately captured in the SEFA.Endeavor will enhance grant management award processes by revising its procedures and adding additional controls to monitor for accuracy of the core data. Management will reinforce the importance of timeliness and accuracy of the Schedule reporting totals to facilitate accurate reporting.
Finding 2023-001 – ReportingInformation of the federal program:Federal Grantor: Department of Defense (DOD)Assistance Listing No.: 12.420, Military Medical Research and DevelopmentPass-Through Grantor: Johns Hopkins UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.172, Human Genome ResearchPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.226, Research on Healthcare Costs, Quality and OutcomesPass-Through Grantor: The Regents of the University of MichiganFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.242, Mental Health Research GrantsPass-Through Grantor: Rutgers State UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.307, Minority Health and Health Disparities ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.310, Trans-NIH Research SupportPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.350, National Center for Advancing Translational SciencesPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.351, Research Infrastructure ProgramPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.361, Nursing ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.368, 21st Century Cures Act – Precision Medicine InitiativePass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.394, Cancer Detection and Diagnosis ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.395, Cancer Treatment ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.396, Cancer Biology ResearchPass-Through Grantor: Tulane University, Louisiana State UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.397, Cancer Centers Support GrantsPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.667, Social Services Block GrantPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.837, Cardiovascular Diseases ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.838, Lung Diseases ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.847, Diabetes, Digestive, and Kidney Diseases Extramural ResearchPass-Through Grantors: Northwestern University, Duke University, University of Washington, The Regents of University of MichiganFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.853, Extramural Research Programs in the Neurosciences and Neurological DisordersPass-Through Grantor: Rush University Medical CenterFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.855, Allergy, Immunology and Transplantation ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.859, Biomedical Research and Research TrainingPass-Through Grantor: University of Wisconsin – MadisonFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.865, Child Health and Human Development Extramural ResearchPass-Through Grantors: Northwestern University, University of Washington, The Regents of the University of CaliforniaFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.866, Aging ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.946, Cooperative Agreements to Support State-Based Safe Motherhood and Infant Health Initiative ProgramsPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.994, Maternal and Child Health Services Block Grant to the StatesPass-Through Grantor: Northwestern Memorial HospitalCriteria or specific requirement (including statutory, regulatory, or other citation):Section 200.303 of the Uniform Guidance states the following regarding internal control: “The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).”The Uniform Guidance 2 CFR section 200.510 states, “(b) Schedule of expenditures of Federal awards. The auditee must also prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended.”Condition:Certain grants related to the Research and Development Cluster were misstated by $233,405 on the preliminary schedule of expenditures of federal awards (the Schedule) provided by management due to the inappropriate classification of costs within the general ledger; the final Schedule was corrected.In addition, an award which was not a federal grant award with expenditures of $148,388 was included on the preliminary Schedule provided by management. The final Schedule was corrected.Cause:Endeavor’s internal controls in place over the preparation of the Schedule were not sufficient to properly accumulate and accurately report all expenditures of federal awards.Effect or Potential Effect:Inaccurate or improper reporting of expenditures results in a misstated Schedule and can also potentially result in insufficient testing of the major programs or improper identification of major programs for audit purposes.Questioned costs:None.Context:The table below reflects the preliminary and adjusted assistance listing balances on the Schedule (only assistance listing programs which changed are included below):Identification as a repeat finding, if applicable:The finding is not a repeat finding from the prior year.Recommendation:Management should implement internal controls to ensure amounts are appropriately accumulated and reported on the Schedule and all federal expenditures are appropriately identified and reported on the Schedule.Views of responsible officials:Award amounts were changed on the Schedule after management’s review was executed. Management acknowledges that implementing the new Enterprise Resource Planning (ERP) system, in 2023 presented changes to the SEFA reporting. Management has identified and addressed the reporting issues within the new system to ensure that the grant totals are appropriately captured in the SEFA.Endeavor will enhance grant management award processes by revising its procedures and adding additional controls to monitor for accuracy of the core data. Management will reinforce the importance of timeliness and accuracy of the Schedule reporting totals to facilitate accurate reporting.
Finding 2023-001 – ReportingInformation of the federal program:Federal Grantor: Department of Defense (DOD)Assistance Listing No.: 12.420, Military Medical Research and DevelopmentPass-Through Grantor: Johns Hopkins UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.172, Human Genome ResearchPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.226, Research on Healthcare Costs, Quality and OutcomesPass-Through Grantor: The Regents of the University of MichiganFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.242, Mental Health Research GrantsPass-Through Grantor: Rutgers State UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.307, Minority Health and Health Disparities ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.310, Trans-NIH Research SupportPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.350, National Center for Advancing Translational SciencesPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.351, Research Infrastructure ProgramPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.361, Nursing ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.368, 21st Century Cures Act – Precision Medicine InitiativePass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.394, Cancer Detection and Diagnosis ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.395, Cancer Treatment ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.396, Cancer Biology ResearchPass-Through Grantor: Tulane University, Louisiana State UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.397, Cancer Centers Support GrantsPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.667, Social Services Block GrantPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.837, Cardiovascular Diseases ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.838, Lung Diseases ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.847, Diabetes, Digestive, and Kidney Diseases Extramural ResearchPass-Through Grantors: Northwestern University, Duke University, University of Washington, The Regents of University of MichiganFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.853, Extramural Research Programs in the Neurosciences and Neurological DisordersPass-Through Grantor: Rush University Medical CenterFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.855, Allergy, Immunology and Transplantation ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.859, Biomedical Research and Research TrainingPass-Through Grantor: University of Wisconsin – MadisonFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.865, Child Health and Human Development Extramural ResearchPass-Through Grantors: Northwestern University, University of Washington, The Regents of the University of CaliforniaFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.866, Aging ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.946, Cooperative Agreements to Support State-Based Safe Motherhood and Infant Health Initiative ProgramsPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.994, Maternal and Child Health Services Block Grant to the StatesPass-Through Grantor: Northwestern Memorial HospitalCriteria or specific requirement (including statutory, regulatory, or other citation):Section 200.303 of the Uniform Guidance states the following regarding internal control: “The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).”The Uniform Guidance 2 CFR section 200.510 states, “(b) Schedule of expenditures of Federal awards. The auditee must also prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended.”Condition:Certain grants related to the Research and Development Cluster were misstated by $233,405 on the preliminary schedule of expenditures of federal awards (the Schedule) provided by management due to the inappropriate classification of costs within the general ledger; the final Schedule was corrected.In addition, an award which was not a federal grant award with expenditures of $148,388 was included on the preliminary Schedule provided by management. The final Schedule was corrected.Cause:Endeavor’s internal controls in place over the preparation of the Schedule were not sufficient to properly accumulate and accurately report all expenditures of federal awards.Effect or Potential Effect:Inaccurate or improper reporting of expenditures results in a misstated Schedule and can also potentially result in insufficient testing of the major programs or improper identification of major programs for audit purposes.Questioned costs:None.Context:The table below reflects the preliminary and adjusted assistance listing balances on the Schedule (only assistance listing programs which changed are included below):Identification as a repeat finding, if applicable:The finding is not a repeat finding from the prior year.Recommendation:Management should implement internal controls to ensure amounts are appropriately accumulated and reported on the Schedule and all federal expenditures are appropriately identified and reported on the Schedule.Views of responsible officials:Award amounts were changed on the Schedule after management’s review was executed. Management acknowledges that implementing the new Enterprise Resource Planning (ERP) system, in 2023 presented changes to the SEFA reporting. Management has identified and addressed the reporting issues within the new system to ensure that the grant totals are appropriately captured in the SEFA.Endeavor will enhance grant management award processes by revising its procedures and adding additional controls to monitor for accuracy of the core data. Management will reinforce the importance of timeliness and accuracy of the Schedule reporting totals to facilitate accurate reporting.
Finding 2023-001 – ReportingInformation of the federal program:Federal Grantor: Department of Defense (DOD)Assistance Listing No.: 12.420, Military Medical Research and DevelopmentPass-Through Grantor: Johns Hopkins UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.172, Human Genome ResearchPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.226, Research on Healthcare Costs, Quality and OutcomesPass-Through Grantor: The Regents of the University of MichiganFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.242, Mental Health Research GrantsPass-Through Grantor: Rutgers State UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.307, Minority Health and Health Disparities ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.310, Trans-NIH Research SupportPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.350, National Center for Advancing Translational SciencesPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.351, Research Infrastructure ProgramPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.361, Nursing ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.368, 21st Century Cures Act – Precision Medicine InitiativePass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.394, Cancer Detection and Diagnosis ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.395, Cancer Treatment ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.396, Cancer Biology ResearchPass-Through Grantor: Tulane University, Louisiana State UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.397, Cancer Centers Support GrantsPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.667, Social Services Block GrantPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.837, Cardiovascular Diseases ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.838, Lung Diseases ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.847, Diabetes, Digestive, and Kidney Diseases Extramural ResearchPass-Through Grantors: Northwestern University, Duke University, University of Washington, The Regents of University of MichiganFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.853, Extramural Research Programs in the Neurosciences and Neurological DisordersPass-Through Grantor: Rush University Medical CenterFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.855, Allergy, Immunology and Transplantation ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.859, Biomedical Research and Research TrainingPass-Through Grantor: University of Wisconsin – MadisonFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.865, Child Health and Human Development Extramural ResearchPass-Through Grantors: Northwestern University, University of Washington, The Regents of the University of CaliforniaFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.866, Aging ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.946, Cooperative Agreements to Support State-Based Safe Motherhood and Infant Health Initiative ProgramsPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.994, Maternal and Child Health Services Block Grant to the StatesPass-Through Grantor: Northwestern Memorial HospitalCriteria or specific requirement (including statutory, regulatory, or other citation):Section 200.303 of the Uniform Guidance states the following regarding internal control: “The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).”The Uniform Guidance 2 CFR section 200.510 states, “(b) Schedule of expenditures of Federal awards. The auditee must also prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended.”Condition:Certain grants related to the Research and Development Cluster were misstated by $233,405 on the preliminary schedule of expenditures of federal awards (the Schedule) provided by management due to the inappropriate classification of costs within the general ledger; the final Schedule was corrected.In addition, an award which was not a federal grant award with expenditures of $148,388 was included on the preliminary Schedule provided by management. The final Schedule was corrected.Cause:Endeavor’s internal controls in place over the preparation of the Schedule were not sufficient to properly accumulate and accurately report all expenditures of federal awards.Effect or Potential Effect:Inaccurate or improper reporting of expenditures results in a misstated Schedule and can also potentially result in insufficient testing of the major programs or improper identification of major programs for audit purposes.Questioned costs:None.Context:The table below reflects the preliminary and adjusted assistance listing balances on the Schedule (only assistance listing programs which changed are included below):Identification as a repeat finding, if applicable:The finding is not a repeat finding from the prior year.Recommendation:Management should implement internal controls to ensure amounts are appropriately accumulated and reported on the Schedule and all federal expenditures are appropriately identified and reported on the Schedule.Views of responsible officials:Award amounts were changed on the Schedule after management’s review was executed. Management acknowledges that implementing the new Enterprise Resource Planning (ERP) system, in 2023 presented changes to the SEFA reporting. Management has identified and addressed the reporting issues within the new system to ensure that the grant totals are appropriately captured in the SEFA.Endeavor will enhance grant management award processes by revising its procedures and adding additional controls to monitor for accuracy of the core data. Management will reinforce the importance of timeliness and accuracy of the Schedule reporting totals to facilitate accurate reporting.
Finding 2023-001 – ReportingInformation of the federal program:Federal Grantor: Department of Defense (DOD)Assistance Listing No.: 12.420, Military Medical Research and DevelopmentPass-Through Grantor: Johns Hopkins UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.172, Human Genome ResearchPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.226, Research on Healthcare Costs, Quality and OutcomesPass-Through Grantor: The Regents of the University of MichiganFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.242, Mental Health Research GrantsPass-Through Grantor: Rutgers State UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.307, Minority Health and Health Disparities ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.310, Trans-NIH Research SupportPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.350, National Center for Advancing Translational SciencesPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.351, Research Infrastructure ProgramPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.361, Nursing ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.368, 21st Century Cures Act – Precision Medicine InitiativePass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.394, Cancer Detection and Diagnosis ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.395, Cancer Treatment ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.396, Cancer Biology ResearchPass-Through Grantor: Tulane University, Louisiana State UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.397, Cancer Centers Support GrantsPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.667, Social Services Block GrantPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.837, Cardiovascular Diseases ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.838, Lung Diseases ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.847, Diabetes, Digestive, and Kidney Diseases Extramural ResearchPass-Through Grantors: Northwestern University, Duke University, University of Washington, The Regents of University of MichiganFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.853, Extramural Research Programs in the Neurosciences and Neurological DisordersPass-Through Grantor: Rush University Medical CenterFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.855, Allergy, Immunology and Transplantation ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.859, Biomedical Research and Research TrainingPass-Through Grantor: University of Wisconsin – MadisonFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.865, Child Health and Human Development Extramural ResearchPass-Through Grantors: Northwestern University, University of Washington, The Regents of the University of CaliforniaFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.866, Aging ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.946, Cooperative Agreements to Support State-Based Safe Motherhood and Infant Health Initiative ProgramsPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.994, Maternal and Child Health Services Block Grant to the StatesPass-Through Grantor: Northwestern Memorial HospitalCriteria or specific requirement (including statutory, regulatory, or other citation):Section 200.303 of the Uniform Guidance states the following regarding internal control: “The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).”The Uniform Guidance 2 CFR section 200.510 states, “(b) Schedule of expenditures of Federal awards. The auditee must also prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended.”Condition:Certain grants related to the Research and Development Cluster were misstated by $233,405 on the preliminary schedule of expenditures of federal awards (the Schedule) provided by management due to the inappropriate classification of costs within the general ledger; the final Schedule was corrected.In addition, an award which was not a federal grant award with expenditures of $148,388 was included on the preliminary Schedule provided by management. The final Schedule was corrected.Cause:Endeavor’s internal controls in place over the preparation of the Schedule were not sufficient to properly accumulate and accurately report all expenditures of federal awards.Effect or Potential Effect:Inaccurate or improper reporting of expenditures results in a misstated Schedule and can also potentially result in insufficient testing of the major programs or improper identification of major programs for audit purposes.Questioned costs:None.Context:The table below reflects the preliminary and adjusted assistance listing balances on the Schedule (only assistance listing programs which changed are included below):Identification as a repeat finding, if applicable:The finding is not a repeat finding from the prior year.Recommendation:Management should implement internal controls to ensure amounts are appropriately accumulated and reported on the Schedule and all federal expenditures are appropriately identified and reported on the Schedule.Views of responsible officials:Award amounts were changed on the Schedule after management’s review was executed. Management acknowledges that implementing the new Enterprise Resource Planning (ERP) system, in 2023 presented changes to the SEFA reporting. Management has identified and addressed the reporting issues within the new system to ensure that the grant totals are appropriately captured in the SEFA.Endeavor will enhance grant management award processes by revising its procedures and adding additional controls to monitor for accuracy of the core data. Management will reinforce the importance of timeliness and accuracy of the Schedule reporting totals to facilitate accurate reporting.
Finding 2023-001 – ReportingInformation of the federal program:Federal Grantor: Department of Defense (DOD)Assistance Listing No.: 12.420, Military Medical Research and DevelopmentPass-Through Grantor: Johns Hopkins UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.172, Human Genome ResearchPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.226, Research on Healthcare Costs, Quality and OutcomesPass-Through Grantor: The Regents of the University of MichiganFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.242, Mental Health Research GrantsPass-Through Grantor: Rutgers State UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.307, Minority Health and Health Disparities ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.310, Trans-NIH Research SupportPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.350, National Center for Advancing Translational SciencesPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.351, Research Infrastructure ProgramPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.361, Nursing ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.368, 21st Century Cures Act – Precision Medicine InitiativePass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.394, Cancer Detection and Diagnosis ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.395, Cancer Treatment ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.396, Cancer Biology ResearchPass-Through Grantor: Tulane University, Louisiana State UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.397, Cancer Centers Support GrantsPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.667, Social Services Block GrantPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.837, Cardiovascular Diseases ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.838, Lung Diseases ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.847, Diabetes, Digestive, and Kidney Diseases Extramural ResearchPass-Through Grantors: Northwestern University, Duke University, University of Washington, The Regents of University of MichiganFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.853, Extramural Research Programs in the Neurosciences and Neurological DisordersPass-Through Grantor: Rush University Medical CenterFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.855, Allergy, Immunology and Transplantation ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.859, Biomedical Research and Research TrainingPass-Through Grantor: University of Wisconsin – MadisonFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.865, Child Health and Human Development Extramural ResearchPass-Through Grantors: Northwestern University, University of Washington, The Regents of the University of CaliforniaFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.866, Aging ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.946, Cooperative Agreements to Support State-Based Safe Motherhood and Infant Health Initiative ProgramsPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.994, Maternal and Child Health Services Block Grant to the StatesPass-Through Grantor: Northwestern Memorial HospitalCriteria or specific requirement (including statutory, regulatory, or other citation):Section 200.303 of the Uniform Guidance states the following regarding internal control: “The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).”The Uniform Guidance 2 CFR section 200.510 states, “(b) Schedule of expenditures of Federal awards. The auditee must also prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended.”Condition:Certain grants related to the Research and Development Cluster were misstated by $233,405 on the preliminary schedule of expenditures of federal awards (the Schedule) provided by management due to the inappropriate classification of costs within the general ledger; the final Schedule was corrected.In addition, an award which was not a federal grant award with expenditures of $148,388 was included on the preliminary Schedule provided by management. The final Schedule was corrected.Cause:Endeavor’s internal controls in place over the preparation of the Schedule were not sufficient to properly accumulate and accurately report all expenditures of federal awards.Effect or Potential Effect:Inaccurate or improper reporting of expenditures results in a misstated Schedule and can also potentially result in insufficient testing of the major programs or improper identification of major programs for audit purposes.Questioned costs:None.Context:The table below reflects the preliminary and adjusted assistance listing balances on the Schedule (only assistance listing programs which changed are included below):Identification as a repeat finding, if applicable:The finding is not a repeat finding from the prior year.Recommendation:Management should implement internal controls to ensure amounts are appropriately accumulated and reported on the Schedule and all federal expenditures are appropriately identified and reported on the Schedule.Views of responsible officials:Award amounts were changed on the Schedule after management’s review was executed. Management acknowledges that implementing the new Enterprise Resource Planning (ERP) system, in 2023 presented changes to the SEFA reporting. Management has identified and addressed the reporting issues within the new system to ensure that the grant totals are appropriately captured in the SEFA.Endeavor will enhance grant management award processes by revising its procedures and adding additional controls to monitor for accuracy of the core data. Management will reinforce the importance of timeliness and accuracy of the Schedule reporting totals to facilitate accurate reporting.
Finding 2023-001 – ReportingInformation of the federal program:Federal Grantor: Department of Defense (DOD)Assistance Listing No.: 12.420, Military Medical Research and DevelopmentPass-Through Grantor: Johns Hopkins UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.172, Human Genome ResearchPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.226, Research on Healthcare Costs, Quality and OutcomesPass-Through Grantor: The Regents of the University of MichiganFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.242, Mental Health Research GrantsPass-Through Grantor: Rutgers State UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.307, Minority Health and Health Disparities ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.310, Trans-NIH Research SupportPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.350, National Center for Advancing Translational SciencesPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.351, Research Infrastructure ProgramPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.361, Nursing ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.368, 21st Century Cures Act – Precision Medicine InitiativePass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.394, Cancer Detection and Diagnosis ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.395, Cancer Treatment ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.396, Cancer Biology ResearchPass-Through Grantor: Tulane University, Louisiana State UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.397, Cancer Centers Support GrantsPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.667, Social Services Block GrantPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.837, Cardiovascular Diseases ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.838, Lung Diseases ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.847, Diabetes, Digestive, and Kidney Diseases Extramural ResearchPass-Through Grantors: Northwestern University, Duke University, University of Washington, The Regents of University of MichiganFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.853, Extramural Research Programs in the Neurosciences and Neurological DisordersPass-Through Grantor: Rush University Medical CenterFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.855, Allergy, Immunology and Transplantation ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.859, Biomedical Research and Research TrainingPass-Through Grantor: University of Wisconsin – MadisonFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.865, Child Health and Human Development Extramural ResearchPass-Through Grantors: Northwestern University, University of Washington, The Regents of the University of CaliforniaFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.866, Aging ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.946, Cooperative Agreements to Support State-Based Safe Motherhood and Infant Health Initiative ProgramsPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.994, Maternal and Child Health Services Block Grant to the StatesPass-Through Grantor: Northwestern Memorial HospitalCriteria or specific requirement (including statutory, regulatory, or other citation):Section 200.303 of the Uniform Guidance states the following regarding internal control: “The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).”The Uniform Guidance 2 CFR section 200.510 states, “(b) Schedule of expenditures of Federal awards. The auditee must also prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended.”Condition:Certain grants related to the Research and Development Cluster were misstated by $233,405 on the preliminary schedule of expenditures of federal awards (the Schedule) provided by management due to the inappropriate classification of costs within the general ledger; the final Schedule was corrected.In addition, an award which was not a federal grant award with expenditures of $148,388 was included on the preliminary Schedule provided by management. The final Schedule was corrected.Cause:Endeavor’s internal controls in place over the preparation of the Schedule were not sufficient to properly accumulate and accurately report all expenditures of federal awards.Effect or Potential Effect:Inaccurate or improper reporting of expenditures results in a misstated Schedule and can also potentially result in insufficient testing of the major programs or improper identification of major programs for audit purposes.Questioned costs:None.Context:The table below reflects the preliminary and adjusted assistance listing balances on the Schedule (only assistance listing programs which changed are included below):Identification as a repeat finding, if applicable:The finding is not a repeat finding from the prior year.Recommendation:Management should implement internal controls to ensure amounts are appropriately accumulated and reported on the Schedule and all federal expenditures are appropriately identified and reported on the Schedule.Views of responsible officials:Award amounts were changed on the Schedule after management’s review was executed. Management acknowledges that implementing the new Enterprise Resource Planning (ERP) system, in 2023 presented changes to the SEFA reporting. Management has identified and addressed the reporting issues within the new system to ensure that the grant totals are appropriately captured in the SEFA.Endeavor will enhance grant management award processes by revising its procedures and adding additional controls to monitor for accuracy of the core data. Management will reinforce the importance of timeliness and accuracy of the Schedule reporting totals to facilitate accurate reporting.
Finding 2023-001 – ReportingInformation of the federal program:Federal Grantor: Department of Defense (DOD)Assistance Listing No.: 12.420, Military Medical Research and DevelopmentPass-Through Grantor: Johns Hopkins UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.172, Human Genome ResearchPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.226, Research on Healthcare Costs, Quality and OutcomesPass-Through Grantor: The Regents of the University of MichiganFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.242, Mental Health Research GrantsPass-Through Grantor: Rutgers State UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.307, Minority Health and Health Disparities ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.310, Trans-NIH Research SupportPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.350, National Center for Advancing Translational SciencesPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.351, Research Infrastructure ProgramPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.361, Nursing ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.368, 21st Century Cures Act – Precision Medicine InitiativePass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.394, Cancer Detection and Diagnosis ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.395, Cancer Treatment ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.396, Cancer Biology ResearchPass-Through Grantor: Tulane University, Louisiana State UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.397, Cancer Centers Support GrantsPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.667, Social Services Block GrantPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.837, Cardiovascular Diseases ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.838, Lung Diseases ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.847, Diabetes, Digestive, and Kidney Diseases Extramural ResearchPass-Through Grantors: Northwestern University, Duke University, University of Washington, The Regents of University of MichiganFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.853, Extramural Research Programs in the Neurosciences and Neurological DisordersPass-Through Grantor: Rush University Medical CenterFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.855, Allergy, Immunology and Transplantation ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.859, Biomedical Research and Research TrainingPass-Through Grantor: University of Wisconsin – MadisonFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.865, Child Health and Human Development Extramural ResearchPass-Through Grantors: Northwestern University, University of Washington, The Regents of the University of CaliforniaFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.866, Aging ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.946, Cooperative Agreements to Support State-Based Safe Motherhood and Infant Health Initiative ProgramsPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.994, Maternal and Child Health Services Block Grant to the StatesPass-Through Grantor: Northwestern Memorial HospitalCriteria or specific requirement (including statutory, regulatory, or other citation):Section 200.303 of the Uniform Guidance states the following regarding internal control: “The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).”The Uniform Guidance 2 CFR section 200.510 states, “(b) Schedule of expenditures of Federal awards. The auditee must also prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended.”Condition:Certain grants related to the Research and Development Cluster were misstated by $233,405 on the preliminary schedule of expenditures of federal awards (the Schedule) provided by management due to the inappropriate classification of costs within the general ledger; the final Schedule was corrected.In addition, an award which was not a federal grant award with expenditures of $148,388 was included on the preliminary Schedule provided by management. The final Schedule was corrected.Cause:Endeavor’s internal controls in place over the preparation of the Schedule were not sufficient to properly accumulate and accurately report all expenditures of federal awards.Effect or Potential Effect:Inaccurate or improper reporting of expenditures results in a misstated Schedule and can also potentially result in insufficient testing of the major programs or improper identification of major programs for audit purposes.Questioned costs:None.Context:The table below reflects the preliminary and adjusted assistance listing balances on the Schedule (only assistance listing programs which changed are included below):Identification as a repeat finding, if applicable:The finding is not a repeat finding from the prior year.Recommendation:Management should implement internal controls to ensure amounts are appropriately accumulated and reported on the Schedule and all federal expenditures are appropriately identified and reported on the Schedule.Views of responsible officials:Award amounts were changed on the Schedule after management’s review was executed. Management acknowledges that implementing the new Enterprise Resource Planning (ERP) system, in 2023 presented changes to the SEFA reporting. Management has identified and addressed the reporting issues within the new system to ensure that the grant totals are appropriately captured in the SEFA.Endeavor will enhance grant management award processes by revising its procedures and adding additional controls to monitor for accuracy of the core data. Management will reinforce the importance of timeliness and accuracy of the Schedule reporting totals to facilitate accurate reporting.
Finding 2023-001 – ReportingInformation of the federal program:Federal Grantor: Department of Defense (DOD)Assistance Listing No.: 12.420, Military Medical Research and DevelopmentPass-Through Grantor: Johns Hopkins UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.172, Human Genome ResearchPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.226, Research on Healthcare Costs, Quality and OutcomesPass-Through Grantor: The Regents of the University of MichiganFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.242, Mental Health Research GrantsPass-Through Grantor: Rutgers State UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.307, Minority Health and Health Disparities ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.310, Trans-NIH Research SupportPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.350, National Center for Advancing Translational SciencesPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.351, Research Infrastructure ProgramPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.361, Nursing ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.368, 21st Century Cures Act – Precision Medicine InitiativePass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.394, Cancer Detection and Diagnosis ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.395, Cancer Treatment ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.396, Cancer Biology ResearchPass-Through Grantor: Tulane University, Louisiana State UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.397, Cancer Centers Support GrantsPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.667, Social Services Block GrantPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.837, Cardiovascular Diseases ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.838, Lung Diseases ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.847, Diabetes, Digestive, and Kidney Diseases Extramural ResearchPass-Through Grantors: Northwestern University, Duke University, University of Washington, The Regents of University of MichiganFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.853, Extramural Research Programs in the Neurosciences and Neurological DisordersPass-Through Grantor: Rush University Medical CenterFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.855, Allergy, Immunology and Transplantation ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.859, Biomedical Research and Research TrainingPass-Through Grantor: University of Wisconsin – MadisonFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.865, Child Health and Human Development Extramural ResearchPass-Through Grantors: Northwestern University, University of Washington, The Regents of the University of CaliforniaFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.866, Aging ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.946, Cooperative Agreements to Support State-Based Safe Motherhood and Infant Health Initiative ProgramsPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.994, Maternal and Child Health Services Block Grant to the StatesPass-Through Grantor: Northwestern Memorial HospitalCriteria or specific requirement (including statutory, regulatory, or other citation):Section 200.303 of the Uniform Guidance states the following regarding internal control: “The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).”The Uniform Guidance 2 CFR section 200.510 states, “(b) Schedule of expenditures of Federal awards. The auditee must also prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended.”Condition:Certain grants related to the Research and Development Cluster were misstated by $233,405 on the preliminary schedule of expenditures of federal awards (the Schedule) provided by management due to the inappropriate classification of costs within the general ledger; the final Schedule was corrected.In addition, an award which was not a federal grant award with expenditures of $148,388 was included on the preliminary Schedule provided by management. The final Schedule was corrected.Cause:Endeavor’s internal controls in place over the preparation of the Schedule were not sufficient to properly accumulate and accurately report all expenditures of federal awards.Effect or Potential Effect:Inaccurate or improper reporting of expenditures results in a misstated Schedule and can also potentially result in insufficient testing of the major programs or improper identification of major programs for audit purposes.Questioned costs:None.Context:The table below reflects the preliminary and adjusted assistance listing balances on the Schedule (only assistance listing programs which changed are included below):Identification as a repeat finding, if applicable:The finding is not a repeat finding from the prior year.Recommendation:Management should implement internal controls to ensure amounts are appropriately accumulated and reported on the Schedule and all federal expenditures are appropriately identified and reported on the Schedule.Views of responsible officials:Award amounts were changed on the Schedule after management’s review was executed. Management acknowledges that implementing the new Enterprise Resource Planning (ERP) system, in 2023 presented changes to the SEFA reporting. Management has identified and addressed the reporting issues within the new system to ensure that the grant totals are appropriately captured in the SEFA.Endeavor will enhance grant management award processes by revising its procedures and adding additional controls to monitor for accuracy of the core data. Management will reinforce the importance of timeliness and accuracy of the Schedule reporting totals to facilitate accurate reporting.
Finding 2023-001 – ReportingInformation of the federal program:Federal Grantor: Department of Defense (DOD)Assistance Listing No.: 12.420, Military Medical Research and DevelopmentPass-Through Grantor: Johns Hopkins UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.172, Human Genome ResearchPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.226, Research on Healthcare Costs, Quality and OutcomesPass-Through Grantor: The Regents of the University of MichiganFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.242, Mental Health Research GrantsPass-Through Grantor: Rutgers State UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.307, Minority Health and Health Disparities ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.310, Trans-NIH Research SupportPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.350, National Center for Advancing Translational SciencesPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.351, Research Infrastructure ProgramPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.361, Nursing ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.368, 21st Century Cures Act – Precision Medicine InitiativePass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.394, Cancer Detection and Diagnosis ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.395, Cancer Treatment ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.396, Cancer Biology ResearchPass-Through Grantor: Tulane University, Louisiana State UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.397, Cancer Centers Support GrantsPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.667, Social Services Block GrantPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.837, Cardiovascular Diseases ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.838, Lung Diseases ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.847, Diabetes, Digestive, and Kidney Diseases Extramural ResearchPass-Through Grantors: Northwestern University, Duke University, University of Washington, The Regents of University of MichiganFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.853, Extramural Research Programs in the Neurosciences and Neurological DisordersPass-Through Grantor: Rush University Medical CenterFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.855, Allergy, Immunology and Transplantation ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.859, Biomedical Research and Research TrainingPass-Through Grantor: University of Wisconsin – MadisonFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.865, Child Health and Human Development Extramural ResearchPass-Through Grantors: Northwestern University, University of Washington, The Regents of the University of CaliforniaFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.866, Aging ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.946, Cooperative Agreements to Support State-Based Safe Motherhood and Infant Health Initiative ProgramsPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.994, Maternal and Child Health Services Block Grant to the StatesPass-Through Grantor: Northwestern Memorial HospitalCriteria or specific requirement (including statutory, regulatory, or other citation):Section 200.303 of the Uniform Guidance states the following regarding internal control: “The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).”The Uniform Guidance 2 CFR section 200.510 states, “(b) Schedule of expenditures of Federal awards. The auditee must also prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended.”Condition:Certain grants related to the Research and Development Cluster were misstated by $233,405 on the preliminary schedule of expenditures of federal awards (the Schedule) provided by management due to the inappropriate classification of costs within the general ledger; the final Schedule was corrected.In addition, an award which was not a federal grant award with expenditures of $148,388 was included on the preliminary Schedule provided by management. The final Schedule was corrected.Cause:Endeavor’s internal controls in place over the preparation of the Schedule were not sufficient to properly accumulate and accurately report all expenditures of federal awards.Effect or Potential Effect:Inaccurate or improper reporting of expenditures results in a misstated Schedule and can also potentially result in insufficient testing of the major programs or improper identification of major programs for audit purposes.Questioned costs:None.Context:The table below reflects the preliminary and adjusted assistance listing balances on the Schedule (only assistance listing programs which changed are included below):Identification as a repeat finding, if applicable:The finding is not a repeat finding from the prior year.Recommendation:Management should implement internal controls to ensure amounts are appropriately accumulated and reported on the Schedule and all federal expenditures are appropriately identified and reported on the Schedule.Views of responsible officials:Award amounts were changed on the Schedule after management’s review was executed. Management acknowledges that implementing the new Enterprise Resource Planning (ERP) system, in 2023 presented changes to the SEFA reporting. Management has identified and addressed the reporting issues within the new system to ensure that the grant totals are appropriately captured in the SEFA.Endeavor will enhance grant management award processes by revising its procedures and adding additional controls to monitor for accuracy of the core data. Management will reinforce the importance of timeliness and accuracy of the Schedule reporting totals to facilitate accurate reporting.
Finding 2023-001 – ReportingInformation of the federal program:Federal Grantor: Department of Defense (DOD)Assistance Listing No.: 12.420, Military Medical Research and DevelopmentPass-Through Grantor: Johns Hopkins UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.172, Human Genome ResearchPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.226, Research on Healthcare Costs, Quality and OutcomesPass-Through Grantor: The Regents of the University of MichiganFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.242, Mental Health Research GrantsPass-Through Grantor: Rutgers State UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.307, Minority Health and Health Disparities ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.310, Trans-NIH Research SupportPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.350, National Center for Advancing Translational SciencesPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.351, Research Infrastructure ProgramPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.361, Nursing ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.368, 21st Century Cures Act – Precision Medicine InitiativePass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.394, Cancer Detection and Diagnosis ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.395, Cancer Treatment ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.396, Cancer Biology ResearchPass-Through Grantor: Tulane University, Louisiana State UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.397, Cancer Centers Support GrantsPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.667, Social Services Block GrantPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.837, Cardiovascular Diseases ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.838, Lung Diseases ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.847, Diabetes, Digestive, and Kidney Diseases Extramural ResearchPass-Through Grantors: Northwestern University, Duke University, University of Washington, The Regents of University of MichiganFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.853, Extramural Research Programs in the Neurosciences and Neurological DisordersPass-Through Grantor: Rush University Medical CenterFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.855, Allergy, Immunology and Transplantation ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.859, Biomedical Research and Research TrainingPass-Through Grantor: University of Wisconsin – MadisonFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.865, Child Health and Human Development Extramural ResearchPass-Through Grantors: Northwestern University, University of Washington, The Regents of the University of CaliforniaFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.866, Aging ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.946, Cooperative Agreements to Support State-Based Safe Motherhood and Infant Health Initiative ProgramsPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.994, Maternal and Child Health Services Block Grant to the StatesPass-Through Grantor: Northwestern Memorial HospitalCriteria or specific requirement (including statutory, regulatory, or other citation):Section 200.303 of the Uniform Guidance states the following regarding internal control: “The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).”The Uniform Guidance 2 CFR section 200.510 states, “(b) Schedule of expenditures of Federal awards. The auditee must also prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended.”Condition:Certain grants related to the Research and Development Cluster were misstated by $233,405 on the preliminary schedule of expenditures of federal awards (the Schedule) provided by management due to the inappropriate classification of costs within the general ledger; the final Schedule was corrected.In addition, an award which was not a federal grant award with expenditures of $148,388 was included on the preliminary Schedule provided by management. The final Schedule was corrected.Cause:Endeavor’s internal controls in place over the preparation of the Schedule were not sufficient to properly accumulate and accurately report all expenditures of federal awards.Effect or Potential Effect:Inaccurate or improper reporting of expenditures results in a misstated Schedule and can also potentially result in insufficient testing of the major programs or improper identification of major programs for audit purposes.Questioned costs:None.Context:The table below reflects the preliminary and adjusted assistance listing balances on the Schedule (only assistance listing programs which changed are included below):Identification as a repeat finding, if applicable:The finding is not a repeat finding from the prior year.Recommendation:Management should implement internal controls to ensure amounts are appropriately accumulated and reported on the Schedule and all federal expenditures are appropriately identified and reported on the Schedule.Views of responsible officials:Award amounts were changed on the Schedule after management’s review was executed. Management acknowledges that implementing the new Enterprise Resource Planning (ERP) system, in 2023 presented changes to the SEFA reporting. Management has identified and addressed the reporting issues within the new system to ensure that the grant totals are appropriately captured in the SEFA.Endeavor will enhance grant management award processes by revising its procedures and adding additional controls to monitor for accuracy of the core data. Management will reinforce the importance of timeliness and accuracy of the Schedule reporting totals to facilitate accurate reporting.
Finding 2023-001 – ReportingInformation of the federal program:Federal Grantor: Department of Defense (DOD)Assistance Listing No.: 12.420, Military Medical Research and DevelopmentPass-Through Grantor: Johns Hopkins UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.172, Human Genome ResearchPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.226, Research on Healthcare Costs, Quality and OutcomesPass-Through Grantor: The Regents of the University of MichiganFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.242, Mental Health Research GrantsPass-Through Grantor: Rutgers State UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.307, Minority Health and Health Disparities ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.310, Trans-NIH Research SupportPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.350, National Center for Advancing Translational SciencesPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.351, Research Infrastructure ProgramPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.361, Nursing ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.368, 21st Century Cures Act – Precision Medicine InitiativePass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.394, Cancer Detection and Diagnosis ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.395, Cancer Treatment ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.396, Cancer Biology ResearchPass-Through Grantor: Tulane University, Louisiana State UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.397, Cancer Centers Support GrantsPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.667, Social Services Block GrantPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.837, Cardiovascular Diseases ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.838, Lung Diseases ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.847, Diabetes, Digestive, and Kidney Diseases Extramural ResearchPass-Through Grantors: Northwestern University, Duke University, University of Washington, The Regents of University of MichiganFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.853, Extramural Research Programs in the Neurosciences and Neurological DisordersPass-Through Grantor: Rush University Medical CenterFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.855, Allergy, Immunology and Transplantation ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.859, Biomedical Research and Research TrainingPass-Through Grantor: University of Wisconsin – MadisonFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.865, Child Health and Human Development Extramural ResearchPass-Through Grantors: Northwestern University, University of Washington, The Regents of the University of CaliforniaFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.866, Aging ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.946, Cooperative Agreements to Support State-Based Safe Motherhood and Infant Health Initiative ProgramsPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.994, Maternal and Child Health Services Block Grant to the StatesPass-Through Grantor: Northwestern Memorial HospitalCriteria or specific requirement (including statutory, regulatory, or other citation):Section 200.303 of the Uniform Guidance states the following regarding internal control: “The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).”The Uniform Guidance 2 CFR section 200.510 states, “(b) Schedule of expenditures of Federal awards. The auditee must also prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended.”Condition:Certain grants related to the Research and Development Cluster were misstated by $233,405 on the preliminary schedule of expenditures of federal awards (the Schedule) provided by management due to the inappropriate classification of costs within the general ledger; the final Schedule was corrected.In addition, an award which was not a federal grant award with expenditures of $148,388 was included on the preliminary Schedule provided by management. The final Schedule was corrected.Cause:Endeavor’s internal controls in place over the preparation of the Schedule were not sufficient to properly accumulate and accurately report all expenditures of federal awards.Effect or Potential Effect:Inaccurate or improper reporting of expenditures results in a misstated Schedule and can also potentially result in insufficient testing of the major programs or improper identification of major programs for audit purposes.Questioned costs:None.Context:The table below reflects the preliminary and adjusted assistance listing balances on the Schedule (only assistance listing programs which changed are included below):Identification as a repeat finding, if applicable:The finding is not a repeat finding from the prior year.Recommendation:Management should implement internal controls to ensure amounts are appropriately accumulated and reported on the Schedule and all federal expenditures are appropriately identified and reported on the Schedule.Views of responsible officials:Award amounts were changed on the Schedule after management’s review was executed. Management acknowledges that implementing the new Enterprise Resource Planning (ERP) system, in 2023 presented changes to the SEFA reporting. Management has identified and addressed the reporting issues within the new system to ensure that the grant totals are appropriately captured in the SEFA.Endeavor will enhance grant management award processes by revising its procedures and adding additional controls to monitor for accuracy of the core data. Management will reinforce the importance of timeliness and accuracy of the Schedule reporting totals to facilitate accurate reporting.
Finding 2023-001 – ReportingInformation of the federal program:Federal Grantor: Department of Defense (DOD)Assistance Listing No.: 12.420, Military Medical Research and DevelopmentPass-Through Grantor: Johns Hopkins UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.172, Human Genome ResearchPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.226, Research on Healthcare Costs, Quality and OutcomesPass-Through Grantor: The Regents of the University of MichiganFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.242, Mental Health Research GrantsPass-Through Grantor: Rutgers State UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.307, Minority Health and Health Disparities ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.310, Trans-NIH Research SupportPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.350, National Center for Advancing Translational SciencesPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.351, Research Infrastructure ProgramPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.361, Nursing ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.368, 21st Century Cures Act – Precision Medicine InitiativePass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.394, Cancer Detection and Diagnosis ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.395, Cancer Treatment ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.396, Cancer Biology ResearchPass-Through Grantor: Tulane University, Louisiana State UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.397, Cancer Centers Support GrantsPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.667, Social Services Block GrantPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.837, Cardiovascular Diseases ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.838, Lung Diseases ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.847, Diabetes, Digestive, and Kidney Diseases Extramural ResearchPass-Through Grantors: Northwestern University, Duke University, University of Washington, The Regents of University of MichiganFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.853, Extramural Research Programs in the Neurosciences and Neurological DisordersPass-Through Grantor: Rush University Medical CenterFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.855, Allergy, Immunology and Transplantation ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.859, Biomedical Research and Research TrainingPass-Through Grantor: University of Wisconsin – MadisonFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.865, Child Health and Human Development Extramural ResearchPass-Through Grantors: Northwestern University, University of Washington, The Regents of the University of CaliforniaFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.866, Aging ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.946, Cooperative Agreements to Support State-Based Safe Motherhood and Infant Health Initiative ProgramsPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.994, Maternal and Child Health Services Block Grant to the StatesPass-Through Grantor: Northwestern Memorial HospitalCriteria or specific requirement (including statutory, regulatory, or other citation):Section 200.303 of the Uniform Guidance states the following regarding internal control: “The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).”The Uniform Guidance 2 CFR section 200.510 states, “(b) Schedule of expenditures of Federal awards. The auditee must also prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended.”Condition:Certain grants related to the Research and Development Cluster were misstated by $233,405 on the preliminary schedule of expenditures of federal awards (the Schedule) provided by management due to the inappropriate classification of costs within the general ledger; the final Schedule was corrected.In addition, an award which was not a federal grant award with expenditures of $148,388 was included on the preliminary Schedule provided by management. The final Schedule was corrected.Cause:Endeavor’s internal controls in place over the preparation of the Schedule were not sufficient to properly accumulate and accurately report all expenditures of federal awards.Effect or Potential Effect:Inaccurate or improper reporting of expenditures results in a misstated Schedule and can also potentially result in insufficient testing of the major programs or improper identification of major programs for audit purposes.Questioned costs:None.Context:The table below reflects the preliminary and adjusted assistance listing balances on the Schedule (only assistance listing programs which changed are included below):Identification as a repeat finding, if applicable:The finding is not a repeat finding from the prior year.Recommendation:Management should implement internal controls to ensure amounts are appropriately accumulated and reported on the Schedule and all federal expenditures are appropriately identified and reported on the Schedule.Views of responsible officials:Award amounts were changed on the Schedule after management’s review was executed. Management acknowledges that implementing the new Enterprise Resource Planning (ERP) system, in 2023 presented changes to the SEFA reporting. Management has identified and addressed the reporting issues within the new system to ensure that the grant totals are appropriately captured in the SEFA.Endeavor will enhance grant management award processes by revising its procedures and adding additional controls to monitor for accuracy of the core data. Management will reinforce the importance of timeliness and accuracy of the Schedule reporting totals to facilitate accurate reporting.
Finding 2023-001 – ReportingInformation of the federal program:Federal Grantor: Department of Defense (DOD)Assistance Listing No.: 12.420, Military Medical Research and DevelopmentPass-Through Grantor: Johns Hopkins UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.172, Human Genome ResearchPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.226, Research on Healthcare Costs, Quality and OutcomesPass-Through Grantor: The Regents of the University of MichiganFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.242, Mental Health Research GrantsPass-Through Grantor: Rutgers State UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.307, Minority Health and Health Disparities ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.310, Trans-NIH Research SupportPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.350, National Center for Advancing Translational SciencesPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.351, Research Infrastructure ProgramPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.361, Nursing ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.368, 21st Century Cures Act – Precision Medicine InitiativePass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.394, Cancer Detection and Diagnosis ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.395, Cancer Treatment ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.396, Cancer Biology ResearchPass-Through Grantor: Tulane University, Louisiana State UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.397, Cancer Centers Support GrantsPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.667, Social Services Block GrantPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.837, Cardiovascular Diseases ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.838, Lung Diseases ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.847, Diabetes, Digestive, and Kidney Diseases Extramural ResearchPass-Through Grantors: Northwestern University, Duke University, University of Washington, The Regents of University of MichiganFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.853, Extramural Research Programs in the Neurosciences and Neurological DisordersPass-Through Grantor: Rush University Medical CenterFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.855, Allergy, Immunology and Transplantation ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.859, Biomedical Research and Research TrainingPass-Through Grantor: University of Wisconsin – MadisonFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.865, Child Health and Human Development Extramural ResearchPass-Through Grantors: Northwestern University, University of Washington, The Regents of the University of CaliforniaFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.866, Aging ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.946, Cooperative Agreements to Support State-Based Safe Motherhood and Infant Health Initiative ProgramsPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.994, Maternal and Child Health Services Block Grant to the StatesPass-Through Grantor: Northwestern Memorial HospitalCriteria or specific requirement (including statutory, regulatory, or other citation):Section 200.303 of the Uniform Guidance states the following regarding internal control: “The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).”The Uniform Guidance 2 CFR section 200.510 states, “(b) Schedule of expenditures of Federal awards. The auditee must also prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended.”Condition:Certain grants related to the Research and Development Cluster were misstated by $233,405 on the preliminary schedule of expenditures of federal awards (the Schedule) provided by management due to the inappropriate classification of costs within the general ledger; the final Schedule was corrected.In addition, an award which was not a federal grant award with expenditures of $148,388 was included on the preliminary Schedule provided by management. The final Schedule was corrected.Cause:Endeavor’s internal controls in place over the preparation of the Schedule were not sufficient to properly accumulate and accurately report all expenditures of federal awards.Effect or Potential Effect:Inaccurate or improper reporting of expenditures results in a misstated Schedule and can also potentially result in insufficient testing of the major programs or improper identification of major programs for audit purposes.Questioned costs:None.Context:The table below reflects the preliminary and adjusted assistance listing balances on the Schedule (only assistance listing programs which changed are included below):Identification as a repeat finding, if applicable:The finding is not a repeat finding from the prior year.Recommendation:Management should implement internal controls to ensure amounts are appropriately accumulated and reported on the Schedule and all federal expenditures are appropriately identified and reported on the Schedule.Views of responsible officials:Award amounts were changed on the Schedule after management’s review was executed. Management acknowledges that implementing the new Enterprise Resource Planning (ERP) system, in 2023 presented changes to the SEFA reporting. Management has identified and addressed the reporting issues within the new system to ensure that the grant totals are appropriately captured in the SEFA.Endeavor will enhance grant management award processes by revising its procedures and adding additional controls to monitor for accuracy of the core data. Management will reinforce the importance of timeliness and accuracy of the Schedule reporting totals to facilitate accurate reporting.
Finding 2023-001 – ReportingInformation of the federal program:Federal Grantor: Department of Defense (DOD)Assistance Listing No.: 12.420, Military Medical Research and DevelopmentPass-Through Grantor: Johns Hopkins UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.172, Human Genome ResearchPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.226, Research on Healthcare Costs, Quality and OutcomesPass-Through Grantor: The Regents of the University of MichiganFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.242, Mental Health Research GrantsPass-Through Grantor: Rutgers State UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.307, Minority Health and Health Disparities ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.310, Trans-NIH Research SupportPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.350, National Center for Advancing Translational SciencesPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.351, Research Infrastructure ProgramPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.361, Nursing ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.368, 21st Century Cures Act – Precision Medicine InitiativePass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.394, Cancer Detection and Diagnosis ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.395, Cancer Treatment ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.396, Cancer Biology ResearchPass-Through Grantor: Tulane University, Louisiana State UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.397, Cancer Centers Support GrantsPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.667, Social Services Block GrantPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.837, Cardiovascular Diseases ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.838, Lung Diseases ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.847, Diabetes, Digestive, and Kidney Diseases Extramural ResearchPass-Through Grantors: Northwestern University, Duke University, University of Washington, The Regents of University of MichiganFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.853, Extramural Research Programs in the Neurosciences and Neurological DisordersPass-Through Grantor: Rush University Medical CenterFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.855, Allergy, Immunology and Transplantation ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.859, Biomedical Research and Research TrainingPass-Through Grantor: University of Wisconsin – MadisonFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.865, Child Health and Human Development Extramural ResearchPass-Through Grantors: Northwestern University, University of Washington, The Regents of the University of CaliforniaFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.866, Aging ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.946, Cooperative Agreements to Support State-Based Safe Motherhood and Infant Health Initiative ProgramsPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.994, Maternal and Child Health Services Block Grant to the StatesPass-Through Grantor: Northwestern Memorial HospitalCriteria or specific requirement (including statutory, regulatory, or other citation):Section 200.303 of the Uniform Guidance states the following regarding internal control: “The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).”The Uniform Guidance 2 CFR section 200.510 states, “(b) Schedule of expenditures of Federal awards. The auditee must also prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended.”Condition:Certain grants related to the Research and Development Cluster were misstated by $233,405 on the preliminary schedule of expenditures of federal awards (the Schedule) provided by management due to the inappropriate classification of costs within the general ledger; the final Schedule was corrected.In addition, an award which was not a federal grant award with expenditures of $148,388 was included on the preliminary Schedule provided by management. The final Schedule was corrected.Cause:Endeavor’s internal controls in place over the preparation of the Schedule were not sufficient to properly accumulate and accurately report all expenditures of federal awards.Effect or Potential Effect:Inaccurate or improper reporting of expenditures results in a misstated Schedule and can also potentially result in insufficient testing of the major programs or improper identification of major programs for audit purposes.Questioned costs:None.Context:The table below reflects the preliminary and adjusted assistance listing balances on the Schedule (only assistance listing programs which changed are included below):Identification as a repeat finding, if applicable:The finding is not a repeat finding from the prior year.Recommendation:Management should implement internal controls to ensure amounts are appropriately accumulated and reported on the Schedule and all federal expenditures are appropriately identified and reported on the Schedule.Views of responsible officials:Award amounts were changed on the Schedule after management’s review was executed. Management acknowledges that implementing the new Enterprise Resource Planning (ERP) system, in 2023 presented changes to the SEFA reporting. Management has identified and addressed the reporting issues within the new system to ensure that the grant totals are appropriately captured in the SEFA.Endeavor will enhance grant management award processes by revising its procedures and adding additional controls to monitor for accuracy of the core data. Management will reinforce the importance of timeliness and accuracy of the Schedule reporting totals to facilitate accurate reporting.
Finding 2023-001 – ReportingInformation of the federal program:Federal Grantor: Department of Defense (DOD)Assistance Listing No.: 12.420, Military Medical Research and DevelopmentPass-Through Grantor: Johns Hopkins UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.172, Human Genome ResearchPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.226, Research on Healthcare Costs, Quality and OutcomesPass-Through Grantor: The Regents of the University of MichiganFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.242, Mental Health Research GrantsPass-Through Grantor: Rutgers State UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.307, Minority Health and Health Disparities ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.310, Trans-NIH Research SupportPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.350, National Center for Advancing Translational SciencesPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.351, Research Infrastructure ProgramPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.361, Nursing ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.368, 21st Century Cures Act – Precision Medicine InitiativePass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.394, Cancer Detection and Diagnosis ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.395, Cancer Treatment ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.396, Cancer Biology ResearchPass-Through Grantor: Tulane University, Louisiana State UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.397, Cancer Centers Support GrantsPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.667, Social Services Block GrantPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.837, Cardiovascular Diseases ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.838, Lung Diseases ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.847, Diabetes, Digestive, and Kidney Diseases Extramural ResearchPass-Through Grantors: Northwestern University, Duke University, University of Washington, The Regents of University of MichiganFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.853, Extramural Research Programs in the Neurosciences and Neurological DisordersPass-Through Grantor: Rush University Medical CenterFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.855, Allergy, Immunology and Transplantation ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.859, Biomedical Research and Research TrainingPass-Through Grantor: University of Wisconsin – MadisonFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.865, Child Health and Human Development Extramural ResearchPass-Through Grantors: Northwestern University, University of Washington, The Regents of the University of CaliforniaFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.866, Aging ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.946, Cooperative Agreements to Support State-Based Safe Motherhood and Infant Health Initiative ProgramsPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.994, Maternal and Child Health Services Block Grant to the StatesPass-Through Grantor: Northwestern Memorial HospitalCriteria or specific requirement (including statutory, regulatory, or other citation):Section 200.303 of the Uniform Guidance states the following regarding internal control: “The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).”The Uniform Guidance 2 CFR section 200.510 states, “(b) Schedule of expenditures of Federal awards. The auditee must also prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended.”Condition:Certain grants related to the Research and Development Cluster were misstated by $233,405 on the preliminary schedule of expenditures of federal awards (the Schedule) provided by management due to the inappropriate classification of costs within the general ledger; the final Schedule was corrected.In addition, an award which was not a federal grant award with expenditures of $148,388 was included on the preliminary Schedule provided by management. The final Schedule was corrected.Cause:Endeavor’s internal controls in place over the preparation of the Schedule were not sufficient to properly accumulate and accurately report all expenditures of federal awards.Effect or Potential Effect:Inaccurate or improper reporting of expenditures results in a misstated Schedule and can also potentially result in insufficient testing of the major programs or improper identification of major programs for audit purposes.Questioned costs:None.Context:The table below reflects the preliminary and adjusted assistance listing balances on the Schedule (only assistance listing programs which changed are included below):Identification as a repeat finding, if applicable:The finding is not a repeat finding from the prior year.Recommendation:Management should implement internal controls to ensure amounts are appropriately accumulated and reported on the Schedule and all federal expenditures are appropriately identified and reported on the Schedule.Views of responsible officials:Award amounts were changed on the Schedule after management’s review was executed. Management acknowledges that implementing the new Enterprise Resource Planning (ERP) system, in 2023 presented changes to the SEFA reporting. Management has identified and addressed the reporting issues within the new system to ensure that the grant totals are appropriately captured in the SEFA.Endeavor will enhance grant management award processes by revising its procedures and adding additional controls to monitor for accuracy of the core data. Management will reinforce the importance of timeliness and accuracy of the Schedule reporting totals to facilitate accurate reporting.
Finding 2023-001 – ReportingInformation of the federal program:Federal Grantor: Department of Defense (DOD)Assistance Listing No.: 12.420, Military Medical Research and DevelopmentPass-Through Grantor: Johns Hopkins UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.172, Human Genome ResearchPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.226, Research on Healthcare Costs, Quality and OutcomesPass-Through Grantor: The Regents of the University of MichiganFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.242, Mental Health Research GrantsPass-Through Grantor: Rutgers State UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.307, Minority Health and Health Disparities ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.310, Trans-NIH Research SupportPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.350, National Center for Advancing Translational SciencesPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.351, Research Infrastructure ProgramPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.361, Nursing ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.368, 21st Century Cures Act – Precision Medicine InitiativePass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.394, Cancer Detection and Diagnosis ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.395, Cancer Treatment ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.396, Cancer Biology ResearchPass-Through Grantor: Tulane University, Louisiana State UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.397, Cancer Centers Support GrantsPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.667, Social Services Block GrantPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.837, Cardiovascular Diseases ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.838, Lung Diseases ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.847, Diabetes, Digestive, and Kidney Diseases Extramural ResearchPass-Through Grantors: Northwestern University, Duke University, University of Washington, The Regents of University of MichiganFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.853, Extramural Research Programs in the Neurosciences and Neurological DisordersPass-Through Grantor: Rush University Medical CenterFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.855, Allergy, Immunology and Transplantation ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.859, Biomedical Research and Research TrainingPass-Through Grantor: University of Wisconsin – MadisonFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.865, Child Health and Human Development Extramural ResearchPass-Through Grantors: Northwestern University, University of Washington, The Regents of the University of CaliforniaFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.866, Aging ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.946, Cooperative Agreements to Support State-Based Safe Motherhood and Infant Health Initiative ProgramsPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.994, Maternal and Child Health Services Block Grant to the StatesPass-Through Grantor: Northwestern Memorial HospitalCriteria or specific requirement (including statutory, regulatory, or other citation):Section 200.303 of the Uniform Guidance states the following regarding internal control: “The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).”The Uniform Guidance 2 CFR section 200.510 states, “(b) Schedule of expenditures of Federal awards. The auditee must also prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended.”Condition:Certain grants related to the Research and Development Cluster were misstated by $233,405 on the preliminary schedule of expenditures of federal awards (the Schedule) provided by management due to the inappropriate classification of costs within the general ledger; the final Schedule was corrected.In addition, an award which was not a federal grant award with expenditures of $148,388 was included on the preliminary Schedule provided by management. The final Schedule was corrected.Cause:Endeavor’s internal controls in place over the preparation of the Schedule were not sufficient to properly accumulate and accurately report all expenditures of federal awards.Effect or Potential Effect:Inaccurate or improper reporting of expenditures results in a misstated Schedule and can also potentially result in insufficient testing of the major programs or improper identification of major programs for audit purposes.Questioned costs:None.Context:The table below reflects the preliminary and adjusted assistance listing balances on the Schedule (only assistance listing programs which changed are included below):Identification as a repeat finding, if applicable:The finding is not a repeat finding from the prior year.Recommendation:Management should implement internal controls to ensure amounts are appropriately accumulated and reported on the Schedule and all federal expenditures are appropriately identified and reported on the Schedule.Views of responsible officials:Award amounts were changed on the Schedule after management’s review was executed. Management acknowledges that implementing the new Enterprise Resource Planning (ERP) system, in 2023 presented changes to the SEFA reporting. Management has identified and addressed the reporting issues within the new system to ensure that the grant totals are appropriately captured in the SEFA.Endeavor will enhance grant management award processes by revising its procedures and adding additional controls to monitor for accuracy of the core data. Management will reinforce the importance of timeliness and accuracy of the Schedule reporting totals to facilitate accurate reporting.
Finding 2023-001 – ReportingInformation of the federal program:Federal Grantor: Department of Defense (DOD)Assistance Listing No.: 12.420, Military Medical Research and DevelopmentPass-Through Grantor: Johns Hopkins UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.172, Human Genome ResearchPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.226, Research on Healthcare Costs, Quality and OutcomesPass-Through Grantor: The Regents of the University of MichiganFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.242, Mental Health Research GrantsPass-Through Grantor: Rutgers State UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.307, Minority Health and Health Disparities ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.310, Trans-NIH Research SupportPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.350, National Center for Advancing Translational SciencesPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.351, Research Infrastructure ProgramPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.361, Nursing ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.368, 21st Century Cures Act – Precision Medicine InitiativePass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.394, Cancer Detection and Diagnosis ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.395, Cancer Treatment ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.396, Cancer Biology ResearchPass-Through Grantor: Tulane University, Louisiana State UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.397, Cancer Centers Support GrantsPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.667, Social Services Block GrantPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.837, Cardiovascular Diseases ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.838, Lung Diseases ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.847, Diabetes, Digestive, and Kidney Diseases Extramural ResearchPass-Through Grantors: Northwestern University, Duke University, University of Washington, The Regents of University of MichiganFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.853, Extramural Research Programs in the Neurosciences and Neurological DisordersPass-Through Grantor: Rush University Medical CenterFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.855, Allergy, Immunology and Transplantation ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.859, Biomedical Research and Research TrainingPass-Through Grantor: University of Wisconsin – MadisonFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.865, Child Health and Human Development Extramural ResearchPass-Through Grantors: Northwestern University, University of Washington, The Regents of the University of CaliforniaFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.866, Aging ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.946, Cooperative Agreements to Support State-Based Safe Motherhood and Infant Health Initiative ProgramsPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.994, Maternal and Child Health Services Block Grant to the StatesPass-Through Grantor: Northwestern Memorial HospitalCriteria or specific requirement (including statutory, regulatory, or other citation):Section 200.303 of the Uniform Guidance states the following regarding internal control: “The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).”The Uniform Guidance 2 CFR section 200.510 states, “(b) Schedule of expenditures of Federal awards. The auditee must also prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended.”Condition:Certain grants related to the Research and Development Cluster were misstated by $233,405 on the preliminary schedule of expenditures of federal awards (the Schedule) provided by management due to the inappropriate classification of costs within the general ledger; the final Schedule was corrected.In addition, an award which was not a federal grant award with expenditures of $148,388 was included on the preliminary Schedule provided by management. The final Schedule was corrected.Cause:Endeavor’s internal controls in place over the preparation of the Schedule were not sufficient to properly accumulate and accurately report all expenditures of federal awards.Effect or Potential Effect:Inaccurate or improper reporting of expenditures results in a misstated Schedule and can also potentially result in insufficient testing of the major programs or improper identification of major programs for audit purposes.Questioned costs:None.Context:The table below reflects the preliminary and adjusted assistance listing balances on the Schedule (only assistance listing programs which changed are included below):Identification as a repeat finding, if applicable:The finding is not a repeat finding from the prior year.Recommendation:Management should implement internal controls to ensure amounts are appropriately accumulated and reported on the Schedule and all federal expenditures are appropriately identified and reported on the Schedule.Views of responsible officials:Award amounts were changed on the Schedule after management’s review was executed. Management acknowledges that implementing the new Enterprise Resource Planning (ERP) system, in 2023 presented changes to the SEFA reporting. Management has identified and addressed the reporting issues within the new system to ensure that the grant totals are appropriately captured in the SEFA.Endeavor will enhance grant management award processes by revising its procedures and adding additional controls to monitor for accuracy of the core data. Management will reinforce the importance of timeliness and accuracy of the Schedule reporting totals to facilitate accurate reporting.
Finding 2023-001 – ReportingInformation of the federal program:Federal Grantor: Department of Defense (DOD)Assistance Listing No.: 12.420, Military Medical Research and DevelopmentPass-Through Grantor: Johns Hopkins UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.172, Human Genome ResearchPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.226, Research on Healthcare Costs, Quality and OutcomesPass-Through Grantor: The Regents of the University of MichiganFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.242, Mental Health Research GrantsPass-Through Grantor: Rutgers State UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.307, Minority Health and Health Disparities ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.310, Trans-NIH Research SupportPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.350, National Center for Advancing Translational SciencesPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.351, Research Infrastructure ProgramPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.361, Nursing ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.368, 21st Century Cures Act – Precision Medicine InitiativePass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.394, Cancer Detection and Diagnosis ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.395, Cancer Treatment ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.396, Cancer Biology ResearchPass-Through Grantor: Tulane University, Louisiana State UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.397, Cancer Centers Support GrantsPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.667, Social Services Block GrantPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.837, Cardiovascular Diseases ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.838, Lung Diseases ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.847, Diabetes, Digestive, and Kidney Diseases Extramural ResearchPass-Through Grantors: Northwestern University, Duke University, University of Washington, The Regents of University of MichiganFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.853, Extramural Research Programs in the Neurosciences and Neurological DisordersPass-Through Grantor: Rush University Medical CenterFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.855, Allergy, Immunology and Transplantation ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.859, Biomedical Research and Research TrainingPass-Through Grantor: University of Wisconsin – MadisonFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.865, Child Health and Human Development Extramural ResearchPass-Through Grantors: Northwestern University, University of Washington, The Regents of the University of CaliforniaFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.866, Aging ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.946, Cooperative Agreements to Support State-Based Safe Motherhood and Infant Health Initiative ProgramsPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.994, Maternal and Child Health Services Block Grant to the StatesPass-Through Grantor: Northwestern Memorial HospitalCriteria or specific requirement (including statutory, regulatory, or other citation):Section 200.303 of the Uniform Guidance states the following regarding internal control: “The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).”The Uniform Guidance 2 CFR section 200.510 states, “(b) Schedule of expenditures of Federal awards. The auditee must also prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended.”Condition:Certain grants related to the Research and Development Cluster were misstated by $233,405 on the preliminary schedule of expenditures of federal awards (the Schedule) provided by management due to the inappropriate classification of costs within the general ledger; the final Schedule was corrected.In addition, an award which was not a federal grant award with expenditures of $148,388 was included on the preliminary Schedule provided by management. The final Schedule was corrected.Cause:Endeavor’s internal controls in place over the preparation of the Schedule were not sufficient to properly accumulate and accurately report all expenditures of federal awards.Effect or Potential Effect:Inaccurate or improper reporting of expenditures results in a misstated Schedule and can also potentially result in insufficient testing of the major programs or improper identification of major programs for audit purposes.Questioned costs:None.Context:The table below reflects the preliminary and adjusted assistance listing balances on the Schedule (only assistance listing programs which changed are included below):Identification as a repeat finding, if applicable:The finding is not a repeat finding from the prior year.Recommendation:Management should implement internal controls to ensure amounts are appropriately accumulated and reported on the Schedule and all federal expenditures are appropriately identified and reported on the Schedule.Views of responsible officials:Award amounts were changed on the Schedule after management’s review was executed. Management acknowledges that implementing the new Enterprise Resource Planning (ERP) system, in 2023 presented changes to the SEFA reporting. Management has identified and addressed the reporting issues within the new system to ensure that the grant totals are appropriately captured in the SEFA.Endeavor will enhance grant management award processes by revising its procedures and adding additional controls to monitor for accuracy of the core data. Management will reinforce the importance of timeliness and accuracy of the Schedule reporting totals to facilitate accurate reporting.
Finding 2023-001 – ReportingInformation of the federal program:Federal Grantor: Department of Defense (DOD)Assistance Listing No.: 12.420, Military Medical Research and DevelopmentPass-Through Grantor: Johns Hopkins UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.172, Human Genome ResearchPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.226, Research on Healthcare Costs, Quality and OutcomesPass-Through Grantor: The Regents of the University of MichiganFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.242, Mental Health Research GrantsPass-Through Grantor: Rutgers State UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.307, Minority Health and Health Disparities ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.310, Trans-NIH Research SupportPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.350, National Center for Advancing Translational SciencesPass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.351, Research Infrastructure ProgramPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.361, Nursing ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.368, 21st Century Cures Act – Precision Medicine InitiativePass-Through Grantor: University of ChicagoFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.394, Cancer Detection and Diagnosis ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.395, Cancer Treatment ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.396, Cancer Biology ResearchPass-Through Grantor: Tulane University, Louisiana State UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.397, Cancer Centers Support GrantsPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.667, Social Services Block GrantPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.837, Cardiovascular Diseases ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.838, Lung Diseases ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.847, Diabetes, Digestive, and Kidney Diseases Extramural ResearchPass-Through Grantors: Northwestern University, Duke University, University of Washington, The Regents of University of MichiganFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.853, Extramural Research Programs in the Neurosciences and Neurological DisordersPass-Through Grantor: Rush University Medical CenterFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.855, Allergy, Immunology and Transplantation ResearchPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.859, Biomedical Research and Research TrainingPass-Through Grantor: University of Wisconsin – MadisonFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.865, Child Health and Human Development Extramural ResearchPass-Through Grantors: Northwestern University, University of Washington, The Regents of the University of CaliforniaFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.866, Aging ResearchFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.946, Cooperative Agreements to Support State-Based Safe Motherhood and Infant Health Initiative ProgramsPass-Through Grantor: Northwestern UniversityFederal Grantor: United States Department of Health and Human Services (HHS)Assistance Listing No.: 93.994, Maternal and Child Health Services Block Grant to the StatesPass-Through Grantor: Northwestern Memorial HospitalCriteria or specific requirement (including statutory, regulatory, or other citation):Section 200.303 of the Uniform Guidance states the following regarding internal control: “The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).”The Uniform Guidance 2 CFR section 200.510 states, “(b) Schedule of expenditures of Federal awards. The auditee must also prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended.”Condition:Certain grants related to the Research and Development Cluster were misstated by $233,405 on the preliminary schedule of expenditures of federal awards (the Schedule) provided by management due to the inappropriate classification of costs within the general ledger; the final Schedule was corrected.In addition, an award which was not a federal grant award with expenditures of $148,388 was included on the preliminary Schedule provided by management. The final Schedule was corrected.Cause:Endeavor’s internal controls in place over the preparation of the Schedule were not sufficient to properly accumulate and accurately report all expenditures of federal awards.Effect or Potential Effect:Inaccurate or improper reporting of expenditures results in a misstated Schedule and can also potentially result in insufficient testing of the major programs or improper identification of major programs for audit purposes.Questioned costs:None.Context:The table below reflects the preliminary and adjusted assistance listing balances on the Schedule (only assistance listing programs which changed are included below):Identification as a repeat finding, if applicable:The finding is not a repeat finding from the prior year.Recommendation:Management should implement internal controls to ensure amounts are appropriately accumulated and reported on the Schedule and all federal expenditures are appropriately identified and reported on the Schedule.Views of responsible officials:Award amounts were changed on the Schedule after management’s review was executed. Management acknowledges that implementing the new Enterprise Resource Planning (ERP) system, in 2023 presented changes to the SEFA reporting. Management has identified and addressed the reporting issues within the new system to ensure that the grant totals are appropriately captured in the SEFA.Endeavor will enhance grant management award processes by revising its procedures and adding additional controls to monitor for accuracy of the core data. Management will reinforce the importance of timeliness and accuracy of the Schedule reporting totals to facilitate accurate reporting.