The questions Shopify sellers actually ask their accountants, answered plainly. If your books and your bank never seem to agree, start here.
Shopify bookkeeping confuses people for one structural reason: Shopify is a commerce platform, not an accounting system. It records what you sold and what was deposited, but it does not maintain a general ledger, recognize revenue correctly, or track your liabilities. The work of turning Shopify data into accurate books happens in QuickBooks or Xero, and these are the questions that come up most when sellers try to do it well. The terms "shopify accounting" and "shopify bookkeeping" together pull several hundred US searches a month, which is a small group of high-stakes operators trying to get this right.
Because the deposit is net. Shopify pays you your gross sales minus refunds, minus processing fees, minus chargebacks, minus any reserves held for the period. The deposit is supposed to be smaller than your sales. The fix is to split each payout into its components when you book it: gross sales to revenue, refunds to a contra-revenue account, fees to a processing-expense account. The pieces sum to the net deposit, and your revenue then reflects what you actually sold.
In a dedicated payment-processing-fees expense account, not buried in the net deposit and not lumped into a generic "bank charges" line. Shopify nets the fees out of your payout, so if you book only the deposit, the fees never appear as an expense and your revenue is understated by the exact amount of fees. At ecommerce volume, processing fees are a major cost worth tracking on their own line.
Accrual, for any serious operation. Cash accounting records revenue when money hits the bank, which breaks down the moment you have settlement timing gaps, pre-orders, gift cards, or B2B sales on terms. Accrual records revenue when you earn it (typically at fulfillment), which keeps your monthly numbers tied to actual sales rather than to payment timing. Accrual is also required to handle deferred revenue and receivables correctly.
Collected sales tax is a liability, not revenue. Book it to a sales-tax-payable account. The tax you collect at checkout is held in trust for the states until you remit it. It is not income. And remember Shopify only collects and calculates tax; it does not file or remit for your own store, so you are responsible for registration, filing, and payment in every state where you have nexus.
No. A gift card is deferred revenue, a liability, until the customer redeems it. Book the sale as a credit to a gift-card liability account and a debit to cash. Recognize revenue only when the card is redeemed for product. The same applies to store credit, which is a liability until spent.
COGS is the actual cost of the inventory that shipped, recognized when the sale happens, matched against that sale's revenue. The accurate method is per-unit cost tracking on a consistent basis such as FIFO, so each sale carries the true cost of the specific inventory sold. Percentage estimates and year-end plugs distort your margin and fail scrutiny if you ever raise capital or sell. ConnectBooks computes FIFO COGS per unit automatically and posts it against the matching sale.
An ecommerce-specific one. Beyond the basics, you need separate contra-revenue accounts for refunds and discounts, a dedicated processing-fee expense, a sales-tax-payable liability, a gift-card liability, a store-credit liability, an inventory asset account, and a clearing account for in-transit payout cash. The generic default chart in QuickBooks or Xero forces ecommerce transactions into the wrong boxes.
Reconcile each gateway separately. Match Shopify Payments settlements to their own deposits, then match PayPal settlements to theirs. Each gateway has its own payout file and deposit stream. Trying to reconcile every gateway against one combined sales figure makes any discrepancy impossible to trace to its source.
Reconcile at least monthly as part of your close, and ideally review payouts as they arrive. Letting a month of unreconciled payouts pile up turns small, traceable discrepancies into a large, tangled one. For higher-volume stores, frequent reconciliation keeps problems small and the month-end close short.
At very low volume, briefly. Past a few hundred orders a month, with refunds, fees, multiple gateways, sales tax across states, and period-end timing, a spreadsheet stops being reliable. The errors are silent (a missed fee here, a mis-timed sale there) and they compound. A real accounting system with automated Shopify sync removes the manual entry that causes those errors.
Because Shopify deposits a net amount after subtracting fees, refunds, chargebacks, and reserves, and because settlement lags the sale. Your revenue (gross sales) will always exceed the cash deposited in a given period. Splitting each payout into its components reconciles the two.
No. It is a liability held in trust for the states, recorded in a sales-tax-payable account. Counting it as income overstates your revenue and risks paying income tax on money that belongs to the state. Shopify also does not remit it for your own store, so you must file it yourself.
For any store with meaningful volume, yes. Accrual records revenue when earned, which handles settlement timing, deferred revenue from gift cards and pre-orders, and B2B receivables correctly. Cash accounting ties your numbers to payment timing rather than actual sales and breaks down quickly at scale.
Track COGS per unit on a consistent basis like FIFO, recognizing the actual cost of the inventory shipped against each sale. Avoid percentage estimates and year-end plugs, which distort margin and fail diligence. Automation that computes per-unit COGS keeps it accurate without manual work.
You need separate tracking of each channel within one set of books, tagged by channel, plus awareness that marketplaces like Amazon remit sales tax for you while your Shopify store does not. Per-channel data lets you see which channel is actually profitable and keeps your tax obligations straight.
ConnectBooks turns Shopify data into accurate books in QuickBooks or Xero, with fees, tax, and COGS handled automatically. See plans at /pricing.
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
