WMS Reports: Inventory, Fulfillment, and Warehouse Cost

WMS reports connect what is in the warehouse, which orders need attention, and how much work the operation is processing. Select a small report package with shared warehouse codes and cutoffs so inventory, fulfillment, and labor views explain one another.

Choose reports by the questions they answer

Use an inventory balance report to ask what is recorded, allocated, held, or available at a specified time. Use a movement report to explain how that balance changed. Keep a fulfillment exception report for late, short, damaged, or documentation-affected orders, and a workload report for the processing effort behind the shipments.

These are business report categories, not instructions for configuring a particular system. Export names differ, so inspect the columns and the row definition. A shipment-line file cannot answer an order-level question until split shipments and repeated order IDs have been resolved.

The warehouse operating KPI guide owns the definitions of picking accuracy, throughput, cycle time, and labor cost per order. Here, the job is to select the reports that make those measures trustworthy and useful.

Keep the row definitions visible

For inventory, use warehouse, SKU, location, ownership status, stock status, unit of measure, and snapshot timestamp. For movements, add the movement ID, event timestamp, type, quantity, and reference document. For fulfillment, retain order ID, requested quantity, promised date, shipment date, and exception reason.

Labor and cost records need a warehouse, activity, work date, hours, and included cost. Decide whether a transfer is an outbound movement at one warehouse and an inbound movement at another. It is neither a customer shipment nor a new purchase for the company.

Also separate physical custody from financial ownership. The Census wholesale definitions value inventories at cost and exclude goods on a firm's premises that it does not own. A WMS quantity report can include those goods operationally, so it will not automatically reconcile to the company's inventory value.

Worked inventory report: balance before availability

A fictional US industrial distributor reviews a warehouse at the close of October 23, 2026. The movement table covers the same period as the opening and closing snapshots. Quantities are units, with no conversion between cases and individual items.

Closing book units = Opening units + Receipts − Shipments + Signed adjustments

For SKU A, 120 + 80 − 150 − 2 = 48 units. Across the table, 270 + 150 − 280 − 1 = 139 units. The adjustment signs matter: the total is a net reduction, even though one SKU has an increase.

Now compare the book balance with the count and stock status. In this example, allocated and held stock are disjoint categories.

Book availability is 139 − 45 − 6 = 88 units. That is provisional because SKU B has an unresolved shortage: 47 counted − 50 recorded = −3 units. The inventory controller investigates movement timing, location errors, and count quality before an approved adjustment changes the book balance.

The count does not silently replace the recorded quantity. Showing the exception preserves the evidence and prevents an unresolved discrepancy from becoming a confident availability promise.

Connect the shipment total to order exceptions

The shipment report contains these customer orders. The shipped quantities tie to the inventory movement table's 280 units.

Requested quantity less shipped quantity is 300 − 280 = 20 units, all on B101. The package has two exception orders out of four, or 50%. That figure is an order exception rate for these declared conditions; it does not prove delivery performance because the table contains shipment dates rather than delivery evidence.

For the fuller customer outcome, use the perfect order fulfillment KPI, which also considers damage and correct documentation. Exporters should include document checks: the International Trade Administration's export document guidance says the commercial invoice should reflect the information on the packing list. A matching quantity is not enough when the accompanying documents disagree.

Add workload and a clearly bounded cost view

The same review includes direct labor records. These illustrative costs use an included labor rate of $30.00 per hour across all activities.

The cost check is 50 × 30 = $1,500. Dividing by the four shipped orders gives $375.00 per order; dividing by 280 shipped units gives $5.36 per unit, rounded to cents. Label both as included direct labor cost, since this table contains no rent, equipment, supervision, or other overhead.

Receiving and picking quantities describe different activities. Adding them together as unique units processed would count goods at multiple steps. Compare activity workloads separately, then investigate where time accumulates or work remains open.

Own the exceptions and the reconciliation

The inventory controller owns unexplained stock differences. Warehouse supervisors own processing queues and staffing questions. Customer operations owns the promised-date and order-status rules, while finance checks the cost boundary and ledger agreement.

Before a recurring review, tie opening balances to the previous close, movements to their source registers, shipments to the order report, and labor cost to approved records. A control total proves coverage outside the report, while the balance equation proves that its own figures fit together.

Where WMS report packages go wrong

• Different cutoffs. A balance after a shipment cannot be reconciled using movements that stop before it.
• Repeated order headers. Summing order quantities repeated on shipment lines inflates demand and can hide shortages.
• Overlapping stock statuses. Subtracting an allocation and a hold that describe the same units understates availability.
• Mixed units. A case receipt cannot be added to each-unit shipments without the approved conversion.
• Incomplete costs. An activity file does not establish total warehouse cost without the corresponding financial records.

Read your warehouse report package in Covirage

Upload a sample of your own inventory, shipment, and labor files to Covirage; it maps the columns, and its tools compute and check the comparisons. The external AI model explains the result with every figure traced to its rows. Create a free Covirage account and bring your own exports after setting up your business.

See Covirage for shipping and logistics for the supporting industry context.