Delivery and COD reports
What this is for
Two reports covering the two things that go wrong with delivery: the margin, and the cash.
The delivery app report
Tracks orders and commissions from delivery platforms.
| Figure | What it is |
|---|---|
| Total Orders | Through delivery. |
| Total Delivery Fees | Fees charged to customers. |
| Total Commission | What the platforms took. |
| Net Revenue | What actually reached you. |
| Avg Order Value | Basket size. |
| Commission Rate | The percentage, and per order cost. |
Filter to All Delivery Apps, a single platform, or Direct Delivery — your own.
The comparison that matters
Put your own delivery next to each platform and look at net revenue per order, not gross.
A platform order at £40 with 28% commission nets you £28.80. Your own delivery at £35 with a card fee nets you nearly £34. The platform order is bigger and worth less.
That single comparison is what decides whether a platform is growth or a treadmill. It's only possible if platform orders have their own order type — see Third-party delivery apps.
What to do with it
- Compare platforms against each other. Commission rates differ, and so do basket sizes.
- Check your platform pricing is doing its job. If you've set higher prices to absorb commission, net revenue per order should be close to your direct figure. If it isn't, the uplift is too small.
- Watch volume shifting. Platform share growing while direct shrinks is a long-term margin problem even while total revenue rises.
- Push your own channel. Every order moved from a platform to your own site is most of a commission saved.
If a platform shows no orders, either nothing came through it or the orders weren't entered under its order type.
The COD report
Tracks cash-on-delivery orders, collections, pending cash and settlement history.
| Figure | What it is |
|---|---|
| Expected COD | What should have been collected. |
| Collected COD | What drivers say they took. |
| Settled COD | What's been handed in and approved. |
| Total Pending COD | Money still out with drivers. |
Four views:
- Order Payment Status — per order.
- COD Collection — what was collected, per order.
- Executive Pending Cash — per driver.
- Settlement History — submissions and approvals.
Search across order, customer, executive or settlement; filter by executive and status.
Reading it
Expected against collected is the first check. A gap is either a partial collection, a not-collected, or something not recorded — and all three carry notes explaining why. See Cash on delivery and settlements.
Collected against settled is the second. Money collected and not settled is cash sitting with a driver. Small during a shift is normal; large or old is not.
Executive Pending Cash is the one to read before anyone goes home. It's a per-driver figure of what they're carrying.
A daily routine
- Before drivers finish — check pending cash per driver.
- At settlement — count the physical cash, then approve. Never the other way round.
- Weekly — read settlement history for rejections and repeated shortfalls.
Good to know
- Both are per branch and follow your operating shifts.
- The COD report only covers orders not paid online. Prepaid deliveries have nothing to collect.
- Commission figures depend on what you've configured per platform. If they look wrong, check the platform's order type setup.
- If COD screens report missing tables, the deployment needs its latest migrations — one for whoever maintains your installation.