ExcelFlux
← Restaurant and café

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.

MeasureSample 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?

  1. 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.
  2. Use one row per drawer and shift. Separate documented payouts from cash drops. Investigate shortages and overages separately.
  3. 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.
  4. 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