Shopify Payout Reconciliation: Why Most Bookkeepers Get It Wrong

If you are using Shopify and your bookkeeping shows the full payout amount as revenue, your books are wrong. This is the most common mistake we fix when onboarding new e-commerce clients — and it can overstate your income by 15–30%, creating real tax problems.

What a Shopify Payout Actually Is

A Shopify payout is not your sales revenue. It is what Shopify transfers to your bank after deducting: Shopify transaction fees (0.5–2% depending on your plan), Payment processing fees (2.9% + 30¢ per transaction), Refunds already processed, Chargebacks, and Any reserve Shopify is holding. If you record the payout amount as income, you are recording the wrong number. Your gross sales, fees, and refunds need to be recorded separately.

The Correct Way to Record Shopify in QuickBooks

The proper bookkeeping entry for a Shopify payout involves three components: 1) Record gross sales as income when the sale happens (or at settlement), 2) Record Shopify fees as an expense (merchant fees account), 3) Record refunds as a reduction in revenue or a separate refunds account. The payout that hits your bank account is the net of all three — it should match what QuickBooks shows as the balance in a Shopify clearing account, not your income figure.

Using A2X to Automate This

A2X is the tool we use for almost all our Shopify clients. It connects directly to Shopify, reads every payout, and automatically creates a journal entry in QuickBooks or Xero that breaks the payout into gross sales, fees, refunds, and taxes. What takes a bookkeeper 3–4 hours per month to do manually, A2X does in about 30 seconds. The setup takes about an hour and pays for itself on the first month.

What About Sales Tax?

If you have sales tax enabled in Shopify, it appears in your payout reports as a collected amount. This is a liability — not your revenue — and must be posted to a Sales Tax Payable account, not income. Getting this wrong creates both incorrect revenue figures and potential compliance issues when you file your state sales tax returns.

Frequently Asked Questions