The eight reports, in one list
Eight inventory reports cover almost every stock decision a business makes: the stock ledger (every movement, with a running balance), item-wise and location-wise stock (current on-hand), stock valuation (what the inventory is worth), ABC analysis (which items carry the value), reorder-level alerts (what to buy before it runs out), non-moving and slow-moving analysis (where cash is frozen), the lot expiry dashboard (what expires when) and the physical count variance report (book stock versus counted stock). If your system produces these eight reliably, you can answer quantity, location, value, priority, replenishment, dead stock, shelf life and accuracy — which is essentially every question a stores, purchase or finance head will ever ask.
This guide walks through each report: the question it answers, what a good version contains, and how often to review it. It assumes the foundations covered in the pillar guide, what is inventory management software — in particular that stock is a running balance changed only by documents, because every report below is only as truthful as the movements behind it.
Why most stockrooms have data but no answers
Most SME stockrooms are not short of numbers — they are short of reports. A spreadsheet export of current quantities is a snapshot: no history, no valuation basis, no link to the documents that produced it. The moment a figure looks wrong there is nothing to drill into, so the "report" gets argued about instead of acted on.
A real inventory report is different in three ways: it is generated from the movement engine, not typed; it is traceable, so every figure opens down to the document that caused it; and it is repeatable, which is what makes a review rhythm possible. That is why moving off spreadsheets (see how to migrate from Excel to inventory software) changes reporting more than anything else.
1. The stock ledger — every movement, traceable
The question it answers: how did this item's stock get to today's figure?
The stock ledger is the movement history of an item in a store: opening balance, then every receipt, issue, return, transfer and adjustment in sequence — each row carrying quantity, transaction type, reference number and rate, with a plus or minus effect — down to the closing balance. Because the ledger is immutable (corrections are new postings, never edits), it is the report an auditor, an accountant or anyone investigating a discrepancy actually needs. When a physical count throws up a variance, the ledger is where you find out whether the cause was a missed issue slip, a transfer posted to the wrong store or a receipt booked twice.
Review it on demand — whenever a figure needs explaining. The deeper mechanics of how each movement writes a ledger row are in the pillar guide's stock model section.
2. Item-wise and location-wise stock — what is on hand now
The question it answers: how much of this item do we have, and in which store?
This is the everyday workhorse: current on-hand quantity per item, broken down by store or storage location, with reserved quantity shown separately so you can see what is physically present versus what is available to promise. A good version filters by item group and store, and shows the unit of measure explicitly — many stock arguments turn out to be boxes-versus-pieces confusion. Stores staff use it all day; purchase before ordering; sales before committing delivery dates.
3. Stock valuation — what the inventory is worth
The question it answers: how much cash is sitting on our shelves, and where?
The valuation report prices on-hand stock — item-wise and store-wise — at cost price or at the lot rate captured at receipt. It is the bridge between the storeroom and the balance sheet: month-end accounts, insurance declarations, borrowing against stock and make-or-buy decisions all rest on it. Two disciplines keep it honest: cost prices maintained on the item master, and receipts always booked with a rate. Where books are kept in Tally, a Tally integration keeps physical stock control and financial valuation aligned without double entry.
Review it monthly as a minimum — and any time working capital is under discussion, because valuation is where carrying-cost reduction starts: you cannot shrink what you have not measured.
4. ABC analysis — where the value concentrates
The question it answers: which items deserve the most attention?
ABC analysis classifies items by their share of inventory value — a common split treats items contributing roughly 70% or more of value share as class A, 30–70% as class B and below 30% as class C. Because a small number of A items usually carry most of the money, the report converts a flat item list into a priority list: count A items more often, watch their reorder levels daily, negotiate hardest on their purchase prices — and give the long C tail lighter-touch control. ABC is also the standard way to set cycle-count frequency, which feeds directly into inventory accuracy.
Review it quarterly: value shares shift slowly, and reclassifying too often churns your counting and purchasing routines for no benefit.
5. Reorder-level alerts — what to buy before it runs out
The question it answers: what must be ordered today?
The reorder report flags every item at or below its minimum (reorder) level, using the min/max levels held on the item master, and a replenishment view adds lead time, minimum order quantity and order multiple so the buyer can act in one pass. This is a daily action list, not a monthly review — its whole value is catching the item the day it crosses the line, not three weeks later. The prerequisite is that minimum and maximum levels are actually set and periodically re-tuned; a reorder report over blank levels is silence, not safety. Setting levels item by item is one of the highest-return fixes in the common inventory mistakes list.
6. Non-moving and slow-moving stock — where cash is frozen
The question it answers: what have we stopped using, and what is it worth?
This report scans movement history over a window you choose — commonly 90, 180 or 365 days — and lists items with no issues, or very few, together with quantity and value. It is the report that finds dead stock before the year-end count does, and it drives four decisions: return to supplier, transfer to a store that uses the item, discount and clear, or write down. Reviewed weekly or monthly, it keeps the slow tail visible while it is still small enough to act on cheaply — which is why it is central to any carrying-cost programme.
7. The lot expiry dashboard — what expires when
The question it answers: which lots must move first, and which are about to become write-offs?
For batch-controlled and perishable stock, the expiry dashboard buckets available lots by expiry window — already expired, today, tomorrow, this week, this month, this quarter and beyond — so near-expiry stock is a dated action list rather than a surprise at stock-take. Paired with FEFO issue (expired lots excluded as a hard rule, nearest-expiry consumed first) it is the core control for pharma, food, chemical and dairy operations. Review it daily wherever shelf life matters; see Lot, Batch & Expiry (FEFO) for how the underlying lot statuses (available, hold, damage, closed) work.
8. Physical count variance — book versus counted
The question it answers: how accurate is our book stock, and where is it wrong?
The count variance report compares system quantity against physically counted quantity for every item or lot in a count — annual, quarterly or perpetual cycle count — and lists the differences. Two disciplines make it useful. First, the count records variance only: it never changes stock by itself; a separate, documented adjustment reconciles it, keeping the audit trail clean. Second, investigate variances by cause — a recurring variance on one item is a process leak, and the stock ledger (report #1) is where you find it. Tracked over time, this report becomes your accuracy metric — the curve described in how to improve inventory accuracy.
A review rhythm that actually sticks
Reports create value only when someone looks at them on a schedule. The table below is a practical rhythm for a single-site SME stockroom — tighten it as scale grows.
| Report | Question it answers | Rhythm | Who acts on it |
|---|---|---|---|
| Reorder-level alerts | What must be ordered today? | Daily | Purchase |
| Lot expiry dashboard | Which lots must move first? | Daily | Stores / QA |
| Item-wise stock | How much, and where? | All day | Stores / sales |
| Non-moving / slow-moving | Where is cash frozen? | Weekly–monthly | Stores + purchase |
| Stock valuation | What is stock worth? | Monthly | Accounts / management |
| ABC analysis | Which items deserve attention? | Quarterly | Purchase / management |
| Count variance | How accurate is book stock? | Every count | Stores + accounts |
| Stock ledger | How did this figure happen? | On demand | Anyone investigating |
Two habits make the rhythm stick: route each report to one named owner — a report everyone receives is a report nobody acts on — and end each review with a posting or a decision. A report that never changes a document is decoration.
Want to see these eight reports on your own items?
A 30-minute demo covers the ledger, valuation, ABC, reorder alerts, non-moving analysis and the expiry dashboard — live, from real movements.
How Fast Inventory Software delivers these reports
Every report in this guide ships as standard in Fast Inventory's reports and analytics, generated directly from the movement engine rather than assembled by hand:
- Stock ledger with opening, in, out, closing and running balance, plus transaction type and reference traceability on every row.
- Item-wise and location-wise stock from the live per-location balance, with reserved quantity shown separately.
- Valuation at cost price or lot rate, item- and store-wise; ABC analysis on the 70 / 30–70 / below-30 value-share split.
- Reorder and replenishment dashboards flagging items at or below minimum level, and non-moving / slow-moving analysis over any period.
- Lot expiry dashboard bucketing available lots by expiry window, and the physical stock taking variance report for every count.
Because counting, adjustment and reporting sit on one engine, the variance report, the adjustment documents and the ledger always reconcile — and where barcode capture is used at receipt, issue and count (see Barcode, RFID & Automation), the reports reflect reality with less typing in between. Pricing for the whole reporting layer is part of the standard product — see inventory software pricing.
Frequently asked questions
What are the essential inventory reports?
Eight reports cover almost every stock decision: the stock ledger (every movement with a running balance), item-wise and location-wise stock (current on-hand), stock valuation (what the inventory is worth), ABC analysis (which items carry the value), reorder-level alerts (what to buy before it stocks out), non-moving and slow-moving analysis (where cash is frozen), the lot expiry dashboard (what expires when) and the physical count variance report (book versus counted stock). Together they answer quantity, location, value, priority, replenishment, dead stock, shelf life and accuracy.
What is a stock ledger report?
The stock ledger is the movement history of an item in a store: opening balance, every receipt, issue, return, transfer and adjustment in sequence — each with its quantity, transaction type, reference number and rate — and the closing balance. Because every posting writes an immutable ledger row, the report lets you trace exactly how today's on-hand figure was reached, which is what auditors, accountants and anyone investigating a discrepancy actually need.
How often should each inventory report be reviewed?
A practical rhythm: reorder-level alerts and the lot expiry dashboard daily, because both are action lists; item-wise stock as needed through the day; non-moving and slow-moving analysis weekly or monthly for de-stocking decisions; valuation monthly for management and accounts; ABC analysis quarterly, since value shares shift slowly; the stock ledger on demand when investigating an item; and the count variance report at every physical count or cycle count.
What does a stock valuation report show?
A valuation report prices your on-hand stock — item-wise and store-wise — using cost price or the lot rate captured at receipt, so the business knows what its inventory is worth and where the cash is tied up. It is the bridge between the storeroom and the balance sheet: purchase decisions, insurance, borrowing against stock and month-end accounts all depend on a valuation figure grounded in real movements rather than an estimate.
Which report finds dead stock?
The non-moving and slow-moving report. It scans movement history over a period you choose and lists items with no issues — or very few — in that window, along with their quantity and value. That list is the starting point for de-stocking decisions: return to supplier, transfer to a location that uses the item, discount, or write down. Reviewed regularly, it stops dead stock from quietly accumulating into a year-end shock.