Revenue is vanity, profit is sanity. Here's everything ecommerce sellers need to know about bookkeeping — from COGS to sales tax to knowing your real margins.
If you're selling online — Shopify, Etsy, Amazon, your own site — your bookkeeping is more complex than most businesses:
COGS is the single most misunderstood concept in ecommerce bookkeeping. Here's what it is and why it matters:
COGS is subtracted from revenue to calculate gross profit — your most important number. Gross profit margin tells you whether your business model works before you even consider operating expenses.
Example: You sell $100K in products. Your COGS is $60K. Gross profit = $40K (40% margin). If your operating expenses (ads, software, labor) are $50K, you're losing $10K despite $100K in revenue. Without tracking COGS separately, you wouldn't see this coming.
When you buy 100 units at $10 each, you record $1,000 in inventory (an asset). When you sell 30 units, you move $300 from inventory to COGS (an expense). This is called "capitalizing" inventory — you don't get the tax deduction until you sell.
Hivebooks' inventory module connects to your sales channels and tracks units sold, COGS per item, and remaining inventory in real time. See your gross profit margins by product, by month, and by sales channel — no spreadsheets required.
Start Free →Post-South Dakota v. Wayfair (2018), selling online got significantly more complicated. You can now owe sales tax in states where you have no physical presence.
You have sales tax nexus in any state where you have:
Most states now require you to collect sales tax if you exceed a sales threshold in that state — typically $100,000 in sales or 200 transactions per year. Every state sets its own thresholds.
Sales tax you collect is not your income — it's a liability. You're holding it for the state. If you record $10,000 in sales that includes $800 in sales tax, your actual revenue is $9,200. Your books need to track this separately or your income statement will be inflated.
Automate it: Use TaxJar, Avalara, or Quaderno to handle calculations and filings. They integrate with Shopify, WooCommerce, etc. You still need your bookkeeping to reflect the amounts correctly.
When should you record a sale? It's not as obvious as it seems.
You record revenue when payment hits your bank account. If a customer orders on January 30 and Stripe deposits on February 2, it's February revenue. Most small ecommerce businesses use cash basis.
You record revenue when the sale happens, regardless of when you get paid. That January 30 order is January revenue even though the money arrives in February. Accrual gives you a more accurate picture of monthly performance.
IRS rule: If your average annual gross receipts exceed $25 million over three years, you must use accrual. Everyone else can choose.
A refund isn't an expense — it's negative revenue. If you sold a $100 item and refunded it, you didn't earn $100 and spend $100. You earned $0. Record refunds as negative revenue or create a "Sales Returns" contra-revenue account.
Chargebacks are similar but uglier — you lose the sale and pay a $15-25 chargeback fee. Track the revenue reversal and the fee separately.
Hivebooks connects to your payment processors and ecommerce platforms. Sales, refunds, fees, and payouts sync automatically. Set categorization rules once and your books update themselves. Review transactions weekly instead of entering them manually.
Start Free →Gross revenue means nothing. Here's what actually matters:
That $100K in revenue generated $19K in profit. If you weren't tracking COGS and operating expenses separately, you might think you're doing better than you are.
Ecommerce businesses have unique deduction opportunities:
Your biggest deduction. Every product you sell reduces your taxable income by the cost to acquire or make it.
You can't deduct inventory when you buy it — only when you sell it (via COGS). But there's an exception: if you're a small business (under $25M average revenue), you can elect to deduct inventory purchases in the year you buy them if you also deduct them when sold via COGS. This accelerates deductions but requires careful tracking.
Equipment, computers, software, warehouse shelving — up to $1,220,000 (2025 limit) can be deducted immediately via Section 179 instead of depreciated over years.
If you run your store from home, the simplified method gives you $5/sq ft (max 300 sq ft = $1,500). Even if you have a warehouse, you can still claim home office if that's where you handle admin work.
Facebook/Instagram/Google ads, influencer payments, affiliate commissions, email marketing tools — all fully deductible.
Shopify, inventory management, email marketing, design tools, shipping software, accounting software — all deductible.
Boxes, poly mailers, tape, labels, postage — deductible. If you offer free shipping and build it into your price, the cost is still deductible as a business expense.
Product photos, lifestyle shots, video content for ads or your site — all deductible as marketing or advertising expenses.
DIY if:
Hire a CPA when:
The hybrid model: Do your own bookkeeping monthly. Hire a CPA for quarterly tax planning and annual tax filing. This costs $1,500-3,000/year instead of $500+/month for full-service bookkeeping.
"Is my Shopify subscription COGS or operating expense?" "Can I deduct the influencer payment?" "Where do refunds go?" Buzz — the AI assistant in Hivebooks — answers these questions in plain English. No accounting textbooks, no Googling IRS pubs.
Try Buzz Free →Selling on Shopify, Amazon, Etsy, and eBay simultaneously? Each platform has different fees, payout schedules, and reporting. Your bookkeeping needs to handle all of them without creating chaos.
Recording each payout as revenue. Amazon deposits $3,247.18 on Tuesday — you record $3,247.18 in revenue. This is wrong because that payout already has fees deducted, and it doesn't tell you which products sold or what your margins are.
Record gross sales as revenue, fees as expenses, and reconcile payouts to make sure everything balances. Most ecommerce accounting tools (including Hivebooks) can sync with Shopify, Amazon, and Etsy to pull gross sales, fees, and payouts separately.
If each channel is a separate legal entity (rare), you need separate books. If they're all under one LLC or sole proprietorship, track them in one set of books but use tags or classes to see per-channel profitability.
If you sell the same product repeatedly and costs fluctuate, you need to choose an inventory valuation method. This affects your COGS and taxable income.
You assume the oldest inventory sells first. If you bought 10 units at $5 and 10 more at $7, and you sell 10 units, COGS = $50 (the $5 units). Simple and most common for ecommerce.
You assume the newest inventory sells first. Rarely used in ecommerce. Beneficial in inflationary times (higher COGS = lower taxes) but creates weird inventory values on the books.
You average the cost of all units. In the example above, average cost = $6/unit. Sell 10 units, COGS = $60. Smooth and fair, but requires more calculation.
Pick one and stick with it. The IRS requires consistency. You can't switch methods year-to-year to minimize taxes.
Free bookkeeping for ecommerce. Track inventory, COGS, and profit margins automatically. No credit card required.
Start Free →