Ecommerce Accounting and Bookkeeping: The Complete Guide for Online Sellers

If you sell products online, your bookkeeping is more complicated than a typical small business. You have multiple payment processors depositing money on different schedules, sales tax obligations in states you have never visited, inventory sitting in warehouses that counts as an asset until it ships, and returns that reverse revenue weeks after the original sale.

Get it wrong and the consequences are real: overpaying estimated taxes, triggering a state sales tax audit, or discovering at year-end that your profitable business actually lost money once you account for inventory shrinkage and uncollected receivables.

This guide walks through the complete accounting framework for ecommerce sellers, from setting up your chart of accounts to reconciling payments, tracking COGS, and staying compliant with sales tax.

Why ecommerce accounting is different from traditional bookkeeping

A local retail store has one cash register, one location, and one set of tax rules. An ecommerce seller has none of those luxuries. What makes online seller bookkeeping fundamentally different:

• Sales tax: a local shop deals with one state and one rate; an online seller can owe tax across dozens of states and thousands of local jurisdictions.
• Payment timing: a shop gets same-day deposits; online processors pay on delays of roughly two to fourteen days.
• Returns: in-store returns are immediate; online returns arrive weeks later, often in a different accounting period.
• Revenue recognition: a register records revenue at the point of sale; online you must decide when it is earned, at ship, at delivery, or at charge.
• Fees: a shop pays card processing; an online seller also pays platform fees, marketplace commissions, app subscriptions, and shipping labels.

These differences mean you cannot just hand your Shopify export to a generalist bookkeeper and expect accurate financials. You need an ecommerce-specific approach.

Setting up your ecommerce chart of accounts

Your chart of accounts is the backbone of your bookkeeping, and most software ships with a generic template that misses critical ecommerce categories. A recommended structure:

Revenue accounts.

• Product revenue, split by channel (for example Shopify and Amazon separately).
• Shipping revenue, what customers pay toward shipping.
• Returns and refunds, a contra-revenue account that reduces gross revenue.
• Discounts given, also contra-revenue.
• Chargebacks, contra-revenue.

Cost of goods sold accounts.

• Product cost, the purchase price from your supplier.
• Inbound freight and duties.
• Packaging materials.
• Outbound shipping, your label costs, not what the customer paid.
• Fulfilment fees, such as FBA fees and 3PL pick-and-pack.
• Marketplace commissions, such as Amazon referral fees.

Operating expense accounts.

• Advertising, split by platform (Meta, Google, TikTok, and others).
• Software and SaaS, such as your Shopify subscription, apps, and tools.
• Payment processing fees.
• Warehousing and storage.
• Contractors and freelancers.
• Insurance.

Do not lump all advertising into one account. At tax time you need to know exactly what you spent on each platform, and separating ad spend by channel also lets you calculate true return on ad spend per platform in your profit-and-loss statement.

COGS and inventory accounting for ecommerce

Inventory accounting is where most sellers make their biggest mistakes. Inventory is an asset, not an expense. You do not expense inventory when you buy it, you expense it when you sell it. This distinction matters enormously for taxes and profitability reporting.

Inventory valuation methods. The IRS requires a consistent method. The three options:

• FIFO (first in, first out): the earliest units purchased are expensed first. Common for ecommerce; when costs are rising it produces higher taxable income.
• LIFO (last in, first out): the most recent units are expensed first. Rare for ecommerce; when costs are rising it produces lower taxable income.
• Weighted average: an average cost across all units. Good for high-SKU stores with frequent reorders, and it smooths out cost swings.

Calculating landed cost. Your true COGS is the landed cost: everything it takes to get a product into your warehouse ready to ship.

1. Product purchase price (ex-factory or FOB).
2. International freight (ocean, air, or courier).
3. Customs duties and import taxes.
4. Domestic freight (port to warehouse).
5. Inspection and quality control.
6. Packaging and labelling.
7. Warehousing prep fees (for a 3PL or FBA).

Payment reconciliation: matching deposits to sales

This is the most time-consuming part of ecommerce bookkeeping. The money that hits your bank account does not match your sales. Here is why:

• Shopify Payments deposits every couple of business days and nets out processing fees, refunds, and chargebacks before depositing.
• Amazon pays roughly every two weeks and deducts referral fees, FBA fees, storage, advertising, and returns before paying you.
• PayPal can hold funds for new sellers and deducts fees at the transaction level.
• Shop Pay Installments pays you in full upfront but charges a fee.

A step-by-step reconciliation process.

1. Record gross revenue at the order level, meaning what the customer paid including shipping and tax collected.
2. Record fees separately; do not book the net deposit as revenue.
3. Match deposits to the payout report from each processor.
4. Record returns as contra-revenue when processed, not when the customer initiates.
5. Reconcile sales tax collected against sales tax owed; they differ because of returns and platform-remitted tax.
6. Run a monthly bank reconciliation to catch any discrepancies.

Sales tax compliance for online sellers

Since the 2018 South Dakota v. Wayfair decision, states can require online sellers to collect sales tax even without a physical presence. The trigger is economic nexus: exceeding a revenue or transaction threshold in a state.

Where you have nexus. You have obligations in a state if any of these apply:

