Finding No. 2022-010 Federal Agency: U.S. Department of Education (ED) Assistance Listing No. and Title: 84.425 Education Stabilization Fund Area: Equipment and Real Property Management Questioned Costs: $854,432 Criteria: The Schedule of Expenditures of Federal Awards (SEFA) must be supported by underlying accounting and other records used in preparing the financial statements. § 2 CFR 200.313(b) provides that a state must use, manage and dispose of equipment acquired under a Federal award by the state in accordance with state laws and procedures. PSS Rules and Regulations § T60-20-815 Inventory Requirements Section (c)(1) provides that a fixed asset at its inception shall be assigned to one individual, who will be responsible for the care and maintenance of the specified fixed asset. The employee, who is in direct control of the fixed asset (not the supervisor of the employee), and who is using the fixed asset, shall sign for the fixed asset. Refusal to sign as the custodian of a fixed asset shall prohibit the employee from custody of the fixed asset. Condition: 1. As of September 30, 2022, the total amount of equipment acquired under ALN 84.425X per equipment schedule or subsidiary ledger was lower by $18,147 as compared to the total amount of equipment expenditures identified in the general ledger journal entry details supporting the SEFA. 2. For 10 (or 100%) of 10 equipment transactions tested, aggregating $854,432 of $2,296,719 in total amount of equipment costs identified as of September 30, 2022, no evidence of custodian signature at inception of the fixed asset was provided. However, printed copies of the property master information record from the JD Edwards system were signed and dated by the custodian and a verifier as evidence of the most recent physical inspection in September 2022. See Schedule of Findings and Questioned Costs for chart/table. Cause: PSS’ existing fixed asset management policies are insufficient to ensure proper management of equipment and real property. Effect: PSS is in noncompliance with applicable equipment and real property requirements. The reportable questioned cost is $854,432. Identification as a repeat finding: 2021-004 Recommendation: PSS should improve its existing fixed asset management policies to align with the Federal requirements on equipment and real property management. The Office of Procurement and Supply should consider developing standard forms and templates that can be used to document compliance with recordkeeping, custodianship, and physical count policies. Views of responsible officials: PSS agrees with the finding and describes corrective actions in the PSS Corrective Action Plan.
Finding No. 2022-011 Federal Agency: U.S. Department of Health and Human Services Assistance Listing No. and Title: 93.600 Head Start; 93.600 COVID-19 Head Start Area: Equipment and Real Property Management Questioned Costs: $165,367 Criteria: § 2 CFR 200.313(b) provides that a state must use, manage and dispose of equipment acquired under a Federal award by the state in accordance with state laws and procedures. PSS Rules and Regulations § T60-20-815 Inventory Requirements Section (c)(1) provides that a fixed asset at its inception shall be assigned to one individual, who will be responsible for the care and maintenance of the specified fixed asset. The employee, who is in direct control of the fixed asset (not the supervisor of the employee), and who is using the fixed asset, shall sign for the fixed asset. Refusal to sign as the custodian of a fixed asset shall prohibit the employee from custody of the fixed asset. The 2022 OMB Compliance Supplement page 4-93.600-9 provides that property records must be maintained for equipment acquired under a federal award that include a description of the property, a serial number or other identification number, the source of funding for the property (including the FAIN), who holds title, the acquisition date, and cost of the property, percentage of federal participation in the project costs for the federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sale price of the property. Condition: For 5 (or 100%) of 5 equipment transactions tested, aggregating $165,367 of $176,733 in total amount of equipment costs as of September 30, 2022, no evidence of custodian signature at inception of the fixed asset was provided. However, printed copies of the property master information record from the JD Edwards system were signed and dated by the custodian and a verifier as evidence of the most recent physical inspection in September 2022. See Schedule of Findings and Questioned Costs for chart/table. Cause: PSS’ existing fixed asset management policies are insufficient to ensure proper management of equipment and real property. Effect: PSS is in noncompliance with applicable equipment and real property requirements. The reportable questioned cost is $165,367. Recommendation: PSS should improve its existing fixed asset management policies to align with the Federal requirements on equipment and real property management. The Office of Procurement and Supply should consider developing standard forms and templates that can be used to document compliance with recordkeeping, custodianship, and physical count policies. Views of responsible officials: PSS agrees with the finding and describes corrective actions in the PSS Corrective Action Plan.
Finding No. 2022-011 Federal Agency: U.S. Department of Health and Human Services Assistance Listing No. and Title: 93.600 Head Start; 93.600 COVID-19 Head Start Area: Equipment and Real Property Management Questioned Costs: $165,367 Criteria: § 2 CFR 200.313(b) provides that a state must use, manage and dispose of equipment acquired under a Federal award by the state in accordance with state laws and procedures. PSS Rules and Regulations § T60-20-815 Inventory Requirements Section (c)(1) provides that a fixed asset at its inception shall be assigned to one individual, who will be responsible for the care and maintenance of the specified fixed asset. The employee, who is in direct control of the fixed asset (not the supervisor of the employee), and who is using the fixed asset, shall sign for the fixed asset. Refusal to sign as the custodian of a fixed asset shall prohibit the employee from custody of the fixed asset. The 2022 OMB Compliance Supplement page 4-93.600-9 provides that property records must be maintained for equipment acquired under a federal award that include a description of the property, a serial number or other identification number, the source of funding for the property (including the FAIN), who holds title, the acquisition date, and cost of the property, percentage of federal participation in the project costs for the federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sale price of the property. Condition: For 5 (or 100%) of 5 equipment transactions tested, aggregating $165,367 of $176,733 in total amount of equipment costs as of September 30, 2022, no evidence of custodian signature at inception of the fixed asset was provided. However, printed copies of the property master information record from the JD Edwards system were signed and dated by the custodian and a verifier as evidence of the most recent physical inspection in September 2022. See Schedule of Findings and Questioned Costs for chart/table. Cause: PSS’ existing fixed asset management policies are insufficient to ensure proper management of equipment and real property. Effect: PSS is in noncompliance with applicable equipment and real property requirements. The reportable questioned cost is $165,367. Recommendation: PSS should improve its existing fixed asset management policies to align with the Federal requirements on equipment and real property management. The Office of Procurement and Supply should consider developing standard forms and templates that can be used to document compliance with recordkeeping, custodianship, and physical count policies. Views of responsible officials: PSS agrees with the finding and describes corrective actions in the PSS Corrective Action Plan.
Finding No. 2022-011 Federal Agency: U.S. Department of Health and Human Services Assistance Listing No. and Title: 93.600 Head Start; 93.600 COVID-19 Head Start Area: Equipment and Real Property Management Questioned Costs: $165,367 Criteria: § 2 CFR 200.313(b) provides that a state must use, manage and dispose of equipment acquired under a Federal award by the state in accordance with state laws and procedures. PSS Rules and Regulations § T60-20-815 Inventory Requirements Section (c)(1) provides that a fixed asset at its inception shall be assigned to one individual, who will be responsible for the care and maintenance of the specified fixed asset. The employee, who is in direct control of the fixed asset (not the supervisor of the employee), and who is using the fixed asset, shall sign for the fixed asset. Refusal to sign as the custodian of a fixed asset shall prohibit the employee from custody of the fixed asset. The 2022 OMB Compliance Supplement page 4-93.600-9 provides that property records must be maintained for equipment acquired under a federal award that include a description of the property, a serial number or other identification number, the source of funding for the property (including the FAIN), who holds title, the acquisition date, and cost of the property, percentage of federal participation in the project costs for the federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sale price of the property. Condition: For 5 (or 100%) of 5 equipment transactions tested, aggregating $165,367 of $176,733 in total amount of equipment costs as of September 30, 2022, no evidence of custodian signature at inception of the fixed asset was provided. However, printed copies of the property master information record from the JD Edwards system were signed and dated by the custodian and a verifier as evidence of the most recent physical inspection in September 2022. See Schedule of Findings and Questioned Costs for chart/table. Cause: PSS’ existing fixed asset management policies are insufficient to ensure proper management of equipment and real property. Effect: PSS is in noncompliance with applicable equipment and real property requirements. The reportable questioned cost is $165,367. Recommendation: PSS should improve its existing fixed asset management policies to align with the Federal requirements on equipment and real property management. The Office of Procurement and Supply should consider developing standard forms and templates that can be used to document compliance with recordkeeping, custodianship, and physical count policies. Views of responsible officials: PSS agrees with the finding and describes corrective actions in the PSS Corrective Action Plan.
Finding No. 2022-003 Federal Agency: U.S Department of Transportation Assistance Listing Program: 20.106 Airport Improvement Program Federal Award No.: 3-68-0001-023-2020 Area: Equipment and Real Property Management Questioned Costs: $0 Criteria: In accordance with applicable equipment and real property management requirements, the Authority must comply with the following: •Under 2 CFR section 200.313(d)(1), property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the federal award identification number), who holds title, the acquisition date, cost of the property, percentage of federal participation in the project costs for the federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sales price of the property. •Under 2 CFR section 200.313(d)(2), a physical inventory of the property must be taken and the results reconciled with the property records at least once every two years. •Under 2 CFR section 200.313(d)(2), a control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of the property. Any loss, damage, or theft must be investigated. Conditions: 1.For 1 (or 100%) item tested, the Authority included description of the property, which is generic or limited (i.e., TO CAPITALISE THE NEW FIRE TRUCK) and related property records did not include serial number or identification number, federal award identification number, percentage of federal participation in the project costs for the federal award under which the property was acquired, and the location, use and condition of the property. 2.The Authority did not perform required physical inventory and reconciliation for all equipment and real properties acquired from Federal funds. 3.Furthermore, there is no control system to ensure adequate safeguards to prevent loss, damage, or theft of all equipment and real properties acquired from Federal funds. Cause: The Authority lacks internal control policies and procedures over compliance with applicable equipment and real property management requirements. Effect: The Authority is exposed to the risk of possible unauthorized use, misappropriation, and disposition of property without being noticed due to the lack of internal controls and proper supporting accounting records. No questioned costs are reported as we are unable to determine the quantitative impact to the program.
Finding 2022 – 009: Activities Allowed and Unallowed, Allowable Costs, Period of Performance (Compliance; Internal Controls Over Compliance) (Repeat Finding: 2018-006, 2019-008, 2020-008 and 2021-007) Significant Deficiency ALN 93.441 Indian Self Determination ALN 20.205 Highway Planning & Construction ALN 15.030 Indian Law Enforcement ALN 93.575 Child Care and Development Block Grant ALN 21.027 Coronavirus State and Local Fiscal Recovery Funds (ARPA) Criteria: Uniform Guidance 2 CFR, Part §200.313(a) requires that non-federal entities 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: During compliance requirement testing for Activities Allowed and Unallowed, Allowable Costs and Period of Performance for the above noted major programs, we selected 120 transactions for testing from each major program. The following number of transactions were not provided for our review during the audit: ALN 93.441 – Indian Self Determination – 47 transactions ALN 20.205 – Highway Planning and Construction - 11 transactions ALN 15.030 – Indian Law Enforcement – 8 transactions ALN 93.575 – Child Care and Development Block Grant – 22 transactions ALN 21.027 – Coronavirus State and Local Fiscal Recovery Funds – 9 transactions Questioned Costs: ALN 93.441 – Indian Self Determination – $18,572 ALN 20.205 – Highway Planning and Construction - $9,133 ALN 15.030 – Indian Law Enforcement – $9,844 ALN 93.575 – Child Care and Development Block Grant – $6,713 ALN 21.027 – Coronavirus State and Local Fiscal Recovery Funds – $6,497 Cause: The Governmental Department did not maintain sufficient appropriate documentation for audit review. Effect: The Governmental Department is not in compliance with Activities Allowed and Unallowed, Allowable Costs and Period of Performance compliance requirements for the 5 major programs mentioned above. This could lead to sanctions by the funding agencies. Recommendation: We recommend the Governmental Department becomes familiar with the requirements of 2 CFR, Part §200.313(a) and establish appropriate internal control policies and procedures to ensure compliance with the requirements of Uniform Guidance and each major program. In addition, all staff should be trained on those policies and procedures so they are familiar with the requirements. We further recommend the Governmental Department does not process payment for disbursements that does not contain sufficient, appropriate supporting documentation and necessary approvals. Views of Responsible Officials: See the corrective action plan that accompanies the schedule of findings and questioned costs.
Finding 2022 – 009: Activities Allowed and Unallowed, Allowable Costs, Period of Performance (Compliance; Internal Controls Over Compliance) (Repeat Finding: 2018-006, 2019-008, 2020-008 and 2021-007) Significant Deficiency ALN 93.441 Indian Self Determination ALN 20.205 Highway Planning & Construction ALN 15.030 Indian Law Enforcement ALN 93.575 Child Care and Development Block Grant ALN 21.027 Coronavirus State and Local Fiscal Recovery Funds (ARPA) Criteria: Uniform Guidance 2 CFR, Part §200.313(a) requires that non-federal entities 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: During compliance requirement testing for Activities Allowed and Unallowed, Allowable Costs and Period of Performance for the above noted major programs, we selected 120 transactions for testing from each major program. The following number of transactions were not provided for our review during the audit: ALN 93.441 – Indian Self Determination – 47 transactions ALN 20.205 – Highway Planning and Construction - 11 transactions ALN 15.030 – Indian Law Enforcement – 8 transactions ALN 93.575 – Child Care and Development Block Grant – 22 transactions ALN 21.027 – Coronavirus State and Local Fiscal Recovery Funds – 9 transactions Questioned Costs: ALN 93.441 – Indian Self Determination – $18,572 ALN 20.205 – Highway Planning and Construction - $9,133 ALN 15.030 – Indian Law Enforcement – $9,844 ALN 93.575 – Child Care and Development Block Grant – $6,713 ALN 21.027 – Coronavirus State and Local Fiscal Recovery Funds – $6,497 Cause: The Governmental Department did not maintain sufficient appropriate documentation for audit review. Effect: The Governmental Department is not in compliance with Activities Allowed and Unallowed, Allowable Costs and Period of Performance compliance requirements for the 5 major programs mentioned above. This could lead to sanctions by the funding agencies. Recommendation: We recommend the Governmental Department becomes familiar with the requirements of 2 CFR, Part §200.313(a) and establish appropriate internal control policies and procedures to ensure compliance with the requirements of Uniform Guidance and each major program. In addition, all staff should be trained on those policies and procedures so they are familiar with the requirements. We further recommend the Governmental Department does not process payment for disbursements that does not contain sufficient, appropriate supporting documentation and necessary approvals. Views of Responsible Officials: See the corrective action plan that accompanies the schedule of findings and questioned costs.
Finding 2022 – 009: Activities Allowed and Unallowed, Allowable Costs, Period of Performance (Compliance; Internal Controls Over Compliance) (Repeat Finding: 2018-006, 2019-008, 2020-008 and 2021-007) Significant Deficiency ALN 93.441 Indian Self Determination ALN 20.205 Highway Planning & Construction ALN 15.030 Indian Law Enforcement ALN 93.575 Child Care and Development Block Grant ALN 21.027 Coronavirus State and Local Fiscal Recovery Funds (ARPA) Criteria: Uniform Guidance 2 CFR, Part §200.313(a) requires that non-federal entities 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: During compliance requirement testing for Activities Allowed and Unallowed, Allowable Costs and Period of Performance for the above noted major programs, we selected 120 transactions for testing from each major program. The following number of transactions were not provided for our review during the audit: ALN 93.441 – Indian Self Determination – 47 transactions ALN 20.205 – Highway Planning and Construction - 11 transactions ALN 15.030 – Indian Law Enforcement – 8 transactions ALN 93.575 – Child Care and Development Block Grant – 22 transactions ALN 21.027 – Coronavirus State and Local Fiscal Recovery Funds – 9 transactions Questioned Costs: ALN 93.441 – Indian Self Determination – $18,572 ALN 20.205 – Highway Planning and Construction - $9,133 ALN 15.030 – Indian Law Enforcement – $9,844 ALN 93.575 – Child Care and Development Block Grant – $6,713 ALN 21.027 – Coronavirus State and Local Fiscal Recovery Funds – $6,497 Cause: The Governmental Department did not maintain sufficient appropriate documentation for audit review. Effect: The Governmental Department is not in compliance with Activities Allowed and Unallowed, Allowable Costs and Period of Performance compliance requirements for the 5 major programs mentioned above. This could lead to sanctions by the funding agencies. Recommendation: We recommend the Governmental Department becomes familiar with the requirements of 2 CFR, Part §200.313(a) and establish appropriate internal control policies and procedures to ensure compliance with the requirements of Uniform Guidance and each major program. In addition, all staff should be trained on those policies and procedures so they are familiar with the requirements. We further recommend the Governmental Department does not process payment for disbursements that does not contain sufficient, appropriate supporting documentation and necessary approvals. Views of Responsible Officials: See the corrective action plan that accompanies the schedule of findings and questioned costs.
Finding 2022 – 009: Activities Allowed and Unallowed, Allowable Costs, Period of Performance (Compliance; Internal Controls Over Compliance) (Repeat Finding: 2018-006, 2019-008, 2020-008 and 2021-007) Significant Deficiency ALN 93.441 Indian Self Determination ALN 20.205 Highway Planning & Construction ALN 15.030 Indian Law Enforcement ALN 93.575 Child Care and Development Block Grant ALN 21.027 Coronavirus State and Local Fiscal Recovery Funds (ARPA) Criteria: Uniform Guidance 2 CFR, Part §200.313(a) requires that non-federal entities 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: During compliance requirement testing for Activities Allowed and Unallowed, Allowable Costs and Period of Performance for the above noted major programs, we selected 120 transactions for testing from each major program. The following number of transactions were not provided for our review during the audit: ALN 93.441 – Indian Self Determination – 47 transactions ALN 20.205 – Highway Planning and Construction - 11 transactions ALN 15.030 – Indian Law Enforcement – 8 transactions ALN 93.575 – Child Care and Development Block Grant – 22 transactions ALN 21.027 – Coronavirus State and Local Fiscal Recovery Funds – 9 transactions Questioned Costs: ALN 93.441 – Indian Self Determination – $18,572 ALN 20.205 – Highway Planning and Construction - $9,133 ALN 15.030 – Indian Law Enforcement – $9,844 ALN 93.575 – Child Care and Development Block Grant – $6,713 ALN 21.027 – Coronavirus State and Local Fiscal Recovery Funds – $6,497 Cause: The Governmental Department did not maintain sufficient appropriate documentation for audit review. Effect: The Governmental Department is not in compliance with Activities Allowed and Unallowed, Allowable Costs and Period of Performance compliance requirements for the 5 major programs mentioned above. This could lead to sanctions by the funding agencies. Recommendation: We recommend the Governmental Department becomes familiar with the requirements of 2 CFR, Part §200.313(a) and establish appropriate internal control policies and procedures to ensure compliance with the requirements of Uniform Guidance and each major program. In addition, all staff should be trained on those policies and procedures so they are familiar with the requirements. We further recommend the Governmental Department does not process payment for disbursements that does not contain sufficient, appropriate supporting documentation and necessary approvals. Views of Responsible Officials: See the corrective action plan that accompanies the schedule of findings and questioned costs.
Finding 2022 – 009: Activities Allowed and Unallowed, Allowable Costs, Period of Performance (Compliance; Internal Controls Over Compliance) (Repeat Finding: 2018-006, 2019-008, 2020-008 and 2021-007) Significant Deficiency ALN 93.441 Indian Self Determination ALN 20.205 Highway Planning & Construction ALN 15.030 Indian Law Enforcement ALN 93.575 Child Care and Development Block Grant ALN 21.027 Coronavirus State and Local Fiscal Recovery Funds (ARPA) Criteria: Uniform Guidance 2 CFR, Part §200.313(a) requires that non-federal entities 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: During compliance requirement testing for Activities Allowed and Unallowed, Allowable Costs and Period of Performance for the above noted major programs, we selected 120 transactions for testing from each major program. The following number of transactions were not provided for our review during the audit: ALN 93.441 – Indian Self Determination – 47 transactions ALN 20.205 – Highway Planning and Construction - 11 transactions ALN 15.030 – Indian Law Enforcement – 8 transactions ALN 93.575 – Child Care and Development Block Grant – 22 transactions ALN 21.027 – Coronavirus State and Local Fiscal Recovery Funds – 9 transactions Questioned Costs: ALN 93.441 – Indian Self Determination – $18,572 ALN 20.205 – Highway Planning and Construction - $9,133 ALN 15.030 – Indian Law Enforcement – $9,844 ALN 93.575 – Child Care and Development Block Grant – $6,713 ALN 21.027 – Coronavirus State and Local Fiscal Recovery Funds – $6,497 Cause: The Governmental Department did not maintain sufficient appropriate documentation for audit review. Effect: The Governmental Department is not in compliance with Activities Allowed and Unallowed, Allowable Costs and Period of Performance compliance requirements for the 5 major programs mentioned above. This could lead to sanctions by the funding agencies. Recommendation: We recommend the Governmental Department becomes familiar with the requirements of 2 CFR, Part §200.313(a) and establish appropriate internal control policies and procedures to ensure compliance with the requirements of Uniform Guidance and each major program. In addition, all staff should be trained on those policies and procedures so they are familiar with the requirements. We further recommend the Governmental Department does not process payment for disbursements that does not contain sufficient, appropriate supporting documentation and necessary approvals. Views of Responsible Officials: See the corrective action plan that accompanies the schedule of findings and questioned costs.
Finding 2022 – 009: Activities Allowed and Unallowed, Allowable Costs, Period of Performance (Compliance; Internal Controls Over Compliance) (Repeat Finding: 2018-006, 2019-008, 2020-008 and 2021-007) Significant Deficiency ALN 93.441 Indian Self Determination ALN 20.205 Highway Planning & Construction ALN 15.030 Indian Law Enforcement ALN 93.575 Child Care and Development Block Grant ALN 21.027 Coronavirus State and Local Fiscal Recovery Funds (ARPA) Criteria: Uniform Guidance 2 CFR, Part §200.313(a) requires that non-federal entities 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: During compliance requirement testing for Activities Allowed and Unallowed, Allowable Costs and Period of Performance for the above noted major programs, we selected 120 transactions for testing from each major program. The following number of transactions were not provided for our review during the audit: ALN 93.441 – Indian Self Determination – 47 transactions ALN 20.205 – Highway Planning and Construction - 11 transactions ALN 15.030 – Indian Law Enforcement – 8 transactions ALN 93.575 – Child Care and Development Block Grant – 22 transactions ALN 21.027 – Coronavirus State and Local Fiscal Recovery Funds – 9 transactions Questioned Costs: ALN 93.441 – Indian Self Determination – $18,572 ALN 20.205 – Highway Planning and Construction - $9,133 ALN 15.030 – Indian Law Enforcement – $9,844 ALN 93.575 – Child Care and Development Block Grant – $6,713 ALN 21.027 – Coronavirus State and Local Fiscal Recovery Funds – $6,497 Cause: The Governmental Department did not maintain sufficient appropriate documentation for audit review. Effect: The Governmental Department is not in compliance with Activities Allowed and Unallowed, Allowable Costs and Period of Performance compliance requirements for the 5 major programs mentioned above. This could lead to sanctions by the funding agencies. Recommendation: We recommend the Governmental Department becomes familiar with the requirements of 2 CFR, Part §200.313(a) and establish appropriate internal control policies and procedures to ensure compliance with the requirements of Uniform Guidance and each major program. In addition, all staff should be trained on those policies and procedures so they are familiar with the requirements. We further recommend the Governmental Department does not process payment for disbursements that does not contain sufficient, appropriate supporting documentation and necessary approvals. Views of Responsible Officials: See the corrective action plan that accompanies the schedule of findings and questioned costs.
Finding Number: 2022-031 Prior Year Finding Number: 2021-026 Compliance Requirement: Equipment and Real Property Management Program: U.S. Department of the Interior Economic, Social, and Political Development of the Territories ALN: 15.875 Award #: Various Award Year: Various Government Department/Agency: Various Criteria – Per 2 CFR section 200.313, Equipment, property records must be maintained that include a description of the property, a serial number or other identification number, the source of property, who holds title, the acquisition date, cost of the property, percentage of Federal participation in the cost of the property, the location, use and conditions of the property, and any ultimate disposition data including the date of disposal and sale price of the property. Further, a physical inventory of equipment should be taken at least once every 2 years and reconciled to the equipment records along with the usage of an appropriate control system to safeguard and maintain equipment. Additionally, the Uniform Guidance in 2 CFR Section 200.303, Internal Controls, requires that non-federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to ensure compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. Condition – The Government’s Department of Property and Procurement (DPP) maintains the equipment register for the Government. DPP was unable to provide an accurate and complete property records which met the stated requirements. Further, no physical inventory was taken in fiscal year 2022. Further, we noted that internal controls were not operating at a level of precision to ensure compliance with the equipment management compliance requirements. Questioned Costs – None. Context – This is a condition identified per review of the Government’s compliance with the specified requirements. Equipment purchased in 2022 totaled $3,007,762. Effect – There is a risk that inadequate recordkeeping of equipment could lead to misappropriation of assets and noncompliance with Federal regulations resulting in a return of Federal awards received. Cause – The Government does not appear to have a process in place to adequately monitor equipment acquired with Federal funds. Recommendation – We recommend that DPP improve internal controls to ensure adherence to Federal regulations related to equipment and its related maintenance. There should be timely coordination and communication amongst all Government departments and/or agencies that are responsible for handling and managing such assets. Views of Responsible Officials – The Government concurs with the auditor’s findings and recommendations. The Asset Management Division (AMD) adheres to Federal equipment guidelines. Assets are tagged, and records are created using the Tyler Munis Resource Planning system (ERP). In 2022, AMD inventoried four agencies, ensuring compliance with Federal regulations. The completed Standard Operation Policies and Procedures (SOPP) are pending approval, crucial for enhancing internal controls. Training sessions for fixed assets employees are planned, and additional staff will be needed to support the initiative effectively. The planned corrective actions are presented in the Government’s Corrective Action Plan attached as Appendix B to the Single Audit Report.
Finding Number: 2022-046 Prior Year Finding Number: 2021-041 Compliance Requirement: Equipment and Real Property Management Program: U.S. Department of Education Special Education Cluster ALN: 84.027 (84.027A and 84.027X) Award #: Various Award Period: Various Government Department/Agency: Department of Education (VIDE) Criteria – Per the Uniform Guidance in 2 CFR Section 200.313, Equipment, property records must be maintained that include a description of the property, a serial number or other identification number, the source of the property, who holds title, the acquisition date, cost of the property, percentage of Federal participation in the cost of the property, the location, use and conditions of the property, and any ultimate disposition date including the date of disposal and sale price of the property. Additionally, the Uniform Guidance in 2 CFR Section 200.303, Internal Controls, requires that non-federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to ensure compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. Condition – The VIDE maintains an equipment listing for fixed assets purchased with federal funding. VIDE was unable to provide complete property records which met the stated requirements. Further, we noted that internal controls were not operating at a level of precision to ensure compliance with the equipment management compliance requirements. Question Costs – None. Context – This is a condition identified per review of the VIDE’s compliance with the specified requirements. Effect – There is a risk that inadequate recordkeeping or equipment could lead to misappropriation of assets and noncompliance with Federal regulations resulting in a return of Federal awards received. Cause – VIDE does not appear to have adequate policies and procedures in place to adequately monitor equipment acquired with Federal Funds. Recommendation – We recommend that VIDE improve internal controls to ensure adherence to Federal regulations related to equipment and its related maintenance. There should be timely coordination and communication amongst all personnel that are responsible for handling and managing such assets as well as monitoring of the performance of the recording of the equipment. Views of Responsible Officials - The Government concurs with the auditor’s findings and recommendations. VIDE will enhance their asset tracking system, maintaining centralized records with detailed asset information, including description, serial number, acquisition details, and federal participation. The Procurement Division will conduct quarterly inventory audits and reconciliations to ensure alignment with actual inventory, promptly resolving discrepancies. The Fixed Asset Director will establish protocols for regular communication among Programs/Divisions responsible for asset management, requiring monthly status reports to ensure data accuracy and timely updates. The planned corrective actions are presented in the Government’s Corrective Action Plan attached as Appendix B to the Single Audit Report.
Finding Number 2022-049 Prior Year Finding Number: 2021-044 Compliance Requirement: Equipment and Real Property Management Program: U.S. Department of Education Consolidated Grant to the Outlying Areas ALN: 84.403A Award #: Various Award Period: Various Government Department/Agency: Department of Education (VIDE) Criteria – Per the Uniform Guidance in 2 CFR Section 200.313, Equipment, property records must be maintained that include a description of the property, a serial number or other identification number, the source of the property, who holds title, the acquisition date, cost of the property, percentage of Federal participation in the cost of the property, the location, use and conditions of the property, and any ultimate disposition date including the date of disposal and sale price of the property. Further, the Uniform Guidance in 2 CFR Section 200.303, Internal Controls, requires that non-federal entities receiving Federal awards (ie. auditee management) establish and maintain internal control designed to ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Condition – The VIDE maintains an equipment listing for fixed assets purchased with federal funding. VIDE was unable to provide complete property records which met the stated requirements. Further, it does not appear that the controls in place are operating at a level of precision to ensure compliance with the equipment management compliance requirements. Question Costs – Not determinable. Context – This is a condition identified per review of the VIDE’s compliance with the specified requirements. Effect – There is a risk that inadequate recordkeeping or equipment could lead to misappropriation of assets and noncompliance with Federal regulations resulting in a return of Federal awards received. Cause – VIDE does not appear to have adequate policies and procedures in place to adequately monitor equipment acquired with Federal Funds. Recommendation – We recommend that VIDE improve internal controls to ensure adherence to Federal regulations related to equipment and its related maintenance. There should be timely coordination and communication amongst all personnel that are responsible for handling and managing such assets as well as monitoring of the performance of the recording of the equipment. Views of Responsible Officials - The Government concurs with the auditor’s findings and recommendations. VIDE plans to improve management and documentation of federally funded equipment by enhancing its asset tracking system and maintaining centralized records with detailed asset information. The Procurement Division will conduct quarterly inventory audits to reconcile records with actual inventory, resolving discrepancies promptly. The Fixed Asset Director will establish communication protocols among Programs/Divisions, requiring monthly status reports to ensure data accuracy and timely updates. The planned corrective actions are presented in the Government’s Corrective Action Plan attached as Appendix B to the Single Audit Report.
Finding Number: 2022-057 Prior Year Finding Number: N/A Compliance Requirement: Equipment and Real Property Management Program: U.S. Department of Health and Human Services Epidemiology and Laboratory Capacity for Infectious Disease ALN: 93.323 Award #: NU50CK000507 Award Year: 08/01/19 – 07/31/24 Government Department/Agency: Department of Health (DOH) Criteria – Per 2 CFR Section 200.313, property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property, who holds title, the acquisition date, cost of the property, percentage of Federal participation in the project costs for the Federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sales price of the property. Further, a physical inventory of equipment should be taken at least once every two years and reconciled to the equipment records along with the usage of an appropriate control system to safeguard and maintain equipment. Additionally, the Uniform Guidance in 2 CFR Section 200.303, Internal Controls, requires that non-federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to ensure compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. Condition – The Government’s Department of Property and Procurement (DPP) maintains the equipment register for the Government. DPP was unable to provide an accurate and complete property records which met the stated requirements. Further, no physical inventory was taken in fiscal year 2022. Further, we noted that internal controls were not operating at a level of precision to ensure compliance with the equipment management compliance requirements. Questioned Costs – Not determinable. Context – This is a condition identified per review of DOH’s compliance with the specified requirements. Cause – DOH does not appear to have a process in place to adequately monitor property and equipment acquired with Federal funds. Effect –There is a risk that inadequate recordkeeping lead to misappropriation of assets and noncompliance with Federal regulations resulting in loss of funding. Recommendation – We recommend that DOH and DPP improve internal to ensure adherence to federal regulations related to equipment and its related maintenance. There should be timely coordination and communication amongst all Government departments responsible for handling managing such assets. Views of Responsible Official - The Government concurs with the auditor’s findings and recommendations. The Epidemiology Division has implemented strong procedures for managing and monitoring property and equipment in line with Property and Procurement guidelines, including meticulous inventory and employee acknowledgment of assigned items. However, DOH acknowledges the need for better coordination with Property and Procurement. To improve asset management, DOH will update the Fixed Asset SOP to mandate that each division shares its asset inventory with Property and Procurement quarterly, ensuring more accurate and current records. The planned corrective actions are presented in the Government’s Corrective Action Plan attached as Appendix B to the Single Audit Report.
Finding No.: 2022-010 Pass-Through Entity: Republic of the Marshall Islands Federal Agency: U.S. Department of the Interior AL Program: 15.875 Economic, Social and Political Development of the Territories Federal Award No.: Compact of Free Association Program, As Amended Area: Equipment and Real Property Management Questioned Costs: $ Undeterminable Criteria: Non-federal entities other than states must follow Sections 200.313(c) through (e) of the Uniform Guidance. Section 200.313(d) states that procedures for managing equipment, whether acquired in whole or in part under a Federal award, until disposition takes place will, as a minimum, meet the following requirements: a. Property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the FAIN), who holds title, the acquisition date, and cost of the property, percentage of Federal participation in the project costs for the Federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sale price of the property; b. A physical inventory of the property must be carried out and the results reconciled with the property records at least once every two years; c. A control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of the property. Any loss, damage, or theft must be investigated; d. Adequate maintenance procedures must be developed to keep the property in good condition; and e. If the non-Federal entity is authorized or required to sell the property, proper sales procedures must be established to ensure the highest possible return. Furthermore, 2 CFR 200.303(a) states that the subrecipient must establish, document, and maintain effective internal control over the Federal award that provides reasonable assurance that the subrecipient is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should align with the 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 COSO. Condition: Capital assets records do not meet the criteria above and are not effectively maintained since updates to the records occur only once a year. Specifically, we noted the following deficiencies: 1. Certain information in the capital assets records are either incomplete or missing, such as the source of funding for the property (including the FAIN), who holds title, percentage of Federal participation in the project costs for the Federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sale price of the property). 2. An inventory of capital assets has been performed on an annual basis; however, the result of the physical inventory was not completely reflected/reconciled with the property records. 3. As capital assets records are not effectively maintained, it does not appear that the College has effectively developed means to adequately safeguard capital assets from loss, damage, or theft, or to reasonably investigate such occurrences. 4. Long-lived assets are not routinely evaluated for possible impairment. Cause: The College lacks adequate internal control policies and procedures over compliance with the applicable federal property rules and regulations and lacks effective procedures governing property maintenance, as well as periodic assessment of asset impairment conditions. Moreover, internal control policies and procedures requiring periodic and timely performance and independent review of capital assets reconciliations and related general ledger accounts are not effectively implemented. Effect: The College is not in compliance with the applicable equipment and real property management requirements. Questioned costs, if any, that may result from inadequate property records, maintenance procedures, and the absence of timely reconciliations are not determinable. Capital outlays within the program for fiscal years are summarized as follows: Fiscal Year Capital Outlays 2022 $131,200 2021 $207,400 2020 $248,700 2019 $249,400 2018 $359,000 Identified as a Repeat Finding: 2021-007 Recommendation: College management should establish and strengthen internal control policies and procedures over compliance with the applicable federal regulations on equipment and real property management. Views of Auditee and Planned Corrective Actions: The College agrees with the finding and provides details in its Corrective Action Plan.
Finding No. 2022-015 Federal Agency: U.S. Department of the Interior AL Program: 15.875 Economic, Social, and Political Development of the Territories Federal Award Nos.: D19AP00130, D20AP00037, D20AP00040, D20AP00126, D20AP00119, D21AP10003, D19AP00142, D20AP00135, D20AP00162, D18AP00130, D19AP00109, D21AP10218, D20AP00005, D21AX10059, D21AP10140 Area: Equipment and Real Property Management Questioned Costs: Unknown Criteria: In accordance with 2 CFR Section 200.313(b), a state must use, manage, and dispose of equipment acquired under a federal award in accordance with state laws and procedures. The CNMI Property Management Policies and Procedures requires the Division of Procurement & Supply (PS) to conduct an annual inventory of property held by a designated official who has administrative control over the use of personal property within his area of jurisdiction. Also, PS shall perform random audits of property held by each accountable person to validate the integrity of the property control process. Further, in accordance with 2 CFR Section 200.313(d)(1), property records must be maintained that include a description of the property, a serial number or another identification number, the source of funding for the property (including the Federal award identification number), the title holder, the acquisition date, the cost of the property, the percentage of the Federal agency contribution towards the original purchase, the location, use and condition of the property, and any disposition data including the date of disposal and sale price of the property. Condition: The capital assets listing provided, comprised of various federal capital assets, for which the CNMI was not able to identify which capital assets were procured from what federal funding. In addition, the CNMI did not provide the program’s schedule of additions and disposals during the fiscal year. Total FY2022 federal capital assets charged to the program amounted to $1,068,187. No questioned costs are presented as we are not able to quantify the extent of noncompliance. Cause: 1. The CNMI did not provide sufficient and appropriate audit evidence to assist the auditors during the testing procedures for the equipment and real property management compliance requirement. 2. The CNMI lacks human resources and financial management system structure needed to effect compliance with applicable equipment and real property management requirements. Effect: The CNMI is in noncompliance with applicable equipment and real property management requirements. Questioned costs are unknown as the CNMI could not provide the program’s capital assets listing. See below for the cumulative dollar amount of property equipment acquired with program grant funds over the past five years. Identification as a Repeat Finding: Finding No. 2021-018 Recommendation: 1. CNMI should adhere to the requirement of 2 CFR Section 200.313(d)(1); 2. Responsible personnel should establish and implement effective monitoring controls to ensure property records are accurately segregated by federal funding source; and 3. The CNMI should consider seeking technical and financial support from Federal agencies to develop human resources and a financial management system capable of effecting compliance with applicable property management policies and procedures. Views of Responsible Officials: The Procurement Services Division agrees with this finding. The CNMI has recently implemented the MUNIS Financial Management System to improve recordkeeping and compliance processes. All equipment and real property records acquired with federal funds will now be entered, tracked, and maintained within MUNIS. Supporting documentation will also be filed in accordance with standardized retention procedures to ensure that accurate and sufficient audit evidence is readily available. Refer to CNMI’s Corrective Action Plan for additional information.
2 CFR § 3474.1 gives regulatory effect to the Department of Education for 2 CFR § 200.313(c) through (d) which require that: (c) Equipment must be used in the program or project for which it was acquired as long as needed, whether or not the project or program continues to be supported by the Federal award or, when appropriate, under other Federal awards; however, the non-Federal entity must not encumber the equipment without prior approval of the Federal awarding agency. (d) Procedures for managing equipment (including replacement equipment), whether acquired in whole or in part under a Federal award, until disposition takes place will, as a minimum, meet the following requirements: 1. Property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the Federal award identification number), who holds title, the acquisition date, cost of the property, percentage of Federal participation in the project costs for the Federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sales price of the property. 2. A physical inventory of the property must be taken and the results reconciled with the property records at least once every 2 years. 3. A control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of the property. Any loss, damage, or theft must be investigated. 4. Adequate maintenance procedures must be developed to keep the property in good condition. 5. If the non-Federal entity is authorized or required to sell the property, proper sales procedures must be established to ensure the highest possible return. The School District failed to properly track assets purchased or improvements completed with ESF (specifically Elementary and Secondary School Emergency Relief (ESSER)) funds in their Equipment Inventory System. In addition, support was not provided that the required physical inventory of equipment was being performed. The School District Treasurer should review the Equipment Inventory System and adjust it to include all assets purchased with ESSER Funds. The School District should establish procedures to ensure the required physical inventories are being performed and reconciled with the Equipment Inventory System at least every two years.
2 CFR § 3474.1 gives regulatory effect to the Department of Education for 2 CFR § 200.313(c) through (d) which require that: (c) Equipment must be used in the program or project for which it was acquired as long as needed, whether or not the project or program continues to be supported by the Federal award or, when appropriate, under other Federal awards; however, the non-Federal entity must not encumber the equipment without prior approval of the Federal awarding agency. (d) Procedures for managing equipment (including replacement equipment), whether acquired in whole or in part under a Federal award, until disposition takes place will, as a minimum, meet the following requirements: 1. Property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the Federal award identification number), who holds title, the acquisition date, cost of the property, percentage of Federal participation in the project costs for the Federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sales price of the property. 2. A physical inventory of the property must be taken and the results reconciled with the property records at least once every 2 years. 3. A control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of the property. Any loss, damage, or theft must be investigated. 4. Adequate maintenance procedures must be developed to keep the property in good condition. 5. If the non-Federal entity is authorized or required to sell the property, proper sales procedures must be established to ensure the highest possible return. The School District failed to properly track assets purchased or improvements completed with ESF (specifically Elementary and Secondary School Emergency Relief (ESSER)) funds in their Equipment Inventory System. In addition, support was not provided that the required physical inventory of equipment was being performed. The School District Treasurer should review the Equipment Inventory System and adjust it to include all assets purchased with ESSER Funds. The School District should establish procedures to ensure the required physical inventories are being performed and reconciled with the Equipment Inventory System at least every two years.
FA 2022-001 Strengthen Controls over Equipment Compliance Requirement: Equipment and Real Property Management Internal Control Impact: Significant Deficiency Compliance Impact: Nonmaterial Noncompliance Federal Awarding Agency: U.S. Department of Education Pass-Through Entity: Georgia Department of Education AL Numbers and Titles: COVID-19 84.425D – Elementary and Secondary School Emergency Relief Fund COVID-19 84.425U – American Rescue Plan Elementary and Secondary School Emergency Relief Fund Federal Award Numbers: S425D210012 (Year: 2021), S425U210012 (Year: 2021) Questioned Costs: None Identified Description: The policies and procedures of the School District were insufficient to provide adequate internal controls over equipment and real property management as it relates to the Elementary and Secondary School Emergency Relief Fund program. Background Information: On March 27, 2020, the Coronavirus Aid, Relief, and Economic Security (CARES) Act was signed into law. The CARES Act was designed to mitigate the economic effects of the COVID-19 pandemic in a variety of ways, including providing additional funding for local educational agencies (LEAs) navigating the impact of the COVID-19 outbreak. Provisions included in Title VIII of the CARES Act created the Education Stabilization Fund to provide financial resources to educational entities to prevent, prepare for, and respond to coronavirus. The CARES Act allocated $30.75 billion, the Coronavirus Response and Relief Supplemental Appropriations Act allocated an additional $81.9 billion, and the American Rescue Plan Act added $165.1 billion in funding to the Education Stabilization Fund. Multiple Education Stabilization Fund subprograms were created and allotted funding through the various COVID-19-related legislation. Of these programs, the Elementary and Secondary School Emergency Relief (ESSER) Fund was created to address the impact that COVID-19 has had, and continues to have, on elementary and secondary schools across the nation. ESSER funding was granted to the Georgia Department of Education (GaDOE) by the U.S. Department of Education (ED). GaDOE was responsible for distributing funds to LEAs and overseeing the expenditure of funds by LEAs. ESSER funds totaling $6,979,815.88 were expended and reported on the Ben Hill County Board of Education’s Schedule of Expenditures of Federal Awards (SEFA) for fiscal year 2021. Criteria: As a recipient of federal awards, the School District is required to establish and maintain effective internal control over federal awards that provides reasonable assurance of managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards pursuant to Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance), Section 200.303 – Internal Controls. Provisions included in the Uniform Guidance, Section 200.313(d)(1) state, “Property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the FAIN), who holds title, the acquisition date, and cost of the property, percentage of Federal participation in the project costs for the Federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sale price of the property.” Furthermore, to assist school districts in improving their financial management systems and associated compliance over federal programs, GaDOE published the Financial Management for Georgia Local Units of Administration (FMGLUA) manual. The FMGLUA manual requires that LEAs submit a budget as part of each federal program’s Consolidated Application process. The program budget reflects details regarding the manner in which each school district intends to expend the program funds. The Consolidated Application, including the budget, for each program must be reviewed and approved by GaDOE personnel before the LEA is authorized to expend program funds. Amendments to the budget are to be submitted to and approved by GaDOE when a school district intends to spend funds in a manner not initially reported. Lastly, LEA personnel must also provide program-specific assurances related to the ESSER programs within the Consolidated Application system. These assurances are reflected in the Uniform Guidance, Section 200.415 – Required Certifications, and include provisions that require LEAs “to assure that expenditures are proper and in accordance with the terms and conditions of the Federal award and approved project budgets...” Condition: The following deficiencies were noted when reviewing the ESSER program: • 12 pieces of equipment with costs totaling $347,619.04, which were purchased with program funds, were not included on the federal program’s equipment listing. • The related expenditures for seven equipment additions with costs totaling $156,067.46 were not appropriately approved by GaDOE through the Consolidated Application process. Further, the expenditures were not submitted for approval on an amended budget as of the end of audit fieldwork. Cause: Issues were a result of inadequate controls and review procedures over equipment. Effect: The School District is not in compliance with the Uniform Guidance and GaDOE guidance. Failure to maintain a complete and accurate equipment listing and reconcile results of the physical inventory performed to the property records exposes the School District to unnecessary risk of error and misuse of equipment and/or federal funds. Additionally, failure to verify compliance with applicable policies and regulations, including reviewing approved budgets prior to the expenditure of federal program funds may expose the School District to unnecessary financial strains and shortages. Recommendation: The School District should develop and maintain an equipment listing that reflects all required information, including a description, an identifying number, the source of funding, the title holder, the acquisition date, the cost, the percentage of federal participation in the project costs, the location, the use and condition, and any ultimate disposal data for each piece of equipment. Management should also implement controls to ensure that a complete physical inventory of equipment is performed, and the results are reconciled back to the equipment listing at least once every two years. In addition, the School District should also revise current internal control procedures related to the ESSER program. Where vulnerable, the School District should develop and/or modify its policies and procedures to ensure that potential expenditures are approved through the Consolidated Application process and deemed to be allowable before spending federal funds. Management should also develop and implement a monitoring process to ensure that control procedures are being followed. Views of Responsible Officials: We concur with this finding.
FA 2022-001 Strengthen Controls over Equipment Compliance Requirement: Equipment and Real Property Management Internal Control Impact: Significant Deficiency Compliance Impact: Nonmaterial Noncompliance Federal Awarding Agency: U.S. Department of Education Pass-Through Entity: Georgia Department of Education AL Numbers and Titles: COVID-19 84.425D – Elementary and Secondary School Emergency Relief Fund COVID-19 84.425U – American Rescue Plan Elementary and Secondary School Emergency Relief Fund Federal Award Numbers: S425D210012 (Year: 2021), S425U210012 (Year: 2021) Questioned Costs: None Identified Description: The policies and procedures of the School District were insufficient to provide adequate internal controls over equipment and real property management as it relates to the Elementary and Secondary School Emergency Relief Fund program. Background Information: On March 27, 2020, the Coronavirus Aid, Relief, and Economic Security (CARES) Act was signed into law. The CARES Act was designed to mitigate the economic effects of the COVID-19 pandemic in a variety of ways, including providing additional funding for local educational agencies (LEAs) navigating the impact of the COVID-19 outbreak. Provisions included in Title VIII of the CARES Act created the Education Stabilization Fund to provide financial resources to educational entities to prevent, prepare for, and respond to coronavirus. The CARES Act allocated $30.75 billion, the Coronavirus Response and Relief Supplemental Appropriations Act allocated an additional $81.9 billion, and the American Rescue Plan Act added $165.1 billion in funding to the Education Stabilization Fund. Multiple Education Stabilization Fund subprograms were created and allotted funding through the various COVID-19-related legislation. Of these programs, the Elementary and Secondary School Emergency Relief (ESSER) Fund was created to address the impact that COVID-19 has had, and continues to have, on elementary and secondary schools across the nation. ESSER funding was granted to the Georgia Department of Education (GaDOE) by the U.S. Department of Education (ED). GaDOE was responsible for distributing funds to LEAs and overseeing the expenditure of funds by LEAs. ESSER funds totaling $6,979,815.88 were expended and reported on the Ben Hill County Board of Education’s Schedule of Expenditures of Federal Awards (SEFA) for fiscal year 2021. Criteria: As a recipient of federal awards, the School District is required to establish and maintain effective internal control over federal awards that provides reasonable assurance of managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards pursuant to Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance), Section 200.303 – Internal Controls. Provisions included in the Uniform Guidance, Section 200.313(d)(1) state, “Property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the FAIN), who holds title, the acquisition date, and cost of the property, percentage of Federal participation in the project costs for the Federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sale price of the property.” Furthermore, to assist school districts in improving their financial management systems and associated compliance over federal programs, GaDOE published the Financial Management for Georgia Local Units of Administration (FMGLUA) manual. The FMGLUA manual requires that LEAs submit a budget as part of each federal program’s Consolidated Application process. The program budget reflects details regarding the manner in which each school district intends to expend the program funds. The Consolidated Application, including the budget, for each program must be reviewed and approved by GaDOE personnel before the LEA is authorized to expend program funds. Amendments to the budget are to be submitted to and approved by GaDOE when a school district intends to spend funds in a manner not initially reported. Lastly, LEA personnel must also provide program-specific assurances related to the ESSER programs within the Consolidated Application system. These assurances are reflected in the Uniform Guidance, Section 200.415 – Required Certifications, and include provisions that require LEAs “to assure that expenditures are proper and in accordance with the terms and conditions of the Federal award and approved project budgets...” Condition: The following deficiencies were noted when reviewing the ESSER program: • 12 pieces of equipment with costs totaling $347,619.04, which were purchased with program funds, were not included on the federal program’s equipment listing. • The related expenditures for seven equipment additions with costs totaling $156,067.46 were not appropriately approved by GaDOE through the Consolidated Application process. Further, the expenditures were not submitted for approval on an amended budget as of the end of audit fieldwork. Cause: Issues were a result of inadequate controls and review procedures over equipment. Effect: The School District is not in compliance with the Uniform Guidance and GaDOE guidance. Failure to maintain a complete and accurate equipment listing and reconcile results of the physical inventory performed to the property records exposes the School District to unnecessary risk of error and misuse of equipment and/or federal funds. Additionally, failure to verify compliance with applicable policies and regulations, including reviewing approved budgets prior to the expenditure of federal program funds may expose the School District to unnecessary financial strains and shortages. Recommendation: The School District should develop and maintain an equipment listing that reflects all required information, including a description, an identifying number, the source of funding, the title holder, the acquisition date, the cost, the percentage of federal participation in the project costs, the location, the use and condition, and any ultimate disposal data for each piece of equipment. Management should also implement controls to ensure that a complete physical inventory of equipment is performed, and the results are reconciled back to the equipment listing at least once every two years. In addition, the School District should also revise current internal control procedures related to the ESSER program. Where vulnerable, the School District should develop and/or modify its policies and procedures to ensure that potential expenditures are approved through the Consolidated Application process and deemed to be allowable before spending federal funds. Management should also develop and implement a monitoring process to ensure that control procedures are being followed. Views of Responsible Officials: We concur with this finding.
2022-001 – Equipment and Real Property Management – Material Weakness in Internal Controls over Compliance Federal Program Information: Funding Agency: U. S. Department of Health and Human Services Title: Headstart Cluster CFDA Number: 93.600 Federal Award Identification number: N/A Pass Through Entity: N/A Award Year: 2022 Condition: The Entity did not conduct a physical inventory in current year or prior year. Criteria: Per Title 2 US Code of Federal Regulations Part 200.303a, non-federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Per 2 CFR 200.313(d)(2), a physical inventory of program property must be taken and the results reconciled with the property records at least once every 2 years. Questioned costs: None Effect: The Entity could dispose of or lose federally funded equipment without following federal guidelines. Cause: The Entity does not have policies and procedures to ensure that the Entity is performing a physical inventory at a minimum of every two years.
2022-001 – Equipment and Real Property Management – Material Weakness in Internal Controls over Compliance Federal Program Information: Funding Agency: U. S. Department of Health and Human Services Title: Headstart Cluster CFDA Number: 93.600 Federal Award Identification number: N/A Pass Through Entity: N/A Award Year: 2022 Condition: The Entity did not conduct a physical inventory in current year or prior year. Criteria: Per Title 2 US Code of Federal Regulations Part 200.303a, non-federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Per 2 CFR 200.313(d)(2), a physical inventory of program property must be taken and the results reconciled with the property records at least once every 2 years. Questioned costs: None Effect: The Entity could dispose of or lose federally funded equipment without following federal guidelines. Cause: The Entity does not have policies and procedures to ensure that the Entity is performing a physical inventory at a minimum of every two years.
FA 2022-02 Strengthen Controls over Expenditures Compliance Requirement: Activities Allowed or Unallowed Allowable Costs/Cost Principles Equipment and Real Property Management Internal Control Impact: Material Weakness Compliance Impact: Material Noncompliance Federal Awarding Agency: U.S. Department of Education Pass-Through Entity: Georgia Department of Education AL Numbers and Titles: COVID-19 – 84.425D – Elementary and Secondary School Emergency Relief Fund COVID-19 – 84.425U – American Rescue Plan Elementary and Secondary School Emergency Relief Fund COVID-19 – 84.425U – American Rescue Plan Elementary and Secondary School Emergency Relief Fund Federal Award Numbers: S425D210012 (Year: 2021), S425U210012 (Year: 2021), S425Q210012 (Year 2021) Questioned Costs: $192,004.45 Description: The policies and procedures of the School District were insufficient to provide adequate internal controls over expenditures and equipment as it relates to the Elementary and Secondary School Emergency Relief Fund program. Background: On March 27, 2020, the Coronavirus Aid, Relief, and Economic Security (CARES) Act was signed into law. The CARES Act was designed to mitigate the economic effects of the COVID-19 pandemic in a variety of ways, including providing additional funding for local educational agencies (LEAs) navigating the impact of the COVID-19 outbreak. Provisions included in Title VIII of the CARES Act created the Education Stabilization Fund to provide financial resources to educational entities to prevent, prepare for, and respond to the coronavirus. The CARES Act allocated $30.75 billion, the Coronavirus Response and Relief Supplemental Appropriations Act allocated an additional $81.9 billion, and the American Rescue Plan Act added $165.1 billion in funding to the Education Stabilization Fund. Multiple Education Stabilization Fund subprograms were created and allotted funding through the various COVID-19-related legislation. Of these programs, the Elementary and Secondary School Emergency Relief (ESSER) Fund was created to address the impact that COVID-19 has had, and continues to have, on elementary and secondary schools across the nation. ESSER funding was granted to the Georgia Department of Education (GaDOE) by the U.S. Department of Education (ED). GaDOE is responsible for distributing funds to LEAs and overseeing the expenditure of funds by LEAs. ESSER funds totaling $3,287,369.95 were expended and reported on the Telfair County Board of Education’s Schedule of Expenditures of Federal Awards (SEFA) for fiscal year 2022. Criteria: As a recipient of federal awards, the School District is required to establish and maintain effective internal control over federal awards that provides reasonable assurance of managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards pursuant to Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance), Section 200.303 – Internal Controls. Provisions included in the Uniform Guidance, Section 200.403 – Factors Affecting Allowability of Costs state that “costs must meet the following general criteria in order to be allowable under Federal awards: (a) Be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles, (b) Conform to any limitations or exclusions set forth in these principles or in the Federal award as to types or amount of cost items, (c) Be consistent with policies and procedures that apply uniformly to both federally-financed and other activities of the non-Federal entity… (g) Be adequately documented…” In addition, provisions included in the Uniform Guidance, Section 202.403 – Reasonable Costs state that “a cost is reasonable if, in its nature and amount, it does not exceed that which would be incurred by a prudent person under the circumstances prevailing at the time the decision was made to incur the cost. The question of reasonableness is particularly important when the non-Federal entity is predominantly federally-funded. In determining reasonableness of a given cost, consideration must be given to: (a) Whether the cost is of a type generally recognized as ordinary and necessary for the operation of the non-Federal entity or the proper and efficient performance of the Federal award. (b) The restraints or requirements imposed by such factors as: sound business practices; arm’s-length bargaining; Federal, state, local, tribal, and other laws and regulations; and terms and conditions of the Federal award… (d) Whether the individuals concerned acted with prudence in the circumstances considering their responsibilities to the non-Federal entity, its employees, where applicable its students or membership, the public at large, and the Federal Government. (e) Whether the non-Federal entity significantly deviates from its established practices and policies regarding the incurrence of costs, which may unjustifiably increase the Federal award’s cost.” Furthermore, as a condition of receiving federal subawards from the GaDOE, LEAs are required to prepare an annual budget that reflects how funding will be expended. This budget is submitted in the Consolidated Application system and is required to be reviewed and approved by the GaDOE program and grants management prior to expending federal program funds. LEA personnel must also provide program-specific assurances related to the ESSER program within the Consolidated Application system. These assurances are reflected in the Uniform Guidance, Section 200.415 – Required Certifications, and include provisions that require LEAs “to assure that expenditures are proper and in accordance with the terms and conditions of the Federal award and approved project budgets...” Lastly, provisions included in the Uniform Guidance, Section 200.313 - Equipment state that "equipment must be used by the non-Federal entity in the program or project for which it was acquired as long as needed, whether or not the project or program continues to be supported by the Federal award, and the non-Federal entity must not encumber the property without prior approval of the Federal awarding agency." Condition: A sample of 23 nonpersonal services expenditures was randomly selected for testing using a nonstatistical sampling approach. In addition, six individually significant expenditures were selected for testing. These expenditures were reviewed to determine if appropriate internal controls were implemented and applicable compliance requirements were met. Furthermore, all equipment items purchased during the period under review were selected for testing to ensure approval was obtained from GaDOE prior to the purchase of the equipment. The following deficiencies were noted: • Two randomly selected expenditures totaling $7,678.24 were not appropriately approved by GaDOE through the Consolidated Application process as required. • Two individually significant items totaling $99,628.33 were not appropriately approved by GaDOE through the Consolidated Application process as required. • The purchase of two servers totaling $35,022.88 was not appropriately approved by GaDOE through the Consolidated Application process as required. • Bonuses totaling $43,900.00 were paid to individuals who were not employees of the School District. These individuals were hired to perform specific functions as detailed within the associated contracts and were paid amounts in excess of the stated rate noted within these contracts. Questioned Costs: Upon testing a sample of $142,102.78 in nonpersonal services expenditures, known questioned costs of $7,678.24 were identified. Using the population being sampled, which totaled $279,079.35, we project the likely questioned costs to be approximately $15,079.50. In addition, known questioned costs identified for unallowable/undocumented payments associated with individually significant items tested totaled $184,326.21; therefore, the known and likely questioned costs identified for all unallowable payments throughout the sample and individually significant items tested totaled $192,004.45 and $199,405.71, respectively. Cause: Per discussion with management, the School District believed that the bonuses were allowable as the expenditures were approved by GaDOE through the Consolidated Application process; however, they were not aware that contract amendments should be initiated prior to the expenditure of funds in this manner. In discussing the expenditures not approved on the Consolidated Application, they stated that the School District management did not update the ESSER Consolidated Application system prior to expending the funds for a different purpose. Effect: The School District is not in compliance with the Uniform Guidance, ED, or GaDOE guidance related to the ESSER program. Failure to ensure that appropriate policies and procedures are followed when expending federal funds may expose the School District to unnecessary financial strains and shortages as GaDOE may require the School District to return funds associated with unallowable expenditures. Recommendation: The School District should review current internal control procedures related to ESSER program expenditures. Where vulnerable, the School District should develop and/or modify its policies and procedures to ensure that expenditures are in line with provisions reflected within the associated contract and/or contract amendments. In addition, the School District should implement a monitoring process to ensure that all expenditures are compliant with the School District’s purchasing and employee compensation policies and procedures. Views of Responsible Officials: The School District does not agree with this finding. The School District feels this was an isolated incident due to the unique circumstances of this atypical grant. All documentation required by the vendors used was provided. The School District believes GaDOE guidelines and district Board approved procedures were followed on all expenditures except for a portion of the bonuses referenced. Auditor’s Concluding Remarks: School District personnel state that the School District “believes GaDOE guidelines and district Board approved procedures were followed”. While the expenditures may be allowable in nature, the School District is still required to get approval from GaDOE to be allowable per the Uniform Guidance. School Districts are expected and required to comply with federal regulations associated with the federal program. When each federal program budget is submitted to GaDOE, School District management signs assurances certifying that “each program will be administered in accordance with all applicable statutes, internal controls in the procurement process for goods and services in accordance with Georgia’s Financial Management for Georgia LUAS Manual.” As noted previously, the School District did follow appropriate procurement policies and procedures. We reaffirm our finding and will review the status of the finding during our next audit.
FA 2022-02 Strengthen Controls over Expenditures Compliance Requirement: Activities Allowed or Unallowed Allowable Costs/Cost Principles Equipment and Real Property Management Internal Control Impact: Material Weakness Compliance Impact: Material Noncompliance Federal Awarding Agency: U.S. Department of Education Pass-Through Entity: Georgia Department of Education AL Numbers and Titles: COVID-19 – 84.425D – Elementary and Secondary School Emergency Relief Fund COVID-19 – 84.425U – American Rescue Plan Elementary and Secondary School Emergency Relief Fund COVID-19 – 84.425U – American Rescue Plan Elementary and Secondary School Emergency Relief Fund Federal Award Numbers: S425D210012 (Year: 2021), S425U210012 (Year: 2021), S425Q210012 (Year 2021) Questioned Costs: $192,004.45 Description: The policies and procedures of the School District were insufficient to provide adequate internal controls over expenditures and equipment as it relates to the Elementary and Secondary School Emergency Relief Fund program. Background: On March 27, 2020, the Coronavirus Aid, Relief, and Economic Security (CARES) Act was signed into law. The CARES Act was designed to mitigate the economic effects of the COVID-19 pandemic in a variety of ways, including providing additional funding for local educational agencies (LEAs) navigating the impact of the COVID-19 outbreak. Provisions included in Title VIII of the CARES Act created the Education Stabilization Fund to provide financial resources to educational entities to prevent, prepare for, and respond to the coronavirus. The CARES Act allocated $30.75 billion, the Coronavirus Response and Relief Supplemental Appropriations Act allocated an additional $81.9 billion, and the American Rescue Plan Act added $165.1 billion in funding to the Education Stabilization Fund. Multiple Education Stabilization Fund subprograms were created and allotted funding through the various COVID-19-related legislation. Of these programs, the Elementary and Secondary School Emergency Relief (ESSER) Fund was created to address the impact that COVID-19 has had, and continues to have, on elementary and secondary schools across the nation. ESSER funding was granted to the Georgia Department of Education (GaDOE) by the U.S. Department of Education (ED). GaDOE is responsible for distributing funds to LEAs and overseeing the expenditure of funds by LEAs. ESSER funds totaling $3,287,369.95 were expended and reported on the Telfair County Board of Education’s Schedule of Expenditures of Federal Awards (SEFA) for fiscal year 2022. Criteria: As a recipient of federal awards, the School District is required to establish and maintain effective internal control over federal awards that provides reasonable assurance of managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards pursuant to Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance), Section 200.303 – Internal Controls. Provisions included in the Uniform Guidance, Section 200.403 – Factors Affecting Allowability of Costs state that “costs must meet the following general criteria in order to be allowable under Federal awards: (a) Be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles, (b) Conform to any limitations or exclusions set forth in these principles or in the Federal award as to types or amount of cost items, (c) Be consistent with policies and procedures that apply uniformly to both federally-financed and other activities of the non-Federal entity… (g) Be adequately documented…” In addition, provisions included in the Uniform Guidance, Section 202.403 – Reasonable Costs state that “a cost is reasonable if, in its nature and amount, it does not exceed that which would be incurred by a prudent person under the circumstances prevailing at the time the decision was made to incur the cost. The question of reasonableness is particularly important when the non-Federal entity is predominantly federally-funded. In determining reasonableness of a given cost, consideration must be given to: (a) Whether the cost is of a type generally recognized as ordinary and necessary for the operation of the non-Federal entity or the proper and efficient performance of the Federal award. (b) The restraints or requirements imposed by such factors as: sound business practices; arm’s-length bargaining; Federal, state, local, tribal, and other laws and regulations; and terms and conditions of the Federal award… (d) Whether the individuals concerned acted with prudence in the circumstances considering their responsibilities to the non-Federal entity, its employees, where applicable its students or membership, the public at large, and the Federal Government. (e) Whether the non-Federal entity significantly deviates from its established practices and policies regarding the incurrence of costs, which may unjustifiably increase the Federal award’s cost.” Furthermore, as a condition of receiving federal subawards from the GaDOE, LEAs are required to prepare an annual budget that reflects how funding will be expended. This budget is submitted in the Consolidated Application system and is required to be reviewed and approved by the GaDOE program and grants management prior to expending federal program funds. LEA personnel must also provide program-specific assurances related to the ESSER program within the Consolidated Application system. These assurances are reflected in the Uniform Guidance, Section 200.415 – Required Certifications, and include provisions that require LEAs “to assure that expenditures are proper and in accordance with the terms and conditions of the Federal award and approved project budgets...” Lastly, provisions included in the Uniform Guidance, Section 200.313 - Equipment state that "equipment must be used by the non-Federal entity in the program or project for which it was acquired as long as needed, whether or not the project or program continues to be supported by the Federal award, and the non-Federal entity must not encumber the property without prior approval of the Federal awarding agency." Condition: A sample of 23 nonpersonal services expenditures was randomly selected for testing using a nonstatistical sampling approach. In addition, six individually significant expenditures were selected for testing. These expenditures were reviewed to determine if appropriate internal controls were implemented and applicable compliance requirements were met. Furthermore, all equipment items purchased during the period under review were selected for testing to ensure approval was obtained from GaDOE prior to the purchase of the equipment. The following deficiencies were noted: • Two randomly selected expenditures totaling $7,678.24 were not appropriately approved by GaDOE through the Consolidated Application process as required. • Two individually significant items totaling $99,628.33 were not appropriately approved by GaDOE through the Consolidated Application process as required. • The purchase of two servers totaling $35,022.88 was not appropriately approved by GaDOE through the Consolidated Application process as required. • Bonuses totaling $43,900.00 were paid to individuals who were not employees of the School District. These individuals were hired to perform specific functions as detailed within the associated contracts and were paid amounts in excess of the stated rate noted within these contracts. Questioned Costs: Upon testing a sample of $142,102.78 in nonpersonal services expenditures, known questioned costs of $7,678.24 were identified. Using the population being sampled, which totaled $279,079.35, we project the likely questioned costs to be approximately $15,079.50. In addition, known questioned costs identified for unallowable/undocumented payments associated with individually significant items tested totaled $184,326.21; therefore, the known and likely questioned costs identified for all unallowable payments throughout the sample and individually significant items tested totaled $192,004.45 and $199,405.71, respectively. Cause: Per discussion with management, the School District believed that the bonuses were allowable as the expenditures were approved by GaDOE through the Consolidated Application process; however, they were not aware that contract amendments should be initiated prior to the expenditure of funds in this manner. In discussing the expenditures not approved on the Consolidated Application, they stated that the School District management did not update the ESSER Consolidated Application system prior to expending the funds for a different purpose. Effect: The School District is not in compliance with the Uniform Guidance, ED, or GaDOE guidance related to the ESSER program. Failure to ensure that appropriate policies and procedures are followed when expending federal funds may expose the School District to unnecessary financial strains and shortages as GaDOE may require the School District to return funds associated with unallowable expenditures. Recommendation: The School District should review current internal control procedures related to ESSER program expenditures. Where vulnerable, the School District should develop and/or modify its policies and procedures to ensure that expenditures are in line with provisions reflected within the associated contract and/or contract amendments. In addition, the School District should implement a monitoring process to ensure that all expenditures are compliant with the School District’s purchasing and employee compensation policies and procedures. Views of Responsible Officials: The School District does not agree with this finding. The School District feels this was an isolated incident due to the unique circumstances of this atypical grant. All documentation required by the vendors used was provided. The School District believes GaDOE guidelines and district Board approved procedures were followed on all expenditures except for a portion of the bonuses referenced. Auditor’s Concluding Remarks: School District personnel state that the School District “believes GaDOE guidelines and district Board approved procedures were followed”. While the expenditures may be allowable in nature, the School District is still required to get approval from GaDOE to be allowable per the Uniform Guidance. School Districts are expected and required to comply with federal regulations associated with the federal program. When each federal program budget is submitted to GaDOE, School District management signs assurances certifying that “each program will be administered in accordance with all applicable statutes, internal controls in the procurement process for goods and services in accordance with Georgia’s Financial Management for Georgia LUAS Manual.” As noted previously, the School District did follow appropriate procurement policies and procedures. We reaffirm our finding and will review the status of the finding during our next audit.
Finding 2022 003 Federal Program Title ? Research & Development Cluster Assistance Listing No. ? As listed on the Schedule of Expenditures of Federal Awards Federal Agencies ? U.S. Department of Agriculture, U.S. Department of Commerce, U.S. Department of Defense, U.S. Department of Interior, U.S. Department of Justice, Department of State, U.S. Department of Transportation, National Aeronautics and Space Administration, National Endowment for the Humanities, National Science Foundation, U.S. Department of Veterans Affairs, U.S. Department of Energy, U.S. Department of Education, and U.S. Department of Health and Human Services Federal Award Numbers ? As listed on the Schedule of Expenditures of Federal Awards Grant Award Periods ? Various Compliance Requirement ? Equipment/Real Property Management Criteria: As set forth in 2 CFR 200.313(d)(1), property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the FAIN), who holds title, the acquisition date, cost of the property, percentage of Federal participation in the project costs for the Federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sale price of the property. Additionally, 2 CFR 200.303 requires nonfederal entities to, among other things, 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. Conditions Found: While performing audit procedures related to the accuracy and completeness of property records and physical inspection of the existence and safeguarding of fifty-seven equipment items (with a net book value of 628,232), the following conditions were identified: ? During our physical inspection procedures, which took several attempts, we noted thirty-five equipment items sampled (with a net book value of $583,715) that were not found at the location stated within the fiscal year 2022 property records maintained by the University for the following items: See Schedule of Findings and Questioned Costs for chart/table The property records for ten equipment items sampled (with a net book value of $327,266) did not have accurate property records (note some of these same equipment items were also not found at the location stated and were also included in the table above). Specifically, the serial number on the equipment item sampled was not documented in the fiscal year 2022 property records maintained by the University for the following items: See Schedule of Findings and Questioned Costs for chart/table ? The property records for two equipment items (with $0 net book value) sampled were not updated to reflect disposals made during fiscal year 2022. Management stated no proceeds were received for the following items: See Schedule of Findings and Questioned Costs for chart/table The University did not have an effective system of internal control in place to ensure property records accurately reflect equipment locations, equipment serial numbers, and disposals. As of June 30, 2022, the University was responsible for maintaining and safeguarding equipment purchased using federal awards with a net book value of $2,110,646. Questioned Cost: There are no questioned costs. Cause and Effect: In discussing these conditions with University management, they stated that inadequate documentation of policies and procedures regarding the types of conditions that require communication to the Business and Finance office (e.g., when equipment is moved to a different location), as well as a lack of a review of changes made to property records by someone other than the preparer, contributed to multiple errors in the property records. Repeat Finding: A similar finding was reported in prior year audit as finding number 2021 003. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendations: We recommend the University strengthen policies, procedures and internal controls to ensure requirements around equipment/real property management are met. We recommend the University perform a detailed review of the property records and make corrections to accurately reflect the required information. We also recommend the University take a fresh look at their capital equipment recordkeeping policies and procedures and consider both preventive and detective internal controls to ensure property records accurately reflect the requirements of 2 CFR 200.313(d)(1).
Finding 2022 003 Federal Program Title ? Research & Development Cluster Assistance Listing No. ? As listed on the Schedule of Expenditures of Federal Awards Federal Agencies ? U.S. Department of Agriculture, U.S. Department of Commerce, U.S. Department of Defense, U.S. Department of Interior, U.S. Department of Justice, Department of State, U.S. Department of Transportation, National Aeronautics and Space Administration, National Endowment for the Humanities, National Science Foundation, U.S. Department of Veterans Affairs, U.S. Department of Energy, U.S. Department of Education, and U.S. Department of Health and Human Services Federal Award Numbers ? As listed on the Schedule of Expenditures of Federal Awards Grant Award Periods ? Various Compliance Requirement ? Equipment/Real Property Management Criteria: As set forth in 2 CFR 200.313(d)(1), property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the FAIN), who holds title, the acquisition date, cost of the property, percentage of Federal participation in the project costs for the Federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sale price of the property. Additionally, 2 CFR 200.303 requires nonfederal entities to, among other things, 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. Conditions Found: While performing audit procedures related to the accuracy and completeness of property records and physical inspection of the existence and safeguarding of fifty-seven equipment items (with a net book value of 628,232), the following conditions were identified: ? During our physical inspection procedures, which took several attempts, we noted thirty-five equipment items sampled (with a net book value of $583,715) that were not found at the location stated within the fiscal year 2022 property records maintained by the University for the following items: See Schedule of Findings and Questioned Costs for chart/table The property records for ten equipment items sampled (with a net book value of $327,266) did not have accurate property records (note some of these same equipment items were also not found at the location stated and were also included in the table above). Specifically, the serial number on the equipment item sampled was not documented in the fiscal year 2022 property records maintained by the University for the following items: See Schedule of Findings and Questioned Costs for chart/table ? The property records for two equipment items (with $0 net book value) sampled were not updated to reflect disposals made during fiscal year 2022. Management stated no proceeds were received for the following items: See Schedule of Findings and Questioned Costs for chart/table The University did not have an effective system of internal control in place to ensure property records accurately reflect equipment locations, equipment serial numbers, and disposals. As of June 30, 2022, the University was responsible for maintaining and safeguarding equipment purchased using federal awards with a net book value of $2,110,646. Questioned Cost: There are no questioned costs. Cause and Effect: In discussing these conditions with University management, they stated that inadequate documentation of policies and procedures regarding the types of conditions that require communication to the Business and Finance office (e.g., when equipment is moved to a different location), as well as a lack of a review of changes made to property records by someone other than the preparer, contributed to multiple errors in the property records. Repeat Finding: A similar finding was reported in prior year audit as finding number 2021 003. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendations: We recommend the University strengthen policies, procedures and internal controls to ensure requirements around equipment/real property management are met. We recommend the University perform a detailed review of the property records and make corrections to accurately reflect the required information. We also recommend the University take a fresh look at their capital equipment recordkeeping policies and procedures and consider both preventive and detective internal controls to ensure property records accurately reflect the requirements of 2 CFR 200.313(d)(1).
Finding 2022 003 Federal Program Title ? Research & Development Cluster Assistance Listing No. ? As listed on the Schedule of Expenditures of Federal Awards Federal Agencies ? U.S. Department of Agriculture, U.S. Department of Commerce, U.S. Department of Defense, U.S. Department of Interior, U.S. Department of Justice, Department of State, U.S. Department of Transportation, National Aeronautics and Space Administration, National Endowment for the Humanities, National Science Foundation, U.S. Department of Veterans Affairs, U.S. Department of Energy, U.S. Department of Education, and U.S. Department of Health and Human Services Federal Award Numbers ? As listed on the Schedule of Expenditures of Federal Awards Grant Award Periods ? Various Compliance Requirement ? Equipment/Real Property Management Criteria: As set forth in 2 CFR 200.313(d)(1), property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the FAIN), who holds title, the acquisition date, cost of the property, percentage of Federal participation in the project costs for the Federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sale price of the property. Additionally, 2 CFR 200.303 requires nonfederal entities to, among other things, 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. Conditions Found: While performing audit procedures related to the accuracy and completeness of property records and physical inspection of the existence and safeguarding of fifty-seven equipment items (with a net book value of 628,232), the following conditions were identified: ? During our physical inspection procedures, which took several attempts, we noted thirty-five equipment items sampled (with a net book value of $583,715) that were not found at the location stated within the fiscal year 2022 property records maintained by the University for the following items: See Schedule of Findings and Questioned Costs for chart/table The property records for ten equipment items sampled (with a net book value of $327,266) did not have accurate property records (note some of these same equipment items were also not found at the location stated and were also included in the table above). Specifically, the serial number on the equipment item sampled was not documented in the fiscal year 2022 property records maintained by the University for the following items: See Schedule of Findings and Questioned Costs for chart/table ? The property records for two equipment items (with $0 net book value) sampled were not updated to reflect disposals made during fiscal year 2022. Management stated no proceeds were received for the following items: See Schedule of Findings and Questioned Costs for chart/table The University did not have an effective system of internal control in place to ensure property records accurately reflect equipment locations, equipment serial numbers, and disposals. As of June 30, 2022, the University was responsible for maintaining and safeguarding equipment purchased using federal awards with a net book value of $2,110,646. Questioned Cost: There are no questioned costs. Cause and Effect: In discussing these conditions with University management, they stated that inadequate documentation of policies and procedures regarding the types of conditions that require communication to the Business and Finance office (e.g., when equipment is moved to a different location), as well as a lack of a review of changes made to property records by someone other than the preparer, contributed to multiple errors in the property records. Repeat Finding: A similar finding was reported in prior year audit as finding number 2021 003. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendations: We recommend the University strengthen policies, procedures and internal controls to ensure requirements around equipment/real property management are met. We recommend the University perform a detailed review of the property records and make corrections to accurately reflect the required information. We also recommend the University take a fresh look at their capital equipment recordkeeping policies and procedures and consider both preventive and detective internal controls to ensure property records accurately reflect the requirements of 2 CFR 200.313(d)(1).
Finding 2022 003 Federal Program Title ? Research & Development Cluster Assistance Listing No. ? As listed on the Schedule of Expenditures of Federal Awards Federal Agencies ? U.S. Department of Agriculture, U.S. Department of Commerce, U.S. Department of Defense, U.S. Department of Interior, U.S. Department of Justice, Department of State, U.S. Department of Transportation, National Aeronautics and Space Administration, National Endowment for the Humanities, National Science Foundation, U.S. Department of Veterans Affairs, U.S. Department of Energy, U.S. Department of Education, and U.S. Department of Health and Human Services Federal Award Numbers ? As listed on the Schedule of Expenditures of Federal Awards Grant Award Periods ? Various Compliance Requirement ? Equipment/Real Property Management Criteria: As set forth in 2 CFR 200.313(d)(1), property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the FAIN), who holds title, the acquisition date, cost of the property, percentage of Federal participation in the project costs for the Federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sale price of the property. Additionally, 2 CFR 200.303 requires nonfederal entities to, among other things, 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. Conditions Found: While performing audit procedures related to the accuracy and completeness of property records and physical inspection of the existence and safeguarding of fifty-seven equipment items (with a net book value of 628,232), the following conditions were identified: ? During our physical inspection procedures, which took several attempts, we noted thirty-five equipment items sampled (with a net book value of $583,715) that were not found at the location stated within the fiscal year 2022 property records maintained by the University for the following items: See Schedule of Findings and Questioned Costs for chart/table The property records for ten equipment items sampled (with a net book value of $327,266) did not have accurate property records (note some of these same equipment items were also not found at the location stated and were also included in the table above). Specifically, the serial number on the equipment item sampled was not documented in the fiscal year 2022 property records maintained by the University for the following items: See Schedule of Findings and Questioned Costs for chart/table ? The property records for two equipment items (with $0 net book value) sampled were not updated to reflect disposals made during fiscal year 2022. Management stated no proceeds were received for the following items: See Schedule of Findings and Questioned Costs for chart/table The University did not have an effective system of internal control in place to ensure property records accurately reflect equipment locations, equipment serial numbers, and disposals. As of June 30, 2022, the University was responsible for maintaining and safeguarding equipment purchased using federal awards with a net book value of $2,110,646. Questioned Cost: There are no questioned costs. Cause and Effect: In discussing these conditions with University management, they stated that inadequate documentation of policies and procedures regarding the types of conditions that require communication to the Business and Finance office (e.g., when equipment is moved to a different location), as well as a lack of a review of changes made to property records by someone other than the preparer, contributed to multiple errors in the property records. Repeat Finding: A similar finding was reported in prior year audit as finding number 2021 003. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendations: We recommend the University strengthen policies, procedures and internal controls to ensure requirements around equipment/real property management are met. We recommend the University perform a detailed review of the property records and make corrections to accurately reflect the required information. We also recommend the University take a fresh look at their capital equipment recordkeeping policies and procedures and consider both preventive and detective internal controls to ensure property records accurately reflect the requirements of 2 CFR 200.313(d)(1).
Finding 2022 003 Federal Program Title ? Research & Development Cluster Assistance Listing No. ? As listed on the Schedule of Expenditures of Federal Awards Federal Agencies ? U.S. Department of Agriculture, U.S. Department of Commerce, U.S. Department of Defense, U.S. Department of Interior, U.S. Department of Justice, Department of State, U.S. Department of Transportation, National Aeronautics and Space Administration, National Endowment for the Humanities, National Science Foundation, U.S. Department of Veterans Affairs, U.S. Department of Energy, U.S. Department of Education, and U.S. Department of Health and Human Services Federal Award Numbers ? As listed on the Schedule of Expenditures of Federal Awards Grant Award Periods ? Various Compliance Requirement ? Equipment/Real Property Management Criteria: As set forth in 2 CFR 200.313(d)(1), property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the FAIN), who holds title, the acquisition date, cost of the property, percentage of Federal participation in the project costs for the Federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sale price of the property. Additionally, 2 CFR 200.303 requires nonfederal entities to, among other things, 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. Conditions Found: While performing audit procedures related to the accuracy and completeness of property records and physical inspection of the existence and safeguarding of fifty-seven equipment items (with a net book value of 628,232), the following conditions were identified: ? During our physical inspection procedures, which took several attempts, we noted thirty-five equipment items sampled (with a net book value of $583,715) that were not found at the location stated within the fiscal year 2022 property records maintained by the University for the following items: See Schedule of Findings and Questioned Costs for chart/table The property records for ten equipment items sampled (with a net book value of $327,266) did not have accurate property records (note some of these same equipment items were also not found at the location stated and were also included in the table above). Specifically, the serial number on the equipment item sampled was not documented in the fiscal year 2022 property records maintained by the University for the following items: See Schedule of Findings and Questioned Costs for chart/table ? The property records for two equipment items (with $0 net book value) sampled were not updated to reflect disposals made during fiscal year 2022. Management stated no proceeds were received for the following items: See Schedule of Findings and Questioned Costs for chart/table The University did not have an effective system of internal control in place to ensure property records accurately reflect equipment locations, equipment serial numbers, and disposals. As of June 30, 2022, the University was responsible for maintaining and safeguarding equipment purchased using federal awards with a net book value of $2,110,646. Questioned Cost: There are no questioned costs. Cause and Effect: In discussing these conditions with University management, they stated that inadequate documentation of policies and procedures regarding the types of conditions that require communication to the Business and Finance office (e.g., when equipment is moved to a different location), as well as a lack of a review of changes made to property records by someone other than the preparer, contributed to multiple errors in the property records. Repeat Finding: A similar finding was reported in prior year audit as finding number 2021 003. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendations: We recommend the University strengthen policies, procedures and internal controls to ensure requirements around equipment/real property management are met. We recommend the University perform a detailed review of the property records and make corrections to accurately reflect the required information. We also recommend the University take a fresh look at their capital equipment recordkeeping policies and procedures and consider both preventive and detective internal controls to ensure property records accurately reflect the requirements of 2 CFR 200.313(d)(1).
Finding 2022 003 Federal Program Title ? Research & Development Cluster Assistance Listing No. ? As listed on the Schedule of Expenditures of Federal Awards Federal Agencies ? U.S. Department of Agriculture, U.S. Department of Commerce, U.S. Department of Defense, U.S. Department of Interior, U.S. Department of Justice, Department of State, U.S. Department of Transportation, National Aeronautics and Space Administration, National Endowment for the Humanities, National Science Foundation, U.S. Department of Veterans Affairs, U.S. Department of Energy, U.S. Department of Education, and U.S. Department of Health and Human Services Federal Award Numbers ? As listed on the Schedule of Expenditures of Federal Awards Grant Award Periods ? Various Compliance Requirement ? Equipment/Real Property Management Criteria: As set forth in 2 CFR 200.313(d)(1), property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the FAIN), who holds title, the acquisition date, cost of the property, percentage of Federal participation in the project costs for the Federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sale price of the property. Additionally, 2 CFR 200.303 requires nonfederal entities to, among other things, 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. Conditions Found: While performing audit procedures related to the accuracy and completeness of property records and physical inspection of the existence and safeguarding of fifty-seven equipment items (with a net book value of 628,232), the following conditions were identified: ? During our physical inspection procedures, which took several attempts, we noted thirty-five equipment items sampled (with a net book value of $583,715) that were not found at the location stated within the fiscal year 2022 property records maintained by the University for the following items: See Schedule of Findings and Questioned Costs for chart/table The property records for ten equipment items sampled (with a net book value of $327,266) did not have accurate property records (note some of these same equipment items were also not found at the location stated and were also included in the table above). Specifically, the serial number on the equipment item sampled was not documented in the fiscal year 2022 property records maintained by the University for the following items: See Schedule of Findings and Questioned Costs for chart/table ? The property records for two equipment items (with $0 net book value) sampled were not updated to reflect disposals made during fiscal year 2022. Management stated no proceeds were received for the following items: See Schedule of Findings and Questioned Costs for chart/table The University did not have an effective system of internal control in place to ensure property records accurately reflect equipment locations, equipment serial numbers, and disposals. As of June 30, 2022, the University was responsible for maintaining and safeguarding equipment purchased using federal awards with a net book value of $2,110,646. Questioned Cost: There are no questioned costs. Cause and Effect: In discussing these conditions with University management, they stated that inadequate documentation of policies and procedures regarding the types of conditions that require communication to the Business and Finance office (e.g., when equipment is moved to a different location), as well as a lack of a review of changes made to property records by someone other than the preparer, contributed to multiple errors in the property records. Repeat Finding: A similar finding was reported in prior year audit as finding number 2021 003. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendations: We recommend the University strengthen policies, procedures and internal controls to ensure requirements around equipment/real property management are met. We recommend the University perform a detailed review of the property records and make corrections to accurately reflect the required information. We also recommend the University take a fresh look at their capital equipment recordkeeping policies and procedures and consider both preventive and detective internal controls to ensure property records accurately reflect the requirements of 2 CFR 200.313(d)(1).
Finding 2022 003 Federal Program Title ? Research & Development Cluster Assistance Listing No. ? As listed on the Schedule of Expenditures of Federal Awards Federal Agencies ? U.S. Department of Agriculture, U.S. Department of Commerce, U.S. Department of Defense, U.S. Department of Interior, U.S. Department of Justice, Department of State, U.S. Department of Transportation, National Aeronautics and Space Administration, National Endowment for the Humanities, National Science Foundation, U.S. Department of Veterans Affairs, U.S. Department of Energy, U.S. Department of Education, and U.S. Department of Health and Human Services Federal Award Numbers ? As listed on the Schedule of Expenditures of Federal Awards Grant Award Periods ? Various Compliance Requirement ? Equipment/Real Property Management Criteria: As set forth in 2 CFR 200.313(d)(1), property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the FAIN), who holds title, the acquisition date, cost of the property, percentage of Federal participation in the project costs for the Federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sale price of the property. Additionally, 2 CFR 200.303 requires nonfederal entities to, among other things, 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. Conditions Found: While performing audit procedures related to the accuracy and completeness of property records and physical inspection of the existence and safeguarding of fifty-seven equipment items (with a net book value of 628,232), the following conditions were identified: ? During our physical inspection procedures, which took several attempts, we noted thirty-five equipment items sampled (with a net book value of $583,715) that were not found at the location stated within the fiscal year 2022 property records maintained by the University for the following items: See Schedule of Findings and Questioned Costs for chart/table The property records for ten equipment items sampled (with a net book value of $327,266) did not have accurate property records (note some of these same equipment items were also not found at the location stated and were also included in the table above). Specifically, the serial number on the equipment item sampled was not documented in the fiscal year 2022 property records maintained by the University for the following items: See Schedule of Findings and Questioned Costs for chart/table ? The property records for two equipment items (with $0 net book value) sampled were not updated to reflect disposals made during fiscal year 2022. Management stated no proceeds were received for the following items: See Schedule of Findings and Questioned Costs for chart/table The University did not have an effective system of internal control in place to ensure property records accurately reflect equipment locations, equipment serial numbers, and disposals. As of June 30, 2022, the University was responsible for maintaining and safeguarding equipment purchased using federal awards with a net book value of $2,110,646. Questioned Cost: There are no questioned costs. Cause and Effect: In discussing these conditions with University management, they stated that inadequate documentation of policies and procedures regarding the types of conditions that require communication to the Business and Finance office (e.g., when equipment is moved to a different location), as well as a lack of a review of changes made to property records by someone other than the preparer, contributed to multiple errors in the property records. Repeat Finding: A similar finding was reported in prior year audit as finding number 2021 003. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendations: We recommend the University strengthen policies, procedures and internal controls to ensure requirements around equipment/real property management are met. We recommend the University perform a detailed review of the property records and make corrections to accurately reflect the required information. We also recommend the University take a fresh look at their capital equipment recordkeeping policies and procedures and consider both preventive and detective internal controls to ensure property records accurately reflect the requirements of 2 CFR 200.313(d)(1).
Finding 2022 003 Federal Program Title ? Research & Development Cluster Assistance Listing No. ? As listed on the Schedule of Expenditures of Federal Awards Federal Agencies ? U.S. Department of Agriculture, U.S. Department of Commerce, U.S. Department of Defense, U.S. Department of Interior, U.S. Department of Justice, Department of State, U.S. Department of Transportation, National Aeronautics and Space Administration, National Endowment for the Humanities, National Science Foundation, U.S. Department of Veterans Affairs, U.S. Department of Energy, U.S. Department of Education, and U.S. Department of Health and Human Services Federal Award Numbers ? As listed on the Schedule of Expenditures of Federal Awards Grant Award Periods ? Various Compliance Requirement ? Equipment/Real Property Management Criteria: As set forth in 2 CFR 200.313(d)(1), property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the FAIN), who holds title, the acquisition date, cost of the property, percentage of Federal participation in the project costs for the Federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sale price of the property. Additionally, 2 CFR 200.303 requires nonfederal entities to, among other things, 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. Conditions Found: While performing audit procedures related to the accuracy and completeness of property records and physical inspection of the existence and safeguarding of fifty-seven equipment items (with a net book value of 628,232), the following conditions were identified: ? During our physical inspection procedures, which took several attempts, we noted thirty-five equipment items sampled (with a net book value of $583,715) that were not found at the location stated within the fiscal year 2022 property records maintained by the University for the following items: See Schedule of Findings and Questioned Costs for chart/table The property records for ten equipment items sampled (with a net book value of $327,266) did not have accurate property records (note some of these same equipment items were also not found at the location stated and were also included in the table above). Specifically, the serial number on the equipment item sampled was not documented in the fiscal year 2022 property records maintained by the University for the following items: See Schedule of Findings and Questioned Costs for chart/table ? The property records for two equipment items (with $0 net book value) sampled were not updated to reflect disposals made during fiscal year 2022. Management stated no proceeds were received for the following items: See Schedule of Findings and Questioned Costs for chart/table The University did not have an effective system of internal control in place to ensure property records accurately reflect equipment locations, equipment serial numbers, and disposals. As of June 30, 2022, the University was responsible for maintaining and safeguarding equipment purchased using federal awards with a net book value of $2,110,646. Questioned Cost: There are no questioned costs. Cause and Effect: In discussing these conditions with University management, they stated that inadequate documentation of policies and procedures regarding the types of conditions that require communication to the Business and Finance office (e.g., when equipment is moved to a different location), as well as a lack of a review of changes made to property records by someone other than the preparer, contributed to multiple errors in the property records. Repeat Finding: A similar finding was reported in prior year audit as finding number 2021 003. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendations: We recommend the University strengthen policies, procedures and internal controls to ensure requirements around equipment/real property management are met. We recommend the University perform a detailed review of the property records and make corrections to accurately reflect the required information. We also recommend the University take a fresh look at their capital equipment recordkeeping policies and procedures and consider both preventive and detective internal controls to ensure property records accurately reflect the requirements of 2 CFR 200.313(d)(1).
Finding 2022 003 Federal Program Title ? Research & Development Cluster Assistance Listing No. ? As listed on the Schedule of Expenditures of Federal Awards Federal Agencies ? U.S. Department of Agriculture, U.S. Department of Commerce, U.S. Department of Defense, U.S. Department of Interior, U.S. Department of Justice, Department of State, U.S. Department of Transportation, National Aeronautics and Space Administration, National Endowment for the Humanities, National Science Foundation, U.S. Department of Veterans Affairs, U.S. Department of Energy, U.S. Department of Education, and U.S. Department of Health and Human Services Federal Award Numbers ? As listed on the Schedule of Expenditures of Federal Awards Grant Award Periods ? Various Compliance Requirement ? Equipment/Real Property Management Criteria: As set forth in 2 CFR 200.313(d)(1), property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the FAIN), who holds title, the acquisition date, cost of the property, percentage of Federal participation in the project costs for the Federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sale price of the property. Additionally, 2 CFR 200.303 requires nonfederal entities to, among other things, 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. Conditions Found: While performing audit procedures related to the accuracy and completeness of property records and physical inspection of the existence and safeguarding of fifty-seven equipment items (with a net book value of 628,232), the following conditions were identified: ? During our physical inspection procedures, which took several attempts, we noted thirty-five equipment items sampled (with a net book value of $583,715) that were not found at the location stated within the fiscal year 2022 property records maintained by the University for the following items: See Schedule of Findings and Questioned Costs for chart/table The property records for ten equipment items sampled (with a net book value of $327,266) did not have accurate property records (note some of these same equipment items were also not found at the location stated and were also included in the table above). Specifically, the serial number on the equipment item sampled was not documented in the fiscal year 2022 property records maintained by the University for the following items: See Schedule of Findings and Questioned Costs for chart/table ? The property records for two equipment items (with $0 net book value) sampled were not updated to reflect disposals made during fiscal year 2022. Management stated no proceeds were received for the following items: See Schedule of Findings and Questioned Costs for chart/table The University did not have an effective system of internal control in place to ensure property records accurately reflect equipment locations, equipment serial numbers, and disposals. As of June 30, 2022, the University was responsible for maintaining and safeguarding equipment purchased using federal awards with a net book value of $2,110,646. Questioned Cost: There are no questioned costs. Cause and Effect: In discussing these conditions with University management, they stated that inadequate documentation of policies and procedures regarding the types of conditions that require communication to the Business and Finance office (e.g., when equipment is moved to a different location), as well as a lack of a review of changes made to property records by someone other than the preparer, contributed to multiple errors in the property records. Repeat Finding: A similar finding was reported in prior year audit as finding number 2021 003. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendations: We recommend the University strengthen policies, procedures and internal controls to ensure requirements around equipment/real property management are met. We recommend the University perform a detailed review of the property records and make corrections to accurately reflect the required information. We also recommend the University take a fresh look at their capital equipment recordkeeping policies and procedures and consider both preventive and detective internal controls to ensure property records accurately reflect the requirements of 2 CFR 200.313(d)(1).
Finding 2022 003 Federal Program Title ? Research & Development Cluster Assistance Listing No. ? As listed on the Schedule of Expenditures of Federal Awards Federal Agencies ? U.S. Department of Agriculture, U.S. Department of Commerce, U.S. Department of Defense, U.S. Department of Interior, U.S. Department of Justice, Department of State, U.S. Department of Transportation, National Aeronautics and Space Administration, National Endowment for the Humanities, National Science Foundation, U.S. Department of Veterans Affairs, U.S. Department of Energy, U.S. Department of Education, and U.S. Department of Health and Human Services Federal Award Numbers ? As listed on the Schedule of Expenditures of Federal Awards Grant Award Periods ? Various Compliance Requirement ? Equipment/Real Property Management Criteria: As set forth in 2 CFR 200.313(d)(1), property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the FAIN), who holds title, the acquisition date, cost of the property, percentage of Federal participation in the project costs for the Federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sale price of the property. Additionally, 2 CFR 200.303 requires nonfederal entities to, among other things, 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. Conditions Found: While performing audit procedures related to the accuracy and completeness of property records and physical inspection of the existence and safeguarding of fifty-seven equipment items (with a net book value of 628,232), the following conditions were identified: ? During our physical inspection procedures, which took several attempts, we noted thirty-five equipment items sampled (with a net book value of $583,715) that were not found at the location stated within the fiscal year 2022 property records maintained by the University for the following items: See Schedule of Findings and Questioned Costs for chart/table The property records for ten equipment items sampled (with a net book value of $327,266) did not have accurate property records (note some of these same equipment items were also not found at the location stated and were also included in the table above). Specifically, the serial number on the equipment item sampled was not documented in the fiscal year 2022 property records maintained by the University for the following items: See Schedule of Findings and Questioned Costs for chart/table ? The property records for two equipment items (with $0 net book value) sampled were not updated to reflect disposals made during fiscal year 2022. Management stated no proceeds were received for the following items: See Schedule of Findings and Questioned Costs for chart/table The University did not have an effective system of internal control in place to ensure property records accurately reflect equipment locations, equipment serial numbers, and disposals. As of June 30, 2022, the University was responsible for maintaining and safeguarding equipment purchased using federal awards with a net book value of $2,110,646. Questioned Cost: There are no questioned costs. Cause and Effect: In discussing these conditions with University management, they stated that inadequate documentation of policies and procedures regarding the types of conditions that require communication to the Business and Finance office (e.g., when equipment is moved to a different location), as well as a lack of a review of changes made to property records by someone other than the preparer, contributed to multiple errors in the property records. Repeat Finding: A similar finding was reported in prior year audit as finding number 2021 003. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendations: We recommend the University strengthen policies, procedures and internal controls to ensure requirements around equipment/real property management are met. We recommend the University perform a detailed review of the property records and make corrections to accurately reflect the required information. We also recommend the University take a fresh look at their capital equipment recordkeeping policies and procedures and consider both preventive and detective internal controls to ensure property records accurately reflect the requirements of 2 CFR 200.313(d)(1).
Finding 2022 003 Federal Program Title ? Research & Development Cluster Assistance Listing No. ? As listed on the Schedule of Expenditures of Federal Awards Federal Agencies ? U.S. Department of Agriculture, U.S. Department of Commerce, U.S. Department of Defense, U.S. Department of Interior, U.S. Department of Justice, Department of State, U.S. Department of Transportation, National Aeronautics and Space Administration, National Endowment for the Humanities, National Science Foundation, U.S. Department of Veterans Affairs, U.S. Department of Energy, U.S. Department of Education, and U.S. Department of Health and Human Services Federal Award Numbers ? As listed on the Schedule of Expenditures of Federal Awards Grant Award Periods ? Various Compliance Requirement ? Equipment/Real Property Management Criteria: As set forth in 2 CFR 200.313(d)(1), property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the FAIN), who holds title, the acquisition date, cost of the property, percentage of Federal participation in the project costs for the Federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sale price of the property. Additionally, 2 CFR 200.303 requires nonfederal entities to, among other things, 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. Conditions Found: While performing audit procedures related to the accuracy and completeness of property records and physical inspection of the existence and safeguarding of fifty-seven equipment items (with a net book value of 628,232), the following conditions were identified: ? During our physical inspection procedures, which took several attempts, we noted thirty-five equipment items sampled (with a net book value of $583,715) that were not found at the location stated within the fiscal year 2022 property records maintained by the University for the following items: See Schedule of Findings and Questioned Costs for chart/table The property records for ten equipment items sampled (with a net book value of $327,266) did not have accurate property records (note some of these same equipment items were also not found at the location stated and were also included in the table above). Specifically, the serial number on the equipment item sampled was not documented in the fiscal year 2022 property records maintained by the University for the following items: See Schedule of Findings and Questioned Costs for chart/table ? The property records for two equipment items (with $0 net book value) sampled were not updated to reflect disposals made during fiscal year 2022. Management stated no proceeds were received for the following items: See Schedule of Findings and Questioned Costs for chart/table The University did not have an effective system of internal control in place to ensure property records accurately reflect equipment locations, equipment serial numbers, and disposals. As of June 30, 2022, the University was responsible for maintaining and safeguarding equipment purchased using federal awards with a net book value of $2,110,646. Questioned Cost: There are no questioned costs. Cause and Effect: In discussing these conditions with University management, they stated that inadequate documentation of policies and procedures regarding the types of conditions that require communication to the Business and Finance office (e.g., when equipment is moved to a different location), as well as a lack of a review of changes made to property records by someone other than the preparer, contributed to multiple errors in the property records. Repeat Finding: A similar finding was reported in prior year audit as finding number 2021 003. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendations: We recommend the University strengthen policies, procedures and internal controls to ensure requirements around equipment/real property management are met. We recommend the University perform a detailed review of the property records and make corrections to accurately reflect the required information. We also recommend the University take a fresh look at their capital equipment recordkeeping policies and procedures and consider both preventive and detective internal controls to ensure property records accurately reflect the requirements of 2 CFR 200.313(d)(1).
Finding 2022 003 Federal Program Title ? Research & Development Cluster Assistance Listing No. ? As listed on the Schedule of Expenditures of Federal Awards Federal Agencies ? U.S. Department of Agriculture, U.S. Department of Commerce, U.S. Department of Defense, U.S. Department of Interior, U.S. Department of Justice, Department of State, U.S. Department of Transportation, National Aeronautics and Space Administration, National Endowment for the Humanities, National Science Foundation, U.S. Department of Veterans Affairs, U.S. Department of Energy, U.S. Department of Education, and U.S. Department of Health and Human Services Federal Award Numbers ? As listed on the Schedule of Expenditures of Federal Awards Grant Award Periods ? Various Compliance Requirement ? Equipment/Real Property Management Criteria: As set forth in 2 CFR 200.313(d)(1), property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the FAIN), who holds title, the acquisition date, cost of the property, percentage of Federal participation in the project costs for the Federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sale price of the property. Additionally, 2 CFR 200.303 requires nonfederal entities to, among other things, 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. Conditions Found: While performing audit procedures related to the accuracy and completeness of property records and physical inspection of the existence and safeguarding of fifty-seven equipment items (with a net book value of 628,232), the following conditions were identified: ? During our physical inspection procedures, which took several attempts, we noted thirty-five equipment items sampled (with a net book value of $583,715) that were not found at the location stated within the fiscal year 2022 property records maintained by the University for the following items: See Schedule of Findings and Questioned Costs for chart/table The property records for ten equipment items sampled (with a net book value of $327,266) did not have accurate property records (note some of these same equipment items were also not found at the location stated and were also included in the table above). Specifically, the serial number on the equipment item sampled was not documented in the fiscal year 2022 property records maintained by the University for the following items: See Schedule of Findings and Questioned Costs for chart/table ? The property records for two equipment items (with $0 net book value) sampled were not updated to reflect disposals made during fiscal year 2022. Management stated no proceeds were received for the following items: See Schedule of Findings and Questioned Costs for chart/table The University did not have an effective system of internal control in place to ensure property records accurately reflect equipment locations, equipment serial numbers, and disposals. As of June 30, 2022, the University was responsible for maintaining and safeguarding equipment purchased using federal awards with a net book value of $2,110,646. Questioned Cost: There are no questioned costs. Cause and Effect: In discussing these conditions with University management, they stated that inadequate documentation of policies and procedures regarding the types of conditions that require communication to the Business and Finance office (e.g., when equipment is moved to a different location), as well as a lack of a review of changes made to property records by someone other than the preparer, contributed to multiple errors in the property records. Repeat Finding: A similar finding was reported in prior year audit as finding number 2021 003. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendations: We recommend the University strengthen policies, procedures and internal controls to ensure requirements around equipment/real property management are met. We recommend the University perform a detailed review of the property records and make corrections to accurately reflect the required information. We also recommend the University take a fresh look at their capital equipment recordkeeping policies and procedures and consider both preventive and detective internal controls to ensure property records accurately reflect the requirements of 2 CFR 200.313(d)(1).
Finding 2022 003 Federal Program Title ? Research & Development Cluster Assistance Listing No. ? As listed on the Schedule of Expenditures of Federal Awards Federal Agencies ? U.S. Department of Agriculture, U.S. Department of Commerce, U.S. Department of Defense, U.S. Department of Interior, U.S. Department of Justice, Department of State, U.S. Department of Transportation, National Aeronautics and Space Administration, National Endowment for the Humanities, National Science Foundation, U.S. Department of Veterans Affairs, U.S. Department of Energy, U.S. Department of Education, and U.S. Department of Health and Human Services Federal Award Numbers ? As listed on the Schedule of Expenditures of Federal Awards Grant Award Periods ? Various Compliance Requirement ? Equipment/Real Property Management Criteria: As set forth in 2 CFR 200.313(d)(1), property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the FAIN), who holds title, the acquisition date, cost of the property, percentage of Federal participation in the project costs for the Federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sale price of the property. Additionally, 2 CFR 200.303 requires nonfederal entities to, among other things, 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. Conditions Found: While performing audit procedures related to the accuracy and completeness of property records and physical inspection of the existence and safeguarding of fifty-seven equipment items (with a net book value of 628,232), the following conditions were identified: ? During our physical inspection procedures, which took several attempts, we noted thirty-five equipment items sampled (with a net book value of $583,715) that were not found at the location stated within the fiscal year 2022 property records maintained by the University for the following items: See Schedule of Findings and Questioned Costs for chart/table The property records for ten equipment items sampled (with a net book value of $327,266) did not have accurate property records (note some of these same equipment items were also not found at the location stated and were also included in the table above). Specifically, the serial number on the equipment item sampled was not documented in the fiscal year 2022 property records maintained by the University for the following items: See Schedule of Findings and Questioned Costs for chart/table ? The property records for two equipment items (with $0 net book value) sampled were not updated to reflect disposals made during fiscal year 2022. Management stated no proceeds were received for the following items: See Schedule of Findings and Questioned Costs for chart/table The University did not have an effective system of internal control in place to ensure property records accurately reflect equipment locations, equipment serial numbers, and disposals. As of June 30, 2022, the University was responsible for maintaining and safeguarding equipment purchased using federal awards with a net book value of $2,110,646. Questioned Cost: There are no questioned costs. Cause and Effect: In discussing these conditions with University management, they stated that inadequate documentation of policies and procedures regarding the types of conditions that require communication to the Business and Finance office (e.g., when equipment is moved to a different location), as well as a lack of a review of changes made to property records by someone other than the preparer, contributed to multiple errors in the property records. Repeat Finding: A similar finding was reported in prior year audit as finding number 2021 003. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendations: We recommend the University strengthen policies, procedures and internal controls to ensure requirements around equipment/real property management are met. We recommend the University perform a detailed review of the property records and make corrections to accurately reflect the required information. We also recommend the University take a fresh look at their capital equipment recordkeeping policies and procedures and consider both preventive and detective internal controls to ensure property records accurately reflect the requirements of 2 CFR 200.313(d)(1).
Finding 2022 003 Federal Program Title ? Research & Development Cluster Assistance Listing No. ? As listed on the Schedule of Expenditures of Federal Awards Federal Agencies ? U.S. Department of Agriculture, U.S. Department of Commerce, U.S. Department of Defense, U.S. Department of Interior, U.S. Department of Justice, Department of State, U.S. Department of Transportation, National Aeronautics and Space Administration, National Endowment for the Humanities, National Science Foundation, U.S. Department of Veterans Affairs, U.S. Department of Energy, U.S. Department of Education, and U.S. Department of Health and Human Services Federal Award Numbers ? As listed on the Schedule of Expenditures of Federal Awards Grant Award Periods ? Various Compliance Requirement ? Equipment/Real Property Management Criteria: As set forth in 2 CFR 200.313(d)(1), property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the FAIN), who holds title, the acquisition date, cost of the property, percentage of Federal participation in the project costs for the Federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sale price of the property. Additionally, 2 CFR 200.303 requires nonfederal entities to, among other things, 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. Conditions Found: While performing audit procedures related to the accuracy and completeness of property records and physical inspection of the existence and safeguarding of fifty-seven equipment items (with a net book value of 628,232), the following conditions were identified: ? During our physical inspection procedures, which took several attempts, we noted thirty-five equipment items sampled (with a net book value of $583,715) that were not found at the location stated within the fiscal year 2022 property records maintained by the University for the following items: See Schedule of Findings and Questioned Costs for chart/table The property records for ten equipment items sampled (with a net book value of $327,266) did not have accurate property records (note some of these same equipment items were also not found at the location stated and were also included in the table above). Specifically, the serial number on the equipment item sampled was not documented in the fiscal year 2022 property records maintained by the University for the following items: See Schedule of Findings and Questioned Costs for chart/table ? The property records for two equipment items (with $0 net book value) sampled were not updated to reflect disposals made during fiscal year 2022. Management stated no proceeds were received for the following items: See Schedule of Findings and Questioned Costs for chart/table The University did not have an effective system of internal control in place to ensure property records accurately reflect equipment locations, equipment serial numbers, and disposals. As of June 30, 2022, the University was responsible for maintaining and safeguarding equipment purchased using federal awards with a net book value of $2,110,646. Questioned Cost: There are no questioned costs. Cause and Effect: In discussing these conditions with University management, they stated that inadequate documentation of policies and procedures regarding the types of conditions that require communication to the Business and Finance office (e.g., when equipment is moved to a different location), as well as a lack of a review of changes made to property records by someone other than the preparer, contributed to multiple errors in the property records. Repeat Finding: A similar finding was reported in prior year audit as finding number 2021 003. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendations: We recommend the University strengthen policies, procedures and internal controls to ensure requirements around equipment/real property management are met. We recommend the University perform a detailed review of the property records and make corrections to accurately reflect the required information. We also recommend the University take a fresh look at their capital equipment recordkeeping policies and procedures and consider both preventive and detective internal controls to ensure property records accurately reflect the requirements of 2 CFR 200.313(d)(1).
Finding 2022 003 Federal Program Title ? Research & Development Cluster Assistance Listing No. ? As listed on the Schedule of Expenditures of Federal Awards Federal Agencies ? U.S. Department of Agriculture, U.S. Department of Commerce, U.S. Department of Defense, U.S. Department of Interior, U.S. Department of Justice, Department of State, U.S. Department of Transportation, National Aeronautics and Space Administration, National Endowment for the Humanities, National Science Foundation, U.S. Department of Veterans Affairs, U.S. Department of Energy, U.S. Department of Education, and U.S. Department of Health and Human Services Federal Award Numbers ? As listed on the Schedule of Expenditures of Federal Awards Grant Award Periods ? Various Compliance Requirement ? Equipment/Real Property Management Criteria: As set forth in 2 CFR 200.313(d)(1), property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the FAIN), who holds title, the acquisition date, cost of the property, percentage of Federal participation in the project costs for the Federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sale price of the property. Additionally, 2 CFR 200.303 requires nonfederal entities to, among other things, 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. Conditions Found: While performing audit procedures related to the accuracy and completeness of property records and physical inspection of the existence and safeguarding of fifty-seven equipment items (with a net book value of 628,232), the following conditions were identified: ? During our physical inspection procedures, which took several attempts, we noted thirty-five equipment items sampled (with a net book value of $583,715) that were not found at the location stated within the fiscal year 2022 property records maintained by the University for the following items: See Schedule of Findings and Questioned Costs for chart/table The property records for ten equipment items sampled (with a net book value of $327,266) did not have accurate property records (note some of these same equipment items were also not found at the location stated and were also included in the table above). Specifically, the serial number on the equipment item sampled was not documented in the fiscal year 2022 property records maintained by the University for the following items: See Schedule of Findings and Questioned Costs for chart/table ? The property records for two equipment items (with $0 net book value) sampled were not updated to reflect disposals made during fiscal year 2022. Management stated no proceeds were received for the following items: See Schedule of Findings and Questioned Costs for chart/table The University did not have an effective system of internal control in place to ensure property records accurately reflect equipment locations, equipment serial numbers, and disposals. As of June 30, 2022, the University was responsible for maintaining and safeguarding equipment purchased using federal awards with a net book value of $2,110,646. Questioned Cost: There are no questioned costs. Cause and Effect: In discussing these conditions with University management, they stated that inadequate documentation of policies and procedures regarding the types of conditions that require communication to the Business and Finance office (e.g., when equipment is moved to a different location), as well as a lack of a review of changes made to property records by someone other than the preparer, contributed to multiple errors in the property records. Repeat Finding: A similar finding was reported in prior year audit as finding number 2021 003. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendations: We recommend the University strengthen policies, procedures and internal controls to ensure requirements around equipment/real property management are met. We recommend the University perform a detailed review of the property records and make corrections to accurately reflect the required information. We also recommend the University take a fresh look at their capital equipment recordkeeping policies and procedures and consider both preventive and detective internal controls to ensure property records accurately reflect the requirements of 2 CFR 200.313(d)(1).
Finding 2022 003 Federal Program Title ? Research & Development Cluster Assistance Listing No. ? As listed on the Schedule of Expenditures of Federal Awards Federal Agencies ? U.S. Department of Agriculture, U.S. Department of Commerce, U.S. Department of Defense, U.S. Department of Interior, U.S. Department of Justice, Department of State, U.S. Department of Transportation, National Aeronautics and Space Administration, National Endowment for the Humanities, National Science Foundation, U.S. Department of Veterans Affairs, U.S. Department of Energy, U.S. Department of Education, and U.S. Department of Health and Human Services Federal Award Numbers ? As listed on the Schedule of Expenditures of Federal Awards Grant Award Periods ? Various Compliance Requirement ? Equipment/Real Property Management Criteria: As set forth in 2 CFR 200.313(d)(1), property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the FAIN), who holds title, the acquisition date, cost of the property, percentage of Federal participation in the project costs for the Federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sale price of the property. Additionally, 2 CFR 200.303 requires nonfederal entities to, among other things, 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. Conditions Found: While performing audit procedures related to the accuracy and completeness of property records and physical inspection of the existence and safeguarding of fifty-seven equipment items (with a net book value of 628,232), the following conditions were identified: ? During our physical inspection procedures, which took several attempts, we noted thirty-five equipment items sampled (with a net book value of $583,715) that were not found at the location stated within the fiscal year 2022 property records maintained by the University for the following items: See Schedule of Findings and Questioned Costs for chart/table The property records for ten equipment items sampled (with a net book value of $327,266) did not have accurate property records (note some of these same equipment items were also not found at the location stated and were also included in the table above). Specifically, the serial number on the equipment item sampled was not documented in the fiscal year 2022 property records maintained by the University for the following items: See Schedule of Findings and Questioned Costs for chart/table ? The property records for two equipment items (with $0 net book value) sampled were not updated to reflect disposals made during fiscal year 2022. Management stated no proceeds were received for the following items: See Schedule of Findings and Questioned Costs for chart/table The University did not have an effective system of internal control in place to ensure property records accurately reflect equipment locations, equipment serial numbers, and disposals. As of June 30, 2022, the University was responsible for maintaining and safeguarding equipment purchased using federal awards with a net book value of $2,110,646. Questioned Cost: There are no questioned costs. Cause and Effect: In discussing these conditions with University management, they stated that inadequate documentation of policies and procedures regarding the types of conditions that require communication to the Business and Finance office (e.g., when equipment is moved to a different location), as well as a lack of a review of changes made to property records by someone other than the preparer, contributed to multiple errors in the property records. Repeat Finding: A similar finding was reported in prior year audit as finding number 2021 003. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendations: We recommend the University strengthen policies, procedures and internal controls to ensure requirements around equipment/real property management are met. We recommend the University perform a detailed review of the property records and make corrections to accurately reflect the required information. We also recommend the University take a fresh look at their capital equipment recordkeeping policies and procedures and consider both preventive and detective internal controls to ensure property records accurately reflect the requirements of 2 CFR 200.313(d)(1).
Finding 2022 003 Federal Program Title ? Research & Development Cluster Assistance Listing No. ? As listed on the Schedule of Expenditures of Federal Awards Federal Agencies ? U.S. Department of Agriculture, U.S. Department of Commerce, U.S. Department of Defense, U.S. Department of Interior, U.S. Department of Justice, Department of State, U.S. Department of Transportation, National Aeronautics and Space Administration, National Endowment for the Humanities, National Science Foundation, U.S. Department of Veterans Affairs, U.S. Department of Energy, U.S. Department of Education, and U.S. Department of Health and Human Services Federal Award Numbers ? As listed on the Schedule of Expenditures of Federal Awards Grant Award Periods ? Various Compliance Requirement ? Equipment/Real Property Management Criteria: As set forth in 2 CFR 200.313(d)(1), property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the FAIN), who holds title, the acquisition date, cost of the property, percentage of Federal participation in the project costs for the Federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sale price of the property. Additionally, 2 CFR 200.303 requires nonfederal entities to, among other things, 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. Conditions Found: While performing audit procedures related to the accuracy and completeness of property records and physical inspection of the existence and safeguarding of fifty-seven equipment items (with a net book value of 628,232), the following conditions were identified: ? During our physical inspection procedures, which took several attempts, we noted thirty-five equipment items sampled (with a net book value of $583,715) that were not found at the location stated within the fiscal year 2022 property records maintained by the University for the following items: See Schedule of Findings and Questioned Costs for chart/table The property records for ten equipment items sampled (with a net book value of $327,266) did not have accurate property records (note some of these same equipment items were also not found at the location stated and were also included in the table above). Specifically, the serial number on the equipment item sampled was not documented in the fiscal year 2022 property records maintained by the University for the following items: See Schedule of Findings and Questioned Costs for chart/table ? The property records for two equipment items (with $0 net book value) sampled were not updated to reflect disposals made during fiscal year 2022. Management stated no proceeds were received for the following items: See Schedule of Findings and Questioned Costs for chart/table The University did not have an effective system of internal control in place to ensure property records accurately reflect equipment locations, equipment serial numbers, and disposals. As of June 30, 2022, the University was responsible for maintaining and safeguarding equipment purchased using federal awards with a net book value of $2,110,646. Questioned Cost: There are no questioned costs. Cause and Effect: In discussing these conditions with University management, they stated that inadequate documentation of policies and procedures regarding the types of conditions that require communication to the Business and Finance office (e.g., when equipment is moved to a different location), as well as a lack of a review of changes made to property records by someone other than the preparer, contributed to multiple errors in the property records. Repeat Finding: A similar finding was reported in prior year audit as finding number 2021 003. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendations: We recommend the University strengthen policies, procedures and internal controls to ensure requirements around equipment/real property management are met. We recommend the University perform a detailed review of the property records and make corrections to accurately reflect the required information. We also recommend the University take a fresh look at their capital equipment recordkeeping policies and procedures and consider both preventive and detective internal controls to ensure property records accurately reflect the requirements of 2 CFR 200.313(d)(1).
Finding 2022 003 Federal Program Title ? Research & Development Cluster Assistance Listing No. ? As listed on the Schedule of Expenditures of Federal Awards Federal Agencies ? U.S. Department of Agriculture, U.S. Department of Commerce, U.S. Department of Defense, U.S. Department of Interior, U.S. Department of Justice, Department of State, U.S. Department of Transportation, National Aeronautics and Space Administration, National Endowment for the Humanities, National Science Foundation, U.S. Department of Veterans Affairs, U.S. Department of Energy, U.S. Department of Education, and U.S. Department of Health and Human Services Federal Award Numbers ? As listed on the Schedule of Expenditures of Federal Awards Grant Award Periods ? Various Compliance Requirement ? Equipment/Real Property Management Criteria: As set forth in 2 CFR 200.313(d)(1), property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the FAIN), who holds title, the acquisition date, cost of the property, percentage of Federal participation in the project costs for the Federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sale price of the property. Additionally, 2 CFR 200.303 requires nonfederal entities to, among other things, 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. Conditions Found: While performing audit procedures related to the accuracy and completeness of property records and physical inspection of the existence and safeguarding of fifty-seven equipment items (with a net book value of 628,232), the following conditions were identified: ? During our physical inspection procedures, which took several attempts, we noted thirty-five equipment items sampled (with a net book value of $583,715) that were not found at the location stated within the fiscal year 2022 property records maintained by the University for the following items: See Schedule of Findings and Questioned Costs for chart/table The property records for ten equipment items sampled (with a net book value of $327,266) did not have accurate property records (note some of these same equipment items were also not found at the location stated and were also included in the table above). Specifically, the serial number on the equipment item sampled was not documented in the fiscal year 2022 property records maintained by the University for the following items: See Schedule of Findings and Questioned Costs for chart/table ? The property records for two equipment items (with $0 net book value) sampled were not updated to reflect disposals made during fiscal year 2022. Management stated no proceeds were received for the following items: See Schedule of Findings and Questioned Costs for chart/table The University did not have an effective system of internal control in place to ensure property records accurately reflect equipment locations, equipment serial numbers, and disposals. As of June 30, 2022, the University was responsible for maintaining and safeguarding equipment purchased using federal awards with a net book value of $2,110,646. Questioned Cost: There are no questioned costs. Cause and Effect: In discussing these conditions with University management, they stated that inadequate documentation of policies and procedures regarding the types of conditions that require communication to the Business and Finance office (e.g., when equipment is moved to a different location), as well as a lack of a review of changes made to property records by someone other than the preparer, contributed to multiple errors in the property records. Repeat Finding: A similar finding was reported in prior year audit as finding number 2021 003. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendations: We recommend the University strengthen policies, procedures and internal controls to ensure requirements around equipment/real property management are met. We recommend the University perform a detailed review of the property records and make corrections to accurately reflect the required information. We also recommend the University take a fresh look at their capital equipment recordkeeping policies and procedures and consider both preventive and detective internal controls to ensure property records accurately reflect the requirements of 2 CFR 200.313(d)(1).
Finding 2022 003 Federal Program Title ? Research & Development Cluster Assistance Listing No. ? As listed on the Schedule of Expenditures of Federal Awards Federal Agencies ? U.S. Department of Agriculture, U.S. Department of Commerce, U.S. Department of Defense, U.S. Department of Interior, U.S. Department of Justice, Department of State, U.S. Department of Transportation, National Aeronautics and Space Administration, National Endowment for the Humanities, National Science Foundation, U.S. Department of Veterans Affairs, U.S. Department of Energy, U.S. Department of Education, and U.S. Department of Health and Human Services Federal Award Numbers ? As listed on the Schedule of Expenditures of Federal Awards Grant Award Periods ? Various Compliance Requirement ? Equipment/Real Property Management Criteria: As set forth in 2 CFR 200.313(d)(1), property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the FAIN), who holds title, the acquisition date, cost of the property, percentage of Federal participation in the project costs for the Federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sale price of the property. Additionally, 2 CFR 200.303 requires nonfederal entities to, among other things, 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. Conditions Found: While performing audit procedures related to the accuracy and completeness of property records and physical inspection of the existence and safeguarding of fifty-seven equipment items (with a net book value of 628,232), the following conditions were identified: ? During our physical inspection procedures, which took several attempts, we noted thirty-five equipment items sampled (with a net book value of $583,715) that were not found at the location stated within the fiscal year 2022 property records maintained by the University for the following items: See Schedule of Findings and Questioned Costs for chart/table The property records for ten equipment items sampled (with a net book value of $327,266) did not have accurate property records (note some of these same equipment items were also not found at the location stated and were also included in the table above). Specifically, the serial number on the equipment item sampled was not documented in the fiscal year 2022 property records maintained by the University for the following items: See Schedule of Findings and Questioned Costs for chart/table ? The property records for two equipment items (with $0 net book value) sampled were not updated to reflect disposals made during fiscal year 2022. Management stated no proceeds were received for the following items: See Schedule of Findings and Questioned Costs for chart/table The University did not have an effective system of internal control in place to ensure property records accurately reflect equipment locations, equipment serial numbers, and disposals. As of June 30, 2022, the University was responsible for maintaining and safeguarding equipment purchased using federal awards with a net book value of $2,110,646. Questioned Cost: There are no questioned costs. Cause and Effect: In discussing these conditions with University management, they stated that inadequate documentation of policies and procedures regarding the types of conditions that require communication to the Business and Finance office (e.g., when equipment is moved to a different location), as well as a lack of a review of changes made to property records by someone other than the preparer, contributed to multiple errors in the property records. Repeat Finding: A similar finding was reported in prior year audit as finding number 2021 003. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendations: We recommend the University strengthen policies, procedures and internal controls to ensure requirements around equipment/real property management are met. We recommend the University perform a detailed review of the property records and make corrections to accurately reflect the required information. We also recommend the University take a fresh look at their capital equipment recordkeeping policies and procedures and consider both preventive and detective internal controls to ensure property records accurately reflect the requirements of 2 CFR 200.313(d)(1).
Finding 2022 003 Federal Program Title ? Research & Development Cluster Assistance Listing No. ? As listed on the Schedule of Expenditures of Federal Awards Federal Agencies ? U.S. Department of Agriculture, U.S. Department of Commerce, U.S. Department of Defense, U.S. Department of Interior, U.S. Department of Justice, Department of State, U.S. Department of Transportation, National Aeronautics and Space Administration, National Endowment for the Humanities, National Science Foundation, U.S. Department of Veterans Affairs, U.S. Department of Energy, U.S. Department of Education, and U.S. Department of Health and Human Services Federal Award Numbers ? As listed on the Schedule of Expenditures of Federal Awards Grant Award Periods ? Various Compliance Requirement ? Equipment/Real Property Management Criteria: As set forth in 2 CFR 200.313(d)(1), property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the FAIN), who holds title, the acquisition date, cost of the property, percentage of Federal participation in the project costs for the Federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sale price of the property. Additionally, 2 CFR 200.303 requires nonfederal entities to, among other things, 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. Conditions Found: While performing audit procedures related to the accuracy and completeness of property records and physical inspection of the existence and safeguarding of fifty-seven equipment items (with a net book value of 628,232), the following conditions were identified: ? During our physical inspection procedures, which took several attempts, we noted thirty-five equipment items sampled (with a net book value of $583,715) that were not found at the location stated within the fiscal year 2022 property records maintained by the University for the following items: See Schedule of Findings and Questioned Costs for chart/table The property records for ten equipment items sampled (with a net book value of $327,266) did not have accurate property records (note some of these same equipment items were also not found at the location stated and were also included in the table above). Specifically, the serial number on the equipment item sampled was not documented in the fiscal year 2022 property records maintained by the University for the following items: See Schedule of Findings and Questioned Costs for chart/table ? The property records for two equipment items (with $0 net book value) sampled were not updated to reflect disposals made during fiscal year 2022. Management stated no proceeds were received for the following items: See Schedule of Findings and Questioned Costs for chart/table The University did not have an effective system of internal control in place to ensure property records accurately reflect equipment locations, equipment serial numbers, and disposals. As of June 30, 2022, the University was responsible for maintaining and safeguarding equipment purchased using federal awards with a net book value of $2,110,646. Questioned Cost: There are no questioned costs. Cause and Effect: In discussing these conditions with University management, they stated that inadequate documentation of policies and procedures regarding the types of conditions that require communication to the Business and Finance office (e.g., when equipment is moved to a different location), as well as a lack of a review of changes made to property records by someone other than the preparer, contributed to multiple errors in the property records. Repeat Finding: A similar finding was reported in prior year audit as finding number 2021 003. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendations: We recommend the University strengthen policies, procedures and internal controls to ensure requirements around equipment/real property management are met. We recommend the University perform a detailed review of the property records and make corrections to accurately reflect the required information. We also recommend the University take a fresh look at their capital equipment recordkeeping policies and procedures and consider both preventive and detective internal controls to ensure property records accurately reflect the requirements of 2 CFR 200.313(d)(1).
Finding 2022 003 Federal Program Title ? Research & Development Cluster Assistance Listing No. ? As listed on the Schedule of Expenditures of Federal Awards Federal Agencies ? U.S. Department of Agriculture, U.S. Department of Commerce, U.S. Department of Defense, U.S. Department of Interior, U.S. Department of Justice, Department of State, U.S. Department of Transportation, National Aeronautics and Space Administration, National Endowment for the Humanities, National Science Foundation, U.S. Department of Veterans Affairs, U.S. Department of Energy, U.S. Department of Education, and U.S. Department of Health and Human Services Federal Award Numbers ? As listed on the Schedule of Expenditures of Federal Awards Grant Award Periods ? Various Compliance Requirement ? Equipment/Real Property Management Criteria: As set forth in 2 CFR 200.313(d)(1), property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the FAIN), who holds title, the acquisition date, cost of the property, percentage of Federal participation in the project costs for the Federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sale price of the property. Additionally, 2 CFR 200.303 requires nonfederal entities to, among other things, 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. Conditions Found: While performing audit procedures related to the accuracy and completeness of property records and physical inspection of the existence and safeguarding of fifty-seven equipment items (with a net book value of 628,232), the following conditions were identified: ? During our physical inspection procedures, which took several attempts, we noted thirty-five equipment items sampled (with a net book value of $583,715) that were not found at the location stated within the fiscal year 2022 property records maintained by the University for the following items: See Schedule of Findings and Questioned Costs for chart/table The property records for ten equipment items sampled (with a net book value of $327,266) did not have accurate property records (note some of these same equipment items were also not found at the location stated and were also included in the table above). Specifically, the serial number on the equipment item sampled was not documented in the fiscal year 2022 property records maintained by the University for the following items: See Schedule of Findings and Questioned Costs for chart/table ? The property records for two equipment items (with $0 net book value) sampled were not updated to reflect disposals made during fiscal year 2022. Management stated no proceeds were received for the following items: See Schedule of Findings and Questioned Costs for chart/table The University did not have an effective system of internal control in place to ensure property records accurately reflect equipment locations, equipment serial numbers, and disposals. As of June 30, 2022, the University was responsible for maintaining and safeguarding equipment purchased using federal awards with a net book value of $2,110,646. Questioned Cost: There are no questioned costs. Cause and Effect: In discussing these conditions with University management, they stated that inadequate documentation of policies and procedures regarding the types of conditions that require communication to the Business and Finance office (e.g., when equipment is moved to a different location), as well as a lack of a review of changes made to property records by someone other than the preparer, contributed to multiple errors in the property records. Repeat Finding: A similar finding was reported in prior year audit as finding number 2021 003. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendations: We recommend the University strengthen policies, procedures and internal controls to ensure requirements around equipment/real property management are met. We recommend the University perform a detailed review of the property records and make corrections to accurately reflect the required information. We also recommend the University take a fresh look at their capital equipment recordkeeping policies and procedures and consider both preventive and detective internal controls to ensure property records accurately reflect the requirements of 2 CFR 200.313(d)(1).
Finding 2022 003 Federal Program Title ? Research & Development Cluster Assistance Listing No. ? As listed on the Schedule of Expenditures of Federal Awards Federal Agencies ? U.S. Department of Agriculture, U.S. Department of Commerce, U.S. Department of Defense, U.S. Department of Interior, U.S. Department of Justice, Department of State, U.S. Department of Transportation, National Aeronautics and Space Administration, National Endowment for the Humanities, National Science Foundation, U.S. Department of Veterans Affairs, U.S. Department of Energy, U.S. Department of Education, and U.S. Department of Health and Human Services Federal Award Numbers ? As listed on the Schedule of Expenditures of Federal Awards Grant Award Periods ? Various Compliance Requirement ? Equipment/Real Property Management Criteria: As set forth in 2 CFR 200.313(d)(1), property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the FAIN), who holds title, the acquisition date, cost of the property, percentage of Federal participation in the project costs for the Federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sale price of the property. Additionally, 2 CFR 200.303 requires nonfederal entities to, among other things, 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. Conditions Found: While performing audit procedures related to the accuracy and completeness of property records and physical inspection of the existence and safeguarding of fifty-seven equipment items (with a net book value of 628,232), the following conditions were identified: ? During our physical inspection procedures, which took several attempts, we noted thirty-five equipment items sampled (with a net book value of $583,715) that were not found at the location stated within the fiscal year 2022 property records maintained by the University for the following items: See Schedule of Findings and Questioned Costs for chart/table The property records for ten equipment items sampled (with a net book value of $327,266) did not have accurate property records (note some of these same equipment items were also not found at the location stated and were also included in the table above). Specifically, the serial number on the equipment item sampled was not documented in the fiscal year 2022 property records maintained by the University for the following items: See Schedule of Findings and Questioned Costs for chart/table ? The property records for two equipment items (with $0 net book value) sampled were not updated to reflect disposals made during fiscal year 2022. Management stated no proceeds were received for the following items: See Schedule of Findings and Questioned Costs for chart/table The University did not have an effective system of internal control in place to ensure property records accurately reflect equipment locations, equipment serial numbers, and disposals. As of June 30, 2022, the University was responsible for maintaining and safeguarding equipment purchased using federal awards with a net book value of $2,110,646. Questioned Cost: There are no questioned costs. Cause and Effect: In discussing these conditions with University management, they stated that inadequate documentation of policies and procedures regarding the types of conditions that require communication to the Business and Finance office (e.g., when equipment is moved to a different location), as well as a lack of a review of changes made to property records by someone other than the preparer, contributed to multiple errors in the property records. Repeat Finding: A similar finding was reported in prior year audit as finding number 2021 003. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendations: We recommend the University strengthen policies, procedures and internal controls to ensure requirements around equipment/real property management are met. We recommend the University perform a detailed review of the property records and make corrections to accurately reflect the required information. We also recommend the University take a fresh look at their capital equipment recordkeeping policies and procedures and consider both preventive and detective internal controls to ensure property records accurately reflect the requirements of 2 CFR 200.313(d)(1).
Finding 2022 003 Federal Program Title ? Research & Development Cluster Assistance Listing No. ? As listed on the Schedule of Expenditures of Federal Awards Federal Agencies ? U.S. Department of Agriculture, U.S. Department of Commerce, U.S. Department of Defense, U.S. Department of Interior, U.S. Department of Justice, Department of State, U.S. Department of Transportation, National Aeronautics and Space Administration, National Endowment for the Humanities, National Science Foundation, U.S. Department of Veterans Affairs, U.S. Department of Energy, U.S. Department of Education, and U.S. Department of Health and Human Services Federal Award Numbers ? As listed on the Schedule of Expenditures of Federal Awards Grant Award Periods ? Various Compliance Requirement ? Equipment/Real Property Management Criteria: As set forth in 2 CFR 200.313(d)(1), property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the FAIN), who holds title, the acquisition date, cost of the property, percentage of Federal participation in the project costs for the Federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sale price of the property. Additionally, 2 CFR 200.303 requires nonfederal entities to, among other things, 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. Conditions Found: While performing audit procedures related to the accuracy and completeness of property records and physical inspection of the existence and safeguarding of fifty-seven equipment items (with a net book value of 628,232), the following conditions were identified: ? During our physical inspection procedures, which took several attempts, we noted thirty-five equipment items sampled (with a net book value of $583,715) that were not found at the location stated within the fiscal year 2022 property records maintained by the University for the following items: See Schedule of Findings and Questioned Costs for chart/table The property records for ten equipment items sampled (with a net book value of $327,266) did not have accurate property records (note some of these same equipment items were also not found at the location stated and were also included in the table above). Specifically, the serial number on the equipment item sampled was not documented in the fiscal year 2022 property records maintained by the University for the following items: See Schedule of Findings and Questioned Costs for chart/table ? The property records for two equipment items (with $0 net book value) sampled were not updated to reflect disposals made during fiscal year 2022. Management stated no proceeds were received for the following items: See Schedule of Findings and Questioned Costs for chart/table The University did not have an effective system of internal control in place to ensure property records accurately reflect equipment locations, equipment serial numbers, and disposals. As of June 30, 2022, the University was responsible for maintaining and safeguarding equipment purchased using federal awards with a net book value of $2,110,646. Questioned Cost: There are no questioned costs. Cause and Effect: In discussing these conditions with University management, they stated that inadequate documentation of policies and procedures regarding the types of conditions that require communication to the Business and Finance office (e.g., when equipment is moved to a different location), as well as a lack of a review of changes made to property records by someone other than the preparer, contributed to multiple errors in the property records. Repeat Finding: A similar finding was reported in prior year audit as finding number 2021 003. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendations: We recommend the University strengthen policies, procedures and internal controls to ensure requirements around equipment/real property management are met. We recommend the University perform a detailed review of the property records and make corrections to accurately reflect the required information. We also recommend the University take a fresh look at their capital equipment recordkeeping policies and procedures and consider both preventive and detective internal controls to ensure property records accurately reflect the requirements of 2 CFR 200.313(d)(1).
Finding 2022 003 Federal Program Title ? Research & Development Cluster Assistance Listing No. ? As listed on the Schedule of Expenditures of Federal Awards Federal Agencies ? U.S. Department of Agriculture, U.S. Department of Commerce, U.S. Department of Defense, U.S. Department of Interior, U.S. Department of Justice, Department of State, U.S. Department of Transportation, National Aeronautics and Space Administration, National Endowment for the Humanities, National Science Foundation, U.S. Department of Veterans Affairs, U.S. Department of Energy, U.S. Department of Education, and U.S. Department of Health and Human Services Federal Award Numbers ? As listed on the Schedule of Expenditures of Federal Awards Grant Award Periods ? Various Compliance Requirement ? Equipment/Real Property Management Criteria: As set forth in 2 CFR 200.313(d)(1), property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the FAIN), who holds title, the acquisition date, cost of the property, percentage of Federal participation in the project costs for the Federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sale price of the property. Additionally, 2 CFR 200.303 requires nonfederal entities to, among other things, 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. Conditions Found: While performing audit procedures related to the accuracy and completeness of property records and physical inspection of the existence and safeguarding of fifty-seven equipment items (with a net book value of 628,232), the following conditions were identified: ? During our physical inspection procedures, which took several attempts, we noted thirty-five equipment items sampled (with a net book value of $583,715) that were not found at the location stated within the fiscal year 2022 property records maintained by the University for the following items: See Schedule of Findings and Questioned Costs for chart/table The property records for ten equipment items sampled (with a net book value of $327,266) did not have accurate property records (note some of these same equipment items were also not found at the location stated and were also included in the table above). Specifically, the serial number on the equipment item sampled was not documented in the fiscal year 2022 property records maintained by the University for the following items: See Schedule of Findings and Questioned Costs for chart/table ? The property records for two equipment items (with $0 net book value) sampled were not updated to reflect disposals made during fiscal year 2022. Management stated no proceeds were received for the following items: See Schedule of Findings and Questioned Costs for chart/table The University did not have an effective system of internal control in place to ensure property records accurately reflect equipment locations, equipment serial numbers, and disposals. As of June 30, 2022, the University was responsible for maintaining and safeguarding equipment purchased using federal awards with a net book value of $2,110,646. Questioned Cost: There are no questioned costs. Cause and Effect: In discussing these conditions with University management, they stated that inadequate documentation of policies and procedures regarding the types of conditions that require communication to the Business and Finance office (e.g., when equipment is moved to a different location), as well as a lack of a review of changes made to property records by someone other than the preparer, contributed to multiple errors in the property records. Repeat Finding: A similar finding was reported in prior year audit as finding number 2021 003. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendations: We recommend the University strengthen policies, procedures and internal controls to ensure requirements around equipment/real property management are met. We recommend the University perform a detailed review of the property records and make corrections to accurately reflect the required information. We also recommend the University take a fresh look at their capital equipment recordkeeping policies and procedures and consider both preventive and detective internal controls to ensure property records accurately reflect the requirements of 2 CFR 200.313(d)(1).
Finding 2022 003 Federal Program Title ? Research & Development Cluster Assistance Listing No. ? As listed on the Schedule of Expenditures of Federal Awards Federal Agencies ? U.S. Department of Agriculture, U.S. Department of Commerce, U.S. Department of Defense, U.S. Department of Interior, U.S. Department of Justice, Department of State, U.S. Department of Transportation, National Aeronautics and Space Administration, National Endowment for the Humanities, National Science Foundation, U.S. Department of Veterans Affairs, U.S. Department of Energy, U.S. Department of Education, and U.S. Department of Health and Human Services Federal Award Numbers ? As listed on the Schedule of Expenditures of Federal Awards Grant Award Periods ? Various Compliance Requirement ? Equipment/Real Property Management Criteria: As set forth in 2 CFR 200.313(d)(1), property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the FAIN), who holds title, the acquisition date, cost of the property, percentage of Federal participation in the project costs for the Federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sale price of the property. Additionally, 2 CFR 200.303 requires nonfederal entities to, among other things, 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. Conditions Found: While performing audit procedures related to the accuracy and completeness of property records and physical inspection of the existence and safeguarding of fifty-seven equipment items (with a net book value of 628,232), the following conditions were identified: ? During our physical inspection procedures, which took several attempts, we noted thirty-five equipment items sampled (with a net book value of $583,715) that were not found at the location stated within the fiscal year 2022 property records maintained by the University for the following items: See Schedule of Findings and Questioned Costs for chart/table The property records for ten equipment items sampled (with a net book value of $327,266) did not have accurate property records (note some of these same equipment items were also not found at the location stated and were also included in the table above). Specifically, the serial number on the equipment item sampled was not documented in the fiscal year 2022 property records maintained by the University for the following items: See Schedule of Findings and Questioned Costs for chart/table ? The property records for two equipment items (with $0 net book value) sampled were not updated to reflect disposals made during fiscal year 2022. Management stated no proceeds were received for the following items: See Schedule of Findings and Questioned Costs for chart/table The University did not have an effective system of internal control in place to ensure property records accurately reflect equipment locations, equipment serial numbers, and disposals. As of June 30, 2022, the University was responsible for maintaining and safeguarding equipment purchased using federal awards with a net book value of $2,110,646. Questioned Cost: There are no questioned costs. Cause and Effect: In discussing these conditions with University management, they stated that inadequate documentation of policies and procedures regarding the types of conditions that require communication to the Business and Finance office (e.g., when equipment is moved to a different location), as well as a lack of a review of changes made to property records by someone other than the preparer, contributed to multiple errors in the property records. Repeat Finding: A similar finding was reported in prior year audit as finding number 2021 003. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendations: We recommend the University strengthen policies, procedures and internal controls to ensure requirements around equipment/real property management are met. We recommend the University perform a detailed review of the property records and make corrections to accurately reflect the required information. We also recommend the University take a fresh look at their capital equipment recordkeeping policies and procedures and consider both preventive and detective internal controls to ensure property records accurately reflect the requirements of 2 CFR 200.313(d)(1).