Export Payments to Accounting: Reconciliation with QuickBooks and Odoo (2026)

The verdict in three sentences

Reconciling multi-operator mobile money collections by hand costs in 2026 between 6 and 10 hours per month for 300 transactions and lets 1.5 to 3 % of unrecorded fees slip away. A structured CSV export, available from every PSP, cuts that time by three; an accounting connector or an ERP API removes it almost entirely. The technical key: a unique transaction reference that links each payment, each fee and each VAT line.

The three levels of accounting integration

It all depends on your volume and your tool. Below 100 transactions a month, a monthly CSV export imported into Excel or your ledger is enough. Between 100 and 1,000, a connector that pushes entries avoids re-keying. Beyond that, a real-time API to the ERP (Odoo, QuickBooks) becomes worthwhile, with automatic reconciliation of fees and VAT.

Fees, VAT and fields to map

The classic trap: recording the gross amount collected and forgetting the PSP commission, which distorts margin and VAT. Each export must separate the gross amount, the fees and the net credited. On tax, the mapping must handle 7.5 % VAT in Nigeria and 16 % in Kenya, or 18 % in the UEMOA zone. A unique transaction reference guarantees no line is counted twice.

Mini case study

Emeka, a restaurateur in Lagos, collects 350 transactions per month across three operators. His accountant spent 8 hours a month re-keying everything, with a recurring 2 % gap of unallocated fees — on revenue of 4,000,000 FCFA (about USD 6,500), roughly 80,000 FCFA mis-recorded every month. Moving to a normalized CSV export with a unique reference and 7.5 % VAT mapping, she drops to 2 hours a month and the gap falls below 0.5 %. Gain: 6 hours of work and a reliable tax base for filing.

Become a Kolonell referral partner

Back offices drowning in manual entry are everywhere. Refer them to Kolonell and earn a commission: 15 % + 5 % recurring on a showcase site, 12 % on e-commerce, 10 % on a marketplace, 8 % on an institutional project. A well-designed payment-to-accounting integration means a client who saves hours every month — and pay for you, without writing a single line of code.

FAQ

Do all PSPs offer a usable export? Yes, in 2026 CSV export is standard at Paystack, Flutterwave, M-Pesa, MTN MoMo and Stripe. The difference is whether fee and VAT fields are present and whether an API exists to automate.

How do I avoid duplicates when reconciling? Use the unique transaction reference from the PSP as the reconciliation key. It links the collection, the fees and the accounting entry, and prevents counting the same sale twice.

Should PSP fees be recorded separately? Absolutely. Gross amount, commission (1.5-3 % depending on operator) and net credited must appear on distinct lines, otherwise your margin and VAT are wrong.

QuickBooks, Odoo or Xero: which to choose? It depends on what you run. QuickBooks and Xero are common in anglophone markets; Odoo suits growing operations. All accept a CSV import or a connector; what matters is the VAT mapping (7.5 % NG / 16 % KE / 18 % UEMOA).

How long to set up a connector? A normalized CSV export takes a few days; a connector or ERP API needs more configuration but drops reconciliation from several hours to under one hour a month.

Let's talk about your project. We connect your mobile money collections to QuickBooks, Odoo or Xero with a unique reference and VAT mapping. WhatsApp +221 77 596 93 33.