An ecommerce P&L template organizes revenue, costs, and profit into the tiers that match how an online store actually makes money: gross revenue down to net revenue, landed cost of goods, three levels of contribution margin, then operating expenses. This page is the template. Every line item, every formula, and a worked multi-channel example are laid out below.
There is nothing to download and no email gate. Copy the structure into a spreadsheet or hand it to your bookkeeper as a specification. Either way, the goal is the same: a profit and loss statement that tells you whether each order, each channel, and the business as a whole actually made money last month.
Why Generic P&L Templates Fail Ecommerce Businesses
Most free P&L templates were designed for a generic small business. They run revenue minus COGS to get gross profit, subtract one block of operating expenses, and land on net income. That structure is fine for a consulting firm, and actively misleading for a store that pays marketplace fees, 3PL invoices, and ad platforms before any payroll.
The problem is where those costs get buried. Shipping, pick and pack, payment processing, and referral fees usually end up scattered across operating expenses, so the template reports a flattering gross margin and hides the three numbers that run an ecommerce business: margin after COGS, margin after fulfillment and fees, and margin after ad spend. Those are the contribution margin tiers, and a template that does not surface them cannot tell you whether growth is making you richer or poorer.
We cover the full accounting foundation in our ecommerce accounting guide, including inventory methods, marketplace settlements, and sales tax. This post focuses on one artifact from that system: the monthly P&L itself.
The Full Ecommerce P&L Template at a Glance
Here is the complete structure. The shape matters more than any single line: revenue steps down to net, variable costs peel off in three tiers, and only then do fixed costs enter.
| Section | Line items | The question it answers |
|---|---|---|
| Revenue | Gross revenue, discounts, refunds and returns, net revenue | What did customers actually pay us? |
| COGS | Unit cost, inbound freight, duties and tariffs, inbound handling | What did the products cost, landed? |
| CM1 | Net revenue minus landed COGS | Is the product itself profitable? |
| Fulfillment and fees | Outbound shipping, pick and pack, storage, marketplace fees, payment processing | What does it cost to deliver an order? |
| CM2 | CM1 minus fulfillment and fees | Is each order profitable before marketing? |
| Advertising | Paid media by platform | What does demand cost? |
| CM3 | CM2 minus ad spend | Is each channel profitable after ads? |
| Operating expenses | Payroll, software, rent, insurance, professional services | What does it cost to run the company? |
| Net operating profit | CM3 minus operating expenses | Did the business make money? |
A P&L is formally an income statement, and this template still reconciles to that standard format. The difference is purely in how the middle is organized, so your accountant loses nothing and you gain three decision-grade margin lines.
Revenue: Gross to Net
Ecommerce revenue leaks before it ever reaches the bank. Discounts, refunds, and returns can take five to fifteen percent off the top, and a template that starts from net deposits hides that erosion. Start from gross and show the leaks as their own lines.
| Line item | Definition |
|---|---|
| Gross revenue | Total order value at list price, before any deductions |
| Less: discounts | Promo codes, sitewide sales, bundle markdowns |
| Less: refunds and returns | Refunded orders and returned units, recorded in the month refunded |
| Net revenue | What the business actually earned from customers |
Two boundary rules keep this section honest. Shipping income charged to customers folds into gross revenue in this format rather than getting its own line, and gross revenue excludes sales tax collected, which is a liability owed to the state, not revenue, as covered in our guide to Shopify taxes.
Tracking discounts as a separate line exposes promotion habits that quietly compound. A permanent 10 percent welcome code is really a permanent 10 percent price cut, and this layout makes that visible. The same goes for a creeping return rate, which shows up here months before it shows up in reviews.
COGS: Landed Cost, Not Invoice Cost
The most common ecommerce P&L mistake is recording COGS at the supplier's invoice price. Freight, duties, tariffs, and inbound handling routinely add 15 to 30 percent to what a unit really costs, and in a tariff era that share is growing. If those costs sit in operating expenses instead, every margin line above them is overstated.
| Line item | Definition |
|---|---|
| Product cost | Supplier invoice price for units sold this month |
| Inbound freight | Ocean, air, or ground freight to your warehouse |
| Duties and tariffs | Customs charges on imported goods |
| Inbound handling | Receiving, inspection, prep, and putaway fees |
| Landed COGS | The full cost of the units sold |
Landed COGS should move with units sold, not with purchase orders placed. That requires releasing inventory cost as units sell, which is standard accrual practice and the subject of its own guide to true landed cost per SKU for importing brands.
The Three Contribution Margin Tiers
This is the section generic templates skip entirely, and it is the reason this template exists. Contribution margin is what remains of net revenue after variable costs, and ecommerce has three distinct layers of variable cost worth separating.
CM1 is net revenue minus landed COGS. It answers whether the product itself carries enough margin to build a business on. Healthy DTC brands typically land between 60 and 80 percent here. If CM1 is thin, no amount of operational efficiency downstream will save the model.
CM2 is CM1 minus fulfillment and selling fees. This tier absorbs outbound shipping, pick and pack, 3PL storage, marketplace referral fees, FBA fees, and payment processing. These costs vary enormously by channel, which is why our ecommerce fee calculators exist. CM2 is the profit on an order before you spend anything to acquire the customer.
CM3 is CM2 minus advertising spend. Subtract Meta, Google, TikTok, and Amazon PPC by channel and you get the number that should govern every scaling decision. A positive CM3 means each incremental order adds cash. A negative CM3 means paid growth is a subscription to losses, no matter what ROAS the ad platform reports. CM3 is also the bridge into unit economics, covered in our guide to CAC, LTV, and payback period for ecommerce.
Operating Expenses Below the Line
Everything below CM3 is cost that does not scale with orders. Payroll, software subscriptions, rent, insurance, and professional services belong here, and nowhere higher. The discipline matters: when fixed costs sneak into the variable tiers, channel comparisons break, and when variable costs sink down here, the business looks scalable when it is not.
| Line item | Typical contents |
|---|---|
| Payroll and contractors | Salaries, wages, benefits, freelance ops and creative |
| Software | Storefront platform, apps, analytics, accounting tools |
| Facilities | Office or warehouse rent not billed per order, utilities |
| Professional services | Bookkeeping, legal, tax preparation |
| Insurance and other | General liability, product liability, bank fees |
CM3 minus operating expenses gives net operating profit. Interest and taxes follow for a complete income statement, but for monthly operating reviews, net operating profit is the line to watch.
A Worked Example: One Month, Two Channels
Here is the full template populated for a fictional brand selling on Shopify and Amazon. All numbers are illustrative, chosen to show realistic proportions rather than any real company. The blended column is what a generic P&L would show you. The channel columns are the point.
| Line item | Shopify | Amazon | Blended |
|---|---|---|---|
| Gross revenue | $82,000 | $54,000 | $136,000 |
| Less: discounts | ($6,600) | ($1,100) | ($7,700) |
| Less: refunds and returns | ($4,100) | ($3,800) | ($7,900) |
| Net revenue | $71,300 | $49,100 | $120,400 |
| Landed COGS | ($24,900) | ($17,200) | ($42,100) |
| CM1 | $46,400 (65%) | $31,900 (65%) | $78,300 (65%) |
| Outbound shipping | ($7,100) | $0 | ($7,100) |
| Pick, pack, and storage | ($3,600) | ($900) | ($4,500) |
| Marketplace and FBA fees | $0 | ($15,700) | ($15,700) |
| Payment processing | ($2,100) | $0 | ($2,100) |
| CM2 | $33,600 (47%) | $15,300 (31%) | $48,900 (41%) |
| Advertising | ($19,800) | ($16,100) | ($35,900) |
| CM3 | $13,800 (19%) | ($800) (-2%) | $13,000 (11%) |
| Operating expenses | ($11,900) | ||
| Net operating profit | $1,100 (0.9%) |
Read the blended column alone and the business looks acceptable: 65 percent CM1, 11 percent CM3, a small operating profit. Read the channel columns and the story changes. Amazon matches Shopify on product margin, but fees take 16 more points of revenue, and after PPC the channel loses money on every order.
Blended vs Channel-Level: Where Unprofitable Channels Hide
A blended P&L averages a strong channel against a weak one and reports the midpoint. In the example above, Shopify's 19 percent CM3 subsidizes Amazon's negative 2 percent, and the blended 11 percent looks healthy enough that nobody asks questions. The brand could raise profit by cutting Amazon ad spend, yet the blended view gives no hint of that lever.
The fix is structural, not analytical. Run the same template with one column per channel every month, allocating shared costs like landed COGS by units shipped per channel. Fulfillment, fees, and ad spend are naturally channel-specific, so the allocation work is smaller than most operators expect.
Channel-level is also just the first split. The same tiered logic extends down to SKU level, where individual products hide losses the same way channels do. Our guide to product profitability analysis walks through that next layer, and our ecommerce KPI dashboard guide covers the metrics that sit alongside the P&L in a monthly review.
Making the Template Part of Your Month
A template only earns its keep if it is populated with clean numbers on a fixed schedule. That means accrual-based revenue from storefront and marketplace reports rather than bank deposits, inventory releasing to COGS as units sell, and settlement reports broken into their fee components instead of booked as lump sums.
The tables above copy cleanly into a spreadsheet, and the formulas are simple subtraction down each column. The hard part is the bookkeeping feed behind them, which is exactly the work Futureproof's AI finance team automates: Vic keeps the books current and structured this way, so the CM tiers and channel splits are ready without a spreadsheet session. Shopify and Amazon integrations are now in beta. If you want your P&L built and maintained in this format, join the ecommerce waitlist.
Frequently Asked Questions
What is the difference between an ecommerce P&L and a standard income statement?
They reconcile to the same net income, so nothing is lost for tax or GAAP purposes. The difference is the middle: an ecommerce P&L separates variable costs into COGS, fulfillment and fees, and advertising, producing three contribution margin tiers, while a standard income statement shows one gross profit line and one operating expense block. The ecommerce format exists because those three tiers drive pricing, channel, and ad spend decisions.
Should shipping costs go in COGS or operating expenses?
Split them by direction. Inbound freight, the cost of getting inventory to your warehouse, belongs in landed COGS because it is part of what the product cost you. Outbound shipping to customers belongs in the fulfillment tier because it is a per-order selling cost. Putting either into operating expenses overstates the margin lines above and makes orders look more profitable than they are.
How often should an ecommerce business review its P&L in this format?
Monthly, in the first week after close, with the channel columns reviewed before the blended one. Ad spend and marketplace fees move fast enough that a quarterly review lets an unprofitable channel run for months unnoticed. Weekly flash views of CM3 by channel help during heavy promotional periods.
What is a good contribution margin for an ecommerce business?
Benchmarks vary by category and price point, but common healthy ranges are 60 to 80 percent at CM1, 35 to 50 percent at CM2, and 10 to 25 percent at CM3. A CM3 near zero means the business is buying revenue rather than earning profit. More important than any single benchmark is the trend: fees and ad costs tend to drift upward, and this template is designed to catch that drift line by line.
Can this template handle more than two sales channels?
Yes. The structure is one column per channel plus a blended total, so a brand selling on Shopify, Amazon, TikTok Shop, and wholesale runs four channel columns. Wholesale typically shows a lower CM1 but far lower fees and ad costs, which is exactly the kind of trade-off the tiered format makes visible.
