Step 8.0
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:
- Weekly — check stock variance for top 10 items by value
- Monthly — review supplier spend and dead stock
- 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.