Building Your First Cash Flow Forecast: Step-by-Step

Cash flow is the lifeblood of every small business, but too many owners rely on gut instinct instead of hard numbers. A solid cash flow forecast helps you sleep at night, spot trouble early, and make smarter decisions. This guide walks you through building your first cash flow forecast from scratch—explaining the 'why' as well as the 'how', using UK-specific figures, pitfalls to avoid, and tips you won’t hear from your accountant.

Cash flow is about timing: when money actually enters and leaves your business bank account. Even profitable firms can run aground if they can't pay bills on time. In the UK, late payments are a chronic issue—FSB research shows that 50,000 small businesses fold each year due to cash flow problems caused by late payers. This makes robust cash flow forecasting not just a best practice, but a survival skill.

A cash flow forecast gives you a forward-looking view of how much cash you’ll have on hand, week by week or month by month. This helps you plan investments, avoid nasty surprises, and negotiate with suppliers or lenders from a position of strength. Lenders—including the British Business Bank and high street banks—often require cash flow forecasts as part of funding applications or loan renewals.

For VAT-registered businesses, cash flow forecasting also helps ensure you set aside enough to cover quarterly VAT bills, PAYE, and annual Corporation Tax. It can also highlight when you’ll need to raise invoices earlier, chase debtors, or potentially negotiate payment terms with suppliers. The earlier you spot a cash shortfall, the more options you have.

• Helps you spot cash gaps before they become crises
• Improves your negotiating position with banks and suppliers
• Ensures you can cover VAT, PAYE, and tax liabilities on time
• Supports investment decisions and business growth
• Enables you to plan for seasonality and one-off expenses

A cash flow forecast is not the same as a profit and loss (P&L) statement. The P&L shows when sales are made and costs incurred, regardless of when money changes hands. Cash flow is all about actual receipts and payments. This difference is crucial, especially in the UK where invoicing terms, VAT, and tax deadlines can create timing gaps.

Start by separating your forecast into two main sections: cash inflows and cash outflows. Inflows include customer payments, grants, loans, and any other money entering your account. Outflows cover staff wages, supplier payments, rent, rates, tax, loan repayments, and other expenses. Always focus on when cash physically moves—not when you raise or receive an invoice.

For many UK businesses, the biggest forecasting headache is the timing of customer payments. Clients might pay on 30, 60, or even 90-day terms, and late payment is common. Build in realistic payment timings based on your history—don’t assume every customer will pay on time. For outgoings, factor in regular bills (like rent or utilities), staff costs (including employer’s NI and pension), and less frequent costs such as annual insurance or tax bills.

Decide whether to forecast weekly or monthly. If your business has rapid turnover, tight margins, or cash crunches, a weekly forecast is essential. For most established businesses, a monthly forecast is adequate. Cover at least the next 12 months—but if you’re just starting out, even a 3–6 month forecast is valuable.

Most UK small businesses use a spreadsheet for their first forecast. You can start with a free template (see GOV.UK’s business planning tools or resources from the British Business Bank), or build your own. Cloud accounting software (like Xero, QuickBooks, or FreeAgent) increasingly offer built-in cash flow tools, but understanding the manual process first is crucial for accuracy.

Structure your spreadsheet with columns for each week or month, and rows for each cash inflow and outflow category. You’ll also want a row for your opening bank balance and a running total of your cash position. This helps you see not just net cash flow each period, but your projected bank balance at any point in time.

• Weekly forecasts suit businesses with frequent transactions or tight liquidity
• Monthly forecasts are often enough for stable, established firms
• Always project at least one quarter past your next major tax or VAT deadline
• Include a running cash balance to spot negative dips
• Use colour-coding to highlight risk periods

You can’t build a useful forecast from thin air. The more accurate your starting data, the more reliable your forecast will be. Gather bank statements for at least the past 6–12 months to spot cash flow patterns. Download your sales ledger to see average payment times, and review supplier invoices to understand when payments leave your account.

Check direct debit and standing order schedules so you don’t overlook regular outgoings. For upcoming VAT, PAYE, or Corporation Tax, look at previous returns and confirm deadlines on GOV.UK. If you’re a seasonal business (e.g., hospitality, retail, construction), use last year’s data as a baseline, adjusting for known changes. Don’t forget one-off costs like insurance renewals, annual subscriptions, or equipment purchases.

If you’re a start-up with no trading history, base your assumptions on industry benchmarks—these are available from trade bodies, accountants, and the Office for National Statistics (ONS). Speak to suppliers about likely payment terms, and research local rent, rates, and wage costs. Overestimate expenses and underestimate income to err on the side of caution.

• Use your last 12 months' bank data to identify seasonal peaks and troughs
• Review average debtor days (how long, on average, customers take to pay)
• Check your HMRC online account for upcoming tax bills
• Speak to your accountant about any upcoming regulatory or tax changes

