Finding 2023-001 – Reporting Information of the federal program: Federal Grantor: Department of Defense (DOD) Assistance Listing No.: 12.420, Military Medical Research and Development Pass-Through Grantor: Johns Hopkins University Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.172, Human Genome Research Pass-Through Grantor: University of Chicago Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.226, Research on Healthcare Costs, Quality and Outcomes Pass-Through Grantor: The Regents of the University of Michigan Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.242, Mental Health Research Grants Pass-Through Grantor: Rutgers State University Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.307, Minority Health and Health Disparities Research Pass-Through Grantor: Northwestern University Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.310, Trans-NIH Research Support Pass-Through Grantor: University of Chicago Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.350, National Center for Advancing Translational Sciences Pass-Through Grantor: University of Chicago Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.351, Research Infrastructure Program Pass-Through Grantor: Northwestern University Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.361, Nursing Research Pass-Through Grantor: Northwestern University Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.368, 21st Century Cures Act – Precision Medicine Initiative Pass-Through Grantor: University of Chicago Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.394, Cancer Detection and Diagnosis Research Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.395, Cancer Treatment Research Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.396, Cancer Biology Research Pass-Through Grantor: Tulane University, Louisiana State University Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.397, Cancer Centers Support Grants Pass-Through Grantor: Northwestern University Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.667, Social Services Block Grant Pass-Through Grantor: Northwestern University Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.837, Cardiovascular Diseases Research Pass-Through Grantor: Northwestern University Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.838, Lung Diseases Research Pass-Through Grantor: Northwestern University Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.847, Diabetes, Digestive, and Kidney Diseases Extramural Research Pass-Through Grantors: Northwestern University, Duke University, University of Washington, The Regents of University of Michigan Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.853, Extramural Research Programs in the Neurosciences and Neurological Disorders Pass-Through Grantor: Rush University Medical Center Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.855, Allergy, Immunology and Transplantation Research Pass-Through Grantor: Northwestern University Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.859, Biomedical Research and Research Training Pass-Through Grantor: University of Wisconsin – Madison Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.865, Child Health and Human Development Extramural Research Pass-Through Grantors: Northwestern University, University of Washington, The Regents of the University of California Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.866, Aging Research Federal 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 Programs Pass-Through Grantor: Northwestern University Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.994, Maternal and Child Health Services Block Grant to the States Pass-Through Grantor: Northwestern Memorial Hospital Criteria or specific requirement (including statutory, regulatory, or other citation): Section 200.303 of the Uniform Guidance states the following regarding internal control: “The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).” The Uniform Guidance 2 CFR section 200.510 states, “(b) Schedule of expenditures of Federal awards. The auditee must also prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended.” Condition: 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 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): Assistance Listing No. Name of Federal Program Preliminary Schedule Adjusted Schedule Change 12.420 Military Medical Research and Development $ 241,025 $ 224,418 $ 16,607 93.172 Human Genome Research 14,874 15,121 (247) 93.226 Research on Healthcare Costs, Quality and Outcomes 251,325 248,842 2,483 93.242 Mental Health Research Grants 1,616,503 1,617,376 (873) 93.307 Minority Health and Health Disparities Research 17,323 15,122 2,201 93.310 Trans-NIH Research Support 313,459 313,490 (31) 93.350 National Center for Advancing Translational Sciences 516,734 518,429 (1,695) 93.351 Research Infrastructure Program 242,436 232,058 10,378 93.361 Nursing Research 8,745 7,645 1,100 93.368 21st Century Cures Act – Precision Medicine Initiative 100,324 94,609 5,715 93.394 Cancer Detection and Diagnosis Research 847,959 816,528 31,431 93.395 Cancer Treatment Research 438,349 439,286 (937) 93.396 Cancer Biology Research 93,919 88,642 5,277 93.397 Cancer Centers Support Grants 15,552 14,078 1,474 93.667 Social Services Block Grant 19,619 27,170 (7,551) 93.837 Cardiovascular Diseases Research 193,160 188,850 4,310 93.838 Lung Diseases Research 482,934 471,427 11,507 93.847 Diabetes, Digestive, and Kidney Diseases Extramural Research 1,075,493 1,035,041 40,452 93.853 Extramural Research Programs in the Neurosciences and Neurological Disorders 1,645,025 1,596,611 48,414 93.855 Allergy, Immunology and Transplantation Research 73,869 72,630 1,239 93.859 Biomedical Research and Research Training 363,336 366,791 (3,455) 93.865 Child Health and Human Development Extramural Research 3,790,797 3,733,008 57,789 93.866 Aging Research 1,101,363 1,098,891 2,472 93.946 Cooperative Agreements to Support State-Based Safe Motherhood and Infant Health Initiative Programs 80,039 78,033 2,006 93.994 Maternal and Child Health Services Block Grant to the States 171,995 168,656 3,339 The Role of Oral Care in Nonventilator Hospital-Acquired Pneumonia (NVHAP) Prevention 148,388 – 148,388 Total $ 13,864,545 $ 13,482,752 $ 381,793 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 – Reporting Information of the federal program: Federal Grantor: Department of Defense (DOD) Assistance Listing No.: 12.420, Military Medical Research and Development Pass-Through Grantor: Johns Hopkins University Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.172, Human Genome Research Pass-Through Grantor: University of Chicago Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.226, Research on Healthcare Costs, Quality and Outcomes Pass-Through Grantor: The Regents of the University of Michigan Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.242, Mental Health Research Grants Pass-Through Grantor: Rutgers State University Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.307, Minority Health and Health Disparities Research Pass-Through Grantor: Northwestern University Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.310, Trans-NIH Research Support Pass-Through Grantor: University of Chicago Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.350, National Center for Advancing Translational Sciences Pass-Through Grantor: University of Chicago Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.351, Research Infrastructure Program Pass-Through Grantor: Northwestern University Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.361, Nursing Research Pass-Through Grantor: Northwestern University Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.368, 21st Century Cures Act – Precision Medicine Initiative Pass-Through Grantor: University of Chicago Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.394, Cancer Detection and Diagnosis Research Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.395, Cancer Treatment Research Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.396, Cancer Biology Research Pass-Through Grantor: Tulane University, Louisiana State University Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.397, Cancer Centers Support Grants Pass-Through Grantor: Northwestern University Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.667, Social Services Block Grant Pass-Through Grantor: Northwestern University Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.837, Cardiovascular Diseases Research Pass-Through Grantor: Northwestern University Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.838, Lung Diseases Research Pass-Through Grantor: Northwestern University Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.847, Diabetes, Digestive, and Kidney Diseases Extramural Research Pass-Through Grantors: Northwestern University, Duke University, University of Washington, The Regents of University of Michigan Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.853, Extramural Research Programs in the Neurosciences and Neurological Disorders Pass-Through Grantor: Rush University Medical Center Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.855, Allergy, Immunology and Transplantation Research Pass-Through Grantor: Northwestern University Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.859, Biomedical Research and Research Training Pass-Through Grantor: University of Wisconsin – Madison Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.865, Child Health and Human Development Extramural Research Pass-Through Grantors: Northwestern University, University of Washington, The Regents of the University of California Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.866, Aging Research Federal 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 Programs Pass-Through Grantor: Northwestern University Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.994, Maternal and Child Health Services Block Grant to the States Pass-Through Grantor: Northwestern Memorial Hospital Criteria or specific requirement (including statutory, regulatory, or other citation): Section 200.303 of the Uniform Guidance states the following regarding internal control: “The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).” The Uniform Guidance 2 CFR section 200.510 states, “(b) Schedule of expenditures of Federal awards. The auditee must also prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended.” Condition: 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 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): Assistance Listing No. Name of Federal Program Preliminary Schedule Adjusted Schedule Change 12.420 Military Medical Research and Development $ 241,025 $ 224,418 $ 16,607 93.172 Human Genome Research 14,874 15,121 (247) 93.226 Research on Healthcare Costs, Quality and Outcomes 251,325 248,842 2,483 93.242 Mental Health Research Grants 1,616,503 1,617,376 (873) 93.307 Minority Health and Health Disparities Research 17,323 15,122 2,201 93.310 Trans-NIH Research Support 313,459 313,490 (31) 93.350 National Center for Advancing Translational Sciences 516,734 518,429 (1,695) 93.351 Research Infrastructure Program 242,436 232,058 10,378 93.361 Nursing Research 8,745 7,645 1,100 93.368 21st Century Cures Act – Precision Medicine Initiative 100,324 94,609 5,715 93.394 Cancer Detection and Diagnosis Research 847,959 816,528 31,431 93.395 Cancer Treatment Research 438,349 439,286 (937) 93.396 Cancer Biology Research 93,919 88,642 5,277 93.397 Cancer Centers Support Grants 15,552 14,078 1,474 93.667 Social Services Block Grant 19,619 27,170 (7,551) 93.837 Cardiovascular Diseases Research 193,160 188,850 4,310 93.838 Lung Diseases Research 482,934 471,427 11,507 93.847 Diabetes, Digestive, and Kidney Diseases Extramural Research 1,075,493 1,035,041 40,452 93.853 Extramural Research Programs in the Neurosciences and Neurological Disorders 1,645,025 1,596,611 48,414 93.855 Allergy, Immunology and Transplantation Research 73,869 72,630 1,239 93.859 Biomedical Research and Research Training 363,336 366,791 (3,455) 93.865 Child Health and Human Development Extramural Research 3,790,797 3,733,008 57,789 93.866 Aging Research 1,101,363 1,098,891 2,472 93.946 Cooperative Agreements to Support State-Based Safe Motherhood and Infant Health Initiative Programs 80,039 78,033 2,006 93.994 Maternal and Child Health Services Block Grant to the States 171,995 168,656 3,339 The Role of Oral Care in Nonventilator Hospital-Acquired Pneumonia (NVHAP) Prevention 148,388 – 148,388 Total $ 13,864,545 $ 13,482,752 $ 381,793 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 – Reporting Information of the federal program: Federal Grantor: Department of Defense (DOD) Assistance Listing No.: 12.420, Military Medical Research and Development Pass-Through Grantor: Johns Hopkins University Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.172, Human Genome Research Pass-Through Grantor: University of Chicago Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.226, Research on Healthcare Costs, Quality and Outcomes Pass-Through Grantor: The Regents of the University of Michigan Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.242, Mental Health Research Grants Pass-Through Grantor: Rutgers State University Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.307, Minority Health and Health Disparities Research Pass-Through Grantor: Northwestern University Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.310, Trans-NIH Research Support Pass-Through Grantor: University of Chicago Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.350, National Center for Advancing Translational Sciences Pass-Through Grantor: University of Chicago Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.351, Research Infrastructure Program Pass-Through Grantor: Northwestern University Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.361, Nursing Research Pass-Through Grantor: Northwestern University Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.368, 21st Century Cures Act – Precision Medicine Initiative Pass-Through Grantor: University of Chicago Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.394, Cancer Detection and Diagnosis Research Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.395, Cancer Treatment Research Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.396, Cancer Biology Research Pass-Through Grantor: Tulane University, Louisiana State University Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.397, Cancer Centers Support Grants Pass-Through Grantor: Northwestern University Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.667, Social Services Block Grant Pass-Through Grantor: Northwestern University Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.837, Cardiovascular Diseases Research Pass-Through Grantor: Northwestern University Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.838, Lung Diseases Research Pass-Through Grantor: Northwestern University Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.847, Diabetes, Digestive, and Kidney Diseases Extramural Research Pass-Through Grantors: Northwestern University, Duke University, University of Washington, The Regents of University of Michigan Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.853, Extramural Research Programs in the Neurosciences and Neurological Disorders Pass-Through Grantor: Rush University Medical Center Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.855, Allergy, Immunology and Transplantation Research Pass-Through Grantor: Northwestern University Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.859, Biomedical Research and Research Training Pass-Through Grantor: University of Wisconsin – Madison Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.865, Child Health and Human Development Extramural Research Pass-Through Grantors: Northwestern University, University of Washington, The Regents of the University of California Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.866, Aging Research Federal 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 Programs Pass-Through Grantor: Northwestern University Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.994, Maternal and Child Health Services Block Grant to the States Pass-Through Grantor: Northwestern Memorial Hospital Criteria or specific requirement (including statutory, regulatory, or other citation): Section 200.303 of the Uniform Guidance states the following regarding internal control: “The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).” The Uniform Guidance 2 CFR section 200.510 states, “(b) Schedule of expenditures of Federal awards. The auditee must also prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended.” Condition: 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 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): Assistance Listing No. Name of Federal Program Preliminary Schedule Adjusted Schedule Change 12.420 Military Medical Research and Development $ 241,025 $ 224,418 $ 16,607 93.172 Human Genome Research 14,874 15,121 (247) 93.226 Research on Healthcare Costs, Quality and Outcomes 251,325 248,842 2,483 93.242 Mental Health Research Grants 1,616,503 1,617,376 (873) 93.307 Minority Health and Health Disparities Research 17,323 15,122 2,201 93.310 Trans-NIH Research Support 313,459 313,490 (31) 93.350 National Center for Advancing Translational Sciences 516,734 518,429 (1,695) 93.351 Research Infrastructure Program 242,436 232,058 10,378 93.361 Nursing Research 8,745 7,645 1,100 93.368 21st Century Cures Act – Precision Medicine Initiative 100,324 94,609 5,715 93.394 Cancer Detection and Diagnosis Research 847,959 816,528 31,431 93.395 Cancer Treatment Research 438,349 439,286 (937) 93.396 Cancer Biology Research 93,919 88,642 5,277 93.397 Cancer Centers Support Grants 15,552 14,078 1,474 93.667 Social Services Block Grant 19,619 27,170 (7,551) 93.837 Cardiovascular Diseases Research 193,160 188,850 4,310 93.838 Lung Diseases Research 482,934 471,427 11,507 93.847 Diabetes, Digestive, and Kidney Diseases Extramural Research 1,075,493 1,035,041 40,452 93.853 Extramural Research Programs in the Neurosciences and Neurological Disorders 1,645,025 1,596,611 48,414 93.855 Allergy, Immunology and Transplantation Research 73,869 72,630 1,239 93.859 Biomedical Research and Research Training 363,336 366,791 (3,455) 93.865 Child Health and Human Development Extramural Research 3,790,797 3,733,008 57,789 93.866 Aging Research 1,101,363 1,098,891 2,472 93.946 Cooperative Agreements to Support State-Based Safe Motherhood and Infant Health Initiative Programs 80,039 78,033 2,006 93.994 Maternal and Child Health Services Block Grant to the States 171,995 168,656 3,339 The Role of Oral Care in Nonventilator Hospital-Acquired Pneumonia (NVHAP) Prevention 148,388 – 148,388 Total $ 13,864,545 $ 13,482,752 $ 381,793 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 – Reporting Information of the federal program: Federal Grantor: Department of Defense (DOD) Assistance Listing No.: 12.420, Military Medical Research and Development Pass-Through Grantor: Johns Hopkins University Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.172, Human Genome Research Pass-Through Grantor: University of Chicago Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.226, Research on Healthcare Costs, Quality and Outcomes Pass-Through Grantor: The Regents of the University of Michigan Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.242, Mental Health Research Grants Pass-Through Grantor: Rutgers State University Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.307, Minority Health and Health Disparities Research Pass-Through Grantor: Northwestern University Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.310, Trans-NIH Research Support Pass-Through Grantor: University of Chicago Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.350, National Center for Advancing Translational Sciences Pass-Through Grantor: University of Chicago Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.351, Research Infrastructure Program Pass-Through Grantor: Northwestern University Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.361, Nursing Research Pass-Through Grantor: Northwestern University Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.368, 21st Century Cures Act – Precision Medicine Initiative Pass-Through Grantor: University of Chicago Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.394, Cancer Detection and Diagnosis Research Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.395, Cancer Treatment Research Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.396, Cancer Biology Research Pass-Through Grantor: Tulane University, Louisiana State University Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.397, Cancer Centers Support Grants Pass-Through Grantor: Northwestern University Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.667, Social Services Block Grant Pass-Through Grantor: Northwestern University Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.837, Cardiovascular Diseases Research Pass-Through Grantor: Northwestern University Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.838, Lung Diseases Research Pass-Through Grantor: Northwestern University Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.847, Diabetes, Digestive, and Kidney Diseases Extramural Research Pass-Through Grantors: Northwestern University, Duke University, University of Washington, The Regents of University of Michigan Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.853, Extramural Research Programs in the Neurosciences and Neurological Disorders Pass-Through Grantor: Rush University Medical Center Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.855, Allergy, Immunology and Transplantation Research Pass-Through Grantor: Northwestern University Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.859, Biomedical Research and Research Training Pass-Through Grantor: University of Wisconsin – Madison Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.865, Child Health and Human Development Extramural Research Pass-Through Grantors: Northwestern University, University of Washington, The Regents of the University of California Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.866, Aging Research Federal 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 Programs Pass-Through Grantor: Northwestern University Federal Grantor: United States Department of Health and Human Services (HHS) Assistance Listing No.: 93.994, Maternal and Child Health Services Block Grant to the States Pass-Through Grantor: Northwestern Memorial Hospital Criteria or specific requirement (including statutory, regulatory, or other citation): Section 200.303 of the Uniform Guidance states the following regarding internal control: “The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).” The Uniform Guidance 2 CFR section 200.510 states, “(b) Schedule of expenditures of Federal awards. The auditee must also prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended.” Condition: 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 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): Assistance Listing No. Name of Federal Program Preliminary Schedule Adjusted Schedule Change 12.420 Military Medical Research and Development $ 241,025 $ 224,418 $ 16,607 93.172 Human Genome Research 14,874 15,121 (247) 93.226 Research on Healthcare Costs, Quality and Outcomes 251,325 248,842 2,483 93.242 Mental Health Research Grants 1,616,503 1,617,376 (873) 93.307 Minority Health and Health Disparities Research 17,323 15,122 2,201 93.310 Trans-NIH Research Support 313,459 313,490 (31) 93.350 National Center for Advancing Translational Sciences 516,734 518,429 (1,695) 93.351 Research Infrastructure Program 242,436 232,058 10,378 93.361 Nursing Research 8,745 7,645 1,100 93.368 21st Century Cures Act – Precision Medicine Initiative 100,324 94,609 5,715 93.394 Cancer Detection and Diagnosis Research 847,959 816,528 31,431 93.395 Cancer Treatment Research 438,349 439,286 (937) 93.396 Cancer Biology Research 93,919 88,642 5,277 93.397 Cancer Centers Support Grants 15,552 14,078 1,474 93.667 Social Services Block Grant 19,619 27,170 (7,551) 93.837 Cardiovascular Diseases Research 193,160 188,850 4,310 93.838 Lung Diseases Research 482,934 471,427 11,507 93.847 Diabetes, Digestive, and Kidney Diseases Extramural Research 1,075,493 1,035,041 40,452 93.853 Extramural Research Programs in the Neurosciences and Neurological Disorders 1,645,025 1,596,611 48,414 93.855 Allergy, Immunology and Transplantation Research 73,869 72,630 1,239 93.859 Biomedical Research and Research Training 363,336 366,791 (3,455) 93.865 Child Health and Human Development Extramural Research 3,790,797 3,733,008 57,789 93.866 Aging Research 1,101,363 1,098,891 2,472 93.946 Cooperative Agreements to Support State-Based Safe Motherhood and Infant Health Initiative Programs 80,039 78,033 2,006 93.994 Maternal and Child Health Services Block Grant to the States 171,995 168,656 3,339 The Role of Oral Care in Nonventilator Hospital-Acquired Pneumonia (NVHAP) Prevention 148,388 – 148,388 Total $ 13,864,545 $ 13,482,752 $ 381,793 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-002 – SEFA Reporting Federal Program: COVID-19 Coronavirus State and Local Fiscal Recovery Funds Medicaid Assistance Program HIV Emergency Relief Project Grants ALNs: 21.027 93.778 93.914 Federal Agency: U.S. Department of Treasury U.S. Department of Health and Human Services Federal Award Years: January 1, 2023 – December 31, 2023 Criteria: 2 CFR, Part 200 – Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, Subpart F, §200.510(b) requires that auditees prepare a schedule of expenditures of Federal awards for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502. Condition Found, Including Perspective: The Schedule of Expenditures of Federal Awards (SEFA) prepared by management contained certain differences between federal expenditures reported and the years in which the federal awards were expended totaling $2,790,267 related to the COVID-10 Coronavirus State and Local Fiscal Recovery Funds, $174,977 related to the Medicaid Assistance Program and $250,808 relate to the HIV Emergency Relief Project Grants. Possible Cause and Effect: While the System performs a review during the compilation of the SEFA, controls were not designed or implemented effectively to ensure that certain amounts were properly reflected on the SEFA in the period in which they were expended. Questioned Costs: None. Statistical Validity: The sample was not intended to be, and was not, a statistically valid sample. Repeat Finding in the Prior Year: This is not a repeat finding. Recommendation We recommend that management implement appropriate controls and processes to ensure that expenditures are presented on the correct SEFA year. Views of Responsible Officials: Grady Memorial Hospital Corporation will implement a control and process to ensure that expenditures are properly reflected on the SEFA.
Finding 2023-002 – SEFA Reporting Federal Program: COVID-19 Coronavirus State and Local Fiscal Recovery Funds Medicaid Assistance Program HIV Emergency Relief Project Grants ALNs: 21.027 93.778 93.914 Federal Agency: U.S. Department of Treasury U.S. Department of Health and Human Services Federal Award Years: January 1, 2023 – December 31, 2023 Criteria: 2 CFR, Part 200 – Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, Subpart F, §200.510(b) requires that auditees prepare a schedule of expenditures of Federal awards for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502. Condition Found, Including Perspective: The Schedule of Expenditures of Federal Awards (SEFA) prepared by management contained certain differences between federal expenditures reported and the years in which the federal awards were expended totaling $2,790,267 related to the COVID-10 Coronavirus State and Local Fiscal Recovery Funds, $174,977 related to the Medicaid Assistance Program and $250,808 relate to the HIV Emergency Relief Project Grants. Possible Cause and Effect: While the System performs a review during the compilation of the SEFA, controls were not designed or implemented effectively to ensure that certain amounts were properly reflected on the SEFA in the period in which they were expended. Questioned Costs: None. Statistical Validity: The sample was not intended to be, and was not, a statistically valid sample. Repeat Finding in the Prior Year: This is not a repeat finding. Recommendation We recommend that management implement appropriate controls and processes to ensure that expenditures are presented on the correct SEFA year. Views of Responsible Officials: Grady Memorial Hospital Corporation will implement a control and process to ensure that expenditures are properly reflected on the SEFA.
Finding 2023-002 – SEFA Reporting Federal Program: COVID-19 Coronavirus State and Local Fiscal Recovery Funds Medicaid Assistance Program HIV Emergency Relief Project Grants ALNs: 21.027 93.778 93.914 Federal Agency: U.S. Department of Treasury U.S. Department of Health and Human Services Federal Award Years: January 1, 2023 – December 31, 2023 Criteria: 2 CFR, Part 200 – Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, Subpart F, §200.510(b) requires that auditees prepare a schedule of expenditures of Federal awards for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502. Condition Found, Including Perspective: The Schedule of Expenditures of Federal Awards (SEFA) prepared by management contained certain differences between federal expenditures reported and the years in which the federal awards were expended totaling $2,790,267 related to the COVID-10 Coronavirus State and Local Fiscal Recovery Funds, $174,977 related to the Medicaid Assistance Program and $250,808 relate to the HIV Emergency Relief Project Grants. Possible Cause and Effect: While the System performs a review during the compilation of the SEFA, controls were not designed or implemented effectively to ensure that certain amounts were properly reflected on the SEFA in the period in which they were expended. Questioned Costs: None. Statistical Validity: The sample was not intended to be, and was not, a statistically valid sample. Repeat Finding in the Prior Year: This is not a repeat finding. Recommendation We recommend that management implement appropriate controls and processes to ensure that expenditures are presented on the correct SEFA year. Views of Responsible Officials: Grady Memorial Hospital Corporation will implement a control and process to ensure that expenditures are properly reflected on the SEFA.
Finding 2023-002 – SEFA Reporting Federal Program: COVID-19 Coronavirus State and Local Fiscal Recovery Funds Medicaid Assistance Program HIV Emergency Relief Project Grants ALNs: 21.027 93.778 93.914 Federal Agency: U.S. Department of Treasury U.S. Department of Health and Human Services Federal Award Years: January 1, 2023 – December 31, 2023 Criteria: 2 CFR, Part 200 – Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, Subpart F, §200.510(b) requires that auditees prepare a schedule of expenditures of Federal awards for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502. Condition Found, Including Perspective: The Schedule of Expenditures of Federal Awards (SEFA) prepared by management contained certain differences between federal expenditures reported and the years in which the federal awards were expended totaling $2,790,267 related to the COVID-10 Coronavirus State and Local Fiscal Recovery Funds, $174,977 related to the Medicaid Assistance Program and $250,808 relate to the HIV Emergency Relief Project Grants. Possible Cause and Effect: While the System performs a review during the compilation of the SEFA, controls were not designed or implemented effectively to ensure that certain amounts were properly reflected on the SEFA in the period in which they were expended. Questioned Costs: None. Statistical Validity: The sample was not intended to be, and was not, a statistically valid sample. Repeat Finding in the Prior Year: This is not a repeat finding. Recommendation We recommend that management implement appropriate controls and processes to ensure that expenditures are presented on the correct SEFA year. Views of Responsible Officials: Grady Memorial Hospital Corporation will implement a control and process to ensure that expenditures are properly reflected on the SEFA.
Finding 2023-002 – SEFA Reporting Federal Program: COVID-19 Coronavirus State and Local Fiscal Recovery Funds Medicaid Assistance Program HIV Emergency Relief Project Grants ALNs: 21.027 93.778 93.914 Federal Agency: U.S. Department of Treasury U.S. Department of Health and Human Services Federal Award Years: January 1, 2023 – December 31, 2023 Criteria: 2 CFR, Part 200 – Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, Subpart F, §200.510(b) requires that auditees prepare a schedule of expenditures of Federal awards for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502. Condition Found, Including Perspective: The Schedule of Expenditures of Federal Awards (SEFA) prepared by management contained certain differences between federal expenditures reported and the years in which the federal awards were expended totaling $2,790,267 related to the COVID-10 Coronavirus State and Local Fiscal Recovery Funds, $174,977 related to the Medicaid Assistance Program and $250,808 relate to the HIV Emergency Relief Project Grants. Possible Cause and Effect: While the System performs a review during the compilation of the SEFA, controls were not designed or implemented effectively to ensure that certain amounts were properly reflected on the SEFA in the period in which they were expended. Questioned Costs: None. Statistical Validity: The sample was not intended to be, and was not, a statistically valid sample. Repeat Finding in the Prior Year: This is not a repeat finding. Recommendation We recommend that management implement appropriate controls and processes to ensure that expenditures are presented on the correct SEFA year. Views of Responsible Officials: Grady Memorial Hospital Corporation will implement a control and process to ensure that expenditures are properly reflected on the SEFA.
Finding 2023-002 – SEFA Reporting Federal Program: COVID-19 Coronavirus State and Local Fiscal Recovery Funds Medicaid Assistance Program HIV Emergency Relief Project Grants ALNs: 21.027 93.778 93.914 Federal Agency: U.S. Department of Treasury U.S. Department of Health and Human Services Federal Award Years: January 1, 2023 – December 31, 2023 Criteria: 2 CFR, Part 200 – Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, Subpart F, §200.510(b) requires that auditees prepare a schedule of expenditures of Federal awards for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502. Condition Found, Including Perspective: The Schedule of Expenditures of Federal Awards (SEFA) prepared by management contained certain differences between federal expenditures reported and the years in which the federal awards were expended totaling $2,790,267 related to the COVID-10 Coronavirus State and Local Fiscal Recovery Funds, $174,977 related to the Medicaid Assistance Program and $250,808 relate to the HIV Emergency Relief Project Grants. Possible Cause and Effect: While the System performs a review during the compilation of the SEFA, controls were not designed or implemented effectively to ensure that certain amounts were properly reflected on the SEFA in the period in which they were expended. Questioned Costs: None. Statistical Validity: The sample was not intended to be, and was not, a statistically valid sample. Repeat Finding in the Prior Year: This is not a repeat finding. Recommendation We recommend that management implement appropriate controls and processes to ensure that expenditures are presented on the correct SEFA year. Views of Responsible Officials: Grady Memorial Hospital Corporation will implement a control and process to ensure that expenditures are properly reflected on the SEFA.
Finding 2023-002 – SEFA Reporting Federal Program: COVID-19 Coronavirus State and Local Fiscal Recovery Funds Medicaid Assistance Program HIV Emergency Relief Project Grants ALNs: 21.027 93.778 93.914 Federal Agency: U.S. Department of Treasury U.S. Department of Health and Human Services Federal Award Years: January 1, 2023 – December 31, 2023 Criteria: 2 CFR, Part 200 – Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, Subpart F, §200.510(b) requires that auditees prepare a schedule of expenditures of Federal awards for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502. Condition Found, Including Perspective: The Schedule of Expenditures of Federal Awards (SEFA) prepared by management contained certain differences between federal expenditures reported and the years in which the federal awards were expended totaling $2,790,267 related to the COVID-10 Coronavirus State and Local Fiscal Recovery Funds, $174,977 related to the Medicaid Assistance Program and $250,808 relate to the HIV Emergency Relief Project Grants. Possible Cause and Effect: While the System performs a review during the compilation of the SEFA, controls were not designed or implemented effectively to ensure that certain amounts were properly reflected on the SEFA in the period in which they were expended. Questioned Costs: None. Statistical Validity: The sample was not intended to be, and was not, a statistically valid sample. Repeat Finding in the Prior Year: This is not a repeat finding. Recommendation We recommend that management implement appropriate controls and processes to ensure that expenditures are presented on the correct SEFA year. Views of Responsible Officials: Grady Memorial Hospital Corporation will implement a control and process to ensure that expenditures are properly reflected on the SEFA.
Finding 2023-002 – SEFA Reporting Federal Program: COVID-19 Coronavirus State and Local Fiscal Recovery Funds Medicaid Assistance Program HIV Emergency Relief Project Grants ALNs: 21.027 93.778 93.914 Federal Agency: U.S. Department of Treasury U.S. Department of Health and Human Services Federal Award Years: January 1, 2023 – December 31, 2023 Criteria: 2 CFR, Part 200 – Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, Subpart F, §200.510(b) requires that auditees prepare a schedule of expenditures of Federal awards for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502. Condition Found, Including Perspective: The Schedule of Expenditures of Federal Awards (SEFA) prepared by management contained certain differences between federal expenditures reported and the years in which the federal awards were expended totaling $2,790,267 related to the COVID-10 Coronavirus State and Local Fiscal Recovery Funds, $174,977 related to the Medicaid Assistance Program and $250,808 relate to the HIV Emergency Relief Project Grants. Possible Cause and Effect: While the System performs a review during the compilation of the SEFA, controls were not designed or implemented effectively to ensure that certain amounts were properly reflected on the SEFA in the period in which they were expended. Questioned Costs: None. Statistical Validity: The sample was not intended to be, and was not, a statistically valid sample. Repeat Finding in the Prior Year: This is not a repeat finding. Recommendation We recommend that management implement appropriate controls and processes to ensure that expenditures are presented on the correct SEFA year. Views of Responsible Officials: Grady Memorial Hospital Corporation will implement a control and process to ensure that expenditures are properly reflected on the SEFA.
Finding 2023-002 – SEFA Reporting Federal Program: COVID-19 Coronavirus State and Local Fiscal Recovery Funds Medicaid Assistance Program HIV Emergency Relief Project Grants ALNs: 21.027 93.778 93.914 Federal Agency: U.S. Department of Treasury U.S. Department of Health and Human Services Federal Award Years: January 1, 2023 – December 31, 2023 Criteria: 2 CFR, Part 200 – Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, Subpart F, §200.510(b) requires that auditees prepare a schedule of expenditures of Federal awards for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502. Condition Found, Including Perspective: The Schedule of Expenditures of Federal Awards (SEFA) prepared by management contained certain differences between federal expenditures reported and the years in which the federal awards were expended totaling $2,790,267 related to the COVID-10 Coronavirus State and Local Fiscal Recovery Funds, $174,977 related to the Medicaid Assistance Program and $250,808 relate to the HIV Emergency Relief Project Grants. Possible Cause and Effect: While the System performs a review during the compilation of the SEFA, controls were not designed or implemented effectively to ensure that certain amounts were properly reflected on the SEFA in the period in which they were expended. Questioned Costs: None. Statistical Validity: The sample was not intended to be, and was not, a statistically valid sample. Repeat Finding in the Prior Year: This is not a repeat finding. Recommendation We recommend that management implement appropriate controls and processes to ensure that expenditures are presented on the correct SEFA year. Views of Responsible Officials: Grady Memorial Hospital Corporation will implement a control and process to ensure that expenditures are properly reflected on the SEFA.
Finding Number: 2023-008 Repeat Finding: No Type of Finding: Significant Deficiency in Internal Control and Nonmaterial Noncompliance Description: Schedule of Expenditures of Federal Awards Awareness and Preparation Major Programs: AL#93.243 - Substance Abuse and Mental Health Services – Direct Award (DHHS) – Award numbers: 1H79SM087536-01, 1H79SM087590-01, 5H79SP081724-04, 5H79SP081724-05, 5H79SM082160-04, 5H79SM082160-05, 5H79SP082229-02, 5H79SP082229-03, 1H79SM088765-01, 1H79TI085542-01, H79TI086128-01 and CD9-23-4425 AL#93.738 – PPHF: Racial and Ethnic Approaches to Community Health Program financed solely by Public Prevention and Health Funds – Direct Award (DHHS) – Award number: 5 NU58DP006960-02-00 and 6 NU58DP006960-01-01 AL#93.772 - Tribal Public Health Capacity Building and Quality Improvement Umbrella Cooperative Agreement – Direct Award (DHHS) – Award numbers: 1 NU38TO000023-01-00, 6 NU38TO000023-01-01, 6 NU38OT000257-05-03 and 6 NU38OT000257C3 AL#93.788 – Opioid STR – Direct Award (DHHS) – Award numbers: 1H79TI083088-01, 5H79TI083088-02, 6H79TI085684-01M003 and CD9-23-4425 AL#93.859 – Biomedical Research and Research Training – Direct Award (DHHS) – Award numbers: 5S06GM142115-02 and 5S06GM142115-03 Questioned Costs: None How the questioned costs were computed: N/A Compliance Requirement: Reporting Condition: The Organization did not have all federal expenditures recorded in their trial balance and did not have accurate records of all expenditures spent during the audit period. In addition, it did not have all of the necessary information or training to create the Schedule of Expenditures of Federal Awards. Criteria: Under 2 CFR Part 200.502, the auditee must prepare the Schedule of Expenditure of Federal Awards to cover the appropriate audit period and to include all applicable federal expenditures expended during the audit period. Cause: The Organization does not have processes in place to properly track award numbers, award periods, assistance listing numbers and grant spending. Effect: The Organization was unable to provide the auditors with a complete Schedule of Expenditures of Federal Awards (including all grants with federal awards, all assistance listing numbers, total amount of federal awards expended) and could not verify the completeness of expenditures recorded in their financial statements provided for the audit. Recommendation: We recommend the Organization create processes and procedures that capture all federal funding received and track applicable expenditures. This report should be reconciled regularly (at least monthly) when requests for reimbursement are made and should include all applicable information necessary to identify the funding agency, assistance listing number, and any other pertinent passthrough information. With this process in place, the Organization will be better able to track and monitor grant funding, plan future projects or future funding needs, and prepare for the annual audit. Views of Responsible Officials: Management agrees with the finding and has committed to a corrective action plan.
Finding Number: 2023-008 Repeat Finding: No Type of Finding: Significant Deficiency in Internal Control and Nonmaterial Noncompliance Description: Schedule of Expenditures of Federal Awards Awareness and Preparation Major Programs: AL#93.243 - Substance Abuse and Mental Health Services – Direct Award (DHHS) – Award numbers: 1H79SM087536-01, 1H79SM087590-01, 5H79SP081724-04, 5H79SP081724-05, 5H79SM082160-04, 5H79SM082160-05, 5H79SP082229-02, 5H79SP082229-03, 1H79SM088765-01, 1H79TI085542-01, H79TI086128-01 and CD9-23-4425 AL#93.738 – PPHF: Racial and Ethnic Approaches to Community Health Program financed solely by Public Prevention and Health Funds – Direct Award (DHHS) – Award number: 5 NU58DP006960-02-00 and 6 NU58DP006960-01-01 AL#93.772 - Tribal Public Health Capacity Building and Quality Improvement Umbrella Cooperative Agreement – Direct Award (DHHS) – Award numbers: 1 NU38TO000023-01-00, 6 NU38TO000023-01-01, 6 NU38OT000257-05-03 and 6 NU38OT000257C3 AL#93.788 – Opioid STR – Direct Award (DHHS) – Award numbers: 1H79TI083088-01, 5H79TI083088-02, 6H79TI085684-01M003 and CD9-23-4425 AL#93.859 – Biomedical Research and Research Training – Direct Award (DHHS) – Award numbers: 5S06GM142115-02 and 5S06GM142115-03 Questioned Costs: None How the questioned costs were computed: N/A Compliance Requirement: Reporting Condition: The Organization did not have all federal expenditures recorded in their trial balance and did not have accurate records of all expenditures spent during the audit period. In addition, it did not have all of the necessary information or training to create the Schedule of Expenditures of Federal Awards. Criteria: Under 2 CFR Part 200.502, the auditee must prepare the Schedule of Expenditure of Federal Awards to cover the appropriate audit period and to include all applicable federal expenditures expended during the audit period. Cause: The Organization does not have processes in place to properly track award numbers, award periods, assistance listing numbers and grant spending. Effect: The Organization was unable to provide the auditors with a complete Schedule of Expenditures of Federal Awards (including all grants with federal awards, all assistance listing numbers, total amount of federal awards expended) and could not verify the completeness of expenditures recorded in their financial statements provided for the audit. Recommendation: We recommend the Organization create processes and procedures that capture all federal funding received and track applicable expenditures. This report should be reconciled regularly (at least monthly) when requests for reimbursement are made and should include all applicable information necessary to identify the funding agency, assistance listing number, and any other pertinent passthrough information. With this process in place, the Organization will be better able to track and monitor grant funding, plan future projects or future funding needs, and prepare for the annual audit. Views of Responsible Officials: Management agrees with the finding and has committed to a corrective action plan.
Finding Number: 2023-008 Repeat Finding: No Type of Finding: Significant Deficiency in Internal Control and Nonmaterial Noncompliance Description: Schedule of Expenditures of Federal Awards Awareness and Preparation Major Programs: AL#93.243 - Substance Abuse and Mental Health Services – Direct Award (DHHS) – Award numbers: 1H79SM087536-01, 1H79SM087590-01, 5H79SP081724-04, 5H79SP081724-05, 5H79SM082160-04, 5H79SM082160-05, 5H79SP082229-02, 5H79SP082229-03, 1H79SM088765-01, 1H79TI085542-01, H79TI086128-01 and CD9-23-4425 AL#93.738 – PPHF: Racial and Ethnic Approaches to Community Health Program financed solely by Public Prevention and Health Funds – Direct Award (DHHS) – Award number: 5 NU58DP006960-02-00 and 6 NU58DP006960-01-01 AL#93.772 - Tribal Public Health Capacity Building and Quality Improvement Umbrella Cooperative Agreement – Direct Award (DHHS) – Award numbers: 1 NU38TO000023-01-00, 6 NU38TO000023-01-01, 6 NU38OT000257-05-03 and 6 NU38OT000257C3 AL#93.788 – Opioid STR – Direct Award (DHHS) – Award numbers: 1H79TI083088-01, 5H79TI083088-02, 6H79TI085684-01M003 and CD9-23-4425 AL#93.859 – Biomedical Research and Research Training – Direct Award (DHHS) – Award numbers: 5S06GM142115-02 and 5S06GM142115-03 Questioned Costs: None How the questioned costs were computed: N/A Compliance Requirement: Reporting Condition: The Organization did not have all federal expenditures recorded in their trial balance and did not have accurate records of all expenditures spent during the audit period. In addition, it did not have all of the necessary information or training to create the Schedule of Expenditures of Federal Awards. Criteria: Under 2 CFR Part 200.502, the auditee must prepare the Schedule of Expenditure of Federal Awards to cover the appropriate audit period and to include all applicable federal expenditures expended during the audit period. Cause: The Organization does not have processes in place to properly track award numbers, award periods, assistance listing numbers and grant spending. Effect: The Organization was unable to provide the auditors with a complete Schedule of Expenditures of Federal Awards (including all grants with federal awards, all assistance listing numbers, total amount of federal awards expended) and could not verify the completeness of expenditures recorded in their financial statements provided for the audit. Recommendation: We recommend the Organization create processes and procedures that capture all federal funding received and track applicable expenditures. This report should be reconciled regularly (at least monthly) when requests for reimbursement are made and should include all applicable information necessary to identify the funding agency, assistance listing number, and any other pertinent passthrough information. With this process in place, the Organization will be better able to track and monitor grant funding, plan future projects or future funding needs, and prepare for the annual audit. Views of Responsible Officials: Management agrees with the finding and has committed to a corrective action plan.
Finding Number: 2023-008 Repeat Finding: No Type of Finding: Significant Deficiency in Internal Control and Nonmaterial Noncompliance Description: Schedule of Expenditures of Federal Awards Awareness and Preparation Major Programs: AL#93.243 - Substance Abuse and Mental Health Services – Direct Award (DHHS) – Award numbers: 1H79SM087536-01, 1H79SM087590-01, 5H79SP081724-04, 5H79SP081724-05, 5H79SM082160-04, 5H79SM082160-05, 5H79SP082229-02, 5H79SP082229-03, 1H79SM088765-01, 1H79TI085542-01, H79TI086128-01 and CD9-23-4425 AL#93.738 – PPHF: Racial and Ethnic Approaches to Community Health Program financed solely by Public Prevention and Health Funds – Direct Award (DHHS) – Award number: 5 NU58DP006960-02-00 and 6 NU58DP006960-01-01 AL#93.772 - Tribal Public Health Capacity Building and Quality Improvement Umbrella Cooperative Agreement – Direct Award (DHHS) – Award numbers: 1 NU38TO000023-01-00, 6 NU38TO000023-01-01, 6 NU38OT000257-05-03 and 6 NU38OT000257C3 AL#93.788 – Opioid STR – Direct Award (DHHS) – Award numbers: 1H79TI083088-01, 5H79TI083088-02, 6H79TI085684-01M003 and CD9-23-4425 AL#93.859 – Biomedical Research and Research Training – Direct Award (DHHS) – Award numbers: 5S06GM142115-02 and 5S06GM142115-03 Questioned Costs: None How the questioned costs were computed: N/A Compliance Requirement: Reporting Condition: The Organization did not have all federal expenditures recorded in their trial balance and did not have accurate records of all expenditures spent during the audit period. In addition, it did not have all of the necessary information or training to create the Schedule of Expenditures of Federal Awards. Criteria: Under 2 CFR Part 200.502, the auditee must prepare the Schedule of Expenditure of Federal Awards to cover the appropriate audit period and to include all applicable federal expenditures expended during the audit period. Cause: The Organization does not have processes in place to properly track award numbers, award periods, assistance listing numbers and grant spending. Effect: The Organization was unable to provide the auditors with a complete Schedule of Expenditures of Federal Awards (including all grants with federal awards, all assistance listing numbers, total amount of federal awards expended) and could not verify the completeness of expenditures recorded in their financial statements provided for the audit. Recommendation: We recommend the Organization create processes and procedures that capture all federal funding received and track applicable expenditures. This report should be reconciled regularly (at least monthly) when requests for reimbursement are made and should include all applicable information necessary to identify the funding agency, assistance listing number, and any other pertinent passthrough information. With this process in place, the Organization will be better able to track and monitor grant funding, plan future projects or future funding needs, and prepare for the annual audit. Views of Responsible Officials: Management agrees with the finding and has committed to a corrective action plan.
Finding Number: 2023-008 Repeat Finding: No Type of Finding: Significant Deficiency in Internal Control and Nonmaterial Noncompliance Description: Schedule of Expenditures of Federal Awards Awareness and Preparation Major Programs: AL#93.243 - Substance Abuse and Mental Health Services – Direct Award (DHHS) – Award numbers: 1H79SM087536-01, 1H79SM087590-01, 5H79SP081724-04, 5H79SP081724-05, 5H79SM082160-04, 5H79SM082160-05, 5H79SP082229-02, 5H79SP082229-03, 1H79SM088765-01, 1H79TI085542-01, H79TI086128-01 and CD9-23-4425 AL#93.738 – PPHF: Racial and Ethnic Approaches to Community Health Program financed solely by Public Prevention and Health Funds – Direct Award (DHHS) – Award number: 5 NU58DP006960-02-00 and 6 NU58DP006960-01-01 AL#93.772 - Tribal Public Health Capacity Building and Quality Improvement Umbrella Cooperative Agreement – Direct Award (DHHS) – Award numbers: 1 NU38TO000023-01-00, 6 NU38TO000023-01-01, 6 NU38OT000257-05-03 and 6 NU38OT000257C3 AL#93.788 – Opioid STR – Direct Award (DHHS) – Award numbers: 1H79TI083088-01, 5H79TI083088-02, 6H79TI085684-01M003 and CD9-23-4425 AL#93.859 – Biomedical Research and Research Training – Direct Award (DHHS) – Award numbers: 5S06GM142115-02 and 5S06GM142115-03 Questioned Costs: None How the questioned costs were computed: N/A Compliance Requirement: Reporting Condition: The Organization did not have all federal expenditures recorded in their trial balance and did not have accurate records of all expenditures spent during the audit period. In addition, it did not have all of the necessary information or training to create the Schedule of Expenditures of Federal Awards. Criteria: Under 2 CFR Part 200.502, the auditee must prepare the Schedule of Expenditure of Federal Awards to cover the appropriate audit period and to include all applicable federal expenditures expended during the audit period. Cause: The Organization does not have processes in place to properly track award numbers, award periods, assistance listing numbers and grant spending. Effect: The Organization was unable to provide the auditors with a complete Schedule of Expenditures of Federal Awards (including all grants with federal awards, all assistance listing numbers, total amount of federal awards expended) and could not verify the completeness of expenditures recorded in their financial statements provided for the audit. Recommendation: We recommend the Organization create processes and procedures that capture all federal funding received and track applicable expenditures. This report should be reconciled regularly (at least monthly) when requests for reimbursement are made and should include all applicable information necessary to identify the funding agency, assistance listing number, and any other pertinent passthrough information. With this process in place, the Organization will be better able to track and monitor grant funding, plan future projects or future funding needs, and prepare for the annual audit. Views of Responsible Officials: Management agrees with the finding and has committed to a corrective action plan.
Finding Number: 2023-008 Repeat Finding: No Type of Finding: Significant Deficiency in Internal Control and Nonmaterial Noncompliance Description: Schedule of Expenditures of Federal Awards Awareness and Preparation Major Programs: AL#93.243 - Substance Abuse and Mental Health Services – Direct Award (DHHS) – Award numbers: 1H79SM087536-01, 1H79SM087590-01, 5H79SP081724-04, 5H79SP081724-05, 5H79SM082160-04, 5H79SM082160-05, 5H79SP082229-02, 5H79SP082229-03, 1H79SM088765-01, 1H79TI085542-01, H79TI086128-01 and CD9-23-4425 AL#93.738 – PPHF: Racial and Ethnic Approaches to Community Health Program financed solely by Public Prevention and Health Funds – Direct Award (DHHS) – Award number: 5 NU58DP006960-02-00 and 6 NU58DP006960-01-01 AL#93.772 - Tribal Public Health Capacity Building and Quality Improvement Umbrella Cooperative Agreement – Direct Award (DHHS) – Award numbers: 1 NU38TO000023-01-00, 6 NU38TO000023-01-01, 6 NU38OT000257-05-03 and 6 NU38OT000257C3 AL#93.788 – Opioid STR – Direct Award (DHHS) – Award numbers: 1H79TI083088-01, 5H79TI083088-02, 6H79TI085684-01M003 and CD9-23-4425 AL#93.859 – Biomedical Research and Research Training – Direct Award (DHHS) – Award numbers: 5S06GM142115-02 and 5S06GM142115-03 Questioned Costs: None How the questioned costs were computed: N/A Compliance Requirement: Reporting Condition: The Organization did not have all federal expenditures recorded in their trial balance and did not have accurate records of all expenditures spent during the audit period. In addition, it did not have all of the necessary information or training to create the Schedule of Expenditures of Federal Awards. Criteria: Under 2 CFR Part 200.502, the auditee must prepare the Schedule of Expenditure of Federal Awards to cover the appropriate audit period and to include all applicable federal expenditures expended during the audit period. Cause: The Organization does not have processes in place to properly track award numbers, award periods, assistance listing numbers and grant spending. Effect: The Organization was unable to provide the auditors with a complete Schedule of Expenditures of Federal Awards (including all grants with federal awards, all assistance listing numbers, total amount of federal awards expended) and could not verify the completeness of expenditures recorded in their financial statements provided for the audit. Recommendation: We recommend the Organization create processes and procedures that capture all federal funding received and track applicable expenditures. This report should be reconciled regularly (at least monthly) when requests for reimbursement are made and should include all applicable information necessary to identify the funding agency, assistance listing number, and any other pertinent passthrough information. With this process in place, the Organization will be better able to track and monitor grant funding, plan future projects or future funding needs, and prepare for the annual audit. Views of Responsible Officials: Management agrees with the finding and has committed to a corrective action plan.
Finding Number: 2023-008 Repeat Finding: No Type of Finding: Significant Deficiency in Internal Control and Nonmaterial Noncompliance Description: Schedule of Expenditures of Federal Awards Awareness and Preparation Major Programs: AL#93.243 - Substance Abuse and Mental Health Services – Direct Award (DHHS) – Award numbers: 1H79SM087536-01, 1H79SM087590-01, 5H79SP081724-04, 5H79SP081724-05, 5H79SM082160-04, 5H79SM082160-05, 5H79SP082229-02, 5H79SP082229-03, 1H79SM088765-01, 1H79TI085542-01, H79TI086128-01 and CD9-23-4425 AL#93.738 – PPHF: Racial and Ethnic Approaches to Community Health Program financed solely by Public Prevention and Health Funds – Direct Award (DHHS) – Award number: 5 NU58DP006960-02-00 and 6 NU58DP006960-01-01 AL#93.772 - Tribal Public Health Capacity Building and Quality Improvement Umbrella Cooperative Agreement – Direct Award (DHHS) – Award numbers: 1 NU38TO000023-01-00, 6 NU38TO000023-01-01, 6 NU38OT000257-05-03 and 6 NU38OT000257C3 AL#93.788 – Opioid STR – Direct Award (DHHS) – Award numbers: 1H79TI083088-01, 5H79TI083088-02, 6H79TI085684-01M003 and CD9-23-4425 AL#93.859 – Biomedical Research and Research Training – Direct Award (DHHS) – Award numbers: 5S06GM142115-02 and 5S06GM142115-03 Questioned Costs: None How the questioned costs were computed: N/A Compliance Requirement: Reporting Condition: The Organization did not have all federal expenditures recorded in their trial balance and did not have accurate records of all expenditures spent during the audit period. In addition, it did not have all of the necessary information or training to create the Schedule of Expenditures of Federal Awards. Criteria: Under 2 CFR Part 200.502, the auditee must prepare the Schedule of Expenditure of Federal Awards to cover the appropriate audit period and to include all applicable federal expenditures expended during the audit period. Cause: The Organization does not have processes in place to properly track award numbers, award periods, assistance listing numbers and grant spending. Effect: The Organization was unable to provide the auditors with a complete Schedule of Expenditures of Federal Awards (including all grants with federal awards, all assistance listing numbers, total amount of federal awards expended) and could not verify the completeness of expenditures recorded in their financial statements provided for the audit. Recommendation: We recommend the Organization create processes and procedures that capture all federal funding received and track applicable expenditures. This report should be reconciled regularly (at least monthly) when requests for reimbursement are made and should include all applicable information necessary to identify the funding agency, assistance listing number, and any other pertinent passthrough information. With this process in place, the Organization will be better able to track and monitor grant funding, plan future projects or future funding needs, and prepare for the annual audit. Views of Responsible Officials: Management agrees with the finding and has committed to a corrective action plan.
Finding Number: 2023-008 Repeat Finding: No Type of Finding: Significant Deficiency in Internal Control and Nonmaterial Noncompliance Description: Schedule of Expenditures of Federal Awards Awareness and Preparation Major Programs: AL#93.243 - Substance Abuse and Mental Health Services – Direct Award (DHHS) – Award numbers: 1H79SM087536-01, 1H79SM087590-01, 5H79SP081724-04, 5H79SP081724-05, 5H79SM082160-04, 5H79SM082160-05, 5H79SP082229-02, 5H79SP082229-03, 1H79SM088765-01, 1H79TI085542-01, H79TI086128-01 and CD9-23-4425 AL#93.738 – PPHF: Racial and Ethnic Approaches to Community Health Program financed solely by Public Prevention and Health Funds – Direct Award (DHHS) – Award number: 5 NU58DP006960-02-00 and 6 NU58DP006960-01-01 AL#93.772 - Tribal Public Health Capacity Building and Quality Improvement Umbrella Cooperative Agreement – Direct Award (DHHS) – Award numbers: 1 NU38TO000023-01-00, 6 NU38TO000023-01-01, 6 NU38OT000257-05-03 and 6 NU38OT000257C3 AL#93.788 – Opioid STR – Direct Award (DHHS) – Award numbers: 1H79TI083088-01, 5H79TI083088-02, 6H79TI085684-01M003 and CD9-23-4425 AL#93.859 – Biomedical Research and Research Training – Direct Award (DHHS) – Award numbers: 5S06GM142115-02 and 5S06GM142115-03 Questioned Costs: None How the questioned costs were computed: N/A Compliance Requirement: Reporting Condition: The Organization did not have all federal expenditures recorded in their trial balance and did not have accurate records of all expenditures spent during the audit period. In addition, it did not have all of the necessary information or training to create the Schedule of Expenditures of Federal Awards. Criteria: Under 2 CFR Part 200.502, the auditee must prepare the Schedule of Expenditure of Federal Awards to cover the appropriate audit period and to include all applicable federal expenditures expended during the audit period. Cause: The Organization does not have processes in place to properly track award numbers, award periods, assistance listing numbers and grant spending. Effect: The Organization was unable to provide the auditors with a complete Schedule of Expenditures of Federal Awards (including all grants with federal awards, all assistance listing numbers, total amount of federal awards expended) and could not verify the completeness of expenditures recorded in their financial statements provided for the audit. Recommendation: We recommend the Organization create processes and procedures that capture all federal funding received and track applicable expenditures. This report should be reconciled regularly (at least monthly) when requests for reimbursement are made and should include all applicable information necessary to identify the funding agency, assistance listing number, and any other pertinent passthrough information. With this process in place, the Organization will be better able to track and monitor grant funding, plan future projects or future funding needs, and prepare for the annual audit. Views of Responsible Officials: Management agrees with the finding and has committed to a corrective action plan.
Finding Number: 2023-008 Repeat Finding: No Type of Finding: Significant Deficiency in Internal Control and Nonmaterial Noncompliance Description: Schedule of Expenditures of Federal Awards Awareness and Preparation Major Programs: AL#93.243 - Substance Abuse and Mental Health Services – Direct Award (DHHS) – Award numbers: 1H79SM087536-01, 1H79SM087590-01, 5H79SP081724-04, 5H79SP081724-05, 5H79SM082160-04, 5H79SM082160-05, 5H79SP082229-02, 5H79SP082229-03, 1H79SM088765-01, 1H79TI085542-01, H79TI086128-01 and CD9-23-4425 AL#93.738 – PPHF: Racial and Ethnic Approaches to Community Health Program financed solely by Public Prevention and Health Funds – Direct Award (DHHS) – Award number: 5 NU58DP006960-02-00 and 6 NU58DP006960-01-01 AL#93.772 - Tribal Public Health Capacity Building and Quality Improvement Umbrella Cooperative Agreement – Direct Award (DHHS) – Award numbers: 1 NU38TO000023-01-00, 6 NU38TO000023-01-01, 6 NU38OT000257-05-03 and 6 NU38OT000257C3 AL#93.788 – Opioid STR – Direct Award (DHHS) – Award numbers: 1H79TI083088-01, 5H79TI083088-02, 6H79TI085684-01M003 and CD9-23-4425 AL#93.859 – Biomedical Research and Research Training – Direct Award (DHHS) – Award numbers: 5S06GM142115-02 and 5S06GM142115-03 Questioned Costs: None How the questioned costs were computed: N/A Compliance Requirement: Reporting Condition: The Organization did not have all federal expenditures recorded in their trial balance and did not have accurate records of all expenditures spent during the audit period. In addition, it did not have all of the necessary information or training to create the Schedule of Expenditures of Federal Awards. Criteria: Under 2 CFR Part 200.502, the auditee must prepare the Schedule of Expenditure of Federal Awards to cover the appropriate audit period and to include all applicable federal expenditures expended during the audit period. Cause: The Organization does not have processes in place to properly track award numbers, award periods, assistance listing numbers and grant spending. Effect: The Organization was unable to provide the auditors with a complete Schedule of Expenditures of Federal Awards (including all grants with federal awards, all assistance listing numbers, total amount of federal awards expended) and could not verify the completeness of expenditures recorded in their financial statements provided for the audit. Recommendation: We recommend the Organization create processes and procedures that capture all federal funding received and track applicable expenditures. This report should be reconciled regularly (at least monthly) when requests for reimbursement are made and should include all applicable information necessary to identify the funding agency, assistance listing number, and any other pertinent passthrough information. With this process in place, the Organization will be better able to track and monitor grant funding, plan future projects or future funding needs, and prepare for the annual audit. Views of Responsible Officials: Management agrees with the finding and has committed to a corrective action plan.
Program Information: Texas Statewide Youth Services Network Project (“SYSN”) (ALN #93.590) Criteria or Specific Requirement (Including Statutory, Regulatory or Other Citation): L. Reporting- The auditee must prepare a schedule of expenditures of Federal awards (the “SEFA”) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For Research and Development (“R&D”), total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the passthrough entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the Assistance Listing number or other identifying number when the Assistance Listing information is not available. For a cluster of programs also provide the total for the cluster. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in 2 CFR 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in 2 CFR 200.414. Condition: The SEFA, as prepared by management, did not originally bifurcate grant expenditures between state and federal funding sources for the SYSN grant. Cause: The Organization did not properly identify separate state and federal funding sources as stated on the Notice of Award for the grant. Effect or Potential Effect: The original draft SEFA did not properly present both state and federal programs for the SYSN grant. Questioned Costs: None. Context: During the process to prepare the draft SEFA, management did not properly identify separate funding sources for one grant resulting in improper presentation of certain federal expenditures as state expenditures on the draft SEFA. Identification as a Repeat Finding: No. Recommendation: We recommend that the Alliance enhance its procedures and internal controls with respect to the preparation and review of the SEFA by comparing programs on the SEFA with corresponding grant agreements and notices of award. Views of Responsible Officials and Planned Corrective Actions: Review all federal grant contracts to determine if any separate funding sources should be listed for total funds received.
Federal Program Information: Education Stabilization Fund (ALN 84.425U) Criteria: L. Reporting- The auditee must prepare a schedule of expenditures of Federal awards (the “SEFA”) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502 Basis for determining Federal awards expended. Condition: During our audit of the financial statements for the fiscal year ending December 31, 2023, we identified that the SEFA was not prepared in accordance with the requirements set forth by the Uniform Guidance (2 CFR Part 200) and was incomplete. Cause: Insufficient internal control and administrative oversight. Effect or Potential Effect: As a result of the incorrect preparation, the SEFA did not accurately reflect the Federal awards expended during the fiscal year. This could potentially lead to non-compliance with Federal requirements and affect the accuracy of the financial statements. Recommendation: We recommend that the entity implement the following corrective actions: 1. Provide training to the staff responsible for preparing the SEFA to ensure they understand the requirements of the Uniform Guidance. 2. Establish a review process to verify the accuracy and completeness of the SEFA before submission. 3. Utilize a checklist or other tools to ensure all required information is included in the SEFA. Views of Responsible Officials: The Alliance will implement more stringent internal controls and administrative oversight with respect to preparation and review of the SEFA.
Federal Awards Findings and Questioned Costs Finding 2023-003 – Inaccurate SEFA - Reporting – Material Weakness Name of Federal Agency: U.S Department of Housing and Urban Development and U.S. Department of Treasury Federal Program Name: HOME Investments Partnership Program and Coronavirus State and Local Fiscal Recovery Funds Assistance Listing Number: 14.239 and 21.027 Federal Award Identification Number and Year: Identification number unavailable. Program years 2010, 2012, 2015, 2019, 2023. Name of Pass-through Entity (if applicable): Rhode Island Housing and Mortgage Finance Corporation and the City of Providence, Rhode Island. Criteria: In accordance with 2 CFR 200.302 (Financial Management), a grant recipient’s financial management system must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the federal statutes, regulations, and the terms and conditions of the federal award. In addition, 2 CFR 200.510 (Financial Statements), states in part that the auditee must prepare a schedule of expenditures of Federal awards (“SEFA”) for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with 2CFR 200.502. At a minimum, the schedule must include: -All individual Federal programs by Federal agency. -For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. -Provide total Federal awards expended for each individual Federal program and the Assistance Listings Number or other identifying number when the Assistance Listings information is not available. -Include the total amount provided to subrecipients from each Federal program. Condition / Context: The Organization management’s review and approval process did not detect the errors that were identified during the audit procedures performed. The errors detected consisted of the understatement of Federal Assistance Listing Numbers 14.239 and 14.218 in the amounts of $364,207 and $295,000, respectively, and an overstatement of Federal Assistance Listing Number 21.027 in the amount of $66,320, for a total net understatement of $592,887. Cause: The Organization’s internal controls over the preparation and review of the SEFA were not operating effectively. Material audit adjustments were proposed during the course of the audit that lead to material changes to the SEFA. Effect or Potential Effect: Inadequate controls over the preparation of the SEFA could result in financial misstatements or potential noncompliance. Questioned Costs: None Identification as a Repeat Finding: This is a repeat finding for Assistance Listing Number 14.239. See 2022-003. Recommendation: We recommend the Organization strengthen its policies, procedures, and controls for the identification of federal awards to ensure a complete and accurate SEFA is prepared in a timely manner. Views of Responsible Officials: Management agrees with the finding and is in the process of revising internal controls to address SEFA preparation.
Federal Awards Findings and Questioned Costs Finding 2023-003 – Inaccurate SEFA - Reporting – Material Weakness Name of Federal Agency: U.S Department of Housing and Urban Development and U.S. Department of Treasury Federal Program Name: HOME Investments Partnership Program and Coronavirus State and Local Fiscal Recovery Funds Assistance Listing Number: 14.239 and 21.027 Federal Award Identification Number and Year: Identification number unavailable. Program years 2010, 2012, 2015, 2019, 2023. Name of Pass-through Entity (if applicable): Rhode Island Housing and Mortgage Finance Corporation and the City of Providence, Rhode Island. Criteria: In accordance with 2 CFR 200.302 (Financial Management), a grant recipient’s financial management system must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the federal statutes, regulations, and the terms and conditions of the federal award. In addition, 2 CFR 200.510 (Financial Statements), states in part that the auditee must prepare a schedule of expenditures of Federal awards (“SEFA”) for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with 2CFR 200.502. At a minimum, the schedule must include: -All individual Federal programs by Federal agency. -For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. -Provide total Federal awards expended for each individual Federal program and the Assistance Listings Number or other identifying number when the Assistance Listings information is not available. -Include the total amount provided to subrecipients from each Federal program. Condition / Context: The Organization management’s review and approval process did not detect the errors that were identified during the audit procedures performed. The errors detected consisted of the understatement of Federal Assistance Listing Numbers 14.239 and 14.218 in the amounts of $364,207 and $295,000, respectively, and an overstatement of Federal Assistance Listing Number 21.027 in the amount of $66,320, for a total net understatement of $592,887. Cause: The Organization’s internal controls over the preparation and review of the SEFA were not operating effectively. Material audit adjustments were proposed during the course of the audit that lead to material changes to the SEFA. Effect or Potential Effect: Inadequate controls over the preparation of the SEFA could result in financial misstatements or potential noncompliance. Questioned Costs: None Identification as a Repeat Finding: This is a repeat finding for Assistance Listing Number 14.239. See 2022-003. Recommendation: We recommend the Organization strengthen its policies, procedures, and controls for the identification of federal awards to ensure a complete and accurate SEFA is prepared in a timely manner. Views of Responsible Officials: Management agrees with the finding and is in the process of revising internal controls to address SEFA preparation.
Federal Awards Findings and Questioned Costs Finding 2023-003 – Inaccurate SEFA - Reporting – Material Weakness Name of Federal Agency: U.S Department of Housing and Urban Development and U.S. Department of Treasury Federal Program Name: HOME Investments Partnership Program and Coronavirus State and Local Fiscal Recovery Funds Assistance Listing Number: 14.239 and 21.027 Federal Award Identification Number and Year: Identification number unavailable. Program years 2010, 2012, 2015, 2019, 2023. Name of Pass-through Entity (if applicable): Rhode Island Housing and Mortgage Finance Corporation and the City of Providence, Rhode Island. Criteria: In accordance with 2 CFR 200.302 (Financial Management), a grant recipient’s financial management system must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the federal statutes, regulations, and the terms and conditions of the federal award. In addition, 2 CFR 200.510 (Financial Statements), states in part that the auditee must prepare a schedule of expenditures of Federal awards (“SEFA”) for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with 2CFR 200.502. At a minimum, the schedule must include: -All individual Federal programs by Federal agency. -For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. -Provide total Federal awards expended for each individual Federal program and the Assistance Listings Number or other identifying number when the Assistance Listings information is not available. -Include the total amount provided to subrecipients from each Federal program. Condition / Context: The Organization management’s review and approval process did not detect the errors that were identified during the audit procedures performed. The errors detected consisted of the understatement of Federal Assistance Listing Numbers 14.239 and 14.218 in the amounts of $364,207 and $295,000, respectively, and an overstatement of Federal Assistance Listing Number 21.027 in the amount of $66,320, for a total net understatement of $592,887. Cause: The Organization’s internal controls over the preparation and review of the SEFA were not operating effectively. Material audit adjustments were proposed during the course of the audit that lead to material changes to the SEFA. Effect or Potential Effect: Inadequate controls over the preparation of the SEFA could result in financial misstatements or potential noncompliance. Questioned Costs: None Identification as a Repeat Finding: This is a repeat finding for Assistance Listing Number 14.239. See 2022-003. Recommendation: We recommend the Organization strengthen its policies, procedures, and controls for the identification of federal awards to ensure a complete and accurate SEFA is prepared in a timely manner. Views of Responsible Officials: Management agrees with the finding and is in the process of revising internal controls to address SEFA preparation.
Assistance Listing Number, Federal Agency, and Program Name ALN 20.205, Department of Transportation, Highway Planning and Construction Federal Transit Cluster, ALNs 20.500 (Federal Transit Capital Investment Grants), 20.507 (Federal Transit Formula Grants), 20.507 (COVID 19, Federal Transit Formula Grants), and 20.526 (Bus and Bus Facilities Formula Program & Discretionary Programs), Department of Transportation Federal Award Identification Number and Year ALN 20.205: STU M455 125, SHO M455 124, and STU CO60 086 ALN 20.500: 1138 2022 1 ALN 20.507: CO 2023 015 00, CO 2021 031, CO 2023 015 00, and CO 2023 014 (COVID 19) ALN 20.526: CO 2023 013 00, 1138 2023 4, 1138 2023 7, 1138 2023 3, CO 2022 003 00, and CO 2023 001 Pass through Entity ALN 20.205 Colorado Department of Transportation ALNs 20.500, 20.507, and 20.526 N/A Finding Type Material weakness Repeat Finding No Criteria According to 2 CFR 200.502, the determination of when a federal award is expended must be based on when the activity related to the federal award occurs. Generally, the activity pertains to the events that require the nonfederal entity to comply with federal status, regulations, and the terms and conditions of federal awards, such as expenditure/expense transactions associated with awards including grants. Per GASB Implementation Guide 2019 1 Question 4.7, in the absence of an executed grant agreement before the end of the reporting period, a government cannot establish that it has incurred allowable costs. Additionally, the applicable FTA section of the federal register for the grants in question indicates that "pre award authority is not a legal or implied commitment that the subject project will be approved for FTA assistance or that FTA will obligate federal funds." Condition The fiscal year 2023 schedule of expenditures of federal awards (SEFA) that was initially provided to the auditors was incorrect because it included expenditures related to fiscal year 2022, as well as expenditures that were incurred before an executed grant agreement was in place. Questioned Costs None Identification of How Questioned Costs Were Computed N/A Context The expenditures on the City's SEFA were misreported as follows: ALN 20.205, Highway Planning and Construction The expenditures reported on the initial SEFA included $641,174 that related to expenditures incurred in fiscal year 2022. ALNs 20.500, 20.507, and 20.526, Federal Transit Cluster The expenditures reported on the initial SEFA included $5,250,990 that related to expenditures incurred in prior fiscal years, or for which an executed grant agreement had not yet been received as of December 31, 2023. ALNs 20.507, 20.507 (COVID 19), and 20.526, Federal Transit Cluster The expenditures reported on the initial SEFA excluded $9,103,948 that related to expenditures incurred in fiscal year 2022, during which an executed grant agreement had not yet been received, but was received during the year ended December 31, 2023. Cause and Effect Related to the instance where fiscal year 2022 expenditures were reported on the fiscal year 2023 SEFA, the City reported federal expenditures in congruence with requests for reimbursement from the federal agency, rather than when the expenditures was incurred. Related to the Federal Transit Cluster, the City has historically interpreted pre award authority granted by the FTA as the trigger to recognized federal expenditures, even without an executed grant agreement. As a result, the SEFA in fiscal year 2023 was initially misstated requiring a restatement of the 2022 SEFA. These errors did impact major program determination, wherein ALN 20.205, Highway Planning and Construction, which was originally required to be tested in fiscal year 2023, did not need to be assessed as a major program based on the reissued 2022 SEFA. The final SEFA for fiscal year 2023 has been corrected for these errors. Recommendation The City should implement controls to ensure that the SEFA is prepared in accordance with applicable rules and regulations. Views of Responsible Officials and Corrective Action Plan Expenditures will be reported on the SEFA only for grant programs with an executed award regardless of the year incurred. SEFA preparation procedures have been updated to ensure analysis of grant execution date.
Assistance Listing Number, Federal Agency, and Program Name ALN 20.205, Department of Transportation, Highway Planning and Construction Federal Transit Cluster, ALNs 20.500 (Federal Transit Capital Investment Grants), 20.507 (Federal Transit Formula Grants), 20.507 (COVID 19, Federal Transit Formula Grants), and 20.526 (Bus and Bus Facilities Formula Program & Discretionary Programs), Department of Transportation Federal Award Identification Number and Year ALN 20.205: STU M455 125, SHO M455 124, and STU CO60 086 ALN 20.500: 1138 2022 1 ALN 20.507: CO 2023 015 00, CO 2021 031, CO 2023 015 00, and CO 2023 014 (COVID 19) ALN 20.526: CO 2023 013 00, 1138 2023 4, 1138 2023 7, 1138 2023 3, CO 2022 003 00, and CO 2023 001 Pass through Entity ALN 20.205 Colorado Department of Transportation ALNs 20.500, 20.507, and 20.526 N/A Finding Type Material weakness Repeat Finding No Criteria According to 2 CFR 200.502, the determination of when a federal award is expended must be based on when the activity related to the federal award occurs. Generally, the activity pertains to the events that require the nonfederal entity to comply with federal status, regulations, and the terms and conditions of federal awards, such as expenditure/expense transactions associated with awards including grants. Per GASB Implementation Guide 2019 1 Question 4.7, in the absence of an executed grant agreement before the end of the reporting period, a government cannot establish that it has incurred allowable costs. Additionally, the applicable FTA section of the federal register for the grants in question indicates that "pre award authority is not a legal or implied commitment that the subject project will be approved for FTA assistance or that FTA will obligate federal funds." Condition The fiscal year 2023 schedule of expenditures of federal awards (SEFA) that was initially provided to the auditors was incorrect because it included expenditures related to fiscal year 2022, as well as expenditures that were incurred before an executed grant agreement was in place. Questioned Costs None Identification of How Questioned Costs Were Computed N/A Context The expenditures on the City's SEFA were misreported as follows: ALN 20.205, Highway Planning and Construction The expenditures reported on the initial SEFA included $641,174 that related to expenditures incurred in fiscal year 2022. ALNs 20.500, 20.507, and 20.526, Federal Transit Cluster The expenditures reported on the initial SEFA included $5,250,990 that related to expenditures incurred in prior fiscal years, or for which an executed grant agreement had not yet been received as of December 31, 2023. ALNs 20.507, 20.507 (COVID 19), and 20.526, Federal Transit Cluster The expenditures reported on the initial SEFA excluded $9,103,948 that related to expenditures incurred in fiscal year 2022, during which an executed grant agreement had not yet been received, but was received during the year ended December 31, 2023. Cause and Effect Related to the instance where fiscal year 2022 expenditures were reported on the fiscal year 2023 SEFA, the City reported federal expenditures in congruence with requests for reimbursement from the federal agency, rather than when the expenditures was incurred. Related to the Federal Transit Cluster, the City has historically interpreted pre award authority granted by the FTA as the trigger to recognized federal expenditures, even without an executed grant agreement. As a result, the SEFA in fiscal year 2023 was initially misstated requiring a restatement of the 2022 SEFA. These errors did impact major program determination, wherein ALN 20.205, Highway Planning and Construction, which was originally required to be tested in fiscal year 2023, did not need to be assessed as a major program based on the reissued 2022 SEFA. The final SEFA for fiscal year 2023 has been corrected for these errors. Recommendation The City should implement controls to ensure that the SEFA is prepared in accordance with applicable rules and regulations. Views of Responsible Officials and Corrective Action Plan Expenditures will be reported on the SEFA only for grant programs with an executed award regardless of the year incurred. SEFA preparation procedures have been updated to ensure analysis of grant execution date.
Assistance Listing Number, Federal Agency, and Program Name ALN 20.205, Department of Transportation, Highway Planning and Construction Federal Transit Cluster, ALNs 20.500 (Federal Transit Capital Investment Grants), 20.507 (Federal Transit Formula Grants), 20.507 (COVID 19, Federal Transit Formula Grants), and 20.526 (Bus and Bus Facilities Formula Program & Discretionary Programs), Department of Transportation Federal Award Identification Number and Year ALN 20.205: STU M455 125, SHO M455 124, and STU CO60 086 ALN 20.500: 1138 2022 1 ALN 20.507: CO 2023 015 00, CO 2021 031, CO 2023 015 00, and CO 2023 014 (COVID 19) ALN 20.526: CO 2023 013 00, 1138 2023 4, 1138 2023 7, 1138 2023 3, CO 2022 003 00, and CO 2023 001 Pass through Entity ALN 20.205 Colorado Department of Transportation ALNs 20.500, 20.507, and 20.526 N/A Finding Type Material weakness Repeat Finding No Criteria According to 2 CFR 200.502, the determination of when a federal award is expended must be based on when the activity related to the federal award occurs. Generally, the activity pertains to the events that require the nonfederal entity to comply with federal status, regulations, and the terms and conditions of federal awards, such as expenditure/expense transactions associated with awards including grants. Per GASB Implementation Guide 2019 1 Question 4.7, in the absence of an executed grant agreement before the end of the reporting period, a government cannot establish that it has incurred allowable costs. Additionally, the applicable FTA section of the federal register for the grants in question indicates that "pre award authority is not a legal or implied commitment that the subject project will be approved for FTA assistance or that FTA will obligate federal funds." Condition The fiscal year 2023 schedule of expenditures of federal awards (SEFA) that was initially provided to the auditors was incorrect because it included expenditures related to fiscal year 2022, as well as expenditures that were incurred before an executed grant agreement was in place. Questioned Costs None Identification of How Questioned Costs Were Computed N/A Context The expenditures on the City's SEFA were misreported as follows: ALN 20.205, Highway Planning and Construction The expenditures reported on the initial SEFA included $641,174 that related to expenditures incurred in fiscal year 2022. ALNs 20.500, 20.507, and 20.526, Federal Transit Cluster The expenditures reported on the initial SEFA included $5,250,990 that related to expenditures incurred in prior fiscal years, or for which an executed grant agreement had not yet been received as of December 31, 2023. ALNs 20.507, 20.507 (COVID 19), and 20.526, Federal Transit Cluster The expenditures reported on the initial SEFA excluded $9,103,948 that related to expenditures incurred in fiscal year 2022, during which an executed grant agreement had not yet been received, but was received during the year ended December 31, 2023. Cause and Effect Related to the instance where fiscal year 2022 expenditures were reported on the fiscal year 2023 SEFA, the City reported federal expenditures in congruence with requests for reimbursement from the federal agency, rather than when the expenditures was incurred. Related to the Federal Transit Cluster, the City has historically interpreted pre award authority granted by the FTA as the trigger to recognized federal expenditures, even without an executed grant agreement. As a result, the SEFA in fiscal year 2023 was initially misstated requiring a restatement of the 2022 SEFA. These errors did impact major program determination, wherein ALN 20.205, Highway Planning and Construction, which was originally required to be tested in fiscal year 2023, did not need to be assessed as a major program based on the reissued 2022 SEFA. The final SEFA for fiscal year 2023 has been corrected for these errors. Recommendation The City should implement controls to ensure that the SEFA is prepared in accordance with applicable rules and regulations. Views of Responsible Officials and Corrective Action Plan Expenditures will be reported on the SEFA only for grant programs with an executed award regardless of the year incurred. SEFA preparation procedures have been updated to ensure analysis of grant execution date.
Assistance Listing Number, Federal Agency, and Program Name ALN 20.205, Department of Transportation, Highway Planning and Construction Federal Transit Cluster, ALNs 20.500 (Federal Transit Capital Investment Grants), 20.507 (Federal Transit Formula Grants), 20.507 (COVID 19, Federal Transit Formula Grants), and 20.526 (Bus and Bus Facilities Formula Program & Discretionary Programs), Department of Transportation Federal Award Identification Number and Year ALN 20.205: STU M455 125, SHO M455 124, and STU CO60 086 ALN 20.500: 1138 2022 1 ALN 20.507: CO 2023 015 00, CO 2021 031, CO 2023 015 00, and CO 2023 014 (COVID 19) ALN 20.526: CO 2023 013 00, 1138 2023 4, 1138 2023 7, 1138 2023 3, CO 2022 003 00, and CO 2023 001 Pass through Entity ALN 20.205 Colorado Department of Transportation ALNs 20.500, 20.507, and 20.526 N/A Finding Type Material weakness Repeat Finding No Criteria According to 2 CFR 200.502, the determination of when a federal award is expended must be based on when the activity related to the federal award occurs. Generally, the activity pertains to the events that require the nonfederal entity to comply with federal status, regulations, and the terms and conditions of federal awards, such as expenditure/expense transactions associated with awards including grants. Per GASB Implementation Guide 2019 1 Question 4.7, in the absence of an executed grant agreement before the end of the reporting period, a government cannot establish that it has incurred allowable costs. Additionally, the applicable FTA section of the federal register for the grants in question indicates that "pre award authority is not a legal or implied commitment that the subject project will be approved for FTA assistance or that FTA will obligate federal funds." Condition The fiscal year 2023 schedule of expenditures of federal awards (SEFA) that was initially provided to the auditors was incorrect because it included expenditures related to fiscal year 2022, as well as expenditures that were incurred before an executed grant agreement was in place. Questioned Costs None Identification of How Questioned Costs Were Computed N/A Context The expenditures on the City's SEFA were misreported as follows: ALN 20.205, Highway Planning and Construction The expenditures reported on the initial SEFA included $641,174 that related to expenditures incurred in fiscal year 2022. ALNs 20.500, 20.507, and 20.526, Federal Transit Cluster The expenditures reported on the initial SEFA included $5,250,990 that related to expenditures incurred in prior fiscal years, or for which an executed grant agreement had not yet been received as of December 31, 2023. ALNs 20.507, 20.507 (COVID 19), and 20.526, Federal Transit Cluster The expenditures reported on the initial SEFA excluded $9,103,948 that related to expenditures incurred in fiscal year 2022, during which an executed grant agreement had not yet been received, but was received during the year ended December 31, 2023. Cause and Effect Related to the instance where fiscal year 2022 expenditures were reported on the fiscal year 2023 SEFA, the City reported federal expenditures in congruence with requests for reimbursement from the federal agency, rather than when the expenditures was incurred. Related to the Federal Transit Cluster, the City has historically interpreted pre award authority granted by the FTA as the trigger to recognized federal expenditures, even without an executed grant agreement. As a result, the SEFA in fiscal year 2023 was initially misstated requiring a restatement of the 2022 SEFA. These errors did impact major program determination, wherein ALN 20.205, Highway Planning and Construction, which was originally required to be tested in fiscal year 2023, did not need to be assessed as a major program based on the reissued 2022 SEFA. The final SEFA for fiscal year 2023 has been corrected for these errors. Recommendation The City should implement controls to ensure that the SEFA is prepared in accordance with applicable rules and regulations. Views of Responsible Officials and Corrective Action Plan Expenditures will be reported on the SEFA only for grant programs with an executed award regardless of the year incurred. SEFA preparation procedures have been updated to ensure analysis of grant execution date.
Assistance Listing Number, Federal Agency, and Program Name ALN 20.205, Department of Transportation, Highway Planning and Construction Federal Transit Cluster, ALNs 20.500 (Federal Transit Capital Investment Grants), 20.507 (Federal Transit Formula Grants), 20.507 (COVID 19, Federal Transit Formula Grants), and 20.526 (Bus and Bus Facilities Formula Program & Discretionary Programs), Department of Transportation Federal Award Identification Number and Year ALN 20.205: STU M455 125, SHO M455 124, and STU CO60 086 ALN 20.500: 1138 2022 1 ALN 20.507: CO 2023 015 00, CO 2021 031, CO 2023 015 00, and CO 2023 014 (COVID 19) ALN 20.526: CO 2023 013 00, 1138 2023 4, 1138 2023 7, 1138 2023 3, CO 2022 003 00, and CO 2023 001 Pass through Entity ALN 20.205 Colorado Department of Transportation ALNs 20.500, 20.507, and 20.526 N/A Finding Type Material weakness Repeat Finding No Criteria According to 2 CFR 200.502, the determination of when a federal award is expended must be based on when the activity related to the federal award occurs. Generally, the activity pertains to the events that require the nonfederal entity to comply with federal status, regulations, and the terms and conditions of federal awards, such as expenditure/expense transactions associated with awards including grants. Per GASB Implementation Guide 2019 1 Question 4.7, in the absence of an executed grant agreement before the end of the reporting period, a government cannot establish that it has incurred allowable costs. Additionally, the applicable FTA section of the federal register for the grants in question indicates that "pre award authority is not a legal or implied commitment that the subject project will be approved for FTA assistance or that FTA will obligate federal funds." Condition The fiscal year 2023 schedule of expenditures of federal awards (SEFA) that was initially provided to the auditors was incorrect because it included expenditures related to fiscal year 2022, as well as expenditures that were incurred before an executed grant agreement was in place. Questioned Costs None Identification of How Questioned Costs Were Computed N/A Context The expenditures on the City's SEFA were misreported as follows: ALN 20.205, Highway Planning and Construction The expenditures reported on the initial SEFA included $641,174 that related to expenditures incurred in fiscal year 2022. ALNs 20.500, 20.507, and 20.526, Federal Transit Cluster The expenditures reported on the initial SEFA included $5,250,990 that related to expenditures incurred in prior fiscal years, or for which an executed grant agreement had not yet been received as of December 31, 2023. ALNs 20.507, 20.507 (COVID 19), and 20.526, Federal Transit Cluster The expenditures reported on the initial SEFA excluded $9,103,948 that related to expenditures incurred in fiscal year 2022, during which an executed grant agreement had not yet been received, but was received during the year ended December 31, 2023. Cause and Effect Related to the instance where fiscal year 2022 expenditures were reported on the fiscal year 2023 SEFA, the City reported federal expenditures in congruence with requests for reimbursement from the federal agency, rather than when the expenditures was incurred. Related to the Federal Transit Cluster, the City has historically interpreted pre award authority granted by the FTA as the trigger to recognized federal expenditures, even without an executed grant agreement. As a result, the SEFA in fiscal year 2023 was initially misstated requiring a restatement of the 2022 SEFA. These errors did impact major program determination, wherein ALN 20.205, Highway Planning and Construction, which was originally required to be tested in fiscal year 2023, did not need to be assessed as a major program based on the reissued 2022 SEFA. The final SEFA for fiscal year 2023 has been corrected for these errors. Recommendation The City should implement controls to ensure that the SEFA is prepared in accordance with applicable rules and regulations. Views of Responsible Officials and Corrective Action Plan Expenditures will be reported on the SEFA only for grant programs with an executed award regardless of the year incurred. SEFA preparation procedures have been updated to ensure analysis of grant execution date.
Assistance Listing Number, Federal Agency, and Program Name ALN 20.205, Department of Transportation, Highway Planning and Construction Federal Transit Cluster, ALNs 20.500 (Federal Transit Capital Investment Grants), 20.507 (Federal Transit Formula Grants), 20.507 (COVID 19, Federal Transit Formula Grants), and 20.526 (Bus and Bus Facilities Formula Program & Discretionary Programs), Department of Transportation Federal Award Identification Number and Year ALN 20.205: STU M455 125, SHO M455 124, and STU CO60 086 ALN 20.500: 1138 2022 1 ALN 20.507: CO 2023 015 00, CO 2021 031, CO 2023 015 00, and CO 2023 014 (COVID 19) ALN 20.526: CO 2023 013 00, 1138 2023 4, 1138 2023 7, 1138 2023 3, CO 2022 003 00, and CO 2023 001 Pass through Entity ALN 20.205 Colorado Department of Transportation ALNs 20.500, 20.507, and 20.526 N/A Finding Type Material weakness Repeat Finding No Criteria According to 2 CFR 200.502, the determination of when a federal award is expended must be based on when the activity related to the federal award occurs. Generally, the activity pertains to the events that require the nonfederal entity to comply with federal status, regulations, and the terms and conditions of federal awards, such as expenditure/expense transactions associated with awards including grants. Per GASB Implementation Guide 2019 1 Question 4.7, in the absence of an executed grant agreement before the end of the reporting period, a government cannot establish that it has incurred allowable costs. Additionally, the applicable FTA section of the federal register for the grants in question indicates that "pre award authority is not a legal or implied commitment that the subject project will be approved for FTA assistance or that FTA will obligate federal funds." Condition The fiscal year 2023 schedule of expenditures of federal awards (SEFA) that was initially provided to the auditors was incorrect because it included expenditures related to fiscal year 2022, as well as expenditures that were incurred before an executed grant agreement was in place. Questioned Costs None Identification of How Questioned Costs Were Computed N/A Context The expenditures on the City's SEFA were misreported as follows: ALN 20.205, Highway Planning and Construction The expenditures reported on the initial SEFA included $641,174 that related to expenditures incurred in fiscal year 2022. ALNs 20.500, 20.507, and 20.526, Federal Transit Cluster The expenditures reported on the initial SEFA included $5,250,990 that related to expenditures incurred in prior fiscal years, or for which an executed grant agreement had not yet been received as of December 31, 2023. ALNs 20.507, 20.507 (COVID 19), and 20.526, Federal Transit Cluster The expenditures reported on the initial SEFA excluded $9,103,948 that related to expenditures incurred in fiscal year 2022, during which an executed grant agreement had not yet been received, but was received during the year ended December 31, 2023. Cause and Effect Related to the instance where fiscal year 2022 expenditures were reported on the fiscal year 2023 SEFA, the City reported federal expenditures in congruence with requests for reimbursement from the federal agency, rather than when the expenditures was incurred. Related to the Federal Transit Cluster, the City has historically interpreted pre award authority granted by the FTA as the trigger to recognized federal expenditures, even without an executed grant agreement. As a result, the SEFA in fiscal year 2023 was initially misstated requiring a restatement of the 2022 SEFA. These errors did impact major program determination, wherein ALN 20.205, Highway Planning and Construction, which was originally required to be tested in fiscal year 2023, did not need to be assessed as a major program based on the reissued 2022 SEFA. The final SEFA for fiscal year 2023 has been corrected for these errors. Recommendation The City should implement controls to ensure that the SEFA is prepared in accordance with applicable rules and regulations. Views of Responsible Officials and Corrective Action Plan Expenditures will be reported on the SEFA only for grant programs with an executed award regardless of the year incurred. SEFA preparation procedures have been updated to ensure analysis of grant execution date.
Assistance Listing Number, Federal Agency, and Program Name ALN 20.205, Department of Transportation, Highway Planning and Construction Federal Transit Cluster, ALNs 20.500 (Federal Transit Capital Investment Grants), 20.507 (Federal Transit Formula Grants), 20.507 (COVID 19, Federal Transit Formula Grants), and 20.526 (Bus and Bus Facilities Formula Program & Discretionary Programs), Department of Transportation Federal Award Identification Number and Year ALN 20.205: STU M455 125, SHO M455 124, and STU CO60 086 ALN 20.500: 1138 2022 1 ALN 20.507: CO 2023 015 00, CO 2021 031, CO 2023 015 00, and CO 2023 014 (COVID 19) ALN 20.526: CO 2023 013 00, 1138 2023 4, 1138 2023 7, 1138 2023 3, CO 2022 003 00, and CO 2023 001 Pass through Entity ALN 20.205 Colorado Department of Transportation ALNs 20.500, 20.507, and 20.526 N/A Finding Type Material weakness Repeat Finding No Criteria According to 2 CFR 200.502, the determination of when a federal award is expended must be based on when the activity related to the federal award occurs. Generally, the activity pertains to the events that require the nonfederal entity to comply with federal status, regulations, and the terms and conditions of federal awards, such as expenditure/expense transactions associated with awards including grants. Per GASB Implementation Guide 2019 1 Question 4.7, in the absence of an executed grant agreement before the end of the reporting period, a government cannot establish that it has incurred allowable costs. Additionally, the applicable FTA section of the federal register for the grants in question indicates that "pre award authority is not a legal or implied commitment that the subject project will be approved for FTA assistance or that FTA will obligate federal funds." Condition The fiscal year 2023 schedule of expenditures of federal awards (SEFA) that was initially provided to the auditors was incorrect because it included expenditures related to fiscal year 2022, as well as expenditures that were incurred before an executed grant agreement was in place. Questioned Costs None Identification of How Questioned Costs Were Computed N/A Context The expenditures on the City's SEFA were misreported as follows: ALN 20.205, Highway Planning and Construction The expenditures reported on the initial SEFA included $641,174 that related to expenditures incurred in fiscal year 2022. ALNs 20.500, 20.507, and 20.526, Federal Transit Cluster The expenditures reported on the initial SEFA included $5,250,990 that related to expenditures incurred in prior fiscal years, or for which an executed grant agreement had not yet been received as of December 31, 2023. ALNs 20.507, 20.507 (COVID 19), and 20.526, Federal Transit Cluster The expenditures reported on the initial SEFA excluded $9,103,948 that related to expenditures incurred in fiscal year 2022, during which an executed grant agreement had not yet been received, but was received during the year ended December 31, 2023. Cause and Effect Related to the instance where fiscal year 2022 expenditures were reported on the fiscal year 2023 SEFA, the City reported federal expenditures in congruence with requests for reimbursement from the federal agency, rather than when the expenditures was incurred. Related to the Federal Transit Cluster, the City has historically interpreted pre award authority granted by the FTA as the trigger to recognized federal expenditures, even without an executed grant agreement. As a result, the SEFA in fiscal year 2023 was initially misstated requiring a restatement of the 2022 SEFA. These errors did impact major program determination, wherein ALN 20.205, Highway Planning and Construction, which was originally required to be tested in fiscal year 2023, did not need to be assessed as a major program based on the reissued 2022 SEFA. The final SEFA for fiscal year 2023 has been corrected for these errors. Recommendation The City should implement controls to ensure that the SEFA is prepared in accordance with applicable rules and regulations. Views of Responsible Officials and Corrective Action Plan Expenditures will be reported on the SEFA only for grant programs with an executed award regardless of the year incurred. SEFA preparation procedures have been updated to ensure analysis of grant execution date.
Assistance Listing Number, Federal Agency, and Program Name ALN 20.205, Department of Transportation, Highway Planning and Construction Federal Transit Cluster, ALNs 20.500 (Federal Transit Capital Investment Grants), 20.507 (Federal Transit Formula Grants), 20.507 (COVID 19, Federal Transit Formula Grants), and 20.526 (Bus and Bus Facilities Formula Program & Discretionary Programs), Department of Transportation Federal Award Identification Number and Year ALN 20.205: STU M455 125, SHO M455 124, and STU CO60 086 ALN 20.500: 1138 2022 1 ALN 20.507: CO 2023 015 00, CO 2021 031, CO 2023 015 00, and CO 2023 014 (COVID 19) ALN 20.526: CO 2023 013 00, 1138 2023 4, 1138 2023 7, 1138 2023 3, CO 2022 003 00, and CO 2023 001 Pass through Entity ALN 20.205 Colorado Department of Transportation ALNs 20.500, 20.507, and 20.526 N/A Finding Type Material weakness Repeat Finding No Criteria According to 2 CFR 200.502, the determination of when a federal award is expended must be based on when the activity related to the federal award occurs. Generally, the activity pertains to the events that require the nonfederal entity to comply with federal status, regulations, and the terms and conditions of federal awards, such as expenditure/expense transactions associated with awards including grants. Per GASB Implementation Guide 2019 1 Question 4.7, in the absence of an executed grant agreement before the end of the reporting period, a government cannot establish that it has incurred allowable costs. Additionally, the applicable FTA section of the federal register for the grants in question indicates that "pre award authority is not a legal or implied commitment that the subject project will be approved for FTA assistance or that FTA will obligate federal funds." Condition The fiscal year 2023 schedule of expenditures of federal awards (SEFA) that was initially provided to the auditors was incorrect because it included expenditures related to fiscal year 2022, as well as expenditures that were incurred before an executed grant agreement was in place. Questioned Costs None Identification of How Questioned Costs Were Computed N/A Context The expenditures on the City's SEFA were misreported as follows: ALN 20.205, Highway Planning and Construction The expenditures reported on the initial SEFA included $641,174 that related to expenditures incurred in fiscal year 2022. ALNs 20.500, 20.507, and 20.526, Federal Transit Cluster The expenditures reported on the initial SEFA included $5,250,990 that related to expenditures incurred in prior fiscal years, or for which an executed grant agreement had not yet been received as of December 31, 2023. ALNs 20.507, 20.507 (COVID 19), and 20.526, Federal Transit Cluster The expenditures reported on the initial SEFA excluded $9,103,948 that related to expenditures incurred in fiscal year 2022, during which an executed grant agreement had not yet been received, but was received during the year ended December 31, 2023. Cause and Effect Related to the instance where fiscal year 2022 expenditures were reported on the fiscal year 2023 SEFA, the City reported federal expenditures in congruence with requests for reimbursement from the federal agency, rather than when the expenditures was incurred. Related to the Federal Transit Cluster, the City has historically interpreted pre award authority granted by the FTA as the trigger to recognized federal expenditures, even without an executed grant agreement. As a result, the SEFA in fiscal year 2023 was initially misstated requiring a restatement of the 2022 SEFA. These errors did impact major program determination, wherein ALN 20.205, Highway Planning and Construction, which was originally required to be tested in fiscal year 2023, did not need to be assessed as a major program based on the reissued 2022 SEFA. The final SEFA for fiscal year 2023 has been corrected for these errors. Recommendation The City should implement controls to ensure that the SEFA is prepared in accordance with applicable rules and regulations. Views of Responsible Officials and Corrective Action Plan Expenditures will be reported on the SEFA only for grant programs with an executed award regardless of the year incurred. SEFA preparation procedures have been updated to ensure analysis of grant execution date.
2023-002: Material Weakness: Preparation of Schedule of Expenditures of Federal Awards Criteria: The Code of Federal Regulations (CFR) section 200.510 (b) states that, the auditee must prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee's financial statements and must include the total federal awards expended as determined in accordance with section 200.502- Financial Management and must include at minimum the following: (1) list of individual federal programs by federal agency (2) for federal awards received as a subrecipient, the name and number of the pass-through entity (3) federal awards expended for each individual federal program and the Assistance Listings Number (4) include the total amount provided to subrecipients from each Federal program. (5) include notes that describe significant accounting policies used in preparing the schedule, loan or loan guarantee programs, and whether the auditee elected to use the 10% de minimis cost rate. Financial management section 200.502 (a) states that the auditee’s financial management systems, including records documenting compliance with federal statutes, regulations, and the terms and conditions of the federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. (b) The financial management system must provide for the following: (1) identification of all federal awards received and expended (2) accurate, current, and complete disclosure of the financial results of each federal award or program (3) records that identify adequately the source and application of funds for federally-funded activities (4) effective control over, and accountability for, all funds, property, and other assets (5) comparison of expenditures with budget amounts for each Federal award (6) written procedures to implement the requirements of section 200.305 (7) written procedures for determining the allowability of costs in accordance with Subpart E and the terms and conditions of the federal award. Condition: During the audit of the December 31, 2023 Schedule of Expenditures of Federal Awards (SEFA) prepared by management, we noted that controls over the preparation of the SEFA were not properly designed, therefore did not include the required federal award information and did not report all 2023 federal awards and related expenditures. Cause: The Organization has not implemented policies or procedures, to the degree necessary, to ensure that the SEFA is reconciled at year-end and that the schedule includes all federal awards and related expenditures. Effect: Audit procedures identified additional federal award expenditures and adjustments were required to be made to the final SEFA. Recommendation: We recommend that management of the Organization implement policies, procedures, and internal controls to ensure that federal expenditures are tracked in a manner that reflects that federal funds have been used and reported in accordance with federal regulations. Views of Responsible Officials: Management agrees with this finding and their response is included in the corrective action plan.
2023-002: Material Weakness: Preparation of Schedule of Expenditures of Federal Awards Criteria: The Code of Federal Regulations (CFR) section 200.510 (b) states that, the auditee must prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee's financial statements and must include the total federal awards expended as determined in accordance with section 200.502- Financial Management and must include at minimum the following: (1) list of individual federal programs by federal agency (2) for federal awards received as a subrecipient, the name and number of the pass-through entity (3) federal awards expended for each individual federal program and the Assistance Listings Number (4) include the total amount provided to subrecipients from each Federal program. (5) include notes that describe significant accounting policies used in preparing the schedule, loan or loan guarantee programs, and whether the auditee elected to use the 10% de minimis cost rate. Financial management section 200.502 (a) states that the auditee’s financial management systems, including records documenting compliance with federal statutes, regulations, and the terms and conditions of the federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. (b) The financial management system must provide for the following: (1) identification of all federal awards received and expended (2) accurate, current, and complete disclosure of the financial results of each federal award or program (3) records that identify adequately the source and application of funds for federally-funded activities (4) effective control over, and accountability for, all funds, property, and other assets (5) comparison of expenditures with budget amounts for each Federal award (6) written procedures to implement the requirements of section 200.305 (7) written procedures for determining the allowability of costs in accordance with Subpart E and the terms and conditions of the federal award. Condition: During the audit of the December 31, 2023 Schedule of Expenditures of Federal Awards (SEFA) prepared by management, we noted that controls over the preparation of the SEFA were not properly designed, therefore did not include the required federal award information and did not report all 2023 federal awards and related expenditures. Cause: The Organization has not implemented policies or procedures, to the degree necessary, to ensure that the SEFA is reconciled at year-end and that the schedule includes all federal awards and related expenditures. Effect: Audit procedures identified additional federal award expenditures and adjustments were required to be made to the final SEFA. Recommendation: We recommend that management of the Organization implement policies, procedures, and internal controls to ensure that federal expenditures are tracked in a manner that reflects that federal funds have been used and reported in accordance with federal regulations. Views of Responsible Officials: Management agrees with this finding and their response is included in the corrective action plan.
2023-002: Material Weakness: Preparation of Schedule of Expenditures of Federal Awards Criteria: The Code of Federal Regulations (CFR) section 200.510 (b) states that, the auditee must prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee's financial statements and must include the total federal awards expended as determined in accordance with section 200.502- Financial Management and must include at minimum the following: (1) list of individual federal programs by federal agency (2) for federal awards received as a subrecipient, the name and number of the pass-through entity (3) federal awards expended for each individual federal program and the Assistance Listings Number (4) include the total amount provided to subrecipients from each Federal program. (5) include notes that describe significant accounting policies used in preparing the schedule, loan or loan guarantee programs, and whether the auditee elected to use the 10% de minimis cost rate. Financial management section 200.502 (a) states that the auditee’s financial management systems, including records documenting compliance with federal statutes, regulations, and the terms and conditions of the federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. (b) The financial management system must provide for the following: (1) identification of all federal awards received and expended (2) accurate, current, and complete disclosure of the financial results of each federal award or program (3) records that identify adequately the source and application of funds for federally-funded activities (4) effective control over, and accountability for, all funds, property, and other assets (5) comparison of expenditures with budget amounts for each Federal award (6) written procedures to implement the requirements of section 200.305 (7) written procedures for determining the allowability of costs in accordance with Subpart E and the terms and conditions of the federal award. Condition: During the audit of the December 31, 2023 Schedule of Expenditures of Federal Awards (SEFA) prepared by management, we noted that controls over the preparation of the SEFA were not properly designed, therefore did not include the required federal award information and did not report all 2023 federal awards and related expenditures. Cause: The Organization has not implemented policies or procedures, to the degree necessary, to ensure that the SEFA is reconciled at year-end and that the schedule includes all federal awards and related expenditures. Effect: Audit procedures identified additional federal award expenditures and adjustments were required to be made to the final SEFA. Recommendation: We recommend that management of the Organization implement policies, procedures, and internal controls to ensure that federal expenditures are tracked in a manner that reflects that federal funds have been used and reported in accordance with federal regulations. Views of Responsible Officials: Management agrees with this finding and their response is included in the corrective action plan.
Material Weakness/Noncompliance – Other 2 CFR §200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a. List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. For example, the National Institutes of Health is a major subdivision in the Department of Health and Human Services. b. For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c. Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d. Include the total amount provided to subrecipients from each Federal program. e. For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f. Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The Village did not prepare a Schedule of Expenditures of Federal Awards. Not preparing the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the Village and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the Village review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Material Weakness/Noncompliance – Other 2 CFR §200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a. List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. For example, the National Institutes of Health is a major subdivision in the Department of Health and Human Services. b. For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c. Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d. Include the total amount provided to subrecipients from each Federal program. e. For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f. Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The Village did not prepare a Schedule of Expenditures of Federal Awards. Not preparing the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the Village and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the Village review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Material Weakness/Noncompliance – Other 2 CFR §200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a. List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. For example, the National Institutes of Health is a major subdivision in the Department of Health and Human Services. b. For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c. Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d. Include the total amount provided to subrecipients from each Federal program. e. For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f. Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The Village did not prepare a Schedule of Expenditures of Federal Awards. Not preparing the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the Village and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the Village review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Federal Award Findings and Questioned Costs - Continued Finding 2023-008 Issue: Identification of Federal Awards and Preparation of a Complete and Accurate Schedule of Expenditures of Federal Awards (SEFA) Classification: Material Weakness Federal Agency: U.S. Department of Housing and Urban Development Federal Program: Community Development Block Grants/State's Program and Non-Entitlement Grants in Hawaii Assistance Listing Number: 14.228 Pass-Through Agency: NYS Office of Community Renewal Criteria: The Uniform Guidance requires the auditee to prepare a SEFA for the period covered by the auditee’s financial statement. It is the responsibility of the auditee's management to design and implement internal controls that provide reasonable assurance over the completeness and accuracy of the SEFA. The SEFA is the basis for the auditor’s identification of major programs. Condition: The City's initial SEFA provided for the audit was incomplete and contained inaccurate program expenditure amounts. In particular, there were multiple federal programs that were materially misstated; including the following major federal program for the year under audit: 1. ALN 14.228 Community Development Block Grants/State's Program and Non-Entitlement Grants in Hawaii In addition, there were multiple federal programs that were not identified on the initial SEFA for the year under audit: 1. ALN 20.600 / 20.616 Highway Safety Cluster 2. ALN 66.818 Brownfield Multipurpose, Assessment, Revolving Loan Fund, and Cleanup Cooperative Agreements 3. ALN 66.458 Capitalization Grants for Clean Water State Revolving Funds 4. ALN 93.568 Low-Income Home Energy Assistance 5. ALN 97.039 (COVID-19) Disaster Grants - Public Assistance (Presidentially Declared Disasters) Cause:The City does not have a method to accurately track the related expenditures for reporting. Effect or Potential Effect: A Uniform Guidance compliance audit is based on the premise that management must comply with federal statutes, regulations and the terms and conditions of the federal awards it receives. Without identifying the funds as federal, the auditee may not have complied with those requirements. In addition, there is increased risk regarding the accurate reporting of grant expenditures and noncompliance with policies and procedures surrounding the recording of federal awards. Questioned Costs:None. Context:The City was aware of the requirement to prepare a SEFA prior to the audit; however, they were not able to accumulate the appropriate records to correctly identify the source of funding for all ongoing projects. In addition, management was unable to accurately determine the amounts to be reported on the SEFA in accordance with 2 CFR §200.502. The adjustments to the SEFA amounted to an increase in Total Federal Expenditures reported of $253,510. Repeat Finding:This finding is not a repeat finding. Recommendation: We recommend the City develop and implement procedures to ensure that information related to all federal awards is accumulated to assist in the preparation of the SEFA. In addition, we recommend management of the City verify the completeness and accuracy of the amounts reported on the SEFA. Views of Responsible Officials of the Auditee:The City agrees with the finding.
Federal Award Findings and Questioned Costs - Continued Finding 2023-008 Issue: Identification of Federal Awards and Preparation of a Complete and Accurate Schedule of Expenditures of Federal Awards (SEFA) Classification: Material Weakness Federal Agency: U.S. Department of Housing and Urban Development Federal Program: Community Development Block Grants/State's Program and Non-Entitlement Grants in Hawaii Assistance Listing Number: 14.228 Pass-Through Agency: NYS Office of Community Renewal Criteria: The Uniform Guidance requires the auditee to prepare a SEFA for the period covered by the auditee’s financial statement. It is the responsibility of the auditee's management to design and implement internal controls that provide reasonable assurance over the completeness and accuracy of the SEFA. The SEFA is the basis for the auditor’s identification of major programs. Condition: The City's initial SEFA provided for the audit was incomplete and contained inaccurate program expenditure amounts. In particular, there were multiple federal programs that were materially misstated; including the following major federal program for the year under audit: 1. ALN 14.228 Community Development Block Grants/State's Program and Non-Entitlement Grants in Hawaii In addition, there were multiple federal programs that were not identified on the initial SEFA for the year under audit: 1. ALN 20.600 / 20.616 Highway Safety Cluster 2. ALN 66.818 Brownfield Multipurpose, Assessment, Revolving Loan Fund, and Cleanup Cooperative Agreements 3. ALN 66.458 Capitalization Grants for Clean Water State Revolving Funds 4. ALN 93.568 Low-Income Home Energy Assistance 5. ALN 97.039 (COVID-19) Disaster Grants - Public Assistance (Presidentially Declared Disasters) Cause:The City does not have a method to accurately track the related expenditures for reporting. Effect or Potential Effect: A Uniform Guidance compliance audit is based on the premise that management must comply with federal statutes, regulations and the terms and conditions of the federal awards it receives. Without identifying the funds as federal, the auditee may not have complied with those requirements. In addition, there is increased risk regarding the accurate reporting of grant expenditures and noncompliance with policies and procedures surrounding the recording of federal awards. Questioned Costs:None. Context:The City was aware of the requirement to prepare a SEFA prior to the audit; however, they were not able to accumulate the appropriate records to correctly identify the source of funding for all ongoing projects. In addition, management was unable to accurately determine the amounts to be reported on the SEFA in accordance with 2 CFR §200.502. The adjustments to the SEFA amounted to an increase in Total Federal Expenditures reported of $253,510. Repeat Finding:This finding is not a repeat finding. Recommendation: We recommend the City develop and implement procedures to ensure that information related to all federal awards is accumulated to assist in the preparation of the SEFA. In addition, we recommend management of the City verify the completeness and accuracy of the amounts reported on the SEFA. Views of Responsible Officials of the Auditee:The City agrees with the finding.
Federal Award Findings and Questioned Costs - Continued Finding 2023-008 Issue: Identification of Federal Awards and Preparation of a Complete and Accurate Schedule of Expenditures of Federal Awards (SEFA) Classification: Material Weakness Federal Agency: U.S. Department of Housing and Urban Development Federal Program: Community Development Block Grants/State's Program and Non-Entitlement Grants in Hawaii Assistance Listing Number: 14.228 Pass-Through Agency: NYS Office of Community Renewal Criteria: The Uniform Guidance requires the auditee to prepare a SEFA for the period covered by the auditee’s financial statement. It is the responsibility of the auditee's management to design and implement internal controls that provide reasonable assurance over the completeness and accuracy of the SEFA. The SEFA is the basis for the auditor’s identification of major programs. Condition: The City's initial SEFA provided for the audit was incomplete and contained inaccurate program expenditure amounts. In particular, there were multiple federal programs that were materially misstated; including the following major federal program for the year under audit: 1. ALN 14.228 Community Development Block Grants/State's Program and Non-Entitlement Grants in Hawaii In addition, there were multiple federal programs that were not identified on the initial SEFA for the year under audit: 1. ALN 20.600 / 20.616 Highway Safety Cluster 2. ALN 66.818 Brownfield Multipurpose, Assessment, Revolving Loan Fund, and Cleanup Cooperative Agreements 3. ALN 66.458 Capitalization Grants for Clean Water State Revolving Funds 4. ALN 93.568 Low-Income Home Energy Assistance 5. ALN 97.039 (COVID-19) Disaster Grants - Public Assistance (Presidentially Declared Disasters) Cause:The City does not have a method to accurately track the related expenditures for reporting. Effect or Potential Effect: A Uniform Guidance compliance audit is based on the premise that management must comply with federal statutes, regulations and the terms and conditions of the federal awards it receives. Without identifying the funds as federal, the auditee may not have complied with those requirements. In addition, there is increased risk regarding the accurate reporting of grant expenditures and noncompliance with policies and procedures surrounding the recording of federal awards. Questioned Costs:None. Context:The City was aware of the requirement to prepare a SEFA prior to the audit; however, they were not able to accumulate the appropriate records to correctly identify the source of funding for all ongoing projects. In addition, management was unable to accurately determine the amounts to be reported on the SEFA in accordance with 2 CFR §200.502. The adjustments to the SEFA amounted to an increase in Total Federal Expenditures reported of $253,510. Repeat Finding:This finding is not a repeat finding. Recommendation: We recommend the City develop and implement procedures to ensure that information related to all federal awards is accumulated to assist in the preparation of the SEFA. In addition, we recommend management of the City verify the completeness and accuracy of the amounts reported on the SEFA. Views of Responsible Officials of the Auditee:The City agrees with the finding.
Federal Award Findings and Questioned Costs - Continued Finding 2023-008 Issue: Identification of Federal Awards and Preparation of a Complete and Accurate Schedule of Expenditures of Federal Awards (SEFA) Classification: Material Weakness Federal Agency: U.S. Department of Housing and Urban Development Federal Program: Community Development Block Grants/State's Program and Non-Entitlement Grants in Hawaii Assistance Listing Number: 14.228 Pass-Through Agency: NYS Office of Community Renewal Criteria: The Uniform Guidance requires the auditee to prepare a SEFA for the period covered by the auditee’s financial statement. It is the responsibility of the auditee's management to design and implement internal controls that provide reasonable assurance over the completeness and accuracy of the SEFA. The SEFA is the basis for the auditor’s identification of major programs. Condition: The City's initial SEFA provided for the audit was incomplete and contained inaccurate program expenditure amounts. In particular, there were multiple federal programs that were materially misstated; including the following major federal program for the year under audit: 1. ALN 14.228 Community Development Block Grants/State's Program and Non-Entitlement Grants in Hawaii In addition, there were multiple federal programs that were not identified on the initial SEFA for the year under audit: 1. ALN 20.600 / 20.616 Highway Safety Cluster 2. ALN 66.818 Brownfield Multipurpose, Assessment, Revolving Loan Fund, and Cleanup Cooperative Agreements 3. ALN 66.458 Capitalization Grants for Clean Water State Revolving Funds 4. ALN 93.568 Low-Income Home Energy Assistance 5. ALN 97.039 (COVID-19) Disaster Grants - Public Assistance (Presidentially Declared Disasters) Cause:The City does not have a method to accurately track the related expenditures for reporting. Effect or Potential Effect: A Uniform Guidance compliance audit is based on the premise that management must comply with federal statutes, regulations and the terms and conditions of the federal awards it receives. Without identifying the funds as federal, the auditee may not have complied with those requirements. In addition, there is increased risk regarding the accurate reporting of grant expenditures and noncompliance with policies and procedures surrounding the recording of federal awards. Questioned Costs:None. Context:The City was aware of the requirement to prepare a SEFA prior to the audit; however, they were not able to accumulate the appropriate records to correctly identify the source of funding for all ongoing projects. In addition, management was unable to accurately determine the amounts to be reported on the SEFA in accordance with 2 CFR §200.502. The adjustments to the SEFA amounted to an increase in Total Federal Expenditures reported of $253,510. Repeat Finding:This finding is not a repeat finding. Recommendation: We recommend the City develop and implement procedures to ensure that information related to all federal awards is accumulated to assist in the preparation of the SEFA. In addition, we recommend management of the City verify the completeness and accuracy of the amounts reported on the SEFA. Views of Responsible Officials of the Auditee:The City agrees with the finding.
Federal Award Findings and Questioned Costs - Continued Finding 2023-008 Issue: Identification of Federal Awards and Preparation of a Complete and Accurate Schedule of Expenditures of Federal Awards (SEFA) Classification: Material Weakness Federal Agency: U.S. Department of Housing and Urban Development Federal Program: Community Development Block Grants/State's Program and Non-Entitlement Grants in Hawaii Assistance Listing Number: 14.228 Pass-Through Agency: NYS Office of Community Renewal Criteria: The Uniform Guidance requires the auditee to prepare a SEFA for the period covered by the auditee’s financial statement. It is the responsibility of the auditee's management to design and implement internal controls that provide reasonable assurance over the completeness and accuracy of the SEFA. The SEFA is the basis for the auditor’s identification of major programs. Condition: The City's initial SEFA provided for the audit was incomplete and contained inaccurate program expenditure amounts. In particular, there were multiple federal programs that were materially misstated; including the following major federal program for the year under audit: 1. ALN 14.228 Community Development Block Grants/State's Program and Non-Entitlement Grants in Hawaii In addition, there were multiple federal programs that were not identified on the initial SEFA for the year under audit: 1. ALN 20.600 / 20.616 Highway Safety Cluster 2. ALN 66.818 Brownfield Multipurpose, Assessment, Revolving Loan Fund, and Cleanup Cooperative Agreements 3. ALN 66.458 Capitalization Grants for Clean Water State Revolving Funds 4. ALN 93.568 Low-Income Home Energy Assistance 5. ALN 97.039 (COVID-19) Disaster Grants - Public Assistance (Presidentially Declared Disasters) Cause:The City does not have a method to accurately track the related expenditures for reporting. Effect or Potential Effect: A Uniform Guidance compliance audit is based on the premise that management must comply with federal statutes, regulations and the terms and conditions of the federal awards it receives. Without identifying the funds as federal, the auditee may not have complied with those requirements. In addition, there is increased risk regarding the accurate reporting of grant expenditures and noncompliance with policies and procedures surrounding the recording of federal awards. Questioned Costs:None. Context:The City was aware of the requirement to prepare a SEFA prior to the audit; however, they were not able to accumulate the appropriate records to correctly identify the source of funding for all ongoing projects. In addition, management was unable to accurately determine the amounts to be reported on the SEFA in accordance with 2 CFR §200.502. The adjustments to the SEFA amounted to an increase in Total Federal Expenditures reported of $253,510. Repeat Finding:This finding is not a repeat finding. Recommendation: We recommend the City develop and implement procedures to ensure that information related to all federal awards is accumulated to assist in the preparation of the SEFA. In addition, we recommend management of the City verify the completeness and accuracy of the amounts reported on the SEFA. Views of Responsible Officials of the Auditee:The City agrees with the finding.
Federal Award Findings and Questioned Costs - Continued Finding 2023-008 Issue: Identification of Federal Awards and Preparation of a Complete and Accurate Schedule of Expenditures of Federal Awards (SEFA) Classification: Material Weakness Federal Agency: U.S. Department of Housing and Urban Development Federal Program: Community Development Block Grants/State's Program and Non-Entitlement Grants in Hawaii Assistance Listing Number: 14.228 Pass-Through Agency: NYS Office of Community Renewal Criteria: The Uniform Guidance requires the auditee to prepare a SEFA for the period covered by the auditee’s financial statement. It is the responsibility of the auditee's management to design and implement internal controls that provide reasonable assurance over the completeness and accuracy of the SEFA. The SEFA is the basis for the auditor’s identification of major programs. Condition: The City's initial SEFA provided for the audit was incomplete and contained inaccurate program expenditure amounts. In particular, there were multiple federal programs that were materially misstated; including the following major federal program for the year under audit: 1. ALN 14.228 Community Development Block Grants/State's Program and Non-Entitlement Grants in Hawaii In addition, there were multiple federal programs that were not identified on the initial SEFA for the year under audit: 1. ALN 20.600 / 20.616 Highway Safety Cluster 2. ALN 66.818 Brownfield Multipurpose, Assessment, Revolving Loan Fund, and Cleanup Cooperative Agreements 3. ALN 66.458 Capitalization Grants for Clean Water State Revolving Funds 4. ALN 93.568 Low-Income Home Energy Assistance 5. ALN 97.039 (COVID-19) Disaster Grants - Public Assistance (Presidentially Declared Disasters) Cause:The City does not have a method to accurately track the related expenditures for reporting. Effect or Potential Effect: A Uniform Guidance compliance audit is based on the premise that management must comply with federal statutes, regulations and the terms and conditions of the federal awards it receives. Without identifying the funds as federal, the auditee may not have complied with those requirements. In addition, there is increased risk regarding the accurate reporting of grant expenditures and noncompliance with policies and procedures surrounding the recording of federal awards. Questioned Costs:None. Context:The City was aware of the requirement to prepare a SEFA prior to the audit; however, they were not able to accumulate the appropriate records to correctly identify the source of funding for all ongoing projects. In addition, management was unable to accurately determine the amounts to be reported on the SEFA in accordance with 2 CFR §200.502. The adjustments to the SEFA amounted to an increase in Total Federal Expenditures reported of $253,510. Repeat Finding:This finding is not a repeat finding. Recommendation: We recommend the City develop and implement procedures to ensure that information related to all federal awards is accumulated to assist in the preparation of the SEFA. In addition, we recommend management of the City verify the completeness and accuracy of the amounts reported on the SEFA. Views of Responsible Officials of the Auditee:The City agrees with the finding.
Criteria: 2 CFR Part 200 – Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, Subpart D – Post Federal Awards Requirements, Standards for Financial and Program Management, and §200.302 (b), Financial Management. Identification, in its accounts, of all federal awards received and expended and the federal program under which they were received. Federal program and federal award identification must include, as applicable, the federal assistance listing title and number, federal award identification number, name of the federal agency, and name of the pass-through entity, if any. Additional Criteria: 2 CFR Part 200 – Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, Subpart F – Audit Requirements, §200.510, Financial Statements. Schedule of Expenditures of Federal Awards – The auditee also must prepare a schedule of expenditures of federal awards for the period covered by the auditee’s financial statements, which must include the total federal awards expended, as determined in accordance with §200.502, Basis for Determining Federal Awards Expended. At a minimum, the schedule must provide total federal awards expended for each individual federal program and the federal assistance listing number or other identifying number when the federal assistance listing information is not available. For a cluster of programs, also provide the total for the cluster. Condition: PCRI did not maintain a complete schedule of expenditures of federal awards. Cause: PCRI did not adequately track which government grants were federally-funded, resulting in an incomplete schedule of expenditures of federal awards. Effect: Failure to prepare an accurate and complete schedule of expenditures of federal awards results in noncompliance with 2 CFR Part 200 – Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, Subpart D – Post Federal Awards Requirements, Standards for Financial and Program Management, §200.302, Financial Management, and Subpart F – Audit Requirements, §200.510, Financial Statements. Recommendation: We recommend that PCRI document and implement policies and procedures to ensure the schedule of expenditures of federal awards is accurate and complete in accordance with 2 CFR Part 200 – Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, Subpart D – Post Federal Awards Requirements, Standards for Financial and Program Management, §200.302, Financial Management, and Subpart F – Audit Requirements, §200.510, Financial Statements, in order to obtain accurate calculations of major federal programs for the Single Audit and to ensure that PCRI is in compliance with all of the reporting requirements as to identify the source and application of funds for federally-funded activities.
Criteria: 2 CFR Part 200 – Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, Subpart D – Post Federal Awards Requirements, Standards for Financial and Program Management, and §200.302 (b), Financial Management. Identification, in its accounts, of all federal awards received and expended and the federal program under which they were received. Federal program and federal award identification must include, as applicable, the federal assistance listing title and number, federal award identification number, name of the federal agency, and name of the pass-through entity, if any. Additional Criteria: 2 CFR Part 200 – Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, Subpart F – Audit Requirements, §200.510, Financial Statements. Schedule of Expenditures of Federal Awards – The auditee also must prepare a schedule of expenditures of federal awards for the period covered by the auditee’s financial statements, which must include the total federal awards expended, as determined in accordance with §200.502, Basis for Determining Federal Awards Expended. At a minimum, the schedule must provide total federal awards expended for each individual federal program and the federal assistance listing number or other identifying number when the federal assistance listing information is not available. For a cluster of programs, also provide the total for the cluster. Condition: PCRI did not maintain a complete schedule of expenditures of federal awards. Cause: PCRI did not adequately track which government grants were federally-funded, resulting in an incomplete schedule of expenditures of federal awards. Effect: Failure to prepare an accurate and complete schedule of expenditures of federal awards results in noncompliance with 2 CFR Part 200 – Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, Subpart D – Post Federal Awards Requirements, Standards for Financial and Program Management, §200.302, Financial Management, and Subpart F – Audit Requirements, §200.510, Financial Statements. Recommendation: We recommend that PCRI document and implement policies and procedures to ensure the schedule of expenditures of federal awards is accurate and complete in accordance with 2 CFR Part 200 – Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, Subpart D – Post Federal Awards Requirements, Standards for Financial and Program Management, §200.302, Financial Management, and Subpart F – Audit Requirements, §200.510, Financial Statements, in order to obtain accurate calculations of major federal programs for the Single Audit and to ensure that PCRI is in compliance with all of the reporting requirements as to identify the source and application of funds for federally-funded activities.
Federal Agency: U.S. Department of the TreasuryFederal Program Name: Emergency Rental Assistance Program (ERAP) Assistance Listing Number: 21.023 Federal Award Identification Number and Year: Various Pass-Through Agency: Pennsylvania Department of Health and Human Services Pass-Through Number(s): ERA-2101060067, ERA2-0391, ERAP2 Award Period: 1/1/2023 – 12/31/23 Type of Finding: Significant Deficiency in Internal Control Over Compliance Criteria or Specific RequirementUniform guidance requires the auditee to prepare a schedule of expenditures of federal awards (SEFA) which must include the total federal awards expended as determined in accordance with sub-section 200.502. 2 CFR 200.510. A non-federal entity must maintain effective internal control over the federal award (2 CFR 200.303).Condition and ContextPolicies and controls in place regarding the completeness of the SEFA were not properly functioning. Within the supporting listing of expenses relating to ERAP expenditures, six transactions were identified as prior fiscal-year expenditures that were included in the unadjusted 2023 expenditure total. The County revised the 2023 SEFA to exclude the 2022 expenditures. Questioned Costs$33,301 Cause Controls ensuring that only federal expenditures incurred in the period from January 1, 2023 to December 31, 2023 were not operating as designed.Effect Potential inaccurate expenditure reporting in the SEFA. Repeat Finding No.Recommendation We recommend management should review the process of recording federal expenditures to determine expenditures are being included in the appropriate fiscal year.Views of Responsible Officials There is no disagreement with the audit finding and the County is in the process of implementing corrective procedures.