Cash flow forecasting for planning income and spending

Cash flow forecasting estimates when money will enter and leave a business, and what balance will remain. For small and medium-sized organisations that aren’t in immediate financial difficulty, updating the forecast monthly and looking 12 months ahead is considered reasonable. Newer businesses with limited financial history should expect estimates further into the future to be less accurate.

It’s understandable to focus on whether your business is profitable, but the timing of receipts and payments matters too. A profitable business can still face a cash squeeze if money arrives after bills are due.

This article explains how cash flow forecasting works, how to estimate incoming and outgoing money, and when to revise a forecast. Regular updates turn changing sales, costs and payment dates into a clearer picture of the cash available for day-to-day decisions.

What is a cash flow forecast?

A cash flow forecast estimates when money will enter and leave a business, then projects the cash balance across future periods. It tracks expected receipts and payments by their timing, helping a Stockport business see whether funds should be available when bills fall due. Unlike a profit figure, the projected balance reflects when cash moves through the bank account.

Choose a forecasting period that matches the decisions you need to make and the business’s cash flow cycle. Short-term forecasts support daily planning or cover up to a month. Medium-term forecasts usually cover 2 to 6 months, while long-term forecasts cover 6 to 12 months. A business with seasonal sales may need a longer view to include quieter trading periods and the costs that continue during them.

The further ahead a forecast looks, the more assumptions it relies on. For a new business with little historical data, estimates are likely to become less accurate over time. Keep the detail strongest in the near term, where invoice dates, payroll and supplier payments are clearer. Use broader estimates further out, then refine them as new sales and cost information comes in.

A rolling forecast keeps its chosen horizon moving forward. For example, if a business reviews a rolling 12-month forecast monthly, it adds a new month as the current month passes. This keeps the forward view consistent instead of allowing the forecast to shrink. A spreadsheet can recalculate projected balances when receipts or payments change, making revised assumptions easier to see.

A budget sets planned income and spending for a period, while a cash flow forecast estimates when those amounts will actually be received or paid. For example, a sale may appear in a monthly budget but enter the forecast when the customer is expected to pay. This timing difference can reveal a short-term cash gap, even when planned income exceeds spending.

Common errors include recording sales before customers are expected to pay, overlooking irregular costs, and leaving outdated estimates unchanged. Improve accuracy by using realistic payment dates, including known commitments, and revising assumptions when new information arrives. For small businesses, cash planning for small businesses can help connect the forecast to everyday decisions.

If the forecast shows a shortfall, identify the dates and payments creating the gap. Then consider whether spending can be moved or receipts collected sooner. Check the effect of each change on later periods so a short-term fix doesn’t create another cash squeeze. Regular cash flow forecasting makes this forward view part of ongoing business planning.

Forecast objectives and business planning

A forecast is most useful when it answers a specific planning question. Define the decision first, then choose the information and time horizon needed to assess it.

Setting forecast objectives

A forecast objective is the business decision that the projected cash position should inform. It might show whether funds can cover everyday commitments, support a planned purchase or flag a possible shortfall early. The forecast should cover at least one complete cash flow cycle, from money leaving the business to its return through customer payments. This keeps the forecast relevant to actual trading.

Building a spreadsheet forecast

A spreadsheet forecast organises expected receipts and payments by period, then calculates the projected cash balance. A common small-business spreadsheet covers at least 90 days, giving the owner a practical view of near-term commitments. Set out opening balances, expected receipts, payments and closing balances in separate rows. Use formulas to carry each closing balance into the next period and recalculate totals when an assumption changes.

Useful records include current bank balances, sales invoices, customer payment dates, supplier bills, payroll information and loan schedules. A spreadsheet can compare expected figures with actual receipts and payments, helping you refine later estimates. For example, if a customer regularly pays after the invoice due date, update the expected receipt period instead of relying on the original date.

Listing business outgoings

List each expected outgoing in the period when payment is due. Include rent, salaries, raw materials, asset purchases, bank loans, fees and charges, marketing and advertising, and tax bills. Separate regular commitments from one-off costs, such as equipment, so their different effects are clear. Check invoices, payment schedules and payroll records to avoid overlooking costs or counting them twice.

Timing matters as much as category. A supplier invoice due this month belongs in this month’s cash forecast, even if the materials support later sales. This helps you see whether a planned purchase coincides with other commitments.

Preparing the forecast step by step

To prepare a forecast, start with the opening bank balance, list expected receipts and payments by date, then calculate each period’s closing balance. Carry that balance forward and compare it with upcoming commitments. This makes the cash position visible throughout the planning period, rather than relying on a single income or spending total.