• Physical nexus: an office, warehouse, employee, or inventory in the state, and FBA inventory counts.
• Economic nexus: passing the state's threshold, commonly around $100,000 in sales or 200 transactions a year.
• Click-through nexus: affiliate relationships in the state.
• Marketplace nexus: selling on Amazon or Walmart, which remit tax for you in most states but not all.

Marketplace facilitator laws. As of 2026, nearly every state with a sales tax has these laws, so Amazon, Walmart, Etsy, and similar platforms collect and remit sales tax on your behalf for orders placed through their marketplace. You are still responsible for:

• Sales through your own Shopify store, where you must collect and remit.
• Filing returns in states where you have nexus, even if a marketplace handles collection.
• Tracking which states you have crossed thresholds in.
• B2B sales with tax exemption certificates.

FBA sellers have physical nexus in every state where Amazon stores their inventory, and Amazon spreads products across many fulfilment centres. You can end up with nexus in twenty or more states without realising it, so check your FBA inventory placement reports regularly.

How often to do your books

The right frequency scales with revenue. A practical schedule:

• Bank reconciliation: monthly for smaller stores, weekly as you grow, daily at high volume.
• Profit-and-loss review: monthly when small, weekly once you are past early scale.
• Inventory count: quarterly when small, monthly as volume grows.
• Sales tax filing: quarterly or monthly, depending on the state and your volume.
• Cash-flow forecast: monthly when small, weekly as you grow.

Accounting tools and software for ecommerce

No single tool handles everything. A common stack:

Accounting software.

• QuickBooks Online, the most popular option with strong integrations, a common choice for smaller sellers.
• Xero, a cleaner interface that suits multi-currency sellers well.
• NetSuite, enterprise-grade for larger businesses.

Ecommerce-specific add-ons.

• A2X, which reconciles Shopify and Amazon payouts into your accounting software.
• TaxJar or Avalara, which automate sales tax calculation and filing.
• Cin7 or SkuVault, inventory management with COGS tracking.

The challenge with this approach is managing several tools and keeping data flowing correctly between them. An operating-system approach to the store is designed to consolidate functions like these, auto-categorising expenses, syncing revenue data, and tracking per-SKU profitability, rather than stitching together separate subscriptions. What is live today from StoreWiz is the free store audit; the autonomous platform is in active development.

Seven common ecommerce bookkeeping mistakes to avoid

1. Booking net deposits as revenue. Your Shopify payout is not your revenue; it is revenue minus fees, refunds, and chargebacks. Always book gross revenue and record deductions separately.
2. Expensing inventory purchases immediately. A large inventory order is an asset, not an expense. Expensing it in the month of purchase destroys profit-and-loss accuracy and can understate taxable income.
3. Ignoring sales tax obligations. States are getting aggressive about enforcement, and penalties include back taxes, interest, and fines.
4. Mixing personal and business expenses. This is the fastest way to trigger an audit. Use separate bank accounts and cards for the business.
5. Not reconciling Amazon payouts. Amazon deducts dozens of fee types; without reconciling, you never know your true Amazon profitability.
6. Forgetting inventory shrinkage. Damaged goods, lost shipments, and warehouse miscounts reduce inventory value. Adjust regularly.
7. Waiting until year-end to do the books. Twelve months of unreconciled transactions take many hours to clean up; monthly bookkeeping takes a fraction of that.

Key takeaways

• Set up an ecommerce-specific chart of accounts with revenue, COGS, and expense categories per channel.
• Inventory is an asset until sold; use a consistent valuation method and cost it at landed cost, not just purchase price.
• Reconcile processor deposits to gross revenue, booking fees and returns separately.
• Sales tax nexus applies wherever you have inventory or employees, or wherever you exceed the economic threshold.
• Marketplace facilitator laws cover Amazon and Walmart sales but not your own Shopify store.
• Do your books monthly; annual catch-ups cost far more time and invite errors.
• Use a connector such as A2X to bridge Shopify and Amazon payouts to your accounting software.

Frequently asked questions

Do I need a CPA or can I do this myself? You can handle day-to-day bookkeeping yourself with tools like QuickBooks and A2X, especially at lower revenue. But you should hire an ecommerce-specialised CPA for tax planning, sales tax setup, and annual filing; a generalist often misses ecommerce-specific deductions and inventory nuances.

How do I handle returns that cross accounting periods? Book returns when the refund is processed, not when the customer initiates. A sale recorded in January and refunded in February hits February's books. For year-end reporting, estimate a return reserve based on your historical return rate, which tends to run higher for apparel than for most other categories.

Should I use cash basis or accrual basis accounting? If you hold inventory, the IRS generally requires accrual for larger businesses. Below that threshold, many sellers use a hybrid: accrual for inventory and COGS, cash for operating expenses. Your CPA should determine the best method for your tax situation.

How do I account for Amazon FBA fees? Amazon bundles many fee types into its settlement reports: referral fees, fulfilment fees, storage, advertising, reimbursements, and more. A connector like A2X can split these into separate categories. Referral and fulfilment fees are COGS; storage and advertising are operating expenses; reimbursements offset the original fee.

What records do I need to keep, and for how long? Keep financial records for at least seven years. That includes bank statements, payment processor reports, supplier invoices, shipping receipts, sales tax filings, inventory counts, and accounting backups. Store digital copies in cloud storage with regular backups.