Shopify Bookkeeping: Reconciling Payouts, Fees & Sales Tax

Shopify Sales and Bank Deposits Never Match

Your Shopify dashboard says you sold $40,000 this month. Your bank shows a series of smaller deposits that add up to less. Neither is wrong — the gap is processing fees, refunds, chargebacks, and payout timing. Shopify bookkeeping is the work of reconciling what you sold to what you were paid, so both your revenue and your costs come out right.

Record Gross Sales, Then the Deductions

The cleanest approach books the gross order value as revenue, then records each deduction separately:

• Payment processing fees (Shopify Payments, Stripe, or PayPal).
• Refunds and returns, netted against sales.
• Chargebacks and disputes.
• Discounts and gift cards, which affect revenue recognition.

Booking only the net deposit buries your fees and understates your sales — and you can't manage costs you can't see.

Reconcile Payouts to the Bank

Shopify Payments bundles many orders into one payout, minus fees, on a delay. Matching each payout to the bank deposit — and back to the orders inside it — is the core reconciliation. Skip it and small discrepancies (a missed refund, an unrecorded fee) pile up into a month-end mystery.

Handle Multiple Sales Channels

Most Shopify stores don't sell only on Shopify — there's also Amazon, social, wholesale, maybe in-person POS. Each channel has its own fees and payout rhythm. Good bookkeeping consolidates them so you see total revenue and per-channel profitability, instead of a confusing pile of deposits.

COGS and Inventory

As with any product business, cost of goods sold belongs in the books when an item sells, and inventory is an asset until then. Tie COGS to sales and your gross margin becomes a number you can trust — and act on.

Sales Tax Is Yours to Manage

Shopify can calculate sales tax, but collecting and remitting it correctly — and tracking where you've crossed economic nexus — is on you. Marketplace facilitator rules may cover your Amazon sales, but your own Shopify store usually isn't covered. Keep collected tax separate from revenue so you never spend money you owe the state.

The Bottom Line

Shopify bookkeeping comes down to reconciling sales to payouts, separating every fee, and tracking COGS and sales tax correctly. Get it right and your store's real profit stops hiding behind the deposits.