Sample company figures: The financial, revenue, churn, cash, and operations values in this v4 model are demonstration data, not Deal Source actuals. Client Results remain blank until verified campaign data is connected. Click Load client JSON to replace the sample.
Edit mode is on. Change any highlighted number and everything downstream recalculates. Changes are saved in this browser and travel with Export. The original file is never overwritten.
Company financials
Monthly Revenue
Total monthly revenue, plan vs actual. Ending MRR is tracked separately in the rollforward.
PlanActual
MRR Rollforward:
Starting + New − Churned = Ending. Hover a bar for its make-up.
Gross Margin %
Delivery margin vs floor and target. Hover for the month's margin math, click a point for the full breakdown.
PlanActualBelow floor
Cost Structure:
Where the money goes, as % of revenue. Click any line to open its make-up.
Profitability by Client, most to least
YTD contribution (revenue minus direct delivery cost). Client margin stays provisional until account costs and time data are verified.
Net Profit trend
Monthly net profit, plan vs actual
PlanActual
Recurring Revenue Forecast
Retainer MRR, expansion, new clients, and churn. Nonretainer revenue stays in Total Revenue.
Booked only+ Expansion+ New salesPlan
Assumptions (edit any of these)
Contracted vs Forecast
Use contract end dates only when signed terms confirm them. Month-to-month accounts belong in the client risk list.
ContractedGap to winTotal forecast
Run-rate vs Goal
Annualized actual run-rate vs committed / stretch
Retention
Net & gross revenue retention and client retention. Hover for the month, click for the clients behind it.
NRRGRRClient retention
Deal Source Acquisition:
Agency leads move through booked, qualified, and showed calls to new clients won. Client campaign leads are in Client Results.
Churn by segment
One blended number hides the segment that is actually bleeding. Click a segment for its clients and reasons.
Segment churn trend
Monthly logo churn by segment. Hover for the month.
Why clients left
Churn reasons across the trailing period. Click a reason for the clients behind it.
Churned clients, trailing 12 months
Click a row for the full exit record. In edit mode you can re-code the reason and segment.
13-Week Cash Flow
Projected cash position, week by week. Hover any week; click for inflow / outflow detail. Inflow and outflow are editable, and the balance re-runs forward.
Ending cashInflowOutflowBelow zero
Week by week
Contract actions: next 90 days
Only confirmed end or notice dates belong here. Click a row for the contract details.
Contracts and notice dates
Signed terms only. Click to expand.
Weekly Core Metrics:
The same target/actual grid as the Weekly Core Metrics sheet. Green = hit, red = miss. Click any red cell to log the reason and the experiment. It lands in Red Metrics.
Metrics that missed, and who owns the fix
Every metric below target across the dashboard, collected automatically. The owner writes why it missed and what they will try instead. Nothing here is optional. An open row stays red.
Response log
Everything submitted, newest first. Copy it into the weekly meeting or export it with the file.
The plan:
This is the only place plan numbers can be changed. Everywhere else in the dashboard the plan is read-only, so there is one version of the budget and one place to argue with it.
Editing any MRR line re-chains every later month: each month starts where the previous one ended. The bridge counts expansion, which the source file left out of ending MRR.
Data Quality: confidence register
What is verified vs estimated vs unconfirmed, why it matters, and how to firm it up.
Deal Source · Company Performance · Company and client delivery