Ecommerce bookkeeping trips up more sellers than almost any other kind, because online sales hide their true numbers. If your books only record the money that lands in your bank account, your revenue, fees, and profit are all wrong. This guide explains how to do it right, whether you sell on Shopify, Amazon, or your own store.
The core problem: the deposit is not the revenue
When a customer buys from you, several things happen at once. The platform takes a fee, the payment processor takes a fee, some orders get refunded, and sales tax gets collected. Then, days later, a single lump sum lands in your bank account, netted after all of that. If you record only that deposit as revenue, you understate your sales, hide your fees, and lose track of tax. Everything downstream is distorted.
The fix is payout reconciliation: matching each deposit back to the orders and fees behind it, so your books show gross sales, total fees, refunds, and tax separately. That is the single most important habit in ecommerce bookkeeping.
The moving parts you have to track
Fees
Payment processing fees and platform fees quietly eat your margin. Recorded properly, they show you your true cost of selling. Buried inside net deposits, they are invisible until you wonder where your profit went.
Refunds and chargebacks
Refunds reduce revenue and returns affect inventory. Chargebacks add fees. These have to be recorded, not ignored, or your revenue looks higher than it is.
Inventory and cost of goods sold
For physical products, your gross profit depends on cost of goods. Track inventory and COGS and you can see real margin per product. Skip it and you are flying blind on which products actually make money.
Multiple channels and currencies
Selling across Shopify, Amazon, and a marketplace, sometimes in multiple currencies, multiplies the complexity. Each channel reports differently, and the books need to bring them into one clear picture.
Sales tax: the part sellers underestimate
Since economic nexus rules took hold, you can owe sales tax in states where you have no physical presence, simply because your sales there crossed a threshold. That means an online seller can have obligations in many states at once. You do not have to panic about it, but you do have to track it, so you know where you have nexus and can stay compliant. Clean bookkeeping keeps those records ready.
Choosing your software and setup
QuickBooks and Xero both work well for ecommerce; the key is clean integration with your sales channels and correct handling of fees, refunds, and inventory. For high volume stores, the manual approach breaks down fast, which is where automation earns its keep, pulling in channel data, categorizing it, and reconciling payouts with far less manual work and fewer errors.
A simple monthly rhythm
- Reconcile every payout back to its orders and fees.
- Record refunds, returns, and chargebacks.
- Update inventory and cost of goods.
- Review sales tax by state.
- Produce a profit and loss that shows true margin by channel.
Do this every month and you always know your real numbers. Leave it for the year and you face a painful, error prone catch-up right when taxes are due.
When to get help
Plenty of sellers start by doing their own books and hit a wall as volume grows and channels multiply. If reconciling payouts eats your evenings, or you are not confident your margins are right, that is the signal to bring in a specialist. Our ecommerce bookkeeping service handles all of the above, so you can focus on growing the store while your numbers stay accurate.
The payoff
Done right, ecommerce bookkeeping does more than keep you compliant. It tells you which products and channels make money, where fees are draining you, and whether your pricing works. That is the difference between guessing and running your store on real numbers.
Common ecommerce bookkeeping mistakes
- Recording deposits as revenue. The most common and most damaging error, it hides fees and refunds.
- Ignoring cost of goods. Without COGS, gross margin is meaningless.
- Forgetting sales tax nexus. Obligations can build quietly in states you have never visited.
- Mixing personal and business funds. This turns reconciliation into a nightmare and clouds your real numbers.
- Leaving it all for year end. A year of unreconciled payouts is far harder to untangle than twelve clean months.
Avoiding these five puts you ahead of most sellers and keeps your books genuinely useful.
Key takeaways
- The deposit that hits your bank is not your revenue; fees and refunds are hidden inside it.
- Reconcile payouts back to orders to see true sales and fees.
- Track inventory and cost of goods to know real gross margin.
- Sales tax nexus can apply in states where you have no physical presence.
Frequently asked questions
Why are ecommerce books so complicated?
Because a single sale can involve a platform, a payment processor, fees, refunds, and sales tax in multiple states, all netted into one bank deposit that hides the detail.
Do I owe sales tax in states I do not live in?
Possibly. Economic nexus rules can create sales tax obligations in states where you have enough sales, even without a physical presence. Tracking it correctly matters.
Should I use QuickBooks or Xero for my store?
Either works. The key is clean integration with your sales channels and correct handling of fees, refunds, and inventory.
