Level 7, 55 Collins Street, MelbourneMon to Fri, 8.30am to 6pm03 8375 4177
Performance · 8 min read

The monthly numbers every business owner should track

A one-page monthly dashboard for an owner-managed business: the dozen numbers worth checking, what each one tells you, and what a warning sign looks like.

At a glance

  • A good monthly report fits on one page. About a dozen numbers cover sales, margin, costs, profit, cash and risk.
  • Compare each number with the same month last year, not just last month, so seasonal swings don't fool you.
  • Rising sales can hide falling margin, slower collections and a growing reliance on one customer.
  • The point is not the report. It is the decision you make after reading it.

Why one page is enough

Most owners get a profit and loss statement each month, if they get anything. It shows sales and costs, but it says little about cash, customers or what is coming next. A long pack of reports is no better. Nobody reads it.

A one-page dashboard picks the numbers that matter and shows each one against last year. You can read it in five minutes and see straight away where to look.

What the page looks like

Take a made-up commercial electrical contractor. Here is its dashboard for October, with each number compared to October last year.

Hypothetical example · commercial electrical contractor, October vs last OctoberRevenue up 12.5%. Margin and profit both down.
Revenue $450k +12.5% on $400k Gross margin 32.0% Last Oct 36.0% Overheads $110k Last Oct $100k Net profit $34k Last Oct $44k Cash balance $180k Last Oct $260k 13-week cash low $40k Week 9 of 13 Debtor days 45 Last Oct 38 Stock days 12 Last Oct 8 Creditor days 20 Last Oct 30 Top customer share 28% Last Oct 18% Jobs invoiced 18 Last Oct 20 Average job value $25.0k Last Oct $20.0k sales up, margin down

Lime arrow: moving the right way. Coral: moving the wrong way. White: neither.

Lime arrows are moving the right way. Coral arrows need a look. At first glance this was a good month: sales up 12.5%. But gross profit was $144k in both years. The extra $50k of sales earned nothing extra, overheads rose $10k, and net profit fell from $44k to $34k. Customers are also paying slower, stock is building and suppliers are being paid sooner.

The trend behind the month

One month can be noise. Twelve months show a pattern. Here, revenue has climbed over the year, with a dip early on, while gross margin has slipped in most months.

Hypothetical example · same business, November last year to October this yearRevenue climbed to $450k. Margin slid to 32.0%.
Revenue each month $380k $450k Gross margin % 36% 34% 32% 30% 36.0% 32.0% 4 points gone in a year NovDecJanFebMarAprMayJunJulAugSepOct

No single month looked alarming. Over the year, though, four points of margin went missing. On $450k of monthly sales, that is about $18k of gross profit a month. Bigger jobs at sharper prices, or materials costing more than quoted, are the usual places to look.

Each number in plain words

The days measures here use a simple method: the balance at month end, divided by that month's sales (or cost of sales), times 30. Use the same GST basis for both numbers. In October, customers owed $675k on $450k of sales, which is 45 days.

Hypothetical example · what each number tells you, with October's warning signsTen numbers, and what a warning sign looks like.
NumberWhat it tells youWarning sign
Revenue vs last yearWhether the business is really growing, allowing for the seasonGrowth that comes with lower margin, as here
Gross margin %How much of each sales dollar is left after direct costsA slow slide, from 36.0% to 32.0%
OverheadsThe fixed cost of running the businessRising faster than gross profit: up $10k while gross profit stayed at $144k
Net profitWhat is left after overheads (and, in full accounts, interest and tax)Falling while sales rise: $44k to $34k
Cash and 13-week outlookMoney in the bank now and the lowest point comingA low point that is close to zero, or keeps moving earlier: $40k in week 9
Debtor daysHow long customers take to payCreeping up: 38 to 45 days
Stock daysHow long materials sit before useBuilding up: 8 to 12 days
Creditor daysHow long you take to pay suppliersFalling with no plan behind it: 30 to 20 days
Top customer shareHow much of the last 12 months' sales came from one customerGrowing reliance: 18% to 28%
Jobs and average job valueWhat drives sales: 18 jobs at $25.0k each is $450kFewer, bigger jobs that may carry thinner margins

Pick one or two drivers that fit your own business. A retailer might track foot traffic and average sale. A professional firm might track billable hours and recovery rates. The rule is the same: choose numbers that move before profit does.

How to set it up

1

Close the month quickly

Aim to have the figures within two weeks of month end. Old numbers lead to late decisions.

2

Fix the list

Choose your dozen numbers and keep them the same each month, so trends are easy to see.

3

Compare with last year

Show the same month last year beside each number, plus a 12-month trend for margin and cash.

4

Mark what needs a look

Agree in advance what counts as a warning for your business, so the page flags it for you.

5

Decide and follow up

End each review with two or three actions, an owner for each, and a check at next month's meeting.

The numbers are only as good as the books. If stock counts, work in progress or accruals are rough, the dashboard will be too. Ask your accountant to help keep month-end entries consistent, and treat any big swing as a question before you treat it as a fact.

When a second pair of eyes helps

Owners are close to their numbers, which makes slow drifts hard to see. If the dashboard keeps flagging the same problem, a Commercial Business Review can dig into the cause. If cash is the worry, our guide on why profit is up but cash is not shows where it usually goes.

Review your numbers every month

Ongoing Advisory gives you a monthly meeting on the numbers and decisions, with agreed follow-up, under a written scope and hours cap. From $3,000 a month + GST.

See Ongoing Advisory

General information only, not advice for your circumstances. See our terms.

Tell us about the decision.

We reply within one business day with whether we can help, the service we would start with and its fixed fee.

Call 03 8375 4177Speak with an adviser