Shopify Payments Payout Reconciliation: A Step-by-Step Monthly Workflow
How Shopify Payments payouts work—schedules, fees, reserves—plus a step-by-step monthly workflow to reconcile orders, payouts, and bank deposits.
The number that hits your bank account is almost never the number on your Shopify sales report. Processing fees, refunds, chargebacks, currency conversion, and reserve holds all sit between "customer paid" and "money deposited"—and if you never reconcile the two, you're running your business on a revenue figure that doesn't exist. This guide explains how Shopify Payments payouts actually work, why payout ≠ revenue, and gives you a monthly reconciliation workflow you can run in under an hour per store.
How Shopify Payments Payouts Actually Work
Shopify Payments doesn't pay you per order. It works on a capture → settle → pay out cycle:
- Capture. When a customer's payment is captured, the funds enter your Shopify Payments balance. Capture dates are recorded in UTC, which matters when a late-night order lands on the "wrong" day of your report.
- Settlement. Funds sit in a settlement window before they're eligible for payout. Shopify defines settlement time as "the amount of time between when a customer's payment is captured and those funds are available to be paid out." This varies by country: Australia is around 2 business days, most of Europe, Canada, the UK, and New Zealand around 3, Hong Kong and Singapore about 4, Japan 5, and Mexico up to 7. For US stores, Shopify quotes a minimum settlement of roughly 2–5 business days depending on the account.
- Payout. On your schedule (daily by default, or weekly/monthly if you configure it under Settings > Payments > Manage), Shopify batches all settled funds into one payout and sends it to your bank.
Three mechanics trip people up during reconciliation:
- Business days only. Payouts aren't processed on weekends or public holidays—they roll to the next business day. Funds captured on Friday, Saturday, and Sunday are grouped and sent together as one payout, which is why Monday's deposit is often 3x the size of a normal day.
- Bank lag. After Shopify sends a payout, it can take an additional 1–3 days to appear in your bank account. A payout marked "Deposited" in Shopify may still be in transit.
- Schedule changes delay funds. If you switch payout schedules (say, daily to weekly), pending payouts are held until the next applicable date on the new schedule.
Some countries also have a minimum payout amount—if your balance is below it, funds roll forward to the next payout. The US has no minimum.
Why Payout ≠ Revenue
If you take one thing from this article: a payout is a net settlement figure, not a revenue figure. Shopify's own troubleshooting docs list nine reasons a payout comes in lower than expected. Here's what actually gets netted against your gross sales inside each payout:
| Deduction | What it is | When it hits |
|---|---|---|
| Processing fees | Card rate per transaction (rate depends on plan and country) | Every transaction |
| Tax on fees | VAT/GST added to processing fees in some regions (e.g. EU, Australia, Singapore, Switzerland) | Every transaction where applicable |
| Refunds | Refunded amounts are deducted from your next available payout | When you issue the refund—often weeks after the original sale |
| Chargebacks | Disputed amount is pulled from your next available payout, plus a chargeback fee | The moment the dispute is filed, not when it's decided |
| Currency conversion | Conversion fee applied when your selling currency differs from your payout currency | At capture, refund, and chargeback |
| Adjustments | Manual or system balance corrections (can go either way) | Ad hoc |
| Reserves and holds | A portion of funds temporarily withheld against risk | Per Shopify's risk review |
| Negative balance carryover | If refunds/fees exceeded earnings in a prior period, the deficit is recovered from the next payout | After a bad period |
Two of these deserve special attention because of timing, not just amount:
Refunds create cross-period distortion. A June sale refunded in July inflates June's payouts and deflates July's. If you're selling in multiple currencies, it's worse: conversion happens at transaction time, so the exchange rate at refund usually differs from the rate at capture. Shopify recommends refunding the full amount in the customer's local currency, which means you can gain or lose money purely on FX movement between sale and refund.
Chargebacks are deducted immediately. When a dispute is filed, the full disputed amount plus the chargeback fee comes out of your next payout right away. If you win—which can take weeks—the amount comes back as a separate credit, and Shopify may refund the chargeback fee depending on your region. Reconciling a month with active disputes means tracking money that left and may or may not return. If disputes are a recurring line item for you, profit tracking that accounts for refunds and chargebacks is the difference between real margin and imaginary margin.
Reserves and Holds: When Shopify Keeps Part of Your Money
A reserve is a temporary hold on a portion—sometimes all—of your processed funds, kept as a buffer against future chargebacks and refunds. Shopify applies reserves after a risk review, typically triggered by dispute spikes, high refund volume, or category risk. Mechanically, reserves show up in your payouts as paired transactions:
- Negative reserve transactions reduce a payout by the amount being held.
- Positive reserve transactions release those funds back into a payout once the reserve period ends.
Your Shopify Payments page separates Payout balance (captured funds waiting for the next scheduled payout) from Reserved funds (money you can't access until the reserve expires). Before a reserve expires, Shopify reviews the account again and can keep, reduce, or raise it.
For reconciliation, the practical rule is: treat reserved funds as an asset, not lost revenue. Your books should show the held amount as receivable, and each month you should verify that positive reserve releases match the negative reserve entries from prior periods. A reserve that silently grows is an early warning sign about your dispute rate—worth catching before Shopify escalates.
The Monthly Reconciliation Workflow: Orders → Fees → Payouts → Bank
Here's a workflow that takes 30–60 minutes per store once you've run it twice. Run it in the first week of each month for the prior month.
Step 1: Pull the payout reconciliation report. In Shopify admin, go to Finance > Documents > Payout reconciliation report (you need Shopify Payments as your provider and finance permissions). Set the date range to the full prior month and, if you sell in multiple currencies, run it once per payout currency. The Summary section gives you: starting balance, account activity before fees, total fees, net amount, total payouts, and ending balance.
Step 2: Verify the balance equation. Check that starting balance + activity − fees − payouts = ending balance. If it holds (it should—this is Shopify's own ledger), your job is now explaining the pieces, not hunting for math errors. Note: the report can have up to a ~3-day data delay on recent transactions, which is why you reconcile last month, not the current one.
Step 3: Tie gross activity back to orders. Compare "account activity before fees" against your sales reports for the month. They won't match exactly, and the differences should be nameable: orders paid with third-party methods (PayPal, etc.) are excluded from this report, capture dates in UTC can shift orders across month boundaries, and pre-orders or delayed captures land when captured, not when placed. Anything you can't name goes on an exceptions list.
Step 4: Break down the deductions. Expand the Activity section of the report: Charges, Refunds, Disputes, Adjustments, Reserves & Holds, and Payouts each expand into line items. Alternatively, export the payout CSV from the Payouts page—it gives you Amount, Fee, and Net per transaction. Book fees, refunds, and dispute movements as separate ledger lines. Never book "net payout" as revenue; that single habit destroys your ability to see margin trends, and it makes tax season across multiple stores miserable because gross revenue and deductible fees are fused into one number.
Step 5: Match payouts to bank deposits. Take the list of payouts from the Payouts page and tick each one against your bank statement. Expect the 1–3 day bank lag: a payout dated June 30 is legitimately a July bank line. Match on exact amount; if an amount differs, check for bank-side wire fees or currency conversion by your bank. For any payout that never landed, confirm its status is "Deposited" in Shopify, then take the settlement date, amount, and currency to your bank.
Step 6: Log exceptions and carry-forwards. Open disputes (money out, decision pending), active reserves (money held, release date pending), and negative balances all cross month boundaries. Keep a small carry-forward list so next month's reconciliation starts with known items instead of mysteries.
Common Mismatches and What They Mean
- Bank deposit smaller than the payout list total → almost always the weekend grouping plus bank lag; the "missing" payout is next month's first deposit.
- Payout smaller than expected with no refunds visible → check Adjustments and Reserves & Holds in the reconciliation report; also check whether a negative balance from the prior period was recovered.
- Sales report and payout activity diverge by a large stable percentage → you're probably comparing all orders (including PayPal/third-party gateways) against a Shopify Payments-only report.
- Small persistent differences on international orders → currency conversion fees and FX drift between capture and refund.
Reconciling Across Multiple Stores
Everything above is per store, per payout currency. At 5+ stores the workflow compounds fast: five admins, five reconciliation reports, five bank feeds, and refunds that cross both months and entities. Two things keep it sane.
First, standardize the ledger. Same chart of accounts, same rule (gross revenue, fees, refunds, disputes booked separately) in every store, so reports are comparable and roll up cleanly—the foundation of any multi-brand portfolio accounting setup.
Second, centralize the data pull. Logging into each admin to export CSVs is the step people skip, and skipping it is how payout gaps go unnoticed for months. A consolidated dashboard like StoreFleet pulls revenue, payouts, and ad spend across all your stores into one finance view and auto-syncs order data to Google Sheets, so the monthly reconciliation starts from one dataset instead of a dozen exports. It also tracks disputes across stores sorted by evidence deadline, which matters because a missed deadline converts a "pending" reconciliation item into a permanent loss.
One caveat for international operators: Shopify Payments is only available to stores in supported countries, and settlement times, minimum payouts, and chargeback fee treatment all vary by country. If you're selling on Shopify from Vietnam through a US or UK entity, reconcile in the entity's payout currency and treat your own bank's inbound transfer fees as a separate line—they're not Shopify's deduction, and mixing them in hides the true cost of each layer.
Payout reconciliation isn't glamorous, but it's the only process that proves your revenue is real. Run it monthly, book gross and deductions separately, and the gap between "Shopify says" and "the bank says" stops being a mystery and becomes a checklist.
Sources
- Shopify Help Center — Getting paid with Shopify Payments
- Shopify Help Center — Understanding Shopify Payments payout timing
- Shopify Help Center — Scheduling your Shopify Payments payouts
- Shopify Help Center — Payout reconciliation report
- Shopify Help Center — Navigating lower or missing payouts
- Shopify Help Center — Overview of reserves in Shopify Payments
- Shopify Help Center — Chargebacks and inquiries
- Shopify Help Center — Currency conversions and exchange rates
- Shopify Help Center — Viewing your Shopify Payments payout fees