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.
| Measure | Sample 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?
- 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.
- Use the same card turnover for both offers. Enter settlement delays in calendar days. Review dispute and refund fees separately.
- 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.
- 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