Why a restaurant should know its commission to the penny
Ordering dinner through a delivery app feels like a gift to a small restaurant: the app brings the guests, the rider and the payment. Then the monthly statement arrives and the owner sees how much of each order was kept. A fee of 25 or 30 per cent of every order is the kind of number that can appear in such contracts, though it differs by market, plan and negotiation, while an order that comes through the restaurant's own website or by phone carries only a small card-payment fee. The difference between those two numbers is the starting point of digital marketing for restaurants and cafés.
This free lesson shows you how to measure it in a spreadsheet. You will take twelve orders, look up the fee rate of each channel, calculate the fee and the net revenue of every order and then add up the net revenue per channel. The same few steps are the foundation of the whole course: later lessons add food cost, packaging, couriers, bookings, reviews and offers on top of them.
The example company is Saltmeadow Kitchen, a fictional restaurant group with a restaurant called the Table and a small café. All names, orders, fee rates and numbers in this article and in the course are invented for learning. Platform fees and plans change often and differ from country to country, so read every rate here as illustrative and check the contract of your own platform.
The core concept: order value, fee and net revenue
Three numbers describe an order. The order value is what the guest pays for the food and drinks, before any delivery fee that goes to a rider. The fee rate is the percentage that the channel takes: a commission for a delivery app, a card-payment fee for your own website or phone line. The fee in pounds is the order value multiplied by the fee rate. What the restaurant keeps is the net revenue: order value minus fee.
Fee £ = order value × fee rateNet revenue £ = order value − fee
Net revenue is not profit. The kitchen still has to pay for the ingredients, the packaging and the people who cook, and the next lessons deduct those. But net revenue is the right first number, because it is the only money that actually reaches the restaurant from each order, and it is where channels differ the most.
The worked example: twelve orders on a Friday evening
On one Friday evening Saltmeadow Kitchen received twelve orders: four through App A, three through App B, three through its own website and two by phone. The fee rates in this fictional example are 30 per cent for App A, 24 per cent for App B, 3 per cent for the website and 1.5 per cent for phone orders (card fees only). The lab above uses exactly these orders.
| Order | Channel | Order value | Fee rate | Fee | Net revenue |
|---|---|---|---|---|---|
| O-1001 | App A | £28.50 | 30.0% | £8.55 | £19.95 |
| O-1002 | App B | £34.00 | 24.0% | £8.16 | £25.84 |
| O-1003 | Website | £31.50 | 3.0% | £0.95 | £30.56 |
| O-1004 | App A | £42.80 | 30.0% | £12.84 | £29.96 |
| O-1005 | Phone | £26.00 | 1.5% | £0.39 | £25.61 |
| O-1006 | App A | £19.90 | 30.0% | £5.97 | £13.93 |
| O-1007 | Website | £38.40 | 3.0% | £1.15 | £37.25 |
| O-1008 | App B | £45.20 | 24.0% | £10.85 | £34.35 |
| O-1009 | App A | £33.60 | 30.0% | £10.08 | £23.52 |
| O-1010 | Website | £29.00 | 3.0% | £0.87 | £28.13 |
| O-1011 | App B | £22.40 | 24.0% | £5.38 | £17.02 |
| O-1012 | Phone | £36.50 | 1.5% | £0.55 | £35.95 |
| Total | £387.80 | £65.73 | £322.07 |
The twelve orders add up to £387.80 of order value. After fees, £322.07 remains as net revenue, so the evening cost £65.73 in commissions and card fees. Amounts are shown rounded to the penny; the totals are calculated from the unrounded values.
Step 1: look up the fee rate with XLOOKUP
Each order has a channel name in column B and the fee rates sit in a small table in H4:I7. Typing a rate by hand for every order would be slow and error-prone, and the day a rate changes you would have to find every place where it was used. Instead, let the spreadsheet look it up: XLOOKUP(what to find, where to look, what to return) finds the channel name in the first range and returns the matching cell of the second range.
D4: =XLOOKUP(B4,$H$4:$H$7,$I$4:$I$7)
The dollar signs lock the lookup table, so the formula can be copied down to D15 without the table moving. Older spreadsheets use INDEX and MATCH or VLOOKUP for the same job; the result is identical. If the channel name is misspelled, the lookup returns an error, which is a feature: it points to the order whose channel you need to fix.
Step 2: the fee and the net revenue of each order
With the fee rate in column D, the rest is simple arithmetic. In E4 the fee is the order value times the rate, and in F4 the net revenue is the order value minus the fee. Copy both formulas down to row 15.
E4: =C4*D4F4: =C4-E4
Look at O-1004: a £42.80 order through App A at 30 per cent carries a fee of £12.84 and leaves £29.96. The same £42.80 through the own website at 3 per cent would carry a fee of £1.28 and leave £41.52. That difference of £11.56 on a single order is the reason why restaurants try to move regular guests to their own channels.
Step 3: net revenue per channel with SUMIFS
To compare channels you need totals per channel. SUMIFS(sum range, criteria range, criterion) adds only those cells of the sum range whose partner cell in the criteria range matches the criterion. In the lab the channel names to the left of each total sit in H4:H7, so the criterion is a cell reference and the formula can be copied down.
J4: =SUMIFS($F$4:$F$15,$B$4:$B$15,H4)
This sums the net revenue column that you filled in step 2. If you prefer one formula that does not depend on the helper columns, you can also write =SUMIFS($C$4:$C$15,$B$4:$B$15,H4)*(1-I4), which sums the order values of the channel and applies its fee rate once. Both give the same result, which is a good way to check your work.
| Channel | Orders | Order value | Fee | Net revenue | Formula in J |
|---|---|---|---|---|---|
| App A | 4 | £124.80 | £37.44 | £87.36 | =SUMIFS($C$4:$C$15,$B$4:$B$15,H4)*(1-I4) |
| App B | 3 | £101.60 | £24.38 | £77.22 | =SUMIFS($C$4:$C$15,$B$4:$B$15,H5)*(1-I5) |
| Website | 3 | £98.90 | £2.97 | £95.93 | =SUMIFS($C$4:$C$15,$B$4:$B$15,H6)*(1-I6) |
| Phone | 2 | £62.50 | £0.94 | £61.56 | =SUMIFS($C$4:$C$15,$B$4:$B$15,H7)*(1-I7) |
| All | 12 | £387.80 | £65.73 | £322.07 | =SUM(J4:J7) |
Reading the result
Three things stand out. First, App A has the most order value (four orders, £124.80) but the website, with three orders and £98.90, keeps more money: £95.93 against £87.36. Second, the fee is not a rounding detail: out of the £387.80 of the evening, £65.73 (16.9 per cent) went to channels, and £37.44 of that to a single app. Third, the phone channel is small but nearly free.
That does not mean the apps are bad. They bring guests who might never find the restaurant otherwise, they carry the delivery and they take the payment risk. It means that the commission is a real price that you pay for those services, and you should know whether you are paying it for guests who are new or for guests who already know you.
Common mistakes
- Using one fee rate for everything. Every channel has its own rate, so a single average rate hides exactly the difference you want to see. Look the rate up per order.
- Forgetting the dollar signs. Without
$H$4:$I$7the lookup table slips down when the formula is copied, and from some row onward the lookups return errors or wrong rates. - Reading the fee rate as a whole number. A rate of 30 per cent is 0.30 in the sheet. Typing 30 multiplies the order by 30. Format the column as a percentage so a mistake is visible.
- Adding up gross instead of net. A chart of order value per channel makes the apps look like heroes. Chart the net revenue and the picture changes.
- Calling net revenue profit. Food, packaging, couriers, staff and rent are still to be paid. The next lessons deduct them step by step.
How to read your own numbers
Once the sheet works for twelve orders, it works for twelve hundred. Export the orders of a month from your point-of-sale or ordering system, with order date, channel and order value, paste them below the headers and extend the formulas. Add up the net revenue per channel and divide each channel's fee by its order value to see the effective fee rate, which can differ from the contract rate if the platform also charges for promotions or in-app advertising.
Then ask three questions. How much of my net revenue depends on one app? What would I lose if that app doubled its rate? And how many of my regulars order through the app although they could order directly? The rest of this course gives you the tools to answer each of these questions with numbers instead of guesses.
What the other 19 labs cover
- Contribution per order: fee, food cost, packaging and your own courier, averaged per channel.
- Break-even commission: the highest fee rate that still meets your target margin.
- Shifting app orders to direct: a what-if grid with courier cost and a first-order incentive.
- The direct ordering funnel: sessions, baskets, orders and promotion cost per order.
- Reservation sources: share of bookings, no-show rate and shown covers.
- Cost per seated cover for each booking source.
- Quiet evenings: weekday numbers, fill rate and conditional formatting.
- Menu promotion tests with a comparison group, and test versus control venue.
- Menu engineering: stars, plough horses, puzzles and dogs.
- Local social posts: engagement rate, tap rate and the best post type.
- Tracked bookings from posts, cost per booking and contribution after a boost.
- Review response rate and speed, rating target math, and rating trends with SLOPE and FORECAST.LINEAR.
- Offer redemption, incremental visits with a holdout group, and repeat visits within a return window.
- A final nine-month dashboard that combines orders, fees, bookings, ratings and a forecast.
The labs get a little harder one by one. Each begins with a short theory text, explains every function when it first appears and checks your cells the moment you type them. You can try the first lab for free, directly in the browser, without installing anything.
Quick reference: functions and shortcuts in this lesson
| Function / shortcut | What it does here | Example |
|---|---|---|
XLOOKUP | Finds the channel in a table and returns its fee rate | =XLOOKUP(B4,$H$4:$H$7,$I$4:$I$7) |
INDEX + MATCH | The same lookup in older spreadsheets | =INDEX($I$4:$I$7,MATCH(B4,$H$4:$H$7,0)) |
| Multiplication | Fee in pounds from value and rate | =C4*D4 |
| Subtraction | Net revenue after the fee | =C4-E4 |
SUMIFS | Adds only the rows of one channel | =SUMIFS($F$4:$F$15,$B$4:$B$15,H4) |
SUM | Total over all channels | =SUM(J4:J7) |
| F4 / Cmd + T | Cycles through relative and absolute references | $H$4:$I$7 |
| Ctrl + D | Copies the formula above into the selected cells | Fill a column down |
Frequently asked questions
What is a delivery app commission?
A commission is a percentage of each order value that a delivery or marketplace platform keeps for bringing the order, handling payment and often the delivery. The rate depends on the contract, the plan and the market, and can change, so check your own agreement.
How do I calculate net revenue after commission in Excel?
Multiply the order value by the commission rate to get the fee, then subtract the fee from the order value. In a sheet this is =C4*D4 for the fee and =C4-E4 for the net revenue, copied down for every order.
How do I look up the fee rate of each channel automatically?
Keep the rates in a small table and use XLOOKUP, for example =XLOOKUP(B4,$H$4:$H$7,$I$4:$I$7). INDEX with MATCH or VLOOKUP give the same result. Lock the table with dollar signs before you copy the formula down.
Is net revenue the same as profit for a restaurant?
No. Net revenue here is the order value minus the channel fee. Food cost, packaging, couriers, staff and rent still have to be paid from it, so profit is lower. The later labs of this course deduct these costs step by step.
Why compare channels by net revenue and not by order value?
Order value ignores the fee, so a channel with high commission looks better than it is. Net revenue shows what actually reaches the restaurant and makes channels with different fee rates comparable.
Should a restaurant stop using delivery apps?
Not necessarily. Apps can bring new guests and carry delivery. The point is to know the cost, compare it with the value of the orders and decide knowingly, for example by encouraging regular guests to order directly while keeping the app for discovery.
Keep going: Restaurant & Café Digital Marketing: Delivery Commission, Direct Orders, Reservations, Menu Tests, Local Posts, Reviews & Offers
This free lab is lesson 1 of 20. Unlock the other 19 hands-on labs, the final exam and your certificate for a one-time CHF 9.90.
- Contribution per Order: Fee, Food Cost, Packaging and Own Courier by Channel
- Break-Even Commission: Contribution per Order, Margin and the Highest Fee Rate a Channel Can Bear
- Shifting App Orders to Direct: Saving per Order, Orders Moved and an Annual What-If Grid
- Direct Ordering Funnel: Basket Rate, Checkout Completion and Promotion Cost per Order
- Reservation Sources: Share of Bookings, No-Show Rate and Shown Covers
- Cost per Seated Cover: Variable Fees, Fixed Costs and Cost as a Share of Sales by Booking Source
- Quiet Evenings: Weekday Numbers, Fill Rate, Peak vs Midweek and Conditional Formatting
- Menu Promotion Test: Change in Units, Margin per Unit, Extra Margin and a Comparison Group
- Test vs Control Venue: Weekly Ratio, Before and After Averages and Uplift of a Menu Promotion
- Menu Engineering: Popularity Share, Weighted Margin, Stars and Puzzles to Promote
- Local Social Posts: Engagement Rate, Tap Rate and the Best Post Type
- From Post to Booking: Click-to-Booking Rate, Cost per Booking with IFERROR and Contribution after Boost
- Review Response: Response Rate, 24-Hour Replies, Unanswered Low-Star Reviews and the Star Distribution
- Rating Target Math: Stars So Far, 5-Star Reviews Needed, Months to Target and Weighted Average
- Review Rating Trend: SLOPE, FORECAST.LINEAR, CORREL with Wait Mentions and an Alert Level
- Offer Redemption: Redemption Rate, Discount Cost, Discount as a Share of the Bill and Rank
- Offer Incrementality: Holdout Group, Expected Visits Anyway, Incremental Visits and Net Contribution
- Repeat Visits: Days to Return, a 60-Day Window and Return Rates with and without an Offer
- Final Project: A Restaurant Digital Marketing Dashboard with Direct Share, Fees, Show-Up Rate and a Forecast