A short rolling cash-flow forecast helps a business look ahead instead of relying only on the current bank balance. A 13-week view is one common planning horizon, but the right period and level of detail depend on the business.
Start with available cash
Record the opening cash balance for each bank account included in the forecast. Exclude restricted funds or amounts that are not available for ordinary operations. Reconcile the opening position to current bank information.
Estimate cash coming in
List expected customer receipts by likely collection date, not just invoice date. Separate confirmed receipts from uncertain or disputed amounts. Include other expected cash inflows only when there is a reasonable basis for the timing and amount.
List cash going out
Include supplier payments, payroll, rent, utilities, loan payments, taxes, insurance, planned purchases and other commitments. Use contractual due dates and the business’s realistic payment pattern. Avoid leaving out irregular or seasonal costs merely because they do not occur every week.
Calculate the closing position
For each week, add expected receipts to opening cash and subtract expected payments. The resulting closing balance becomes the next week’s opening balance. Highlight any projected shortfall early and record the assumptions that drive it.
Use scenarios
A base case can reflect the most likely timing. A cautious case can test slower collections or higher costs. A stronger case can show what happens if receipts arrive earlier. Scenarios are planning tools, not predictions or guarantees.
Update with actual results
At the end of each week, replace forecast figures with actual receipts and payments, explain material variances and roll the forecast forward. Assign someone to update assumptions and escalate emerging pressure.
Questions for management
- Which receipts are uncertain or overdue?
- Which payments are essential and contractually due?
- What is the lowest projected cash point?
- Are planned purchases or owner withdrawals affordable?
- What action requires approval before a shortfall occurs?
Borrowing, delaying payments or changing tax-payment plans can have legal and financial consequences. Seek appropriate professional advice before taking action.