August 2026 / Leadership one-page
Draft run · not closedPrototype v0.2 · real August data, masked
For: owner and leadership · five-minute read
August on one page
What each aggregator brought in, what it cost, and what is still unexplained. Figures stay marked draft until the finance manager closes the month.
Decisions this view supportsWhich aggregators to grow or renegotiate · Whether the open value is acceptable · What v2 should answer
SalesKES 39.15M25,447 sales in 31 days
Fees recordedKES 1.36M3.5% of sales; Glovo commission missing
Still to explainKES 1.85M1,213 sales · draft until the manager closes the month
Cash difference, observedKES 373Kaudit only · 1 Aug to 1 Sep
What each aggregator earned and cost
Sales by aggregator, with recorded fees and the value still open.
| Aggregator | Sales | Share | Fees | Fee rate | Open (to explain) |
|---|---|---|---|---|---|
| Glovocommission not in export | KES 10.26M | 26.2% | KES 212K | 2.1% | KES 667K |
| Uber Eats | KES 6.19M | 15.8% | KES 953K | 15.6% | KES 664K |
| Bolt Food | KES 2.78M | 7.1% | KES 274K | 10.0% | KES 121K |
| M-Pesa till | KES 7.91M | 20.2% | KES 43K | 0.5% | KES 171K |
| Card machines | KES 8.80M | 22.5% | KES 89K | 1.0% | KES 222K |
| Cash | KES 3.17M | 8.1% | — | — | — |
| Little Cab | KES 30K | 0.1% | KES 2,437 | 8.0% | — |
| Meal cards | KES 17K | 0.0% | — | — | KES 2,540 |
| Vouchers | KES 4,898 | 0.0% | — | — | KES 3,698 |
| Total | KES 39.15M | 100% | KES 1.36M | 3.5% | KES 1.85M |
Cost per 100 shillings sold
Recorded fee rate by aggregator. Glovo is left out until its commission is found (Q8).
Table view
| Aggregator | KES per 100 |
|---|---|
| Uber Eats | 15.61 |
| Bolt Food | 9.98 |
| Little Cab | 8.01 |
| Card machines | 1.00 |
| M-Pesa till | 0.52 |
Four things to know
- Delivery apps are 49% of sales and the most expensive way to sell: Uber Eats keeps about KES 16 of every 100, Bolt Food 10. Glovo's real cost is unknown until its commission statement is found (Q8).
- 94.8% of checkable sales match a provider record. Most of the rest repeat a few patterns: 327 Glovo orders are KES 385 lower on the POS than in Glovo.
- KES 373K of POS cash has no matching deposit by 1 September. KES 250K of it is one take away order on 26 Aug rung up as cash. Was it really paid in cash?
- 568 provider records (KES 721K) have no POS sale, mostly M-Pesa (321). They may be other M-Pesa tills on the same number, or sales never rung up.
Decisions for leadership
- D1What should v1 be for first?The data supports five outcomes: missed payments, inter-punches, fee checks, cash observations (audit only), and sales patterns. Decides: Project lead, client.
- D4Where is Glovo's commission, and what rates did we sign?Glovo's export has no fee columns; other rates are August averages. Decides: Project lead, client.
- D5Was the KES 250K order on 26 Aug really paid in cash?Observed cash difference is KES 373K; one take-away sale of 500 meals explains KES 250K of it. Cash reconciliation is outside the first version; may we show the audit-only cash view?. Decides: Finance manager, store.
- D8Who receives the HR report, and how is the hand-over recorded?The HR report lists confirmed losses only, by POS user, for HR review; the system never deducts pay (s.19). Decides: Client, with HR advice.
Built from the pipeline run of 10 Oct 2026 (Payments.xlsx + POS export). Customer details are masked and cashiers are shown as pseudonyms. Items tagged "assumed" rest on assumptions in the spec.