Dashboard / as at 2 Nov 2026
Kauri Joinery Ltd
Demo business with made-up figures, recalculated every hour. All amounts in NZD.
This week
Customers owe you $52.5k that is past due.
One thing to do this week
Chase Fletcher Living for $38.4k
It is 42 days overdue. A short call, or a reminder with the invoice attached, is a good start.
Key numbers
2 Nov 2026Cash in the bank
$79.6k
-$1.4k since 31 Oct
Sales in November so far
$14k
too early to compare
Profit in October
$36.8k
-$10.4k vs September
Overdue, owed to you
$52.5k
3 invoices
Bills due in 14 days
$20.6k
3 bills
Monthly sales goal
$14k of $200k 7%
Sales so far in November are $14k of your $200k goal (7%), with 28 days to go.
What changed
Most important first. Every number is calculated from your Xero figures.
-
Overdue invoices (Worth a look)
Customers owe you $52.5k that is past due, across 3 invoices. Biggest: Fletcher Living $38.4k (42 days overdue), Mitchell & Sons Builders $9.8k (18 days overdue), Waiheke Holiday Homes $4.2k (6 days overdue). In total, money owed to you (receivables) is $271k.
-
Reliance on one customer (Worth knowing)
Fletcher Living made up 41% of what you invoiced over the last 3 months ($246.6k of $596k). $38.4k of what they owe is overdue.
-
Bills due soon (Worth knowing)
$20.6k of bills are due in the next 14 days. Cash in the bank covers that 3.9 times over.
-
Timber and sheet materials up (Worth a look)
Timber and sheet materials was $73.6k in October, $18.3k (33%) more than its usual $55.3k a month, allowing for the level of sales.
Show 4 smaller changesShow fewer
-
Gross margin (Worth a look)
Gross margin was 46% in October, down from 55% in September. In plain terms: from every $100 of sales, $46 was left after direct costs, against $55 the month before.
-
Sales in October (Good news)
Sales in October were $199.6k, up $11.2k (6%) on September, mainly because of Joinery contracts ($7.2k higher than in September). That is up 9% on October last year ($183.5k).
-
Profit in October (Worth a look)
October made a profit of $36.8k, down $10.4k on September ($47.2k), mainly because of Timber and sheet materials ($19.8k higher than in September).
-
Cash in the bank (Worth knowing)
Cash in the bank is $79.6k, down $1.4k since the end of October.
Show the numbers
| October 2026 | $199,642 |
| September 2026 | $188,465 |
| August 2026 | $176,867 |
| July 2026 | $160,785 |
| June 2026 | $161,748 |
| May 2026 | $188,195 |
| April 2026 | $175,322 |
| March 2026 | $183,791 |
| February 2026 | $160,793 |
| January 2026 | $124,270 |
| December 2025 | $173,991 |
| November 2025 | $185,244 |
| October 2025 | $183,515 |
| September 2025 | $182,465 |
| August 2025 | $166,194 |
| July 2025 | $148,018 |
| June 2025 | $156,154 |
| May 2025 | $164,439 |
| April 2025 | $170,472 |
| March 2025 | $175,501 |
| February 2025 | $148,274 |
| January 2025 | $119,055 |
| December 2024 | $161,434 |
| November 2024 | $182,324 |
Show the numbers
| October 2026 | $36,798 |
| September 2026 | $47,166 |
| August 2026 | $39,519 |
| July 2026 | $33,347 |
| June 2026 | $32,853 |
| May 2026 | $53,989 |
| April 2026 | $40,560 |
| March 2026 | $47,103 |
| February 2026 | $35,337 |
| January 2026 | $15,101 |
| December 2025 | $42,583 |
| November 2025 | $48,323 |
| October 2025 | $46,187 |
| September 2025 | $44,731 |
| August 2025 | $34,426 |
| July 2025 | $24,921 |
| June 2025 | $35,552 |
| May 2025 | $36,190 |
| April 2025 | $40,664 |
| March 2025 | $44,278 |
| February 2025 | $28,100 |
| January 2025 | $15,630 |
| December 2024 | $38,225 |
| November 2024 | $49,010 |
Show the numbers
| October 2026 | $81,045 |
| September 2026 | $88,296 |
| August 2026 | $86,989 |
| July 2026 | $85,667 |
| June 2026 | $83,748 |
| May 2026 | $85,132 |
| April 2026 | $82,867 |
| March 2026 | $83,135 |
| February 2026 | $80,079 |
| January 2026 | $80,129 |
| December 2025 | $80,261 |
| November 2025 | $77,950 |
| October 2025 | $77,389 |
| September 2025 | $75,824 |
| August 2025 | $75,479 |
| July 2025 | $75,728 |
| June 2025 | $74,580 |
| May 2025 | $73,204 |
| April 2025 | $71,378 |
| March 2025 | $72,441 |
| February 2025 | $69,958 |
| January 2025 | $69,416 |
| December 2024 | $69,423 |
| November 2024 | $68,738 |
Show the numbers
| October 2026 | $218,185 |
| September 2026 | $248,634 |
| August 2026 | $226,061 |
| July 2026 | $217,492 |
| June 2026 | $210,290 |
| May 2026 | $247,708 |
| April 2026 | $266,762 |
| March 2026 | $269,200 |
| February 2026 | $220,246 |
| January 2026 | $244,121 |
| December 2025 | $221,815 |
| November 2025 | $263,643 |
| October 2025 | $238,807 |
| September 2025 | $212,325 |
| August 2025 | $230,373 |
| July 2025 | $221,582 |
| June 2025 | $232,214 |
| May 2025 | $258,459 |
| April 2025 | $250,137 |
| March 2025 | $210,761 |
| February 2025 | $214,732 |
| January 2025 | $222,467 |
| December 2024 | $271,342 |
| November 2024 | $258,657 |
Overdue: who owes you
| Customer | Overdue | Oldest |
|---|---|---|
| Fletcher Living | $38,400 | 42 days |
| Mitchell & Sons Builders | $9,850 | 18 days |
| Waiheke Holiday Homes | $4,210 | 6 days |
Costs that moved in October
| Cost | October | vs usual |
|---|---|---|
| Timber and sheet materials | $73,570 | +$18.3k |
"Usual" is the average of the previous six months. Direct costs are adjusted for the level of sales.
Biggest customers, last 3 months
- Fletcher Living$246,610 (41%)
- Mitchell & Sons Builders$106,995 (18%)
- Ponsonby Fitout Group$69,480 (12%)
- Waiheke Holiday Homes$67,351 (11%)
- Tamaki Schools Trust$46,320 (8%)
Share of what you invoiced (before tax) in the last 3 months.
All amounts are in NZD, the base currency in Xero. ReportPilot only reads from Xero; it cannot change anything in your books.