Ecommerce Bookkeeping
Shopify Bookkeeping: Payouts, Fees, Sales Tax and Inventory
Quick answer
Shopify bookkeeping starts with payout reconciliation: every deposit is gross sales minus payment processing fees, refunds, adjustments and sometimes held amounts. Record gross sales as revenue, fees as expenses, collected sales tax as a liability, and refunds against the month of the original sale. Match inventory purchases to cost of goods, and reconcile monthly so the books and the bank agree.
Shopify makes selling easy and bookkeeping confusing. The dashboard shows sales; the bank shows smaller, later deposits; fees, refunds and taxes live in different reports. If you book the deposit as revenue, your sales are understated and fees vanish. This guide covers the core flows; our broader [ecommerce bookkeeping guide](/blog/ecommerce-bookkeeping-amazon-shopify-sellers) covers Amazon and multi-channel stores.
Reconcile every payout
Each Shopify Payments deposit combines many orders minus processing fees, refunds and any adjustments or holds. The correct entry records gross sales, then the fees as merchant fee expense, then refunds, so the net equals the deposit. Bookkeeping software and connector apps can automate the split, but someone still needs to review exceptions monthly. The same discipline applies to PayPal and other processors if you offer them.
Record fees as expenses, not invisible
Processing fees, subscription fees, app charges, theme and shipping label costs are all real expenses. When fees hide inside net deposits, you cannot see what the channel actually costs, and margin by product is fiction. Keep each fee type on its own account so a fee increase or an expensive app is visible the month it happens.
Sales tax is a liability, not revenue
Tax Shopify collects at checkout belongs to the state. In the books it goes to a sales tax payable account, never into sales. If you sell into states where you have obligations, track tax by jurisdiction so your CPA or filing service can file from clean numbers. The mechanics are in our [sales tax bookkeeping guide](/blog/sales-tax-bookkeeping-small-business). Rules vary by state; your CPA confirms where you must collect.
Inventory and cost of goods
If you stock products, purchases are inventory, an asset, and move to cost of goods as items sell. Expensing inventory on purchase makes profit swing with buying instead of selling, and confuses your tax return. Keep supplier invoices, shipping-in costs and any duties matched to inventory, and agree the costing method with your CPA.
Refunds, chargebacks and gift cards
- Refunds. Record against the original sale month where practical, so monthly revenue is not distorted.
- Chargebacks. Track disputed amounts separately until resolved; won disputes come back as revenue.
- Gift cards. A sale of a gift card is a liability until redeemed, then it becomes revenue.
How Mispar helps
Mispar reconciles your Shopify payouts, fees, refunds and sales tax every month in your own QuickBooks Online or Xero file, and keeps inventory and cost of goods current, so your profit and loss shows real margin. [Bookkeeping for ecommerce](/industries/ecommerce) starts at $229/mo.
Frequently asked questions
Why does my Shopify deposit never match my sales?
Deposits are net of processing fees, refunds and adjustments, and they batch many orders. Reconciliation explains the difference line by line.
Do I need a connector app?
Not necessarily. Connectors save data entry on higher volumes, but the monthly review of what they posted is still required.
How do I handle multiple currencies?
Record each payout in the currency received and let your accounting file handle conversion, with gains and losses shown separately. Your CPA confirms the tax treatment.
Can Mispar handle Shopify plus other channels?
Yes. Each channel is reconciled on its own, then combined into one set of books in your own file.
Keep reading
E-commerce
Ecommerce Bookkeeping for Amazon and Shopify Sellers: What to Track and Why Payouts Never Match
Ecommerce bookkeeping for Amazon and Shopify sellers: why payouts do not match sales, how to track fees, inventory and COGS, and sales tax basics.
Bookkeeping Basics
Sales Tax and Your Books: What Small Businesses Should Track
Sales tax you collect belongs to the state, not to your business. Your books should show it as a liability and tie to every return you file.
Bookkeeping Basics
Bank Reconciliation Explained: A Simple Guide for Small Businesses
Reconciliation is the check that your books agree with the bank. It is a small monthly task that catches duplicates, missing entries and mistakes while they are still easy to fix.
Written by
is a Senior Account Manager at Mispar who works directly with small business owners and freelancers to keep their books clean, reconciled, and tax-ready every month.
More about Mispar