Shopify Payments payout reconciliation
Match payout reports to bank deposits and the related order activity. Separate gross sales, discounts, refunds, processing fees and supported adjustments rather than treating the net payout as revenue.
For Shopify and Shopify Plus businesses
Shopify Accounting and Payout Reconciliation
Reconcile Shopify Payments and other gateway payouts to the bank, separate fees and refunds, and prepare records for inventory, month-end and CPA review.
The order report, payout and bank deposit are different records
Shopify records store activity, while the payment provider sends payouts according to its settlement process. A single payout may combine multiple orders, refunds, processing fees and adjustments. Posting only the net bank deposit can hide the gross activity and make the month-end figures hard to trace.
A dependable routine identifies the source report for each period, matches payout totals to the bank, and documents timing differences and unresolved items. Other gateways and sales channels should be reconciled separately before results are consolidated.
What the Shopify accounting workflow can cover
The exact scope depends on the store’s payment providers, order volume, inventory setup and accounting process. Work is based on available source records and the client-approved accounting policy.
Payment gateways and timing differences
Reconcile other agreed payment channels such as PayPal or Stripe from their own transaction and payout records. Track timing differences, unmatched deposits and unresolved items for review.
Refunds, disputes and gift-card records
Keep refunds, chargebacks and gift-card activity traceable to the source records and approved accounting treatment. Flag missing evidence or unusual balances instead of guessing at a correction.
Inventory and cost of goods sold
Prepare agreed inventory and COGS schedules from the purchase, fulfillment and stock records available. Valuation methods, cost assumptions and accounting-policy decisions remain with the client or its CPA.
Multi-channel sales
Keep Shopify distinct from Amazon, wholesale and other sales channels before consolidating results, so channel-level differences and duplicate posting risks remain visible.
Month-end close and CPA handoff
Prepare reconciliation schedules, exception notes and agreed reporting inputs that make the close easier to review. Sales-tax conclusions, tax advice and return filing remain with the client’s qualified adviser or provider.
A repeatable monthly reconciliation
1. Agree on the source reports
Confirm the Shopify, gateway, bank, inventory and accounting reports needed for each period.
2. Match payouts to the bank
Tie each payout to the corresponding deposit and related transaction report; separate fees, refunds and supported adjustments.
3. Record and document differences
List timing items, missing reports, duplicate postings and unexplained balances with source references and questions for the reviewer.
4. Prepare the close handoff
Provide the agreed reconciliation schedules and reporting inputs. The client or CPA retains approval of accounting treatment and tax decisions.
Related accounting resources
Clear accounting and tax boundaries
Accounstone provides defined accounting preparation and bookkeeping support within an agreed scope. The client retains banking control, accounting-policy decisions and approval of proposed adjustments. Sales-tax nexus determinations, tax advice, tax-return filing and software implementation remain with the client’s appropriately qualified adviser or service provider.
Shopify accounting questions
Frequently Asked Questions
Why do Shopify sales differ from the bank payout?
Orders and payouts do not represent the same event. A payout can include processing fees, refunds, chargebacks, adjustments and tax-related amounts, and it may arrive after the original sale. The reconciliation should connect the transaction or payout report to the actual bank deposit.
Can you reconcile Shopify Payments with QuickBooks Online or Xero?
We can review the exports, accounting file and current process to define a suitable reconciliation workflow. We work within the existing setup and do not assume a direct integration, connector or software change is required.
Can you include PayPal, Stripe or other payment gateways?
The agreed scope can cover the payment channels the business actually uses. Each gateway should be reconciled from its transaction or payout reports to the relevant bank activity, with fees, refunds and timing differences recorded separately where supported.
How should gift cards and customer refunds be handled?
Gift-card activity, refunds and chargebacks need to follow the client-approved accounting policy and the supporting transaction history. We can prepare records and schedules, while policy decisions and approval of unusual adjustments remain with the client or its CPA.
Do you provide Shopify tax advice or file sales-tax returns?
No. We can organize sales and transaction data for review by the client’s CPA or sales-tax provider. Nexus conclusions, taxability decisions, tax advice and filings remain with the appropriately qualified tax professional or service provider.
What is needed to scope Shopify accounting support?
Start with the accounting system, Shopify and payment-provider reports, bank statements, reporting periods, inventory or fulfillment records, other sales channels and the current month-end process. Access should follow the client’s approved security and permissions process.
How should Shopify payout timing differences be reflected at month-end?
Use the order, transaction and payout reports to identify the sale date, refunds or fees, payout date and actual bank receipt. Keep timing differences visible by settlement period so the accounting record does not treat the net deposit as a complete sales summary.
Can sales be reconciled across Shopify Payments and other gateways?
The scope can include Shopify Payments and other payment providers that the business uses, provided the relevant transaction or payout reports are available. Reconcile each provider's activity to its bank movement and keep processing fees, refunds, chargebacks and timing differences traceable.
What should be checked when Shopify refunds or chargebacks cross reporting periods?
Match the refund or chargeback to the original transaction and the period shown by the source report, then document how the amount appears in the payout and accounting ledger. The client-approved accounting policy determines period treatment; any unclear or unsupported item should be listed for review.
Does Shopify accounting support include store setup or software integration?
This page describes accounting preparation and reconciliation inside the existing workflow. It does not imply Shopify store configuration, connector implementation, migration or vendor technical support. The current reports, accounting system, access and reconciliation requirements should be confirmed before work starts.
Free consultation
Discuss Your Shopify Payout Workflow
Tell us which Shopify and payment-provider reports you use, how payouts are reconciled today, and where fees, refunds, inventory or month-end schedules need attention.
- Start with one client or one month of close work
- We prepare; your firm reviews, signs and e-files
- No EFIN, no banking control, no client-facing contact without your say-so
Make Shopify payouts easier to trace
Build a repeatable reconciliation routine around your existing store, payment providers and accounting records.