Shopify logoQuickBooks Online logoShopify → QuickBooks Online

One Shopify payout.Six accounts it belongs to.

A single Shopify Payments deposit mixes product sales, shipping income, sales tax you owe, discounts, refunds and processing fees. Ledgerzoom breaks every payout apart and posts each piece to the right account in QuickBooks Online.

Read-only access to orders and payouts via Shopify’s official API. Ledgerzoom never edits your store or products.

JE-3117Shopify Payments payout
Posted2026-03-14 02:21
AccountDebitCredit
1320 · Shopify ClearingPayout #84021 · net settled
8,575.22—
4050 · Discounts GivenCodes & automatic discounts
380.00—
4090 · Refunds & Returns7 refunded orders
265.00—
6220 · Merchant Processing FeesShopify Payments fees
262.18—
4010 · Product SalesGross sales, 186 orders
—8,450.00
4030 · Shipping IncomeShipping charged to customers
—420.00
2210 · Sales Tax PayableTax collected, 14 jurisdictions
—612.40
Totals9,482.409,482.40
BalancedPushed to QuickBooks Online

Every component of one Shopify payout, posted to its own account.

The reconciliation gap

Your payout is not your revenue

Shopify deposits one net number. Hidden inside it is tax you have to remit, shipping you charged, discounts you gave and fees you paid.

Customer charges$9,482.40Sales, shipping and tax across 186 orders
Fees, refunds & discounts$907.18Deducted or given away before payout
Bank deposit$8,575.22What your bank feed actually shows

Book the deposit as sales and $612.40 of tax you owe the state is now sitting in your income.

Sales tax ends up in revenue

Tax you collected on behalf of states is a liability, not income. Lumping it into sales overstates revenue and makes filing a guessing game.

Gross margin is meaningless

Without discounts, refunds, shipping income and fees on their own lines, you cannot tell whether a promotion or a carrier change actually worked.

PayPal and other gateways drift

Orders paid through PayPal, Shop Pay Installments or manual methods settle on different schedules and never tie back to Shopify on their own.

How it works

Shopify to QuickBooks Online, on autopilot

  1. Once, about five minutes

    Connect Shopify and QuickBooks

    Install via Shopify’s official app flow and authorize QuickBooks Online. Ledgerzoom proposes mappings for sales, shipping, discounts, refunds, tax and fees.

  2. Every night, unattended

    Orders and payouts are pulled nightly

    Ledgerzoom reads orders, transactions and payouts from every gateway, then groups them under the deposit that settled them.

  3. Before you wake up

    A summarized entry per payout

    One balanced entry per payout keeps QuickBooks lean — no thousands of invoices — while every order stays traceable in Ledgerzoom.

Capabilities

Built for how Shopify actually settles

Discount codes, partial refunds, gift cards and three payment gateways in one month. Ledgerzoom handles the messy parts so your P&L stays readable.

  • Sales tax as a liability

    Tax collected is posted to sales tax payable, split by jurisdiction if you need it, so filing ties straight to the ledger.

  • Discounts and promotions

    Discount codes and automatic discounts get their own contra-revenue line instead of silently shrinking sales.

  • Gift cards

    Gift card sales are booked as a liability and recognized as revenue only when redeemed.

  • Shipping income

    Shipping you charge customers lands in its own income account, separate from product sales.

  • Every payment gateway

    Shopify Payments, PayPal, Shop Pay Installments and manual payments each reconcile to their own clearing account.

  • Refunds and chargebacks

    Partial refunds, restocking and chargebacks reverse the right lines, including refunded tax and shipping.

  • Never posts twice

    Every sync is idempotent and keyed to the source ledger. A retry or re-run produces the same single entry, not a duplicate.

  • Review mode for accountants

    Queue entries for approval instead of auto-posting, with a full audit trail and one-click reversal.

  • Historical backfill

    Work backwards through prior months to clean up unreconciled activity on any connected channel.

Questions

Shopify questions, answered

Reconcile Shopify tonight.

Connect Shopify and QuickBooks Online in about five minutes. Tomorrow morning every payout is posted and your clearing account is already at zero.

Start your free trial
  • 14 days free, no card required
  • Every channel included
  • Live in about five minutes