Shopify, Stripe and QuickBooks Reconciliation: Why Payouts Don't Match
Use payout-first exported evidence to connect Shopify orders, Stripe payout support, and QuickBooks deposits before any clearing or posting decision.
Try with sample files | View sample report
Problem statement
Shopify explains the order layer, Stripe explains the payout layer, and QuickBooks only sees the bank-side deposit. If the Stripe payout support is skipped, the QuickBooks deposit can look acceptable while fees, refunds, timing, and grouped activity are still unresolved.
Numeric example
| Line item | Amount |
|---|
| Shopify orders paid via Stripe | $6,420.00 |
| Stripe refunds | -$420.00 |
| Stripe fees | -$191.80 |
| Stripe adjustment or reserve movement | -$35.00 |
| QuickBooks bank deposit | $5,773.20 |
Why the numbers do not match
- Shopify payment status and gross order totals do not by themselves prove what cash reached the bank.
- Stripe balance transactions and payouts show the charges, refunds, fees, adjustments, and payout status behind the deposit.
- QuickBooks bank feeds usually expose only the final net deposit or cleared bank row.
- A clearing-account or connector workflow can hide unresolved payout logic if the review starts from the bank side only.
- Refunds, disputes, or adjustments can land in a different payout cycle than the original Shopify order date.
What files to export
- Shopify orders export with order ID, paid date, payment method, gross total, and refund detail for payments that actually settled through Stripe.
- Stripe balance transactions export with payout ID, type, amount, fee, net amount, source references, and timing fields.
- Stripe payouts export with payout ID, payout status, arrival date, and net payout amount.
- QuickBooks bank export with deposit date, amount, and bank-feed description for the transaction being reviewed.
- Optional clearing-account or sales-summary export when you need to confirm whether QuickBooks already contains a summary entry for the same payout.
Reconciliation workflow
- Start from the Stripe payout ID, payout status, arrival date, and QuickBooks deposit that should represent the same bank movement.
- Filter Shopify orders to payments that were actually settled through Stripe, not just all paid orders in the period.
- Group Stripe balance transactions by payout ID and separate charges, refunds, fees, disputes, and adjustments before any QuickBooks decision is made.
- Compare the grouped Stripe net amount to the Stripe payouts export before you compare it to the QuickBooks bank row.
- Use Shopify orders only as supporting detail after the payout-level cash movement already makes sense.
- Check whether QuickBooks already contains a clearing-account move, sales receipt, or manual deposit that duplicates the same payout evidence.
- Keep unsupported gaps as amount differences and retain the reviewed report before posting, clearing, or accountant handoff.
Review checks
- Starting from the QuickBooks deposit and backfilling the payout explanation after posting.
- Mixing Shopify orders from a non-Stripe gateway into the Stripe payout support.
- Treating an amount match as enough evidence while payout status or arrival timing is still unclear.
- Clearing or posting the QuickBooks deposit before the payout support is retained.
- Leaving the clearing account with an unexplained residue after the Stripe payout is supposedly matched.
How Reconcile Locally helps
- Keeps Shopify order context, Stripe payout support, and QuickBooks bank rows in one local review workflow.
- Separates payout proof from downstream accounting decisions instead of blending them into one spreadsheet step.
- Shows matched deposits, amount differences, grouped-row cases, and unresolved evidence separately.
- Exports a review-ready report you can retain with the QuickBooks deposit review or accountant handoff.
What still needs manual review
- Reconcile Locally does not replace QuickBooks, post accounting entries, or decide final ledger mapping.
- Multi-processor, reserve, grouped-settlement, and cross-period cases can still require another export or a qualified reviewer.
- Tax treatment, clearing-account design, and final posting logic remain separate accounting decisions.
Content review and sources
Written and reviewed by the Reconcile Locally product team. Last reviewed June 7, 2026.
Guidance is checked against current product behavior and first-party documentation where available. Reconciliation results still require human review.
Frequently asked questions
Should I start from Shopify or from Stripe?
Start from the Stripe payout when the question is about the bank-side deposit in QuickBooks. Use Shopify orders as supporting detail after the payout-level net movement is already explained.
Do I need a clearing account?
Many ecommerce bookkeeping workflows use one, but it is not the first analytical step. First prove the payout and bank movement, then confirm the accounting treatment with your accountant.
What if the QuickBooks deposit matches the Stripe net amount but Shopify orders still look off?
Keep reviewing. The payout can match the bank while some Shopify orders, refunds, excluded gateways, or timing effects still need separate explanation.
Can Reconcile Locally post to QuickBooks?
No. It prepares a reconciliation report from exported files. Posting accounting entries remains a separate workflow.