Why most warehouses are reporting on the wrong things
Most warehouse management articles list the same KPIs — order accuracy, inventory turnover, space utilisation, dock-to-stock time. These are valid metrics. But the problem most Indian warehouses actually have is not measuring the wrong metrics. It is measuring nothing, or measuring the right things after the damage is already done.
A stock discrepancy discovered at the annual stocktake has been accumulating for twelve months. A supplier who has been short-delivering appears in the accounts, but nobody in the warehouse has the report that shows the pattern. A customer with ₹18 lakh overdue continues to receive dispatches because the store man has no visibility of receivables. These are not metric problems — they are reporting timing problems.
The 6 reports in this guide are chosen for one specific reason: they show problems early enough to act on them. Each one identifies a failure mode while there is still time and cost-effective action available. And one of them — the 6th report category — lives in the Fast WMS but is absent from most generic WMS products because most WMS products are built for e-commerce, not for manufacturers, distributors, and traders.
Stock Reconciliation Report
What it shows
The Stock Reconciliation Report compares what the WMS says is in stock (system quantity, per item, per bin, per lot) against what a physical count finds is actually present. The difference — the variance — is the accumulated result of every GRN error, picking error, unrecorded transfer, and system entry mistake since the last count.
Why it matters in India
In Indian warehouses without a WMS, the stock reconciliation is done once a year at the annual stocktake — a 2–3 day shutdown that reveals variances that have been accumulating for twelve months. By the time the variance is found, the cause is untraceable. Was it a short delivery in May? A picking error in August? A transfer that was never recorded? The annual reconciliation tells you the number. It cannot tell you why — or where the same error is happening right now.
A WMS-driven reconciliation report changes this completely. Cycle counts happen continuously — one bin group per day or week — and variances appear immediately, while the cause is still recent and traceable.
What the report looks like in Fast WMS
| Item Code | Item Description | Store / Bin | WMS Qty | Physical Qty | Variance | Variance % |
|---|---|---|---|---|---|---|
| GI-PIPE-40MM | GI Pipe 40mm x 6m | Bay C · Bin B2 | 240 pcs | 228 pcs | -12 pcs | -5.0% |
The report shows every line where physical count and system count disagree. Positive variances (more physically than system shows) suggest unrecorded receipts or returns. Negative variances (less physically than system shows) suggest picking errors, unrecorded issues, damage, or theft. Fast WMS generates this report from cycle count data — the adjustment is then manually reviewed and posted (not automatic) to maintain human control over stock changes.
The benchmark
World-class warehouses achieve 97% or higher inventory accuracy (WERC 2025 research). The average is meaningfully lower — most operations that transition from manual record-keeping discover significant variances in their first WMS cycle count, simply because the WMS captures movements that previously went unrecorded.
Picker Accuracy Report
What it shows
The Picker Accuracy Report tracks, for each individual picker and for the warehouse team as a whole, what percentage of picks were completed correctly — correct item, correct lot, correct quantity — out of all picks attempted.
| Picker | Total Picks | Correct | Errors | Accuracy % | Date Range |
|---|---|---|---|---|---|
| Store Supervisor | 1,240 | 1,238 | 2 | 99.84% | June 2026 |
| Store Man A | 890 | 883 | 7 | 99.21% | June 2026 |
| Store Man B | 760 | 731 | 29 | 96.18% ⚠ | June 2026 |
| Team Total | 2,890 | 2,852 | 38 | 98.68% | June 2026 |
Store Man B at 96.18% is significantly below team average and benchmark — this is a coaching signal, not a performance review.
Why it matters in India
In most Indian warehouses, picking accuracy is invisible until a customer complains. A wrong item dispatched to a customer triggers a return, a credit note, a re-dispatch, and a customer relationship conversation — all of which cost significantly more than catching the error at the dock.
The Picker Accuracy Report makes accuracy visible at the individual level — before errors reach the customer. A picker at 96% accuracy is generating three to four times more errors than the industry average. That signal appears in the weekly report, not in a customer complaint two weeks later.
The benchmarks
The 2025 WERC DC Measures Report benchmarks average picking accuracy at 99.49% for warehouse operations. Improving from 96% to 99.5% accuracy can reduce returns processing costs by up to 88% — because the cost of a picking error cascades through rework, re-dispatch, and customer relationship cost. Each return costs $15–45 (approximately ₹1,250–₹3,750) to process in a typical operation.
Individual vs team report
Fast WMS produces both. The team report shows the warehouse's overall accuracy — useful for management reviews and customer SLA discussions. The individual report identifies which specific pickers are generating disproportionate errors — useful for targeted coaching, training, and process review. The data is by date range (day, week, month) and by item or order category.
Warehouse Space Utilisation Report
What it shows
The Warehouse Space Utilisation Report shows, for every bin in the warehouse, the current stock vs the defined capacity — expressed as a percentage in both weight (kg) and volume (cubic metres). At the warehouse level, it shows overall utilisation: how much of the total warehouse capacity is currently in use.
| Bin Location | Capacity (kg) | Used (kg) | Utilisation % | Status |
|---|---|---|---|---|
| Bay A · Bin A1 | 1,000 kg | 960 kg | 96% | 🟡 Near full |
| Bay A · Bin A2 | 1,000 kg | 420 kg | 42% | 🟢 Available |
| Bay B · Bin B3 | 1,000 kg | 1,020 kg | 102% | 🔴 Overloaded |
| Bay C · Bin C1 | 500 kg | 0 kg | 0% | ⚪ Empty |
The report also shows at the warehouse level: total capacity, total used, overall utilisation percentage. And it produces the Graphical Stock Report — a colour-coded visual grid of the warehouse layout showing which bins are full, available, empty, or in hold status at a glance.
Why it matters
The 2025 WERC DC Measures Report shows the average warehouse space utilisation is just 68%. This means most warehouses are using barely two-thirds of their available space — while simultaneously feeling "full" because specific popular areas are overcrowded and unpopular areas are empty.
The utilisation report surfaces both problems: bins that are overloaded (accuracy risk, damage risk, safety risk) and bins that are empty or underutilised (slotting inefficiency, wasted capacity). The combination drives better slotting decisions — moving fast-moving items to accessible empty space, and moving slow-movers away from premium locations.
Want to see your warehouse in the graphical bin map?
Fast WMS's graphical stock report shows every bin in your warehouse — colour-coded by status, capacity, and stock — in a live visual grid. Takes 30 minutes to demonstrate on your warehouse layout.
Lot Expiry Dashboard
What it shows
The Lot Expiry Dashboard shows every lot of stock in the warehouse that has an expiry date — organised by how close each lot is to expiry. Fast WMS uses 9 time bands:
Each band is clickable — drilling down to the specific lots, quantities, bin locations, and supplier details for stock in that time window.
Why 9 bands matter — and why a binary flag doesn't
Most WMS products offer an "expiry alert" — a flag that appears when a lot is within X days of expiry, typically 30 or 60 days. This is binary: either the alert is on or off. It doesn't help procurement answer the questions that actually matter: how much stock is expiring in the next three months? In the next six months? What's the total value of stock expiring within 90 days across all bins?
The 9-band dashboard answers all of these. A cold storage operator looking at ₹14 lakh of stock in the "Next 3 Months" band can take action — promote the items, negotiate a return with the supplier, apply a price reduction — three months before expiry. With a binary flag, they find out 30 days before it's too late.
The enforcement layer
The dashboard is the visibility layer. The enforcement layer is what happens at picking: lots in the "Previous" band (already expired) are automatically excluded from pick lists in Fast WMS. They cannot be scanned and confirmed for dispatch — regardless of what the picker attempts. Near-expiry lots are prioritised in pick lists via FEFO (First Expired First Out) — the system picks the lot closest to expiry first, without the picker needing to check dates.
Fast / Slow Moving Stock Report
What it shows
The Fast Moving Stock Report identifies which items are being dispatched at the highest rate over a selected date range — by volume, by value, or by number of transactions. The Slow Moving Stock Report (its counterpart) identifies items with minimal or no dispatch activity over the same period.
| Item | Dispatched | Value | Rank |
|---|---|---|---|
| GI Pipe 40mm | 1,240 pcs | ₹7,44,000 | #1 |
| SS Elbow 90° | 890 units | ₹4,27,200 | #2 |
| MS Sheet 3mm | 760 kg | ₹3,04,000 | #3 |
| Item | Last Dispatch | In Stock | Value |
|---|---|---|---|
| Copper Tube 8mm | 147 days | 280 pcs | ₹98,000 |
| SS Sheet 2mm | 203 days | 120 kg | ₹72,600 |
| MS Flat Bar 50×6 | 316 days | 85 pcs | ₹34,000 |
Why both reports matter
Fast-moving items drive two actions: reorder (ensure reorder level in Fast WMS triggers a replenishment before stockout) and slotting (fast movers belong in the most accessible bins near dispatch — see Tip 5 of the warehouse management tips guide).
Slow-moving items drive three actions: working capital review (₹2.04 lakh tied up in items that haven't moved in 3–10 months), obsolescence check (will these items move at all, or should they be returned, discounted, or written off), and space reclamation (slow-movers in premium bins should make way for faster-moving items).
The combination most businesses overlook
The most dangerous category in any warehouse is a slow-moving item with an expiry date. It combines two risk factors: capital tied up, and a ticking clock. Running the Slow Moving Stock Report filtered by items that also appear in the "Next 3 Months" or "Next 6 Months" band of the Lot Expiry Dashboard identifies this category precisely. This combination report is the one that should drive urgent procurement and sales team conversations.
The finance bridge: Outstanding Payments + Supplier Rejection Analysis
This is the 6th category — the one the title promised. These two reports don't appear in most WMS products because most WMS products are built for e-commerce fulfillment — where payment is upfront and suppliers are large companies with formal performance contracts.
For Indian manufacturers, distributors, and traders, the reality is different: credit terms are common, payment follow-up is a daily operational task, and supplier performance is managed informally until a problem becomes serious. Fast WMS includes both reports as standard — because the warehouse is the operational source of the data that makes them accurate.
Outstanding Payment Report
The Outstanding Payment Report shows all customer invoices that have not been fully paid — by customer, by invoice, with days overdue and balance outstanding.
| Party Name | Invoice No | Invoice Date | Due Date | Days Overdue | Amount | Paid | Balance |
|---|---|---|---|---|---|---|---|
| Rajan Steel Traders | INV-2026-0441 | 15 Apr 2026 | 15 May 2026 | 38 days | ₹8,40,000 | ₹5,00,000 | ₹3,40,000 |
| Mehta Fabricators | INV-2026-0398 | 02 Apr 2026 | 02 May 2026 | — | ₹12,60,000 | ₹12,60,000 | ₹0 ✓ |
| Global Components | INV-2026-0512 | 28 Apr 2026 | 28 Jun 2026 | 5 days ⚠ | ₹18,90,000 | ₹0 | ₹18,90,000 |
| Total outstanding balance | ₹22,30,000 | ||||||
This report answers the question a business owner asks every Monday morning — "who owes us money and for how long?" — without opening Tally or the ERP. The answer comes from the WMS because the WMS is where dispatch and invoicing happen. Fast WMS generates the payment follow-up alert automatically — by email, WhatsApp, or SMS to the customer when an invoice becomes overdue.
Supplier Rejection Analysis
The Supplier Rejection Analysis Report aggregates all Non-Conformance Reports (NCRs) generated at inward inspection — by supplier, by item, by rejection reason, by period.
| Supplier | Period | GRN Qty | Rejected | Rejection % | Primary Reason | NCRs |
|---|---|---|---|---|---|---|
| Rajputana Metals | Jun 2026 | 1,200 pcs | 84 pcs | 7.0% | Dimensional out of tolerance | 3 |
| Shree Steel Works | Jun 2026 | 800 kg | 16 kg | 2.0% | Surface defect | 1 |
| Gupta Fasteners | Jun 2026 | 5,000 pcs | 450 pcs | 9.0% ⚠ | Wrong specification | 5 |
Gupta Fasteners at 9% rejection rate across 5 NCRs in June alone is a procurement conversation that should happen this week — not after another six months of absorbing replacement costs and production delays. The supplier rejection report makes this visible from the warehouse's inspection data.
The connection between these two reports is not coincidental. The outstanding payment report shows what customers owe. The supplier rejection analysis shows what costs suppliers are generating. Together with the stock reconciliation report (what's accurate) and the fast/slow moving report (what's moving), these four reports give a business owner a complete operational and financial picture of the warehouse — without opening a separate finance system.
How these 6 reports connect to each other
These 6 reports are not independent — they form a connected picture of warehouse health. Each one answers a different question, and together they cover every dimension that matters:
| Report | Answers the question | When to check | Action it drives |
|---|---|---|---|
| Stock Reconciliation | Is my inventory record accurate? | After every cycle count | Trace and adjust variances while cause is recent |
| Picker Accuracy | Which pickers are generating errors and at what rate? | Weekly per picker | Coach or retrain underperforming pickers before errors reach customers |
| Space Utilisation | Am I using my warehouse space efficiently? | Monthly | Move slow-movers, slot fast-movers near dispatch, identify expansion need |
| Lot Expiry Dashboard | What stock am I at risk of losing to expiry? | Daily (cold chain / pharma) or weekly | Promote, return, or dispose of near-expiry stock proactively |
| Fast / Slow Moving | What's moving, what's sitting, and what's tying up capital? | Weekly | Trigger reorders for fast-movers; plan disposition for slow-movers |
| Outstanding Payments | Who owes us money and for how long? | Daily or weekly | Send payment reminders; hold dispatch for overdue customers if appropriate |
| Supplier Rejection | Which suppliers are consistently generating quality problems? | Monthly | Data-driven supplier review; NCR-backed quality conversations |
A warehouse manager who reviews these 7 questions (note: the outstanding payments / supplier rejection count as 2 within the 6th report category) every week has, in practice, a complete picture of whether the warehouse is accurate, efficient, financially healthy, and quality-controlled — without requiring a separate management information system. The WMS is the MIS.
