August 2026 / Cash observations
Draft run · not closedPrototype v0.2 · real August data, masked
For: store manager and finance manager · J6 · audit only

What do the POS and the deposit sheet show for cash?

Cash is observed, not reconciled. The figures below are what the files record: cash taken on the POS, deposits on the sheet, and the running difference.

Decisions this view supportsShow this audit view to the client (D5) · Whether cash reconciliation comes in a later version · What context the store adds
Cash taken on the POSKES 3.17M1,978 cash sales
DepositedKES 2.79M173 deposits, 1 Aug to 1 Sep
Difference, observedKES 373K11.8% of cash taken
Days with no deposit5all Sundays

Cash taken against cash deposited, running total

The shaded band is the difference between cash taken and cash deposited. It stays small until 26 Aug, when the POS took KES 331K in cash (a typical day is KES 96K) and KES 46K was deposited. It never closes after that.

01.00M2.00M3.00M4.00MPOS cash KES 3.17MDeposited KES 2.79M01 Aug04 Aug07 Aug10 Aug13 Aug16 Aug19 Aug22 Aug25 Aug28 Aug31 Aug
POS cashDeposited

Difference, day by day

Rises each Sunday (no deposit) and falls back with Monday's deposit, until 26 Aug. Before that day the difference was KES 42K. Hover a day for the figure.

0150K300K450K600K01 Aug04 Aug07 Aug10 Aug13 Aug16 Aug19 Aug22 Aug25 Aug28 Aug31 Aug
Table view
DayTakenDepositedRunning difference
01 AugKES 107KKES 68KKES 39K
02 AugKES 124KKES 0KES 162K
03 AugKES 115KKES 197KKES 80K
04 AugKES 91KKES 128KKES 43K
05 AugKES 98KKES 106KKES 34K
06 AugKES 94KKES 85KKES 43K
07 AugKES 98KKES 93KKES 48K
08 AugKES 108KKES 106KKES 50K
09 AugKES 111KKES 0KES 161K
10 AugKES 80KKES 203KKES 38K
11 AugKES 89KKES 81KKES 47K
12 AugKES 99KKES 94KKES 51K
13 AugKES 102KKES 122KKES 31K
14 AugKES 73KKES 75KKES 29K
15 AugKES 121KKES 86KKES 64K
16 AugKES 83KKES 0KES 147K
17 AugKES 90KKES 174KKES 63K
18 AugKES 62KKES 97KKES 28K
19 AugKES 96KKES 76KKES 49K
20 AugKES 91KKES 92KKES 47K
21 AugKES 97KKES 84KKES 60K
22 AugKES 96KKES 102KKES 54K
23 AugKES 74KKES 0KES 129K
24 AugKES 88KKES 137KKES 80K
25 AugKES 89KKES 127KKES 42K
26 AugKES 331KKES 46KKES 327K
27 AugKES 73KKES 83KKES 317K
28 AugKES 82KKES 72KKES 327K
29 AugKES 121KKES 34KKES 415K
30 AugKES 108KKES 0KES 522K
31 AugKES 77KKES 173KKES 426K
01 SepKES 0KES 53KKES 373K
One sale explains most of the differenceA single take away sale of KES 250K at 12:55 on 26 Aug (500 meals) was rung up as cash. Without it the difference would be KES 123K. The files cannot say whether it was paid in cash or rung under the wrong payment type; the store can add context (decision D5).
Audit only: what this page does not doCash reconciliation is outside the first version (original requirements §4.3). This page states whon the POS and the deposit sheet show and nothing more: no matching, no exceptions, no loss confirmation, and cash never reaches the HR report. The store can add context, such as float kept in the safe or a deposit banked under another date. Showing this view needs the client's OK (decision D5).

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