What is left to explain? Work it one item at a time.
Exceptions grouped by kind, by repeating pattern and by day. Each item moves Open → Explained → Resolved, and only the manager accepts.
Glovo: provider KES 385 higher
327 sales with the same difference. One explanation covers them all.
- Aggregator
- Glovo
- Each sale
- KES 385 higher than the POS
- Sales
- 327
- Total
- KES 126K
- Days seen
- 31 of 31
Evidence
| Day | Sale | POS | Provider | Difference |
|---|---|---|---|---|
| 01 Aug | …80388 | KES 1,190 | KES 1,575 | KES 385 |
| 01 Aug | …80851 | KES 490 | KES 875 | KES 385 |
| 01 Aug | …92456 | KES 990 | KES 1,375 | KES 385 |
| 01 Aug | …01746 | KES 1,140 | KES 1,525 | KES 385 |
| 01 Aug | …12503 | KES 3,730 | KES 4,115 | KES 385 |
5 of 327 sales. Seen on 31 of 31 days, so it looks like a standing rule, not a one-off.
Likely reason (to confirm)
Glovo price list KES 385 above the POS (one item?) assumed
What happens next
The finance officer writes one explanation for the group. When the finance manager accepts it, every sale in the group is resolved.
Uber Eats: provider KES 100 higher
88 sales with the same difference. One explanation covers them all.
- Aggregator
- Uber Eats
- Each sale
- KES 100 higher than the POS
- Sales
- 88
- Total
- KES 8,800
- Days seen
- 23 of 31
Evidence
| Day | Sale | POS | Provider | Difference |
|---|---|---|---|---|
| 06 Aug | …99090 | KES 2,200 | KES 2,300 | KES 100 |
| 07 Aug | …25256 | KES 1,250 | KES 1,350 | KES 100 |
| 07 Aug | …41043 | KES 1,670 | KES 1,770 | KES 100 |
| 07 Aug | …49019 | KES 1,650 | KES 1,750 | KES 100 |
| 08 Aug | …20119 | KES 1,550 | KES 1,650 | KES 100 |
5 of 88 sales. Seen on 23 of 31 days, so it looks like a standing rule, not a one-off.
Likely reason (to confirm)
Uber price KES 100 above the POS assumed
What happens next
The finance officer writes one explanation for the group. When the finance manager accepts it, every sale in the group is resolved.
Uber Eats: provider KES 230 higher
61 sales with the same difference. One explanation covers them all.
- Aggregator
- Uber Eats
- Each sale
- KES 230 higher than the POS
- Sales
- 61
- Total
- KES 14K
- Days seen
- 3 of 31
Evidence
| Day | Sale | POS | Provider | Difference |
|---|---|---|---|---|
| 29 Aug | …72998 | KES 1,150 | KES 1,380 | KES 230 |
| 29 Aug | …76125 | KES 750 | KES 980 | KES 230 |
| 29 Aug | …79561 | KES 2,950 | KES 3,180 | KES 230 |
| 29 Aug | …81833 | KES 2,450 | KES 2,680 | KES 230 |
| 29 Aug | …81835 | KES 1,050 | KES 1,280 | KES 230 |
5 of 61 sales. Seen on 3 of 31 days, so it looks like a standing rule, not a one-off.
Likely reason (to confirm)
Uber price KES 230 above the POS assumed
What happens next
The finance officer writes one explanation for the group. When the finance manager accepts it, every sale in the group is resolved.
Glovo: provider KES 770 higher
40 sales with the same difference. One explanation covers them all.
- Aggregator
- Glovo
- Each sale
- KES 770 higher than the POS
- Sales
- 40
- Total
- KES 31K
- Days seen
- 23 of 31
Evidence
| Day | Sale | POS | Provider | Difference |
|---|---|---|---|---|
| 01 Aug | …84573 | KES 3,150 | KES 3,920 | KES 770 |
| 01 Aug | …84574 | KES 980 | KES 1,750 | KES 770 |
| 01 Aug | …96374 | KES 980 | KES 1,750 | KES 770 |
| 01 Aug | …84742 | KES 980 | KES 1,750 | KES 770 |
| 02 Aug | …24031 | KES 980 | KES 1,750 | KES 770 |
5 of 40 sales. Seen on 23 of 31 days, so it looks like a standing rule, not a one-off.
Likely reason (to confirm)
Same, two items assumed
What happens next
The finance officer writes one explanation for the group. When the finance manager accepts it, every sale in the group is resolved.
Bolt Food: provider KES 200 lower
16 sales with the same difference. One explanation covers them all.
- Aggregator
- Bolt Food
- Each sale
- KES 200 lower than the POS
- Sales
- 16
- Total
- KES 3,200
- Days seen
- 1 of 31
Evidence
| Day | Sale | POS | Provider | Difference |
|---|---|---|---|---|
| 28 Aug | …48846 | KES 750 | KES 550 | KES -200 |
| 28 Aug | …70588 | KES 750 | KES 550 | KES -200 |
| 28 Aug | …81754 | KES 750 | KES 550 | KES -200 |
| 28 Aug | …99114 | KES 750 | KES 550 | KES -200 |
| 28 Aug | …19570 | KES 1,150 | KES 950 | KES -200 |
5 of 16 sales. Seen on 1 of 31 days, so it looks like a standing rule, not a one-off.
Likely reason (to confirm)
Repeating difference: price list or packaging fee? assumed
What happens next
The finance officer writes one explanation for the group. When the finance manager accepts it, every sale in the group is resolved.
Glovo: provider KES 90 higher
15 sales with the same difference. One explanation covers them all.
- Aggregator
- Glovo
- Each sale
- KES 90 higher than the POS
- Sales
- 15
- Total
- KES 1,350
- Days seen
- 11 of 31
Evidence
| Day | Sale | POS | Provider | Difference |
|---|---|---|---|---|
| 03 Aug | …57873 | KES 1,170 | KES 1,260 | KES 90 |
| 07 Aug | …81364 | KES 3,940 | KES 4,030 | KES 90 |
| 09 Aug | …71084 | KES 5,530 | KES 5,620 | KES 90 |
| 10 Aug | …57612 | KES 2,150 | KES 2,240 | KES 90 |
| 10 Aug | …76025 | KES 1,020 | KES 1,110 | KES 90 |
5 of 15 sales. Seen on 11 of 31 days, so it looks like a standing rule, not a one-off.
Likely reason (to confirm)
Repeating difference: price list or packaging fee? assumed
What happens next
The finance officer writes one explanation for the group. When the finance manager accepts it, every sale in the group is resolved.
Glovo: provider KES 1,155 higher
14 sales with the same difference. One explanation covers them all.
- Aggregator
- Glovo
- Each sale
- KES 1,155 higher than the POS
- Sales
- 14
- Total
- KES 16K
- Days seen
- 10 of 31
Evidence
| Day | Sale | POS | Provider | Difference |
|---|---|---|---|---|
| 01 Aug | …79163 | KES 1,470 | KES 2,625 | KES 1,155 |
| 04 Aug | …86623 | KES 1,470 | KES 2,625 | KES 1,155 |
| 08 Aug | …82371 | KES 1,470 | KES 2,625 | KES 1,155 |
| 09 Aug | …15334 | KES 1,470 | KES 2,625 | KES 1,155 |
| 09 Aug | …91388 | KES 1,470 | KES 2,625 | KES 1,155 |
5 of 14 sales. Seen on 10 of 31 days, so it looks like a standing rule, not a one-off.
Likely reason (to confirm)
Same, three items assumed
What happens next
The finance officer writes one explanation for the group. When the finance manager accepts it, every sale in the group is resolved.
Glovo: provider KES 50 lower
13 sales with the same difference. One explanation covers them all.
- Aggregator
- Glovo
- Each sale
- KES 50 lower than the POS
- Sales
- 13
- Total
- KES 650
- Days seen
- 12 of 31
Evidence
| Day | Sale | POS | Provider | Difference |
|---|---|---|---|---|
| 01 Aug | …75761 | KES 1,700 | KES 1,650 | KES -50 |
| 03 Aug | …79041 | KES 1,550 | KES 1,500 | KES -50 |
| 03 Aug | …09036 | KES 3,700 | KES 3,650 | KES -50 |
| 06 Aug | …47489 | KES 2,000 | KES 1,950 | KES -50 |
| 15 Aug | …01125 | KES 1,490 | KES 1,440 | KES -50 |
5 of 13 sales. Seen on 12 of 31 days, so it looks like a standing rule, not a one-off.
Likely reason (to confirm)
Repeating difference: price list or packaging fee? assumed
What happens next
The finance officer writes one explanation for the group. When the finance manager accepts it, every sale in the group is resolved.
Bolt Food: provider KES 30 higher
10 sales with the same difference. One explanation covers them all.
- Aggregator
- Bolt Food
- Each sale
- KES 30 higher than the POS
- Sales
- 10
- Total
- KES 300
- Days seen
- 2 of 31
Evidence
| Day | Sale | POS | Provider | Difference |
|---|---|---|---|---|
| 29 Aug | …37874 | KES 1,250 | KES 1,280 | KES 30 |
| 29 Aug | …57434 | KES 1,350 | KES 1,380 | KES 30 |
| 30 Aug | …05998 | KES 2,060 | KES 2,090 | KES 30 |
| 30 Aug | …09816 | KES 3,150 | KES 3,180 | KES 30 |
| 30 Aug | …22345 | KES 1,150 | KES 1,180 | KES 30 |
5 of 10 sales. Seen on 2 of 31 days, so it looks like a standing rule, not a one-off.
Likely reason (to confirm)
Repeating difference: price list or packaging fee? assumed
What happens next
The finance officer writes one explanation for the group. When the finance manager accepts it, every sale in the group is resolved.
Inter-punch: rung up as Uber Eats, found in Glovo
Sale …29115 on 05 Aug
- Day
- 05 Aug
- Rung up as
- Uber Eats
- Found in
- Glovo
- Amount
- KES 3,250
- POS user
- Cashier 10 (pseudonym)
Evidence
An inter-punch is a sale rung up on the POS under the wrong delivery app or payment type, so its payment shows up under another one.
No Uber Eats order matches this docket. Glovo has an order for exactly KES 3,250 on the same day that no POS sale claims.
What happens next
Moving it changes only the aggregator on the record. No money moves, and nothing is said about the POS user.
Inter-punch: rung up as Uber Eats, found in Glovo
Sale …74803 on 08 Aug
- Day
- 08 Aug
- Rung up as
- Uber Eats
- Found in
- Glovo
- Amount
- KES 1,000
- POS user
- Cashier 01 (pseudonym)
Evidence
An inter-punch is a sale rung up on the POS under the wrong delivery app or payment type, so its payment shows up under another one.
No Uber Eats order matches this docket. Glovo has an order for exactly KES 1,000 on the same day that no POS sale claims.
What happens next
Moving it changes only the aggregator on the record. No money moves, and nothing is said about the POS user.
Inter-punch: rung up as Uber Eats, found in Glovo
Sale …97375 on 16 Aug
- Day
- 16 Aug
- Rung up as
- Uber Eats
- Found in
- Glovo
- Amount
- KES 700
- POS user
- Cashier 21 (pseudonym)
Evidence
An inter-punch is a sale rung up on the POS under the wrong delivery app or payment type, so its payment shows up under another one.
No Uber Eats order matches this docket. Glovo has an order for exactly KES 700 on the same day that no POS sale claims.
What happens next
Moving it changes only the aggregator on the record. No money moves, and nothing is said about the POS user.
Inter-punch: rung up as Uber Eats, found in Glovo
Sale …21942 on 21 Aug
- Day
- 21 Aug
- Rung up as
- Uber Eats
- Found in
- Glovo
- Amount
- KES 500
- POS user
- Cashier 11 (pseudonym)
Evidence
An inter-punch is a sale rung up on the POS under the wrong delivery app or payment type, so its payment shows up under another one.
No Uber Eats order matches this docket. Glovo has an order for exactly KES 500 on the same day that no POS sale claims.
What happens next
Moving it changes only the aggregator on the record. No money moves, and nothing is said about the POS user.
Inter-punch: rung up as Uber Eats, found in Glovo
Sale …22548 on 21 Aug
- Day
- 21 Aug
- Rung up as
- Uber Eats
- Found in
- Glovo
- Amount
- KES 700
- POS user
- Cashier 11 (pseudonym)
Evidence
An inter-punch is a sale rung up on the POS under the wrong delivery app or payment type, so its payment shows up under another one.
No Uber Eats order matches this docket. Glovo has an order for exactly KES 700 on the same day that no POS sale claims.
What happens next
Moving it changes only the aggregator on the record. No money moves, and nothing is said about the POS user.
Inter-punch: rung up as Bolt Food, found in Glovo
Sale …31581 on 09 Aug
- Day
- 09 Aug
- Rung up as
- Bolt Food
- Found in
- Glovo
- Amount
- KES 1,000
- POS user
- Cashier 01 (pseudonym)
Evidence
An inter-punch is a sale rung up on the POS under the wrong delivery app or payment type, so its payment shows up under another one.
No Bolt Food order matches this docket. Glovo has an order for exactly KES 1,000 on the same day that no POS sale claims.
What happens next
Moving it changes only the aggregator on the record. No money moves, and nothing is said about the POS user.
Inter-punch: rung up as Bolt Food, found in Glovo
Sale …82747 on 21 Aug
- Day
- 21 Aug
- Rung up as
- Bolt Food
- Found in
- Glovo
- Amount
- KES 500
- POS user
- Cashier 18 (pseudonym)
Evidence
An inter-punch is a sale rung up on the POS under the wrong delivery app or payment type, so its payment shows up under another one.
No Bolt Food order matches this docket. Glovo has an order for exactly KES 500 on the same day that no POS sale claims.
What happens next
Moving it changes only the aggregator on the record. No money moves, and nothing is said about the POS user.
Inter-punch: rung up as Glovo, found in Uber Eats
Sale …31312 on 03 Aug
- Day
- 03 Aug
- Rung up as
- Glovo
- Found in
- Uber Eats
- Amount
- KES 3,250
- POS user
- Cashier 10 (pseudonym)
Evidence
An inter-punch is a sale rung up on the POS under the wrong delivery app or payment type, so its payment shows up under another one.
No Glovo order matches this docket. Uber Eats has an order for exactly KES 3,250 on the same day that no POS sale claims.
What happens next
Moving it changes only the aggregator on the record. No money moves, and nothing is said about the POS user.
Sale …11348 · M-Pesa till
Missing settlement · 11 Aug
- Day
- 11 Aug
- Aggregator
- M-Pesa till
- State
- Missing settlement
- POS
- KES 22K
- Provider
- No record
- POS user
- Cashier 14 (pseudonym)
Evidence
No M-Pesa till record was found for this sale within the matching window. POS users are pseudonyms; nothing here is a finding about a person.
What happens next
Explain it, or ask the store for context. Only the finance manager can accept an explanation or confirm a loss.
Sale …51545 · Card machines
Missing settlement · 23 Aug
- Day
- 23 Aug
- Aggregator
- Card machines
- State
- Missing settlement
- POS
- KES 15K
- Provider
- No record
- POS user
- Cashier 05 (pseudonym)
Evidence
No Card machines record was found for this sale within the matching window. POS users are pseudonyms; nothing here is a finding about a person.
What happens next
Explain it, or ask the store for context. Only the finance manager can accept an explanation or confirm a loss.
Sale …84991 · Uber Eats
Refunded · 26 Aug
- Day
- 26 Aug
- Aggregator
- Uber Eats
- State
- Refund
- POS
- KES 11K
- Provider
- KES 11K
- POS user
- Cashier 07 (pseudonym)
Evidence
Uber Eats paid this order and then refunded the customer, but the POS kept the full sale. POS users are pseudonyms; nothing here is a finding about a person.
What happens next
Explain it, or ask the store for context. Only the finance manager can accept an explanation or confirm a loss.
Sale …80067 · M-Pesa till
Missing settlement · 26 Aug
- Day
- 26 Aug
- Aggregator
- M-Pesa till
- State
- Missing settlement
- POS
- KES 9,000
- Provider
- No record
- POS user
- Cashier 02 (pseudonym)
Evidence
No M-Pesa till record was found for this sale within the matching window. POS users are pseudonyms; nothing here is a finding about a person.
What happens next
Explain it, or ask the store for context. Only the finance manager can accept an explanation or confirm a loss.
Sale …10195 · Uber Eats
Amount variance · 15 Aug
- Day
- 15 Aug
- Aggregator
- Uber Eats
- State
- Amount variance
- POS
- KES 7,200
- Provider
- KES 7,900
- POS user
- Cashier 20 (pseudonym)
Evidence
Uber Eats recorded a different amount from the POS. POS users are pseudonyms; nothing here is a finding about a person.
What happens next
Explain it, or ask the store for context. Only the finance manager can accept an explanation or confirm a loss.
Sale …77839 · Uber Eats
Amount variance · 30 Aug
- Day
- 30 Aug
- Aggregator
- Uber Eats
- State
- Amount variance
- POS
- KES 6,750
- Provider
- KES 6,850
- POS user
- Cashier 18 (pseudonym)
Evidence
Uber Eats recorded a different amount from the POS. POS users are pseudonyms; nothing here is a finding about a person.
What happens next
Explain it, or ask the store for context. Only the finance manager can accept an explanation or confirm a loss.
Sale …84363 · Uber Eats
Cancellation · 10 Aug
- Day
- 10 Aug
- Aggregator
- Uber Eats
- State
- Cancellation
- POS
- KES 6,600
- Provider
- KES 6,600
- POS user
- Cashier 02 (pseudonym)
Evidence
Uber Eats marked this order cancelled, but the POS kept the sale. POS users are pseudonyms; nothing here is a finding about a person.
What happens next
Explain it, or ask the store for context. Only the finance manager can accept an explanation or confirm a loss.
Sale …85645 · Glovo
Amount variance · 26 Aug
- Day
- 26 Aug
- Aggregator
- Glovo
- State
- Amount variance
- POS
- KES 6,430
- Provider
- KES 6,815
- POS user
- Cashier 07 (pseudonym)
Evidence
Glovo recorded a different amount from the POS. POS users are pseudonyms; nothing here is a finding about a person.
What happens next
Explain it, or ask the store for context. Only the finance manager can accept an explanation or confirm a loss.
The list starts with the 9 patterns (584 sales), because one explanation clears many sales. About 613 more open sales are worked one by one in the same way.
Exceptions by day
Steady through the month, which points to process (prices, keying) rather than one bad day.
Table view
| Day | Amount variance | Missing settlement | Cancellation | Refund | Inter-punch |
|---|---|---|---|---|---|
| 01 | 19 | 15 | 15 | 3 | 0 |
| 02 | 16 | 17 | 8 | 3 | 0 |
| 03 | 14 | 3 | 10 | 1 | 2 |
| 04 | 20 | 10 | 2 | 2 | 0 |
| 05 | 12 | 10 | 8 | 0 | 1 |
| 06 | 13 | 5 | 1 | 1 | 1 |
| 07 | 18 | 8 | 4 | 0 | 0 |
| 08 | 24 | 16 | 6 | 0 | 2 |
| 09 | 19 | 10 | 7 | 0 | 1 |
| 10 | 14 | 3 | 5 | 0 | 0 |
| 11 | 9 | 3 | 6 | 2 | 0 |
| 12 | 20 | 6 | 8 | 3 | 0 |
| 13 | 27 | 9 | 5 | 1 | 0 |
| 14 | 25 | 22 | 8 | 0 | 1 |
| 15 | 22 | 15 | 3 | 1 | 0 |
| 16 | 17 | 15 | 9 | 2 | 1 |
| 17 | 25 | 9 | 6 | 1 | 1 |
| 18 | 26 | 7 | 1 | 2 | 0 |
| 19 | 16 | 5 | 2 | 1 | 0 |
| 20 | 25 | 7 | 3 | 2 | 1 |
| 21 | 13 | 18 | 4 | 1 | 3 |
| 22 | 15 | 10 | 2 | 5 | 0 |
| 23 | 24 | 10 | 2 | 1 | 1 |
| 24 | 19 | 5 | 4 | 1 | 0 |
| 25 | 12 | 6 | 3 | 1 | 0 |
| 26 | 21 | 9 | 6 | 1 | 0 |
| 27 | 31 | 5 | 2 | 1 | 0 |
| 28 | 39 | 10 | 6 | 0 | 1 |
| 29 | 47 | 16 | 5 | 2 | 0 |
| 30 | 55 | 10 | 7 | 5 | 0 |
| 31 | 35 | 7 | 2 | 1 | 0 |
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.