The Complete E-Commerce Bookkeeping Guide: What Every Online Seller Needs to Know

Selling online has never been easier — but keeping track of the money? That's where things get complicated fast. Between marketplace fees, multi-state sales tax, payment processor holdbacks, and inventory spread across three warehouses, e-commerce bookkeeping looks nothing like traditional small business accounting.

If you've ever stared at a bank deposit from Amazon or Shopify and wondered how a single lump sum could represent dozens of transactions — including sales, refunds, fees, and adjustments — you already understand the problem. This guide breaks down exactly how to manage your e-commerce finances so you can stop guessing and start making decisions based on real numbers.

Why E-Commerce Bookkeeping Is Different

A brick-and-mortar store makes a sale, collects payment, and records the transaction. An online seller makes a sale on Shopify, processes payment through Stripe, ships via a third-party fulfillment center, collects sales tax for a state they've never visited, and receives a consolidated payout two weeks later that bundles everything together.

The core differences include:

• Multi-channel sales tracking: You might sell on your own website, Amazon, eBay, Etsy, and wholesale — each with different fee structures, payout schedules, and reporting formats.
• Complex payment processing: Stripe, PayPal, Square, and marketplace-specific processors each take their cut and deposit funds on their own timeline.
• Inventory across locations: Products might sit in your garage, an Amazon FBA warehouse, and a third-party logistics center simultaneously.
• Higher return and chargeback rates: Online purchases have significantly higher return rates than in-store sales, which complicates revenue recognition.
• Multi-state tax obligations: Since the Supreme Court's 2018 South Dakota v. Wayfair decision, you may owe sales tax in states where you have no physical presence.

Cash vs. Accrual Accounting: Which Method to Use

Most e-commerce businesses should use accrual accounting rather than cash-basis accounting. Here's why:

With cash accounting, you record revenue when money hits your bank account. But marketplace payouts often arrive weeks after the actual sale, and a single deposit might include transactions from an entire pay period. This makes it nearly impossible to match revenue to the period when sales actually occurred.

Accrual accounting records revenue when the sale happens and expenses when they're incurred, regardless of when cash changes hands. This gives you:

• Accurate monthly profit and loss statements that reflect actual business performance
• Better inventory tracking since COGS is recorded when items are sold, not when you pay your supplier
• Cleaner financial statements for lenders, investors, or potential buyers

If your annual revenue exceeds $1 million or you carry significant inventory, accrual accounting isn't just recommended — it may be required by the IRS.

Tracking Cost of Goods Sold (COGS)

COGS is one of the most critical — and most commonly mismanaged — numbers in e-commerce bookkeeping. Your cost of goods sold includes everything it takes to get a product into a customer's hands:

• Purchase price or manufacturing cost
• Inbound shipping and freight
• Import duties and tariffs
• Warehousing and fulfillment fees
• Packaging materials

Choosing an Inventory Valuation Method

The IRS requires you to pick a consistent method for valuing inventory:

FIFO (First-In, First-Out): Assumes the oldest inventory is sold first. This is the most common method for e-commerce and is generally recommended because it matches the natural flow of goods and provides a more accurate picture of current inventory value on your balance sheet.

Weighted Average Cost: Calculates the average cost of all units available for sale during the period. This is simpler to manage and works well for businesses selling homogeneous products where individual unit costs don't vary dramatically.

LIFO (Last-In, First-Out): Assumes the newest inventory is sold first. While this can reduce taxable income during periods of rising costs, it's less commonly used in e-commerce and is not permitted under international accounting standards (IFRS).

Whichever method you choose, stick with it. The IRS requires consistency, and switching methods requires formal approval.

Untangling Marketplace Payouts

This is where many online sellers lose the plot. When Amazon deposits $15,000 into your account, that number represents:

• Gross sales revenue
• Minus marketplace referral fees
• Minus FBA fulfillment fees
• Minus storage fees
• Minus refunds issued
• Plus any reimbursements
• Minus advertising costs (if using auto-deduct)

You need to break each payout into its components. Recording the net deposit as "revenue" dramatically understates your actual sales volume and makes it impossible to track your true fee burden.

Best Practices for Payout Reconciliation

1. Download settlement reports from each marketplace and payment processor for every payout period
2. Record gross revenue as total sales, then book each fee category as a separate expense
3. Reconcile monthly by matching your accounting records to bank deposits
4. Track refunds separately from sales — don't just net them out, as the pattern of returns tells you important things about product quality and customer satisfaction

Multi-State Sales Tax Compliance

Sales tax is arguably the single most complex aspect of e-commerce bookkeeping. After the Wayfair decision, most states have established economic nexus laws that require remote sellers to collect and remit sales tax once they exceed certain thresholds.

What You Need to Know for 2026

• 45 states plus D.C. currently impose sales tax on e-commerce transactions
• Most states use a $100,000 sales threshold to trigger economic nexus
• 15 states have eliminated the 200-transaction threshold as of mid-2025, simplifying compliance somewhat
• New York requires both $500,000 in sales AND 100 transactions
• California and Texas use a $500,000 threshold with no transaction requirement

Staying Compliant

