The verdict in three sentences
The amount Flutterwave (or Wave) credits to your account is never equal to the gross sum of your orders, because of fees, refunds and chargebacks. With manual CSV-and-VLOOKUP reconciliation, 8 % of orders stay unmatched and cost you 2 hours a week. Automatic matching on the transaction reference with a tolerance threshold drives that rate to near zero.
Anatomy of the gap between settlement and orders
When a 20,000 NGN order arrives, the provider does not credit you 20,000 NGN. It deducts its commission, holds a chargeback reserve, and shifts the payout to T+1. Multiply by hundreds of orders and the gap becomes impossible to track by eye.
| 2026 item | Value | Effect on the credit |
|---|---|---|
| Flutterwave local fee (Nigeria) | 1.4 % | Deducted at source |
| Wave cash-in fee | 1 % | Deducted at source |
| Settlement | T+1 | Shifted payout |
| Chargeback reserve | 0.3 % | Temporarily held |
| Matching tolerance threshold | 50 NGN / 50 FCFA | Absorbs rounding |
| Refunds | Separate debit | Isolate the line |
Manual (CSV + VLOOKUP) vs automatic matching
Export the settlement, open the orders, run a VLOOKUP column by column: the method works at small scale but collapses as volume climbs.
| Criterion | CSV + VLOOKUP | Auto match on reference |
|---|---|---|
| Time per week | 2 h | ~10 min |
| Unmatched orders | 8 % | < 0.5 % |
| Fee handling | Manual, error-prone | Computed automatically |
| Chargeback detection | Late | Immediate |
| Tolerance threshold | None (false gaps) | 50 NGN / 50 FCFA |
| Scaling | No | Yes, unlimited |
Building the mapping table
- Join key: the transaction reference, present on both the provider settlement and the order.
- Gross amount column (order) and credited amount column (settlement).
- Theoretical gap calculation: fee 1.4 % (Flutterwave) or 1 % (Wave) + 0.3 % chargeback reserve.
- Tolerance threshold of 50 units to absorb rounding.
- Exception queue: any line outside tolerance goes to human review.
Mini case study
Chiamaka runs an online fashion store in Lagos, 600 orders a week via Flutterwave, average basket 12,000 NGN. Manually, 8 % of orders went unmatched — 48 orders a week lost in the gaps — plus 2 hours of VLOOKUP every Monday morning. After setting up reference matching with a 50 NGN tolerance, her unmatched rate fell to 0.4 % (fewer than 3 orders) and reconciliation closes in 10 minutes. She reclaims nearly 8 hours a month and now catches every chargeback the same day.
Need a professional website?
Kolonell builds websites that attract clients, optimized for the Sénégalese market. Free quote in 2 minutes.
FAQ
Why does Flutterwave credit me less than my total sales?
Because it deducts a 1.4 % local Nigeria fee, holds 0.3 % for chargebacks, and pays out at T+1. On 100,000 NGN of sales, expect around 98,300 NGN credited.
What is the 50 tolerance threshold for?
To stop rounding differences of a few units being flagged as gaps. Below 50 NGN or 50 FCFA, the line is treated as matched.
How do I spot a chargeback in the settlement?
It is a separate debit line, often dated after the order. Automatic matching isolates it immediately instead of drowning it in the bulk.
Does automatic matching also work with Wave and MoMo?
Yes. The logic is identical: join key = transaction reference, theoretical fees 1 % (Wave) or 1.5 % (MoMo), tolerance adapted accordingly.
How long to set up a mapping table?
Expect a few days of integration depending on your platform. The payoff, around 8 hours a month plus chargeback detection, repays the initial effort quickly.
Let's talk about your project. We automate the matching of your Wave or Flutterwave settlement to your orders. WhatsApp +221 77 596 93 33.
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.
