Online Sales Payouts: How to Reconcile Stripe, PayPal and Shopify in Your Books

By Di Ma, Project Manager 29 OCT 2026 · 4 MIN READ

If you sell online, the money arrives in your bank as payouts from Stripe, PayPal, Shopify Payments or a similar platform, and the payout never matches the sales. Fees have been taken off, refunds deducted, perhaps a chargeback, and one payout can cover dozens of orders over several days. Booking the payout as "sales" gets the income wrong, the fees invisible and the reconciliation impossible. Here's the right way.

The rule: book the gross, not the payout

Illustration with invented figures: gross sales of HKD 10,000, less platform fees of HKD 340 and a refund of HKD 500, equals a payout to the bank of HKD 9,160. A note says to book the gross sales as income, the fees as an expense, the refund against sales, and the payout as a transfer from the platform to the bank, so the platform's account comes back to nil. — Gross sales less fees and refunds is the payout: book each part separately, not the net.

Your income is the sales you made, not what's left after the platform's cut. The fees are a cost of doing business, and refunds reduce sales. Book each one separately, and the payout becomes what it really is: money moving from the platform to your bank.

Treat each platform as its own account

Give each platform (and each currency on it) its own account in the books, like a bank account. Sales, fees and refunds go in and out of it; payouts move its balance to the bank. At the end of each period its balance should equal what the platform says it's holding for you, ideally nil after the last payout.

One week of card sales through a payment platform (illustrative, HK$)
What	Entry
Sales	Dr Platform account 10,000 Cr Sales 10,000
Platform fees	Dr Payment processing fees 340 Cr Platform account 340
A refund	Dr Sales returns 500 Cr Platform account 500
The payout	Dr Bank 9,160 Cr Platform account 9,160

The platform account starts at 10,000, falls by 340 and 500, and the payout of 9,160 clears it to nil.

Use the platform's payout report

Every platform can tell you exactly what's in each payout. Use those reports, not the bank line:

Stripe: the payout reconciliation report groups each automatic payout with the payments, refunds, disputes and fees it settles, and the itemised CSV lists every transaction.
PayPal: the Activity Download report has gross, fee and net amounts for each transaction.
Shopify Payments: the payouts and activity reports break down transactions, fees and payouts.

Book from the report totals for the period (sales, fees, refunds, disputes), then match each payout to the bank.

The awkward cases

Disputes and chargebacks. The amount is taken back, often with a fee. Book it against sales and the fee as a cost; if you win the dispute, the money comes back.
Reserves and holds. Some platforms hold back part of your balance. It's still your money: it stays in the platform account until released.
Currencies. If you sell in several currencies, keep a platform account per currency and book the conversion when the platform converts (see multi-currency bookkeeping).
Timing. Sales at the end of the month are often paid out in the next. That's fine: they sit in the platform account at the month end, which is why it's an asset, not a mistake.
Marketplace sellers (Amazon, app stores) work the same way, with more fee types. Their settlement reports play the role of the payout report.

Quick test: does each platform account in your books equal the balance the platform shows for the same date? If it does, every sale, fee and refund has been booked. If not, a payout has probably been booked as sales.

How Certanta handles payment platforms

Each platform and currency as its own account, reconciled to the platform's statement or report each month, like a bank account (see bank reconciliation).
Sales at gross, with fees, refunds and chargebacks in their own lines.
Payouts matched to the bank as transfers between your own accounts, never counted as sales twice (see own-account transfers).
Fintech accounts by daily feed where available (see Airwallex, Wise, Mercury and Revolut).

Frequently asked questions

Why doesn't my Stripe or PayPal payout match my sales?

Because the platform deducts its fees, refunds, disputes and sometimes reserves before paying out, and one payout can cover many days of sales. The payout is the net of all of these, not your sales.

Should I record the payout or the gross sales as income?

The gross sales. Record the platform fees as an expense and refunds against sales, and treat the payout as a transfer from the platform to your bank.

How do I find what is in a Stripe payout?

Use Stripe's payout reconciliation report, which groups each automatic payout with the payments, refunds, disputes and fees it settles; the itemised CSV lists every transaction.

How do I reconcile PayPal?

Use PayPal's Activity Download report, which shows the gross, fee and net amount of each transaction, and treat your PayPal balance as its own account in the books.

How should chargebacks be recorded?

Record the amount taken back against sales and any chargeback fee as a cost. If the dispute is won and the money returned, record that as well.

What should the platform account balance be at month end?

The balance the platform shows it is holding for you on that date, including any reserve and any sales not yet paid out.

Online sales, booked at gross

Certanta keeps each payment platform as its own account in your books, reconciled to the platform's statement, so sales, fees and refunds each show where they belong.

Open the demo See pricing

This article is general information about bookkeeping for online sales, not accounting or tax advice. Platform reports, fees and payout terms change; check your provider's current documentation.