Why Your Shopify Payouts Never Match Your Bank | And How to Fix It

You made $18,430 in Shopify sales last week. But when the payout hit your bank account, it was $16,891. Where did $1,539 go? This gap confuses nearly every Shopify seller, and if you don't understand it, your books will always be wrong.

Why Shopify Payouts Are Always Lower Than Your Sales

Shopify doesn't deposit your gross sales. It deposits your gross sales minus a series of deductions. Every payout is net of:

• Shopify Payments processing fees, typically 2.4 to 2.9% + 30¢ per transaction depending on your plan
• Refunds processed, any refunds issued during the payout period are deducted
• Chargebacks, disputed transactions that have been resolved against you
• Shopify Balance transfers, if you use Shopify Balance, some funds may route there
• Adjustments, any billing adjustments Shopify has applied to your account

How to Reconcile a Shopify Payout Step by Step

Step 1: Download your payout report. In Shopify admin, go to Finances → Payouts → click on a specific payout to see the breakdown. You'll see gross sales, fees, refunds, and adjustments.

Step 2: Record gross sales as revenue. Book the full gross sales amount as income. Do not book the deposit amount as revenue.

Step 3: Book fees as expenses. Create a separate expense account for Shopify processing fees. Book the total fees from the payout report against this account.

Step 4: Record refunds. Refunds should be reversed against revenue (or booked as a contra-revenue account). Track them separately from fees.

Step 5: Confirm the math. Gross sales minus fees minus refunds should equal the exact deposit. If it doesn't, something is missing, dig into the adjustments line.

The Most Common Reconciliation Errors

Booking the bank deposit as sales. This understates revenue and buries your processing fees inside the revenue number rather than showing them as an expense.

Missing partial-period payouts. If a payout spans two calendar months (e.g., starts March 29 and deposits April 1), you need to accrue the revenue in March even though cash hasn't arrived yet.

Not tracking chargebacks separately. Chargebacks have a different operational implication than simple refunds. Track them in a separate account so you can spot patterns.

Should You Use A2X or a Native Integration?

Shopify has native integrations with QuickBooks Online and Xero. These work but need to be configured carefully, out of the box they often record net deposits rather than gross sales. A2X is a third-party tool that pulls Shopify payout data and structures it correctly for accounting software. Either approach works if configured properly.

The most important thing is consistency, pick an approach and apply it every payout, every month.