Fix 7 of 60 · Payouts & holds

How do I match Shopify payouts to my bank deposits?

A Shopify payout is sales minus fees, refunds, chargebacks and reserves, paid on its own schedule. Here is how to open each payout, export its transactions and tick it off against your bank.

Published Updated By Kishore, Axioprax5 min read
A Shopify payouts list with two payouts matched to bank deposits and one payout lower than expected because of a refund and fees.

Why does my Shopify payout never match my sales?

Because a payout is not a day of sales. It is a bundle of transactions that cleared on Shopify's schedule, with money taken out along the way. Shopify lists the usual reasons a payout comes in lower: processing fees are "deducted from your earnings before the payout is sent", refunds come out of "your next available payout", and a chargeback takes the payment amount plus "any associated dispute fees". Adjustments can push the figure up or down, and a reserve can hold part of your sales back for a while.

Timing adds to the confusion. Payout schedules count business days only, and Shopify says funds captured on Friday, Saturday and Sunday "are grouped and sent together as one payout". So Monday's deposit can carry three days of sales, minus Tuesday's refund from last week.

How do I know my books have a payout problem?

You probably do if any of these sound familiar:

  • Your accountant asks what a deposit was for and you have to guess.
  • Your sales report says one number for the week and your bank says another.
  • You see deposits on the bank statement with no idea which orders they cover.
  • A refund or chargeback from weeks ago turned up as a smaller deposit and nobody noticed.

None of this means money is missing. It usually means nobody has matched payouts to deposits one by one. That takes one sheet and a short weekly habit.

How do I fix it? (step by step)

Work through it with your Shopify admin open, and tick each step as you go.

0 of 7 done

  1. Open your payouts list.

    In your Shopify admin, go to Finance and click View payouts, or go straight to Finance, Payouts. Payouts are grouped by payout date. If your admin shows Money instead of Finance, an early access layout, click See all payouts in its Upcoming section.

  2. Open one payout and note its ID.

    Click the payout date, then the payout. Copy the payout ID, the status, the amount and the bank reference number into your sheet.

  3. Read the breakdown before the total.

    On the same payout page, check the breakdown of charges, refunds, adjustments, fees, reserves and retried payouts. This is where the gap between sales and deposit lives.

  4. Export the payout transactions.

    Still inside the payout, click the Export icon, then Export payout transactions. Shopify emails the CSV to you and the store owner.

  5. Tick it off against the bank statement.

    Wait for the status to read Deposited, then allow 1 to 3 business days. Find the deposit with the same amount and mark the row matched.

  6. Chase anything that does not match.

    Check Finance, Payouts, Pending and the Reserve figure for money not yet paid out. If a Deposited payout never lands, give your bank its bank reference number.

  7. Run a monthly check.

    Once a month, open Finance, Documents, Shopify Payments activity report to compare the period's earnings, fees, payouts and reserves in one place.

Sales, refunds, fees and reserves flow into one Shopify payout. The payout is opened and exported from Finance, Payouts, then ticked off against the matching bank deposit in a simple sheet.
Match payout to deposit, not sales to deposit. The payout breakdown explains the difference.

What should my matching sheet look like?

One row per payout, not per order. These columns work well: payout date, payout ID, status, charges, refunds, adjustments, fees, reserved funds, payout amount, bank reference number, bank deposit date, bank amount, difference and matched. The difference column is just payout amount minus bank amount, and it should be zero. Keep the exported CSV for each payout in a folder named by payout ID, so you can show anyone which orders sit behind a deposit.

The CSV columns Shopify gives you are Transaction Date, Type, Order, Card Brand, Card Source, Payout Status, Payout Date, Available On, Amount, Fee and Net. The Net column shows each transaction after fees, which helps when you need to explain one line of the breakdown.

When is this not the right fix?

This only covers Shopify Payments. Payments through third-party processors are not part of these payouts, and Shopify's activity report leaves them out, so they need their own sheet. PayPal depends on your country: where PayPal Wallet runs through Shopify Payments, such as the United States, it is already inside your payouts. If you sell in more than one currency, compare amounts in the payout currency only, because Shopify notes that differences can come from date ranges, time zones or currency. And if a payout shows Failed, the sheet will not fix it: Shopify says it points to an issue with your bank account, so check your bank details first.

What does it cost?

Nothing. The payouts page, the CSV export and the activity report are part of Shopify Payments, and any spreadsheet will do. The honest cost is the habit: a short weekly check is far easier than rebuilding a year of deposits from memory at year end.

Do it yourself, or have it done?

Done for you

We set it up in your store through a collaborator account, and tell you what it takes before you pay anything.

Frequently asked questions

Why is my Shopify payout lower than my sales?

Fees are taken before the payout is sent, and refunds, chargebacks with their dispute fees, adjustments and reserves can all reduce it. The payout's breakdown in Finance, Payouts shows which ones applied.

The payout says Deposited but it is not in my bank. Is it lost?

Not necessarily. Shopify says Deposited means the payout was sent, not that it has arrived, and it typically takes 1 to 3 business days depending on your bank. If it still does not show, give your bank the payout's bank reference number.

Can I export more than one payout at a time?

Yes. In Finance, Payouts, click View transactions, then Export, and choose a scope such as Items by date. Shopify emails the CSV to you and the store owner.

Is the Shopify Payments activity report enough for my accountant?

It is a good monthly summary, but Shopify says it is not a statement of revenue for accounting purposes and has a 3-day data delay. For individual deposits, use the payout pages.

Get the week's fixes by email

One email a week with the new fixes and their checklists. No sales emails. Unsubscribe any time.

Got a store problem we haven't fixed yet? Send it to us and it may become a future fix.

All fixes