Bookkeeping for E-commerce: Managing Amazon and Shopify Finances

E-commerce bookkeeping comes down to tracking gross sales separately from platform fees and payouts, staying on top of sales tax nexus across states, keeping inventory and COGS accurate, and reconciling payment processor payouts every month. Get these four right and your books stay clean.

You made $10,000 in sales on Shopify last month. Congratulations! ...Except your bank account only grew by about $8,700. Where did the other $1,300 go?

Platform fees. Payment processing charges. A couple of refunds. Maybe an advertising bill. If your bookkeeping only records the $10,000 in sales and the $8,700 that landed in your account, your books are wrong in two directions at once — and you'll find out at tax time, when it's too late to fix gracefully.

Selling on Amazon, Shopify, Etsy, or any marketplace adds layers that a regular retail business never deals with: the platform takes its cut before you see a dime, payouts arrive in batches days after the sale, refunds and chargebacks flow backward, and your sales tax obligations can span a dozen states. Here's how to keep your books honest through all of it.

Why e-commerce bookkeeping is its own animal

A traditional store sells something and pockets the cash. Simple. An online seller has at least four money movements per sale: the customer pays the platform, the platform takes fees, the platform batches the remainder into a payout, and the payout hits your bank days later.

That gap between "sale" and "money in the bank" is where bookkeeping goes to die. Add in inventory sitting in an Amazon warehouse you've never visited, sales tax rules that differ by state, and returns that reverse everything — and you've got a bookkeeping challenge that needs its own playbook.

1. Track gross sales and fees separately — always

This is the number-one rule of e-commerce bookkeeping, and the one most sellers break.

Say you sell $10,000 on Shopify in a month. Shopify takes roughly $290 in payment processing fees plus platform costs, and you issue $380 in refunds. The payout hitting your bank is around $9,330.

Wrong way to record it: one $9,330 deposit labeled "Shopify sales." That understates your revenue (the IRS sees $10,000 in sales) and hides your fee expenses — which are tax-deductible.

Right way: record the full $10,000 as sales income, then record the platform fees, processing charges, and refunds as their own expense line items. Yes, it's more entries. It's also correct, and your accountant will be able to actually deduct those fees instead of guessing.

For Amazon sellers, the same principle applies to referral fees, FBA fulfillment fees, storage fees, and advertising costs — each is a separate, deductible expense. Amazon's settlement reports break these down; use them.

2. Reconcile payouts like your business depends on it (it does)

Platform payouts are batch deposits that combine many orders minus many fees. They're almost impossible to match to individual sales, and that's fine — you don't need to.

What you *do* need: at month-end, your recorded payouts should match your bank deposits, and your recorded sales should match your platform's sales reports. A simple monthly routine:

• Pull the platform's payout report (Shopify Payments payout report, Amazon settlement report).
• Compare each payout to the matching bank deposit.
• Investigate anything that doesn't line up — missing payouts are more common than you'd think, especially with Amazon's rolling reserve.

Do this monthly, not annually. Catching a missing $2,000 payout in February is a quick support ticket; catching it next April is a forensic project.

3. Get serious about sales tax nexus

Here's where e-commerce gets legally tricky. You don't just owe sales tax in your home state — you may owe it in every state where you have nexus, which can mean:

• Physical presence (your office, warehouse, or employees)
• Inventory stored in a state (hello, Amazon FBA sellers — your products sit in warehouses across the country, and that creates nexus)
• Economic nexus (exceeding a state's sales or transaction threshold, often $100,000 in sales or 200 transactions)

Most states now require marketplace facilitators (Amazon, Etsy) to collect sales tax on your behalf — but not all platforms, not all states, and not all product types. Shopify, for example, generally leaves collection to you. You need to know, state by state, who's collecting and who isn't. This is genuinely one area where a professional's guidance pays for itself.

4. Keep inventory and COGS accurate

If you sell physical products, your inventory is money sitting on a shelf (or in an FBA warehouse). Sloppy inventory tracking means wrong cost of goods sold, which means wrong profit figures, which means wrong taxes.

• Track inventory quantities and costs in QuickBooks or your inventory system — not in a spreadsheet you update "when you remember."
• Count inventory regularly. Annual counts are the minimum; quarterly is better for active sellers. Amazon's inventory reports help, but they're not a substitute for your own records.
• Record COGS when you sell, not when you buy. Buying $5,000 of inventory isn't a $5,000 expense — it's an asset swap (cash becomes inventory). The expense happens when each unit sells.
• Write off dead stock. Products that will never sell are still on your books as assets. Clearing them out (even at a loss) gives you an honest balance sheet and a legitimate deduction.

5. Separate your business finances completely

Mixing personal and business money is the fastest way to make e-commerce bookkeeping miserable. One dedicated business checking account, one business credit card — and run every platform payout, ad spend, and supplier payment through them. When everything business flows through two accounts, reconciliation takes minutes instead of hours.

6. Use integrations — but don’t trust them blindly

QuickBooks connects with Shopify, Amazon, and most major platforms through integration apps that sync sales, fees, and payouts automatically. These save enormous amounts of time, and for a growing store they're practically mandatory.

But integrations break. APIs change, syncs fail silently, and duplicates appear. Check your integration's sync status weekly, and spot-check a handful of synced transactions against your platform reports each month. An integration you never verify is just automated errors. (Sync failures are common enough that we've covered how to fix them — see the link below.)

A monthly bookkeeping routine that actually works

• Reconcile all platform payouts against bank deposits
• Record fees, refunds, and chargebacks as separate entries
• Update inventory counts and COGS
• Review sales tax collection vs. what's owed, state by state
• Check integration sync health
• Set aside estimated taxes (e-commerce income is lumpy — don't get caught short)

Thirty to sixty minutes a month. That's the whole routine once the system is set up.

Conclusion!

That brings us to the end of this guide on bookkeeping for e-commerce businesses. We hope the tips explained above helped you understand how to track platform fees, reconcile payouts, handle sales tax nexus, and keep your inventory honest. If you run into any difficulty applying them, consider consulting a qualified and experienced QuickBooks professional for further assistance.

FAQs

You may also like:

accounting for wholesalers

bookkeeping for freelancers

essential bookkeeping practices for contractors and construction

remote bookkeeping how businesses are cutting costs

QuickBooks integration errors: how to fix sync failures between QuickBooks and third-party apps