Ecommerce Bookkeeping 101

Ecommerce Bookkeeping 101: How to Track Inventory, Returns, and Sales Tax the Right Way

August 3, 2026 - by analyticssocial trendzz

Most accounting software was built with a simple business in mind: one register, one location, cash in the till at the end of the day. Ecommerce doesn’t work like that. You’ve got orders coming from Shopify, Amazon, and TikTok Shop, payouts that land a week after the sale, inventory sitting in three different warehouses, and a return rate that can quietly eat into margin nobody’s tracking.

This is exactly why generic bookkeeping falls apart for online sellers. Getting it right takes a system built specifically for how ecommerce actually works, which is really what good ecommerce bookkeeping services are for. This guide breaks down the three areas that trip up most sellers, inventory, returns, and sales tax, and shows you exactly how to handle each one.

Why Traditional Bookkeeping Breaks Down for Ecommerce Sellers?

A traditional bookkeeper records a sale, deposits the cash, done. Ecommerce adds layers on top of that simple transaction:

  • Marketplace fees, ad spend, and payment processing fees get deducted before the payout even hits your bank
  • Inventory sits in multiple locations, your warehouse, FBA, a 3PL, and needs to be valued consistently across all of them
  • Revenue can come in a dozen currencies and get taxed differently in nearly every US state
  • Payouts settle days or weeks after the actual sale, so your bank balance and your real revenue rarely match on any given day

None of this is impossible to manage, but it does require a bookkeeping approach built around how online retail actually moves money, not a system borrowed from a brick-and-mortar shop.

Section 1: Master Inventory Accounting for Ecommerce

Inventory is usually the single biggest number on an ecommerce balance sheet, and it’s also the number most sellers get wrong. Solid inventory accounting for ecommerce starts with three decisions.

Calculating COGS Accurately

Your cost of goods sold has to reflect the full landed cost of each unit, not just what you paid the manufacturer.

  • Choose a valuation method, FIFO, LIFO, or weighted average, and apply it consistently across every SKU
  • Roll freight, customs duties, and inbound shipping into landed cost rather than treating them as a separate expense line
  • Recalculate COGS for bundles and kits every time a component price changes, since bundled SKUs are the most common place this number quietly goes stale

Managing Inventory Holding Costs

Stock that sits on a shelf is still costing you money, even if it hasn’t sold yet.

  • Track storage and warehousing fees separately from COGS so you can see which SKUs are actually profitable to hold
  • Write down slow-moving or obsolete inventory on a regular schedule instead of waiting until year-end to notice it
  • Factor in insurance and shrinkage, especially for higher-value or easily damaged products

Cash vs. Accrual Accounting: Which Fits Your Store

This single decision shapes how accurate your financial picture is at any given moment.

  • Cash-basis accounting is simple but can badly distort your numbers, since it books revenue on payout date instead of sale date
  • Accrual accounting matches revenue to the sale itself, giving you a far more accurate month-to-month profit picture
  • The IRS generally requires accrual accounting once average annual revenue crosses roughly $25-30 million, but most growing sellers benefit from switching well before that point

If your current bookkeeping still runs on a spreadsheet built for a much smaller store, this is usually the first thing a dedicated ecommerce bookkeeping services provider will rebuild, since inventory errors here ripple through every other financial report you rely on.

Section 2: Streamline Ecommerce Returns Accounting

Returns aren’t just a customer service problem, they’re an accounting problem too. Handled sloppily, they inflate your revenue and hide your true margin.

Logging Refunded Sales Correctly

  • Post refunds to a dedicated contra-revenue account instead of lumping them in with general expenses
  • Recognize the return in the period it actually happens, not the period the original sale occurred
  • Reconcile refund totals from each marketplace against what actually left your bank account weekly, not once a quarter

Restored vs. Damaged Inventory