Cash flow planning can cover a few weeks to many months, depending on the decision and trading cycle. Review the forecast alongside actual bank activity, sales information and bills, then revise assumptions when dates or amounts change. If you’d like support applying these steps to your business, discuss your forecasting needs.

Assumptions about when money arrives and is spent

A forecast is more accurate when receipts and payments are assigned to the periods when cash is expected to move. This is especially useful when customer payments, supplier bills or sales vary throughout the year.

Timing income and expenditure assumptions

Timing assumptions estimate when each receipt will reach the business and when each payment will leave its bank account. They matter because a sale or bill date may differ from the date cash moves. Record sales income in the period when payment is expected to reach the bank, not automatically when an invoice is issued.

Use invoice terms, previous payment behaviour and agreed dates to estimate customer receipts. For example, if a customer usually pays after the invoice due date, forecast the receipt later. For spending, use supplier terms, payroll records and scheduled payments. If income is irregular, don’t assume receipts arrive evenly every month.

Compare each assumption with actual bank activity. If customers regularly pay later than expected, adjust the timing in future periods. If a supplier changes its payment date, update the relevant outflow. This helps distinguish a one-off delay from a pattern that should be reflected in the forecast.

Allowing for tax payments and seasonal changes

Tax and seasonal assumptions place expected liabilities and trading changes in the periods when they may affect cash. This helps a UK business account for tax payments and avoid assuming that busy-season receipts arrive evenly throughout the year.

Include expected VAT, Corporation Tax and PAYE payments using the business’s records and anticipated payment dates. Forecast the amounts expected to be paid, rather than treating tax liabilities as ordinary customer or supplier activity. Update estimates when accounting information changes so the projected cash position reflects current figures.

Seasonal changes need similar care. A Stockport retailer expecting stronger Christmas sales should account for when customer receipts arrive, alongside stock purchases, wages and other costs. Higher sales don’t necessarily mean cash arrives before related payments are due. A quieter trading period may also reduce receipts while rent and other regular commitments continue.

Use previous trading patterns where they remain relevant, then adjust for known changes such as altered opening plans, new contracts or supplier arrangements. A business without useful historical records can base assumptions on confirmed orders and current payment terms, then revise them as evidence builds. For uncertain receipts, avoid relying on an optimistic date; for planned spending, include the expected payment period. Reviewing seasonal assumptions alongside tax estimates makes emerging cash pressure easier to identify and assess.

Calculating net income and net outgoings

For each forecast period, total expected cash income and outgoings separately. Subtract outgoings from income to find the period’s net cash flow, then add that result to the previous period’s closing balance. This running total shows how expected cash changes over time, rather than treating income or spending as one overall figure.

Start with money expected to enter the business, using the period when each receipt should arrive. Sales are one source, but a forecast can also include tax refunds, grants, investment from an owner or shareholder, and royalties or licence fees. Keep these sources identifiable. If a grant is expected in a different period from a customer payment, record each separately against its expected timing.

Next, list expected payments in the periods when cash should leave the business. Outgoings may include rent, salaries, raw materials, assets, bank loans, fees and charges, marketing and advertising, and tax bills. Grouping similar costs can make totals easier to review, while keeping different types visible helps explain changes. For example, separating asset purchases from regular rent shows which outflow is a one-off commitment.

Apply the same calculation to every period: net cash flow is net income minus net outgoings. If expected receipts exceed payments, the period adds cash; if payments are higher, it reduces the balance. Carry the closing balance forward as the next period’s opening balance. A spreadsheet can recalculate automatically when figures change, reducing repetitive arithmetic and showing revised totals.

Check entries before relying on the running total. Compare customer receipts with invoices and expected payment dates, then check outgoings against supplier bills, payroll records and loan schedules. Make sure each receipt or payment appears only once in the relevant period. If an invoice is entered as an expected receipt, don’t enter the same bank payment again under another income heading.

Trace unusual movements to their source. A large asset purchase, grant receipt or tax refund can change one period’s result without representing a regular pattern. Keeping these items distinct helps explain why the balance changes and whether the movement is likely to recur. For a Stockport business, a clear calculation helps compare projected cash with upcoming commitments and adjust plans when assumptions change.

For each period, calculate cash flow by subtracting net outgoings from net income, then carry the result into a running total. Read that total alongside the opening balance to see whether the forecast is building cash or drawing it down. If the projected position shifts, revisit the income and outgoings assigned to that period and check that the timing is consistent. This ties the calculation to expected cash movements, not a broad overall estimate. Each period’s contribution to the continuing total should be clear, so changes make sense in context.

How often to update a cash flow forecast

Update a forecast when circumstances change or estimates become more precise. The right review rhythm depends on how quickly receipts, costs and payment dates shift. A stable trading pattern may need fewer revisions than a business facing delayed customer payments or changing orders. The aim is to keep the projected balance useful for decisions, rather than letting old assumptions shape current plans.

