Ecommerce Dashboard: How I Build One That Matches Your Books

Does your ecommerce dashboard say you just had a record month, while your bank balance tells a very different story?

You’re not imagining the gap. Most dashboards are built to show what the store sold and what the ads reported. Very few are built to show what you kept.

Revenue sits at the top in big green numbers. Margin, cash, and the cost of the customers behind that revenue sit somewhere else, or nowhere at all.

Hey, I’m Jarrod Souza. I’ve spent 15+ years as a CFO, including at Michael Hyatt and Company, and building finance dashboards for 7 and 8 figure ecommerce brands is part of what our team does every month. I’ve seen plenty of beautiful dashboards that told a founder the wrong thing.

In this guide I’ll show you what a good dashboard does, why its revenue never matches your books, the five layers of metrics I put on every founder’s screen, the targets and review rhythm that make them useful, and how to build one at your stage.

What an Ecommerce Dashboard Should Actually Do

An ecommerce dashboard is one screen that pulls your store, ad, and finance data together so you can see the health of the business and decide what to do next.

That last part is the test. Every number on the screen should change a decision about spend, pricing, inventory, or hiring. If nobody would act differently when a number moves, it belongs in a report.

Here’s how I separate the three tools founders tend to blur together:

• ●Dashboard: a short list of live or recent metrics with targets, reviewed on a fixed rhythm.
• ●Report: a deeper, one-off look at a question, such as why returns spiked on one product.
• ●Profit and loss statement: the accrual record of revenue, costs, and profit for a closed month, prepared from your books.

Your team may want its own view. Marketing watches spend and acquisition daily, operations watches stock and fulfillment, and you watch the layer that ties it all to margin and cash.

Those views should all draw from the same definitions. Two teams quoting two different revenue numbers in one meeting is a dashboard problem, and a common one.

Know Why Your Dashboard Revenue Never Matches Your Books

Most founders notice the gap the first time they compare the dashboard to the monthly financials. The two are measuring different things, and once you know how, the gap stops being scary.

Shopify alone gives you three revenue numbers. According to Shopify’s finance report definitions, gross sales is selling price times quantity, net sales takes out discounts and returns, and total sales adds taxes, shipping charges, and fees back on top.

Total sales is the figure on Shopify Home, so it’s the one most founders see first. That figure includes sales tax you collected for the state and shipping you charged the customer, so it reads higher than the revenue you’ll see on your income statement.

Returns add a timing problem. Shopify records a return on the date it was processed, so a wave of January refunds from December orders lands in January’s net sales.

Accrual books handle returns differently. Under the revenue recognition standard, FASB Topic 606, a sale with a right of return is recorded at the amount you expect to keep, with a refund liability for the returns you expect. The same standard leaves out amounts collected on behalf of third parties, such as some sales taxes.

Here’s what that looks like in an illustrative month with $500,000 of gross sales, $40,000 of discounts, $15,000 of refunds processed on last month’s orders, $20,000 of shipping charged, $30,000 of sales tax collected, and a 5% expected return rate on this month’s orders:

Same month, a $58,000 spread between the top and bottom number. None of the three numbers is wrong. They answer different questions, and your dashboard should label which one it shows.

How your books treat returns, shipping income, and collected sales tax is an accounting policy decision. I’m sharing general education here, so confirm the right treatment for your business with your CPA.

Build Your Dashboard in Five Layers

The layers run in the same order money moves through your business: sales come in, margin is what’s left, acquisition is what it cost, retention is what it’s worth over time, and cash is what’s in the bank.

For definitions of each number in more depth, I keep a longer guide to ecommerce financial metrics. Below is the short list I’d put on screen.

1Sales and Revenue

Start with the numbers that tell you whether demand is moving.

• ●Net sales: gross sales minus discounts and returns. Use this as your headline revenue line instead of total sales.
• ●Orders and average order value (AOV): AOV is net sales divided by orders, and it tells you whether bundles and free-shipping thresholds are working.
• ●Conversion rate: orders divided by sessions. A sudden drop often points to a site, stock, or checkout issue before it shows up in revenue.
• ●New vs returning customer revenue: the split shows how much of your growth you’re paying to acquire.
• ●Discount rate: discounts as a share of gross sales. Watch it climb during promotions.

2Unit Economics and Contribution Margin

Contribution margin (CM) is what’s left from a sale after every cost that moves with that sale. I treat it as the most important layer on the screen.

Take an illustrative $80 order:

• ●Cost of goods sold (COGS): $20 for the product itself, landed.
• ●Shipping and fulfillment: $9 for the pick, pack, and postage.
• ●Payment processing: $2.50, roughly 3% of the order.
• ●Packaging: $1.50.
• ●Returns allowance: $3 set aside for expected returns.

That leaves $44 of contribution margin before marketing, or 55% of the order. Put a blended customer acquisition cost (CAC) of $35 against a first order and you’re down to $9 of contribution after the ad dollars.

Show three versions on the dashboard: CM per order, CM after ad spend, and CM percentage by product. You can run your own numbers through our contribution margin calculator before you wire them into a live view.

3Customer Acquisition

Acquisition metrics tell you what each new customer costs and whether the spend is paying for itself.

• ●New-customer CAC: total marketing spend divided by new customers in the same period.
• ●Marketing efficiency ratio (MER): total revenue divided by total ad spend, across every channel.
• ●Break-even return on ad spend (ROAS): one divided by your contribution margin percentage. At 55% CM, you need about $1.82 of revenue for every ad dollar just to break even on a first order.
• ●Platform-reported ROAS: keep it, but label it as the platform’s own view.

