Insights / blog post

How to Build a Cash Flow Forecast for the Next 90 Days

Share on social media

Most business owners find out they have a cash flow problem when it is already a crisis. Revenue looks healthy on paper, invoices are outstanding, and then payroll week arrives and the account does not have what it needs. The problem is rarely a shortage of income. It is a failure to anticipate when that income will actually arrive and when obligations will fall due.

A 90-day cash flow forecast solves this. It gives you a forward-looking view of exactly what is coming in, what is going out, and when, so that gaps are visible weeks before they become emergencies. It does not require an accounting background to build. It requires accurate records, a structured approach, and the discipline to keep it current.

Here is how to build one.

Step One: Establish Your Starting Position

Before projecting forward, you need a clear picture of where you stand today. Pull your current bank balances across all business accounts. This is your opening cash position and the foundation everything else is built on.

If your accounts are not reconciled and your current balance is unclear, that is the first problem to address. A forecast built on an inaccurate starting figure will produce inaccurate projections regardless of how carefully everything else is done.

Step Two: Map Your Expected Cash Inflows

Work through every source of income you expect to receive over the next 90 days and assign each one a specific date or date range. This is not a list of invoices you have sent. It is a realistic estimate of when those invoices will be paid.

Sources to account for include:

  • Outstanding invoices and their expected payment dates, based on your clients' actual payment patterns rather than your payment terms

  • Confirmed orders or signed agreements not yet invoiced

  • Recurring revenue from retainer clients or subscription arrangements

  • Any other confirmed income, including loan disbursements, grant tranches, or investment draws

Be conservative. If a client habitually pays 15 days after your 30-day terms, reflect that reality in your forecast rather than assuming they will pay on time. Optimistic inflow projections are the most common reason cash flow forecasts fail to prevent the problems they are designed to catch.

Step Three: Map Your Expected Cash Outflows

List every payment obligation your business has over the next 90 days and assign each one its due date. Do not approximate. Use actual figures from your supplier agreements, loan statements, lease documents, and payroll records.

Outflows to include:

  • Staff salaries and contractor payments

  • Rent, utilities, and recurring operational costs

  • Supplier and inventory payments

  • Loan repayments and interest obligations

  • Tax payments, including any installment obligations due within the period

  • Subscriptions, software licenses, and any other fixed monthly costs

  • Any planned capital expenditure or one-off payments expected in the period

If an expense is variable, use a realistic average based on recent months rather than a best-case figure.

Step Four: Calculate Your Weekly or Bi-Weekly Net Position

With your inflows and outflows mapped by date, calculate your running cash balance across the 90-day period. The simplest method is a week-by-week or bi-weekly view: opening balance, plus inflows for the period, minus outflows for the period, equals closing balance. That closing balance becomes the opening balance for the next period.

What you are looking for are the weeks where the closing balance drops below a level your business can comfortably operate at, or worse, turns negative. These are your cash flow gaps, and identifying them in advance is the entire point of the exercise.

Step Five: Address the Gaps Before They Arrive

A gap identified three to six weeks in advance is a planning problem. The same gap identified three days in advance is a crisis. The difference is what you can do about it.

When your forecast reveals a shortfall, your options include:

  • Accelerating collections by following up on outstanding invoices ahead of schedule or offering early payment incentives

  • Negotiating extended payment terms with suppliers to push outflows past the gap period

  • Drawing on a line of credit or short-term facility specifically to bridge the period

  • Deferring non-essential expenditure until cash position recovers

  • Pursuing a funding option that can be accessed within the relevant timeframe

The earlier you identify the gap, the more options you have and the less disruption the solution requires.

Keeping the Forecast Current

A 90-day cash flow forecast is not a document you build once and file. It is a working tool that needs to be updated as invoices are paid, new orders come in, and expenses are confirmed. A forecast that has not been reviewed in three weeks is no longer telling you anything useful.

The accuracy of your forecast is entirely dependent on the accuracy of your underlying financial records. Businesses whose books are current and well-organized can build and maintain a reliable forecast with significantly less effort than those working with disorganized or outdated records.

TryBookkeeping keeps your financial records accurate and up to date at all times, giving you the clean data your forecast depends on to be genuinely useful rather than a best guess.

Start Your Free 14-Day Trial of TryBookkeeping

If you would like support building a financial picture that positions your business for funding or operational stability, Grovane's team is available to help. Book a free discovery call with us to get started.