How to reconcile Shopify Payments payouts to bank deposits

Your bank statement shows one deposit from Shopify. Your orders page shows dozens of sales. The two never match, because each payout is charges minus fees, minus refunds, plus or minus adjustments and reserves. Reconciling means proving, payout by payout, that the deposit equals the sum of the transactions Shopify says it contains, and explaining any difference.

This guide does it in a spreadsheet using the transaction export from your Shopify admin. Menu names below are taken from the Shopify Help Center; Shopify notes that a new payouts view is rolling out, so your screens may look slightly different.

Step 1: Export the transactions

You have two options, and both give the same CSV columns (Shopify Help Center: Viewing and exporting your Shopify Payments payout details):

• One payout: go to Finance > Payouts, click the payout date (and the specific payout if there were several that day), then Export > Export payout transactions. Use this when you are checking a single deposit.
• A date range: go to Settings > Payments, click View payouts, then View Transactions, click Export, choose the range and click Export balance transactions. Use this for a month-end close.

The CSV is emailed to you and the store owner rather than downloaded straight away. Keep an untouched copy.

Step 2: Know the columns

The export has these columns: Transaction Date, Type, Order, Card Brand, Card Source, Payout Status, Payout Date, Available On, Amount, Fee and Net (Net is Amount minus Fee). Type tells you what each row is, for example a charge, a refund or an adjustment.

Rows with Payout Status = pending haven't been paid out yet. Filter them out of a month-end reconciliation, or you will be looking for money that hasn't left Shopify.

Step 3: Pivot per payout

Insert a pivot table on the export:

• Rows: Payout Date (then Type, if you want the breakdown)
• Values: Sum of Amount, Sum of Fee, Sum of Net

Each Payout Date row is now one expected deposit, with gross, fees and net side by side. If you had more than one payout on the same date, the pivot merges them; export those payouts one at a time instead (Step 1, first option).

Step 4: Add the bank deposits and a Difference column

Next to the pivot, list the matching deposits from your bank statement. Then add:

Difference = Bank deposit − Sum of Net

A zero means the payout is reconciled. Shopify's Payouts page also shows each payout's total and status, so you can check the pivot against it too. Note that a payout marked Deposited has been sent to your bank, but Shopify says your bank may still take 1 to 3 business days to show it. A deposit missing from the statement isn't necessarily a problem yet.

Step 5: Explain any difference

Shopify lists the common reasons a payout is lower than expected (Shopify Help Center: lower or missing payouts):

• Adjustments, which can increase or decrease a payout. Shopify's examples include chargeback_fee, chargeback_protection, shopify_collective_debit, shopify_collective_credit, seller_protection and tax_adjustment.
• Chargebacks, where the payment amount and any dispute fees are deducted.
• Refunds processed since the last payout.
• Reserves held against possible disputes, and payout holds.
• A negative balance from earlier fees or refunds being recovered.
• Currency conversion, if you get paid in a different currency from the one you sell in.
• Taxes on fees in some regions.

Most of these are already rows in your export, so they're inside Sum of Net. If a difference remains, open that payout in the admin: the overview breaks it down into charges, refunds, adjustments and reserves.

For a whole period, Shopify also offers the Shopify Payments activity report under Finance > Documents. It shows gross activity, fees, payouts and your ending balance for a date range and currency (Shopify Help Center: Shopify Payments activity report).

Step 6: Shopify Capital repayments

If you have a Shopify Capital loan, where the repayment shows up depends on your country and when you accepted the loan. Check your country's page in the Shopify Help Center. For the United States, Shopify says (Shopify Help Center: Shopify Capital in the United States):

• Repayments are a percentage of your daily sales.
• For loans accepted on or after March 9, 2026, repayments are collected from your Shopify Payments balance, so they reduce your payouts. (For merchants in Texas, this applies to loans accepted on or after September 1, 2025.)
• For loans accepted before March 9, 2026, repayments are still collected as automatic debits from your bank account. They appear as separate withdrawals on your bank statement, not inside the payout.

Either way, a Capital repayment is not a sales fee. Bookkeepers normally post the repayment against the loan in the books (a liability account), with the cost of borrowing handled as your accountant decides. Book it as an expense and you overstate costs and leave the loan balance wrong. Ask your accountant how to split the loan fee.

Step 7: Book the payout

A common pattern is a Shopify clearing account: post sales, fees, refunds and adjustments into it from the export, and record each bank deposit as a transfer out of it. When every payout reconciles, the clearing balance equals what's still pending in Shopify. Booking each deposit as a single sales figure hides your fees and refunds.

Doing it faster

There isn't a JWillum tool built for the Shopify Payments export yet, so the spreadsheet above is the way to do it. If you also take card payments directly through Stripe, StripeClear Journal does the same job for Stripe: it turns a Stripe Balance Transactions CSV into a balanced QuickBooks Online journal, with a clearing-account proof. It expects Stripe's export format, not Shopify's.

→ StripeClear Journal

Related tools

• Need complete rows for each order from the Shopify orders export? Shopify CSV Densifier fills in the blank order-level cells.
• Handing the books over? BooksExport Clean tidies QuickBooks Online and Xero exports for your accountant.