Guide · Shopify accounting
How to reconcile Shopify payouts in QuickBooks or Xero
A Shopify Payments deposit is the final balance of many transactions. Reconciliation explains the activity first, then proves the exact amount that reached the bank.
The short version
The payout is a balance movement. It is not the sale.
Open one completed Shopify Payments payout, separate every category, post one balanced accounting summary, and match its net amount to the bank.
Open the payout
The payout details explain the deposit. The bank feed only confirms it arrived.
Preserve the activity
Keep sales, refunds, fees, disputes, and adjustments in their proper accounts.
Match once
The clearing balance should equal the Shopify transfer, with no second revenue entry.
Anatomy of one payout
Make $11,100 explain $12,000.
Shopify moves several types of activity through the balance before it sends cash to the bank.
Booking only the $11,100 deposit hides $900 of refunds, fees, disputes, and other movement.
Choose the right report
Start with payout details.
The source document must explain one transfer, category by category.
Use this
Payout details
Open the completed payout that matches the bank deposit. Its transactions and export provide the trail behind the transfer.
- One completed payout
- Transactions included in that transfer
- Expected amount and bank date
Do not confuse it with
Payments activity report
This report shows balance activity for a selected period. It can help investigate movement, but Shopify does not position it as an accounting revenue statement.
- Useful for balance activity
- Can span several payouts
- Not the starting document for one bank match
The five-step workflow
Follow the payout to the bank.
Working in this order prevents the most common duplicate-income mistake.
Match one completed Shopify Payments payout to one expected deposit.
Identify sales, refunds, fees, disputes, reserves, and adjustments.
Send each type of activity to the account where it belongs.
Create one entry whose clearing balance equals the expected payout.
Match the transfer to the entry already recorded. Do not create new sales.
QuickBooks or Xero
Same clearing logic. Different document.
Both systems should preserve the transaction categories and leave one net balance for bank matching.
QuickBooks Online
Post a summarized journal.
Separate journal lines record sales, refunds, fees, and mapped categories. The Shopify clearing balance equals the net payout.
Xero
Post an invoice or bill.
A positive settlement is commonly represented by an invoice. A negative payout may require a bill. The resulting balance is reconciled to the transfer.
One storefront, several money routes
Separate every gateway that settles elsewhere.
A Shopify order can exist even when Shopify Payments never holds or transfers its cash.
Storefront
Shopify orders
Orders describe what customers bought. Reconciliation follows the processor that actually collected the money.
Route by payment gateway →Native route
Shopify Payments
Use Shopify payout details and match the resulting balance to its bank deposit.
Shopify clearingExternal route
PayPal
Use a separate PayPal clearing workflow when funds settle through PayPal.
PayPal clearingExternal route
Stripe
Use Stripe payout reports when Stripe holds and transfers the money.
Open Stripe guide →Manual or automated?
Manual works while one payout stays simple.
You can export, total, post, and match a payout yourself. Automation becomes useful when rebuilding the same entry starts controlling the close.
The same category mapping repeats across many transfers.
Shopify Payments, PayPal, and Stripe need separate clearing routes.
Cash movement no longer explains store profitability.
Manual review becomes harder than posting the entries.
Four software routes
Choose by accounting destination and scope.
Entry price matters, but the deciding factor is usually COGS, multiple channels, or Zoho Books.
Link My Books
Creates one settlement summary per Shopify Payments payout and can route other gateways through clearing accounts.
A2X
Summarizes sales, refunds, discounts, taxes, fees, and other payout activity.
Synder
Connects a wider set of commerce and payment sources with summary or per-transaction sync.
Bookkeep
Posts summarized Shopify sales and payout activity to Zoho Books, QuickBooks Online, or Xero.
Which route fits?
Let the operating model decide.
Start with the narrowest tool that solves the real reconciliation problem.
Export and post the payout yourself while the work remains easy to review.
The focused settlement workflow and lower entry price make the comparison direct.
COGS begins on Basic, with Sage and NetSuite available beyond QBO and Xero.
One broader connector may be easier than a separate route for every source.
It is the specialist option here that posts Shopify summaries directly to Zoho Books.
The reports are not interchangeable
Use the source each platform creates.
The accounting principle stays consistent while the source document changes.
Before you mark it reconciled
Three controls must pass.
If any one fails, the payout still needs work.
The books show customer payments before Shopify deductions, not just the net deposit.
PayPal, Stripe, and other processors are not buried inside Shopify Payments.
The remaining Shopify clearing balance equals the exact bank transfer.
Frequently asked questions
Before you post.
What is a Shopify payout?
A Shopify Payments payout is a transfer of the available Shopify Payments balance to your bank. The amount can reflect customer payments, refunds, fees, disputes, adjustments and other balance activity.
Should I record a Shopify payout as sales?
No. The payout is the net result of several transactions. Record the underlying sales and deductions, then match the resulting balance to the bank deposit.
How do I reconcile Shopify Payments in QuickBooks Online?
Create or import a payout summary that separates the accounting categories and produces a net Shopify balance equal to the deposit. Match that amount to the corresponding transaction in the QuickBooks bank feed.
How do I reconcile Shopify Payments in Xero?
Post the Shopify payout activity into Xero so its net balance equals the expected transfer, then match that entry to the bank deposit during reconciliation.
Is A2X or Link My Books better for Shopify?
Link My Books currently has a lower starting price and focuses on QuickBooks and Xero settlement workflows. A2X supports more accounting platforms and includes COGS from its Basic plan.
What if my Shopify store also uses PayPal or Stripe?
Reconcile those gateways separately if their funds settle outside Shopify Payments. A clearing account can keep the Shopify order data separate from the processor that actually sends the money to the bank.
Final take
Explain the payout first. Use the bank as proof.
A small store can do this manually. Link My Books is the focused lower-cost route for QuickBooks or Xero. A2X adds COGS and more accounting systems. Synder covers a broader channel mix, while Bookkeep matters when the ledger is Zoho Books.