Knowledge

Reconcile artist storefront sales to a bank payout

A storefront report, a processor report and a bank feed answer different questions. The storefront records sales; a processor payout batches cleared funds; the bank records the transfer. Reconcile by order and payout ID, not by matching totals for the same month.

Bridge gross charges to processed funds

Twelve fictional orders post £540 of charges including shipping. One £45 order is refunded and the processor deducts £22 of fees. Net processed activity is £473. In this example no separate tax or currency conversion appears; retain those fields in real exports rather than folding them into fees.

One £80 order, already included in the £540, contributes £76 after its £4 fee, but is not yet available to pay out. A £397 deposit is therefore expected: £473 minus £76 carried into the next period. The gap between £540 and £397 is explained and should not be booked again as a loss.

  • Store order ID, charge ID, refund ID, fees, payout ID, currency and all relevant dates.
  • If the payment report contains a platform-funded discount, chargeback or currency adjustment, use the actual adjustment line rather than inferring it from the bank.

Tie the unpaid balance to the next run

If £397 arrives, mark the first payout reconciled but leave £76 open at the processor. Confirm that £76 appears in a later payout or explanatory adjustment. Close an item as resolved only when the promised onward movement is identifiable.

If only £387 arrives, investigate the remaining £10 separately. Check the payout record against the bank statement, then fees assessed outside the processor, bank FX, failed payouts and duplicate order exports. Do not force the difference into a fee account without evidence.

Figures referred to

Expected bank depositIllustrative
£397 (£540 charges less £45 refund, £22 fees and £76 not settled)Fictional worked example in this guide · as of 2026-11
Unexplained difference if deposit is £387Illustrative
£10Fictional worked example in this guide · as of 2026-11

Figures marked Illustrative show the shape of the market, not a quoted rate. The lessons keep the maintained, sourced numbers.

Primary sources

Common questions

Is the bank payout the right figure for shop revenue?

Not by itself. A payout can include sales from different periods and be net of fees, refunds and other adjustments.

Learn this properly

The interactive lessons on this topic, with sourced figures and live simulators: