Inventory Reports

30 reports covering every layer of inventory: stock levels, movement history, supplier performance, reorder status, valuation, work order aging, and dead stock. All live. No exports required.

The Regional Stock Imbalance report is where multi-location operations find money they did not know they had tied up. It compares maximum and minimum on-hand quantities per item across sites, surfacing situations where one facility has overstocked while another has dropped below reorder threshold. Rebalancing between locations costs far less than placing a new purchase order, but most operations only discover the imbalance after the order is already placed.

Inventory Aging by Lifecycle Status adds a time dimension that standard on-hand reports leave out entirely. Items do not just sit they age through procurement stages, and the cost of carrying them changes depending on where they are in that cycle. For operations managing capital-intensive inventory, this report is the difference between knowing what you have and knowing what your inventory is actually worth at any given moment.

Meet Ikhana

Your Personal Guide on Every Page

From the first click to the final step, Ikhana, your on-screen tutor, shows you how it all works. Every field, every button, every page explained with clarity, right where you need it.

On the inventory reports pages, Ikhana walks through filter configuration, date range logic, and how to read classification and aging outputs. With 30 reports available, knowing which one answers your specific question matters more than knowing all 30.

Learn more about Ikhana

The full inventory report library

• ABC Classification. Segments inventory into value tiers based on consumption. A items get the most management attention; C items reveal where capital is parked with minimal operational return. Drives reorder priority and cycle count frequency.
• Dead/Slow Stock (No Usage in Period, On-Hand > 0). Identifies items with no recorded consumption during a defined period while stock still exists. The starting point for any inventory reduction or write-down process.
• Duplicate Barcodes/SKUs. Finds items entered more than once under different identifiers. Correcting duplicates before they accumulate is what keeps on-hand counts accurate and physical counts from producing unexplainable variances.
• Fast-Moving Items (by Usage Qty in Period). Ranks items by consumption volume over a selected period. Used for storage placement decisions, safety stock reviews, and identifying which items carry the most operational risk if they go out of stock.
• Image/PDF/Video Coverage (Content Audit). Audits which inventory items have supporting documentation attached and which do not. For operations where item-level documentation affects compliance or training, this report identifies the gaps before an audit does.
• Inventory Aging by Lifecycle. Tracks how long items have been in each procurement stage. Identifies where inventory is sitting longer than expected in receiving, staging, or active storage, with cost-of-carry implications that standard on-hand reports do not show.
• Inventory Backorder. Lists items currently on backorder with the originating work orders or requests that triggered them. Operations managers can prioritize fulfillment and communicate delays to the affected teams without hunting through individual records.
• Inventory Turnover. Calculates how many times inventory cycles through in a period. Low turnover on high-value items flags carrying cost problems. High turnover on critical items flags reorder risk. Both matter and neither shows up in a simple on-hand count.
• Inventory Usage Log (Consumptions). A full audit trail of every item consumed, by whom, for what purpose, and from which location. Supports compliance documentation, cost allocation, and any investigation into unexplained stock reductions.
• Items to Reorder and Order. Compares current on-hand quantities against reorder thresholds across all locations. Items that have crossed their reorder point appear automatically, filtered by site, so procurement acts before a stockout is already in progress.
• Items Report. A full catalog view of all active inventory items with current attributes, classifications, storage assignments, and linked supplier records. The baseline reference report for any inventory audit or master data cleanup project.
• Items Without Any Storage (Not Stored Anywhere). Identifies items in the system with no assigned storage location. These are the items that will be missing from a physical count because there is no bin or shelf to look in. Finding them before an audit is considerably less disruptive than finding them during one.
• Items Without Any Vendor Mapping. Surfaces items with no supplier record attached. When a reorder is triggered for one of these items, procurement has no vendor to contact. This report makes the gap visible before the shortage makes it urgent.
• Last Movement Per Item (Most Recent History). Shows the most recent transaction date for every item in the system. Combines with the Dead/Slow Stock report to confirm whether an item has genuinely gone unused or was simply miscategorized in a previous report run.
• Movement Volume by Region/Station (Period). Aggregates transaction volume by physical location over a selected period. Identifies which stations or regions are driving the most inventory activity and which are underutilized relative to the stock assigned to them.
• On-Hand Inventory. Current stock quantities by item, location, and category. The foundational real-time view that every other inventory report builds on. Filters to a single site or shows the consolidated total across the full operation.
• On-Hand vs. Reorder (Replenishment). Compares current stock levels against defined reorder points and shows the replenishment gap in quantified terms. Used alongside vendor lead time data to time purchase orders before a shortage affects operations.
• Open Work Order Aging Buckets. Groups open work orders by elapsed time since creation. Long-aging work orders that have not been closed are often tied to inventory holds or parts delays that are not visible anywhere else in the system until this report surfaces them.
• Orphan Storage Rows (No Matching Inventory). Finds storage locations that exist in the system but have no inventory mapped to them. Critical for audit preparation and for operations that have reorganized physical storage without updating the system to match.
• Regional Stock Imbalance (Max-Min On-Hand per Item). Compares on-hand quantity highs and lows per item across all sites. Identifies where rebalancing between locations is more cost-effective than placing a new purchase order.
• Storage Movement History (Check-in/out trail). A full audit log of every item movement between storage locations, including who performed the movement and when. Supports both compliance documentation and the investigation of physical count discrepancies.
• Supplier Performance Scorecards. Measures vendor fill rate, on-time delivery, and lead time consistency over a configurable period. Gives procurement teams verified performance data for contract reviews and supplier negotiations.
• Top Users by Consumption (Period). Ranks individuals or teams by inventory consumption volume over a selected period. Useful for cost allocation, identifying unusual usage patterns, and supporting any investigation into unexplained stock reductions.
• Usage by Purpose (Period). Breaks consumption down by the stated purpose behind each transaction maintenance, production, project, or other categories defined by the operation. Supports cost center reporting and budget variance analysis at the item level.
• Valuation by Lifecycle Status. Calculates inventory value segmented by where each item sits in its lifecycle. Gives finance teams the data they need for period-end reporting without a manual reconciliation between the inventory system and the accounting platform.
• Vendor Catalog and Last Order. Shows the full supplier catalog for each vendor alongside the date and quantity of the most recent order placed. Useful for consolidating purchasing decisions and for identifying suppliers that have not been used recently despite having active catalog agreements.
• Vendor Lead Time KPI. Tracks whether each supplier's actual delivery window matches their quoted lead time. Discrepancies between promised and actual lead times show up here before they turn into reorder calculation errors that cause stockouts.
• Vendor Spend Summary (Orders). Aggregates total purchase order value per supplier over a defined period. The data foundation for volume discount negotiations and for identifying where spend is concentrated across the supplier base.
• Work Order Turnaround (Closed Only). Measures elapsed time between work order creation and closure for completed orders. Identifies where fulfilment takes longer than expected, whether the delay is in parts availability, labor, or approval.
• Zero On-Hand Items with Open Work Orders. The report that prevents operational surprises. Finds items currently at zero on-hand quantity that have active work orders waiting on them. These are the stockouts that have already happened but have not yet caused a visible operational failure.

