
A company has PLN 120,000 in its bank accounts. Over the next month, it expects further payments from customers, but it also needs to pay suppliers, cover payroll and settle its tax obligations.
At first glance, the financial position looks stable. The business has cash available, continues generating sales and expects more payments to arrive.
The problem becomes visible only when all expected cash inflows and outflows are allocated to specific weeks. The forecast reveals that cash will fall sharply in the third week and, several weeks later, may drop below the company's minimum safety threshold.
This is exactly what a 13-week cash flow forecast helps identify: not just how much money a business expects to receive and spend, but, more importantly, when those cash movements will occur.
You do not need an advanced financial management system to get started. For many businesses, a well-structured spreadsheet, up-to-date payment information and consistent weekly updates are enough.
This guide explains how to build the model, calculate cash balances for the next 13 weeks and determine whether additional financing may be needed.
A 13-week cash flow forecast is a short-term financial plan showing expected cash inflows, outflows and balances for each of the next 13 weeks.
It covers 91 days, approximately one quarter.
The forecast is typically prepared using the direct method, based on expected actual cash receipts and payments rather than accounting revenue and expenses.
Each week, the business determines four key figures:
The closing balance of one week becomes the opening balance of the next.
This allows business owners to see not only the expected result for the entire quarter, but also the point at which available cash may reach its lowest level.
A cash flow statement is part of financial reporting and presents cash movements over a historical reporting period.
A cash flow forecast, by contrast, looks ahead. It uses expected dates of actual payments, which may differ from the dates when revenue or expenses are recognised in the accounting records.
An issued invoice is therefore not yet a cash inflow, just as a purchase made on deferred payment terms does not necessarily result in an immediate cash outflow.
If you would like to understand the difference between accounting profit and available cash first, read Cash Flow vs Profit - Why Your Business Looks Profitable on Paper but Has No Cash.
Start with the amount of cash the business can actually use at the beginning of the forecast.
If the company operates several bank accounts, their available balances can be included. However, cash must be distinguished from approved but unused credit facilities and funds that are restricted or earmarked for a specific purpose.
For example, a company has:
The opening available cash balance is PLN 120,000, not PLN 170,000.
The credit facility is a potential source of financing, but it should not be treated as cash the business already holds.
Next, prepare a schedule of the money the business expects to receive over the next 13 weeks.
The most important sources of information include issued invoices, payment schedules, customer contracts and expected receipts from ongoing sales.
Do not automatically allocate all receivables according to their invoice due dates. If a customer regularly pays late, the forecast should reflect the realistic date on which payment is likely to arrive.
It is also worth distinguishing confirmed inflows from estimates. An approved invoice issued to a reliable customer should not be treated in the same way as sales that have not yet taken place.
We explain the effect of payment terms on a company's capital in more detail in our DSO guide. A 13-week forecast goes one step further by allocating specific amounts to the weeks in which they are expected to reach the bank account.
On the outflow side, the forecast should include not only operating costs but all expected cash payments within its scope.
These may include supplier payments, payroll, taxes, Polish social security contributions (ZUS), rent, loan repayments, advance payments for materials and capital expenditure.
The most important consideration is the expected date on which cash will leave the business.
For example, purchasing materials worth PLN 80,000 does not necessarily reduce cash on the delivery date. If payment is due three weeks later, that is when the outflow should be recorded in the forecast.
Do not automatically spread all expenses evenly across the 13 weeks. Payroll, taxes and major purchases can cause significant fluctuations in cash balances.
Once you know the opening balance, expected inflows and planned outflows, you can calculate the cash expected to remain at the end of each week.
If the opening cash balance is PLN 120,000, expected inflows are PLN 80,000 and outflows are PLN 75,000, the calculation is:
PLN 120,000 + PLN 80,000 - PLN 75,000 = PLN 125,000
The company will start the second week with a forecast balance of PLN 125,000, provided all expected cash movements occur as planned.
A positive closing cash balance does not always mean that the business is in a comfortable position.
The company may need to maintain a certain cash reserve to continue operating and withstand delayed customer payments.
Suppose management sets a minimum available cash threshold of PLN 80,000.
If the forecast shows a closing balance of PLN 45,000, the company is not yet forecasting a negative cash balance, but it is PLN 35,000 below its own minimum cash reserve.
This is an early signal to plan corrective action before an actual cash shortage makes it difficult to meet obligations.
The minimum reserve should be based on the company's real operating requirements. The PLN 80,000 figure is only an assumption used in our example.
Let's return to the company starting with PLN 120,000 in available cash.
The business has prepared a schedule of expected customer payments and cash outflows for the next 13 weeks.
For readability, all figures in the table are expressed in thousands of Polish zloty (PLN '000). They are illustrative figures, not a forecast for an actual company.
What does the forecast tell us?
The company begins the period with PLN 120,000 in cash. After 13 weeks, its forecast closing balance is PLN 90,000.
If the business owner only compared the beginning and end of the period, they might conclude that the company would maintain sufficient liquidity.
However, the weekly forecast reveals much more.
In week three, the balance falls to PLN 50,000. It remains below the assumed PLN 80,000 minimum cash reserve over the following weeks, and the lowest forecast cash balance occurs in week eight, at PLN 45,000.
This is the most important finding from the calculation.
The company does not forecast a negative cash balance, but it operates below its own minimum safety threshold for much of the period.
The final balance does not reveal every problem that may occur along the way.
A business may have sufficient cash at the end of a quarter while struggling to pay its obligations several weeks earlier.
This is why short-term cash flow forecasts should be broken down by week rather than relying solely on a single monthly or quarterly balance.
In our example, the most important decision concerns the earlier drop in cash, not the balance in week thirteen, and how the company intends to cover its upcoming payments.
Now suppose the company expects a PLN 50,000 payment from a customer in week eight.
However, the customer informs the business that the transfer will not arrive until week ten.
We assume that all other inflows and outflows remain unchanged.
The forecast therefore needs to be updated.
In this scenario, the business receives PLN 50,000 later than expected, so its projected closing balance in week eight falls from PLN 45,000 to -PLN 5,000.
Without corrective action, the forecast therefore indicates a cash deficit of PLN 5,000 at the end of that week.
However, if the company also wants to maintain its PLN 80,000 minimum cash reserve, the shortfall against that threshold increases to PLN 85,000.
These are two different figures and should not be confused:
Only in week ten, once the delayed customer payment arrives, does the forecast balance return to the original plan.
This scenario shows how even a relatively modest delay in one payment can significantly affect a company's short-term financial position.
It is not enough to know that a customer will eventually pay. The company must also determine whether it can meet all its obligations before that payment arrives.
A 13-week cash flow forecast should not be a one-off document that the business revisits only three months later.
Its greatest value comes from regular updates.
At the end of each week, the company should compare expected cash movements with actual transactions, then extend the forecast by another week. This approach is known as a rolling forecast.
In practice, the process involves five steps:
Simply moving a delayed invoice into the next column is not enough. The business must also check how the delay affects the lowest forecast cash balance and whether protective action is required.
Suppose the company expected PLN 100,000 in customer payments during a particular week but received only PLN 70,000.
The difference is PLN 30,000.
It should not be explained away simply by saying that customers will pay later.
The business should establish whether the missing PLN 30,000 relates to one delayed invoice, a revised payment date, a customer dispute or overly optimistic sales assumptions.
This allows the company to improve future forecasts instead of repeating the same mistakes.
For more information about other financial indicators worth checking regularly, read Weekly Financial Analysis for Businesses - 7 Signals Worth Monitoring.
Even a correctly structured spreadsheet can lead to poor decisions if its underlying assumptions are unreliable.
The most common problems relate not to the formula itself, but to the data used.
A company may issue an invoice for PLN 100,000 but receive payment only after 60 days.
If that amount is entered into the forecast in the week the invoice is issued, the model will show cash that the company does not yet have.
Contractual payment terms are an important reference point, but they do not always reflect how customers actually pay.
The forecast should account for the likely dates of receiving payment, not just contractual due dates.
A business owner may carefully plan payroll and supplier payments while overlooking a significant tax liability, insurance premium or capital expenditure.
This is particularly dangerous when several major payments fall due during the same week.
Without a defined minimum cash reserve, it is difficult to determine whether a projected balance of PLN 30,000 is sufficient.
For one company, that amount may cover several weeks of operations. For another, it may not even cover a single day of typical payments.
A spreadsheet prepared a month ago will no longer reflect the current situation if customer payment dates, orders or expenses have changed.
A 13-week cash flow forecast should support decisions based on current information, not preserve assumptions that have already become outdated.
The most important result of a forecast is not always the closing balance in week thirteen.
What may matter much more is the lowest forecast cash balance and when it is expected to occur.
In our base case, the company needed an additional PLN 35,000 to maintain its assumed cash buffer during the most difficult week.
After a customer payment was delayed, the shortfall against that buffer increased to PLN 85,000.
However, this still does not mean that the company should automatically take out an PLN 85,000 loan.
Before making a decision, the business should determine whether it can reduce the shortfall by collecting receivables earlier, adjusting the timing of expenses, using available reserves or taking other justified measures.
If external financing is required, the timing of the gap, how long it is expected to last and the realistic source of repayment will also matter.
Financing should address a specific cash flow need, rather than being taken out simply because the forecast shows a lower cash balance.
PaveNow offers financing solutions for businesses, including growth financing and financing for specific receivables and contracts.
The appropriate option depends on the cause of the capital requirement, when the company expects cash to arrive and whether it has a realistic source of repayment.
For example, if the problem is waiting for payment on an issued B2B invoice, receivables financing may be worth considering. If the business needs additional funds to expand operations, growth financing may be more appropriate.
Preparing a cash flow forecast does not guarantee financing approval. However, it helps define the purpose of financing, the amount that can be justified and the expected period for which the funds will be needed.
More information about one of the available solutions can be found on the PaveNow Growth Loan for Businesses page.
A 13-week cash flow forecast helps a business understand how its available cash may change over the coming months.
Preparing one does not necessarily require an elaborate financial model. The most important elements are up-to-date data, realistic payment dates and correctly carrying cash balances forward from week to week.
In our example, the company started with PLN 120,000 in available cash and had a forecast closing balance of PLN 90,000 after 13 weeks.
However, the lowest balance occurred in week eight, at PLN 45,000. Against a required cash reserve of PLN 80,000, this represented a PLN 35,000 shortfall.
After accounting for a two-week delay in a customer payment, the forecast closing balance in week eight fell to -PLN 5,000, increasing the shortfall against the reserve to PLN 85,000.
The most important purpose of a cash flow forecast is not to predict the future with perfect accuracy, but to identify periods when a company may need additional cash early enough to take action.
A regularly updated forecast helps businesses make decisions before a short-term cash flow gap begins to affect their ability to meet payment obligations.