How to reconcile Stripe payouts with your sales records

To reconcile Stripe payouts with your sales records, work in two steps. First, match the amount that lands in your bank to the balance transactions Stripe included in that payout: payments, refunds, disputes, fees and adjustments. Then match those payments to the orders, bookings and invoices in your POS or booking system. A payout is a net figure that follows Stripe's settlement timing, so it seldom equals a single day's sales report.

For automatic payouts, Stripe's reports and API handle the first step. The second depends on how well your sales system and your payment records share references.

Why doesn't my Stripe payout match my sales?

• Fees come off before the money reaches you, so a payout is net of processing fees.
• Settlement takes time. Stripe's default for UK accounts is three business days, and payouts due on a weekend or bank holiday arrive the next business day.
• Refunds and disputes are deducted when they happen, often in a later payout than the original sale.
• Cash, house accounts, and voucher or gift card redemptions appear in your sales report but never pass through Stripe.
• Payments forwarded after an internet outage are processed later than the sales they belong to.
• If you run several connected accounts or legal entities, each has its own payouts.

What is a Stripe balance transaction?

Stripe creates a balance transaction for every movement of funds into or out of your Stripe balance. Card payments, refunds, payouts and some Stripe fees each have one, recording a gross amount, a fee and a net amount; the processing fee on a card payment sits on that payment's own balance transaction. Automatic payouts are the easiest to reconcile, because Stripe records which balance transactions each one contains.

Manual and Instant Payouts work differently. You choose their timing and amount, so Stripe cannot say which transactions they include, and reconciling them against your transaction history is your job.

If you reconcile through the API, pass the payout ID to the request that lists balance transactions and Stripe returns only the transactions in that payout. Stripe also sends a payout.reconciliation_completed webhook event, which a finance system can use to start matching automatically.

Stripe's payout reconciliation report covers automatic payouts and groups the transactions in each one by reporting category, such as charges, refunds and fees. Its itemised download lists every transaction with gross, fee and net amounts, and you can include custom metadata, such as an order reference, to match transactions to your own records.

How do you reconcile a Stripe payout step by step?

• Start from the bank statement. Note the payout amount and date, then find the matching payout in Stripe.
• List the balance transactions in that payout from the Dashboard, the itemised report or the API.
• Check the arithmetic: gross payments, minus fees, refunds, disputes and other adjustments, should equal the payout.
• Match each payment to an order or booking using a shared reference, such as an order ID stored in the payment's metadata.
• Investigate what is left: refunds against older sales, disputes, payments without an order, and card sales in your POS that have not settled yet.
• Post the result to your accounts, recording sales at gross and fees as a cost, so the payout clears your Stripe clearing account.

Here is a hypothetical payout broken down by reporting category, with net equal to gross minus fees:

The £4,812.40 in the bank is £5,000 of card sales, less £97.60 of fees and a £90 refund for an earlier sale. A sales report for the same period can show a higher figure because it includes cash and vouchers that never pass through Stripe.

How should Stripe payouts appear in your accounts?

A Stripe clearing account keeps the books tidy. Post card sales to it at their gross value, post Stripe fees out of it as a cost, and post refunds and disputes against it when they happen. Each payout then moves money from the clearing account to your bank account. At any point, the balance left on the clearing account should equal the funds Stripe is holding for you that have not yet been paid out, so a difference tells you something is missing.

Recording fees separately also shows what card acceptance costs you each month, which a net payout figure hides. Reconcile payouts at least weekly. A short list of unexplained items is easy to clear, and a dispute or an unmatched refund is much easier to trace a few days after it happens than at the month-end close.

How does Tiquo help with payout reconciliation?

In Tiquo, card payments are processed through Stripe and each payment stays linked to the order or booking it belongs to, so the second step of the method above starts from records that already share a reference. The Payments area in Tiquo's settings embeds the connected Stripe account's balances, payouts and disputes, so finance staff can look up a payout without leaving Tiquo.

For the files your accountant needs, Tiquo's Import & Export page includes Stripe payment and accounting exports for connected payment accounts. Order exports can list one row per order or one row per item sold, which covers the cash, voucher and free orders that never reach a payout, and the end-of-day export gives one summary row per trading day for a sublocation. Tiquo's integrations directory lists accounting tools including Xero, QuickBooks and Sage.