Blog

Personal Finance Cash Flow Forecast: 90 Days Ahead

By , Founder of Thrifty Owl

← All posts

Key takeaways

A personal finance cash flow forecast projects your household's weekly inflows and outflows up to 90 days ahead, so you know what's left to spend after every recurring and annual bill has been paid. This guide walks you through building one step by step, with a fully worked forecast table, a recurring-bill calendar, and a method for handling irregular income.

What is a personal finance cash flow forecast and how does it differ from a budget?

A personal finance cash flow forecast is a date-based projection of every pound moving in and out of your household accounts over a set period, typically 90 days. A budget tells you how much you may spend in each category this month; a forecast tells you which days your balance dips and which bills land when.

A budget sets limits; a forecast predicts dates

Budget categories answer "how much is left to spend on groceries?" A forecast answers "if the car tax and the TV licence both debit before payday, do we stay above zero?" Those lumpy annual bills are easy to forget: the TV licence currently costs £174.50 a year (TV Licensing), and car tax adds a three-figure debit for most petrol cars.

Why the distinction matters for households

If you manage several accounts and a shared budget, category limits alone can hide a shortfall that is weeks away. A forecast surfaces it early enough to act, which is the gap Thrifty Owl's pricing and cash flow view are built to close.

How far ahead should a household cash flow forecast look?

Ninety days. That is long enough to catch the next quarterly or annual bill, and short enough that your estimates stay grounded in real dates rather than guesswork. A 12-month forecast of weekly spending drifts badly; a 90-day one you can check against actual statements every week.

Why 90 days beats 12 months for accuracy

The further out you project, the more every small error compounds. Within 90 days, most of your numbers are known: pay dates, direct debits, the council tax instalment due in six weeks. Beyond that, you are guessing, and guesses erode confidence in the whole forecast. If you have ever abandoned a budgeting tool because the projections stopped matching reality, this is usually why.

When to extend the horizon

Keep a separate annual list of lumpy bills (insurance renewal, car service, holidays) and pull each item into the 90-day forecast as it enters the window. That gives you the long view without pretending you can predict week 40. Thrifty Owl's "left to spend" view works the same way: known bills and budgets in view, everything else left to budget (Thrifty Owl).

Which recurring and annual bills must go into a 90-day forecast?

A 90-day forecast only works if every recurring outflow sits in it. Miss one lumpy annual bill and the week it lands looks like a crisis that never existed.

Fixed monthly outflows

Start with anything identical or near-identical each month: mortgage or rent, council tax, utilities on fixed direct debit, broadband, phone, subscriptions, insurance premiums paid monthly. Enter each with its amount, payment date and account, so the forecast subtracts it from the right balance on the right week.

Lumpy annual bills and how to spread them

Convert annuals into weekly amounts by dividing the total by 52 and setting it aside weekly, or by reserving the full amount in the week it falls due. Typical items:

Bill Typical cycle How to enter it
Car insurance Annual Full amount in due week
Car tax and MOT Annual Full amount in due week
TV licence Annual £169.50/52 weekly, or in week due
Holidays Ad hoc Reserve weekly from booking date

Check each figure against your last statement rather than guessing.

Building the recurring-bill calendar

List every bill with its date and amount, then walk it forward 13 weeks. Tools like Actual Budget or CountAbout handle scheduled transactions, and Thrifty Owl builds this calendar in from your recurring bills (features). The point is trust: apps that vanish mid-system leave you stranded, as Mint users found when Intuit shut it down in early 2024.

How do you forecast cash flow when your income is irregular?

Use your lowest reliable month as the baseline

If your income varies, forecast the inflow side using the worst month you would still call normal, not an average. If you earned £2,900, £3,400 and £1,900 over the last three months, budget against £1,900. Every outflow in your 90-day forecast then stays covered even in a lean month, and anything above the baseline is a bonus rather than something you have already spent.

The smoothing reserve method

Open a separate savings account and, in good months, sweep the surplus above your baseline into it. In lean months, you draw the shortfall back out. Your forecast then shows a flat, predictable income line, which makes the left-to-spend figure stable from week to week. Size the reserve at one full baseline month to start; two is more comfortable for the self-employed.

What to do with windfalls

Treat anything outside your normal range (a bonus, a tax refund, an inheritance) as unplanned inflow. Never let it lift your baseline. Assign it deliberately: top up the smoothing reserve first, then clear the next lumpy annual bill in your forecast. If you want the reasoning behind baseline-and-reserve planning written out in full, we keep a longer treatment of it in our white papers.

What does a completed weekly cash flow forecast actually look like?

The 13-week worked example

Take a household with £2,400 in the current account, a monthly salary of £2,800 paid on the 28th, and a council tax instalment of £145 every month. Your forecast is a table with one row per week for 13 weeks: opening balance, inflows, outflows, closing balance. The outflows column is where the work lives, because every recurring bill and budget category gets scheduled into the week it falls due rather than averaged across the month.

