13-Week Cash Flow
Rolling forecast from outstanding A/R, unpaid bills and recurring rules
Opening cash
$0
from ledger
Projected in (13 wks)
$0
A/R + recurring income
Projected out (13 wks)
$0
bills + recurring expense
Closing cash
$0
week 13
Lowest point
$0
β
Projected cash balance
Weekly detail
| Week | Starting | A/R in | Recurring in | Bills out | Recurring out | Net | Closing |
|---|---|---|---|---|---|---|---|
| ⳠLoading⦠| |||||||
Assumptions. Weeks start Monday. A/R = invoices not
paid, void or archived, landing on their due date plus the collection lag.
Bills = unpaid bills on their due date. Recurring = active rules expanded forward from next at their frequency, stopping at each rule's end date.
Opening cash is derived from posted ledger transactions (income + donations + grants + transfers in, less expenses and transfers out) and can be overridden above.
GST remittances, payroll runs not set up as recurring rules, and loan draws are not modelled.