Why Weekly (Not Monthly)
If you're only looking at your P&L monthly, you're finding out about margin problems 30 days too late. Ecommerce moves fast. A supplier price increase, a spike in returns, or a bad ad week can eat your entire month's profit before you notice.
Weekly P&L reviews take 15-20 minutes once the dashboard is set up. That's it. And they let you catch the problems that monthly reviews miss entirely: a shipping rate change that went unnoticed, a product with a 40% return rate, an ad campaign burning cash with no conversions.
Most profitable ecommerce brands we've talked to review their numbers weekly. The ones struggling usually check once a month (or, honestly, once a quarter).
The Line Items You Need
An ecommerce P&L is different from a traditional business P&L. You need ecommerce-specific line items that standard accounting templates miss. Here's the structure that actually works.
| Section | Line Items | Where to Get the Data |
|---|---|---|
| Revenue | Gross sales, discounts, returns/refunds, shipping income | Shopify Analytics, payment processor |
| Cost of Goods Sold | Product cost, packaging, inbound freight | Supplier invoices, 3PL reports |
| Fulfillment | Outbound shipping, 3PL fees, warehouse costs | Shipping provider dashboard, 3PL invoices |
| Transaction Fees | Payment processing, Shopify fees, marketplace fees | Shopify billing, Stripe/PayPal dashboard |
| Marketing | Meta ads, Google ads, TikTok ads, influencer spend | Ad platform dashboards, invoices |
| Operating Expenses | Shopify plan, apps, software, salaries, rent | Bank statements, subscriptions |
Two things most templates get wrong: they lump shipping income into revenue (correct) but don't separate shipping costs from COGS (wrong). And they put ad spend into one bucket instead of breaking it out by channel.
Track shipping income and shipping expense as separate line items. Don't net them. You need to see both numbers independently to know if your shipping strategy is subsidizing orders or eating margin.
Step 1: Map Your Revenue Accurately
Gross revenue is not your revenue. It's the starting point.
Net Revenue = Gross Sales - Discounts - Returns - Refunds + Shipping Income
If you run a lot of promotions, the gap between gross and net revenue can be 15-25%. I've seen stores report $100K months that are actually $78K after discounts and returns. That's a different business. Know your real number.
Side note: if your return rate is above 10%, that's a product quality or product description problem, not a "cost of doing business" problem. Fix the root cause before building dashboards around the symptom.
Step 2: Get Your COGS Right
COGS in ecommerce is everything it costs to get a product ready to ship. Not just the wholesale cost of the product. The full list:
- Product cost (what you pay your supplier per unit)
- Inbound shipping (freight from manufacturer to your warehouse)
- Packaging materials (boxes, tape, inserts, tissue paper)
- Import duties and tariffs (if sourcing internationally)
- Quality control / inspection fees
I think the single biggest margin mistake in ecommerce is underestimating COGS. Founders calculate their margin using only the product cost and ignore everything else. A product that costs $8 from your supplier might cost $12 landed when you add freight, packaging, and duties. That's the number that goes in your P&L.
Step 3: Break Out Ad Spend by Channel
"Marketing: $15,000" tells you nothing useful. You need to see exactly where every dollar went and what it returned.
| Ad Channel | Weekly Spend | Revenue Attributed | ROAS |
|---|---|---|---|
| Meta (Facebook/Instagram) | $2,500 | $8,750 | 3.5x |
| Google (Search + Shopping) | $1,800 | $7,200 | 4.0x |
| TikTok | $800 | $1,600 | 2.0x |
| Influencers | $500 | $1,500 | 3.0x |
| Total Marketing | $5,600 | $19,050 | 3.4x |
This view lets you make decisions. TikTok at 2.0x ROAS might be below your breakeven. You'd never catch that in a lumped "marketing" line item.
Update these numbers weekly. Ad performance can shift 30-50% week to week based on creative fatigue, audience saturation, and platform algorithm changes.
Want to see your actual profit margins right now?
Plug in your revenue, COGS, ad spend, and fees to calculate your real net profit and margin percentage.
Open Profit Margin Calculator →Step 4: Calculate the Three Margins That Matter
Your P&L dashboard should surface three margin numbers. Each tells you something different.
- Gross Margin: (Net Revenue - COGS) / Net Revenue. This tells you how much room you have after product costs. Target: 60-70% for DTC brands.
- Contribution Margin: (Net Revenue - COGS - Shipping - Processing Fees - Packaging) / Net Revenue. This is what each order actually contributes after all variable costs. Target: 40-55%.
- Net Margin: (Net Revenue - All Costs) / Net Revenue. The bottom line. After ad spend, salaries, rent, software. Target: 10-20% for healthy ecommerce brands.
Gross margin looks great on pitch decks. Contribution margin tells the truth. Net margin pays your bills.
Step 5: Choose Your Tool
You have three paths, depending on your budget and technical comfort.
Option A: Google Sheets (Free)
Build a spreadsheet with weekly columns. Export data from Shopify, your ad platforms, and your shipping provider every Monday morning. Manual, but it works for stores under $50K/month. Takes about 30 minutes per week once the template is set up.
The downside: manual data entry means human error. And you'll spend more time building and maintaining the spreadsheet than actually analyzing the numbers.
Option B: Shopify Profit Apps ($30-$100/month)
TrueProfit, Lifetimely, and BeProfit all pull data automatically from Shopify, your ad accounts, and your payment processor. They calculate P&L in real-time and give you daily/weekly/monthly views.
TrueProfit syncs ad spend from Meta, Google, TikTok, and others automatically and tracks COGS at the product level. Lifetimely adds customer lifetime value analysis. BeProfit connects Shopify, Amazon, and WooCommerce if you're multi-channel.
Honestly, for most Shopify stores doing $10K+/month, a $30-$50/month profit tracking app will save you hours and catch things a spreadsheet won't. It's one of the few app categories where the ROI is obvious.
Option C: Accounting Software + Custom Dashboard ($50-$200/month)
For larger operations, connect Shopify to Xero or QuickBooks via A2X or Synder. These tools map your Shopify transactions to proper accounting categories and generate real P&L reports that your accountant can work with.
Then layer a dashboard tool like Databox or Coupler.io on top to visualize the data weekly. This is the most accurate setup, but it requires accounting knowledge to configure correctly.
The Weekly Review Routine
Once your dashboard is live, here's the 15-minute weekly routine that keeps you on track.
Every Monday morning:
- Check net revenue vs. last week and same week last year
- Check gross margin. If it dropped more than 2 points, investigate (returns spike? COGS increase?)
- Check ad spend vs. revenue by channel. Kill anything under breakeven ROAS for 2+ weeks
- Check contribution margin. This is your true per-order health metric
- Check net profit. Are you actually making money, or just moving it around?
Write down one action item from each review. "Pause TikTok campaign #3." "Renegotiate shipping rates." "Investigate 12% return rate on SKU-447." That's it. One action per week compounds fast.
Common P&L Mistakes to Avoid
Netting shipping. Recording shipping income minus shipping cost as one number hides whether you're making or losing money on shipping. Keep them separate.
Ignoring payment processing fees. Shopify Payments charges 2.9% + $0.30 per transaction on the Basic plan. On $100K/month in sales, that's roughly $3,200/month. It belongs on your P&L.
Lumping all marketing together. "We spent $20K on marketing" doesn't help you decide anything. Break it down by channel and track ROAS per channel weekly.
Forgetting app costs. The average Shopify merchant spends $120/month on apps. That adds up to $1,440/year. It's an operating expense that belongs on your P&L.
Using cash basis instead of accrual. If you received $50K in revenue this week but $15K of it is from orders that haven't shipped (and might get cancelled), your real revenue is closer to $35K. Accrual-based P&L matching revenue to when the product ships gives you a more accurate picture.
Frequently Asked Questions
What should an ecommerce P&L dashboard include?
Gross revenue, returns/refunds, shipping income, COGS, fulfillment costs, ad spend by channel, platform fees, and operating expenses. The output should show gross profit, contribution margin, and net profit on weekly and monthly timeframes.
How often should I review my ecommerce P&L?
Weekly. Monthly is too slow for ecommerce. Ad spend, returns, and shipping costs can shift week to week. A weekly review catches margin problems before they burn through a full month's profit.
What tools can I use to build an ecommerce P&L dashboard?
For Shopify, TrueProfit, Lifetimely, and BeProfit are the most popular automated options ($30-$100/month). Google Sheets works for smaller stores. For larger operations, connect Shopify to Xero or QuickBooks via A2X and layer a dashboard tool on top.
Should I track ad spend in my P&L or separately?
Both. Your P&L needs total ad spend as a line item to show true net profit. But you also need a separate ad performance view that breaks down ROAS and CPA by campaign. The P&L tells you if ads are worth it overall. The ad dashboard tells you which campaigns to keep.
What's the difference between gross margin and contribution margin in ecommerce?
Gross margin is revenue minus COGS. Contribution margin subtracts all variable costs: COGS, shipping, payment processing, and packaging. Contribution margin is more useful because it shows what each order actually contributes toward covering your fixed costs.