ExcelFlux
← Restaurant and café

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.

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

  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. Match the statement to the net deposit. Exclude platform-funded coupons from merchant promotions. Check the agreed commission base.
  3. 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.
  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.

  • 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