It's easy to watch revenue climb on Shopify's dashboard and feel like the business is winning. But revenue is a vanity metric until you subtract what it actually cost you to generate it. A store doing $100K in monthly revenue with 60% product cost and heavy ad spend can be less profitable than one doing $40K with lean costs.
The Basic Profit Formula
At its simplest: Net Profit = Revenue − Product Cost − Ad Spend − Other Expenses. The hard part isn't the formula, it's getting reliable numbers for each input without stitching together three different tools by hand every week.
Revenue: Easier Than It Looks, With One Catch
Shopify order totals are accurate, but only if you account for refunds and cancellations. A report that only counts gross order value will overstate your real revenue — always work from net revenue after refunds when calculating profit.
Product Cost: Know Your COGS
Cost of goods sold (COGS) is the most commonly underestimated input. If you haven't set a cost-per-item in Shopify for every SKU, your profit numbers will be wrong no matter how good your reporting tool is. This is worth an afternoon of cleanup — it pays for itself the first time you catch a product that looks like a bestseller but is barely breaking even.
Ad Spend: Connect It, Don't Estimate It
If you run paid ads, connect that platform directly to your analytics tool instead of manually re-entering spend numbers each week. Manual entry is the single most common source of stale or wrong profit numbers in e-commerce reporting — someone forgets to update the spreadsheet for two weeks and suddenly your "profit" number is fiction.
"We didn't realize one of our 'hero' products had a 78% cost ratio until we actually built out COGS by SKU. It was profitable in name only."
— Founder, Home Goods Shopify Store
Watch Net Profit Alongside Revenue, Not Instead of It
The goal isn't to ignore revenue — it's a real signal of demand and growth. The goal is to never look at revenue without also glancing at net profit right next to it, calculated from the same real order data, updated on the same schedule. A dashboard that shows both side by side, with 30-day period-over-period comparisons, makes it obvious when a promotion drove revenue up but profit down.
Building This Without a Spreadsheet
SnapDash's Net Profit KPI card is calculated from real Shopify order data minus ad spend and product cost, with the label reflecting exactly which sources are feeding the number — so you always know what you're looking at, not just what a formula assumed.