M cenaly.ru
⚙️ Features

📊 Analytics

Sales, ABC analysis, KPI, P&L, margins

Documentation

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

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
WhatsApp Orders, conversion
Telegram Orders, new users

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

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#

  1. Check the dashboard daily — spot trends and anomalies
  2. Use ABC analysis once a month — update the menu based on data
  3. Compare periods — to see growth or decline
  4. Export to Excel — for detailed analysis and reporting
  5. Track staff KPIs — for motivation and training

8. Inventory Management and Cost of Goods#

Ingredient tracking#

  1. InventoryIngredients → add all products with purchase price
  2. Link ingredients to menu items (recipe cards)
  3. 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#

  1. AnalyticsReport schedule
  2. Choose: daily, weekly, monthly
  3. Specify recipients (email)
  4. 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