KPI Dashboard for Small Business: The 10 Numbers Australian Owners Should Track

A KPI dashboard for small business should show about ten numbers on one page: cash in the bank, revenue, gross margin, money owed to you, days to get paid, pipeline, win rate, jobs on track, staff utilisation and new leads. Each one comes from a system you already use, like Xero, your CRM or your job app. Most of them only need a look once a week.

There are three ways to get them in one place. You can use Xero's own dashboard and reports, connect an off-the-shelf reporting tool like Looker Studio, Power BI, Fathom or Spotlight, or have a custom internal dashboard built that pulls from every system you run. Which one fits depends on how many of your numbers live outside Xero.

The short version: if most of the numbers you care about are financial, start with Xero's dashboard. If your bookkeeper or accountant wants deeper finance reports and forecasts, add a reporting tool. Go custom when your numbers are spread across Xero, a CRM, a job app and a few spreadsheets, and someone is copying them into one place by hand every week.

The 10 KPIs worth tracking in a small business

Google's autocomplete in Australia suggests both "kpi dashboard for small business" and "financial dashboard for small business", so plenty of owners are asking. Most KPI lists online run to 30 or 40 metrics. A small business doesn't need that many. These ten cover money, sales, delivery and marketing, and each one should lead to a decision.

If you only take three from this list, take cash, debtors and pipeline. Cash is where you are now. Debtors is money that should arrive soon. Pipeline is the work that comes after that.

Gross margin is only right if your bookkeeper codes materials, subcontractors and direct labour to cost of sales. Days to get paid usually has to be worked out from invoice and payment dates, which is the kind of sum a dashboard should do for you. Utilisation is billable hours divided by the hours someone was available, so leave doesn't drag it down.

You don't have to use all ten. A sole trader with five regular clients can skip win rate and utilisation. The test is simple: if the number moved, would anyone do anything differently? If not, take it off.

Where each number comes from

Most small businesses already have the data. It's just split across four or five places.

• Xero holds the money side: bank balances, invoices, payments, bills and the profit and loss. The first five KPIs come from here.
• Your CRM or quoting tool holds pipeline, win rate and, if your forms feed into it, new leads.
• Your job or project app knows which jobs are open or late, what was budgeted and who logged time.
• Spreadsheets fill the gaps, like targets and capacity plans.
• Google Analytics shows website visits and, if it's set up to track them, form enquiries.

The rule that matters most is one source per number. Revenue comes from Xero, full stop. If it also comes from the CRM's total of won deals, the two will never match and the meeting turns into an argument. Write a one-line definition for each KPI too. "Revenue: invoiced in the month, excluding GST, from Xero" settles most arguments before they start.

Matching across systems is harder. To tie won deals in the CRM to paid invoices in Xero, both systems need a shared customer ID, or you end up matching on names, and names drift. Our guide to connecting your CRM to everything covers how to set that up, and if you're on HubSpot, see what the HubSpot Xero integration does and doesn't sync.

How often to look at each number

Looking at every number every day is the fastest way to stop looking at them at all. A rhythm works better.

On Monday morning, look at the five numbers that change week to week: cash, debtors overdue, pipeline, jobs on track and new leads. Each one has an obvious next step. Overdue debtors get a call. A thin pipeline means more quoting. A slipping job gets a conversation before the client notices.

Once a month, ideally with your bookkeeper or accountant, look at revenue, gross margin, days to get paid, win rate and utilisation. These move slowly. Compare each with the same month last year, so seasonal businesses don't panic every winter.

Every number also needs an owner. "Debtors overdue: office manager, chases anything past due every Monday" beats a red tile nobody is responsible for.

Three ways to get a dashboard

1. Xero's own dashboard and reports

If you're on Xero, start here. Xero's Australian analytics page says you can customise the Xero dashboard to prioritise the metrics that matter to you, and monitor areas like your cash flow position, income versus expenses and gross profit.

Xero's help centre says every organisation gets the short-term cash flow projection and the business snapshot as part of the subscription. The projection runs over the next 7 or 30 days and shows invoices owed to you, bills to pay and the projected balance day by day. It also has a panel for overdue invoices where you can add expected payment dates, which makes the projection more realistic. With Xero Analytics Plus, Xero adds predictions and lets you extend the projection further out.

The limit is that Xero only knows what's in Xero. Pipeline, job status, utilisation and leads aren't there. For an owner whose main worry is cash, that might not matter.

Sources: Xero AU, Analytics and Xero Central, Use the short-term cash flow projection.

2. Off-the-shelf reporting tools

Looker Studio and Power BI are general tools that will chart almost anything you can get into them. Fathom and Spotlight are built around accounting data and are often run by your accountant.

Looker Studio is Google's reporting tool. Google's docs now say it's called Data Studio again, so you may see either name. The docs say its own connectors are free and built for data like Google Sheets, Google Ads and Google Analytics. Other sources come through partner connectors built by third parties, which Google notes may cost money. So for Xero you'd use a partner connector or a regular export into Google Sheets. Source: Google Data Studio docs, About data sources.

Power BI is Microsoft's option, and it suits businesses already on Microsoft 365. Microsoft's Power Query connector list includes Excel, SharePoint Online lists, Google Analytics, Google Sheets, Salesforce and Dynamics 365. Xero wasn't on that list when we checked on 20 October 2026, so you'd need a third-party connector or an export. Source: Microsoft Learn, Power Query connectors.