For small and medium-sized organisations not in immediate financial difficulty, monthly updates and a rolling 12-month view are considered reasonable. Each month, compare actual cash movements with the previous forecast, revise upcoming receipts and payments, then add a new month at the end. This keeps the forward-looking period consistent and shows whether expected changes affect later plans as well as immediate cash availability.

Use new information to refine estimates between scheduled reviews. A customer changing payment dates, a supplier revising terms or a shift in expected sales can affect cash timing. Update the relevant entries when changes arise and record why an assumption changed. This helps distinguish a temporary difference from a pattern that should influence future periods.

At each monthly review, compare forecast figures with actual bank activity and investigate significant differences. If a receipt arrived later than expected, adjust the next estimate using the latest payment information. If spending has changed, update the relevant outgoings and recalculate the balance. A spreadsheet that recalculates automatically can show how each revision affects the periods ahead.

Pay closer attention when cash pressure increases. A business close to insolvency may need daily forecasting, because a missed receipt or unexpected payment can quickly change the available balance. Daily reviews help identify the dates creating pressure and provide current information about receipts, payments and immediate commitments.

Charities have an additional reason to review balances carefully: check forecast bank balances at each month-end and consider setting a minimum balance for unrestricted funds. Track restricted funding separately because it cannot be used for unrestricted purposes. Keeping these balances distinct helps prevent a headline cash total from obscuring which funds are available for general spending.

Make the review frequency part of the business routine. A monthly meeting can cover actual results, revised assumptions and the rolling 12-month view, with updates sooner when trading or payment conditions change. If cash pressure is increasing or regular reviews are difficult to maintain, discuss your forecasting needs with an accountant.

Coombs Chartered Accountants: Statutory Accounts Preparation

Coombs Chartered Accountants prepares statutory accounts and provides cash flow forecasting to help businesses understand their financial position and plan ahead. Turn to the firm when you need support assessing expected receipts and payments, or when changing trading conditions make forward planning harder. Management Accounts can help you review performance, while Tax Compliance and Tax Planning support related financial decisions.

Cash flow forecasting brings projected movements into view alongside your accounting records. Coombs Chartered Accountants can help make your forecast relevant to business decisions. Contact the firm to discuss accounting support tailored to your needs.

Make your next business decision with greater clarity

A forecast can do more than flag a cash gap. Use it when weighing a new commitment, changing payment arrangements or deciding whether planned spending still fits your priorities. Reviewing these choices against current figures connects day-to-day decisions with your business’s financial position.

Consistent cash flow forecasting works best alongside accurate accounting records. Coombs Chartered Accountants offers Statutory Accounts Preparation, Tax Compliance and Tax Planning to support businesses with connected financial and tax needs.

If you’d like to discuss how forecasting could support your business decisions, contact Coombs Chartered Accountants. A clearer view of the figures can help you plan your next steps with confidence.

Frequently Asked Questions

What is cash flow forecasting and why is it important for UK businesses?

Cash flow forecasting estimates future cash receipts and payments so a business can plan for available funds. It helps owners assess whether the timing of cash movements supports a decision, such as taking on a new contract or committing to equipment. For a UK business, the forecast can also account for expected tax payments rather than treating them as an afterthought. Its value is in informing decisions before cash pressure becomes immediate.

How can a business forecast cash inflows and outflows accurately?

Build estimates from records that reflect actual trading, such as customer invoices, order information, supplier statements and payroll records. Separate confirmed receipts from less certain opportunities so the projected balance doesn’t rely on sales that may not proceed. Compare previous estimates with actual bank activity and investigate differences. For example, repeated late customer payments may mean future receipts need a more cautious timing assumption.

How far ahead should a business forecast cash flow, and how often should it update the forecast?

Choose a horizon that covers at least the business’s cash flow cycle, then extend it to suit upcoming decisions. A monthly review with a rolling 12-month outlook is reasonable for small and medium-sized organisations not in immediate financial difficulty. Shorten the review interval if cash pressure rises; a business close to insolvency may need daily forecasting. The forecast’s usefulness depends on keeping future periods aligned with current trading conditions.

Which cash flow forecasting methods and templates are best for small businesses?

The suitable method depends on the planning horizon. Direct receipts-and-disbursements forecasting suits short-term planning over 30 days, while accrual reversal is suited to medium-term forecasting. Adjusted net income and pro-forma balance sheet methods can support medium-term forecasts up to one year and long-term forecasts spanning multiple years, using monthly or quarterly intervals. A small-business spreadsheet should make assumptions visible and recalculate balances when figures change.