The Multi-Channel Challenge
Selling on multiple platforms creates three problems:
- Fragmentation: Data scattered across 3-4 platforms, not centralized
- Reconciliation Nightmare: Each platform calculates fees differently, deposits on different schedules
- Profitability Blindness: You don't know which channel is actually profitable
Without proper accounting, you optimize for the wrong metrics and miss profitability leaks.
Consolidation Architecture
Structure Option 1: Separate Revenue Accounts (Recommended)
- Amazon FBA Revenue
- Shopify DTC Revenue
- eBay Marketplace Revenue
- Etsy Revenue
Pros: Easy to see which channel generates revenue
Cons: Expenses are consolidated; can't see channel-level profit
Structure Option 2: Class/Department Tracking (Best)
- All revenue tagged by channel (Amazon, Shopify, eBay, Etsy)
- All expenses tagged by channel
- Run P&L by class to see profit per platform
Pros: Complete channel profitability visibility
Cons: Requires discipline tagging every transaction
Structure Option 3: Hybrid
- Separate revenue accounts by channel (easy reconciliation)
- Use Classes for expense allocation
- Run channel-level P&L monthly
Recommended for most sellers - balance of accuracy and simplicity
Platform-Specific Reconciliation
Amazon Reconciliation
- Frequency: Every 14 days (deposit cycle)
- What to reconcile: Settlement Report total to bank deposit
- Checklist:
- Sales amount matches
- Referral fee calculation correct
- FBA fulfillment charges accurate
- Refunds properly recorded
- Chargeback deductions noted
- Net payout matches bank deposit
Shopify Reconciliation
- Frequency: Daily deposits (can do weekly)
- What to reconcile: Daily transaction report to daily deposits
- Checklist:
- Order count matches
- Shipping charges allocated
- Shopify fees deducted
- Refunds properly reversed
- Net deposit to bank is correct
eBay Reconciliation
- Frequency: Monthly (eBay settles monthly)
- What to reconcile: Monthly activity statement to bank deposit
- Checklist:
- Sales recorded
- Insertion fees deducted
- Final value fees calculated
- Refunds processed
- Month-end payout accurate
Common Multi-Channel Accounting Issues
| Issue | Cause | Solution |
|---|---|---|
| QB doesn't match bank | Missing transaction from one platform | Check platform reports for that date |
| Revenue looks wrong | Double-counted or missing refund | Verify each platform's transaction count |
| Fees unexpectedly high | Rates changed or chargebacks applied | Calculate fees based on actual rates |
| Can't see channel profit | Revenues separate but expenses aren't | Use Classes/Departments to tag expenses |
| Month-end takes days | Manual reconciliation of each platform | Use integration tools like Stitch Labs |
Tools for Multi-Channel Consolidation
Native Integrations (Free to $15/month)
- QB/Xero built-in Shopify app (free)
- Amazon Seller Connector (best in QB/Xero)
- eBay and Etsy apps (limited functionality)
Third-Party Platforms ($99-299/month)
- Stitch Labs: Best for multi-channel FBA/DTC
- Sellalytic: Good for Amazon-focused
- Inventory Lab: Budget option ($29-89/month)
Recommendation by Volume
Under $500K: Use native QB/Xero integrations
$500K-2M: Add Stitch Labs or Sellalytic
2M+: Consider custom integration or enterprise platform
Monthly Multi-Channel Close Process
- Download settlement/activity reports from each platform
- Verify totals match bank deposits
- Record any adjustments or missing transactions
- Reconcile each platform's revenue account
- Tag all expenses by channel (if using Classes)
- Run P&L by channel to analyze profitability
- Compare to prior month and identify variances
- Document any anomalies for investigation
Summary: Multi-Channel Accounting Strategy
✓ Structure: Separate revenue by channel; tag expenses by channel
✓ Reconcile: Each platform's statement to QB/Xero monthly
✓ Analyze: P&L by channel to identify most profitable
✓ Consolidate: One master P&L showing total business performance