Tabellab

Delivery Commission vs Direct Orders: Fee Rate, Fee in £, Net Revenue and Net Revenue per Channel

Lesson 1 of 20Lab

All lessons
  1. Delivery Commission vs Direct Orders: Fee Rate, Fee in £, Net Revenue and Net Revenue per ChannelLabFree
  2. Contribution per Order: Fee, Food Cost, Packaging and Own Courier by ChannelLab Locked
  3. Break-Even Commission: Contribution per Order, Margin and the Highest Fee Rate a Channel Can BearLab Locked
  4. Shifting App Orders to Direct: Saving per Order, Orders Moved and an Annual What-If GridLab Locked
  5. Direct Ordering Funnel: Basket Rate, Checkout Completion and Promotion Cost per OrderLab Locked
  6. Reservation Sources: Share of Bookings, No-Show Rate and Shown CoversLab Locked
  7. Cost per Seated Cover: Variable Fees, Fixed Costs and Cost as a Share of Sales by Booking SourceLab Locked
  8. Quiet Evenings: Weekday Numbers, Fill Rate, Peak vs Midweek and Conditional FormattingLab Locked
  9. Menu Promotion Test: Change in Units, Margin per Unit, Extra Margin and a Comparison GroupLab Locked
  10. Test vs Control Venue: Weekly Ratio, Before and After Averages and Uplift of a Menu PromotionLab Locked
  11. Menu Engineering: Popularity Share, Weighted Margin, Stars and Puzzles to PromoteLab Locked
  12. Local Social Posts: Engagement Rate, Tap Rate and the Best Post TypeLab Locked
  13. From Post to Booking: Click-to-Booking Rate, Cost per Booking with IFERROR and Contribution after BoostLab Locked
  14. Review Response: Response Rate, 24-Hour Replies, Unanswered Low-Star Reviews and the Star DistributionLab Locked
  15. Rating Target Math: Stars So Far, 5-Star Reviews Needed, Months to Target and Weighted AverageLab Locked
  16. Review Rating Trend: SLOPE, FORECAST.LINEAR, CORREL with Wait Mentions and an Alert LevelLab Locked
  17. Offer Redemption: Redemption Rate, Discount Cost, Discount as a Share of the Bill and RankLab Locked
  18. Offer Incrementality: Holdout Group, Expected Visits Anyway, Incremental Visits and Net ContributionLab Locked
  19. Repeat Visits: Days to Return, a 60-Day Window and Return Rates with and without an OfferLab Locked
  20. Final Project: A Restaurant Digital Marketing Dashboard with Direct Share, Fees, Show-Up Rate and a ForecastLab Locked

You are not signed in — the lab works, but your progress is not saved. Sign up

Lesson 1 of 20 is free. Unlock all 20 hands-on labs, the final exam and your certificate.

Buy course — CHF 9.90
Loading the spreadsheet…

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 rate
Net 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.

Order value here means the food and drinks only. Delivery fees that guests pay for the ride are treated as a separate matter and are left out of this course's order values.

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.

OrderChannelOrder valueFee rateFeeNet revenue
O-1001App A£28.5030.0%£8.55£19.95
O-1002App B£34.0024.0%£8.16£25.84
O-1003Website£31.503.0%£0.95£30.56
O-1004App A£42.8030.0%£12.84£29.96
O-1005Phone£26.001.5%£0.39£25.61
O-1006App A£19.9030.0%£5.97£13.93
O-1007Website£38.403.0%£1.15£37.25
O-1008App B£45.2024.0%£10.85£34.35
O-1009App A£33.6030.0%£10.08£23.52
O-1010Website£29.003.0%£0.87£28.13
O-1011App B£22.4024.0%£5.38£17.02
O-1012Phone£36.501.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*D4
F4: =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.

Check one row by hand. Take any order, multiply its value by its fee rate on a calculator and compare it with the sheet. A check like this takes ten seconds and catches a wrong lookup range straight away.

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.

ChannelOrdersOrder valueFeeNet revenueFormula in J
App A4£124.80£37.44£87.36=SUMIFS($C$4:$C$15,$B$4:$B$15,H4)*(1-I4)
App B3£101.60£24.38£77.22=SUMIFS($C$4:$C$15,$B$4:$B$15,H5)*(1-I5)
Website3£98.90£2.97£95.93=SUMIFS($C$4:$C$15,$B$4:$B$15,H6)*(1-I6)
Phone2£62.50£0.94£61.56=SUMIFS($C$4:$C$15,$B$4:$B$15,H7)*(1-I7)
All12£387.80£65.73£322.07=SUM(J4:J7)

Reading the result

Order value per channel: what stays and what goes as feeNet revenue (kept)Fee (commission or card fee)020406080100120140£ per channel£124.80£87.36£37.44App A4 orders · fee 30.0%£101.60£77.22£24.38App B3 orders · fee 24.0%£98.90£95.93Website3 orders · fee 3.0%£62.50£61.56Phone2 orders · fee 1.5%Twelve fictional orders from one Friday evening
Figure 1. Order value per channel, split into net revenue (kept) and fee. App A brings the biggest order value, £124.80, but only £87.36 of it stays with the restaurant, while the three website orders keep £95.93 of £98.90.

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.

