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 handle sales tax on food and beverage sales?
Most states tax prepared food while exempting or reducing rates on grocery items. You need to know your local rates, configure your POS system correctly, and file on time to avoid penalties.
Read answerWhat are the most common QuickBooks setup mistakes?
The most common QuickBooks setup mistakes include using default chart of accounts without customization, choosing the wrong accounting method, and entering incorrect opening balances. These errors compound over time and become harder to fix.
Read answerHow do I account for food waste and spoilage?
Track spoilage in a dedicated expense account within cost of goods sold. Use a waste log to document what gets thrown out, and reconcile against physical inventory counts regularly.
Read answerHow do I know if I need to collect sales tax in other states?
You need to collect sales tax in another state when you have nexus there, either through physical presence or by crossing economic thresholds. Most states require collection once you hit $100,000 in sales or 200 transactions annually.
Read answerHow do I register my business with the Massachusetts Department of Revenue?
Register through MassTaxConnect, the DOR's online portal. You'll need your federal EIN first, then select which tax types apply to your business and submit your information.
Read answerHow do I separate personal and business finances?
Open a dedicated business bank account and use it exclusively for business transactions. Get a business credit card, pay yourself through regular documented transfers, and track everything through accounting software from day one.
Read answer
