Small Business KPI Dashboard: What to Track and How to Build Your First One

A useful small business KPI dashboard does not try to display every number in your accounting software, CRM or ecommerce platform. It gives owners and managers a short, trusted view of the numbers that require a decision this week.

The best first dashboard usually combines revenue, cash, sales activity, delivery or fulfilment performance and one or two customer indicators. The exact mix depends on whether you run a retail store, service company, ecommerce brand or manufacturing business.

This guide explains which KPIs to start with, how to organise dashboard views, where each metric usually comes from and how to avoid the inconsistent definitions that make manual reports unreliable.

For a foundational explanation of the wider category, see our guide to business intelligence dashboards and their benefits.

Start with decisions, not charts

Before choosing a visualisation, write down the decisions the dashboard must support. For example:

• Do we have enough cash to cover the next four to eight weeks?
• Are sales likely to meet this month’s target?
• Which opportunities need attention from the sales team?
• Are orders being delivered on time?
• Which products, services or channels are generating profitable revenue?

Each decision should have one primary KPI, a target or comparison and an owner. A dashboard becomes cluttered when it contains several versions of the same metric or numbers that nobody is expected to act on.

Use charts to explain movement, not to decorate the page. A scorecard can show current revenue against target; a line chart can show the trend over the past 12 weeks; a detail view can identify the customers, products or orders behind a change.

Owner dashboard: essential weekly KPIs

Most small businesses can begin with these eight KPIs. Add or remove metrics based on your business model, but avoid expanding the first version until these numbers are trusted.

1. Revenue

Show revenue for the current week and month, compared with the target and the same period previously. Define whether the figure includes taxes, shipping, discounts, returns or cancelled orders. Revenue is useful for measuring demand, but it does not show whether the business is profitable or collecting cash.

2. Gross profit and gross margin

Gross profit is sales revenue minus the direct cost of the products or services sold. Gross margin is gross profit divided by net sales. These measures help an owner see whether growth is producing enough contribution after direct costs. They are only as reliable as the product-cost, subcontractor-cost or billable-labour data behind them.

3. Cash position

Show cash available across bank accounts and payment platforms, alongside expected inflows and outflows. Keep cash separate from profit: an invoice can increase reported revenue before the customer pays, while a loan repayment can reduce cash without being an operating expense. A cash-flow view can also classify movement into operating, investing and financing activities.

4. Accounts receivable and overdue invoices

Track total unpaid invoices, the overdue amount and the oldest outstanding invoice. For businesses that sell on credit, this may be more actionable than a top-line sales figure. Include ageing bands such as current, 1–30 days overdue, 31–60 days and more than 60 days.

5. Sales pipeline value

Show the value of open opportunities by stage, expected close date and owner. Pipeline value should not be treated as guaranteed revenue. If useful, add a weighted pipeline using the probability assigned to each stage, but document how those probabilities are determined.

6. Win rate or conversion rate

Win rate can be calculated as won opportunities divided by closed opportunities for a defined period. Do not mix leads, opportunities, proposals and orders in the same calculation. A sales funnel should show how many records move from one stage to the next.

7. On-time delivery or fulfilment rate

Measure the percentage of jobs, orders or shipments completed by the promised date. Define whether partial deliveries, customer-caused delays and cancelled orders are included. This KPI connects operational performance to customer experience.

8. Customer retention, repeat purchase or churn

Choose the customer measure that fits your model. Ecommerce companies may track returning customer rate, subscription businesses may track churn, and service companies may track renewal or repeat-booking rate. Always state the period and customer population used in the calculation.

KPI dashboard examples by business type

Retail business

A retail owner needs a balance of sales, margin, stock and store productivity:

• Net sales by store, channel or category
• Gross margin by product category
• Average transaction value
• Units per transaction
• Sell-through rate and stock cover
• Stockout count for priority products
• Returns and refund value
• Staff hours or labour cost as a percentage of sales

