Bookkeeping for Shopify Sellers

Shopify bookkeeping is more complex than most owners expect. The payout you receive from Shopify is not your revenue — and treating it that way creates a financial picture that's wrong in ways that matter at tax time and when making business decisions.

The core problem: gross revenue vs. net payouts

Shopify deposits net payouts into your bank account after deducting transaction fees, payment processing fees, refunds, and chargebacks. If you record that deposit as revenue, you're understating your gross sales and losing visibility into what your actual fees and returns are costing you.

Key bookkeeping entries for Shopify sellers

• Gross revenue: Record the full sale amount, not the payout
• Shopify fees: Record as a separate expense line item
• Payment processing fees: Stripe/PayPal/Shopify Payments fees as separate expense
• Refunds and returns: Record as a reduction in revenue or contra-revenue account
• Cost of Goods Sold (COGS): Track product cost separately from operating expenses
• Shipping: Separate shipping collected vs. shipping paid to carriers

The inventory challenge

If you hold physical inventory, you also need to track COGS correctly — which means knowing your product cost, any import duties, and shipping-in costs. Many Shopify sellers lump inventory purchases into expenses, which overstates expenses when items are purchased and understates them when items are sold.

Sales tax complexity

If you sell in multiple states, you may have sales tax nexus obligations in each of them. Shopify can collect sales tax automatically, but someone still needs to track it, file returns, and remit payment. This is where TaxJar integration (included in our CFO Lite plan) becomes essential.

What good Shopify bookkeeping looks like

Monthly reconciliation of Shopify payouts against gross sales, a clear view of your actual gross margin after COGS, accurate expense categorization, and a real-time dashboard showing revenue trends. At Graphene, we set up a Shopify-specific chart of accounts and reconcile your payouts to the penny each month.