2 CFR section 200.313(d)(1) states, in part, that property records must be maintained for equipment and real property purchases using federal funds. The property records should include, but are not limited to, 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), and any ultimate disposition data including the date of disposal and sales price of the property. Testing over the District's Elementary and Secondary School Emergency Relief funds (ESSER) purchases identified purchases totaling $74,774, that were not recorded on the Fixed Asset Detail Report. This is the result of the District not reviewing their policies and the Fixed Asset Detail Report. Failure to ensure equipment purchases are included on the District's inventory listing could result in a misappropriation of the equipment and a possible future loss of funding. To effectively control equipment and to maintain accountability over expenditures, the District should review its policy and ensure all equipment is properly identified and recorded on their Fixed Asset Detail Report.
2 CFR section 200.313(d)(1) states, in part, that property records must be maintained for equipment and real property purchases using federal funds. The property records should include, but are not limited to, 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), and any ultimate disposition data including the date of disposal and sales price of the property. Testing over the District's Elementary and Secondary School Emergency Relief funds (ESSER) purchases identified purchases totaling $74,774, that were not recorded on the Fixed Asset Detail Report. This is the result of the District not reviewing their policies and the Fixed Asset Detail Report. Failure to ensure equipment purchases are included on the District's inventory listing could result in a misappropriation of the equipment and a possible future loss of funding. To effectively control equipment and to maintain accountability over expenditures, the District should review its policy and ensure all equipment is properly identified and recorded on their Fixed Asset Detail Report.
FINDING 2022-001 Subject: COVID-19 - Education Stabilization Fund - Equipment and Real Property Management Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Equipment and Real Property Management Audit Findings: Material Weakness, Modified Opinion Condition and Context An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the Equipment and Real Property Management compliance requirement. The School Corporation paid $173,134 for the purchase of capital assets with federal awards from the COVID-19 - Education Stabilization Fund. These assets included several wrestling mats, two dishwashers, the installation of HVAC systems with scrubbers, a building audio upgrade, and outdoor playground equipment. These assets were not added to a detailed listing of capital assets that would 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 (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, and the use and condition of the property. In addition, a physical inventory had not been taken in the past two years. Assets were not properly safeguarded and maintained. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.313(d) states in part: "Management requirements. 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 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. (2) A physical inventory of the property must be taken and the results reconciled with the property records at least once every two 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 . . . ." Cause Management had not developed nor implemented a system of internal controls that would have ensured compliance with the grant agreement and the Equipment and Real Property Management compliance requirement. Effect The failure to establish an effective internal controls system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Equipment and Real Property Management compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish a system of internal controls related to the grant agreement and the Equipment and Real Property Management compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-001 Subject: COVID-19 - Education Stabilization Fund - Equipment and Real Property Management Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Equipment and Real Property Management Audit Findings: Material Weakness, Modified Opinion Condition and Context An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the Equipment and Real Property Management compliance requirement. The School Corporation paid $173,134 for the purchase of capital assets with federal awards from the COVID-19 - Education Stabilization Fund. These assets included several wrestling mats, two dishwashers, the installation of HVAC systems with scrubbers, a building audio upgrade, and outdoor playground equipment. These assets were not added to a detailed listing of capital assets that would 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 (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, and the use and condition of the property. In addition, a physical inventory had not been taken in the past two years. Assets were not properly safeguarded and maintained. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.313(d) states in part: "Management requirements. 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 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. (2) A physical inventory of the property must be taken and the results reconciled with the property records at least once every two 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 . . . ." Cause Management had not developed nor implemented a system of internal controls that would have ensured compliance with the grant agreement and the Equipment and Real Property Management compliance requirement. Effect The failure to establish an effective internal controls system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Equipment and Real Property Management compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish a system of internal controls related to the grant agreement and the Equipment and Real Property Management compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-001 Subject: COVID-19 - Education Stabilization Fund - Equipment and Real Property Management Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Equipment and Real Property Management Audit Findings: Material Weakness, Modified Opinion Condition and Context An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the Equipment and Real Property Management compliance requirement. The School Corporation paid $173,134 for the purchase of capital assets with federal awards from the COVID-19 - Education Stabilization Fund. These assets included several wrestling mats, two dishwashers, the installation of HVAC systems with scrubbers, a building audio upgrade, and outdoor playground equipment. These assets were not added to a detailed listing of capital assets that would 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 (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, and the use and condition of the property. In addition, a physical inventory had not been taken in the past two years. Assets were not properly safeguarded and maintained. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.313(d) states in part: "Management requirements. 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 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. (2) A physical inventory of the property must be taken and the results reconciled with the property records at least once every two 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 . . . ." Cause Management had not developed nor implemented a system of internal controls that would have ensured compliance with the grant agreement and the Equipment and Real Property Management compliance requirement. Effect The failure to establish an effective internal controls system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Equipment and Real Property Management compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish a system of internal controls related to the grant agreement and the Equipment and Real Property Management compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-002 ? EQUIPMENT AND REAL PROPERTY MANAGEMENT (Repeat Finding of 2021-002) Significant Deficiency Federal Programs: Charter Schools ? AL 84.282; Education Stabilization Fund ? AL 84.425 Criteria 2 CFR 200.313(d) contains equipment management requirements which dictate property records entities must maintain and the need for procedures to adequately safeguard and maintain assets acquired with federal funding. Condition The Organization did not retain in their accounting records all the required information. Specifically, the federal award identification number, holder of the title, use, and condition were not listed. The federal participation was assumed based on allocations between fund codes in the general ledger. Additionally, sufficient and appropriate documentation did not exist to support a physical inventory had been completed for all assets once in the last two years. Cause and Effect As described in 2022-001, the Organization has not established a formal process related to federal awards to identify all key compliance requirements and changes in compliance requirements, evaluate risks of noncompliance with these requirements, and respond to such risks of noncompliance through establishing or changing processes and internal controls. Additionally, certain individuals, within a department, responsible for the use of federal funds or maintenance and safeguard of assets acquired with federal funds lacked knowledge of the compliance requirements pertaining to the use of the funds or the maintenance and safeguard of the acquired assets. As a result, adequate documentation was not maintained for equipment acquired with federal funds or to support the performance of a physical inventory occurring within the required time period. Recommendation We recommend the Organization develop a system of internal controls aligned with the applicable compliance requirements to properly track equipment acquisitions in the accounting records and to ensure a physical inventory is appropriately documented when completed. Views of Responsible Officials and Planned Corrective Actions The Organization?s Corrective Action Plan is included on pages 38 and 39.
FINDING 2022-002 ? EQUIPMENT AND REAL PROPERTY MANAGEMENT (Repeat Finding of 2021-002) Significant Deficiency Federal Programs: Charter Schools ? AL 84.282; Education Stabilization Fund ? AL 84.425 Criteria 2 CFR 200.313(d) contains equipment management requirements which dictate property records entities must maintain and the need for procedures to adequately safeguard and maintain assets acquired with federal funding. Condition The Organization did not retain in their accounting records all the required information. Specifically, the federal award identification number, holder of the title, use, and condition were not listed. The federal participation was assumed based on allocations between fund codes in the general ledger. Additionally, sufficient and appropriate documentation did not exist to support a physical inventory had been completed for all assets once in the last two years. Cause and Effect As described in 2022-001, the Organization has not established a formal process related to federal awards to identify all key compliance requirements and changes in compliance requirements, evaluate risks of noncompliance with these requirements, and respond to such risks of noncompliance through establishing or changing processes and internal controls. Additionally, certain individuals, within a department, responsible for the use of federal funds or maintenance and safeguard of assets acquired with federal funds lacked knowledge of the compliance requirements pertaining to the use of the funds or the maintenance and safeguard of the acquired assets. As a result, adequate documentation was not maintained for equipment acquired with federal funds or to support the performance of a physical inventory occurring within the required time period. Recommendation We recommend the Organization develop a system of internal controls aligned with the applicable compliance requirements to properly track equipment acquisitions in the accounting records and to ensure a physical inventory is appropriately documented when completed. Views of Responsible Officials and Planned Corrective Actions The Organization?s Corrective Action Plan is included on pages 38 and 39.
FINDING 2022-002 ? EQUIPMENT AND REAL PROPERTY MANAGEMENT (Repeat Finding of 2021-002) Significant Deficiency Federal Programs: Charter Schools ? AL 84.282; Education Stabilization Fund ? AL 84.425 Criteria 2 CFR 200.313(d) contains equipment management requirements which dictate property records entities must maintain and the need for procedures to adequately safeguard and maintain assets acquired with federal funding. Condition The Organization did not retain in their accounting records all the required information. Specifically, the federal award identification number, holder of the title, use, and condition were not listed. The federal participation was assumed based on allocations between fund codes in the general ledger. Additionally, sufficient and appropriate documentation did not exist to support a physical inventory had been completed for all assets once in the last two years. Cause and Effect As described in 2022-001, the Organization has not established a formal process related to federal awards to identify all key compliance requirements and changes in compliance requirements, evaluate risks of noncompliance with these requirements, and respond to such risks of noncompliance through establishing or changing processes and internal controls. Additionally, certain individuals, within a department, responsible for the use of federal funds or maintenance and safeguard of assets acquired with federal funds lacked knowledge of the compliance requirements pertaining to the use of the funds or the maintenance and safeguard of the acquired assets. As a result, adequate documentation was not maintained for equipment acquired with federal funds or to support the performance of a physical inventory occurring within the required time period. Recommendation We recommend the Organization develop a system of internal controls aligned with the applicable compliance requirements to properly track equipment acquisitions in the accounting records and to ensure a physical inventory is appropriately documented when completed. Views of Responsible Officials and Planned Corrective Actions The Organization?s Corrective Action Plan is included on pages 38 and 39.
FINDING 2022-002 ? EQUIPMENT AND REAL PROPERTY MANAGEMENT (Repeat Finding of 2021-002) Significant Deficiency Federal Programs: Charter Schools ? AL 84.282; Education Stabilization Fund ? AL 84.425 Criteria 2 CFR 200.313(d) contains equipment management requirements which dictate property records entities must maintain and the need for procedures to adequately safeguard and maintain assets acquired with federal funding. Condition The Organization did not retain in their accounting records all the required information. Specifically, the federal award identification number, holder of the title, use, and condition were not listed. The federal participation was assumed based on allocations between fund codes in the general ledger. Additionally, sufficient and appropriate documentation did not exist to support a physical inventory had been completed for all assets once in the last two years. Cause and Effect As described in 2022-001, the Organization has not established a formal process related to federal awards to identify all key compliance requirements and changes in compliance requirements, evaluate risks of noncompliance with these requirements, and respond to such risks of noncompliance through establishing or changing processes and internal controls. Additionally, certain individuals, within a department, responsible for the use of federal funds or maintenance and safeguard of assets acquired with federal funds lacked knowledge of the compliance requirements pertaining to the use of the funds or the maintenance and safeguard of the acquired assets. As a result, adequate documentation was not maintained for equipment acquired with federal funds or to support the performance of a physical inventory occurring within the required time period. Recommendation We recommend the Organization develop a system of internal controls aligned with the applicable compliance requirements to properly track equipment acquisitions in the accounting records and to ensure a physical inventory is appropriately documented when completed. Views of Responsible Officials and Planned Corrective Actions The Organization?s Corrective Action Plan is included on pages 38 and 39.
FINDING 2022-002 ? EQUIPMENT AND REAL PROPERTY MANAGEMENT (Repeat Finding of 2021-002) Significant Deficiency Federal Programs: Charter Schools ? AL 84.282; Education Stabilization Fund ? AL 84.425 Criteria 2 CFR 200.313(d) contains equipment management requirements which dictate property records entities must maintain and the need for procedures to adequately safeguard and maintain assets acquired with federal funding. Condition The Organization did not retain in their accounting records all the required information. Specifically, the federal award identification number, holder of the title, use, and condition were not listed. The federal participation was assumed based on allocations between fund codes in the general ledger. Additionally, sufficient and appropriate documentation did not exist to support a physical inventory had been completed for all assets once in the last two years. Cause and Effect As described in 2022-001, the Organization has not established a formal process related to federal awards to identify all key compliance requirements and changes in compliance requirements, evaluate risks of noncompliance with these requirements, and respond to such risks of noncompliance through establishing or changing processes and internal controls. Additionally, certain individuals, within a department, responsible for the use of federal funds or maintenance and safeguard of assets acquired with federal funds lacked knowledge of the compliance requirements pertaining to the use of the funds or the maintenance and safeguard of the acquired assets. As a result, adequate documentation was not maintained for equipment acquired with federal funds or to support the performance of a physical inventory occurring within the required time period. Recommendation We recommend the Organization develop a system of internal controls aligned with the applicable compliance requirements to properly track equipment acquisitions in the accounting records and to ensure a physical inventory is appropriately documented when completed. Views of Responsible Officials and Planned Corrective Actions The Organization?s Corrective Action Plan is included on pages 38 and 39.
FINDING 2022-003 Subject: COVID-19 - Education Stabilization Fund - Equipment and Real Property Management Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.425U Federal Award Numbers (or Other Identifying Numbers): S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Equipment and Real Property Management Audit Findings: Material Weakness, Modified Opinion Condition and Context An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the Equipment and Real Property Management compliance requirement. During fiscal year 2021-2022, the School Corporation purchased equipment for the HVAC project totaling $81,637 with ESSER II and ESSER III funds. The HVAC project was not added to the property record which would 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 (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. The lack of internal controls and noncompliance were isolated to the property records for 2021-2022. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.313(d)(1) states: "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 sales price of the property." Cause Management had not developed a system of internal controls that would have ensured compliance with the Equipment and Real Property Management compliance requirement. Effect The failure to establish an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Equipment and Real Property Management compliance requirement could have result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish internal controls to ensure compliance and comply with the grant agreement and the Equipment and Real Property Management compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-003 Subject: COVID-19 - Education Stabilization Fund - Equipment and Real Property Management Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.425U Federal Award Numbers (or Other Identifying Numbers): S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Equipment and Real Property Management Audit Findings: Material Weakness, Modified Opinion Condition and Context An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the Equipment and Real Property Management compliance requirement. During fiscal year 2021-2022, the School Corporation purchased equipment for the HVAC project totaling $81,637 with ESSER II and ESSER III funds. The HVAC project was not added to the property record which would 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 (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. The lack of internal controls and noncompliance were isolated to the property records for 2021-2022. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.313(d)(1) states: "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 sales price of the property." Cause Management had not developed a system of internal controls that would have ensured compliance with the Equipment and Real Property Management compliance requirement. Effect The failure to establish an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Equipment and Real Property Management compliance requirement could have result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish internal controls to ensure compliance and comply with the grant agreement and the Equipment and Real Property Management compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
Criteria: 2 CFR 200.313(d)(2) requires the non-Federal entity take a physical inventory of property and reconcile the results with the property records at least once every two years. Condition: The physical inventory was not conducted as required. Context: In October 2021, the University conducted a physical inventory of all of its fixed assets which includes property acquired with federal funds. To facilitate the inventory, the University distributed a memo to all department heads detailing the procedures needed to conduct a physical inventory and instructed them to perform a physical inventory in their respective departments by December 1, 2021. During our audit, it was noted that the physical inventory was not completed by all departments. Based on the information provided by management there were 16 property items that were subject to inventory; however, because the inventory documentation provided did not cover all departments, only 1 property item was identified through the physical inventory. Cause: Although the University has procedures in place over the physical inventory of property, there was a lack of diligence in complying with the procedures. Effect: Failure to perform physical inventory of property and reconcile the results with the property records at least once every two years results in noncompliance with the equipment and real property management requirement. Questioned Costs: None Identification of a repeat finding: N/A Recommendations: We recommend the University follow their procedures for the physical inventory of equipment and ensure all departments timely complete the physical inventory. Views of responsible officials: The HPU Fixed Asset Accountant, Federal Grant Project Investigator and Office of Sponsored Projects will work collaboratively to ensure that the physical inventory of all fixed assets which were acquired using federal funds are conducted and completed periodically. This physical inventory monitoring will be done at least, every two years. The team will work on getting all departments covered in the periodic inventory to confirm that the fixed asset listing is complete, updated and maintained.
Criteria: 2 CFR 200.313(d)(2) requires the non-Federal entity take a physical inventory of property and reconcile the results with the property records at least once every two years. Condition: The physical inventory was not conducted as required. Context: In October 2021, the University conducted a physical inventory of all of its fixed assets which includes property acquired with federal funds. To facilitate the inventory, the University distributed a memo to all department heads detailing the procedures needed to conduct a physical inventory and instructed them to perform a physical inventory in their respective departments by December 1, 2021. During our audit, it was noted that the physical inventory was not completed by all departments. Based on the information provided by management there were 16 property items that were subject to inventory; however, because the inventory documentation provided did not cover all departments, only 1 property item was identified through the physical inventory. Cause: Although the University has procedures in place over the physical inventory of property, there was a lack of diligence in complying with the procedures. Effect: Failure to perform physical inventory of property and reconcile the results with the property records at least once every two years results in noncompliance with the equipment and real property management requirement. Questioned Costs: None Identification of a repeat finding: N/A Recommendations: We recommend the University follow their procedures for the physical inventory of equipment and ensure all departments timely complete the physical inventory. Views of responsible officials: The HPU Fixed Asset Accountant, Federal Grant Project Investigator and Office of Sponsored Projects will work collaboratively to ensure that the physical inventory of all fixed assets which were acquired using federal funds are conducted and completed periodically. This physical inventory monitoring will be done at least, every two years. The team will work on getting all departments covered in the periodic inventory to confirm that the fixed asset listing is complete, updated and maintained.
Criteria: 2 CFR 200.313(d)(2) requires the non-Federal entity take a physical inventory of property and reconcile the results with the property records at least once every two years. Condition: The physical inventory was not conducted as required. Context: In October 2021, the University conducted a physical inventory of all of its fixed assets which includes property acquired with federal funds. To facilitate the inventory, the University distributed a memo to all department heads detailing the procedures needed to conduct a physical inventory and instructed them to perform a physical inventory in their respective departments by December 1, 2021. During our audit, it was noted that the physical inventory was not completed by all departments. Based on the information provided by management there were 16 property items that were subject to inventory; however, because the inventory documentation provided did not cover all departments, only 1 property item was identified through the physical inventory. Cause: Although the University has procedures in place over the physical inventory of property, there was a lack of diligence in complying with the procedures. Effect: Failure to perform physical inventory of property and reconcile the results with the property records at least once every two years results in noncompliance with the equipment and real property management requirement. Questioned Costs: None Identification of a repeat finding: N/A Recommendations: We recommend the University follow their procedures for the physical inventory of equipment and ensure all departments timely complete the physical inventory. Views of responsible officials: The HPU Fixed Asset Accountant, Federal Grant Project Investigator and Office of Sponsored Projects will work collaboratively to ensure that the physical inventory of all fixed assets which were acquired using federal funds are conducted and completed periodically. This physical inventory monitoring will be done at least, every two years. The team will work on getting all departments covered in the periodic inventory to confirm that the fixed asset listing is complete, updated and maintained.
Criteria: 2 CFR 200.313(d)(2) requires the non-Federal entity take a physical inventory of property and reconcile the results with the property records at least once every two years. Condition: The physical inventory was not conducted as required. Context: In October 2021, the University conducted a physical inventory of all of its fixed assets which includes property acquired with federal funds. To facilitate the inventory, the University distributed a memo to all department heads detailing the procedures needed to conduct a physical inventory and instructed them to perform a physical inventory in their respective departments by December 1, 2021. During our audit, it was noted that the physical inventory was not completed by all departments. Based on the information provided by management there were 16 property items that were subject to inventory; however, because the inventory documentation provided did not cover all departments, only 1 property item was identified through the physical inventory. Cause: Although the University has procedures in place over the physical inventory of property, there was a lack of diligence in complying with the procedures. Effect: Failure to perform physical inventory of property and reconcile the results with the property records at least once every two years results in noncompliance with the equipment and real property management requirement. Questioned Costs: None Identification of a repeat finding: N/A Recommendations: We recommend the University follow their procedures for the physical inventory of equipment and ensure all departments timely complete the physical inventory. Views of responsible officials: The HPU Fixed Asset Accountant, Federal Grant Project Investigator and Office of Sponsored Projects will work collaboratively to ensure that the physical inventory of all fixed assets which were acquired using federal funds are conducted and completed periodically. This physical inventory monitoring will be done at least, every two years. The team will work on getting all departments covered in the periodic inventory to confirm that the fixed asset listing is complete, updated and maintained.
2 CFR 200.313(d)(1) provides that 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. The District purchased a bus in the amount of $102,963 and completed office renovations in the amount of $26,750 and an entrance brivo and aiphone project and in the amount of $15,100 using their Education Stabilization Fund (ESSER II) AL# 84.425D federal funding. Due to a lack of proper internal controls over Federal Grants management, the District failed to record these purchases and projects in their capital asset records. The Treasurer and Superintendent should ensure all capital acquisitions are added to the capital asset listing and include all required information in the listing, noting the assets were purchased with federal funds.
Material Weakness/Noncompliance Finding Number: 2022-001 Assistance Listing Number and Title: AL #84.425D COVID-19 ? Education Stabilization Fund Federal Award Identification Number / Year: 2022 Federal Agency: US Department of Education Compliance Requirement: Equipment Pass-Through Entity: Ohio Department of Education Repeat Finding from Prior Audit? No 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. Consistent with 2 CFR section 200.311 (real property), section 200.313 (equipment), and section 200.439 (equipment and other capital expenditures), ESF funds may be used for these purposes. Recipients and subrecipients may use ESF funds to purchase equipment. Capital expenditures for general and special purpose equipment purchases are subject to prior approval by ED or the pass-through entity. In addition, with prior approval by the ED or the pass-through entity, recipients and subrecipients may use ESF funds to purchase real property and perform construction for improvements to land, buildings, or equipment that meet the overall purpose of the ESF program, which is ?to prevent, prepare for, and respond to? the COVID-19 pandemic. In addition to the guidance noted above, the Uniform Guidance at 2 CFR ? 200.407 requires prior written approval from either the Department or the State (Governor or SEA, as applicable) for certain costs, such as the purchase of real property; equipment and other capital expenditures; entertainment costs; and travel costs. The School District failed to properly track assets purchased or improvements completed with ESF (specifically Elementary and Secondary School Emergency Relief or ESSER) funds in their Equipment Inventory System. This resulted in unrecorded assets of approximately $209,788 purchased with ESSER Funds not recorded in the inventory system. This would not allow for proper tracking as required above. This was the result of the School District Treasurer not adding all assets to the system. The School District also did not receive proper approval before the purchase of Phenomenal Aire Units. We recommend the School District Treasurer review the Equipment Inventory System and adjust it to include all assets purchased with ESSER Funds. We further recommend the School District ensure it receives all proper approvals as required for any capital asset expenditures purchased with ESSER funds. Officials? Response: Moving forward the School District Treasurer will make sure and double check all inventory purchased with ESSER Funds are in the inventory system if it is over the capital asset threshold. Also, she will make sure all capital asset expenditures purchased with ESSER funds have proper approval.
Material Weakness/Noncompliance Finding Number: 2022-001 Assistance Listing Number and Title: AL #84.425D COVID-19 ? Education Stabilization Fund Federal Award Identification Number / Year: 2022 Federal Agency: US Department of Education Compliance Requirement: Equipment Pass-Through Entity: Ohio Department of Education Repeat Finding from Prior Audit? No 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. Consistent with 2 CFR section 200.311 (real property), section 200.313 (equipment), and section 200.439 (equipment and other capital expenditures), ESF funds may be used for these purposes. Recipients and subrecipients may use ESF funds to purchase equipment. Capital expenditures for general and special purpose equipment purchases are subject to prior approval by ED or the pass-through entity. In addition, with prior approval by the ED or the pass-through entity, recipients and subrecipients may use ESF funds to purchase real property and perform construction for improvements to land, buildings, or equipment that meet the overall purpose of the ESF program, which is ?to prevent, prepare for, and respond to? the COVID-19 pandemic. In addition to the guidance noted above, the Uniform Guidance at 2 CFR ? 200.407 requires prior written approval from either the Department or the State (Governor or SEA, as applicable) for certain costs, such as the purchase of real property; equipment and other capital expenditures; entertainment costs; and travel costs. The School District failed to properly track assets purchased or improvements completed with ESF (specifically Elementary and Secondary School Emergency Relief or ESSER) funds in their Equipment Inventory System. This resulted in unrecorded assets of approximately $209,788 purchased with ESSER Funds not recorded in the inventory system. This would not allow for proper tracking as required above. This was the result of the School District Treasurer not adding all assets to the system. The School District also did not receive proper approval before the purchase of Phenomenal Aire Units. We recommend the School District Treasurer review the Equipment Inventory System and adjust it to include all assets purchased with ESSER Funds. We further recommend the School District ensure it receives all proper approvals as required for any capital asset expenditures purchased with ESSER funds. Officials? Response: Moving forward the School District Treasurer will make sure and double check all inventory purchased with ESSER Funds are in the inventory system if it is over the capital asset threshold. Also, she will make sure all capital asset expenditures purchased with ESSER funds have proper approval.
Condition and Context: The School has not performed a comprehensive inventory of capital assets in several years. Accordingly, the School has not reconciled a physical observation to its detailed capital asset listing. Criteria: According to 2 CFR 200.313 Equipment, a physical inventory of the property must be performed and the results reconciled with the property records at least once every two years. Cause and Effect: The cause is a lack of resources to perform a physical inventory of the property and equipment. The effect is the possibility of purchasing assets using federal funds that are not properly accounted for in the accounting records. Recommendation: We recommend that the School perform a physical inventory of the School's capital assets on at least a biennial basis. In addition, the Finance Department should update the School's accounting records based on the results of the physical inventory. Management?s Response: The School?s responsible officials? views and planned corrective action are in its corrective action plan at the end of the report.
Condition and Context: The School has not performed a comprehensive inventory of capital assets in several years. Accordingly, the School has not reconciled a physical observation to its detailed capital asset listing. Criteria: According to 2 CFR 200.313 Equipment, a physical inventory of the property must be performed and the results reconciled with the property records at least once every two years. Cause and Effect: The cause is a lack of resources to perform a physical inventory of the property and equipment. The effect is the possibility of purchasing assets using federal funds that are not properly accounted for in the accounting records. Recommendation: We recommend that the School perform a physical inventory of the School's capital assets on at least a biennial basis. In addition, the Finance Department should update the School's accounting records based on the results of the physical inventory. Management?s Response: The School?s responsible officials? views and planned corrective action are in its corrective action plan at the end of the report.
2022-010 ? Equipment and Real Property Management ? Material Weakness Federal Program Information Funding Agency: Department of Defense, National Science Foundation, Department of Education, Department of Health and Human Services ? National Institute of Health Federal Award Agreement Number: Not Applicable Award Year: Fiscal year 2022 Title: Research and Development Cluster Assistance Listing Number: 12.598, 47.050, 47.076, 84.031, and 93.859 Pass-through Agency: Not Applicable, Direct Program Pass-through Identification Number: Not Applicable, Direct Program Condition - The College was not able to provide an equipment listing tracking items purchased with federal funding nor did the College conduct a physical inventory.Criteria - 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 and per 2 CFR 200.303(a) states that the non-Federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations and the terms and conditions of the Federal award. Questioned Costs - Not applicable. Effect - The College could dispose of or lose federally funded equipment without following federal guidelines. Cause - The College does not have policies and procedures to ensure that equipment purchases with federal funds is maintained and tracked and that the College performing a physical inventory at a minimum of every two years.
Reference Number: 2022-028 Prior Year Finding: No Federal Agency: U.S. Department of Education State Agency: Agency of Education (Agency) Federal Program: COVID-19 ? Governor?s Emergency Education Relief Fund Assistance Listing Number: 84.425C, 84.425R Award Number and Year: S425C200009 (5/6/2020 ? 9/30/2021) S425C210009 (1/8/2021 ? 9/30/2022) S425R210033 (2/23/2021 ? 9/30/2022) S425V210033 (1/21/2021 ? 9/30/2023) Compliance Requirement: Equipment/Real Property Management Type of Finding Significant Deficiency in Internal Control Over Compliance, Other Matters Criteria or specific requirement: Compliance: Per 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. Per 2 CFR section 200.313(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 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. (2) A physical inventory of the property must be taken and the results reconciled with the property records at least once every two 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. Control: Per 2 CFR section 200.303(a), a 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 comply with guidance in ?Standards for Internal Control in the Federal Government? issued by the Comptroller General of the United States or the ?Internal Control Integrated Framework?, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: The Agency of Education (Agency) was unable to provide supporting documentation for equipment purchased with program funds. The Agency did not maintain an equipment ledger or track equipment in accordance with 2 CFR section 200.313. Context: When auditors conducted an initial risk assessment of the program, the Agency was unable to provide an equipment ledger or other supporting documentation of equipment purchased with program funds and, therefore, materiality could not be determined. The Agency conducted a manual assessment over all personal property/equipment purchased with federal program funding. This assessment determined that approximately $78,000 of equipment was purchased using GEER funding. While this amount is immaterial to total funding dollars, materiality could only be determined due to the additional assessments performed. Cause: The Agency?s procedures and internal controls were not sufficient to ensure it maintained documentation of equipment purchased with program funds. Effect: Equipment purchased with program funds was not managed and accounted for in accordance with State laws and procedures and in accordance with 2 CFR section 200.313. Questioned costs: Undetermined. Recommendation: We recommend the Agency review and enhance internal controls and procedures over equipment to ensure that it purchases and records equipment purchased with program funds in accordance with State laws and procedures and in accordance with 2 CFR section 200.313. Views of responsible officials: Management agrees with the finding.
Reference Number: 2022-028 Prior Year Finding: No Federal Agency: U.S. Department of Education State Agency: Agency of Education (Agency) Federal Program: COVID-19 ? Governor?s Emergency Education Relief Fund Assistance Listing Number: 84.425C, 84.425R Award Number and Year: S425C200009 (5/6/2020 ? 9/30/2021) S425C210009 (1/8/2021 ? 9/30/2022) S425R210033 (2/23/2021 ? 9/30/2022) S425V210033 (1/21/2021 ? 9/30/2023) Compliance Requirement: Equipment/Real Property Management Type of Finding Significant Deficiency in Internal Control Over Compliance, Other Matters Criteria or specific requirement: Compliance: Per 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. Per 2 CFR section 200.313(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 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. (2) A physical inventory of the property must be taken and the results reconciled with the property records at least once every two 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. Control: Per 2 CFR section 200.303(a), a 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 comply with guidance in ?Standards for Internal Control in the Federal Government? issued by the Comptroller General of the United States or the ?Internal Control Integrated Framework?, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: The Agency of Education (Agency) was unable to provide supporting documentation for equipment purchased with program funds. The Agency did not maintain an equipment ledger or track equipment in accordance with 2 CFR section 200.313. Context: When auditors conducted an initial risk assessment of the program, the Agency was unable to provide an equipment ledger or other supporting documentation of equipment purchased with program funds and, therefore, materiality could not be determined. The Agency conducted a manual assessment over all personal property/equipment purchased with federal program funding. This assessment determined that approximately $78,000 of equipment was purchased using GEER funding. While this amount is immaterial to total funding dollars, materiality could only be determined due to the additional assessments performed. Cause: The Agency?s procedures and internal controls were not sufficient to ensure it maintained documentation of equipment purchased with program funds. Effect: Equipment purchased with program funds was not managed and accounted for in accordance with State laws and procedures and in accordance with 2 CFR section 200.313. Questioned costs: Undetermined. Recommendation: We recommend the Agency review and enhance internal controls and procedures over equipment to ensure that it purchases and records equipment purchased with program funds in accordance with State laws and procedures and in accordance with 2 CFR section 200.313. Views of responsible officials: Management agrees with the finding.
Finding 2022 002: Inaccurate Property Management Records Federal Agency: U.S. Department of Agriculture (USDA) U.S. Department of Commerce (USDOC) U.S. Department of Defense (USDOD) U.S. Director of National Intelligence (USDNI) U.S. Department of Housing and Urban Development (USHUD) U.S. Department of Interior (USDOI) U.S. Department of Justice (USDOJ) U.S. Department of Transportation (USDOT) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) U.S. Environmental Protection Agency (USEPA) U.S. Department of Energy (USDOE) U.S. Department of Education (USDE) Smithsonian Institution U.S. Department of Health and Human Services (USDHHS) Corporation for National and Community Service All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($482,298,931) Federal Award Numbers: Various ? See schedule of award numbers Federal Award Year: Various ? See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Condition Found: The University did not consistently follow its property management policies and procedures related to equipment purchased with federal funding from the Research and Development (R&D) Cluster program. The University conducts research at multiple locations throughout their campus, where equipment purchased with federal funds is utilized and maintained. The University identifies all equipment in its property management records with individually assigned asset numbers and each individual asset record includes the specific location of the asset, the federal award general ledger account number that funded the purchase of the asset, and other required information. An asset tag with the assigned asset number is affixed to each asset in accordance with University policy. During our physical observation of 60 pieces of equipment purchased with R&D Cluster funds (with a total cost value of $1,542,384), we noted the following: - Nine items (with a total cost value of $200,035) did not have property management tags affixed at the time of our observation. - Eight items (with a total cost value of $103,583) had property management tags with asset numbers that were inconsistent with the equipment listing. Upon further review, we noted the property management records contained a temporary asset tag number that had not been updated for the permanent tag subsequently affixed by department personnel. Further, we noted adequate management review controls had not been established to ensure property management records were accurately updated and equipment was properly tagged. The net book value of equipment related to the R&D Cluster program totaled $217,101,257 at June 30, 2022. Criteria: According to 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, 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. In addition, 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. Effective internal controls should include procedures to ensure that accurate property records are maintained and equipment items are properly tagged. Cause: In discussing these conditions with University officials, they stated the University?s procedures for tagging equipment were delayed because the University?s personnel operated in a remote environment during fiscal years 2021 and 2022. Additionally, physical inventory procedures, which are designed detect differences between perpetual and actual information, were waived during fiscal years 2020 and 2021 as a result of the pandemic. Possible Asserted Effect: Failure to maintain accurate property records may prohibit the University from properly safeguarding and maintaining equipment and may result in federal programs not receiving the appropriate share of proceeds from the disposals of equipment purchased with federal funds. Repeat Finding: A similar finding was not reported in the prior year audit. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend the University review its procedures for updating property records to ensure they accurately reflect equipment information. We also recommend the University properly tag equipment in accordance with its policy. Views of University Officials: The University agrees with the finding. All departments of the University will be reminded that tagging is an integral part of the internal control process for capital assets and training will be made available before June 30, 2023.
Finding 2022 002: Inaccurate Property Management Records Federal Agency: U.S. Department of Agriculture (USDA) U.S. Department of Commerce (USDOC) U.S. Department of Defense (USDOD) U.S. Director of National Intelligence (USDNI) U.S. Department of Housing and Urban Development (USHUD) U.S. Department of Interior (USDOI) U.S. Department of Justice (USDOJ) U.S. Department of Transportation (USDOT) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) U.S. Environmental Protection Agency (USEPA) U.S. Department of Energy (USDOE) U.S. Department of Education (USDE) Smithsonian Institution U.S. Department of Health and Human Services (USDHHS) Corporation for National and Community Service All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($482,298,931) Federal Award Numbers: Various ? See schedule of award numbers Federal Award Year: Various ? See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Condition Found: The University did not consistently follow its property management policies and procedures related to equipment purchased with federal funding from the Research and Development (R&D) Cluster program. The University conducts research at multiple locations throughout their campus, where equipment purchased with federal funds is utilized and maintained. The University identifies all equipment in its property management records with individually assigned asset numbers and each individual asset record includes the specific location of the asset, the federal award general ledger account number that funded the purchase of the asset, and other required information. An asset tag with the assigned asset number is affixed to each asset in accordance with University policy. During our physical observation of 60 pieces of equipment purchased with R&D Cluster funds (with a total cost value of $1,542,384), we noted the following: - Nine items (with a total cost value of $200,035) did not have property management tags affixed at the time of our observation. - Eight items (with a total cost value of $103,583) had property management tags with asset numbers that were inconsistent with the equipment listing. Upon further review, we noted the property management records contained a temporary asset tag number that had not been updated for the permanent tag subsequently affixed by department personnel. Further, we noted adequate management review controls had not been established to ensure property management records were accurately updated and equipment was properly tagged. The net book value of equipment related to the R&D Cluster program totaled $217,101,257 at June 30, 2022. Criteria: According to 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, 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. In addition, 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. Effective internal controls should include procedures to ensure that accurate property records are maintained and equipment items are properly tagged. Cause: In discussing these conditions with University officials, they stated the University?s procedures for tagging equipment were delayed because the University?s personnel operated in a remote environment during fiscal years 2021 and 2022. Additionally, physical inventory procedures, which are designed detect differences between perpetual and actual information, were waived during fiscal years 2020 and 2021 as a result of the pandemic. Possible Asserted Effect: Failure to maintain accurate property records may prohibit the University from properly safeguarding and maintaining equipment and may result in federal programs not receiving the appropriate share of proceeds from the disposals of equipment purchased with federal funds. Repeat Finding: A similar finding was not reported in the prior year audit. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend the University review its procedures for updating property records to ensure they accurately reflect equipment information. We also recommend the University properly tag equipment in accordance with its policy. Views of University Officials: The University agrees with the finding. All departments of the University will be reminded that tagging is an integral part of the internal control process for capital assets and training will be made available before June 30, 2023.
Finding 2022 002: Inaccurate Property Management Records Federal Agency: U.S. Department of Agriculture (USDA) U.S. Department of Commerce (USDOC) U.S. Department of Defense (USDOD) U.S. Director of National Intelligence (USDNI) U.S. Department of Housing and Urban Development (USHUD) U.S. Department of Interior (USDOI) U.S. Department of Justice (USDOJ) U.S. Department of Transportation (USDOT) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) U.S. Environmental Protection Agency (USEPA) U.S. Department of Energy (USDOE) U.S. Department of Education (USDE) Smithsonian Institution U.S. Department of Health and Human Services (USDHHS) Corporation for National and Community Service All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($482,298,931) Federal Award Numbers: Various ? See schedule of award numbers Federal Award Year: Various ? See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Condition Found: The University did not consistently follow its property management policies and procedures related to equipment purchased with federal funding from the Research and Development (R&D) Cluster program. The University conducts research at multiple locations throughout their campus, where equipment purchased with federal funds is utilized and maintained. The University identifies all equipment in its property management records with individually assigned asset numbers and each individual asset record includes the specific location of the asset, the federal award general ledger account number that funded the purchase of the asset, and other required information. An asset tag with the assigned asset number is affixed to each asset in accordance with University policy. During our physical observation of 60 pieces of equipment purchased with R&D Cluster funds (with a total cost value of $1,542,384), we noted the following: - Nine items (with a total cost value of $200,035) did not have property management tags affixed at the time of our observation. - Eight items (with a total cost value of $103,583) had property management tags with asset numbers that were inconsistent with the equipment listing. Upon further review, we noted the property management records contained a temporary asset tag number that had not been updated for the permanent tag subsequently affixed by department personnel. Further, we noted adequate management review controls had not been established to ensure property management records were accurately updated and equipment was properly tagged. The net book value of equipment related to the R&D Cluster program totaled $217,101,257 at June 30, 2022. Criteria: According to 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, 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. In addition, 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. Effective internal controls should include procedures to ensure that accurate property records are maintained and equipment items are properly tagged. Cause: In discussing these conditions with University officials, they stated the University?s procedures for tagging equipment were delayed because the University?s personnel operated in a remote environment during fiscal years 2021 and 2022. Additionally, physical inventory procedures, which are designed detect differences between perpetual and actual information, were waived during fiscal years 2020 and 2021 as a result of the pandemic. Possible Asserted Effect: Failure to maintain accurate property records may prohibit the University from properly safeguarding and maintaining equipment and may result in federal programs not receiving the appropriate share of proceeds from the disposals of equipment purchased with federal funds. Repeat Finding: A similar finding was not reported in the prior year audit. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend the University review its procedures for updating property records to ensure they accurately reflect equipment information. We also recommend the University properly tag equipment in accordance with its policy. Views of University Officials: The University agrees with the finding. All departments of the University will be reminded that tagging is an integral part of the internal control process for capital assets and training will be made available before June 30, 2023.
Finding 2022 002: Inaccurate Property Management Records Federal Agency: U.S. Department of Agriculture (USDA) U.S. Department of Commerce (USDOC) U.S. Department of Defense (USDOD) U.S. Director of National Intelligence (USDNI) U.S. Department of Housing and Urban Development (USHUD) U.S. Department of Interior (USDOI) U.S. Department of Justice (USDOJ) U.S. Department of Transportation (USDOT) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) U.S. Environmental Protection Agency (USEPA) U.S. Department of Energy (USDOE) U.S. Department of Education (USDE) Smithsonian Institution U.S. Department of Health and Human Services (USDHHS) Corporation for National and Community Service All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($482,298,931) Federal Award Numbers: Various ? See schedule of award numbers Federal Award Year: Various ? See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Condition Found: The University did not consistently follow its property management policies and procedures related to equipment purchased with federal funding from the Research and Development (R&D) Cluster program. The University conducts research at multiple locations throughout their campus, where equipment purchased with federal funds is utilized and maintained. The University identifies all equipment in its property management records with individually assigned asset numbers and each individual asset record includes the specific location of the asset, the federal award general ledger account number that funded the purchase of the asset, and other required information. An asset tag with the assigned asset number is affixed to each asset in accordance with University policy. During our physical observation of 60 pieces of equipment purchased with R&D Cluster funds (with a total cost value of $1,542,384), we noted the following: - Nine items (with a total cost value of $200,035) did not have property management tags affixed at the time of our observation. - Eight items (with a total cost value of $103,583) had property management tags with asset numbers that were inconsistent with the equipment listing. Upon further review, we noted the property management records contained a temporary asset tag number that had not been updated for the permanent tag subsequently affixed by department personnel. Further, we noted adequate management review controls had not been established to ensure property management records were accurately updated and equipment was properly tagged. The net book value of equipment related to the R&D Cluster program totaled $217,101,257 at June 30, 2022. Criteria: According to 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, 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. In addition, 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. Effective internal controls should include procedures to ensure that accurate property records are maintained and equipment items are properly tagged. Cause: In discussing these conditions with University officials, they stated the University?s procedures for tagging equipment were delayed because the University?s personnel operated in a remote environment during fiscal years 2021 and 2022. Additionally, physical inventory procedures, which are designed detect differences between perpetual and actual information, were waived during fiscal years 2020 and 2021 as a result of the pandemic. Possible Asserted Effect: Failure to maintain accurate property records may prohibit the University from properly safeguarding and maintaining equipment and may result in federal programs not receiving the appropriate share of proceeds from the disposals of equipment purchased with federal funds. Repeat Finding: A similar finding was not reported in the prior year audit. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend the University review its procedures for updating property records to ensure they accurately reflect equipment information. We also recommend the University properly tag equipment in accordance with its policy. Views of University Officials: The University agrees with the finding. All departments of the University will be reminded that tagging is an integral part of the internal control process for capital assets and training will be made available before June 30, 2023.
Finding 2022 002: Inaccurate Property Management Records Federal Agency: U.S. Department of Agriculture (USDA) U.S. Department of Commerce (USDOC) U.S. Department of Defense (USDOD) U.S. Director of National Intelligence (USDNI) U.S. Department of Housing and Urban Development (USHUD) U.S. Department of Interior (USDOI) U.S. Department of Justice (USDOJ) U.S. Department of Transportation (USDOT) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) U.S. Environmental Protection Agency (USEPA) U.S. Department of Energy (USDOE) U.S. Department of Education (USDE) Smithsonian Institution U.S. Department of Health and Human Services (USDHHS) Corporation for National and Community Service All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($482,298,931) Federal Award Numbers: Various ? See schedule of award numbers Federal Award Year: Various ? See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Condition Found: The University did not consistently follow its property management policies and procedures related to equipment purchased with federal funding from the Research and Development (R&D) Cluster program. The University conducts research at multiple locations throughout their campus, where equipment purchased with federal funds is utilized and maintained. The University identifies all equipment in its property management records with individually assigned asset numbers and each individual asset record includes the specific location of the asset, the federal award general ledger account number that funded the purchase of the asset, and other required information. An asset tag with the assigned asset number is affixed to each asset in accordance with University policy. During our physical observation of 60 pieces of equipment purchased with R&D Cluster funds (with a total cost value of $1,542,384), we noted the following: - Nine items (with a total cost value of $200,035) did not have property management tags affixed at the time of our observation. - Eight items (with a total cost value of $103,583) had property management tags with asset numbers that were inconsistent with the equipment listing. Upon further review, we noted the property management records contained a temporary asset tag number that had not been updated for the permanent tag subsequently affixed by department personnel. Further, we noted adequate management review controls had not been established to ensure property management records were accurately updated and equipment was properly tagged. The net book value of equipment related to the R&D Cluster program totaled $217,101,257 at June 30, 2022. Criteria: According to 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, 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. In addition, 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. Effective internal controls should include procedures to ensure that accurate property records are maintained and equipment items are properly tagged. Cause: In discussing these conditions with University officials, they stated the University?s procedures for tagging equipment were delayed because the University?s personnel operated in a remote environment during fiscal years 2021 and 2022. Additionally, physical inventory procedures, which are designed detect differences between perpetual and actual information, were waived during fiscal years 2020 and 2021 as a result of the pandemic. Possible Asserted Effect: Failure to maintain accurate property records may prohibit the University from properly safeguarding and maintaining equipment and may result in federal programs not receiving the appropriate share of proceeds from the disposals of equipment purchased with federal funds. Repeat Finding: A similar finding was not reported in the prior year audit. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend the University review its procedures for updating property records to ensure they accurately reflect equipment information. We also recommend the University properly tag equipment in accordance with its policy. Views of University Officials: The University agrees with the finding. All departments of the University will be reminded that tagging is an integral part of the internal control process for capital assets and training will be made available before June 30, 2023.
Finding 2022 002: Inaccurate Property Management Records Federal Agency: U.S. Department of Agriculture (USDA) U.S. Department of Commerce (USDOC) U.S. Department of Defense (USDOD) U.S. Director of National Intelligence (USDNI) U.S. Department of Housing and Urban Development (USHUD) U.S. Department of Interior (USDOI) U.S. Department of Justice (USDOJ) U.S. Department of Transportation (USDOT) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) U.S. Environmental Protection Agency (USEPA) U.S. Department of Energy (USDOE) U.S. Department of Education (USDE) Smithsonian Institution U.S. Department of Health and Human Services (USDHHS) Corporation for National and Community Service All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($482,298,931) Federal Award Numbers: Various ? See schedule of award numbers Federal Award Year: Various ? See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Condition Found: The University did not consistently follow its property management policies and procedures related to equipment purchased with federal funding from the Research and Development (R&D) Cluster program. The University conducts research at multiple locations throughout their campus, where equipment purchased with federal funds is utilized and maintained. The University identifies all equipment in its property management records with individually assigned asset numbers and each individual asset record includes the specific location of the asset, the federal award general ledger account number that funded the purchase of the asset, and other required information. An asset tag with the assigned asset number is affixed to each asset in accordance with University policy. During our physical observation of 60 pieces of equipment purchased with R&D Cluster funds (with a total cost value of $1,542,384), we noted the following: - Nine items (with a total cost value of $200,035) did not have property management tags affixed at the time of our observation. - Eight items (with a total cost value of $103,583) had property management tags with asset numbers that were inconsistent with the equipment listing. Upon further review, we noted the property management records contained a temporary asset tag number that had not been updated for the permanent tag subsequently affixed by department personnel. Further, we noted adequate management review controls had not been established to ensure property management records were accurately updated and equipment was properly tagged. The net book value of equipment related to the R&D Cluster program totaled $217,101,257 at June 30, 2022. Criteria: According to 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, 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. In addition, 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. Effective internal controls should include procedures to ensure that accurate property records are maintained and equipment items are properly tagged. Cause: In discussing these conditions with University officials, they stated the University?s procedures for tagging equipment were delayed because the University?s personnel operated in a remote environment during fiscal years 2021 and 2022. Additionally, physical inventory procedures, which are designed detect differences between perpetual and actual information, were waived during fiscal years 2020 and 2021 as a result of the pandemic. Possible Asserted Effect: Failure to maintain accurate property records may prohibit the University from properly safeguarding and maintaining equipment and may result in federal programs not receiving the appropriate share of proceeds from the disposals of equipment purchased with federal funds. Repeat Finding: A similar finding was not reported in the prior year audit. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend the University review its procedures for updating property records to ensure they accurately reflect equipment information. We also recommend the University properly tag equipment in accordance with its policy. Views of University Officials: The University agrees with the finding. All departments of the University will be reminded that tagging is an integral part of the internal control process for capital assets and training will be made available before June 30, 2023.
Finding 2022 002: Inaccurate Property Management Records Federal Agency: U.S. Department of Agriculture (USDA) U.S. Department of Commerce (USDOC) U.S. Department of Defense (USDOD) U.S. Director of National Intelligence (USDNI) U.S. Department of Housing and Urban Development (USHUD) U.S. Department of Interior (USDOI) U.S. Department of Justice (USDOJ) U.S. Department of Transportation (USDOT) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) U.S. Environmental Protection Agency (USEPA) U.S. Department of Energy (USDOE) U.S. Department of Education (USDE) Smithsonian Institution U.S. Department of Health and Human Services (USDHHS) Corporation for National and Community Service All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($482,298,931) Federal Award Numbers: Various ? See schedule of award numbers Federal Award Year: Various ? See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Condition Found: The University did not consistently follow its property management policies and procedures related to equipment purchased with federal funding from the Research and Development (R&D) Cluster program. The University conducts research at multiple locations throughout their campus, where equipment purchased with federal funds is utilized and maintained. The University identifies all equipment in its property management records with individually assigned asset numbers and each individual asset record includes the specific location of the asset, the federal award general ledger account number that funded the purchase of the asset, and other required information. An asset tag with the assigned asset number is affixed to each asset in accordance with University policy. During our physical observation of 60 pieces of equipment purchased with R&D Cluster funds (with a total cost value of $1,542,384), we noted the following: - Nine items (with a total cost value of $200,035) did not have property management tags affixed at the time of our observation. - Eight items (with a total cost value of $103,583) had property management tags with asset numbers that were inconsistent with the equipment listing. Upon further review, we noted the property management records contained a temporary asset tag number that had not been updated for the permanent tag subsequently affixed by department personnel. Further, we noted adequate management review controls had not been established to ensure property management records were accurately updated and equipment was properly tagged. The net book value of equipment related to the R&D Cluster program totaled $217,101,257 at June 30, 2022. Criteria: According to 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, 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. In addition, 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. Effective internal controls should include procedures to ensure that accurate property records are maintained and equipment items are properly tagged. Cause: In discussing these conditions with University officials, they stated the University?s procedures for tagging equipment were delayed because the University?s personnel operated in a remote environment during fiscal years 2021 and 2022. Additionally, physical inventory procedures, which are designed detect differences between perpetual and actual information, were waived during fiscal years 2020 and 2021 as a result of the pandemic. Possible Asserted Effect: Failure to maintain accurate property records may prohibit the University from properly safeguarding and maintaining equipment and may result in federal programs not receiving the appropriate share of proceeds from the disposals of equipment purchased with federal funds. Repeat Finding: A similar finding was not reported in the prior year audit. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend the University review its procedures for updating property records to ensure they accurately reflect equipment information. We also recommend the University properly tag equipment in accordance with its policy. Views of University Officials: The University agrees with the finding. All departments of the University will be reminded that tagging is an integral part of the internal control process for capital assets and training will be made available before June 30, 2023.
Finding 2022 002: Inaccurate Property Management Records Federal Agency: U.S. Department of Agriculture (USDA) U.S. Department of Commerce (USDOC) U.S. Department of Defense (USDOD) U.S. Director of National Intelligence (USDNI) U.S. Department of Housing and Urban Development (USHUD) U.S. Department of Interior (USDOI) U.S. Department of Justice (USDOJ) U.S. Department of Transportation (USDOT) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) U.S. Environmental Protection Agency (USEPA) U.S. Department of Energy (USDOE) U.S. Department of Education (USDE) Smithsonian Institution U.S. Department of Health and Human Services (USDHHS) Corporation for National and Community Service All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($482,298,931) Federal Award Numbers: Various ? See schedule of award numbers Federal Award Year: Various ? See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Condition Found: The University did not consistently follow its property management policies and procedures related to equipment purchased with federal funding from the Research and Development (R&D) Cluster program. The University conducts research at multiple locations throughout their campus, where equipment purchased with federal funds is utilized and maintained. The University identifies all equipment in its property management records with individually assigned asset numbers and each individual asset record includes the specific location of the asset, the federal award general ledger account number that funded the purchase of the asset, and other required information. An asset tag with the assigned asset number is affixed to each asset in accordance with University policy. During our physical observation of 60 pieces of equipment purchased with R&D Cluster funds (with a total cost value of $1,542,384), we noted the following: - Nine items (with a total cost value of $200,035) did not have property management tags affixed at the time of our observation. - Eight items (with a total cost value of $103,583) had property management tags with asset numbers that were inconsistent with the equipment listing. Upon further review, we noted the property management records contained a temporary asset tag number that had not been updated for the permanent tag subsequently affixed by department personnel. Further, we noted adequate management review controls had not been established to ensure property management records were accurately updated and equipment was properly tagged. The net book value of equipment related to the R&D Cluster program totaled $217,101,257 at June 30, 2022. Criteria: According to 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, 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. In addition, 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. Effective internal controls should include procedures to ensure that accurate property records are maintained and equipment items are properly tagged. Cause: In discussing these conditions with University officials, they stated the University?s procedures for tagging equipment were delayed because the University?s personnel operated in a remote environment during fiscal years 2021 and 2022. Additionally, physical inventory procedures, which are designed detect differences between perpetual and actual information, were waived during fiscal years 2020 and 2021 as a result of the pandemic. Possible Asserted Effect: Failure to maintain accurate property records may prohibit the University from properly safeguarding and maintaining equipment and may result in federal programs not receiving the appropriate share of proceeds from the disposals of equipment purchased with federal funds. Repeat Finding: A similar finding was not reported in the prior year audit. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend the University review its procedures for updating property records to ensure they accurately reflect equipment information. We also recommend the University properly tag equipment in accordance with its policy. Views of University Officials: The University agrees with the finding. All departments of the University will be reminded that tagging is an integral part of the internal control process for capital assets and training will be made available before June 30, 2023.
Finding 2022 002: Inaccurate Property Management Records Federal Agency: U.S. Department of Agriculture (USDA) U.S. Department of Commerce (USDOC) U.S. Department of Defense (USDOD) U.S. Director of National Intelligence (USDNI) U.S. Department of Housing and Urban Development (USHUD) U.S. Department of Interior (USDOI) U.S. Department of Justice (USDOJ) U.S. Department of Transportation (USDOT) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) U.S. Environmental Protection Agency (USEPA) U.S. Department of Energy (USDOE) U.S. Department of Education (USDE) Smithsonian Institution U.S. Department of Health and Human Services (USDHHS) Corporation for National and Community Service All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($482,298,931) Federal Award Numbers: Various ? See schedule of award numbers Federal Award Year: Various ? See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Condition Found: The University did not consistently follow its property management policies and procedures related to equipment purchased with federal funding from the Research and Development (R&D) Cluster program. The University conducts research at multiple locations throughout their campus, where equipment purchased with federal funds is utilized and maintained. The University identifies all equipment in its property management records with individually assigned asset numbers and each individual asset record includes the specific location of the asset, the federal award general ledger account number that funded the purchase of the asset, and other required information. An asset tag with the assigned asset number is affixed to each asset in accordance with University policy. During our physical observation of 60 pieces of equipment purchased with R&D Cluster funds (with a total cost value of $1,542,384), we noted the following: - Nine items (with a total cost value of $200,035) did not have property management tags affixed at the time of our observation. - Eight items (with a total cost value of $103,583) had property management tags with asset numbers that were inconsistent with the equipment listing. Upon further review, we noted the property management records contained a temporary asset tag number that had not been updated for the permanent tag subsequently affixed by department personnel. Further, we noted adequate management review controls had not been established to ensure property management records were accurately updated and equipment was properly tagged. The net book value of equipment related to the R&D Cluster program totaled $217,101,257 at June 30, 2022. Criteria: According to 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, 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. In addition, 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. Effective internal controls should include procedures to ensure that accurate property records are maintained and equipment items are properly tagged. Cause: In discussing these conditions with University officials, they stated the University?s procedures for tagging equipment were delayed because the University?s personnel operated in a remote environment during fiscal years 2021 and 2022. Additionally, physical inventory procedures, which are designed detect differences between perpetual and actual information, were waived during fiscal years 2020 and 2021 as a result of the pandemic. Possible Asserted Effect: Failure to maintain accurate property records may prohibit the University from properly safeguarding and maintaining equipment and may result in federal programs not receiving the appropriate share of proceeds from the disposals of equipment purchased with federal funds. Repeat Finding: A similar finding was not reported in the prior year audit. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend the University review its procedures for updating property records to ensure they accurately reflect equipment information. We also recommend the University properly tag equipment in accordance with its policy. Views of University Officials: The University agrees with the finding. All departments of the University will be reminded that tagging is an integral part of the internal control process for capital assets and training will be made available before June 30, 2023.
Finding 2022 002: Inaccurate Property Management Records Federal Agency: U.S. Department of Agriculture (USDA) U.S. Department of Commerce (USDOC) U.S. Department of Defense (USDOD) U.S. Director of National Intelligence (USDNI) U.S. Department of Housing and Urban Development (USHUD) U.S. Department of Interior (USDOI) U.S. Department of Justice (USDOJ) U.S. Department of Transportation (USDOT) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) U.S. Environmental Protection Agency (USEPA) U.S. Department of Energy (USDOE) U.S. Department of Education (USDE) Smithsonian Institution U.S. Department of Health and Human Services (USDHHS) Corporation for National and Community Service All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($482,298,931) Federal Award Numbers: Various ? See schedule of award numbers Federal Award Year: Various ? See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Condition Found: The University did not consistently follow its property management policies and procedures related to equipment purchased with federal funding from the Research and Development (R&D) Cluster program. The University conducts research at multiple locations throughout their campus, where equipment purchased with federal funds is utilized and maintained. The University identifies all equipment in its property management records with individually assigned asset numbers and each individual asset record includes the specific location of the asset, the federal award general ledger account number that funded the purchase of the asset, and other required information. An asset tag with the assigned asset number is affixed to each asset in accordance with University policy. During our physical observation of 60 pieces of equipment purchased with R&D Cluster funds (with a total cost value of $1,542,384), we noted the following: - Nine items (with a total cost value of $200,035) did not have property management tags affixed at the time of our observation. - Eight items (with a total cost value of $103,583) had property management tags with asset numbers that were inconsistent with the equipment listing. Upon further review, we noted the property management records contained a temporary asset tag number that had not been updated for the permanent tag subsequently affixed by department personnel. Further, we noted adequate management review controls had not been established to ensure property management records were accurately updated and equipment was properly tagged. The net book value of equipment related to the R&D Cluster program totaled $217,101,257 at June 30, 2022. Criteria: According to 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, 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. In addition, 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. Effective internal controls should include procedures to ensure that accurate property records are maintained and equipment items are properly tagged. Cause: In discussing these conditions with University officials, they stated the University?s procedures for tagging equipment were delayed because the University?s personnel operated in a remote environment during fiscal years 2021 and 2022. Additionally, physical inventory procedures, which are designed detect differences between perpetual and actual information, were waived during fiscal years 2020 and 2021 as a result of the pandemic. Possible Asserted Effect: Failure to maintain accurate property records may prohibit the University from properly safeguarding and maintaining equipment and may result in federal programs not receiving the appropriate share of proceeds from the disposals of equipment purchased with federal funds. Repeat Finding: A similar finding was not reported in the prior year audit. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend the University review its procedures for updating property records to ensure they accurately reflect equipment information. We also recommend the University properly tag equipment in accordance with its policy. Views of University Officials: The University agrees with the finding. All departments of the University will be reminded that tagging is an integral part of the internal control process for capital assets and training will be made available before June 30, 2023.
Finding 2022 002: Inaccurate Property Management Records Federal Agency: U.S. Department of Agriculture (USDA) U.S. Department of Commerce (USDOC) U.S. Department of Defense (USDOD) U.S. Director of National Intelligence (USDNI) U.S. Department of Housing and Urban Development (USHUD) U.S. Department of Interior (USDOI) U.S. Department of Justice (USDOJ) U.S. Department of Transportation (USDOT) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) U.S. Environmental Protection Agency (USEPA) U.S. Department of Energy (USDOE) U.S. Department of Education (USDE) Smithsonian Institution U.S. Department of Health and Human Services (USDHHS) Corporation for National and Community Service All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($482,298,931) Federal Award Numbers: Various ? See schedule of award numbers Federal Award Year: Various ? See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Condition Found: The University did not consistently follow its property management policies and procedures related to equipment purchased with federal funding from the Research and Development (R&D) Cluster program. The University conducts research at multiple locations throughout their campus, where equipment purchased with federal funds is utilized and maintained. The University identifies all equipment in its property management records with individually assigned asset numbers and each individual asset record includes the specific location of the asset, the federal award general ledger account number that funded the purchase of the asset, and other required information. An asset tag with the assigned asset number is affixed to each asset in accordance with University policy. During our physical observation of 60 pieces of equipment purchased with R&D Cluster funds (with a total cost value of $1,542,384), we noted the following: - Nine items (with a total cost value of $200,035) did not have property management tags affixed at the time of our observation. - Eight items (with a total cost value of $103,583) had property management tags with asset numbers that were inconsistent with the equipment listing. Upon further review, we noted the property management records contained a temporary asset tag number that had not been updated for the permanent tag subsequently affixed by department personnel. Further, we noted adequate management review controls had not been established to ensure property management records were accurately updated and equipment was properly tagged. The net book value of equipment related to the R&D Cluster program totaled $217,101,257 at June 30, 2022. Criteria: According to 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, 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. In addition, 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. Effective internal controls should include procedures to ensure that accurate property records are maintained and equipment items are properly tagged. Cause: In discussing these conditions with University officials, they stated the University?s procedures for tagging equipment were delayed because the University?s personnel operated in a remote environment during fiscal years 2021 and 2022. Additionally, physical inventory procedures, which are designed detect differences between perpetual and actual information, were waived during fiscal years 2020 and 2021 as a result of the pandemic. Possible Asserted Effect: Failure to maintain accurate property records may prohibit the University from properly safeguarding and maintaining equipment and may result in federal programs not receiving the appropriate share of proceeds from the disposals of equipment purchased with federal funds. Repeat Finding: A similar finding was not reported in the prior year audit. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend the University review its procedures for updating property records to ensure they accurately reflect equipment information. We also recommend the University properly tag equipment in accordance with its policy. Views of University Officials: The University agrees with the finding. All departments of the University will be reminded that tagging is an integral part of the internal control process for capital assets and training will be made available before June 30, 2023.
Finding 2022 002: Inaccurate Property Management Records Federal Agency: U.S. Department of Agriculture (USDA) U.S. Department of Commerce (USDOC) U.S. Department of Defense (USDOD) U.S. Director of National Intelligence (USDNI) U.S. Department of Housing and Urban Development (USHUD) U.S. Department of Interior (USDOI) U.S. Department of Justice (USDOJ) U.S. Department of Transportation (USDOT) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) U.S. Environmental Protection Agency (USEPA) U.S. Department of Energy (USDOE) U.S. Department of Education (USDE) Smithsonian Institution U.S. Department of Health and Human Services (USDHHS) Corporation for National and Community Service All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($482,298,931) Federal Award Numbers: Various ? See schedule of award numbers Federal Award Year: Various ? See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Condition Found: The University did not consistently follow its property management policies and procedures related to equipment purchased with federal funding from the Research and Development (R&D) Cluster program. The University conducts research at multiple locations throughout their campus, where equipment purchased with federal funds is utilized and maintained. The University identifies all equipment in its property management records with individually assigned asset numbers and each individual asset record includes the specific location of the asset, the federal award general ledger account number that funded the purchase of the asset, and other required information. An asset tag with the assigned asset number is affixed to each asset in accordance with University policy. During our physical observation of 60 pieces of equipment purchased with R&D Cluster funds (with a total cost value of $1,542,384), we noted the following: - Nine items (with a total cost value of $200,035) did not have property management tags affixed at the time of our observation. - Eight items (with a total cost value of $103,583) had property management tags with asset numbers that were inconsistent with the equipment listing. Upon further review, we noted the property management records contained a temporary asset tag number that had not been updated for the permanent tag subsequently affixed by department personnel. Further, we noted adequate management review controls had not been established to ensure property management records were accurately updated and equipment was properly tagged. The net book value of equipment related to the R&D Cluster program totaled $217,101,257 at June 30, 2022. Criteria: According to 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, 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. In addition, 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. Effective internal controls should include procedures to ensure that accurate property records are maintained and equipment items are properly tagged. Cause: In discussing these conditions with University officials, they stated the University?s procedures for tagging equipment were delayed because the University?s personnel operated in a remote environment during fiscal years 2021 and 2022. Additionally, physical inventory procedures, which are designed detect differences between perpetual and actual information, were waived during fiscal years 2020 and 2021 as a result of the pandemic. Possible Asserted Effect: Failure to maintain accurate property records may prohibit the University from properly safeguarding and maintaining equipment and may result in federal programs not receiving the appropriate share of proceeds from the disposals of equipment purchased with federal funds. Repeat Finding: A similar finding was not reported in the prior year audit. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend the University review its procedures for updating property records to ensure they accurately reflect equipment information. We also recommend the University properly tag equipment in accordance with its policy. Views of University Officials: The University agrees with the finding. All departments of the University will be reminded that tagging is an integral part of the internal control process for capital assets and training will be made available before June 30, 2023.
Finding 2022 002: Inaccurate Property Management Records Federal Agency: U.S. Department of Agriculture (USDA) U.S. Department of Commerce (USDOC) U.S. Department of Defense (USDOD) U.S. Director of National Intelligence (USDNI) U.S. Department of Housing and Urban Development (USHUD) U.S. Department of Interior (USDOI) U.S. Department of Justice (USDOJ) U.S. Department of Transportation (USDOT) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) U.S. Environmental Protection Agency (USEPA) U.S. Department of Energy (USDOE) U.S. Department of Education (USDE) Smithsonian Institution U.S. Department of Health and Human Services (USDHHS) Corporation for National and Community Service All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($482,298,931) Federal Award Numbers: Various ? See schedule of award numbers Federal Award Year: Various ? See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Condition Found: The University did not consistently follow its property management policies and procedures related to equipment purchased with federal funding from the Research and Development (R&D) Cluster program. The University conducts research at multiple locations throughout their campus, where equipment purchased with federal funds is utilized and maintained. The University identifies all equipment in its property management records with individually assigned asset numbers and each individual asset record includes the specific location of the asset, the federal award general ledger account number that funded the purchase of the asset, and other required information. An asset tag with the assigned asset number is affixed to each asset in accordance with University policy. During our physical observation of 60 pieces of equipment purchased with R&D Cluster funds (with a total cost value of $1,542,384), we noted the following: - Nine items (with a total cost value of $200,035) did not have property management tags affixed at the time of our observation. - Eight items (with a total cost value of $103,583) had property management tags with asset numbers that were inconsistent with the equipment listing. Upon further review, we noted the property management records contained a temporary asset tag number that had not been updated for the permanent tag subsequently affixed by department personnel. Further, we noted adequate management review controls had not been established to ensure property management records were accurately updated and equipment was properly tagged. The net book value of equipment related to the R&D Cluster program totaled $217,101,257 at June 30, 2022. Criteria: According to 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, 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. In addition, 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. Effective internal controls should include procedures to ensure that accurate property records are maintained and equipment items are properly tagged. Cause: In discussing these conditions with University officials, they stated the University?s procedures for tagging equipment were delayed because the University?s personnel operated in a remote environment during fiscal years 2021 and 2022. Additionally, physical inventory procedures, which are designed detect differences between perpetual and actual information, were waived during fiscal years 2020 and 2021 as a result of the pandemic. Possible Asserted Effect: Failure to maintain accurate property records may prohibit the University from properly safeguarding and maintaining equipment and may result in federal programs not receiving the appropriate share of proceeds from the disposals of equipment purchased with federal funds. Repeat Finding: A similar finding was not reported in the prior year audit. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend the University review its procedures for updating property records to ensure they accurately reflect equipment information. We also recommend the University properly tag equipment in accordance with its policy. Views of University Officials: The University agrees with the finding. All departments of the University will be reminded that tagging is an integral part of the internal control process for capital assets and training will be made available before June 30, 2023.
Finding 2022 002: Inaccurate Property Management Records Federal Agency: U.S. Department of Agriculture (USDA) U.S. Department of Commerce (USDOC) U.S. Department of Defense (USDOD) U.S. Director of National Intelligence (USDNI) U.S. Department of Housing and Urban Development (USHUD) U.S. Department of Interior (USDOI) U.S. Department of Justice (USDOJ) U.S. Department of Transportation (USDOT) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) U.S. Environmental Protection Agency (USEPA) U.S. Department of Energy (USDOE) U.S. Department of Education (USDE) Smithsonian Institution U.S. Department of Health and Human Services (USDHHS) Corporation for National and Community Service All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($482,298,931) Federal Award Numbers: Various ? See schedule of award numbers Federal Award Year: Various ? See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Condition Found: The University did not consistently follow its property management policies and procedures related to equipment purchased with federal funding from the Research and Development (R&D) Cluster program. The University conducts research at multiple locations throughout their campus, where equipment purchased with federal funds is utilized and maintained. The University identifies all equipment in its property management records with individually assigned asset numbers and each individual asset record includes the specific location of the asset, the federal award general ledger account number that funded the purchase of the asset, and other required information. An asset tag with the assigned asset number is affixed to each asset in accordance with University policy. During our physical observation of 60 pieces of equipment purchased with R&D Cluster funds (with a total cost value of $1,542,384), we noted the following: - Nine items (with a total cost value of $200,035) did not have property management tags affixed at the time of our observation. - Eight items (with a total cost value of $103,583) had property management tags with asset numbers that were inconsistent with the equipment listing. Upon further review, we noted the property management records contained a temporary asset tag number that had not been updated for the permanent tag subsequently affixed by department personnel. Further, we noted adequate management review controls had not been established to ensure property management records were accurately updated and equipment was properly tagged. The net book value of equipment related to the R&D Cluster program totaled $217,101,257 at June 30, 2022. Criteria: According to 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, 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. In addition, 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. Effective internal controls should include procedures to ensure that accurate property records are maintained and equipment items are properly tagged. Cause: In discussing these conditions with University officials, they stated the University?s procedures for tagging equipment were delayed because the University?s personnel operated in a remote environment during fiscal years 2021 and 2022. Additionally, physical inventory procedures, which are designed detect differences between perpetual and actual information, were waived during fiscal years 2020 and 2021 as a result of the pandemic. Possible Asserted Effect: Failure to maintain accurate property records may prohibit the University from properly safeguarding and maintaining equipment and may result in federal programs not receiving the appropriate share of proceeds from the disposals of equipment purchased with federal funds. Repeat Finding: A similar finding was not reported in the prior year audit. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend the University review its procedures for updating property records to ensure they accurately reflect equipment information. We also recommend the University properly tag equipment in accordance with its policy. Views of University Officials: The University agrees with the finding. All departments of the University will be reminded that tagging is an integral part of the internal control process for capital assets and training will be made available before June 30, 2023.
Finding 2022 002: Inaccurate Property Management Records Federal Agency: U.S. Department of Agriculture (USDA) U.S. Department of Commerce (USDOC) U.S. Department of Defense (USDOD) U.S. Director of National Intelligence (USDNI) U.S. Department of Housing and Urban Development (USHUD) U.S. Department of Interior (USDOI) U.S. Department of Justice (USDOJ) U.S. Department of Transportation (USDOT) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) U.S. Environmental Protection Agency (USEPA) U.S. Department of Energy (USDOE) U.S. Department of Education (USDE) Smithsonian Institution U.S. Department of Health and Human Services (USDHHS) Corporation for National and Community Service All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($482,298,931) Federal Award Numbers: Various ? See schedule of award numbers Federal Award Year: Various ? See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Condition Found: The University did not consistently follow its property management policies and procedures related to equipment purchased with federal funding from the Research and Development (R&D) Cluster program. The University conducts research at multiple locations throughout their campus, where equipment purchased with federal funds is utilized and maintained. The University identifies all equipment in its property management records with individually assigned asset numbers and each individual asset record includes the specific location of the asset, the federal award general ledger account number that funded the purchase of the asset, and other required information. An asset tag with the assigned asset number is affixed to each asset in accordance with University policy. During our physical observation of 60 pieces of equipment purchased with R&D Cluster funds (with a total cost value of $1,542,384), we noted the following: - Nine items (with a total cost value of $200,035) did not have property management tags affixed at the time of our observation. - Eight items (with a total cost value of $103,583) had property management tags with asset numbers that were inconsistent with the equipment listing. Upon further review, we noted the property management records contained a temporary asset tag number that had not been updated for the permanent tag subsequently affixed by department personnel. Further, we noted adequate management review controls had not been established to ensure property management records were accurately updated and equipment was properly tagged. The net book value of equipment related to the R&D Cluster program totaled $217,101,257 at June 30, 2022. Criteria: According to 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, 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. In addition, 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. Effective internal controls should include procedures to ensure that accurate property records are maintained and equipment items are properly tagged. Cause: In discussing these conditions with University officials, they stated the University?s procedures for tagging equipment were delayed because the University?s personnel operated in a remote environment during fiscal years 2021 and 2022. Additionally, physical inventory procedures, which are designed detect differences between perpetual and actual information, were waived during fiscal years 2020 and 2021 as a result of the pandemic. Possible Asserted Effect: Failure to maintain accurate property records may prohibit the University from properly safeguarding and maintaining equipment and may result in federal programs not receiving the appropriate share of proceeds from the disposals of equipment purchased with federal funds. Repeat Finding: A similar finding was not reported in the prior year audit. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend the University review its procedures for updating property records to ensure they accurately reflect equipment information. We also recommend the University properly tag equipment in accordance with its policy. Views of University Officials: The University agrees with the finding. All departments of the University will be reminded that tagging is an integral part of the internal control process for capital assets and training will be made available before June 30, 2023.
Finding 2022 002: Inaccurate Property Management Records Federal Agency: U.S. Department of Agriculture (USDA) U.S. Department of Commerce (USDOC) U.S. Department of Defense (USDOD) U.S. Director of National Intelligence (USDNI) U.S. Department of Housing and Urban Development (USHUD) U.S. Department of Interior (USDOI) U.S. Department of Justice (USDOJ) U.S. Department of Transportation (USDOT) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) U.S. Environmental Protection Agency (USEPA) U.S. Department of Energy (USDOE) U.S. Department of Education (USDE) Smithsonian Institution U.S. Department of Health and Human Services (USDHHS) Corporation for National and Community Service All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($482,298,931) Federal Award Numbers: Various ? See schedule of award numbers Federal Award Year: Various ? See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Condition Found: The University did not consistently follow its property management policies and procedures related to equipment purchased with federal funding from the Research and Development (R&D) Cluster program. The University conducts research at multiple locations throughout their campus, where equipment purchased with federal funds is utilized and maintained. The University identifies all equipment in its property management records with individually assigned asset numbers and each individual asset record includes the specific location of the asset, the federal award general ledger account number that funded the purchase of the asset, and other required information. An asset tag with the assigned asset number is affixed to each asset in accordance with University policy. During our physical observation of 60 pieces of equipment purchased with R&D Cluster funds (with a total cost value of $1,542,384), we noted the following: - Nine items (with a total cost value of $200,035) did not have property management tags affixed at the time of our observation. - Eight items (with a total cost value of $103,583) had property management tags with asset numbers that were inconsistent with the equipment listing. Upon further review, we noted the property management records contained a temporary asset tag number that had not been updated for the permanent tag subsequently affixed by department personnel. Further, we noted adequate management review controls had not been established to ensure property management records were accurately updated and equipment was properly tagged. The net book value of equipment related to the R&D Cluster program totaled $217,101,257 at June 30, 2022. Criteria: According to 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, 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. In addition, 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. Effective internal controls should include procedures to ensure that accurate property records are maintained and equipment items are properly tagged. Cause: In discussing these conditions with University officials, they stated the University?s procedures for tagging equipment were delayed because the University?s personnel operated in a remote environment during fiscal years 2021 and 2022. Additionally, physical inventory procedures, which are designed detect differences between perpetual and actual information, were waived during fiscal years 2020 and 2021 as a result of the pandemic. Possible Asserted Effect: Failure to maintain accurate property records may prohibit the University from properly safeguarding and maintaining equipment and may result in federal programs not receiving the appropriate share of proceeds from the disposals of equipment purchased with federal funds. Repeat Finding: A similar finding was not reported in the prior year audit. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend the University review its procedures for updating property records to ensure they accurately reflect equipment information. We also recommend the University properly tag equipment in accordance with its policy. Views of University Officials: The University agrees with the finding. All departments of the University will be reminded that tagging is an integral part of the internal control process for capital assets and training will be made available before June 30, 2023.
Finding 2022 002: Inaccurate Property Management Records Federal Agency: U.S. Department of Agriculture (USDA) U.S. Department of Commerce (USDOC) U.S. Department of Defense (USDOD) U.S. Director of National Intelligence (USDNI) U.S. Department of Housing and Urban Development (USHUD) U.S. Department of Interior (USDOI) U.S. Department of Justice (USDOJ) U.S. Department of Transportation (USDOT) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) U.S. Environmental Protection Agency (USEPA) U.S. Department of Energy (USDOE) U.S. Department of Education (USDE) Smithsonian Institution U.S. Department of Health and Human Services (USDHHS) Corporation for National and Community Service All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($482,298,931) Federal Award Numbers: Various ? See schedule of award numbers Federal Award Year: Various ? See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Condition Found: The University did not consistently follow its property management policies and procedures related to equipment purchased with federal funding from the Research and Development (R&D) Cluster program. The University conducts research at multiple locations throughout their campus, where equipment purchased with federal funds is utilized and maintained. The University identifies all equipment in its property management records with individually assigned asset numbers and each individual asset record includes the specific location of the asset, the federal award general ledger account number that funded the purchase of the asset, and other required information. An asset tag with the assigned asset number is affixed to each asset in accordance with University policy. During our physical observation of 60 pieces of equipment purchased with R&D Cluster funds (with a total cost value of $1,542,384), we noted the following: - Nine items (with a total cost value of $200,035) did not have property management tags affixed at the time of our observation. - Eight items (with a total cost value of $103,583) had property management tags with asset numbers that were inconsistent with the equipment listing. Upon further review, we noted the property management records contained a temporary asset tag number that had not been updated for the permanent tag subsequently affixed by department personnel. Further, we noted adequate management review controls had not been established to ensure property management records were accurately updated and equipment was properly tagged. The net book value of equipment related to the R&D Cluster program totaled $217,101,257 at June 30, 2022. Criteria: According to 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, 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. In addition, 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. Effective internal controls should include procedures to ensure that accurate property records are maintained and equipment items are properly tagged. Cause: In discussing these conditions with University officials, they stated the University?s procedures for tagging equipment were delayed because the University?s personnel operated in a remote environment during fiscal years 2021 and 2022. Additionally, physical inventory procedures, which are designed detect differences between perpetual and actual information, were waived during fiscal years 2020 and 2021 as a result of the pandemic. Possible Asserted Effect: Failure to maintain accurate property records may prohibit the University from properly safeguarding and maintaining equipment and may result in federal programs not receiving the appropriate share of proceeds from the disposals of equipment purchased with federal funds. Repeat Finding: A similar finding was not reported in the prior year audit. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend the University review its procedures for updating property records to ensure they accurately reflect equipment information. We also recommend the University properly tag equipment in accordance with its policy. Views of University Officials: The University agrees with the finding. All departments of the University will be reminded that tagging is an integral part of the internal control process for capital assets and training will be made available before June 30, 2023.
Finding 2022 002: Inaccurate Property Management Records Federal Agency: U.S. Department of Agriculture (USDA) U.S. Department of Commerce (USDOC) U.S. Department of Defense (USDOD) U.S. Director of National Intelligence (USDNI) U.S. Department of Housing and Urban Development (USHUD) U.S. Department of Interior (USDOI) U.S. Department of Justice (USDOJ) U.S. Department of Transportation (USDOT) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) U.S. Environmental Protection Agency (USEPA) U.S. Department of Energy (USDOE) U.S. Department of Education (USDE) Smithsonian Institution U.S. Department of Health and Human Services (USDHHS) Corporation for National and Community Service All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($482,298,931) Federal Award Numbers: Various ? See schedule of award numbers Federal Award Year: Various ? See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Condition Found: The University did not consistently follow its property management policies and procedures related to equipment purchased with federal funding from the Research and Development (R&D) Cluster program. The University conducts research at multiple locations throughout their campus, where equipment purchased with federal funds is utilized and maintained. The University identifies all equipment in its property management records with individually assigned asset numbers and each individual asset record includes the specific location of the asset, the federal award general ledger account number that funded the purchase of the asset, and other required information. An asset tag with the assigned asset number is affixed to each asset in accordance with University policy. During our physical observation of 60 pieces of equipment purchased with R&D Cluster funds (with a total cost value of $1,542,384), we noted the following: - Nine items (with a total cost value of $200,035) did not have property management tags affixed at the time of our observation. - Eight items (with a total cost value of $103,583) had property management tags with asset numbers that were inconsistent with the equipment listing. Upon further review, we noted the property management records contained a temporary asset tag number that had not been updated for the permanent tag subsequently affixed by department personnel. Further, we noted adequate management review controls had not been established to ensure property management records were accurately updated and equipment was properly tagged. The net book value of equipment related to the R&D Cluster program totaled $217,101,257 at June 30, 2022. Criteria: According to 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, 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. In addition, 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. Effective internal controls should include procedures to ensure that accurate property records are maintained and equipment items are properly tagged. Cause: In discussing these conditions with University officials, they stated the University?s procedures for tagging equipment were delayed because the University?s personnel operated in a remote environment during fiscal years 2021 and 2022. Additionally, physical inventory procedures, which are designed detect differences between perpetual and actual information, were waived during fiscal years 2020 and 2021 as a result of the pandemic. Possible Asserted Effect: Failure to maintain accurate property records may prohibit the University from properly safeguarding and maintaining equipment and may result in federal programs not receiving the appropriate share of proceeds from the disposals of equipment purchased with federal funds. Repeat Finding: A similar finding was not reported in the prior year audit. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend the University review its procedures for updating property records to ensure they accurately reflect equipment information. We also recommend the University properly tag equipment in accordance with its policy. Views of University Officials: The University agrees with the finding. All departments of the University will be reminded that tagging is an integral part of the internal control process for capital assets and training will be made available before June 30, 2023.
Finding 2022 002: Inaccurate Property Management Records Federal Agency: U.S. Department of Agriculture (USDA) U.S. Department of Commerce (USDOC) U.S. Department of Defense (USDOD) U.S. Director of National Intelligence (USDNI) U.S. Department of Housing and Urban Development (USHUD) U.S. Department of Interior (USDOI) U.S. Department of Justice (USDOJ) U.S. Department of Transportation (USDOT) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) U.S. Environmental Protection Agency (USEPA) U.S. Department of Energy (USDOE) U.S. Department of Education (USDE) Smithsonian Institution U.S. Department of Health and Human Services (USDHHS) Corporation for National and Community Service All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($482,298,931) Federal Award Numbers: Various ? See schedule of award numbers Federal Award Year: Various ? See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Condition Found: The University did not consistently follow its property management policies and procedures related to equipment purchased with federal funding from the Research and Development (R&D) Cluster program. The University conducts research at multiple locations throughout their campus, where equipment purchased with federal funds is utilized and maintained. The University identifies all equipment in its property management records with individually assigned asset numbers and each individual asset record includes the specific location of the asset, the federal award general ledger account number that funded the purchase of the asset, and other required information. An asset tag with the assigned asset number is affixed to each asset in accordance with University policy. During our physical observation of 60 pieces of equipment purchased with R&D Cluster funds (with a total cost value of $1,542,384), we noted the following: - Nine items (with a total cost value of $200,035) did not have property management tags affixed at the time of our observation. - Eight items (with a total cost value of $103,583) had property management tags with asset numbers that were inconsistent with the equipment listing. Upon further review, we noted the property management records contained a temporary asset tag number that had not been updated for the permanent tag subsequently affixed by department personnel. Further, we noted adequate management review controls had not been established to ensure property management records were accurately updated and equipment was properly tagged. The net book value of equipment related to the R&D Cluster program totaled $217,101,257 at June 30, 2022. Criteria: According to 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, 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. In addition, 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. Effective internal controls should include procedures to ensure that accurate property records are maintained and equipment items are properly tagged. Cause: In discussing these conditions with University officials, they stated the University?s procedures for tagging equipment were delayed because the University?s personnel operated in a remote environment during fiscal years 2021 and 2022. Additionally, physical inventory procedures, which are designed detect differences between perpetual and actual information, were waived during fiscal years 2020 and 2021 as a result of the pandemic. Possible Asserted Effect: Failure to maintain accurate property records may prohibit the University from properly safeguarding and maintaining equipment and may result in federal programs not receiving the appropriate share of proceeds from the disposals of equipment purchased with federal funds. Repeat Finding: A similar finding was not reported in the prior year audit. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend the University review its procedures for updating property records to ensure they accurately reflect equipment information. We also recommend the University properly tag equipment in accordance with its policy. Views of University Officials: The University agrees with the finding. All departments of the University will be reminded that tagging is an integral part of the internal control process for capital assets and training will be made available before June 30, 2023.
Finding 2022 002: Inaccurate Property Management Records Federal Agency: U.S. Department of Agriculture (USDA) U.S. Department of Commerce (USDOC) U.S. Department of Defense (USDOD) U.S. Director of National Intelligence (USDNI) U.S. Department of Housing and Urban Development (USHUD) U.S. Department of Interior (USDOI) U.S. Department of Justice (USDOJ) U.S. Department of Transportation (USDOT) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) U.S. Environmental Protection Agency (USEPA) U.S. Department of Energy (USDOE) U.S. Department of Education (USDE) Smithsonian Institution U.S. Department of Health and Human Services (USDHHS) Corporation for National and Community Service All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($482,298,931) Federal Award Numbers: Various ? See schedule of award numbers Federal Award Year: Various ? See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Condition Found: The University did not consistently follow its property management policies and procedures related to equipment purchased with federal funding from the Research and Development (R&D) Cluster program. The University conducts research at multiple locations throughout their campus, where equipment purchased with federal funds is utilized and maintained. The University identifies all equipment in its property management records with individually assigned asset numbers and each individual asset record includes the specific location of the asset, the federal award general ledger account number that funded the purchase of the asset, and other required information. An asset tag with the assigned asset number is affixed to each asset in accordance with University policy. During our physical observation of 60 pieces of equipment purchased with R&D Cluster funds (with a total cost value of $1,542,384), we noted the following: - Nine items (with a total cost value of $200,035) did not have property management tags affixed at the time of our observation. - Eight items (with a total cost value of $103,583) had property management tags with asset numbers that were inconsistent with the equipment listing. Upon further review, we noted the property management records contained a temporary asset tag number that had not been updated for the permanent tag subsequently affixed by department personnel. Further, we noted adequate management review controls had not been established to ensure property management records were accurately updated and equipment was properly tagged. The net book value of equipment related to the R&D Cluster program totaled $217,101,257 at June 30, 2022. Criteria: According to 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, 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. In addition, 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. Effective internal controls should include procedures to ensure that accurate property records are maintained and equipment items are properly tagged. Cause: In discussing these conditions with University officials, they stated the University?s procedures for tagging equipment were delayed because the University?s personnel operated in a remote environment during fiscal years 2021 and 2022. Additionally, physical inventory procedures, which are designed detect differences between perpetual and actual information, were waived during fiscal years 2020 and 2021 as a result of the pandemic. Possible Asserted Effect: Failure to maintain accurate property records may prohibit the University from properly safeguarding and maintaining equipment and may result in federal programs not receiving the appropriate share of proceeds from the disposals of equipment purchased with federal funds. Repeat Finding: A similar finding was not reported in the prior year audit. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend the University review its procedures for updating property records to ensure they accurately reflect equipment information. We also recommend the University properly tag equipment in accordance with its policy. Views of University Officials: The University agrees with the finding. All departments of the University will be reminded that tagging is an integral part of the internal control process for capital assets and training will be made available before June 30, 2023.
Finding 2022 002: Inaccurate Property Management Records Federal Agency: U.S. Department of Agriculture (USDA) U.S. Department of Commerce (USDOC) U.S. Department of Defense (USDOD) U.S. Director of National Intelligence (USDNI) U.S. Department of Housing and Urban Development (USHUD) U.S. Department of Interior (USDOI) U.S. Department of Justice (USDOJ) U.S. Department of Transportation (USDOT) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) U.S. Environmental Protection Agency (USEPA) U.S. Department of Energy (USDOE) U.S. Department of Education (USDE) Smithsonian Institution U.S. Department of Health and Human Services (USDHHS) Corporation for National and Community Service All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($482,298,931) Federal Award Numbers: Various ? See schedule of award numbers Federal Award Year: Various ? See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Condition Found: The University did not consistently follow its property management policies and procedures related to equipment purchased with federal funding from the Research and Development (R&D) Cluster program. The University conducts research at multiple locations throughout their campus, where equipment purchased with federal funds is utilized and maintained. The University identifies all equipment in its property management records with individually assigned asset numbers and each individual asset record includes the specific location of the asset, the federal award general ledger account number that funded the purchase of the asset, and other required information. An asset tag with the assigned asset number is affixed to each asset in accordance with University policy. During our physical observation of 60 pieces of equipment purchased with R&D Cluster funds (with a total cost value of $1,542,384), we noted the following: - Nine items (with a total cost value of $200,035) did not have property management tags affixed at the time of our observation. - Eight items (with a total cost value of $103,583) had property management tags with asset numbers that were inconsistent with the equipment listing. Upon further review, we noted the property management records contained a temporary asset tag number that had not been updated for the permanent tag subsequently affixed by department personnel. Further, we noted adequate management review controls had not been established to ensure property management records were accurately updated and equipment was properly tagged. The net book value of equipment related to the R&D Cluster program totaled $217,101,257 at June 30, 2022. Criteria: According to 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, 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. In addition, 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. Effective internal controls should include procedures to ensure that accurate property records are maintained and equipment items are properly tagged. Cause: In discussing these conditions with University officials, they stated the University?s procedures for tagging equipment were delayed because the University?s personnel operated in a remote environment during fiscal years 2021 and 2022. Additionally, physical inventory procedures, which are designed detect differences between perpetual and actual information, were waived during fiscal years 2020 and 2021 as a result of the pandemic. Possible Asserted Effect: Failure to maintain accurate property records may prohibit the University from properly safeguarding and maintaining equipment and may result in federal programs not receiving the appropriate share of proceeds from the disposals of equipment purchased with federal funds. Repeat Finding: A similar finding was not reported in the prior year audit. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend the University review its procedures for updating property records to ensure they accurately reflect equipment information. We also recommend the University properly tag equipment in accordance with its policy. Views of University Officials: The University agrees with the finding. All departments of the University will be reminded that tagging is an integral part of the internal control process for capital assets and training will be made available before June 30, 2023.
Finding 2022 002: Inaccurate Property Management Records Federal Agency: U.S. Department of Agriculture (USDA) U.S. Department of Commerce (USDOC) U.S. Department of Defense (USDOD) U.S. Director of National Intelligence (USDNI) U.S. Department of Housing and Urban Development (USHUD) U.S. Department of Interior (USDOI) U.S. Department of Justice (USDOJ) U.S. Department of Transportation (USDOT) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) U.S. Environmental Protection Agency (USEPA) U.S. Department of Energy (USDOE) U.S. Department of Education (USDE) Smithsonian Institution U.S. Department of Health and Human Services (USDHHS) Corporation for National and Community Service All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($482,298,931) Federal Award Numbers: Various ? See schedule of award numbers Federal Award Year: Various ? See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Condition Found: The University did not consistently follow its property management policies and procedures related to equipment purchased with federal funding from the Research and Development (R&D) Cluster program. The University conducts research at multiple locations throughout their campus, where equipment purchased with federal funds is utilized and maintained. The University identifies all equipment in its property management records with individually assigned asset numbers and each individual asset record includes the specific location of the asset, the federal award general ledger account number that funded the purchase of the asset, and other required information. An asset tag with the assigned asset number is affixed to each asset in accordance with University policy. During our physical observation of 60 pieces of equipment purchased with R&D Cluster funds (with a total cost value of $1,542,384), we noted the following: - Nine items (with a total cost value of $200,035) did not have property management tags affixed at the time of our observation. - Eight items (with a total cost value of $103,583) had property management tags with asset numbers that were inconsistent with the equipment listing. Upon further review, we noted the property management records contained a temporary asset tag number that had not been updated for the permanent tag subsequently affixed by department personnel. Further, we noted adequate management review controls had not been established to ensure property management records were accurately updated and equipment was properly tagged. The net book value of equipment related to the R&D Cluster program totaled $217,101,257 at June 30, 2022. Criteria: According to 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, 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. In addition, 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. Effective internal controls should include procedures to ensure that accurate property records are maintained and equipment items are properly tagged. Cause: In discussing these conditions with University officials, they stated the University?s procedures for tagging equipment were delayed because the University?s personnel operated in a remote environment during fiscal years 2021 and 2022. Additionally, physical inventory procedures, which are designed detect differences between perpetual and actual information, were waived during fiscal years 2020 and 2021 as a result of the pandemic. Possible Asserted Effect: Failure to maintain accurate property records may prohibit the University from properly safeguarding and maintaining equipment and may result in federal programs not receiving the appropriate share of proceeds from the disposals of equipment purchased with federal funds. Repeat Finding: A similar finding was not reported in the prior year audit. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend the University review its procedures for updating property records to ensure they accurately reflect equipment information. We also recommend the University properly tag equipment in accordance with its policy. Views of University Officials: The University agrees with the finding. All departments of the University will be reminded that tagging is an integral part of the internal control process for capital assets and training will be made available before June 30, 2023.
Finding 2022 002: Inaccurate Property Management Records Federal Agency: U.S. Department of Agriculture (USDA) U.S. Department of Commerce (USDOC) U.S. Department of Defense (USDOD) U.S. Director of National Intelligence (USDNI) U.S. Department of Housing and Urban Development (USHUD) U.S. Department of Interior (USDOI) U.S. Department of Justice (USDOJ) U.S. Department of Transportation (USDOT) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) U.S. Environmental Protection Agency (USEPA) U.S. Department of Energy (USDOE) U.S. Department of Education (USDE) Smithsonian Institution U.S. Department of Health and Human Services (USDHHS) Corporation for National and Community Service All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($482,298,931) Federal Award Numbers: Various ? See schedule of award numbers Federal Award Year: Various ? See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Condition Found: The University did not consistently follow its property management policies and procedures related to equipment purchased with federal funding from the Research and Development (R&D) Cluster program. The University conducts research at multiple locations throughout their campus, where equipment purchased with federal funds is utilized and maintained. The University identifies all equipment in its property management records with individually assigned asset numbers and each individual asset record includes the specific location of the asset, the federal award general ledger account number that funded the purchase of the asset, and other required information. An asset tag with the assigned asset number is affixed to each asset in accordance with University policy. During our physical observation of 60 pieces of equipment purchased with R&D Cluster funds (with a total cost value of $1,542,384), we noted the following: - Nine items (with a total cost value of $200,035) did not have property management tags affixed at the time of our observation. - Eight items (with a total cost value of $103,583) had property management tags with asset numbers that were inconsistent with the equipment listing. Upon further review, we noted the property management records contained a temporary asset tag number that had not been updated for the permanent tag subsequently affixed by department personnel. Further, we noted adequate management review controls had not been established to ensure property management records were accurately updated and equipment was properly tagged. The net book value of equipment related to the R&D Cluster program totaled $217,101,257 at June 30, 2022. Criteria: According to 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, 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. In addition, 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. Effective internal controls should include procedures to ensure that accurate property records are maintained and equipment items are properly tagged. Cause: In discussing these conditions with University officials, they stated the University?s procedures for tagging equipment were delayed because the University?s personnel operated in a remote environment during fiscal years 2021 and 2022. Additionally, physical inventory procedures, which are designed detect differences between perpetual and actual information, were waived during fiscal years 2020 and 2021 as a result of the pandemic. Possible Asserted Effect: Failure to maintain accurate property records may prohibit the University from properly safeguarding and maintaining equipment and may result in federal programs not receiving the appropriate share of proceeds from the disposals of equipment purchased with federal funds. Repeat Finding: A similar finding was not reported in the prior year audit. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend the University review its procedures for updating property records to ensure they accurately reflect equipment information. We also recommend the University properly tag equipment in accordance with its policy. Views of University Officials: The University agrees with the finding. All departments of the University will be reminded that tagging is an integral part of the internal control process for capital assets and training will be made available before June 30, 2023.
Finding 2022 002: Inaccurate Property Management Records Federal Agency: U.S. Department of Agriculture (USDA) U.S. Department of Commerce (USDOC) U.S. Department of Defense (USDOD) U.S. Director of National Intelligence (USDNI) U.S. Department of Housing and Urban Development (USHUD) U.S. Department of Interior (USDOI) U.S. Department of Justice (USDOJ) U.S. Department of Transportation (USDOT) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) U.S. Environmental Protection Agency (USEPA) U.S. Department of Energy (USDOE) U.S. Department of Education (USDE) Smithsonian Institution U.S. Department of Health and Human Services (USDHHS) Corporation for National and Community Service All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($482,298,931) Federal Award Numbers: Various ? See schedule of award numbers Federal Award Year: Various ? See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Condition Found: The University did not consistently follow its property management policies and procedures related to equipment purchased with federal funding from the Research and Development (R&D) Cluster program. The University conducts research at multiple locations throughout their campus, where equipment purchased with federal funds is utilized and maintained. The University identifies all equipment in its property management records with individually assigned asset numbers and each individual asset record includes the specific location of the asset, the federal award general ledger account number that funded the purchase of the asset, and other required information. An asset tag with the assigned asset number is affixed to each asset in accordance with University policy. During our physical observation of 60 pieces of equipment purchased with R&D Cluster funds (with a total cost value of $1,542,384), we noted the following: - Nine items (with a total cost value of $200,035) did not have property management tags affixed at the time of our observation. - Eight items (with a total cost value of $103,583) had property management tags with asset numbers that were inconsistent with the equipment listing. Upon further review, we noted the property management records contained a temporary asset tag number that had not been updated for the permanent tag subsequently affixed by department personnel. Further, we noted adequate management review controls had not been established to ensure property management records were accurately updated and equipment was properly tagged. The net book value of equipment related to the R&D Cluster program totaled $217,101,257 at June 30, 2022. Criteria: According to 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, 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. In addition, 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. Effective internal controls should include procedures to ensure that accurate property records are maintained and equipment items are properly tagged. Cause: In discussing these conditions with University officials, they stated the University?s procedures for tagging equipment were delayed because the University?s personnel operated in a remote environment during fiscal years 2021 and 2022. Additionally, physical inventory procedures, which are designed detect differences between perpetual and actual information, were waived during fiscal years 2020 and 2021 as a result of the pandemic. Possible Asserted Effect: Failure to maintain accurate property records may prohibit the University from properly safeguarding and maintaining equipment and may result in federal programs not receiving the appropriate share of proceeds from the disposals of equipment purchased with federal funds. Repeat Finding: A similar finding was not reported in the prior year audit. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend the University review its procedures for updating property records to ensure they accurately reflect equipment information. We also recommend the University properly tag equipment in accordance with its policy. Views of University Officials: The University agrees with the finding. All departments of the University will be reminded that tagging is an integral part of the internal control process for capital assets and training will be made available before June 30, 2023.
Finding 2022 002: Inaccurate Property Management Records Federal Agency: U.S. Department of Agriculture (USDA) U.S. Department of Commerce (USDOC) U.S. Department of Defense (USDOD) U.S. Director of National Intelligence (USDNI) U.S. Department of Housing and Urban Development (USHUD) U.S. Department of Interior (USDOI) U.S. Department of Justice (USDOJ) U.S. Department of Transportation (USDOT) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) U.S. Environmental Protection Agency (USEPA) U.S. Department of Energy (USDOE) U.S. Department of Education (USDE) Smithsonian Institution U.S. Department of Health and Human Services (USDHHS) Corporation for National and Community Service All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($482,298,931) Federal Award Numbers: Various ? See schedule of award numbers Federal Award Year: Various ? See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Condition Found: The University did not consistently follow its property management policies and procedures related to equipment purchased with federal funding from the Research and Development (R&D) Cluster program. The University conducts research at multiple locations throughout their campus, where equipment purchased with federal funds is utilized and maintained. The University identifies all equipment in its property management records with individually assigned asset numbers and each individual asset record includes the specific location of the asset, the federal award general ledger account number that funded the purchase of the asset, and other required information. An asset tag with the assigned asset number is affixed to each asset in accordance with University policy. During our physical observation of 60 pieces of equipment purchased with R&D Cluster funds (with a total cost value of $1,542,384), we noted the following: - Nine items (with a total cost value of $200,035) did not have property management tags affixed at the time of our observation. - Eight items (with a total cost value of $103,583) had property management tags with asset numbers that were inconsistent with the equipment listing. Upon further review, we noted the property management records contained a temporary asset tag number that had not been updated for the permanent tag subsequently affixed by department personnel. Further, we noted adequate management review controls had not been established to ensure property management records were accurately updated and equipment was properly tagged. The net book value of equipment related to the R&D Cluster program totaled $217,101,257 at June 30, 2022. Criteria: According to 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, 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. In addition, 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. Effective internal controls should include procedures to ensure that accurate property records are maintained and equipment items are properly tagged. Cause: In discussing these conditions with University officials, they stated the University?s procedures for tagging equipment were delayed because the University?s personnel operated in a remote environment during fiscal years 2021 and 2022. Additionally, physical inventory procedures, which are designed detect differences between perpetual and actual information, were waived during fiscal years 2020 and 2021 as a result of the pandemic. Possible Asserted Effect: Failure to maintain accurate property records may prohibit the University from properly safeguarding and maintaining equipment and may result in federal programs not receiving the appropriate share of proceeds from the disposals of equipment purchased with federal funds. Repeat Finding: A similar finding was not reported in the prior year audit. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend the University review its procedures for updating property records to ensure they accurately reflect equipment information. We also recommend the University properly tag equipment in accordance with its policy. Views of University Officials: The University agrees with the finding. All departments of the University will be reminded that tagging is an integral part of the internal control process for capital assets and training will be made available before June 30, 2023.
Finding 2022 002: Inaccurate Property Management Records Federal Agency: U.S. Department of Agriculture (USDA) U.S. Department of Commerce (USDOC) U.S. Department of Defense (USDOD) U.S. Director of National Intelligence (USDNI) U.S. Department of Housing and Urban Development (USHUD) U.S. Department of Interior (USDOI) U.S. Department of Justice (USDOJ) U.S. Department of Transportation (USDOT) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) U.S. Environmental Protection Agency (USEPA) U.S. Department of Energy (USDOE) U.S. Department of Education (USDE) Smithsonian Institution U.S. Department of Health and Human Services (USDHHS) Corporation for National and Community Service All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($482,298,931) Federal Award Numbers: Various ? See schedule of award numbers Federal Award Year: Various ? See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Condition Found: The University did not consistently follow its property management policies and procedures related to equipment purchased with federal funding from the Research and Development (R&D) Cluster program. The University conducts research at multiple locations throughout their campus, where equipment purchased with federal funds is utilized and maintained. The University identifies all equipment in its property management records with individually assigned asset numbers and each individual asset record includes the specific location of the asset, the federal award general ledger account number that funded the purchase of the asset, and other required information. An asset tag with the assigned asset number is affixed to each asset in accordance with University policy. During our physical observation of 60 pieces of equipment purchased with R&D Cluster funds (with a total cost value of $1,542,384), we noted the following: - Nine items (with a total cost value of $200,035) did not have property management tags affixed at the time of our observation. - Eight items (with a total cost value of $103,583) had property management tags with asset numbers that were inconsistent with the equipment listing. Upon further review, we noted the property management records contained a temporary asset tag number that had not been updated for the permanent tag subsequently affixed by department personnel. Further, we noted adequate management review controls had not been established to ensure property management records were accurately updated and equipment was properly tagged. The net book value of equipment related to the R&D Cluster program totaled $217,101,257 at June 30, 2022. Criteria: According to 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, 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. In addition, 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. Effective internal controls should include procedures to ensure that accurate property records are maintained and equipment items are properly tagged. Cause: In discussing these conditions with University officials, they stated the University?s procedures for tagging equipment were delayed because the University?s personnel operated in a remote environment during fiscal years 2021 and 2022. Additionally, physical inventory procedures, which are designed detect differences between perpetual and actual information, were waived during fiscal years 2020 and 2021 as a result of the pandemic. Possible Asserted Effect: Failure to maintain accurate property records may prohibit the University from properly safeguarding and maintaining equipment and may result in federal programs not receiving the appropriate share of proceeds from the disposals of equipment purchased with federal funds. Repeat Finding: A similar finding was not reported in the prior year audit. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend the University review its procedures for updating property records to ensure they accurately reflect equipment information. We also recommend the University properly tag equipment in accordance with its policy. Views of University Officials: The University agrees with the finding. All departments of the University will be reminded that tagging is an integral part of the internal control process for capital assets and training will be made available before June 30, 2023.