Digital Africa11 min read

The Merchant's Daily Settlement Report: 2026 Template

Mohamed Bah·Fondateur, Kolonell
August 30, 2026
Share:
The Merchant's Daily Settlement Report: 2026 Template

The Merchant's Daily Settlement Report: 2026 Template

Digital Africa

The verdict in three sentences

Most merchants check their balance once a month, at close, and discover a fraud, dispute or abnormal fee far too late. A daily settlement report — gross collected, operator fees, net receivable, open disputes — cuts anomaly detection from 5 to 7 days to under 24 hours. In 2026 it is the cheapest and most profitable KPI in a shop's entire accounting.

The KPIs that must appear every day

A good daily report fits on one screen. The point isn't to show everything, but to show the six numbers that trigger an action. If any one leaves its usual range, an alert fires immediately.

Daily KPIWhat it revealsTypical alert threshold
Gross collectedReal sales volumeGap > 30 % vs 7-day avg
Operator feesReal cost of paymentsFees > 2 % of gross
Net receivableWhat will hit the bankNet < 96 % of gross
Transaction countTraffic and basket sizeDrop > 25 % vs prior day
Disputes / refundsFraud and dissatisfaction> 1.5 % of transactions
Pending settlementCash locked up> 48 h delay

Settlement T+0 vs T+1: the impact on the report

When the money actually reaches the bank changes how you read the report. A T+0 operator pays you the same day; a T+1 or T+2 one shifts your cash flow. The report must separate "collected" from "received in bank".

Operator / channelSettlement cycle (2026 order of magnitude)Indicative merchant feesCash-flow impact
Wave (merchant)T+0 to T+1~1 %Low
Orange MoneyT+1~1 to 1.5 %Medium
Free MoneyT+1 to T+2variableMedium
Stripe (international)T+2 to T+7~2.9 % + fixed feeHigh
CashT+00 %None but physical risk

Mini case study

Ibrahim runs a restaurant in Abidjan collecting on average 900,000 FCFA/day. Without a daily report, a waiter was quietly diverting refunds: the leak ran 11 days before it showed up at close, for a total of 165,000 FCFA. With a daily report alerting whenever refunds exceed 1.5 % of transactions, the anomaly would have surfaced on day 1, capping the loss at around 15,000 FCFA. On that single incident, the daily report would have saved him 150,000 FCFA.

FAQ

Need a professional website?

Kolonell builds websites that attract clients, optimized for the Sénégalese market. Free quote in 2 minutes.

Isn't a daily report too much for a small shop?

No, because it's automated: an email or notification at a fixed time, no intervention. Even a shop at 300,000 FCFA/day benefits from seeing its real net and disputes every morning.

What's the difference between collected and net receivable?

Collected is the gross paid by customers; net receivable deducts operator fees (often 1 to 2 %) and refunds. Net is what reflects your true cash flow.

How do I automate delivery?

We plug Wave/Orange Money statements into an engine that computes the KPIs and emails a report or feeds a dashboard every morning at 7 a.m. Setup takes a few days.

Does the report catch internal fraud?

Yes, indirectly: a spike in refunds or cancellations immediately leaves the range and triggers an alert, as in Ibrahim's case where 11 days of leakage would have been cut to 1.

Can I combine it with accounting reconciliation?

Absolutely. The daily report monitors day to day, monthly reconciliation validates the entries. Both share the same statement ingestion.

Let's talk about your project. We set up your automated daily settlement report on Wave and Orange Money. WhatsApp +221 77 596 93 33.

Tags:#reporting#settlement#collection#merchant#KPI#dashboard#cash flow#daily
Share:

Mohamed Bah

Fondateur, Kolonell

Passionate about digital and entrepreneurship in Africa, Mohamed has been helping Sénégalese businesses with their digital transformation since 2020. Founder of Kolonell, he believes every SME deserves a professional and accessible online présence.