Fathom is a reporting, analysis and forecasting tool that connects to Xero, QuickBooks and MYOB. It does KPI tracking, management reports and three-way forecasts, and says you can bring operational data in through Google Sheets or Excel. Fathom says it syncs Xero data automatically once a day, before 8am AEST. Sources: Fathom and Fathom's Xero integration page.

Spotlight Reporting covers reporting, forecasting and dashboards, with Xero and QuickBooks integrations. It lists financial and non-financial KPI reporting, and says it integrates with non-financial data like Google Analytics. Its own site pitches it at accounting firms delivering advisory work as well as at businesses. Source: Spotlight Reporting.

Pricing changes, so check each one's current pricing page. And if your accountant already uses Fathom or Spotlight, ask them first. They may already have your file set up.

3. A custom internal dashboard

A custom dashboard is a page built for your business that pulls from every system on a schedule. Your definitions are built in, so revenue means the same thing every time. It can also send the Monday numbers by email and flag anything past a threshold, like a big debtor going well past due.

The connections behind it are ordinary automations. If that's a new idea, start with our explainer on what workflow automation is. When we build one through our internal dashboards service, it runs in your own accounts and you own it once it's paid for.

The downside is that it needs building and someone to look after it. Vendors change their APIs and connections drop, so it needs alerts for when a sync fails, or it quietly shows old numbers. If Xero's dashboard already answers your questions, you don't need one.

Comparing the three routes

Not sure which route fits? Book a free call and show us where your numbers live today. We'll tell you straight if Xero's dashboard is enough.

Worked example: a small Brisbane design studio

Here's a made-up but typical case. Say a seven-person building design studio in Brisbane: two directors, four designers and an office manager. They run Xero for accounts, a CRM for quotes, a project tool for jobs and timesheets, and a shared spreadsheet for targets.

Every Monday the office manager spends the morning copying numbers from all four into a spreadsheet for the directors' meeting. Revenue in the sheet never matches Xero, because the sheet counts quotes accepted and Xero counts invoices raised. Utilisation is usually left blank because it's the hardest to pull.

Here's how they'd set up a dashboard the directors trust:

1. Agree the ten numbers and a one-line definition for each, with the bookkeeper in the room.
2. Pick one source per number. Money comes from Xero, pipeline and win rate from the CRM, jobs and hours from the project tool, and targets from the spreadsheet.
3. Fix the data first. Consultant and printing costs move into cost of sales so gross margin means something. Every quote gets marked won or lost, including the ones that went quiet.
4. Build the page. Top row: cash and the cash projection, debtors overdue, pipeline. Middle row: revenue against last year, gross margin, win rate. Bottom row: projects over budget, utilisation by designer and new enquiries by source.
5. Send the five weekly numbers as a Monday email before the meeting.
6. Review the page after the first month and remove anything nobody used.

Now say the dashboard shows days to get paid creeping up, and most of the overdue money sits with one builder client. That's a phone call and maybe new payment terms. If win rate on small renovation quotes is far lower than on new homes, the directors might stop quoting the smallest jobs. If one designer's utilisation sits well above everyone else's, that's a workload problem to fix before they burn out.

Common mistakes with small business dashboards

• Too many charts. A dashboard with 40 tiles gets opened twice and then ignored. Keep the main page to the numbers you'd act on.
• Numbers nobody trusts. If the dashboard says one thing and Xero says another, people stop believing the dashboard. The usual causes are loose definitions (with or without GST, invoiced or paid) and data entered late.
• Manual copy-paste. A spreadsheet someone rebuilds every Monday is soon out of date, picks up typos, and stops completely when that person is on leave.
• Insisting on live data when weekly would do. Most small business numbers don't change fast enough to need it.
• Tracking what's easy to count. Website visits are easy to get. Enquiries are closer to money, so track those.

If you also send regular numbers to clients, the same rules apply. Our guide to automated client reports covers that side of it.

What we've built

For an NDIS provider, we built an obligations register in Excel Online with a live status dashboard alongside it. The team could see what was due, what was overdue and where evidence had been logged. Reminders went out on their own at 60, 30 and 7 days before each deadline, and a digest landed every Monday. That one tracked compliance deadlines. The same idea carries over to money and sales: one page that shows what needs attention, fed from the place the data already lives. You can read the NDIS compliance case study.

I also run Workvolve on a proposal and CRM app I built myself. It has its own dashboard showing where every proposal is up to, from sent through to signed and paid. It's my own tool, and it's a big part of why I'm fussy about one source per number.

Getting started

You can do most of the thinking with a pen. Write down the ten numbers you'd want, a definition for each, where it lives today and who would act on it. Then open Xero's dashboard and see how many of them it already covers.

If Xero covers most of them, set it up properly and you're done. If the list is spread across four systems and someone is pasting it together by hand every Monday, that's what our internal dashboard builds are for. We map each number to its source, agree how fresh it needs to be, and hand over the dashboard and its connections in your own accounts.

Want every number on one page without the copy-paste? Show us where your numbers live today. We'll tell you whether Xero's dashboard will do, or what a custom one would involve. Book a free call.