How to Reconcile Shopify and Stripe in QuickBooks Online
The Ecommerce Reconciliation Nightmare
If you run an ecommerce business, you likely use Shopify to process orders and Stripe (or Shopify Payments) to collect the cash. One of the most common bookkeeping nightmares I see is trying to make the sales data in Shopify match the deposits hitting your bank account in QuickBooks Online.
Because Stripe deducts processing fees and holds funds for a few days before depositing them, the bank deposit rarely matches the gross sales figure for that day. If you simply categorize the bank deposit as “Sales,” your revenue will be understated, and your merchant fees will be completely missing from your Profit and Loss statement.
If you are unsure whether your QuickBooks file has hidden sync, reconciliation, or reporting issues, take the QuickBooks Health Scorecard.
The Clearing Account Method
The most reliable way to reconcile ecommerce sales is by using a Clearing Account (also known as a holding account or holding bank). This acts as a bridge between your sales platform and your actual bank account.
Step 1: Record the Gross Sale
Instead of relying on the bank feed, you (or an integration tool like A2X) record a Summary Journal Entry or sales receipt in QuickBooks that captures the total activity for the day or week. This entry should include:
- Gross Sales (Credit to Income)
- Sales Tax Collected (Credit to Liability)
- Shipping Income (Credit to Income)
- Discounts Given (Debit to Income/Expense)
- Merchant Processing Fees (Debit to Expense)
The net total of this entry - the exact amount Stripe owes you - is debited to your Stripe Clearing Account.
Step 2: Match the Bank Deposit
A few days later, when Stripe transfers the funds to your checking account, that transaction will appear in your QuickBooks bank feed. Instead of categorizing this deposit as “Sales,” you categorize it as a transfer from the Stripe Clearing Account.
Step 3: Reconcile the Clearing Account
During your Month-End Reconciliation, the balance in your Stripe Clearing Account should exactly match the funds that Stripe has collected but not yet deposited into your bank account (your ending balance in Stripe). If the clearing account balance grows uncontrollably or drops below zero, it means an entry was missed or duplicated, and you need to investigate.
Why Direct Sync Apps Often Fail
Many business owners try to solve this by turning on Direct Sync Apps that push every single Shopify order into QuickBooks as an individual invoice. For high-volume stores, this is a disaster. It clutters your customer list, slows down QuickBooks, and makes it incredibly difficult to match hundreds of small invoices to a single lump-sum Stripe deposit.
Using a Summary Journal Entry via a Clearing Account keeps your QuickBooks file fast, clean, and accurate.
Need Help Untangling Your Ecommerce Books?
If your Shopify, Stripe, and QuickBooks numbers do not line up, Wecare Bookkeeping can help review your workflow, clean up your bookkeeping process, and build a clearer monthly reconciliation system.
