What it means
A company maintains a 13-week cash view. At the end of week one, it replaces expected bank movement with actuals, adds week 14 and revises the expected collection dates in the remaining weeks, so the horizon always remains 13 weeks.
A business.com guide describes the same mechanic and treats 13 weeks as an example rather than a universal requirement. Choose a horizon and frequency that fit the decisions.
Weekly buckets can support payroll and supplier planning, daily buckets may be needed during a tight cash period, and a longer monthly view can help with strategic choices. Start with verified opening cash for each bank account and entity, noting restrictions, uncleared items and currencies, because a consolidated balance can hide money that cannot readily fund a local obligation.
List inflows by expected cash date, not invoice date, and outflows by payment date. Open receivables, contract milestones, subscriptions and new sales carry different confidence levels, and an overdue invoice should not stay on its original forecast date indefinitely.
Payroll, rent, supplier bills, tax, debt service and committed capital purchases should follow actual agreements rather than a smooth monthly average. Reconcile the first week with bank transactions and classify differences as timing, amount, omitted item or data error.
The Association for Financial Professionals discusses effective cash forecasting as a decision tool that depends on inputs and process, so the forecast needs clear ownership and review rather than a spreadsheet that merely rolls dates forward. Keep a minimum cash threshold too: a forecast ending above zero may still breach payroll needs, lender covenants or the owner's risk buffer, so show the lowest week and the available headroom.
Separate committed flows from uncertain ones, because a signed invoice due soon carries different evidence from a hopeful pipeline item. Adjust expected dates using each buyer's actual payment history while keeping contract due dates visible for collections work.
Watch for one-off events such as tax settlements, annual insurance premiums and inventory builds, and avoid double counting a customer deposit and the final invoice payment. Do not confuse a cash forecast with profit, since a profitable service can run short of cash when customers pay after wages and suppliers are due.
Use scenarios such as slow collections or a delayed launch to test the buffer, without assuming a credit facility can be drawn before checking its terms. For an owner, the forecast answers when cash could become tight and why, which lets them act while options remain.
In practice
Real-world examples.
Example
A software distributor keeps a 13-week forecast. When week one closes, the finance lead replaces the forecast with bank actuals, drops that week and adds a new week 13 at the end. The remaining weeks are re-dated using what customers actually did.
Example
A consulting firm has a $30,000 receipt that is two weeks overdue. Instead of leaving it on its original date, the team moves it to a date supported by the client's latest email and flags it for collections. The forecast then shows a more honest low point in cash.
Example
A retailer places a seasonal stock order of $120,000 payable before the holiday sales arrive. The rolling view shows a short-lived cash dip in week 6 that a monthly average would have hidden, so the owner arranges supplier terms in good time.
Formula
Calculation
Weekly closing cash = opening cash + cash receipts - cash payments. The closing figure, once validated against the bank, becomes the next week's opening cash.
Worked example: a business opens a week with $80,000, expects receipts of $45,000 and payments of $55,000. Closing cash = $80,000 + $45,000 - $55,000 = $70,000. If the minimum cash threshold is $60,000, headroom is $70,000 - $60,000 = $10,000.
Now roll the forecast forward. If next week's receipts are $40,000 and payments $62,000, closing cash is $70,000 + $40,000 - $62,000 = $48,000, which is $12,000 below the $60,000 threshold. That shortfall is exactly what the rolling view is designed to reveal early.Case study
Seen in the real world.
In this entirely fictional example, Lakeview Services rolls a weekly cash forecast forward. An expected $30,000 receipt misses its date, so the team moves it to a supported estimate and sees that cash would fall below the owner's $25,000 threshold in week 5. It reviews optional spending and customer follow-up. The case does not assume the receipt or a loan will arrive on time.
The controller then splits the inflows into signed invoices and pipeline items, and shows the weeks where only signed invoices are counted. The result is a range rather than a single number, which makes the conversation with the owner far more practical. By week 8 the receipt has arrived and the team records the variance as a timing difference. The forecast has done its job: it prompted action early, and the actuals now feed the next round of assumptions.
Watch out
Common mistakes.
- Rolling dates without reconciling actual bank cash.
- Forecasting invoice dates rather than likely receipt dates.
- Treating optimistic pipeline opportunities as certain cash.
Questions
People also ask.
Why is it called rolling?
The forward window moves ahead as completed periods become actual.
Must the forecast be 13 weeks?
No. Match the horizon and time buckets to the decisions and cash risk.
Is it a substitute for a budget?
No. It focuses on cash timing and is updated more frequently.
From the founder's library
Take it further with the book.
Build your financial confidence beyond this definition. Shihan's full-length guide, Accounting Fundamentals, takes the same plain-English approach and turns it into a complete, practical playbook for non-finance managers, business owners and students - with chapter-end quiz answers and presentation slides included.
25% off with code MMHQ25, applied at checkout. Priced in USD - checkout may show the equivalent in your local currency.
View the book and save 25%