2023-002 – Equipment Management Cluster: Research and Development Cluster (“R&D Cluster”) Grantor: Various - All R&D Cluster awards with equipment Award Name: Various - All R&D Cluster awards with equipment Award Year: FY2023 Pass-through entities and ID Number: Various - All R&D Cluster awards with equipment Assistance Listing Number: Various – All R&D Cluster awards with equipment Condition The University has a process in place whereby a third-party is engaged to scan all equipment (federal and nonfederal) across their 3 campuses every two years. The third-party does not have a detailed listing when performing their inventory and thus the University must reconcile what was located by the thirdparty to their detailed equipment listing and understand why certain items were not located. If not located, follow-up is performed on an asset-by-asset basis by the University requesting the custodian of the asset confirm the equipment is on-hand. While we University provided evidence of the third-party inventory being performed, including a related manual reconciliation process, we were unable to obtain an aggregated reconciliation between the University equipment records and the third-party inventory results that included all follow-up information as the process is currently manual and disaggregated. Additionally, when scanning through the detailed listing of federal assets, certain equipment was noted to have an inventory date outside of the past 2 years. 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. Cause The University’s process for reviewing third-party equipment inventory results and conducting follow-up is manual, which can cause delays. Additionally, an aggregated reconciliation is not maintained, which can result in an incomplete or inaccurate inventory listing. Effect The lack of a formal reconciliation may result in incomplete equipment inventory records and/or certain assets not being physically inspected within the required 2-year period. Questioned Costs There are no questioned costs associated with this finding. Recommendation We recommend the University update their policies and procedures to require an aggregated reconciliation be maintained between third-party equipment inventory results and University equipment records. Additionally, the University should develop a more automated approach to resolving discrepancies between the third-party equipment inventory results and the federally funded equipment listing, rather than utilizing a manual process, which can cause delays. 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-002 – Equipment Management Cluster: Research and Development Cluster (“R&D Cluster”) Grantor: Various - All R&D Cluster awards with equipment Award Name: Various - All R&D Cluster awards with equipment Award Year: FY2023 Pass-through entities and ID Number: Various - All R&D Cluster awards with equipment Assistance Listing Number: Various – All R&D Cluster awards with equipment Condition The University has a process in place whereby a third-party is engaged to scan all equipment (federal and nonfederal) across their 3 campuses every two years. The third-party does not have a detailed listing when performing their inventory and thus the University must reconcile what was located by the thirdparty to their detailed equipment listing and understand why certain items were not located. If not located, follow-up is performed on an asset-by-asset basis by the University requesting the custodian of the asset confirm the equipment is on-hand. While we University provided evidence of the third-party inventory being performed, including a related manual reconciliation process, we were unable to obtain an aggregated reconciliation between the University equipment records and the third-party inventory results that included all follow-up information as the process is currently manual and disaggregated. Additionally, when scanning through the detailed listing of federal assets, certain equipment was noted to have an inventory date outside of the past 2 years. 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. Cause The University’s process for reviewing third-party equipment inventory results and conducting follow-up is manual, which can cause delays. Additionally, an aggregated reconciliation is not maintained, which can result in an incomplete or inaccurate inventory listing. Effect The lack of a formal reconciliation may result in incomplete equipment inventory records and/or certain assets not being physically inspected within the required 2-year period. Questioned Costs There are no questioned costs associated with this finding. Recommendation We recommend the University update their policies and procedures to require an aggregated reconciliation be maintained between third-party equipment inventory results and University equipment records. Additionally, the University should develop a more automated approach to resolving discrepancies between the third-party equipment inventory results and the federally funded equipment listing, rather than utilizing a manual process, which can cause delays. 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-002 – Equipment Management Cluster: Research and Development Cluster (“R&D Cluster”) Grantor: Various - All R&D Cluster awards with equipment Award Name: Various - All R&D Cluster awards with equipment Award Year: FY2023 Pass-through entities and ID Number: Various - All R&D Cluster awards with equipment Assistance Listing Number: Various – All R&D Cluster awards with equipment Condition The University has a process in place whereby a third-party is engaged to scan all equipment (federal and nonfederal) across their 3 campuses every two years. The third-party does not have a detailed listing when performing their inventory and thus the University must reconcile what was located by the thirdparty to their detailed equipment listing and understand why certain items were not located. If not located, follow-up is performed on an asset-by-asset basis by the University requesting the custodian of the asset confirm the equipment is on-hand. While we University provided evidence of the third-party inventory being performed, including a related manual reconciliation process, we were unable to obtain an aggregated reconciliation between the University equipment records and the third-party inventory results that included all follow-up information as the process is currently manual and disaggregated. Additionally, when scanning through the detailed listing of federal assets, certain equipment was noted to have an inventory date outside of the past 2 years. 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. Cause The University’s process for reviewing third-party equipment inventory results and conducting follow-up is manual, which can cause delays. Additionally, an aggregated reconciliation is not maintained, which can result in an incomplete or inaccurate inventory listing. Effect The lack of a formal reconciliation may result in incomplete equipment inventory records and/or certain assets not being physically inspected within the required 2-year period. Questioned Costs There are no questioned costs associated with this finding. Recommendation We recommend the University update their policies and procedures to require an aggregated reconciliation be maintained between third-party equipment inventory results and University equipment records. Additionally, the University should develop a more automated approach to resolving discrepancies between the third-party equipment inventory results and the federally funded equipment listing, rather than utilizing a manual process, which can cause delays. 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-002 – Equipment Management Cluster: Research and Development Cluster (“R&D Cluster”) Grantor: Various - All R&D Cluster awards with equipment Award Name: Various - All R&D Cluster awards with equipment Award Year: FY2023 Pass-through entities and ID Number: Various - All R&D Cluster awards with equipment Assistance Listing Number: Various – All R&D Cluster awards with equipment Condition The University has a process in place whereby a third-party is engaged to scan all equipment (federal and nonfederal) across their 3 campuses every two years. The third-party does not have a detailed listing when performing their inventory and thus the University must reconcile what was located by the thirdparty to their detailed equipment listing and understand why certain items were not located. If not located, follow-up is performed on an asset-by-asset basis by the University requesting the custodian of the asset confirm the equipment is on-hand. While we University provided evidence of the third-party inventory being performed, including a related manual reconciliation process, we were unable to obtain an aggregated reconciliation between the University equipment records and the third-party inventory results that included all follow-up information as the process is currently manual and disaggregated. Additionally, when scanning through the detailed listing of federal assets, certain equipment was noted to have an inventory date outside of the past 2 years. 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. Cause The University’s process for reviewing third-party equipment inventory results and conducting follow-up is manual, which can cause delays. Additionally, an aggregated reconciliation is not maintained, which can result in an incomplete or inaccurate inventory listing. Effect The lack of a formal reconciliation may result in incomplete equipment inventory records and/or certain assets not being physically inspected within the required 2-year period. Questioned Costs There are no questioned costs associated with this finding. Recommendation We recommend the University update their policies and procedures to require an aggregated reconciliation be maintained between third-party equipment inventory results and University equipment records. Additionally, the University should develop a more automated approach to resolving discrepancies between the third-party equipment inventory results and the federally funded equipment listing, rather than utilizing a manual process, which can cause delays. 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-002 – Equipment Management Cluster: Research and Development Cluster (“R&D Cluster”) Grantor: Various - All R&D Cluster awards with equipment Award Name: Various - All R&D Cluster awards with equipment Award Year: FY2023 Pass-through entities and ID Number: Various - All R&D Cluster awards with equipment Assistance Listing Number: Various – All R&D Cluster awards with equipment Condition The University has a process in place whereby a third-party is engaged to scan all equipment (federal and nonfederal) across their 3 campuses every two years. The third-party does not have a detailed listing when performing their inventory and thus the University must reconcile what was located by the thirdparty to their detailed equipment listing and understand why certain items were not located. If not located, follow-up is performed on an asset-by-asset basis by the University requesting the custodian of the asset confirm the equipment is on-hand. While we University provided evidence of the third-party inventory being performed, including a related manual reconciliation process, we were unable to obtain an aggregated reconciliation between the University equipment records and the third-party inventory results that included all follow-up information as the process is currently manual and disaggregated. Additionally, when scanning through the detailed listing of federal assets, certain equipment was noted to have an inventory date outside of the past 2 years. 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. Cause The University’s process for reviewing third-party equipment inventory results and conducting follow-up is manual, which can cause delays. Additionally, an aggregated reconciliation is not maintained, which can result in an incomplete or inaccurate inventory listing. Effect The lack of a formal reconciliation may result in incomplete equipment inventory records and/or certain assets not being physically inspected within the required 2-year period. Questioned Costs There are no questioned costs associated with this finding. Recommendation We recommend the University update their policies and procedures to require an aggregated reconciliation be maintained between third-party equipment inventory results and University equipment records. Additionally, the University should develop a more automated approach to resolving discrepancies between the third-party equipment inventory results and the federally funded equipment listing, rather than utilizing a manual process, which can cause delays. 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-002 – Equipment Management Cluster: Research and Development Cluster (“R&D Cluster”) Grantor: Various - All R&D Cluster awards with equipment Award Name: Various - All R&D Cluster awards with equipment Award Year: FY2023 Pass-through entities and ID Number: Various - All R&D Cluster awards with equipment Assistance Listing Number: Various – All R&D Cluster awards with equipment Condition The University has a process in place whereby a third-party is engaged to scan all equipment (federal and nonfederal) across their 3 campuses every two years. The third-party does not have a detailed listing when performing their inventory and thus the University must reconcile what was located by the thirdparty to their detailed equipment listing and understand why certain items were not located. If not located, follow-up is performed on an asset-by-asset basis by the University requesting the custodian of the asset confirm the equipment is on-hand. While we University provided evidence of the third-party inventory being performed, including a related manual reconciliation process, we were unable to obtain an aggregated reconciliation between the University equipment records and the third-party inventory results that included all follow-up information as the process is currently manual and disaggregated. Additionally, when scanning through the detailed listing of federal assets, certain equipment was noted to have an inventory date outside of the past 2 years. 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. Cause The University’s process for reviewing third-party equipment inventory results and conducting follow-up is manual, which can cause delays. Additionally, an aggregated reconciliation is not maintained, which can result in an incomplete or inaccurate inventory listing. Effect The lack of a formal reconciliation may result in incomplete equipment inventory records and/or certain assets not being physically inspected within the required 2-year period. Questioned Costs There are no questioned costs associated with this finding. Recommendation We recommend the University update their policies and procedures to require an aggregated reconciliation be maintained between third-party equipment inventory results and University equipment records. Additionally, the University should develop a more automated approach to resolving discrepancies between the third-party equipment inventory results and the federally funded equipment listing, rather than utilizing a manual process, which can cause delays. 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-002 – Equipment Management Cluster: Research and Development Cluster (“R&D Cluster”) Grantor: Various - All R&D Cluster awards with equipment Award Name: Various - All R&D Cluster awards with equipment Award Year: FY2023 Pass-through entities and ID Number: Various - All R&D Cluster awards with equipment Assistance Listing Number: Various – All R&D Cluster awards with equipment Condition The University has a process in place whereby a third-party is engaged to scan all equipment (federal and nonfederal) across their 3 campuses every two years. The third-party does not have a detailed listing when performing their inventory and thus the University must reconcile what was located by the thirdparty to their detailed equipment listing and understand why certain items were not located. If not located, follow-up is performed on an asset-by-asset basis by the University requesting the custodian of the asset confirm the equipment is on-hand. While we University provided evidence of the third-party inventory being performed, including a related manual reconciliation process, we were unable to obtain an aggregated reconciliation between the University equipment records and the third-party inventory results that included all follow-up information as the process is currently manual and disaggregated. Additionally, when scanning through the detailed listing of federal assets, certain equipment was noted to have an inventory date outside of the past 2 years. 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. Cause The University’s process for reviewing third-party equipment inventory results and conducting follow-up is manual, which can cause delays. Additionally, an aggregated reconciliation is not maintained, which can result in an incomplete or inaccurate inventory listing. Effect The lack of a formal reconciliation may result in incomplete equipment inventory records and/or certain assets not being physically inspected within the required 2-year period. Questioned Costs There are no questioned costs associated with this finding. Recommendation We recommend the University update their policies and procedures to require an aggregated reconciliation be maintained between third-party equipment inventory results and University equipment records. Additionally, the University should develop a more automated approach to resolving discrepancies between the third-party equipment inventory results and the federally funded equipment listing, rather than utilizing a manual process, which can cause delays. 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-002 – Equipment Management Cluster: Research and Development Cluster (“R&D Cluster”) Grantor: Various - All R&D Cluster awards with equipment Award Name: Various - All R&D Cluster awards with equipment Award Year: FY2023 Pass-through entities and ID Number: Various - All R&D Cluster awards with equipment Assistance Listing Number: Various – All R&D Cluster awards with equipment Condition The University has a process in place whereby a third-party is engaged to scan all equipment (federal and nonfederal) across their 3 campuses every two years. The third-party does not have a detailed listing when performing their inventory and thus the University must reconcile what was located by the thirdparty to their detailed equipment listing and understand why certain items were not located. If not located, follow-up is performed on an asset-by-asset basis by the University requesting the custodian of the asset confirm the equipment is on-hand. While we University provided evidence of the third-party inventory being performed, including a related manual reconciliation process, we were unable to obtain an aggregated reconciliation between the University equipment records and the third-party inventory results that included all follow-up information as the process is currently manual and disaggregated. Additionally, when scanning through the detailed listing of federal assets, certain equipment was noted to have an inventory date outside of the past 2 years. 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. Cause The University’s process for reviewing third-party equipment inventory results and conducting follow-up is manual, which can cause delays. Additionally, an aggregated reconciliation is not maintained, which can result in an incomplete or inaccurate inventory listing. Effect The lack of a formal reconciliation may result in incomplete equipment inventory records and/or certain assets not being physically inspected within the required 2-year period. Questioned Costs There are no questioned costs associated with this finding. Recommendation We recommend the University update their policies and procedures to require an aggregated reconciliation be maintained between third-party equipment inventory results and University equipment records. Additionally, the University should develop a more automated approach to resolving discrepancies between the third-party equipment inventory results and the federally funded equipment listing, rather than utilizing a manual process, which can cause delays. 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-002 – Equipment Management Cluster: Research and Development Cluster (“R&D Cluster”) Grantor: Various - All R&D Cluster awards with equipment Award Name: Various - All R&D Cluster awards with equipment Award Year: FY2023 Pass-through entities and ID Number: Various - All R&D Cluster awards with equipment Assistance Listing Number: Various – All R&D Cluster awards with equipment Condition The University has a process in place whereby a third-party is engaged to scan all equipment (federal and nonfederal) across their 3 campuses every two years. The third-party does not have a detailed listing when performing their inventory and thus the University must reconcile what was located by the thirdparty to their detailed equipment listing and understand why certain items were not located. If not located, follow-up is performed on an asset-by-asset basis by the University requesting the custodian of the asset confirm the equipment is on-hand. While we University provided evidence of the third-party inventory being performed, including a related manual reconciliation process, we were unable to obtain an aggregated reconciliation between the University equipment records and the third-party inventory results that included all follow-up information as the process is currently manual and disaggregated. Additionally, when scanning through the detailed listing of federal assets, certain equipment was noted to have an inventory date outside of the past 2 years. 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. Cause The University’s process for reviewing third-party equipment inventory results and conducting follow-up is manual, which can cause delays. Additionally, an aggregated reconciliation is not maintained, which can result in an incomplete or inaccurate inventory listing. Effect The lack of a formal reconciliation may result in incomplete equipment inventory records and/or certain assets not being physically inspected within the required 2-year period. Questioned Costs There are no questioned costs associated with this finding. Recommendation We recommend the University update their policies and procedures to require an aggregated reconciliation be maintained between third-party equipment inventory results and University equipment records. Additionally, the University should develop a more automated approach to resolving discrepancies between the third-party equipment inventory results and the federally funded equipment listing, rather than utilizing a manual process, which can cause delays. 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-002 – Equipment Management Cluster: Research and Development Cluster (“R&D Cluster”) Grantor: Various - All R&D Cluster awards with equipment Award Name: Various - All R&D Cluster awards with equipment Award Year: FY2023 Pass-through entities and ID Number: Various - All R&D Cluster awards with equipment Assistance Listing Number: Various – All R&D Cluster awards with equipment Condition The University has a process in place whereby a third-party is engaged to scan all equipment (federal and nonfederal) across their 3 campuses every two years. The third-party does not have a detailed listing when performing their inventory and thus the University must reconcile what was located by the thirdparty to their detailed equipment listing and understand why certain items were not located. If not located, follow-up is performed on an asset-by-asset basis by the University requesting the custodian of the asset confirm the equipment is on-hand. While we University provided evidence of the third-party inventory being performed, including a related manual reconciliation process, we were unable to obtain an aggregated reconciliation between the University equipment records and the third-party inventory results that included all follow-up information as the process is currently manual and disaggregated. Additionally, when scanning through the detailed listing of federal assets, certain equipment was noted to have an inventory date outside of the past 2 years. 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. Cause The University’s process for reviewing third-party equipment inventory results and conducting follow-up is manual, which can cause delays. Additionally, an aggregated reconciliation is not maintained, which can result in an incomplete or inaccurate inventory listing. Effect The lack of a formal reconciliation may result in incomplete equipment inventory records and/or certain assets not being physically inspected within the required 2-year period. Questioned Costs There are no questioned costs associated with this finding. Recommendation We recommend the University update their policies and procedures to require an aggregated reconciliation be maintained between third-party equipment inventory results and University equipment records. Additionally, the University should develop a more automated approach to resolving discrepancies between the third-party equipment inventory results and the federally funded equipment listing, rather than utilizing a manual process, which can cause delays. 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-002 – Equipment Management Cluster: Research and Development Cluster (“R&D Cluster”) Grantor: Various - All R&D Cluster awards with equipment Award Name: Various - All R&D Cluster awards with equipment Award Year: FY2023 Pass-through entities and ID Number: Various - All R&D Cluster awards with equipment Assistance Listing Number: Various – All R&D Cluster awards with equipment Condition The University has a process in place whereby a third-party is engaged to scan all equipment (federal and nonfederal) across their 3 campuses every two years. The third-party does not have a detailed listing when performing their inventory and thus the University must reconcile what was located by the thirdparty to their detailed equipment listing and understand why certain items were not located. If not located, follow-up is performed on an asset-by-asset basis by the University requesting the custodian of the asset confirm the equipment is on-hand. While we University provided evidence of the third-party inventory being performed, including a related manual reconciliation process, we were unable to obtain an aggregated reconciliation between the University equipment records and the third-party inventory results that included all follow-up information as the process is currently manual and disaggregated. Additionally, when scanning through the detailed listing of federal assets, certain equipment was noted to have an inventory date outside of the past 2 years. 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. Cause The University’s process for reviewing third-party equipment inventory results and conducting follow-up is manual, which can cause delays. Additionally, an aggregated reconciliation is not maintained, which can result in an incomplete or inaccurate inventory listing. Effect The lack of a formal reconciliation may result in incomplete equipment inventory records and/or certain assets not being physically inspected within the required 2-year period. Questioned Costs There are no questioned costs associated with this finding. Recommendation We recommend the University update their policies and procedures to require an aggregated reconciliation be maintained between third-party equipment inventory results and University equipment records. Additionally, the University should develop a more automated approach to resolving discrepancies between the third-party equipment inventory results and the federally funded equipment listing, rather than utilizing a manual process, which can cause delays. 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-002 – Equipment Management Cluster: Research and Development Cluster (“R&D Cluster”) Grantor: Various - All R&D Cluster awards with equipment Award Name: Various - All R&D Cluster awards with equipment Award Year: FY2023 Pass-through entities and ID Number: Various - All R&D Cluster awards with equipment Assistance Listing Number: Various – All R&D Cluster awards with equipment Condition The University has a process in place whereby a third-party is engaged to scan all equipment (federal and nonfederal) across their 3 campuses every two years. The third-party does not have a detailed listing when performing their inventory and thus the University must reconcile what was located by the thirdparty to their detailed equipment listing and understand why certain items were not located. If not located, follow-up is performed on an asset-by-asset basis by the University requesting the custodian of the asset confirm the equipment is on-hand. While we University provided evidence of the third-party inventory being performed, including a related manual reconciliation process, we were unable to obtain an aggregated reconciliation between the University equipment records and the third-party inventory results that included all follow-up information as the process is currently manual and disaggregated. Additionally, when scanning through the detailed listing of federal assets, certain equipment was noted to have an inventory date outside of the past 2 years. 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. Cause The University’s process for reviewing third-party equipment inventory results and conducting follow-up is manual, which can cause delays. Additionally, an aggregated reconciliation is not maintained, which can result in an incomplete or inaccurate inventory listing. Effect The lack of a formal reconciliation may result in incomplete equipment inventory records and/or certain assets not being physically inspected within the required 2-year period. Questioned Costs There are no questioned costs associated with this finding. Recommendation We recommend the University update their policies and procedures to require an aggregated reconciliation be maintained between third-party equipment inventory results and University equipment records. Additionally, the University should develop a more automated approach to resolving discrepancies between the third-party equipment inventory results and the federally funded equipment listing, rather than utilizing a manual process, which can cause delays. 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-002 – Equipment Management Cluster: Research and Development Cluster (“R&D Cluster”) Grantor: Various - All R&D Cluster awards with equipment Award Name: Various - All R&D Cluster awards with equipment Award Year: FY2023 Pass-through entities and ID Number: Various - All R&D Cluster awards with equipment Assistance Listing Number: Various – All R&D Cluster awards with equipment Condition The University has a process in place whereby a third-party is engaged to scan all equipment (federal and nonfederal) across their 3 campuses every two years. The third-party does not have a detailed listing when performing their inventory and thus the University must reconcile what was located by the thirdparty to their detailed equipment listing and understand why certain items were not located. If not located, follow-up is performed on an asset-by-asset basis by the University requesting the custodian of the asset confirm the equipment is on-hand. While we University provided evidence of the third-party inventory being performed, including a related manual reconciliation process, we were unable to obtain an aggregated reconciliation between the University equipment records and the third-party inventory results that included all follow-up information as the process is currently manual and disaggregated. Additionally, when scanning through the detailed listing of federal assets, certain equipment was noted to have an inventory date outside of the past 2 years. 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. Cause The University’s process for reviewing third-party equipment inventory results and conducting follow-up is manual, which can cause delays. Additionally, an aggregated reconciliation is not maintained, which can result in an incomplete or inaccurate inventory listing. Effect The lack of a formal reconciliation may result in incomplete equipment inventory records and/or certain assets not being physically inspected within the required 2-year period. Questioned Costs There are no questioned costs associated with this finding. Recommendation We recommend the University update their policies and procedures to require an aggregated reconciliation be maintained between third-party equipment inventory results and University equipment records. Additionally, the University should develop a more automated approach to resolving discrepancies between the third-party equipment inventory results and the federally funded equipment listing, rather than utilizing a manual process, which can cause delays. 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-002 – Equipment Management Cluster: Research and Development Cluster (“R&D Cluster”) Grantor: Various - All R&D Cluster awards with equipment Award Name: Various - All R&D Cluster awards with equipment Award Year: FY2023 Pass-through entities and ID Number: Various - All R&D Cluster awards with equipment Assistance Listing Number: Various – All R&D Cluster awards with equipment Condition The University has a process in place whereby a third-party is engaged to scan all equipment (federal and nonfederal) across their 3 campuses every two years. The third-party does not have a detailed listing when performing their inventory and thus the University must reconcile what was located by the thirdparty to their detailed equipment listing and understand why certain items were not located. If not located, follow-up is performed on an asset-by-asset basis by the University requesting the custodian of the asset confirm the equipment is on-hand. While we University provided evidence of the third-party inventory being performed, including a related manual reconciliation process, we were unable to obtain an aggregated reconciliation between the University equipment records and the third-party inventory results that included all follow-up information as the process is currently manual and disaggregated. Additionally, when scanning through the detailed listing of federal assets, certain equipment was noted to have an inventory date outside of the past 2 years. 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. Cause The University’s process for reviewing third-party equipment inventory results and conducting follow-up is manual, which can cause delays. Additionally, an aggregated reconciliation is not maintained, which can result in an incomplete or inaccurate inventory listing. Effect The lack of a formal reconciliation may result in incomplete equipment inventory records and/or certain assets not being physically inspected within the required 2-year period. Questioned Costs There are no questioned costs associated with this finding. Recommendation We recommend the University update their policies and procedures to require an aggregated reconciliation be maintained between third-party equipment inventory results and University equipment records. Additionally, the University should develop a more automated approach to resolving discrepancies between the third-party equipment inventory results and the federally funded equipment listing, rather than utilizing a manual process, which can cause delays. 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-002 – Equipment Management Cluster: Research and Development Cluster (“R&D Cluster”) Grantor: Various - All R&D Cluster awards with equipment Award Name: Various - All R&D Cluster awards with equipment Award Year: FY2023 Pass-through entities and ID Number: Various - All R&D Cluster awards with equipment Assistance Listing Number: Various – All R&D Cluster awards with equipment Condition The University has a process in place whereby a third-party is engaged to scan all equipment (federal and nonfederal) across their 3 campuses every two years. The third-party does not have a detailed listing when performing their inventory and thus the University must reconcile what was located by the thirdparty to their detailed equipment listing and understand why certain items were not located. If not located, follow-up is performed on an asset-by-asset basis by the University requesting the custodian of the asset confirm the equipment is on-hand. While we University provided evidence of the third-party inventory being performed, including a related manual reconciliation process, we were unable to obtain an aggregated reconciliation between the University equipment records and the third-party inventory results that included all follow-up information as the process is currently manual and disaggregated. Additionally, when scanning through the detailed listing of federal assets, certain equipment was noted to have an inventory date outside of the past 2 years. 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. Cause The University’s process for reviewing third-party equipment inventory results and conducting follow-up is manual, which can cause delays. Additionally, an aggregated reconciliation is not maintained, which can result in an incomplete or inaccurate inventory listing. Effect The lack of a formal reconciliation may result in incomplete equipment inventory records and/or certain assets not being physically inspected within the required 2-year period. Questioned Costs There are no questioned costs associated with this finding. Recommendation We recommend the University update their policies and procedures to require an aggregated reconciliation be maintained between third-party equipment inventory results and University equipment records. Additionally, the University should develop a more automated approach to resolving discrepancies between the third-party equipment inventory results and the federally funded equipment listing, rather than utilizing a manual process, which can cause delays. 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-002 – Equipment Management Cluster: Research and Development Cluster (“R&D Cluster”) Grantor: Various - All R&D Cluster awards with equipment Award Name: Various - All R&D Cluster awards with equipment Award Year: FY2023 Pass-through entities and ID Number: Various - All R&D Cluster awards with equipment Assistance Listing Number: Various – All R&D Cluster awards with equipment Condition The University has a process in place whereby a third-party is engaged to scan all equipment (federal and nonfederal) across their 3 campuses every two years. The third-party does not have a detailed listing when performing their inventory and thus the University must reconcile what was located by the thirdparty to their detailed equipment listing and understand why certain items were not located. If not located, follow-up is performed on an asset-by-asset basis by the University requesting the custodian of the asset confirm the equipment is on-hand. While we University provided evidence of the third-party inventory being performed, including a related manual reconciliation process, we were unable to obtain an aggregated reconciliation between the University equipment records and the third-party inventory results that included all follow-up information as the process is currently manual and disaggregated. Additionally, when scanning through the detailed listing of federal assets, certain equipment was noted to have an inventory date outside of the past 2 years. 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. Cause The University’s process for reviewing third-party equipment inventory results and conducting follow-up is manual, which can cause delays. Additionally, an aggregated reconciliation is not maintained, which can result in an incomplete or inaccurate inventory listing. Effect The lack of a formal reconciliation may result in incomplete equipment inventory records and/or certain assets not being physically inspected within the required 2-year period. Questioned Costs There are no questioned costs associated with this finding. Recommendation We recommend the University update their policies and procedures to require an aggregated reconciliation be maintained between third-party equipment inventory results and University equipment records. Additionally, the University should develop a more automated approach to resolving discrepancies between the third-party equipment inventory results and the federally funded equipment listing, rather than utilizing a manual process, which can cause delays. 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-002 – Equipment Management Cluster: Research and Development Cluster (“R&D Cluster”) Grantor: Various - All R&D Cluster awards with equipment Award Name: Various - All R&D Cluster awards with equipment Award Year: FY2023 Pass-through entities and ID Number: Various - All R&D Cluster awards with equipment Assistance Listing Number: Various – All R&D Cluster awards with equipment Condition The University has a process in place whereby a third-party is engaged to scan all equipment (federal and nonfederal) across their 3 campuses every two years. The third-party does not have a detailed listing when performing their inventory and thus the University must reconcile what was located by the thirdparty to their detailed equipment listing and understand why certain items were not located. If not located, follow-up is performed on an asset-by-asset basis by the University requesting the custodian of the asset confirm the equipment is on-hand. While we University provided evidence of the third-party inventory being performed, including a related manual reconciliation process, we were unable to obtain an aggregated reconciliation between the University equipment records and the third-party inventory results that included all follow-up information as the process is currently manual and disaggregated. Additionally, when scanning through the detailed listing of federal assets, certain equipment was noted to have an inventory date outside of the past 2 years. 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. Cause The University’s process for reviewing third-party equipment inventory results and conducting follow-up is manual, which can cause delays. Additionally, an aggregated reconciliation is not maintained, which can result in an incomplete or inaccurate inventory listing. Effect The lack of a formal reconciliation may result in incomplete equipment inventory records and/or certain assets not being physically inspected within the required 2-year period. Questioned Costs There are no questioned costs associated with this finding. Recommendation We recommend the University update their policies and procedures to require an aggregated reconciliation be maintained between third-party equipment inventory results and University equipment records. Additionally, the University should develop a more automated approach to resolving discrepancies between the third-party equipment inventory results and the federally funded equipment listing, rather than utilizing a manual process, which can cause delays. 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-002 – Equipment Management Cluster: Research and Development Cluster (“R&D Cluster”) Grantor: Various - All R&D Cluster awards with equipment Award Name: Various - All R&D Cluster awards with equipment Award Year: FY2023 Pass-through entities and ID Number: Various - All R&D Cluster awards with equipment Assistance Listing Number: Various – All R&D Cluster awards with equipment Condition The University has a process in place whereby a third-party is engaged to scan all equipment (federal and nonfederal) across their 3 campuses every two years. The third-party does not have a detailed listing when performing their inventory and thus the University must reconcile what was located by the thirdparty to their detailed equipment listing and understand why certain items were not located. If not located, follow-up is performed on an asset-by-asset basis by the University requesting the custodian of the asset confirm the equipment is on-hand. While we University provided evidence of the third-party inventory being performed, including a related manual reconciliation process, we were unable to obtain an aggregated reconciliation between the University equipment records and the third-party inventory results that included all follow-up information as the process is currently manual and disaggregated. Additionally, when scanning through the detailed listing of federal assets, certain equipment was noted to have an inventory date outside of the past 2 years. 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. Cause The University’s process for reviewing third-party equipment inventory results and conducting follow-up is manual, which can cause delays. Additionally, an aggregated reconciliation is not maintained, which can result in an incomplete or inaccurate inventory listing. Effect The lack of a formal reconciliation may result in incomplete equipment inventory records and/or certain assets not being physically inspected within the required 2-year period. Questioned Costs There are no questioned costs associated with this finding. Recommendation We recommend the University update their policies and procedures to require an aggregated reconciliation be maintained between third-party equipment inventory results and University equipment records. Additionally, the University should develop a more automated approach to resolving discrepancies between the third-party equipment inventory results and the federally funded equipment listing, rather than utilizing a manual process, which can cause delays. 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-002 – Equipment Management Cluster: Research and Development Cluster (“R&D Cluster”) Grantor: Various - All R&D Cluster awards with equipment Award Name: Various - All R&D Cluster awards with equipment Award Year: FY2023 Pass-through entities and ID Number: Various - All R&D Cluster awards with equipment Assistance Listing Number: Various – All R&D Cluster awards with equipment Condition The University has a process in place whereby a third-party is engaged to scan all equipment (federal and nonfederal) across their 3 campuses every two years. The third-party does not have a detailed listing when performing their inventory and thus the University must reconcile what was located by the thirdparty to their detailed equipment listing and understand why certain items were not located. If not located, follow-up is performed on an asset-by-asset basis by the University requesting the custodian of the asset confirm the equipment is on-hand. While we University provided evidence of the third-party inventory being performed, including a related manual reconciliation process, we were unable to obtain an aggregated reconciliation between the University equipment records and the third-party inventory results that included all follow-up information as the process is currently manual and disaggregated. Additionally, when scanning through the detailed listing of federal assets, certain equipment was noted to have an inventory date outside of the past 2 years. 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. Cause The University’s process for reviewing third-party equipment inventory results and conducting follow-up is manual, which can cause delays. Additionally, an aggregated reconciliation is not maintained, which can result in an incomplete or inaccurate inventory listing. Effect The lack of a formal reconciliation may result in incomplete equipment inventory records and/or certain assets not being physically inspected within the required 2-year period. Questioned Costs There are no questioned costs associated with this finding. Recommendation We recommend the University update their policies and procedures to require an aggregated reconciliation be maintained between third-party equipment inventory results and University equipment records. Additionally, the University should develop a more automated approach to resolving discrepancies between the third-party equipment inventory results and the federally funded equipment listing, rather than utilizing a manual process, which can cause delays. 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-002 – Equipment Management Cluster: Research and Development Cluster (“R&D Cluster”) Grantor: Various - All R&D Cluster awards with equipment Award Name: Various - All R&D Cluster awards with equipment Award Year: FY2023 Pass-through entities and ID Number: Various - All R&D Cluster awards with equipment Assistance Listing Number: Various – All R&D Cluster awards with equipment Condition The University has a process in place whereby a third-party is engaged to scan all equipment (federal and nonfederal) across their 3 campuses every two years. The third-party does not have a detailed listing when performing their inventory and thus the University must reconcile what was located by the thirdparty to their detailed equipment listing and understand why certain items were not located. If not located, follow-up is performed on an asset-by-asset basis by the University requesting the custodian of the asset confirm the equipment is on-hand. While we University provided evidence of the third-party inventory being performed, including a related manual reconciliation process, we were unable to obtain an aggregated reconciliation between the University equipment records and the third-party inventory results that included all follow-up information as the process is currently manual and disaggregated. Additionally, when scanning through the detailed listing of federal assets, certain equipment was noted to have an inventory date outside of the past 2 years. 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. Cause The University’s process for reviewing third-party equipment inventory results and conducting follow-up is manual, which can cause delays. Additionally, an aggregated reconciliation is not maintained, which can result in an incomplete or inaccurate inventory listing. Effect The lack of a formal reconciliation may result in incomplete equipment inventory records and/or certain assets not being physically inspected within the required 2-year period. Questioned Costs There are no questioned costs associated with this finding. Recommendation We recommend the University update their policies and procedures to require an aggregated reconciliation be maintained between third-party equipment inventory results and University equipment records. Additionally, the University should develop a more automated approach to resolving discrepancies between the third-party equipment inventory results and the federally funded equipment listing, rather than utilizing a manual process, which can cause delays. 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-002 – Equipment Management Cluster: Research and Development Cluster (“R&D Cluster”) Grantor: Various - All R&D Cluster awards with equipment Award Name: Various - All R&D Cluster awards with equipment Award Year: FY2023 Pass-through entities and ID Number: Various - All R&D Cluster awards with equipment Assistance Listing Number: Various – All R&D Cluster awards with equipment Condition The University has a process in place whereby a third-party is engaged to scan all equipment (federal and nonfederal) across their 3 campuses every two years. The third-party does not have a detailed listing when performing their inventory and thus the University must reconcile what was located by the thirdparty to their detailed equipment listing and understand why certain items were not located. If not located, follow-up is performed on an asset-by-asset basis by the University requesting the custodian of the asset confirm the equipment is on-hand. While we University provided evidence of the third-party inventory being performed, including a related manual reconciliation process, we were unable to obtain an aggregated reconciliation between the University equipment records and the third-party inventory results that included all follow-up information as the process is currently manual and disaggregated. Additionally, when scanning through the detailed listing of federal assets, certain equipment was noted to have an inventory date outside of the past 2 years. 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. Cause The University’s process for reviewing third-party equipment inventory results and conducting follow-up is manual, which can cause delays. Additionally, an aggregated reconciliation is not maintained, which can result in an incomplete or inaccurate inventory listing. Effect The lack of a formal reconciliation may result in incomplete equipment inventory records and/or certain assets not being physically inspected within the required 2-year period. Questioned Costs There are no questioned costs associated with this finding. Recommendation We recommend the University update their policies and procedures to require an aggregated reconciliation be maintained between third-party equipment inventory results and University equipment records. Additionally, the University should develop a more automated approach to resolving discrepancies between the third-party equipment inventory results and the federally funded equipment listing, rather than utilizing a manual process, which can cause delays. 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-002 – Equipment Management Cluster: Research and Development Cluster (“R&D Cluster”) Grantor: Various - All R&D Cluster awards with equipment Award Name: Various - All R&D Cluster awards with equipment Award Year: FY2023 Pass-through entities and ID Number: Various - All R&D Cluster awards with equipment Assistance Listing Number: Various – All R&D Cluster awards with equipment Condition The University has a process in place whereby a third-party is engaged to scan all equipment (federal and nonfederal) across their 3 campuses every two years. The third-party does not have a detailed listing when performing their inventory and thus the University must reconcile what was located by the thirdparty to their detailed equipment listing and understand why certain items were not located. If not located, follow-up is performed on an asset-by-asset basis by the University requesting the custodian of the asset confirm the equipment is on-hand. While we University provided evidence of the third-party inventory being performed, including a related manual reconciliation process, we were unable to obtain an aggregated reconciliation between the University equipment records and the third-party inventory results that included all follow-up information as the process is currently manual and disaggregated. Additionally, when scanning through the detailed listing of federal assets, certain equipment was noted to have an inventory date outside of the past 2 years. 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. Cause The University’s process for reviewing third-party equipment inventory results and conducting follow-up is manual, which can cause delays. Additionally, an aggregated reconciliation is not maintained, which can result in an incomplete or inaccurate inventory listing. Effect The lack of a formal reconciliation may result in incomplete equipment inventory records and/or certain assets not being physically inspected within the required 2-year period. Questioned Costs There are no questioned costs associated with this finding. Recommendation We recommend the University update their policies and procedures to require an aggregated reconciliation be maintained between third-party equipment inventory results and University equipment records. Additionally, the University should develop a more automated approach to resolving discrepancies between the third-party equipment inventory results and the federally funded equipment listing, rather than utilizing a manual process, which can cause delays. 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-002 – Equipment Management Cluster: Research and Development Cluster (“R&D Cluster”) Grantor: Various - All R&D Cluster awards with equipment Award Name: Various - All R&D Cluster awards with equipment Award Year: FY2023 Pass-through entities and ID Number: Various - All R&D Cluster awards with equipment Assistance Listing Number: Various – All R&D Cluster awards with equipment Condition The University has a process in place whereby a third-party is engaged to scan all equipment (federal and nonfederal) across their 3 campuses every two years. The third-party does not have a detailed listing when performing their inventory and thus the University must reconcile what was located by the thirdparty to their detailed equipment listing and understand why certain items were not located. If not located, follow-up is performed on an asset-by-asset basis by the University requesting the custodian of the asset confirm the equipment is on-hand. While we University provided evidence of the third-party inventory being performed, including a related manual reconciliation process, we were unable to obtain an aggregated reconciliation between the University equipment records and the third-party inventory results that included all follow-up information as the process is currently manual and disaggregated. Additionally, when scanning through the detailed listing of federal assets, certain equipment was noted to have an inventory date outside of the past 2 years. 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. Cause The University’s process for reviewing third-party equipment inventory results and conducting follow-up is manual, which can cause delays. Additionally, an aggregated reconciliation is not maintained, which can result in an incomplete or inaccurate inventory listing. Effect The lack of a formal reconciliation may result in incomplete equipment inventory records and/or certain assets not being physically inspected within the required 2-year period. Questioned Costs There are no questioned costs associated with this finding. Recommendation We recommend the University update their policies and procedures to require an aggregated reconciliation be maintained between third-party equipment inventory results and University equipment records. Additionally, the University should develop a more automated approach to resolving discrepancies between the third-party equipment inventory results and the federally funded equipment listing, rather than utilizing a manual process, which can cause delays. 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-002 – Equipment Management Cluster: Research and Development Cluster (“R&D Cluster”) Grantor: Various - All R&D Cluster awards with equipment Award Name: Various - All R&D Cluster awards with equipment Award Year: FY2023 Pass-through entities and ID Number: Various - All R&D Cluster awards with equipment Assistance Listing Number: Various – All R&D Cluster awards with equipment Condition The University has a process in place whereby a third-party is engaged to scan all equipment (federal and nonfederal) across their 3 campuses every two years. The third-party does not have a detailed listing when performing their inventory and thus the University must reconcile what was located by the thirdparty to their detailed equipment listing and understand why certain items were not located. If not located, follow-up is performed on an asset-by-asset basis by the University requesting the custodian of the asset confirm the equipment is on-hand. While we University provided evidence of the third-party inventory being performed, including a related manual reconciliation process, we were unable to obtain an aggregated reconciliation between the University equipment records and the third-party inventory results that included all follow-up information as the process is currently manual and disaggregated. Additionally, when scanning through the detailed listing of federal assets, certain equipment was noted to have an inventory date outside of the past 2 years. 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. Cause The University’s process for reviewing third-party equipment inventory results and conducting follow-up is manual, which can cause delays. Additionally, an aggregated reconciliation is not maintained, which can result in an incomplete or inaccurate inventory listing. Effect The lack of a formal reconciliation may result in incomplete equipment inventory records and/or certain assets not being physically inspected within the required 2-year period. Questioned Costs There are no questioned costs associated with this finding. Recommendation We recommend the University update their policies and procedures to require an aggregated reconciliation be maintained between third-party equipment inventory results and University equipment records. Additionally, the University should develop a more automated approach to resolving discrepancies between the third-party equipment inventory results and the federally funded equipment listing, rather than utilizing a manual process, which can cause delays. 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-002 – Equipment Management Cluster: Research and Development Cluster (“R&D Cluster”) Grantor: Various - All R&D Cluster awards with equipment Award Name: Various - All R&D Cluster awards with equipment Award Year: FY2023 Pass-through entities and ID Number: Various - All R&D Cluster awards with equipment Assistance Listing Number: Various – All R&D Cluster awards with equipment Condition The University has a process in place whereby a third-party is engaged to scan all equipment (federal and nonfederal) across their 3 campuses every two years. The third-party does not have a detailed listing when performing their inventory and thus the University must reconcile what was located by the thirdparty to their detailed equipment listing and understand why certain items were not located. If not located, follow-up is performed on an asset-by-asset basis by the University requesting the custodian of the asset confirm the equipment is on-hand. While we University provided evidence of the third-party inventory being performed, including a related manual reconciliation process, we were unable to obtain an aggregated reconciliation between the University equipment records and the third-party inventory results that included all follow-up information as the process is currently manual and disaggregated. Additionally, when scanning through the detailed listing of federal assets, certain equipment was noted to have an inventory date outside of the past 2 years. 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. Cause The University’s process for reviewing third-party equipment inventory results and conducting follow-up is manual, which can cause delays. Additionally, an aggregated reconciliation is not maintained, which can result in an incomplete or inaccurate inventory listing. Effect The lack of a formal reconciliation may result in incomplete equipment inventory records and/or certain assets not being physically inspected within the required 2-year period. Questioned Costs There are no questioned costs associated with this finding. Recommendation We recommend the University update their policies and procedures to require an aggregated reconciliation be maintained between third-party equipment inventory results and University equipment records. Additionally, the University should develop a more automated approach to resolving discrepancies between the third-party equipment inventory results and the federally funded equipment listing, rather than utilizing a manual process, which can cause delays. 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-002 – Equipment Management Cluster: Research and Development Cluster (“R&D Cluster”) Grantor: Various - All R&D Cluster awards with equipment Award Name: Various - All R&D Cluster awards with equipment Award Year: FY2023 Pass-through entities and ID Number: Various - All R&D Cluster awards with equipment Assistance Listing Number: Various – All R&D Cluster awards with equipment Condition The University has a process in place whereby a third-party is engaged to scan all equipment (federal and nonfederal) across their 3 campuses every two years. The third-party does not have a detailed listing when performing their inventory and thus the University must reconcile what was located by the thirdparty to their detailed equipment listing and understand why certain items were not located. If not located, follow-up is performed on an asset-by-asset basis by the University requesting the custodian of the asset confirm the equipment is on-hand. While we University provided evidence of the third-party inventory being performed, including a related manual reconciliation process, we were unable to obtain an aggregated reconciliation between the University equipment records and the third-party inventory results that included all follow-up information as the process is currently manual and disaggregated. Additionally, when scanning through the detailed listing of federal assets, certain equipment was noted to have an inventory date outside of the past 2 years. 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. Cause The University’s process for reviewing third-party equipment inventory results and conducting follow-up is manual, which can cause delays. Additionally, an aggregated reconciliation is not maintained, which can result in an incomplete or inaccurate inventory listing. Effect The lack of a formal reconciliation may result in incomplete equipment inventory records and/or certain assets not being physically inspected within the required 2-year period. Questioned Costs There are no questioned costs associated with this finding. Recommendation We recommend the University update their policies and procedures to require an aggregated reconciliation be maintained between third-party equipment inventory results and University equipment records. Additionally, the University should develop a more automated approach to resolving discrepancies between the third-party equipment inventory results and the federally funded equipment listing, rather than utilizing a manual process, which can cause delays. 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-002 – Equipment Management Cluster: Research and Development Cluster (“R&D Cluster”) Grantor: Various - All R&D Cluster awards with equipment Award Name: Various - All R&D Cluster awards with equipment Award Year: FY2023 Pass-through entities and ID Number: Various - All R&D Cluster awards with equipment Assistance Listing Number: Various – All R&D Cluster awards with equipment Condition The University has a process in place whereby a third-party is engaged to scan all equipment (federal and nonfederal) across their 3 campuses every two years. The third-party does not have a detailed listing when performing their inventory and thus the University must reconcile what was located by the thirdparty to their detailed equipment listing and understand why certain items were not located. If not located, follow-up is performed on an asset-by-asset basis by the University requesting the custodian of the asset confirm the equipment is on-hand. While we University provided evidence of the third-party inventory being performed, including a related manual reconciliation process, we were unable to obtain an aggregated reconciliation between the University equipment records and the third-party inventory results that included all follow-up information as the process is currently manual and disaggregated. Additionally, when scanning through the detailed listing of federal assets, certain equipment was noted to have an inventory date outside of the past 2 years. 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. Cause The University’s process for reviewing third-party equipment inventory results and conducting follow-up is manual, which can cause delays. Additionally, an aggregated reconciliation is not maintained, which can result in an incomplete or inaccurate inventory listing. Effect The lack of a formal reconciliation may result in incomplete equipment inventory records and/or certain assets not being physically inspected within the required 2-year period. Questioned Costs There are no questioned costs associated with this finding. Recommendation We recommend the University update their policies and procedures to require an aggregated reconciliation be maintained between third-party equipment inventory results and University equipment records. Additionally, the University should develop a more automated approach to resolving discrepancies between the third-party equipment inventory results and the federally funded equipment listing, rather than utilizing a manual process, which can cause delays. 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-002 – Equipment Management Cluster: Research and Development Cluster (“R&D Cluster”) Grantor: Various - All R&D Cluster awards with equipment Award Name: Various - All R&D Cluster awards with equipment Award Year: FY2023 Pass-through entities and ID Number: Various - All R&D Cluster awards with equipment Assistance Listing Number: Various – All R&D Cluster awards with equipment Condition The University has a process in place whereby a third-party is engaged to scan all equipment (federal and nonfederal) across their 3 campuses every two years. The third-party does not have a detailed listing when performing their inventory and thus the University must reconcile what was located by the thirdparty to their detailed equipment listing and understand why certain items were not located. If not located, follow-up is performed on an asset-by-asset basis by the University requesting the custodian of the asset confirm the equipment is on-hand. While we University provided evidence of the third-party inventory being performed, including a related manual reconciliation process, we were unable to obtain an aggregated reconciliation between the University equipment records and the third-party inventory results that included all follow-up information as the process is currently manual and disaggregated. Additionally, when scanning through the detailed listing of federal assets, certain equipment was noted to have an inventory date outside of the past 2 years. 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. Cause The University’s process for reviewing third-party equipment inventory results and conducting follow-up is manual, which can cause delays. Additionally, an aggregated reconciliation is not maintained, which can result in an incomplete or inaccurate inventory listing. Effect The lack of a formal reconciliation may result in incomplete equipment inventory records and/or certain assets not being physically inspected within the required 2-year period. Questioned Costs There are no questioned costs associated with this finding. Recommendation We recommend the University update their policies and procedures to require an aggregated reconciliation be maintained between third-party equipment inventory results and University equipment records. Additionally, the University should develop a more automated approach to resolving discrepancies between the third-party equipment inventory results and the federally funded equipment listing, rather than utilizing a manual process, which can cause delays. 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-002 – Equipment Management Cluster: Research and Development Cluster (“R&D Cluster”) Grantor: Various - All R&D Cluster awards with equipment Award Name: Various - All R&D Cluster awards with equipment Award Year: FY2023 Pass-through entities and ID Number: Various - All R&D Cluster awards with equipment Assistance Listing Number: Various – All R&D Cluster awards with equipment Condition The University has a process in place whereby a third-party is engaged to scan all equipment (federal and nonfederal) across their 3 campuses every two years. The third-party does not have a detailed listing when performing their inventory and thus the University must reconcile what was located by the thirdparty to their detailed equipment listing and understand why certain items were not located. If not located, follow-up is performed on an asset-by-asset basis by the University requesting the custodian of the asset confirm the equipment is on-hand. While we University provided evidence of the third-party inventory being performed, including a related manual reconciliation process, we were unable to obtain an aggregated reconciliation between the University equipment records and the third-party inventory results that included all follow-up information as the process is currently manual and disaggregated. Additionally, when scanning through the detailed listing of federal assets, certain equipment was noted to have an inventory date outside of the past 2 years. 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. Cause The University’s process for reviewing third-party equipment inventory results and conducting follow-up is manual, which can cause delays. Additionally, an aggregated reconciliation is not maintained, which can result in an incomplete or inaccurate inventory listing. Effect The lack of a formal reconciliation may result in incomplete equipment inventory records and/or certain assets not being physically inspected within the required 2-year period. Questioned Costs There are no questioned costs associated with this finding. Recommendation We recommend the University update their policies and procedures to require an aggregated reconciliation be maintained between third-party equipment inventory results and University equipment records. Additionally, the University should develop a more automated approach to resolving discrepancies between the third-party equipment inventory results and the federally funded equipment listing, rather than utilizing a manual process, which can cause delays. 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-002 – Equipment Management Cluster: Research and Development Cluster (“R&D Cluster”) Grantor: Various - All R&D Cluster awards with equipment Award Name: Various - All R&D Cluster awards with equipment Award Year: FY2023 Pass-through entities and ID Number: Various - All R&D Cluster awards with equipment Assistance Listing Number: Various – All R&D Cluster awards with equipment Condition The University has a process in place whereby a third-party is engaged to scan all equipment (federal and nonfederal) across their 3 campuses every two years. The third-party does not have a detailed listing when performing their inventory and thus the University must reconcile what was located by the thirdparty to their detailed equipment listing and understand why certain items were not located. If not located, follow-up is performed on an asset-by-asset basis by the University requesting the custodian of the asset confirm the equipment is on-hand. While we University provided evidence of the third-party inventory being performed, including a related manual reconciliation process, we were unable to obtain an aggregated reconciliation between the University equipment records and the third-party inventory results that included all follow-up information as the process is currently manual and disaggregated. Additionally, when scanning through the detailed listing of federal assets, certain equipment was noted to have an inventory date outside of the past 2 years. 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. Cause The University’s process for reviewing third-party equipment inventory results and conducting follow-up is manual, which can cause delays. Additionally, an aggregated reconciliation is not maintained, which can result in an incomplete or inaccurate inventory listing. Effect The lack of a formal reconciliation may result in incomplete equipment inventory records and/or certain assets not being physically inspected within the required 2-year period. Questioned Costs There are no questioned costs associated with this finding. Recommendation We recommend the University update their policies and procedures to require an aggregated reconciliation be maintained between third-party equipment inventory results and University equipment records. Additionally, the University should develop a more automated approach to resolving discrepancies between the third-party equipment inventory results and the federally funded equipment listing, rather than utilizing a manual process, which can cause delays. 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-002 – Equipment Management Cluster: Research and Development Cluster (“R&D Cluster”) Grantor: Various - All R&D Cluster awards with equipment Award Name: Various - All R&D Cluster awards with equipment Award Year: FY2023 Pass-through entities and ID Number: Various - All R&D Cluster awards with equipment Assistance Listing Number: Various – All R&D Cluster awards with equipment Condition The University has a process in place whereby a third-party is engaged to scan all equipment (federal and nonfederal) across their 3 campuses every two years. The third-party does not have a detailed listing when performing their inventory and thus the University must reconcile what was located by the thirdparty to their detailed equipment listing and understand why certain items were not located. If not located, follow-up is performed on an asset-by-asset basis by the University requesting the custodian of the asset confirm the equipment is on-hand. While we University provided evidence of the third-party inventory being performed, including a related manual reconciliation process, we were unable to obtain an aggregated reconciliation between the University equipment records and the third-party inventory results that included all follow-up information as the process is currently manual and disaggregated. Additionally, when scanning through the detailed listing of federal assets, certain equipment was noted to have an inventory date outside of the past 2 years. 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. Cause The University’s process for reviewing third-party equipment inventory results and conducting follow-up is manual, which can cause delays. Additionally, an aggregated reconciliation is not maintained, which can result in an incomplete or inaccurate inventory listing. Effect The lack of a formal reconciliation may result in incomplete equipment inventory records and/or certain assets not being physically inspected within the required 2-year period. Questioned Costs There are no questioned costs associated with this finding. Recommendation We recommend the University update their policies and procedures to require an aggregated reconciliation be maintained between third-party equipment inventory results and University equipment records. Additionally, the University should develop a more automated approach to resolving discrepancies between the third-party equipment inventory results and the federally funded equipment listing, rather than utilizing a manual process, which can cause delays. 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-002 – Equipment Management Cluster: Research and Development Cluster (“R&D Cluster”) Grantor: Various - All R&D Cluster awards with equipment Award Name: Various - All R&D Cluster awards with equipment Award Year: FY2023 Pass-through entities and ID Number: Various - All R&D Cluster awards with equipment Assistance Listing Number: Various – All R&D Cluster awards with equipment Condition The University has a process in place whereby a third-party is engaged to scan all equipment (federal and nonfederal) across their 3 campuses every two years. The third-party does not have a detailed listing when performing their inventory and thus the University must reconcile what was located by the thirdparty to their detailed equipment listing and understand why certain items were not located. If not located, follow-up is performed on an asset-by-asset basis by the University requesting the custodian of the asset confirm the equipment is on-hand. While we University provided evidence of the third-party inventory being performed, including a related manual reconciliation process, we were unable to obtain an aggregated reconciliation between the University equipment records and the third-party inventory results that included all follow-up information as the process is currently manual and disaggregated. Additionally, when scanning through the detailed listing of federal assets, certain equipment was noted to have an inventory date outside of the past 2 years. 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. Cause The University’s process for reviewing third-party equipment inventory results and conducting follow-up is manual, which can cause delays. Additionally, an aggregated reconciliation is not maintained, which can result in an incomplete or inaccurate inventory listing. Effect The lack of a formal reconciliation may result in incomplete equipment inventory records and/or certain assets not being physically inspected within the required 2-year period. Questioned Costs There are no questioned costs associated with this finding. Recommendation We recommend the University update their policies and procedures to require an aggregated reconciliation be maintained between third-party equipment inventory results and University equipment records. Additionally, the University should develop a more automated approach to resolving discrepancies between the third-party equipment inventory results and the federally funded equipment listing, rather than utilizing a manual process, which can cause delays. 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-002 – Equipment Management Cluster: Research and Development Cluster (“R&D Cluster”) Grantor: Various - All R&D Cluster awards with equipment Award Name: Various - All R&D Cluster awards with equipment Award Year: FY2023 Pass-through entities and ID Number: Various - All R&D Cluster awards with equipment Assistance Listing Number: Various – All R&D Cluster awards with equipment Condition The University has a process in place whereby a third-party is engaged to scan all equipment (federal and nonfederal) across their 3 campuses every two years. The third-party does not have a detailed listing when performing their inventory and thus the University must reconcile what was located by the thirdparty to their detailed equipment listing and understand why certain items were not located. If not located, follow-up is performed on an asset-by-asset basis by the University requesting the custodian of the asset confirm the equipment is on-hand. While we University provided evidence of the third-party inventory being performed, including a related manual reconciliation process, we were unable to obtain an aggregated reconciliation between the University equipment records and the third-party inventory results that included all follow-up information as the process is currently manual and disaggregated. Additionally, when scanning through the detailed listing of federal assets, certain equipment was noted to have an inventory date outside of the past 2 years. 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. Cause The University’s process for reviewing third-party equipment inventory results and conducting follow-up is manual, which can cause delays. Additionally, an aggregated reconciliation is not maintained, which can result in an incomplete or inaccurate inventory listing. Effect The lack of a formal reconciliation may result in incomplete equipment inventory records and/or certain assets not being physically inspected within the required 2-year period. Questioned Costs There are no questioned costs associated with this finding. Recommendation We recommend the University update their policies and procedures to require an aggregated reconciliation be maintained between third-party equipment inventory results and University equipment records. Additionally, the University should develop a more automated approach to resolving discrepancies between the third-party equipment inventory results and the federally funded equipment listing, rather than utilizing a manual process, which can cause delays. 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-002 – Equipment Management Cluster: Research and Development Cluster (“R&D Cluster”) Grantor: Various - All R&D Cluster awards with equipment Award Name: Various - All R&D Cluster awards with equipment Award Year: FY2023 Pass-through entities and ID Number: Various - All R&D Cluster awards with equipment Assistance Listing Number: Various – All R&D Cluster awards with equipment Condition The University has a process in place whereby a third-party is engaged to scan all equipment (federal and nonfederal) across their 3 campuses every two years. The third-party does not have a detailed listing when performing their inventory and thus the University must reconcile what was located by the thirdparty to their detailed equipment listing and understand why certain items were not located. If not located, follow-up is performed on an asset-by-asset basis by the University requesting the custodian of the asset confirm the equipment is on-hand. While we University provided evidence of the third-party inventory being performed, including a related manual reconciliation process, we were unable to obtain an aggregated reconciliation between the University equipment records and the third-party inventory results that included all follow-up information as the process is currently manual and disaggregated. Additionally, when scanning through the detailed listing of federal assets, certain equipment was noted to have an inventory date outside of the past 2 years. 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. Cause The University’s process for reviewing third-party equipment inventory results and conducting follow-up is manual, which can cause delays. Additionally, an aggregated reconciliation is not maintained, which can result in an incomplete or inaccurate inventory listing. Effect The lack of a formal reconciliation may result in incomplete equipment inventory records and/or certain assets not being physically inspected within the required 2-year period. Questioned Costs There are no questioned costs associated with this finding. Recommendation We recommend the University update their policies and procedures to require an aggregated reconciliation be maintained between third-party equipment inventory results and University equipment records. Additionally, the University should develop a more automated approach to resolving discrepancies between the third-party equipment inventory results and the federally funded equipment listing, rather than utilizing a manual process, which can cause delays. 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-002 – Equipment Management Cluster: Research and Development Cluster (“R&D Cluster”) Grantor: Various - All R&D Cluster awards with equipment Award Name: Various - All R&D Cluster awards with equipment Award Year: FY2023 Pass-through entities and ID Number: Various - All R&D Cluster awards with equipment Assistance Listing Number: Various – All R&D Cluster awards with equipment Condition The University has a process in place whereby a third-party is engaged to scan all equipment (federal and nonfederal) across their 3 campuses every two years. The third-party does not have a detailed listing when performing their inventory and thus the University must reconcile what was located by the thirdparty to their detailed equipment listing and understand why certain items were not located. If not located, follow-up is performed on an asset-by-asset basis by the University requesting the custodian of the asset confirm the equipment is on-hand. While we University provided evidence of the third-party inventory being performed, including a related manual reconciliation process, we were unable to obtain an aggregated reconciliation between the University equipment records and the third-party inventory results that included all follow-up information as the process is currently manual and disaggregated. Additionally, when scanning through the detailed listing of federal assets, certain equipment was noted to have an inventory date outside of the past 2 years. 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. Cause The University’s process for reviewing third-party equipment inventory results and conducting follow-up is manual, which can cause delays. Additionally, an aggregated reconciliation is not maintained, which can result in an incomplete or inaccurate inventory listing. Effect The lack of a formal reconciliation may result in incomplete equipment inventory records and/or certain assets not being physically inspected within the required 2-year period. Questioned Costs There are no questioned costs associated with this finding. Recommendation We recommend the University update their policies and procedures to require an aggregated reconciliation be maintained between third-party equipment inventory results and University equipment records. Additionally, the University should develop a more automated approach to resolving discrepancies between the third-party equipment inventory results and the federally funded equipment listing, rather than utilizing a manual process, which can cause delays. 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-002 – Equipment Management Cluster: Research and Development Cluster (“R&D Cluster”) Grantor: Various - All R&D Cluster awards with equipment Award Name: Various - All R&D Cluster awards with equipment Award Year: FY2023 Pass-through entities and ID Number: Various - All R&D Cluster awards with equipment Assistance Listing Number: Various – All R&D Cluster awards with equipment Condition The University has a process in place whereby a third-party is engaged to scan all equipment (federal and nonfederal) across their 3 campuses every two years. The third-party does not have a detailed listing when performing their inventory and thus the University must reconcile what was located by the thirdparty to their detailed equipment listing and understand why certain items were not located. If not located, follow-up is performed on an asset-by-asset basis by the University requesting the custodian of the asset confirm the equipment is on-hand. While we University provided evidence of the third-party inventory being performed, including a related manual reconciliation process, we were unable to obtain an aggregated reconciliation between the University equipment records and the third-party inventory results that included all follow-up information as the process is currently manual and disaggregated. Additionally, when scanning through the detailed listing of federal assets, certain equipment was noted to have an inventory date outside of the past 2 years. 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. Cause The University’s process for reviewing third-party equipment inventory results and conducting follow-up is manual, which can cause delays. Additionally, an aggregated reconciliation is not maintained, which can result in an incomplete or inaccurate inventory listing. Effect The lack of a formal reconciliation may result in incomplete equipment inventory records and/or certain assets not being physically inspected within the required 2-year period. Questioned Costs There are no questioned costs associated with this finding. Recommendation We recommend the University update their policies and procedures to require an aggregated reconciliation be maintained between third-party equipment inventory results and University equipment records. Additionally, the University should develop a more automated approach to resolving discrepancies between the third-party equipment inventory results and the federally funded equipment listing, rather than utilizing a manual process, which can cause delays. 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-002 – Equipment Management Cluster: Research and Development Cluster (“R&D Cluster”) Grantor: Various - All R&D Cluster awards with equipment Award Name: Various - All R&D Cluster awards with equipment Award Year: FY2023 Pass-through entities and ID Number: Various - All R&D Cluster awards with equipment Assistance Listing Number: Various – All R&D Cluster awards with equipment Condition The University has a process in place whereby a third-party is engaged to scan all equipment (federal and nonfederal) across their 3 campuses every two years. The third-party does not have a detailed listing when performing their inventory and thus the University must reconcile what was located by the thirdparty to their detailed equipment listing and understand why certain items were not located. If not located, follow-up is performed on an asset-by-asset basis by the University requesting the custodian of the asset confirm the equipment is on-hand. While we University provided evidence of the third-party inventory being performed, including a related manual reconciliation process, we were unable to obtain an aggregated reconciliation between the University equipment records and the third-party inventory results that included all follow-up information as the process is currently manual and disaggregated. Additionally, when scanning through the detailed listing of federal assets, certain equipment was noted to have an inventory date outside of the past 2 years. 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. Cause The University’s process for reviewing third-party equipment inventory results and conducting follow-up is manual, which can cause delays. Additionally, an aggregated reconciliation is not maintained, which can result in an incomplete or inaccurate inventory listing. Effect The lack of a formal reconciliation may result in incomplete equipment inventory records and/or certain assets not being physically inspected within the required 2-year period. Questioned Costs There are no questioned costs associated with this finding. Recommendation We recommend the University update their policies and procedures to require an aggregated reconciliation be maintained between third-party equipment inventory results and University equipment records. Additionally, the University should develop a more automated approach to resolving discrepancies between the third-party equipment inventory results and the federally funded equipment listing, rather than utilizing a manual process, which can cause delays. 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-002 – Equipment Management Cluster: Research and Development Cluster (“R&D Cluster”) Grantor: Various - All R&D Cluster awards with equipment Award Name: Various - All R&D Cluster awards with equipment Award Year: FY2023 Pass-through entities and ID Number: Various - All R&D Cluster awards with equipment Assistance Listing Number: Various – All R&D Cluster awards with equipment Condition The University has a process in place whereby a third-party is engaged to scan all equipment (federal and nonfederal) across their 3 campuses every two years. The third-party does not have a detailed listing when performing their inventory and thus the University must reconcile what was located by the thirdparty to their detailed equipment listing and understand why certain items were not located. If not located, follow-up is performed on an asset-by-asset basis by the University requesting the custodian of the asset confirm the equipment is on-hand. While we University provided evidence of the third-party inventory being performed, including a related manual reconciliation process, we were unable to obtain an aggregated reconciliation between the University equipment records and the third-party inventory results that included all follow-up information as the process is currently manual and disaggregated. Additionally, when scanning through the detailed listing of federal assets, certain equipment was noted to have an inventory date outside of the past 2 years. 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. Cause The University’s process for reviewing third-party equipment inventory results and conducting follow-up is manual, which can cause delays. Additionally, an aggregated reconciliation is not maintained, which can result in an incomplete or inaccurate inventory listing. Effect The lack of a formal reconciliation may result in incomplete equipment inventory records and/or certain assets not being physically inspected within the required 2-year period. Questioned Costs There are no questioned costs associated with this finding. Recommendation We recommend the University update their policies and procedures to require an aggregated reconciliation be maintained between third-party equipment inventory results and University equipment records. Additionally, the University should develop a more automated approach to resolving discrepancies between the third-party equipment inventory results and the federally funded equipment listing, rather than utilizing a manual process, which can cause delays. 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-002 – Equipment Management Cluster: Research and Development Cluster (“R&D Cluster”) Grantor: Various - All R&D Cluster awards with equipment Award Name: Various - All R&D Cluster awards with equipment Award Year: FY2023 Pass-through entities and ID Number: Various - All R&D Cluster awards with equipment Assistance Listing Number: Various – All R&D Cluster awards with equipment Condition The University has a process in place whereby a third-party is engaged to scan all equipment (federal and nonfederal) across their 3 campuses every two years. The third-party does not have a detailed listing when performing their inventory and thus the University must reconcile what was located by the thirdparty to their detailed equipment listing and understand why certain items were not located. If not located, follow-up is performed on an asset-by-asset basis by the University requesting the custodian of the asset confirm the equipment is on-hand. While we University provided evidence of the third-party inventory being performed, including a related manual reconciliation process, we were unable to obtain an aggregated reconciliation between the University equipment records and the third-party inventory results that included all follow-up information as the process is currently manual and disaggregated. Additionally, when scanning through the detailed listing of federal assets, certain equipment was noted to have an inventory date outside of the past 2 years. 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. Cause The University’s process for reviewing third-party equipment inventory results and conducting follow-up is manual, which can cause delays. Additionally, an aggregated reconciliation is not maintained, which can result in an incomplete or inaccurate inventory listing. Effect The lack of a formal reconciliation may result in incomplete equipment inventory records and/or certain assets not being physically inspected within the required 2-year period. Questioned Costs There are no questioned costs associated with this finding. Recommendation We recommend the University update their policies and procedures to require an aggregated reconciliation be maintained between third-party equipment inventory results and University equipment records. Additionally, the University should develop a more automated approach to resolving discrepancies between the third-party equipment inventory results and the federally funded equipment listing, rather than utilizing a manual process, which can cause delays. 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-002 – Equipment Management Cluster: Research and Development Cluster (“R&D Cluster”) Grantor: Various - All R&D Cluster awards with equipment Award Name: Various - All R&D Cluster awards with equipment Award Year: FY2023 Pass-through entities and ID Number: Various - All R&D Cluster awards with equipment Assistance Listing Number: Various – All R&D Cluster awards with equipment Condition The University has a process in place whereby a third-party is engaged to scan all equipment (federal and nonfederal) across their 3 campuses every two years. The third-party does not have a detailed listing when performing their inventory and thus the University must reconcile what was located by the thirdparty to their detailed equipment listing and understand why certain items were not located. If not located, follow-up is performed on an asset-by-asset basis by the University requesting the custodian of the asset confirm the equipment is on-hand. While we University provided evidence of the third-party inventory being performed, including a related manual reconciliation process, we were unable to obtain an aggregated reconciliation between the University equipment records and the third-party inventory results that included all follow-up information as the process is currently manual and disaggregated. Additionally, when scanning through the detailed listing of federal assets, certain equipment was noted to have an inventory date outside of the past 2 years. 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. Cause The University’s process for reviewing third-party equipment inventory results and conducting follow-up is manual, which can cause delays. Additionally, an aggregated reconciliation is not maintained, which can result in an incomplete or inaccurate inventory listing. Effect The lack of a formal reconciliation may result in incomplete equipment inventory records and/or certain assets not being physically inspected within the required 2-year period. Questioned Costs There are no questioned costs associated with this finding. Recommendation We recommend the University update their policies and procedures to require an aggregated reconciliation be maintained between third-party equipment inventory results and University equipment records. Additionally, the University should develop a more automated approach to resolving discrepancies between the third-party equipment inventory results and the federally funded equipment listing, rather than utilizing a manual process, which can cause delays. 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-002 – Equipment Management Cluster: Research and Development Cluster (“R&D Cluster”) Grantor: Various - All R&D Cluster awards with equipment Award Name: Various - All R&D Cluster awards with equipment Award Year: FY2023 Pass-through entities and ID Number: Various - All R&D Cluster awards with equipment Assistance Listing Number: Various – All R&D Cluster awards with equipment Condition The University has a process in place whereby a third-party is engaged to scan all equipment (federal and nonfederal) across their 3 campuses every two years. The third-party does not have a detailed listing when performing their inventory and thus the University must reconcile what was located by the thirdparty to their detailed equipment listing and understand why certain items were not located. If not located, follow-up is performed on an asset-by-asset basis by the University requesting the custodian of the asset confirm the equipment is on-hand. While we University provided evidence of the third-party inventory being performed, including a related manual reconciliation process, we were unable to obtain an aggregated reconciliation between the University equipment records and the third-party inventory results that included all follow-up information as the process is currently manual and disaggregated. Additionally, when scanning through the detailed listing of federal assets, certain equipment was noted to have an inventory date outside of the past 2 years. 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. Cause The University’s process for reviewing third-party equipment inventory results and conducting follow-up is manual, which can cause delays. Additionally, an aggregated reconciliation is not maintained, which can result in an incomplete or inaccurate inventory listing. Effect The lack of a formal reconciliation may result in incomplete equipment inventory records and/or certain assets not being physically inspected within the required 2-year period. Questioned Costs There are no questioned costs associated with this finding. Recommendation We recommend the University update their policies and procedures to require an aggregated reconciliation be maintained between third-party equipment inventory results and University equipment records. Additionally, the University should develop a more automated approach to resolving discrepancies between the third-party equipment inventory results and the federally funded equipment listing, rather than utilizing a manual process, which can cause delays. 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-002 – Equipment Management Cluster: Research and Development Cluster (“R&D Cluster”) Grantor: Various - All R&D Cluster awards with equipment Award Name: Various - All R&D Cluster awards with equipment Award Year: FY2023 Pass-through entities and ID Number: Various - All R&D Cluster awards with equipment Assistance Listing Number: Various – All R&D Cluster awards with equipment Condition The University has a process in place whereby a third-party is engaged to scan all equipment (federal and nonfederal) across their 3 campuses every two years. The third-party does not have a detailed listing when performing their inventory and thus the University must reconcile what was located by the thirdparty to their detailed equipment listing and understand why certain items were not located. If not located, follow-up is performed on an asset-by-asset basis by the University requesting the custodian of the asset confirm the equipment is on-hand. While we University provided evidence of the third-party inventory being performed, including a related manual reconciliation process, we were unable to obtain an aggregated reconciliation between the University equipment records and the third-party inventory results that included all follow-up information as the process is currently manual and disaggregated. Additionally, when scanning through the detailed listing of federal assets, certain equipment was noted to have an inventory date outside of the past 2 years. 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. Cause The University’s process for reviewing third-party equipment inventory results and conducting follow-up is manual, which can cause delays. Additionally, an aggregated reconciliation is not maintained, which can result in an incomplete or inaccurate inventory listing. Effect The lack of a formal reconciliation may result in incomplete equipment inventory records and/or certain assets not being physically inspected within the required 2-year period. Questioned Costs There are no questioned costs associated with this finding. Recommendation We recommend the University update their policies and procedures to require an aggregated reconciliation be maintained between third-party equipment inventory results and University equipment records. Additionally, the University should develop a more automated approach to resolving discrepancies between the third-party equipment inventory results and the federally funded equipment listing, rather than utilizing a manual process, which can cause delays. 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-002 – Equipment Management Cluster: Research and Development Cluster (“R&D Cluster”) Grantor: Various - All R&D Cluster awards with equipment Award Name: Various - All R&D Cluster awards with equipment Award Year: FY2023 Pass-through entities and ID Number: Various - All R&D Cluster awards with equipment Assistance Listing Number: Various – All R&D Cluster awards with equipment Condition The University has a process in place whereby a third-party is engaged to scan all equipment (federal and nonfederal) across their 3 campuses every two years. The third-party does not have a detailed listing when performing their inventory and thus the University must reconcile what was located by the thirdparty to their detailed equipment listing and understand why certain items were not located. If not located, follow-up is performed on an asset-by-asset basis by the University requesting the custodian of the asset confirm the equipment is on-hand. While we University provided evidence of the third-party inventory being performed, including a related manual reconciliation process, we were unable to obtain an aggregated reconciliation between the University equipment records and the third-party inventory results that included all follow-up information as the process is currently manual and disaggregated. Additionally, when scanning through the detailed listing of federal assets, certain equipment was noted to have an inventory date outside of the past 2 years. 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. Cause The University’s process for reviewing third-party equipment inventory results and conducting follow-up is manual, which can cause delays. Additionally, an aggregated reconciliation is not maintained, which can result in an incomplete or inaccurate inventory listing. Effect The lack of a formal reconciliation may result in incomplete equipment inventory records and/or certain assets not being physically inspected within the required 2-year period. Questioned Costs There are no questioned costs associated with this finding. Recommendation We recommend the University update their policies and procedures to require an aggregated reconciliation be maintained between third-party equipment inventory results and University equipment records. Additionally, the University should develop a more automated approach to resolving discrepancies between the third-party equipment inventory results and the federally funded equipment listing, rather than utilizing a manual process, which can cause delays. 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-002 – Equipment Management Cluster: Research and Development Cluster (“R&D Cluster”) Grantor: Various - All R&D Cluster awards with equipment Award Name: Various - All R&D Cluster awards with equipment Award Year: FY2023 Pass-through entities and ID Number: Various - All R&D Cluster awards with equipment Assistance Listing Number: Various – All R&D Cluster awards with equipment Condition The University has a process in place whereby a third-party is engaged to scan all equipment (federal and nonfederal) across their 3 campuses every two years. The third-party does not have a detailed listing when performing their inventory and thus the University must reconcile what was located by the thirdparty to their detailed equipment listing and understand why certain items were not located. If not located, follow-up is performed on an asset-by-asset basis by the University requesting the custodian of the asset confirm the equipment is on-hand. While we University provided evidence of the third-party inventory being performed, including a related manual reconciliation process, we were unable to obtain an aggregated reconciliation between the University equipment records and the third-party inventory results that included all follow-up information as the process is currently manual and disaggregated. Additionally, when scanning through the detailed listing of federal assets, certain equipment was noted to have an inventory date outside of the past 2 years. 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. Cause The University’s process for reviewing third-party equipment inventory results and conducting follow-up is manual, which can cause delays. Additionally, an aggregated reconciliation is not maintained, which can result in an incomplete or inaccurate inventory listing. Effect The lack of a formal reconciliation may result in incomplete equipment inventory records and/or certain assets not being physically inspected within the required 2-year period. Questioned Costs There are no questioned costs associated with this finding. Recommendation We recommend the University update their policies and procedures to require an aggregated reconciliation be maintained between third-party equipment inventory results and University equipment records. Additionally, the University should develop a more automated approach to resolving discrepancies between the third-party equipment inventory results and the federally funded equipment listing, rather than utilizing a manual process, which can cause delays. 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-002 – Equipment Management Cluster: Research and Development Cluster (“R&D Cluster”) Grantor: Various - All R&D Cluster awards with equipment Award Name: Various - All R&D Cluster awards with equipment Award Year: FY2023 Pass-through entities and ID Number: Various - All R&D Cluster awards with equipment Assistance Listing Number: Various – All R&D Cluster awards with equipment Condition The University has a process in place whereby a third-party is engaged to scan all equipment (federal and nonfederal) across their 3 campuses every two years. The third-party does not have a detailed listing when performing their inventory and thus the University must reconcile what was located by the thirdparty to their detailed equipment listing and understand why certain items were not located. If not located, follow-up is performed on an asset-by-asset basis by the University requesting the custodian of the asset confirm the equipment is on-hand. While we University provided evidence of the third-party inventory being performed, including a related manual reconciliation process, we were unable to obtain an aggregated reconciliation between the University equipment records and the third-party inventory results that included all follow-up information as the process is currently manual and disaggregated. Additionally, when scanning through the detailed listing of federal assets, certain equipment was noted to have an inventory date outside of the past 2 years. 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. Cause The University’s process for reviewing third-party equipment inventory results and conducting follow-up is manual, which can cause delays. Additionally, an aggregated reconciliation is not maintained, which can result in an incomplete or inaccurate inventory listing. Effect The lack of a formal reconciliation may result in incomplete equipment inventory records and/or certain assets not being physically inspected within the required 2-year period. Questioned Costs There are no questioned costs associated with this finding. Recommendation We recommend the University update their policies and procedures to require an aggregated reconciliation be maintained between third-party equipment inventory results and University equipment records. Additionally, the University should develop a more automated approach to resolving discrepancies between the third-party equipment inventory results and the federally funded equipment listing, rather than utilizing a manual process, which can cause delays. 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-002 – Equipment Management Cluster: Research and Development Cluster (“R&D Cluster”) Grantor: Various - All R&D Cluster awards with equipment Award Name: Various - All R&D Cluster awards with equipment Award Year: FY2023 Pass-through entities and ID Number: Various - All R&D Cluster awards with equipment Assistance Listing Number: Various – All R&D Cluster awards with equipment Condition The University has a process in place whereby a third-party is engaged to scan all equipment (federal and nonfederal) across their 3 campuses every two years. The third-party does not have a detailed listing when performing their inventory and thus the University must reconcile what was located by the thirdparty to their detailed equipment listing and understand why certain items were not located. If not located, follow-up is performed on an asset-by-asset basis by the University requesting the custodian of the asset confirm the equipment is on-hand. While we University provided evidence of the third-party inventory being performed, including a related manual reconciliation process, we were unable to obtain an aggregated reconciliation between the University equipment records and the third-party inventory results that included all follow-up information as the process is currently manual and disaggregated. Additionally, when scanning through the detailed listing of federal assets, certain equipment was noted to have an inventory date outside of the past 2 years. 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. Cause The University’s process for reviewing third-party equipment inventory results and conducting follow-up is manual, which can cause delays. Additionally, an aggregated reconciliation is not maintained, which can result in an incomplete or inaccurate inventory listing. Effect The lack of a formal reconciliation may result in incomplete equipment inventory records and/or certain assets not being physically inspected within the required 2-year period. Questioned Costs There are no questioned costs associated with this finding. Recommendation We recommend the University update their policies and procedures to require an aggregated reconciliation be maintained between third-party equipment inventory results and University equipment records. Additionally, the University should develop a more automated approach to resolving discrepancies between the third-party equipment inventory results and the federally funded equipment listing, rather than utilizing a manual process, which can cause delays. 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-002 – Equipment Management Cluster: Research and Development Cluster (“R&D Cluster”) Grantor: Various - All R&D Cluster awards with equipment Award Name: Various - All R&D Cluster awards with equipment Award Year: FY2023 Pass-through entities and ID Number: Various - All R&D Cluster awards with equipment Assistance Listing Number: Various – All R&D Cluster awards with equipment Condition The University has a process in place whereby a third-party is engaged to scan all equipment (federal and nonfederal) across their 3 campuses every two years. The third-party does not have a detailed listing when performing their inventory and thus the University must reconcile what was located by the thirdparty to their detailed equipment listing and understand why certain items were not located. If not located, follow-up is performed on an asset-by-asset basis by the University requesting the custodian of the asset confirm the equipment is on-hand. While we University provided evidence of the third-party inventory being performed, including a related manual reconciliation process, we were unable to obtain an aggregated reconciliation between the University equipment records and the third-party inventory results that included all follow-up information as the process is currently manual and disaggregated. Additionally, when scanning through the detailed listing of federal assets, certain equipment was noted to have an inventory date outside of the past 2 years. 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. Cause The University’s process for reviewing third-party equipment inventory results and conducting follow-up is manual, which can cause delays. Additionally, an aggregated reconciliation is not maintained, which can result in an incomplete or inaccurate inventory listing. Effect The lack of a formal reconciliation may result in incomplete equipment inventory records and/or certain assets not being physically inspected within the required 2-year period. Questioned Costs There are no questioned costs associated with this finding. Recommendation We recommend the University update their policies and procedures to require an aggregated reconciliation be maintained between third-party equipment inventory results and University equipment records. Additionally, the University should develop a more automated approach to resolving discrepancies between the third-party equipment inventory results and the federally funded equipment listing, rather than utilizing a manual process, which can cause delays. 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-002 – Equipment Management Cluster: Research and Development Cluster (“R&D Cluster”) Grantor: Various - All R&D Cluster awards with equipment Award Name: Various - All R&D Cluster awards with equipment Award Year: FY2023 Pass-through entities and ID Number: Various - All R&D Cluster awards with equipment Assistance Listing Number: Various – All R&D Cluster awards with equipment Condition The University has a process in place whereby a third-party is engaged to scan all equipment (federal and nonfederal) across their 3 campuses every two years. The third-party does not have a detailed listing when performing their inventory and thus the University must reconcile what was located by the thirdparty to their detailed equipment listing and understand why certain items were not located. If not located, follow-up is performed on an asset-by-asset basis by the University requesting the custodian of the asset confirm the equipment is on-hand. While we University provided evidence of the third-party inventory being performed, including a related manual reconciliation process, we were unable to obtain an aggregated reconciliation between the University equipment records and the third-party inventory results that included all follow-up information as the process is currently manual and disaggregated. Additionally, when scanning through the detailed listing of federal assets, certain equipment was noted to have an inventory date outside of the past 2 years. 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. Cause The University’s process for reviewing third-party equipment inventory results and conducting follow-up is manual, which can cause delays. Additionally, an aggregated reconciliation is not maintained, which can result in an incomplete or inaccurate inventory listing. Effect The lack of a formal reconciliation may result in incomplete equipment inventory records and/or certain assets not being physically inspected within the required 2-year period. Questioned Costs There are no questioned costs associated with this finding. Recommendation We recommend the University update their policies and procedures to require an aggregated reconciliation be maintained between third-party equipment inventory results and University equipment records. Additionally, the University should develop a more automated approach to resolving discrepancies between the third-party equipment inventory results and the federally funded equipment listing, rather than utilizing a manual process, which can cause delays. 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-002 – Equipment Management Cluster: Research and Development Cluster (“R&D Cluster”) Grantor: Various - All R&D Cluster awards with equipment Award Name: Various - All R&D Cluster awards with equipment Award Year: FY2023 Pass-through entities and ID Number: Various - All R&D Cluster awards with equipment Assistance Listing Number: Various – All R&D Cluster awards with equipment Condition The University has a process in place whereby a third-party is engaged to scan all equipment (federal and nonfederal) across their 3 campuses every two years. The third-party does not have a detailed listing when performing their inventory and thus the University must reconcile what was located by the thirdparty to their detailed equipment listing and understand why certain items were not located. If not located, follow-up is performed on an asset-by-asset basis by the University requesting the custodian of the asset confirm the equipment is on-hand. While we University provided evidence of the third-party inventory being performed, including a related manual reconciliation process, we were unable to obtain an aggregated reconciliation between the University equipment records and the third-party inventory results that included all follow-up information as the process is currently manual and disaggregated. Additionally, when scanning through the detailed listing of federal assets, certain equipment was noted to have an inventory date outside of the past 2 years. 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. Cause The University’s process for reviewing third-party equipment inventory results and conducting follow-up is manual, which can cause delays. Additionally, an aggregated reconciliation is not maintained, which can result in an incomplete or inaccurate inventory listing. Effect The lack of a formal reconciliation may result in incomplete equipment inventory records and/or certain assets not being physically inspected within the required 2-year period. Questioned Costs There are no questioned costs associated with this finding. Recommendation We recommend the University update their policies and procedures to require an aggregated reconciliation be maintained between third-party equipment inventory results and University equipment records. Additionally, the University should develop a more automated approach to resolving discrepancies between the third-party equipment inventory results and the federally funded equipment listing, rather than utilizing a manual process, which can cause delays. 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-002 – Equipment Management Cluster: Research and Development Cluster (“R&D Cluster”) Grantor: Various - All R&D Cluster awards with equipment Award Name: Various - All R&D Cluster awards with equipment Award Year: FY2023 Pass-through entities and ID Number: Various - All R&D Cluster awards with equipment Assistance Listing Number: Various – All R&D Cluster awards with equipment Condition The University has a process in place whereby a third-party is engaged to scan all equipment (federal and nonfederal) across their 3 campuses every two years. The third-party does not have a detailed listing when performing their inventory and thus the University must reconcile what was located by the thirdparty to their detailed equipment listing and understand why certain items were not located. If not located, follow-up is performed on an asset-by-asset basis by the University requesting the custodian of the asset confirm the equipment is on-hand. While we University provided evidence of the third-party inventory being performed, including a related manual reconciliation process, we were unable to obtain an aggregated reconciliation between the University equipment records and the third-party inventory results that included all follow-up information as the process is currently manual and disaggregated. Additionally, when scanning through the detailed listing of federal assets, certain equipment was noted to have an inventory date outside of the past 2 years. 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. Cause The University’s process for reviewing third-party equipment inventory results and conducting follow-up is manual, which can cause delays. Additionally, an aggregated reconciliation is not maintained, which can result in an incomplete or inaccurate inventory listing. Effect The lack of a formal reconciliation may result in incomplete equipment inventory records and/or certain assets not being physically inspected within the required 2-year period. Questioned Costs There are no questioned costs associated with this finding. Recommendation We recommend the University update their policies and procedures to require an aggregated reconciliation be maintained between third-party equipment inventory results and University equipment records. Additionally, the University should develop a more automated approach to resolving discrepancies between the third-party equipment inventory results and the federally funded equipment listing, rather than utilizing a manual process, which can cause delays. 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