2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-003 – Equipment and real property management Cluster: Research and Development Sponsoring Agency: Various Award Names: All awards for 3 campuses with federal equipment expenditures in the Schedules of Expenditures of Federal Awards (“SEFA”) Award Numbers: Various Assistance Listing Titles: Various Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA Award Year: 2022-2023 Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA Criteria 2 CFR 200.313(d) requires that a physical inventory of equipment acquired in whole or in part under a Federal award must be taken and the results reconciled with the property records at least once every two years. Condition Through our testing of federal equipment and real property management across three campuses, we noted the following: • One campus has a control by which all custodians are responsible for the completion of their federal equipment inventory on a 2-year rolling basis, which includes timely review and approval of the Physical Inventory Certification Form. Through our testing of 12 custodians, out of a population of 120, we noted that 11 custodians did not complete the Physical Inventory Certification Form within the two-year timeframe. On average these certifications were completed 263 days late. • At a second campus, we noted a similar control in which a Department Inventorial Equipment Certification form is periodically required to be signed and submitted by each custodian. Through our testing of timeliness and approval of equipment inventories being performed by custodian, we selected 15 custodians, out of a population of 153, to ensure timely submission and approval of this form and noted the following: o Three of the sampled custodians submitted forms in early FY2022 and the next form was not due based on campus policy until FY2024; due dates for which were all beyond the two-year requirement. On average, using the scheduled due dates based on campus policy, these inventories would be 63 days late. o Eleven of the sampled custodians submitted the latest certifications during FY2022, FY2023 or FY2024, however, when compared to the date of the previous submission, the submissions were on average 274 days late when compared to the Uniform Guidance biennial requirement. • At a third campus, we selected seven custodians for equipment observation procedures and for those seven custodians also obtained their annual inventory certification form, which was completed on a timely basis. One of the certifications that is attested to on this form is that the last inventory date on the equipment for which the custodian is responsible has been inventoried within the last two years. Through review of the underlying detail for these seven custodians, we noted two custodians with equipment that had not been inventoried within the two-year timeframe. For context, one custodian had 261 out of 972 pieces of equipment that had not been inventoried within the two year-period; a second custodian had 542 out of 569 assets that had not been inventoried within the two-year period, including 473 pieces having last inventory dates during calendar years 2012-2019. Cause • In the case of the first campus, we understand that many of the custodians continue to work remotely and adhering to the required timeframe has been difficult to enforce. • In the case of the second campus, federal equipment inventory dates are assigned based on a system algorithm, which allocates due dates ratably across the custodians. This algorithm does not, however, take into account when the last inventory was completed and the biennial requirement. Additionally, we understand this campus has custodians working remotely and request extensions on their inventory requirement, however, when granting such extensions, the biennial requirement is not considered. • In the case of the third campus, the custodians indicated that they completed the inventories as certified, however, due to the volume of assets they either do not update the dates in the equipment management system or update them well after-the-fact due to a manual process. There is no central review of the underlying equipment management system detail to validate “last inventory dates” and thus no monitoring to ensure inventory dates are updated by custodians in the equipment management system. Effect Federal equipment inventories that are not completed in a timely manner, could result in assets purchased with federal funds not being appropriately safeguarded. Questioned Costs None noted. Recommendation We recommend the campuses review their federal equipment policies and procedures and implement controls to ensure federal equipment inventories are completed on a timely basis in accordance with the Uniform Guidance requirements and that underlying details in the equipment management systems get updated timely, as applicable. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
FINDING 2023-003 Subject: COVID-19 - Education Stabilization Fund - Equipment and Real Property Management Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Number: 84.425U Federal Award Number: S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Equipment and Real Property Management Audit Findings: Material Weakness, Modified Opinion Condition and Context A property record or capital asset listing which would include a description of the property, a serial number or other identification number, the source of funding for the property (including the federal award identification number (FAIN)), who holds title, the acquisition date, cost of the property, percentage of federal participation in the project costs for the federal award under which the property was acquired, the location, and use and condition of the property is to be maintained for assets purchased that exceed the School Corporation's capitalization threshold. The School Corporation purchased the following items during the audit period: an HVAC system in the amount of $1,420,440; paving for a traffic improvement project in the amount of $1,069,051; and a dehumidification unit for the pool in the amount of $328,076. The dehumidification unit for the pool was added to the capital asset listing; however, the source of the funding, who holds title, percentage of federal participation in the project costs for the federal award, and the condition of property were not noted. The HVAC system and the traffic improvement project were not included on the asset listing. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." INDIANA STATE BOARD OF ACCOUNTS 18 NORTH ADAMS COMMUNITY SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 2 CFR 200.313(d)(1) states: "Property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the FAIN), who holds title, the acquisition date, 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." Cause A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, assets purchased with federal dollars were not properly added to the School Corporation's asset listing. In addition, the one asset added did not have all the required elements. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure asset records include all the necessary information and new assets are added. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-003 Subject: COVID-19 - Education Stabilization Fund - Equipment and Real Property Management Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Number: 84.425U Federal Award Number: S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Equipment and Real Property Management Audit Findings: Material Weakness, Modified Opinion Condition and Context A property record or capital asset listing which would include a description of the property, a serial number or other identification number, the source of funding for the property (including the federal award identification number (FAIN)), who holds title, the acquisition date, cost of the property, percentage of federal participation in the project costs for the federal award under which the property was acquired, the location, and use and condition of the property is to be maintained for assets purchased that exceed the School Corporation's capitalization threshold. The School Corporation purchased the following items during the audit period: an HVAC system in the amount of $1,420,440; paving for a traffic improvement project in the amount of $1,069,051; and a dehumidification unit for the pool in the amount of $328,076. The dehumidification unit for the pool was added to the capital asset listing; however, the source of the funding, who holds title, percentage of federal participation in the project costs for the federal award, and the condition of property were not noted. The HVAC system and the traffic improvement project were not included on the asset listing. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." INDIANA STATE BOARD OF ACCOUNTS 18 NORTH ADAMS COMMUNITY SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 2 CFR 200.313(d)(1) states: "Property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the FAIN), who holds title, the acquisition date, 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." Cause A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, assets purchased with federal dollars were not properly added to the School Corporation's asset listing. In addition, the one asset added did not have all the required elements. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure asset records include all the necessary information and new assets are added. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-003 Subject: COVID-19 - Education Stabilization Fund - Equipment and Real Property Management Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Number: 84.425U Federal Award Number and Year (or Other Identifying Number): S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Equipment and Real Property Management Audit Findings: Material Weakness, Other Matters Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. A property record or capital asset listing which would include a description of the property, a serial number or other identification number, the source of funding for the property (including the federal award identification number (FAIN)), who holds title, the acquisition date, cost of the property, percentage of federal participation in the project costs for the federal award under which the property was acquired, the location, and use and condition of the property is to be maintained for assets purchased that exceed the School Corporation's capitalization threshold. During fiscal year 2022-2023, the School Corporation purchased two buses, totaling $168,884, out of ESSER III funds which exceeded the School Corporation's capitalization threshold. The two buses were added to the School Corporation's capital asset listing; however, the capital asset listing was missing a serial number or other identification number, the source of funding for the property (including the federal award identification number (FAIN)), who holds title, and the percentage of federal participation in the project costs. Additionally, the School Corporation did not complete a capital asset inventory every two years as required. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.313(d) states in part: "Management requirements. Procedures for managing equipment (including replacement equipment), whether acquired in whole or in part under a Federal award, until disposition takes place will, as a minimum, meet the following requirements: INDIANA STATE BOARD OF ACCOUNTS 20 MEDORA COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (1) Property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the FAIN), who holds title, the acquisition date, and cost of the property, percentage of Federal participation in the project costs for the Federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sale price of the property. (2) A physical inventory of the property must be taken and the results reconciled with the property records at least once every two years. . . ." Cause A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, the capital asset listing did not include all the required information and the required inventory was not completed. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure asset records include all the necessary information and an inventory is taken every two years. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-003 Subject: COVID-19 - Education Stabilization Fund - Equipment and Real Property Management Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Number: 84.425U Federal Award Number and Year (or Other Identifying Number): S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Equipment and Real Property Management Audit Findings: Material Weakness, Other Matters Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. A property record or capital asset listing which would include a description of the property, a serial number or other identification number, the source of funding for the property (including the federal award identification number (FAIN)), who holds title, the acquisition date, cost of the property, percentage of federal participation in the project costs for the federal award under which the property was acquired, the location, and use and condition of the property is to be maintained for assets purchased that exceed the School Corporation's capitalization threshold. During fiscal year 2022-2023, the School Corporation purchased two buses, totaling $168,884, out of ESSER III funds which exceeded the School Corporation's capitalization threshold. The two buses were added to the School Corporation's capital asset listing; however, the capital asset listing was missing a serial number or other identification number, the source of funding for the property (including the federal award identification number (FAIN)), who holds title, and the percentage of federal participation in the project costs. Additionally, the School Corporation did not complete a capital asset inventory every two years as required. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.313(d) states in part: "Management requirements. Procedures for managing equipment (including replacement equipment), whether acquired in whole or in part under a Federal award, until disposition takes place will, as a minimum, meet the following requirements: INDIANA STATE BOARD OF ACCOUNTS 20 MEDORA COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (1) Property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the FAIN), who holds title, the acquisition date, and cost of the property, percentage of Federal participation in the project costs for the Federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sale price of the property. (2) A physical inventory of the property must be taken and the results reconciled with the property records at least once every two years. . . ." Cause A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, the capital asset listing did not include all the required information and the required inventory was not completed. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure asset records include all the necessary information and an inventory is taken every two years. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
U.S. Department of Education Fund for the Improvement of Postsecondary Education - 84.116Z Award Number - P116Z220080 Criteria or Specific Requirement - Equipment and Real Property Management Non-federal entities other than states must follow 2 CFR sections 200.313 which require that property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the federal award identification number), who holds title, the acquisition date, cost of the property, percentage of federal participation in the project costs for the federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sales price of the property (2 CFR section 200.313(d)(1)). Condition - The College property records do not contain all of the information required under 2 CFR section 200.313. Questioned Costs - None noted. Context - Approximately $1,950,000 of the $2,081,000 of Federal expenditures in fiscal year 2023 were for equipment and real property. When performing testing, we noted that the College did not have proper tracking procedures in place for property records as the records did not contain a serial number or other identification number, there was no indication in the property records that the equipment and real property was purchased with Federal funds and the location, use and condition of the property was not identified. Cause - The College has not historically received federal awards that would allow for purchase of equipment and real property and therefore was not aware of the specific requirements. Effect - Failure to properly track and maintain equipment purchased with Federal funding could ultimately lead to loss of equipment procured with Federal funds or noncompliance with Uniform Guidance requirements. Identification as a repeat finding, if applicable - Not applicable. Recommendation - We recommend that management take necessary steps to ensure compliance with equipment and real property maintenance requirements to comply with 2 CFR section 200.313. View of Responsible Official and Planned Corrective Actions – Management agrees with the stated finding and has implemented a corrective action plan.
2023-002. Equipment and Real Property Management Education Stabilization Fund (ESF) COVID-19: Elementary and Secondary School Emergency Relief Fund ALN: 84.425D COVID-19: American Rescue Plan – Elementary and Secondary School Emergency Relief ALN: 84.425U COVID-19: American Rescue Plan – Elementary and Secondary School Emergency Relief – Homeless Children and Youth ALN: 84.425W Criteria: 2 CFR §200.313 of the Uniform Guidance issued by the U.S. Office of Management and Budget requires management to have procedures for managing equipment (including replacement equipment), whether acquired in whole or in part under a Federal award, until disposition takes place. This includes maintaining property records 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 (FAIN), and who holds title. In addition, it requires the District to track 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: The District did not include equipment purchased with Federal grant funds in its current year additions in the District’s capital assets inventory records. Cause: The District uses specific codes to identify and track equipment purchased during the year. Since the District did not have adequate procedures in place to review and reconcile the District’s equipment purchases codes to the annual capital asset additions, the equipment purchased under the Federal grants was inadvertently omitted from the current year capital assets inventory additions. Effect: The inability to include and differentiate capital assets acquired with Federal awards in the capital asset inventory records could lead to improper procedures for disposal of those capital assets. Questioned Costs: None reported. Context: The District rarely uses Federal grant funds for the purchase of equipment. As a result of this, when the District’s Purchasing Agent was compiling the listing of equipment purchased during the year, to be provided to the District’s third-party capital asset management company, the equipment purchased using Federal grant funds was inadvertently omitted from the listing. Recommendation: The District should implement procedures where there is a formal reconciliation performed annually for all of the District’s equipment expenditure codes and the additions to the District’s capital assets inventory. This will ensure that all equipment purchased with Federal funds is captured and included in the capital asset inventory records. Additionally, all capital asset additions purchased with Federal funds should be managed in accordance with 2 CFR §200.313. Views of Responsible Officials of Auditee: Management agrees with the finding and will ensure that the equipment purchased with Federal funds is identified and included in the District’s capital assets inventory records as part of the capital asset reconciliation process.
2023-002. Equipment and Real Property Management Education Stabilization Fund (ESF) COVID-19: Elementary and Secondary School Emergency Relief Fund ALN: 84.425D COVID-19: American Rescue Plan – Elementary and Secondary School Emergency Relief ALN: 84.425U COVID-19: American Rescue Plan – Elementary and Secondary School Emergency Relief – Homeless Children and Youth ALN: 84.425W Criteria: 2 CFR §200.313 of the Uniform Guidance issued by the U.S. Office of Management and Budget requires management to have procedures for managing equipment (including replacement equipment), whether acquired in whole or in part under a Federal award, until disposition takes place. This includes maintaining property records 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 (FAIN), and who holds title. In addition, it requires the District to track 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: The District did not include equipment purchased with Federal grant funds in its current year additions in the District’s capital assets inventory records. Cause: The District uses specific codes to identify and track equipment purchased during the year. Since the District did not have adequate procedures in place to review and reconcile the District’s equipment purchases codes to the annual capital asset additions, the equipment purchased under the Federal grants was inadvertently omitted from the current year capital assets inventory additions. Effect: The inability to include and differentiate capital assets acquired with Federal awards in the capital asset inventory records could lead to improper procedures for disposal of those capital assets. Questioned Costs: None reported. Context: The District rarely uses Federal grant funds for the purchase of equipment. As a result of this, when the District’s Purchasing Agent was compiling the listing of equipment purchased during the year, to be provided to the District’s third-party capital asset management company, the equipment purchased using Federal grant funds was inadvertently omitted from the listing. Recommendation: The District should implement procedures where there is a formal reconciliation performed annually for all of the District’s equipment expenditure codes and the additions to the District’s capital assets inventory. This will ensure that all equipment purchased with Federal funds is captured and included in the capital asset inventory records. Additionally, all capital asset additions purchased with Federal funds should be managed in accordance with 2 CFR §200.313. Views of Responsible Officials of Auditee: Management agrees with the finding and will ensure that the equipment purchased with Federal funds is identified and included in the District’s capital assets inventory records as part of the capital asset reconciliation process.