Federal Agency: United States Department of Health and Human Services (HHS) Federal Program: R&D Provider Relief Fund Provider Relief Fund and American Rescue Plan (ARP) Rural Distribution (93.498) Federal Award Numbers: Various Federal Award Years: Various Reference: 2023 002 Criteria Internal Controls Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements of Federal Awards, (2 CFR 200) section 200.303(a) states, the non federal entity must establish and maintain effective internal control over the federal award that provides reasonable assurance that the non federal entity is managing the federal award in compliance with federal statues, 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). Condition BMC utilizes Infor, a could based system, as the entity’s general ledger. BMC management of Infor includes maintaining the application system layer of the IT control environment and relies on the Infor vendor to support infrastructure layers through SOC 1 reporting. Processes that support compliance and administration of the PRF and R&D programs rely on Infor IT application controls. During our test work, we noted the following deficiencies operating effectiveness of the general IT controls: 1) BMC did not have a process in place to perform and document a Infor User Access Review during the fiscal year. Upon audit inquiry, a review was performed to confirm there were no impacts to IT application controls configurations or processes. 2) For 4 of 15 employee termination access samples to the Infor system, it was determined the samples were not removed in a timely basis following the employee’s termination date. Upon audit inquiry, we obtained system documentation for the 4 users identified as exceptions indicating the related users did not logon to the system past their termination date. Cause The conditions above related to the following: 1) Management did not formally implement a process or policy to review user access due to reliance on preventative access controls and no established review requirements as of the fiscal year. 2) The exceptions occurred due to human oversight during the execution of the de provisioning process. Possible Asserted Effect Failure to have a reliable general IT control environment over logical access may result in unauthorized changes being made to Infor, which may result in erroneous reliance on the operating effectiveness of automated IT controls, over allowability. Failure to have effective internal controls over allowability may result in federal awards being utilized for unallowable expenditures not in accordance with the federal statues, regulations, and terms and conditions of federal awards. Questioned Costs Not applicable Statistical Sampling The sample was not intended to be, and was not, a statistically valid sample. Recommendation We recommend that management review and emphasize the access management policies and procedures with key personnel to help ensure that an Infor User Access Review is performed. Additionally, we recommend that management review and emphasize the logical access policies and procedures with key personnel responsible for the timely communication and removal of de provisioning of users. Views of Responsible Officials Recommendation accepted. Please refer to corrective action plan.
Federal Agency: United States Department of Health and Human Services (HHS) Federal Program: R&D Provider Relief Fund Provider Relief Fund and American Rescue Plan (ARP) Rural Distribution (93.498) Federal Award Numbers: Various Federal Award Years: Various Reference: 2023 002 Criteria Internal Controls Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements of Federal Awards, (2 CFR 200) section 200.303(a) states, the non federal entity must establish and maintain effective internal control over the federal award that provides reasonable assurance that the non federal entity is managing the federal award in compliance with federal statues, 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). Condition BMC utilizes Infor, a could based system, as the entity’s general ledger. BMC management of Infor includes maintaining the application system layer of the IT control environment and relies on the Infor vendor to support infrastructure layers through SOC 1 reporting. Processes that support compliance and administration of the PRF and R&D programs rely on Infor IT application controls. During our test work, we noted the following deficiencies operating effectiveness of the general IT controls: 1) BMC did not have a process in place to perform and document a Infor User Access Review during the fiscal year. Upon audit inquiry, a review was performed to confirm there were no impacts to IT application controls configurations or processes. 2) For 4 of 15 employee termination access samples to the Infor system, it was determined the samples were not removed in a timely basis following the employee’s termination date. Upon audit inquiry, we obtained system documentation for the 4 users identified as exceptions indicating the related users did not logon to the system past their termination date. Cause The conditions above related to the following: 1) Management did not formally implement a process or policy to review user access due to reliance on preventative access controls and no established review requirements as of the fiscal year. 2) The exceptions occurred due to human oversight during the execution of the de provisioning process. Possible Asserted Effect Failure to have a reliable general IT control environment over logical access may result in unauthorized changes being made to Infor, which may result in erroneous reliance on the operating effectiveness of automated IT controls, over allowability. Failure to have effective internal controls over allowability may result in federal awards being utilized for unallowable expenditures not in accordance with the federal statues, regulations, and terms and conditions of federal awards. Questioned Costs Not applicable Statistical Sampling The sample was not intended to be, and was not, a statistically valid sample. Recommendation We recommend that management review and emphasize the access management policies and procedures with key personnel to help ensure that an Infor User Access Review is performed. Additionally, we recommend that management review and emphasize the logical access policies and procedures with key personnel responsible for the timely communication and removal of de provisioning of users. Views of Responsible Officials Recommendation accepted. Please refer to corrective action plan.
Federal Agency: United States Department of Health and Human Services (HHS) Federal Program: R&D Provider Relief Fund Provider Relief Fund and American Rescue Plan (ARP) Rural Distribution (93.498) Federal Award Numbers: Various Federal Award Years: Various Reference: 2023 002 Criteria Internal Controls Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements of Federal Awards, (2 CFR 200) section 200.303(a) states, the non federal entity must establish and maintain effective internal control over the federal award that provides reasonable assurance that the non federal entity is managing the federal award in compliance with federal statues, 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). Condition BMC utilizes Infor, a could based system, as the entity’s general ledger. BMC management of Infor includes maintaining the application system layer of the IT control environment and relies on the Infor vendor to support infrastructure layers through SOC 1 reporting. Processes that support compliance and administration of the PRF and R&D programs rely on Infor IT application controls. During our test work, we noted the following deficiencies operating effectiveness of the general IT controls: 1) BMC did not have a process in place to perform and document a Infor User Access Review during the fiscal year. Upon audit inquiry, a review was performed to confirm there were no impacts to IT application controls configurations or processes. 2) For 4 of 15 employee termination access samples to the Infor system, it was determined the samples were not removed in a timely basis following the employee’s termination date. Upon audit inquiry, we obtained system documentation for the 4 users identified as exceptions indicating the related users did not logon to the system past their termination date. Cause The conditions above related to the following: 1) Management did not formally implement a process or policy to review user access due to reliance on preventative access controls and no established review requirements as of the fiscal year. 2) The exceptions occurred due to human oversight during the execution of the de provisioning process. Possible Asserted Effect Failure to have a reliable general IT control environment over logical access may result in unauthorized changes being made to Infor, which may result in erroneous reliance on the operating effectiveness of automated IT controls, over allowability. Failure to have effective internal controls over allowability may result in federal awards being utilized for unallowable expenditures not in accordance with the federal statues, regulations, and terms and conditions of federal awards. Questioned Costs Not applicable Statistical Sampling The sample was not intended to be, and was not, a statistically valid sample. Recommendation We recommend that management review and emphasize the access management policies and procedures with key personnel to help ensure that an Infor User Access Review is performed. Additionally, we recommend that management review and emphasize the logical access policies and procedures with key personnel responsible for the timely communication and removal of de provisioning of users. Views of Responsible Officials Recommendation accepted. Please refer to corrective action plan.
Federal Agency: United States Department of Health and Human Services (HHS) Federal Program: R&D Provider Relief Fund Provider Relief Fund and American Rescue Plan (ARP) Rural Distribution (93.498) Federal Award Numbers: Various Federal Award Years: Various Reference: 2023 002 Criteria Internal Controls Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements of Federal Awards, (2 CFR 200) section 200.303(a) states, the non federal entity must establish and maintain effective internal control over the federal award that provides reasonable assurance that the non federal entity is managing the federal award in compliance with federal statues, 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). Condition BMC utilizes Infor, a could based system, as the entity’s general ledger. BMC management of Infor includes maintaining the application system layer of the IT control environment and relies on the Infor vendor to support infrastructure layers through SOC 1 reporting. Processes that support compliance and administration of the PRF and R&D programs rely on Infor IT application controls. During our test work, we noted the following deficiencies operating effectiveness of the general IT controls: 1) BMC did not have a process in place to perform and document a Infor User Access Review during the fiscal year. Upon audit inquiry, a review was performed to confirm there were no impacts to IT application controls configurations or processes. 2) For 4 of 15 employee termination access samples to the Infor system, it was determined the samples were not removed in a timely basis following the employee’s termination date. Upon audit inquiry, we obtained system documentation for the 4 users identified as exceptions indicating the related users did not logon to the system past their termination date. Cause The conditions above related to the following: 1) Management did not formally implement a process or policy to review user access due to reliance on preventative access controls and no established review requirements as of the fiscal year. 2) The exceptions occurred due to human oversight during the execution of the de provisioning process. Possible Asserted Effect Failure to have a reliable general IT control environment over logical access may result in unauthorized changes being made to Infor, which may result in erroneous reliance on the operating effectiveness of automated IT controls, over allowability. Failure to have effective internal controls over allowability may result in federal awards being utilized for unallowable expenditures not in accordance with the federal statues, regulations, and terms and conditions of federal awards. Questioned Costs Not applicable Statistical Sampling The sample was not intended to be, and was not, a statistically valid sample. Recommendation We recommend that management review and emphasize the access management policies and procedures with key personnel to help ensure that an Infor User Access Review is performed. Additionally, we recommend that management review and emphasize the logical access policies and procedures with key personnel responsible for the timely communication and removal of de provisioning of users. Views of Responsible Officials Recommendation accepted. Please refer to corrective action plan.
Federal Agency: United States Department of Health and Human Services (HHS) Federal Program: R&D Provider Relief Fund Provider Relief Fund and American Rescue Plan (ARP) Rural Distribution (93.498) Federal Award Numbers: Various Federal Award Years: Various Reference: 2023 002 Criteria Internal Controls Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements of Federal Awards, (2 CFR 200) section 200.303(a) states, the non federal entity must establish and maintain effective internal control over the federal award that provides reasonable assurance that the non federal entity is managing the federal award in compliance with federal statues, 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). Condition BMC utilizes Infor, a could based system, as the entity’s general ledger. BMC management of Infor includes maintaining the application system layer of the IT control environment and relies on the Infor vendor to support infrastructure layers through SOC 1 reporting. Processes that support compliance and administration of the PRF and R&D programs rely on Infor IT application controls. During our test work, we noted the following deficiencies operating effectiveness of the general IT controls: 1) BMC did not have a process in place to perform and document a Infor User Access Review during the fiscal year. Upon audit inquiry, a review was performed to confirm there were no impacts to IT application controls configurations or processes. 2) For 4 of 15 employee termination access samples to the Infor system, it was determined the samples were not removed in a timely basis following the employee’s termination date. Upon audit inquiry, we obtained system documentation for the 4 users identified as exceptions indicating the related users did not logon to the system past their termination date. Cause The conditions above related to the following: 1) Management did not formally implement a process or policy to review user access due to reliance on preventative access controls and no established review requirements as of the fiscal year. 2) The exceptions occurred due to human oversight during the execution of the de provisioning process. Possible Asserted Effect Failure to have a reliable general IT control environment over logical access may result in unauthorized changes being made to Infor, which may result in erroneous reliance on the operating effectiveness of automated IT controls, over allowability. Failure to have effective internal controls over allowability may result in federal awards being utilized for unallowable expenditures not in accordance with the federal statues, regulations, and terms and conditions of federal awards. Questioned Costs Not applicable Statistical Sampling The sample was not intended to be, and was not, a statistically valid sample. Recommendation We recommend that management review and emphasize the access management policies and procedures with key personnel to help ensure that an Infor User Access Review is performed. Additionally, we recommend that management review and emphasize the logical access policies and procedures with key personnel responsible for the timely communication and removal of de provisioning of users. Views of Responsible Officials Recommendation accepted. Please refer to corrective action plan.
Federal Agency: United States Department of Health and Human Services (HHS) Federal Program: R&D Provider Relief Fund Provider Relief Fund and American Rescue Plan (ARP) Rural Distribution (93.498) Federal Award Numbers: Various Federal Award Years: Various Reference: 2023 002 Criteria Internal Controls Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements of Federal Awards, (2 CFR 200) section 200.303(a) states, the non federal entity must establish and maintain effective internal control over the federal award that provides reasonable assurance that the non federal entity is managing the federal award in compliance with federal statues, 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). Condition BMC utilizes Infor, a could based system, as the entity’s general ledger. BMC management of Infor includes maintaining the application system layer of the IT control environment and relies on the Infor vendor to support infrastructure layers through SOC 1 reporting. Processes that support compliance and administration of the PRF and R&D programs rely on Infor IT application controls. During our test work, we noted the following deficiencies operating effectiveness of the general IT controls: 1) BMC did not have a process in place to perform and document a Infor User Access Review during the fiscal year. Upon audit inquiry, a review was performed to confirm there were no impacts to IT application controls configurations or processes. 2) For 4 of 15 employee termination access samples to the Infor system, it was determined the samples were not removed in a timely basis following the employee’s termination date. Upon audit inquiry, we obtained system documentation for the 4 users identified as exceptions indicating the related users did not logon to the system past their termination date. Cause The conditions above related to the following: 1) Management did not formally implement a process or policy to review user access due to reliance on preventative access controls and no established review requirements as of the fiscal year. 2) The exceptions occurred due to human oversight during the execution of the de provisioning process. Possible Asserted Effect Failure to have a reliable general IT control environment over logical access may result in unauthorized changes being made to Infor, which may result in erroneous reliance on the operating effectiveness of automated IT controls, over allowability. Failure to have effective internal controls over allowability may result in federal awards being utilized for unallowable expenditures not in accordance with the federal statues, regulations, and terms and conditions of federal awards. Questioned Costs Not applicable Statistical Sampling The sample was not intended to be, and was not, a statistically valid sample. Recommendation We recommend that management review and emphasize the access management policies and procedures with key personnel to help ensure that an Infor User Access Review is performed. Additionally, we recommend that management review and emphasize the logical access policies and procedures with key personnel responsible for the timely communication and removal of de provisioning of users. Views of Responsible Officials Recommendation accepted. Please refer to corrective action plan.
Federal Agency: United States Department of Health and Human Services (HHS) Federal Program: R&D Provider Relief Fund Provider Relief Fund and American Rescue Plan (ARP) Rural Distribution (93.498) Federal Award Numbers: Various Federal Award Years: Various Reference: 2023 002 Criteria Internal Controls Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements of Federal Awards, (2 CFR 200) section 200.303(a) states, the non federal entity must establish and maintain effective internal control over the federal award that provides reasonable assurance that the non federal entity is managing the federal award in compliance with federal statues, 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). Condition BMC utilizes Infor, a could based system, as the entity’s general ledger. BMC management of Infor includes maintaining the application system layer of the IT control environment and relies on the Infor vendor to support infrastructure layers through SOC 1 reporting. Processes that support compliance and administration of the PRF and R&D programs rely on Infor IT application controls. During our test work, we noted the following deficiencies operating effectiveness of the general IT controls: 1) BMC did not have a process in place to perform and document a Infor User Access Review during the fiscal year. Upon audit inquiry, a review was performed to confirm there were no impacts to IT application controls configurations or processes. 2) For 4 of 15 employee termination access samples to the Infor system, it was determined the samples were not removed in a timely basis following the employee’s termination date. Upon audit inquiry, we obtained system documentation for the 4 users identified as exceptions indicating the related users did not logon to the system past their termination date. Cause The conditions above related to the following: 1) Management did not formally implement a process or policy to review user access due to reliance on preventative access controls and no established review requirements as of the fiscal year. 2) The exceptions occurred due to human oversight during the execution of the de provisioning process. Possible Asserted Effect Failure to have a reliable general IT control environment over logical access may result in unauthorized changes being made to Infor, which may result in erroneous reliance on the operating effectiveness of automated IT controls, over allowability. Failure to have effective internal controls over allowability may result in federal awards being utilized for unallowable expenditures not in accordance with the federal statues, regulations, and terms and conditions of federal awards. Questioned Costs Not applicable Statistical Sampling The sample was not intended to be, and was not, a statistically valid sample. Recommendation We recommend that management review and emphasize the access management policies and procedures with key personnel to help ensure that an Infor User Access Review is performed. Additionally, we recommend that management review and emphasize the logical access policies and procedures with key personnel responsible for the timely communication and removal of de provisioning of users. Views of Responsible Officials Recommendation accepted. Please refer to corrective action plan.
Federal Agency: United States Department of Health and Human Services (HHS) Federal Program: R&D Provider Relief Fund Provider Relief Fund and American Rescue Plan (ARP) Rural Distribution (93.498) Federal Award Numbers: Various Federal Award Years: Various Reference: 2023 002 Criteria Internal Controls Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements of Federal Awards, (2 CFR 200) section 200.303(a) states, the non federal entity must establish and maintain effective internal control over the federal award that provides reasonable assurance that the non federal entity is managing the federal award in compliance with federal statues, 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). Condition BMC utilizes Infor, a could based system, as the entity’s general ledger. BMC management of Infor includes maintaining the application system layer of the IT control environment and relies on the Infor vendor to support infrastructure layers through SOC 1 reporting. Processes that support compliance and administration of the PRF and R&D programs rely on Infor IT application controls. During our test work, we noted the following deficiencies operating effectiveness of the general IT controls: 1) BMC did not have a process in place to perform and document a Infor User Access Review during the fiscal year. Upon audit inquiry, a review was performed to confirm there were no impacts to IT application controls configurations or processes. 2) For 4 of 15 employee termination access samples to the Infor system, it was determined the samples were not removed in a timely basis following the employee’s termination date. Upon audit inquiry, we obtained system documentation for the 4 users identified as exceptions indicating the related users did not logon to the system past their termination date. Cause The conditions above related to the following: 1) Management did not formally implement a process or policy to review user access due to reliance on preventative access controls and no established review requirements as of the fiscal year. 2) The exceptions occurred due to human oversight during the execution of the de provisioning process. Possible Asserted Effect Failure to have a reliable general IT control environment over logical access may result in unauthorized changes being made to Infor, which may result in erroneous reliance on the operating effectiveness of automated IT controls, over allowability. Failure to have effective internal controls over allowability may result in federal awards being utilized for unallowable expenditures not in accordance with the federal statues, regulations, and terms and conditions of federal awards. Questioned Costs Not applicable Statistical Sampling The sample was not intended to be, and was not, a statistically valid sample. Recommendation We recommend that management review and emphasize the access management policies and procedures with key personnel to help ensure that an Infor User Access Review is performed. Additionally, we recommend that management review and emphasize the logical access policies and procedures with key personnel responsible for the timely communication and removal of de provisioning of users. Views of Responsible Officials Recommendation accepted. Please refer to corrective action plan.
Federal Agency: United States Department of Health and Human Services (HHS) Federal Program: R&D Provider Relief Fund Provider Relief Fund and American Rescue Plan (ARP) Rural Distribution (93.498) Federal Award Numbers: Various Federal Award Years: Various Reference: 2023 002 Criteria Internal Controls Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements of Federal Awards, (2 CFR 200) section 200.303(a) states, the non federal entity must establish and maintain effective internal control over the federal award that provides reasonable assurance that the non federal entity is managing the federal award in compliance with federal statues, 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). Condition BMC utilizes Infor, a could based system, as the entity’s general ledger. BMC management of Infor includes maintaining the application system layer of the IT control environment and relies on the Infor vendor to support infrastructure layers through SOC 1 reporting. Processes that support compliance and administration of the PRF and R&D programs rely on Infor IT application controls. During our test work, we noted the following deficiencies operating effectiveness of the general IT controls: 1) BMC did not have a process in place to perform and document a Infor User Access Review during the fiscal year. Upon audit inquiry, a review was performed to confirm there were no impacts to IT application controls configurations or processes. 2) For 4 of 15 employee termination access samples to the Infor system, it was determined the samples were not removed in a timely basis following the employee’s termination date. Upon audit inquiry, we obtained system documentation for the 4 users identified as exceptions indicating the related users did not logon to the system past their termination date. Cause The conditions above related to the following: 1) Management did not formally implement a process or policy to review user access due to reliance on preventative access controls and no established review requirements as of the fiscal year. 2) The exceptions occurred due to human oversight during the execution of the de provisioning process. Possible Asserted Effect Failure to have a reliable general IT control environment over logical access may result in unauthorized changes being made to Infor, which may result in erroneous reliance on the operating effectiveness of automated IT controls, over allowability. Failure to have effective internal controls over allowability may result in federal awards being utilized for unallowable expenditures not in accordance with the federal statues, regulations, and terms and conditions of federal awards. Questioned Costs Not applicable Statistical Sampling The sample was not intended to be, and was not, a statistically valid sample. Recommendation We recommend that management review and emphasize the access management policies and procedures with key personnel to help ensure that an Infor User Access Review is performed. Additionally, we recommend that management review and emphasize the logical access policies and procedures with key personnel responsible for the timely communication and removal of de provisioning of users. Views of Responsible Officials Recommendation accepted. Please refer to corrective action plan.
Federal Agency: United States Department of Health and Human Services (HHS) Federal Program: R&D and Provider Relief Fund and American Rescue Plan (ARP) Rural Distribution (PRF) (93.498) Federal Award Numbers: Various Federal Award Years: Various Reference: 2023 001 Criteria Internal Controls Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements of Federal Awards, (2 CFR 200) section 200.303(a) states, the non federal entity must establish and maintain effective internal control over the federal award that provides reasonable assurance that the non federal entity is managing the federal award in compliance with federal statues, 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). Condition BMC utilizes Workday, a cloud based system, to provide human resources and payroll applications. BMC’s management of Workday includes maintaining the application system layer of the information technology (IT)control environment and relies on the Workday vendor to support infrastructure layers through Service Organization Control (SOC) Type 1 reporting. Processes that support compliance and administration of the PRF and R&D programs rely on Workday IT application controls. During our testing, we noted the following deficiencies operating effectiveness of the Workday general IT controls: 1) BMC did not perform and document a Workday change review during the fiscal year, such a control would enable management to detect inappropriate changes to the Workday application. Such a report detailing changes to Workday was generated as part of the Uniform Guidance audit, however management did not formally perform and document its review over the report. Upon audit inquiry, the review was subsequently performed by management and we observed no inappropriate changes were made during the year that would impact the IT application controls relied upon. 2) For 1 of 13 employee new or modified Workday access provisioning samples, BMC did not maintain adequate documentation of the access request and approval. Upon audit inquiry, it was determined that access was provided as part of a promotion and was appropriate; however, was not formally documented. Cause The conditions above related to the following: 1) Management did not formally perform and document their review over the report due to a lack of knowledge of performance and documentation requirements by the control operators. 2) The exception occurred due to delays in supervisors’ timely reporting of terminations in Infor which delayed the de provisioning process performed by IT. Possible Asserted Effect Failure to have a reliable general IT control environment over logical access and change management may result in unauthorized changes being made to Workday, which may result in erroneous reliance on the operating effectiveness of automated IT controls, over allowability. Failure to have effective internal controls over allowability may result in federal awards being utilized for unallowable expenditures not in accordance with the federal statues, regulations, and terms and conditions of federal awards. Questioned Costs Not applicable Statistical Sampling The sample was not intended to be, and was not, a statistically valid sample. Recommendation We recommend that management review and emphasize the change management policies and procedures with key personnel to help ensure that the Workday change Review is performed to address change management risks for the system. Additionally, we recommend that management review and emphasize the logical access policies and procedures with key personnel responsible for requesting and provisioning access to help ensure that requests for both new and modified access are appropriately obtained and documented for approval of access needed for job responsibilities. Views of Responsible Officials Recommendation accepted. Please refer to corrective action plan.
Federal Agency: United States Department of Health and Human Services (HHS) Federal Program: R&D Provider Relief Fund Provider Relief Fund and American Rescue Plan (ARP) Rural Distribution (93.498) Federal Award Numbers: Various Federal Award Years: Various Reference: 2023 002 Criteria Internal Controls Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements of Federal Awards, (2 CFR 200) section 200.303(a) states, the non federal entity must establish and maintain effective internal control over the federal award that provides reasonable assurance that the non federal entity is managing the federal award in compliance with federal statues, 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). Condition BMC utilizes Infor, a could based system, as the entity’s general ledger. BMC management of Infor includes maintaining the application system layer of the IT control environment and relies on the Infor vendor to support infrastructure layers through SOC 1 reporting. Processes that support compliance and administration of the PRF and R&D programs rely on Infor IT application controls. During our test work, we noted the following deficiencies operating effectiveness of the general IT controls: 1) BMC did not have a process in place to perform and document a Infor User Access Review during the fiscal year. Upon audit inquiry, a review was performed to confirm there were no impacts to IT application controls configurations or processes. 2) For 4 of 15 employee termination access samples to the Infor system, it was determined the samples were not removed in a timely basis following the employee’s termination date. Upon audit inquiry, we obtained system documentation for the 4 users identified as exceptions indicating the related users did not logon to the system past their termination date. Cause The conditions above related to the following: 1) Management did not formally implement a process or policy to review user access due to reliance on preventative access controls and no established review requirements as of the fiscal year. 2) The exceptions occurred due to human oversight during the execution of the de provisioning process. Possible Asserted Effect Failure to have a reliable general IT control environment over logical access may result in unauthorized changes being made to Infor, which may result in erroneous reliance on the operating effectiveness of automated IT controls, over allowability. Failure to have effective internal controls over allowability may result in federal awards being utilized for unallowable expenditures not in accordance with the federal statues, regulations, and terms and conditions of federal awards. Questioned Costs Not applicable Statistical Sampling The sample was not intended to be, and was not, a statistically valid sample. Recommendation We recommend that management review and emphasize the access management policies and procedures with key personnel to help ensure that an Infor User Access Review is performed. Additionally, we recommend that management review and emphasize the logical access policies and procedures with key personnel responsible for the timely communication and removal of de provisioning of users. Views of Responsible Officials Recommendation accepted. Please refer to corrective action plan.
Head Start and Early Head Start Assistance Listing #93.600 Head Start Grant No. 04CH01121 U.S. Department of Health and Human Services Federal Award Year - 2023 Condition – Adequate controls were not in place to review and approve grant reports prior to their submission to the grantor. The Federal Financial Reports (SF-425) for the Head Start Cluster grants were not reviewed and approved prior to submission to the Payment Management System. Criteria – Grantees should have controls in place to ensure that grant reports are being reviewed and approved by management prior to being submitted to the grantor. 2 CFR 200.303 requires the non‐Federal entity to “(a) establish and maintain effective internal controls over the Federal award that provides reasonable assurance that the non‐Federal entity is managing the Federal statutes, regulations, and the terms and conditions of the Federal award.” Cause – Lack of sufficient controls over the review and approval of grant reports to ensure the accuracy and completeness of the report being submitted to the grantor. Questioned Costs – Not applicable. Effect – Lack of proper review and approval could result in improper reporting which could lead to disallowed costs. However, our audit disclosed no instances of unallowable costs. Recommendation – We recommend the implementation of controls to ensure there is evidence of review and approval of the quarterly grant reports prior to submission to the grantor. Management’s Response – The Agency will implement controls to ensure proper review and approval is obtained on required grant reports prior to submission to the grantor.
Head Start and Early Head Start Assistance Listing #93.600 Head Start Grant No. 04CH01121 U.S. Department of Health and Human Services Federal Award Year - 2023 Condition – Adequate controls were not in place to review and approve grant reports prior to their submission to the grantor. The Federal Financial Reports (SF-425) for the Head Start Cluster grants were not reviewed and approved prior to submission to the Payment Management System. Criteria – Grantees should have controls in place to ensure that grant reports are being reviewed and approved by management prior to being submitted to the grantor. 2 CFR 200.303 requires the non‐Federal entity to “(a) establish and maintain effective internal controls over the Federal award that provides reasonable assurance that the non‐Federal entity is managing the Federal statutes, regulations, and the terms and conditions of the Federal award.” Cause – Lack of sufficient controls over the review and approval of grant reports to ensure the accuracy and completeness of the report being submitted to the grantor. Questioned Costs – Not applicable. Effect – Lack of proper review and approval could result in improper reporting which could lead to disallowed costs. However, our audit disclosed no instances of unallowable costs. Recommendation – We recommend the implementation of controls to ensure there is evidence of review and approval of the quarterly grant reports prior to submission to the grantor. Management’s Response – The Agency will implement controls to ensure proper review and approval is obtained on required grant reports prior to submission to the grantor.
2023-002 [2022‐002]—PREPARATION OF SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS Federal Agency: All presented in the Schedule of Expenditures of Federal Awards. Program Name: All presented in the Schedule of Expenditures of Federal Awards. Assistance Listing Nos. and Program Expenditures: All presented in Schedule of Expenditures of Federal Awards. Award Number and Program Award Year: All presented in Schedule of Expenditures of Federal Awards. Compliance Requirement: Other – Schedule of Expenditures of Federal Awards preparation Statement of Condition During our audit, we reviewed the Coalition’s federal grants report for the fiscal year and identified the federal grants, Assistance Listing #s (AL#s) and the amounts of the federal expenditures and all of the other items required to properly present the Schedule of Expenditures of Federal Awards (SEFA). We then had the finance staff of the Coalition confirm the correctness of the SEFA. Despite the confirmation of accuracy, additional federal expenditures and grouping of grant expenditures were identified after several reviews of the SEFA.Criteria 2 CFR 200.510 indicates that the auditee must prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502, Basis for Determining Federal Awards Expended. Per 2 CFR 200.502, the determination of when a federal award is expended should be based on when the activity related to the federal award occurs. Generally, the activity pertains to events that require the non-federal entity to comply with federal statutes, regulations, and the terms and conditions of federal awards, such as expenditure/expense transactions associated with awards. In addition, 2 CFR Part 200.303 requires the program to establish and maintain effective internal controls over federal awards that provides reasonable assurance of compliance with federal statutes, regulations, and the terms and conditions of federal awards. Effect Without an established process governed by effective internal controls, the Coalition may not prevent or detect material misstatements on its SEFA in a timely manner. In addition, the errors could result in improper selections of major program(s) for the single audit and a substandard single audit. Cause Historically, the Coalition has requested the auditor assist in identifying accruals related to federal grant expenditures as the organization has maintained these records on a cash basis. As the organization has taken more responsibility on maintaining its federal grant expenditures on an accrual basis, an incomplete SEFA has been provided. Recommendation We recommend the Coalition prepare the Schedule of Expenditures of Federal Awards and submit this to the auditor for testing. The SEFA should include the name of the grant, name of grantor, the AL #, the pass-through number if applicable and a reconciliation of the federal revenues and expenditures to the Coalition’s general ledger. The Coalition staff should perform more detailed reviews of the reports to ensure they properly reflect grant receipts and expenditures. This review should be performed by someone other than the preparer and should include documented evidence of agreeing the reported data to the accounting records. We further recommend training for those individuals involved in the preparation and review of the reports to ensure they are fully aware of the requirements. View of Responsible Officials and Corrective Action Plan: The corrective Action Plan will be carried out in the 2024 Fiscal Year and information will be given to the auditors when requested for the next audit. The Coalition will ensure that all information needed for the SEFA is kept and entered accurately (this process has already begun). When the fiscal year closes out, the Coalition will provide the auditors with a test SEFA to confirm that the information we are collecting throughout the year and are asserting are the correct numbers for our federal grants, is indeed the correct information. Corrective Action Plan Timeline: Completed by December 13, 2024 (Final copy of the SEFA will not be given to the auditors until requested for the 2024 Audit) Designation Of Employee Position Responsible For Meeting Deadline: Executive Director will oversee this project and work directly with NMCEH finance staff work closely with the auditors to make sure that the information saved and shared is correct. Type of Finding: (F) Significant Deficiency in Internal Control over Compliance of Federal Awards. Questioned Costs: None
2023-002 [2022‐002]—PREPARATION OF SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS Federal Agency: All presented in the Schedule of Expenditures of Federal Awards. Program Name: All presented in the Schedule of Expenditures of Federal Awards. Assistance Listing Nos. and Program Expenditures: All presented in Schedule of Expenditures of Federal Awards. Award Number and Program Award Year: All presented in Schedule of Expenditures of Federal Awards. Compliance Requirement: Other – Schedule of Expenditures of Federal Awards preparation Statement of Condition During our audit, we reviewed the Coalition’s federal grants report for the fiscal year and identified the federal grants, Assistance Listing #s (AL#s) and the amounts of the federal expenditures and all of the other items required to properly present the Schedule of Expenditures of Federal Awards (SEFA). We then had the finance staff of the Coalition confirm the correctness of the SEFA. Despite the confirmation of accuracy, additional federal expenditures and grouping of grant expenditures were identified after several reviews of the SEFA.Criteria 2 CFR 200.510 indicates that the auditee must prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502, Basis for Determining Federal Awards Expended. Per 2 CFR 200.502, the determination of when a federal award is expended should be based on when the activity related to the federal award occurs. Generally, the activity pertains to events that require the non-federal entity to comply with federal statutes, regulations, and the terms and conditions of federal awards, such as expenditure/expense transactions associated with awards. In addition, 2 CFR Part 200.303 requires the program to establish and maintain effective internal controls over federal awards that provides reasonable assurance of compliance with federal statutes, regulations, and the terms and conditions of federal awards. Effect Without an established process governed by effective internal controls, the Coalition may not prevent or detect material misstatements on its SEFA in a timely manner. In addition, the errors could result in improper selections of major program(s) for the single audit and a substandard single audit. Cause Historically, the Coalition has requested the auditor assist in identifying accruals related to federal grant expenditures as the organization has maintained these records on a cash basis. As the organization has taken more responsibility on maintaining its federal grant expenditures on an accrual basis, an incomplete SEFA has been provided. Recommendation We recommend the Coalition prepare the Schedule of Expenditures of Federal Awards and submit this to the auditor for testing. The SEFA should include the name of the grant, name of grantor, the AL #, the pass-through number if applicable and a reconciliation of the federal revenues and expenditures to the Coalition’s general ledger. The Coalition staff should perform more detailed reviews of the reports to ensure they properly reflect grant receipts and expenditures. This review should be performed by someone other than the preparer and should include documented evidence of agreeing the reported data to the accounting records. We further recommend training for those individuals involved in the preparation and review of the reports to ensure they are fully aware of the requirements. View of Responsible Officials and Corrective Action Plan: The corrective Action Plan will be carried out in the 2024 Fiscal Year and information will be given to the auditors when requested for the next audit. The Coalition will ensure that all information needed for the SEFA is kept and entered accurately (this process has already begun). When the fiscal year closes out, the Coalition will provide the auditors with a test SEFA to confirm that the information we are collecting throughout the year and are asserting are the correct numbers for our federal grants, is indeed the correct information. Corrective Action Plan Timeline: Completed by December 13, 2024 (Final copy of the SEFA will not be given to the auditors until requested for the 2024 Audit) Designation Of Employee Position Responsible For Meeting Deadline: Executive Director will oversee this project and work directly with NMCEH finance staff work closely with the auditors to make sure that the information saved and shared is correct. Type of Finding: (F) Significant Deficiency in Internal Control over Compliance of Federal Awards. Questioned Costs: None
2023-002 [2022‐002]—PREPARATION OF SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS Federal Agency: All presented in the Schedule of Expenditures of Federal Awards. Program Name: All presented in the Schedule of Expenditures of Federal Awards. Assistance Listing Nos. and Program Expenditures: All presented in Schedule of Expenditures of Federal Awards. Award Number and Program Award Year: All presented in Schedule of Expenditures of Federal Awards. Compliance Requirement: Other – Schedule of Expenditures of Federal Awards preparation Statement of Condition During our audit, we reviewed the Coalition’s federal grants report for the fiscal year and identified the federal grants, Assistance Listing #s (AL#s) and the amounts of the federal expenditures and all of the other items required to properly present the Schedule of Expenditures of Federal Awards (SEFA). We then had the finance staff of the Coalition confirm the correctness of the SEFA. Despite the confirmation of accuracy, additional federal expenditures and grouping of grant expenditures were identified after several reviews of the SEFA.Criteria 2 CFR 200.510 indicates that the auditee must prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502, Basis for Determining Federal Awards Expended. Per 2 CFR 200.502, the determination of when a federal award is expended should be based on when the activity related to the federal award occurs. Generally, the activity pertains to events that require the non-federal entity to comply with federal statutes, regulations, and the terms and conditions of federal awards, such as expenditure/expense transactions associated with awards. In addition, 2 CFR Part 200.303 requires the program to establish and maintain effective internal controls over federal awards that provides reasonable assurance of compliance with federal statutes, regulations, and the terms and conditions of federal awards. Effect Without an established process governed by effective internal controls, the Coalition may not prevent or detect material misstatements on its SEFA in a timely manner. In addition, the errors could result in improper selections of major program(s) for the single audit and a substandard single audit. Cause Historically, the Coalition has requested the auditor assist in identifying accruals related to federal grant expenditures as the organization has maintained these records on a cash basis. As the organization has taken more responsibility on maintaining its federal grant expenditures on an accrual basis, an incomplete SEFA has been provided. Recommendation We recommend the Coalition prepare the Schedule of Expenditures of Federal Awards and submit this to the auditor for testing. The SEFA should include the name of the grant, name of grantor, the AL #, the pass-through number if applicable and a reconciliation of the federal revenues and expenditures to the Coalition’s general ledger. The Coalition staff should perform more detailed reviews of the reports to ensure they properly reflect grant receipts and expenditures. This review should be performed by someone other than the preparer and should include documented evidence of agreeing the reported data to the accounting records. We further recommend training for those individuals involved in the preparation and review of the reports to ensure they are fully aware of the requirements. View of Responsible Officials and Corrective Action Plan: The corrective Action Plan will be carried out in the 2024 Fiscal Year and information will be given to the auditors when requested for the next audit. The Coalition will ensure that all information needed for the SEFA is kept and entered accurately (this process has already begun). When the fiscal year closes out, the Coalition will provide the auditors with a test SEFA to confirm that the information we are collecting throughout the year and are asserting are the correct numbers for our federal grants, is indeed the correct information. Corrective Action Plan Timeline: Completed by December 13, 2024 (Final copy of the SEFA will not be given to the auditors until requested for the 2024 Audit) Designation Of Employee Position Responsible For Meeting Deadline: Executive Director will oversee this project and work directly with NMCEH finance staff work closely with the auditors to make sure that the information saved and shared is correct. Type of Finding: (F) Significant Deficiency in Internal Control over Compliance of Federal Awards. Questioned Costs: None
2023-002 [2022‐002]—PREPARATION OF SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS Federal Agency: All presented in the Schedule of Expenditures of Federal Awards. Program Name: All presented in the Schedule of Expenditures of Federal Awards. Assistance Listing Nos. and Program Expenditures: All presented in Schedule of Expenditures of Federal Awards. Award Number and Program Award Year: All presented in Schedule of Expenditures of Federal Awards. Compliance Requirement: Other – Schedule of Expenditures of Federal Awards preparation Statement of Condition During our audit, we reviewed the Coalition’s federal grants report for the fiscal year and identified the federal grants, Assistance Listing #s (AL#s) and the amounts of the federal expenditures and all of the other items required to properly present the Schedule of Expenditures of Federal Awards (SEFA). We then had the finance staff of the Coalition confirm the correctness of the SEFA. Despite the confirmation of accuracy, additional federal expenditures and grouping of grant expenditures were identified after several reviews of the SEFA.Criteria 2 CFR 200.510 indicates that the auditee must prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502, Basis for Determining Federal Awards Expended. Per 2 CFR 200.502, the determination of when a federal award is expended should be based on when the activity related to the federal award occurs. Generally, the activity pertains to events that require the non-federal entity to comply with federal statutes, regulations, and the terms and conditions of federal awards, such as expenditure/expense transactions associated with awards. In addition, 2 CFR Part 200.303 requires the program to establish and maintain effective internal controls over federal awards that provides reasonable assurance of compliance with federal statutes, regulations, and the terms and conditions of federal awards. Effect Without an established process governed by effective internal controls, the Coalition may not prevent or detect material misstatements on its SEFA in a timely manner. In addition, the errors could result in improper selections of major program(s) for the single audit and a substandard single audit. Cause Historically, the Coalition has requested the auditor assist in identifying accruals related to federal grant expenditures as the organization has maintained these records on a cash basis. As the organization has taken more responsibility on maintaining its federal grant expenditures on an accrual basis, an incomplete SEFA has been provided. Recommendation We recommend the Coalition prepare the Schedule of Expenditures of Federal Awards and submit this to the auditor for testing. The SEFA should include the name of the grant, name of grantor, the AL #, the pass-through number if applicable and a reconciliation of the federal revenues and expenditures to the Coalition’s general ledger. The Coalition staff should perform more detailed reviews of the reports to ensure they properly reflect grant receipts and expenditures. This review should be performed by someone other than the preparer and should include documented evidence of agreeing the reported data to the accounting records. We further recommend training for those individuals involved in the preparation and review of the reports to ensure they are fully aware of the requirements. View of Responsible Officials and Corrective Action Plan: The corrective Action Plan will be carried out in the 2024 Fiscal Year and information will be given to the auditors when requested for the next audit. The Coalition will ensure that all information needed for the SEFA is kept and entered accurately (this process has already begun). When the fiscal year closes out, the Coalition will provide the auditors with a test SEFA to confirm that the information we are collecting throughout the year and are asserting are the correct numbers for our federal grants, is indeed the correct information. Corrective Action Plan Timeline: Completed by December 13, 2024 (Final copy of the SEFA will not be given to the auditors until requested for the 2024 Audit) Designation Of Employee Position Responsible For Meeting Deadline: Executive Director will oversee this project and work directly with NMCEH finance staff work closely with the auditors to make sure that the information saved and shared is correct. Type of Finding: (F) Significant Deficiency in Internal Control over Compliance of Federal Awards. Questioned Costs: None
2023-002 [2022‐002]—PREPARATION OF SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS Federal Agency: All presented in the Schedule of Expenditures of Federal Awards. Program Name: All presented in the Schedule of Expenditures of Federal Awards. Assistance Listing Nos. and Program Expenditures: All presented in Schedule of Expenditures of Federal Awards. Award Number and Program Award Year: All presented in Schedule of Expenditures of Federal Awards. Compliance Requirement: Other – Schedule of Expenditures of Federal Awards preparation Statement of Condition During our audit, we reviewed the Coalition’s federal grants report for the fiscal year and identified the federal grants, Assistance Listing #s (AL#s) and the amounts of the federal expenditures and all of the other items required to properly present the Schedule of Expenditures of Federal Awards (SEFA). We then had the finance staff of the Coalition confirm the correctness of the SEFA. Despite the confirmation of accuracy, additional federal expenditures and grouping of grant expenditures were identified after several reviews of the SEFA.Criteria 2 CFR 200.510 indicates that the auditee must prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502, Basis for Determining Federal Awards Expended. Per 2 CFR 200.502, the determination of when a federal award is expended should be based on when the activity related to the federal award occurs. Generally, the activity pertains to events that require the non-federal entity to comply with federal statutes, regulations, and the terms and conditions of federal awards, such as expenditure/expense transactions associated with awards. In addition, 2 CFR Part 200.303 requires the program to establish and maintain effective internal controls over federal awards that provides reasonable assurance of compliance with federal statutes, regulations, and the terms and conditions of federal awards. Effect Without an established process governed by effective internal controls, the Coalition may not prevent or detect material misstatements on its SEFA in a timely manner. In addition, the errors could result in improper selections of major program(s) for the single audit and a substandard single audit. Cause Historically, the Coalition has requested the auditor assist in identifying accruals related to federal grant expenditures as the organization has maintained these records on a cash basis. As the organization has taken more responsibility on maintaining its federal grant expenditures on an accrual basis, an incomplete SEFA has been provided. Recommendation We recommend the Coalition prepare the Schedule of Expenditures of Federal Awards and submit this to the auditor for testing. The SEFA should include the name of the grant, name of grantor, the AL #, the pass-through number if applicable and a reconciliation of the federal revenues and expenditures to the Coalition’s general ledger. The Coalition staff should perform more detailed reviews of the reports to ensure they properly reflect grant receipts and expenditures. This review should be performed by someone other than the preparer and should include documented evidence of agreeing the reported data to the accounting records. We further recommend training for those individuals involved in the preparation and review of the reports to ensure they are fully aware of the requirements. View of Responsible Officials and Corrective Action Plan: The corrective Action Plan will be carried out in the 2024 Fiscal Year and information will be given to the auditors when requested for the next audit. The Coalition will ensure that all information needed for the SEFA is kept and entered accurately (this process has already begun). When the fiscal year closes out, the Coalition will provide the auditors with a test SEFA to confirm that the information we are collecting throughout the year and are asserting are the correct numbers for our federal grants, is indeed the correct information. Corrective Action Plan Timeline: Completed by December 13, 2024 (Final copy of the SEFA will not be given to the auditors until requested for the 2024 Audit) Designation Of Employee Position Responsible For Meeting Deadline: Executive Director will oversee this project and work directly with NMCEH finance staff work closely with the auditors to make sure that the information saved and shared is correct. Type of Finding: (F) Significant Deficiency in Internal Control over Compliance of Federal Awards. Questioned Costs: None
2023-002 [2022‐002]—PREPARATION OF SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS Federal Agency: All presented in the Schedule of Expenditures of Federal Awards. Program Name: All presented in the Schedule of Expenditures of Federal Awards. Assistance Listing Nos. and Program Expenditures: All presented in Schedule of Expenditures of Federal Awards. Award Number and Program Award Year: All presented in Schedule of Expenditures of Federal Awards. Compliance Requirement: Other – Schedule of Expenditures of Federal Awards preparation Statement of Condition During our audit, we reviewed the Coalition’s federal grants report for the fiscal year and identified the federal grants, Assistance Listing #s (AL#s) and the amounts of the federal expenditures and all of the other items required to properly present the Schedule of Expenditures of Federal Awards (SEFA). We then had the finance staff of the Coalition confirm the correctness of the SEFA. Despite the confirmation of accuracy, additional federal expenditures and grouping of grant expenditures were identified after several reviews of the SEFA.Criteria 2 CFR 200.510 indicates that the auditee must prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502, Basis for Determining Federal Awards Expended. Per 2 CFR 200.502, the determination of when a federal award is expended should be based on when the activity related to the federal award occurs. Generally, the activity pertains to events that require the non-federal entity to comply with federal statutes, regulations, and the terms and conditions of federal awards, such as expenditure/expense transactions associated with awards. In addition, 2 CFR Part 200.303 requires the program to establish and maintain effective internal controls over federal awards that provides reasonable assurance of compliance with federal statutes, regulations, and the terms and conditions of federal awards. Effect Without an established process governed by effective internal controls, the Coalition may not prevent or detect material misstatements on its SEFA in a timely manner. In addition, the errors could result in improper selections of major program(s) for the single audit and a substandard single audit. Cause Historically, the Coalition has requested the auditor assist in identifying accruals related to federal grant expenditures as the organization has maintained these records on a cash basis. As the organization has taken more responsibility on maintaining its federal grant expenditures on an accrual basis, an incomplete SEFA has been provided. Recommendation We recommend the Coalition prepare the Schedule of Expenditures of Federal Awards and submit this to the auditor for testing. The SEFA should include the name of the grant, name of grantor, the AL #, the pass-through number if applicable and a reconciliation of the federal revenues and expenditures to the Coalition’s general ledger. The Coalition staff should perform more detailed reviews of the reports to ensure they properly reflect grant receipts and expenditures. This review should be performed by someone other than the preparer and should include documented evidence of agreeing the reported data to the accounting records. We further recommend training for those individuals involved in the preparation and review of the reports to ensure they are fully aware of the requirements. View of Responsible Officials and Corrective Action Plan: The corrective Action Plan will be carried out in the 2024 Fiscal Year and information will be given to the auditors when requested for the next audit. The Coalition will ensure that all information needed for the SEFA is kept and entered accurately (this process has already begun). When the fiscal year closes out, the Coalition will provide the auditors with a test SEFA to confirm that the information we are collecting throughout the year and are asserting are the correct numbers for our federal grants, is indeed the correct information. Corrective Action Plan Timeline: Completed by December 13, 2024 (Final copy of the SEFA will not be given to the auditors until requested for the 2024 Audit) Designation Of Employee Position Responsible For Meeting Deadline: Executive Director will oversee this project and work directly with NMCEH finance staff work closely with the auditors to make sure that the information saved and shared is correct. Type of Finding: (F) Significant Deficiency in Internal Control over Compliance of Federal Awards. Questioned Costs: None
2023-002 [2022‐002]—PREPARATION OF SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS Federal Agency: All presented in the Schedule of Expenditures of Federal Awards. Program Name: All presented in the Schedule of Expenditures of Federal Awards. Assistance Listing Nos. and Program Expenditures: All presented in Schedule of Expenditures of Federal Awards. Award Number and Program Award Year: All presented in Schedule of Expenditures of Federal Awards. Compliance Requirement: Other – Schedule of Expenditures of Federal Awards preparation Statement of Condition During our audit, we reviewed the Coalition’s federal grants report for the fiscal year and identified the federal grants, Assistance Listing #s (AL#s) and the amounts of the federal expenditures and all of the other items required to properly present the Schedule of Expenditures of Federal Awards (SEFA). We then had the finance staff of the Coalition confirm the correctness of the SEFA. Despite the confirmation of accuracy, additional federal expenditures and grouping of grant expenditures were identified after several reviews of the SEFA.Criteria 2 CFR 200.510 indicates that the auditee must prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502, Basis for Determining Federal Awards Expended. Per 2 CFR 200.502, the determination of when a federal award is expended should be based on when the activity related to the federal award occurs. Generally, the activity pertains to events that require the non-federal entity to comply with federal statutes, regulations, and the terms and conditions of federal awards, such as expenditure/expense transactions associated with awards. In addition, 2 CFR Part 200.303 requires the program to establish and maintain effective internal controls over federal awards that provides reasonable assurance of compliance with federal statutes, regulations, and the terms and conditions of federal awards. Effect Without an established process governed by effective internal controls, the Coalition may not prevent or detect material misstatements on its SEFA in a timely manner. In addition, the errors could result in improper selections of major program(s) for the single audit and a substandard single audit. Cause Historically, the Coalition has requested the auditor assist in identifying accruals related to federal grant expenditures as the organization has maintained these records on a cash basis. As the organization has taken more responsibility on maintaining its federal grant expenditures on an accrual basis, an incomplete SEFA has been provided. Recommendation We recommend the Coalition prepare the Schedule of Expenditures of Federal Awards and submit this to the auditor for testing. The SEFA should include the name of the grant, name of grantor, the AL #, the pass-through number if applicable and a reconciliation of the federal revenues and expenditures to the Coalition’s general ledger. The Coalition staff should perform more detailed reviews of the reports to ensure they properly reflect grant receipts and expenditures. This review should be performed by someone other than the preparer and should include documented evidence of agreeing the reported data to the accounting records. We further recommend training for those individuals involved in the preparation and review of the reports to ensure they are fully aware of the requirements. View of Responsible Officials and Corrective Action Plan: The corrective Action Plan will be carried out in the 2024 Fiscal Year and information will be given to the auditors when requested for the next audit. The Coalition will ensure that all information needed for the SEFA is kept and entered accurately (this process has already begun). When the fiscal year closes out, the Coalition will provide the auditors with a test SEFA to confirm that the information we are collecting throughout the year and are asserting are the correct numbers for our federal grants, is indeed the correct information. Corrective Action Plan Timeline: Completed by December 13, 2024 (Final copy of the SEFA will not be given to the auditors until requested for the 2024 Audit) Designation Of Employee Position Responsible For Meeting Deadline: Executive Director will oversee this project and work directly with NMCEH finance staff work closely with the auditors to make sure that the information saved and shared is correct. Type of Finding: (F) Significant Deficiency in Internal Control over Compliance of Federal Awards. Questioned Costs: None
2023-002 [2022‐002]—PREPARATION OF SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS Federal Agency: All presented in the Schedule of Expenditures of Federal Awards. Program Name: All presented in the Schedule of Expenditures of Federal Awards. Assistance Listing Nos. and Program Expenditures: All presented in Schedule of Expenditures of Federal Awards. Award Number and Program Award Year: All presented in Schedule of Expenditures of Federal Awards. Compliance Requirement: Other – Schedule of Expenditures of Federal Awards preparation Statement of Condition During our audit, we reviewed the Coalition’s federal grants report for the fiscal year and identified the federal grants, Assistance Listing #s (AL#s) and the amounts of the federal expenditures and all of the other items required to properly present the Schedule of Expenditures of Federal Awards (SEFA). We then had the finance staff of the Coalition confirm the correctness of the SEFA. Despite the confirmation of accuracy, additional federal expenditures and grouping of grant expenditures were identified after several reviews of the SEFA.Criteria 2 CFR 200.510 indicates that the auditee must prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502, Basis for Determining Federal Awards Expended. Per 2 CFR 200.502, the determination of when a federal award is expended should be based on when the activity related to the federal award occurs. Generally, the activity pertains to events that require the non-federal entity to comply with federal statutes, regulations, and the terms and conditions of federal awards, such as expenditure/expense transactions associated with awards. In addition, 2 CFR Part 200.303 requires the program to establish and maintain effective internal controls over federal awards that provides reasonable assurance of compliance with federal statutes, regulations, and the terms and conditions of federal awards. Effect Without an established process governed by effective internal controls, the Coalition may not prevent or detect material misstatements on its SEFA in a timely manner. In addition, the errors could result in improper selections of major program(s) for the single audit and a substandard single audit. Cause Historically, the Coalition has requested the auditor assist in identifying accruals related to federal grant expenditures as the organization has maintained these records on a cash basis. As the organization has taken more responsibility on maintaining its federal grant expenditures on an accrual basis, an incomplete SEFA has been provided. Recommendation We recommend the Coalition prepare the Schedule of Expenditures of Federal Awards and submit this to the auditor for testing. The SEFA should include the name of the grant, name of grantor, the AL #, the pass-through number if applicable and a reconciliation of the federal revenues and expenditures to the Coalition’s general ledger. The Coalition staff should perform more detailed reviews of the reports to ensure they properly reflect grant receipts and expenditures. This review should be performed by someone other than the preparer and should include documented evidence of agreeing the reported data to the accounting records. We further recommend training for those individuals involved in the preparation and review of the reports to ensure they are fully aware of the requirements. View of Responsible Officials and Corrective Action Plan: The corrective Action Plan will be carried out in the 2024 Fiscal Year and information will be given to the auditors when requested for the next audit. The Coalition will ensure that all information needed for the SEFA is kept and entered accurately (this process has already begun). When the fiscal year closes out, the Coalition will provide the auditors with a test SEFA to confirm that the information we are collecting throughout the year and are asserting are the correct numbers for our federal grants, is indeed the correct information. Corrective Action Plan Timeline: Completed by December 13, 2024 (Final copy of the SEFA will not be given to the auditors until requested for the 2024 Audit) Designation Of Employee Position Responsible For Meeting Deadline: Executive Director will oversee this project and work directly with NMCEH finance staff work closely with the auditors to make sure that the information saved and shared is correct. Type of Finding: (F) Significant Deficiency in Internal Control over Compliance of Federal Awards. Questioned Costs: None
2023-002 [2022‐002]—PREPARATION OF SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS Federal Agency: All presented in the Schedule of Expenditures of Federal Awards. Program Name: All presented in the Schedule of Expenditures of Federal Awards. Assistance Listing Nos. and Program Expenditures: All presented in Schedule of Expenditures of Federal Awards. Award Number and Program Award Year: All presented in Schedule of Expenditures of Federal Awards. Compliance Requirement: Other – Schedule of Expenditures of Federal Awards preparation Statement of Condition During our audit, we reviewed the Coalition’s federal grants report for the fiscal year and identified the federal grants, Assistance Listing #s (AL#s) and the amounts of the federal expenditures and all of the other items required to properly present the Schedule of Expenditures of Federal Awards (SEFA). We then had the finance staff of the Coalition confirm the correctness of the SEFA. Despite the confirmation of accuracy, additional federal expenditures and grouping of grant expenditures were identified after several reviews of the SEFA.Criteria 2 CFR 200.510 indicates that the auditee must prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502, Basis for Determining Federal Awards Expended. Per 2 CFR 200.502, the determination of when a federal award is expended should be based on when the activity related to the federal award occurs. Generally, the activity pertains to events that require the non-federal entity to comply with federal statutes, regulations, and the terms and conditions of federal awards, such as expenditure/expense transactions associated with awards. In addition, 2 CFR Part 200.303 requires the program to establish and maintain effective internal controls over federal awards that provides reasonable assurance of compliance with federal statutes, regulations, and the terms and conditions of federal awards. Effect Without an established process governed by effective internal controls, the Coalition may not prevent or detect material misstatements on its SEFA in a timely manner. In addition, the errors could result in improper selections of major program(s) for the single audit and a substandard single audit. Cause Historically, the Coalition has requested the auditor assist in identifying accruals related to federal grant expenditures as the organization has maintained these records on a cash basis. As the organization has taken more responsibility on maintaining its federal grant expenditures on an accrual basis, an incomplete SEFA has been provided. Recommendation We recommend the Coalition prepare the Schedule of Expenditures of Federal Awards and submit this to the auditor for testing. The SEFA should include the name of the grant, name of grantor, the AL #, the pass-through number if applicable and a reconciliation of the federal revenues and expenditures to the Coalition’s general ledger. The Coalition staff should perform more detailed reviews of the reports to ensure they properly reflect grant receipts and expenditures. This review should be performed by someone other than the preparer and should include documented evidence of agreeing the reported data to the accounting records. We further recommend training for those individuals involved in the preparation and review of the reports to ensure they are fully aware of the requirements. View of Responsible Officials and Corrective Action Plan: The corrective Action Plan will be carried out in the 2024 Fiscal Year and information will be given to the auditors when requested for the next audit. The Coalition will ensure that all information needed for the SEFA is kept and entered accurately (this process has already begun). When the fiscal year closes out, the Coalition will provide the auditors with a test SEFA to confirm that the information we are collecting throughout the year and are asserting are the correct numbers for our federal grants, is indeed the correct information. Corrective Action Plan Timeline: Completed by December 13, 2024 (Final copy of the SEFA will not be given to the auditors until requested for the 2024 Audit) Designation Of Employee Position Responsible For Meeting Deadline: Executive Director will oversee this project and work directly with NMCEH finance staff work closely with the auditors to make sure that the information saved and shared is correct. Type of Finding: (F) Significant Deficiency in Internal Control over Compliance of Federal Awards. Questioned Costs: None
2023-002 [2022‐002]—PREPARATION OF SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS Federal Agency: All presented in the Schedule of Expenditures of Federal Awards. Program Name: All presented in the Schedule of Expenditures of Federal Awards. Assistance Listing Nos. and Program Expenditures: All presented in Schedule of Expenditures of Federal Awards. Award Number and Program Award Year: All presented in Schedule of Expenditures of Federal Awards. Compliance Requirement: Other – Schedule of Expenditures of Federal Awards preparation Statement of Condition During our audit, we reviewed the Coalition’s federal grants report for the fiscal year and identified the federal grants, Assistance Listing #s (AL#s) and the amounts of the federal expenditures and all of the other items required to properly present the Schedule of Expenditures of Federal Awards (SEFA). We then had the finance staff of the Coalition confirm the correctness of the SEFA. Despite the confirmation of accuracy, additional federal expenditures and grouping of grant expenditures were identified after several reviews of the SEFA.Criteria 2 CFR 200.510 indicates that the auditee must prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502, Basis for Determining Federal Awards Expended. Per 2 CFR 200.502, the determination of when a federal award is expended should be based on when the activity related to the federal award occurs. Generally, the activity pertains to events that require the non-federal entity to comply with federal statutes, regulations, and the terms and conditions of federal awards, such as expenditure/expense transactions associated with awards. In addition, 2 CFR Part 200.303 requires the program to establish and maintain effective internal controls over federal awards that provides reasonable assurance of compliance with federal statutes, regulations, and the terms and conditions of federal awards. Effect Without an established process governed by effective internal controls, the Coalition may not prevent or detect material misstatements on its SEFA in a timely manner. In addition, the errors could result in improper selections of major program(s) for the single audit and a substandard single audit. Cause Historically, the Coalition has requested the auditor assist in identifying accruals related to federal grant expenditures as the organization has maintained these records on a cash basis. As the organization has taken more responsibility on maintaining its federal grant expenditures on an accrual basis, an incomplete SEFA has been provided. Recommendation We recommend the Coalition prepare the Schedule of Expenditures of Federal Awards and submit this to the auditor for testing. The SEFA should include the name of the grant, name of grantor, the AL #, the pass-through number if applicable and a reconciliation of the federal revenues and expenditures to the Coalition’s general ledger. The Coalition staff should perform more detailed reviews of the reports to ensure they properly reflect grant receipts and expenditures. This review should be performed by someone other than the preparer and should include documented evidence of agreeing the reported data to the accounting records. We further recommend training for those individuals involved in the preparation and review of the reports to ensure they are fully aware of the requirements. View of Responsible Officials and Corrective Action Plan: The corrective Action Plan will be carried out in the 2024 Fiscal Year and information will be given to the auditors when requested for the next audit. The Coalition will ensure that all information needed for the SEFA is kept and entered accurately (this process has already begun). When the fiscal year closes out, the Coalition will provide the auditors with a test SEFA to confirm that the information we are collecting throughout the year and are asserting are the correct numbers for our federal grants, is indeed the correct information. Corrective Action Plan Timeline: Completed by December 13, 2024 (Final copy of the SEFA will not be given to the auditors until requested for the 2024 Audit) Designation Of Employee Position Responsible For Meeting Deadline: Executive Director will oversee this project and work directly with NMCEH finance staff work closely with the auditors to make sure that the information saved and shared is correct. Type of Finding: (F) Significant Deficiency in Internal Control over Compliance of Federal Awards. Questioned Costs: None
2023-002 [2022‐002]—PREPARATION OF SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS Federal Agency: All presented in the Schedule of Expenditures of Federal Awards. Program Name: All presented in the Schedule of Expenditures of Federal Awards. Assistance Listing Nos. and Program Expenditures: All presented in Schedule of Expenditures of Federal Awards. Award Number and Program Award Year: All presented in Schedule of Expenditures of Federal Awards. Compliance Requirement: Other – Schedule of Expenditures of Federal Awards preparation Statement of Condition During our audit, we reviewed the Coalition’s federal grants report for the fiscal year and identified the federal grants, Assistance Listing #s (AL#s) and the amounts of the federal expenditures and all of the other items required to properly present the Schedule of Expenditures of Federal Awards (SEFA). We then had the finance staff of the Coalition confirm the correctness of the SEFA. Despite the confirmation of accuracy, additional federal expenditures and grouping of grant expenditures were identified after several reviews of the SEFA.Criteria 2 CFR 200.510 indicates that the auditee must prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502, Basis for Determining Federal Awards Expended. Per 2 CFR 200.502, the determination of when a federal award is expended should be based on when the activity related to the federal award occurs. Generally, the activity pertains to events that require the non-federal entity to comply with federal statutes, regulations, and the terms and conditions of federal awards, such as expenditure/expense transactions associated with awards. In addition, 2 CFR Part 200.303 requires the program to establish and maintain effective internal controls over federal awards that provides reasonable assurance of compliance with federal statutes, regulations, and the terms and conditions of federal awards. Effect Without an established process governed by effective internal controls, the Coalition may not prevent or detect material misstatements on its SEFA in a timely manner. In addition, the errors could result in improper selections of major program(s) for the single audit and a substandard single audit. Cause Historically, the Coalition has requested the auditor assist in identifying accruals related to federal grant expenditures as the organization has maintained these records on a cash basis. As the organization has taken more responsibility on maintaining its federal grant expenditures on an accrual basis, an incomplete SEFA has been provided. Recommendation We recommend the Coalition prepare the Schedule of Expenditures of Federal Awards and submit this to the auditor for testing. The SEFA should include the name of the grant, name of grantor, the AL #, the pass-through number if applicable and a reconciliation of the federal revenues and expenditures to the Coalition’s general ledger. The Coalition staff should perform more detailed reviews of the reports to ensure they properly reflect grant receipts and expenditures. This review should be performed by someone other than the preparer and should include documented evidence of agreeing the reported data to the accounting records. We further recommend training for those individuals involved in the preparation and review of the reports to ensure they are fully aware of the requirements. View of Responsible Officials and Corrective Action Plan: The corrective Action Plan will be carried out in the 2024 Fiscal Year and information will be given to the auditors when requested for the next audit. The Coalition will ensure that all information needed for the SEFA is kept and entered accurately (this process has already begun). When the fiscal year closes out, the Coalition will provide the auditors with a test SEFA to confirm that the information we are collecting throughout the year and are asserting are the correct numbers for our federal grants, is indeed the correct information. Corrective Action Plan Timeline: Completed by December 13, 2024 (Final copy of the SEFA will not be given to the auditors until requested for the 2024 Audit) Designation Of Employee Position Responsible For Meeting Deadline: Executive Director will oversee this project and work directly with NMCEH finance staff work closely with the auditors to make sure that the information saved and shared is correct. Type of Finding: (F) Significant Deficiency in Internal Control over Compliance of Federal Awards. Questioned Costs: None
2023-002 [2022‐002]—PREPARATION OF SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS Federal Agency: All presented in the Schedule of Expenditures of Federal Awards. Program Name: All presented in the Schedule of Expenditures of Federal Awards. Assistance Listing Nos. and Program Expenditures: All presented in Schedule of Expenditures of Federal Awards. Award Number and Program Award Year: All presented in Schedule of Expenditures of Federal Awards. Compliance Requirement: Other – Schedule of Expenditures of Federal Awards preparation Statement of Condition During our audit, we reviewed the Coalition’s federal grants report for the fiscal year and identified the federal grants, Assistance Listing #s (AL#s) and the amounts of the federal expenditures and all of the other items required to properly present the Schedule of Expenditures of Federal Awards (SEFA). We then had the finance staff of the Coalition confirm the correctness of the SEFA. Despite the confirmation of accuracy, additional federal expenditures and grouping of grant expenditures were identified after several reviews of the SEFA.Criteria 2 CFR 200.510 indicates that the auditee must prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502, Basis for Determining Federal Awards Expended. Per 2 CFR 200.502, the determination of when a federal award is expended should be based on when the activity related to the federal award occurs. Generally, the activity pertains to events that require the non-federal entity to comply with federal statutes, regulations, and the terms and conditions of federal awards, such as expenditure/expense transactions associated with awards. In addition, 2 CFR Part 200.303 requires the program to establish and maintain effective internal controls over federal awards that provides reasonable assurance of compliance with federal statutes, regulations, and the terms and conditions of federal awards. Effect Without an established process governed by effective internal controls, the Coalition may not prevent or detect material misstatements on its SEFA in a timely manner. In addition, the errors could result in improper selections of major program(s) for the single audit and a substandard single audit. Cause Historically, the Coalition has requested the auditor assist in identifying accruals related to federal grant expenditures as the organization has maintained these records on a cash basis. As the organization has taken more responsibility on maintaining its federal grant expenditures on an accrual basis, an incomplete SEFA has been provided. Recommendation We recommend the Coalition prepare the Schedule of Expenditures of Federal Awards and submit this to the auditor for testing. The SEFA should include the name of the grant, name of grantor, the AL #, the pass-through number if applicable and a reconciliation of the federal revenues and expenditures to the Coalition’s general ledger. The Coalition staff should perform more detailed reviews of the reports to ensure they properly reflect grant receipts and expenditures. This review should be performed by someone other than the preparer and should include documented evidence of agreeing the reported data to the accounting records. We further recommend training for those individuals involved in the preparation and review of the reports to ensure they are fully aware of the requirements. View of Responsible Officials and Corrective Action Plan: The corrective Action Plan will be carried out in the 2024 Fiscal Year and information will be given to the auditors when requested for the next audit. The Coalition will ensure that all information needed for the SEFA is kept and entered accurately (this process has already begun). When the fiscal year closes out, the Coalition will provide the auditors with a test SEFA to confirm that the information we are collecting throughout the year and are asserting are the correct numbers for our federal grants, is indeed the correct information. Corrective Action Plan Timeline: Completed by December 13, 2024 (Final copy of the SEFA will not be given to the auditors until requested for the 2024 Audit) Designation Of Employee Position Responsible For Meeting Deadline: Executive Director will oversee this project and work directly with NMCEH finance staff work closely with the auditors to make sure that the information saved and shared is correct. Type of Finding: (F) Significant Deficiency in Internal Control over Compliance of Federal Awards. Questioned Costs: None
2023-002 [2022‐002]—PREPARATION OF SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS Federal Agency: All presented in the Schedule of Expenditures of Federal Awards. Program Name: All presented in the Schedule of Expenditures of Federal Awards. Assistance Listing Nos. and Program Expenditures: All presented in Schedule of Expenditures of Federal Awards. Award Number and Program Award Year: All presented in Schedule of Expenditures of Federal Awards. Compliance Requirement: Other – Schedule of Expenditures of Federal Awards preparation Statement of Condition During our audit, we reviewed the Coalition’s federal grants report for the fiscal year and identified the federal grants, Assistance Listing #s (AL#s) and the amounts of the federal expenditures and all of the other items required to properly present the Schedule of Expenditures of Federal Awards (SEFA). We then had the finance staff of the Coalition confirm the correctness of the SEFA. Despite the confirmation of accuracy, additional federal expenditures and grouping of grant expenditures were identified after several reviews of the SEFA.Criteria 2 CFR 200.510 indicates that the auditee must prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502, Basis for Determining Federal Awards Expended. Per 2 CFR 200.502, the determination of when a federal award is expended should be based on when the activity related to the federal award occurs. Generally, the activity pertains to events that require the non-federal entity to comply with federal statutes, regulations, and the terms and conditions of federal awards, such as expenditure/expense transactions associated with awards. In addition, 2 CFR Part 200.303 requires the program to establish and maintain effective internal controls over federal awards that provides reasonable assurance of compliance with federal statutes, regulations, and the terms and conditions of federal awards. Effect Without an established process governed by effective internal controls, the Coalition may not prevent or detect material misstatements on its SEFA in a timely manner. In addition, the errors could result in improper selections of major program(s) for the single audit and a substandard single audit. Cause Historically, the Coalition has requested the auditor assist in identifying accruals related to federal grant expenditures as the organization has maintained these records on a cash basis. As the organization has taken more responsibility on maintaining its federal grant expenditures on an accrual basis, an incomplete SEFA has been provided. Recommendation We recommend the Coalition prepare the Schedule of Expenditures of Federal Awards and submit this to the auditor for testing. The SEFA should include the name of the grant, name of grantor, the AL #, the pass-through number if applicable and a reconciliation of the federal revenues and expenditures to the Coalition’s general ledger. The Coalition staff should perform more detailed reviews of the reports to ensure they properly reflect grant receipts and expenditures. This review should be performed by someone other than the preparer and should include documented evidence of agreeing the reported data to the accounting records. We further recommend training for those individuals involved in the preparation and review of the reports to ensure they are fully aware of the requirements. View of Responsible Officials and Corrective Action Plan: The corrective Action Plan will be carried out in the 2024 Fiscal Year and information will be given to the auditors when requested for the next audit. The Coalition will ensure that all information needed for the SEFA is kept and entered accurately (this process has already begun). When the fiscal year closes out, the Coalition will provide the auditors with a test SEFA to confirm that the information we are collecting throughout the year and are asserting are the correct numbers for our federal grants, is indeed the correct information. Corrective Action Plan Timeline: Completed by December 13, 2024 (Final copy of the SEFA will not be given to the auditors until requested for the 2024 Audit) Designation Of Employee Position Responsible For Meeting Deadline: Executive Director will oversee this project and work directly with NMCEH finance staff work closely with the auditors to make sure that the information saved and shared is correct. Type of Finding: (F) Significant Deficiency in Internal Control over Compliance of Federal Awards. Questioned Costs: None
2023-002 [2022‐002]—PREPARATION OF SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS Federal Agency: All presented in the Schedule of Expenditures of Federal Awards. Program Name: All presented in the Schedule of Expenditures of Federal Awards. Assistance Listing Nos. and Program Expenditures: All presented in Schedule of Expenditures of Federal Awards. Award Number and Program Award Year: All presented in Schedule of Expenditures of Federal Awards. Compliance Requirement: Other – Schedule of Expenditures of Federal Awards preparation Statement of Condition During our audit, we reviewed the Coalition’s federal grants report for the fiscal year and identified the federal grants, Assistance Listing #s (AL#s) and the amounts of the federal expenditures and all of the other items required to properly present the Schedule of Expenditures of Federal Awards (SEFA). We then had the finance staff of the Coalition confirm the correctness of the SEFA. Despite the confirmation of accuracy, additional federal expenditures and grouping of grant expenditures were identified after several reviews of the SEFA.Criteria 2 CFR 200.510 indicates that the auditee must prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502, Basis for Determining Federal Awards Expended. Per 2 CFR 200.502, the determination of when a federal award is expended should be based on when the activity related to the federal award occurs. Generally, the activity pertains to events that require the non-federal entity to comply with federal statutes, regulations, and the terms and conditions of federal awards, such as expenditure/expense transactions associated with awards. In addition, 2 CFR Part 200.303 requires the program to establish and maintain effective internal controls over federal awards that provides reasonable assurance of compliance with federal statutes, regulations, and the terms and conditions of federal awards. Effect Without an established process governed by effective internal controls, the Coalition may not prevent or detect material misstatements on its SEFA in a timely manner. In addition, the errors could result in improper selections of major program(s) for the single audit and a substandard single audit. Cause Historically, the Coalition has requested the auditor assist in identifying accruals related to federal grant expenditures as the organization has maintained these records on a cash basis. As the organization has taken more responsibility on maintaining its federal grant expenditures on an accrual basis, an incomplete SEFA has been provided. Recommendation We recommend the Coalition prepare the Schedule of Expenditures of Federal Awards and submit this to the auditor for testing. The SEFA should include the name of the grant, name of grantor, the AL #, the pass-through number if applicable and a reconciliation of the federal revenues and expenditures to the Coalition’s general ledger. The Coalition staff should perform more detailed reviews of the reports to ensure they properly reflect grant receipts and expenditures. This review should be performed by someone other than the preparer and should include documented evidence of agreeing the reported data to the accounting records. We further recommend training for those individuals involved in the preparation and review of the reports to ensure they are fully aware of the requirements. View of Responsible Officials and Corrective Action Plan: The corrective Action Plan will be carried out in the 2024 Fiscal Year and information will be given to the auditors when requested for the next audit. The Coalition will ensure that all information needed for the SEFA is kept and entered accurately (this process has already begun). When the fiscal year closes out, the Coalition will provide the auditors with a test SEFA to confirm that the information we are collecting throughout the year and are asserting are the correct numbers for our federal grants, is indeed the correct information. Corrective Action Plan Timeline: Completed by December 13, 2024 (Final copy of the SEFA will not be given to the auditors until requested for the 2024 Audit) Designation Of Employee Position Responsible For Meeting Deadline: Executive Director will oversee this project and work directly with NMCEH finance staff work closely with the auditors to make sure that the information saved and shared is correct. Type of Finding: (F) Significant Deficiency in Internal Control over Compliance of Federal Awards. Questioned Costs: None
2023-002 [2022‐002]—PREPARATION OF SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS Federal Agency: All presented in the Schedule of Expenditures of Federal Awards. Program Name: All presented in the Schedule of Expenditures of Federal Awards. Assistance Listing Nos. and Program Expenditures: All presented in Schedule of Expenditures of Federal Awards. Award Number and Program Award Year: All presented in Schedule of Expenditures of Federal Awards. Compliance Requirement: Other – Schedule of Expenditures of Federal Awards preparation Statement of Condition During our audit, we reviewed the Coalition’s federal grants report for the fiscal year and identified the federal grants, Assistance Listing #s (AL#s) and the amounts of the federal expenditures and all of the other items required to properly present the Schedule of Expenditures of Federal Awards (SEFA). We then had the finance staff of the Coalition confirm the correctness of the SEFA. Despite the confirmation of accuracy, additional federal expenditures and grouping of grant expenditures were identified after several reviews of the SEFA.Criteria 2 CFR 200.510 indicates that the auditee must prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502, Basis for Determining Federal Awards Expended. Per 2 CFR 200.502, the determination of when a federal award is expended should be based on when the activity related to the federal award occurs. Generally, the activity pertains to events that require the non-federal entity to comply with federal statutes, regulations, and the terms and conditions of federal awards, such as expenditure/expense transactions associated with awards. In addition, 2 CFR Part 200.303 requires the program to establish and maintain effective internal controls over federal awards that provides reasonable assurance of compliance with federal statutes, regulations, and the terms and conditions of federal awards. Effect Without an established process governed by effective internal controls, the Coalition may not prevent or detect material misstatements on its SEFA in a timely manner. In addition, the errors could result in improper selections of major program(s) for the single audit and a substandard single audit. Cause Historically, the Coalition has requested the auditor assist in identifying accruals related to federal grant expenditures as the organization has maintained these records on a cash basis. As the organization has taken more responsibility on maintaining its federal grant expenditures on an accrual basis, an incomplete SEFA has been provided. Recommendation We recommend the Coalition prepare the Schedule of Expenditures of Federal Awards and submit this to the auditor for testing. The SEFA should include the name of the grant, name of grantor, the AL #, the pass-through number if applicable and a reconciliation of the federal revenues and expenditures to the Coalition’s general ledger. The Coalition staff should perform more detailed reviews of the reports to ensure they properly reflect grant receipts and expenditures. This review should be performed by someone other than the preparer and should include documented evidence of agreeing the reported data to the accounting records. We further recommend training for those individuals involved in the preparation and review of the reports to ensure they are fully aware of the requirements. View of Responsible Officials and Corrective Action Plan: The corrective Action Plan will be carried out in the 2024 Fiscal Year and information will be given to the auditors when requested for the next audit. The Coalition will ensure that all information needed for the SEFA is kept and entered accurately (this process has already begun). When the fiscal year closes out, the Coalition will provide the auditors with a test SEFA to confirm that the information we are collecting throughout the year and are asserting are the correct numbers for our federal grants, is indeed the correct information. Corrective Action Plan Timeline: Completed by December 13, 2024 (Final copy of the SEFA will not be given to the auditors until requested for the 2024 Audit) Designation Of Employee Position Responsible For Meeting Deadline: Executive Director will oversee this project and work directly with NMCEH finance staff work closely with the auditors to make sure that the information saved and shared is correct. Type of Finding: (F) Significant Deficiency in Internal Control over Compliance of Federal Awards. Questioned Costs: None
2023-002 [2022‐002]—PREPARATION OF SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS Federal Agency: All presented in the Schedule of Expenditures of Federal Awards. Program Name: All presented in the Schedule of Expenditures of Federal Awards. Assistance Listing Nos. and Program Expenditures: All presented in Schedule of Expenditures of Federal Awards. Award Number and Program Award Year: All presented in Schedule of Expenditures of Federal Awards. Compliance Requirement: Other – Schedule of Expenditures of Federal Awards preparation Statement of Condition During our audit, we reviewed the Coalition’s federal grants report for the fiscal year and identified the federal grants, Assistance Listing #s (AL#s) and the amounts of the federal expenditures and all of the other items required to properly present the Schedule of Expenditures of Federal Awards (SEFA). We then had the finance staff of the Coalition confirm the correctness of the SEFA. Despite the confirmation of accuracy, additional federal expenditures and grouping of grant expenditures were identified after several reviews of the SEFA.Criteria 2 CFR 200.510 indicates that the auditee must prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502, Basis for Determining Federal Awards Expended. Per 2 CFR 200.502, the determination of when a federal award is expended should be based on when the activity related to the federal award occurs. Generally, the activity pertains to events that require the non-federal entity to comply with federal statutes, regulations, and the terms and conditions of federal awards, such as expenditure/expense transactions associated with awards. In addition, 2 CFR Part 200.303 requires the program to establish and maintain effective internal controls over federal awards that provides reasonable assurance of compliance with federal statutes, regulations, and the terms and conditions of federal awards. Effect Without an established process governed by effective internal controls, the Coalition may not prevent or detect material misstatements on its SEFA in a timely manner. In addition, the errors could result in improper selections of major program(s) for the single audit and a substandard single audit. Cause Historically, the Coalition has requested the auditor assist in identifying accruals related to federal grant expenditures as the organization has maintained these records on a cash basis. As the organization has taken more responsibility on maintaining its federal grant expenditures on an accrual basis, an incomplete SEFA has been provided. Recommendation We recommend the Coalition prepare the Schedule of Expenditures of Federal Awards and submit this to the auditor for testing. The SEFA should include the name of the grant, name of grantor, the AL #, the pass-through number if applicable and a reconciliation of the federal revenues and expenditures to the Coalition’s general ledger. The Coalition staff should perform more detailed reviews of the reports to ensure they properly reflect grant receipts and expenditures. This review should be performed by someone other than the preparer and should include documented evidence of agreeing the reported data to the accounting records. We further recommend training for those individuals involved in the preparation and review of the reports to ensure they are fully aware of the requirements. View of Responsible Officials and Corrective Action Plan: The corrective Action Plan will be carried out in the 2024 Fiscal Year and information will be given to the auditors when requested for the next audit. The Coalition will ensure that all information needed for the SEFA is kept and entered accurately (this process has already begun). When the fiscal year closes out, the Coalition will provide the auditors with a test SEFA to confirm that the information we are collecting throughout the year and are asserting are the correct numbers for our federal grants, is indeed the correct information. Corrective Action Plan Timeline: Completed by December 13, 2024 (Final copy of the SEFA will not be given to the auditors until requested for the 2024 Audit) Designation Of Employee Position Responsible For Meeting Deadline: Executive Director will oversee this project and work directly with NMCEH finance staff work closely with the auditors to make sure that the information saved and shared is correct. Type of Finding: (F) Significant Deficiency in Internal Control over Compliance of Federal Awards. Questioned Costs: None
2023-002 [2022‐002]—PREPARATION OF SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS Federal Agency: All presented in the Schedule of Expenditures of Federal Awards. Program Name: All presented in the Schedule of Expenditures of Federal Awards. Assistance Listing Nos. and Program Expenditures: All presented in Schedule of Expenditures of Federal Awards. Award Number and Program Award Year: All presented in Schedule of Expenditures of Federal Awards. Compliance Requirement: Other – Schedule of Expenditures of Federal Awards preparation Statement of Condition During our audit, we reviewed the Coalition’s federal grants report for the fiscal year and identified the federal grants, Assistance Listing #s (AL#s) and the amounts of the federal expenditures and all of the other items required to properly present the Schedule of Expenditures of Federal Awards (SEFA). We then had the finance staff of the Coalition confirm the correctness of the SEFA. Despite the confirmation of accuracy, additional federal expenditures and grouping of grant expenditures were identified after several reviews of the SEFA.Criteria 2 CFR 200.510 indicates that the auditee must prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502, Basis for Determining Federal Awards Expended. Per 2 CFR 200.502, the determination of when a federal award is expended should be based on when the activity related to the federal award occurs. Generally, the activity pertains to events that require the non-federal entity to comply with federal statutes, regulations, and the terms and conditions of federal awards, such as expenditure/expense transactions associated with awards. In addition, 2 CFR Part 200.303 requires the program to establish and maintain effective internal controls over federal awards that provides reasonable assurance of compliance with federal statutes, regulations, and the terms and conditions of federal awards. Effect Without an established process governed by effective internal controls, the Coalition may not prevent or detect material misstatements on its SEFA in a timely manner. In addition, the errors could result in improper selections of major program(s) for the single audit and a substandard single audit. Cause Historically, the Coalition has requested the auditor assist in identifying accruals related to federal grant expenditures as the organization has maintained these records on a cash basis. As the organization has taken more responsibility on maintaining its federal grant expenditures on an accrual basis, an incomplete SEFA has been provided. Recommendation We recommend the Coalition prepare the Schedule of Expenditures of Federal Awards and submit this to the auditor for testing. The SEFA should include the name of the grant, name of grantor, the AL #, the pass-through number if applicable and a reconciliation of the federal revenues and expenditures to the Coalition’s general ledger. The Coalition staff should perform more detailed reviews of the reports to ensure they properly reflect grant receipts and expenditures. This review should be performed by someone other than the preparer and should include documented evidence of agreeing the reported data to the accounting records. We further recommend training for those individuals involved in the preparation and review of the reports to ensure they are fully aware of the requirements. View of Responsible Officials and Corrective Action Plan: The corrective Action Plan will be carried out in the 2024 Fiscal Year and information will be given to the auditors when requested for the next audit. The Coalition will ensure that all information needed for the SEFA is kept and entered accurately (this process has already begun). When the fiscal year closes out, the Coalition will provide the auditors with a test SEFA to confirm that the information we are collecting throughout the year and are asserting are the correct numbers for our federal grants, is indeed the correct information. Corrective Action Plan Timeline: Completed by December 13, 2024 (Final copy of the SEFA will not be given to the auditors until requested for the 2024 Audit) Designation Of Employee Position Responsible For Meeting Deadline: Executive Director will oversee this project and work directly with NMCEH finance staff work closely with the auditors to make sure that the information saved and shared is correct. Type of Finding: (F) Significant Deficiency in Internal Control over Compliance of Federal Awards. Questioned Costs: None
2023-002 [2022‐002]—PREPARATION OF SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS Federal Agency: All presented in the Schedule of Expenditures of Federal Awards. Program Name: All presented in the Schedule of Expenditures of Federal Awards. Assistance Listing Nos. and Program Expenditures: All presented in Schedule of Expenditures of Federal Awards. Award Number and Program Award Year: All presented in Schedule of Expenditures of Federal Awards. Compliance Requirement: Other – Schedule of Expenditures of Federal Awards preparation Statement of Condition During our audit, we reviewed the Coalition’s federal grants report for the fiscal year and identified the federal grants, Assistance Listing #s (AL#s) and the amounts of the federal expenditures and all of the other items required to properly present the Schedule of Expenditures of Federal Awards (SEFA). We then had the finance staff of the Coalition confirm the correctness of the SEFA. Despite the confirmation of accuracy, additional federal expenditures and grouping of grant expenditures were identified after several reviews of the SEFA.Criteria 2 CFR 200.510 indicates that the auditee must prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502, Basis for Determining Federal Awards Expended. Per 2 CFR 200.502, the determination of when a federal award is expended should be based on when the activity related to the federal award occurs. Generally, the activity pertains to events that require the non-federal entity to comply with federal statutes, regulations, and the terms and conditions of federal awards, such as expenditure/expense transactions associated with awards. In addition, 2 CFR Part 200.303 requires the program to establish and maintain effective internal controls over federal awards that provides reasonable assurance of compliance with federal statutes, regulations, and the terms and conditions of federal awards. Effect Without an established process governed by effective internal controls, the Coalition may not prevent or detect material misstatements on its SEFA in a timely manner. In addition, the errors could result in improper selections of major program(s) for the single audit and a substandard single audit. Cause Historically, the Coalition has requested the auditor assist in identifying accruals related to federal grant expenditures as the organization has maintained these records on a cash basis. As the organization has taken more responsibility on maintaining its federal grant expenditures on an accrual basis, an incomplete SEFA has been provided. Recommendation We recommend the Coalition prepare the Schedule of Expenditures of Federal Awards and submit this to the auditor for testing. The SEFA should include the name of the grant, name of grantor, the AL #, the pass-through number if applicable and a reconciliation of the federal revenues and expenditures to the Coalition’s general ledger. The Coalition staff should perform more detailed reviews of the reports to ensure they properly reflect grant receipts and expenditures. This review should be performed by someone other than the preparer and should include documented evidence of agreeing the reported data to the accounting records. We further recommend training for those individuals involved in the preparation and review of the reports to ensure they are fully aware of the requirements. View of Responsible Officials and Corrective Action Plan: The corrective Action Plan will be carried out in the 2024 Fiscal Year and information will be given to the auditors when requested for the next audit. The Coalition will ensure that all information needed for the SEFA is kept and entered accurately (this process has already begun). When the fiscal year closes out, the Coalition will provide the auditors with a test SEFA to confirm that the information we are collecting throughout the year and are asserting are the correct numbers for our federal grants, is indeed the correct information. Corrective Action Plan Timeline: Completed by December 13, 2024 (Final copy of the SEFA will not be given to the auditors until requested for the 2024 Audit) Designation Of Employee Position Responsible For Meeting Deadline: Executive Director will oversee this project and work directly with NMCEH finance staff work closely with the auditors to make sure that the information saved and shared is correct. Type of Finding: (F) Significant Deficiency in Internal Control over Compliance of Federal Awards. Questioned Costs: None
2023-002 [2022‐002]—PREPARATION OF SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS Federal Agency: All presented in the Schedule of Expenditures of Federal Awards. Program Name: All presented in the Schedule of Expenditures of Federal Awards. Assistance Listing Nos. and Program Expenditures: All presented in Schedule of Expenditures of Federal Awards. Award Number and Program Award Year: All presented in Schedule of Expenditures of Federal Awards. Compliance Requirement: Other – Schedule of Expenditures of Federal Awards preparation Statement of Condition During our audit, we reviewed the Coalition’s federal grants report for the fiscal year and identified the federal grants, Assistance Listing #s (AL#s) and the amounts of the federal expenditures and all of the other items required to properly present the Schedule of Expenditures of Federal Awards (SEFA). We then had the finance staff of the Coalition confirm the correctness of the SEFA. Despite the confirmation of accuracy, additional federal expenditures and grouping of grant expenditures were identified after several reviews of the SEFA.Criteria 2 CFR 200.510 indicates that the auditee must prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502, Basis for Determining Federal Awards Expended. Per 2 CFR 200.502, the determination of when a federal award is expended should be based on when the activity related to the federal award occurs. Generally, the activity pertains to events that require the non-federal entity to comply with federal statutes, regulations, and the terms and conditions of federal awards, such as expenditure/expense transactions associated with awards. In addition, 2 CFR Part 200.303 requires the program to establish and maintain effective internal controls over federal awards that provides reasonable assurance of compliance with federal statutes, regulations, and the terms and conditions of federal awards. Effect Without an established process governed by effective internal controls, the Coalition may not prevent or detect material misstatements on its SEFA in a timely manner. In addition, the errors could result in improper selections of major program(s) for the single audit and a substandard single audit. Cause Historically, the Coalition has requested the auditor assist in identifying accruals related to federal grant expenditures as the organization has maintained these records on a cash basis. As the organization has taken more responsibility on maintaining its federal grant expenditures on an accrual basis, an incomplete SEFA has been provided. Recommendation We recommend the Coalition prepare the Schedule of Expenditures of Federal Awards and submit this to the auditor for testing. The SEFA should include the name of the grant, name of grantor, the AL #, the pass-through number if applicable and a reconciliation of the federal revenues and expenditures to the Coalition’s general ledger. The Coalition staff should perform more detailed reviews of the reports to ensure they properly reflect grant receipts and expenditures. This review should be performed by someone other than the preparer and should include documented evidence of agreeing the reported data to the accounting records. We further recommend training for those individuals involved in the preparation and review of the reports to ensure they are fully aware of the requirements. View of Responsible Officials and Corrective Action Plan: The corrective Action Plan will be carried out in the 2024 Fiscal Year and information will be given to the auditors when requested for the next audit. The Coalition will ensure that all information needed for the SEFA is kept and entered accurately (this process has already begun). When the fiscal year closes out, the Coalition will provide the auditors with a test SEFA to confirm that the information we are collecting throughout the year and are asserting are the correct numbers for our federal grants, is indeed the correct information. Corrective Action Plan Timeline: Completed by December 13, 2024 (Final copy of the SEFA will not be given to the auditors until requested for the 2024 Audit) Designation Of Employee Position Responsible For Meeting Deadline: Executive Director will oversee this project and work directly with NMCEH finance staff work closely with the auditors to make sure that the information saved and shared is correct. Type of Finding: (F) Significant Deficiency in Internal Control over Compliance of Federal Awards. Questioned Costs: None
2023-002 [2022‐002]—PREPARATION OF SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS Federal Agency: All presented in the Schedule of Expenditures of Federal Awards. Program Name: All presented in the Schedule of Expenditures of Federal Awards. Assistance Listing Nos. and Program Expenditures: All presented in Schedule of Expenditures of Federal Awards. Award Number and Program Award Year: All presented in Schedule of Expenditures of Federal Awards. Compliance Requirement: Other – Schedule of Expenditures of Federal Awards preparation Statement of Condition During our audit, we reviewed the Coalition’s federal grants report for the fiscal year and identified the federal grants, Assistance Listing #s (AL#s) and the amounts of the federal expenditures and all of the other items required to properly present the Schedule of Expenditures of Federal Awards (SEFA). We then had the finance staff of the Coalition confirm the correctness of the SEFA. Despite the confirmation of accuracy, additional federal expenditures and grouping of grant expenditures were identified after several reviews of the SEFA.Criteria 2 CFR 200.510 indicates that the auditee must prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502, Basis for Determining Federal Awards Expended. Per 2 CFR 200.502, the determination of when a federal award is expended should be based on when the activity related to the federal award occurs. Generally, the activity pertains to events that require the non-federal entity to comply with federal statutes, regulations, and the terms and conditions of federal awards, such as expenditure/expense transactions associated with awards. In addition, 2 CFR Part 200.303 requires the program to establish and maintain effective internal controls over federal awards that provides reasonable assurance of compliance with federal statutes, regulations, and the terms and conditions of federal awards. Effect Without an established process governed by effective internal controls, the Coalition may not prevent or detect material misstatements on its SEFA in a timely manner. In addition, the errors could result in improper selections of major program(s) for the single audit and a substandard single audit. Cause Historically, the Coalition has requested the auditor assist in identifying accruals related to federal grant expenditures as the organization has maintained these records on a cash basis. As the organization has taken more responsibility on maintaining its federal grant expenditures on an accrual basis, an incomplete SEFA has been provided. Recommendation We recommend the Coalition prepare the Schedule of Expenditures of Federal Awards and submit this to the auditor for testing. The SEFA should include the name of the grant, name of grantor, the AL #, the pass-through number if applicable and a reconciliation of the federal revenues and expenditures to the Coalition’s general ledger. The Coalition staff should perform more detailed reviews of the reports to ensure they properly reflect grant receipts and expenditures. This review should be performed by someone other than the preparer and should include documented evidence of agreeing the reported data to the accounting records. We further recommend training for those individuals involved in the preparation and review of the reports to ensure they are fully aware of the requirements. View of Responsible Officials and Corrective Action Plan: The corrective Action Plan will be carried out in the 2024 Fiscal Year and information will be given to the auditors when requested for the next audit. The Coalition will ensure that all information needed for the SEFA is kept and entered accurately (this process has already begun). When the fiscal year closes out, the Coalition will provide the auditors with a test SEFA to confirm that the information we are collecting throughout the year and are asserting are the correct numbers for our federal grants, is indeed the correct information. Corrective Action Plan Timeline: Completed by December 13, 2024 (Final copy of the SEFA will not be given to the auditors until requested for the 2024 Audit) Designation Of Employee Position Responsible For Meeting Deadline: Executive Director will oversee this project and work directly with NMCEH finance staff work closely with the auditors to make sure that the information saved and shared is correct. Type of Finding: (F) Significant Deficiency in Internal Control over Compliance of Federal Awards. Questioned Costs: None
2023-002 [2022‐002]—PREPARATION OF SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS Federal Agency: All presented in the Schedule of Expenditures of Federal Awards. Program Name: All presented in the Schedule of Expenditures of Federal Awards. Assistance Listing Nos. and Program Expenditures: All presented in Schedule of Expenditures of Federal Awards. Award Number and Program Award Year: All presented in Schedule of Expenditures of Federal Awards. Compliance Requirement: Other – Schedule of Expenditures of Federal Awards preparation Statement of Condition During our audit, we reviewed the Coalition’s federal grants report for the fiscal year and identified the federal grants, Assistance Listing #s (AL#s) and the amounts of the federal expenditures and all of the other items required to properly present the Schedule of Expenditures of Federal Awards (SEFA). We then had the finance staff of the Coalition confirm the correctness of the SEFA. Despite the confirmation of accuracy, additional federal expenditures and grouping of grant expenditures were identified after several reviews of the SEFA.Criteria 2 CFR 200.510 indicates that the auditee must prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502, Basis for Determining Federal Awards Expended. Per 2 CFR 200.502, the determination of when a federal award is expended should be based on when the activity related to the federal award occurs. Generally, the activity pertains to events that require the non-federal entity to comply with federal statutes, regulations, and the terms and conditions of federal awards, such as expenditure/expense transactions associated with awards. In addition, 2 CFR Part 200.303 requires the program to establish and maintain effective internal controls over federal awards that provides reasonable assurance of compliance with federal statutes, regulations, and the terms and conditions of federal awards. Effect Without an established process governed by effective internal controls, the Coalition may not prevent or detect material misstatements on its SEFA in a timely manner. In addition, the errors could result in improper selections of major program(s) for the single audit and a substandard single audit. Cause Historically, the Coalition has requested the auditor assist in identifying accruals related to federal grant expenditures as the organization has maintained these records on a cash basis. As the organization has taken more responsibility on maintaining its federal grant expenditures on an accrual basis, an incomplete SEFA has been provided. Recommendation We recommend the Coalition prepare the Schedule of Expenditures of Federal Awards and submit this to the auditor for testing. The SEFA should include the name of the grant, name of grantor, the AL #, the pass-through number if applicable and a reconciliation of the federal revenues and expenditures to the Coalition’s general ledger. The Coalition staff should perform more detailed reviews of the reports to ensure they properly reflect grant receipts and expenditures. This review should be performed by someone other than the preparer and should include documented evidence of agreeing the reported data to the accounting records. We further recommend training for those individuals involved in the preparation and review of the reports to ensure they are fully aware of the requirements. View of Responsible Officials and Corrective Action Plan: The corrective Action Plan will be carried out in the 2024 Fiscal Year and information will be given to the auditors when requested for the next audit. The Coalition will ensure that all information needed for the SEFA is kept and entered accurately (this process has already begun). When the fiscal year closes out, the Coalition will provide the auditors with a test SEFA to confirm that the information we are collecting throughout the year and are asserting are the correct numbers for our federal grants, is indeed the correct information. Corrective Action Plan Timeline: Completed by December 13, 2024 (Final copy of the SEFA will not be given to the auditors until requested for the 2024 Audit) Designation Of Employee Position Responsible For Meeting Deadline: Executive Director will oversee this project and work directly with NMCEH finance staff work closely with the auditors to make sure that the information saved and shared is correct. Type of Finding: (F) Significant Deficiency in Internal Control over Compliance of Federal Awards. Questioned Costs: None
Item 2023‐001 Eligibility (Repeat) Assistance Listing Number 93.499 Low Income Home Water Assistance Program U.S. Department of Health and Human Services Passed through the Alabama Department of Economic and Community Affairs Pass‐through Grant No. LW-010-CONS and LW-010-ARP Condition – The Agency lacked adequate controls to ensure compliance with the award calculation of eligible applicants receiving grant assistance as outlined by the Low-Income Household Water Assistance Program (LIHWAP) policies and procedures manual published by the pass through grantor, Alabama Department of Economic and Community Affairs (ADECA). During a dual-purpose test of controls and compliance seven applicants out of a sample of sixty received water awards that were erroneously calculated. Approved applications for the seven applicants supported that the applicant met eligibility requirements to receive a program award; however, the award amounts for the seven applicants were not computed correctly in accordance with the grant award guidelines. Criteria – As specified in 2 CFR section 200.303 the non‐Federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non‐ Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. Cause – Lack of sufficient controls to ensure supporting documentation for eligibility and award calculation is being input into the award system accurately and that the program award for each applicant is being calculated correctly. Questioned Costs – Net $31.59 known, $1,367 likely Effect – Lack of proper approval and recalculation of awards to participants could result in disallowed costs. Recommendation – We recommend the implementation of additional controls to ensure proper review and approval of award totals for eligible individuals seeking to receive benefits from the program. Management’s Response – See “Corrective Action Plan”
Item 2023‐001 Eligibility (Repeat) Assistance Listing Number 93.499 Low Income Home Water Assistance Program U.S. Department of Health and Human Services Passed through the Alabama Department of Economic and Community Affairs Pass‐through Grant No. LW-010-CONS and LW-010-ARP Condition – The Agency lacked adequate controls to ensure compliance with the award calculation of eligible applicants receiving grant assistance as outlined by the Low-Income Household Water Assistance Program (LIHWAP) policies and procedures manual published by the pass through grantor, Alabama Department of Economic and Community Affairs (ADECA). During a dual-purpose test of controls and compliance seven applicants out of a sample of sixty received water awards that were erroneously calculated. Approved applications for the seven applicants supported that the applicant met eligibility requirements to receive a program award; however, the award amounts for the seven applicants were not computed correctly in accordance with the grant award guidelines. Criteria – As specified in 2 CFR section 200.303 the non‐Federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non‐ Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. Cause – Lack of sufficient controls to ensure supporting documentation for eligibility and award calculation is being input into the award system accurately and that the program award for each applicant is being calculated correctly. Questioned Costs – Net $31.59 known, $1,367 likely Effect – Lack of proper approval and recalculation of awards to participants could result in disallowed costs. Recommendation – We recommend the implementation of additional controls to ensure proper review and approval of award totals for eligible individuals seeking to receive benefits from the program. Management’s Response – See “Corrective Action Plan”
Assistance Listing, Federal Agency, and Program Name - ALN 14.218, U.S. Department of Housing and Urban Development, Entitlement Grants Cluster (CDBG), Community Development Block Grants/Entitlement Grants Federal Award Identification Number and Year - All grants listed on SEFA Pass-through Entity - Not applicable Finding Type - Material weakness Repeat Finding - No Criteria - Per 24 CFR section 570.603 - Grantees must adhere to the labor standards applicable to non-volunteer labor per 42 USC 53110 when rehabilitating residential property that contains no fewer than eight units, which includes ensuring prevailing wage rates are being used. Additionally, per 2 CFR section 200.303 - Grantees must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in Standards for Internal Control in the Federal Government issued by the Comptroller General of the United States or the Internal Control Integrated Framework, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition - The County did not have controls in place, during the year under audit, to ensure that the required certified payrolls were received and reviewed by the County. Questioned Costs - None Identification of How Questioned Costs Were Computed - Not applicable Context - The County has a process in place to receive and review weekly payroll certifications from contractors and subcontractors. However, there is not a control in place to ensure that all weekly payroll certifications have been received and reviewed. Cause and Effect - The County did not have controls in place ensure that the required certified payrolls were received and reviewed. For the sample selected for testing, the County was still in compliance with the applicable laws and regulations. Recommendation - We recommend that the County implement a control to ensure that the required certified payrolls from contractors and subcontractors are received and reviewed timely. Views of Responsible Officials and Corrective Action Plan - A process will be put into place to ensure certified payrolls are received and reviewed by two staff employees.
Assistance Listing, Federal Agency, and Program Name - ALN 14.218, U.S. Department of Housing and Urban Development, Entitlement Grants Cluster (CDBG), Community Development Block Grants/Entitlement Grants Federal Award Identification Number and Year - All grants listed on SEFA Pass-through Entity - Not applicable Finding Type - Material weakness Repeat Finding - No Criteria - Per 24 CFR section 570.603 - Grantees must adhere to the labor standards applicable to non-volunteer labor per 42 USC 53110 when rehabilitating residential property that contains no fewer than eight units, which includes ensuring prevailing wage rates are being used. Additionally, per 2 CFR section 200.303 - Grantees must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in Standards for Internal Control in the Federal Government issued by the Comptroller General of the United States or the Internal Control Integrated Framework, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition - The County did not have controls in place, during the year under audit, to ensure that the required certified payrolls were received and reviewed by the County. Questioned Costs - None Identification of How Questioned Costs Were Computed - Not applicable Context - The County has a process in place to receive and review weekly payroll certifications from contractors and subcontractors. However, there is not a control in place to ensure that all weekly payroll certifications have been received and reviewed. Cause and Effect - The County did not have controls in place ensure that the required certified payrolls were received and reviewed. For the sample selected for testing, the County was still in compliance with the applicable laws and regulations. Recommendation - We recommend that the County implement a control to ensure that the required certified payrolls from contractors and subcontractors are received and reviewed timely. Views of Responsible Officials and Corrective Action Plan - A process will be put into place to ensure certified payrolls are received and reviewed by two staff employees.
Assistance Listing, Federal Agency, and Program Name - ALN 14.218, U.S. Department of Housing and Urban Development, Entitlement Grants Cluster (CDBG), Community Development Block Grants/Entitlement Grants Federal Award Identification Number and Year - All grants listed on SEFA Pass-through Entity - Not applicable Finding Type - Material weakness Repeat Finding - No Criteria - Per 24 CFR section 570.603 - Grantees must adhere to the labor standards applicable to non-volunteer labor per 42 USC 53110 when rehabilitating residential property that contains no fewer than eight units, which includes ensuring prevailing wage rates are being used. Additionally, per 2 CFR section 200.303 - Grantees must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in Standards for Internal Control in the Federal Government issued by the Comptroller General of the United States or the Internal Control Integrated Framework, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition - The County did not have controls in place, during the year under audit, to ensure that the required certified payrolls were received and reviewed by the County. Questioned Costs - None Identification of How Questioned Costs Were Computed - Not applicable Context - The County has a process in place to receive and review weekly payroll certifications from contractors and subcontractors. However, there is not a control in place to ensure that all weekly payroll certifications have been received and reviewed. Cause and Effect - The County did not have controls in place ensure that the required certified payrolls were received and reviewed. For the sample selected for testing, the County was still in compliance with the applicable laws and regulations. Recommendation - We recommend that the County implement a control to ensure that the required certified payrolls from contractors and subcontractors are received and reviewed timely. Views of Responsible Officials and Corrective Action Plan - A process will be put into place to ensure certified payrolls are received and reviewed by two staff employees.
Assistance Listing, Federal Agency, and Program Name - ALN 14.218, U.S. Department of Housing and Urban Development, Entitlement Grants Cluster (CDBG), Community Development Block Grants/Entitlement Grants Federal Award Identification Number and Year - All grants listed on SEFA Pass-through Entity - Not applicable Finding Type - Material weakness Repeat Finding - No Criteria - Per 24 CFR section 570.603 - Grantees must adhere to the labor standards applicable to non-volunteer labor per 42 USC 53110 when rehabilitating residential property that contains no fewer than eight units, which includes ensuring prevailing wage rates are being used. Additionally, per 2 CFR section 200.303 - Grantees must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in Standards for Internal Control in the Federal Government issued by the Comptroller General of the United States or the Internal Control Integrated Framework, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition - The County did not have controls in place, during the year under audit, to ensure that the required certified payrolls were received and reviewed by the County. Questioned Costs - None Identification of How Questioned Costs Were Computed - Not applicable Context - The County has a process in place to receive and review weekly payroll certifications from contractors and subcontractors. However, there is not a control in place to ensure that all weekly payroll certifications have been received and reviewed. Cause and Effect - The County did not have controls in place ensure that the required certified payrolls were received and reviewed. For the sample selected for testing, the County was still in compliance with the applicable laws and regulations. Recommendation - We recommend that the County implement a control to ensure that the required certified payrolls from contractors and subcontractors are received and reviewed timely. Views of Responsible Officials and Corrective Action Plan - A process will be put into place to ensure certified payrolls are received and reviewed by two staff employees.
Assistance Listing, Federal Agency, and Program Name - ALN 14.218, U.S. Department of Housing and Urban Development, Entitlement Grants Cluster (CDBG), Community Development Block Grants/Entitlement Grants Federal Award Identification Number and Year - All grants listed on SEFA Pass-through Entity - Not applicable Finding Type - Material weakness Repeat Finding - No Criteria - Per 24 CFR section 570.603 - Grantees must adhere to the labor standards applicable to non-volunteer labor per 42 USC 53110 when rehabilitating residential property that contains no fewer than eight units, which includes ensuring prevailing wage rates are being used. Additionally, per 2 CFR section 200.303 - Grantees must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in Standards for Internal Control in the Federal Government issued by the Comptroller General of the United States or the Internal Control Integrated Framework, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition - The County did not have controls in place, during the year under audit, to ensure that the required certified payrolls were received and reviewed by the County. Questioned Costs - None Identification of How Questioned Costs Were Computed - Not applicable Context - The County has a process in place to receive and review weekly payroll certifications from contractors and subcontractors. However, there is not a control in place to ensure that all weekly payroll certifications have been received and reviewed. Cause and Effect - The County did not have controls in place ensure that the required certified payrolls were received and reviewed. For the sample selected for testing, the County was still in compliance with the applicable laws and regulations. Recommendation - We recommend that the County implement a control to ensure that the required certified payrolls from contractors and subcontractors are received and reviewed timely. Views of Responsible Officials and Corrective Action Plan - A process will be put into place to ensure certified payrolls are received and reviewed by two staff employees.
Assistance Listing, Federal Agency, and Program Name - ALN 14.218, U.S. Department of Housing and Urban Development, Entitlement Grants Cluster (CDBG), Community Development Block Grants/Entitlement Grants Federal Award Identification Number and Year - All grants listed on SEFA Pass-through Entity - Not applicable Finding Type - Material weakness Repeat Finding - No Criteria - Per 24 CFR section 570.603 - Grantees must adhere to the labor standards applicable to non-volunteer labor per 42 USC 53110 when rehabilitating residential property that contains no fewer than eight units, which includes ensuring prevailing wage rates are being used. Additionally, per 2 CFR section 200.303 - Grantees must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in Standards for Internal Control in the Federal Government issued by the Comptroller General of the United States or the Internal Control Integrated Framework, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition - The County did not have controls in place, during the year under audit, to ensure that the required certified payrolls were received and reviewed by the County. Questioned Costs - None Identification of How Questioned Costs Were Computed - Not applicable Context - The County has a process in place to receive and review weekly payroll certifications from contractors and subcontractors. However, there is not a control in place to ensure that all weekly payroll certifications have been received and reviewed. Cause and Effect - The County did not have controls in place ensure that the required certified payrolls were received and reviewed. For the sample selected for testing, the County was still in compliance with the applicable laws and regulations. Recommendation - We recommend that the County implement a control to ensure that the required certified payrolls from contractors and subcontractors are received and reviewed timely. Views of Responsible Officials and Corrective Action Plan - A process will be put into place to ensure certified payrolls are received and reviewed by two staff employees.
Assistance Listing, Federal Agency, and Program Name - ALN 14.218, U.S. Department of Housing and Urban Development, Entitlement Grants Cluster (CDBG), Community Development Block Grants/Entitlement Grants Federal Award Identification Number and Year - All grants listed on SEFA Pass-through Entity - Not applicable Finding Type - Material weakness Repeat Finding - No Criteria - Per 24 CFR section 570.603 - Grantees must adhere to the labor standards applicable to non-volunteer labor per 42 USC 53110 when rehabilitating residential property that contains no fewer than eight units, which includes ensuring prevailing wage rates are being used. Additionally, per 2 CFR section 200.303 - Grantees must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in Standards for Internal Control in the Federal Government issued by the Comptroller General of the United States or the Internal Control Integrated Framework, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition - The County did not have controls in place, during the year under audit, to ensure that the required certified payrolls were received and reviewed by the County. Questioned Costs - None Identification of How Questioned Costs Were Computed - Not applicable Context - The County has a process in place to receive and review weekly payroll certifications from contractors and subcontractors. However, there is not a control in place to ensure that all weekly payroll certifications have been received and reviewed. Cause and Effect - The County did not have controls in place ensure that the required certified payrolls were received and reviewed. For the sample selected for testing, the County was still in compliance with the applicable laws and regulations. Recommendation - We recommend that the County implement a control to ensure that the required certified payrolls from contractors and subcontractors are received and reviewed timely. Views of Responsible Officials and Corrective Action Plan - A process will be put into place to ensure certified payrolls are received and reviewed by two staff employees.
Assistance Listing, Federal Agency, and Program Name - ALN 14.218, U.S. Department of Housing and Urban Development, Entitlement Grants Cluster (CDBG), Community Development Block Grants/Entitlement Grants Federal Award Identification Number and Year - All grants listed on SEFA Pass-through Entity - Not applicable Finding Type - Material weakness Repeat Finding - No Criteria - Per 24 CFR section 570.603 - Grantees must adhere to the labor standards applicable to non-volunteer labor per 42 USC 53110 when rehabilitating residential property that contains no fewer than eight units, which includes ensuring prevailing wage rates are being used. Additionally, per 2 CFR section 200.303 - Grantees must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in Standards for Internal Control in the Federal Government issued by the Comptroller General of the United States or the Internal Control Integrated Framework, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition - The County did not have controls in place, during the year under audit, to ensure that the required certified payrolls were received and reviewed by the County. Questioned Costs - None Identification of How Questioned Costs Were Computed - Not applicable Context - The County has a process in place to receive and review weekly payroll certifications from contractors and subcontractors. However, there is not a control in place to ensure that all weekly payroll certifications have been received and reviewed. Cause and Effect - The County did not have controls in place ensure that the required certified payrolls were received and reviewed. For the sample selected for testing, the County was still in compliance with the applicable laws and regulations. Recommendation - We recommend that the County implement a control to ensure that the required certified payrolls from contractors and subcontractors are received and reviewed timely. Views of Responsible Officials and Corrective Action Plan - A process will be put into place to ensure certified payrolls are received and reviewed by two staff employees.
Assistance Listing, Federal Agency, and Program Name - ALN 14.218, U.S. Department of Housing and Urban Development, Entitlement Grants Cluster (CDBG), Community Development Block Grants/Entitlement Grants Federal Award Identification Number and Year - All grants listed on SEFA Pass-through Entity - Not applicable Finding Type - Material weakness Repeat Finding - No Criteria - Per 24 CFR section 570.603 - Grantees must adhere to the labor standards applicable to non-volunteer labor per 42 USC 53110 when rehabilitating residential property that contains no fewer than eight units, which includes ensuring prevailing wage rates are being used. Additionally, per 2 CFR section 200.303 - Grantees must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in Standards for Internal Control in the Federal Government issued by the Comptroller General of the United States or the Internal Control Integrated Framework, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition - The County did not have controls in place, during the year under audit, to ensure that the required certified payrolls were received and reviewed by the County. Questioned Costs - None Identification of How Questioned Costs Were Computed - Not applicable Context - The County has a process in place to receive and review weekly payroll certifications from contractors and subcontractors. However, there is not a control in place to ensure that all weekly payroll certifications have been received and reviewed. Cause and Effect - The County did not have controls in place ensure that the required certified payrolls were received and reviewed. For the sample selected for testing, the County was still in compliance with the applicable laws and regulations. Recommendation - We recommend that the County implement a control to ensure that the required certified payrolls from contractors and subcontractors are received and reviewed timely. Views of Responsible Officials and Corrective Action Plan - A process will be put into place to ensure certified payrolls are received and reviewed by two staff employees.
Assistance Listing, Federal Agency, and Program Name - ALN 14.218, U.S. Department of Housing and Urban Development, Entitlement Grants Cluster (CDBG), Community Development Block Grants/Entitlement Grants Federal Award Identification Number and Year - All grants listed on SEFA Pass-through Entity - Not applicable Finding Type - Material weakness Repeat Finding - No Criteria - Per 24 CFR section 570.603 - Grantees must adhere to the labor standards applicable to non-volunteer labor per 42 USC 53110 when rehabilitating residential property that contains no fewer than eight units, which includes ensuring prevailing wage rates are being used. Additionally, per 2 CFR section 200.303 - Grantees must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in Standards for Internal Control in the Federal Government issued by the Comptroller General of the United States or the Internal Control Integrated Framework, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition - The County did not have controls in place, during the year under audit, to ensure that the required certified payrolls were received and reviewed by the County. Questioned Costs - None Identification of How Questioned Costs Were Computed - Not applicable Context - The County has a process in place to receive and review weekly payroll certifications from contractors and subcontractors. However, there is not a control in place to ensure that all weekly payroll certifications have been received and reviewed. Cause and Effect - The County did not have controls in place ensure that the required certified payrolls were received and reviewed. For the sample selected for testing, the County was still in compliance with the applicable laws and regulations. Recommendation - We recommend that the County implement a control to ensure that the required certified payrolls from contractors and subcontractors are received and reviewed timely. Views of Responsible Officials and Corrective Action Plan - A process will be put into place to ensure certified payrolls are received and reviewed by two staff employees.
Assistance Listing, Federal Agency, and Program Name - ALN 14.218, U.S. Department of Housing and Urban Development, Entitlement Grants Cluster (CDBG), Community Development Block Grants/Entitlement Grants Federal Award Identification Number and Year - All grants listed on SEFA Pass-through Entity - Not applicable Finding Type - Material weakness Repeat Finding - No Criteria - Per 24 CFR section 570.603 - Grantees must adhere to the labor standards applicable to non-volunteer labor per 42 USC 53110 when rehabilitating residential property that contains no fewer than eight units, which includes ensuring prevailing wage rates are being used. Additionally, per 2 CFR section 200.303 - Grantees must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in Standards for Internal Control in the Federal Government issued by the Comptroller General of the United States or the Internal Control Integrated Framework, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition - The County did not have controls in place, during the year under audit, to ensure that the required certified payrolls were received and reviewed by the County. Questioned Costs - None Identification of How Questioned Costs Were Computed - Not applicable Context - The County has a process in place to receive and review weekly payroll certifications from contractors and subcontractors. However, there is not a control in place to ensure that all weekly payroll certifications have been received and reviewed. Cause and Effect - The County did not have controls in place ensure that the required certified payrolls were received and reviewed. For the sample selected for testing, the County was still in compliance with the applicable laws and regulations. Recommendation - We recommend that the County implement a control to ensure that the required certified payrolls from contractors and subcontractors are received and reviewed timely. Views of Responsible Officials and Corrective Action Plan - A process will be put into place to ensure certified payrolls are received and reviewed by two staff employees.
Assistance Listing, Federal Agency, and Program Name - ALN 14.218, U.S. Department of Housing and Urban Development, Entitlement Grants Cluster (CDBG), Community Development Block Grants/Entitlement Grants Federal Award Identification Number and Year - All grants listed on SEFA Pass-through Entity - Not applicable Finding Type - Material weakness Repeat Finding - No Criteria - Per 24 CFR section 570.603 - Grantees must adhere to the labor standards applicable to non-volunteer labor per 42 USC 53110 when rehabilitating residential property that contains no fewer than eight units, which includes ensuring prevailing wage rates are being used. Additionally, per 2 CFR section 200.303 - Grantees must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in Standards for Internal Control in the Federal Government issued by the Comptroller General of the United States or the Internal Control Integrated Framework, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition - The County did not have controls in place, during the year under audit, to ensure that the required certified payrolls were received and reviewed by the County. Questioned Costs - None Identification of How Questioned Costs Were Computed - Not applicable Context - The County has a process in place to receive and review weekly payroll certifications from contractors and subcontractors. However, there is not a control in place to ensure that all weekly payroll certifications have been received and reviewed. Cause and Effect - The County did not have controls in place ensure that the required certified payrolls were received and reviewed. For the sample selected for testing, the County was still in compliance with the applicable laws and regulations. Recommendation - We recommend that the County implement a control to ensure that the required certified payrolls from contractors and subcontractors are received and reviewed timely. Views of Responsible Officials and Corrective Action Plan - A process will be put into place to ensure certified payrolls are received and reviewed by two staff employees.
Assistance Listing, Federal Agency, and Program Name - ALN 14.218, U.S. Department of Housing and Urban Development, Entitlement Grants Cluster (CDBG), Community Development Block Grants/Entitlement Grants Federal Award Identification Number and Year - All grants listed on SEFA Pass-through Entity - Not applicable Finding Type - Material weakness Repeat Finding - No Criteria - Per 24 CFR section 570.603 - Grantees must adhere to the labor standards applicable to non-volunteer labor per 42 USC 53110 when rehabilitating residential property that contains no fewer than eight units, which includes ensuring prevailing wage rates are being used. Additionally, per 2 CFR section 200.303 - Grantees must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in Standards for Internal Control in the Federal Government issued by the Comptroller General of the United States or the Internal Control Integrated Framework, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition - The County did not have controls in place, during the year under audit, to ensure that the required certified payrolls were received and reviewed by the County. Questioned Costs - None Identification of How Questioned Costs Were Computed - Not applicable Context - The County has a process in place to receive and review weekly payroll certifications from contractors and subcontractors. However, there is not a control in place to ensure that all weekly payroll certifications have been received and reviewed. Cause and Effect - The County did not have controls in place ensure that the required certified payrolls were received and reviewed. For the sample selected for testing, the County was still in compliance with the applicable laws and regulations. Recommendation - We recommend that the County implement a control to ensure that the required certified payrolls from contractors and subcontractors are received and reviewed timely. Views of Responsible Officials and Corrective Action Plan - A process will be put into place to ensure certified payrolls are received and reviewed by two staff employees.
Finding 2023‐001: U.S. Department of the Treasury Federal Financial Assistance Listing 21.027 COVID‐19 Coronavirus State and Local Fiscal Recovery Funds Compliance Requirement: Reporting Type of Finding: Significant Deficiency in Internal Controls over Compliance Criteria: 2 CFR 200.303(a) establishes that the auditee must establish and maintain effective internal control over the federal award that provides assurance that the entity is managing the federal award in compliance with federal statutes, regulations, and conditions of the federal award. Condition: The County’s reports submitted to the Department of Treasury were not reviewed and approved by a separate individual outside of the preparer. Cause: The County did not have an internal control process in place to ensure a secondary review and approval of the reports submitted to the Department of Treasury were performed by someone other than the preparer of the report. Effect: Without a secondary review and approval, there is a possibility that the report may not be accurately completed. Questioned Costs: None. Context / Sampling: For the Coronavirus State and Local Fiscal Recovery Funds, one of one annual report was tested – sampling was not performed. Repeat Finding from Prior Year: No Recommendation: We recommend the County implement a control process which includes a secondary review and approval of the required reports to be submitted to the federal agency. Views of Responsible Officials: Management agrees with the noted finding. Refer to Corrective Action Plan.