Bank and card-terminal reconciliation
Match expected net deposits with bank transactions by settlement batch.
Restaurant and Café Pack · Excel workbook in Turkish
Results from the sample workbook
- Komisyon bazı (TL)
- 28,195.31
- Beklenen aktarım (TL)
- 27,120.64
- Mutabakat farkı (TL)
- -715.14
Who can use it, and for what?
Cash office and accounting teams
Match expected net deposits with bank transactions by settlement batch.
A worked example from the workbook
The first sample row in the baseline has the following results. Komisyon bazı (TL) 27.730, Beklenen aktarım (TL) 26.785,83, Mutabakat farkı (TL) -305,83, Açık tutar (TL) 305,83. The table shows per-record averages across 16 fictional records. In-workbook field names are shown in Turkish.
| Measure | Sample result |
|---|---|
| Komisyon bazı (TL) | 28,195.31 |
| Beklenen aktarım (TL) | 27,120.64 |
| Mutabakat farkı (TL) | -715.14 |
| Açık tutar (TL) | 1,606.51 |
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.
- Enter sales, returns, and bank proceeds for each settlement batch. Verify the fee basis against processor terms. Count waiting days from batch close.
- Choose a date range and group on Ayarlar (Settings). Compare the three editable values for “Beklenen azami aktarım (gün)”. The sample settings are 2 / 1 / 4. 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.
- Kart satışı (TL)
- İade (TL)
- Komisyon
- Sabit masraf (TL)
- Banka kredisi (TL)
- Bekleme (gün)
Sample assumptions
- Beklenen azami aktarım (gün)
- 2