The KPI Dashboard Every SME Should Review Monthly

You don't need 50 KPIs. You need the right 10–15 numbers - reviewed consistently.

Running a business without monitoring its key performance indicators is a bit like driving a car without looking at the dashboard.

You might be moving.

You might even be moving quickly.

But you don't necessarily know:

• how much fuel you have left

• whether the engine is overheating

• how fast you're going

• or whether you're heading in the right direction.

The same applies to an SME.

Your accounts tell you what has happened financially. Your KPIs help you understand what is driving those results.

And importantly, the right KPIs can give you an early warning before the problem appears in your accounts.

What is a KPI?

KPI stands for Key Performance Indicator.

In simple terms, it is a measurable number that tells you something important about the performance of your business.

Examples include:

• revenue

• gross margin

• customer retention

• average transaction value

• debtor days

• sales conversion rate

• utilisation

• recurring revenue

• customer acquisition cost

But here's the important bit:

Not every metric is a KPI.

Your accounting software might give you hundreds of numbers.

That doesn't mean you need to monitor hundreds of numbers.

A good KPI is:

Relevant + measurable + actionable

If a number changes but you wouldn't change your behaviour because of it, it probably doesn't belong on your core dashboard.

The problem with measuring everything

Many business owners make one of two mistakes.

Mistake 1: They measure nothing

They look at:

"How much is in the bank?"

And perhaps:

"How much did we sell?"

That's not enough.

Mistake 2: They measure everything

They create a spreadsheet with 40 different KPIs.

Nobody looks at it.

Three months later, the dashboard is forgotten.

The objective isn't to create the biggest dashboard.

It's to create one you'll actually review every month.

The 10 KPIs every SME should consider

The exact KPIs will depend on your business model, but most SMEs should consider monitoring at least some of these.

Revenue

The obvious starting point.

How much are you selling?

But don't simply look at the total.

Track revenue by:

• month

• quarter

• product

• service

• location

• salesperson

• customer type

Where appropriate.

For example:

January: £40,000
February: £42,000
March: £55,000
April: £47,000

The trend tells you much more than a single annual figure.

Questions to ask

• Is revenue growing?

• Is growth consistent?

• Is growth seasonal?

• Which products/services are driving it?

• Are we dependent on a small number of customers?

Gross profit margin

This is one of the most important KPIs for many SMEs.

The calculation is:

Gross Profit ÷ Revenue × 100

For example:

Revenue: £100,000
Direct costs: £60,000
Gross profit: £40,000

Gross margin = 40%

Why does this matter?

Because increasing sales doesn't necessarily mean increasing profitability.

Imagine:

Revenue increases by 20%

but:

Gross margin falls from 40% to 30%.

You are selling more but potentially generating less profit from every pound of sales.

Monitor:

• current gross margin

• previous period

• budget

• same period last year

And investigate significant changes.

Net profit margin

Gross margin tells you about your core sales.

Net profit margin tells you what remains after operating costs.

The calculation is:

Net Profit ÷ Revenue × 100

For example:

Revenue: £500,000
Net profit: £50,000

Net profit margin = 10%

This allows you to compare profitability over time even when revenue changes.

For example:

Revenue increased by £100,000.

Profit increased slightly.

But the margin deteriorated.

That's a very different story from simply saying:

"Sales are up 25%."

Cash balance

We've already covered why cash matters in our previous article.

Your cash position should absolutely be on your KPI dashboard.

But don't just monitor today's bank balance.

Consider tracking:

Current cash

Forecast cash in 4 weeks

Forecast cash in 13 weeks

This gives you a much more useful view.

A business with £100,000 in the bank today could still face a cash-flow problem if £90,000 of payments are due shortly.

Debtor days

How quickly are customers paying you?

A useful KPI is debtor days.

A simplified calculation is:

Trade receivables ÷ credit sales × number of days

For example, if customers typically take 30 days to pay, your debtor days might be around 30.

If that suddenly increases to 50, something may have changed.

Perhaps:

• customers are paying more slowly

• your payment terms changed

• invoices aren't being sent promptly

• disputes have increased

• your credit control process isn't working

A two-week increase in debtor days can represent a significant amount of cash for an SME.

Monthly recurring revenue

For businesses operating on subscriptions or recurring contracts, MRR can be extremely useful.

MRR = Monthly Recurring Revenue

