Shopify Profitability Report Checklist

A recurring review checklist for marketing, finance, and operations teams to identify profit leaks and growth opportunities before they compound.

Quick Answer

• If you're a growth team that currently reviews ROAS, gross margin, and fulfillment costs in separate silos → implement the structured 30-minute weekly review below, because reviewing these metrics in isolation is the most common reason net margin erodes without anyone noticing.
• If you're scaling a product with high revenue but suspect thin margins after marketing → check your product-level Contribution Margin After Marketing (CMAM) first, since a "hero" product can look profitable on paper while losing money once marketing cost is included.
• If your blended CAC is above 40% of AOV → pause prospecting on the highest-CAC channel immediately rather than waiting for a month-end review.
• If you're a brand holding significant inventory → include inventory carrying costs in your monthly profitability audit; industry estimates put these at 20-30% of inventory value annually, which is easy to leave out of a per-order margin calculation.

Why Most Shopify Growth Teams Miss Profitability Signals

Direct answer: A consistent pattern shows up across growth teams: they optimize for top-line revenue while profitability erodes silently. The problem usually isn't a lack of data—it's the absence of a structured, recurring review process that connects marketing spend, operational costs, and unit economics.

Marketing teams often review ROAS weekly, finance reviews gross margin monthly, and operations reviews fulfillment costs quarterly—each in isolation. When no one looks at the intersection of these metrics together, a brand's net profit margin can be several points lower than it should be, with no single team positioned to catch it.

This checklist is designed to close that gap. It works regardless of your reporting stack—whether you're pulling data from your Shopify admin, ad platform dashboards, a BI tool, or a spreadsheet.

The Core Metrics Every Review Should Track

Direct answer: Before the checklist itself, establish the metric baseline. These five numbers form the foundation of any profitability review:

These benchmarks are broadly consistent with figures reported in Shopify's 2023 State of Commerce report across categories like apparel, supplements, and home goods. Your specific targets may vary by category, but the red flag thresholds apply broadly.

How to Run the Weekly Profitability Review (30 Minutes)

Direct answer: This is the actionable core. Schedule this every Monday morning before campaign decisions are made.

Step 1: Pull a Channel-Level Profit & Loss View (5 minutes)

Pull together a channel-level P&L from your ad platforms, Shopify admin, and fulfillment provider that includes: - Revenue attributed by last-click and multi-touch models - Ad spend by platform (Meta, Google, TikTok, Pinterest) - COGS by product variant - Fulfillment costs by order

Use the multi-touch attribution view for marketing decisions and last-click for cash reconciliation. A meaningful discrepancy between the two often points to an attribution gap worth investigating.

Step 2: Calculate Blended CAC and Compare to Target (5 minutes)

Take total marketing spend across all channels for the trailing 7 days. Divide by new customer count from your Shopify customer report. Compare to your target CAC-to-AOV ratio.

If blended CAC exceeds 40% of AOV, pause prospecting campaigns on the highest-CAC channel before the next meeting rather than waiting for a month-end review to catch it.

Step 3: Review Contribution Margin After Marketing by Product (5 minutes)

Pull a product-level profitability view. Sort by CMAM ascending. Identify the bottom 10% of SKUs.

Common pattern: a "hero" product with high revenue but razor-thin margins after marketing, because it's the primary acquisition driver. A product can be profitable on paper (revenue minus COGS) but unprofitable once marketing spend is included—and that gap is easy to miss if marketing and margin are reviewed separately.

Step 4: Check Fulfillment Cost Trends (5 minutes)

Compare current average shipping cost per order against the trailing 4-week average. If it's up meaningfully, investigate: - Carrier rate changes - Dimensional weight shifts from new packaging - Geographic distribution changes

Set an alert threshold for fulfillment cost increases so this doesn't require remembering to check manually every week.

Step 5: Review Customer Payback Period for New Cohorts (5 minutes)

Segment new customers acquired in the last 30 days by acquisition channel. Calculate payback period using first 30 days of gross contribution (revenue - COGS - fulfillment) per customer.

If one channel's payback period is meaningfully longer than another's, the decision usually isn't to kill that channel—it's to adjust creative strategy or audience targeting first.

Step 6: Identify One Actionable Change (5 minutes)

