Description
Full Walkthrough
Enter daily store totals, ad spend and expenses. Get a monthly P&L with contribution margin, MER, blended CAC, break-even ROAS and net profit.
Who it’s for
Direct-to-consumer store owners on Shopify, WooCommerce and similar platforms who run paid ads and want one monthly P&L across channels. It works from store totals, with no per-SKU inventory or reorder tracking.
What’s inside
- Dashboard: Net sales, orders, AOV, ad spend, MER, contribution margin, net profit, blended CAC, repeat %, gross margin, break-even ROAS, channel table, charts
- Monthly P&L: 12 months from net sales to net profit, with MER, CAC, AOV, repeat %, break-even ROAS
- Daily Sales: Daily store totals with net sales, processing fees, gross profit and AOV
- Ad Spend: Daily spend and platform-reported revenue per channel, with ROAS
- Expenses: Fixed and overhead costs
- Settings: Fees, targets, channels, categories
What you get
- The .xlsx workbook with sample data that’s easy to clear
- Setup Guide PDF, with every tab explained
- A video walkthrough
FAQ
Does it work in Google Sheets?
Yes. Upload it to Google Drive, open it with Google Sheets, then choose File > Save as Google Sheets.
Which Excel version do I need?
Excel 2019 or newer, Microsoft 365 or Excel for Mac.
Is this a subscription?
No. You pay once and keep the file. No macros, no add-ons.
A management view, not accounting or tax advice. Net profit is before income tax. Shopify is a trademark of its owner and this template is not affiliated with it.
This is a digital product. No physical item will be shipped.
Also on Gumroad: Ecommerce Store P&L: Contribution Margin, MER & CAC Dashboard on Gumroad
Build your own store: Hostinger WordPress hosting (affiliate link: I may earn a commission at no extra cost to you)
