You're running a growing business. Revenue looks healthy. But when someone asks "how many months of cash do we have left?" or "what's our actual margin after subcontractors?", you're digging through Xero, your bank app, and three different spreadsheets to piece together an answer. By the time you have the number, the meeting has moved on.
A KPI dashboard puts your most important metrics in one place, updated regularly, visible at a glance. No digging. No guessing. This guide covers which KPIs actually matter for Irish SMEs, how to calculate them accurately, and how to build a dashboard that drives decisions rather than collecting dust.
What Problem Does a KPI Dashboard Solve for Irish SMEs?
Most small business owners know their revenue. Fewer know their margin. Even fewer know their cash runway or debtor days without running a report. And those three numbers, margin, runway, and debtor days, are the ones that determine whether the business survives the next quarter.
A KPI dashboard solves this by surfacing the metrics that matter on a single screen. It gives you:
- Faster decisions: You see the numbers before the problem becomes a crisis. Debtor days creeping from 35 to 48 is a trend you can act on. Discovering it at month end when cash is already tight is damage control.
- Fewer surprises: Margin erosion, cash burn acceleration, overdue receivables building up: these all show up on a dashboard weeks before they hit your bank balance.
- Better conversations: With your team, your accountant, your bank. A dashboard gives everyone the same picture to work from, not different versions of the truth pulled from different sources.
If you're running the business from memory and monthly accounts that arrive three weeks late, a dashboard changes the game.
What Is a KPI Dashboard (and What Is a KPI)?
A KPI, or Key Performance Indicator, is a measurable signal tied to a specific business goal. "Revenue" is a metric. "Revenue growth rate vs target" is a KPI, because it tells you whether you're on track.
A KPI dashboard is a visual, regularly updated view of your most important KPIs in one place. Think of it as the instrument panel in a car: speed, fuel, temperature, engine warning light. You don't need to open the bonnet to know something needs attention.
There's a difference between a dashboard and a report:
- Dashboard: Ongoing monitoring. Updated daily or weekly. Designed for quick scanning and pattern recognition.
- Report: Periodic analysis. Monthly or quarterly. Includes deeper commentary, variance explanations, and recommendations.
You need both. The dashboard tells you what's happening now. The report tells you why. But if you only have one, start with the dashboard. It's the one that prevents surprises.
Which KPIs Should an Irish SME Track?
The temptation is to track everything. Don't. Too many KPIs dilute focus. A dashboard with 30 metrics is just a prettier spreadsheet. Start with the metrics that matter most for cash flow, profitability, and financial health, then add others as needed.
The Core Finance KPIs
These are the ones every SME should have front and centre:
Gross Margin
Revenue minus direct costs, expressed as a percentage. This tells you how much of every euro you keep before overheads. Track it monthly and, if possible, by service line or customer segment. When margin drops, you need to know whether it's a pricing issue, a cost issue, or a mix shift. A dashboard that shows margin trending from 42% to 36% over three months is worth more than a profit and loss report that arrives after the quarter is over.
Cash Runway
How many months of operating expenses your current cash balance covers. The formula: cash balance divided by average monthly net cash burn. If your runway is under three months, you need to act. If it's under six months and shrinking, you need a plan. Build a base case and a worst case to see the range.
Debtor Days (DSO)
How long it takes your customers to pay, on average. The formula: (trade receivables / credit sales) x number of days in the period. An Irish SME with 30-day terms but 52 actual debtor days has a collection problem, and that gap is funded by your cash. Track the trend monthly. Pair it with a debtors ageing breakdown so you can see which customers are stretching and which balances are at risk.
Net Profit or EBITDA
Gross margin tells you the product-level picture. Net profit tells you the whole-business picture. A company can have healthy margins and still lose money if overheads are out of control. Track net profit monthly against target and prior year.
Supporting Cash KPIs
- Bank balance trend: A simple weekly chart showing your cash position over time. Is it climbing, flat, or declining?
- Cash in vs cash out: Weekly or monthly. Total cash receipts versus total cash payments. When outflows consistently exceed inflows, runway is shrinking.
- Overdue receivables: The total value of invoices past due date. Split by 30, 60, 90+ days. This is actionable: someone should be chasing these.
- VAT and payroll liabilities: Particularly important in Ireland. Knowing what you owe Revenue before the payment date prevents nasty surprises.
Sales and Operational KPIs (If Relevant)
Depending on your business, you might also track:
- Sales pipeline value and conversion rate.
- Customer acquisition cost and customer lifetime value.
- Employee utilisation (for services businesses).
- Stock turnover (for product businesses).
Add these once your financial KPIs are solid. They're valuable, but margin, runway, and debtor days are the ones that keep the lights on.
How Do You Set Targets and Thresholds?
Every KPI on your dashboard should have a target and a RAG status (red, amber, green). For example:
- Debtor days: green under 35, amber 35-45, red over 45.
- Cash runway: green over 6 months, amber 3-6 months, red under 3 months.
- Gross margin: green above 40%, amber 35-40%, red below 35%.
When a KPI turns red, there should be a pre-agreed action. Who investigates? What levers get pulled? A dashboard without trigger actions is just information. A dashboard with trigger actions is a management system.
How Do You Calculate Margin, Runway, and Debtor Days Accurately?
The formulas are simple. Getting clean data into them is where it gets tricky.
Margin: Make sure your direct costs are consistently classified. If subcontractor costs sometimes sit in overheads and sometimes in cost of sales, your margin will bounce around for the wrong reasons. Define what's "direct" once, stick to it, and review the classification quarterly.
Runway: Define your cash burn period clearly. Use the average of the last three months of net cash outflows, not just last month (which could be unusually high or low). Factor in known future commitments like tax payments or annual insurance. A runway calculation that ignores a €30,000 VAT bill due next month is dangerously optimistic.
Debtor days: Use trade receivables only (exclude prepayments, deposits, and related-party balances). Use credit sales, not total revenue, if you have a significant cash sales component. Watch for distortions from credit notes and partial payments: they can make DSO look better or worse than reality.
What Does a Good KPI Dashboard Look Like?
A good dashboard is one you actually look at. That means:
- One screen: If you have to scroll or click through tabs to see the key numbers, it's a report, not a dashboard.
- Visual hierarchy: The three or four most critical KPIs should be the largest elements. Everything else supports them.
- Trends, not just snapshots: A number on its own is less useful than a number with a trend line. "Debtor days: 42" tells you something. "Debtor days: 42, up from 35 three months ago" tells you much more.
- RAG indicators: Green, amber, red at a glance. You should be able to scan the dashboard in ten seconds and know if anything needs attention.
For a financial KPI dashboard, a typical layout might include:
|
KPI |
Current |
Target |
Trend |
Status |
|
Gross Margin |
41% |
40% |
Stable |
Green |
|
Cash Runway |
5.2 months |
6 months |
Declining |
Amber |
|
Debtor Days |
47 |
35 |
Rising |
Red |
|
Net Profit (MTD) |
€18,200 |
€22,000 |
Below target |
Amber |
|
Overdue Receivables |
€34,500 |
<€20,000 |
Rising |
Red |
One glance tells you: margin is fine, but cash is under pressure because debtors are stretching and overdue balances are climbing. That's an actionable insight. Now you know where to focus this week.
Should You Build Your Dashboard in a Spreadsheet or Use Software?
Spreadsheets work for getting started. You can build a basic financial KPI dashboard in Excel or Google Sheets using data you already have in Xero or your accounting software. The advantage is full control and zero cost. The disadvantage is manual updates: someone has to pull the data, paste it in, and refresh the formulas every week.
Dashboard solutions like Power BI, Fathom, Spotlight Reporting, or SimpleKPI connect directly to your data sources and update automatically. They offer better visualisation, real-time or near-real-time data, and the ability to customise views for different stakeholders (an owner's dashboard vs a sales manager's dashboard).
The right choice depends on where you are:
- Starting out: Build in a spreadsheet. Get the habit of reviewing KPIs weekly before investing in software.
- Growing team: Move to a dashboard solution when manual updates become a bottleneck or when you need multiple people viewing the same live data.
- Multiple data sources: If you need to pull from Xero, a CRM, and a project management tool, software handles the integration far better than a spreadsheet.
What Are the Most Common KPI Dashboard Mistakes?
- Too many KPIs: If everything is important, nothing is. Limit your dashboard to 5-8 KPIs. Track everything else in reports.
- Vanity metrics: Revenue without margin context is misleading. Website traffic without conversion data is noise. Every KPI should connect to a business outcome.
- No targets: A KPI without a target is just a number. Set targets so you know whether the number is good, bad, or indifferent.
- Stale data: A dashboard updated monthly is a report with a fancy layout. Update weekly at minimum for financial KPIs.
- No action triggers: The dashboard should drive behaviour. If debtor days hit red, who calls the overdue customers? If runway drops below three months, what spending gets paused? Define the actions upfront.
Frequently Asked Questions About KPI Dashboards for SMEs
How many KPIs should an SME track on a dashboard?
Five to eight. Enough to cover financial health (margin, cash, debtors) and one or two operational indicators relevant to your business. Anything beyond that belongs in monthly reporting, not the dashboard.
What tools can I use to build a KPI dashboard?
Start with Google Sheets or Excel if you want simplicity and control. For automated, connected dashboards, look at Fathom, Spotlight Reporting, Power BI, or SimpleKPI. Most integrate with Xero and other accounting platforms, pulling data automatically so you don't have to re-enter it.
How often should I review my KPI dashboard?
Weekly for financial KPIs. The dashboard should be a standing agenda item in your weekly management meeting or owner review. Monthly is too slow for cash-related metrics; by the time you spot a problem, it's already impacting your bank balance.
What's the difference between leading and lagging KPIs?
Lagging KPIs measure results after the fact: revenue, profit, debtor days. Leading KPIs predict future results: pipeline value, quote-to-close ratio, customer enquiries. A good dashboard includes both so you can see what's happened and what's likely to happen next.
Ready to See Your Business Clearly?
If you're making decisions based on gut feel, outdated accounts, or numbers scattered across multiple tools, a KPI dashboard changes that. We build and maintain financial dashboards for Irish SMEs: margin, runway, debtor days, cash position, profitability, all in one place, updated weekly, with targets and trigger actions so the numbers drive decisions.
Get in touch today to get a KPI dashboard built for your business. We'll identify the metrics that matter most, connect the data, set the targets, and give you a weekly view you can actually use.
Disclaimer: This guide is for general information purposes only and does not constitute tax advice. Tax rules and thresholds can change. Always consult a qualified accountant or tax adviser for advice specific to your circumstances.