Document one specific action from the review. Examples: - "Pause TikTok prospecting for SKU-1024 due to an unsustainable CAC-to-AOV ratio" - "Increase free shipping threshold to offset a fulfillment cost increase" - "Shift budget from an underperforming channel toward one with a shorter payback period"

Without this step, the review becomes data theater. No meeting should end without a documented decision.

Monthly Deep-Dive: The Full Profitability Audit

The weekly review catches surface-level issues. The monthly audit finds structural problems.

Unit Economics Decomposition

Break down net profit per order into its components: - Average order value - Items per order - COGS per item - Fulfillment cost per order - Marketing cost per order - Payment processing fees (often overlooked—typically around 2.9% + $0.30 per transaction, which can be a meaningful share of AOV for low-ticket items)

Payment processing fees are one of the most commonly overlooked profit leaks precisely because they're deducted automatically and rarely reviewed line by line.

Cohort Profitability Analysis

Run a 90-day cohort analysis showing cumulative gross contribution per customer by acquisition month. Compare against CAC paid in the acquisition month.

Healthy cohorts show cumulative contribution exceeding CAC by day 60-90. If a cohort from three months ago still hasn't paid back, that acquisition channel needs structural changes—not just budget shifts.

Inventory Carrying Cost Impact

Include inventory carrying costs in your profitability model. Standard industry estimates from the Council of Supply Chain Management Professionals put carrying costs at 20-30% of inventory value annually. For a brand holding a substantial amount of inventory, that can be a significant hidden cost that never shows up in a simple revenue-minus-COGS view.

A common approximation is: (Average Inventory Value × 25%) / (Number of Orders), which spreads the estimated annual carrying cost across orders—useful context when setting prices or making purchasing decisions.

Frequently Asked Questions

How often should growth teams run this checklist?

Weekly for the six-step review, monthly for the full audit. The weekly review takes 30 minutes and catches profit leaks before they compound. The monthly audit takes 2-3 hours and identifies structural issues. Skipping the weekly review in favor of monthly-only checks is a common way for fulfillment cost creep to go unnoticed for weeks.

What if I don't have automated fulfillment cost data?

You can approximate fulfillment costs using Shopify's built-in shipping reports combined with carrier invoices. Prioritize getting a reliable fulfillment cost feed set up—it's often the highest-impact data source missing from profitability reviews.

Should we include salaries and overhead in profitability calculations?

Not for the weekly review. Include only variable costs that change with order volume: COGS, fulfillment, marketing, and payment processing. Fixed costs like salaries and rent belong in a separate P&L review. Mixing them obscures the unit economics signals you need for rapid campaign decisions.

How do we handle attribution when customers convert across multiple channels?

Use a multi-touch attribution view for marketing efficiency decisions and last-click for cash reconciliation. The gap between the two is sometimes called an "attribution tax"—the degree to which bottom-of-funnel channels get over-credited for conversions that involved multiple touchpoints.

What's the most common profitability mistake growth teams make?

Optimizing for ROAS instead of contribution margin after marketing. A campaign with a higher ROAS on a low-margin product can be less profitable in absolute terms than a lower-ROAS campaign on a high-margin product. Teams that make CMAM their primary metric tend to make better product and channel decisions than teams anchored only to ROAS.

Can this checklist work for brands using platforms other than Shopify?

Yes. The framework and metric definitions are platform-agnostic; only the specific reports you pull from will differ. For non-Shopify brands, replicate the metric definitions and review cadence using whatever reporting tools your platform provides.

Sources

1. Shopify, State of Commerce Report (2023)
2. Council of Supply Chain Management Professionals, Annual State of Logistics Report (2023)
3. Harvard Business Review, The Economics of Ecommerce Profitability (2022)
4. Federal Reserve Bank of St. Louis, Retail Trade Data Series (2023)
5. Gartner, Marketing Budget and Efficiency Benchmarks (2023)

The Takeaway

Direct answer: Profitability isn't a quarterly review exercise—it's a weekly operational discipline. Brands that maintain healthy net margins aren't doing anything mysterious. They run a structured review process that connects marketing, operations, and finance data at the unit level. This checklist gives you that process. Run it weekly, act on the signals, and optimize for cash in the bank rather than vanity metrics.