Skip to main content

How to use the Profitability dashboard

Trace every baht of revenue through five margin layers — recipe cost, options, discounts, commission, and waste.

Written by Kate Khunvirojpanich
Updated yesterday

What is the Profitability dashboard?

Profitability shows you exactly where margin is being lost between the menu price and the money that actually ends up in your pocket. It traces every baht of revenue through five layers — recipe cost, options, discounts, delivery commission, and waste — so you can see which layer is eroding profit the most and where to act.

Why it matters

Most operators track one margin number — usually food cost percentage — and miss everything else. By the time revenue becomes profit, it has been chipped away by modifier discounts, promo codes, delivery platform fees, and unrecorded loss. Profitability breaks all of that apart so you know which one is actually killing you.


The 5-layer margin model

Every layer subtracts one more cost from the previous one. Margin falls at each step. The size of the drop tells you which cost is biggest.

Layer

What's subtracted

1. Gross Margin

Base menu revenue minus recipe ingredient cost (COGS).

2. Margin After Options

Adds option/modifier revenue and subtracts option ingredient cost. Reveals whether your add-ons are profitable.

3. Margin After Discounts

Subtracts item-level and order-level discounts. Order-level discounts are attributed to each item proportional to its share of the bill.

4. Margin After Commission

Subtracts delivery platform commission (Grab, LINE MAN, etc.). Applies only to partner channels — dine-in and takeaway are unaffected.

5. Margin After Waste

Subtracts recorded inventory waste. This is the bottom line — what actually remains.

The dashboard is split into three tabs — Overview, Drivers, and Item Drilldown — each answering a different question.


Tab 1: Overview

The top-level view. Shows margin and profit at each of the five layers as headline numbers, with a Margin Waterfall chart visualising the drop-off from gross to net, and a weekly trend line underneath.

The two rows of KPIs

  • Top row — margins as percentages: Gross Margin → Margin After Options → Margin After Discounts → Margin After Commission → Margin After Waste.

  • Bottom row — the same layers in baht: Gross Profit → Profit After Options → Profit After Discounts → Profit After Commission → Profit After Waste.

The percentage row shows efficiency ("how much of each baht do we keep?"). The baht row shows scale ("how much total money is left at each stage?"). Both matter.

Margin Waterfall

A visual walk-through of the 5 layers. Starts with gross revenue on the left, subtracts each cost bar-by-bar moving right, and ends with net profit. The size of each red bar tells you which cost layer is hurting you most.

Margin Over Time

Weekly margin percentage at each of the five layers. Watch for trends:

  • Widening gap between Gross Margin and Margin After Discounts — promos or discounts are growing.

  • Widening gap between Margin After Discounts and Margin After Commission — delivery mix is shifting toward higher-commission platforms.

  • Sudden drop in Gross Margin — a supplier price increase, a recipe change, or waste finally being logged properly.

Profitability by Channel Type

A table showing margin at each layer, broken down by channel. Partner channels expand to show each platform individually (Grab, LINE MAN, etc.) with their specific commission impact. Comparing dine-in vs. delivery margins here often surfaces the biggest profit leak — delivery frequently runs 15–25 percentage points lower once commission lands.

Recipe Coverage (on Overview)

The share of sold items with complete recipes. Every metric above only reflects items with recipes — low coverage means the numbers understate true costs. Keep this above 80% to trust the figures.


Tab 2: Drivers

Answers "which items, categories, and menus are making the money, and which are dragging it down?" Use this when the Overview shows a problem and you need to find which products to act on.

Profit Pareto

Top 100 menu items ranked by net profit (bars) with a cumulative % line. Shows the 80/20 of your profit — usually a small number of items drive most of the absolute profit. Where the line crosses 80% tells you how concentrated your profit is: 10 items to 80% means very concentrated (fragile); 50 items to 80% means broadly distributed (resilient).

Profit Efficiency

Scatter plot of every menu item:

  • X-axis = net margin % (how profitable per baht of revenue)

  • Y-axis = net profit in baht (how much total profit)

Items in the top-right are efficient and high-volume — your profit engine. Items in the bottom-left are low-margin AND low-volume — candidates to cut. Items high on the Y but low on X are volume dependencies (a lot of sales, thin margins); high on X but low on Y are niche winners (great margin, low reach).

Net Profit by Category

Waterfall by menu category. Each bar is one category's net profit contribution — positive bars add, negative bars subtract, and the final bar is total. Immediately shows whether any category is losing money once all costs are counted.

Net Profit by Menu

Same waterfall, but split by parent menu (e.g. Food, Alcohol, Non-Alcohol). Useful for multi-menu setups — tells you whether your bar menu is really profitable or whether it's being subsidised by the kitchen.


