Payment gateway settlements: how to reconcile payouts, fees and refunds

Payment gateway settlement reconciliation is the job of proving that every rand your customers paid online either reached your bank account or is explained by a fee, a refund, a chargeback or a payout that is still on its way. It sounds simple until the first month-end, when the gateway deposit in your bank statement is a single round-looking number that matches nothing in your sales report.

This guide explains why that happens and gives you a repeatable method to tie settlements back to individual payments, whichever gateway you use.

Why the payout never matches your sales

Most gateways don't pay you each transaction as it happens. They collect money from many customers, hold it for a settlement period, deduct their fees and then transfer the balance to your bank account. By the time it arrives, the deposit is a net settlement: gross sales, minus fees, minus refunds and reversals, sometimes minus a reserve, often covering several days of trading.

Common reasons the numbers don't line up:

• Fees are deducted at source. Your invoice was for R1,150 but the gateway kept its fee and paid you the rest.
• Timing. A payment made on the last day of the month may settle in the next month.
• Batching. One deposit covers many payments, sometimes from several days.
• Refunds and chargebacks are taken off later settlements, not the original one.
• Payment methods settle differently. Card, instant EFT and other methods on the same gateway can follow different settlement schedules.
• Account-level charges, such as monthly fees, may be posted separately from transaction fees.

If you post the bank deposit straight against your sales, the difference ends up in a suspense account that grows every month. The fix is to reconcile in two steps, not one.

The two-step method

Think of the gateway as a bank account of its own, sometimes called a clearing account.

1. Gateway to sales: match each payment the gateway collected to the invoice or order it paid. This proves your sales were collected.
2. Gateway to bank: match each settlement (payout) the gateway sent to the deposit in your bank account. This proves the money arrived.

Fees, refunds and chargebacks sit in between. When both steps balance, the clearing account is back to zero (or to the amount still waiting to settle), and you can explain every cent.

What you need before you start

The key that ties these together is the payment reference. If every payment carries a unique reference that is passed to the gateway and appears on its statement, matching becomes mechanical. If references are missing or reused, you are back to matching on amount and date, which breaks as soon as two customers pay the same amount on the same day. Our guide to payment reference best practice covers how to set them up.

Step by step: reconciling a settlement period

1. Import the gateway statement for the period

Download the statement or settlement report covering the dates in question. Daily statements make exceptions easier to find than one monthly file.

2. Match collections to payments

For each collection line, find the payment with the same reference and confirm the amount. Anything with no matching payment is an exception: a payment taken outside your billing system, a test transaction or a reference typed incorrectly.

3. Record fees against the payments they belong to

Where the statement shows a fee per transaction, record it against that payment so you know the net amount you actually earned. Account-level fees that don't belong to one payment go to a bank charges or merchant fees expense account.

4. Match refunds and reversals

Each refund line should correspond to a refund you issued. A reversal or chargeback you don't recognise needs attention quickly, because dispute deadlines are short. See chargebacks in South Africa for how to respond.

5. Match payouts to your bank

Each payout line on the gateway statement should appear as a deposit in your bank account with the same amount. A payout on the statement that never reached your bank, or one that was returned, is an urgent exception.

6. Work the exception list

Whatever is left is your exception list. Give every item an owner and a note explaining the decision. A short, explained list is a healthy reconciliation; a long list nobody touches is how errors become write-offs.

How to post it in your accounting system

A clean way to record gateway activity:

• Customer payment: debit the gateway clearing account, credit the customer (or accounts receivable) with the gross amount.
• Gateway fee: debit merchant fees expense, credit the clearing account.
• Refund: debit the customer or sales returns, credit the clearing account.
• Payout: debit your bank account, credit the clearing account.

At the end of the period the clearing account balance should equal money collected but not yet paid out. If it doesn't, the difference is in your exception list. If you use Xero, our Xero payment integration guide shows the same idea with a clearing account in practice.

Mistakes that make settlement reconciliation painful

• Posting the net deposit as revenue. You understate sales and lose sight of fees entirely.
• Reconciling monthly only. Problems are older and harder to trace. Weekly, or daily for busy accounts, keeps the list short.
• Ignoring small differences. A small unexplained amount often hides a missed refund or a duplicated payment.
• Different references in different systems. Use one reference from checkout to statement.
• Several gateways in one clearing account. Give each gateway or merchant account its own clearing account so their settlements don't blur together. If you run more than one provider, our article on multiple payment gateways covers the trade-offs.

How CentraPoint helps

Every CentraPoint payment carries a unique reference that is passed to the gateway, so it can be found again on the gateway's statement. When a payment completes, CentraPoint records the gateway fee and net amount whenever the gateway reports them.

On plans that include reconciliation, CentraPoint can fetch your Netcash merchant statements automatically every day once the account's statement access is set up, and you can import CSV statements from other gateways or your bank. Statement lines are matched by reference: collections confirm payments, fee lines are recorded against the payment they name, refund lines confirm refunds you recorded, returns and chargebacks are flagged, and settlements to your bank account are recorded as payouts. Anything CentraPoint can't match with certainty goes to an exception queue for a person to decide, rather than being guessed. Runs are safe to repeat, so importing the same statement twice doesn't create duplicates.

Results can be exported to CSV or Excel, and payments, refunds and invoices sync to Xero, Sage, QuickBooks or Zoho Books. See the reconciliation documentation for how matching works.

Frequently asked questions

Why is my gateway payout less than my sales?

Gateways usually deduct their fees, refunds and any reversals before paying you, and one payout can cover several days of payments. Reconcile the gateway statement line by line rather than comparing totals.

What is a gateway clearing account?

It is an account in your books that represents money held by the payment gateway. Customer payments go in, fees, refunds and payouts come out, and the balance should equal money collected but not yet settled to your bank.

How often should I reconcile gateway settlements?

At least weekly, and daily if you process a lot of payments. Shorter periods mean fewer exceptions and fresher information when something needs investigating.

What should I do with a payout that doesn't match any deposit?

Check whether it is still in transit or was returned by your bank. If neither explains it, contact the gateway with the payout reference and date, and keep it on your exception list until resolved.