August 2026 / Branches
Draft run · not closedPrototype v0.2 · real August data, masked
For: HQ finance and admin · J8
Where does every branch stand this month?
The HQ view across branches. August has one branch's POS data; the meal-card export already shows 41 others.
Decisions this view supportsConfirm the branch map for each provider account · A second branch's files for testing
Branches in August files421 with a POS upload, 41 seen only in the meal-card export
Rows sent to other branches363meal cards, KES 438K
Branch unknown1meal-card row the file does not place, KES 1,200
Cross-branch moves0manual only, approved by a second person
Every branch, one month
HQ sees all branches; a store manager sees only their own. Branches without a POS upload show what HQ files already hold for them.
| Branch | Files in for August | POS sales | Matched | Exceptions | Month |
|---|---|---|---|---|---|
| Hurlingham | POS, cash and provider files | 25,447 | 94.8% | 1,213 | In review |
| KFC Southfield Mall | Meal-card rows only, from the HQ upload | — | — | — | Waiting for branch upload |
| KFC Kimathi street | Meal-card rows only, from the HQ upload | — | — | — | Waiting for branch upload |
| KFC SYOKIMAU | Meal-card rows only, from the HQ upload | — | — | — | Waiting for branch upload |
| KFC Kamakis | Meal-card rows only, from the HQ upload | — | — | — | Waiting for branch upload |
| KFC Woodvale Grove | Meal-card rows only, from the HQ upload | — | — | — | Waiting for branch upload |
| KFC Embakasi | Meal-card rows only, from the HQ upload | — | — | — | Waiting for branch upload |
| and 35 more branches seen in the meal-card export | |||||
Branch map: how a payment finds its branch
Each provider account is mapped to one branch. A payment the map cannot place goes to Branch unknown and is never matched automatically.
| Provider | What identifies the branch | Maps to | Source |
|---|---|---|---|
| Glovo | Store ID on each order | Hurlingham | assumed |
| Uber Eats | Store UUID on each order | Hurlingham | assumed |
| Bolt Food | Provider (store) ID | Hurlingham | assumed |
| Little Cab | Merchant account | Hurlingham | assumed |
| M-Pesa till | Till number | Hurlingham | assumed |
| Card machines | Pesapal merchant, DPO terminal | Hurlingham | assumed |
| Meal cards | Branch column in the export | Each row's own branch | from the file |
| Vouchers | Redeeming store | Hurlingham | assumed |
Meal-card payments for other branches
From the one brand-wide export: assigned to their own branch, never matched against Hurlingham.
Table view
| Branch | Payments | Amount |
|---|---|---|
| KFC Southfield Mall | 52 | KES 55K |
| KFC Kimathi street | 27 | KES 27K |
| KFC SYOKIMAU | 27 | KES 34K |
| KFC Kamakis | 18 | KES 20K |
| KFC Woodvale Grove | 15 | KES 16K |
| KFC Embakasi | 15 | KES 24K |
| KFC KANGUNDO ROAD | 14 | KES 14K |
| KFC Thindigua | 13 | KES 20K |
| KFC KAREN | 12 | KES 10K |
| KFC Mombasa Road | 11 | KES 12K |
| KFC Northview | 10 | KES 14K |
| KFC Buruburu | 10 | KES 8,530 |
| KFC Lavington | 9 | KES 10K |
| KFC Donholm | 9 | KES 12K |
| KFC Kasarani | 9 | KES 6,620 |
| KFC Mombasa | 8 | KES 10K |
| KFC NGONG ROAD | 8 | KES 6,550 |
| KFC Nakuru, Westside mall | 7 | KES 6,200 |
| KFC Thika | 7 | KES 14K |
| KFC Kahawa Sukari | 6 | KES 8,940 |
| KFC RUAKA | 6 | KES 7,930 |
| KFC Hyrax | 6 | KES 10K |
| KFC Baraka | 6 | KES 6,370 |
| KFC Garden City | 5 | KES 7,770 |
| KFC NJIRU | 5 | KES 4,991 |
| KFC Waiyaki Way | 5 | KES 6,620 |
| KFC Rongai | 5 | KES 7,800 |
| KFC Limuru road | 5 | KES 5,080 |
| KFC Nyali | 5 | KES 5,190 |
| KFC Junction Mall | 4 | KES 9,180 |
| KFC Galleria | 4 | KES 7,060 |
| KFC ATHI RIVER | 3 | KES 6,040 |
| KFC Meru | 3 | KES 2,650 |
| KFC Lang'ata | 3 | KES 3,690 |
| KFC EASTLEIGH 2 | 2 | KES 2,390 |
| KFC Eldoret | 2 | KES 1,210 |
| KFC Kisumu | 2 | KES 3,500 |
| KFC The Hub | 2 | KES 4,220 |
| KFC Kakamega | 1 | KES 2,200 |
| KFC Machakos | 1 | KES 1,200 |
| KFC Nanyuki | 1 | KES 1,790 |
The ruleAutomated matching only pairs a sale and a payment from the same branch. Anything across branches is done by hand on Manual match, with a reason, an explanation and a second person's approval, and is recorded in the audit trail.
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.