E-Commerce Bookkeeping: Making Sense of Shopify, Amazon & Stripe in QuickBooks Online

June 12, 2026 · 5 min read

E-commerce looks simple from the outside: customers buy, money lands in your bank. Under the hood, it's one of the trickiest types of bookkeeping — because the deposit that hits your account is almost never your actual revenue. Here's how to keep multi-channel sales clean in QuickBooks Online.

A payout is not your revenue

When Shopify, Amazon, or Stripe sends you a deposit, it's a net figure — gross sales minus refunds, platform fees, shipping, and sometimes sales tax, all rolled into one number. If you book that deposit as "income," your revenue is understated and your fees disappear. Each payout needs to be broken back out into its parts.

Sales tax can hide in the numbers

Platforms often collect and remit sales tax on your behalf — but it can still flow through your payouts. Without careful tracking, sales tax gets mistaken for revenue, inflating your income and confusing your filings. Clean books separate what's truly yours from what's just passing through.

Cost of goods and inventory

Profit in e-commerce lives in the gap between what you sold and what it cost you. Tracking cost of goods sold (COGS) and inventory accurately is what turns a pile of payouts into a real picture of margin — and it's where a lot of stores lose visibility.

Keeping it clean in QuickBooks Online

The goal is to record gross sales, fees, refunds, and tax as their own line items, reconcile each platform payout to the bank deposit, and keep COGS current. Done consistently, your QuickBooks Online file shows true revenue, true margin, and numbers your CPA can file from — no untangling required at year end.