Cash Flow Forecast: Build a Practical 13-Week Plan

A 13-week cash flow projection is one of the most valuable forecasts for any business to perform. It does not provide strategic planning on a long-term basis. Instead, it is a short yet practical look at the funds that are about to come or go out of your account in the next three months, week-by-week. 13 weeks is a good compromise – it gives you enough time to identify potential issues, yet keeps all of the numbers feasible.

Most of the companies that end up with cash flow problems do not face difficulties for an entire year but only a few critical weeks.

What inputs belong in a cash flow forecast?

Don’t complicate things, and keep it practical by considering actual cash flows. The framework always remains the same as follows:

• Opening cash balance (cash that is there in the bank at the beginning of the week)
• Cash inflows (expected cash flow)
• Cash outflows (expected cash flow)
• Closing cash balance (opening + inflows – outflows)

The major inputs will always be as follows:

 

Inflows

• Customer receipts from outstanding invoices
• New sales that will be paid within the period
• Loan drawdowns or equity injections
• Tax refunds or other one-off receipts

Outflows

• Payroll and related taxes
• Supplier and vendor payments
• Rent, utilities, and regular bills
• Loan repayments and interest
• Tax payments
• Owner draws or dividends
• Any known one-off costs

Use the direct method — actual cash in and cash out. Do not start from profit and try to adjust. That approach hides the timing problems you are trying to see.

A useful rule many teams follow: if it does not move the bank balance, it does not belong in the main forecast. Accruals and non-cash items can live in a separate note if needed.

How do you estimate weekly customer receipts?

This is usually the hardest and most important part. Start with what you already know and get more conservative the further out you go.

1. Pull the current accounts receivable aging report.
2. List every open invoice with its due date.
3. Adjust for real payment behaviour. If a customer almost always pays 10–15 days late, put the receipt 10–15 days after the due date, not on it.
4. For the first 2–3 weeks, be specific: name the customer, the invoice, and the expected week.
5. For weeks 4–13, use percentages based on history. Example: 70% of the 1–30 day bucket usually comes in within the next two weeks, 40% of the 31–60 day bucket, and so on.

New sales that have not been invoiced yet should be treated carefully. Only include them if you have a strong reason to believe the cash will arrive inside the 13 weeks. Many teams keep a separate “pipeline” line and only move amounts into the main forecast once an invoice is issued or a deposit is confirmed.

The worst mistake is over-confidence. It is always better to under-estimate revenues and be pleasantly surprised than to assume revenues that do not materialize.

How do you schedule payroll, bills, and debt payments?

These are usually the most reliable lines, so give them your attention.

• Payroll: List the specific dates and gross payroll amounts (along with the taxes and benefits paid through the payroll process).
• Payable regular bills: Rent, software subscriptions, insurance, utilities, all based on their specific due dates.
• Supplier payments: Begin with the payable invoices and their due dates. Next, determine how much you actually pay to each supplier on a weekly basis, depending on the amount of available cash and the relative importance of the supplier.
• Debt repayments: Repayment of principal and payment of interest according to the actual due dates. Don’t miss them.
• Taxes: Payroll tax deposits, VAT/GST, tax installment payments – often arrive in large chunks.

Tip: Prepare two lists per week – one of ‘must-pay’ lines (payroll, important suppliers, debts, taxes), and one of ‘flexible’ lines. In times of cash shortage, the ‘must-pay’ items are retained, while the others are reduced.

How do opening and closing cash balances connect?

This is the spine of the whole forecast.

Week 1 opening balance = today’s actual bank balance (or the balance you expect at the start of the first forecast week).
Week 1 closing balance = Week 1 opening + Week 1 inflows – Week 1 outflows.
Week 2 opening balance = Week 1 closing balance.
And so on through Week 13.

The end of balance from one week becomes the starting point of balance for the next. It is this one simple connection that transforms a mere series of numbers into a running record of your cash runway.

Another parameter used by many companies is the cash floor. The cash floor is the minimum level of balance that a company will be comfortable working with. When the forecast indicates a balance that falls below this level, action must be taken immediately.

How do scenarios and weekly updates improve the forecast?

A static forecast loses value quickly. The power comes from two habits: updating it every week and running simple scenarios.

Weekly update rhythm

• Bring in last week’s actual receipts and payments.
• Compare forecast versus actual and note the biggest differences.
• Roll the model forward so the old Week 2 becomes the new Week 1, and a new Week 13 appears.
• Adjust the forward weeks based on what you learned.

This process usually takes 30–60 minutes once the model is set up. The goal is not perfection. It is to keep the picture current.

Simple scenarios
You do not need complicated models. Three versions are often enough:

• Base case (your best realistic view)
• Delayed collections (what if key customers pay 10–14 days later)
• Higher costs or slower sales (what if a big cost hits early or a expected receipt slips)

Looking at the same 13 weeks under different assumptions quickly shows where the business is most exposed and how much buffer you really need.

Accuracy improves with practice. Many teams aim for roughly ±5–10% on the near weeks and accept wider ranges further out. What matters most is that the forecast is updated, compared to reality, and used to make decisions.

Putting the 13-week plan to work

Start simple. Open a spreadsheet, put the next 13 weeks across the top, and list the main cash categories down the side. Fill in what you know. Update it every week. After a month you will already see patterns that were invisible before.

The 13-week cash flow forecast is not glamorous. It is practical. It turns “I think we should be okay” into “here is exactly which weeks look tight and what we can do about them.” That clarity is usually worth far more than the time it takes to maintain.

5 Practical FAQs on Cash Flow Forecasts

1. Why 13 weeks and not a full year or just one month?
   Thirteen weeks covers roughly one quarter. A monthly view hides the week-to-week timing problems that actually create cash crunches. A full-year forecast is useful for planning but becomes too uncertain for day-to-day decisions. Thirteen weeks is long enough to see trouble coming and short enough that the numbers stay realistic.
2. How accurate does the forecast need to be?
   Near weeks (1–3) should be reasonably tight — many teams aim for within 5–10% on total cash movement. Further weeks can be more directional. What matters most is that you update it every week and learn from the differences between forecast and actual. Perfect accuracy is not the goal; early visibility is.
3. Should I capture all the little payments or should it be high level?

First capture the large items impacting the cash flow: payroll, key vendors, key customer receipts, rent, taxes and debt repayments. You can then drill down later if needed. A simple model which gets updated each week is much more valuable than a complex one which does not get maintained.

4. What is the common mistake people do when developing 13 weeks forecasts?

Being overly optimistic about customer receipts. Putting the money in the week where the invoice is due and not in the week you get paid is by far the most frequent mistake. Use historical information and not the term of the invoice. Second mistake would be to prepare it once and then never update it.

5. How long does it take to build and maintain one?

Preparation of the first forecast generally takes a few hours if you have some clean receivable and payable information. Maintenance of the forecast after that generally takes 30-60 minutes per week.

 

Conclusion

An example of an analysis would be the creation of a cash flow forecast for 13 weeks. It would be simply a projection of cash coming in and out each week during the upcoming quarter. The numbers need to be realistic, with the revenues based on customer behaviour, and the expenses carefully scheduled. Running two or three different scenarios during tough times is enough. It will provide visibility instead of uncertainty.