Project-based businesses, seasonal companies, and early-stage growth firms all share the same forecasting problem: the annual budget was built on assumptions that started unravelling by February, and by June the cash picture is genuinely unclear.
The standard 12-month cash flow forecast, built in October with neat monthly columns and steady assumptions, is not designed for this kind of business. It is designed for businesses with contracted, recurring revenue, predictable cost structures, and minimal exposure to timing risk. For everyone else, it produces false confidence and late surprises.
This article explains the forecasting approaches that actually work when revenue is lumpy, seasonal, or project-dependent: the direct method, the 13-week rolling forecast, and the structural buffer discipline that separates businesses that manage through unpredictability from ones that get caught by it.
Why the Standard Approach Fails
The indirect cash flow method, which starts from net profit and adjusts for non-cash items and working capital changes, is the standard format for statutory reporting. It is not useful for operational cash management when revenue is uncertain.
The problem is timing. An indirect forecast tells you the net cash change for a period, but it does not tell you in which week the cash hits. For a project-based business waiting on a CHF 400K milestone payment, the difference between that payment arriving on the 25th versus the 8th of next month is the difference between making payroll comfortably and making a call to the bank.
When revenue is unpredictable, you need the direct method: mapping actual expected cash inflows and outflows by week or by month, based on what you know is coming in and what you know needs to go out. No aggregation, no netting, no working capital adjustment. Just money in, money out, and the resulting balance.
The Direct Method: How to Build It
A direct cash flow forecast has three components: cash inflows, cash outflows, and the resulting net position by period.
Cash inflows are built from the specific sources of cash you expect to receive, not from accrued revenue. For a project-based business, this means listing each project or client and estimating the payment dates for each milestone or invoice. Not the invoice date. The payment date, based on contractual terms and historical payment behaviour from that client. A client with 60-day terms who consistently pays on day 75 should be forecast at day 75. Optimism in cash forecasting is expensive.
For a seasonal business, inflows are built from the historical seasonal pattern applied to current-year revenue expectations, adjusted for any known changes in pricing, volume, or client mix.
Cash outflows are easier to build because most of them are known in advance. Payroll runs on a fixed date. Rent and lease payments are contractual. Social contributions (AHV, IV, ALV, and BVG) have fixed quarterly or monthly payment dates. Supplier payments follow either contractual terms or historical payment practice. Loan repayments and interest are scheduled. The variable outflows, discretionary spending, project-specific costs, are harder but can be estimated from the project plan.
The resulting balance is calculated period by period: opening cash plus inflows minus outflows equals closing cash. The closing cash of one period is the opening cash of the next. The forecast shows the trajectory of the cash balance across the projection period, and specifically it shows whether and when the balance approaches a minimum threshold that management has defined.
That minimum threshold is critical. A cash balance of CHF 50K is not inherently dangerous or safe. It is dangerous if CHF 80K of outflows are due in the next two weeks. It is safe if the next major outflow is 45 days away and a CHF 200K client payment is expected in week two. The cash forecast makes this context visible. The bank balance alone does not.
The 13-Week Rolling Forecast
The 13-week rolling forecast is the standard for businesses with meaningful cash risk, and it is what banks and boards ask to see when they want evidence that liquidity is being managed.
The logic is simple: 13 weeks is approximately one quarter, which is long enough to identify problems before they become crises and short enough that the assumptions can be estimated with reasonable precision. A 12-month annual forecast for a project-based business is largely fiction beyond the first quarter. A 13-week forecast, updated weekly, is actionable intelligence.
The rolling aspect means that every week, the forecast extends by one week: last week drops off as actuals, a new week 13 is added. The result is a forecast that always covers the same horizon, always reflects the latest known information, and never becomes stale through the passage of time.
Building the 13-week forecast in Excel requires three tabs: a data input tab where cash inflows and outflows are entered by week and category, a summary tab that aggregates to a weekly cash position, and an actuals comparison tab that tracks the variance between forecast and actual week by week.
The variance tracking is not optional. It is the mechanism that improves forecast accuracy over time. If your inflows are consistently 15 percent below forecast, that is a systematic bias you need to understand and correct. If outflows are accurate but inflows are volatile, you have a collections problem, not a forecasting problem. The variance history tells you which.
Update discipline: The forecast should be updated once a week, on the same day, by the same person. The update does not require rebuilding the model. It requires confirming that known inflows are still expected as forecast, adjusting anything that has changed, and adding the new week 13 layer. For most businesses, this takes 30 to 60 minutes. The cost of not doing it weekly is two weeks of blindness when something shifts.
Project-Based Businesses: The Specific Challenge
For project-based businesses, the primary source of cash flow uncertainty is not cost. It is revenue timing. Projects slip, milestones get disputed, client payment processes move slowly, and the gap between work delivered and cash received can be substantial.
The discipline that reduces this risk most effectively is not forecasting methodology. It is contract structure. Milestone-based payment schedules, advance payments for significant project phases, and explicit late payment penalties all reduce cash flow uncertainty at the source. A controller who understands this should be raising these issues in the commercial discussion, not just modelling the consequences after the contract is signed.
For the forecast itself, project-based businesses should maintain a project cash flow register alongside the 13-week model: a list of all active projects, with the expected payment milestone dates and amounts for each one. The register is updated as projects progress, and the updated payment dates feed directly into the weekly forecast. When a milestone slips, the impact on the cash position is visible immediately, not two weeks later when the expected payment fails to arrive.
The register also makes the CFO or controller conversation with the CEO much more concrete. Rather than a general discussion about cash being tight, the conversation is about specific projects, specific milestones, and specific expected dates. That specificity is what produces decisions, not generalities.
Seasonal Businesses: Planning Around the Pattern
Seasonal businesses have the opposite problem from project-based firms. The timing of cash is predictable, but the magnitude is variable. A ski resort, a summer tourism operator, or a Swiss retailer with strong Christmas trading knows when cash will flow but not exactly how much.
The forecasting approach for seasonal businesses starts with the seasonal profile from historical data: what percentage of annual revenue and cash inflows lands in each month, based on the last three to five years. This profile is applied to the current-year revenue expectation to produce the base case monthly cash forecast.
The critical addition for seasonal businesses is the cash buffer: the cash reserve that needs to be in place at the start of the low season to cover operating costs until the high season cash arrives. This buffer should be calculated explicitly, from the seasonal cash flow model, not estimated intuitively. The calculation shows the lowest point the cash balance will reach during the off-season, and that lowest point, plus a safety margin, is the buffer the business needs to carry into the off-season.
For seasonal businesses that use credit lines to bridge the seasonal cash trough, the forecast determines exactly when the line needs to be drawn down and when it can be repaid. Banks lending to seasonal businesses understand this pattern. A well-prepared seasonal cash forecast, presented proactively before the low-season period begins, is the kind of financial management that builds banking relationships and makes credit renewals straightforward.
Building the Cash Buffer: The Structural Discipline
Whatever forecasting approach you use, the business needs to define a minimum cash position that it will not allow itself to fall below, and treat that number as a hard constraint rather than a guideline.
The minimum cash position should cover at minimum two to four weeks of fixed operating costs: payroll, rent, lease payments, and social contributions. For businesses with significant client concentration or project revenue risk, the minimum should be higher.
The buffer is not idle cash. It is the operational reserve that means a late client payment or a project delay does not immediately create a payroll problem. Its size should be set deliberately, documented, and reviewed at least once a year as the cost base changes.
When the cash forecast shows the balance approaching the minimum threshold, that is an automatic trigger for a specific set of actions: accelerating collections on overdue invoices, drawing on available credit facilities, or initiating a conversation about adjusted payment terms with a major supplier. The threshold triggers the action. Without the threshold, the action gets triggered by panic when the balance is already below the minimum.
What to Tell the Bank
If your business faces regular cash flow uncertainty, the bank should know about it before it becomes a problem, not when you need emergency help. A controller who maintains a 13-week cash forecast and shares a regular summary with the relationship manager at the bank is doing exactly what banks want to see.
Banks are not uncomfortable with seasonal cash patterns or project-driven timing gaps. They are uncomfortable with surprises and with borrowers who appear not to understand their own cash position. A well-prepared cash forecast, presented proactively, is one of the most effective tools for maintaining a productive banking relationship and ensuring that when credit is needed, the conversation is fast and the answer is yes.
Struggling with cash visibility? Book a free 30-minute call to discuss your situation.
Alessandro Ratzenberger is a fractional CFO and business controller based in Zurich, with 15 years of operational finance experience at Dufry Group and Bomi (UPS Group).
