Bookkeeping for E-Commerce Startups: What You Need to Track

Selling online creates a specific bookkeeping problem: what arrives in the bank bears little resemblance to what you sold.

Fees, refunds, chargebacks and holdbacks are all netted off before the money lands. Recording that net figure as revenue is the commonest early mistake, and it understates both sales and costs in a way that is slow to unpick.

This covers gross against net revenue, how platform fees are handled, when sales tax obligations arise, stock and cost of sales, returns and chargebacks, processor reconciliation, and the cash timing that follows.

E-commerce bookkeeping looks simple until you dig in. Platform fees, chargebacks, multi-state sales tax, inventory costing, and timing differences make it one of the more complex small business accounting challenges. Here's what you need to track, and how.

Revenue Recognition: Gross vs. Net

When Amazon, Shopify, or Etsy pays you, they deposit a net amount after deducting their fees. Your revenue is the gross sale price, not the payout.

• Record gross revenue (full sale price) as income
• Record platform fees (Amazon referral fees, Shopify transaction fees, PayPal fees) as separate expenses
• Never book only the net payout as revenue, it understates both income and expenses
• Use A2X, Synder, or similar tools to automate this split from platform reports

Platform Fees

Sales Tax Nexus

Post-South Dakota v. Wayfair (2018), e-commerce sellers must collect sales tax in states where they have 'economic nexus', usually $100,000 in sales or 200 transactions, even without physical presence.

• Track your gross sales and transaction count by state
• Register for sales tax in states where you cross the threshold
• Use TaxJar or Avalara to calculate, collect, and file automatically
• Know which states have marketplace facilitator laws (Amazon/Etsy/eBay collect and remit for you)

Pro Tip: Marketplace facilitator laws in most states mean Amazon handles sales tax collection for FBA sellers. Check which states still require your direct registration.

Inventory and COGS

Cost of Goods Sold (COGS) is the inventory cost of what you sold, not what you bought. The difference is your remaining inventory.

• COGS = Beginning Inventory + Purchases - Ending Inventory
• Choose an inventory costing method: FIFO, LIFO (prohibited under IFRS), or weighted average
• Most e-commerce businesses use FIFO, oldest units sold first
• Track inventory in QuickBooks (Plus or Advanced) or a dedicated system like Cin7 or Fishbowl

Returns and Chargebacks

Returns and chargebacks reduce your revenue and (sometimes) restore inventory. Book them correctly or your gross margin will be overstated.

• Returns: reverse the original sale; restore inventory if goods are restocked
• Chargebacks: record as a reduction of revenue; add chargeback fees as an expense
• Track return rates by SKU, high-return products destroy margins
• Reconcile platform refund reports monthly to your accounting software

Payment Processor Reconciliation

Stripe, PayPal, and Shopify Payments hold funds, batch payouts, and deduct fees before depositing. This creates a timing mismatch with your bank account.

• Reconcile each payment processor separately, monthly
• Track the 'in-transit' balance (collected but not yet deposited)
• Record processor fees as a separate expense line, not a revenue reduction
• Use A2X, Synder, or Reconcilely to automate reconciliation from platform reports

Cash Flow Timing

E-commerce cash flow has unique timing issues: you buy inventory (cash out), sit on it, sell it, wait for the platform to pay (7-14 day hold), then receive cash.

• Model your inventory purchase-to-cash cycle
• Track platform payment hold periods (Amazon pays every 14 days; Shopify every 1-5 days)
• Don't confuse platform payout deposits with revenue, revenue was recognized at sale
• Maintain a 30-60 day inventory float in your cash flow plan

Accrual vs. Cash Basis for E-Commerce

Most small e-commerce businesses start on cash basis. But if you carry inventory, accrual is more accurate, and required if you have over $25M in average annual gross receipts.

Frequently Asked Questions

Written by

Ankit Sagatani, MBA, B.Com

Ankit works with business owners across the US on industry-specific bookkeeping, from real estate to construction and retail. He writes about what each trade's books actually need. Connect on LinkedIn Connect on LinkedIn