Reconcile Shopify Payouts to Your Bank Statement

TL;DR A Shopify payout is a net figure: customer payments collected through Shopify Payments, minus processing fees, refunds, chargebacks and other adjustments, paid to your bank as one deposit. To reconcile, first match each payout amount to a deposit on your bank statement, then break each payout into its parts using Shopify's payout details, and record gross sales, refunds, fees and adjustments separately in your books. Payments collected through other gateways such as PayPal arrive separately and need their own reconciliation. At month end, payouts still in transit are timing differences, not errors.

If you sell on Shopify, your bank statement probably shows a steady stream of deposits that don't match any single order. One day it's 1,284.17, the next 312.60. None of those numbers are your sales for the day. They're payouts, and each one bundles many orders, refunds and fees together.

That's fine for cash flow but awkward for bookkeeping. If you record each deposit as "sales", your revenue is understated (because fees were already taken out), your fees are missing, refunds disappear, and your sales tax or VAT figures may not line up. Reconciling payouts properly fixes all of that.

This guide explains how payouts work in general terms, how to match them to your bank statement, how to break them down, a worked example, and how to handle the awkward cases. Shopify's admin and reports change over time and differ by region and plan, so we describe them generally. Check Shopify's help center for your current screens.

How Shopify payouts work

When a customer pays through Shopify Payments, the money doesn't go straight to your bank. Shopify collects it, groups transactions over a period, deducts what's owed, and sends you a payout. Each payout has:

• A payout date and status (for example scheduled, in transit or paid).
• A net amount, which is what arrives in your bank.
• A list of the transactions included: charges (customer payments), refunds, chargebacks or disputes, reversals, and adjustments.
• The fees deducted from those transactions.

Payout timing depends on your region and account settings, and weekends and bank holidays can push deposits back. That's why a payout dated on a Friday might reach your bank on Monday or Tuesday.

A few important points:

• Only Shopify Payments transactions are in Shopify payouts. If you also accept PayPal, Shop Pay Installments, a third-party gateway or manual payments, those settle separately, each in their own way.
• Some charges may not be deducted from payouts. Depending on your setup, your Shopify subscription, app charges and other bills may be charged separately, for example to a card on file. Check your billing settings and treat these as their own expenses.
• Refunds and chargebacks reduce payouts. If refunds exceed sales in a period, the payout can be small, zero, or in some cases a debit from your bank.

What you need

• Your bank statements for the period, ideally converted to a spreadsheet. SheetStatement converts PDF statements to Excel or CSV and checks each statement's balance. The free plan covers 3 pages a month; Starter ($9), Pro ($19) and Business ($39) monthly plans cover more.
• Shopify's payout list for the period, with dates and net amounts.
• Payout transaction details for each payout, showing the gross amounts, fees and adjustments. Shopify generally lets you view and export payout and transaction details from the admin.
• Your books, whether that's accounting software or a spreadsheet ledger.

Step 1: match payouts to bank deposits

Start with the simplest level: does every payout appear in the bank, and does every Shopify deposit in the bank correspond to a payout?

Put the bank deposits from Shopify in one table and the payouts in another:

Bank deposits (from your statement):

Shopify payouts:

Figures are illustrative.

Match by amount, allowing a few days' gap between payout date and bank date. In Excel, a lookup works well:

=XLOOKUP(C2, Payouts[Net amount], Payouts[Payout date], "No match", 0)

For more robust matching, where two payouts might have the same amount, add a date window. Our guide to matching bank transactions in Excel covers lookups with tolerances.

Anything left unmatched needs a reason:

• A payout in transit at month end will appear in next month's bank statement. It's a timing difference.
• A bank deposit with no payout might be from another processor or a transfer you've mislabeled.
• A payout with no deposit that's marked paid needs investigating with Shopify or your bank.

Step 2: break each payout into its parts

Matching proves the cash arrived. It doesn't tell your books what the money was. For that, each payout needs to be split.

From the payout's transaction details, summarize:

Check that the components add up to the net payout:

=ROUND(Gross + Refunds + Fees + Adjustments - Net, 2)

