Company Performance

Deal Source Company Performance Dashboard

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