Shopify Accounting Guide
Master your Shopify bookkeeping: understand Shopify Payments fees, reconcile payouts, handle chargebacks and refunds, and import everything into QuickBooks — free.
Shopify Fee Structure
Understanding Shopify's fee model is essential for accurate bookkeeping. Fees vary by plan tier and whether you use Shopify Payments or a third-party gateway.
| Fee / Plan | Rate | Description |
|---|---|---|
| Shopify Payments (Online) | 2.4–2.9% + $0.30 | Credit card processing fee per transaction. Rate depends on your Shopify plan tier. |
| Shopify Payments (In-Person) | 2.4–2.7% + $0.10 | Tap, chip, or swipe transactions via Shopify POS. Lower rate than online transactions. |
| Third-Party Gateway Surcharge | 0.5–2.0% | Extra fee Shopify charges when using a non-Shopify payment gateway (e.g., PayPal, Authorize.net). |
| Basic Plan | $39/mo | Entry-level plan with 2.9% + $0.30 online rate. Best for new and small stores. |
| Shopify Plan | $105/mo | Mid-tier plan with 2.6% + $0.30 online rate. Includes professional reports and lower fees. |
| Advanced Plan | $399/mo | Enterprise-grade plan with 2.4% + $0.30 online rate. Custom reports, duties & import taxes. |
Key takeaway: Using Shopify Payments eliminates the third-party gateway surcharge (0.5–2.0%), which can save thousands of dollars annually for high-volume stores. Always factor this into your payment gateway decision.
Shopify Payments vs. Third-Party Gateways
Your choice of payment processor directly impacts your fees, payouts, and bookkeeping complexity.
Shopify Payments
- +No third-party transaction surcharge — saves 0.5–2.0% per sale
- +Integrated payout tracking directly in Shopify Admin
- +Automatic chargeback handling with evidence submission tools
- +Simpler bookkeeping — one processor, one fee structure
- –Not available in all countries
- –Limited customization of checkout experience
Third-Party Gateways
- +Full control over payment processor choice (PayPal, Stripe, etc.)
- +Available worldwide with more gateway options
- +May offer lower rates via negotiated enterprise pricing
- –Shopify adds 0.5–2.0% surcharge on top of gateway fees
- –Separate payout tracking — payouts come from the gateway, not Shopify
- –More complex bookkeeping with two fee sources to track
Payout Schedule
Shopify Payments lets you choose how often you receive payouts. Your choice affects both cash flow and reconciliation effort.
Daily
Payouts processed every business day on a rolling basis. Funds arrive 2 business days after the order.
Best for: High-volume stores that need frequent cash flow
Weekly
Payouts processed once per week on your chosen day. Bundles an entire week of activity into one deposit.
Best for: Mid-volume stores that prefer fewer bank transactions to reconcile
Monthly
Payouts processed once per month on your chosen date. Maximum bundling, fewest deposits.
Best for: Low-volume stores or those who reconcile monthly
Payout hold periods: New Shopify stores may experience a hold period before receiving their first payout. For US stores, this is typically 2–3 business days. International stores may see longer holds. Once established, payouts follow your chosen schedule reliably.
How to Export from Shopify
Shopify offers two main export paths: order-level data and payout-level data. Choose based on the level of detail you need.
Orders Export
Line-item detail for every order
- 1.Navigate to Orders in your Shopify Admin
- 2.Filter by date range, status, or fulfillment if needed
- 3.Click Export and choose the export scope
- 4.Select CSV for Excel, Numbers format
- 5.Click Export orders — the CSV is emailed to you
Payouts Export
Bank deposit reconciliation data
- 1.Go to Settings → Payments in Shopify Admin
- 2.Click View payouts under Shopify Payments
- 3.Navigate to Finances → Payouts for the full list
- 4.Click on a specific payout to see its transaction breakdown
- 5.Use Export to download payout data as CSV
Pro tip: For QuickBooks reconciliation, the Payouts export is usually the better choice — it matches what actually hits your bank account. Use the Orders export when you need per-order or per-product detail for profitability analysis.
Common Accounting Challenges
Shopify bookkeeping has unique pitfalls. Here are the six challenges that trip up most store owners — and how to handle them.
Chargebacks & Disputes
Chargebacks deduct the sale amount plus a $15 fee from your next payout. If you win the dispute, the funds are credited back later. This creates timing mismatches in your books that require careful tracking.
Partial Refunds
Partial refunds reduce the order total but may not refund the original transaction fee. Whether the fee is refunded depends on your Shopify Payments settings and the refund timing. Track both the refund amount and fee impact.
POS + Online Combined
Shopify POS and online sales flow into the same Shopify Payments account and are bundled together in payouts. Separating channel performance requires careful order tagging or dedicated sub-accounts in QuickBooks.
Multi-Currency Orders
If you sell in multiple currencies, Shopify converts to your payout currency at the time of sale. Exchange rate differences between order date and payout date can create small discrepancies that need reconciliation.
Gift Cards
Gift card sales are deferred revenue — not income at the time of purchase. When a gift card is redeemed, the original sale should be recognized as income. Shopify tracks gift card liability, but your QuickBooks setup must mirror this treatment.
App & Theme Costs
Shopify app subscriptions and theme purchases are billed separately from your sales. These show up on your Shopify invoice, not in your payouts. Track them as separate business expenses in QuickBooks.
Step-by-Step Workflow
Follow these six steps every payout period to keep your Shopify books clean and current.
Export Orders or Payouts
In Shopify Admin, go to Orders → Export for order-level data, or Settings → Payments → View Payouts for payout-level data. Download the CSV file.
Review the Raw Data
Open the CSV in a spreadsheet. Verify totals match your Shopify dashboard. Check for chargebacks, partial refunds, or unusual adjustments.
Convert to QuickBooks Format
Upload the CSV to the PrimeConnect Shopify-to-QB converter. The tool auto-detects columns, separates fees, and outputs a QuickBooks-ready file (CSV, IIF, or QBO).
Import into QuickBooks
For QuickBooks Online: Banking → Upload transactions. For Desktop: File → Utilities → Import → Web Connect (QBO) or IIF Import.
Categorize Transactions
Map gross sales to income accounts, Shopify Payments fees to an expense account, refunds to contra-revenue, and chargebacks to a dedicated expense account.
Reconcile with Bank
Match each Shopify payout in QuickBooks against the corresponding bank deposit. For daily payouts, match the rolling 2-day deposit cycle. Flag any discrepancies immediately.
Importing to QuickBooks
Once you've converted your Shopify export, here's how to get it into QuickBooks.
QuickBooks Online
Best format: CSV or QBO
- 1.Go to Banking (or Transactions) in the left sidebar
- 2.Click Upload transactions (or Link account → Upload from file)
- 3.Select the converted CSV or QBO file from your computer
- 4.Map columns if prompted (date, description, amount)
- 5.Choose the target bank account and click Import
QuickBooks Desktop
Best format: IIF or QBO (Web Connect)
- 1.Go to File → Utilities → Import
- 2.Choose IIF Files or Web Connect Files (.QBO)
- 3.Select the converted file from your computer
- 4.Map to the appropriate bank account when prompted
- 5.Review the imported transactions and categorize as needed
Recommendation: For QuickBooks Online, QBO format provides the fastest import via the bank feed. For Desktop, IIF gives you the most control over account mappings and memos. CSV works universally across both platforms.
Tax Obligations
Unlike Amazon or Etsy, Shopify is not a marketplace facilitator. This means tax handling is different — and more of your responsibility.
Shopify Tax
Shopify Tax automatically calculates and collects sales tax based on your registered nexus states. It tracks rooftop-level tax rates for accuracy. However, Shopify does NOT remit the tax — you must file and pay sales tax to each state yourself (or use a service like TaxJar).
Economic Nexus
Most US states have economic nexus thresholds (typically $100K in sales or 200 transactions). If you exceed the threshold in a state, you must register to collect sales tax there. Shopify provides nexus insights in Settings → Taxes to help you identify where you have obligations.
Not a Marketplace Facilitator
Unlike Amazon, Etsy, or eBay, Shopify is a platform, not a marketplace. Marketplace facilitator laws do not apply to your Shopify store. This means sales tax collection and remittance is entirely your responsibility as the merchant.
Disclaimer: This guide provides general information only and does not constitute tax advice. Tax laws vary by jurisdiction and change frequently. Consult a qualified tax professional for advice specific to your situation.
Best Practices
Eight tips from experienced Shopify merchants to keep your books accurate and audit-ready.
Choose Your Payout Schedule Wisely
Weekly payouts strike the best balance between cash flow and reconciliation effort. Daily payouts create too many bank transactions; monthly creates too much lag.
Track Shopify Payments Fees Separately
Create a dedicated "Shopify Payments Fees" expense account in QuickBooks. This gives you clear visibility into your processing costs as a percentage of revenue.
Handle Gift Cards as Deferred Revenue
Set up a liability account in QuickBooks for gift card sales. Only recognize revenue when the gift card is redeemed, not when it is purchased.
Separate POS and Online Channels
Use sub-accounts or classes in QuickBooks to distinguish POS revenue from online revenue. This helps you understand which channel is more profitable.
Reconcile Chargebacks Promptly
Don't let chargebacks pile up. Record them as they happen, including the $15 fee. If you win a dispute, record the credit when it appears in your payout.
Track App and Theme Costs
Shopify app subscriptions and theme purchases are billed separately from payouts. Download your Shopify invoices monthly and record them as operating expenses.
Use Bank Rules for Automation
Set up QuickBooks bank rules to auto-categorize Shopify payouts, fees, and refunds. This cuts reconciliation time dramatically for recurring transaction patterns.
Archive Your Exports Monthly
Download and archive both order exports and payout exports every month. Store them in a dated folder structure. You'll need them for audits and year-end tax prep.
Related Tools
Put this guide into practice with these free tools.
Shopify to QuickBooks Converter
Convert Shopify order and payout CSVs to QuickBooks-ready format instantly. Free, browser-based.
Use tool →Multi-Channel Merge Tool
Combine exports from Shopify, Amazon, Etsy, and more into a single QuickBooks import file.
Use tool →Ecommerce Analytics Dashboard
Compare fees, revenue, and trends across all your ecommerce platforms in one view.
Use tool →Related Platform Guides
Expanding beyond Shopify? These guides cover accounting for platforms commonly paired with a Shopify store.
Amazon Accounting Guide
Settlement reports, FBA fees, multi-marketplace bookkeeping, and how to import Amazon transactions into QuickBooks.
Read guideWooCommerce Accounting Guide
Self-hosted store accounting, multi-gateway reconciliation, plugin-based exports, and QuickBooks import for WooCommerce.
Read guideEtsy Accounting Guide
Multi-layered fee structure, Shop Manager exports, Star Seller metrics, and QuickBooks import for Etsy sellers.
Read guideFrequently Asked Questions
Common questions about Shopify accounting and QuickBooks import.
How do I export transactions from Shopify?
What is the difference between Shopify Payments and third-party gateways?
How often does Shopify pay out?
How do I handle Shopify chargebacks in QuickBooks?
How do I handle partial refunds?
Does Shopify handle sales tax collection?
How do I reconcile Shopify POS and online sales together?
Can I import Shopify data into QuickBooks for free?
Ready to Import Your Shopify Data?
Convert your Shopify orders or payouts CSV to a QuickBooks-ready file in under 60 seconds. Free, private, and entirely browser-based.