• Monitor your sales by state monthly to identify when you're approaching nexus thresholds
• Register for a sales tax permit before you begin collecting — collecting without a permit is illegal in most states
• Automate wherever possible using tools like TaxJar, Avalara, or built-in marketplace tax collection
• File on time — late filing penalties add up quickly when you owe in 20+ states
• Keep records for at least four years as most states can audit that far back

Be aware that states including New York, California, and Michigan are now using AI-powered enforcement tools to cross-reference marketplace data against filed tax returns. Underreporting is getting caught faster than ever.

Payment Processing Fees: The Hidden Margin Killer

Payment processing fees are a deductible business expense, but many sellers don't track them precisely. Over the course of a year, these fees can represent 3-5% of gross revenue — a significant number that directly impacts your bottom line.

Track fees separately for each processor:

Processor	Typical Fee
Stripe	2.9% + $0.30 per transaction
PayPal	3.49% + $0.49 for standard
Square	2.6% + $0.10 in-person, 2.9% + $0.30 online
Amazon	6-45% referral fee by category
Shopify Payments	2.4-2.9% + $0.30 depending on plan

When you know exactly what you're paying each processor, you can make informed decisions about which channels are actually profitable after fees.

Managing Returns and Chargebacks

E-commerce return rates typically run 20-30% — far higher than the 8-10% seen in physical retail. Each return creates multiple bookkeeping entries:

1. Reverse the original revenue
2. Record any restocking fees charged to the customer
3. Account for return shipping costs (whether you or the customer pays)
4. Adjust inventory — returned items may go back into sellable stock, require refurbishment, or need to be written off
5. Track the refund through the payment processor (which may or may not refund its processing fee)

Chargebacks are even more complex because they involve the payment processor acting as an intermediary. Track chargebacks as a separate expense category so you can monitor the rate and identify problematic products or fraud patterns.

Setting Up Your Chart of Accounts

A well-organized chart of accounts is the foundation of useful financial reporting. For e-commerce, you'll want more detail than a standard small business setup:

Revenue Accounts:

• Sales by channel (Amazon, Shopify, wholesale, etc.)
• Shipping revenue collected from customers

COGS Accounts:

• Product costs
• Inbound freight
• Fulfillment and warehousing fees
• Packaging materials

Operating Expense Accounts:

• Marketplace referral fees (by platform)
• Payment processing fees (by processor)
• Advertising and marketing (by platform)
• Returns and refund costs
• Software and subscriptions
• Shipping supplies and postage

Liability Accounts:

• Sales tax collected (by state or as an aggregate)

This level of detail lets you answer critical questions: Which channel is most profitable? Are Amazon FBA fees eating your margin? Is your advertising spend on one platform generating better returns than another?

Automating Your Bookkeeping Workflow

Manual e-commerce bookkeeping doesn't scale. Once you're processing more than a few dozen transactions per day, automation isn't optional — it's essential for accuracy.

A solid automation workflow looks like this:

1. Sales channels (Shopify, Amazon, etc.) automatically sync transactions to your accounting system
2. Payment processors feed fee data and settlement reports into your books
3. Inventory management software tracks COGS and stock levels in real time
4. Sales tax tools calculate, collect, and file automatically
5. Bank feeds import deposits for reconciliation

The goal is to reduce manual data entry to near zero while maintaining the granularity you need for meaningful financial analysis.

Common Mistakes to Avoid

Recording net payouts as revenue. Your top-line revenue should reflect gross sales. Fees, refunds, and adjustments are separate line items.

Ignoring sales tax obligations. "I didn't know" is not a defense. Nexus monitoring should be part of your monthly routine.

Mixing personal and business finances. This is basic, but it's still the most common bookkeeping mistake among new sellers. Get a separate business bank account and credit card.

Not reconciling monthly. Small discrepancies compound over time. A $50 mystery variance in January becomes a $600 problem by December that takes hours to track down.

Treating inventory purchases as expenses. Inventory is an asset until it's sold. Expensing inventory at purchase distorts both your balance sheet and your profit and loss statement.

Neglecting to track shipping costs accurately. Shipping is often the second-largest cost after COGS. If you're offering "free shipping," you need to know exactly what it's costing you per order to price products correctly.

When to Get Professional Help

Consider hiring a bookkeeper or accountant experienced in e-commerce when:

• You're selling on three or more channels
• You have sales tax obligations in 10+ states
• Your annual revenue exceeds $250,000
• You're spending more than five hours per week on bookkeeping
• You're preparing for a business loan or investment round
• Your books haven't been reconciled in more than two months

A specialist who understands marketplace payouts, inventory accounting, and multi-state tax compliance will save you far more than they cost.

Keep Your Finances Organized from Day One

Running an e-commerce business means juggling dozens of financial data streams — but it doesn't have to mean chaos. The key is building the right systems early: a detailed chart of accounts, consistent reconciliation habits, and automation where it matters most.

Beancount.io offers plain-text accounting that gives you complete transparency and control over your financial data — no black boxes, no vendor lock-in. Every transaction is human-readable, version-controlled, and ready for AI-powered analysis. Get started for free and see why developers and finance professionals trust plain-text accounting for their e-commerce businesses.