Text version of this lessonExpand
Build a DTC profit model sheet before scaling ads, offers, inventory, or channels. The goal is simple: separate order revenue, discount, COGS, fulfillment, payment fees, refund reserve, ad cost, contribution profit, and cash impact so the team can see whether an order actually makes money.
Start by fixing the mistake: ROAS and revenue are not a profit model
Many ecommerce teams mix three numbers during their first finance review: ROAS in the ad platform, order revenue in Shopify, and cash received in the bank account. All three matter, but none of them is the full profit model. ROAS does not know product cost, fulfillment, payment fees, or refunds. Order revenue does not know ad cost or cash timing. Cash received does not tell you which SKU or channel created the problem.
A DTC profit model answers an operating question, not an accounting-close question: after discount, product cost, fulfillment, payment fee, refund reserve, and ad cost, how much contribution profit remains? When did cash leave? When will payout arrive? Can this result support more budget, more discounting, more inventory, or a new channel?
Without this sheet, every team can be right inside its own tool and still make the wrong business decision. Ads may see ROAS above target. Merchandising may see product margin. Operations may see revenue growth. Finance may see cash pressure from replenishment, refunds, and ad billing. The profit model puts those readings on the same row.
Lesson output: DTC profit model sheet
A profit model is not better because it has more columns. The first version only needs to answer eight questions: is this actual order revenue, how much discount was used, is COGS reliable, did fulfillment and payment fees enter the model, is the refund reserve conservative, which order/SKU/channel owns the ad cost, how much post-ad contribution profit remains, and is cash tied up by inventory, ads, or refunds?
Each row needs a source, refresh timing, decision lead, and rule. Sources can include Shopify orders, cost per item, a SKU cost sheet, carrier bills, Shopify Payments payout, Google Ads, GA4, UTM, and support refund records. Field evidence status should be marked as verified, estimated, or missing. Estimates are allowed, but estimated fields should not support heavy scaling decisions.
| Field | What it means | Decision it supports |
|---|---|---|
| Order revenue | Actual Shopify order revenue, not ad-attributed revenue. | Confirms whether the money happened. |
| COGS | Cost of goods sold from cost per item or a SKU cost sheet. | Checks whether gross margin exists before ads. |
| Fulfillment and payment | Shipping, packaging, payment fee, dispute fee, and payout effects. | Turns gross margin into usable operating margin. |
| Refund reserve | A conservative cost for refunds, returns, and support credits. | Stops risky orders from looking like healthy growth. |
| Ad cost | CPA, CAC, or spend tied to the order, SKU, or channel. | Tests whether traffic can be scaled without losing contribution profit. |
Plain terms before the model
DTC means a brand sells directly to consumers through its own storefront. It describes the sales route, not guaranteed profit. The upside is more control over data and customer relationships. The downside is that traffic, fulfillment, support, and inventory pressure also come back to the store.
ROAS is ad revenue return, usually attributed revenue divided by ad spend. It can show revenue return, but it does not deduct product cost, refunds, shipping, payment fees, or support credits. ROAS can help diagnosis, but it cannot replace the profit model.
COGS is cost of goods sold. It is not the selling price and not ad cost. The common source is Shopify cost per item or a SKU cost sheet. Shopify profit reports are useful when cost per item was recorded at the time of sale, but cost per item is still static and does not automatically include real shipping, payment fees, or reshipments.
CPA / CAC is the cost to get one purchase or one new customer. This lesson uses it to test whether acquisition cost exceeds the room contribution profit can afford. Contribution profit is what remains after discount, COGS, fulfillment, payment fee, refund reserve, and ad cost. Cash rhythm asks when money leaves, when payout arrives, and whether inventory, ads, or refund reserve tie up cash.
Why the profit model comes before scaling
Scaling is not making a winning budget larger. Scaling is increasing the order type that can still make money, collect cash, and survive after-sales risk. If an order has only $1 of post-ad contribution profit, it may still be worth selling, but it is not a healthy scaling sample. If a SKU has good product margin but high refunds, high reshipment cost, or remote-zone shipping cost, it should not receive more spend just because it sells often.
The model turns arguments into variables. The ads team cannot stop at ROAS; it needs to show whether actual CPA is below affordable CPA. Merchandising cannot stop at gross margin; it needs to show whether cost per item is complete and whether purchasing or inventory pressure changed. Operations cannot stop at campaign revenue; it needs to show whether discount, shipping subsidy, refunds, and payment fees consumed contribution profit.
The sheet also prevents oversized actions too early. If many fields are estimated, the right move is field completion and small tests. If cash pressure already exists, the right move is slowing down, not using ad-attributed revenue to hide payout timing.
Worked example: one pet travel mat order
Use one generic order to make the model concrete. A pet travel mat sells for $79. The order used an $8 discount. COGS is $24, fulfillment is $9, payment fee is $2.50, refund reserve is $3, and the recent CPA for this order type is $22.
| Line | Calculation | Operating meaning |
|---|---|---|
| Pre-ad contribution room | 79 - 8 - 24 - 9 - 2.5 - 3 = 32.5 | Ads and channel actions can only consume this room. |
| Actual CPA | 22 | The recent cost to get this order type. |
| Post-ad contribution profit | 32.5 - 22 = 10.5 | This order still contributes, but the buffer is not large. |
| Decision | Do not scale blindly from ROAS. | Check refund reasons, shipping threshold, and cost fields before increasing spend. |
The important part is not the $10.50 by itself. The important part is the next questions it creates. Is refund reserve too low? Does the $9 fulfillment number include packaging and remote-zone surcharges? Did the payment fee come from the actual payout? Is CPA for first orders only or all orders? Until those questions are answered, ROAS should not be the only scaling signal.
Complete order profit breakdown: four orders where ROAS is not enough
One example is not enough. A useful DTC profit model calculator should run different order types through the same order profit breakdown calculator: high-discount orders, low-AOV orders, first-order ad orders, and repeat orders. The same ROAS can lead to very different actions once the cost structure changes.
| Order scenario | Breakdown path | Result | Action |
|---|---|---|---|
| Pet travel mat first order | 79 - 8 - 24 - 9 - 2.5 - 3 - 22 | Post-ad contribution profit is $10.50, below the $12 teaching buffer. | Do not scale yet. Check refund reasons, shipping threshold, and fulfillment cost. |
| Skincare bundle discount order | 96 - 18 - 31 - 7 - 3.2 - 6 - 28 | Post-ad contribution profit is only $2.80; deep discount consumed the room. | Pause deep-discount scaling. Test bundle price or gifts instead of more discount. |
| Desk cable organizer low-AOV order | 42 - 4 - 11 - 6 - 1.5 - 1.5 - 13 | Post-ad contribution profit is $5; low AOV is squeezed by fulfillment and CPA. | Do not force single-item ads. Build add-ons, bundle pages, or a higher free-shipping threshold. |
| Repeat consumable order | 58 - 0 - 18 - 5 - 1.8 - 2 - 6 | Post-ad contribution profit is $25.20 because repeat-touch cost is lower. | Protect the repeat path and modestly expand replenishment email or subscription reminders. |
These examples show the real purpose of the model. It is not trying to prove that ads are good or bad. It separates order types. A first order may need page repair, discount repair, or shipping-threshold repair. A low-AOV product may need bundles. A repeat order may be the healthier source of both cash and profit. In the weekly review, do not only ask what ROAS is. Ask which order type contributes profit and which order type only contributes revenue.
Contribution break-even line
The break-even line converts a good-looking ROAS into an affordable CPA. First calculate pre-ad contribution room. Then decide the minimum contribution profit you want to keep for fixed costs, cost swings, and cash pressure. Affordable CPA equals pre-ad contribution room minus that minimum kept profit.
If pre-ad contribution room is $32.50 and the team wants to keep at least $12, the affordable CPA is $20.50. A $22 CPA does not automatically mean the campaign is bad, but it means this order type should not be treated as a clean scale sample. The next action should be smaller: reduce discount, adjust shipping threshold, improve conversion quality, or inspect refund causes.
Minimum kept contribution profit is not a universal number. Low-ticket products with low returns and fast payout can keep a smaller buffer. High-ticket products with long return windows, long replenishment cycles, and early ad billing need a larger buffer. The beginner mistake is giving all pre-ad room to ads and then watching one refund, reshipment, or payout delay erase profit.
Evidence trail
Do not make a profit call from one metric in one system. Keep four evidence layers together: order facts, cost facts, channel facts, and action facts. Order facts come from Shopify orders, sales reports, refunds, and payment records. Cost facts come from COGS, fulfillment bills, payment fees, returns, and support credits. Channel facts explain why the order appeared. Action facts record whether the team will scale, pause, reprice, change inventory, adjust the offer, or rewrite the page.
A minimal sheet only needs eight columns: date, order or SKU, revenue, main cost, contribution profit, source channel, variance reason, and next action. The point is not perfect accounting. The point is a stable operating lens for the next review.
Official tools prove only their part of the story. Shopify profit reports can help review cost per item, net sales, cost, and gross profit, but they do not automatically calculate real fulfillment cost or post-ad contribution profit. Shopify Payments payout can verify fees and payout timing. Google Ads conversion value can support value-based optimization, but the team must label whether the value is revenue, gross margin, or a contribution-profit proxy. GA4 purchase and refund events can explain behavior, but they still need to be reconciled with orders, costs, payments, and support records.
Practice: build the first model in 30 minutes
- Pull the latest 20 orders, including high-volume, high-discount, high-refund, and new-channel orders.
- Choose six priority SKUs and mark cost per item, fulfillment cost, refund reserve, and ad cost as verified, estimated, or missing.
- Calculate pre-ad contribution room before reading ROAS.
- Write the minimum kept contribution profit for each SKU and explain why that buffer is enough.
- Calculate affordable CPA / CAC and compare it with recent 7-day or 14-day actual CPA.
- Write this-week action: continue, modestly scale, reduce discount, change shipping threshold, pause SKU, complete cost fields, or observe only.
The completion standard is not a pretty sheet. The standard is that every action maps back to one profit variable. If the team cannot say whether revenue, discount, COGS, fulfillment, payment fee, refund, ad cost, or cash rhythm is driving the result, do not scale yet.
Sampling rhythm
In week one, sample 20 orders and 6 priority SKUs: five high-volume SKU orders, five high-discount orders, five high-refund orders, five new-channel orders, and six priority SKUs marked as verified, estimated, or missing. In week two, classify orders into healthy contribution profit, high revenue but thin profit, high cash tie-up, and refund or support risk. In week three, set fixed guardrails for minimum contribution profit, refund warning line, and cash slowdown rule.
At month end, write those guardrails back into budget, offer, inventory, and channel decisions. Ads should know what can scale. CRO should know whether a page lift has commercial value. Email should know whether a discount can continue. Operations should know whether inventory and cash can support growth.
How to write three common conclusions
Continue: cost fields are mostly verified, actual CPA is below affordable CPA, post-ad contribution profit is above the floor, and refunds plus cash timing show no clear pressure. The action is modest continuation with a refund-window and payout check in the next review.
Complete fields before deciding: revenue and ROAS look good, but COGS, fulfillment, payment fee, or refund reserve is still estimated. The action is field completion and narrow testing, not heavy scaling.
Pause scaling and repair: actual CPA stays above affordable CPA, post-ad contribution profit is near zero or negative, or cash is squeezed by replenishment, ad billing, and refund reserve at the same time. The action is lower budget, discount repair, shipping-threshold review, page-promise repair, low-contribution SKU pause, or a deeper true order cost review in the next lesson.
Official verification boundaries
Shopify profit reports are useful only when product cost data such as cost per item is available, and gross margin is affected by discounts and refunds. Shopify Payments payout fee pages help the team see fees and cash timing. Google Ads conversion value can support value-based optimization, but the value must be clearly labeled as revenue, gross margin, or a contribution-profit proxy. GA4 ecommerce events can explain purchase and refund behavior; item information in refund events helps show item-level refund impact.
Public references: Shopify profit reports, Shopify Payments payout fees, Google Ads conversion values, and GA4 ecommerce measurement.
DTC profit model copyable lesson notes
After this lesson, leave one clean version: current pressure, first evidence, sampled orders and SKUs, revenue and cost sources, contribution profit guardrail, cash signal, this-week action, blocked move, review window, next route, and counter-signal. Useful copyable notes do not say "profit is weak." They say which SKU or order type is weak, why, what changes this week, what should not happen yet, what metric validates it, and what signal would prove the decision wrong.
The next lesson breaks this model into COGS, shipping, payment fees, and refund costs. In other words, this lesson tells you whether profit room exists. The next lesson shows which true order costs are consuming that room.