November 17, 2026

13-Week Cash Flow Forecast - How to Build One Step by Step

13-Week Cash Flow Forecast - How to Build One Step by Step

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.

What is a 13-week cash flow forecast?

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:

  • Opening cash balance - the amount of available cash at the beginning of the week.
  • Expected cash inflows - the money the business realistically expects to receive.
  • Expected cash outflows - the payments scheduled to be made.
  • Closing cash balance - the cash expected to remain after inflows and outflows.

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.

How is a cash flow forecast different from a cash flow statement?

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.

Key takeaway

A 13-week cash flow forecast is based on when money is actually expected to enter or leave the business. An invoice issued on Monday with a 30-day payment term does not automatically increase cash in the first week. It should appear in the week when the business realistically expects to receive payment.

How to prepare a 13-week cash flow forecast: five steps

Step 1. Establish the actual opening cash balance

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:

  • PLN 95,000 in its main operating account.
  • PLN 25,000 in a second account, available for business use.
  • An unused credit facility of PLN 50,000.

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.

Step 2. Allocate expected cash inflows to specific weeks

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.

Step 3. Organise cash outflows by payment date

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.

Step 4. Calculate the closing cash balance for each week

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.

Weekly closing cash balance formula

Closing cash balance = opening cash balance + cash inflows - cash outflows

The previous week's closing balance becomes the following week's opening balance. All amounts should be calculated consistently on a cash basis.

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.

Step 5. Compare the balance with a minimum cash reserve

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.

13-week cash flow forecast example - a complete weekly table

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.

Week Opening cash balance Cash inflows Cash outflows Closing cash balance
11208075125
212590100115
31157013550
4501109070
570808070
6709510560
7601009565
8659011045
94511510060
1060959065
116510510070
12701009575
137512010590

All figures are in PLN '000. For example, 120 represents PLN 120,000.

‍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.

Largest shortfall against the cash reserve: PLN 35,000

In week eight, the forecast cash balance falls to PLN 45,000. With a minimum cash reserve of PLN 80,000, the difference is PLN 35,000. This is a potential need to restore the cash buffer, not automatically the amount the company should borrow.

Why isn't it enough to look at the balance after 13 weeks?

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.

What happens if a customer delays payment by two weeks?

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.

Week Original closing balance Closing balance after the delay
7 PLN 65,000 PLN 65,000
8 PLN 45,000 -PLN 5,000
9 PLN 60,000 PLN 10,000
10 PLN 65,000 PLN 65,000

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:

  • PLN 5,000 - the forecast deficit relative to a zero cash balance.
  • PLN 85,000 - the amount required to maintain the assumed minimum cash reserve at the end of week eight.

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.

How should you update a 13-week cash flow forecast every week?

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:

  1. Close the completed week using actual bank transactions.
  1. Compare forecast and actual cash inflows and outflows.
  1. Investigate the most significant differences, particularly delayed payments and unplanned expenses.
  1. Update the expected amounts and dates of future inflows and outflows.
  1. Add another week to the end of the schedule so the forecast continues to cover 13 weeks.

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.

Why compare the forecast with actual results?

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.

Common mistakes in a 13-week cash flow forecast

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.

Recording revenue instead of actual cash receipts

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.

Overly optimistic customer payment dates

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.

Leaving out taxes and irregular expenses

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.

Failing to set a minimum cash buffer

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.

Not updating the forecast

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.

How can a cash flow forecast help assess financing needs?

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.

Can PaveNow help finance a cash flow gap?

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.

Checklist - is your cash flow forecast complete?

CASH FLOW PLANNING

13-week cash flow forecast checklist

Data and forecast

  • Have I established the actual opening available cash balance?
  • Does the forecast cover the full 13 weeks?
  • Have I allocated cash inflows to realistic payment weeks?
  • Have I included regular, irregular and tax-related expenses?
  • Have I distinguished available cash from unused credit facilities?
  • Does each week's closing balance become the following week's opening balance?

Monitoring and decisions

  • Have I established a minimum available cash threshold?
  • Do I know which week has the lowest forecast cash balance?
  • Have I tested a scenario involving a delayed major payment?
  • Do I compare the forecast with actual transactions?
  • Do I update the model weekly and add another week?
  • Can I identify the amount, timing and repayment source of any required financing?

Summary - 13 weeks can reveal more than your bank balance

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.

BUSINESS FINANCING

Explore financing options for your business

Does your cash flow forecast indicate a need for additional capital? Explore business growth financing options and review the available solutions.

Explore financing options →

Frequently asked questions about 13-week cash flow forecasts

What is a 13-week cash flow forecast?

It is a short-term model of expected cash inflows, outflows and balances for each of the next 13 weeks. It helps identify periods of potential cash shortages and plan corrective action in advance.

How do you calculate the cash balance in a cash flow forecast?

Add expected cash inflows to the opening cash balance and subtract planned cash outflows. The result is the week's closing cash balance, which becomes the opening balance for the following period.

Why does the forecast cover 13 weeks?

Thirteen weeks cover 91 days, approximately one quarter. This allows businesses to account for both regular and irregular payments while maintaining a detailed weekly view of cash movements.

Can you prepare a 13-week cash flow forecast in Excel?

Yes. A basic forecast can be prepared in a spreadsheet such as Microsoft Excel or Google Sheets. Accurate input data, realistic payment dates and regular updates are more important than using a complex financial system.

How often should a 13-week cash flow forecast be updated?

Ideally, every week. After each completed week, compare the forecast with actual transactions, update future cash inflows and outflows, and add a new week to the end of the model.

Does a positive cash balance mean a business has no liquidity problems?

Not always. A cash balance may be positive but still fall below the reserve needed to operate safely. It is important to compare the forecast with the company's minimum cash threshold and consider payment timing within individual weeks.

How should a delayed invoice be reflected in a cash flow forecast?

Move the expected receipt to the week when the business realistically expects payment, then recalculate all subsequent balances. It is also worth testing a further delay and assessing the effect on the minimum cash reserve.

Can a cash flow forecast show how much a business needs to borrow?

It can help estimate the amount and timing of a potential cash shortage, but it does not automatically determine the appropriate loan amount. Available cash, minimum reserves, options for adjusting cash flows and a realistic repayment source must also be considered.