E-Commerce Accounting: From Shopify to Tax Season

E-commerce accounting is more complex than traditional retail. Between payment processors, multiple platforms, sales tax, and inventory, there's a lot to track. Here's your complete guide.

The E-Commerce Accounting Challenge

Online sellers face unique issues:

• Multiple revenue sources: Shopify, Amazon, Etsy, eBay
• Payment processor fees: Stripe, PayPal, Shop Pay
• Multi-state sales tax: Nexus complexity
• Inventory across locations: Warehouses, FBA, 3PL
• Returns and chargebacks: Constant adjustments

Setting Up Your Chart of Accounts

Revenue

• Shopify Sales
• Amazon Sales
• Wholesale Revenue
• Shipping Revenue (if charged)

Cost of Goods Sold

• Product Costs
• Inbound Shipping
• Packaging Materials
• Amazon FBA Fees
• Platform Selling Fees

Expenses

• Payment Processing Fees
• Marketing & Advertising
• Software & Subscriptions
• Warehouse/Fulfillment
• Returns & Refunds
• Chargebacks

Understanding E-Commerce Revenue

Gross vs. Net Revenue

Gross Revenue: What customers pay Net Revenue: What you actually receive

Example:

• Customer pays: $100
• Shipping: $10
• Platform fee: $15
• Payment processing: $3
• Net to you: $72

Recording Sales Correctly

You have two options:

Method 1: Gross Revenue Record full sale, then expense fees separately.

• Revenue: $100
• Expense - Platform fees: $15
• Expense - Processing fees: $3

Method 2: Net Revenue Record only what hits your bank.

• Revenue: $82

Recommendation: Use Method 1 for better analysis. You need to see your true costs.

Payment Processing Timing

The Delay Problem

Customer pays Monday → Funds arrive Thursday

Solution: Accrual Tracking

Record revenue when sale occurs, not when funds arrive. Use "Accounts Receivable - [Processor]" to bridge the gap.

Reconciling Payouts

Match each payout to underlying transactions:

• Gross sales
• Minus fees
• Minus refunds
• Equals payout

Inventory Accounting

COGS Calculation

COGS = Beginning Inventory + Purchases - Ending Inventory

Inventory Valuation Methods

• FIFO (First In, First Out): Most common
• LIFO (Last In, First Out): Not allowed for tax in some cases
• Average Cost: Weighted average of all units

Multi-Location Tracking

Track inventory across:

• Your warehouse
• Amazon FBA
• Shopify Fulfillment
• Third-party logistics (3PL)

Sales Tax Compliance

Understanding Nexus

You must collect sales tax where you have "nexus":

• Physical nexus: Office, warehouse, employees
• Economic nexus: Sales exceed threshold (varies by state)

Common Thresholds

Sales Tax Tools

Use automation:

• TaxJar
• Avalara
• Shopify Tax

These integrate with Ledger Flow for automatic tracking.

Platform-Specific Accounting

Shopify

• Payouts net of fees
• Separate fee breakdown available
• Connect via API for transaction-level detail

Amazon

• Settlement reports every 2 weeks
• Complex fee structure
• FBA fees, referral fees, storage fees
• Need Amazon Seller Central access

eBay

• Managed Payments payouts
• Fee breakdown in payments tab
• Combine with PayPal historical data

Returns and Refunds

Accounting for Returns

1. Reduce revenue for refund amount
2. Add inventory back (if applicable)
3. Note any non-recoverable costs (shipping, restocking)

Chargeback Accounting

1. Record as contra-revenue or expense
2. Track separately for analysis
3. Include chargeback fees

Monthly Reconciliation Process

Step 1: Reconcile Each Platform

Match platform reports to recorded revenue.

Step 2: Reconcile Payment Processors

Match payouts to bank deposits.

Step 3: Reconcile Inventory

Physical count vs. system quantities.

Step 4: Verify Sales Tax

Collected vs. remitted.

Tax Season Preparation

Gather These Documents

☐ 1099-K forms from all platforms/processors ☐ Sales tax filing records ☐ Inventory valuation ☐ COGS calculations ☐ Business expense documentation

Common E-Commerce Deductions

• Product costs
• Shipping supplies
• Platform and payment fees
• Advertising (Facebook, Google, Amazon)
• Software subscriptions
• Home office (if applicable)
• Professional services

E-Commerce Accounting Mistakes

1. Recording Net Instead of Gross

You miss cost analysis opportunities.

2. Ignoring Platform Fees

These can be 15-30% of revenue!

3. Poor Inventory Tracking

Leading to incorrect COGS and taxes.

4. Sales Tax Non-Compliance

Penalties and back taxes add up.

5. Mixing Personal and Business

Always separate accounts.

Automation Is Essential

Manual e-commerce accounting is nearly impossible. Too many transactions, too many platforms.

Ledger Flow's e-commerce features:

• Direct integrations: Shopify, Amazon, eBay, Stripe, PayPal
• Automatic fee separation: Gross up revenue
• Inventory sync: Real-time tracking
• Sales tax integration: Connect with TaxJar/Avalara
• Consolidated view: All platforms in one dashboard

Action Plan for E-Commerce Sellers

This Week: ☐ Set up separate business bank account ☐ Connect all platforms to accounting software ☐ Establish chart of accounts

This Month: ☐ Implement inventory tracking system ☐ Set up sales tax automation ☐ Reconcile last month's transactions

Ongoing: ☐ Weekly transaction review ☐ Monthly reconciliation ☐ Quarterly inventory count ☐ Sales tax filing on schedule

E-commerce success requires more than great products. Master your numbers, and scale with confidence.