# Shopify Payout Reconciliation: Complete Guide

*Last updated: June 2026*

If you've ever looked at your Shopify payout and thought "this doesn't match what hit my bank account," you're not alone. Shopify payout reconciliation is one of the most confusing parts of ecommerce bookkeeping.

In this guide, we'll walk you through exactly how to reconcile your Shopify payouts so you always know where your money is going.

## What is Shopify Payout Reconciliation?

Payout reconciliation is the process of matching your Shopify payouts to your bank deposits and making sure all the numbers add up.

Sounds simple, right? It's not. Here's why:

- Shopify bundles fees inside payouts
- Multiple payment processors (Shopify Payments, PayPal, etc.)
- Refunds and chargebacks create timing differences
- Currency conversion adds another layer
- App fees are deducted separately

## Why Reconciliation Matters

If you don't reconcile properly:

1. **You overpay taxes** — reporting net payouts instead of gross sales
2. **You think you're more profitable than you are** — fees are hidden
3. **You miss money leaks** — unauthorized charges, app fees, etc.
4. **Your books are wrong** — making bad business decisions

## Step-by-Step Reconciliation Process

### Step 1: Export Your Payout Report
1. Go to Shopify → Payments → Payouts
2. Click "Export" for the period you want to reconcile
3. Download as CSV

### Step 2: Export Your Bank Statement
1. Log into your bank account
2. Download the same period as a CSV
3. Filter for Shopify deposits

### Step 3: Match Payouts to Deposits
Create a spreadsheet with these columns:

| Date | Shopify Payout | Bank Deposit | Difference | Notes |
|------|---------------|--------------|------------|-------|
| Jun 1 | $4,200 | $4,180 | -$20 | Currency conversion |
| Jun 8 | $3,800 | $3,800 | $0 | Perfect match |
| Jun 15 | $5,100 | $5,050 | -$50 | Held funds |

### Step 4: Investigate Discrepancies
Common reasons for differences:
- **Currency conversion fees** — if you sell internationally
- **Held funds** — Shopify holds funds for new accounts
- **Chargebacks** — deducted from future payouts
- **App fees** — some apps deduct fees separately
- **Timing differences** — payouts deposited on different days

### Step 5: Record in Your Books
Once reconciled, record:
- Gross sales (before fees)
- All fees (broken out by type)
- Net payout
- Any discrepancies

## Common Reconciliation Mistakes

### 1. Using Net Payout as Revenue
This is the #1 mistake. Your revenue is gross sales, not net payouts.

### 2. Not Breaking Out Fees
Don't just record "Shopify fees." Break them out:
- Transaction fees
- Payment processing fees
- Currency conversion
- App fees

### 3. Ignoring Timing Differences
Payouts don't always deposit on the same day. Track the dates carefully.

### 4. Not Accounting for Refunds
Refunds reduce your payout but may not be obvious in the payout report.

## How Often Should You Reconcile?

**Monthly** is the minimum. Ideally, you should reconcile:
- **Weekly** if you're doing >$100K/month
- **Monthly** if you're doing $50K-$100K/month
- **Quarterly** if you're doing <$50K/month (but monthly is still better)

## Automate Your Reconciliation

If this sounds like a lot of work, you're right. That's why we built Klarr.

We automatically:
- Pull your Shopify data
- Reconcile payments to bank deposits
- Break out all fees
- Deliver P&L, Balance Sheet, and Cash Flow
- All in 24 hours for $149/month

[Try Klarr free →](/)

## Free Reconciliation Template

We built a free [Shopify Financial Health Check](/tools/) that shows you:
- Your payout reconciliation status
- Hidden fees you're missing
- Your real profit margin
- A financial health score

[Try it free →](/tools/)