Reports and analytics

Stock variance, supplier performance, sales trends, and menu engineering.

Invinite surfaces insights from your daily transactions and stocktakes — without building spreadsheets. Analytics are available per team and roll up across outlets for group-level visibility.

Stock variance

The stock variance report shows the gap between theoretical and actual stock over a period. Filter by:

  • Date range
  • Category
  • Individual item
  • Team or outlet

Use this to answer: "Where are we losing stock?" and "Which categories have the worst variance?"

High-variance items deserve investigation before they hit your P&L.

Supplier performance

The supplier performance report tracks your purchasing activity:

  • Total spend by supplier over time
  • Price trends for key items
  • Delivery frequency

Compare spend year-over-year or between suppliers to negotiate better terms or switch primaries.

Sales trends

Sales trends show what sold and when — volume and revenue over daily, weekly, or monthly periods. Combine with costing data to see which periods drive margin and which drain it.

ABC analysis

ABC analysis classifies your inventory by value and movement:

  • A items — high value, high movement. Count frequently, manage tightly.
  • B items — moderate value or movement.
  • C items — low value, low movement. Count less often.

Focus your stocktake effort and variance investigation on A items first — they have the biggest financial impact.

Dead stock

Dead stock identifies items with little or no movement over a period. These tie up capital and shelf space. Review dead stock regularly to decide: promote, discount, transfer, or discontinue.

Inventory turnover

Turnover measures how quickly you sell through inventory. Low turnover on perishables is a waste risk. High turnover on spirits may mean you're under-ordering.

Turnover benchmarks vary by category — spirits turn slower than fresh produce. Compare within category, not across.

Product engineering (menu engineering)

If you sell finished products (cocktails, dishes) linked to recipes, product engineering classifies each menu item into four quadrants based on real COGS and sales volume:

Quadrant Margin Popularity Action
Stars High High Promote, protect recipe
Plowhorses Low High Raise price or reduce portion cost
Puzzles High Low Promote harder or reposition
Dogs Low Low Remove or rethink

Unlike systems that use fixed reference costs, Invinite calculates margin from actual purchase prices via your GRN history — so the matrix reflects reality, not guesses.

Costing method reminder

All cost-based analytics respect your organization's costing method:

  • FIFO — oldest inventory consumed first (default)
  • LIFO — newest inventory consumed first
  • Weighted Average — perpetual average of all receipts

Costs are calculated on-demand, not frozen at transaction time. If you correct an old GRN, downstream costs update automatically.

Putting it together

A practical review rhythm for a bar manager:

  1. Weekly — check stock variance for top 10 items by value
  2. Monthly — review supplier spend and dead stock
  3. Quarterly — run product engineering on the full menu; adjust pricing and recipes

Invinite gives you the numbers. What you do with them is where margin lives.

Was this page helpful?

Thanks for your feedback.