Payment-provider reconciliation: payouts, fees and reserves

Set the facts for P-204

This fictional provider account, Demo EUR, settles September activity on 2 October. The merchant is the seller to customers. The source report contains customer collections for workshop bookings and equipment sales. These are gross settlement figures, not a VAT journal.

The teaching facts are explicit:

• Refund evidence R-17 identifies €450 of cancelled workshop bookings.
• Chargeback C-08 concerns a separate €200 equipment sale cancelled by agreement. The dispute is final, the sale is reversed and no recovery claim remains.
• Fee statements F-09 and B-09 support charges of €800 and €150.
• The opening reserve is €500, already recorded as due from the provider.
• All other opening balances and movements are zero.

A real chargeback can have a different outcome. These assumptions let this example resolve the amount without treating every dispute as an expense or cancelled sale.

Rebuild the €8,200 payout

Calculate the eight components:

€10,000 − €650 − €950 − €300 + €100 = €8,200.

The source download includes a separate total row. Exclude that row from the component sum; otherwise the expected payout would be counted twice.

Download the source report, bank record and completed answer sheet. All are synthetic teaching files, not product exports or an import-ready journal.

Prove the reserve and the whole provider balance

The following final balances are measured immediately after the 2 October payout. At 30 September, the total provider claim is €8,900: €8,200 awaiting payout plus €700 reserve.

The reserve reconciliation is:

€500 opening + €300 held − €100 released = €700 closing reserve.

The €300 hold moves part of the provider claim into retained funds. The €100 release moves an existing retained amount back into the payable settlement. Neither movement creates another sale or fee.

A second calculation proves the complete provider position:

The remaining claim agrees exactly with the reserve statement. The ordinary settlement-clearing balance is zero after the payout; the retained reserve is €700. If the accounting keeps both in one control account, its €700 balance must still be explained by that reserve detail.

Match identity and timing at the bank

The bank record shows €8,200 received on 2 October into the demo operating account, with P-204 in the reference. Compare provider account, payout reference, currency, direction and amount.

At 30 September, an announced payout that has not reached the bank remains a provider claim, according to the underlying settlement facts. The 2 October receipt then clears it. Do not move September sales into October merely to match the bank date.

An equal amount on another account or from another provider is not sufficient evidence of the same payout.

Translate the reconciliation into accounting entries

Record the underlying sales and their VAT from the transaction evidence. Record the €450 refund and the separate €200 final cancellation against their original sales. Determine the fees’ expense and VAT treatment from the fee documents. Transfer the reserve amounts between the relevant provider balances and settle the €8,200 bank receipt against the provider claim.

These figures prove gross settlement completeness. They do not assume that a provider’s fee label determines VAT or that all sales have the same tax treatment. The total gross effect must still match the reconciliation after the appropriate net and VAT splits.

If a chargeback remains disputed, preserve its separate status and assess the remaining claim. Replacing it with a fee merely because it lowers the payout would change the economics.

Reuse the work with a meaningful control

Hans can interpret supported settlement formats, produce the associated bookkeeping and match their bank payouts. Reuse should preserve component meaning as well as arithmetic.

A useful recurring control compares the new report’s fields and totals with the established format. An unfamiliar deduction needs an explanation before it inherits an old treatment. The changed-format guide covers that investigation; bank reconciliation connects the payout to the full bank account.