The Ecommerce Bookkeeping Mistakes Costing You Thousands
Most e-commerce founders don’t find out their books are wrong. They find out their profit was never what they thought it was, usually around tax time, usually from an accountant who asks a question they can’t answer. Bookkeeping mistakes in ecommerce rarely look like mistakes while they’re happening. A missed transaction here, a fee recorded in the wrong place there. None of it feels urgent until you’re staring at a bank balance that doesn’t match your accounting software, wondering which one is lying to you. I’ve gone through enough of these files for sellers running everything from a single Shopify store to a five-channel operation spanning Amazon, TikTok Shop, and a wholesale side business to know the patterns repeat. Here’s where things actually go wrong and what fixing them looks like in practice. 1. Treating Payout Deposits as Revenue This is the single most common error I see, and it’s almost never the seller’s fault directly. It’s how Shopify Payments, Amazon, Stripe, and PayPal are built. When a platform pays you out, that deposit is not your revenue. It’s your revenue minus fees, minus refunds, minus chargebacks, sometimes minus a reserve holdback, all bundled into one net number. If you record that deposit as a single sales entry, your revenue is understated, your expenses are invisible, and your gross margin calculation becomes meaningless. The fix is unglamorous but nonnegotiable: revenue, fees, refunds, and reserves need to be broken out as separate line items, ideally through a tool like A2X or a manual journal entry process that mirrors your settlement report. Once that’s set up, it mostly runs itself. 2. Confusing Cash Basis and Accrual Basis Without Realizing It A lot of sellers think they’re on cash basis because that’s what their software defaulted to, then get confused when their P&L doesn’t reflect a big sale they just made or shows revenue for inventory they haven’t shipped yet. Cash-basis records money when it moves. The accrual basis records revenue when it’s earned and expenses when they’re incurred, regardless of when cash changes hands. E-commerce businesses with inventory almost always benefit from accrual, or at minimum a hybrid approach to COGS, because the cash basis can badly distort how profitable you actually are during high-growth or high-inventory-purchasing months. If you’ve never had a conversation with anyone about which method you’re using and why, that’s worth fixing before it’s worth anything else on this list. 3. Getting Cost of Goods Sold Wrong (Or Skipping It Entirely) I still see stores where the entire cost of inventory purchased in a month gets dumped straight into an expense account the moment it’s paid for. That’s not COGS. That’s a cash outflow being mistaken for a cost. Real COGS only hits your income statement when the inventory actually sells. Everything sitting in your warehouse, or in an Amazon fulfillment center, is an asset until it’s sold, not an expense. Get this wrong and your margins will look wildly different from reality, sometimes making a genuinely profitable month look like a loss, or the reverse. This one matters more the faster you’re growing, because growth usually means buying more inventory than you’re selling in any given month, which is exactly when the distortion is worst. 4. Skipping Reconciliation, or Doing It Once a Quarter Reconciliation is the process of matching your accounting records against your actual bank and platform statements. Skip it for a few months, and small errors compound into ones that take hours to untangle. Monthly reconciliation across every bank account, every payment processor, and every sales channel isn’t optional busywork. It’s the mechanism that catches duplicate transactions, missing deposits, and fee changes before they turn into a quarter of unreliable numbers. Sellers running Shopify, Amazon, and a merchant account often assume their bookkeeping software auto-reconciles everything through bank feeds. It doesn’t, not reliably, and definitely not across multiple settlement schedules running on different timelines. 5. Mixing Personal and Business Finances Common with newer sellers, especially anyone who started as a side hustle. A business credit card gets used for a personal purchase, or business revenue lands in a personal account during a cash crunch, and it never gets cleanly separated after. Beyond the accounting mess, this one has real legal weight if the business is structured as an LLC, since commingling funds is one of the things that can pierce the liability protection an LLC is supposed to provide. Separate accounts, separate cards, no exceptions, even when it feels inconvenient in the moment. 6. Ignoring Sales Tax Nexus Across States Multi-state sales tax obligations kick in based on economic nexus thresholds that vary by state, not just where the business is physically located. A lot of sellers register in their home state and stop there, unaware that hitting a sales volume threshold in another state can create a filing obligation they’ve never addressed. This isn’t strictly a bookkeeping error in the traditional sense, but it shows up in the books, usually as sales tax collected sitting in the wrong account or not tracked separately from revenue at all. Sales tax collected is not your money. It’s a liability you’re holding for a state government, and it needs its own account, tracked separately from the moment it’s collected. 7. No Consistent Chart of Accounts A chart of accounts that grows organically, one new category added every time something doesn’t fit anywhere else, eventually becomes unusable. I’ve seen accounts named after specific vendors, categories that duplicate each other under slightly different names, and expense buckets so broad they tell you nothing about where money is actually going. A clean, e-commerce-specific chart of accounts separates merchant fees from advertising costs from COGS from shipping and stays that way as the business scales. It’s far easier to build this correctly early than to rebuild it three years and thousands of transactions later. Shopify and Amazon-Specific Patterns Shopify and Amazon each have their own quirks worth briefly noting here, since sellers on either platform tend to encounter specific