Cash flow problems rarely arise overnight. It gives an early warning. Late payment. Early procurement. Invoices not issued. A sudden spike in labor or overhead costs.
The problem isn't that there's no data. The problem is that it takes too long to compile the data.
The 13-week cash flow forecast provides the answer. Weekly breakdown. Short-term outlook. Continuously updated.
1. Why 13 weeks?
Three months is long enough to see the next critical point. It's still short enough for the estimate to remain useful.
The 13 weeks cover:
- the regular payroll and tax payment cycle;
- the payment terms for most customers;
- short-term purchases;
- the funding requirements for project launches;
- the initial impact of seasonal variations.
Not an annual budget. Not an income statement. A liquidity indicator system.
2. One line. One transaction.
A forecast remains manageable as long as the structure is simple.
Incoming funds:
- invoices issued;
- expected invoices;
- advances;
- recurring revenue;
- other reliable sources of cash inflows.
Outgoing payments:
- wages and related costs;
- suppliers;
- rental fees;
- system and subscription costs;
- loans;
- tax and other obligations;
- investments;
- payments to owners, if planned.
Each row should include the total, week, currency, status, and person in charge.
3. Don't mix up money you're sure to receive with money you hope to receive
The biggest flaw in the forecast is optimism.
Use reliability categories:
- A – certainly: contractual, confirmed, due shortly;
- B – probable: It's realistic, but there's still some uncertainty;
- Option C: a quote, a prospective project, or an unconfirmed amount.
The baseline forecast should be based only on items A and the controlled item B. Category C represents a particularly favorable scenario.
Hope is not liquidity.
4. The opening balance should be clear
The first row of the model represents the money that can actually be used.
Don't base your decision solely on your bank account balance.
Subtract:
- set-aside tax revenue;
- a customer advance, if it cannot be used for any other purpose;
- already approved, immediate payment;
- a technical or blocked amount.
If the opening number is incorrect, all subsequent weeks will be incorrect.
5. Weekly Net Cash Flow and Closing Cash Balance
Every week is based on two basic formulas:
Weekly net cash position = cash inflows − cash outflows.
Weekly closing balance = previous week's closing balance + weekly net cash position.
The manager's view must include three indicators:
- minimum balance;
- alert level;
- critical level.
If the forecast exceeds the threshold in any given week, an action plan is triggered. Not during the critical week. Now.
6. Develop three scenarios
The base model alone isn't enough.
You must have at least three views:
- Base case: the most likely mode of operation at this time.
- Adverse case: Customers who pay late, lower revenue, or higher costs.
- Best-case scenario: A new store or faster delivery.
The worst-case scenario should be specific.
Example:
- The two largest customers are two weeks behind schedule;
- A project launch is delayed by one month;
- a major expense increases by 15%;
- An expected advance payment has not been received.
A scenario is not a prediction. It is a test of decision-making.
7. Provide a brief explanation for each week
Please include an explanation next to the number.
A brief comment will suffice:
- „large supplier advance payment”;
- „quarterly tax payment”;
- „Project closing invoice expected”;
- „Two customer payments are uncertain”;
- „Investment only after approval.”.
Thus, the forecast is not a black box. It is a traceable decision-making model.
8. The Weekly Update Process
The 13-week forecast is a rolling system.
Every week:
- record actual cash flows;
- compare it with the plan;
- explain the large discrepancies;
- Update the next 12 weeks;
- add a new, thirteenth week;
- Record the decisions.
A discrepancy in and of itself is not an error. An unexplained discrepancy is an error.
9. Decision Signals
A forecast is only useful if it leads to a decision.
A pre-recorded message may be:
- falling below the minimum cash balance;
- two consecutive weeks of negative results;
- an increase in customer concentration risk;
- An increase in receivables more than 30 days past due;
- unplanned investment need;
- a funding shortfall in the event of an adverse scenario.
Each prompt should have a possible response:
- speeding up the management of outstanding receivables;
- advancing the billing date;
- rescheduling of procurement;
- cost cap;
- advance payment request;
- funding coordination;
- Amendment to the owner's payment.
10. The Manager's Perspective
Don't bring all the lines to the meeting.
The executive summary includes:
- current available funds;
- lowest expected balance;
- the date of the critical week;
- the three biggest risks;
- three necessary decisions;
- Person in charge and deadline.
A good forecast doesn't tell you what's going to happen. It shows you when to make a decision so that the problem doesn't decide for you.
This article presents a general business planning framework. To create a specific financial model, you must use your company's own data and operating procedures.