Shopify Seller Accounting: The Complete 2026 Guide

Why Shopify accounting is hard

Three structural problems show up in every Shopify operation past $100K annual revenue.

First, the gross-to-net gap. The Shopify Sales report shows gross sales. The bank deposit shows net of payment processing, refunds, chargebacks, and gift card adjustments. The two numbers are never the same, and the gap is composed of half a dozen line items that need separate accounts.

Second, the payout calendar. Shopify Payments deposits 1 to 3 business days after the sale, but it batches across days and across order types. The deposit you see Tuesday includes Friday's orders, Saturday's app subscriptions, Sunday's tip activity, and Monday's refunds. Matching it back to a daily sales summary requires a settlement ledger, not a transactions list.

Third, multi-channel orders. If you also sell on Amazon, eBay, or wholesale, the same SKU shows up in Shopify Inventory with no channel context. Per-channel revenue and COGS reporting needs an external system because Shopify will not give you a clean per-channel P&L by itself.

What Shopify reports actually tell you

The four reports matter in this order:

• Finances Summary: Highest-level view. Gross sales, returns, discounts, net sales, shipping, taxes, total sales. Use this for top-line revenue.
• Payouts: The actual bank deposits. Each payout includes a transaction-level breakdown of charges, refunds, adjustments, and fees. This is your bank reconciliation source.
• Transactions: Order-by-order detail. Use this when you need to investigate a specific discrepancy.
• Tax: Sales tax collected by Shopify, by jurisdiction. Use this for sales tax filing, but only for the states where you collect through Shopify yourself, not the marketplace-facilitator states.

The chart of accounts for a Shopify seller

Minimum viable structure:

• Sales, Shopify (gross revenue)
• Discounts, Shopify (contra-revenue)
• Refunds, Shopify (contra-revenue)
• Chargebacks, Shopify (contra-revenue or expense, depending on accounting policy)
• Shipping income, Shopify
• Sales tax payable (liability: collected but not yet remitted)
• Shopify Payments processing fees (expense)
• Shopify subscription (expense: your monthly plan)
• Shopify apps (expense: categorized by type if you can)
• COGS, Shopify (expense: flowed from inventory)
• Fulfillment expense, Shopify (3PL, FBA-for-Shopify, manual ship)
• Inventory asset, Shopify location

For sellers with FBM (Fulfillment by Merchant) operations, add per-location warehouse asset accounts.

Sales tax: what Shopify handles vs what you handle

Most US states now have marketplace facilitator laws. For Shopify, the facilitator status depends on the channel: when an order comes through Shop Pay or Shop app, Shopify acts as facilitator in many states. When the order comes through your own checkout, you collect and you remit.

The practical implication: a portion of your sales tax is collected by Shopify and remitted on your behalf (you don't file on it), and a portion you collect and remit yourself. Your accounting needs to separate the two, because filing on the wrong amount creates either over-collection or under-remittance.

Multi-channel sellers face an extra layer: Amazon, Walmart, and eBay are all marketplace facilitators in most states. Your direct Shopify orders into your nexus states are the only sales you typically file on. Your accounting needs to track that filing base correctly.

Reconciling Shopify to your accounting software

The clean-month workflow:

1. Pull the Finances Summary for the month. Record net sales, returns, discounts, shipping, and tax.
2. Pull every payout from the month's date range. Sum: total payouts to bank = total charges minus fees minus refunds minus adjustments.
3. Match payouts to bank deposits in your accounting software. The deposit amount should reconcile to the payout summary, line by line.
4. Reconcile timing differences: orders placed at month-end that pay out the following month. Use a clearing account for in-transit deposits.
5. Sales tax separation: book Shopify-collected, marketplace-facilitated sales tax as net-zero (collected and remitted in the same period by Shopify). Book your own collected sales tax as a payable until you remit.
6. COGS: apply per-unit landed cost to units sold in the period. FIFO is the standard method for Shopify inventory.

This is a 4 to 8 hour workflow done manually by an experienced bookkeeper. ConnectBooks automates the entire flow: payouts reconcile to deposits, sales tax separates correctly between facilitated and self-collected, COGS posts from the inventory ledger with FIFO costing, and the journal entries hit QuickBooks Online or Xero clean. Plans start at $149/month on the Gold tier and scale to Diamond ($199) and Platinum ($349) based on order volume and feature depth.

Shopify + Amazon multi-channel: the accounting pattern

Most ConnectBooks customers run Shopify alongside at least one marketplace. The accounting pattern that works:

• Separate revenue, expense, and inventory accounts per channel. Sales, Shopify and Sales, Amazon are two different accounts. Same for FBA fees and Shopify processing fees.
• Shared SKU master, separate inventory ledger per location. ConnectStock handles this: same product across Shopify warehouse, FBA, and 3PL with different on-hand quantities and different per-unit landed costs.
• Per-channel P&L view monthly. So you know whether your Shopify margins justify the Shop Pay processing fees vs Amazon margins after FBA and referral. Most sellers don't realize their best margin channel until they see the per-channel P&L.

Does Shopify have built-in accounting?

No. Shopify has reports (Sales, Payouts, Transactions, Tax) but no general ledger, no chart of accounts, and no financial statements. The reports are useful for reconciliation but they don't replace accounting software.

Should I use QuickBooks Online or Xero with Shopify?

Either works. QuickBooks Online is the default in the US market and most ecommerce bookkeepers prefer it. Xero is stronger for multi-currency and international operations.

How long does a Shopify monthly close take?

Manually with reports and spreadsheets: 4 to 8 hours. With an integration like ConnectBooks: 30 minutes to review the auto-posted journals and approve.

What about Shopify gift cards in the accounting?

Gift cards are a liability when sold (you owe the buyer the goods later) and revenue when redeemed. Shopify reports show both events. The clean handling is a gift card liability account that grows on sale and reduces on redemption.

Take Control of Your E-Commerce Business with ConnectBooks

Running an e-commerce business comes with plenty of challenges, but ConnectBooks is here to make your life easier. With real-time insights, seamless integrations, and detailed tracking of your profitability and inventory, you can stay ahead of the game. Whether you’re selling on Amazon, Shopify, Walmart, TikTok or eBay, ConnectBooks helps you manage your finances with 100% accuracy and confidence, so you can focus on growing your business.

Ready to level up? Start making smarter, data-driven decisions every step of the way. Try ConnectBooks Free Today or Schedule a Demo