Overview
Estackly provides two complementary reporting tools:
- Analytics (Restaurant → Analytics) — visual, trend-focused dashboards for spotting patterns: revenue vs expenses over time, peak hours, best and worst sellers, customer behaviour.
- Reports (Restaurant → Reports) — detailed tabular breakdowns for shift-end reconciliation and management review: daily sales, item performance, payment methods, staff performance, financial totals.
Both cover only paid orders unless otherwise noted. Use them together: Analytics for strategic insight, Reports for day-to-day operational data.
Analytics
Go to Restaurant → Analytics. Default range is the last 30 days. Use the date pickers to select any custom range.
KPI Cards
Six headline numbers at the top, each showing the current period value and a percentage change vs the equal-length period immediately before it:
| KPI | What it measures |
|---|---|
| Total Revenue | Sum of all paid order totals in the period. |
| Total Orders | Count of all orders (any status) in the period. |
| Avg Order Value | Total revenue ÷ paid order count. |
| New Customers | Customers whose very first order falls within this period. |
| Total Expenses | Sum of all expense entries dated within the period. |
| Net Profit | Total Revenue − Total Expenses. |
An arrow indicates direction vs the previous period: green ↑ for improvement, red ↓ for decline. A dash appears when the previous period had zero (no meaningful comparison).
Revenue Trend Chart
A daily line chart showing three series side-by-side: Current Period Revenue, Previous Period Revenue (shifted to align day-for-day), and Expenses. Use this to see if revenue is trending up or down compared to the prior period, and how expenses track against it.
Customer Insights
- New vs Returning — a donut chart showing how many unique customers ordered for the first time vs how many were returning visitors.
- Top 5 Customers by Spend — a ranked table of your highest-value customers in the selected period, with order count and total spend.
Menu Insights
- Best Sellers — top 5 menu items by quantity sold.
- Worst Sellers — bottom 5 menu items by quantity sold. Use this to identify items to promote, reprice, or remove from the menu.
Peak Hours Heatmap
A 7 × 24 grid (days of week × hours of day) colour-coded by order volume. Darker cells = more orders. Instantly reveals your busiest times for staffing and prep planning.
Area / Section Performance
Revenue and order count broken down by dining area (Indoor, Outdoor, Terrace, etc.) or "Unassigned" for orders not linked to a table. Helps identify which sections drive the most revenue.
Reports
Go to Restaurant → Reports.
Filters
| Filter | Options |
|---|---|
| Date Range | Today, Yesterday, Last 7 Days, Last 30 Days, This Month, Custom (pick start/end date and time) |
| Order Type | All, Dine-in, Takeaway, Delivery — narrows all report sections to that order type only |
Key Metrics Bar
Three headline numbers for the filtered period: Total Revenue, Total Orders, Avg Order Value.
Daily Sales Breakdown
A table showing each day in the range with: date, number of orders, total revenue, and average order value. Sorted newest first. Use this for daily reconciliation.
Item Performance
Top 50 menu items by quantity sold, with units sold and total revenue per item. Use this to see which dishes generate the most income vs just the most volume (they are often different items).
Category Performance
Revenue per menu category. Identifies which sections of your menu (Starters, Mains, Beverages, Desserts) contribute most to revenue.
Hourly Breakdown
Order count and revenue per hour of the day (0–23). Different from the Analytics heatmap — this is a single flat table for the entire selected period, useful for scheduling staff and kitchen capacity.
Order Type Breakdown
Split of order count and revenue between Dine-in, Takeaway, and Delivery. Useful for understanding channel mix and deciding where to invest (e.g. if delivery is small, whether it is worth the commission costs).
Staff / Waiter Performance
Per-staff breakdown for the period:
- Number of orders handled
- Total sales value
- Average ticket size
- Average service time (minutes from order creation to completion)
Sorted by total sales. Staff members with no assigned orders appear at the bottom. Use this during performance reviews.
Payment Method Breakdown
Revenue split by payment method: Cash, Card, UPI, Bank Transfer, and online gateway (Razorpay etc.). Helps with cash-vs-digital reconciliation and understanding customer payment preferences.
Financial Breakdown
Totals for: Service Charge, Delivery Charge, Taxes collected, and Discounts given. Use alongside the daily sales data for GST filing and financial reporting.
Outstanding Payments
Total value of orders in Pending or Confirmed status within the selected period. These are orders that have not yet been paid. Monitor this at shift end to ensure no open orders are accidentally left unpaid.
Print Report
Click Print Report at the top of the Reports page to open a clean, print-optimised version of the current report with all sections formatted for A4 paper. Staff can print end-of-day reports without the admin UI chrome.
Consolidated Report (Multi-Restaurant)
If your account manages more than one restaurant, go to Restaurant → Reports → Consolidated Report. This shows:
- Per-branch revenue, orders, average order value, and top-selling item side by side.
- Grand totals across all branches.
- Daily revenue trend per branch on a single chart.
- Top 15 items across all branches combined (by quantity sold, with outlet count).
Same date range presets as the standard report. Use this to compare branch performance and spot your best and weakest outlets at a glance.
Frequently Asked Questions
Why do Analytics and Reports sometimes show different revenue numbers?
Analytics defaults to the last 30 days; Reports defaults to this month. Set both to the exact same date range to compare. Also confirm both are using the same order type filter.
Does the data update in real time?
Yes. Both Analytics and Reports query live data each time you load or filter the page. There is no caching delay.
Can I export the report to Excel or CSV?
Use the Print Report function and save as PDF, or copy the table data from the browser. A dedicated CSV export is not currently available in the UI.
Why does staff performance show some orders under "no staff"?
Orders placed through the QR menu, kiosk, or customer portal are not assigned to a waiter. Only orders created in the POS with a waiter selected appear under a staff member in the performance table.
The net profit looks wrong — expenses are not showing up.
Check that expenses are logged with a date that falls within the Analytics date range. Expenses use the date field you enter manually, not the created-at timestamp. A bill from last month logged today with yesterday's date appears in yesterday's range, not today's.