# ERP Report Inventory Worksheet > Source: https://netray.co/tools/erp-report-inventory-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer An editable worksheet to list every ERP report, who owns it, how often it runs and whether to keep, merge or retire it. ## Category erp-operations ## Audience - ERP administrator - Controller - IT manager ## Tool **Kind:** worksheet **Mode:** editable **Columns:** #### Report ID **Key:** report_id **Type:** text #### Report name **Key:** report_name **Type:** text #### System **Key:** erp **Type:** select **Options:** - SAP - Oracle EBS - Infor SyteLine - Epicor Kinetic - NetSuite - Dynamics 365 - Spreadsheet - Other #### Type **Key:** kind **Type:** select **Options:** - Standard - Custom - Ad hoc export - Spreadsheet macro #### Business owner **Key:** owner **Type:** text #### Runs per month **Key:** runs **Type:** number #### Minutes per run **Key:** minutes **Type:** number #### Distinct users **Key:** users **Type:** number #### Hours per month **Key:** hours **Type:** number **Expr:** runs * minutes / 60 **Format:** hours #### Last used **Key:** last_used **Type:** date #### Decision **Key:** decision **Type:** select **Options:** - Keep - Merge - Retire - Review **Rows:** **Report id:** R-001 **Report name:** Open sales orders by customer **Erp:** Infor SyteLine **Kind:** Standard **Owner:** Customer service **Runs:** 60 **Minutes:** 5 **Users:** 8 **Last used:** 2026-10-14 **Decision:** Keep **Report id:** R-002 **Report name:** Weekly inventory aging (Excel macro) **Erp:** Spreadsheet **Kind:** Spreadsheet macro **Owner:** Materials **Runs:** 4 **Minutes:** 45 **Users:** 2 **Last used:** 2026-10-09 **Decision:** Merge **Report id:** R-003 **Report name:** Job cost variance by work center **Erp:** SAP **Kind:** Custom **Owner:** Cost accounting **Runs:** 4 **Minutes:** 30 **Users:** 3 **Last used:** 2026-09-30 **Decision:** Keep **Report id:** R-004 **Report name:** Supplier late receipts 2019 format **Erp:** Oracle EBS **Kind:** Custom **Owner:** Purchasing **Runs:** 0 **Minutes:** 20 **Users:** 0 **Last used:** 2025-02-11 **Decision:** Retire **Report id:** R-005 **Report name:** AR aging summary **Erp:** NetSuite **Kind:** Standard **Owner:** Finance **Runs:** 8 **Minutes:** 10 **Users:** 4 **Last used:** 2026-10-12 **Decision:** Review **Totals:** #### Total report hours per month **Key:** hours **Agg:** sum **Format:** hours #### Reports listed **Key:** report_id **Agg:** count **Format:** integer **Summary:** #### Average hours per report **Key:** avg_hours **Expr:** sum_hours / count **Format:** hours **Notes:** Pull the first list from your ERP's report or job audit log, then add the spreadsheets people keep on their own drives. Hours per month is runs times minutes per run divided by 60. ## Content **Intro:** Most companies cannot say how many reports their ERP produces, who reads them or which are obsolete. This worksheet gives you a single list to fill in once and sort many ways, then export to Excel for the review meeting. **Sections:** #### How to fill in the report inventory **Body:** Start with the reports your ERP can list for you: scheduled jobs, saved queries, custom report definitions and the audit or usage log. Then add the shadow reports, the spreadsheets and macros that finance and operations rebuild every week from exports. Give each a short ID, the business owner (not the developer), the number of runs per month, a typical run time and the number of distinct users. Leave decision as Review until you have talked to the owner. **Bullets:** - One row per report, not per variant, note variants in the name - Owner is the person who would complain if it disappeared - Include spreadsheets that are fed by an ERP export #### What the numbers tell you **Body:** Runs per month and distinct users separate living reports from dead ones. A report with zero runs in twelve months is a retirement candidate. A report run daily by one person for five minutes is a candidate for scheduling. Reports with many users but long run times may need an index or a data extract. The hours column adds up the human cost, the first number executives usually care about when you propose consolidation. #### Using the decision column **Body:** Keep means leave alone. Merge means another report already covers most of the content and the two should become one. Retire means archive the definition and remove it from menus after a notice period. Review means the owner has not confirmed. Aim to have no rows in Review before you run the rationalization checklist, because the checklist assumes owners have answered. #### Common mistakes **Body:** People list only standard reports and miss the custom ones where the risk lives. They accept a developer as the owner, then nobody can say whether the report is needed. They skip the last used date, so retirement debates run on opinion. Finally, they forget to record the data source, which matters later if you migrate ERPs and need to rebuild the reports. **Cta:** If your report list is long and hard to read, Netray can help analyze usage logs and map reports to the underlying tables so the rebuild or retirement decisions are quicker. **Faq:** #### Where do I get a list of ERP reports? **Answer:** Most ERPs have a report or job definition list and a log of executions. Ask your administrator for scheduled jobs, saved queries and user-created report definitions. Then survey departments for spreadsheets and macros that are fed by exports. #### How do I estimate minutes per run? **Answer:** Use the log if it records elapsed time. Otherwise ask the owner for a typical run and include the time to export and format the result. Estimates are fine for ranking reports against each other. #### How often should the inventory be updated? **Answer:** Do a full pass once a year and before any upgrade or ERP migration. Between those, add rows whenever a new custom report is released so the list does not go stale. #### Is this the same as a data dictionary? **Answer:** No. A data dictionary describes fields and tables. A report inventory describes outputs, owners and usage. Both help in a migration, but you can build the report inventory without the dictionary. ## Search terms erp report inventory, report catalog template, erp report audit worksheet, list of erp reports excel, report inventory template, erp report usage analysis, custom report inventory --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json