E-Commerce Bookkeeping: What Online Sellers Get Wrong (and How to Fix It)

If you sell online, your bookkeeping is more complex than a typical service business. You're dealing with marketplace payouts (Shopify, Amazon, Etsy), sales tax nexus across multiple states, inventory valuation methods, return/refund accounting, and payment processor reconciliation.

Most e-commerce sellers either over-simplify (dump everything into one revenue account) or over-complicate (track every SKU as a separate revenue line). Both approaches create problems at tax time. Here's the practical middle ground.

The #1 E-Commerce Bookkeeping Mistake

Recording marketplace deposits as revenue.

When Shopify deposits $4,200 into your bank account, that's NOT $4,200 in revenue. It's revenue minus fees, refunds, and chargebacks. The actual breakdown might be:

• Gross sales: $5,000
• Shopify fees: -$145
• Payment processing: -$155
• Refunds: -$400
• Chargebacks: -$100
• Net deposit: $4,200

If you record $4,200 as revenue, you're understating sales by $800 and hiding $400 in fees. Your P&L won't match your marketplace reports, and you won't know your true cost of processing.

The fix: Record gross revenue, then separate line items for fees, refunds, and chargebacks. Your accounting system should break down each marketplace payout into its components.

Chart of Accounts for E-Commerce

Revenue Accounts

• 4010 — Product Sales (Shopify / Direct)
• 4020 — Marketplace Sales (Amazon, Etsy, etc.)
• 4030 — Wholesale Revenue
• 4040 — Shipping Revenue (if you charge for shipping)
• 4500 — Refunds & Returns (contra-revenue, reduces total)

Cost of Goods Sold

• 5010 — Product Cost (inventory purchases)
• 5020 — Shipping & Fulfillment
• 5030 — Packaging & Materials
• 5040 — Customs & Import Duties
• 5050 — Marketplace Fees (Amazon referral fees, Shopify fees)
• 5060 — Payment Processing Fees (Stripe, PayPal)

Operating Expenses

• 6100 — Marketing & Advertising
• 6110 — Influencer / Affiliate Costs
• 6200 — Software & Subscriptions (Shopify, apps, tools)
• 6300 — Warehouse / Storage
• 6400 — Insurance (product liability, general)
• 6500 — Returns Processing (restocking, inspection)

Notice that marketplace fees and payment processing fees are in COGS, not operating expenses. This gives you an accurate gross margin — the most important number for an e-commerce business.

Sales Tax: The Multi-State Nightmare

Since the Supreme Court's *Wayfair* decision (2018), states can require online sellers to collect sales tax even without a physical presence. This created economic nexus: if you exceed a state's threshold (typically $100K in sales or 200 transactions), you must collect and remit sales tax there.

What You Need to Track

• Sales by state — to know where you have nexus
• Tax collected — as a liability (you owe this to the state, it's not your money)
• Tax remitted — payments to state tax authorities
• Exemptions — wholesale customers, tax-exempt organizations

Practical Approach

1. Use automated sales tax software — TaxJar, Avalara, or Shopify Tax handles calculation and filing
2. Record sales tax collected as a liability — not revenue
3. Reconcile monthly — tax collected should match tax remitted (within rounding)
4. Review nexus quarterly — you might cross thresholds in new states as you grow

Inventory Valuation

How you value inventory affects your taxable income. Three methods:

FIFO (First In, First Out)

Oldest inventory is sold first. During rising costs, FIFO shows higher profits (lower COGS) because you're “selling” cheaper, older inventory.

LIFO (Last In, First Out)

Newest inventory is sold first. Shows lower profits during rising costs (higher COGS). Better for tax savings. Note: LIFO is not allowed under IFRS, only US GAAP.

Weighted Average

Average cost of all units available for sale. Simplest method. Good for businesses with many similar items.

For most e-commerce businesses: FIFO is standard and easiest to implement. Use it unless your CPA recommends otherwise.

Dead Stock

Inventory that hasn't sold in 6+ months needs attention:

• Write it down to net realizable value (what you can actually sell it for)
• Liquidate through flash sales, bundles, or marketplace clearance
• Donate for a tax deduction (FMV for inventory donations)
• Write it off entirely if it's truly unsalable

Return and Refund Accounting

Returns are a reality of e-commerce (average return rate: 20-30% for apparel, 5-10% for other categories).

When a customer returns an item:

1. Record the refund as contra-revenue (reduces sales, doesn't increase expenses)
2. If the product goes back to inventory: reverse the COGS entry
3. If the product is damaged/unsalable: write off the inventory cost
4. Record any restocking fees as revenue offset

Chargebacks are different from refunds. Chargebacks include a fee from the payment processor ($15-50 per chargeback). Record the refunded amount as contra-revenue and the chargeback fee as an expense.

Reconciling Marketplace Payouts

Each marketplace has its own payout schedule and fee structure:

• Shopify: Pays daily or weekly depending on plan
• Amazon: Pays every 14 days, holds reserves for returns
• Etsy: Pays daily or weekly depending on history

For each payout, download the settlement report and reconcile:

• Gross sales in the period
• Minus: marketplace fees
• Minus: refunds processed
• Minus: chargebacks
• Minus: reserve holdbacks
• Equals: net deposit amount

Match the net deposit to your bank statement. The components go to their respective accounts (revenue, fees, refunds).

Monthly Bookkeeping Routine for E-Commerce

1. Reconcile all marketplace payouts to bank deposits (15 min per marketplace)
2. Record inventory purchases and update stock levels
3. Reconcile payment processors (Stripe, PayPal) to bank deposits
4. Review sales tax collected vs. liability account balance
5. Categorize non-marketplace transactions (ads, software, shipping supplies)
6. Review return rate and adjust refund reserves if needed
7. Generate P&L and check gross margin against target

With Holdings, steps 5 and 7 are automatic. Transactions categorize as they happen, and financial reports update in real time.

Open a Holdings account for your online business →