Advanced Payment Gateway and Multi-Channel Sales Reconciliation

Multi-channel UK e-commerce sellers run three operational realities in parallel: orders placed on the store, payouts arriving in the bank, and the tax position implied by each. The three rarely match daily. Shopify Payments settles on a two-day rolling window; Stripe holds a rolling reserve; Klarna deducts merchant fees and credit losses before remitting; Amazon settles every fortnight against an opaque pool of fees, taxes, refunds, and reserves. Reconciling sales to deposits without a settlement-summary tool is where most brands lose hours each month or, worse, misstate revenue and VAT.

This pillar walks the major reconciliation pain points for UK e-commerce finance teams. Each section links to a detailed companion piece.

The four reconciliation domains

1. 1Sales-to-payout reconciliation: matching gross orders to the net deposit, accounting for fees, refunds, chargebacks, currency conversion, and platform reserves.
2. 2Multi-currency exposure: unrealised exchange differences between order date, settlement date, and bank credit date for USD, EUR, and other foreign sales.
3. 3Chargeback and dispute accounting: provisioning for the dispute reserve, recognising refunds, and clearing the receivable when the platform releases held funds.
4. 4Revenue-recognition decisions: gross vs net for marketplace sales, deferred revenue for gift cards, and the principal-vs-agent classification for dropship.

BNPL and processor fees

Buy Now Pay Later (Klarna, Clearpay, Affirm) charges merchant fees of 3% to 6% plus a fixed per-order amount, materially higher than card processing. The merchant fee is deductible against profit and recoverable as input VAT if the BNPL provider supplies a proper VAT invoice (rules differ by provider). Refunded BNPL orders may not reverse the original fee, depending on contract terms, which materially affects realised margin on returns-heavy categories.

Gross vs net revenue

For a Shopify direct-to-consumer brand, revenue is gross of card fees: a £100 order is £100 of revenue and ~£2.50 of processor fee expense. For marketplace sales where the marketplace controls the customer relationship, the principal-vs-agent test may push the seller to net revenue (commission only). Getting this wrong distorts both the top-line growth narrative and the VAT registration threshold.