featured article

The Annual P&L Review by Channel: Questions to Ask Twelve Months of Data

Konstantine Christofakis

November 14, 2026

An annual P&L review by channel asks one question in several forms: which channel turned this year's revenue into contribution, and which one just got bigger. Build each channel's P&L down to contribution after COGS, marketplace or payment fees, fulfillment, advertising, refunds, and storage. Compare it to last year. Then ask where the incremental revenue earned, whether fee and ad rates drifted, how much cash each channel ties up, and which SKUs drove each change. Shared overhead stays below the line. The eight questions below are the ones that change next year's plan.

Set up the channel P&L first

Each channel needs its own revenue, COGS, and variable cost lines. In QuickBooks that usually means classes or locations, set up as described in class and location tracking for channel P&L. Ad spend belongs to the channel it drove: Amazon Sponsored Products to Amazon, Walmart's ads to Walmart, and social or search spend that sends traffic to your own site to Shopify.

Rent, salaries, software, and the accountant do not get spread across channels for this review. Allocating them by revenue share makes the smallest channel look worse and the largest look better without telling you anything. Keep them as one block under total contribution.

The worked example

Illustrative numbers. Take a seller on Amazon, Shopify, and Walmart, closing 2026.

Amazon, 2026

  • Revenue: $2,400,000
  • COGS: $840,000
  • Marketplace fees: $744,000
  • Advertising: $312,000
  • Refunds: $96,000
  • Storage: $48,000
  • Contribution: $360,000, or 15.0 percent

Shopify, 2026

  • Revenue: $900,000
  • COGS: $306,000
  • Payment processing: $27,000
  • Shipping and 3PL fulfillment: $117,000
  • Advertising: $171,000
  • Refunds: $54,000
  • Contribution: $225,000, or 25.0 percent

Walmart, 2026

  • Revenue: $500,000
  • COGS: $185,000
  • Marketplace and fulfillment fees: $145,000
  • Advertising: $40,000
  • Refunds: $30,000
  • Storage: $10,000
  • Contribution: $90,000, or 18.0 percent

Total: $3,800,000 of revenue and $675,000 of contribution, 17.8 percent.

The 2025 comparison: Amazon earned $357,000 on $2,100,000 (17.0 percent). Shopify earned $213,200 on $820,000 (26.0 percent). Walmart earned $39,000 on $300,000 (13.0 percent).

The eight questions

1. Which channel grew contribution, not just revenue?

Amazon revenue rose 14.3 percent. Amazon contribution rose 0.8 percent, from $357,000 to $360,000. Shopify revenue rose 9.8 percent and contribution 5.5 percent. Walmart revenue rose 66.7 percent and contribution 130.8 percent. On revenue, Amazon had the best year in dollars. On contribution, Walmart did, adding $51,000 against Amazon's $3,000.

2. What did the incremental revenue earn?

Divide the change in contribution by the change in revenue. Amazon: $3,000 on $300,000 of new revenue, a 1.0 percent incremental margin. Shopify: $11,800 on $80,000, 14.8 percent. Walmart: $51,000 on $200,000, 25.5 percent. The extra $300,000 of Amazon sales was close to free work. That is the single most useful number in this review, and it never appears on a standard P&L.

3. Did fee rates drift?

Compute fees as a share of revenue by quarter for each channel. Amazon's fee basis moved twice in 2026: Amazon's selling partners site announced on October 15, 2025 an average FBA fee increase of $0.08 per unit effective January 15, 2026, and Seller Central's FBA fee page added a 3.5 percent fuel and logistics surcharge on fulfillment fees from April 17, 2026. In this example, Amazon fees ran 31.0 percent of revenue for the year. If they ran 29.5 percent in Q1 and 31.5 percent from Q2 onward (on even quarterly revenue, that averages to 31.0), the surcharge and a mix shift toward heavier items explain more of question 1 than any pricing decision did.

4. Is advertising buying growth or paying rent?

