Shopify accounting looks simple until you realize a single daily "payout" contains dozens of transactions: gross sales, processing fees, refunds, chargebacks, gift cards, shipping collected, tips, apps charges, and more. Proper Shopify accounting separates these correctly and reconciles each payout to the bank deposit. This guide covers how.
Shopify Payments (the default payment processor for Shopify stores) batches transactions and sends a net payout to your bank every 2–5 business days. Each payout looks simple on the bank side: one ACH deposit for, say, $4,247.38. On the Shopify side, that payout aggregates:
Proper accounting separates each of these to the correct GL account. Generic bookkeeping that just categorizes the $4,247.38 deposit as "sales revenue" misstates: revenue (understated because processing fees reduce payout), COGS (missed), sales tax liability (missed because tax goes to separate liability account), and more.
Doing Shopify accounting manually transaction-by-transaction is impossibly tedious at scale. Specialized tools automate the split:
The most common tool for Shopify + accounting integration. Takes each Shopify payout, splits it into component parts per GL account mapping, creates a summary journal entry in your accounting platform (QBO, Xero, NetSuite). Reconciles payout to bank deposit automatically.
Pricing: $19–$199/month depending on order volume.
UK-based alternative to A2X, popular in UK and growing in US. Similar functionality, often competitive pricing for small merchants.
Multi-platform (Shopify + Amazon + eBay + Walmart). Good for merchants selling on multiple channels. More complex setup than A2X.
Both QBO and Xero have official Shopify apps. Less sophisticated than A2X; often creates duplicate entries or incorrect tax handling. Fine for very simple single-channel small merchants; breaks down at higher complexity.
For very small merchants (under $20k/month revenue), manual reconciliation from Shopify reports to accounting is feasible. Above that volume, manual becomes error-prone and time-consuming.
Most Shopify brands eventually sell on multiple channels: Shopify store, Amazon, TikTok Shop, wholesale through Faire, maybe eBay or Walmart Marketplace. Accounting for multi-channel ecommerce is meaningfully more complex than single-channel.
See our ecommerce bookkeeping guide for broader ecommerce accounting framework.
Post-Wayfair, Shopify merchants face multi-state sales tax obligations once they exceed economic nexus thresholds (typically $100k revenue or 200 transactions in a state).
Shopify's built-in sales tax calculation. Good for merchants operating in fewer than 10 states. Handles calculation well; filing is separate (handled manually or through a service).
For merchants in 15+ states, dedicated sales tax platforms handle calculation + registration + filing. Monthly cost typically $50–$500 depending on volume and state count.
See our sales tax services page.
Related: ecommerce bookkeeping guide, ecommerce industry page.
Related