Paystack settlement reports: reconciliation for your accountant (Lagos, 2026)

The verdict in three sentences

Paystack's settlement report holds everything your accountant needs, provided you map the key columns gross amount, 1.5% fee (NGN 100 flat, capped at NGN 2,000) and net. Because Paystack settles T+1 for local NGN and T+2 for international, timing your bank reconciliation matters more than with an instant rail. The one mistake to avoid: booking the net received without ever isolating the fee, which silently inflates your margin.

Understanding the settlement columns

The Paystack settlement report downloads from the dashboard (Transactions then Export) or via the API. Each row is a customer charge or a settlement movement. The columns that matter for bookkeeping are below.

The golden rule: amount = settlement_amount + fees. If that equality fails per line, there was a partial refund or an adjustment to investigate.

Fees vs settlement: the 2026 calendar

Paystack applies a tiered model: 1.5% + NGN 100 local, capped at NGN 2,000 per transaction, with the NGN 100 waived under NGN 2,500. International cards run higher. Here is the 2026 ballpark against an instant local rail.

On NGN 20,000,000 collected across, say, 4,000 transactions, the NGN 2,000 cap keeps large tickets cheap while the 1.5% dominates small ones; the blended fee lands near NGN 300,000. Trace every naira of it.

Mini case study

Chidi runs an online electronics store in Lagos and in October 2026 collects a gross of NGN 8,000,000 over 900 Paystack transactions. His report shows NGN 130,000 in cumulative fees and NGN 7,870,000 settled. The clean entries are: debit Bank NGN 7,870,000, debit Bank charges NGN 130,000, credit Sales NGN 8,000,000. Reconciling with the bank statement, he finds exactly NGN 7,870,000 in Paystack payouts. Before this method he booked NGN 7,870,000 as sales and lost the NGN 130,000 fee trail, understating deductible expenses by NGN 1,560,000 over the year.

FAQ

Is the settlement report in local time or UTC?

Timestamps are usually in WAT (UTC+1). For a clean month-end cut, confirm the timezone so a 31st sale is not pushed into the next period.

How do I book a Paystack refund?

A refund shows a refund or reversed status and a negative amount. You reverse the original sale: credit Bank, debit Sales, and adjust the fee if Paystack returns it (the flat NGN 100 is often not refunded).

Should I match every transaction or the daily total?

For low volume, line-by-line matching is ideal. Above 200 rows per day, reconcile the daily batch (Paystack net total = bank payout) and sample-check.

Can I automate the import into QuickBooks or Xero?

Yes. The Paystack API or a small script that reshapes the CSV feeds QuickBooks or Xero with a fixed column mapping as described above, including chargeback handling.

Are Paystack fees deductible?

Yes, they are bank/processing charges and are fully deductible against taxable profit, provided the export justifies them, which is why isolating them matters.

Let's talk about your project. We connect your Paystack settlement reports to clean, automated books with no re-keying. WhatsApp +221 77 596 93 33.