ExcelFlux
← Restaurant and café

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.

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

  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. Enter sales, returns, and bank proceeds for each settlement batch. Verify the fee basis against processor terms. Count waiting days from batch close.
  3. 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.
  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.

  • Kart satışı (TL)
  • İade (TL)
  • Komisyon
  • Sabit masraf (TL)
  • Banka kredisi (TL)
  • Bekleme (gün)

Sample assumptions

Beklenen azami aktarım (gün)
2