If you’re running a Shopify store, accurate accounting in QuickBooks Online is critical for tax compliance, business decisions, and growth. This guide shows you how to connect Shopify to QuickBooks Online the right way — so your books stay accurate and your accountant stays happy.
Why Connect Shopify to QuickBooks?
Before we dive into the “how,” let’s cover the “why”:
- Eliminate manual data entry: No more copying sales from Shopify into QuickBooks by hand
- Instant financial visibility: See current revenue, expenses, and profitability any time
- Accurate tax reporting: Sales tax syncs correctly across jurisdictions
- Clean audit trail: Every order traceable from Shopify to QuickBooks
- Faster month-end close: Automated sync means reconciliation takes minutes, not hours
Using WeIntegrate to Connect Shopify to QuickBooks Online
WeIntegrate is purpose-built for Shopify-QuickBooks syncing with accountants in mind. Here’s how to set it up:
Step 1: Sign Up for WeIntegrate
- Go to weintegrate.co
- Click “Start Free Trial”
- Create your account (no credit card required for 15-day trial)
Step 2: Connect Shopify
- Click “Connect Shopify Store”
- Log in to your Shopify admin (you’ll be redirected)
- Click “Authorize” to grant WeIntegrate access
- Return to WeIntegrate dashboard
Important: WeIntegrate uses OAuth 2.0, so we never see your Shopify password. You can revoke access anytime from Shopify’s app settings.
Step 3: Connect QuickBooks Online
- Click “Connect QuickBooks Online”
- Log in to your QuickBooks account
- Authorize WeIntegrate to access your company file
- Return to WeIntegrate dashboard
Step 4: Configure Your Account Mappings
The Configuration Setup Wizard walks you through mapping each type of Shopify data to the right account in your QuickBooks chart of accounts. This is not automatic — you make the decisions, and the wizard guides you through each one:
- Product revenue → your income account (e.g., “Shopify Product Sales”)
- Sales tax → a Sales Tax Payable liability account (never an income account)
- Shopify fees → an expense account (e.g., “Merchant Fees” or “Payment Processing”)
- Shipping collected → a shipping income account
- Customer matching → match orders to existing QBO customers, or configure how new customers are created
- Product matching → match Shopify products to existing QBO items, or configure auto-creation rules
Take the time to get these mappings right. They determine how every order lands in QuickBooks from day one, and fixing a wrong mapping retroactively means correcting every document it affected.
Once the wizard is complete, WeIntegrate begins syncing immediately. Every new Shopify order flows into QuickBooks automatically — no additional step required.
Note on historical orders: If you need to back-fill Shopify orders from before your connection date, historical sync is available by request after you’ve subscribed to a plan. Contact WeIntegrate support to arrange it.
What Gets Synced
With WeIntegrate, every paid Shopify order creates a real Sales Receipt in QuickBooks — not a journal entry, not a daily summary, but an individual transaction document linked to the Shopify order number. Each Sales Receipt includes:
- Product line items → revenue posted to your income account
- Sales tax → posted to your Sales Tax Payable liability account (never touching income)
- Shipping collected → posted to your shipping income account
- Discounts → reflected as reductions against revenue
- Shopify fees → posted to your designated expense account
- Customer information → matched to your QBO customer records
- Shopify order ID → on every document, so you can trace any transaction in seconds
Returns and refunds create a Refund Receipt in QuickBooks automatically, linked to the original Sales Receipt and the originating Shopify order. Your refund records match exactly what Shopify processed — without any manual reconciliation.
Manual Entry Is Not a Real Alternative
You can manually enter Shopify sales into QuickBooks, but this approach breaks down quickly:
- Under 10 orders per month, it’s manageable — barely
- At 50 orders per month, it’s a part-time job
- At 200+ orders per month, it’s impossible to keep current
Even at low volume, manual entry introduces errors that compound into reconciliation problems. Starting with automated sync from the first order is the only approach that scales.
Common Mistakes to Avoid
Mapping Sales Tax to an Income Account
Sales tax MUST go to a liability account (Sales Tax Payable), not income. Mapping it to income overstates revenue and leaves your Sales Tax Liability report empty — a problem your accountant will catch and you’ll spend time fixing.
Skipping the Account Mapping Step
The Configuration Wizard is where your integration gets built. Rushing through account mappings or accepting placeholders you plan to change later creates books that reflect the placeholder, not your actual chart of accounts. Ten minutes of thoughtful setup prevents weeks of cleanup.
Mixing Cash and Accrual Accounting
Decide before you connect: are you on cash or accrual basis?
- Accrual: Record revenue when the order is placed and paid
- Cash: Record revenue when the payout reaches your bank
Most Shopify stores use accrual. WeIntegrate handles both — but the setting needs to match how your QBO company file is configured.
Not Reconciling Regularly
Even with automation, reconcile your Shopify payouts against QuickBooks monthly. This catches any discrepancies before they compound across multiple periods.
How to Test Your Setup
After connecting and completing the account mapping wizard, test the integration:
- Place a test order in Shopify (or use an existing recent order)
- Check QuickBooks — the Sales Receipt should appear instantly
- Verify the transaction document includes all components:
- Product revenue in your income account
- Sales tax in your liability account
- Shipping in your shipping income account
- Fees in your expense account
- Trace back to Shopify using the order ID on the Sales Receipt
- Process a refund and verify a Refund Receipt appears in QuickBooks automatically
If all five checks pass, your integration is working correctly.
Maintaining Your Integration
Once set up, the integration runs without ongoing intervention. To keep it healthy:
- Review sync logs periodically to catch any failed syncs early
- Reconcile monthly to confirm QuickBooks matches your Shopify payout records
- Update account mappings if you restructure your chart of accounts
- Keep your accountant informed of how data flows so they can close the month without surprises
Ready to Connect?
Start your free 15-day trial with WeIntegrate and connect Shopify to QuickBooks Online in 10 minutes. No credit card required.
For a complete walkthrough of how to prepare QuickBooks Online before connecting — including chart of accounts setup, required QBO settings, and product and customer configuration — see How to Integrate Shopify with QuickBooks Online Using WeIntegrate.