Advertising as a share of revenue: Amazon 13.0 percent, Shopify 19.0 percent, Walmart 8.0 percent. Shopify's ratio is the highest, and so is its contribution margin, so the level alone proves nothing. The trend does. Suppose Amazon ads ran 10 percent of revenue in 2025. The same ratio on 2026 revenue would have been $240,000. Actual spend was $312,000, so three extra points of revenue, $72,000, went to ads on a channel whose contribution rose $3,000. That is the shape of rent.

5. Where are refunds concentrated?

Refunds as a share of revenue: Amazon 4.0 percent, Shopify 6.0 percent, Walmart 6.0 percent. A channel-level rate hides which SKUs carry it. Refunds on Shopify often include returns of bundles or gift orders that never show on a marketplace, and a refund line without return-reason data can only say how much, not why.

6. How much cash does each channel tie up?

Contribution is not cash. Each channel carries inventory and a settlement lag. Amazon disburses on its settlement cycle, Walmart on its own, and TikTok Shop's 1099-K FAQ notes that the gap between a buyer's payment and settlement in the seller's wallet can run a few weeks. Add average inventory at cost held for each channel to the average undisbursed balance, and divide contribution by that sum. A channel earning 15 percent on revenue but turning its inventory twice a year can return less on its cash than one earning 12 percent with six turns.

7. What would have happened without the channel?

This one has no clean answer from the books. Some Walmart buyers would have bought on Amazon if Walmart did not exist. Some Shopify buyers first saw the product on Amazon. The P&L treats each channel's sales as its own. Before cutting a channel on its contribution, estimate how much of its revenue would move to the others and at what margin.

8. Which SKUs drove each channel's change?

Amazon's contribution margin fell from 17.0 percent to 15.0 percent. At the old margin, $2,400,000 of revenue would have produced $408,000 of contribution. Actual was $360,000. That $48,000 of erosion came from somewhere specific, and it usually traces to a handful of products: a launch that ran heavy ads all year, a SKU that moved into a higher fulfillment fee band after a packaging change, a bestseller whose refund rate doubled. The comparison report in ConnectBooks puts periods side by side by SKU and channel, which is the starting point for that breakdown.

If the SKU breakdown explains only $30,000 of the $48,000, the rest is in a cost line nobody has mapped to a product yet, and that is worth finding before the budget is set.

Asking the questions of reconciled data

Questions 1 through 6 are arithmetic once each channel's settlements are reconciled, with fees, refunds, and storage mapped to their own accounts and COGS on FIFO. ConnectBooks reconciles settlements for Amazon, Shopify, Walmart, eBay, TikTok Shop, and Temu and syncs them to QuickBooks or Xero.

Question 8 is where Crunch fits. Crunch is the AI analyst inside ConnectBooks, and it answers deep-analysis and profitability questions from the seller's reconciled data. Asked why Amazon contribution was flat on 14 percent growth, it finds what changed across sales, pricing, ads, fees, returns, and storage, compares quarter over quarter or year over year, names the products responsible, explains why, and recommends a next step. The cross-channel version of that analysis is covered in how AI compares channel margins.

Crunch has limits that matter in this review. It cannot answer question 7, because cannibalization between channels is not in the transaction data. It cannot decide how to treat shared overhead, which is a judgment call. It works only on what reached the books: ad spend paid on a card and never categorized to a channel will not be in its answer. And it does not change budgets or campaigns. The plan for 2027 is still yours to write, with these eight answers on the desk.

Take Control of Your E-Commerce Business with ConnectBooks

Running an e-commerce business comes with plenty of challenges, but ConnectBooks is here to make your life easier. With real-time insights, seamless integrations, and detailed tracking of your profitability and inventory, you can stay ahead of the game. Whether you’re selling on Amazon, Shopify, Walmart, TikTok or eBay, ConnectBooks helps you manage your finances with 100% accuracy and confidence, so you can focus on growing your business.

Ready to level up? Start making smarter, data-driven decisions every step of the way. Try ConnectBooks Free Today or Schedule a Demo