Retail dashboards should make it easy to move from a weak category-level margin to the specific products, promotions or locations causing the result.

Service business

For agencies, consultants, repair companies and other service providers, capacity and billing are often more important than inventory:

• Booked revenue and recognised revenue
• Billable utilisation
• Billable hours versus available hours
• Average project or job margin
• Work in progress and unbilled work
• Jobs completed on time
• Average time to invoice
• Client renewal or repeat-booking rate

Utilisation should have a clear denominator. Decide whether available hours exclude leave, training, internal work and non-billable administration.

Ecommerce business

An ecommerce dashboard should connect traffic to profitable orders rather than focusing only on visits:

• Net sales and order count
• Average order value, calculated as eligible order revenue divided by orders
• Online store conversion rate
• Add-to-cart and checkout completion rates
• Gross profit and gross margin
• Customer acquisition cost by channel
• Returning customer rate or customer lifetime value
• Refund, return and fulfilment rate
• Days of inventory remaining for key products

Conversion rate can vary depending on the denominator. A store-wide rate may use completed purchases divided by sessions, while checkout conversion may use completed checkouts divided by checkout starts. Do not label both simply as “conversion rate.”

Manufacturing business

Manufacturers need visibility into production flow, quality, capacity and working capital:

• Production output versus plan
• Overall equipment effectiveness, where the underlying data is dependable
• Yield and scrap rate
• Downtime by cause
• On-time-in-full delivery
• Order backlog and schedule adherence
• Work-in-progress value
• Inventory turns and days of supply
• Supplier delivery performance

Start with the metrics that supervisors can verify during daily operations. A sophisticated production KPI is not useful if machine downtime or quality events are recorded inconsistently.

Sales, finance, operations and marketing metrics

Sales view

• New leads and qualified opportunities
• Pipeline value by stage
• Opportunity ageing
• Win rate
• Average deal size
• Sales cycle length
• Bookings or closed-won revenue

Show both volume and value. A rising lead count can hide a fall in lead quality, while a large pipeline can hide deals that have remained untouched for months.

Finance view

• Revenue and gross margin
• Operating expenses
• Operating profit or EBITDA, if appropriate for your reporting purpose
• Cash balance and short-term cash forecast
• Accounts receivable ageing
• Accounts payable due soon
• Tax liabilities and major upcoming payments

Use the finance dashboard for management reporting, not as a replacement for reconciled accounts or statutory reporting.

Operations view

• Orders or jobs in progress
• On-time completion rate
• Backlog and ageing
• Capacity utilisation
• Defects, rework or complaints
• Average cycle time
• Inventory availability or stock cover

Marketing view

• Qualified leads by source
• Cost per lead
• Customer acquisition cost
• Campaign-attributed revenue
• Conversion rate by landing page or campaign
• Return on advertising spend
• Email engagement and unsubscribe rate

Marketing attribution requires a consistent model. If one channel reports first-click revenue and another reports last-click revenue, the dashboard should show the distinction instead of presenting the figures as directly comparable.

Data-source and integration map

Map every KPI to a system of record before building the dashboard. A typical small-business data map looks like this:

• Accounting platform: revenue, expenses, profit, invoices, bills, tax categories and customer balances.
• Banking and payment platforms: cash balances, settlements, fees, refunds and payout timing.
• CRM: leads, opportunities, stages, owners, activities, close dates and win-loss outcomes.
• Ecommerce or point-of-sale platform: orders, products, discounts, returns, customers, inventory and fulfilment.
• Marketing platforms and web analytics: spend, impressions, sessions, campaigns, conversions and attribution fields.
• Operations, help-desk or project system: jobs, tickets, deadlines, labour time, defects and service-level results.
• Spreadsheets: temporary inputs such as targets, budgets, manually recorded machine readings or allocation rules.

