Why Channel Attribution Matters
Multi-channel sellers often don't know which platform is truly profitable. Your consolidated P&L shows 20% profit, but Amazon might be 15% while Shopify is 40%. Without channel attribution, you can't make strategic decisions about where to invest time and inventory.
Channel attribution tells you: "Platform X generated $50K revenue at 22% margin while Platform Y generated $30K at only 8% margin." This insight drives better resource allocation.
Setting Up Channel Attribution in QB/Xero
Method 1: Separate Income Accounts (Simplest)
- Amazon FBA Revenue
- Amazon FBM Revenue
- Shopify Revenue
- eBay Revenue
- Etsy Revenue
- Direct Sales Revenue (if any)
Each channel gets its own revenue account. Expenses can be allocated by channel or kept consolidated (depends on detail needed).
Method 2: Department/Class Tracking (More Detailed)
Use QB's "Class" feature or Xero's "Departments" to tag every transaction by channel:
- All Amazon sales tagged "Amazon"
- All Shopify sales tagged "Shopify"
- All expenses tagged to channel
- Run P&L by class/department for channel breakdown
Best for: Sellers wanting detailed channel-level profitability
Method 3: Hybrid (Recommended)
- Revenue: Separate accounts by channel (for easy reconciliation)
- COGS: By channel if significant differences, otherwise consolidated
- Expenses: Use Classes/Departments for allocation
- Result: Channel-level P&L with manageable complexity
Real Example: Multi-Channel P&L
| Item | Amazon FBA | Shopify | eBay | Total |
|---|---|---|---|---|
| Revenue | $60,000 | $30,000 | $15,000 | $105,000 |
| COGS | -$24,000 | -$12,000 | -$6,000 | -$42,000 |
| Gross Profit | $36,000 (60%) | $18,000 (60%) | $9,000 (60%) | $63,000 (60%) |
| Referral Fees | -$4,800 | $0 | -$900 | -$5,700 |
| Fulfillment Fees | -$5,400 | -$1,200 | -$900 | -$7,500 |
| Advertising | -$6,000 | -$2,000 | -$1,000 | -$9,000 |
| Allocated Overhead (15%) | -$9,000 | -$4,500 | -$2,250 | -$15,750 |
| Net Profit | $10,800 (18%) | $9,300 (31%) | $3,950 (26%) | $24,050 (23%) |
Insight: Shopify is the most profitable (31% margin) despite lower revenue. If you had to cut one channel, eBay is the weakest. This insight only comes from proper channel attribution.
Allocating Shared Expenses by Channel
Method 1: Revenue Percentage (Fairest)
Allocate overhead proportional to each channel's revenue:
- Total overhead: $15,750
- Amazon = 57% of revenue → $8,978 overhead
- Shopify = 29% of revenue → $4,567 overhead
- eBay = 14% of revenue → $2,205 overhead
Method 2: Direct Allocation
Allocate specific expenses directly to channels:
- Amazon ads: $6,000 → charge Amazon channel
- Shopify hosting: $30/month → charge Shopify
- Shared accountant fee: Allocate by revenue %
Method 3: Unit-Based
Allocate overhead equally per unit sold:
- Amazon: 500 units
- Shopify: 300 units
- eBay: 200 units
- Total overhead ÷ 1,000 units = $15.75/unit
Works better if: Similar products across channels and margins
Channel-Specific Accounting Issues
Amazon-Specific
- Account Holds: Reserve funds not immediately paid out
- Chargebacks: Reversed within 90 days
- FBA Fees: Complex breakdown (referral + FBA + processing)
Shopify-Specific
- App Charges: Track separately as Shopify expenses
- Shipping Labels: Deduct from revenue or separate expense
- Platform Fees: Typically lower than Amazon (2.9% + payment)
eBay-Specific
- Auction vs. Fixed-Price: Different fee structures
- Markdown Manager: Automatic price reductions
- Insertion Fees: Charged upfront per listing
Channel Attribution Mistakes to Avoid
- Forgetting to separate revenue: Can't isolate channel performance
- Not allocating overhead: Makes unprofitable channels appear profitable
- Over-complicated allocation: System too complex to maintain
- Ignoring platform-specific costs: Thinking all channels have 15% fees
- Manual tracking only: Can't scale; automate with Classes/Departments
Summary: Channel Attribution Setup
Step 1: Create separate revenue accounts for each channel
Step 2: Use Classes or Departments to tag all expenses by channel
Step 3: Allocate overhead by revenue percentage (fairest method)
Step 4: Run monthly P&L by channel to analyze profitability
Result: Know which channels are truly profitable and make data-driven scaling decisions