That must be zero. If you've exported the payout transactions, a pivot table with transaction type as rows and summed amounts and fees is the fastest way to build this summary. See our bank statement pivot table guide for the technique.

Step 3: record the payout in your books

There are two common approaches. Your accountant may prefer one.

Approach A: a clearing account

Create a Shopify clearing account (a current asset, sometimes set up as a bank-type account in your software).

• Record sales, shipping charged and taxes collected into the clearing account as they happen, usually through an integration or a daily or weekly summary journal.
• Record refunds and fees against the clearing account.
• When the payout hits the bank, record a transfer from the clearing account to your bank account for the net amount.

If everything is recorded correctly, the clearing account balance equals payouts in transit at any point. At month end, that balance should match the total of payouts not yet in the bank. This approach handles in-transit payouts cleanly and makes the reconciliation self-checking.

Approach B: split the deposit

When the deposit appears in your bank feed or statement import, record it as a split transaction:

• Sales income for the gross charges.
• Refunds as a reduction of sales (or a separate contra-revenue account).
• Merchant fees as an expense.
• Adjustments to the appropriate accounts.

The parts add up to the deposit. This is simpler for low volumes but harder to manage with sales tax detail, and it records sales when cash arrives rather than when the order happened, which may not match how you need to report.

Whichever you use, the key point is the same: record gross sales and fees separately. Don't book the net deposit as sales.

Worked example: closing June

A small store sells through Shopify Payments and PayPal. June's bank statement shows three Shopify deposits totaling 3,644.65. Shopify shows four payouts dated in June totaling 4,550.07, with the last one, 905.42, in transit on 30 June.

Cash matching:

• Three payouts matched to bank deposits: 3,644.65.
• One payout in transit: 905.42. It appears on the July bank statement on 1 July.

Breakdown of June payouts (summarized from payout details):

All figures are illustrative.

Clearing account check at 30 June: if sales, refunds and fees were all recorded into the clearing account and the three paid payouts were transferred to the bank, the clearing balance should be 905.42, the in-transit payout. If it's different, something is missing: perhaps a refund recorded only in Shopify, or a fee not posted.

PayPal: PayPal sales don't appear in Shopify payouts. Reconcile them separately against PayPal's own activity and transfers to the bank. Our guide to PayPal statements in Excel covers that side.

Bank reconciliation: on the bank side, June's reconciliation shows three Shopify deposits as cleared. The fourth isn't a reconciling item for the bank, because it's in the clearing account, not the bank account, until it arrives. If you use approach B instead, the in-transit payout simply isn't recorded until July.

Chargebacks, disputes and reserves

Chargebacks and disputes. When a customer disputes a charge, the amount (and often a dispute fee) is typically deducted from a payout. If you win, it may be returned in a later payout. Record the deduction and any later reversal separately so you can see the net effect, and keep dispute fees as an expense.

Reserves or holds. In some cases, a portion of funds may be held back. That changes payout amounts without changing your sales. Note any held amounts, and make sure they're released and recorded in later payouts.

Negative balances. If refunds or chargebacks exceed sales in a period, Shopify may recover the difference from future payouts or from your bank. A debit from Shopify on your bank statement needs the same breakdown treatment as a deposit.

Currency and multiple stores

If you sell in multiple currencies, payouts are usually made in your store's payout currency, with conversion happening before the payout. Your books should record sales in your reporting currency following your accountant's method. If payouts go to a non-home-currency account, such as a multi-currency account, reconcile that account in its own currency first. Our guide to Wise statements in Excel covers multi-currency balances.

If you run several Shopify stores paying into the same bank account, keep a store column in your payout table. Matching by amount is harder when payouts from different stores land on the same day, so use each store's payout list and dates.

Sales tax and VAT

Gross charges usually include sales tax or VAT collected and shipping. For tax reporting, you'll typically rely on Shopify's sales and tax reports rather than payouts, because payouts are about cash timing. Payout reconciliation proves the cash side ties to Shopify. It doesn't, on its own, tell you how much tax you owe. This is general information, not tax advice; check with your accountant about how to report sales and taxes in your jurisdiction.

Linking to annual reporting