For example:

100 customers × £100 per month

= £10,000 MRR

If next month you have:

110 customers × £100

= £11,000 MRR

You can see the underlying recurring revenue base growing.

It is particularly useful for:

• SaaS businesses

• subscription businesses

• gyms

• memberships

• retainers

• recurring service businesses

Customer acquisition cost

How much does it cost you to acquire a customer?

For example:

You spend:

£5,000 on marketing and sales

and acquire:

100 new customers.

Customer acquisition cost:

£50 per customer

That number becomes much more useful when compared with customer value.

If the average customer generates £500 of gross profit, £50 acquisition cost may be perfectly reasonable.

If they generate £60, you have a problem.

This is why KPIs should not be viewed in isolation.

Customer retention / churn

Getting customers is only half the job.

Keeping them matters too.

Churn measures how many customers leave over a period.

For example:

You start the month with 500 customers.

25 leave.

Monthly churn = 5%

That might sound small.

But over time, high churn can seriously affect growth.

A business constantly replacing customers it loses is running hard just to stand still.

Ask:

• Why are customers leaving?

• Are certain customer groups more likely to leave?

• Has churn changed recently?

• Is churn linked to pricing, service or competition?

Average transaction value

This is particularly useful for retail, hospitality, e-commerce and many consumer-facing businesses.

For example:

£100,000 sales

÷

2,000 transactions

=

£50 average transaction value

You can then ask:

"Can we increase the average transaction from £50 to £55?"

That might be achieved through:

• bundles

• upselling

• cross-selling

• premium products

• pricing changes

Sometimes increasing the value of existing transactions is easier than finding significantly more customers.

Sales conversion rate

If your business generates leads, you should know how many become customers.

For example:

500 leads

100 customers

= 20% conversion rate

If you increase conversion to 25%, you could generate significantly more sales without increasing your marketing spend.

This is why:

More leads ≠ necessarily more revenue.

The quality of your sales process matters too.

Not every SME should use the same KPIs

This is important.

A KPI dashboard should reflect how your business actually makes money.

A gym shouldn't use exactly the same dashboard as a construction company.

A consultancy shouldn't use exactly the same metrics as an online retailer.

Let's look at some examples.

KPI dashboard for a professional services business

A consultancy, accountant, lawyer or agency might monitor:

For professional services businesses, utilisation can be particularly important.

If your team has significant unused capacity, you may have a profitability problem even if revenue looks healthy.

KPI dashboard for a retail business

A retailer might focus on:

• sales

• gross margin

• average transaction value

• number of transactions

• stock turnover

• stock days

• conversion rate

• customer acquisition cost

• return rate

• sales per employee

For retailers, inventory can be particularly important.

You can have a profitable product sitting on your shelves.

But until it sells, your cash is tied up.

KPI dashboard for a gym

A gym might monitor:

• active memberships

• new memberships

• cancellations

• churn

• average revenue per member

• personal training revenue

• membership revenue

• occupancy

• utilisation

• customer acquisition cost

• gross margin

• monthly cash flow

A gym owner might say:

"We have 800 members."

That's useful.

But imagine:

800 members
£50 average monthly revenue
5% monthly churn

That churn number becomes very important.

You may need to acquire 40 new members every month simply to replace those leaving.

That's a much more useful management conversation.

KPI dashboard for a construction business

Construction businesses have a very different financial profile.

Useful KPIs might include:

• revenue

• gross margin by project

• project profitability

• labour hours

• labour cost

• work in progress

• outstanding variations

• debtor days

• cash position

• order book

• project completion rate

The key question becomes:

"Are our projects actually making the margin we expected?"

A company can have a strong order book and still make poor profits if projects are badly priced or poorly controlled.

The KPI every SME should have: cash conversion

One of the most useful concepts for business owners is understanding how quickly profit turns into cash.

You can have:

£100,000 profit

but if customers are taking months to pay and you have significant stock or work in progress, cash conversion can be weak.

This is why I would always recommend looking at KPIs alongside:

• P&L

• balance sheet

• cash flow

• aged receivables

The numbers tell different parts of the same story.

Don't just measure KPIs. Set targets.

A KPI without a target is often just a number.

For example:

Gross margin: 38%

Is that good?

It depends.

If your target is 45%, perhaps not.

If your target is 35%, it could be excellent.