Now you’ve got your data, it’s time to build your first cash flow forecast. This process is more art than science at first—don’t expect perfection. The key is to be realistic, not optimistic, and to update your forecast regularly as new information comes in.

Start with your opening bank balance for the forecast period. Then, for each week or month, estimate your expected cash inflows—when you realistically expect to receive customer payments, loan drawdowns, or grants. Next, list all outgoings in the period, including salaries, supplier payments, rent, utilities, and tax bills. Subtract total outgoings from inflows to find your net cash flow for the period, and add this to your opening balance to get your closing position.

Repeat this process for each period in your forecast, rolling forward the closing balance as the next period’s opening balance. This running total is your early-warning system for cash shortfalls. If your forecast shows a negative balance, don’t panic—use this insight to plan remedial action, such as speeding up collections, delaying non-essential spend, or arranging an overdraft in advance.

A cash flow forecast is only as good as the assumptions behind it. One of the biggest mistakes UK small businesses make is assuming all customers will pay on time. In reality, late payment is endemic—so build in realistic lags based on historic data, or at least add a buffer for overdue payments.

Another common error is forgetting irregular or annual costs—insurance renewals, accounting fees, business rates, or equipment purchases. These can create nasty surprises if not factored in. Similarly, many businesses underestimate their true tax and VAT liabilities. Always check your last few returns and let your accountant review your forecast if possible.

Don’t forget to update your forecast regularly—at least monthly, or weekly if you’re in a tight spot. A forecast is a living tool, not a one-off task. Update it as actual figures come in and adjust future periods accordingly. If your assumptions change (e.g., you win a big contract, lose a key customer, or face a rent hike), revise your forecast straight away.

• Assuming 100% of customers pay on time—always allow for late payments
• Forgetting to include annual or quarterly bills (insurance, rates, tax)
• Mixing up cash flow with profit—only count cash moving in or out
• Failing to update the forecast regularly as real figures come in
• Not factoring in VAT on sales and purchases

No forecast survives first contact with reality. UK businesses face unpredictable events: customers delay payment, energy bills spike, or projects fall through. That’s why it’s vital to stress-test your cash flow forecast by running different scenarios. What if a key customer pays 30 days late? What if your biggest expense jumps by 20%? These 'what ifs' help you prepare a contingency plan.

Create at least two alternative forecasts: a worst-case scenario (delayed income, higher outgoings) and a best-case scenario (early payments, lower costs). This helps you understand your risk exposure and set realistic minimum bank balance targets. If your worst-case forecast shows a cash gap, take early action: speak to your bank about overdraft facilities, negotiate supplier terms, or plan to cut discretionary spending.

If you’re applying for funding, lenders will often want to see a 'sensitivity analysis'—showing how your cash flow would cope with a drop in sales or a spike in costs. Be honest with yourself: stress-testing isn’t about scaring yourself, but about making sure you have options if things go wrong. The earlier you spot a potential cash crisis, the more choices you have to fix it.

• Model what happens if key clients pay 30–60 days late
• Test your forecast with a 10–20% drop in income
• Factor in emergency costs—equipment breakdowns, legal fees
• Calculate the impact of a sudden tax or VAT bill
• Set a 'trigger point' for action if your bank balance drops below a safe level

A cash flow forecast is not a set-and-forget document. It’s a living tool that should shape your day-to-day decisions. Set time in your diary—ideally every week—to update your forecast with actual income and outgoings, and to check for emerging cash gaps or surpluses. This discipline is especially critical before making major spending commitments or taking on new staff.

Use your forecast to drive practical action: chase overdue invoices early, delay discretionary spend if a shortfall looms, or negotiate better payment terms with suppliers. If your business is growing, monitor how increased sales might mean more cash tied up in stock or debtor days. If you hit a cash crunch, approach your bank before you breach your overdraft—lenders are more supportive when you demonstrate forward planning.

Finally, keep your accountant or business adviser in the loop. Many UK accountants offer free or low-cost cash flow review sessions, and can help you spot tax traps or regulatory deadlines you might have missed. Sharing your forecast with your team also helps everyone understand business priorities and support prudent financial management.

Building your first cash flow forecast is just the beginning. Once you’re comfortable with the basics, consider upgrading to a more automated tool—cloud accounting software like Xero, QuickBooks, or FreeAgent now offer cash flow modules that sync with your bank feed. The British Business Bank and Federation of Small Businesses both offer free guides and templates tailored for UK SMEs.

For more complex businesses, or if you’re seeking funding, work with your accountant to refine your forecast and integrate it with your business plan. If you routinely face cash crunches, consider training in credit control, invoice finance, or supply chain management. Many local Growth Hubs and LEPs offer free workshops for small businesses on topics like cash flow, funding, and financial management.

Don’t be afraid to ask for help. Cash flow forecasting isn’t just for number-crunchers—it's an essential skill for every business owner. The sooner you start, the better your decisions will be.