Bookkeeper Group

Keeping it Real

Ecommerce Bookkeeping: Inventory, Payouts, and Margin You Can Trust

Ecommerce bookkeeping often feels like trying to solve a puzzle with missing pieces. You sold $10,000 worth of product, but only $9,650 hit your bank account. You bought $20,000 of inventory three months ago, but you're only selling it now. Your sales tax liability is growing in five different states, and you're not sure if the marketplace collected it for you.

The core problem is that in ecommerce, the "cash story" rarely matches the "sales story." Money moves differently than goods.

  • Cash Flow Lag: You buy inventory months before you sell it.
  • Payment Batches: Processors like Stripe or Shopify hold your money for days, then deposit a lump sum minus their fees.
  • Returns & Refunds: A sale today might become a refund next week, reversing the revenue but complicating the cash flow.

The goal of ecommerce bookkeeping is to untangle this mess so you can answer three critical questions:

  1. Is my bank balance correct? (Tying sales to payouts)
  2. Am I actually making money on each sale? (Measuring true margin: Price - COGS - Shipping - Fees - Returns)
  3. Do I have enough stock (or too much)? (Managing inventory as an asset, not just an expense)

Overview

This guide breaks down the unique challenges of ecommerce accounting. We will cover the "Gross-to-Net" problem with payment processors, how to handle inventory without losing your mind, and a practical month-end workflow to keep your books audit-ready.

The "Gross-to-Net" Trap: Why Bank Feeds Lie to You

One of the biggest pain points in ecommerce is relying on your bank feed to tell you how much you sold. This is a mistake.

When a customer buys a $100 item from your store:

  1. They pay $100.
  2. The payment processor (Shopify, Stripe, PayPal) takes a fee, say $3.
  3. They deposit $97 into your bank account.

If you simply categorize that $97 deposit as "Sales Income," you have made two errors:

  1. Underreported Revenue: You sold $100, not $97.
  2. Missing Expenses: You failed to record the $3 processing fee.

Over thousands of transactions, this distorts your margins significantly. You might think your overhead is low, but you're actually bleeding 3% of your revenue in hidden fees.

The Solution: Clearing Accounts Think of a clearing account as a "digital cash register."

  • Step 1: Record the full $100 sale into the clearing account (Debits Clearing, Credits Sales).
  • Step 2: Record the $3 fee out of the clearing account (Debits Fees, Credits Clearing).
  • Step 3: When the $97 hits your bank, transfer it from the clearing account (Debits Bank, Credits Clearing).

When done correctly, your clearing account balance should be zero (or match the "funds in transit" balance at the end of the month).

Inventory: The Cash Tie-Up

Inventory is likely your biggest cash outlay. In cash-basis accounting, you might be tempted to expense inventory the moment you buy it. However, this creates a "rollercoaster" P&L:

  • Month 1: You buy $50k of stock. P&L shows a huge loss.
  • Month 2: You sell $20k of stock. P&L shows huge profit (because you have $0 cost recorded this month).

This makes it impossible to know if you are profitable.

The Accrual Approach (Even for Small Biz) You should treat inventory as an Asset on your Balance Sheet until it is sold.

  1. Purchase: Debit Inventory Asset, Credit Cash/AP.
  2. Sale: When you sell an item, you move its cost from Inventory Asset to "Cost of Goods Sold" (COGS) on the P&L.

This matches the cost of the product with the revenue from the sale in the same month, giving you a true Gross Margin.

Sales Tax: The Nexus Nightmare

Ecommerce sellers face a complex web of sales tax laws.

  • Nexus: If you have a physical presence (warehouse, employee, affiliate) or exceed a certain sales volume in a state (economic nexus), you must collect and remit sales tax there.
  • Marketplace Facilitators: Platforms like Amazon or Etsy often collect and remit tax for you. However, you still need to file returns in many cases, reporting the sales as "non-taxable" or "marketplace facilitated" to avoid paying twice.

Warning: Do not mix sales tax collected with your profit. It is a liability—money you owe the government. Keep it separate, ideally in a savings account, so you don't accidentally spend it.

A Practical Chart of Accounts for Ecommerce

Your Chart of Accounts (COA) is the map of your financial business. For ecommerce, standard categories aren't enough. You need specific buckets to see where your money is going.

