Shopify makes selling online easy. Bookkeeping for your Shopify store? Not so much. Between payouts, fees, refunds, chargebacks and sales tax, the numbers can get complicated fast. This guide covers everything you need to know to keep your eCommerce books clean and accurate.
📋 What's in this guide
Why eCommerce Bookkeeping is Different
Traditional bookkeeping is relatively straightforward — money comes in, money goes out, you record it. eCommerce bookkeeping adds several layers of complexity that trip up even experienced business owners:
- Shopify doesn't deposit your full sales amount — it deducts fees before paying you
- Multiple payment gateways (Shopify Payments, PayPal, Stripe) each settle separately
- Refunds and chargebacks need to be accounted for properly
- Sales tax rules vary by state, country and product type
- Inventory tracking affects your cost of goods sold (COGS) and profitability
- Multi-currency sales add another layer of complexity
⚠️ The Most Common Mistake
Most Shopify sellers record their Shopify payout as their revenue. This is wrong. Your revenue is the total sales amount — the payout is what remains after Shopify deducts its fees. Recording payouts as revenue understates your gross sales and overstates your profit margin.
Understanding Shopify Payouts
Before you can reconcile your books, you need to understand exactly what a Shopify payout contains. Here's what happens between a customer placing an order and money hitting your bank account:
Customer places an order — $100
This is your gross revenue. It should be recorded as income in full, regardless of what you actually receive.
Shopify deducts its transaction & processing fees — e.g. $3.20
Shopify charges a payment processing fee (typically 2.4%–2.9% + 30¢ per transaction). These fees must be recorded as a separate expense — not netted against revenue.
Shopify pays out the net amount — $96.80
This is what hits your bank account. If you record only this as your revenue, you're missing $3.20 of gross sales and $3.20 of expenses every single transaction.
Refunds and chargebacks are deducted from future payouts
Shopify doesn't always send a separate transaction for refunds — they're often netted from your next payout. Your bookkeeper needs to track these separately.
Common Bookkeeping Errors Shopify Sellers Make
❌ Recording payouts as revenue
As explained above — your revenue is total sales, not net payouts. This error distorts your gross margin and makes tax filing inaccurate.
❌ Not tracking Shopify fees as expenses
Transaction fees, subscription fees, app charges and shipping label costs are all deductible business expenses. Missing them means you overpay tax.
❌ Ignoring refunds and returns
Every refund reduces your revenue. Not recording refunds properly overstates your income and leads to incorrect tax filings.
❌ Not separating sales tax from revenue
Sales tax collected belongs to the government — it's not your income. Mixing it with revenue inflates your reported earnings.
❌ Skipping inventory reconciliation
Without accurate inventory tracking, you can't calculate your true cost of goods sold (COGS) — and without COGS, you can't calculate your real profit.
❌ Reconciling monthly instead of per payout
Shopify pays out every few days — if you only reconcile monthly, errors and discrepancies compound and become very hard to untangle.
Setting Up Your Chart of Accounts for Shopify
A well-structured chart of accounts is the foundation of clean eCommerce bookkeeping. Here's what your key accounts should look like:
Income Accounts
- Product Sales Revenue (gross sales)
- Shipping Income (if you charge customers for shipping)
- Discount Given (contra revenue account)
- Returns and Refunds (contra revenue account)
Cost of Goods Sold (COGS)
- Product Cost / Purchases
- Shipping Cost (cost to ship to customers)
- Packaging Materials
- Fulfilment Costs (3PL or warehouse fees)
Operating Expense Accounts
- Shopify Subscription Fees
- Shopify Transaction & Processing Fees
- Shopify App Fees
- Advertising & Marketing (Meta, Google Ads)
- Payment Gateway Fees (PayPal, Stripe)
- Chargebacks & Dispute Fees
- Software & Tools
Liability Accounts
- Sales Tax Payable
- VAT Payable (UK/EU sellers)
- GST Payable (AU/Canada sellers)
💡 AccountSaathi Tip
When setting up your Shopify chart of accounts in QuickBooks or Xero, always create separate income accounts for gross sales and contra accounts for refunds and discounts. This gives you far cleaner reporting and makes your P&L statement much more meaningful.
Reconciling Your Shopify Sales
Reconciliation means making sure your accounting records match your Shopify payouts, bank deposits, and the actual sales figures from your Shopify dashboard. Here's the process:
- Download your Shopify payout report from Shopify Admin → Finances → Payouts for each payout period
- Record gross sales as revenue in your accounting software
- Record Shopify fees as separate expense line items
- Record refunds as contra revenue (reducing gross sales)
- Record the net payout as a bank deposit and match it to your actual bank statement
- Reconcile sales tax collected vs what is owed
- Verify the closing balance matches your bank statement to the penny
This process should be done for every Shopify payout — not just once a month. If you have high sales volume, this might mean reconciling multiple times per week.
Inventory and COGS Accounting
For product-based Shopify sellers, inventory accounting is one of the most important — and most neglected — areas of bookkeeping.
The Two Main Inventory Methods:
FIFO (First In, First Out)
The first items purchased are the first ones sold. Most common method for physical product businesses. Gives accurate COGS during periods of rising costs.
Weighted Average Cost
Calculates an average cost across all inventory. Simpler to manage and smooths out cost fluctuations. Often used by businesses with high volumes of similar products.
Your COGS directly impacts your gross profit. If you're not tracking inventory accurately, your profit margins are just estimates — and your tax filings may be incorrect.
💡 AccountSaathi Tip
If you use a 3PL (third-party logistics) provider or dropshipping model, make sure your bookkeeper understands how costs flow through your supply chain. The accounting treatment for dropshipping is different from holding your own inventory — and getting it wrong is a common and costly mistake.
Sales Tax, VAT and GST for Shopify Sellers
This is often the most stressful area for eCommerce sellers — and for good reason. Tax obligations vary significantly depending on where you sell and where your customers are.
🇺🇸 US Sellers — Sales Tax
After the South Dakota v. Wayfair ruling, US states can require online sellers to collect sales tax even without a physical presence. If you sell to customers in multiple states and exceed certain thresholds (typically $100,000 in sales or 200 transactions), you may have nexus in those states and be required to collect and remit sales tax. Shopify can automatically calculate and collect sales tax — but recording and remitting it correctly in your books is your responsibility.
🇬🇧 UK & 🇪🇺 EU Sellers — VAT
If you're VAT registered, every sale to a UK or EU customer may require VAT to be charged, collected and remitted. Shopify can handle VAT calculation, but your bookkeeping must separate VAT collected from revenue and track it as a liability until you file your VAT return.
🇦🇺 Australian Sellers — GST
If your Shopify store turns over more than AUD $75,000 per year, you must register for GST. GST collected on sales is a liability — it belongs to the ATO, not you. Your BAS preparation must accurately reflect GST collected and GST paid on business expenses.
🇨🇦 Canadian Sellers — GST/HST
Canadian Shopify sellers with over CAD $30,000 in revenue must register for GST/HST. The rate varies by province and your bookkeeping must track both the GST/HST collected from customers and the input tax credits (ITCs) you can claim.
⚠️ Important
Sales tax, VAT and GST are never your income. Always record them as a separate liability in your books. Mixing tax collected with your revenue is one of the most common and costly bookkeeping errors for eCommerce sellers.
Tools and Integrations for Shopify Bookkeeping
The good news is that Shopify integrates directly with all major accounting platforms, making reconciliation much faster when set up correctly.
📊 QuickBooks
Best for US/Canada Shopify sellers. Native integration available.
💙 Xero
Preferred for UK/Australia. Excellent Shopify integration.
🔄 A2X
Dedicated Shopify reconciliation tool. Works with QB and Xero.
📄 Dext
Automates receipt and invoice capture for eCommerce expenses.
💳 Stripe
If using Stripe as payment gateway — reconcile separately from Shopify Payments.
🅿️ PayPal
Another common payment gateway that needs separate reconciliation.
💡 Pro Tip — Use A2X for Shopify Reconciliation
A2X is a specialist tool that sits between Shopify and your accounting software (QuickBooks or Xero). It automatically summarises each Shopify payout into properly structured journal entries — separating gross sales, fees, refunds and taxes. It dramatically reduces reconciliation time and errors. Many of our eCommerce clients use it alongside their chosen accounting platform.
Your Monthly Shopify Bookkeeping Checklist
Here's what should happen every month to keep your Shopify books clean and current:
✅ Monthly eCommerce Bookkeeping Checklist
When to Outsource Your Shopify Bookkeeping
Managing Shopify bookkeeping yourself makes sense when you're just starting out. But as your store grows — more products, more payouts, multiple payment gateways, international sales — the complexity grows with it.
Consider outsourcing when:
- You're spending more than 4-5 hours per month on bookkeeping
- You're not confident your books are reconciled correctly
- Your CPA keeps finding errors at year-end
- You're selling across multiple countries with different tax rules
- You've added Amazon, Etsy or other channels alongside Shopify
- You're making purchasing or hiring decisions without clear profit visibility
Let AccountSaathi Handle Your Shopify Books
We specialise in eCommerce bookkeeping for Shopify sellers across the US, Canada, UK, Australia and Europe. Clean books, accurate reconciliation, delivered on time every month.
📅 Schedule Your Free Consultation