Expected Revenue (March)
$402k
100% invoiced
Collected to Date
$354k
88% collected
Outstanding (Active)
$48k
12% unpaid
Carryover Debt (Prior Months)
$31.2k
8 clients
| Client Name |
Monthly Fee |
Invoice Date |
Due Date |
Days Overdue |
Paid Amount |
Carryover Debt |
Total Owed |
Payment Status |
Action |
| Newark Plumbing |
$4,200 |
1 Mar |
20 Mar |
9d |
$0 |
$8,400 |
$12,600 |
🔴 Serious |
|
| ES4U Electrical |
$4,200 |
1 Mar |
11 Mar |
18d |
$0 |
$0 |
$4,200 |
🔴 Overdue |
|
| DigiType Australia |
$3,800 |
1 Mar |
15 Mar |
14d |
$0 |
$1,200 |
$5,000 |
🔴 Debt + overdue |
|
| Complete Refrigeration |
$3,200 |
1 Mar |
18 Mar |
11d |
$0 |
$6,400 |
$9,600 |
🔴 Serious |
|
| Proform Electrical |
$3,600 |
1 Mar |
25 Mar |
4d |
$0 |
$0 |
$3,600 |
🟡 Late |
|
| AirCool HVAC |
$4,800 |
1 Mar |
28 Mar |
1d |
$0 |
$0 |
$4,800 |
🟡 Late |
|
| Sparky Solutions |
$3,400 |
1 Mar |
10 Mar |
19d |
$0 |
$3,400 |
$6,800 |
🔴 Recurring late |
|
| BuildRight Plumbing |
$3,400 |
1 Mar |
31 Mar |
— |
$3,400 |
$0 |
$0 |
✅ Paid |
— |
| TradeMaster Services |
$4,600 |
1 Mar |
5 Apr |
— |
$0 |
$0 |
$4,600 |
🟢 Future |
|
| Elite Electrical |
$4,200 |
1 Mar |
8 Apr |
— |
$0 |
$0 |
$4,200 |
🟢 Future |
|
Total outstanding (active)
$48k (12 clients)
With carryover debt
$31.2k (8 clients)
Seriously overdue (30d+)
$22.2k (4 clients)
Average days to payment
18 days
| Client |
Last Active Month |
Monthly Fee |
Total Owed |
Days Since Last Payment |
Suspended Date |
Recovery Action |
Status |
| Newark Plumbing |
Dec 2025 |
$4,200 |
$16,800 |
120d |
15 Feb 2026 |
Debt collection agency |
🔴 In collections |
| Superior HVAC |
Nov 2025 |
$3,600 |
$14,400 |
150d |
10 Jan 2026 |
Legal notice sent |
🔴 Legal |
| Metro Electrical |
Oct 2025 |
$3,200 |
$12,800 |
180d |
5 Dec 2025 |
Write-off pending |
🟡 Write-off review |
| FastFix Plumbing |
Sep 2025 |
$2,800 |
$8,400 |
210d |
1 Nov 2025 |
Written off |
⚫ Closed |
Total debt owed (inactive)
$52.4k
In active collections
$31.2k (2 clients)
Pending write-off
$21.2k (2 clients)
| Client Name |
Oct |
Nov |
Dec |
Jan |
Feb |
Mar |
Pattern |
| BuildRight Plumbing |
🟢 |
🟢 |
🟢 |
🟢 |
🟢 |
🟢 |
Always on time |
| TradeMaster Services |
🟢 |
🟡 |
🟢 |
🟢 |
🟡 |
🟢 |
Occasionally late |
| ES4U Electrical |
🟢 |
🟢 |
🟡 |
🟡 |
🔴 |
🔴 |
Deteriorating |
| DigiType Australia |
🟡 |
🔴 |
🔴 |
🔴 |
🔴 |
🔴 |
Chronic late |
| Newark Plumbing |
🟢 |
🟡 |
🔴 |
🔴 |
⚫ |
⚫ |
Suspended |
| Elite Electrical |
🟢 |
🟢 |
🟢 |
🟡 |
🟢 |
🟢 |
Mostly reliable |
| AirCool HVAC |
🟢 |
🟢 |
🟡 |
🟢 |
🟢 |
🟡 |
Stable |
| Complete Refrigeration |
🟢 |
🟡 |
🟡 |
🔴 |
🔴 |
🔴 |
Worsening |
| Proform Electrical |
🟢 |
🟢 |
🟢 |
🟢 |
🟡 |
🟡 |
Recent slippage |
| Sparky Solutions |
🟡 |
🔴 |
🟡 |
🔴 |
🔴 |
🔴 |
Erratic pattern |
🔴 4 clients showing deteriorating payment patterns (green → amber → red trend). Proactive outreach recommended before they escalate.