Ecommerce Bookkeeping: Why Your Amazon and Shopify Numbers Never Seem to Add Up

Selling online was supposed to be simpler than running a store. Then came multi-channel fees, sales tax across 40 states, and a bank feed that makes no sense. Here's how sellers are finally getting their books under control.

If you sell online, you already know the strange math of it. Revenue hits your dashboard the moment an order comes in, but the actual money that lands in your bank account weeks later is smaller, delayed, and split up in ways that never quite match what you expected. Add a payment processor fee here, a returned order there, inventory sitting in three different warehouses, and sales tax rules that change depending on which state your customer happens to live in and suddenly "just check your bank balance" stops being useful advice.

This is the exact mess ecommerce bookkeeping exists to untangle. It isn't traditional bookkeeping with a different label stuck on it. Selling on Amazon, Shopify, eBay, or Walmart creates a genuinely different kind of financial picture, and treating it like a regular retail business is usually where sellers get into trouble.

Why ecommerce books are harder than they look

A normal business collects payment, records the sale, done. Ecommerce doesn't work that way, and a few things make it uniquely messy.

Payouts don't equal sales

Amazon and other marketplaces don't deposit money per order they batch dozens or hundreds of transactions into a single payout every week or two, after subtracting referral fees, FBA fees, advertising spend, and refunds. If you're recording "deposits" as revenue, your numbers are wrong before you've even started.

Multiple channels, one set of books

A lot of sellers run Amazon, their own Shopify store, and maybe eBay or Walmart at the same time each with its own fee structure, payout schedule, and reporting format. Pulling all of that into one clean, accurate set of books is where basic accounting software starts to struggle without proper setup.

Inventory is a moving target

Unlike a service business, ecommerce sellers have to account for inventory sitting in FBA warehouses, in transit, or on a shelf and know its actual cost, not just its retail price. Get this wrong and your profit margins on paper won't resemble your real ones at all.

Sales tax has genuinely gotten more complicated

Since economic nexus rules changed a few years back, sellers can owe sales tax in states where they've never set foot, simply by crossing a revenue or transaction threshold. Marketplaces collect some of this automatically, but not always all of it, and not always correctly which leaves sellers exposed if nobody's checking.

What proper ecommerce bookkeeping actually solves

Done right, this isn't just about tidier spreadsheets. It changes what you can actually see and decide.

• Real profit per product, per channel. Once fees, ad spend, and cost of goods are properly allocated, you find out which products (and which platforms) are actually making you money and which ones just look busy.
• Accurate cash flow forecasting. Knowing what's actually coming in, and when, instead of guessing based on a bank balance that lags reality by weeks.
• Sales tax that's handled before it becomes a problem. Nexus tracking and filing done proactively, not discovered during an audit letter.
• Clean books at tax time. No December scramble trying to reconstruct a year of marketplace statements, fee reports, and inventory adjustments.
• Numbers a lender or investor will actually trust, if you're looking to scale, get a business loan, or bring in outside capital.

What LMA Accounting & Consulting handles for online sellers

One example of how this looks in practice is LMA Accounting & Consulting, a firm that works with small and mid-sized businesses across the United States, Australia, and Singapore with a client list that leans heavily toward online sellers. Its work with Amazon, eBay, and Walmart sellers covers the parts of ecommerce bookkeeping that generic tools tend to miss: reconciling marketplace payouts down to the fee level, tracking inventory and cost of goods accurately across warehouses, and keeping multi-state sales tax compliance on track as a seller's footprint grows.

Alongside ecommerce-specific work, the firm also supports broader bookkeeping needs payroll processing (including Gusto), accounts payable and receivable, and GAAP-compliant financial statement preparation all run through QuickBooks Online or Xero, so sellers can see accurate numbers whenever they check, rather than waiting on a report that's already out of date by the time it arrives.

Questions to ask before you outsource your ecommerce books

Not every bookkeeper understands marketplace accounting, so it's worth checking a few things before you hand it over:

Have they worked with Amazon or Shopify sellers before? 
Marketplace fee structures and payout reconciliation aren't intuitive ask for specifics, not just a general "yes."

How do they handle inventory and cost of goods sold? 
This is where a lot of ecommerce books quietly go wrong.

Do they track sales tax nexus across states? 

With rules varying so much by state, this shouldn't be something you find out is missing at tax time.

What software do they use, and does it integrate with your sales channels? 

 QuickBooks and Xero both have ecommerce integrations, but not every provider sets them up correctly.

Frequently asked questions

Is ecommerce bookkeeping different from regular small business bookkeeping? 

Yes, in practical terms. Marketplace payouts, multi-channel sales, inventory tracking across warehouses, and varying state sales tax rules all add complexity that standard bookkeeping setups usually aren't built to handle out of the box.

Do I need separate bookkeeping if I sell on both Amazon and Shopify? 

You need one clean set of books, but the process for getting there usually means reconciling each channel separately before combining them since Amazon, Shopify, and eBay each report sales, fees, and payouts differently.

How does sales tax work for online sellers now? 

Most states require sellers to collect and remit sales tax once they cross a certain revenue or transaction threshold in that state, known as economic nexus. Marketplaces often collect this automatically for marketplace sales, but sellers are still responsible for tracking where they owe and confirming it's being handled correctly.

Can accounting software alone handle ecommerce bookkeeping? 

Software like QuickBooks Online or Xero can handle it well, but usually needs to be set up with the right integrations and chart of accounts for ecommerce specifically a default setup often misclassifies marketplace payouts and fees.

When should an online seller consider outsourcing their bookkeeping? 

Common signs include not knowing true profit per product, spending hours trying to reconcile marketplace payouts, missing sales tax deadlines, or simply running out of time to keep books current while managing day-to-day selling.

---

Not sure if your ecommerce numbers are telling you the full story? 

Talk to LMA Accounting & Consulting