What Belongs on a Shopify CFO Dashboard
A finance dashboard for a store needs six things: net sales, contribution margin rate, profit after advertising, projected net profit against fixed cost run rate, cash position with inventory commitments, and the acquisition cost to margin gap. Everything else belongs in a report someone opens deliberately.
Written by Deepa Swaroop · Co-founder, NetNet
Updated September 6, 2026 · 4 min read
Most finance dashboards fail in one of two directions. Either they show a dozen metrics nobody reads, or they show revenue and net profit and leave everything decision-relevant off the screen.
The test for including anything is narrow: is there a decision that changes when this number moves, on a cadence someone actually reviews?
The six
Net sales, month to date, against the same point last month. The size of the period. Net sales, not total sales — no tax, no shipping revenue.
Contribution margin rate. The fastest-moving number in the business and the one that leads everything else. Shown as a rate against last month’s rate, because the currency total rises with volume and reassures when it should not.
Profit after advertising. Contribution margin minus all acquisition spend including agency fees. It reconciles to real money and cannot be inflated by attribution windows.
Projected net profit against fixed cost run rate. Where the month is heading, not where it has been. This is what turns a dashboard from a record into a warning.
Cash position with commitments. Bank balance, plus outstanding payouts, minus committed inventory orders. Profit and cash diverge constantly, and inventory commitments are the largest claim that appears in no profit statement.
The gap between contribution margin per order and acquisition cost. One number, in currency. Positive means growth funds itself. It is the single most decision-dense figure available.
That is the screen. Six lines.
What to leave off
ROAS. It cannot be interpreted without contribution margin, and the dashboard already shows the profit figure it was standing in for.
Sessions and conversion rate. Real operating metrics, and not finance ones. They belong on a marketing view.
Anything by product, channel or region. These are investigations, not monitors. Put them in reports that get opened when a headline number moves.
Year-to-date totals. They only ever go up, so they carry no signal.
Real-time order counts. Engaging and not decisional. Several of the underlying costs settle over days regardless, so precision here is precision about provisional numbers.
Why projection beats reporting
The distinction that makes a finance dashboard useful rather than historical.
A report tells you last month made $5,360. Accurate, and every decision that produced it has already been taken.
A projection says this month is heading for $2,008, and the second line shows contribution margin has slipped two points. There are still thirteen days to find out which product or promotion caused it and respond.
Projection needs three inputs: month-to-date actuals, a fixed cost run rate, and a simple assumption that the rest of the month resembles the part observed. That assumption breaks around promotions and seasonal peaks, which is worth flagging on the screen rather than solving with sophistication.
The provisional-data problem
Every mid-month figure is partially costed. Carrier adjustments arrive weeks later, gateway fees settle in payouts, refunds land whenever customers ask, and chargebacks can appear months on.
This means month-to-date contribution margin is systematically optimistic, and a dashboard presenting it at the same confidence as a closed month invites false certainty.
The fix costs one line: show how much of the period is fully costed. “78% of orders fully costed” alongside the margin figure. It prevents the most common failure of live dashboards, which is not inaccuracy but misplaced confidence.
Everything must link to detail
The follow-up question after any number moves is always the same: which product, which channel, which region.
A dashboard that cannot answer it sends someone to a spreadsheet, and after the third time that happens the dashboard stops being consulted at all.
Contribution margin rate should open into margin by product and by channel. Profit after advertising should open into channel-level spend and margin. Cash should open into outstanding payouts and committed orders. The screen stays at six numbers; the detail sits one click away.
Why cash deserves its own line
Of the six, the cash line is the one most often left off and the one most likely to matter in an emergency.
Profit and cash diverge for reasons that have nothing to do with performance. Inventory consumes money the moment it is bought and only becomes a cost when sold. Payouts arrive days behind orders, so a growing month holds more receivables than a flat one. Tax and loan principal come out of profit already earned.
The consequence is that a store can post its best profit month and have less money than it started with, most often because it bought stock for a peak season.
Showing bank balance alone is not enough — it looks reassuring right up until a committed inventory order lands. The line needs three components: cash on hand, outstanding payouts due in, and committed but unpaid inventory orders. That third figure appears in no profit statement and is usually the largest single claim on the account.
A store that reviews profit weekly and cash never is the one that gets surprised, and it is surprised at exactly the moment it can least afford to be.
Who it is actually for
At most stores this size there is no CFO, and the dashboard is for the founder, an operations lead and possibly an accountant.
That argues for plain language over finance terminology, and for showing the decision alongside the number where it is not obvious. “Contribution margin 42%, down from 44%” is a fact. “Contribution margin 42%, down from 44% — acquisition ceiling now $43 per order” is the same fact with the decision attached, and it is the version that gets acted on.
The screen, mid-month
A finance view seventeen days into a month, showing where the period is heading rather than where it has been.
- Net sales, month to date
- $67,400
- Projected net profit
- $2,008
- Share kept
- 3.0%
| Line | Relative size | Amount |
|---|---|---|
| Net sales, month to date | $67,400 | |
| Contribution margin 42% — against 44% last month | $28,308 | |
| Advertising, month to date | $15,100 | |
| Profit after advertising | $13,208 | |
| Fixed costs, monthly run rate | $11,200 | |
| Projected net profit On current trajectory | $2,008 |
Mid-month, the period is heading for $2,008 rather than the $5,360 it made last month, and the reason is visible on the second line — contribution margin has slipped two points. That is a dashboard doing its job: it says what is happening and where to look, while there is still half a month left to respond.
Where the numbers come from
Every figure above traces to a specific field in a specific system. These are the ones that matter, and where each one goes wrong.
| Figure | Source | Where it breaks |
|---|---|---|
| Month-to-date figures | Orders and costs for the period so far | Recent orders are partially costed, so month-to-date margin is systematically optimistic. |
| Fixed cost run rate | Recurring payments, normalised to a monthly figure | Annual invoices must be spread or the run rate jumps in whichever month they fall. |
| Cash and commitments | Bank balance, outstanding payouts, and committed inventory orders | Committed but unpaid stock is the largest claim on cash and appears in no profit statement. |
What this does not tell you
- A dashboard shows what changed, not why. Every number on it should link to detail, because the follow-up question is always which product, channel or region moved.
- Mid-month projections assume the rest of the period resembles the part observed, which breaks around promotions, launches and seasonal peaks.
Frequently asked questions
What is the most important number on a finance dashboard?
Contribution margin rate. It moves fastest, it leads every other figure, and it is the input to the acquisition ceiling. Net profit matters more but arrives too late to act on within the period.
Should a CFO dashboard show cash or profit?
Both, because they diverge routinely. Profit says whether the operation works; cash says whether you can pay for the next inventory order. A profitable store can be unable to fund its own growth, and only the cash line shows it.
How many metrics should be on one screen?
Six or so. Beyond that nobody reads all of them and the screen becomes decorative. Anything that does not have a decision attached belongs in a report opened deliberately rather than on a permanent display.
Should the dashboard update in real time?
Daily is enough for finance. Real-time updating encourages reacting to noise, and several inputs — carrier costs, fees, refunds — settle over days regardless, so an hourly figure is precise about numbers that are still provisional.
Keep reading — Decisions & benchmarks
The DTC profit metrics that matter
Which numbers earn a permanent place.
Building a Shopify P&L
The full statement underneath.