Finding 2023-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. Department of Education (USDE) U.S. Department of Energy (USDOE) U.S. Department of Health and Human Services (USDHHS) 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 State (USDOS) U.S. Department of Transportation (USDOT) U.S. Director of National Intelligence (USDNI) U.S. Environmental Protection Agency (USEPA) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($508,850,558) Federal Award Numbers: Various – See schedule of award numbers Federal Award Year: Various – See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Type of Finding: Noncompliance and material weakness Condition Found The University did not consistently follow its property management policies and procedures related to maintaining accurate property management records for equipment purchased with federal R&D Cluster program awards. The University conducts research at multiple locations throughout its campus where equipment purchased with federal awards 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 which 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. The University is required to safeguard equipment purchased with federal awards, maintain current property records, and to perform a physical inventory of equipment purchased with federal awards on a biennial basis. During our physical observation of 60 pieces of equipment (with a net book value (NBV) of $224,269) purchased with federal R&D Cluster awards, we noted eight items (with a NBV totaling $0) selected for physical observation were not able to be located for our testing. In response to the exceptions identified in our audit procedures, the University performed a physical inventory of all of its federally funded equipment in January 2024, which identified an additional 1,006 equipment items (with a NBV of $1,726,897) that could not be located, of which 839 were fully depreciated. University management believes these items were disposed of but not appropriately removed from the property records and federal equipment listing. As of June 30, 2023, the University’s federal equipment listing included 6,270 assets (with a NBV of $61,390,724) purchased with R&D Cluster program awards. We also noted the University’s controls for equipment dispositions are not operating at an appropriate level of precision to ensure equipment dispositions are properly authorized and property management records are updated on a timely basis. 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. Per 2 CFR 200.313(d)(3) and (4), a control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of property and adequate maintenance procedures must be developed to keep the property in good condition. 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 decentralized nature of the equipment recordkeeping process can result in delayed reporting of asset disposals. 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 reported in the prior year audit as finding number 2022-002. 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. Views of University Officials The University concurs with the finding and has begun to address these concerns. As noted in the finding, the University conducted a full federal equipment inventory in January 2024 and updated property records to ensure accuracy of federally funded equipment.
Finding 2023-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. Department of Education (USDE) U.S. Department of Energy (USDOE) U.S. Department of Health and Human Services (USDHHS) 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 State (USDOS) U.S. Department of Transportation (USDOT) U.S. Director of National Intelligence (USDNI) U.S. Environmental Protection Agency (USEPA) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($508,850,558) Federal Award Numbers: Various – See schedule of award numbers Federal Award Year: Various – See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Type of Finding: Noncompliance and material weakness Condition Found The University did not consistently follow its property management policies and procedures related to maintaining accurate property management records for equipment purchased with federal R&D Cluster program awards. The University conducts research at multiple locations throughout its campus where equipment purchased with federal awards 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 which 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. The University is required to safeguard equipment purchased with federal awards, maintain current property records, and to perform a physical inventory of equipment purchased with federal awards on a biennial basis. During our physical observation of 60 pieces of equipment (with a net book value (NBV) of $224,269) purchased with federal R&D Cluster awards, we noted eight items (with a NBV totaling $0) selected for physical observation were not able to be located for our testing. In response to the exceptions identified in our audit procedures, the University performed a physical inventory of all of its federally funded equipment in January 2024, which identified an additional 1,006 equipment items (with a NBV of $1,726,897) that could not be located, of which 839 were fully depreciated. University management believes these items were disposed of but not appropriately removed from the property records and federal equipment listing. As of June 30, 2023, the University’s federal equipment listing included 6,270 assets (with a NBV of $61,390,724) purchased with R&D Cluster program awards. We also noted the University’s controls for equipment dispositions are not operating at an appropriate level of precision to ensure equipment dispositions are properly authorized and property management records are updated on a timely basis. 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. Per 2 CFR 200.313(d)(3) and (4), a control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of property and adequate maintenance procedures must be developed to keep the property in good condition. 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 decentralized nature of the equipment recordkeeping process can result in delayed reporting of asset disposals. 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 reported in the prior year audit as finding number 2022-002. 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. Views of University Officials The University concurs with the finding and has begun to address these concerns. As noted in the finding, the University conducted a full federal equipment inventory in January 2024 and updated property records to ensure accuracy of federally funded equipment.
Finding 2023-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. Department of Education (USDE) U.S. Department of Energy (USDOE) U.S. Department of Health and Human Services (USDHHS) 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 State (USDOS) U.S. Department of Transportation (USDOT) U.S. Director of National Intelligence (USDNI) U.S. Environmental Protection Agency (USEPA) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($508,850,558) Federal Award Numbers: Various – See schedule of award numbers Federal Award Year: Various – See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Type of Finding: Noncompliance and material weakness Condition Found The University did not consistently follow its property management policies and procedures related to maintaining accurate property management records for equipment purchased with federal R&D Cluster program awards. The University conducts research at multiple locations throughout its campus where equipment purchased with federal awards 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 which 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. The University is required to safeguard equipment purchased with federal awards, maintain current property records, and to perform a physical inventory of equipment purchased with federal awards on a biennial basis. During our physical observation of 60 pieces of equipment (with a net book value (NBV) of $224,269) purchased with federal R&D Cluster awards, we noted eight items (with a NBV totaling $0) selected for physical observation were not able to be located for our testing. In response to the exceptions identified in our audit procedures, the University performed a physical inventory of all of its federally funded equipment in January 2024, which identified an additional 1,006 equipment items (with a NBV of $1,726,897) that could not be located, of which 839 were fully depreciated. University management believes these items were disposed of but not appropriately removed from the property records and federal equipment listing. As of June 30, 2023, the University’s federal equipment listing included 6,270 assets (with a NBV of $61,390,724) purchased with R&D Cluster program awards. We also noted the University’s controls for equipment dispositions are not operating at an appropriate level of precision to ensure equipment dispositions are properly authorized and property management records are updated on a timely basis. 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. Per 2 CFR 200.313(d)(3) and (4), a control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of property and adequate maintenance procedures must be developed to keep the property in good condition. 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 decentralized nature of the equipment recordkeeping process can result in delayed reporting of asset disposals. 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 reported in the prior year audit as finding number 2022-002. 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. Views of University Officials The University concurs with the finding and has begun to address these concerns. As noted in the finding, the University conducted a full federal equipment inventory in January 2024 and updated property records to ensure accuracy of federally funded equipment.
Finding 2023-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. Department of Education (USDE) U.S. Department of Energy (USDOE) U.S. Department of Health and Human Services (USDHHS) 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 State (USDOS) U.S. Department of Transportation (USDOT) U.S. Director of National Intelligence (USDNI) U.S. Environmental Protection Agency (USEPA) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($508,850,558) Federal Award Numbers: Various – See schedule of award numbers Federal Award Year: Various – See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Type of Finding: Noncompliance and material weakness Condition Found The University did not consistently follow its property management policies and procedures related to maintaining accurate property management records for equipment purchased with federal R&D Cluster program awards. The University conducts research at multiple locations throughout its campus where equipment purchased with federal awards 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 which 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. The University is required to safeguard equipment purchased with federal awards, maintain current property records, and to perform a physical inventory of equipment purchased with federal awards on a biennial basis. During our physical observation of 60 pieces of equipment (with a net book value (NBV) of $224,269) purchased with federal R&D Cluster awards, we noted eight items (with a NBV totaling $0) selected for physical observation were not able to be located for our testing. In response to the exceptions identified in our audit procedures, the University performed a physical inventory of all of its federally funded equipment in January 2024, which identified an additional 1,006 equipment items (with a NBV of $1,726,897) that could not be located, of which 839 were fully depreciated. University management believes these items were disposed of but not appropriately removed from the property records and federal equipment listing. As of June 30, 2023, the University’s federal equipment listing included 6,270 assets (with a NBV of $61,390,724) purchased with R&D Cluster program awards. We also noted the University’s controls for equipment dispositions are not operating at an appropriate level of precision to ensure equipment dispositions are properly authorized and property management records are updated on a timely basis. 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. Per 2 CFR 200.313(d)(3) and (4), a control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of property and adequate maintenance procedures must be developed to keep the property in good condition. 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 decentralized nature of the equipment recordkeeping process can result in delayed reporting of asset disposals. 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 reported in the prior year audit as finding number 2022-002. 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. Views of University Officials The University concurs with the finding and has begun to address these concerns. As noted in the finding, the University conducted a full federal equipment inventory in January 2024 and updated property records to ensure accuracy of federally funded equipment.
Finding 2023-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. Department of Education (USDE) U.S. Department of Energy (USDOE) U.S. Department of Health and Human Services (USDHHS) 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 State (USDOS) U.S. Department of Transportation (USDOT) U.S. Director of National Intelligence (USDNI) U.S. Environmental Protection Agency (USEPA) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($508,850,558) Federal Award Numbers: Various – See schedule of award numbers Federal Award Year: Various – See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Type of Finding: Noncompliance and material weakness Condition Found The University did not consistently follow its property management policies and procedures related to maintaining accurate property management records for equipment purchased with federal R&D Cluster program awards. The University conducts research at multiple locations throughout its campus where equipment purchased with federal awards 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 which 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. The University is required to safeguard equipment purchased with federal awards, maintain current property records, and to perform a physical inventory of equipment purchased with federal awards on a biennial basis. During our physical observation of 60 pieces of equipment (with a net book value (NBV) of $224,269) purchased with federal R&D Cluster awards, we noted eight items (with a NBV totaling $0) selected for physical observation were not able to be located for our testing. In response to the exceptions identified in our audit procedures, the University performed a physical inventory of all of its federally funded equipment in January 2024, which identified an additional 1,006 equipment items (with a NBV of $1,726,897) that could not be located, of which 839 were fully depreciated. University management believes these items were disposed of but not appropriately removed from the property records and federal equipment listing. As of June 30, 2023, the University’s federal equipment listing included 6,270 assets (with a NBV of $61,390,724) purchased with R&D Cluster program awards. We also noted the University’s controls for equipment dispositions are not operating at an appropriate level of precision to ensure equipment dispositions are properly authorized and property management records are updated on a timely basis. 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. Per 2 CFR 200.313(d)(3) and (4), a control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of property and adequate maintenance procedures must be developed to keep the property in good condition. 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 decentralized nature of the equipment recordkeeping process can result in delayed reporting of asset disposals. 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 reported in the prior year audit as finding number 2022-002. 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. Views of University Officials The University concurs with the finding and has begun to address these concerns. As noted in the finding, the University conducted a full federal equipment inventory in January 2024 and updated property records to ensure accuracy of federally funded equipment.
Finding 2023-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. Department of Education (USDE) U.S. Department of Energy (USDOE) U.S. Department of Health and Human Services (USDHHS) 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 State (USDOS) U.S. Department of Transportation (USDOT) U.S. Director of National Intelligence (USDNI) U.S. Environmental Protection Agency (USEPA) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($508,850,558) Federal Award Numbers: Various – See schedule of award numbers Federal Award Year: Various – See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Type of Finding: Noncompliance and material weakness Condition Found The University did not consistently follow its property management policies and procedures related to maintaining accurate property management records for equipment purchased with federal R&D Cluster program awards. The University conducts research at multiple locations throughout its campus where equipment purchased with federal awards 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 which 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. The University is required to safeguard equipment purchased with federal awards, maintain current property records, and to perform a physical inventory of equipment purchased with federal awards on a biennial basis. During our physical observation of 60 pieces of equipment (with a net book value (NBV) of $224,269) purchased with federal R&D Cluster awards, we noted eight items (with a NBV totaling $0) selected for physical observation were not able to be located for our testing. In response to the exceptions identified in our audit procedures, the University performed a physical inventory of all of its federally funded equipment in January 2024, which identified an additional 1,006 equipment items (with a NBV of $1,726,897) that could not be located, of which 839 were fully depreciated. University management believes these items were disposed of but not appropriately removed from the property records and federal equipment listing. As of June 30, 2023, the University’s federal equipment listing included 6,270 assets (with a NBV of $61,390,724) purchased with R&D Cluster program awards. We also noted the University’s controls for equipment dispositions are not operating at an appropriate level of precision to ensure equipment dispositions are properly authorized and property management records are updated on a timely basis. 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. Per 2 CFR 200.313(d)(3) and (4), a control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of property and adequate maintenance procedures must be developed to keep the property in good condition. 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 decentralized nature of the equipment recordkeeping process can result in delayed reporting of asset disposals. 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 reported in the prior year audit as finding number 2022-002. 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. Views of University Officials The University concurs with the finding and has begun to address these concerns. As noted in the finding, the University conducted a full federal equipment inventory in January 2024 and updated property records to ensure accuracy of federally funded equipment.
Finding 2023-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. Department of Education (USDE) U.S. Department of Energy (USDOE) U.S. Department of Health and Human Services (USDHHS) 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 State (USDOS) U.S. Department of Transportation (USDOT) U.S. Director of National Intelligence (USDNI) U.S. Environmental Protection Agency (USEPA) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($508,850,558) Federal Award Numbers: Various – See schedule of award numbers Federal Award Year: Various – See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Type of Finding: Noncompliance and material weakness Condition Found The University did not consistently follow its property management policies and procedures related to maintaining accurate property management records for equipment purchased with federal R&D Cluster program awards. The University conducts research at multiple locations throughout its campus where equipment purchased with federal awards 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 which 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. The University is required to safeguard equipment purchased with federal awards, maintain current property records, and to perform a physical inventory of equipment purchased with federal awards on a biennial basis. During our physical observation of 60 pieces of equipment (with a net book value (NBV) of $224,269) purchased with federal R&D Cluster awards, we noted eight items (with a NBV totaling $0) selected for physical observation were not able to be located for our testing. In response to the exceptions identified in our audit procedures, the University performed a physical inventory of all of its federally funded equipment in January 2024, which identified an additional 1,006 equipment items (with a NBV of $1,726,897) that could not be located, of which 839 were fully depreciated. University management believes these items were disposed of but not appropriately removed from the property records and federal equipment listing. As of June 30, 2023, the University’s federal equipment listing included 6,270 assets (with a NBV of $61,390,724) purchased with R&D Cluster program awards. We also noted the University’s controls for equipment dispositions are not operating at an appropriate level of precision to ensure equipment dispositions are properly authorized and property management records are updated on a timely basis. 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. Per 2 CFR 200.313(d)(3) and (4), a control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of property and adequate maintenance procedures must be developed to keep the property in good condition. 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 decentralized nature of the equipment recordkeeping process can result in delayed reporting of asset disposals. 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 reported in the prior year audit as finding number 2022-002. 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. Views of University Officials The University concurs with the finding and has begun to address these concerns. As noted in the finding, the University conducted a full federal equipment inventory in January 2024 and updated property records to ensure accuracy of federally funded equipment.
Finding 2023-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. Department of Education (USDE) U.S. Department of Energy (USDOE) U.S. Department of Health and Human Services (USDHHS) 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 State (USDOS) U.S. Department of Transportation (USDOT) U.S. Director of National Intelligence (USDNI) U.S. Environmental Protection Agency (USEPA) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($508,850,558) Federal Award Numbers: Various – See schedule of award numbers Federal Award Year: Various – See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Type of Finding: Noncompliance and material weakness Condition Found The University did not consistently follow its property management policies and procedures related to maintaining accurate property management records for equipment purchased with federal R&D Cluster program awards. The University conducts research at multiple locations throughout its campus where equipment purchased with federal awards 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 which 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. The University is required to safeguard equipment purchased with federal awards, maintain current property records, and to perform a physical inventory of equipment purchased with federal awards on a biennial basis. During our physical observation of 60 pieces of equipment (with a net book value (NBV) of $224,269) purchased with federal R&D Cluster awards, we noted eight items (with a NBV totaling $0) selected for physical observation were not able to be located for our testing. In response to the exceptions identified in our audit procedures, the University performed a physical inventory of all of its federally funded equipment in January 2024, which identified an additional 1,006 equipment items (with a NBV of $1,726,897) that could not be located, of which 839 were fully depreciated. University management believes these items were disposed of but not appropriately removed from the property records and federal equipment listing. As of June 30, 2023, the University’s federal equipment listing included 6,270 assets (with a NBV of $61,390,724) purchased with R&D Cluster program awards. We also noted the University’s controls for equipment dispositions are not operating at an appropriate level of precision to ensure equipment dispositions are properly authorized and property management records are updated on a timely basis. 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. Per 2 CFR 200.313(d)(3) and (4), a control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of property and adequate maintenance procedures must be developed to keep the property in good condition. 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 decentralized nature of the equipment recordkeeping process can result in delayed reporting of asset disposals. 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 reported in the prior year audit as finding number 2022-002. 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. Views of University Officials The University concurs with the finding and has begun to address these concerns. As noted in the finding, the University conducted a full federal equipment inventory in January 2024 and updated property records to ensure accuracy of federally funded equipment.
Finding 2023-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. Department of Education (USDE) U.S. Department of Energy (USDOE) U.S. Department of Health and Human Services (USDHHS) 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 State (USDOS) U.S. Department of Transportation (USDOT) U.S. Director of National Intelligence (USDNI) U.S. Environmental Protection Agency (USEPA) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($508,850,558) Federal Award Numbers: Various – See schedule of award numbers Federal Award Year: Various – See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Type of Finding: Noncompliance and material weakness Condition Found The University did not consistently follow its property management policies and procedures related to maintaining accurate property management records for equipment purchased with federal R&D Cluster program awards. The University conducts research at multiple locations throughout its campus where equipment purchased with federal awards 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 which 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. The University is required to safeguard equipment purchased with federal awards, maintain current property records, and to perform a physical inventory of equipment purchased with federal awards on a biennial basis. During our physical observation of 60 pieces of equipment (with a net book value (NBV) of $224,269) purchased with federal R&D Cluster awards, we noted eight items (with a NBV totaling $0) selected for physical observation were not able to be located for our testing. In response to the exceptions identified in our audit procedures, the University performed a physical inventory of all of its federally funded equipment in January 2024, which identified an additional 1,006 equipment items (with a NBV of $1,726,897) that could not be located, of which 839 were fully depreciated. University management believes these items were disposed of but not appropriately removed from the property records and federal equipment listing. As of June 30, 2023, the University’s federal equipment listing included 6,270 assets (with a NBV of $61,390,724) purchased with R&D Cluster program awards. We also noted the University’s controls for equipment dispositions are not operating at an appropriate level of precision to ensure equipment dispositions are properly authorized and property management records are updated on a timely basis. 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. Per 2 CFR 200.313(d)(3) and (4), a control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of property and adequate maintenance procedures must be developed to keep the property in good condition. 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 decentralized nature of the equipment recordkeeping process can result in delayed reporting of asset disposals. 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 reported in the prior year audit as finding number 2022-002. 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. Views of University Officials The University concurs with the finding and has begun to address these concerns. As noted in the finding, the University conducted a full federal equipment inventory in January 2024 and updated property records to ensure accuracy of federally funded equipment.
Finding 2023-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. Department of Education (USDE) U.S. Department of Energy (USDOE) U.S. Department of Health and Human Services (USDHHS) 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 State (USDOS) U.S. Department of Transportation (USDOT) U.S. Director of National Intelligence (USDNI) U.S. Environmental Protection Agency (USEPA) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($508,850,558) Federal Award Numbers: Various – See schedule of award numbers Federal Award Year: Various – See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Type of Finding: Noncompliance and material weakness Condition Found The University did not consistently follow its property management policies and procedures related to maintaining accurate property management records for equipment purchased with federal R&D Cluster program awards. The University conducts research at multiple locations throughout its campus where equipment purchased with federal awards 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 which 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. The University is required to safeguard equipment purchased with federal awards, maintain current property records, and to perform a physical inventory of equipment purchased with federal awards on a biennial basis. During our physical observation of 60 pieces of equipment (with a net book value (NBV) of $224,269) purchased with federal R&D Cluster awards, we noted eight items (with a NBV totaling $0) selected for physical observation were not able to be located for our testing. In response to the exceptions identified in our audit procedures, the University performed a physical inventory of all of its federally funded equipment in January 2024, which identified an additional 1,006 equipment items (with a NBV of $1,726,897) that could not be located, of which 839 were fully depreciated. University management believes these items were disposed of but not appropriately removed from the property records and federal equipment listing. As of June 30, 2023, the University’s federal equipment listing included 6,270 assets (with a NBV of $61,390,724) purchased with R&D Cluster program awards. We also noted the University’s controls for equipment dispositions are not operating at an appropriate level of precision to ensure equipment dispositions are properly authorized and property management records are updated on a timely basis. 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. Per 2 CFR 200.313(d)(3) and (4), a control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of property and adequate maintenance procedures must be developed to keep the property in good condition. 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 decentralized nature of the equipment recordkeeping process can result in delayed reporting of asset disposals. 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 reported in the prior year audit as finding number 2022-002. 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. Views of University Officials The University concurs with the finding and has begun to address these concerns. As noted in the finding, the University conducted a full federal equipment inventory in January 2024 and updated property records to ensure accuracy of federally funded equipment.
Finding 2023-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. Department of Education (USDE) U.S. Department of Energy (USDOE) U.S. Department of Health and Human Services (USDHHS) 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 State (USDOS) U.S. Department of Transportation (USDOT) U.S. Director of National Intelligence (USDNI) U.S. Environmental Protection Agency (USEPA) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($508,850,558) Federal Award Numbers: Various – See schedule of award numbers Federal Award Year: Various – See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Type of Finding: Noncompliance and material weakness Condition Found The University did not consistently follow its property management policies and procedures related to maintaining accurate property management records for equipment purchased with federal R&D Cluster program awards. The University conducts research at multiple locations throughout its campus where equipment purchased with federal awards 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 which 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. The University is required to safeguard equipment purchased with federal awards, maintain current property records, and to perform a physical inventory of equipment purchased with federal awards on a biennial basis. During our physical observation of 60 pieces of equipment (with a net book value (NBV) of $224,269) purchased with federal R&D Cluster awards, we noted eight items (with a NBV totaling $0) selected for physical observation were not able to be located for our testing. In response to the exceptions identified in our audit procedures, the University performed a physical inventory of all of its federally funded equipment in January 2024, which identified an additional 1,006 equipment items (with a NBV of $1,726,897) that could not be located, of which 839 were fully depreciated. University management believes these items were disposed of but not appropriately removed from the property records and federal equipment listing. As of June 30, 2023, the University’s federal equipment listing included 6,270 assets (with a NBV of $61,390,724) purchased with R&D Cluster program awards. We also noted the University’s controls for equipment dispositions are not operating at an appropriate level of precision to ensure equipment dispositions are properly authorized and property management records are updated on a timely basis. 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. Per 2 CFR 200.313(d)(3) and (4), a control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of property and adequate maintenance procedures must be developed to keep the property in good condition. 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 decentralized nature of the equipment recordkeeping process can result in delayed reporting of asset disposals. 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 reported in the prior year audit as finding number 2022-002. 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. Views of University Officials The University concurs with the finding and has begun to address these concerns. As noted in the finding, the University conducted a full federal equipment inventory in January 2024 and updated property records to ensure accuracy of federally funded equipment.
Finding 2023-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. Department of Education (USDE) U.S. Department of Energy (USDOE) U.S. Department of Health and Human Services (USDHHS) 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 State (USDOS) U.S. Department of Transportation (USDOT) U.S. Director of National Intelligence (USDNI) U.S. Environmental Protection Agency (USEPA) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($508,850,558) Federal Award Numbers: Various – See schedule of award numbers Federal Award Year: Various – See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Type of Finding: Noncompliance and material weakness Condition Found The University did not consistently follow its property management policies and procedures related to maintaining accurate property management records for equipment purchased with federal R&D Cluster program awards. The University conducts research at multiple locations throughout its campus where equipment purchased with federal awards 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 which 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. The University is required to safeguard equipment purchased with federal awards, maintain current property records, and to perform a physical inventory of equipment purchased with federal awards on a biennial basis. During our physical observation of 60 pieces of equipment (with a net book value (NBV) of $224,269) purchased with federal R&D Cluster awards, we noted eight items (with a NBV totaling $0) selected for physical observation were not able to be located for our testing. In response to the exceptions identified in our audit procedures, the University performed a physical inventory of all of its federally funded equipment in January 2024, which identified an additional 1,006 equipment items (with a NBV of $1,726,897) that could not be located, of which 839 were fully depreciated. University management believes these items were disposed of but not appropriately removed from the property records and federal equipment listing. As of June 30, 2023, the University’s federal equipment listing included 6,270 assets (with a NBV of $61,390,724) purchased with R&D Cluster program awards. We also noted the University’s controls for equipment dispositions are not operating at an appropriate level of precision to ensure equipment dispositions are properly authorized and property management records are updated on a timely basis. 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. Per 2 CFR 200.313(d)(3) and (4), a control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of property and adequate maintenance procedures must be developed to keep the property in good condition. 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 decentralized nature of the equipment recordkeeping process can result in delayed reporting of asset disposals. 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 reported in the prior year audit as finding number 2022-002. 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. Views of University Officials The University concurs with the finding and has begun to address these concerns. As noted in the finding, the University conducted a full federal equipment inventory in January 2024 and updated property records to ensure accuracy of federally funded equipment.
Finding 2023-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. Department of Education (USDE) U.S. Department of Energy (USDOE) U.S. Department of Health and Human Services (USDHHS) 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 State (USDOS) U.S. Department of Transportation (USDOT) U.S. Director of National Intelligence (USDNI) U.S. Environmental Protection Agency (USEPA) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($508,850,558) Federal Award Numbers: Various – See schedule of award numbers Federal Award Year: Various – See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Type of Finding: Noncompliance and material weakness Condition Found The University did not consistently follow its property management policies and procedures related to maintaining accurate property management records for equipment purchased with federal R&D Cluster program awards. The University conducts research at multiple locations throughout its campus where equipment purchased with federal awards 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 which 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. The University is required to safeguard equipment purchased with federal awards, maintain current property records, and to perform a physical inventory of equipment purchased with federal awards on a biennial basis. During our physical observation of 60 pieces of equipment (with a net book value (NBV) of $224,269) purchased with federal R&D Cluster awards, we noted eight items (with a NBV totaling $0) selected for physical observation were not able to be located for our testing. In response to the exceptions identified in our audit procedures, the University performed a physical inventory of all of its federally funded equipment in January 2024, which identified an additional 1,006 equipment items (with a NBV of $1,726,897) that could not be located, of which 839 were fully depreciated. University management believes these items were disposed of but not appropriately removed from the property records and federal equipment listing. As of June 30, 2023, the University’s federal equipment listing included 6,270 assets (with a NBV of $61,390,724) purchased with R&D Cluster program awards. We also noted the University’s controls for equipment dispositions are not operating at an appropriate level of precision to ensure equipment dispositions are properly authorized and property management records are updated on a timely basis. 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. Per 2 CFR 200.313(d)(3) and (4), a control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of property and adequate maintenance procedures must be developed to keep the property in good condition. 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 decentralized nature of the equipment recordkeeping process can result in delayed reporting of asset disposals. 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 reported in the prior year audit as finding number 2022-002. 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. Views of University Officials The University concurs with the finding and has begun to address these concerns. As noted in the finding, the University conducted a full federal equipment inventory in January 2024 and updated property records to ensure accuracy of federally funded equipment.
Finding 2023-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. Department of Education (USDE) U.S. Department of Energy (USDOE) U.S. Department of Health and Human Services (USDHHS) 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 State (USDOS) U.S. Department of Transportation (USDOT) U.S. Director of National Intelligence (USDNI) U.S. Environmental Protection Agency (USEPA) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($508,850,558) Federal Award Numbers: Various – See schedule of award numbers Federal Award Year: Various – See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Type of Finding: Noncompliance and material weakness Condition Found The University did not consistently follow its property management policies and procedures related to maintaining accurate property management records for equipment purchased with federal R&D Cluster program awards. The University conducts research at multiple locations throughout its campus where equipment purchased with federal awards 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 which 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. The University is required to safeguard equipment purchased with federal awards, maintain current property records, and to perform a physical inventory of equipment purchased with federal awards on a biennial basis. During our physical observation of 60 pieces of equipment (with a net book value (NBV) of $224,269) purchased with federal R&D Cluster awards, we noted eight items (with a NBV totaling $0) selected for physical observation were not able to be located for our testing. In response to the exceptions identified in our audit procedures, the University performed a physical inventory of all of its federally funded equipment in January 2024, which identified an additional 1,006 equipment items (with a NBV of $1,726,897) that could not be located, of which 839 were fully depreciated. University management believes these items were disposed of but not appropriately removed from the property records and federal equipment listing. As of June 30, 2023, the University’s federal equipment listing included 6,270 assets (with a NBV of $61,390,724) purchased with R&D Cluster program awards. We also noted the University’s controls for equipment dispositions are not operating at an appropriate level of precision to ensure equipment dispositions are properly authorized and property management records are updated on a timely basis. 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. Per 2 CFR 200.313(d)(3) and (4), a control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of property and adequate maintenance procedures must be developed to keep the property in good condition. 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 decentralized nature of the equipment recordkeeping process can result in delayed reporting of asset disposals. 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 reported in the prior year audit as finding number 2022-002. 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. Views of University Officials The University concurs with the finding and has begun to address these concerns. As noted in the finding, the University conducted a full federal equipment inventory in January 2024 and updated property records to ensure accuracy of federally funded equipment.
Finding 2023-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. Department of Education (USDE) U.S. Department of Energy (USDOE) U.S. Department of Health and Human Services (USDHHS) 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 State (USDOS) U.S. Department of Transportation (USDOT) U.S. Director of National Intelligence (USDNI) U.S. Environmental Protection Agency (USEPA) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($508,850,558) Federal Award Numbers: Various – See schedule of award numbers Federal Award Year: Various – See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Type of Finding: Noncompliance and material weakness Condition Found The University did not consistently follow its property management policies and procedures related to maintaining accurate property management records for equipment purchased with federal R&D Cluster program awards. The University conducts research at multiple locations throughout its campus where equipment purchased with federal awards 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 which 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. The University is required to safeguard equipment purchased with federal awards, maintain current property records, and to perform a physical inventory of equipment purchased with federal awards on a biennial basis. During our physical observation of 60 pieces of equipment (with a net book value (NBV) of $224,269) purchased with federal R&D Cluster awards, we noted eight items (with a NBV totaling $0) selected for physical observation were not able to be located for our testing. In response to the exceptions identified in our audit procedures, the University performed a physical inventory of all of its federally funded equipment in January 2024, which identified an additional 1,006 equipment items (with a NBV of $1,726,897) that could not be located, of which 839 were fully depreciated. University management believes these items were disposed of but not appropriately removed from the property records and federal equipment listing. As of June 30, 2023, the University’s federal equipment listing included 6,270 assets (with a NBV of $61,390,724) purchased with R&D Cluster program awards. We also noted the University’s controls for equipment dispositions are not operating at an appropriate level of precision to ensure equipment dispositions are properly authorized and property management records are updated on a timely basis. 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. Per 2 CFR 200.313(d)(3) and (4), a control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of property and adequate maintenance procedures must be developed to keep the property in good condition. 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 decentralized nature of the equipment recordkeeping process can result in delayed reporting of asset disposals. 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 reported in the prior year audit as finding number 2022-002. 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. Views of University Officials The University concurs with the finding and has begun to address these concerns. As noted in the finding, the University conducted a full federal equipment inventory in January 2024 and updated property records to ensure accuracy of federally funded equipment.
Finding 2023-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. Department of Education (USDE) U.S. Department of Energy (USDOE) U.S. Department of Health and Human Services (USDHHS) 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 State (USDOS) U.S. Department of Transportation (USDOT) U.S. Director of National Intelligence (USDNI) U.S. Environmental Protection Agency (USEPA) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($508,850,558) Federal Award Numbers: Various – See schedule of award numbers Federal Award Year: Various – See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Type of Finding: Noncompliance and material weakness Condition Found The University did not consistently follow its property management policies and procedures related to maintaining accurate property management records for equipment purchased with federal R&D Cluster program awards. The University conducts research at multiple locations throughout its campus where equipment purchased with federal awards 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 which 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. The University is required to safeguard equipment purchased with federal awards, maintain current property records, and to perform a physical inventory of equipment purchased with federal awards on a biennial basis. During our physical observation of 60 pieces of equipment (with a net book value (NBV) of $224,269) purchased with federal R&D Cluster awards, we noted eight items (with a NBV totaling $0) selected for physical observation were not able to be located for our testing. In response to the exceptions identified in our audit procedures, the University performed a physical inventory of all of its federally funded equipment in January 2024, which identified an additional 1,006 equipment items (with a NBV of $1,726,897) that could not be located, of which 839 were fully depreciated. University management believes these items were disposed of but not appropriately removed from the property records and federal equipment listing. As of June 30, 2023, the University’s federal equipment listing included 6,270 assets (with a NBV of $61,390,724) purchased with R&D Cluster program awards. We also noted the University’s controls for equipment dispositions are not operating at an appropriate level of precision to ensure equipment dispositions are properly authorized and property management records are updated on a timely basis. 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. Per 2 CFR 200.313(d)(3) and (4), a control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of property and adequate maintenance procedures must be developed to keep the property in good condition. 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 decentralized nature of the equipment recordkeeping process can result in delayed reporting of asset disposals. 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 reported in the prior year audit as finding number 2022-002. 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. Views of University Officials The University concurs with the finding and has begun to address these concerns. As noted in the finding, the University conducted a full federal equipment inventory in January 2024 and updated property records to ensure accuracy of federally funded equipment.
Finding 2023-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. Department of Education (USDE) U.S. Department of Energy (USDOE) U.S. Department of Health and Human Services (USDHHS) 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 State (USDOS) U.S. Department of Transportation (USDOT) U.S. Director of National Intelligence (USDNI) U.S. Environmental Protection Agency (USEPA) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($508,850,558) Federal Award Numbers: Various – See schedule of award numbers Federal Award Year: Various – See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Type of Finding: Noncompliance and material weakness Condition Found The University did not consistently follow its property management policies and procedures related to maintaining accurate property management records for equipment purchased with federal R&D Cluster program awards. The University conducts research at multiple locations throughout its campus where equipment purchased with federal awards 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 which 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. The University is required to safeguard equipment purchased with federal awards, maintain current property records, and to perform a physical inventory of equipment purchased with federal awards on a biennial basis. During our physical observation of 60 pieces of equipment (with a net book value (NBV) of $224,269) purchased with federal R&D Cluster awards, we noted eight items (with a NBV totaling $0) selected for physical observation were not able to be located for our testing. In response to the exceptions identified in our audit procedures, the University performed a physical inventory of all of its federally funded equipment in January 2024, which identified an additional 1,006 equipment items (with a NBV of $1,726,897) that could not be located, of which 839 were fully depreciated. University management believes these items were disposed of but not appropriately removed from the property records and federal equipment listing. As of June 30, 2023, the University’s federal equipment listing included 6,270 assets (with a NBV of $61,390,724) purchased with R&D Cluster program awards. We also noted the University’s controls for equipment dispositions are not operating at an appropriate level of precision to ensure equipment dispositions are properly authorized and property management records are updated on a timely basis. 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. Per 2 CFR 200.313(d)(3) and (4), a control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of property and adequate maintenance procedures must be developed to keep the property in good condition. 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 decentralized nature of the equipment recordkeeping process can result in delayed reporting of asset disposals. 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 reported in the prior year audit as finding number 2022-002. 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. Views of University Officials The University concurs with the finding and has begun to address these concerns. As noted in the finding, the University conducted a full federal equipment inventory in January 2024 and updated property records to ensure accuracy of federally funded equipment.
Finding 2023-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. Department of Education (USDE) U.S. Department of Energy (USDOE) U.S. Department of Health and Human Services (USDHHS) 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 State (USDOS) U.S. Department of Transportation (USDOT) U.S. Director of National Intelligence (USDNI) U.S. Environmental Protection Agency (USEPA) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($508,850,558) Federal Award Numbers: Various – See schedule of award numbers Federal Award Year: Various – See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Type of Finding: Noncompliance and material weakness Condition Found The University did not consistently follow its property management policies and procedures related to maintaining accurate property management records for equipment purchased with federal R&D Cluster program awards. The University conducts research at multiple locations throughout its campus where equipment purchased with federal awards 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 which 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. The University is required to safeguard equipment purchased with federal awards, maintain current property records, and to perform a physical inventory of equipment purchased with federal awards on a biennial basis. During our physical observation of 60 pieces of equipment (with a net book value (NBV) of $224,269) purchased with federal R&D Cluster awards, we noted eight items (with a NBV totaling $0) selected for physical observation were not able to be located for our testing. In response to the exceptions identified in our audit procedures, the University performed a physical inventory of all of its federally funded equipment in January 2024, which identified an additional 1,006 equipment items (with a NBV of $1,726,897) that could not be located, of which 839 were fully depreciated. University management believes these items were disposed of but not appropriately removed from the property records and federal equipment listing. As of June 30, 2023, the University’s federal equipment listing included 6,270 assets (with a NBV of $61,390,724) purchased with R&D Cluster program awards. We also noted the University’s controls for equipment dispositions are not operating at an appropriate level of precision to ensure equipment dispositions are properly authorized and property management records are updated on a timely basis. 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. Per 2 CFR 200.313(d)(3) and (4), a control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of property and adequate maintenance procedures must be developed to keep the property in good condition. 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 decentralized nature of the equipment recordkeeping process can result in delayed reporting of asset disposals. 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 reported in the prior year audit as finding number 2022-002. 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. Views of University Officials The University concurs with the finding and has begun to address these concerns. As noted in the finding, the University conducted a full federal equipment inventory in January 2024 and updated property records to ensure accuracy of federally funded equipment.
Finding 2023-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. Department of Education (USDE) U.S. Department of Energy (USDOE) U.S. Department of Health and Human Services (USDHHS) 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 State (USDOS) U.S. Department of Transportation (USDOT) U.S. Director of National Intelligence (USDNI) U.S. Environmental Protection Agency (USEPA) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($508,850,558) Federal Award Numbers: Various – See schedule of award numbers Federal Award Year: Various – See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Type of Finding: Noncompliance and material weakness Condition Found The University did not consistently follow its property management policies and procedures related to maintaining accurate property management records for equipment purchased with federal R&D Cluster program awards. The University conducts research at multiple locations throughout its campus where equipment purchased with federal awards 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 which 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. The University is required to safeguard equipment purchased with federal awards, maintain current property records, and to perform a physical inventory of equipment purchased with federal awards on a biennial basis. During our physical observation of 60 pieces of equipment (with a net book value (NBV) of $224,269) purchased with federal R&D Cluster awards, we noted eight items (with a NBV totaling $0) selected for physical observation were not able to be located for our testing. In response to the exceptions identified in our audit procedures, the University performed a physical inventory of all of its federally funded equipment in January 2024, which identified an additional 1,006 equipment items (with a NBV of $1,726,897) that could not be located, of which 839 were fully depreciated. University management believes these items were disposed of but not appropriately removed from the property records and federal equipment listing. As of June 30, 2023, the University’s federal equipment listing included 6,270 assets (with a NBV of $61,390,724) purchased with R&D Cluster program awards. We also noted the University’s controls for equipment dispositions are not operating at an appropriate level of precision to ensure equipment dispositions are properly authorized and property management records are updated on a timely basis. 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. Per 2 CFR 200.313(d)(3) and (4), a control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of property and adequate maintenance procedures must be developed to keep the property in good condition. 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 decentralized nature of the equipment recordkeeping process can result in delayed reporting of asset disposals. 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 reported in the prior year audit as finding number 2022-002. 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. Views of University Officials The University concurs with the finding and has begun to address these concerns. As noted in the finding, the University conducted a full federal equipment inventory in January 2024 and updated property records to ensure accuracy of federally funded equipment.
Finding 2023-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. Department of Education (USDE) U.S. Department of Energy (USDOE) U.S. Department of Health and Human Services (USDHHS) 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 State (USDOS) U.S. Department of Transportation (USDOT) U.S. Director of National Intelligence (USDNI) U.S. Environmental Protection Agency (USEPA) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($508,850,558) Federal Award Numbers: Various – See schedule of award numbers Federal Award Year: Various – See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Type of Finding: Noncompliance and material weakness Condition Found The University did not consistently follow its property management policies and procedures related to maintaining accurate property management records for equipment purchased with federal R&D Cluster program awards. The University conducts research at multiple locations throughout its campus where equipment purchased with federal awards 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 which 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. The University is required to safeguard equipment purchased with federal awards, maintain current property records, and to perform a physical inventory of equipment purchased with federal awards on a biennial basis. During our physical observation of 60 pieces of equipment (with a net book value (NBV) of $224,269) purchased with federal R&D Cluster awards, we noted eight items (with a NBV totaling $0) selected for physical observation were not able to be located for our testing. In response to the exceptions identified in our audit procedures, the University performed a physical inventory of all of its federally funded equipment in January 2024, which identified an additional 1,006 equipment items (with a NBV of $1,726,897) that could not be located, of which 839 were fully depreciated. University management believes these items were disposed of but not appropriately removed from the property records and federal equipment listing. As of June 30, 2023, the University’s federal equipment listing included 6,270 assets (with a NBV of $61,390,724) purchased with R&D Cluster program awards. We also noted the University’s controls for equipment dispositions are not operating at an appropriate level of precision to ensure equipment dispositions are properly authorized and property management records are updated on a timely basis. 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. Per 2 CFR 200.313(d)(3) and (4), a control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of property and adequate maintenance procedures must be developed to keep the property in good condition. 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 decentralized nature of the equipment recordkeeping process can result in delayed reporting of asset disposals. 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 reported in the prior year audit as finding number 2022-002. 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. Views of University Officials The University concurs with the finding and has begun to address these concerns. As noted in the finding, the University conducted a full federal equipment inventory in January 2024 and updated property records to ensure accuracy of federally funded equipment.
Finding 2023-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. Department of Education (USDE) U.S. Department of Energy (USDOE) U.S. Department of Health and Human Services (USDHHS) 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 State (USDOS) U.S. Department of Transportation (USDOT) U.S. Director of National Intelligence (USDNI) U.S. Environmental Protection Agency (USEPA) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($508,850,558) Federal Award Numbers: Various – See schedule of award numbers Federal Award Year: Various – See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Type of Finding: Noncompliance and material weakness Condition Found The University did not consistently follow its property management policies and procedures related to maintaining accurate property management records for equipment purchased with federal R&D Cluster program awards. The University conducts research at multiple locations throughout its campus where equipment purchased with federal awards 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 which 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. The University is required to safeguard equipment purchased with federal awards, maintain current property records, and to perform a physical inventory of equipment purchased with federal awards on a biennial basis. During our physical observation of 60 pieces of equipment (with a net book value (NBV) of $224,269) purchased with federal R&D Cluster awards, we noted eight items (with a NBV totaling $0) selected for physical observation were not able to be located for our testing. In response to the exceptions identified in our audit procedures, the University performed a physical inventory of all of its federally funded equipment in January 2024, which identified an additional 1,006 equipment items (with a NBV of $1,726,897) that could not be located, of which 839 were fully depreciated. University management believes these items were disposed of but not appropriately removed from the property records and federal equipment listing. As of June 30, 2023, the University’s federal equipment listing included 6,270 assets (with a NBV of $61,390,724) purchased with R&D Cluster program awards. We also noted the University’s controls for equipment dispositions are not operating at an appropriate level of precision to ensure equipment dispositions are properly authorized and property management records are updated on a timely basis. 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. Per 2 CFR 200.313(d)(3) and (4), a control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of property and adequate maintenance procedures must be developed to keep the property in good condition. 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 decentralized nature of the equipment recordkeeping process can result in delayed reporting of asset disposals. 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 reported in the prior year audit as finding number 2022-002. 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. Views of University Officials The University concurs with the finding and has begun to address these concerns. As noted in the finding, the University conducted a full federal equipment inventory in January 2024 and updated property records to ensure accuracy of federally funded equipment.
Finding 2023-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. Department of Education (USDE) U.S. Department of Energy (USDOE) U.S. Department of Health and Human Services (USDHHS) 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 State (USDOS) U.S. Department of Transportation (USDOT) U.S. Director of National Intelligence (USDNI) U.S. Environmental Protection Agency (USEPA) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($508,850,558) Federal Award Numbers: Various – See schedule of award numbers Federal Award Year: Various – See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Type of Finding: Noncompliance and material weakness Condition Found The University did not consistently follow its property management policies and procedures related to maintaining accurate property management records for equipment purchased with federal R&D Cluster program awards. The University conducts research at multiple locations throughout its campus where equipment purchased with federal awards 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 which 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. The University is required to safeguard equipment purchased with federal awards, maintain current property records, and to perform a physical inventory of equipment purchased with federal awards on a biennial basis. During our physical observation of 60 pieces of equipment (with a net book value (NBV) of $224,269) purchased with federal R&D Cluster awards, we noted eight items (with a NBV totaling $0) selected for physical observation were not able to be located for our testing. In response to the exceptions identified in our audit procedures, the University performed a physical inventory of all of its federally funded equipment in January 2024, which identified an additional 1,006 equipment items (with a NBV of $1,726,897) that could not be located, of which 839 were fully depreciated. University management believes these items were disposed of but not appropriately removed from the property records and federal equipment listing. As of June 30, 2023, the University’s federal equipment listing included 6,270 assets (with a NBV of $61,390,724) purchased with R&D Cluster program awards. We also noted the University’s controls for equipment dispositions are not operating at an appropriate level of precision to ensure equipment dispositions are properly authorized and property management records are updated on a timely basis. 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. Per 2 CFR 200.313(d)(3) and (4), a control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of property and adequate maintenance procedures must be developed to keep the property in good condition. 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 decentralized nature of the equipment recordkeeping process can result in delayed reporting of asset disposals. 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 reported in the prior year audit as finding number 2022-002. 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. Views of University Officials The University concurs with the finding and has begun to address these concerns. As noted in the finding, the University conducted a full federal equipment inventory in January 2024 and updated property records to ensure accuracy of federally funded equipment.
Finding 2023-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. Department of Education (USDE) U.S. Department of Energy (USDOE) U.S. Department of Health and Human Services (USDHHS) 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 State (USDOS) U.S. Department of Transportation (USDOT) U.S. Director of National Intelligence (USDNI) U.S. Environmental Protection Agency (USEPA) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($508,850,558) Federal Award Numbers: Various – See schedule of award numbers Federal Award Year: Various – See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Type of Finding: Noncompliance and material weakness Condition Found The University did not consistently follow its property management policies and procedures related to maintaining accurate property management records for equipment purchased with federal R&D Cluster program awards. The University conducts research at multiple locations throughout its campus where equipment purchased with federal awards 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 which 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. The University is required to safeguard equipment purchased with federal awards, maintain current property records, and to perform a physical inventory of equipment purchased with federal awards on a biennial basis. During our physical observation of 60 pieces of equipment (with a net book value (NBV) of $224,269) purchased with federal R&D Cluster awards, we noted eight items (with a NBV totaling $0) selected for physical observation were not able to be located for our testing. In response to the exceptions identified in our audit procedures, the University performed a physical inventory of all of its federally funded equipment in January 2024, which identified an additional 1,006 equipment items (with a NBV of $1,726,897) that could not be located, of which 839 were fully depreciated. University management believes these items were disposed of but not appropriately removed from the property records and federal equipment listing. As of June 30, 2023, the University’s federal equipment listing included 6,270 assets (with a NBV of $61,390,724) purchased with R&D Cluster program awards. We also noted the University’s controls for equipment dispositions are not operating at an appropriate level of precision to ensure equipment dispositions are properly authorized and property management records are updated on a timely basis. 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. Per 2 CFR 200.313(d)(3) and (4), a control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of property and adequate maintenance procedures must be developed to keep the property in good condition. 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 decentralized nature of the equipment recordkeeping process can result in delayed reporting of asset disposals. 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 reported in the prior year audit as finding number 2022-002. 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. Views of University Officials The University concurs with the finding and has begun to address these concerns. As noted in the finding, the University conducted a full federal equipment inventory in January 2024 and updated property records to ensure accuracy of federally funded equipment.
Finding 2023-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. Department of Education (USDE) U.S. Department of Energy (USDOE) U.S. Department of Health and Human Services (USDHHS) 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 State (USDOS) U.S. Department of Transportation (USDOT) U.S. Director of National Intelligence (USDNI) U.S. Environmental Protection Agency (USEPA) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($508,850,558) Federal Award Numbers: Various – See schedule of award numbers Federal Award Year: Various – See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Type of Finding: Noncompliance and material weakness Condition Found The University did not consistently follow its property management policies and procedures related to maintaining accurate property management records for equipment purchased with federal R&D Cluster program awards. The University conducts research at multiple locations throughout its campus where equipment purchased with federal awards 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 which 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. The University is required to safeguard equipment purchased with federal awards, maintain current property records, and to perform a physical inventory of equipment purchased with federal awards on a biennial basis. During our physical observation of 60 pieces of equipment (with a net book value (NBV) of $224,269) purchased with federal R&D Cluster awards, we noted eight items (with a NBV totaling $0) selected for physical observation were not able to be located for our testing. In response to the exceptions identified in our audit procedures, the University performed a physical inventory of all of its federally funded equipment in January 2024, which identified an additional 1,006 equipment items (with a NBV of $1,726,897) that could not be located, of which 839 were fully depreciated. University management believes these items were disposed of but not appropriately removed from the property records and federal equipment listing. As of June 30, 2023, the University’s federal equipment listing included 6,270 assets (with a NBV of $61,390,724) purchased with R&D Cluster program awards. We also noted the University’s controls for equipment dispositions are not operating at an appropriate level of precision to ensure equipment dispositions are properly authorized and property management records are updated on a timely basis. 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. Per 2 CFR 200.313(d)(3) and (4), a control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of property and adequate maintenance procedures must be developed to keep the property in good condition. 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 decentralized nature of the equipment recordkeeping process can result in delayed reporting of asset disposals. 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 reported in the prior year audit as finding number 2022-002. 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. Views of University Officials The University concurs with the finding and has begun to address these concerns. As noted in the finding, the University conducted a full federal equipment inventory in January 2024 and updated property records to ensure accuracy of federally funded equipment.
Finding 2023-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. Department of Education (USDE) U.S. Department of Energy (USDOE) U.S. Department of Health and Human Services (USDHHS) 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 State (USDOS) U.S. Department of Transportation (USDOT) U.S. Director of National Intelligence (USDNI) U.S. Environmental Protection Agency (USEPA) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($508,850,558) Federal Award Numbers: Various – See schedule of award numbers Federal Award Year: Various – See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Type of Finding: Noncompliance and material weakness Condition Found The University did not consistently follow its property management policies and procedures related to maintaining accurate property management records for equipment purchased with federal R&D Cluster program awards. The University conducts research at multiple locations throughout its campus where equipment purchased with federal awards 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 which 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. The University is required to safeguard equipment purchased with federal awards, maintain current property records, and to perform a physical inventory of equipment purchased with federal awards on a biennial basis. During our physical observation of 60 pieces of equipment (with a net book value (NBV) of $224,269) purchased with federal R&D Cluster awards, we noted eight items (with a NBV totaling $0) selected for physical observation were not able to be located for our testing. In response to the exceptions identified in our audit procedures, the University performed a physical inventory of all of its federally funded equipment in January 2024, which identified an additional 1,006 equipment items (with a NBV of $1,726,897) that could not be located, of which 839 were fully depreciated. University management believes these items were disposed of but not appropriately removed from the property records and federal equipment listing. As of June 30, 2023, the University’s federal equipment listing included 6,270 assets (with a NBV of $61,390,724) purchased with R&D Cluster program awards. We also noted the University’s controls for equipment dispositions are not operating at an appropriate level of precision to ensure equipment dispositions are properly authorized and property management records are updated on a timely basis. 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. Per 2 CFR 200.313(d)(3) and (4), a control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of property and adequate maintenance procedures must be developed to keep the property in good condition. 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 decentralized nature of the equipment recordkeeping process can result in delayed reporting of asset disposals. 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 reported in the prior year audit as finding number 2022-002. 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. Views of University Officials The University concurs with the finding and has begun to address these concerns. As noted in the finding, the University conducted a full federal equipment inventory in January 2024 and updated property records to ensure accuracy of federally funded equipment.
Finding 2023-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. Department of Education (USDE) U.S. Department of Energy (USDOE) U.S. Department of Health and Human Services (USDHHS) 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 State (USDOS) U.S. Department of Transportation (USDOT) U.S. Director of National Intelligence (USDNI) U.S. Environmental Protection Agency (USEPA) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($508,850,558) Federal Award Numbers: Various – See schedule of award numbers Federal Award Year: Various – See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Type of Finding: Noncompliance and material weakness Condition Found The University did not consistently follow its property management policies and procedures related to maintaining accurate property management records for equipment purchased with federal R&D Cluster program awards. The University conducts research at multiple locations throughout its campus where equipment purchased with federal awards 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 which 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. The University is required to safeguard equipment purchased with federal awards, maintain current property records, and to perform a physical inventory of equipment purchased with federal awards on a biennial basis. During our physical observation of 60 pieces of equipment (with a net book value (NBV) of $224,269) purchased with federal R&D Cluster awards, we noted eight items (with a NBV totaling $0) selected for physical observation were not able to be located for our testing. In response to the exceptions identified in our audit procedures, the University performed a physical inventory of all of its federally funded equipment in January 2024, which identified an additional 1,006 equipment items (with a NBV of $1,726,897) that could not be located, of which 839 were fully depreciated. University management believes these items were disposed of but not appropriately removed from the property records and federal equipment listing. As of June 30, 2023, the University’s federal equipment listing included 6,270 assets (with a NBV of $61,390,724) purchased with R&D Cluster program awards. We also noted the University’s controls for equipment dispositions are not operating at an appropriate level of precision to ensure equipment dispositions are properly authorized and property management records are updated on a timely basis. 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. Per 2 CFR 200.313(d)(3) and (4), a control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of property and adequate maintenance procedures must be developed to keep the property in good condition. 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 decentralized nature of the equipment recordkeeping process can result in delayed reporting of asset disposals. 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 reported in the prior year audit as finding number 2022-002. 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. Views of University Officials The University concurs with the finding and has begun to address these concerns. As noted in the finding, the University conducted a full federal equipment inventory in January 2024 and updated property records to ensure accuracy of federally funded equipment.
Finding 2023-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. Department of Education (USDE) U.S. Department of Energy (USDOE) U.S. Department of Health and Human Services (USDHHS) 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 State (USDOS) U.S. Department of Transportation (USDOT) U.S. Director of National Intelligence (USDNI) U.S. Environmental Protection Agency (USEPA) National Aeronautics and Space Administration (NASA) National Endowment for the Humanities (NEH) National Science Foundation (NSF) U.S. Department of Veteran Affairs (USDVA) All Pass-Through Entities Program Name: Research and Development Cluster ALN # and Program Expenditures: Various ($508,850,558) Federal Award Numbers: Various – See schedule of award numbers Federal Award Year: Various – See schedule of award numbers Questioned Costs: None Compliance Requirement: Equipment Type of Finding: Noncompliance and material weakness Condition Found The University did not consistently follow its property management policies and procedures related to maintaining accurate property management records for equipment purchased with federal R&D Cluster program awards. The University conducts research at multiple locations throughout its campus where equipment purchased with federal awards 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 which 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. The University is required to safeguard equipment purchased with federal awards, maintain current property records, and to perform a physical inventory of equipment purchased with federal awards on a biennial basis. During our physical observation of 60 pieces of equipment (with a net book value (NBV) of $224,269) purchased with federal R&D Cluster awards, we noted eight items (with a NBV totaling $0) selected for physical observation were not able to be located for our testing. In response to the exceptions identified in our audit procedures, the University performed a physical inventory of all of its federally funded equipment in January 2024, which identified an additional 1,006 equipment items (with a NBV of $1,726,897) that could not be located, of which 839 were fully depreciated. University management believes these items were disposed of but not appropriately removed from the property records and federal equipment listing. As of June 30, 2023, the University’s federal equipment listing included 6,270 assets (with a NBV of $61,390,724) purchased with R&D Cluster program awards. We also noted the University’s controls for equipment dispositions are not operating at an appropriate level of precision to ensure equipment dispositions are properly authorized and property management records are updated on a timely basis. 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. Per 2 CFR 200.313(d)(3) and (4), a control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of property and adequate maintenance procedures must be developed to keep the property in good condition. 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 decentralized nature of the equipment recordkeeping process can result in delayed reporting of asset disposals. 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 reported in the prior year audit as finding number 2022-002. 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. Views of University Officials The University concurs with the finding and has begun to address these concerns. As noted in the finding, the University conducted a full federal equipment inventory in January 2024 and updated property records to ensure accuracy of federally funded equipment.
Material Weakness Material Noncompliance Program: Assistance Listing: 84.425D – Elementary and Secondary School Emergency Relief Fund Repeat Finding: No Criteria: Under 2 CFR Part 200, entities receiving federal funds must follow the stricter of regulations between state and federal guidelines for purchasing and tracking equipment. Specifically, 2 CFR 313 requires recipients to maintain detailed property records for equipment acquired with federal awards. These records must include descriptions, identification numbers, funding sources, acquisition dates, costs, federal contribution percentages, locations, usage, conditions, and disposal information. Recipients must also update these records whenever the status of the property changes. Specifically, the Mississippi Public School Asset Management Manual requires school districts to maintain current inventories of property items valued at $1,000 or more. Additionally, other items, such as cameras, camera equipment, televisions, computers and computer equipment equal to or greater than $250, must be included in the inventory. Other equipment such as tools, furniture and other assets regardless of their purchase price or fair market value must be included. This also requires thorough tracking and management of school assets. Condition: The District’s internal controls over fixed asset inventory were inadequate to ensure that the District followed its internal control policies on fixed assets, which require all assets above a certain threshold and others regardless of cost to be listed in its fixed asset system. As a result, we observed approximately $260,627 in equipment purchased with federal grant (ESSER II) that was not properly included in the District’s fixed asset system. Context/ Perspective: This finding is a result of our statistically valid random sample of forty fixed assets inventory observation for single audit purposes and the conditions cited appear to be a systematic issue. Cause: The District’s internal control system is inadequate to ensure that the fixed asset system fulfilled the requirements of the current District internal control policy, “Fixed Asset Accountability” is inadequate. Effect: Failure to follow the federal and state requirements could affect future eligibility for federal award programs or could result in a loss or misappropriation of public assets. Questioned Costs: None Recommendation: We recommend that the District implement additional internal controls to improve the monitoring activities element of its current internal control system which will ensure that it fulfills the standards for Federal requirements of “Equipment and Real Property Management” contained in the U. S. Code of Federal Regulations, Title 2, Subtitle A, Chapter II, Part 200, Subpart D, section 200.313(d)(1). Views of Responsible Officials: The Auditee’s Corrective Action Plan on pages 99-100 lists the District’s response to the findings.
2023-006: Equipment (15.042) Criteria: CFR Section 200.313 under the Uniform Guidance requires a physical inventory of property acquired with federal dollars to be conducted at least once every two years. Condition: The District does not have physical inventory procedures in place for equipment purchased with federal dollars. Cause: Management oversight Effects: There is an increased risk that funds received for disposal of equipment purchased with federal dollars would not be retained by the program. Questioned Costs: None Context: The District was unable to provide support for a physical inventory of equipment purchased with federal dollars conducted in the last two years. Repeat Finding: No Recommendation: We recommend the District implement policies and procedures for conducting a physical inventory of equipment purchased with federal dollars at least once every two years. Management’s Response: The District will perform a physical inventory of all equipment purchased with federal dollars.
2023-006: Equipment (15.042) Criteria: CFR Section 200.313 under the Uniform Guidance requires a physical inventory of property acquired with federal dollars to be conducted at least once every two years. Condition: The District does not have physical inventory procedures in place for equipment purchased with federal dollars. Cause: Management oversight Effects: There is an increased risk that funds received for disposal of equipment purchased with federal dollars would not be retained by the program. Questioned Costs: None Context: The District was unable to provide support for a physical inventory of equipment purchased with federal dollars conducted in the last two years. Repeat Finding: No Recommendation: We recommend the District implement policies and procedures for conducting a physical inventory of equipment purchased with federal dollars at least once every two years. Management’s Response: The District will perform a physical inventory of all equipment purchased with federal dollars.
2023-006: Equipment (15.042) Criteria: CFR Section 200.313 under the Uniform Guidance requires a physical inventory of property acquired with federal dollars to be conducted at least once every two years. Condition: The District does not have physical inventory procedures in place for equipment purchased with federal dollars. Cause: Management oversight Effects: There is an increased risk that funds received for disposal of equipment purchased with federal dollars would not be retained by the program. Questioned Costs: None Context: The District was unable to provide support for a physical inventory of equipment purchased with federal dollars conducted in the last two years. Repeat Finding: No Recommendation: We recommend the District implement policies and procedures for conducting a physical inventory of equipment purchased with federal dollars at least once every two years. Management’s Response: The District will perform a physical inventory of all equipment purchased with federal dollars.
Federal Agency: U.S. Department of Education Federal Program Name: Elementary and Secondary Education School Emergency Relief and Governors Emergency Education Relief Fund Assistance Listing Number: 84.425D & 84.425C Federal Award Identification Number and Year: 2021 Pass-Through Agency: Wisconsin Department of Public Instruction Pass-Through Number(s): 2021-401253-DPI-GEERF-162, 2022-401253-DPI-ESSERFII-163 & 2022-401253-DPI-ESSERFIII-165 Award Period: July 1, 2020 through September 30, 2022, March 13, 2020 through September 30, 2029 and July 1, 2020 through September 30 ,2024 Type of Finding: Significant Deficiency in Internal Control over Compliance and Other Matter Criteria or specific requirement: 2 CFR section 200.313(d)(1) requires 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. Condition: The District’s capital asset records do not include all of the required aspects of property records as required by Uniform Guidance. The detail capital asset records do not identify the source of the funding for the property or the percentage of federal participation in the project costs for the federal award under which the property was acquired. Questioned costs: None Context: The Districts capital asset records are not currently designed to track the source and percentage of federal participation in a project as the District does not commonly utilize federal funding for capital purchases. Cause: The District has not designed and implemented controls to ensure capital asset records included all necessary information for assets purchased with federal awards. Effect: Capital asset records for assets purchased, wholly or partially, with federal awards do not include all necessary details as required by Uniform Guidance. Repeat Finding: The finding is not a repeat finding. Recommendation: We recommend the District design and implement capital asset record procedures and controls that ensure all necessary information is track in capital asset records for assets purchased with federal awards. Views of responsible officials: There is no disagreement with the audit finding.
Federal Agency: U.S. Department of Education Federal Program Name: Elementary and Secondary Education School Emergency Relief and Governors Emergency Education Relief Fund Assistance Listing Number: 84.425D & 84.425C Federal Award Identification Number and Year: 2021 Pass-Through Agency: Wisconsin Department of Public Instruction Pass-Through Number(s): 2021-401253-DPI-GEERF-162, 2022-401253-DPI-ESSERFII-163 & 2022-401253-DPI-ESSERFIII-165 Award Period: July 1, 2020 through September 30, 2022, March 13, 2020 through September 30, 2029 and July 1, 2020 through September 30 ,2024 Type of Finding: Significant Deficiency in Internal Control over Compliance and Other Matter Criteria or specific requirement: 2 CFR section 200.313(d)(1) requires 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. Condition: The District’s capital asset records do not include all of the required aspects of property records as required by Uniform Guidance. The detail capital asset records do not identify the source of the funding for the property or the percentage of federal participation in the project costs for the federal award under which the property was acquired. Questioned costs: None Context: The Districts capital asset records are not currently designed to track the source and percentage of federal participation in a project as the District does not commonly utilize federal funding for capital purchases. Cause: The District has not designed and implemented controls to ensure capital asset records included all necessary information for assets purchased with federal awards. Effect: Capital asset records for assets purchased, wholly or partially, with federal awards do not include all necessary details as required by Uniform Guidance. Repeat Finding: The finding is not a repeat finding. Recommendation: We recommend the District design and implement capital asset record procedures and controls that ensure all necessary information is track in capital asset records for assets purchased with federal awards. Views of responsible officials: There is no disagreement with the audit finding.
Federal Agency: U.S. Department of Education Federal Program Name: Elementary and Secondary Education School Emergency Relief and Governors Emergency Education Relief Fund Assistance Listing Number: 84.425D & 84.425C Federal Award Identification Number and Year: 2021 Pass-Through Agency: Wisconsin Department of Public Instruction Pass-Through Number(s): 2021-401253-DPI-GEERF-162, 2022-401253-DPI-ESSERFII-163 & 2022-401253-DPI-ESSERFIII-165 Award Period: July 1, 2020 through September 30, 2022, March 13, 2020 through September 30, 2029 and July 1, 2020 through September 30 ,2024 Type of Finding: Significant Deficiency in Internal Control over Compliance and Other Matter Criteria or specific requirement: 2 CFR section 200.313(d)(1) requires 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. Condition: The District’s capital asset records do not include all of the required aspects of property records as required by Uniform Guidance. The detail capital asset records do not identify the source of the funding for the property or the percentage of federal participation in the project costs for the federal award under which the property was acquired. Questioned costs: None Context: The Districts capital asset records are not currently designed to track the source and percentage of federal participation in a project as the District does not commonly utilize federal funding for capital purchases. Cause: The District has not designed and implemented controls to ensure capital asset records included all necessary information for assets purchased with federal awards. Effect: Capital asset records for assets purchased, wholly or partially, with federal awards do not include all necessary details as required by Uniform Guidance. Repeat Finding: The finding is not a repeat finding. Recommendation: We recommend the District design and implement capital asset record procedures and controls that ensure all necessary information is track in capital asset records for assets purchased with federal awards. Views of responsible officials: There is no disagreement with the audit finding.
CRITERIA/SPECIFIC REQUIREMENT: The Regional Office of Education No. 39 did not have adequate record keeping over its equipment acquired from federal funds. The Code of Federal Regulations (2 CFR §200.313(d)(1)) requires that procedures for managing equipment acquired with federal funds must maintain property records that include the following information: (i) a description of the property, (ii) manufacturer’s serial number or other identification number, (iii) source of the funding for the property (including the FAIN), (iv) who holds title, (v) acquisition date (vi) cost of the property, (vii) percentage of federal contribution in the project cost for the Federal award under which the property was acquired, (viii) location (ix) use and condition of the property, and (x) and any ultimate disposition data, including date of disposal and sale price of the property. Moreover, the Code (2 CFR §200.313(d)(2)) requires that a physical inventory of the property must be taken and the results reconciled with the property records at least once every two years. In addition, the Code (2 CFR §200.303 (a)) requires the Regional Office of Education No. 39 to establish and maintain effective internal control over the federal award to provide reasonable assurance the Regional Office of Education No. 39 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 record keeping and monitoring of equipment acquired from federal funds. CONDITION: The Regional Office of Education No. 39 asset details in the property records include only the description of the property, acquisition date, and cost of the property. The other minimum requirements specified by the Code are not included in the property records. Moreover, the Regional Office of Education No. 39 was unable to properly account for the results of its physical inventory count and only performed partial reconciliation. EFFECT: Inadequate record keeping over equipment acquired from federal funds may result in noncompliance with the Code. Additionally, incomplete reconciliation of physical inventory can lead to discrepancies in financial reporting, affecting overall accountability. CAUSE: Management indicated the issue was due to oversight and lack of training on requirements by the previous management. RECOMMENDATION: We recommend the Regional Office of Education No. 39 comply with federal regulations by monitoring equipment acquired from federal funds and establish a regular schedule for comprehensive reconciliation of physical inventory to ensure accurate financial reporting and enhance overall accountability. MANAGEMENT’S RESPONSE: The Regional Office of Education No. 39 agrees with the audit findings and is implementing documents and procedures to meet requirements in the future.
CRITERIA/SPECIFIC REQUIREMENT: The Regional Office of Education No. 39 did not have adequate record keeping over its equipment acquired from federal funds. The Code of Federal Regulations (2 CFR §200.313(d)(1)) requires that procedures for managing equipment acquired with federal funds must maintain property records that include the following information: (i) a description of the property, (ii) manufacturer’s serial number or other identification number, (iii) source of the funding for the property (including the FAIN), (iv) who holds title, (v) acquisition date (vi) cost of the property, (vii) percentage of federal contribution in the project cost for the Federal award under which the property was acquired, (viii) location (ix) use and condition of the property, and (x) and any ultimate disposition data, including date of disposal and sale price of the property. Moreover, the Code (2 CFR §200.313(d)(2)) requires that a physical inventory of the property must be taken and the results reconciled with the property records at least once every two years. In addition, the Code (2 CFR §200.303 (a)) requires the Regional Office of Education No. 39 to establish and maintain effective internal control over the federal award to provide reasonable assurance the Regional Office of Education No. 39 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 record keeping and monitoring of equipment acquired from federal funds. CONDITION: The Regional Office of Education No. 39 asset details in the property records include only the description of the property, acquisition date, and cost of the property. The other minimum requirements specified by the Code are not included in the property records. Moreover, the Regional Office of Education No. 39 was unable to properly account for the results of its physical inventory count and only performed partial reconciliation. EFFECT: Inadequate record keeping over equipment acquired from federal funds may result in noncompliance with the Code. Additionally, incomplete reconciliation of physical inventory can lead to discrepancies in financial reporting, affecting overall accountability. CAUSE: Management indicated the issue was due to oversight and lack of training on requirements by the previous management. RECOMMENDATION: We recommend the Regional Office of Education No. 39 comply with federal regulations by monitoring equipment acquired from federal funds and establish a regular schedule for comprehensive reconciliation of physical inventory to ensure accurate financial reporting and enhance overall accountability. MANAGEMENT’S RESPONSE: The Regional Office of Education No. 39 agrees with the audit findings and is implementing documents and procedures to meet requirements in the future.
CRITERIA/SPECIFIC REQUIREMENT: The Regional Office of Education No. 39 did not have adequate record keeping over its equipment acquired from federal funds. The Code of Federal Regulations (2 CFR §200.313(d)(1)) requires that procedures for managing equipment acquired with federal funds must maintain property records that include the following information: (i) a description of the property, (ii) manufacturer’s serial number or other identification number, (iii) source of the funding for the property (including the FAIN), (iv) who holds title, (v) acquisition date (vi) cost of the property, (vii) percentage of federal contribution in the project cost for the Federal award under which the property was acquired, (viii) location (ix) use and condition of the property, and (x) and any ultimate disposition data, including date of disposal and sale price of the property. Moreover, the Code (2 CFR §200.313(d)(2)) requires that a physical inventory of the property must be taken and the results reconciled with the property records at least once every two years. In addition, the Code (2 CFR §200.303 (a)) requires the Regional Office of Education No. 39 to establish and maintain effective internal control over the federal award to provide reasonable assurance the Regional Office of Education No. 39 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 record keeping and monitoring of equipment acquired from federal funds. CONDITION: The Regional Office of Education No. 39 asset details in the property records include only the description of the property, acquisition date, and cost of the property. The other minimum requirements specified by the Code are not included in the property records. Moreover, the Regional Office of Education No. 39 was unable to properly account for the results of its physical inventory count and only performed partial reconciliation. EFFECT: Inadequate record keeping over equipment acquired from federal funds may result in noncompliance with the Code. Additionally, incomplete reconciliation of physical inventory can lead to discrepancies in financial reporting, affecting overall accountability. CAUSE: Management indicated the issue was due to oversight and lack of training on requirements by the previous management. RECOMMENDATION: We recommend the Regional Office of Education No. 39 comply with federal regulations by monitoring equipment acquired from federal funds and establish a regular schedule for comprehensive reconciliation of physical inventory to ensure accurate financial reporting and enhance overall accountability. MANAGEMENT’S RESPONSE: The Regional Office of Education No. 39 agrees with the audit findings and is implementing documents and procedures to meet requirements in the future.
Statement of condition: Property records for equipment acquired under the Education Stabilization Fund program were not maintained. Criteria: Title 2 U.S. Code of Federal Regulations (CFR) 200.313(d)(1) requires that property records 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 ate of disposal and sales price of the property. Per the school’s policies, property records should be maintained for all equipment and theft-sensitive assets. Cause of condition: Procedures are in place for property records to be maintained for all equipment acquired during the fiscal year. However, these procedures do no include maintaining all of the information required by 2 CFR 200.313(d)(1). Effect of condition: During testing, it was noted that property records including all required information were not maintained for capital assets acquired under the Education Stabilization Fund program. Context: Property included school buses and various computer equipment and furniture and fixtures was acquired during the fiscal year, records including a description of the property, the acquisition date, and the cost of the property are being maintained. However, the property records do not include various additional information as required by 2 CFR 200.313(d)(1). Recommendation: Procedures should be put in place to ensure that property records including all required information are maintained for all capital assts purchased by the School in accordance with 2 CFR 200.313(d)(1). View of responsible officials and planned corrective actions: Management agrees with this finding and will put procedures in place to maintain adequate property records. See 2023-004 for management’s detailed action plan, timeline, and the responsible parties for all Education Stabilization Fund findings.
Statement of condition: A physical inventory of property was not performed within the last two years. Criteria: Title 2 U.S. Code of Federal Regulations (CFR) 200.313(d)(2) requires that a physical inventory of property must be conducted, and the results must be reconciled with the property records at least once every two years. Cause of condition: A physical inventory of property was planned for the current fiscal year, however, due to high employee turnover, this inventory was never performed. Effect of condition: The School was not in compliance with 2 CFR 200.313(d)(2) as a physical inventory of property had not been performed within the past two years. Context: Property including school buses and various computer equipment and furniture and fixtures was acquired under the Education Stabilization Fund program. A physical inventory of this property has not been performed with the past two years as required by 2 CFR 200.313(d)(2). Recommendation: Procedures should be put in place to ensure that a physical inventory of property is being performed every two years in accordance with 2 CFR 200.313(d)(2). Views of responsible officials and planned corrective actions: Management agrees with this finding and will put procedures in place to perform a physical inventory of property at least once every two years. See 2023-004 for management’s detailed action plan, timeline, and the responsible parties for all Education Stabilization Fund findings.
Statement of condition: Property records for equipment acquired under the Education Stabilization Fund program were not maintained. Criteria: Title 2 U.S. Code of Federal Regulations (CFR) 200.313(d)(1) requires that property records 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 ate of disposal and sales price of the property. Per the school’s policies, property records should be maintained for all equipment and theft-sensitive assets. Cause of condition: Procedures are in place for property records to be maintained for all equipment acquired during the fiscal year. However, these procedures do no include maintaining all of the information required by 2 CFR 200.313(d)(1). Effect of condition: During testing, it was noted that property records including all required information were not maintained for capital assets acquired under the Education Stabilization Fund program. Context: Property included school buses and various computer equipment and furniture and fixtures was acquired during the fiscal year, records including a description of the property, the acquisition date, and the cost of the property are being maintained. However, the property records do not include various additional information as required by 2 CFR 200.313(d)(1). Recommendation: Procedures should be put in place to ensure that property records including all required information are maintained for all capital assts purchased by the School in accordance with 2 CFR 200.313(d)(1). View of responsible officials and planned corrective actions: Management agrees with this finding and will put procedures in place to maintain adequate property records. See 2023-004 for management’s detailed action plan, timeline, and the responsible parties for all Education Stabilization Fund findings.
Statement of condition: A physical inventory of property was not performed within the last two years. Criteria: Title 2 U.S. Code of Federal Regulations (CFR) 200.313(d)(2) requires that a physical inventory of property must be conducted, and the results must be reconciled with the property records at least once every two years. Cause of condition: A physical inventory of property was planned for the current fiscal year, however, due to high employee turnover, this inventory was never performed. Effect of condition: The School was not in compliance with 2 CFR 200.313(d)(2) as a physical inventory of property had not been performed within the past two years. Context: Property including school buses and various computer equipment and furniture and fixtures was acquired under the Education Stabilization Fund program. A physical inventory of this property has not been performed with the past two years as required by 2 CFR 200.313(d)(2). Recommendation: Procedures should be put in place to ensure that a physical inventory of property is being performed every two years in accordance with 2 CFR 200.313(d)(2). Views of responsible officials and planned corrective actions: Management agrees with this finding and will put procedures in place to perform a physical inventory of property at least once every two years. See 2023-004 for management’s detailed action plan, timeline, and the responsible parties for all Education Stabilization Fund findings.
Statement of condition: Property records for equipment acquired under the Education Stabilization Fund program were not maintained. Criteria: Title 2 U.S. Code of Federal Regulations (CFR) 200.313(d)(1) requires that property records 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 ate of disposal and sales price of the property. Per the school’s policies, property records should be maintained for all equipment and theft-sensitive assets. Cause of condition: Procedures are in place for property records to be maintained for all equipment acquired during the fiscal year. However, these procedures do no include maintaining all of the information required by 2 CFR 200.313(d)(1). Effect of condition: During testing, it was noted that property records including all required information were not maintained for capital assets acquired under the Education Stabilization Fund program. Context: Property included school buses and various computer equipment and furniture and fixtures was acquired during the fiscal year, records including a description of the property, the acquisition date, and the cost of the property are being maintained. However, the property records do not include various additional information as required by 2 CFR 200.313(d)(1). Recommendation: Procedures should be put in place to ensure that property records including all required information are maintained for all capital assts purchased by the School in accordance with 2 CFR 200.313(d)(1). View of responsible officials and planned corrective actions: Management agrees with this finding and will put procedures in place to maintain adequate property records. See 2023-004 for management’s detailed action plan, timeline, and the responsible parties for all Education Stabilization Fund findings.
Statement of condition: A physical inventory of property was not performed within the last two years. Criteria: Title 2 U.S. Code of Federal Regulations (CFR) 200.313(d)(2) requires that a physical inventory of property must be conducted, and the results must be reconciled with the property records at least once every two years. Cause of condition: A physical inventory of property was planned for the current fiscal year, however, due to high employee turnover, this inventory was never performed. Effect of condition: The School was not in compliance with 2 CFR 200.313(d)(2) as a physical inventory of property had not been performed within the past two years. Context: Property including school buses and various computer equipment and furniture and fixtures was acquired under the Education Stabilization Fund program. A physical inventory of this property has not been performed with the past two years as required by 2 CFR 200.313(d)(2). Recommendation: Procedures should be put in place to ensure that a physical inventory of property is being performed every two years in accordance with 2 CFR 200.313(d)(2). Views of responsible officials and planned corrective actions: Management agrees with this finding and will put procedures in place to perform a physical inventory of property at least once every two years. See 2023-004 for management’s detailed action plan, timeline, and the responsible parties for all Education Stabilization Fund findings.
Federal Assistance Listing Number: 84.425D and 84.425U Federal Program Name: COVID-19 - Education Stabilization Fund Federal Agency: U.S. Department of Education Pass-Through Name: Wisconsin Department of Public Instruction Pass-Through Identification Number: 2022 - 403619 - DPI - ESSERFII - 163 and 2022 - 403619 - DPI - ESSERFIII - 165 Criteria: In accordance with 2 CFR 200.313(d)(1), property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the FAIN), who holds title, the acquisition date and cost of the property, percentage of Federal participation in the project costs for the Federal award under which the property was acquired, the location, use and condition of the property and any ultimate disposition data including the date of disposal and sale price of the property. Condition/Context: The District maintains a list of capitalized equipment in BusinessPlus using the Fixed Asset module. However, of the three pieces of equipment sampled, one was put into service in January 2023 but was not entered into BusinessPlus until the subsequent fiscal year. Additionally, the other two pieces of equipment sampled did not contain all the required information in BusinessPlus. The following pieces of information were missing from the listing: • the source of funding for the property (including the FAIN), • who holds title, and • the sales price of the property, if disposed. This was not a statistically valid sample. Cause: The Department of Facilities and Maintenance services had staff changes, and it was not discovered until well after the new staff were in place that the former staff member had missed entering the record. Additionally, the District was unaware of the property records requirement as equipment is not frequently purchased with federal funds. Effect: When the funding source for fixed assets is not tracked, if an asset is disposed of via a sale, the federal program may not receive the proceeds of the sale at the appropriate proportional rate. Questioned Costs: None noted. Recommendation: We recommend that the District enter fixed assets into BusinessPlus in a timely manner and record all the information required by the Uniform Guidance. Views of Responsible Officials: Management concurs with the finding.
Federal Assistance Listing Number: 84.425D and 84.425U Federal Program Name: COVID-19 - Education Stabilization Fund Federal Agency: U.S. Department of Education Pass-Through Name: Wisconsin Department of Public Instruction Pass-Through Identification Number: 2022 - 403619 - DPI - ESSERFII - 163 and 2022 - 403619 - DPI - ESSERFIII - 165 Criteria: In accordance with 2 CFR 200.313(d)(1), property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the FAIN), who holds title, the acquisition date and cost of the property, percentage of Federal participation in the project costs for the Federal award under which the property was acquired, the location, use and condition of the property and any ultimate disposition data including the date of disposal and sale price of the property. Condition/Context: The District maintains a list of capitalized equipment in BusinessPlus using the Fixed Asset module. However, of the three pieces of equipment sampled, one was put into service in January 2023 but was not entered into BusinessPlus until the subsequent fiscal year. Additionally, the other two pieces of equipment sampled did not contain all the required information in BusinessPlus. The following pieces of information were missing from the listing: • the source of funding for the property (including the FAIN), • who holds title, and • the sales price of the property, if disposed. This was not a statistically valid sample. Cause: The Department of Facilities and Maintenance services had staff changes, and it was not discovered until well after the new staff were in place that the former staff member had missed entering the record. Additionally, the District was unaware of the property records requirement as equipment is not frequently purchased with federal funds. Effect: When the funding source for fixed assets is not tracked, if an asset is disposed of via a sale, the federal program may not receive the proceeds of the sale at the appropriate proportional rate. Questioned Costs: None noted. Recommendation: We recommend that the District enter fixed assets into BusinessPlus in a timely manner and record all the information required by the Uniform Guidance. Views of Responsible Officials: Management concurs with the finding.
2023-005 U.S. Department of Education, Assistance Listing #84.425D and #84.425U, Elementary and Secondary School Emergency Relief Funds for the year July 1, 2022 through June 30, 2023 Criteria: In accordance with 2 CFR 200.313, property records for equipment and real property purchased with Federal funds must be maintained that include a description of the property, a serial number or other identification number, the source funding for the property, who holds title, the acquisition date, cost of the property, percentage of federal participation in the project costs for the Federal award, the location, use, and condition of the property. Condition: The Facilities Department maintains a spreadsheet of capital assets purchased with Elementary and Secondary School Emergency Relief Funds (ESSER) funds for assets procured through the Facilities Department. The City Finance Department also maintains a capital asset listing for financial reporting purposes, however, assets funded by grant proceeds are not separately identified in the listing. In addition, during the audit, three assets funded with ESSER funds totaling $444,842 had not been capitalized in the City’s financial reporting system. The two lists are not cross checked to ensure all ESSER purchases have been identified. Cause: There are no formal procedures for tracking Federally funded assets. Effect: Federally funded assets are not identified and tracked. If the City were to sell a Federally funded asset, they may be required to remit some of the proceeds back to the grantor agency. Therefore, if the asset was not properly identified and tracked the City could inadvertently profit from the Federal funding. Recommendation: It is our recommendation that procedures be established for the tracking of federally funded assets.
2023-005 U.S. Department of Education, Assistance Listing #84.425D and #84.425U, Elementary and Secondary School Emergency Relief Funds for the year July 1, 2022 through June 30, 2023 Criteria: In accordance with 2 CFR 200.313, property records for equipment and real property purchased with Federal funds must be maintained that include a description of the property, a serial number or other identification number, the source funding for the property, who holds title, the acquisition date, cost of the property, percentage of federal participation in the project costs for the Federal award, the location, use, and condition of the property. Condition: The Facilities Department maintains a spreadsheet of capital assets purchased with Elementary and Secondary School Emergency Relief Funds (ESSER) funds for assets procured through the Facilities Department. The City Finance Department also maintains a capital asset listing for financial reporting purposes, however, assets funded by grant proceeds are not separately identified in the listing. In addition, during the audit, three assets funded with ESSER funds totaling $444,842 had not been capitalized in the City’s financial reporting system. The two lists are not cross checked to ensure all ESSER purchases have been identified. Cause: There are no formal procedures for tracking Federally funded assets. Effect: Federally funded assets are not identified and tracked. If the City were to sell a Federally funded asset, they may be required to remit some of the proceeds back to the grantor agency. Therefore, if the asset was not properly identified and tracked the City could inadvertently profit from the Federal funding. Recommendation: It is our recommendation that procedures be established for the tracking of federally funded assets.
2023-005 U.S. Department of Education, Assistance Listing #84.425D and #84.425U, Elementary and Secondary School Emergency Relief Funds for the year July 1, 2022 through June 30, 2023 Criteria: In accordance with 2 CFR 200.313, property records for equipment and real property purchased with Federal funds must be maintained that include a description of the property, a serial number or other identification number, the source funding for the property, who holds title, the acquisition date, cost of the property, percentage of federal participation in the project costs for the Federal award, the location, use, and condition of the property. Condition: The Facilities Department maintains a spreadsheet of capital assets purchased with Elementary and Secondary School Emergency Relief Funds (ESSER) funds for assets procured through the Facilities Department. The City Finance Department also maintains a capital asset listing for financial reporting purposes, however, assets funded by grant proceeds are not separately identified in the listing. In addition, during the audit, three assets funded with ESSER funds totaling $444,842 had not been capitalized in the City’s financial reporting system. The two lists are not cross checked to ensure all ESSER purchases have been identified. Cause: There are no formal procedures for tracking Federally funded assets. Effect: Federally funded assets are not identified and tracked. If the City were to sell a Federally funded asset, they may be required to remit some of the proceeds back to the grantor agency. Therefore, if the asset was not properly identified and tracked the City could inadvertently profit from the Federal funding. Recommendation: It is our recommendation that procedures be established for the tracking of federally funded assets.
2023-005 U.S. Department of Education, Assistance Listing #84.425D and #84.425U, Elementary and Secondary School Emergency Relief Funds for the year July 1, 2022 through June 30, 2023 Criteria: In accordance with 2 CFR 200.313, property records for equipment and real property purchased with Federal funds must be maintained that include a description of the property, a serial number or other identification number, the source funding for the property, who holds title, the acquisition date, cost of the property, percentage of federal participation in the project costs for the Federal award, the location, use, and condition of the property. Condition: The Facilities Department maintains a spreadsheet of capital assets purchased with Elementary and Secondary School Emergency Relief Funds (ESSER) funds for assets procured through the Facilities Department. The City Finance Department also maintains a capital asset listing for financial reporting purposes, however, assets funded by grant proceeds are not separately identified in the listing. In addition, during the audit, three assets funded with ESSER funds totaling $444,842 had not been capitalized in the City’s financial reporting system. The two lists are not cross checked to ensure all ESSER purchases have been identified. Cause: There are no formal procedures for tracking Federally funded assets. Effect: Federally funded assets are not identified and tracked. If the City were to sell a Federally funded asset, they may be required to remit some of the proceeds back to the grantor agency. Therefore, if the asset was not properly identified and tracked the City could inadvertently profit from the Federal funding. Recommendation: It is our recommendation that procedures be established for the tracking of federally funded assets.
2023-005 U.S. Department of Education, Assistance Listing #84.425D and #84.425U, Elementary and Secondary School Emergency Relief Funds for the year July 1, 2022 through June 30, 2023 Criteria: In accordance with 2 CFR 200.313, property records for equipment and real property purchased with Federal funds must be maintained that include a description of the property, a serial number or other identification number, the source funding for the property, who holds title, the acquisition date, cost of the property, percentage of federal participation in the project costs for the Federal award, the location, use, and condition of the property. Condition: The Facilities Department maintains a spreadsheet of capital assets purchased with Elementary and Secondary School Emergency Relief Funds (ESSER) funds for assets procured through the Facilities Department. The City Finance Department also maintains a capital asset listing for financial reporting purposes, however, assets funded by grant proceeds are not separately identified in the listing. In addition, during the audit, three assets funded with ESSER funds totaling $444,842 had not been capitalized in the City’s financial reporting system. The two lists are not cross checked to ensure all ESSER purchases have been identified. Cause: There are no formal procedures for tracking Federally funded assets. Effect: Federally funded assets are not identified and tracked. If the City were to sell a Federally funded asset, they may be required to remit some of the proceeds back to the grantor agency. Therefore, if the asset was not properly identified and tracked the City could inadvertently profit from the Federal funding. Recommendation: It is our recommendation that procedures be established for the tracking of federally funded assets.