Tab 3: Item Drilldown

Zoom into a single menu item's profitability story. Use this when the Drivers tab flagged an item you want to understand or fix.

Menu Item Profitability (summary table)

One row per menu item: revenue, COGS, discounts, commission, net profit, and margins at each layer. Last 30 days. Click any row to filter the rest of the tab to that item.

Menu Item Profitability by Channel

Below the summary table, the same item broken down by channel. Shows which channels make you money on a given dish and which lose you money. It's common for a Star dish to be highly profitable dine-in and unprofitable on a delivery platform once commission is subtracted.

Margin Waterfall (Per Unit)

For the selected item — the 5-layer waterfall, but averaged per unit sold. Shows exactly how much margin you lose per order of that dish at each step.

Margin Waterfall (Total)

Same breakdown, but total across all units. Shows the magnitude of each erosion layer for that dish in the period.

Margin Over Time (By Item)

The selected item's margin trend over weeks, at each of the 5 layers. Surfaces whether a specific dish's profitability is stable or eroding.


How it's calculated

💡 Gross Margin = (base revenue − recipe COGS) ÷ base revenue

💡Margin After Options = (base revenue + option revenue − recipe COGS − option COGS) ÷ (base revenue + option revenue)

💡Margin After Discounts = profit after options − all discounts

💡Margin After Commission = above − delivery platform fees

💡Margin After Waste = above − recorded inventory waste

Order-level discounts (e.g. 10% off the whole bill) are attributed to each item proportional to its share of the subtotal, so each item takes its fair hit.

Worked example

Pad Thai ordered via LINE MAN with a 20% promo and an extra-protein modifier:

  • Base price: ฿180 — recipe cost ฿54. Gross Margin = 70%

  • Extra protein option: +฿40 revenue, +฿15 cost. Combined: revenue ฿220, cost ฿69 → Margin After Options = 68.6%

  • 20% order discount (pro-rata): −฿44. Net revenue ฿176, cost ฿69 → Margin After Discounts = 60.8%

  • LINE MAN commission 30% of gross: −฿66. Net revenue after fee ฿110 → Margin After Commission = 37.3%

  • Attributed waste cost ฿5 → Margin After Waste = 34.5%

The order that looked like a 70% margin dish on the menu actually delivers 34.5% — less than half.


Action Steps

  • Start with the Overview Waterfall. The biggest bar is your biggest fix. If Commission dominates, the problem is channel mix. If Discounts dominate, it's promo strategy. If Waste dominates, it's operations.

  • Compare dine-in vs. delivery margins in Profitability by Channel Type. If delivery runs more than 20 points lower after commission, consider raising delivery prices to compensate.

  • Use Drivers → Profit Pareto to identify your top 20 items. Protect them; make sure their ingredients are always in stock.

  • Look at Drivers → Net Profit by Category for negative bars. Any category with negative net profit is being subsidised by the rest of the menu.

  • In Item Drilldown, click the worst-margin high-volume item first. That's your biggest profit unlock per change.

  • Review monthly. Profitability trends monthly; weekly is too noisy. Month-over-month changes in Margin After Waste are the headline KPI.


Frequently asked questions

Why does my Gross Margin look higher here than in the COGS dashboard?

COGS uses actual food cost (what you bought) as the numerator, while Profitability uses theoretical recipe cost. The gap between the two is unaccounted loss — waste, over-portioning, shrinkage. If you want the full picture, look at both dashboards together.

My delivery margins look terrible. Is commission really that high?

Yes. Platform commissions run 25–35% of gross on most Thai delivery partners. If your base Gross Margin is 65%, a 30% commission drops you to about 35% on those orders — before any waste or discounts. Many operators list higher prices on delivery to offset.

Why is Margin After Waste barely different from Margin After Commission?

Only logged waste is subtracted at this step. If your team isn't logging waste in the system, this layer will understate the real loss. Check the Waste dashboard for Waste % of Revenue — if it's well above industry norms, something is being missed.

What's a good Margin After Waste target?

Full-service restaurants typically aim for 15–25%. QSR runs tighter (8–15%). A single-digit figure usually signals a real problem — often delivery mix or discount creep.

Why do some items show negative Profit After Commission?

Those items genuinely lose money on delivery. Either the price is too low for the delivery channel, the recipe cost is too high, or the commission rate is punishing. Consider delivery-specific pricing or removing the item from delivery menus.

How is the order-level discount attributed?

Proportionally. A 10% off ฿500 order with one ฿300 item and one ฿200 item would attribute a ฿30 discount to the first item and ฿20 to the second. Each item takes its proportional share.

Did this answer your question?