The Settlement Timing Gap Between a Sale and a Stripe or Shopify Payout

When a customer checks out, the sale happens immediately, but the cash does not. Stripe and Shopify Payments hold the funds for a rolling settlement period and then pay them to your bank in a batch, net of their fees. The date of the sale and the date of the payout almost always differ, and at a period end they often fall on opposite sides of the line. That gap is the single most common reason an e-commerce profit and loss does not match the bank, and it sits alongside the [gross versus net payout trap](/blog/gross-vs-net-revenue-recognition-payout-accounting-trap/) covered separately. This piece is part of the [payment gateway reconciliation hub](/guides/payment-gateway-multi-channel-sales-reconciliation/).

What the settlement gap actually is

A payout from a processor is not one sale. It is a batch of transactions that cleared over the processor's settlement window, bundled together and deposited as a single net figure once fees, refunds and any reserve are taken out. Stripe in the UK typically pays on a rolling schedule a few days after each charge; Shopify Payments works the same way. So a payout that lands on Tuesday represents sales made over the preceding several days, and the money from sales made today will not arrive until later in the week. There is always a balance sitting in transit between the store and the bank.

Why it distorts the accounts at a period end

Within a month the gap usually washes through, because last month's in-transit sales arrive this month and this month's leave for next. The problem is the cut-off date. On 31 March, the sales of the last few days of March have been made but not yet paid out. If you record revenue only when the payout hits the bank, those sales fall into April, March revenue is understated, and the asset owed to you by the processor is missing from the balance sheet entirely. For a year end that feeds the tax return, the error moves taxable profit between two years.

The in-transit balance is an asset you own

Money sitting with Stripe or Shopify at the period end is yours; it is simply not in your bank yet. In accounting terms it is a receivable, often recorded in an undeposited funds or payment-processor clearing account. Recognising it does two things: it pulls the revenue into the period the sale was actually made, and it shows the closing balance the processor owes you. The next payout then clears that balance rather than creating new revenue, which is exactly how the figures should behave.

A clean cut-off method

• Record sales on the transaction date from the gateway report, not on the payout date from the bank.
• Run a clearing account for each processor. Sales debit the clearing account and credit revenue; fees are posted against the clearing account; payouts move the cash from the clearing account into the bank.
• At the period end, the clearing account balance equals the funds the processor is holding plus fees not yet deducted. Reconcile it to the processor's balance report for the same date.
• Carry that balance as a receivable on the balance sheet, so the period's revenue is complete and the closing position is right.

Worked example across a year end

A store makes £6,200 of sales between 28 and 31 March that Stripe has not yet paid out, with £210 of Stripe fees attached. If the books recognise revenue only on payout, March is short by £6,200 of sales and the £5,990 net owed by Stripe is nowhere in the accounts. Posting the sales to the clearing account on their transaction dates puts the full £6,200 into March revenue, charges the £210 fee to March, and leaves a £5,990 receivable at 31 March. When Stripe pays out in early April, the deposit clears the clearing account to nil rather than inflating April. The two years now carry the right revenue and the right tax.

Where the gap widens

The in-transit balance is larger, and the cut-off matters more, where the processor holds a reserve, where a new account is on a longer initial settlement delay, or where a payout schedule is weekly rather than daily. Disputed transactions and payment holds extend the gap further, which is why they are handled in the companion piece on [chargebacks, disputes and payment holds](/blog/reconciling-chargebacks-disputes-payment-holds/). For a multi-channel seller, each gateway has its own settlement timing, so the clearing-account approach has to run per processor before the figures are [consolidated across channels](/blog/consolidating-omni-channel-revenue-shopify-etsy-tiktok-amazon/).

Common questions about settlement timing

Should I record revenue on the sale date or the payout date?

On the sale date. Revenue is earned when the customer is charged and the order is fulfilled, not when the processor releases the cash. Recording on the payout date pushes end-of-period sales into the wrong month and hides the money the processor still owes you.

What is undeposited funds or a clearing account?

It is a holding account that represents money taken from customers but not yet in your bank. Sales land there first; the payout then moves the cash to the bank. Its balance at any date should equal what the processor is holding for you, which makes it easy to reconcile.

Does the settlement gap affect my VAT return?

It can, on a standard accruals VAT scheme, because the tax point is usually the date of supply, not the date you are paid out. Recognising sales on the transaction date keeps the VAT in the correct period. On a cash basis the timing differs, so confirm which basis you are on.

Why does my bank balance never match my sales total?

Because the bank only ever shows net payouts after fees, refunds and reserves, and always lags the sales by the settlement period. Matching the gateway's gross sales to the bank directly will never reconcile; matching both through a clearing account will.

The settlement gap is invisible most of the month and expensive at the year end. An e-commerce accountant can set up per-processor clearing accounts, reconcile the in-transit balance to your Stripe and Shopify reports, and make sure your cut-off puts every sale and its tax in the right period.