Warehouse reports are read by two people with different questions: the operator, who wants to know whether the building is earning its rate card this week, and the client, who wants to know whether its stock is accurate and its orders are leaving on time. Warehouse reporting that serves both is a short weekly set per client, produced from figures the operation already records, rather than a monthly export nobody reads. This page sets out what belongs on it, where each figure comes from, how it is calculated and what to leave off, and the free reports worksheet on this site builds the set from a week's totals with no account and no vendor named.
The four figures and where they come from
Throughput: orders and lines shipped this week, from the shipping confirmations. Labor: lines and orders per labor hour and cost per order, from the pick totals against the hours worked on the account at a loaded rate. Accuracy: inventory accuracy from the cycle counts and pick accuracy from the pack-bench checks. Dock: dock-to-stock hours on receipts, from the receipt timestamps against the putaway confirmations. Every one is derivable from a barcode WMS log and a timesheet; if one of them is not, the operation has a gap in its scanning rather than a gap in its reporting.
How the report is laid out and read
One page per client per week, the four figures with last week and the four-week trend beside each, and a short list of exceptions: the discrepancies found and their causes, the orders that missed the cut-off and why, the receipts that waited. The operator reads all of them on Monday and compares cost per order with the handling rate; the client reads accuracy and on-time first. A report that runs to ten pages of charts is a report that stops being read by week three. The worksheet on this site produces the four figures from the orders, lines, hours, receipts and counts you enter and shows the arithmetic beside each.
What to leave out, and what to keep
Leave out industry benchmarks, because the client's account is compared with its own history, not with a published rate that measured a different building. Leave out figures that cannot be traced to a scan or a timesheet. Keep the history, because the trend is the report's real content, and keep the exceptions with their causes, because they are what the client actually asks about. Pickpathly Pro keeps every week's report per client on one record with its history and exports it, so the Monday report is a read, not a rebuild.
Questions people ask about warehouse reports
What should a weekly warehouse report include?
Orders and lines shipped, lines and orders per labor hour, cost per order, inventory and pick accuracy, dock-to-stock time, each with last week and the trend, plus the exceptions with their causes. One page per client.
Where do warehouse reporting figures come from?
From the WMS scan log and the timesheet: shipping confirmations, pick totals, cycle counts, pack-bench checks and receipt-to-putaway timestamps. If a figure cannot be traced to one of those it does not belong on the report.
Should warehouse reports include industry benchmarks?
No. A client's account is measured against its own history. A published benchmark measured a different building with different products, and this site publishes none.