NAS Mail — Practical email, follow-up and inbox workflow guidance for small organisations.

How Bookkeepers Can Reconcile Merchant Payouts | NAS-MAIL

A merchant payout arriving in the bank may represent many underlying transactions rather than one sale. Sales receipts, refunds, processing deductions and settlement timing can all sit behind a single deposit. A bookkeeping review therefore needs to reconcile the payout to its settlement evidence instead of treating the bank amount as a complete description of trading activity.

Start with the bank deposit and settlement reference

Record the amount and date received in the bank, then identify the merchant settlement or payout report that appears to correspond with it. Use provider references where available. Similar amounts alone are not a reliable match, particularly where the business receives frequent payouts.

Understand the settlement components

Read the settlement evidence to identify the transactions included in the payout. Depending on the client's system, the report may distinguish sales, refunds, fees or other adjustments. Record only what the evidence actually shows. If a component is unclear, flag it rather than inventing a category based on how another payout was structured.

Connect sales to the correct period

The date money reaches the bank may differ from the dates of the underlying customer transactions. Keep settlement timing separate from the sales activity it represents. This is particularly important around period boundaries, where using the bank date as the only reference can obscure which transactions were included in the payout.

Make deductions visible

If the settlement report shows deductions between gross transaction activity and the net bank deposit, reconcile those components explicitly. A net deposit should not automatically be recorded as though it were the gross sales figure. Where the nature of a deduction requires accounting or tax judgement, route it to the responsible person rather than assigning a treatment merely to make the reconciliation balance.

Trace refunds and reversals carefully

A refund may reduce a payout, appear in a later settlement or create a separate movement depending on the provider and timing. Connect it to the available customer and merchant evidence rather than assuming every negative line has the same meaning. Unmatched reversals should remain on an exception list until their source is established.

Investigate withheld or delayed amounts

If the expected settlement does not equal the amount received, first check the provider's available report for timing differences or other documented movements. Do not label a difference as a fee, reserve or error unless the evidence supports that description. Record the unresolved amount and the question needed to move the reconciliation forward.

Prevent duplicate sales recording

Where sales data is imported separately from merchant payouts, the bookkeeping process should make clear that the bank deposit is settlement of underlying activity rather than an additional sale. Review integrations and manual entries for overlap. A duplicate can arise easily when one part of the workflow records customer transactions and another records deposits without a connecting control.

Close with a settlement-to-bank bridge

A completed reconciliation should show how the underlying merchant activity leads to the bank amount received, including any supported deductions or timing items. Preserve the settlement report and relevant references with the working record. The result is a transparent bridge between sales activity and cash receipt, making later review far easier than relying on the bank description alone.