Cash on hand
$76.2K
▲ $3.7K
Projected low
$4.8K
wk of Jul 20
AR outstanding
$32.5K
18 accounts
Overdue 30+
$9.8K
3 accounts
Net cash (MTD)
+$8.1K
▲ 12%
8-week cash outlook
Projected cash balance
Dashed line = $10K comfort floor · the dip lands the week of Jul 20
Money in vs. out
Cash in vs. out
Weekly inflows vs. outflows ($K)
Where the cash goes
Outflows by category
Receivables — who owes you
Receivables by age
Outstanding balance by days late
Top accounts owing
Red = 30+ days overdue
🤖 Insights
- Cash is healthy now but dips to ~$4.8K the week of Jul 20.
- A payroll run and a quarterly insurance bill land together that week.
- $9.8K is 30+ days overdue across 3 accounts; DSO crept to 38 days.
✅ Recommended actions
- Send reminders to the 3 overdue accounts this week.
- Stagger the insurance payment after payroll if the vendor allows.
- Tighten billing cadence to pull DSO back under 35 days.
🗄️ Data sources
- Bank feeds — balances & transactions
- Accounting — AR (invoices) & AP (bills)
- Invoicing system — due dates & terms
📐 Definitions & methodology
- Projected cash = balance + expected inflows − scheduled outflows
- AR aging = unpaid invoices bucketed by days outstanding
- DSO = (AR ÷ revenue) × days in period
