Why Shopify Accounting is Different
Shopify sellers have unique accounting requirements compared to marketplace sellers (Amazon, eBay). The biggest difference: Shopify handles payment collection but daily payouts, while marketplaces batch payouts every 14 days.
This creates different accounting challenges:
- Daily transactions need reconciliation
- Fees vary day-to-day (no fixed Amazon rate)
- Sales tax collection & remittance is your responsibility (not marketplace)
- Refunds process differently
- Multiple payment processors create complexity
Shopify Payment Processing Overview
Shopify Payments (Recommended)
Shopify's built-in payment processor. Integrated directly into Shopify admin.
- Fees: 2.9% + 30¢ per transaction (US)
- Payout schedule: Daily to your bank (minus 2-day hold)
- Settlement: Deposits appear in bank account within 1-2 business days
- Visibility: All data in Shopify admin; reconciliation is easier
Third-Party Processors (Stripe, Square, PayPal)
Alternative payment processors integrated via Shopify.
- Stripe: 2.9% + 30¢; Daily payouts
- Square: 2.9% + 30¢; Daily payouts
- PayPal: 2.2% + 30¢; Daily payouts
- Advantage: May have existing merchant account; can negotiate rates
- Disadvantage: Data split between Shopify and processor; harder to reconcile
Fee Breakdown Example
Customer buys $100 product with Shopify Payments:
- Gross sale: $100
- Payment processing fee: -$2.90 - $0.30 = -$3.20
- Shopify subscription (if Basic): -$29/month (fixed, spread daily)
- Net payout today: ~$96.74 (accounting for daily subscription allocation)
Key Accounting Point
Unlike Amazon (which shows fees on Settlement Report), Shopify deducts fees directly from payout. You see net amount, not gross + fees separately.
Shopify Accounting Setup in QuickBooks
Step 1: Install Shopify App in QuickBooks
In QuickBooks Online:
- Go to Apps → Find Apps
- Search "Shopify"
- Select "Shopify" by Intuit
- Click Install
- Authorize Shopify account (connects the two systems)
Step 2: Configure Chart of Accounts
Before syncing, set up proper accounts:
- Income Accounts:
- Sales - Product Revenue
- Sales - Shipping Revenue
- Sales Returns & Refunds
- Asset Accounts:
- Bank - Shopify (linking account)
- Expense Accounts:
- Shopify Fees (payment processing)
- Shopify Subscription
- Sales Tax Payable (liability, not expense)
Step 3: Map Shopify Data to QB Accounts
In QB Shopify app settings:
- Product sales → Sales - Product Revenue
- Shipping charges → Sales - Shipping Revenue
- Refunds → Sales Returns & Refunds
- Payment fees → Shopify Fees expense
- Bank deposits → Bank - Shopify account
Step 4: Set Sync Frequency
- QB automatically syncs Shopify data daily
- Creates journal entries for each transaction
- Can manually sync if needed
Step 5: Reconcile Monthly
- Download Shopify financial report (Settings → Financial reports)
- Compare to QB P&L
- Verify deposits match bank statement
- Investigate any variances
Shopify Revenue & Fee Reconciliation
Example: Shopify Daily Activity
| Metric | Amount |
|---|---|
| Gross Sales (orders) | $2,500 |
| Shipping Revenue | $150 |
| Customer Refunds | -$200 |
| Disputes/Chargebacks | -$50 |
| Net Revenue | $2,400 |
| Payment Processing Fee (2.9% + $0.30) | -$73.50 |
| Shopify Subscription (daily allocation) | -$0.87 (if Basic $29/30 days) |
| Sales Tax Collected (not net to you) | $190 (held, owed to state) |
| Net Deposit to Bank | $2,325.63 |
QB Journal Entries
QB automatically creates these entries:
- Debit: Bank - Shopify $2,325.63
- Debit: Shopify Fees $73.50
- Debit: Shopify Subscription $0.87
- Credit: Sales - Product Revenue $2,500
- Credit: Sales - Shipping Revenue $150
- Credit: Sales Returns & Refunds $200
- Credit: Sales Tax Payable $190
Monthly Reconciliation Checklist
- ☐ Compare Shopify Revenue Report total to QB Sales revenue
- ☐ Verify refunds recorded in QB match Shopify refunds
- ☐ Check fees calculated correctly (2.9% + $0.30 per transaction)
- ☐ Verify total deposits = QB bank balance for Shopify account
- ☐ Validate sales tax collected matches QB liability
- ☐ Investigate any 1-2% variances (rounding, timing)
Sales Tax Accounting for Shopify
Important: You Must Collect & Remit Sales Tax
Unlike Amazon (which handles FBA sales tax in some cases), Shopify sellers are responsible for sales tax collection and remittance.
Tax Setup in Shopify
- Go to Settings → Taxes
- Enable tax collection for states where you have nexus
- Shopify automatically calculates & collects tax at checkout
- Tax amount appears in Shopify reports separately from revenue
Accounting Treatment
- Tax collected: Not revenue (liability to state)
- Record as Sales Tax Payable (liability account)
- When you remit to state: Debit Sales Tax Payable, Credit Bank
- Monthly filing: Generate Shopify tax report, file with state, pay balance due
Comparing QB and Xero for Shopify
| Feature | QuickBooks Online | Xero |
|---|---|---|
| Shopify Integration | Official app; native sync | Official app; native sync |
| Ease of Setup | Very easy; guided setup | Very easy; guided setup |
| Daily Sync | Automatic | Automatic |
| Reconciliation | Built-in reconciliation tools | Built-in reconciliation tools |
| Multi-Channel | Good for Shopify + Amazon | Better for Shopify + Amazon |
| Cost (Basic Tier) | $15/month | $13/month |
| Recommendation | Shopify-only sellers | Multi-channel sellers |
Common Shopify Accounting Issues
Issue 1: Sales tax not separating from revenue
Shopify sometimes shows tax-inclusive pricing. QB auto-sync captures tax as sales tax payable (correct). Verify in reconciliation.
Issue 2: Refunds delayed in QB
Shopify refunds process 5-10 days after approval. QB records refund immediately if sync is on. Reconcile after refund fully processes.
Issue 3: Shopify subscription allocation confusing
Daily Shopify fee ($29/month ÷ 30) appears in every daily payout. QB allocates proportionally. Aggregate shows correct monthly total.
Issue 4: Multiple payment processors
If using Stripe + Shopify Payments, data splits between Shopify and processor. Create separate bank accounts in QB for each processor.
Best Practices: Shopify Accounting
Monthly Routine
- Download Shopify financial reports (product sales, shipping, refunds)
- Verify QB sync captured all transactions
- Reconcile Shopify payout account in QB to bank statement
- Review fees for accuracy
- Calculate and accrue sales tax liability
- Generate P&L for month
Quarterly Routine
- File sales tax returns for all states (if applicable)
- Verify sales tax liability in QB matches filed amounts
- Analyze profitability by product/collection
- Review payment processing fees (can sometimes negotiate)
Annual Routine
- Verify annual revenue matches Shopify totals
- Reconcile total fees charged
- Review for new sales tax nexus (expansion to new states)
- Prepare 1099-K if accepting third-party payments
Summary: Shopify Accounting Setup
✓ Choose payment processor: Shopify Payments recommended (simpler)
✓ Set up QB/Xero: Install Shopify app; configure chart of accounts
✓ Enable auto-sync: Daily sync captures all transactions
✓ Track sales tax: Separate collection from revenue; remit quarterly
✓ Reconcile monthly: Verify deposits, fees, and balances
✓ Monitor profitability: Easy to track with Shopify integration