At year end, payment processors may issue information returns depending on your country and the volume processed. In the US, that can include Form 1099-K. Those forms usually report gross payment amounts, not net payouts, which is another reason to record gross sales and fees separately. Our guide to reconciling a 1099-K with bank deposits walks through tying gross reported figures back to what reached your bank.

Gift cards, discounts and shipping

A few kinds of activity regularly cause confusion because they affect sales figures and cash differently.

Gift cards. When a customer buys a gift card, you receive cash, but you haven't made a sale of goods yet. Many businesses record gift card sales as a liability and recognize revenue when the card is redeemed. When a customer pays with a gift card, there's a sale but no new cash in that payout. If your clearing account won't balance, gift cards are one of the first things to check. Ask your accountant how they want gift cards treated.

Discounts. Discounts reduce what the customer pays, so they reduce gross charges. They don't appear as a separate deduction in the payout. If you report gross sales before discounts, you'll need Shopify's sales reports to see the discount amounts.

Shipping and taxes. Customer payments usually include shipping charged and tax collected. Both are in gross charges, but neither is product revenue in the usual sense. Record them to the accounts your accountant uses for shipping income and taxes payable.

What to hand your accountant

If someone else prepares your accounts, a tidy monthly pack saves time and questions:

• The converted bank statement for each account, with the balance check showing zero.
• The payout list for the month, with each payout matched to a bank date.
• A summary of each payout's gross charges, refunds, fees and adjustments.
• A list of payouts in transit at month end.
• Separate summaries for each other payment processor.

Keep the files with consistent names by month. That pack also makes year-end and any review much easier. Our month-end close checklist shows where this fits in a wider routine.

A monthly routine

1. Convert the month's bank statements and filter for Shopify deposits.
2. Export the month's payout list and payout transaction details.
3. Match payouts to deposits. List any in transit.
4. Summarize each payout into gross, refunds, fees and adjustments, and check each sums to the net.
5. Record sales, refunds and fees (or confirm your integration did).
6. Check the clearing account balance equals payouts in transit.
7. Repeat for each other payment processor.
8. Reconcile the bank account. See our guide to reconciling a bank statement in Excel if you do this in a spreadsheet.

If you also sell through Stripe directly, the same ideas apply, with Stripe's own reports. See our guide to reconciling Stripe payouts to a bank statement.

Common problems

Deposits don't match any payout. Check for payouts from another store, another processor, or a payout split into two deposits by your bank's display. Also check that the bank statement row isn't a transfer from your own savings.

Revenue in the books is lower than Shopify's sales. You probably recorded net payouts as sales. Fees and refunds are hidden inside. Gross up the sales and record fees separately.

The clearing account won't go to zero (or to in-transit). Something was recorded on one side only. Common culprits are manual refunds, gift card sales and redemptions, and adjustments.

Duplicate deposits after importing statements and a bank feed. Check date ranges and see QuickBooks duplicate transactions after import if you use QuickBooks.

Get your bank data ready

Upload your bank statement PDFs to SheetStatement, check the balance, and download Excel or CSV so you can match Shopify payouts against real bank rows. The free plan includes 3 pages a month.

FAQ

Why doesn't my Shopify deposit match my sales?

A payout is net of processing fees, refunds, chargebacks and adjustments, and it groups transactions across a period. Break the payout into its components to see how it relates to sales.

Should I record the payout as sales?

No. Record gross sales, then refunds and fees separately. Recording net payouts as sales understates revenue and hides fees.

What is a Shopify clearing account?

An account in your books that holds Shopify activity until payouts reach the bank. Its balance should equal payouts in transit, which makes reconciliation self-checking.

Are PayPal sales included in Shopify payouts?

No. Payments through PayPal and other gateways settle separately and need their own reconciliation.

What about payouts that arrive in the next month?

They're timing differences. List them as in transit at month end and confirm they appear on the next bank statement.

Is this tax advice?

No. It's general bookkeeping information. Ask your accountant how to record sales, fees and taxes for your business.

How much does SheetStatement cost?

The free plan includes 3 pages a month. Starter is $9 a month, Pro is $19 and Business is $39.