What Is a Cash Flow Forecast? How to Project Your Future Balances

You know what is in your account right now. That number is easy. The harder question is what will be there in three weeks, after the rent has gone out, before payday lands, and once that annual car insurance bill you had forgotten about finally hits. Today's balance tells you almost nothing about any of that.

A cash flow forecast fixes the blind spot. It maps the money coming in against the money going out over a future period, then rolls the two together so you can see your balance at every point ahead, not just today's snapshot. Businesses have done this for decades to make sure they can cover payroll and supplier invoices. Far fewer people do it for their own money, even though the question it answers is the one most of us ask in a vague, slightly anxious way every single month. Am I going to be alright until I next get paid?

This guide explains what a cash flow forecast is, how it differs from a cash flow statement, what goes into one, and how to build a simple version yourself. It also covers the part almost nobody writes about, which is how to forecast your own personal balances without spending your evenings babysitting a spreadsheet.

What Is a Cash Flow Forecast?

A cash flow forecast is an estimate of the money coming in and going out over a future period, used to project what your balance will be at each point in time. Instead of a single figure for today, you get a forward view: this is what you will have next week, this is where you land at the end of the month, this is the position three months out. The same forward estimate is sometimes called a cash flow projection, especially in the US and in business, though the personal version is the one this guide is built around.

Both businesses and individuals use them, and the mechanic is identical at either scale. A company forecasts to confirm it can pay staff and suppliers before the money from its own invoices arrives. A household forecasts to confirm the rent will clear, the direct debits will not bounce, and there is something left in reserve before the next salary lands. The word forecast is doing the real work there. It is not a record of what happened. It is an informed estimate of what will happen, assembled from things you already know: your salary, your rent, the subscriptions that leave on the same date every month, the bills that arrive once a year. Feed in more of those known quantities and the picture sharpens. A forecast never promises certainty, but it gives you a credible line to plan against, and it shows you the low points well before you reach them.

