You made 47 sales on Amazon, 12 on Shopify, and 8 through your own website last week — and your bank account shows one lump deposit that doesn’t match any of it. If that sounds familiar, you’re not alone. Multi-channel ecommerce sellers consistently rank bookkeeping as one of their biggest operational headaches, mostly because each sales channel reports revenue, fees, and payouts differently. Get it wrong and you’ll either overpay taxes on money you never actually kept, or underreport income and invite an IRS notice. Here’s how to keep your books accurate across Amazon, Shopify, and every other channel you sell on.
Why Ecommerce Bookkeeping Is Different From Traditional Retail
A brick-and-mortar shop rings up a sale and the cash hits the register. Ecommerce doesn’t work that way. When a customer buys something on Amazon, the platform collects the payment, deducts referral fees, FBA fulfillment fees, storage fees, and sometimes advertising costs, and then pays you the net amount — often two weeks later, bundled with hundreds of other transactions into a single deposit. Shopify (through Shopify Payments or a third-party processor like PayPal or Stripe) does something similar, just with different fee structures and payout schedules.
If you record that single bank deposit as “sales income,” you’re understating your actual revenue and overstating your expenses — or worse, missing deductible fees entirely because they never show up as a separate line item in your books. This is the single most common bookkeeping mistake we see in ecommerce accounts, and it snowballs fast once you’re selling on three or four channels at once.
The Core Principle: Gross Revenue, Not Net Deposits
Proper ecommerce bookkeeping records transactions at the gross level, then breaks out each deduction separately. For every payout, your books should reflect:
- Gross sales — the full amount the customer paid, including shipping charged to them
- Sales tax collected — this isn’t your money; it’s a liability owed to the state
- Platform/referral fees — Amazon’s 8–15% referral fee, Shopify transaction fees, etc.
- Fulfillment fees — FBA pick, pack, and ship fees, or your 3PL’s charges
- Advertising spend — Amazon PPC, Shopify/Meta ads run through the platform
- Refunds and chargebacks — tracked separately from gross sales, not netted against them silently
- Net payout — the number that actually lands in your bank account
When these are broken out correctly, your gross sales figure feeds your revenue reporting (and matches what platforms report to the IRS on Form 1099-K), while fees and ad spend become deductible business expenses instead of disappearing into a mystery gap between “what customers paid” and “what hit my bank.”
Amazon Seller Central: Reconciling Settlement Reports
Amazon issues a Settlement Report roughly every two weeks that itemizes every sale, fee, refund, and adjustment in that payout period. This report is the source of truth — not the deposit amount in your bank feed. A few practical tips:
- Download settlement reports monthly at minimum, even if Amazon pays out biweekly, so nothing falls between reporting periods.
- Watch for “Long-Term Storage Fees” and “FBA Inventory Reimbursements” — both are easy to miss and both affect your taxable income.
- If you use QuickBooks or Xero, a connector app (like A2X or Link My Books) can automate this reconciliation instead of manual spreadsheet work. Our QuickBooks bookkeeping services and Xero bookkeeping services both support these integrations.
Shopify and Direct-to-Consumer Sales
Shopify is comparatively simpler than Amazon because you control more of the transaction, but the payout gap still exists. Shopify Payments typically deposits net of processing fees (around 2.9% + $0.30 per transaction as of 2026, though rates vary by plan) on a rolling schedule. If you’re also accepting PayPal, Klarna, or Affirm on your storefront, each of those adds its own fee structure and payout timing to reconcile.
Don’t forget shipping income and shipping costs — if you charge customers $8 for shipping but pay UPS $11, that’s real margin erosion your books need to reflect, not just a wash you ignore.
Multi-Channel Inventory and Cost of Goods Sold
Selling the same SKU across Amazon, Shopify, Walmart Marketplace, and Etsy means your inventory is fragmented across multiple warehouses (your own, Amazon FBA, a 3PL). For accurate Cost of Goods Sold (COGS) and gross margin reporting, you need:
- One unified inventory count across all locations, updated at least monthly
- Consistent costing method — most small ecommerce businesses use weighted average cost or FIFO (first in, first out)
- COGS recorded at time of sale, not when inventory is purchased, so your P&L reflects true per-period profitability
Without this, it’s common for ecommerce sellers to look profitable on paper while actually losing money on every unit sold after fees, shipping, and COGS are properly accounted for. This is one of the most valuable things a bookkeeper catches early — see our full bookkeeping services for how we structure this for multi-channel sellers.
Sales Tax: The Multi-State Nexus Problem
Since the 2018 South Dakota v. Wayfair Supreme Court decision, states can require you to collect sales tax based on economic nexus — meaning you can owe sales tax in a state simply by exceeding a sales threshold there (commonly $100,000 in sales or 200 transactions, though thresholds vary by state), even without a physical presence. Amazon and most major marketplaces now collect and remit “marketplace facilitator” sales tax on your behalf in most states, but if you also sell direct through Shopify, that tax collection is on you.
Track which channels are handling sales tax remittance for you and which aren’t — this is a compliance area where a mistake can mean real penalties, and it’s worth reviewing with a tax professional if you sell in more than a handful of states.
A Simple Monthly Ecommerce Bookkeeping Routine
- Export settlement/transaction reports from every sales channel
- Reconcile gross sales, fees, and refunds against bank deposits
- Update inventory counts and COGS across all fulfillment locations
- Review sales tax collected vs. remitted by channel
- Categorize advertising and platform fees as deductible expenses
- Generate a Profit & Loss statement by channel to see which platform is actually most profitable
Running this monthly — not scrambling at tax time — is what separates ecommerce businesses that know their real margins from ones guessing based on bank balance alone.
When to Bring in Professional Help
If you’re spending more than a couple of hours a month wrestling with settlement reports, or you genuinely don’t know your profit margin by channel, it’s usually time to hand this off. Multi-channel ecommerce bookkeeping is a specialized skill — the accounting itself isn’t conceptually hard, but the volume of transactions and the number of moving fee structures make manual tracking error-prone at scale. Ask For CPA’s online accounting services and full bookkeeping services are built around exactly this kind of multi-platform reconciliation. Check our pricing page for plans sized to sellers at different revenue levels.
This article is for general informational purposes and isn’t a substitute for advice from a licensed CPA or tax professional familiar with your specific business and state tax obligations.
Frequently Asked Questions
Do I need separate bookkeeping for each sales channel?
Not separate books entirely, but you do need channel-level detail within one unified accounting system. Tracking revenue, fees, and profitability by channel (Amazon vs. Shopify vs. Etsy, for example) lets you see which platforms are actually worth your time and ad spend.
What’s the difference between Amazon’s 1099-K and my actual taxable income?
Form 1099-K reports your gross unadjusted sales volume — it does not subtract fees, refunds, or COGS. Your actual taxable income is gross sales minus all deductible business expenses, including platform fees, shipping, advertising, and cost of goods sold. Never assume the 1099-K number is your profit.
Should I use QuickBooks or Xero for ecommerce bookkeeping?
Both work well and both integrate with ecommerce connector apps like A2X, Link My Books, and Synder. The right choice usually depends on what your bookkeeper or accountant is already set up to support. Our team works in both — see QuickBooks services or Xero services to compare.
How often should I reconcile my ecommerce accounts?
Monthly at minimum. Sellers with high transaction volume or multiple channels often benefit from weekly reconciliation so discrepancies get caught while the settlement reports are still fresh and easy to trace.
Ready to stop guessing at your real margins? Contact Ask For CPA for a free consultation and let us set up multi-channel bookkeeping that actually reflects what your ecommerce business is earning.
