Analytics and Reports
Overview#
The analytics section provides a complete picture of your venue's performance — from dish popularity to staff efficiency. All data is available in real time and can be exported to Excel/CSV.
Dashboard#
The main analytics page displays key metrics:
- Revenue — total amount for the period (day/week/month)
- Number of orders — total count and trend
- Average check — average order amount
- Popular items — TOP 10 most ordered
- Menu views — how many times guests opened the QR menu
Sales Reports#
General report#
- Revenue by days, weeks, months
- Trend charts
- Comparison with previous periods
- Filtering by categories, items, order channels
Menu ABC analysis#
Classification of items by profitability and popularity:
| Group | Description | Action |
|---|---|---|
| A — Stars | High profit + high popularity | Promote, keep in a prominent place |
| B — Workhorses | Average profit, stable demand | Optimize margin |
| C — Outsiders | Low profit and/or low demand | Update or remove from the menu |
Profitability report (COGS)#
- Cost of goods for each item
- Margin in % and absolute numbers
- Food cost by categories
- Optimization recommendations
Staff KPIs#
Waiter metrics#
- Number of tables served
- Average check per waiter
- Average service time
- Total tips received
- Number of upsells (additional sales)
Kitchen metrics#
- Average order preparation time
- Number of orders processed
- Returns and complaints
- Hourly workload
Channel Report#
Comparison of order channel effectiveness:
| Channel | Metrics |
|---|---|
| Dine-in | Orders, average check, service time |
| Delivery | Orders, average delivery time, zones |
| Takeaway | Orders, average check |
| Orders, conversion | |
| Telegram | Orders, new users |
Menu Analytics#
Item popularity#
- TOP most viewed items
- TOP most ordered
- Items that are viewed but not ordered (possibly the price is too high)
Heatmap#
- What categories are popular at what time of day
- Peak order hours
- Seasonal trends
Menu engineering#
A dedicated tab in menu statistics lays dishes out on the Kasavana & Smith matrix (stars, plowhorses, puzzles, dogs) and gives a recommendation for each: keep it featured, raise the price, move it up the menu, or take it off. The same tab shows margin by channel with aggregator commissions taken into account.
Details — Menu engineering.
Financial Reports#
P&L (Profit and Loss)#
- Revenue
- Cost of goods sold (COGS)
- Gross profit
- Operating expenses
- Net profit
Cash Flow#
- Cash inflows by day
- Breakdown by payment methods
- Ending balances for the period
Data Export#
All reports are available for download:
- Excel (.xlsx) — for analysis in Excel / Google Sheets
- CSV — for import into accounting systems
- PDF — for printing and reporting
Accounting Integration#
Analytics data can be automatically transferred to:
- 1C (Russia)
- iiko (CIS)
- MoySklad (Russia)
- Other systems via API / Webhooks
Tips for Working with Analytics#
- Check the dashboard daily — spot trends and anomalies
- Use ABC analysis once a month — update the menu based on data
- Compare periods — to see growth or decline
- Export to Excel — for detailed analysis and reporting
- Track staff KPIs — for motivation and training
8. Inventory Management and Cost of Goods#
Ingredient tracking#
- Inventory → Ingredients → add all products with purchase price
- Link ingredients to menu items (recipe cards)
- The system will automatically calculate the cost of each dish
Recipe card (recipe)#
For each dish, specify:
- List of ingredients with exact weight (grams / ml)
- Processing loss percentage (shrinkage, boil-down)
- Finished dish yield
Food cost calculation#
| Metric | Formula | Benchmark |
|---|---|---|
| Food cost % | Cost ÷ Selling price × 100% | 25–35% |
| Markup | Selling price ÷ Cost | 2.5–4x |
| Margin | (Price - Cost) ÷ Price × 100% | 65–75% |
Stock control#
- Auto write-off: when an order is closed, ingredients are written off automatically
- Low stock: push notification when the minimum is reached
- Stocktaking: reconcile actual stock with system stock
- Discrepancy report: actual/system deviations to control theft
Purchasing#
- The system suggests a purchase list based on the sales forecast
- Auto-order from suppliers when minimum stock is reached
- Purchase history with prices to track inflation
9. Demand forecast#
The forecast lives in Inventory, on the "Forecast" tab, and is computed from sales history with no AI at all — from two explainable statistics: the median sales of a dish on this weekday over 8 weeks, and how that demand is spread across dayparts.
What comes out of it:
- a prep plan for the shift — with recipes exploded (including nested semi-finished items) and a "be ready by" hour;
- a supplier order draft for a chosen coverage horizon;
- a "runs out around 19:00" risk corrected for today's pace.
Details, including the limits, — Demand forecast.
10. Automated Reports#
Mailing setup#
- Analytics → Report schedule
- Choose: daily, weekly, monthly
- Specify recipients (email)
- Select report sections
Auto-report contents#
- Revenue and average check
- TOP 10 items
- Comparison with the previous period
- Stop list for the period
- Staff KPIs