Understand chart of accounts, revenue recognition, inventory valuation, tax reserves, and the SOP that separates profitable businesses from chaotic ones. Includes a spreadsheet template.
StoreWiz Team
Dec 27, 2025 · 14 min read
TL;DR
Ecommerce accounting is not the same as traditional bookkeeping. You need to track sales tax across 46+ states, reconcile payments from Shopify, Amazon, and PayPal on different schedules, account for COGS with landed costs, and handle inventory as an asset on your balance sheet. Most sellers overpay taxes or underpay them (triggering audits) because they treat revenue as income without subtracting returns, chargebacks, and marketplace fees first. This guide covers the exact chart of accounts, reconciliation workflows, and tax obligations every online seller needs.
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 by thousands, triggering state sales tax audits, or discovering at year-end that your “profitable” business actually lost money once you account for inventory shrinkage and uncollected receivables.
This guide walks you through the complete accounting and bookkeeping framework for ecommerce sellers — from setting up your chart of accounts to reconciling payments, tracking COGS, and staying compliant with sales tax in 2026.
A local retail store has one cash register, one location, and one set of tax rules. An ecommerce seller has none of those luxuries. Here is what makes online seller bookkeeping fundamentally different:
| Factor | Traditional Retail | Ecommerce |
|---|---|---|
| Sales Tax | 1 state, 1 rate | 46 states, 12,000+ jurisdictions |
| Payment Timing | Same-day deposits | 2-14 day delays across processors |
| Returns | Immediate in-store | 30-60 day windows, cross-period |
| Revenue Recognition | Point of sale | When shipped? When delivered? When charged? |
| Fees | Card processing only | Platform fees, marketplace commissions, app subscriptions, shipping labels |
These differences mean you cannot just hand your Shopify CSV to a generalist bookkeeper and expect accurate financials. You need an ecommerce-specific approach.
Your chart of accounts is the backbone of your bookkeeping. Most accounting software comes with a generic template that misses critical ecommerce categories. Here is the recommended structure:
Common Mistake
Do not lump all advertising into one account. When tax time comes, you need to know exactly how much you spent on each platform. Separating ad spend by channel also lets you calculate true ROAS per platform in your P&L.
Inventory accounting is where most ecommerce 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.
Step 1: Purchase inventory → Debit: Inventory Asset / Credit: Cash (or AP)
Step 2: Sell a unit → Debit: COGS / Credit: Inventory Asset
Step 3: Record revenue → Debit: Cash (or AR) / Credit: Revenue
The IRS requires you to use a consistent valuation method. The three options:
| Method | How It Works | Best For | Tax Impact |
|---|---|---|---|
| FIFO | First units purchased are first expensed | Most ecommerce sellers | Higher taxable income when costs rise |
| LIFO | Last units purchased are first expensed | Rare for ecommerce | Lower taxable income when costs rise |
| Weighted Average | Average cost across all units | High-SKU stores with frequent reorders | Smooths out cost fluctuations |
Your true COGS is the landed cost — everything it takes to get the product into your warehouse ready to ship:
Example Calculation
Product cost: $8.00 + Freight: $1.80 + Duties: $0.64 + Packaging: $0.75 + 3PL prep: $0.40 = Landed cost: $11.59. That is 45% higher than the raw product price. If you only track the $8.00 in your books, your profit calculations are wrong on every single order.
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:
Pro Tip
Create a “clearing account” for each payment processor. When a sale happens, book revenue and debit the clearing account. When the deposit arrives, credit the clearing account and debit cash. Any remaining balance in the clearing account represents fees, returns, or holds — making discrepancies immediately visible.
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.
You have sales tax obligations in a state if any of these apply:
As of 2026, nearly every state with sales tax has marketplace facilitator laws. This means Amazon, Walmart, Etsy, and similar platforms collect and remit sales tax on your behalf for orders placed through their marketplace.
However, you are still responsible for:
Warning
FBA sellers have physical nexus in every state where Amazon stores your inventory. Amazon distributes your products across dozens of fulfillment centers. You may have nexus in 20+ states without realizing it. Check your FBA inventory placement reports quarterly.
The frequency depends on your revenue. Here is a practical schedule:
| Task | Under $50K/mo | $50K–$250K/mo | $250K+/mo |
|---|---|---|---|
| Bank reconciliation | Monthly | Weekly | Daily |
| P&L review | Monthly | Weekly | Weekly |
| Inventory count | Quarterly | Monthly | Monthly |
| Sales tax filing | Quarterly | Monthly | Monthly |
| Cash flow forecast | Monthly | Weekly | Weekly |
No single tool handles everything. Here is the recommended stack:
The challenge with this approach is managing multiple tools and ensuring data flows correctly between them. Platforms like StoreWiz are beginning to consolidate these functions — auto-categorizing expenses, syncing revenue data, and tracking per-SKU profitability without needing four separate subscriptions.
Key Takeaways
You can handle day-to-day bookkeeping yourself with QuickBooks and A2X, especially under $500K/year. However, you should hire an ecommerce-specialized CPA for tax planning, sales tax compliance setup, and annual tax filing. A generalist CPA often misses ecommerce-specific deductions and inventory accounting nuances. Budget $2,000–$5,000/year for a good ecommerce CPA.
Book returns when the refund is processed, not when the customer initiates the return. If a sale was recorded in January and the refund processes in February, the return hits February's books. For year-end reporting, estimate a return reserve based on your historical return rate (typically 15–30% for apparel, 5–10% for other categories).
If you have inventory, the IRS generally requires accrual basis for businesses over $27 million in gross receipts (as of 2026). Below that threshold, many ecommerce sellers use a hybrid approach: accrual for inventory and COGS, cash for operating expenses. Your CPA should determine the best method for your tax situation.
Amazon bundles dozens of fee types into their settlement reports: referral fees, FBA fulfillment fees, storage fees, advertising costs, reimbursements, and more. Use A2X to automatically break these into separate accounting categories. Referral fees and FBA fulfillment fees are COGS. Storage fees and advertising are operating expenses. Reimbursements should offset the original fee category.
Keep all financial records for at least 7 years (the IRS can audit up to 6 years back in cases of significant underreporting). This includes bank statements, payment processor reports, supplier invoices, shipping receipts, sales tax filings, inventory counts, and all accounting software backups. Store digital copies in cloud storage with regular backups.
Written by StoreWiz Team
Accounting
The StoreWiz team writes about ecommerce automation, AI operations, and growth strategies for modern online sellers. Our insights come from building technology that helps brands scale without scaling headcount.
Mar 29, 2026 · 18 min read
Mar 27, 2026 · 20 min read
Mar 25, 2026 · 18 min read
Join 2,000+ ecommerce operators getting weekly insights on autonomous commerce, pricing tactics, and AI growth.
No spam. Unsubscribe anytime.