In my YouTube video on what a fractional CFO actually does for a Shopify store, I put the core of this layer simply: “We set CAC targets. We set customer lifetime value ratios that you need to be hitting.” A dashboard without those two targets is a scoreboard with no par.

4Retention and Lifetime Value

Retention tells you what a customer is worth after the first order, which decides how much you can afford to pay for one.

• ●Repeat purchase rate: the share of customers who order again within a set window, such as 90 or 180 days.
• ●Lifetime value (LTV) by cohort: contribution margin per customer, grouped by the month they first bought. Cohorts show you whether newer customers are worth more or less than older ones.
• ●CAC payback period: how many months of contribution it takes to earn back the cost of acquiring a customer.
• ●LTV to CAC ratio: use contribution-margin LTV in the numerator. A ratio built on revenue LTV flatters every channel.

5Cash and Inventory

Cash is the layer most dashboards leave out, and it’s the one that ends businesses. In a LinkedIn post I wrote: “Most brands don’t die because of sales. They die because they couldn’t keep cash flowing.”

• ●Cash on hand and the 13-week cash forecast: a rolling weekly view of cash in and cash out, so you can spot the tight week a month ahead.
• ●Weeks of inventory on hand: units in stock divided by average weekly units sold, by SKU.
• ●Inventory turnover: I aim for roughly 4 to 8 turns a year, so nothing sits for much more than 90 days. That’s my working range, and your category may differ.
• ●Cash conversion cycle: days from paying your supplier to collecting cash from the customer.
• ●Open purchase orders and debt payments: the big cash commitments that are already scheduled.

If cash is already the pressure point, my guide to managing ecommerce cash flow walks through the forecast in detail.

Set a Target Next to Every Metric

A number with no target is trivia. A number with a target is a decision waiting to happen.

These are the working ranges I use for 7 and 8 figure ecommerce brands. They’re my own heuristics from client work, so treat them as a starting point to adjust for your category and stage.

On the marketing line, I’d also add one rule to the dashboard: scale spend only when CAC payback is under 6 months.

Net margin targets shift with size. In my experience a brand under $1M in revenue does well at 5% to 10% net, a $1M to $10M brand can hold 10% to 15% when it’s managed well, and $10M-plus brands can reach 15% to 20%.

Color each tile green, amber, or red against its target. Founders read color faster than numbers, and a screen of green with one red tile tells you exactly where to look.

Match Each Metric to a Review Cadence

A dashboard checked whenever someone remembers is a dashboard nobody trusts. Give every metric a rhythm and an owner.

The weekly cash review is the one I’d never skip. Cash problems show up week to week, long before they show up on a monthly statement.

The monthly review depends on clean books. I push every brand we work with to close the books by the 10th of the following month, so the dashboard can be reconciled to accrual numbers while the month is still fresh enough to act on.

Use Your Own Store Data as the Source of Truth for Ad Spend

Every ad platform reports on its own performance, and each one counts the conversions it can claim inside its own rules. Add up what Meta, Google, and your email tool each say they drove, and the total can come to more than the orders you actually shipped.

The rules themselves vary. In Meta’s standard attribution settings, a click-through conversion is one that happens within 1 or 7 days of a link click, and a view-through conversion is one within 1 day of someone seeing the ad.

Google Analytics 4 adds its own wrinkle. Per Google’s help page on GA4 attribution settings, changing the reporting attribution model applies to historical data as well as future data, so if someone on your team switches models, last quarter’s channel numbers change with it.

So I anchor the acquisition layer on numbers no platform can grade for itself:

• ●MER: total revenue from your store against total ad spend from your invoices.
• ●New-customer CAC: total marketing spend against new customers counted in your store.
• ●CM after ad spend: contribution margin from your books against the same ad spend.

Platform ROAS still has a job. Use it to compare campaigns inside one platform, and use your store-based numbers to decide total budget.

Choose How to Build Your Ecommerce Dashboard

The right build depends on your revenue, your data sources, and how much you trust your books. Here’s a rough way to compare the options, keeping in mind that the number of data sources matters as much as revenue:

If you’re comparing software for the middle options, my roundup of ecommerce analytics tools covers the main choices by job.

Whatever you choose, build in this order. Lock the metric definitions first, connect the data sources second, set targets third, and design the layout last. Most dashboard projects stall because they start with the layout.

The last option is the one our team builds. Through our ecommerce CFO services, clients get accrual financials by the 10th alongside a custom dashboard that, depending on the package, covers COGS, contribution margin, CAC, LTV, payback, shipping costs, and overhead trends.

Avoid the Five Dashboard Mistakes I See Most

Most bad dashboards fail in one of five ways. Check yours against this list:

1. 1Too many metrics: forty tiles means nobody knows which three matter. Keep the main screen to two or three numbers per layer and push the rest into reports.
2. 2Revenue with no margin: a dashboard that leads with revenue and never shows contribution margin rewards discounting and expensive growth.
3. 3Platform ROAS as the truth: budget decisions made on self-reported platform numbers tend to overspend on the channels best at claiming credit.
4. 4Bad cost data underneath: if COGS is missing freight and duties, or the books are on a cash basis, every margin tile on the screen is off.
5. 5No owner and no action: if a tile turns red and nobody is responsible for it, the dashboard is decoration.

Frequently Asked Questions (FAQs)

Conclusion

A good ecommerce dashboard shows you margin and cash next to revenue, puts a target beside every number, and ties back to your books every month. Build it in five layers, review it on a set rhythm, and trust your own store data over any ad platform’s opinion of itself.

Here’s a quick win for this week. Open your dashboard next to last month’s income statement and write down the revenue number from each. If you can’t explain the difference line by line, start by fixing the definitions.

If you’d like a second set of eyes on your dashboard and the numbers feeding it, I’m happy to walk through it with you.