Business intelligence tools such as Power BI and Looker Studio can connect to files, databases and online services, but connector availability, refresh limits and permissions vary. Treat spreadsheets as controlled source files rather than silently combining multiple versions of the truth.

Dashboard requirements template

Use this short specification for every KPI:

• KPI name: the plain-language label shown to users.
• Decision supported: what action the KPI is intended to inform.
• Formula: numerator, denominator and exclusions.
• Source system: the authoritative system and relevant fields.
• Time grain: daily, weekly, monthly or rolling period.
• Owner: the person responsible for reviewing and acting on it.
• Target: budget, plan, service level or approved range.
• Refresh expectation: live, hourly, daily or after a controlled weekly close.
• Quality check: reconciliation or exception test that confirms the data is usable.

A minimum viable dashboard should contain one owner page, five to ten KPIs, a target or comparison for each, a visible “last refreshed” timestamp and a drill-down or supporting report for unusual results.

Common KPI and data-quality mistakes

• Counting revenue as cash: distinguish invoices, recognised revenue, payments received and bank settlements.
• Changing definitions: document whether sales include taxes, shipping, discounts, returns and cancellations.
• Mixing time periods: compare like-for-like weeks or months and label rolling periods clearly.
• Double-counting customers or orders: define unique keys before joining CRM, accounting and ecommerce data.
• Ignoring data freshness: display the last successful refresh and alert someone when a source fails.
• Using vanity metrics: traffic, followers or total leads need a connection to revenue, margin or a specific decision.
• Overusing averages: a mean can hide large variations in order value, job duration or customer profitability; use medians or distributions where appropriate.
• Showing sensitive data too broadly: limit access to customer, payroll, bank and margin information. Role-based or row-level security may be needed when different users should see different records.

Do not assume a dashboard is secure simply because the report is shared internally. Review data credentials, sharing settings, user roles and whether a report exposes more information than the original source permissions allowed.

Build versus buy: which approach fits?

Buy or configure an existing dashboard when your data is already clean, your KPIs are standard and you need a quick first version. This can work well with accounting, ecommerce or CRM-native reporting.

Build a connected dashboard when managers are reconciling several systems, definitions differ between teams or decisions depend on combined data. A BI platform can provide centralised calculations, refresh schedules and controlled access, but it still needs a properly designed data model.

Use custom dashboard development when the business needs specialised workflows, operational data, complex permissions or reporting embedded in an internal application. Our guide to custom dashboard development for businesses covers when connected reporting goes beyond templates.

The practical sequence is usually: define decisions, choose the first KPIs, document formulas, connect the most reliable sources, validate the numbers against existing reports, then add detail views. A dashboard should earn expansion by helping people make better decisions—not by accumulating more charts.

FAQ

How many KPIs should a small business dashboard contain?

Start with five to ten owner-level KPIs. Separate supporting metrics into sales, finance, operations and marketing pages rather than placing everything on one screen.

Should KPIs be reviewed daily or weekly?

Review revenue, orders, cash alerts and operational exceptions as often as the business requires. A weekly owner review is usually a useful starting rhythm because it balances responsiveness with enough data to identify a trend.

What is the difference between a KPI dashboard and a performance scorecard?

A dashboard is usually an interactive view of current performance and trends. A scorecard normally emphasises targets, status and accountability. Many small businesses use both: a dashboard for diagnosis and a scorecard for weekly follow-up.

Can a dashboard replace spreadsheets?

It can reduce repeated manual reporting, but spreadsheets may still be useful for budgets, targets and controlled inputs. The goal is to remove uncontrolled copying and conflicting versions, not to eliminate every spreadsheet.

When should a business expand its first dashboard?

Expand only after the first KPIs have clear definitions, reliable refreshes and named owners. Then add role-specific pages, drill-downs, alerts or forecasts based on recurring decisions. If dashboards are part of a larger technology programme, connect the work to a wider digital transformation roadmap for small businesses.