For each important KPI, establish:

Current → Target → Variance → Action

For example:

Now your dashboard becomes a management tool.

The danger of vanity metrics

Not every impressive-looking number is useful.

For example:

10,000 website visitors

Sounds great.

But if only 20 people become customers, what does it tell you?

Similarly:

50,000 social media followers

might look impressive.

But if they don't generate revenue, retention or brand value, the number may have little relevance to your financial performance.

This is why I prefer actionable KPIs over vanity metrics.

Ask:

"If this number changes, what would I do differently?"

If the answer is "nothing", reconsider whether it belongs on your core dashboard.

How often should you review KPIs?

For most SMEs:

Monthly is a good starting point.

Some KPIs should be monitored more frequently.

Daily

Potentially:

• sales

• cash

• orders

• website conversion

• operational capacity

Weekly

Potentially:

• leads

• sales pipeline

• debtor collection

• staffing

• stock

Monthly

Typically:

• revenue

• gross margin

• net profit

• cash flow

• debtor days

• budget vs actual

• key operational KPIs

Quarterly

Review:

• strategic performance

• pricing

• customer profitability

• product/service mix

• business targets

• longer-term forecasts

The frequency should reflect how quickly your business changes.

Your monthly KPI meeting

A KPI dashboard is only useful if somebody actually reviews it.

A simple monthly meeting could take 30–45 minutes.

What went well?

Identify positive movements.

What missed target?

Focus on significant variances.

Why?

Don't just record the number.

Understand the cause.

What needs action?

Assign specific actions.

Who owns the action?

Someone should be responsible.

When will it be reviewed?

Set a deadline.

This turns reporting into management.

A simple SME KPI dashboard

If you're starting from scratch, don't build a 30-metric monster.

Start with perhaps 10 core KPIs:

The dashboard should make problems visible immediately.

You shouldn't need to spend an hour interpreting it.

The traffic-light approach

One simple way of presenting KPIs is:

Green: on or above target

Amber: slightly outside target / monitor

Red: significant issue / action required

This makes dashboards much easier for non-financial managers to understand.

The goal isn't to make the report pretty.

The goal is to make it obvious where management attention is needed.

KPIs should lead to decisions

This is the most important principle.

A KPI is useful when it changes behaviour.

For example:

Gross margin falls from 42% to 35%.

Possible action:

→ review pricing
→ review supplier costs
→ analyse product mix

Debtor days increase from 30 to 50.

Possible action:

→ strengthen credit control
→ review payment terms
→ request deposits

Customer churn increases from 2% to 5%.

Possible action:

→ contact customers
→ investigate complaints
→ review pricing/service

Conversion falls from 25% to 15%.

Possible action:

→ review sales process
→ analyse lead quality
→ retrain sales team

That is what good management information should do.

Don't confuse KPIs with accounting

Accounting tells you what happened financially.

KPIs help explain why.

For example:

Your P&L tells you:

Gross profit fell by £15,000.

Your KPI dashboard might tell you:

• sales volume fell 5%

• average selling price fell 3%

• supplier costs increased 8%

• conversion rate fell 4 percentage points

Now you have something you can act on.

The Solutio approach

At SolutioAccounting, we don't believe SME owners need pages of financial data.

They need the right information, at the right time, presented in a way they can actually use.

Depending on the business, that might mean building a monthly dashboard around:

• profitability

• cash flow

• sales

• margins

• customers

• working capital

• operational performance

• business growth

The dashboard should reflect your business, not somebody else's template.

Because the most important KPI for a gym might be churn.

For a consultancy, it might be utilisation.

For a retailer, stock turnover.

For a construction company, project margin.

And for almost every SME:

Cash matters.

The bottom line

You don't need 50 KPIs.

You need the 10 or so numbers that genuinely tell you whether your business is healthy and moving towards its goals.

Review them consistently.

Compare them against targets.

Understand the reasons behind the variances.

And most importantly:

Take action.

Because a KPI dashboard isn't successful because it looks impressive.

It's successful when it helps you make a better business decision.

Want better visibility over your business?

If you're running an SME and want more than year-end accounts, SolutioAccounting can help you build practical management information around your business.

From management accounts and cash-flow forecasting to KPI dashboards and budgeting, the aim is simple:

Know your numbers. Plan ahead. Make better decisions.