Finance · Sourced explainer
How to Build a Rolling Cash-Flow Forecast
Build a rolling cash-flow forecast from bank balances, expected collection dates, and payment commitments, then test the effect of late receipts.

A cash-flow forecast shows when money is expected to reach or leave the business. Its purpose is to reveal a payment problem early enough to choose a response. It differs from a sales target and from an income statement prepared using accrual accounting.
The SBA's finance guidance distinguishes cash and accrual recording and emphasizes control over receivables, payables, available cash, reconciliation, and payroll. Those are useful inputs for a forecast. SBA finance guidance
Begin with cash that is actually available
Reconcile the opening balance to bank records. Identify restricted funds, payments already issued, and transactions that have not cleared. A credit facility is a separate financing assumption, not money already held in the bank.
For a short planning horizon, weekly columns can expose timing that a monthly total would hide. Choose a period that covers the business's next important commitments and extend it as each week closes. Thirteen weeks is one possible operating choice, not a mandatory standard.
Forecast the collection date, not just the invoice date
List expected receipts by customer and likely payment week. Use contractual terms alongside actual payment history. Keep an overdue invoice visible rather than automatically moving it one week forward without explanation.
Separate firm receivables from hoped-for sales. A signed order, an issued invoice, and a sales opportunity have different levels of uncertainty. Show those differences so the team can see which receipt is carrying the plan.
Include every material cash commitment
Build payment rows for payroll, suppliers, rent, tax payments, debt service, equipment deposits, insurance, owner distributions, and irregular renewals where relevant. Obtain dates from the actual commitment instead of assuming an even monthly pattern.
For this illustrative week, opening cash is $20,000. Expected receipts are $12,000 and planned payments are $18,000. Ending cash is $14,000: opening cash plus receipts minus payments. If $8,000 of those receipts arrives a week late, ending cash becomes $6,000.
This example demonstrates timing sensitivity. It is not a forecast for any named business.
Show the adverse case explicitly
Test slower collection, a delayed launch, or a larger inventory deposit. Avoid combining every possible shock into an unexplained worst case; choose assumptions that reveal a decision.
Identify the minimum operating balance the business needs and who can authorize changes if the forecast approaches it. Possible responses might include adjusting a purchase schedule, chasing a disputed invoice, or speaking with a lender. The right response depends on actual contracts and circumstances.
Reconcile forecast and actuals
When a week closes, record actual receipts and payments. Label differences as timing, amount, missing item, or changed business conditions. This turns the forecast into an improving model rather than a spreadsheet continually overwritten to match reality.
Assign an owner to each major assumption. Sales may know when a customer expects to approve an invoice; operations may know about an upcoming deposit. Finance should reconcile those inputs into one view.
Use the forecast before committing
Review the cash effect of a new hire, large order, or equipment purchase before accepting it. A profitable project can still require more working capital than the company can provide at the required date.
The linked calculators can help organize payment and inventory assumptions. Read the interest-rate explainer for financing sensitivity and the supply-chain guide for buffer-stock decisions.
Common questions
Is profit enough to show that a company can pay its bills?
No. Revenue recognition, inventory purchases, loan principal, and collection timing can create a gap between reported profit and available cash.
Should tax dates be estimated from memory?
Use the dates and amounts appropriate to the business's actual obligations and confirm uncertain entries with its accountant. A generic template is not a tax calendar.
How often should the forecast change?
Update as actuals arrive and material assumptions change. A short weekly review is useful when near-term receipts and commitments move frequently.
References
Sources & further reading
Sources consulted October 17, 2026. These organizations do not endorse this article.
- Manage your financesU.S. Small Business Administration