Till handover and cash variance
Reconcile physical counts, POS activity and cash drops by shift.
Restaurant and Café Pack · Excel workbook in Turkish
Results from the sample workbook
- Beklenen devir (TL)
- 6,028.13
- Sayım farkı (TL)
- -338.13
- Açık (TL)
- 597.38
Who can use it, and for what?
Branch and shift managers
Reconcile physical counts, POS activity and cash drops by shift.
A worked example from the workbook
The first sample row in the baseline has the following results. Beklenen devir (TL) 5.770, Sayım farkı (TL) -80, Açık (TL) 80, Fazla (TL) 0. The table shows per-record averages across 16 fictional records. In-workbook field names are shown in Turkish.
| Measure | Sample result |
|---|---|
| Beklenen devir (TL) | 6,028.13 |
| Sayım farkı (TL) | -338.13 |
| Açık (TL) | 597.38 |
| Fazla (TL) | 259.25 |
How do you start with your own data?
- Start with Kılavuz (Guide). Replace the 16 fictional entries in the yellow cells on Veri (Data). Use an Excel date, a unique record ID and a branch or category. There are 64 ready-to-use input rows.
- Use one row per drawer and shift. Separate documented payouts from cash drops. Investigate shortages and overages separately.
- Choose a date range and group on Ayarlar (Settings). Compare the three editable values for “Sayım toleransı (TL)”. The sample settings are 20 / 5 / 50. Changing the scenario preserves source records.
- Panel shows the three cases and the group breakdown for the selected case. On Hesap (Calculations), check input flags and row-level decisions. To rename a group, use the same name on Settings and Data.
Workbook input fields
Labels appear in Turkish in the workbook.
- Açılış (TL)
- Nakit satış (TL)
- İade (TL)
- Belgeli çıkış (TL)
- Kasadan alınan (TL)
- Sayım (TL)
Sample assumptions
- Sayım toleransı (TL)
- 20