Cash Flow Forecast vs Cash Flow Statement (Don't Confuse Them)

These two get muddled constantly, partly because they share most of their name. They are not the same thing, and the difference is worth getting straight before you build either one. A cash flow forecast looks forward. A cash flow statement looks back.

The forecast is an estimate of money you expect to move in the weeks and months ahead, built so you can plan. The statement is a record of money that has already moved, usually pulled together after a period ends for accounts, tax, or a lender who wants to see the history. One helps you decide what to do next. The other documents what already happened. Confuse them and you end up carefully reviewing the past when you meant to be planning the future.

For your personal finances, the forecast is the one that earns its keep day to day. The statement is, in effect, what your banking app already gives you after the event: every transaction listed and categorised, all of it firmly in the past. Useful for a monthly review. No help at all with the question of whether you can afford the dentist next Thursday.

What Goes Into a Cash Flow Forecast

A cash flow forecast has four moving parts. Get these right and everything else is arithmetic that a spreadsheet, or an app, can handle for you.

The part people get wrong is timing. A forecast built on monthly totals alone will cheerfully tell you that you earn more than you spend and everything is fine. Then the 1st arrives, rent and three direct debits all leave on the same grey morning, and you are overdrawn for nine days until payday on the 28th rescues you. On paper the month balanced. In reality you spent a week and a half in the red and paid an arranged-overdraft fee for the privilege.

Totals hide that. Timing reveals it. A forecast worth keeping tracks not only how much money moves but when, so the order of events is visible and you can see the squeeze coming. That is why weekly columns, or even daily ones around a tight stretch, often beat a tidy monthly summary. The resolution matters, because problems tend to happen between the totals rather than in them.

One category deserves a special mention: the irregular costs. Car insurance once a year. The annual subscription that renews quietly on a date you have forgotten. The MOT, the dentist, the cluster of birthdays that all seem to fall in the same expensive month. These are the costs that wreck an otherwise healthy forecast, precisely because they do not show up in a typical month and then they all land at once. Building them in ahead of time is half the reason to forecast at all. Setting money aside for them on purpose, in what is often called a sinking fund, is the other half.

How to Build a Simple Cash Flow Forecast

You do not need accounting software to build one. A notebook works. A spreadsheet works better, because it will do the running total for you and let you change a single number to see what happens. Here is the method, broken into five steps, followed by a worked example you can copy.

1. Pick your period and horizon. Weekly columns usually suit personal finances, because that is the resolution at which problems actually show up. Then decide how far ahead to project. One month is the minimum that tells you anything useful; three to six months catches most of the irregular bills before they bite.
2. Start with your opening balance. Use the real cleared balance in the account today, not the optimistic version that conveniently ignores the payment you know is about to land.
3. List your income by date. Not just £2,300 a month, but £2,300 on the 28th. If you are paid weekly, or irregularly as a freelancer, estimate on the cautious side and anchor each amount to a date you can actually rely on.
4. List your outgoings by date. Every recurring cost on the day it leaves: rent, council tax, utilities, subscriptions, loan repayments, and a sensible average for groceries and fuel. Then drop in the irregular ones, the insurance renewal or the MOT, in the month they fall rather than smearing them evenly across the year.
5. Roll the balance forward. For each period: opening balance, plus income, minus outgoings, gives the closing balance. That closing balance becomes the next period's opening balance, and you repeat the sum to the end of your horizon. The running total down the page is the forecast.

Say you have £900 in your account today. Your take-home pay is £2,300 a month, paid on the 28th. Your regular outgoings, rent and bills and food and transport and a little discretionary spending, come to about £2,225 a month, which leaves you £75 of breathing room in a normal month. Two irregular costs are on the way: car insurance of £680 due in March, and the balance payment on a holiday you have booked, £900, due in May. Here is how the next six months project.

Read down the closing column and the problem jumps out. On a month-by-month-totals basis you are fine, comfortably so, earning £75 more than you spend. But the forecast shows May tipping you £305 into the red, because the holiday payment lands on top of a buffer that March's insurance bill had already thinned out. And you do not climb back to positive in June either.

Here is the thing. You are reading this in January or February, with three or four months' notice, not standing at a card machine in May watching a payment decline. That lead time is the whole point. You could move £80 a month into a separate pot starting now, shift the holiday balance date, trim the discretionary spending for a couple of months, or approach budgeting for the holiday more deliberately so the £900 is already set aside when it falls due. A vague worry has become a specific, fixable number.

That is the entire value of a forecast, sitting in one small table. Not the arithmetic, which a child could do. The early warning. You cannot fix a shortfall you only discover on the day it arrives, and you can almost always fix one you can see coming three months out.

Forecasting Your Personal Finances (The Part Nobody Covers)

Search for cash flow forecast and you will half-drown in business templates. Twelve-month projections for startups, accounting-software demos, spreadsheets built for a limited company applying for a loan. Almost nobody writes about doing this for your own current account, which is odd, because the personal version answers questions that genuinely keep people awake.

Will I go overdrawn before payday? Can I afford to book this now, or should I wait until after the insurance has come out? If I take on £200 a month for a new car, what does my balance actually look like by October? Every one of those is a forecasting question, and a personal cash flow forecast answers it directly, in pounds, on a date. The mechanics are exactly the business ones, with two quirks that happen to work in your favour.

The first quirk is that your income is usually more predictable than a business's. Most people know their payday and their salary to the penny, where a company is forever waiting on customers who pay late. The second is that your recurring costs are remarkably stable month to month, which makes them easy to project forward. Rent does not move. The gym leaves on the 3rd. The streaming bundle on the 14th. Once you have mapped a single typical month, you have effectively mapped most of the year, and you only need to layer the irregular costs on top.

The catch is maintenance. A spreadsheet forecast is brilliant on the day you build it and quietly decaying by the end of the week. Every real transaction drifts from your estimate. The shop was £52, not the £45 you pencilled in. A refund landed. You forgot to log Saturday's takeaway. Within a fortnight the projection and your actual balance have parted ways, and keeping them aligned means re-entering numbers you have already typed once into your banking app. This is the same reason so many budgets quietly fall apart: the admin outlasts the motivation. Most people build one good spreadsheet, use it for a month, and let it gather digital dust.

That is the gap a finance app is built to close. If your transactions already flow in on their own, your recurring bills are already recognised, and the running balance recalculates itself every time something changes, the forecast stops being a chore you maintain and becomes a view you simply open. Which, conveniently, is the only kind of forecast people tend to keep using past week three.

Best, Worst and Expected: Why One Line Isn't Enough

Every forecast is an estimate, and estimates are wrong in both directions. Your grocery spend wanders. A bonus might land, or might not. The boiler holds out for another winter, or it does not. A single projected line marching down the page implies a precision the future simply does not have, and false precision carries its own risk. It tells you that you will close May on exactly £312 when the honest answer is somewhere between comfortable and a genuine problem.

Better forecasts carry a range instead of a single line. Three versions of the same future, run side by side.

• Worst case. Income comes in light, variable spending runs hot, and every irregular cost lands at the worst possible moment. This is your stress test. Survive the worst case and you can stop worrying about the rest.
• Expected case. Your honest middle estimate. Income and spending land roughly where they usually do. This is the line you plan against from day to day, and the one most forecasts show by default.
• Best case. Income holds or beats expectations, the discretionary spending stays reined in, and nothing breaks. This is your upside, and it quietly tells you how much faster you could clear a debt or reach a savings goal if the months go your way.

The space between worst and best is the part worth studying. A narrow gap means a predictable stretch you can plan tightly around. A wide one is a signal in itself: your finances are sensitive to things you do not fully control, and a larger buffer is worth holding until that changes. A single-line forecast hides all of that. A three-line one makes your own financial volatility visible, which is genuinely useful information rather than reassuring noise.

Running three projections by hand, though, is three times the work that almost nobody was doing in the first place. Which is the point where the right tool stops being a nicety and becomes the only realistic way to keep it up.

How Endute Forecasts Your Future Balances

This is where it gets concrete. Endute is a personal finance app, and projecting your future account balances is one of the things it does without being asked. The forecast you would otherwise babysit in a spreadsheet simply maintains itself in the background.

Endute builds your forecast from what it already knows about your money: your scheduled transactions, the income and bills that repeat on a known cadence, and the recurring patterns it recognises in your real spending. You do not assemble a model or maintain a sheet. The projection is already there, drawn from your actual financial life, and it refreshes as new transactions come in rather than waiting for you to sit down and update anything.

And it runs three scenarios, not one. A worst case, an expected case and a best case, charted together so you see the range rather than a single fragile line. We work the spread out for you, so you are not left guessing what a sensible margin looks like. The expected line is what you plan against. The worst case is your early warning. The distance between the two tells you, at a glance, how much slack to keep in reserve.

You set the horizon to match the question you are actually asking. One month to check you will clear payday without drama. Three or six months to see an annual bill coming while there is still time to prepare for it. A full year for the bigger shape of things. And you can point the forecast at a single account, the current account you are watching like a hawk this month, or at all of them combined for your whole position at once. You also choose whether to project from your scheduled transactions only, or to fold in the recurring patterns Endute has detected, depending on how cautious or how complete you want the view to be.

One thing worth being plain about: this is forecasting for your personal finances, your own account balances, not business cash-flow accounting. Endute is not bookkeeping software and it will not produce your company's management accounts. It answers the personal question, what will my balance be and where does it dip, rather than the corporate one. If you have landed here looking for a forecast to put in front of a bank manager or an investor, this is the wrong tool, honestly told.

The forecast is also more trustworthy because it does not sit on its own. The same app holds your budgeting, your net worth, your investments and your scheduled payments, so the numbers feeding the projection are the same numbers running everything else, not a separate set you have to keep in sync. Endute connects to real bank accounts through open banking where that is available, and supports manual accounts and CSV imports everywhere else, so the forecast reflects your genuine balances, refreshed daily. It reads your accounts to show you the picture. It never holds or moves your money.

If you want to see your own balances projected forward in worst, expected and best case, you can try it for yourself. Endute does the forecasting inside its plan view, part of a complete personal finance app rather than a standalone calculator, and there is a 37-day free trial with no card required. It takes a few minutes to connect or add an account, and the forecast builds itself from there.

See the Dip Before You Reach It

A cash flow forecast turns I think I am fine into I can see I am fine until the 28th, and a little tight after that. It is the difference between hoping and knowing. The mechanics are simple enough to run on the back of an envelope: opening balance, money in, money out, rolled forward by date. The discipline is the hard part, which is exactly why most people who try the spreadsheet route give it up inside a month.

Whichever way you do it, by hand or with an app that keeps it current for you, the goal never changes. See the dip before you reach it. Then you have got time, and options, instead of a declined card and a fee.

Cash Flow Forecast FAQs

What is a cash flow forecast?

A cash flow forecast is an estimate of the money coming in and going out over a future period, used to project what your balance will be at each point in time. It turns today's single balance into a forward view, so you can see shortfalls and surpluses before they arrive rather than after.

What is the difference between a cash flow forecast and a cash flow statement?

A forecast looks forward and a statement looks back. The forecast estimates money you expect to move in the coming weeks or months so you can plan. The cash flow statement is a record of money that has already moved, usually compiled after the fact for accounts or tax. One is a plan, the other is history.

How do you make a cash flow forecast?

Start with your current balance, list your expected income by the date it arrives, list your expected outgoings by the date they leave (including annual and irregular costs), then roll the balance forward. Opening balance plus income minus outgoings gives the closing balance, which becomes the next period's opening balance. Repeat to the end of your chosen horizon.

What is a personal cash flow forecast?

It is the same idea applied to your own money rather than a business. You project your future bank balance from your salary, bills, subscriptions and one-off costs, so you can answer practical questions like whether you will go overdrawn before payday, or whether you can afford a purchase before an annual bill lands.

How far ahead can you forecast cash flow?

Commonly one to twelve months. A month is the minimum useful horizon, and three to six months catches most irregular costs like insurance renewals. Accuracy falls the further out you go, because more of the numbers become estimates rather than known commitments, which is why many people keep a short, rolling forecast rather than one long projection.

Why use best, worst and expected scenarios?

Because income and spending vary, and a single projected line implies a precision the future does not have. Running three scenarios shows the range: the worst case is your stress test, the expected case is what you plan against, and the best case shows your upside. The gap between them tells you how much of a buffer is worth holding.

This article is for educational purposes only and does not constitute financial advice.