Your bank balance says one thing, your P&L says another, and the Amazon settlement report looks like it was assembled by a committee of spiteful accountants. That's usually the moment an ecommerce founder realises bookkeeping for ecommerce isn't a tidy spreadsheet chore, it's the thing standing between “we're growing” and “we're bleeding margin.”
The annoying part is that the money doesn't land the way it used to. One order becomes a platform payout, then a bundle of refunds, fees, taxes, chargebacks, and timing differences. If you try to run that through a normal small-business ledger, you'll spend half your month doing forensic accounting with a coffee that's gone cold twice.
A lot of founders start with the same assumption. Sales are up, cash is coming in, the accountant can handle the rest. Then the questions start, and suddenly nobody can explain why the store looks healthy on paper but feels tight in the bank.
That's the first break from normal bookkeeping. In ecommerce, the bank deposit is usually a net payout, not the sale itself. The sale price has to be recorded as revenue, then separated from marketplace fees, refunds, sales tax, and processor charges, because the payout is just the leftover cash after everyone else took their cut. A practitioner guide notes that Amazon fees can average 30% to 35% of gross revenue for sellers, which is exactly why fee reconciliation isn't a nuisance line item, it's the whole game for a lot of operators (ecommerce seller bookkeeping guide).
That's why generic bookkeeping advice falls flat. Traditional bookkeeping asks, “What came in and what went out?” Ecommerce asks, “What happened inside the payout?” Those are not the same question, and if you answer the wrong one, your margin report turns into fan fiction.
Prepaid inventory makes the gap uglier. You pay suppliers before the customer buys, then the platform deposits cash later, often after deductions and delays. On top of that, marketplaces don't hand you one clean transaction per order, they hand you lump-sum settlements that combine multiple events.
Practical rule: if you can't explain a net deposit back to gross sales, fees, refunds, and taxes, you don't have bookkeeping yet. You have a cash log.
That's why ecommerce books need gross-method recording and channel-level reconciliation from day one. The goal isn't just neat tax filings, it's a true read on channel-level margin. Without that, you're pricing by instinct, not by profit.
The default chart of accounts most small businesses start with is too blunt for ecommerce. It gives you “sales,” “fees,” and maybe “shipping expense,” then acts surprised when margin reporting turns into a spreadsheet rescue mission.
Start with separate revenue and contra-revenue lines. Gross sales should stand alone, then sales discounts, refunds and allowances, and any shipping income should each get their own place. Marketplace costs need their own buckets too, split by type, because “fees” as a single line is basically accounting with blindfolds on.
You also want clean liability and cost accounts. Sales tax payable sits as a liability, not revenue. Inventory needs its own asset account, with COGS subaccounts that can support gross margin reporting. Then add clearaway accounts for ad spend and inventory write-downs, because those are the lines that get mangled first when teams are moving fast and nobody wants to be the bad guy.
If your chart can't separate a refund from a fee, it can't produce a trustworthy P&L.
A useful reference point is a plain-language breakdown of what belongs in a proper chart of accounts, which is worth comparing against your current setup in this chart of accounts guide.
The software layer should support the accounting structure, not flatten it. That means a real general ledger, channel integrations, an inventory module, a sales tax engine, and a reconciliation tool that can handle settlement timing. Using Stripe reports as your ledger is a classic shortcut that feels efficient until month-end, when someone has to reconstruct reality from exports and curse words.
The other common mistake is treating Shopify payouts as gross revenue. They're not. They're net deposits after platform activity has already happened. That's why a reconciliation tool matters, it turns the platform's settlement mess into journal entries your ledger can digest.
For sellers who want an outside sanity check on the ugly edge cases, Amazon accounting tips for suspended sellers is a useful specialist resource. It's the sort of thing people ignore until a payout freezes and suddenly every missing fee category becomes a fire drill.
Amazon is where many clean books go to die. One deposit can include gross sales, refunds, FBA fees, storage fees, advertising deductions, and sales tax collected, all collapsed into one net number. If that payout crosses month-end, you get a timing mess too, because the sale happened in one period and the cash landed in another.
Amazon settlement reports are the most annoying because they bundle everything. You have to peel apart the deposit, map each fee type to the right account, and separate settlement timing from actual economic activity. That's the only way to keep gross margin from wobbling when the bank balance shifts but the sales picture hasn't changed.
Shopify Payments is cleaner, but not clean. You still have pending balances, refunds, and processor deductions, and the payout cadence can leave you with an accounting period that looks softer than reality if you only watch cash. Stripe adds another wrinkle, because disputes and chargebacks can land well after the original sale, which means the revenue, fee, and reversal often live in different periods.
The process is boring, which is usually a good sign in accounting.
That last point matters. For scaled ecommerce, daily bookkeeping isn't automatically the highest-value habit. A disciplined payout-by-payout reconciliation cadence is usually better, because it respects each channel's settlement schedule and makes timing differences visible instead of hiding them in one giant net number.
The operational benchmark here is not sexy. A practitioner survey found that 82% of firms had to run manual monthly activity reports for ecommerce revenue sources at least some of the time, and more than a third had to manually match SKU or order details to payments or dates (Woodard survey). That's the tax on pretending marketplace settlements will reconcile themselves.
Rule of thumb: if a payout can't be explained in one reconciliation pass, it's not a bookkeeping system. It's a detective novel.
For teams that need their accounting stack to talk to the channels without constant babysitting, accounting software integration guidance is worth a look before piling on more tools.
Ecommerce books go off track fast when inventory is treated as a simple purchase log. If you capitalise only the supplier invoice and ignore freight, duties, prep, inspection, and storage before sale, gross margin looks cleaner than it is. Clean-looking margins do not help when pricing is based on a false cost base.
Landed cost is the number that matters, because it includes the full cost of getting inventory ready to sell. The product did not really cost you just the supplier invoice, it also cost the inbound freight, customs charges, prep work, and anything else needed before it could be sold. Leave those pieces out and you overstate margin, then make pricing decisions off numbers that flatter the business instead of describing it.
That is why a proper COGS process has to connect inventory movement to the P&L. The mechanics are worth spelling out in this COGS resource, because ecommerce teams need the cost logic set up cleanly before they start debating gross profit by product or channel.
FIFO usually fits ecommerce well because stock tends to move in waves and many catalogues turn quickly. It assumes the oldest units sell first, which keeps the inventory story readable when products are repriced or replenished at different costs. Weighted average can work for larger catalogs with frequent replenishment, but it smooths reality. That is useful in some businesses and misleading in others.
Specific identification is only practical when exact units must be tracked, which is rare unless the products are high-value or unusually distinctive. Stores with fewer than 50 SKUs rarely need that level of precision. They need a method that keeps the books consistent and the margins believable.
Obsolete stock, partial losses, and return-heavy SKUs have to show up somewhere. If inventory goes bad, write it down. If returns are predictable, reserve for them. If samples or damages are part of the business, expense them cleanly instead of shoving them into COGS and pretending the margin is fine.
A clean gross margin by SKU and by channel is the most useful report in ecommerce. Without it, you are making decisions with half the picture and calling that control.
Sales tax gets overcomplicated because people want it to be optional. It isn't. Once a state's economic nexus threshold is triggered, you owe tax there whether you've got a warehouse, an office, or just a laptop and optimism.
The bookkeeping rule is simple. Sales tax collected is a liability, not revenue. When you remit it, the liability comes down. When you collect it, the liability goes up. That's the whole flow, and it needs its own account so you don't accidentally inflate revenue by counting tax as sales.
That separation gets messy when marketplaces collect tax on your behalf. Some channels handle the collection and remittance directly, some don't, and founders often mix those two worlds in the same report. Then the gross sales number is wrong, the tax payable number is wrong, and everyone starts saying “we'll fix it next month,” which is finance for “we'll ignore it until it hurts.”
Automation tools help with filing, rate calculation, and jurisdiction tracking, but the bookkeeping layer still owns the underlying liability. If the sales tax balance is wrong, the filing output is just a polished mistake. That's why the chart of accounts from earlier matters so much, because it gives you a place to park collected tax before it leaves the business.
| Channel | Who Collects | Seller's Bookkeeping Job | Notes |
|---|---|---|---|
| Shopify store | Often the seller, depending on setup | Record tax in sales tax payable and exclude it from revenue | Watch destination-based rates |
| Amazon marketplace | Often the marketplace | Confirm how tax was handled in the settlement and keep liability clean | Settlement detail matters |
| Stripe checkout | Usually the seller through checkout configuration | Map collected tax separately from sales and fees | Don't net it into gross sales |
A useful decision checklist is pretty short. Which channels collect tax for you, which states have filings open, and where do you need a sales tax specialist because the rules have turned into a swamp? If you can answer those three without opening six tabs, you're in decent shape.
A clean close is not a heroic all-nighter. It's a repeatable sequence that tells you the business truth without drama. If you're still relying on vibes at month-end, you're not closing the books, you're negotiating with them.
The checklist is blunt. Bank and channel reconciliations done. COGS posted from inventory movements. Sales tax liability tied to filings. Prepaids adjusted. Unpaid bills accrued. Weird one-offs reviewed before they fossilise in the ledger.
That's the point where accounting stops being a compliance task and becomes an operating system. You can finally trust the numbers enough to make decisions about pricing, ads, and buying inventory without checking every line twice and then once more because the Amazon report looked funny again.
The reporting layer should collapse into one page that a founder can read. The report should show net revenue by channel, gross margin by channel, contribution margin after ads, cash conversion cycle, and refund rate. Everything else is secondary unless it changes a decision.
Sessions, click-throughs, and conversion rates are marketing metrics. They're useful, but they don't tell you whether the business is making money. The bookkeeping layer exists to produce the few numbers that drive real choices, like whether a channel deserves more budget or whether a SKU is consuming profits.
For a broader KPI framework, the e-commerce KPI guide from Carti is a handy reference. It's not a substitute for clean books, obviously, but it does help keep the dashboard from turning into decorative nonsense.
Clean close, clean decisions: if the KPI page can't be explained in five minutes, it's too busy.
A lot of ecommerce founders start with software because it feels controllable. QuickBooks or Xero, a few integrations, a sales tax app, and a steady stream of exports can work for a while. The problem shows up when Amazon settlements, Stripe payouts, returns, fees, and inventory changes stop lining up cleanly. At that point, the books are no longer just late, they start lying about margin.
DIY software means QuickBooks or Xero plus integrations and a sales tax tool. It is workable in the early days, especially if the catalogue is simple and the channel count is low. The trade-off is time and judgment. The owner ends up doing reconciliation in the cracks of the week, and those cracks get wider as orders grow, refunds spike, or a marketplace payout lands short of expectations.
Fully outsourced CPA firms buy you judgment, but not always speed. Month-end can drag if the firm is not built for ecommerce settlement data, and you often pay for expertise that you do not need on every task. It is safer than DIY, but it can feel like hiring a luxury car to drive three blocks. The books may be cleaner, yet the reporting can still arrive after the decisions have already been made.
Hybrid is the fit for a lot of operators. A remote bookkeeper handles daily or weekly reconciliation, then a CPA reviews monthly and handles tax complexity. That setup matches the actual workload once the business is past the stage where one person and a spreadsheet can keep up without breaking a sweat. It also gives you cleaner channel-level margin reporting, which matters more than pretty books that only satisfy a tax filing.
Recent industry guidance puts ecommerce bookkeeping costs commonly at $500 to $5,000+ per month (WebTonic). Smaller stores under $500K in revenue often land around $500 to $1,500 monthly, while larger operations above $5M may need $3,000 to $5,000+ for reconciliation, tax compliance, and financial planning. That is the budget reality before anyone starts pretending bookkeeping is a weekend project.
A separate industry breakdown says multi-channel brands typically pay 40% to 80% more than single-channel Shopify-only businesses, and Amazon settlement reconciliation alone can take 4 to 8 hours per biweekly payout even with automation tools in place. Those numbers explain why the hybrid model wins so often. It respects the actual workload instead of treating channel complexity like a software subscription problem. The cost is not just the bookkeeping fee, it is the margin leakage that hides when payouts, fees, and returns are not tied back to the right channel.
If you're still trying to do this in a spreadsheet, fair enough, but don't confuse stubbornness with effectiveness. Payout reconciliation and inventory accounting are judgment-heavy, and one missed fee category or misposted sales tax payment can cost more than a part-time professional.
That's why a pre-vetted remote bookkeeper or controller is usually the smartest next hire for ecommerce founders who've outgrown DIY. Remote finance talent in US time zones can cover channel reconciliation, month-end close, and reporting without the overhead of a traditional firm. HireAccountants is one place to find pre-vetted accountants and bookkeepers who can slot into that workflow quickly, which matters when the business needs a clean close in days, not weeks.
If your ecommerce books are still stitched together with exports, hunches, and a heroic amount of coffee, it's time to hand the ugly parts to someone who lives in them every day. Visit HireAccountants to find pre-vetted finance talent that can handle ecommerce reconciliation, inventory, and reporting without the usual hiring circus.
Let's simplify your finances today!