How do I handle multi-channel e-commerce accounting?
Multi-channel e-commerce accounting is difficult because each platform handles money differently. Amazon takes fees before depositing funds. Shopify processes payments through Shopify Payments or third-party processors. Etsy has its own fee structure and payout schedule. Your bank account ends up showing deposits that don’t match any single sales report.
The first principle is recording gross sales and fees separately. When you sell a $100 item on Amazon and $85 lands in your bank account, you didn’t make $85 in revenue. You made $100 in revenue and paid $15 in platform fees. This distinction matters for understanding your actual margins and for tax purposes. The IRS wants to see your gross sales, not just what ended up in your bank.
Integration software makes multi-channel accounting manageable. Tools like A2X, Link My Books, or Webgility connect Amazon, Shopify, eBay, and other channels directly to QuickBooks. They summarize daily or weekly sales, fees, refunds, and deposits so you don’t have to enter transactions manually. Merrimack Valley bookkeepers who work with online sellers can help configure these integrations correctly from the start, saving hours of reconciliation work each month.
Set up your chart of accounts to track revenue and fees by channel. You want to see Shopify sales separate from Amazon sales separate from Etsy sales. Same with platform fees. When you review your profit and loss statement, you should immediately see which channels are actually profitable after all costs are accounted for.
Reconcile each platform’s payouts individually, not just your bank account. Amazon’s bi-weekly settlement should match what hits your bank plus any amounts they withheld. Shopify’s daily payouts should tie to their transaction reports. When deposits don’t match, you have missing transactions, unrecorded refunds, or fee discrepancies that need investigation.
Sales tax adds complexity. Amazon and certain states require marketplace facilitator collection, meaning the platform handles sales tax for you in those jurisdictions. But you might still owe sales tax on direct website sales or in states where platforms don’t collect on your behalf. Tracking which sales had tax collected by the platform versus which need separate remittance is essential for staying compliant.
Inventory accounting gets complicated when you’re selling the same products across multiple channels. You need one inventory system that decrements stock regardless of which platform made the sale. Otherwise you’re manually adjusting inventory constantly or overselling products you don’t have.
Most e-commerce sellers who struggle with their books aren’t tracking platform fees correctly or aren’t reconciling each channel separately. If you’re spending hours trying to match deposits to sales reports or you can’t tell which channel is actually profitable, your accounting setup needs attention. Getting the foundation right means you can use your financial data to make real decisions about where to focus your selling efforts.
The Merrimack Valley's Trusted Accounting Partner
The Next Step:
A 15-Minute Call
Tell us about your business and what you're dealing with. We'll listen, ask a few questions, and give you a straightforward quote.
More Questions
How do I manage accounts receivable for a medical practice?
Medical practice AR requires managing two collection streams: insurance companies and patients. Success depends on clean claim submission, systematic denial management, and prompt patient billing once insurance pays their portion.
Read answerWhat accounting software is best for transportation businesses?
QuickBooks Online handles what most transportation businesses need. The software choice matters less than getting it configured correctly for per-mile tracking, equipment costs, and multi-state operations.
Read answerHow do I track food costs and inventory for my restaurant?
Tracking food costs requires weekly inventory counts, categorized purchase tracking, and proper accounting integration. Calculate cost of goods sold using beginning inventory plus purchases minus ending inventory, then divide by sales to get your food cost percentage.
Read answerWhat financial reports should a small business review monthly?
Every small business should review the profit and loss statement, balance sheet, and cash flow statement monthly. Beyond these three, accounts receivable and accounts payable aging reports help you manage cash and catch collection problems before they become serious.
Read answerCan a bookkeeper fix years of disorganized financial records?
Yes, a qualified bookkeeper can reconstruct and organize years of neglected financial records. The process involves gathering bank statements, sorting through documentation, and systematically rebuilding your books month by month.
Read answerWhat are the signs that my business needs professional bookkeeping help?
Common signs include not knowing your actual profitability, falling months behind on reconciliations, dreading tax season, and spending hours on books instead of running your business. If your CPA is charging extra to clean up your records, that's a clear signal.
Read answer
