Shopify and QuickBooks Reconciliation: A Payout-First Checklist
Reconcile the payout, not a top-line sales number
The fastest way to create a confusing Shopify–QuickBooks reconciliation is to compare a bank deposit with Shopify sales for a calendar day. They describe different events.
Shopify’s payout reconciliation report is designed to show the transactions and adjustments associated with a Shopify Payments payout. QuickBooks’ Shopify connection guidance describes the integration setup, but a connected app does not remove the need to define the accounting treatment.
Start with one payout ID and one closed period:
- Identify the payout amount, currency, payout date, and transfer reference.
- Export or review the payout’s included transactions and adjustments.
- Find the corresponding clearing or deposit record in QuickBooks.
- Explain every difference before posting an adjustment.
- Keep the accounting owner responsible for final entries and close decisions.
Use a payout-first reconciliation worksheet
| Line | Shopify evidence | QuickBooks evidence | Question to resolve |
|---|---|---|---|
| Gross activity | Included orders and transactions | Sales or clearing entries | Is the scope identical? |
| Fees | Payout fee lines | Fee expense or clearing treatment | Was the fee posted once? |
| Refunds | Included refund lines | Refund or clearing entry | Is the refund in this payout period? |
| Disputes/adjustments | Payout adjustment lines | Matching liability/expense policy | Who owns the classification? |
| Net payout | Transfer amount | Bank feed or deposit | Does the transfer match after explanations? |
The worksheet is an evidence trail, not a journal-entry template. Tax treatment, revenue recognition, payout clearing, and account mapping depend on the business and its accounting policy.
Explain the common differences before changing anything
Fees and net deposits
A payment processor can transfer a net amount after fees. The payout report helps reconcile the transfer, while Shopify finance reports answer different sales questions. Shopify’s finance report definitions distinguish gross sales, net sales, and total sales; none should be silently substituted for a payout.
Refund timing
A refund may be associated with a different payout from the original sale. Record the payout period and source transaction before treating the difference as an error.
Disputes and adjustments
Do not collapse every adjustment into a generic “fee.” Preserve the provider’s wording and route any classification question to the accounting owner. That makes review, audit, and later reversal safer.
Multiple payment methods
Shopify Payments, other gateways, gift cards, and manual methods can settle on different schedules. Reconcile each settlement source to its own evidence rather than forcing them through one deposit comparison.
A controlled handoff between ecommerce and finance
Use three visible states:
| State | Meaning | Next owner |
|---|---|---|
| Ready to reconcile | Payout, period, currency, and bank evidence are present | Finance operator |
| Needs evidence | A transaction, refund, or mapping is missing | Ecommerce operator |
| Needs accounting decision | Evidence exists but classification policy is unclear | Controller or accountant |
BizSidekick can assemble authorized Shopify and connected operational evidence into a reviewable variance list. It should not claim to replace bookkeeping judgment or independently post a ledger change. For the related operating view of sales, ads, costs, and payouts, read Shopify profit after ads, COGS, fees, and refunds.
Close with a variance record
For each payout, retain the payout ID, expected and actual net amounts, included source records, open variance, owner, and resolution date. If the difference remains unexplained, keep the payout open for review instead of manufacturing a match.
When the team needs a cross-system evidence pack before the finance review, prepare a governed reconciliation review. The next action should be a confirmed accounting decision, not an automatic book entry.
Keep reading
Continue with a guide that supports your next ecommerce decision.
