Selling online produces more transactions, more fee types and more places money is held than an equivalent offline business, and the accounting has to keep up with all three.
The recurring frustration is that the platform's numbers and the accounting system's numbers never agree. Both are usually right: they measure different things, on different dates, on different bases.
This covers the challenges specific to selling online, how sales tax obligations arise across states, how to structure the accounts, the tools that help, and why the accounting basis matters more here than elsewhere.
E-commerce accounting is more complex than traditional retail accounting because revenue comes from multiple platforms, sales tax applies across many states, inventory moves rapidly, and payment processors add a timing layer between sale and bank deposit.
Key Accounting Challenges for E-Commerce Sellers
| Challenge | Why It Matters |
|---|---|
| Multi-channel revenue | Amazon, Shopify, Etsy, and your own store all report differently |
| Sales tax nexus | Economic nexus laws (Wayfair ruling) may require collection in 30+ states |
| Inventory tracking and COGS | FIFO or weighted average, must match your physical inventory flow |
| Returns and refunds | Must reverse revenue and COGS correctly; credit card fees may not reverse |
| Platform fees | Amazon referral fees, Shopify subscription, PayPal processing, classify correctly |
| Payment processor timing | Stripe/PayPal deposits lag sales by 1-3 days, creating reconciliation challenges |
The platform reports orders when placed, gross, in its own time zone. The accounting system records revenue when earned, net of cancellations, in your period. Both can be right. Reconcile them monthly and write down why they differ rather than trying to make them equal.
Abhinav Gupta, CPA, CA, MBA · LinkedInSales Tax Nexus After Wayfair
The 2018 South Dakota v. Wayfair Supreme Court ruling eliminated the physical presence requirement. Most states now impose economic nexus thresholds.
- Once you hit a state's threshold, register for a sales tax permit in that state
- Use TaxJar or Avalara to automate sales tax calculation and filing across states
- Marketplaces like Amazon and Etsy act as Marketplace Facilitators in most states, they collect and remit sales tax on your behalf, reducing your direct obligation
Chart of Accounts for E-Commerce
| Account | Category |
|---|---|
| Product Revenue, Shopify | Income |
| Product Revenue, Amazon | Income |
| Returns and Refunds | Contra-Income |
| Cost of Goods Sold | COGS |
| Inbound Shipping (to warehouse) | COGS |
| Amazon Referral Fees | COGS or Operating Expense |
| Payment Processing Fees | Operating Expense |
| Shopify Subscription | Operating Expense |
| Outbound Shipping to Customer | COGS (if charged to customer) or Operating Expense |
| Inventory Asset | Balance Sheet, Current Asset |
Tools for E-Commerce Accounting
| Tool | What It Does |
|---|---|
| QuickBooks Online + A2X | A2X translates Amazon settlement reports into clean QBO journal entries |
| Xero + Shopify integration | Syncs Shopify orders, refunds, and fees to Xero automatically |
| TaxJar | Automates sales tax calculation, reporting, and filing across US states |
| Avalara | Enterprise sales tax compliance for high-volume sellers |
| Inventory Planner | Demand forecasting and inventory purchasing recommendations |
Accrual vs Cash Basis for E-Commerce
Most small e-commerce sellers start on cash basis. Once revenue exceeds $1M, or if you are raising capital, switch to accrual. Accrual accounting recognises revenue when the sale occurs (not when PayPal deposits), and records inventory as an asset until sold.
Book a free consultation and we will get the numbers straight.
Frequently Asked Questions
How do I record Amazon settlement payments in my accounting?
Do not record the net deposit as revenue. Use A2X or a similar tool to break down each settlement into: gross sales, returns, Amazon fees, FBA fees, and reimbursements. Each goes to its correct account.
Do I need to collect sales tax if I sell only on Amazon?
In most states, Amazon collects and remits sales tax as a Marketplace Facilitator. You may still have a direct obligation for sales made through your own Shopify store or other non-facilitator channels.
How do I value my inventory for accounting purposes?
Most e-commerce businesses use FIFO or weighted average cost. FIFO matches the physical flow of most products and is simpler to audit. Avoid LIFO for e-commerce, it is not permitted under IFRS and complicates multi-country operations.
Why do the platform's sales figures never match the accounting system?
Because they are measuring different things, and both can be right. The platform reports orders at the moment they are placed, gross, in its own time zone. The accounting system records revenue when it is earned, net of cancellations, in your reporting period, and receives cash later still after fees and refunds. Reconciling the two monthly, and writing down the reasons they differ, is more useful than trying to make them equal.
How should returns and refunds be handled in the books?
As a reduction of revenue in the period the return happens, with the stock brought back in if it is resaleable and written off if it is not. Treating refunds as an expense makes the margin look healthier than it is and hides a rising return rate, which for most online sellers is the earliest warning that something is wrong with a product listing or a supplier.
Written by
Abhinav Gupta, CPA, CA, MBA
Abhinav works with business owners across the US on industry-specific bookkeeping, from dental practices and restaurants to construction and e-commerce. He writes about what each trade's books actually need. Connect on LinkedIn
Free consultation
Want Books You Can Rely On?
Book a free consultation and we will get the numbers straight.