Multi-Branch, Multi-Currency Reconciliation in One Consolidated Dashboard (2026)

The verdict in three sentences

When you run several stores across countries and currencies (FCFA, GHS, NGN, KES), reconciling via separate per-PSP exports becomes an unmanageable spreadsheet: the monthly close takes 6 to 12 hours and concentrates 3 to 5 % of data-entry errors. The 2026 solution is a consolidated dashboard with a single reconciliation key and three-way reconciliation (order, PSP, bank account). Result: a 30 to 60 minute close and FX gaps frozen at the day's rate.

Separate exports vs consolidated dashboard

The single reconciliation key

The heart of the system is a unique reference attached to each order at creation and propagated everywhere: order side (your database), PSP side (transaction metadata) and bank statement side (label or transfer reference). Without it, you reconcile "by hand" on amount and date — the source of errors.

Three-way reconciliation compares: what the customer ordered, what the PSP says it collected, and what actually landed on the bank account after payout. A gap between any of these fires a targeted alert rather than a manual hunt.

Multi-currency: freeze the day's rate

Across countries, a payment in GHS, NGN or KES must be converted to the reporting currency (often FCFA) at the transaction day's rate, not the rate at close time. Otherwise FX swings create artificial gaps impossible to explain to the accountant. The dashboard freezes the rate at each operation's date.

Source and responsibility plan

Mini case study

Moussa runs 4 stores (Senegal, Côte d'Ivoire, Ghana, Kenya), 6,000 orders/month total, 3 PSPs and 3 currencies. Manually, his close takes 2 people for 10 hours each, i.e. 20 h/month, with an estimated 4 % error rate (240 lines to re-check).

With a consolidated dashboard, the close drops to 45 minutes. Gain: ~19 h/month of skilled work. At an estimated loaded cost of 4,000 FCFA/h, that is 76,000 FCFA/month, i.e. 912,000 FCFA/year, not counting the end of unexplained FX gaps and data-entry errors.

Become a Kolonell referral partner

Do you know merchants or multi-country groups drowning in reconciliation spreadsheets? The Kolonell referral partner program pays you for every project signed thanks to you. Commission rates: showcase 15 % + 5 % recurring, e-commerce 12 %, marketplace 10 %, institutional 8 %. A single qualified introduction on an e-commerce or marketplace project can mean several hundred thousand FCFA in commission.

FAQ

Why is a spreadsheet no longer enough across countries? Because a manual close takes 6-12 h and concentrates 3-5 % of data-entry errors. Multiply by several currencies and PSPs and the file becomes impossible to audit. A consolidated dashboard drops to 30-60 min.

What is three-way reconciliation? It compares the order, what the PSP says it collected, and what actually lands on the bank account. A gap between the three fires a targeted alert instead of a manual search.

How do you handle multiple currencies? Freeze the FX rate at each transaction's date, not at close. Otherwise FCFA/GHS/NGN/KES swings create artificial gaps impossible to justify.

What is the most important building block? The single reconciliation key, propagated from the order to the PSP to the bank statement. Without it you reconcile by hand on amount and date — the main source of errors.

How long to set this up? Depending on the number of PSPs and countries, an order of magnitude of a few weeks. Payback comes fast: dozens of close hours saved every month.

Let's talk about your project. We build your multi-country, multi-currency reconciliation dashboard, single key and three-way included. WhatsApp +221 77 596 93 33.