Running an online store means juggling platform fees, refunds, inventory, shipping costs, and sales tax across dozens of states — often all at once. That complexity is exactly why ecommerce bookkeeping trips up so many online sellers. The deposit that hits your bank account is not your revenue, the sales tax you collect isn’t your money, and the inventory you bought isn’t an expense until it sells.
This guide breaks down how ecommerce bookkeeping actually works for US online sellers in 2026 — what makes it different, the mistakes that quietly distort your numbers, and the systems that keep your books clean and decision-ready.
Why ecommerce bookkeeping is different
Traditional bookkeeping assumes a simple flow: you make a sale, money comes in, you record revenue. Ecommerce breaks that assumption. When Shopify, Amazon, or Etsy pays you, they send a single net deposit — your gross sales minus platform fees, refunds, shipping labels, advertising, and sometimes sales tax, all rolled into one lump sum.
If you record that deposit as revenue, your books are wrong from the very first entry. Your sales look too low, your fees and expenses disappear, and your profit margin becomes a guess. This is the single most common reason ecommerce books are inaccurate — and it compounds every single payout.
Your bank deposit is a summary, not a sale. Good ecommerce bookkeeping breaks every payout back into gross sales, fees, refunds, and tax.
The 5 things that make ecommerce books messy
Sales tax and economic nexus in 2026
Since the Supreme Court’s 2018 South Dakota v. Wayfair decision, you can owe sales tax in a state where you have no physical presence at all. This is called economic nexus, and by 2026 nearly every state with a sales tax enforces it. The most common threshold is $100,000 in sales or 200 transactions into a state in a year, though some states (like Illinois and Utah) have dropped the 200-transaction rule to simplify things for smaller sellers.
You can also trigger physical nexus without realizing it — for example, if Amazon stores your inventory in a fulfillment center in another state, that inventory can create a filing obligation there.
Critically, platforms handle sales tax very differently:
Even when a marketplace remits for you, you still need to track it in your books and know where you have nexus — because your own Shopify or website sales are entirely your responsibility. Our tax services include multi-state sales tax tracking for exactly this reason.
Tracking inventory and cost of goods sold (COGS)
For a product business, inventory is usually your single biggest number — and the one most often mishandled. The core rule: buying inventory is not an expense. It’s an asset sitting on your balance sheet. It only becomes an expense — cost of goods sold — at the moment it sells.
Get this wrong and everything downstream breaks: your profit is overstated in months you buy stock, understated in months you sell it, and your taxable income is unreliable. Clean ecommerce books track inventory purchases, landed costs (including shipping and duties), and COGS so your gross margin reflects reality.
The right ecommerce software stack
You don’t need enterprise software to keep clean books — you need the right combination for your size and channels.
Not sure which ledger to build on? Our breakdown of QuickBooks vs Xero walks through the trade-offs for US small businesses.
Your monthly ecommerce bookkeeping checklist
Monthly is the minimum for an online store; weekly is ideal once you’re doing meaningful volume. Each month you should:
- Reconcile every payout from each sales channel back to gross sales, fees, refunds and tax.
- Reconcile bank and credit card accounts to your books.
- Update inventory and record COGS for the period.
- Categorize advertising, shipping and software costs correctly.
- Review sales tax collected and check whether you’ve crossed nexus in any new state.
- Record refunds and chargebacks against the right sales and inventory.
- Produce a P&L and balance sheet so you actually know your margins and cash position.
A simple ecommerce chart of accounts
A clean chart of accounts makes everything above easier. A basic ecommerce structure looks like this:
When should you hire an ecommerce bookkeeper?
Plenty of sellers start out doing their own books — and that’s fine at low volume. But the math changes fast. If you’re selling on multiple channels, holding inventory, approaching sales tax nexus in several states, or simply spending hours each month untangling payouts instead of growing your store, it’s time to hand it off.
At Cloud Accountants, we handle ecommerce books remotely on QuickBooks and Xero — reconciling every channel, tracking inventory and COGS, and keeping your multi-state sales tax organized so your numbers are always decision-ready. Curious what it costs? See our guide to how much a bookkeeper costs.
Frequently asked questions
Do I record the full sale or just the payout amount?
Record the full gross sale, then separately record platform fees, refunds and sales tax. The net payout that hits your bank should reconcile to gross sales minus those deductions — never book the payout as revenue.
Does Shopify collect and remit my sales tax?
No. Shopify gives you tools to calculate and collect sales tax, but you are responsible for registering in states where you have nexus and for remitting what you collect. Marketplaces like Amazon, Etsy and eBay generally remit for you.
Is buying inventory a tax deduction?
Not when you buy it. Inventory is an asset; it becomes a deductible expense (cost of goods sold) only when the item sells. This is one of the most common and costly ecommerce bookkeeping mistakes.
How often should I do my ecommerce bookkeeping?
Monthly at a minimum. High-volume or multi-channel sellers benefit from weekly reconciliation so problems (like a spike in refunds or a new nexus state) are caught early.
Which accounting software is best for ecommerce?
Most US sellers use QuickBooks Online or Xero as the general ledger, paired with a connector like A2X or Synder to import payouts accurately from Shopify, Amazon and other channels.
Related reading
- How Much Does a Bookkeeper Cost for a Small Business in the US?
- QuickBooks vs Xero for US Small Businesses: Which Is Better in 2026?
- US Small Business Tax Deadlines 2026: The Complete Calendar
- Our Bookkeeping Services →
- Our Tax Services →
Cloud Accountants LLC is a US remote bookkeeping and tax firm serving small businesses and online sellers nationwide. This article is general information, not tax advice — sales tax rules vary by state, so consult a professional about your specific situation.
