August 2026 / Money map
Draft run · not closedPrototype v0.2 · real August data, masked
For: everyone · start here

Where did August's money go?

One picture of the month: what was sold, what each provider confirms, what it cost, and what is still open. Each role then drills into its own page.

Decisions this view supportsIs the month good enough to close? · Which gap matters most? · What should v2 focus on?
Sales on the POSKES 39.15M25,447 sales
Matched to a provider record94.8%of sales that can be checked one by one (cash excluded)
Exceptions to review1,213KES 1.85M of POS sales · 584 fall into 9 repeating patterns
Cash difference, observedKES 373Kaudit only · POS cash KES 3.17M vs deposits KES 2.79M

Where the money sits after matching

Every POS sale flows from its aggregator (left) to its result (right). Band width is the value in KES; percentages are shares of all POS value, cash included. (The 95.0% tile counts sales, cash excluded.) Hover a band for the amount.

Glovo KES 10.26MUber Eats KES 6.19MBolt Food KES 2.78MM-Pesa till KES 7.91MCard machines KES 8.80MCash KES 3.17MOther KES 52KMatched KES 34.13M · 87.2% of valueDaily total only KES 3.17M · 8.1% of valueAmount variance KES 986K · 2.5% of valueMissing settlement KES 492K · 1.3% of valueCancellation KES 264K · 0.7% of valueRefund KES 90K · 0.2% of valueInter-punch KES 19K · 0.0% of value
GlovoUber EatsBolt FoodM-Pesa tillCard machinesCashOther
Table view
AggregatorResultValue
GlovoMatchedKES 9.59M
Card machinesMatchedKES 8.57M
M-Pesa tillMatchedKES 7.73M
Uber EatsMatchedKES 5.53M
CashDaily total onlyKES 3.17M
Bolt FoodMatchedKES 2.66M
GlovoAmount varianceKES 520K
Uber EatsAmount varianceKES 383K
Card machinesMissing settlementKES 222K
M-Pesa tillMissing settlementKES 171K
GlovoCancellationKES 127K
Uber EatsCancellationKES 110K
Uber EatsRefundKES 90K
Bolt FoodAmount varianceKES 83K
Uber EatsMissing settlementKES 75K
OtherMatchedKES 46K
Bolt FoodCancellationKES 26K
GlovoMissing settlementKES 12K
GlovoInter-punchKES 7,780
OtherMissing settlementKES 6,238
Bolt FoodMissing settlementKES 6,150
Uber EatsInter-punchKES 6,150
Bolt FoodInter-punchKES 5,200

The trail, end to end

The same sale seen four times. A gap between two steps is what someone needs to explain.

1 · POS (what was sold)KES 39.15M25,447 sales across 9 aggregators
→
2 · Providers (what they say they collected)94.8% matched1,213 POS sales to review · 568 provider records not on the POS (KES 721K)
→
3 · Fees (what it cost)KES 1.36MGlovo's commission is not in its export (Q8), so this is low
→
4 · Bank (what arrived)Not uploadedNeeds the bank statement (Q5). M-Pesa reports 30 sweeps, KES 8.37M

What needs a decision now

11 decisions, drawn from the data and the open questions. Full list on Decisions needed.

All decisions
  • D1
    What 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.
  • D2
    Who does reconciliation today, and can they walk us through it?Every role in this pack is assumed (tagged assumed). Decides: Project lead.
  • D3
    Is the Glovo KES 385 difference a price list gap?327 Glovo orders are exactly KES 385 lower on the POS than in Glovo (more at 2× and 3×). Decides: Finance manager, store.
  • D4
    Where 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.

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.

Look