Inventory dashboard: metrics, layout, and data checks

An inventory dashboard should connect stock value, availability, and service exceptions to the SKU and site rows that explain them. Start with a reconciled snapshot and a clearly defined demand period, then build a layout around the decisions users need to make. A chart is useful only when its totals and timing can be checked.

Begin with the audience and the cutoff

Purchasing needs to know where usable stock is insufficient and whether an incoming receipt changes the decision. Operations needs unexplained balances and service failures. Finance needs inventory value and slow-stock exposure. Put the shared totals at the top, then give each audience a short exception list.

Show the inventory cutoff, demand window, source extract time, currency, and selected sites. Distinguish a stock measure taken at a moment from a flow measured over a period. For example, today's closing inventory and this month's fulfilled demand can share a page without pretending they describe the same time interval.

Use the inventory reporting framework for the supporting report pack. This guide focuses on choosing the dashboard's measures, arranging them, and proving that they still agree after filtering.

Prepare one controlled SKU and site table

Start from a closing stock export with quantity, unit cost, allocations, status, and site. Join the period's requested and fulfilled quantities on stable SKU and site identifiers. Add days since last issue only if the movement records support it. Keep missing demand records distinct from confirmed zero demand.

The worked example is a US distributor's October 23, 2026 snapshot. Requested and fulfilled units relate to the same orders due from October 1 through October 23. Fulfilled quantities are the units supplied against that cohort by the cutoff; unrelated backlog shipments are excluded.

Enter these inputs in A1:H5. Requested demand is confirmed zero for C at West.

The snapshot values are operational inputs, not a substitute for finance's valuation policy. Before publication, reconcile stock quantities to their controlled source report and inventory value to the valuation export. Retain approved scope differences rather than hiding them in the dashboard.

Calculate the measures before designing charts

Use I for inventory value, J for available units, K for a current shortage-review flag, L for fill rate, and M for dormant value. Enter these formulas in row 2 and fill through row 5:

=C2*D2
=C2-E2
=IF(AND(J2<=0,G2>0),1,0)
=IF(G2=0,NA(),F2/G2)
=IF(H2>=180,I2,0)

Here the shortage-review rule means available units are nonpositive and the SKU/site had demand during the defined period. It is an illustrative review rule, not proof that every requested unit was lost. In a live review, add forward commitments and confirmed receipts before deciding whether to expedite.

The total fill rate is 220 fulfilled / 235 requested = 93.6%, rounded to one decimal place. Calculate it from totals rather than averaging row percentages:

=SUM(F2:F5)/SUM(G2:G5)

The shortage-review share is one flagged SKU/site out of four, or 25.0%. Dormant value is 1,500 / 3,300 = 45.5% of total value. These are different denominators: key count and inventory dollars. State each denominator beside its card.

Days since issue is a dormancy indicator rather than the age of every remaining unit. Link the detail view to an inventory aging explanation so readers understand what a recent small issue can conceal. If adding turnover, use the established inventory turnover calculation rather than inventing a dashboard-specific version.

Arrange the dashboard around decisions

For site value, Microsoft's SUMIFS function sums records matching specified criteria. The East card uses:

=SUMIFS(I2:I5,B2:B5,"East")

East's $1,200 plus West's $2,100 must equal $3,300. Selecting a site should change the applicable numerator and denominator together. A filtered table beside an unfiltered headline is a reporting error even if both cells are individually correct.

Use color for explicit exceptions. Microsoft's conditional formatting documentation describes value-based rules; apply a rule to the review flag and show its meaning in text. Keep missing inputs visible instead of coloring them as satisfactory.

For a dedicated workbook layout, see the inventory KPI dashboard in Excel; the Power BI inventory dashboard guide covers that separate build. Covirage is not affiliated with Microsoft.

Where it goes wrong

• Mixing snapshots and transactions. Summing daily inventory balances across a month does not give closing inventory.
• Averaging service percentages. Calculate total fulfilled units divided by total matched requested units; exclude neither weak rows nor valid zero-fulfillment demand.
• Calling no demand perfect service. C at West has no applicable fill rate, rather than a perfect score.
• Treating allocations as physical issues. Allocations reduce available stock here, but do not reduce the on-hand balance until the relevant movement occurs.
• Hiding record failures with color. A missing cost, stale extract, or unreconciled balance requires a visible exception and an owner.

Check your inventory dashboard figures in Covirage

Bring dated stock, allocation, and matched-demand exports. Covirage maps the columns, and its tools compute and check the underlying figures; the external AI model explains the result with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.

See Covirage for supply chain teams for the decisions those comparisons support.