Revenue (Segment by Channel)

Don't just have one "Sales" account. Split it up to see which channel performs best:

  • Sales - Shopify (DTC)
  • Sales - Amazon (Marketplace)
  • Sales - Wholesale/B2B
  • Shipping Income (Money customers pay you for shipping)
  • Returns & Allowances (A "Contra-Revenue" account that subtracts from sales. This helps you track refund rates separately from sales volume.)

Cost of Goods Sold (COGS)

  • Product COGS: The actual cost of the item.
  • Freight-in: The cost to ship inventory from the factory to you (this is part of the asset value).
  • Packaging: Boxes, tape, inserts.
  • Merchant Processing Fees: Some argue this is an OpEx, but for ecommerce, it's a direct cost of every sale.
  • Shrinkage/Adjustments: For lost, stolen, or damaged inventory.

Operating Expenses (OpEx)

  • Advertising - Facebook/Instagram: Keep paid social separate.
  • Advertising - Google/Search: Keep search separate.
  • Software - SaaS: Shopify subscription, Klaviyo, tools.
  • 3PL / Fulfillment Fees: If you outsource shipping.

Balance Sheet Specifics

  • Inventory Asset: The value of goods sitting in your warehouse.
  • Clearing Accounts: One for each processor (e.g., "Shopify Clearing", "Stripe Clearing", "PayPal Clearing").
  • Sales Tax Payable: Money collected but not yet remitted.
  • Gift Card Liability: Money received for gift cards not yet redeemed.

The Monthly Close: A Checklist for Sanity

You can't close an ecommerce month in 10 minutes. You need a systematic process to ensure every dollar is accounted for.

  1. Reconcile the "Banks": Start with your actual bank accounts and credit cards.
  2. Reconcile the "Processors": This is the hard part.
    • Log in to Shopify/Stripe/Amazon.
    • Pull the "Payouts" or "Settlement" report for the month.
    • Verify: Gross Sales - Refunds - Fees = Net Deposit.
    • Ensure your accounting software matches these figures exactly in the Clearing Accounts.
  3. Record Inventory Adjustments:
    • Do a physical count (or trust your inventory management system if reliable).
    • Calculate COGS for the sold items.
    • Journal Entry: Credit Inventory Asset, Debit COGS.
  4. Sales Tax Check:
    • Run a sales tax report.
    • Verify that the "Sales Tax Payable" on your Balance Sheet matches what the state portals say you owe.
  5. Review the P&L:
    • Does your Gross Margin look right? (e.g., if you usually make 40%, and this month is 80% or 10%, you likely missed a COGS entry).

Key Performance Indicators (KPIs)

Beyond just "Net Profit," look at these metrics to steer the ship:

  • Gross Margin %: (Revenue - COGS) / Revenue. This tells you if your product is fundamentally profitable before overhead.
  • Contribution Margin: Gross Margin - Variable Costs (Ads + Shipping + Payment Fees). This is the true profit left to cover your fixed costs (Rent, Salaries).
  • Refund Rate: Returns / Gross Sales. A spike here indicates a product quality issue or misleading marketing.
  • CAC (Customer Acquisition Cost): Total Ad Spend / New Customers.
  • LTV (Lifetime Value): How much a customer spends over time. If LTV > CAC, you are growing sustainably.
  • Inventory Turnover: How fast you sell through your stock. Low turnover means cash is stuck in dusty boxes.

Getting Started (The "MVP" Setup)

If you are just starting and can't afford a complex ERP system:

  1. Separate Finances: Open a dedicated business checking account. Never mix personal expenses.
  2. Tech Stack: Use cloud accounting software (Xero/QBO) and a connector tool (like A2X or Link My Books) to automate the "clearing account" entries. Manual entry is a recipe for error.
  3. Inventory: At minimum, count your stock value at the end of every month and adjust your books.
  4. Sales Tax: Use a tool like TaxJar or Avalara to monitor your nexus exposure.

When to Get Help

You are ready for a professional bookkeeper or controller when:

  • You spend more time wrestling with spreadsheets than growing the business.
  • You have no idea what your true profit is until tax season.
  • You are selling on multiple channels (Amazon + Shopify + Wholesale) and can't track inventory across them.
  • Your "Clearing Accounts" never balance, and you just plug the difference.

Next Steps