How to read a payment gateway settlement report

A gateway settlement report is the document that explains a deposit. Most merchants never open one, because the deposit arrived and the bank balance went up, and that feels like the end of the story.

It is the beginning of it. The deposit is a net figure. The report is where the gross sits, and where everything taken out of it is listed.

What the report is actually for

It answers one question: why is this number what it is?

A gateway does not send you money order by order. It accumulates transactions over a settlement period, subtracts what it is owed and anything reversed, and transfers the remainder. The report is the working that produced the transfer.

Which means the report has a shape you can rely on, whatever the provider. There is a batch, there are the transactions inside it, and there are the deductions applied to them.

The parts to find

Providers name these differently, so look for the concept rather than the word.

The settlement or payout identifier. The reference for this specific transfer. It is what you match to the credit on your bank statement, and it is the only thing in the report that will appear there.

The settlement period. The window of transactions this batch covers. It almost never matches a calendar day or your trading day, which is the single biggest source of confusion when people first try to tie a payout to a day's sales.

Gross transaction amount. What customers actually paid, before anything came out. This, not the deposit, is your revenue.

Fees. The processing charge, usually per transaction, sometimes with a fixed component and a percentage component. If you run several payment methods through one provider, the rate may vary by method, and the report should show which applied.

Refunds. A refunded sale reduces the settlement. Whether the original processing fee comes back varies by provider, and that detail is worth knowing before you build any assumption on top of it.

Chargebacks and disputes. A customer-initiated reversal, often with a separate administrative charge, and often landing in a settlement weeks after the original sale.

Adjustments and reserves. Corrections, or a portion withheld and released later. Both are legitimate and both make a settlement harder to tie out if nobody expected them.

The order reference. The single most valuable column, and the one most often missing or truncated. Without it, matching a settlement line to a sale is guesswork based on amount and timing.

Tracing one sale through it

Take a customer who paid RM180 on your storefront.

In the report, that appears as a transaction line with a gross of RM180, dated when the payment was authorised. A processing fee is deducted against it. If that customer later returns the item and you refund them, a separate line appears in a later settlement, reducing that batch by RM180, possibly without returning the original fee.

So one sale has produced entries in two different settlements, on two different dates, with a fee that may or may not have reversed. The order is one thing. The money is three events.

Now multiply by every order in a busy week, and you can see why "the deposit looks about right" is the approach most businesses fall back on, and why it quietly loses money.

The three mistakes this report exists to prevent

Recording the deposit as revenue. The most common and most costly. It understates your sales, hides your processing costs entirely, and makes your margin look better than it is while your bank balance disagrees. Doing it properly is the same discipline as recording marketplace sales correctly — the gross, the fee and the net are three facts, not one.

Assuming a settlement covers a trading day. It covers a settlement period defined by the provider. Any attempt to reconcile daily sales against daily deposits will produce differences that are not errors, and hours spent chasing them.

Treating refunds as though they cancel a sale. They reverse the money but they do not erase the transaction, the original fee may stay, and both events belong in your records. A refund handled as a deletion loses the fee you actually paid.

When to stop doing this by hand

Reading one settlement report carefully is a genuinely useful exercise and worth doing at least once, because it teaches you the shape of your own money.

Doing it every month across several gateways is a different proposition. The work is repetitive, rule-shaped and grows directly with order volume, which is the profile of something that should be automated: settlement lines matched to orders, fees attached to the orders that incurred them, and anything unrecognised put in front of a person rather than absorbed into a rounding difference.

The aim is not to stop understanding your settlements. It is to stop re-deriving them by hand every month.

The exercise that proves you can read one properly is taking a single bank deposit and accounting for every component inside it, to the sen — see decomposing a payout line by line. If the report cannot support that, the gap is in the data rather than in your reading of it — see gateway API or settlement file.

Common questions

Why does the settlement amount not match any day of sales?

Because it covers the provider's settlement window rather than your trading day, and it is net of fees, refunds and any adjustments that landed in the same window. Matching a payout to a day is the wrong unit; matching it to the transactions inside it is the right one.

Do processing fees come back when I refund a customer?

It depends on the provider and sometimes on how long ago the sale was. Check the specific terms rather than assuming, because if the fee does not return then a full refund costs you more than the sale earned.

What if a settlement line has no order reference?

Then it has to be matched on amount, timing and payment method, which is reliable for distinctive amounts and unreliable for common ones. If your provider offers a way to pass an order reference through at checkout, use it. It saves more time than any other single change.

How long should I keep settlement reports?

As long as you keep any other financial record, and ideally attached to the orders they relate to rather than in a folder of downloads. The value of a settlement report is highest when a specific transaction is questioned, which is exactly when a folder of PDFs is least helpful.

The document that explains the money

Every deposit has a reason for being the size it is. The settlement report is that reason, written down.

Read one properly and you will never again think of a payout as your sales figure. That, more than any individual number in it, is what the exercise is for.