AHM Jamal Subscribe

Insights · Treasury

The 13-Week Cash Flow Forecast: A Practical Guide for Real Estate and Project Businesses

By AHM Jamal, FMVA® · · 2 min read

Profit does not pay salaries. Cash does.

A business can look strong on paper and still run short of cash next month. This happens often in project and real estate businesses, where money comes in lumps and goes out in lumps.

The simplest tool I know for this is the 13-week cash flow forecast.

What it is

A week-by-week view of cash coming in and going out for the next 13 weeks, which is one quarter. You update it every week and roll it forward.

It is not a budget. A budget says what you plan. The 13-week forecast says what your bank balance will actually be.

How to build it

  1. Start with the opening bank balance. Use the real figure from the bank, not the ledger.
  2. List the cash coming in. Collections from customers, instalments due, loans drawn, other receipts. Use expected dates, not invoice dates.
  3. List the cash going out. Payroll, supplier and contractor payments, taxes and duties, loan repayments, rent and utilities, project costs.
  4. Calculate the weekly net cash and the closing balance. The closing balance of one week is the opening balance of the next.
  5. Mark the minimum cash you must always hold. Any week below that line needs action.

Three rules that make it work

  • Be honest about collections. Count a receipt when you expect the money, not when the customer promised. Late collections are the main reason forecasts fail.
  • Put fixed dates first. Salaries, taxes and loan instalments cannot move. Show them clearly.
  • Update every week. Replace the forecast with actuals, then add a new week. A forecast that is not updated becomes a story.

What to do when a gap appears

If a week shows cash below your minimum, you have options. The earlier you see it, the cheaper they are.

  • Speed up collections or agree dates with key customers
  • Re-sequence non-urgent payments
  • Arrange short-term funding before you need it
  • Delay discretionary spending

Common mistakes

  • Mixing profit with cash
  • Forgetting taxes and one-off payments
  • Using one rosy scenario. Keep a base case and a cautious case.
  • Keeping the forecast with one person only

A simple start

You do not need special software. A spreadsheet with weeks across the top and cash lines down the side is enough. Build it once, review it weekly with your team, and let it guide your decisions.

Good treasury is not about clever tools. It is about seeing cash early, while you still have choices.


If this is useful, subscribe to the newsletter below for more practical notes on finance, treasury and AI.

Keep reading

Get practical AI-and-finance ideas in your inbox.

Short, useful notes on FP&A, cash flow, ERP, BI and AI for finance leaders. No spam. Unsubscribe any time.