Shopify payouts, explained

Reconciling Shopify with PayPal (or any second gateway) without losing your mind

The store shows one sales total. The bank shows deposits from two different companies on two different schedules. Here's the method that makes multi-gateway months tie out.

A plain-English guide for store owners

The short version: never reconcile the store total against the bank. Split by gateway first — Shopify Payments orders tie to Shopify payouts, PayPal orders tie to PayPal transfers — and give each gateway its own clearing account. Each side ties out alone, or the error hides forever.

Why the totals can never match directly

Shopify's analytics count every order, however it was paid. But the money takes separate roads: Shopify Payments batches its orders into payouts on its schedule and fee structure; PayPal keeps its orders, fees and holds entirely to itself. Two roads, two timetables, two fee tables — one combined sales report. The mismatch isn't an error; it's mixed plumbing.

The method: split, then tie out per gateway

One clearing account per gateway. Sales paid via Shopify Payments post to a Shopify clearing account; PayPal sales to a PayPal clearing account.
Tie Shopify Payments to its payouts. The Payouts → Transactions export shows gross, fees, refunds, reserves per payout — each deposit should clear its slice exactly.
Tie PayPal to its transfers. PayPal's settlement report plays the same role; its fees and holds live there, not in Shopify.
What's left in clearing = money in transit. A healthy balance is a few days of sales; a growing one means something isn't arriving.

The traps that catch people

An order 'missing' from a payout was usually just paid through the other gateway. A refund always exits through the gateway that took the money in. And month-end comparisons fail because each gateway holds a different in-transit slice at the cut-off. Split first and every one of these becomes visible instead of mysterious.

See it on your own payout

NetClear rebuilds each payout from your export and tells you in plain English exactly where every pound went — reserves, fees, refunds and all.

Try it — free →

Free while in early access · no card · your file is only ever read, never changed

Frequently asked

Why don't my Shopify sales match my deposits when I use PayPal too?

Because each gateway pays you separately. Shopify's sales reports total every order regardless of how it was paid, but the Shopify Payments payout only contains Shopify Payments orders — PayPal money arrives on its own schedule, with its own fees, in its own deposit. One sales number, two or more unrelated bank lines.

How do I reconcile Shopify Payments and PayPal together?

Reconcile each gateway to its own deposits, not the store total to the bank. For Shopify Payments use the Payouts → Transactions export; for PayPal use its activity/settlement report. Each gateway gets its own clearing account; sales flow in, that gateway's deposits flow out, and each should tie out on its own.

Which orders are in a Shopify Payments payout?

Only orders paid through Shopify Payments (including Shop Pay running on it). Orders paid with PayPal, Klarna or any third-party gateway never appear in those payouts — a common reason a payout looks 'missing' money that was simply paid elsewhere.

Why is the mismatch worse at month end?

Cut-off timing differs per gateway: Shopify Payments and PayPal each hold their own few days of sales in transit, so at month end each gateway has a different slice of sales not yet deposited. Comparing month sales to month deposits without those in-transit balances will never tie out.