Where £100 of food orders goesKept by the restaurantFeeApp A (30% commission)£70 kept£30Own website (3% card fee)£97 kept£3 feeBefore food cost, packaging, staff and rent (fictional rates)
Figure 2. The same £100 of food orders through App A and through the own website. At the fictional rates of this course the restaurant keeps £70 in the first case and £97 in the second, before any other cost.

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$7 the 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.

Treat guests' data with care. Order histories can include names, addresses and phone numbers. Keep only what you need, use customer data from apps only as the platform's terms allow, and market to guests by email or message only with their consent.

What the other 19 labs cover

  1. Contribution per order: fee, food cost, packaging and your own courier, averaged per channel.
  2. Break-even commission: the highest fee rate that still meets your target margin.
  3. Shifting app orders to direct: a what-if grid with courier cost and a first-order incentive.
  4. The direct ordering funnel: sessions, baskets, orders and promotion cost per order.
  5. Reservation sources: share of bookings, no-show rate and shown covers.
  6. Cost per seated cover for each booking source.
  7. Quiet evenings: weekday numbers, fill rate and conditional formatting.
  8. Menu promotion tests with a comparison group, and test versus control venue.
  9. Menu engineering: stars, plough horses, puzzles and dogs.
  10. Local social posts: engagement rate, tap rate and the best post type.
  11. Tracked bookings from posts, cost per booking and contribution after a boost.
  12. Review response rate and speed, rating target math, and rating trends with SLOPE and FORECAST.LINEAR.
  13. Offer redemption, incremental visits with a holdout group, and repeat visits within a return window.
  14. 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.

You do not need a restaurant of your own to learn from the course. The method works for a café, a food truck, a bakery with a delivery option or a hotel restaurant: wherever guests can reach you through a marketplace and through a channel of your own.

Quick reference: functions and shortcuts in this lesson

Function / shortcutWhat it does hereExample
XLOOKUPFinds the channel in a table and returns its fee rate=XLOOKUP(B4,$H$4:$H$7,$I$4:$I$7)
INDEX + MATCHThe same lookup in older spreadsheets=INDEX($I$4:$I$7,MATCH(B4,$H$4:$H$7,0))
MultiplicationFee in pounds from value and rate=C4*D4
SubtractionNet revenue after the fee=C4-E4
SUMIFSAdds only the rows of one channel=SUMIFS($F$4:$F$15,$B$4:$B$15,H4)
SUMTotal over all channels=SUM(J4:J7)
F4 / Cmd + TCycles through relative and absolute references$H$4:$I$7
Ctrl + DCopies the formula above into the selected cellsFill 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.

  1. Contribution per Order: Fee, Food Cost, Packaging and Own Courier by Channel
  2. Break-Even Commission: Contribution per Order, Margin and the Highest Fee Rate a Channel Can Bear
  3. Shifting App Orders to Direct: Saving per Order, Orders Moved and an Annual What-If Grid
  4. Direct Ordering Funnel: Basket Rate, Checkout Completion and Promotion Cost per Order
  5. Reservation Sources: Share of Bookings, No-Show Rate and Shown Covers
  6. Cost per Seated Cover: Variable Fees, Fixed Costs and Cost as a Share of Sales by Booking Source
  7. Quiet Evenings: Weekday Numbers, Fill Rate, Peak vs Midweek and Conditional Formatting
  8. Menu Promotion Test: Change in Units, Margin per Unit, Extra Margin and a Comparison Group
  9. Test vs Control Venue: Weekly Ratio, Before and After Averages and Uplift of a Menu Promotion
  10. Menu Engineering: Popularity Share, Weighted Margin, Stars and Puzzles to Promote
  11. Local Social Posts: Engagement Rate, Tap Rate and the Best Post Type
  12. From Post to Booking: Click-to-Booking Rate, Cost per Booking with IFERROR and Contribution after Boost
  13. Review Response: Response Rate, 24-Hour Replies, Unanswered Low-Star Reviews and the Star Distribution
  14. Rating Target Math: Stars So Far, 5-Star Reviews Needed, Months to Target and Weighted Average
  15. Review Rating Trend: SLOPE, FORECAST.LINEAR, CORREL with Wait Mentions and an Alert Level
  16. Offer Redemption: Redemption Rate, Discount Cost, Discount as a Share of the Bill and Rank
  17. Offer Incrementality: Holdout Group, Expected Visits Anyway, Incremental Visits and Net Contribution
  18. Repeat Visits: Days to Return, a 60-Day Window and Return Rates with and without an Offer
  19. Final Project: A Restaurant Digital Marketing Dashboard with Direct Share, Fees, Show-Up Rate and a Forecast

Buy course — CHF 9.90 See the full course