ExcelFlux
← Restaurant and café

Card processing contract comparison

Compare two merchant agreements by fees, fixed charges, and settlement delays.

Restaurant and Café Pack · Excel workbook in Turkish

Results from the sample workbook

A toplam maliyet (TL)
12,202.88
B toplam maliyet (TL)
13,039.44
B avantajı (TL)
-836.56

Who can use it, and for what?

Owners and finance teams

Compare two merchant agreements by fees, fixed charges, and settlement delays.

A worked example from the workbook

The first sample row in the baseline has the following results. A toplam maliyet (TL) 8.432,19, B toplam maliyet (TL) 10.876,3, B avantajı (TL) -2.444,11, A ve B gecikme farkı (gün) 11. The table shows per-record averages across 16 fictional records. In-workbook field names are shown in Turkish.

MeasureSample result
A toplam maliyet (TL)12,202.88
B toplam maliyet (TL)13,039.44
B avantajı (TL)-836.56
A ve B gecikme farkı (gün)10.94

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 the same card turnover for both offers. Enter settlement delays in calendar days. Review dispute and refund fees separately.
  3. Choose a date range and group on Ayarlar (Settings). Compare the three editable values for “Yıllık fon maliyeti”. The sample settings are %42 / %28 / %58. 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.

  • Dönem kart cirosu (TL)
  • A komisyonu
  • B komisyonu
  • A gecikme (gün)
  • B gecikme (gün)
  • A sabit (TL)
  • B sabit (TL)

Sample assumptions

Yıllık fon maliyeti
0.42