Catering deposits, balances, and collections
Track deposits, interim collections, and paid supplier costs by event.
Restaurant and Café Pack · Excel workbook in Turkish
Results from the sample workbook
- Toplam tahsilat (TL)
- 69,132.75
- Açık alacak (TL)
- 28,995.94
- Güncel nakit katkı (TL)
- 17,577.94
Who can use it, and for what?
Catering finance and event leads
Track deposits, interim collections, and paid supplier costs by event.
A worked example from the workbook
The first sample row in the baseline has the following results. Toplam tahsilat (TL) 68.900, Açık alacak (TL) 27.600, Güncel nakit katkı (TL) 17.200, Finansman ihtiyacı (TL) 0. The table shows per-record averages across 16 fictional records. In-workbook field names are shown in Turkish.
| Measure | Sample result |
|---|---|
| Toplam tahsilat (TL) | 69,132.75 |
| Açık alacak (TL) | 28,995.94 |
| Güncel nakit katkı (TL) | 17,577.94 |
| Finansman ihtiyacı (TL) | 972.88 |
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.
- Record deposits and final payments separately. Enter overdue days for unpaid contract balances. Compare remaining supplier commitments with cash contribution.
- Choose a date range and group on Ayarlar (Settings). Compare the three editable values for “Kalan maliyet çarpanı”. The sample settings are 1 / 0,9 / 1,23. 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.
- Sözleşme (TL)
- Avans (TL)
- Ara tahsilat (TL)
- Bakiye tahsilatı (TL)
- Ödenen maliyet (TL)
- Gecikme günü
- Kalan taahhüt (TL)
Sample assumptions
- Kalan maliyet çarpanı
- 1