Delivery platform deduction audit
Check commissions, service fees, and merchant-funded promotions by order or settlement batch.
Restaurant and Café Pack · Excel workbook in Turkish
Results from the sample workbook
- Kesinti bazı (TL)
- 910.38
- Beklenen aktarım (TL)
- 638.6
- Tahsil farkı (TL)
- -40.6
Who can use it, and for what?
Delivery operators and finance teams
Check commissions, service fees, and merchant-funded promotions by order or settlement batch.
A worked example from the workbook
The first sample row in the baseline has the following results. Kesinti bazı (TL) 895, Beklenen aktarım (TL) 627,4, Tahsil farkı (TL) -29,4, Efektif kesinti oranı %33,18. The table shows per-record averages across 16 fictional records. In-workbook field names are shown in Turkish.
| Measure | Sample result |
|---|---|
| Kesinti bazı (TL) | 910.38 |
| Beklenen aktarım (TL) | 638.6 |
| Tahsil farkı (TL) | -40.6 |
| Efektif kesinti oranı | 32.28% |
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.
- Match the statement to the net deposit. Exclude platform-funded coupons from merchant promotions. Check the agreed commission base.
- Choose a date range and group on Ayarlar (Settings). Compare the three editable values for “Fark eşiği (TL)”. The sample settings are 5 / 1 / 12. 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.
- Brüt sepet (TL)
- İşletme promosyonu (TL)
- İade (TL)
- Sözleşme komisyonu
- Ek hizmet (TL)
- Aktarılan (TL)
Sample assumptions
- Fark eşiği (TL)
- 5