I ran ads at 2.8 ROAS in Aug 2026 thinking we were winning until margin showed 18 percent and CPA ate 38 percent. I built a one-page Monday board for cash, margin and CPA. This guide shows that 7-metric review to spot leaks early.
Short answer: A one-page KPI dashboard tracks cash collected, sales, gross margin, on-time fulfillment, ROAS, CPA and repeat rate every Monday. Compute margin with the free product performance analyzer and ROAS plus CPA with the free ad performance analyzer, show week-over-week change, assign one owner per red metric and act on one fix at a time.
Business performance note: Educational content only, not financial or professional advice. ROAS, revenue and KPI examples are illustrations to teach calculation and workflow. Confirm decisions with your own records or a qualified professional. See Disclaimer.
Which Seven KPIs Matter
Seven numbers run most small businesses without overload. Cash collected shows survival. Sales booked shows demand. Gross margin shows pricing power. On-time fulfillment shows operations. ROAS shows ad efficiency. CPA shows order cost. Repeat rate shows loyalty. Together they answer can we pay, can we sell, can we keep, can we deliver, can we acquire profitably and will they return. More than ten metrics causes scrolling without action. Fewer than five hides leaks.
Definitions stay simple. Cash collected equals receipt totals for the week. Sales equals invoiced plus cash sales. Gross margin equals revenue minus cost of goods sold divided by revenue. On-time equals on-time jobs or shipments divided by total. ROAS equals revenue divided by ad spend. CPA equals spend divided by orders. Repeat rate equals repeat buyers divided by total buyers. Compute margin with the product performance analyzer and ROAS plus CPA with the ad performance analyzer.
Learn inputs in ROAS guide, fulfillment in job docs, billing in billing stack and overview in operations guide.
How to Build the Dashboard in 3 Steps
This section covers: Step 2 — Review One Page; Step 3 — Act on One Metric.
Step 1 — Enter Weekly Inputs
Add sales, product costs, returns, orders shipped versus late, ad spend, clicks, conversions, revenue and bank balance into analyzers and a one-page sheet. Use same Monday to Sunday window for all sources and freeze inputs before review.
Step 2 — Review One Page
Show each KPI with this week, last week, change and threshold color. Top row cash plus bank, middle sales plus margin plus fulfillment, bottom ROAS plus CPA plus repeat. One owner per metric and one line for action.
Step 3 — Act on One Metric
Pick the reddest metric, assign fix with date, re-measure next Monday and archive snapshots by date. Fixing one at a time compounds faster than chasing five.
Formulas and Thresholds
Thresholds turn numbers into decisions. Cash collected must cover next two payrolls plus rent. Margin stable or rising is healthy, falling two weeks triggers price or mix review. On-time above 95 percent keeps reviews, below 90 percent needs capacity. ROAS above 4.0 or above margin hurdle allows scale, 2.0 to 4.0 needs fix, below 2.0 pauses. CPA under 30 percent of order value preserves cash, above 35 percent burns despite sales. Repeat rising quarter over quarter signals fit.
| KPI | Formula | Healthy sign | Source |
|---|---|---|---|
| Cash collected | Receipts total by week | Covers next payroll | Receipts |
| Gross margin | Revenue minus COGS over revenue | Stable or rising | Product analyzer |
| On-time fulfillment | On-time divided by total | Above 95 percent | Job plus sales orders |
| ROAS | Revenue divided by spend | Above 4.0 or hurdle | Ad analyzer |
| CPA | Spend divided by orders | Under 30 percent of order | Ad analyzer |
| Repeat rate | Repeat buyers over buyers | Rising | Orders plus receipts |
| KPI this week | Value | Signal | Action owner |
|---|---|---|---|
| Cash collected | 182000 | Green | None, fund stock |
| Margin | 42 percent, down 3 | Yellow | Review discount SKU, Priya |
| On-time | 91 percent | Yellow | Add Saturday shift, Omar |
| ROAS | 2.8 | Yellow | Pause set C, shift 20 percent |
| CPA | 38 percent of order | Red | Pause low margin SKU ads |
| Repeat | 28 percent up 2 | Green | Ask reviews |
Weekly Review Rhythm
Thirty minutes every Monday beats three hours monthly. Agenda: cash versus target two minutes, sales plus margin five minutes, fulfillment plus backlog five minutes, ads ROAS plus CPA eight minutes, repeat plus returns five minutes, one fix assignment five minutes. No laptops except the dashboard, no new metrics mid-meeting, no blame without data. Note decisions with date and revisit next week. Monthly add returns by SKU, discount leakage and fee review. Quarterly add pricing, assortment and channel mix.
Tool tips: save analyzer reports with dates, name files KPI-2026-W38, keep four weeks visible for trend, and chart margin plus ROAS together to see profit truth. Daily checks cause overreaction to noise. Weekly rhythm with fixed thresholds drives steady fixes that compound.
Fixing Red Metrics
Fix in priority order: cash first, fulfillment second, margin third, ads fourth. Cash red means chase top three overdue invoices today and delay non-critical buying. Fulfillment red means add shift, split jobs or expedite purchase orders. Margin red means cut deepest discount SKU, raise lowest margin line 10 percent or shift ads to high margin SKUs.
Ads red means pause bottom set, fix page conversion, then retest. Repeat red means follow up delivered orders for reviews and win-back offers. One fix per week with owner and date beats five started and none finished. Mistakes are ten KPIs, daily reactions, no thresholds, no owners and no archives. Discipline here funds payroll, stock and growth.
See numbering for traceability that makes fixes fast.
Checklist Before You File
Verify names spelled correctly, numbers sequential, dates real, quantities with units, prices with currency, tax with rate and ID, totals math-checked, payment method working, delivery address complete and terms signed. A two-minute check prevents a two-week dispute. Photograph or scan signed papers the same day and name files with number plus party plus date. Keep voided numbers with reasons. This habit alone halves support time for returns and audits.
File by month with subfolders for orders, jobs, invoices, receipts and KPI snapshots. Monthly, sample five documents per type and trace end to end. Quarterly, review top customers, top SKUs and channel costs. Yearly, archive with an index of sequences issued, voided and carried forward. Small discipline compounds into clean books and faster decisions.
Common Mistakes and Quick Fixes
Quoting in chat without scope causes price fights. Fix with written quotes linked to sales orders. Buying without purchase orders causes overpay. Fix with approval above threshold. Promising without stock check causes late shipments. Fix with allocation before promise. Running jobs without status causes chasing. Fix with daily status updates. Invoicing late causes cash gaps. Fix with same-day billing and Net 7 or 15. Deleting numbers causes audit risk. Fix with void logs. Scaling ads before margin fit causes cash burn. Fix with SKU margin review first.
Each fix takes minutes and pays for months. Pick one per week, assign owner and date, and confirm next Monday. Steady fixes beat big overhauls that stall.
Spot Money Leaks Early With a Simple Performance Scoreboard
A KPI board fits on one page and shows if the shop earned or bled. It lists sales, margin, cash, late bills, and ad cost per sale with last week beside this week. Green means hold course, red means fix now. All staff see the same facts. It stops month end shocks.
Take sales of $12,000 with costs of $8,400. First, 12,000 minus 8,400 equals $3,600 profit. Next, 3,600 divided by 12,000 equals 0.30. Then 0.30 times 100 equals 30 percent margin. If margin slips to 25 percent, profit drops to $3,000 on the same sales.
Ads feed the board through two costs. Cost per sale is ad spend divided by orders and must stay below profit per order. Return on spend is sales divided by spend and should clear 3.0 for most small shops. When either fails, pause weak ads and fix price or page. Daily ad checks are not needed for most shops.
Review takes 20 minutes each Monday. The five numbers are updated, change versus last week is marked, and one fix is picked for the next seven days. Each fix has an owner and a due date. Four weeks of notes show trends that gut feel misses.
- Sales and gross margin for the week
- Cash left plus late bills owed to you
- Ad spend, orders, and cost per sale
- Change versus last week in plain numbers
- One fix with owner and due date