Every return needs a decision, and that decision changes how it’s booked.

  • Sellable returned stock goes back into inventory at its original cost basis, ready to be resold
  • Damaged or unsellable stock gets written off as an inventory loss expense, not left sitting in inventory as a phantom asset
  • Track the split between restored and damaged inventory by SKU, since a high damage rate on one product usually points to a packaging or shipping issue worth fixing

Processing Fees and Partial Refunds

Payment processors rarely return the full transaction fee on a refund, which is an easy detail to lose track of.

  • Book the unreturned processing fee as its own expense line rather than folding it into cost of goods sold
  • For partial refunds or restocking fees, record only the actual dollar amount refunded, so revenue isn’t overstated
  • Run a monthly return-rate report by product line, not just a company-wide total, to catch problem SKUs early

This is also where clean accounts payable and receivable processes matter, since return-related credits, chargebacks, and short payments all flow through the same reconciliation workflow as your regular receivables.

Section 3: Simplify Sales Tax Tracking and Compliance

Sales tax is the part of ecommerce bookkeeping most sellers dread, mainly because the rules genuinely differ from state to state.

Understanding Economic Nexus

  • Nexus is typically triggered once you cross a state’s revenue or transaction-count threshold in a trailing 12-month period
  • Thresholds and rules vary by state, so a seller can trigger nexus in a new state without ever setting foot there
  • Review your nexus exposure at least quarterly, since a single strong sales month can push you over a threshold you weren’t watching

Handling State-by-State Variations

  • Product taxability isn’t universal, clothing, food, and digital goods are taxed differently (or not at all) depending on the state
  • Marketplace facilitator laws mean some platforms already collect and remit tax on your behalf, so check before you double-file
  • Keep a running log of every state where you’re registered, along with filing frequency and due dates

Leveraging Sales Tax Tracking Software

Manually tracking rates across 40+ states isn’t realistic once you’re selling in any real volume. Good sales tax tracking software handles the heavy lifting:

  • Automatically calculates the correct rate at checkout based on the buyer’s exact location
  • Monitors your nexus exposure in real time as sales accumulate state by state
  • Generates filing-ready reports and sends reminders before due dates, cutting down on missed or late filings

Even with automation handling the calculations, someone still needs to review filings, catch mismatches, and prepare returns correctly. That review layer is a core part of tax return preparation for ecommerce sellers, and it’s where most software-only setups eventually fall short.

Section 4: Scale Smart, When to Outsource Ecommerce Bookkeeping

There’s a point in every growing store’s life where the founder doing the books stops being a cost-saving move and starts being a genuine liability.

Signs Your In-House Process Is Breaking

  • Monthly reconciliation takes days instead of hours, and it keeps slipping later into the following month
  • You can’t say with confidence what your actual margin is by product or by channel
  • Sales tax filings have been late, missed, or handled reactively more than once
  • Inventory counts in your accounting system rarely match what’s actually on the shelf

What Outsourcing Actually Buys You

  • Access to bookkeepers who already understand multi-channel ecommerce, instead of a generalist learning on your dime
  • Bandwidth that scales up during peak season and back down afterward, without a hiring or layoff cycle
  • Consistent, accurate financials you can actually use to make inventory, pricing, and ad-spend decisions

Most sellers who outsource ecommerce bookkeeping do it for the same reason: it turns bookkeeping from a weekly fire drill into a system that just runs quietly in the background, while they focus on growing the store.

Key Takeaways: Clean Books Are a Growth Strategy

Inventory, returns, and sales tax are the three places ecommerce bookkeeping most commonly goes wrong, and they’re also the three places that matter most once you’re trying to scale.

  • Get your COGS and inventory valuation method locked down and applied consistently across every channel
  • Treat returns as their own accounting process, not an afterthought bolted onto revenue
  • Stay ahead of economic nexus instead of reacting to a tax notice after the fact
  • Know the point where outsourcing saves you more than it costs, and don’t wait until the books are already a mess to make the call

Clean books won’t just keep you compliant, they’ll actually tell you which products, channels, and campaigns are worth doubling down on. If your current setup can’t answer that question with confidence, that’s the real signal it’s time for a change.