What operations see after deployment

• Physical counts produce fewer surprises. Orphan storage rows, items without storage assignments, and duplicate SKUs are identified and corrected before count day rather than during it, which means variances that do appear are real discrepancies rather than data artifacts.
• Procurement stops reacting and starts anticipating. Reorder reports, vendor lead time data, and regional imbalance visibility combine to give purchasing teams enough lead time to act before a stockout is already affecting work orders.
• Capital tied up in dead stock becomes visible and addressable. The Dead/Slow Stock and Inventory Aging reports give finance and operations a shared view of where inventory value is sitting idle, which changes the conversation about what to carry and what to reduce.
• Supplier reviews are grounded in verified data. Scorecard, lead time, and spend reports replace the account relationship as the basis for vendor conversations, which produces better contract terms and more reliable delivery commitments.

Questions operations teams ask before deploying inventory reporting

How many inventory reports does FireFlight include?

+

FireFlight includes 30 inventory reports covering stock levels, movement history, supplier performance, reorder status, valuation, work order aging, and more. All reports run against live data with no export or scheduled refresh required.

What is the ABC Classification report in FireFlight?

+

The ABC Classification report segments your inventory into tiers based on consumption value: A items are your highest-value movers, C items are low-value and slow. This classification drives reorder prioritization, storage placement decisions, and cycle count frequency without manual analysis.

How does FireFlight identify dead stock and slow-moving inventory?

+

The Dead and Slow Stock report filters for items with no recorded usage within a defined period while on-hand quantity is greater than zero. You set the period. The report flags items that are consuming storage and capital without contributing to operations, which is the starting point for any inventory reduction effort.

Can FireFlight identify items that need to be reordered across multiple locations?

+

Yes. The Items to Reorder and Order report compares current on-hand quantities against defined reorder points across every location in your system. Items that have dropped below threshold appear automatically, filtered by site if needed, so procurement can act before a stockout occurs.

What does the Regional Stock Imbalance report show?

+

The Regional Stock Imbalance report compares maximum and minimum on-hand quantities for each item across sites. It surfaces situations where one location is overstocked on an item while another location is running short, which allows operations to rebalance before placing a new purchase order.

Does FireFlight track supplier performance beyond just order history?

+

Yes. The Supplier Performance Scorecards report measures vendor fill rate, on-time delivery, and lead time consistency over a defined period. Combined with the Vendor Lead Time KPI and Vendor Spend Summary reports, procurement teams have the data to evaluate suppliers on actual performance rather than account rep relationships.

How long does it take to deploy FireFlight inventory reporting for my operation?

+

Most operations are running live inventory reports in weeks, not months. PCG handles configuration, data migration, and training. The timeline depends on the number of locations, item categories, and integrations involved. There is no rebuild of your existing processes from scratch.

Allison Woolbert

Principal, Phoenix Consultants Group  |  Developer, FireFlight Data Systems

PCG founded 1995. 500+ applications built across 31 years, roughly one-third in regulated environments where software failure carries direct operational and compliance consequences. FireFlight is the platform built from that body of work. When you contact PCG, Allison is the person who answers.

phxconsultants.com LinkedIn

FireFlight Data Systems is a product of Phoenix Consultants Group. PCG founded 1995. All system configurations are custom-built for each deployment. Implementation timelines, module availability, and integration scope vary by organization. Contact PCG directly to discuss requirements specific to your operation.