A useful procurement dashboard for a small business turns an exception into a decision: what needs ordering, which supplier commitment needs follow-up, and what finance needs before reviewing a bill. Start with the decisions and source records, then choose the measures.
This guide explains how to organize a weekly review and assign follow-up. For definitions and worked arithmetic, use the companion procurement KPI calculation guide. For supplier-specific measurement, use the supplier scorecard.
Organize the dashboard around three decisions
Review area
Decision
Useful evidence
Inventory availability
Buy, transfer, expedite or wait?
Usable stock, commitments, expected demand, incoming quantities and dates
Supplier execution
Follow up, accept a change or qualify an alternative?
Original promise, accepted revision, supplier reply and actual receipt
Purchase and cash exposure
Resolve a price, quantity or funding exception?
Agreed prices, invoice lines, receipts, terms and finance’s cash schedule
These are a starting point for a physical-goods buying team. Approval compliance, contract coverage and other measures can also matter to a small business. Add them when they support a decision someone owns.
1. Inventory availability: start with dated gaps
Show the item and location, usable on-hand quantity, committed demand, expected consumption and confirmed incoming deliveries. A simple coverage estimate is usable on-hand units divided by expected daily use, but a dated projection is more useful when receipts, demand or spoilage vary.
Illustrative exception: 60 usable units at 10 units per day provide six days of nominal cover. A supplier normally takes eight days, but 40 confirmed units are due tomorrow. The six-day figure alone does not establish that another order is immediately required. Check that the inbound stock is usable, not allocated elsewhere, and sufficient for the next review and delivery cycle.
Prioritize shortage consequences, not only ABC class. A low-spend packaging item or critical spare can stop operations. For intermittent or new products, disclose the planning assumption instead of showing an apparently precise coverage number from inadequate history.
Useful supporting measures include:
Stockout incidence: active SKUs with a zero-on-hand event divided by the defined active assortment for the period. This is not the percentage of demand units unfilled.
Inventory turns: period COGS divided by average inventory at cost. Low turns may reflect seasonal stock or critical spares as well as excess buying.
Aging and loss: show affected stock and its disposition, keeping an estimated planning loss separate from a recorded adjustment or an actual use-by limit.
2. Supplier execution: keep promises and receipts separate
Show the original requested quantity and date, supplier confirmation, accepted changes, first receipt and completion. This preserves both what the business initially needed and what the supplier subsequently agreed to provide.
Use fill rate, OTIF and delivery-window performance together. Define each cutoff and denominator. For OTIF, count orders due in the measurement period so undelivered overdue orders do not disappear from the result.
A supplier can ultimately deliver all units and still leave the business short on the required date. Conversely, a buyer-requested postponement should not automatically be recorded as supplier failure. Keep the change and its owner visible.
Do not convert the percentage of late or incomplete orders directly into a safety-stock adjustment. Investigate actual delays, shortage quantities, demand, alternatives and current supplier capacity before changing the inventory policy.
3. Purchase and cash exposure: compare matched records
Keep price exceptions separate from receipt-quantity exceptions. For an invoice comparison, use the same item, pack, currency, cost scope and comparable invoiced quantity on both sides.
Here a positive result is unfavorable. If 80 units are invoiced at $5.20 against an accepted $5 price, the variance is $16 unfavorable. If only 70 units have arrived, investigate the ten-unit receipt difference separately; do not multiply the price variance by whichever quantity happens to be easiest to retrieve.
Also preserve the original planned price. An invoice can match a supplier change the buyer accepted while still exceeding the original plan. An unfavorable variance may reflect an agreed specification or freight change, a conversion issue or an error; it is not proof of misconduct.
For cash exposure, show due dates and commitments alongside finance’s payment schedule. Cash conversion cycle, GMROI and inventory turns provide broader context when their financial inputs are ready. They are not substitutes for knowing which bills fall due next week.
Make every dashboard number inspectable
Record a definition, source, cutoff, owner and last refresh for each measure. Distinguish missing data from a zero value. A polished aggregate is not reliable if half the receipts remain unrecorded.
Before adopting a report, trace a small sample back to source records. Include a partial receipt, a revised delivery date, a price change and an unresolved invoice. A sample can reveal errors; it does not certify every record in the report.
Check
What it prevents
Stable item and pack mapping
Comparing a six-pack price with a twelve-pack price
Original and accepted commitments
Erasing delays by overwriting promised dates
Due orders in the denominator
Excluding orders that have not arrived
Consistent financial periods
Comparing monthly gross profit with annual inventory assumptions
Visible missing matches
Treating unmatched invoices as validated purchases
Finance should approve the valuation and financial definitions. The buyer and receiver should agree the operational events and exception ownership.
Run the weekly review with an action register
Use a short standing review, then expand it when the exceptions warrant more time:
Identify uncovered requirements. Review critical items and dated gaps, including suitable incoming stock and transfer options.
Resolve changed commitments. Follow up on missing confirmations, late balances and proposed substitutions before the relevant deadline.
Review commercial exceptions. Compare accepted terms, receipt evidence and invoice lines; assign the buyer, supplier or finance reviewer who can resolve each difference.
Check purchase timing. Bring upcoming commitments and payment dates to the cash owner before authorizing additional purchases.
Close the loop. Record the action, owner, due date and evidence needed to mark it resolved. Revisit previous actions before adding new ones.
A missed target starts an investigation. It should not automatically authorize a purchase, change a buffer or trigger a supplier switch.
Evaluate LineNow with these exceptions
LineNow’s procurement workflow connects purchase orders, supplier replies, receiving and accounting handoff through a living purchase order. Bring the exception cases above to a demonstration and inspect the report or export used to retrieve them. Confirm which fields, calculations and review permissions are available in the proposed setup.
Financial close, cash scheduling and any specialized dashboard requirements need explicit data owners and an agreed handoff.
