The DTC Financial Model Template

Module: Ecommerce Empire Builder Instructor: Kevin Gundersen Topic: Monthly P&L, Dashboard, and Key Ratios

Run Your P&L Monthly. No Exceptions.

If you're looking at your financials quarterly, you're flying blind 10 out of 12 months. If you're looking annually, you're already dead and just don't know it yet. Every DTC operator should run a full P&L every single month, reviewed in the first week of the following month. This is not negotiable.

Here's the exact structure I use. It's not fancy. It doesn't require an accounting degree. It requires discipline.

The Monthly P&L Structure

Revenue Block

Gross Revenue                    $142,000
  - Discounts & Coupons           ($14,200)    [10% of gross -- watch this number]
  - Refunds & Returns              ($5,680)    [4% of gross -- healthy range]
  - Chargebacks                      ($710)    [0.5% -- keep under 1%]
= Net Revenue                    $121,410

Gross revenue is vanity. Net revenue is reality. Track the discount rate obsessively. If it's creeping above 12-15%, you're training customers to wait for sales and eroding your brand. Refund rate above 6% means you have a product quality or expectation-setting problem. Fix it.

COGS Block

Product Cost (landed)             $31,570     [26% of net -- good for supplements]
Packaging & Inserts                $3,640     [3% of net]
Merchant Processing Fees           $3,520     [2.9% -- standard Shopify Payments]
= Total COGS                     $38,730
= Gross Profit                   $82,680
  Gross Margin:                    68.1%      [target: 60-70% for supplements]

Gross margin is your foundation. If this number is bad, nothing downstream can save you. Track it monthly because COGS drift is real. Your manufacturer raises prices 5%, your packaging supplier adds a surcharge, Shopify adjusts processing fees. Each one is small, but they compound. A 68% gross margin can become 61% in a year if you're not watching.

Operating Expenses Block

MARKETING
  Meta Ads                        $28,500     [23.5% of net revenue]
  Google Ads                       $8,200     [6.8%]
  TikTok Ads                      $3,100     [2.6%]
  Influencer/Affiliate             $2,400     [2.0%]
  Email/SMS Platform                 $890     [0.7%]
= Total Marketing                $43,090     [35.5% of net revenue]

FULFILLMENT
  Shipping (outbound)              $9,710     [8% of net]
  Pick & Pack (3PL fees)           $4,860     [4% of net]
  Returns Processing                 $850     [0.7%]
= Total Fulfillment              $15,420     [12.7% of net revenue]

TEAM
  Salaries & Contractors          $14,570     [12% of net]
  Payroll Taxes & Benefits         $1,820     [1.5%]
= Total Team                     $16,390     [13.5% of net revenue]

SOFTWARE & TOOLS
  Shopify + Apps                   $1,200
  Analytics/BI                       $450
  Design/Creative Tools              $380
  Project Management                 $120
  Other SaaS                         $650
= Total Software                  $2,800     [2.3% of net revenue]

OTHER
  Insurance                          $400
  Legal/Accounting                   $750
  Miscellaneous                      $350
= Total Other                     $1,500     [1.2% of net revenue]

The Bottom Line

= Total Operating Expenses        $79,200
= Net Operating Income             $3,480
  Net Operating Margin:             2.9%

This is the truth. Not your ROAS. Not your revenue graph. This number, right here, tells you if your business is actually making money. In this example, $121K in net revenue produces $3,480 in actual profit. That's thin. One bad month on Meta and you're negative.

Unit Economics Section

Below the P&L, calculate these monthly:

Total Orders:                      2,180
Contribution Per Order:            $18.19    [(Gross Profit - Fulfillment - Marketing) / Orders]
New Customer Acquisition Cost:     $34.22    [Total Acquisition Spend / New Customers Acquired]
Returning Customer Revenue %:      38%       [target: 35-50% -- your path to profitability]
CAC Payback Period:                1.4 orders [how many orders to recoup nCAC]
LTV:CAC Ratio:                     3.2:1     [healthy is 3:1+; below 2:1 is a problem]

The contribution per order tells you the real profit per transaction after variable costs. The CAC payback period tells you how long it takes to recoup what you spent to get the customer. If payback is more than 2 orders, your first-order economics are weak and you're depending heavily on retention. That's a fragile position.

Cash Position Section

Starting Cash (Month Begin):     $47,200
  + Cash In (collected revenue):  $118,300   [note: not same as net revenue due to timing]
  - Cash Out (all expenses):     ($112,800)  [includes inventory reorder of $22,000]
= Ending Cash (Month End):       $52,700
  Net Cash Change:                +$5,500
  Cash Runway:                    3.8 months [at current burn rate excluding inventory]

Notice that cash in ($118K) doesn't match net revenue ($121K) because of payment processing timing, holds, and delayed payouts. And cash out ($113K) includes an inventory reorder that doesn't show up in the P&L as an expense (it's an asset until sold). This is why P&L and cash flow are different reports and you need both.

The Weekly Dashboard: 5 Numbers

You don't need to run the full P&L weekly. But every Monday morning, check these five numbers:

1. Net Revenue (trailing 7 days): Is it trending up, down, or flat vs. the prior week and same week last year?
2. Contribution Margin % (trailing 7 days): Calculate it weekly. If it drops below 20%, investigate immediately. Which channel got more expensive? Did COGS change? Did you run a deeper discount?
3. nCAC (trailing 7 days): What did it cost to acquire a new customer this week? Trending up is a warning sign. Trending up for 3 consecutive weeks means something structural changed.
4. Email/SMS Revenue as % of Total: This is your retention health metric. Below 25% means you're too dependent on paid acquisition. Above 35% means your retention engine is strong. Target: 30%+.
5. Cash Runway (months): Updated weekly based on current cash and trailing 30-day net burn. If this number is shrinking, you need to act before it becomes a crisis.

Key Ratio Benchmarks

Keep these posted where you can see them:

If your software costs exceed 3% of revenue, audit every subscription. I guarantee you're paying for tools nobody uses. If marketing exceeds 35%, your creative is fatiguing or your audiences are tapped. If team cost exceeds 18%, you've hired ahead of revenue.

The model doesn't lie. Build it. Update it monthly. Let the numbers tell you what to do next.