Syntha Lab RU

Owner dashboard: 10 indicators and a traffic light

Compares key business indicators with plan, colors the deviation as a traffic light with your tolerance and points to where to work out the cause. The set of indicators is a platform suggestion, replace it with your own.

Owner’s cash and management dashboard For whom: Owners and directors who run the business by numbers.

Calculate on your data →

At a glance

What question does it answer?
Which ten indicators to watch at what rhythm and where they have departed from plan.
What data is needed?
The actual for each indicator for its own period: week, month, quarter.
How to read the result?
Take the red indicators first: the “where to find the cause” column leads to the right calculation. The tolerance is illustrative, set your own. The set of indicators is a platform suggestion, replace it with your own. Example on the default values: Indicators included — 10; On track — 3; Attention — 4; Red — 3.

Why and how to reason

An owner needs not a 40-page report but ten indicators that show in time where something goes wrong. So each indicator is compared with its plan and colored: a favorable deviation gives on track, a small adverse one within tolerance gives attention, beyond tolerance red. Direction matters: sales growth is good, overdue receivables growth is bad, so an indicator carries a sign. Example: sales 3.1 million against a plan of 3.4 million is −8.8% with a 5% tolerance: red. Cash 9.2 million against 8.0 is +15%: on track. Overdue receivables 1.05 against 1.0 million are 5% worse than plan with a 10% tolerance: attention. In total 3 on track, 4 attention, 3 red, the worst −18%. The traffic light does not explain the cause, it says where to look, so each row has a hint on which calculation to open.

When to use it

It is useful for a weekly and monthly meeting: 10 indicators, the same rhythm, a plan for each. The set of indicators is the platform’s proposal, replace it with your own and keep those you can actually influence. It does not replace management accounting and does not fit a company without a plan: the traffic light compares with plan, so a bad plan makes the light meaningless. Set tolerances by the volatility of an indicator: 5% for sales, 10% for stock.

How to read the result

Start with reds, then attention items that risk turning red. Check for groups: red sales and red cash together is a signal of a different scale than a single red row. The worst deviation hints where to start but is not always the most important: compare in roubles. For each red, name a cause and an owner before the next meeting. If everything is green for months, tolerance is too wide or the plan too soft. Assign an owner to each red indicator and a date by which he brings the cause and action, and start the next meeting with them, not with the general picture.

Common mistakes

The usual mistakes: not setting direction (growing overdue would turn green); taking a plan with no basis; too narrow a tolerance, so everything is red and the signal is lost; looking at the color without causes. Do not add indicators that lead to no decision. Do not change the plan after the fact just to turn an indicator green.

What data is needed?

  • The actual for each indicator for its own period: week, month, quarter.
  • The plan or limit and the tolerance you are ready to accept.

Inputs

FieldUnitValue in the exampleMeaning
Common tolerance for deviation from plan%5Optional. A rule of thumb; a row can have its own tolerance. Within tolerance: attention, beyond: red.

How it is calculated

StepFormula
Deviation(Actual − plan) ÷ |plan|, allowing for the indicator’s direction
Traffic lightNot worse than plan: on track; worse but within tolerance: attention; beyond: red

Worked numbers

Default values from the app; in the interactive version you enter your own.

Indicators included
10
On track
3
Attention
4
Red
3
Worst against plan
−18.2 % · EBITDA, % of revenue

Traffic light by indicator

IndicatorRhythmActualPlanVs planStatusWhere to find the cause
Weekly sales, RUBWeek3,100,0003,400,000−8.8 %redSales plan, forecast
Cash on accounts against payments for 4 weeks, RUBWeek9,200,0008,000,00015 %on trackCash flow by month
Overdue receivables, RUBWeek1,050,0001,000,0005 %attentionCost of payment terms
Season sell-through, %Week5355−3.6 %attentionSell-through and season pace
Gross margin, %Month56.4560.7 %on trackChannel margin
Stock, days of salesMonth1281206.7 %attentionDays of inventory and excess
Advertising to revenue, %Month14.615−2.7 %on trackAdvertising: ROAS, ad share and ROMI
Repeat customer share, %Month2428−14.3 %redRepeat purchases
EBITDA, % of revenueQuarter911−18.2 %redFixed and variable costs
Cash conversion cycle, daysQuarter96906.7 %attentionCash conversion cycle

Meeting rhythm (a platform suggestion): weekly 30 minutes on cash and sales; monthly on margin, stock and marketing; quarterly on strategy, budget and goals. A red indicator is a reason to find the cause, not excuses.

Nuances and limits

  • Too many indicators and no owner for each.
  • Indicators used to fit rather than to measure.
  • A tolerance without a reason: one percent for everything.

Terms used

Calculate on your data →