CFO Dashboard: The One-Page View I Build for Ecommerce Brands
In the Federal Reserve’s 2024 Small Business Credit Survey, 51% of small employer firms named uneven cash flows as a financial challenge. Even more, 56%, said paying operating expenses was a challenge.
Most of those owners had plenty of data. What they were missing was one page that told them whether they could afford next month.
I see the same gap in ecommerce. Founders have a Shopify dashboard, an ads dashboard, an email dashboard, and a bank app.
None of them answers the questions you actually lose sleep over, like whether you can place this inventory order, push ad spend, or hire.
Hey, I’m Jarrod Souza. I’ve been a CFO for 15+ years, including at Michael Hyatt and Company, and before that I was the operator on a golf ecommerce brand that grew from about $4M to $40M on disciplined customer lifetime value math. Today our clients get accrual financials by the 10th of each month along with a KPI dashboard, so I’ve built a lot of these pages and thrown out a lot of bad ones.
In this guide I’ll show you what a CFO dashboard is for, the four numbers I put on the top row, the supporting metrics underneath, how to read budget vs actual, the triggers that turn numbers into decisions, and how to run one weekly meeting from it.
TL;DR
What is a CFO dashboard, and what should be on it? A CFO dashboard is one page that tells an ecommerce founder whether to spend, order inventory, or hire this week. I build the top row around four numbers: weeks of cash to the forecast low point, contribution margin after marketing vs plan, CAC payback, and net sales vs forecast. Underneath sit about a dozen supporting metrics, a budget vs actual view, and a trigger for every number, all fed by closed accrual books and reviewed in one weekly meeting.
What a CFO Dashboard Actually Does
A CFO dashboard turns your financials into the handful of decisions you make every week.
Each number on it earns its place by changing a decision. If a number moves and nobody does anything differently, it belongs on someone else’s report.
CFO Dashboard vs Ecommerce Dashboard
Your store and marketing dashboards run the channels. They show sessions, conversion rate, ROAS (return on ad spend, or revenue divided by ad spend) by campaign, and email revenue.
A CFO dashboard sits one level up, taking the results of all those channels and asking what they did to margin, cash, and the plan. Your marketing lead needs the channel view every day; you need the owner’s view every week.
CFO Dashboard vs Monthly Financial Report
A monthly financial report explains what already happened. You get it after the books close, and it’s the official record.
The dashboard is forward-facing. Closed months set the baseline, and this week’s numbers sit on top, so you can change course in week two instead of finding out at month-end.
Answer Four Questions on the Top Row
The top row holds four numbers, one for each question a founder has to answer every week.
When a founder asks me what to put on a CFO dashboard, I start here. If you build nothing else, build these four.
1Do We Have Enough Cash?
The number: weeks of cash until your forecast low point.
Your bank balance today is only half the story. The real question is the lowest point your cash hits over the next 13 weeks, after inventory deposits, payroll, ad spend, and loan payments go out. Show how many weeks away that low point is and how far above your cash floor it sits.
2Are We Making Money on What We Sell?
The number: contribution margin after marketing, month to date vs plan.
Contribution margin is what each order leaves after the costs that move with it: product cost, shipping and fulfillment, payment fees, returns, and discounts. Take marketing out as well and you get contribution margin after marketing, the money left to cover overhead and profit.
I put this on the top row instead of revenue. Revenue can climb while this number falls, and you’ll see an example of exactly that further down.
3Is Growth Paying Back Fast Enough?
The number: CAC payback in months.
CAC (customer acquisition cost) is marketing spend divided by new customers. Payback is how many months of contribution margin from a new customer it takes to earn that CAC back.
My guardrail for 7 and 8 figure brands is to scale spend only while payback stays under 6 months. That’s my operating rule, and a brand with a strong subscription or repeat-purchase base may justify a longer window.
4Are We on Plan?
The number: net sales vs forecast, plus the updated month-end forecast.
Net sales are sales after discounts and returns. Comparing them to the forecast every week tells you early whether the month is drifting, and the updated month-end number tells you how far.
Track the Supporting Metrics Underneath
Below the top row sit the supporting metrics that explain why a top-row number moved.
I keep this to about a dozen. For the full definitions and formulas, our guide to ecommerce financial metrics goes deeper on each one.
| Metric | What it tells you | Review |
|---|---|---|
| Average order value (AOV) | Net sales divided by orders; whether baskets are growing or being discounted down | Weekly |
| Discount rate | Discounts as a share of gross sales; how much margin promotions are giving away | Weekly |
| Return rate | Returned sales as a share of sales; a cost that rarely shows up in channel reports | Monthly |
| Gross margin on landed COGS | Net sales minus landed product cost; whether pricing and supplier costs hold | Monthly |
| Contribution margin per order | What one order leaves after variable costs | Weekly |
| New-customer CAC | Marketing spend divided by new customers | Weekly |
| MER (marketing efficiency ratio) | Total net sales divided by total marketing spend, across every channel | Weekly |
| LTV:CAC by cohort | Contribution-margin lifetime value of a monthly cohort against what it cost to acquire | Monthly |
| Inventory weeks of cover | Weeks of sales your stock covers at the current pace | Weekly |
| Cash conversion cycle | Days from paying for inventory to collecting cash from the sale | Monthly |
| Overhead as a share of net sales | Fixed costs like salaries, software, and rent against sales | Monthly |
| Net margin | Operating profit as a share of net sales | Monthly |
Two of these deserve a note. For contribution margin per order, run your top SKU through our contribution margin calculator before you trust any blended number.
For lifetime value (LTV), use margin instead of revenue. As I put it on LinkedIn: “Subtract COGS, shipping, and merchant fees before you call it lifetime value.”
Lay Out the Page in Three Rows
A good CFO dashboard reads top to bottom in the order you make decisions: the answer first, then the trend, then the detail.
Here’s the layout I use as a starting example. The values are illustrative.
| Row | What goes there | Example |
|---|---|---|
| Top row | The four decision numbers, each colored against its trigger | 9 weeks to cash low point; contribution margin after marketing 27% vs 31% plan; CAC payback 4.5 months; net sales 104% of forecast |
| Trend row | The same four numbers over the last 13 weeks, plus the 13-week cash forecast line | A cash line dipping in week 9 when the next inventory balance is due |
| Detail row | The supporting metrics, split by channel and top SKUs | MER by channel, discount rate by promotion, weeks of cover by SKU |
Color only what needs attention. Green, amber, and red against the trigger lines is enough, and it lets you read the page in under a minute.
Keep the detail row collapsed or on a second tab. The founder’s view should fit on one screen.
Put Budget vs Actual on the Same Page
A CFO dashboard compares every number to a plan, because a number with nothing to compare against can’t tell you to act.
The budget vs actual view lines up your accrual P and L (profit and loss statement) against the budget for the month. Here’s an illustrative month for a brand budgeting $400,000 in net sales.
| Line | Budget | Actual | Difference |
|---|---|---|---|
| Net sales | $400,000 | $480,000 | +$80,000 |
| Landed product cost (COGS) | $100,000 | $120,000 | +$20,000 |
| Shipping and fulfillment | $44,000 | $62,400 | +$18,400 |
| Payment and platform fees | $12,000 | $14,400 | +$2,400 |
| Marketing | $120,000 | $168,000 | +$48,000 |
| Contribution margin after marketing | $124,000 | $115,200 | -$8,800 |
| Overhead | $70,000 | $72,000 | +$2,000 |
| Operating profit | $54,000 | $43,200 | -$10,800 |
On a revenue-only dashboard, that month is a win. Sales beat budget by 20%.
The CFO view tells a different story. Marketing ran at 35% of net sales against a 30% budget, shipping and fulfillment crept from 11% to 13%, and operating profit came in $10,800 under plan on $80,000 more sales.
Contribution margin after marketing fell from a budgeted 31% of net sales to 24%. Caught in week two, that’s a conversation about CAC and fulfillment rates. Caught at the close, it’s a month you can’t get back.
Set a Trigger for Every Number
A trigger is the line that, once crossed, means somebody acts.
Without triggers, a dashboard becomes something people glance at and close.
Here are the guardrails I use with 7 and 8 figure ecommerce brands. They’re my operating heuristics from years of doing this. They aren’t accounting rules, so adjust them to your margins and stage.
| Metric | My guardrail | What we do when it trips |
|---|---|---|
| Cash low point | Falls below the cash floor you set in advance | Move or split the next PO, slow scaling spend, line up financing before you need it |
| CAC payback | Over 6 months | Stop adding spend; fix offer, AOV, or channel mix first |
| Contribution margin after marketing | Under plan two weeks in a row | Find the leak line by line: discounts, fulfillment, returns, CAC |
| COGS | Above 25% of net sales | Re-quote suppliers, check price-break quantities, review pricing |
| Marketing spend | Above 40% of net sales | Pull back to channels that meet the payback rule |
| Shipping and fulfillment | Above 12% of net sales | Review 3PL rates, packaging, and the free-shipping threshold |
| Payment and platform fees | Above 4% of net sales | Audit processor rates and app subscriptions |
| Inventory | Any SKU over 90 days on hand | Pause reorders, plan a bundle or markdown |
| Net margin | Below 8% | Review overhead and pricing before next quarter’s plan |
| Overhead | Over 30% of net sales | Freeze new fixed costs until it comes down |
On inventory, I aim for 4 to 8 turns a year so nothing sits longer than about 90 days. On net margin, I like to see 10% or better, and below 8% a brand is vulnerable to one bad quarter.
Keep Cash at the Top of the Page
Cash gets the first spot on the top row because running out of it is what ends companies. Strong sales won’t save a brand that can’t pay for its next order.
A profitable month can still leave you short. Inventory is paid for weeks or months before it sells, and even card sales take time to land. Shopify Payments payouts in the US typically arrive 3 to 5 business days after a customer’s payment is captured.
The cash section of the dashboard comes from a 13-week rolling forecast. Each week shows:
- ●Cash in: payouts you expect from each sales channel, by the week they land.
- ●Cash out: inventory deposits and balances, payroll, ad spend, 3PL bills, software, and loan or financing repayments.
- ●Ending balance: the running total, with the low point and your cash floor marked.
If you don’t have that forecast yet, our guide to managing ecommerce cash flow walks through how to build one.
Feed the Dashboard From Closed Accrual Books
The dashboard is only as honest as the books underneath it.
“Your financial statements are your business report card,” and a dashboard built on messy books grades you wrong. Three things have to be right.
- ●Accrual accounting: Under the accrual method, the IRS describes income as reported when earned and expenses when incurred, whatever day the cash moves. Cash-basis books swing with the timing of inventory payments, so monthly margins jump around for no real reason. Talk to your CPA about which method your business must use for tax purposes.
- ●Landed COGS: Product cost should include inbound freight, duties, and packaging. Leave those out and every margin on the page reads too high.
- ●A fast close: I want the books closed by the 10th of each month. A close that lands on the 25th turns your dashboard into a history lesson.
One more trap. Shopify’s built-in profit reports calculate gross profit as net sales minus product cost. Shipping, payment fees, returns handling, and marketing aren’t in that number, so it can’t stand in for contribution margin.
If your bookkeeping isn’t accrual-based or closing on time, start with ecommerce bookkeeping done monthly before you build anything on top.
Run One Weekly Meeting From the Dashboard
A dashboard changes decisions only when the people who make them review it together on a schedule.
When people ask me where to start with cash, my answer is short: “The number one fix? Weekly cash reviews. Non-negotiable.” The dashboard is the agenda for that meeting.
| Rhythm | What we review | Who attends |
|---|---|---|
| Weekly, 30 minutes | Top row, inventory cover, CAC, MER, discount rate, any tripped triggers | Founder, marketing lead, finance |
| Monthly, after the close | Budget vs actual, gross margin, return rate, cohorts, overhead, net margin | Founder, finance, department heads |
| Quarterly | Re-forecast, reset targets and triggers, SKU and channel review | Founder, finance, leadership team |
Keep the weekly agenda tight. Look at the top row, then any number past its trigger, then decide who does what by when.
The habit matters more than the tool. On a podcast a while back, I named the first of the biggest mistakes I see: “One of the biggest ones is founders are not looking at their financials on a regular basis.” A standing weekly meeting fixes that.
Build Your CFO Dashboard in Five Steps
You’ll get to a useful first version faster if you build it in this order.
1Start From the Decisions You Make
List the calls you make most often: ad budget changes, purchase orders, hires, price changes, promotions. For each one, write down the number that should drive it. Those become your top row and triggers.
2Close Accrual Books by the 10th
Get your monthly close on an accrual basis and on a deadline. Every number on the page depends on it, and a late close makes the whole dashboard late.
3Write the Budget and Rolling Forecast
Build a 12-month budget by month and a 13-week cash forecast. The budget gives the monthly targets; the forecast gives the cash low point.
4Set Targets and Triggers
Put a target next to every number and a trigger line where action starts. Use the guardrails above as a starting point, then tune them to your margins.
5Assign Owners and a Meeting
Give every metric one owner who explains it when it moves. Then put the weekly review on the calendar and protect it.
Decide Who Builds and Maintains It
How you build the dashboard matters less than who keeps it accurate every week.
- ●A spreadsheet: Fine below about $1M in sales. One person updates it weekly from Shopify, the ad accounts, and the bank, and the books feed the monthly view.
- ●Connectors plus a BI tool: Past a few million in sales, manual updates break. Data connectors pull from your store, ad platforms, and accounting file into a BI (business intelligence) tool. Our roundup of ecommerce analytics tools compares the common options.
- ●A fractional CFO: Someone owns the definitions, the forecast, the triggers, and the weekly read. A custom finance dashboard is one of the core pieces of our ecommerce CFO services, built on the same accrual books we close each month.
The software is the easy part. The hard part is keeping the definitions consistent, the books on time, and the meeting on the calendar.
Show Lenders, Investors, and Buyers the Same Numbers
The numbers you run the business on are the numbers outsiders will ask for.
A lender wants to see cash, margins, and how you’ve tracked against plan. A buyer in due diligence wants months of accrual history, clean margin trends, and an operating profit they can trust.
If your CFO dashboard has run on closed accrual books for a year or two, most of that is already done. For the exit-minded brands we work with, our FAQ puts it plainly: “The goal is simple: make you look bulletproof to buyers.” Talk to your transaction advisor, CPA, and attorney about the specifics of any financing or sale.
Avoid These CFO Dashboard Mistakes
Most dashboards I inherit fail for one of these reasons.
- ●Revenue on the top row: Sales go up while contribution margin and cash go down, and nobody notices until the close.
- ●Store metrics with no cash: Sessions and ROAS fill the screen, and the cash low point is nowhere on it.
- ●Cash-basis numbers: Inventory payments make margins jump month to month.
- ●No budget or forecast: Nothing to compare against, so nothing looks wrong.
- ●No triggers: Everyone sees the number move and waits for someone else to act.
- ●No owner: Numbers that belong to everyone get explained by no one.
- ●Too many numbers: Forty charts hide the four that matter.
Frequently Asked Questions (FAQs)
Conclusion
A CFO dashboard earns its place when it changes what you do this week. Four numbers on top, a dozen underneath, a budget to compare against, a trigger on each line, and one meeting to act on it.
Here’s a quick win. Before Friday, write down your cash low point over the next 13 weeks, last month’s contribution margin after marketing, your CAC payback in months, and month-to-date net sales vs plan. If any of the four takes more than an hour to find, that’s the first thing to fix.
If you’d like a second set of eyes on what you find, book a time and we’ll walk through your numbers together.
