A useful inventory dashboard template should answer “Which item needs attention, and why?” before it shows an attractive total. Keep the date, location, and units attached to the answer.
Start with a dated item snapshot
Use one row per item and location. Include the item ID, description, counting unit, on-hand quantity, reserved quantity, threshold, count date, and source-row reference. If two locations hold the same item, preserve both location IDs instead of collapsing them into an unexplained total.
For this small-stockroom example, available = on-hand − reserved. This is a stated local convention, not a substitute for the definitions in your inventory system. Other adjustments, inbound stock, and reservation rules may require a different measure. Use the definitions your coordinator actually supplies.
A school supply-room example
Fictional example: all items and counts below are original demonstration data. Snapshot: October 13, 2026, supply room A. The comparison rule is available strictly below the supplied threshold. Equality does not enter the below-threshold queue.
| Item ID | Item and unit | On hand | Reserved | Available | Threshold | Review state |
|---|---|---|---|---|---|---|
| G01 | Glue sticks, individual sticks | 18 | 12 | 6 | 10 | Below threshold |
| P02 | Paper, unopened reams | 9 | 2 | 7 | 5 | Above threshold |
| M03 | Markers, complete sets | 5 | 2 | 3 | 4 | Below threshold |
| T04 | Tape, rolls | 4 | 0 | 4 | 4 | At threshold |
| S05 | Scissors, pairs | Unknown | 1 | Unknown | 6 | Count needed |
The below-threshold filter has two rows: G01 and M03. It does not include T04, which equals its threshold, or S05, which cannot be compared yet. Keep S05 in a separate missing count queue. Treating an unknown as zero would make a data gap look like a confirmed shortage.
Stock bars can make the comparison easier to scan, but label the values beside them. Six glue sticks and three marker sets have different units; adding them into “nine items available” would conceal that difference. An item-level queue is more useful here than a grand quantity total.
Turn the exception into a next action
For G01, ask the coordinator to verify the count and reservation before proposing replenishment. For M03, verify that the recorded unit really means a complete set. A partial set should not silently become one usable set.
Keep the exception detail specific:
G01, source row 1: 18 on hand minus 12 reserved gives 6 available. Threshold 10; shortfall to that threshold is 4 sticks. Action: verify count and reservation, then decide replenishment under the stockroom's procedure. Supplier lead time and order quantity have not been supplied.
The shortfall is arithmetic, not an automatic purchase recommendation. Minimum order quantities or upcoming demand could change what is ordered. Leave those fields blank until the responsible person provides them.
Copy this prompt with your stock rows
Prepare an inventory dashboard review in US English.
Snapshot date and location: [enter]
Source inventory sheet/system: [enter]
Rows with item ID, location, unit, on-hand, reserved, threshold, count date:
[paste approved rows]
Available-quantity definition: [enter the actual rule]
Threshold comparison rule: [below / at-or-below / supplied custom rule]
Known replenishment constraints: [paste or NOT SUPPLIED]
Return a dated item table and an exception queue. Preserve IDs, locations,
units, and source-row references. Show the arithmetic for derived quantities.
Keep missing stock UNKNOWN, not zero. Flag inconsistent units, duplicate
item-location rows, negative inputs, and reservations exceeding on-hand;
do not silently correct them. Reconcile the filtered count to source rows.
Separate below-threshold items from rows awaiting a count. Do not invent
thresholds, supplier lead times, purchases, or confirmed shortages.
If requested, provide an HTML snapshot with labeled item bars, threshold
markers, and a local exception filter. Keep the snapshot date and comparison
rule visible. Do not add live inventory sync, saved stock movements, or
automatic orders. The maintained inventory record remains authoritative.
Before using the queue, check its date and source against the maintained inventory record. Give the coordinator the two confirmed comparison exceptions and the separate missing-count request. Update actual counts and replenishment decisions in the inventory sheet or warehouse system.
Optional: inspect a stock-review snapshot in NOS
An HTML snapshot can be saved and displayed in NOS when the coordinator needs to read an item, reservation, and threshold together. Use that copy to discuss the exception; record subsequent stock movements and orders in the maintained inventory system.