Build a rolling cash flow forecast by starting with reconciled cash in the bank, estimating when receipts and payments will actually clear, and carrying each period’s closing balance into the next. At each review, replace estimates for completed periods with actuals, revise dates and assumptions using new information, then add a period at the far end. A weekly 13-week forecast is one useful short-term format—not a rule; choose a cadence and horizon that fit your cash cycle and the reliability of your information.
What a rolling cash flow forecast shows
A rolling forecast estimates cash entering and leaving the business over a sequence of future periods. It is designed to answer practical liquidity questions: when might cash run low, which payments or receipts drive that risk, and how much time is available to respond?
As an Amazon Associate I earn from qualifying purchases.
“Rolling” describes how the forecast is maintained. After a period ends, record what actually happened, replace that completed estimate with actuals, and add a new period to the end. The forecast therefore keeps looking forward rather than ending on a fixed date. For an operational cash forecast, focus on expected bank movements—not profit, revenue recognition, or expenses that have not yet been paid. See the Tauro Accounting guide for a weekly example.
What’s actually slowing this PC down?
Pick the symptom - the matching free tool is one click away.
Choose a useful cadence and horizon
Use periods detailed enough to reveal cash pressure without creating work the team cannot keep current. Daily or weekly views can support near-term oversight; longer periods can help with strategic planning. The forecast should extend at least as far ahead as the business’s cash-flow cycle. A 13-week weekly forecast is a common practical pattern in the Tauro guide, but it is not a universal requirement. The British Business Bank recommends looking at least as far ahead as the cash-flow cycle, while Business.govt.nz describes daily or weekly oversight as well as longer-term forecasts.
#1 Best Overall
- 【Stylish Budget Binder】:1pcs PU leather money saving binder,8pcs A6 zipper cash budget envelope 12pcs expense budget sheets,2 sheets of English letter sticker labels,8 colored self-adhesive labels,Great way to organize your money, expenses and savings.
- 【Pretty Gift A6 Money Saving Binder 】Budget binder with cash envelopes for budgeting is an ideal gift for family, friends, colleagues and children. A6 binder is lightweight easy to carry, convenient for home, office, school and travel.
- 【Easy To Carry A6 Budget Binder 】A6 Binder fits in your handbag, backpack, suitcase or desk,suitable for storing pen, passports, ID cards, bank cards and other important things，Budget envelopes is convenient for storing cards, stamps, tickets, pens, etc
- 【Money Envelopes for cash】waterproof sticker labels make you easily categorize all of your budgets, stick it on the cash envelopes to keep everything organized. budget sheets allow you track your cash flow. Use them with your cash budgeting system will keep you stay on a budget.
- OUR SERVICE : Thank you for your trust in NICOOTH budget binder.
- Daily: Consider it when receipt and payment timing within a week materially affects available cash.
- Weekly: Often a workable near-term view when daily detail is unnecessary.
- Monthly or longer: Useful for broader planning, but may conceal the order of payments and receipts within a period.
Use more detail where timing is both important and reasonably knowable. Avoid implying that a distant estimate is precise simply because it appears in a spreadsheet.
Set up the forecast
- Reconcile the opening cash balance. Confirm the balance as of a specific date across the bank accounts included in the forecast. Use available bank records and accounting data to resolve discrepancies before projecting forward.
- Choose periods and the end date. Create weekly columns, for example, and extend them across the cash-flow cycle you need to manage. If using a 13-week view, treat that as a planning choice rather than a rule.
- Create consistent rows. Include opening balance, receipts, payments, net cash movement, and closing balance. Separate material types of receipts and payments so timing differences remain visible.
- Record assumptions and sources. Note the evidence behind expected dates and amounts, such as an invoice, customer payment pattern, payroll calendar, loan schedule, or known renewal.
- Calculate and carry balances forward. For each period, subtract total payments from total receipts. Add the result to opening cash to get closing cash; use that closing figure as the next period’s opening cash.
- Identify the lowest projected balance. Highlight the period and date or week of the trough, and compare it with any minimum-cash threshold the business uses. If a financing assumption is included, label it clearly rather than blending it into expected operating cash.
Estimate receipts when cash is likely to arrive
Use invoices and receivables, customer payment history, recurring billing records, and other documented sources to estimate incoming cash. Place each receipt in the period when it is reasonably expected to clear the bank—not automatically on the sale date or invoice due date. Customer payment practices can make the actual collection date different from the stated terms. The Australian Government’s small-business guidance discusses organizing cash-in information in its cash-in resource.
Include other receipts when they are sufficiently supported. Keep uncertain sales pipeline, uncommitted financing, and speculative funding separate from expected receipts; otherwise a forecast can show cash that the business has not actually secured.
Outdated Drivers Are Slowing You Down
One free scan finds every outdated or missing driver and matches the right update for your exact hardware.Free scan · exact hardware matchPC Slower Than It Used to Be?
A free scan shows the junk files, broken settings and background clutter dragging Windows down - then fixes them in one click.Free scan · Windows 10 & 11Estimate payments when they are likely to leave the bank
Build payment rows from supplier bills and expected payment practices, then add payroll, rent, debt service, taxes, fees, and known irregular costs. Calendars and records help establish timing: supplier payables, payroll dates, loan schedules, compliance dates, and renewal notices. The Australian Government’s cash-flow data guide covers gathering records for forecasting.
Include lumpy payments such as insurance renewals, bonuses, and tax instalments in the periods when they are expected, rather than smoothing them into average monthly costs. Adapt tax and payroll items to the business’s jurisdiction: the Australian resource discusses tax and super commitments, while the Canadian Tauro example refers to HST and corporate instalments. Those are local examples, not obligations that apply everywhere.
Calculate the running balance and examine the trough
Use the same calculation in each period:
Net cash movement = total receipts − total payments
Closing cash = opening cash + net cash movement
Next period’s opening cash = previous period’s closing cash
For example, if a week starts with $20,000, has $12,000 in receipts and $15,000 in payments, it ends with $17,000: $20,000 + ($12,000 − $15,000). This is an illustration of the calculation, not a benchmark for a particular business.
The Tool Desk
Outbyte Driver Updater FREEScan for outdated or missing drivers - takes under a minuteDriver Scan →Outbyte PC Repair FREEClear out junk files and repair common Windows errorsFree Scan →Review the lowest projected balance, not just the balance at the end of the forecast. A customer payment expected late in a week may arrive after payroll, rent, or tax payments due earlier in that same week. If that order matters, shorten the time buckets or split the period so the timing is visible. A forecast that nets a week or month into one total can hide a temporary shortfall.
Best Value
Use scenarios when dates or amounts are uncertain
When a key assumption is uncertain, show how the forecast changes under different plausible conditions instead of concealing the uncertainty in one estimate. Business.govt.nz suggests pessimistic, realistic, and optimistic income estimates. Identify what differs in each case—such as a delayed customer payment or lower receipts—and compare the resulting troughs. Do not treat an optimistic scenario as committed cash.
Keep the forecast rolling
Make updating part of a recurring review, such as a weekly close for a weekly forecast. Use a spreadsheet or accounting software; the right format is the one the team can maintain with reliable inputs and visible assumptions. The British Business Bank notes that spreadsheets can recalculate as inputs change, and Business.govt.nz describes both spreadsheets and accounting software.
- Replace the completed period’s estimates with actual receipts and payments.
- Compare actuals with the forecast and record meaningful variances and their causes, such as a late collection or changed payment date.
- Update future dates and amounts when evidence changes; do not move figures merely to make the forecast look better.
- Check the new lowest projected balance and whether it creates a decision that needs attention.
- Add one new period at the far end so the forecast continues to cover the selected horizon.
Common mistakes to avoid
- Starting from the wrong cash balance: an opening-balance error flows through every projected period.
- Forecasting profit instead of cash timing: sales can be recorded before collection, and expenses before payment; a liquidity forecast needs bank movements.
- Counting pipeline as a receipt: keep speculative sales and uncommitted financing visibly separate from supported inflows.
- Ignoring irregular payments: renewals, bonuses, and instalments can create a low point that average monthly costs conceal.
- Overcomplicating the model: detail that is not refreshed can make a forecast less useful than a simpler, maintained one.
Choose a format the team can maintain
A spreadsheet or accounting software can both support a cash forecast. Before choosing, check whether the format can represent the needed periods, accept dependable source data, show assumptions and formulas clearly, replace estimates with actuals, extend the horizon, and support scenarios if needed. Also consider the effort and cost of keeping it current. The cited guidance does not establish a product-by-product comparison, so choose based on the business’s process rather than assumed features.
Quick Recap
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