Weeks 1 to 4 look comfortable: salary in, £145 council tax and roughly £180 of groceries and utilities out, closing balances of £2,875, £2,530, £2,185 and £2,840 as the salary lands again. Week 5 is the lumpy one. The car insurance renewal of £412 and the annual boiler service of £90 both fall in the same week, so outflows hit £647 and the closing balance drops to £2,193. Weeks 6 and 7 recover to £2,548 and £2,903. The forecast's job is to show you week 5 in week 1, while there is still time to move £200 from savings or shift the renewal date. That single lumpy week is the whole reason the forecast exists: a monthly budget would have shown a comfortable surplus and hidden the dip entirely.

This is the same principle behind scheduled transactions in tools like YNAB, though a spreadsheet handles it fine.

Reading the forecast: spotting the dip before it happens

Scan the closing balance column, not the rows. Any week where the balance dips below your buffer, say £1,000, is a warning to act on three weeks early. If your categories and split transactions matter to you the way they did in Microsoft Money, our guide to choosing a budgeting app covers what to check before committing.

How do you update your forecast when actual spending differs?

A forecast is only useful if it meets reality once a week. The routine is simple: compare what you predicted against what actually cleared, then adjust the remaining weeks before the drift compounds.

The 15-minute weekly review

Pick one day, sit down, and go through three numbers: what you forecast for the week, what actually left your accounts, and what is left to spend in each category. Update your opening balance for next week with the real figure. If groceries came in £30 over, that £30 comes out of a future week, not from hope.

Reconciling against bank statements

Check every transaction against your statement, the same way you did in Microsoft Money. This catches card refunds, duplicate charges, and direct debits that moved date. If you split transactions, reconcile each split so your budget categories stay honest.

When to reforecast from scratch

Small drift gets patched week by week. But if a big change lands, a bill moving by months, a shift in income, a new recurring commitment, rebuild the 90-day forecast from your current balances rather than editing twelve weeks of guesses.

What early warning signs does a cash flow forecast reveal before a budget does?

A budget tells you whether the month balanced. A forecast tells you which specific week breaks first. Three patterns are worth watching every time you update the numbers.

Three warning patterns to watch for

First, the low-balance week: one week where the projected closing balance dips near or below zero, often four to six weeks out, invisible in a monthly budget. Second, the bill pile-up: three or four annual or quarterly bills landing in the same fortnight, such as car insurance, the water bill and a school trip. Third, creeping overdraft risk: a forecast that never goes negative but sits within a few pounds of it for consecutive weeks, leaving no room for a bill arriving a day early.

What to do when you spot one

Shift a payment date, move money from a savings pot, or trim a discretionary category that week. If you track every penny down to split transactions, a forecast gives you the confidence to stop micromanaging and act only when a warning appears, which is what many households report after switching from envelope tracking.

Can you build this in a spreadsheet, and when should you move to a tool?

Spreadsheet pros and cons

A spreadsheet handles a 90-day forecast well: you control every formula, split transactions however you like, and keep 20 years of history on your own machine. The cost is upkeep. Every update is manual, formulas break quietly, and nothing reconciles itself against statements, so the forecast drifts from reality within weeks unless you are disciplined.

Comparing tools honestly, including Thrifty Owl

Judge any tool on four criteria: it imports your history, handles split transactions and budget categories, reconciles against statements, and shows what is left to spend after each bill. YNAB, CountAbout, Actual Budget and Monarch Money all score differently on those, and each publishes its own details at ynab.com, countabout.com, actualbudget.com and monarchmoney.com.

Thrifty Owl was built for exactly this: recurring bills, a household shared budget, and a running left-to-spend figure. Where it falls short: if you want envelope-style zero-based budgeting, YNAB or Actual Budget do that better, and Thrifty Owl does not replace deep investment tracking.

FAQ

What's the difference between a cash flow forecast and a budget in plain terms?

A budget caps spending by category each month. A forecast maps dates: it shows which week your balance drops when the insurance renewal and the boiler service land before payday. Use the budget to decide limits, and the forecast to see whether the money actually clears in the right order across the next 13 weeks.

Do I need to forecast my credit card spending separately from my current account?

Yes, if you clear the card in full. Forecast the card's balance for daily spending, then schedule the repayment as an outflow from the current account on the direct debit date. If you carry a balance instead, treat the minimum payment as a recurring bill and add interest where you can estimate it.

How much should I keep as a buffer before a forecast says I'm safe?

Set a buffer that covers your worst week plus one lumpy bill. In the worked example, £1,000 was the line: any week projected below it triggered action three weeks early. Check your own history for the largest single debit you have had, size the buffer above it, and treat consecutive weeks near that figure as a warning.

Can a cash flow forecast work for a couple budgeting together?

It suits couples well, because it forces shared visibility of dates rather than arguments over category limits. List both salaries, every joint bill, and each account the bills leave from, then agree a single buffer figure. A shared tool showing one left-to-spend number after each bill beats merging spreadsheets by hand.